solana.staking.rewards table contains staking rewards from 2 sources
reward_type='native_staking'- staking rewards issued by the solana network for staking SOLreward_type='jito_mev'- MEV tips collected when a validator is running the jito MEV client. More info here
Table columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| stake_account | The address of the stake account receiving the reward | varchar | 7xLk17EQQ5KLDLDe44wCmupJKJjTGd8hs3eSVVhCx932 |
| reward_type | Type of reward: ‘native_staking’ or ‘jito_mev’ | varchar | native_staking |
| raw_amount | Raw amount of reward in lamports (unnormalized) | number | 1000000000 |
| amount | Amount of reward in SOL (normalized) | float | 1.0 |
| usd_amount | USD value of the reward at the time of the reward | float | 150.25 |
| usd_exchange_rate | USD exchange rate for SOL at the time of the reward | float | 150.25 |
| block_slot | Block slot when the reward was recorded | number | 150000000 |
| block_height | Block height when the reward was recorded | number | 175699063 |
| block_timestamp | Timestamp of the block | timestamp_ntz | 2024-03-20 10:00:00 |
| block_hash | Block hash of the reward | varchar | xSiG9AgdNfgKRhXyrd92EgLuQ5N6NVURdHNFN5U3TPM |
| txn_id | Transaction ID associated with the reward | varchar | 2HtfMAqb1meoJHB1kmDvPzfZWpjDu3JYV5cmruftATE2 |
| txn_index | Transaction index within the block | number | 747 |
| instruction_index | Instruction index within the transaction | number | 0 |
| inner_instruction_index | Inner instruction index within the instruction | number | 4 |
| unique_id | Unique identifier for the reward record | varchar | txn_id-2HtfMAqb1meoJHB1kmDvPzfZWpjDu3JYV5cmruftATE2_i_index-0_ii_index-4 |