gmx_v1_solana

Tables

GMSol_CloseWithdrawal_instruction

Withdrawal completion instructions from GMX V1 liquidity pools on Solana (GMSol). Tracks final withdrawal processing with owner, withdrawal account, and store references for analyzing vault liquidity flows and redemption 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.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`withdrawal_account`	`STRING`	Solana account address representing the withdrawal position being closed in this GMX v1 instruction. Base58-encoded 32-byte public key that uniquely identifies the withdrawal state account.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.

Sample Data

owner	store	block_slot	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	withdrawal_account
DK2eNstwfJ5kx6VLPUMCi399JDUPjGXf5KvNfyYnhMoR	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	363263479	363263479-5f7V2i5phSQnJLFu39Q2zpfzKnz2qQT7NCmdYVM9ZZREabwFQUbcys7FcjJbby6sM5j2N4iU2nZtyNRfVnKuGmHf-3	5f7V2i5phSQnJLFu39Q2zpfzKnz2qQT7NCmdYVM9ZZREabwFQUbcys7FcjJbby6sM5j2N4iU2nZtyNRfVnKuGmHf	2025-08-29T09:28:05.000Z	CloseWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	48	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	DwsmkRUkEw94ehi4coANoXBWg2fPFA8Ja4q3cLQLWmdQ
DK2eNstwfJ5kx6VLPUMCi399JDUPjGXf5KvNfyYnhMoR	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	363263589	363263589-3wX1uwB82Aps7UcfWCJMS8tzsPzdn7hSpxgY5XtCd5btNRdCxZ7arPyca2S6GSaqnY18W85dkZgLizbPo7F1seHX-3	3wX1uwB82Aps7UcfWCJMS8tzsPzdn7hSpxgY5XtCd5btNRdCxZ7arPyca2S6GSaqnY18W85dkZgLizbPo7F1seHX	2025-08-29T09:28:50.000Z	CloseWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	191	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	3GSY1tFUNKe252w7mXHZGAEp1F1j7ksbRDaVEP5BXdZx
H89an5zGq8o9Mu26TthNf6Z9dQBzMESp8XBL9rVEqMiS	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	363287764	363287764-5chAa7sY6NwtUp1uW1tHPWEv7v6WngbyVTatY9dT9BivSqiE9ccc3HcR86uMvafZYzQ6AfV3GGCrQkyZzXTStFnV-3	5chAa7sY6NwtUp1uW1tHPWEv7v6WngbyVTatY9dT9BivSqiE9ccc3HcR86uMvafZYzQ6AfV3GGCrQkyZzXTStFnV	2025-08-29T12:07:39.000Z	CloseWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	330	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	GyByg84AGU3UdSVsGwAmUf5xx6hDfAqprhXiCAvscuMb

Example Query

Query with partition filter

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

GMSol_CreateDeposit_instruction

Deposit creation instructions for GMX v1 liquidity pools on Solana, capturing user deposits of long and short tokens into markets in exchange for liquidity provider (LP) tokens. Used to analyze liquidity provisioning behavior, deposit sizes, and market token minting activity across GMX markets.

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.
`deposit`	`STRING`	Account address of the deposit position created by this CreateDeposit instruction. Each deposit represents a unique liquidity provision request in the GMX protocol.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`receiver`	`STRING`	Account that will receive the liquidity pool tokens minted from this deposit. Base58-encoded Solana address, typically matching the deposit owner.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`market_token`	`STRING`	Account representing the liquidity pool token for a GMX trading market. Base58-encoded Solana public key.
`market_token_ata`	`STRING`	Associated Token Account (ATA) address for the market token owned by the receiver. This account holds the LP tokens received after the deposit is executed.
`market_token_escrow`	`STRING`	Account that temporarily holds market LP tokens during the deposit creation process. This escrow is controlled by the GMX protocol until the deposit is executed or cancelled.
`initial_long_token`	`STRING`	Token address of the long position collateral in this GMX deposit. Typically represents wrapped SOL (Gmso1uv…) in the sample transactions.
`initial_long_token_source`	`STRING`	Token account address from which the initial long token amount is transferred. Solana account identifier (base58-encoded) holding the user’s long token balance before deposit.
`initial_long_token_escrow`	`STRING`	Account address holding the deposited long token in escrow until the deposit is executed or cancelled. Typically matches the program address when no long token is deposited (amount = 0).
`initial_short_token`	`STRING`	Token address of the short token being deposited into the GMX liquidity pool. Typically represents stablecoins (USDC) as shown by the consistent EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v address across samples.
`initial_short_token_source`	`STRING`	Source account address from which initial short tokens are transferred during deposit creation. Tokens are pulled from this account (typically user’s Associated Token Account or ATA) to fund the liquidity position.
`initial_short_token_escrow`	`STRING`	Solana account address holding the short token in escrow during the deposit process. This escrow account temporarily secures the deposited short token amount until the deposit instruction is fully executed.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`nonce`	`JSON`	Cryptographic nonce used to derive the deposit account’s Program Derived Address (PDA). Represented as a 32-byte array ensuring unique deposit account generation.
`execution_lamports`	`BIGNUMERIC`	Execution fee paid for processing this deposit instruction on Solana, denominated in lamports (1 SOL = 1 billion lamports). All sample transactions show a standard fee of 200,000 lamports (0.0002 SOL).
`initial_long_token_amount`	`BIGNUMERIC`	Amount of long tokens deposited in lamports at instruction creation time. Always 0 in samples, suggesting deposits occur exclusively in short tokens for these markets.
`initial_short_token_amount`	`BIGNUMERIC`	Amount of the short token deposited into the GMX market, denominated in the token’s smallest unit. Typically non-zero when users provide short-side liquidity.
`min_market_token_amount`	`BIGNUMERIC`	Minimum amount of market tokens the depositor expects to receive from this deposit. Acts as slippage protection, ensuring the transaction reverts if market conditions result in fewer tokens than this threshold.
`long_token_swap_length`	`INT64`	Number of swap operations required to convert the long token into the desired market position. Typically zero when depositing native market tokens directly.
`short_token_swap_length`	`INT64`	Number of swap operations planned for the short token during deposit creation. Typically 0 when depositing directly without intermediate swaps.
`should_unwrap_native_token`	`BOOL`	Indicates whether the deposited native SOL should be unwrapped to WSOL (Wrapped SOL) during the deposit process. Always true in these samples, suggesting automatic conversion of native tokens.

Sample Data

nonce	owner	store	market	deposit	receiver	block_slot	market_token	surrogate_key	transaction_id	block_timestamp	instruction_type	market_token_ata	executing_account	instruction_index	transaction_index	execution_lamports	initial_long_token	transaction_signer	initial_short_token	market_token_escrow	min_market_token_amount	initial_long_token_escrow	initial_long_token_source	initial_short_token_amount	initial_short_token_escrow	initial_short_token_source	should_unwrap_native_token
[131,155,97,141,101,115,178,23,183,78,3,229,162,110,62,194,63,242,78,20,27,203,76,196,111,130,166,20,106,49,119,127]	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	8rLKTG4dHkDkvpoBvDHVDedF8n1xR5vt9kGTD3gs2xbV	4Wvwa1BVo8Tc5JL3veLuE89deQW9J3TfTbyH6EFCvT6L	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	375073101	6kKGHF9tPoXvtyAGUY8mfuRCFXBw61xWfhfS4sSJbXFr	375073101-67F6cSKHhAH536MjBJH79fKRWzkBknj8W5XxCUgUyVKQHvdADzHvwraVnuz45eBS175WxbRUfkzQLKWC6cAt8tWd-4	67F6cSKHhAH536MjBJH79fKRWzkBknj8W5XxCUgUyVKQHvdADzHvwraVnuz45eBS175WxbRUfkzQLKWC6cAt8tWd	2025-10-22T14:53:01.000Z	CreateDeposit	FgcLMdnYFLRGs4kPUppBrRRC1CcQuGxA3BPSuQfc71Lb	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	4	86	200000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	DxmR8jzqdTz4QpNKDG4zV7DE7UL62J74S5hHD5srV9h3	100000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	100000	AJysgrBYV3DXgVPkdRdwFTTqDR7qPCZtjJMkQaRFZMxa	9NHhVTAvaAG6rTHcsbn6oRc9zcgg7vF5TodmNdkmJaBd	true
[54,105,252,244,4,215,194,44,50,82,3,251,213,70,121,106,193,36,49,232,211,160,127,220,30,253,210,128,150,209,245,207]	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	7F8y61cwBWxgdVHZ17qx4KSfPsdhXLvgMQAfQY6xv9ty	FvpnrRrB8ffUswY2a76Z2mi57TsF3YxuhWdz2XGALpSb	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	375072730	2wxH1sGLH4Rui6Ws4F1nFDHtW3aJDG1fAF3gZVJ7ktwV	375072730-2SzA2vyiWjVn3vHgM9wYwikJt96yUnpfQb2zyHxfwz1AN2k9abicG7fU5CHQ2uKohZsq4YRM8g4BBcLof1Lai7bh-4	2SzA2vyiWjVn3vHgM9wYwikJt96yUnpfQb2zyHxfwz1AN2k9abicG7fU5CHQ2uKohZsq4YRM8g4BBcLof1Lai7bh	2025-10-22T14:50:35.000Z	CreateDeposit	4eegihbstUkRzAvv55oGCpWiTT7WmkcsGKUqQVJuz5mw	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	4	50	200000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	FpX6cbcsSaVya6XdkbSPTSdoCK4yDqkZuNe5TxTH33Vy	100000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	100000	9Khc72meS5VVwjDtFcc6mnXbiUWX44Fdra971t7uzvsm	9NHhVTAvaAG6rTHcsbn6oRc9zcgg7vF5TodmNdkmJaBd	true
[93,132,238,116,231,221,79,163,173,79,115,29,118,164,89,197,5,133,232,92,243,241,78,146,27,95,189,73,185,152,78,143]	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	4rF2MSAmBmmcQvwJUzZSPwLrfG6FcPyQEne9q7KfzKTF	6vktnG8daJ8HYYwpTXBmWEcrUQChc61Hp5qaZ6fYw8jK	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	375072977	6KTCEqyMG9eErgSkfbe5QTc6eYnPcgJ4bKK63VZWqZWG	375072977-4MNxeUF8j3tkF5gQWkQ6nWvM5t3e6DwdkiuefPNbfcfZ7bmXvnVjR8T2jUz3a2n9reQ6TKB9H7aYrEBBKDW7ZW36-4	4MNxeUF8j3tkF5gQWkQ6nWvM5t3e6DwdkiuefPNbfcfZ7bmXvnVjR8T2jUz3a2n9reQ6TKB9H7aYrEBBKDW7ZW36	2025-10-22T14:52:13.000Z	CreateDeposit	GuwCtSwFY7ZSH6h1jPVVUYDyt6D5KNiAxNhvpfbgy7Eg	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	4	60	200000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5xYnGMAj62B1uFSRCeAygDDYcHM9iBHTJABmwzfSNPGo	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	AnFXG2fdiFkYtKsUf7TpohBbXafAAsP5YFzC2vUsQ7dL	100000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	100000	398AUF18ZQULvXjd3SAuNZsJ3D3MDj6xjGunPwx3sgjz	9NHhVTAvaAG6rTHcsbn6oRc9zcgg7vF5TodmNdkmJaBd	true

Example Query

Query with partition filter

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

GMSol_CreateWithdrawal_instruction

GMX v1 liquidity pool withdrawal initiation instructions on Solana. Records withdrawal requests with market token amounts, minimum output requirements, and user accounts for tracking LP removal 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.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`withdrawal_account`	`STRING`	Account address where the withdrawn tokens will be received upon withdrawal execution. Base58-encoded Solana account identifier created for each withdrawal transaction.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`nonce`	`JSON`	Unique identifier for the withdrawal request, represented as a 32-byte array. Each withdrawal creates a new nonce value to prevent duplicate transactions and ensure idempotency.
`execution_lamports`	`BIGNUMERIC`	Transaction fee paid in lamports (1 SOL = 1 billion lamports) for executing this withdrawal instruction. Consistently 200,000 lamports (0.0002 SOL) across all sample transactions.
`market_token_amount`	`BIGNUMERIC`	Amount of market tokens (liquidity pool shares) being withdrawn from the GMX position. Denominated in the market token’s smallest unit, representing the user’s LP token balance to redeem.
`min_long_token_amount`	`BIGNUMERIC`	Minimum amount of long token the user is willing to receive from the withdrawal. Set to 0 in sample data, indicating no slippage protection for the long token portion.
`min_short_token_amount`	`BIGNUMERIC`	Minimum amount of short tokens the user expects to receive from the withdrawal. Set to zero to accept any amount without slippage protection.
`long_token_swap_length`	`INT64`	Number of swap steps required to convert the long token during withdrawal execution. Null when no long token swap is configured for the withdrawal.
`short_token_swap_length`	`INT64`	Number of intermediate token swaps required for the short token leg of the withdrawal. Null when no swap is needed for the short token position.
`should_unwrap_native_token`	`BOOL`	Boolean flag indicating whether to unwrap native SOL tokens during withdrawal processing. Consistently true in observed transactions, suggesting automatic unwrapping is the default behavior.

Sample Data

nonce	owner	store	market	block_slot	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	execution_lamports	transaction_signer	withdrawal_account	market_token_amount	should_unwrap_native_token
[249,94,147,77,165,21,72,183,141,21,96,214,50,224,30,80,172,30,96,44,221,100,216,212,15,155,30,159,175,82,0,207]	2tTPiyXKifAtwLasZwkpdSKmJQvG6LuQ7k8cV3TC5HxM	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	328543607	328543607-54MLFpMSN6nzvF6WETS8rkaZVQzgrZzV8PssAbtUcXEVQi5RDXFRQaaMFthW1tEH5eN5W4ofBuRaUBHCjicgGNmq-8	54MLFpMSN6nzvF6WETS8rkaZVQzgrZzV8PssAbtUcXEVQi5RDXFRQaaMFthW1tEH5eN5W4ofBuRaUBHCjicgGNmq	2025-03-23T00:43:15.000Z	CreateWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	8	3	200000	2tTPiyXKifAtwLasZwkpdSKmJQvG6LuQ7k8cV3TC5HxM	A6xpv4BVi8mvSLkY18YAryjTWFSNdJ68pVVDXV2TyGWP	9833769539249	true
[110,229,109,133,111,113,32,68,25,29,16,144,245,99,186,188,221,203,84,8,192,87,215,171,135,69,174,49,50,184,135,81]	3PrS35pbYWhVNxQ5eSH5LvhWzurmsdNd6zMhSMV5zFoX	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	328670568	328670568-4r7CUVayDu83PDfVGXEW3NAqRfDikZnGXizLJTCUPkLituJtajMLemqnuh7BkAoUPH3hGxrYrGdX99PJZ4156DxW-8	4r7CUVayDu83PDfVGXEW3NAqRfDikZnGXizLJTCUPkLituJtajMLemqnuh7BkAoUPH3hGxrYrGdX99PJZ4156DxW	2025-03-23T14:47:36.000Z	CreateWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	8	294	200000	3PrS35pbYWhVNxQ5eSH5LvhWzurmsdNd6zMhSMV5zFoX	3mWGN1Y1Pdqr9VHcTHDxXFU45Sdo6GwV5CQkz8biZjqx	6400000000000	true
[246,156,235,56,62,245,176,116,219,130,222,174,13,11,102,159,5,113,126,9,156,142,8,201,90,73,196,177,41,157,127,90]	BMv5bFFaVjha8nD3h4qaFpfWaBExc9wGtgtvJWBFTY76	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	328613723	328613723-4QXa6jooRnUm1ZzzHAbvjtV31cdHE57mD5G4nxzRgTfZs342D5dxTUeiq3tQhuoZV2Cb7qQo7z4T8Cvv68KmxwML-8	4QXa6jooRnUm1ZzzHAbvjtV31cdHE57mD5G4nxzRgTfZs342D5dxTUeiq3tQhuoZV2Cb7qQo7z4T8Cvv68KmxwML	2025-03-23T08:29:11.000Z	CreateWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	8	52	200000	BMv5bFFaVjha8nD3h4qaFpfWaBExc9wGtgtvJWBFTY76	8dDBb3vsLtcL4qXmPUFfeLrwvghpTq1UEPiPoxiZB7ku	4823493985534	true

Example Query

Query with partition filter

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

GMSol_ExecuteDecreaseOrder_instruction

Order execution records for position decreases on GMX V1 Solana perpetual markets. Contains fill data including user accounts, market identifiers, token vaults, execution fees, and oracle references for analyzing position closures and profit-taking 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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`position`	`STRING`	Account representing a trading position or vault position in the protocol. Base58-encoded Solana public key.
`order_account`	`STRING`	Account representing the order being executed or acted upon. Base58-encoded Solana public key.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`long_token_vault`	`STRING`	Account holding the long position token reserves for the market. Base58-encoded Solana public key.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`short_token_vault`	`STRING`	Account holding the short position token reserves for the market. Base58-encoded Solana public key.
`final_output_token`	`STRING`	Account address of the token received as the final output from the order execution. Base58-encoded Solana public key.
`final_output_token_vault`	`STRING`	Vault account holding the final output token transferred to the user after order execution. Represents the protocol’s token reserve account on Solana that sources the settlement payment.
`claimable_long_token_account_for_user`	`STRING`	User’s token account for receiving claimable long tokens from position settlements. Base58-encoded Solana account address that holds the long side token (e.g., SOL, USDC) specified in the market.
`claimable_short_token_account_for_user`	`STRING`	User’s token account address for receiving claimable short token proceeds from position settlements. Base58-encoded Solana address that holds the short-side collateral token for this market.
`claimable_pnl_token_account_for_holding`	`STRING`	Account address holding claimable profit and loss (PnL) tokens for this position closure. This is typically a protocol-controlled vault that temporarily holds settlement tokens before distribution to the user.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`recent_timestamp`	`INT64`	Unix timestamp representing the most recent acceptable time for instruction execution. Integer value in seconds since the Unix epoch.
`throw_on_execution_error`	`BOOL`	Flag indicating whether the instruction should revert the transaction upon execution failure.

Sample Data

user	owner	store	market	oracle	position	authority	block_slot	long_token	short_token	execution_fee	order_account	surrogate_key	transaction_id	block_timestamp	instruction_type	long_token_vault	recent_timestamp	executing_account	instruction_index	short_token_vault	transaction_index	final_output_token	transaction_signer	final_output_token_vault	throw_on_execution_error	claimable_long_token_account_for_user	claimable_short_token_account_for_user	claimable_pnl_token_account_for_holding
3TUbGjGu2RvpaJGHZjv81ZiYWLN87YeRkEsZi42C11nJ	Aq2LuVu4TMrjCreARCz3Ck7v48MGoizzqVoB1vRiYdDm	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	8xZ95KnnLdy2aZ6zgEbKVg2yJkyqiNhsUbY8G6vFJbxW	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	FVimkN4YehKoXcUBf9wZU6daKT2p2xwKqwYFu29jKXPg	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	338238496	3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	375180	9SB3v4H8kkwYnADs28U75LhRG5sSmAUfubsVbtCevU2i	338238496-5wFvYF5ut6cRsNgauLPyBPPZhzbAVQRSRQtBTLfT27e6DcZKpTYgmXHpGuWiGGgPVxCCoq2tsYDRhj9KPvQ453Ux-6	5wFvYF5ut6cRsNgauLPyBPPZhzbAVQRSRQtBTLfT27e6DcZKpTYgmXHpGuWiGGgPVxCCoq2tsYDRhj9KPvQ453Ux	2025-05-06T15:25:17.000Z	ExecuteDecreaseOrder	FDJy7HQFtxVR7ZLYokMeYuu64uWnUtH886vAiUZU3RaK	1746545114	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	6	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	74	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	false	DuXmAtvCASP7aMhhkjVjimn5fpsU9XkFCe7Qtn28vnoy	GYXEMdaAeBoAFS24yzQtZFbsqAWRRkK6FhYbXjJuAXi1	7PQ8YKDjm6wBUUGBTd5MZuyARq6gQzNj1QzZCdmeiiB7
3X2Db2uDTWRSUVAAHZYb2hGetYnLqoYPmGtXTnFpzSWe	pd1CsFgdR91gRZF3RKzDJzbhhEfBeLVbsNJrV6VV3hL	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	CJg17Dn4xgUyEW3gKSSyteNw7LhP1o9pzm9eLtvuNjkQ	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	GVZyEhrYq1pdgtYJ2fPH1TGjZ8J6s1RU9AjW5hrSNpix	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	338268284	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	102387	4942cZwsC7usFGvUDJ8eYD31deH86aBgvtAkgNjScSnG	338268284-5RKVHVLrnPMiZp1zTuRjWnVj9rSGLUaLHzv8EDj7JdCnEJ944tFH4CVvmoqFkMS8oB3Ft4A5PEtWG8DfS6pTpttr-5	5RKVHVLrnPMiZp1zTuRjWnVj9rSGLUaLHzv8EDj7JdCnEJ944tFH4CVvmoqFkMS8oB3Ft4A5PEtWG8DfS6pTpttr	2025-05-06T18:41:59.000Z	ExecuteDecreaseOrder	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1746556917	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	140	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	false	4K5yAG8ddB2cXn3WineazgRpb6JG8RUTd8FHJv18u6jP	4K5yAG8ddB2cXn3WineazgRpb6JG8RUTd8FHJv18u6jP	CgUjMxCwUSm7o59xuiXAzJV6sVTWNzZByeqkc6244r9a
4R5QtuWJWdunfdy52CM2X18yH2vm5CrwQQQstv4t8ytp	ExCsisSuZuXmnuPMNVUiR7zTejfN3kmZdVidSExQE1vc	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	9NHXWtLQX4Y4P72Qs6y2j3XHNe3Q6xapw6VHAep6rezE	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	338263264	So11111111111111111111111111111111111111112	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	105000	EkNdUCze6rgCNcKEKWfNY5ZFWcRXYYqMBacRdQhou4yL	338263264-5mHyDRJpF1r7fnKxL3AhY44bu8i5ZzhNfHvGGgXettTUdFd3wtqbLL7VTzXsaX6X6Cv6nbCmpZcKV5RZXSJCNsAU-6	5mHyDRJpF1r7fnKxL3AhY44bu8i5ZzhNfHvGGgXettTUdFd3wtqbLL7VTzXsaX6X6Cv6nbCmpZcKV5RZXSJCNsAU	2025-05-06T18:08:48.000Z	ExecuteDecreaseOrder	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj	1746554925	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	6	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	110	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	false	DumDLtRQPAeUsgvV1qNWab3Tzt5NxzMR2NPsLofHF4Co	Gm8R5PyruZomBnyVGBvasANM9scFMWqzxyatkMR8sDWD	CgUjMxCwUSm7o59xuiXAzJV6sVTWNzZByeqkc6244r9a

Example Query

Query with partition filter

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

GMSol_ExecuteDecreaseOrderV2_instruction

Position closure execution records from GMX V1 perpetual futures protocol on Solana. Captures decrease order fills with execution fees, position identifiers, market/oracle references, and token vault addresses for analyzing trade exits and liquidations.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`position`	`STRING`	Account representing a trading position or vault position in the protocol. Base58-encoded Solana public key.
`order_account`	`STRING`	Account representing the order being executed or acted upon. Base58-encoded Solana public key.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`long_token_vault`	`STRING`	Account holding the long position token reserves for the market. Base58-encoded Solana public key.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`short_token_vault`	`STRING`	Account holding the short position token reserves for the market. Base58-encoded Solana public key.
`final_output_token`	`STRING`	Account address of the token received as the final output from the order execution. Base58-encoded Solana public key.
`final_output_token_vault`	`STRING`	Solana account address of the vault holding the final output token for this decrease order execution. Matches the long or short token vault depending on which token the user receives upon closing their position.
`claimable_long_token_account_for_user`	`STRING`	Solana account address where claimable long token amounts are deposited for the user after position decrease. Base58-encoded address typically unique per user and token type.
`claimable_short_token_account_for_user`	`STRING`	Solana account address where claimable short token profits and returns are deposited for the user. Base58-encoded string representing the user’s associated token account for receiving short position proceeds.
`claimable_pnl_token_account_for_holding`	`STRING`	Token account address that holds claimable profit and loss (PnL) tokens for the protocol or market maker. This account accumulates realized PnL from position closures that can be claimed by the holding entity.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`recent_timestamp`	`INT64`	Unix timestamp representing the most recent acceptable time for instruction execution. Integer value in seconds since the Unix epoch.
`throw_on_execution_error`	`BOOL`	Flag indicating whether the instruction should revert the transaction upon execution failure.

Sample Data

user	owner	store	market	oracle	position	authority	block_slot	long_token	short_token	execution_fee	order_account	surrogate_key	transaction_id	block_timestamp	instruction_type	long_token_vault	recent_timestamp	executing_account	instruction_index	short_token_vault	transaction_index	final_output_token	transaction_signer	final_output_token_vault	throw_on_execution_error	claimable_long_token_account_for_user	claimable_short_token_account_for_user	claimable_pnl_token_account_for_holding
2A8DkSz3ZnvqoJqUxcN9eVTxkXW7mSZVrfHSzNB27cEk	Hcembof5AAjt53zqonqGRxNscxxi4XuM7rFveBa8eYSD	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	7F8y61cwBWxgdVHZ17qx4KSfPsdhXLvgMQAfQY6xv9ty	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	5AdmEieAnuQ4WFBC1ZQHfuApcwVu4c8XxsJsaN8xiftn	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	360413582	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	114000	3aairNVcTt5tBLtXiyspR9CDUdySmS8aGD2DjywqJL6v	360413582-2brDnDvfFUALhew8WNHpCA24s7e7WBqzw3ss95YvxgxWajy98XPuutywdZWkNeKsCF38q3J7VHnKvwNYQ9XnTMzq-5	2brDnDvfFUALhew8WNHpCA24s7e7WBqzw3ss95YvxgxWajy98XPuutywdZWkNeKsCF38q3J7VHnKvwNYQ9XnTMzq	2025-08-16T09:48:32.000Z	ExecuteDecreaseOrderV2	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1755337710	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	130	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	false	GvdkWcP3gsMD2hLbHiVLR77VT4E9oB4jQwY92eCjuqoU	GvdkWcP3gsMD2hLbHiVLR77VT4E9oB4jQwY92eCjuqoU	7hGstYfPr3SgZWLkBeAJhYXDz53QnQzPXyEPMUrmnYR3
2A8DkSz3ZnvqoJqUxcN9eVTxkXW7mSZVrfHSzNB27cEk	Hcembof5AAjt53zqonqGRxNscxxi4XuM7rFveBa8eYSD	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	CJg17Dn4xgUyEW3gKSSyteNw7LhP1o9pzm9eLtvuNjkQ	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	3aKWDqfjvVqMUtGXwgpK7S2t7ekbzDj7nKBbb3QVywEC	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	360413534	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	112193	45EtjqVuQgHT5PXqernKsmb5NKjDByLLeSqasP42veqw	360413534-4HPwJedGetsUFQexZpodZQVYMJ8PWEYh743f5M4ay4m1FVVSwAUCZwG5GDm4XnMS9gdnPtBxESR54328W4Hp6oVz-5	4HPwJedGetsUFQexZpodZQVYMJ8PWEYh743f5M4ay4m1FVVSwAUCZwG5GDm4XnMS9gdnPtBxESR54328W4Hp6oVz	2025-08-16T09:48:13.000Z	ExecuteDecreaseOrderV2	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1755337692	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	85	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	false	GvdkWcP3gsMD2hLbHiVLR77VT4E9oB4jQwY92eCjuqoU	GvdkWcP3gsMD2hLbHiVLR77VT4E9oB4jQwY92eCjuqoU	7hGstYfPr3SgZWLkBeAJhYXDz53QnQzPXyEPMUrmnYR3
3LTuR8jCZWccwhnDRUPG3inKuXvD9BVJJdEEFYg5JEHK	FhcrBAymYW9KTYNXCxXkHsncPF2E6a896aHnMJBT94J9	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	4tM9cPqNpEYmstNdJMCc6rwdq42939w1SRFYoqMsqPQF	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	GmLWYdwYoyW7L3GANQuwtiQrZJTxZXqTHHE6zFJBLBvc	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	360456307	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	101959	BV7Ub6dNyNEKJNZJm2gQUQSXEP5RFYbYoGhrLQ8ihEMM	360456307-66Y75oPcaBRxpbNbnVeAQxc1jao4CS1GSpuhQthh9m4Moi8RJ12U5seCCakkjcoJbKuGH5yVjF4CEMMuoirqKLy1-5	66Y75oPcaBRxpbNbnVeAQxc1jao4CS1GSpuhQthh9m4Moi8RJ12U5seCCakkjcoJbKuGH5yVjF4CEMMuoirqKLy1	2025-08-16T14:28:27.000Z	ExecuteDecreaseOrderV2	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1755354504	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	61	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	false	693n6BebqwiYq7WCersBv6SGGRgArkqdYa7aTxe8Wcg6	693n6BebqwiYq7WCersBv6SGGRgArkqdYa7aTxe8Wcg6	7Jr2H2iyAqf3H9F3cLjFa2xXgTmfkkL3yfGiRDJMdK1t

Example Query

Query with partition filter

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

GMSol_ExecuteDeposit_instruction

Executed deposit instructions from GMX v1 protocol on Solana, recording liquidity provision events with market identifiers, token vault addresses, and execution fees. Used for tracking market maker deposits and analyzing liquidity flows across GMX markets.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`deposit`	`STRING`	Solana address of the deposit request being executed in this transaction. Base58-encoded string identifying the specific deposit order in the GMX v1 protocol.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`market_token`	`STRING`	Account representing the liquidity pool token for a GMX trading market. Base58-encoded Solana public key.
`market_token_escrow`	`STRING`	Escrow account holding market tokens during deposit execution. Solana account address temporarily securing LP tokens before final distribution to depositor.
`initial_long_token`	`STRING`	Solana address of the market’s long collateral token (GMSol wrapped SOL in these samples). Represents the base asset for long positions being deposited into the GMX v1 liquidity pool.
`initial_long_token_vault`	`STRING`	Solana program account holding the long token reserves for this GMX market. Base58-encoded 32-byte public key representing the vault that stores deposited long-side collateral.
`initial_long_token_escrow`	`STRING`	Escrow account holding the initial long token deposits before they are transferred to the market vault. Base58-encoded Solana address for the program-derived account managing deposited assets.
`initial_short_token`	`STRING`	Token contract address for the short-side collateral being deposited into the GMX market. Typically a stablecoin like USDC on Solana (EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v).
`initial_short_token_vault`	`STRING`	Solana address of the vault account holding the market’s short token (typically USDC). The vault stores deposited collateral before it is processed into market tokens during deposit execution.
`initial_short_token_escrow`	`STRING`	Solana program account holding USDC or other short tokens in escrow for this deposit before execution. Temporary custody address that releases funds to the vault upon successful deposit completion.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`throw_on_execution_error`	`BOOL`	Flag indicating whether the instruction should revert the transaction upon execution failure.

Sample Data

store	market	oracle	deposit	authority	block_slot	market_token	execution_fee	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	initial_long_token	transaction_signer	initial_short_token	market_token_escrow	initial_long_token_vault	throw_on_execution_error	initial_long_token_escrow	initial_short_token_vault	initial_short_token_escrow
CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	8rLKTG4dHkDkvpoBvDHVDedF8n1xR5vt9kGTD3gs2xbV	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	2FzhG1V5o4rsZNpod9zhLNriNbbLpxaizS4aJWJpXsxe	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	366787660	6kKGHF9tPoXvtyAGUY8mfuRCFXBw61xWfhfS4sSJbXFr	61011	366787660-3pfgrhomvvkURG8WnZe851fX6ucPvxtD6jUeghEkk7hfYeEcY9oia6ZxSzfVejBMkDzDwZYREMZvZ7kj4JszUY9K-2	3pfgrhomvvkURG8WnZe851fX6ucPvxtD6jUeghEkk7hfYeEcY9oia6ZxSzfVejBMkDzDwZYREMZvZ7kj4JszUY9K	2025-09-14T14:53:13.000Z	ExecuteDeposit	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2	357	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	4iNn8y6rGnAfBCFwfokEH23NtMFDacoFXePoMqEwK6ds	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	false	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	GsxGYNAsmeZ7WTRfQFjZCjLzLT2KaZPCDbUbVEKo6Zw8
CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	C199y3g9awLbt3r8dQyZ8jnyghSqJTuDYs6pNzz6Ctnz	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	5THrnGsJMsJQw4NVDHpjRuvjAkc3i371UfiQJDprKz42	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	366788722	527jUvh7guN8Fip96TeJhKWreeWdcwD9CFFwXG9mTiHQ	74000	366788722-HMpV5FnWcxpgyFYn6aKfVmUTvTfNgpVR2U7jHdfca5ZR5DsXpuP9ssYgjnJFrUivM3q72gXis6Y1tiDQbahykqz-2	HMpV5FnWcxpgyFYn6aKfVmUTvTfNgpVR2U7jHdfca5ZR5DsXpuP9ssYgjnJFrUivM3q72gXis6Y1tiDQbahykqz	2025-09-14T15:00:14.000Z	ExecuteDeposit	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2	190	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	jcepxk5LHFuLKjpC4ujcNu5tqsBaJnbibEcApyviaYf	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	false	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	14TFZQgeUAAEQ2NGWSywsvM1q3a7S5bSM4Q2oF1x852Q
CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	ARD41bjAWARhJ4wbByGDhdnkGfCr5NzGAsnAjNU5WbaE	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	EMvmmGV2AT6Z8vY6768h6f7GKMSWPCGb9ERdUwFSCrTh	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	366788602	2dVHXNgzC7vvcsDi89S6crSkX3Y6HzPgZfmWqttEzvmo	70929	366788602-Hi5PSBss5Q2vy2fN96cJxC1KZka4qtZBoVCkR6e9gCdUgHyBeaPjbw7CXhqoTAQagLvArurpBXJFaJ3RNhJbGhz-2	Hi5PSBss5Q2vy2fN96cJxC1KZka4qtZBoVCkR6e9gCdUgHyBeaPjbw7CXhqoTAQagLvArurpBXJFaJ3RNhJbGhz	2025-09-14T14:59:25.000Z	ExecuteDeposit	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2	331	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	GX2Xcu2WUSAxrqADPEAan1gZroAg79AkYL4NXhuZx6be	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	false	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	8qMYLJySRaSHoFVqmgturuE3ysfgxf9iai1GXktJirUK

Example Query

Query with partition filter

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

GMSol_ExecuteIncreaseOrSwapOrder_instruction

GMX V1 position increase and swap order executions on Solana, capturing user accounts, collateral tokens (SOL/USDC), execution fees, and oracle references. Enables analysis of leveraged trading activity and order fill patterns across GMX markets.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`position`	`STRING`	Account representing a trading position or vault position in the protocol. Base58-encoded Solana public key.
`order_account`	`STRING`	Account representing the order being executed or acted upon. Base58-encoded Solana public key.
`initial_collateral_token`	`STRING`	Token address used as initial collateral when the position was opened or increased. Typically either SOL (So11111111111111111111111111111111111111112) or USDC (EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v) on Solana.
`initial_collateral_token_vault`	`STRING`	Program account address holding the initial collateral tokens deposited with the order. References the vault for either the long or short token depending on the collateral type used.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`long_token_vault`	`STRING`	Account holding the long position token reserves for the market. Base58-encoded Solana public key.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`short_token_vault`	`STRING`	Account holding the short position token reserves for the market. Base58-encoded Solana public key.
`final_output_token`	`STRING`	Account address of the token received as the final output from the order execution. Base58-encoded Solana public key.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`recent_timestamp`	`INT64`	Unix timestamp representing the most recent acceptable time for instruction execution. Integer value in seconds since the Unix epoch.
`throw_on_execution_error`	`BOOL`	Flag indicating whether the instruction should revert the transaction upon execution failure.

Sample Data

user	owner	store	market	oracle	position	authority	block_slot	long_token	short_token	execution_fee	order_account	surrogate_key	transaction_id	block_timestamp	instruction_type	long_token_vault	recent_timestamp	executing_account	instruction_index	short_token_vault	transaction_index	final_output_token	transaction_signer	initial_collateral_token	throw_on_execution_error	initial_collateral_token_vault
FGUbKB13hnNCP2QRn7sFtRfV3UtDi1cD9Uc2CH9GazCG	DGiAWjk73NuEKmh89gbfhewpCcnPEv8ZhpzqAPJYq19k	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	GQ92sh52jGhPCxRQUFs3XJmYWj9yfC45EmmVndguRWdR	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	324227139	So11111111111111111111111111111111111111112	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	109026	DdwJiy3Fjee4VaQE3PTfcJ1WZNfadS4kEiSZ7YMVd4Uc	324227139-N9FnUVwdBnSqVcps126VQgtjr5mYpeakRTbxQrRMnmUhMQatayXVQBZCs9QPjDsCZ7oCQCm2cM2ghn8Li3jqSsB-3	N9FnUVwdBnSqVcps126VQgtjr5mYpeakRTbxQrRMnmUhMQatayXVQBZCs9QPjDsCZ7oCQCm2cM2ghn8Li3jqSsB	2025-03-03T03:43:26.000Z	ExecuteIncreaseOrSwapOrder	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj	1740973405	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	76	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	false	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL
FGUbKB13hnNCP2QRn7sFtRfV3UtDi1cD9Uc2CH9GazCG	DGiAWjk73NuEKmh89gbfhewpCcnPEv8ZhpzqAPJYq19k	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	EM6U5vq1Fg416Cn6zxM9zaQCJXihTgytWkg6ET4J6LxZ	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	324215461	So11111111111111111111111111111111111111112	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	109026	4KAibS23vYuZG6EpHzpT6fYMj6vWT3ywo9szUz8krfui	324215461-um3eKnzQnRGtUwwjaY2abGrPWwmnaJrY13xu1pDmJSU71wqdmMCu8nsRG9kXNT2w74Xp5yHLqv4cgpYZvCLd6dv-3	um3eKnzQnRGtUwwjaY2abGrPWwmnaJrY13xu1pDmJSU71wqdmMCu8nsRG9kXNT2w74Xp5yHLqv4cgpYZvCLd6dv	2025-03-03T02:26:25.000Z	ExecuteIncreaseOrSwapOrder	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj	1740968784	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	163	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	false	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL
3YWiNVQeF2T9Vzi3ynCuUvmzb177KLcvShL2zefUdVoh	89PnGf3z3Cp5CZXfwoEdMWZxWgZUyJ4YVXoAx1wD6wM8	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	3zCEgJ5AhEgWfPexLSPCpbWWcqUepRjTnZSvTask3Xqt	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	324281684	So11111111111111111111111111111111111111112	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	109026	E1aziszLoZNFW4LtdZwL5LxG7b9sdCqZKFTts9UpaU4y	324281684-3HbkRt5MKp6bJQrSD1TYRUy46St7wkRprSqh53Cv5TsTwRhT39S6XoyJtcZYxvzDnriQCQ91HsA3o2KHWK3VcPGR-3	3HbkRt5MKp6bJQrSD1TYRUy46St7wkRprSqh53Cv5TsTwRhT39S6XoyJtcZYxvzDnriQCQ91HsA3o2KHWK3VcPGR	2025-03-03T09:42:59.000Z	ExecuteIncreaseOrSwapOrder	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj	1740994978	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	207	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	So11111111111111111111111111111111111111112	false	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj

Example Query

Query with partition filter

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

GMSol_ExecuteIncreaseOrSwapOrderV2_instruction

Order execution records from GMX v1 perpetual futures protocol on Solana. Captures position increases and token swaps with collateral details, market identifiers, and execution fees for analyzing trading activity and liquidity flows.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`position`	`STRING`	Account representing a trading position or vault position in the protocol. Base58-encoded Solana public key.
`order_account`	`STRING`	Account representing the order being executed or acted upon. Base58-encoded Solana public key.
`initial_collateral_token`	`STRING`	Token address used as collateral when the order was created. Typically matches either the long or short token of the market.
`initial_collateral_token_vault`	`STRING`	Solana account address of the vault holding the initial collateral token for the position. Base58-encoded public key representing the program-controlled token account.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`long_token_vault`	`STRING`	Account holding the long position token reserves for the market. Base58-encoded Solana public key.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`short_token_vault`	`STRING`	Account holding the short position token reserves for the market. Base58-encoded Solana public key.
`final_output_token`	`STRING`	Account address of the token received as the final output from the order execution. Base58-encoded Solana public key.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`recent_timestamp`	`INT64`	Unix timestamp representing the most recent acceptable time for instruction execution. Integer value in seconds since the Unix epoch.
`throw_on_execution_error`	`BOOL`	Flag indicating whether the instruction should revert the transaction upon execution failure.

Sample Data

user	owner	store	market	oracle	position	authority	block_slot	long_token	short_token	execution_fee	order_account	surrogate_key	transaction_id	block_timestamp	instruction_type	long_token_vault	recent_timestamp	executing_account	instruction_index	short_token_vault	transaction_index	final_output_token	transaction_signer	initial_collateral_token	throw_on_execution_error	initial_collateral_token_vault
5f1tsdkzKo3AFVcvXfMUczqW4faEWmsRaVvkd4twNc2M	27vqH5WTGPzUsQ7ajGPphKyc2ZiSctHFsnXPHwyqQ8Yh	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	6EnZdBzJsGznoh857PuhbrnrzWYGtZe6xMZiQjAPyFGT	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	6ujb1u3hVAP941r3PUUvxqT2wW9UYP74GHTPv3Yp7xF5	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	359982896	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	81800	CNTLZE2Puwt35tqn1YbRwcWkByiEeFjLfaMrfuXsYGPr	359982896-3jK6VoZwxHrET2b7wgz89dkcdpwB9XZ4PzjZzNt4cbEBjYqRWESAsw9wL2NiktUX2ugJTXSV7TkWSof5zJiF1Y79-3	3jK6VoZwxHrET2b7wgz89dkcdpwB9XZ4PzjZzNt4cbEBjYqRWESAsw9wL2NiktUX2ugJTXSV7TkWSof5zJiF1Y79	2025-08-14T10:46:12.000Z	ExecuteIncreaseOrSwapOrderV2	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1755168370	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	65	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	false	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL
5f1tsdkzKo3AFVcvXfMUczqW4faEWmsRaVvkd4twNc2M	27vqH5WTGPzUsQ7ajGPphKyc2ZiSctHFsnXPHwyqQ8Yh	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	4tM9cPqNpEYmstNdJMCc6rwdq42939w1SRFYoqMsqPQF	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	C3iDLGEVajtnKFzqBkLW34mKqrvWBvKHwi6JecrYdfsn	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	359983917	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	77220	7HwP63oDMoTPL8gsN9J2bQwRRk7igo91FaZP9xu7CQ3f	359983917-5dTZDsEqtScNNDtibGo5pZaqU56xHMiGBxkgeFVmPMFFrAphK9F29vxKmwcVRHMJqv3HRfeD7jG7rELVVgxsp9nS-3	5dTZDsEqtScNNDtibGo5pZaqU56xHMiGBxkgeFVmPMFFrAphK9F29vxKmwcVRHMJqv3HRfeD7jG7rELVVgxsp9nS	2025-08-14T10:52:51.000Z	ExecuteIncreaseOrSwapOrderV2	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1755168771	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	191	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	false	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL
EZpc2BuJ841jCoj66UaWfQiq5NP6w5sVJoGgZX7LeCNR	2GigKBNkDwQmEibDNReSCwoM4w2WvvA9SKmpzbFZxsAu	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	4McvcxhUzpkgk3jKPVCawuBcTqfHJMtunree3uhQznSE	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	359936199	So11111111111111111111111111111111111111112	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	94113	HVbMscQ1uhEziXZBqKwrPYkwV7wALP6BLHJs8wmWNTg5	359936199-279RXYNb48QDSP84aXddRvHLnbugXcPApRWjR9ZF9td5gZiC9j4rnUDRwKArTjjYhR9dGQbyJ2jq4pcMve3puwnr-3	279RXYNb48QDSP84aXddRvHLnbugXcPApRWjR9ZF9td5gZiC9j4rnUDRwKArTjjYhR9dGQbyJ2jq4pcMve3puwnr	2025-08-14T05:39:05.000Z	ExecuteIncreaseOrSwapOrderV2	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj	1755149945	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	335	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	false	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL

Example Query

Query with partition filter

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

GMSol_ExecuteWithdrawal_instruction

Withdrawal execution records from GMX v1 perpetual exchange on Solana. Contains completed liquidity removals with market, oracle, execution fee, and withdrawal account data for analyzing LP activity and protocol liquidity flows.

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.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`withdrawal_account`	`STRING`	Solana account address that holds the withdrawal request being executed. Base58-encoded 32-byte public key identifying the specific withdrawal instruction instance.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`long_token_vault`	`STRING`	Account holding the long position token reserves for the market. Base58-encoded Solana public key.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`short_token_vault`	`STRING`	Account holding the short position token reserves for the market. Base58-encoded Solana public key.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`throw_on_execution_error`	`BOOL`	Flag indicating whether the instruction should revert the transaction upon execution failure.

Sample Data

store	market	oracle	block_slot	execution_fee	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	withdrawal_account	throw_on_execution_error
CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	3M4vW1u8RT3HJSWqgEN1WuiUJZuVjJLQYEWvCHCuk56g	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	353343825	49370	353343825-EMGKVzMH4tMqJcKqdVPwHLSyDZKD9zqnnmfKaRWNHugVBpHakdALpSi9ivr2mRquNY4NvtHXWNsReijS6drnrN9-2	EMGKVzMH4tMqJcKqdVPwHLSyDZKD9zqnnmfKaRWNHugVBpHakdALpSi9ivr2mRquNY4NvtHXWNsReijS6drnrN9	2025-07-14T23:19:24.000Z	ExecuteWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2	84	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	67U2UWAacdJSVZuUmu48u7HeEjpD9DWrJsmXoDXneibW	false
CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	4tM9cPqNpEYmstNdJMCc6rwdq42939w1SRFYoqMsqPQF	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	353186967	44999	353186967-2HzELLRotbQMmvbYYfBnw6fxm53MQittJnE2FzqWJHMbqLdjL65PPvo6FovYgLhfKXH35CooRAVPKZmofWREXswC-2	2HzELLRotbQMmvbYYfBnw6fxm53MQittJnE2FzqWJHMbqLdjL65PPvo6FovYgLhfKXH35CooRAVPKZmofWREXswC	2025-07-14T06:03:59.000Z	ExecuteWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2	219	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	A1hoSbxXT4C7gC654beUhmXevwhfP2md7YreTVEsY4Tf	false
CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	4tM9cPqNpEYmstNdJMCc6rwdq42939w1SRFYoqMsqPQF	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	353223008	44999	353223008-3nQLGppQvuQZHqDdWRMVJKkswyX2kx8LDxsjQAdds1mxbGn9wQ4HkhTd8uXoQebfBkWG5SHkz3tfnnhcwyeFNTAM-2	3nQLGppQvuQZHqDdWRMVJKkswyX2kx8LDxsjQAdds1mxbGn9wQ4HkhTd8uXoQebfBkWG5SHkz3tfnnhcwyeFNTAM	2025-07-14T10:02:00.000Z	ExecuteWithdrawal	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	2	143	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	HwqAypfvn9Zr8mkpcSRykmXHt23gMJbswhrNmUUjwSVc	false

Example Query

Query with partition filter

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

GMSol_Liquidate_instruction

Position liquidation events from GMX v1 perpetual futures protocol on Solana. Records forced position closures with execution fees, vault transfers, and claimable token accounts for risk and liquidation analysis.

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.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`market`	`STRING`	Account representing the trading pair or liquidity pool within the GMX protocol. Base58-encoded Solana public key.
`position`	`STRING`	Account representing a trading position or vault position in the protocol. Base58-encoded Solana public key.
`order_account`	`STRING`	Account representing the order being executed or acted upon. Base58-encoded Solana public key.
`long_token`	`STRING`	Account address of the long position token in the trading pair. Base58-encoded Solana public key.
`long_token_vault`	`STRING`	Account holding the long position token reserves for the market. Base58-encoded Solana public key.
`long_token_escrow`	`STRING`	Solana account address holding long tokens in escrow for this liquidation position. Base58-encoded identifier that temporarily stores collateral tokens during position closure.
`short_token`	`STRING`	Account address of the short position token in the trading pair. Base58-encoded Solana public key.
`short_token_vault`	`STRING`	Account holding the short position token reserves for the market. Base58-encoded Solana public key.
`short_token_escrow`	`STRING`	Account holding short token collateral in escrow for this position. Receives collateral from the user when the position is opened and releases it during settlement or liquidation.
`claimable_long_token_account_for_user`	`STRING`	Token account address where liquidated long token collateral can be claimed by the position owner. Holds funds after liquidation settles, unique per user and market.
`claimable_short_token_account_for_user`	`STRING`	Account address where the user’s claimable short token balance is held after liquidation. This is the destination account for any short token proceeds owed to the liquidated position owner.
`claimable_pnl_token_account_for_holding`	`STRING`	Account address where PnL (Profit and Loss) tokens claimable from this liquidation are held by the protocol. This holding account temporarily stores realized gains or losses before final settlement to the user.
`oracle`	`STRING`	Account providing price feed data for the market or trading pair. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`execution_fee`	`BIGNUMERIC`	Fee paid to execute the order, operation, or liquidation. Integer value representing lamports, Solana’s smallest unit of account.
`recent_timestamp`	`INT64`	Unix timestamp representing the most recent acceptable time for instruction execution. Integer value in seconds since the Unix epoch.
`nonce`	`JSON`	Random 32-byte value used to uniquely identify each liquidation instruction within the GMX v1 protocol on Solana. Represented as a JSON array of 32 integers between 0-255.

Sample Data

user	nonce	owner	store	market	oracle	position	authority	block_slot	long_token	short_token	execution_fee	order_account	surrogate_key	transaction_id	block_timestamp	instruction_type	long_token_vault	recent_timestamp	executing_account	instruction_index	long_token_escrow	short_token_vault	transaction_index	short_token_escrow	transaction_signer	claimable_long_token_account_for_user	claimable_short_token_account_for_user	claimable_pnl_token_account_for_holding
9YKhVJGsuhJEbpkUNNDLyVeePUMoJCiW45YoDekHLkPY	[219,5,199,238,14,19,35,249,167,213,239,233,214,55,175,254,123,41,242,209,42,240,135,211,103,81,248,119,216,158,213,218]	6bBq43FaMEbXbFzPAEpmyCaoMynacJsM95a4C65THksn	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	6EnZdBzJsGznoh857PuhbrnrzWYGtZe6xMZiQjAPyFGT	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	377JFaUBvWHEwQ7X72VhGv2rm8EcpVEpLGUjDnPMLWNN	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	361021712	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	195000	CVuC54kDNMg1nn9LrRckGGyJiNfNvmbwpmrpMDJ23hC	361021712-2cvpmbwGAZ26g34nsy4dxZD6MXs6X2tigEHsC5XQNaPXp91XfnNmgUM8RFeiKwnQ2A2v6FQF8sHJBDZtkrf6dtG2-8	2cvpmbwGAZ26g34nsy4dxZD6MXs6X2tigEHsC5XQNaPXp91XfnNmgUM8RFeiKwnQ2A2v6FQF8sHJBDZtkrf6dtG2	2025-08-19T04:09:02.000Z	Liquidate	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1755576539	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	8	6f1PCNkfpEyK6gqS4qwbzbkNwCG52RA8HQbhQX7gDkuL	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	130	6f1PCNkfpEyK6gqS4qwbzbkNwCG52RA8HQbhQX7gDkuL	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	29WoCdrgZkmrbhd3wsWWX3ZocKBcNqxTtnjdZGrGgCdi	29WoCdrgZkmrbhd3wsWWX3ZocKBcNqxTtnjdZGrGgCdi	221zi7rbvmUjmyVWL5AfUbmTg5PfqVFChK9U5DHVuexK
2MHmDMRWyZnAcZNAPWfDQ7c9c44r4xCFKG1hZspu5wtw	[3,35,201,105,26,126,208,79,163,198,191,40,148,126,8,16,8,193,137,190,96,106,111,36,251,16,181,59,177,65,83,225]	Aw4ijVVboevdTXg18xsLZC2oC4f4YmRa5ZvDyLZTbhyC	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	47cF5oAPycHuH9Q8TbuHSgiaHjypWQN1T8HKkYX7yEw1	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	341Fia18BMAdUzFLL6V5tsVLMi1s3qYGBsNiZfk4Z5pp	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	361051476	So11111111111111111111111111111111111111112	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	92000	7kfVbLGAgjEGUteSitWx5DXG82nC78BAPoB7cdrFwsgK	361051476-611oSZ8Qjw4NkbH224xyVbYLmovHP78RKjnJWbivtJw6EgAbp3dpCnGw7s2WejEzFsMCqW2DXLHDVsCAYHMJPza8-9	611oSZ8Qjw4NkbH224xyVbYLmovHP78RKjnJWbivtJw6EgAbp3dpCnGw7s2WejEzFsMCqW2DXLHDVsCAYHMJPza8	2025-08-19T07:23:46.000Z	Liquidate	FNWATo2tLmYJH4kaDDxwYkFwsmoLVFnapaupisqKtntj	1755588224	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	9	yQ6CahNyBKjPKfdsVQ41TcZcdHZjgxyseY3BR54nTMY	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	111	HRHXoKb9nv4TNJ6jxAQL2SgYRqR963SNHn2qZ219sG7u	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	4ka8JkRThJtDEZvKR35ksCrRumLWABhanpzqCqkBQSL3	BoGWXVfdBJvKgUEuEjbnndwYVA6y9kVz8Vzp3KaZky6g	5oknyknE9GirqyCtLXiTfEaAYLJbnzn6eKJ5XSVYc5EJ
GVbEDGqE8H1LNgtTVc7YBz1vTNnMnRXvUFrMXJ2ZKWw3	[127,139,40,212,241,239,175,219,241,159,174,41,163,138,204,8,248,24,87,2,57,191,207,233,29,110,233,71,98,123,118,65]	uRgKj3yTs14HjLKAqrpcRRfHkkz4jjEwxdBndniipGt	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	6EnZdBzJsGznoh857PuhbrnrzWYGtZe6xMZiQjAPyFGT	AywftYs9BX3GmzQ5RPaaLxnJZGvMpW91RfT5rU5stvUG	9JkDEamszeBq7AFdzmryTRNYcCtgLgbAdHbw2YsPxZXv	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	379724802	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v	195000	GgSpJ3gceP3EZqb9R2G3EP66McR5eMFMcL1FN3U8RX69	379724802-271ntdTLUwJTDWTKCe4utejqiUyPLgus4bhcMZ4UCTQrSkmuj65qKzaw8mYwcpgpz41c17pyUG8aq2WB7JnxoKRH-8	271ntdTLUwJTDWTKCe4utejqiUyPLgus4bhcMZ4UCTQrSkmuj65qKzaw8mYwcpgpz41c17pyUG8aq2WB7JnxoKRH	2025-11-13T03:14:48.000Z	Liquidate	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	1763003686	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	8	An3v9J9LgSjYvENAWJaazAvMsXP5pMPzNsE7NTh3mTK4	9rvMKWhxy98Q3GE8ktHf5WQVmeBa8Y5ECTPiWWN5T1tL	426	An3v9J9LgSjYvENAWJaazAvMsXP5pMPzNsE7NTh3mTK4	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	mpd5u8KRtrfzAMR4RgPXQxeLZNGsJgX4km84mh6PTkF	mpd5u8KRtrfzAMR4RgPXQxeLZNGsJgX4km84mh6PTkF	FKZsXZMkLzbW6HVtVhhL6tWT5CkbctMPk5FvGS3T55HA

Example Query

Query with partition filter

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

GMSol_MarketFeesUpdated_event

Market fee accrual events from GMX V1 perpetual futures protocol on Solana, tracking funding rate updates, borrowing factor changes, and position impact pool distributions. Captures periodic fee calculations used to analyze market dynamics and trader cost structures.

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.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`market_token`	`STRING`	Account representing the liquidity pool token for a GMX trading market. Base58-encoded Solana public key.
`rev`	`INT64`	Schema revision number tracking changes to the event structure or definition. Increments when the table schema is updated to accommodate new fields or data formats.
`borrowing_duration_in_seconds`	`INT64`	Time elapsed in seconds since the last borrowing rate update for this market. Used to calculate the cumulative borrowing fees accrued during this period.
`next_cumulative_borrowing_factor_for_long`	`BIGNUMERIC`	Cumulative borrowing factor for long positions after this market fees update event. Represents the total accumulated borrowing costs over time, with higher values indicating more accrued borrowing fees.
`next_cumulative_borrowing_factor_for_short`	`BIGNUMERIC`	Cumulative borrowing rate multiplier for short positions in this GMX v1 market on Solana. The factor accumulates over time based on the borrowing duration, with zero values indicating no active short positions or borrowing fees.
`funding_duration_in_seconds`	`INT64`	Time elapsed in seconds since the last funding fee update for this market. Used to calculate the funding rate accrual period.
`next_funding_factor_per_second`	`BIGNUMERIC`	Updated funding rate per second for the market after this event. This per-second rate accrues continuously to calculate funding payments between long and short positions.
`delta_funding_amount_per_size`	`JSON`	Change in funding rate per unit of position size for the market, represented as a JSON array of four string-encoded numeric values. Typically zero in sample data, indicating no funding rate adjustment occurred during the update period.
`delta_claimable_funding_amount_per_size`	`JSON`	Change in claimable funding fees per unit of position size, represented as a JSON array with four values for different position/collateral combinations. Typically zero when no funding fee accrual occurs during the update period.
`position_impact_distribution_amount`	`BIGNUMERIC`	Amount of tokens distributed from the position impact pool during this fee update period. Typically zero, indicating no distribution occurred in the observed time window.
`position_impact_duration_in_seconds`	`INT64`	Time elapsed in seconds since the last position impact pool distribution for this GMX V1 market. Used to calculate the rate of fee accumulation from position impacts during the current period.
`next_position_impact_pool_amount`	`BIGNUMERIC`	Updated balance of the position impact fee pool after fee accrual and distribution. Denominated in the market’s base token units, this pool accumulates fees from position impacts and may distribute them over time.

Sample Data

rev	block_slot	event_type	market_token	surrogate_key	transaction_id	block_timestamp	executing_account	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index	funding_duration_in_seconds	borrowing_duration_in_seconds	delta_funding_amount_per_size	next_position_impact_pool_amount	position_impact_duration_in_seconds	delta_claimable_funding_amount_per_size	next_cumulative_borrowing_factor_for_long
8	335638775	MarketFeesUpdated	DAY6Qr1FKgJQFvjJAhFUZUWHzx8UbbbkRmt6G6AYswWG	335638775-58w5Dek5Foz73UJqsWjTLbrypUjJWe7eqMoAod1ZDiAYjqjEhyWa4gacMw6JVZQpAbLUkmW4naZ1JtQYkkooG9WY-5-0	58w5Dek5Foz73UJqsWjTLbrypUjJWe7eqMoAod1ZDiAYjqjEhyWa4gacMw6JVZQpAbLUkmW4naZ1JtQYkkooG9WY	2025-04-24T18:06:05.000Z	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	107	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	836	836	[“0”,“0”,“0”,“0”]	2131	836	[“0”,“0”,“0”,“0”]	35021942848860
12	335639907	MarketFeesUpdated	DAY6Qr1FKgJQFvjJAhFUZUWHzx8UbbbkRmt6G6AYswWG	335639907-5J1DMJQgPByUBrJpyGusSUJQUjJ8y6tsi7VZBqQ6dAtVawfM7MJ9mUTSBsTD926AC1AyEguEJD3qECLrYsonSnn6-5-0	5J1DMJQgPByUBrJpyGusSUJQUjJ8y6tsi7VZBqQ6dAtVawfM7MJ9mUTSBsTD926AC1AyEguEJD3qECLrYsonSnn6	2025-04-24T18:13:40.000Z	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	80	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	319	319	[“0”,“0”,“0”,“0”]	3414	319	[“0”,“0”,“0”,“0”]	49029200574673
13	335640114	MarketFeesUpdated	Dqq58gS1TgRMDouUbdvhhzc51XXTNHG921WLxH9X2eB8	335640114-2CQgnX7vhjt3bA5CLwWBSrRE6qfEWurPVvF4x5mjLXWSskKSYjmNoNbGMfF5TiCcbxWtMzESDQLtUNT2rytLScf3-5-0	2CQgnX7vhjt3bA5CLwWBSrRE6qfEWurPVvF4x5mjLXWSskKSYjmNoNbGMfF5TiCcbxWtMzESDQLtUNT2rytLScf3	2025-04-24T18:15:03.000Z	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	70	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	5	2783	2783	[“0”,“0”,“0”,“0”]	1	2783	[“0”,“0”,“0”,“0”]	17062986436914

Example Query

Query with partition filter

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

GMSol_PositionDecreased_event

Position closure events from GMX v1 perpetual futures markets on Solana, capturing realized profit/loss, fees (order, funding, borrowing), execution prices, and output token amounts. Used for analyzing trading performance, fee structures, and position management patterns across GMX markets.

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.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`market_token`	`STRING`	Account representing the liquidity pool token for a GMX trading market. Base58-encoded Solana public key.
`rev`	`INT64`	Revision number of the event schema or data structure. Typically increases with protocol upgrades or data model changes.
`claimable_funding_long_token_amount`	`BIGNUMERIC`	Amount of long token funding fees accumulated and available to claim from the position. Denominated in the long token’s native units, zero when no funding is owed to the position holder.
`claimable_funding_short_token_amount`	`BIGNUMERIC`	Amount of short token claimable as funding fee credit by the position holder after this decrease event. Denominated in token’s base units and typically zero when position is fully closed.
`execution_price`	`BIGNUMERIC`	Price at which the position was closed, denominated in the market’s base unit. Values like ‘19311865089311’ represent decimal-adjusted token prices.
`initial_size_delta_usd`	`BIGNUMERIC`	USD-denominated position size change at order initiation, before price impact and fees are applied. Matches size_delta_usd when no adjustments occur during execution.
`size_delta_in_tokens`	`BIGNUMERIC`	Decrease in position size measured in token units (not USD). Represents the actual token quantity being closed from the leveraged position.
`size_delta_usd`	`BIGNUMERIC`	Change in position size denominated in USD terms at time of decrease. Reflects the dollar value of the position reduction, typically matching initial_size_delta_usd.
`withdrawable_collateral_amount`	`BIGNUMERIC`	Amount of collateral tokens that can be withdrawn from the position after decrease. Typically zero when position is fully closed (should_remove=true), non-zero for partial decreases.
`price_impact_value`	`BIGNUMERIC`	USD value of the position’s price impact from the size reduction. Represents the cost or benefit of the trade’s effect on the market price, calculated in USD terms with high precision.
`price_impact_diff`	`BIGNUMERIC`	Impact of price changes between order submission and execution, measured in USD value. Typically zero when order fills at expected price.
`should_remove`	`BOOL`	Flag indicating whether the position was completely closed and removed from the protocol. True when the decrease fully exits the position.
`is_output_token_long`	`BOOL`	Indicates whether the primary output token corresponds to the long side of the market position. Typically true when closing long positions or receiving long-side collateral upon position decrease.
`is_secondary_output_token_long`	`BOOL`	Indicates whether the secondary output token is the long token in the market pair. Typically false when there is no secondary output (amount is zero).
`borrowing_fee_amount`	`BIGNUMERIC`	Borrowing fee charged in token units when reducing or closing a leveraged position. Commonly zero or low single-digit values, with occasional higher amounts for larger positions.
`borrowing_fee_amount_for_receiver`	`BIGNUMERIC`	Borrowing fee amount allocated to the fee receiver address in native token units. This portion represents the protocol’s share of borrowing fees collected when a position is decreased.
`funding_fee_amount`	`BIGNUMERIC`	Funding fee paid by the position holder for this decrease event. Measured in token units, often zero but can reach hundreds of thousands when positions have accrued significant funding costs.
`funding_claimable_long_token_amount`	`BIGNUMERIC`	Amount of long token funding fees that can be claimed by the position holder at the time of decrease. Typically zero or small positive values when funding is owed to long position holders.
`funding_claimable_short_token_amount`	`BIGNUMERIC`	Amount of short token claimable from accumulated funding fees for this position. Denominated in the short token’s base units, typically zero when no funding has accrued.
`order_fee_amount_for_pool`	`BIGNUMERIC`	Fee amount allocated to the liquidity pool from this position decrease order. Denominated in native token units; typically split between pool and fee receiver.
`order_fee_amount_for_receiver`	`BIGNUMERIC`	Portion of the order fee allocated to the fee receiver account. Denominated in the output token’s native units.
`order_fee_value`	`BIGNUMERIC`	Fee charged for executing this order expressed in USD value. Includes both pool and receiver portions of the order fee.
`paid_order_and_borrowing_fee_value`	`BIGNUMERIC`	Total USD value of combined order execution fees and borrowing fees paid by the position holder. Represents the sum of protocol fees charged for both trade execution and leverage costs.
`pnl`	`BIGNUMERIC`	Realized profit or loss in USD from the position decrease, calculated as uncapped PnL minus price impact and fees. Can be positive (profit) or negative (loss) as seen in sample values ranging from -776 trillion to +151 trillion units.
`uncapped_pnl`	`BIGNUMERIC`	Unrealized profit or loss before applying any caps or limits imposed by the protocol. May differ from `pnl` when protocol risk controls constrain maximum payout amounts.
`output_amount`	`BIGNUMERIC`	Amount of tokens received from the operation. Integer value representing token quantity in the smallest unit of the token’s decimals.
`secondary_output_amount`	`BIGNUMERIC`	Token amount of the secondary output token received when closing or reducing a position. Represents the second token in dual-token outputs, typically zero when position uses single collateral.
`for_user_output_token_amount`	`BIGNUMERIC`	Primary output token amount distributed directly to the user after position closure. Always zero in sample data, suggesting amounts may be allocated to holding or other receivers in GMX v1 on Solana.
`for_user_secondary_output_token_amount`	`BIGNUMERIC`	Amount of secondary output tokens allocated to the user from the position decrease. Typically zero when positions close completely or when all outputs are in the primary token.
`for_holding_output_token_amount`	`BIGNUMERIC`	Token amount retained by the protocol for holding purposes from the primary output token. Typically zero, indicating funds are distributed rather than held.
`for_holding_secondary_output_token_amount`	`BIGNUMERIC`	Amount of secondary output tokens retained by the protocol rather than distributed to the user. Always zero in sample data, suggesting secondary outputs are typically not held by the protocol.
`insolvent_close_step`	`STRING`	Step identifier indicating which stage of an insolvency closure process this position decrease represents, if applicable. Null when the position was closed normally without insolvency conditions.

Sample Data

pnl	rev	block_slot	event_type	market_token	uncapped_pnl	output_amount	should_remove	surrogate_key	size_delta_usd	transaction_id	block_timestamp	execution_price	order_fee_value	executing_account	instruction_index	transaction_index	funding_fee_amount	price_impact_value	transaction_signer	borrowing_fee_amount	is_output_token_long	size_delta_in_tokens	initial_size_delta_usd	outer_executing_account	outer_instruction_index	order_fee_amount_for_pool	order_fee_amount_for_receiver	is_secondary_output_token_long	borrowing_fee_amount_for_receiver	paid_order_and_borrowing_fee_value
89925027293867360880	44	320578469	PositionDecreased	3pHXv5NsrxwkDdus2e1rTHoaNK9zUUnGwcwg1oeeCGzd	89925027293867360880	54254214	true	320578469-4vZGADM4XJyqHUBM9bA7LcxtLLnUoJXr4hNrYb3xiDLNWJovs8tCSrzNWhwn6ScqTwGPLPNYknWYKGGgcMSCEBWw-6-1	1.93586056616117263912e+21	4vZGADM4XJyqHUBM9bA7LcxtLLnUoJXr4hNrYb3xiDLNWJovs8tCSrzNWhwn6ScqTwGPLPNYknWYKGGgcMSCEBWw	2025-02-14T10:20:58.000Z	19311865089311	774344226464469055	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	1	92	103625	9368688506186	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	24338	true	104898496	1.93586056616117263912e+21	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	6	11576	27009	true	17036	774344226464469055
373264091282898338	80	320550839	PositionDecreased	5KSsaGZebQSAxZcYuzRz5JWCxoYztWYcfTcRBWLCwoMX	373264091282898338	737892	true	320550839-ouoYvdV7zAp3qTLjxHwB8QnjjsLZdA81bqcMW7i3vS2oBK7wzkQ3EXovaFojhnBpQaeX9AFAExXjm3ZjLR6YSGp-6-1	3.991892450523117101662e+21	ouoYvdV7zAp3qTLjxHwB8QnjjsLZdA81bqcMW7i3vS2oBK7wzkQ3EXovaFojhnBpQaeX9AFAExXjm3ZjLR6YSGp	2025-02-14T07:18:33.000Z	2703402419407526	1596756980209246840	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	1	145	0	28660180541510	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	1	true	1476756	3.991892450523117101662e+21	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	6	177	413	true	0	1596756980209246840
-776175248819500000000	70	320501803	PositionDecreased	5KSsaGZebQSAxZcYuzRz5JWCxoYztWYcfTcRBWLCwoMX	-776175248819500000000	39419244	true	320501803-2xNw75QfLsp8yJKBsk6heFRqhrUTNRGfJXn7kLnvFWR7XEB5XMHVrNk3wGNkqrcTrgQjzknT8eXAk2RDecSWij12-6-1	1.199249885757405e+23	2xNw75QfLsp8yJKBsk6heFRqhrUTNRGfJXn7kLnvFWR7XEB5XMHVrNk3wGNkqrcTrgQjzknT8eXAk2RDecSWij12	2025-02-14T01:54:44.000Z	2686569754603258	47969995430296200000	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	1	71	283034	11025088665960854	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	43387	false	44927608	1.199249885757405e+23	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	6	143922	335818	false	30370	47969995430296200000

Example Query

Query with partition filter

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

GMSol_PositionIncreased_event

Position increase events from GMX v1 perpetual futures protocol on Solana. Records leverage position expansions with collateral changes, execution prices, fees (order, funding, borrowing), and price impact for analyzing trading patterns and protocol fee generation.

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.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`market_token`	`STRING`	Account representing the liquidity pool token for a GMX trading market. Base58-encoded Solana public key.
`rev`	`INT64`	Schema version or revision number for this event record. Used for tracking data model changes over time.
`claimable_funding_long_token_amount`	`BIGNUMERIC`	Amount of long token available to claim from accumulated funding fees. Denominated in the market’s long token, typically zero unless position has accrued positive funding.
`claimable_funding_short_token_amount`	`BIGNUMERIC`	Amount of short token that can be claimed from accumulated funding payments on this position. Measured in token’s native decimals, typically zero when no funding has accrued.
`collateral_delta_amount`	`BIGNUMERIC`	Amount of collateral token added to or removed from the position, denominated in the collateral token’s native units. This is the net collateral change after accounting for fees and price impact.
`execution_price`	`BIGNUMERIC`	Actual execution price for the position increase order, denominated in the price unit for that market. Represents the price at which the position size was actually increased.
`price_impact_amount`	`BIGNUMERIC`	Net token amount impact from price slippage when opening or increasing the position. Can be positive (favorable) or negative (unfavorable) based on market depth and order size.
`price_impact_value`	`BIGNUMERIC`	Dollar value impact on position from moving market price, positive indicates favorable slippage and negative indicates unfavorable. Calculated based on the difference between execution price and mid-market price multiplied by position size.
`size_delta_in_tokens`	`BIGNUMERIC`	Change in position size measured in tokens of the underlying asset. Represents the number of index tokens added to the trader’s leveraged position.
`borrowing_fee_amount`	`BIGNUMERIC`	Fee charged for borrowing liquidity to open or maintain the leveraged position, denominated in the position’s collateral token. Typically zero for newly opened positions as shown in samples.
`borrowing_fee_amount_for_receiver`	`BIGNUMERIC`	Borrowing fee portion allocated to the fee receiver for this position increase. Denominated in the position’s collateral token.
`funding_fee_amount`	`BIGNUMERIC`	Funding fee paid by the trader to rebalance long/short positions in the perpetual market. Zero in most samples, but accrues when position is imbalanced relative to market.
`funding_claimable_long_token_amount`	`BIGNUMERIC`	Amount of long token funding fees claimable by the position holder after the increase. Typically zero immediately after position creation, accumulates over time based on funding rates.
`funding_claimable_short_token_amount`	`BIGNUMERIC`	Amount of short token claimable by the position owner from accumulated funding fees. Denominated in the market’s short token units and can be zero if no funding is owed.
`order_fee_amount_for_pool`	`BIGNUMERIC`	Fee amount allocated to the liquidity pool from the position increase order. Denominated in the collateral token with precision matching the token’s decimals.
`order_fee_amount_for_receiver`	`BIGNUMERIC`	Portion of the order execution fee allocated to the fee receiver address. Denominated in the collateral token’s smallest unit.
`order_fee_value`	`BIGNUMERIC`	Fee charged for this position increase order in USD value terms. Denominated in the same units as size_delta_usd for value comparison.
`paid_order_and_borrowing_fee_value`	`BIGNUMERIC`	Total USD value of combined order execution fees and borrowing fees paid by the trader for this position increase. Always matches order_fee_value in sample data, indicating no borrowing fees charged.
`acceptable_price`	`BIGNUMERIC`	Maximum execution price acceptable to trader when opening or increasing this position. Slippage protection threshold expressed in the same unit as execution_price.
`collateral_increment_amount`	`BIGNUMERIC`	Initial collateral amount added to the position before fees are deducted. Always equal to or slightly greater than collateral_delta_amount, with the difference representing paid fees.
`size_delta_usd`	`BIGNUMERIC`	Change in position size denominated in USD. Positive values indicate the position increased by this amount, measured with high precision.
`index_token_price_min`	`BIGNUMERIC`	Maximum price of the index token (the underlying asset being traded) at the time of position increase. Used with index_token_price_max to establish the price range for this derivative position.
`index_token_price_max`	`BIGNUMERIC`	Maximum price of the index token (position’s underlying asset) used for this position increase. Expressed in scaled integer format representing the price in USD at transaction execution time.
`long_token_price_min`	`BIGNUMERIC`	Price floor for the long token in the market pair during execution. Denominated in smallest token units with 14 decimal places of precision.
`long_token_price_max`	`BIGNUMERIC`	Maximum oracle price of the long token in the market at execution time. Denominated in USD with high precision (14 decimal places based on sample values).
`short_token_price_min`	`BIGNUMERIC`	Minimum price of the short token in the market pair during position increase execution. Used for calculating collateral value and exposure in USD terms.
`short_token_price_max`	`BIGNUMERIC`	Maximum price of the short token in the market pair at the time of the position increase event. Denominated in 1e12 precision units, typically representing a stablecoin or alternative collateral asset in the GMX V1 Solana market.

Sample Data

rev	block_slot	event_type	market_token	surrogate_key	size_delta_usd	transaction_id	block_timestamp	execution_price	order_fee_value	acceptable_price	executing_account	instruction_index	transaction_index	price_impact_value	transaction_signer	price_impact_amount	long_token_price_max	long_token_price_min	size_delta_in_tokens	index_token_price_max	index_token_price_min	short_token_price_max	short_token_price_min	collateral_delta_amount	outer_executing_account	outer_instruction_index	order_fee_amount_for_pool	collateral_increment_amount	order_fee_amount_for_receiver	paid_order_and_borrowing_fee_value
257	354899088	PositionIncreased	2wxH1sGLH4Rui6Ws4F1nFDHtW3aJDG1fAF3gZVJ7ktwV	354899088-2WyrftDgUtpxwieHCapLU2g8qPTZ3L1ksTfP9TYJoPeuo4VE7Vu2tRUKaVqr751g4TvGiseEGp8XjaYnywzUxqyv-3-3	103025939978548000000	2WyrftDgUtpxwieHCapLU2g8qPTZ3L1ksTfP9TYJoPeuo4VE7Vu2tRUKaVqr751g4TvGiseEGp8XjaYnywzUxqyv	2025-07-22T02:17:14.000Z	25742957070696	37089338392277280	25679215614428	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	194	339401417985	AM96Xpr1gYTGVaycDa4YDXoEF2iF4npe94NTXKJcCFM3	0	99992000000000	99979700000000	4002102	25751517000000	25742960000000	99992000000000	99979700000000	3499630	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	111	3500000	259	37089338392277280
259	354906918	PositionIncreased	2wxH1sGLH4Rui6Ws4F1nFDHtW3aJDG1fAF3gZVJ7ktwV	354906918-wVTqp4jMWDDg4y6YpCEQvLTZ29KQik2HrPnN6HEFmsVLVGo3c5Q3SqDQN5DiE842sY2KMi2WmCozpcXNjtfyaZY-3-3	2.96668649407899539951205e+23	wVTqp4jMWDDg4y6YpCEQvLTZ29KQik2HrPnN6HEFmsVLVGo3c5Q3SqDQN5DiE842sY2KMi2WmCozpcXNjtfyaZY	2025-07-22T03:08:50.000Z	25880473880124	178001189644739700237	25987109887277	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	25	-5280856102295503976	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	-204137	99988000000000	99977300000000	11463030035	25880013000000	25869210000000	99988000000000	99977300000000	593446949	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	534125	595227365	1246291	178001189644739700237
263	354990976	PositionIncreased	2wxH1sGLH4Rui6Ws4F1nFDHtW3aJDG1fAF3gZVJ7ktwV	354990976-AtjBWreMdrn4cESQYLPjSXkkyqYPAjXK775gTwuUpCdW6Wt8ZxkNd6rcx975Ecg5RLJEQuudBxjJDE32TrXXJGA-3-3	3.07573110843864e+21	AtjBWreMdrn4cESQYLPjSXkkyqYPAjXK775gTwuUpCdW6Wt8ZxkNd6rcx975Ecg5RLJEQuudBxjJDE32TrXXJGA	2025-07-22T12:22:26.000Z	25623440556857	1845438665063183753	25708912885827	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	98	-110065598752954483	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	-4298	99997200000000	99988300000000	120035836	25622523000000	25612760000000	99997200000000	99988300000000	15379573	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	5537	15398029	12919	1845438665063183753

Example Query

Query with partition filter

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

GMSol_TradeEvent_event

Trade execution and position modification events from GMX V1 perpetual futures protocol on Solana. Contains comprehensive order fills, position updates, fees, profit/loss, and funding calculations for analyzing trader performance and protocol metrics.

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.
`event_type`	`STRING`	Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
`authority`	`STRING`	Account authorized to execute administrative or privileged operations within the program. Base58-encoded Solana public key.
`market_token`	`STRING`	Account representing the liquidity pool token for a GMX trading market. Base58-encoded Solana public key.
`position`	`STRING`	Account representing a trading position or vault position in the protocol. Base58-encoded Solana public key.
`order_account`	`STRING`	Account representing the order being executed or acted upon. Base58-encoded Solana public key.
`user`	`STRING`	Account that initiates or owns the transaction or operation. Base58-encoded Solana public key.
`store`	`STRING`	Account representing the GMX protocol state storage or data registry. Base58-encoded Solana public key.
`final_output_token`	`STRING`	Account address of the token received as the final output from the order execution. Base58-encoded Solana public key.
`slot`	`INT64`	Solana slot number when the trade event was recorded. Represents the specific blockchain height at which this trade transaction occurred.
`ts`	`INT64`	Unix timestamp of when the trade event occurred. Typically represents the transaction execution time on-chain.
`trade_id`	`STRING`	Unique identifier for the trade event assigned by the GMX protocol on Solana. Sequential numeric value increasing with each new trade execution.
`flags`	`INT64`	Binary flags indicating trade characteristics such as direction (long/short) and action type (increase/decrease). Typically represented as small integers encoding multiple boolean states.
`execution_price`	`BIGNUMERIC`	Executed price of the trade in the market’s base unit. Expressed as a high-precision value showing the actual fill price including price impact and spread.
`price_impact_value`	`BIGNUMERIC`	Price impact of the trade measured in USD, negative for unfavorable slippage. Calculated as the difference between execution price and oracle price multiplied by position size.
`price_impact_diff`	`BIGNUMERIC`	Price impact difference between expected and actual execution prices, expressed in USD. Typically zero when price impact is fully realized at execution time.
`before_size_in_usd`	`BIGNUMERIC`	Position size in USD before the trade event occurred. Zero for new positions, populated with previous position value for modifications or closures.
`before_size_in_tokens`	`BIGNUMERIC`	Position size denominated in tokens before this trade event occurred. Typically zero for new position openings, non-zero for position modifications or closures.
`before_collateral_amount`	`BIGNUMERIC`	Collateral amount posted to the position before this trade event, denominated in the collateral token’s smallest unit. Zero when opening a new position.
`before_borrowing_factor`	`BIGNUMERIC`	Borrowing factor applied to the position at the start of the trade event. Used to calculate accrued borrowing fees based on position size and duration.
`before_funding_fee_amount_per_size`	`BIGNUMERIC`	Cumulative funding fee per unit of position size at the time before this trade event. Denominated in the same units as position size, typically zero for new positions.
`before_long_token_claimable_funding_amount_per_size`	`BIGNUMERIC`	Claimable funding fee amount per unit of position size for the long token before the trade execution. Measured in funding fee tokens per size unit, typically zero for new positions.
`before_short_token_claimable_funding_amount_per_size`	`BIGNUMERIC`	Claimable funding fee rate per unit of position size for the short token before this trade event. Denominated in the short token and used to calculate accumulated funding rewards for short positions.
`before_increased_at`	`INT64`	Unix timestamp when the position was last increased before this trade event. Null when opening a new position (indicated by 0).
`before_decreased_at`	`INT64`	Unix timestamp of the previous position decrease for this trader’s position. Typically zero when opening a fresh position.
`before_updated_at_slot`	`INT64`	Solana slot number when the position state was last modified before this trade event. Null (0) indicates the position did not exist prior to this event.
`before_trade_id`	`STRING`	Trade identifier of the position before this event was processed. Null or ‘0’ when opening a new position, populated with the previous trade ID when modifying an existing position.
`after_size_in_usd`	`BIGNUMERIC`	Position size in USD after the trade execution. Null when position is fully closed (size reduced to zero).
`after_size_in_tokens`	`BIGNUMERIC`	Position size in tokens after the trade execution. Null when position is fully closed; otherwise represents the remaining token-denominated size of the leveraged position.
`after_collateral_amount`	`BIGNUMERIC`	Collateral amount in the position after this trade event was executed. Denominated in the collateral token’s smallest unit.
`after_borrowing_factor`	`BIGNUMERIC`	Cumulative borrowing factor applied to the position after this trade event. Represents the accrued borrowing fees per unit of position size over time.
`after_funding_fee_amount_per_size`	`BIGNUMERIC`	Cumulative funding fee accrued per unit of position size after this trade event. Denominated in the funding token and represents the funding rate state for calculating position-level funding obligations.
`after_long_token_claimable_funding_amount_per_size`	`BIGNUMERIC`	Claimable funding amount per unit of position size for the long token after the trade execution. Represents accrued funding fees that traders can claim, denominated in the long token of the market pair.
`after_short_token_claimable_funding_amount_per_size`	`BIGNUMERIC`	Claimable funding fee per unit of position size in short tokens after the trade event. Represents updated accumulated funding payments denominated in the short token that can be claimed by position holders.
`after_increased_at`	`INT64`	Unix timestamp indicating when the position was last increased. Null (0) if position has not been increased yet.
`after_decreased_at`	`INT64`	Timestamp when the position size was last decreased, measured in Unix epoch seconds. Null or zero if the position has never been reduced.
`after_updated_at_slot`	`INT64`	Solana slot number when the position state was last updated after this trade event. Null when position is newly created or fully closed.
`after_trade_id`	`STRING`	Unique identifier for the trade position after this event occurred. Matches trade_id for position-opening events, increments on subsequent modifications.
`order_fee_for_pool_amount`	`BIGNUMERIC`	Fee amount allocated to the liquidity pool from this trade execution. Denominated in the smallest unit of the collateral token (typically lamports for Solana).
`order_fee_for_receiver_amount`	`BIGNUMERIC`	Order fee portion allocated to the fee receiver account, denominated in the collateral token. Typically ranges from 40-75 million units based on position size.
`total_borrowing_fee_amount`	`BIGNUMERIC`	Total borrowing fee charged on the position in raw token units. Collected incrementally as traders hold leveraged positions over time.
`borrowing_fee_for_receiver_amount`	`BIGNUMERIC`	Portion of the borrowing fee allocated to the order receiver, denominated in the collateral token. Null when no borrowing fee is charged on the trade.
`funding_fee_amount`	`BIGNUMERIC`	Funding fee paid or received by the position holder for this trade event. Sign indicates direction: positive values are fees paid to the protocol, negative values represent fees received by the trader.
`claimable_funding_fee_long_token_amount`	`BIGNUMERIC`	Amount of long token funding fees that can be claimed by the trader on this event. Typically zero for new positions, non-zero when closing positions with accumulated funding.
`claimable_funding_fee_short_token_amount`	`BIGNUMERIC`	Funding fees claimable in the short token denomination after position update. Amount reflects protocol-level funding payments between long and short sides, denominated in the market’s short token.
`liquidation_fee_amount`	`BIGNUMERIC`	Liquidation fee charged when a position is liquidated due to insufficient collateral. Null or zero for normal trade closures; populated only during forced liquidations.
`liquidation_fee_for_receiver_amount`	`BIGNUMERIC`	Portion of liquidation fee allocated to the fee receiver account when a position is liquidated. Zero for standard trade events, populated only during liquidations.
`pnl`	`BIGNUMERIC`	Realized profit or loss (PnL) on the position in USD, calculated as the difference between entry and exit value. Positive values indicate profit, negative values indicate loss, and zero typically indicates a position increase.
`uncapped_pnl`	`BIGNUMERIC`	Unrealized profit or loss on the position before applying any caps or limits. May differ from the final realized PnL due to platform-imposed constraints on maximum loss or profit per trade.
`output_amount`	`BIGNUMERIC`	Amount of tokens received from the operation. Integer value representing token quantity in the smallest unit of the token’s decimals.
`secondary_output_amount`	`BIGNUMERIC`	Secondary amount of tokens received in a trade that produced multiple outputs. Null for single-output trades; populated when position closure or complex swaps result in dual token distributions.
`transfer_out_executed`	`INT64`	Execution status flag indicating whether token transfers out of the position have been completed. Typically set to 255 when transfers are executed successfully.
`transfer_out_long_token`	`BIGNUMERIC`	Amount of long token transferred out during trade execution. Denominated in the long token’s smallest unit, null when no long token transfer occurs.
`transfer_out_short_token`	`BIGNUMERIC`	Amount of short tokens transferred out to the user as part of trade settlement. Denominated in the short token’s native units; commonly zero when collateral or output uses different tokens.
`transfer_out_final_output_token`	`BIGNUMERIC`	Amount of the final output token transferred out to the user after trade settlement. Typically non-zero when positions are closed or partially closed, matching the `output_amount` value in USDC (EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v).
`transfer_out_secondary_output_token`	`BIGNUMERIC`	Amount of secondary output token transferred out to the user, in raw token units. Typically zero for single-token trades, non-zero for multi-token order settlements.
`transfer_out_long_token_for_claimable_account_of_user`	`BIGNUMERIC`	Amount of long tokens transferred to the user’s claimable account during trade settlement. Typically zero unless funding fees or other claimable amounts are being distributed.
`transfer_out_short_token_for_claimable_account_of_user`	`BIGNUMERIC`	Amount of short tokens transferred to the user’s claimable account upon trade settlement. Remains zero when positions are opened or closed without claimable funding transfers.
`transfer_out_long_token_for_claimable_account_of_holding`	`BIGNUMERIC`	Amount of long tokens transferred to the holding claimable account during trade settlement. Typically zero unless specific holding account claims are processed.
`transfer_out_short_token_for_claimable_account_of_holding`	`BIGNUMERIC`	Amount of short token transferred to the holding claimable account during trade settlement. Typically zero when position is fully closed or no claimable funding applies.
`index_price_min`	`BIGNUMERIC`	Maximum index price used for this trade’s execution on the GMX v1 Solana market. Denominated in USD with 18 decimal precision.
`index_price_max`	`BIGNUMERIC`	Maximum index price of the asset during this trade event, denominated in wei-equivalent units (18 decimals). Used as the upper bound for price calculations in position valuation and PnL settlement.
`long_price_min`	`BIGNUMERIC`	Maximum price of the long token in the market at trade execution time. Used for oracle-based price bounds in position calculations.
`long_price_max`	`BIGNUMERIC`	Maximum price of the long token during this trade event. Typically represents a stablecoin price in smallest units (6 decimal precision for USDC).
`short_price_min`	`BIGNUMERIC`	Short token minimum price at time of trade execution in basis point-denominated units. Represents the lower bound of the price range for the short token in the GMX v1 perpetuals market.
`short_price_max`	`BIGNUMERIC`	Maximum price of the short collateral token during the trade execution window. Typically represents a stablecoin value around 1.0 USD with 14-decimal precision.

Sample Data

ts	slot	user	flags	store	position	trade_id	authority	block_slot	event_type	market_token	order_account	surrogate_key	after_trade_id	long_price_max	long_price_min	transaction_id	block_timestamp	execution_price	index_price_max	index_price_min	short_price_max	short_price_min	after_size_in_usd	executing_account	instruction_index	transaction_index	after_increased_at	final_output_token	price_impact_value	transaction_signer	after_size_in_tokens	after_updated_at_slot	transfer_out_executed	after_borrowing_factor	after_collateral_amount	outer_executing_account	outer_instruction_index	order_fee_for_pool_amount	order_fee_for_receiver_amount	after_funding_fee_amount_per_size	after_long_token_claimable_funding_amount_per_size	after_short_token_claimable_funding_amount_per_size
1752202428	352503061	HkqFPaP3E6Bcfgkq4GvZwS7xoKaU6ei6skWtQ9HhtiKd	7	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	2HLxgAFkDkYYVZFudWURYoRHsZ2cE8KSyjsbT9MHH5FC	1995	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	352503061	TradeEvent	Dqq58gS1TgRMDouUbdvhhzc51XXTNHG921WLxH9X2eB8	2vBXMEcjbQauhn8Z4DZiQffaZUWZt5LqRtGWVjnWwq6q	352503061-RUfRTNnkDwNZ4jEddkHhMM34zDz2JWwEy62smx4nHmgwJ4YZLKRfHW5LuCqYMk7eDM6hY1r38sC4Yf1YAYWJLN4-3-7	1995	100002000000000	99985200000000	RUfRTNnkDwNZ4jEddkHhMM34zDz2JWwEy62smx4nHmgwJ4YZLKRfHW5LuCqYMk7eDM6hY1r38sC4Yf1YAYWJLN4	2025-07-11T02:53:48.000Z	116743884067164805	116739060000000000	116727800000000000	100002000000000	99985200000000	1.861295141699739765964215e+25	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	7	184	1752202428	11111111111111111111111111111111	-768952810625599009189	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	159434060	352503061	255	413959025515747280	2504360034	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	28347998	66145328	1047344565611669	3064176750890042	3064176750890042
1752202323	352502800	HkqFPaP3E6Bcfgkq4GvZwS7xoKaU6ei6skWtQ9HhtiKd	7	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	2HLxgAFkDkYYVZFudWURYoRHsZ2cE8KSyjsbT9MHH5FC	1991	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	352502800	TradeEvent	Dqq58gS1TgRMDouUbdvhhzc51XXTNHG921WLxH9X2eB8	3fJNPiriL75UTZoCnfAx7kFL6DhANbwzdN2d7xpGn2RB	352502800-2YxpgEr4dxkTyeenT2Jo8bhhBuswTCvCMUAEkGTBd6CyCmQiLoUkfkHj7tkhUrMoCSRehujVKD7REVjKVboSPBsG-3-7	1991	99999600000000	99986100000000	2YxpgEr4dxkTyeenT2Jo8bhhBuswTCvCMUAEkGTBd6CyCmQiLoUkfkHj7tkhUrMoCSRehujVKD7REVjKVboSPBsG	2025-07-11T02:52:03.000Z	116654610785264208	116649140000000000	116645650000000000	99999600000000	99986100000000	2.08468967231468758117149e+25	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	7	273	1752202323	11111111111111111111111111111111	-977502128668398136825	DfrKKdMa2NdEjErxrHEM6JTM8hCvckkdCBfYVynZQZpt	178706153	352502800	255	413927599738791274	2804936818	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	31750068	74083490	1047313322451200	3064176750890042	3064176750890042
1752202586	352503441	HkqFPaP3E6Bcfgkq4GvZwS7xoKaU6ei6skWtQ9HhtiKd	7	CTDLvGGXnoxvqLyTpGzdGLg9pD6JexKxKXSV8tqqo8bN	2HLxgAFkDkYYVZFudWURYoRHsZ2cE8KSyjsbT9MHH5FC	2001	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	352503441	TradeEvent	Dqq58gS1TgRMDouUbdvhhzc51XXTNHG921WLxH9X2eB8	4hoivcZDeifeq5V4CMYqpkAwviiK61EDh4wBoxM4VW9T	352503441-5pervSGt9bSNBf17EJWDMXX3Y47YwZcokMwZLWhxKvAsXNY3xykMxkrPx7n65XBoYCxUWNEzr5NHce69Vv4X4kj7-3-7	2001	99999000000000	99987200000000	5pervSGt9bSNBf17EJWDMXX3Y47YwZcokMwZLWhxKvAsXNY3xykMxkrPx7n65XBoYCxUWNEzr5NHce69Vv4X4kj7	2025-07-11T02:56:26.000Z	116690173713671386	116685930000000000	116684260000000000	99999000000000	99987200000000	1.662140108773387083881565e+25	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	7	211	1752202586	11111111111111111111111111111111	-604312618186828968467	2D35F11pJ6a7jh9amXxmMcMUXGscqgXHHwGFforhQM6z	142440452	352503441	255	413984518971998033	2236492496	Gmso1uvJnLbawvw7yezdfCDcPydwW2s2iqG3w6MDucLo	3	25314310	59066722	1047397844824764	3064176750890042	3064176750890042

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

GMSol_CloseWithdrawal_instruction

GMSol_CreateDeposit_instruction

GMSol_CreateWithdrawal_instruction

GMSol_ExecuteDecreaseOrder_instruction

GMSol_ExecuteDecreaseOrderV2_instruction

GMSol_ExecuteDeposit_instruction

GMSol_ExecuteIncreaseOrSwapOrder_instruction

GMSol_ExecuteIncreaseOrSwapOrderV2_instruction

GMSol_ExecuteWithdrawal_instruction

GMSol_Liquidate_instruction

GMSol_MarketFeesUpdated_event

GMSol_PositionDecreased_event

GMSol_PositionIncreased_event

GMSol_TradeEvent_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​GMSol_CloseWithdrawal_instruction

​GMSol_CreateDeposit_instruction

​GMSol_CreateWithdrawal_instruction

​GMSol_ExecuteDecreaseOrder_instruction

​GMSol_ExecuteDecreaseOrderV2_instruction

​GMSol_ExecuteDeposit_instruction

​GMSol_ExecuteIncreaseOrSwapOrder_instruction

​GMSol_ExecuteIncreaseOrSwapOrderV2_instruction

​GMSol_ExecuteWithdrawal_instruction

​GMSol_Liquidate_instruction

​GMSol_MarketFeesUpdated_event

​GMSol_PositionDecreased_event

​GMSol_PositionIncreased_event

​GMSol_TradeEvent_event

Tables

GMSol_CloseWithdrawal_instruction

GMSol_CreateDeposit_instruction

GMSol_CreateWithdrawal_instruction

GMSol_ExecuteDecreaseOrder_instruction

GMSol_ExecuteDecreaseOrderV2_instruction

GMSol_ExecuteDeposit_instruction

GMSol_ExecuteIncreaseOrSwapOrder_instruction

GMSol_ExecuteIncreaseOrSwapOrderV2_instruction

GMSol_ExecuteWithdrawal_instruction

GMSol_Liquidate_instruction

GMSol_MarketFeesUpdated_event

GMSol_PositionDecreased_event

GMSol_PositionIncreased_event

GMSol_TradeEvent_event