Staking
Stakers
The solana.staking.stakers table contains information about every stake_account ever created.
The information of each stake_account is consolidated from indexing these stake program instructions - initialize, authorize, setLockup.
Table columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| stake_account | The address of the stake account being modified | varchar | CKa9YSmnjrKx5nxYoa7ufbrVL9fEmt99w3ZCgv3DJfyo |
| staker | The authority address that can manage staking operations | varchar | 3rBnnH9TTgd3xwu48rnzGsaQkSrlhR64nY7lDrDt6VrQ |
| withdrawer | The authority address that can withdraw funds from the stake account | varchar | 3rBnnH9TTgd3xwu48rnzGsaQkSrlhR64nY7lDrDt6VrQ |
| lockup_custodian | The authority that can modify lockup parameters | varchar | 9n8bp3f8VvikXjqXjZUPZuEq8aAyrXzCqrq7nAREKMP9 |
| lockup_epoch | The epoch until which the stake account is locked | varchar | 800 |
| lockup_unix_timestamp | Unix timestamp until which the stake account is locked | varchar | 1650000000 |
| block_timestamp | Block timestamp of the last update | timestamp_ntz | 2024-08-30 21:31:42.000 |
| txn_index | Transaction index of the last update | varchar | 24 |
| txn_id | Transaction id of the last update | varchar | 5uLekDFd37Tgt5QJ5k9L1c7o9V4SSF81ooToeXKmQNooRoRTUQwr2qsWtMTLxzoMcwHW6u7NAGXRJSXQYFQwo8vU |
| instruction_index | Instruction index within the tx of the last update | varchar | 3 |
| inner_instruction_index | Inner instruction index of the last update, if available | varchar | 3 |
| unique_id | Unique id of the record | varchar | txn_id-5uLekDFd37Tgt5QJ5k9L1c7o9V4SSF81ooToeXKmQNooRoRTUQwr2qsWtMTLxzoMcwHW6u7NAGXRJSXQYFQwo8vU_i_index-3_ii_index-null |