PLATFORM,

SUM(AMOUNT_IN_USD) AS total_volume_usd,

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS day,

SUM(total_volume_usd) over (partition by platform order by day) as cumulative_volume_usd,

count(distinct tx_hash) as swaps,

sum(swaps) over (partition by platform order by day) as cumulative_swaps,

count(distinct swapper) as swappers

FROM

aptos.defi.ez_dex_swaps

where AMOUNT_IN_USD<1e6 and amount_in_usd is not null

and day<trunc(current_date,'week') and day>='2024-01-01'

GROUP BY

PLATFORM, day

ORDER BY

day DESC, platform