flipside

    near bridge 7
    adriaparcerisasnear bridge 7
    Updated 2025-05-19
    SELECT
    case when source_chain='near' then destination_chain else source_chain end as chain,
    SUM(AMOUNT_USD) AS TOTAL_VOLUME_USD,
    COUNT(TX_HASH) AS TRANSACTION_COUNT,
    ROUND(SUM(AMOUNT_USD) / NULLIF(SUM(SUM(AMOUNT_USD)) OVER (), 0) * 100, 2) AS PERCENT_OF_TOTAL_VOLUME
    FROM
    near.defi.ez_bridge_activity
    WHERE
    RECEIPT_SUCCEEDED = TRUE
    AND AMOUNT_USD IS NOT NULL
    GROUP BY
    CHAIN having chain is not null
    ORDER BY
    TOTAL_VOLUME_USD DESC


    Last run: 11 days ago
    CHAIN
    TOTAL_VOLUME_USD
    TRANSACTION_COUNT
    PERCENT_OF_TOTAL_VOLUME
    1
    		aurora2105170151.1681550764958.89
    2
    		ethereum1441719381.980588452740.33
    3
    		celo7288286.1618668419520.2
    4
    		solana6161173.2724823795160.17
    5
    		binance smart chain5915918.4366363510300.17
    6
    		eth4221033.79532763010.12
    7
    		polygon1661810.240334263340.05
    8
    		sol1367094.647633766350.04
    9
    		avalanche c-chain1041301.54289634770.03
    10
    		terra classic91708.0492787964170
    11
    		fantom37848.4852490291440
    12
    		terra224989.45893622930
    13
    		harmony23962.9869761240
    14
    		huobi eco chain17726.786555471790
    15
    		bsc16158.133560112930
    16
    		avalanche14882.420643343590
    17
    		cronos9385.34276887860
    18
    		fuse7010.6528173330
    19
    		klaytn6354.986313987110
    20
    		aptos942.705163212130
    36
    1KB
    510s