DATE | SW_COUNT | SW_COUNT_CUMUL | TX_FEES | TX_FEES_CUMUL | TIPS_JITO | TIPS_JITO_CUMUL | EXTRACTED_VALUE_SOL | EXTRACTED_VALUE_SOL_CUMUL | PROFIT_SOL_NET | PROFIT_SOL_NET_CUMUL | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-27 17:00:00.000 | 1 | 119972 | 0.00001 | 1.184885 | 0.001608799 | 4482.722955617 | 0.025860872 | 51338.120899134 | 0.024242073 | 46854.213058517 |
2 | 2025-03-27 16:00:00.000 | 2 | 119971 | 0.00002 | 1.184875 | 0.010468241 | 4482.721346818 | 0.167149607 | 51338.095038262 | 0.156661366 | 46854.188816444 |
3 | 2025-03-27 15:00:00.000 | 1 | 119969 | 0.00001 | 1.184855 | 0.002349598 | 4482.710878577 | 0.007626578 | 51337.927888655 | 0.00526698 | 46854.032155078 |
4 | 2025-03-27 14:00:00.000 | 3 | 119968 | 0.00003 | 1.184845 | 0.007647654 | 4482.708528979 | 0.122637218 | 51337.920262077 | 0.114959564 | 46854.026888098 |
5 | 2025-03-27 13:00:00.000 | 3 | 119965 | 0.00003 | 1.184815 | 0.036942348 | 4482.700881325 | 0.155049439 | 51337.797624859 | 0.118077091 | 46853.911928534 |
6 | 2025-03-27 12:00:00.000 | 1 | 119962 | 0.00001 | 1.184785 | 0.000715723 | 4482.663938977 | 0.011483977 | 51337.64257542 | 0.010758254 | 46853.793851443 |
7 | 2025-03-27 11:00:00.000 | 1 | 119961 | 0.00001 | 1.184775 | 0.017439875 | 4482.663223254 | 0.279765206 | 51337.631091443 | 0.262315331 | 46853.783093189 |
8 | 2025-03-27 10:00:00.000 | 2 | 119960 | 0.00002 | 1.184765 | 0.004999411 | 4482.645783379 | 0.079147328 | 51337.351326237 | 0.074127917 | 46853.520777858 |
9 | 2025-03-27 08:00:00.000 | 1 | 119958 | 0.00001 | 1.184745 | 0.001855901 | 4482.640783968 | 0.030060248 | 51337.272178909 | 0.028194347 | 46853.446649941 |
10 | 2025-03-27 07:00:00.000 | 2 | 119957 | 0.00002 | 1.184735 | 0.014400805 | 4482.638928067 | 0.2301531 | 51337.242118661 | 0.215732295 | 46853.418455594 |
11 | 2025-03-27 05:00:00.000 | 1 | 119955 | 0.00001 | 1.184715 | 0.001031443 | 4482.624527262 | 0.016356583 | 51337.011965561 | 0.01531514 | 46853.202723299 |
12 | 2025-03-27 03:00:00.000 | 2 | 119954 | 0.00002 | 1.184705 | 0.002073155 | 4482.623495819 | 0.033240357 | 51336.995608978 | 0.031147202 | 46853.187408159 |
13 | 2025-03-27 02:00:00.000 | 1 | 119952 | 0.00001 | 1.184685 | 0.00468951 | 4482.621422664 | 0.075236408 | 51336.962368621 | 0.070536898 | 46853.156260957 |
14 | 2025-03-27 01:00:00.000 | 1 | 119951 | 0.00001 | 1.184675 | 0.000153733 | 4482.616733154 | 0.002453511 | 51336.887132213 | 0.002289778 | 46853.085724059 |
15 | 2025-03-27 00:00:00.000 | 2 | 119950 | 0.00002 | 1.184665 | 0.014042121 | 4482.616579421 | 0.0479989 | 51336.884678702 | 0.033936779 | 46853.083434281 |
16 | 2025-03-26 21:00:00.000 | 5 | 119948 | 0.00005 | 1.184645 | 0.056429951 | 4482.6025373 | 0.731311907 | 51336.836679802 | 0.674831956 | 46853.049497502 |
17 | 2025-03-26 20:00:00.000 | 6 | 119943 | 0.00006 | 1.184595 | 0.005384764 | 4482.546107349 | 0.086892375 | 51336.105367895 | 0.081447611 | 46852.374665546 |
18 | 2025-03-26 19:00:00.000 | 3 | 119937 | 0.00003 | 1.184535 | 0.009967671 | 4482.540722585 | 0.160858982 | 51336.01847552 | 0.150861311 | 46852.293217935 |
19 | 2025-03-26 17:00:00.000 | 3 | 119934 | 0.00003 | 1.184505 | 0.002083509 | 4482.530754914 | 0.02340708 | 51335.857616538 | 0.021293571 | 46852.142356624 |
20 | 2025-03-26 16:00:00.000 | 4 | 119931 | 0.00004 | 1.184475 | 0.070763482 | 4482.528671405 | 0.250511036 | 51335.834209458 | 0.179707554 | 46852.121063053 |
marque6y Sandwich - v1.3 - aggregated SOL
Updated 2025-03-27
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Vpe Sandwhich - v1.3 - aggregated SOL @ https://flipsidecrypto.xyz/studio/queries/ce89f2f8-b563-42b3-8874-20cbea411c97
with
jito_tip_txs as (
select
tx_id as jito_tx_id
, (post_balances[f_accs.index] - pre_balances[f_accs.index]) / pow(10, 9) as tip_jito
from solana.core.fact_events
inner join solana.core.fact_transactions
using(block_timestamp, tx_id, succeeded)
inner join lateral flatten (input => account_keys) f_accs
where succeeded
and fact_events.program_id = 'E6YoRP3adE5XYneSseLee15wJshDxCsmyD2WtLvAmfLi'
and substr(livequery.utils.udf_base58_to_hex(fact_events.instruction :data), 3, 16) = '9c23c76ff5fe2635'
and fact_events.instruction :accounts[3] in ( -- Jito Tip Payment Addresses https://jito-foundation.gitbook.io/mev/mev-payment-and-distribution/on-chain-addresses#mainnet
'96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5'
, 'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe'
, 'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY'
, 'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49'
, 'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh'
, 'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt'
, 'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL'
, '3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'
)
and fact_events.instruction :accounts[3] = f_accs.value :pubkey
and block_timestamp > current_timestamp() - interval '30 days'
union all
select
tx_id as jito_tx_id
Last run: 20 days ago
...
657
88KB
891s