Fungible Balances Latest

​

Table Columns

​

Model Caveats

• Balance Changes Without Transfers: Certain operations may modify token balances without generating a transfer event. This can occur through direct contract interactions that adjust balances internally, bypassing the standard transfer log mechanism. Some older TRC20 contracts or legacy blocks may not emit standard transfer events. As a result, balances from these contracts might not be accurately captured.
• Rebasing Tokens: Rebasing tokens automatically adjust their total supply, which can impact individual balances without explicit transfer events. This can lead to discrepancies in balance calculations that rely solely on transfer events.
• Null Balances: Zero address T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb will show negative balances for most TRC20 tokens due to the way the event logs represent zero address as the sender of assets during token mints, despite the address not holding the assets previously.

​

Sample Query

SELECT * FROM tron.assets.fungible_balances_latest
WHERE address = 'TXFBqBbqJommqZf7BV8NNYzePh97UmJodJ' -- Bitfinex Hot Wallet