Skip to main content

​
Tables

​
RaydiumV5_increaseLiquidityV2_instruction

Raydium V5 concentrated liquidity position increase instructions on Solana. Captures liquidity additions to existing positions with token amounts, tick ranges, and NFT position identifiers for analyzing liquidity provider behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
transaction_successBOOLBoolean flag indicating whether the transaction executed successfully and was committed to the blockchain.
instruction_program_addressSTRINGAddress of the Solana program that executed the instruction. Base58-encoded public key.
inner_instruction_indexINT64Position of the instruction within nested cross-program invocations. Zero-indexed integer representing the sequential order when one program calls another program’s instructions.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
nameSTRINGName of the instruction or event type being executed. Identifies the specific operation performed within the smart contract or program.
in_liquidityBIGNUMERICTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_amount0MaxBIGNUMERICMaximum amount of token0 the user authorizes to deposit into the liquidity pool. Acts as a slippage protection cap; actual deposited amount may be less.
in_amount1MaxBIGNUMERICMaximum amount of token1 the user authorizes to deposit when adding liquidity to the pool. Value represents the token amount in smallest unit (lamports/wei equivalent).
in_baseFlagSTRINGFlag indicating which token is treated as the base asset in the liquidity calculation. Null in all sample rows suggests this parameter may be optional or unused in v2 instructions.
in_nftOwnerSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Solana address of the NFT owner who is increasing liquidity in the Raydium pool position. This account must sign the transaction and typically pays fees for the operation.
in_nftAccountSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Address of the NFT representing ownership of this concentrated liquidity position in the Raydium V5 pool. This NFT account serves as the position identifier and proof of ownership for the user’s liquidity stake.
in_poolStateSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Raydium pool account holding the concentrated liquidity market state being modified. This RECORD type contains the pool’s Solana address and account metadata flags.
in_protocolPositionSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Raydium protocol-owned position account managing the protocol’s share of liquidity in this concentrated liquidity pool. This account tracks the protocol’s portion of fees and liquidity separate from user positions.
in_personalPositionSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Account address of the user’s individual liquidity position NFT in Raydium’s concentrated liquidity pools. This position tracks the liquidity provider’s specific range, ownership, and earned fees.
in_tickArrayLowerSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Account address of the lower tick array boundary for the concentrated liquidity position. Represents the price range floor where liquidity is actively deployed.
in_tickArrayUpperSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Account address for the upper tick array boundary of this concentrated liquidity position. Represents the upper price range limit for the liquidity being added.
in_tokenAccount0STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token account owned by the user holding the first token in the liquidity pair before the increase operation. This account’s balance will be debited by up to in_amount0Max during the transaction.
in_tokenAccount1STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token account holding the second token asset in the pair that the user is depositing from to increase their liquidity position. Writable account that must match the pool’s vault1 token mint type.
in_tokenVault0STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token vault account holding the pool’s reserves for the first token in the pair. This account is controlled by the Raydium protocol and receives deposits when liquidity is added.
in_tokenVault1STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token vault account holding the pool’s reserves of the second token in the pair. Updated during liquidity additions to reflect new token deposits.
in_tokenProgramSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>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_tokenProgram2022STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token-2022 program account used for SPL token operations if either vault token implements the Token-2022 standard. Null when both tokens use the legacy SPL Token program.
in_vault0MintSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token mint address for the first asset in the concentrated liquidity pair. Typically SOL (wrapped) or USDC based on sample values.
in_vault1MintSTRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>Token mint address for the second asset in the liquidity pool (typically USDC or another quote token). This account specifies the SPL token standard being used, either Token Program or Token-2022.
namein_baseFlagin_nftOwnerblock_heightin_liquidityin_poolStatein_amount0Maxin_amount1Maxin_nftAccountin_vault0Mintin_vault1Mintsurrogate_keyin_tokenVault0in_tokenVault1transaction_idblock_timestampin_tokenProgramin_tokenAccount0in_tokenAccount1in_tickArrayLowerin_tickArrayUpperinstruction_indextransaction_indexin_personalPositionin_protocolPositionin_tokenProgram2022transaction_successinner_instruction_indexinstruction_program_address
increaseLiquidityV2{“is_alt”:false,“address”:“GTHy95LNMbGFV63HtdxQFJoMdM4FATUeC4bYctC8R68m”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}30509864113479671{“is_alt”:true,“address”:“8sLbNZoA1cfnvMJLPfp98ZLAnFSYCFApfJKMbiXNLwxj”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}10103682233546{“is_alt”:false,“address”:“Dp9zygDWPtZeR81gMjkTMQXtKFpeYzNmeidrgZkWDM8U”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:true,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:true,“address”:“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}9k9cH9pVKDMzvGisSjteVPApCXYGSeejp64ypKRFZNKp-61WFTa2VANtZVSaGrR1wN4dHJuxGNfpKWW3jwoyCMASx7FRbDCzxMabg4yh7QXzTGdvc5FuZUgQ33onzEQSCDhm6-4{“is_alt”:true,“address”:“6P4tvbzRY6Bh3MiWDHuLqyHywovsRwRpfskPvyeSoHsz”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:true,“address”:“6mK4Pxs6GhwnessH7CvPivqDYauiHZmAdbEFDpXFk9zt”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}61WFTa2VANtZVSaGrR1wN4dHJuxGNfpKWW3jwoyCMASx7FRbDCzxMabg4yh7QXzTGdvc5FuZUgQ33onzEQSCDhm62025-03-15T03:45:43.000Z{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:false,“address”:“3S6QiPEsMFuU8eQzENMquMyiXqeFQBQMBgw7GEcumNt3”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“9SHoLuQGm6Sp8vmCKM2yqyV2BZ9Du8eo9U5wi8uwwzCw”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“122jcyTjivng2AZhANCqXfQnbQbRdBqYnDa3P66zcGko”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“4iy9eFvvczwJApnuJGBBLnL9FUMm2SLBucJW3sURU2nX”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}41204{“is_alt”:false,“address”:“2KcF3MBGLJanHJ74r2fc9FUNzuhCVbskZeEzENiSoG2f”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“6HaRnqNrc5eL9vBTyFYBtGmTH4BKTM214iWRH2MuECUP”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:true,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}trueCAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK
increaseLiquidityV2{“is_alt”:false,“address”:“6dTZM2HSZagVX7hzqedyCmQSPHDKDzJm7794LCTPLCgW”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}30527940121819035{“is_alt”:true,“address”:“2AXXcN6oN9bBT5owwmTH53C7QHUXvhLeu718Kqt8rvY2”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}37210692500000{“is_alt”:false,“address”:“HMNgpixWCiPzqBdUsPe9ujEyd24ikC9KEj8CYfqnmuVa”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:true,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:true,“address”:“4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}3D3SLbE6737ELDELgRAFpZj7SQWCdwk6V4AzKZFPvdEn-4cXJBdAUYLMTqVjSV7U94Q2V2j4kSBGPRSD54JsQMnbvmfhtYTwxewqvp84HuckM7ZZsFXcqZe9LsDkHsXyg67c-4{“is_alt”:true,“address”:“9Jgp8NpqEDFd5d3RQPfuRY7gMgRFByTNFmi68Ph1yvVb”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:true,“address”:“Be1CFyoPAr8aBGxpvCPD2LD21hdz2vjYNq8EcypnmgGD”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}4cXJBdAUYLMTqVjSV7U94Q2V2j4kSBGPRSD54JsQMnbvmfhtYTwxewqvp84HuckM7ZZsFXcqZe9LsDkHsXyg67c2025-03-15T23:47:51.000Z{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:false,“address”:“DepnpHE2uZi5EYDMa5fS3pN1R5Rs9rFRFLGMKdfXBigt”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“ALx7xAnyZNMv9r4Vs6E72c4Z35uFGL87YskQimUrN2Qp”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“24gpD6mrt8u5ewNhQKM5WEfVddg8MjCN6PHo2NeRPDUR”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“77M4P36sHsHFLkt45JYu4atZ2uhPrivnKqPeT191dLPJ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}483{“is_alt”:false,“address”:“5ufZ9oJbWEQDYG5iK6TQtDYwLPx5fTGNqgZHhtqyy7u1”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“EmcFQ7LZGT2wedQ9GyX89UHQjmJaXQbQJZoTfxESpYMt”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:true,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}trueCAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK
increaseLiquidityV2{“is_alt”:false,“address”:“6dTZM2HSZagVX7hzqedyCmQSPHDKDzJm7794LCTPLCgW”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}30509553621550639{“is_alt”:true,“address”:“2AXXcN6oN9bBT5owwmTH53C7QHUXvhLeu718Kqt8rvY2”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}32831732500000{“is_alt”:false,“address”:“HMNgpixWCiPzqBdUsPe9ujEyd24ikC9KEj8CYfqnmuVa”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:true,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:true,“address”:“4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}CbdLdfyQhQFeEuNJzkQw1kXbVY6VvScvqXVrTbquJqZq-HiAVHgtZtjVrS8qwr5Whm3AYUA4kxP6ZRJaPFZEucBX2UzrBEcET7z47KEjKp7dpC1c5Dx9uEXtixu13wN8czRJ-4{“is_alt”:true,“address”:“9Jgp8NpqEDFd5d3RQPfuRY7gMgRFByTNFmi68Ph1yvVb”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:true,“address”:“Be1CFyoPAr8aBGxpvCPD2LD21hdz2vjYNq8EcypnmgGD”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}HiAVHgtZtjVrS8qwr5Whm3AYUA4kxP6ZRJaPFZEucBX2UzrBEcET7z47KEjKp7dpC1c5Dx9uEXtixu13wN8czRJ2025-03-15T03:25:07.000Z{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}{“is_alt”:false,“address”:“6UuZTCWviXKGsR9knGocuzGrfAHZbrxxsSckhcZiYYvG”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“ALx7xAnyZNMv9r4Vs6E72c4Z35uFGL87YskQimUrN2Qp”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“24gpD6mrt8u5ewNhQKM5WEfVddg8MjCN6PHo2NeRPDUR”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“77M4P36sHsHFLkt45JYu4atZ2uhPrivnKqPeT191dLPJ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}4200{“is_alt”:false,“address”:“5ufZ9oJbWEQDYG5iK6TQtDYwLPx5fTGNqgZHhtqyy7u1”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:false,“address”:“EmcFQ7LZGT2wedQ9GyX89UHQjmJaXQbQJZoTfxESpYMt”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}{“is_alt”:true,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}trueCAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK
Query with partition filter
SELECT *
FROM `tt-contracts.raydium_v5_solana.RaydiumV5_increaseLiquidityV2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
RaydiumV5_swap_instruction

Swap instruction records from Raydium V5 concentrated liquidity pools (CLMM) on Solana. Captures token exchanges with amounts, price limits, vault addresses, and tick array references for analyzing concentrated liquidity DEX trading activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position 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_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
amm_configSTRINGAccount address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
input_vaultSTRINGAccount address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
output_vaultSTRINGAccount address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
observation_stateSTRINGAccount address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
pool_stateSTRINGAccount address representing the liquidity pool state. Base58-encoded Solana public key.
tick_arraySTRINGAccount address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
other_amount_thresholdBIGNUMERICMinimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
sqrt_price_limit_x64BIGNUMERICPrice limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
is_base_inputBOOLBoolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramountamm_configblock_slotpool_statetick_arrayinput_vaultoutput_vaultis_base_inputsurrogate_keytoken_programtransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indexobservation_statetransaction_indexremaining_accountstransaction_signerinput_token_accountoutput_token_accountsqrt_price_limit_x64other_amount_thresholdouter_executing_accountouter_instruction_index
6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB20760849785A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x2791993463dKVs61jk68gtHqEzNR9nW8GzKV9SHm6wdc7R65YTaKS2Gy3ppm894vDq1TkhiTJtTPWpZVLJbFDUkBYC3DHMTzh12GCV8i8gma79ABVKyBJ27Fw1wyCSGgfybYEmsve2k4i8bAGcJ926B4aPeFsx3YbkfpXVSdBdc6s79bWGh89sRdntrue279199346-49i5m66DfCrj9QNDfCF2ZcPwyFntweAtPHqMAX9j1Wxr4J5Azv9EMmjhhpES6pRy7dz1q8T1f6FfEzPdH3jk5uoy-1-1TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA49i5m66DfCrj9QNDfCF2ZcPwyFntweAtPHqMAX9j1Wxr4J5Azv9EMmjhhpES6pRy7dz1q8T1f6FfEzPdH3jk5uoy2024-07-23T11:29:39.000ZSwapCAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK15jp8XAQ3KvidnABxgNLmvWCThLBugYGC6QRHbCCgrveW463[“2rCmpPiLRdZeTrXiPvDXatXHE6zAuG675dXxP89SqSG4”,“6RpLDTz93ACBjQKcDDzg1JQ7RnRd1FSLCABmAVLXLXn7”]DCAK36VfExkPdAkYUQg6ewgxyinvcEyPLyHjRbmveKFw2qfNWsZ1anq3KbWMZgRREwsN8qNTHzDq9ukVM5GYgk8q59v2cSbCsnyaWymLnsq6TWzE6cEN5KJYNTBNrcP4smRH00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV41
eat1947zx4FuVm1crrW35TdHq2ZnngiW84bKnrKCdxT23513621349A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x2792433273dKVs61jk68gtHqEzNR9nW8GzKV9SHm6wdc7R65YTaKS2Gy3ppm894vDq1TkhiTJtTPWpZVLJbFDUkBYC3DHMTzh12GCV8i8gma79ABVKyBJ27Fw1wyCSGgfybYEmsve2k4i8bAGcJ926B4aPeFsx3YbkfpXVSdBdc6s79bWGh89sRdntrue279243327-3cgnnFEDb1yAYpVrqugowY1aMiX6zvguhF8QZYysQnHiuyoTer4HaTdvJeaRnJdkg9tuMSGJnLCtuagBhUekYHLD-10-4TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA3cgnnFEDb1yAYpVrqugowY1aMiX6zvguhF8QZYysQnHiuyoTer4HaTdvJeaRnJdkg9tuMSGJnLCtuagBhUekYHLD2024-07-23T16:53:32.000ZSwapCAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK45jp8XAQ3KvidnABxgNLmvWCThLBugYGC6QRHbCCgrveW201[“2rCmpPiLRdZeTrXiPvDXatXHE6zAuG675dXxP89SqSG4”,“6RpLDTz93ACBjQKcDDzg1JQ7RnRd1FSLCABmAVLXLXn7”]eat1947zx4FuVm1crrW35TdHq2ZnngiW84bKnrKCdxT31BPBXWncj2PUi4kSnBCUs3j9atwGJ3tcWe9ubVdN9ET82qzDhNVNm9Z7U3YvA8WeudChG2npT8fHPEEqRbNSRFJ00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV410
YcjUULpoURFD8TVwDZC8Wsk4RbAY5L62TH3rJoaFFTk9816215468A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x2792741203dKVs61jk68gtHqEzNR9nW8GzKV9SHm6wdc7R65YTaKS2Gy3ppm894vDq1TkhiTJtTPWpZVLJbFDUkBYC3DHMTzh12GCV8i8gma79ABVKyBJ27Fw1wyCSGgfybYEmsve2k4i8bAGcJ926B4aPeFsx3YbkfpXVSdBdc6s79bWGh89sRdntrue279274120-5PG9JAzWuymQB2AfEN4N9k7L3SuT2eL3WVQaiKGpL9fMowdqfkGHqs8pLmFbp2MCsTbcsuf5adt6NKQg1wc5a3zN-3-3TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5PG9JAzWuymQB2AfEN4N9k7L3SuT2eL3WVQaiKGpL9fMowdqfkGHqs8pLmFbp2MCsTbcsuf5adt6NKQg1wc5a3zN2024-07-23T20:43:01.000ZSwapCAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK35jp8XAQ3KvidnABxgNLmvWCThLBugYGC6QRHbCCgrveW234[“6RpLDTz93ACBjQKcDDzg1JQ7RnRd1FSLCABmAVLXLXn7”]YcjUULpoURFD8TVwDZC8Wsk4RbAY5L62TH3rJoaFFTk3AQrryttxqFtw5qxqBsvW13qDD2dgyfP9LAp4Vocu3eEBkh6G4TZ9FXRHqEXcjFS9yNPg5cERRBPRisqw2cYsqiB00AfmiiWVWYACfVCUuHeAmVN15ATBHDyfKvwowmQKXt1kg3
Query with partition filter
SELECT *
FROM `tt-contracts.raydium_v5_solana.RaydiumV5_swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
RaydiumV5_swapV2_instruction

Token swap instruction records from Raydium V5 automated market maker (AMM) on Solana. Captures swap parameters including input/output amounts, vault addresses, price limits, and pool state for analyzing decentralized exchange (DEX) trading activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position 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_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
amm_configSTRINGAccount address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
input_vaultSTRINGAccount address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
output_vaultSTRINGAccount address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
input_vault_mintSTRINGToken mint address for the input vault. Base58-encoded Solana public key.
output_vault_mintSTRINGToken mint address for the output vault. Base58-encoded Solana public key.
memo_programSTRINGProgram address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
observation_stateSTRINGAccount address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
pool_stateSTRINGAccount address representing the liquidity pool state. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
token_program_2022STRINGProgram address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
other_amount_thresholdBIGNUMERICMinimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
sqrt_price_limit_x64BIGNUMERICPrice limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
is_base_inputBOOLBoolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramountamm_configblock_slotpool_stateinput_vaultmemo_programoutput_vaultis_base_inputsurrogate_keytoken_programtransaction_idblock_timestampinput_vault_mintinstruction_typeexecuting_accountinstruction_indexobservation_stateoutput_vault_minttransaction_indexremaining_accountstoken_program_2022transaction_signerinput_token_accountoutput_token_accountsqrt_price_limit_x64other_amount_thresholdouter_executing_accountouter_instruction_index
EyS8aVDUR2RJ1PZusBjgCprzZHZgW6v6ki1Qw8fJF1Bv10000000A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x275346241HbuBYFbQKSeyE17HwHWyLnLR8sFE2scgrGAJyFFCsZCeANjYVMN8ydiMfXz9QVYNMgujrywhjUk23uAMLLY1k2D9MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr2DM76h7KNYhdFCsHXeefqE3c5y5x8Zk4SxCcbiUR1LRktrue275346241-12NFoCMcyBbPSaYekFtncavugoLxFPsq7W4X7RC4NWBC62kKxVy3LFoAUkLaLhXb282JCoe27fjbYLX7MF5Jbeo-1-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA12NFoCMcyBbPSaYekFtncavugoLxFPsq7W4X7RC4NWBC62kKxVy3LFoAUkLaLhXb282JCoe27fjbYLX7MF5Jbeo2024-07-03T00:28:50.000ZSo11111111111111111111111111111111111111112SwapV2CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK0BCK5R4Vo46DevaLk2gQgxYUwHo3QG6wyuXhGLoyUapxhsKeqdUAKN7o8Kj9ebj3oyLoQJHPDhT5yDoHeevkUNgr310[“9YRNTE1eVwPry9czoFXkDqowMin61aXUov5aEpR94nux”,“9BtZPEi4AsrzcNBgU5RETZXykzRn9r4mkzZwVBMa7Dyv”,“FSCGDwe4tm8Tx2JPMAgXhtVrdGfAzT4bN4wRaEBzJEow”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbEyS8aVDUR2RJ1PZusBjgCprzZHZgW6v6ki1Qw8fJF1BvCMTfRQdBwL9yWTLEk2udqbnAJC5ixe9Uk4psaffjraH1Ft56o3n2naHtHTvtMrDsZartBH1t3EqiTXWLz9vBZ1Kc8641173451877957700320routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS1
6uyhopMH6dasokN2sUqFRAirEWPu1cnrvJfjaWvpnVFg155382803A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x275351119HbuBYFbQKSeyE17HwHWyLnLR8sFE2scgrGAJyFFCsZCeANjYVMN8ydiMfXz9QVYNMgujrywhjUk23uAMLLY1k2D9MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr2DM76h7KNYhdFCsHXeefqE3c5y5x8Zk4SxCcbiUR1LRktrue275351119-5xHvrcmK2mpXzejgvo9mLSnuntkw8d68oShyJXnZMFkCwm6dKEFXCBkx5cUckPQA1k2syvp4aBweXV31CvD2GFVH-1-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5xHvrcmK2mpXzejgvo9mLSnuntkw8d68oShyJXnZMFkCwm6dKEFXCBkx5cUckPQA1k2syvp4aBweXV31CvD2GFVH2024-07-03T01:06:15.000ZSo11111111111111111111111111111111111111112SwapV2CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK0BCK5R4Vo46DevaLk2gQgxYUwHo3QG6wyuXhGLoyUapxhsKeqdUAKN7o8Kj9ebj3oyLoQJHPDhT5yDoHeevkUNgr135[“9YRNTE1eVwPry9czoFXkDqowMin61aXUov5aEpR94nux”,“9BtZPEi4AsrzcNBgU5RETZXykzRn9r4mkzZwVBMa7Dyv”,“FSCGDwe4tm8Tx2JPMAgXhtVrdGfAzT4bN4wRaEBzJEow”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb6uyhopMH6dasokN2sUqFRAirEWPu1cnrvJfjaWvpnVFgCd8sYS82p9u5PHt3r9Mj6ZEXEy6SsJfSjP8ypYMYc95W9FEJFc4pCWGcLMeZkshDbBWHz8WhEeeTLWS2bkmQVs9Z3280825092299819670900routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS1
B6MwGCYXfyVaMVnUbj1HduaYXaVFvBSr8WAARQmVLcR81000000A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x275348761HbuBYFbQKSeyE17HwHWyLnLR8sFE2scgrGAJyFFCsZCeANjYVMN8ydiMfXz9QVYNMgujrywhjUk23uAMLLY1k2D9MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr2DM76h7KNYhdFCsHXeefqE3c5y5x8Zk4SxCcbiUR1LRktrue275348761-5puRhGwYuZswjanHpnnrSK2ud2iN8ZSNzXeERw3hwGuYmTXpCEFGphBVzH317os26g5tXSoY7mUGB9D9Y2PbKtsU-1-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5puRhGwYuZswjanHpnnrSK2ud2iN8ZSNzXeERw3hwGuYmTXpCEFGphBVzH317os26g5tXSoY7mUGB9D9Y2PbKtsU2024-07-03T00:48:18.000ZSo11111111111111111111111111111111111111112SwapV2CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK0BCK5R4Vo46DevaLk2gQgxYUwHo3QG6wyuXhGLoyUapxhsKeqdUAKN7o8Kj9ebj3oyLoQJHPDhT5yDoHeevkUNgr130[“9YRNTE1eVwPry9czoFXkDqowMin61aXUov5aEpR94nux”,“9BtZPEi4AsrzcNBgU5RETZXykzRn9r4mkzZwVBMa7Dyv”,“FSCGDwe4tm8Tx2JPMAgXhtVrdGfAzT4bN4wRaEBzJEow”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbB6MwGCYXfyVaMVnUbj1HduaYXaVFvBSr8WAARQmVLcR85YLJZuat1be4Pa1ZjkzUfaqdbUeUcSzexXTcVtQ5ENdEkKyxK9vxYc5cS9MxRhFcJMv4KN66eZ9P6cBJkREV9WS8542137098859722642240routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS1
Query with partition filter
SELECT *
FROM `tt-contracts.raydium_v5_solana.RaydiumV5_swapV2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100