Skip to main content

Scope

The EVM catalog spans the canonical ledger, execution traces, liquidity metadata, pricing, flash loans, TVL, yields, and arbitrage datasets for Ethereum and compatible L2/L3 chains. Every table in /data-catalog/evm mirrors the Postgres DDL in the BlockDB Postgres Tables directory in this repository, aligned with the EVM API family.

How to navigate the EVM catalog

  1. Start with the global Dataset Index to see every published dataset.
  2. Use the category links below to drill into dataset pages by use case.
  3. Use _tracing_id and _parent_tracing_ids on each row for lineage joins across tables.

Categories (by use case)

Ledger & execution primitives

Blocks, transactions, logs, internal traces, contract deployments, and function call results.

Tokens & pools

Token registries (ERC-20/721/1155), pool inventory, and pool fee terms.

Transfers

Native and token transfer events.

Reserves

Pool liquidity snapshots and optional per-snapshot tick/bin/range detail rows.

Swaps

Per-swap fee accounting alongside swap prints for realized execution prices.

Pricing

Swap prints, OHLC and VWAP time buckets (token-to-token), and token-to-USD VWAP.

Flash loans

Flash loan borrow/repay prints across major DEX protocols.

Yields & ROI

Pool yield and ROI predictions across fixed horizons.

TVL

Pool total value locked in USD.

Arbitrage

Path definitions, status events, and opportunity snapshots.

How to work with the catalog

  1. Use the Dataset Index for IDs and table names.
  2. Read dataset pages for primary keys, column semantics, and indexes.
  3. See Delivery options for archives, REST, and WebSocket access.
Last modified on March 21, 2026