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

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

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

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

Field

Data Type

fee

withdrawal_fee

deposit_fee

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

Field

Data Type

denominator

bigint

numerator

bigint

name

string

fields

string

withdrawal_fee

Field	Data Type
denominator	bigint
numerator	bigint

Field

Data Type

denominator

bigint

numerator

bigint

deposit_fee

Field	Data Type
denominator	bigint
numerator	bigint

Field

Data Type

denominator

bigint

numerator

bigint

PreviousSol Splits NextHubble

Last updated 3 months ago