chispastop 10 tokens most swapped from pyusd
    Updated 2023-10-13
    SELECT
    SYMBOL_IN AS token_in,
    SYMBOL_OUT AS token_out,
    SUM(AMOUNT_OUT_USD) AS total_volume,
    COUNT(DISTINCT TX_HASH) AS swaps,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS tradoors
    FROM
    ETHEREUM.defi.ez_dex_swaps
    WHERE
    AMOUNT_IN_USD IS NOT NULL
    AND AMOUNT_OUT_USD IS NOT NULL
    AND block_timestamp >= DATE '2023-08-01'
    AND block_timestamp <= CURRENT_DATE
    AND token_in = '0x6c3ea9036406852006290770bedfcaba0e23a0e8' --pyusd token address
    GROUP BY
    token_in,
    token_out,
    SYMBOL_OUT,
    SYMBOL_IN
    ORDER BY
    total_volume DESC
    LIMIT
    5
    Run a query to Download Data