select block_timestamp::date daily,

case when daily < '2022-09-15'::date then 'before Merge'

else 'After Merge'

end as range ,

count (distinct tx_hash) num_swaps,

sum (amount_in_usd) swapped_volume_usd,

count (distinct origin_from_address) num_swappers

from ethereum.core.ez_dex_swaps

where block_timestamp::date >= '2022-09-15'::date - 30

group by 1,2