Skip to content

Latest commit

 

History

History
1398 lines (1211 loc) · 75.4 KB

canonical_beacon_.md

File metadata and controls

1398 lines (1211 loc) · 75.4 KB
Raw

canonical_beacon_

Events derived from the finalized beacon chain

Availability

  • EthPandaOps Clickhouse
  • Public Parquet Files

Tables

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-20 to 2024-11-20

Examples

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/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-20 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_committee/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_committee/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to null

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_attester_slashing/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_attester_slashing/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to null

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_proposer_slashing/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_proposer_slashing/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-28 to 2024-11-20
  • sepolia: 2022-06-22 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_bls_to_execution_change/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_bls_to_execution_change/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_execution_transaction/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_execution_transaction/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_voluntary_exit/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_voluntary_exit/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_deposit/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_deposit/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2023-02-28 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_block_withdrawal/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_withdrawal/2024/11/23.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 @-

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-11-20
  • holesky: 2024-02-07 to 2024-11-20
  • sepolia: 2024-01-30 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_blob_sidecar/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_blob_sidecar/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-20 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_proposer_duty/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_proposer_duty/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_elaborated_attestation/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_elaborated_attestation/2024/11/23.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 @-

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-11-20
  • holesky: 2023-09-23 to 2024-11-20
  • sepolia: 2022-06-22 to 2024-11-20

Examples

Parquet file

https://data.ethpandaops.io/xatu/NETWORK/databases/default/canonical_beacon_validators/YYYY/MM/DD/HH.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_validators/2024/11/23/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 @-

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