shreexdasdds
    Updated 2022-11-25
    select
    date_trunc('day',block_timestamp) as date,
    case
    when date >= '2022-11-08' then 'After FTX Collapse'
    when date < '2022-11-08' then 'Before FTX Collapse'
    else 'A' end as event_date,
    swap_program,
    count(distinct tx_id) as swaps
    from solana.core.fact_swaps
    where date >= '2022-11-01'
    group by date,swap_program,event_date
    order by date
    Run a query to Download Data