Transactions

A block contains multiple transactions which in term contain multiple instructions.

Learn more in the official Solana documentation here.

Table Columns

Column Name	Description	Type	Example
block_slot	The slot of the block containing the tx.	number	159292973
block_ height	The height of the block containing the tx.	number	123292963
block_timestamp	The timestamp of the block containing the tx.	timestamp_ntz
block_hash	The hash of the block containing the tx.	varchar	5X6zcnNw6HSAn4X8GaMnzBp8JnWPcNHoAThFwFN1oeph
txn_id	Unique base58 identifier of the transaction	varchar	5Bc8KuxsmRCiLkBJhL7wYuTsawUiux2enj4xYr7FsPG7eUxVoCPKwqj9LcCAvTztA2drUJghUBTqo8C62qpRMM4H
txn_index	The index of this tx within the block. Used for strict ordering of transactions	number	5
signatures	array of signatures for this transaction. usually, the initiator of the tx and fee payor is assumed to be signatures[0]	variant	["4pGL1btb5pL8ir7nQZdt9uxpkaFTi8aUHRigo2QA1MMgXwb2SzLumGkoy7TLfo6Dv6zvaMj7yjBYxv2TU3wxzBRY"]
fee	Fee this transaction was charged	number	5000
err	JSON with info about a transaction error, if a tx fail. Null for a successful tx.	varchar	Null/ { "InstructionError": [ 0, "InvalidArgument" ] }
account_keys	Accounts needed for the tx	variant	[key1, key2, key3, key4, ...]
recent_block_hash	A recent block hash in the past, used as a nonce	varchar	47S8ZnTiR1my1HqEfdWe9f9XqThW6svjqUwXF5N2ZBBk
signer	first pubkey of account_keys	varchar	key1
log_messages	array of string log messages or null if log message recording was not enabled during this transaction	variant	"Program 11111111111111111111111111111111 invoke [1]", "Program 11111111111111111111111111111111 success", "Program TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA invoke [1]", "Program log: Instruction: InitializeMint",
pre_token_balances	List of token balances from before the transaction was processed	variant	[a,b,c]
post_token_balances	List of token balances from after the transaction was processed	variant	[a,b,c]
pre_balances	array of u64 account balances from before the transaction was processed	variant	[a,b,c]
post_balances	array of u64 account balances after the transaction was processed	variant	[a,b,c]
success	indicates if the transaction was successful	boolean	true/false