Balances
Daily balance snapshot of active validators on Beacon Chain.
The
beacon.validator.balances table provides a daily snapshot of ETH balances for active validators on Beacon Chain. This snapshot is taken at the last slot of every day (UTC timing). This means that validators with pending, withdrawal, exited status are not included in this snapshot. The types of validator status can be found here.
Querying balance of a validator by its unique index.
select
slot_timestamp, validator_index, balance
from beacon.valdiator.balances
where validator_index = 10
Output of the sample query above for validator index = 10. As this validator have not updated to a 0x01 withdrawal prefix, excess balance is not withdrawn back to ETH1.
Note: if the validator has specified an ETH1 withdrawal address, reward payments of excess balance over 32 ETH will automatically and regularly be sent to the withdrawal address on ETH1.
Column Name | Description | Example |
|---|---|---|
slot_number | Slot number of balance snapshot. | 6,116,398 |
slot_timestamp | Timestamp of balance snapshot . | 2023-03-30 23:59:59 |
validator_index | Unique index of validator. | 538,903 |
balance | Validator balance. | 32.10887728 |
status | Current status of the validator. Note that only active validators are included. | active_ongoing |
activation_eligibility_epoch | When criteria for activation were met. | 184167 |
activation_epoch | Epoch when validator activated. FAR_FUTURE_EPOCH if not activated. | 185165 |
effective_balance | The balance at stake. Effective balance is a value for each validator that is derived from the validator's balance and prior effective balance. It is used to calculate the size of rewards and penalties given to that validator. | 32 |
exit_epoch | PUBKEY | 18446744073709551615 |
pubkey | The validator's BLS public key, uniquely identifying them. _48-bytes, hex encoded with 0x prefix, case insensitive. | 0xb4783219cddc42d5950bf394ade17c60fe5fa50c065b379ae79cd272340d0f4fe28c0bbfb294230a801f616f80c167e8 |
is_slashed | Was validator slashed (not longer active). | FALSE |
withdrawable_epoch | When validator can withdraw or transfer funds. FAR_FUTURE_EPOCH if not defined. | 18446744073709551615 |
withdrawal_credentials | The root of withdrawal credentials. | 0x010000000000000000000000b9d7934878b5fb9610b3fe8a5e441e8fad7e293f |
withdrawal_prefix | The first byte of this credential is known as the withdrawal prefix. This value is currently either 0x00 or 0x01. | 0x01 |
withdrawal_address | ETH1 Withdrawal address specified in withdrawal credentials, applicable for validators with 0x01 withdrawal credentials only. | 0xb9d7934878b5fb9610b3fe8a5e441e8fad7e293f |
raw_balance | Balance in gwei. | 32108877278 |
raw_effective_balance | Effective balance in gwei. | 32000000000 |
unique_id | Unique ID given to validator balance entry. | slot_timestamp-2023-03-30 23:59:59.000_validator_index-538903 |
Last modified 3mo ago