Trc10 Token Transfers - Allium Documentation Hub

Table Details

Property	Value
Table Name	`tron.assets.trc10_token_transfers`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `unique_id`
Clustering Key(s)	`block_timestamp::date`
Search Optimization	`token_id`, `from_address`, `to_address`

For TRC10 transfers, transaction and block hashes are not appended with 0x as they are from the Tron JSON RPC.

TRC-10 is a native token on the TRON blockchain that is a standard of basic token production and does not require the TRON Virtual Machine (TVM). Transfers type included:

legacy_value_transfer - movement of TRC10 tokens via TransferAssetContract
value_transfer - movement of TRC10 tokens via TransferAssetContract
trace_transfer - movement of TRC10 tokens in internal transactions

Null token_id for legacy value transfers before 2019-01-05 0600.Currently, the asset_name field of TRC10 transactions returns the hex encoded value of the token_id from RPC calls

https://tronprotocol.github.io/documentation-en/mechanism-algorithm/system-contracts/#3-transferassetcontract

However, in historical version of the same call, the asset_name field returns the hex encoded value token name which caused ambiguity. This inconsistency was a known issue and was corrected subsequently.

Table Columns

Column Name	Data Type	Description
from_address	VARCHAR(34)	Address where the token is being transferred from.
to_address	VARCHAR(34)	Address where the token is being transferred to.
token_id	VARCHAR(134217728)	Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Each unique token_id within a collection represents a distinct asset.
token_name	VARCHAR(134217728)	Name of the asset transferred.
token_symbol	VARCHAR(134217728)	Token symbol of the asset transferred.
raw_amount_str	VARCHAR(134217728)	Amount of tokens transferred (unnormalized) in string to retain precision.
raw_amount	FLOAT	Amount of tokens transferred (unnormalized).
amount_str	VARCHAR(134217728)	Amount of token transferred, normalized in string to retain precision.
amount	FLOAT	Amount of token transferred, normalized.
usd_amount	FLOAT	The USD amount of the tokens at the time of the transfer.
usd_exchange_rate	FLOAT	The exchange rate used to calculate the `usd_amount`.
transaction_from_address	VARCHAR(34)	The address of the sending party of this transaction.
transaction_to_address	VARCHAR(34)	The address of the receiving party of this transaction (could be a contract address).
transaction_hash	VARCHAR(64)	Transaction hash that this transfer belongs to.
transfer_type	VARCHAR(134217728)	The type of transfers, depending on the blockchain. Typically include: `value_transfer`, `gas_burn`, `gas_payment_to_miner`.
block_timestamp	TIMESTAMP_NTZ(9)	The time when the block that contains this transaction was included on the blockchain.
block_number	NUMBER(38,0)	The block number that the corresponding transaction of this transfer belongs to.
block_hash	VARCHAR(64)	The block hash that the corresponding transaction of this transfer belongs to.
unique_id	VARCHAR(134217728)	Unique ID generated for each transfer.
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated.

EVM Assets Trc10 Token Transfers

​Table Details

​Table Columns

​Related Docs

Table Details

Table Columns

Related Docs