flipside

    Token Status 6
    feyikemiToken Status 6
    Updated 2025-01-23
    WITH Tb1 AS (
    SELECT
    TOKEN_IN AS TOKEN,
    MAX(BLOCK_TIMESTAMP) AS LAST_TRADE
    FROM avalanche.defi.ez_dex_swaps
    WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')
    GROUP BY TOKEN

    UNION ALL

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

    SELECT
    CASE
    WHEN LAST_TRADE >= CURRENT_DATE - INTERVAL '30 DAY' THEN 'Active'
    ELSE 'Inactive'
    END AS STATUS,
    COUNT(DISTINCT TOKEN) AS TOKEN_COUNT
    FROM Tb1
    GROUP BY STATUS






    QueryRunArchived: QueryRun has been archived