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 |
