select

block_timestamp,

block_number,

tx_hash,

origin_from_address,

amount_out_usd,

symbol_in

from ethereum.core.ez_dex_swaps

where block_timestamp::date >= '2022-09-06'

and block_timestamp::date <= '2022-09-24'

and symbol_out = 'WETH'

and amount_out_usd > 0 and amount_out_usd is not null

),

top_pool as (

select

concat('SWAP WETH TO ', symbol_in) as "Pool",

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

from ethereum_swaps

group by "Pool"

order by "Swap Volume (USD)" desc

limit 10

select

block_timestamp::date as "Days",

case

when block_timestamp::date >= '2022-09-06' and block_timestamp::date <= '2022-09-15' and block_number < 15537394 then 'Before Merge'

else 'After Merge'

end as "Time Frame",

concat('SWAP WETH TO ', symbol_in) as "Pool",

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

where "Pool" in (select "Pool" from top_pool)