mlhtop swaps on orca
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select a1.address_name || '-' || a2.address_name as swap_pair,
count (distinct swapper) as distinct_swapper,
count(distinct tx_id) as trxs
from solana.core.fact_swaps a0 join solana.core.dim_labels a1 on a0.swap_from_mint = a1.address
join solana.core.dim_labels a2 on a0.swap_to_mint = a2.address
where succeeded ='TRUE'
and swap_program ='orca'
group by 1
order by 2 desc
limit 10
Run a query to Download Data