brian-terra[1] Bridge platform overview copy
    Updated 2024-12-14
    -- forked from andreafiandro / [1] Bridge platform overview @ https://flipsidecrypto.xyz/andreafiandro/q/FODTFxX3SS2a/1-bridge-platform-overview

    SELECT
    platform,
    COUNT(DISTINCT TX_HASH) as total_txs,
    COUNT(DISTINCT token_symbol) as tot_asset
    --sum(amount_usd) as tot_bridged
    FROM
    ethereum.defi.ez_bridge_activity
    WHERE
    block_timestamp > '{{starting_date}}'
    AND Destination_chain in (
    'near',
    'solana',
    'sui',
    'osmosis',
    'aptos',
    'telos',
    'sei',
    'injective'
    )
    GROUP BY
    platform


    Last run: 27 days ago
    PLATFORM
    TOTAL_TXS
    TOT_ASSET
    1
    symbiosis263
    2
    wormhole68198442
    3
    near: rainbow bridge374275
    4
    axelar1587016
    5
    meson3972
    6
    dln_debridge16682912
    7
    allbridge18757
    7
    160B
    2s