Beacon ChainProposer Slashings

Column Descriptions

for eth_cl.proposer_slashings

11 rows

Name	Type	Description
parent_root	TEXT	Root hash of the parent block for the signed header
slot	NUMBER	Slot number of the header involved in the slashing
state_root	TEXT	Root hash of the chain state for the signed header
block_date	DATE	Calendar date associated with the block containing this slashing
block_hash	TEXT	Unique identifier (hash) of the block containing this slashing
index	NUMBER	Index of the slashing within the block
block_time	TIMESTAMP_NTZ	Timestamp indicating when the block containing this slashing was created
proposer_index	NUMBER	Index of the proposer involved in the slashing
signature	TEXT	Signature of the header, used for verification
block_number	NUMBER	Sequential number of the block in the blockchain containing this slashing
body_root	TEXT	Root hash of the block body for the signed header

Sample Queries

Daily Proposer Slashing Count

Calculates the total number of proposer slashings for each day.

SELECT
  block_date,
  COUNT(*) AS daily_slashings
FROM
  eth_cl.proposer_slashings
GROUP BY
  block_date
ORDER BY
  block_date;

Most Slashed Proposers

Identifies the proposers with the highest number of slashings.

SELECT
  proposer_index,
  COUNT(*) AS slashing_count
FROM
  eth_cl.proposer_slashings
GROUP BY
  proposer_index
ORDER BY
  slashing_count DESC
LIMIT
  10;

Proposer Slashings in a Specific Slot Range

Finds all proposer slashings that occurred within a particular slot range.

SELECT
  *
FROM
  eth_cl.proposer_slashings
WHERE
  slot BETWEEN 1000 AND 2000;