Stake Pool

A program for pooling together SOL to be staked by an off-chain agent

stake_pool.txns

This table has similar schema as of Solana transactions table

stake_pool.parsed

The table contains the parsed instructions data for Stake Pools. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Column Name	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	<STRUCT>	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

Some columns in the above table needs to be explained a bit for better understanding. Let's go into what each one of them contains.

input accounts

Field	Column Type
pool_mint	string
metadata_program_id	string
stake_config_sysvar	string
validator_stake	string
destination_stake	string
stake_history_sysvar	string
accounts	array<string>
source_pool_account	string
clock_sysvar	string
token_metadata	string
token_program_id	string
manager_fee_account	string
rent_sysvar	string
validator	string
destination_transient_stake	string
payer	string
funding_account	string
system_program_id	string
reserve_stake	string
source_transfer_authority	string
source_validator_stake	string
withdraw_authority	string
staker	string
deposit_stake	string
manager	string
deposit_authority	string
withdrawauthority	string
stake_pool	string
source_transient_stake	string
referral_pool_account	string
manager_pool_account	string
sol_withdraw_authority	string
ephemeral_stake	string
destination_pool_account	string
destination_validator_stake	string
destination_system_account	string
validator_list	string
stake_program_id	string
destination_stake_authority	string
validator_vote	string
validator_and_transient_stake_pairs	array<string>
transient_stake	string

args

Field	Data Type
fee	<STRUCT>
withdrawal_fee	<STRUCT>
deposit_fee	<STRUCT>
referral_fee	int16
max_validators	int32
seed	int32
lamports	bigint
transient_stake_seed	bigint
validator_type	string
validator_vote_address	string
start_index	int32
no_merge	boolean
pool_tokens_in	bigint
lamports_in	bigint
funding_type	string
name	string
symbol	string
uri	string
ephemeral_stake_seed	bigint
source_transient_stake_seed	bigint
destination_transient_stake_seed	bigint
minimum_pool_tokens_out	bigint
minimum_lamports_out	bigint

fee

Field	Data Type
denominator	bigint
numerator	bigint
name	string
fields	string

withdrawal_fee

Field	Data Type
denominator	bigint
numerator	bigint

deposit_fee

Field	Data Type
denominator	bigint
numerator	bigint