itsxenuxTop 10 Popular Swaped To
Updated 2022-03-02
9
1
2
3
4
5
6
7
8
9
›
⌄
WITH query_table AS
(SELECT s.swap_to_mint , b.address_name, COUNT(s.swap_to_mint) AS swap_count
FROM Solana.swaps s
JOIN Solana.labels b ON s.swap_to_mint = b.address
WHERE block_timestamp::date >= '2022-02-01'
AND swap_program LIKE 'jupiter%' AND swap_from_amount != 0 AND swap_to_amount != 0 AND succeeded = 'True'
GROUP BY s.swap_to_mint, b.address_name
ORDER BY swap_count DESC LIMIT 10)
SELECT * FROM query_table;
Run a query to Download Data