date_trunc('day', block_timestamp) as date,

case when date = '2022-09-15' then 'The merge' when block_number >= 15537393 then 'After the merge' else 'Before the merge' end as type,

count(distinct tx_hash) as swap_count, count(distinct origin_from_address) as unique_swapper, sum(amount_out) as swaps_volume

from ethereum.core.ez_dex_swaps

where date >= '2022-08-01' and date < current_date and symbol_out = 'WETH'

group by 1, 2