config.yaml

datasets:
  - name: Beacon API Event Stream
    description: Events derived from the Beacon API event stream. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances. These tables are usually fairly slim and contain only a few columns. These tables can be joined with the canonical tables to get a more complete view of the data. For example, you can join the beacon_api_eth_v1_events_block table on block_root or slot with the canonical_beacon_block table to get the block data for each block.
    tables:
      prefix: beacon_api_
    availability:
      - public
      - ethpandaops-clickhouse
  - name: Execution Layer P2P
    description: Events from the execution layer p2p network. This data is usually useful for 'timing' events, such as when a transaction was seen in the mempool by an instance. Because of this it usually has the same data but from many different instances.
    tables:
      prefix: mempool_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: Canonical Beacon
    description: Events derived from the finalized beacon chain. This data is only derived by a single instance, are deduped, and are more complete and reliable than the beacon_api_ tables. These tables can be reliably JOINed on to hydrate other tables with information
    tables:
      prefix: canonical_beacon_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: Canonical Execution
    description: Data extracted from the execution layer. This data is only derived by a single instance, are deduped, and are more complete and reliable than the execution_layer_p2p tables. These tables can be reliably JOINed on to hydrate other tables with information
    tables:
      prefix: canonical_execution_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: Consensus Layer P2P
    description: Events from the consensus layer p2p network. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances.
    additional_info: "The libp2p dataset captures peer-to-peer network events from the consensus layer, however due to the large volume of network traffic, data is sampled using a sharding strategy. This ensures manageable data sizes while maintaining significance. Not all events are captured - the sampling rate varies by event type and topic, with high-volume topics being more aggressively sampled.\n\n## Event Categorization\n\nEvents are categorized into four groups based on their available sharding keys:\n\n### Group A: Topic + MsgID Events\nEvents with both topic and message ID, enabling full sharding flexibility:\n- `PUBLISH_MESSAGE`, `DELIVER_MESSAGE`, `DUPLICATE_MESSAGE`, `REJECT_MESSAGE`\n- `GOSSIPSUB_BEACON_BLOCK`, `GOSSIPSUB_BEACON_ATTESTATION`, `GOSSIPSUB_BLOB_SIDECAR`\n- `RPC_META_MESSAGE`, `RPC_META_CONTROL_IHAVE`\n\n**Sharding**: Uses message ID for sharding, with topic-based configuration\n\n### Group B: Topic-Only Events\nEvents with only topic information:\n- `JOIN`, `LEAVE`, `GRAFT`, `PRUNE`\n- `RPC_META_CONTROL_GRAFT`, `RPC_META_CONTROL_PRUNE`, `RPC_META_SUBSCRIPTION`\n\n**Sharding**: Uses topic hash for sharding decisions\n\n### Group C: MsgID-Only Events\nEvents with only message ID:\n- `RPC_META_CONTROL_IWANT`, `RPC_META_CONTROL_IDONTWANT`\n\n**Sharding**: Uses message ID with default configuration\n\n### Group D: No Sharding Key Events\nEvents without sharding keys:\n- `ADD_PEER`, `REMOVE_PEER`, `CONNECTED`, `DISCONNECTED`\n- `RECV_RPC`, `SEND_RPC`, `DROP_RPC` (parent events only)\n- `HANDLE_METADATA`, `HANDLE_STATUS`\n\n**Sharding**: All-or-nothing based on configuration\n\n### Sharding Decision Flow\n```\n┌─────────────┐\n│Event Arrives│\n└──────┬──────┘\n       │\n       ▼\n┌──────────────┐     ┌─────────────────┐\n│Get Event Info├────►│ Event Category? │\n└──────────────┘     └────────┬────────┘\n                              │\n        ┌─────────────────────┼─────────────────────┬─────────────────────┐\n        ▼                     ▼                     ▼                     ▼\n   ┌─────────┐         ┌─────────┐           ┌─────────┐           ┌─────────┐\n   │ Group A │         │ Group B │           │ Group C │           │ Group D │\n   │Topic+Msg│         │Topic Only│          │Msg Only │           │ No Keys │\n   └────┬────┘         └────┬────┘           └────┬────┘           └────┬────┘\n        │                   │                     │                     │\n        ▼                   ▼                     ▼                     ▼\n   Topic Config?       Topic Config?         Default Shard         Enabled?\n        │                   │                     │                     │\n     Yes/No              Yes/No                   │                  Yes/No\n        │                   │                     │                     │\n        ▼                   ▼                     ▼                     ▼\n   Shard by Msg       Shard by Topic        Shard by Msg         Process/Drop\n```\n"
    tables:
      prefix: libp2p_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: MEV Relay
    description: Events derived from MEV relays. Data is scraped from multiple MEV Relays by multiple instances.
    tables:
      prefix: mev_relay_
    availability:
      - public
      - ethpandaops-clickhouse
  - name: CBT (ClickHouse Build Tools)
    description: Pre-aggregated analytical tables for common blockchain queries. These tables are transformation tables similar to DBT, powered by [xatu-cbt](https://github.com/ethpandaops/xatu-cbt) using [ClickHouse Build Tools (CBT)](https://github.com/ethpandaops/cbt).
    additional_info: 'CBT tables are organized by network-specific databases. To query these tables, you must target the correct database for your network:

      - `mainnet.table_name` for Mainnet data

      - `sepolia.table_name` for Sepolia data

      - `holesky.table_name` for Holesky data

      - `hoodi.table_name` for Hoodi data


      Unlike other Xatu datasets, CBT tables do not use `meta_network_name` for filtering. The network is determined by the database you query.


      CBT tables include dimension tables (prefixed with `dim_`), fact tables (prefixed with `fct_`), and intermediate tables (prefixed with `int_`).

'
    tables:
      prefix: ''
    availability:
      - ethpandaops-clickhouse
tables:
  - name: beacon_api_eth_v1_beacon_committee
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: hourly
    networks:
      mainnet:
        from: '2023-09-04'
        to: '2026-04-29'
      holesky:
        from: '2023-09-28'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-25'
        to: '2026-04-29'
    tags:
      - Consensus layer
    quirks: Sometimes sentries may [publish different committees](https://github.com/ethpandaops/xatu/issues/288) for the same epoch.
    description: Contains beacon API /eth/v1/beacon/states/{state_id}/committees data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_attestation
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: hourly
    networks:
      mainnet:
        from: '2023-06-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-18'
        to: '2025-11-17'
      sepolia:
        from: '2023-08-31'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "attestation" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_blob_sidecar
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-03-13'
        to: '2025-12-09'
      holesky:
        from: '2024-02-07'
        to: '2025-11-03'
      sepolia:
        from: '2024-01-30'
        to: '2025-10-20'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "blob_sidecar" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2020-12-02'
        to: '2026-04-29'
      sepolia:
        from: '2023-12-24'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "block" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_block_gossip
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-14'
        to: '2026-04-29'
      holesky:
        from: '2025-05-14'
        to: '2025-11-22'
      sepolia:
        from: '2025-05-14'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "block_gossip" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_chain_reorg
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2023-03-01'
        to: '2026-04-29'
      holesky:
        from: '2024-02-05'
        to: '2026-04-29'
      sepolia:
        from: '2023-12-30'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "chain reorg" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_contribution_and_proof
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: contribution_slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2023-08-31'
        to: '2026-04-29'
      holesky:
        from: '2023-12-24'
        to: '2025-10-26'
      sepolia:
        from: '2023-12-24'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "contribution and proof" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_data_column_sidecar
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-12-03'
        to: '2026-04-29'
      holesky:
        from: '2025-10-01'
        to: '2025-11-09'
      hoodi:
        from: '2025-10-28'
        to: '2026-04-29'
      sepolia:
        from: '2025-10-14'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "data_column_sidecar" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_finalized_checkpoint
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: epoch_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-03-26'
        to: '2026-04-29'
      sepolia:
        from: '2023-03-26'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "finalized checkpoint" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_head
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-12-05'
        to: '2026-04-29'
      sepolia:
        from: '2023-12-05'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "head" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_events_voluntary_exit
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: wallclock_epoch_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-28'
        to: '2025-08-12'
      sepolia:
        from: '2023-10-01'
        to: 'null'
    tags:
      - Consensus layer
    description: Contains beacon API eventstream "voluntary exit" data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v1_validator_attestation_data
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2023-08-31'
        to: '2026-04-29'
      holesky:
        from: '2023-12-24'
        to: '2025-10-26'
      sepolia:
        from: '2023-12-24'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API validator attestation data from each sentry client attached to a beacon node.
  - name: beacon_api_eth_v2_beacon_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-28'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-20'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API /eth/v2/beacon/blocks/{block_id} data from each sentry client attached to a beacon node.
  - name: mempool_transaction
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2023-03-03'
        to: '2026-04-29'
      holesky:
        from: '2024-01-08'
        to: '2025-10-26'
      sepolia:
        from: '2024-01-08'
        to: '2026-04-29'
    tags:
      - Execution layer
      - Transaction
      - Mempool
    description: Each row represents a transaction that was seen in the mempool by a sentry client. Sentries can report the same transaction multiple times if it has been long enough since the last report.
  - name: beacon_api_eth_v1_proposer_duty
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-03'
        to: '2026-04-29'
      holesky:
        from: '2024-04-03'
        to: '2025-10-26'
      sepolia:
        from: '2024-04-03'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains a proposer duty from a beacon block.
  - name: beacon_api_eth_v3_validator_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-11-25'
        to: '2026-04-29'
      holesky:
        from: '2024-11-25'
        to: '2025-10-26'
      sepolia:
        from: '2024-11-25'
        to: '2026-04-29'
    tags:
      - Consensus layer
    description: Contains beacon API /eth/v3/validator/blocks/{slot} data from each sentry client attached to a beacon node.
  - name: canonical_beacon_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-20'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains beacon block from a beacon node.
  - name: canonical_beacon_committee
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-20'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains canonical beacon API /eth/v1/beacon/committees data.
  - name: canonical_beacon_block_attester_slashing
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-06'
      holesky:
        from: '2023-09-23'
        to: '2025-10-03'
      sepolia:
        from: '2022-06-22'
        to: 'null'
    tags:
      - Consensus layer
      - Finalized
    description: Contains attester slashing from a beacon block.
  - name: canonical_beacon_block_proposer_slashing
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2025-04-27'
      holesky:
        from: '2023-09-23'
        to: '2025-04-27'
      sepolia:
        from: '2022-06-22'
        to: 'null'
    tags:
      - Consensus layer
      - Finalized
    description: Contains proposer slashing from a beacon block.
  - name: canonical_beacon_block_bls_to_execution_change
    database: default
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    excluded_columns: []
    networks:
      mainnet:
        from: '2023-04-12'
        to: '2026-04-29'
      holesky:
        from: '2023-09-28'
        to: '2025-05-09'
      sepolia:
        from: '2022-06-22'
        to: '2025-05-16'
    tags:
      - Consensus layer
      - Finalized
    description: Contains bls to execution change from a beacon block.
  - name: canonical_beacon_block_execution_transaction
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2022-09-06'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains execution transaction from a beacon block.
  - name: canonical_beacon_block_voluntary_exit
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-08-06'
      sepolia:
        from: '2022-06-22'
        to: '2025-10-22'
    tags:
      - Consensus layer
      - Finalized
    description: Contains a voluntary exit from a beacon block.
  - name: canonical_beacon_block_deposit
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2025-05-14'
      holesky:
        from: '2023-09-23'
        to: '2025-04-27'
      sepolia:
        from: '2022-06-22'
        to: '2025-04-27'
    tags:
      - Consensus layer
      - Finalized
    description: Contains a deposit from a beacon block.
  - name: canonical_beacon_block_withdrawal
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2023-04-12'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2023-02-28'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains a withdrawal from a beacon block.
  - name: canonical_beacon_blob_sidecar
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-03-13'
        to: '2026-04-29'
      holesky:
        from: '2024-02-07'
        to: '2025-10-15'
      sepolia:
        from: '2024-01-30'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains a blob sidecar from a beacon block.
  - name: canonical_beacon_proposer_duty
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-20'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains a proposer duty from a beacon block.
  - name: canonical_beacon_elaborated_attestation
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-20'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Finalized
    description: Contains elaborated attestations from beacon blocks.
  - name: canonical_beacon_validators
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: epoch_start_date_time
      interval: hourly
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2023-09-23'
        to: '2025-10-26'
      sepolia:
        from: '2022-06-20'
        to: '2026-04-28'
    tags:
      - Consensus layer
      - Finalized
    description: Contains a validator state for an epoch.
  - name: canonical_beacon_validators_pubkeys
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: index
      interval: 50
    networks:
      mainnet:
        from: '0'
        to: '2265250'
      holesky:
        from: '0'
        to: '1923800'
      sepolia:
        from: '0'
        to: '1900'
    tags:
      - Consensus layer
      - Finalized
    quirks: A new parquet file is only created once there is 50 new validator index's assigned and finalized. Also available in chunks of 10,000.
    description: Contains a validator state for an epoch.
  - name: libp2p_gossipsub_beacon_attestation
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: hourly
    networks:
      mainnet:
        from: '2024-05-01'
        to: '2026-04-29'
      holesky:
        from: '2024-05-01'
        to: '2025-10-26'
      sepolia:
        from: '2024-05-01'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p gossipsub beacon attestation data.
  - name: libp2p_gossipsub_beacon_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2024-04-26'
        to: '2025-10-26'
      sepolia:
        from: '2024-04-26'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p gossipsub beacon block data.
  - name: libp2p_gossipsub_blob_sidecar
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2025-12-09'
      holesky:
        from: '2024-06-03'
        to: '2025-10-07'
      sepolia:
        from: '2024-06-03'
        to: '2025-10-20'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p gossipsub blob sidecar data
  - name: libp2p_gossipsub_data_column_sidecar
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-12-03'
        to: '2026-04-29'
      holesky:
        from: '2025-10-01'
        to: '2025-10-26'
      hoodi:
        from: '2025-10-28'
        to: '2026-04-29'
      sepolia:
        from: '2025-10-14'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p gossipsub data column sidecar data.
  - name: libp2p_gossipsub_aggregate_and_proof
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-07-11'
        to: '2026-04-29'
      holesky:
        from: '2025-07-11'
        to: '2025-10-26'
      sepolia:
        from: '2025-07-11'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p gossipsub aggregate and proof attestation data
  - name: libp2p_connected
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-24'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-04-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p connected events
  - name: libp2p_disconnected
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-24'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-04-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p disconnected events
  - name: libp2p_add_peer
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-24'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-04-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p add peer events
  - name: libp2p_remove_peer
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-24'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-04-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p remove peer events
  - name: libp2p_recv_rpc
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p recv rpc events
  - name: libp2p_send_rpc
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p send rpc events
  - name: libp2p_drop_rpc
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-30'
        to: '2026-04-17'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p drop rpc events
  - name: libp2p_join
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-05-01'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-05-01'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p join events
  - name: libp2p_leave
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-06-01'
        to: '2026-04-29'
      hoodi:
        from: '2025-06-01'
        to: '2025-06-01'
      sepolia:
        from: '2025-06-01'
        to: '2025-06-01'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p leave events
  - name: libp2p_graft
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p graft events
  - name: libp2p_prune
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p prune events
  - name: libp2p_duplicate_message
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p duplicate message events
  - name: libp2p_deliver_message
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p deliver message events
  - name: libp2p_handle_metadata
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-24'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-04-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p handle metadata events
  - name: libp2p_handle_status
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-04-24'
        to: '2026-04-29'
      hoodi:
        from: '2025-03-17'
        to: '2026-04-29'
      sepolia:
        from: '2024-04-22'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p handle status events
  - name: libp2p_rpc_meta_control_ihave
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta control ihave events
  - name: libp2p_rpc_meta_control_iwant
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta control iwant events
  - name: libp2p_rpc_meta_control_idontwant
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta control idontwant events
  - name: libp2p_rpc_meta_control_graft
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta control graft events
  - name: libp2p_rpc_meta_control_prune
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-07-02'
        to: '2026-04-29'
      hoodi:
        from: '2025-06-23'
        to: '2026-04-29'
      sepolia:
        from: '2025-06-23'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta control prune events
  - name: libp2p_rpc_meta_subscription
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta subscription events
  - name: libp2p_rpc_meta_message
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-05-30'
        to: '2026-04-29'
      hoodi:
        from: '2025-05-29'
        to: '2026-04-29'
      sepolia:
        from: '2025-05-29'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p rpc meta message events
  - name: mev_relay_bid_trace
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-09-13'
        to: '2026-04-29'
      holesky:
        from: '2024-09-13'
        to: '2025-10-26'
      sepolia:
        from: '2024-09-13'
        to: '2026-04-29'
    description: Contains MEV relay block bids data.
  - name: mev_relay_proposer_payload_delivered
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2020-12-01'
        to: '2026-04-29'
      holesky:
        from: '2024-09-16'
        to: '2025-08-17'
      sepolia:
        from: '2024-09-16'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Execution layer
      - MEV
    description: Contains MEV relay proposer payload delivered data.
  - name: mev_relay_validator_registration
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2024-12-11'
        to: '2026-04-29'
      holesky:
        from: '2024-12-11'
        to: '2025-04-27'
      sepolia:
        from: '2024-12-11'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - Execution layer
      - MEV
    description: Contains MEV relay validator registrations data.
  - name: canonical_execution_block
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution block data.
  - name: canonical_execution_transaction
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution transaction data.
  - name: canonical_execution_traces
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '9569000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution traces data.
  - name: canonical_execution_logs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution logs data.
  - name: canonical_execution_contracts
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution contract data.
  - name: canonical_execution_four_byte_counts
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    quirks: Holesky is currently stuck at block `2402609`, waiting for reth release including the [fix](https://github.com/paradigmxyz/reth/issues/11272).
    description: Contains canonical execution four byte count data.
  - name: canonical_execution_address_appearances
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4659000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution address appearance data.
  - name: canonical_execution_balance_diffs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution balance diff data.
  - name: canonical_execution_balance_reads
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4652000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    quirks: Holesky is currently stuck at block `2402609`, waiting for reth release including the [fix](https://github.com/paradigmxyz/reth/issues/11272).
    description: Contains canonical execution balance read data.
  - name: canonical_execution_erc20_transfers
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution erc20 transfer data.
  - name: canonical_execution_erc721_transfers
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution erc721 transfer data.
  - name: canonical_execution_native_transfers
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution native transfer data.
  - name: canonical_execution_nonce_diffs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution nonce diff data.
  - name: canonical_execution_nonce_reads
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4657000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    quirks: Holesky is currently stuck at block `2402609`, waiting for reth release including the [fix](https://github.com/paradigmxyz/reth/issues/11272).
    description: Contains canonical execution nonce read data.
  - name: canonical_execution_storage_diffs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: '0'
        to: '24988000'
      holesky:
        from: '0'
        to: '4710000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution storage diffs data.
  - name: canonical_execution_storage_reads
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      holesky:
        from: '0'
        to: '4652000'
      sepolia:
        from: '0'
        to: '10073000'
    tags:
      - Execution layer
      - Finalized
    quirks: Mainnet is currently back-filling and not yet available publicly. Holesky is currently stuck at block `2402609`, waiting for reth release including the [fix](https://github.com/paradigmxyz/reth/issues/11272).
    description: Contains canonical execution storage reads data.
  - name: canonical_execution_transaction_structlog
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 100
    networks:
      mainnet:
        from: '22731300'
        to: '24294300'
    tags:
      - Execution layer
      - Finalized
    description: Contains canonical execution transaction structlog data from [`debug_traceTransaction`](https://geth.ethereum.org/docs/interacting-with-geth/rpc/ns-debug#debugtracetransaction).
  - name: canonical_execution_transaction_structlog_agg
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 100
    networks:
      mainnet:
        from: null
        to: null
    tags:
      - Execution layer
      - Finalized
    description: Contains aggregated canonical execution transaction structlog data from [`debug_traceTransaction`](https://geth.ethereum.org/docs/interacting-with-geth/rpc/ns-debug#debugtracetransaction).
  - name: consensus_engine_api_get_blobs
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-12-09'
        to: '2026-01-07'
    tags:
      - Consensus layer
      - Engine API
    description: Contains consensus engine API getBlobsV1 request data from each sentry client.
  - name: consensus_engine_api_new_payload
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-12-09'
        to: '2026-01-07'
    tags:
      - Consensus layer
      - Engine API
    description: Contains consensus engine API newPayload request data from each sentry client.
  - name: libp2p_rpc_data_column_custody_probe
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-12-03'
        to: '2026-04-29'
      hoodi:
        from: '2025-12-03'
        to: '2026-04-29'
      sepolia:
        from: '2025-12-03'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p RPC data column custody probe events.
  - name: libp2p_identify
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2026-02-23'
      hoodi:
        from: '2026-02-23'
      sepolia:
        from: '2026-02-23'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p identify events containing peer identification data including agent version, protocols, and connection metadata.
  - name: libp2p_synthetic_heartbeat
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-08-21'
        to: '2026-04-29'
      holesky:
        from: '2025-09-29'
        to: '2025-10-20'
      hoodi:
        from: '2025-08-21'
        to: '2026-04-29'
      sepolia:
        from: '2025-08-21'
        to: '2026-04-29'
    tags:
      - Consensus layer
      - P2P
    description: Table for libp2p synthetic heartbeat events.
  - name: node_record_consensus
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-07-25'
        to: '2026-01-07'
      hoodi:
        from: '2025-07-25'
        to: '2025-12-16'
      sepolia:
        from: '2025-07-25'
        to: '2026-01-07'
    tags:
      - Consensus layer
      - Node Discovery
    description: Contains consensus layer node records from discv5 discovery.
  - name: node_record_execution
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: '2025-07-25'
        to: '2026-01-07'
      hoodi:
        from: '2025-07-25'
        to: '2025-12-16'
      sepolia:
        from: '2025-07-25'
        to: '2026-01-07'
    tags:
      - Execution layer
      - Node Discovery
    description: Contains execution layer node records from discv4/discv5 discovery.
  - name: execution_state_size
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 5000000
    networks:
      mainnet:
        from: '98326'
        to: '24185815'
      hoodi:
        from: '1571382'
        to: '9751275'
      sepolia:
        from: '9578000'
        to: '9999120'
    tags:
      - Execution layer
    description: Contains execution layer state size metrics per block.
  - name: execution_transaction
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 5000000
    networks:
      mainnet:
        from: '23194617'
        to: '24185815'
      hoodi:
        from: '1736843'
        to: '1831171'
      sepolia:
        from: '9009762'
        to: '9800850'
    tags:
      - Execution layer
      - Transaction
    description: Contains execution layer transaction data.