with tab1 as (select date_trunc('day',block_timestamp)as date,
count(distinct tx_hash) as swaps
from ethereum.core.ez_dex_swaps
where block_timestamp >= '2022-09-01'
group by date
order by date asc)
select date,swaps,
case
when date >= '2022-09-15' then 'merged'
when date <= '2022-09-15' then 'before merge'
end as merge
from tab1