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
- Pick a dataset group (Ledger & Execution, Tokens & Liquidity, Pricing, etc.).
- Open the dataset page to review column-level documentation, constraints, and indexes.
- Run the matching
.sqlfile against your warehouse or use it as a reference when transforming extracts coming from the Historic API.
The Postgres tables include the same
_tracing_id, _created_at, and _updated_at fields you see in the API. Use _tracing_id to resolve any row back to its lineage endpoints.What’s in this section
- Coverage — which chains, networks, and DEX protocols we support
- Delivery — all channels to consume datasets and how to choose
- Data Granularity — raw vs derived vs analytics layers
- Data Freshness — expected latency and how to verify
- Data Verification — cryptographic integrity and lineage
- Access & SLA — availability targets and support
- Schema Governance — versioning and deprecations
Dataset index
| Dataset | Table | Description |
|---|---|---|
0001 | blockdb0001_decentralized_exchanges_types_v1 | DEX families (Uniswap, SushiSwap, Curve, …). |
0002 | blockdb0002_liquidity_pools_types_v1 | AMM pool archetype metadata. |
0101 | blockdb0101_blocks_v1 | Canonical EVM blocks with integrity metadata. |
0102 | blockdb0102_transactions_v1 | Executed transactions, gas usage, and lineage fields. |
0103 | blockdb0103_logs_v1 | Event logs emitted by smart contracts. |
0104 | blockdb0104_contracts_v1 | Deployment metadata for verified contracts. |
0105 | blockdb0105_function_results_v1 | Deterministic contract call outputs. |
0201 | blockdb0201_erc20_tokens_v1 | ERC-20 token registry and compliance fields. |
0202 | blockdb0202_erc721_tokens_v1 | ERC-721 collection metadata and mint stats. |
0203 | blockdb0203_liquidity_pools_v1 | On-chain AMM pools (addressing, type IDs, fee tiers). |
0301 | blockdb0301_liquidity_pools_reserves_v1 | Normalized reserve snapshots joined to pool metadata. |
0401 | blockdb0401_token_to_token_prices_l1_v1 | L1 depth-normalized synthetic prices. |
0402 | blockdb0402_token_to_token_prices_l2_v1 | L2 venue-aggregated prices. |
0403 | blockdb0403_token_to_token_prices_l3_v1 | L3 liquidity-routed composite prices. |
0404 | blockdb0404_token_to_token_prices_ohlc_v1 | OHLC bars derived from synthetic spot markets. |
0501 | blockdb0501_token_to_token_vwap_v1 | VWAP windows across class pairs. |
0502 | blockdb0502_token_to_token_lwap_v1 | Liquidity-weighted average price slices. |