datavortexunited-lime
    Updated 2024-10-31
    SELECT
    CONCAT(token_in_symbol, '/', token_out_symbol) AS SwapPair,
    SUM(amount_in_usd) AS total_volume
    FROM
    flow.defi.ez_dex_swaps
    GROUP BY
    token_in_symbol,
    token_out_symbol
    ORDER BY
    total_volume DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived