raydium_v1_solana

Tables

AMMV4_SwapBaseIn_instruction

Instruction-level records of SwapBaseIn operations on Raydium V4 automated market maker (AMM) pools on Solana. Captures swap execution details including input amounts, minimum output constraints, and pool/token account addresses for analyzing trading activity and liquidity dynamics.

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`	`STRING`	Program address of the automated market maker pool. Base58-encoded Solana public key.
`amm_authority`	`STRING`	Program-derived address (PDA) with authority to execute operations on the AMM pool. Constant value 5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1 across all Raydium V4 pools.
`amm_open_orders`	`STRING`	Account address managing open orders for the automated market maker pool on the Serum decentralized exchange. Base58-encoded Solana public key.
`amm_target_orders`	`STRING`	Account address for the automated market maker’s target orders on the Serum decentralized exchange. Base58-encoded Solana public key.
`pool_coin_token_account`	`STRING`	Token account holding the pool’s reserve of the base (coin) asset in this liquidity pool. All pools appear to use valid Solana addresses except placeholder values (‘11111111111111111111111111111111’) indicating non-Serum integrations.
`pool_pc_token_account`	`STRING`	Token account holding the pool’s price currency (PC/quote token) reserves in the Raydium AMM liquidity pool. This is the destination account when swapping from base to quote token.
`serum_asks`	`STRING`	Account address of Serum DEX’s ask (sell) orders for the liquidity pool. May be null address (all 1s) when pool does not use Serum orderbook integration.
`serum_bids`	`STRING`	Account address for the Serum DEX order book bids data structure in the referenced market. May contain the placeholder value ‘11111111111111111111111111111111’ when not actively routing through Serum.
`serum_coin_vault_account`	`STRING`	Serum DEX vault account holding the base token (coin) reserves for the associated market. Frequently set to null address (all 1s) when Serum integration is disabled for CPMM pools.
`serum_event_queue`	`STRING`	Serum DEX event queue account address for recording trade events and order matches. Frequently set to the null address (all 1s) when Serum integration is not active for the swap.
`serum_market`	`STRING`	Account address of the Serum decentralized exchange market for the trading pair. Base58-encoded Solana public key.
`serum_pc_vault_account`	`STRING`	Serum DEX vault account holding the price currency (PC) token reserves for this liquidity pool on Raydium. Set to null address (all 1s) when the pool operates without an integrated Serum market.
`serum_program`	`STRING`	Program ID of the Serum DEX instance used for order book matching in this AMM swap. Typically the standard Serum v3 program or a null placeholder when Serum integration is not active.
`serum_vault_signer`	`STRING`	Account authorized to sign Serum DEX vault operations for this AMM pool. Commonly set to the null address (all 1s) when Serum integration is disabled or not used.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`uer_destination_token_account`	`STRING`	Token account receiving the output tokens from the swap transaction. Base58-encoded Solana account address, may match transaction_signer for direct recipient wallets.
`uer_source_token_account`	`STRING`	Token account address of the user’s input asset being swapped from in this transaction. Solana base58-encoded public key representing the SPL token account debited during the swap.
`user_source_owner`	`STRING`	Solana account address that owns the source token account initiating the swap. Empty string when transaction signer directly owns source account.
`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

amm	amount_in	block_slot	serum_asks	serum_bids	serum_market	amm_authority	serum_program	surrogate_key	token_program	transaction_id	amm_open_orders	block_timestamp	instruction_type	amm_target_orders	executing_account	instruction_index	serum_event_queue	transaction_index	user_source_owner	minimum_amount_out	remaining_accounts	serum_vault_signer	transaction_signer	pool_pc_token_account	serum_pc_vault_account	outer_executing_account	outer_instruction_index	pool_coin_token_account	serum_coin_vault_account	uer_source_token_account	uer_destination_token_account
7ZjFFFRCfsGvsRuWmm6s5Z9FVnKfTqXaw7ThPHYQaBPy	11942182208665	307990223	11111111111111111111111111111111	11111111111111111111111111111111	11111111111111111111111111111111	5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1	11111111111111111111111111111111	307990223-63Pv9c8zmvSRtpgffzt1SpNadBrSPxzzyEZNfg9ydBD85v9b8AGDsjBhL8Nav3CygDAM4Kq6Wd4TxRYsNEWbMGyQ-3-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	63Pv9c8zmvSRtpgffzt1SpNadBrSPxzzyEZNfg9ydBD85v9b8AGDsjBhL8Nav3CygDAM4Kq6Wd4TxRYsNEWbMGyQ	11111111111111111111111111111111	2024-12-17T05:45:44.000Z	SwapBaseIn	5L5xZBVmH5FwNmiqgGMXk5SjV9hH1K3nJnHryYtRGDTB	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	5	11111111111111111111111111111111	166		0	[]	CCTcqvKdP5WkGetwkNCLzsqt2RNAkxAAi5TpRkxdG7Rf	27ca4HoAHhLs929VAFGybfrkigf19a7zUt661kg6SSp1	11111111111111111111111111111111	11111111111111111111111111111111	DF1ow3DqMj3HvTj8i8J9yM2hE9hCrLLXpdbaKZu4ZPnz	3	A2qJ4AcXNu9iqwtcow6JvxFTsVSEa8oLBJmbaRgG5sg5	11111111111111111111111111111111	7pEaHA3Mjgo2wWrDh8nKmqAPMBVC4FHUSnYXziJKdb5s	27ca4HoAHhLs929VAFGybfrkigf19a7zUt661kg6SSp1
J3b6dvheS2Y1cbMtVz5TCWXNegSjJDbUKxdUVDPoqmS7	42716964348	308090310	11111111111111111111111111111111	11111111111111111111111111111111	11111111111111111111111111111111	5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1	11111111111111111111111111111111	308090310-5sE9PeQ3mMdFCYVVPDTJSuzyCsgweZydrUn8Y1yesHLHDpVJ38JrVt1ocCizNJUQYGhE7xicaUsYdAB9QLnvZ8Zc-5-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5sE9PeQ3mMdFCYVVPDTJSuzyCsgweZydrUn8Y1yesHLHDpVJ38JrVt1ocCizNJUQYGhE7xicaUsYdAB9QLnvZ8Zc	11111111111111111111111111111111	2024-12-17T17:17:04.000Z	SwapBaseIn	BExeHoT1gWqPJ1iyMYScL3Lz7awxrMz5QLQRCJPdMy37	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	5	11111111111111111111111111111111	526		0	[]	9pLVTpc2kLbcP4rTdVrty3zd93mtGRMehcHZ83C7YW24	Cbso3ckzWUJfrqP5uSBFLtXXCR9b964ZQacmVP5f2AWz	11111111111111111111111111111111	11111111111111111111111111111111	DF1ow3DqMj3HvTj8i8J9yM2hE9hCrLLXpdbaKZu4ZPnz	5	5Au7iiRJNP8BeXBaZj2Y8tiCQL8HsZDiB9MNAxNJd9SF	11111111111111111111111111111111	2hMpu3bkH91JHAKULSPe6TGSSmJxM9N8q32xk8xhCk8V	Cbso3ckzWUJfrqP5uSBFLtXXCR9b964ZQacmVP5f2AWz
GZppTbWFSfyhUXrFQoX5a9wMbGfZeSi1mA5Npqd9x6Az	6993661301	308044245	11111111111111111111111111111111	11111111111111111111111111111111	11111111111111111111111111111111	5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1	11111111111111111111111111111111	308044245-5DVE6tXnoUAWTMZoa5gViKEJXWucsQ8hckss5yQyAw5V481CCcWThdxttfMEyua4NqAXkMScVg9duskqKkcrEvNS-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5DVE6tXnoUAWTMZoa5gViKEJXWucsQ8hckss5yQyAw5V481CCcWThdxttfMEyua4NqAXkMScVg9duskqKkcrEvNS	11111111111111111111111111111111	2024-12-17T11:55:28.000Z	SwapBaseIn	11111111111111111111111111111111	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	4	11111111111111111111111111111111	309	Aff46EPvHBBtGoj8DZKxPJbDuLQq2ZLpfBvgAZTCmnKp	3243215562885	[]	11111111111111111111111111111111	Aff46EPvHBBtGoj8DZKxPJbDuLQq2ZLpfBvgAZTCmnKp	8BWriELkeNhE7jEXKeLPvS1X2LHwiQkvnhc3sCUDAiyg	11111111111111111111111111111111			CMGgyrVW6GZizHxrBufGKvK5iuePmegQDycgWUT6R84M	11111111111111111111111111111111	4QqYgNJDpviuHAmjKEWn7n7iFZdqXjpPU11LnVJ3xGvL	59VEALmDb1DhH2nFG1aMyxPfgna5jwDM6jW64zRbH2LG

Example Query

Query with partition filter

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

AMMV4_SwapBaseOut_instruction

Raydium V4 AMM swap instructions on Solana where users specify exact output amount and accept maximum input slippage. Contains swap parameters, AMM pool references, Serum DEX orderbook accounts, and user token accounts for analyzing liquidity provision and arbitrage 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`	`STRING`	Program address of the automated market maker pool. Base58-encoded Solana public key.
`amm_authority`	`STRING`	Automated market maker (AMM) authority account that has administrative permissions over the liquidity pool. This is a Solana program-derived address (PDA) used to authorize pool operations and control AMM funds.
`amm_open_orders`	`STRING`	Account address managing open orders for the automated market maker pool on the Serum decentralized exchange. Base58-encoded Solana public key.
`amm_target_orders`	`STRING`	Account address for the automated market maker’s target orders on the Serum decentralized exchange. Base58-encoded Solana public key.
`pool_coin_token_account`	`STRING`	Raydium AMM’s token account holding the base (coin) side of the liquidity pool. Base-58 encoded Solana account address.
`pool_pc_token_account`	`STRING`	Raydium AMM pool’s price currency (quote token) account address. Base58-encoded Solana account identifier holding the pool’s quote-side token reserves.
`serum_asks`	`STRING`	Solana account address of the Serum DEX asks orderbook for this trading pair. This address stores sell orders available for the automated market maker to match against.
`serum_bids`	`STRING`	Solana account address containing the Serum DEX order book bids for this liquidity pool. Base58-encoded, identifies the account storing buy orders that the AMM uses for price discovery.
`serum_coin_vault_account`	`STRING`	Serum DEX vault account holding the base (coin) token reserves for the liquidity pool. Base58-encoded Solana account address managing token custody for the market maker side.
`serum_event_queue`	`STRING`	Solana account address of the Serum decentralized exchange (DEX) event queue for this swap transaction. This queue tracks order matching events on the associated Serum market.
`serum_market`	`STRING`	Account address of the Serum decentralized exchange market for the trading pair. Base58-encoded Solana public key.
`serum_pc_vault_account`	`STRING`	Solana account address of the Serum DEX vault holding the price currency (quote token) for this AMM pool’s underlying market. Base58-encoded string identifier linking the Raydium pool to its Serum market reserves.
`serum_program`	`STRING`	Solana program address for the Serum DEX (decentralized exchange) integration handling order matching. All sample values show `9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin`, the Serum v3 program identifier.
`serum_vault_signer`	`STRING`	Solana account authorized to sign transactions on behalf of the Serum DEX market vault. This Program Derived Address (PDA) enables the market to transfer tokens during swap execution.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`uer_destination_token_account`	`STRING`	User’s destination token account address for receiving the swapped output tokens. Base58-encoded Solana account identifier that holds the tokens being acquired in the swap.
`uer_source_token_account`	`STRING`	User’s source token account from which tokens are debited during the swap. Solana account address in base58 format.
`user_source_owner`	`STRING`	Solana account address of the user initiating the swap transaction. Base58-encoded public key that owns the source token account being debited.
`amount_out`	`BIGNUMERIC`	Output amount of tokens received from the swap or transaction. Integer value representing the quantity in the token’s smallest unit.
`max_amount_in`	`BIGNUMERIC`	Maximum amount of input tokens the user is willing to spend to receive the specified output amount. Acts as a slippage protection limit, with actual input typically lower than this ceiling.
`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

amm	amount_out	block_slot	serum_asks	serum_bids	serum_market	amm_authority	max_amount_in	serum_program	surrogate_key	token_program	transaction_id	amm_open_orders	block_timestamp	instruction_type	amm_target_orders	executing_account	serum_event_queue	transaction_index	user_source_owner	remaining_accounts	serum_vault_signer	transaction_signer	pool_pc_token_account	serum_pc_vault_account	pool_coin_token_account	serum_coin_vault_account	uer_source_token_account	uer_destination_token_account
5JERMjgnUNXfmBuxtGqJ6zcrGbiUrz41SkqhCiZCsZC8	21421521	152867892	8HVFDwLGtK95jPoUfPJcaBmyYrW26ctjbxUUhHP4GmSP	5y4Kk5fWDHEyfsPMosq5J6ErqMkjEFi5smMMBizcRHhr	7tiJfi9AEpnsi3dHPiaQE2NKr67x5n4LFPg3JxEJdtwQ	5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1	23300000000	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	152867892-StNe5bwBUP4TYiNxWNihNjSPzagyu54XBHJAyjhKmmtmBPd615v8RaUojsUMmsRS7miaXEs1bkxKx1MtuMxLzaW-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	StNe5bwBUP4TYiNxWNihNjSPzagyu54XBHJAyjhKmmtmBPd615v8RaUojsUMmsRS7miaXEs1bkxKx1MtuMxLzaW	Hdj3tAgSzNMmBHpArRNJLDjiKHSncMR2wqpistVsCNCQ	2022-09-29T00:59:44.000Z	SwapBaseOut	5Uh9WHghZwPfStZGQLLPWxnBZ7e5QPeB2SoDuC9xQGAb	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	2TTBuFgctDdV2XbAPaV4dLiEf5fNvGQCTJDQcsgzJukT	20	EZg32rLEgk7JxNA2ANsMNe7TdToy2JhgSERS4De8EyTq	[]	EjeN8tG8SP9Tb2zu9nPRpuWWmr1WiFQFB9oRnZDa2JoY	EZg32rLEgk7JxNA2ANsMNe7TdToy2JhgSERS4De8EyTq	F6eSqBZnbYWELWpPGXWooKRu2SNnTWJQV4wuTf2WfT1W	8Z89io5V2QTgGETTSYDbfJ1jDUu3hRchMKGStABB6vfq	Hpw3P5EiALv4Z5HCZ8mwpSRhzXofvRMQcpgcb7kRAGM1	8FMEm8zqc3B8g6GdmSwQi8fnmRxwNh4ycCtXBcSR1JG8	CSXAJGwaSvcf1XEXnWHiaoKrZgkP6oA88Eppyvus9bXn	AF5pJGJWWGi2HrZi66Yek1ir2BLTSdeenwKcTSxkZ4eJ
5JERMjgnUNXfmBuxtGqJ6zcrGbiUrz41SkqhCiZCsZC8	20507102	152944943	8HVFDwLGtK95jPoUfPJcaBmyYrW26ctjbxUUhHP4GmSP	5y4Kk5fWDHEyfsPMosq5J6ErqMkjEFi5smMMBizcRHhr	7tiJfi9AEpnsi3dHPiaQE2NKr67x5n4LFPg3JxEJdtwQ	5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1	22400000000	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	152944943-5YuYaL46PC7miHejKZ1pRvcvS1qpxaVKKs16ujkUB1otnUQVgbdRe2EnRVfYyJgvHSXyqNuKzYWPAbohmM4jWf8K-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5YuYaL46PC7miHejKZ1pRvcvS1qpxaVKKs16ujkUB1otnUQVgbdRe2EnRVfYyJgvHSXyqNuKzYWPAbohmM4jWf8K	Hdj3tAgSzNMmBHpArRNJLDjiKHSncMR2wqpistVsCNCQ	2022-09-29T13:42:09.000Z	SwapBaseOut	5Uh9WHghZwPfStZGQLLPWxnBZ7e5QPeB2SoDuC9xQGAb	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	2TTBuFgctDdV2XbAPaV4dLiEf5fNvGQCTJDQcsgzJukT	311	CWRd3hNcdgpHpA2S76VZXqDr9NR6Nnk7pv3sRo2MTRcD	[]	EjeN8tG8SP9Tb2zu9nPRpuWWmr1WiFQFB9oRnZDa2JoY	CWRd3hNcdgpHpA2S76VZXqDr9NR6Nnk7pv3sRo2MTRcD	F6eSqBZnbYWELWpPGXWooKRu2SNnTWJQV4wuTf2WfT1W	8Z89io5V2QTgGETTSYDbfJ1jDUu3hRchMKGStABB6vfq	Hpw3P5EiALv4Z5HCZ8mwpSRhzXofvRMQcpgcb7kRAGM1	8FMEm8zqc3B8g6GdmSwQi8fnmRxwNh4ycCtXBcSR1JG8	6zGXcxqgJt2g4GarpKr5VNpZqtJpUfdg6YdAytJndkB7	A9V5SjCdyZCeBMvD4bGNF7zwRS1pvDqpnephsW8JUEoK
5JERMjgnUNXfmBuxtGqJ6zcrGbiUrz41SkqhCiZCsZC8	26135531	152868603	8HVFDwLGtK95jPoUfPJcaBmyYrW26ctjbxUUhHP4GmSP	5y4Kk5fWDHEyfsPMosq5J6ErqMkjEFi5smMMBizcRHhr	7tiJfi9AEpnsi3dHPiaQE2NKr67x5n4LFPg3JxEJdtwQ	5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1	28800000000	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	152868603-3YcAxgq3BBvpJaD8SrC84kkuBesqk516zKKp6ZtDzbbPscnugznjCqfrmXx2X9AoPkwc7w3oQzA6WNcVztChqMAA-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3YcAxgq3BBvpJaD8SrC84kkuBesqk516zKKp6ZtDzbbPscnugznjCqfrmXx2X9AoPkwc7w3oQzA6WNcVztChqMAA	Hdj3tAgSzNMmBHpArRNJLDjiKHSncMR2wqpistVsCNCQ	2022-09-29T01:06:37.000Z	SwapBaseOut	5Uh9WHghZwPfStZGQLLPWxnBZ7e5QPeB2SoDuC9xQGAb	675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8	2TTBuFgctDdV2XbAPaV4dLiEf5fNvGQCTJDQcsgzJukT	121	EZg32rLEgk7JxNA2ANsMNe7TdToy2JhgSERS4De8EyTq	[]	EjeN8tG8SP9Tb2zu9nPRpuWWmr1WiFQFB9oRnZDa2JoY	EZg32rLEgk7JxNA2ANsMNe7TdToy2JhgSERS4De8EyTq	F6eSqBZnbYWELWpPGXWooKRu2SNnTWJQV4wuTf2WfT1W	8Z89io5V2QTgGETTSYDbfJ1jDUu3hRchMKGStABB6vfq	Hpw3P5EiALv4Z5HCZ8mwpSRhzXofvRMQcpgcb7kRAGM1	8FMEm8zqc3B8g6GdmSwQi8fnmRxwNh4ycCtXBcSR1JG8	CSXAJGwaSvcf1XEXnWHiaoKrZgkP6oA88Eppyvus9bXn	AF5pJGJWWGi2HrZi66Yek1ir2BLTSdeenwKcTSxkZ4eJ

Example Query

Query with partition filter

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

CLMM_CreateAmmConfig_instruction

Automated Market Maker (AMM) configuration creation events from Raydium’s concentrated liquidity protocol on Solana, capturing fee parameters, tick spacing, and ownership data. Used for tracking liquidity pool parameter deployments and fee structure analysis across different pool configurations.

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.
`in_amm_config`	`STRING`	Address of the automated market maker configuration account. Base58-encoded Solana public key.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_fund_fee_rate`	`STRING`	Fund fee rate parameter for the AMM configuration, denominated in basis points. May be null in early protocol versions before this fee type was introduced.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_protocol_fee_rate`	`STRING`	Protocol fee rate charged by Raydium on pool trades, denominated in basis points. Value of 120000 represents 12% of trading fees going to protocol treasury.
`in_tick_spacing`	`STRING`	Minimum price movement increment for the automated market maker (AMM) pool, specified in ticks. Determines the granularity of liquidity positions, with smaller values allowing finer price control.
`in_trade_fee_rate`	`STRING`	Trading fee rate charged per swap expressed in basis points, where typical values range from 100 (0.01%) to 10000 (1%). This fee is collected by liquidity providers and protocol on each trade executed through the AMM pool.

Sample Data

in_index	in_owner	block_slot	in_amm_config	surrogate_key	transaction_id	block_timestamp	in_tick_spacing	in_fund_fee_rate	instruction_type	executing_account	in_system_program	in_trade_fee_rate	instruction_index	transaction_index	transaction_signer	in_protocol_fee_rate	outer_executing_account	outer_instruction_index
8	GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	259383702	3h2e43PunVA5K34vwKCLHWhZF4aZpyaC9RmxvshGAQpL	259383702-afHpNUw1hp3WF8ASmpSzYzV1bHsBXXuRjiThGyqSyySBi8Ty4vUAMN7eq4T6DkuPgGU9KGUNY9tLsbkJyjDSser-2-4	afHpNUw1hp3WF8ASmpSzYzV1bHsBXXuRjiThGyqSyySBi8Ty4vUAMN7eq4T6DkuPgGU9KGUNY9tLsbkJyjDSser	2024-04-10T15:37:20.000Z	1	40000	CreateAmmConfig	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	11111111111111111111111111111111	400	4	123	6KTbnuxCsDsJywdtDLqtgS9DD3q5pBTkRMsYev2q249v	120000	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
6	GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	259383702	EdPxg8QaeFSrTYqdWJn6Kezwy9McWncTYueD9eMGCuzR	259383702-afHpNUw1hp3WF8ASmpSzYzV1bHsBXXuRjiThGyqSyySBi8Ty4vUAMN7eq4T6DkuPgGU9KGUNY9tLsbkJyjDSser-2-0	afHpNUw1hp3WF8ASmpSzYzV1bHsBXXuRjiThGyqSyySBi8Ty4vUAMN7eq4T6DkuPgGU9KGUNY9tLsbkJyjDSser	2024-04-10T15:37:20.000Z	1	40000	CreateAmmConfig	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	11111111111111111111111111111111	200	0	123	6KTbnuxCsDsJywdtDLqtgS9DD3q5pBTkRMsYev2q249v	120000	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
7	GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	259383702	9EeWRCL8CJnikDFCDzG8rtmBs5KQR1jEYKCR5rRZ2NEi	259383702-afHpNUw1hp3WF8ASmpSzYzV1bHsBXXuRjiThGyqSyySBi8Ty4vUAMN7eq4T6DkuPgGU9KGUNY9tLsbkJyjDSser-2-2	afHpNUw1hp3WF8ASmpSzYzV1bHsBXXuRjiThGyqSyySBi8Ty4vUAMN7eq4T6DkuPgGU9KGUNY9tLsbkJyjDSser	2024-04-10T15:37:20.000Z	1	40000	CreateAmmConfig	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	11111111111111111111111111111111	300	2	123	6KTbnuxCsDsJywdtDLqtgS9DD3q5pBTkRMsYev2q249v	120000	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2

Example Query

Query with partition filter

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

CLMM_CreatePool_instruction

Concentrated Liquidity Market Maker (CLMM) pool creation instructions on Raydium V1 for Solana. Contains initialization parameters including token pair addresses, initial sqrt price, vault accounts, and pool configuration for tracking new automated market maker pool deployments.

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.
`in_amm_config`	`STRING`	Address of the automated market maker configuration account. Base58-encoded Solana public key.
`in_observation_state`	`STRING`	Solana account address that stores the price oracle observation data for this Concentrated Liquidity Market Maker (CLMM) pool. This state account tracks historical price points used for time-weighted average price (TWAP) calculations.
`in_pool_creator`	`STRING`	Solana account address of the wallet that initiated the pool creation transaction. Corresponds to the transaction_signer in all sample cases, indicating the entity deploying the new liquidity pool.
`in_pool_state`	`STRING`	Account address of the newly created concentrated liquidity pool state. Stores pool configuration, liquidity data, and price information for the Raydium CLMM pool.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_token_mint_0`	`STRING`	Mint address of the first token in the liquidity pool pair. Base-58 encoded Solana public key identifying the token’s mint account on-chain.
`in_token_mint_1`	`STRING`	Token mint address of the second token in the liquidity pool pair. Base58-encoded Solana program address identifying the SPL token.
`in_token_program_0`	`STRING`	Account address of the token program managing the first token in the pool pair. Typically references the SPL Token program or Token-2022 program on Solana.
`in_token_vault_0`	`STRING`	Account address of the token vault holding the first token (token_0) in the liquidity pool. This vault stores the actual tokens deposited by liquidity providers.
`in_token_vault_1`	`STRING`	Account address of the second token vault that holds the pool’s reserves for token 1. Owned by the pool program and stores the actual token balance.
`in_sqrt_price_x64`	`STRING`	Square root of the initial price ratio encoded as a 64-bit fixed-point number (Q64.64 format). Determines the starting exchange rate between the two tokens in the concentrated liquidity pool.

Sample Data

in_rent	block_slot	in_amm_config	in_pool_state	surrogate_key	transaction_id	block_timestamp	in_pool_creator	in_token_mint_0	in_token_mint_1	in_token_vault_0	in_token_vault_1	instruction_type	executing_account	in_sqrt_price_x64	in_system_program	instruction_index	transaction_index	in_token_program_0	transaction_signer	in_observation_state
SysvarRent111111111111111111111111111111111	185168450	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	DLTjS88vLNjqTkYb3meLvR8qNb3oAsGawxNjPmVas2pX	185168450-x1eSJLrqZhPpMHorEfmiZME7QKQmc3tFRxqSKmdMnXDvmfTnktxetnP4tK6nxRBMjmN8vGTVynEbeUTX1L4roSp-3	x1eSJLrqZhPpMHorEfmiZME7QKQmc3tFRxqSKmdMnXDvmfTnktxetnP4tK6nxRBMjmN8vGTVynEbeUTX1L4roSp	2023-03-28T12:53:20.000Z	23pLnzKqe2wkxVqsj2T4eyCHTGRBcDNv8jU9DFxk3F4d	6LXwc9ZyhTE74pyHrRPJeavjxBMxobGpt91x1jNCoSGa	9WMwGcY6TcbSfy9XPpQymY3qNEsvEaYL3wivdwPG2fpp	7iFsquJ6vfEY4CggYd9ufwpgXi4jews1cDkYtLERxZjh	28UboTfMuRns7hBtQG5VkRtFk9cUFMnoLc3sre9wmtWN	CreatePool	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	184467440737095516160	11111111111111111111111111111111	3	130	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	23pLnzKqe2wkxVqsj2T4eyCHTGRBcDNv8jU9DFxk3F4d	H7HKmyWHox3VrSxm4HB8UKn8acDgtLbos3XbizktCTde
SysvarRent111111111111111111111111111111111	185100640	A1BBtTYJd4i3xU8D6Tc2FzU6ZN4oXZWXKZnCxwbHXr8x	K3bbQbL7MgzPM668jAVCopZWDPtgWrp3z63ybyPY2CA	185100640-4oJGVuiCjYwFJqq3exwbxo3KbSJXggDyfGPPTDSBeJyt5PBrukKbD5Hoxz4JBtHEBqdpPDJmZLN24pgtEkh4NerA-3	4oJGVuiCjYwFJqq3exwbxo3KbSJXggDyfGPPTDSBeJyt5PBrukKbD5Hoxz4JBtHEBqdpPDJmZLN24pgtEkh4NerA	2023-03-28T04:19:38.000Z	2rsbbs2dwYEXKxvKezNzF4tJzxGJ9HHWgREz7ZfMLwcN	So11111111111111111111111111111111111111112	FoXyMu5xwXre7zEoSvzViRk3nGawHUp9kUh97y2NDhcq	4B4v8YwDLnMuSVZ2DPpQ3HWNFxKuq8HvdJnGoA2PtpPD	F9H567FLEys32yCzW7VanUxZ6REXVTZY3aWBwvzRbKs9	CreatePool	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	39831643903133259	11111111111111111111111111111111	3	106	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2rsbbs2dwYEXKxvKezNzF4tJzxGJ9HHWgREz7ZfMLwcN	6jd1aBmK37yYiMzdbvsHxpkWHADj7mCUatnW7oAjoD9
SysvarRent111111111111111111111111111111111	185221178	E64NGkDLLCdQ2yFNPcavaKptrEgmiQaNykUuLC1Qgwyp	7FEKKFVtLrBZAjESJdMuhLiADNzVcVAf9DZ9rbDdZBZA	185221178-sWjr6Wuke9DLR8EpB79z8RPCEcL3deps3a4f6czt6trPEvnDevArnDU5zgQGbfcy3wPBD95noWHB5NWsm4UpqLP-3	sWjr6Wuke9DLR8EpB79z8RPCEcL3deps3a4f6czt6trPEvnDevArnDU5zgQGbfcy3wPBD95noWHB5NWsm4UpqLP	2023-03-28T19:37:14.000Z	6dXuDRWGN5HWorvFHeqXktsUaoSb3o5v67hVzhxEXhFY	4WNRx7unUcc5wk6J6TqGq8nxX59RnhF2UDKaahgo9Z1R	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EuyFPDHWsUsrsWEbc8H8gBRaga9apdGN8BdrxT7Z75tS	Dky1ZNJb5WG2RM649UFGLMCUEffVG1Hx58w8rHa4H8mN	CreatePool	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	1844674407370955	11111111111111111111111111111111	3	16	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	6dXuDRWGN5HWorvFHeqXktsUaoSb3o5v67hVzhxEXhFY	CQxHK7Fvamxs6Asb8MLgGgAUj3f1TBzFZf86Rg1zTRaT

Example Query

Query with partition filter

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

CLMM_UpdateAmmConfig_instruction

Configuration update events for Raydium v1 CLMM (Concentrated Liquidity Market Maker) pools on Solana. Tracks parameter changes such as protocol addresses and fund recipients initiated by pool owners for governance and operational adjustments.

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.
`in_amm_config`	`STRING`	Address of the automated market maker configuration account. Base58-encoded Solana public key.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_remaining`	`ARRAY<JSON>`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_param`	`STRING`	Configuration parameters for automated market maker or protocol settings. Structured data containing fee ratios, margin requirements, and protocol-specific settings encoded as strings or structs.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_owner	in_param	block_slot	in_remaining	in_amm_config	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	3	279588484	[""projjosVCPQH49d5em7VYS7fJZzaqKixqKtus7yk416""]	Gex2NJRS3jVLPfbzSFM5d5DRsNoL5ynnwT1TXoDEhanz	279588484-5eXp6Z4Cgr8XrcdTTHGtDc29cKAkE5tYP8DoTb1kvSG4uSrofjDdZEEYQvMJ71LLQEZpCDf5A38GkpYYDBo59MZs-2-2	5eXp6Z4Cgr8XrcdTTHGtDc29cKAkE5tYP8DoTb1kvSG4uSrofjDdZEEYQvMJ71LLQEZpCDf5A38GkpYYDBo59MZs	2024-07-25T12:16:56.000Z	UpdateAmmConfig	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	2	1	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	4	279588484	[""FundHfY8oo8J9KYGyfXFFuQCHe7Z1VBNmsj84eMcdYs4""]	Gex2NJRS3jVLPfbzSFM5d5DRsNoL5ynnwT1TXoDEhanz	279588484-5eXp6Z4Cgr8XrcdTTHGtDc29cKAkE5tYP8DoTb1kvSG4uSrofjDdZEEYQvMJ71LLQEZpCDf5A38GkpYYDBo59MZs-2-3	5eXp6Z4Cgr8XrcdTTHGtDc29cKAkE5tYP8DoTb1kvSG4uSrofjDdZEEYQvMJ71LLQEZpCDf5A38GkpYYDBo59MZs	2024-07-25T12:16:56.000Z	UpdateAmmConfig	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	3	1	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	3	236605910	[""projjosVCPQH49d5em7VYS7fJZzaqKixqKtus7yk416""]	3XCQJQryqpDvvZBfGxR7CLAw5dpGJ9aa7kt1jRLdyxuZ	236605910-4nt9k4ijwVrxZukuSvdV98GA5HzmxcnpGx2xtVmmoSL1YrQeo4Tc38w3yCzxdgopuKxdYTqDJknM4NQ4D3hbwHto-1-2	4nt9k4ijwVrxZukuSvdV98GA5HzmxcnpGx2xtVmmoSL1YrQeo4Tc38w3yCzxdgopuKxdYTqDJknM4NQ4D3hbwHto	2023-12-18T12:52:27.000Z	UpdateAmmConfig	CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqK	2	61	6KTbnuxCsDsJywdtDLqtgS9DD3q5pBTkRMsYev2q249v	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	1

Example Query

Query with partition filter

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

CPMM_CreateAmmConfig_instruction

Instruction-level records for creating AMM (Automated Market Maker) configuration parameters on Raydium v1 CPMM protocol for Solana, including trade fees, protocol fees, fund fees, and pool creation costs. Used for tracking liquidity pool fee tier deployments and protocol governance changes.

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.
`in_amm_config`	`STRING`	Address of the automated market maker configuration account. Base58-encoded Solana public key.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_create_pool_fee`	`STRING`	Fee amount in lamports required to create a new liquidity pool using this AMM configuration. Typically set to 150,000,000 lamports (0.15 SOL) across most configurations.
`in_fund_fee_rate`	`STRING`	Fee rate allocated to the fund, expressed in basis points. Commonly set to 40000 (4%) across configurations based on sample values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_protocol_fee_rate`	`STRING`	Protocol fee rate as an integer basis point value applied to trades in this AMM configuration. Common values like 120000 represent 12% of total fees allocated to protocol revenue.
`in_trade_fee_rate`	`STRING`	Trade fee rate applied to swaps in basis points (1/10000ths), stored as a string integer. Sample values range from 2500 (0.25%) to 40000 (4.00%), configurable per AMM pool configuration.

Sample Data

in_index	in_owner	block_slot	in_amm_config	surrogate_key	transaction_id	block_timestamp	in_fund_fee_rate	instruction_type	executing_account	in_system_program	in_trade_fee_rate	instruction_index	transaction_index	in_create_pool_fee	transaction_signer	in_protocol_fee_rate	outer_executing_account	outer_instruction_index
2	GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	279550212	2fGXL8uhqxJ4tpgtosHZXT4zcQap6j62z3bMDxdkMvy5	279550212-61pvyDQF7xjLf5TFUwJa431cTcCtc5ncWfePTia5hE2aNc1fEu19CM2pQqYVXt7x2CB262VJnkZqPRYpCNahj5PD-2-2	61pvyDQF7xjLf5TFUwJa431cTcCtc5ncWfePTia5hE2aNc1fEu19CM2pQqYVXt7x2CB262VJnkZqPRYpCNahj5PD	2024-07-25T07:22:19.000Z	40000	CreateAmmConfig	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	11111111111111111111111111111111	20000	2	33	150000000	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	120000	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
1	GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	279550212	G95xxie3XbkCqtE39GgQ9Ggc7xBC8Uceve7HFDEFApkc	279550212-61pvyDQF7xjLf5TFUwJa431cTcCtc5ncWfePTia5hE2aNc1fEu19CM2pQqYVXt7x2CB262VJnkZqPRYpCNahj5PD-2-0	61pvyDQF7xjLf5TFUwJa431cTcCtc5ncWfePTia5hE2aNc1fEu19CM2pQqYVXt7x2CB262VJnkZqPRYpCNahj5PD	2024-07-25T07:22:19.000Z	40000	CreateAmmConfig	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	11111111111111111111111111111111	10000	0	33	150000000	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	120000	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
3	GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	279550212	C7Cx2pMLtjybS3mDKSfsBj4zQ3PRZGkKt7RCYTTbCSx2	279550212-61pvyDQF7xjLf5TFUwJa431cTcCtc5ncWfePTia5hE2aNc1fEu19CM2pQqYVXt7x2CB262VJnkZqPRYpCNahj5PD-2-4	61pvyDQF7xjLf5TFUwJa431cTcCtc5ncWfePTia5hE2aNc1fEu19CM2pQqYVXt7x2CB262VJnkZqPRYpCNahj5PD	2024-07-25T07:22:19.000Z	40000	CreateAmmConfig	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	11111111111111111111111111111111	40000	4	33	150000000	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	120000	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2

Example Query

Query with partition filter

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

CPMM_Initialize_instruction

Liquidity pool initialization events from Raydium’s Constant Product Market Maker (CPMM) program on Solana, capturing new pool creation with initial token deposits, LP mint addresses, and configuration parameters for analyzing pool launches and liquidity provision patterns.

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.
`in_amm_config`	`STRING`	Address of the automated market maker configuration account. Base58-encoded Solana public key.
`in_associated_token_program`	`STRING`	Account address of the Solana Associated Token Program invoked during pool initialization. Always set to the canonical program address ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL for managing token accounts.
`in_authority`	`STRING`	Account address authorized to perform the operation. Base58-encoded Solana public key or hex-encoded EVM address.
`in_create_pool_fee`	`STRING`	Account receiving the pool creation fee paid by the liquidity provider. Typically a protocol-controlled address that collects initialization fees.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator_lp_token`	`STRING`	Account address of the creator’s LP (Liquidity Provider) token account receiving pool shares. Base58-encoded Solana account identifier tracking the recipient of initial liquidity tokens.
`in_creator_token_0`	`STRING`	Account holding token0 owned by the pool creator used to fund initial liquidity. Debited during pool initialization to provide the in_init_amount_0 quantity.
`in_creator_token_1`	`STRING`	Account holding the creator’s token_1 balance that will be deposited as initial liquidity. This is the associated token account owned by the pool creator for the second token in the pair.
`in_lp_mint`	`STRING`	LP (Liquidity Provider) token mint address for the newly initialized pool. This is the address of the SPL token minted to represent liquidity shares in the Raydium CPMM pool.
`in_observation_state`	`STRING`	Account address storing historical price and liquidity observations for the pool’s oracle functionality. Used by the Raydium CPMM protocol to track time-weighted average prices (TWAP) and other statistical data.
`in_pool_state`	`STRING`	Pool state account address for this newly initialized Raydium CPMM liquidity pool. This account stores the pool’s configuration and state data on Solana.
`in_rent`	`STRING`	Address of the Solana Rent Sysvar account. Base58-encoded public key, constant value SysvarRent111111111111111111111111111111111.
`in_system_program`	`STRING`	Address of the Solana System Program. Base58-encoded public key, constant value 11111111111111111111111111111111.
`in_token_0_mint`	`STRING`	Account address of the first token in the liquidity pool pair being initialized. Base-58 encoded Solana address, typically SOL (So11111111111111111111111111111111111111112) or an SPL token mint.
`in_token_0_program`	`STRING`	Program account managing token 0 in the liquidity pool. Typically references the Solana Token Program or Token-2022 Program address.
`in_token_0_vault`	`STRING`	Vault account holding token 0 reserves for the liquidity pool. Base58-encoded Solana address managing pool’s first token balance.
`in_token_1_mint`	`STRING`	Token mint address for the second asset in the liquidity pool pair. Base-58 encoded Solana program address identifying the SPL token being paired with token_0.
`in_token_1_program`	`STRING`	Token program account managing token_1 operations in the liquidity pool. Typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL tokens or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022 standard.
`in_token_1_vault`	`STRING`	Account address holding token 1 reserves for the liquidity pool. This vault stores the pool’s balance of the second token in the trading pair.
`in_token_program`	`STRING`	Address of the Solana Token Program. Base58-encoded public key, constant value TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`in_init_amount_0`	`STRING`	Initial deposit amount of token_0 provided by the pool creator at initialization. Denominated in the token’s smallest unit (lamports for SOL, base units for SPL tokens).
`in_init_amount_1`	`STRING`	Initial deposit amount of token 1 provided by the pool creator to seed liquidity. Expressed as a raw token unit string without decimal adjustment.
`in_open_time`	`STRING`	Unix timestamp indicating when the liquidity pool becomes active for trading. Typically set to a future block time by the pool creator.

Sample Data

in_rent	block_slot	in_creator	in_lp_mint	in_authority	in_open_time	in_amm_config	in_pool_state	surrogate_key	transaction_id	block_timestamp	in_token_0_mint	in_token_1_mint	in_init_amount_0	in_init_amount_1	in_token_0_vault	in_token_1_vault	in_token_program	instruction_type	executing_account	in_system_program	instruction_index	transaction_index	in_create_pool_fee	in_creator_token_0	in_creator_token_1	in_token_0_program	in_token_1_program	transaction_signer	in_creator_lp_token	in_observation_state	in_associated_token_program
SysvarRent111111111111111111111111111111111	327429278	FEkXvzxjz1zcPh4qh5wWsypWd6WrjgAxiE7uzj2roGdZ	2x8jWV4tzHSoFCCtMmYc2knGJkCydwer97kc6ZMekdJQ	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	1742245279	2fGXL8uhqxJ4tpgtosHZXT4zcQap6j62z3bMDxdkMvy5	5rV4me9C1NDvR6Um456xL6XBZ2xP7YvVeSC79PGY5ukF	327429278-4feixxtqNbyjoqpN3mbVJmc8NFTEc1UwaLH96qwe5x47G9N7Ndab6GpMder5PnaCrYEZmyb3btZ66AXghtbMBTxX-4	4feixxtqNbyjoqpN3mbVJmc8NFTEc1UwaLH96qwe5x47G9N7Ndab6GpMder5PnaCrYEZmyb3btZ66AXghtbMBTxX	2025-03-17T21:00:31.000Z	So11111111111111111111111111111111111111112	Ct8FZBQr83TtHsgfDq5MZMQCPCuBCu3uYeQZP1exfmS2	10000	150000000000000000	3B2EQD875HraZwsvHnCxAtrqoXLAAVBiYCJuW8Nf3VrS	HVg7o5z84xtfTB8uhPrtutu1GvE8mnYkUcxUxpwrT4LV	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	11111111111111111111111111111111	4	56	DNXgeM9EiiaAbaWvwjHj9fQQLAX5ZsfHyvmYUNRAdNC8	GFK7cg9WLGKAnCPGXmjYxh8a6EUccc3Fq3G1wE5RYrN2	GXbrJeyDtGNdxBkbb3JHZos38yvB23y3fKGsSPRi8259	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	FEkXvzxjz1zcPh4qh5wWsypWd6WrjgAxiE7uzj2roGdZ	EYhhj2DDydcN96HsaxtpWoyi4rsZhEM4LteBoE9SjcLY	DQvZazZzJ9k9gb4FGuR7bfS7XS3ETUmaaWykFYDzQmcj	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
SysvarRent111111111111111111111111111111111	327267053	GXadeB5j8DwE3xNYBK6K9sa1uf53Y5rqwqJwy5Z7RmsL	6hqeGHjLn6vrHh7cZK2CNzZhDxNzP3UxGMMReDF4DcAt	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	1742180563	2fGXL8uhqxJ4tpgtosHZXT4zcQap6j62z3bMDxdkMvy5	BE6L29SqN5kB7nsaQbJBHFTiE48SD5HqCxHgZJ8V76kW	327267053-3AgmBE6FpX8AyMcu3er7zvAF9toiWW9M8hZTHZc6fLpg6BppJe7Vo1yKJgSUMvWjBUpBh7KBdu8p717ZPGxo5nTh-4	3AgmBE6FpX8AyMcu3er7zvAF9toiWW9M8hZTHZc6fLpg6BppJe7Vo1yKJgSUMvWjBUpBh7KBdu8p717ZPGxo5nTh	2025-03-17T03:01:55.000Z	So11111111111111111111111111111111111111112	FXsVdDk25R3fgDvxDW28xr4LTPsMtLSMQWtpsonuVbnk	10000000	900000000000000000	HwkKkURHHEYq23tiJX91YQUDYCmHtMa6oTmhLE6E6YXj	5m5K9vZQ2bE8Bb4bcF58ruCVuYr1wzxRoqZoxh3nX7kv	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	11111111111111111111111111111111	4	323	DNXgeM9EiiaAbaWvwjHj9fQQLAX5ZsfHyvmYUNRAdNC8	9NV1dkQjP5rBottP9dQkobtRd3HbgzBvmZVe56BQrUJK	2Hot11iXMvfSyRM3eSiTc1DU5kt5WEmWjREHDrY2w7i6	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	GXadeB5j8DwE3xNYBK6K9sa1uf53Y5rqwqJwy5Z7RmsL	DNqT1mChmByY3K5TV3hzTzU46bwm8DtSJqMS4dVFxmJP	9BRStHdBbEQqX1dcz4gCGAZkJvN8d2mVTg4NYVfGD9SF	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
SysvarRent111111111111111111111111111111111	327341551	A2EDaABtiq93zK33TvQQFT3uraBuqWCKT2TxzSaWcXDv	5EfaUpejBpk9EBA1Zs4uPxykXZMqHECmHRgip6mM3j2C	GpMZbSM2GgvTKHJirzeGfMFoaZ8UR2X7F4v8vHTvxFbL	1742210231	2fGXL8uhqxJ4tpgtosHZXT4zcQap6j62z3bMDxdkMvy5	88n54YRzuPhGRVd9vvo54dk3WUQfXyac9P1AJieaBxeL	327341551-3s8p1p2Kzpqw5qToXGu6ebnjVvDTGUkkmhV2TCoxuS7PTJcttnRSQSRLyp1QGpAXnWeCR7vYb51FcvCkcwLMhy8t-4	3s8p1p2Kzpqw5qToXGu6ebnjVvDTGUkkmhV2TCoxuS7PTJcttnRSQSRLyp1QGpAXnWeCR7vYb51FcvCkcwLMhy8t	2025-03-17T11:16:15.000Z	So11111111111111111111111111111111111111112	Ey4EKgsyuE1BhT13Epxcvh74b36teKWXuXsXECUrymqi	100000000	900000000000000000	5t7ymauh8Cnh7i7kGtB2TQ763yzNzcDgZvRWQtSzvHgf	G48tPtT7RDWz51m3F2bUAcCYaLca391cX39VpEPiStnu	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	Initialize	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	11111111111111111111111111111111	4	7	DNXgeM9EiiaAbaWvwjHj9fQQLAX5ZsfHyvmYUNRAdNC8	GjqPdNrLMg8XD5yWAsgyk7zRGMGo9p9DiMa1okPw957B	4hzwoU7LkDkFM8sNYUNmhBnSbcmhdXDTRejt3vv819Sr	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	A2EDaABtiq93zK33TvQQFT3uraBuqWCKT2TxzSaWcXDv	GHSpaCV3rJn6YYNuXYRGsu7MVDGUfce7awMUNwMJNfDU	FYoqEZCrYTyeEfxaL7uCKGwH3y55g92Prb2Smf3LM7nK	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL

Example Query

Query with partition filter

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

CPMM_UpdateAmmConfig_instruction

Configuration update instructions for Raydium’s Constant Product Market Maker (CPMM) pools on Solana. Tracks parameter changes to automated market maker (AMM) settings including owner modifications and configuration values for analyzing pool governance and parameter adjustments.

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.
`in_amm_config`	`STRING`	Address of the automated market maker configuration account. Base58-encoded Solana public key.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_remaining_0`	`STRING`	Account address for the first remaining account passed to this instruction. Additional accounts beyond standard instruction parameters used for protocol-specific functionality.
`in_param`	`STRING`	Configuration parameters for automated market maker or protocol settings. Structured data containing fee ratios, margin requirements, and protocol-specific settings encoded as strings or structs.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_owner	in_param	block_slot	in_amm_config	surrogate_key	in_remaining_0	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	3	344803354	B5u5x9S5pyaJdonf7bXUiEnBfEXsJWhNxXfLGAbRFtg2	344803354-28SjbDdShQHUNVNpp7V7V5f3t5KAhTUC4PrqQs6goDrPN5QKJGrRnv1aY23Cn9XCbuZWdttVYEMS22AmcF31gunf-2-2	ProCXqRcXJjoUd1RNoo28bSizAA6EEqt9wURZYPDc5u	28SjbDdShQHUNVNpp7V7V5f3t5KAhTUC4PrqQs6goDrPN5QKJGrRnv1aY23Cn9XCbuZWdttVYEMS22AmcF31gunf	2025-06-05T14:56:59.000Z	UpdateAmmConfig	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	2	2	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	4	344803354	B5u5x9S5pyaJdonf7bXUiEnBfEXsJWhNxXfLGAbRFtg2	344803354-28SjbDdShQHUNVNpp7V7V5f3t5KAhTUC4PrqQs6goDrPN5QKJGrRnv1aY23Cn9XCbuZWdttVYEMS22AmcF31gunf-2-3	FUNDduJTA7XcckKHKfAoEnnhuSud2JUCUZv6opWEjrBU	28SjbDdShQHUNVNpp7V7V5f3t5KAhTUC4PrqQs6goDrPN5QKJGrRnv1aY23Cn9XCbuZWdttVYEMS22AmcF31gunf	2025-06-05T14:56:59.000Z	UpdateAmmConfig	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	3	2	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2
GThUX1Atko4tqhN2NaiTazWSeFWMuiUvfFnyJyUghFMJ	3	343254941	BgxH5ifebqHDuiADWKhLjXGP5hWZeZLoCdmeWJLkRqLP	343254941-6Rtp1ZxfvdMeoBrsGfgwi74XWQADxpAQ33vGgTduceQYMmTCeNAaZiGPHwNryYHiRBkXieFT556Rm2Cbgcok6hH-2-2	ProCXqRcXJjoUd1RNoo28bSizAA6EEqt9wURZYPDc5u	6Rtp1ZxfvdMeoBrsGfgwi74XWQADxpAQ33vGgTduceQYMmTCeNAaZiGPHwNryYHiRBkXieFT556Rm2Cbgcok6hH	2025-05-29T13:47:42.000Z	UpdateAmmConfig	CPMMoo8L3F4NbTegBCKVNunggL7H1ZpdTHKxQB5qKP1C	2	2	8aSRiwajnkCP3ZhWTqTGJBy82ELo3Rt1CoEk5Hyjiqiy	SMPLecH534NA9acpos4G6x7uf3LWbCAwZQE9e8ZekMu	2

Example Query

Query with partition filter

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

LaunchLab_BuyExactIn_instruction

BuyExactIn instruction logs from Raydium’s LaunchLab token launch platform on Solana, recording exact input amount swaps with quote-to-base token conversions and slippage protection. Used for analyzing token launch trading activity, liquidity bootstrapping behavior, and early-stage market making patterns.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`base_token_mint`	`STRING`	Mint address of the base token in the liquidity pool. Base58-encoded Solana public key.
`base_token_program`	`STRING`	Program address of the Solana Token Program managing the base token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`base_vault`	`STRING`	Account address holding the base token reserves for the liquidity pool. Base58-encoded Solana public key.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`global_config`	`STRING`	Account address storing global protocol configuration parameters. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`platform_config`	`STRING`	Account address storing platform-specific fee and configuration parameters for the trading protocol. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`quote_token_mint`	`STRING`	Mint address of the quote token in the liquidity pool. Base58-encoded Solana public key.
`quote_token_program`	`STRING`	Program address of the Solana Token Program managing the quote token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`quote_vault`	`STRING`	Account address holding the quote token reserves for the liquidity pool. Base58-encoded Solana public key.
`user_base_token`	`STRING`	Account address holding the user’s base token balance for the swap transaction. Base58-encoded Solana public key.
`user_quote_token`	`STRING`	Account address holding the user’s quote token balance for the swap transaction. 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.
`share_fee_rate`	`BIGNUMERIC`	Fee rate applied to the transaction for revenue sharing or platform fees. Integer value representing basis points or rate denominator.
`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	program	amount_in	authority	base_vault	block_slot	pool_state	quote_vault	global_config	surrogate_key	transaction_id	base_token_mint	block_timestamp	event_authority	platform_config	user_base_token	instruction_type	quote_token_mint	user_quote_token	executing_account	instruction_index	transaction_index	base_token_program	minimum_amount_out	remaining_accounts	transaction_signer	quote_token_program
BQUSEMBpE4w1BuDVCKYzw46b2rZNLNVDLZZBrBwbNK1e	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	472841094	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	12tB3tWapU1HHV9jwZHiHjRvS58eaSA4gnPH3zxJmXCK	370109787	7T5vQp9q7qERteKc8TctS4fJAv3H2m6vZDtYJuFZBHp9	HUTBtGc9kiThz9eKidjCm3SFTPc8BVUs3ZzuokSgtmGA	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	370109787-4CbEQCsPkQ6VLuiWDopioQ8mu4fTHLgxkHpmbFQoGiAbLAqNieGPv2FWpApjNGhN51qA1cCsQqbN4cFA8PeTndAf-6	4CbEQCsPkQ6VLuiWDopioQ8mu4fTHLgxkHpmbFQoGiAbLAqNieGPv2FWpApjNGhN51qA1cCsQqbN4cFA8PeTndAf	CRY4yYVWa68XtTf2NKPo85ppsTyVShh8qGgsNvm9bonk	2025-09-29T20:00:42.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	5vtLrm9DFKb5swQyCVzzLkyQpt661jZS7u7hPDKZNEBg	BuyExactIn	So11111111111111111111111111111111111111112	FWh8uKcsvncLyDp57iVZ3rPCUtnxqWMsRsBLiSBTAtFS	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	6	308	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	8699883476599	[“11111111111111111111111111111111”,“AMWjewk8jvQkqyrUv5cowmbQdoS2ChbJopXXPtVqKtch”,“FAwRQ2DuarwoNGGAQMmgGRxowfYUvG7xbjtWbuJ4RDCB”]	BQUSEMBpE4w1BuDVCKYzw46b2rZNLNVDLZZBrBwbNK1e	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
56S29mZ3wqvw8hATuUUFqKhGcSGYFASRRFNT38W8q7G3	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	232722188	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	12tB3tWapU1HHV9jwZHiHjRvS58eaSA4gnPH3zxJmXCK	370111246	7T5vQp9q7qERteKc8TctS4fJAv3H2m6vZDtYJuFZBHp9	HUTBtGc9kiThz9eKidjCm3SFTPc8BVUs3ZzuokSgtmGA	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	370111246-hEkniX46pnNqa6mSFDURXP127EsMxVeBmRrAAL4hzsM7VwbqKSCwWbgs3ujGPRQB4LDatJ1sBawLxDZWykJ52kW-4	hEkniX46pnNqa6mSFDURXP127EsMxVeBmRrAAL4hzsM7VwbqKSCwWbgs3ujGPRQB4LDatJ1sBawLxDZWykJ52kW	CRY4yYVWa68XtTf2NKPo85ppsTyVShh8qGgsNvm9bonk	2025-09-29T20:10:22.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	49zahzYK4ZvgFqHg7u2GHGKGYCZXvTDRhRrnDCiXGezH	BuyExactIn	So11111111111111111111111111111111111111112	DA9tkbUk7ZEBa3hPMHcwwMRsTwV8fzSN23xfyNtw7cp7	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	4	81	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	0	[“11111111111111111111111111111111”,“AMWjewk8jvQkqyrUv5cowmbQdoS2ChbJopXXPtVqKtch”,“FAwRQ2DuarwoNGGAQMmgGRxowfYUvG7xbjtWbuJ4RDCB”]	56S29mZ3wqvw8hATuUUFqKhGcSGYFASRRFNT38W8q7G3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
9BzksH4SgBQ22251keN1kaAtcAuzeo6uzQGAroGKEutN	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	495000000	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	12tB3tWapU1HHV9jwZHiHjRvS58eaSA4gnPH3zxJmXCK	370111472	7T5vQp9q7qERteKc8TctS4fJAv3H2m6vZDtYJuFZBHp9	HUTBtGc9kiThz9eKidjCm3SFTPc8BVUs3ZzuokSgtmGA	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	370111472-2dbv3Ct5Mrg6YMWkVZDXspa6ZCP9R9qDoZ3vNFUiZmia6uAJjFAbQjBABYB6r96b8XBkUBAZsoKmMskSPMJ33nWJ-5	2dbv3Ct5Mrg6YMWkVZDXspa6ZCP9R9qDoZ3vNFUiZmia6uAJjFAbQjBABYB6r96b8XBkUBAZsoKmMskSPMJ33nWJ	CRY4yYVWa68XtTf2NKPo85ppsTyVShh8qGgsNvm9bonk	2025-09-29T20:11:52.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	E2yjWSRcSY5qdGJg9MGCCpyankUbXiGEMPY6BrvCHTEY	BuyExactIn	So11111111111111111111111111111111111111112	3hrbHc56i6CQoiTdPfX3cTiXEUu8mxNhRKrMv87b4wf2	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	5	55	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	7789691692233	[“11111111111111111111111111111111”,“AMWjewk8jvQkqyrUv5cowmbQdoS2ChbJopXXPtVqKtch”,“FAwRQ2DuarwoNGGAQMmgGRxowfYUvG7xbjtWbuJ4RDCB”]	9BzksH4SgBQ22251keN1kaAtcAuzeo6uzQGAroGKEutN	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA

Example Query

Query with partition filter

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

LaunchLab_BuyExactOut_instruction

Buy orders on Raydium LaunchLab token launch pools where users specify exact output amount of base token to receive, paying variable quote token (SOL). Used for analyzing token launch trading patterns and liquidity bootstrapping 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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`base_token_mint`	`STRING`	Mint address of the base token in the liquidity pool. Base58-encoded Solana public key.
`base_token_program`	`STRING`	Program address of the Solana Token Program managing the base token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`base_vault`	`STRING`	Account address holding the base token reserves for the liquidity pool. Base58-encoded Solana public key.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`global_config`	`STRING`	Account address storing global protocol configuration parameters. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`platform_config`	`STRING`	Account address storing platform-specific fee and configuration parameters for the trading protocol. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`quote_token_mint`	`STRING`	Mint address of the quote token in the liquidity pool. Base58-encoded Solana public key.
`quote_token_program`	`STRING`	Program address of the Solana Token Program managing the quote token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`quote_vault`	`STRING`	Account address holding the quote token reserves for the liquidity pool. Base58-encoded Solana public key.
`user_base_token`	`STRING`	Account address holding the user’s base token balance for the swap transaction. Base58-encoded Solana public key.
`user_quote_token`	`STRING`	Account address holding the user’s quote token balance for the swap transaction. Base58-encoded Solana public key.
`amount_out`	`BIGNUMERIC`	Output amount of tokens received from the swap or transaction. Integer value representing the quantity in the token’s smallest unit.
`maximum_amount_in`	`BIGNUMERIC`	Maximum input amount of quote tokens the buyer is willing to spend to acquire the exact output amount. Acts as a slippage protection limit; transactions fail if actual cost exceeds this cap.
`share_fee_rate`	`BIGNUMERIC`	Fee rate applied to the transaction for revenue sharing or platform fees. Integer value representing basis points or rate denominator.
`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	program	authority	amount_out	base_vault	block_slot	pool_state	quote_vault	global_config	surrogate_key	transaction_id	base_token_mint	block_timestamp	event_authority	platform_config	user_base_token	instruction_type	quote_token_mint	user_quote_token	executing_account	instruction_index	maximum_amount_in	transaction_index	base_token_program	remaining_accounts	transaction_signer	quote_token_program	outer_executing_account	outer_instruction_index
4CWcb55TUrTcANm79ysBApwQNgg7t7qNACPyBv6oZCTj	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	9999999999999	FbCX1yJoes6gaoHLACYHtShjfRsKJpPTTUitHNzj84qq	365210100	UfWa8gNgarFgj6JunmwNpGi5gDrRXANB5kZ8MYNPirt	3i6aaLMVJZup8LDbB9dEctnCynyJydf1th5sxsi7Aknj	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	365210100-2FDPJBnKi3T5nrgde3SZ9DJPAEWa6cjh685Cof117kjrcDV5Y8RGdv4hyRKGT5LE9ejXWYphy4k3LemPGWpkF7dC-4	2FDPJBnKi3T5nrgde3SZ9DJPAEWa6cjh685Cof117kjrcDV5Y8RGdv4hyRKGT5LE9ejXWYphy4k3LemPGWpkF7dC	AA5yc1DiqmozivVsW75L4ZYq49286w2w54EZ2Cjrbonk	2025-09-07T08:03:11.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	F91HKUNTHetm2ygKjdgTfaoUn7JJg5mrh1pcikP1PMRt	BuyExactOut	So11111111111111111111111111111111111111112	3eEpjbHwTJ2Ct6rMTdvZtr8m695vtGp2CHsE5gYxhjEL	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	4	294283050	213	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[“11111111111111111111111111111111”,“AMWjewk8jvQkqyrUv5cowmbQdoS2ChbJopXXPtVqKtch”,“Fc37hjLqqEE8qYtCpdVoyEUUxffL5SuK5fgoZ5S7XKPQ”]	4CWcb55TUrTcANm79ysBApwQNgg7t7qNACPyBv6oZCTj	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
FHt3ZnkKFzLt1wqjABpnB8xiSY1S1UVjtsNRhVeGWhFV	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	9999999999999	FbCX1yJoes6gaoHLACYHtShjfRsKJpPTTUitHNzj84qq	365210102	UfWa8gNgarFgj6JunmwNpGi5gDrRXANB5kZ8MYNPirt	3i6aaLMVJZup8LDbB9dEctnCynyJydf1th5sxsi7Aknj	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	365210102-p9bvDXRYAamjKJJSTyu8PVC4QzNt7Ti6G8B5Nc81tVPjtgBduRpSJxonqLKSUgyzA43svCjj1Q2mKSt1Kx7Zo2J-1-12	p9bvDXRYAamjKJJSTyu8PVC4QzNt7Ti6G8B5Nc81tVPjtgBduRpSJxonqLKSUgyzA43svCjj1Q2mKSt1Kx7Zo2J	AA5yc1DiqmozivVsW75L4ZYq49286w2w54EZ2Cjrbonk	2025-09-07T08:03:12.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	EVdsau9tKmWaE9ASeG2V5unERFVRDpAPY4HTysduVWF3	BuyExactOut	So11111111111111111111111111111111111111112	76pvKKrdyibxkeK33aEWJwSL9h319Cr1S2TEULpNV2qT	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	12	18446744073709551615	20	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[“11111111111111111111111111111111”,“AMWjewk8jvQkqyrUv5cowmbQdoS2ChbJopXXPtVqKtch”,“Fc37hjLqqEE8qYtCpdVoyEUUxffL5SuK5fgoZ5S7XKPQ”]	FHt3ZnkKFzLt1wqjABpnB8xiSY1S1UVjtsNRhVeGWhFV	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	FNFw8zBXCQ3frw8bpnUzd1cxgg2beH62S5VSxpJ29Ad	1
2GS66EF8TtHjnWfNyy87S7nxKMUydhbpd6EdXgygfm8k	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	5545964631845	FbCX1yJoes6gaoHLACYHtShjfRsKJpPTTUitHNzj84qq	365210103	UfWa8gNgarFgj6JunmwNpGi5gDrRXANB5kZ8MYNPirt	3i6aaLMVJZup8LDbB9dEctnCynyJydf1th5sxsi7Aknj	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	365210103-42EhXp1eV7WZLZauyUBc4twiL5wy2J7hAQJFbokeCVzzYBwDpGqR54aKzzTMNmDf7RqNkUnjLQPbpdr4fssqDNZn-1-12	42EhXp1eV7WZLZauyUBc4twiL5wy2J7hAQJFbokeCVzzYBwDpGqR54aKzzTMNmDf7RqNkUnjLQPbpdr4fssqDNZn	AA5yc1DiqmozivVsW75L4ZYq49286w2w54EZ2Cjrbonk	2025-09-07T08:03:12.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	FrZWp7dx5C4n4wUcx6Ggn4U4Q3e1M7eJ2afqnhqm1WQq	BuyExactOut	So11111111111111111111111111111111111111112	2Qznd8T1cHi9dLbUWebFSz8qjBzajxtDz8ji6wAibGG5	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	12	18446744073709551615	110	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[“11111111111111111111111111111111”,“AMWjewk8jvQkqyrUv5cowmbQdoS2ChbJopXXPtVqKtch”,“Fc37hjLqqEE8qYtCpdVoyEUUxffL5SuK5fgoZ5S7XKPQ”]	2GS66EF8TtHjnWfNyy87S7nxKMUydhbpd6EdXgygfm8k	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	FNFw8zBXCQ3frw8bpnUzd1cxgg2beH62S5VSxpJ29Ad	1

Example Query

Query with partition filter

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

LaunchLab_SellExactIn_instruction

Sell order executions from Raydium’s LaunchLab automated market maker (AMM) on Solana where users swap exact base token amounts for quote tokens. Used for analyzing token sales, price impact, and liquidity provider fee distribution across LaunchLab pools.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`base_token_mint`	`STRING`	Mint address of the base token in the liquidity pool. Base58-encoded Solana public key.
`base_token_program`	`STRING`	Program address of the Solana Token Program managing the base token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`base_vault`	`STRING`	Account address holding the base token reserves for the liquidity pool. Base58-encoded Solana public key.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`global_config`	`STRING`	Account address storing global protocol configuration parameters. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`platform_config`	`STRING`	Account address storing platform-specific fee and configuration parameters for the trading protocol. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`quote_token_mint`	`STRING`	Mint address of the quote token in the liquidity pool. Base58-encoded Solana public key.
`quote_token_program`	`STRING`	Program address of the Solana Token Program managing the quote token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`quote_vault`	`STRING`	Account address holding the quote token reserves for the liquidity pool. Base58-encoded Solana public key.
`user_base_token`	`STRING`	Account address holding the user’s base token balance for the swap transaction. Base58-encoded Solana public key.
`user_quote_token`	`STRING`	Account address holding the user’s quote token balance for the swap transaction. 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.
`share_fee_rate`	`BIGNUMERIC`	Fee rate applied to the transaction for revenue sharing or platform fees. Integer value representing basis points or rate denominator.
`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	program	amount_in	authority	base_vault	block_slot	pool_state	quote_vault	global_config	surrogate_key	transaction_id	base_token_mint	block_timestamp	event_authority	platform_config	user_base_token	instruction_type	quote_token_mint	user_quote_token	executing_account	instruction_index	transaction_index	base_token_program	minimum_amount_out	remaining_accounts	transaction_signer	quote_token_program
D3sovmjANgA8V27e5rnQft8kV3mocSH8gw9zwth3Ba9g	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	175914215825302	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	2cuRtrsfuGNfhdL9Xq5frVhrQrAof4SQbTpb6M3EWgje	369628251	BqzFWnt2H5r1Ks9ztjAJinoPRJLbShBUMxsQR9v618oR	5CtMJcx3QaNyobUsXQSzMWPPHczLoSykDYRrb2R97gDw	EPiZbnrThjyLnoQ6QQzkxeFqyL5uyg9RzNHHAudUPxBz	369628251-59Mtxdu7Yz6g8hYrY3LxPqwnRKbANQC99cUuuSkLcn4gxFL1HmiPUCbqd4BJx5DGoxiSnbepVFSPEknoNsy2Zujf-2	59Mtxdu7Yz6g8hYrY3LxPqwnRKbANQC99cUuuSkLcn4gxFL1HmiPUCbqd4BJx5DGoxiSnbepVFSPEknoNsy2Zujf	12s5HdvqwrHtKVHvc535sgNnfHTmyDUwfrPdt9a8bonk	2025-09-27T15:04:26.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	3XCDc78QkCfUEM8nye8vmnCu79nvU6StjeUpeGv6Sg2x	SellExactIn	USD1ttGY1N17NEEHLmELoaybftRBUSErhqYiQzvEmuB	FEFLT7z8Mx3szL8kd6zigsgDVqQgaG4Nw6UPV1D2YoGt	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	2	51	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1	[“11111111111111111111111111111111”,“67pirGqYiCT6j56DdQmAivWZSuZEtYbzSqMTWUNcHZAL”,“AdzxW9DA815msSnwnAuV6D44aCE6YBauBUA6e2Pirpfj”]	D3sovmjANgA8V27e5rnQft8kV3mocSH8gw9zwth3Ba9g	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
CaX2MFr6mGJ3FJpBHYQpMcWe3NTxdvNaim4kjEp9ES46	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	94163468805090	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	AB9NvGyACSQDya7a8agUU2sJTdBFnSm5WU6pK1yP33nV	369648053	6D5CSJsD5nWnHuE6eCW66nL9mTZdfoAYQsT7Z24zPFQQ	Fi9vRp49Jp6NywckpwaZYbXHkBLyGKNhFuKm8AnaTYq1	EPiZbnrThjyLnoQ6QQzkxeFqyL5uyg9RzNHHAudUPxBz	369648053-5TpbiJbRDVDqMrgzqKoijkhJPDu7quhpPAUbAoBVU71pHH4ue14WR2mycC2Anp352J7zp6uxodRx4hF1syFkPV6M-2	5TpbiJbRDVDqMrgzqKoijkhJPDu7quhpPAUbAoBVU71pHH4ue14WR2mycC2Anp352J7zp6uxodRx4hF1syFkPV6M	1M7VGN6LUgx4LkkAffKup9GynWahTd2poVw24JEbonk	2025-09-27T17:15:05.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	EQAAHj8iJ9HQ1oSFuaUZesWd7C7sU8bUWT3zgY59XsmL	SellExactIn	USD1ttGY1N17NEEHLmELoaybftRBUSErhqYiQzvEmuB	2iLMj1hkPQ9JG9mfQLqUztKZqrjzwCZf5CnHy94qHxns	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	2	14	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	418892669	[“11111111111111111111111111111111”,“67pirGqYiCT6j56DdQmAivWZSuZEtYbzSqMTWUNcHZAL”,“BrztV3tphpveid9VXP1TV5gbmqA8baCbNS9boPgJRHmg”]	CaX2MFr6mGJ3FJpBHYQpMcWe3NTxdvNaim4kjEp9ES46	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
ASHUNVCW4E63G5WnmaW5TywUTy4tVS2WE7xGGk3mVRTM	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	87710037991308	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	Csz5ZN4fXLx83be6x9n5iy3eGzUPzLdvkbMZbzFhncjJ	369517284	4Drm69wcjJjkFf8THcRKMmHxzBQ4qwRu6p5BivRZ4qAa	6CrNKUxE9AxVKVtoEqKYDyxb2ePXhiXYWWKTRxpt3rhS	EPiZbnrThjyLnoQ6QQzkxeFqyL5uyg9RzNHHAudUPxBz	369517284-3N9LGFJmUTpStbS9y7kQGLSpuokv8DXq7gGrCkrwSV98u1mfUzrNAbk8QkHRQWs4BJBfmivzJfJiYPaBte2d6X2s-3	3N9LGFJmUTpStbS9y7kQGLSpuokv8DXq7gGrCkrwSV98u1mfUzrNAbk8QkHRQWs4BJBfmivzJfJiYPaBte2d6X2s	1cg57Z6avmy6BXVARZchiGzmofpomyv5jUdyjjPa1Ap	2025-09-27T02:53:34.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	BhFAyLpE7WhAWECqJfuJmc6cMyeBDVMbBohrwqqRGKQ3	SellExactIn	USD1ttGY1N17NEEHLmELoaybftRBUSErhqYiQzvEmuB	9Ac6D2YQD6tmSajuwXgh8XoojTeBhaDCRD5w7JXRBb4Q	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	3	337	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	0	[“11111111111111111111111111111111”,“67pirGqYiCT6j56DdQmAivWZSuZEtYbzSqMTWUNcHZAL”,“7JYnCGK1WKyBnMuDsmpbfLc81yFNNeRK8bvPegX7heir”]	ASHUNVCW4E63G5WnmaW5TywUTy4tVS2WE7xGGk3mVRTM	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA

Example Query

Query with partition filter

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

LaunchLab_SellExactOut_instruction

Sell instructions from Raydium’s LaunchLab token launch platform on Solana specifying exact output token amounts with maximum input limits. Used for analyzing token sales where traders specify the exact amount they want to receive from selling base tokens for SOL (quote tokens).

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`base_token_mint`	`STRING`	Mint address of the base token in the liquidity pool. Base58-encoded Solana public key.
`base_token_program`	`STRING`	Program address of the Solana Token Program managing the base token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`base_vault`	`STRING`	Account address holding the base token reserves for the liquidity pool. Base58-encoded Solana public key.
`event_authority`	`STRING`	Account address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
`global_config`	`STRING`	Account address storing global protocol configuration parameters. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`platform_config`	`STRING`	Account address storing platform-specific fee and configuration parameters for the trading protocol. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`program`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`quote_token_mint`	`STRING`	Mint address of the quote token in the liquidity pool. Base58-encoded Solana public key.
`quote_token_program`	`STRING`	Program address of the Solana Token Program managing the quote token account operations. Base58-encoded Solana public key, consistently TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA.
`quote_vault`	`STRING`	Account address holding the quote token reserves for the liquidity pool. Base58-encoded Solana public key.
`user_base_token`	`STRING`	Account address holding the user’s base token balance for the swap transaction. Base58-encoded Solana public key.
`user_quote_token`	`STRING`	Account address holding the user’s quote token balance for the swap transaction. Base58-encoded Solana public key.
`amount_out`	`BIGNUMERIC`	Output amount of tokens received from the swap or transaction. Integer value representing the quantity in the token’s smallest unit.
`maximum_amount_in`	`BIGNUMERIC`	Maximum amount of quote tokens the user is willing to spend to receive the exact amount of base tokens specified. Protects against unfavorable price movement during transaction execution (slippage tolerance).
`share_fee_rate`	`BIGNUMERIC`	Fee rate applied to the transaction for revenue sharing or platform fees. Integer value representing basis points or rate denominator.
`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	program	authority	amount_out	base_vault	block_slot	pool_state	quote_vault	global_config	surrogate_key	transaction_id	base_token_mint	block_timestamp	event_authority	platform_config	user_base_token	instruction_type	quote_token_mint	user_quote_token	executing_account	instruction_index	maximum_amount_in	transaction_index	base_token_program	remaining_accounts	transaction_signer	quote_token_program
3yfDeYHN1kUAdV49eKpoSTxXpT8QfuM1v9cyvkPvQKkj	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	42746200000	7haCG9HmwAnyVbT6eFyFMTHqSqbq4urxQFwX39BGBB67	348856037	E2YwziKS6rZFRug8vAkRSbNc2jzoCVQVDunweG7pgM6q	DGCgaxFX4HvLpw1zrjdiG7UnYZH6sKdDYR2VfovSXbFi	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	348856037-3fLbY8pUHvuT4DKRPsakijgoZKAWnCqhgrRsbAJs8NokYXtrMAXEUeMXD78GzQE3TFPvn5NZkvXdrkKVxkhbChFY-1	3fLbY8pUHvuT4DKRPsakijgoZKAWnCqhgrRsbAJs8NokYXtrMAXEUeMXD78GzQE3TFPvn5NZkvXdrkKVxkhbChFY	Maw8KrBQ3m6kcMZzzC982qfb2j9yiSjvWyc7WFxpump	2025-06-24T08:34:41.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	4tA3qd9uSkSXCYLHr14FM54AK1VjLbhEpabY1Z1xRbfM	SellExactOut	So11111111111111111111111111111111111111112	bg41P2GHwNUiNHr95zvHBg6hHjrHihSDvv54c5gJzkY	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	1	1000000000000000	195	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	3yfDeYHN1kUAdV49eKpoSTxXpT8QfuM1v9cyvkPvQKkj	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
ZV479ubwoHoTRaX3C282ro3JEABueaSLivZWcqn6MpY	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	59993956	5UedDTKye6QHmDkvTFcxS1yCPvSF8nbS3ku938Q4WLCH	348924106	8jCFpeoPwcb8DqLkCov7oqGLujSKzXb8QWETXSxSQqDo	9uziTrVSaGWaPMn1M2DLYrGHKqLHa5nrgmxEPKb37SYy	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	348924106-3ZJz3ZFyWAH25c61fNZMQmHMtYBhNFQo8PCtyHQNydEgG8pUqqjVtD5ZM9AKQ6mkfpWHyHC7qqACg7UDcDfBZFQ1-5	3ZJz3ZFyWAH25c61fNZMQmHMtYBhNFQo8PCtyHQNydEgG8pUqqjVtD5ZM9AKQ6mkfpWHyHC7qqACg7UDcDfBZFQ1	2DtzQBnFLEKupVfVpQhv7bHbe5WGntB6CkKiFuR8bonk	2025-06-24T16:11:59.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	FfYek5vEz23cMkWsdJwG2oa6EphsvXSHrGpdALN4g6W1	8UaP1qbDmkrdpwx7zy1QBAaqiRrnZqdEia1gTpAQoXj5	SellExactOut	So11111111111111111111111111111111111111112	3wTMsX6RuXLn2DacmjhmUmH4au2ZiVY7uYDuPuYHqvzf	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	5	271538847599	120	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	ZV479ubwoHoTRaX3C282ro3JEABueaSLivZWcqn6MpY	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA
Da3CGEpo98f2TyLJtTYBP4KKD2w2Gm1JTFbymW8oG32W	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	WLHv2UAZm6z4KyaaELi5pjdbJh6RESMva1Rnn8pJVVh	100000000	A2nd7H2BJfTWPRC4nyZdo8qxEJCgLCK7zcubrCz3mfGj	348992388	A7CUHkyxj5p35beZNpKdx6sHQLgNZHGLFTisU8Drfz5P	CUK6X3weuJudk1Rjfen2tXim3fc9PG6fuSFnqtyHEPax	6s1xP3hpbAfFoNtUNF8mfHsjr2Bd97JxFJRWLbL6aHuX	348992388-4c13TsuuhLbWmHpPdVuLZtR2Toru6NhvABrZQMpNFM1n4qbk7ke7ndx9tsFSHtcPNJM9JRKcvuCReLUgL9cSiXsg-5	4c13TsuuhLbWmHpPdVuLZtR2Toru6NhvABrZQMpNFM1n4qbk7ke7ndx9tsFSHtcPNJM9JRKcvuCReLUgL9cSiXsg	EEzUi8Z8KKpTqchsTsn8Nj9ZtXqnwnpaXvXYRougbonk	2025-06-24T23:50:06.000Z	2DPAtwB8L12vrMRExbLuyGnC7n2J5LNoZQSejeQGpwkr	BuM6KDpWiTcxvrpXywWFiw45R2RNH8WURdvqoTDV1BW4	CdS5mdAamUQDHFmGF3ecCD8sE4wbpKbtgvL6MJ9MzJkg	SellExactOut	So11111111111111111111111111111111111111112	38QdE2SUEmZ9K8PJ2P5SZSAgXaE4ibm2j8MiAY24hzhW	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	5	1156611944743	46	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	[]	Da3CGEpo98f2TyLJtTYBP4KKD2w2Gm1JTFbymW8oG32W	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA

Example Query

Query with partition filter

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

LaunchLab_TradeEvent_instruction

Trade execution events from Raydium’s LaunchLab token launchpad on Solana, capturing swap details including amounts, directions, pool states, and fee breakdowns. Tracks virtual and real liquidity balances before/after each trade for analyzing bonding curve mechanics and early-stage token 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.
`amount_in`	`STRING`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`amount_out`	`STRING`	Output amount of tokens received from the swap or transaction. Integer value representing the quantity in the token’s smallest unit.
`platform_fee`	`STRING`	Platform fee charged by Raydium’s LaunchLab protocol on this trade, denominated in the smallest token unit. Represents the protocol’s revenue share from the swap transaction.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`pool_status`	`STRING`	Pool operational state at the time of the trade, indicating the liquidity provisioning phase. Value “Fund” indicates the pool is in the funding phase before full launch.
`protocol_fee`	`STRING`	Fee collected by the Raydium protocol from this trade, denominated in the smallest token unit (lamports for SOL). Typically represents a percentage of the total trade value, as seen in sample values like ‘2824811’ or ‘29377524’.
`real_base_after`	`STRING`	Quantity of base token in the liquidity pool after the trade was executed. Stored as string-encoded integer to preserve precision for large token amounts.
`real_base_before`	`STRING`	Base token reserve in the liquidity pool before the trade executed, denominated in the token’s smallest unit (lamports). Used to calculate price impact and actual token amounts for automated market maker (AMM) swaps.
`real_quote_after`	`STRING`	Pool’s quote token reserves after the trade execution, denominated in the quote token’s smallest unit. Represents the ending liquidity state of the quote side of the trading pair.
`real_quote_before`	`STRING`	Liquidity pool’s quote token reserve balance before the trade execution. Stored as a string-encoded integer representing the smallest denomination of the quote token (e.g., lamports for SOL).
`share_fee`	`STRING`	Fee amount distributed to liquidity pool token holders as trading rewards. Consistently zero in sample data, suggesting this fee type may be inactive or conditionally applied.
`total_base_sell`	`STRING`	Total amount of base token available for sale in the liquidity pool. Typically represents the initial token supply allocated for trading in Raydium LaunchLab pools.
`trade_direction`	`STRING`	Direction of the token swap in the trade. Value is either “Sell” (selling base token for quote token) or “Buy” (buying base token with quote token).
`virtual_base`	`STRING`	Virtual base token reserve used for pricing calculations in Raydium’s LaunchLab bonding curve mechanism. This value differs from real_base and represents the theoretical reserve that determines the current token price based on the automated market maker (AMM) formula.
`virtual_quote`	`STRING`	Virtual quote token reserve amount used for pricing in the pool’s bonding curve. Denominated in the smallest unit of the quote token (typically SOL lamports or USDC base units).

Sample Data

amount_in	amount_out	block_slot	pool_state	pool_status	platform_fee	protocol_fee	virtual_base	surrogate_key	virtual_quote	transaction_id	block_timestamp	real_base_after	total_base_sell	trade_direction	instruction_type	real_base_before	real_quote_after	executing_account	instruction_index	real_quote_before	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
27154259544904004	1115800313	336276297	2e4rgi4LNps2MMMTThYZChoPoH9MsHUnj8cenCxxyGND	Fund	11299244	2824811	1073025605596382859	336276297-5z8LEEnGhHgeTkiEexPzvK4G8UmcHeaXKAJn1eBbaJs5Rx7PW3roVXx8bcN1XqJKUug7Uu5rJ8muhGsVWUifeh2j-1-1	30000852951	5z8LEEnGhHgeTkiEexPzvK4G8UmcHeaXKAJn1eBbaJs5Rx7PW3roVXx8bcN1XqJKUug7Uu5rJ8muhGsVWUifeh2j	2025-04-27T16:13:50.000Z	179782338815374395	793100000000000000	Sell	TradeEvent	206936598360278399	6038247039	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	1	7168171407	17	GHPCChGqtKf4sFaN1wPPCapcweKXBBngB3hF7D6nT29e	AQdoMDeM9t7xTuL6KmeraRMnghG6QapcfYuKRm2h9aqR	1
83411108132496	11604121923	336266358	C1QCjQMt3UuYQFo6H5dpuZLNuX98NkYKyJG3FaKzAaQ3	Fund	117510096	29377524	1073025605596382	336266358-48JjSFGKapr84nQn2dxuB5AGSkKtyF7Nr4t5JEnyRZM6naERQMfDnmAJjBYVitY6y3xJq37NKKF6MZv4QnxJ9bSf-1-1	30000852951	48JjSFGKapr84nQn2dxuB5AGSkKtyF7Nr4t5JEnyRZM6naERQMfDnmAJjBYVitY6y3xJq37NKKF6MZv4QnxJ9bSf	2025-04-27T15:08:16.000Z	551484024272265	793100000000000	Sell	TradeEvent	634895132404761	31723244561	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	1	43474254104	58	DwYVzJaAW683T474NP2nAe7S84cLrbhsUWqCcKko9Lr8	J76gkJ6F6ZHwb3reJq9LhghpEbSFGNPmepMEAveGisR6	1
34946606981025	12572778763	336301425	HxQCNiWLRg56m4YFfAP7piDZCaZqK7LMAcEUYVyJA7fV	Fund	127319279	31829820	1073025605596382	336301425-24QFCBqGM5RsQfBMVtMLdC9FujcPL1FmwojDzpvzhSEh5vkwWPgmJahGyme13R8mfWrT4zVNaAZK1XoUM9wFoz1y-1-1	30000852951	24QFCBqGM5RsQfBMVtMLdC9FujcPL1FmwojDzpvzhSEh5vkwWPgmJahGyme13R8mfWrT4zVNaAZK1XoUM9wFoz1y	2025-04-27T18:59:33.000Z	757785484300954	793100000000000	Sell	TradeEvent	792732091281979	72117123952	LanMV9sAd7wArD4vJFi2qDdfnVhFxYSUg6eADduJ3uj	1	84849051814	257	GHPCChGqtKf4sFaN1wPPCapcweKXBBngB3hF7D6nT29e	AQdoMDeM9t7xTuL6KmeraRMnghG6QapcfYuKRm2h9aqR	1

Example Query

Query with partition filter

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

StableSwapAmm_SwapBaseIn_instruction

SwapBaseIn instruction records from Raydium’s v1 stablecoin automated market maker (AMM) pools on Solana. Captures swap executions with input amounts, minimum output requirements, and vault addresses for analyzing stablecoin trading patterns.

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_account`	`STRING`	Account address of the Raydium Automated Market Maker (AMM) pool facilitating this stableswap operation. Identifies the specific liquidity pool on Solana where the token swap is executed.
`amm_open_orders`	`STRING`	Account address managing open orders for the automated market maker pool on the Serum decentralized exchange. Base58-encoded Solana public key.
`amm_target_orders`	`STRING`	Account address for the automated market maker’s target orders on the Serum decentralized exchange. Base58-encoded Solana public key.
`asks`	`STRING`	Solana address of the order book account holding all ask (sell) orders for this Raydium stableswap pool on Serum DEX. This account is queried during swaps to find available liquidity on the sell side.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`bids`	`STRING`	Solana account address for the bids side of the Serum decentralized exchange order book. Used by the Raydium AMM to route swap orders through the underlying Serum market.
`coin_vault`	`STRING`	Solana account address holding the base token (coin side) reserves for this Raydium stableswap pool. Base58-encoded, typically 32-44 characters.
`event_q`	`STRING`	Solana account address of the Serum DEX event queue used by this AMM pool. The event queue stores pending order match events for the associated Serum market.
`pc_vault`	`STRING`	Solana account address holding the quote currency (PC - price currency) reserves for the Raydium stableswap pool. This vault stores one side of the trading pair that users swap against.
`pool_token_coin`	`STRING`	Token account holding the coin-side liquidity pool tokens for this Automated Market Maker (AMM). Represents the base asset in the trading pair.
`pool_token_pc`	`STRING`	Token account holding the liquidity pool’s “price currency” (quote token) reserves for the stableswap AMM. Represented as a base58-encoded Solana account address.
`serum_dex_program_id`	`STRING`	Solana program address for the Serum DEX (Decentralized Exchange) integration used by this Raydium swap. Base58-encoded identifier, typically `9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin` for Serum v3.
`serum_market`	`STRING`	Account address of the Serum decentralized exchange market for the trading pair. Base58-encoded Solana public key.
`spl_token_program`	`STRING`	SPL Token Program address invoked to facilitate the token transfer during the swap. Always set to the standard Solana Program Library token program identifier on this chain.
`user_destination_token`	`STRING`	Account address of the user’s token account receiving the output tokens from the swap. Base58-encoded Solana public key.
`user_owner`	`STRING`	Solana account address that owns the user source token account initiating the swap. Base58-encoded public key identifying the wallet authority for the transaction.
`user_source_token`	`STRING`	Account address of the user’s token account providing the input tokens for the swap. Base58-encoded Solana public key.
`vault_signer`	`STRING`	Solana account authorized to sign vault token transfers on behalf of the AMM. Base58-encoded public key derived from the program’s PDA (Program Derived Address).
`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

asks	bids	event_q	pc_vault	amount_in	authority	block_slot	coin_vault	user_owner	amm_account	serum_market	vault_signer	pool_token_pc	surrogate_key	transaction_id	amm_open_orders	block_timestamp	pool_token_coin	instruction_type	amm_target_orders	executing_account	instruction_index	spl_token_program	transaction_index	user_source_token	remaining_accounts	transaction_signer	serum_dex_program_id	user_destination_token	outer_executing_account	outer_instruction_index
HUCmvkqFdwixBBMm2vMgaBfJ5ArY5b7RqfYbACjCPhpp	AXTKA59Xd53s5a26PNALtnmqfJUWzdyuPN1w5qFMHGio	DMPcCyyqqDhxU852FU6rP6bCy6dfWGWjg2KF21y9DFt4	D6xgt4XSTRFAqctmY5byT4Ji7mvTihfnuNxjJWPETe7M	4097891	3uaZBfHPfmpAHW7dsimC1SnyR61X4bJqQZKWmRSCXJxv	228122533	3E3J4Ua9DPM5fdmRxB1AM6S5NqbhBh9exudHcs5jgumz	BVhqPeMZYar4xjpqmmyknhsA6xRvKvMLcSocx7rR5hCd	9DTY3rv8xRa3CnoPoWJCMcQUSY7kUHZAoFKNsBhx8DDz	CaFjigEgJdtGPxQxRjneA1hzNcY5MsHoAAL6Et67QrC5	PmGWi4jXyde5y4ed8GdF1Son68LioBRGuazkCoJM8B2	CDSr3ssLcRB6XYPJwAfFt18MZvEZp4LjHcvzBVZ45duo	228122533-5gUF5AswshcBw2MFV9FXCnMJXfdHMD9VEeexJkBeSvDApBHjq9z93nsob5caXtrwCUP83bEaNqBx9QKdhLTXtZ42-2-10	5gUF5AswshcBw2MFV9FXCnMJXfdHMD9VEeexJkBeSvDApBHjq9z93nsob5caXtrwCUP83bEaNqBx9QKdhLTXtZ42	2a1H2xUFdja6RjPJ6RKWDLraURNCEY85LdP3GXcDeg8y	2023-11-05T09:33:36.000Z	PH3UpBfXJNazcFtUuxHMFtwtoAYJM9trKMCTqgYX8ZA	SwapBaseIn	8WhX9Y6cDkVUhBmm1TT83jX2vT7ZGwXv6zAQiUg84B5U	5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h	10	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	52	21hDE9d2kGUdsFcy2gHZyZNV43WePwVFH92sRNAPFg8p	[]	BVhqPeMZYar4xjpqmmyknhsA6xRvKvMLcSocx7rR5hCd	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	Vsf9rHRwMp2UnsuBXizdPwaddoCeYxyN6EJqpYYVMQK	3J3HFc8jXxdvZQ73PeUPJmPdM2EKpKonzBaYACCXzqkv	2
HUCmvkqFdwixBBMm2vMgaBfJ5ArY5b7RqfYbACjCPhpp	AXTKA59Xd53s5a26PNALtnmqfJUWzdyuPN1w5qFMHGio	DMPcCyyqqDhxU852FU6rP6bCy6dfWGWjg2KF21y9DFt4	D6xgt4XSTRFAqctmY5byT4Ji7mvTihfnuNxjJWPETe7M	4574215	3uaZBfHPfmpAHW7dsimC1SnyR61X4bJqQZKWmRSCXJxv	228122532	3E3J4Ua9DPM5fdmRxB1AM6S5NqbhBh9exudHcs5jgumz	BVhqPeMZYar4xjpqmmyknhsA6xRvKvMLcSocx7rR5hCd	9DTY3rv8xRa3CnoPoWJCMcQUSY7kUHZAoFKNsBhx8DDz	CaFjigEgJdtGPxQxRjneA1hzNcY5MsHoAAL6Et67QrC5	PmGWi4jXyde5y4ed8GdF1Son68LioBRGuazkCoJM8B2	CDSr3ssLcRB6XYPJwAfFt18MZvEZp4LjHcvzBVZ45duo	228122532-2jgUPopQ89TrekqVdDgWcUzWZuWK8Fnij9JWpE3ctM9nk4AzUUz23XbYnbH9Sm2KQyZBvETNLN8x9KCJwvF7B3u2-2-10	2jgUPopQ89TrekqVdDgWcUzWZuWK8Fnij9JWpE3ctM9nk4AzUUz23XbYnbH9Sm2KQyZBvETNLN8x9KCJwvF7B3u2	2a1H2xUFdja6RjPJ6RKWDLraURNCEY85LdP3GXcDeg8y	2023-11-05T09:33:36.000Z	PH3UpBfXJNazcFtUuxHMFtwtoAYJM9trKMCTqgYX8ZA	SwapBaseIn	8WhX9Y6cDkVUhBmm1TT83jX2vT7ZGwXv6zAQiUg84B5U	5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h	10	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	51	21hDE9d2kGUdsFcy2gHZyZNV43WePwVFH92sRNAPFg8p	[]	BVhqPeMZYar4xjpqmmyknhsA6xRvKvMLcSocx7rR5hCd	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	Vsf9rHRwMp2UnsuBXizdPwaddoCeYxyN6EJqpYYVMQK	3J3HFc8jXxdvZQ73PeUPJmPdM2EKpKonzBaYACCXzqkv	2
HUCmvkqFdwixBBMm2vMgaBfJ5ArY5b7RqfYbACjCPhpp	AXTKA59Xd53s5a26PNALtnmqfJUWzdyuPN1w5qFMHGio	DMPcCyyqqDhxU852FU6rP6bCy6dfWGWjg2KF21y9DFt4	D6xgt4XSTRFAqctmY5byT4Ji7mvTihfnuNxjJWPETe7M	7027365	3uaZBfHPfmpAHW7dsimC1SnyR61X4bJqQZKWmRSCXJxv	228137318	3E3J4Ua9DPM5fdmRxB1AM6S5NqbhBh9exudHcs5jgumz	BVhqPeMZYar4xjpqmmyknhsA6xRvKvMLcSocx7rR5hCd	9DTY3rv8xRa3CnoPoWJCMcQUSY7kUHZAoFKNsBhx8DDz	CaFjigEgJdtGPxQxRjneA1hzNcY5MsHoAAL6Et67QrC5	PmGWi4jXyde5y4ed8GdF1Son68LioBRGuazkCoJM8B2	CDSr3ssLcRB6XYPJwAfFt18MZvEZp4LjHcvzBVZ45duo	228137318-368xZdYDjbdDZVJM251aH7ryiZtizDv5eqFs7Q2DNzbZHU2KtPHWnM3WqFNR6ivgv1c9fsv1XpA2UBnRtPuRthGG-2-11	368xZdYDjbdDZVJM251aH7ryiZtizDv5eqFs7Q2DNzbZHU2KtPHWnM3WqFNR6ivgv1c9fsv1XpA2UBnRtPuRthGG	2a1H2xUFdja6RjPJ6RKWDLraURNCEY85LdP3GXcDeg8y	2023-11-05T11:15:36.000Z	PH3UpBfXJNazcFtUuxHMFtwtoAYJM9trKMCTqgYX8ZA	SwapBaseIn	8WhX9Y6cDkVUhBmm1TT83jX2vT7ZGwXv6zAQiUg84B5U	5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h	11	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	17	21hDE9d2kGUdsFcy2gHZyZNV43WePwVFH92sRNAPFg8p	[]	BVhqPeMZYar4xjpqmmyknhsA6xRvKvMLcSocx7rR5hCd	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	Vsf9rHRwMp2UnsuBXizdPwaddoCeYxyN6EJqpYYVMQK	3J3HFc8jXxdvZQ73PeUPJmPdM2EKpKonzBaYACCXzqkv	2

Example Query

Query with partition filter

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

StableSwapAmm_SwapBaseOut_instruction

Raydium V1 stable swap instructions where traders specify exact output amount to receive and pay variable input. Used for analyzing stablecoin swap execution patterns and slippage tolerance on Solana.

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_account`	`STRING`	Account address of the Raydium Automated Market Maker (AMM) pool executing this stableswap instruction. Base58-encoded Solana address that uniquely identifies the liquidity pool configuration.
`amm_open_orders`	`STRING`	Account address managing open orders for the automated market maker pool on the Serum decentralized exchange. Base58-encoded Solana public key.
`amm_target_orders`	`STRING`	Account address for the automated market maker’s target orders on the Serum decentralized exchange. Base58-encoded Solana public key.
`asks`	`STRING`	Account address for the asks order book side in the Serum DEX market integrated with this Raydium stableswap pool. Base58-encoded Solana public key representing the asks data structure.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`bids`	`STRING`	Account holding bid orders on the Serum DEX market for this AMM pool. Base58-encoded Solana address identifying the orderbook state account.
`coin_vault`	`STRING`	Solana token account address holding the base (coin) token reserves for this AMM pool. This vault stores the liquidity for the base side of the trading pair.
`event_q`	`STRING`	Solana account address of the Serum event queue for the associated market. Used to track order fills and market events for the stableswap pool’s underlying DEX integration.
`pc_vault`	`STRING`	Account address of the price coin (quote token) vault holding the pool’s quote-side liquidity. Base58-encoded Solana public key corresponding to the stablecoin or quote asset reserves.
`pool_token_coin`	`STRING`	Account holding the base token (coin-side) pool reserves for the Raydium stable swap AMM. This is the vault containing the first token in the trading pair.
`pool_token_pc`	`STRING`	Pool token account address for the quote currency (PC) side of the liquidity pair. Represents the stablecoin or secondary asset in Raydium’s stable swap automated market maker (AMM).
`serum_dex_program_id`	`STRING`	Program ID of the Serum DEX instance used for order book operations in this stable swap. Consistently appears as `9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin` across all sample transactions.
`serum_market`	`STRING`	Account address of the Serum decentralized exchange market for the trading pair. Base58-encoded Solana public key.
`spl_token_program`	`STRING`	Program ID for the Solana Program Library (SPL) Token program used in this swap instruction. Always references the standard SPL Token program on Solana mainnet.
`user_destination_token`	`STRING`	Account address of the user’s token account receiving the output tokens from the swap. Base58-encoded Solana public key.
`user_owner`	`STRING`	Account address of the user initiating the swap transaction. Base58-encoded Solana public key that owns the source and destination token accounts.
`user_source_token`	`STRING`	Account address of the user’s token account providing the input tokens for the swap. Base58-encoded Solana public key.
`vault_signer`	`STRING`	Vault authority account that signs transactions on behalf of the Raydium AMM pool. Base58-encoded Solana program-derived address (PDA) with signing privileges for vault operations.
`amount_out`	`BIGNUMERIC`	Output amount of tokens received from the swap or transaction. Integer value representing the quantity in the token’s smallest unit.
`max_amount_in`	`BIGNUMERIC`	Maximum input amount the user authorizes for the swap in base token units. Acts as slippage protection by capping how much can be spent to receive the desired output.
`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

asks	bids	event_q	pc_vault	authority	amount_out	block_slot	coin_vault	user_owner	amm_account	serum_market	vault_signer	max_amount_in	pool_token_pc	surrogate_key	transaction_id	amm_open_orders	block_timestamp	pool_token_coin	instruction_type	amm_target_orders	executing_account	instruction_index	spl_token_program	transaction_index	user_source_token	remaining_accounts	transaction_signer	serum_dex_program_id	user_destination_token	outer_executing_account	outer_instruction_index
HUCmvkqFdwixBBMm2vMgaBfJ5ArY5b7RqfYbACjCPhpp	AXTKA59Xd53s5a26PNALtnmqfJUWzdyuPN1w5qFMHGio	DMPcCyyqqDhxU852FU6rP6bCy6dfWGWjg2KF21y9DFt4	D6xgt4XSTRFAqctmY5byT4Ji7mvTihfnuNxjJWPETe7M	3uaZBfHPfmpAHW7dsimC1SnyR61X4bJqQZKWmRSCXJxv	1000000	275603600	3E3J4Ua9DPM5fdmRxB1AM6S5NqbhBh9exudHcs5jgumz	8FcA5Yhi38rcv5hm6yByXq54LriNsCwzedykAP7VVBgQ	9DTY3rv8xRa3CnoPoWJCMcQUSY7kUHZAoFKNsBhx8DDz	CaFjigEgJdtGPxQxRjneA1hzNcY5MsHoAAL6Et67QrC5	PmGWi4jXyde5y4ed8GdF1Son68LioBRGuazkCoJM8B2	2000000	CDSr3ssLcRB6XYPJwAfFt18MZvEZp4LjHcvzBVZ45duo	275603600-58Xz5PoUeRwxTvgF1JHB43Cb9TiNkRiLS9apUk4qN9eEQbFdZrWrGo56mQcZHFYfK8AgaKCDsPB8L9rc67vzyybA-1-0	58Xz5PoUeRwxTvgF1JHB43Cb9TiNkRiLS9apUk4qN9eEQbFdZrWrGo56mQcZHFYfK8AgaKCDsPB8L9rc67vzyybA	2a1H2xUFdja6RjPJ6RKWDLraURNCEY85LdP3GXcDeg8y	2024-07-04T09:07:02.000Z	PH3UpBfXJNazcFtUuxHMFtwtoAYJM9trKMCTqgYX8ZA	SwapBaseOut	8WhX9Y6cDkVUhBmm1TT83jX2vT7ZGwXv6zAQiUg84B5U	5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h	0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	174	BemvpVf2GKqmeVJcPvxE4PGGveu5QM371nghJprHqgqe	[]	8FcA5Yhi38rcv5hm6yByXq54LriNsCwzedykAP7VVBgQ	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	H7vF6xNW3JvUauTrh7xxh2LZCXV6C1agBMFmkneF29wu	BbGtVpxFAFMRRTjgNt4BBhZoi1QYV2B24UezCUdp21A3	1
HUCmvkqFdwixBBMm2vMgaBfJ5ArY5b7RqfYbACjCPhpp	AXTKA59Xd53s5a26PNALtnmqfJUWzdyuPN1w5qFMHGio	DMPcCyyqqDhxU852FU6rP6bCy6dfWGWjg2KF21y9DFt4	D6xgt4XSTRFAqctmY5byT4Ji7mvTihfnuNxjJWPETe7M	3uaZBfHPfmpAHW7dsimC1SnyR61X4bJqQZKWmRSCXJxv	1000000	275222159	3E3J4Ua9DPM5fdmRxB1AM6S5NqbhBh9exudHcs5jgumz	8FcA5Yhi38rcv5hm6yByXq54LriNsCwzedykAP7VVBgQ	9DTY3rv8xRa3CnoPoWJCMcQUSY7kUHZAoFKNsBhx8DDz	CaFjigEgJdtGPxQxRjneA1hzNcY5MsHoAAL6Et67QrC5	PmGWi4jXyde5y4ed8GdF1Son68LioBRGuazkCoJM8B2	2000000	CDSr3ssLcRB6XYPJwAfFt18MZvEZp4LjHcvzBVZ45duo	275222159-C1wfoCPEi4MuMkNhyUSGHbdqGwKzEAMT1L2SvFpERXYKXhr8tRStqXVa2GviQbSMqzCmt1tG3Mm8fYRW61mWPz4-1-0	C1wfoCPEi4MuMkNhyUSGHbdqGwKzEAMT1L2SvFpERXYKXhr8tRStqXVa2GviQbSMqzCmt1tG3Mm8fYRW61mWPz4	2a1H2xUFdja6RjPJ6RKWDLraURNCEY85LdP3GXcDeg8y	2024-07-02T08:41:14.000Z	PH3UpBfXJNazcFtUuxHMFtwtoAYJM9trKMCTqgYX8ZA	SwapBaseOut	8WhX9Y6cDkVUhBmm1TT83jX2vT7ZGwXv6zAQiUg84B5U	5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h	0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	123	BemvpVf2GKqmeVJcPvxE4PGGveu5QM371nghJprHqgqe	[]	8FcA5Yhi38rcv5hm6yByXq54LriNsCwzedykAP7VVBgQ	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	H7vF6xNW3JvUauTrh7xxh2LZCXV6C1agBMFmkneF29wu	BbGtVpxFAFMRRTjgNt4BBhZoi1QYV2B24UezCUdp21A3	1
AQKXXC29ybqL8DLeAVNt3ebpwMv8Sb4csberrP6Hz6o5	37m9QdvxmKRdjm3KKV2AjTiGcXMfWHQpVFnmhtb289yo	9MgPMkdEHFX7DZaitSh6Crya3kCCr1As6JC75bm3mjuC	9FLih4qwFMjdqRAGmHeCxa64CgjP1GtcgKJgHHgz44ar	3uaZBfHPfmpAHW7dsimC1SnyR61X4bJqQZKWmRSCXJxv	103456	340658840	H61Y7xVnbWVXrQQx3EojTEqf3ogKVY5GfGjEn5ewyX7B	MszymBkFFd8WPKJ5Dw58jQcipdJyW7QsDy1Jd7yf24R	2EXiumdi14E9b8Fy62QcA5Uh6WdHS2b38wtSxp72Mibj	77quYg4MGneUdjgXCunt9GgM1usmrxKY31twEy3WHwcS	FGBvMAu88q9d1Csz7ZECB5a2gbWwp6qicNxN2Mo7QhWG	142907	CDSr3ssLcRB6XYPJwAfFt18MZvEZp4LjHcvzBVZ45duo	340658840-pCjeyG82G5PH1vCjApQeChB83dj7EQ86MWPxjy2YyCc6kp8cJMjcPdjoe23ZpoimEwXbkjCJ3WSf2Eas9JC9Dfg-2	pCjeyG82G5PH1vCjApQeChB83dj7EQ86MWPxjy2YyCc6kp8cJMjcPdjoe23ZpoimEwXbkjCJ3WSf2Eas9JC9Dfg	4zbGjjRx8bmZjynJg2KnkJ54VAk1crcrYsGMy79EXK1P	2025-05-17T17:19:09.000Z	jfrmNrBtxnX1FH36ATeiaXnpA4ppQcKtv7EfrgMsgLJ	SwapBaseOut	5XkWQL9FJL4qEvL8c3zCzzWnMGzerM3jbGuuyRprsEgG	5quBtoiQqxF9Jv6KYKctB59NT3gtJD2Y65kdnB1Uev3h	2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	202	2ScQkUgqc8oWtzVFoSrsWmchYcHuGAEADteRUMKtyVih	[]	MszymBkFFd8WPKJ5Dw58jQcipdJyW7QsDy1Jd7yf24R	9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9PusVFin	FcqDNb3hcRV3rYPmFnGKzR2xHg9trNJWDGu2LY3mEGa

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AMMV4_SwapBaseIn_instruction

AMMV4_SwapBaseOut_instruction

CLMM_CreateAmmConfig_instruction

CLMM_CreatePool_instruction

CLMM_UpdateAmmConfig_instruction

CPMM_CreateAmmConfig_instruction

CPMM_Initialize_instruction

CPMM_UpdateAmmConfig_instruction

LaunchLab_BuyExactIn_instruction

LaunchLab_BuyExactOut_instruction

LaunchLab_SellExactIn_instruction

LaunchLab_SellExactOut_instruction

LaunchLab_TradeEvent_instruction

StableSwapAmm_SwapBaseIn_instruction

StableSwapAmm_SwapBaseOut_instruction

​Tables

​AMMV4_SwapBaseIn_instruction

​AMMV4_SwapBaseOut_instruction

​CLMM_CreateAmmConfig_instruction

​CLMM_CreatePool_instruction

​CLMM_UpdateAmmConfig_instruction

​CPMM_CreateAmmConfig_instruction

​CPMM_Initialize_instruction

​CPMM_UpdateAmmConfig_instruction

​LaunchLab_BuyExactIn_instruction

​LaunchLab_BuyExactOut_instruction

​LaunchLab_SellExactIn_instruction

​LaunchLab_SellExactOut_instruction

​LaunchLab_TradeEvent_instruction

​StableSwapAmm_SwapBaseIn_instruction

​StableSwapAmm_SwapBaseOut_instruction

Tables

AMMV4_SwapBaseIn_instruction

AMMV4_SwapBaseOut_instruction

CLMM_CreateAmmConfig_instruction

CLMM_CreatePool_instruction

CLMM_UpdateAmmConfig_instruction

CPMM_CreateAmmConfig_instruction

CPMM_Initialize_instruction

CPMM_UpdateAmmConfig_instruction

LaunchLab_BuyExactIn_instruction

LaunchLab_BuyExactOut_instruction

LaunchLab_SellExactIn_instruction

LaunchLab_SellExactOut_instruction

LaunchLab_TradeEvent_instruction

StableSwapAmm_SwapBaseIn_instruction

StableSwapAmm_SwapBaseOut_instruction