For TRC10 transfers, transaction and block hashes are not appended with 0x as they are from the Tron JSON RPC.
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 viaTransferAssetContract -
value_transfer- movement of TRC10 tokens viaTransferAssetContract -
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 callsHowever, 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 | Description | Example |
|---|---|---|
| from_address | The address of the sending party of this transaction. (Tron Base58) | TRoFcmjYqjF67Pgt9FxgtAFYTW6cPeLi3Y |
| to_address | The address of the receiving party of this transaction (could be a contract address). (Tron Base58) | TQo92evkR3Ndts2bofKRTfegTL7Ek3Netg |
| token_id | Token ID of the TRC10 transferred | 1004178 |
| token_name | Name of the asset transferred. | LETCOINS |
| token_symbol | Token symbol of the asset transferred. | LETS |
| raw_amount | Amount of tokens moved (unnormalized). | 1250000 |
| raw_amount_str | Amount of tokens moved (unnormalized) in string | 1250000 |
| amount | Amount of token moved, normalized. | 12500 |
| amount_str | Amount of token moved, normalized in string. | 12500 |
| usd_amount | USD value of TRC10 transferred. Note that we do not support TRC10 token prices. | |
| usd_exchange_rate | USD value of the TRC10 token. Note that we do not support TRC10 token prices. | |
| transaction_from_address | The address of the sending party of this transaction. | TRoFcmjYqjF67Pgt9FxgtAFYTW6cPeLi3Y |
| transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | TQo92evkR3Ndts2bofKRTfegTL7Ek3Netg |
| transaction_hash | Unique identifier of the transaction that this log belongs to. | b1e4a6adecc5ea771ba1e939de40561d2a300e1558dee9d4ed4b1d68f231b6f9 |
| transfer_type | Transfer type includes the type of transfer. | value_transfer |
| block_timestamp | The time when the block that contains this transaction was included on the blockchain. | 2021-06-29 08:18:24 |
| block_number | The length of the chain, in blocks. | 31494335 |
| block_hash | Unique identifier of the block that includes this transaction. | 0000000001e090bf19906be5789292a7a9981dff49826535ca4605b87deac7fe |
| unique_id | Unique id generated to each transfer. Includes transaction hash and log index. | txn-b1e4a6adecc5ea771ba1e939de40561d2a300e1558dee9d4ed4b1d68f231b6f9 |
| _created_at | Timestamp of the entry creation. | |
| _updated_at | Timestamp of the entry updated. | 2024-03-01 09:05:55 |