solana_v1_solana

Tables

BPF_Upgrade_instruction

BPF Loader Upgradeable program instructions for upgrading deployed Solana programs, including buffer addresses, program data accounts, and upgrade authorities. Used for tracking on-chain program version changes and governance actions.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`buffer`	`STRING`	Temporary buffer account containing the new program bytecode to be deployed during the upgrade. Once the upgrade completes, this buffer account is typically closed and its lamports reclaimed.
`clock`	`STRING`	Solana sysvar account address providing access to current network time and slot information. Always set to the canonical sysvar address SysvarC1ock11111111111111111111111111111111.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`program_data`	`STRING`	Address of the program data account containing the deployed program’s executable bytecode. This account is created during program deployment and upgraded through BPF Loader upgrade instructions.
`rent`	`STRING`	Program address of the Solana Rent Sysvar. Base58-encoded string, consistently SysvarRent111111111111111111111111111111111.
`spill`	`STRING`	Account address designated to receive any remaining lamports (SOL) after the program upgrade completes. Typically matches the authority or transaction signer address.
`account_arguments`	`JSON`	Ordered list of account addresses involved in the BPF upgrade instruction, including program data, upgradeable program, buffer, and authority accounts. JSON-encoded array of base58-encoded Solana addresses passed to the upgrade instruction.
`args`	`JSON`	Parsed arguments from the instruction’s raw data specific to the BPF Upgrade operation. Typically an empty array for standard upgrade instructions as shown in sample data.
`raw_data`	`STRING`	Raw hex-encoded bytes of the instruction data sent to the BPF Loader Upgradeable program. Contains the encoded instruction discriminator and parameters before parsing into structured fields.

Sample Data

args	rent	clock	spill	buffer	program	raw_data	authority	block_slot	program_data	surrogate_key	transaction_id	block_timestamp	instruction_type	account_arguments	executing_account	transaction_index	transaction_signer
[]	SysvarRent111111111111111111111111111111111	SysvarC1ock11111111111111111111111111111111	TRTNuj8GgjnBSSohYgyJhxF4gkhSscxJ4kDELy9Hdh8	GgNT6FgLWH1ueKPaCwQKfY1oHkmLENjf4dBd5xPZyLf4	EdYp85RTTNJJAFCXuCPc1uoSJuchchxEXr9W39tmktFu	5Sxr3	TRTNuj8GgjnBSSohYgyJhxF4gkhSscxJ4kDELy9Hdh8	163350757	2jqqXo4NgHS6DorkEMzVFRLfLi4qcLraxZtUCexEeiuG	163350757-2gWUAjUiceEVfbLbTQmJ8RRncQa55JCBjEqLd128qq9FbNtwmAVSb8s5zNjeaGiscD1wmQKbPgJ7DweKqBESmj1D-0	2gWUAjUiceEVfbLbTQmJ8RRncQa55JCBjEqLd128qq9FbNtwmAVSb8s5zNjeaGiscD1wmQKbPgJ7DweKqBESmj1D	2022-11-26T20:02:58.000Z	Upgrade	[“2jqqXo4NgHS6DorkEMzVFRLfLi4qcLraxZtUCexEeiuG”,“EdYp85RTTNJJAFCXuCPc1uoSJuchchxEXr9W39tmktFu”,“GgNT6FgLWH1ueKPaCwQKfY1oHkmLENjf4dBd5xPZyLf4”,“TRTNuj8GgjnBSSohYgyJhxF4gkhSscxJ4kDELy9Hdh8”,“SysvarRent111111111111111111111111111111111”,“SysvarC1ock11111111111111111111111111111111”,“TRTNuj8GgjnBSSohYgyJhxF4gkhSscxJ4kDELy9Hdh8”]	BPFLoaderUpgradeab1e11111111111111111111111	12	TRTNuj8GgjnBSSohYgyJhxF4gkhSscxJ4kDELy9Hdh8
[]	SysvarRent111111111111111111111111111111111	SysvarC1ock11111111111111111111111111111111	EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2	E3HKxsSPzZ5zuMkTVm9oFdJCbFvVBvH8f461ZTvUfnTk	8LPjGDbxhW4G2Q8S6FvdvUdfGWssgtqmvsc63bwNFA7E	5Sxr3	EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2	163268352	4F72AMhvh4SAr4noKPwXUB6Sn1sBEfp68A3cS35FejnB	163268352-3ioey6Beh57te9mE3xegwepoz7PSFPs7w82y2nCBf1ko5cRZwZ95ab9EQrvrZEnSaJKYAzVnJtBv6e9jYSbM6Xts-0	3ioey6Beh57te9mE3xegwepoz7PSFPs7w82y2nCBf1ko5cRZwZ95ab9EQrvrZEnSaJKYAzVnJtBv6e9jYSbM6Xts	2022-11-26T09:57:29.000Z	Upgrade	[“4F72AMhvh4SAr4noKPwXUB6Sn1sBEfp68A3cS35FejnB”,“8LPjGDbxhW4G2Q8S6FvdvUdfGWssgtqmvsc63bwNFA7E”,“E3HKxsSPzZ5zuMkTVm9oFdJCbFvVBvH8f461ZTvUfnTk”,“EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2”,“SysvarRent111111111111111111111111111111111”,“SysvarC1ock11111111111111111111111111111111”,“EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2”]	BPFLoaderUpgradeab1e11111111111111111111111	2	EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2
[]	SysvarRent111111111111111111111111111111111	SysvarC1ock11111111111111111111111111111111	EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2	EhX1ZJYFKxwB5TGtpuzRBBnyuUACaPVhz1SY6SuCBUP9	8LPjGDbxhW4G2Q8S6FvdvUdfGWssgtqmvsc63bwNFA7E	5Sxr3	EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2	163333572	4F72AMhvh4SAr4noKPwXUB6Sn1sBEfp68A3cS35FejnB	163333572-5j77EpBFwfPpHUY2eFM4qBvfF49CZ4grfkDxs76iazN4odu36nSpFHmgAjJv3YePLbGj5ktiQfANywkoAy7Jp5u6-0	5j77EpBFwfPpHUY2eFM4qBvfF49CZ4grfkDxs76iazN4odu36nSpFHmgAjJv3YePLbGj5ktiQfANywkoAy7Jp5u6	2022-11-26T17:57:29.000Z	Upgrade	[“4F72AMhvh4SAr4noKPwXUB6Sn1sBEfp68A3cS35FejnB”,“8LPjGDbxhW4G2Q8S6FvdvUdfGWssgtqmvsc63bwNFA7E”,“EhX1ZJYFKxwB5TGtpuzRBBnyuUACaPVhz1SY6SuCBUP9”,“EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2”,“SysvarRent111111111111111111111111111111111”,“SysvarC1ock11111111111111111111111111111111”,“EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2”]	BPFLoaderUpgradeab1e11111111111111111111111	36	EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.BPF_Upgrade_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_Authorize_instruction

Solana native staking authority transfer instructions from the Stake Program, recording changes to Staker and Withdrawer permissions on stake accounts. Used for tracking stake account ownership transitions and validator delegation authority changes.

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_authority`	`STRING`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_authorityType`	`STRING`	Account permission type being reassigned, either “Staker” (for delegating/undelegating) or “Withdrawer” (for withdrawing funds from the stake account). Determines which authorization role the new authority will control.
`in_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_newAuthority`	`STRING`	Account address of the new authority being assigned to the stake account. Base58-encoded Solana public key that will gain Staker or Withdrawer permissions as specified in the authorization.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.

Sample Data

block_slot	in_authority	surrogate_key	in_clockSysvar	transaction_id	block_timestamp	in_newAuthority	in_stakeAccount	in_authorityType	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
207746314	7zCARko7TYUEY6cyuDAAaz3K8Y8xrroPWQEKQ6tdmob2	207746314-3wzonPvdFBduXCrQj21aJCGwBTASgnvGWVc1S6hZ5Np4EcVgrN6EysCFUg3nCGPyugzuX1uBmEmEeiM3tBwadJhY-0	SysvarC1ock11111111111111111111111111111111	3wzonPvdFBduXCrQj21aJCGwBTASgnvGWVc1S6hZ5Np4EcVgrN6EysCFUg3nCGPyugzuX1uBmEmEeiM3tBwadJhY	2023-07-27T03:57:57.000Z	74opVa3v51hUmTrsZn8YusZw4fXB16vGQY4WYHt9UegR	BXsR3hxi25vwgSCu9E1J8cJnos9JXkkSX5MZccp3C5m8	Staker	Authorize	Stake11111111111111111111111111111111111111	0	18	7zCARko7TYUEY6cyuDAAaz3K8Y8xrroPWQEKQ6tdmob2
207746314	7zCARko7TYUEY6cyuDAAaz3K8Y8xrroPWQEKQ6tdmob2	207746314-3wzonPvdFBduXCrQj21aJCGwBTASgnvGWVc1S6hZ5Np4EcVgrN6EysCFUg3nCGPyugzuX1uBmEmEeiM3tBwadJhY-1	SysvarC1ock11111111111111111111111111111111	3wzonPvdFBduXCrQj21aJCGwBTASgnvGWVc1S6hZ5Np4EcVgrN6EysCFUg3nCGPyugzuX1uBmEmEeiM3tBwadJhY	2023-07-27T03:57:57.000Z	74opVa3v51hUmTrsZn8YusZw4fXB16vGQY4WYHt9UegR	BXsR3hxi25vwgSCu9E1J8cJnos9JXkkSX5MZccp3C5m8	Withdrawer	Authorize	Stake11111111111111111111111111111111111111	1	18	7zCARko7TYUEY6cyuDAAaz3K8Y8xrroPWQEKQ6tdmob2
207751651	7zCARko7TYUEY6cyuDAAaz3K8Y8xrroPWQEKQ6tdmob2	207751651-5zkyNiMdJQ9Kk3FF2dUoT2UmJRr3i8xXFzmiaKs3STcs9p5iurbrnVH9i2PSvfQQ9YHGs4P6t2H3aPpumMBb2WiY-0	SysvarC1ock11111111111111111111111111111111	5zkyNiMdJQ9Kk3FF2dUoT2UmJRr3i8xXFzmiaKs3STcs9p5iurbrnVH9i2PSvfQQ9YHGs4P6t2H3aPpumMBb2WiY	2023-07-27T04:36:50.000Z	74opVa3v51hUmTrsZn8YusZw4fXB16vGQY4WYHt9UegR	4dZdTfzqDh4uyADMLViTLRAQMNnFUXjHSSTacmjDx4xD	Staker	Authorize	Stake11111111111111111111111111111111111111	0	31	7zCARko7TYUEY6cyuDAAaz3K8Y8xrroPWQEKQ6tdmob2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_Authorize_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_AuthorizeChecked_instruction

Solana native staking authority change instructions that transfer control of stake accounts by updating staker or withdrawer permissions. Used for analyzing stake delegation flows and validator custody transfers.

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_authority`	`STRING`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_authorityType`	`STRING`	Account permission type being modified, either “Staker” for delegation control or “Withdrawer” for fund withdrawal rights. This parameter determines which authority role is being reassigned to the new authority address.
`in_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_newAuthority`	`STRING`	Account address of the newly authorized signer being assigned to the stake account. Base58-encoded Solana public key replacing the existing authority for staking or withdrawal operations.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.

Sample Data

block_slot	in_authority	surrogate_key	in_clockSysvar	transaction_id	block_timestamp	in_newAuthority	in_stakeAccount	in_authorityType	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
281430464	2Pp61NRtTDgpzMZJRme5mZrkskduYhZMbZ1yfet1suce	281430464-46qu6p1Ute2XtP3kjAvdZwX3PryBW5XmoqacDhKr5JV4tDgJwrgcwuSNR2N424vK8JCJM6ySyFsfedpwJMQVU7ZV-0	SysvarC1ock11111111111111111111111111111111	46qu6p1Ute2XtP3kjAvdZwX3PryBW5XmoqacDhKr5JV4tDgJwrgcwuSNR2N424vK8JCJM6ySyFsfedpwJMQVU7ZV	2024-08-04T02:24:00.000Z	EuFGYR8gvg5SknEnYj8iGneaHWNkGvhYrE5ydvXvLpfX	2pmLr4SWsubn25mpwkwTDqT1mBTMAY6CUCzs1v8ihMp5	Staker	AuthorizeChecked	Stake11111111111111111111111111111111111111	0	8	EuFGYR8gvg5SknEnYj8iGneaHWNkGvhYrE5ydvXvLpfX
281430464	2Pp61NRtTDgpzMZJRme5mZrkskduYhZMbZ1yfet1suce	281430464-46qu6p1Ute2XtP3kjAvdZwX3PryBW5XmoqacDhKr5JV4tDgJwrgcwuSNR2N424vK8JCJM6ySyFsfedpwJMQVU7ZV-1	SysvarC1ock11111111111111111111111111111111	46qu6p1Ute2XtP3kjAvdZwX3PryBW5XmoqacDhKr5JV4tDgJwrgcwuSNR2N424vK8JCJM6ySyFsfedpwJMQVU7ZV	2024-08-04T02:24:00.000Z	EuFGYR8gvg5SknEnYj8iGneaHWNkGvhYrE5ydvXvLpfX	2pmLr4SWsubn25mpwkwTDqT1mBTMAY6CUCzs1v8ihMp5	Withdrawer	AuthorizeChecked	Stake11111111111111111111111111111111111111	1	8	EuFGYR8gvg5SknEnYj8iGneaHWNkGvhYrE5ydvXvLpfX
281430008	5yHqB3NxovCEMUniQCboaPRMyyQ7kQQF4QqvC4vaz78z	281430008-4vmSjSz5W5WMkJajYJzda1YmAuj1ciGKb8fw7mh2NwrTaVK7RxZF1bMUWR5YWZ4cvomS8PnyBYfHYuuR7vgjD94P-1	SysvarC1ock11111111111111111111111111111111	4vmSjSz5W5WMkJajYJzda1YmAuj1ciGKb8fw7mh2NwrTaVK7RxZF1bMUWR5YWZ4cvomS8PnyBYfHYuuR7vgjD94P	2024-08-04T02:20:31.000Z	FLVgaCPvSGFguumN9ao188izB4K4rxSWzkHneQMtkwQJ	ESmVgZiTK7VAdcpNtKgYGRMiLLhKeoWRACx9NHkavKXJ	Withdrawer	AuthorizeChecked	Stake11111111111111111111111111111111111111	1	31	FLVgaCPvSGFguumN9ao188izB4K4rxSWzkHneQMtkwQJ

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_AuthorizeChecked_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_AuthorizeWithSeed_instruction

Solana stake account authorization changes using seed-derived authorities, capturing withdrawer and staker permission updates with base addresses and seeds. Used for tracking programmatic stake account control transfers and validator delegation management.

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_authorityBase`	`STRING`	Base account address used to derive the stake authority through program-derived address (PDA) generation. Combined with seed and owner to create the authorizing account for this instruction.
`in_authorityOwner`	`STRING`	Program that owns the authority base account used to derive the signing authority. Typically the Stake program address (Stake11111111111111111111111111111111111111) for seed-based stake account authorities.
`in_authoritySeed`	`STRING`	Seed string used to derive the stake authority address from the base public key. Typically a simple numeric string like ‘0’ for sequential account derivation.
`in_authorityType`	`STRING`	Type of stake account authority being changed via seed-derived authorization. Common values include “Withdrawer” and “Staker” roles.
`in_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_newAuthorized`	`STRING`	Address of the new authority account being assigned to the stake account. Represents the replacement for the existing stake or withdraw authority based on the authorization type.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.

Sample Data

block_slot	surrogate_key	transaction_id	block_timestamp	in_stakeAccount	in_authorityBase	in_authorityType	in_newAuthorized	instruction_type	executing_account	in_authorityOwner	instruction_index	transaction_index	transaction_signer
61301541	61301541-2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ-1	2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ	2021-01-19T01:37:02.000Z	HVhNcBHUCQTgRxRbHVJ1qj7Ey3VwUbQWPMvdMQzJcXAu	5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw	Withdrawer	7kgfDmgbEfypBujqn4tyApjf8H7ZWuaL3F6Ah9vQHzgR	AuthorizeWithSeed	Stake11111111111111111111111111111111111111	Stake11111111111111111111111111111111111111	1	275	5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw
61301541	61301541-2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ-1	2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ	2021-01-19T01:37:02.000Z	HVhNcBHUCQTgRxRbHVJ1qj7Ey3VwUbQWPMvdMQzJcXAu	5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw	Withdrawer	7kgfDmgbEfypBujqn4tyApjf8H7ZWuaL3F6Ah9vQHzgR	AuthorizeWithSeed	Stake11111111111111111111111111111111111111	Stake11111111111111111111111111111111111111	1	275	5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw
61301541	61301541-2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ-1	2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ	2021-01-19T01:37:02.000Z	HVhNcBHUCQTgRxRbHVJ1qj7Ey3VwUbQWPMvdMQzJcXAu	5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw	Withdrawer	7kgfDmgbEfypBujqn4tyApjf8H7ZWuaL3F6Ah9vQHzgR	AuthorizeWithSeed	Stake11111111111111111111111111111111111111	Stake11111111111111111111111111111111111111	1	275	5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_AuthorizeWithSeed_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_Deactivate_instruction

Deactivate stake account instructions from Solana’s native staking program, recording when validators or delegators initiate unstaking of SOL tokens. Used for analyzing staking behavior, validator delegation changes, and network participation trends.

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_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.
`in_stakeAuthority`	`STRING`	Account address authorized to perform stake operations on the stake account. Base58-encoded Solana public key.

Sample Data

block_slot	surrogate_key	in_clockSysvar	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	in_stakeAuthority	transaction_signer
117512322	117512322-4CU6UYXJtUhUFuhJwwmCp7hcDoAiYdHJkC1DqHpcQGrJgrL5fUTBudngTx8xpP9kQW4GJmTNFpKKJgZF1NHHA5DU-0	SysvarC1ock11111111111111111111111111111111	4CU6UYXJtUhUFuhJwwmCp7hcDoAiYdHJkC1DqHpcQGrJgrL5fUTBudngTx8xpP9kQW4GJmTNFpKKJgZF1NHHA5DU	2022-01-23T19:59:24.000Z	tf59FkdUui9XWZxoKwK2K86RY5pcv5ZH1wG9n7rXfhj	Deactivate	Stake11111111111111111111111111111111111111	6Ldpww3gVC5SzE7UKMgaT8vmM8yPtmUgtbHQu4YZ9Lih	6Ldpww3gVC5SzE7UKMgaT8vmM8yPtmUgtbHQu4YZ9Lih
117473944	117473944-5crSynAaVSWgQTZHCHn3ALcXeZQMNQaQvL6hHsRAyp5YHe4NaVp2c2chS7oYraSeyBXS7nf5PQFc9vAqhCRiVYqP-0	SysvarC1ock11111111111111111111111111111111	5crSynAaVSWgQTZHCHn3ALcXeZQMNQaQvL6hHsRAyp5YHe4NaVp2c2chS7oYraSeyBXS7nf5PQFc9vAqhCRiVYqP	2022-01-23T14:04:19.000Z	6NftWaYV6m3iGsjeuC3e1J2L7We1GYVZG7xh7CvPYJU6	Deactivate	Stake11111111111111111111111111111111111111	7V5fqQKrgNoAtjsKchKfuZxLQyc8mWwZPtN5WrWDDKeh	7V5fqQKrgNoAtjsKchKfuZxLQyc8mWwZPtN5WrWDDKeh
117386202	117386202-3ZiweuhXDdjgvUkgrkL7cRUe6j9uLvdj17G2cER6MdR3MaFr29TaKoG3jmbrBLdbtFSNNZsV7rfheNd4YtENct8U-0	SysvarC1ock11111111111111111111111111111111	3ZiweuhXDdjgvUkgrkL7cRUe6j9uLvdj17G2cER6MdR3MaFr29TaKoG3jmbrBLdbtFSNNZsV7rfheNd4YtENct8U	2022-01-23T00:33:18.000Z	DM4wiXRt9RCST3FkTPVX28EcRf3ThUtB3tiTcsfPeyZn	Deactivate	Stake11111111111111111111111111111111111111	9sp8rqBBLcNi2hAJY3kS8sFgPKCwthxBTW3FCequX7PN	9sp8rqBBLcNi2hAJY3kS8sFgPKCwthxBTW3FCequX7PN

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_Deactivate_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_DeactivateDelinquent_instruction

Solana native staking program instructions that deactivate stake accounts delegated to delinquent validators who have not voted recently. Used to analyze validator performance monitoring and forced stake reallocation by comparing delinquent vote accounts against reference vote accounts.

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_referenceVoteAccount`	`STRING`	Vote account address used as the reference for determining delinquency status in this instruction. This account must be currently active and up-to-date for the deactivation to succeed.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.
`in_voteAccount`	`STRING`	Address of the validator’s vote account to which stake is delegated or associated. Base58-encoded Solana public key.

Sample Data

block_slot	surrogate_key	in_voteAccount	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	in_referenceVoteAccount
312336464	312336464-2bVhCbLN8kxTdPjGnvSYdQrpvK8pVL9ACDSH2b6zSwX7cSk68A8AioR3cJuWL9zVeJRmehdopivcfbmAmtrBePAX-21	GTi71VkpXq9CFSt6heWiAkwndPQertmtXwrRJAwLG2uj	2bVhCbLN8kxTdPjGnvSYdQrpvK8pVL9ACDSH2b6zSwX7cSk68A8AioR3cJuWL9zVeJRmehdopivcfbmAmtrBePAX	2025-01-06T23:10:08.000Z	88zCu7zFzF3CgRuBR2dS7Qc5HELDRB46t1oUGJHaDreX	DeactivateDelinquent	Stake11111111111111111111111111111111111111	21	313	GiYGtz42bh1sLKvCxw3PNzvS6FAwB4ciNejLi5CpHPgr	BLADE1qNA1uNjRgER6DtUFf7FU3c1TWLLdpPeEcKatZ2
312336464	312336464-2bVhCbLN8kxTdPjGnvSYdQrpvK8pVL9ACDSH2b6zSwX7cSk68A8AioR3cJuWL9zVeJRmehdopivcfbmAmtrBePAX-12	GTi71VkpXq9CFSt6heWiAkwndPQertmtXwrRJAwLG2uj	2bVhCbLN8kxTdPjGnvSYdQrpvK8pVL9ACDSH2b6zSwX7cSk68A8AioR3cJuWL9zVeJRmehdopivcfbmAmtrBePAX	2025-01-06T23:10:08.000Z	CyTq8QKL6hqpH7DiKidaRa97Sb9nSXsQJnDWvwEvPMRs	DeactivateDelinquent	Stake11111111111111111111111111111111111111	12	313	GiYGtz42bh1sLKvCxw3PNzvS6FAwB4ciNejLi5CpHPgr	BLADE1qNA1uNjRgER6DtUFf7FU3c1TWLLdpPeEcKatZ2
312336464	312336464-2bVhCbLN8kxTdPjGnvSYdQrpvK8pVL9ACDSH2b6zSwX7cSk68A8AioR3cJuWL9zVeJRmehdopivcfbmAmtrBePAX-13	GTi71VkpXq9CFSt6heWiAkwndPQertmtXwrRJAwLG2uj	2bVhCbLN8kxTdPjGnvSYdQrpvK8pVL9ACDSH2b6zSwX7cSk68A8AioR3cJuWL9zVeJRmehdopivcfbmAmtrBePAX	2025-01-06T23:10:08.000Z	Dzrgewo4iXxYoondVw8HVTA8S5YTz71C9GWUZgpL7fRm	DeactivateDelinquent	Stake11111111111111111111111111111111111111	13	313	GiYGtz42bh1sLKvCxw3PNzvS6FAwB4ciNejLi5CpHPgr	BLADE1qNA1uNjRgER6DtUFf7FU3c1TWLLdpPeEcKatZ2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_DeactivateDelinquent_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_DelegateStake_instruction

Solana native stake delegation instructions recording when stake accounts are delegated to validators. Used for analyzing staking behavior, validator selection patterns, and tracking stake pool operations across the network.

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_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.
`in_stakeAuthority`	`STRING`	Account address authorized to perform stake operations on the stake account. Base58-encoded Solana public key.
`in_stakeConfigAccount`	`STRING`	Account address of the Solana stake configuration program containing network-wide staking parameters. Always set to the constant `StakeConfig11111111111111111111111111111111` sysvar address.
`in_stakeHistorySysvar`	`STRING`	Account address of the Solana StakeHistory sysvar program, which provides historical stake activation data required by the stake program. Always set to the canonical sysvar address SysvarStakeHistory1111111111111111111111111.
`in_voteAccount`	`STRING`	Address of the validator’s vote account to which stake is delegated or associated. Base58-encoded Solana public key.

Sample Data

block_slot	surrogate_key	in_clockSysvar	in_voteAccount	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	in_stakeAuthority	transaction_index	transaction_signer	in_stakeConfigAccount	in_stakeHistorySysvar	outer_executing_account	outer_instruction_index
233812749	233812749-3yScJedqojg1xu6HJu6uuvUcQDZVE5WA2A4JDXg1MnsWuz4aH1kB88kupjqKY5yMJg3PXeYH1g7EwffWiEhrqChM-1-0	SysvarC1ock11111111111111111111111111111111	1KXz4xKV2viJCGpxqnQqdf2J45vQr5USdmtcJLTaHkm	3yScJedqojg1xu6HJu6uuvUcQDZVE5WA2A4JDXg1MnsWuz4aH1kB88kupjqKY5yMJg3PXeYH1g7EwffWiEhrqChM	2023-12-03T20:23:17.000Z	4FWKWnRRVtjaXTdKqBK7yTaqYZXMofPyrYSRHKsgiAGq	DelegateStake	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	22	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	1
233783228	233783228-c3DJEKQpWR7PDPafiE73PHdxc3G3XeYJBaivJ3KiniUqXrge6gK8k2X6icjRD9qc7EjAjCqFr3itjqfPnR34Nvu-1-0	SysvarC1ock11111111111111111111111111111111	1KXz4xKV2viJCGpxqnQqdf2J45vQr5USdmtcJLTaHkm	c3DJEKQpWR7PDPafiE73PHdxc3G3XeYJBaivJ3KiniUqXrge6gK8k2X6icjRD9qc7EjAjCqFr3itjqfPnR34Nvu	2023-12-03T16:53:57.000Z	ChwDiVS188uShiEUwJAf2bz6wviEyYN6auovtq7GzMjk	DelegateStake	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	65	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	1
233793550	233793550-bxnkeAYtxCxNPVRJw3yfmUVbBm12wWkAdgs75sTVde91sAQVNhCyVkLQzYsVhMJa2VwzpAKcRFfyNkDMtuQvr67-2-0	SysvarC1ock11111111111111111111111111111111	1KXz4xKV2viJCGpxqnQqdf2J45vQr5USdmtcJLTaHkm	bxnkeAYtxCxNPVRJw3yfmUVbBm12wWkAdgs75sTVde91sAQVNhCyVkLQzYsVhMJa2VwzpAKcRFfyNkDMtuQvr67	2023-12-03T18:06:38.000Z	CrHyesRvvVcqRjT9kMkXpwm6i56tFQ9uNjVYu6avA64K	DelegateStake	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	5	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_DelegateStake_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_Initialize_instruction

Solana native stake account initialization instructions from the Stake program (Stake11111111111111111111111111111111111111). Records creation of new stake accounts with designated staker, withdrawer, and custodian authorities for analyzing staking setup activity.

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_write_uninitialized_stake_account`	`STRING`	Account address of the uninitialized stake account being written to during initialization. Always matches `in_stakeAccount` in Initialize instructions as it represents the new stake account being set up.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawer`	`STRING`	Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
`in_custodian`	`STRING`	Solana address authorized to slash or close the stake account in case of validator misconduct. Typically set to match the staker or withdrawer address in standard staking setups.
`in_epoch`	`STRING`	Epoch identifier for the protocol event or operation. String-encoded numeric value representing the time period or reward cycle.
`in_unixTimestamp`	`STRING`	Input parameter for Unix timestamp when the stake authorization was created. Null in these samples, indicating optional timestamp specification during initialization.
`in_rentSysvar`	`STRING`	Solana rent sysvar address used to verify rent exemption requirements during stake account initialization. Always set to the system constant SysvarRent111111111111111111111111111111111.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.

Sample Data

in_staker	block_slot	in_custodian	in_rentSysvar	in_withdrawer	surrogate_key	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	in_write_uninitialized_stake_account
Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw	122487469	Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw	SysvarRent111111111111111111111111111111111	Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw	122487469-2Vatxf8xG5jAJ4a2FH6PpL34k2WhS2tAMQvs3Cdpft2zsXmH6jWo1n7mJzBcD2nMBFwzJkSC7VcHq5NwVSAx4JJ5-1	2Vatxf8xG5jAJ4a2FH6PpL34k2WhS2tAMQvs3Cdpft2zsXmH6jWo1n7mJzBcD2nMBFwzJkSC7VcHq5NwVSAx4JJ5	2022-02-26T00:30:49.000Z	51ZVzJh22bTkMPHdSzNHKUJriirZ8zGFYFqftwAWJyaH	Initialize	Stake11111111111111111111111111111111111111	1	0	Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw	51ZVzJh22bTkMPHdSzNHKUJriirZ8zGFYFqftwAWJyaH
68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f	122531479	68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f	SysvarRent111111111111111111111111111111111	68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f	122531479-2PWETdpiQ1kEfjpeujr6qLcRuNwEidBwwMweqftNEPhPPatFMuw9rnawpyw7zfm9eSboyAzU5GbearcnXn6V7sTL-1	2PWETdpiQ1kEfjpeujr6qLcRuNwEidBwwMweqftNEPhPPatFMuw9rnawpyw7zfm9eSboyAzU5GbearcnXn6V7sTL	2022-02-26T07:32:39.000Z	GHvjvjkhbsw3bxNVwg4VzpAnQN8ZVVNVZ2MQ16FW8Q9L	Initialize	Stake11111111111111111111111111111111111111	1	0	68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f	GHvjvjkhbsw3bxNVwg4VzpAnQN8ZVVNVZ2MQ16FW8Q9L
AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5	122514855	AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5	SysvarRent111111111111111111111111111111111	AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5	122514855-3rsCTbV561NUbCp8Qzzzk9hLLMzo1RAk7eKDyqG7T3j9FTxSFBXCE7tCLbDRuvohc6jWmAS4XMNx2ggYcombCdf8-1	3rsCTbV561NUbCp8Qzzzk9hLLMzo1RAk7eKDyqG7T3j9FTxSFBXCE7tCLbDRuvohc6jWmAS4XMNx2ggYcombCdf8	2022-02-26T04:55:12.000Z	52X4jSAa1KNz5VWg9N6pmL4aQc993Xafb5HUm38EVGp3	Initialize	Stake11111111111111111111111111111111111111	1	1	AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5	52X4jSAa1KNz5VWg9N6pmL4aQc993Xafb5HUm38EVGp3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_Initialize_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_InitializeChecked_instruction

Stake account initialization instructions from Solana’s native staking program, recording staker and withdrawer authority assignments. Used for tracking new stake account creation and analyzing staking delegation patterns.

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_rentSysvar`	`STRING`	Solana system variable account that provides rent calculation data for the stake account initialization. Always set to `SysvarRent111111111111111111111111111111111` across all InitializeChecked instructions.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_withdrawer`	`STRING`	Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_staker	block_slot	in_rentSysvar	in_withdrawer	surrogate_key	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
7jXXV62fwUphSXVCUhmcxdRQhkBJ3KUP9Bi3LkYgQD4V	247904382	SysvarRent111111111111111111111111111111111	7jXXV62fwUphSXVCUhmcxdRQhkBJ3KUP9Bi3LkYgQD4V	247904382-HLcQTGLqxywfNUNVpkMbbJrho8tZuuyQZ1FBGDFCVfmCXqTiYpbgNGxPaBiE7W9FBnQDEXtLDJvwWXzv4LCRP2d-1	HLcQTGLqxywfNUNVpkMbbJrho8tZuuyQZ1FBGDFCVfmCXqTiYpbgNGxPaBiE7W9FBnQDEXtLDJvwWXzv4LCRP2d	2024-02-13T11:57:44.000Z	2TYy86RG5vqaXC6QvWeNzohskoMhMjfkptZnxZ9SBFae	InitializeChecked	Stake11111111111111111111111111111111111111	1	6	9Hk5RS6H7io9y2mcNBPFa9BBVnMuiNgGSHxrF7iNsNws
2Z8avBkAdVUREfz3yhtVDKYrpQHqa3m9ZRSY1N2w2AGz	247882930	SysvarRent111111111111111111111111111111111	2Z8avBkAdVUREfz3yhtVDKYrpQHqa3m9ZRSY1N2w2AGz	247882930-45ReXKcg7BRQNgqDx55a5HBd9XD1yPGVeqLFSZVMTprKsH1Hu2eshSMN3bkhLas3VDVVFgymXLr71iMTQFwU2oc3-1	45ReXKcg7BRQNgqDx55a5HBd9XD1yPGVeqLFSZVMTprKsH1Hu2eshSMN3bkhLas3VDVVFgymXLr71iMTQFwU2oc3	2024-02-13T09:27:42.000Z	241CAMT7S8SiYnSMgvWTNU98DfBjsMZsbEkBsoArLc6m	InitializeChecked	Stake11111111111111111111111111111111111111	1	128	D4B64Fa4U3Aw3VzDb6ktqxnAqnAdeiXxKY214JRRyWBK
FUunvwmujTXtvK9cG7DvFxi3a7SyXzKhQzWFLc7Eakwq	247894905	SysvarRent111111111111111111111111111111111	FUunvwmujTXtvK9cG7DvFxi3a7SyXzKhQzWFLc7Eakwq	247894905-FBrPEmW7GHVnMCxzDZFAHh7UyiAhe1WVSmjeYdJzf1aCUWqG9Zqv85nMiGAjv8yTVrTePQnjKYogcHygyAm7dvh-1	FBrPEmW7GHVnMCxzDZFAHh7UyiAhe1WVSmjeYdJzf1aCUWqG9Zqv85nMiGAjv8yTVrTePQnjKYogcHygyAm7dvh	2024-02-13T10:50:45.000Z	FqRFc1p7cHHWMjMSbwfu9M4FdRaLv1YXXXAH9dJc1iYm	InitializeChecked	Stake11111111111111111111111111111111111111	1	42	BKw6h4WX1TttGQbTSULtKcVaEp6nzPxQGHexHiX27atH

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_InitializeChecked_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_Merge_instruction

Solana stake account merge instructions that consolidate source stake accounts into destination accounts via the native Stake program. Used for analyzing stake account management patterns and validator delegation consolidation activity.

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_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_stakeAuthority`	`STRING`	Account address authorized to perform stake operations on the stake account. Base58-encoded Solana public key.
`in_stakeHistorySysvar`	`STRING`	Address of the Solana Stake History sysvar account providing historical stake activation data required for merge validation. Always set to the canonical sysvar address SysvarStakeHistory1111111111111111111111111.

Sample Data

in_source	block_slot	surrogate_key	in_clockSysvar	in_destination	transaction_id	block_timestamp	instruction_type	executing_account	in_stakeAuthority	instruction_index	transaction_index	transaction_signer	in_stakeHistorySysvar	outer_executing_account	outer_instruction_index
DAaySFzMC3hLba7UFscUKgadFUi9WsZvjkLAkrPnAJ9M	331129372	331129372-UESfkHJvVnDaHDZbHePTQVScgZxoxG248nwfstAsAGUqpLvYmbNPTwym3oLWNFe9SWQNVHiXZpYXtKe4Z6NByCk-2-34	SysvarC1ock11111111111111111111111111111111	DGP8rqmeutfYWb7v7A5yewJBtk1XZuE8SugKsVJwRE6W	UESfkHJvVnDaHDZbHePTQVScgZxoxG248nwfstAsAGUqpLvYmbNPTwym3oLWNFe9SWQNVHiXZpYXtKe4Z6NByCk	2025-04-04T00:12:36.000Z	Merge	Stake11111111111111111111111111111111111111	3b7XQeZ8nSMyjcQGTFJS5kBw4pXS2SqtB9ooHCnF2xV9	34	7	BedAip9o3VW4Qd4HSbh39La9QrCEhXw3j4djdAde5UEK	SysvarStakeHistory1111111111111111111111111	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2
9Bq8QM5b74V8NMmjzN8A1DXsuyZj6zLzJ6g7LB9fvNjE	331138373	331138373-5vHUCastWPRFVc5Hw6ShYoAgSJpQALmsA8VepSMWpUF2k57rucGnvks9Rj8v5JkuJFRNAVS7HFHhZwyfMN66KMWf-2-34	SysvarC1ock11111111111111111111111111111111	DGP8rqmeutfYWb7v7A5yewJBtk1XZuE8SugKsVJwRE6W	5vHUCastWPRFVc5Hw6ShYoAgSJpQALmsA8VepSMWpUF2k57rucGnvks9Rj8v5JkuJFRNAVS7HFHhZwyfMN66KMWf	2025-04-04T01:12:33.000Z	Merge	Stake11111111111111111111111111111111111111	3b7XQeZ8nSMyjcQGTFJS5kBw4pXS2SqtB9ooHCnF2xV9	34	60	BedAip9o3VW4Qd4HSbh39La9QrCEhXw3j4djdAde5UEK	SysvarStakeHistory1111111111111111111111111	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2
2miXADEB8V6yKTiVfgU1wbKouyFnPtRTaE2wZKkpxd3q	331170224	331170224-2KPUS7hbNPRErREhobWKb7jK3Kr2qGZPVsKw1RpoUQuiBYoaaAczwtacmFkoRDLcKusAM5wnA3JQLTXbsBvn9G2A-0-5	SysvarC1ock11111111111111111111111111111111	69H8JRnP1SEcGqvirLximTgc3uYEHt8psMeuswsJPnSE	2KPUS7hbNPRErREhobWKb7jK3Kr2qGZPVsKw1RpoUQuiBYoaaAczwtacmFkoRDLcKusAM5wnA3JQLTXbsBvn9G2A	2025-04-04T04:43:47.000Z	Merge	Stake11111111111111111111111111111111111111	3pFTQjRVwcJHSpUNH5n1hx6Jwx7V3EzJDDHaKuwExyGJ	5	16	EG976hUYS3Mwf595uk9irszydggWzB3tBDobbMffyScq	SysvarStakeHistory1111111111111111111111111	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_Merge_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_MoveLamports_instruction

Lamport transfer instructions executed through Solana’s native staking program, showing SOL movements between stake accounts with authorization details. Used for analyzing staking reward distribution, stake account rebalancing, and validator pool management operations.

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_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_lamports`	`STRING`	Amount in lamports, Solana’s smallest unit of SOL. Decimal-encoded string representing 1/1,000,000,000th of one SOL token.
`in_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_stakeAuthority`	`STRING`	Account address authorized to perform stake operations on the stake account. Base58-encoded Solana public key.

Sample Data

in_source	block_slot	in_lamports	surrogate_key	in_destination	transaction_id	block_timestamp	instruction_type	executing_account	in_stakeAuthority	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
6qyLpscrdc9yJ1TXKokTgdQw5hGwnPGXPhEuhLybx6gZ	338516141	33679	338516141-1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh-9-0	C6jpLk2EqtMbrV73AfUztV67Us1C9njS9bMDFaM6w9gn	1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh	2025-05-07T21:59:26.000Z	MoveLamports	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	150	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	9
Dt5JPbq2Vw8gkminYXJwbcTiLLyP8bqPwufYZoX7k8SK	338516141	25509	338516141-1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh-10-0	3yi8LcfWxu4ouJnYLoyQrBV9QZ3Ka3sWpky3U2BBghvy	1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh	2025-05-07T21:59:26.000Z	MoveLamports	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	150	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	10
45v3JrtWauCfSwz2sF4cwM8fzHRyGXzsjUvukjgoeRKV	338516141	120049	338516141-1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh-2-0	3yi8LcfWxu4ouJnYLoyQrBV9QZ3Ka3sWpky3U2BBghvy	1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh	2025-05-07T21:59:26.000Z	MoveLamports	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	150	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_MoveLamports_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_MoveStake_instruction

Solana stake account transfer instructions that move staked SOL lamports from one stake account to another under the same stake authority. Used for analyzing validator delegation changes and stake account rebalancing patterns.

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_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_lamports`	`STRING`	Amount in lamports, Solana’s smallest unit of SOL. Decimal-encoded string representing 1/1,000,000,000th of one SOL token.
`in_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_stakeAuthority`	`STRING`	Account address authorized to perform stake operations on the stake account. Base58-encoded Solana public key.

Sample Data

in_source	block_slot	in_lamports	surrogate_key	in_destination	transaction_id	block_timestamp	instruction_type	executing_account	in_stakeAuthority	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
EHwuD1ts1FQ5ngDuwRjrZ5fs5cXqUXKBMEvL35WvypV1	340284081	1084954972	340284081-2QEHzmxZ48qxv77TNCxVfP4XK5YepBDmA1gjWipxmMozH8deQfG7cwUYKtM221EN8U4eJhRsGVVUNmyVX5YfUbB1-6-0	DC55XSGwFFwUiXg87rtqFRoMMRo5itjGv4tFrC7kf9iz	2QEHzmxZ48qxv77TNCxVfP4XK5YepBDmA1gjWipxmMozH8deQfG7cwUYKtM221EN8U4eJhRsGVVUNmyVX5YfUbB1	2025-05-16T00:10:40.000Z	MoveStake	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	65	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	6
2DLNZFY7Tn8HEJT4zsmJGCqCiQeSCRSMSsDbzaPUKNz7	340284081	1285210440	340284081-2BrqYisG2Mex41TibWk4UkDKiL1nwmqKkj77H9S5teUt2xNC9TN6Mr6tYureYbqriSwyqbZEQwyEXiaDMjkhrFei-7-0	FJsf4qxuf8ZvjhEMe5tuYRdxyxTCXrZpz1BFxowsU3zb	2BrqYisG2Mex41TibWk4UkDKiL1nwmqKkj77H9S5teUt2xNC9TN6Mr6tYureYbqriSwyqbZEQwyEXiaDMjkhrFei	2025-05-16T00:10:40.000Z	MoveStake	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	77	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	7
BDcU733tPX5TMAEHCkkyUd4j6QG5yN84sCCpbEdvu9gq	340284081	2059825741	340284081-3CiGZv2wFTmjGTDYPnU4wRK9Haf4YLsRdKF1wdPKtwgbhJ3PrFkd5UNizJWUPK4isNk33iRtDKQRYnJGSx5utYpK-5-0	8mSxKYTL6NbVC7BZECu1Wffrcra42byjPVGWyyZuFmLh	3CiGZv2wFTmjGTDYPnU4wRK9Haf4YLsRdKF1wdPKtwgbhJ3PrFkd5UNizJWUPK4isNk33iRtDKQRYnJGSx5utYpK	2025-05-16T00:10:40.000Z	MoveStake	Stake11111111111111111111111111111111111111	stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq	89	opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP	mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk	5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_MoveStake_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_SetLockup_instruction

Solana native staking lockup configuration instructions that modify custodian addresses and epoch lockup parameters for stake accounts. Used for analyzing stake account custody changes and lockup period management by validators and delegators.

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_custodian`	`STRING`	Custodian account address that controls the lockup parameters for the stake account. Base58-encoded Solana address that has authority to modify lockup settings.
`in_lockupCustodian`	`STRING`	Account address designated as the custodian for the stake account’s lockup period. Commonly set to the system program address (all 1s) when no custodian is assigned.
`in_lockupEpoch`	`STRING`	Epoch number until which the stake account lockup is valid. Value of ‘0’ indicates no lockup period is set.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.

Sample Data

block_slot	in_custodian	surrogate_key	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	instruction_index	transaction_index	in_lockupCustodian	transaction_signer	outer_executing_account	outer_instruction_index
172940240	8QakJQ53rJgK5BpHfvthwE8cFkBKQQQnNNzVp5Qx7Z9W	172940240-37Z7Mn56b7rqfiuQP2tNSaiicqHDecMeGBi7RcboewKHaDBDJ5AnMebi7bjb3UXcmWBzvriAHNLRJdPoAnmtCarb-0-1	37Z7Mn56b7rqfiuQP2tNSaiicqHDecMeGBi7RcboewKHaDBDJ5AnMebi7bjb3UXcmWBzvriAHNLRJdPoAnmtCarb	2023-01-17T09:33:13.000Z	5mVUwUwmGPSXUHfevvzjtqqABhvaVAydhX4axEdSPvWG	SetLockup	Stake11111111111111111111111111111111111111	1	48	11111111111111111111111111111111	8QakJQ53rJgK5BpHfvthwE8cFkBKQQQnNNzVp5Qx7Z9W	mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY	0
172948056	FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw	172948056-24kFH5ud8zS43adfb9n1apu6947ipiRh4FxtCg4gbVojQHSnfRpTguoiNL5etJnxwXQwiSgcD6vFM2tax34TsoQ8-0-1	24kFH5ud8zS43adfb9n1apu6947ipiRh4FxtCg4gbVojQHSnfRpTguoiNL5etJnxwXQwiSgcD6vFM2tax34TsoQ8	2023-01-17T10:37:39.000Z	9rWg53h3pTv2vzPfFLqKV3Vknfvgcp492utWzaCeWR4i	SetLockup	Stake11111111111111111111111111111111111111	1	53	11111111111111111111111111111111	FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw	mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY	0
172947641	FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw	172947641-KPuWupoVwP2dKTg8MbHmeqg3ukjZxyxe5JP5fsAe1mqHKq8dvZ4tsxfXiM9Ldvg7kBLuRNSRu2kAXghcWik5Tjq-1-1	KPuWupoVwP2dKTg8MbHmeqg3ukjZxyxe5JP5fsAe1mqHKq8dvZ4tsxfXiM9Ldvg7kBLuRNSRu2kAXghcWik5Tjq	2023-01-17T10:34:17.000Z	8UvbLbJu5KXtmpyanoUKj6UmJoGwiCn4aL4KkWVYYP3D	SetLockup	Stake11111111111111111111111111111111111111	1	18	11111111111111111111111111111111	FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw	mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_SetLockup_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_Split_instruction

Solana native staking split instructions that divide an existing stake account into two separate accounts with specified lamport amounts. Used for analyzing stake account management patterns, validator delegation strategies, and SOL staking liquidity flows.

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_lamports`	`STRING`	Amount in lamports, Solana’s smallest unit of SOL. Decimal-encoded string representing 1/1,000,000,000th of one SOL token.
`in_newSplitAccount`	`STRING`	Address of the newly created stake account that receives the split portion of lamports. Base58-encoded Solana public key representing the destination account created by the Split instruction.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.
`in_stakeAuthority`	`STRING`	Account address authorized to perform stake operations on the stake account. Base58-encoded Solana public key.

Sample Data

block_slot	in_lamports	surrogate_key	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	in_stakeAuthority	instruction_index	transaction_index	in_newSplitAccount	transaction_signer
94845883	5000000000	94845883-2G9H9UuRSprZsLhgrKdnKmGGACtQ6YevBwqafJPZFmhvQw4QKXhVxCaFFtDzrrXkEbVVpSna55XqEt5kmCRbcrfj-1	2G9H9UuRSprZsLhgrKdnKmGGACtQ6YevBwqafJPZFmhvQw4QKXhVxCaFFtDzrrXkEbVVpSna55XqEt5kmCRbcrfj	2021-09-04T05:49:32.000Z	HvzT1fiJ2NuDSghok6SPuXoQQLswgbBRs1aujSJgL7H1	Split	Stake11111111111111111111111111111111111111	29MfsqQCTedMLVYd77UuPbiST6hXKdkD8QFhXM3reJ3v	1	92	3ek9n3NCBcyiMToHgT5PVCM8FLVhL5yadvbhiDFkurQ4	29MfsqQCTedMLVYd77UuPbiST6hXKdkD8QFhXM3reJ3v
94810326	276000000000	94810326-fNvDCfbGbHxdJVvMQJWgTQtcAFvihTaEaVb78DMyKEucFMFwA8R5i4m6QTiQ1QAsZS3VEjT5dnb3ieuL5pYpUh6-1	fNvDCfbGbHxdJVvMQJWgTQtcAFvihTaEaVb78DMyKEucFMFwA8R5i4m6QTiQ1QAsZS3VEjT5dnb3ieuL5pYpUh6	2021-09-04T00:50:44.000Z	2S3CN9YRYdy4qA6YxMaLmvQczeftf2THt7jt7dZ8LJcX	Split	Stake11111111111111111111111111111111111111	2ChoQgJDJ2twuXFGMPMYGxSeJ53x7sVxDKCB7MxuzNKy	1	1	8x7D6mduU5sDJ2VsCqRG4EN4vbHgGo9vjZdyg2GVkF1Q	2ChoQgJDJ2twuXFGMPMYGxSeJ53x7sVxDKCB7MxuzNKy
94932941	23000000000	94932941-5EvcDVnwiff5HmKEhqAF3f8Wp3ryFNFo3q1DyRseVASf4jGYmzJnATMDRmRogwhFHVyFtN6H4BrrDi1XJS1m55Fk-1	5EvcDVnwiff5HmKEhqAF3f8Wp3ryFNFo3q1DyRseVASf4jGYmzJnATMDRmRogwhFHVyFtN6H4BrrDi1XJS1m55Fk	2021-09-04T18:07:50.000Z	Fq3L6P9vY9MFraZyFALg1BEVtBjTVfyqhR5QVi94rqyv	Split	Stake11111111111111111111111111111111111111	2emB9ZSTGnWuVJ1JCbf2axHYD7Sd9kv3QJ7Zv3S439fj	1	20	6piT9DvSDAVWeLuXtpXAWhZdCMu7z2K6c99JuZK9G2NQ	2emB9ZSTGnWuVJ1JCbf2axHYD7Sd9kv3QJ7Zv3S439fj

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_Split_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Staking_Withdraw_instruction

Solana native staking withdrawal instructions executed through the Stake program (Stake11111111111111111111111111111111111111), recording lamport withdrawals from stake accounts to destination wallets. Used for tracking unstaking activity, validator rewards distribution, and SOL liquidity flows from staked positions.

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_clockSysvar`	`STRING`	Address of the Solana Clock sysvar account providing current network time and slot information. Base58-encoded Solana public key with the canonical value SysvarC1ock11111111111111111111111111111111.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_lamports`	`STRING`	Amount in lamports, Solana’s smallest unit of SOL. Decimal-encoded string representing 1/1,000,000,000th of one SOL token.
`in_stakeAccount`	`STRING`	Address of the stake account being operated on. Base58-encoded Solana public key.
`in_stakeHistorySysvar`	`STRING`	Address of the Solana Stake History Sysvar program account used to validate historical stake data during withdrawal. This value is consistently `SysvarStakeHistory1111111111111111111111111` across all transactions.
`in_withdrawAuthority`	`STRING`	Account authorized to withdraw lamports from the stake account. Base58-encoded Solana public key, typically matches the transaction signer in these withdrawal operations.

Sample Data

block_slot	in_lamports	surrogate_key	in_clockSysvar	in_destination	transaction_id	block_timestamp	in_stakeAccount	instruction_type	executing_account	transaction_index	transaction_signer	in_withdrawAuthority	in_stakeHistorySysvar
148193169	110823744	148193169-4KkNT8aFRJyvbR7VzqusDRoDgtdAXKoCZDU86gePLF8Qjzx7iam2GNSpAeJXVjaA1meBnDKQYKcLYsPun78EQ2cv-0	SysvarC1ock11111111111111111111111111111111	12EnXscJHN8ABiVdR7qempF1BunLix9hqNXgvgUTZDrU	4KkNT8aFRJyvbR7VzqusDRoDgtdAXKoCZDU86gePLF8Qjzx7iam2GNSpAeJXVjaA1meBnDKQYKcLYsPun78EQ2cv	2022-08-29T11:55:08.000Z	4Lm2d9MRWei6W71raGFhJw3b7PWqkaw8xqamvx9z4vDz	Withdraw	Stake11111111111111111111111111111111111111	136	12EnXscJHN8ABiVdR7qempF1BunLix9hqNXgvgUTZDrU	12EnXscJHN8ABiVdR7qempF1BunLix9hqNXgvgUTZDrU	SysvarStakeHistory1111111111111111111111111
148199772	18406144790	148199772-3KHgFCnUQvBN2kTdyY9jX91nSUaEqt3SVAnzhweQMs93dDfMTMLot8F2wpuP4ZrgZSDvj8VpFqZpSGL654bSD1xX-0	SysvarC1ock11111111111111111111111111111111	13NMcdzmuJfxA742AynbZTADTaJvUF9otu3BdDydZxMg	3KHgFCnUQvBN2kTdyY9jX91nSUaEqt3SVAnzhweQMs93dDfMTMLot8F2wpuP4ZrgZSDvj8VpFqZpSGL654bSD1xX	2022-08-29T12:59:39.000Z	9eiwuJaymom9SjNFJ54y9PogFUD6mVbHu7cwKngLUXvG	Withdraw	Stake11111111111111111111111111111111111111	357	13NMcdzmuJfxA742AynbZTADTaJvUF9otu3BdDydZxMg	13NMcdzmuJfxA742AynbZTADTaJvUF9otu3BdDydZxMg	SysvarStakeHistory1111111111111111111111111
148201460	506105181	148201460-63KhUC4uthhkuPBYSbRJFPkdG8HSKtNY4BhTBrdFsDo631fCqHeKBzk4EKqybDvFjvF121ZnyH67CnVjQc9skyzm-0	SysvarC1ock11111111111111111111111111111111	13Z8X2ehiUR1SSXvAEqqo1S5oUS5Kdt7esiTobVCpM5Y	63KhUC4uthhkuPBYSbRJFPkdG8HSKtNY4BhTBrdFsDo631fCqHeKBzk4EKqybDvFjvF121ZnyH67CnVjQc9skyzm	2022-08-29T13:16:26.000Z	7G4bUWUiRwatJfxu5RE8T1qFVFZHFBdGoMd1qhRiqyUj	Withdraw	Stake11111111111111111111111111111111111111	159	13Z8X2ehiUR1SSXvAEqqo1S5oUS5Kdt7esiTobVCpM5Y	13Z8X2ehiUR1SSXvAEqqo1S5oUS5Kdt7esiTobVCpM5Y	SysvarStakeHistory1111111111111111111111111

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Staking_Withdraw_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Token22Program_InitializeAccount_instruction

Token-2022 program account initialization instructions on Solana, recording new token account creation events with associated mint, owner, and transaction metadata. Used to track SPL Token-2022 account lifecycle and ownership patterns across the network.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	owner_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
367839276	CgNePAbb19MEoCPL2azxHqUtrugsiyiL4ZJbaHgnSKM8	3oY5zrZbtcJRjJh6VzmZh9xf7jWXRac7rQwryJpzGJrL	367839276-4AANw2Hr9QoFhwmPz8wdnLmpKhUEM4bAb8LVzfdKzFQndVgUq6omFX3MQMr7EVw5ea47xdYWCRTzYvWGMdwZAdX1-1-2	3oY5zrZbtcJRjJh6VzmZh9xf7jWXRac7rQwryJpzGJrL	4AANw2Hr9QoFhwmPz8wdnLmpKhUEM4bAb8LVzfdKzFQndVgUq6omFX3MQMr7EVw5ea47xdYWCRTzYvWGMdwZAdX1	2025-09-19T10:16:36.000Z	InitializeAccount	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	2	7	4XhM42CN9xTrjXkZawWPM9JmVz2jxxKSL3MnCKWjcQ26	strmRqUCoQUgGUan5YhzUZa6KqdzwX5L6FpUxfmKg5m	1
367792995	HtRAZQR9vhzVjK9ju4Xgv1dAwaR57J8sLZ2HxK7UK6hD	GqPk26sMKFbiuELvqe7rLkuApJZU4GCaa6Wd42pcvBae	367792995-3oTuxZe9sDbpDmgsEXQWXXTnFUFVxkdVSz1LSENjA83zFVfXSumbXu5Jp4bCPn4ASjUydmBLCWhbAXTFDrDV8Z9Y-1-2	GqPk26sMKFbiuELvqe7rLkuApJZU4GCaa6Wd42pcvBae	3oTuxZe9sDbpDmgsEXQWXXTnFUFVxkdVSz1LSENjA83zFVfXSumbXu5Jp4bCPn4ASjUydmBLCWhbAXTFDrDV8Z9Y	2025-09-19T05:11:39.000Z	InitializeAccount	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	2	35	FFNWmUKHxt9GrZUrVqsoXLWWUUz4bXXmu2oET7juoTde	strmRqUCoQUgGUan5YhzUZa6KqdzwX5L6FpUxfmKg5m	1
367806760	2LXSF3x9CgaR3yzdjWSv2z9tjWyekdoMsrHm9Z1unUai	8shhBrQN7kjJgjsVVgcXdneqiyKp9ehLpE7gugUfUCJX	367806760-454Wq11ipFrWsQ21ePvfEwzWUw87MdzkYGVEqT2ZJRQjz2RcfKQRw6NJAgCLUipWJ7wS69M1LSJMqvC3AAjMxoHH-1-1	12yeCcD5C8Cqd1pDtXibxRiknuRfs3ZbwSSuMrqACNwp	454Wq11ipFrWsQ21ePvfEwzWUw87MdzkYGVEqT2ZJRQjz2RcfKQRw6NJAgCLUipWJ7wS69M1LSJMqvC3AAjMxoHH	2025-09-19T06:42:16.000Z	InitializeAccount	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	137	8shhBrQN7kjJgjsVVgcXdneqiyKp9ehLpE7gugUfUCJX	BwWRVvD2hCe8gnLXLSTJPsY6BVVog3NsrmDJRf5tozZj	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Token22Program_InitializeAccount_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Token22Program_InitializeAccount123_instruction

Token-2022 program InitializeAccount3 instruction records on Solana, capturing new associated token account (ATA) creation events with mint address, token account, and transaction context. Used for tracking token account initialization patterns and ATA program interactions.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
239443751	13XeUXTnoZsWmwNvxMqdZBVCQd3GhHeTvr7TrTDB8Zyc	239443751-48NZqTsgbMHhLu5LMXbyRuUa8gQowCXE7GobDrWvb4pZDPU8fQ7AAax4bzvcdQigAL57on6UVHTDLdz9uW6njqiz-3-3	HoAPQ1P3dwGt2psQjMGhonJpffLaBBFcacoMGH34FfVT	48NZqTsgbMHhLu5LMXbyRuUa8gQowCXE7GobDrWvb4pZDPU8fQ7AAax4bzvcdQigAL57on6UVHTDLdz9uW6njqiz	2024-01-02T11:13:14.000Z	InitializeAccount3	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	20	MncG67HXupFGYt8f45jEdCaxQ7LCAgQUCdWnbPcwayK	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	3
239377529	1J3GqhpQRL61vkewBaW7BSvSJUM1pKD6UgdW9dremyP	239377529-3ipGRDL2Pe76ajxtmKHqjGdLTYviF2PWg4pJjkJpvMhgYf1H2KD7riydmLX81h7UEKQziKXE9BD3KVmPorg83a9r-5-3	HW2rcYdX3QkpN95rvY47eSaZLzurpcygYN92GKwZszpL	3ipGRDL2Pe76ajxtmKHqjGdLTYviF2PWg4pJjkJpvMhgYf1H2KD7riydmLX81h7UEKQziKXE9BD3KVmPorg83a9r	2024-01-02T02:46:22.000Z	InitializeAccount3	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	21	52VuZece4miwepeNTCgsfzwJtczK3SJn3QckyrAVEKBb	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	5
239543208	24RLzQJaj7BDZgHqSNKRF6tVojXTCj9zmKAEZrS2UPzP	239543208-3K4FTXx1oqqExSBCeTykVQms7KrsUAmWoVy1WPHkYnQsUiDFDE4qFpzAKDGPxawUTPaCPbG4sssGvs8gUojMVhVw-3-3	SJUXL9RQxvsdjJhaNnxDEKqhhAQi1kkpSWzuEMTVZmV	3K4FTXx1oqqExSBCeTykVQms7KrsUAmWoVy1WPHkYnQsUiDFDE4qFpzAKDGPxawUTPaCPbG4sssGvs8gUojMVhVw	2024-01-02T23:48:48.000Z	InitializeAccount3	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	57	2Ksuobe9ohMqzc1cv4GSNSTpQdzkLjL4z2TkEZ8ZFERd	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Token22Program_InitializeAccount123_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Token22Program_InitializeAccount2_instruction

Token account initialization events from Solana’s Token-2022 program, recording the creation of new token accounts with their associated mint addresses and owners. Used for tracking token account creation patterns and wallet activity across SPL Token-2022 standard tokens.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
379742145	o9mh96wy8jiToyBTk3g34L1QoZrvrNXmcacSZqnpump	379742145-jWao7J9sCZuMQn2GGVzviYDmHz57YqtdcPBnG8AJjjFejtg8FKfx9FYCatBtcPD1M5L5gRujc4RmoKppfTEPg1L-3	AJHWhXxCTWucPm5kocUbEvpZDYM6ShzYeawx5Ls1qaxA	jWao7J9sCZuMQn2GGVzviYDmHz57YqtdcPBnG8AJjjFejtg8FKfx9FYCatBtcPD1M5L5gRujc4RmoKppfTEPg1L	2025-11-13T05:10:59.000Z	InitializeAccount2	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	208	9xD9MinvG5SdqLcNws4ooDTgWMvrB7DqpXPFkpC4GpR1
379744281	Mw1sjBqMyib6razsMTfkdiskcikSFxHWikdtkRopump	379744281-RosECKaEVrTdcCwvrNKQ4L9VBeDx6h1jRHnSvEJ6cKLLqJ8E1AUFVU6anCHmyBqF9bEmJ8GEGrSAuEH55YhqkCQ-6	3hne4YzSgJXFfgx7bMtD28xzrWnUgrZHxU9BNybm7fpk	RosECKaEVrTdcCwvrNKQ4L9VBeDx6h1jRHnSvEJ6cKLLqJ8E1AUFVU6anCHmyBqF9bEmJ8GEGrSAuEH55YhqkCQ	2025-11-13T05:25:15.000Z	InitializeAccount2	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	6	62	9xD9MinvG5SdqLcNws4ooDTgWMvrB7DqpXPFkpC4GpR1
379850802	9wMMYnrvwSPcY5QrLtwivZd6x8JAA6htJjSR6zThpump	379850802-3qXxerZGf44oNwxYGP3QhYWEchdwZv34bQaezJ2YY9SEq9v8VLfKtYm3Z5pw7dA9d1h6EwKPt23eGr5nmHCNmKVT-3	9CMbPzzsqnyCLJwAyUK1Se4T3DVqjuo2aLgxtaKJGKrx	3qXxerZGf44oNwxYGP3QhYWEchdwZv34bQaezJ2YY9SEq9v8VLfKtYm3Z5pw7dA9d1h6EwKPt23eGr5nmHCNmKVT	2025-11-13T17:16:23.000Z	InitializeAccount2	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	334	9xD9MinvG5SdqLcNws4ooDTgWMvrB7DqpXPFkpC4GpR1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Token22Program_InitializeAccount2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Token22Program_InitializeAccount3_instruction

Token-2022 program instruction logs for initializing SPL token accounts on Solana, containing account owner addresses, mint addresses, and transaction metadata. Used for tracking associated token account creation events and analyzing wallet token holdings setup.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	owner_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
196607105	4rADWie1EB5k2Dd49oM1SfeNawTRtV2ZTyutFb3B57nG	4s9xM4kUg71p759NotRDo6k5re8P7Q2s74YaPMZup5tm	196607105-5jHLax9t7NWjSszPJ11Kad8vHUedJTZcC8gpwmbUd1KyT9WxEMbGQpnd2KaxwZJ6wnMJhU8tSwmRN7LgmAwgVGEi-4-3	CNokF9d1EVFTiv1kLUgrRUGUDgTodCxdwHiBqumY9miP	5jHLax9t7NWjSszPJ11Kad8vHUedJTZcC8gpwmbUd1KyT9WxEMbGQpnd2KaxwZJ6wnMJhU8tSwmRN7LgmAwgVGEi	2023-05-29T10:32:45.000Z	InitializeAccount3	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	11	4s9xM4kUg71p759NotRDo6k5re8P7Q2s74YaPMZup5tm	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	4
196609551	DSDe9F6M6h7Dpb7XvYShHZLEBwcYXDCTJFfVacQYVyAF	beamazjPnFT3JQoe16HjUxkpmHFfsHY6dTqf3VwBXzq	196609551-2mZYX2JyUzMRPUwDYw7jHPnJ816oPNeMD43NvrvsPe1XEjvnrSrof999yLh1zyrNoXivihRdN8G8QeyeDHwW8M3Z-3-3	7GiveFC2SahQEVKC1SUqd48cxfT4bGBpgBcEzqsvjL2m	2mZYX2JyUzMRPUwDYw7jHPnJ816oPNeMD43NvrvsPe1XEjvnrSrof999yLh1zyrNoXivihRdN8G8QeyeDHwW8M3Z	2023-05-29T10:51:43.000Z	InitializeAccount3	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	8	4s9xM4kUg71p759NotRDo6k5re8P7Q2s74YaPMZup5tm	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	3
196609551	DSDe9F6M6h7Dpb7XvYShHZLEBwcYXDCTJFfVacQYVyAF	4s9xM4kUg71p759NotRDo6k5re8P7Q2s74YaPMZup5tm	196609551-2mZYX2JyUzMRPUwDYw7jHPnJ816oPNeMD43NvrvsPe1XEjvnrSrof999yLh1zyrNoXivihRdN8G8QeyeDHwW8M3Z-2-3	6qgNABMYhHFmccrpH5SPu49m2sf4R9RQDPZbXgY1gkCv	2mZYX2JyUzMRPUwDYw7jHPnJ816oPNeMD43NvrvsPe1XEjvnrSrof999yLh1zyrNoXivihRdN8G8QeyeDHwW8M3Z	2023-05-29T10:51:43.000Z	InitializeAccount3	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3	8	4s9xM4kUg71p759NotRDo6k5re8P7Q2s74YaPMZup5tm	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Token22Program_InitializeAccount3_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Token22Program_InitializeMint_instruction

Token-2022 program mint initialization instructions on Solana, capturing new SPL token creation events with mint address, decimals, and authority data. Used for tracking token launches and analyzing mint configuration patterns across the Token-2022 standard.

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_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_decimals`	`INT64`	Number of decimal places for the token. Integer value defining precision for token amount representations.
`in_mintAuthority`	`STRING`	Account authorized to mint new tokens for the specified token mint. Base58-encoded Solana public key or byte array representation.

Sample Data

in_mint	in_rent	block_slot	in_decimals	surrogate_key	transaction_id	block_timestamp	in_mintAuthority	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
ErzkC3Z3ChXNPZFETvU7wT9rhMo3FW6zJsFKAAx1f8ri	SysvarRent111111111111111111111111111111111	306635443	9	306635443-4jsJNgYb33MtV2Kxen5JoVrpUAyHx7TfgnyjoXeWoaazDeK7CcqJMhCef7VmzfGJxkQYTtw1R7eUa9NX4jM32nqA-1	4jsJNgYb33MtV2Kxen5JoVrpUAyHx7TfgnyjoXeWoaazDeK7CcqJMhCef7VmzfGJxkQYTtw1R7eUa9NX4jM32nqA	2024-12-10T16:54:33.000Z	CJ8sZnRhUJSeownmBByvAE6nqeyMXHrgmyw2wieQaL9R	InitializeMint	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	2	CJ8sZnRhUJSeownmBByvAE6nqeyMXHrgmyw2wieQaL9R
MEwSRBxLa16zQuQ8jfVcCCzHXa9yrZq64CXpHcdggJZ	SysvarRent111111111111111111111111111111111	306512236	9	306512236-5zSnu5BXn5XDTzKNAx3qnm7d8tTggc7MpDffQTmt6dFYv2YjVxeqdoXar2hvUxoH9eCXmXohA8Ht6hSxPi4NUSbg-1	5zSnu5BXn5XDTzKNAx3qnm7d8tTggc7MpDffQTmt6dFYv2YjVxeqdoXar2hvUxoH9eCXmXohA8Ht6hSxPi4NUSbg	2024-12-10T02:34:19.000Z	DEVprtnnH9LHEUqnkzcWnMfG9hs5tqt5jHZG9R5cb7RZ	InitializeMint	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	25	DEVprtnnH9LHEUqnkzcWnMfG9hs5tqt5jHZG9R5cb7RZ
rwabUbHukpyMYSRyebrvqAZS6pC43myiqyPxTAgKqWZ	SysvarRent111111111111111111111111111111111	306655799	9	306655799-29cadvw6JWm5uhDEFSDzbkbj3jqsgNPVtvMa76CsRrAHVL9TinSQxMk5DPwxBjqXpkodKHXayXPS5BmFXG3M6qUi-1	29cadvw6JWm5uhDEFSDzbkbj3jqsgNPVtvMa76CsRrAHVL9TinSQxMk5DPwxBjqXpkodKHXayXPS5BmFXG3M6qUi	2024-12-10T19:17:00.000Z	EYScT4d3g7kRVr1UU9eR3nnfKRVz4bkjGir3pffgrbBQ	InitializeMint	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	107	EYScT4d3g7kRVr1UU9eR3nnfKRVz4bkjGir3pffgrbBQ

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Token22Program_InitializeMint_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Token22Program_InitializeMint2_instruction

Token-2022 program mint initialization instructions on Solana, capturing new token creation events with mint address, decimal precision, and mint authority. Used for tracking SPL Token-2022 deployments and token supply configuration.

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_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_decimals`	`INT64`	Number of decimal places for the token. Integer value defining precision for token amount representations.
`in_mintAuthority`	`STRING`	Account authorized to mint new tokens for the specified token mint. Base58-encoded Solana public key or byte array representation.

Sample Data

in_mint	block_slot	in_decimals	surrogate_key	transaction_id	block_timestamp	in_mintAuthority	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
67FT8A1CyB9r2qnbxobSm83inHN5v9gSDsTCWFC9rnCe	215168044	2	215168044-TQBEzkS9Vng146aXDFqZJmuQgrfF5cYL84Zsd5bssA1UtywGgRSQVngNcFEQu7GPnPJmapkswpLygvMQgRwej49-1	TQBEzkS9Vng146aXDFqZJmuQgrfF5cYL84Zsd5bssA1UtywGgRSQVngNcFEQu7GPnPJmapkswpLygvMQgRwej49	2023-09-02T17:19:28.000Z	EQd99RWr9o6c7y6Ft3MLpYN4SdKrDjyqXvywA2PTwnhj	InitializeMint2	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	0	BJJaBHA8XUbcKNVAYwD75tdQLxHnECa33vLSN7pb7mdM
6kRtG7ScFd4zXPUxCCxiSqnYEo1mudEToJ79UPQ1dgdm	215063940	2	215063940-2nXvJfDCZfuEYQP5FsfHjhxdpb95Ruvx2nRhTBM7a1nXqgJYk1w3LUHabWRGhN1VzkRFvXQUJArugdmnKyZyQWfz-1	2nXvJfDCZfuEYQP5FsfHjhxdpb95Ruvx2nRhTBM7a1nXqgJYk1w3LUHabWRGhN1VzkRFvXQUJArugdmnKyZyQWfz	2023-09-02T04:49:47.000Z	6PFHrPAGfVQX9QLL5b7AX6nmAzZJPNEQofSu8e8n6JuY	InitializeMint2	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	40	A69gGFtcvzRoHeRghEh6ChnPdmBx7z6iHU1f54H5KF8Y
DP2Z6BQUKdyewxD6xY2NZ8YTfd3UYhCCd85B6LAeRs5v	215140831	2	215140831-D16MxFjmsVVdJnVpuAYu9L52KSZA3r2NibRwjssFTdMuRsSKxgQbNi1fsMsHEj49ddvde2ZqtYSkZ4xjcaLDC1H-1	D16MxFjmsVVdJnVpuAYu9L52KSZA3r2NibRwjssFTdMuRsSKxgQbNi1fsMsHEj49ddvde2ZqtYSkZ4xjcaLDC1H	2023-09-02T14:00:21.000Z	AY7UBg49oD9GrF2hoiFWhufTCg6jdUUpyVHXYzU54B8T	InitializeMint2	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	1	34	5X384XP4DF2HDj9xaPhDGnzKEhNCQrbgdrHtqjKx4aZS

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.Token22Program_InitializeMint2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TokenProgram_InitializeAccount_instruction

Solana Token Program instruction records for initializing new token accounts, linking mint addresses to owner addresses. Useful for tracking account creation activity and analyzing token adoption patterns across SPL tokens and wrapped SOL.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	owner_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
204921002	Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB	125vMQKvzqw6qY8YRNRMHYtErtLXd3pLmPRqqqUgV1Bo	204921002-5JWCA7JMfmD3i7WcX1vY4cpHmk6tnLXUVDBSCJjTDWrkdscG82zZKSGC98Ei3hsWFezeT6Go9aoXRAvgciEWvkuw-2	9eKWeSFgVapbfQSiFeGrpF92gQJ9eaSaat2kHoNKFUcd	5JWCA7JMfmD3i7WcX1vY4cpHmk6tnLXUVDBSCJjTDWrkdscG82zZKSGC98Ei3hsWFezeT6Go9aoXRAvgciEWvkuw	2023-07-12T12:43:14.000Z	InitializeAccount	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2	4	125vMQKvzqw6qY8YRNRMHYtErtLXd3pLmPRqqqUgV1Bo
204900876	So11111111111111111111111111111111111111112	128hv5Dgo4BcQat7qDGHbc2wTpPHm2vncCZnrboNNXbZ	204900876-55KQfZAA9St7QB4k7AbV8YXZMZC6Rjczd8U7sPQAUVNavqZY8fbqRPg5vv98nKvjzV8SwCMEq3U6boWtt77fSsDy-1	6f6cX9zx9PDxHfjc7kc99tTBXeWxC1HmoFC8Xd3WYB1v	55KQfZAA9St7QB4k7AbV8YXZMZC6Rjczd8U7sPQAUVNavqZY8fbqRPg5vv98nKvjzV8SwCMEq3U6boWtt77fSsDy	2023-07-12T10:16:53.000Z	InitializeAccount	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	92	128hv5Dgo4BcQat7qDGHbc2wTpPHm2vncCZnrboNNXbZ
204845893	So11111111111111111111111111111111111111112	12Sv6Zxw5Cz8BzvX7mVoA5PYiGMJ7VFniMRy6vcJG5HC	204845893-2MUasMaPRkmrNdkJVbvVKhPwu3wfMMwEru5uRomffZ1GaGqWee29zhJVitEi8z3Fza54dGCaJ5pw4Y5hWZLq9Q67-1	G66mZCoBuqNbsG5rRHpP3KLHnY4Qw8P6B4ZhX4p55EPS	2MUasMaPRkmrNdkJVbvVKhPwu3wfMMwEru5uRomffZ1GaGqWee29zhJVitEi8z3Fza54dGCaJ5pw4Y5hWZLq9Q67	2023-07-12T03:40:25.000Z	InitializeAccount	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	49	12Sv6Zxw5Cz8BzvX7mVoA5PYiGMJ7VFniMRy6vcJG5HC

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeAccount_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TokenProgram_InitializeAccount123_instruction

Solana Token Program instructions that create new SPL token accounts, linking token accounts to their mint address and owner. Used for analyzing token account creation patterns and wallet token holdings initialization.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	owner_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
124903960	EHrpkz3XYYfDNnxArYHBujS4r6Y5zNeJGEYdBt1pkhmY	121UucmBhubixdrG15e3XvVnJ3yRVQGra6StSSbXvJhN	124903960-qaA8WnncNyeVV9KiB6NnwDrVHyatv6HeVkjQt3rZtoMCtkwpSbbF4J6bVSJG4uBkn9YMhUMA3F4vNuoY46ymdYj-1	Ac5sBqS8DPeUtSReZMidsv8ML5fJCYKvZjLpj3Ae5aqC	qaA8WnncNyeVV9KiB6NnwDrVHyatv6HeVkjQt3rZtoMCtkwpSbbF4J6bVSJG4uBkn9YMhUMA3F4vNuoY46ymdYj	2022-03-14T12:30:16.000Z	InitializeAccount	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	514	121UucmBhubixdrG15e3XvVnJ3yRVQGra6StSSbXvJhN
124904005	3gHSBfELUAXrVKRH62e7uEJ8nn4AmN7fGf87vKMibfCe	121UucmBhubixdrG15e3XvVnJ3yRVQGra6StSSbXvJhN	124904005-4rJFQwSXLf3Qb36LQW9i8dXboyS23JNrWdpPT3SRUkFc99uYD9hQD3XANGUu1iMA95zCxh5xMWyQ8KfnyRnqoSAh-1	8mmbm1oZjZoYK5eEt3a45Zp3VL4tUCuMmFkf844nGgcN	4rJFQwSXLf3Qb36LQW9i8dXboyS23JNrWdpPT3SRUkFc99uYD9hQD3XANGUu1iMA95zCxh5xMWyQ8KfnyRnqoSAh	2022-03-14T12:30:44.000Z	InitializeAccount	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	137	121UucmBhubixdrG15e3XvVnJ3yRVQGra6StSSbXvJhN
124903646	9wy4NicJWrYygRJkrN9CPprrtru349ap6FDEngpYdLka	121UucmBhubixdrG15e3XvVnJ3yRVQGra6StSSbXvJhN	124903646-3P5sdrqDrXMjjNrdTZATXY5dz1xGJ1xj2bf9zaFVJzjf5abPWjDT2fTb8RN2sBUjHLU4N9kAXcDPNBdGAEDrRQjr-1	FLebt5RZP1uL7Kx2x2dhQe1iVFbSj3ouLZG7ZBvjfpu9	3P5sdrqDrXMjjNrdTZATXY5dz1xGJ1xj2bf9zaFVJzjf5abPWjDT2fTb8RN2sBUjHLU4N9kAXcDPNBdGAEDrRQjr	2022-03-14T12:27:12.000Z	InitializeAccount	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	409	121UucmBhubixdrG15e3XvVnJ3yRVQGra6StSSbXvJhN

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeAccount123_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TokenProgram_InitializeAccount2_instruction

Solana Token Program instructions that initialize new token accounts (SPL tokens) with specified mint and owner addresses. Used for tracking token account creation events and analyzing new wallet setups for specific tokens.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	owner_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
226773520	So11111111111111111111111111111111111111112	Auybg1MtacsE9pCwkTB2dcSocDRKsyAnPBdaz7Kg3jqP	226773520-4r5rjhahP8fPkuwqffgmUDg8FNeYdWAq6cqcxfCGyGfTUExLSrAjsRdNcgyYHABQ9y2vhuqVquLbV2PjnWERyxKL-1	ByMkcudSt871gfNYjfNunca9V355V1UvBb8s5x1bVz9a	4r5rjhahP8fPkuwqffgmUDg8FNeYdWAq6cqcxfCGyGfTUExLSrAjsRdNcgyYHABQ9y2vhuqVquLbV2PjnWERyxKL	2023-10-29T18:57:45.000Z	InitializeAccount2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	29	Auybg1MtacsE9pCwkTB2dcSocDRKsyAnPBdaz7Kg3jqP
226718096	7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx	3JtZSiKnmco4of657XjeLm3PmGXBcme4GqahnELrkDU4	226718096-5rL4prr6vcD3SmnBkrRk6iNFLJEQXcgPsvZoJXKpYLPqwjvSPAxN7nDNUR8UT9qUNb78XUifGyPuaXXnVyc5vMHs-0-3	51VfKD8aPq1T7f6La6gRkEG4FhGn5bhxi9SQNjkyWYLU	5rL4prr6vcD3SmnBkrRk6iNFLJEQXcgPsvZoJXKpYLPqwjvSPAxN7nDNUR8UT9qUNb78XUifGyPuaXXnVyc5vMHs	2023-10-29T12:37:42.000Z	InitializeAccount2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3	70	or48CcuEXD2qYvrSNWXGJRgdbDQC4Wt8zxUJuGEzSAB	5pBn2Sxa41SUuTxKR8s91kMn9LHptd7Q9AA7nP6mqa4W	0
226749565	6gkmJMpGFr5BuxK6G49eXNYCcDpkiEGq8DoVCEEPvP6c	8NyzvUXo3hLLq5yrP5xCZJy1ZeHKQBJNAjF2yuFu3XUA	226749565-4LXXe2PidVg1fZX5cAiE7ecKdH4GWHJRYQC4A4Lg86WcirrA553t1LfSZ5ucygJe5tSW8HqZgc7JrkXXGvhRsoC6-2-4	H7USPLiJUdUPNcqZsUWAHWUxHEbxUom6fUChMyRcR129	4LXXe2PidVg1fZX5cAiE7ecKdH4GWHJRYQC4A4Lg86WcirrA553t1LfSZ5ucygJe5tSW8HqZgc7JrkXXGvhRsoC6	2023-10-29T16:13:15.000Z	InitializeAccount2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	4	19	FSVPw5wJKYtjCwPcdhDF5KvCjjBfd78VCELjpQTa7ibB	csbMUULiQfGjT8ezT16EoEBaiarS6VWRevTw1JMydrS	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeAccount2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TokenProgram_InitializeAccount3_instruction

Solana Token Program InitializeAccount3 instruction calls that create new token accounts, linking mint addresses to owner addresses. Tracks token account initialization events for analyzing wallet creation patterns and SPL token adoption.

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.
`token_account`	`STRING`	Address of the SPL token account being initialized. Base58-encoded Solana public key.
`mint_address`	`STRING`	Address of the SPL token mint account. Base58-encoded Solana public key.
`owner_address`	`STRING`	Account address that controls or has authority over the token account. Base58-encoded Solana public key.

Sample Data

block_slot	mint_address	owner_address	surrogate_key	token_account	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer
248915578	So11111111111111111111111111111111111111112	12ZZetfUvFaaa6v2mAx9w8GzJw2cVTu2fxGYJyVZdp8j	248915578-56RhQ5BiKzXnL2Nw2txshZix5hcygEh4wrmo2zztwMkGqj9pnAJTH7zKMtT4NB6srKNuasqgVHrjhD91kbMhZKxC-2	7FwTDWDRxsmNN9WpgiRZCEYHmnY1oMERBoDY8KUT7oeg	56RhQ5BiKzXnL2Nw2txshZix5hcygEh4wrmo2zztwMkGqj9pnAJTH7zKMtT4NB6srKNuasqgVHrjhD91kbMhZKxC	2024-02-18T09:43:29.000Z	InitializeAccount3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2	14	12ZZetfUvFaaa6v2mAx9w8GzJw2cVTu2fxGYJyVZdp8j
248994584	So11111111111111111111111111111111111111112	1qxYvBL57HTcoPqsx37zd6mvX181sheN9yUULUTp8E9	248994584-siL3FHZu5w6RcxaEtjnB71mGx4FshqM7EAmjMgdMaTdVjEnZmnpWgR15xDCQGT2JxpxgigjJ5WZ7nijXk4uB7SV-2	23W56HvTr5jnELqYNWj9qRXLKb6tmmUhaDoewVBq25mE	siL3FHZu5w6RcxaEtjnB71mGx4FshqM7EAmjMgdMaTdVjEnZmnpWgR15xDCQGT2JxpxgigjJ5WZ7nijXk4uB7SV	2024-02-18T18:57:55.000Z	InitializeAccount3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2	3	1qxYvBL57HTcoPqsx37zd6mvX181sheN9yUULUTp8E9
248993593	So11111111111111111111111111111111111111112	1qxYvBL57HTcoPqsx37zd6mvX181sheN9yUULUTp8E9	248993593-4hz3X5ViVEBDfEhvJSGb9dEMQehYS9nRUb2dvY2BXUoG2BPaXQCYG9aRABBQuMiM3Sw4QfL7LsJJ9nVpa588pP2D-2	4Q1Vdi88hbsVaMGvrdoHfr73UPg72gAC5U7qbiWAmRpC	4hz3X5ViVEBDfEhvJSGb9dEMQehYS9nRUb2dvY2BXUoG2BPaXQCYG9aRABBQuMiM3Sw4QfL7LsJJ9nVpa588pP2D	2024-02-18T18:50:41.000Z	InitializeAccount3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2	26	1qxYvBL57HTcoPqsx37zd6mvX181sheN9yUULUTp8E9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeAccount3_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TokenProgram_InitializeMint_instruction

Token mint initialization instructions from Solana’s Token Program, capturing new SPL token creation events with mint address, decimal precision, and authority configurations. Used for tracking token deployment activity and analyzing mint authority patterns across the Solana ecosystem.

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_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_rentSysvar`	`STRING`	Account address of the Solana rent sysvar program used to verify rent-exemption status during mint initialization. Always set to the canonical rent sysvar address `SysvarRent111111111111111111111111111111111`.
`in_signerAccounts`	`STRING`	Array of additional signer accounts required to authorize the mint initialization instruction. Typically empty for standard mint creation operations.
`in_decimals`	`INT64`	Number of decimal places for the token. Integer value defining precision for token amount representations.
`in_mintAuthority`	`STRING`	Account authorized to mint new tokens for the specified token mint. Base58-encoded Solana public key or byte array representation.
`in_freezeAuthority`	`STRING`	Public key authorized to freeze token accounts for this mint, stored as byte array. Can be null if freeze functionality is disabled for the token.

Sample Data

in_mint	block_slot	in_decimals	in_rentSysvar	surrogate_key	transaction_id	block_timestamp	in_mintAuthority	instruction_type	executing_account	in_signerAccounts	instruction_index	transaction_index	in_freezeAuthority	transaction_signer
ErPC5KjUKrZV1DZTmZjuv9ebFyTC6beJU11pBtedEckj	48016693	0	SysvarRent111111111111111111111111111111111	48016693-2rq8HELpTZMZVuk9hxcygmAjCvJtZAX7xy8vxX647gZHbrtWciYsqMgr5zg9Z2kjsnpnptrGwiwSjYwNWqT8NGQz-1	2rq8HELpTZMZVuk9hxcygmAjCvJtZAX7xy8vxX647gZHbrtWciYsqMgr5zg9Z2kjsnpnptrGwiwSjYwNWqT8NGQz	2020-11-10T13:04:33.000Z	[224,0,108,221,94,35,68,66,221,103,74,5,166,98,78,250,242,138,182,217,58,102,160,98,80,12,100,7,179,77,249,192]	InitializeMint	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	1	52	null	G5Qhd8KnMm7iLbTkseuZdsAbrP9V71eqizQgenHQw8vb
3ye6qseDSsjdgK6kHhqYaFdCPTyCZmaDQoGCy7FWc6qq	47989047	8	SysvarRent111111111111111111111111111111111	47989047-fnvPXZztAWrNXqReASSz2tmJJK4QRQgNs1ZCCp4syauMrNm9nH3bgWYVwL3cC16j2ajY1JoeTHWfKvaPvGtH5hK-1	fnvPXZztAWrNXqReASSz2tmJJK4QRQgNs1ZCCp4syauMrNm9nH3bgWYVwL3cC16j2ajY1JoeTHWfKvaPvGtH5hK	2020-11-10T10:08:11.000Z	[46,91,0,88,74,38,39,130,184,122,186,247,144,226,65,12,78,212,209,225,129,77,115,153,50,221,249,47,246,170,139,168]	InitializeMint	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	1	19	[46,91,0,88,74,38,39,130,184,122,186,247,144,226,65,12,78,212,209,225,129,77,115,153,50,221,249,47,246,170,139,168]	47xEhQfDT1rLq6G8ir4G4dqfXRn4HswYVgC2F8ExkHFu
P4oqVy3nJ6YLD8BsX1xPsp3ry88VcoBHxJ5qy9uJtGQ	208708857	0	SysvarRent111111111111111111111111111111111	208708857-3nW4pvhjMvKhZbEchU7VDuKad7bAc2b9j2i9HLcR95BeeUExKLiBBhJ6uste9rZAPBiqa8RV5gEhhNr9ZWxPkog9-1	3nW4pvhjMvKhZbEchU7VDuKad7bAc2b9j2i9HLcR95BeeUExKLiBBhJ6uste9rZAPBiqa8RV5gEhhNr9ZWxPkog9	2023-08-01T00:44:00.000Z	[0,98,57,126,234,242,86,137,51,6,242,212,41,110,189,36,191,186,76,3,69,148,91,146,123,214,69,113,127,146,113,181]	InitializeMint	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	1	22	[0,98,57,126,234,242,86,137,51,6,242,212,41,110,189,36,191,186,76,3,69,148,91,146,123,214,69,113,127,146,113,181]	12VsUnQo8v2A3Gu1wsSdkpnqJDBqLQMXBPuCQveYnrcC

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeMint_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TokenProgram_InitializeMint2_instruction

SPL Token Program instructions that initialize new token mints with specified decimals, mint authority, and optional freeze authority. Used to analyze token creation patterns and authority configurations on Solana.

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_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_signerAccounts`	`STRING`	Array of accounts required to sign this mint initialization instruction. Typically empty for InitializeMint2 as it requires no additional signers beyond the transaction signer.
`in_decimals`	`INT64`	Number of decimal places for the token. Integer value defining precision for token amount representations.
`in_mintAuthority`	`STRING`	Account authorized to mint new tokens for the specified token mint. Base58-encoded Solana public key or byte array representation.
`in_freezeAuthority`	`STRING`	Public key of the account authorized to freeze token accounts, represented as a byte array. Commonly set to the same value as mint authority in the samples provided.

Sample Data

in_mint	block_slot	surrogate_key	transaction_id	block_timestamp	in_mintAuthority	instruction_type	executing_account	in_signerAccounts	instruction_index	transaction_index	in_freezeAuthority	transaction_signer
DMxxdCdUfA2A4aZ3nVyBTRunMDQYDdYXVwnTE1AnSE6K	128410062	128410062-4Xj9xVcivpWpNdcghQYUC8GTjbi8rBdndT1yKcm19mQNdSRB2aGrRW3GzznRTfnTbQJPd7q85BsDs4SLvZxMWR5L-1	4Xj9xVcivpWpNdcghQYUC8GTjbi8rBdndT1yKcm19mQNdSRB2aGrRW3GzznRTfnTbQJPd7q85BsDs4SLvZxMWR5L	2022-04-06T00:24:01.000Z	[22,90,150,247,121,25,242,38,135,117,176,38,174,37,121,83,218,110,95,20,10,224,207,198,115,35,240,169,251,52,198,213]	InitializeMint2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	1	58	[22,90,150,247,121,25,242,38,135,117,176,38,174,37,121,83,218,110,95,20,10,224,207,198,115,35,240,169,251,52,198,213]	2WG64rZkJrEZQXuheMLSUZ2nNt58CbUZEzHJ4zgfvdXr
gHJfDyzwqukrdeey89JoNys94resSiSX3HvEGvkPMXZ	128418659	128418659-2DeVBBP1R8DAhkMTH1Twjzn4KgTaYbPvkTbXcxFK8nVU3bDFFrfxhtTG3ZGnz3WY86RN7oCGwDekUhMUAyXmHMHT-1	2DeVBBP1R8DAhkMTH1Twjzn4KgTaYbPvkTbXcxFK8nVU3bDFFrfxhtTG3ZGnz3WY86RN7oCGwDekUhMUAyXmHMHT	2022-04-06T01:43:55.000Z	[54,109,216,7,189,112,36,165,90,15,214,155,168,37,58,202,171,27,237,61,124,42,44,6,238,141,20,80,178,114,81,172]	InitializeMint2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	1	2	[54,109,216,7,189,112,36,165,90,15,214,155,168,37,58,202,171,27,237,61,124,42,44,6,238,141,20,80,178,114,81,172]	4fUAQUyczp6ckEHdESocxUw6VAXVct1xHaf6UCs9UcxK
4yRqGseDXEmb8tZH2TkiJtKbcJQkcp5JeLpHkeWESVhX	128490602	128490602-3CervzgyAM411XwakxT1uSp1x1Q7mqoUqDFmeAparkpKp7TFJKGnnTC9iF2avvvHRXPWH1yEpBdBG9CLK3KcA1Mm-1	3CervzgyAM411XwakxT1uSp1x1Q7mqoUqDFmeAparkpKp7TFJKGnnTC9iF2avvvHRXPWH1yEpBdBG9CLK3KcA1Mm	2022-04-06T12:38:27.000Z	[174,17,153,33,119,175,16,100,173,199,134,251,230,50,0,200,181,176,242,166,52,139,14,86,192,33,25,72,254,246,81,234]	InitializeMint2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	1	75	[174,17,153,33,119,175,16,100,173,199,134,251,230,50,0,200,181,176,242,166,52,139,14,86,192,33,25,72,254,246,81,234]	CiVWCAUkYLnnGi4vZWV8nnU7XABRRKY8EV3P7UGESxiD

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeMint2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

BPF_Upgrade_instruction

Staking_Authorize_instruction

Staking_AuthorizeChecked_instruction

Staking_AuthorizeWithSeed_instruction

Staking_Deactivate_instruction

Staking_DeactivateDelinquent_instruction

Staking_DelegateStake_instruction

Staking_Initialize_instruction

Staking_InitializeChecked_instruction

Staking_Merge_instruction

Staking_MoveLamports_instruction

Staking_MoveStake_instruction

Staking_SetLockup_instruction

Staking_Split_instruction

Staking_Withdraw_instruction

Token22Program_InitializeAccount_instruction

Token22Program_InitializeAccount123_instruction

Token22Program_InitializeAccount2_instruction

Token22Program_InitializeAccount3_instruction

Token22Program_InitializeMint_instruction

Token22Program_InitializeMint2_instruction

TokenProgram_InitializeAccount_instruction

TokenProgram_InitializeAccount123_instruction

TokenProgram_InitializeAccount2_instruction

TokenProgram_InitializeAccount3_instruction

TokenProgram_InitializeMint_instruction

TokenProgram_InitializeMint2_instruction

Metrics

Primitives

Contracts

Blockchain

​Tables

​BPF_Upgrade_instruction

​Staking_Authorize_instruction

​Staking_AuthorizeChecked_instruction

​Staking_AuthorizeWithSeed_instruction

​Staking_Deactivate_instruction

​Staking_DeactivateDelinquent_instruction

​Staking_DelegateStake_instruction

​Staking_Initialize_instruction

​Staking_InitializeChecked_instruction

​Staking_Merge_instruction

​Staking_MoveLamports_instruction

​Staking_MoveStake_instruction

​Staking_SetLockup_instruction

​Staking_Split_instruction

​Staking_Withdraw_instruction

​Token22Program_InitializeAccount_instruction

​Token22Program_InitializeAccount123_instruction

​Token22Program_InitializeAccount2_instruction

​Token22Program_InitializeAccount3_instruction

​Token22Program_InitializeMint_instruction

​Token22Program_InitializeMint2_instruction

​TokenProgram_InitializeAccount_instruction

​TokenProgram_InitializeAccount123_instruction

​TokenProgram_InitializeAccount2_instruction

​TokenProgram_InitializeAccount3_instruction

​TokenProgram_InitializeMint_instruction

​TokenProgram_InitializeMint2_instruction

Tables

BPF_Upgrade_instruction

Staking_Authorize_instruction

Staking_AuthorizeChecked_instruction

Staking_AuthorizeWithSeed_instruction

Staking_Deactivate_instruction

Staking_DeactivateDelinquent_instruction

Staking_DelegateStake_instruction

Staking_Initialize_instruction

Staking_InitializeChecked_instruction

Staking_Merge_instruction

Staking_MoveLamports_instruction

Staking_MoveStake_instruction

Staking_SetLockup_instruction

Staking_Split_instruction

Staking_Withdraw_instruction

Token22Program_InitializeAccount_instruction

Token22Program_InitializeAccount123_instruction

Token22Program_InitializeAccount2_instruction

Token22Program_InitializeAccount3_instruction

Token22Program_InitializeMint_instruction

Token22Program_InitializeMint2_instruction

TokenProgram_InitializeAccount_instruction

TokenProgram_InitializeAccount123_instruction

TokenProgram_InitializeAccount2_instruction

TokenProgram_InitializeAccount3_instruction

TokenProgram_InitializeMint_instruction

TokenProgram_InitializeMint2_instruction