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