Liquidity Pool TVL USD | Ethereum EVM Blockchain Data

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

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.

​Overview

​Sample Viewer

​Columns

​Use Cases

​Related Datasets

Liquidity Pools Reserves

Liquidity Pools

Token-to-USD VWAP

Overview

Sample Viewer

Columns

Use Cases

Related Datasets