select
trunc(block_timestamp, 'day')::date as day,
iff(day > '2022-12-24', 'After BONK Activation', 'Before BONK Activation') as type,
count (distinct (tx_id)) as txn_count,
count (distinct (signers[0])) as users_count
from solana.core.fact_transactions
where block_timestamp::date >= '2022-11-01'
group by day, type
order by day