solana

Tables

account_activity

Account state changes for Solana accounts within each transaction, capturing SOL balance and SPL token (mint, owner, amount, program) pre and post-transaction states. Used for tracking balance flows, token transfers, and account interactions across the Solana network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_id`	`STRING`	Unique identifier for the transaction on the blockchain. String format varies by chain: 66-character hex with 0x prefix for EVM chains, base58-encoded for Solana, alphanumeric without prefix for Algorand.
`signer`	`STRING`	Account address that signed and authorized the transaction. Base58-encoded string for Solana, alphanumeric string for Stellar.
`account_key`	`STRING`	Public key of the account affected by this transaction, typically a base58-encoded Solana address. Can represent program IDs (like the system program “11111111111111111111111111111111”), token accounts, or user wallets involved in the transaction.
`account_index`	`INT64`	Position of this account within the transaction’s ordered account list. Zero-indexed integer indicating the account’s sequence in the transaction’s account array.
`pre_balance`	`INT64`	Account’s SOL balance in lamports before the transaction executed. One lamport equals 0.000000001 SOL; null when the account holds only SPL tokens without native SOL.
`post_balance`	`INT64`	Account balance in lamports (1 SOL = 1 billion lamports) after the transaction executed. Native SOL balance for the account at this position in the transaction’s account array.
`pre_token_amount`	`FLOAT64`	Token balance held by the account before the transaction, measured in the token’s native units (accounting for decimals). Null for SOL balance changes or accounts not holding SPL tokens.
`pre_token_mint`	`STRING`	Token mint address before the transaction executed for SPL token accounts. Null for native SOL balance changes or non-token accounts.
`pre_token_owner`	`STRING`	Token account owner address before the transaction, identifying which wallet controls the SPL token account. Null for native SOL balance changes or accounts not associated with SPL tokens.
`pre_token_program`	`STRING`	Token program address that owned the token account before the transaction executed. Null for native SOL balance changes or when the account is not a token account.
`post_token_amount`	`FLOAT64`	Token balance of the account after transaction execution, denominated in the token’s native units. Null for SOL balance changes (use post_balance instead) or when the account does not hold SPL tokens.
`post_token_mint`	`STRING`	Token mint address after the transaction executed, identifying the SPL token type held in this account. Null when the account holds native SOL rather than SPL tokens.
`post_token_owner`	`STRING`	Token owner account address after the transaction, representing who controls the SPL token account. Null for SOL-only transactions or accounts without token balances.
`post_token_program`	`STRING`	Program ID that owns the token account after the transaction. Null for SOL balance changes; populated for SPL token operations.

Sample Data

signer	block_slot	account_key	pre_balance	post_balance	account_index	transaction_id	block_timestamp	transaction_index
98xYeL9EAF9mAcgMRaPm8U2LLu84DVU6rw682hbJav47	311159530	11111111111111111111111111111111	1	1	9	23GQMxDfjcdWnXQiU4qTdqVQwV68L1XmUjVqm9rfkFAjRHEXSuQuLMM5zSH3cS1fQxrLiCtzAxbMxQMxMHCpwFyd	2025-01-01T08:53:26.000Z	120
2idELTBheyiY5DQi541xnaeqTJiC5fVCWSeLG5kVCsJa	311233323	11111111111111111111111111111111	1	1	2	1e3RJaDzYKizitkrG25mxWMw5yR5vJhje73wVBL31E26nMbTf4JCrJMk7Fi1L8xtAUuWgLNnqVPosFEGJbkGFzc	2025-01-01T17:15:20.000Z	59
9GdheLHgegEnBkAVcR8PVpUMzJscHvyjFnUomwHamHGw	311239029	11111111111111111111111111111111	1	1	14	1PKBjk3qa94NgPexQfsrxKmRpo6LmBFD5zeYJb5RYnp3YhevgyxnSnEHK3MBpySCUqrgVnbVHgr6WCMXJXv8KYL	2025-01-01T17:54:27.000Z	359

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.account_activity`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.

Columns

Column	Type	Description
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`block_height`	`INT64`	Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`parent_slot`	`INT64`	Slot number of the immediately preceding block in Solana’s slot sequence. May skip slots if no block was produced, as seen when parent_slot increments by more than one between consecutive blocks.
`previous_block_hash`	`STRING`	Hash of the previous block in the blockchain, linking blocks in chronological sequence to form the chain structure.
`total_transaction_count`	`INT64`	Total count of all transactions included in this block, including both vote and non-vote transactions. Sum equals `successful_transaction_count` plus `failed_transaction_count`.
`successful_transaction_count`	`INT64`	Number of transactions that executed successfully in this block, including both vote and non-vote transactions. Always equals the sum of successful_vote_transaction_count and successful_non_vote_transaction_count.
`failed_transaction_count`	`INT64`	Total count of transactions in this block that failed execution. Includes both vote and non-vote transactions that were included in the block but did not complete successfully.
`vote_transaction_count`	`INT64`	Number of validator consensus vote transactions included in this block. Vote transactions are used by validators to participate in Solana’s Proof of Stake consensus mechanism and are tracked separately from user transactions.
`non_vote_transaction_count`	`INT64`	Number of non-vote transactions included in this block, regardless of execution status. Vote transactions are consensus-related validator activities excluded from this count.
`successful_vote_transaction_count`	`INT64`	Count of validator voting transactions that successfully executed within this block. Always zero in these samples as vote transactions are tracked separately from user transactions.
`successful_non_vote_transaction_count`	`INT64`	Number of non-vote transactions that executed successfully in this block. Excludes validator consensus vote transactions, counting only user-initiated or program transactions that completed without errors.
`failed_vote_transaction_count`	`INT64`	Number of validator vote transactions that failed execution in this block. Always zero in sample data as vote transactions rarely fail on Solana.
`failed_non_vote_transaction_count`	`INT64`	Number of non-vote transactions that failed execution in this block. Non-vote transactions exclude validator consensus votes and represent user-initiated activity like transfers, swaps, and program interactions.
`total_fee`	`INT64`	Total sum of transaction fees collected in the block. Denominated in the smallest unit of the native token (satoshis for Bitcoin/Litecoin, lamports for Solana).
`successful_vote_transactions_fee`	`INT64`	Total fees in lamports collected from successful vote transactions in this block. Always zero in practice as validator vote transactions are subsidized by the protocol and do not charge fees.
`successful_non_vote_transactions_fee`	`INT64`	Total fees collected in lamports from all successfully executed non-vote transactions in this block. Excludes priority fees, representing only the base transaction costs paid by users.
`failed_vote_transactions_fee`	`INT64`	Total fees paid by failed vote transactions in this block, measured in lamports (1 SOL = 1 billion lamports). Typically zero as vote transactions are validator consensus messages that rarely fail.
`failed_non_vote_transactions_fee`	`INT64`	Total fees paid by failed non-vote transactions in this block, measured in lamports (1 SOL = 1 billion lamports). Includes both base fees and priority fees for transactions that executed but did not succeed.
`successful_non_vote_transactions_priority_fee`	`INT64`	Total priority fees paid in lamports for all successfully executed non-vote transactions in this block. Priority fees are optional payments to validators for transaction prioritization, shown aggregated across all successful non-vote transactions.
`failed_non_vote_transactions_priority_fee`	`INT64`	Total priority fees paid in lamports for all failed non-vote transactions in this block. Priority fees are optional additional payments to incentivize block inclusion beyond base transaction fees.

Sample Data

total_fee	block_hash	block_slot	parent_slot	block_height	block_timestamp	previous_block_hash	total_transaction_count	failed_transaction_count	non_vote_transaction_count	successful_transaction_count	failed_non_vote_transactions_fee	failed_non_vote_transaction_count	successful_non_vote_transactions_fee	successful_non_vote_transaction_count	failed_non_vote_transactions_priority_fee	successful_non_vote_transactions_priority_fee
612908	2Ad3oUbGdyEYcXtk7PBB2hVZ3c8E8yKbAwYXtP26pfur	144728724	144728723	130650837	2022-08-06T00:02:59.000Z	FEBSry92z1z81m4Y3BDxwy4AKgiNQfRgmSC9ujVXWWW8	108	27	108	81	156628	27	456280	81	11628	11280
563030	B1KmgnTuSvopPoHz7xWS8ucESjDUPF5BcEVS6yfyNED3	144731303	144731302	130653134	2022-08-06T00:28:42.000Z	5QvraWnt9VYgV5htwBpuoSjtNSb1PU8qr8ETtLw5TtDY	78	20	78	58	244010	20	319020	58	114010	9020
3595366	HDXDVXLx1PmAgSk3FkxP3zdULozezNz9yiE5oCfJcgX6	144745269	144745268	130665970	2022-08-06T02:44:30.000Z	4LVTs8ckiYvrdHFVt1JCUmNUGHvCNYyyw7arHYDANx6u	679	215	679	464	1142011	215	2453355	464	7011	18355

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.blocks`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

failed_instructions

Solana transaction instructions that did not execute successfully, containing execution context, program addresses, and account arguments for debugging failed on-chain operations. Useful for analyzing transaction failure patterns and protocol error rates.

Columns

Column	Type	Description
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`transaction_id`	`STRING`	Unique identifier for the transaction on the blockchain. String format varies by chain: 66-character hex with 0x prefix for EVM chains, base58-encoded for Solana, alphanumeric without prefix for Algorand.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_signer`	`STRING`	Solana account address that signed and authorized the transaction. Base58-encoded string representing the fee payer and primary authority for the transaction.
`instruction_index`	`INT64`	Position of the instruction within its containing transaction. Zero-indexed integer indicating the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction when this instruction is a cross-program invocation. Zero-indexed integer, null for top-level instructions.
`executing_account`	`STRING`	Solana program address that executed the instruction. Base58-encoded string representing the on-chain program responsible for processing the instruction logic.
`outer_executing_account`	`STRING`	Solana program address of the parent instruction when this instruction is a cross-program invocation. Base58-encoded string, null for top-level instructions.
`account_arguments`	`ARRAY<STRING>`	Array of Solana account addresses that serve as input parameters to the instruction. Base58-encoded strings representing the accounts read from or written to during instruction execution.
`instruction_data`	`STRING`	Encoded payload containing the parameters and data required for the Solana program to execute the instruction. Base58-encoded string representing the serialized instruction arguments.
`stack_height`	`INT64`	Depth of cross-program invocation nesting for the instruction. Integer value starting at 1 for top-level instructions, incrementing by 1 for each nested program call.
`surrogate_key`	`STRING`	Unique identifier for the instruction composed of block slot, transaction ID, and instruction index. Hyphen-delimited string format combining blockchain position identifiers to ensure row-level uniqueness.

Sample Data

block_slot	stack_height	surrogate_key	transaction_id	block_timestamp	instruction_data	account_arguments	executing_account	transaction_index	transaction_signer
311280632	1	311280632-3WAkEqBaPzwScCr4Brxfd7VWmFm2Y1HGWnX9XvX94WEMTWnNZHqGCpMmKkZEdcCwzBDw3Z4JQuguG2biF5bUcGCC-0	3WAkEqBaPzwScCr4Brxfd7VWmFm2Y1HGWnX9XvX94WEMTWnNZHqGCpMmKkZEdcCwzBDw3Z4JQuguG2biF5bUcGCC	2025-01-01T22:38:16.000Z	6vx8P	[“CkZDFQrC4REXuVHsb6puAQdAjjTRka565yDN6UEm4KGz”,“SysvarRecentB1ockHashes11111111111111111111”,“1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed”]	11111111111111111111111111111111	683	1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed
311239920	1	311239920-nte4SYjppp3jnkP1bpY26PKrxbHtYX1m2WedtqmB4VfXWLV164EMuT6ZiRTzCg7V2G5soNbB5LTw4b15ZSVEW7o-0	nte4SYjppp3jnkP1bpY26PKrxbHtYX1m2WedtqmB4VfXWLV164EMuT6ZiRTzCg7V2G5soNbB5LTw4b15ZSVEW7o	2025-01-01T18:00:36.000Z	6vx8P	[“6v5YwqAqazfAPMXG1oV5o8TUKd8AtBW5tqqkGxKHRCaD”,“SysvarRecentB1ockHashes11111111111111111111”,“1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed”]	11111111111111111111111111111111	211	1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed
311192582	1	311192582-3GRUMKLiqpv52JfQ5yBgZRYConGmQrcBamXdQMSamkDjcw9aoYvj9CV3nDZVUWYLy5nKCFVscGkdHwrUuYt4nHkn-0	3GRUMKLiqpv52JfQ5yBgZRYConGmQrcBamXdQMSamkDjcw9aoYvj9CV3nDZVUWYLy5nKCFVscGkdHwrUuYt4nHkn	2025-01-01T12:36:58.000Z	6vx8P	[“7oc69bZ7RfBPaq3ScxcSrJRkF3rZQcRVrMAXY38z4jTd”,“SysvarRecentB1ockHashes11111111111111111111”,“1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed”]	11111111111111111111111111111111	1994	1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.failed_instructions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

failed_transactions

Failed Solana transaction records with execution errors, including insufficient lamports, account conflicts, and program failures. Used for debugging transaction issues and analyzing network error patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_id`	`STRING`	Unique identifier for the transaction on the blockchain. String format varies by chain: 66-character hex with 0x prefix for EVM chains, base58-encoded for Solana, alphanumeric without prefix for Algorand.
`account_keys`	`ARRAY<STRING>`	Array of public keys for all accounts involved in the transaction, including signers, writable accounts, and readonly accounts. Base58-encoded Solana addresses ordered by transaction account index.
`executing_accounts`	`ARRAY<STRING>`	Array of program IDs that were invoked during transaction execution. Derived from on-chain program logs showing which smart contracts were called, even when the transaction failed.
`fee`	`INT64`	Transaction fee paid to validators or network operators. Denominated in the blockchain’s native currency unit (microAlgos for Algorand, satoshis for Bitcoin, lamports for Solana, smallest divisible unit for other chains).
`signatures`	`ARRAY<STRING>`	Array of transaction signatures identifying this failed transaction. Base58-encoded strings where the first signature is from the primary fee payer.
`return_data`	`STRUCT<program_id STRING, data STRING>`	Optional data returned by programs during transaction execution. Contains the program ID and base64-encoded output data when programs explicitly return values.
`compute_units_consumed`	`INT64`	Computational resources used by the transaction measured in Solana compute units (CU). Failed transactions still consume compute units before terminating, with simple transfers typically using 150 CU.
`required_signatures_count`	`INT64`	Number of signatures required to authorize this transaction. Typically 1 for single-signer transactions, higher for multi-signature operations.
`readonly_signed_accounts_count`	`INT64`	Number of signed accounts in the transaction that have read-only access. This count is typically zero for simple transfers, indicating all signers have write permissions.
`readonly_unsigned_accounts_count`	`INT64`	Number of accounts included in the transaction that are neither signers nor writable, used only for read-only access. Typically 1 or more for transactions involving system programs or token lookups.
`log_messages`	`ARRAY<STRING>`	Array of program execution logs generated during transaction processing. Contains error messages, program invocations, and state change information useful for debugging failed transactions.
`signer`	`STRING`	Account address that signed and authorized the transaction. Base58-encoded string for Solana, alphanumeric string for Stellar.
`version`	`STRING`	Sequential version number of the transaction or block structure indicating the format specification. Integer value representing the data structure version used for encoding and validation.
`logs_truncated`	`BOOL`	Indicates whether the transaction’s log messages exceeded the maximum length and were cut off. This field is false when all logs are fully captured.
`success`	`BOOL`	Boolean indicator of whether the operation completed successfully without errors.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.

Sample Data

fee	error	signer	success	block_slot	signatures	return_data	account_keys	log_messages	logs_truncated	transaction_id	block_timestamp	transaction_index	executing_accounts	compute_units_consumed	required_signatures_count	readonly_unsigned_accounts_count
5000	feZGfvXvqNxZrHPAF	13ouppteejahWHKMb2pgC56bz9gjP9pTfigQNnGhaRHV	false	311104368	[“2A3z6xM6CK43g4rXQdfCPVPtBL3a1HZW4RoE72DbaSsAcdFuxwX62qEzzEovemQoXg9GUgaxVMardvX6nvR22uk2”]	{“data”:null,“program_id”:null}	[“13ouppteejahWHKMb2pgC56bz9gjP9pTfigQNnGhaRHV”,“12EL9xRFgqye4Qk2GHkdpovdsHGLajwrgW56Bi3KbkcC”,“11111111111111111111111111111111”]	[“Program 11111111111111111111111111111111 invoke [1]”,“Transfer: insufficient lamports 6990000, need 66955427”,“Program 11111111111111111111111111111111 failed: custom program error: 0x1”]	false	2A3z6xM6CK43g4rXQdfCPVPtBL3a1HZW4RoE72DbaSsAcdFuxwX62qEzzEovemQoXg9GUgaxVMardvX6nvR22uk2	2025-01-01T02:39:01.000Z	2057	[“11111111111111111111111111111111”]	150	1	1
5000	feZGfvXvqNxZrHPAF	2JhCguTdGR7QGZdfmZjGSWEDvUa8fDaaaDZWoHeJ5rtA	false	311088986	[“5hfbXyZf83njmBSB3pNkXesQf1bsWJMmqVHjVoMW86rKgD3kuT9xyQ5MUR1sZSYPozY12sZnsaEYYSZ5b2bnYGk6”]	{“data”:null,“program_id”:null}	[“2JhCguTdGR7QGZdfmZjGSWEDvUa8fDaaaDZWoHeJ5rtA”,“FuQRkcsgQzVmV5tLvikjVy2eLA7bPyNnGNAoSgxCwn3y”,“11111111111111111111111111111111”]	[“Program 11111111111111111111111111111111 invoke [1]”,“Transfer: insufficient lamports 4990000, need 73409115”,“Program 11111111111111111111111111111111 failed: custom program error: 0x1”]	false	5hfbXyZf83njmBSB3pNkXesQf1bsWJMmqVHjVoMW86rKgD3kuT9xyQ5MUR1sZSYPozY12sZnsaEYYSZ5b2bnYGk6	2025-01-01T00:53:41.000Z	1562	[“11111111111111111111111111111111”]	150	1	1
10010000	feZGfwGkMaXDT54NK	2KnMoM2xwYjGzszX1ynRN3DEgQcATDBrKczDstzneRGQ	false	311249645	[“2ZjksGRsHaZt46afhBefovcDzKug1TEoy4V999PPuJZbAbThSjN6B8BuKyNnHqqWF6JHC1HPvohvpDqh3fiUhGNY”,“5Et7epE8A1zRqLD62j5LQh8MmZEbFaMBBSrbDPJve3cdMD8qgRdo2FykfLGK1Ua9p33tg2scLjNTF3Rv5xbvH2vM”]	{“data”:null,“program_id”:null}	[“2KnMoM2xwYjGzszX1ynRN3DEgQcATDBrKczDstzneRGQ”,“D7fNr5dLHAmpwYRV8pBJWpa8HkXAqUrSYmuski599Szp”,“minTcHYRLVPubRK8nt6sqe2ZpWrGDLQoNLipDJCGocY”,“HfYHNu4Lm41ACdWNu1wLRY7Gac8WvHwS6KQpGJ61vsKn”,“5iKd2BkZUH2m67wdah8zS4tBvL4rtGbXSsvvSY7Ce2i4”,“11111111111111111111111111111111”,“Ea58t8WoZnuWci9LXxq2xyg9eu5MCydaBQsF1rHNE5MU”,“EStuUYa9LKi5QevUMr5LwAUDYkZdxoeKQe4XuEcjMea9”,“9DCxsMizn3H1hprZ7xWe6LDzeUeZBksYFpBWBtSf1PQX”,“G1Xmy9Qxe7kcuKuNfn8daPxpGgw3C6LiB7poC3GxqRan”,“Beuq5vDmdG7fDgCKka9b7GQH5xqG112vEQWMW9NgfBA1”,“Dtxin24c3tFc2KmLJWUBXjSZ8288TkFRvgdnxDGLwMAA”,“ADuUkR4vqLUMWXxW9gh6D6L8pMSawimctcNZ5pGwDcEt”,“ComputeBudget111111111111111111111111111111”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8”,“5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1”]	[“Program ComputeBudget111111111111111111111111111111 invoke [1]”,“Program ComputeBudget111111111111111111111111111111 success”,“Program 11111111111111111111111111111111 invoke [1]”,“Create Account: account Address { address: D7fNr5dLHAmpwYRV8pBJWpa8HkXAqUrSYmuski599Szp, base: None } already in use”,“Program 11111111111111111111111111111111 failed: custom program error: 0x0”]	false	2ZjksGRsHaZt46afhBefovcDzKug1TEoy4V999PPuJZbAbThSjN6B8BuKyNnHqqWF6JHC1HPvohvpDqh3fiUhGNY	2025-01-01T19:07:10.000Z	25	[“11111111111111111111111111111111”,“ComputeBudget111111111111111111111111111111”,“minTcHYRLVPubRK8nt6sqe2ZpWrGDLQoNLipDJCGocY”]	300	2	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.failed_transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

instructions

Low-level instruction execution records from Solana transactions, including both top-level and nested (inner) instructions with program addresses, input data, and account arguments. Used for analyzing smart contract interactions, tracking cross-program invocations via stack depth, and reconstructing transaction execution flow.

Columns

Column	Type	Description
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`transaction_id`	`STRING`	Unique identifier for the transaction on the blockchain. String format varies by chain: 66-character hex with 0x prefix for EVM chains, base58-encoded for Solana, alphanumeric without prefix for Algorand.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_signer`	`STRING`	Solana account address that signed and authorized the transaction. Base58-encoded string representing the fee payer and primary authority for the transaction.
`instruction_index`	`INT64`	Position of the instruction within its containing transaction. Zero-indexed integer indicating the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction when this instruction is a cross-program invocation. Zero-indexed integer, null for top-level instructions.
`executing_account`	`STRING`	Solana program address that executed the instruction. Base58-encoded string representing the on-chain program responsible for processing the instruction logic.
`outer_executing_account`	`STRING`	Solana program address of the parent instruction when this instruction is a cross-program invocation. Base58-encoded string, null for top-level instructions.
`account_arguments`	`ARRAY<STRING>`	Array of Solana account addresses that serve as input parameters to the instruction. Base58-encoded strings representing the accounts read from or written to during instruction execution.
`instruction_data`	`STRING`	Encoded payload containing the parameters and data required for the Solana program to execute the instruction. Base58-encoded string representing the serialized instruction arguments.
`stack_height`	`INT64`	Depth of cross-program invocation nesting for the instruction. Integer value starting at 1 for top-level instructions, incrementing by 1 for each nested program call.
`surrogate_key`	`STRING`	Unique identifier for the instruction composed of block slot, transaction ID, and instruction index. Hyphen-delimited string format combining blockchain position identifiers to ensure row-level uniqueness.

Sample Data

block_slot	stack_height	surrogate_key	transaction_id	block_timestamp	instruction_data	account_arguments	executing_account	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
311207549	2	311207549-2Bn7k77wDXDZKkMZbL5rhVEucsR3hy5YnzEghxJVnfyHcj1xJSKBDxh9oz6hjysdVdP3vvtwEXAo16Myaq3do3M3-2-0	2Bn7k77wDXDZKkMZbL5rhVEucsR3hy5YnzEghxJVnfyHcj1xJSKBDxh9oz6hjysdVdP3vvtwEXAo16Myaq3do3M3	2025-01-01T14:18:59.000Z	1111122NPtq7nzVbhd823R44A9gVhRduGynm5mUeJCZQcVvwatKpUtfYAph8ri8hxkEKBb	[“Gb92jjsvrFCMAFiAkRPjmtio5DXjWo3rFMeLNAs3dh7Z”,“BpMAqizRiKyC1TtPpHe4rSJ153ZTmVJSJ6Ra7BkBAugz”]	11111111111111111111111111111111	132	Gb92jjsvrFCMAFiAkRPjmtio5DXjWo3rFMeLNAs3dh7Z	vAuLTsyrvSfZRuRB3XgvkPwNGgYSs9YRYymVebLKoxR	2
311152445	2	311152445-2nst36UX2RnrVw6fdDQKawDejbeVihwfEos9W6CP7SjLWgmayttMZxeDLC4LnUNR234MiAms8tPzsmqTDbqxWLq8-2-0	2nst36UX2RnrVw6fdDQKawDejbeVihwfEos9W6CP7SjLWgmayttMZxeDLC4LnUNR234MiAms8tPzsmqTDbqxWLq8	2025-01-01T08:05:37.000Z	1111122NPtq7nzVbhd823R44A9gVhRduGynm5mUeJCZQcVvwatKpUtfYAph8ri8hxkEKBb	[“D6J74YsTi3EjkMkpjfL6FD1Zo5g23kCrnXt6QEbifroK”,“9paK5smGrisdz2D2yMM3FB4pxeY34F1kLuJynkbMwatY”]	11111111111111111111111111111111	48	D6J74YsTi3EjkMkpjfL6FD1Zo5g23kCrnXt6QEbifroK	vAuLTsyrvSfZRuRB3XgvkPwNGgYSs9YRYymVebLKoxR	2
311246436	2	311246436-4ubWLsr3xAU47t2hyjMv8YDr6LoHwasrW1w5zrtLKjtxENwuCTfdKxDEpVCitAYYX5CxC3x75tb8CT1S9MpHCh2M-8-0	4ubWLsr3xAU47t2hyjMv8YDr6LoHwasrW1w5zrtLKjtxENwuCTfdKxDEpVCitAYYX5CxC3x75tb8CT1S9MpHCh2M	2025-01-01T18:45:14.000Z	1111122NPtq7nzVbhd823R44A9qXHZHt5zH76XmnZH7o1gi2XbfWv7WhS8KMTR4HFD8HAt	[“5rxHwh7dVGPY2WySyTit9GeLkpty1eoBMtdPukNTmBrA”,“8DAVjYdseocd12VqgQK6xoEtD6dhVwo74oVTSh9YSQD2”]	11111111111111111111111111111111	92	5rxHwh7dVGPY2WySyTit9GeLkpty1eoBMtdPukNTmBrA	Awm2zSgzMGTRraAVjRvshqLehy7mJ2Qr3maURDsoDmwi	8

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.instructions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

rewards

Validator and staking rewards earned on Solana, denominated in lamports (1 SOL = 1 billion lamports). Used for analyzing validator economics, fee distributions, and staking yield calculations across the network.

Columns

Column	Type	Description
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`pubkey`	`STRING`	Public key of the account receiving the reward, typically a validator or fee recipient. Base58-encoded 32-byte identifier representing the Solana account address.
`lamports`	`NUMERIC`	Amount of lamports earned as reward by the recipient address. Denominated in lamports, where 1 SOL equals 1 billion lamports.
`commission`	`NUMERIC`	Commission percentage earned by the vote account on staking rewards, represented as a basis point value (0-10000). Null for fee rewards, as commission only applies to staking reward distributions.
`post_balance`	`NUMERIC`	Account balance in lamports after the reward was applied. Represents the total balance of the recipient account following the credit of the reward amount.
`reward_type`	`STRING`	Type of reward distributed to the account, such as fee, staking, voting, or rent. Sample data shows primarily fee-based rewards, though null values may occur for certain reward distributions.

Sample Data

pubkey	lamports	block_hash	block_slot	reward_type	post_balance	block_timestamp
6TkKqq15wXjqEjNg9zqTKADwuVATR9dW3rkNnsYme1ea	3440000	BuWY3c41Si3xXD2JJHoSKMMeoV1bDnhA4RL939JUpDcM	67192663	fee	553090637200	2021-03-01T00:34:16.000Z
67joanjyAoVmb9nZLyX8p3Gx9tAxzXaUgHDe3kaUH4wf	3440000	8DvNCm9UHEwFms7P4BQbCX63nb3pPVwYc1iB6yF9TDjm	67200433	fee	427783884503	2021-03-01T02:07:30.000Z
3xGDUST5CKZsiW4L5PPp9E63X3PdqRvCJfDM3q9EYcB4	3440000	2o7pJmwS9RSVfFqzyrybn8MkQc6c9FRWvoPtMXyWMj7k	67205977	fee	447210486599	2021-03-01T03:14:01.000Z

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.rewards`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_slot`	`INT64`	Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`transaction_id`	`STRING`	Unique identifier for the transaction on the blockchain. String format varies by chain: 66-character hex with 0x prefix for EVM chains, base58-encoded for Solana, alphanumeric without prefix for Algorand.
`account_keys`	`ARRAY<STRING>`	Array of all account public keys involved in the transaction, including signers, writable accounts, and read-only accounts. First element is typically the transaction fee payer.
`executing_accounts`	`ARRAY<STRING>`	Array of program IDs invoked during transaction execution, derived from log messages. Empty for transactions that fail or execute no on-chain programs.
`fee`	`INT64`	Transaction fee paid to validators or network operators. Denominated in the blockchain’s native currency unit (microAlgos for Algorand, satoshis for Bitcoin, lamports for Solana, smallest divisible unit for other chains).
`signatures`	`ARRAY<STRING>`	List of base58-encoded transaction signatures authorizing this transaction. Typically contains one signature but can include multiple for multi-signature transactions.
`return_data`	`STRUCT<program_id STRING, data STRING>`	Data returned by a program invoked in the transaction, containing the program ID and base64-encoded result. Null for most transactions unless a program explicitly returns data.
`compute_units_consumed`	`INT64`	Computational resources consumed during transaction execution on the Solana virtual machine. Measured in compute units (CU), with typical simple transfers consuming 150 CU and complex program interactions consuming more.
`required_signatures_count`	`INT64`	Number of signatures required for this transaction to be valid. Typically 1 for simple transfers, higher for multi-signature accounts.
`readonly_signed_accounts_count`	`INT64`	Number of accounts with read-only access that provided signatures for this transaction. Typically 0 for standard transfers, may be higher for complex multi-signature operations.
`readonly_unsigned_accounts_count`	`INT64`	Number of accounts that are read-only and not required to sign the transaction. These accounts are used by programs to reference data or state without modification or authorization.
`log_messages`	`ARRAY<STRING>`	Program execution logs from Solana runtime showing invoked programs and their success/failure status. Array of strings containing messages like “Program {program_id} invoke [depth]” and result indicators, empty for transactions without program calls.
`signer`	`STRING`	Account address that signed and authorized the transaction. Base58-encoded string for Solana, alphanumeric string for Stellar.
`version`	`STRING`	Sequential version number of the transaction or block structure indicating the format specification. Integer value representing the data structure version used for encoding and validation.
`logs_truncated`	`BOOL`	Indicates whether the transaction’s execution logs were cut off due to exceeding maximum log message storage limits. Typically false for most transactions; true when program output is excessively verbose.
`success`	`BOOL`	Boolean indicator of whether the operation completed successfully without errors.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.

Sample Data

fee	signer	success	version	block_slot	signatures	return_data	account_keys	log_messages	logs_truncated	transaction_id	block_timestamp	transaction_index	executing_accounts	compute_units_consumed	required_signatures_count	readonly_unsigned_accounts_count
5000	HbwvjjeAvonHkQknfAUZeLb53vVYHAUwFgpoRFS8shVc	true	legacy	339212825	[“1JHqBtu3W3oampyHq9CjNTFuAwL8Rtugxj7tbzs5F549t3cA7oxotb3X7pVGjVcdzfc8vFAjhD9rgAivdqsJsCx”]	{“data”:null,“program_id”:null}	[“HbwvjjeAvonHkQknfAUZeLb53vVYHAUwFgpoRFS8shVc”]	[]	false	1JHqBtu3W3oampyHq9CjNTFuAwL8Rtugxj7tbzs5F549t3cA7oxotb3X7pVGjVcdzfc8vFAjhD9rgAivdqsJsCx	2025-05-11T02:21:13.000Z	338	[]	0	1	0
5000	HcJsuC9d672vuBsSDLKWLUpSm1iGhsgWQuHNGE82JZRg	true	0	339359875	[“1KPRe1FVqsQZj1v4J1fHAhWrJx9zC4G8MjfdGSqSthktgVxVVjbGy3gqawrecwE6TkSMdKnXh1Mmt7ZTUyam86s”]	{“data”:null,“program_id”:null}	[“HcJsuC9d672vuBsSDLKWLUpSm1iGhsgWQuHNGE82JZRg”,“Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY”,“11111111111111111111111111111111”]	[“Program 11111111111111111111111111111111 invoke [1]”,“Program 11111111111111111111111111111111 success”]	false	1KPRe1FVqsQZj1v4J1fHAhWrJx9zC4G8MjfdGSqSthktgVxVVjbGy3gqawrecwE6TkSMdKnXh1Mmt7ZTUyam86s	2025-05-11T18:28:34.000Z	265	[“11111111111111111111111111111111”]	150	1	1
5000	9cvoyBnNU2xXunXXtY2x7NyGSffQAMeiEHwPt9CbzZnD	true	0	339278304	[“18yNKKLmbDpFtGoj6kWcaCPfCuJFMPKJhpCuKBoRZGQX55j96TZnzmFyCV7Md93YUKuCFP93yaggf88kBZVep9P”]	{“data”:null,“program_id”:null}	[“9cvoyBnNU2xXunXXtY2x7NyGSffQAMeiEHwPt9CbzZnD”,“5Pc8FXNBrzdRkmmvDWt7pWHQ5cKC1uRqQN7MKMGXA7D8”,“11111111111111111111111111111111”]	[“Program 11111111111111111111111111111111 invoke [1]”,“Program 11111111111111111111111111111111 success”]	false	18yNKKLmbDpFtGoj6kWcaCPfCuJFMPKJhpCuKBoRZGQX55j96TZnzmFyCV7Md93YUKuCFP93yaggf88kBZVep9P	2025-05-11T09:31:36.000Z	59	[“11111111111111111111111111111111”]	150	1	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.solana.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

account_activity

blocks

failed_instructions

failed_transactions

instructions

rewards

transactions

​Tables

​account_activity

​blocks

​failed_instructions

​failed_transactions

​instructions

​rewards

​transactions

Tables

account_activity

blocks

failed_instructions

failed_transactions

instructions

rewards

transactions