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

# Transactions

> Filter canonical transactions with execution metadata and gas accounting.

## Overview

* **Dataset ID:** [`0102 - Transactions`](/data-catalog/evm/primitives/transactions)
* **Description:** Transactions included in blocks.
* **CSV Sample:** [Download](https://huggingface.co/datasets/BlockDB/Raw-Transactions-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0102_transactions_v1.csv?download=true)
* **JSON Sample:** [Download](https://huggingface.co/datasets/BlockDB/Raw-Transactions-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0102_transactions_v1.json?download=true)

## Parameters

<ParamField body="chain_id" type="number" required>
  Target EVM network. *See the [Chain](/api-reference/enumerations/chain) enumeration for supported values.*
</ParamField>

#### Range Filters (mutually exclusive)

<ParamField body="from_block" type="number">
  Starting block number (inclusive) for the query. Use with `to_block`.
</ParamField>

<ParamField body="to_block" type="number">
  Ending block number (inclusive) for the query. Use with `from_block`.
</ParamField>

<ParamField body="from_timestamp" type="string">
  Starting timestamp (ISO-8601). If it falls between blocks, the next block after this timestamp is used. Use with `to_timestamp`.
</ParamField>

<ParamField body="to_timestamp" type="string">
  Ending timestamp (ISO-8601). If it falls between blocks, the last block before this timestamp is used. Use with `from_timestamp`.
</ParamField>

<Warning>
  Validation rule:\
  You must provide **either** a block range, a time range, or explicit selectors.\
  Providing more than one option (e.g., both ranges or ranges plus selectors) results in HTTP 400.\
  Providing none results in HTTP 400.
</Warning>

#### Direct Selectors

<ParamField body="block_numbers" type="number[]">
  Explicit set of block numbers. Mutually exclusive with `tx_hashes`.
</ParamField>

<ParamField body="tx_hashes" type="string[]">
  Explicit set of transaction hashes (hex string, 32 bytes, no `0x` prefix). Mutually exclusive with `block_numbers`.
</ParamField>

#### Address & Type Filters

<ParamField body="from_addresses" type="string[]">
  Filter by sender address (20 bytes, hex string, no `0x` prefix).
</ParamField>

<ParamField body="to_addresses" type="string[]">
  Filter by recipient address (20 bytes, hex string, no `0x` prefix). Contract-creation transactions set `to_address` to `null` and are excluded when this filter is present.
</ParamField>

<ParamField body="created_contract_addresses" type="string[]">
  Filter by contract addresses created by the transaction.
</ParamField>

<ParamField body="status_success" type="boolean">
  Filter by execution status (`true` = success, `false` = revert). Omit to include pre-Byzantium transactions with `null` status.
</ParamField>

<ParamField body="tx_types" type="number[]">
  Filter by transaction type ID (e.g., `2` = EIP-1559, `1` = legacy).
</ParamField>

#### Pagination Controls

<ParamField body="limit" type="number" default="250">
  Recommended default `250`; maximum `1000` to stay under \~10 MB responses.
</ParamField>

<ParamField body="cursor" type="string">
  Opaque pagination cursor supplied by a previous response.
</ParamField>

## Response Fields

#### Meta

<ResponseField name="meta" type="object">
  Echo of request metadata applied to the response.
</ResponseField>

<ResponseField name="meta.chain_id" type="number">
  EVM chain ID echoed from the request.
</ResponseField>

<ResponseField name="meta.request_window" type="object">
  Pure echo of the window you sent (`from_block`/`to_block`/`from_timestamp`/`to_timestamp`); unset bounds are `null`.
</ResponseField>

<ResponseField name="meta.resolved_window" type="object | null">
  The concrete window the query actually executed against, after resolving the request. For a **block range** on a time-bucketed endpoint (OHLC/VWAP/VWAP-aggregate/fiat VWAP), `from_timestamp`/`to_timestamp` hold the resolved timestamp window (and `from_block`/`to_block` echo your request). For a **time range** on a block-keyed endpoint, `from_block`/`to_block` hold the resolved block range (and the timestamps echo your request). `null` for selector-only requests (no window). No extra database work is done — these are the values the query already computed.
</ResponseField>

<ResponseField name="meta.resolved_window.from_block" type="number | null">
  Resolved/echoed start block of the executed window.
</ResponseField>

<ResponseField name="meta.resolved_window.to_block" type="number | null">
  Resolved/echoed end block of the executed window.
</ResponseField>

<ResponseField name="meta.resolved_window.from_timestamp" type="string | null">
  Resolved/echoed start timestamp (ISO-8601) of the executed window.
</ResponseField>

<ResponseField name="meta.resolved_window.to_timestamp" type="string | null">
  Resolved/echoed end timestamp (ISO-8601) of the executed window.
</ResponseField>

<ResponseField name="meta.filters" type="object">
  Filter parameters (block numbers, hashes, addresses, status flags) echoed from the request.
</ResponseField>

#### Data

<ResponseField name="data" type="object[]">
  Array of transaction objects.
</ResponseField>

<ResponseField name="data.block_number" type="number">
  Block height containing the transaction.
</ResponseField>

<ResponseField name="data.block_time" type="string">
  Block timestamp joined from the `blocks` table for easier aggregation.
</ResponseField>

<ResponseField name="data.tx_hash" type="string">
  Keccak-256 hash of the transaction (32 bytes, hex string, no `0x` prefix).
</ResponseField>

<ResponseField name="data.tx_index" type="number">
  Zero-based index within the block; directly verifiable from RLP.
</ResponseField>

<ResponseField name="data.from_address" type="string">
  Sender address (20 bytes).
</ResponseField>

<ResponseField name="data.to_address" type="string | null">
  Recipient address (20 bytes). `null` denotes contract creation.
</ResponseField>

<ResponseField name="data.created_contract_address" type="string | null">
  Address of the contract created by this transaction. `null` for non-creation transactions.
</ResponseField>

<ResponseField name="data.gas_used" type="string">
  Gas consumed by the transaction (string to preserve `NUMERIC(78)` precision).
</ResponseField>

<ResponseField name="data.effective_gas_price_wei" type="string">
  Effective gas price paid, expressed in wei (string to preserve precision).
</ResponseField>

<ResponseField name="data.status_success" type="boolean">
  Execution status: `true` = success, `false` = revert, `null` for pre-Byzantium blocks.
</ResponseField>

<ResponseField name="data.root" type="string">
  Post-transaction state root for pre-Byzantium blocks (32 bytes).
</ResponseField>

<ResponseField name="data.tx_type" type="number">
  Transaction type identifier (e.g., `2` = EIP-1559, `1` = legacy).
</ResponseField>

<ResponseField name="data.trace_failed" type="boolean | null">
  `true` if trace failed, `false` if trace succeeded, `null` if trace not available.
</ResponseField>

<ResponseField name="data.value_wei" type="string">
  Value transferred in wei (string to preserve `NUMERIC` precision).
</ResponseField>

<ResponseField name="data.input" type="string">
  Calldata sent with the transaction (hex string, no `0x` prefix).
</ResponseField>

<ResponseField name="data.nonce" type="number">
  Sender nonce.
</ResponseField>

<ResponseField name="data.gas_limit" type="string">
  Gas limit provided by the sender (string to preserve `NUMERIC` precision).
</ResponseField>

<ResponseField name="data.gas_price_wei" type="string">
  Legacy gas price in wei (string to preserve `NUMERIC` precision).
</ResponseField>

<ResponseField name="data.max_fee_per_gas_wei" type="string">
  Max fee per gas in wei for EIP-1559 transactions (string to preserve `NUMERIC` precision).
</ResponseField>

<ResponseField name="data.max_priority_fee_per_gas_wei" type="string">
  Max priority fee per gas in wei for EIP-1559 transactions (string to preserve `NUMERIC` precision).
</ResponseField>

<ResponseField name="data._tracing_id" type="string">
  Tracing identifier for the canonical transaction record (hex string, no `0x` prefix).
</ResponseField>

<ResponseField name="data._updated_at" type="string">
  Record last update timestamp.
</ResponseField>

<ResponseField name="data._created_at" type="string">
  Record creation timestamp.
</ResponseField>

#### Envelope Fields

<ResponseField name="cursor" type="string | null">
  Cursor token for pagination.
</ResponseField>

<ResponseField name="page_count" type="number">
  Number of records returned in `data`.
</ResponseField>

<RequestExample>
  ```bash cURL theme={null}
  curl -X POST "https://api.blockdb.io/v1/evm/raw/transactions" \
    -H "Authorization: Bearer $BLOCKDB_API_KEY" \
    -H "Content-Type: application/json" \
    -d '{
    "chain_id": 1,
    "from_block": 12345678,
    "to_block": 12345999,
    "from_timestamp": "2025-10-29T00:00:00Z",
    "to_timestamp": "2025-11-11T00:00:00Z",
    "block_numbers": [
      12345678,
      12345679
    ],
    "tx_hashes": [
      "7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0"
    ],
    "from_addresses": [
      "0000000000000000000000000000000000000000"
    ],
    "to_addresses": [
      "0000000000000000000000000000000000000001"
    ],
    "created_contract_addresses": [
      "0000000000000000000000000000000000000002"
    ],
    "status_success": true,
    "tx_types": [
      0,
      1,
      2
    ],
    "limit": 200,
    "cursor": null
  }'
  ```

  ```c C theme={null}
  #include <curl/curl.h>
  #include <stdio.h>
  #include <stdlib.h>

  int main(void) {
      CURL *curl = curl_easy_init();
      if (!curl) return 1;

      const char *token = getenv("BLOCKDB_API_KEY");
      char auth_header[256];
      snprintf(auth_header, sizeof(auth_header), "Authorization: Bearer %s", token ? token : "");
      const char *payload = "{\"chain_id\":1,\"from_block\":12345678,\"to_block\":12345999,\"from_timestamp\":\"2025-10-29T00:00:00Z\",\"to_timestamp\":\"2025-11-11T00:00:00Z\",\"block_numbers\":[12345678,12345679],\"tx_hashes\":[\"7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0\"],\"from_addresses\":[\"0000000000000000000000000000000000000000\"],\"to_addresses\":[\"0000000000000000000000000000000000000001\"],\"created_contract_addresses\":[\"0000000000000000000000000000000000000002\"],\"status_success\":true,\"tx_types\":[0,1,2],\"limit\":200,\"cursor\":null}";

      struct curl_slist *headers = NULL;
      headers = curl_slist_append(headers, auth_header);
      headers = curl_slist_append(headers, "Content-Type: application/json");


      curl_easy_setopt(curl, CURLOPT_URL, "https://api.blockdb.io/v1/evm/raw/transactions");
      curl_easy_setopt(curl, CURLOPT_HTTPHEADER, headers);
      curl_easy_setopt(curl, CURLOPT_POSTFIELDS, payload);


      CURLcode res = curl_easy_perform(curl);

      curl_slist_free_all(headers);
      curl_easy_cleanup(curl);
      return res == CURLE_OK ? 0 : 1;
  }
  ```

  ```csharp .NET theme={null}
  using System;
  using System.Net.Http;
  using System.Net.Http.Headers;
  using System.Text;
  using System.Threading.Tasks;

  class Program
  {
      static async Task Main()
      {
          using var client = new HttpClient();
          client.DefaultRequestHeaders.Authorization =
              new AuthenticationHeaderValue("Bearer", Environment.GetEnvironmentVariable("BLOCKDB_API_KEY"));

          var payload = new StringContent(
              "{\"chain_id\":1,\"from_block\":12345678,\"to_block\":12345999,\"from_timestamp\":\"2025-10-29T00:00:00Z\",\"to_timestamp\":\"2025-11-11T00:00:00Z\",\"block_numbers\":[12345678,12345679],\"tx_hashes\":[\"7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0\"],\"from_addresses\":[\"0000000000000000000000000000000000000000\"],\"to_addresses\":[\"0000000000000000000000000000000000000001\"],\"created_contract_addresses\":[\"0000000000000000000000000000000000000002\"],\"status_success\":true,\"tx_types\":[0,1,2],\"limit\":200,\"cursor\":null}",
              Encoding.UTF8,
              "application/json"
          );

          var response = await client.PostAsync("https://api.blockdb.io/v1/evm/raw/transactions", payload);
          response.EnsureSuccessStatusCode();

          var body = await response.Content.ReadAsStringAsync();
          Console.WriteLine(body);
      }
  }
  ```

  ```python Python theme={null}
  import os
  import requests

  response = requests.post(
      "https://api.blockdb.io/v1/evm/raw/transactions",
      headers={
          "Authorization": f"Bearer {os.getenv('BLOCKDB_API_KEY')}",
          "Content-Type": "application/json"
      },
      json={'block_numbers': [12345678, 12345679],
   'chain_id': 1,
   'created_contract_addresses': ['0000000000000000000000000000000000000002'],
   'from_addresses': ['0000000000000000000000000000000000000000'],
   'from_block': 12345678,
   'from_timestamp': '2025-10-29T00:00:00Z',
   'status_success': True,
   'to_addresses': ['0000000000000000000000000000000000000001'],
   'to_block': 12345999,
   'to_timestamp': '2025-11-11T00:00:00Z',
   'tx_hashes': ['7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0'],
   'tx_types': [0, 1, 2],
   'limit': 200,
   'cursor': None}
  )

  data = response.json()
  print(data)
  ```

  ```javascript Node.js theme={null}
  const response = await fetch("https://api.blockdb.io/v1/evm/raw/transactions", {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.BLOCKDB_API_KEY}`,
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
    "chain_id": 1,
    "from_block": 12345678,
    "to_block": 12345999,
    "from_timestamp": "2025-10-29T00:00:00Z",
    "to_timestamp": "2025-11-11T00:00:00Z",
    "block_numbers": [
      12345678,
      12345679
    ],
    "tx_hashes": [
      "7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0"
    ],
    "from_addresses": [
      "0000000000000000000000000000000000000000"
    ],
    "to_addresses": [
      "0000000000000000000000000000000000000001"
    ],
    "created_contract_addresses": [
      "0000000000000000000000000000000000000002"
    ],
    "status_success": true,
    "tx_types": [
      0,
      1,
      2
    ],
    "limit": 200,
    "cursor": null
  })
  });

  const data = await response.json();
  console.log(data);
  ```

  ```go Go theme={null}
  package main

  import (
      "fmt"
      "net/http"
      "os"
      "strings"
  )

  func main() {
      payload := strings.NewReader(`{
    "chain_id": 1,
    "from_block": 12345678,
    "to_block": 12345999,
    "from_timestamp": "2025-10-29T00:00:00Z",
    "to_timestamp": "2025-11-11T00:00:00Z",
    "block_numbers": [
      12345678,
      12345679
    ],
    "tx_hashes": [
      "7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0"
    ],
    "from_addresses": [
      "0000000000000000000000000000000000000000"
    ],
    "to_addresses": [
      "0000000000000000000000000000000000000001"
    ],
    "created_contract_addresses": [
      "0000000000000000000000000000000000000002"
    ],
    "status_success": true,
    "tx_types": [
      0,
      1,
      2
    ],
    "limit": 200,
    "cursor": null
  }`)

      req, _ := http.NewRequest("POST", "https://api.blockdb.io/v1/evm/raw/transactions", payload)
      req.Header.Set("Authorization", fmt.Sprintf("Bearer %s", os.Getenv("BLOCKDB_API_KEY")))
      req.Header.Set("Content-Type", "application/json")

      client := &http.Client{}
      resp, _ := client.Do(req)
      defer resp.Body.Close()

      // Handle response
  }
  ```
</RequestExample>

<ResponseExample>
  ```json 200 theme={null}
  {
    "meta": {
      "chain_id": 1,
      "request_window": {
        "from_block": 12345678,
        "to_block": 12345999,
        "from_timestamp": "2025-10-29T00:00:00Z",
        "to_timestamp": "2025-11-11T00:00:00Z"
      },
      "resolved_window": {
        "from_block": 12345678,
        "to_block": 12345999,
        "from_timestamp": "2025-10-29T00:00:00Z",
        "to_timestamp": "2025-11-11T00:00:00Z"
      },
      "filters": {
        "block_numbers": [
          12345678,
          12345679
        ],
        "tx_hashes": [
          "7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0"
        ],
        "from_addresses": [
          "0000000000000000000000000000000000000000"
        ],
        "to_addresses": [
          "0000000000000000000000000000000000000001"
        ],
        "created_contract_addresses": [
          "0000000000000000000000000000000000000002"
        ],
        "status_success": true,
        "tx_types": [
          0,
          1,
          2
        ]
      }
    },
    "data": [
      {
        "block_number": 12345678,
        "block_time": "2025-11-11T18:42:15.123Z",
        "tx_hash": "7b5c0972efb6a0b5be4a4d4a0de5d1abd922478a53f32b2c717a800c862ba9e0",
        "tx_index": 4,
        "from_address": "0000000000000000000000000000000000000000",
        "to_address": "0000000000000000000000000000000000000001",
        "created_contract_address": null,
        "gas_used": "21000",
        "effective_gas_price_wei": "1234567890123456789",
        "status_success": true,
        "root": null,
        "tx_type": 2,
        "trace_failed": false,
        "value_wei": "0",
        "input": "a9059cbb000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000003e8",
        "nonce": 7,
        "gas_limit": 21000,
        "gas_price_wei": "1234567890",
        "max_fee_per_gas_wei": "2000000000",
        "max_priority_fee_per_gas_wei": "1000000000",
        "_tracing_id": "010200000000000000000000000000000000",
        "_created_at": "2025-11-11T18:42:15.123Z",
        "_updated_at": "2025-11-11T18:42:15.123Z"
      }
    ],
    "cursor": null,
    "page_count": 1
  }
  ```

  ```json 400 theme={null}
  {
    "error": {
      "code": "BAD_REQUEST",
      "http_status": 400,
      "message": "The request contains invalid or missing parameters.",
      "hint": "Validate all required parameters against the endpoint specification before retrying.",
      "severity": "error",
      "retryable": false,
      "details": {
        "invalid_parameters": [
          {
            "name": "chain_id",
            "location": "query",
            "reason": "missing",
            "expected": "positive integer, e.g. 1"
          },
          {
            "name": "from_timestamp",
            "location": "query",
            "reason": "invalid_format",
            "expected": "ISO-8601 UTC timestamp, e.g. 2025-11-11T00:00:00Z"
          }
        ]
      },
      "docs_url": "https://docs.blockdb.io/api-reference/overview/home"
    }
  }
  ```

  ```json 401 theme={null}
  {
    "error": {
      "code": "UNAUTHORIZED",
      "http_status": 401,
      "message": "Invalid or missing API key.",
      "hint": "Ensure you send 'Authorization: Bearer <API_KEY>' in every request to this endpoint.",
      "severity": "error",
      "retryable": false,
      "details": {
        "auth_scheme": "bearer",
        "expected_header": "Authorization: Bearer <API_KEY>",
        "provided_header": "Authorization: <REDACTED_OR_MISSING>",
        "token_status": "invalid_or_missing",
        "recommendation": "Regenerate the API key if you suspect it is expired or compromised."
      },
      "docs_url": "https://docs.blockdb.io/api-reference/overview/authorization"
    }
  }
  ```

  ```json 403 theme={null}
  {
    "error": {
      "code": "FORBIDDEN",
      "http_status": 403,
      "message": "Your API key does not have permission to access this endpoint.",
      "hint": "Upgrade your subscription tier or request additional access.",
      "severity": "warning",
      "retryable": false,
      "details": {
        "required_plan": "production",
        "your_plan": null,
        "contact": "support@blockdb.io",
        "recommendation": "Contact BlockDB Support Team via email support@blockdb.io."
      },
      "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
    }
  }
  ```

  ```json 404 theme={null}
  {
    "error": {
      "code": "NOT_FOUND",
      "http_status": 404,
      "message": "The requested resource does not exist.",
      "hint": "Verify the API endpoint",
      "severity": "warning",
      "retryable": false,
      "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
    }
  }
  ```

  ```json 413 theme={null}
  {
    "error": {
      "code": "PAYLOAD_TOO_LARGE",
      "http_status": 413,
      "message": "The requested response exceeds the maximum allowed size of 10 MB.",
      "hint": "Reduce the limit, narrow the block or time window, or apply additional filters before retrying.",
      "details": {
        "max_allowed_bytes": 10485760,
        "estimated_response_bytes": 15360000,
        "recommended_actions": [
          "Decrease the 'limit' parameter value",
          "Shorten the block range or time window",
          "Filter by fewer pools or exchanges"
        ]
      },
      "docs_url": "https://docs.blockdb.io/api-reference/overview/pagination-and-limits"
    }
  }
  ```

  ```json 422 theme={null}
  {
    "error": {
      "code": "CHAIN_NOT_SUPPORTED",
      "http_status": 422,
      "message": "chain_id=137 is not supported.",
      "hint": "Use a supported chain_id. Consult the documentation for the list of available chains.",
      "severity": "error",
      "retryable": false,
      "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
    }
  }
  ```

  ```json 429 theme={null}
  {
    "error": {
      "code": "RATE_LIMIT_EXCEEDED",
      "http_status": 429,
      "message": "You have exceeded the allowed request rate.",
      "hint": "Introduce client-side throttling or exponential backoff and respect the retry_after_seconds value.",
      "details": {
        "limit_rps": 1000, # configured rate limit
        "current_estimated_rps": 73,
        "retry_after_seconds": 2,
        "limit_scope": "api_key",
        "limit_window_seconds": 1
      },
      "docs_url": "https://docs.blockdb.io/api-reference/overview/rate-limiting"
    }
  }
  ```

  ```json 500 theme={null}
  {
    "error": {
      "code": "INTERNAL_SERVER_ERROR",
      "http_status": 500,
      "message": "An unexpected server error occurred.",
      "hint": "This error is not caused by your request. You may retry after a short delay.",
      "severity": "critical",
      "retryable": true,
      "details": {
        "incident_id": "INC-2025-11-11-123456",
        "temporary_issue": true,
        "expected_recovery_seconds": 5
      },
      "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
    }
  }
  ```

  ```json 503 theme={null}
  {
    "error": {
      "code": "SERVICE_UNAVAILABLE",
      "http_status": 503,
      "message": "The service is temporarily unable to handle the request.",
      "hint": "The database connection pool is briefly saturated. Retry after a short delay.",
      "severity": "warning",
      "retryable": true,
      "details": null,
      "docs_url": "https://docs.blockdb.io/api-reference/overview/error-codes"
    }
  }
  ```
</ResponseExample>