permary Top DEXs for XSGD on Each Chain
    Updated 2025-03-16
    WITH xsgd_dexs AS (
    SELECT
    'Ethereum' AS chain,
    platform,
    SUM(amount_in_usd) AS volume_usd
    FROM ethereum.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-01'
    GROUP BY chain, platform

    UNION ALL
    SELECT
    'Polygon' AS chain,
    platform,
    SUM(amount_in_usd) AS volume_usd
    FROM polygon.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-01'

    GROUP BY chain, platform
    UNION ALL
    SELECT
    'Avalanche' AS chain,
    platform,
    SUM(amount_in_usd) AS volume_usd
    FROM avalanche.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-01'
    GROUP BY chain, platform
    )
    SELECT * FROM xsgd_dexs ORDER BY volume_usd DESC;

    Last run: about 1 month ago
    CHAIN
    PLATFORM
    VOLUME_USD
    1
    Polygonsushiswap
    2
    Polygoncurve
    3
    Polygonquickswap-v2
    4
    Avalanchepharaoh-v2256827726.22
    5
    Avalanchetrader-joe-v2167460311.24
    6
    Polygonuniswap-v399488941.55
    7
    Polygonbalancer17609966.57
    8
    Ethereumuniswap-v316531728.38
    9
    Ethereumpancakeswap-v37523427.2
    10
    Avalanchebalancer2422129
    11
    Ethereumuniswap-v2284432.49
    12
    Polygonwoofi5697.01
    13
    Avalanchepangolin269.1
    14
    Polygonuniswap-v21.12
    14
    478B
    3s