gmx_v1_arbitrum

Tables

Vault_BuyUSDG_event

USDG stablecoin purchase events emitted by vault contracts, recording the deposited token type, amount, receiving account, minted USDG quantity, and fee charged in basis points.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_usdgAmount`	`STRING`	Amount of USDG tokens involved in the buy or sell transaction. String-encoded integer representing the USDG quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	in_token	log_index	in_account	block_number	in_usdgAmount	in_tokenAmount	block_timestamp	transaction_hash
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	7	0x321f653eed006ad1c29d174e17d96351bde22649	13218426	10809793750000000000	36925	2022-05-29T17:02:02.000Z	0x782a2fb7a25b65c3af4d9bd198c9e4fc8e25381f561cc8e858ae47b3ab8353d0
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	6	0x321f653eed006ad1c29d174e17d96351bde22649	13224732	14578583740000000000	50096	2022-05-29T19:41:28.000Z	0x6f29dbc7d012c65af4827829abfbeb936a487b2a8b35a482ab20740ff12aee17
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	7	0x321f653eed006ad1c29d174e17d96351bde22649	13162780	238695741410000000000	822066	2022-05-29T00:10:55.000Z	0x762256c93fa9bc729ada54c6f53f5dd1e204afd5ddc8549ab91287ee39daa906

Example Query

Query with partition filter

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

Vault_CollectMarginFees_event

Margin fee collection events emitted by perpetual futures vault contracts. Records fee amounts in both native token and USD-denominated values charged on leveraged trading positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeUsd`	`STRING`	USD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
`in_feeTokens`	`STRING`	Fee amount collected in token units. String-encoded integer value representing the quantity of tokens charged as the fee.

Sample Data

address	removed	in_token	in_feeUsd	log_index	block_number	in_feeTokens	block_timestamp	transaction_hash
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	7652790364024900000000000000000	2	65225934	7652790364024900000	2023-02-27T22:54:17.000Z	0x5770cd3838adc99312ca09502f8a33971e6ded0d41ea2df80821f5023b0087d0
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	19118062561806835000000000000000	7	65095294	19118062561806835000	2023-02-27T13:35:45.000Z	0x944279def3ac4611cf05aadd2f0e8ece24485fa7511b0646c71d02352ced43ec
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	7607147479150000000000000000000	10	65187999	7607147479150000000	2023-02-27T20:04:49.000Z	0xf1ac0067ec6156724f4ec0ddba9040feddc24418dee2b4b732506a0f096b6cb4

Example Query

Query with partition filter

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

Vault_CollectSwapFees_event

Swap fee collection events emitted by GMX-style vault contracts, recording the token address, fee amount in both native token units and USD-denominated value. Used for protocol revenue tracking and fee distribution analytics across perpetual trading and liquidity platforms.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_feeUsd`	`STRING`	USD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
`in_feeTokens`	`STRING`	Fee amount collected in token units. String-encoded integer value representing the quantity of tokens charged as the fee.

Sample Data

address	removed	in_token	in_feeUsd	log_index	block_number	in_feeTokens	block_timestamp	transaction_hash
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	53843403266608194	2	26777479	53843403266608194000000000000	2022-09-26T09:42:43.000Z	0x83edeee0e46ba32105e02cd63a3f5ad2f607e389302ad638c92e9e00799f5fb9
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	1472000000000000000	2	26714545	1472000000000000000000000000000	2022-09-26T04:33:00.000Z	0xe7dd529575b32a656ce0d9436fe9806cac0c5843288e07bb4a0656f00cc55ead
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	26100515534493927	2	26757772	26100515534493927000000000000	2022-09-26T08:08:03.000Z	0x71c021b1bf1f772f2a2406499ac5bfe88819ee8a734eb207d4d44d570522128b

Example Query

Query with partition filter

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

Vault_DecreasePosition_event

Emitted when a leveraged trading position is reduced or closed, recording position size changes, collateral withdrawals, and associated fees. Used for tracking position lifecycle and calculating realized PnL in perpetual futures protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexToken`	`STRING`	Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralDelta`	`STRING`	Change in collateral amount for the position. String-encoded integer value representing the delta in the smallest unit of the collateral token.
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_key	address	removed	in_price	in_isLong	log_index	in_account	block_number	in_sizeDelta	in_indexToken	block_timestamp	transaction_hash	in_collateralDelta	in_collateralToken
1252292140924000000000000000000	0x99d6fd9e02409915db50d115b35acad461976e6e262e0a5134d4adb07b43a870	0x489ee077994b6658eafa855c308275ead8097c4a	false	97598935000000000000000000000000000	false	20	0xb16504509342b4c40d35af544aa21c7113afd74a	288219556	1252292140924000000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2024-12-24T19:58:13.000Z	0x6eaaf1511da018e3ce51ce401c8a0a2c3055189b6db724a6414fc5b1a2b66a0b	0	0x17fc002b466eec40dae837fc4be5c67993ddbd6f
162828883501701925200000000000000	0x09ba60759e3ada0eb8863f175fa92275a650a71086434f806030fb09f5ebbb60	0x489ee077994b6658eafa855c308275ead8097c4a	false	97346600000000000000000000000000000	true	30	0xf967691c33524c01c7ace2d43c0487ae528f31db	288153707	111070179741952200000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2024-12-24T15:22:38.000Z	0x0b6e6e25ed99b5aedb5c16cbd160e00e1a1c67e60ac188e203ab53fbff7a24b0	0	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f
4823319339368765121413600000000	0x17419aba666bf736227aafc5de29b747190be135078678a084efdf64efc1817f	0x489ee077994b6658eafa855c308275ead8097c4a	false	98282748000000000000000000000000000	true	19	0x5c650adbf72c3ccf9628a8cecdf3b3f2767b8c16	288213663	4000000000000000000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2024-12-24T19:33:30.000Z	0x11e1f4a225863532710ab0eb5c6be0c9b60a2a08b594aa64d553cb7b927bcc84	221684746893712767011996091174483	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f

Example Query

Query with partition filter

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

Vault_IncreasePosition_event

Perpetual futures position increase events emitted when traders add collateral or size to existing leveraged positions. Records account, collateral token, index token, position size change in USD, execution price, fees, and position direction (long/short).

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexToken`	`STRING`	Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralDelta`	`STRING`	Change in collateral amount for the position. String-encoded integer value representing the delta in the smallest unit of the collateral token.
`in_sizeDelta`	`STRING`	Change in position size denominated in USD. String-encoded integer value representing the delta in smallest unit with extended precision (30 decimal places).
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	in_key	address	removed	in_price	in_isLong	log_index	in_account	block_number	in_sizeDelta	in_indexToken	block_timestamp	transaction_hash	in_collateralDelta	in_collateralToken
10270948423132360000000000000000	0x0261e0fe3cebce6dde35533d106ef6d50b6ee7f646b443b68b094ab30550e8dd	0x489ee077994b6658eafa855c308275ead8097c4a	false	20849000000000000000000000000000000	false	16	0x53d8edf6a54239eb785ec72213919fb6b6b73598	17719490	9529694047680000000000000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2022-07-15T23:47:20.000Z	0xb626d29479c49d1e15df2e2babbd7fbf9b6c07097cf1d143f0cdb7bf666fc307	493310440000000000000000000000000	0x17fc002b466eec40dae837fc4be5c67993ddbd6f
7068001609227807451253400000000	0x16115331b904150c90d7dfed056b43daad12c4041c1d452c0876c33403d37461	0x489ee077994b6658eafa855c308275ead8097c4a	false	1183300000000000000000000000000000	false	8	0x53d8edf6a54239eb785ec72213919fb6b6b73598	17656472	7068001609227807451253400000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-07-15T01:05:16.000Z	0xcf5785e129d8d34ccee7bac47c6b5bf4dd1f47f339f815a8b4e2267935a3aba3	360468082070618180071000000000000	0x17fc002b466eec40dae837fc4be5c67993ddbd6f
65710872162485065710064500000000	0xdc4348b2c36b29ec8874e66d6539cb6a5cfbd28c935ef000926814f58ce67742	0x489ee077994b6658eafa855c308275ead8097c4a	false	1204700000000000000000000000000000	false	8	0x24f8d92794a283b454d1fc32722f51a4f3bc1ae5	17674372	65710872162485065710064500000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	2022-07-15T08:15:42.000Z	0x616578ff76a0f27728eff770276c87377ebe1171859a8ae9289cedf921af8704	15000000000000000000000000000000000	0x17fc002b466eec40dae837fc4be5c67993ddbd6f

Example Query

Query with partition filter

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

Vault_LiquidatePosition_event

Perpetual futures position liquidation events recording forced closure of undercollateralized positions. Contains account, collateral token, index token, position size, mark price, and realized profit/loss for risk management and leverage analytics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_key`	`STRING`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_indexToken`	`STRING`	Contract address of the index token used to price the position. Hex-encoded, 0x-prefixed, 42-character string.
`in_isLong`	`BOOL`	Boolean flag indicating whether the position is long or short. True represents a long position (betting on price increase), false represents a short position (betting on price decrease).
`in_size`	`STRING`	Size of the position in the derivative contract. String-encoded integer value representing the position magnitude in the smallest unit of the relevant asset or USD-denominated value.
`in_collateral`	`STRING`	Contract address of the collateral asset or vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_reserveAmount`	`STRING`	Amount of tokens reserved in the protocol for the position or operation. String-encoded integer value representing the reserved quantity in the smallest unit of the relevant token.
`in_realisedPnl`	`STRING`	Realized profit or loss from the position at close or liquidation. String-encoded integer value representing the net gain or loss in the smallest unit of the collateral token.
`in_markPrice`	`STRING`	Market price of the index token at the time of position liquidation. String-encoded integer representing the price with 30 decimal places of precision.

Sample Data

in_key	address	in_size	removed	in_isLong	log_index	in_account	block_number	in_markPrice	in_collateral	in_indexToken	block_timestamp	in_reserveAmount	transaction_hash	in_collateralToken
0xd5f2692621cd71acd9d3de62e92a132981528132e79d64d04d0905a4e95c4df8	0x489ee077994b6658eafa855c308275ead8097c4a	250492015799360864665500000000000	false	true	33	0xb7ba3d3fb852825a89ae6bcfd8971603798b102d	169027121	44904238000000000000000000000000000	8831378481900639135334500000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2024-01-10T12:49:20.000Z	549672	0x5d57cb0adb4800c7923d6fc8fb587cdf4ae34768d329732583147b6dd5f33eda	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f
0xedc63f1efe85cbe43c8663636ad949bd5825a3d9fd1742a2f3d5e89343e1ab34	0x489ee077994b6658eafa855c308275ead8097c4a	510235821320041200000000000000000	false	true	20	0xacf4130fe32f9a4a1c7918fb921a517a84a82d2d	169022271	45193222000000000000000000000000000	24525567950229958800000000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2024-01-10T12:29:16.000Z	1087061	0xaeec29f1f04962adde983fc30115b5a43d5629c8d59aee98ec300fdff9865f2b	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f
0xfafdf8620dfa97f7c9792f0cb4a709819965fed9e1e87e0045e95de7cb1953f9	0x489ee077994b6658eafa855c308275ead8097c4a	598645089635361553500000000000000	false	true	70	0xde71b35417586d49305149640ddc02ac7dd9ce71	169179225	46935348000000000000000000000000000	11931691240164638446500000000000	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	2024-01-10T23:28:16.000Z	1261707	0x1d6d547ccd98f1c1ebd4f018874c446cea8a10410a067daa9bd8bd58d24d04e3	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f

Example Query

Query with partition filter

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

Vault_SellUSDG_event

USDG stablecoin redemption events emitted when users sell USDG tokens back to the vault for an underlying collateral token. Records the account address, USDG amount burned, output token and amount received, and fee charged in basis points.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_usdgAmount`	`STRING`	Amount of USDG tokens involved in the buy or sell transaction. String-encoded integer representing the USDG quantity in its smallest denomination.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	in_token	log_index	in_account	block_number	in_usdgAmount	in_tokenAmount	block_timestamp	transaction_hash
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	15	0x1f3555e9572af36c2a0f0ec54fa929c5f7d04223	2094916	30661986108618079864159	54694681	2021-10-10T20:25:36.000Z	0xe31de9d377f4b81c68c2a6e011dcc37d2b37565ce838ecd4aff85932e97154de
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	11	0xa906f338cb21815cbc4bc87ace9e68c87ef8d8f1	2088601	1433405952893173019616271	404275120541167135681	2021-10-10T16:21:37.000Z	0xd784c14ef7914abac53b589db0600dd1dadac2d64b518dd18690598b00d63179
0x489ee077994b6658eafa855c308275ead8097c4a	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	15	0xa906f338cb21815cbc4bc87ace9e68c87ef8d8f1	2087116	2202862154343192434379	619564661606860479	2021-10-10T15:35:32.000Z	0x0f0fb0680f2902e77ebfd06c477e7b2ecd484e35df82edf44de0f7dc24249a21

Example Query

Query with partition filter

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

Vault_Swap_event

Swap events emitted by decentralized exchange vault contracts containing input/output token addresses, amounts, pool identifiers, and swap fee data. Tracks token exchanges executed through vault-based automated market maker protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_amountOutAfterFees`	`STRING`	Amount of output tokens received after swap fees are deducted. Numeric string representing the net token quantity in its smallest denomination.
`in_feeBasisPoints`	`STRING`	Fee charged for the transaction expressed in basis points. String-encoded integer where 1 basis point equals 0.01%.

Sample Data

address	removed	log_index	in_account	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	transaction_hash	in_feeBasisPoints	in_amountOutAfterFees
0x489ee077994b6658eafa855c308275ead8097c4a	false	26	0x00000000d4fb3aec73968d00fdf92fc98f366ba5	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	80872788626548215635	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	236958753	80872788	2024-07-28T14:12:06.000Z	0x72693c7ee50457baf62b2a4674a62bfcdee8d30df312d1ed9249fbca3411320d	1	80864700
0x489ee077994b6658eafa855c308275ead8097c4a	false	47	0x00000000d4fb3aec73968d00fdf92fc98f366ba5	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	204818810380889835489	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	236900271	204818810	2024-07-28T10:08:09.000Z	0x66e69b46778ed1b7b11a2ef034d665759541aff40950a5f799b3ab02f43aea03	1	204798328
0x489ee077994b6658eafa855c308275ead8097c4a	false	40	0x00000000d4fb3aec73968d00fdf92fc98f366ba5	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	332220157508482189220	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	236901578	332220157	2024-07-28T10:13:37.000Z	0x8dc93b36af3311e0ce70a43e607d832194a655f2518b8113fcb7748af273f69e	1	332186934

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Vault_BuyUSDG_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePosition_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_SellUSDG_event

Vault_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Vault_BuyUSDG_event

​Vault_CollectMarginFees_event

​Vault_CollectSwapFees_event

​Vault_DecreasePosition_event

​Vault_IncreasePosition_event

​Vault_LiquidatePosition_event

​Vault_SellUSDG_event

​Vault_Swap_event

Tables

Vault_BuyUSDG_event

Vault_CollectMarginFees_event

Vault_CollectSwapFees_event

Vault_DecreasePosition_event

Vault_IncreasePosition_event

Vault_LiquidatePosition_event

Vault_SellUSDG_event

Vault_Swap_event