shreexdasdds
Updated 2022-11-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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