Links

Vote 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.vote_transactions

This table contains the full set of vote transactions that are submitted by validators to vote on a block. It can be joined with the non-vote transactions table above to get a full breakdown of all transactions. It has the same schema as the main transactions table.
An example query that demonstrates that is available here: Solana transactions past 30 days
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