Liquidity Pool Fee Terms | Ethereum EVM Blockchain Data

Overview

Dataset ID: 0212
Table: blockdb_evm.b0212_liquidity_pools_fee_terms_v1
Description: Per-pool fee configuration (total fee + split between user/LP, protocol, and extra recipients).
Primary key: (pool_uid, block_number, tx_index, log_index)
Foreign Key: pool_uid → blockdb_evm.b0211_liquidity_pools_v1(pool_uid)
API: POST /evm/entities/pools/fee-terms
CSV Sample: Download
JSON Sample: Download

Sample Viewer

Fee terms are derived from pool metadata (e.g., pool type configuration) rather than parsed from swap logs. Use these terms to split swap fees into user/LP, protocol, and extra destinations.

Columns

Column	Type	Description
`pool_uid`	`BYTEA`	Pool identifier; join to `blockdb_evm.b0211_liquidity_pools_v1`.
`exchange_id`	`INTEGER`	Exchange identifier.
`type_id`	`INTEGER`	Pool type identifier.
`block_number`	`BIGINT`	Block height where the fee-terms change was recognized/anchored.
`block_time`	`TIMESTAMPTZ`	UTC timestamp of the block.
`tx_index`	`INTEGER`	Transaction index within `block_number`.
`log_index`	`INTEGER`	Log index within `tx_index`.
`total_fee`	`NUMERIC(18,18)`	Total fee fraction (e.g., `0.003` = 0.30%). Nullable when unavailable.
`user_fee`	`NUMERIC(18,18)`	Absolute fee fraction allocated to users/LPs (same units as `total_fee`). Nullable.
`protocol_fee`	`NUMERIC(18,18)`	Absolute fee fraction allocated to protocol/treasury (same units as `total_fee`). Nullable.
`extra_fee`	`NUMERIC(18,18)`	Absolute fee fraction allocated to other destinations (burn, staking, etc.). Nullable.
`_tracing_id`	`BYTEA`	Deterministic BlockDB lineage identifier for the fee-terms record.
`_parent_tracing_ids`	`BYTEA[]`	Tracing IDs for upstream derived records referenced during computation.
`_created_at`	`TIMESTAMPTZ`	Record creation timestamp.
`_updated_at`	`TIMESTAMPTZ`	Record update timestamp.

Use Cases

Fee tier discovery and pool classification
Protocol revenue attribution vs LP/user revenue
Normalizing fee splits across heterogeneous AMM designs
Inputs into pool-level yield/ROI forecasting

Liquidity Pools

Pool registry this fee config belongs to.

Swap Fees

Per-swap fee amounts earned by each pool.

Liquidity Pools Yields

Forward-looking yield windows derived from fees.

​Overview

​Sample Viewer

​Columns

​Use Cases

​Related Datasets

Liquidity Pools

Swap Fees

Liquidity Pools Yields

Overview

Sample Viewer

Columns

Use Cases

Related Datasets