chispasTotal Tokens Traded in 2024 (Polygon)
    Updated 2024-10-21
    -- forked from Total Tokens Traded in 2024 (Base) @ https://flipsidecrypto.xyz/studio/queries/2e1f3b77-7fc4-47e4-a17c-79c5bbc4bc2b

    SELECT COUNT(DISTINCT token) AS unique_tokens
    FROM (
    SELECT symbol_in AS token
    FROM polygon.defi.ez_dex_swaps
    WHERE platform LIKE '%uniswap%'
    AND block_timestamp >= '2024-01-01'
    UNION
    SELECT symbol_out AS token
    FROM polygon.defi.ez_dex_swaps
    WHERE platform LIKE '%uniswap%'
    AND block_timestamp >= '2024-01-01'
    ) AS all_tokens



    QueryRunArchived: QueryRun has been archived