select block_timestamp::Date as date,
case when date < '2023-03-13' then 'Before Hack'
when date = '2023-03-13' then 'Hack Day'
else 'After Hack' end as timespan,
symbol_out,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Swappers_Count,
sum (amount_in) as Volume
from ethereum.core.ez_dex_swaps
where token_in = '0xd9fcd98c322942075a5c3860693e9f4f03aae07b'
and date >= '2023-03-01'
group by 1,2,3
order by 1