YEAR | TRADERS | PREVIOUS_YEAR_VOLUME | PERC_DIFF | |
---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 217752 | 1455052 | -85.0348 |
2 | 2024-01-01 00:00:00.000 | 1455052 | 676708 | 115.0192 |
3 | 2023-01-01 00:00:00.000 | 676708 | 135744 | 398.5178 |
4 | 2022-01-01 00:00:00.000 | 135744 |
feyikemiUnique Traders % Difference
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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
4
201B
2s