select

BLOCK_TIMESTAMP::date as date,

b.symbol,

count(distinct tx_id) as swap_numbers,

sum(swap_numbers) over (order by date) as cum_swap_numbers,

sum(a.TOKEN_IN_AMOUNT*b.price) as USD_volume,

sum(usd_volume) over (order by date) as cum_USD_volume

from flow.core.ez_swaps a

join token_price b

on a.TOKEN_IN_CONTRACT=b.TOKEN_CONTRACT and a.BLOCK_TIMESTAMP::date=b.date

where date>='2021-03-18'

group by 1,2,b.date