case 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-10-20'

group by hour, time_period