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

# Liquidity Pool TVL USD

> Tick-resolution USD TVL for every AMM pool — derived from onchain reserves & BlockDB prices. 10 EVM chains.

## Overview

* **Dataset ID:** `0701`
* **Table:** `blockdb_evm.b0701_liquidity_pools_tvl_usd_v1`
* **Description:** Pool TVL (Total Value Locked) snapshots in USD, computed from reserves multiplied by fiat prices. Provides a standardized USD-denominated measure of pool liquidity at each on-chain event.
* **Primary key:** `(pool_uid, block_number, tx_index, log_index)`
* **API:** [POST /evm/tvl](/api-reference/evm/tvl/tvl-usd)
* **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)

## Sample Viewer

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

<Info>
  TVL is computed as `sum(token_amounts[i] x fiat_price[i])` for all tokens in the pool. The `token_amounts` array is aligned with the pool's token order from the `blockdb_evm.b0211_liquidity_pools_v1` dataset.
</Info>

## Columns

| Column                | Type               | Description                                                           |
| --------------------- | ------------------ | --------------------------------------------------------------------- |
| `pool_uid`            | `BYTEA`            | Unique pool identifier (32 bytes).                                    |
| `exchange_id`         | `INTEGER`          | Exchange/DEX identifier.                                              |
| `type_id`             | `INTEGER`          | Pool type identifier (FK to liquidity\_pool\_types).                  |
| `block_number`        | `BIGINT`           | Block number when the TVL snapshot was recorded.                      |
| `block_time`          | `TIMESTAMPTZ`      | UTC timestamp when the block was mined.                               |
| `tx_index`            | `INTEGER`          | Transaction index within the block.                                   |
| `log_index`           | `INTEGER`          | Log index within the block.                                           |
| `token_amounts`       | `NUMERIC(78,18)[]` | Array of token amounts (decimals-adjusted), aligned with pool tokens. |
| `tvl_usd`             | `NUMERIC(78,18)`   | Total value locked in USD.                                            |
| `_tracing_id`         | `BYTEA`            | Tracing ID of this TVL record (18 bytes).                             |
| `_parent_tracing_ids` | `BYTEA[]`          | Tracing IDs of the parent records leading to this TVL record.         |
| `_created_at`         | `TIMESTAMPTZ`      | Record creation timestamp.                                            |
| `_updated_at`         | `TIMESTAMPTZ`      | Record last update timestamp.                                         |

## Use Cases

* DEX and pool TVL rankings and dashboards
* Liquidity migration tracking across protocols
* TVL trend analysis and anomaly detection
* Protocol health monitoring and risk assessment
* Liquidity depth scoring for routing decisions

## Related Datasets

<CardGroup cols={3}>
  <Card title="Liquidity Pools Reserves" icon="database" href="/data-catalog/evm/reserves/liquidity-pools-reserves">
    Raw reserve snapshots that feed TVL calculations.
  </Card>

  <Card title="Liquidity Pools" icon="water" href="/data-catalog/evm/entities/liquidity-pools">
    Pool registry for the TVL-tracked venues.
  </Card>

  <Card title="Token-to-USD VWAP" icon="dollar-sign" href="/data-catalog/evm/prices/token-to-fiat-vwap">
    USD benchmarks used when marking reserves to dollars.
  </Card>
</CardGroup>