select date(block_timestamp) as days,

tx_from as users

from osmosis.core.fact_transactions

where days >= '2022-10-10'

group by 1, 2

select days,

case

when days < '2022-11-06' then 'Pre-crisis'

else 'Crisis'

end as period,

count( DISTINCT users) as daily_users

from daily_users

group by days,period