MetiocreTop Swapped To Jupiter
Updated 2022-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with addresses as (
select swap_to_mint as token_mint, sum(1) 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
order by 2 DESC
limit 10
)
select l.label as token, a.count as count
from addresses as a , solana.labels as l
where a.token_mint=l.address
order by count desc
Run a query to Download Data