Skip to main content

DatasetId Enumeration

Defines the canonical dataset identifiers used across Historic API and WebSocket payloads (e.g., the dataset / dataset_id field). Each identifier maps to a documented REST endpoint and Postgres table in blockdb_evm. Prefix indicates the functional domain:
  • 01xx — base chain primitives (blocks, transactions, logs, internal traces, contracts, function results)
  • 02xx — token and pool metadata (ERC-20/721/1155, pools, fee terms)
  • 03xx — reserves, swap prints, swap fees, transfers, flash loans
  • 04xx — token-to-token OHLC and VWAP time buckets
  • 05xx — token-to-fiat (USD) VWAP
  • 06xx — pool TVL in USD
  • 07xx — arbitrage path definitions and status (0702 is the path-status companion table from the same DDL file as 0701)
  • 08xx — arbitrage opportunities
ValueTableDescriptionNotes
0101blockdb_evm.b0101_blocks_v1Canonical block headers and integrity metadata.POST /evm/raw/blocks
0102blockdb_evm.b0102_transactions_v1Executed transactions with gas, status, and calldata.POST /evm/raw/transactions
0103blockdb_evm.b0103_logs_v1Event logs emitted by smart contracts.POST /evm/raw/logs
0111blockdb_evm.b0111_internal_transactions_v1Internal transactions (call traces).POST /evm/raw/internal-transactions
0121blockdb_evm.b0121_contracts_v1Contract deployments (CREATE/CREATE2), keyed by contract_id.POST /evm/raw/contracts
0122blockdb_evm.b0122_function_results_v1Contract call return values versioned by block.POST /evm/raw/function-results
0201blockdb_evm.b0201_erc20_tokens_v1ERC-20 token metadata.POST /evm/tokens/erc20
0202blockdb_evm.b0202_erc721_tokens_v1ERC-721 collection metadata.POST /evm/tokens/erc721
0203blockdb_evm.b0203_erc1155_tokens_v1ERC-1155 contract metadata.POST /evm/tokens/erc1155
0211blockdb_evm.b0211_liquidity_pools_v1Liquidity pool registry.POST /evm/pools
0212blockdb_evm.b0212_liquidity_pools_fee_terms_v1Versioned pool fee terms.POST /evm/pools/fee-terms
0301blockdb_evm.b0301_liquidity_pools_reserves_v1Pool reserve / state snapshots. Companion details: b0301_liquidity_pools_reserves_details_v1 (join on snapshot_id = _tracing_id).POST /evm/reserves
0302blockdb_evm.b0302_token_to_token_prices_swap_prints_v1Executed swap prints (realized prices).POST /evm/prices/spot/crypto/prints
0303blockdb_evm.b0303_liquidity_pools_swap_fees_v1Per-swap fee accounting.POST /evm/swaps/fees
0304blockdb_evm.b0304_token_transfers_v1Token transfers (native, ERC-20/721/1155).POST /evm/transfers/token-transfers
0305blockdb_evm.b0305_flash_loan_prints_v1Flash loan borrow/repay prints.POST /evm/flash-loans/prints
0404blockdb_evm.b0404_token_to_token_prices_ohlc_v1Time-bucketed OHLC per pool and direction.POST /evm/prices/spot/crypto/ohlc
0405blockdb_evm.b0405_token_to_token_vwap_v1Time-bucketed token-to-token VWAP.POST /evm/prices/spot/crypto/vwap
0411blockdb_evm.b0411_liquidity_pools_yields_v1Pool yield / ROI predictions.POST /evm/yields
0501blockdb_evm.b0501_token_to_fiat_vwapToken-to-USD VWAP time buckets.POST /evm/prices/spot/fiat/vwap
0601blockdb_evm.b0601_liquidity_pools_tvl_usd_v1Pool TVL snapshots in USD.POST /evm/tvl
0701blockdb_evm.b0701_arb_paths_v1Arbitrage path definitions (topology).POST /evm/arb/paths
0702blockdb_evm.b0701_arb_path_status_v1Path active/inactive status events. Same DDL source file as 0701.POST /evm/arb/path-status
0801blockdb_evm.b0801_arb_opportunities_v1Arbitrage opportunities per path and position.POST /evm/arb/opportunities

Usage Notes

  • Responses that expose a dataset field use one of the identifiers above (or the full table name, e.g. blockdb_evm.b0201_erc20_tokens_v1).
  • New datasets follow the same prefix scheme; clients should tolerate unknown IDs to remain forward compatible.
  • Use this enumeration to drive UI labels and access control lists rather than hardcoding endpoint prefixes.
Last modified on March 21, 2026