Links

Transactions

Our docs are now available at dune.com/docs. We'll keep this around as a reference, but we won't update them and eventually plan to deprecate.

Solana.transactions

This table contains the transaction data within Solana’s blockchain. Most of the relevant data related to account, protocol, and program activity is available in this table.
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 error
NULL if success is true.
required_signatures
bigint
The total number of signatures required to make the transaction valid.
readonly_signed___accounts
bigint
The last readonly_signed_accounts of the signed keys are read-only accounts.
readonly_unsigned___accounts
bigint
The last readonly_unsigned_accounts of the unsigned keys are read-only 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)
accountKeys
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_balance
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_balance
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

Within several of these columns is a data type of STRUCT which allows for representing nested hierarchical data and has key-value pairs. It's similar to a dictionary in python and can be used to group fields together to make them more accessible.
An example of how these can be used to extract data: # of Solana instructions by day for DEXes
token_balance
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
Decimal
Derived from the token balance's raw amount (ui_token_amount.amount) and the number of decimals (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
int
The instruction number that failed
message
string
The error message