itsxenuxPopular Swap Pairs
Updated 2022-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH query_table AS(
SELECT b.label AS TOKEN_FROM, bf.label AS TO_TOKEN, COUNT(TOKEN_FROM) AS SWAP_COUNT,
CONCAT(TOKEN_FROM,
'/',
TO_TOKEN) AS PAIRS
FROM Solana.swaps s
JOIN Solana.labels b ON s.swap_from_mint = b.address
JOIN Solana.labels bf ON s.swap_to_mint = bf.address
WHERE block_timestamp::date >= '2022-02-01' AND swap_program LIKE 'jupiter%' And swap_from_amount != 0 AND swap_to_amount != 0
AND s.swap_from_mint != s.swap_to_mint
AND succeeded = 'True'
Group by TOKEN_FROM, TO_TOKEN
Order by SWAP_COUNT DESC
limit 10)
SELECT * FROM query_table;
Run a query to Download Data