CATEGORY | TOP_SWAPPED_TOKEN | SWAPS | |
---|---|---|---|
1 | Big Fish (10k-50k) | USDt | 94670 |
2 | Big Fish (10k-50k) | wNEAR | 647141 |
3 | Big Fish (10k-50k) | NEKO | 112599 |
4 | Dolphins (50k-100k) | BLACKDRAGON | 87304 |
5 | Dolphins (50k-100k) | wNEAR | 341773 |
6 | Dolphins (50k-100k) | REF | 18860 |
7 | Goldfish (100-500) | USDC | 283167 |
8 | Goldfish (100-500) | wNEAR | 1008312 |
9 | Goldfish (100-500) | USDt | 360494 |
10 | Minnows (10-100) | UWON | 273001 |
11 | Minnows (10-100) | USDt | 383861 |
12 | Minnows (10-100) | wNEAR | 1279460 |
13 | Plankton (<10) | USDt | 269209 |
14 | Plankton (<10) | UWON | 226439 |
15 | Plankton (<10) | wNEAR | 1003761 |
16 | Salmon (1k-5k) | USDt | 329775 |
17 | Salmon (1k-5k) | wNEAR | 1130454 |
18 | Salmon (1k-5k) | USDC | 277749 |
19 | Trout (500-1k) | USDC | 159991 |
20 | Trout (500-1k) | USDt | 179179 |
datavortexTop Swapped by category
Updated 2025-04-30
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
33
34
35
36
›
⌄
WITH user_volumes AS (
SELECT
trader,
SUM(amount_in_usd) AS total_volume
FROM
near.defi.ez_dex_swaps
WHERE
platform = 'v2.ref-finance.near'
AND amount_in_usd IS NOT NULL
GROUP BY
trader
),
categorized_traders AS (
SELECT
trader,
CASE
WHEN total_volume >= 100000 THEN 'Whales (100k+)'
WHEN total_volume BETWEEN 50000 AND 99999 THEN 'Dolphins (50k-100k)'
WHEN total_volume BETWEEN 10000 AND 49999 THEN 'Big Fish (10k-50k)'
WHEN total_volume BETWEEN 5000 AND 9999 THEN 'Tuna (5k-10k)'
WHEN total_volume BETWEEN 1000 AND 4999 THEN 'Salmon (1k-5k)'
WHEN total_volume BETWEEN 500 AND 999 THEN 'Trout (500-1k)'
WHEN total_volume BETWEEN 100 AND 499 THEN 'Goldfish (100-500)'
WHEN total_volume BETWEEN 10 AND 99 THEN 'Minnows (10-100)'
ELSE 'Plankton (<10)'
END AS category
FROM user_volumes
),
category_top_tokens AS (
SELECT
ct.category,
s.symbol_in,
COUNT(DISTINCT s.tx_hash) AS swaps
FROM
near.defi.ez_dex_swaps s
JOIN categorized_traders ct ON s.trader = ct.trader
Last run: 28 days ago
27
953B
515s