invariant_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.
`account_x`	`STRING`	Token mint address for the first token in the swap pair (x-axis). Base58-encoded Solana public key representing the SPL token being exchanged.
`account_y`	`STRING`	Solana address of the second token in the swap pair (Y token). Always paired with account_x to define the trading pair for this Invariant protocol swap.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`program_authority`	`STRING`	Program-derived address (PDA) with authority to execute protocol operations. Base58-encoded Solana public key.
`reserve_x`	`STRING`	Account address holding the pool’s reserve of token X. Base58-encoded Solana public key.
`reserve_y`	`STRING`	Account address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
`state`	`STRING`	Account address of the protocol state configuration. Base58-encoded Solana public key.
`tickmap`	`STRING`	Account address storing the bitmap structure that tracks active price ticks in the Invariant concentrated liquidity pool. Used for efficient price range discovery during swaps.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`by_amount_in`	`BOOL`	Indicates whether the swap specifies an exact input amount (true) or exact output amount (false). Determines how the protocol calculates the opposite side of the trade.
`sqrt_price_limit`	`BIGNUMERIC`	Price boundary for the swap execution expressed as square root of the price ratio. Controls slippage protection by halting the swap if the pool price reaches this limit.
`x_to_y`	`BOOL`	Direction indicator for token swap within a liquidity pool. True represents swapping from token X to token Y, false represents swapping from token Y to token X.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	owner	state	amount	x_to_y	tickmap	account_x	account_y	reserve_x	reserve_y	block_slot	by_amount_in	surrogate_key	token_program	transaction_id	block_timestamp	instruction_type	sqrt_price_limit	executing_account	instruction_index	program_authority	transaction_index	remaining_accounts	transaction_signer
6rvpVhL9fxm2WLMefNRaLwv6aNdivZadMi56teWfSkuU	GK9QHeWnAmyZkAZnWbzbzp6kEHT5eJKgKPkn2JyvpVnF	8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1	566227397	false	6te341EkeDvjs9xcPyZALYFKGLSBXD2Ski7SPTGcdvpv	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	So11111111111111111111111111111111111111112	4BLZwoLcw3KvGYMUnZ5HUZarBJATZSTMunEqSX4caSHh	9QK8NqHtGpgcfDzRz74TQvevLq17xsNGec9iezUrQ8sW	128163273	true	128163273-3FvVmjatU6mKckxZjKxLrukaMQC91HzYQSpwRP3oPAHG63C8QXo6UwodYEow4G1VC5viQgMrdaQGhjM6rh9HuLWh-2	2VPZNvTkrQxvCxS2P9GvYWNj9VyE2tTct7P1R1ef3eKq	3FvVmjatU6mKckxZjKxLrukaMQC91HzYQSpwRP3oPAHG63C8QXo6UwodYEow4G1VC5viQgMrdaQGhjM6rh9HuLWh	2022-04-04T10:26:59.000Z	Swap	3.40282366920938463463374607431768211455e+38	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	2	f6nwMTRpKTCVmRhGUbjfJPEBeXaaDUCvUUQh1941e4a	63	[“J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“GQC4L77dBAHaWAgJFi7zAq8tBps5SwVq5iS9tySt4BY5”,“9mo3MNDui6cyd8ZayALiJNAn8yuSLnUUpz2u8JPkFnD2”]	2VPZNvTkrQxvCxS2P9GvYWNj9VyE2tTct7P1R1ef3eKq
6rvpVhL9fxm2WLMefNRaLwv6aNdivZadMi56teWfSkuU	GK9QHeWnAmyZkAZnWbzbzp6kEHT5eJKgKPkn2JyvpVnF	8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1	164049235	false	6te341EkeDvjs9xcPyZALYFKGLSBXD2Ski7SPTGcdvpv	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	So11111111111111111111111111111111111111112	AuGrSyrHeKKn4GpwoYVoJBRR2MfPjqkdQS8YMd1degsF	2jp3pCUj5ofFm4E7rQwE2rTd6qPupN71ES3FEwYcD3t7	128183722	true	128183722-2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN-2	EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz	2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN	2022-04-04T13:32:59.000Z	Swap	3.182989029107812803651915e+24	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	2	f6nwMTRpKTCVmRhGUbjfJPEBeXaaDUCvUUQh1941e4a	96	[“J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“9mo3MNDui6cyd8ZayALiJNAn8yuSLnUUpz2u8JPkFnD2”,“FqCYTAZuTk8AvC8KDNFrNHvUVgBh3t1Brph4rKGpBmQL”,“J2KvnYp8pv1Bdz7YhGgqB1gd1SNqBvgK4mATvezHK5Uf”,“4gS59D4RKCU8b2SE4gzj7qBLPxFGkT8PL2PmqLa6APzk”,“2UbconhVhQztAMxyTPUEctV3PQKesETeSkmd6SHwnYHd”,“9KEqBXFmeDwFyGozah9FP4n8mS7Uw18VXkdZNPc8TCS7”,“5UksHgoW4iLCf4AScr5DFUMsMWfSyTi9eRz72ud9cFpR”,“EC2aQPBVpo5jygTgTVnPQLAQGuRrkRXbWJApsg28doJ3”,“GQC4L77dBAHaWAgJFi7zAq8tBps5SwVq5iS9tySt4BY5”]	EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz
6rvpVhL9fxm2WLMefNRaLwv6aNdivZadMi56teWfSkuU	GK9QHeWnAmyZkAZnWbzbzp6kEHT5eJKgKPkn2JyvpVnF	8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1	3424410	false	6te341EkeDvjs9xcPyZALYFKGLSBXD2Ski7SPTGcdvpv	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	So11111111111111111111111111111111111111112	AuGrSyrHeKKn4GpwoYVoJBRR2MfPjqkdQS8YMd1degsF	2jp3pCUj5ofFm4E7rQwE2rTd6qPupN71ES3FEwYcD3t7	128183722	true	128183722-2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN-0	EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz	2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN	2022-04-04T13:32:59.000Z	Swap	3.182989029107812803651915e+24	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	0	f6nwMTRpKTCVmRhGUbjfJPEBeXaaDUCvUUQh1941e4a	96	[“J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“9mo3MNDui6cyd8ZayALiJNAn8yuSLnUUpz2u8JPkFnD2”,“FqCYTAZuTk8AvC8KDNFrNHvUVgBh3t1Brph4rKGpBmQL”,“J2KvnYp8pv1Bdz7YhGgqB1gd1SNqBvgK4mATvezHK5Uf”,“4gS59D4RKCU8b2SE4gzj7qBLPxFGkT8PL2PmqLa6APzk”,“2UbconhVhQztAMxyTPUEctV3PQKesETeSkmd6SHwnYHd”,“9KEqBXFmeDwFyGozah9FP4n8mS7Uw18VXkdZNPc8TCS7”,“5UksHgoW4iLCf4AScr5DFUMsMWfSyTi9eRz72ud9cFpR”,“EC2aQPBVpo5jygTgTVnPQLAQGuRrkRXbWJApsg28doJ3”,“GQC4L77dBAHaWAgJFi7zAq8tBps5SwVq5iS9tySt4BY5”]	EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz

Example Query

Query with partition filter

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

Swap_Swap_instruction

Swap instruction records from Invariant decentralized exchange (DEX) protocol on Solana. Contains trade execution details including pool identifiers, swap direction, token amounts, and price limits for analyzing concentrated liquidity market activity.

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.
`account_x`	`STRING`	Solana account address holding the first token (X) in the trading pair for this swap instruction. Base58-encoded public key representing the user’s token account from which tokens are debited or credited.
`account_y`	`STRING`	Token account address receiving or providing the Y-side asset in the swap transaction. Base58-encoded Solana account identifier used to track liquidity pool reserves.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`pool`	`STRING`	Account address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
`program_authority`	`STRING`	Program-derived address (PDA) with authority to execute protocol operations. Base58-encoded Solana public key.
`reserve_x`	`STRING`	Account address holding the pool’s reserve of token X. Base58-encoded Solana public key.
`reserve_y`	`STRING`	Account address holding the pool’s reserve of token Y. Base58-encoded Solana public key.
`state`	`STRING`	Account address of the protocol state configuration. Base58-encoded Solana public key.
`tickmap`	`STRING`	Solana account address for the tick bitmap used by the Invariant AMM pool to track liquidity distribution. Essential for determining available price ranges during swap execution.
`token_program`	`STRING`	Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
`amount`	`BIGNUMERIC`	Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
`by_amount_in`	`BOOL`	Indicates whether the swap specifies an exact input amount (true) or exact output amount (false). Determines how the swap calculates the trade: fixed input with variable output or fixed output with variable input.
`sqrt_price_limit`	`BIGNUMERIC`	Price boundary for concentrated liquidity pool swap, expressed as square root of price ratio scaled by 10^18. Acts as slippage protection by halting execution if pool price moves beyond this threshold.
`x_to_y`	`BOOL`	Direction indicator for token swap within a liquidity pool. True represents swapping from token X to token Y, false represents swapping from token Y to token X.
`remaining_accounts`	`JSON`	Additional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.

Sample Data

pool	owner	state	amount	x_to_y	tickmap	account_x	account_y	reserve_x	reserve_y	block_slot	by_amount_in	surrogate_key	token_program	transaction_id	block_timestamp	instruction_type	sqrt_price_limit	executing_account	program_authority	transaction_index	remaining_accounts	transaction_signer	outer_executing_account	outer_instruction_index
4XVJ5mZB2h5fmcMJYasc6QReQQTNhJCQpevwA666diwN	5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw	8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1	17777776	true	HVeA2ErTyzvdFakcEhRGLV885cHpKY1ivqvHbdykGZxg	939jztRTMiNbu13uo7zxbtXeEMBja9CLtNYjxu49Y5or	2CT8Le1U95k7FZukXpL1xLrHVQQeywV8gWUWVzLyUPUi	M65gn8YMeZK2S1cwMaovpmh3qFiTWvXaFYVnnMcJvhS	Hakg2KBvmHuYizxCbpZTitYrUde639wQxiFzvAb843qE	227788164	true	227788164-UAckZeiSR6fRdWSdNk2uvswy1PQ1qHNT8Qqd4psfQmaDh3sQRL22yuVJZwDvNUa6uGiZgHzzVYLrj8xc9JgXSQM-2-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	UAckZeiSR6fRdWSdNk2uvswy1PQ1qHNT8Qqd4psfQmaDh3sQRL22yuVJZwDvNUa6uGiZgHzzVYLrj8xc9JgXSQM	2023-11-03T18:31:36.000Z	Swap	15258932000000000000	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt	19	[]	5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	2
4XVJ5mZB2h5fmcMJYasc6QReQQTNhJCQpevwA666diwN	5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw	8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1	17777776	true	HVeA2ErTyzvdFakcEhRGLV885cHpKY1ivqvHbdykGZxg	939jztRTMiNbu13uo7zxbtXeEMBja9CLtNYjxu49Y5or	2CT8Le1U95k7FZukXpL1xLrHVQQeywV8gWUWVzLyUPUi	M65gn8YMeZK2S1cwMaovpmh3qFiTWvXaFYVnnMcJvhS	Hakg2KBvmHuYizxCbpZTitYrUde639wQxiFzvAb843qE	227813733	true	227813733-A2uKBWuGTeRoGdJT8MkjFZxA9pBaHbt42R84pGbH5wqYsQVvYfNnCREpmERWuk3jPZNsJhUs4uNrTfsoD5dWfiW-2-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	A2uKBWuGTeRoGdJT8MkjFZxA9pBaHbt42R84pGbH5wqYsQVvYfNnCREpmERWuk3jPZNsJhUs4uNrTfsoD5dWfiW	2023-11-03T21:30:34.000Z	Swap	15258932000000000000	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt	56	[]	5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	2
4XVJ5mZB2h5fmcMJYasc6QReQQTNhJCQpevwA666diwN	5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw	8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1	8888888	true	HVeA2ErTyzvdFakcEhRGLV885cHpKY1ivqvHbdykGZxg	939jztRTMiNbu13uo7zxbtXeEMBja9CLtNYjxu49Y5or	2CT8Le1U95k7FZukXpL1xLrHVQQeywV8gWUWVzLyUPUi	M65gn8YMeZK2S1cwMaovpmh3qFiTWvXaFYVnnMcJvhS	Hakg2KBvmHuYizxCbpZTitYrUde639wQxiFzvAb843qE	227792013	true	227792013-4ZVvC2FfzAecGKnKUPcdwogv37yGvCQ6Dpe8me8JLMm1jBmdLApC5u7GkCkBjQSHRhXyRqi4Pz5AShbgVNRaGgNV-2-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	4ZVvC2FfzAecGKnKUPcdwogv37yGvCQ6Dpe8me8JLMm1jBmdLApC5u7GkCkBjQSHRhXyRqi4Pz5AShbgVNRaGgNV	2023-11-03T18:58:42.000Z	Swap	15258932000000000000	HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt	J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt	8	[]	5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw	JUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB	2

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Swap_instruction

Swap_Swap_instruction

​Tables

​Swap_instruction

​Swap_Swap_instruction

Tables

Swap_instruction

Swap_Swap_instruction