TRADER_CATEGORY | SWAP_PAIR | SWAP_COUNT | TOTAL_SWAP_VOLUME_USD | |
|---|---|---|---|---|
1 | Medium Traders | MNDE-USDC | 397 | 935315.56 |
2 | Medium Traders | MNDE-USDT | 188 | 378801.83 |
3 | Medium Traders | MNDE-SOL | 61 | 190190.02 |
4 | Medium Traders | MNDE-MSOL | 34 | 94875.66 |
5 | Medium Traders | MNDE-TRUMP | 39 | 61565.3 |
6 | Small Traders | MNDE-USDC | 8240 | 1522047.58 |
7 | Small Traders | MNDE-SOL | 3439 | 506102.04 |
8 | Small Traders | MNDE-USDT | 354 | 121657.06 |
9 | Small Traders | MNDE-MSOL | 1933 | 100891.05 |
10 | Small Traders | MNDE-JLP | 777 | 60371.13 |
11 | Whales | MNDE-USDC | 18 | 353465.81 |
12 | Whales | MNDE-SOL | 9 | 249898.32 |
13 | Whales | MNDE-JTO | 1 | 113940.7 |
14 | Whales | MNDE-USDT | 5 | 88087.88 |
15 | Whales | MNDE-MSOL | 3 | 45246.21 |
datavortexwhat traders
Updated 2025-02-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
33
34
35
36
›
⌄
WITH swap_data AS (
SELECT
swap_from_mint,
swap_to_mint,
swap_from_symbol,
swap_to_symbol,
tx_id,
swapper,
swap_from_amount_usd,
swap_to_amount_usd,
block_timestamp,
CASE
WHEN SUM(swap_from_amount_usd) <= 1000 THEN 'Small Traders'
WHEN SUM(swap_from_amount_usd) <= 10000 THEN 'Medium Traders'
WHEN SUM(swap_from_amount_usd) > 10000 THEN 'Whales'
ELSE 'Unknown'
END AS trader_category
FROM
solana.marinade.ez_swaps
WHERE
swap_from_symbol = 'MNDE'
AND block_timestamp >= CURRENT_DATE - INTERVAL '1 MONTH'
GROUP BY
swap_from_mint, swap_to_mint, swap_from_symbol, swap_to_symbol, tx_id, swapper, swap_from_amount_usd, swap_to_amount_usd, block_timestamp
),
ranked_swap_pairs AS (
SELECT
trader_category,
swap_from_symbol || '-' || swap_to_symbol AS swap_pair,
COUNT(DISTINCT tx_id) AS swap_count,
SUM(swap_from_amount_usd) AS total_swap_volume_usd,
ROW_NUMBER() OVER (PARTITION BY trader_category ORDER BY SUM(swap_from_amount_usd) DESC) AS rank
FROM
swap_data
GROUP BY
trader_category, swap_from_symbol, swap_to_symbol
Last run: 3 months ago
15
612B
1s