> ## 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 Fee Terms

> Time-versioned AMM pool fee configuration — LP, protocol & extra splits. Ethereum & EVM chains. REST API.

## 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](/api-reference/evm/entities/fee-terms)
* **CSV Sample:** [Download](https://huggingface.co/datasets/BlockDB/Liquidity-Pools-Fee-Terms-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0212_liquidity_pools_fee_terms_v1.csv?download=true)
* **JSON Sample:** [Download](https://huggingface.co/datasets/BlockDB/Liquidity-Pools-Fee-Terms-Ethereum-And-EVM-Cryptocurrency-Data/resolve/main/data/blockdb_evm.b0212_liquidity_pools_fee_terms_v1.json?download=true)

## Sample Viewer

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

<Info>
  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.
</Info>

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

## Related Datasets

<CardGroup cols={3}>
  <Card title="Liquidity Pools" icon="water" href="/data-catalog/evm/entities/liquidity-pools">
    Pool registry this fee config belongs to.
  </Card>

  <Card title="Swap Fees" icon="arrow-right-arrow-left" href="/data-catalog/evm/swaps/liquidity-pools-swap-fees">
    Per-swap fee amounts earned by each pool.
  </Card>

  <Card title="Liquidity Pools Yields" icon="chart-line" href="/data-catalog/evm/yields/liquidity-pools-yields">
    Forward-looking yield windows derived from fees.
  </Card>
</CardGroup>