> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# byreal_v1_solana
> Tables in tt-contracts.byreal_v1_solana
## Tables
### CLMM\_Swap\_instruction
Swap instruction records from ByReal CLMM (Concentrated Liquidity Market Maker) pools on Solana. Tracks token swaps with amounts, prices, vaults, and tick arrays for analyzing DEX trading patterns and liquidity utilization.
| 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_config` | `STRING` | Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key. |
| `input_token_account` | `STRING` | Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key. |
| `input_vault` | `STRING` | Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `observation_state` | `STRING` | Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key. |
| `output_token_account` | `STRING` | Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key. |
| `output_vault` | `STRING` | Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `payer` | `STRING` | Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key. |
| `pool_state` | `STRING` | Account address representing the liquidity pool state. Base58-encoded Solana public key. |
| `tick_array` | `STRING` | Account address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key. |
| `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. |
| `is_base_input` | `BOOL` | Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool's trading pair. |
| `other_amount_threshold` | `BIGNUMERIC` | Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token. |
| `sqrt_price_limit_x64` | `BIGNUMERIC` | Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format). |
| `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. |
| payer | amount | amm\_config | block\_slot | pool\_state | tick\_array | input\_vault | output\_vault | is\_base\_input | surrogate\_key | token\_program | transaction\_id | block\_timestamp | instruction\_type | executing\_account | instruction\_index | observation\_state | transaction\_index | remaining\_accounts | transaction\_signer | input\_token\_account | output\_token\_account | sqrt\_price\_limit\_x64 | other\_amount\_threshold | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ------------ | ------------------------------------------- | ----------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | --------------- | ------------------------------------------------------------------------------------------------------ | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ----------------- | ------------------------------------------- | ------------------ | -------------------------------------------- | ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ----------------------- | ------------------------ | ------------------------------------------- | ------------------------- |
| FATEorZGqsxg11TmJVRdX5WZ12bQpdS2Va9L7iHWzcHr | 218013951014 | veWyQnnZP5rJgVkif5zL5hvuxFTZMcJVoVEo3ri8ZKA | 372214765 | BmB6JgMnmxMBpmBnyoXi8REjJnZuzcaJ9m8e8QSCG1a3 | HG21mHF4EadJ6WzJ89emijNWj4nH8mB6AotPh4oMATSo | 2jN4cLEniux5k6ZFK32GVnR96nibhzSU6CvZbcT6xkqZ | 7CrxxzxRGBJxSHg233LTpSqm4G2xXNzdM7DRenCAG1bc | true | 372214765-36muC2bshABFE28n4XmyJ7c273paTjobjHgs6iSvq1Xb758K9TMS6M4dFSVwmsQLSv6UQYvoECkhEceEHrKgZZep-0-3 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 36muC2bshABFE28n4XmyJ7c273paTjobjHgs6iSvq1Xb758K9TMS6M4dFSVwmsQLSv6UQYvoECkhEceEHrKgZZep | 2025-10-09T11:15:43.000Z | Swap | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 3 | 4ywZjpidXVDKF1Ta1d3ud4RbmgjxDrW6a4Xh7KHbRLib | 0 | \["2nGwN5TwxJPkuEj5PeW6FYnzNeEsD68f5TtEAbwkLJDi","fbqZmD6C8FvzsGwZkHhDbSFtyx6fEHqQkZor6amDLnw","GSZQ3Y4MmyubTugqsm8pimsQ2PBryXKoXEfDGJszEG3f","8izExcyaGqXMZavW2KkcTi39AMDWzZYR9CsbQbmV3Frg"] | FATEorZGqsxg11TmJVRdX5WZ12bQpdS2Va9L7iHWzcHr | DUiFkisdnLYV7QPrs75oi3DHwYtuqHgfACCiQ431fPFx | 827XwBZ5XW9avTevtZq2aJrGZsytTZUzLzGPBzC5FmCs | 0 | 0 | SAbErai3UvzycbkooTMoQkD3Y7JVr5aEf7tEHBW1AWf | 0 |
| FATEorZGqsxg11TmJVRdX5WZ12bQpdS2Va9L7iHWzcHr | 234905859256 | veWyQnnZP5rJgVkif5zL5hvuxFTZMcJVoVEo3ri8ZKA | 372214760 | BmB6JgMnmxMBpmBnyoXi8REjJnZuzcaJ9m8e8QSCG1a3 | HG21mHF4EadJ6WzJ89emijNWj4nH8mB6AotPh4oMATSo | 2jN4cLEniux5k6ZFK32GVnR96nibhzSU6CvZbcT6xkqZ | 7CrxxzxRGBJxSHg233LTpSqm4G2xXNzdM7DRenCAG1bc | true | 372214760-5mwPe5A2krUmxaeydj3soPuXwg41DZGG95DPBr3QdeLpwJzcgPF175fK675bjQhUqWo8yDz8AUFM5nPsrAYbxMLQ-0-3 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 5mwPe5A2krUmxaeydj3soPuXwg41DZGG95DPBr3QdeLpwJzcgPF175fK675bjQhUqWo8yDz8AUFM5nPsrAYbxMLQ | 2025-10-09T11:15:42.000Z | Swap | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 3 | 4ywZjpidXVDKF1Ta1d3ud4RbmgjxDrW6a4Xh7KHbRLib | 129 | \["2nGwN5TwxJPkuEj5PeW6FYnzNeEsD68f5TtEAbwkLJDi","fbqZmD6C8FvzsGwZkHhDbSFtyx6fEHqQkZor6amDLnw","GSZQ3Y4MmyubTugqsm8pimsQ2PBryXKoXEfDGJszEG3f","8izExcyaGqXMZavW2KkcTi39AMDWzZYR9CsbQbmV3Frg"] | FATEorZGqsxg11TmJVRdX5WZ12bQpdS2Va9L7iHWzcHr | DUiFkisdnLYV7QPrs75oi3DHwYtuqHgfACCiQ431fPFx | 827XwBZ5XW9avTevtZq2aJrGZsytTZUzLzGPBzC5FmCs | 0 | 0 | SAbErai3UvzycbkooTMoQkD3Y7JVr5aEf7tEHBW1AWf | 0 |
| ATQs6A92eUzdxTBsQhRJxxJDpgYDTGvLnU4e5mMEfY3k | 33564657 | veWyQnnZP5rJgVkif5zL5hvuxFTZMcJVoVEo3ri8ZKA | 372194408 | 3DbStN7JQ7XJJDNhSk8c7NPX2WX5qMtUFFqudjaFjuSU | 82Wj4QAjPGxVV7JTpAwxgFYfG5RoWxz5zXgr9YTFBPjJ | 7c19MGtKYYSocv9yegiZZX17q2Vpdn7PppEnUZFxqcPm | 4aPHYfdkhP7Z1FZYxAZrbLyeXBaqWAPLF79zCCzDdR2b | true | 372194408-5NyfddK8hVCVBNj2tRncv2NkUbTniJCk7CupR49HrUykHzRwKvYJK3asZv1UzVfrKTC3X96XJsZeA25gEokRnBrc-1-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 5NyfddK8hVCVBNj2tRncv2NkUbTniJCk7CupR49HrUykHzRwKvYJK3asZv1UzVfrKTC3X96XJsZeA25gEokRnBrc | 2025-10-09T09:01:11.000Z | Swap | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | G92z7cjgptsFjM8Fou8bPuhYG6VXUWBzb6fhGSgSL94c | 303 | \["2ntBsyD6oEgJpdeNttjLCe9o7x5fM7KdES2cVgLizTNT","4HZ9XegxDZ74bDaezoYazu2uWKhaP33JDq4tPY8AFHUF"] | ATQs6A92eUzdxTBsQhRJxxJDpgYDTGvLnU4e5mMEfY3k | EUWdBPVb39PTbMJZbRoR1LSa138JjqoYThVdUdSPchSV | 146bEK8ChWaoMxcG5eY5hUxJTC7idUmnwqCftVYdK8f5 | 0 | 0 | JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4 | 1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.byreal_v1_solana.CLMM_Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CLMM\_SwapV2\_instruction
Concentrated Liquidity Market Maker (CLMM) swap instruction records from the Byreal protocol on Solana. Contains token swap details including amounts, vaults, price limits, and swap direction for analyzing DEX trading patterns and liquidity pool interactions.
| 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_config` | `STRING` | Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key. |
| `input_token_account` | `STRING` | Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key. |
| `input_vault` | `STRING` | Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `input_vault_mint` | `STRING` | Token mint address for the input vault. Base58-encoded Solana public key. |
| `memo_program` | `STRING` | Program address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key. |
| `observation_state` | `STRING` | Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key. |
| `output_token_account` | `STRING` | Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key. |
| `output_vault` | `STRING` | Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `output_vault_mint` | `STRING` | Token mint address for the output vault. Base58-encoded Solana public key. |
| `payer` | `STRING` | Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key. |
| `pool_state` | `STRING` | Account address representing the liquidity pool state. Base58-encoded Solana public key. |
| `token_program` | `STRING` | Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program. |
| `token_program_2022` | `STRING` | Program address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program. |
| `amount` | `BIGNUMERIC` | Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token. |
| `is_base_input` | `BOOL` | Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool's trading pair. |
| `other_amount_threshold` | `BIGNUMERIC` | Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token. |
| `sqrt_price_limit_x64` | `BIGNUMERIC` | Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format). |
| `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. |
| payer | amount | amm\_config | block\_slot | pool\_state | input\_vault | memo\_program | output\_vault | is\_base\_input | surrogate\_key | token\_program | transaction\_id | block\_timestamp | input\_vault\_mint | instruction\_type | executing\_account | instruction\_index | observation\_state | output\_vault\_mint | transaction\_index | remaining\_accounts | token\_program\_2022 | transaction\_signer | input\_token\_account | output\_token\_account | sqrt\_price\_limit\_x64 | other\_amount\_threshold | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | -------- | -------------------------------------------- | ----------- | -------------------------------------------- | -------------------------------------------- | ------------------------------------------- | -------------------------------------------- | --------------- | ------------------------------------------------------------------------------------------------------ | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | -------------------------------------------- | -------------------------------------------- | ------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ----------------------- | ------------------------ | -------------------------------------------- | ------------------------- |
| 9FZV5bmxdAbChYv4vW6xaAnqUnVQ3452SCyVnfJAHUVE | 50351470 | 96FHuHDcv9FL55qhoBoUGAmxZg9XM47fBM3t2vdefGW2 | 357696542 | 23XoPQqGw9WMsLoqTu8HMzJLD6RnXsufbKyWPLJywsCT | 6nMF76wKdFZaE78eRRDcNikVw1jMKMC4zoj7ibq1N25f | MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr | J9WJF4NbJwio4DiKiTGsb7uDnxbruWjEVkj7M6bLhCRa | true | 357696542-37arjoDgqoqJgHGdb1kffKdovoHfPvCtdQcbG7pwscCVqfcwarT5DVGVgj2HKE9uvrocTYN6JWhwMLV4KkCNtNAY-3-3 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 37arjoDgqoqJgHGdb1kffKdovoHfPvCtdQcbG7pwscCVqfcwarT5DVGVgj2HKE9uvrocTYN6JWhwMLV4KkCNtNAY | 2025-08-03T23:26:13.000Z | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | SwapV2 | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 3 | EWXF1h46ahk9i4c768wRCxxWjR7eEDs3PAvFwms95hqf | Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB | 209 | \["AsotAq6Hb5KW6bAExHq2hJctDNuErLEjaVSaR4yJ5WEj","DbRjFtYNCvPCs7YSk3Cs1feaRfxe2HuCZnpUYEjmR3nQ","AkNBHzK3gMxPo74pu4xvk3YNRZfpam643ScskE4w6fNN","GDqetVZ6WdDYJb7edydzqg53CtDWnqQZVSAM8FxeRnvC"] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | 9FZV5bmxdAbChYv4vW6xaAnqUnVQ3452SCyVnfJAHUVE | EVzyfq1PRqrKs3eVBWNErNoVtB7o9YWirksLZH1uNTiv | 13BzbKUELR3KBkPsspJfpeJ86EwZriTN3QK3J8QwKG3Z | 0 | 1 | 6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma | 3 |
| 7zdn1rsyKaLPCyoUb22UuVQFHYPBy8zczCaAbwZnmZSv | 61357309 | 96FHuHDcv9FL55qhoBoUGAmxZg9XM47fBM3t2vdefGW2 | 357694943 | 23XoPQqGw9WMsLoqTu8HMzJLD6RnXsufbKyWPLJywsCT | J9WJF4NbJwio4DiKiTGsb7uDnxbruWjEVkj7M6bLhCRa | MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr | 6nMF76wKdFZaE78eRRDcNikVw1jMKMC4zoj7ibq1N25f | true | 357694943-5DtW6C3vg27GSNoabTQBepwUWHhQjj26L2U5iWb5QYsKaGC4qWSbH6DsieXcjihChZ5qbeW5q25bq4Dafm1kk8i-3-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 5DtW6C3vg27GSNoabTQBepwUWHhQjj26L2U5iWb5QYsKaGC4qWSbH6DsieXcjihChZ5qbeW5q25bq4Dafm1kk8i | 2025-08-03T23:15:32.000Z | Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB | SwapV2 | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | EWXF1h46ahk9i4c768wRCxxWjR7eEDs3PAvFwms95hqf | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | 235 | \["AsotAq6Hb5KW6bAExHq2hJctDNuErLEjaVSaR4yJ5WEj","DbRjFtYNCvPCs7YSk3Cs1feaRfxe2HuCZnpUYEjmR3nQ","5ipEofiHQt2z9EXBZZMbMLcgeD6SFRFGKfQgfo65PKCc","8vdCZ5Ks2TcgAfJjE7q9RKdBt1A9dWPM7fKQPFaC3Z3E","Gw6NM3UC8FGsQ2hyw8FzKqz1oS9XYQRWr8Na9NB68KJF"] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | 7zdn1rsyKaLPCyoUb22UuVQFHYPBy8zczCaAbwZnmZSv | F2HG8RddKQvkCvzPP3TbSEzjZabZRGVBknLxnQ2BY6vL | 23fLtFXotmPXG5EjBaHz93hWcWcxxZiUKVf1BKhy7dhN | 0 | 1 | 6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma | 3 |
| HR3BgaUaFLXYjtDDH6bPPQET3Tq5VGnftt7u7s6yBRrW | 51119387 | 96FHuHDcv9FL55qhoBoUGAmxZg9XM47fBM3t2vdefGW2 | 357696625 | 23XoPQqGw9WMsLoqTu8HMzJLD6RnXsufbKyWPLJywsCT | 6nMF76wKdFZaE78eRRDcNikVw1jMKMC4zoj7ibq1N25f | MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr | J9WJF4NbJwio4DiKiTGsb7uDnxbruWjEVkj7M6bLhCRa | true | 357696625-4xr6P1Jbh1gg7xrvLpkHjXXXcLcry97q6narfFVxUpPN2pZudVeVEos4qYgYTfuU3BpBR9ELzmJhXkA6z9u6ULXG-3-3 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 4xr6P1Jbh1gg7xrvLpkHjXXXcLcry97q6narfFVxUpPN2pZudVeVEos4qYgYTfuU3BpBR9ELzmJhXkA6z9u6ULXG | 2025-08-03T23:26:45.000Z | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | SwapV2 | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 3 | EWXF1h46ahk9i4c768wRCxxWjR7eEDs3PAvFwms95hqf | Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB | 328 | \["AsotAq6Hb5KW6bAExHq2hJctDNuErLEjaVSaR4yJ5WEj","DbRjFtYNCvPCs7YSk3Cs1feaRfxe2HuCZnpUYEjmR3nQ","AkNBHzK3gMxPo74pu4xvk3YNRZfpam643ScskE4w6fNN","GDqetVZ6WdDYJb7edydzqg53CtDWnqQZVSAM8FxeRnvC"] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | HR3BgaUaFLXYjtDDH6bPPQET3Tq5VGnftt7u7s6yBRrW | 2d9R4RxRte9UTn2uMvUuS9kfrrQbz3Vt9iZ25zGU2r8C | 24wGJTy1C5NjSAusuKBMMjBcNhvE24rzzGGEvUtmh5FT | 0 | 1 | 6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma | 3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.byreal_v1_solana.CLMM_SwapV2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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_config` | `STRING` | Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key. |
| `input_token_account` | `STRING` | Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key. |
| `input_vault` | `STRING` | Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `observation_state` | `STRING` | Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key. |
| `output_token_account` | `STRING` | Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key. |
| `output_vault` | `STRING` | Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `payer` | `STRING` | Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key. |
| `pool_state` | `STRING` | Account address representing the liquidity pool state. Base58-encoded Solana public key. |
| `tick_array` | `STRING` | Account address storing tick data for concentrated liquidity price ranges in the AMM pool. Base58-encoded Solana public key. |
| `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. |
| `is_base_input` | `BOOL` | Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool's trading pair. |
| `other_amount_threshold` | `BIGNUMERIC` | Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token. |
| `sqrt_price_limit_x64` | `BIGNUMERIC` | Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format). |
| `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. |
| payer | amount | amm\_config | block\_slot | pool\_state | tick\_array | input\_vault | output\_vault | is\_base\_input | surrogate\_key | token\_program | transaction\_id | block\_timestamp | instruction\_type | executing\_account | instruction\_index | observation\_state | transaction\_index | remaining\_accounts | transaction\_signer | input\_token\_account | output\_token\_account | sqrt\_price\_limit\_x64 | other\_amount\_threshold | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | -------- | -------------------------------------------- | ----------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | --------------- | ------------------------------------------------------------------------------------------------------ | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | ----------------- | ------------------------------------------- | ------------------ | -------------------------------------------- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | --------------------------------- | ------------------------ | ------------------------------------------- | ------------------------- |
| C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j | 40000000 | 4E6xP73xzTs4aCvY92hbXRwWkYptNwvViPZmLcZEBUk4 | 352614899 | 9GTj99g9tbz9U6UYDsX6YeRTgUnkYG6GTnHv3qLa5aXq | 7XCCPsg1HYuG1xPZ3n5BSSRM9JZU1i7RybMQ2VPitBgU | HL8turx8hJEEPVH4ivxzxwfdxVA1PH3LeYbSmh3hYfzz | 5BzogZvHNEuwstR4iwTWdd7jknFBZqJQWVjxPsDfEUD6 | true | 352614899-4NP7VYnerPUJWnGiiMCSZdfTD5wwoRCSp35aP7Qsf8XmdGxBcU9LkTKzqsyFsPCwRV85td5LpBSss9L2QvmDYsEs-0-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 4NP7VYnerPUJWnGiiMCSZdfTD5wwoRCSp35aP7Qsf8XmdGxBcU9LkTKzqsyFsPCwRV85td5LpBSss9L2QvmDYsEs | 2025-07-11T15:11:46.000Z | Swap | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | 3T6qNbQqWYDfSTew1ifsNedtoeDP8LRuCegmUH27ykEZ | 130 | \["2fXk9LK5zRWKCbeLqcYkvbTjNMSrDS8YNr8dCkHQ4jQk","J4WwSJRGqYQn8xzXN2urgewrAjEFyqFm16rhRvJt2uo5","B8SwEGYm7p8eE2okdRe68mbRRSf5hhjP5k4ixp9YUQmo","7kpU4nqpUerDw1VZjayRGrqsJjvzNtiuodsgTgJ2qakF","zmsoKEYP5amoM8zUEFn2MPMCNtPqRj1ChqYDoF4XsLz","GuDQwyNv6g6jtZg13VNcDnK9mb6q8pTj534BDehqvtzF"] | C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j | 2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF | DcJWCjqmUiYJwtmybNVPhpBzqoJrCM4Q3bVEBNuAs4YZ | 7.922667352106697925757824809e+28 | 0 | ams9tG5sJHh6ZDEuWrFZQUnoM6PGau5sMiMnomKBwui | 0 |
| C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j | 30000000 | 4E6xP73xzTs4aCvY92hbXRwWkYptNwvViPZmLcZEBUk4 | 352543150 | 9GTj99g9tbz9U6UYDsX6YeRTgUnkYG6GTnHv3qLa5aXq | 7XCCPsg1HYuG1xPZ3n5BSSRM9JZU1i7RybMQ2VPitBgU | HL8turx8hJEEPVH4ivxzxwfdxVA1PH3LeYbSmh3hYfzz | 5BzogZvHNEuwstR4iwTWdd7jknFBZqJQWVjxPsDfEUD6 | true | 352543150-5dX2ChBGDZu3Zo3UVwaxnH5Tk8VY8RJsMALvBmrGnS6JPAQTYzFwRw4m8MHQvHdEST4fK2GpicNSzKosKaHJfX3X-0-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 5dX2ChBGDZu3Zo3UVwaxnH5Tk8VY8RJsMALvBmrGnS6JPAQTYzFwRw4m8MHQvHdEST4fK2GpicNSzKosKaHJfX3X | 2025-07-11T07:18:07.000Z | Swap | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | 3T6qNbQqWYDfSTew1ifsNedtoeDP8LRuCegmUH27ykEZ | 23 | \["2fXk9LK5zRWKCbeLqcYkvbTjNMSrDS8YNr8dCkHQ4jQk","J4WwSJRGqYQn8xzXN2urgewrAjEFyqFm16rhRvJt2uo5","B8SwEGYm7p8eE2okdRe68mbRRSf5hhjP5k4ixp9YUQmo","7kpU4nqpUerDw1VZjayRGrqsJjvzNtiuodsgTgJ2qakF","zmsoKEYP5amoM8zUEFn2MPMCNtPqRj1ChqYDoF4XsLz","GuDQwyNv6g6jtZg13VNcDnK9mb6q8pTj534BDehqvtzF"] | C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j | 2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF | DcJWCjqmUiYJwtmybNVPhpBzqoJrCM4Q3bVEBNuAs4YZ | 7.922667352106697925757824809e+28 | 0 | ams9tG5sJHh6ZDEuWrFZQUnoM6PGau5sMiMnomKBwui | 0 |
| C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j | 30000000 | 4E6xP73xzTs4aCvY92hbXRwWkYptNwvViPZmLcZEBUk4 | 352614952 | 9GTj99g9tbz9U6UYDsX6YeRTgUnkYG6GTnHv3qLa5aXq | 7XCCPsg1HYuG1xPZ3n5BSSRM9JZU1i7RybMQ2VPitBgU | HL8turx8hJEEPVH4ivxzxwfdxVA1PH3LeYbSmh3hYfzz | 5BzogZvHNEuwstR4iwTWdd7jknFBZqJQWVjxPsDfEUD6 | true | 352614952-66DC9Nj92ZrhkBUddnaSYqgrAL3KhiGs8ewsxDjpVGorKXK8VmnVUUzGnzYJkvdEDfMm4VGupuREYQKLRQ4to6s3-0-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 66DC9Nj92ZrhkBUddnaSYqgrAL3KhiGs8ewsxDjpVGorKXK8VmnVUUzGnzYJkvdEDfMm4VGupuREYQKLRQ4to6s3 | 2025-07-11T15:12:07.000Z | Swap | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | 3T6qNbQqWYDfSTew1ifsNedtoeDP8LRuCegmUH27ykEZ | 34 | \["2fXk9LK5zRWKCbeLqcYkvbTjNMSrDS8YNr8dCkHQ4jQk","J4WwSJRGqYQn8xzXN2urgewrAjEFyqFm16rhRvJt2uo5","B8SwEGYm7p8eE2okdRe68mbRRSf5hhjP5k4ixp9YUQmo","7kpU4nqpUerDw1VZjayRGrqsJjvzNtiuodsgTgJ2qakF","zmsoKEYP5amoM8zUEFn2MPMCNtPqRj1ChqYDoF4XsLz","GuDQwyNv6g6jtZg13VNcDnK9mb6q8pTj534BDehqvtzF"] | C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j | 2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF | DcJWCjqmUiYJwtmybNVPhpBzqoJrCM4Q3bVEBNuAs4YZ | 7.922667352106697925757824809e+28 | 0 | ams9tG5sJHh6ZDEuWrFZQUnoM6PGau5sMiMnomKBwui | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.byreal_v1_solana.Swap_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### SwapV2\_instruction
Token swap instruction records from Byreal V1 automated market maker (AMM) on Solana. Contains swap parameters including input/output vaults, price limits, and token account details for analyzing DEX trading activity.
| 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_config` | `STRING` | Account address storing the configuration parameters for the Automated Market Maker (AMM) liquidity pool. Base58-encoded Solana public key. |
| `input_token_account` | `STRING` | Account address holding the tokens being swapped or deposited in the transaction. Base58-encoded Solana public key. |
| `input_vault` | `STRING` | Account address holding the input token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `input_vault_mint` | `STRING` | Token mint address for the input vault. Base58-encoded Solana public key. |
| `memo_program` | `STRING` | Program address for the Solana Memo Program used to attach on-chain messages to transactions. Base58-encoded Solana public key. |
| `observation_state` | `STRING` | Account address storing historical price and liquidity observations for the liquidity pool. Base58-encoded Solana public key. |
| `output_token_account` | `STRING` | Account address receiving the tokens from the swap transaction. Base58-encoded Solana public key. |
| `output_vault` | `STRING` | Account address holding the output token reserves for the liquidity pool. Base58-encoded Solana public key. |
| `output_vault_mint` | `STRING` | Token mint address for the output vault. Base58-encoded Solana public key. |
| `payer` | `STRING` | Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key. |
| `pool_state` | `STRING` | Account address representing the liquidity pool state. Base58-encoded Solana public key. |
| `token_program` | `STRING` | Program address managing SPL token operations. Base58-encoded Solana public key representing the Token Program or Token-2022 Program. |
| `token_program_2022` | `STRING` | Program address managing SPL Token-2022 operations. Base58-encoded Solana public key representing the Token-2022 Program. |
| `amount` | `BIGNUMERIC` | Quantity of tokens involved in the transaction. Integer value representing the smallest denomination of the token. |
| `is_base_input` | `BOOL` | Boolean flag indicating whether the input token corresponds to the base token in the liquidity pool's trading pair. |
| `other_amount_threshold` | `BIGNUMERIC` | Minimum acceptable quantity for the output token in a swap transaction. Integer value representing the smallest denomination of the token. |
| `sqrt_price_limit_x64` | `BIGNUMERIC` | Price limit for the swap expressed as the square root of the price ratio, scaled by 2^64 (Q64.64 fixed-point format). |
| `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. |
| payer | amount | amm\_config | block\_slot | pool\_state | input\_vault | memo\_program | output\_vault | is\_base\_input | surrogate\_key | token\_program | transaction\_id | block\_timestamp | input\_vault\_mint | instruction\_type | executing\_account | instruction\_index | observation\_state | output\_vault\_mint | transaction\_index | remaining\_accounts | token\_program\_2022 | transaction\_signer | input\_token\_account | output\_token\_account | sqrt\_price\_limit\_x64 | other\_amount\_threshold | outer\_executing\_account | outer\_instruction\_index |
| -------------------------------------------- | ------- | ------------------------------------------- | ----------- | -------------------------------------------- | -------------------------------------------- | ------------------------------------------- | -------------------------------------------- | --------------- | ------------------------------------------------------------------------------------------------------ | ------------------------------------------- | ---------------------------------------------------------------------------------------- | ------------------------ | -------------------------------------------- | ----------------- | ------------------------------------------- | ------------------ | -------------------------------------------- | ------------------------------------------- | ------------------ | ------------------------------------------------------------------------------------------------ | ------------------------------------------- | -------------------------------------------- | -------------------------------------------- | -------------------------------------------- | ---------------------------------- | ------------------------ | -------------------------------------------- | ------------------------- |
| atom2VuiFEhgGSggRokWuXfsZaS6mxHKwKUSFnECshJ | 7714879 | veWyQnnZP5rJgVkif5zL5hvuxFTZMcJVoVEo3ri8ZKA | 364753372 | GjLusGo2z3mnXPmebhhNt9ocMDJgfdxrDFctVF8Ev3Kg | H66hccvb28JaK6p7jqsNyFkyrc5vNzyDBzWvTveyJFds | MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr | 14fhv98NmX6sDiyiLDsP2WrDHJuD4k5gd5SmiqaJgh7U | true | 364753372-4NeCA12LZN6VKcnkjzAgTFoHfkkbBRhYHsaSR1vwhiEADEivVS7bFamJrDSCB8D9cXjYa6es2cmjdjhKTpAUgCdq-0-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 4NeCA12LZN6VKcnkjzAgTFoHfkkbBRhYHsaSR1vwhiEADEivVS7bFamJrDSCB8D9cXjYa6es2cmjdjhKTpAUgCdq | 2025-09-05T05:12:59.000Z | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | SwapV2 | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | DwuoTKhzz7JmRfkxcwAWi52uqBvuGXWWaspMqm7e79vg | Xsc9qvGR1efVDFGLrVsmkzv3qi45LTBjeUKSPmx9qEh | 82 | \["DGxCE3nZkg6nnZTiktz56hBJRnKpZFv1TgxKbFUHXn1M","AChzVVdxDdAHz7775ccKG4J5gbhKW1ujAYwYyHrUeYrN"] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | atom2VuiFEhgGSggRokWuXfsZaS6mxHKwKUSFnECshJ | EzrSmFqKHouV1s9jh1cAsevobQHyinUneC965va8LSFN | 2yhPzVsC2AB6qukc7UEaxsjJDMYfvQgVGxEb5TCdBjGd | 0 | 0 | AtomCf57Gdp49TDf2q6w7ypqEwPEaCCpxbpTdD4RmDQt | 0 |
| atom2VuiFEhgGSggRokWuXfsZaS6mxHKwKUSFnECshJ | 3984413 | veWyQnnZP5rJgVkif5zL5hvuxFTZMcJVoVEo3ri8ZKA | 364737968 | GjLusGo2z3mnXPmebhhNt9ocMDJgfdxrDFctVF8Ev3Kg | H66hccvb28JaK6p7jqsNyFkyrc5vNzyDBzWvTveyJFds | MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr | 14fhv98NmX6sDiyiLDsP2WrDHJuD4k5gd5SmiqaJgh7U | true | 364737968-4SYBGmE7rLvyS6c4ZrSijkMouzSVWg74KxEAGdLAMJqJuYbGLkJu3qiPc2ADEyn2akx77Euiw27M3X3SK17M3YV1-0-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 4SYBGmE7rLvyS6c4ZrSijkMouzSVWg74KxEAGdLAMJqJuYbGLkJu3qiPc2ADEyn2akx77Euiw27M3X3SK17M3YV1 | 2025-09-05T03:30:55.000Z | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | SwapV2 | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | DwuoTKhzz7JmRfkxcwAWi52uqBvuGXWWaspMqm7e79vg | Xsc9qvGR1efVDFGLrVsmkzv3qi45LTBjeUKSPmx9qEh | 257 | \["DGxCE3nZkg6nnZTiktz56hBJRnKpZFv1TgxKbFUHXn1M","AChzVVdxDdAHz7775ccKG4J5gbhKW1ujAYwYyHrUeYrN"] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | atom2VuiFEhgGSggRokWuXfsZaS6mxHKwKUSFnECshJ | EzrSmFqKHouV1s9jh1cAsevobQHyinUneC965va8LSFN | 2yhPzVsC2AB6qukc7UEaxsjJDMYfvQgVGxEb5TCdBjGd | 0 | 0 | AtomCf57Gdp49TDf2q6w7ypqEwPEaCCpxbpTdD4RmDQt | 0 |
| EV7VScMVUyfe8LKczt5rgJjhfyJy4DnfRGcJJ9g3zjZB | 2229963 | veWyQnnZP5rJgVkif5zL5hvuxFTZMcJVoVEo3ri8ZKA | 364853054 | GjLusGo2z3mnXPmebhhNt9ocMDJgfdxrDFctVF8Ev3Kg | H66hccvb28JaK6p7jqsNyFkyrc5vNzyDBzWvTveyJFds | MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr | 14fhv98NmX6sDiyiLDsP2WrDHJuD4k5gd5SmiqaJgh7U | true | 364853054-3NYSVVmwjmV6AwzYHUzNgFXpPyoqiGBjG5ty7Z1JhAcgMgMGzKD6uuRrK4qp9rnqoD4RYN1vtryVqCvYttRaruSP-3-0 | TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA | 3NYSVVmwjmV6AwzYHUzNgFXpPyoqiGBjG5ty7Z1JhAcgMgMGzKD6uuRrK4qp9rnqoD4RYN1vtryVqCvYttRaruSP | 2025-09-05T16:13:48.000Z | EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v | SwapV2 | REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2 | 0 | DwuoTKhzz7JmRfkxcwAWi52uqBvuGXWWaspMqm7e79vg | Xsc9qvGR1efVDFGLrVsmkzv3qi45LTBjeUKSPmx9qEh | 35 | \["AChzVVdxDdAHz7775ccKG4J5gbhKW1ujAYwYyHrUeYrN","DGxCE3nZkg6nnZTiktz56hBJRnKpZFv1TgxKbFUHXn1M"] | TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb | EV7VScMVUyfe8LKczt5rgJjhfyJy4DnfRGcJJ9g3zjZB | FDXx8F5ALYPGcibPwXVac2VEGpbi9AzyrNrSAF4V4DnM | 6pZL2s2DbDzCJ19WNprxc14gfKhTVrFCEnFEjzDn1sWh | 7.9226673515401279992447579055e+28 | 1 | 3q9RnxufDcorEPAmCeZumn8kveC832rYYmZSk5tcaCzM | 3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.byreal_v1_solana.SwapV2_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***