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

# Consensus Income

### Table Details

| Property     | Value                               |
| ------------ | ----------------------------------- |
| Table Name   | `beacon.validator.consensus_income` |
| Table Status | Production-Ready                    |

### Table Columns

| Column Name           | Data Type         | Description                                                                                                                                                                                                                                                                            |
| --------------------- | ----------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| slot\_number          | NUMBER(38,0)      | Slot number of the state where the pending deposits to beacon chain is fetched.                                                                                                                                                                                                        |
| slot\_timestamp       | TIMESTAMP\_NTZ(9) | Slot timestamp of the state where the pending deposits to beacon chain is fetched.                                                                                                                                                                                                     |
| slot\_timestamp\_est  | TIMESTAMP\_NTZ(9) | Snapshot time in **Eastern Time** (end-of-day EST for the reporting date).                                                                                                                                                                                                             |
| validator\_index      | NUMBER(38,0)      | 916,865                                                                                                                                                                                                                                                                                |
| reward\_type          | VARCHAR(16777216) | Type of reward. Currently includes attestation\_total\_rewards (attestation rewards from beacon.raw\.total\_rewards), block\_rewards (block rewards from beacon.raw\.block\_rewards), and sync\_committee\_rewards (sync committee rewards from beacon.raw\.sync\_committee\_rewards). |
| raw\_amount           | VARCHAR(16777216) | Raw amount of reward, in string to retain precision.                                                                                                                                                                                                                                   |
| amount                | FLOAT             | Amount of reward normalized.                                                                                                                                                                                                                                                           |
| finalized             | BOOLEAN           | If the slot/epoch is finalized.                                                                                                                                                                                                                                                        |
| execution\_optimistic | BOOLEAN           | If the slot/epoch is executed optimistically.                                                                                                                                                                                                                                          |
| \_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.                                                                                                                                                                                                                          |