Skip to main content

Tables

DAMM_v1_Swap_instruction

Swap instructions from Meteora’s Dynamic Automated Market Maker (DAMM) v1 pools on Solana, capturing token exchanges with vault addresses, input amounts, and minimum output thresholds. Useful for analyzing liquidity provider activity and routing patterns through Jupiter aggregator integrations.
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.
a_token_vaultSTRINGToken account address holding the reserves for vault A in the liquidity pool. This account stores the actual tokens that users swap against in the A-side of the pool.
a_vaultSTRINGToken account address for vault A in the Meteora DAMM (Dynamic Automated Market Maker) pool. This vault holds one side of the liquidity pair and is referenced across all swap operations for this pool.
a_vault_lpSTRINGLiquidity provider (LP) token account for vault A in the pool. Base-58 encoded Solana account address holding the LP tokens representing the first side of the liquidity pair.
a_vault_lp_mintSTRINGMint address for the LP (Liquidity Provider) tokens representing the user’s share of vault A’s liquidity. Base58-encoded Solana account address, distinct from the vault’s underlying token mint.
b_token_vaultSTRINGToken account holding assets for vault B within the Meteora DAMM (Dynamic Automated Market Maker) pool. Base58-encoded Solana address that stores the actual token reserves for the second side of the trading pair.
b_vaultSTRINGSolana account address of the vault holding the second token (token B) in the liquidity pool. Base58-encoded string representing a Solana public key, consistently paired with a_vault across all swap operations.
b_vault_lpSTRINGLiquidity provider (LP) token account for vault B within the DAMM pool. Represents the user’s share of liquidity deposited in the B-side vault.
b_vault_lp_mintSTRINGMint address for the liquidity provider (LP) token of vault B in the Meteora DAMM pool. This represents the token issued to liquidity providers for their share of vault B.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
protocol_token_feeSTRINGAccount address receiving the protocol fee from this swap. Base58-encoded Solana address that collects a percentage of the swap amount as platform revenue.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_destination_tokenSTRINGAccount address of the user’s token account receiving the output tokens from the swap. Base58-encoded Solana public key.
user_source_tokenSTRINGAccount address of the user’s token account providing the input tokens for the swap. Base58-encoded Solana public key.
vault_programSTRINGProgram address managing vault operations for the swap protocol. Base58-encoded Solana public key.
in_amountBIGNUMERICInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
minimum_out_amountBIGNUMERICMinimum amount of tokens the user is willing to receive from the swap, serving as slippage protection. Commonly set to zero in these samples, indicating no minimum output enforcement at the instruction level.
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.
poolusera_vaultb_vaultin_amounta_vault_lpb_vault_lpblock_slota_token_vaultb_token_vaultsurrogate_keytoken_programvault_programtransaction_ida_vault_lp_mintb_vault_lp_mintblock_timestampinstruction_typeexecuting_accountinstruction_indextransaction_indexuser_source_tokenminimum_out_amountprotocol_token_feeremaining_accountstransaction_signeruser_destination_tokenouter_executing_accountouter_instruction_index
278P6iwdEeX5tUFMGxmi2tii3EAho4iHzfiroKLKCQKj5SeNtCBx15SLG7VHKh1g5Ntj3pBUvo5ik1RBMz6uWsD7J9K67PxqqvCRW9tiDHB9bAisgNQSMLU1bvExtexyd7VeFERjPVNEa7Udq8CEv68h6tPL46Tq7ieE49HrE2wea3XT20947868485EEbxC3sYKKRmEUMGSFcAUz543bN6bXq7yX7GjbDuYzfs6ZCdLLXMU8yNEnP1FXTy5qEsUZNPg5wwCEPuo3uU38n520569919966i1ucUah4Qi1sv4KhdonGRsGGr7zmGPeMC3eSzR8BixHZeLxbZ9uHtSpwZC3LBr4Nubd14iHwz7bRSghRZf5VCG205699199-5pBWNu37LbLYYpuq7R1r9De5bsmR69K4Z8t2329QoqHg627XzPLhrjTQqjqS62LP1sAojFeS98su7wqQp7Xt3fG9-3-7TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi5pBWNu37LbLYYpuq7R1r9De5bsmR69K4Z8t2329QoqHg627XzPLhrjTQqjqS62LP1sAojFeS98su7wqQp7Xt3fG95fzuPMnSeGFhUFN6szN8tqL676TDE1m4YH13ZC1LKzc2FZN7QZ8ZUUAxMPfxYEYkH3cXUASzH8EqA6B4tyCL8f1j2023-07-16T14:17:12.000ZSwapEo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB71429Y9jEURacFhPVcgPWqzgLt2ASUN624YVgNG7EkW61uS05v9er1pzWpsxo1dDuEQsRpSoETVndryoENJ8rVrdEGQQ[]5SeNtCBx15SLG7VHKh1g5Ntj3pBUvo5ik1RBMz6uWsD75Qy1tfGek99jtxxXQ1Zvgw4aQKmFZeWjBxSESXFDnYNiJUP5cHjnnCx2DppVsufsLrXs8EBZeEZzGtEK9Gdz6ow3
278P6iwdEeX5tUFMGxmi2tii3EAho4iHzfiroKLKCQKj5SeNtCBx15SLG7VHKh1g5Ntj3pBUvo5ik1RBMz6uWsD7J9K67PxqqvCRW9tiDHB9bAisgNQSMLU1bvExtexyd7VeFERjPVNEa7Udq8CEv68h6tPL46Tq7ieE49HrE2wea3XT20981819188EEbxC3sYKKRmEUMGSFcAUz543bN6bXq7yX7GjbDuYzfs6ZCdLLXMU8yNEnP1FXTy5qEsUZNPg5wwCEPuo3uU38n520569890566i1ucUah4Qi1sv4KhdonGRsGGr7zmGPeMC3eSzR8BixHZeLxbZ9uHtSpwZC3LBr4Nubd14iHwz7bRSghRZf5VCG205698905-2iTdXRMeokbp99iofQnQQNAynZtG4nQTy8wLvnyzG3i6zhcML92QEaGWkubx8makZQtigPYtf4UnQop4uC687iqf-3-6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi2iTdXRMeokbp99iofQnQQNAynZtG4nQTy8wLvnyzG3i6zhcML92QEaGWkubx8makZQtigPYtf4UnQop4uC687iqf5fzuPMnSeGFhUFN6szN8tqL676TDE1m4YH13ZC1LKzc2FZN7QZ8ZUUAxMPfxYEYkH3cXUASzH8EqA6B4tyCL8f1j2023-07-16T14:15:00.000ZSwapEo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB61329Y9jEURacFhPVcgPWqzgLt2ASUN624YVgNG7EkW61uS05v9er1pzWpsxo1dDuEQsRpSoETVndryoENJ8rVrdEGQQ[]5SeNtCBx15SLG7VHKh1g5Ntj3pBUvo5ik1RBMz6uWsD75Qy1tfGek99jtxxXQ1Zvgw4aQKmFZeWjBxSESXFDnYNiJUP5cHjnnCx2DppVsufsLrXs8EBZeEZzGtEK9Gdz6ow3
278P6iwdEeX5tUFMGxmi2tii3EAho4iHzfiroKLKCQKj4XaLErom3SxqyZMNccdUqeyaA6b3UEJkDg1bAg3E5a8mJ9K67PxqqvCRW9tiDHB9bAisgNQSMLU1bvExtexyd7VeFERjPVNEa7Udq8CEv68h6tPL46Tq7ieE49HrE2wea3XT18252067EEbxC3sYKKRmEUMGSFcAUz543bN6bXq7yX7GjbDuYzfs6ZCdLLXMU8yNEnP1FXTy5qEsUZNPg5wwCEPuo3uU38n520574290066i1ucUah4Qi1sv4KhdonGRsGGr7zmGPeMC3eSzR8BixHZeLxbZ9uHtSpwZC3LBr4Nubd14iHwz7bRSghRZf5VCG205742900-4GXxgkJ5Rd9HUnut9Rv9YnGAVHWQt9tzfuEe63zoRdy91ecze78hAHm1mpaw7m7N6AWQQkt67FU5ivW3KFSncmZo-2-3TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi4GXxgkJ5Rd9HUnut9Rv9YnGAVHWQt9tzfuEe63zoRdy91ecze78hAHm1mpaw7m7N6AWQQkt67FU5ivW3KFSncmZo5fzuPMnSeGFhUFN6szN8tqL676TDE1m4YH13ZC1LKzc2FZN7QZ8ZUUAxMPfxYEYkH3cXUASzH8EqA6B4tyCL8f1j2023-07-16T19:41:32.000ZSwapEo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB3693SBAtrSCmNzXTpChe12uAtsuKu8UGP6KwbTd9kG4zcoa09jugSQG9hGpA384u7i56tWhH3o3AAnJEu7oknPKiSWxn[“61CjGbapEVoyCC51x5tPZGZHCYsgtPSSssCatHEEUWeG”]4XaLErom3SxqyZMNccdUqeyaA6b3UEJkDg1bAg3E5a8mD1rDemo5SoCX86C3M2gFRtmNJDt4zzuQKepBCdqbeZ5FJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB2
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DAMM_v1_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DAMM_v2_EvtSwap_event

Swap execution events from Meteora’s DAMM v2 (Dynamic Automated Market Maker) protocol on Solana, capturing trade details including input/output amounts, price impacts, and fee breakdowns. Used for analyzing liquidity pool trading activity and fee distribution across LP, protocol, partner, and referral recipients.
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.
actual_amount_inBIGNUMERICActual amount of tokens deposited into the pool by the user for this swap transaction. Denominated in the input token’s smallest unit (lamports for SOL, base units for SPL tokens).
current_timestampBIGNUMERICUnix timestamp representing the on-chain time when the swap event occurred, recorded in seconds since epoch. Extracted from Solana blockchain state at transaction execution.
has_referralBOOLIndicates whether the swap transaction included a referral partner in the fee distribution. Always false in these samples, suggesting referral fees are optional or inactive for this pool.
params_amount_inBIGNUMERICSpecified input amount for the swap transaction in token’s smallest unit (lamports for SOL). This parameter sets the maximum tokens the user is willing to spend, with actual_amount_in showing what was ultimately consumed.
params_minimum_amount_outBIGNUMERICMinimum acceptable token output amount specified by the user to protect against excessive slippage. Set to zero in all sample transactions, indicating no minimum output constraint was enforced.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
swap_result_lp_feeBIGNUMERICFee paid to liquidity providers for executing the swap, denominated in the smallest token unit. Typically ranges from thousands to millions of base units depending on swap size and pool fee structure.
swap_result_next_sqrt_priceBIGNUMERICPool’s square root price after the swap execution, represented as a fixed-point integer. Used for calculating token exchange rates and determining price impact in the Meteora DAMM (Dynamic Automated Market Maker) pool.
swap_result_output_amountBIGNUMERICToken amount received by the trader after executing the swap. Denominated in the output token’s native units (often lamports for Solana tokens).
swap_result_partner_feeBIGNUMERICFee paid to partner protocols as part of the swap execution, denominated in the base token units. Always zero in these samples, indicating either no partner fee structure is active or fees are waived.
swap_result_protocol_feeBIGNUMERICProtocol fee charged by Meteora on the swap transaction, denominated in the output token. Typically represents a small percentage of the trade value allocated to the protocol treasury.
swap_result_referral_feeBIGNUMERICFee amount paid to the referral address for facilitating this swap, denominated in the token’s smallest unit. Typically zero unless a referral program participant directed the trade.
trade_directionINT64Direction of the token swap within the pool, where 0 indicates one direction and 1 indicates the opposite. Determines which token in the pair is being sold versus bought.
poolblock_slothas_referralsurrogate_keytransaction_idblock_timestamptrade_directionactual_amount_ininstruction_typeparams_amount_incurrent_timestampexecuting_accountinstruction_indextransaction_indexswap_result_lp_feetransaction_signerouter_executing_accountouter_instruction_indexswap_result_partner_feeswap_result_protocol_feeswap_result_referral_feeparams_minimum_amount_outswap_result_output_amountswap_result_next_sqrt_price
GqkqZewQsvpN7pkNbCRDhqb49AemgjqS14kR94aB8to347892156false347892156-5T9PPKXYKTYFqkaviKcc3bLfGRyX4a5J3wD7RZk6hLmXDdTQroLG9oZxFrxRvVUFvrSTMd1xP2GuwsQv7GSry6d4-0-75T9PPKXYKTYFqkaviKcc3bLfGRyX4a5J3wD7RZk6hLmXDdTQroLG9oZxFrxRvVUFvrSTMd1xP2GuwsQv7GSry6d42025-06-19T20:50:57.000Z03380733EvtSwap33807331750366257cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG727722885asKWJfxCYEGyC8Yocyi9KGVQyhi8rmTbzP72pgajUnF2M86GVGn3AHgAX9afQrYeSEETJBs9qmDtxb3f6kEa87H00571002829915363935622875747554
4MSn6EafnvgBkh22KbUp8Wqd9ALMUjGRxZgbFi3xV1qD347888720false347888720-4eFBjfNWN2Hcnva174r1zuJJM5TzMiF2UGEYZwBZYMowyeYpuiMAw8k3gU1TJDMPjeAz48ZBRCkXjjZ3yXgrcWRR-0-34eFBjfNWN2Hcnva174r1zuJJM5TzMiF2UGEYZwBZYMowyeYpuiMAw8k3gU1TJDMPjeAz48ZBRCkXjjZ3yXgrcWRR2025-06-19T20:28:03.000Z1898255128EvtSwap8982551281750364883cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG39072811105asKWJfxCYEGyC8Yocyi9KGVQyhi8rmTbzP72pgajUnF2M86GVGn3AHgAX9afQrYeSEETJBs9qmDtxb3f6kEa87H0018202770014909192808609945116499916344748
4hk34QGGVnf9JMhChC7LiLLeRo8pqse1T6YEFgEhmt74347885759false347885759-2aeRG6D5946DYV3q8J2vx4x7MXJXfFFsNk1hHYJkTj63KivKQiDhyHEEBKQBmM4SMzCzCMhA47hPWcTmvK2TXPJX-0-32aeRG6D5946DYV3q8J2vx4x7MXJXfFFsNk1hHYJkTj63KivKQiDhyHEEBKQBmM4SMzCzCMhA47hPWcTmvK2TXPJX2025-06-19T20:08:11.000Z12117811EvtSwap21178111750363691cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG31891031625asKWJfxCYEGyC8Yocyi9KGVQyhi8rmTbzP72pgajUnF2M86GVGn3AHgAX9afQrYeSEETJBs9qmDtxb3f6kEa87H002579000971132500837565769210941469
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DAMM_v2_EvtSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DAMM_v2_Swap_instruction

Swap instruction records from Meteora’s Dynamic Automated Market Maker (DAMM) v2 protocol on Solana. Captures token swap executions with input/output amounts, slippage protection, vault addresses, and referral data for analyzing DEX trading 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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
pool_authoritySTRINGSolana account address that has authority to execute operations on behalf of the pool. Typically a Program Derived Address (PDA) derived from the pool’s public key and program ID.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
referral_token_accountSTRINGToken account designated to receive referral fees or rewards for facilitating the swap transaction. May default to the program address when no referral partner is involved.
token_a_mintSTRINGToken mint address for the first token in the liquidity pool. Base58-encoded Solana address representing the SPL token’s mint authority.
token_a_programSTRINGToken program address governing token A in the pool. Typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA (SPL Token) or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb (Token-2022).
token_a_vaultSTRINGToken account holding the pool’s reserves of the first token in the trading pair. Base-58 encoded Solana address of the vault controlled by the pool authority.
token_b_mintSTRINGToken mint address for the second asset in the DAMM v2 liquidity pool being swapped. Base58-encoded Solana public key, commonly SOL’s native mint address (So11111111111111111111111111111111111111112) when paired with other tokens.
token_b_programSTRINGToken program address governing the second token (token B) in the swap pair. Typically TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL tokens or TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb for Token-2022 standard.
token_b_vaultSTRINGToken account address holding the liquidity pool’s reserves of the second token in the trading pair. This vault is controlled by the pool_authority and used during swap settlement.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
minimum_amount_outBIGNUMERICMinimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
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.
poolpayerprogramamount_inblock_slottoken_a_minttoken_b_mintsurrogate_keytoken_a_vaulttoken_b_vaultpool_authoritytransaction_idblock_timestampevent_authoritytoken_a_programtoken_b_programinstruction_typeexecuting_accountinstruction_indextransaction_indexminimum_amount_outremaining_accountstransaction_signerinput_token_accountoutput_token_accountreferral_token_accountouter_executing_accountouter_instruction_index
1hWKHfkYQ1QTo5GiCXq1EmgAQtbKwFc6DKDN6RPvfDJBkNp2aHh1BZUdFcEz5m8qoYBFbvCh47oGjkCgW87bMQPcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG200000000348256692HHUg1cgmMN3hmmZLjzzxoAQVY7tS1ngk4frPt1nt6DJTSo11111111111111111111111111111111111111112348256692-4nYVX1AMtLcFUcEoDdQFnSKc7xqXSGHJna1B2xrLGrwegvv3V3dPwqdk18NWbpNf3WEDGqy1cXQXmmbwL3kyJZ3G-57KMszmFpRgtqp3BJL5hs7qjxoi7FUHknAN1f4HN1fm3sB38fbvHP9S7muzoyNwq3MBawv7bVdfMh2oRbp3Y5TtU5HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC4nYVX1AMtLcFUcEoDdQFnSKc7xqXSGHJna1B2xrLGrwegvv3V3dPwqdk18NWbpNf3WEDGqy1cXQXmmbwL3kyJZ3G2025-06-21T13:34:06.000Z3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfetTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG53925932392655823785[“HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC”,“1hWKHfkYQ1QTo5GiCXq1EmgAQtbKwFc6DKDN6RPvfDJ”,“7ZSjkbaJuwannzXDpu5EqzwPqur8UN4tqQ2bXgdDxkzF”,“68fkvWnuKNzKSbsGMyq2yShut8mVnjK1QZVyWfKqRbFt”,“7KMszmFpRgtqp3BJL5hs7qjxoi7FUHknAN1f4HN1fm3s”,“B38fbvHP9S7muzoyNwq3MBawv7bVdfMh2oRbp3Y5TtU5”,“HHUg1cgmMN3hmmZLjzzxoAQVY7tS1ngk4frPt1nt6DJT”,“So11111111111111111111111111111111111111112”,“BkNp2aHh1BZUdFcEz5m8qoYBFbvCh47oGjkCgW87bMQP”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”,“3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfet”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”]BkNp2aHh1BZUdFcEz5m8qoYBFbvCh47oGjkCgW87bMQP7ZSjkbaJuwannzXDpu5EqzwPqur8UN4tqQ2bXgdDxkzF68fkvWnuKNzKSbsGMyq2yShut8mVnjK1QZVyWfKqRbFtcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG
1hWKHfkYQ1QTo5GiCXq1EmgAQtbKwFc6DKDN6RPvfDJnvuYp2xYJBUmqGX5gZMrEhBNsqJHPaLv5ZZUTypggDdcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG7414938540707875348256675HHUg1cgmMN3hmmZLjzzxoAQVY7tS1ngk4frPt1nt6DJTSo11111111111111111111111111111111111111112348256675-2mLCp165cGNjvAS7WXoSiakFpVdKD4TpBzDbWWo1bGLApLzTyKvhPQVFgSQGPqhp2LnqdkDrpWcKsPRbi32DPJSe-37KMszmFpRgtqp3BJL5hs7qjxoi7FUHknAN1f4HN1fm3sB38fbvHP9S7muzoyNwq3MBawv7bVdfMh2oRbp3Y5TtU5HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC2mLCp165cGNjvAS7WXoSiakFpVdKD4TpBzDbWWo1bGLApLzTyKvhPQVFgSQGPqhp2LnqdkDrpWcKsPRbi32DPJSe2025-06-21T13:34:00.000Z3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfetTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG358156804210[“HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC”,“1hWKHfkYQ1QTo5GiCXq1EmgAQtbKwFc6DKDN6RPvfDJ”,“82wpgxhcngL6g5WDW6bamnwerqUM72uNG8Z6MLspJPWj”,“ENs8WqUPmAZyZihXEDTGwFJ1CrjbbpnK2NkJfvpbSPfq”,“7KMszmFpRgtqp3BJL5hs7qjxoi7FUHknAN1f4HN1fm3s”,“B38fbvHP9S7muzoyNwq3MBawv7bVdfMh2oRbp3Y5TtU5”,“HHUg1cgmMN3hmmZLjzzxoAQVY7tS1ngk4frPt1nt6DJT”,“So11111111111111111111111111111111111111112”,“nvuYp2xYJBUmqGX5gZMrEhBNsqJHPaLv5ZZUTypggDd”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”,“3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfet”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”]nvuYp2xYJBUmqGX5gZMrEhBNsqJHPaLv5ZZUTypggDd82wpgxhcngL6g5WDW6bamnwerqUM72uNG8Z6MLspJPWjENs8WqUPmAZyZihXEDTGwFJ1CrjbbpnK2NkJfvpbSPfqcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG
1hWKHfkYQ1QTo5GiCXq1EmgAQtbKwFc6DKDN6RPvfDJnvuYp2xYJBUmqGX5gZMrEhBNsqJHPaLv5ZZUTypggDdcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG200000000348256663HHUg1cgmMN3hmmZLjzzxoAQVY7tS1ngk4frPt1nt6DJTSo11111111111111111111111111111111111111112348256663-2EcPxaYi9juAC3qr39KGEiecpAEBNVk98v2r9PAjh1wVa1s97SxAXAkBGuAFWSdvHrDDktZqwjCTZFWnhpQj5a5a-57KMszmFpRgtqp3BJL5hs7qjxoi7FUHknAN1f4HN1fm3sB38fbvHP9S7muzoyNwq3MBawv7bVdfMh2oRbp3Y5TtU5HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC2EcPxaYi9juAC3qr39KGEiecpAEBNVk98v2r9PAjh1wVa1s97SxAXAkBGuAFWSdvHrDDktZqwjCTZFWnhpQj5a5a2025-06-21T13:33:54.000Z3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfetTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG51035932392655823789[“HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC”,“1hWKHfkYQ1QTo5GiCXq1EmgAQtbKwFc6DKDN6RPvfDJ”,“ENs8WqUPmAZyZihXEDTGwFJ1CrjbbpnK2NkJfvpbSPfq”,“82wpgxhcngL6g5WDW6bamnwerqUM72uNG8Z6MLspJPWj”,“7KMszmFpRgtqp3BJL5hs7qjxoi7FUHknAN1f4HN1fm3s”,“B38fbvHP9S7muzoyNwq3MBawv7bVdfMh2oRbp3Y5TtU5”,“HHUg1cgmMN3hmmZLjzzxoAQVY7tS1ngk4frPt1nt6DJT”,“So11111111111111111111111111111111111111112”,“nvuYp2xYJBUmqGX5gZMrEhBNsqJHPaLv5ZZUTypggDd”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”,“3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfet”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”]nvuYp2xYJBUmqGX5gZMrEhBNsqJHPaLv5ZZUTypggDdENs8WqUPmAZyZihXEDTGwFJ1CrjbbpnK2NkJfvpbSPfq82wpgxhcngL6g5WDW6bamnwerqUM72uNG8Z6MLspJPWjcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DAMM_v2_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DAMMV1_Swap_instruction

Swap instruction records from Meteora’s Dynamic AMM (DAMM) V1 pools on Solana, capturing token exchanges with vault routing, LP mint references, and slippage parameters. Used for analyzing liquidity pool trade flow, fee distribution, and routing patterns through Jupiter aggregator integrations.
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.
a_token_vaultSTRINGSolana account holding the actual tokens for vault A in the liquidity pool. This is the token account that stores the physical tokens, distinct from the vault’s LP (liquidity provider) tracking account.
a_vaultSTRINGAccount address of vault A in the Meteora DAMM V1 pool that holds the first token. This vault is one of two vaults managing liquidity for the pool’s token pair.
a_vault_lpSTRINGToken account address holding the LP (Liquidity Provider) tokens for vault A in the Meteora DLMM pool. Base58-encoded Solana address representing the account that tracks the LP token balance.
a_vault_lp_mintSTRINGMint address of the LP (liquidity provider) token for vault A in the Meteora DAMM pool. Base-58 encoded Solana program address representing the token minted to liquidity providers.
b_token_vaultSTRINGAccount holding the actual tokens for vault B in the liquidity pool. This is the Solana Program Derived Address (PDA) that stores the second token asset in the pair.
b_vaultSTRINGAccount address of the liquidity vault holding the B-side token in the Meteora DAMM pool. Corresponds to one of the two token reserves participating in the swap transaction.
b_vault_lpSTRINGLiquidity provider token account for the B vault in this Meteora DLMM pool. Represents the user’s share of liquidity provided to the B-side token vault.
b_vault_lp_mintSTRINGMint address for vault B’s LP token that represents user shares in that side of the liquidity pool. Base58-encoded Solana program address format.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
protocol_token_feeSTRINGAccount address that receives protocol fees collected from this swap transaction. Represents the Meteora protocol’s fee collection account for this specific token vault pair.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_destination_tokenSTRINGAccount address of the user’s token account receiving the output tokens from the swap. Base58-encoded Solana public key.
user_source_tokenSTRINGAccount address of the user’s token account providing the input tokens for the swap. Base58-encoded Solana public key.
vault_programSTRINGProgram address managing vault operations for the swap protocol. Base58-encoded Solana public key.
in_amountBIGNUMERICInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
minimum_out_amountBIGNUMERICMinimum acceptable output token amount for the swap, used as slippage protection. Set to zero when no slippage limit is enforced by the user.
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.
poolusera_vaultb_vaultin_amounta_vault_lpb_vault_lpblock_slota_token_vaultb_token_vaultsurrogate_keytoken_programvault_programtransaction_ida_vault_lp_mintb_vault_lp_mintblock_timestampinstruction_typeexecuting_accountinstruction_indextransaction_indexuser_source_tokenminimum_out_amountprotocol_token_feeremaining_accountstransaction_signeruser_destination_tokenouter_executing_accountouter_instruction_index
12osadF4MvLVmYge2nZc9ePt5HKaftdufX9KL9XkAMzWBoKirTPVhEup8qUt7QXJSjrTPePajWi3QQ61hcLXBXiw7f1Gnip27Ue4MF7Axh9145Gn7kdHc3vVGyS4R7sSdmmHENJzRyFukWW2HXEWbNoxmqHKjzej8evamqSE5vCPYnXy68682180318X172YASCKb19N5WqV7YCLFpshRNQkYCAVo1W2ZD2xbJ4jKrztcr3Esyfz3VR9s2EyFPJy1wFCASeLgrUMJdkWvF247492757FPxtHq57i5AVjzQBVVWrdM4yfL9d4qPLh3WDTsrLUooM7jvYMrqUensD85JYxBzNY1t3LsppYLMnzoGkzkjTLtsK247492757-56JurBCQunFwCakvZJNtj51i8zqTktcruDXEHDCyHVQuqq3dgXAEJPUSVLXJ2jmURS4bvJFymuyiK43Jxfz9YJap-7-4TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi56JurBCQunFwCakvZJNtj51i8zqTktcruDXEHDCyHVQuqq3dgXAEJPUSVLXJ2jmURS4bvJFymuyiK43Jxfz9YJapX5om1v9m9HN8X8R99CZiTraSUF9GTH1D3HidNYiovu59chHAdg22ZGPCgxh9qn34tLHLZxF78cNx6nkrhyK4fPD2024-02-11T12:14:45.000ZSwapEo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB42792QbWBgtm3tbvXTDLZMHUqahXVr27JZzrsawaj4TQvB907mr8t9ro1FZrFkXDLBS3UkGJzVse3noAcjzzoL6my2AC[]BoKirTPVhEup8qUt7QXJSjrTPePajWi3QQ61hcLXBXiw3m6A2ibh4ZucErNhKMzo1Gb9WCeWWkP9bVsfdxt3Rb1wJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV47
12osadF4MvLVmYge2nZc9ePt5HKaftdufX9KL9XkAMzW4xDsmeTWPNjgSVSS1VTfzFq3iHZhp77ffPkAmkZkdu717f1Gnip27Ue4MF7Axh9145Gn7kdHc3vVGyS4R7sSdmmHENJzRyFukWW2HXEWbNoxmqHKjzej8evamqSE5vCPYnXy6208339448X172YASCKb19N5WqV7YCLFpshRNQkYCAVo1W2ZD2xbJ4jKrztcr3Esyfz3VR9s2EyFPJy1wFCASeLgrUMJdkWvF247428634FPxtHq57i5AVjzQBVVWrdM4yfL9d4qPLh3WDTsrLUooM7jvYMrqUensD85JYxBzNY1t3LsppYLMnzoGkzkjTLtsK247428634-6g4yQJTd93p2MqJTSeWW7DHWGLRRvPj5aSoePdGhPrGdktf9bG3prT4ZAB47tkuJa1zZJzsu2ZHjfnZ6wiygv75-3-5TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi6g4yQJTd93p2MqJTSeWW7DHWGLRRvPj5aSoePdGhPrGdktf9bG3prT4ZAB47tkuJa1zZJzsu2ZHjfnZ6wiygv75X5om1v9m9HN8X8R99CZiTraSUF9GTH1D3HidNYiovu59chHAdg22ZGPCgxh9qn34tLHLZxF78cNx6nkrhyK4fPD2024-02-11T05:00:22.000ZSwapEo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB583AYVEjRneP1Y2bNajzajM1GM4eX79NBp2zADSgUtkTe2B0E4LT8D8DBNDeRwrnzJPHZuoAHAjofBGgmCFMxQoPnYKp[]DCAKuApAuZtVNYLk3KTAVW9GLWVvPbnb5CxxRRmVgcTr9YM5CbLtUqv7ct9UWnGNorNtmPGG7JRPSXf3N1677tHTJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV43
12osadF4MvLVmYge2nZc9ePt5HKaftdufX9KL9XkAMzWBQ72nSv9f3PRyRKCBnHLVrerrv37CYTHm5h3s9VSGQDV7f1Gnip27Ue4MF7Axh9145Gn7kdHc3vVGyS4R7sSdmmHENJzRyFukWW2HXEWbNoxmqHKjzej8evamqSE5vCPYnXy12108901208X172YASCKb19N5WqV7YCLFpshRNQkYCAVo1W2ZD2xbJ4jKrztcr3Esyfz3VR9s2EyFPJy1wFCASeLgrUMJdkWvF247453525FPxtHq57i5AVjzQBVVWrdM4yfL9d4qPLh3WDTsrLUooM7jvYMrqUensD85JYxBzNY1t3LsppYLMnzoGkzkjTLtsK247453525-2NCJYZL7e63sLUYWf2NLhw1si129jfwP4gvoTSaLE1SgYNAH6XCSvzUyuNMTPZQHoxPFSKbuB7QcGFJzfSFuPvXX-2-9TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA24Uqj9JCLxUeoC3hGfh5W3s9FM9uCHDS2SG3LYwBpyTi2NCJYZL7e63sLUYWf2NLhw1si129jfwP4gvoTSaLE1SgYNAH6XCSvzUyuNMTPZQHoxPFSKbuB7QcGFJzfSFuPvXXX5om1v9m9HN8X8R99CZiTraSUF9GTH1D3HidNYiovu59chHAdg22ZGPCgxh9qn34tLHLZxF78cNx6nkrhyK4fPD2024-02-11T07:47:32.000ZSwapEo7WjKq67rjJQSZxS6z3YkapzY3eMj6Xy8X5EQVn5UaB9121GQy3x2ZhFmbkqVHhdd4QwuSHeJTZoRrrZg5CPaerWEMJ0E4LT8D8DBNDeRwrnzJPHZuoAHAjofBGgmCFMxQoPnYKp[]2rbMgYvzAb3xDk6vXrzKkY3VwsmyDZsJTkvB3JJYsRzACN4VGagwqbbYTynA9P4V2hXv31bqDHekVUqeCUcyhKnbJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DAMMV1_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DAMMV2_Swap_instruction

Swap instruction events from Meteora DLMM (Dynamic Liquidity Market Maker) V2 pools on Solana. Contains token pair trades with input/output amounts, pool identifiers, and vault addresses for tracking decentralized exchange activity.
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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
pool_authoritySTRINGProgram-derived authority account that controls operations on the Meteora DAMMV2 liquidity pool. Derived deterministically from the pool address and program ID for secure pool management.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
referral_token_accountSTRINGToken account address receiving referral fees for facilitating the swap transaction. Often set to the program address when no referral partner is involved.
token_a_mintSTRINGMint address of the first token in the liquidity pool pair. Base-58 encoded Solana public key representing the SPL token contract.
token_a_programSTRINGSolana program address managing token A in the liquidity pool. Typically references the SPL Token or Token-2022 program depending on the token standard implementation.
token_a_vaultSTRINGSolana account address holding token A reserves for the liquidity pool. Base58-encoded string identifying the program-controlled vault that stores one side of the trading pair.
token_b_mintSTRINGMint address of the second token in the liquidity pool pair. Base58-encoded Solana public key, typically USDC (EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v) in these examples.
token_b_programSTRINGSolana program address managing the output token (token B) in the swap. Typically the standard SPL Token program or Token-2022 program.
token_b_vaultSTRINGToken account address holding the pool’s reserves of token B (the second token in the pair). This vault is controlled by the pool authority and stores the actual token balance.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
minimum_amount_outBIGNUMERICMinimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
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.
poolpayerprogramamount_inblock_slottoken_a_minttoken_b_mintsurrogate_keytoken_a_vaulttoken_b_vaultpool_authoritytransaction_idblock_timestampevent_authoritytoken_a_programtoken_b_programinstruction_typeexecuting_accountinstruction_indextransaction_indexminimum_amount_outremaining_accountstransaction_signerinput_token_accountoutput_token_accountreferral_token_accountouter_executing_accountouter_instruction_index
4Fo5VYSS2vsKoZ1Wpy18YSt2m8H6zv25FrwFr2UWAksV8RfFmoQ9AThHp9LPNAdbmrReCtSst9z6RbrRLZCnUF75cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG3823360023369BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v336002336-7vxWjFWxQis2scfsSuzV3NumSbobWoo6FMrhETcXwfptfUwcRVTJJ8dQNkv42YG6LNL1W1yKrDZeDhHqLbZ4Qnf-4-05mQEQQ8xwwKCfbQWYwJjjDJbtizARZ18nXUXq4QE6PUA2AUKLXTya7iDBZqUK2ggLd8y16uDbxrokhdKBUrekHBmHLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC7vxWjFWxQis2scfsSuzV3NumSbobWoo6FMrhETcXwfptfUwcRVTJJ8dQNkv42YG6LNL1W1yKrDZeDhHqLbZ4Qnf2025-04-26T10:07:32.000Z3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfetTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG0150[“HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC”,“4Fo5VYSS2vsKoZ1Wpy18YSt2m8H6zv25FrwFr2UWAksV”,“DSmEkAZcKVALpVAvx8KPfpdy5fwGpKmLcKejtDoFEHWF”,“9rpKwSdW3FggAS4azDxKCpNS5yFxNGtVHEfdWFzM6pjC”,“5mQEQQ8xwwKCfbQWYwJjjDJbtizARZ18nXUXq4QE6PUA”,“2AUKLXTya7iDBZqUK2ggLd8y16uDbxrokhdKBUrekHBm”,“9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump”,“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“8RfFmoQ9AThHp9LPNAdbmrReCtSst9z6RbrRLZCnUF75”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”,“3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfet”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”]8RfFmoQ9AThHp9LPNAdbmrReCtSst9z6RbrRLZCnUF75DSmEkAZcKVALpVAvx8KPfpdy5fwGpKmLcKejtDoFEHWF9rpKwSdW3FggAS4azDxKCpNS5yFxNGtVHEfdWFzM6pjCcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGGJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV44
4Fo5VYSS2vsKoZ1Wpy18YSt2m8H6zv25FrwFr2UWAksV8RfFmoQ9AThHp9LPNAdbmrReCtSst9z6RbrRLZCnUF75cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG2113360425069BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v336042506-4P9qqKhMU4T6ZLqT1ezXqV5EWxv5VE4UHmSicwwmaafT4ctadWMomutFspZ8ay3PFtA7b3CyLtbMyt9MMscUZaBM-5-05mQEQQ8xwwKCfbQWYwJjjDJbtizARZ18nXUXq4QE6PUA2AUKLXTya7iDBZqUK2ggLd8y16uDbxrokhdKBUrekHBmHLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC4P9qqKhMU4T6ZLqT1ezXqV5EWxv5VE4UHmSicwwmaafT4ctadWMomutFspZ8ay3PFtA7b3CyLtbMyt9MMscUZaBM2025-04-26T14:31:31.000Z3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfetTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG01900[“HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC”,“4Fo5VYSS2vsKoZ1Wpy18YSt2m8H6zv25FrwFr2UWAksV”,“DSmEkAZcKVALpVAvx8KPfpdy5fwGpKmLcKejtDoFEHWF”,“9rpKwSdW3FggAS4azDxKCpNS5yFxNGtVHEfdWFzM6pjC”,“5mQEQQ8xwwKCfbQWYwJjjDJbtizARZ18nXUXq4QE6PUA”,“2AUKLXTya7iDBZqUK2ggLd8y16uDbxrokhdKBUrekHBm”,“9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump”,“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“8RfFmoQ9AThHp9LPNAdbmrReCtSst9z6RbrRLZCnUF75”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”,“3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfet”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”]8RfFmoQ9AThHp9LPNAdbmrReCtSst9z6RbrRLZCnUF75DSmEkAZcKVALpVAvx8KPfpdy5fwGpKmLcKejtDoFEHWF9rpKwSdW3FggAS4azDxKCpNS5yFxNGtVHEfdWFzM6pjCcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGGJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV45
HUgtEWBhDMqbqscaaMq1aVpiqM8H2tfxqwtogiqoG9kqJ8sEimQ3Fa7jf9mki3cKiZPHQGGbTCQUxtYHsG2xqaX7cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG90733359631674TBi66vi32S7J8X1A6eWfaLHYmUXu7CStcEmsJQdpumpEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v335963167-4gtJfVw7tBbHoLr29rkpS1gEzz5QtvxxiJ5CWrczg38QzggMg6iVaH5P9F79wPSWWSRk8ZBssuKSHGCpyFcpyA4B-6-104bXw5VLDs3bJh5KhChG4VFLx1cRy3kRyyx2ZqHnv5bnL2YyzFm7wkNzKt6Y6bcNTukkUD37jkjYVbwDKvGJQdh7nHLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC4gtJfVw7tBbHoLr29rkpS1gEzz5QtvxxiJ5CWrczg38QzggMg6iVaH5P9F79wPSWWSRk8ZBssuKSHGCpyFcpyA4B2025-04-26T05:49:27.000Z3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfetTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapcpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG10100[“HLnpSz9h2S4hiLQ43rnSD9XkcUThA7B8hQMKmDaiTLcC”,“HUgtEWBhDMqbqscaaMq1aVpiqM8H2tfxqwtogiqoG9kq”,“5eaPc9kvYb8XJnhuRgjXNYPjyR4bxyLy4m28JENFxRqT”,“GMoHWGUibYdcVhh6mEaRFvJj64swPb7Zz3A8wpzY29rc”,“4bXw5VLDs3bJh5KhChG4VFLx1cRy3kRyyx2ZqHnv5bnL”,“2YyzFm7wkNzKt6Y6bcNTukkUD37jkjYVbwDKvGJQdh7n”,“4TBi66vi32S7J8X1A6eWfaLHYmUXu7CStcEmsJQdpump”,“EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v”,“J8sEimQ3Fa7jf9mki3cKiZPHQGGbTCQUxtYHsG2xqaX7”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”,“3rmHSu74h1ZcmAisVcWerTCiRDQbUrBKmcwptYGjHfet”,“cpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGG”]J8sEimQ3Fa7jf9mki3cKiZPHQGGbTCQUxtYHsG2xqaX75eaPc9kvYb8XJnhuRgjXNYPjyR4bxyLy4m28JENFxRqTGMoHWGUibYdcVhh6mEaRFvJj64swPb7Zz3A8wpzY29rccpamdpZCGKUy5JxQXB4dcpGPiikHawvSWAd6mEn1sGGJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV46
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DAMMV2_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DBC_EvtSwap_event

Swap event records from Meteora DLMM (Dynamic Liquidity Market Maker) pools on Solana, capturing trade executions with input/output amounts, fees, price impacts, and routing context through Jupiter aggregator.
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.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
configSTRINGConfiguration account address for the Meteora liquidity pool defining fee tiers and operational parameters. Base58-encoded Solana address typically shared across multiple pools with similar settings.
current_timestampBIGNUMERICUnix timestamp indicating when the swap event occurred on-chain. Represented in seconds since epoch, matching the block_timestamp field.
has_referralBOOLIndicates whether a referral fee was applicable to this swap transaction. When true, the swap_result_referral_fee field will contain a non-zero value.
params_amount_inBIGNUMERICInput amount specified in the swap instruction parameters before execution. May differ from swap_result_actual_input_amount due to slippage or partial fills during execution.
params_minimum_amount_outBIGNUMERICMinimum output token amount required for swap execution as specified in transaction parameters. Non-zero values act as slippage protection, with the transaction failing if actual output falls below this threshold.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
swap_result_actual_input_amountBIGNUMERICThe actual quantity of input tokens consumed in the swap execution, denominated in the token’s smallest unit (lamports for SOL). May differ from params_amount_in due to slippage, price impact, or partial fills during concentrated liquidity swaps.
swap_result_next_sqrt_priceBIGNUMERICOutput amount required from the swap based on the user’s specified slippage tolerance. Set to 0 when no minimum threshold is enforced.
swap_result_output_amountBIGNUMERICToken amount received by the swapper after executing the trade on Meteora’s DLMM pool. Denominated in the output token’s smallest unit (lamports for SOL, base units for SPL tokens).
swap_result_protocol_feeBIGNUMERICPortion of the swap transaction allocated to the protocol as a fee, denominated in the input or output token’s smallest unit. Typically represents 20-25% of the total trading fee charged on the swap.
swap_result_referral_feeBIGNUMERICFee amount paid to referrers who facilitated the swap transaction on Meteora. Returns zero when no referrer was involved, as indicated by the has_referral flag.
swap_result_trading_feeBIGNUMERICPortion of the swap output allocated to the liquidity pool as a trading fee, denominated in the output token. Typically represents 0.2-0.5% of the swap amount based on pool configuration.
trade_directionINT64Direction of the swap indicating which token in the pair is being sold (0 or 1). Corresponds to the token order in the Meteora DLMM (Dynamic Liquidity Market Maker) pool configuration.
poolconfigamount_inblock_slothas_referralsurrogate_keytransaction_idblock_timestamptrade_directioninstruction_typeparams_amount_incurrent_timestampexecuting_accountinstruction_indextransaction_indextransaction_signerouter_executing_accountouter_instruction_indexswap_result_trading_feeswap_result_protocol_feeswap_result_referral_feeparams_minimum_amount_outswap_result_output_amountswap_result_next_sqrt_priceswap_result_actual_input_amount
26EoDh7gA1REWphRLUVc5axc4yFFTzea8PGgMdvYDHyA4uFraBJMdQVPmJJn3LXX3LT4wLSwncnZ9RfseHq61fAs208911266878886347951732false347951732-2fS9CfutjmRQP6fzYyduk8AZAMvqaPekprhTQjFDQt6uAgedMYG7Q3A2w4M9BT9xfS4D7gvmw1X2uaaQKyEUgMUo-0-32fS9CfutjmRQP6fzYyduk8AZAMvqaPekprhTQjFDQt6uAgedMYG7Q3A2w4M9BT9xfS4D7gvmw1X2uaaQKyEUgMUo2025-06-20T03:30:07.000Z0EvtSwap2089112668788861750390207dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN32273vNpqjmMYK9yZb9dtc5Xhd7QxpDukYEZP5tmGmeVq9bSJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4061475315368800374740407891882262973352208911266878886
CdHYUyYCTfEG8ojPPiRqrKGDKw5cUFXDasTXGYENjk6iAjre7gv97ERXMg8Ex57iEPrLXsJbttTuWUWdQz1zCQEi14000000347962637false347962637-Xke7hbvyFw4x5AY6Yvk6Rh2vYd13LFc6zEeUErSXzeHERGcyDAgHr6zpJ4vR7d1ATMWXGrXZcxpkDHWC6ERUitP-0-3Xke7hbvyFw4x5AY6Yvk6Rh2vYd13LFc6zEeUErSXzeHERGcyDAgHr6zpJ4vR7d1ATMWXGrXZcxpkDHWC6ERUitP2025-06-20T04:42:53.000Z0EvtSwap140000001750394573dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN386HW2Cg9ZYRGZRzXfdgc1pgGxdYduyVvYrYkg1H2PVLo1HJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV40329638240002018606707526306236917621114000000
CuZZHy2iWjpmVc8bQii8yD49Tx6dxn2MhFn5CYKGkFNrAjre7gv97ERXMg8Ex57iEPrLXsJbttTuWUWdQz1zCQEi25000000347965527false347965527-5mfnUTZVivNXTRG71SJU479xyQV35mk5dzxwqZD11oFeWgMStcWccYdZbwEaFgUumBKQNcDYVbP2m4yVtBMABTSK-0-35mfnUTZVivNXTRG71SJU479xyQV35mk5dzxwqZD11oFeWgMStcWccYdZbwEaFgUumBKQNcDYVbP2m4yVtBMABTSK2025-06-20T05:02:17.000Z1EvtSwap250000001750395737dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN3286HW2Cg9ZYRGZRzXfdgc1pgGxdYduyVvYrYkg1H2PVLo1HJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4040023310005800213827801624923106888152600224499709
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DBC_EvtSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DBC_Swap_instruction

Swap instruction records from Meteora v1 DBC (Dynamic Bin Curve) pools on Solana. Captures token swap executions with input amounts, minimum output thresholds, pool addresses, and token vault details for analyzing DEX trading activity and liquidity provider performance.
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.
base_mintSTRINGMint address of the base token in the Meteora DBC swap pool. Solana token mint addresses are base58-encoded 32-byte identifiers.
base_vaultSTRINGAccount address holding the base token reserves for the liquidity pool. Base58-encoded Solana public key.
configSTRINGConfiguration account address for the Meteora Dynamic AMM pool parameters. Contains pool-specific settings like fees and trading constraints.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
input_token_accountSTRINGAccount address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key.
output_token_accountSTRINGAccount address receiving the tokens from the swap transaction. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
pool_authoritySTRINGProgram-derived authority address for the Meteora liquidity pool on Solana. Controls vault operations and swap execution permissions for this pool.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
quote_mintSTRINGToken mint address of the quote asset in the liquidity pool trading pair. Typically represents the secondary token (e.g., SOL, USDC) against which the base token is priced.
quote_vaultSTRINGAccount address holding the quote token reserves for the liquidity pool. Base58-encoded Solana public key.
referral_token_accountSTRINGToken account receiving referral fees from the swap, if any. Defaults to the program address when no referral is specified.
token_base_programSTRINGToken program address governing the base asset in this liquidity pool. Typically the SPL Token Program for standard Solana tokens.
token_quote_programSTRINGToken program address that manages the quote token in this swap. Typically the SPL Token program on Solana (TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA).
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
minimum_amount_outBIGNUMERICMinimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
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.
poolpayerconfigprogramamount_inbase_mintbase_vaultblock_slotquote_mintquote_vaultsurrogate_keypool_authoritytransaction_idblock_timestampevent_authorityinstruction_typeexecuting_accountinstruction_indextransaction_indexminimum_amount_outremaining_accountstoken_base_programtransaction_signerinput_token_accounttoken_quote_programoutput_token_accountreferral_token_accountouter_executing_accountouter_instruction_index
EGYPbk2S7c85mp8jMsS5KhbEWy4LSiLfcB1p1bTuigLqAiLwAtCzPnQh6GnJ1UiMi9vqNniV3QyTM4rueKYNjPwN3UxVehmNEwetzHNkFXjSiFbEEanqYkhFqrd7sF9XJ841dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN7996179555248232913gyac7xvxtKbMiHavZKHgBP62HqvoJ3jTSuDwzbCULT34SnemkvuMLX8pTyqA3YRYmzAYnF4JGtss2pBxSZyu9Q345072221So111111111111111111111111111111111111111125ak4oHef94JAk3TJEy69ZwoV9YeP4h7tRCjzmoJqKFpQ345072221-62AEjBdo2tBHWhzZn12zkrcQbK5eNmiwGD5xayXo5mDxRwcfLN2mykKzFnaW7KmiZVxeJkcfy1ojhRfWSdiQDTkp-3-0FhVo3mqL8PW5pH5U2CN4XE33DokiyZnUwuGpH2hmHLuM62AEjBdo2tBHWhzZn12zkrcQbK5eNmiwGD5xayXo5mDxRwcfLN2mykKzFnaW7KmiZVxeJkcfy1ojhRfWSdiQDTkp2025-06-06T20:16:42.000Z8Ks12pbrD6PXxfty1hVQiE9sc289zgU1zHkvXhrSdriFSwapdbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN01340[“FhVo3mqL8PW5pH5U2CN4XE33DokiyZnUwuGpH2hmHLuM”,“3UxVehmNEwetzHNkFXjSiFbEEanqYkhFqrd7sF9XJ841”,“EGYPbk2S7c85mp8jMsS5KhbEWy4LSiLfcB1p1bTuigLq”,“A9jGNXk9qtY7W51Mb7gzHBHDFL5UDxjHhKZFZhm86DkZ”,“6NmU5tPouzysXEDzdtuDSgDDhkK6b6jk6x1J6ZbEi4Ce”,“34SnemkvuMLX8pTyqA3YRYmzAYnF4JGtss2pBxSZyu9Q”,“5ak4oHef94JAk3TJEy69ZwoV9YeP4h7tRCjzmoJqKFpQ”,“13gyac7xvxtKbMiHavZKHgBP62HqvoJ3jTSuDwzbCULT”,“So11111111111111111111111111111111111111112”,“AiLwAtCzPnQh6GnJ1UiMi9vqNniV3QyTM4rueKYNjPwN”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN”,“8Ks12pbrD6PXxfty1hVQiE9sc289zgU1zHkvXhrSdriF”,“dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN”]TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAAiLwAtCzPnQh6GnJ1UiMi9vqNniV3QyTM4rueKYNjPwNA9jGNXk9qtY7W51Mb7gzHBHDFL5UDxjHhKZFZhm86DkZTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA6NmU5tPouzysXEDzdtuDSgDDhkK6b6jk6x1J6ZbEi4Cedbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqNminTcHYRLVPubRK8nt6sqe2ZpWrGDLQoNLipDJCGocY3
J5SeWAhTjAFtREjV8KAhgXSTjDQ43RpTnbCLdY7vvPe65HJSSe6vRXxgG8uJiFJSYEhNmHiXwQanCWzSY3twnPj3CKupGn17nQ3Qjv35UKuGa9cHqDrnGxGEQsjT9xH5RRZKdbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN821679460459146214ows3ugRPZVmq2twKAsPd2R1akFFD7rUyXiBHXqH1WDF7E9G6szwSdfcQSo8n6R8v6r6Wezb5Tc3cdUzqDn1tXm345021768So11111111111111111111111111111111111111112FRPtmY4RJs6wmnbYRiqTT5gZDiRC2vR85z48zE2RisjD345021768-4u9kGfxQJKtfpxXmNBH72fDWeCZBh2aAZHCJ454DRviSEtuF8NCG3FtdyeZ7WUi8Q2ybp3ggS8DktRGeP9wi1JQX-4-0FhVo3mqL8PW5pH5U2CN4XE33DokiyZnUwuGpH2hmHLuM4u9kGfxQJKtfpxXmNBH72fDWeCZBh2aAZHCJ454DRviSEtuF8NCG3FtdyeZ7WUi8Q2ybp3ggS8DktRGeP9wi1JQX2025-06-06T14:45:58.000Z8Ks12pbrD6PXxfty1hVQiE9sc289zgU1zHkvXhrSdriFSwapdbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN0751[“FhVo3mqL8PW5pH5U2CN4XE33DokiyZnUwuGpH2hmHLuM”,“CKupGn17nQ3Qjv35UKuGa9cHqDrnGxGEQsjT9xH5RRZK”,“J5SeWAhTjAFtREjV8KAhgXSTjDQ43RpTnbCLdY7vvPe6”,“5PJUNcHHFNNQ2FrePXBuoH8Ro6KgcLEDcaKmhmnbrf2e”,“5cXCAK36WasDtqfyChGWMKAMkHqYnJ9LnYKWxdZjn12N”,“F7E9G6szwSdfcQSo8n6R8v6r6Wezb5Tc3cdUzqDn1tXm”,“FRPtmY4RJs6wmnbYRiqTT5gZDiRC2vR85z48zE2RisjD”,“14ows3ugRPZVmq2twKAsPd2R1akFFD7rUyXiBHXqH1WD”,“So11111111111111111111111111111111111111112”,“5HJSSe6vRXxgG8uJiFJSYEhNmHiXwQanCWzSY3twnPj3”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN”,“8Ks12pbrD6PXxfty1hVQiE9sc289zgU1zHkvXhrSdriF”,“dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN”]TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5HJSSe6vRXxgG8uJiFJSYEhNmHiXwQanCWzSY3twnPj35PJUNcHHFNNQ2FrePXBuoH8Ro6KgcLEDcaKmhmnbrf2eTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5cXCAK36WasDtqfyChGWMKAMkHqYnJ9LnYKWxdZjn12Ndbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma4
8e5y4LP2CmNeo99egJ8suRnxqmfRVBLZLS2wrXH2h8yK8LSfQmgKRmoKoneW66T4BNWGVC9FywXCuxhfGWiefd8mCKupGn17nQ3Qjv35UKuGa9cHqDrnGxGEQsjT9xH5RRZKdbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN43822967734670026D7zPLuikGiZVFi4VLYAx7rfqjGG9gv63V2HpcTSY113b6FyUmeSWF4vZ2q885fDDGvWL3XRTYG8fVWB6Eq7np4344895351So1111111111111111111111111111111111111111233VWkpAJPzvU2feU6AZmgFkLLFg8y4skmXrufEiZP4bc344895351-2UFkiaQCsR4wscNhqjVmFXUhzJmy3w5SY4oY1ZydRZTZgoYjSY8rKzhjAiuFkdecEZetW2nUqVEipN4Z97VdBvfo-2-0FhVo3mqL8PW5pH5U2CN4XE33DokiyZnUwuGpH2hmHLuM2UFkiaQCsR4wscNhqjVmFXUhzJmy3w5SY4oY1ZydRZTZgoYjSY8rKzhjAiuFkdecEZetW2nUqVEipN4Z97VdBvfo2025-06-06T00:59:26.000Z8Ks12pbrD6PXxfty1hVQiE9sc289zgU1zHkvXhrSdriFSwapdbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN01890[“FhVo3mqL8PW5pH5U2CN4XE33DokiyZnUwuGpH2hmHLuM”,“CKupGn17nQ3Qjv35UKuGa9cHqDrnGxGEQsjT9xH5RRZK”,“8e5y4LP2CmNeo99egJ8suRnxqmfRVBLZLS2wrXH2h8yK”,“CHv5wsJCTbGAp1UsSGrLLN2iEC5dty4VkZbYkghsde7c”,“8Y7NWNuex3ML9HSG1ndKWqJJZp3ckzcydPRUpJzz7bay”,“3b6FyUmeSWF4vZ2q885fDDGvWL3XRTYG8fVWB6Eq7np4”,“33VWkpAJPzvU2feU6AZmgFkLLFg8y4skmXrufEiZP4bc”,“26D7zPLuikGiZVFi4VLYAx7rfqjGG9gv63V2HpcTSY11”,“So11111111111111111111111111111111111111112”,“8LSfQmgKRmoKoneW66T4BNWGVC9FywXCuxhfGWiefd8m”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN”,“8Ks12pbrD6PXxfty1hVQiE9sc289zgU1zHkvXhrSdriF”,“dbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqN”]TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA8LSfQmgKRmoKoneW66T4BNWGVC9FywXCuxhfGWiefd8mCHv5wsJCTbGAp1UsSGrLLN2iEC5dty4VkZbYkghsde7cTokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA8Y7NWNuex3ML9HSG1ndKWqJJZp3ckzcydPRUpJzz7baydbcij3LWUppWqq96dh6gJWwBifmcGfLSB5D4DuSMaqNJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV42
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DBC_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DLMM_Swap_instruction

Swap instruction records from Meteora’s Dynamic Liquidity Market Maker (DLMM) on Solana, capturing token exchanges with amounts, pricing oracle data, and liquidity pool identifiers. Used for analyzing DEX trading patterns, slippage tolerance (min_amount_out), and cross-program composition via outer instruction tracking.
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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
lb_pairSTRINGAccount address of the liquidity book pair or pool. Base58-encoded Solana public key.
oracleSTRINGAccount providing price feed data for the market or trading pair. Base58-encoded Solana public key.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
reserve_xSTRINGAccount address holding the pool’s reserve of token X. Base58-encoded Solana public key.
reserve_ySTRINGAccount address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
token_x_mintSTRINGMint address of token X in the liquidity pair. Base58-encoded Solana public key.
token_x_programSTRINGProgram address managing token X transfers and operations. Base58-encoded Solana public key.
token_y_mintSTRINGMint address of token Y in the liquidity pair. Base58-encoded Solana public key.
token_y_programSTRINGProgram address managing token Y transfers and operations. Base58-encoded Solana public key.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_token_inSTRINGAccount address holding the user’s input token before the swap. Base58-encoded Solana public key.
user_token_outSTRINGAccount address holding the user’s output token after the swap. Base58-encoded Solana public key.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
min_amount_outBIGNUMERICMinimum acceptable output token amount specified by the user for slippage protection on the swap. Set to 0 when the user accepts any output amount without slippage limits.
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.
useroraclelb_pairprogramamount_inreserve_xreserve_yblock_slottoken_x_minttoken_y_mintsurrogate_keyuser_token_inmin_amount_outtransaction_iduser_token_outblock_timestampevent_authoritytoken_x_programtoken_y_programinstruction_typeexecuting_accountinstruction_indextransaction_indexremaining_accountstransaction_signerouter_executing_accountouter_instruction_index
C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j9BSRgpcTHstpz7YaHmJYA8F4xhRhEua8jW9b4wm6wzt8xDx66z5YmWdZJQB8AT2iDutmuXVfPQnrsxRYw3LYVLQLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo442223223XEiVTvMTBm4YFeRddxmKL7i4vNJ86o9rxgsPQWpnVav3xYkxZCFBViL6us89TBh95cvwML7opEfj6iKQC9ARuVh3607897269BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v360789726-bDW5oNkabmdAgXUQKepvLBYDBxPJyfnJMjup6Bz1nomt5t5uY2YgQryj73zRp3U5dYWQwpZqppQuvbkWm3rRKTB-0-363QmzjpPgxiVBoBDFFuAPuSMLF1X7JvWijRW6qNo8Sxp0bDW5oNkabmdAgXUQKepvLBYDBxPJyfnJMjup6Bz1nomt5t5uY2YgQryj73zRp3U5dYWQwpZqppQuvbkWm3rRKTB2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF2025-08-18T02:50:48.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo3235[“1YbrSgCANbZooyAiVk6962XTyj4qkcqSgzgKBYSd3qp”,“1YbrSgCANbZooyAiVk6962XTyj4qkcqSgzgKBYSd3qp”,“1YbrSgCANbZooyAiVk6962XTyj4qkcqSgzgKBYSd3qp”]C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8jmmmmauu7rM92h8jHcMM69e8TsccCkwmnMRtrGSHocwj0
6sZGtMnbfZYrma9bKnTkLwjRYXBoTpzcP72cCAWPMhrk9BSRgpcTHstpz7YaHmJYA8F4xhRhEua8jW9b4wm6wzt8xDx66z5YmWdZJQB8AT2iDutmuXVfPQnrsxRYw3LYVLQLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo215346163XEiVTvMTBm4YFeRddxmKL7i4vNJ86o9rxgsPQWpnVav3xYkxZCFBViL6us89TBh95cvwML7opEfj6iKQC9ARuVh3607774189BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v360777418-26i36P6PopgMiVf5Yag2ZWawKU6odWm1mcjZUqamH2w9B596nntwqnpXTbPYFBNUsuwow8iLeaATnpkJtb8xjC5x-1-3GaJpB6nv9fCXHC7hqdpVGDojEGXMni7LMTnNyV2LanVA026i36P6PopgMiVf5Yag2ZWawKU6odWm1mcjZUqamH2w9B596nntwqnpXTbPYFBNUsuwow8iLeaATnpkJtb8xjC5x54kjESsz4EBAjVx6aWmZsPSxyfNkozYhcxfrJMvsCZ5B2025-08-18T01:30:09.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo3326[“1YbrSgCANbZooyAiVk6962XTyj4qkcqSgzgKBYSd3qp”]6sZGtMnbfZYrma9bKnTkLwjRYXBoTpzcP72cCAWPMhrkNA365bsPdvZ8sP58qJ5QFg7eXygCe8aPRRxR9oeMbR51
9MLh7BLSrSJsz8WEGHqCungRVG5N4Hrti8TuFBwWbS6J9BSRgpcTHstpz7YaHmJYA8F4xhRhEua8jW9b4wm6wzt8xDx66z5YmWdZJQB8AT2iDutmuXVfPQnrsxRYw3LYVLQLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo2263143XEiVTvMTBm4YFeRddxmKL7i4vNJ86o9rxgsPQWpnVav3xYkxZCFBViL6us89TBh95cvwML7opEfj6iKQC9ARuVh3608503329BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v360850332-5UGNtCTETCJDLWRsDeJcYivWvP795eWJGb5wAmyiuj1BTh6j78qQ1FyEhF9coMY2X9mryqurdMcvChym78XCg2tN-2-22Bj3uiSYg44LYGbypghUpTmD4jhBNiiG8ErxYcWA8oyZm05UGNtCTETCJDLWRsDeJcYivWvP795eWJGb5wAmyiuj1BTh6j78qQ1FyEhF9coMY2X9mryqurdMcvChym78XCg2tNAe7p8xgSZdBrAYTspdm4ZydJsjqsrgiWXZzNXuTB8smA2025-08-18T09:27:22.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo22513[“1YbrSgCANbZooyAiVk6962XTyj4qkcqSgzgKBYSd3qp”]9MLh7BLSrSJsz8WEGHqCungRVG5N4Hrti8TuFBwWbS6JDF1ow4tspfHX9JwWJsAb9epbkA8hmpSEAtxXy1V27QBH2
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DLMM_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DLMM_Swap2_instruction

Swap instruction records from Meteora’s DLMM (Dynamic Liquidity Market Maker) protocol on Solana, containing input/output amounts, token addresses, liquidity pool identifiers, and minimum output constraints for analyzing trading patterns and slippage tolerance.
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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
lb_pairSTRINGAccount address of the liquidity book pair or pool. 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.
oracleSTRINGAccount providing price feed data for the market or trading pair. Base58-encoded Solana public key.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
reserve_xSTRINGAccount address holding the pool’s reserve of token X. Base58-encoded Solana public key.
reserve_ySTRINGAccount address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
token_x_mintSTRINGMint address of token X in the liquidity pair. Base58-encoded Solana public key.
token_x_programSTRINGProgram address managing token X transfers and operations. Base58-encoded Solana public key.
token_y_mintSTRINGMint address of token Y in the liquidity pair. Base58-encoded Solana public key.
token_y_programSTRINGProgram address managing token Y transfers and operations. Base58-encoded Solana public key.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_token_inSTRINGAccount address holding the user’s input token before the swap. Base58-encoded Solana public key.
user_token_outSTRINGAccount address holding the user’s output token after the swap. Base58-encoded Solana public key.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
min_amount_outBIGNUMERICMinimum acceptable output token amount the user will receive from this swap. Set to 0 when user accepts any output amount, or 1 when slippage protection is enabled.
remaining_accounts_infoJSONAdditional metadata about accounts passed to the swap instruction beyond the standard required accounts. Typically contains slices array for complex routing scenarios, often empty for direct swaps.
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.
useroraclelb_pairprogramamount_inreserve_xreserve_yblock_slotmemo_programtoken_x_minttoken_y_mintsurrogate_keyuser_token_inmin_amount_outtransaction_iduser_token_outblock_timestampevent_authoritytoken_x_programtoken_y_programinstruction_typeexecuting_accountinstruction_indextransaction_indexremaining_accountstransaction_signerouter_executing_accountouter_instruction_indexremaining_accounts_info
Hssq2dpipwM5G6Q43o9ucVWSwP5Goi7qqK7hvbyXnebX2Bv3BsXcj57sjzZKGyJghRBPU2ekNMeu7SXqhskfq6oV7ULd7AH6KQxSV3jNKBa6MsUk8cxsLC1TdJVPUZ9Ko74oLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo288535721490DNMXsVdmMMsUvy4MupQmi6dJgCXxSRdi7VVf6YzWZKSY12GKpq7czz5CPugtYyj8JNLF1xsBLpkTnUY5rFX5reVk350877303MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrHxptKywiNbHobJD4XMMBn1czMUGkdMrUkeUErQLKbonkSo11111111111111111111111111111111111111112350877303-xrkHevcXzAGsU11m7dPsiRsAS1Sc9ZsC8Ye6x7qpHJ9Q7kB5U72njauBTVqVi3rH31tTCLVdBgXnbikbksyzeiW-3-0DfE9zXjXZrd8m3g9tECntYrbk675tk38bKE669JC2fUx1xrkHevcXzAGsU11m7dPsiRsAS1Sc9ZsC8Ye6x7qpHJ9Q7kB5U72njauBTVqVi3rH31tTCLVdBgXnbikbksyzeiWxiZdMFYeyU2LjAProrQWsaYkTDUxjL7Re6oRQ2c6sf82025-07-03T15:48:42.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwap2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo05[“HdoJ9QRd4VCgZquZwAidmE9ssjx4x2V1FtcVMi9Um8Tj”]Hssq2dpipwM5G6Q43o9ucVWSwP5Goi7qqK7hvbyXnebX6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma3{“slices”:[]}
bobCPc5nqVoX7r8gKzCMPLrKjFidjnSCrAdcYGCH2Ye2Bv3BsXcj57sjzZKGyJghRBPU2ekNMeu7SXqhskfq6oV7ULd7AH6KQxSV3jNKBa6MsUk8cxsLC1TdJVPUZ9Ko74oLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo94437146930DNMXsVdmMMsUvy4MupQmi6dJgCXxSRdi7VVf6YzWZKSY12GKpq7czz5CPugtYyj8JNLF1xsBLpkTnUY5rFX5reVk350931421MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrHxptKywiNbHobJD4XMMBn1czMUGkdMrUkeUErQLKbonkSo11111111111111111111111111111111111111112350931421-Gtr7wXH1EBT2rwxXUNcfGYRHfb6HNdejCohYE69hRLNFyFdFbEayC6VvgjMTVzYpVkTwxnoLosqt23r9jqKuuzA-2-3638n5KCNWvEUnt2Fz148Sw3o95tS9ZdjHTgDNJhSMDrm0Gtr7wXH1EBT2rwxXUNcfGYRHfb6HNdejCohYE69hRLNFyFdFbEayC6VvgjMTVzYpVkTwxnoLosqt23r9jqKuuzAGjPXKLE6FgbNhZkNBpMgEpPGMEmXhGNUqGJYVu3kXHH42025-07-03T21:44:05.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwap2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo377[“HdoJ9QRd4VCgZquZwAidmE9ssjx4x2V1FtcVMi9Um8Tj”]bobCPc5nqVoX7r8gKzCMPLrKjFidjnSCrAdcYGCH2YeEvo1veLzNhWcEXFc4xv9nwoDg4MBoyo2N2j6nWWHQF692{“slices”:[]}
GhaCjCi7NLZ3mnrxY6i3Cng835C3Q6u3Z8aiZEYEmJer9wPa1HZjH1F8Tvw7XZxb4fYU56EwiDzhQH6vdHDPKpJXHA1M9ckb1MFugy9ajFbaCxPULhHGcFYQDYdvYZegFMB9LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo25757396855HgThtKtRCTBUpn6srrfbsZuDdRfugcbsYkecWSkBfPii21SdtJKu6etJhzHwrKL6bhteR6sh3HGktbQj7voTjr6e350756822MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr7h1L5U4zDJwpHkaFVfWxM1xT1RWPW8ev9Nfj9a6djupsSo11111111111111111111111111111111111111112350756822-4na5rL4rSej7EPJXe1iZpfdkdpMxZDbEFWV59iRGV6DdgJPkKTP6ssNPHbhjdiXJiZq1VHPT4vLF4L6uXg55K1pP-3-064vRKH2xTRtveQb6gyvn1u7WMZFRChWpxd5Tj6AdSCPy14na5rL4rSej7EPJXe1iZpfdkdpMxZDbEFWV59iRGV6DdgJPkKTP6ssNPHbhjdiXJiZq1VHPT4vLF4L6uXg55K1pP2rikd7tzPbmowhUJzPNVtX7fuUGcnBa8jqJnx6HbtHeE2025-07-03T02:36:01.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwap2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo040[“7huBu9ZJvAfpZx64VMdefLCTUmGkezPEeLL9yJ1ZSSw”,“AF5qm3SLQug7njzssJoDGEdEvHDTWejiYuuQEdTynkQi”]GhaCjCi7NLZ3mnrxY6i3Cng835C3Q6u3Z8aiZEYEmJer6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma3{“slices”:[]}
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DLMM_Swap2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DLMM_SwapExactOut_instruction

Exact output swap instructions from Meteora’s DLMM (Dynamic Liquidity Market Maker) protocol on Solana, specifying desired output amount with maximum input constraints. Contains token pair data, user accounts, reserves, and swap parameters for analyzing trader behavior and liquidity utilization across discrete liquidity bins.
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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
lb_pairSTRINGAccount address of the liquidity book pair or pool. Base58-encoded Solana public key.
oracleSTRINGAccount providing price feed data for the market or trading pair. Base58-encoded Solana public key.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
reserve_xSTRINGAccount address holding the pool’s reserve of token X. Base58-encoded Solana public key.
reserve_ySTRINGAccount address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
token_x_mintSTRINGMint address of token X in the liquidity pair. Base58-encoded Solana public key.
token_x_programSTRINGProgram address managing token X transfers and operations. Base58-encoded Solana public key.
token_y_mintSTRINGMint address of token Y in the liquidity pair. Base58-encoded Solana public key.
token_y_programSTRINGProgram address managing token Y transfers and operations. Base58-encoded Solana public key.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_token_inSTRINGAccount address holding the user’s input token before the swap. Base58-encoded Solana public key.
user_token_outSTRINGAccount address holding the user’s output token after the swap. Base58-encoded Solana public key.
max_in_amountBIGNUMERICMaximum amount of input tokens the user authorizes to spend for this exact-output swap. Acts as slippage protection by limiting the swap if the required input exceeds this threshold.
out_amountBIGNUMERICAmount of tokens received as output from the swap operation. Integer value representing the quantity in the token’s smallest unit.
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.
useroraclelb_pairprogramreserve_xreserve_yblock_slotout_amounttoken_x_minttoken_y_mintmax_in_amountsurrogate_keyuser_token_intransaction_iduser_token_outblock_timestampevent_authoritytoken_x_programtoken_y_programinstruction_typeexecuting_accountinstruction_indextransaction_indexremaining_accountstransaction_signerouter_executing_accountouter_instruction_index
CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6GXKMWG8sUSBqfHyM9QLkayJa3gQHdA6aq12i1UH9iR7U2KSwspZj2CQmbP1TAJGvVZXonLpz1F9mzH1AXjjs8UbaLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo26cGtuUb5pWgNnZu88xviPnGusgsF4r3QVsxVpJE2ZzCZ45BMBc7zQvMApsoS4ZLYQ3RiGk9f4Y8PrNrnBcwfUk36493418467342667229597PVGU2DzFqsAWaYU17ZBqGvQFmkqtdMywYBNPAfy8vySo1111111111111111111111111111111111111111242925850364934184-3V5gMrjWBuQ4PypwiMDLd5KDQjS4UBJDLPo6TeFMhrXBdWE9cJ8eVuSPjr7kLHJuTfmJVRpXRvAD5cEbJXfyu8xx-0BLpE2fWdce2D3KYs4v8neGwumQzCHMdaeNDLVh4syMVp3V5gMrjWBuQ4PypwiMDLd5KDQjS4UBJDLPo6TeFMhrXBdWE9cJ8eVuSPjr7kLHJuTfmJVRpXRvAD5cEbJXfyu8xx597ATvbC2Ag1vws9DSn25Y6dMbB4F7YwM9ZnX2xo3HPw2025-09-06T01:15:23.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapExactOutLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo0109[“7EqPhfcezgoizYL5gwwC9Sq6jZz3vyUx93vy1BsL5SL1”,“FS7ZdKcLgnCVnK9dXd4RKaVebsbqTTEr7DNCBTzQWgpF”,“ZfFqcEy62cdn83cytRXb743oHhkFMHyDdTQCrFXFztP”]CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6
CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6GXKMWG8sUSBqfHyM9QLkayJa3gQHdA6aq12i1UH9iR7U2KSwspZj2CQmbP1TAJGvVZXonLpz1F9mzH1AXjjs8UbaLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo26cGtuUb5pWgNnZu88xviPnGusgsF4r3QVsxVpJE2ZzCZ45BMBc7zQvMApsoS4ZLYQ3RiGk9f4Y8PrNrnBcwfUk364925027281765547860997PVGU2DzFqsAWaYU17ZBqGvQFmkqtdMywYBNPAfy8vySo11111111111111111111111111111111111111112161177005364925027-3BDj3WT3D1FW6HH5pFQoDkTgYQ4G9Y776Ewx87iBBJG1N9HVCsRResEvb7XDAGcqfiU6HLFtqCVPRJWWrMXyZyQz-0BLpE2fWdce2D3KYs4v8neGwumQzCHMdaeNDLVh4syMVp3BDj3WT3D1FW6HH5pFQoDkTgYQ4G9Y776Ewx87iBBJG1N9HVCsRResEvb7XDAGcqfiU6HLFtqCVPRJWWrMXyZyQz597ATvbC2Ag1vws9DSn25Y6dMbB4F7YwM9ZnX2xo3HPw2025-09-06T00:14:08.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapExactOutLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo0106[“JBxaG2bK2gZKCkJjZSgJeDixkpzzPc7Nu9Cdcyjp8wNF”,“7EqPhfcezgoizYL5gwwC9Sq6jZz3vyUx93vy1BsL5SL1”,“FS7ZdKcLgnCVnK9dXd4RKaVebsbqTTEr7DNCBTzQWgpF”]CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6
CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6GXKMWG8sUSBqfHyM9QLkayJa3gQHdA6aq12i1UH9iR7U2KSwspZj2CQmbP1TAJGvVZXonLpz1F9mzH1AXjjs8UbaLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo26cGtuUb5pWgNnZu88xviPnGusgsF4r3QVsxVpJE2ZzCZ45BMBc7zQvMApsoS4ZLYQ3RiGk9f4Y8PrNrnBcwfUk3650127968242445673249897PVGU2DzFqsAWaYU17ZBqGvQFmkqtdMywYBNPAfy8vySo111111111111111111111111111111111111111124901868627365012796-2tSchrLBSrqm9Tnqn18VziLMrqRqYGoCUSprFGoZNEgW2piBiYVHFsqW1yLES9ZUTAfNniY8VKWtrx2mXdk7SGpd-0BLpE2fWdce2D3KYs4v8neGwumQzCHMdaeNDLVh4syMVp2tSchrLBSrqm9Tnqn18VziLMrqRqYGoCUSprFGoZNEgW2piBiYVHFsqW1yLES9ZUTAfNniY8VKWtrx2mXdk7SGpd597ATvbC2Ag1vws9DSn25Y6dMbB4F7YwM9ZnX2xo3HPw2025-09-06T10:01:00.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapExactOutLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo0299[“7EqPhfcezgoizYL5gwwC9Sq6jZz3vyUx93vy1BsL5SL1”,“FS7ZdKcLgnCVnK9dXd4RKaVebsbqTTEr7DNCBTzQWgpF”,“ZfFqcEy62cdn83cytRXb743oHhkFMHyDdTQCrFXFztP”]CKBCxNxdsfZwTwKYHQmBs7J8zpPjCjMJAxcxoBUwExw6
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DLMM_SwapExactOut_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DLMM_SwapExactOut2_instruction

Exact output swap instructions from Meteora’s Dynamic Liquidity Market Maker (DLMM) protocol on Solana, specifying desired token amount out with maximum input limit. Captures user accounts, token pair reserves, and liquidity bin routing for analyzing targeted swap execution and slippage protection.
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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
lb_pairSTRINGAccount address of the liquidity book pair or pool. 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.
oracleSTRINGAccount providing price feed data for the market or trading pair. Base58-encoded Solana public key.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
reserve_xSTRINGAccount address holding the pool’s reserve of token X. Base58-encoded Solana public key.
reserve_ySTRINGAccount address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
token_x_mintSTRINGMint address of token X in the liquidity pair. Base58-encoded Solana public key.
token_x_programSTRINGProgram address managing token X transfers and operations. Base58-encoded Solana public key.
token_y_mintSTRINGMint address of token Y in the liquidity pair. Base58-encoded Solana public key.
token_y_programSTRINGProgram address managing token Y transfers and operations. Base58-encoded Solana public key.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_token_inSTRINGAccount address holding the user’s input token before the swap. Base58-encoded Solana public key.
user_token_outSTRINGAccount address holding the user’s output token after the swap. Base58-encoded Solana public key.
max_in_amountBIGNUMERICMaximum input token amount the user authorizes for this exact-output swap on Meteora DLMM. Often set to maximum uint64 value (18446744073709551615) indicating no slippage limit.
out_amountBIGNUMERICAmount of tokens received as output from the swap operation. Integer value representing the quantity in the token’s smallest unit.
remaining_accounts_infoJSONAdditional metadata about accounts in remaining_accounts, structured as JSON with slice information. Currently empty for all observed SwapExactOut2 instructions.
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.
useroraclelb_pairprogramreserve_xreserve_yblock_slotout_amountmemo_programtoken_x_minttoken_y_mintmax_in_amountsurrogate_keyuser_token_intransaction_iduser_token_outblock_timestampevent_authoritytoken_x_programtoken_y_programinstruction_typeexecuting_accountinstruction_indextransaction_indexremaining_accountstransaction_signerouter_executing_accountouter_instruction_indexremaining_accounts_info
HxjwdF326ZunmUwC1iXhfgL3ku78YsksN6n7Rfxzwr6b6poMc83qjRz6bPeLheaqxJXiyvZV743knwFKBpVoA4om34y7x6LXsaQhXztArXMA1dEgQqLM7aLsnnUCTpoZR3sKLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxoGLVu2HMDMNig5gTVJ4pxnRWMewm4VwwJmJXftZ7U7SVV2EoAUS4LbMoEWomJhk2f57axxVgLANRF1GkmAPQektuK35048281391594628929MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrDFKgJXQnH99NNh2Uq4896AczXURkYnpwb98bsapSpumpSo1111111111111111111111111111111111111111218446744073709551615350482813-5gPQ838aAAFZxfexLUy7GkqR5XkP9kHnBV35javybtGDCLgcJADcFX8KesgxBtVQtzyKnmFn8mk4rMHQLAN5CGEb-0-05mBxcs67jwkHSSMupQ7oQJ116jMUf8cH1rPdcoHb2sPn5gPQ838aAAFZxfexLUy7GkqR5XkP9kHnBV35javybtGDCLgcJADcFX8KesgxBtVQtzyKnmFn8mk4rMHQLAN5CGEb9fY6kZ5jkB8RhvUXvtFSnzKmQN3ATDDqT7vikziqgPMw2025-07-01T20:27:42.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapExactOut2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo0361[“GLDXyYZjWEeUPfSt8jtw1bBtb99BgZNLqbzzFcRpfaLp”,“3HueR2jwQKMfkQipz2nHH2oBBCAbNd2i39oU6vgxu2G7”,“DqKkarxp642caM6ocAR1ZjLS4WbH8XKdRfXNagQZFHMr”]HxjwdF326ZunmUwC1iXhfgL3ku78YsksN6n7Rfxzwr6bGewJHw4W7ukhnidDtTCszTQMSeX5JXdjh3y6whyCuNSq0{“slices”:[]}
HxjwdF326ZunmUwC1iXhfgL3ku78YsksN6n7Rfxzwr6b6poMc83qjRz6bPeLheaqxJXiyvZV743knwFKBpVoA4om34y7x6LXsaQhXztArXMA1dEgQqLM7aLsnnUCTpoZR3sKLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxoGLVu2HMDMNig5gTVJ4pxnRWMewm4VwwJmJXftZ7U7SVV2EoAUS4LbMoEWomJhk2f57axxVgLANRF1GkmAPQektuK35048281384267058598MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrDFKgJXQnH99NNh2Uq4896AczXURkYnpwb98bsapSpumpSo1111111111111111111111111111111111111111218446744073709551615350482813-2ki8d682faLV6TUrp5Qx6JBB9gBfr33aMY4nGgyhuq8XcpSToTM1jxn9xR1GpvYPD9mbHY47XPQZgnRJotgYXUR6-0-05mBxcs67jwkHSSMupQ7oQJ116jMUf8cH1rPdcoHb2sPn2ki8d682faLV6TUrp5Qx6JBB9gBfr33aMY4nGgyhuq8XcpSToTM1jxn9xR1GpvYPD9mbHY47XPQZgnRJotgYXUR69fY6kZ5jkB8RhvUXvtFSnzKmQN3ATDDqT7vikziqgPMw2025-07-01T20:27:42.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapExactOut2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo0362[“GLDXyYZjWEeUPfSt8jtw1bBtb99BgZNLqbzzFcRpfaLp”,“3HueR2jwQKMfkQipz2nHH2oBBCAbNd2i39oU6vgxu2G7”,“DqKkarxp642caM6ocAR1ZjLS4WbH8XKdRfXNagQZFHMr”]HxjwdF326ZunmUwC1iXhfgL3ku78YsksN6n7Rfxzwr6bGewJHw4W7ukhnidDtTCszTQMSeX5JXdjh3y6whyCuNSq0{“slices”:[]}
HxjwdF326ZunmUwC1iXhfgL3ku78YsksN6n7Rfxzwr6b4uW8zBrGjzyduL1Ryt7qAKUVf1vsmxfd6NXopaGrZnD1H9my58gexRYUZjAiYBjHJM8JX6vrpVu7uhFJAyZYMf4HLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo3awd7CESmLNoa6krYVFmU3SxrsZwvpgLeJ9173Qj9uVD2FqvacmYmi2BXt11sMeDi8RU4DkSFbG8GGfWcR7MaN6F3504699324558101927MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrCzHc1ugMNhim5JCJC8ebbp4k14jfrbZx1HNcMyEppumpSo1111111111111111111111111111111111111111218446744073709551615350469932-53ZdH7DnaseVACKcBw1un4pQaHJv9f2XaFdBZ31ZPRzUTR1PEMgmhCaSdjvK5Ds3hoN8oBeGMtEbFW9pLV6kQzAC-0-05mBxcs67jwkHSSMupQ7oQJ116jMUf8cH1rPdcoHb2sPn53ZdH7DnaseVACKcBw1un4pQaHJv9f2XaFdBZ31ZPRzUTR1PEMgmhCaSdjvK5Ds3hoN8oBeGMtEbFW9pLV6kQzAC3ooLEE7qfVhyiUgKXPemTAHKEYGGUXP4VnKS69TTJDmh2025-07-01T19:03:03.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapExactOut2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo06[“BcAkndoZJtkapCYb4Ptswpip4niafDmqXFJ9fFUBjoQn”,“H5sPCeQad5uw6c7rSVCzg1H3abkUKWikYTSLDQHyVDss”]HxjwdF326ZunmUwC1iXhfgL3ku78YsksN6n7Rfxzwr6bGewJHw4W7ukhnidDtTCszTQMSeX5JXdjh3y6whyCuNSq0{“slices”:[]}
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DLMM_SwapExactOut2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DLMM_SwapWithPriceImpact2_instruction

Swap instructions from Meteora’s DLMM (Dynamic Liquidity Market Maker) protocol on Solana with price impact protection limits. Contains swap amounts, active price bins, token pair details, and maximum slippage thresholds in basis points for analyzing DEX trading patterns and liquidity utilization.
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.
event_authoritySTRINGAccount address designated to emit program events for monitoring and logging. Base58-encoded Solana public key.
lb_pairSTRINGAccount address of the liquidity book pair or pool. 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.
oracleSTRINGAccount providing price feed data for the market or trading pair. Base58-encoded Solana public key.
programSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
reserve_xSTRINGAccount address holding the pool’s reserve of token X. Base58-encoded Solana public key.
reserve_ySTRINGAccount address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
token_x_mintSTRINGMint address of token X in the liquidity pair. Base58-encoded Solana public key.
token_x_programSTRINGProgram address managing token X transfers and operations. Base58-encoded Solana public key.
token_y_mintSTRINGMint address of token Y in the liquidity pair. Base58-encoded Solana public key.
token_y_programSTRINGProgram address managing token Y transfers and operations. Base58-encoded Solana public key.
userSTRINGAccount that initiates or owns the transaction or operation. Base58-encoded Solana public key.
user_token_inSTRINGAccount address holding the user’s input token before the swap. Base58-encoded Solana public key.
user_token_outSTRINGAccount address holding the user’s output token after the swap. Base58-encoded Solana public key.
active_idINT64Current active bin ID of the DLMM (Dynamic Liquidity Market Maker) pool at swap execution time. Represents the price point where liquidity is concentrated, with values ranging from negative to positive integers.
amount_inBIGNUMERICInput amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
max_price_impact_bpsINT64Maximum allowed price impact for the swap expressed in basis points (BPS). Commonly set to 100 (1%), 1000 (10%), or lower values to protect against excessive slippage.
remaining_accounts_infoJSONAdditional metadata describing the structure of accounts in the remaining_accounts array. JSON object containing slices that categorize account groups by type (e.g., TransferHookX, TransferHookY) and their lengths.
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.
useroraclelb_pairprogramactive_idamount_inreserve_xreserve_yblock_slotmemo_programtoken_x_minttoken_y_mintsurrogate_keyuser_token_intransaction_iduser_token_outblock_timestampevent_authoritytoken_x_programtoken_y_programinstruction_typeexecuting_accountinstruction_indextransaction_indexremaining_accountstransaction_signermax_price_impact_bpsouter_executing_accountouter_instruction_indexremaining_accounts_info
AEApgTi3A44NBQY4GUDAZZd4RgEo5qBGzmkFBCnLngex2wTGAGZYaxr8fDy3pcJy1QuLPBfg3HY7N9QQTfwWeHjG6wJ7W3oHj7ex6MVFp2o26NSof3aey7U8Brs8E371WCXALBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo9931000000CMVrNeYhZnqdbZfQuijgcNvCfvTJN2WKvKSnt2q3HT6N5EfbkfLpaz9mHeTN6FnhtN8DTdMGZDRURYcsQ1f1Utg6335090896MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpSo11111111111111111111111111111111111111112335090896-gB9LGKEv4w7NhEV9bYDXim722wZVjwxbQTNGFc1rp8Nw3uUdtd8fgRUSMaiGUcaYm4AYMJCjsfiBTd5LaYd6SiF-38t11JazLbVSEQALJwcDu6wiyK2peDR1PNhjCHkNKnraAgB9LGKEv4w7NhEV9bYDXim722wZVjwxbQTNGFc1rp8Nw3uUdtd8fgRUSMaiGUcaYm4AYMJCjsfiBTd5LaYd6SiFEuMYXsrtqcjVzQWXe8R7zgpTkUk6DTVBkeBJvj1zSHEi2025-04-22T05:44:35.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapWithPriceImpact2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo3159[“3v3YCCddek9CDExhHtkkq6qnPRYNaUmdLCodxD8bGQQA”,“7X9hRXCQqtJogCxVmdiWcu1qQxvbdNcr7M4fSPFigAEk”,“EKHP8kFUhRKi5RHBbpLJL2H4Gdx3Xh2diWK51jYAPb2i”,“FgCuebzK8zhwchqgTTWBjUVtg7Ktsg4asBfyCJGeHgZv”]AEApgTi3A44NBQY4GUDAZZd4RgEo5qBGzmkFBCnLngex100{“slices”:[{“accounts_type”:“TransferHookX”,“length”:0},{“accounts_type”:“TransferHookY”,“length”:0}]}
AEApgTi3A44NBQY4GUDAZZd4RgEo5qBGzmkFBCnLngex2wTGAGZYaxr8fDy3pcJy1QuLPBfg3HY7N9QQTfwWeHjG6wJ7W3oHj7ex6MVFp2o26NSof3aey7U8Brs8E371WCXALBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo9951000000CMVrNeYhZnqdbZfQuijgcNvCfvTJN2WKvKSnt2q3HT6N5EfbkfLpaz9mHeTN6FnhtN8DTdMGZDRURYcsQ1f1Utg6335092335MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpumpSo11111111111111111111111111111111111111112335092335-4ARv4ncRixMptuexx5HEbDztsu7HhZMTL1eDgpHoi7LnhzCHqC1b6jFZTAGuJAEcfVkDt6dp66dQTGmV6pfjzK5G-48t11JazLbVSEQALJwcDu6wiyK2peDR1PNhjCHkNKnraA4ARv4ncRixMptuexx5HEbDztsu7HhZMTL1eDgpHoi7LnhzCHqC1b6jFZTAGuJAEcfVkDt6dp66dQTGmV6pfjzK5GEuMYXsrtqcjVzQWXe8R7zgpTkUk6DTVBkeBJvj1zSHEi2025-04-22T05:54:08.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapWithPriceImpact2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo4201[“3v3YCCddek9CDExhHtkkq6qnPRYNaUmdLCodxD8bGQQA”,“7X9hRXCQqtJogCxVmdiWcu1qQxvbdNcr7M4fSPFigAEk”,“EKHP8kFUhRKi5RHBbpLJL2H4Gdx3Xh2diWK51jYAPb2i”,“FgCuebzK8zhwchqgTTWBjUVtg7Ktsg4asBfyCJGeHgZv”]AEApgTi3A44NBQY4GUDAZZd4RgEo5qBGzmkFBCnLngex100{“slices”:[{“accounts_type”:“TransferHookX”,“length”:0},{“accounts_type”:“TransferHookY”,“length”:0}]}
6ZgXjkSmcAqV2ELiRv33D16CQV5GAkFpL8jmuBg5QfPY6sxkiLgrEGvAcyhmKuDKyLdSjioRPficbScjH6YZtQUaEo8V81Ktxx3rG9NNCauBrBHXuuy3xRMgQXDM1z63ag3cLBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo-5361100000CeoNSAPhPi5HtzJy9AgDEC5dLT11YeQX4vpYUfjx6DsSHtx1JpTaRg3V6pRhMxGFXDNWJDcf4TUzCiDjZhFfnXCf348053059MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHrJBahfY5TSFaBooJ5N186Zd9JNvVgm9iHRJSUFT5KqNxASo11111111111111111111111111111111111111112348053059-3PXSbyytD6SJfxo3n12TJEo3ohsTweTi17m9VsvspX4MyuAhKHVteTC87svQAE9iQHxzUpgSyYCujzrtTZi97Ngn-42YGA6ogjCtCJGg5HaPpreiH7qeiQEWsboiV1UhNVk8LB3PXSbyytD6SJfxo3n12TJEo3ohsTweTi17m9VsvspX4MyuAhKHVteTC87svQAE9iQHxzUpgSyYCujzrtTZi97Ngn2p3276tqQxXqYpRQEiWujZEHDBGamtyyCZH7zYGjerN42025-06-20T14:48:22.000ZD1ZN9Wj1fRSUQfCjhvnu1hqDMT7hzjzBBpi12nVniYD6TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DATokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DASwapWithPriceImpact2LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxo4218[“H2P37u33LXJ4Y2iVPtAdZzXJmLkTf7WQe2fxf33sqSAG”,“5R7n5Pdm4zHqt8dgGSucFRrFGw2Jhp6E3yht1LFVcyrs”,“VQKnDvSpBz8kk7zoGXrv8bgzJeDtzBowLQ6TpRdVWc8”]6ZgXjkSmcAqV2ELiRv33D16CQV5GAkFpL8jmuBg5QfPY1000{“slices”:[]}
Query with partition filter
SELECT *
FROM `tt-contracts.meteora_v1_solana.DLMM_SwapWithPriceImpact2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100