Liquid Staking

All liquid staking protocols decoded transactions.

How we are indexing our cnft_trades table?

We have written a Substreams to index this data. Substreams is a powerful blockchain indexing technology developed by StreamingFast.

You can take a look at our indexing code here. The table below contains the project names and their respective program addresses that we have included in our liquid_staking table.

Platform Name	DAPP	Instructions
SPL Stake Pool	SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy	DepositSol, DepositStake, WithdrawSol, WithdrawStake
Marinade	MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD	Deposit, DepositStakeAccount, Claim, OrderUnstake, UpdateDeactivated, UpdateActive, LiquidUnstake

liquid_staking

The table below contains all the cnft_trades table columns , such as signer, stake_pool, reserve_stake, withdraw_authority, pool_mint, etc.

Column Name	Column Type	Description
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
tx_id	string	The first signature in the transaction
signer	string	The initial value from the account_keys array that initiates the transaction and pays the transaction fee
amount	double	The amount of token that is to be staked
category	string	various categories trade such as buy, sell, etc.
stake_pool	string	The LST pool in which the token is staked
withdraw_authority	string	The authority assigned by the platform to approve any un-staking
reserve_stake	string	the reserve account of the stake pool
validator_stake	string	The authority assigned by the platform to validate staking
pool_mint	string	The token mint of the reserve account
fee_account	string	The fee account of the stake pool
mint_amount	double	The amount of LST token minted in return of deposit of token
burn_amount	double	Amount of LST token that is getting burnt upon de-staking
staking_reward	double	The reward of staking as accrued by the stacker
liq_pool_sol_leg	string
fee_amount	double	The amount of fee paid to fee account of stake pool
is_inner_instruction	boolean	Tells whether there is any inner instruction in the transaction or not
instruction_index	bigint	Index of various instructions in a transaction
instruction_type	string	Name of the function of a Solana program invoked via an instruction
inner_instruction_index	bigint	Index of various inner instructions in a instruction
outer_program	string	The main program of an instruction
inner_program	string	The inner programs under the main/outer program
txn_fee	big_int	Fee this transaction was charged, as paid by first account
platform	string	Name of the platform on which trade is happening
partition_0	string	The date on which the block was produced