orca_v2_solana

Tables

Whirlpool_InitializeAdaptiveFeeTier_instruction

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	-
`block_slot`	`INT64`	-
`transaction_id`	`STRING`	-
`transaction_index`	`INT64`	-
`transaction_signer`	`STRING`	-
`instruction_index`	`INT64`	-
`outer_instruction_index`	`INT64`	-
`executing_account`	`STRING`	-
`outer_executing_account`	`STRING`	-
`surrogate_key`	`STRING`	-
`instruction_type`	`STRING`	-
`in_adaptive_fee_tier`	`STRING`	-
`in_fee_authority`	`STRING`	-
`in_funder`	`STRING`	-
`in_system_program`	`STRING`	-
`in_whirlpools_config`	`STRING`	-
`in_remaining_accounts`	`JSON`	-
`in_adaptive_fee_control_factor`	`STRING`	-
`in_decay_period`	`STRING`	-
`in_default_base_fee_rate`	`STRING`	-
`in_delegated_fee_authority`	`STRING`	-
`in_fee_tier_index`	`STRING`	-
`in_filter_period`	`STRING`	-
`in_initialize_pool_authority`	`STRING`	-
`in_major_swap_threshold_ticks`	`STRING`	-
`in_max_volatility_accumulator`	`STRING`	-
`in_reduction_factor`	`STRING`	-
`in_tick_group_size`	`STRING`	-
`in_tick_spacing`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Whirlpool_InitializePoolWithAdaptiveFee_instruction

Liquidity pool initialization instructions from Orca v2’s Whirlpool automated market maker (AMM) on Solana, capturing new pool deployments with adaptive fee tiers, token pairs, and initial pricing parameters.

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_adaptive_fee_tier`	`STRING`	Account address of the adaptive fee tier configuration used by this Whirlpool. Determines the dynamic fee structure applied to swaps in this liquidity pool.
`in_funder`	`STRING`	Account address that provides funds for the transaction or operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_initialize_pool_authority`	`STRING`	Account authorized to initialize the Whirlpool liquidity pool on Orca V2. Base58-encoded Solana address, typically matches the transaction signer and funder.
`in_oracle`	`STRING`	Contract address of the oracle providing price feed data. Hex-encoded, 0x-prefixed, 42-character string.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_token_badge_a`	`STRING`	Token badge account address for the first token (A) in the Whirlpool pair, used to track token metadata and permissions. Base58-encoded Solana account address, typically consistent within a protocol deployment.
`in_token_badge_b`	`STRING`	Account address for token B’s badge metadata in Orca’s whirlpool configuration. Used to validate and track token characteristics within the pool initialization process.
`in_token_mint_a`	`STRING`	Mint address for the first token (token A) in the liquidity pool pair on Solana. Base-58 encoded public key identifying the token program account for the pool’s primary asset.
`in_token_mint_b`	`STRING`	Mint address of the second token (token B) in the initialized liquidity pool. Base-58 encoded Solana address representing the SPL token or native SOL wrapper.
`in_token_program_a`	`STRING`	Solana program address managing token A operations in the pool. Typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL tokens or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022 standard.
`in_token_program_b`	`STRING`	Token program account address governing the second token (B) in the liquidity pool. Always TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA (SPL Token) or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb (Token-2022) based on mint requirements.
`in_token_vault_a`	`STRING`	Account address of the token vault holding reserves for token A in the Whirlpool liquidity pool. Created during pool initialization and owned by the Whirlpool program to custody token A deposits.
`in_token_vault_b`	`STRING`	Account address holding token B reserves for this liquidity pool. Created during pool initialization to custody the second token in the trading pair.
`in_whirlpool`	`STRING`	Account address of the Whirlpool liquidity pool. Base58-encoded Solana public key.
`in_whirlpools_config`	`STRING`	Address of the Orca Whirlpools configuration account that defines global protocol parameters for this deployment. Always set to the same base58-encoded Solana address across all pool initializations within this Whirlpools instance.
`in_initial_sqrt_price`	`BIGNUMERIC`	Initial square root price for the liquidity pool at creation, encoded as a fixed-point integer. Determines the starting exchange rate between the two tokens in the pool.
`in_remaining_accounts`	`JSON`	Additional accounts required for instruction execution beyond the standard account set. JSON array of Base58-encoded Solana public keys.

Sample Data

in_rent	in_funder	in_oracle	block_slot	in_whirlpool	surrogate_key	transaction_id	block_timestamp	in_token_mint_a	in_token_mint_b	in_token_badge_a	in_token_badge_b	in_token_vault_a	in_token_vault_b	instruction_type	executing_account	in_system_program	instruction_index	transaction_index	in_token_program_a	in_token_program_b	transaction_signer	in_adaptive_fee_tier	in_whirlpools_config	in_initial_sqrt_price	in_remaining_accounts	in_initialize_pool_authority
SysvarRent111111111111111111111111111111111	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN	EWRnMgEhUPHSpwgWGZPFXUhyW7TwDBCTuEyxRPZDgnXJ	359323581	GaHA4LWbYsZWfxnJXsTZneNBNNa3VEwkouKQYG6qS7RA	359323581-4z8zRMrjCHKzZH8rK86Uwo4aTQ1b6CK8D3o8ogb44u7LrGgHw7CZTXytjdGP3gjkMdng7zKUod1Ny34ejVp6Ju2g-3	4z8zRMrjCHKzZH8rK86Uwo4aTQ1b6CK8D3o8ogb44u7LrGgHw7CZTXytjdGP3gjkMdng7zKUod1Ny34ejVp6Ju2g	2025-08-11T10:41:32.000Z	JxxWsvm9jHt4ah7DT9NuLyVLYZcZLUdPD93PcPQ71Ka	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	5ZXFYvztJ5NcyP3sLxDDo3y3xjTHvnDNWEm9MmT9WYsy	7aaBNde6QQZi5E4RCsfPf8J3BGbDUyGjkrMyZ51AXH2a	ApyLsVB5TKpeqBH2e7UZZKpGJ55jyknwC2iass1Yydxg	Akh4N2iT4j5vWmfKDjrrdSZxPmZ1Xvz5kvry7LEViZZr	InitializePoolWithAdaptiveFee	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	11111111111111111111111111111111	3	160	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN	FFvZf8vio5jhY14RUcF8xBpKYrdKGhvybG3CbFexM2b5	2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	8940792610702877	[]	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN
SysvarRent111111111111111111111111111111111	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN	DjsZRpA8jZcLVfw5UTZmtybmSTzrAP9base9dPRDY2ai	359366268	GJ4eijTxac8drUEUdjwwkusavwDDdViKDk9UETcvfiWk	359366268-5p2MkTJCznVxkFGStnLLxppWbPVC4X9fbkjTABjYUeWiLhBgLgQfARQqJJodWYvzp19VUpMae8RsRCFUkZdf4ByU-3	5p2MkTJCznVxkFGStnLLxppWbPVC4X9fbkjTABjYUeWiLhBgLgQfARQqJJodWYvzp19VUpMae8RsRCFUkZdf4ByU	2025-08-11T15:19:40.000Z	BkW2v5uv6skTW5c5GYjBctkbY9nuyyHs3gry1dCo5Hra	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	CPYCATHbLU9PKCiWqmWqCY5cWjw81j3aNwwcwDHCHMoU	7aaBNde6QQZi5E4RCsfPf8J3BGbDUyGjkrMyZ51AXH2a	HqUxTHdWJvks6bAoLkQbLtTqYNnwHJKZGBjhW2dUfxJu	H9pi4MCdGKYswXzvnfcryuQZ8xnR2Zd159osUy5w1gE6	InitializePoolWithAdaptiveFee	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	11111111111111111111111111111111	3	56	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN	FFvZf8vio5jhY14RUcF8xBpKYrdKGhvybG3CbFexM2b5	2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	57155146071381964	[]	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN
SysvarRent111111111111111111111111111111111	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN	Ef6geFdSAzg6j5HT545aDRTA49WvjGi65o9MKJCiJhCi	359325528	4HH7EqECSnZCPsvf3Zczyr16T89Xjmgh1ZnqojnitHwK	359325528-Jvj97gGeWNmCaA64mU2v19S9RoZyChx15RC8Mj4xcSTd6Ks4uqhs2g1ZYf3SaHFu9Q9gkZRRCkvrr2Rw3xe8Y2b-3	Jvj97gGeWNmCaA64mU2v19S9RoZyChx15RC8Mj4xcSTd6Ks4uqhs2g1ZYf3SaHFu9Q9gkZRRCkvrr2Rw3xe8Y2b	2025-08-11T10:54:17.000Z	4MeqZ8v3XbNVVX6B69XxXaymoTX6DbK8iZgaGngCbonk	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	A9UJugPZBJZ1QqgZ6DwGZM1BdvqC871X48nmx1rP8ty9	7aaBNde6QQZi5E4RCsfPf8J3BGbDUyGjkrMyZ51AXH2a	Aa2a89SEwRnNXWfERowkEuX4JQunEhrEANwnr8V7MLF8	8c8r6hbqYuTAtiYogCmPa99uNEYSJhjvx81jAfzUSh2e	InitializePoolWithAdaptiveFee	whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc	11111111111111111111111111111111	3	115	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN	AySnqHvKXDRjisecZ6MNq9WHfHxGPVqYKk29bvCQV3od	2LecshUwdy9xi7meFgHtFJQNSKk4KdTrcpvaB56dP2NQ	742031601695487446	[]	2G3tAmZULTM3XCKo429CifuEEYzVRu25cExMRouQ4NpN

Example Query

Query with partition filter

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

Whirlpool_SetDefaultBaseFeeRate_instruction

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	-
`block_slot`	`INT64`	-
`transaction_id`	`STRING`	-
`transaction_index`	`INT64`	-
`transaction_signer`	`STRING`	-
`instruction_index`	`INT64`	-
`outer_instruction_index`	`INT64`	-
`executing_account`	`STRING`	-
`outer_executing_account`	`STRING`	-
`surrogate_key`	`STRING`	-
`instruction_type`	`STRING`	-
`in_adaptive_fee_tier`	`STRING`	-
`in_fee_authority`	`STRING`	-
`in_whirlpools_config`	`STRING`	-
`in_remaining_accounts`	`JSON`	-
`in_default_base_fee_rate`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Whirlpool_SetPresetAdaptiveFeeConstants_instruction

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	-
`block_slot`	`INT64`	-
`transaction_id`	`STRING`	-
`transaction_index`	`INT64`	-
`transaction_signer`	`STRING`	-
`instruction_index`	`INT64`	-
`outer_instruction_index`	`INT64`	-
`executing_account`	`STRING`	-
`outer_executing_account`	`STRING`	-
`surrogate_key`	`STRING`	-
`instruction_type`	`STRING`	-
`in_adaptive_fee_tier`	`STRING`	-
`in_fee_authority`	`STRING`	-
`in_whirlpools_config`	`STRING`	-
`in_remaining_accounts`	`JSON`	-
`in_adaptive_fee_control_factor`	`STRING`	-
`in_decay_period`	`STRING`	-
`in_filter_period`	`STRING`	-
`in_major_swap_threshold_ticks`	`STRING`	-
`in_max_volatility_accumulator`	`STRING`	-
`in_reduction_factor`	`STRING`	-
`in_tick_group_size`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Whirlpool_InitializeAdaptiveFeeTier_instruction

Whirlpool_InitializePoolWithAdaptiveFee_instruction

Whirlpool_SetDefaultBaseFeeRate_instruction

Whirlpool_SetPresetAdaptiveFeeConstants_instruction

Metrics

Primitives

Contracts

Blockchain

​Tables

​Whirlpool_InitializeAdaptiveFeeTier_instruction

​Whirlpool_InitializePoolWithAdaptiveFee_instruction

​Whirlpool_SetDefaultBaseFeeRate_instruction

​Whirlpool_SetPresetAdaptiveFeeConstants_instruction

Tables

Whirlpool_InitializeAdaptiveFeeTier_instruction

Whirlpool_InitializePoolWithAdaptiveFee_instruction

Whirlpool_SetDefaultBaseFeeRate_instruction

Whirlpool_SetPresetAdaptiveFeeConstants_instruction