messariIBC transfers basics
    Updated 2024-07-09
    with ibc_transfers as (
    select
    date(block_timestamp) as date,
    *
    from
    cosmos.core.fact_transfers
    where
    transfer_type = 'IBC_TRANSFER_IN'
    or transfer_type = 'IBC_TRANSFER_OUT'
    )

    SELECT
    date,
    transfer_type,
    count(*) as transfers,
    count(distinct sender) as unique_senders,
    count(distinct receiver) as unique_receivers,
    count(distinct tx_id) as ibc_transactions
    from ibc_transfers group by 1, 2 order by date desc;
    QueryRunArchived: QueryRun has been archived