> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Balances L24H

### 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. |