nitsTop Swappers by Amount
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT swapper, sum(swap_amt_sol) as total_amt
from
(SELECT *, case when swap_to_mint = 'So11111111111111111111111111111111111111112' then swap_to_amount
else swap_from_amount end as swap_amt_sol
from solana.core.fact_swaps
where succeeded = TRUE and (swap_to_mint = 'So11111111111111111111111111111111111111112' or swap_from_mint = 'So11111111111111111111111111111111111111112' ) and
program_id = 'JUP2jxvXaqu7NQY1GmNF4m1vodw12LVXYxbFL2uJvfo' and date(block_timestamp) >= CURRENT_DATE - {{n}})
GROUP by 1
ORDER by 2 desc
LIMIT 10
Run a query to Download Data