Flipside Axelar AnalystsSolana + Blast + Aptos
    Updated 2025-02-06
    select case
    when source_chain='solana' then 'Solana'
    when source_chain='aptos' then 'Aptos'
    when source_chain='blast' then 'Blast'
    end as "Source Chain",
    sum(amount_usd) as "Volume of Transfers",
    count(distinct tx_hash) as "Number of Transfers",
    count(distinct source_address) as "Number of Users",
    count(distinct (source_chain || '➡' || destination_chain)) as "Number of Routes",
    case
    when platform in ('layerzero','layerzero-v2','stargate') then 'LayerZero'
    when platform = 'wormhole' then 'Wormhole'
    end as "Cross-Chain Service"
    from crosschain.defi.ez_bridge_activity
    where platform in ('layerzero','layerzero-v2','stargate','wormhole') and block_timestamp::date>='2024-01-01'
    and source_chain in ('blast','solana')
    group by 1, 6

    union all

    select case
    when source_chain in ('Aptos','aptos') then 'Aptos'
    end as "Source Chain",
    round(sum(amount_in_usd),2) as "Volume of Transfers",
    count(distinct tx_hash) as "Number of Transfers",
    count(distinct sender) as "Number of Users",
    count(distinct (source_chain || '➡' || destination_chain)) as "Number of Routes",
    case
    when platform = 'layerzero' then 'LayerZero'
    when platform = 'wormhole' then 'Wormhole'
    end as "Cross-Chain Service"
    from aptos.defi.ez_bridge_activity
    where source_chain in ('Aptos','aptos') and platform in ('layerzero','wormhole')
    and block_timestamp::date>='2024-01-01'
    group by 1, 6
    QueryRunArchived: QueryRun has been archived