> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# solana_v1_solana
> Tables in tt-contracts.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.
| 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. |
| 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 | instruction\_index | transaction\_index | transaction\_signer | outer\_executing\_account | outer\_instruction\_index |
| ---- | ------------------------------------------- | ------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | --------- | -------------------------------------------- | ----------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ----------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| \[] | 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 | 0 | 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 | 0 | 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 | 0 | 36 | EU8z368kxJ4VzLfdpNG774L6DpAnav9d9cBBpbyH9Rr2 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| ----------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | -------------------------------------------- | ----------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| ----------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | -------------------------------------------- | ----------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| block\_slot | surrogate\_key | in\_clockSysvar | transaction\_id | block\_timestamp | in\_stakeAccount | in\_authorityBase | in\_authoritySeed | in\_authorityType | in\_newAuthorized | instruction\_type | executing\_account | in\_authorityOwner | instruction\_index | transaction\_index | transaction\_signer | outer\_executing\_account | outer\_instruction\_index |
| ----------- | --------------------------------------------------------------------------------------------------- | --------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | -------------------------------------------- | ----------------- | ----------------- | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 61301541 | 61301541-2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ-1 | | 2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ | 2021-01-19T01:37:02.000Z | HVhNcBHUCQTgRxRbHVJ1qj7Ey3VwUbQWPMvdMQzJcXAu | 5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw | 0 | Withdrawer | 7kgfDmgbEfypBujqn4tyApjf8H7ZWuaL3F6Ah9vQHzgR | AuthorizeWithSeed | Stake11111111111111111111111111111111111111 | Stake11111111111111111111111111111111111111 | 1 | 275 | 5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw | | |
| 61301541 | 61301541-2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ-1 | | 2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ | 2021-01-19T01:37:02.000Z | HVhNcBHUCQTgRxRbHVJ1qj7Ey3VwUbQWPMvdMQzJcXAu | 5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw | 0 | Withdrawer | 7kgfDmgbEfypBujqn4tyApjf8H7ZWuaL3F6Ah9vQHzgR | AuthorizeWithSeed | Stake11111111111111111111111111111111111111 | Stake11111111111111111111111111111111111111 | 1 | 275 | 5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw | | |
| 61301541 | 61301541-2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ-1 | | 2RMsJdttrcdTiqVDsBQj95F6YoTDJzJUftB8i1ZiauBth2ebWGDfsYeRoyyrUuurzdGeuFJKNPTJ3wfFejmM3vRJ | 2021-01-19T01:37:02.000Z | HVhNcBHUCQTgRxRbHVJ1qj7Ey3VwUbQWPMvdMQzJcXAu | 5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw | 0 | Withdrawer | 7kgfDmgbEfypBujqn4tyApjf8H7ZWuaL3F6Ah9vQHzgR | AuthorizeWithSeed | Stake11111111111111111111111111111111111111 | Stake11111111111111111111111111111111111111 | 1 | 275 | 5Amvvx9vEzEkFCEJK6LaQcrL6i8y7HYdHoHVwZFabHAw | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| block\_slot | surrogate\_key | in\_clockSysvar | transaction\_id | block\_timestamp | in\_stakeAccount | instruction\_type | executing\_account | in\_stakeAuthority | instruction\_index | transaction\_index | transaction\_signer | outer\_executing\_account | outer\_instruction\_index |
| ----------- | ---------------------------------------------------------------------------------------------------- | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | -------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 117512322 | 117512322-4CU6UYXJtUhUFuhJwwmCp7hcDoAiYdHJkC1DqHpcQGrJgrL5fUTBudngTx8xpP9kQW4GJmTNFpKKJgZF1NHHA5DU-0 | SysvarC1ock11111111111111111111111111111111 | 4CU6UYXJtUhUFuhJwwmCp7hcDoAiYdHJkC1DqHpcQGrJgrL5fUTBudngTx8xpP9kQW4GJmTNFpKKJgZF1NHHA5DU | 2022-01-23T19:59:24.000Z | tf59FkdUui9XWZxoKwK2K86RY5pcv5ZH1wG9n7rXfhj | Deactivate | Stake11111111111111111111111111111111111111 | 6Ldpww3gVC5SzE7UKMgaT8vmM8yPtmUgtbHQu4YZ9Lih | 0 | 0 | 6Ldpww3gVC5SzE7UKMgaT8vmM8yPtmUgtbHQu4YZ9Lih | | |
| 117473944 | 117473944-5crSynAaVSWgQTZHCHn3ALcXeZQMNQaQvL6hHsRAyp5YHe4NaVp2c2chS7oYraSeyBXS7nf5PQFc9vAqhCRiVYqP-0 | SysvarC1ock11111111111111111111111111111111 | 5crSynAaVSWgQTZHCHn3ALcXeZQMNQaQvL6hHsRAyp5YHe4NaVp2c2chS7oYraSeyBXS7nf5PQFc9vAqhCRiVYqP | 2022-01-23T14:04:19.000Z | 6NftWaYV6m3iGsjeuC3e1J2L7We1GYVZG7xh7CvPYJU6 | Deactivate | Stake11111111111111111111111111111111111111 | 7V5fqQKrgNoAtjsKchKfuZxLQyc8mWwZPtN5WrWDDKeh | 0 | 0 | 7V5fqQKrgNoAtjsKchKfuZxLQyc8mWwZPtN5WrWDDKeh | | |
| 117386202 | 117386202-3ZiweuhXDdjgvUkgrkL7cRUe6j9uLvdj17G2cER6MdR3MaFr29TaKoG3jmbrBLdbtFSNNZsV7rfheNd4YtENct8U-0 | SysvarC1ock11111111111111111111111111111111 | 3ZiweuhXDdjgvUkgrkL7cRUe6j9uLvdj17G2cER6MdR3MaFr29TaKoG3jmbrBLdbtFSNNZsV7rfheNd4YtENct8U | 2022-01-23T00:33:18.000Z | DM4wiXRt9RCST3FkTPVX28EcRf3ThUtB3tiTcsfPeyZn | Deactivate | Stake11111111111111111111111111111111111111 | 9sp8rqBBLcNi2hAJY3kS8sFgPKCwthxBTW3FCequX7PN | 0 | 0 | 9sp8rqBBLcNi2hAJY3kS8sFgPKCwthxBTW3FCequX7PN | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| block\_slot | surrogate\_key | in\_voteAccount | transaction\_id | block\_timestamp | in\_stakeAccount | instruction\_type | executing\_account | instruction\_index | transaction\_index | transaction\_signer | in\_referenceVoteAccount | outer\_executing\_account | outer\_instruction\_index |
| ----------- | ----------------------------------------------------------------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | -------------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| block\_slot | surrogate\_key | in\_clockSysvar | in\_voteAccount | transaction\_id | block\_timestamp | in\_stakeAccount | instruction\_type | executing\_account | in\_stakeAuthority | instruction\_index | 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 | 0 | 22 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | StakeConfig11111111111111111111111111111111 | SysvarStakeHistory1111111111111111111111111 | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 1 |
| 233783228 | 233783228-c3DJEKQpWR7PDPafiE73PHdxc3G3XeYJBaivJ3KiniUqXrge6gK8k2X6icjRD9qc7EjAjCqFr3itjqfPnR34Nvu-1-0 | SysvarC1ock11111111111111111111111111111111 | 1KXz4xKV2viJCGpxqnQqdf2J45vQr5USdmtcJLTaHkm | c3DJEKQpWR7PDPafiE73PHdxc3G3XeYJBaivJ3KiniUqXrge6gK8k2X6icjRD9qc7EjAjCqFr3itjqfPnR34Nvu | 2023-12-03T16:53:57.000Z | ChwDiVS188uShiEUwJAf2bz6wviEyYN6auovtq7GzMjk | DelegateStake | Stake11111111111111111111111111111111111111 | stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq | 0 | 65 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | StakeConfig11111111111111111111111111111111 | SysvarStakeHistory1111111111111111111111111 | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 1 |
| 233793550 | 233793550-bxnkeAYtxCxNPVRJw3yfmUVbBm12wWkAdgs75sTVde91sAQVNhCyVkLQzYsVhMJa2VwzpAKcRFfyNkDMtuQvr67-2-0 | SysvarC1ock11111111111111111111111111111111 | 1KXz4xKV2viJCGpxqnQqdf2J45vQr5USdmtcJLTaHkm | bxnkeAYtxCxNPVRJw3yfmUVbBm12wWkAdgs75sTVde91sAQVNhCyVkLQzYsVhMJa2VwzpAKcRFfyNkDMtuQvr67 | 2023-12-03T18:06:38.000Z | CrHyesRvvVcqRjT9kMkXpwm6i56tFQ9uNjVYu6avA64K | DelegateStake | Stake11111111111111111111111111111111111111 | stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq | 0 | 5 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | StakeConfig11111111111111111111111111111111 | SysvarStakeHistory1111111111111111111111111 | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 2 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_epoch | in\_staker | block\_slot | in\_custodian | in\_rentSysvar | in\_withdrawer | surrogate\_key | transaction\_id | block\_timestamp | in\_stakeAccount | in\_unixTimestamp | instruction\_type | executing\_account | instruction\_index | transaction\_index | transaction\_signer | outer\_executing\_account | outer\_instruction\_index | in\_write\_uninitialized\_stake\_account |
| --------- | -------------------------------------------- | ----------- | -------------------------------------------- | ------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- | -------------------------------------------- |
| 0 | Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw | 122487469 | Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw | SysvarRent111111111111111111111111111111111 | Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw | 122487469-2Vatxf8xG5jAJ4a2FH6PpL34k2WhS2tAMQvs3Cdpft2zsXmH6jWo1n7mJzBcD2nMBFwzJkSC7VcHq5NwVSAx4JJ5-1 | 2Vatxf8xG5jAJ4a2FH6PpL34k2WhS2tAMQvs3Cdpft2zsXmH6jWo1n7mJzBcD2nMBFwzJkSC7VcHq5NwVSAx4JJ5 | 2022-02-26T00:30:49.000Z | 51ZVzJh22bTkMPHdSzNHKUJriirZ8zGFYFqftwAWJyaH | | Initialize | Stake11111111111111111111111111111111111111 | 1 | 0 | Aq9MknkWnvtPZKiL7qdarsS9jggg2JFkMZ9E6q1VDKYw | | | 51ZVzJh22bTkMPHdSzNHKUJriirZ8zGFYFqftwAWJyaH |
| 0 | 68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f | 122531479 | 68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f | SysvarRent111111111111111111111111111111111 | 68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f | 122531479-2PWETdpiQ1kEfjpeujr6qLcRuNwEidBwwMweqftNEPhPPatFMuw9rnawpyw7zfm9eSboyAzU5GbearcnXn6V7sTL-1 | 2PWETdpiQ1kEfjpeujr6qLcRuNwEidBwwMweqftNEPhPPatFMuw9rnawpyw7zfm9eSboyAzU5GbearcnXn6V7sTL | 2022-02-26T07:32:39.000Z | GHvjvjkhbsw3bxNVwg4VzpAnQN8ZVVNVZ2MQ16FW8Q9L | | Initialize | Stake11111111111111111111111111111111111111 | 1 | 0 | 68CzRKMBi6497dMytkWt67nitCb41vSCEmWDnkaZZs5f | | | GHvjvjkhbsw3bxNVwg4VzpAnQN8ZVVNVZ2MQ16FW8Q9L |
| 0 | AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5 | 122514855 | AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5 | SysvarRent111111111111111111111111111111111 | AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5 | 122514855-3rsCTbV561NUbCp8Qzzzk9hLLMzo1RAk7eKDyqG7T3j9FTxSFBXCE7tCLbDRuvohc6jWmAS4XMNx2ggYcombCdf8-1 | 3rsCTbV561NUbCp8Qzzzk9hLLMzo1RAk7eKDyqG7T3j9FTxSFBXCE7tCLbDRuvohc6jWmAS4XMNx2ggYcombCdf8 | 2022-02-26T04:55:12.000Z | 52X4jSAa1KNz5VWg9N6pmL4aQc993Xafb5HUm38EVGp3 | | Initialize | Stake11111111111111111111111111111111111111 | 1 | 1 | AFZkUQwikAv7sJknNsCJ7qSkPeNPXqfmPiyWReLvr3K5 | | | 52X4jSAa1KNz5VWg9N6pmL4aQc993Xafb5HUm38EVGp3 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ----------- | ------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_source | block\_slot | in\_lamports | surrogate\_key | in\_destination | transaction\_id | block\_timestamp | instruction\_type | executing\_account | in\_stakeAuthority | instruction\_index | 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 | 0 | 150 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 9 |
| Dt5JPbq2Vw8gkminYXJwbcTiLLyP8bqPwufYZoX7k8SK | 338516141 | 25509 | 338516141-1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh-10-0 | 3yi8LcfWxu4ouJnYLoyQrBV9QZ3Ka3sWpky3U2BBghvy | 1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh | 2025-05-07T21:59:26.000Z | MoveLamports | Stake11111111111111111111111111111111111111 | stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq | 0 | 150 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 10 |
| 45v3JrtWauCfSwz2sF4cwM8fzHRyGXzsjUvukjgoeRKV | 338516141 | 120049 | 338516141-1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh-2-0 | 3yi8LcfWxu4ouJnYLoyQrBV9QZ3Ka3sWpky3U2BBghvy | 1hrbNNzchcTsBmof33PygNrZTJQGJgTQMuj85173VeiFBuqnsfPH39MhKAmYTceaEU1hQRgAfWEPBqtWthajwoh | 2025-05-07T21:59:26.000Z | MoveLamports | Stake11111111111111111111111111111111111111 | stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq | 0 | 150 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 2 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_source | block\_slot | in\_lamports | surrogate\_key | in\_destination | transaction\_id | block\_timestamp | instruction\_type | executing\_account | in\_stakeAuthority | instruction\_index | 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 | 0 | 65 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 6 |
| 2DLNZFY7Tn8HEJT4zsmJGCqCiQeSCRSMSsDbzaPUKNz7 | 340284081 | 1285210440 | 340284081-2BrqYisG2Mex41TibWk4UkDKiL1nwmqKkj77H9S5teUt2xNC9TN6Mr6tYureYbqriSwyqbZEQwyEXiaDMjkhrFei-7-0 | FJsf4qxuf8ZvjhEMe5tuYRdxyxTCXrZpz1BFxowsU3zb | 2BrqYisG2Mex41TibWk4UkDKiL1nwmqKkj77H9S5teUt2xNC9TN6Mr6tYureYbqriSwyqbZEQwyEXiaDMjkhrFei | 2025-05-16T00:10:40.000Z | MoveStake | Stake11111111111111111111111111111111111111 | stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq | 0 | 77 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 7 |
| BDcU733tPX5TMAEHCkkyUd4j6QG5yN84sCCpbEdvu9gq | 340284081 | 2059825741 | 340284081-3CiGZv2wFTmjGTDYPnU4wRK9Haf4YLsRdKF1wdPKtwgbhJ3PrFkd5UNizJWUPK4isNk33iRtDKQRYnJGSx5utYpK-5-0 | 8mSxKYTL6NbVC7BZECu1Wffrcra42byjPVGWyyZuFmLh | 3CiGZv2wFTmjGTDYPnU4wRK9Haf4YLsRdKF1wdPKtwgbhJ3PrFkd5UNizJWUPK4isNk33iRtDKQRYnJGSx5utYpK | 2025-05-16T00:10:40.000Z | MoveStake | Stake11111111111111111111111111111111111111 | stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq | 0 | 89 | opNS8ENpEMWdXcJUgJCsJTDp7arTXayoBEeBUg6UezP | mnspJQyF1KdDEs5c6YJPocYdY1esBgVQFufM2dY9oDk | 5 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| block\_slot | in\_custodian | surrogate\_key | in\_lockupEpoch | 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 | 0 | 37Z7Mn56b7rqfiuQP2tNSaiicqHDecMeGBi7RcboewKHaDBDJ5AnMebi7bjb3UXcmWBzvriAHNLRJdPoAnmtCarb | 2023-01-17T09:33:13.000Z | 5mVUwUwmGPSXUHfevvzjtqqABhvaVAydhX4axEdSPvWG | SetLockup | Stake11111111111111111111111111111111111111 | 1 | 48 | 11111111111111111111111111111111 | 8QakJQ53rJgK5BpHfvthwE8cFkBKQQQnNNzVp5Qx7Z9W | mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY | 0 |
| 172948056 | FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw | 172948056-24kFH5ud8zS43adfb9n1apu6947ipiRh4FxtCg4gbVojQHSnfRpTguoiNL5etJnxwXQwiSgcD6vFM2tax34TsoQ8-0-1 | 0 | 24kFH5ud8zS43adfb9n1apu6947ipiRh4FxtCg4gbVojQHSnfRpTguoiNL5etJnxwXQwiSgcD6vFM2tax34TsoQ8 | 2023-01-17T10:37:39.000Z | 9rWg53h3pTv2vzPfFLqKV3Vknfvgcp492utWzaCeWR4i | SetLockup | Stake11111111111111111111111111111111111111 | 1 | 53 | 11111111111111111111111111111111 | FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw | mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY | 0 |
| 172947641 | FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw | 172947641-KPuWupoVwP2dKTg8MbHmeqg3ukjZxyxe5JP5fsAe1mqHKq8dvZ4tsxfXiM9Ldvg7kBLuRNSRu2kAXghcWik5Tjq-1-1 | 0 | KPuWupoVwP2dKTg8MbHmeqg3ukjZxyxe5JP5fsAe1mqHKq8dvZ4tsxfXiM9Ldvg7kBLuRNSRu2kAXghcWik5Tjq | 2023-01-17T10:34:17.000Z | 8UvbLbJu5KXtmpyanoUKj6UmJoGwiCn4aL4KkWVYYP3D | SetLockup | Stake11111111111111111111111111111111111111 | 1 | 18 | 11111111111111111111111111111111 | FynoFykyYHgqcEejW5MUTjXKmb1WPb6J29m73f3EUggw | mRefx8ypXNxE59NhoBqwqb3vTvjgf8MYECp4kgJWiDY | 1 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| ----------- | ------------ | --------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | -------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| block\_slot | in\_lamports | surrogate\_key | in\_clockSysvar | in\_destination | transaction\_id | block\_timestamp | in\_stakeAccount | instruction\_type | executing\_account | instruction\_index | transaction\_index | transaction\_signer | in\_withdrawAuthority | in\_stakeHistorySysvar | outer\_executing\_account | outer\_instruction\_index |
| ----------- | ------------ | ---------------------------------------------------------------------------------------------------- | ------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | -------------------------------------------- | ------------------------------------------- | ------------------------- | ------------------------- |
| 148193169 | 110823744 | 148193169-4KkNT8aFRJyvbR7VzqusDRoDgtdAXKoCZDU86gePLF8Qjzx7iam2GNSpAeJXVjaA1meBnDKQYKcLYsPun78EQ2cv-0 | SysvarC1ock11111111111111111111111111111111 | 12EnXscJHN8ABiVdR7qempF1BunLix9hqNXgvgUTZDrU | 4KkNT8aFRJyvbR7VzqusDRoDgtdAXKoCZDU86gePLF8Qjzx7iam2GNSpAeJXVjaA1meBnDKQYKcLYsPun78EQ2cv | 2022-08-29T11:55:08.000Z | 4Lm2d9MRWei6W71raGFhJw3b7PWqkaw8xqamvx9z4vDz | Withdraw | Stake11111111111111111111111111111111111111 | 0 | 136 | 12EnXscJHN8ABiVdR7qempF1BunLix9hqNXgvgUTZDrU | 12EnXscJHN8ABiVdR7qempF1BunLix9hqNXgvgUTZDrU | SysvarStakeHistory1111111111111111111111111 | | |
| 148199772 | 18406144790 | 148199772-3KHgFCnUQvBN2kTdyY9jX91nSUaEqt3SVAnzhweQMs93dDfMTMLot8F2wpuP4ZrgZSDvj8VpFqZpSGL654bSD1xX-0 | SysvarC1ock11111111111111111111111111111111 | 13NMcdzmuJfxA742AynbZTADTaJvUF9otu3BdDydZxMg | 3KHgFCnUQvBN2kTdyY9jX91nSUaEqt3SVAnzhweQMs93dDfMTMLot8F2wpuP4ZrgZSDvj8VpFqZpSGL654bSD1xX | 2022-08-29T12:59:39.000Z | 9eiwuJaymom9SjNFJ54y9PogFUD6mVbHu7cwKngLUXvG | Withdraw | Stake11111111111111111111111111111111111111 | 0 | 357 | 13NMcdzmuJfxA742AynbZTADTaJvUF9otu3BdDydZxMg | 13NMcdzmuJfxA742AynbZTADTaJvUF9otu3BdDydZxMg | SysvarStakeHistory1111111111111111111111111 | | |
| 148201460 | 506105181 | 148201460-63KhUC4uthhkuPBYSbRJFPkdG8HSKtNY4BhTBrdFsDo631fCqHeKBzk4EKqybDvFjvF121ZnyH67CnVjQc9skyzm-0 | SysvarC1ock11111111111111111111111111111111 | 13Z8X2ehiUR1SSXvAEqqo1S5oUS5Kdt7esiTobVCpM5Y | 63KhUC4uthhkuPBYSbRJFPkdG8HSKtNY4BhTBrdFsDo631fCqHeKBzk4EKqybDvFjvF121ZnyH67CnVjQc9skyzm | 2022-08-29T13:16:26.000Z | 7G4bUWUiRwatJfxu5RE8T1qFVFZHFBdGoMd1qhRiqyUj | Withdraw | Stake11111111111111111111111111111111111111 | 0 | 159 | 13Z8X2ehiUR1SSXvAEqqo1S5oUS5Kdt7esiTobVCpM5Y | 13Z8X2ehiUR1SSXvAEqqo1S5oUS5Kdt7esiTobVCpM5Y | SysvarStakeHistory1111111111111111111111111 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ----------- | -------------------------------------------- | -------------- | ------------------------------------------------------------------------------------------------------ | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ------------------ | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | -------------------------------------------- | ------------------------- |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ----------- | -------------------------------------------- | -------------- | ---------------------------------------------------------------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ------------------ | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ------------------------------------------- | ----------- | ------------ | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_mint | block\_slot | in\_decimals | surrogate\_key | transaction\_id | block\_timestamp | in\_mintAuthority | instruction\_type | executing\_account | instruction\_index | transaction\_index | transaction\_signer | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ----------- | ------------ | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ----------- | -------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ----------- | -------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
| ----------- | ------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ------------------ | ------------------------------------------- | ------------------ | ------------------ | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ----------- | ------------ | ------------------------------------------- | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------------------------------------------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | ------------------ | -------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_mint | block\_slot | in\_decimals | surrogate\_key | transaction\_id | block\_timestamp | in\_mintAuthority | instruction\_type | executing\_account | in\_signerAccounts | instruction\_index | transaction\_index | in\_freezeAuthority | transaction\_signer | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ----------- | ------------ | ---------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ---------------------------------------------------------------------------------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | ------------------ | ---------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- | ------------------------- | ------------------------- |
| DMxxdCdUfA2A4aZ3nVyBTRunMDQYDdYXVwnTE1AnSE6K | 128410062 | 0 | 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 | 0 | 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 | 0 | 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 | | |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.solana_v1_solana.TokenProgram_InitializeMint2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***