select
date_trunc('day',block_timestamp) as day
,count(tx_hash) as swaps
,case
when block_timestamp between '2023-01-01 06:00:00' and '2023-01-16 14:00:00' then 'During Pump'
else 'Rest of the year'
end as Period
from ethereum.core.ez_dex_swaps
where block_timestamp > '2022-06-01'
group by 1, 3