realistoutbound bridging
    Updated 2024-11-21
    SELECT
    --date_trunc('day', block_timestamp) as date,
    destination_chain as destination,
    count(tx_hash) as no_trans,
    sum(case when direction = 'outbound' then amount_in_usd
    end) as bridge_out
    FROM aptos.defi.ez_bridge_activity
    where block_timestamp >= '{{start_date}}'
    and destination_chain != 'Aptos'
    and destination_chain != 'aptos'

    GROUP BY 1
    Last run: about 2 months ago
    DESTINATION
    NO_TRANS
    BRIDGE_OUT
    1
    bsc113140173.79918963
    2
    polygon7522385.45895332
    3
    CoreDAO4975.98754526
    4
    Avalanche119311279683.0733072
    5
    algorand364.28624
    6
    fantom208698.854537902
    7
    optimism174122066.541416918
    8
    BSC326071236384.6335448
    9
    base16827536.713404932
    10
    terra210.00987
    11
    Bevm4
    12
    ZkSync580.6081404
    13
    ethereum802254490.15509995
    14
    sui12321333696.30274172
    15
    solana10602198109.52682894
    16
    Polygon22737565808.48362939
    17
    sei118167.432657033
    18
    moonbeam1167461305.02364806
    19
    celo711552.394142742
    20
    avalanche2115934.354816446
    29
    848B
    1s