lifinity_v1_solana

Tables

Swap_instruction

Token swap execution records from decentralized exchange (DEX) programs on Solana. Contains input/output amounts, token accounts, liquidity pool references, and slippage protection parameters for atomic token exchanges.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`amm`	`STRING`	Program address of the automated market maker pool. Base58-encoded Solana public key.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`destination_info`	`STRING`	Account address that receives the swapped tokens after the transaction completes. This is the destination token account within Lifinity’s AMM infrastructure.
`fee_account`	`STRING`	Account address that receives protocol fees charged on the swap transaction. Remains constant across all swaps in this Lifinity pool.
`oracle_main_account`	`STRING`	Oracle 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_account`	`STRING`	Oracle 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_account`	`STRING`	Oracle 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_mint`	`STRING`	Mint address of the liquidity pool token representing shares in the Lifinity AMM pool. Base58-encoded Solana program address.
`source_info`	`STRING`	Token account providing input tokens for the swap transaction. Base58-encoded Solana account address holding the user’s source tokens.
`swap_destination`	`STRING`	Token account receiving the output tokens after the swap completes. Base58-encoded Solana account address holding the destination token balance.
`swap_source`	`STRING`	Token account address from which the swap withdraws input tokens. Base58-encoded Solana account address serving as the source for the token transfer.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user_transfer_authority`	`STRING`	Account authorized to transfer tokens from the user’s token account during the swap operation. Base58-encoded Solana public key.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

amm	amount_in	authority	pool_mint	block_slot	fee_account	source_info	swap_source	surrogate_key	token_program	transaction_id	block_timestamp	destination_info	instruction_type	swap_destination	executing_account	instruction_index	oracle_pc_account	transaction_index	oracle_sub_account	remaining_accounts	transaction_signer	oracle_main_account	outer_executing_account	outer_instruction_index	user_transfer_authority
AcU6ZBSM3qaEJUeoJYXwAwMqcffmi5NYoFswdtWmXTKh	53421607	BkxnE1qJrzw2SE1Voy29DXHkZfXmKkQa9eh2Zuzitpo1	BsFuJEShHAdLoY8JjeZN7EiaMAobVGzGnpdS5d3pCCXu	290657543	Dk3nZq6G16pnPAUmrHwEvC3HJBep4tQU5i5gpWAsRXcv	Ho1BJBuxMc9hVejqmKwZeHiWmYHH3i9Zbe31kbUojdHm	GyBabQx5BkpqAnwVYeppZUkJYADJK3jnmEZ6G9znWiW9	290657543-2wfbzVJAfFhGALQbkyzeYHaHV4rPoEYiRGWxtyCftHmadQ9Qrz7jCwQaTtHYtawfLsNPvrdPyKJYEuiiBJSFXBd2-11-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	2wfbzVJAfFhGALQbkyzeYHaHV4rPoEYiRGWxtyCftHmadQ9Qrz7jCwQaTtHYtawfLsNPvrdPyKJYEuiiBJSFXBd2	2024-09-19T02:47:06.000Z	ERuJ75WRaantrVrMFqMzbUNLbp1mKB2ZRnaTXK7qmeka	Swap	2JM5V31bjr3vdnT1jeGMB3AdZUv72FGpo9zsBnegdpGB	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	4	EF1U95mUHvhjjRms9QhodoEaRGVitnqiCsU7pkuFHXv7	57	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	[]	rightnGF4tk4NaN9Me3gGhFc5MpAsciJJf3V1wbRQJc	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	11	rightnGF4tk4NaN9Me3gGhFc5MpAsciJJf3V1wbRQJc
AcU6ZBSM3qaEJUeoJYXwAwMqcffmi5NYoFswdtWmXTKh	27724393	BkxnE1qJrzw2SE1Voy29DXHkZfXmKkQa9eh2Zuzitpo1	BsFuJEShHAdLoY8JjeZN7EiaMAobVGzGnpdS5d3pCCXu	290694105	Dk3nZq6G16pnPAUmrHwEvC3HJBep4tQU5i5gpWAsRXcv	GJD8AfssT3Gh2QioMbBTmEeNY2ZG2Myrbv3xoShbTAbv	GyBabQx5BkpqAnwVYeppZUkJYADJK3jnmEZ6G9znWiW9	290694105-strFZShvp2gjtDJ7UUWKpfsaFgmCVDskYQUCU3ay3nHvoxAJHshvw3mVnHfjWawGZbz246jHyG9nTJ6E9ycqN53-6-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	strFZShvp2gjtDJ7UUWKpfsaFgmCVDskYQUCU3ay3nHvoxAJHshvw3mVnHfjWawGZbz246jHyG9nTJ6E9ycqN53	2024-09-19T07:12:49.000Z	3CyEf1261jWSnq7SgvzCswLh6Aphr8YzF2JoaFxWVW35	Swap	2JM5V31bjr3vdnT1jeGMB3AdZUv72FGpo9zsBnegdpGB	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	4	EF1U95mUHvhjjRms9QhodoEaRGVitnqiCsU7pkuFHXv7	85	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	[]	yssJP6Te8Qu5SUUfYCNXzbxoE9tDyvN6bDHf7KuE8QZ	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	6	yssJP6Te8Qu5SUUfYCNXzbxoE9tDyvN6bDHf7KuE8QZ
AcU6ZBSM3qaEJUeoJYXwAwMqcffmi5NYoFswdtWmXTKh	9235571	BkxnE1qJrzw2SE1Voy29DXHkZfXmKkQa9eh2Zuzitpo1	BsFuJEShHAdLoY8JjeZN7EiaMAobVGzGnpdS5d3pCCXu	290662526	Dk3nZq6G16pnPAUmrHwEvC3HJBep4tQU5i5gpWAsRXcv	BhTwsDdGWFJNTrgT9fSeA19tEZ5WzDXdCjuuDiQ3irrM	GyBabQx5BkpqAnwVYeppZUkJYADJK3jnmEZ6G9znWiW9	290662526-m98VYLgbS2ucQQ4MUuxhU6pM7HJLJiwgNnnpyaFevHgoXdXsnYUM63Z6viaVg8zSYacQNDJ9DZQk7yngNLB27SU-6-4	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	m98VYLgbS2ucQQ4MUuxhU6pM7HJLJiwgNnnpyaFevHgoXdXsnYUM63Z6viaVg8zSYacQNDJ9DZQk7yngNLB27SU	2024-09-19T03:24:31.000Z	6xRZmRPMsuiTtPJdbZumSTuyX8gyMAm5fDRAZsbqjbPF	Swap	2JM5V31bjr3vdnT1jeGMB3AdZUv72FGpo9zsBnegdpGB	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	4	EF1U95mUHvhjjRms9QhodoEaRGVitnqiCsU7pkuFHXv7	119	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	[]	BarronCrmQmTxz3VTdRALxMGjDxHkZzDc8L4r44NnWKA	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	6	BarronCrmQmTxz3VTdRALxMGjDxHkZzDc8L4r44NnWKA

Example Query

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`amm`	`STRING`	Program address of the automated market maker pool. Base58-encoded Solana public key.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`destination_info`	`STRING`	Solana 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_account`	`STRING`	Solana 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_account`	`STRING`	Oracle 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_account`	`STRING`	Oracle account address for the price conversion token in the Lifinity AMM pool. Used to determine swap rates when trading between token pairs.
`oracle_sub_account`	`STRING`	Oracle 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_mint`	`STRING`	Solana 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_info`	`STRING`	Solana 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_destination`	`STRING`	Token account receiving the output tokens from the swap. Solana base58-encoded address where swapped tokens are deposited after the trade executes.
`swap_source`	`STRING`	Token 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_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`user_transfer_authority`	`STRING`	Account authorized to transfer tokens from the user’s token account during the swap operation. Base58-encoded Solana public key.
`amount_in`	`BIGNUMERIC`	Input amount of tokens being swapped or deposited in the transaction. Integer value representing the quantity in the token’s smallest unit.
`minimum_amount_out`	`BIGNUMERIC`	Minimum output amount required from the swap transaction to prevent slippage. Integer value representing the quantity in the token’s smallest unit.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

amm	amount_in	authority	pool_mint	block_slot	fee_account	source_info	swap_source	surrogate_key	token_program	transaction_id	block_timestamp	destination_info	instruction_type	swap_destination	executing_account	instruction_index	oracle_pc_account	transaction_index	oracle_sub_account	remaining_accounts	transaction_signer	oracle_main_account	outer_executing_account	outer_instruction_index	user_transfer_authority
Cx8eWxJAaCQAFVmv1mP7B2cVie2BnkR7opP8vUh23Wcr	3467324	6YJWm3nhHXGPvgAHErWcNmqPQtSSHZhvtmE4U9Adwb3g	EJhqXKJEncSx1HJjS5ZpKdiKGGgLiRgNPvo8JZvw5Guj	213928474	E8Bw6Zt6NxjaHmHyhkXsq4UiLbHzicLKmhUAfCz1bgdU	9STUXwnxusc2DMn7V2nqC2Lu2qfpk5KysbHJYX4cGcTa	Cqs1j5n7mJ8sCaa15FRAYrYmtDktKL3itBQzjangscB3	213928474-3wTpDpy5zDQEV2hvfWKfVGKE7cxmuLYJAthAZLEhTziXnxamLNKVZUd4kRABdnrAJjXzzZtkQczm5epKdf5xNeK3-3-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	3wTpDpy5zDQEV2hvfWKfVGKE7cxmuLYJAthAZLEhTziXnxamLNKVZUd4kRABdnrAJjXzzZtkQczm5epKdf5xNeK3	2023-08-27T11:15:18.000Z	7ZdNHwfN47NEyc84zxJAeWDAnfS3dkHUamgW5BEn6VJq	Swap	Bhi2nPWnHv2ZV6rFDJc2Xepj6ufkdFZsUs24DAozNzCP	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	3	7KX5bLSyGRUDjWnmKDpnCKNfsrM9Yc1ueMBwuHnJw3kU	27	H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG	[]	222pEN8xcEwjVbtZfF7HaFRvxGsjBbWj3mqFWV8dNgL1	FdfXTrKevBiz5yoGfpdSXcSbZj2bF1jUQWSixhyYdU2Q	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	3	222pEN8xcEwjVbtZfF7HaFRvxGsjBbWj3mqFWV8dNgL1
Cx8eWxJAaCQAFVmv1mP7B2cVie2BnkR7opP8vUh23Wcr	106091226	6YJWm3nhHXGPvgAHErWcNmqPQtSSHZhvtmE4U9Adwb3g	EJhqXKJEncSx1HJjS5ZpKdiKGGgLiRgNPvo8JZvw5Guj	213848939	E8Bw6Zt6NxjaHmHyhkXsq4UiLbHzicLKmhUAfCz1bgdU	2R9mJYHn4LHE5CeKMDpQPWFxpAU3uRSABAYMNynKnQBw	Bhi2nPWnHv2ZV6rFDJc2Xepj6ufkdFZsUs24DAozNzCP	213848939-A9ZXmGHx7QsNzUL1uYntW7Yhzbfu6K9o69JDAvYkPmtXHtkxfEt9AKwPA9bvS49N4oKk4tM1sXcBeE6ZxkN8mbR-2-3	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	A9ZXmGHx7QsNzUL1uYntW7Yhzbfu6K9o69JDAvYkPmtXHtkxfEt9AKwPA9bvS49N4oKk4tM1sXcBeE6ZxkN8mbR	2023-08-27T01:45:53.000Z	BCp15pjKfnyaTNqHu536axoiEPN4MNeFvwfeMaFna7KC	Swap	Cqs1j5n7mJ8sCaa15FRAYrYmtDktKL3itBQzjangscB3	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	3	7KX5bLSyGRUDjWnmKDpnCKNfsrM9Yc1ueMBwuHnJw3kU	21	H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG	[]	2EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4	FdfXTrKevBiz5yoGfpdSXcSbZj2bF1jUQWSixhyYdU2Q	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	2	2EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4
5aA49noLf1Npt4cVWT4CAKqZhSQYYpSfy64Sv3rJdenS	20955638	AqN7qN9KT3zHPqUNzRd45fhNQdgAs5sqWaLMygtmMYsj	7thU97STYodyB1N6EBod4d1ZUZaT5NioYoqddHvNr7u2	214026183	7QtMkw4NeDKyF4zTKkUjX5C4VWYqkJ97BTPpkbVGXhs7	56ENbUHD7cP4YXTjj4jfhb7tuisSh74Aup5ZauHZZLZ9	Cz2XEzxJLhm6GFPF8Jvgt8pYptAgn5tqdzHUrZr1BNqt	214026183-5DeBjCdnvvo69CmrkzueNyWTJJPNWSqeoFry2nBkNcqXipKS3mS56DQUYgabGuvVgUx6hYJhrZkHN5sqwHDJ3k1P-1-7	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5DeBjCdnvvo69CmrkzueNyWTJJPNWSqeoFry2nBkNcqXipKS3mS56DQUYgabGuvVgUx6hYJhrZkHN5sqwHDJ3k1P	2023-08-27T23:00:45.000Z	6e7bx4vnKr7hsGDscgC7hTL1SWxgwffLVUPpXrxHQLXW	Swap	D4gReMNn1RQfFCYtLKrKmXTBJqSuKSjUS6AGpZwtn6p6	2wT8Yq49kHgDzXuPxZSaeLaH1qbmGXtEyPy64bL7aD3c	7	9Ru2ENpz8wdXsBYyL7kxxnxSrhCs71BmU9ovJLKFiwt5	44	H6ARHf6YXhGYeQfUzQNGk6rDNnLBQKrenN712K4AQJEG	[]	2EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4	EPBJUVCmzvwkGPGcEuwKmXomfGt78Aozy6pj44x9xxDB	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	1	2EZ4WPhwqD16eheWJ9QeeCnWtMrUrxnCpkFF6vNkHYN4

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Swap_instruction

SwapV2_Swap_instruction

​Tables

​Swap_instruction

​SwapV2_Swap_instruction

Tables

Swap_instruction

SwapV2_Swap_instruction