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.

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_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.

Sample Data

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	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	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	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	JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4	1

Example Query

Query with partition filter

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.

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_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.

Sample Data

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	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	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	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	1	6m2CDdhRgxpH4WjvdzxAYbGxwdGUz5MziiL5jek2kBma	3

Example Query

Query with partition filter

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.

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_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.

Sample Data

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	observation_state	transaction_index	remaining_accounts	transaction_signer	input_token_account	output_token_account	sqrt_price_limit_x64	outer_executing_account
C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j	40000000	4E6xP73xzTs4aCvY92hbXRwWkYptNwvViPZmLcZEBUk4	352614899	9GTj99g9tbz9U6UYDsX6YeRTgUnkYG6GTnHv3qLa5aXq	7XCCPsg1HYuG1xPZ3n5BSSRM9JZU1i7RybMQ2VPitBgU	HL8turx8hJEEPVH4ivxzxwfdxVA1PH3LeYbSmh3hYfzz	5BzogZvHNEuwstR4iwTWdd7jknFBZqJQWVjxPsDfEUD6	true	352614899-4NP7VYnerPUJWnGiiMCSZdfTD5wwoRCSp35aP7Qsf8XmdGxBcU9LkTKzqsyFsPCwRV85td5LpBSss9L2QvmDYsEs-0-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	4NP7VYnerPUJWnGiiMCSZdfTD5wwoRCSp35aP7Qsf8XmdGxBcU9LkTKzqsyFsPCwRV85td5LpBSss9L2QvmDYsEs	2025-07-11T15:11:46.000Z	Swap	REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2	3T6qNbQqWYDfSTew1ifsNedtoeDP8LRuCegmUH27ykEZ	130	[“2fXk9LK5zRWKCbeLqcYkvbTjNMSrDS8YNr8dCkHQ4jQk”,“J4WwSJRGqYQn8xzXN2urgewrAjEFyqFm16rhRvJt2uo5”,“B8SwEGYm7p8eE2okdRe68mbRRSf5hhjP5k4ixp9YUQmo”,“7kpU4nqpUerDw1VZjayRGrqsJjvzNtiuodsgTgJ2qakF”,“zmsoKEYP5amoM8zUEFn2MPMCNtPqRj1ChqYDoF4XsLz”,“GuDQwyNv6g6jtZg13VNcDnK9mb6q8pTj534BDehqvtzF”]	C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j	2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF	DcJWCjqmUiYJwtmybNVPhpBzqoJrCM4Q3bVEBNuAs4YZ	7.922667352106697925757824809e+28	ams9tG5sJHh6ZDEuWrFZQUnoM6PGau5sMiMnomKBwui
C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j	30000000	4E6xP73xzTs4aCvY92hbXRwWkYptNwvViPZmLcZEBUk4	352543150	9GTj99g9tbz9U6UYDsX6YeRTgUnkYG6GTnHv3qLa5aXq	7XCCPsg1HYuG1xPZ3n5BSSRM9JZU1i7RybMQ2VPitBgU	HL8turx8hJEEPVH4ivxzxwfdxVA1PH3LeYbSmh3hYfzz	5BzogZvHNEuwstR4iwTWdd7jknFBZqJQWVjxPsDfEUD6	true	352543150-5dX2ChBGDZu3Zo3UVwaxnH5Tk8VY8RJsMALvBmrGnS6JPAQTYzFwRw4m8MHQvHdEST4fK2GpicNSzKosKaHJfX3X-0-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	5dX2ChBGDZu3Zo3UVwaxnH5Tk8VY8RJsMALvBmrGnS6JPAQTYzFwRw4m8MHQvHdEST4fK2GpicNSzKosKaHJfX3X	2025-07-11T07:18:07.000Z	Swap	REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2	3T6qNbQqWYDfSTew1ifsNedtoeDP8LRuCegmUH27ykEZ	23	[“2fXk9LK5zRWKCbeLqcYkvbTjNMSrDS8YNr8dCkHQ4jQk”,“J4WwSJRGqYQn8xzXN2urgewrAjEFyqFm16rhRvJt2uo5”,“B8SwEGYm7p8eE2okdRe68mbRRSf5hhjP5k4ixp9YUQmo”,“7kpU4nqpUerDw1VZjayRGrqsJjvzNtiuodsgTgJ2qakF”,“zmsoKEYP5amoM8zUEFn2MPMCNtPqRj1ChqYDoF4XsLz”,“GuDQwyNv6g6jtZg13VNcDnK9mb6q8pTj534BDehqvtzF”]	C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j	2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF	DcJWCjqmUiYJwtmybNVPhpBzqoJrCM4Q3bVEBNuAs4YZ	7.922667352106697925757824809e+28	ams9tG5sJHh6ZDEuWrFZQUnoM6PGau5sMiMnomKBwui
C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j	30000000	4E6xP73xzTs4aCvY92hbXRwWkYptNwvViPZmLcZEBUk4	352614952	9GTj99g9tbz9U6UYDsX6YeRTgUnkYG6GTnHv3qLa5aXq	7XCCPsg1HYuG1xPZ3n5BSSRM9JZU1i7RybMQ2VPitBgU	HL8turx8hJEEPVH4ivxzxwfdxVA1PH3LeYbSmh3hYfzz	5BzogZvHNEuwstR4iwTWdd7jknFBZqJQWVjxPsDfEUD6	true	352614952-66DC9Nj92ZrhkBUddnaSYqgrAL3KhiGs8ewsxDjpVGorKXK8VmnVUUzGnzYJkvdEDfMm4VGupuREYQKLRQ4to6s3-0-0	TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA	66DC9Nj92ZrhkBUddnaSYqgrAL3KhiGs8ewsxDjpVGorKXK8VmnVUUzGnzYJkvdEDfMm4VGupuREYQKLRQ4to6s3	2025-07-11T15:12:07.000Z	Swap	REALQqNEomY6cQGZJUGwywTBD2UmDT32rZcNnfxQ5N2	3T6qNbQqWYDfSTew1ifsNedtoeDP8LRuCegmUH27ykEZ	34	[“2fXk9LK5zRWKCbeLqcYkvbTjNMSrDS8YNr8dCkHQ4jQk”,“J4WwSJRGqYQn8xzXN2urgewrAjEFyqFm16rhRvJt2uo5”,“B8SwEGYm7p8eE2okdRe68mbRRSf5hhjP5k4ixp9YUQmo”,“7kpU4nqpUerDw1VZjayRGrqsJjvzNtiuodsgTgJ2qakF”,“zmsoKEYP5amoM8zUEFn2MPMCNtPqRj1ChqYDoF4XsLz”,“GuDQwyNv6g6jtZg13VNcDnK9mb6q8pTj534BDehqvtzF”]	C6GA4fZDTrxzqRh16F1XbGvYqodmgWT1JHCKHvKVnv8j	2pb2bhqTJVJ4BaHhh5xoF3y5oAP2Ygfu8MAXkm99pVHF	DcJWCjqmUiYJwtmybNVPhpBzqoJrCM4Q3bVEBNuAs4YZ	7.922667352106697925757824809e+28	ams9tG5sJHh6ZDEuWrFZQUnoM6PGau5sMiMnomKBwui

Example Query

Query with partition filter

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.

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_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.

Sample Data

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	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	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	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	DwuoTKhzz7JmRfkxcwAWi52uqBvuGXWWaspMqm7e79vg	Xsc9qvGR1efVDFGLrVsmkzv3qi45LTBjeUKSPmx9qEh	35	[“AChzVVdxDdAHz7775ccKG4J5gbhKW1ujAYwYyHrUeYrN”,“DGxCE3nZkg6nnZTiktz56hBJRnKpZFv1TgxKbFUHXn1M”]	TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb	EV7VScMVUyfe8LKczt5rgJjhfyJy4DnfRGcJJ9g3zjZB	FDXx8F5ALYPGcibPwXVac2VEGpbi9AzyrNrSAF4V4DnM	6pZL2s2DbDzCJ19WNprxc14gfKhTVrFCEnFEjzDn1sWh	7.9226673515401279992447579055e+28	1	3q9RnxufDcorEPAmCeZumn8kveC832rYYmZSk5tcaCzM	3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CLMM_Swap_instruction

CLMM_SwapV2_instruction

Swap_instruction

SwapV2_instruction

Metrics

Primitives

Contracts

Blockchain

​Tables

​CLMM_Swap_instruction

​CLMM_SwapV2_instruction

​Swap_instruction

​SwapV2_instruction

Tables

CLMM_Swap_instruction

CLMM_SwapV2_instruction

Swap_instruction

SwapV2_instruction