Jito Tips Inner Events score V3

Pine AnalyticsJito Tips Inner Events score V3

Updated 2025-04-11

WITH tab1 AS (

SELECT tx_id, amount

FROM solana.core.fact_transfers

WHERE tx_to IN (

'96gYZGLnJYVFmbjzopPSU6QiEV5fGqZNyN9nmNhvrZU5',

'HFqU5x63VTqvQss8hp11i4wVV8bD44PvwucfZ2bU7gRe',

'Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY',

'ADaUMid9yfUytqMBgopwjb2DTLSokTSzL1zt6iGPaS49',

'DfXygSm4jCyNCybVYYK6DwvWqjKee8pbDmJGcLWNDXjh',

'ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt',

'DttWaMuVvTiduZRnguLF7jNxTgiMBZ1hyAumKUiL2KRL',

'3AVi9Tg9Uo68tJfuvoKvqKNWKkC5wPdSSdeBnizKZ6jT'

)

AND block_timestamp between '2024-10-10' and '2024-10-17'

AND mint = 'So11111111111111111111111111111111111111111'

AND NOT index IN (0, 1)

), tab0 as (

select tx_id

FROM solana.core.fact_events

WHERE block_timestamp between '2024-10-10' and '2024-10-17'

AND tx_id IN (SELECT tx_id FROM tab1)

and program_id in (

'CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK', -- Raydium CLMM

'675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8', -- Raydium v4

'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY', -- Phoenix

'pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEA', -- Pumpswap

'oreV2ZymfyeXgNgBdqMkumTqqAprVqgBWQfoYkrtKWQ', -- Ore Events

'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4', -- Jupiter v6

'SoLFiHG9TfgtdUXUjWAxi3LtvYuFyDLVhBWxdMZxyCe', -- Solfi Events

'ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD', -- Zeta Events

'LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo', -- Meteora Events

'whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc', -- Orca Whirlpool

'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD', -- Kamino Lend

'stkitrT1Uoy18Dk1fTrgPw8W6MVzoCfYoAFT4MLsmhq', -- Sanctum Router

'j1o2qRpjcyUwEvwtcfhEQefh773ZgjxcVRry7LDqg5X', -- Jupiter Limit Order

'2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c', -- Lifinity

Last run: 18 days ago

587B

122s

flipside