Skip to main content

​
Overview

  • Dataset ID: 0111
  • Table: blockdb_evm.b0111_internal_transactions_v1
  • Description: Internal transactions (call traces) from debug_traceTransaction
  • Primary Key: block_number, tx_index, trace_address
  • Foreign Key: (block_number, tx_index) → blockdb_evm.b0102_transactions_v1
  • API: POST /evm/raw/internal-transactions

​
Columns

ColumnTypeDescription
block_numberBIGINTBlock number of the parent transaction.
block_timeTIMESTAMPTZUTC timestamp of the block.
tx_indexINTEGERZero-based index of the parent transaction within the block.
trace_addressTEXTPosition in the call tree (e.g., “0”, “0.0”, “0.1”).
call_typeTEXTThe type of call: CALL, DELEGATECALL, STATICCALL, CREATE, CREATE2.
from_addressBYTEAThe address of the caller (20 bytes).
to_addressBYTEAThe address of the callee (20 bytes); null for failed CREATE/CREATE2.
value_weiNUMERICThe native value (in wei) transferred in this call.
gasNUMERICThe gas allocated for this call.
gas_usedNUMERICThe gas actually consumed by this call.
inputBYTEAThe input data (calldata) for this call.
outputBYTEAThe return data from the call (null if reverted).
errorTEXTThe error message if the call reverted.
tx_successBOOLEANThe success of the underlying transaction that caused this internal transaction.
_tracing_idBYTEAInternal tracing ID for observability.
_created_atTIMESTAMPTZRecord creation timestamp.
_updated_atTIMESTAMPTZRecord last update timestamp.

​
Use Cases

  • Contract creation and factory flow analysis
  • Internal call graphs and cross-contract dependencies
  • Value flow and gas consumption per call
  • Debugging failed transactions and revert reasons
  • MEV and arbitrage path reconstruction