Beacon ChainVoluntary Exits

Column Descriptions

for eth_cl.voluntary_exits

8 rows

Name	Type	Description
validator_index	NUMBER	Index of the validator requesting the voluntary exit
signature	TEXT	Signature of the voluntary exit request, used for verification
block_hash	TEXT	Unique identifier (hash) of the block containing this voluntary exit
index	NUMBER	Index of the voluntary exit within the block
block_date	DATE	Calendar date associated with the block containing this voluntary exit
epoch	NUMBER	Epoch during which the validator initiated the voluntary exit
block_number	NUMBER	Sequential number of the block in the blockchain containing this voluntary exit
block_time	TIMESTAMP_NTZ	Timestamp indicating when the block containing this voluntary exit was created

Sample Queries

Daily Voluntary Exit Count

Calculates the total number of voluntary exits for each day.

SELECT
  block_date,
  COUNT(*) AS daily_exits
FROM
  eth_cl.voluntary_exits
GROUP BY
  block_date
ORDER BY
  block_date;

Validators with Multiple Exits

Identifies validators that have initiated voluntary exits more than once.

SELECT
  validator_index,
  COUNT(*) AS exit_count
FROM
  eth_cl.voluntary_exits
GROUP BY
  validator_index
HAVING
  exit_count > 1
ORDER BY
  exit_count DESC;

Voluntary Exits in a Specific Epoch

Retrieves all voluntary exits that occurred during a particular epoch.

SELECT
  *
FROM
  eth_cl.voluntary_exits
WHERE
  epoch = 197354;