bonkswap_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.
`associated_token_program`	`STRING`	Program address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`pool_x_account`	`STRING`	Token account address holding the pool’s reserves of token_x. Owned by the pool program and used to track available liquidity for swaps.
`pool_y_account`	`STRING`	Token account address holding the pool’s reserves of token Y (the quote token in the trading pair). This is the pool-owned account from which token Y is debited or credited during swaps.
`program_authority`	`STRING`	Program-derived address (PDA) with authority to execute protocol operations. Base58-encoded Solana public key.
`referrer`	`STRING`	Optional address of an entity receiving a fee share from this swap transaction. Null when no referrer fee is applicable.
`referrer_x_account`	`STRING`	Solana account address holding token X on behalf of the referrer who facilitated this swap. Typically remains consistent across swaps for a given referrer-token pair on this DEX.
`referrer_y_account`	`STRING`	Solana token account address holding the Y token (quote token) for the referrer who facilitated this swap. Receives a portion of trading fees as referral reward.
`rent`	`STRING`	Program address of the Solana Rent Sysvar. Base58-encoded string, consistently SysvarRent111111111111111111111111111111111.
`state`	`STRING`	Account address of the protocol state configuration. Base58-encoded Solana public key.
`swapper`	`STRING`	Wallet address of the user initiating the swap transaction. Base58-encoded Solana public key that owns the token accounts being swapped.
`swapper_x_account`	`STRING`	Token account owned by the swapper holding token_x balance. Base58-encoded Solana account address used as the source or destination for token_x in the swap.
`swapper_y_account`	`STRING`	Account address holding the swapper’s token Y balance for this trade. This is the token account controlled by the swapper for the Y-side token in the pool.
`system_program`	`STRING`	Program address of the Solana System Program. 32-character string of ones representing the native system program identifier.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`token_x`	`STRING`	Token address of the first asset (X) in the liquidity pool trading pair. Base-58 encoded Solana program address identifying the SPL token being swapped.
`token_y`	`STRING`	Token account address representing the Y-side asset in the liquidity pool on Solana. Typically represents the quote token in trading pairs (e.g., SOL, USDC).
`delta_in`	`BIGNUMERIC`	Token amount being swapped into the pool, denominated in the input token’s smallest unit. Null values indicate incomplete or failed swap instructions.
`price_limit`	`BIGNUMERIC`	Maximum acceptable price ratio for the swap expressed as a fixed-point numeric value. Prevents unfavorable execution if pool price moves beyond this threshold during transaction processing.
`x_to_y`	`BOOL`	Direction indicator for token swap within a liquidity pool. True represents swapping from token X to token Y, false represents swapping from token Y to token X.
`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

pool	rent	state	x_to_y	swapper	token_x	token_y	delta_in	referrer	block_slot	price_limit	surrogate_key	token_program	pool_x_account	pool_y_account	system_program	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	program_authority	swapper_x_account	swapper_y_account	transaction_index	referrer_x_account	referrer_y_account	remaining_accounts	transaction_signer	associated_token_program
GBmzQL7BTKwSV9Qg7h5iXQad1q61xwMSzMpdbBkCyo2p	SysvarRent111111111111111111111111111111111	2QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRD	true	DrmErrsyieqUWb7Da2k9TzXdM39AW2fp7hbco1Y5dCQU	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263	So11111111111111111111111111111111111111112	267654518646	MaPoNRu6RgbTkE978RYGuaXKobsciLLTDdgL6juqh68	199579740	192393623	199579740-4LH88h53KjNoF8GamfFgaaL7cWmzYmLnqs5bibj8rHUT7eijUbdgCqmrgjFNmizb9cXiUobwhzKmkR1Lg2TQ1kt6-1	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	DBW3ZfheSXEWzqcoUCy11dX4uazNbGTar7LmBMXReJpZ	An9rnaGYDHJVzvmxGEwrTTjCPszWRzkvF8dEypmhhajU	11111111111111111111111111111111	4LH88h53KjNoF8GamfFgaaL7cWmzYmLnqs5bibj8rHUT7eijUbdgCqmrgjFNmizb9cXiUobwhzKmkR1Lg2TQ1kt6	2023-06-14T20:20:12.000Z	Swap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	1	8NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2	5YtfvpuXSxg9zwn7aYq7KK87TYPSLXNivD7RpmDxsqic	3X6V418xeaaV3buUXCn4iSdbKAqXyAx2KLWHoWKE9nYh	15	2jAzUVRomfPikrmSikqBNf5NrPKesUGDdonpHmCjrXPz	4aXk3qtcipQRXy7Uru49o5YGuuBbjCpH5G7rS6qcCuRF	[]	DrmErrsyieqUWb7Da2k9TzXdM39AW2fp7hbco1Y5dCQU	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
GBmzQL7BTKwSV9Qg7h5iXQad1q61xwMSzMpdbBkCyo2p	SysvarRent111111111111111111111111111111111	2QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRD	false	84YwggDxtCxPWsgHWtKcCzx17X7r5o791TX9b9rru6Aq	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263	So11111111111111111111111111111111111111112	20000	MaPoNRu6RgbTkE978RYGuaXKobsciLLTDdgL6juqh68	199583049	196030231	199583049-4dpTx4D1oYWCbJGS69Dx9rGopMbKCZSBWXSX9RpkxAWYzcbX9MPvEJ1eWhgpjg618p4XR5AxEJR6Ce8jq3Z3Ev4z-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	DBW3ZfheSXEWzqcoUCy11dX4uazNbGTar7LmBMXReJpZ	An9rnaGYDHJVzvmxGEwrTTjCPszWRzkvF8dEypmhhajU	11111111111111111111111111111111	4dpTx4D1oYWCbJGS69Dx9rGopMbKCZSBWXSX9RpkxAWYzcbX9MPvEJ1eWhgpjg618p4XR5AxEJR6Ce8jq3Z3Ev4z	2023-06-14T20:47:45.000Z	Swap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	3	8NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2	DqHLUBqSCvDaMH3pymYvVGKLuwSTMkyN4HvjxsHV67g1	6cTtSHfonjBpgYmKfXLhsLqpcfTY3WSMe4mFZdVCz3mU	1	2jAzUVRomfPikrmSikqBNf5NrPKesUGDdonpHmCjrXPz	4aXk3qtcipQRXy7Uru49o5YGuuBbjCpH5G7rS6qcCuRF	[]	84YwggDxtCxPWsgHWtKcCzx17X7r5o791TX9b9rru6Aq	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
5MMaArf3NgUjaDqYZiwYP2wbXLd8myKmmYzBzzqdfYSb	SysvarRent111111111111111111111111111111111	2QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRD	true	GxEzfQzjh5vBreYwyiVySo5Ti78R2Uj4pPKeTxPkMewb	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	41422229	MaPoNRu6RgbTkE978RYGuaXKobsciLLTDdgL6juqh68	199598950	2744650	199598950-285LHumVstVQjhxVrowKbHW9bFRRH8Z8Ef2fzEF4kdBwqrDhkQqFNxSMzuaCWtxPDsUJhR4F7CXgpNFEnaNJnGup-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	DugwxEmZkNzAH3VfMf8ySCZCGimmkUHG2nxkRmB66sUU	Dww7FQaVx6YN3Y5xba12RixH6BjnHmFL1jaoJgnS5tGW	11111111111111111111111111111111	285LHumVstVQjhxVrowKbHW9bFRRH8Z8Ef2fzEF4kdBwqrDhkQqFNxSMzuaCWtxPDsUJhR4F7CXgpNFEnaNJnGup	2023-06-14T22:50:31.000Z	Swap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	0	8NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2	DqR7vbrNAit1Ze58LDbt4DshBQCKcziXGE2jbv5F7iYe	6tLZdBwzVECsXBLtZR9q12RaBpYwy3cbq73FuTwTUBk1	96	2jAzUVRomfPikrmSikqBNf5NrPKesUGDdonpHmCjrXPz	FADDueZePTP5ArSbzsMgsHMFs2RZsXycRDDzYaFQyZVo	[]	GxEzfQzjh5vBreYwyiVySo5Ti78R2Uj4pPKeTxPkMewb	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL

Example Query

Query with partition filter

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

Swap_Swap_instruction

Token swap instructions from Bonkswap decentralized exchange (DEX) on Solana. Records individual swap executions with input amounts, price limits, token pair identifiers, and wallet addresses for analyzing DEX trading volume and liquidity 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.
`associated_token_program`	`STRING`	Program address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`pool_x_account`	`STRING`	Token account address holding the pool’s reserves of token_x for this liquidity pool. This account is debited or credited depending on swap direction.
`pool_y_account`	`STRING`	Token account holding the pool’s reserves of the Y token in the liquidity pair. Base58-encoded Solana account address that stores the actual token balance for one side of the swap pool.
`program_authority`	`STRING`	Program-derived address (PDA) with authority to execute protocol operations. Base58-encoded Solana public key.
`referrer`	`STRING`	Account address that receives a referral fee for routing the swap. Present when the swap was facilitated through a third-party aggregator or interface.
`referrer_x_account`	`STRING`	Solana account address that receives referral fees in token X for facilitating this swap. Base58-encoded string identifier for the fee recipient’s token account.
`referrer_y_account`	`STRING`	Token account address holding the Y-side token balance for the referrer receiving fees. May be null if no referrer participates in the swap.
`rent`	`STRING`	Program address of the Solana Rent Sysvar. Base58-encoded string, consistently SysvarRent111111111111111111111111111111111.
`state`	`STRING`	Account address of the protocol state configuration. Base58-encoded Solana public key.
`swapper`	`STRING`	Account address of the user initiating the swap transaction on BonkSwap. Base58-encoded Solana public key, consistent across multiple swaps by the same user.
`swapper_x_account`	`STRING`	Account address holding the swapper’s token X balance for this swap transaction. Base58-encoded Solana address representing the user’s token account for the input or output token depending on swap direction.
`swapper_y_account`	`STRING`	Account address holding the swapper’s balance of token_y (the quote token in the pool). This is the token account that receives tokens when swapping from token_x or sends tokens when swapping to token_x.
`system_program`	`STRING`	Program address of the Solana System Program. 32-character string of ones representing the native system program identifier.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`token_x`	`STRING`	Token address for the first asset in the trading pair on Solana. Base58-encoded public key identifying the SPL token being swapped.
`token_y`	`STRING`	Token account address for the Y token in the liquidity pool pair. Base58-encoded Solana address that represents the second token in the trading pair.
`delta_in`	`BIGNUMERIC`	Input amount of the source token being swapped into the pool. Denominated in the token’s smallest unit (lamports for SOL-based tokens).
`price_limit`	`BIGNUMERIC`	Maximum acceptable price for the swap, expressed as a square root price boundary to prevent excessive slippage. Set to 0 for token_x to token_y swaps or maximum value for token_y to token_x swaps.
`x_to_y`	`BOOL`	Direction indicator for token swap within a liquidity pool. True represents swapping from token X to token Y, false represents swapping from token Y to token X.
`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

pool	rent	state	x_to_y	swapper	token_x	token_y	delta_in	referrer	block_slot	price_limit	surrogate_key	token_program	pool_x_account	pool_y_account	system_program	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	program_authority	swapper_x_account	swapper_y_account	transaction_index	referrer_x_account	referrer_y_account	remaining_accounts	transaction_signer	outer_executing_account	outer_instruction_index	associated_token_program
7rrhoufMtAW8d6d1F8tCGbSKVsbeYesFt3bCMn6uf7XL	SysvarRent111111111111111111111111111111111	2QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRD	true	xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbv	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263	2VhjJ9WxaGC3EZFwJG9BDUs9KxKCAjQY4vgd1qxgYWVg	10077027707	BUX7s2ef2htTGb2KKoPHWkmzxPj4nTWMWRgs5CSbQxf9	280765917	0	280765917-5sa6azAVMwjFxQLfD71rRBQqoWQPshBSsRNieVKmagAGvi787Skimk5TNegsmRGUBDTuzHpnKKXUCh7smE6wsh9-2-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3ztm9ogFW8zg4MmTNnn2k9JqAw6Xvn4EBaYQExAaKY6a	4GGRTWRfYdZySCgRrtfmnCpnfxQzZmn7e8gxVCot4w9n	11111111111111111111111111111111	5sa6azAVMwjFxQLfD71rRBQqoWQPshBSsRNieVKmagAGvi787Skimk5TNegsmRGUBDTuzHpnKKXUCh7smE6wsh9	2024-07-31T16:32:43.000Z	Swap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	5	8NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2	34ekELGhHKuUL2nFCMyvmSutDG8iJQM4PGBtDpJFyiTB	HxtkdgZsbGKMGkTEUvCb65466oGVYGaurDufmmBb5Ked	84	8bjsQA7jXATyc3QbQ3bap7E2uMnsidmJnpHCdaQn7Ae4	24RjgyhiC5sd9yfbYvQUmVNAbKyo9Qd39MGgJ7stxp8w	[]	xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbv	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
7rrhoufMtAW8d6d1F8tCGbSKVsbeYesFt3bCMn6uf7XL	SysvarRent111111111111111111111111111111111	2QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRD	false	xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbv	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263	2VhjJ9WxaGC3EZFwJG9BDUs9KxKCAjQY4vgd1qxgYWVg	1678696	BUX7s2ef2htTGb2KKoPHWkmzxPj4nTWMWRgs5CSbQxf9	280746000	3.40282366920938463463374607431768211455e+38	280746000-Neg72FfvmNnES9ZxA1oyZAoFgTLAje1USZL2LpnwPP1XmJXJDajr2qAjgHCWH5C6myv3VS7XZfGUWMKg4mebLgi-2-9	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3ztm9ogFW8zg4MmTNnn2k9JqAw6Xvn4EBaYQExAaKY6a	4GGRTWRfYdZySCgRrtfmnCpnfxQzZmn7e8gxVCot4w9n	11111111111111111111111111111111	Neg72FfvmNnES9ZxA1oyZAoFgTLAje1USZL2LpnwPP1XmJXJDajr2qAjgHCWH5C6myv3VS7XZfGUWMKg4mebLgi	2024-07-31T14:07:49.000Z	Swap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	9	8NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2	34ekELGhHKuUL2nFCMyvmSutDG8iJQM4PGBtDpJFyiTB	HxtkdgZsbGKMGkTEUvCb65466oGVYGaurDufmmBb5Ked	298	8bjsQA7jXATyc3QbQ3bap7E2uMnsidmJnpHCdaQn7Ae4	24RjgyhiC5sd9yfbYvQUmVNAbKyo9Qd39MGgJ7stxp8w	[]	xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbv	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
7rrhoufMtAW8d6d1F8tCGbSKVsbeYesFt3bCMn6uf7XL	SysvarRent111111111111111111111111111111111	2QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRD	true	xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbv	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263	2VhjJ9WxaGC3EZFwJG9BDUs9KxKCAjQY4vgd1qxgYWVg	7874288515	BUX7s2ef2htTGb2KKoPHWkmzxPj4nTWMWRgs5CSbQxf9	280716607	0	280716607-5GPPaHjkcVD98BdABCwjEyEuVjWBsA8DH2YP9oczewRtTXWqqSgtANV9hYLcM7c5t59aSUwuv1o5q1mcBp44dEMy-2-5	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3ztm9ogFW8zg4MmTNnn2k9JqAw6Xvn4EBaYQExAaKY6a	4GGRTWRfYdZySCgRrtfmnCpnfxQzZmn7e8gxVCot4w9n	11111111111111111111111111111111	5GPPaHjkcVD98BdABCwjEyEuVjWBsA8DH2YP9oczewRtTXWqqSgtANV9hYLcM7c5t59aSUwuv1o5q1mcBp44dEMy	2024-07-31T10:34:13.000Z	Swap	BSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p	5	8NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2	34ekELGhHKuUL2nFCMyvmSutDG8iJQM4PGBtDpJFyiTB	HxtkdgZsbGKMGkTEUvCb65466oGVYGaurDufmmBb5Ked	44	8bjsQA7jXATyc3QbQ3bap7E2uMnsidmJnpHCdaQn7Ae4	24RjgyhiC5sd9yfbYvQUmVNAbKyo9Qd39MGgJ7stxp8w	[]	xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbv	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	2	ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Swap_instruction

Swap_Swap_instruction

​Tables

​Swap_instruction

​Swap_Swap_instruction

Tables

Swap_instruction

Swap_Swap_instruction