datavortexdisciplinary-amethyst
    Updated 2024-09-17

    SELECT
    DISTINCT origin_from_address,
    symbol_in AS token_swapped,
    SUM(amount_in_usd) AS total_volume
    FROM polygon.defi.ez_dex_swaps
    WHERE block_timestamp >= '{{ start_date }}'
    AND block_timestamp < '{{ end_date }}'
    AND amount_in_usd IS NOT NULL
    GROUP BY origin_from_address, symbol_in
    ORDER BY total_volume DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived