PeimanStablecoin Arbitrage on Jupiter(number of swaps)
    Updated 2022-03-20
    select count (distinct tx_id) as Number_of_AllSwaps,
    count(case when (swap_to_amount/swap_from_amount)>=1.01 then tx_id END) as Swaps_1percent_gain,
    (Swaps_1percent_gain/Number_of_AllSwaps)*100 as "Percentage of swaps with at least 1% gain(%)"
    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
    Run a query to Download Data