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.

Sample Query

Querying balance of a validator by its unique index.

select 
slot_timestamp, validator_index, balance
from .valdiator.balances 
where validator_index = 10

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.

Table Columns

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.	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	Exit epoch of the validator.	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