0xHaM-dTotals Bridge[All Time]
    Updated 9 days ago
    -- forked from Totals By Bridge[All Time] @ https://flipsidecrypto.xyz/studio/queries/4ab8462a-eba2-4983-bbaa-0c1a0efaba1b

    -- forked from flyingfish / Totals By Bridge @ https://flipsidecrypto.xyz/flyingfish/q/qLXRXm5P4Pdm/totals-by-bridge

    with hyperlane_bridges as (
    select
    'Hyperlane' as bridge
    , date
    , total_gross_usd_volume
    , events_count

    from $query('19f93923-bf61-4c76-a496-194ee7e6d11f')
    order by date desc
    limit 1

    )

    , canonical_bridges as (
    select
    'Canonical' as bridge
    , date
    , total_gross_usd_volume
    , events_count

    from $query('3b847d0f-cb54-439d-90d7-a6c81442058c')
    order by date desc
    limit 1
    )

    select
    sum(total_gross_usd_volume) as total_volume
    , sum(events_count) as total_bridges
    from (
    select * from canonical_bridges
    union all
    select * from hyperlane_bridges
    Last run: 9 days ago
    TOTAL_VOLUME
    TOTAL_BRIDGES
    1
    736439252.432699142
    1
    24B
    1s