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

# Rewards 🌱

### Table Details

| Property            | Value                        |
| ------------------- | ---------------------------- |
| Table Name          | `solana_devnet.raw.rewards`  |
| Table Status        | Beta 🌱                      |
| Unique Key          | `block_slot`, `reward_index` |
| Clustering Key(s)   | `to_date("block_timestamp")` |
| Search Optimization | `block_hash`, `pubkey`       |

### Table Columns

| Column Name      | Data Type         | Description                                                                           |
| ---------------- | ----------------- | ------------------------------------------------------------------------------------- |
| block\_slot      | NUMBER(38,0)      | Slot of the block where this reward was applied.                                      |
| block\_height    | NUMBER(38,0)      | Height of the block where this reward was applied.                                    |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Estimated production time of the block, as Unix timestamp.                            |
| block\_hash      | VARCHAR(16777216) | Blockhash of the block where this reward was applied.                                 |
| commission       | NUMBER(38,0)      | Validator commission for staking rewards (basis points).                              |
| lamports         | NUMBER(38,0)      | Reward amount in lamports (1 SOL = 1,000,000,000 lamports). Can be negative for fees. |
| post\_balance    | NUMBER(38,0)      | Account balance in lamports after the reward was applied.                             |
| pubkey           | VARCHAR(16777216) | Account public key that received the reward.                                          |
| reward\_type     | VARCHAR(16777216) | Type of reward — "fee", "rent", "voting", or "staking".                               |
| reward\_index    | NUMBER(38,0)      | Position of this reward within the block's reward list.                               |
| \_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.                         |

### Related Docs

* [Solana Raw Rewards](/historical-data/supported-blockchains/solana/solana/raw/rewards)
