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

The tron.assets.trx_token_transfers table contains the details of TRX movement on the Tron blockchain.

Transfers type included:

  • fees - TRX burnt from transactions / Tron-specific contract transactions such as creating a TRC10 tokens

  • value_transfer - movement of TRX tokens in most TRX transfers, excluding TRC10 tokens

  • internal_txn - TRX transferred via internal transactions (aka Traces)

  • contract_transfer - movement of TRX transferred to contracts

  • staking-related - movement of TRX to and from Tron staking

    • claim_rewards - rewards claimed from staking
  • exchange-related - movement of TRX to and from Tron TRC10-TRX pools

  • participate_asset_issue - TRX transfers for participation in asset issuance

Table Columns

ColumnDescriptionExample
from_addressThe address of the sending party of this transaction. (Tron Base58)TMyrXwULKhhwhmrU4fQ5NezfeMafCMEvdm
to_addressThe address of the receiving party of this transaction (could be a contract address). (Tron Base58)TJMC6J1r9Kgb1x53zKuArFhn7U1auvpzSq
token_addressThe default addres for TRX token is T9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwbT9yD14Nj9j7xAB4dbGeiX9h8unkKHxuWwb
token_nameName of the asset transferred.Tron
token_symbolToken symbol of the asset transferred.TRX
raw_amountAmount of tokens moved (unnormalized).48,050.00
raw_amount_strAmount of tokens moved (unnormalized) in string48,050.00
amountAmount of token moved, normalized.0.04805
amount_strAmount of token moved, normalized in string.0.04805
usd_amountThe amount of tokens moved, in USD.</td><td>0.0015438465</td></tr><tr><td>usdexchangerate</td><td>Thisisthepriceofasingletoken,inUSD.</td><td>0.0015438465</td></tr><tr><td>usd_exchange_rate</td><td>This is the price of a single token, in USD. Refer to Hourly Token Prices for more information.0.03
transaction_from_addressThe address of the sending party of this transaction.TMyrXwULKhhwhmrU4fQ5NezfeMafCMEvdm
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).TJMC6J1r9Kgb1x53zKuArFhn7U1auvpzSq
transaction_hashUnique identifier of the transaction that this log belongs to.95a56fc50a675e8a190ca1982e8a54c1eba3b82740b93b1bab821f80a2e4486d
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-01-07 06:24:30
block_numberThe length of the chain, in blocks.26,540,810
block_hashUnique identifier of the block that includes this transaction.000000000194fb0aca8333b08872a9a445ed70474ecaec780f22d98ec0f23444
unique_idUnique id generated to each transfer. Includes transaction hash and log index.value_transfer-95a56fc50a675e8a190ca1982e8a54c1eba3b82740b93b1bab821f80a2e4486d