tron.assets.trc20_balances
contains block-level balances of TRC20 tokens.
Each entry in the model corresponds to a specific event/transaction that causes a balance change in a particular asset at the block level.
This means a new data entry is only created when a transaction alters an asset’s balance at the block level.
tron.assets.trc20_balances
dataset is derived by calculating the net effect of all token transfers for each account, specifically by summing all incoming transfers (credits) and subtracting all outgoing transfers (debits). This approach is used as the Tron blockchain does not support point-in-time balance queries for TRC20 contracts.
As a result, the model is subject to the following caveats that will result in discrepancies in the balances:
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.
Column Name | Description | Example | Column Name |
---|---|---|---|
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 |