orca_v1_solana

Tables

Staking_Stake_instruction

Stake instruction calls to Orca’s liquid staking program on Solana, recording user deposits into the StaKE validator pool. Contains transaction metadata and signer addresses for analyzing staking activity patterns and deposit volume.

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.

Sample Data

block_slot	transaction_id	block_timestamp	executing_account	instruction_index	transaction_index	transaction_signer
371375308	5DWMPMNx5ApD5Piura3UW1Yh82hL975V7WnRrGxPUPXBJohAM1WU7e7ZFBvA1BL9FxgJxL9iexTcWRexFYrfbPXR	2025-10-05T14:55:56.000Z	StaKE6XNKVVhG8Qu9hDJBqCW3eRe7MDGLz17nJZetLT	1	30	93f7gdxUL5xieGngKeAUt8JTbdVnKyH2izc3SYqc4KTD
371309367	2vupk9J5UcJcS1XHS4mvBTr2otGu28ZDW4LC7gojmQzx2FfWF9rZQxUR5DzHckWJJdLHMtxPKo8jd81iC9kixZm5	2025-10-05T07:41:23.000Z	StaKE6XNKVVhG8Qu9hDJBqCW3eRe7MDGLz17nJZetLT	1	89	8x6GKf7iVAKw2mUq5jYnCt33WxDpyiCQdR2JAuhxj8NT
371430316	3P9ZrSd8RDaMB9AXGxo9ERGpYiwKb3MQdNWW2x4Z9ss3Xs6bgdGkHUFvikcpAuuxexFRjdPjMdNgZXC9M2aKb42S	2025-10-05T20:58:20.000Z	StaKE6XNKVVhG8Qu9hDJBqCW3eRe7MDGLz17nJZetLT	1	108	54bGAPhbovzdVzdasLNKEkM41vjC3tCHTLA4CTdnro3S

Example Query

Query with partition filter

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

TokenSwapV2_Initialize_instruction

Liquidity pool initialization events from Orca V1 automated market maker on Solana, capturing pool creation parameters including token pairs, fee structures (trade, owner, host fees with numerators/denominators), curve types (ConstantProduct or Offset), and associated token accounts for analyzing pool deployment patterns and fee configurations.

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_hostFeeDenominator`	`STRING`	Denominator used to calculate fees paid to hosts who facilitate swaps on the pool. Typically 0 indicating no host fees are charged in most Orca pools.
`in_hostFeeNumerator`	`STRING`	Numerator component of the host referral fee fraction applied on trades in this liquidity pool. Typically 0, indicating no host referral fees are charged.
`in_ownerTradeFeeDenominator`	`STRING`	Denominator of the fraction representing the pool owner’s portion of trading fees. Combined with `in_ownerTradeFeeNumerator`, defines the owner fee rate (commonly 5/10000 or 0.05%).
`in_ownerTradeFeeNumerator`	`STRING`	Numerator for calculating owner’s portion of trading fees on this liquidity pool. Combined with denominator (typically 10000), determines the protocol fee rate collected by pool owners on each swap.
`in_ownerWithdrawFeeDenominator`	`STRING`	Denominator for calculating the liquidity pool owner’s withdrawal fee as a fraction (numerator/denominator). Commonly set to 0 when no owner withdrawal fees are charged.
`in_ownerWithdrawFeeNumerator`	`STRING`	Numerator for calculating pool owner withdrawal fees on liquidity removals. Typically 0, indicating no owner withdrawal fees charged on this pool.
`in_tradeFeeDenominator`	`STRING`	Denominator for calculating trade fees in basis points, paired with in_tradeFeeNumerator. Typically set to 10000, representing the divisor for fee percentage calculations (e.g., 10000 = 100% denominator).
`in_tradeFeeNumerator`	`STRING`	Numerator for calculating the trading fee charged on swaps in this pool. Combined with in_tradeFeeDenominator to form a fraction (typically 25/10000 = 0.25% fee).
`in_swapCurveType`	`STRING`	Automated market maker pricing curve model used by the liquidity pool, such as ConstantProduct or Offset. Determines how token swap prices are calculated based on pool reserves.
`in_initialPoolTokenAccount`	`STRING`	Initial liquidity provider’s pool token account that receives LP tokens upon pool creation. Base58-encoded Solana address of the token account that holds the newly minted pool tokens representing the first liquidity position.
`in_poolTokenAccount`	`STRING`	Token account that holds LP (liquidity provider) tokens issued by this swap pool. Represents the pool’s own account for managing pool token distribution to liquidity providers.
`in_poolTokenMint`	`STRING`	Mint address of the liquidity pool token (LP token) created to represent shares in this swap pool. This token is minted to liquidity providers in exchange for depositing both tokens in the pool.
`in_swapAuthority`	`STRING`	Program-derived authority account for the liquidity pool that has signing privileges over pool operations. Base58-encoded Solana public key derived deterministically from the swap account.
`in_tokenA`	`STRING`	Contract address of the first token in a token pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenB`	`STRING`	Contract address of the second token in a token pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_tokenSwapAccount`	`STRING`	Program-derived account (PDA) that stores the state and configuration of this liquidity pool. This is the main account that controls the pool’s token reserves, fees, and swap curve parameters.

Sample Data

in_tokenA	in_tokenB	block_slot	surrogate_key	transaction_id	block_timestamp	in_tokenProgram	in_poolTokenMint	in_swapAuthority	in_swapCurveType	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	in_poolTokenAccount	in_tokenSwapAccount	in_tradeFeeNumerator	in_tradeFeeDenominator	in_ownerTradeFeeNumerator	in_initialPoolTokenAccount	in_ownerTradeFeeDenominator
5k1Nj2TvG51p7s2ambWpmX6FraiSchoYS1wJgVw5f9Af	2s2vbHk4XzKQ9SQdPRyirY8JmBemhZ67EBx7xgF6tzq5	118125418	118125418-61mvZzhTB5q5tA96P1hoghKD1824HT1tcYSSy9SsZYvhMpjmmnZYuLdSJB8cFY7jLfk8WqEo5Z8cZ8aFpUDzanhq-1	61mvZzhTB5q5tA96P1hoghKD1824HT1tcYSSy9SsZYvhMpjmmnZYuLdSJB8cFY7jLfk8WqEo5Z8cZ8aFpUDzanhq	2022-01-27T20:47:21.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	FkKzu2HeMJZf4oHwoYPxLGVy3net5Jq8HAfnA5VqETgk	8GRweHBrpXfeYpmryfkvEsW3DmoJKGDQLpcVfeNUqn8x	ConstantProduct	Initialize	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	1	143	AW1ibYCXMiJEWCvdaQqrZoKXsHcpbzAgkryfKuoxkXb3	2Y1xXr1j6xg5r5Qz8LDqnU7N8T4GGu3Ju4AHGsfU2nXS	2aCJ1VTwfvLej1PJJAmiVCzuLGtjQ5bEo9DYkbwwe1C6	25	10000	5	7D74JevABQxn2xGooEoamQjy5qeJycVywRhqPPJ99FnB	10000
2vq1vt98xBPUmvbTC5nH4GtsjJVeA64kwv6CZc7xSAf6	B7f4A1Pp6RCjWYv5Lsrf4MecmZQDMekXh4MFQasCQuRB	118124734	118124734-Mrkwygu7w9Fq5o6jVQA1AfVfCwTVCp8i2TyUfhUbb7xhZ2Z6BzoCuzDGcquEXRPbAAQnvgum6uhhWsWw6rJXCq4-1	Mrkwygu7w9Fq5o6jVQA1AfVfCwTVCp8i2TyUfhUbb7xhZ2Z6BzoCuzDGcquEXRPbAAQnvgum6uhhWsWw6rJXCq4	2022-01-27T20:40:57.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	cL5WhffCYFRLM4We8VS2W684kM4pHyuvEDwp8Ddw48k	9odZioXkQTCZERzQXbDTfirMfbP9FtKqsP9LvHgm6wJr	ConstantProduct	Initialize	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	1	188	AW1ibYCXMiJEWCvdaQqrZoKXsHcpbzAgkryfKuoxkXb3	3nyqxtRPnYrwEHneWgbN1197aZoEaemnSNQ7rgJLv8hS	Fpwa7a1r7kjax1nW25TVP3uiQc7XH9dv9n9UXMJRSTEx	25	10000	5	5pSANxdi2Bbi3pgy4hq3nVLRLbGfJLFFW6BkTTVj4anJ	10000
7F2cLdio3i6CCJaypj9VfNDPW2DwT3vkDmZJDEfmxu6A	5pUTGvN2AA2BEzBDU4CNDh3LHER15WS6J8oJf5XeZFD8	90511588	90511588-5noDnwDaHrs7hDkHPmeDQsoBPguAktDF4mNnGTwvEfN5bWqsGWnDLRx8tQQKFZchRny7CMtW3TcrNUsNJyxmBRZr-1	5noDnwDaHrs7hDkHPmeDQsoBPguAktDF4mNnGTwvEfN5bWqsGWnDLRx8tQQKFZchRny7CMtW3TcrNUsNJyxmBRZr	2021-08-07T04:27:32.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	71FymgN2ZUf7VvVTLE8jYEnjP3jSK1Frp2XT1nHs8Hob	DffrDbzPiswDJaiicBBo9CjqztKgFLrqXGwNJH4XQefZ	ConstantProduct	Initialize	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	1	57	2YM8LrJGRtsDcWeqsjX2EQwJfhArxyDdtDzgt7vrwwbV	unxKgWEc71ZiHwMqZs3VLqjcjmZhfTZEg94ZLGvjdMP	EuK3xDa4rWuHeMQCBsHf1ETZNiEQb5C476oE9u9kp8Ji	25	10000	5	unxKgWEc71ZiHwMqZs3VLqjcjmZhfTZEg94ZLGvjdMP	10000

Example Query

Query with partition filter

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

TokenSwapV2_Swap_instruction

Swap instruction execution records from Orca V1 automated market maker (AMM) pools on Solana. Contains token swap parameters including input/output amounts, pool identifiers, and user accounts for analyzing decentralized exchange activity and liquidity pool behavior.

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_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_minimumAmountOut`	`STRING`	Minimum acceptable amount of output tokens for the swap to succeed, specified by the user as slippage protection. Value of 0 indicates no minimum threshold enforced.
`in_authority`	`STRING`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeAccount`	`STRING`	Account that receives trading fees from the swap transaction. Typically controlled by the liquidity pool protocol or fee collector.
`in_poolDestination`	`STRING`	Token account in the Orca pool that receives the swapped tokens being traded into. Base58-encoded Solana address of the pool’s reserve account for the output token.
`in_poolMint`	`STRING`	Mint address of the liquidity pool token (LP token) for the Orca swap pair. Base58-encoded Solana public key identifying the specific pool being traded against.
`in_poolSource`	`STRING`	Token account address serving as the source liquidity pool account in the Orca swap. This account’s balance decreases by the input amount during the swap transaction.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_tokenSwap`	`STRING`	Token swap pool program account address being interacted with in this Orca V1 swap transaction. Base58-encoded Solana public key identifying the specific liquidity pool instance.
`in_userDestination`	`STRING`	Token account receiving the output tokens after the swap completes. This is the destination account owned by the user executing the swap.
`in_userSource`	`STRING`	Token account from which the user’s input tokens are withdrawn for the swap. Base58-encoded Solana account address that must have sufficient balance and be owned by the user’s wallet.
`in_userTransferAuthority`	`STRING`	Solana account authorized to transfer tokens from the user’s source account to execute the swap. Typically matches the transaction signer or a delegated program authority.

Sample Data

block_slot	in_amountIn	in_poolMint	in_authority	in_tokenSwap	in_feeAccount	in_poolSource	in_userSource	surrogate_key	transaction_id	block_timestamp	in_tokenProgram	instruction_type	executing_account	instruction_index	transaction_index	in_poolDestination	in_userDestination	transaction_signer	in_minimumAmountOut	outer_executing_account	outer_instruction_index	in_userTransferAuthority
356206084	60007877	6fj1McV4jQ69bo6mM2xp3EVond9dUMvnAf1ypWExDaSW	7hbUFNqyPrdE83a922ahedQbm4ZEMw9eT4mGdfuJGthH	AJVEy2rzoTTSxTJSMK2CXhphoBwFdBBbRdw6jXVT1PYU	HNJv6HMXVDN1Eap5mNyhp96i1qia9XKdmriPUqwQmSB5	12uS9dmX9H38o2gHW9AhP8Si7vQ2rUmfH5D1Cz4UsYWs	3bH11JN3SqUoYebDiS4rm8XuzLa4faoL3Mq3pV7h7CXF	356206084-vv7rxrsm9MXv4XU2X7yYw4tkmZc2HAm7Tm6XEoY53cAGMwcPJSp2Qc4CpsBxjW5d48R8hw2AfiwkspLVE432gAT-3-14	vv7rxrsm9MXv4XU2X7yYw4tkmZc2HAm7Tm6XEoY53cAGMwcPJSp2Qc4CpsBxjW5d48R8hw2AfiwkspLVE432gAT	2025-07-28T02:37:58.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	14	307	7dRSfJaBVjhdTTWLr7SJnvqnoAV4Y1A5K14tLKF3jwUi	8EE1ycdEu5t46iuaBNJ8h2y4MxmvMJHNRu8yvmiBJf13	BJcxXxr2mSr71SVJaqvHHmdxHUrYRvC4sct1wMNZxirK	0	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	3	BJcxXxr2mSr71SVJaqvHHmdxHUrYRvC4sct1wMNZxirK
356352467	47013693	6fj1McV4jQ69bo6mM2xp3EVond9dUMvnAf1ypWExDaSW	7hbUFNqyPrdE83a922ahedQbm4ZEMw9eT4mGdfuJGthH	AJVEy2rzoTTSxTJSMK2CXhphoBwFdBBbRdw6jXVT1PYU	HNJv6HMXVDN1Eap5mNyhp96i1qia9XKdmriPUqwQmSB5	12uS9dmX9H38o2gHW9AhP8Si7vQ2rUmfH5D1Cz4UsYWs	5kcscTYsibM2pAgKcZKKCFe827jT5vKJYF7Ads8HCef7	356352467-4T4AgpgPDzBVvfSw46RQjvLKTkMJWrvcr6yAh92RX2GXbGGnDQ1HCUE69P7XgW5NKDaL2aZ5eGar78Sj4hKRtZQQ-0-4	4T4AgpgPDzBVvfSw46RQjvLKTkMJWrvcr6yAh92RX2GXbGGnDQ1HCUE69P7XgW5NKDaL2aZ5eGar78Sj4hKRtZQQ	2025-07-28T18:51:23.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	4	164	7dRSfJaBVjhdTTWLr7SJnvqnoAV4Y1A5K14tLKF3jwUi	8VfznLquRs44UvP4ePtSQ6tqCczLVwW6xmXXkGbwEYTT	7dGrdJRYtsNR8UYxZ3TnifXGjGc9eRYLq9sELwYpuuUu	0	King7ki4SKMBPb3iupnQwTyjsq294jaXsgLmJo8cb7T	0	7dGrdJRYtsNR8UYxZ3TnifXGjGc9eRYLq9sELwYpuuUu
356205978	2373260	F5BTnwuMA6rxftTdbZ33VWKr2wrr6DuQHnd4guKmPSYQ	Fawkj9g4s1M26uZDF6QczEviyib2Ge3FaPdCG9TJLYcm	4jhCSYuGkLCiB8uvCaS34QCtPycBjayxEk27YCartTuW	EqhWQbxsa36o7YSrCNvJTV1yoTRTWxCiLKcG9pzafprc	13PtHDhQzswoFWg8Gr4yVrTmUEW4CWxeKFkLVERCmypB	465hpb9FxqreEBmgts2YTwBtYrG9YMqkXt61MmnhhFij	356205978-5XYKnQKEmBrrSHUzPQZD9wDy2RvSR185qKvkKtv2KjocKhN6CZa1LqbQRdv5jcqb8e5XP3MrwC3JEzYnQGzJhuj7-3	5XYKnQKEmBrrSHUzPQZD9wDy2RvSR185qKvkKtv2KjocKhN6CZa1LqbQRdv5jcqb8e5XP3MrwC3JEzYnQGzJhuj7	2025-07-28T02:37:15.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	9W959DqEETiGZocYWCQPaJ6sBmUzgfxXfqGeTEdp3aQP	3	187	5KSCuA99i7PSF6KvvbvV5hDveGse7isqF6e7tFXPeMyn	2dAzwuwi6qRXfnJYNqJfooAgi4fA3mXHxhHYtuZ7zdfU	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	14019930231			GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC

Example Query

Query with partition filter

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

Whirlpool_InitializeConfig_instruction

Configuration initialization instructions for Orca Whirlpool automated market maker (AMM) pools on Solana, capturing protocol fee rate settings and configuration account creation. Used for tracking Whirlpool pool deployment events and fee parameter 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_defaultProtocolFeeRate`	`STRING`	Default protocol fee rate set during Whirlpool config initialization, expressed in basis points. Common values include 138 (1.38%) and 666 (6.66%), defining the fee tier for liquidity pools.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.

Sample Data

in_config	in_funder	block_slot	surrogate_key	transaction_id	block_timestamp	in_systemProgram	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	in_defaultProtocolFeeRate
9Rnq9vE87MhP3HVwzgHen269Lop7qXvzJA2wCLKdQwEb	99VXriv7RXJSypeJDBQtGRsak1n5o2NBzbtMXhHW2RNG	294999268	294999268-4rC3CCcaUhnhdWH3ravRd3RbhCnCt6DziEvdFTKH6UZcGrXiuA1o38vgfQhRMMgYYLdcofyrpAmh9bR4SZ3wRNvt-2	4rC3CCcaUhnhdWH3ravRd3RbhCnCt6DziEvdFTKH6UZcGrXiuA1o38vgfQhRMMgYYLdcofyrpAmh9bR4SZ3wRNvt	2024-10-11T11:58:58.000Z	11111111111111111111111111111111	InitializeConfig	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	2	294	99VXriv7RXJSypeJDBQtGRsak1n5o2NBzbtMXhHW2RNG	666
Cc7KdAPTFnb4h6TNRxura2BUABpLMT24MpKYKqATHPv2	99VXriv7RXJSypeJDBQtGRsak1n5o2NBzbtMXhHW2RNG	294999504	294999504-58pUFX4e9FWdoRiCm6KXAJC8B5mbzjBL22ZFHk2CzVyL1FyCuy4mB8vUYwey8HKwWJysC5qoMmKzJdCJ5eQiz1kj-2	58pUFX4e9FWdoRiCm6KXAJC8B5mbzjBL22ZFHk2CzVyL1FyCuy4mB8vUYwey8HKwWJysC5qoMmKzJdCJ5eQiz1kj	2024-10-11T12:00:46.000Z	11111111111111111111111111111111	InitializeConfig	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	2	75	99VXriv7RXJSypeJDBQtGRsak1n5o2NBzbtMXhHW2RNG	666
HYYtVQiiY9jm278YX5Ct4GE2NDzyCQFDYdtMRK2DdYQX	99VXriv7RXJSypeJDBQtGRsak1n5o2NBzbtMXhHW2RNG	294999440	294999440-5GNhMGeg78JK3fqi4mVica5DmF6j5R9zvsxBd6WbJB4XsRwrPrk7uR4cekDwVj62MZ1FzPAiwBbU5Wf8Ucwn3bEk-2	5GNhMGeg78JK3fqi4mVica5DmF6j5R9zvsxBd6WbJB4XsRwrPrk7uR4cekDwVj62MZ1FzPAiwBbU5Wf8Ucwn3bEk	2024-10-11T12:00:16.000Z	11111111111111111111111111111111	InitializeConfig	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	2	189	99VXriv7RXJSypeJDBQtGRsak1n5o2NBzbtMXhHW2RNG	666

Example Query

Query with partition filter

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

Whirlpool_InitializeFeeTier_instruction

Fee tier initialization instructions for Orca Whirlpool automated market maker (AMM) pools on Solana. Records configuration of tick spacing and default fee rates (in basis points) for new liquidity pool 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_defaultFeeRate`	`STRING`	Default fee rate for this tier expressed in basis points (1/10000ths of a percent). Common values include 20, 40, 80, and 480 basis points representing 0.2%, 0.4%, 0.8%, and 4.8% fees respectively.
`in_tickSpacing`	`STRING`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeAuthority`	`STRING`	Account address authorized to modify fee parameters in the Whirlpool protocol. Base58-encoded Solana public key.
`in_feeTier`	`STRING`	Account address of the fee tier configuration in the Whirlpool protocol. Base58-encoded Solana public key.
`in_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.

Sample Data

in_config	in_funder	block_slot	in_feeTier	surrogate_key	in_tickSpacing	transaction_id	block_timestamp	in_feeAuthority	in_systemProgram	instruction_type	executing_account	in_defaultFeeRate	transaction_index	transaction_signer
HR3c2Sgn6B6WJSXEDnsKyhNEWse4YLNn8sC9YjiCpUKq	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh	177555580	NCAENPk4WmkT6S22kWNiqo2Ugf7AT9BnK2QYhbq9itT	177555580-2GUHAz7zaPmZh9yNg1GnsZAJGV8iVFSfgGPCKm9K2PYe2sqh5PtKcGC9T1eFEfJhseUPeJphCtEGM2LZ4NPYDxJd-0	16	2GUHAz7zaPmZh9yNg1GnsZAJGV8iVFSfgGPCKm9K2PYe2sqh5PtKcGC9T1eFEfJhseUPeJphCtEGM2LZ4NPYDxJd	2023-02-13T12:09:21.000Z	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh	11111111111111111111111111111111	InitializeFeeTier	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	40	6	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh
AJvqS84a33ELesMuGxKAjzvfWFwHbywAJZNz1sEMQmNB	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh	177555640	Gvire5d2qECy5vRQicEnGJXK3Dfqu4w6TTafAJrXCiGz	177555640-6bYDe4i2xKQo3ou4AcSDh8kfqrLLDamoPSXmoAK2ygunwxQzandMvx4zsPpe9bLjBQcizcjDF4inPDUSBfdDtqV-0	16	6bYDe4i2xKQo3ou4AcSDh8kfqrLLDamoPSXmoAK2ygunwxQzandMvx4zsPpe9bLjBQcizcjDF4inPDUSBfdDtqV	2023-02-13T12:09:50.000Z	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh	11111111111111111111111111111111	InitializeFeeTier	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	40	144	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh
eh3BQT778DA7rTM5s7q7MBGZyLiboZ6bzWvZ5oVmevn	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh	177555637	GTLgYLCURb65j16KwaPnuVj93cUdGwB68LJ1AC9MT3gL	177555637-3tPs1Q1qNUCayHT7ZTcs7aVyG3evTyEavhVg2jtEJn79XopjpuBvSvjq5zy4McUNrYahfXtmucuH8hERyTPnDcAe-0	16	3tPs1Q1qNUCayHT7ZTcs7aVyG3evTyEavhVg2jtEJn79XopjpuBvSvjq5zy4McUNrYahfXtmucuH8hERyTPnDcAe	2023-02-13T12:09:47.000Z	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh	11111111111111111111111111111111	InitializeFeeTier	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	40	2	BuFT4LG7Qxn9iJfNHoWscwHYQetTTq6PABauKffehnkh

Example Query

Query with partition filter

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

Whirlpool_InitializePool_instruction

Pool creation instructions from Orca Whirlpool automated market maker (AMM) on Solana. Captures initial pool setup parameters including token pair addresses, fee tiers, tick spacing, and starting sqrt price for analyzing new liquidity 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_sqrtPriceLimit`	`STRING`	Square root of the price limit for the swap operation, represented as a fixed-point integer in Q64.64 format.
`in_tickSpacing`	`STRING`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeTier`	`STRING`	Account address of the fee tier configuration in the Whirlpool protocol. Base58-encoded Solana public key.
`in_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_tokenMintA`	`STRING`	Contract address of the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenMintB`	`STRING`	Contract address of the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_tokenVaultA`	`STRING`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRING`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_rent	in_config	in_funder	block_slot	in_feeTier	in_whirlpool	in_tokenMintA	in_tokenMintB	surrogate_key	in_tickSpacing	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	in_tokenProgram	in_systemProgram	instruction_type	executing_account	in_sqrtPriceLimit	transaction_index	transaction_signer
SysvarRent111111111111111111111111111111111	BAETyPHo6bvDLzip6STet5Ark71Epo8GxynZMHoL2bzt	BwRHdbXye2hJWtkYffeSKekApwJa4L8Qjn26hGDFsYkq	130801105	5cyhCta55L7DrWB9bi9Uwh1f98ag71wScRbGqcSAbyGN	3i6aDHk429PjYSwWXibSCvpFjDkt9fu6xgAJph7sVxWf	orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	130801105-29gc24Wm29D1vtEr8iXPkf6N9wboVUE64ZkMopBQYPQdqf5DnitdvDsMiWuuQnvmcfG3fp9GMdj7cCrSLWJst45v-0	128	ETugSn7YXqKnCDHzNeVpr9FDdgBM49gijoa3SK4FXbcW	26MpWrQNa4gm7tSd3SfELrH7GqJkmYxpetSDd8ArFoP1	29gc24Wm29D1vtEr8iXPkf6N9wboVUE64ZkMopBQYPQdqf5DnitdvDsMiWuuQnvmcfG3fp9GMdj7cCrSLWJst45v	2022-04-22T04:52:09.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializePool	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	18446744073709551616	110	BwRHdbXye2hJWtkYffeSKekApwJa4L8Qjn26hGDFsYkq
SysvarRent111111111111111111111111111111111	AXQC5E97NyZegAs1dR43bJBwnf4QbTepvp6Ciixk9Cqz	BwRHdbXye2hJWtkYffeSKekApwJa4L8Qjn26hGDFsYkq	130879590	GaiUH8finbmCZRcfmepKVP1xVx66fd81BmoDvoVGhA3s	d49qN4YBvMSg1kuXf4dUgtxop8pWUtTkx7CAaHHaQaf	orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	130879590-SvwGxBWapxiheqzEQR5xqaTeRDCxiz2UosgdkmBtnY1xRcKZcvSguUSUhUwBpdccezDm2XGvKooJRTifCfdzAcr-0	128	49f2N9VVemAfmiLwY2rXJsBsjwaiKhapzjtG2gfNpBXA	82bCFQvwUhi8geQrKP4Xe9YZoMTdCP4kQAmSvFoYsgmb	SvwGxBWapxiheqzEQR5xqaTeRDCxiz2UosgdkmBtnY1xRcKZcvSguUSUhUwBpdccezDm2XGvKooJRTifCfdzAcr	2022-04-22T17:36:39.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializePool	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	18446744073709551616	70	BwRHdbXye2hJWtkYffeSKekApwJa4L8Qjn26hGDFsYkq
SysvarRent111111111111111111111111111111111	2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	FRr3z85NEkkNGivvki7hD5P8wzGJoJ3SJygsGGnu7JYj	254392494	BGnhGXT9CCt5WYS23zg9sqsAT2MGXkq7VSwch9pML82W	2wdFzWP5nkASvd6j8H7APwVBxEYXP8oe2vHTwcEJWTLa	3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o	AVLhahDcDQ4m4vHM4ug63oh7xc8Jtk49Dm5hoe9Sazqr	254392494-3AjqsMx1RB9BcmjD7zR5fEhfVN5rT8AFdntdsEp9mkiJVh8JNSPXrtaLFdKCsFNVyaHstGyJBUKQdgjCrgB7E7FR-0	128	5nRzNeoxMg4jThnQDLcmEwiwGqmGF8D6tD47fnD7gPYE	GvFaFEpqTHEniUzZFYw4kQd751NgQB6PWM222nrSg5jw	3AjqsMx1RB9BcmjD7zR5fEhfVN5rT8AFdntdsEp9mkiJVh8JNSPXrtaLFdKCsFNVyaHstGyJBUKQdgjCrgB7E7FR	2024-03-15T21:07:39.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializePool	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	860227105637242897	74	FRr3z85NEkkNGivvki7hD5P8wzGJoJ3SJygsGGnu7JYj

Example Query

Query with partition filter

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

Whirlpool_initializePoolV2_instruction

Liquidity pool initialization events from Orca Whirlpool decentralized exchange (DEX) on Solana. Contains token pair addresses, initial pricing (sqrt price), tick spacing configuration, and vault setup for analyzing new pool deployments and liquidity market creation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`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.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`transaction_success`	`BOOL`	Boolean flag indicating whether the transaction executed successfully and was committed to the blockchain.
`instruction_program_address`	`STRING`	Address of the Solana program that executed the instruction. Base58-encoded public key.
`inner_instruction_index`	`INT64`	Position of the instruction within nested cross-program invocations. Zero-indexed integer representing the sequential order when one program calls another program’s instructions.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`name`	`STRING`	Name of the instruction or event type being executed. Identifies the specific operation performed within the smart contract or program.
`in_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_initialSqrtPrice`	`BIGNUMERIC`	Initial square root price for the liquidity pool at creation, represented as a fixed-point number. This value determines the starting exchange rate between tokenA and tokenB in the Whirlpool concentrated liquidity pool.
`in_whirlpoolsConfig`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Global configuration account address for the Orca Whirlpool program that defines protocol-wide parameters. Base58-encoded Solana public key, consistent across pool initialization instructions.
`in_tokenMintA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Contract address of the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenMintB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Contract address of the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenBadgeA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account containing metadata or verification status for token A in the newly initialized pool. May be null for tokens without on-chain badges or verification.
`in_tokenBadgeB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Token badge program-derived address (PDA) for token B, used to verify token mint metadata on Orca Whirlpool V2. Null when token badges are not configured for the pool.
`in_funder`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_whirlpool`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_tokenVaultA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_feeTier`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the fee tier configuration in the Whirlpool protocol. Base58-encoded Solana public key.
`in_tokenProgramA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Token program account address for token A in the pool (typically SPL Token program). Contains account metadata including address, signer status, and writability flags for the instruction.
`in_tokenProgramB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Program address for token B’s SPL Token program. Typically the standard SPL Token program address on Solana.
`in_systemProgram`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_rent`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.

Sample Data

name	in_rent	in_funder	in_feeTier	block_height	in_whirlpool	in_tokenMintA	in_tokenMintB	surrogate_key	in_tickSpacing	in_tokenBadgeA	in_tokenBadgeB	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	in_systemProgram	in_tokenProgramA	in_tokenProgramB	instruction_index	transaction_index	in_initialSqrtPrice	in_whirlpoolsConfig	transaction_success	instruction_program_address
initializePoolV2	{“is_alt”:false,“address”:“SysvarRent111111111111111111111111111111111”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“H1YTKvMUoUoLDPVVkTwJY5jfE74mXC4FbvWhh35rmCWP”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	{“is_alt”:false,“address”:“62dSkn5ktwY1PoKPNMArZA4bZsvyemuknWUnnQ2ATTuN”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	305279879	{“is_alt”:false,“address”:“H5pma6JwS8hXPcAVsAMpwRtMApPApGGQbDjm8fyoWu8k”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“ET9wFpsjE7R78rWFutg9FjP3DbpPTPDzyevH7o5qgMKz”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	AyvgEuZcxgFtzgn7ckNH9WxdaKyGGh4az4od2zBreM99-4wrhD9sX8kj2LdzATvc6zz25K2Qo5GpJ4LPuZHHLAZAbwVEm9dpB92HcqKfhKgKeHWGyoAVQMSmW6bVArG1t3s28-3	1	{“is_alt”:false,“address”:“A25FKDeNYwo4Y9KJZHfhoeojAiyhAssQesT2y3kfF2Mp”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“QAzgcXJtm2DxghqZS8goYimFUWxqWwkunn1MMSYg6ac”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“D4MrRF1BigXxKr58eDSMrJ1q2umRXWCBfUCwktvV335v”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“CNq9reNKkDoxeskN6Fq1F8DzxFK24PMSwYBKVmbXarKq”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:false}	4wrhD9sX8kj2LdzATvc6zz25K2Qo5GpJ4LPuZHHLAZAbwVEm9dpB92HcqKfhKgKeHWGyoAVQMSmW6bVArG1t3s28	2025-03-15T23:51:03.000Z	{“is_alt”:false,“address”:“11111111111111111111111111111111”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	3	188	2.1478908724737641828e+21	{“is_alt”:false,“address”:“2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc
initializePoolV2	{“is_alt”:false,“address”:“SysvarRent111111111111111111111111111111111”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“CvxQ4nccMoxPACKsxA9S1GTdbTrYmz3gZtPYH1HEoHFY”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	{“is_alt”:false,“address”:“62dSkn5ktwY1PoKPNMArZA4bZsvyemuknWUnnQ2ATTuN”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	305147185	{“is_alt”:false,“address”:“313NdCcvvdjgJXda851w8HiZVyJex6hetyDA544GCbKu”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“GpR7vkVPw52STVxS17PzZ8S6Q1XmHnRtXsgnhMUfYqEY”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	G8GAkgBUAygDVjs34NjX7VjPRTH6gwy83gpJUPaB3PD-5D4PKRNwzwfHTmmr2aH97kY2r3ssJjCG1QBR5xWrvF25Enb2cDq2zZcbFtm8EDeoh8SSCPCmiaEviYgeR7tnV6pb-3	1	{“is_alt”:false,“address”:“A25FKDeNYwo4Y9KJZHfhoeojAiyhAssQesT2y3kfF2Mp”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“FtN8eX649iHHVaZZRnDQyHWK87bcFCVXfLrUoTSagqhB”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“3o4SxtLBCpEeRyp2o78K7dDaQspJDfgkM2rEAjLemk2i”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“Bim7xVmN2D4XPQGd4tnQDF25SL62T4TR26fqUpu63Gfg”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:false}	5D4PKRNwzwfHTmmr2aH97kY2r3ssJjCG1QBR5xWrvF25Enb2cDq2zZcbFtm8EDeoh8SSCPCmiaEviYgeR7tnV6pb	2025-03-15T09:07:32.000Z	{“is_alt”:false,“address”:“11111111111111111111111111111111”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	3	4	1.1374749684638758231e+21	{“is_alt”:false,“address”:“2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc
initializePoolV2	{“is_alt”:false,“address”:“SysvarRent111111111111111111111111111111111”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“DgmWrgFs38jEx7rB5xywVKgo4ANfGdTkEbFkDRB1cnFu”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	{“is_alt”:false,“address”:“62dSkn5ktwY1PoKPNMArZA4bZsvyemuknWUnnQ2ATTuN”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	305250433	{“is_alt”:false,“address”:“CxZ9ifkJVN1km2NNSAedTn7d89gVx9d6Lv61dK4P15K9”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“4ChLgVaPc1TEApym6Ba1SbbVETC4T5zumfpbNbRANtb8”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	Arxdv3EWuQTUCX3xpS3zuLisoSZXYYstqSGK9vK4qGXp-4t4RqHUB1mAbEejixtQPeFMas6gbXviFmk3V4hSU837eo229hqjsRNWeSGXnUEMjZprvHL74QCaiT6GtKBv1HhAy-3	1	{“is_alt”:false,“address”:“A25FKDeNYwo4Y9KJZHfhoeojAiyhAssQesT2y3kfF2Mp”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“D4f8P5AeA81qA1boLuw5Voi1MDGWhkYYonETHJ124J7w”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“ANXDcxZFyCthSJNA6NrFgytQVbRNCDET58Efv48RHaPJ”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“3mDSMjBEq5yPT46bk3PZy5kxiZmrxWDPLz2gqpJJ85Wc”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:false}	4t4RqHUB1mAbEejixtQPeFMas6gbXviFmk3V4hSU837eo229hqjsRNWeSGXnUEMjZprvHL74QCaiT6GtKBv1HhAy	2025-03-15T20:35:08.000Z	{“is_alt”:false,“address”:“11111111111111111111111111111111”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	3	890	166505441924815948590	{“is_alt”:false,“address”:“2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc

Example Query

Query with partition filter

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

Whirlpool_InitializePoolV2_instruction

Liquidity pool initialization instructions from Orca’s Whirlpool V2 automated market maker (AMM) on Solana. Contains setup parameters for new trading pools including token pairs, fee tiers, tick spacing, and initial sqrt price limits for analyzing pool deployments and configuration patterns.

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_sqrtPriceLimit`	`STRING`	Square root of the price limit for the swap operation, represented as a fixed-point integer in Q64.64 format.
`in_tickSpacing`	`STRING`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeTier`	`STRING`	Account address of the fee tier configuration in the Whirlpool protocol. Base58-encoded Solana public key.
`in_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_tokenBadgeA`	`STRING`	Account holding token badge metadata for token A in the pool. Required for Orca V2 pools to validate token mint authority and configuration parameters.
`in_tokenBadgeB`	`STRING`	Account address of the token badge for token B in the initialized Orca whirlpool. Badges verify token metadata and configuration for concentrated liquidity pools.
`in_tokenMintA`	`STRING`	Contract address of the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenMintB`	`STRING`	Contract address of the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultA`	`STRING`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRING`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_config	in_funder	block_slot	in_feeTier	in_whirlpool	in_tokenMintA	in_tokenMintB	surrogate_key	in_tickSpacing	in_tokenBadgeA	in_tokenBadgeB	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	instruction_type	executing_account	in_sqrtPriceLimit	instruction_index	transaction_index	transaction_signer
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	HCjDPTXigbPB63sTjooyqWdSVzvAR5HKfWDY4QKcm6sL	328505146	62dSkn5ktwY1PoKPNMArZA4bZsvyemuknWUnnQ2ATTuN	3shLSVVcs7JvdANbhKvAWW7SiaePBUSojx7e7aN8GByg	So11111111111111111111111111111111111111112	F6LtYPDhQDhTovULFDMuZb2Fr6iknrTsSEVxBETbNiLL	328505146-5UtBtkzLzyy1CPBzeciWEFEHU7cc8FE9YjdvKsBZejd9TsVcT4B7GRQBG2Qt6G58AuZVKXEskoNNTEjXQETYgLKy-3	1	A25FKDeNYwo4Y9KJZHfhoeojAiyhAssQesT2y3kfF2Mp	7vr4ey1vuptQYypKfL47sXQE8TFf63byLDKoeMGNsWoN	GbgGfF2g327BTTxgfALMuqZm7TaS26N7Z1gfG97HdU3y	BhakJjq694S59kJbEQh2wPYx1WrmGS6UPy9XVGiA3NFP	5UtBtkzLzyy1CPBzeciWEFEHU7cc8FE9YjdvKsBZejd9TsVcT4B7GRQBG2Qt6G58AuZVKXEskoNNTEjXQETYgLKy	2025-03-22T20:27:10.000Z	InitializePoolV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	10500055074613607887	3	170	HCjDPTXigbPB63sTjooyqWdSVzvAR5HKfWDY4QKcm6sL
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	9C6HxuWWsaCwqcAi8KXiq1xwu58JphGvjPQfCsqEwrmU	328509771	9zfDkPMnx9ei8mZVfCsLjkBzXob7H3PuAhabmUVAiuJF	6eRQ6LzdaQRj2UnpfW3Nr39aFr1EDuEHwCpr8AnksqVz	So11111111111111111111111111111111111111112	CSD6JQMvLi46psjHdpfFdr826mF336pEVMJgjwcoS1m4	328509771-5V4hLv9eG9odepuyCNHFnyczr5XdFBuUSFXLCiyGiPhWrCePej8vvLuQtRXT4An1ZbEPJ4PEsPqgbmq9V67ahXoT-3	4	A25FKDeNYwo4Y9KJZHfhoeojAiyhAssQesT2y3kfF2Mp	8NNw6nUJVuWkKVhbVGCjQQ1921jFhkYcibda9QsAB1dG	ERsUEYPhU6Xw7gNZpA6FPDRW9nkUx7RdWVkDGAE75FZp	7Y6EKyJ2T1gJcQLWYSRKAuBFgtUzD1v3Qmec1pz9hpC2	5V4hLv9eG9odepuyCNHFnyczr5XdFBuUSFXLCiyGiPhWrCePej8vvLuQtRXT4An1ZbEPJ4PEsPqgbmq9V67ahXoT	2025-03-22T20:57:59.000Z	InitializePoolV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	1489851830418586420	3	114	9C6HxuWWsaCwqcAi8KXiq1xwu58JphGvjPQfCsqEwrmU
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	F4ugTGN6g2nsECwfZn2Q3TFJs3ED6kdPcRcoJ43HNFud	328415111	BGnhGXT9CCt5WYS23zg9sqsAT2MGXkq7VSwch9pML82W	4QAhoqxXWykhPyo6i6XDXdDmeDPvs5VbH9U21cNpnwDw	CvnLghcisdCdfQWGe2763h3Dz4x1yGA8hhaR4jCxHUoG	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	328415111-59KemogyD3ZdPN5S9GqFvq12sPd1uM4jZgGo8ecosLp1yc2ENZge4WMwuymS9dFaxMjmPCmhtD5S6DXEoJHZmjEA-3	128	8xDpoENjzjUNMirm4VtvPVTbYn6hrkCodbrh3dv3K24r	7aaBNde6QQZi5E4RCsfPf8J3BGbDUyGjkrMyZ51AXH2a	J9ajSBbWy9jaBYDmyH87XegcaGRnGSZM5JcWp3yUX8of	7BAeKmx455zv5VPXCUuMbDBNvikTGmGcqPxRHMDiyDDM	59KemogyD3ZdPN5S9GqFvq12sPd1uM4jZgGo8ecosLp1yc2ENZge4WMwuymS9dFaxMjmPCmhtD5S6DXEoJHZmjEA	2025-03-22T10:27:25.000Z	InitializePoolV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	583320933199204579	3	189	F4ugTGN6g2nsECwfZn2Q3TFJs3ED6kdPcRcoJ43HNFud

Example Query

Query with partition filter

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

Whirlpool_InitializeReward_instruction

Initialization instructions for reward programs on Orca Whirlpool liquidity pools on Solana, establishing reward vaults and authorities for incentivizing liquidity providers. Tracks setup of additional token rewards beyond trading fees.

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_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_rewardAuthority`	`STRING`	Account address authorized to configure reward parameters for the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_rewardMint`	`STRING`	Solana address of the token being configured as a reward for the specified whirlpool liquidity pool. Base58-encoded public key identifying the SPL token mint for reward distribution.
`in_rewardVault`	`STRING`	Account address of the token vault holding reward tokens for distribution to liquidity providers. Base58-encoded Solana public key.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_rent	in_funder	block_slot	in_whirlpool	in_rewardMint	surrogate_key	in_rewardVault	transaction_id	block_timestamp	in_tokenProgram	in_systemProgram	instruction_type	executing_account	transaction_index	in_rewardAuthority	transaction_signer
SysvarRent111111111111111111111111111111111	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	246309249	54TLmeqsMyDrVbdW35V8JN2CxsFDiNQfMN8vpMa6CCoz	ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx	246309249-4bF5166f7AHQrik2JGpYKZ5teGL2X6PodaZmo9svapDfB7unfuMaeThkDwugJUrL7bmcCzLscUQnsdc9iFzLRXAw-0	GyR3JbVqb6xVZE6uAeRyChppwp6VFrD8oPbmKvzkiYkd	4bF5166f7AHQrik2JGpYKZ5teGL2X6PodaZmo9svapDfB7unfuMaeThkDwugJUrL7bmcCzLscUQnsdc9iFzLRXAw	2024-02-05T15:20:47.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializeReward	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	72	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW
SysvarRent111111111111111111111111111111111	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	246305027	54TLmeqsMyDrVbdW35V8JN2CxsFDiNQfMN8vpMa6CCoz	SHAREqUspz65F5LxnvgPMWyrRBWgy5rbv9ksQC8QY4w	246305027-2MdrfdFNuXwAjcnFVqkEtNgyXzieDxbSBvZEKXQGhPyiUmiq9ThCRuH4DU9wpanjNoGi1hZsA82GXoWSQbjeg926-0	Aevr4uCSPNBcqjeeUpukxeJ8xZHeQBNaJ2P7GzbxgQ32	2MdrfdFNuXwAjcnFVqkEtNgyXzieDxbSBvZEKXQGhPyiUmiq9ThCRuH4DU9wpanjNoGi1hZsA82GXoWSQbjeg926	2024-02-05T14:50:36.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializeReward	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	145	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW
SysvarRent111111111111111111111111111111111	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	246304402	7PEP67domJDwNeKFDV6NACC38Lwuk2yrdkM7kktVvM6r	CzLWmvjtj5bp9YEWkzzBnuWovVtogeuchFu5GeFh68hB	246304402-23ZyQgwnJ181BpTAgs9smDBNzwWZdhkmWmKun4HSExrTaCpNUNvdWbBNyVT2DkPSMcYAezAg3dvrBCWRZDmqmLP4-0	BeH3bBZ8szpgMfJqPZWFemxFtSrAkBS7hpThRKZSfs84	23ZyQgwnJ181BpTAgs9smDBNzwWZdhkmWmKun4HSExrTaCpNUNvdWbBNyVT2DkPSMcYAezAg3dvrBCWRZDmqmLP4	2024-02-05T14:45:59.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializeReward	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	45	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW

Example Query

Query with partition filter

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

Whirlpool_InitializeRewardV2_instruction

Initialization instructions for liquidity mining rewards on Orca Whirlpool automated market maker (AMM) pools on Solana. Records reward token setup including reward mint, vault, authority, and reward index for analyzing incentive program 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_rewardIndex`	`STRING`	Index identifying which reward slot is being configured or claimed. String-encoded integer, zero-indexed.
`in_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_rewardAuthority`	`STRING`	Account address authorized to configure reward parameters for the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_rewardMint`	`STRING`	Solana address of the token used for liquidity mining rewards on this Whirlpool. Base58-encoded public key identifying the SPL token mint account.
`in_rewardVault`	`STRING`	Account address of the token vault holding reward tokens for distribution to liquidity providers. Base58-encoded Solana public key.
`in_systemProgram`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_tokenBadge`	`STRING`	Solana address of the token badge account verifying the reward token for this pool. Used in Orca’s token verification system to validate reward token authenticity.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_rent	in_funder	block_slot	in_whirlpool	in_rewardMint	in_tokenBadge	surrogate_key	in_rewardVault	transaction_id	block_timestamp	in_tokenProgram	in_systemProgram	instruction_type	executing_account	instruction_index	transaction_index	in_rewardAuthority	transaction_signer
SysvarRent111111111111111111111111111111111	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	338058351	FWDvLqKFt5H514ov22XXGLopGVsf4w34SD1CEnhfMyJW	26VfKb7jjtdEdvfovoBijScoZmJbWWasFZkgfUD5w7cy	7tuLqsLLWhhmYGcDfX8UKG5raHTcK3B2cSpQiEV6SARL	338058351-4FimehnebnPcPsoTgMEXPsuuUaNVeQKgczwXceCvuNMwzcASPhJh7oCx2kMTiPixpbpGVNsMZbYTtdfXx4fXhy2-3	Dm5a5zgHGCbrjKufQJbJMoFQspQGV6kWk6PXD2iqgwx2	4FimehnebnPcPsoTgMEXPsuuUaNVeQKgczwXceCvuNMwzcASPhJh7oCx2kMTiPixpbpGVNsMZbYTtdfXx4fXhy2	2025-05-05T19:42:36.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializeRewardV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	83	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW
SysvarRent111111111111111111111111111111111	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	303952700	FX1yMJybFGMZ95nkvLjvAS1nfqsbNQZtLg9nqhCBBkeH	4Eb7ReeT936hX25KMBfYtyP1RWDdd9iixEwGJroACeLC	3CwjTekhtwcgredLSJWyUVDKknB4izub6Cx1eSYx8iGk	303952700-4p5ZK4Rfsfdmmbva7uK7LMQc1WVyrYbYdYUU3Yn5j2ism8umzY6vRbPod22EafWXpKJBgpAUAb9GnQw6RstEAYzf-3	9GaVzPBmXUYDxFT96FNhnkMZLhaUM7SaYXy3YTz5i2Jq	4p5ZK4Rfsfdmmbva7uK7LMQc1WVyrYbYdYUU3Yn5j2ism8umzY6vRbPod22EafWXpKJBgpAUAb9GnQw6RstEAYzf	2024-11-27T15:02:06.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializeRewardV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	13	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW
SysvarRent111111111111111111111111111111111	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	312829843	FBBryPMjKvCAu8UEJNGhciYPTRGzd4dHsmiegFZ66PSP	3KzAE8dPyJRgZ36Eh81v7WPwi6dm7bDhdMb8EAus2RAf	ESTsigpSsMEHwaZKhsgDEoJPjNgzU1wx8t8vJDvB9bH6	312829843-43qZAHk4EacDJdYH5U3sjrijWp5BBYCW2FyLpYC1QNUS1UqDRJMZWb6AfBm4Cs6eFQx58rdkWA3tQ5pjNNhkBV5p-3	9851G4U5R2wBu8gYR5bRNqw8gmehHeui1o8vS1RRStmk	43qZAHk4EacDJdYH5U3sjrijWp5BBYCW2FyLpYC1QNUS1UqDRJMZWb6AfBm4Cs6eFQx58rdkWA3tQ5pjNNhkBV5p	2025-01-09T07:12:40.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	11111111111111111111111111111111	InitializeRewardV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	146	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW

Example Query

Query with partition filter

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

Whirlpool_SetDefaultFeeRate_instruction

Administrative instructions for updating default fee rates on Orca Whirlpool liquidity pools on Solana. Records fee tier configuration changes by authorized pool administrators, with rates specified in basis points (e.g., 3000 = 30%).

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_defaultFeeRate`	`STRING`	Fee rate setting in basis points (1/100th of 1%) for the specified fee tier. Typical values range from 800 to 3000 basis points (0.08% to 0.30%).
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeAuthority`	`STRING`	Account address authorized to modify fee parameters in the Whirlpool protocol. Base58-encoded Solana public key.
`in_feeTier`	`STRING`	Account address of the fee tier configuration in the Whirlpool protocol. Base58-encoded Solana public key.

Sample Data

in_config	block_slot	in_feeTier	surrogate_key	transaction_id	block_timestamp	in_feeAuthority	instruction_type	executing_account	in_defaultFeeRate	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	150957662	HT55NVGVTjWmWLjV7BrSMPVZ7ppU8T2xE5nCAZ6YaGad	150957662-5QQN4xnHUq4FwNKuyE6P3soa7AiUtReXsvae92Gsn7cWGkbYcqkQdwWCDofczQ85WLs9thvzoazSzyipCz6DejyA-0	5QQN4xnHUq4FwNKuyE6P3soa7AiUtReXsvae92Gsn7cWGkbYcqkQdwWCDofczQ85WLs9thvzoazSzyipCz6DejyA	2022-09-16T18:26:31.000Z	3Pi4tc4SxZyKZivKxWnYfGNxeqFJJxPc8xRw1VnvXpbb	SetDefaultFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3000	393	3Pi4tc4SxZyKZivKxWnYfGNxeqFJJxPc8xRw1VnvXpbb
35VNM2KsKZKxWpEvde4NHrcfuCfXtKfdCffUmSTceKeC	214408450	D96VqzfAZb6fmW1j52ZmYfX1ZFP7AVmBSYpRgRmx57PY	214408450-5Q7BYpk8Ee7xBbJRXA1MrXkavGA5UXAw24cMDsALjXNJSgEHcN7Bz4JMPCJ71PDFRUCn3V1HvCQNZ5NoAHYcxM3c-1-0	5Q7BYpk8Ee7xBbJRXA1MrXkavGA5UXAw24cMDsALjXNJSgEHcN7Bz4JMPCJ71PDFRUCn3V1HvCQNZ5NoAHYcxM3c	2023-08-29T21:32:19.000Z	7btJUBpZq3pzhYJBF9pkCBJ4xa4de1ZnUeJ4WiA5TiHT	SetDefaultFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	2500	65	DMRJobdXwtYdru2oPVQZdKQoGo1vDxke3ByzEg8kiKv	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	1
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	385761587	GBtp54LJqqDSWonLT878KWerkJAYqYq4jasZ1UYs8wfD	385761587-4TAneXaC2TzgXLRy2kKB1MNrd83LTMsjvZKXk5U7GdpEgrV4yjcHU5zcSXnne7fCd1Vq1CohxckUdejBSzYqaVyf-3-0	4TAneXaC2TzgXLRy2kKB1MNrd83LTMsjvZKXk5U7GdpEgrV4yjcHU5zcSXnne7fCd1Vq1CohxckUdejBSzYqaVyf	2025-12-10T13:34:02.000Z	GwH3Hiv5mACLX3ufTw1pFsrhSPon5tdw252DBs4Rx4PV	SetDefaultFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	800	103	BWyVTPPRW7A5kpHM3tNgPhRz6JekR9sL8iFx2o4X1w9C	SQDS4ep65T869zMMBKyuUq6aD6EgTu8psMjkvj52pCf	3

Example Query

Query with partition filter

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

Whirlpool_SetDefaultProtocolFeeRate_instruction

Protocol fee rate update instructions from Orca’s Whirlpool automated market maker (AMM) on Solana. Captures governance actions where fee authorities modify the default protocol fee rates charged on trades.

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_defaultProtocolFeeRate`	`STRING`	The new protocol fee rate being set, expressed in basis points (1/100th of a percent). For example, a value of 1300 represents a 13% protocol fee on trades in Orca Whirlpool liquidity pools.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeAuthority`	`STRING`	Account address authorized to modify fee parameters in the Whirlpool protocol. Base58-encoded Solana public key.

Sample Data

in_config	block_slot	surrogate_key	transaction_id	block_timestamp	in_feeAuthority	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index	in_defaultProtocolFeeRate
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	309406753	309406753-3XQ6YWrSvWcchH3NJk5XxsQhA2HiRQUFoUQcYG2sLjPMqttpoSPkCsAT9Z8DgmDvYNpQaXkryipYWqeX9N7yqFY3-2	3XQ6YWrSvWcchH3NJk5XxsQhA2HiRQUFoUQcYG2sLjPMqttpoSPkCsAT9Z8DgmDvYNpQaXkryipYWqeX9N7yqFY3	2024-12-24T00:58:17.000Z	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw	SetDefaultProtocolFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	2	22	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw			1300

Example Query

Query with partition filter

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

Whirlpool_SetFeeRate_instruction

Fee rate adjustment instructions for Orca Whirlpool automated market maker pools on Solana. Records fee authority changes with basis point values (2500=0.25%, 5000=0.5%) for analyzing protocol fee dynamics and governance actions.

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_feeRate`	`STRING`	Fee rate in basis points (1/100th of a percent) being set for the Orca Whirlpool liquidity pool. Sample values like 2500, 5000, and 10000 represent 0.25%, 0.50%, and 1.00% trading fees respectively.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeAuthority`	`STRING`	Account address authorized to modify fee parameters in the Whirlpool protocol. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_config	block_slot	in_feeRate	in_whirlpool	surrogate_key	transaction_id	block_timestamp	in_feeAuthority	instruction_type	executing_account	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
35VNM2KsKZKxWpEvde4NHrcfuCfXtKfdCffUmSTceKeC	249463341	5000	Bqqt9eNSJmZUSdy2GPkxK8EZSxySyfm4PsNw3C9m8vLi	249463341-3MdtqgmKsxcxXvvDddLQ7jpToyzFsbBBKGC3U63RyCPYuJs6eXSi7kWDi73NZMwdDVNGo7JugLhStuyYatCzAcTW-2-0	3MdtqgmKsxcxXvvDddLQ7jpToyzFsbBBKGC3U63RyCPYuJs6eXSi7kWDi73NZMwdDVNGo7JugLhStuyYatCzAcTW	2024-02-21T02:27:28.000Z	7btJUBpZq3pzhYJBF9pkCBJ4xa4de1ZnUeJ4WiA5TiHT	SetFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	DMRJobdXwtYdru2oPVQZdKQoGo1vDxke3ByzEg8kiKv	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
35VNM2KsKZKxWpEvde4NHrcfuCfXtKfdCffUmSTceKeC	210683287	2500	C7AD8EHcbKvFL3zw2z4YKKn1ZMTCYqkThZGtY3hPajsd	210683287-4C5bn2Zz52ADUYDYsJHAxdze5HL9wx4xdiZUvimTyyF8SSyEsp4XmFpagRwuvGDgEhzQoMyTrW3p5SxvFC4qbuyT-1-0	4C5bn2Zz52ADUYDYsJHAxdze5HL9wx4xdiZUvimTyyF8SSyEsp4XmFpagRwuvGDgEhzQoMyTrW3p5SxvFC4qbuyT	2023-08-11T00:32:15.000Z	7btJUBpZq3pzhYJBF9pkCBJ4xa4de1ZnUeJ4WiA5TiHT	SetFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	4	DMRJobdXwtYdru2oPVQZdKQoGo1vDxke3ByzEg8kiKv	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	1
35VNM2KsKZKxWpEvde4NHrcfuCfXtKfdCffUmSTceKeC	223268133	10000	Fue32RRWw16M6aakuUNde79kiBrJf5xEyeBgGtxNSfQV	223268133-3GZGSwaMBFFN2eb9aSMHaF2P2V45RL2WPC4t9JHNoeaeoPQwyioKHmTRJCase7Y7yzavyuo6zs87yPYgpYjmTyNK-1-0	3GZGSwaMBFFN2eb9aSMHaF2P2V45RL2WPC4t9JHNoeaeoPQwyioKHmTRJCase7Y7yzavyuo6zs87yPYgpYjmTyNK	2023-10-12T22:17:25.000Z	7btJUBpZq3pzhYJBF9pkCBJ4xa4de1ZnUeJ4WiA5TiHT	SetFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	40	DMRJobdXwtYdru2oPVQZdKQoGo1vDxke3ByzEg8kiKv	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	1

Example Query

Query with partition filter

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

Whirlpool_SetProtocolFeeRate_instruction

Protocol fee rate updates executed by fee authorities on Orca Whirlpool liquidity pools on Solana. Used for tracking fee governance changes and analyzing protocol revenue adjustments across different pool configurations.

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_protocolFeeRate`	`STRING`	Protocol fee rate being set for the Orca Whirlpool, expressed in basis points. Typically 1300 (13 basis points or 0.13%), with occasional values of 1 basis point.
`in_config`	`STRING`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.
`in_feeAuthority`	`STRING`	Account address authorized to modify fee parameters in the Whirlpool protocol. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_config	block_slot	in_whirlpool	surrogate_key	transaction_id	block_timestamp	in_feeAuthority	instruction_type	executing_account	transaction_index	in_protocolFeeRate	transaction_signer
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	253719700	9FpjggAFkaPby2cwkqDrHS6AxciTAMcEnybSeioLV76X	253719700-5xPmDeNaEDLJzKyS9MRLJkuKsse7kFdqLnHhR6hEyR3NyhtNYf6YsVTP29SuazXvrTkYPUp2o2jX4RGuyixK1Wra-0	5xPmDeNaEDLJzKyS9MRLJkuKsse7kFdqLnHhR6hEyR3NyhtNYf6YsVTP29SuazXvrTkYPUp2o2jX4RGuyixK1Wra	2024-03-12T13:31:53.000Z	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw	SetProtocolFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	6	1300	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	253757442	4WaptrPFjRDMuKw6h75rfWqxFVxChFERx5NuapS3ZoRd	253757442-9xPiKBYDwesHPToWjs3dZTGMN2RtgKixQp9Raj9zM28mxSxKdYj3HT3g8dJ2SMcwwQ42yuQ7zv6TSBLtB5XXrJt-0	9xPiKBYDwesHPToWjs3dZTGMN2RtgKixQp9Raj9zM28mxSxKdYj3HT3g8dJ2SMcwwQ42yuQ7zv6TSBLtB5XXrJt	2024-03-12T17:57:21.000Z	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw	SetProtocolFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	7	1300	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw
2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	253628844	7QCLFaSN74p4qv5CgE4wrnAEf2vg6CkxMgUYqQLDHfV8	253628844-35oq4F6ciqMrMGwPM56Vm4BmdSAcy1vozz1sEjoq89rSqjyUPP7VufD6rYVXHosKxcBp4dnmysV2BCwwSMn4vbUF-0	35oq4F6ciqMrMGwPM56Vm4BmdSAcy1vozz1sEjoq89rSqjyUPP7VufD6rYVXHosKxcBp4dnmysV2BCwwSMn4vbUF	2024-03-12T02:57:35.000Z	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw	SetProtocolFeeRate	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	9	1300	6BLTtBS9miUZruZtR9reTzp6ctGc4kVY4xrcxQwurYtw

Example Query

Query with partition filter

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

Whirlpool_SetRewardEmissions_instruction

Instruction-level records of reward emission rate changes for Orca Whirlpool liquidity pools on Solana. Used to track incentive program adjustments and analyze liquidity mining reward distributions over time.

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_emissionsPerSecondX64`	`STRING`	Reward emission rate for the liquidity pool, denominated in tokens per second and multiplied by 2^64 for precision. This Q64.64 fixed-point value can range from 0 (no emissions) to large integers representing active reward programs.
`in_rewardIndex`	`STRING`	Index identifying which reward slot is being configured or claimed. String-encoded integer, zero-indexed.
`in_rewardAuthority`	`STRING`	Account address authorized to configure reward parameters for the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_rewardVault`	`STRING`	Account address of the token vault holding reward tokens for distribution to liquidity providers. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

block_slot	in_whirlpool	surrogate_key	in_rewardIndex	in_rewardVault	transaction_id	block_timestamp	instruction_type	executing_account	transaction_index	in_rewardAuthority	transaction_signer	in_emissionsPerSecondX64
154199448	GpqMSH1YM6oPmJ5xxEE2KfePf7uf5rXFbTW2TnxicRj6	154199448-3Q4YNN26o4FWsH7Y49ngStmBAcFJYn77jZ1YrHnu3cAzavv8qi1RrQjjq74uAU39J1wra2MjRM8iwiYxPAxhCeJh-0	1	E9t83swg8d8u6BjaAYN81VpyjMuqiKC1V9cBCeBxwd6i	3Q4YNN26o4FWsH7Y49ngStmBAcFJYn77jZ1YrHnu3cAzavv8qi1RrQjjq74uAU39J1wra2MjRM8iwiYxPAxhCeJh	2022-10-07T22:12:50.000Z	SetRewardEmissions	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	133	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	0
154199345	J7qn7AvZ4QK9qT6BikVBKA3hUp89Lg9UkqJmXZQEjRxq	154199345-4YYdRaAbBvVX9fia68XJgGXzzn2HmP65b1Drtph9UHYU3GsT8nZMvHgoEZS96abQkTWTTKX5engQsex3Cz2cyea4-0	1	8CH8Jr6T41MrUCsLCMoq5TNjx32ZrnpD5S5AyNdzLVSJ	4YYdRaAbBvVX9fia68XJgGXzzn2HmP65b1Drtph9UHYU3GsT8nZMvHgoEZS96abQkTWTTKX5engQsex3Cz2cyea4	2022-10-07T22:11:54.000Z	SetRewardEmissions	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	53	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	1143753472802213328846848
154193494	AiMZS5U3JMvpdvsr1KeaMiS354Z1DeSg5XjA4yYRxtFf	154193494-icAh3yvW3zcpiehuRM3cTTuPG51hG6RFZqaU3vNpzTgLzLpQjvBEDZbYz6MYpHuz4HEX2Xb6gpgevtYQ6uK3GdD-0	1	D8qyK7BjxnJTkGYnuAyhac8zYxb8rmaBt1y9zDFjsvPw	icAh3yvW3zcpiehuRM3cTTuPG51hG6RFZqaU3vNpzTgLzLpQjvBEDZbYz6MYpHuz4HEX2Xb6gpgevtYQ6uK3GdD	2022-10-07T21:20:16.000Z	SetRewardEmissions	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	157	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	1570535277656221259564843008

Example Query

Query with partition filter

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

Whirlpool_SetRewardEmissionsV2_instruction

Instruction-level records of reward emission rate updates for Orca Whirlpool liquidity pools on Solana. Used to track changes in incentive distribution rates (emissions per second) for specific reward tokens across 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_emissionsPerSecondX64`	`STRING`	Reward emission rate for a Whirlpool liquidity pool, expressed in X64 fixed-point format (actual rate divided by 2^64). Values of ‘0’ indicate emissions are disabled for that reward index.
`in_rewardIndex`	`STRING`	Index identifying which reward slot is being configured or claimed. String-encoded integer, zero-indexed.
`in_rewardAuthority`	`STRING`	Account address authorized to configure reward parameters for the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_rewardVault`	`STRING`	Account address of the token vault holding reward tokens for distribution to liquidity providers. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

block_slot	in_whirlpool	surrogate_key	in_rewardIndex	in_rewardVault	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	in_rewardAuthority	transaction_signer	in_emissionsPerSecondX64
312213996	4nAiqm5QiZiwh1sMpmuJJdVUH12Fst2kPPzApNfppQGd	312213996-5Yxm81W4o1WQxcDwpUSZuuE7Qg27q8CYhXW8vnavkBg7q14Ajpb6gaFVaR7oPk8TGjtWfL4NzaQ8zYBf4zj2U3oD-3	1	3xCKFNyZU11N3bZ1DufXskbHJQJ5hrdnTPPNpdq5wXYz	5Yxm81W4o1WQxcDwpUSZuuE7Qg27q8CYhXW8vnavkBg7q14Ajpb6gaFVaR7oPk8TGjtWfL4NzaQ8zYBf4zj2U3oD	2025-01-06T09:16:16.000Z	SetRewardEmissionsV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	285	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	0
312213944	FuvLSmZRY7X4tBciLbgVkSPLBW7v4d1i57D4sWd3ig8x	312213944-2w3JpUhRY2xhzYkzLzYKAjvWH4xSN5bc3AUQBynjUxQCYvHW9f32VA2RTS3tgTUpBLB9SZP8ZvN5qtvrU3py9CBR-3	1	AdKiz1uuFMYRFm8SKFxZKwVr1hmgVisLqzUFBvjao3uY	2w3JpUhRY2xhzYkzLzYKAjvWH4xSN5bc3AUQBynjUxQCYvHW9f32VA2RTS3tgTUpBLB9SZP8ZvN5qtvrU3py9CBR	2025-01-06T09:15:55.000Z	SetRewardEmissionsV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	167	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	0
323447276	8phK65jxmTPEN158xLgSr4oZvssw9SyTErpNZj3g7px4	323447276-55rAprM7WAU4Sq4ZUewuh65pNKd2hz2zHBzYyJTVmTRZ91nJ5XsDKtkTM38V2qp75ihUJuceUbWcaaU6B6M3DMwy-3	1	5xdSuBsRQBgg57gm461Hy6y8wfQUCfhM1pQ2w3KnWcPj	55rAprM7WAU4Sq4ZUewuh65pNKd2hz2zHBzYyJTVmTRZ91nJ5XsDKtkTM38V2qp75ihUJuceUbWcaaU6B6M3DMwy	2025-02-27T13:58:42.000Z	SetRewardEmissionsV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	3	30	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	DjDsi34mSB66p2nhBL6YvhbcLtZbkGfNybFeLDjJqxJW	1415005450866570466136243138

Example Query

Query with partition filter

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

Whirlpool_swap_instruction

Swap instruction records from Orca Whirlpool automated market maker (AMM) pools on Solana. Contains detailed swap parameters including token amounts, price limits, tick arrays, and vault accounts for analyzing liquidity pool trading activity.

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_aToB`	`STRING`	Boolean flag indicating the swap direction in the Whirlpool pool. When true, swaps from token A to token B; when false, swaps from token B to token A.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_otherAmountThreshold`	`STRING`	Minimum or maximum acceptable amount for the opposite side of the swap operation. Numeric string representation of token quantity in smallest denomination, serving as a slippage protection parameter.
`in_sqrtPriceLimit`	`STRING`	Square root of the price limit for the swap operation, represented as a fixed-point integer in Q64.64 format.
`in_amountSpecifiedIsInput`	`STRING`	Boolean flag indicating whether the amount parameter represents the input quantity for the swap operation. When true, the amount specifies the exact input tokens to swap; when false, it specifies the desired output tokens to receive.
`in_oracle`	`STRING`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickArray0`	`STRING`	Account address of the first tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray1`	`STRING`	Account address of the second tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray2`	`STRING`	Account address of the third tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tokenAuthority`	`STRING`	Account address authorized to transfer tokens from the owner’s token account. Base58-encoded Solana public key.
`in_tokenOwnerAccountA`	`STRING`	Account address holding the first token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenOwnerAccountB`	`STRING`	Account address holding the second token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_tokenVaultA`	`STRING`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRING`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_aToB	in_amount	in_oracle	block_slot	in_whirlpool	in_tickArray0	in_tickArray1	in_tickArray2	surrogate_key	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	in_tokenProgram	instruction_type	executing_account	in_sqrtPriceLimit	in_tokenAuthority	transaction_index	transaction_signer	in_tokenOwnerAccountA	in_tokenOwnerAccountB	in_otherAmountThreshold	outer_executing_account	outer_instruction_index	in_amountSpecifiedIsInput
true	10543826655961	5DYdLC1jhK9ACT1bbKw3rHeg8A5Jo82ksLkCM8keiv1G	181660673	5eNSot4bzvf2YKhNVyBTzSnxFQPXruvCMFd1zsR6oXXu	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	181660673-5fChheLTNNKYkfUwViJLY3gvk3AxXF3nYJ4Lnj6daVsCxjsKEn5Vvuzh8CqS7hbJPhHdQhUYqrtGWzpBJkpycwbZ-0	EdgPequgSZHmnGvb4Ci65qtFPFMWYNShiTTWF5sTPRgj	AZ56DNbU6eo2uJJY8VDokz5sQKsgzMnupzJEZ8aAc59K	5fChheLTNNKYkfUwViJLY3gvk3AxXF3nYJ4Lnj6daVsCxjsKEn5Vvuzh8CqS7hbJPhHdQhUYqrtGWzpBJkpycwbZ	2023-03-09T17:02:07.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	4295048016	7q1jCdB3HV5RR6FDRtbPjRjfAi7QFq6uuBaVBUpKhYCP	4	7q1jCdB3HV5RR6FDRtbPjRjfAi7QFq6uuBaVBUpKhYCP	8VATnx5MukXGZuFKg236MHV9zq6fxavFxa7x42dNBh4H	3ZqeByYG9hv4hd5PsakpCNJwipRmv6aJuDcdDHipLjd6	11248288			true
true	39049577139435	5DYdLC1jhK9ACT1bbKw3rHeg8A5Jo82ksLkCM8keiv1G	181602701	5eNSot4bzvf2YKhNVyBTzSnxFQPXruvCMFd1zsR6oXXu	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	181602701-5Awzb34bfN55XPRWRByfvEfwZEhxKw2wPGbtxBzqVWbFsBNByidsgdXe8MMYKgSa8KgjAaH3nNPEHAzVgNrzikRw-1-0	EdgPequgSZHmnGvb4Ci65qtFPFMWYNShiTTWF5sTPRgj	AZ56DNbU6eo2uJJY8VDokz5sQKsgzMnupzJEZ8aAc59K	5Awzb34bfN55XPRWRByfvEfwZEhxKw2wPGbtxBzqVWbFsBNByidsgdXe8MMYKgSa8KgjAaH3nNPEHAzVgNrzikRw	2023-03-09T09:15:48.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	4295048016	8RD6Rd3NfWBWrYmHJj9cfteWrdsC4MgeBdkEJ8paP3As	50	8RD6Rd3NfWBWrYmHJj9cfteWrdsC4MgeBdkEJ8paP3As	BAFTdTu3c5Qu48S6n8AbX1Z1kpVHMUzR192YcAhVahDs	EMdNi1gnK7StXJUarxmwe7JQMJos8Zpzu5BUiR3SpQ8M	0	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	1	true
true	106795341987225	5DYdLC1jhK9ACT1bbKw3rHeg8A5Jo82ksLkCM8keiv1G	181680456	5eNSot4bzvf2YKhNVyBTzSnxFQPXruvCMFd1zsR6oXXu	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	12bkBUuWQxJCRsK87g9LFbY3xNNuvLKq7RHD2m8CGWdp	181680456-48YhEf3fjToCwDiYwm3NUm7HQgp4J5kidcoNJtrfYBVFq6EfdkhA1PekisNesbALyGP961UZmyVyBniVNfNtRJGp-4-0	EdgPequgSZHmnGvb4Ci65qtFPFMWYNShiTTWF5sTPRgj	AZ56DNbU6eo2uJJY8VDokz5sQKsgzMnupzJEZ8aAc59K	48YhEf3fjToCwDiYwm3NUm7HQgp4J5kidcoNJtrfYBVFq6EfdkhA1PekisNesbALyGP961UZmyVyBniVNfNtRJGp	2023-03-09T19:43:51.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	4295048016	Cswwnzi6Pk5qfajxjsQCdgM7dgfvNTjesPhsGX6LmYsZ	134	Cswwnzi6Pk5qfajxjsQCdgM7dgfvNTjesPhsGX6LmYsZ	6hVC47dMHLF4A2k7ASBoRJE2yt6vEmTbe1s6VYuo3KW2	5tBofP8946QBhJbS8SevHV32uRfYXdnok8cf79TBYkBD	0	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	4	true

Example Query

Query with partition filter

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

Whirlpool_Swap_instruction

Swap instruction records from Orca’s Whirlpool concentrated liquidity automated market maker (AMM) pools on Solana. Contains token amounts, price limits, swap direction, and account references for analyzing trading patterns and liquidity pool interactions.

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_aToB`	`STRING`	Boolean flag indicating the swap direction in the Whirlpool pool. When true, swaps from token A to token B; when false, swaps from token B to token A.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_otherAmountThreshold`	`STRING`	Minimum or maximum acceptable amount for the opposite side of the swap operation. Numeric string representation of token quantity in smallest denomination, serving as a slippage protection parameter.
`in_sqrtPriceLimit`	`STRING`	Square root of the price limit for the swap operation, represented as a fixed-point integer in Q64.64 format.
`in_amountSpecifiedIsInput`	`STRING`	Boolean flag indicating whether the amount parameter represents the input quantity for the swap operation. When true, the amount specifies the exact input tokens to swap; when false, it specifies the desired output tokens to receive.
`in_oracle`	`STRING`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickArray0`	`STRING`	Account address of the first tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray1`	`STRING`	Account address of the second tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray2`	`STRING`	Account address of the third tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tokenAuthority`	`STRING`	Account address authorized to transfer tokens from the owner’s token account. Base58-encoded Solana public key.
`in_tokenOwnerAccountA`	`STRING`	Account address holding the first token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenOwnerAccountB`	`STRING`	Account address holding the second token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenProgram`	`STRING`	Address of the Solana Token Program invoked for token operations. Base58-encoded public key, typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022.
`in_tokenVaultA`	`STRING`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRING`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_aToB	in_amount	in_oracle	block_slot	in_whirlpool	in_tickArray0	in_tickArray1	in_tickArray2	surrogate_key	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	in_tokenProgram	instruction_type	executing_account	in_sqrtPriceLimit	in_tokenAuthority	instruction_index	transaction_index	transaction_signer	in_tokenOwnerAccountA	in_tokenOwnerAccountB	in_otherAmountThreshold	in_amountSpecifiedIsInput
true	713504	C5Fhtw7VLawwt2ZM4woBXGh5QqRWRs9Dcvdx4V543CNu	228168139	GLNvG5Ly4cK512oQeJqnwLftwfoPZ4skyDwZWzxorYQ9	13SKDmJSbJ6vudGrwQgA3UecB4oKkyKeTxkjErBjB3bK	13SKDmJSbJ6vudGrwQgA3UecB4oKkyKeTxkjErBjB3bK	13SKDmJSbJ6vudGrwQgA3UecB4oKkyKeTxkjErBjB3bK	228168139-xfUXngWWWiBUD5EVxpuf2tkxfJwvHq6so6gT4GRapEjU6AFZZ7hxDRhQwhc4YzfBNG6pE3rRagDFFv9rq7uB6ho-1	AzrRewYSJPSMFxf5WxSoTWw1mxqaPQtVgRmsBaPgQZ7B	2i4Dew7vLcTPDHTQF3Wska1CrsWaqNj99xuDvxJVvM8x	xfUXngWWWiBUD5EVxpuf2tkxfJwvHq6so6gT4GRapEjU6AFZZ7hxDRhQwhc4YzfBNG6pE3rRagDFFv9rq7uB6ho	2023-11-05T14:51:43.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	4295048016	7Zrez9Er4V1KdabPQ9GMZA29W5JRHmT3Gsn2jnAXYH7a	1	33	7Zrez9Er4V1KdabPQ9GMZA29W5JRHmT3Gsn2jnAXYH7a	2Qans16XqeQcZh4XhBYRiTVnoCJ5oFKwXmckf3P1b9Ha	4HVyK7uVXAjsFnyM4eZh5mZiGAceEp3Z3gwsPLfnepUZ	706077	true
true	378129	C5Fhtw7VLawwt2ZM4woBXGh5QqRWRs9Dcvdx4V543CNu	228220234	GLNvG5Ly4cK512oQeJqnwLftwfoPZ4skyDwZWzxorYQ9	13SKDmJSbJ6vudGrwQgA3UecB4oKkyKeTxkjErBjB3bK	13SKDmJSbJ6vudGrwQgA3UecB4oKkyKeTxkjErBjB3bK	13SKDmJSbJ6vudGrwQgA3UecB4oKkyKeTxkjErBjB3bK	228220234-GFFi1xUw9YT6izzt2p1vJJfohNAurd9JT1ArKToo9466xwpAYbeJaMGpwW4fy72RXuutyJBj19i5Bw9xvFRd6pC-1	AzrRewYSJPSMFxf5WxSoTWw1mxqaPQtVgRmsBaPgQZ7B	2i4Dew7vLcTPDHTQF3Wska1CrsWaqNj99xuDvxJVvM8x	GFFi1xUw9YT6izzt2p1vJJfohNAurd9JT1ArKToo9466xwpAYbeJaMGpwW4fy72RXuutyJBj19i5Bw9xvFRd6pC	2023-11-05T20:50:24.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	4295048016	7Zrez9Er4V1KdabPQ9GMZA29W5JRHmT3Gsn2jnAXYH7a	1	52	7Zrez9Er4V1KdabPQ9GMZA29W5JRHmT3Gsn2jnAXYH7a	2Qans16XqeQcZh4XhBYRiTVnoCJ5oFKwXmckf3P1b9Ha	4HVyK7uVXAjsFnyM4eZh5mZiGAceEp3Z3gwsPLfnepUZ	374246	true
false	999837	CdsK8J6mgWg1zjanhgbqo6UmxGUd3GVVDJNF1L7dK3bC	228146496	4dMCeFsjsGgakprFMtTY4uwuRL2p55Y6pJuQBcUFyu1v	DpgySHxrF9WQmq99p56eHzA4qH43xuJDuJuEzB1BABtt	4eLy8RGUhkncyJqHCMZvHU2Z8vDcvBQMkyuNMtHE1Zfk	254RLKTrzT8UCvw3DSo9pkd9VCc4M5WxDkjcAiJeaqHe	228146496-3z4QfV9mRfVAKfXjFZ5p1z2zn7ao7CH6DRNAUZ9S2BsZCNAC9pvY8TMpTQFmn28YvhkgvZrnYD5Sab8S1fdiy9xf-0	9b5K4vzc7UfcPSU5iUYoXTNEhr4d1AvnrJnPjC8WKPc2	EEMdi8He1dNfLArNK4Ep2WW35THHbNtEUYuFzzh4qzNY	3z4QfV9mRfVAKfXjFZ5p1z2zn7ao7CH6DRNAUZ9S2BsZCNAC9pvY8TMpTQFmn28YvhkgvZrnYD5Sab8S1fdiy9xf	2023-11-05T12:19:31.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Swap	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	79226673515401279992447579055	FnJZCfHc6LuZKCWMJGsHmpmqPeVVpxiJR3upiFp8TWsG	0	19	FnJZCfHc6LuZKCWMJGsHmpmqPeVVpxiJR3upiFp8TWsG	HfeJ7knMtbeRB8CHQmKKmNLBRX7x1L9Vsp8fU4x4kPby	34BBW47ENzCCGnWj8QkeVM8xoLyuKMQRngtoZPDPKPw5	397805276	true

Example Query

Query with partition filter

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

Whirlpool_swapV2_instruction

SwapV2 instruction executions from Orca Whirlpool concentrated liquidity pools on Solana, containing swap parameters including amount, direction, price limits, and involved token accounts for analyzing DEX trading patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`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.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`transaction_success`	`BOOL`	Boolean flag indicating whether the transaction executed successfully and was committed to the blockchain.
`instruction_program_address`	`STRING`	Address of the Solana program that executed the instruction. Base58-encoded public key.
`inner_instruction_index`	`INT64`	Position of the instruction within nested cross-program invocations. Zero-indexed integer representing the sequential order when one program calls another program’s instructions.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`name`	`STRING`	Name of the instruction or event type being executed. Identifies the specific operation performed within the smart contract or program.
`in_aToB`	`BOOL`	Boolean flag indicating the swap direction in the Whirlpool pool. When true, swaps from token A to token B; when false, swaps from token B to token A.
`in_amount`	`BIGNUMERIC`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_otherAmountThreshold`	`BIGNUMERIC`	Minimum or maximum acceptable amount for the opposite side of the swap operation. Numeric string representation of token quantity in smallest denomination, serving as a slippage protection parameter.
`in_sqrtPriceLimit`	`BIGNUMERIC`	Square root of the price limit for the swap operation, represented as a fixed-point integer in Q64.64 format.
`in_amountSpecifiedIsInput`	`BOOL`	Boolean flag indicating whether the amount parameter represents the input quantity for the swap operation. When true, the amount specifies the exact input tokens to swap; when false, it specifies the desired output tokens to receive.
`in_remainingAccountsInfo`	`JSON`	Additional account data passed to the instruction for extended functionality. Typically null for standard swaps but may contain configuration for advanced routing or oracle integrations.
`in_tokenProgramA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	SPL Token program address governing token A operations in this swap. Typically the standard Solana Token Program (TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA).
`in_tokenProgramB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Token program address governing token B in the swap pair. Typically the SPL Token program on Solana (TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA).
`in_memoProgram`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account reference for the memo program used to record swap metadata on-chain. Typically the Solana Memo program address (MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr) when memo functionality is enabled.
`in_tokenAuthority`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address authorized to transfer tokens from the owner’s token account. Base58-encoded Solana public key.
`in_whirlpool`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_tokenMintA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Contract address of the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenMintB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Contract address of the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenOwnerAccountA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address holding the first token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenVaultA`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenOwnerAccountB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address holding the second token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tickArray0`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the first tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray1`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the second tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray2`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the third tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_oracle`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

name	in_aToB	in_amount	in_oracle	block_height	in_whirlpool	in_tickArray0	in_tickArray1	in_tickArray2	in_tokenMintA	in_tokenMintB	surrogate_key	in_memoProgram	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	in_tokenProgramA	in_tokenProgramB	in_sqrtPriceLimit	in_tokenAuthority	instruction_index	transaction_index	transaction_success	in_tokenOwnerAccountA	in_tokenOwnerAccountB	inner_instruction_index	in_remainingAccountsInfo	in_amountSpecifiedIsInput	instruction_program_address
swapV2	false	7802	{“is_alt”:true,“address”:“2zzxEHGnWU6rb43twEogZERPLTY2VKdr1j5KuXriMFkw”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305242148	{“is_alt”:true,“address”:“G3vDQSmNfUfiXF27Y8LHER6yt13PsKaRuLER4eTUnpkM”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“2jQKKdtAYqtrXG4aEnpJV9HsuxuxpqgEjsYJQjL8QeTG”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“5DbUyyWM3V4mNaKfE625G4QEQ1csG9di6AyTTaRZUdPW”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“12F1hXkeitLdnw6jXzCfPsuQQDMwvr6BqNwzRvSaWAm3”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	Hc9MaZWUCnsUby4c6aayEVyqezmiDrgxmNodCftBKFAH-2qfLLFPiemMZbRGF5H2dWbJeKuqQrLNsY3RQBHxzxx6YoKHgozHgHvQf33gduqY34Q9t1prmZ8budpYtpZ2PkRsR-3-1	{“is_alt”:true,“address”:“MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“8d6EBn9WnYEABtDktsna44a7x9BB7ZdXTEnJJEc6Juy8”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“FcfFqLKyv9W4iwhXZWqmxzmLuEjD5HnzsGCzhLS4wR4J”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	2qfLLFPiemMZbRGF5H2dWbJeKuqQrLNsY3RQBHxzxx6YoKHgozHgHvQf33gduqY34Q9t1prmZ8budpYtpZ2PkRsR	2025-03-15T19:39:52.000Z	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	7.9226673515401279992447579055e+28	{“is_alt”:false,“address”:“BQ72nSv9f3PRyRKCBnHLVrerrv37CYTHm5h3s9VSGQDV”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	3	316	true	{“is_alt”:false,“address”:“8ctcHN52LY21FEipCjr1MVWtoZa1irJQTPyAaTj72h7S”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“2kG7tEsTFxNWmS71aDUNigaHPPVKUfkzuFr8CBhsAqRh”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	1	null	true	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc
swapV2	false	7270	{“is_alt”:true,“address”:“2zzxEHGnWU6rb43twEogZERPLTY2VKdr1j5KuXriMFkw”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305214948	{“is_alt”:true,“address”:“G3vDQSmNfUfiXF27Y8LHER6yt13PsKaRuLER4eTUnpkM”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“2jQKKdtAYqtrXG4aEnpJV9HsuxuxpqgEjsYJQjL8QeTG”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“5DbUyyWM3V4mNaKfE625G4QEQ1csG9di6AyTTaRZUdPW”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“12F1hXkeitLdnw6jXzCfPsuQQDMwvr6BqNwzRvSaWAm3”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	6Fdfc4kM19s3LrkbCDeocZpPk1NrDwPfZDSCq5QnyWYv-2tgNtTRxMGqnY1rEt6HW4aonbke9MV2sNXk1wbKkiuXsNWarZu4uB1BRctdw359DC6y1ZR7KJBwNT32KEtGAyTR4-3-1	{“is_alt”:true,“address”:“MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“8d6EBn9WnYEABtDktsna44a7x9BB7ZdXTEnJJEc6Juy8”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“FcfFqLKyv9W4iwhXZWqmxzmLuEjD5HnzsGCzhLS4wR4J”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	2tgNtTRxMGqnY1rEt6HW4aonbke9MV2sNXk1wbKkiuXsNWarZu4uB1BRctdw359DC6y1ZR7KJBwNT32KEtGAyTR4	2025-03-15T16:38:48.000Z	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	7.9226673515401279992447579055e+28	{“is_alt”:false,“address”:“CapuXNQoDviLvU1PxFiizLgPNQCxrsag1uMeyk6zLVps”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	3	1041	true	{“is_alt”:false,“address”:“91bUbswo6Di8235jAPwim1At4cPZLbG2pkpneyqKg4NQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“ExPLiWjwLAL5ZqiLW1Jg1bJydhTcHV8KamBWUjmxKzVk”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	1	null	true	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc
swapV2	false	10080	{“is_alt”:true,“address”:“2zzxEHGnWU6rb43twEogZERPLTY2VKdr1j5KuXriMFkw”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305197156	{“is_alt”:true,“address”:“G3vDQSmNfUfiXF27Y8LHER6yt13PsKaRuLER4eTUnpkM”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“2jQKKdtAYqtrXG4aEnpJV9HsuxuxpqgEjsYJQjL8QeTG”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“5DbUyyWM3V4mNaKfE625G4QEQ1csG9di6AyTTaRZUdPW”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“12F1hXkeitLdnw6jXzCfPsuQQDMwvr6BqNwzRvSaWAm3”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	9crPBtNsJGmAPuVDnyU3q3cjDywe4rXWChUmGTB4pM3T-5swNKbFB7yyey3TEdmCRRHXAjCZCraFeXomX9WbD5UvqHjYBzUpB5BomAkEFwhjHnTYaiicXbj7D77xafdVBWWBE-2-1	{“is_alt”:true,“address”:“MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“8d6EBn9WnYEABtDktsna44a7x9BB7ZdXTEnJJEc6Juy8”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“FcfFqLKyv9W4iwhXZWqmxzmLuEjD5HnzsGCzhLS4wR4J”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	5swNKbFB7yyey3TEdmCRRHXAjCZCraFeXomX9WbD5UvqHjYBzUpB5BomAkEFwhjHnTYaiicXbj7D77xafdVBWWBE	2025-03-15T14:40:17.000Z	{“is_alt”:true,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:true,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	7.9226673515401279992447579055e+28	{“is_alt”:false,“address”:“2MFoS3MPtvyQ4Wh4M9pdfPjz6UhVoNbFbGJAskCPCj3h”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	2	77	true	{“is_alt”:false,“address”:“H1qQ6Hent1C5wa4Hc3GK2V1sgg4grvDBbmKd5H8dsTmo”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“9GUDbyWcwBBxxpYTo9H8udB6ZibyKA6s2fw4ojyAkP1Q”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	1	null	true	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc

Example Query

Query with partition filter

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

Whirlpool_SwapV2_instruction

SwapV2 instruction records from Orca’s Whirlpool concentrated liquidity automated market maker (AMM) on Solana, capturing token pair exchanges with swap direction, amounts, price limits, and tick array references for analyzing DEX trading activity.

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_aToB`	`STRING`	Boolean flag indicating the swap direction in the Whirlpool pool. When true, swaps from token A to token B; when false, swaps from token B to token A.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_otherAmountThreshold`	`STRING`	Minimum or maximum acceptable amount for the opposite side of the swap operation. Numeric string representation of token quantity in smallest denomination, serving as a slippage protection parameter.
`in_sqrtPriceLimit`	`STRING`	Square root of the price limit for the swap operation, represented as a fixed-point integer in Q64.64 format.
`in_amountSpecifiedIsInput`	`STRING`	Boolean flag indicating whether the amount parameter represents the input quantity for the swap operation. When true, the amount specifies the exact input tokens to swap; when false, it specifies the desired output tokens to receive.
`in_memoProgram`	`STRING`	Program account address for attaching memos to the swap transaction. Typically references Solana’s Memo program (MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr) when metadata is included.
`in_oracle`	`STRING`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickArray0`	`STRING`	Account address of the first tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray1`	`STRING`	Account address of the second tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tickArray2`	`STRING`	Account address of the third tick array used for price range tracking in the swap operation. Base58-encoded Solana public key.
`in_tokenAuthority`	`STRING`	Account address authorized to transfer tokens from the owner’s token account. Base58-encoded Solana public key.
`in_tokenMintA`	`STRING`	Contract address of the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenMintB`	`STRING`	Contract address of the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenOwnerAccountA`	`STRING`	Account address holding the first token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenOwnerAccountB`	`STRING`	Account address holding the second token in the swap owner’s balance for the transaction. Base58-encoded Solana public key.
`in_tokenProgramA`	`STRING`	Token program address governing token A operations in the swap. Typically the standard Solana Token Program (TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA) for SPL tokens.
`in_tokenProgramB`	`STRING`	Token program account address governing token B in the swap. Typically the standard Solana Token Program (TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA) for SPL tokens.
`in_tokenVaultA`	`STRING`	Account address of the token vault holding the first token in the pool’s trading pair. Base58-encoded Solana public key.
`in_tokenVaultB`	`STRING`	Account address of the token vault holding the second token in the pool’s trading pair. Base58-encoded Solana public key.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.

Sample Data

in_aToB	in_amount	in_oracle	block_slot	in_whirlpool	in_tickArray0	in_tickArray1	in_tickArray2	in_tokenMintA	in_tokenMintB	surrogate_key	in_memoProgram	in_tokenVaultA	in_tokenVaultB	transaction_id	block_timestamp	in_tokenProgramA	in_tokenProgramB	instruction_type	executing_account	in_sqrtPriceLimit	in_tokenAuthority	transaction_index	transaction_signer	in_tokenOwnerAccountA	in_tokenOwnerAccountB	outer_executing_account	outer_instruction_index	in_amountSpecifiedIsInput
false	37122	9QZDM8BGb2mL1qmyNRSPz5tBYFY9XWSYZYMgFVy8KsLn	366933254	5gE4kFKgqNbgMK1PJtzzLxaxgfGePaYxfDBk33PaRngm	FDV2Ny73JRdbsg15rzy4XbjcPfDJMvdjsPFrCx1PipJA	BW9Xwh4VpiBrYPR6wBBG5iuNvK5PGq9REn2bPHYQMJP7	13SMosuCRcDgjFR3Qen3ez6QX1yhPe1Nprfik1Zu3kzU	So11111111111111111111111111111111111111112	7Pnqg1S6MYrL6AP1ZXcToTHfdBbTB77ze6Y33qBBpump	366933254-4PCGZX3tQhuY9QKqfzwKstG8dTJbZdoQ4svnnohKHdwtziSAo1AZDexv8fJStsHjLm9Y5TNhyTUiNAqKRAjzS8zf-3-0	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	DWLJrwRt2n1bAo32zH5w1ZJMXCCq1uZihrpDiLGoGKuJ	3ChVtaTY7PgGMxMy8MJn3fV5AVRbFAf4nnpWmcdHFjtK	4PCGZX3tQhuY9QKqfzwKstG8dTJbZdoQ4svnnohKHdwtziSAo1AZDexv8fJStsHjLm9Y5TNhyTUiNAqKRAjzS8zf	2025-09-15T06:49:16.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	SwapV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	79226673515401279992447579055	Gq75t6TLixChyktxfEDwpALsmd7jxczwgzfd9EWBhXBb	172	Gq75t6TLixChyktxfEDwpALsmd7jxczwgzfd9EWBhXBb	ETHFJx7HiqWwvme9xkM9wNtpzrxB8CBEmWxEsKQrnrTc	HwzDyW27vfDQ3V4G2F6LYtbdAZRdi9VCekJyheUqeEua	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	3	true
false	20037808	9QZDM8BGb2mL1qmyNRSPz5tBYFY9XWSYZYMgFVy8KsLn	366926293	5gE4kFKgqNbgMK1PJtzzLxaxgfGePaYxfDBk33PaRngm	FDV2Ny73JRdbsg15rzy4XbjcPfDJMvdjsPFrCx1PipJA	BW9Xwh4VpiBrYPR6wBBG5iuNvK5PGq9REn2bPHYQMJP7	13SMosuCRcDgjFR3Qen3ez6QX1yhPe1Nprfik1Zu3kzU	So11111111111111111111111111111111111111112	7Pnqg1S6MYrL6AP1ZXcToTHfdBbTB77ze6Y33qBBpump	366926293-28TUGDz82eHVTcB8TyfJApMyc6Q5W4imxFsEeJ8fFbE9o2xQpcwAGV4b84xRd56twNLUC6uFBeAUjqRZWi9gfgnv-3-0	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	DWLJrwRt2n1bAo32zH5w1ZJMXCCq1uZihrpDiLGoGKuJ	3ChVtaTY7PgGMxMy8MJn3fV5AVRbFAf4nnpWmcdHFjtK	28TUGDz82eHVTcB8TyfJApMyc6Q5W4imxFsEeJ8fFbE9o2xQpcwAGV4b84xRd56twNLUC6uFBeAUjqRZWi9gfgnv	2025-09-15T06:03:30.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	SwapV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	79226673515401279992447579055	4MSyhcZNZSKdJCvDmEo6JED5JTk19LZrf8KeHVEbC7zG	328	4MSyhcZNZSKdJCvDmEo6JED5JTk19LZrf8KeHVEbC7zG	9RCkk3q3mzMMwMgw5rxrdYss6HXqptK8AgeRhddntTuu	BrA4hmAucd8AGcJu1gCe9bZTAyKcbCpNkAH9i4EYX5bf	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	3	true
false	16816239	9QZDM8BGb2mL1qmyNRSPz5tBYFY9XWSYZYMgFVy8KsLn	366875276	5gE4kFKgqNbgMK1PJtzzLxaxgfGePaYxfDBk33PaRngm	FDV2Ny73JRdbsg15rzy4XbjcPfDJMvdjsPFrCx1PipJA	BW9Xwh4VpiBrYPR6wBBG5iuNvK5PGq9REn2bPHYQMJP7	13SMosuCRcDgjFR3Qen3ez6QX1yhPe1Nprfik1Zu3kzU	So11111111111111111111111111111111111111112	7Pnqg1S6MYrL6AP1ZXcToTHfdBbTB77ze6Y33qBBpump	366875276-3TofciB6BVkLmFtbqp587t8Q3MABbocbar9y9UeDRB7HaHprg4ng4JD2UKDZCw8sCGHnGBML1dddgKAyNoBedYeQ-3-0	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	DWLJrwRt2n1bAo32zH5w1ZJMXCCq1uZihrpDiLGoGKuJ	3ChVtaTY7PgGMxMy8MJn3fV5AVRbFAf4nnpWmcdHFjtK	3TofciB6BVkLmFtbqp587t8Q3MABbocbar9y9UeDRB7HaHprg4ng4JD2UKDZCw8sCGHnGBML1dddgKAyNoBedYeQ	2025-09-15T00:28:21.000Z	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	SwapV2	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	79226673515401279992447579055	Ci1RVxJr5T16aJDnGHFqexkecL6sehbtps7TmpELGD4H	219	Ci1RVxJr5T16aJDnGHFqexkecL6sehbtps7TmpELGD4H	6yhactWUvTnf7cWsFBSvdWyMYQeLDzYen3Cs6Y93naeJ	8snnvRukehuoyU3uViMu3L9MXqubzhbCBhVjYYmJNERw	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	3	true

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Staking_Stake_instruction

TokenSwapV2_Initialize_instruction

TokenSwapV2_Swap_instruction

Whirlpool_InitializeConfig_instruction

Whirlpool_InitializeFeeTier_instruction

Whirlpool_InitializePool_instruction

Whirlpool_initializePoolV2_instruction

Whirlpool_InitializePoolV2_instruction

Whirlpool_InitializeReward_instruction

Whirlpool_InitializeRewardV2_instruction

Whirlpool_SetDefaultFeeRate_instruction

Whirlpool_SetDefaultProtocolFeeRate_instruction

Whirlpool_SetFeeRate_instruction

Whirlpool_SetProtocolFeeRate_instruction

Whirlpool_SetRewardEmissions_instruction

Whirlpool_SetRewardEmissionsV2_instruction

Whirlpool_swap_instruction

Whirlpool_Swap_instruction

Whirlpool_swapV2_instruction

Whirlpool_SwapV2_instruction

Metrics

Primitives

Contracts

Blockchain

​Tables

​Staking_Stake_instruction

​TokenSwapV2_Initialize_instruction

​TokenSwapV2_Swap_instruction

​Whirlpool_InitializeConfig_instruction

​Whirlpool_InitializeFeeTier_instruction

​Whirlpool_InitializePool_instruction

​Whirlpool_initializePoolV2_instruction

​Whirlpool_InitializePoolV2_instruction

​Whirlpool_InitializeReward_instruction

​Whirlpool_InitializeRewardV2_instruction

​Whirlpool_SetDefaultFeeRate_instruction

​Whirlpool_SetDefaultProtocolFeeRate_instruction

​Whirlpool_SetFeeRate_instruction

​Whirlpool_SetProtocolFeeRate_instruction

​Whirlpool_SetRewardEmissions_instruction

​Whirlpool_SetRewardEmissionsV2_instruction

​Whirlpool_swap_instruction

​Whirlpool_Swap_instruction

​Whirlpool_swapV2_instruction

​Whirlpool_SwapV2_instruction

Tables

Staking_Stake_instruction

TokenSwapV2_Initialize_instruction

TokenSwapV2_Swap_instruction

Whirlpool_InitializeConfig_instruction

Whirlpool_InitializeFeeTier_instruction

Whirlpool_InitializePool_instruction

Whirlpool_initializePoolV2_instruction

Whirlpool_InitializePoolV2_instruction

Whirlpool_InitializeReward_instruction

Whirlpool_InitializeRewardV2_instruction

Whirlpool_SetDefaultFeeRate_instruction

Whirlpool_SetDefaultProtocolFeeRate_instruction

Whirlpool_SetFeeRate_instruction

Whirlpool_SetProtocolFeeRate_instruction

Whirlpool_SetRewardEmissions_instruction

Whirlpool_SetRewardEmissionsV2_instruction

Whirlpool_swap_instruction

Whirlpool_Swap_instruction

Whirlpool_swapV2_instruction

Whirlpool_SwapV2_instruction