case when date <= '2022-12-25' then 'Before $BONK'

else 'After $BONK' end as period,

count (distinct tx_id) as total_transaction,

count (distinct signers[0]) as total_user

from solana.core.fact_transactions

where block_timestamp::date >= CURRENT_DATE - 30

group by date,period