count(DISTINCT tx_hash) as trxs,

count(DISTINCT SENDER) as swappers,

sum(AMOUNT_IN_USD) as usd_amount_in,

case when BLOCK_NUMBER < 15537393 then 'Before Merg'--15537393 is the first block after the merge

when BLOCK_NUMBER >= 15537393 then 'After Merg'

end as type,

sum(trxs) over (partition by type order by date) as cum_trxs,

sum(swappers) over (partition by type order by date) as cum_swappers,

sum(usd_amount_in) over (partition by type order by date) as cum_usd_amount_in

FROM ethereum.core.ez_dex_swaps

WHERE SYMBOL_IN = 'WETH'

AND BLOCK_TIMESTAMP::date >= '2022-09-01'

group by 1, 5

order by 1 desc