permaryMost Popular Trading Pairs on Avalanche
    Updated 2025-03-25
    WITH xsgd_trades AS (
    -- Avalanche Trades
    SELECT
    'Avalanche' AS platform,
    CONCAT(
    LEAST(SYMBOL_IN, SYMBOL_OUT),
    '-',
    GREATEST(SYMBOL_IN, SYMBOL_OUT)
    ) AS token_pair,
    COUNT(*) AS trade_count,
    SUM(amount_in_usd) AS volume_usd_primary,
    SUM(
    CASE
    WHEN SYMBOL_IN = 'XSGD' THEN amount_out_usd
    WHEN SYMBOL_OUT = 'XSGD' THEN amount_in_usd
    END
    ) AS volume_usd_secondary
    FROM avalanche.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-09'
    GROUP BY platform, token_pair

    UNION ALL

    -- Ethereum Trades
    SELECT
    'Ethereum' AS platform,
    CONCAT(
    LEAST(SYMBOL_IN, SYMBOL_OUT),
    '-',
    GREATEST(SYMBOL_IN, SYMBOL_OUT)
    ) AS token_pair,
    COUNT(*) AS trade_count,
    SUM(amount_in_usd) AS volume_usd_primary,
    SUM(
    CASE
    Last run: about 1 month ago
    PLATFORM
    TOKEN_PAIR
    TOTAL_TRADE_COUNT
    TOTAL_VOLUME_USD
    1
    AvalancheUSDC-XSGD112659258573719.77
    2
    AvalancheWAVAX-XSGD117394177760624.28
    3
    AvalancheUSDt-XSGD115269.47
    4
    AvalancheXSGD-avUSD42115.5
    5
    EthereumUSDC-XSGD313016117944.79
    6
    EthereumUSDT-XSGD15648411660.89
    7
    EthereumTKX-XSGD1407324105.4
    8
    EthereumWETH-XSGD46315.18
    9
    EthereumFORT-XSGD10
    10
    PolygonUSDC-XSGD98524110365539.77
    11
    PolygonWETH-XSGD489777205530.09
    12
    PolygonWGC-XSGD175013807.41
    13
    PolygonUSDT-XSGD94838.14
    14
    PolygonJPYC-XSGD2152232.97
    15
    PolygonWMATIC-XSGD5391291.66
    16
    PolygonBonk-XSGD222.9
    17
    PolygonWBTC-XSGD40.28
    18
    PolygonVNXAU-XSGD30.17
    19
    PolygonELON-XSGD30.07
    20
    PolygonSIMI-XSGD3090
    24
    850B
    15s