shadilStablecoin Arbitrage on Jupiter - top 10 wallets gained more than 1% profit - in total swaps
    Updated 2022-03-19
    select swapper, sum(swap_to_amount/swap_from_amount) * 100 as arbitrage
    from solana.swaps
    where block_timestamp::date >= '2022-02-01'
    and swap_program = 'jupiter aggregator v2'
    and succeeded = 'True'
    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
    group by swapper
    having arbitrage >= 101
    order by arbitrage DESC
    limit 10
    Run a query to Download Data