Table description
Thesolana.rewards table contains data about rewards paid out on Solana. One block may contain zero or more rewards, and each row corresponds to one reward.
Table Schema
| Column | Type | Description |
|---|---|---|
block_slot | BIGINT | The slot number of the block in which this reward was distributed |
block_time | TIMESTAMP | The timestamp of the block containing this reward |
block_hash | VARCHAR | The hash of the block containing this reward |
reward_type | VARCHAR | The type of reward (e.g., ‘Fee’, ‘Rent’, ‘Staking’, ‘Voting’) |
lamports | BIGINT | The reward amount in lamports (1 SOL = 1,000,000,000 lamports) |
pre_balance | BIGINT | The recipient’s balance in lamports before the reward was applied |
post_balance | BIGINT | The recipient’s balance in lamports after the reward was applied |
commission | BIGINT | The validator commission percentage at the time of the reward (for staking/voting rewards) |
recipient | VARCHAR | The account address that received the reward |
block_date | DATE | The date of the block in which this reward was distributed |