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.
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
- CSV Sample: Download
- JSON Sample: Download
Sample Viewer
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.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
Liquidity Pools Reserves
Raw reserve snapshots that feed TVL calculations.
Liquidity Pools
Pool registry for the TVL-tracked venues.
Token-to-USD VWAP
USD benchmarks used when marking reserves to dollars.