TRADING_PAIR | TOTAL_SWAPS | |
|---|---|---|
1 | SOL-ROMEO | 4616600 |
2 | SOL-MBC | 3703776 |
3 | SOL-HALL OF PEPE | 3657146 |
4 | SOL-GRINGO | 3208830 |
5 | SOL-PONKEI | 3164182 |
6 | SOL-FLUFFY PICKLE | 2057666 |
7 | SOL-MONKEY POX | 1890029 |
8 | SOL-USDT | 1672955 |
9 | USDT-SOL | 1565075 |
10 | GRINGO-SOL | 429448 |
11 | HALL OF PEPE-SOL | 253464 |
datavortextop swap pairs
Updated 2025-03-25
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
›
⌄
⌄
/*
SELECT
swap_from_mint AS "swap_from",
swap_to_mint AS "swap_to",
COUNT(DISTINCT tx_id) AS total_swaps
FROM
solana.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'
AND swap_from_mint IS NOT NULL
AND swap_to_mint IS NOT NULL
AND TRIM(swap_from_mint) <> ''
AND TRIM(swap_to_mint) <> ''
GROUP BY
swap_from_mint, swap_to_mint
ORDER BY
total_swaps DESC
LIMIT 10;
*/
SELECT
CASE
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = '9Y7myWuGEY9kT4Z9nKXPXWZEhRd2hJQ85nCK4Hjs8oX2' THEN 'SOL-ROMEO'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'YcUzxsUL4wTETS1qWe5HsgCHNaQz9wddcoL2L62xn7k' THEN 'SOL-HALL OF PEPE'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'F7A8759EzWs9c4z8xyhwdtATU4jjzTU6VTQ6zHcwXyh2' THEN 'SOL-PONKEI'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'EbZh3FDVcgnLNbh1ooatcDL1RCRhBgTKirFKNoGPpump' THEN 'SOL-GRINGO'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'MBCccZZEbcvWzaHD9otPjmBMFaa6pG7XRYSw39HT5n2' THEN 'SOL-MBC'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = '6rRHwTdDAJwFYNdU4Z6CVGSwgTjBAaqMAj1w1kpopump' THEN 'SOL-FLUFFY PICKLE'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'mpoxP5wyoR3eRW8L9bZjGPFtCsmX8WcqU5BHxFW1xkn' THEN 'SOL-MONKEY POX'
WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' AND swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'SOL-USDT'
WHEN swap_from_mint = '9Y7myWuGEY9kT4Z9nKXPXWZEhRd2hJQ85nCK4Hjs8oX2' AND swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'ROMEO-SOL'
WHEN swap_from_mint = 'YcUzxsUL4wTETS1qWe5HsgCHNaQz9wddcoL2L62xn7k' AND swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'HALL OF PEPE-SOL'
WHEN swap_from_mint = 'F7A8759EzWs9c4z8xyhwdtATU4jjzTU6VTQ6zHcwXyh2' AND swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'PONKEI-SOL'
WHEN swap_from_mint = 'EbZh3FDVcgnLNbh1ooatcDL1RCRhBgTKirFKNoGPpump' AND swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'GRINGO-SOL'
WHEN swap_from_mint = 'MBCccZZEbcvWzaHD9otPjmBMFaa6pG7XRYSw39HT5n2' AND swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'MBC-SOL'
Last run: 3 months ago
11
267B
34s