Documentation Index
Fetch the complete documentation index at: https://docs.dune.com/llms.txt
Use this file to discover all available pages before exploring further.
Table description
Thesolana.transactions table contains the transaction data within Solana’s blockchain. Most of the relevant data related to account, protocol, and program activity is available in this table.
This table excludes all voting transactions, which are available in the solana.vote_transactions table.
Table Schema
| Column | Type | Description |
|---|---|---|
block_slot | BIGINT | The slot number of the block containing this transaction |
block_height | BIGINT | The block height at which this transaction was processed |
block_time | TIMESTAMP | The timestamp of the block this transaction belongs to |
block_date | DATE | The date of the block this transaction belongs to |
index | INTEGER | The index position of this transaction within the block |
fee | BIGINT | The transaction fee paid in lamports |
compute_units_consumed | BIGINT | The number of compute units consumed by this transaction |
cost_units | BIGINT | The cost units charged for this transaction |
version | VARCHAR | The transaction version (‘legacy’ or ‘0’ for versioned transactions) |
required_signatures | INTEGER | The number of signatures required for this transaction |
readonly_signed_accounts | INTEGER | The number of read-only accounts that are also signers |
readonly_unsigned_accounts | INTEGER | The number of read-only accounts that are not signers |
block_hash | VARCHAR | The hash of the block containing this transaction |
id | VARCHAR | The unique transaction ID (same as signature) |
signature | VARCHAR | The first signature of the transaction, used as the transaction identifier |
success | BOOLEAN | Whether the transaction completed successfully |
error | VARCHAR | The error message if the transaction failed, null otherwise |
recent_block_hash | VARCHAR | The recent blockhash used for transaction validity and replay prevention |
instructions | ARRAY(ROW(data VARCHAR, executing_account VARCHAR, account_arguments ARRAY(VARCHAR), inner_instructions ARRAY(ROW(data VARCHAR, executing_account VARCHAR, account_arguments ARRAY(VARCHAR), stack_height BIGINT)))) | The list of instructions executed in this transaction, including nested inner instructions |
account_keys | ARRAY(VARCHAR) | All account addresses referenced in this transaction |
log_messages | ARRAY(VARCHAR) | Program log messages emitted during transaction execution |
pre_balances | ARRAY(BIGINT) | SOL balances (in lamports) of all accounts before the transaction, ordered by account_keys index |
post_balances | ARRAY(BIGINT) | SOL balances (in lamports) of all accounts after the transaction, ordered by account_keys index |
pre_token_balances | ARRAY(ROW(account VARCHAR, mint VARCHAR, owner VARCHAR, amount DECIMAL(38,18))) | SPL token balances of accounts before the transaction |
post_token_balances | ARRAY(ROW(account VARCHAR, mint VARCHAR, owner VARCHAR, amount DECIMAL(38,18))) | SPL token balances of accounts after the transaction |
signatures | ARRAY(VARCHAR) | All signatures attached to this transaction |
signer | VARCHAR | The primary signer (fee payer) of the transaction |
signers | ARRAY(VARCHAR) | All accounts that signed this transaction |
return_data_program_id | VARCHAR | The program ID that produced the return data, if any |
return_data | ARRAY(VARCHAR) | The data returned by the program after execution, if any |
address_table_lookups | ARRAY(ROW(accountKey VARCHAR, readonlyIndexes ARRAY(BIGINT), writableIndexes ARRAY(BIGINT))) | Address lookup table references used for versioned transactions |
loaded_addresses | ROW(readonly ARRAY(VARCHAR), writable ARRAY(VARCHAR)) | Addresses loaded from address lookup tables, split into readonly and writable sets |