keshanSolana Jupiter arbs 3
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select swap_size, count(swap_size)
from (select
(swap_to_amount - swap_from_amount) as amount,
(case
when (swap_from_amount) >= 100 and (swap_from_amount) <= 500 then '100 - 500 USD'
when (swap_from_amount) > 500 and (swap_from_amount) <= 1000 then '500 - 1000 USD'
when (swap_from_amount) > 1000 and (swap_from_amount) <= 10000 then '1000 - 10000 USD'
when (swap_from_amount) > 10000 and (swap_from_amount) <= 1000000 then '10000 - 1M USD'
when (swap_from_amount) > 1000000 then '1M+ USD' end) as swap_size
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 swap_size