BlockDB Swaps Fees | Ethereum & EVM Chains | Historical, EOD, Real-Time | Bitcoin Price Data

Per-swap fee accounting capturing total, LP/user, protocol, and extra fee amounts for each on-chain swap event. One row per swap direction per event, with audit-grade lineage to the originating swap log and deterministic tracing at the row level.

Chains and Coverage
ETH, BSC, Base, Arbitrum, Unichain, Avalanche, Polygon, Celo, Linea, Optimism (others on request).
Full history from chain genesis; reorg-aware real-time ingestion and updates.

Schema
List the columns exactly as delivered.
- id BIGINT - PK; surrogate identity for the swap fee record (auto-incremented)
- pool_uid BYTEA - FK; internal pool identifier linking to liquidity_pools
- exchange_id INTEGER - Exchange/DEX identifier
- type_id INTEGER - Pool type identifier (FK to liquidity_pool_types)
- block_number BIGINT - block height when the swap was executed
- 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 transaction
- token_in BYTEA - 20-byte address of the input token (direction of trade)
- token_out BYTEA - 20-byte address of the output token
- fee_token BYTEA - 20-byte address of the token in which fees are denominated (typically token_in)
- amount_in NUMERIC(78,0) - raw amount of token_in (lossless, pre-decimal scaling)
- amount_out NUMERIC(78,0) - raw amount of token_out (lossless, pre-decimal scaling)
- fee_amount_total NUMERIC(78,0) - total fee amount in fee_token units
- fee_amount_user NUMERIC(78,0) - LP/user share of fees in fee_token units (nullable)
- fee_amount_protocol NUMERIC(78,0) - protocol share of fees in fee_token units (nullable)
- fee_amount_extra NUMERIC(78,0) - other/additional share of fees in fee_token units (nullable)
- _tracing_id BYTEA - deterministic row-level hash
- _parent_tracing_ids BYTEA[] - hash(es) of immediate parent rows in the derivation graph
- _genesis_tracing_ids BYTEA[] - hash(es) of original sources (genesis of the derivation path)
- _created_at TIMESTAMPTZ - Record creation timestamp
- _updated_at TIMESTAMPTZ - Record last update timestamp

Notes
- Use encode(pool_uid,'hex') or encode(token_in,'hex') for hex presentation.
- fee_token is always either token_in or token_out (validated by constraint).
- fee_amount_total is guaranteed to be ≤ the corresponding amount (amount_in or amount_out depending on fee_token).
- The sum of fee_amount_user + fee_amount_protocol + fee_amount_extra ≤ fee_amount_total when all are present.
- Uniqueness is enforced per (pool_uid, token_in, token_out, block_number, tx_index, log_index).

Lineage
Every row has a verifiable path back to the originating raw events via the lineage triple and tracing graph:
- _tracing_id - this row's identity
- _parent_tracing_ids - immediate sources
- _genesis_tracing_ids - original on-chain sources
This supports audits and exact reprocessing to source transactions/logs/function calls.

Use Cases
- Calculate LP earnings and protocol revenue from swap fees
- Analyze fee structures and fee tier performance across DEXs
- Build fee-adjusted PnL models for liquidity providers
- Compare fee economics between Uniswap, Curve, Balancer, and other AMMs
- Track protocol fee switches and their impact on LP returns

搜集汇总

背景与挑战

背景概述

该数据集捕获以太坊及多个EVM链上交换事件的费用明细，包括总费用、LP/用户费用、协议费用和额外费用，支持历史数据和实时更新。数据结构包含详细的交换信息列和审计级溯源字段，适用于分析DEX费用结构和流动性提供者收益。