afonsoDaily Number of Transactions on Solana Before and After $BONK Launch Over Time
    Updated 2023-01-07
    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
    Run a query to Download Data