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
- Start with the global Dataset Index to see every published dataset.
- Use the category links below to drill into dataset pages by use case.
- Use
_tracing_idand_parent_tracing_idson 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
- Use the Dataset Index for IDs and table names.
- Read dataset pages for primary keys, column semantics, and indexes.
- See Delivery options for archives, REST, and WebSocket access.