Skip to main content

​
Tables

​
TipsDistribution_Claim

Tip claim transactions from Jito’s MEV (Maximal Extractable Value) rewards distribution program on Solana. Records merkle-proof-verified claims by validators and stakers withdrawing their earned tip rewards with claimant addresses and lamport amounts.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
in_claimStatusSTRINGSolana account address tracking the claim status for this tip distribution. This account stores whether the claimant has already withdrawn their tips from the merkle tree.
in_claimantSTRINGSolana address of the recipient claiming MEV (Maximal Extractable Value) tips from the Jito distribution program. Typically represents validators or stakers eligible for tip rewards based on merkle proof verification.
in_configSTRINGConfiguration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
in_merkleRootUploadAuthoritySTRINGSolana address authorized to upload merkle roots for the tip distribution program. This account controls which merkle trees are used to verify claim eligibility.
in_payerSTRINGAddress of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_systemProgramSTRINGAddress of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
in_tipDistributionAccountSTRINGAccount address of the Jito tip distribution from which MEV (Maximum Extractable Value) rewards are being claimed. Each distribution represents a specific reward period for validators and stakers.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_bumpSTRINGProgram-derived address (PDA) bump seed used to derive the claim status account. Numeric value (typically 239-255) ensuring unique account generation in the Jito tips distribution system.
in_bumpin_payerin_amountin_configblock_slotin_claimantsurrogate_keyin_claimStatustransaction_idblock_timestampin_systemPrograminstruction_typeexecuting_accountinstruction_indextransaction_indextransaction_signerouter_executing_accountouter_instruction_indexin_tipDistributionAccountin_merkleRootUploadAuthority
2556jWg4ostJobnqLMCUBkussarDesNFqFJj1nFqim1xgWB14563276STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6344658016Cw4KPufX1Vk7Lkh1cLQo444DHezbzeHtS5Zrf1GAZAyn344658016-4PYhgK9vwvZRxNvRUELAKNn1RLSmM2RDPrmc2u5aNfoshQtcVqKKSSDBNsVRFMDYrap2DX6gn3f1ccfaYodLi4sx-2-02NFctp7CrAY2ZhcTX5hXiQ4bJ2ZiDkgkmVeD4wZmt9rU4PYhgK9vwvZRxNvRUELAKNn1RLSmM2RDPrmc2u5aNfoshQtcVqKKSSDBNsVRFMDYrap2DX6gn3f1ccfaYodLi4sx2025-06-04T23:05:54.000Z11111111111111111111111111111111Claim4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r70335EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vhRouterBmuRBkPUbgEDMtdvTZ75GBdSREZR5uGUxxxpb23ReoAfpttxjXCYrH8SfK7BkoVMMdw378DRfqzjQ7xpvj8F4jGUmxF36vQ6yabnsxX6AQVXdKBhs8kGSUuRKSg8Xt
2546jWg4ostJobnqLMCUBkussarDesNFqFJj1nFqim1xgWB1701660STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6344658017D4HsQLZRW6MoHEVoLN6jztRbsyg5qaHsGtYabBpa23ru344658017-57eYYyCrvPvkyzobvBob8yhJ9Aem23bwhvHfwocDKBnEUrGQY1HFkNamh4ZSMtGK4DovtVY1CAFCVtRbkekXv2KB-2-0FxhY5BRr3DC2UZGJo8dL5pLCpa1kv5en97vooZz44zTV57eYYyCrvPvkyzobvBob8yhJ9Aem23bwhvHfwocDKBnEUrGQY1HFkNamh4ZSMtGK4DovtVY1CAFCVtRbkekXv2KB2025-06-04T23:05:55.000Z11111111111111111111111111111111Claim4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7036EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vhRouterBmuRBkPUbgEDMtdvTZ75GBdSREZR5uGUxxxpb23ReoAfpttxjXCYrH8SfK7BkoVMMdw378DRfqzjQ7xpvj8F4jGUmxF36vQ6yabnsxX6AQVXdKBhs8kGSUuRKSg8Xt
2546jWg4ostJobnqLMCUBkussarDesNFqFJj1nFqim1xgWB70467STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu63445728562Cs4udv76yEi6htEnbVqy3nFdkDtZrVS5JL3iyo32jcR344572856-4kyw3kbJQ186QVU1YMe4Tyuh93gcujE4mJGyXyp99dyPkQpEuHgPbgrWaRuNrLyTgrTvgCPoSRjx2yLjHBWkPuqV-2-08N8Mfq2x343fSgeNcQYvR2Rss3taGVvdaeiXmyqqMcEz4kyw3kbJQ186QVU1YMe4Tyuh93gcujE4mJGyXyp99dyPkQpEuHgPbgrWaRuNrLyTgrTvgCPoSRjx2yLjHBWkPuqV2025-06-04T13:47:58.000Z11111111111111111111111111111111Claim4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r70161EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vhRouterBmuRBkPUbgEDMtdvTZ75GBdSREZR5uGUxxxpb25Gh9BUvyMBsD8rAjjzj9FmamuSBrsYAg7oKrBE8MLEPn8F4jGUmxF36vQ6yabnsxX6AQVXdKBhs8kGSUuRKSg8Xt
Query with partition filter
SELECT *
FROM `tt-contracts.jito_v1_solana.TipsDistribution_Claim`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
TipsDistribution_Claim_instruction

Claim instruction records from Jito’s MEV tip distribution program on Solana, tracking merkle proof-based reward claims by validators and stakers. Used for analyzing tip distribution patterns and claimant behavior in Jito’s maximal extractable value (MEV) sharing system.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
in_claimStatusSTRINGAccount address tracking the claim status for this specific tip distribution claim. Base58-encoded Solana account identifier unique to each claimant’s withdrawal request.
in_claimantSTRINGSolana account address of the user claiming MEV tips from Jito’s tip distribution program. Base58-encoded public key that receives the distributed tip amount.
in_configSTRINGConfiguration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
in_merkleRootUploadAuthoritySTRINGSolana account address authorized to upload merkle roots to the Jito tip distribution program. Base58-encoded public key that controls which merkle proofs can be used for tip claims.
in_payerSTRINGAddress of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_systemProgramSTRINGAddress of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
in_tipDistributionAccountSTRINGSolana account address that holds the MEV (Maximal Extractable Value) tip distribution details for a specific epoch or batch. Used to track and validate claim eligibility against merkle proofs.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_bumpSTRINGProgram-derived address (PDA) bump seed used to derive the claim status account. Numeric value typically ranging from 238-242 that ensures deterministic account generation.
in_bumpin_payerin_amountin_configblock_slotin_claimantsurrogate_keyin_claimStatustransaction_idblock_timestampin_systemPrograminstruction_typeexecuting_accountinstruction_indextransaction_indextransaction_signerouter_executing_accountouter_instruction_indexin_tipDistributionAccountin_merkleRootUploadAuthority
2381111111111111111111111111111111116896STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6287478257GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib287478257-2ay1JMjjSYXq7v8PxzbmcxY9BMuCX1wwaZADoCw7UbC5adb6U5AK91bLbA8cCnCHgAZSp9ETdH19fKaL9mTH2CTx-23NeB23AnWUB2cUnve9LyrrVssXFaGmWzefSXjcbjjE2E2ay1JMjjSYXq7v8PxzbmcxY9BMuCX1wwaZADoCw7UbC5adb6U5AK91bLbA8cCnCHgAZSp9ETdH19fKaL9mTH2CTx2024-09-03T04:02:39.000ZClaim4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r72272GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDibFbLgU3dpkWV2GzYpHCeL91yoJ6QE6iixZNeHfvwXCKWuFWahwdRY7WDhmAqDEHisECyvUM79wx8EW6vpR7MJxzTn
2381111111111111111111111111111111112402140STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6287534084GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib287534084-3dsAdromG5L9W2gytY86whZru1uZDHpqw1SnpUJPpQjrnz5vqiC59DtBLtBk4ss86JtfpnfdfkkLUoAoa4EQ9jgz-29cHwpFjU5uwkqM8qeakwAJQnz33rrAefQVXgqxY2eza93dsAdromG5L9W2gytY86whZru1uZDHpqw1SnpUJPpQjrnz5vqiC59DtBLtBk4ss86JtfpnfdfkkLUoAoa4EQ9jgz2024-09-03T10:33:22.000ZClaim4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7291GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDibDP3gAKpKFuwRt4tqsS3GxaCkTb5QqbTYt7BLFyDPRatJCw7ekTC4mQFSdRyMxPJTW7o7i4mpvTxpi4YATqR6o5Mm
2391111111111111111111111111111111115956STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6287527657GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib287527657-9otoxkhM3j6BwjcMNTVoGVDy3swVwg5dzHsp7ZLhV7gM2HR8LP7CbaiwC9xa6BwbNhcXZdyvV54fv3REL3k5HNu-25FfkNDc9h1yEeAfzDiNd8K6zodsVfMJZwqEhYsPnXNfy9otoxkhM3j6BwjcMNTVoGVDy3swVwg5dzHsp7ZLhV7gM2HR8LP7CbaiwC9xa6BwbNhcXZdyvV54fv3REL3k5HNu2024-09-03T09:48:46.000ZClaim4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r72132GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib5aeeZ1GNU6k6sC2vBjdYpgTZ3TSdZroUv3FRxzaUtQAEByT4w3B7RVYjJGNYBcLKJgFfMWmhgFxHgqMoHBnBvZ84
Query with partition filter
SELECT *
FROM `tt-contracts.jito_v1_solana.TipsDistribution_Claim_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100