BLOCK_TIMESTAMP::date as day,

count(distinct trader) as swapper,

count(distinct tx_id) as no_swaps,

sum(swapper) over (order by day) as cum_swappers,

sum(no_swaps) over (order by day) as cum_swaps

from osmosis.core.fact_swaps where POOL_IDS[0]=722

and TX_STATUS='SUCCEEDED'

and BLOCK_TIMESTAMP>=CURRENT_DATE-7

group by 1

order by 1