validator.balances migration

← Back to schema changes overview Historical daily balance snapshots (one row per validator per day).

Effective date: March 27, 2026
End of life: May 23, 2026
Replacement: beacon.raw.balances_daily
Replacement available: April 14, 2026 (before the legacy table is removed)
Last published: April 7, 2026

The beacon.validator.balances table will not receive updates after May 23, 2026.

Schema comparison

Column Name	Old Schema (`beacon.validator.balances`)	New Schema (`beacon.raw.balances_daily`)	Change Type	Notes
`SLOT_NUMBER`	Integer	Integer	No change	Slot number remains the same
`SLOT_TIMESTAMP`	Timestamp	Timestamp	No change	Timestamp format unchanged
`VALIDATOR_INDEX`	Integer	Integer	No change	Validator index unchanged
`RAW_BALANCE`	Integer (Wei) - `32787279442`	Integer (Wei) - `32787279442`	Reordered	Now appears BEFORE `BALANCE` column
`BALANCE` ⚠️	Float (ETH) - `32.787279442`	Float (ETH) - `32.787279442`	Reordered	Column moved after `RAW_BALANCE`
`RAW_EFFECTIVE_BALANCE`	Integer (Wei) - `32000000000`	Integer (Wei) - `32000000000`	Reordered	Column moved in order
`EFFECTIVE_BALANCE`	Float (ETH) - `32`	Float (ETH) - `32`	Reordered	Column moved in order
`STATUS`	String - `active_ongoing`	String - `active_ongoing`	Reordered	Moved after balance columns
`PUBKEY`	String (hex)	String (hex)	No change	Public key format unchanged
`WITHDRAWAL_CREDENTIALS`	String (hex)	String (hex)	No change	Credentials unchanged
`WITHDRAWAL_PREFIX`	String (hex) - `0x02`	String (hex) - `0x02`	No change	Prefix unchanged
`WITHDRAWAL_ADDRESS`	String (hex)	String (hex)	No change	Address unchanged
`IS_SLASHED` ⚠️	Boolean - `FALSE`	❌ Removed	REMOVED	Replaced by `SLASHED`
`SLASHED` ⚠️	❌ Not present	Boolean - `FALSE`	NEW	Replaces `IS_SLASHED` (column renamed)
`ACTIVATION_ELIGIBILITY_EPOCH`	Integer	Integer	No change	Epoch values unchanged
`ACTIVATION_EPOCH`	Integer	Integer	No change	Epoch values unchanged
`EXIT_EPOCH`	Integer	Integer	No change	Epoch values unchanged
`WITHDRAWABLE_EPOCH`	Integer	Integer	No change	Epoch values unchanged
`EXECUTION_OPTIMISTIC`	❌ Not present	String (empty) or Boolean	NEW	New field for optimistic execution status
`FINALIZED`	❌ Not present	Boolean - `TRUE`	NEW	New field for finalization status
`UNIQUE_ID` ⚠️	String - `date-2026-03-27_validator_index-0`	String - `date-2026-03-27-validator_index-0`	BREAKING	Format changed: underscore removed between date and validator
`_CREATED_AT`	Timestamp	Timestamp	No change	Creation timestamp unchanged
`_UPDATED_AT`	Timestamp	Timestamp	No change	Update timestamp unchanged
`_CHANGED_SINCE_FULL_REFRESH`	Boolean - `TRUE`	❌ Removed	REMOVED	Field no longer available

Breaking changes summary

Critical breaking changes — address these in your queries:

Column order changed (affects SELECT *): RAW_BALANCE before BALANCE; balance columns grouped; STATUS after balance columns
Column renamed: IS_SLASHED → SLASHED
UNIQUE_ID format changed: date-2026-03-27_validator_index-0 → date-2026-03-27-validator_index-0 (breaks filters/joins on UNIQUE_ID)
New columns: EXECUTION_OPTIMISTIC, FINALIZED
Removed column: _CHANGED_SINCE_FULL_REFRESH

Non-breaking changes

Core validator fields (VALIDATOR_INDEX, PUBKEY, STATUS, etc.) keep the same data types
Withdrawal fields (WITHDRAWAL_PREFIX, WITHDRAWAL_ADDRESS) already present in the legacy schema
Epoch fields remain integers; timestamps unchanged
RAW_BALANCE and RAW_EFFECTIVE_BALANCE remain Integer (Wei)

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Schema comparison

Breaking changes summary

Non-breaking changes

​Schema comparison

​Breaking changes summary

​Non-breaking changes

Schema comparison

Breaking changes summary

Non-breaking changes