Assets
Balances
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 Name | Description | Example |
---|---|---|
address | Address of the account | 0x1d632d46ff70491033fefc4e6398dceaa4943dcf62512b4d57378b5ab703bc5e |
coin_type | Type of the coin | 0x2::sui::SUI |
coin_name | Name of the coin | Sui |
coin_symbol | Symbol of the coin | SUI |
raw_balance | Balance of tokens (unnormalized) | 9996684712015 |
raw_balance_str | String representation of raw balance | 9996684712015 |
balance_str | String representation of normalized balance | 9996.684712015 |
balance | Normalized balance of the token | 9996.684712015 |
usd_balance | The amount of tokens in USD at the current time | 5127.591491986 |
usd_exchange_rate | The exchange rate used to calculate the USD value | 0.5129292 |
checkpoint_timestamp | The timestamp of the checkpoint | 2023-11-07 14:57:27.169 |
checkpoint_sequence | The sequence number of the checkpoint | 17645270 |
checkpoint_digest | The digest of the checkpoint | CHRApjya4BKfCZ5fz92DvQ4QZ8CUpErALqsw8QXKh3ar |
transaction_block_digest | The digest of the transaction block | EVSE1tStdEFxe7dt1Fd7wbqK4y7RFrcw1gResBxqdgoG |
transaction_block_index | The index of the transaction block | 56 |
unique_id | Unique identifier for the balance entry | checkpoint-17645270_transaction-EVSE1tStdEFxe7dt1Fd7wbqK4y7RFrcw1gResBxqdgoG_address-0x1d632d46ff70491033fefc4e6398dceaa4943dcf62512b4d57378b5ab703bc5e_coin_type-0x2::sui::SUI |
_created_at | Timestamp when the record was created | 2025-06-03 16:45:31.319 |
_updated_at | Timestamp when the record was last updated | 2025-06-03 16:45:31.319 |