Transactions

A transaction is one or more instructions signed by a client using one or more key-pairs and executed atomically with only two possible outcomes: success or failure.

tl-solana-merged-data.transactions

The table contains the transaction data for Solana blockchain. Data related to account, program, program activity, token balance, etc. is available here.

Column Name	Column Type	Description
block_slot	bigint	This block’s slot index in the ledger
block_time	timestamp	The (estimated) time this block was produced
block_date	date	Event date
index	bigint	Index into the block’s transactions
fee	bigint	Fee this transaction was charged, as paid by first account
block_hash	string	The hash of this block, base-58 encoded
error	STRUCT	Only if success is true
required_signatures	bigint	The total number of signatures required to make the transaction valid
readonly_signed_accounts	bigint	The number of read-only signed accounts
readonly_unsigned_account	bigint	The number of read-only unsigned accounts
id	string	The first signature in the transaction
success	boolean	The transaction was valid and thus committed.
recent_block_hash	string	The hash of a recent block in the ledger, used to prevent transaction duplication and to give transactions lifetimes
instructions	array<STRUCT instructions>	Instructions to execute (in order)
account_keys	array<string>	The account keys used in the transaction
log_messages	array<string>	The log messages emitted by the transaction
pre_balances	array<bigint>	Array of account balances before the transaction was processed. The i-th balance is the balance of the i-th account key in account_keys
post_balances	array<bigint>	Array of account balances after the transaction was processed. The i-th balance is the balance of the i-th account key in account_keys
pre_token_balances	array<STRUCT token_balance>	List of token balances from before the transaction was processed or omitted if token balance recording was not yet enabled during this transaction
post_token_balances	array<STRUCT token_balance>	List of token balances from after the transaction was processed or omitted if token balance recording was not yet enabled during this transaction
signatures	array<string>	A list of base-58 encoded signatures applied to the transaction. Always of length numRequiredSignatures
signer	string	The initial value from the account_keys array that initiates the transaction and pays the transaction fee

Struct Definitions

Some columns in the transactions table has the data type STRUCT. It allows for representing nested hierarchical data and has key-value pairs. Let's go into what each one of them contains.

token_balances (pre/post)

Field	Data type	Description
account	string	The account key of the account that the token balance is provided for
mint	string	Public key of the token’s mint. This is an account that stores metadata about the token: The supply, number of decimals, and various authorities with control over the mint
amount	double	Derived from the token balance's raw amount. (ui_token_amount.amount) by (ui_token_amount.decimals)

instructions

Field	Data type	Description
account_arguments	array<string>	Ordered list of accounts to pass to the program
data	string	Program input data in a base-58 string
executing_account	string	The account key of the program that executed this instruction
inner_instructions	array<STRUCT inner_instructions>	The instructions invoked by this instruction

inner_instructions

Field	Data type	Description
account_arguments	array<string>	Ordered list of accounts to pass to the program
data	string	Program input data in a base-58 string
executing_account	string	The account key of the program that executed this instruction

error

Field	Data type	Description
instruction_index	bigint	The instruction number that failed
message	string	The error message