select

date_trunc(week, block_timestamp) as date ,

PLATFORM,

count(DISTINCT origin_from_address) as swappers,

count(distinct tx_hash) as swaps,

sum(AMOUNT_IN_USD) as volume_usd,

avg(AMOUNT_IN_USD) as AVG_volume_usd,

max (AMOUNT_IN_USD) as Maximum_volume_usd,

sum(volume_usd) over (partition by PLATFORM order by date rows between unbounded preceding and current row) as cum_volume,

sum(swaps) over (partition by platform order by date rows between unbounded preceding and current row) as cum_swaps_TX

from ethereum.core.ez_dex_swaps

where block_timestamp >= '2022-01-01' and AMOUNT_IN_USD < 1e6

group by 1,2