raydium_v2_solana

Tables

RaydiumV2_deposit_instruction

Liquidity deposit instructions for Raydium V2 automated market maker pools on Solana, capturing LP token minting events with token pair amounts and maximum slippage parameters. Used for analyzing liquidity provider behavior and pool deposit activity across Raydium V2 constant product market maker (CPMM) pools.

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_lpTokenAmount`	`BIGNUMERIC`	Amount of liquidity pool (LP) tokens being deposited into or minted by the Raydium pool. Denominated in the pool’s native units, represented as an integer value without decimal adjustment.
`in_maximumToken0Amount`	`BIGNUMERIC`	Maximum allowable amount of the first token to deposit into the Raydium liquidity pool. This caps slippage protection by limiting how much of token0 the user is willing to contribute.
`in_maximumToken1Amount`	`BIGNUMERIC`	Maximum amount of the second token the depositor authorizes to contribute to the liquidity pool. Acts as a slippage protection parameter to prevent excessive token usage if pool price moves unfavorably.
`in_owner`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_authority`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_poolState`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the Raydium V2 liquidity pool state that this deposit instruction interacts with. This pool contains the configuration and current reserves for the token pair being deposited.
`in_ownerLpToken`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Owner’s liquidity provider (LP) token account that receives LP tokens representing their share of the pool. This account is marked as writable to allow the deposit instruction to mint and transfer new LP tokens.
`in_token0Account`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account holding the user’s token0 balance that will be debited during the deposit operation. This is the source account for the first token in the liquidity pair.
`in_token1Account`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account holding the user’s second token to be deposited into the liquidity pool. This is a writable account from which token1 will be debited during the deposit operation.
`in_token0Vault`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Token account address holding the first asset in the Raydium V2 liquidity pool. This vault receives token0 deposits during liquidity provision operations.
`in_token1Vault`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana address of the liquidity pool’s vault account holding the second token in the pair. This vault stores the actual token1 balance controlled by the pool’s authority.
`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>`	Account address of the SPL Token-2022 program used for token operations in this deposit transaction. May be null if only the standard SPL Token program is used.
`in_vault0Mint`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address of the first token’s mint in the liquidity pool vault. Base-58 encoded Solana public key representing the SPL token mint authority.
`in_vault1Mint`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana address of the second token’s mint account in the liquidity pool vault. Represented as a base58-encoded string identifying the SPL token contract.
`in_lpMint`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Address of the liquidity pool token mint account. Base58-encoded Solana public key.

Sample Data

name	in_owner	in_lpMint	block_height	in_authority	in_poolState	in_vault0Mint	in_vault1Mint	surrogate_key	in_token0Vault	in_token1Vault	transaction_id	block_timestamp	in_ownerLpToken	in_tokenProgram	in_lpTokenAmount	in_token0Account	in_token1Account	instruction_index	transaction_index	in_tokenProgram2022	transaction_success	in_maximumToken0Amount	in_maximumToken1Amount	instruction_program_address
deposit	{“is_alt”:false,“address”:“BoXHxMPxtfYwgH8c8MmRAzcopcifR9FZ3gFSFKayVhru”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	{“is_alt”:false,“address”:“Fz273EXfYRRQwGkanDR9LqDqw4ykF7vSKHj5EsakT86q”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305065249	{“is_alt”:false,“address”:“GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“7Yt1yNCaKp2rqirzVhYKoHQQsmU6qBsasxDCoRhDaSGD”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“CXevZMmR8MWEMizUA9y1oqB6etSZrTtYDToV8pZwGGLM”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“EPjFWVTx9E7LWBEqYVnJby3dyq6UMaG5bdU39ESURJ1Y”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	7ryBHiHSBfSzyXG8czJBnKYTZqpRwTRixuWtNB1wZXH5-5sb245hd97jb9C3Nr9GTzRQiEHMosJK2BrvBkH6CRxtkVKaBUfDj8ZxGv5ikVELBML7ruVy1krJ16YXzVErUP9yr-0	{“is_alt”:false,“address”:“45uKgjazf5YqKWuqaJxgEyduRHCjfDJEeC8HLosfzxwQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“EcmDSRfynn9ZJeSKMgFY5ta23MrgUvuxuqkG5MpLJRyf”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	5sb245hd97jb9C3Nr9GTzRQiEHMosJK2BrvBkH6CRxtkVKaBUfDj8ZxGv5ikVELBML7ruVy1krJ16YXzVErUP9yr	2025-03-15T00:03:51.000Z	{“is_alt”:false,“address”:“EKUh3txoJuTHGFHwUTAaEPxCGh6quwRJdJAjY75AvUPa”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	442003167189	{“is_alt”:false,“address”:“5oy8aXRdhk1QZhx34zvZ8bV7S8MmB4AqVZgodaAJyDzQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“4S2FbkuCEgix7BfH85ArR4FSnM7HMeMHpgNaaH9zL9hJ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	0	1323	{“is_alt”:true,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	3953292308999	52000000000	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C
deposit	{“is_alt”:false,“address”:“FK5odhCycBgJjTws8i4AAFannhmbhao6KYzN6BEf5dDE”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	{“is_alt”:false,“address”:“DL3jqn84EDDg6HctEh8n6w6LUrf59FTv3QheAfys58oz”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305259669	{“is_alt”:false,“address”:“GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“78b9w7B6K8Pa37vSsN8WLugii6TNCTnfLnjjXgCTnMBP”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“pSYRpDqr847kB2nD5ZhjcPsHLV2ZpUxweXm1MwiSTcc”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“Bbza1cYWVTbotSwe329y111ij4LovHDWGA3Epf8J6nSs”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	7NUZH6dnHs64ZVJFzGcb8xkHkg7GzCY9VLTGNewZMWEk-3bVndUdU1J7pfmSyEgoqv2eoHLKgZHCfhxFVDMy4AzmJ5svTGcUoT2mHncsyZZ8fvyWAgKcEXo8qSBZopSKEXqHe-1	{“is_alt”:false,“address”:“Amz4cAjvjJFAgho9LAXwuGNGBfaQdZqrHbNQbTTDeXDJ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“6buzugyLAA1aiui39jVk7AihyxbdByTbJHQmMQJAPYNn”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	3bVndUdU1J7pfmSyEgoqv2eoHLKgZHCfhxFVDMy4AzmJ5svTGcUoT2mHncsyZZ8fvyWAgKcEXo8qSBZopSKEXqHe	2025-03-15T21:36:40.000Z	{“is_alt”:false,“address”:“HweY9V4MMzB1ryo9RtcoppAPuK5h8oeqavKQBrjjHncA”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	95928070	{“is_alt”:false,“address”:“CdQoTkoMcP9hKBBYfFYTPAwAi1TJd6pMyqr1dGwpPL6D”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“EvSepV6SLMHTYNg18jFagAQreQ3ZSuA4AEmErSDsQ4iQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	1	1782	{“is_alt”:true,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	2355556	6576669460	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C
deposit	{“is_alt”:false,“address”:“FK5odhCycBgJjTws8i4AAFannhmbhao6KYzN6BEf5dDE”,“is_signer”:true,“is_writable”:true,“is_fee_payer”:true}	{“is_alt”:false,“address”:“DL3jqn84EDDg6HctEh8n6w6LUrf59FTv3QheAfys58oz”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305263395	{“is_alt”:false,“address”:“GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“78b9w7B6K8Pa37vSsN8WLugii6TNCTnfLnjjXgCTnMBP”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“pSYRpDqr847kB2nD5ZhjcPsHLV2ZpUxweXm1MwiSTcc”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“Bbza1cYWVTbotSwe329y111ij4LovHDWGA3Epf8J6nSs”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	3kKymwezRWXE3pn5CXErfBjNSYUqN2PVEqDpVKcCAJJN-54zhwbiTRch1zzsymPLGYebNSL7HyFb2gxSLD2BZisos3etEcFkAjp13ZXsG9m5L1J9boAgioBe3qVK9gip98Spd-1	{“is_alt”:false,“address”:“Amz4cAjvjJFAgho9LAXwuGNGBfaQdZqrHbNQbTTDeXDJ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“6buzugyLAA1aiui39jVk7AihyxbdByTbJHQmMQJAPYNn”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	54zhwbiTRch1zzsymPLGYebNSL7HyFb2gxSLD2BZisos3etEcFkAjp13ZXsG9m5L1J9boAgioBe3qVK9gip98Spd	2025-03-15T22:01:27.000Z	{“is_alt”:false,“address”:“HweY9V4MMzB1ryo9RtcoppAPuK5h8oeqavKQBrjjHncA”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:true,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	101592323	{“is_alt”:false,“address”:“CdQoTkoMcP9hKBBYfFYTPAwAi1TJd6pMyqr1dGwpPL6D”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“EvSepV6SLMHTYNg18jFagAQreQ3ZSuA4AEmErSDsQ4iQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	1	1429	{“is_alt”:true,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	2494648	6965947540	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C

Example Query

Query with partition filter

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

RaydiumV2_swapBaseInput_instruction

Raydium V2 concentrated liquidity market maker (CLMM) swap instructions on Solana where traders specify exact input amounts. Contains swap parameters including input/output token mints, amounts, vault addresses, and minimum output constraints for analyzing DEX trading flow and liquidity utilization.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. 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_token_program`	`STRING`	Solana program address controlling the input token account in this swap instruction. Typically the SPL Token Program (TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA) for standard tokens.
`output_token_program`	`STRING`	Solana program address managing the output token in the swap transaction. Typically references the SPL Token program for standard tokens on Solana.
`input_token_mint`	`STRING`	Solana address of the input token being swapped in this Raydium V2 transaction. Base58-encoded string identifying the SPL token mint that the user is selling.
`output_token_mint`	`STRING`	Mint address of the token being received from the swap on Solana. Base58-encoded public key identifying the output token’s mint account.
`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.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	amount_in	authority	amm_config	block_slot	pool_state	input_vault	output_vault	surrogate_key	transaction_id	block_timestamp	input_token_mint	instruction_type	executing_account	instruction_index	observation_state	output_token_mint	transaction_index	remaining_accounts	transaction_signer	input_token_account	input_token_program	output_token_account	output_token_program	outer_executing_account	outer_instruction_index
HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK	83192897	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	D4FPEruKEHrG5TenZ2mpDGEfu1iUvTiqBxvpU8HLBvC2	271850089	Fb1ugqvbHT8fi2j128GtKWdrQFhBjcHAygJy8xbJ4Ex1	wN9ww9eZCzCqdMmCbJJNkYkQjqFHZ1nvNJKaJs9EB7p	13Dt8hUV8NkyboLj8cdgetC7jnbR59GTM4mUM2Pz2mdj	271850089-5wN1gk4EQtf8AuBdLCYpk7dvDRenXz22t266YWCMtirdavRmqecUeFape1MAhJJmu6LGjB6RpHSom9fWme1NAUrf-3-3	5wN1gk4EQtf8AuBdLCYpk7dvDRenXz22t266YWCMtirdavRmqecUeFape1MAhJJmu6LGjB6RpHSom9fWme1NAUrf	2024-06-14T19:26:43.000Z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	SwapBaseInput	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	3	BJm7jinvRxgm7SUcmAwHwV3Xy1B4VrW3cS77Bn5dEp3H	BARBAe5cb7XZ55coHKbY4sdk6BtALX8cwjq7mzPNm7zk	7	[]	HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK	2A83EeK7fXKYnptbDUqho3XaukqGk6pmYWqajwqnR5Ak	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Dy4ZaELLfdGRzV69TsUUYdMNkJWfAtvoB8nTKpCiQUj3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	G2E4eoenFMirpFKRfHNo2koDP7mrhnNWVwxyHASSpjQD	3
HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK	88676366	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	D4FPEruKEHrG5TenZ2mpDGEfu1iUvTiqBxvpU8HLBvC2	271806296	Fb1ugqvbHT8fi2j128GtKWdrQFhBjcHAygJy8xbJ4Ex1	wN9ww9eZCzCqdMmCbJJNkYkQjqFHZ1nvNJKaJs9EB7p	13Dt8hUV8NkyboLj8cdgetC7jnbR59GTM4mUM2Pz2mdj	271806296-2Bf72zCmBzKrgWFTAH8SDwX6xn3TU5M8RtBYmUUmfbZ4zGtTpMMV4PK6KDy1fKwPYVNrPvTcYmqhAEaL6MCLdve2-3-3	2Bf72zCmBzKrgWFTAH8SDwX6xn3TU5M8RtBYmUUmfbZ4zGtTpMMV4PK6KDy1fKwPYVNrPvTcYmqhAEaL6MCLdve2	2024-06-14T14:00:19.000Z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	SwapBaseInput	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	3	BJm7jinvRxgm7SUcmAwHwV3Xy1B4VrW3cS77Bn5dEp3H	BARBAe5cb7XZ55coHKbY4sdk6BtALX8cwjq7mzPNm7zk	11	[]	HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK	2A83EeK7fXKYnptbDUqho3XaukqGk6pmYWqajwqnR5Ak	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Dy4ZaELLfdGRzV69TsUUYdMNkJWfAtvoB8nTKpCiQUj3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	G2E4eoenFMirpFKRfHNo2koDP7mrhnNWVwxyHASSpjQD	3
HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK	90227955	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	D4FPEruKEHrG5TenZ2mpDGEfu1iUvTiqBxvpU8HLBvC2	271807417	Fb1ugqvbHT8fi2j128GtKWdrQFhBjcHAygJy8xbJ4Ex1	wN9ww9eZCzCqdMmCbJJNkYkQjqFHZ1nvNJKaJs9EB7p	13Dt8hUV8NkyboLj8cdgetC7jnbR59GTM4mUM2Pz2mdj	271807417-4hqMWs7mNH5r9X6ezje3QJ9aB3Kne4RYgKXCzD9LBzQjGLiG9MDz8SrPTmiwAkvebVtwctHAY9XEtQbBMfgV2Vs3-3-3	4hqMWs7mNH5r9X6ezje3QJ9aB3Kne4RYgKXCzD9LBzQjGLiG9MDz8SrPTmiwAkvebVtwctHAY9XEtQbBMfgV2Vs3	2024-06-14T14:08:43.000Z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	SwapBaseInput	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	3	BJm7jinvRxgm7SUcmAwHwV3Xy1B4VrW3cS77Bn5dEp3H	BARBAe5cb7XZ55coHKbY4sdk6BtALX8cwjq7mzPNm7zk	28	[]	HvFdDWS3RqymRAVx1ZdoL2RjiC38r5dtt19Z8op5jqDK	2A83EeK7fXKYnptbDUqho3XaukqGk6pmYWqajwqnR5Ak	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Dy4ZaELLfdGRzV69TsUUYdMNkJWfAtvoB8nTKpCiQUj3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	G2E4eoenFMirpFKRfHNo2koDP7mrhnNWVwxyHASSpjQD	3

Example Query

Query with partition filter

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

RaydiumV2_swapBaseOutput_instruction

Swap instruction records from Raydium V2 AMM (Automated Market Maker) concentrated liquidity pools on Solana where traders specify exact output amount and accept variable input cost. Used for analyzing swap routing behavior, slippage tolerance patterns, and liquidity pool efficiency across SPL token pairs.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. 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_token_program`	`STRING`	Account address of the Solana Token Program managing the input token. Typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA (SPL Token) or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb (Token-2022).
`output_token_program`	`STRING`	Program ID of the token program managing the output token. Typically `TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA` for SPL Token or `TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb` for Token-2022.
`input_token_mint`	`STRING`	Token mint address of the asset being sold in this swap. Base58-encoded Solana program-derived address identifying the SPL token being provided as input.
`output_token_mint`	`STRING`	Token mint address of the asset being received in the swap transaction. Base-58 encoded Solana program address identifying the SPL token being acquired.
`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.
`max_amount_in`	`BIGNUMERIC`	Maximum amount of input tokens the user authorizes to spend for this swap. Acts as slippage protection by reverting if the actual amount needed exceeds this limit.
`amount_out`	`BIGNUMERIC`	Output amount of tokens received from the swap or transaction. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	authority	amm_config	amount_out	block_slot	pool_state	input_vault	output_vault	max_amount_in	surrogate_key	transaction_id	block_timestamp	input_token_mint	instruction_type	executing_account	instruction_index	observation_state	output_token_mint	transaction_index	remaining_accounts	transaction_signer	input_token_account	input_token_program	output_token_account	output_token_program	outer_executing_account	outer_instruction_index
2LT7ZYMaHfqRNBYAAG6GU95MgAEqxshmCygJTWLa8ewQ	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	D4FPEruKEHrG5TenZ2mpDGEfu1iUvTiqBxvpU8HLBvC2	50000000000	349728587	AeGBjqTeXiEgdAxU1ZhBEqmkXk6RuQNCXJWvdo4N4CBg	7eNhwggCUKw8Qt6zxuyszhuBeuY5aGqqkrD5AnuefhAw	7bSUSTQe4qHUuJJLpSg6f5sCTqMU34K2xbgkgAvqBnrh	1325405955	349728587-58ZfznhsZBBJ6aTiaTkMrRrc6VpVcdWTH7WtPFSRXB2TA5HCpFj3Bsb4Nv6UFGSnk4LDWGuex9H4ocWA27bHa51B-2-8	58ZfznhsZBBJ6aTiaTkMrRrc6VpVcdWTH7WtPFSRXB2TA5HCpFj3Bsb4Nv6UFGSnk4LDWGuex9H4ocWA27bHa51B	2025-06-28T09:28:30.000Z	So11111111111111111111111111111111111111112	SwapBaseOutput	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	8	J2nxGTfQrCK44rJASfSZTBwS4TiSFWev9EJt73QoktSk	9McvH6w97oewLmPxqQEoHUAv3u5iYMyQ9AeZZhguYf1T	280	[]	2LT7ZYMaHfqRNBYAAG6GU95MgAEqxshmCygJTWLa8ewQ	D5E4soMeRiyA638GRBr3JLCKLhAA3MChD2vWdPLyXuv5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	93TA1VzpLCaYu4kDxwJ6jCoTHEQxfGaN75PC6RZSCFpZ	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS	2
2ZCXaS4ghnqAjXEei6WMs4TEX51RkWsSwYa4K5gZKYHM	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	D4FPEruKEHrG5TenZ2mpDGEfu1iUvTiqBxvpU8HLBvC2	25000000000000	349649194	9JsVdcURJRjXxp2eiEymY4fZWNPGmL2h5qfTkBua6GY3	EXRj6K3p5vrUcnS4Xgd3pjPqftuCFf2Y76vgQpwGKRy1	35ZWhh7pksXPdtwMxdVPHemiPh3g7wN2CAkghDqa9ajJ	3743563	349649194-4WtR7HTfR6QAN2NuDn2xo93oRPFay7GiBXn4nfACBVsL7xVYQm8k8wgqZhiAob2u3uea579D7pxxNbNDRhAAKWzG-3-0	4WtR7HTfR6QAN2NuDn2xo93oRPFay7GiBXn4nfACBVsL7xVYQm8k8wgqZhiAob2u3uea579D7pxxNbNDRhAAKWzG	2025-06-28T00:43:55.000Z	So11111111111111111111111111111111111111112	SwapBaseOutput	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	0	CD5c3giPK4X9h7EtA7CHJpwuAM1aUw4DexNRSd1UqrTe	9TVnJsWkWFao7qyWDavEUBUao9w6J6QYDL1GoueTHpfD	53	[]	2ZCXaS4ghnqAjXEei6WMs4TEX51RkWsSwYa4K5gZKYHM	AHmNDpRhBBthuJkckg6jtn6FzF1FcGXLVmt5ywJy76Uh	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	4Hxf1fe2caDnqf8wpcHhSAL2uC3SRT3mXTmjYwFeb5Cs	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS	3
2c2ZvRiEXJNPUdxtHN5ZLYuJ64vn3MmM5P4wNDRTmADa	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	D4FPEruKEHrG5TenZ2mpDGEfu1iUvTiqBxvpU8HLBvC2	10999000000000	349684567	48ExM5rHCahDdh5V1Liije5D2vwKVXB5rgGGnBbJ5biP	6snfj2A1KJFUb6TsxB8HAGg8Bu1zsDxMMPdHSov8jSwa	3YpPCtFKGitiiv3GfdyLjk2kkY1WZq8GhLYrMoxyXUvq	42385185	349684567-5JfYpr3Hz3VzxLLe6sVeVodiu9M89ykCz6FJx3KrQ4J3ZoVtiDAZXbWyZGiRYEqfAsQrqDCewvrAA1yz8FWYsDVZ-3-5	5JfYpr3Hz3VzxLLe6sVeVodiu9M89ykCz6FJx3KrQ4J3ZoVtiDAZXbWyZGiRYEqfAsQrqDCewvrAA1yz8FWYsDVZ	2025-06-28T04:37:08.000Z	So11111111111111111111111111111111111111112	SwapBaseOutput	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	5	Edoxpd7SMaygwqr6NHdtxLF7RxuTULQ3T7qv6B2WSqtW	2G4RMDbXu79f5Yff6fBjKgXknuGvrFCr7iYmiTKy3fVc	238	[]	2c2ZvRiEXJNPUdxtHN5ZLYuJ64vn3MmM5P4wNDRTmADa	GszXv1PXR5v27LAUi3nZw6cCR7ByFVNzH5D8MTe5kopn	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2ixbHNHW63nD3tBSwg7t2anqs7sVWWoNwucLij7F2cLN	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	routeUGWgWzqBWFcrCfv8tritsqukccJPu3q5GPP3xS	3

Example Query

Query with partition filter

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

RaydiumV2_withdraw_instruction

Liquidity pool (LP) token withdrawal instructions from Raydium V2 automated market maker (AMM) on Solana. Contains burn amounts, minimum output requirements, vault addresses, and token pair data for analyzing LP position exits and redemption patterns.

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_lpTokenAmount`	`BIGNUMERIC`	Amount of LP (Liquidity Provider) tokens being withdrawn from the Raydium V2 pool. Represented as a raw token amount without decimal adjustment, typically in the millions range based on sample values.
`in_minimumToken0Amount`	`BIGNUMERIC`	Minimum amount of token0 the user is willing to accept from the liquidity withdrawal. Typically set to zero to allow any amount, providing slippage protection when non-zero.
`in_minimumToken1Amount`	`BIGNUMERIC`	Minimum acceptable amount of the second token to receive from liquidity withdrawal. Protects against unfavorable price movements or slippage, commonly set to zero for unlimited tolerance.
`in_owner`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_authority`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_poolState`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana account address of the Raydium V2 liquidity pool state from which liquidity is being withdrawn. This is a writable account that tracks pool composition and LP token supply.
`in_ownerLpToken`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana address of the liquidity provider (LP) token account owned by the withdrawing user. This account holds the LP tokens being burned in exchange for the underlying token pair.
`in_token0Account`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana account address receiving the first token of the pair when liquidity is withdrawn from the pool. Base-58 encoded Solana address that must match the token0 mint type.
`in_token1Account`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Account receiving token1 (the second token in the pair) upon liquidity withdrawal. Solana account address marked as writable to accept the transferred tokens.
`in_token0Vault`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana address of the pool’s vault holding the first token in the liquidity pair. This vault stores the pool’s token0 reserves that are withdrawn from during liquidity removal.
`in_token1Vault`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana account address of the pool’s vault holding the second token in the liquidity pair. Writable account that receives withdrawn token1 amounts during liquidity removal operations.
`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>`	Solana Token-2022 program address for handling token operations if the liquidity pool uses Token Extensions. This field may be null for pools using the standard SPL Token program.
`in_vault0Mint`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana address of the first token’s mint account in the liquidity pool vault. Represents the mint authority for token0, typically SOL or USDC based on sample data.
`in_vault1Mint`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana address of the second token’s mint account in the liquidity pool vault. This field identifies token1 in the trading pair being withdrawn from.
`in_lpMint`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Address of the liquidity pool token mint account. Base58-encoded Solana public key.
`in_memoProgram`	`STRUCT<address STRING, is_signer BOOL, is_writable BOOL, is_alt BOOL, is_fee_payer BOOL>`	Solana account containing the Memo program used to attach notes to the transaction. Consistently set to the standard Memo program address (MemoSq4…) across all withdrawals.

Sample Data

name	in_owner	in_lpMint	block_height	in_authority	in_poolState	in_vault0Mint	in_vault1Mint	surrogate_key	in_memoProgram	in_token0Vault	in_token1Vault	transaction_id	block_timestamp	in_ownerLpToken	in_tokenProgram	in_lpTokenAmount	in_token0Account	in_token1Account	instruction_index	transaction_index	in_tokenProgram2022	transaction_success	instruction_program_address
withdraw	{“is_alt”:false,“address”:“3f7GcQFG397GAaEnv51zR6tsTVihYRydnydDD1cXekxH”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“5pJbrKLEXCAwryJ65uAPqQoLiJZT53xRSTCv3TR82JLY”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305125678	{“is_alt”:false,“address”:“GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“8DPPdVemT4gR7MU5paqKkXWuqdUR6KDVvDEr4ewH4m8s”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“JCeoBX79HfatfaY6xvuNyCHf86hwgkCCWDpEycVHtime”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	7QbeMVGnZj5xQ8KhbffREs41rsQM64GtLuSCPYkhr6Uz-3cFhaHGs1nv1xmHGJPD3knDdLvDCrJSgencYrDnocp9m2so4Ua4RKeePUQobcQnvdDTj8fqwaWJ4SghPTi1hpG9B-2-0	{“is_alt”:false,“address”:“MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“9xc2hFBpv2HgaYqZnjJdkfo4FgZyDQJimqTAzakUt2Kw”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“5C6CGumCdFqnU4p3XH18ZjX3rfVWrbCELBH4qsRnaohE”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	3cFhaHGs1nv1xmHGJPD3knDdLvDCrJSgencYrDnocp9m2so4Ua4RKeePUQobcQnvdDTj8fqwaWJ4SghPTi1hpG9B	2025-03-15T06:45:09.000Z	{“is_alt”:false,“address”:“D2fs4QekuzgGT87VunZfYLPivp8uJ6z9z9MGyxxBiSn9”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	6198580	{“is_alt”:false,“address”:“HKJfcimMpZ7S3d4786wyjk2NBCKWrjMjNRzRjCSjbzBd”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“4Yms1e3E6dsR2vxK39R5C5MoMQ425EksXKtngGPsN4Eq”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	2	1340	{“is_alt”:false,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C
withdraw	{“is_alt”:false,“address”:“3f7GcQFG397GAaEnv51zR6tsTVihYRydnydDD1cXekxH”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“BJND2yH9D6ZJNsxNYAh7ZvhBMmTbTVV2VN4tJRFGpRhC”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305244867	{“is_alt”:false,“address”:“GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“DL5ybnT8xv9MjvaxeLDATXox6tw5YhPt8TKALvoTvYhq”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“HsBG6WGhbHYwyknCqDSZ27edyCWk1aPSVmmSYginhDhp”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	4adLJKB5uaPPv54k8GaHwEB47p9k1LNvKqkZ8e3o6oD6-4ChiRv2QNi86SyexXoqJ8rZh2e9eci181J5Txdg84DiZ45XvqEyvDcGFuHJPuXDccQEy2waHA8bcpPfby7hR6K4B-3-0	{“is_alt”:false,“address”:“MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“Dg3dMB6uCw4EkT7wuFrLLR6bB3h2szwSFMWMoK384dDT”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“HbivGRDY343RrAGcv8NTs24RuMtrDwktfxCzjFR6tW6b”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	4ChiRv2QNi86SyexXoqJ8rZh2e9eci181J5Txdg84DiZ45XvqEyvDcGFuHJPuXDccQEy2waHA8bcpPfby7hR6K4B	2025-03-15T19:57:51.000Z	{“is_alt”:false,“address”:“DVEYMLn5eZPawF575fzsVkzxkHZuxz3AXNH73WSJajAQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	5787596	{“is_alt”:false,“address”:“GGtXPeFGXnaVr3XNDtzWYKxk34qZre6XeJsDLFZtf1e7”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“CrX9r53jFUYfMU6rA5Xzuyn9SqJe4bNMtT1XtP9wvnHb”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	3	1385	{“is_alt”:false,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C
withdraw	{“is_alt”:false,“address”:“3f7GcQFG397GAaEnv51zR6tsTVihYRydnydDD1cXekxH”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“BJND2yH9D6ZJNsxNYAh7ZvhBMmTbTVV2VN4tJRFGpRhC”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	305220658	{“is_alt”:false,“address”:“GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“DL5ybnT8xv9MjvaxeLDATXox6tw5YhPt8TKALvoTvYhq”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“So11111111111111111111111111111111111111112”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“HsBG6WGhbHYwyknCqDSZ27edyCWk1aPSVmmSYginhDhp”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	4X4qUsv39ZcWgWKuyQ2BjbJYAq4UkU7qvnEVrPxpwxft-4uzkcE7zVyZKRRkoKpaYJCFcezKbXbZCgV2uobeKSCU4yKAJhta9RtkmGa4SZVenosRSp2zfbb9UhXLiKuZgxivy-3-0	{“is_alt”:false,“address”:“MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	{“is_alt”:false,“address”:“Dg3dMB6uCw4EkT7wuFrLLR6bB3h2szwSFMWMoK384dDT”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“HbivGRDY343RrAGcv8NTs24RuMtrDwktfxCzjFR6tW6b”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	4uzkcE7zVyZKRRkoKpaYJCFcezKbXbZCgV2uobeKSCU4yKAJhta9RtkmGa4SZVenosRSp2zfbb9UhXLiKuZgxivy	2025-03-15T17:16:47.000Z	{“is_alt”:false,“address”:“DVEYMLn5eZPawF575fzsVkzxkHZuxz3AXNH73WSJajAQ”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	5746684	{“is_alt”:false,“address”:“5Y2LonQ2f3wLHmiZC3Liv4cZjwYzRB6Y5NKpBVjN1Lo6”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	{“is_alt”:false,“address”:“CrX9r53jFUYfMU6rA5Xzuyn9SqJe4bNMtT1XtP9wvnHb”,“is_signer”:false,“is_writable”:true,“is_fee_payer”:false}	3	1997	{“is_alt”:false,“address”:“TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb”,“is_signer”:false,“is_writable”:false,“is_fee_payer”:false}	true	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

RaydiumV2_deposit_instruction

RaydiumV2_swapBaseInput_instruction

RaydiumV2_swapBaseOutput_instruction

RaydiumV2_withdraw_instruction

Metrics

Primitives

Contracts

Blockchain

​Tables

​RaydiumV2_deposit_instruction

​RaydiumV2_swapBaseInput_instruction

​RaydiumV2_swapBaseOutput_instruction

​RaydiumV2_withdraw_instruction

Tables

RaydiumV2_deposit_instruction

RaydiumV2_swapBaseInput_instruction

RaydiumV2_swapBaseOutput_instruction

RaydiumV2_withdraw_instruction