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