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