keshanStable coin arb jupiter (solana)
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select (over_1_perc * 100 / total) as percentage
from (select
count(swap_to_amount/swap_from_amount) as total,
sum(case when (swap_to_amount - swap_from_amount) * 100/swap_from_amount >= 1 then 1 else 0 end) as over_1_perc
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