config.yaml

datasets:
  - description: "Events derived from the Beacon API event stream"
    name: "Beacon API Event Stream"
    tables:
      prefix: beacon_api_
    availability:
      - public
      - ethpandaops-clickhouse
  - name: "Execution Layer P2P"
    description: "Events from the execution layer p2p network"
    tables:
      prefix: mempool_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: "Canonical Beacon"
    description: "Events derived from the finalized beacon chain"
    tables:
      prefix: canonical_beacon_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: "Canonical Execution"
    description: "Data extracted from the execution layer"
    tables:
      prefix: canonical_execution_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: "Consensus Layer P2P"
    description: "Events from the consensus layer p2p network"
    tables:
      prefix: libp2p_
    availability:
      - ethpandaops-clickhouse
      - public
  - name: "MEV Relay"
    description: "Events derived from MEV relays"
    tables:
      prefix: mev_relay_
    availability:
      - public
      - 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-05"
        to: "2024-12-01"
      holesky:
        from: "2023-12-25"
        to: "2024-12-01"
      sepolia:
        from: "2023-12-24"
        to: "2024-12-01"
    tags:
      - Consensus layer
    quirks: >-
      Sometimes sentries may [publish different committees](https://github.com/ethpandaops/xatu/issues/288) for the same epoch.
  - 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-05"
        to: "2024-12-01"
      holesky:
        from: "2023-09-29"
        to: "2024-12-01"
      sepolia:
        from: "2023-09-01"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - 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: "2024-12-01"
      holesky:
        from: "2024-02-07"
        to: "2024-12-01"
      sepolia:
        from: "2024-01-30"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - name: beacon_api_eth_v1_events_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2023-02-28"
        to: "2024-12-01"
      holesky:
        from: "2023-12-24"
        to: "2024-12-01"
      sepolia:
        from: "2023-12-24"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - 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: "2024-12-01"
      holesky:
        from: "2024-02-05"
        to: "2024-12-01"
      sepolia:
        from: "2024-05-23"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - 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: "2024-12-01"
      holesky:
        from: "2023-12-24"
        to: "2024-12-01"
      sepolia:
        from: "2023-12-24"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - 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: "2023-04-10"
        to: "2024-12-01"
      holesky:
        from: "2023-03-26"
        to: "2024-12-01"
      sepolia:
        from: "2023-03-26"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - name: beacon_api_eth_v1_events_head
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2023-08-30"
        to: "2024-12-01"
      holesky:
        from: "2023-12-05"
        to: "2024-12-01"
      sepolia:
        from: "2023-12-05"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - 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: "2024-11-30"
      holesky:
        from: "2023-10-01"
        to: "2024-11-30"
      sepolia:
        from: "2023-10-01"
        to: "null"
    tags:
      - Consensus layer
  - 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: "2024-11-30"
      holesky:
        from: "2023-12-24"
        to: "2024-11-30"
      sepolia:
        from: "2023-12-24"
        to: "2024-11-30"
    tags:
      - Consensus layer
  - name: beacon_api_eth_v2_beacon_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2023-11-14"
        to: "2024-11-30"
      holesky:
        from: "2023-12-24"
        to: "2024-11-30"
      sepolia:
        from: "2023-12-24"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - name: mempool_transaction
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: event_date_time
      interval: daily
    networks:
      mainnet:
        from: "2023-07-22"
        to: "2024-11-30"
      holesky:
        from: "2024-01-08"
        to: "2024-11-30"
      sepolia:
        from: "2024-01-08"
        to: "2024-11-30"
    tags:
      - Execution layer
      - Transaction
      - Mempool
  - 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: "2024-12-01"
      holesky:
        from: "2024-04-03"
        to: "2024-11-30"
      sepolia:
        from: "2024-04-03"
        to: "2024-11-30"
    tags:
      - Consensus layer
  - 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: "2024-12-01"
      holesky:
        from: "2024-11-25"
        to: "2024-12-01"
      sepolia:
        from: "2024-11-25"
        to: "2024-12-01"
    tags:
      - Consensus layer
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-20"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-20"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "null"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "null"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-28"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2023-02-28"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2024-02-07"
        to: "2024-11-20"
      sepolia:
        from: "2024-01-30"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-20"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-20"
      holesky:
        from: "2023-09-23"
        to: "2024-11-20"
      sepolia:
        from: "2022-06-22"
        to: "2024-11-20"
    tags:
      - Consensus layer
      - Finalized
  - 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: "2024-11-30"
      holesky:
        from: "2024-05-01"
        to: "2024-11-30"
      sepolia:
        from: "2024-05-01"
        to: "2024-11-30"
    tags:
      - Consensus layer
      - P2P
  - name: libp2p_gossipsub_beacon_block
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2024-04-26"
        to: "2024-11-30"
      holesky:
        from: "2024-04-26"
        to: "2024-11-30"
      sepolia:
        from: "2024-04-26"
        to: "2024-11-30"
    tags:
      - Consensus layer
      - P2P
  - name: libp2p_gossipsub_blob_sidecar
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2024-06-04"
        to: "2024-11-30"
      holesky:
        from: "2024-06-04"
        to: "2024-12-01"
      sepolia:
        from: "2024-06-04"
        to: "2024-11-30"
    tags:
      - Consensus layer
      - P2P
  - name: mev_relay_bid_trace
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2024-09-16"
        to: "2024-11-30"
      holesky:
        from: "2024-09-16"
        to: "2024-11-30"
      sepolia:
        from: "2024-09-16"
        to: "2024-11-30"
  - name: mev_relay_proposer_payload_delivered
    database: default
    excluded_columns: []
    partitioning:
      type: datetime
      column: slot_start_date_time
      interval: daily
    networks:
      mainnet:
        from: "2024-09-16"
        to: "2024-11-30"
      holesky:
        from: "2024-09-16"
        to: "2024-11-30"
      sepolia:
        from: "2024-09-16"
        to: "2024-11-30"
    tags:
      - Consensus layer
      - Execution layer
      - MEV
  - name: canonical_execution_block
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2786000"
      sepolia:
        from: "0"
        to: "7136000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_transaction
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7145000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_traces
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_logs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2786000"
      sepolia:
        from: "0"
        to: "7137000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_contracts
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_four_byte_counts
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2786000"
      sepolia:
        from: "0"
        to: "7136000"
    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).
  - name: canonical_execution_address_appearances
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_balance_diffs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_balance_reads
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    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).
  - name: canonical_execution_erc20_transfers
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2786000"
      sepolia:
        from: "0"
        to: "7137000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_erc721_transfers
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2786000"
      sepolia:
        from: "0"
        to: "7137000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_native_transfers
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_nonce_diffs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7145000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_nonce_reads
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    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).
  - name: canonical_execution_storage_diffs
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      mainnet:
        from: "0"
        to: "21282000"
      holesky:
        from: "0"
        to: "2790000"
      sepolia:
        from: "0"
        to: "7144000"
    tags:
      - Execution layer
      - Finalized
  - name: canonical_execution_storage_reads
    database: default
    excluded_columns: []
    partitioning:
      type: integer
      column: block_number
      interval: 1000
    networks:
      # mainnet:
      #   from: "0"
      #   to: "20967000"
      holesky:
        from: "0"
        to: "2791000"
      sepolia:
        from: "0"
        to: "7146000"
    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).