date_trunc('day', block_timestamp) as date,

platform,

count(DISTINCT swapper) as user_count,

count(DISTINCT tx_hash) as tx_count,

sum(amount_in_usd) as total_vol,

avg(amount_in_usd) as avg_tx_vol,

sum(sum(amount_in_usd)) over (PARTITION by platform order by date asc) as cum_total_vol,

sum(count(DISTINCT tx_hash)) over (PARTITION by platform order by date asc) as cum_tx_count,

from

aptos.defi.ez_dex_swaps

where

date >= current_date - interval '30 days'

group by

date, platform

order by

date, platform asc