Comment on page
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 |
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.
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 |
Last modified 6d ago