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-01-28 08:00:00.000 | 3 | 1338625 | 0.00003 | 13.38625 | 0.00530004 | 14471.958858304 | 0.282122991 | 232278.291865232 | 0.276792951 | 217792.946756928 |
2 | 2025-01-28 07:00:00.000 | 695 | 1338622 | 0.00695 | 13.38622 | 4.587676115 | 14471.953558264 | 66.768670921 | 232278.009742241 | 62.174044806 | 217792.669963977 |
3 | 2025-01-28 06:00:00.000 | 1907 | 1337927 | 0.01907 | 13.37927 | 12.549516087 | 14467.365882149 | 143.874140341 | 232211.24107132 | 131.305554254 | 217730.495919171 |
4 | 2025-01-28 05:00:00.000 | 1610 | 1336020 | 0.0161 | 13.3602 | 18.614014163 | 14454.816366062 | 232.92421498 | 232067.366930979 | 214.294100817 | 217599.190364917 |
5 | 2025-01-28 04:00:00.000 | 1988 | 1334410 | 0.01988 | 13.3441 | 37.569800392 | 14436.202351899 | 573.185648247 | 231834.442715999 | 535.595967855 | 217384.8962641 |
6 | 2025-01-28 03:00:00.000 | 1890 | 1332422 | 0.0189 | 13.32422 | 23.331295449 | 14398.632551507 | 318.232123356 | 231261.257067752 | 294.881927907 | 216849.300296245 |
7 | 2025-01-28 02:00:00.000 | 1989 | 1330532 | 0.01989 | 13.30532 | 22.506938024 | 14375.301256058 | 266.045414301 | 230943.024944396 | 243.518586277 | 216554.418368338 |
8 | 2025-01-28 01:00:00.000 | 1780 | 1328543 | 0.0178 | 13.28543 | 20.921771856 | 14352.794318034 | 274.498590861 | 230676.979530095 | 253.559019005 | 216310.899782061 |
9 | 2025-01-28 00:00:00.000 | 2076 | 1326763 | 0.02076 | 13.26763 | 27.358585527 | 14331.872546178 | 332.415293468 | 230402.480939234 | 305.035947941 | 216057.340763056 |
10 | 2025-01-27 23:00:00.000 | 1839 | 1324687 | 0.01839 | 13.24687 | 20.214221525 | 14304.513960651 | 234.399428971 | 230070.065645766 | 214.166817446 | 215752.304815115 |
11 | 2025-01-27 22:00:00.000 | 2484 | 1322848 | 0.02484 | 13.22848 | 32.923637115 | 14284.299739126 | 442.013875785 | 229835.666216795 | 409.06539867 | 215538.137997669 |
12 | 2025-01-27 21:00:00.000 | 2793 | 1320364 | 0.02793 | 13.20364 | 59.9106188 | 14251.376102011 | 929.761166774 | 229393.65234101 | 869.822617974 | 215129.072598999 |
13 | 2025-01-27 20:00:00.000 | 2378 | 1317571 | 0.02378 | 13.17571 | 25.396123063 | 14191.465483211 | 311.303505039 | 228463.891174236 | 285.883601976 | 214259.249981025 |
14 | 2025-01-27 19:00:00.000 | 2686 | 1315193 | 0.02686 | 13.15193 | 35.814268897 | 14166.069360148 | 460.011220053 | 228152.587669197 | 424.170091156 | 213973.366379049 |
15 | 2025-01-27 18:00:00.000 | 2222 | 1312507 | 0.02222 | 13.12507 | 21.818020054 | 14130.255091251 | 255.046770892 | 227692.576449144 | 233.206530838 | 213549.196287893 |
16 | 2025-01-27 17:00:00.000 | 2230 | 1310285 | 0.0223 | 13.10285 | 26.700131421 | 14108.437071197 | 373.846842429 | 227437.529678252 | 347.124411008 | 213315.989757055 |
17 | 2025-01-27 16:00:00.000 | 1941 | 1308055 | 0.01941 | 13.08055 | 19.515946853 | 14081.736939776 | 230.390562243 | 227063.682835823 | 210.85520539 | 212968.865346047 |
18 | 2025-01-27 15:00:00.000 | 2067 | 1306114 | 0.02067 | 13.06114 | 19.037108202 | 14062.220992923 | 247.368486891 | 226833.29227358 | 228.310708689 | 212758.010140657 |
19 | 2025-01-27 14:00:00.000 | 2209 | 1304047 | 0.02209 | 13.04047 | 22.038242561 | 14043.183884721 | 267.594662831 | 226585.923786689 | 245.53433027 | 212529.699431968 |
20 | 2025-01-27 13:00:00.000 | 1601 | 1301838 | 0.01601 | 13.01838 | 15.060798903 | 14021.14564216 | 188.395886019 | 226318.329123858 | 173.319077116 | 212284.165101698 |
marque6y Sandwich - v1.3 - aggregated SOL
Updated 2025-01-28
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: 26 days ago
...
490
69KB
896s