PLATFORM,

origin_from_address,

count(DISTINCT(tx_hash)) as total_swaps,

sum(AMOUNT_IN_USD) as volume

from ethereum.core.ez_dex_swaps

where amount_in_usd < 1000000

group by 1,2,3)

select weekly,

PLATFORM,

count(DISTINCT(origin_from_address)) as total_user,

sum(total_swaps) as total_swap,

sum(volume) as total_volume,

avg(volume) as volume_per_user,

avg(total_swaps) as avg_swaps,

sum(total_volume) over (partition by PLATFORM order by weekly asc) as cum_volume,

sum(total_swap) over (partition by platform order by weekly asc) as cum_swaps

from swaps

where weekly >= '2022-01-01'

group by 1,2

order by 1