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.
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)
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
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
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
instruction_index
bigint
The instruction number that failed
message
string
The error message
Last updated