sanctum_v1_solana

Tables

Controller_AddLst_instruction

Administrative instructions for adding liquid staking tokens (LST) to Sanctum’s liquidity pool controller on Solana. Used to track LST onboarding events including mint addresses, pool state configurations, and protocol fee structures.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_associated_token_program`	`STRING`	Account address of the Solana Associated Token Program used in this instruction. This program manages the creation and lookup of associated token accounts for LST (Liquid Staking Token) operations.
`in_lst_mint`	`STRING`	Solana account address of the liquid staking token (LST) mint being added to the Sanctum controller. Base58-encoded identifier that remains consistent across all sample rows.
`in_lst_state_list`	`STRING`	Account address of the Liquid Staking Token (LST) state list being modified in the AddLst instruction. Base58-encoded Solana address referencing the on-chain list tracking registered LSTs in the Sanctum pool.
`in_lst_token_program`	`STRING`	Program account managing the token operations for the LST (Liquid Staking Token) being added to the Sanctum pool. Base58-encoded Solana program address that defines token behavior and minting rules.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool_reserves`	`STRING`	Account address of the liquidity pool’s SOL reserve vault that holds the underlying staked SOL. Consistent across all sample transactions at 4sDXGroVt7ba45rzXtNto97QjG1rHm8Py3v56Mgg16Nc.
`in_pool_state`	`STRING`	Account holding the pool state configuration for the Sanctum liquidity pool. Base58-encoded Solana account address, typically a sysvar or program-derived address.
`in_protocol_fee_accumulator`	`STRING`	Account address where protocol fees are collected from liquidity staking token operations. Base58-encoded Solana public key.
`in_protocol_fee_accumulator_auth`	`STRING`	Account authorized to manage the protocol fee accumulator for this Sanctum pool operation. Base58-encoded Solana address, often a system program or authority account.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_sol_value_calculator`	`STRING`	Account address of the SOL value calculator program used to determine SOL equivalency for LST (Liquid Staking Token) conversions. Consistently references the Solana Stake program address across all transactions.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.

Sample Data

in_admin	in_payer	block_slot	in_lst_mint	in_remaining	in_pool_state	surrogate_key	transaction_id	block_timestamp	in_pool_reserves	instruction_type	executing_account	in_lst_state_list	in_system_program	transaction_index	transaction_signer	in_lst_token_program	in_sol_value_calculator	in_associated_token_program	in_protocol_fee_accumulator	in_protocol_fee_accumulator_auth
5oc4nmbNTda9fx8Tw57ShLD132aqDK65vuHH4RU1K4LZ	AzZRvyyMHBm8EHEksWxq4ozFL7JxLMydCDMGhqM6BVck	95904285	8pTa29ovYHxjQgX7gjxGi395GAo8DSXCRTKJZvwMc6MR	[""7g5KspBMSSYBbf8eLdExcfDQ7YSnYwswp2DM2r5idkKJ"",""3bk6jyNCoAwqcGyKVnbVoYHXzHsuuLncQp74pgHAgjEG"",""AUXjnCRehtdHaMMH83S2CiNodyPsmiTgosMALhXwc1hD"",""J1G4vKfZCr3wj4F4VGZWWxrMW2qNavLbVe9aUz6iE9wW"",""AnMX2n479GjD5hAndHhuB7NbnrZopZSDunHEQFXafEqA"",""36V26fL3JSSoRmgKSZd5zMuQsi8LsPZxWKftQJhpEdEG""]	Sysvar1nstructions1111111111111111111111111	95904285-29paR8qqfwp2T7H6Ja7HwK4BgkeZ3JBFJeZpDAavxHPK5kW44NZ7Yq9EN6UotdYf5k9c9GtUdschTGJafpJZKcDt-0	29paR8qqfwp2T7H6Ja7HwK4BgkeZ3JBFJeZpDAavxHPK5kW44NZ7Yq9EN6UotdYf5k9c9GtUdschTGJafpJZKcDt	2021-09-10T14:49:57.000Z	4sDXGroVt7ba45rzXtNto97QjG1rHm8Py3v56Mgg16Nc	AddLst	5ocnV1qiCgaQR8Jb8xWnVbApfaygJ8tNoZfgPwsgx9kx	9pQBsNSQiLgFAXfFqjuPMKVcaN5k34TaRs3HwU6aNX59	13bbJGTkrk1nQBXfV2Pbaw7XGKS5k283j5T3P7pwme4u	25	3etKXcW2fzEJR5YXoSKSmP6UZ633g9uiFv5yuqFUf66k	EkqSjiEVWKoo12WMLRvm1FAFp9NdHFSvZDnzhEwWBdkZ	Stake11111111111111111111111111111111111111	owTnSHiuWEfMG19xDCwqVXDa5NSDVJ7iiu3EEzuaJfU	SysvarC1ock11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111
5oc4nmbNTda9fx8Tw57ShLD132aqDK65vuHH4RU1K4LZ	AzZRvyyMHBm8EHEksWxq4ozFL7JxLMydCDMGhqM6BVck	95904267	8pTa29ovYHxjQgX7gjxGi395GAo8DSXCRTKJZvwMc6MR	[""7g5KspBMSSYBbf8eLdExcfDQ7YSnYwswp2DM2r5idkKJ"",""3bk6jyNCoAwqcGyKVnbVoYHXzHsuuLncQp74pgHAgjEG"",""AUXjnCRehtdHaMMH83S2CiNodyPsmiTgosMALhXwc1hD"",""J1G4vKfZCr3wj4F4VGZWWxrMW2qNavLbVe9aUz6iE9wW"",""AnMX2n479GjD5hAndHhuB7NbnrZopZSDunHEQFXafEqA"",""36V26fL3JSSoRmgKSZd5zMuQsi8LsPZxWKftQJhpEdEG""]	Sysvar1nstructions1111111111111111111111111	95904267-vnCz7UDL7nD5gvdYk1FbSUQGEQ21dx5QVQMcNA6Urx8pSFtZwVBJA14e1y3t9iHZTJSDhmNrPTU9DeZiq15X4mw-0	vnCz7UDL7nD5gvdYk1FbSUQGEQ21dx5QVQMcNA6Urx8pSFtZwVBJA14e1y3t9iHZTJSDhmNrPTU9DeZiq15X4mw	2021-09-10T14:49:43.000Z	4sDXGroVt7ba45rzXtNto97QjG1rHm8Py3v56Mgg16Nc	AddLst	5ocnV1qiCgaQR8Jb8xWnVbApfaygJ8tNoZfgPwsgx9kx	9pQBsNSQiLgFAXfFqjuPMKVcaN5k34TaRs3HwU6aNX59	13bbJGTkrk1nQBXfV2Pbaw7XGKS5k283j5T3P7pwme4u	0	BEc48J3SofZETHbqrgGYr85S1e5Rg5K98yMvEE259b28	EkqSjiEVWKoo12WMLRvm1FAFp9NdHFSvZDnzhEwWBdkZ	Stake11111111111111111111111111111111111111	owTnSHiuWEfMG19xDCwqVXDa5NSDVJ7iiu3EEzuaJfU	SysvarC1ock11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111
5oc4nmbNTda9fx8Tw57ShLD132aqDK65vuHH4RU1K4LZ	AzZRvyyMHBm8EHEksWxq4ozFL7JxLMydCDMGhqM6BVck	95904320	8pTa29ovYHxjQgX7gjxGi395GAo8DSXCRTKJZvwMc6MR	[""7g5KspBMSSYBbf8eLdExcfDQ7YSnYwswp2DM2r5idkKJ"",""3bk6jyNCoAwqcGyKVnbVoYHXzHsuuLncQp74pgHAgjEG"",""AUXjnCRehtdHaMMH83S2CiNodyPsmiTgosMALhXwc1hD"",""J1G4vKfZCr3wj4F4VGZWWxrMW2qNavLbVe9aUz6iE9wW"",""AnMX2n479GjD5hAndHhuB7NbnrZopZSDunHEQFXafEqA"",""36V26fL3JSSoRmgKSZd5zMuQsi8LsPZxWKftQJhpEdEG""]	Sysvar1nstructions1111111111111111111111111	95904320-5C9Sbq4cnQDCUvVvP3PmRBqqP5kvUx3Wro1rpy9dAyyYeXhurmf38ynUFespJtuc3ciiwxj32Z1oKKrMFC2u1tn8-0	5C9Sbq4cnQDCUvVvP3PmRBqqP5kvUx3Wro1rpy9dAyyYeXhurmf38ynUFespJtuc3ciiwxj32Z1oKKrMFC2u1tn8	2021-09-10T14:50:22.000Z	4sDXGroVt7ba45rzXtNto97QjG1rHm8Py3v56Mgg16Nc	AddLst	5ocnV1qiCgaQR8Jb8xWnVbApfaygJ8tNoZfgPwsgx9kx	9pQBsNSQiLgFAXfFqjuPMKVcaN5k34TaRs3HwU6aNX59	13bbJGTkrk1nQBXfV2Pbaw7XGKS5k283j5T3P7pwme4u	272	AoWYPDeX1ZdwzPy8hNBZpYszs2HeFZbT79C45cQXscNz	EkqSjiEVWKoo12WMLRvm1FAFp9NdHFSvZDnzhEwWBdkZ	Stake11111111111111111111111111111111111111	owTnSHiuWEfMG19xDCwqVXDa5NSDVJ7iiu3EEzuaJfU	SysvarC1ock11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.Controller_AddLst_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiValidatorStakePool_AddValidatorToPool_instruction

Instruction-level data for adding validators to Sanctum stake pools on Solana. Tracks stake pool management operations including validator addresses, stake accounts, and pool configuration for analyzing liquid staking delegation strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_reserve_stake_account`	`STRING`	Solana account address holding the stake pool’s reserve stake, used to fund new validator stake accounts. Base58-encoded identifier typically starting with alphanumeric characters.
`in_stake`	`STRING`	Amount of staked or collateralized tokens denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains or lamports for Solana.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_stake_pool_withdraw`	`STRING`	Account address authorized to withdraw from the stake pool. Base58-encoded Solana public key.
`in_stake_program`	`STRING`	Program address of the Solana Stake Program. Base58-encoded public key, constant value Stake11111111111111111111111111111111111111.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_sysvar_clock`	`STRING`	Address of the Solana Clock Sysvar account. Base58-encoded public key, constant value SysvarC1ock11111111111111111111111111111111.
`in_sysvar_rent`	`STRING`	Account address of the Solana Rent sysvar program used to check rent-exemption requirements during validator addition. Always set to the system constant SysvarRent111111111111111111111111111111111 on Solana mainnet.
`in_sysvar_stake_config`	`STRING`	Solana system variable account address for stake configuration parameters (StakeConfig program). Constant value across all transactions as it references the protocol-level stake config sysvar.
`in_sysvar_stake_history`	`STRING`	Solana system variable account address containing historical stake activation data required for stake pool validator operations. Fixed at SysvarStakeHistory1111111111111111111111111 across all transactions.
`in_validator`	`STRING`	Solana address of the validator being added to the stake pool in this instruction. Base58-encoded public key identifying the validator node to which pool funds can be delegated.
`in_validator_list`	`STRING`	Account address of the validator list storing registered validators for the stake pool. Base58-encoded Solana public key.
`in_seed`	`STRING`	Seed value used to derive the validator stake account address within the pool. Typically set to ‘0’ as shown in sample data.

Sample Data

in_stake	in_staker	block_slot	in_remaining	in_validator	in_stake_pool	surrogate_key	in_sysvar_rent	transaction_id	block_timestamp	in_sysvar_clock	in_stake_program	instruction_type	executing_account	in_system_program	in_validator_list	instruction_index	transaction_index	transaction_signer	in_stake_pool_withdraw	in_sysvar_stake_config	in_sysvar_stake_history	in_reserve_stake_account
EmutJdbKJ55hUyth15bar8ZxDCchR44udAXWYg9eLLDL	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	257857340	[]	CatzoSMUkTRidT5DwBxAC2pEtnwMBTpkCepHkFgZDiqb	8VpRhuxa7sUUepdY3kQiTmX9rS5vx4WgaXiAnXq4KCtr	257857340-ni3oMHLZqmZZj41AUpPXoW4ykzvM3MrUniGYfWGDsUbk38N5vGGwG7YdM7xtKUVL9H2HZFEhRF5wrXRbiR5Wpwp-2	SysvarRent111111111111111111111111111111111	ni3oMHLZqmZZj41AUpPXoW4ykzvM3MrUniGYfWGDsUbk38N5vGGwG7YdM7xtKUVL9H2HZFEhRF5wrXRbiR5Wpwp	2024-04-02T03:33:12.000Z	SysvarC1ock11111111111111111111111111111111	Stake11111111111111111111111111111111111111	AddValidatorToPool	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	11111111111111111111111111111111	AXL4v4bbzRkqwHmLc9A1YzHQmRhmG9Q93i1e6CPG2bEK	2	85	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	EMjuABxELpYWYEwjkKmQKBNCwdaFAy4QYAs6W9bDQDNw	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	FMAWbzuxsgbgndArunedwxXPA6sweaVUGGgadCpSxau2
548NpMWzufukU5Eingips1Yq4tVWzwrXYFqP2VuECqpx	EG976hUYS3Mwf595uk9irszydggWzB3tBDobbMffyScq	262359686	[]	GE6atKoWiQ2pt3zL7N13pjNHjdLVys8LinG8qeJLcAiL	4fdMvFuyNboQ5Kr93X16f1tFcTeEkvfNwNAeSrzY3afb	262359686-32S1Sz6RGQ8hZSBzXr2WJcDVMbGvb7Kwd3JuFVxBDWv9AxMRDQREDjydszp8o2T4CQKPPhKHXZhJN8WL11eWYqit-2	SysvarRent111111111111111111111111111111111	32S1Sz6RGQ8hZSBzXr2WJcDVMbGvb7Kwd3JuFVxBDWv9AxMRDQREDjydszp8o2T4CQKPPhKHXZhJN8WL11eWYqit	2024-04-26T14:26:27.000Z	SysvarC1ock11111111111111111111111111111111	Stake11111111111111111111111111111111111111	AddValidatorToPool	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	11111111111111111111111111111111	25vgWN38FKfcbejXcNvgwKJ2YR6TBudgxmkr5NhRJKzT	2	59	3etKXcW2fzEJR5YXoSKSmP6UZ633g9uiFv5yuqFUf66k	2wTD2CJN3VSfV84JUexQLmhUeCbXPjKBYKFME3LWt4ue	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	3ufHs1EDLsCPTsBYG5ydsctCmCP2qHn5nVqqLRSpcj4A
A22EWLwPBPytCpPzcgv8ZxxjQiGVdMJk93gbvSSDx1h4	EG976hUYS3Mwf595uk9irszydggWzB3tBDobbMffyScq	262359627	[]	votem3UdGx5xWFbY9EFbyZ1X2pBuswfR5yd2oB3JAaj	EVXQHaLSJyUNrnBGfXUnvEi4DvVz4UJ3GnoKGVQVxrjr	262359627-4H4R6h7TXof8nBxpG6qXpPBwBgdceYVnLy6m4cwtekTspJCFVjHBHDnrDzKJHhM3J1PJQytRdCKrQx1zHujA4uny-2	SysvarRent111111111111111111111111111111111	4H4R6h7TXof8nBxpG6qXpPBwBgdceYVnLy6m4cwtekTspJCFVjHBHDnrDzKJHhM3J1PJQytRdCKrQx1zHujA4uny	2024-04-26T14:25:59.000Z	SysvarC1ock11111111111111111111111111111111	Stake11111111111111111111111111111111111111	AddValidatorToPool	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	11111111111111111111111111111111	4uSMQWg19CNj4qEnTDfZpRuTKbUTeFF1KRACS7PSzRjX	2	246	3etKXcW2fzEJR5YXoSKSmP6UZ633g9uiFv5yuqFUf66k	57RrmRqAyha3jT6Z3RZom6EfwRm1q61Rw4Fk9hj4345E	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	A9cFPZSwRgFqiv52KjFj5NvgAQvLd3boUFzq5bFTw63B

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.MultiValidatorStakePool_AddValidatorToPool_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiValidatorStakePool_Initialize_instruction

Stake pool initialization events from Sanctum v1 protocol on Solana, recording creation of multi-validator liquid staking pools with configuration parameters including fee structures (deposit, withdrawal, management), validator limits, and pool mint tokens. Used for tracking new stake pool deployments and analyzing fee models across different liquid staking token (LST) implementations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.
`in_manager_pool_account`	`STRING`	Account address where pool tokens are minted to the manager upon initialization. Base58-encoded Solana address controlled by the stake pool manager.
`in_pool_mint`	`STRING`	Address of the liquid staking token (LST) mint account created for the stake pool. This is the SPL token that depositors receive in exchange for their staked SOL.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_reserve_stake`	`STRING`	Solana account address of the reserve stake account used to store unstaked SOL in the multi-validator stake pool. Base58-encoded string identifier that holds liquid reserves for withdrawals and deposits.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_stake_pool_withdraw_authority`	`STRING`	Program-derived address (PDA) with authority to withdraw SOL from the stake pool’s reserve. This address is controlled by the stake pool program and manages unstaking operations.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_token_program`	`STRING`	Address of the Solana Token Program. Base58-encoded public key, constant value TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`in_validator_list`	`STRING`	Account address of the validator list storing registered validators for the stake pool. Base58-encoded Solana public key.
`in_deposit_fee_denominator`	`STRING`	Denominator for calculating deposit fees when adding stake to the pool. Combined with in_deposit_fee_numerator to form a fraction (e.g., 1/1000 = 0.1% fee).
`in_deposit_fee_numerator`	`STRING`	Numerator portion of the deposit fee fraction charged when users stake SOL into the pool. Combined with in_deposit_fee_denominator to calculate the actual fee percentage (e.g., 1/1000 = 0.1%).
`in_fee_denominator`	`STRING`	Denominator for fee calculation. Decimal string representation forming the basis of a fraction with the corresponding numerator to determine fee percentage.
`in_fee_numerator`	`STRING`	Numerator for fee calculation. Decimal string representation forming the upper part of a fraction with the corresponding denominator to determine fee percentage.
`in_max_validators`	`STRING`	Maximum number of validators allowed in this stake pool at initialization. Determines the capacity of the validator list and is typically set between 20 and 3950 depending on pool size requirements.
`in_referral_fee`	`STRING`	Percentage of fees allocated to referrers for bringing users to the stake pool. Typically set to 0 in most pools, indicating no referral program is active.
`in_withdrawal_fee_denominator`	`STRING`	Denominator for calculating withdrawal fee percentage when unstaking from the pool. Combined with `in_withdrawal_fee_numerator`, determines the fee charged (e.g., numerator 1 and denominator 1000 equals 0.1% fee).
`in_withdrawal_fee_numerator`	`STRING`	Numerator of the withdrawal fee fraction charged when users unstake from the pool. Combined with denominator to calculate the percentage fee (e.g., “0” means no withdrawal fee, “1” with denominator “1000” equals 0.1%).

Sample Data

in_staker	block_slot	in_manager	in_pool_mint	in_remaining	in_stake_pool	surrogate_key	transaction_id	block_timestamp	in_fee_numerator	in_reserve_stake	in_token_program	instruction_type	executing_account	in_max_validators	in_validator_list	instruction_index	transaction_index	in_fee_denominator	transaction_signer	in_manager_pool_account	in_deposit_fee_numerator	in_deposit_fee_denominator	in_withdrawal_fee_denominator	in_stake_pool_withdraw_authority
GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	262467191	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	fpSoL8EJ7UA5yJxFKWk1MFiWi35w8CbH36G5B9d7DsV	[]	GutG5bcmEZw15WmPHNVMWHU77c6t8CEinUEdPLYz3doa	262467191-5UGwzzenjaagqpuNW4y37YyF3rWv5a729NoZFytfDFHye3p5EgVcwXVPnYnT8H5gY5Cm3yNhMfHmTPYpZ8YhnCpg-5	5UGwzzenjaagqpuNW4y37YyF3rWv5a729NoZFytfDFHye3p5EgVcwXVPnYnT8H5gY5Cm3yNhMfHmTPYpZ8YhnCpg	2024-04-27T04:38:27.000Z	100	CLYjc1sSoD6oo6Lopn1J28YGRnwveHsCZWjyu41KfLUQ	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	20	DfVmEvxkRBgFfYHgrtN9AcEv7gWXUtB1QZ6hkD3aYzsc	5	73	100	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	3Nd8iKMueHebdb5pqUwGYfYsrV6UF9hiBdc2rSTPaS76	1	1000	0	CVVUc2Rgj3PeXeepNjxEBHqEfd2nNMdavXeWWx7DP2Yq
GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	269608500	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	AxM7a5HNmRNHbND6h5ZMSsU8n3NLa1tskoN6m5mAgVvL	[]	CAEsfzw43mvaVauCxXCSJh8DvnFsTMiTyeL1kjs6UwaT	269608500-5tYEEVFXnbxHXA82hnj7kPn6pyCZafpbiHsCdxBztPr3BRx8KvRegARK9KtQCR6xPx342b1X5ta7QyT8VcNwEN8r-5	5tYEEVFXnbxHXA82hnj7kPn6pyCZafpbiHsCdxBztPr3BRx8KvRegARK9KtQCR6xPx342b1X5ta7QyT8VcNwEN8r	2024-06-03T09:24:06.000Z	1000	EvkcQHxJ1ASrq6Yc5SySbQTkmNwMQFrT3tZpaP4pseUU	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	1000	8QsyXperTQHzv7huu1ZB1QV9jzD7BKzNVkgsniCqzUGL	5	15	1000	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	3hk5m88EdDyHH6QABAMTZDAgVGRS16oTL9isctu1oMwC	1	1000	0	66EXYBt7oPsx4rXXHHzxBQxwWehaAEDdZnwaQu7uR2sY
phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit	260739588	phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit	phaseZSfPxTDBpiVb96H4XFSD8xHeHxZre5HerehBJG	[]	phasejkG1akKgqkLvfWzWY17evnH6mSWznnUspmpyeG	260739588-4YRfsPUw43kDXcPFsWpffVdg8FKrcQ6YzRyYnjGjLZynqBvJxnZiDgmZMEMeFZyjXVA65RUtYcu1kbxrYyR36Y2G-5	4YRfsPUw43kDXcPFsWpffVdg8FKrcQ6YzRyYnjGjLZynqBvJxnZiDgmZMEMeFZyjXVA65RUtYcu1kbxrYyR36Y2G	2024-04-17T23:06:58.000Z	0	phaseECAeXantYWXvRGkmeh7ddQsUJTf7DcywquY9Z2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	3950	phaseeExd43yGjjad2FZSigdG9UTRpMdxS4aMerx821	5	0	100	phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit	3Y3bNqaRLFiG8w3wUUE82oEsbMwc8NjnJ5QLyn39APPU	1	1000	1000	9HYjrCF5evTobLmay372kpUWSNTrtmDU2NkQtqjdnHKa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.MultiValidatorStakePool_Initialize_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiValidatorStakePool_RemoveValidatorFromPool_instruction

Validator removal instructions from Sanctum’s multi-validator stake pool program on Solana. Tracks administrative actions where validators are removed from liquid staking pools, including stake account transitions and pool authority signatures.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_stake_account`	`STRING`	Solana address of the validator’s stake account being removed from the pool. This account holds the delegated SOL stake that is being deactivated or withdrawn.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_stake_pool_withdraw`	`STRING`	Account address authorized to withdraw from the stake pool. Base58-encoded Solana public key.
`in_stake_program`	`STRING`	Program address of the Solana Stake Program. Base58-encoded public key, constant value Stake11111111111111111111111111111111111111.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_sysvar_clock`	`STRING`	Address of the Solana Clock Sysvar account. Base58-encoded public key, constant value SysvarC1ock11111111111111111111111111111111.
`in_transient_stake_account`	`STRING`	Address of the temporary stake account used during the validator removal process. This account holds stake funds in transit before they are merged back into the pool.
`in_validator_list`	`STRING`	Account address of the validator list storing registered validators for the stake pool. Base58-encoded Solana public key.

Sample Data

in_staker	block_slot	in_remaining	in_stake_pool	surrogate_key	transaction_id	block_timestamp	in_sysvar_clock	in_stake_account	in_stake_program	instruction_type	executing_account	in_validator_list	instruction_index	transaction_index	transaction_signer	in_stake_pool_withdraw	in_transient_stake_account
phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit	281513620	[]	phasejkG1akKgqkLvfWzWY17evnH6mSWznnUspmpyeG	281513620-5mNFfrfzZFuQDmPnuYmLwgbdXkTXqibQ87bbCQYCy8s55y8HiXpZC9uxMZoDQHYhMiHYi1z3cPwJHj9MAHXAredn-3	5mNFfrfzZFuQDmPnuYmLwgbdXkTXqibQ87bbCQYCy8s55y8HiXpZC9uxMZoDQHYhMiHYi1z3cPwJHj9MAHXAredn	2024-08-04T12:53:37.000Z	SysvarC1ock11111111111111111111111111111111	Esux8mWpqUjkwcHB8jyb8ahEGb6swLUWEGmAEa25Ex1L	Stake11111111111111111111111111111111111111	RemoveValidatorFromPool	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	phaseeExd43yGjjad2FZSigdG9UTRpMdxS4aMerx821	3	55	phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit	9HYjrCF5evTobLmay372kpUWSNTrtmDU2NkQtqjdnHKa	6WNJqmCXo9K42dxVuJ1bu79GJwnys7DxfM39rFS2FBzU
4R5j71yLdVa8TQdFuSqCdetSAViiXTHtTPU4ALyaZFoc	320461994	[]	Bvbu55B991evqqhLtKcyTZjzQ4EQzRUwtf9T4CcpMmPL	320461994-3BRTGZJ4QBX2pQrRKvNCEZE1Sz5f2DgWbPm3G1xQcwYLpydqavHLAAiouqVKQYUxS2wq1pyLWiEfGbbMxBVof5Pk-2	3BRTGZJ4QBX2pQrRKvNCEZE1Sz5f2DgWbPm3G1xQcwYLpydqavHLAAiouqVKQYUxS2wq1pyLWiEfGbbMxBVof5Pk	2025-02-13T21:31:52.000Z	SysvarC1ock11111111111111111111111111111111	KrWnfQSbAiHCZXw4R5ZkZpzGWrnjBJ8zkqD4LgSAdYL	Stake11111111111111111111111111111111111111	RemoveValidatorFromPool	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	98BPxQ3qwLDQWRcuvWwFbAabJSprANhiUPuHndv3VP8M	2	5	4R5j71yLdVa8TQdFuSqCdetSAViiXTHtTPU4ALyaZFoc	5ugu8RogBq5ZdfGt4hKxKotRBkndiV1ndsqWCf7PBmST	FAfF7BgGLWraZG275A7vNbLPGvBxx2iCdCKB3zSLUdcb
4R5j71yLdVa8TQdFuSqCdetSAViiXTHtTPU4ALyaZFoc	320461924	[]	Bvbu55B991evqqhLtKcyTZjzQ4EQzRUwtf9T4CcpMmPL	320461924-44my8fKdaMW4cT8HGrSC9YQt5gkp2jBEsJfXG3e59r2fNE6CB3HLQYyAXpYRyFywUMSkzPvYQ6rT2QspTbDwFrok-3	44my8fKdaMW4cT8HGrSC9YQt5gkp2jBEsJfXG3e59r2fNE6CB3HLQYyAXpYRyFywUMSkzPvYQ6rT2QspTbDwFrok	2025-02-13T21:31:25.000Z	SysvarC1ock11111111111111111111111111111111	HURCzd6bex9keZZZ7SckXqG5P5ra48xUjH5s4H3rCsBx	Stake11111111111111111111111111111111111111	RemoveValidatorFromPool	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	98BPxQ3qwLDQWRcuvWwFbAabJSprANhiUPuHndv3VP8M	3	125	4R5j71yLdVa8TQdFuSqCdetSAViiXTHtTPU4ALyaZFoc	5ugu8RogBq5ZdfGt4hKxKotRBkndiV1ndsqWCf7PBmST	2kpLgo86gavJcDTvcGtPb82pTsnar7jU27jJQDY4AwxH

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.MultiValidatorStakePool_RemoveValidatorFromPool_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiValidatorStakePool_SetFee_instruction

Fee configuration changes for Sanctum multi-validator stake pools on Solana, recording manager updates to deposit and epoch fee structures. Used to track fee policy adjustments across liquid staking pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_fee_type`	`STRING`	Type of fee being configured by this instruction. Common values include StakeDeposit (fees on deposits) and Epoch (fees on staking rewards).
`in_fee_denominator`	`STRING`	Denominator for fee calculation. Decimal string representation forming the basis of a fraction with the corresponding numerator to determine fee percentage.
`in_fee_numerator`	`STRING`	Numerator for fee calculation. Decimal string representation forming the upper part of a fraction with the corresponding denominator to determine fee percentage.

Sample Data

block_slot	in_manager	in_fee_type	in_remaining	in_stake_pool	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	in_fee_denominator	transaction_signer
272140364	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	StakeDeposit	[]	AArUn1RkrCejbciMwd9t7a8TFLHaBRHBzaQXiM9B48aH	272140364-2Pg5KuRonBzA5rwnVeZUFABZYYB2gvnssccPbmF4HpHBEDeXdXh6Rvr5oQQbdxoxw8N5QzbqWaYAZhKE98aXKGyo-2	2Pg5KuRonBzA5rwnVeZUFABZYYB2gvnssccPbmF4HpHBEDeXdXh6Rvr5oQQbdxoxw8N5QzbqWaYAZhKE98aXKGyo	2024-06-16T06:46:13.000Z	SetFee	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	2	100	100	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ
260747784	phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit	StakeDeposit	[]	phasejkG1akKgqkLvfWzWY17evnH6mSWznnUspmpyeG	260747784-5T5FWu7oAcTB5gwAB1HZe9pV7TTXKAKXGCyJYTM7pC44dPXEP6HLi8T3k3vin3tZ6xfuGKx5no6DEfT7iQA1jDXR-3	5T5FWu7oAcTB5gwAB1HZe9pV7TTXKAKXGCyJYTM7pC44dPXEP6HLi8T3k3vin3tZ6xfuGKx5no6DEfT7iQA1jDXR	2024-04-18T00:07:46.000Z	SetFee	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	3	33	1000	phaseGat2zkWtpMPbjPJWWj2EVN4tFR1HN4EqtwUzit
305742424	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	StakeDeposit	[]	EEByZqy7iTAzF3dfKZX2RVmQ8iGwGHMVxwD7mDM7Bd8A	305742424-4iXhx1CbMnnyvJAtVWZwKe25ayzNijSCyzhReHepW4MheseYrqiqXp9CpAjyRxXSiMVe1Lr85DdfKzRSrymBCxqE-2	4iXhx1CbMnnyvJAtVWZwKe25ayzNijSCyzhReHepW4MheseYrqiqXp9CpAjyRxXSiMVe1Lr85DdfKzRSrymBCxqE	2024-12-06T09:49:18.000Z	SetFee	SPMBzsVUuoHA4Jm6KunbsotaahvVikZs1JyTW6iJvbn	2	18	1000	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.MultiValidatorStakePool_SetFee_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SingleValidatorStakePool_AddValidatorToPool_instruction

AddValidatorToPool instruction events from Sanctum’s single-validator stake pool program on Solana. Records validator additions to stake pools including stake accounts, pool authorities, and Solana system program accounts for analyzing pool composition changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_reserve_stake_account`	`STRING`	Account address of the stake pool’s reserve, which holds unstaked SOL for liquidity. Base58-encoded Solana address that serves as the source of funds when adding validators to the pool.
`in_stake`	`STRING`	Amount of staked or collateralized tokens denominated in the smallest unit of the asset. String-encoded decimal value representing wei for EVM chains or lamports for Solana.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_stake_pool_withdraw`	`STRING`	Account address authorized to withdraw from the stake pool. Base58-encoded Solana public key.
`in_stake_program`	`STRING`	Program address of the Solana Stake Program. Base58-encoded public key, constant value Stake11111111111111111111111111111111111111.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_sysvar_clock`	`STRING`	Address of the Solana Clock Sysvar account. Base58-encoded public key, constant value SysvarC1ock11111111111111111111111111111111.
`in_sysvar_rent`	`STRING`	Solana system variable account address for rent calculations, used to determine rent-exempt balances during stake account creation. Always set to the constant address SysvarRent111111111111111111111111111111111 across all transactions.
`in_sysvar_stake_config`	`STRING`	Address of the Solana sysvar account containing network-wide stake configuration parameters. Always set to the canonical StakeConfig program ID for stake pool operations.
`in_sysvar_stake_history`	`STRING`	Solana sysvar account containing historical stake activations and deactivations for the network. Always set to the canonical address SysvarStakeHistory1111111111111111111111111.
`in_validator`	`STRING`	Solana address of the validator being added to the stake pool. Base58-encoded public key identifying the validator node receiving delegated stake.
`in_validator_list`	`STRING`	Account address of the validator list storing registered validators for the stake pool. Base58-encoded Solana public key.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_seed`	`STRING`	Seed value used to derive the stake account’s program-derived address. Typically ‘0’ for the first validator added to the pool.

Sample Data

in_stake	in_staker	block_slot	in_remaining	in_validator	in_stake_pool	surrogate_key	in_sysvar_rent	transaction_id	block_timestamp	in_sysvar_clock	in_stake_program	instruction_type	executing_account	in_system_program	in_validator_list	instruction_index	transaction_index	transaction_signer	in_stake_pool_withdraw	in_sysvar_stake_config	in_sysvar_stake_history	in_reserve_stake_account
8FSzHpLjxgXiVsMsU7xknyr4v4f4Me2MGgdxTBpqvo6W	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	312488954	[]	LAKEuKJQYVFpf4vyjX7iuf9ajHo3k9FiyewYKf6VxPV	95tkNsPVV3gTwG3jrxSbbVowo5WG2VZDY2efze2EQ3pD	312488954-DQa3knymsQwKmmKcRr2cehqDFLPeaUgD42nvDekWaxBx2FaQqKvDV3srir3ofiZASpiurW1WshoYCqJusoQmXUi-2	SysvarRent111111111111111111111111111111111	DQa3knymsQwKmmKcRr2cehqDFLPeaUgD42nvDekWaxBx2FaQqKvDV3srir3ofiZASpiurW1WshoYCqJusoQmXUi	2025-01-07T16:31:01.000Z	SysvarC1ock11111111111111111111111111111111	Stake11111111111111111111111111111111111111	AddValidatorToPool	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	11111111111111111111111111111111	EwnQABa9fobijA5zGQybJSDhGv6jW74pNhz1haaYAoqf	2	132	GFHMc9BegxJXLdHJrABxNVoPRdnmVxXiNeoUCEpgXVHw	HLB6bae2VoYiqcxjZgx5UJU5QetLVQbxhCSsz26WZ4u9	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	6PUQd8aqpKTLSpBonP4Yk5t2zJhA6pHVsuF7qeNVSVuW
4QmxjqLJTeAh41JZM5ppZUrMY5Gd97oAfZvBXyWkyygJ	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	254372026	[]	FACqsS19VScz8oo2YhdMg35EsAy6xsCZ9Y58eJXGv8QJ	LW3qEdGWdVrxNgxSXW8vZri7Jifg4HuKEQ1UABLxs3C	254372026-3DfvHt8gvzTY1GXuNLnqmsmF7R4yx7hEuN8FZTDhNwjXgDHbx7MqLeU4g1LPXWDvuiGqZBdFTCevbDrX1JZ3Apk-0	SysvarRent111111111111111111111111111111111	3DfvHt8gvzTY1GXuNLnqmsmF7R4yx7hEuN8FZTDhNwjXgDHbx7MqLeU4g1LPXWDvuiGqZBdFTCevbDrX1JZ3Apk	2024-03-15T18:40:26.000Z	SysvarC1ock11111111111111111111111111111111	Stake11111111111111111111111111111111111111	AddValidatorToPool	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	11111111111111111111111111111111	GM7T5roJWhQchJErSZdPeHvkw43MkvVC6b8DK4BNuidP	0	133	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	6Sw4WcMTakZFrd19Q4hTH8ewiLxXXTCuBdVxAaneg1fo	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	EH7jVtxJbpMNwmkJFREAEPBseTmE5CTNtLC4Wh8u48eS
6sHZAhxH7UFMmvgguACofxLzd7GcfBgAfhvqzp8eA7LB	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	270951560	[]	2ayMCC4aizr8RGg5ptXYqu8uoxW1whNek1hE1zaAd58z	HSDnqBq7EnfcKpnw52DTAZrP38tf8rdWLiRhQo4qGTUa	270951560-5cyS2Uk1JdrTeDyN6r1CS3NuUM2efoH5wQy2j5quBEYnLVeHZHauNqvDYYzeFPRA2XK7HrJqm12QqMw9Sx7Eggxr-2	SysvarRent111111111111111111111111111111111	5cyS2Uk1JdrTeDyN6r1CS3NuUM2efoH5wQy2j5quBEYnLVeHZHauNqvDYYzeFPRA2XK7HrJqm12QqMw9Sx7Eggxr	2024-06-10T05:01:28.000Z	SysvarC1ock11111111111111111111111111111111	Stake11111111111111111111111111111111111111	AddValidatorToPool	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	11111111111111111111111111111111	9JLWSXToxx1Kn28jwix3eCUc4Rvz3VN41Km3tKA4adFB	2	26	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	9Ydzb2u5GUnwWHw1xwaVNZcZeaUrqHe6LmeisbML1KQ5	StakeConfig11111111111111111111111111111111	SysvarStakeHistory1111111111111111111111111	Cz3g2KcBtTtfQut1mmF8F3iz8SGZ4wdiAbCZ92V9aHJk

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.SingleValidatorStakePool_AddValidatorToPool_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SingleValidatorStakePool_Initialize_instruction

Initialize instruction events for Sanctum single-validator stake pools on Solana. Captures pool creation parameters including fee structures (deposit/withdrawal), manager accounts, validator lists, and pool mint addresses for tracking liquid staking pool deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.
`in_manager_pool_account`	`STRING`	Account address designated to receive pool management fees and rewards. Owned by the manager, used for collecting protocol revenue from stake pool operations.
`in_pool_mint`	`STRING`	Account address of the stake pool’s liquidity pool token (LP token) mint. This token represents proportional ownership in the stake pool and is minted to depositors.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_reserve_stake`	`STRING`	Solana account address holding the reserve stake for the stake pool. Base58-encoded identifier representing the pool’s liquidity buffer for immediate withdrawals.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_stake_pool_withdraw_authority`	`STRING`	Program-derived address (PDA) with authority to withdraw stake from the pool’s reserve account. Base58-encoded Solana account address that serves as the authorized signer for unstaking operations.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_token_program`	`STRING`	Address of the Solana Token Program. Base58-encoded public key, constant value TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`in_validator_list`	`STRING`	Account address of the validator list storing registered validators for the stake pool. Base58-encoded Solana public key.
`in_deposit_fee_denominator`	`STRING`	Denominator of the deposit fee fraction applied when users deposit SOL into the stake pool. Paired with `in_deposit_fee_numerator` to calculate the percentage fee (e.g., “1000” with numerator “1” equals 0.1%).
`in_deposit_fee_numerator`	`STRING`	Numerator component of the deposit fee fraction applied when users deposit into the stake pool. Combined with `in_deposit_fee_denominator` to calculate the percentage fee (e.g., ‘1’ and ‘1000’ = 0.1% fee).
`in_fee_denominator`	`STRING`	Denominator for fee calculation. Decimal string representation forming the basis of a fraction with the corresponding numerator to determine fee percentage.
`in_fee_numerator`	`STRING`	Numerator for fee calculation. Decimal string representation forming the upper part of a fraction with the corresponding denominator to determine fee percentage.
`in_max_validators`	`STRING`	Maximum number of validators allowed in this stake pool. Typically set to 1-20 validators per pool during initialization.
`in_referral_fee`	`STRING`	Referral fee amount charged as basis points on stake pool operations. Typically 0, indicating no referral fees are collected by the pool.
`in_withdrawal_fee_denominator`	`STRING`	Denominator for the withdrawal fee fraction charged when unstaking from the pool. Combined with in_withdrawal_fee_numerator to calculate the fee percentage (e.g., 1/1000 = 0.1% fee).
`in_withdrawal_fee_numerator`	`STRING`	Numerator component of the withdrawal fee fraction charged when unstaking from the pool. Combined with the denominator to calculate the percentage fee (e.g., ‘1’ with denominator ‘1000’ equals 0.1%).

Sample Data

in_staker	block_slot	in_manager	in_pool_mint	in_remaining	in_stake_pool	surrogate_key	transaction_id	block_timestamp	in_fee_numerator	in_reserve_stake	in_token_program	instruction_type	executing_account	in_max_validators	in_validator_list	instruction_index	transaction_index	in_fee_denominator	transaction_signer	in_manager_pool_account	in_deposit_fee_numerator	in_deposit_fee_denominator	in_withdrawal_fee_numerator	in_withdrawal_fee_denominator	in_stake_pool_withdraw_authority
GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	310170498	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	LUX8NDStbKJhzMuH7abY4va81YaubLw3Vto5rmb66Lw	[]	HZfhhGDQafoGcSRNXUfZojnsKCCacKMXr1ufLpcC4cGX	310170498-5qyXhKsQN9bMCRtMszuyTZ5ASKAbFHwx2wFMfgUtx8u5PUXmLvju2jK7pjYXkAiT1ngqYLed97zRkRpv4bFMJNo8-5	5qyXhKsQN9bMCRtMszuyTZ5ASKAbFHwx2wFMfgUtx8u5PUXmLvju2jK7pjYXkAiT1ngqYLed97zRkRpv4bFMJNo8	2024-12-27T16:26:48.000Z	0	FXYnYtuudM9vXnn8NhpUSph21iNdyDJKucR4xeutQ1Br	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	10	GvVYboeccdY5NvFsS1aeaQGvC3yT8jF3SNf4JL2xfgAg	5	72	100	GFHMc9BegxJXLdHJrABxNVoPRdnmVxXiNeoUCEpgXVHw	B4szP3qPPDXHHS2LHG4juiS9a5XCDqHYoH9DHyihFPeM	1	1000	0	100	4R1L9q6sRopHKtQD1rpd7tBnUcu1jduXD3C6LfX3ViaV
GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	344809010	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	7RN7JErHv958SNeYeCN8ihScnkyVtCahSaexfRP8Pw6s	[]	2ErDD1kBrXyQmNWrojkgWKFDSsw2S1q55DXMmCT5bZnS	344809010-4k732yuGkn7v1M9skLXp6rpZ5uUeKwE1RmBS7FkUN9RnswADnBwMBVLUKcVgGT2ozdK5Y4kk7rAZ1EeXbs1LkiXJ-5	4k732yuGkn7v1M9skLXp6rpZ5uUeKwE1RmBS7FkUN9RnswADnBwMBVLUKcVgGT2ozdK5Y4kk7rAZ1EeXbs1LkiXJ	2025-06-05T15:33:54.000Z	50	D85giaCcmBAJfauRLAKWzm3SVWj29ht4wRtywU2hV75v	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	10	7terKDqcS37Pr3ooP6G8RsJcLHRQ2nguMUxzP42zbz6a	5	119	1000	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	E8ehnc15sJkJ97m4KYLqA9mGyWyoyHAumigBkeL61ASC	0	0	1	1000	EFii7eEYeoFzpX2CXpbv8D1J35fxeqFnF3v7bhWnV5hk
GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	344808984	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	79bnSzQdKyqypcueaCErrMHosPgk7ZEVrLYrAXk8yk2c	[]	7snAkZeMdg77L2BrDYKdaXiA4itam1kUGcLqD9GDLHGJ	344808984-3JyY64DmVpmWNHcWBiPyo9gXBteqA2N1JmP1AXgH9ggyKxLksAQZG9PPkQnExMJfPUDfSN5n2XyraB56htJHmD5w-5	3JyY64DmVpmWNHcWBiPyo9gXBteqA2N1JmP1AXgH9ggyKxLksAQZG9PPkQnExMJfPUDfSN5n2XyraB56htJHmD5w	2025-06-05T15:33:44.000Z	25	67jRjjcgWppazoo7x81iCWgYGqkuUkXJNZsVKUNAj5GG	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	10	6oDAQRzXU7z1DfX6fGzZhJgxJ6HH1q6SPanhzjdj6bdC	5	416	1000	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	GQdqdB7Pym85xKf5UJPBLoSYgdpvaxEK4nW82Bk9enpU	0	0	1	1000	6bFhMu9R3VQfbzfN6GUv8hrdruueDMnqr2cRdKG3gKDS

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.SingleValidatorStakePool_Initialize_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SingleValidatorStakePool_RemoveValidatorFromPool_instruction

Instruction-level records of validator removals from Sanctum single-validator stake pools on Solana. Tracks stake account deactivations, transient stake movements, and authorized staker actions for analyzing pool rebalancing and validator management operations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_stake_account`	`STRING`	Account holding the staked SOL being removed from the validator pool. Base58-encoded Solana public key identifying the stake account to be withdrawn.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_stake_pool_withdraw`	`STRING`	Account address authorized to withdraw from the stake pool. Base58-encoded Solana public key.
`in_stake_program`	`STRING`	Program address of the Solana Stake Program. Base58-encoded public key, constant value Stake11111111111111111111111111111111111111.
`in_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_sysvar_clock`	`STRING`	Address of the Solana Clock Sysvar account. Base58-encoded public key, constant value SysvarC1ock11111111111111111111111111111111.
`in_transient_stake_account`	`STRING`	Account address of the temporary stake account used during validator removal from the pool. This transient account facilitates the stake withdrawal process before final deactivation.
`in_validator_list`	`STRING`	Account address of the validator list storing registered validators for the stake pool. Base58-encoded Solana public key.

Sample Data

in_staker	block_slot	in_remaining	in_stake_pool	surrogate_key	transaction_id	block_timestamp	in_sysvar_clock	in_stake_account	in_stake_program	instruction_type	executing_account	in_validator_list	instruction_index	transaction_index	transaction_signer	in_stake_pool_withdraw	in_transient_stake_account
89VB5UmvopuCFmp5Mf8YPX28fGvvqn79afCgouQuPyhY	310022292	[]	SzoSoRxsrL9sbFcwpbjbH5bRrzuvFtuytZTeuqZCfQ6	310022292-4V8pezMQui16mSK655d5GHNFKa8AvamKVrimLU5sjG5zdYcxqu7r69hRGmak1hk9qCNpDJbpEvS11NYdFTNs1iCA-2	4V8pezMQui16mSK655d5GHNFKa8AvamKVrimLU5sjG5zdYcxqu7r69hRGmak1hk9qCNpDJbpEvS11NYdFTNs1iCA	2024-12-26T23:40:11.000Z	SysvarC1ock11111111111111111111111111111111	C5QCedaLbwwu44hVkuNHSR9skFpPi4dQVhubhhCNMag1	Stake11111111111111111111111111111111111111	RemoveValidatorFromPool	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	GoabVWYUt9sui4KuNW1s7ELtHV2DS3TL7fYZu4soUnkX	2	3	89VB5UmvopuCFmp5Mf8YPX28fGvvqn79afCgouQuPyhY	CA7yTjzt8JgkyamhoNveQZP9TMMZFcUyDabsYWBZipt6	5aBztYHtX3AjDVAatTrgJPGG61wBoLr9a18xTXXsemrf
7KUm928PQhpNukeKDkUgBz6gbXEo8oKnbD2XwqP7yw2H	292424864	[]	AwDeTcW6BovNYR34Df1TPm4bFwswa4CJY4YPye2LXtPS	292424864-dmGNB9o5n3HXJ3vqJJL2dfiqbjCzuwYm65WUzHgym8xsXbSnrDxejdv2rLn7jZBgnPZquyx5JEXwXKQFJK3j7cJ-3	dmGNB9o5n3HXJ3vqJJL2dfiqbjCzuwYm65WUzHgym8xsXbSnrDxejdv2rLn7jZBgnPZquyx5JEXwXKQFJK3j7cJ	2024-09-28T03:54:30.000Z	SysvarC1ock11111111111111111111111111111111	7xgW2ELnvY8jEmQb11LkcHkEKFoy19EcjmMVi13v7pfz	Stake11111111111111111111111111111111111111	RemoveValidatorFromPool	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	DgSrw8Kmww4wVC1KaHFrEYE3UiCupNpLde2CcUEmGYsx	3	51	7KUm928PQhpNukeKDkUgBz6gbXEo8oKnbD2XwqP7yw2H	3SpAsJj9mXsDmwtaE6zSgEh78ZZE278TBnYgAAy5DHaM	5L7Fkd3btBEg3VCqgXUEda4mnQxEekr9yXJeZLafZfso
EG976hUYS3Mwf595uk9irszydggWzB3tBDobbMffyScq	303712084	[]	FxhzbU8rn4MhZxmeH2u7M18qkvFH3LjkWk8z9686TE45	303712084-tAy8mPaqM1jFBdoYdVqrSyLyaKqkpBJtB9tSd2mNhGWPQAcB2tiba9DGbNcRmAzaUXqeftffbm4Zpkd4iDTBQZN-2	tAy8mPaqM1jFBdoYdVqrSyLyaKqkpBJtB9tSd2mNhGWPQAcB2tiba9DGbNcRmAzaUXqeftffbm4Zpkd4iDTBQZN	2024-11-26T09:53:13.000Z	SysvarC1ock11111111111111111111111111111111	9U5M4cNoKYrPhjEnEo3f47DytHExbRgCDHyReS96atxP	Stake11111111111111111111111111111111111111	RemoveValidatorFromPool	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	4zDzb3SKgCuHoT9qnUy1M7xT5vQyRuVzEwA5egmaqc8F	2	30	EG976hUYS3Mwf595uk9irszydggWzB3tBDobbMffyScq	3LXLNjGGS8XhPmco5vhScyW8cb3TVPmpF7pr7k7ZfCoW	ECZLbaHcWdj1NDZsnJdSN13mxcWv38XeZiQWwXsawjVo

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.SingleValidatorStakePool_RemoveValidatorFromPool_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SingleValidatorStakePool_SetFee_instruction

Fee configuration changes for Sanctum single-validator stake pools on Solana, capturing manager-initiated updates to deposit, withdrawal, and epoch fee rates with numerator/denominator structures.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_stake_pool`	`STRING`	Account address of the Solana stake pool program. Base58-encoded Solana public key.
`in_fee_type`	`STRING`	Type of fee being configured for the stake pool operation, such as StakeDeposit, StakeWithdrawal, SolDeposit, SolWithdrawal, or Epoch. Indicates which specific transaction type this fee setting applies to.
`in_fee_denominator`	`STRING`	Denominator for fee calculation. Decimal string representation forming the basis of a fraction with the corresponding numerator to determine fee percentage.
`in_fee_numerator`	`STRING`	Numerator for fee calculation. Decimal string representation forming the upper part of a fraction with the corresponding denominator to determine fee percentage.

Sample Data

block_slot	in_manager	in_fee_type	in_remaining	in_stake_pool	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	in_fee_denominator	transaction_signer
284927716	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	StakeDeposit	[]	2aMLkB5p5gVvCwKkdSo5eZAL1WwhZbxezQr1wxiynRhq	284927716-4e1Hv8RxT1x6Ynw4b3pyLgp5MkKrXptEiJrh7ZkkcCcNGTugFuqrcXxUmv4aNhr62u2Tm7ZcWgVHcPcsaoe7A6sX-2	4e1Hv8RxT1x6Ynw4b3pyLgp5MkKrXptEiJrh7ZkkcCcNGTugFuqrcXxUmv4aNhr62u2Tm7ZcWgVHcPcsaoe7A6sX	2024-08-21T10:27:20.000Z	SetFee	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	2	1	100	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ
321300084	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	StakeDeposit	[]	8iax3u8PEcP6VhBtLLG7QAoSrCp7fUbCJtmHPrqHxdas	321300084-2r23P3jXxXiT6uTETFVzX1sZG1CD16XHB5nz2h66mZMqcHXidVmaJDL8eV8tEnGz3KieFrmxZDqrSh4G2yKtp3GD-3	2r23P3jXxXiT6uTETFVzX1sZG1CD16XHB5nz2h66mZMqcHXidVmaJDL8eV8tEnGz3KieFrmxZDqrSh4G2yKtp3GD	2025-02-17T17:49:44.000Z	SetFee	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	3	220	0	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ
321300084	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ	StakeWithdrawal	[]	8iax3u8PEcP6VhBtLLG7QAoSrCp7fUbCJtmHPrqHxdas	321300084-2r23P3jXxXiT6uTETFVzX1sZG1CD16XHB5nz2h66mZMqcHXidVmaJDL8eV8tEnGz3KieFrmxZDqrSh4G2yKtp3GD-2	2r23P3jXxXiT6uTETFVzX1sZG1CD16XHB5nz2h66mZMqcHXidVmaJDL8eV8tEnGz3KieFrmxZDqrSh4G2yKtp3GD	2025-02-17T17:49:44.000Z	SetFee	SP12tWFxD9oJsVWNavTTBZvMbA6gkAmxtVgxdqvyvhY	2	220	0	GRwm4EXMyVwtftQeTft7DZT3HBRxx439PrKq4oM6BwoZ

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.sanctum_v1_solana.SingleValidatorStakePool_SetFee_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Controller_AddLst_instruction

MultiValidatorStakePool_AddValidatorToPool_instruction

MultiValidatorStakePool_Initialize_instruction

MultiValidatorStakePool_RemoveValidatorFromPool_instruction

MultiValidatorStakePool_SetFee_instruction

SingleValidatorStakePool_AddValidatorToPool_instruction

SingleValidatorStakePool_Initialize_instruction

SingleValidatorStakePool_RemoveValidatorFromPool_instruction

SingleValidatorStakePool_SetFee_instruction

Metrics

Primitives

Contracts

Blockchain

​Tables

​Controller_AddLst_instruction

​MultiValidatorStakePool_AddValidatorToPool_instruction

​MultiValidatorStakePool_Initialize_instruction

​MultiValidatorStakePool_RemoveValidatorFromPool_instruction

​MultiValidatorStakePool_SetFee_instruction

​SingleValidatorStakePool_AddValidatorToPool_instruction

​SingleValidatorStakePool_Initialize_instruction

​SingleValidatorStakePool_RemoveValidatorFromPool_instruction

​SingleValidatorStakePool_SetFee_instruction

Tables

Controller_AddLst_instruction

MultiValidatorStakePool_AddValidatorToPool_instruction

MultiValidatorStakePool_Initialize_instruction

MultiValidatorStakePool_RemoveValidatorFromPool_instruction

MultiValidatorStakePool_SetFee_instruction

SingleValidatorStakePool_AddValidatorToPool_instruction

SingleValidatorStakePool_Initialize_instruction

SingleValidatorStakePool_RemoveValidatorFromPool_instruction

SingleValidatorStakePool_SetFee_instruction