Overview
- Dataset ID:
0204 - Table:
blockdb_evm.0204_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
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 (internal). Use to join across pool-centric datasets. |
block_number | BIGINT | Block height where the fee-terms change was recognized/anchored. |
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.) (same units as total_fee). Nullable. |
_tracing_id | BYTEA | Deterministic BlockDB lineage identifier for the fee-terms record. |
_genesis_tracing_ids | BYTEA[] | Tracing IDs for the raw artifacts that seeded this 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