Kruys-Collinsrolling-maroon
    Updated 2025-01-27
    SELECT
    symbol,
    ROUND(SUM(amount_in_usd),2) AS total_amount_in_usd,
    SUM(amount_in_usd) * 100.0 / SUM(SUM(amount_in_usd)) OVER () AS token_dominance_percentage
    FROM aptos.defi.ez_bridge_activity
    WHERE amount_in_usd is not null
    AND YEAR(block_timestamp) = 2025
    GROUP BY
    symbol
    ORDER BY
    total_amount_in_usd DESC;

    Last run: 3 months ago
    SYMBOL
    TOTAL_AMOUNT_IN_USD
    TOKEN_DOMINANCE_PERCENTAGE
    1
    USDC26426378.8855.195226661
    2
    WETH14154233.2229.563116241
    3
    USDT3637655.017.597756525
    4
    Cake2429694.795.074760919
    5
    WBTC618811.211.292474656
    6
    APT342362.090.7150716071
    7
    doodoo194535.940.4063158113
    8
    SOL63392.790.1324048007
    9
    BTC.b10431.190.021787007
    10
    BNB355.020.0007415105292
    11
    BSKT122.580.0002560341316
    12
    BUSD41.850.00008740372676
    13
    WFTM0.367.550210952e-7
    14
    WMATIC0.036.778441425e-8
    14
    445B
    1s