> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# stabble_v1_solana
> Tables in tt-contracts.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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | -------------------------------------------- | ------------------------------------------- | ---------- | ----------- | ---------------------------------------------------------------------------------------------------- | ------------------------------------------- | -------------------------------------------- | ------------------------------------------- | ---------------------------------------------------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ------------------------ | -------------------------------------------- | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------- | ------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | 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 | 0 | 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 | 0 | 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 | 0 | 367 | 1 | \[] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | 9MmuU2eKKfaLuNuvnDm6gWNnZviB4Ftf9gP6TmWrGta7 | 8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm | HwqXnDYQ6mArWJyPo4jP8LjUgrx1c55FvNX7kWnubsdC | 6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma | 4 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | 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 | 0 | \[] | 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 | 0 | \[] | 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 | 0 | \[] | 9iwM3XPan59ffNdVfBxLRTuTBTQgGBf4cHw71i3SCKUL | 8BSWYgAczR36C7ukr32v7uTepoRhYJYxAVnpBtYniZTm | ArLSJrSstZ3kjeZDyMAgjfjad1qdRZHHYaCQTQeAcTpa | JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4 | 2 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | -------------------------------------------- | ------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ---------- | ----------- | ---------------------------------------------------------------------------------------------------- | ------------------------------------------- | -------------------------------------------- | ------------------------------------------- | ---------------------------------------------------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ------------------------ | -------------------------------------------- | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | ------------------ | -------------------- | ------------------- | ------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ------------------------------------------- | ------------------------- | ------------------------- |
| 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 | | |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stabble_v1_solana.SwapV2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***