Balance Changes

Table Details

Property	Value
Table Name	`solana.assets.balance_changes`
Table Status	Production-Ready
Unique Key	`block_slot`, `txn_id`, `address`, `token_account`

solana.assets.balance_changes is a view that consolidates balances changes per transaction, and tries to attribute it to the counterparties contributing to each balance change, by joining with the solana.assets.transfers. Each row represents a change in balance of a party in the transaction.

This view has been deprecated due to suboptimal performance. Please use solana.udfs.sql_table_solana_get_balance_change_attribution from convenience functions, which produces an equivalent table.

Due to invisible sol transfers in solana, not all balance changes will be fully associated with transfers from the solana.assets.transfers table. This results in balance changes not/partially attributed to counterparties. We will attempt to surface more invisible sol transfers and improve the attribution of counterparties, this is work in progress.

Table Columns

Column Name	Data Type	Description
type	VARCHAR(16777216)	The type of balance change. Current available types: `sol_transfer` - a sol transfer `spl_transfer` - a spl transfer between 2 existing token accounts `new_spl_account` - creation of a new a spl token account with non-zero balance `spl_changed_owner` - transfer of ownership of a token account, and thus its balance
address	VARCHAR(16777216)	Address of the balance change
token_account	VARCHAR(16777216)	Token account of the balance change, only available for an spl token account
mint	VARCHAR(16777216)	Mint of the balance change
symbol	VARCHAR(16777216)	Symbol of the token
decimals	VARCHAR(16777216)	Decimals of the token
pre_tx_balance	VARCHAR(16777216)	Balance at the start of the transaction
post_tx_balance	VARCHAR(16777216)	Balance at the end of the transaction
tx_balance_change	VARCHAR(16777216)	Change in balance for the transaction, calculated by `post_tx_balance - pre_tx_balance`
transfers_raw_amount_sum	VARCHAR(16777216)	The sum of the transfers in/out of the address/account, extracted from the `solana.assets.transfers` table
transfers_counterparties	VARIANT	The list of counterparties of all transfers of the address/account
agg_transfers_details	VARIANT	Details about the transfers to/from the address/account
is_attribution_complete	BOOLEAN	Reflects if the total balance change can be attributed to known transfers extracted from `solana.assets.transfers`
block_slot	NUMBER(38,0)	Block slot of the transfer
block_height	NUMBER(38,0)	Block height of the transfer
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the transfer
block_hash	VARCHAR(44)	Block hash of the transfer
txn_id	VARCHAR(88)	Transaction ID of the transfer
txn_index	NUMBER(38,0)	Transaction Index of the transfer

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

​Table Details

​Table Columns

Table Details

Table Columns