> ## 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.

## 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>