stabble_v1_solana

Tables

StableSwap_Swap_instruction

Swap instruction records from Stabble Protocol’s StableSwap automated market maker (AMM) on Solana. Captures token-to-token exchanges through liquidity pools with input amounts, minimum output constraints, and vault account references for analyzing stablecoin swap activity and slippage tolerance.

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.
`beneficiary_token_out`	`STRING`	Account address receiving the output tokens from the swap transaction. Base58-encoded Solana public key.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_token_in`	`STRING`	Account address holding the user’s input token before the swap. Base58-encoded Solana public key.
`user_token_out`	`STRING`	Account address holding the user’s output token after the swap. Base58-encoded Solana public key.
`vault`	`STRING`	Account address of the vault holding protocol-controlled assets. Base58-encoded Solana public key.
`vault_authority`	`STRING`	Account address authorized to manage vault operations and token transfers. Base58-encoded Solana public key.
`vault_program`	`STRING`	Program address managing vault operations for the swap protocol. Base58-encoded Solana public key.
`vault_token_in`	`STRING`	Account address holding the vault’s input token before the swap. Base58-encoded Solana public key.
`vault_token_out`	`STRING`	Account address holding the vault’s output token after the swap. Base58-encoded Solana public key.
`withdraw_authority`	`STRING`	Account address authorized to withdraw tokens from the vault. Base58-encoded Solana public key.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	user	vault	amount_in	block_slot	surrogate_key	token_program	user_token_in	vault_program	transaction_id	user_token_out	vault_token_in	block_timestamp	vault_authority	vault_token_out	instruction_type	executing_account	instruction_index	transaction_index	minimum_amount_out	remaining_accounts	transaction_signer	withdraw_authority	beneficiary_token_out
5K7CHUbBYAh6wrantyJvDDqwT4VoKuZTi73CN1DTUUer	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	2303400296	313553448	313553448-3xG7UQ45FJMiPhpFee9xRM757spGoaERwss23BoBvWRLqGXDufYTZqQnwK7GdDJXD7X6f7Wi8sPXPjZpJvVNewh6-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	9BaeKpEaaTA4dAeLd1VcQ7Wto9YWmQmWn7KnhNSvmbtv	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	3xG7UQ45FJMiPhpFee9xRM757spGoaERwss23BoBvWRLqGXDufYTZqQnwK7GdDJXD7X6f7Wi8sPXPjZpJvVNewh6	465hpb9FxqreEBmgts2YTwBtYrG9YMqkXt61MmnhhFij	95QUtvDkuoDZrNJiuh9MdahkpRNtSVhZRe83oepd8AM7	2025-01-12T17:03:58.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	Swap	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	3	201	2302289788	[]	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa
DLgzpha6oCe14yjM4i3kygY3QjGBTd8Bw327Wtd4JsLZ	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	445905002	313520280	313520280-2oc4ZLesoznCkVHR47UWpun6AxCAV1xsfrRceX5GZTGWfmqCxRaGAjdqLqScXyiDNzF3WiLgE682M8Sdm6GtCLDQ-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	9BaeKpEaaTA4dAeLd1VcQ7Wto9YWmQmWn7KnhNSvmbtv	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	2oc4ZLesoznCkVHR47UWpun6AxCAV1xsfrRceX5GZTGWfmqCxRaGAjdqLqScXyiDNzF3WiLgE682M8Sdm6GtCLDQ	465hpb9FxqreEBmgts2YTwBtYrG9YMqkXt61MmnhhFij	95QUtvDkuoDZrNJiuh9MdahkpRNtSVhZRe83oepd8AM7	2025-01-12T13:18:16.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	Swap	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	3	364	445613476	[]	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa
5K7CHUbBYAh6wrantyJvDDqwT4VoKuZTi73CN1DTUUer	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	2919195626	313525133	313525133-n5BiAaYaiMsogYUeMf1qXxn7Z3red5xAAwjpp2DRu6A3q8RC2WrdsK5wxxMB7LW8ikPBcyHExVfSBfDVg2q2ag2-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	9BaeKpEaaTA4dAeLd1VcQ7Wto9YWmQmWn7KnhNSvmbtv	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	n5BiAaYaiMsogYUeMf1qXxn7Z3red5xAAwjpp2DRu6A3q8RC2WrdsK5wxxMB7LW8ikPBcyHExVfSBfDVg2q2ag2	465hpb9FxqreEBmgts2YTwBtYrG9YMqkXt61MmnhhFij	95QUtvDkuoDZrNJiuh9MdahkpRNtSVhZRe83oepd8AM7	2025-01-12T13:51:13.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	Swap	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	3	68	2917563003	[]	GGgUJX5Ckvxg7mw1pB3jXEphg2w3Ndt5x731Vrjk9FkC	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa

Example Query

Query with partition filter

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

StableSwap_SwapV2_instruction

Token swap instruction records from Stabble StableSwap protocol on Solana. Captures swap amounts, pool identifiers, token mint addresses, and vault details for analyzing stablecoin trading activity and liquidity routing.

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.
`beneficiary_token_out`	`STRING`	Account address receiving the output tokens from the swap transaction. Base58-encoded Solana public key.
`mint_in`	`STRING`	Mint address of the input token being swapped in this StableSwap transaction. Base58-encoded Solana program-derived address identifying the SPL token standard.
`mint_out`	`STRING`	Token mint address of the asset being received from the swap. Base58-encoded Solana program address identifying the output token type.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`token_2022_program`	`STRING`	Program address for the Token-2022 Program when managing SPL tokens with extended features. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_token_in`	`STRING`	Account address holding the user’s input token before the swap. Base58-encoded Solana public key.
`user_token_out`	`STRING`	Account address holding the user’s output token after the swap. Base58-encoded Solana public key.
`vault`	`STRING`	Account address of the vault holding protocol-controlled assets. Base58-encoded Solana public key.
`vault_authority`	`STRING`	Account address authorized to manage vault operations and token transfers. Base58-encoded Solana public key.
`vault_program`	`STRING`	Program address managing vault operations for the swap protocol. Base58-encoded Solana public key.
`vault_token_in`	`STRING`	Account address holding the vault’s input token before the swap. Base58-encoded Solana public key.
`vault_token_out`	`STRING`	Account address holding the vault’s output token after the swap. Base58-encoded Solana public key.
`withdraw_authority`	`STRING`	Account address authorized to withdraw tokens from the vault. Base58-encoded Solana public key.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	user	vault	mint_in	mint_out	amount_in	block_slot	surrogate_key	token_program	user_token_in	vault_program	transaction_id	user_token_out	vault_token_in	block_timestamp	vault_authority	vault_token_out	instruction_type	executing_account	transaction_index	minimum_amount_out	remaining_accounts	token_2022_program	transaction_signer	withdraw_authority	beneficiary_token_out	outer_executing_account	outer_instruction_index
2y6SoneeaqpryEPsice35wHxuSvz8VjzmQ9RNLNbXJD3	2w3nJeAbZGhr8fCoMUhm7d4Q9jfrMYiSotD4ibngd5oC	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh	cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij	62087	312894634	312894634-5cVnsBUbGR6U5qeA67s23d8SdCmBybum51Lah7JFfRv8eiYzY3WuNer6AKqigRHGHsn92hHk2MBPQN21mx4HZbov-3-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	EXpwBUdt6gr1ZTQGVDhgnPV7D8kTChgsq3zqjXb6gqe6	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	5cVnsBUbGR6U5qeA67s23d8SdCmBybum51Lah7JFfRv8eiYzY3WuNer6AKqigRHGHsn92hHk2MBPQN21mx4HZbov	9LoiYPvmy7qLRY3PJqQ5HVBsKpHfzE5RSxEZ73bmAAGy	AS97rDZfv52jjKpHRcRr9rzpcevoDYUsJLRLutw73Mmb	2025-01-09T14:31:55.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	38C4ZQ3BYwoRstQTKxTQw1QfohRzJ4rS2W4PLtcnpZH9	SwapV2	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	133	1	[]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	2w3nJeAbZGhr8fCoMUhm7d4Q9jfrMYiSotD4ibngd5oC	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	HwqXnDYQ6mArWJyPo4jP8LjUgrx1c55FvNX7kWnubsdC	6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma	3
2y6SoneeaqpryEPsice35wHxuSvz8VjzmQ9RNLNbXJD3	6Ki3oNYKPo25ZM7qP5t5xwTi15KNCqRtoeRn1UfPPtga	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh	cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij	62291	312934267	312934267-5L7h3FdkbofXvHT4wmMEjHP4iexSUVepMmS7n8aNNY2Cs4E6KBQqcXFu7XCaYzwnztSXJTQ1wMoVeqd5twZVDuzf-3-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	ASgqc1jbADV9QTWaCPsryoPQsL5z9i5HC4FKdAH6AFAQ	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	5L7h3FdkbofXvHT4wmMEjHP4iexSUVepMmS7n8aNNY2Cs4E6KBQqcXFu7XCaYzwnztSXJTQ1wMoVeqd5twZVDuzf	DzpqiFaQqMgPHRFXQzGwD7J34ERdd9XG9CXJDsViv8vj	AS97rDZfv52jjKpHRcRr9rzpcevoDYUsJLRLutw73Mmb	2025-01-09T19:01:45.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	38C4ZQ3BYwoRstQTKxTQw1QfohRzJ4rS2W4PLtcnpZH9	SwapV2	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	223	1	[]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	6Ki3oNYKPo25ZM7qP5t5xwTi15KNCqRtoeRn1UfPPtga	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	HwqXnDYQ6mArWJyPo4jP8LjUgrx1c55FvNX7kWnubsdC	6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma	3
2y6SoneeaqpryEPsice35wHxuSvz8VjzmQ9RNLNbXJD3	9MmuU2eKKfaLuNuvnDm6gWNnZviB4Ftf9gP6TmWrGta7	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh	cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij	52000	312907969	312907969-2aNBLt4AU9SA4n98U2GW9GcNxCKEQmYpquxBLAtabJA122sgJMbhBGed8Z7aobAieZTUJPq1kKp4NiXLBGXFSC1z-4-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	GqjqXbAAy2AqvpCbRRuuGafqGbpr2jp1fh5nsFhPYkXR	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	2aNBLt4AU9SA4n98U2GW9GcNxCKEQmYpquxBLAtabJA122sgJMbhBGed8Z7aobAieZTUJPq1kKp4NiXLBGXFSC1z	DzpqiFaQqMgPHRFXQzGwD7J34ERdd9XG9CXJDsViv8vj	AS97rDZfv52jjKpHRcRr9rzpcevoDYUsJLRLutw73Mmb	2025-01-09T16:02:19.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	38C4ZQ3BYwoRstQTKxTQw1QfohRzJ4rS2W4PLtcnpZH9	SwapV2	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	367	1	[]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	9MmuU2eKKfaLuNuvnDm6gWNnZviB4Ftf9gP6TmWrGta7	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	HwqXnDYQ6mArWJyPo4jP8LjUgrx1c55FvNX7kWnubsdC	6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma	4

Example Query

Query with partition filter

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

Swap_instruction

Token swap execution records from decentralized exchange (DEX) programs on Solana. Contains input/output amounts, token accounts, liquidity pool references, and slippage protection parameters for atomic token exchanges.

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.
`beneficiary_token_out`	`STRING`	Account address receiving the output tokens from the swap transaction. Base58-encoded Solana public key.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_token_in`	`STRING`	Account address holding the user’s input token before the swap. Base58-encoded Solana public key.
`user_token_out`	`STRING`	Account address holding the user’s output token after the swap. Base58-encoded Solana public key.
`vault`	`STRING`	Account address of the vault holding protocol-controlled assets. Base58-encoded Solana public key.
`vault_authority`	`STRING`	Account address authorized to manage vault operations and token transfers. Base58-encoded Solana public key.
`vault_program`	`STRING`	Program address managing vault operations for the swap protocol. Base58-encoded Solana public key.
`vault_token_in`	`STRING`	Account address holding the vault’s input token before the swap. Base58-encoded Solana public key.
`vault_token_out`	`STRING`	Account address holding the vault’s output token after the swap. Base58-encoded Solana public key.
`withdraw_authority`	`STRING`	Account address authorized to withdraw tokens from the vault. Base58-encoded Solana public key.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	user	vault	amount_in	block_slot	surrogate_key	token_program	user_token_in	vault_program	transaction_id	user_token_out	vault_token_in	block_timestamp	vault_authority	vault_token_out	instruction_type	executing_account	instruction_index	transaction_index	remaining_accounts	transaction_signer	withdraw_authority	beneficiary_token_out	outer_executing_account	outer_instruction_index
3CnGAs4F4dwYbRrpmZWT4d1qCetd6TFHDh9nAFFiFZjS	9XLcx4qeRMef4S1uMTsyv5Uv8SAXpo8aE9d97NDxYRvL	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	5188595	356818956	356818956-62xA5XFwEpxn7B8CNGHh1UzXcPFatA4QtV2HArekCW1YwE5fY8dRDqScLk74UVaYVPsAVxFADdsz1qCDWsUTTCkk-2-9	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5xMbNZg63zEjBUEkUMdBnv9bzanXsSVD47tw8AxKPYWi	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	62xA5XFwEpxn7B8CNGHh1UzXcPFatA4QtV2HArekCW1YwE5fY8dRDqScLk74UVaYVPsAVxFADdsz1qCDWsUTTCkk	28CV4CWWj7oHw2E2ioS3KNGSBXc5oqnoghKERyDqYrWC	2mytUEpSW2SiVAjCJyF9pLbUhNn3Leq8eihwcBbdtJdN	2025-07-30T22:37:46.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	Swap	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	9	214	[]	9XLcx4qeRMef4S1uMTsyv5Uv8SAXpo8aE9d97NDxYRvL	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2
DLgzpha6oCe14yjM4i3kygY3QjGBTd8Bw327Wtd4JsLZ	9XLcx4qeRMef4S1uMTsyv5Uv8SAXpo8aE9d97NDxYRvL	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	6691440	356662164	356662164-4vHkn28XJ7bPdBbjLhECCsQm5vU2vBNiJVfstK8zjU36ueuFf4SS9nfhWGKbAb5cRzFLZd3yfQprcUge7HM8Xp8z-2-8	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5xMbNZg63zEjBUEkUMdBnv9bzanXsSVD47tw8AxKPYWi	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	4vHkn28XJ7bPdBbjLhECCsQm5vU2vBNiJVfstK8zjU36ueuFf4SS9nfhWGKbAb5cRzFLZd3yfQprcUge7HM8Xp8z	28CV4CWWj7oHw2E2ioS3KNGSBXc5oqnoghKERyDqYrWC	2mytUEpSW2SiVAjCJyF9pLbUhNn3Leq8eihwcBbdtJdN	2025-07-30T05:15:47.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	Swap	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	8	287	[]	9XLcx4qeRMef4S1uMTsyv5Uv8SAXpo8aE9d97NDxYRvL	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2
DLgzpha6oCe14yjM4i3kygY3QjGBTd8Bw327Wtd4JsLZ	9iwM3XPan59ffNdVfBxLRTuTBTQgGBf4cHw71i3SCKUL	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	101019452	356805025	356805025-48ULy2h8wbtTsw5QFVT2PNynUq28Fm2yCQY2nrZ1cT81CirEQfcwRJBC9THjwKxWpVqV35xnrTN1ytKaQ9mRzjMr-2-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	4zkc3qsr2avPjF627zpscGccnM6bt5oMC7SmVdMJChUs	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	48ULy2h8wbtTsw5QFVT2PNynUq28Fm2yCQY2nrZ1cT81CirEQfcwRJBC9THjwKxWpVqV35xnrTN1ytKaQ9mRzjMr	2SE75XCF98yQBtxfDxhcpGmSRJX9BTjhfaQC2HYKRLmD	2mytUEpSW2SiVAjCJyF9pLbUhNn3Leq8eihwcBbdtJdN	2025-07-30T21:05:23.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	Swap	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	0	190	[]	9iwM3XPan59ffNdVfBxLRTuTBTQgGBf4cHw71i3SCKUL	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2

Example Query

Query with partition filter

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

SwapV2_instruction

Token swap instruction records from Stabble protocol on Solana showing vault-based swaps between stablecoins and other SPL tokens. Useful for analyzing swap volumes, slippage tolerance (minimum_amount_out), and liquidity routing through Stabble’s vault system.

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.
`beneficiary_token_out`	`STRING`	Account address receiving the output tokens from the swap transaction. Base58-encoded Solana public key.
`mint_in`	`STRING`	Token mint address for the input asset being swapped. Base58-encoded Solana public key representing the SPL token being sold in the swap transaction.
`mint_out`	`STRING`	Solana mint address of the token being received in the swap. Base58-encoded 44-character string identifying the output token contract.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`token_2022_program`	`STRING`	Program address for the Token-2022 Program when managing SPL tokens with extended features. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`user_token_in`	`STRING`	Account address holding the user’s input token before the swap. Base58-encoded Solana public key.
`user_token_out`	`STRING`	Account address holding the user’s output token after the swap. Base58-encoded Solana public key.
`vault`	`STRING`	Account address of the vault holding protocol-controlled assets. Base58-encoded Solana public key.
`vault_authority`	`STRING`	Account address authorized to manage vault operations and token transfers. Base58-encoded Solana public key.
`vault_program`	`STRING`	Program address managing vault operations for the swap protocol. Base58-encoded Solana public key.
`vault_token_in`	`STRING`	Account address holding the vault’s input token before the swap. Base58-encoded Solana public key.
`vault_token_out`	`STRING`	Account address holding the vault’s output token after the swap. Base58-encoded Solana public key.
`withdraw_authority`	`STRING`	Account address authorized to withdraw tokens from the vault. Base58-encoded Solana public key.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	user	vault	mint_in	mint_out	amount_in	block_slot	surrogate_key	token_program	user_token_in	vault_program	transaction_id	user_token_out	vault_token_in	block_timestamp	vault_authority	vault_token_out	instruction_type	executing_account	instruction_index	transaction_index	minimum_amount_out	remaining_accounts	token_2022_program	transaction_signer	withdraw_authority	beneficiary_token_out
7XCChVc1woDSB8RkXvztTboG7MAVow3BAeSg1YeqbF3q	4XvaAxUa8pWnBFcVMS5KGnJmNmSNQ9U9VGZtQqEoPJBa	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	9zNQRsGLjNKwCUU5Gq5LR8beUCPzQMVMqKAi3SSZh54u		327668954	327668954-4k8jXciktd2Q6hTwHaZrVUyD17pAhwvox4UWGWP5wYBB8AHrKGrutJqSKnoYEmLVR1qFmMnLUUk85jnGmpRmxbYd-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	25tozyZCr1ZyhGNR4qXQAGJTVjGWDaY9a7Pt2xufmS7P	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	4k8jXciktd2Q6hTwHaZrVUyD17pAhwvox4UWGWP5wYBB8AHrKGrutJqSKnoYEmLVR1qFmMnLUUk85jnGmpRmxbYd	DSuVzosbjWzMB7YnZGsD5zVKHtwFKPz34i2oxoa3EtXG	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	2025-03-18T23:36:27.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	A4WxY8xHPdKw9NSEWHNMPJLtBT4DdJUeeaWM4piQeppT	SwapV2	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	5	17	994488774	[]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	4XvaAxUa8pWnBFcVMS5KGnJmNmSNQ9U9VGZtQqEoPJBa	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	DcdRkZt5wyvdvWVQxL5fBys3hSMZqpT8oE4US2B7QQs
7XCChVc1woDSB8RkXvztTboG7MAVow3BAeSg1YeqbF3q	2dzF5xP8Cjsbz535FK9QcEoFBKAbKVKJDdfcD4639j9S	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	9zNQRsGLjNKwCUU5Gq5LR8beUCPzQMVMqKAi3SSZh54u		327625361	327625361-26gPfEo55KSvLh4yrfW6nj8y76ZbvqT52AJntnrX3SiEuXkVhZCBSyuQZe6PiFB7hmsai12sCdVAPBs7vRM9fMfo-9	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3LGGhEx4NoVy8QFR26kS7jesi4Adr3FQ8nNL24oiLohu	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	26gPfEo55KSvLh4yrfW6nj8y76ZbvqT52AJntnrX3SiEuXkVhZCBSyuQZe6PiFB7hmsai12sCdVAPBs7vRM9fMfo	DSUfYrnGV6LwcSwo9KWLMzRqhBzG6mWRMAoPgKcwbjc7	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	2025-03-18T18:46:16.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	A4WxY8xHPdKw9NSEWHNMPJLtBT4DdJUeeaWM4piQeppT	SwapV2	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	9	30	6156982	[]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	2dzF5xP8Cjsbz535FK9QcEoFBKAbKVKJDdfcD4639j9S	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	DcdRkZt5wyvdvWVQxL5fBys3hSMZqpT8oE4US2B7QQs
7XCChVc1woDSB8RkXvztTboG7MAVow3BAeSg1YeqbF3q	BpJ8o4MjbdXpYHK74hBon8Jd8rSDYvWaE6rqiEpvTmjw	stab1io8dHvK26KoHmTwwHyYmHRbUWbyEJx6CdrGabC	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	9zNQRsGLjNKwCUU5Gq5LR8beUCPzQMVMqKAi3SSZh54u	24281660	327659604	327659604-3MsmpRe9UUqWF6A5Htj32JHDqbZm6gFpfp1s8Gaa9AGUUB3P9kuXjrXornrouxTXTK7kgE1tuM2ooc11J1ChfiR4-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	7icUFYHn5mEB4zwuBBSapehdprem6byL9pYdjw2j3UUc	vo1tWgqZMjG61Z2T9qUaMYKqZ75CYzMuaZ2LZP1n7HV	3MsmpRe9UUqWF6A5Htj32JHDqbZm6gFpfp1s8Gaa9AGUUB3P9kuXjrXornrouxTXTK7kgE1tuM2ooc11J1ChfiR4	xMhapTSgsRXrGfrzP2kagzUCZzowfTsrMe6bYEMxcqy	AioJRQXvcDLRhHMd6DAkTbbMpgVx63qSGQYmRBS2vHYA	2025-03-18T22:34:19.000Z	7imnGYfCovXjMWKdbQvETFVMe72MQDX4S5zW4GFxMJME	A4WxY8xHPdKw9NSEWHNMPJLtBT4DdJUeeaWM4piQeppT	SwapV2	swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZ	4	26	0	[]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	BpJ8o4MjbdXpYHK74hBon8Jd8rSDYvWaE6rqiEpvTmjw	8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm	DcdRkZt5wyvdvWVQxL5fBys3hSMZqpT8oE4US2B7QQs

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

StableSwap_Swap_instruction

StableSwap_SwapV2_instruction

Swap_instruction

SwapV2_instruction

​Tables

​StableSwap_Swap_instruction

​StableSwap_SwapV2_instruction

​Swap_instruction

​SwapV2_instruction

Tables

StableSwap_Swap_instruction

StableSwap_SwapV2_instruction

Swap_instruction

SwapV2_instruction