Events derived from the finalized beacon chain
- EthPandaOps Clickhouse
- Public Parquet Files
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_validators
Contains beacon block from a beacon node.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-20
to2024-12-11
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 --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains canonical beacon API /eth/v1/beacon/committees data.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-12
- sepolia:
2022-06-20
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_committee/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_committee FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_committee FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains attester slashing from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
tonull
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_attester_slashing/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_attester_slashing FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_attester_slashing FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains proposer slashing from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-12
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
tonull
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_proposer_slashing/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_proposer_slashing FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_proposer_slashing FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains bls to execution change from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-04-12
to2024-12-11
- holesky:
2023-09-28
to2024-12-11
- sepolia:
2022-06-22
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_bls_to_execution_change/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_bls_to_execution_change FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_bls_to_execution_change FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains execution transaction from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2022-09-06
to2024-12-12
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_execution_transaction/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_execution_transaction FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_execution_transaction FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains a voluntary exit from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_voluntary_exit/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_voluntary_exit FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_voluntary_exit FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains a deposit from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
to2024-12-12
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_deposit/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_deposit FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_deposit FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains a withdrawal from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2023-04-12
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2023-02-28
to2024-12-12
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_block_withdrawal/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_block_withdrawal FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_block_withdrawal FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains a blob sidecar from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2024-03-13
to2024-12-12
- holesky:
2024-02-07
to2024-12-11
- sepolia:
2024-01-30
to2024-12-12
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_blob_sidecar/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_blob_sidecar FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_blob_sidecar FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains a proposer duty from a beacon block.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-12
- sepolia:
2022-06-20
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_proposer_duty/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_proposer_duty FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_proposer_duty FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains elaborated attestations from beacon blocks.
Data is partitioned daily on slot_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_elaborated_attestation/2024/12/6.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_elaborated_attestation FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_elaborated_attestation FINAL
WHERE
slot_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
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 |
Contains a validator state for an epoch.
Data is partitioned hourly on epoch_start_date_time for the following networks:
- mainnet:
2020-12-01
to2024-12-11
- holesky:
2023-09-23
to2024-12-11
- sepolia:
2022-06-22
to2024-12-11
Parquet file
docker run --rm -it clickhouse/clickhouse-server clickhouse local --query --query="""
SELECT
*
FROM url('https://data.ethpandaops.io/xatu/mainnet/databases/default/canonical_beacon_validators/2024/12/6/0.parquet', 'Parquet')
LIMIT 10
FORMAT Pretty
"""
Your Clickhouse
Note:
FINAL
should be used when querying this table
docker run --rm -it --net host clickhouse/clickhouse-server clickhouse client --query="""
SELECT
*
FROM default.canonical_beacon_validators FINAL
WHERE
epoch_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 10
FORMAT Pretty
"""
EthPandaOps Clickhouse
Note:
FINAL
should be used when querying this table
echo """
SELECT
*
FROM default.canonical_beacon_validators FINAL
WHERE
epoch_start_date_time >= NOW() - INTERVAL '1 HOUR'
LIMIT 3
FORMAT Pretty
""" | curl "https://clickhouse.xatu.ethpandaops.io" -u "$CLICKHOUSE_USER:$CLICKHOUSE_PASSWORD" --data-binary @-
Name | Type | Description |
---|---|---|
updated_date_time | DateTime |
When this row was last updated |
epoch | UInt32 |
The epoch number from beacon block payload |
epoch_start_date_time | DateTime |
The wall clock time when the epoch started |
index | UInt32 |
The index of the validator |
balance | Nullable(UInt64) |
The balance of the validator |
status | LowCardinality(String) |
The status of the validator |
effective_balance | Nullable(UInt64) |
The effective balance of the validator |
slashed | Bool |
Whether the validator is slashed |
activation_epoch | Nullable(UInt64) |
The epoch when the validator was activated |
activation_eligibility_epoch | Nullable(UInt64) |
The epoch when the validator was activated |
exit_epoch | Nullable(UInt64) |
The epoch when the validator exited |
withdrawable_epoch | Nullable(UInt64) |
The epoch when the validator can withdraw |
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 |