select

block_timestamp,

block_number,

tx_hash,

origin_from_address,

amount_out_usd

from ethereum.core.ez_dex_swaps

where date_trunc('day', block_timestamp) >= '2022-09-01'

and symbol_out = 'WETH'

and amount_out_usd > 0 and amount_out_usd is not null

select

block_timestamp::date as "Days",

case when "Days" < '2022-09-15' then 'Pre' ELSE 'Post' END as MERGE,

count(distinct tx_hash) as "Number of Swaps",

count(distinct origin_from_address) as "Number of Unique Swapper",

sum(amount_out_usd) as "Swap Volume (USD)"

from ethereum_swaps

group by 1,2

order by "Days"