days,

case when days >= '2022-08-31' and days < '2022-09-15' then '15 days before Merge'

else '15 days after Merge'

end as "period",

"unique swappers count",

"number of swaps",

"USD volume",

"cumulative USD volume",

"cumulative number of swaps"

from

(select

block_timestamp::date as days,

count (distinct ORIGIN_FROM_ADDRESS) as "unique swappers count",

count (distinct tx_hash) as "number of swaps",

sum(amount_in_usd)as "USD volume",

sum("USD volume") over (order by DAYS) as "cumulative USD volume",

sum("number of swaps") over (order by DAYS) as "cumulative number of swaps"

from ethereum.core.ez_dex_swaps

where symbol_in = 'WETH'

and amount_in_usd > 0 and amount_in_usd is not null

and block_timestamp::date > '2022-08-30'

group by 1

group by 1 , 2 , 3 , 4 , 5 , 6 , 7

order by 1