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）的价格分析。所有数据均通过加密哈希可追溯至原始链上事件，适用于交易执行、套利检测和市场分析等场景。