Links

Account activity

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.account_activity

This table contains information from the transactions table focused on account usage. Each row contains all information about an account's usage in a transaction.
Column Name
Column Type
Description
block_slot
bigint
The slot of the block this transaction was in.
block_hash
string
The hash of the block this transaction was in
block_time
timestamp
The timestamp that this account usage occurred
block_date
date
The date this account usage occurred
address
string
The address of the account, also referred to as public key
tx_index
int
The index of this transaction in the block
tx_id
string
The ID of the transaction in which this account usage occurred
tx_success
boolean
The transaction succeeded and was committed
signed
boolean
This account signed this transaction
writeable
boolean
This account was granted read-write access in this transaction
pre_balance
bigint
The balance of this account before the transaction was processed
pre_token___balance
decimal
The token balance before the transaction was processed
post_balance
bigint
The balance of this account after the transaction was processed
post_token___balance
decimal
The token balance after the transaction was processed
balance_change
bigint
The balance change that occurred as part of the transaction
token_balance___change
decimal
The balance change that occurred as part of the transaction