roketos11
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 TX_Count
from osmosis.core.fact_transfers
where tx_status = 'SUCCEEDED'
and transfer_type = 'IBC_TRANSFER_IN'
and block_timestamp >= CURRENT_DATE - 90
group by 1,2
order by 1