TRC20 Balances

Historical TRC20 balances of all addresses at every block height.

TRC20 balances table contains the TRC20 balances of all addresses, at every block height. Use this table to easily plot the change in the balance of TRC20 tokens for an address or a group of addresses over time.

Sample Query

Getting the TRC20 Balances of USDC Token from an address over time.

select * from tron.assets.trc20_balances
where address = 'TXFBqBbqJommqZf7BV8NNYzePh97UmJodJ' -- Bitfinex
and token_address = 'TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t' -- USDT Token Address
order by block_number desc 

Table Columns

Column Name	Description	Example
address	Address of the account.	TYE218dMfzo2TH348AbKyHD2G8PjGo7ESS
token_address	Token address of the TRC20 token.	TEkxiTehnzSmSe2XqrBj4w32RUN966rdz8
token_name	Name of the TRC20 token.	USD Coin
token_symbol	Token symbol of this token.	USDC
balance	Balance of this TRC20 token, normalized by the decimal points defined in the TRC20 token contract. For example, USDC has 6 decimals, so this value is the raw_balance divided by 10^6.	1,101.95
raw_balance	Balance of tokens (unnormalized)	1101950000
usd_value	The amount of tokens, in $USD.	1,101.95
usd_exchange_rate	The exchange rate used to calculate the usd_value.	1
block_timestamp	The timestamp of the block that that resulted in the balance.	2021-07-04 11:29:30
block_number	The number of the block that resulted in the balance.	31,641,759
block_hash	The hash of the block that resulted in the balance.	0x0000000001e2d09ff8d7322804797a046afb97433cfedc15f46b057df5c47dee