strawbettySwap Pairs on Jupiter
Updated 2022-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with addresses as (
select swap_from_mint as swap_from, swap_to_mint as swap_to, count(*) as count
From solana.swaps
Where block_timestamp::date >= '2022-02-01' and swap_program='jupiter aggregator v2' And succeeded = 'True' and swap_from_amount > 0
Group by 1,2
order by 3 DESC
limit 10
)
select l1.label as from_token, l2.label as to_token, concat(from_token, ' to ', to_token) as pair , a.count as count
from addresses as a , solana.labels as l1, solana.labels as l2
where a.swap_from=l1.address and a.swap_to = l2.address
order by count desc
Run a query to Download Data