date_trunc ('week',BLOCK_TIMESTAMP) as Date,

PLATFORM as DEX,

count (DISTINCT TX_HASH) as TXN,

count (DISTINCT ORIGIN_FROM_ADDRESS) as Users,

sum (AMOUNT_IN_USD) as USD,

sum (TXN) over (partition by DEX order by date ) as cum_TXN,

sum (Users) over (partition by DEX order by date ) as cum_Users,

sum (USD) over (partition by DEX order by date ) as cum_USD

FROM avalanche.core.ez_dex_swaps

WHERE BLOCK_TIMESTAMP >= '2023-01-01'

GROUP BY 1,2