date(BLOCK_TIMESTAMP) as dt,

when dt between '2022-05-01' and '2022-05-03' then 'First Outage'

when dt between '2022-06-01' and '2022-06-03' then 'Second Outage'

else 'other times' end as periods,

count (distinct SWAPPER) as swappers,

count(distinct tx_id) as no_swaps

from flipside_prod_db.solana.fact_swaps

where SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP>=CURRENT_DATE-45

group by 1,2