Beacon Chainbls-to_execution_changes

Column Descriptions

for eth_cl.bls_to_execution_changes

9 rows

Name	Type	Description
validator_index	NUMBER	Index of the validator associated with this change
from_bls_pubkey	TEXT	BLS public key being changed
block_date	DATE	Calendar date associated with the block containing this change
block_hash	TEXT	Unique identifier (hash) of the block containing this change
signature	TEXT	Signature of the change, used for verification
block_number	NUMBER	Sequential number of the block in the blockchain containing this change
block_time	TIMESTAMP_NTZ	Timestamp indicating when the block containing this change was created
to_execution_address	TEXT	Ethereum execution layer address receiving the delegation
index	NUMBER	Index of this change within the block

Sample Queries

Daily BLS to Execution Changes Count

Calculates the total number of BLS to execution address changes for each day.

SELECT
  block_date,
  COUNT(*) AS daily_changes
FROM
  eth_cl.bls_to_execution_changes
GROUP BY
  block_date
ORDER BY
  block_date;

Most Frequent Execution Address Changes

Identifies the execution addresses that are most frequently involved in changes.

SELECT
  to_execution_address,
  COUNT(*) AS change_count
FROM
  eth_cl.bls_to_execution_changes
GROUP BY
  to_execution_address
ORDER BY
  change_count DESC
LIMIT
  10;

Changes for a Specific Validator

Retrieves all BLS to execution changes for a given validator index.

SELECT
  *
FROM
  eth_cl.bls_to_execution_changes
where
  validator_index = 48697;