date_trunc('year', block_timestamp) as date, PLATFORM,

count(distinct tx_hash) as swaps,

count(distinct SENDER) as wallets,

sum(AMOUNT_IN_USD) as usd_vol,

avg(AMOUNT_IN_USD) as avg_usd_vol,

sum(usd_vol) over (partition by PLATFORM order by date) as cumu_vol,

sum(swaps) over (partition by PLATFORM order by date) as cumu_swaps

from ethereum.core.ez_dex_swaps

where date(block_timestamp) >= '2020-01-01'

and AMOUNT_IN_USD < 1e8

group by date, PLATFORM