- Effective date: April 7, 2026
- End of life: May 23, 2026
- Replacement:
beacon.raw.balances_latest - Last published: April 7, 2026
Schema comparison
| Column Name | Old Schema (beacon.validator.balances_latest) | New Schema (beacon.raw.balances_latest) | 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) | Integer (Wei) | Reordered | Now appears BEFORE BALANCE column |
BALANCE ⚠️ | Integer (Wei) - stored as 32787459477 | Float (ETH) - stored as 32.78744189 | BREAKING | Changed from Wei integer to ETH float |
EFFECTIVE_BALANCE ⚠️ | Integer (Wei) - stored as 32000000000 | Float (ETH) - stored as 32 | BREAKING | Changed from Wei integer to ETH float |
RAW_EFFECTIVE_BALANCE | Integer (Wei) | Integer (Wei) | No change | Raw value unchanged |
STATUS | String | String | No change | Status values unchanged |
PUBKEY | String (hex) | String (hex) | No change | Public key format unchanged |
WITHDRAWAL_CREDENTIALS | String (hex) | String (hex) | No change | Credentials unchanged |
WITHDRAWAL_PREFIX | ❌ Not present | String (hex) - 0x02 | NEW | Extracted from withdrawal credentials |
WITHDRAWAL_ADDRESS | ❌ Not present | String (hex) - 0x0d369bb... | NEW | Extracted withdrawal address |
SLASHED | Boolean | Boolean | No change | Slashing status unchanged |
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 | Boolean (FALSE) | String (empty) or Boolean | BREAKING | Type changed, may be empty string |
FINALIZED | Boolean (FALSE) | Boolean (TRUE) | BREAKING | Type may differ, default changed |
UNIQUE_ID | ❌ Not present | String - validator_index-0 | NEW | New unique identifier field |
_CREATED_AT | Timestamp | Timestamp | No change | Creation timestamp unchanged |
_UPDATED_AT | ❌ Not present | Timestamp | NEW | New update tracking field |
INDEX | Integer - 0 | ❌ Removed | REMOVED | Replaced by UNIQUE_ID |
Breaking changes summary
Critical breaking changes — address these in your queries:
- Column order changed:
RAW_BALANCEnow appears beforeBALANCE(affectsSELECT *queries) - Balance data types changed:
BALANCE: Integer (Wei) → Float (ETH)- Old:
32787459477(Wei) - New:
32.78744189(ETH)
- Old:
EFFECTIVE_BALANCE: Integer (Wei) → Float (ETH)- Old:
32000000000(Wei) - New:
32(ETH)
- Old:
- New columns:
WITHDRAWAL_PREFIX,WITHDRAWAL_ADDRESS,UNIQUE_ID,_UPDATED_AT - Removed column:
INDEX(replaced byUNIQUE_ID) - Type changes:
EXECUTION_OPTIMISTICmay be empty string;FINALIZEDbehavior may differ