feyikemiUnique Traders % Difference
    Updated 2025-03-25
    With Stats AS (
    SELECT
    Date_trunc('year', Block_timestamp) AS Year,
    COUNT(DISTINCT Swapper) AS Traders
    FROM aptos.defi.ez_dex_swaps
    GROUP BY 1
    )

    SELECT
    Year,
    Traders,
    LAG(Traders) OVER (ORDER BY Year) AS Previous_Year_Volume,
    ((Traders - LAG(Traders) OVER (ORDER BY Year)) / LAG(Traders) OVER (ORDER BY Year)) * 100 Perc_diff
    FROM Stats
    ORDER BY YEAR DESC
    Last run: 2 months ago
    YEAR
    TRADERS
    PREVIOUS_YEAR_VOLUME
    PERC_DIFF
    1
    2025-01-01 00:00:00.0002177521455052-85.0348
    2
    2024-01-01 00:00:00.0001455052676708115.0192
    3
    2023-01-01 00:00:00.000676708135744398.5178
    4
    2022-01-01 00:00:00.000135744
    4
    201B
    2s