hosein778Untitled Query
    Updated 2022-10-16
    select
    date_trunc('day', block_timestamp) as day,
    case
    when day = '2022-10-11' then 'hacked day'
    when day > '2022-10-11' then 'after the hack'
    when day < '2022-10-11' then 'before the hack'
    else 'the hack'
    end t1,
    program_id as Raydium,
    count(distinct tx_id) as transactions
    from solana.fact_events where
    program_id in ('675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8')
    and block_timestamp >= '2022-10-01'
    group by 1,2,3
    order by 1 asc
    Run a query to Download Data