Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_idSTRINGUnique 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.
signerSTRINGAccount address that signed and authorized the transaction. Base58-encoded string for Solana, alphanumeric string for Stellar.
account_keySTRINGPublic 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_indexINT64Position 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_balanceINT64Account’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_balanceINT64Account 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_amountFLOAT64Token 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_mintSTRINGToken mint address before the transaction executed for SPL token accounts. Null for native SOL balance changes or non-token accounts.
pre_token_ownerSTRINGToken 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_programSTRINGToken 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_amountFLOAT64Token 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_mintSTRINGToken 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_ownerSTRINGToken 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_programSTRINGProgram ID that owns the token account after the transaction. Null for SOL balance changes; populated for SPL token operations.
signerblock_slotaccount_keypre_balancepost_balanceaccount_indexpre_token_minttransaction_idblock_timestamppost_token_mintpre_token_ownerpost_token_ownerpre_token_amountpost_token_amountpre_token_programtransaction_indexpost_token_program
98xYeL9EAF9mAcgMRaPm8U2LLu84DVU6rw682hbJav473111595301111111111111111111111111111111111923GQMxDfjcdWnXQiU4qTdqVQwV68L1XmUjVqm9rfkFAjRHEXSuQuLMM5zSH3cS1fQxrLiCtzAxbMxQMxMHCpwFyd2025-01-01T08:53:26.000Z120
2idELTBheyiY5DQi541xnaeqTJiC5fVCWSeLG5kVCsJa311233323111111111111111111111111111111111121e3RJaDzYKizitkrG25mxWMw5yR5vJhje73wVBL31E26nMbTf4JCrJMk7Fi1L8xtAUuWgLNnqVPosFEGJbkGFzc2025-01-01T17:15:20.000Z59
9GdheLHgegEnBkAVcR8PVpUMzJscHvyjFnUomwHamHGw3112390291111111111111111111111111111111111141PKBjk3qa94NgPexQfsrxKmRpo6LmBFD5zeYJb5RYnp3YhevgyxnSnEHK3MBpySCUqrgVnbVHgr6WCMXJXv8KYL2025-01-01T17:54:27.000Z359
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.
ColumnTypeDescription
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
block_heightINT64Sequential position of the block in the blockchain. Zero-indexed integer representing the block’s distance from the genesis block.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
parent_slotINT64Slot 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_hashSTRINGHash of the previous block in the blockchain, linking blocks in chronological sequence to form the chain structure.
total_transaction_countINT64Total 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_countINT64Number 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_countINT64Total 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_countINT64Number 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_countINT64Number 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_countINT64Count 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_countINT64Number 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_countINT64Number 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_countINT64Number 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_feeINT64Total 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_feeINT64Total 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_feeINT64Total 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_feeINT64Total 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_feeINT64Total 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_feeINT64Total 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_feeINT64Total 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.
total_feeblock_hashblock_slotparent_slotblock_heightblock_timestampprevious_block_hashvote_transaction_counttotal_transaction_countfailed_transaction_countnon_vote_transaction_countfailed_vote_transactions_feesuccessful_transaction_countfailed_vote_transaction_countfailed_non_vote_transactions_feesuccessful_vote_transactions_feefailed_non_vote_transaction_countsuccessful_vote_transaction_countsuccessful_non_vote_transactions_feesuccessful_non_vote_transaction_countfailed_non_vote_transactions_priority_feesuccessful_non_vote_transactions_priority_fee
6129082Ad3oUbGdyEYcXtk7PBB2hVZ3c8E8yKbAwYXtP26pfur1447287241447287231306508372022-08-06T00:02:59.000ZFEBSry92z1z81m4Y3BDxwy4AKgiNQfRgmSC9ujVXWWW801082710808101566280270456280811162811280
563030B1KmgnTuSvopPoHz7xWS8ucESjDUPF5BcEVS6yfyNED31447313031447313021306531342022-08-06T00:28:42.000Z5QvraWnt9VYgV5htwBpuoSjtNSb1PU8qr8ETtLw5TtDY078207805802440100200319020581140109020
3595366HDXDVXLx1PmAgSk3FkxP3zdULozezNz9yiE5oCfJcgX61447452691447452681306659702022-08-06T02:44:30.000Z4LVTs8ckiYvrdHFVt1JCUmNUGHvCNYyyw7arHYDANx6u0679215679046401142011021502453355464701118355
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.
ColumnTypeDescription
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
transaction_idSTRINGUnique 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_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_signerSTRINGSolana account address that signed and authorized the transaction. Base58-encoded string representing the fee payer and primary authority for the transaction.
instruction_indexINT64Position of the instruction within its containing transaction. Zero-indexed integer indicating the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction when this instruction is a cross-program invocation. Zero-indexed integer, null for top-level instructions.
executing_accountSTRINGSolana program address that executed the instruction. Base58-encoded string representing the on-chain program responsible for processing the instruction logic.
outer_executing_accountSTRINGSolana program address of the parent instruction when this instruction is a cross-program invocation. Base58-encoded string, null for top-level instructions.
account_argumentsARRAY<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_dataSTRINGEncoded payload containing the parameters and data required for the Solana program to execute the instruction. Base58-encoded string representing the serialized instruction arguments.
stack_heightINT64Depth 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_keySTRINGUnique 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.
block_slotstack_heightsurrogate_keytransaction_idblock_timestampinstruction_dataaccount_argumentsexecuting_accountinstruction_indextransaction_indextransaction_signerouter_executing_accountouter_instruction_index
3112806321311280632-3WAkEqBaPzwScCr4Brxfd7VWmFm2Y1HGWnX9XvX94WEMTWnNZHqGCpMmKkZEdcCwzBDw3Z4JQuguG2biF5bUcGCC-03WAkEqBaPzwScCr4Brxfd7VWmFm2Y1HGWnX9XvX94WEMTWnNZHqGCpMmKkZEdcCwzBDw3Z4JQuguG2biF5bUcGCC2025-01-01T22:38:16.000Z6vx8P[“CkZDFQrC4REXuVHsb6puAQdAjjTRka565yDN6UEm4KGz”,“SysvarRecentB1ockHashes11111111111111111111”,“1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed”]1111111111111111111111111111111106831112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed
3112399201311239920-nte4SYjppp3jnkP1bpY26PKrxbHtYX1m2WedtqmB4VfXWLV164EMuT6ZiRTzCg7V2G5soNbB5LTw4b15ZSVEW7o-0nte4SYjppp3jnkP1bpY26PKrxbHtYX1m2WedtqmB4VfXWLV164EMuT6ZiRTzCg7V2G5soNbB5LTw4b15ZSVEW7o2025-01-01T18:00:36.000Z6vx8P[“6v5YwqAqazfAPMXG1oV5o8TUKd8AtBW5tqqkGxKHRCaD”,“SysvarRecentB1ockHashes11111111111111111111”,“1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed”]1111111111111111111111111111111102111112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed
3111925821311192582-3GRUMKLiqpv52JfQ5yBgZRYConGmQrcBamXdQMSamkDjcw9aoYvj9CV3nDZVUWYLy5nKCFVscGkdHwrUuYt4nHkn-03GRUMKLiqpv52JfQ5yBgZRYConGmQrcBamXdQMSamkDjcw9aoYvj9CV3nDZVUWYLy5nKCFVscGkdHwrUuYt4nHkn2025-01-01T12:36:58.000Z6vx8P[“7oc69bZ7RfBPaq3ScxcSrJRkF3rZQcRVrMAXY38z4jTd”,“SysvarRecentB1ockHashes11111111111111111111”,“1112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed”]11111111111111111111111111111111019941112WAZEnyLBeSVd6WtLDc2YXc96J9bEhmmPMfJn6Ed
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_idSTRINGUnique 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_keysARRAY<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_accountsARRAY<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.
feeINT64Transaction 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).
signaturesARRAY<STRING>Array of transaction signatures identifying this failed transaction. Base58-encoded strings where the first signature is from the primary fee payer.
return_dataSTRUCT<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_consumedINT64Computational 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_countINT64Number of signatures required to authorize this transaction. Typically 1 for single-signer transactions, higher for multi-signature operations.
readonly_signed_accounts_countINT64Number 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_countINT64Number 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_messagesARRAY<STRING>Array of program execution logs generated during transaction processing. Contains error messages, program invocations, and state change information useful for debugging failed transactions.
signerSTRINGAccount address that signed and authorized the transaction. Base58-encoded string for Solana, alphanumeric string for Stellar.
versionSTRINGSequential 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_truncatedBOOLIndicates whether the transaction’s log messages exceeded the maximum length and were cut off. This field is false when all logs are fully captured.
successBOOLBoolean indicator of whether the operation completed successfully without errors.
errorSTRINGError message returned when transaction execution fails. Empty when execution succeeds.
feeerrorsignersuccessversionblock_slotsignaturesreturn_dataaccount_keyslog_messageslogs_truncatedtransaction_idblock_timestamptransaction_indexexecuting_accountscompute_units_consumedrequired_signatures_countreadonly_signed_accounts_countreadonly_unsigned_accounts_count
5000feZGfvXvqNxZrHPAF13ouppteejahWHKMb2pgC56bz9gjP9pTfigQNnGhaRHVfalse0311104368[“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”]false2A3z6xM6CK43g4rXQdfCPVPtBL3a1HZW4RoE72DbaSsAcdFuxwX62qEzzEovemQoXg9GUgaxVMardvX6nvR22uk22025-01-01T02:39:01.000Z2057[“11111111111111111111111111111111”]150101
5000feZGfvXvqNxZrHPAF2JhCguTdGR7QGZdfmZjGSWEDvUa8fDaaaDZWoHeJ5rtAfalse0311088986[“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”]false5hfbXyZf83njmBSB3pNkXesQf1bsWJMmqVHjVoMW86rKgD3kuT9xyQ5MUR1sZSYPozY12sZnsaEYYSZ5b2bnYGk62025-01-01T00:53:41.000Z1562[“11111111111111111111111111111111”]150101
10010000feZGfwGkMaXDT54NK2KnMoM2xwYjGzszX1ynRN3DEgQcATDBrKczDstzneRGQfalse0311249645[“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”]false2ZjksGRsHaZt46afhBefovcDzKug1TEoy4V999PPuJZbAbThSjN6B8BuKyNnHqqWF6JHC1HPvohvpDqh3fiUhGNY2025-01-01T19:07:10.000Z25[“11111111111111111111111111111111”,“ComputeBudget111111111111111111111111111111”,“minTcHYRLVPubRK8nt6sqe2ZpWrGDLQoNLipDJCGocY”]300201
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.
ColumnTypeDescription
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
transaction_idSTRINGUnique 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_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_signerSTRINGSolana account address that signed and authorized the transaction. Base58-encoded string representing the fee payer and primary authority for the transaction.
instruction_indexINT64Position of the instruction within its containing transaction. Zero-indexed integer indicating the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction when this instruction is a cross-program invocation. Zero-indexed integer, null for top-level instructions.
executing_accountSTRINGSolana program address that executed the instruction. Base58-encoded string representing the on-chain program responsible for processing the instruction logic.
outer_executing_accountSTRINGSolana program address of the parent instruction when this instruction is a cross-program invocation. Base58-encoded string, null for top-level instructions.
account_argumentsARRAY<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_dataSTRINGEncoded payload containing the parameters and data required for the Solana program to execute the instruction. Base58-encoded string representing the serialized instruction arguments.
stack_heightINT64Depth 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_keySTRINGUnique 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.
block_slotstack_heightsurrogate_keytransaction_idblock_timestampinstruction_dataaccount_argumentsexecuting_accountinstruction_indextransaction_indextransaction_signerouter_executing_accountouter_instruction_index
3112075492311207549-2Bn7k77wDXDZKkMZbL5rhVEucsR3hy5YnzEghxJVnfyHcj1xJSKBDxh9oz6hjysdVdP3vvtwEXAo16Myaq3do3M3-2-02Bn7k77wDXDZKkMZbL5rhVEucsR3hy5YnzEghxJVnfyHcj1xJSKBDxh9oz6hjysdVdP3vvtwEXAo16Myaq3do3M32025-01-01T14:18:59.000Z1111122NPtq7nzVbhd823R44A9gVhRduGynm5mUeJCZQcVvwatKpUtfYAph8ri8hxkEKBb[“Gb92jjsvrFCMAFiAkRPjmtio5DXjWo3rFMeLNAs3dh7Z”,“BpMAqizRiKyC1TtPpHe4rSJ153ZTmVJSJ6Ra7BkBAugz”]111111111111111111111111111111110132Gb92jjsvrFCMAFiAkRPjmtio5DXjWo3rFMeLNAs3dh7ZvAuLTsyrvSfZRuRB3XgvkPwNGgYSs9YRYymVebLKoxR2
3111524452311152445-2nst36UX2RnrVw6fdDQKawDejbeVihwfEos9W6CP7SjLWgmayttMZxeDLC4LnUNR234MiAms8tPzsmqTDbqxWLq8-2-02nst36UX2RnrVw6fdDQKawDejbeVihwfEos9W6CP7SjLWgmayttMZxeDLC4LnUNR234MiAms8tPzsmqTDbqxWLq82025-01-01T08:05:37.000Z1111122NPtq7nzVbhd823R44A9gVhRduGynm5mUeJCZQcVvwatKpUtfYAph8ri8hxkEKBb[“D6J74YsTi3EjkMkpjfL6FD1Zo5g23kCrnXt6QEbifroK”,“9paK5smGrisdz2D2yMM3FB4pxeY34F1kLuJynkbMwatY”]11111111111111111111111111111111048D6J74YsTi3EjkMkpjfL6FD1Zo5g23kCrnXt6QEbifroKvAuLTsyrvSfZRuRB3XgvkPwNGgYSs9YRYymVebLKoxR2
3112464362311246436-4ubWLsr3xAU47t2hyjMv8YDr6LoHwasrW1w5zrtLKjtxENwuCTfdKxDEpVCitAYYX5CxC3x75tb8CT1S9MpHCh2M-8-04ubWLsr3xAU47t2hyjMv8YDr6LoHwasrW1w5zrtLKjtxENwuCTfdKxDEpVCitAYYX5CxC3x75tb8CT1S9MpHCh2M2025-01-01T18:45:14.000Z1111122NPtq7nzVbhd823R44A9qXHZHt5zH76XmnZH7o1gi2XbfWv7WhS8KMTR4HFD8HAt[“5rxHwh7dVGPY2WySyTit9GeLkpty1eoBMtdPukNTmBrA”,“8DAVjYdseocd12VqgQK6xoEtD6dhVwo74oVTSh9YSQD2”]111111111111111111111111111111110925rxHwh7dVGPY2WySyTit9GeLkpty1eoBMtdPukNTmBrAAwm2zSgzMGTRraAVjRvshqLehy7mJ2Qr3maURDsoDmwi8
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.
ColumnTypeDescription
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
block_hashSTRINGUnique identifier for the block. 66-character hex string including 0x prefix.
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
pubkeySTRINGPublic key of the account receiving the reward, typically a validator or fee recipient. Base58-encoded 32-byte identifier representing the Solana account address.
lamportsNUMERICAmount of lamports earned as reward by the recipient address. Denominated in lamports, where 1 SOL equals 1 billion lamports.
commissionNUMERICCommission 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_balanceNUMERICAccount balance in lamports after the reward was applied. Represents the total balance of the recipient account following the credit of the reward amount.
reward_typeSTRINGType 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.
pubkeylamportsblock_hashblock_slotcommissionreward_typepost_balanceblock_timestamp
6TkKqq15wXjqEjNg9zqTKADwuVATR9dW3rkNnsYme1ea3440000BuWY3c41Si3xXD2JJHoSKMMeoV1bDnhA4RL939JUpDcM67192663fee5530906372002021-03-01T00:34:16.000Z
67joanjyAoVmb9nZLyX8p3Gx9tAxzXaUgHDe3kaUH4wf34400008DvNCm9UHEwFms7P4BQbCX63nb3pPVwYc1iB6yF9TDjm67200433fee4277838845032021-03-01T02:07:30.000Z
3xGDUST5CKZsiW4L5PPp9E63X3PdqRvCJfDM3q9EYcB434400002o7pJmwS9RSVfFqzyrybn8MkQc6c9FRWvoPtMXyWMj7k67205977fee4472104865992021-03-01T03:14:01.000Z
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, microsecond precision.
block_slotINT64Sequential slot number in which the block was produced on the Solana blockchain. Integer value representing the blockchain’s internal ordering mechanism.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
transaction_idSTRINGUnique 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_keysARRAY<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_accountsARRAY<STRING>Array of program IDs invoked during transaction execution, derived from log messages. Empty for transactions that fail or execute no on-chain programs.
feeINT64Transaction 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).
signaturesARRAY<STRING>List of base58-encoded transaction signatures authorizing this transaction. Typically contains one signature but can include multiple for multi-signature transactions.
return_dataSTRUCT<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_consumedINT64Computational 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_countINT64Number of signatures required for this transaction to be valid. Typically 1 for simple transfers, higher for multi-signature accounts.
readonly_signed_accounts_countINT64Number 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_countINT64Number 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_messagesARRAY<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.
signerSTRINGAccount address that signed and authorized the transaction. Base58-encoded string for Solana, alphanumeric string for Stellar.
versionSTRINGSequential 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_truncatedBOOLIndicates 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.
successBOOLBoolean indicator of whether the operation completed successfully without errors.
errorSTRINGError message returned when transaction execution fails. Empty when execution succeeds.
feeerrorsignersuccessversionblock_slotsignaturesreturn_dataaccount_keyslog_messageslogs_truncatedtransaction_idblock_timestamptransaction_indexexecuting_accountscompute_units_consumedrequired_signatures_countreadonly_signed_accounts_countreadonly_unsigned_accounts_count
5000HbwvjjeAvonHkQknfAUZeLb53vVYHAUwFgpoRFS8shVctruelegacy339212825[“1JHqBtu3W3oampyHq9CjNTFuAwL8Rtugxj7tbzs5F549t3cA7oxotb3X7pVGjVcdzfc8vFAjhD9rgAivdqsJsCx”]{“data”:null,“program_id”:null}[“HbwvjjeAvonHkQknfAUZeLb53vVYHAUwFgpoRFS8shVc”][]false1JHqBtu3W3oampyHq9CjNTFuAwL8Rtugxj7tbzs5F549t3cA7oxotb3X7pVGjVcdzfc8vFAjhD9rgAivdqsJsCx2025-05-11T02:21:13.000Z338[]0100
5000HcJsuC9d672vuBsSDLKWLUpSm1iGhsgWQuHNGE82JZRgtrue0339359875[“1KPRe1FVqsQZj1v4J1fHAhWrJx9zC4G8MjfdGSqSthktgVxVVjbGy3gqawrecwE6TkSMdKnXh1Mmt7ZTUyam86s”]{“data”:null,“program_id”:null}[“HcJsuC9d672vuBsSDLKWLUpSm1iGhsgWQuHNGE82JZRg”,“Cw8CFyM9FkoMi7K7Crf6HNQqf4uEMzpKw6QNghXLvLkY”,“11111111111111111111111111111111”][“Program 11111111111111111111111111111111 invoke [1]”,“Program 11111111111111111111111111111111 success”]false1KPRe1FVqsQZj1v4J1fHAhWrJx9zC4G8MjfdGSqSthktgVxVVjbGy3gqawrecwE6TkSMdKnXh1Mmt7ZTUyam86s2025-05-11T18:28:34.000Z265[“11111111111111111111111111111111”]150101
50009cvoyBnNU2xXunXXtY2x7NyGSffQAMeiEHwPt9CbzZnDtrue0339278304[“18yNKKLmbDpFtGoj6kWcaCPfCuJFMPKJhpCuKBoRZGQX55j96TZnzmFyCV7Md93YUKuCFP93yaggf88kBZVep9P”]{“data”:null,“program_id”:null}[“9cvoyBnNU2xXunXXtY2x7NyGSffQAMeiEHwPt9CbzZnD”,“5Pc8FXNBrzdRkmmvDWt7pWHQ5cKC1uRqQN7MKMGXA7D8”,“11111111111111111111111111111111”][“Program 11111111111111111111111111111111 invoke [1]”,“Program 11111111111111111111111111111111 success”]false18yNKKLmbDpFtGoj6kWcaCPfCuJFMPKJhpCuKBoRZGQX55j96TZnzmFyCV7Md93YUKuCFP93yaggf88kBZVep9P2025-05-11T09:31:36.000Z59[“11111111111111111111111111111111”]150101
Query with partition filter
SELECT *
FROM `tt-blockchain.solana.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100