Skip to main content

​
Overview

BlockDB ships a Postgres schema for every dataset that also powers the Historic REST API. The scripts in /BlockDb.Postgres.Tables.Public are the canonical definitions; each dataset here mirrors the SQL CREATE TABLE statements, constraints, and indexes from that source. All tables follow a blockdb<dataset_id>_<name>_v<major> naming convention. Dataset IDs match the REST API identifiers (0101 for blocks, 0201 for ERC-20 tokens, etc.) so you can map SQL exports to API payloads or lineage metadata.

​
How to use this catalog

  1. Pick a dataset group (Ledger & Execution, Tokens & Liquidity, Pricing, etc.).
  2. Open the dataset page to review column-level documentation, constraints, and indexes.
  3. Run the matching .sql file against your warehouse or use it as a reference when transforming extracts coming from the Historic API.
DatasetTableDescription
0001blockdb0001_decentralized_exchanges_types_v1DEX families (Uniswap, SushiSwap, Curve, …).
0002blockdb0002_liquidity_pools_types_v1AMM pool archetype metadata.
0101blockdb0101_blocks_v1Canonical EVM blocks with integrity metadata.
0102blockdb0102_transactions_v1Executed transactions, gas usage, and lineage fields.
0103blockdb0103_logs_v1Event logs emitted by smart contracts.
0104blockdb0104_contracts_v1Deployment metadata for verified contracts.
0105blockdb0105_function_results_v1Deterministic contract call outputs.
0201blockdb0201_erc20_tokens_v1ERC-20 token registry and compliance fields.
0202blockdb0202_erc721_tokens_v1ERC-721 collection metadata and mint stats.
0203blockdb0203_liquidity_pools_v1On-chain AMM pools (addressing, type IDs, fee tiers).
0301blockdb0301_liquidity_pools_reserves_v1Normalized reserve snapshots joined to pool metadata.
0401blockdb0401_token_to_token_prices_l1_v1L1 depth-normalized synthetic prices.
0402blockdb0402_token_to_token_prices_l2_v1L2 venue-aggregated prices.
0403blockdb0403_token_to_token_prices_l3_v1L3 liquidity-routed composite prices.
0404blockdb0404_token_to_token_prices_ohlc_v1OHLC bars derived from synthetic spot markets.
0501blockdb0501_token_to_token_vwap_v1VWAP windows across class pairs.
0502blockdb0502_token_to_token_lwap_v1Liquidity-weighted average price slices.