Skip to main content

Table description

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

ColumnTypeDescription
block_slotBIGINTThe slot number of the block in which this reward was distributed
block_timeTIMESTAMPThe timestamp of the block containing this reward
block_hashVARCHARThe hash of the block containing this reward
reward_typeVARCHARThe type of reward (e.g., ‘Fee’, ‘Rent’, ‘Staking’, ‘Voting’)
lamportsBIGINTThe reward amount in lamports (1 SOL = 1,000,000,000 lamports)
pre_balanceBIGINTThe recipient’s balance in lamports before the reward was applied
post_balanceBIGINTThe recipient’s balance in lamports after the reward was applied
commissionBIGINTThe validator commission percentage at the time of the reward (for staking/voting rewards)
recipientVARCHARThe account address that received the reward
block_dateDATEThe date of the block in which this reward was distributed

Table Sample