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 | solana_testnet.raw.rewards |
| Table Status | Beta 🌱 |
| Unique Key | block_slot, reward_index, block_timestamp |
| Clustering Key(s) | to_date("block_timestamp") |
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. |