tron.raw.traces_native contains trace calls, or internal transaction data from Tron’s native API call.

Internal Transactions represent all transactions that happen in a smart contract call.

Some important information is included in the transaction, such as the sender/receiver address in a token/trx transfer transaction, trx/token amount, transfer status, etc.

Internal Transactions on Tron vs Other EVMs

  • Traces on Tron network differ slightly from the EVM counterparts. There are no input and output fields. For more details, refer to Tron’s documentation on internal transactions atthis link.

  • The transaction hash in this table does not have a 0x prefix.

Query Sample

Finding TRC10 transfers.

select * from tron.raw.traces_native

where token_id is not null -- Filters for TRC10 transfers.

limit 100

Table Columns

Column NameDescriptionExample
transaction_hashTransaction hash of the main transaction.ea126d37c665b0c6364abd19acf4571f7ad7cb5e39ae9a4b876181ccd6815ae9
from_addressThe address send trx or trc10 tokenTEEXEWrkMFKapSMJ6mErg39ELFKDqEs6w3
to_addressThe address recieve trx or trc10 tokenTLUqyV9rGYXZ2E8kXe6J3P1rvYV1Au1Goe
call_valueThe amount of trx or trc10 token.10000000000
token_idThe trc10 tokenId. An empty value represents trx.
trace_typeTrace type (or note). This can only have 3 types of values, call, create, suicide, that represent the internaltransaction type.call
rejectedShow whether this internal transaction is rejected due to some error. If true, the internal transaction is rejected and it is not be executed.
extraExtra fields
trace_hashUnique identifier for a internal transaction. Should not exist same hash across all InternalTransactions or transactions.f36a3242bb7036196f321ab3cf30c259f8422b053b1f2e6d108d2624bbaf4729
trace_indexIndex of the trace flatten within the transaction1
subtracesInternally generated subtraces0
trace_idUnique trace id.f36a3242bb7036196f321ab3cf30c259f8422b053b1f2e6d108d2624bbaf4729_0
block_timestampBlock timestamp of the internal transaction.2018-11-07 08:38:18
block_numberBlock number of the internal transaction.3875914
internal_transaction_rawInternal Transaction JSON for legacy Tron Traces.
_created_atTimestamp of entry creation. (Null for v0 data)
_updated_atTimestamp of entry updated. (Null for v0 data)