kiacryptomost popular swapping to
Updated 2022-03-08Copy Reference Fork
9
1
2
3
4
5
6
7
›
⌄
Select ll.address_name as "to", COUNT(*)
From solana.swaps s LEFT OUTER JOIN solana.labels l ON s.swap_from_mint = l.address LEFT OUTER JOIN solana.labels ll ON s.swap_to_mint = ll.address
Where block_timestamp::date >= '2021-12-01' And succeeded = 'True' And (swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
or swap_from_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) And (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
or swap_to_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) AND swap_from_amount > 0 AND swap_to_amount > 0 and swap_program = 'jupiter aggregator v2' AND swap_from_mint != swap_to_mint
GROUP by 1
ORDER by 2 DESC
Run a query to Download Data