Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | solana_devnet.staking.rewards |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| stake_account | VARCHAR(16777216) | The address of the stake account receiving the reward |
| reward_type | VARCHAR(14) | Type of reward: ‘native_staking’ or ‘jito_mev’ |
| raw_amount | NUMBER(38,0) | Raw amount of reward in lamports (unnormalized) |
| amount | FLOAT | Amount of reward in SOL (normalized) |
| usd_amount | FLOAT | USD value of the reward at the time of the reward |
| usd_exchange_rate | FLOAT | USD exchange rate for SOL at the time of the reward |
| block_slot | NUMBER(38,0) | Block slot when the reward was recorded |
| block_height | NUMBER(38,0) | Block height when the reward was recorded |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block |
| block_hash | VARCHAR(16777216) | Block hash of the reward |
| txn_id | VARCHAR(16777216) | Transaction ID associated with the reward |
| txn_index | NUMBER(38,0) | Transaction index within the block |
| instruction_index | NUMBER(38,0) | Instruction index within the transaction |
| inner_instruction_index | NUMBER(38,0) | Inner instruction index within the instruction |
| unique_id | VARCHAR(16777216) | Unique identifier for the reward record |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |