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.
Table Details
| Property | Value |
|---|---|
| Table Name | casper.staking.rewards |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| reward_type | VARCHAR(16777216) | Type of reward (e.g., validator or delegator). |
| era_id | NUMBER(38,0) | Era (epoch) for which the reward was distributed. |
| address | VARCHAR(16777216) | Recipient address of the staking reward. |
| address_type | VARCHAR(16777216) | Type of the recipient address (Account, Contract, or Hash). |
| validator_public_key | VARCHAR(16777216) | Public key of the validator that earned or distributed the reward. |
| delegator_public_key | VARCHAR(16777216) | Public key of the delegator receiving the reward; null for validator rewards. |
| raw_amount | VARCHAR(16777216) | Reward amount in motes (no decimal adjustment). |
| amount | FLOAT | Reward amount in CSPR adjusted for decimals. |
| usd_amount | FLOAT | USD value of the reward at the time of the event. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block this event was included in. |
| block_number | NUMBER(38,0) | Height of the block this event was included in. |
| block_hash | VARCHAR(16777216) | Hash of the block this event was included in. |
| unique_id | VARCHAR(16777216) | Unique identifier for the row, used for deduplication. |