date_trunc('month', block_timestamp) as date,

count(DISTINCT trader) as user_count,

count(DISTINCT tx_hash) as tx_count,

sum(amount_in_usd) as total_vol,

avg(amount_in_usd) as avg_tx_vol,

min(amount_in_usd) as min_tx_vol,

max(amount_in_usd) as max_tx_vol,

median(amount_in_usd) as median_tx_vol,

from

near.defi.ez_dex_swaps

where

date between '2024-01-01' and '2024-12-31' and

platform = 'v2.ref-finance.near'

group by

date

order by

date asc