libp2p_.md

Events from the consensus layer p2p network. This data is usually useful for 'timing' events, such as when a block was seen by a sentry. Because of this it usually has the same data but from many different instances.

The libp2p dataset captures peer-to-peer network events from the consensus layer, however due to the large volume of network traffic, data is sampled using a sharding strategy. This ensures manageable data sizes while maintaining significance. Not all events are captured - the sampling rate varies by event type and topic, with high-volume topics being more aggressively sampled.

Event Categorization

Events are categorized into four groups based on their available sharding keys:

Group A: Topic + MsgID Events

Events with both topic and message ID, enabling full sharding flexibility:

• PUBLISH_MESSAGE, DELIVER_MESSAGE, DUPLICATE_MESSAGE, REJECT_MESSAGE
• GOSSIPSUB_BEACON_BLOCK, GOSSIPSUB_BEACON_ATTESTATION, GOSSIPSUB_BLOB_SIDECAR
• RPC_META_MESSAGE, RPC_META_CONTROL_IHAVE

Sharding: Uses message ID for sharding, with topic-based configuration

Group B: Topic-Only Events

Events with only topic information:

• JOIN, LEAVE, GRAFT, PRUNE
• RPC_META_CONTROL_GRAFT, RPC_META_CONTROL_PRUNE, RPC_META_SUBSCRIPTION

Sharding: Uses topic hash for sharding decisions

Group C: MsgID-Only Events

Events with only message ID:

• RPC_META_CONTROL_IWANT, RPC_META_CONTROL_IDONTWANT

Sharding: Uses message ID with default configuration

Group D: No Sharding Key Events

Events without sharding keys:

• ADD_PEER, REMOVE_PEER, CONNECTED, DISCONNECTED
• RECV_RPC, SEND_RPC, DROP_RPC (parent events only)
• HANDLE_METADATA, HANDLE_STATUS

Sharding: All-or-nothing based on configuration

Sharding Decision Flow

┌─────────────┐
│Event Arrives│
└──────┬──────┘
       │
       ▼
┌──────────────┐     ┌─────────────────┐
│Get Event Info├────►│ Event Category? │
└──────────────┘     └────────┬────────┘
                              │
        ┌─────────────────────┼─────────────────────┬─────────────────────┐
        ▼                     ▼                     ▼                     ▼
   ┌─────────┐         ┌─────────┐           ┌─────────┐           ┌─────────┐
   │ Group A │         │ Group B │           │ Group C │           │ Group D │
   │Topic+Msg│         │Topic Only│          │Msg Only │           │ No Keys │
   └────┬────┘         └────┬────┘           └────┬────┘           └────┬────┘
        │                   │                     │                     │
        ▼                   ▼                     ▼                     ▼
   Topic Config?       Topic Config?         Default Shard         Enabled?
        │                   │                     │                     │
     Yes/No              Yes/No                   │                  Yes/No
        │                   │                     │                     │
        ▼                   ▼                     ▼                     ▼
   Shard by Msg       Shard by Topic        Shard by Msg         Process/Drop

Availability

• EthPandaOps Clickhouse
• Public Parquet Files

Tables

• libp2p_gossipsub_beacon_attestation
• libp2p_gossipsub_beacon_block
• libp2p_gossipsub_blob_sidecar
• libp2p_gossipsub_data_column_sidecar
• libp2p_gossipsub_aggregate_and_proof
• libp2p_gossipsub_execution_payload_bid
• libp2p_gossipsub_execution_payload_envelope
• libp2p_gossipsub_payload_attestation_message
• libp2p_gossipsub_proposer_preferences
• libp2p_connected
• libp2p_disconnected
• libp2p_recv_rpc
• libp2p_send_rpc
• libp2p_drop_rpc
• libp2p_join
• libp2p_leave
• libp2p_graft
• libp2p_prune
• libp2p_duplicate_message
• libp2p_deliver_message
• libp2p_handle_metadata
• libp2p_handle_status
• libp2p_rpc_meta_control_ihave
• libp2p_rpc_meta_control_iwant
• libp2p_rpc_meta_control_idontwant
• libp2p_rpc_meta_control_graft
• libp2p_rpc_meta_control_prune
• libp2p_rpc_meta_subscription
• libp2p_rpc_meta_message
• libp2p_rpc_data_column_custody_probe
• libp2p_identify
• libp2p_synthetic_heartbeat

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: 2024-05-01 to 2026-11-01
• holesky: 2024-05-01 to 2025-10-26
• sepolia: 2024-05-01 to 2026-11-01

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_gossipsub_beacon_attestation/YYYY/M/D/H.parquet

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_beacon_attestation/2026/11/1/0.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_beacon_attestation FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_beacon_attestation FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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_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_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 daily on slot_start_date_time for the following networks:

• mainnet: 2020-12-01 to 2026-11-01
• holesky: 2024-04-26 to 2025-10-26
• sepolia: 2024-04-26 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_beacon_block/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_beacon_block FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_beacon_block FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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_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_name	LowCardinality(String)	Name of the network associated with the client

libp2p_gossipsub_blob_sidecar

Table for libp2p gossipsub blob sidecar data

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• mainnet: 2020-12-01 to 2025-12-09
• holesky: 2024-06-03 to 2025-10-07
• sepolia: 2024-06-03 to 2025-10-20

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_blob_sidecar/2025/12/9.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_blob_sidecar FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_blob_sidecar FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
proposer_index	UInt32	The proposer index of the beacon block
blob_index	UInt32	Blob index associated with the record
beacon_block_root	FixedString(66)	**
parent_root	FixedString(66)	Parent root of the beacon block
state_root	FixedString(66)	State root 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_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_name	LowCardinality(String)	Name of the network associated with the client

libp2p_gossipsub_data_column_sidecar

Table for libp2p gossipsub data column sidecar data

🔀 Introduced in the Fusaka network upgrade (fulu fork).

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• mainnet: 2025-12-03 to 2026-11-01
• holesky: 2025-10-01 to 2025-10-26
• hoodi: 2025-10-28 to 2026-11-01
• sepolia: 2025-10-14 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_data_column_sidecar/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_data_column_sidecar FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_data_column_sidecar FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
proposer_index	UInt32	The proposer index of the beacon block
column_index	UInt64	Column index associated with the record
kzg_commitments_count	UInt32	Number of KZG commitments associated with the record. 0 on Gloas, where the sidecar no longer carries the block header
beacon_block_root	FixedString(66)	**
parent_root	FixedString(66)	Parent root of the beacon block
state_root	FixedString(66)	State root 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_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_name	LowCardinality(String)	Name of the network associated with the client

libp2p_gossipsub_aggregate_and_proof

Table for libp2p gossipsub aggregate and proof data.

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• mainnet: 2025-07-11 to 2026-11-01
• holesky: 2025-07-11 to 2025-10-26
• sepolia: 2025-07-11 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_aggregate_and_proof/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_aggregate_and_proof FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_aggregate_and_proof FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
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
aggregator_index	UInt32	Index of the validator who created this aggregate
committee_index	LowCardinality(String)	Committee index from the attestation
aggregation_bits	String	Bitfield of aggregated attestation
beacon_block_root	FixedString(66)	Root of the beacon block being attested to
source_epoch	UInt32	Source epoch from the attestation
source_root	FixedString(66)	Source root from the attestation
target_epoch	UInt32	Target epoch from the attestation
target_root	FixedString(66)	Target root from the attestation
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Name of the network associated with the client

libp2p_gossipsub_execution_payload_bid

Builder bid gossip propagation from libp2p.

🔀 Introduced in the Glamsterdam network upgrade (gloas fork).

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• sepolia: 2026-10-06 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_execution_payload_bid/2026/10/27.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_execution_payload_bid FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_execution_payload_bid FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
slot_start_date_time	DateTime	Start date and time of the slot
epoch	UInt32	Epoch number
epoch_start_date_time	DateTime	Start date and time of the epoch
wallclock_slot	UInt32	Wall clock slot when the event was received
wallclock_slot_start_date_time	DateTime	Start time of the wall clock slot
wallclock_epoch	UInt32	Wall clock epoch when the event was received
wallclock_epoch_start_date_time	DateTime	Start time of the wall clock epoch
propagation_slot_start_diff	Int32	Propagation delay from slot start in ms (negative if observed before slot start)
builder_index	Nullable(UInt64)	Index of the builder, NULL when self-built
block_hash	FixedString(66)	Execution block hash committed to in the bid
parent_block_hash	FixedString(66)	Parent execution block hash
value	UInt64	Bid value in Gwei
execution_payment	UInt64	Execution payment in Gwei
fee_recipient	FixedString(42)	Fee recipient address
gas_limit	UInt64	Gas limit
blob_kzg_commitment_count	UInt32	Number of blob KZG commitments
peer_id_unique_key	Int64	Unique key for the peer identifier
message_id	String	Identifier of the gossip message
message_size	UInt32	Size of the message in bytes
topic_layer	LowCardinality(String)	Layer of the gossipsub 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 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
meta_client_version	LowCardinality(String)	Version of the client
meta_client_implementation	LowCardinality(String)	Implementation of the client
meta_client_os	LowCardinality(String)	Operating system of the client
meta_client_ip	Nullable(IPv6)	IP address of the client
meta_client_geo_city	LowCardinality(String)	City of the client
meta_client_geo_country	LowCardinality(String)	Country of the client
meta_client_geo_country_code	LowCardinality(String)	Country code of the client
meta_client_geo_continent_code	LowCardinality(String)	Continent code of the client
meta_client_geo_longitude	Nullable(Float64)	Longitude of the client
meta_client_geo_latitude	Nullable(Float64)	Latitude of the client
meta_client_geo_autonomous_system_number	Nullable(UInt32)	ASN of the client
meta_client_geo_autonomous_system_organization	Nullable(String)	AS organization of the client
meta_network_id	Int32	Ethereum network ID
meta_network_name	LowCardinality(String)	Ethereum network name

libp2p_gossipsub_execution_payload_envelope

Execution payload envelope gossip propagation from libp2p.

🔀 Introduced in the Glamsterdam network upgrade (gloas fork).

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• sepolia: 2026-10-06 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_execution_payload_envelope/2026/10/27.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_execution_payload_envelope FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_execution_payload_envelope FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
slot_start_date_time	DateTime	Start date and time of the slot
epoch	UInt32	Epoch number
epoch_start_date_time	DateTime	Start date and time of the epoch
wallclock_slot	UInt32	Wall clock slot when the event was received
wallclock_slot_start_date_time	DateTime	Start time of the wall clock slot
wallclock_epoch	UInt32	Wall clock epoch when the event was received
wallclock_epoch_start_date_time	DateTime	Start time of the wall clock epoch
propagation_slot_start_diff	UInt32	Propagation delay from slot start in ms
block_root	FixedString(66)	Beacon block root the envelope references
builder_index	Nullable(UInt64)	Index of the builder that produced the payload, NULL when self-built
block_hash	FixedString(66)	Execution block hash
peer_id_unique_key	Int64	Unique key for the peer identifier
message_id	String	Identifier of the gossip message
message_size	UInt32	Size of the message in bytes
topic_layer	LowCardinality(String)	Layer of the gossipsub 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 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
meta_client_version	LowCardinality(String)	Version of the client
meta_client_implementation	LowCardinality(String)	Implementation of the client
meta_client_os	LowCardinality(String)	Operating system of the client
meta_client_ip	Nullable(IPv6)	IP address of the client
meta_client_geo_city	LowCardinality(String)	City of the client
meta_client_geo_country	LowCardinality(String)	Country of the client
meta_client_geo_country_code	LowCardinality(String)	Country code of the client
meta_client_geo_continent_code	LowCardinality(String)	Continent code of the client
meta_client_geo_longitude	Nullable(Float64)	Longitude of the client
meta_client_geo_latitude	Nullable(Float64)	Latitude of the client
meta_client_geo_autonomous_system_number	Nullable(UInt32)	ASN of the client
meta_client_geo_autonomous_system_organization	Nullable(String)	AS organization of the client
meta_network_id	Int32	Ethereum network ID
meta_network_name	LowCardinality(String)	Ethereum network name

libp2p_gossipsub_payload_attestation_message

Individual PTC payload attestation messages from libp2p gossip (~512 per slot).

🔀 Introduced in the Glamsterdam network upgrade (gloas fork).

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• sepolia: 2026-10-06 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_payload_attestation_message/2026/10/27.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_payload_attestation_message FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_payload_attestation_message FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
slot_start_date_time	DateTime	Start date and time of the slot
epoch	UInt32	Epoch number
epoch_start_date_time	DateTime	Start date and time of the epoch
wallclock_slot	UInt32	Wall clock slot when the event was received
wallclock_slot_start_date_time	DateTime	Start time of the wall clock slot
wallclock_epoch	UInt32	Wall clock epoch when the event was received
wallclock_epoch_start_date_time	DateTime	Start time of the wall clock epoch
propagation_slot_start_diff	UInt32	Propagation delay from slot start in ms
validator_index	UInt32	Index of the PTC validator
beacon_block_root	FixedString(66)	Block root being attested to
payload_present	Bool	Whether the validator attests payload was present
blob_data_available	Bool	Whether the validator attests blob data was available
peer_id_unique_key	Int64	Unique key for the peer identifier
message_id	String	Identifier of the gossip message
message_size	UInt32	Size of the message in bytes
topic_layer	LowCardinality(String)	Layer of the gossipsub 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 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
meta_client_version	LowCardinality(String)	Version of the client
meta_client_implementation	LowCardinality(String)	Implementation of the client
meta_client_os	LowCardinality(String)	Operating system of the client
meta_client_ip	Nullable(IPv6)	IP address of the client
meta_client_geo_city	LowCardinality(String)	City of the client
meta_client_geo_country	LowCardinality(String)	Country of the client
meta_client_geo_country_code	LowCardinality(String)	Country code of the client
meta_client_geo_continent_code	LowCardinality(String)	Continent code of the client
meta_client_geo_longitude	Nullable(Float64)	Longitude of the client
meta_client_geo_latitude	Nullable(Float64)	Latitude of the client
meta_client_geo_autonomous_system_number	Nullable(UInt32)	ASN of the client
meta_client_geo_autonomous_system_organization	Nullable(String)	AS organization of the client
meta_network_id	Int32	Ethereum network ID
meta_network_name	LowCardinality(String)	Ethereum network name

libp2p_gossipsub_proposer_preferences

Proposer preferences gossip propagation from libp2p.

🔀 Introduced in the Glamsterdam network upgrade (gloas fork).

Availability

Data is partitioned daily on slot_start_date_time for the following networks:

• sepolia: 2026-10-06 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_proposer_preferences/2026/10/27.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_gossipsub_proposer_preferences FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_gossipsub_proposer_preferences FINAL
    WHERE
        slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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	Proposal slot
slot_start_date_time	DateTime	Start date and time of the slot
epoch	UInt32	Epoch number
epoch_start_date_time	DateTime	Start date and time of the epoch
wallclock_slot	UInt32	Wall clock slot when the event was received
wallclock_slot_start_date_time	DateTime	Start time of the wall clock slot
wallclock_epoch	UInt32	Wall clock epoch when the event was received
wallclock_epoch_start_date_time	DateTime	Start time of the wall clock epoch
propagation_slot_start_diff	Int32	Propagation delay from slot start in ms (negative if observed before slot start)
validator_index	UInt32	Index of the proposing validator
fee_recipient	FixedString(42)	Preferred fee recipient address
target_gas_limit	UInt64	Preferred gas limit
peer_id_unique_key	Int64	Unique key for the peer identifier
message_id	String	Identifier of the gossip message
message_size	UInt32	Size of the message in bytes
topic_layer	LowCardinality(String)	Layer of the gossipsub 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 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
meta_client_version	LowCardinality(String)	Version of the client
meta_client_implementation	LowCardinality(String)	Implementation of the client
meta_client_os	LowCardinality(String)	Operating system of the client
meta_client_ip	Nullable(IPv6)	IP address of the client
meta_client_geo_city	LowCardinality(String)	City of the client
meta_client_geo_country	LowCardinality(String)	Country of the client
meta_client_geo_country_code	LowCardinality(String)	Country code of the client
meta_client_geo_continent_code	LowCardinality(String)	Continent code of the client
meta_client_geo_longitude	Nullable(Float64)	Longitude of the client
meta_client_geo_latitude	Nullable(Float64)	Latitude of the client
meta_client_geo_autonomous_system_number	Nullable(UInt32)	ASN of the client
meta_client_geo_autonomous_system_organization	Nullable(String)	AS organization of the client
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 daily on event_date_time for the following networks:

• mainnet: 2024-04-24 to 2026-11-01
• hoodi: 2025-03-17 to 2026-11-01
• sepolia: 2024-04-22 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_connected/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_connected FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_connected FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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	Nullable(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_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_name	LowCardinality(String)	Ethereum network name

libp2p_disconnected

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2024-04-24 to 2026-11-01
• hoodi: 2025-03-17 to 2026-11-01
• sepolia: 2024-04-22 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_disconnected/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_disconnected FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_disconnected FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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	Nullable(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_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_name	LowCardinality(String)	Ethereum network name

libp2p_recv_rpc

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_recv_rpc/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_recv_rpc FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_recv_rpc FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name

libp2p_send_rpc

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_send_rpc/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_send_rpc FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_send_rpc FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name

libp2p_drop_rpc

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-30 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_drop_rpc/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_drop_rpc FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_drop_rpc FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name

libp2p_join

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2024-05-01 to 2026-11-01
• hoodi: 2025-03-17 to 2026-11-01
• sepolia: 2024-05-01 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_join/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_join FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_join FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
local_peer_id_unique_key	Int64	Unique key derived from the libp2p peer.ID of the local host that joined the topic
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Ethereum network name

libp2p_leave

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-06-01 to 2026-11-01
• hoodi: 2025-06-01 to 2025-06-01
• sepolia: 2025-06-01 to 2025-06-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_leave/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_leave FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_leave FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
local_peer_id_unique_key	Int64	Unique key derived from the libp2p peer.ID of the local host that left the topic
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Ethereum network name

libp2p_graft

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_graft/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_graft FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_graft FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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 for the peer that initiated the GRAFT (eg joined the mesh for this topic) identifies mesh membership changes per peer.
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Ethereum network name

libp2p_prune

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_prune/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_prune FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_prune FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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 for the peer that was PRUNED (eg removed from the mesh for this topic) identifies mesh membership changes per peer.
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Ethereum network name

libp2p_duplicate_message

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_duplicate_message/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_duplicate_message FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_duplicate_message FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
seq_number	UInt64	A linearly increasing number that is unique among messages originating from the given peer
local_delivery	Bool	Indicates if the message was duplicated locally
peer_id_unique_key	Int64	Unique key for the peer that sent the duplicate message
message_id	String	Identifier of the message
message_size	UInt32	Size of the message in bytes
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Ethereum network name

libp2p_deliver_message

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

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_deliver_message/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_deliver_message FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_deliver_message FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
seq_number	UInt64	A linearly increasing number that is unique among messages originating from the given peer
local_delivery	Bool	Indicates if the message was delivered to in-process subscribers only
peer_id_unique_key	Int64	Unique key for the peer that delivered the message
message_id	String	Identifier of the message
message_size	UInt32	Size of the message in bytes
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_name	LowCardinality(String)	Ethereum network name

libp2p_handle_metadata

Contains the metadata handling events for libp2p peers.

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2024-04-24 to 2026-11-01
• hoodi: 2025-03-17 to 2026-11-01
• sepolia: 2024-04-22 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_handle_metadata/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_handle_metadata FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_handle_metadata FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
direction	LowCardinality(String)	Direction of the RPC request (inbound or outbound)
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
custody_group_count	Nullable(UInt8)	Number of custody groups (0-127)
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_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_name	LowCardinality(String)	Ethereum network name

libp2p_handle_status

Contains the status handling events for libp2p peers.

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2024-04-24 to 2026-11-01
• hoodi: 2025-03-17 to 2026-11-01
• sepolia: 2024-04-22 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_handle_status/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_handle_status FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_handle_status FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
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
direction	LowCardinality(String)	Direction of the RPC request (inbound or outbound)
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
request_earliest_available_slot	Nullable(UInt32)	Requested earliest available 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
response_earliest_available_slot	Nullable(UInt32)	Response earliest available 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_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_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 daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_ihave/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_ihave FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_ihave FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name

libp2p_rpc_meta_control_iwant

Contains IWANT control messages from gossipsub. Collected from deep instrumentation within forked consensus layer clients. Peers request specific message IDs. Partition: monthly by event_date_time

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_iwant/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_iwant FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_iwant FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name

libp2p_rpc_meta_control_idontwant

Contains the details of the IDONTWANT control messages from the peer.

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_idontwant/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_idontwant FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_idontwant FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
unique_key	Int64	Unique identifier for each IDONTWANT control record
updated_date_time	DateTime	Timestamp when the IDONTWANT control record was last updated
event_date_time	DateTime64(3)	Timestamp of the IDONTWANT control event
control_index	Int32	Position in the RPC meta control idontwant array
message_index	Int32	Position in the RPC meta control idontwant message_ids array
rpc_meta_unique_key	Int64	Unique key associated with the IDONTWANT control metadata
message_id	String	Identifier of the message associated with the IDONTWANT control
peer_id_unique_key	Int64	Unique key associated with the identifier of the peer involved in the IDONTWANT control
meta_client_name	LowCardinality(String)	Name of the client that generated the event
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_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 daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_graft/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_graft FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_graft FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_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 daily on event_date_time for the following networks:

• mainnet: 2025-07-02 to 2026-11-01
• hoodi: 2025-06-23 to 2026-11-01
• sepolia: 2025-06-23 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_prune/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_prune FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_control_prune FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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	Nullable(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_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_name	LowCardinality(String)	Ethereum network name

libp2p_rpc_meta_subscription

Contains the details of the RPC subscriptions from the peer.

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_subscription/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_subscription FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_subscription FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name
requests_partial	Nullable(Bool)	Whether the peer asked to receive gossipsub partial messages on the topic. Null when the tracer cannot see the partial messages subscription options
supports_sending_partial	Nullable(Bool)	Whether the peer can send gossipsub partial messages on the topic. Null when the tracer cannot see the partial messages subscription options

libp2p_rpc_meta_message

Contains the details of the RPC meta messages from the peer

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-05-30 to 2026-11-01
• hoodi: 2025-05-29 to 2026-11-01
• sepolia: 2025-05-29 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_message/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_meta_message FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_meta_message FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

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_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_name	LowCardinality(String)	Ethereum network name

libp2p_rpc_data_column_custody_probe

Contains custody probe events for data column availability verification

🔀 Introduced in the Fusaka network upgrade (fulu fork).

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-12-03 to 2026-11-01
• hoodi: 2025-12-03 to 2026-11-01
• sepolia: 2025-12-03 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_data_column_custody_probe/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_rpc_data_column_custody_probe FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_rpc_data_column_custody_probe FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
updated_date_time	DateTime	Timestamp when the record was last updated
event_date_time	DateTime64(3)	When the probe was executed
slot	UInt32	Slot number being probed
slot_start_date_time	DateTime	The wall clock time when the slot started
epoch	UInt32	Epoch number of the slot being probed
epoch_start_date_time	DateTime	The wall clock time when the epoch started
wallclock_request_slot	UInt32	The wallclock slot when the request was sent
wallclock_request_slot_start_date_time	DateTime	The start time for the slot when the request was sent
wallclock_request_epoch	UInt32	The wallclock epoch when the request was sent
wallclock_request_epoch_start_date_time	DateTime	The start time for the wallclock epoch when the request was sent
column_index	UInt64	Column index being probed
column_rows_count	UInt16	Number of rows in the column
beacon_block_root	FixedString(66)	Root of the beacon block
peer_id_unique_key	Int64	Unique key associated with the identifier of the peer
result	LowCardinality(String)	Result of the probe
response_time_ms	Int32	Response time in milliseconds
error	Nullable(String)	Error message if probe failed
meta_client_name	LowCardinality(String)	Name of the client that executed the probe
meta_client_version	LowCardinality(String)	Version of the client
meta_client_implementation	LowCardinality(String)	Implementation of the client
meta_client_os	LowCardinality(String)	Operating system of the client
meta_client_ip	Nullable(IPv6)	IP address of the client
meta_client_geo_city	LowCardinality(String)	City of the client
meta_client_geo_country	LowCardinality(String)	Country of the client
meta_client_geo_country_code	LowCardinality(String)	Country code of the client
meta_client_geo_continent_code	LowCardinality(String)	Continent code of the client
meta_client_geo_longitude	Nullable(Float64)	Longitude of the client
meta_client_geo_latitude	Nullable(Float64)	Latitude of the client
meta_client_geo_autonomous_system_number	Nullable(UInt32)	Autonomous system number of the client
meta_client_geo_autonomous_system_organization	Nullable(String)	Autonomous system organization of the client
meta_network_name	LowCardinality(String)	Ethereum network name

libp2p_identify

Contains libp2p identify protocol exchange results including remote peer agent info, supported protocols, and connection metadata

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2026-02-23 to ``
• hoodi: 2026-02-23 to ``
• sepolia: 2026-02-23 to ``

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_identify/2026/10/27.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_identify FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_identify FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
updated_date_time	DateTime	**
event_date_time	DateTime64(3)	**
remote_peer_id_unique_key	Int64	**
success	Bool	**
error	Nullable(String)	**
remote_protocol	LowCardinality(String)	**
remote_transport_protocol	LowCardinality(String)	**
remote_port	UInt16	**
remote_ip	Nullable(IPv6)	**
remote_geo_city	LowCardinality(String)	**
remote_geo_country	LowCardinality(String)	**
remote_geo_country_code	LowCardinality(String)	**
remote_geo_continent_code	LowCardinality(String)	**
remote_geo_longitude	Nullable(Float64)	**
remote_geo_latitude	Nullable(Float64)	**
remote_geo_autonomous_system_number	Nullable(UInt32)	**
remote_geo_autonomous_system_organization	Nullable(String)	**
remote_agent_implementation	LowCardinality(String)	**
remote_agent_version	LowCardinality(String)	**
remote_agent_version_major	LowCardinality(String)	**
remote_agent_version_minor	LowCardinality(String)	**
remote_agent_version_patch	LowCardinality(String)	**
remote_agent_platform	LowCardinality(String)	**
protocol_version	LowCardinality(String)	**
protocols	Array(String)	**
listen_addrs	Array(String)	**
observed_addr	String	**
transport	LowCardinality(String)	**
security	LowCardinality(String)	**
muxer	LowCardinality(String)	**
direction	LowCardinality(String)	**
remote_multiaddr	String	**
meta_client_name	LowCardinality(String)	**
meta_client_version	LowCardinality(String)	**
meta_client_implementation	LowCardinality(String)	**
meta_client_os	LowCardinality(String)	**
meta_client_ip	Nullable(IPv6)	**
meta_client_geo_city	LowCardinality(String)	**
meta_client_geo_country	LowCardinality(String)	**
meta_client_geo_country_code	LowCardinality(String)	**
meta_client_geo_continent_code	LowCardinality(String)	**
meta_client_geo_longitude	Nullable(Float64)	**
meta_client_geo_latitude	Nullable(Float64)	**
meta_client_geo_autonomous_system_number	Nullable(UInt32)	**
meta_client_geo_autonomous_system_organization	Nullable(String)	**
meta_network_name	LowCardinality(String)	**

libp2p_synthetic_heartbeat

Contains heartbeat events from libp2p peers

Availability

Data is partitioned daily on event_date_time for the following networks:

• mainnet: 2025-08-21 to 2026-11-01
• holesky: 2025-09-29 to 2025-10-20
• hoodi: 2025-08-21 to 2026-11-01
• sepolia: 2025-08-21 to 2026-11-01

Examples

Parquet file

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

docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
    SELECT
        *
    FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_synthetic_heartbeat/2026/11/1.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

Note: FINAL should be used when querying this table

docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
    SELECT
        *
    FROM default.libp2p_synthetic_heartbeat FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 10
    FORMAT Pretty
"""

EthPandaOps Clickhouse

Note: FINAL should be used when querying this table

echo """
    SELECT
        *
    FROM default.libp2p_synthetic_heartbeat FINAL
    WHERE
        event_date_time >= NOW() - INTERVAL '1 HOUR'
    LIMIT 3
    FORMAT Pretty
""" | curl "https://clickhouse-raw.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-

Columns

Name	Type	Description
updated_date_time	DateTime	Timestamp when the record was last updated
event_date_time	DateTime64(3)	Timestamp of the heartbeat event
remote_peer_id_unique_key	Int64	Unique key of the remote peer
remote_maddrs	String	Multiaddress of the remote peer
latency_ms	Nullable(Int64)	EWMA latency in milliseconds (0 if unavailable)
direction	LowCardinality(String)	Connection direction (Unknown/Inbound/Outbound)
protocols	Array(String)	List of supported protocols
connection_age_ms	Nullable(Int64)	Connection age in milliseconds
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
remote_ip	Nullable(IPv6)	IP address of the remote peer
remote_port	Nullable(UInt16)	Port of the remote peer
remote_geo_city	LowCardinality(String)	City of the remote peer
remote_geo_country	LowCardinality(String)	Country of the remote peer
remote_geo_country_code	LowCardinality(String)	Country code of the remote peer
remote_geo_continent_code	LowCardinality(String)	Continent code of the remote peer
remote_geo_longitude	Nullable(Float64)	Longitude of the remote peer
remote_geo_latitude	Nullable(Float64)	Latitude of the remote peer
remote_geo_autonomous_system_number	Nullable(UInt32)	ASN of the remote peer
remote_geo_autonomous_system_organization	Nullable(String)	AS organization of the remote peer
meta_client_name	LowCardinality(String)	Name of the client that generated the event
meta_client_version	LowCardinality(String)	Version of the client
meta_client_implementation	LowCardinality(String)	Implementation of the client
meta_client_os	LowCardinality(String)	Operating system of the client
meta_client_ip	Nullable(IPv6)	IP address of the client
meta_client_geo_city	LowCardinality(String)	City of the client
meta_client_geo_country	LowCardinality(String)	Country of the client
meta_client_geo_country_code	LowCardinality(String)	Country code of the client
meta_client_geo_continent_code	LowCardinality(String)	Continent code of the client
meta_client_geo_longitude	Nullable(Float64)	Longitude of the client
meta_client_geo_latitude	Nullable(Float64)	Latitude of the client
meta_client_geo_autonomous_system_number	Nullable(UInt32)	ASN of the client
meta_client_geo_autonomous_system_organization	Nullable(String)	AS organization of the client
meta_network_name	LowCardinality(String)	Ethereum network name