SWAP_PAIRS | swap count | distinct swappers | |
|---|---|---|---|
1 | APT-USDC | 15012658 | 858465 |
2 | USDC-APT | 13730123 | 796062 |
3 | USDt | 3851898 | 36646 |
4 | USDC | 3658530 | 33491 |
5 | APT-USDT | 3069378 | 472580 |
6 | USDt | 2971018 | 31774 |
7 | APT | 2934708 | 33637 |
8 | USDT-APT | 2630251 | 406967 |
9 | USDC-USDC | 2263957 | 193877 |
10 | USDC-USDT | 2163171 | 298241 |
datavortexTotal Swappers and Swaps Per Swap Pairs
Updated 2025-05-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
WITH top_tokens AS (
SELECT
symbol_in,
symbol_out,
COUNT(DISTINCT tx_hash) AS "swap count",
COUNT(DISTINCT swapper) AS "distinct swappers"
FROM aptos.defi.ez_dex_swaps
GROUP BY symbol_in, symbol_out
)
SELECT
CASE
WHEN symbol_in = 'APT' AND symbol_out = 'USDC' THEN 'APT-USDC'
WHEN symbol_in = 'USDC' AND symbol_out = 'APT' THEN 'USDC-APT'
WHEN symbol_in = 'APT' AND symbol_out = 'USDT' THEN 'APT-USDT'
WHEN symbol_in = 'USDT' AND symbol_out = 'APT' THEN 'USDT-APT'
WHEN symbol_in = 'USDT' AND symbol_out = 'USDC' THEN 'USDT-USDC'
WHEN symbol_in = 'USDC' AND symbol_out = 'USDT' THEN 'USDC-USDT'
WHEN symbol_in = 'amAPT' AND symbol_out = 'APT' THEN 'amAPT-APT'
WHEN symbol_in = 'APT' AND symbol_out = 'WETH' THEN 'APT-WETH'
WHEN symbol_in = 'APT' AND symbol_out = 'amAPT' THEN 'APT-amAPT'
WHEN symbol_in = 'USDC' AND symbol_out = 'USDC' THEN 'USDC-USDC'
WHEN symbol_in = 'USDT' AND symbol_out = 'USDT' THEN 'USDT-USDT'
ELSE symbol_out
END AS swap_pairs,
"swap count",
"distinct swappers"
FROM top_tokens
ORDER BY "swap count" DESC
LIMIT 10;
Last run: 10 days ago
10
264B
38s