superflyTop token volume by pool
    Updated 2024-11-26
    WITH tb1 AS (
    SELECT
    POOL_NAME,
    SYMBOL_IN,
    SUM(COALESCE(amount_in_usd, 0)) AS total_volume
    FROM
    avalanche.defi.ez_dex_swaps
    WHERE
    block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
    GROUP BY
    POOL_NAME,
    SYMBOL_IN
    ORDER BY
    total_volume DESC
    )
    SELECT
    SYMBOL_IN,
    total_volume
    FROM
    tb1
    ORDER BY
    total_volume DESC
    LIMIT
    10
    QueryRunArchived: QueryRun has been archived