TRC20 balances latest contains the current TRC20 balances of all addresses. It is otherwise identical to TRC20 Balances

​
Sample Query

Getting the latest ERC20 Balances of USDC Token from an address.

select * from tron.assets.trc20_balances_latest

where address = 'TXFBqBbqJommqZf7BV8NNYzePh97UmJodJ' -- Bitfinex

and token_address = 'TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t' -- USDT Token Address

​
Table Columns

Column NameDescriptionExample
addressAddress of the account.TYE218dMfzo2TH348AbKyHD2G8PjGo7ESS
token_addressAddres of the token.TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8
token_nameName of the token.USD Coin
token_symbolSymbol of the token.USDC
raw_balanceBalance of ERC20 token unnormalized.84,005
raw_balance_strBalance of ERC20 token unnormalized in string.84005
balance_strBalance of ERC20 token in string.0.084005
balanceBalance of ERC20 token.0.084005
usd_balance_currentUSD balance of ERC20 token at the current timestamp.0.0839797985
usd_balance_at_block_timestampUSD balance of ERC20 token at the timestamp of the last activity that resulted in balance change.0.083920995
usd_exchange_rate_currentUSD exchange rate of ERC20 token at the current timestamp.0.9997
usd_exchange_rate_at_block_timestampUSD exchange rate of ERC20 token at the timestamp of the last activity that resulted in balance update.0.999
transaction_hashThe transaction hash that resulted in the balance update.0x8f1b88cc42fd0923bcb6460c631ac319eb18793e45feb3fa3bd2087dafe273f1
last_activity_block_timestampThe last timestamp of the block that that resulted in the balance update.2021-07-04 11:29:30
last_activity_block_numberThe last block number that resulted in the balance update.31,641,759
last_activity_block_hashThe last hash of the block that resulted in the balance update.0x0000000001e2d09ff8d7322804797a046afb97433cfedc15f46b057df5c47dee
_updated_at__usd_exchange_rate_currentTimestamp of the current USD exchange.2023-03-10 22:00:00
unique_idUnique ID of the balanceblock-31641759_address-TYE218dMfzo2TH348AbKyHD2G8PjGo7ESS_token_address-TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8_erc20
_updated_atTimestamp of the balance update. 2023-03-10 10:18:08