TRC20 Balances Latest - Allium Documentation Hub

TRC20 balances latest contains the current TRC20 balances of all addresses from tron.assets.fungible_balances_latest

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

TRX Balances Latest Credit Debit

⌘I

​Sample Query

Sample Query