> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blockdb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Internal Transactions

> Full EVM call-trace data — internal ETH transfers, CREATE/DELEGATECALL, MEV path reconstruction. 10 chains, REST API.

<Warning>
  **Not publicly available:** This dataset is not included in the standard public API. Request access via a custom plan — contact [support@blockdb.io](mailto:support@blockdb.io).
</Warning>

## 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)`
* **Unique:** `_tracing_id`
* **Foreign key:** `(block_number, tx_index)` → `blockdb_evm.b0102_transactions_v1`
* **API:** [POST /evm/raw/internal-transactions](/api-reference/evm/primitives/internal-transactions)
* **CSV Sample:** [Download](https://huggingface.co/datasets/BlockDB/Raw-Internal-Transactions-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0111_internal_transactions_v1.csv?download=true)
* **JSON Sample:** [Download](https://huggingface.co/datasets/BlockDB/Raw-Internal-Transactions-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0111_internal_transactions_v1.json?download=true)

## Sample Viewer

<Frame>
  <iframe src="https://huggingface.co/datasets/BlockDB/Raw-Internal-Transactions-Ethereum-And-EVM-Cryptocurrency-Data/embed/viewer/default/train" frameborder="0" width="100%" height="600px" />
</Frame>

## Columns

| Column | Type | Description |
| - | - | - |
| `block_number` | `BIGINT` | Block number of the parent transaction. |
| `block_time` | `TIMESTAMPTZ` | UTC timestamp of the block. |
| `tx_index` | `INTEGER` | Zero-based index of the parent transaction within the block. |
| `trace_address` | `TEXT` | Position in the call tree (e.g., "0", "0.0", "0.1"). |
| `call_type` | `TEXT` | The type of call: CALL, DELEGATECALL, STATICCALL, CREATE, CREATE2. |
| `from_address` | `BYTEA` | The address of the caller (20 bytes, enforced). |
| `to_address` | `BYTEA` | The address of the callee; null for failed CREATE/CREATE2 (when present, 20 bytes). |
| `value_wei` | `NUMERIC` | The native value (in wei) transferred in this call; non-negative. |
| `gas` | `NUMERIC` | The gas allocated for this call (optional; non-negative when set). |
| `gas_used` | `NUMERIC` | The gas actually consumed by this call (optional; non-negative when set). |
| `input` | `BYTEA` | The input data (calldata) for this call (optional). |
| `output` | `BYTEA` | The return data from the call (optional; if enabled, null = reverted). |
| `error` | `TEXT` | The error message if the call reverted. |
| `tx_success` | `BOOLEAN` | The success of the underlying transaction that caused this internal transaction. |
| `_tracing_id` | `BYTEA` | Internal tracing ID for observability (unique). |
| `_created_at` | `TIMESTAMPTZ` | Record creation timestamp. |
| `_updated_at` | `TIMESTAMPTZ` | Record 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

## Related Datasets

<CardGroup cols={3}>
  <Card title="Transactions" icon="arrow-right-arrow-left" href="/data-catalog/evm/primitives/transactions">
    Top-level transactions that spawned these calls.
  </Card>

  <Card title="Contracts" icon="file-code" href="/data-catalog/evm/primitives/contracts">
    Contract metadata for the callee addresses.
  </Card>

  <Card title="Logs" icon="list" href="/data-catalog/evm/primitives/logs">
    Events emitted during the same transaction context.
  </Card>
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.