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