Beacon ChainWithdrawals

Column Descriptions

for eth_cl.withdrawals

8 rows

Name	Type	Description
block_hash	TEXT	Unique identifier (hash) of the block containing this withdrawal
address	TEXT	Address where the withdrawal is sent
block_time	TIMESTAMP_NTZ	Timestamp indicating when the block containing this withdrawal was created
gwei	NUMBER	Amount withdrawn in gwei (smallest unit of Ether)
validator_index	NUMBER	Index of the validator associated with this withdrawal
withdrawal_index	NUMBER	Index of the withdrawal within the block
block_date	DATE	Calendar date associated with the block containing this withdrawal
block_number	NUMBER	Sequential number of the block in the blockchain containing this withdrawal

Sample Queries

Total Withdrawals per Day in Gwei

Calculates the total amount of withdrawals in Gwei for each day.

SELECT
  block_date,
  SUM(gwei) AS total_gwei_withdrawn
FROM
  eth_cl.withdrawals
GROUP BY
  block_date
ORDER BY
  block_date;

Top 10 Withdrawal Addresses by Total Gwei

Identifies the top 10 addresses based on the total amount of Gwei withdrawn.

SELECT
  address,
  SUM(gwei) AS total_gwei
FROM
  eth_cl.withdrawals
GROUP BY
  address
ORDER BY
  total_gwei DESC
LIMIT
  10;

Average Withdrawal Amount in Gwei

Calculates the average withdrawal amount in Gwei.

SELECT
  AVG(gwei) AS average_withdrawal_gwei
FROM
  eth_cl.withdrawals;