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).

The tron.assets.trc10_token_transfers table contains the details of TRC10 movement on the Tron blockchain.

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

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 NameDescriptionExample
from_addressThe address of the sending party of this transaction. (Tron Base58)TRoFcmjYqjF67Pgt9FxgtAFYTW6cPeLi3Y
to_addressThe address of the receiving party of this transaction (could be a contract address). (Tron Base58)TQo92evkR3Ndts2bofKRTfegTL7Ek3Netg
token_idToken ID of the TRC10 transferred1004178
token_nameName of the asset transferred.LETCOINS
token_symbolToken symbol of the asset transferred.LETS
raw_amountAmount of tokens moved (unnormalized).1250000
raw_amount_strAmount of tokens moved (unnormalized) in string1250000
amountAmount of token moved, normalized.12500
amount_strAmount of token moved, normalized in string.12500
usd_amountUSD value of TRC10 transferred. Note that we do not support TRC10 token prices.
usd_exchange_rateUSD value of the TRC10 token. Note that we do not support TRC10 token prices.
transaction_from_addressThe address of the sending party of this transaction.TRoFcmjYqjF67Pgt9FxgtAFYTW6cPeLi3Y
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).TQo92evkR3Ndts2bofKRTfegTL7Ek3Netg
transaction_hashUnique identifier of the transaction that this log belongs to.b1e4a6adecc5ea771ba1e939de40561d2a300e1558dee9d4ed4b1d68f231b6f9
transfer_typeTransfer type includes the type of transfer.value_transfer
block_timestampThe time when the block that contains this transaction was included on the blockchain.2021-06-29 08:18:24
block_numberThe length of the chain, in blocks.31494335
block_hashUnique identifier of the block that includes this transaction.0000000001e090bf19906be5789292a7a9981dff49826535ca4605b87deac7fe
unique_idUnique id generated to each transfer. Includes transaction hash and log index.txn-b1e4a6adecc5ea771ba1e939de40561d2a300e1558dee9d4ed4b1d68f231b6f9
_created_atTimestamp of the entry creation.
_updated_atTimestamp of the entry updated.2024-03-01 09:05:55