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

# TVL USD

> Read pool Total Value Locked (TVL) snapshots in USD.

<Warning>
  **Not available on the public API yet:** This endpoint is scheduled to become available **by the end of May 2026**. Until then, calls may fail (for example with `404`, `403`, or `501`). For early access or contract timelines, contact [support@blockdb.io](mailto:support@blockdb.io).
</Warning>

## Overview

* **Dataset ID:** [`0701 - Liquidity Pool TVL (USD)`](/data-catalog/evm/tvl/liquidity-pools-tvl-usd)
* **Description:** Pool TVL (Total Value Locked) snapshots in USD, computed from reserves multiplied by fiat prices. Grain: one row per (pool, event triple); `pool_uid` → `blockdb_evm.b0211_liquidity_pools_v1`.
* **CSV Sample:** [Download](https://huggingface.co/datasets/BlockDB/Liquidity-Pools-TVL-USD-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0701_liquidity_pools_tvl_usd_v1.csv?download=true)
* **JSON Sample:** [Download](https://huggingface.co/datasets/BlockDB/Liquidity-Pools-TVL-USD-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0701_liquidity_pools_tvl_usd_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 at least one direct selector.\
  Providing more than one option results in HTTP 400.\
  Providing none results in HTTP 400.
</Warning>

#### Pool Selectors

<ParamField body="exchange_ids" type="number[]">
  Filter pools by exchange IDs. *See the [DigitalExchange](/api-reference/enumerations/digital-exchange) enumeration for supported values.*
</ParamField>

<ParamField body="pool_uids" type="string[]">
  Filter by BlockDB pool identifiers (`uid` from `/evm/entities/pools`).
</ParamField>

<ParamField body="pool_addresses" type="string[]">
  Filter by pool contract addresses (hex string, 20 bytes, no `0x` prefix).
</ParamField>

<ParamField body="pool_type_ids" type="number[]">
  Filter by AMM archetype. *See the [PoolType](/api-reference/enumerations/pool-type) enumeration for supported values.*
</ParamField>

#### TVL Filters

<ParamField body="min_tvl_usd" type="number">
  Minimum TVL threshold in USD.
</ParamField>

<ParamField body="max_tvl_usd" type="number">
  Maximum TVL threshold in USD.
</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">
  Pagination cursor from a prior call.
</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">
  Filters echoed from the request (selectors, TVL filters, pagination state, etc.).
</ResponseField>

#### Data

<ResponseField name="data" type="object[]">
  Array of TVL snapshot records matching the request.
</ResponseField>

<ResponseField name="data.pool_uid" type="string">
  BlockDB pool identifier — 32-byte `pool_uid` (`uid` from `/evm/entities/pools`).
</ResponseField>

<ResponseField name="data.exchange_id" type="number">
  Exchange / DEX identifier for the pool.
</ResponseField>

<ResponseField name="data.type_id" type="number">
  Pool type identifier (AMM archetype).
</ResponseField>

<ResponseField name="data.block_number" type="number">
  Block height of the TVL snapshot.
</ResponseField>

<ResponseField name="data.block_time" type="string">
  UTC timestamp of the TVL snapshot.
</ResponseField>

<ResponseField name="data.tx_index" type="number">
  Zero-based transaction index within the block.
</ResponseField>

<ResponseField name="data.log_index" type="number">
  Zero-based log index within the transaction.
</ResponseField>

<ResponseField name="data.token_amounts" type="string[]">
  Array of token amounts (decimals-adjusted), aligned with pool tokens. Returned as strings to preserve precision.
</ResponseField>

<ResponseField name="data.tvl_usd" type="string">
  Total value locked in USD. Returned as a string to preserve precision.
</ResponseField>

<ResponseField name="data._tracing_id" type="string">
  Row-level lineage hash (hex string, no `0x` prefix).
</ResponseField>

<ResponseField name="data._parent_tracing_ids" type="string[]">
  Lineage references of immediate parents.
</ResponseField>

<ResponseField name="data._created_at" type="string">
  Record creation timestamp (ISO-8601).
</ResponseField>

<ResponseField name="data._updated_at" type="string">
  Last update timestamp (ISO-8601).
</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/tvl" \
    -H "Authorization: Bearer $BLOCKDB_API_KEY" \
    -H "Content-Type: application/json" \
    -d '{
    "chain_id": 1,
    "pool_uids": [
      "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000"
    ],
    "from_timestamp": "2025-12-01T00:00:00Z",
    "to_timestamp": "2025-12-20T00:00:00Z",
    "min_tvl_usd": 1000000,
    "limit": 250
  }'
  ```

  ```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,\"pool_uids\":[\"88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000\"],\"from_timestamp\":\"2025-12-01T00:00:00Z\",\"to_timestamp\":\"2025-12-20T00:00:00Z\",\"min_tvl_usd\":1000000,\"limit\":250}";

      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/tvl");
      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,\"pool_uids\":[\"88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000\"],\"from_timestamp\":\"2025-12-01T00:00:00Z\",\"to_timestamp\":\"2025-12-20T00:00:00Z\",\"min_tvl_usd\":1000000,\"limit\":250}",
              Encoding.UTF8,
              "application/json"
          );

          var response = await client.PostAsync("https://api.blockdb.io/v1/evm/tvl", 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/tvl",
      headers={
          "Authorization": f"Bearer {os.getenv('BLOCKDB_API_KEY')}",
          "Content-Type": "application/json"
      },
      json={
          'chain_id': 1,
          'pool_uids': ['88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000'],
          'from_timestamp': '2025-12-01T00:00:00Z',
          'to_timestamp': '2025-12-20T00:00:00Z',
          'min_tvl_usd': 1000000,
          'limit': 250
      }
  )

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

  ```javascript Node.js theme={null}
  const response = await fetch("https://api.blockdb.io/v1/evm/tvl", {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${process.env.BLOCKDB_API_KEY}`,
      "Content-Type": "application/json"
    },
    body: JSON.stringify({
      "chain_id": 1,
      "pool_uids": [
        "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000"
      ],
      "from_timestamp": "2025-12-01T00:00:00Z",
      "to_timestamp": "2025-12-20T00:00:00Z",
      "min_tvl_usd": 1000000,
      "limit": 250
    })
  });

  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,
    "pool_uids": [
      "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000"
    ],
    "from_timestamp": "2025-12-01T00:00:00Z",
    "to_timestamp": "2025-12-20T00:00:00Z",
    "min_tvl_usd": 1000000,
    "limit": 250
  }`)

      req, _ := http.NewRequest("POST", "https://api.blockdb.io/v1/evm/tvl", 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()
  }
  ```
</RequestExample>

<ResponseExample>
  ```json 200 theme={null}
  {
    "meta": {
      "chain_id": 1,
      "request_window": {
        "from_block": null,
        "to_block": null,
        "from_timestamp": "2025-12-01T00:00:00Z",
        "to_timestamp": "2025-12-20T00:00:00Z"
      },
      "resolved_window": {
        "from_block": 21640000,
        "to_block": 21775000,
        "from_timestamp": "2025-12-01T00:00:00Z",
        "to_timestamp": "2025-12-20T00:00:00Z"
      },
      "filters": {
        "pool_uids": [
          "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000"
        ],
        "min_tvl_usd": 1000000,
        "limit": 250,
        "cursor": null
      }
    },
    "data": [
      {
        "pool_uid": "88e6a0c2ddd26feeb64f039a2c41296fcb3f5640000000000000000000000000",
        "exchange_id": 1,
        "type_id": 201,
        "block_number": 19001234,
        "block_time": "2025-12-20T12:34:56Z",
        "tx_index": 7,
        "log_index": 12,
        "token_amounts": [
          "1250.000000000000000000",
          "3950000.000000000000000000"
        ],
        "tvl_usd": "8750000.00",
        "_tracing_id": "0701c0ffee000000000000000000000000000000000000000000000000000001",
        "_parent_tracing_ids": [
          "0301c0ffee000000000000000000000000000000000000000000000000000001"
        ],
        "_created_at": "2025-12-20T12:35:01Z",
        "_updated_at": "2025-12-20T12:35:01Z"
      }
    ],
    "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 contract addresses"
        ]
      },
      "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,
        "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>