Assets
Latest Balances
Records the cumulative (total) balance of each coin type for an address at the time of its latest balance change, including USD value if available. Useful for analyzing recent balance updates.
Sample query:
Table Columns
Column Name | Description | Example |
---|---|---|
address | Address of the account | 0xa8b690c5bcafdbbd43fb7f973c9d57efeba5b968f12b021380de187ef193d6ef |
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) | 598482559254 |
raw_balance_str | Balance of tokens (unnormalized) in string | 598482559254 |
balance_str | Balance of the token as string | 598.482559254 |
balance | Balance of this token, normalized | 598.482559254 |
usd_balance_current | The amount of tokens, in $USD at the current time | 1974.992445538 |
usd_balance_at_checkpoint_timestamp | The amount of tokens, in $USD at the price evaluated at the checkpoint timestamp | 1974.992445538 |
usd_exchange_rate_current | The exchange rate used to calculate the usd_value at current time | 3.3 |
usd_exchange_rate_at_checkpoint_timestamp | The exchange rate used to calculate the usd_value at checkpoint timestamp | 3.3 |
last_activity_checkpoint_timestamp | The latest timestamp of the checkpoint that resulted in change in balance | 2025-06-03 18:35:34.373 |
last_activity_checkpoint_sequence | The sequence number of the latest checkpoint that resulted in change in balance | 152695456 |
last_activity_checkpoint_digest | The digest of the latest checkpoint that resulted in change in balance | 3sSXy6GKwF8CgFRwSPQp4e7Dsv36rLGsi3ouqi8KE1VJ |
last_activity_transaction_block_digest | The digest of the latest transaction block that resulted in change in balance | BM1sFL1RFUjNXHVq9d3UiMUXXbEMCJkCtqdeeU7KvUj7 |
last_activity_transaction_block_index | The index of the latest transaction block that resulted in change in balance | 9 |
_updated_at__usd_exchange_rate_current | Time the usd exchange rate was calculated | 2025-06-03 18:00:00.000 |
unique_id | Unique ID of the balances entry | checkpoint-152695456_transaction-BM1sFL1RFUjNXHVq9d3UiMUXXbEMCJkCtqdeeU7KvUj7_address-0xa8b690c5bcafdbbd43fb7f973c9d57efeba5b968f12b021380de187ef193d6ef_coin_type-0x2::sui::SUI |
_updated_at__unhydrated | Time the raw balance was calculated | 2025-06-03 19:15:01.477 |
_created_at | Time the row was created | 2025-06-03 19:15:01.477 |
_updated_at | Time the row was updated | 2025-06-03 19:15:01.477 |