Xatu - Canonical Beacon chain events
canonical_beacon_ #
Events derived from the finalized beacon chain
Availability #
- EthPandaOps Clickhouse
- Public Parquet Files
Tables #
-
canonical_beacon_block -
canonical_beacon_committee -
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
canonical_beacon_block #
Contains beacon block from a beacon node.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-20to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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_committee #
Contains canonical beacon API /eth/v1/beacon/committees data.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-20to2024-10-02
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_committee/2024/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould be used when querying this table
docker run --rm -it --net host \
clickhouse/clickhouse-server clickhouse client -q \
"SELECT \
* \
FROM default.canonical_beacon_committee FINAL \
WHERE \
slot_start_date_time >= NOW() - INTERVAL '1 HOUR' \
LIMIT 10"
Example - EthPandaOps Clickhouse #
Note:
FINALshould 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_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 |
| 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 |
canonical_beacon_block_attester_slashing #
Contains attester slashing from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-22tonull
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains proposer slashing from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-22tonull
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains bls to execution change from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-04-12to2024-10-02 - holesky:
2023-09-28to2024-10-02 - sepolia:
2022-06-22to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains execution transaction from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2022-09-06to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-22to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains a voluntary exit from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-22to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains a deposit from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-22to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains a withdrawal from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-04-12to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2023-02-28to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains a blob sidecar from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-03-13to2024-10-02 - holesky:
2024-02-07to2024-10-02 - sepolia:
2024-01-30to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains a proposer duty from a beacon block.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-20to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 #
Contains elaborated attestations from beacon blocks.
Availability #
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01to2024-10-02 - holesky:
2023-09-23to2024-10-02 - sepolia:
2022-06-22to2024-10-02
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/9/27.parquet', 'Parquet') \
LIMIT 10"
Example - Your Clickhouse #
Note:
FINALshould 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:
FINALshould 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 |