alfredfx10Top 10 traded token (ETH)
    Updated 2024-09-21
    SELECT
    CONCAT(SYMBOL_IN, '-', SYMBOL_OUT) AS token_pair,
    COUNT(DISTINCT TX_HASH) AS Transactions,
    FROM ethereum.defi.ez_dex_swaps
    WHERE year(BLOCK_TIMESTAMP)='2024'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    QueryRunArchived: QueryRun has been archived