date_trunc('month',block_timestamp) as month,

sum(AMOUNT_OUT) as stNEAR_VOL,

sum(stNEAR_VOL) over (order by month asc rows between unbounded preceding and current row) as cum_NEAR_staked,

count(distinct(POOL_ID)) as dif_TOKEN_IN,

count(distinct(platform)) as platform,

count(distinct(trader)) as n_traders,

sum(n_traders) over (order by month asc rows between unbounded preceding and current row) as cum_n_traders,

count(distinct(tx_hash)) as n_deposits,

sum(n_deposits) over (order by month asc rows between unbounded preceding and current row) as cum_n_deposits,

avg(AMOUNT_OUT) as avg_stake_size,

max(AMOUNT_OUT) as max_NEAR_deposit,

min(AMOUNT_OUT) as min_NEAR_deposit,

median(AMOUNT_OUT) as median_NEAR_deposit

from near.core.ez_dex_swaps

where TOKEN_OUT = 'STNEAR'

group by 1