select swapper, sum(x) as arb_gain, avg(percent_gain)

from (select swapper ,(swap_to_amount/swap_from_amount) as arbitrage, ((swap_to_amount-swap_from_amount)/swap_from_amount)*100 as percent_gain, swap_to_amount-swap_from_amount as x

from solana.swaps

where block_timestamp::date>='2022-02-01'

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 and swap_program = 'jupiter aggregator v2' and succeeded = 'True')

group by 1 order by 2 desc

limit 10