boomer77stablecoin arb
Updated 2022-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
⌄
/*
select (swap_to_amount/swap_from_amount) as arbitrage (swap_to_amount/swap_from_amount) 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
*/
select arb_outcome, count(tx_id) as n_txn
from (select tx_id ,(swap_to_amount/swap_from_amount) as arbitrage, ((swap_to_amount-swap_from_amount)/swap_from_amount)*100 as percent_gain, case when percent_gain>=1 then '1% gain or more'
else 'less than 1%' end as arb_outcome
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 1
Run a query to Download Data