SolanaRewards
Column Descriptions
for solana.rewards
13 rows
| Name | Type | Description |
|---|---|---|
| reward_type | TEXT | |
| block_previous_block_hash | TEXT | |
| pre_balance | NUMBER | |
| block_parent_slot | NUMBER | |
| pubkey | TEXT | |
| block_height | NUMBER | |
| block_hash | TEXT | |
| block_time | TIMESTAMP_NTZ | |
| block_slot | NUMBER | |
| commission | TEXT | |
| post_balance | NUMBER | |
| block_date | DATE | |
| lamports | NUMBER |
Sample Queries
Total Lamports Rewarded Daily
Calculates the total lamports rewarded each day.
SELECT
block_date,
SUM(lamports) AS total_lamports
FROM
solana.rewards
GROUP BY
block_date
ORDER BY
block_date;Top 10 Pubkeys with Highest Total Rewards
Identifies the top 10 public keys that have received the highest total rewards.
SELECT
pubkey,
SUM(lamports) AS total_rewards
FROM
solana.rewards
GROUP BY
pubkey
ORDER BY
total_rewards DESC
LIMIT
10;Average Reward Amount by Reward Type
Calculates the average reward amount for each type of reward.
SELECT
reward_type,
AVG(lamports) AS avg_reward
FROM
solana.rewards
GROUP BY
reward_type;