BlockDB Token to Token Prices | Ethereum & EVM Chains | Historical, EOD, Real-Time | ...

Dataset Overview
Comprehensive suite of synthetic, lineage-verified token-to-token pricing datasets built from raw DEX swaps, reserves, and liquidity states.
Each level (L1–L3) represents a distinct resolution of price and liquidity impact: from ±1% micro-depth to full-range tick grids.

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.
Coverage includes all major DEX protocols holding stablecoin pairs:
• Uniswap V2, V3, V4
• Curve, Balancer, Aerodrome, Solidly, Maverick, Pancake, and others

Schema
List the columns exactly as delivered.
Each sub-product extends this base schema with specific price-resolution fields.
• id BIGINT – Surrogate row id.
• pool_uid BIGINT NOT NULL – Pool identifier (FK → liquidity_pools(uid)).
• block_number BIGINT - first block where the token was recognized
• block_time TIMESTAMPTZ - UTC timestamp when the block was mined
• tx_index INTEGER - tx index for that event
• log_index INTEGER - log index for that event
• token_in BYTEA NOT NULL – 20-byte address of input token (FK → erc20_tokens(contract_address)).
• token_out BYTEA NOT NULL – 20-byte address of output token (FK → erc20_tokens(contract_address)).
• current_price NUMERIC(78,18) NOT NULL – Mid price at snapshot (token_out per 1 token_in, decimals-adjusted).
• _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
• Additional columns depend on level:
• L1: ±1% impact, offset_bps, size_in, size_out, target_price.
• L2: granular price grids (e.g., every 10 bps within ±10%).
• L3: full-range tick-level prices across entire Uniswap V3-style pools.
• OHLC: time-bucketed open-high-low-close values with volume.

Notes:
• For hex display: encode(token_in,'hex'), encode(token_out,'hex').

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.

Common Use Cases
• Execution sizing & price impact analysis at micro (L1) and full-range (L3) depth.
• Routing and arbitrage detection across chains and pools.
• Market structure analytics and slippage modeling.
• Backtesting and ML feature generation (depth, liquidity, volatility, impact).
• Protocol health monitoring — liquidity degradation, fee sensitivity, depth decay.

Quality
• Each row includes a cryptographic hash linking back to raw on-chain events for auditability.
• Tick-level resolution for precision.
• Reorg-aware ingestion ensuring data integrity.
• Complete backfills to chain genesis for consistency.

搜集汇总

背景与挑战

背景概述

该数据集提供以太坊及EVM链上代币间价格数据，包含从链初始至今的历史记录和实时更新，支持不同精度级别（L1-L3）的价格分析。所有数据均通过加密哈希可追溯至原始链上事件，适用于交易执行、套利检测和市场分析等场景。