feyikemiTop Platforms
    Updated 2025-01-23
    SELECT
    Platform,
    COUNT(DISTINCT TX_HASH) AS Total_Trades_Aug,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS Total_Traders_Aug,
    SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS Total_Traded_Volume_Aug
    FROM
    avalanche.defi.ez_dex_swaps
    WHERE BLOCK_TIMESTAMP :: Date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
    GROUP BY 1
    ORDER BY 2 DESC
    Limit 10
    QueryRunArchived: QueryRun has been archived