roketos11
    Updated 2022-11-15
    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
    Run a query to Download Data