Xatu - Schema
This dataset contains a wealth of information about the Ethereum network, including detailed data on beacon chain events, mempool activity, and canonical chain events. Read more in our
announcement post.
Xatu data is licensed under
CC BY 4.0
Tables #
-
beacon_api_eth_v1_beacon_committee -
beacon_api_eth_v1_events_attestation -
beacon_api_eth_v1_events_blob_sidecar -
beacon_api_eth_v1_events_block -
beacon_api_eth_v1_events_chain_reorg -
beacon_api_eth_v1_events_contribution_and_proof -
beacon_api_eth_v1_events_finalized_checkpoint -
beacon_api_eth_v1_events_head -
beacon_api_eth_v1_events_voluntary_exit -
beacon_api_eth_v1_validator_attestation_data -
beacon_api_eth_v2_beacon_block -
mempool_transaction -
beacon_api_eth_v1_proposer_duty -
canonical_beacon_block -
canonical_beacon_block_attester_slashing -
canonical_beacon_block_proposer_slashing -
canonical_beacon_block_bls_to_execution_change -
canonical_beacon_block_execution_transaction -
canonical_beacon_block_voluntary_exit -
canonical_beacon_block_deposit -
canonical_beacon_block_withdrawal -
canonical_beacon_blob_sidecar -
canonical_beacon_proposer_duty -
canonical_beacon_elaborated_attestation -
libp2p_add_peer -
libp2p_connected -
libp2p_disconnected -
libp2p_gossipsub_beacon_attestation -
libp2p_gossipsub_beacon_block -
libp2p_handle_metadata -
libp2p_handle_status -
libp2p_join -
libp2p_peer -
libp2p_recv_rpc -
libp2p_remove_peer -
libp2p_rpc_meta_control_graft -
libp2p_rpc_meta_control_ihave -
libp2p_rpc_meta_control_iwant -
libp2p_rpc_meta_control_prune -
libp2p_rpc_meta_message -
libp2p_rpc_meta_subscription -
libp2p_send_rpc
beacon_api_eth_v1_beacon_committee #
Contains beacon API /eth/v1/beacon/states/{state_id}/committees data from each sentry client attached to a beacon node.
Sometimes sentries may
publish different committees for the same epoch.
Availability #
Data is partitioned hourly on slot_start_date_time for the following networks:
- mainnet:
2023-09-05to2024-07-23 - holesky:
2023-12-25to2024-07-23 - sepolia:
2023-12-24to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_beacon_committee/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_beacon_committee FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
Slot number in the beacon API committee payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| committee_index | LowCardinality(String) |
The committee index in the beacon API committee payload |
| validators | Array(UInt32) |
The validator indices in the beacon API committee payload |
| epoch | UInt32 |
The epoch number in the beacon API committee payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_attestation #
Contains beacon API eventstream “attestation” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned hourly on slot_start_date_time for the following networks:
- mainnet:
2023-06-05to2024-07-23 - holesky:
2023-09-29to2024-07-23 - sepolia:
2023-09-01to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_attestation/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_attestation WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
Slot number in the beacon API event stream payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| propagation_slot_start_diff | UInt32 |
The difference between the event_date_time and the slot_start_date_time |
| committee_index | LowCardinality(String) |
The committee index in the beacon API event stream payload |
| attesting_validator_index | Nullable(UInt32) |
The index of the validator attesting to the event |
| attesting_validator_committee_index | LowCardinality(String) |
The committee index of the attesting validator |
| aggregation_bits | String |
The aggregation bits of the event in the beacon API event stream payload |
| beacon_block_root | FixedString(66) |
The beacon block root hash in the beacon API event stream payload |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| source_epoch | UInt32 |
The source epoch number in the beacon API event stream payload |
| source_epoch_start_date_time | DateTime |
The wall clock time when the source epoch started |
| source_root | FixedString(66) |
The source beacon block root hash in the beacon API event stream payload |
| target_epoch | UInt32 |
The target epoch number in the beacon API event stream payload |
| target_epoch_start_date_time | DateTime |
The wall clock time when the target epoch started |
| target_root | FixedString(66) |
The target beacon block root hash in the beacon API event stream payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_blob_sidecar #
Contains beacon API eventstream “blob_sidecar” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-03-13to2024-07-24 - holesky:
2024-02-07to2024-07-24 - sepolia:
2024-01-30to2024-07-24
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_blob_sidecar/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_blob_sidecar FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
Slot number in the beacon API event stream payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| propagation_slot_start_diff | UInt32 |
The difference between the event_date_time and the slot_start_date_time |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The beacon block root hash in the beacon API event stream payload |
| blob_index | UInt64 |
The index of blob sidecar in the beacon API event stream payload |
| kzg_commitment | FixedString(98) |
The KZG commitment in the beacon API event stream payload |
| versioned_hash | FixedString(66) |
The versioned hash in the beacon API event stream payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_block #
Contains beacon API eventstream “block” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-02-28to2024-07-24 - holesky:
2023-12-24to2024-07-24 - sepolia:
2023-12-24to2024-07-24
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_block/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_block FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
Slot number in the beacon API event stream payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| propagation_slot_start_diff | UInt32 |
The difference between the event_date_time and the slot_start_date_time |
| block | FixedString(66) |
The beacon block root hash in the beacon API event stream payload |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| execution_optimistic | Bool |
If the attached beacon node is running in execution optimistic mode |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_chain_reorg #
Contains beacon API eventstream “chain reorg” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-03-01to2024-07-24 - holesky:
2024-02-05to2024-07-24 - sepolia:
2024-05-23to2024-07-24
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_chain_reorg/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_chain_reorg FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
The slot number of the chain reorg event in the beacon API event stream payload |
| slot_start_date_time | DateTime |
The wall clock time when the reorg slot started |
| propagation_slot_start_diff | UInt32 |
Difference in slots between when the reorg occurred and when the sentry received the event |
| depth | UInt16 |
The depth of the chain reorg in the beacon API event stream payload |
| old_head_block | FixedString(66) |
The old head block root hash in the beacon API event stream payload |
| new_head_block | FixedString(66) |
The new head block root hash in the beacon API event stream payload |
| old_head_state | FixedString(66) |
The old head state root hash in the beacon API event stream payload |
| new_head_state | FixedString(66) |
The new head state root hash in the beacon API event stream payload |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| execution_optimistic | Bool |
Whether the execution of the epoch was optimistic |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_contribution_and_proof #
Contains beacon API eventstream “contribution and proof” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on contribution_slot_start_date_time for the following networks:
- mainnet:
2023-08-31to2024-07-24 - holesky:
2023-12-24to2024-07-24 - sepolia:
2023-12-24to2024-07-24
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_contribution_and_proof/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_contribution_and_proof FINAL WHERE contribution_slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| aggregator_index | UInt32 |
The validator index of the aggregator in the beacon API event stream payload |
| contribution_slot | UInt32 |
The slot number of the contribution in the beacon API event stream payload |
| contribution_slot_start_date_time | DateTime |
The wall clock time when the contribution slot started |
| contribution_propagation_slot_start_diff | UInt32 |
Difference in slots between when the contribution occurred and when the sentry received the event |
| contribution_beacon_block_root | FixedString(66) |
The beacon block root hash in the beacon API event stream payload |
| contribution_subcommittee_index | LowCardinality(String) |
The subcommittee index of the contribution in the beacon API event stream payload |
| contribution_aggregation_bits | String |
The aggregation bits of the contribution in the beacon API event stream payload |
| contribution_signature | String |
The signature of the contribution in the beacon API event stream payload |
| contribution_epoch | UInt32 |
The epoch number of the contribution in the beacon API event stream payload |
| contribution_epoch_start_date_time | DateTime |
The wall clock time when the contribution epoch started |
| selection_proof | String |
The selection proof in the beacon API event stream payload |
| signature | String |
The signature in the beacon API event stream payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_finalized_checkpoint #
Contains beacon API eventstream “finalized checkpoint” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on epoch_start_date_time for the following networks:
- mainnet:
2023-04-10to2024-07-23 - holesky:
2023-03-26to2024-07-23 - sepolia:
2023-03-26to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_finalized_checkpoint/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_finalized_checkpoint FINAL WHERE epoch_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| block | FixedString(66) |
The finalized block root hash in the beacon API event stream payload |
| state | FixedString(66) |
The finalized state root hash in the beacon API event stream payload |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| execution_optimistic | Bool |
Whether the execution of the epoch was optimistic |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_head #
Contains beacon API eventstream “head” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-08-30to2024-07-23 - holesky:
2023-12-05to2024-07-23 - sepolia:
2023-12-05to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_head/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_head FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
Slot number in the beacon API event stream payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| propagation_slot_start_diff | UInt32 |
The difference between the event_date_time and the slot_start_date_time |
| block | FixedString(66) |
The beacon block root hash in the beacon API event stream payload |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| epoch_transition | Bool |
If the event is an epoch transition |
| execution_optimistic | Bool |
If the attached beacon node is running in execution optimistic mode |
| previous_duty_dependent_root | FixedString(66) |
The previous duty dependent root in the beacon API event stream payload |
| current_duty_dependent_root | FixedString(66) |
The current duty dependent root in the beacon API event stream payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_events_voluntary_exit #
Contains beacon API eventstream “voluntary exit” data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on wallclock_epoch_start_date_time for the following networks:
- mainnet:
2024-01-01to2024-07-23 - holesky:
2023-10-01to2024-07-23 - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_events_voluntary_exit/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_events_voluntary_exit FINAL WHERE wallclock_epoch_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| epoch | UInt32 |
The epoch number in the beacon API event stream payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| 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 |
| validator_index | UInt32 |
The index of the validator making the voluntary exit |
| signature | String |
The signature of the voluntary exit in the beacon API event stream payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_validator_attestation_data #
Contains beacon API validator attestation data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-08-31to2024-07-23 - holesky:
2023-12-24to2024-07-23 - sepolia:
2023-12-24to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_validator_attestation_data/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_validator_attestation_data FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry received the event from a beacon node |
| slot | UInt32 |
Slot number in the beacon API validator attestation data payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| committee_index | LowCardinality(String) |
The committee index in the beacon API validator attestation data payload |
| beacon_block_root | FixedString(66) |
The beacon block root hash in the beacon API validator attestation data payload |
| epoch | UInt32 |
The epoch number in the beacon API validator attestation data payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| source_epoch | UInt32 |
The source epoch number in the beacon API validator attestation data payload |
| source_epoch_start_date_time | DateTime |
The wall clock time when the source epoch started |
| source_root | FixedString(66) |
The source beacon block root hash in the beacon API validator attestation data payload |
| target_epoch | UInt32 |
The target epoch number in the beacon API validator attestation data payload |
| target_epoch_start_date_time | DateTime |
The wall clock time when the target epoch started |
| target_root | FixedString(66) |
The target beacon block root hash in the beacon API validator attestation data payload |
| request_date_time | DateTime |
When the request was sent to the beacon node |
| request_duration | UInt32 |
The request duration in milliseconds |
| request_slot_start_diff | UInt32 |
The difference between the request_date_time and the slot_start_date_time |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v2_beacon_block #
Contains beacon API /eth/v2/beacon/blocks/{block_id} data from each sentry client attached to a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-11-14to2024-07-23 - holesky:
2023-12-24to2024-07-23 - sepolia:
2023-12-24to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v2_beacon_block/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v2_beacon_block FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
When the sentry fetched the beacon block from a beacon node |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the reorg slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| block_total_bytes | Nullable(UInt32) |
The total bytes of the beacon block payload |
| block_total_bytes_compressed | Nullable(UInt32) |
The total bytes of the beacon block payload when compressed using snappy |
| parent_root | FixedString(66) |
The root hash of the parent beacon block |
| state_root | FixedString(66) |
The root hash of the beacon state at this block |
| proposer_index | UInt32 |
The index of the validator that proposed the beacon block |
| eth1_data_block_hash | FixedString(66) |
The block hash of the associated execution block |
| eth1_data_deposit_root | FixedString(66) |
The root of the deposit tree in the associated execution block |
| execution_payload_block_hash | FixedString(66) |
The block hash of the execution payload |
| execution_payload_block_number | UInt32 |
The block number of the execution payload |
| execution_payload_fee_recipient | String |
The recipient of the fee for this execution payload |
| execution_payload_state_root | FixedString(66) |
The state root of the execution payload |
| execution_payload_parent_hash | FixedString(66) |
The parent hash of the execution payload |
| execution_payload_transactions_count | Nullable(UInt32) |
The transaction count of the execution payload |
| execution_payload_transactions_total_bytes | Nullable(UInt32) |
The transaction total bytes of the execution payload |
| execution_payload_transactions_total_bytes_compressed | Nullable(UInt32) |
The transaction total bytes of the execution payload when compressed using snappy |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
mempool_transaction #
Each row represents a transaction that was seen in the mempool by a sentry client. Sentries can report the same transaction multiple times if it has been long enough since the last report.
Availability #
Data is partitioned daily on event_date_time for the following networks:
- mainnet:
2023-07-22to2024-07-23 - holesky:
2024-01-08to2024-07-23 - sepolia:
2024-01-08to2024-07-23
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/mempool_transaction/YYYY/MM/DD.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/mempool_transaction/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.mempool_transaction FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
The time when the sentry saw the transaction in the mempool |
| hash | FixedString(66) |
The hash of the transaction |
| from | FixedString(42) |
The address of the account that sent the transaction |
| to | Nullable(FixedString(42)) |
The address of the account that is the transaction recipient |
| nonce | UInt64 |
The nonce of the sender account at the time of the transaction |
| gas_price | UInt128 |
The gas price of the transaction in wei |
| gas | UInt64 |
The maximum gas provided for the transaction execution |
| gas_tip_cap | Nullable(UInt128) |
The priority fee (tip) the user has set for the transaction |
| gas_fee_cap | Nullable(UInt128) |
The max fee the user has set for the transaction |
| value | UInt128 |
The value transferred with the transaction in wei |
| type | Nullable(UInt8) |
The type of the transaction |
| size | UInt32 |
The size of the transaction data in bytes |
| call_data_size | UInt32 |
The size of the call data of the transaction in bytes |
| blob_gas | Nullable(UInt64) |
The maximum gas provided for the blob transaction execution |
| blob_gas_fee_cap | Nullable(UInt128) |
The max fee the user has set for the transaction |
| blob_hashes | Array(String) |
The hashes of the blob commitments for blob transactions |
| blob_sidecars_size | Nullable(UInt32) |
The total size of the sidecars for blob transactions in bytes |
| blob_sidecars_empty_size | Nullable(UInt32) |
The total empty size of the sidecars for blob transactions in bytes |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_execution_fork_id_hash | LowCardinality(String) |
The hash of the fork ID of the current Ethereum network |
| meta_execution_fork_id_next | LowCardinality(String) |
The fork ID of the next planned Ethereum network upgrade |
| meta_labels | Map(String, String) |
Labels associated with the event |
beacon_api_eth_v1_proposer_duty #
Contains a proposer duty from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-04-03to2024-07-23 - holesky:
2024-04-03to2024-07-23 - sepolia:
2024-04-03to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/beacon_api_eth_v1_proposer_duty/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.beacon_api_eth_v1_proposer_duty FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| event_date_time | DateTime64(3) |
When the client fetched the beacon block from a beacon node |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| proposer_validator_index | UInt32 |
The validator index from the proposer duty payload |
| proposer_pubkey | String |
The BLS public key of the validator from the proposer duty payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block #
Contains beacon block from a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-24 - holesky:
2023-09-23to2024-07-24 - sepolia:
2022-06-20to2024-07-24
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block/YYYY/MM/DD.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| block_total_bytes | Nullable(UInt32) |
The total bytes of the beacon block payload |
| block_total_bytes_compressed | Nullable(UInt32) |
The total bytes of the beacon block payload when compressed using snappy |
| parent_root | FixedString(66) |
The root hash of the parent beacon block |
| state_root | FixedString(66) |
The root hash of the beacon state at this block |
| proposer_index | UInt32 |
The index of the validator that proposed the beacon block |
| eth1_data_block_hash | FixedString(66) |
The block hash of the associated execution block |
| eth1_data_deposit_root | FixedString(66) |
The root of the deposit tree in the associated execution block |
| execution_payload_block_hash | FixedString(66) |
The block hash of the execution payload |
| execution_payload_block_number | UInt32 |
The block number of the execution payload |
| execution_payload_fee_recipient | String |
The recipient of the fee for this execution payload |
| execution_payload_state_root | FixedString(66) |
The state root of the execution payload |
| execution_payload_parent_hash | FixedString(66) |
The parent hash of the execution payload |
| execution_payload_transactions_count | Nullable(UInt32) |
The transaction count of the execution payload |
| execution_payload_transactions_total_bytes | Nullable(UInt32) |
The transaction total bytes of the execution payload |
| execution_payload_transactions_total_bytes_compressed | Nullable(UInt32) |
The transaction total bytes of the execution payload when compressed using snappy |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_attester_slashing #
Contains attester slashing from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-24 - holesky:
2023-09-23to2024-07-24 - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_attester_slashing/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_attester_slashing FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| attestation_1_attesting_indices | Array(UInt32) |
The attesting indices from the first attestation in the slashing payload |
| attestation_1_signature | String |
The signature from the first attestation in the slashing payload |
| attestation_1_data_beacon_block_root | FixedString(66) |
The beacon block root from the first attestation in the slashing payload |
| attestation_1_data_slot | UInt32 |
The slot number from the first attestation in the slashing payload |
| attestation_1_data_index | UInt32 |
The attestor index from the first attestation in the slashing payload |
| attestation_1_data_source_epoch | UInt32 |
The source epoch number from the first attestation in the slashing payload |
| attestation_1_data_source_root | FixedString(66) |
The source root from the first attestation in the slashing payload |
| attestation_1_data_target_epoch | UInt32 |
The target epoch number from the first attestation in the slashing payload |
| attestation_1_data_target_root | FixedString(66) |
The target root from the first attestation in the slashing payload |
| attestation_2_attesting_indices | Array(UInt32) |
The attesting indices from the second attestation in the slashing payload |
| attestation_2_signature | String |
The signature from the second attestation in the slashing payload |
| attestation_2_data_beacon_block_root | FixedString(66) |
The beacon block root from the second attestation in the slashing payload |
| attestation_2_data_slot | UInt32 |
The slot number from the second attestation in the slashing payload |
| attestation_2_data_index | UInt32 |
The attestor index from the second attestation in the slashing payload |
| attestation_2_data_source_epoch | UInt32 |
The source epoch number from the second attestation in the slashing payload |
| attestation_2_data_source_root | FixedString(66) |
The source root from the second attestation in the slashing payload |
| attestation_2_data_target_epoch | UInt32 |
The target epoch number from the second attestation in the slashing payload |
| attestation_2_data_target_root | FixedString(66) |
The target root from the second attestation in the slashing payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_proposer_slashing #
Contains proposer slashing from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-24 - holesky:
2023-09-23to2024-07-24 - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_proposer_slashing/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_proposer_slashing FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| signed_header_1_message_slot | UInt32 |
The slot number from the first signed header in the slashing payload |
| signed_header_1_message_proposer_index | UInt32 |
The proposer index from the first signed header in the slashing payload |
| signed_header_1_message_body_root | FixedString(66) |
The body root from the first signed header in the slashing payload |
| signed_header_1_message_parent_root | FixedString(66) |
The parent root from the first signed header in the slashing payload |
| signed_header_1_message_state_root | FixedString(66) |
The state root from the first signed header in the slashing payload |
| signed_header_1_signature | String |
The signature for the first signed header in the slashing payload |
| signed_header_2_message_slot | UInt32 |
The slot number from the second signed header in the slashing payload |
| signed_header_2_message_proposer_index | UInt32 |
The proposer index from the second signed header in the slashing payload |
| signed_header_2_message_body_root | FixedString(66) |
The body root from the second signed header in the slashing payload |
| signed_header_2_message_parent_root | FixedString(66) |
The parent root from the second signed header in the slashing payload |
| signed_header_2_message_state_root | FixedString(66) |
The state root from the second signed header in the slashing payload |
| signed_header_2_signature | String |
The signature for the second signed header in the slashing payload |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_bls_to_execution_change #
Contains bls to execution change from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-04-12to2024-07-24 - holesky:
2023-09-28to2024-07-24 - sepolia:
2022-06-22to2024-07-24
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_bls_to_execution_change/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_bls_to_execution_change FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| exchanging_message_validator_index | UInt32 |
The validator index from the exchanging message |
| exchanging_message_from_bls_pubkey | String |
The BLS public key from the exchanging message |
| exchanging_message_to_execution_address | FixedString(42) |
The execution address from the exchanging message |
| exchanging_signature | String |
The signature for the exchanging message |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_execution_transaction #
Contains execution transaction from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2022-09-06to2024-07-24 - holesky:
2023-09-23to2024-07-24 - sepolia:
2022-06-22to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_execution_transaction/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_execution_transaction FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| position | UInt32 |
The position of the transaction in the beacon block |
| hash | FixedString(66) |
The hash of the transaction |
| from | FixedString(42) |
The address of the account that sent the transaction |
| to | Nullable(FixedString(42)) |
The address of the account that is the transaction recipient |
| nonce | UInt64 |
The nonce of the sender account at the time of the transaction |
| gas_price | UInt128 |
The gas price of the transaction in wei |
| gas | UInt64 |
The maximum gas provided for the transaction execution |
| gas_tip_cap | Nullable(UInt128) |
The priority fee (tip) the user has set for the transaction |
| gas_fee_cap | Nullable(UInt128) |
The max fee the user has set for the transaction |
| value | UInt128 |
The value transferred with the transaction in wei |
| type | UInt8 |
The type of the transaction |
| size | UInt32 |
The size of the transaction data in bytes |
| call_data_size | UInt32 |
The size of the call data of the transaction in bytes |
| blob_gas | Nullable(UInt64) |
The maximum gas provided for the blob transaction execution |
| blob_gas_fee_cap | Nullable(UInt128) |
The max fee the user has set for the transaction |
| blob_hashes | Array(String) |
The hashes of the blob commitments for blob transactions |
| blob_sidecars_size | Nullable(UInt32) |
The total size of the sidecars for blob transactions in bytes |
| blob_sidecars_empty_size | Nullable(UInt32) |
The total empty size of the sidecars for blob transactions in bytes |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_voluntary_exit #
Contains a voluntary exit from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-23 - holesky:
2023-09-23to2024-07-23 - sepolia:
2022-06-22to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_voluntary_exit/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_voluntary_exit FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| voluntary_exit_message_epoch | UInt32 |
The epoch number from the exit message |
| voluntary_exit_message_validator_index | UInt32 |
The validator index from the exit message |
| voluntary_exit_signature | String |
The signature of the exit message |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_deposit #
Contains a deposit from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-23 - holesky:
2023-09-23to2024-07-23 - sepolia:
2022-06-22to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_deposit/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_deposit FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| deposit_proof | Array(String) |
The proof of the deposit data |
| deposit_data_pubkey | String |
The BLS public key of the validator from the deposit data |
| deposit_data_withdrawal_credentials | FixedString(66) |
The withdrawal credentials of the validator from the deposit data |
| deposit_data_amount | UInt128 |
The amount of the deposit from the deposit data |
| deposit_data_signature | String |
The signature of the deposit data |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_block_withdrawal #
Contains a withdrawal from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-04-12to2024-07-23 - holesky:
2023-09-23to2024-07-23 - sepolia:
2023-02-28to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_withdrawal/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_block_withdrawal FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_version | LowCardinality(String) |
The version of the beacon block |
| withdrawal_index | UInt32 |
The index of the withdrawal |
| withdrawal_validator_index | UInt32 |
The validator index from the withdrawal data |
| withdrawal_address | FixedString(42) |
The address of the account that is the withdrawal recipient |
| withdrawal_amount | UInt128 |
The amount of the withdrawal from the withdrawal data |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_blob_sidecar #
Contains a blob sidecar from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-03-13to2024-07-23 - holesky:
2024-02-07to2024-07-23 - sepolia:
2024-01-30to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_blob_sidecar/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_blob_sidecar FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number from beacon block payload |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number from beacon block payload |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| block_root | FixedString(66) |
The root hash of the beacon block |
| block_parent_root | FixedString(66) |
The root hash of the parent beacon block |
| versioned_hash | FixedString(66) |
The versioned hash in the beacon API event stream payload |
| kzg_commitment | FixedString(98) |
The KZG commitment in the blob sidecar payload |
| kzg_proof | FixedString(98) |
The KZG proof in the blob sidecar payload |
| proposer_index | UInt32 |
The index of the validator that proposed the beacon block |
| blob_index | UInt64 |
The index of blob sidecar in the blob sidecar payload |
| blob_size | UInt32 |
The total bytes of the blob |
| blob_empty_size | Nullable(UInt32) |
The total empty size of the blob in bytes |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
canonical_beacon_proposer_duty #
Contains a proposer duty from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-23 - holesky:
2023-09-23to2024-07-23 - sepolia:
2022-06-20to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_proposer_duty/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_proposer_duty FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| slot | UInt32 |
The slot number for which the proposer duty is assigned |
| slot_start_date_time | DateTime |
The wall clock time when the slot started |
| epoch | UInt32 |
The epoch number containing the slot |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| proposer_validator_index | UInt32 |
The validator index of the proposer for the slot |
| proposer_pubkey | String |
The public key of the validator proposer |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the even |
canonical_beacon_elaborated_attestation #
Contains elaborated attestations from beacon blocks.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-07-23 - holesky:
2023-09-23to2024-07-23 - sepolia:
2022-06-22to2024-07-23
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_elaborated_attestation/2024/7/19.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.canonical_beacon_elaborated_attestation FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
When this row was last updated |
| block_slot | UInt32 |
The slot number of the block containing the attestation |
| block_slot_start_date_time | DateTime |
The wall clock time when the block slot started |
| block_epoch | UInt32 |
The epoch number of the block containing the attestation |
| block_epoch_start_date_time | DateTime |
The wall clock time when the block epoch started |
| position_in_block | UInt32 |
The position of the attestation in the block |
| block_root | FixedString(66) |
The root of the block containing the attestation |
| validators | Array(UInt32) |
Array of validator indices participating in the attestation |
| committee_index | LowCardinality(String) |
The index of the committee making the attestation |
| beacon_block_root | FixedString(66) |
The root of the beacon block being attested to |
| slot | UInt32 |
The slot number being attested to |
| slot_start_date_time | DateTime |
** |
| epoch | UInt32 |
** |
| epoch_start_date_time | DateTime |
** |
| source_epoch | UInt32 |
The source epoch referenced in the attestation |
| source_epoch_start_date_time | DateTime |
The wall clock time when the source epoch started |
| source_root | FixedString(66) |
The root of the source checkpoint in the attestation |
| target_epoch | UInt32 |
The target epoch referenced in the attestation |
| target_epoch_start_date_time | DateTime |
The wall clock time when the target epoch started |
| target_root | FixedString(66) |
The root of the target checkpoint in the attestation |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
| meta_consensus_version | LowCardinality(String) |
Ethereum consensus client version that generated the event |
| meta_consensus_version_major | LowCardinality(String) |
Ethereum consensus client major version that generated the event |
| meta_consensus_version_minor | LowCardinality(String) |
Ethereum consensus client minor version that generated the event |
| meta_consensus_version_patch | LowCardinality(String) |
Ethereum consensus client patch version that generated the event |
| meta_consensus_implementation | LowCardinality(String) |
Ethereum consensus client implementation that generated the event |
| meta_labels | Map(String, String) |
Labels associated with the event |
libp2p_add_peer #
Contains the details of the peers added to the libp2p client.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_add_peer/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_add_peer/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_add_peer FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 |
| protocol | LowCardinality(String) |
Protocol used by the peer |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_connected #
Contains the details of the CONNECTED events from the libp2p client.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_connected/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_connected/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_connected FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 | UInt16 |
Port of the remote peer |
| remote_ip | Nullable(IPv6) |
IP address of the remote peer that generated the event |
| remote_geo_city | LowCardinality(String) |
City of the remote peer that generated the event |
| remote_geo_country | LowCardinality(String) |
Country of the remote peer that generated the event |
| remote_geo_country_code | LowCardinality(String) |
Country code of the remote peer that generated the event |
| remote_geo_continent_code | LowCardinality(String) |
Continent code of the remote peer that generated the event |
| remote_geo_longitude | Nullable(Float64) |
Longitude of the remote peer that generated the event |
| remote_geo_latitude | Nullable(Float64) |
Latitude of the remote peer that generated the event |
| remote_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the remote peer that generated the event |
| remote_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the remote peer that generated the event |
| remote_agent_implementation | LowCardinality(String) |
Implementation of the remote peer |
| remote_agent_version | LowCardinality(String) |
Version of the remote peer |
| remote_agent_version_major | LowCardinality(String) |
Major version of the remote peer |
| remote_agent_version_minor | LowCardinality(String) |
Minor version of the remote peer |
| remote_agent_version_patch | LowCardinality(String) |
Patch version of the remote peer |
| remote_agent_platform | LowCardinality(String) |
Platform of the remote peer |
| direction | LowCardinality(String) |
Connection direction |
| opened | DateTime |
Timestamp when the connection was opened |
| transient | Bool |
Whether the connection is transient |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_disconnected #
Contains the details of the DISCONNECTED events from the libp2p client.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_disconnected/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_disconnected/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_disconnected FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 | UInt16 |
Port of the remote peer |
| remote_ip | Nullable(IPv6) |
IP address of the remote peer that generated the event |
| remote_geo_city | LowCardinality(String) |
City of the remote peer that generated the event |
| remote_geo_country | LowCardinality(String) |
Country of the remote peer that generated the event |
| remote_geo_country_code | LowCardinality(String) |
Country code of the remote peer that generated the event |
| remote_geo_continent_code | LowCardinality(String) |
Continent code of the remote peer that generated the event |
| remote_geo_longitude | Nullable(Float64) |
Longitude of the remote peer that generated the event |
| remote_geo_latitude | Nullable(Float64) |
Latitude of the remote peer that generated the event |
| remote_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the remote peer that generated the event |
| remote_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the remote peer that generated the event |
| remote_agent_implementation | LowCardinality(String) |
Implementation of the remote peer |
| remote_agent_version | LowCardinality(String) |
Version of the remote peer |
| remote_agent_version_major | LowCardinality(String) |
Major version of the remote peer |
| remote_agent_version_minor | LowCardinality(String) |
Minor version of the remote peer |
| remote_agent_version_patch | LowCardinality(String) |
Patch version of the remote peer |
| remote_agent_platform | LowCardinality(String) |
Platform of the remote peer |
| direction | LowCardinality(String) |
Connection direction |
| opened | DateTime |
Timestamp when the connection was opened |
| transient | Bool |
Whether the connection is transient |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_gossipsub_beacon_attestation #
Table for libp2p gossipsub beacon attestation data.
Availability #
Data is partitioned hourly on slot_start_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_beacon_attestation/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_gossipsub_beacon_attestation FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| version | UInt32 |
Version of this row, to help with de-duplication we want the latest updated_date_time but lowest propagation_slot_start_diff time |
| event_date_time | DateTime64(3) |
Timestamp of the event with millisecond precision |
| slot | UInt32 |
Slot number associated with the event |
| slot_start_date_time | DateTime |
Start date and time of the slot |
| epoch | UInt32 |
The epoch number in the attestation |
| epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
| committee_index | LowCardinality(String) |
The committee index in the attestation |
| attesting_validator_index | Nullable(UInt32) |
The index of the validator attesting to the event |
| attesting_validator_committee_index | LowCardinality(String) |
The committee index of the attesting validator |
| wallclock_slot | UInt32 |
Slot number of the wall clock when the event was received |
| wallclock_slot_start_date_time | DateTime |
Start date and time of the wall clock slot when the event was received |
| wallclock_epoch | UInt32 |
Epoch number of the wall clock when the event was received |
| wallclock_epoch_start_date_time | DateTime |
Start date and time of the wall clock epoch when the event was received |
| propagation_slot_start_diff | UInt32 |
Difference in slot start time for propagation |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer |
| message_id | String |
Identifier of the message |
| message_size | UInt32 |
Size of the message in bytes |
| topic_layer | LowCardinality(String) |
Layer of the topic in the gossipsub protocol |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding used for the topic |
| aggregation_bits | String |
The aggregation bits of the event in the attestation |
| beacon_block_root | FixedString(66) |
The beacon block root hash in the attestation |
| source_epoch | UInt32 |
The source epoch number in the attestation |
| source_epoch_start_date_time | DateTime |
The wall clock time when the source epoch started |
| source_root | FixedString(66) |
The source beacon block root hash in the attestation |
| target_epoch | UInt32 |
The target epoch number in the attestation |
| target_epoch_start_date_time | DateTime |
The wall clock time when the target epoch started |
| target_root | FixedString(66) |
The target beacon block root hash in the attestation |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Network ID associated with the client |
| meta_network_name | LowCardinality(String) |
Name of the network associated with the client |
libp2p_gossipsub_beacon_block #
Table for libp2p gossipsub beacon block data.
Availability #
Data is partitioned hourly on slot_start_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_gossipsub_beacon_block/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_gossipsub_beacon_block FINAL WHERE slot_start_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| version | UInt32 |
Version of this row, to help with de-duplication we want the latest updated_date_time but lowest propagation_slot_start_diff time |
| event_date_time | DateTime64(3) |
Timestamp of the event with millisecond precision |
| slot | UInt32 |
Slot number associated with the event |
| slot_start_date_time | DateTime |
Start date and time of the slot |
| epoch | UInt32 |
Epoch number associated with the event |
| epoch_start_date_time | DateTime |
Start date and time of the epoch |
| wallclock_slot | UInt32 |
Slot number of the wall clock when the event was received |
| wallclock_slot_start_date_time | DateTime |
Start date and time of the wall clock slot when the event was received |
| wallclock_epoch | UInt32 |
Epoch number of the wall clock when the event was received |
| wallclock_epoch_start_date_time | DateTime |
Start date and time of the wall clock epoch when the event was received |
| propagation_slot_start_diff | UInt32 |
Difference in slot start time for propagation |
| block | FixedString(66) |
The beacon block root hash |
| proposer_index | UInt32 |
The proposer index of the beacon block |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer |
| message_id | String |
Identifier of the message |
| message_size | UInt32 |
Size of the message in bytes |
| topic_layer | LowCardinality(String) |
Layer of the topic in the gossipsub protocol |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding used for the topic |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Network ID associated with the client |
| meta_network_name | LowCardinality(String) |
Name of the network associated with the client |
libp2p_handle_metadata #
Contains the metadata handling events for libp2p peers.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_handle_metadata/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_handle_metadata FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 |
| attnets | String |
Attestation subnets the peer is subscribed to |
| seq_number | UInt64 |
Sequence number of the metadata |
| syncnets | String |
Sync subnets the peer is subscribed to |
| latency_milliseconds | Decimal(10, 3) |
How long it took to handle the metadata request in milliseconds |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_handle_status #
Contains the status handling events for libp2p peers.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_handle_status/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_handle_status FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 |
| request_finalized_epoch | Nullable(UInt32) |
Requested finalized epoch |
| request_finalized_root | Nullable(String) |
Requested finalized root |
| request_fork_digest | LowCardinality(String) |
Requested fork digest |
| request_head_root | Nullable(FixedString(66)) |
Requested head root |
| request_head_slot | Nullable(UInt32) |
Requested head slot |
| response_finalized_epoch | Nullable(UInt32) |
Response finalized epoch |
| response_finalized_root | Nullable(FixedString(66)) |
Response finalized root |
| response_fork_digest | LowCardinality(String) |
Response fork digest |
| response_head_root | Nullable(FixedString(66)) |
Response head root |
| response_head_slot | Nullable(UInt32) |
Response head slot |
| latency_milliseconds | Decimal(10, 3) |
How long it took to handle the status request in milliseconds |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_join #
Contains the details of the JOIN events from the libp2p client.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_join/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_join/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_join FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 associated with the identifier of the peer that joined the topic |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_peer #
Contains the original peer id of a seahashed peer_id + meta_network_name, commonly seen in other tables as the field peer_id_unique_key
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_peer/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_peer/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_peer FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each record, seahash of peer_id + meta_network_name |
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| peer_id | String |
Peer ID |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_recv_rpc #
Contains the details of the RPC messages received by the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_recv_rpc/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_recv_rpc/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_recv_rpc FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each record |
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the event |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer sender |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_remove_peer #
Contains the details of the peers removed from the libp2p client.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_remove_peer/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_remove_peer/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_remove_peer FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
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 |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_rpc_meta_control_graft #
Contains the details of the “Graft” control messages from the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_graft/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_rpc_meta_control_graft FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each “Graft” control record |
| updated_date_time | DateTime |
Timestamp when the “Graft” control record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the “Graft” control event |
| control_index | Int32 |
Position in the RPC meta control GRAFT array |
| rpc_meta_unique_key | Int64 |
Unique key associated with the “Graft” control metadata |
| topic_layer | LowCardinality(String) |
Layer of the topic |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding of the topic |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer involved in the Graft control |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_rpc_meta_control_ihave #
Contains the details of the “I have” control messages from the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_ihave/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_rpc_meta_control_ihave FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each “I have” control record |
| updated_date_time | DateTime |
Timestamp when the “I have” control record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the “I have” control event |
| rpc_meta_unique_key | Int64 |
Unique key associated with the “I have” control metadata |
| message_index | Int32 |
Position in the RPC meta control IWANT message_ids array |
| control_index | Int32 |
Position in the RPC meta control IWANT array |
| topic_layer | LowCardinality(String) |
Layer of the topic |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding of the topic |
| message_id | String |
Identifier of the message associated with the “I have” control |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer involved in the I have control |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_rpc_meta_control_iwant #
Contains the details of the “I want” control messages from the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_iwant/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_rpc_meta_control_iwant FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each “I want” control record |
| updated_date_time | DateTime |
Timestamp when the “I want” control record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the “I want” control event |
| control_index | Int32 |
Position in the RPC meta control IWANT array |
| message_index | Int32 |
Position in the RPC meta control IWANT message_ids array |
| rpc_meta_unique_key | Int64 |
Unique key associated with the “I want” control metadata |
| message_id | String |
Identifier of the message associated with the “I want” control |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer involved in the I want control |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_rpc_meta_control_prune #
Contains the details of the “Prune” control messages from the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_control_prune/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_rpc_meta_control_prune FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each “Prune” control record |
| updated_date_time | DateTime |
Timestamp when the “Prune” control record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the “Prune” control event |
| control_index | Int32 |
Position in the RPC meta control PRUNE array |
| rpc_meta_unique_key | Int64 |
Unique key associated with the “Prune” control metadata |
| peer_id_index | Int32 |
** |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer involved in the Prune control |
| graft_peer_id_unique_key | Int64 |
Unique key associated with the identifier of the graft peer involved in the Prune control |
| topic_layer | LowCardinality(String) |
Layer of the topic |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding of the topic |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_rpc_meta_message #
Contains the details of the RPC meta messages from the peer
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_message/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_rpc_meta_message FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each RPC message record |
| updated_date_time | DateTime |
Timestamp when the RPC message record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the RPC event |
| control_index | Int32 |
Position in the RPC meta message array |
| rpc_meta_unique_key | Int64 |
Unique key associated with the RPC metadata |
| message_id | String |
Identifier of the message |
| topic_layer | LowCardinality(String) |
Layer of the topic |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding of the topic |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer involved in the RPC |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_rpc_meta_subscription #
Contains the details of the RPC subscriptions from the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_rpc_meta_subscription/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_rpc_meta_subscription FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each RPC subscription record |
| updated_date_time | DateTime |
Timestamp when the RPC subscription record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the RPC subscription event |
| control_index | Int32 |
Position in the RPC meta subscription array |
| rpc_meta_unique_key | Int64 |
Unique key associated with the RPC subscription metadata |
| subscribe | Bool |
Boolean indicating if it is a subscription or unsubscription |
| topic_layer | LowCardinality(String) |
Layer of the topic |
| topic_fork_digest_value | LowCardinality(String) |
Fork digest value of the topic |
| topic_name | LowCardinality(String) |
Name of the topic |
| topic_encoding | LowCardinality(String) |
Encoding of the topic |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer involved in the subscription |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |
libp2p_send_rpc #
Contains the details of the RPC messages sent by the peer.
Availability #
Data is partitioned hourly on event_date_time for the following networks:
- mainnet:
nulltonull - holesky:
nulltonull - sepolia:
nulltonull
Example - parquet file #
https://data.ethpandaops.io/xatu/NETWORK/databases/default/libp2p_send_rpc/YYYY/MM/DD/HH.parquet
clickhouse client -q "SELECT * FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/libp2p_send_rpc/2024/7/19/0.parquet', 'Parquet') LIMIT 10"
Example - clickhouse table #
Note:
FINALshould be used when querying this table
clickhouse client -q "SELECT * FROM default.libp2p_send_rpc FINAL WHERE event_date_time >= NOW() - INTERVAL '1 HOUR' LIMIT 10"
Columns #
| Name | Type | Description |
|---|---|---|
| unique_key | Int64 |
Unique identifier for each record |
| updated_date_time | DateTime |
Timestamp when the record was last updated |
| event_date_time | DateTime64(3) |
Timestamp of the event |
| peer_id_unique_key | Int64 |
Unique key associated with the identifier of the peer receiver |
| meta_client_name | LowCardinality(String) |
Name of the client that generated the event |
| meta_client_id | String |
Unique Session ID of the client that generated the event. This changes every time the client is restarted. |
| meta_client_version | LowCardinality(String) |
Version of the client that generated the event |
| meta_client_implementation | LowCardinality(String) |
Implementation of the client that generated the event |
| meta_client_os | LowCardinality(String) |
Operating system of the client that generated the event |
| meta_client_ip | Nullable(IPv6) |
IP address of the client that generated the event |
| meta_client_geo_city | LowCardinality(String) |
City of the client that generated the event |
| meta_client_geo_country | LowCardinality(String) |
Country of the client that generated the event |
| meta_client_geo_country_code | LowCardinality(String) |
Country code of the client that generated the event |
| meta_client_geo_continent_code | LowCardinality(String) |
Continent code of the client that generated the event |
| meta_client_geo_longitude | Nullable(Float64) |
Longitude of the client that generated the event |
| meta_client_geo_latitude | Nullable(Float64) |
Latitude of the client that generated the event |
| meta_client_geo_autonomous_system_number | Nullable(UInt32) |
Autonomous system number of the client that generated the event |
| meta_client_geo_autonomous_system_organization | Nullable(String) |
Autonomous system organization of the client that generated the event |
| meta_network_id | Int32 |
Ethereum network ID |
| meta_network_name | LowCardinality(String) |
Ethereum network name |