Skip to main content

​
Tables

​
Swap_instruction

Token swap execution records from decentralized exchange (DEX) programs on Solana. Contains input/output amounts, token accounts, liquidity pool references, and slippage protection parameters for atomic token exchanges.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
executing_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
ammSTRINGProgram address of the automated market maker pool. Base58-encoded Solana public key.
authoritySTRINGAccount authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
destination_infoSTRINGAccount address that receives the swapped tokens after the transaction completes. This is the destination token account within Lifinity’s AMM infrastructure.
fee_accountSTRINGAccount address that receives protocol fees charged on the swap transaction. Remains constant across all swaps in this Lifinity pool.
oracle_main_accountSTRINGOracle account address providing primary price feed data for the Lifinity AMM pool. Used alongside oracle_pc_account and oracle_sub_account for price discovery and swap calculations.
oracle_pc_accountSTRINGOracle account address for price counter token in the Lifinity automated market maker (AMM) pool. Used to fetch real-time pricing data for swap calculations.
oracle_sub_accountSTRINGOracle account address for the secondary or sub-price feed used by the Lifinity automated market maker (AMM). Provides additional pricing data to support swap calculations and slippage protection.
pool_mintSTRINGMint address of the liquidity pool token representing shares in the Lifinity AMM pool. Base58-encoded Solana program address.
source_infoSTRINGToken account providing input tokens for the swap transaction. Base58-encoded Solana account address holding the user’s source tokens.
swap_destinationSTRINGToken account receiving the output tokens after the swap completes. Base58-encoded Solana account address holding the destination token balance.
swap_sourceSTRINGToken account address from which the swap withdraws input tokens. Base58-encoded Solana account address serving as the source for the token transfer.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
user_transfer_authoritySTRINGAccount authorized to transfer tokens from the user’s token account during the swap operation. 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.
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.
ammamount_inauthoritypool_mintblock_slotfee_accountsource_infoswap_sourcesurrogate_keytoken_programtransaction_idblock_timestampdestination_infoinstruction_typeswap_destinationexecuting_accountinstruction_indexoracle_pc_accounttransaction_indexminimum_amount_outoracle_sub_accountremaining_accountstransaction_signeroracle_main_accountouter_executing_accountouter_instruction_indexuser_transfer_authority
AcU6ZBSM3qaEJUeoJYXwAwMqcffmi5NYoFswdtWmXTKh53421607BkxnE1qJrzw2SE1Voy29DXHkZfXmKkQa9eh2Zuzitpo1BsFuJEShHAdLoY8JjeZN7EiaMAobVGzGnpdS5d3pCCXu290657543Dk3nZq6G16pnPAUmrHwEvC3HJBep4tQU5i5gpWAsRXcvHo1BJBuxMc9hVejqmKwZeHiWmYHH3i9Zbe31kbUojdHmGyBabQx5BkpqAnwVYeppZUkJYADJK3jnmEZ6G9znWiW9290657543-2wfbzVJAfFhGALQbkyzeYHaHV4rPoEYiRGWxtyCftHmadQ9Qrz7jCwQaTtHYtawfLsNPvrdPyKJYEuiiBJSFXBd2-11-4TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA2wfbzVJAfFhGALQbkyzeYHaHV4rPoEYiRGWxtyCftHmadQ9Qrz7jCwQaTtHYtawfLsNPvrdPyKJYEuiiBJSFXBd22024-09-19T02:47:06.000ZERuJ75WRaantrVrMFqMzbUNLbp1mKB2ZRnaTXK7qmekaSwap2JM5V31bjr3vdnT1jeGMB3AdZUv72FGpo9zsBnegdpGB2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c4EF1U95mUHvhjjRms9QhodoEaRGVitnqiCsU7pkuFHXv7570EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB[]rightnGF4tk4NaN9Me3gGhFc5MpAsciJJf3V1wbRQJcEPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDBJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV411rightnGF4tk4NaN9Me3gGhFc5MpAsciJJf3V1wbRQJc
AcU6ZBSM3qaEJUeoJYXwAwMqcffmi5NYoFswdtWmXTKh27724393BkxnE1qJrzw2SE1Voy29DXHkZfXmKkQa9eh2Zuzitpo1BsFuJEShHAdLoY8JjeZN7EiaMAobVGzGnpdS5d3pCCXu290694105Dk3nZq6G16pnPAUmrHwEvC3HJBep4tQU5i5gpWAsRXcvGJD8AfssT3Gh2QioMbBTmEeNY2ZG2Myrbv3xoShbTAbvGyBabQx5BkpqAnwVYeppZUkJYADJK3jnmEZ6G9znWiW9290694105-strFZShvp2gjtDJ7UUWKpfsaFgmCVDskYQUCU3ay3nHvoxAJHshvw3mVnHfjWawGZbz246jHyG9nTJ6E9ycqN53-6-4TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAstrFZShvp2gjtDJ7UUWKpfsaFgmCVDskYQUCU3ay3nHvoxAJHshvw3mVnHfjWawGZbz246jHyG9nTJ6E9ycqN532024-09-19T07:12:49.000Z3CyEf1261jWSnq7SgvzCswLh6Aphr8YzF2JoaFxWVW35Swap2JM5V31bjr3vdnT1jeGMB3AdZUv72FGpo9zsBnegdpGB2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c4EF1U95mUHvhjjRms9QhodoEaRGVitnqiCsU7pkuFHXv7850EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB[]yssJP6Te8Qu5SUUfYCNXzbxoE9tDyvN6bDHf7KuE8QZEPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDBJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV46yssJP6Te8Qu5SUUfYCNXzbxoE9tDyvN6bDHf7KuE8QZ
AcU6ZBSM3qaEJUeoJYXwAwMqcffmi5NYoFswdtWmXTKh9235571BkxnE1qJrzw2SE1Voy29DXHkZfXmKkQa9eh2Zuzitpo1BsFuJEShHAdLoY8JjeZN7EiaMAobVGzGnpdS5d3pCCXu290662526Dk3nZq6G16pnPAUmrHwEvC3HJBep4tQU5i5gpWAsRXcvBhTwsDdGWFJNTrgT9fSeA19tEZ5WzDXdCjuuDiQ3irrMGyBabQx5BkpqAnwVYeppZUkJYADJK3jnmEZ6G9znWiW9290662526-m98VYLgbS2ucQQ4MUuxhU6pM7HJLJiwgNnnpyaFevHgoXdXsnYUM63Z6viaVg8zSYacQNDJ9DZQk7yngNLB27SU-6-4TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAm98VYLgbS2ucQQ4MUuxhU6pM7HJLJiwgNnnpyaFevHgoXdXsnYUM63Z6viaVg8zSYacQNDJ9DZQk7yngNLB27SU2024-09-19T03:24:31.000Z6xRZmRPMsuiTtPJdbZumSTuyX8gyMAm5fDRAZsbqjbPFSwap2JM5V31bjr3vdnT1jeGMB3AdZUv72FGpo9zsBnegdpGB2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c4EF1U95mUHvhjjRms9QhodoEaRGVitnqiCsU7pkuFHXv71190EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB[]BarronCrmQmTxz3VTdRALxMGjDxHkZzDc8L4r44NnWKAEPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDBJUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV46BarronCrmQmTxz3VTdRALxMGjDxHkZzDc8L4r44NnWKA
Query with partition filter
SELECT *
FROM `tt-contracts.lifinity_v1_solana.Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
SwapV2_Swap_instruction

Swap instruction records from Lifinity V1 automated market maker (AMM) on Solana, containing input amounts, token accounts, pool identifiers, and oracle references. Used for analyzing DEX trading activity, liquidity pool performance, and price execution across Lifinity pools.
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.
ammSTRINGProgram address of the automated market maker pool. Base58-encoded Solana public key.
authoritySTRINGAccount authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
destination_infoSTRINGSolana account address holding metadata or state information for the destination token in the swap. This account is distinct from the actual token destination account and is used by the Lifinity protocol for tracking swap parameters.
fee_accountSTRINGSolana account address that receives trading fees for this swap transaction. Base58-encoded public key representing the fee collection wallet for the Lifinity protocol.
oracle_main_accountSTRINGOracle account address for the primary token in the swap pair, used by Lifinity’s proactive market maker for price discovery. Provided for every swap operation on Solana.
oracle_pc_accountSTRINGOracle account address for the price conversion token in the Lifinity AMM pool. Used to determine swap rates when trading between token pairs.
oracle_sub_accountSTRINGOracle account address for the subordinate (secondary) price feed used in the Lifinity V1 swap. Provides additional price data alongside the main oracle to enhance price accuracy and reduce manipulation risk.
pool_mintSTRINGSolana mint address of the liquidity pool token for the Lifinity automated market maker. Each AMM pool issues a unique mint representing liquidity provider shares.
source_infoSTRINGSolana account containing metadata about the source token being swapped out of the pool. This account provides token account information for the swap source used in the Lifinity V1 swap instruction.
swap_destinationSTRINGToken account receiving the output tokens from the swap. Solana base58-encoded address where swapped tokens are deposited after the trade executes.
swap_sourceSTRINGToken account address from which the input tokens are debited during the swap. Base58-encoded Solana account identifier representing the user’s source token balance.
token_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
user_transfer_authoritySTRINGAccount authorized to transfer tokens from the user’s token account during the swap operation. 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.
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.
ammamount_inauthoritypool_mintblock_slotfee_accountsource_infoswap_sourcesurrogate_keytoken_programtransaction_idblock_timestampdestination_infoinstruction_typeswap_destinationexecuting_accountinstruction_indexoracle_pc_accounttransaction_indexminimum_amount_outoracle_sub_accountremaining_accountstransaction_signeroracle_main_accountouter_executing_accountouter_instruction_indexuser_transfer_authority
Cx8eWxJAaCQAFVmv1mP7B2cVie2BnkR7opP8vUh23Wcr34673246YJWm3nhHXGPvgAHErWcNmqPQtSSHZhvtmE4U9Adwb3gEJhqXKJEncSx1HJjS5ZpKdiKGGgLiRgNPvo8JZvw5Guj213928474E8Bw6Zt6NxjaHmHyhkXsq4UiLbHzicLKmhUAfCz1bgdU9STUXwnxusc2DMn7V2nqC2Lu2qfpk5KysbHJYX4cGcTaCqs1j5n7mJ8sCaa15FRAYrYmtDktKL3itBQzjangscB3213928474-3wTpDpy5zDQEV2hvfWKfVGKE7cxmuLYJAthAZLEhTziXnxamLNKVZUd4kRABdnrAJjXzzZtkQczm5epKdf5xNeK3-3-3TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA3wTpDpy5zDQEV2hvfWKfVGKE7cxmuLYJAthAZLEhTziXnxamLNKVZUd4kRABdnrAJjXzzZtkQczm5epKdf5xNeK32023-08-27T11:15:18.000Z7ZdNHwfN47NEyc84zxJAeWDAnfS3dkHUamgW5BEn6VJqSwapBhi2nPWnHv2ZV6rFDJc2Xepj6ufkdFZsUs24DAozNzCP2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c37KX5bLSyGRUDjWnmKDpnCKNfsrM9Yc1ueMBwuHnJw3kU270H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG[]222pEN8xcEwjVbtZfF7HaFRvxGsjBbWj3mqFWV8dNgL1FdfXTrKevBiz5yoGfpdSXcSbZj2bF1jUQWSixhyYdU2QJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB3222pEN8xcEwjVbtZfF7HaFRvxGsjBbWj3mqFWV8dNgL1
Cx8eWxJAaCQAFVmv1mP7B2cVie2BnkR7opP8vUh23Wcr1060912266YJWm3nhHXGPvgAHErWcNmqPQtSSHZhvtmE4U9Adwb3gEJhqXKJEncSx1HJjS5ZpKdiKGGgLiRgNPvo8JZvw5Guj213848939E8Bw6Zt6NxjaHmHyhkXsq4UiLbHzicLKmhUAfCz1bgdU2R9mJYHn4LHE5CeKMDpQPWFxpAU3uRSABAYMNynKnQBwBhi2nPWnHv2ZV6rFDJc2Xepj6ufkdFZsUs24DAozNzCP213848939-A9ZXmGHx7QsNzUL1uYntW7Yhzbfu6K9o69JDAvYkPmtXHtkxfEt9AKwPA9bvS49N4oKk4tM1sXcBeE6ZxkN8mbR-2-3TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAA9ZXmGHx7QsNzUL1uYntW7Yhzbfu6K9o69JDAvYkPmtXHtkxfEt9AKwPA9bvS49N4oKk4tM1sXcBeE6ZxkN8mbR2023-08-27T01:45:53.000ZBCp15pjKfnyaTNqHu536axoiEPN4MNeFvwfeMaFna7KCSwapCqs1j5n7mJ8sCaa15FRAYrYmtDktKL3itBQzjangscB32wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c37KX5bLSyGRUDjWnmKDpnCKNfsrM9Yc1ueMBwuHnJw3kU210H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG[]2EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4FdfXTrKevBiz5yoGfpdSXcSbZj2bF1jUQWSixhyYdU2QJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB22EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4
5aA49noLf1Npt4cVWT4CAKqZhSQYYpSfy64Sv3rJdenS20955638AqN7qN9KT3zHPqUNzRd45fhNQdgAs5sqWaLMygtmMYsj7thU97STYodyB1N6EBod4d1ZUZaT5NioYoqddHvNr7u22140261837QtMkw4NeDKyF4zTKkUjX5C4VWYqkJ97BTPpkbVGXhs756ENbUHD7cP4YXTjj4jfhb7tuisSh74Aup5ZauHZZLZ9Cz2XEzxJLhm6GFPF8Jvgt8pYptAgn5tqdzHUrZr1BNqt214026183-5DeBjCdnvvo69CmrkzueNyWTJJPNWSqeoFry2nBkNcqXipKS3mS56DQUYgabGuvVgUx6hYJhrZkHN5sqwHDJ3k1P-1-7TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA5DeBjCdnvvo69CmrkzueNyWTJJPNWSqeoFry2nBkNcqXipKS3mS56DQUYgabGuvVgUx6hYJhrZkHN5sqwHDJ3k1P2023-08-27T23:00:45.000Z6e7bx4vnKr7hsGDscgC7hTL1SWxgwffLVUPpXrxHQLXWSwapD4gReMNn1RQfFCYtLKrKmXTBJqSuKSjUS6AGpZwtn6p62wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c79Ru2ENpz8wdXsBYyL7kxxnxSrhCs71BmU9ovJLKFiwt5440H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG[]2EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDBJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB12EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4
Query with partition filter
SELECT *
FROM `tt-contracts.lifinity_v1_solana.SwapV2_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100