raydium_v5_solana

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_height`	`INT64`	Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`transaction_success`	`BOOL`	Boolean flag indicating whether the transaction executed successfully and was committed to the blockchain.
`instruction_program_address`	`STRING`	Address of the Solana program that executed the instruction. Base58-encoded public key.
`inner_instruction_index`	`INT64`	Position of the instruction within nested cross-program invocations. Zero-indexed integer representing the sequential order when one program calls another program’s instructions.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`name`	`STRING`	Name of the instruction or event type being executed. Identifies the specific operation performed within the smart contract or program.
`in_liquidity`	`BIGNUMERIC`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_amount0Max`	`BIGNUMERIC`	Maximum 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_amount1Max`	`BIGNUMERIC`	Maximum 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_baseFlag`	`STRING`	Flag 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_nftOwner`	`STRUCT<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_nftAccount`	`STRUCT<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_poolState`	`STRUCT<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_protocolPosition`	`STRUCT<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_personalPosition`	`STRUCT<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_tickArrayLower`	`STRUCT<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_tickArrayUpper`	`STRUCT<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_tokenAccount0`	`STRUCT<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_tokenAccount1`	`STRUCT<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_tokenVault0`	`STRUCT<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_tokenVault1`	`STRUCT<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_tokenProgram`	`STRUCT<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_tokenProgram2022`	`STRUCT<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_vault0Mint`	`STRUCT<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_vault1Mint`	`STRUCT<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.

Sample Data

name	in_nftOwner	block_height	in_liquidity	in_poolState	in_amount0Max	in_amount1Max	in_nftAccount	in_vault0Mint	in_vault1Mint	surrogate_key	in_tokenVault0	in_tokenVault1	transaction_id	block_timestamp	in_tokenProgram	in_tokenAccount0	in_tokenAccount1	in_tickArrayLower	in_tickArrayUpper	instruction_index	transaction_index	in_personalPosition	in_protocolPosition	in_tokenProgram2022	transaction_success	instruction_program_address
increaseLiquidityV2	{“is_alt”:false,“address”:“GTHy95LNMbGFV63HtdxQFJoMdM4FATUeC4bYctC8R68m”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	305098641	13479671	{“is_alt”:true,“address”:“8sLbNZoA1cfnvMJLPfp98ZLAnFSYCFApfJKMbiXNLwxj”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	10103682	233546	{“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}	61WFTa2VANtZVSaGrR1wN4dHJuxGNfpKWW3jwoyCMASx7FRbDCzxMabg4yh7QXzTGdvc5FuZUgQ33onzEQSCDhm6	2025-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}	4	1204	{“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}	true	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK
increaseLiquidityV2	{“is_alt”:false,“address”:“6dTZM2HSZagVX7hzqedyCmQSPHDKDzJm7794LCTPLCgW”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	305279401	21819035	{“is_alt”:true,“address”:“2AXXcN6oN9bBT5owwmTH53C7QHUXvhLeu718Kqt8rvY2”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	3721069	2500000	{“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}	4cXJBdAUYLMTqVjSV7U94Q2V2j4kSBGPRSD54JsQMnbvmfhtYTwxewqvp84HuckM7ZZsFXcqZe9LsDkHsXyg67c	2025-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}	4	83	{“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}	true	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK
increaseLiquidityV2	{“is_alt”:false,“address”:“6dTZM2HSZagVX7hzqedyCmQSPHDKDzJm7794LCTPLCgW”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	305095536	21550639	{“is_alt”:true,“address”:“2AXXcN6oN9bBT5owwmTH53C7QHUXvhLeu718Kqt8rvY2”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	3283173	2500000	{“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}	HiAVHgtZtjVrS8qwr5Whm3AYUA4kxP6ZRJaPFZEucBX2UzrBEcET7z47KEjKp7dpC1c5Dx9uEXtixu13wN8czRJ	2025-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}	4	200	{“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}	true	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK

Example Query

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.

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.
`amm_config`	`STRING`	Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`output_token_account`	`STRING`	Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
`input_vault`	`STRING`	Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
`output_vault`	`STRING`	Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
`observation_state`	`STRING`	Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`tick_array`	`STRING`	Account address storing tick data for concentrated liquidity price ranges in the AMM pool. 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.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`other_amount_threshold`	`BIGNUMERIC`	Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
`sqrt_price_limit_x64`	`BIGNUMERIC`	Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
`is_base_input`	`BOOL`	Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
`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

payer	amount	amm_config	block_slot	pool_state	tick_array	input_vault	output_vault	is_base_input	surrogate_key	token_program	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	observation_state	transaction_index	remaining_accounts	transaction_signer	input_token_account	output_token_account	outer_executing_account	outer_instruction_index
6U91aKa8pmMxkJwBCfPTmUEfZi6dHe7DcFq2ALvB2tbB	20760849785	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	279199346	3dKVs61jk68gtHqEzNR9nW8GzKV9SHm6wdc7R65YTaKS	2Gy3ppm894vDq1TkhiTJtTPWpZVLJbFDUkBYC3DHMTzh	12GCV8i8gma79ABVKyBJ27Fw1wyCSGgfybYEmsve2k4i	8bAGcJ926B4aPeFsx3YbkfpXVSdBdc6s79bWGh89sRdn	true	279199346-49i5m66DfCrj9QNDfCF2ZcPwyFntweAtPHqMAX9j1Wxr4J5Azv9EMmjhhpES6pRy7dz1q8T1f6FfEzPdH3jk5uoy-1-1	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	49i5m66DfCrj9QNDfCF2ZcPwyFntweAtPHqMAX9j1Wxr4J5Azv9EMmjhhpES6pRy7dz1q8T1f6FfEzPdH3jk5uoy	2024-07-23T11:29:39.000Z	Swap	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	1	5jp8XAQ3KvidnABxgNLmvWCThLBugYGC6QRHbCCgrveW	463	[“2rCmpPiLRdZeTrXiPvDXatXHE6zAuG675dXxP89SqSG4”,“6RpLDTz93ACBjQKcDDzg1JQ7RnRd1FSLCABmAVLXLXn7”]	DCAK36VfExkPdAkYUQg6ewgxyinvcEyPLyHjRbmveKFw	2qfNWsZ1anq3KbWMZgRREwsN8qNTHzDq9ukVM5GYgk8q	59v2cSbCsnyaWymLnsq6TWzE6cEN5KJYNTBNrcP4smRH	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	1
eat1947zx4FuVm1crrW35TdHq2ZnngiW84bKnrKCdxT	23513621349	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	279243327	3dKVs61jk68gtHqEzNR9nW8GzKV9SHm6wdc7R65YTaKS	2Gy3ppm894vDq1TkhiTJtTPWpZVLJbFDUkBYC3DHMTzh	12GCV8i8gma79ABVKyBJ27Fw1wyCSGgfybYEmsve2k4i	8bAGcJ926B4aPeFsx3YbkfpXVSdBdc6s79bWGh89sRdn	true	279243327-3cgnnFEDb1yAYpVrqugowY1aMiX6zvguhF8QZYysQnHiuyoTer4HaTdvJeaRnJdkg9tuMSGJnLCtuagBhUekYHLD-10-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3cgnnFEDb1yAYpVrqugowY1aMiX6zvguhF8QZYysQnHiuyoTer4HaTdvJeaRnJdkg9tuMSGJnLCtuagBhUekYHLD	2024-07-23T16:53:32.000Z	Swap	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	4	5jp8XAQ3KvidnABxgNLmvWCThLBugYGC6QRHbCCgrveW	201	[“2rCmpPiLRdZeTrXiPvDXatXHE6zAuG675dXxP89SqSG4”,“6RpLDTz93ACBjQKcDDzg1JQ7RnRd1FSLCABmAVLXLXn7”]	eat1947zx4FuVm1crrW35TdHq2ZnngiW84bKnrKCdxT	31BPBXWncj2PUi4kSnBCUs3j9atwGJ3tcWe9ubVdN9ET	82qzDhNVNm9Z7U3YvA8WeudChG2npT8fHPEEqRbNSRFJ	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	10
YcjUULpoURFD8TVwDZC8Wsk4RbAY5L62TH3rJoaFFTk	9816215468	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	279274120	3dKVs61jk68gtHqEzNR9nW8GzKV9SHm6wdc7R65YTaKS	2Gy3ppm894vDq1TkhiTJtTPWpZVLJbFDUkBYC3DHMTzh	12GCV8i8gma79ABVKyBJ27Fw1wyCSGgfybYEmsve2k4i	8bAGcJ926B4aPeFsx3YbkfpXVSdBdc6s79bWGh89sRdn	true	279274120-5PG9JAzWuymQB2AfEN4N9k7L3SuT2eL3WVQaiKGpL9fMowdqfkGHqs8pLmFbp2MCsTbcsuf5adt6NKQg1wc5a3zN-3-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5PG9JAzWuymQB2AfEN4N9k7L3SuT2eL3WVQaiKGpL9fMowdqfkGHqs8pLmFbp2MCsTbcsuf5adt6NKQg1wc5a3zN	2024-07-23T20:43:01.000Z	Swap	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	3	5jp8XAQ3KvidnABxgNLmvWCThLBugYGC6QRHbCCgrveW	234	[“6RpLDTz93ACBjQKcDDzg1JQ7RnRd1FSLCABmAVLXLXn7”]	YcjUULpoURFD8TVwDZC8Wsk4RbAY5L62TH3rJoaFFTk	3AQrryttxqFtw5qxqBsvW13qDD2dgyfP9LAp4Vocu3eE	Bkh6G4TZ9FXRHqEXcjFS9yNPg5cERRBPRisqw2cYsqiB	AfmiiWVWYACfVCUuHeAmVN15ATBHDyfKvwowmQKXt1kg	3

Example Query

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.

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.
`amm_config`	`STRING`	Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`output_token_account`	`STRING`	Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
`input_vault`	`STRING`	Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
`output_vault`	`STRING`	Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
`input_vault_mint`	`STRING`	Token mint address for the input vault. Base58-encoded Solana public key.
`output_vault_mint`	`STRING`	Token mint address for the output vault. Base58-encoded Solana public key.
`memo_program`	`STRING`	Program address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
`observation_state`	`STRING`	Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. 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.
`token_program_2022`	`STRING`	Program address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`other_amount_threshold`	`BIGNUMERIC`	Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
`sqrt_price_limit_x64`	`BIGNUMERIC`	Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
`is_base_input`	`BOOL`	Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
`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

payer	amount	amm_config	block_slot	pool_state	input_vault	memo_program	output_vault	is_base_input	surrogate_key	token_program	transaction_id	block_timestamp	input_vault_mint	instruction_type	executing_account	observation_state	output_vault_mint	transaction_index	remaining_accounts	token_program_2022	transaction_signer	input_token_account	output_token_account	sqrt_price_limit_x64	outer_executing_account	outer_instruction_index
EyS8aVDUR2RJ1PZusBjgCprzZHZgW6v6ki1Qw8fJF1Bv	10000000	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	275346241	HbuBYFbQKSeyE17HwHWyLnLR8sFE2scgrGAJyFFCsZCe	ANjYVMN8ydiMfXz9QVYNMgujrywhjUk23uAMLLY1k2D9	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	2DM76h7KNYhdFCsHXeefqE3c5y5x8Zk4SxCcbiUR1LRk	true	275346241-12NFoCMcyBbPSaYekFtncavugoLxFPsq7W4X7RC4NWBC62kKxVy3LFoAUkLaLhXb282JCoe27fjbYLX7MF5Jbeo-1-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	12NFoCMcyBbPSaYekFtncavugoLxFPsq7W4X7RC4NWBC62kKxVy3LFoAUkLaLhXb282JCoe27fjbYLX7MF5Jbeo	2024-07-03T00:28:50.000Z	So11111111111111111111111111111111111111112	SwapV2	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	BCK5R4Vo46DevaLk2gQgxYUwHo3QG6wyuXhGLoyUapxh	sKeqdUAKN7o8Kj9ebj3oyLoQJHPDhT5yDoHeevkUNgr	310	[“9YRNTE1eVwPry9czoFXkDqowMin61aXUov5aEpR94nux”,“9BtZPEi4AsrzcNBgU5RETZXykzRn9r4mkzZwVBMa7Dyv”,“FSCGDwe4tm8Tx2JPMAgXhtVrdGfAzT4bN4wRaEBzJEow”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	EyS8aVDUR2RJ1PZusBjgCprzZHZgW6v6ki1Qw8fJF1Bv	CMTfRQdBwL9yWTLEk2udqbnAJC5ixe9Uk4psaffjraH1	Ft56o3n2naHtHTvtMrDsZartBH1t3EqiTXWLz9vBZ1Kc	864117345187795770032	routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS	1
6uyhopMH6dasokN2sUqFRAirEWPu1cnrvJfjaWvpnVFg	155382803	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	275351119	HbuBYFbQKSeyE17HwHWyLnLR8sFE2scgrGAJyFFCsZCe	ANjYVMN8ydiMfXz9QVYNMgujrywhjUk23uAMLLY1k2D9	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	2DM76h7KNYhdFCsHXeefqE3c5y5x8Zk4SxCcbiUR1LRk	true	275351119-5xHvrcmK2mpXzejgvo9mLSnuntkw8d68oShyJXnZMFkCwm6dKEFXCBkx5cUckPQA1k2syvp4aBweXV31CvD2GFVH-1-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5xHvrcmK2mpXzejgvo9mLSnuntkw8d68oShyJXnZMFkCwm6dKEFXCBkx5cUckPQA1k2syvp4aBweXV31CvD2GFVH	2024-07-03T01:06:15.000Z	So11111111111111111111111111111111111111112	SwapV2	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	BCK5R4Vo46DevaLk2gQgxYUwHo3QG6wyuXhGLoyUapxh	sKeqdUAKN7o8Kj9ebj3oyLoQJHPDhT5yDoHeevkUNgr	135	[“9YRNTE1eVwPry9czoFXkDqowMin61aXUov5aEpR94nux”,“9BtZPEi4AsrzcNBgU5RETZXykzRn9r4mkzZwVBMa7Dyv”,“FSCGDwe4tm8Tx2JPMAgXhtVrdGfAzT4bN4wRaEBzJEow”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	6uyhopMH6dasokN2sUqFRAirEWPu1cnrvJfjaWvpnVFg	Cd8sYS82p9u5PHt3r9Mj6ZEXEy6SsJfSjP8ypYMYc95W	9FEJFc4pCWGcLMeZkshDbBWHz8WhEeeTLWS2bkmQVs9Z	328082509229981967090	routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS	1
B6MwGCYXfyVaMVnUbj1HduaYXaVFvBSr8WAARQmVLcR8	1000000	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	275348761	HbuBYFbQKSeyE17HwHWyLnLR8sFE2scgrGAJyFFCsZCe	ANjYVMN8ydiMfXz9QVYNMgujrywhjUk23uAMLLY1k2D9	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	2DM76h7KNYhdFCsHXeefqE3c5y5x8Zk4SxCcbiUR1LRk	true	275348761-5puRhGwYuZswjanHpnnrSK2ud2iN8ZSNzXeERw3hwGuYmTXpCEFGphBVzH317os26g5tXSoY7mUGB9D9Y2PbKtsU-1-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5puRhGwYuZswjanHpnnrSK2ud2iN8ZSNzXeERw3hwGuYmTXpCEFGphBVzH317os26g5tXSoY7mUGB9D9Y2PbKtsU	2024-07-03T00:48:18.000Z	So11111111111111111111111111111111111111112	SwapV2	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	BCK5R4Vo46DevaLk2gQgxYUwHo3QG6wyuXhGLoyUapxh	sKeqdUAKN7o8Kj9ebj3oyLoQJHPDhT5yDoHeevkUNgr	130	[“9YRNTE1eVwPry9czoFXkDqowMin61aXUov5aEpR94nux”,“9BtZPEi4AsrzcNBgU5RETZXykzRn9r4mkzZwVBMa7Dyv”,“FSCGDwe4tm8Tx2JPMAgXhtVrdGfAzT4bN4wRaEBzJEow”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	B6MwGCYXfyVaMVnUbj1HduaYXaVFvBSr8WAARQmVLcR8	5YLJZuat1be4Pa1ZjkzUfaqdbUeUcSzexXTcVtQ5ENd	EkKyxK9vxYc5cS9MxRhFcJMv4KN66eZ9P6cBJkREV9WS	854213709885972264224	routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS	1

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

RaydiumV5_increaseLiquidityV2_instruction

RaydiumV5_swap_instruction

RaydiumV5_swapV2_instruction

​Tables

​RaydiumV5_increaseLiquidityV2_instruction

​RaydiumV5_swap_instruction

​RaydiumV5_swapV2_instruction

Tables

RaydiumV5_increaseLiquidityV2_instruction

RaydiumV5_swap_instruction

RaydiumV5_swapV2_instruction