Stakers - Allium Documentation Hub

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 Details

Property	Value
Table Name	`solana.staking.stakers`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `txn_id`, `unique_id`

Table Columns

Column Name	Data Type	Description
stake_account	VARCHAR(44)	The address of the stake account being modified
staker	VARCHAR(44)	The authority address that can manage staking operations
withdrawer	VARCHAR(44)	The authority address that can withdraw funds from the stake account
lockup_custodian	VARCHAR(44)	The authority that can modify lockup parameters
lockup_epoch	VARCHAR(16777216)	The epoch until which the stake account is locked
lockup_unix_timestamp	VARCHAR(16777216)	Unix timestamp until which the stake account is locked
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the last update
txn_index	NUMBER(38,0)	Transaction index of the last update
txn_id	VARCHAR(88)	Transaction id of the last update
instruction_index	NUMBER(38,0)	Instruction index within the tx of the last update
inner_instruction_index	NUMBER(38,0)	Inner instruction index of the last update, if available
unique_id	VARCHAR(16777216)	Unique id of the record