Skip to main content

Xatu - Schema

This dataset contains a wealth of information about the Ethereum network, including detailed data on beacon chain events, mempool activity, and canonical chain events. Read more in our announcement post.
Xatu data is licensed under CC BY 4.0

Tables
#

beacon_api_eth_v1_beacon_committee
#

Contains beacon API /eth/v1/beacon/states/{state_id}/committees data from each sentry client attached to a beacon node.
Sometimes sentries may publish different committees for the same epoch.

Availability
#

Data is partitioned hourly on slot_start_date_time for the following networks:

  • mainnet: 2023-09-05 to 2024-06-14
  • holesky: 2023-12-25 to 2024-06-14
  • sepolia: 2023-12-24 to 2024-06-14

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_beacon_committee/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_beacon_committee/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 Slot number in the beacon API committee payload
slot_start_date_time DateTime The wall clock time when the slot started
committee_index LowCardinality(String) The committee index in the beacon API committee payload
validators Array(UInt32) The validator indices in the beacon API committee payload
epoch UInt32 The epoch number in the beacon API committee payload
epoch_start_date_time DateTime The wall clock time when the epoch started
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_attestation
#

Contains beacon API eventstream “attestation” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned hourly on slot_start_date_time for the following networks:

  • mainnet: 2023-06-05 to 2024-06-14
  • holesky: 2023-09-29 to 2024-06-13
  • sepolia: 2023-09-01 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_attestation/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_attestation/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 Slot number in the beacon API event stream payload
slot_start_date_time DateTime The wall clock time when the slot started
propagation_slot_start_diff UInt32 The difference between the event_date_time and the slot_start_date_time
committee_index LowCardinality(String) The committee index in the beacon API event stream payload
attesting_validator_index Nullable(UInt32) The index of the validator attesting to the event
attesting_validator_committee_index LowCardinality(String) The committee index of the attesting validator
aggregation_bits String The aggregation bits of the event in the beacon API event stream payload
beacon_block_root FixedString(66) The beacon block root hash in the beacon API event stream payload
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
source_epoch UInt32 The source epoch number in the beacon API event stream payload
source_epoch_start_date_time DateTime The wall clock time when the source epoch started
source_root FixedString(66) The source beacon block root hash in the beacon API event stream payload
target_epoch UInt32 The target epoch number in the beacon API event stream payload
target_epoch_start_date_time DateTime The wall clock time when the target epoch started
target_root FixedString(66) The target beacon block root hash in the beacon API event stream payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_blob_sidecar
#

Contains beacon API eventstream “blob_sidecar” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2024-03-13 to 2024-06-13
  • holesky: 2024-02-07 to 2024-06-13
  • sepolia: 2024-01-30 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_blob_sidecar/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_blob_sidecar/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 Slot number in the beacon API event stream payload
slot_start_date_time DateTime The wall clock time when the slot started
propagation_slot_start_diff UInt32 The difference between the event_date_time and the slot_start_date_time
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The beacon block root hash in the beacon API event stream payload
blob_index UInt64 The index of blob sidecar in the beacon API event stream payload
kzg_commitment FixedString(98) The KZG commitment in the beacon API event stream payload
versioned_hash FixedString(66) The versioned hash in the beacon API event stream payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_block
#

Contains beacon API eventstream “block” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-02-28 to 2024-06-13
  • holesky: 2023-12-24 to 2024-06-13
  • sepolia: 2023-12-24 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_block/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_block/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 Slot number in the beacon API event stream payload
slot_start_date_time DateTime The wall clock time when the slot started
propagation_slot_start_diff UInt32 The difference between the event_date_time and the slot_start_date_time
block FixedString(66) The beacon block root hash in the beacon API event stream payload
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
execution_optimistic Bool If the attached beacon node is running in execution optimistic mode
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_chain_reorg
#

Contains beacon API eventstream “chain reorg” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-03-01 to 2024-06-13
  • holesky: 2024-02-05 to 2024-06-13
  • sepolia: 2024-05-23 to 2024-05-23

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_chain_reorg/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_chain_reorg/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 The slot number of the chain reorg event in the beacon API event stream payload
slot_start_date_time DateTime The wall clock time when the reorg slot started
propagation_slot_start_diff UInt32 Difference in slots between when the reorg occurred and when the sentry received the event
depth UInt16 The depth of the chain reorg in the beacon API event stream payload
old_head_block FixedString(66) The old head block root hash in the beacon API event stream payload
new_head_block FixedString(66) The new head block root hash in the beacon API event stream payload
old_head_state FixedString(66) The old head state root hash in the beacon API event stream payload
new_head_state FixedString(66) The new head state root hash in the beacon API event stream payload
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
execution_optimistic Bool Whether the execution of the epoch was optimistic
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_contribution_and_proof
#

Contains beacon API eventstream “contribution and proof” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on contribution_slot_start_date_time for the following networks:

  • mainnet: 2023-08-31 to 2024-06-13
  • holesky: 2023-12-24 to 2024-06-13
  • sepolia: 2023-12-24 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_contribution_and_proof/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_contribution_and_proof/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
aggregator_index UInt32 The validator index of the aggregator in the beacon API event stream payload
contribution_slot UInt32 The slot number of the contribution in the beacon API event stream payload
contribution_slot_start_date_time DateTime The wall clock time when the contribution slot started
contribution_propagation_slot_start_diff UInt32 Difference in slots between when the contribution occurred and when the sentry received the event
contribution_beacon_block_root FixedString(66) The beacon block root hash in the beacon API event stream payload
contribution_subcommittee_index LowCardinality(String) The subcommittee index of the contribution in the beacon API event stream payload
contribution_aggregation_bits String The aggregation bits of the contribution in the beacon API event stream payload
contribution_signature String The signature of the contribution in the beacon API event stream payload
contribution_epoch UInt32 The epoch number of the contribution in the beacon API event stream payload
contribution_epoch_start_date_time DateTime The wall clock time when the contribution epoch started
selection_proof String The selection proof in the beacon API event stream payload
signature String The signature in the beacon API event stream payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_finalized_checkpoint
#

Contains beacon API eventstream “finalized checkpoint” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on epoch_start_date_time for the following networks:

  • mainnet: 2023-04-10 to 2024-06-13
  • holesky: 2023-03-26 to 2024-06-13
  • sepolia: 2023-03-26 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_finalized_checkpoint/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_finalized_checkpoint/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
block FixedString(66) The finalized block root hash in the beacon API event stream payload
state FixedString(66) The finalized state root hash in the beacon API event stream payload
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
execution_optimistic Bool Whether the execution of the epoch was optimistic
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_head
#

Contains beacon API eventstream “head” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-08-30 to 2024-06-13
  • holesky: 2023-12-05 to 2024-06-13
  • sepolia: 2023-12-05 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_head/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_head/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 Slot number in the beacon API event stream payload
slot_start_date_time DateTime The wall clock time when the slot started
propagation_slot_start_diff UInt32 The difference between the event_date_time and the slot_start_date_time
block FixedString(66) The beacon block root hash in the beacon API event stream payload
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
epoch_transition Bool If the event is an epoch transition
execution_optimistic Bool If the attached beacon node is running in execution optimistic mode
previous_duty_dependent_root FixedString(66) The previous duty dependent root in the beacon API event stream payload
current_duty_dependent_root FixedString(66) The current duty dependent root in the beacon API event stream payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_events_voluntary_exit
#

Contains beacon API eventstream “voluntary exit” data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on epoch_start_date_time for the following networks:

  • mainnet: 2024-01-01 to 2024-03-25
  • holesky: 2023-10-01 to 2023-10-06
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_events_voluntary_exit/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_voluntary_exit/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
epoch UInt32 The epoch number in the beacon API event stream payload
epoch_start_date_time DateTime The wall clock time when the epoch started
validator_index UInt32 The index of the validator making the voluntary exit
signature String The signature of the voluntary exit in the beacon API event stream payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_validator_attestation_data
#

Contains beacon API validator attestation data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-08-31 to 2024-06-13
  • holesky: 2023-12-24 to 2024-06-13
  • sepolia: 2023-12-24 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_validator_attestation_data/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_validator_attestation_data/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry received the event from a beacon node
slot UInt32 Slot number in the beacon API validator attestation data payload
slot_start_date_time DateTime The wall clock time when the slot started
committee_index LowCardinality(String) The committee index in the beacon API validator attestation data payload
beacon_block_root FixedString(66) The beacon block root hash in the beacon API validator attestation data payload
epoch UInt32 The epoch number in the beacon API validator attestation data payload
epoch_start_date_time DateTime The wall clock time when the epoch started
source_epoch UInt32 The source epoch number in the beacon API validator attestation data payload
source_epoch_start_date_time DateTime The wall clock time when the source epoch started
source_root FixedString(66) The source beacon block root hash in the beacon API validator attestation data payload
target_epoch UInt32 The target epoch number in the beacon API validator attestation data payload
target_epoch_start_date_time DateTime The wall clock time when the target epoch started
target_root FixedString(66) The target beacon block root hash in the beacon API validator attestation data payload
request_date_time DateTime When the request was sent to the beacon node
request_duration UInt32 The request duration in milliseconds
request_slot_start_diff UInt32 The difference between the request_date_time and the slot_start_date_time
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v2_beacon_block
#

Contains beacon API /eth/v2/beacon/blocks/{block_id} data from each sentry client attached to a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-11-14 to 2024-06-13
  • holesky: 2023-12-24 to 2024-06-13
  • sepolia: 2023-12-24 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v2_beacon_block/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v2_beacon_block/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) When the sentry fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the reorg slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
block_total_bytes Nullable(UInt32) The total bytes of the beacon block payload
block_total_bytes_compressed Nullable(UInt32) The total bytes of the beacon block payload when compressed using snappy
parent_root FixedString(66) The root hash of the parent beacon block
state_root FixedString(66) The root hash of the beacon state at this block
proposer_index UInt32 The index of the validator that proposed the beacon block
eth1_data_block_hash FixedString(66) The block hash of the associated execution block
eth1_data_deposit_root FixedString(66) The root of the deposit tree in the associated execution block
execution_payload_block_hash FixedString(66) The block hash of the execution payload
execution_payload_block_number UInt32 The block number of the execution payload
execution_payload_fee_recipient String The recipient of the fee for this execution payload
execution_payload_state_root FixedString(66) The state root of the execution payload
execution_payload_parent_hash FixedString(66) The parent hash of the execution payload
execution_payload_transactions_count Nullable(UInt32) The transaction count of the execution payload
execution_payload_transactions_total_bytes Nullable(UInt32) The transaction total bytes of the execution payload
execution_payload_transactions_total_bytes_compressed Nullable(UInt32) The transaction total bytes of the execution payload when compressed using snappy
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

mempool_transaction
#

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.

Availability
#

Data is partitioned daily on event_date_time for the following networks:

  • mainnet: 2023-07-22 to 2024-06-01
  • holesky: 2024-01-08 to 2024-06-01
  • sepolia: 2024-01-08 to 2024-06-01

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/mempool_transaction/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/mempool_transaction/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) The time when the sentry saw the transaction in the mempool
hash FixedString(66) The hash of the transaction
from FixedString(42) The address of the account that sent the transaction
to Nullable(FixedString(42)) The address of the account that is the transaction recipient
nonce UInt64 The nonce of the sender account at the time of the transaction
gas_price UInt128 The gas price of the transaction in wei
gas UInt64 The maximum gas provided for the transaction execution
gas_tip_cap Nullable(UInt128) The priority fee (tip) the user has set for the transaction
gas_fee_cap Nullable(UInt128) The max fee the user has set for the transaction
value UInt128 The value transferred with the transaction in wei
type Nullable(UInt8) The type of the transaction
size UInt32 The size of the transaction data in bytes
call_data_size UInt32 The size of the call data of the transaction in bytes
blob_gas Nullable(UInt64) The maximum gas provided for the blob transaction execution
blob_gas_fee_cap Nullable(UInt128) The max fee the user has set for the transaction
blob_hashes Array(String) The hashes of the blob commitments for blob transactions
blob_sidecars_size Nullable(UInt32) The total size of the sidecars for blob transactions in bytes
blob_sidecars_empty_size Nullable(UInt32) The total empty size of the sidecars for blob transactions in bytes
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_execution_fork_id_hash LowCardinality(String) The hash of the fork ID of the current Ethereum network
meta_execution_fork_id_next LowCardinality(String) The fork ID of the next planned Ethereum network upgrade
meta_labels Map(String, String) Labels associated with the event

beacon_api_eth_v1_proposer_duty
#

Contains a proposer duty from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2024-04-03 to 2024-06-13
  • holesky: 2024-04-03 to 2024-06-13
  • sepolia: 2024-04-03 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/beacon_api_eth_v1_proposer_duty/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_proposer_duty/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
proposer_validator_index UInt32 The validator index from the proposer duty payload
proposer_pubkey String The BLS public key of the validator from the proposer duty payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block
#

Contains beacon block from a beacon node.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2020-12-01 to 2024-06-13
  • holesky: 2023-09-28 to 2024-06-13
  • sepolia: 2022-06-20 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
block_total_bytes Nullable(UInt32) The total bytes of the beacon block payload
block_total_bytes_compressed Nullable(UInt32) The total bytes of the beacon block payload when compressed using snappy
parent_root FixedString(66) The root hash of the parent beacon block
state_root FixedString(66) The root hash of the beacon state at this block
proposer_index UInt32 The index of the validator that proposed the beacon block
eth1_data_block_hash FixedString(66) The block hash of the associated execution block
eth1_data_deposit_root FixedString(66) The root of the deposit tree in the associated execution block
execution_payload_block_hash FixedString(66) The block hash of the execution payload
execution_payload_block_number UInt32 The block number of the execution payload
execution_payload_fee_recipient String The recipient of the fee for this execution payload
execution_payload_state_root FixedString(66) The state root of the execution payload
execution_payload_parent_hash FixedString(66) The parent hash of the execution payload
execution_payload_transactions_count Nullable(UInt32) The transaction count of the execution payload
execution_payload_transactions_total_bytes Nullable(UInt32) The transaction total bytes of the execution payload
execution_payload_transactions_total_bytes_compressed Nullable(UInt32) The transaction total bytes of the execution payload when compressed using snappy
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_attester_slashing
#

Contains attester slashing from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2024-04-11 to 2024-04-11
  • holesky: 2024-05-21 to 2024-05-26
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_attester_slashing/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_attester_slashing/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
attestation_1_attesting_indices Array(UInt32) The attesting indices from the first attestation in the slashing payload
attestation_1_signature String The signature from the first attestation in the slashing payload
attestation_1_data_beacon_block_root FixedString(66) The beacon block root from the first attestation in the slashing payload
attestation_1_data_slot UInt32 The slot number from the first attestation in the slashing payload
attestation_1_data_index UInt32 The attestor index from the first attestation in the slashing payload
attestation_1_data_source_epoch UInt32 The source epoch number from the first attestation in the slashing payload
attestation_1_data_source_root FixedString(66) The source root from the first attestation in the slashing payload
attestation_1_data_target_epoch UInt32 The target epoch number from the first attestation in the slashing payload
attestation_1_data_target_root FixedString(66) The target root from the first attestation in the slashing payload
attestation_2_attesting_indices Array(UInt32) The attesting indices from the second attestation in the slashing payload
attestation_2_signature String The signature from the second attestation in the slashing payload
attestation_2_data_beacon_block_root FixedString(66) The beacon block root from the second attestation in the slashing payload
attestation_2_data_slot UInt32 The slot number from the second attestation in the slashing payload
attestation_2_data_index UInt32 The attestor index from the second attestation in the slashing payload
attestation_2_data_source_epoch UInt32 The source epoch number from the second attestation in the slashing payload
attestation_2_data_source_root FixedString(66) The source root from the second attestation in the slashing payload
attestation_2_data_target_epoch UInt32 The target epoch number from the second attestation in the slashing payload
attestation_2_data_target_root FixedString(66) The target root from the second attestation in the slashing payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_proposer_slashing
#

Contains proposer slashing from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-04-03 to 2023-04-03
  • holesky: 2024-03-26 to 2024-03-26
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_proposer_slashing/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_proposer_slashing/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
signed_header_1_message_slot UInt32 The slot number from the first signed header in the slashing payload
signed_header_1_message_proposer_index UInt32 The proposer index from the first signed header in the slashing payload
signed_header_1_message_body_root FixedString(66) The body root from the first signed header in the slashing payload
signed_header_1_message_parent_root FixedString(66) The parent root from the first signed header in the slashing payload
signed_header_1_message_state_root FixedString(66) The state root from the first signed header in the slashing payload
signed_header_1_signature String The signature for the first signed header in the slashing payload
signed_header_2_message_slot UInt32 The slot number from the second signed header in the slashing payload
signed_header_2_message_proposer_index UInt32 The proposer index from the second signed header in the slashing payload
signed_header_2_message_body_root FixedString(66) The body root from the second signed header in the slashing payload
signed_header_2_message_parent_root FixedString(66) The parent root from the second signed header in the slashing payload
signed_header_2_message_state_root FixedString(66) The state root from the second signed header in the slashing payload
signed_header_2_signature String The signature for the second signed header in the slashing payload
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_bls_to_execution_change
#

Contains bls to execution change from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2024-05-18 to 2024-06-12
  • holesky: 2024-05-25 to 2024-05-25
  • sepolia: 2024-04-08 to 2024-04-08

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_bls_to_execution_change/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_bls_to_execution_change/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
exchanging_message_validator_index UInt32 The validator index from the exchanging message
exchanging_message_from_bls_pubkey String The BLS public key from the exchanging message
exchanging_message_to_execution_address FixedString(42) The execution address from the exchanging message
exchanging_signature String The signature for the exchanging message
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_execution_transaction
#

Contains execution transaction from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2022-09-15 to 2024-06-13
  • holesky: 2023-09-28 to 2024-06-13
  • sepolia: 2022-07-06 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_execution_transaction/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_execution_transaction/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
position UInt32 The position of the transaction in the beacon block
hash FixedString(66) The hash of the transaction
from FixedString(42) The address of the account that sent the transaction
to Nullable(FixedString(42)) The address of the account that is the transaction recipient
nonce UInt64 The nonce of the sender account at the time of the transaction
gas_price UInt128 The gas price of the transaction in wei
gas UInt64 The maximum gas provided for the transaction execution
gas_tip_cap Nullable(UInt128) The priority fee (tip) the user has set for the transaction
gas_fee_cap Nullable(UInt128) The max fee the user has set for the transaction
value UInt128 The value transferred with the transaction in wei
type UInt8 The type of the transaction
size UInt32 The size of the transaction data in bytes
call_data_size UInt32 The size of the call data of the transaction in bytes
blob_gas Nullable(UInt64) The maximum gas provided for the blob transaction execution
blob_gas_fee_cap Nullable(UInt128) The max fee the user has set for the transaction
blob_hashes Array(String) The hashes of the blob commitments for blob transactions
blob_sidecars_size Nullable(UInt32) The total size of the sidecars for blob transactions in bytes
blob_sidecars_empty_size Nullable(UInt32) The total empty size of the sidecars for blob transactions in bytes
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_voluntary_exit
#

Contains a voluntary exit from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-04-02 to 2024-06-13
  • holesky: 2024-02-11 to 2024-06-13
  • sepolia: 2024-03-28 to 2024-03-28

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_voluntary_exit/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_voluntary_exit/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
voluntary_exit_message_epoch UInt32 The epoch number from the exit message
voluntary_exit_message_validator_index UInt32 The validator index from the exit message
voluntary_exit_signature String The signature of the exit message
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_deposit
#

Contains a deposit from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2020-12-01 to 2024-06-13
  • holesky: 2023-09-29 to 2024-06-13
  • sepolia: 2022-07-01 to 2022-07-01

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_deposit/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_deposit/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
deposit_proof Array(String) The proof of the deposit data
deposit_data_pubkey String The BLS public key of the validator from the deposit data
deposit_data_withdrawal_credentials FixedString(66) The withdrawal credentials of the validator from the deposit data
deposit_data_amount UInt128 The amount of the deposit from the deposit data
deposit_data_signature String The signature of the deposit data
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_block_withdrawal
#

Contains a withdrawal from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-04-12 to 2024-06-13
  • holesky: 2023-09-29 to 2024-06-13
  • sepolia: 2023-02-28 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_withdrawal/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_withdrawal/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_version LowCardinality(String) The version of the beacon block
withdrawal_index UInt32 The index of the withdrawal
withdrawal_validator_index UInt32 The validator index from the withdrawal data
withdrawal_address FixedString(42) The address of the account that is the withdrawal recipient
withdrawal_amount UInt128 The amount of the withdrawal from the withdrawal data
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_blob_sidecar
#

Contains a blob sidecar from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2024-03-13 to 2024-06-13
  • holesky: 2024-02-07 to 2024-06-13
  • sepolia: 2024-01-30 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_blob_sidecar/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_blob_sidecar/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the beacon block from a beacon node
slot UInt32 The slot number from beacon block payload
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number from beacon block payload
epoch_start_date_time DateTime The wall clock time when the epoch started
block_root FixedString(66) The root hash of the beacon block
block_parent_root FixedString(66) The root hash of the parent beacon block
versioned_hash FixedString(66) The versioned hash in the beacon API event stream payload
kzg_commitment FixedString(98) The KZG commitment in the blob sidecar payload
kzg_proof FixedString(98) The KZG proof in the blob sidecar payload
proposer_index UInt32 The index of the validator that proposed the beacon block
blob_index UInt64 The index of blob sidecar in the blob sidecar payload
blob_size UInt32 The total bytes of the blob
blob_empty_size Nullable(UInt32) The total empty size of the blob in bytes
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

canonical_beacon_proposer_duty
#

Contains a proposer duty from a beacon block.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2020-12-01 to 2024-06-13
  • holesky: 2023-09-28 to 2024-06-13
  • sepolia: 2022-06-20 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_proposer_duty/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_proposer_duty/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the proposer duty information from a beacon node
slot UInt32 The slot number for which the proposer duty is assigned
slot_start_date_time DateTime The wall clock time when the slot started
epoch UInt32 The epoch number containing the slot
epoch_start_date_time DateTime The wall clock time when the epoch started
proposer_validator_index UInt32 The validator index of the proposer for the slot
proposer_pubkey String The public key of the validator proposer
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the even

canonical_beacon_elaborated_attestation
#

Contains elaborated attestations from beacon blocks.

Availability
#

Data is partitioned daily on slot_start_date_time for the following networks:

  • mainnet: 2023-05-03 to 2024-06-13
  • holesky: 2023-09-28 to 2024-06-13
  • sepolia: 2023-04-05 to 2024-06-13

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_elaborated_attestation/YYYY/MM/DD.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_elaborated_attestation/2024/6/9.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique key for the row generated from seahash
updated_date_time DateTime When this row was last updated
event_date_time DateTime64(3) When the client fetched the elaborated attestation from a beacon node
block_slot UInt32 The slot number of the block containing the attestation
block_slot_start_date_time DateTime The wall clock time when the block slot started
block_epoch UInt32 The epoch number of the block containing the attestation
block_epoch_start_date_time DateTime The wall clock time when the block epoch started
position_in_block UInt32 The position of the attestation in the block
block_root FixedString(66) The root of the block containing the attestation
validators Array(UInt32) Array of validator indices participating in the attestation
committee_index LowCardinality(String) The index of the committee making the attestation
beacon_block_root FixedString(66) The root of the beacon block being attested to
slot UInt32 The slot number being attested to
slot_start_date_time DateTime **
epoch UInt32 **
epoch_start_date_time DateTime **
source_epoch UInt32 The source epoch referenced in the attestation
source_epoch_start_date_time DateTime The wall clock time when the source epoch started
source_root FixedString(66) The root of the source checkpoint in the attestation
target_epoch UInt32 The target epoch referenced in the attestation
target_epoch_start_date_time DateTime The wall clock time when the target epoch started
target_root FixedString(66) The root of the target checkpoint in the attestation
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name
meta_consensus_version LowCardinality(String) Ethereum consensus client version that generated the event
meta_consensus_version_major LowCardinality(String) Ethereum consensus client major version that generated the event
meta_consensus_version_minor LowCardinality(String) Ethereum consensus client minor version that generated the event
meta_consensus_version_patch LowCardinality(String) Ethereum consensus client patch version that generated the event
meta_consensus_implementation LowCardinality(String) Ethereum consensus client implementation that generated the event
meta_labels Map(String, String) Labels associated with the event

libp2p_add_peer
#

Contains the details of the peers added to the libp2p client.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_add_peer/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_add_peer/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
peer_id_unique_key Int64 Unique key associated with the identifier of the peer
protocol LowCardinality(String) Protocol used by the peer
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_connected
#

Contains the details of the CONNECTED events from the libp2p client.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_connected/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_connected/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
remote_peer_id_unique_key Int64 Unique key associated with the identifier of the remote peer
remote_protocol LowCardinality(String) Protocol of the remote peer
remote_transport_protocol LowCardinality(String) Transport protocol of the remote peer
remote_port UInt16 Port of the remote peer
remote_ip Nullable(IPv6) IP address of the remote peer that generated the event
remote_geo_city LowCardinality(String) City of the remote peer that generated the event
remote_geo_country LowCardinality(String) Country of the remote peer that generated the event
remote_geo_country_code LowCardinality(String) Country code of the remote peer that generated the event
remote_geo_continent_code LowCardinality(String) Continent code of the remote peer that generated the event
remote_geo_longitude Nullable(Float64) Longitude of the remote peer that generated the event
remote_geo_latitude Nullable(Float64) Latitude of the remote peer that generated the event
remote_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the remote peer that generated the event
remote_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the remote peer that generated the event
remote_agent_implementation LowCardinality(String) Implementation of the remote peer
remote_agent_version LowCardinality(String) Version of the remote peer
remote_agent_version_major LowCardinality(String) Major version of the remote peer
remote_agent_version_minor LowCardinality(String) Minor version of the remote peer
remote_agent_version_patch LowCardinality(String) Patch version of the remote peer
remote_agent_platform LowCardinality(String) Platform of the remote peer
direction LowCardinality(String) Connection direction
opened DateTime Timestamp when the connection was opened
transient Bool Whether the connection is transient
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_disconnected
#

Contains the details of the DISCONNECTED events from the libp2p client.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_disconnected/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_disconnected/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
remote_peer_id_unique_key Int64 Unique key associated with the identifier of the remote peer
remote_protocol LowCardinality(String) Protocol of the remote peer
remote_transport_protocol LowCardinality(String) Transport protocol of the remote peer
remote_port UInt16 Port of the remote peer
remote_ip Nullable(IPv6) IP address of the remote peer that generated the event
remote_geo_city LowCardinality(String) City of the remote peer that generated the event
remote_geo_country LowCardinality(String) Country of the remote peer that generated the event
remote_geo_country_code LowCardinality(String) Country code of the remote peer that generated the event
remote_geo_continent_code LowCardinality(String) Continent code of the remote peer that generated the event
remote_geo_longitude Nullable(Float64) Longitude of the remote peer that generated the event
remote_geo_latitude Nullable(Float64) Latitude of the remote peer that generated the event
remote_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the remote peer that generated the event
remote_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the remote peer that generated the event
remote_agent_implementation LowCardinality(String) Implementation of the remote peer
remote_agent_version LowCardinality(String) Version of the remote peer
remote_agent_version_major LowCardinality(String) Major version of the remote peer
remote_agent_version_minor LowCardinality(String) Minor version of the remote peer
remote_agent_version_patch LowCardinality(String) Patch version of the remote peer
remote_agent_platform LowCardinality(String) Platform of the remote peer
direction LowCardinality(String) Connection direction
opened DateTime Timestamp when the connection was opened
transient Bool Whether the connection is transient
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_gossipsub_beacon_attestation
#

Table for libp2p gossipsub beacon attestation data.

Availability
#

Data is partitioned hourly on slot_start_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_gossipsub_beacon_attestation/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_beacon_attestation/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event with millisecond precision
slot UInt32 Slot number associated with the event
slot_start_date_time DateTime Start date and time of the slot
epoch UInt32 The epoch number in the attestation
epoch_start_date_time DateTime The wall clock time when the epoch started
committee_index LowCardinality(String) The committee index in the attestation
attesting_validator_index Nullable(UInt32) The index of the validator attesting to the event
attesting_validator_committee_index LowCardinality(String) The committee index of the attesting validator
wallclock_slot UInt32 Slot number of the wall clock when the event was received
wallclock_slot_start_date_time DateTime Start date and time of the wall clock slot when the event was received
wallclock_epoch UInt32 Epoch number of the wall clock when the event was received
wallclock_epoch_start_date_time DateTime Start date and time of the wall clock epoch when the event was received
propagation_slot_start_diff UInt32 Difference in slot start time for propagation
peer_id_unique_key Int64 Unique key associated with the identifier of the peer
message_id String Identifier of the message
message_size UInt32 Size of the message in bytes
topic_layer LowCardinality(String) Layer of the topic in the gossipsub protocol
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding used for the topic
aggregation_bits String The aggregation bits of the event in the attestation
beacon_block_root FixedString(66) The beacon block root hash in the attestation
source_epoch UInt32 The source epoch number in the attestation
source_epoch_start_date_time DateTime The wall clock time when the source epoch started
source_root FixedString(66) The source beacon block root hash in the attestation
target_epoch UInt32 The target epoch number in the attestation
target_epoch_start_date_time DateTime The wall clock time when the target epoch started
target_root FixedString(66) The target beacon block root hash in the attestation
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Network ID associated with the client
meta_network_name LowCardinality(String) Name of the network associated with the client

libp2p_gossipsub_beacon_block
#

Table for libp2p gossipsub beacon block data.

Availability
#

Data is partitioned hourly on slot_start_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_gossipsub_beacon_block/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_beacon_block/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event with millisecond precision
slot UInt32 Slot number associated with the event
slot_start_date_time DateTime Start date and time of the slot
epoch UInt32 Epoch number associated with the event
epoch_start_date_time DateTime Start date and time of the epoch
wallclock_slot UInt32 Slot number of the wall clock when the event was received
wallclock_slot_start_date_time DateTime Start date and time of the wall clock slot when the event was received
wallclock_epoch UInt32 Epoch number of the wall clock when the event was received
wallclock_epoch_start_date_time DateTime Start date and time of the wall clock epoch when the event was received
propagation_slot_start_diff UInt32 Difference in slot start time for propagation
block FixedString(66) The beacon block root hash
proposer_index UInt32 The proposer index of the beacon block
peer_id_unique_key Int64 Unique key associated with the identifier of the peer
message_id String Identifier of the message
message_size UInt32 Size of the message in bytes
topic_layer LowCardinality(String) Layer of the topic in the gossipsub protocol
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding used for the topic
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Network ID associated with the client
meta_network_name LowCardinality(String) Name of the network associated with the client

libp2p_handle_metadata
#

Contains the metadata handling events for libp2p peers.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_handle_metadata/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_handle_metadata/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the RPC
error Nullable(String) Error message if the metadata handling failed
protocol LowCardinality(String) The protocol of the metadata handling event
attnets String Attestation subnets the peer is subscribed to
seq_number UInt64 Sequence number of the metadata
syncnets String Sync subnets the peer is subscribed to
latency_milliseconds Decimal(10, 3) How long it took to handle the metadata request in milliseconds
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_handle_status
#

Contains the status handling events for libp2p peers.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_handle_status/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_handle_status/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
peer_id_unique_key Int64 Unique key associated with the identifier of the peer
error Nullable(String) Error message if the status handling failed
protocol LowCardinality(String) The protocol of the status handling event
request_finalized_epoch Nullable(UInt32) Requested finalized epoch
request_finalized_root Nullable(String) Requested finalized root
request_fork_digest LowCardinality(String) Requested fork digest
request_head_root Nullable(FixedString(66)) Requested head root
request_head_slot Nullable(UInt32) Requested head slot
response_finalized_epoch Nullable(UInt32) Response finalized epoch
response_finalized_root Nullable(FixedString(66)) Response finalized root
response_fork_digest LowCardinality(String) Response fork digest
response_head_root Nullable(FixedString(66)) Response head root
response_head_slot Nullable(UInt32) Response head slot
latency_milliseconds Decimal(10, 3) How long it took to handle the status request in milliseconds
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_join
#

Contains the details of the JOIN events from the libp2p client.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_join/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_join/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
topic_layer LowCardinality(String) Layer of the topic
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding of the topic
peer_id_unique_key Int64 Unique key associated with the identifier of the peer that joined the topic
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_peer
#

Contains the original peer id of a seahashed peer_id + meta_network_name, commonly seen in other tables as the field peer_id_unique_key

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_peer/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_peer/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record, seahash of peer_id + meta_network_name
updated_date_time DateTime Timestamp when the record was last updated
peer_id String Peer ID
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_recv_rpc
#

Contains the details of the RPC messages received by the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_recv_rpc/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_recv_rpc/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
peer_id_unique_key Int64 Unique key associated with the identifier of the peer sender
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_remove_peer
#

Contains the details of the peers removed from the libp2p client.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_remove_peer/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_remove_peer/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
peer_id_unique_key Int64 Unique key associated with the identifier of the peer
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_rpc_meta_control_graft
#

Contains the details of the “Graft” control messages from the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_rpc_meta_control_graft/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_graft/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each “Graft” control record
updated_date_time DateTime Timestamp when the “Graft” control record was last updated
event_date_time DateTime64(3) Timestamp of the “Graft” control event
control_index Int32 Position in the RPC meta control GRAFT array
rpc_meta_unique_key Int64 Unique key associated with the “Graft” control metadata
topic_layer LowCardinality(String) Layer of the topic
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding of the topic
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the Graft control
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_rpc_meta_control_ihave
#

Contains the details of the “I have” control messages from the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_rpc_meta_control_ihave/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_ihave/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each “I have” control record
updated_date_time DateTime Timestamp when the “I have” control record was last updated
event_date_time DateTime64(3) Timestamp of the “I have” control event
rpc_meta_unique_key Int64 Unique key associated with the “I have” control metadata
message_index Int32 Position in the RPC meta control IWANT message_ids array
control_index Int32 Position in the RPC meta control IWANT array
topic_layer LowCardinality(String) Layer of the topic
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding of the topic
message_id String Identifier of the message associated with the “I have” control
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the I have control
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_rpc_meta_control_iwant
#

Contains the details of the “I want” control messages from the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_rpc_meta_control_iwant/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_iwant/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each “I want” control record
updated_date_time DateTime Timestamp when the “I want” control record was last updated
event_date_time DateTime64(3) Timestamp of the “I want” control event
control_index Int32 Position in the RPC meta control IWANT array
message_index Int32 Position in the RPC meta control IWANT message_ids array
rpc_meta_unique_key Int64 Unique key associated with the “I want” control metadata
message_id String Identifier of the message associated with the “I want” control
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the I want control
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_rpc_meta_control_prune
#

Contains the details of the “Prune” control messages from the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_rpc_meta_control_prune/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_prune/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each “Prune” control record
updated_date_time DateTime Timestamp when the “Prune” control record was last updated
event_date_time DateTime64(3) Timestamp of the “Prune” control event
control_index Int32 Position in the RPC meta control PRUNE array
rpc_meta_unique_key Int64 Unique key associated with the “Prune” control metadata
peer_id_index Int32 **
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the Prune control
graft_peer_id_unique_key Int64 Unique key associated with the identifier of the graft peer involved in the Prune control
topic_layer LowCardinality(String) Layer of the topic
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding of the topic
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_rpc_meta_message
#

Contains the details of the RPC meta messages from the peer

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_rpc_meta_message/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_message/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each RPC message record
updated_date_time DateTime Timestamp when the RPC message record was last updated
event_date_time DateTime64(3) Timestamp of the RPC event
control_index Int32 Position in the RPC meta message array
rpc_meta_unique_key Int64 Unique key associated with the RPC metadata
message_id String Identifier of the message
topic_layer LowCardinality(String) Layer of the topic
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding of the topic
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the RPC
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_rpc_meta_subscription
#

Contains the details of the RPC subscriptions from the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_rpc_meta_subscription/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_subscription/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each RPC subscription record
updated_date_time DateTime Timestamp when the RPC subscription record was last updated
event_date_time DateTime64(3) Timestamp of the RPC subscription event
control_index Int32 Position in the RPC meta subscription array
rpc_meta_unique_key Int64 Unique key associated with the RPC subscription metadata
subscribe Bool Boolean indicating if it is a subscription or unsubscription
topic_layer LowCardinality(String) Layer of the topic
topic_fork_digest_value LowCardinality(String) Fork digest value of the topic
topic_name LowCardinality(String) Name of the topic
topic_encoding LowCardinality(String) Encoding of the topic
peer_id_unique_key Int64 Unique key associated with the identifier of the peer involved in the subscription
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name

libp2p_send_rpc
#

Contains the details of the RPC messages sent by the peer.

Availability
#

Data is partitioned hourly on event_date_time for the following networks:

  • mainnet: null to null
  • holesky: null to null
  • sepolia: null to null

Example
#

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_send_rpc/YYYY/MM/DD/HH.parquet

clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_send_rpc/2024/6/9/0.parquet', 'Parquet') LIMIT 10"

Columns
#

Name Type Description
unique_key Int64 Unique identifier for each record
updated_date_time DateTime Timestamp when the record was last updated
event_date_time DateTime64(3) Timestamp of the event
peer_id_unique_key Int64 Unique key associated with the identifier of the peer receiver
meta_client_name LowCardinality(String) Name of the client that generated the event
meta_client_id String Unique Session ID of the client that generated the event. This changes every time the client is restarted.
meta_client_version LowCardinality(String) Version of the client that generated the event
meta_client_implementation LowCardinality(String) Implementation of the client that generated the event
meta_client_os LowCardinality(String) Operating system of the client that generated the event
meta_client_ip Nullable(IPv6) IP address of the client that generated the event
meta_client_geo_city LowCardinality(String) City of the client that generated the event
meta_client_geo_country LowCardinality(String) Country of the client that generated the event
meta_client_geo_country_code LowCardinality(String) Country code of the client that generated the event
meta_client_geo_continent_code LowCardinality(String) Continent code of the client that generated the event
meta_client_geo_longitude Nullable(Float64) Longitude of the client that generated the event
meta_client_geo_latitude Nullable(Float64) Latitude of the client that generated the event
meta_client_geo_autonomous_system_number Nullable(UInt32) Autonomous system number of the client that generated the event
meta_client_geo_autonomous_system_organization Nullable(String) Autonomous system organization of the client that generated the event
meta_network_id Int32 Ethereum network ID
meta_network_name LowCardinality(String) Ethereum network name