Rewards Table

Stores data regarding rewards earned on the Solana blockchain, which can be related to staking, validators, or other network participation activities.

Name	Type	Description
BLOCK_SLOT	FIXED	Slot number or identifier of the block.
TIMESTAMP	FIXED	Raw value of the time in Unix Epoch time (in UTC time zone), which is then converted to DATETIME column.
DATETIME	TIMESTAMP_NTZ	Timestamp of the transaction in UTC.
BLOCK_HEIGHT	FIXED	Indicates the numerical position of a block within the blockchain.
BLOCK_HASH	TEXT	The hash of a specific block in the chain.
REWARD_INDEX	FIXED	Index or identifier for the specific reward.
REWARD_TYPE	TEXT	Type or category of the reward.
PRE_BALANCE	FIXED	Balance before the reward.
POST_BALANCE	FIXED	Balance after the reward.
PCT_CHANGE	REAL	Percentage change in balance due to the reward.
COMMISSION	TEXT	Commission associated with the reward.
RECIPIENT_PUBKEY	TEXT	Public key or address of the reward recipient.
VALUE	FIXED	The curated quantity of the token.
USD_VALUE	REAL	The curated value of the token, priced in USD.
SOURCE_VALUE	FIXED	The raw quantity of the token with the native denomination.
SOURCE_PRE_BALANCE	FIXED	Source balance before the reward.
SOURCE_POST_BALANCE	FIXED	Source balance after the reward.
DATE_CREATED	TIMESTAMP_NTZ	Indicates the date in which the data was loaded.
DATE_UPDATED	TIMESTAMP_NTZ	Indicates the date in which the data was updated.

🔍 Use these columns to gather comprehensive insights into rewards events on the Solana blockchain. Analyze rewards data, such as staking or validator payouts, by showing when each reward was issued, how much was earned, and any associated changes in balance or commission, along with other key metrics. You can:

• Identify the block context using BLOCK_SLOT, TIMESTAMP, DATETIME, BLOCK_HEIGHT, and BLOCK_HASH.

• Determine the specific reward and its type using REWARD_INDEX and REWARD_TYPE.

• Compare balances before and after the reward with PRE_BALANCE and POST_BALANCE, and evaluate the impact with PCT_CHANGE.

• Analyze commission details via COMMISSION.

• Identify the reward recipient using RECIPIENT_PUBKEY.

• Assess reward amounts using VALUE and USD_VALUE.

• Examine the raw token quantities with SOURCE_VALUE, SOURCE_PRE_BALANCE, and SOURCE_POST_BALANCE.

• Track data recency with DATE_CREATED and DATE_UPDATED.

💡 For example, you might query DATETIME, REWARD_TYPE, and PCT_CHANGE, among others, to understand how staking rewards vary over time.