BlockDB Stablecoins Prices | Ethereum & EVM Chains | Historical, EOD, Real-Time | Stablecoins Data

Dataset Overview
Canonical dataset of stablecoin prices and liquidity across major decentralized exchanges.
Each record represents a normalized, lineage-verified stablecoin-to-reference pair (e.g. USDC/USDT, DAI/USDC, USDC/ETH), aggregated from DEX-level swaps, reserves, and pool states.

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
• Stablecoin peg monitoring and deviation analysis across chains
• Liquidity-weighted cross-chain parity tracking
• Arbitrage and routing research between USD-pegged assets
• Volatility and stability modeling for quantitative trading or DeFi risk
• AI/ML signal extraction for anomaly detection and peg loss prediction

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.