flipside

    APT Trading Volume Distribution by Top 5 Pairs
    victor-sanzcapdetAPT Trading Volume Distribution by Top 5 Pairs
    Updated 2025-02-11

    SELECT
    CONCAT(SYMBOL_IN, ' - ', SYMBOL_OUT) AS token_pair,
    SUM(COALESCE(AMOUNT_IN_USD, 0) + COALESCE(AMOUNT_OUT_USD, 0)) AS apt_pair_trading_volume
    FROM
    aptos.defi.ez_dex_swaps
    WHERE
    SYMBOL_IN = 'APT'
    AND block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
    AND SYMBOL_OUT IS NOT NULL
    GROUP BY
    token_pair
    ORDER BY
    apt_pair_trading_volume DESC
    LIMIT 5; -- Limitar el resultado al Top 5

    Last run: 3 months ago
    TOKEN_PAIR
    APT_PAIR_TRADING_VOLUME
    1
    		APT - USDC46524529.1978417
    2
    		APT - USDT9257861.68900084
    3
    		APT - amAPT7958064.33048464
    4
    		APT - aBTC4766409.88873634
    5
    		APT - thAPT1682959.60013447
    5
    163B
    2s