barbodTop 20 Favorite Tokens for Top10 Gainers
Updated 2022-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with gainers as (
select
SWAPPER
,count(tx_id) as tx_count
,sum(swap_to_amount-swap_from_amount) as gain
from solana.swaps
where block_timestamp::date >= '2022-02-01'
and swap_program = 'jupiter aggregator v2'
and succeeded = 'True'
and (swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
and (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
and swap_from_amount>=100 and swap_to_amount>=100
group by 1
having gain>0
order by gain DESC
limit 10
)
select
address_name as token ,
count (tx_id) as transactions
from solana.swaps join solana.labels
on swap_to_mint = address
where block_timestamp::date >= '2022-02-01'
and swapper in (select SWAPPER from gainers )
group by 1 order by 2 desc limit 20
Run a query to Download Data