talebimorteza_72Untitled Query
Updated 2022-03-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with swaps as (
select swap_to_mint as swapped_to_coin, count(s.tx_id) as number_of_swaps
from solana.swaps s
join solana.transactions t
on s.tx_id = t.tx_id
where swap_from_mint = 'So11111111111111111111111111111111111111112'
and swap_to_mint <> 'So11111111111111111111111111111111111111112'
and s.block_timestamp::date >= '2022-01-01'
and swap_program like '%jupiter%'
and t.succeeded = true
group by swapped_to_coin
order by number_of_swaps desc)
SELECT sl.label as labels, swaps.number_of_swaps as Numbers
from swaps
join solana.labels sl on sl.address = swaps.swapped_to_coin
order by Numbers desc
limit 5
Run a query to Download Data