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

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

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)

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

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

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

Blocks

Account activity

Last modified 6mo ago