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.
account_xSTRINGToken mint address for the first token in the swap pair (x-axis). Base58-encoded Solana public key representing the SPL token being exchanged.
account_ySTRINGSolana 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.
ownerSTRINGAccount that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
program_authoritySTRINGProgram-derived address (PDA) with authority to execute protocol operations. 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.
stateSTRINGAccount address of the protocol state configuration. Base58-encoded Solana public key.
tickmapSTRINGAccount 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_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
by_amount_inBOOLIndicates 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_limitBIGNUMERICPrice 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_yBOOLDirection indicator for token swap within a liquidity pool. True represents swapping from token X to token Y, false represents swapping from token Y to token X.
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
poolownerstateamountx_to_ytickmapaccount_xaccount_yreserve_xreserve_yblock_slotby_amount_insurrogate_keytoken_programtransaction_idblock_timestampinstruction_typesqrt_price_limitexecuting_accountinstruction_indexprogram_authoritytransaction_indexremaining_accountstransaction_signerouter_executing_accountouter_instruction_index
6rvpVhL9fxm2WLMefNRaLwv6aNdivZadMi56teWfSkuUGK9QHeWnAmyZkAZnWbzbzp6kEHT5eJKgKPkn2JyvpVnF8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1566227397false6te341EkeDvjs9xcPyZALYFKGLSBXD2Ski7SPTGcdvpvEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vSo111111111111111111111111111111111111111124BLZwoLcw3KvGYMUnZ5HUZarBJATZSTMunEqSX4caSHh9QK8NqHtGpgcfDzRz74TQvevLq17xsNGec9iezUrQ8sW128163273true128163273-3FvVmjatU6mKckxZjKxLrukaMQC91HzYQSpwRP3oPAHG63C8QXo6UwodYEow4G1VC5viQgMrdaQGhjM6rh9HuLWh-22VPZNvTkrQxvCxS2P9GvYWNj9VyE2tTct7P1R1ef3eKq3FvVmjatU6mKckxZjKxLrukaMQC91HzYQSpwRP3oPAHG63C8QXo6UwodYEow4G1VC5viQgMrdaQGhjM6rh9HuLWh2022-04-04T10:26:59.000ZSwap3.40282366920938463463374607431768211455e+38HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt2f6nwMTRpKTCVmRhGUbjfJPEBeXaaDUCvUUQh1941e4a63[“J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“GQC4L77dBAHaWAgJFi7zAq8tBps5SwVq5iS9tySt4BY5”,“9mo3MNDui6cyd8ZayALiJNAn8yuSLnUUpz2u8JPkFnD2”]2VPZNvTkrQxvCxS2P9GvYWNj9VyE2tTct7P1R1ef3eKq
6rvpVhL9fxm2WLMefNRaLwv6aNdivZadMi56teWfSkuUGK9QHeWnAmyZkAZnWbzbzp6kEHT5eJKgKPkn2JyvpVnF8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW1164049235false6te341EkeDvjs9xcPyZALYFKGLSBXD2Ski7SPTGcdvpvEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vSo11111111111111111111111111111111111111112AuGrSyrHeKKn4GpwoYVoJBRR2MfPjqkdQS8YMd1degsF2jp3pCUj5ofFm4E7rQwE2rTd6qPupN71ES3FEwYcD3t7128183722true128183722-2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN-2EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN2022-04-04T13:32:59.000ZSwap3.182989029107812803651915e+24HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt2f6nwMTRpKTCVmRhGUbjfJPEBeXaaDUCvUUQh1941e4a96[“J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“9mo3MNDui6cyd8ZayALiJNAn8yuSLnUUpz2u8JPkFnD2”,“FqCYTAZuTk8AvC8KDNFrNHvUVgBh3t1Brph4rKGpBmQL”,“J2KvnYp8pv1Bdz7YhGgqB1gd1SNqBvgK4mATvezHK5Uf”,“4gS59D4RKCU8b2SE4gzj7qBLPxFGkT8PL2PmqLa6APzk”,“2UbconhVhQztAMxyTPUEctV3PQKesETeSkmd6SHwnYHd”,“9KEqBXFmeDwFyGozah9FP4n8mS7Uw18VXkdZNPc8TCS7”,“5UksHgoW4iLCf4AScr5DFUMsMWfSyTi9eRz72ud9cFpR”,“EC2aQPBVpo5jygTgTVnPQLAQGuRrkRXbWJApsg28doJ3”,“GQC4L77dBAHaWAgJFi7zAq8tBps5SwVq5iS9tySt4BY5”]EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz
6rvpVhL9fxm2WLMefNRaLwv6aNdivZadMi56teWfSkuUGK9QHeWnAmyZkAZnWbzbzp6kEHT5eJKgKPkn2JyvpVnF8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW13424410false6te341EkeDvjs9xcPyZALYFKGLSBXD2Ski7SPTGcdvpvEPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vSo11111111111111111111111111111111111111112AuGrSyrHeKKn4GpwoYVoJBRR2MfPjqkdQS8YMd1degsF2jp3pCUj5ofFm4E7rQwE2rTd6qPupN71ES3FEwYcD3t7128183722true128183722-2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN-0EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz2PNcjnRxkwd9ddAAcJ292Ye32vqBsr43rWTyb7nv58m8uX5vBQ3wJS8GUeJoWtHjdzASdiBoParF5dtLtAUGraKN2022-04-04T13:32:59.000ZSwap3.182989029107812803651915e+24HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt0f6nwMTRpKTCVmRhGUbjfJPEBeXaaDUCvUUQh1941e4a96[“J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt”,“TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA”,“9mo3MNDui6cyd8ZayALiJNAn8yuSLnUUpz2u8JPkFnD2”,“FqCYTAZuTk8AvC8KDNFrNHvUVgBh3t1Brph4rKGpBmQL”,“J2KvnYp8pv1Bdz7YhGgqB1gd1SNqBvgK4mATvezHK5Uf”,“4gS59D4RKCU8b2SE4gzj7qBLPxFGkT8PL2PmqLa6APzk”,“2UbconhVhQztAMxyTPUEctV3PQKesETeSkmd6SHwnYHd”,“9KEqBXFmeDwFyGozah9FP4n8mS7Uw18VXkdZNPc8TCS7”,“5UksHgoW4iLCf4AScr5DFUMsMWfSyTi9eRz72ud9cFpR”,“EC2aQPBVpo5jygTgTVnPQLAQGuRrkRXbWJApsg28doJ3”,“GQC4L77dBAHaWAgJFi7zAq8tBps5SwVq5iS9tySt4BY5”]EcaLjGRA6htZocBGh6PNatcMWvUNMn27Jb1Qp5yeceGz
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.
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.
account_xSTRINGSolana 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_ySTRINGToken account address receiving or providing the Y-side asset in the swap transaction. Base58-encoded Solana account identifier used to track liquidity pool reserves.
ownerSTRINGAccount that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
poolSTRINGAccount address of the liquidity pool where the swap occurs. Base58-encoded Solana public key.
program_authoritySTRINGProgram-derived address (PDA) with authority to execute protocol operations. 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.
stateSTRINGAccount address of the protocol state configuration. Base58-encoded Solana public key.
tickmapSTRINGSolana 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_programSTRINGProgram address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program.
amountBIGNUMERICQuantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token.
by_amount_inBOOLIndicates 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_limitBIGNUMERICPrice 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_yBOOLDirection indicator for token swap within a liquidity pool. True represents swapping from token X to token Y, false represents swapping from token Y to token X.
remaining_accountsJSONAdditional accounts required by the instruction beyond the defined schema. JSON array of Base58-encoded Solana public keys representing accounts needed for program execution.
poolownerstateamountx_to_ytickmapaccount_xaccount_yreserve_xreserve_yblock_slotby_amount_insurrogate_keytoken_programtransaction_idblock_timestampinstruction_typesqrt_price_limitexecuting_accountinstruction_indexprogram_authoritytransaction_indexremaining_accountstransaction_signerouter_executing_accountouter_instruction_index
4XVJ5mZB2h5fmcMJYasc6QReQQTNhJCQpevwA666diwN5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW117777776trueHVeA2ErTyzvdFakcEhRGLV885cHpKY1ivqvHbdykGZxg939jztRTMiNbu13uo7zxbtXeEMBja9CLtNYjxu49Y5or2CT8Le1U95k7FZukXpL1xLrHVQQeywV8gWUWVzLyUPUiM65gn8YMeZK2S1cwMaovpmh3qFiTWvXaFYVnnMcJvhSHakg2KBvmHuYizxCbpZTitYrUde639wQxiFzvAb843qE227788164true227788164-UAckZeiSR6fRdWSdNk2uvswy1PQ1qHNT8Qqd4psfQmaDh3sQRL22yuVJZwDvNUa6uGiZgHzzVYLrj8xc9JgXSQM-2-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAUAckZeiSR6fRdWSdNk2uvswy1PQ1qHNT8Qqd4psfQmaDh3sQRL22yuVJZwDvNUa6uGiZgHzzVYLrj8xc9JgXSQM2023-11-03T18:31:36.000ZSwap15258932000000000000HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt0J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt19[]5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLwJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB2
4XVJ5mZB2h5fmcMJYasc6QReQQTNhJCQpevwA666diwN5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW117777776trueHVeA2ErTyzvdFakcEhRGLV885cHpKY1ivqvHbdykGZxg939jztRTMiNbu13uo7zxbtXeEMBja9CLtNYjxu49Y5or2CT8Le1U95k7FZukXpL1xLrHVQQeywV8gWUWVzLyUPUiM65gn8YMeZK2S1cwMaovpmh3qFiTWvXaFYVnnMcJvhSHakg2KBvmHuYizxCbpZTitYrUde639wQxiFzvAb843qE227813733true227813733-A2uKBWuGTeRoGdJT8MkjFZxA9pBaHbt42R84pGbH5wqYsQVvYfNnCREpmERWuk3jPZNsJhUs4uNrTfsoD5dWfiW-2-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DAA2uKBWuGTeRoGdJT8MkjFZxA9pBaHbt42R84pGbH5wqYsQVvYfNnCREpmERWuk3jPZNsJhUs4uNrTfsoD5dWfiW2023-11-03T21:30:34.000ZSwap15258932000000000000HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt0J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt56[]5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLwJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB2
4XVJ5mZB2h5fmcMJYasc6QReQQTNhJCQpevwA666diwN5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLw8NsPwRFYqob3FzYvHYTjFK6WVFJADFN8Hn7yNQKcVNW18888888trueHVeA2ErTyzvdFakcEhRGLV885cHpKY1ivqvHbdykGZxg939jztRTMiNbu13uo7zxbtXeEMBja9CLtNYjxu49Y5or2CT8Le1U95k7FZukXpL1xLrHVQQeywV8gWUWVzLyUPUiM65gn8YMeZK2S1cwMaovpmh3qFiTWvXaFYVnnMcJvhSHakg2KBvmHuYizxCbpZTitYrUde639wQxiFzvAb843qE227792013true227792013-4ZVvC2FfzAecGKnKUPcdwogv37yGvCQ6Dpe8me8JLMm1jBmdLApC5u7GkCkBjQSHRhXyRqi4Pz5AShbgVNRaGgNV-2-0TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA4ZVvC2FfzAecGKnKUPcdwogv37yGvCQ6Dpe8me8JLMm1jBmdLApC5u7GkCkBjQSHRhXyRqi4Pz5AShbgVNRaGgNV2023-11-03T18:58:42.000ZSwap15258932000000000000HyaB3W9q6XdA5xwpU4XnSZV94htfmbmqJXZcEbRaJutt0J4uBbeoWpZE8fH58PM1Fp9n9K6f1aThyeVCyRdJbaXqt8[]5nM1CTQwKXFZo5yJYC8J1pgj32JW6Fx8DpQAtPZ8aiLwJUP4Fb2cqiRUcaTHdrPC8h2gNsA2ETXiPDD33WcGuJB2
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