feyikemiTraded Volume Perc. Diff
    Updated 2025-01-23
    WITH August_stats AS (
    SELECT
    DATE_TRUNC('month', block_timestamp) AS month,
    --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 >= '{{Start_Date}}'
    AND block_timestamp::DATE < '{{End_Date}}'
    GROUP BY 1
    )

    SELECT
    Month,
    Total_Traded_Volume_Aug,
    LAG(Total_Traded_Volume_Aug) OVER (ORDER BY Month) AS Previous_month_traded_Volume,
    ((Total_Traded_Volume_Aug - LAG(Total_Traded_Volume_Aug) OVER (ORDER BY Month)) / LAG(Total_Traded_Volume_Aug) OVER (ORDER BY Month)) *100 AS Txns_diff
    FROM August_stats
    ORDER BY Month DESC


    QueryRunArchived: QueryRun has been archived