Skip to content


The ethereum.traces table provides indexed views of all traces.


Name Type Description
block_number integer The block number the parent transaction was included in.
contract_address text The address of the contract created by the transaction, if any.
from_address text The address of the transaction's sender.
input text The input data for the trace.
output text The output data for the trace.
timestamp timestamp The log's timestamp (in ISO-8601 format).
to_address text The address of the transaction's recipient, if any.
trace_address integer[] The address of the trace within the transaction's call stack.
trace_index integer The index of the trace in the transaction.
trace_type text The trace's call type (call, staticcall, delegatecall, callcode, create, or selfdestruct).
transaction_hash text The parent transaction's hash.
transaction_position integer The position of the parent transaction in the block.
value numeric The amount sent by the transaction (in Wei).
__confirmed boolean Flag indicating whether the log has been confirmed.


transaction_hash, trace_index
to_address, block_number, transaction_position
from_address, block_number, transaction_position
block_number, transaction_position
__confirmed WHERE __confirmed = false
left(input, 10), block_number, transaction_position
to_address, left(input, 10), block_number, transaction_position

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.