jito_v1_solana

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position 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_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_claimStatus`	`STRING`	Solana 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_claimant`	`STRING`	Solana 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_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_merkleRootUploadAuthority`	`STRING`	Solana address authorized to upload merkle roots for the tip distribution program. This account controls which merkle trees are used to verify claim eligibility.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_tipDistributionAccount`	`STRING`	Account 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_bump`	`STRING`	Program-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.

Sample Data

in_bump	in_payer	in_amount	in_config	block_slot	in_claimant	surrogate_key	in_claimStatus	transaction_id	block_timestamp	in_systemProgram	instruction_type	executing_account	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index	in_tipDistributionAccount	in_merkleRootUploadAuthority
255	6jWg4ostJobnqLMCUBkussarDesNFqFJj1nFqim1xgWB	14563276	STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6	344658016	Cw4KPufX1Vk7Lkh1cLQo444DHezbzeHtS5Zrf1GAZAyn	344658016-4PYhgK9vwvZRxNvRUELAKNn1RLSmM2RDPrmc2u5aNfoshQtcVqKKSSDBNsVRFMDYrap2DX6gn3f1ccfaYodLi4sx-2-0	2NFctp7CrAY2ZhcTX5hXiQ4bJ2ZiDkgkmVeD4wZmt9rU	4PYhgK9vwvZRxNvRUELAKNn1RLSmM2RDPrmc2u5aNfoshQtcVqKKSSDBNsVRFMDYrap2DX6gn3f1ccfaYodLi4sx	2025-06-04T23:05:54.000Z	11111111111111111111111111111111	Claim	4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7	335	EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vh	RouterBmuRBkPUbgEDMtdvTZ75GBdSREZR5uGUxxxpb	2	3ReoAfpttxjXCYrH8SfK7BkoVMMdw378DRfqzjQ7xpvj	8F4jGUmxF36vQ6yabnsxX6AQVXdKBhs8kGSUuRKSg8Xt
254	6jWg4ostJobnqLMCUBkussarDesNFqFJj1nFqim1xgWB	1701660	STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6	344658017	D4HsQLZRW6MoHEVoLN6jztRbsyg5qaHsGtYabBpa23ru	344658017-57eYYyCrvPvkyzobvBob8yhJ9Aem23bwhvHfwocDKBnEUrGQY1HFkNamh4ZSMtGK4DovtVY1CAFCVtRbkekXv2KB-2-0	FxhY5BRr3DC2UZGJo8dL5pLCpa1kv5en97vooZz44zTV	57eYYyCrvPvkyzobvBob8yhJ9Aem23bwhvHfwocDKBnEUrGQY1HFkNamh4ZSMtGK4DovtVY1CAFCVtRbkekXv2KB	2025-06-04T23:05:55.000Z	11111111111111111111111111111111	Claim	4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7	36	EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vh	RouterBmuRBkPUbgEDMtdvTZ75GBdSREZR5uGUxxxpb	2	3ReoAfpttxjXCYrH8SfK7BkoVMMdw378DRfqzjQ7xpvj	8F4jGUmxF36vQ6yabnsxX6AQVXdKBhs8kGSUuRKSg8Xt
254	6jWg4ostJobnqLMCUBkussarDesNFqFJj1nFqim1xgWB	70467	STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6	344572856	2Cs4udv76yEi6htEnbVqy3nFdkDtZrVS5JL3iyo32jcR	344572856-4kyw3kbJQ186QVU1YMe4Tyuh93gcujE4mJGyXyp99dyPkQpEuHgPbgrWaRuNrLyTgrTvgCPoSRjx2yLjHBWkPuqV-2-0	8N8Mfq2x343fSgeNcQYvR2Rss3taGVvdaeiXmyqqMcEz	4kyw3kbJQ186QVU1YMe4Tyuh93gcujE4mJGyXyp99dyPkQpEuHgPbgrWaRuNrLyTgrTvgCPoSRjx2yLjHBWkPuqV	2025-06-04T13:47:58.000Z	11111111111111111111111111111111	Claim	4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7	161	EG2ziPBR4uc9MzCLxBmnrE7cozKZV8DTvVSxPWXiQ8vh	RouterBmuRBkPUbgEDMtdvTZ75GBdSREZR5uGUxxxpb	2	5Gh9BUvyMBsD8rAjjzj9FmamuSBrsYAg7oKrBE8MLEPn	8F4jGUmxF36vQ6yabnsxX6AQVXdKBhs8kGSUuRKSg8Xt

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position 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_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_claimStatus`	`STRING`	Account address tracking the claim status for this specific tip distribution claim. Base58-encoded Solana account identifier unique to each claimant’s withdrawal request.
`in_claimant`	`STRING`	Solana 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_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_merkleRootUploadAuthority`	`STRING`	Solana 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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_tipDistributionAccount`	`STRING`	Solana 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_bump`	`STRING`	Program-derived address (PDA) bump seed used to derive the claim status account. Numeric value typically ranging from 238-242 that ensures deterministic account generation.

Sample Data

in_bump	in_payer	in_amount	in_config	block_slot	in_claimant	surrogate_key	in_claimStatus	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	in_tipDistributionAccount	in_merkleRootUploadAuthority
238	11111111111111111111111111111111	16896	STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6	287478257	GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib	287478257-2ay1JMjjSYXq7v8PxzbmcxY9BMuCX1wwaZADoCw7UbC5adb6U5AK91bLbA8cCnCHgAZSp9ETdH19fKaL9mTH2CTx-2	3NeB23AnWUB2cUnve9LyrrVssXFaGmWzefSXjcbjjE2E	2ay1JMjjSYXq7v8PxzbmcxY9BMuCX1wwaZADoCw7UbC5adb6U5AK91bLbA8cCnCHgAZSp9ETdH19fKaL9mTH2CTx	2024-09-03T04:02:39.000Z	Claim	4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7	2	272	GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib	FbLgU3dpkWV2GzYpHCeL91yoJ6QE6iixZNeHfvwXCKWu	FWahwdRY7WDhmAqDEHisECyvUM79wx8EW6vpR7MJxzTn
238	11111111111111111111111111111111	12402140	STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6	287534084	GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib	287534084-3dsAdromG5L9W2gytY86whZru1uZDHpqw1SnpUJPpQjrnz5vqiC59DtBLtBk4ss86JtfpnfdfkkLUoAoa4EQ9jgz-2	9cHwpFjU5uwkqM8qeakwAJQnz33rrAefQVXgqxY2eza9	3dsAdromG5L9W2gytY86whZru1uZDHpqw1SnpUJPpQjrnz5vqiC59DtBLtBk4ss86JtfpnfdfkkLUoAoa4EQ9jgz	2024-09-03T10:33:22.000Z	Claim	4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7	2	91	GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib	DP3gAKpKFuwRt4tqsS3GxaCkTb5QqbTYt7BLFyDPRatJ	Cw7ekTC4mQFSdRyMxPJTW7o7i4mpvTxpi4YATqR6o5Mm
239	11111111111111111111111111111111	15956	STGR71TeAeycQUDKzku1GqPQdErQcTcdqxJuQmCjBu6	287527657	GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib	287527657-9otoxkhM3j6BwjcMNTVoGVDy3swVwg5dzHsp7ZLhV7gM2HR8LP7CbaiwC9xa6BwbNhcXZdyvV54fv3REL3k5HNu-2	5FfkNDc9h1yEeAfzDiNd8K6zodsVfMJZwqEhYsPnXNfy	9otoxkhM3j6BwjcMNTVoGVDy3swVwg5dzHsp7ZLhV7gM2HR8LP7CbaiwC9xa6BwbNhcXZdyvV54fv3REL3k5HNu	2024-09-03T09:48:46.000Z	Claim	4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7	2	132	GZctHpWXmsZC1YHACTGGcHhYxjdRqQvTpYkb9LMvxDib	5aeeZ1GNU6k6sC2vBjdYpgTZ3TSdZroUv3FRxzaUtQAE	ByT4w3B7RVYjJGNYBcLKJgFfMWmhgFxHgqMoHBnBvZ84

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

TipsDistribution_Claim

TipsDistribution_Claim_instruction

​Tables

​TipsDistribution_Claim

​TipsDistribution_Claim_instruction

Tables

TipsDistribution_Claim

TipsDistribution_Claim_instruction