nsa2000Daily Number of Incoming and Outgoing Transfers On Osmosis During FTX Alameda Collapse
    Updated 2022-11-17
    select block_timestamp::date as date,
    transfer_type,
    count (distinct tx_id) as TX_Count
    from osmosis.core.fact_transfers
    where tx_status = 'SUCCEEDED'
    and transfer_type in ('IBC_TRANSFER_IN','IBC_TRANSFER_OUT')
    and block_timestamp >= CURRENT_DATE - 90
    group by 1,2
    order by 1
    Run a query to Download Data