select

trunc(block_timestamp,'day') as date,

case when date <'2023-06-05' then 'Before SEC'

when date between '2023-06-05' and '2023-06-08' then 'During SEC Rumours'

else 'After SEC' end as period,

count(*) as swaps,

count(distinct swapper) as swappers,

sum(case when swap_from_mint='So11111111111111111111111111111111111111112' then swap_from_amount else swap_to_amount end) as volume

from solana.core.fact_swaps

where (swap_from_mint='So11111111111111111111111111111111111111112' or swap_to_mint='So11111111111111111111111111111111111111112') and date>=current_date-INTERVAL '1 MONTH'

group by 1,2

order by 1