Sample query:

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

Table Columns

Column NameDescriptionExample
addressAddress of the account0xa8b690c5bcafdbbd43fb7f973c9d57efeba5b968f12b021380de187ef193d6ef
coin_typeType of the coin0x2::sui::SUI
coin_nameName of the coinSui
coin_symbolSymbol of the coinSUI
raw_balanceBalance of tokens (unnormalized)598482559254
raw_balance_strBalance of tokens (unnormalized) in string598482559254
balance_strBalance of the token as string598.482559254
balanceBalance of this token, normalized598.482559254
usd_balance_currentThe amount of tokens, in $USD at the current time1974.992445538
usd_balance_at_checkpoint_timestampThe amount of tokens, in $USD at the price evaluated at the checkpoint timestamp1974.992445538
usd_exchange_rate_currentThe exchange rate used to calculate the usd_value at current time3.3
usd_exchange_rate_at_checkpoint_timestampThe exchange rate used to calculate the usd_value at checkpoint timestamp3.3
last_activity_checkpoint_timestampThe latest timestamp of the checkpoint that resulted in change in balance2025-06-03 18:35:34.373
last_activity_checkpoint_sequenceThe sequence number of the latest checkpoint that resulted in change in balance152695456
last_activity_checkpoint_digestThe digest of the latest checkpoint that resulted in change in balance3sSXy6GKwF8CgFRwSPQp4e7Dsv36rLGsi3ouqi8KE1VJ
last_activity_transaction_block_digestThe digest of the latest transaction block that resulted in change in balanceBM1sFL1RFUjNXHVq9d3UiMUXXbEMCJkCtqdeeU7KvUj7
last_activity_transaction_block_indexThe index of the latest transaction block that resulted in change in balance9
_updated_at__usd_exchange_rate_currentTime the usd exchange rate was calculated2025-06-03 18:00:00.000
unique_idUnique ID of the balances entrycheckpoint-152695456_transaction-BM1sFL1RFUjNXHVq9d3UiMUXXbEMCJkCtqdeeU7KvUj7_address-0xa8b690c5bcafdbbd43fb7f973c9d57efeba5b968f12b021380de187ef193d6ef_coin_type-0x2::sui::SUI
_updated_at__unhydratedTime the raw balance was calculated2025-06-03 19:15:01.477
_created_atTime the row was created2025-06-03 19:15:01.477
_updated_atTime the row was updated2025-06-03 19:15:01.477