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