flipside

    Total Active Tokens 5
    feyikemiTotal Active Tokens 5
    Updated 2025-01-23
    WITH last_trade AS (
    SELECT
    TOKEN_IN AS TOKEN,
    MAX(BLOCK_TIMESTAMP) AS LAST_TRADE
    FROM optimism.defi.ez_dex_swaps
    WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')
    GROUP BY TOKEN_IN

    UNION ALL

    SELECT
    TOKEN_OUT AS TOKEN,
    MAX(BLOCK_TIMESTAMP) AS LAST_TRADE
    FROM optimism.defi.ez_dex_swaps
    WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')
    GROUP BY TOKEN_OUT
    )

    SELECT
    COUNT(DISTINCT TOKEN) AS TOKEN_COUNT
    FROM last_trade
    WHERE LAST_TRADE >= CURRENT_DATE - INTERVAL '30 DAY'





    Last run: about 2 months ago
    TOKEN_COUNT
    1
    		330
    1
    7B
    12s