pancakeswap_v1_solana

Tables

Swap_instruction

Token swap execution records from decentralized exchange (DEX) programs on Solana. Contains input/output amounts, token accounts, liquidity pool references, and slippage protection parameters for atomic token exchanges.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`amm_config`	`STRING`	Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`input_vault`	`STRING`	Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
`observation_state`	`STRING`	Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
`output_token_account`	`STRING`	Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
`output_vault`	`STRING`	Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`tick_array`	`STRING`	Account address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`is_base_input`	`BOOL`	Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
`other_amount_threshold`	`BIGNUMERIC`	Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
`sqrt_price_limit_x64`	`BIGNUMERIC`	Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	amount	amm_config	block_slot	pool_state	tick_array	input_vault	output_vault	is_base_input	surrogate_key	token_program	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	observation_state	transaction_index	remaining_accounts	transaction_signer	input_token_account	output_token_account	outer_executing_account	outer_instruction_index
8ifsAW71uZ7wL6r7dzc3Hi8D3JeDTtgEGnyApuhCeUj2	10000000	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	364070815	AYkYVs7y4BMa5jt3QpbcXVXrc5p6cJJRg1fyZ12sjvva	8XcANLwhQs6d9Fb2RpCvNYozWBsStzwt2wBEpPGn9vtF	B2YnC6xdYCi7PvPyJCaggrGZ33xCowfbHmXBVACTaYZ1	9xY4A8CN7WTZSa6A5MfKAU3RXxLPhwB93CyNR5x3RLza	true	364070815-1Gb5tbsY47W5xvVxkek8KXFPqPKv234p2KfjLyV8hr3v5oiZLmMkKHeDiuwTLgQ2jDZY12tXHMeYHDrdJp6vHaL-0-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	1Gb5tbsY47W5xvVxkek8KXFPqPKv234p2KfjLyV8hr3v5oiZLmMkKHeDiuwTLgQ2jDZY12tXHMeYHDrdJp6vHaL	2025-09-02T02:05:26.000Z	Swap	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	0	C1skJjQBeU5QG3FzSNtit8bTaZ64JMemjtaP5s5fcKRb	172	[“6jSQrK1ErKRt6H1vFb85fJSs8f3VVPb37N4YwQR98BX”,“DKL6FxFkGNK1NVJJw3qi3qrCRPtKZ3YiU1krZsKJDKVU”,“Hc5v6qyyvUsdScny9555QygAR6tLz9QpR7bdZ66LoUy1”,“9wKFhGMssZEtobiyzXusJut9bcXD81rYJt7QmFRJPPPL”]	7zeciBUZK7obwiBMdt3ydhEqCDG5BBTMVd2btRJJE7KR	C77m2XK4q7V2Ku9TWMC9Y2ws2btYfc1gYFPn5REi6Kqu	Ayj5khRYexQCmDHjcZ7BRXoX2DYEgKSW8ELKDRsvjz1K	mmmmauu7rM92h8jHcMM69e8TsccCkwmnMRtrGSHocwj	0
3E1mwCBNyWELNjsNparpY92ncRvRdm3dzH3n92rVSjL1	16737768698	He4brjK7TRKiqJ8szpRmhuueDwC4837BFRRBmWfmjo14	364253681	8TNnJgVGVzDfiHbSVNHCKDqvN33rxKRp2VFdmjoeJWAq	9CB1eDdT194eDgcssaVMZRDdWFp55n39Bgr5gF7zsey1	9MwVpP9PgMnybgVkESxZ2wfPsx6s4qFs8Y6DXxzdzBaL	5LU4xuL4K61FoH4DvowjNeTw3878mPRUSRXTivcDz7Sh	true	364253681-38ZSWfbJEnTw1gKnCvXqLwvd3jMSP2dbcceCfQACxMTbdPkbXQqeTTUf4pqDPF2BeH5NCZBp7susqTGJHt1pBvBN-4-13	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	38ZSWfbJEnTw1gKnCvXqLwvd3jMSP2dbcceCfQACxMTbdPkbXQqeTTUf4pqDPF2BeH5NCZBp7susqTGJHt1pBvBN	2025-09-02T22:11:53.000Z	Swap	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	13	BjCE627eP3j8Xm6GzaHnpuPzFjEvp1xQS53NMtQiW9xg	200	[“KBQwNJFNdm9cPFFYCNPLpB6sg3mD8sW5w3sXxaxJKM9”,“6fP4ndfc1fWuRe5jodthseyyf3pgHcAqxsGynYs4J7Et”]	3E1mwCBNyWELNjsNparpY92ncRvRdm3dzH3n92rVSjL1	Hm6euGWdCgi6auaopRh9RcLsXFSbZfucaMgkStvq75YB	81FSqaZaMw1rAWALh8pxe5UZRjoK6cQv4Bv7r22sizJH	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	4
3CgvbiM3op4vjrrjH2zcrQUwsqh5veNVRjFCB9N6sRoD	16969367413	He4brjK7TRKiqJ8szpRmhuueDwC4837BFRRBmWfmjo14	364253783	8TNnJgVGVzDfiHbSVNHCKDqvN33rxKRp2VFdmjoeJWAq	9CB1eDdT194eDgcssaVMZRDdWFp55n39Bgr5gF7zsey1	9MwVpP9PgMnybgVkESxZ2wfPsx6s4qFs8Y6DXxzdzBaL	5LU4xuL4K61FoH4DvowjNeTw3878mPRUSRXTivcDz7Sh	true	364253783-538UBaTCTTUB7yJovzfa9X44kSQq2iZsC8HgGFbwLXH13U4HGdFT6HcNXMSbJd8Z9Nt8Ldzf3p5bZpJ9GVrhbrKe-2-12	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	538UBaTCTTUB7yJovzfa9X44kSQq2iZsC8HgGFbwLXH13U4HGdFT6HcNXMSbJd8Z9Nt8Ldzf3p5bZpJ9GVrhbrKe	2025-09-02T22:12:34.000Z	Swap	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	12	BjCE627eP3j8Xm6GzaHnpuPzFjEvp1xQS53NMtQiW9xg	172	[“KBQwNJFNdm9cPFFYCNPLpB6sg3mD8sW5w3sXxaxJKM9”,“6fP4ndfc1fWuRe5jodthseyyf3pgHcAqxsGynYs4J7Et”]	GSDTt8arr8jFSwmUdrEbqd6CDFqMcW6uyJycyijrSqPs	DdyyHwGqewxXBPdR7paXwLsurd9RZSY7kvmtD5VJJzmR	39FWQJxqTmUkFqHKjEs3CawQ1b1rqLcKmHfJ1FWMAWdu	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2

Example Query

Query with partition filter

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

Swap_Swap_instruction

Individual swap instruction executions from PancakeSwap V1 automated market maker (AMM) pools on Solana. Tracks token exchange details including amounts, vault addresses, price limits, and routing through Jupiter aggregator for analyzing DEX trading patterns and liquidity flow.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`amm_config`	`STRING`	Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`input_vault`	`STRING`	Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
`observation_state`	`STRING`	Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
`output_token_account`	`STRING`	Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
`output_vault`	`STRING`	Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`tick_array`	`STRING`	Account address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`is_base_input`	`BOOL`	Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
`other_amount_threshold`	`BIGNUMERIC`	Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
`sqrt_price_limit_x64`	`BIGNUMERIC`	Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	amount	amm_config	block_slot	pool_state	tick_array	input_vault	output_vault	is_base_input	surrogate_key	token_program	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	observation_state	transaction_index	remaining_accounts	transaction_signer	input_token_account	output_token_account	outer_executing_account	outer_instruction_index
3Ptq4SYHY2A5oVeS1wm2Gq7L5euHGFoZ9S92dg4SphqM	36298	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	372094677	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	EKEzN3swoUmQw9pqh2LGyCComCwoDB1FLmmRPXNZcvpD	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	true	372094677-3k4gMtfp7aFuCL4CYMetVZjF8SVSRF3pxQ5Spv4SF7REP27R19AqkBC2izufmsL6c1z2FxqgoMizcs2kBStBYY5r-4-7	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3k4gMtfp7aFuCL4CYMetVZjF8SVSRF3pxQ5Spv4SF7REP27R19AqkBC2izufmsL6c1z2FxqgoMizcs2kBStBYY5r	2025-10-08T22:03:29.000Z	Swap	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	7	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	190	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“3i1Hicio2k6WT2Q923cWhbbCn1azuPseoD4UrxMq3Nzy”]	3Ptq4SYHY2A5oVeS1wm2Gq7L5euHGFoZ9S92dg4SphqM	2fGpB1oaHmj1SkUERHH5w7rCN4QbyqFVHnB49Wjb5Cu8	Ce9di842qAYSSiBuxH76MfC3BAo8hLp4NXuULnoZ1sFb	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	4
7iWnBRRhBCiNXXPhqiGzvvBkKrvFSWqqmxRyu9VyYBxE	1407799	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	372100643	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	EKEzN3swoUmQw9pqh2LGyCComCwoDB1FLmmRPXNZcvpD	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	true	372100643-2vdcq25N9hL2ohAsDWnt3gkHasPAyAXtMUQUSe3jbpG3kq68n5p5fqmBXvTmVjbJsXdjJz5Ccipkrbs4MtZ6Jfm3-2-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2vdcq25N9hL2ohAsDWnt3gkHasPAyAXtMUQUSe3jbpG3kq68n5p5fqmBXvTmVjbJsXdjJz5Ccipkrbs4MtZ6Jfm3	2025-10-08T22:42:57.000Z	Swap	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	4	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	25	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“3i1Hicio2k6WT2Q923cWhbbCn1azuPseoD4UrxMq3Nzy”]	6zUuBhR2Zqg8MGGnLhLijuGf9f17gEYC1gFkqeqX6CU7	2oL6my4QDDCfpgJZX1bZV1NgbmuNptKdgcE8wJm6efgk	2i2pqY5eoHkoSiorPU8TGsgYLfZH5GvynqsyGRDzDYcV	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2
4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu71	460800	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	371898312	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	EKEzN3swoUmQw9pqh2LGyCComCwoDB1FLmmRPXNZcvpD	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	true	371898312-5HcX2zYpPxHnpfDw1KAUv5XsKNqb7qaj6cYwrmdt3ywoFoRPznciAduQsLGL9aNSEneh9Bd5A2gqtaf9nbiJgUa1-5-1	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5HcX2zYpPxHnpfDw1KAUv5XsKNqb7qaj6cYwrmdt3ywoFoRPznciAduQsLGL9aNSEneh9Bd5A2gqtaf9nbiJgUa1	2025-10-08T00:28:27.000Z	Swap	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	1	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	348	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“3i1Hicio2k6WT2Q923cWhbbCn1azuPseoD4UrxMq3Nzy”]	227yvSsT3ZrC3Hri7xEBUTrvJwq1UAcTemGVcQ1pMzg1	6zAcFYmxkaH25qWZW5ek4dk4SyQNpSza3ydSoUxjTudD	5kHFC6PpvZAEkDYiRdPbASgkCrxXmUcQg3ffVLCRc1Z8	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	5

Example Query

Query with partition filter

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

Swap_SwapV2_instruction

Token swap instruction data from PancakeSwap V1 automated market maker (AMM) on Solana. Contains swap execution details including input/output vaults, token amounts, price limits, and pool state for tracking DEX trading activity and liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`amm_config`	`STRING`	Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`input_vault`	`STRING`	Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
`input_vault_mint`	`STRING`	Token mint address for the input vault. Base58-encoded Solana public key.
`memo_program`	`STRING`	Program address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
`observation_state`	`STRING`	Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
`output_token_account`	`STRING`	Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
`output_vault`	`STRING`	Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
`output_vault_mint`	`STRING`	Token mint address for the output vault. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`token_program_2022`	`STRING`	Program address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`is_base_input`	`BOOL`	Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
`other_amount_threshold`	`BIGNUMERIC`	Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
`sqrt_price_limit_x64`	`BIGNUMERIC`	Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	amount	amm_config	block_slot	pool_state	input_vault	memo_program	output_vault	is_base_input	surrogate_key	token_program	transaction_id	block_timestamp	input_vault_mint	instruction_type	executing_account	instruction_index	observation_state	output_vault_mint	transaction_index	remaining_accounts	token_program_2022	transaction_signer	input_token_account	output_token_account	sqrt_price_limit_x64	other_amount_threshold	outer_executing_account	outer_instruction_index
AxR5o7n98EY6xoNGVhrJ3QGZAS2wRUcbzRnU5Dwbaev8	26590168	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	367230052	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	true	367230052-2BS3yj7TWWCnV6B5CGUj4RtZes4yNqdwqyGDMzCS75RTGLRiroHXzx1qgfPwhZnttb5kWakUAj3y3ndJhQFyQTpf-3-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2BS3yj7TWWCnV6B5CGUj4RtZes4yNqdwqyGDMzCS75RTGLRiroHXzx1qgfPwhZnttb5kWakUAj3y3ndJhQFyQTpf	2025-09-16T15:21:06.000Z	So11111111111111111111111111111111111111112	SwapV2	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	0	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr	42	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“6XuqFt3jzebFmMuf2zwE5Y6EfaEdyv8zkjZJJGdLJ96m”,“BRXVtj4tcMYnNPp7hKHNxdpRQb9uX1F64zPptDV62tHC”,“G1xHa1s9kEYarwazZLic8WGjRKhqd1LmpTQ6YEDAdbbB”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	AxR5o7n98EY6xoNGVhrJ3QGZAS2wRUcbzRnU5Dwbaev8	BjQBmV1stqWWMJ5oywpiAfK28C1jz3eSWSZ6Fg3ub7ak	BodcopG1PYKtwhSDZy1Mm1GSbePz1qMou8RaDu64UkWb	4295128740	1	3q9RnxufDcorEPAmCeZumn8kveC832rYYmZSk5tcaCzM	3
D5YqVMoSxnqeZAKAUUE1Dm3bmjtdxQ5DCF356ozqN9cM	11448000	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	367151964	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	true	367151964-4o8CPbamgvnfLCaFUvfUz1wTbdEWZyVw7GNjPnyeeLxfBbcnpriuBbMorv6pivrPk4ksezF5F5z8jrjTRdyUgYSx-7-1	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	4o8CPbamgvnfLCaFUvfUz1wTbdEWZyVw7GNjPnyeeLxfBbcnpriuBbMorv6pivrPk4ksezF5F5z8jrjTRdyUgYSx	2025-09-16T06:47:47.000Z	So11111111111111111111111111111111111111112	SwapV2	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	1	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr	42	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“6XuqFt3jzebFmMuf2zwE5Y6EfaEdyv8zkjZJJGdLJ96m”,“BRXVtj4tcMYnNPp7hKHNxdpRQb9uX1F64zPptDV62tHC”,“G1xHa1s9kEYarwazZLic8WGjRKhqd1LmpTQ6YEDAdbbB”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	9vi7ZwLbLa6nxRJi2DCMRbYYwXpNMGaFwVFZrKh4C8KK	EW9diL91VgHY5i9qYScz53W3PihQPSnPoMtAKCo1Bs7J	FmPgfNXwN31BTgryUWe9RKUJCQDXjmppMgqmdFYELrog	4295048017	0	T1TANpTeScyeqVzzgNViGDNrkQ6qHz9KrSBS4aNXvGT	7
FkdDHrM8j8psKbxuwjV1jBKCM2JGPygkj7WCX8sSCzNm	20580572	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	367100951	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	true	367100951-5rRyp9Ntm5XhBNmTMsMX1iS5mMizU4WU5hqJnB6vtWbwupfMUS2SG764DUxowyQ4zNGzHoLwm8EnT65iKTWifMhG-5-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5rRyp9Ntm5XhBNmTMsMX1iS5mMizU4WU5hqJnB6vtWbwupfMUS2SG764DUxowyQ4zNGzHoLwm8EnT65iKTWifMhG	2025-09-16T01:12:27.000Z	So11111111111111111111111111111111111111112	SwapV2	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	0	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr	110	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“6XuqFt3jzebFmMuf2zwE5Y6EfaEdyv8zkjZJJGdLJ96m”,“BRXVtj4tcMYnNPp7hKHNxdpRQb9uX1F64zPptDV62tHC”,“G1xHa1s9kEYarwazZLic8WGjRKhqd1LmpTQ6YEDAdbbB”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	FkdDHrM8j8psKbxuwjV1jBKCM2JGPygkj7WCX8sSCzNm	H6YtZBn9wjEoZM96ZVPgNQVwzqBCn3QteviZXSzKkWb	BYWJvcbgsgP8wztgooShjhhh6yQdGBNDjbgw1eHqTzKH	0	0	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	5

Example Query

Query with partition filter

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

SwapRouterBaseIn_instruction

Swap router instruction records from PancakeSwap V1 on Solana where input token amount is specified (exact-in swaps). Contains routing paths, slippage parameters, and token account data for analyzing multi-hop swap execution and routing efficiency.

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.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`input_token_mint`	`STRING`	Mint address of the token being swapped into the pool (input side of the swap). Base58-encoded Solana program-derived address identifying the SPL token contract.
`memo_program`	`STRING`	Program address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`token_program_2022`	`STRING`	Program address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`amount_out_minimum`	`BIGNUMERIC`	Minimum acceptable output token amount for the swap, specified by the user to protect against slippage. Acts as a floor price guarantee — the transaction fails if the actual output falls below this threshold.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	amount_in	block_slot	memo_program	surrogate_key	token_program	transaction_id	block_timestamp	input_token_mint	instruction_type	executing_account	instruction_index	transaction_index	amount_out_minimum	remaining_accounts	token_program_2022	transaction_signer	input_token_account
DmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV	2000000	353870479	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	353870479-25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z-6	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z	2025-07-17T09:13:54.000Z	So11111111111111111111111111111111111111112	SwapRouterBaseIn	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	6	214	293	[“5szFcjKA7UU93nhgb3fE1o1cfcurwpFQEzywZyb2qAYF”,“9Gx2jRszQQxTrExaoLxztgwsbMcWSVLRBsXGojHHAQo7”,“G3oSQGoz5RaWb1Nqnjm35ryNahpLZR27zkQPUsS4HYQ5”,“EFqBGwtwT4WREpMpewHm4iCcSc2R31sXczL7KYJUt24b”,“9AEZZUtfhKvVyBoBBUmn1AwFHtJUmb1wtuJi4ecnY9Zi”,“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“Gy2SugudBDyZctTmidjnNfaXZ4uxw37bbvdbAhuAkDAY”,“GvryckwMc9TXrCV2AiYRqr5Ye12bjtYmZy2qdjzzpc3j”,“FnaHH8ztTyPq1LCdYDgFHWhsyWzEQN2qidajhmHEK81t”,“9iLX7Vk3zD24ZwbzU8ZVU9rRDwKzVuwmy5hgPR1ZJp8X”,“Gej5N9tJiBJruWgMLn6v5VuKEhre8HxREhkikDtP7eYC”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	DmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV	4HTExmriWFQrjmFvP9Y4VeksraTS2BaBdKHpYyGJekCJ
DmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV	8000000	353870479	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	353870479-25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z	2025-07-17T09:13:54.000Z	So11111111111111111111111111111111111111112	SwapRouterBaseIn	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	5	214	1174	[“HZzqEWHEvSiqYt6PxxLs7zXETmqGuryqfmvggjAkqisp”,“22HUWiJaTNph96KQTKZVy2wg8KzfCems5nyW7E5H5J6w”,“61sHRS6qeoELLAppkRE8Tr8ph9qatJdJVEqx7z7MwxWB”,“7YcR78PKBHE5divhPVJ668kmmaDzove2d9msY9NpAJL2”,“FCBauqNLbEBUci1v3NT4gWyFZXS4YUGnX7ZsPmWVzrvV”,“Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB”,“AsRbHvJA4a5DujNA6dx3VPWYvd3KkgfK8KWuBRV7YuK3”,“8Qj8jJsrfPjeAgB9h6rjB583jAbwmBe32c81gB4jRwSk”,“BjoRaXvW65NCB6QNR2gDG14n3wLbBUR1rGwvXLe2E3yW”,“8GySGJrAUCQSoH2EyGk788FZNtG8riK5jxo675GPqNsm”,“94hUf4FS81A8HJs2u75gw4TJShNAizA1zu2K9DbfYUuM”,“2zmg7259ahZkrSn6M3PEM7eFvEfBU8obgfVHT3AL9Qwu”,“93mnMSder8YXAex1CQPVexpgryrThJ5GfoxmHg2iSZeV”,“G3oSQGoz5RaWb1Nqnjm35ryNahpLZR27zkQPUsS4HYQ5”,“6FUyZnFDnbJcyY2vfFBTXLdf9XFwjyYj65xm93JCE4kU”,“8asgvi4RjxRMgzqZhTLHpsoaDDjLBMKdfAWDX97y2j8f”,“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“FE63YXiEwr4kBbzdHcd7XBfqRGERZiHowds37XXB6urA”,“HhSPKrvju6WeR4tYPtyxRb79zDuFB2Gkt9R6j2tj1dju”,“J6a1DLHC59uwffAEGaBMoa4pknjtMddmaXqtHEFTqypP”,“FsZb8CyxTaCD4PJBtbqhrvFeojrnwrcL9YwksvZXpA7o”,“3U8n7s1PixNWMJu4EMzDMCxXqpG61UmBs3XWWLXPdrjj”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	DmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV	4HTExmriWFQrjmFvP9Y4VeksraTS2BaBdKHpYyGJekCJ
F2cahz2SxKip5WBEeFJxHGxX5aJGoPhAVMJ1toazRSoV	1000000	350144716	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	350144716-49u9G9uG5oq8ULF5ipLSQExXBevNhyA5ocCdnS4SQ6x8ABXFpod2Z2UjpzkEDZrwtav4QPjLGvBBsp19AThEDopz-2	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	49u9G9uG5oq8ULF5ipLSQExXBevNhyA5ocCdnS4SQ6x8ABXFpod2Z2UjpzkEDZrwtav4QPjLGvBBsp19AThEDopz	2025-06-30T07:18:22.000Z	2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo	SwapRouterBaseIn	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	2	270	1021305	[“GcJVsj5MxokA4eRMUkB4cJHuZ6o9Y8MooXBViN5F1mYW”,“BfEqPRVa4eZJK62TgAGNUGMBDKu5914cwgTHsdZGDGtT”,“7Vk54pQGBnwaVa4ERJ9XwJvyYgfyDpsyNepKYrAkHBnN”,“DUN9shf378AmHRh1Z3gzqF3eL5fATbgAZPZWVwvzMJVD”,“5Se5DVLV6xDU1eg2PuP8icqjsrCR2z6EuzLEFb9T5va4”,“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“437FvZvTkpAysjDNrbNunynn4sNQd24VhVZejfJCWyLo”,“AY9oHQGnqdohwNyoUoxWWLiZHmk7BeW4RSQK9F8n5mAQ”,“29117UdRkuMrefZARQNU9MAr11ytB361p4f2d2JQWGjy”,“DbtYdZEQT36SaQ7YcoxF4Hbc5zSv2HMd2KvRThZT6FQu”,“A6RftuphhXVJFGncMq1TFfdwJ5qVewKtudzrLdygnHE1”,“He4brjK7TRKiqJ8szpRmhuueDwC4837BFRRBmWfmjo14”,“5KKuejdZrFCoLGQPQQgcuP3Kd6fNhQQmemgshnwjpyQy”,“Ae1qsR1xwpWRMnFQKSrYHs6zTiFABULPX5hgWvfbBfJL”,“J3osYkYxxWT5NJcPujYn4P5CLtLyw7Em4eGDoxvLjD1c”,“2KE2qD6FHaHggcfjYXRNF2XSMniikNrBx59xyqChhcjT”,“Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB”,“GsT8bVw1rN7x1gBMAzzSzpyUAvBeuGrXHmqRdWiw94ZG”,“E2RCP7hoRW3k9ECznfwwm1HXnFZvxRq2jnhvVf2ViaUW”,“F6gtmgfPcf8NJZmZzg1CFs9oyfJbmpfEawMXzAJyjM77”,“74aUa6uCvqyRtVUn7pGBJiJWLT6DkicfNM1tXhGTkCx”,“3MM119fr4nQ7p4qN4RG9B4FubAzvK9VnwP3KvVP4nYFZ”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	F2cahz2SxKip5WBEeFJxHGxX5aJGoPhAVMJ1toazRSoV	fzGSeGVV57xZ8Psyunj4qr6JMe6n4pcN2PTPAk8QbpD

Example Query

Query with partition filter

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

SwapV2_instruction

Instruction-level swap records from PancakeSwap V1 concentrated liquidity pools on Solana, capturing token amounts, vault addresses, slippage thresholds, and price limits for analyzing individual swap executions and routing paths.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`amm_config`	`STRING`	Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
`input_token_account`	`STRING`	Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
`input_vault`	`STRING`	Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
`input_vault_mint`	`STRING`	Token mint address for the input vault. Base58-encoded Solana public key.
`memo_program`	`STRING`	Program address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
`observation_state`	`STRING`	Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
`output_token_account`	`STRING`	Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
`output_vault`	`STRING`	Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
`output_vault_mint`	`STRING`	Token mint address for the output vault. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`pool_state`	`STRING`	Account address representing the liquidity pool state. Base58-encoded Solana public key.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`token_program_2022`	`STRING`	Program address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`is_base_input`	`BOOL`	Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
`other_amount_threshold`	`BIGNUMERIC`	Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
`sqrt_price_limit_x64`	`BIGNUMERIC`	Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

payer	amount	amm_config	block_slot	pool_state	input_vault	memo_program	output_vault	is_base_input	surrogate_key	token_program	transaction_id	block_timestamp	input_vault_mint	instruction_type	executing_account	instruction_index	observation_state	output_vault_mint	transaction_index	remaining_accounts	token_program_2022	transaction_signer	input_token_account	output_token_account	other_amount_threshold	outer_executing_account	outer_instruction_index
3nMNd89AxwHUa1AFvQGqohRkxFEQsTsgiEyEyqXFHyyH	9196723068	5kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M	364036600	E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC	23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	GugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF	true	364036600-5DZxguEcbVWoXBUVb5k8PbBi7CisoBiTZwbAfzqbWY13wyDvbnjYcmn3yai58m6MyzVtsbFpyewahqMm7UkM3VuX-2-14	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5DZxguEcbVWoXBUVb5k8PbBi7CisoBiTZwbAfzqbWY13wyDvbnjYcmn3yai58m6MyzVtsbFpyewahqMm7UkM3VuX	2025-09-01T22:19:29.000Z	7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr	SwapV2	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	14	AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw	So11111111111111111111111111111111111111112	199	[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“8xtDq2dATztrAVdaypsiRtF2neUUFTmMMhYv2UU9n91H”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	3nMNd89AxwHUa1AFvQGqohRkxFEQsTsgiEyEyqXFHyyH	3QEmytRpngHgbco3HuZKsBa85Y4ffBzYy6YLeZw2umqS	AthF4CEubMxyPVkw8PKbLsPgs9sj6uRHLskGLuBybMpS	1	9Zzf9QqTy3TkyXysvJBsXyuRjda5aXCEJ9vXfL2HKSYv	2
HV1KXxWFaSeriyFvXyx48FqG9BoFbfinB8njCJonqP7K	32579997	GaWZjVasTQLCNmag5n34eyhhD4T56TN39ckNcuUmu7x4	364031962	GZp6RZrRhQocBgtogRf8YWx8PQHbh39LMtveAXs6tqyb	26op6cJny3QCc91wVmwm1xZ3MnH6QWkYAm95DdvprKkW	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	9HXBjNBLmKmS4G3LyHMPTRNFQyLZ7GLfc5Psfi5MuZ1Z	true	364031962-j5GLtcu3SDdd6tNB3QbE5izV7grqX2mJRqjVdsfMtpXPa51ZSufsLKeCYf9mh1ETRd2kBPLzZudnzR66GPPmi5Z-5-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	j5GLtcu3SDdd6tNB3QbE5izV7grqX2mJRqjVdsfMtpXPa51ZSufsLKeCYf9mh1ETRd2kBPLzZudnzR66GPPmi5Z	2025-09-01T21:49:01.000Z	DrZ26cKJDksVRWib3DVVsjo9eeXccc7hKhDJviiYEEZY	SwapV2	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	5	BS1vkcV4zTXoP5NNm1vg4LYK4wd2HdkGY4EkNJeERaGA	So11111111111111111111111111111111111111112	148	[“7J4WLPYRDA2YZA2z1cTSzVRoeK45iz8PvUgdJMT6QAo2”,“B6pFSSsCPhjjE4GGBiqfwwBpt3Byep65vh2QnwWmcHQW”,“9btVQLV4skf4iYhNHHuHj33cLmnTLCBSfGHrscmLpeGJ”,“4eVupb3rbniPpQh294x8cZ8NjU5BaeZdp38cqhtRGjWw”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	FdPxPcWndy6UWqqXtKCfBcuGYYsVV2xed9eTZPjWTuUd	C7NBSb9ENdPChc5iCTnFZAJwy59y2TYYnbwD4266p7XY	2rikd7tzPbmowhUJzPNVtX7fuUGcnBa8jqJnx6HbtHeE	1	6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma	5
HV1KXxWFaSeriyFvXyx48FqG9BoFbfinB8njCJonqP7K	503829	GaWZjVasTQLCNmag5n34eyhhD4T56TN39ckNcuUmu7x4	364040848	GZp6RZrRhQocBgtogRf8YWx8PQHbh39LMtveAXs6tqyb	26op6cJny3QCc91wVmwm1xZ3MnH6QWkYAm95DdvprKkW	MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr	9HXBjNBLmKmS4G3LyHMPTRNFQyLZ7GLfc5Psfi5MuZ1Z	true	364040848-yo9tCeP9ccxWCKTKFJeKFQAprGqtHBqGewyGa3fGR91aBELZSYhqD99Lahm4cFpXjvPG6itiMQ3JaRacYj81xsE-4-12	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	yo9tCeP9ccxWCKTKFJeKFQAprGqtHBqGewyGa3fGR91aBELZSYhqD99Lahm4cFpXjvPG6itiMQ3JaRacYj81xsE	2025-09-01T22:47:33.000Z	DrZ26cKJDksVRWib3DVVsjo9eeXccc7hKhDJviiYEEZY	SwapV2	HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq	12	BS1vkcV4zTXoP5NNm1vg4LYK4wd2HdkGY4EkNJeERaGA	So11111111111111111111111111111111111111112	60	[“7J4WLPYRDA2YZA2z1cTSzVRoeK45iz8PvUgdJMT6QAo2”,“B6pFSSsCPhjjE4GGBiqfwwBpt3Byep65vh2QnwWmcHQW”,“9btVQLV4skf4iYhNHHuHj33cLmnTLCBSfGHrscmLpeGJ”,“4eVupb3rbniPpQh294x8cZ8NjU5BaeZdp38cqhtRGjWw”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	7DgbYgufUMs3yDShSJmBYLt3AKXjrk9NPx5WhVsJfU4g	C7NBSb9ENdPChc5iCTnFZAJwy59y2TYYnbwD4266p7XY	2rikd7tzPbmowhUJzPNVtX7fuUGcnBa8jqJnx6HbtHeE	1	6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma	4

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Swap_instruction

Swap_Swap_instruction

Swap_SwapV2_instruction

SwapRouterBaseIn_instruction

SwapV2_instruction

​Tables

​Swap_instruction

​Swap_Swap_instruction

​Swap_SwapV2_instruction

​SwapRouterBaseIn_instruction

​SwapV2_instruction

Tables

Swap_instruction

Swap_Swap_instruction

Swap_SwapV2_instruction

SwapRouterBaseIn_instruction

SwapV2_instruction