PLATFORM | SYMBOL_IN | TOTAL_SWAP_COUNT | |
---|---|---|---|
1 | astroport | SEI | 706391 |
2 | astroport | USDCet | 133408 |
3 | astroport | SEIYAN | 108757 |
4 | astroport | USDC | 58881 |
5 | astroport | USDT | 35202 |
6 | dragonswap | WSEI | 2588166 |
7 | dragonswap | USDC | 1340734 |
8 | dragonswap | USDT | 650350 |
9 | dragonswap | iSEI | 405135 |
10 | dragonswap | WETH | 351935 |
11 | fuzio | SEI | 3592 |
12 | fuzio | USDCet | 1431 |
13 | fuzio | WETH | 1235 |
14 | fuzio | ATOM | 286 |
15 | fuzio | OSMO | 205 |
16 | jellyswap | USDC | 706715 |
17 | jellyswap | WSEI | 480184 |
18 | jellyswap | fastUSD | 229031 |
19 | jellyswap | USDT | 188322 |
20 | jellyswap | JLY | 165490 |
datavortexplatform dependencies
Updated 2025-05-18
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
32
›
⌄
WITH platform_token_activity AS (
SELECT
platform,
symbol_in,
COUNT(DISTINCT tx_id) AS total_swap_count
FROM
sei.defi.ez_dex_swaps
WHERE
symbol_in IS NOT NULL
GROUP BY
platform, symbol_in
),
ranked_platform_tokens AS (
SELECT
platform,
symbol_in,
total_swap_count,
ROW_NUMBER() OVER (PARTITION BY platform ORDER BY total_swap_count DESC) AS rank
FROM
platform_token_activity
)
SELECT
platform,
symbol_in,
total_swap_count
FROM
ranked_platform_tokens
WHERE
rank <= 5
ORDER BY
platform, total_swap_count DESC;
Last run: 13 days ago
30
797B
3s