The balances table contains transaction_block-level changes in the balances of coins across all Sui wallets. Includes USD value where applicable.

This table is built by calculating the cumulative sum of amounts in the balance_change table. Note: Failed transaction_blocks are factored in the total balance. These balance changes are spent gas fees.

Generating Daily Balances

How to generate daily balances from transaction_block-level balances table.

Table Columns

Column NameDescriptionExample
addressAddress of the account0x1d632d46ff70491033fefc4e6398dceaa4943dcf62512b4d57378b5ab703bc5e
coin_typeType of the coin0x2::sui::SUI
coin_nameName of the coinSui
coin_symbolSymbol of the coinSUI
raw_balanceBalance of tokens (unnormalized)9996684712015
raw_balance_strString representation of raw balance9996684712015
balance_strString representation of normalized balance9996.684712015
balanceNormalized balance of the token9996.684712015
usd_balanceThe amount of tokens in USD at the current time5127.591491986
usd_exchange_rateThe exchange rate used to calculate the USD value0.5129292
checkpoint_timestampThe timestamp of the checkpoint2023-11-07 14:57:27.169
checkpoint_sequenceThe sequence number of the checkpoint17645270
checkpoint_digestThe digest of the checkpointCHRApjya4BKfCZ5fz92DvQ4QZ8CUpErALqsw8QXKh3ar
transaction_block_digestThe digest of the transaction blockEVSE1tStdEFxe7dt1Fd7wbqK4y7RFrcw1gResBxqdgoG
transaction_block_indexThe index of the transaction block56
unique_idUnique identifier for the balance entrycheckpoint-17645270_transaction-EVSE1tStdEFxe7dt1Fd7wbqK4y7RFrcw1gResBxqdgoG_address-0x1d632d46ff70491033fefc4e6398dceaa4943dcf62512b4d57378b5ab703bc5e_coin_type-0x2::sui::SUI
_created_atTimestamp when the record was created2025-06-03 16:45:31.319
_updated_atTimestamp when the record was last updated2025-06-03 16:45:31.319