Pine AnalyticsBSC Bridge 3
    Updated 2024-02-06
    -- forked from BSC Bridge 1 @ https://flipsidecrypto.xyz/edit/queries/b12f5e18-5170-48aa-8813-4918a71dd9c9

    SELECT
    count(DISTINCT tx_hash) as events,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users,
    sum(AMOUNT_USD) as volume_usd,
    avg(AMOUNT_USD) as avg_bridge_amount

    FROM (

    SELECT
    block_timestamp,
    platform,
    tx_hash,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_USD

    FROM ethereum.defi.ez_bridge_activity
    WHERE destination_chain = 'bsc'

    )
    WHERE platform in ('axelar')


    Last run: about 1 year agoAuto-refreshes every 12 hours
    EVENTS
    USERS
    VOLUME_USD
    AVG_BRIDGE_AMOUNT
    1
    10680693592249290.998655.403545693
    1
    41B
    4s