TRC20 Balances Latest

The current TRC20 balance of all addresses.

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

address

Address of the account.

TYE218dMfzo2TH348AbKyHD2G8PjGo7ESS

token_address

Addres of the token.

TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8

token_name

Name of the token.

USD Coin

token_symbol

Symbol of the token.

USDC

raw_balance

Balance of ERC20 token unnormalized.

84,005

raw_balance_str

Balance of ERC20 token unnormalized in string.

84005

balance_str

Balance of ERC20 token in string.

0.084005

balance

Balance of ERC20 token.

0.084005

usd_balance_current

USD balance of ERC20 token at the current timestamp.

0.0839797985

usd_balance_at_block_timestamp

USD balance of ERC20 token at the timestamp of the last activity that resulted in balance change.

0.083920995

usd_exchange_rate_current

USD exchange rate of ERC20 token at the current timestamp.

0.9997

usd_exchange_rate_at_block_timestamp

USD exchange rate of ERC20 token at the timestamp of the last activity that resulted in balance update.

0.999

transaction_hash

The transaction hash that resulted in the balance update.

0x8f1b88cc42fd0923bcb6460c631ac319eb18793e45feb3fa3bd2087dafe273f1

last_activity_block_timestamp

The last timestamp of the block that that resulted in the balance update.

2021-07-04 11:29:30

last_activity_block_number

The last block number that resulted in the balance update.

31,641,759

last_activity_block_hash

The last hash of the block that resulted in the balance update.

0x0000000001e2d09ff8d7322804797a046afb97433cfedc15f46b057df5c47dee

_updated_at__usd_exchange_rate_current

Timestamp of the current USD exchange.

2023-03-10 22:00:00

unique_id

Unique ID of the balance

block-31641759_address-TYE218dMfzo2TH348AbKyHD2G8PjGo7ESS_token_address-TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8_erc20

_updated_at

Timestamp of the balance update.

2023-03-10 10:18:08

Last updated