case when block_timestamp >= '2022-03-15' and block_timestamp <= '2022-05-11' then '60 days before the Terra collapse'

when block_timestamp > '2022-05-12' and block_timestamp <= '2022-07-12' then '60 days after the Terra collapse'

when block_timestamp >= '2022-10-28' then 'one week after $OSMO trading listed on Binance'

when block_timestamp >= '2022-10-20' and block_timestamp < '2022-10-28' then 'one week before $OSMO trading listed on Binance'

else 'others' end as time_period,

count (distinct tx_id) as no_of_txns,

count (distinct tx_from) as no_of_users

from osmosis.core.fact_transactions

where tx_status = 'SUCCEEDED'

and block_timestamp >= '2022-03-15'

group by day, time_period