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_validators

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-20 to 2024-12-13

Examples
#

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/2024/12/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-20 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to null

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to null

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-12 to 2024-12-13
holesky: 2023-09-28 to 2024-12-13
sepolia: 2022-06-22 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-06 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-12 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2023-02-28 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-13 to 2024-12-13
holesky: 2024-02-07 to 2024-12-13
sepolia: 2024-01-30 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-20 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to 2024-12-13

Examples
#

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/8.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

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

canonical_beacon_validators
#

Contains a validator state for an epoch.

Availability
#

Data is partitioned hourly on epoch_start_date_time for the following networks:

mainnet: 2020-12-01 to 2024-12-13
holesky: 2023-09-23 to 2024-12-13
sepolia: 2022-06-22 to 2024-12-13

Examples
#

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/8/0.parquet', 'Parquet')
    LIMIT 10
    FORMAT Pretty
"""

Your Clickhouse

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

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 @-

Columns
#

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

canonical_beacon_ #

Availability #

Tables #

canonical_beacon_block #

Availability #

Examples #

Columns #

canonical_beacon_committee #

Availability #

Examples #

Columns #

canonical_beacon_block_attester_slashing #

Availability #

Examples #

Columns #

canonical_beacon_block_proposer_slashing #

Availability #

Examples #

Columns #

canonical_beacon_block_bls_to_execution_change #

Availability #

Examples #

Columns #

canonical_beacon_block_execution_transaction #

Availability #

Examples #

Columns #

canonical_beacon_block_voluntary_exit #

Availability #

Examples #

Columns #

canonical_beacon_block_deposit #

Availability #

Examples #

Columns #

canonical_beacon_block_withdrawal #

Availability #

Examples #

Columns #

canonical_beacon_blob_sidecar #

Availability #

Examples #

Columns #

canonical_beacon_proposer_duty #

Availability #

Examples #

Columns #

canonical_beacon_elaborated_attestation #

Availability #

Examples #

Columns #

canonical_beacon_validators #

Availability #

Examples #

Columns #

canonical_beacon_
#

Availability
#

Tables
#

canonical_beacon_block
#

Availability
#

Examples
#

Columns
#

canonical_beacon_committee
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_attester_slashing
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_proposer_slashing
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_bls_to_execution_change
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_execution_transaction
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_voluntary_exit
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_deposit
#

Availability
#

Examples
#

Columns
#

canonical_beacon_block_withdrawal
#

Availability
#

Examples
#

Columns
#

canonical_beacon_blob_sidecar
#

Availability
#

Examples
#

Columns
#

canonical_beacon_proposer_duty
#

Availability
#

Examples
#

Columns
#

canonical_beacon_elaborated_attestation
#

Availability
#

Examples
#

Columns
#

canonical_beacon_validators
#

Availability
#

Examples
#

Columns
#