Balances Latest - Allium Documentation Hub

Table Details

Property	Value
Table Name	`sui.assets.balances_latest`
Table Status	Production-Ready
Unique Key	`token_address`, `address`

Sample query:

select * from sui.assets.balances_latest
where last_activity_checkpoint_timestamp >= current_timestamp - interval '5 hours';

Table Columns

Column Name	Data Type	Description
address	VARCHAR(16777216)	Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies.
coin_type	VARCHAR(16777216)	Fully-qualified Aptos coin type identifier (e.g. `0x1::aptos_coin::AptosCoin`). Alias for `aptos_coin_type` used in Aptos models that name the column `coin_type`.
coin_name	VARCHAR(16777216)	Full name of this coin. Short alias for token_name in Aptos/Cosmos-style tables.
coin_symbol	VARCHAR(16777216)	Ticker symbol of this coin. Short alias for token_symbol in Aptos/Cosmos-style tables.
raw_balance	FLOAT	Token balance in the token’s smallest unit (not decimal-adjusted). Use `balance` for the human-readable normalized value.
raw_balance_str	VARCHAR(16777216)	Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances.
balance_str	VARCHAR(16777216)	Normalized token balance stored as a string for full precision. Equivalent to `balance` but avoids floating-point truncation.
balance	FLOAT	Sum of end-of-day token balances for this address_type.
usd_balance_current	FLOAT	USD value of the token balance using the most recent available price, updated independently of balance changes.
usd_balance_at_checkpoint_timestamp	FLOAT	USD value of the balance at the checkpoint timestamp, computed using the price at that time.
usd_exchange_rate_current	FLOAT	Most recent USD price per unit of the token, used to compute `usd_balance_current`.
usd_exchange_rate_at_checkpoint_timestamp	FLOAT	USD exchange rate used to compute usd_balance_at_checkpoint_timestamp.
last_activity_checkpoint_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the checkpoint at which this address last had activity.
last_activity_checkpoint_sequence	NUMBER(38,0)	Checkpoint sequence number of the most recent checkpoint in which this address had activity.
last_activity_checkpoint_digest	VARCHAR(66)	Checkpoint digest of the most recent checkpoint in which this address had activity.
last_activity_transaction_block_digest	VARCHAR(66)	Transaction block digest of the most recent transaction for this address.
last_activity_transaction_block_index	NUMBER(38,0)	Index within the checkpoint of the most recent transaction for this address.
_updated_at__usd_exchange_rate_current	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the most recent update to the current USD exchange rate for this token. Updated independently when prices are refreshed, separate from balance data.
unique_id	VARCHAR(16777216)	Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes.
_updated_at__unhydrated	TIMESTAMP_NTZ(9)	Timestamp of the unhydrated update.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.