roketos1
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::date as date,
case when date < '2022-11-08' then 'Before FTX & Alameda Collapse'
when date >= '2022-11-08' then 'During and After FTX & Alameda Collapse' end as timespan,
count (distinct tx_id) as Swaps_Count,
count (distinct trader) as Swappers_Count
from osmosis.core.fact_swaps
where tx_status = 'SUCCEEDED'
and block_timestamp >= CURRENT_DATE - 90
group by 1,2
order by 1
Run a query to Download Data