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.Generating Daily Balances from Transaction_Block-level Balances
Generating Daily Balances from Transaction_Block-level Balances
| 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 |