KaskoazulTop10 Swap Away
Updated 2022-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
l.label as labelAway,
s.swap_to_mint,
count(tx_id) as swapCountAway --count(l.label)
FROM Solana.swaps s
LEFT OUTER JOIN Solana.labels l
ON s.swap_to_mint = l.address
WHERE block_timestamp::date >= '2022-02-01'
AND succeeded = 'True'
GROUP BY 1, 2
ORDER BY 3 DESC
LIMIT 10
Run a query to Download Data