Skip to content


The traces table provides indexed views of all traces submitted for a specified chain.


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


The following indexes are available for this table:

(__confirmed) WHERE __confirmed = false
(block_number, transaction_position)
(from_address, block_number, transaction_position)
(to_address, 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.