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.
associated_token_programSTRINGProgram address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
pool_x_accountSTRINGToken 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_accountSTRINGToken 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_authoritySTRINGProgram-derived address (PDA) with authority to execute protocol operations. Base58-encoded Solana public key.
referrerSTRINGOptional address of an entity receiving a fee share from this swap transaction. Null when no referrer fee is applicable.
referrer_x_accountSTRINGSolana 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_accountSTRINGSolana 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.
rentSTRINGProgram address of the Solana Rent Sysvar. Base58-encoded string, consistently SysvarRent111111111111111111111111111111111.
stateSTRINGAccount address of the protocol state configuration. Base58-encoded Solana public key.
swapperSTRINGWallet address of the user initiating the swap transaction. Base58-encoded Solana public key that owns the token accounts being swapped.
swapper_x_accountSTRINGToken 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_accountSTRINGAccount 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_programSTRINGProgram address of the Solana System Program. 32-character string of ones representing the native system program identifier.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
token_xSTRINGToken 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_ySTRINGToken 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_inBIGNUMERICToken amount being swapped into the pool, denominated in the input token’s smallest unit. Null values indicate incomplete or failed swap instructions.
price_limitBIGNUMERICMaximum 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_yBOOLDirection 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_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
poolrentstatex_to_yswappertoken_xtoken_ydelta_inreferrerblock_slotprice_limitsurrogate_keytoken_programpool_x_accountpool_y_accountsystem_programtransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indexprogram_authorityswapper_x_accountswapper_y_accounttransaction_indexreferrer_x_accountreferrer_y_accountremaining_accountstransaction_signerouter_executing_accountouter_instruction_indexassociated_token_program
GBmzQL7BTKwSV9Qg7h5iXQad1q61xwMSzMpdbBkCyo2pSysvarRent1111111111111111111111111111111112QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRDtrueDrmErrsyieqUWb7Da2k9TzXdM39AW2fp7hbco1Y5dCQUDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263So11111111111111111111111111111111111111112267654518646MaPoNRu6RgbTkE978RYGuaXKobsciLLTDdgL6juqh68199579740192393623199579740-4LH88h53KjNoF8GamfFgaaL7cWmzYmLnqs5bibj8rHUT7eijUbdgCqmrgjFNmizb9cXiUobwhzKmkR1Lg2TQ1kt6-1TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DADBW3ZfheSXEWzqcoUCy11dX4uazNbGTar7LmBMXReJpZAn9rnaGYDHJVzvmxGEwrTTjCPszWRzkvF8dEypmhhajU111111111111111111111111111111114LH88h53KjNoF8GamfFgaaL7cWmzYmLnqs5bibj8rHUT7eijUbdgCqmrgjFNmizb9cXiUobwhzKmkR1Lg2TQ1kt62023-06-14T20:20:12.000ZSwapBSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p18NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK25YtfvpuXSxg9zwn7aYq7KK87TYPSLXNivD7RpmDxsqic3X6V418xeaaV3buUXCn4iSdbKAqXyAx2KLWHoWKE9nYh152jAzUVRomfPikrmSikqBNf5NrPKesUGDdonpHmCjrXPz4aXk3qtcipQRXy7Uru49o5YGuuBbjCpH5G7rS6qcCuRF[]DrmErrsyieqUWb7Da2k9TzXdM39AW2fp7hbco1Y5dCQUATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
GBmzQL7BTKwSV9Qg7h5iXQad1q61xwMSzMpdbBkCyo2pSysvarRent1111111111111111111111111111111112QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRDfalse84YwggDxtCxPWsgHWtKcCzx17X7r5o791TX9b9rru6AqDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263So1111111111111111111111111111111111111111220000MaPoNRu6RgbTkE978RYGuaXKobsciLLTDdgL6juqh68199583049196030231199583049-4dpTx4D1oYWCbJGS69Dx9rGopMbKCZSBWXSX9RpkxAWYzcbX9MPvEJ1eWhgpjg618p4XR5AxEJR6Ce8jq3Z3Ev4z-3TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DADBW3ZfheSXEWzqcoUCy11dX4uazNbGTar7LmBMXReJpZAn9rnaGYDHJVzvmxGEwrTTjCPszWRzkvF8dEypmhhajU111111111111111111111111111111114dpTx4D1oYWCbJGS69Dx9rGopMbKCZSBWXSX9RpkxAWYzcbX9MPvEJ1eWhgpjg618p4XR5AxEJR6Ce8jq3Z3Ev4z2023-06-14T20:47:45.000ZSwapBSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p38NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2DqHLUBqSCvDaMH3pymYvVGKLuwSTMkyN4HvjxsHV67g16cTtSHfonjBpgYmKfXLhsLqpcfTY3WSMe4mFZdVCz3mU12jAzUVRomfPikrmSikqBNf5NrPKesUGDdonpHmCjrXPz4aXk3qtcipQRXy7Uru49o5YGuuBbjCpH5G7rS6qcCuRF[]84YwggDxtCxPWsgHWtKcCzx17X7r5o791TX9b9rru6AqATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
5MMaArf3NgUjaDqYZiwYP2wbXLd8myKmmYzBzzqdfYSbSysvarRent1111111111111111111111111111111112QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRDtrueGxEzfQzjh5vBreYwyiVySo5Ti78R2Uj4pPKeTxPkMewbDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v41422229MaPoNRu6RgbTkE978RYGuaXKobsciLLTDdgL6juqh681995989502744650199598950-285LHumVstVQjhxVrowKbHW9bFRRH8Z8Ef2fzEF4kdBwqrDhkQqFNxSMzuaCWtxPDsUJhR4F7CXgpNFEnaNJnGup-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DADugwxEmZkNzAH3VfMf8ySCZCGimmkUHG2nxkRmB66sUUDww7FQaVx6YN3Y5xba12RixH6BjnHmFL1jaoJgnS5tGW11111111111111111111111111111111285LHumVstVQjhxVrowKbHW9bFRRH8Z8Ef2fzEF4kdBwqrDhkQqFNxSMzuaCWtxPDsUJhR4F7CXgpNFEnaNJnGup2023-06-14T22:50:31.000ZSwapBSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p08NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK2DqR7vbrNAit1Ze58LDbt4DshBQCKcziXGE2jbv5F7iYe6tLZdBwzVECsXBLtZR9q12RaBpYwy3cbq73FuTwTUBk1962jAzUVRomfPikrmSikqBNf5NrPKesUGDdonpHmCjrXPzFADDueZePTP5ArSbzsMgsHMFs2RZsXycRDDzYaFQyZVo[]GxEzfQzjh5vBreYwyiVySo5Ti78R2Uj4pPKeTxPkMewbATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
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.
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.
associated_token_programSTRINGProgram address of the Associated Token Account (ATA) Program on Solana. Base58-encoded Solana public key, consistently ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
pool_x_accountSTRINGToken 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_accountSTRINGToken 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_authoritySTRINGProgram-derived address (PDA) with authority to execute protocol operations. Base58-encoded Solana public key.
referrerSTRINGAccount 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_accountSTRINGSolana 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_accountSTRINGToken account address holding the Y-side token balance for the referrer receiving fees. May be null if no referrer participates in the swap.
rentSTRINGProgram address of the Solana Rent Sysvar. Base58-encoded string, consistently SysvarRent111111111111111111111111111111111.
stateSTRINGAccount address of the protocol state configuration. Base58-encoded Solana public key.
swapperSTRINGAccount 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_accountSTRINGAccount 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_accountSTRINGAccount 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_programSTRINGProgram address of the Solana System Program. 32-character string of ones representing the native system program identifier.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
token_xSTRINGToken address for the first asset in the trading pair on Solana. Base58-encoded public key identifying the SPL token being swapped.
token_ySTRINGToken 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_inBIGNUMERICInput amount of the source token being swapped into the pool. Denominated in the token’s smallest unit (lamports for SOL-based tokens).
price_limitBIGNUMERICMaximum 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_yBOOLDirection 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_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
poolrentstatex_to_yswappertoken_xtoken_ydelta_inreferrerblock_slotprice_limitsurrogate_keytoken_programpool_x_accountpool_y_accountsystem_programtransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indexprogram_authorityswapper_x_accountswapper_y_accounttransaction_indexreferrer_x_accountreferrer_y_accountremaining_accountstransaction_signerouter_executing_accountouter_instruction_indexassociated_token_program
7rrhoufMtAW8d6d1F8tCGbSKVsbeYesFt3bCMn6uf7XLSysvarRent1111111111111111111111111111111112QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRDtruexGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbvDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB2632VhjJ9WxaGC3EZFwJG9BDUs9KxKCAjQY4vgd1qxgYWVg10077027707BUX7s2ef2htTGb2KKoPHWkmzxPj4nTWMWRgs5CSbQxf92807659170280765917-5sa6azAVMwjFxQLfD71rRBQqoWQPshBSsRNieVKmagAGvi787Skimk5TNegsmRGUBDTuzHpnKKXUCh7smE6wsh9-2-5TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA3ztm9ogFW8zg4MmTNnn2k9JqAw6Xvn4EBaYQExAaKY6a4GGRTWRfYdZySCgRrtfmnCpnfxQzZmn7e8gxVCot4w9n111111111111111111111111111111115sa6azAVMwjFxQLfD71rRBQqoWQPshBSsRNieVKmagAGvi787Skimk5TNegsmRGUBDTuzHpnKKXUCh7smE6wsh92024-07-31T16:32:43.000ZSwapBSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p58NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK234ekELGhHKuUL2nFCMyvmSutDG8iJQM4PGBtDpJFyiTBHxtkdgZsbGKMGkTEUvCb65466oGVYGaurDufmmBb5Ked848bjsQA7jXATyc3QbQ3bap7E2uMnsidmJnpHCdaQn7Ae424RjgyhiC5sd9yfbYvQUmVNAbKyo9Qd39MGgJ7stxp8w[]xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbvJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
7rrhoufMtAW8d6d1F8tCGbSKVsbeYesFt3bCMn6uf7XLSysvarRent1111111111111111111111111111111112QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRDfalsexGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbvDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB2632VhjJ9WxaGC3EZFwJG9BDUs9KxKCAjQY4vgd1qxgYWVg1678696BUX7s2ef2htTGb2KKoPHWkmzxPj4nTWMWRgs5CSbQxf92807460003.40282366920938463463374607431768211455e+38280746000-Neg72FfvmNnES9ZxA1oyZAoFgTLAje1USZL2LpnwPP1XmJXJDajr2qAjgHCWH5C6myv3VS7XZfGUWMKg4mebLgi-2-9TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA3ztm9ogFW8zg4MmTNnn2k9JqAw6Xvn4EBaYQExAaKY6a4GGRTWRfYdZySCgRrtfmnCpnfxQzZmn7e8gxVCot4w9n11111111111111111111111111111111Neg72FfvmNnES9ZxA1oyZAoFgTLAje1USZL2LpnwPP1XmJXJDajr2qAjgHCWH5C6myv3VS7XZfGUWMKg4mebLgi2024-07-31T14:07:49.000ZSwapBSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p98NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK234ekELGhHKuUL2nFCMyvmSutDG8iJQM4PGBtDpJFyiTBHxtkdgZsbGKMGkTEUvCb65466oGVYGaurDufmmBb5Ked2988bjsQA7jXATyc3QbQ3bap7E2uMnsidmJnpHCdaQn7Ae424RjgyhiC5sd9yfbYvQUmVNAbKyo9Qd39MGgJ7stxp8w[]xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbvJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
7rrhoufMtAW8d6d1F8tCGbSKVsbeYesFt3bCMn6uf7XLSysvarRent1111111111111111111111111111111112QWN6WjrJ3RAk51ecxLxaLPfFCYLAnmWJwJ1oKA92CRDtruexGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbvDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB2632VhjJ9WxaGC3EZFwJG9BDUs9KxKCAjQY4vgd1qxgYWVg7874288515BUX7s2ef2htTGb2KKoPHWkmzxPj4nTWMWRgs5CSbQxf92807166070280716607-5GPPaHjkcVD98BdABCwjEyEuVjWBsA8DH2YP9oczewRtTXWqqSgtANV9hYLcM7c5t59aSUwuv1o5q1mcBp44dEMy-2-5TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA3ztm9ogFW8zg4MmTNnn2k9JqAw6Xvn4EBaYQExAaKY6a4GGRTWRfYdZySCgRrtfmnCpnfxQzZmn7e8gxVCot4w9n111111111111111111111111111111115GPPaHjkcVD98BdABCwjEyEuVjWBsA8DH2YP9oczewRtTXWqqSgtANV9hYLcM7c5t59aSUwuv1o5q1mcBp44dEMy2024-07-31T10:34:13.000ZSwapBSwp6bEBihVLdqJRKGgzjcGLHkcTuzmSo1TQkHepzH8p58NyaPDJeC2eaBGpkRpZKnD9S448AZGgjSvumFe92DRK234ekELGhHKuUL2nFCMyvmSutDG8iJQM4PGBtDpJFyiTBHxtkdgZsbGKMGkTEUvCb65466oGVYGaurDufmmBb5Ked448bjsQA7jXATyc3QbQ3bap7E2uMnsidmJnpHCdaQn7Ae424RjgyhiC5sd9yfbYvQUmVNAbKyo9Qd39MGgJ7stxp8w[]xGexTsXWrM6nrXErxrwS4u877EUKiHbXMiVe5rhVxbvJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42ATokenGPvbdGVxr1b2hvZbsiqW5xWH25efTNsLJA8knL
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