Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.balances_l24h |
| Table Status | Production-Ready |
| Unique Key | slot_number, validator_index |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| slot_number | NUMBER(38,0) | Slot number of the beacon state this record was read from. |
| slot_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the beacon slot this record was read from. |
| validator_index | NUMBER(38,0) | Unique index of the validator. |
| raw_balance | VARCHAR(16777216) | Validator balance as an integer in gwei (1e9 gwei = 1 ETH). |
| balance | FLOAT | Balance of the validator in ETH. |
| effective_balance | FLOAT | Effective balance of the validator in ETH. |
| raw_effective_balance | VARCHAR(16777216) | Effective balance at stake in gwei. |
| status | VARCHAR(16777216) | Current status of the validator. |
| pubkey | VARCHAR(16777216) | The validator’s BLS public key, hex-encoded with 0x prefix. |
| withdrawal_credentials | VARCHAR(16777216) | 32-byte field specifying the withdrawal destination and type. |
| withdrawal_prefix | VARCHAR(16777216) | First byte of withdrawal_credentials, identifying the withdrawal credential type. |
| withdrawal_address | VARCHAR(16777216) | Execution-layer withdrawal address derived from withdrawal_credentials. |
| slashed | BOOLEAN | Whether the validator has been slashed. |
| activation_eligibility_epoch | VARCHAR(16777216) | Epoch when the validator became eligible for activation. |
| activation_epoch | VARCHAR(16777216) | Epoch when the validator was activated. |
| exit_epoch | VARCHAR(16777216) | Epoch when the validator exited or will exit. |
| withdrawable_epoch | VARCHAR(16777216) | Epoch when the validator can withdraw. |
| execution_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| finalized | BOOLEAN | If the slot/epoch is finalized. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| is_latest | BOOLEAN | True when this row is the most recent snapshot for the validator in the lookback window. |