select date(block_timestamp) as date, case when block_timestamp::date <= '2022-11-06' then 'Before FTX' else 'After FTX'
end as date_type , count(DISTINCT(tx_hash)) as total_tx, sum(stake_amount/pow(10,24)) as near
from near.core.dim_staking_actions
where block_timestamp::date >= CURRENT_DATE - 30
and action = 'Stake'
group by 1,2