Overview
- Dataset ID:
0601 - Table:
blockdb_evm.b0601_liquidity_pools_tvl_usd_v1 - What it is: 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.
- Grain: 1 row per (pool, event triple).
- Primary location fields:
pool_uid,block_number,block_time(UTC),tx_index,log_index - Join keys:
- Pool:
pool_uid→blockdb_evm.b0211_liquidity_pools_v1.pool_uid - Provenance:
(block_number, tx_index, log_index)→blockdb_evm.b0103_logs_v1
- Pool:
- API: POST /evm/tvl
TVL is computed as
sum(token_amounts[i] × 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 |
|---|---|---|
id | BIGINT | Surrogate primary key for the TVL record (auto-incremented). |
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[] | Array of token amounts (decimals-adjusted), aligned with pool tokens. |
tvl_usd | NUMERIC | 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. |
Indexes
(pool_uid, block_number DESC)— Fast pool-specific time-series queries(block_number, tx_index, log_index)— Event triple lookupsblock_number— Block-range scansblock_time— Time-range scanstvl_usd DESC— TVL ranking queries
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