Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
amm_configSTRINGAccount address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
input_vaultSTRINGAccount address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
observation_stateSTRINGAccount address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
output_vaultSTRINGAccount address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
pool_stateSTRINGAccount address representing the liquidity pool state. Base58-encoded Solana public key.
tick_arraySTRINGAccount address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
is_base_inputBOOLBoolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
other_amount_thresholdBIGNUMERICMinimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
sqrt_price_limit_x64BIGNUMERICPrice limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramountamm_configblock_slotpool_statetick_arrayinput_vaultoutput_vaultis_base_inputsurrogate_keytoken_programtransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indexobservation_statetransaction_indexremaining_accountstransaction_signerinput_token_accountoutput_token_accountsqrt_price_limit_x64other_amount_thresholdouter_executing_accountouter_instruction_index
8ifsAW71uZ7wL6r7dzc3Hi8D3JeDTtgEGnyApuhCeUj2100000005kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M364070815AYkYVs7y4BMa5jt3QpbcXVXrc5p6cJJRg1fyZ12sjvva8XcANLwhQs6d9Fb2RpCvNYozWBsStzwt2wBEpPGn9vtFB2YnC6xdYCi7PvPyJCaggrGZ33xCowfbHmXBVACTaYZ19xY4A8CN7WTZSa6A5MfKAU3RXxLPhwB93CyNR5x3RLzatrue364070815-1Gb5tbsY47W5xvVxkek8KXFPqPKv234p2KfjLyV8hr3v5oiZLmMkKHeDiuwTLgQ2jDZY12tXHMeYHDrdJp6vHaL-0-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA1Gb5tbsY47W5xvVxkek8KXFPqPKv234p2KfjLyV8hr3v5oiZLmMkKHeDiuwTLgQ2jDZY12tXHMeYHDrdJp6vHaL2025-09-02T02:05:26.000ZSwapHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq0C1skJjQBeU5QG3FzSNtit8bTaZ64JMemjtaP5s5fcKRb172[“6jSQrK1ErKRt6H1vFb85fJSs8f3VVPb37N4YwQR98BX”,“DKL6FxFkGNK1NVJJw3qi3qrCRPtKZ3YiU1krZsKJDKVU”,“Hc5v6qyyvUsdScny9555QygAR6tLz9QpR7bdZ66LoUy1”,“9wKFhGMssZEtobiyzXusJut9bcXD81rYJt7QmFRJPPPL”]7zeciBUZK7obwiBMdt3ydhEqCDG5BBTMVd2btRJJE7KRC77m2XK4q7V2Ku9TWMC9Y2ws2btYfc1gYFPn5REi6KquAyj5khRYexQCmDHjcZ7BRXoX2DYEgKSW8ELKDRsvjz1K00mmmmauu7rM92h8jHcMM69e8TsccCkwmnMRtrGSHocwj0
3E1mwCBNyWELNjsNparpY92ncRvRdm3dzH3n92rVSjL116737768698He4brjK7TRKiqJ8szpRmhuueDwC4837BFRRBmWfmjo143642536818TNnJgVGVzDfiHbSVNHCKDqvN33rxKRp2VFdmjoeJWAq9CB1eDdT194eDgcssaVMZRDdWFp55n39Bgr5gF7zsey19MwVpP9PgMnybgVkESxZ2wfPsx6s4qFs8Y6DXxzdzBaL5LU4xuL4K61FoH4DvowjNeTw3878mPRUSRXTivcDz7Shtrue364253681-38ZSWfbJEnTw1gKnCvXqLwvd3jMSP2dbcceCfQACxMTbdPkbXQqeTTUf4pqDPF2BeH5NCZBp7susqTGJHt1pBvBN-4-13TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA38ZSWfbJEnTw1gKnCvXqLwvd3jMSP2dbcceCfQACxMTbdPkbXQqeTTUf4pqDPF2BeH5NCZBp7susqTGJHt1pBvBN2025-09-02T22:11:53.000ZSwapHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq13BjCE627eP3j8Xm6GzaHnpuPzFjEvp1xQS53NMtQiW9xg200[“KBQwNJFNdm9cPFFYCNPLpB6sg3mD8sW5w3sXxaxJKM9”,“6fP4ndfc1fWuRe5jodthseyyf3pgHcAqxsGynYs4J7Et”]3E1mwCBNyWELNjsNparpY92ncRvRdm3dzH3n92rVSjL1Hm6euGWdCgi6auaopRh9RcLsXFSbZfucaMgkStvq75YB81FSqaZaMw1rAWALh8pxe5UZRjoK6cQv4Bv7r22sizJH00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV44
3CgvbiM3op4vjrrjH2zcrQUwsqh5veNVRjFCB9N6sRoD16969367413He4brjK7TRKiqJ8szpRmhuueDwC4837BFRRBmWfmjo143642537838TNnJgVGVzDfiHbSVNHCKDqvN33rxKRp2VFdmjoeJWAq9CB1eDdT194eDgcssaVMZRDdWFp55n39Bgr5gF7zsey19MwVpP9PgMnybgVkESxZ2wfPsx6s4qFs8Y6DXxzdzBaL5LU4xuL4K61FoH4DvowjNeTw3878mPRUSRXTivcDz7Shtrue364253783-538UBaTCTTUB7yJovzfa9X44kSQq2iZsC8HgGFbwLXH13U4HGdFT6HcNXMSbJd8Z9Nt8Ldzf3p5bZpJ9GVrhbrKe-2-12TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA538UBaTCTTUB7yJovzfa9X44kSQq2iZsC8HgGFbwLXH13U4HGdFT6HcNXMSbJd8Z9Nt8Ldzf3p5bZpJ9GVrhbrKe2025-09-02T22:12:34.000ZSwapHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq12BjCE627eP3j8Xm6GzaHnpuPzFjEvp1xQS53NMtQiW9xg172[“KBQwNJFNdm9cPFFYCNPLpB6sg3mD8sW5w3sXxaxJKM9”,“6fP4ndfc1fWuRe5jodthseyyf3pgHcAqxsGynYs4J7Et”]GSDTt8arr8jFSwmUdrEbqd6CDFqMcW6uyJycyijrSqPsDdyyHwGqewxXBPdR7paXwLsurd9RZSY7kvmtD5VJJzmR39FWQJxqTmUkFqHKjEs3CawQ1b1rqLcKmHfJ1FWMAWdu00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
amm_configSTRINGAccount address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
input_vaultSTRINGAccount address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
observation_stateSTRINGAccount address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
output_vaultSTRINGAccount address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
pool_stateSTRINGAccount address representing the liquidity pool state. Base58-encoded Solana public key.
tick_arraySTRINGAccount address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
is_base_inputBOOLBoolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
other_amount_thresholdBIGNUMERICMinimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
sqrt_price_limit_x64BIGNUMERICPrice limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramountamm_configblock_slotpool_statetick_arrayinput_vaultoutput_vaultis_base_inputsurrogate_keytoken_programtransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indexobservation_statetransaction_indexremaining_accountstransaction_signerinput_token_accountoutput_token_accountsqrt_price_limit_x64other_amount_thresholdouter_executing_accountouter_instruction_index
3Ptq4SYHY2A5oVeS1wm2Gq7L5euHGFoZ9S92dg4SphqM362985kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M372094677E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgECEKEzN3swoUmQw9pqh2LGyCComCwoDB1FLmmRPXNZcvpDGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4true372094677-3k4gMtfp7aFuCL4CYMetVZjF8SVSRF3pxQ5Spv4SF7REP27R19AqkBC2izufmsL6c1z2FxqgoMizcs2kBStBYY5r-4-7TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA3k4gMtfp7aFuCL4CYMetVZjF8SVSRF3pxQ5Spv4SF7REP27R19AqkBC2izufmsL6c1z2FxqgoMizcs2kBStBYY5r2025-10-08T22:03:29.000ZSwapHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq7AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw190[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“3i1Hicio2k6WT2Q923cWhbbCn1azuPseoD4UrxMq3Nzy”]3Ptq4SYHY2A5oVeS1wm2Gq7L5euHGFoZ9S92dg4SphqM2fGpB1oaHmj1SkUERHH5w7rCN4QbyqFVHnB49Wjb5Cu8Ce9di842qAYSSiBuxH76MfC3BAo8hLp4NXuULnoZ1sFb00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV44
7iWnBRRhBCiNXXPhqiGzvvBkKrvFSWqqmxRyu9VyYBxE14077995kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M372100643E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgECEKEzN3swoUmQw9pqh2LGyCComCwoDB1FLmmRPXNZcvpDGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4true372100643-2vdcq25N9hL2ohAsDWnt3gkHasPAyAXtMUQUSe3jbpG3kq68n5p5fqmBXvTmVjbJsXdjJz5Ccipkrbs4MtZ6Jfm3-2-4TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA2vdcq25N9hL2ohAsDWnt3gkHasPAyAXtMUQUSe3jbpG3kq68n5p5fqmBXvTmVjbJsXdjJz5Ccipkrbs4MtZ6Jfm32025-10-08T22:42:57.000ZSwapHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq4AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw25[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“3i1Hicio2k6WT2Q923cWhbbCn1azuPseoD4UrxMq3Nzy”]6zUuBhR2Zqg8MGGnLhLijuGf9f17gEYC1gFkqeqX6CU72oL6my4QDDCfpgJZX1bZV1NgbmuNptKdgcE8wJm6efgk2i2pqY5eoHkoSiorPU8TGsgYLfZH5GvynqsyGRDzDYcV00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42
4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu714608005kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M371898312E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgECEKEzN3swoUmQw9pqh2LGyCComCwoDB1FLmmRPXNZcvpDGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXF23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4true371898312-5HcX2zYpPxHnpfDw1KAUv5XsKNqb7qaj6cYwrmdt3ywoFoRPznciAduQsLGL9aNSEneh9Bd5A2gqtaf9nbiJgUa1-5-1TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5HcX2zYpPxHnpfDw1KAUv5XsKNqb7qaj6cYwrmdt3ywoFoRPznciAduQsLGL9aNSEneh9Bd5A2gqtaf9nbiJgUa12025-10-08T00:28:27.000ZSwapHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq1AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw348[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“3i1Hicio2k6WT2Q923cWhbbCn1azuPseoD4UrxMq3Nzy”]227yvSsT3ZrC3Hri7xEBUTrvJwq1UAcTemGVcQ1pMzg16zAcFYmxkaH25qWZW5ek4dk4SyQNpSza3ydSoUxjTudD5kHFC6PpvZAEkDYiRdPbASgkCrxXmUcQg3ffVLCRc1Z800JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV45
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
amm_configSTRINGAccount address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
input_vaultSTRINGAccount address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
input_vault_mintSTRINGToken mint address for the input vault. Base58-encoded Solana public key.
memo_programSTRINGProgram address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
observation_stateSTRINGAccount address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
output_vaultSTRINGAccount address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
output_vault_mintSTRINGToken mint address for the output vault. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
pool_stateSTRINGAccount address representing the liquidity pool state. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
token_program_2022STRINGProgram address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
is_base_inputBOOLBoolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
other_amount_thresholdBIGNUMERICMinimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
sqrt_price_limit_x64BIGNUMERICPrice limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramountamm_configblock_slotpool_stateinput_vaultmemo_programoutput_vaultis_base_inputsurrogate_keytoken_programtransaction_idblock_timestampinput_vault_mintinstruction_typeexecuting_accountinstruction_indexobservation_stateoutput_vault_minttransaction_indexremaining_accountstoken_program_2022transaction_signerinput_token_accountoutput_token_accountsqrt_price_limit_x64other_amount_thresholdouter_executing_accountouter_instruction_index
AxR5o7n98EY6xoNGVhrJ3QGZAS2wRUcbzRnU5Dwbaev8265901685kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M367230052E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgECGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXFMemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4true367230052-2BS3yj7TWWCnV6B5CGUj4RtZes4yNqdwqyGDMzCS75RTGLRiroHXzx1qgfPwhZnttb5kWakUAj3y3ndJhQFyQTpf-3-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA2BS3yj7TWWCnV6B5CGUj4RtZes4yNqdwqyGDMzCS75RTGLRiroHXzx1qgfPwhZnttb5kWakUAj3y3ndJhQFyQTpf2025-09-16T15:21:06.000ZSo11111111111111111111111111111111111111112SwapV2HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq0AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr42[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“6XuqFt3jzebFmMuf2zwE5Y6EfaEdyv8zkjZJJGdLJ96m”,“BRXVtj4tcMYnNPp7hKHNxdpRQb9uX1F64zPptDV62tHC”,“G1xHa1s9kEYarwazZLic8WGjRKhqd1LmpTQ6YEDAdbbB”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbAxR5o7n98EY6xoNGVhrJ3QGZAS2wRUcbzRnU5Dwbaev8BjQBmV1stqWWMJ5oywpiAfK28C1jz3eSWSZ6Fg3ub7akBodcopG1PYKtwhSDZy1Mm1GSbePz1qMou8RaDu64UkWb429512874013q9RnxufDcorEPAmCeZumn8kveC832rYYmZSk5tcaCzM3
D5YqVMoSxnqeZAKAUUE1Dm3bmjtdxQ5DCF356ozqN9cM114480005kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M367151964E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgECGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXFMemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4true367151964-4o8CPbamgvnfLCaFUvfUz1wTbdEWZyVw7GNjPnyeeLxfBbcnpriuBbMorv6pivrPk4ksezF5F5z8jrjTRdyUgYSx-7-1TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA4o8CPbamgvnfLCaFUvfUz1wTbdEWZyVw7GNjPnyeeLxfBbcnpriuBbMorv6pivrPk4ksezF5F5z8jrjTRdyUgYSx2025-09-16T06:47:47.000ZSo11111111111111111111111111111111111111112SwapV2HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq1AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr42[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“6XuqFt3jzebFmMuf2zwE5Y6EfaEdyv8zkjZJJGdLJ96m”,“BRXVtj4tcMYnNPp7hKHNxdpRQb9uX1F64zPptDV62tHC”,“G1xHa1s9kEYarwazZLic8WGjRKhqd1LmpTQ6YEDAdbbB”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb9vi7ZwLbLa6nxRJi2DCMRbYYwXpNMGaFwVFZrKh4C8KKEW9diL91VgHY5i9qYScz53W3PihQPSnPoMtAKCo1Bs7JFmPgfNXwN31BTgryUWe9RKUJCQDXjmppMgqmdFYELrog42950480170T1TANpTeScyeqVzzgNViGDNrkQ6qHz9KrSBS4aNXvGT7
FkdDHrM8j8psKbxuwjV1jBKCM2JGPygkj7WCX8sSCzNm205805725kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M367100951E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgECGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXFMemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4true367100951-5rRyp9Ntm5XhBNmTMsMX1iS5mMizU4WU5hqJnB6vtWbwupfMUS2SG764DUxowyQ4zNGzHoLwm8EnT65iKTWifMhG-5-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5rRyp9Ntm5XhBNmTMsMX1iS5mMizU4WU5hqJnB6vtWbwupfMUS2SG764DUxowyQ4zNGzHoLwm8EnT65iKTWifMhG2025-09-16T01:12:27.000ZSo11111111111111111111111111111111111111112SwapV2HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq0AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgyw7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr110[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“6XuqFt3jzebFmMuf2zwE5Y6EfaEdyv8zkjZJJGdLJ96m”,“BRXVtj4tcMYnNPp7hKHNxdpRQb9uX1F64zPptDV62tHC”,“G1xHa1s9kEYarwazZLic8WGjRKhqd1LmpTQ6YEDAdbbB”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbFkdDHrM8j8psKbxuwjV1jBKCM2JGPygkj7WCX8sSCzNmH6YtZBn9wjEoZM96ZVPgNQVwzqBCn3QteviZXSzKkWbBYWJvcbgsgP8wztgooShjhhh6yQdGBNDjbgw1eHqTzKH00JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV45
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
input_token_mintSTRINGMint 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_programSTRINGProgram address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
token_program_2022STRINGProgram address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
amount_out_minimumBIGNUMERICMinimum 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_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramount_inblock_slotmemo_programsurrogate_keytoken_programtransaction_idblock_timestampinput_token_mintinstruction_typeexecuting_accountinstruction_indextransaction_indexamount_out_minimumremaining_accountstoken_program_2022transaction_signerinput_token_accountouter_executing_accountouter_instruction_index
DmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV2000000353870479MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr353870479-25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z-6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z2025-07-17T09:13:54.000ZSo11111111111111111111111111111111111111112SwapRouterBaseInHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq6214293[“5szFcjKA7UU93nhgb3fE1o1cfcurwpFQEzywZyb2qAYF”,“9Gx2jRszQQxTrExaoLxztgwsbMcWSVLRBsXGojHHAQo7”,“G3oSQGoz5RaWb1Nqnjm35ryNahpLZR27zkQPUsS4HYQ5”,“EFqBGwtwT4WREpMpewHm4iCcSc2R31sXczL7KYJUt24b”,“9AEZZUtfhKvVyBoBBUmn1AwFHtJUmb1wtuJi4ecnY9Zi”,“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“Gy2SugudBDyZctTmidjnNfaXZ4uxw37bbvdbAhuAkDAY”,“GvryckwMc9TXrCV2AiYRqr5Ye12bjtYmZy2qdjzzpc3j”,“FnaHH8ztTyPq1LCdYDgFHWhsyWzEQN2qidajhmHEK81t”,“9iLX7Vk3zD24ZwbzU8ZVU9rRDwKzVuwmy5hgPR1ZJp8X”,“Gej5N9tJiBJruWgMLn6v5VuKEhre8HxREhkikDtP7eYC”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbDmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV4HTExmriWFQrjmFvP9Y4VeksraTS2BaBdKHpYyGJekCJ
DmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV8000000353870479MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr353870479-25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z-5TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA25GaVsAJmpGS2GgTBT4n8ZbJYpHyz98s9qvrGKsj5wL7uxmtT1JSb13oTyr4o9i4qrtYD1oW8jk8etSRfKYiKn2z2025-07-17T09:13:54.000ZSo11111111111111111111111111111111111111112SwapRouterBaseInHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq52141174[“HZzqEWHEvSiqYt6PxxLs7zXETmqGuryqfmvggjAkqisp”,“22HUWiJaTNph96KQTKZVy2wg8KzfCems5nyW7E5H5J6w”,“61sHRS6qeoELLAppkRE8Tr8ph9qatJdJVEqx7z7MwxWB”,“7YcR78PKBHE5divhPVJ668kmmaDzove2d9msY9NpAJL2”,“FCBauqNLbEBUci1v3NT4gWyFZXS4YUGnX7ZsPmWVzrvV”,“Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB”,“AsRbHvJA4a5DujNA6dx3VPWYvd3KkgfK8KWuBRV7YuK3”,“8Qj8jJsrfPjeAgB9h6rjB583jAbwmBe32c81gB4jRwSk”,“BjoRaXvW65NCB6QNR2gDG14n3wLbBUR1rGwvXLe2E3yW”,“8GySGJrAUCQSoH2EyGk788FZNtG8riK5jxo675GPqNsm”,“94hUf4FS81A8HJs2u75gw4TJShNAizA1zu2K9DbfYUuM”,“2zmg7259ahZkrSn6M3PEM7eFvEfBU8obgfVHT3AL9Qwu”,“93mnMSder8YXAex1CQPVexpgryrThJ5GfoxmHg2iSZeV”,“G3oSQGoz5RaWb1Nqnjm35ryNahpLZR27zkQPUsS4HYQ5”,“6FUyZnFDnbJcyY2vfFBTXLdf9XFwjyYj65xm93JCE4kU”,“8asgvi4RjxRMgzqZhTLHpsoaDDjLBMKdfAWDX97y2j8f”,“cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij”,“FE63YXiEwr4kBbzdHcd7XBfqRGERZiHowds37XXB6urA”,“HhSPKrvju6WeR4tYPtyxRb79zDuFB2Gkt9R6j2tj1dju”,“J6a1DLHC59uwffAEGaBMoa4pknjtMddmaXqtHEFTqypP”,“FsZb8CyxTaCD4PJBtbqhrvFeojrnwrcL9YwksvZXpA7o”,“3U8n7s1PixNWMJu4EMzDMCxXqpG61UmBs3XWWLXPdrjj”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbDmwXqqK5Zuj619au6q2Jx3TMr9ZV1837uxJcEwyvXVtV4HTExmriWFQrjmFvP9Y4VeksraTS2BaBdKHpYyGJekCJ
F2cahz2SxKip5WBEeFJxHGxX5aJGoPhAVMJ1toazRSoV1000000350144716MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr350144716-49u9G9uG5oq8ULF5ipLSQExXBevNhyA5ocCdnS4SQ6x8ABXFpod2Z2UjpzkEDZrwtav4QPjLGvBBsp19AThEDopz-2TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA49u9G9uG5oq8ULF5ipLSQExXBevNhyA5ocCdnS4SQ6x8ABXFpod2Z2UjpzkEDZrwtav4QPjLGvBBsp19AThEDopz2025-06-30T07:18:22.000Z2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXoSwapRouterBaseInHpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq22701021305[“GcJVsj5MxokA4eRMUkB4cJHuZ6o9Y8MooXBViN5F1mYW”,“BfEqPRVa4eZJK62TgAGNUGMBDKu5914cwgTHsdZGDGtT”,“7Vk54pQGBnwaVa4ERJ9XwJvyYgfyDpsyNepKYrAkHBnN”,“DUN9shf378AmHRh1Z3gzqF3eL5fATbgAZPZWVwvzMJVD”,“5Se5DVLV6xDU1eg2PuP8icqjsrCR2z6EuzLEFb9T5va4”,“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“437FvZvTkpAysjDNrbNunynn4sNQd24VhVZejfJCWyLo”,“AY9oHQGnqdohwNyoUoxWWLiZHmk7BeW4RSQK9F8n5mAQ”,“29117UdRkuMrefZARQNU9MAr11ytB361p4f2d2JQWGjy”,“DbtYdZEQT36SaQ7YcoxF4Hbc5zSv2HMd2KvRThZT6FQu”,“A6RftuphhXVJFGncMq1TFfdwJ5qVewKtudzrLdygnHE1”,“He4brjK7TRKiqJ8szpRmhuueDwC4837BFRRBmWfmjo14”,“5KKuejdZrFCoLGQPQQgcuP3Kd6fNhQQmemgshnwjpyQy”,“Ae1qsR1xwpWRMnFQKSrYHs6zTiFABULPX5hgWvfbBfJL”,“J3osYkYxxWT5NJcPujYn4P5CLtLyw7Em4eGDoxvLjD1c”,“2KE2qD6FHaHggcfjYXRNF2XSMniikNrBx59xyqChhcjT”,“Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB”,“GsT8bVw1rN7x1gBMAzzSzpyUAvBeuGrXHmqRdWiw94ZG”,“E2RCP7hoRW3k9ECznfwwm1HXnFZvxRq2jnhvVf2ViaUW”,“F6gtmgfPcf8NJZmZzg1CFs9oyfJbmpfEawMXzAJyjM77”,“74aUa6uCvqyRtVUn7pGBJiJWLT6DkicfNM1tXhGTkCx”,“3MM119fr4nQ7p4qN4RG9B4FubAzvK9VnwP3KvVP4nYFZ”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbF2cahz2SxKip5WBEeFJxHGxX5aJGoPhAVMJ1toazRSoVfzGSeGVV57xZ8Psyunj4qr6JMe6n4pcN2PTPAk8QbpD
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
amm_configSTRINGAccount address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
input_vaultSTRINGAccount address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key.
input_vault_mintSTRINGToken mint address for the input vault. Base58-encoded Solana public key.
memo_programSTRINGProgram address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key.
observation_stateSTRINGAccount address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
output_vaultSTRINGAccount address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key.
output_vault_mintSTRINGToken mint address for the output vault. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
pool_stateSTRINGAccount address representing the liquidity pool state. Base58-encoded Solana public key.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
token_program_2022STRINGProgram address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
is_base_inputBOOLBoolean flag indicating whether the input token corresponds to the base token in the liquidity pool’s trading pair.
other_amount_thresholdBIGNUMERICMinimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token.
sqrt_price_limit_x64BIGNUMERICPrice limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format).
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
payeramountamm_configblock_slotpool_stateinput_vaultmemo_programoutput_vaultis_base_inputsurrogate_keytoken_programtransaction_idblock_timestampinput_vault_mintinstruction_typeexecuting_accountinstruction_indexobservation_stateoutput_vault_minttransaction_indexremaining_accountstoken_program_2022transaction_signerinput_token_accountoutput_token_accountsqrt_price_limit_x64other_amount_thresholdouter_executing_accountouter_instruction_index
3nMNd89AxwHUa1AFvQGqohRkxFEQsTsgiEyEyqXFHyyH91967230685kosJrgZ6rHyqqweWGpp11nNqdwPTHbyXVczvzPM9h7M364036600E7vvEwfEXUeFdp8Rpxags8U1mZ56XYVRbVx3w1jRvgEC23zznfDs4vAbFsBU6dEjKYs4SLXr3ojhWzyAKnY2Drp4MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrGugtAySUEU7HwEMsZzgweQWioJpuFxDELs5qCxpDhdXFtrue364036600-5DZxguEcbVWoXBUVb5k8PbBi7CisoBiTZwbAfzqbWY13wyDvbnjYcmn3yai58m6MyzVtsbFpyewahqMm7UkM3VuX-2-14TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5DZxguEcbVWoXBUVb5k8PbBi7CisoBiTZwbAfzqbWY13wyDvbnjYcmn3yai58m6MyzVtsbFpyewahqMm7UkM3VuX2025-09-01T22:19:29.000Z7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hrSwapV2HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq14AnC7bqp385zAcVHEfvSgrRcQXKmMfWcaZAW5qKNrUgywSo11111111111111111111111111111111111111112199[“G7LDJmxiLJT2Hb969Y162gTF2eQkXdWqfqL9WyeDBPPk”,“8xtDq2dATztrAVdaypsiRtF2neUUFTmMMhYv2UU9n91H”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb3nMNd89AxwHUa1AFvQGqohRkxFEQsTsgiEyEyqXFHyyH3QEmytRpngHgbco3HuZKsBa85Y4ffBzYy6YLeZw2umqSAthF4CEubMxyPVkw8PKbLsPgs9sj6uRHLskGLuBybMpS019Zzf9QqTy3TkyXysvJBsXyuRjda5aXCEJ9vXfL2HKSYv2
HV1KXxWFaSeriyFvXyx48FqG9BoFbfinB8njCJonqP7K32579997GaWZjVasTQLCNmag5n34eyhhD4T56TN39ckNcuUmu7x4364031962GZp6RZrRhQocBgtogRf8YWx8PQHbh39LMtveAXs6tqyb26op6cJny3QCc91wVmwm1xZ3MnH6QWkYAm95DdvprKkWMemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr9HXBjNBLmKmS4G3LyHMPTRNFQyLZ7GLfc5Psfi5MuZ1Ztrue364031962-j5GLtcu3SDdd6tNB3QbE5izV7grqX2mJRqjVdsfMtpXPa51ZSufsLKeCYf9mh1ETRd2kBPLzZudnzR66GPPmi5Z-5-5TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAj5GLtcu3SDdd6tNB3QbE5izV7grqX2mJRqjVdsfMtpXPa51ZSufsLKeCYf9mh1ETRd2kBPLzZudnzR66GPPmi5Z2025-09-01T21:49:01.000ZDrZ26cKJDksVRWib3DVVsjo9eeXccc7hKhDJviiYEEZYSwapV2HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq5BS1vkcV4zTXoP5NNm1vg4LYK4wd2HdkGY4EkNJeERaGASo11111111111111111111111111111111111111112148[“7J4WLPYRDA2YZA2z1cTSzVRoeK45iz8PvUgdJMT6QAo2”,“B6pFSSsCPhjjE4GGBiqfwwBpt3Byep65vh2QnwWmcHQW”,“9btVQLV4skf4iYhNHHuHj33cLmnTLCBSfGHrscmLpeGJ”,“4eVupb3rbniPpQh294x8cZ8NjU5BaeZdp38cqhtRGjWw”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEbFdPxPcWndy6UWqqXtKCfBcuGYYsVV2xed9eTZPjWTuUdC7NBSb9ENdPChc5iCTnFZAJwy59y2TYYnbwD4266p7XY2rikd7tzPbmowhUJzPNVtX7fuUGcnBa8jqJnx6HbtHeE016m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma5
HV1KXxWFaSeriyFvXyx48FqG9BoFbfinB8njCJonqP7K503829GaWZjVasTQLCNmag5n34eyhhD4T56TN39ckNcuUmu7x4364040848GZp6RZrRhQocBgtogRf8YWx8PQHbh39LMtveAXs6tqyb26op6cJny3QCc91wVmwm1xZ3MnH6QWkYAm95DdvprKkWMemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr9HXBjNBLmKmS4G3LyHMPTRNFQyLZ7GLfc5Psfi5MuZ1Ztrue364040848-yo9tCeP9ccxWCKTKFJeKFQAprGqtHBqGewyGa3fGR91aBELZSYhqD99Lahm4cFpXjvPG6itiMQ3JaRacYj81xsE-4-12TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAyo9tCeP9ccxWCKTKFJeKFQAprGqtHBqGewyGa3fGR91aBELZSYhqD99Lahm4cFpXjvPG6itiMQ3JaRacYj81xsE2025-09-01T22:47:33.000ZDrZ26cKJDksVRWib3DVVsjo9eeXccc7hKhDJviiYEEZYSwapV2HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFq12BS1vkcV4zTXoP5NNm1vg4LYK4wd2HdkGY4EkNJeERaGASo1111111111111111111111111111111111111111260[“7J4WLPYRDA2YZA2z1cTSzVRoeK45iz8PvUgdJMT6QAo2”,“B6pFSSsCPhjjE4GGBiqfwwBpt3Byep65vh2QnwWmcHQW”,“9btVQLV4skf4iYhNHHuHj33cLmnTLCBSfGHrscmLpeGJ”,“4eVupb3rbniPpQh294x8cZ8NjU5BaeZdp38cqhtRGjWw”]TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb7DgbYgufUMs3yDShSJmBYLt3AKXjrk9NPx5WhVsJfU4gC7NBSb9ENdPChc5iCTnFZAJwy59y2TYYnbwD4266p7XY2rikd7tzPbmowhUJzPNVtX7fuUGcnBa8jqJnx6HbtHeE016m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma4
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