gmx_v1_avalanche

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
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	10	0xd152c7f25db7f4b95b7658323c5f33d176818ee4	52363803	255300000000000000	10000000000000000	2024-10-28T18:23:41.000Z	0x926157efc6892a60d92de4260c5b4441f7323cb34edd6b4ed830f8b7771ac874
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	13	0xd152c7f25db7f4b95b7658323c5f33d176818ee4	52368151	3637979000000000000000	140300000000000000000	2024-10-28T20:53:14.000Z	0x86c40bf03ad7fbf2046caa2c827f8c9b2d771b8244ece686de9063f1dbdd00be
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	63	0xd152c7f25db7f4b95b7658323c5f33d176818ee4	52349467	27382056507524281019	1049523055098669261	2024-10-28T10:10:39.000Z	0x4160460f958f936c8de411ebcf0dae94ea80e6b848130d09311851361122e7e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	14299907533852028159884410000000	28	17407989	10865365499469666	2022-07-16T16:12:19.000Z	0x066929b3d35512d91acd16dd2a28787931c23bb93e5c8c6424cd08015704b195
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	618442626725943580205500000000	53	17408130	444507027043731	2022-07-16T16:15:54.000Z	0xe8896a16194b03875132508860f8694622613de651f90be8ad7cddc3bfca772b
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	64886715186802523046905600000000	36	17407826	49684310009956142	2022-07-16T16:06:59.000Z	0x8c430c190be9d11cdc2808898dab56adff07e3b0164b039cf042cddbb6390f81

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x130966628846bfd36ff31a822705796e8cb8c18d	43756510800000000000000000000	9	14126387	43756510800000000	2022-05-01T07:39:03.000Z	0xc81eecfed238b32d58551d710832e29869fb9bfa4f40b3aceca237e293b4bb4a
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x130966628846bfd36ff31a822705796e8cb8c18d	87662426860000000000000000000	9	14126357	87662426860000000	2022-05-01T07:38:04.000Z	0x622dc81bf81397cf477ac269abb90fc402bb082bab64eb7bcaa9a4c4b39cca79
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x130966628846bfd36ff31a822705796e8cb8c18d	43756510800000000000000000000	25	14126394	43756510800000000	2022-05-01T07:39:17.000Z	0x7c87542eb0410772342e3368e37cbb4dd6571ad0b4d0ac69e85c70d26e0a073f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
1704112605584033125439061000000	0x06699fdaaf4e75a49455c30166d4896490a9543246785488a514563c28960032	0x9ab2de34a33fb459b538c43f251eb825645e8595	false	3010800000000000000000000000000000	false	112	0xd334533980c201c1b93e39bbe6bd1e04be5c0f5d	10554659	780628770308764601667000000000000	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	2022-02-06T08:00:55.000Z	0xb20763127de9b53330ccf81c835911daf94c41da230f51c26f0c4ecd49239f9c	0	0x130966628846bfd36ff31a822705796e8cb8c18d
5104400907328889246719167900000	0xdd3042491dd35f49b5f40a1e1f003ff6fd08b006fc76adbcd6d1bbf233f69013	0x9ab2de34a33fb459b538c43f251eb825645e8595	false	3060560000000000000000000000000000	false	27	0x50d6102774fe54dd7d073a27f45dffacb51fa667	10583225	1146798676101749999262900000000000	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	2022-02-06T23:49:15.000Z	0x5570007f46226675c3cfd928b12613cd82d4796d026fe4f10d2f4440e8d47385	0	0x130966628846bfd36ff31a822705796e8cb8c18d
218443947530012234195423904000	0x4938df4c2d138302d2b0f78d120bdcc436d271f9fd2904e872c14b56de4888c5	0x9ab2de34a33fb459b538c43f251eb825645e8595	false	3015255000000000000000000000000000	true	87	0xf2aaa1f7a4ac15324191ef7b91fbdeebd0e681f5	10565875	0	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	2022-02-06T14:14:35.000Z	0x357592c50005dbda8a56cca9da5dced6e7b035487fa369a7e7746c0e2d4435be	50000000000000000000000000000000	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
5900244614600000000000000000000	0x190a24948a0b4522edd4a22d2727cdcb04181f45038b8375ae94fec85cac91e9	0x9ab2de34a33fb459b538c43f251eb825645e8595	false	19151950000000000000000000000000000	true	23	0x7e0cb28572a0b3a7f5132382726337758dc4a655	21154433	5900244614600000000000000000000000	0x152b9d0fdc40c096757f570a51e494bd4b943e50	2022-10-16T21:58:51.000Z	0x2555f2b1e6543dbcb1e371593f9bb43ed575b8431c9284a29f72aa9fb90e34a7	199332729522000000000000000000000	0x152b9d0fdc40c096757f570a51e494bd4b943e50
3528943176271400000000000000000	0x190a24948a0b4522edd4a22d2727cdcb04181f45038b8375ae94fec85cac91e9	0x9ab2de34a33fb459b538c43f251eb825645e8595	false	19143000000000000000000000000000000	true	23	0x7e0cb28572a0b3a7f5132382726337758dc4a655	21154394	3528943176271400000000000000000000	0x152b9d0fdc40c096757f570a51e494bd4b943e50	2022-10-16T21:57:32.000Z	0xf8b4afab1569352d7724d387ad32d0ad6c6e0e235bfe097de7361a8e8d6c8870	119220306840000000000000000000000	0x152b9d0fdc40c096757f570a51e494bd4b943e50
26155857651620000000000000000000	0x2faa08fe06f4b8685b3d1a68e3a9faa11b0235848069a99a956a3d5c3ca2f093	0x9ab2de34a33fb459b538c43f251eb825645e8595	false	19418000000000000000000000000000000	true	15	0xf7d8653684dec3130cfee601b395c5792b5fe60d	21151042	26155857651620000000000000000000000	0x152b9d0fdc40c096757f570a51e494bd4b943e50	2022-10-16T20:03:16.000Z	0x92dc4089750141dcb60d8063f087276c92f8ef48770028eaf98694a3f2746d04	3033201117520000000000000000000000	0x152b9d0fdc40c096757f570a51e494bd4b943e50

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
0x83585ecace257e926c8bb1f41ca9d23b0471d0defd3d6e1098003597e87616d6	0x9ab2de34a33fb459b538c43f251eb825645e8595	301048733520000000000000000000000	false	true	8	0x3666d5421ff3ef93bd4f48bfc00e9b21c9b98be4	20721109	20011000000000000000000000000000000	9873941266480000000000000000000	0x50b7545627a5162f82a992c33b87adc75187b218	2022-10-06T14:06:50.000Z	1479356	0x53e371f40cac97e46bd255888ec0f4f52032acb2657f3a10c051f72c7e55ac65	0x50b7545627a5162f82a992c33b87adc75187b218
0x2a1adb38f67abe4cf24dda9994b6135a6d1709d300d1f7a5fe95bd76f3f339bd	0x9ab2de34a33fb459b538c43f251eb825645e8595	295972806860000000000000000000000	false	false	25	0x1c81e2b70c9f1cf75cc3c1e2ff2a76e7b5798d66	20700241	20405000000000000000000000000000000	9704027193140000000000000000000	0x50b7545627a5162f82a992c33b87adc75187b218	2022-10-06T02:02:49.000Z	295972806	0x9dd498046232506903778320e3d46f967439f396c7dd83b3891a34697730eaa8	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664
0x8c985fc1832613f66f8d40ddf0302cad97826197768bcb890275d977a23424e4	0x9ab2de34a33fb459b538c43f251eb825645e8595	591945657447840853948167000000000	false	false	6	0xae9cda1d8ee9718be130ae545019496ae1413258	20699813	17550000000000000000000000000000	19408054342552159146051833000000	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	2022-10-06T01:48:09.000Z	591945657	0x7b54069f7ad7681ea29aa7638f3f4be90d228d9d4058a33ed6461cf6c2ed3b64	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	24	0x3b9645b2432374d9b3fa766b95d5a793d7241190	47217323	37991596807220278060065	62198743	2024-06-26T18:11:42.000Z	0x9698f16ea93a0bc49900c32af77a987bf9ed061f894cc23a78b907b3a39f7aca
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	15	0x5517c5f22177bcf7b320a2a5daf2334344efb38c	47223454	80045333333457662230	131313	2024-06-26T21:41:31.000Z	0xbf739c08f52afb7b7aab0ddcf6e9fd015021a14927502c0d41116409a080c241
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	26	0x3b9645b2432374d9b3fa766b95d5a793d7241190	47217301	37991596807206587102347	62198743	2024-06-26T18:10:58.000Z	0x82607b002344b50884cdbfd0d2c75be9adf1e13aa91bb261354020a3d2c9f901

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	12	0x9a6e6ca75ff2fd0b70027bbe844f5afa612dd773	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	3252679544733171712	0x130966628846bfd36ff31a822705796e8cb8c18d	28239656	56173775737541875466	2023-04-02T22:53:07.000Z	0xaecd004271c6b6b7cda87245b0e9484d808c638f5759f9b64d58b75f92db9bd5	20	56061428186066791715
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	80	0xb382247667fe8ca5327ca1fa4835ae77a9907bc8	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	8853337445840715776	0x130966628846bfd36ff31a822705796e8cb8c18d	28210309	157040499614322616434	2023-04-02T06:26:00.000Z	0x5c17a9d0834f98d4baae9d77ba88d1526d0b25014c7e82351a467bc6241f48b0	34	156506561915633919538
0x9ab2de34a33fb459b538c43f251eb825645e8595	false	8	0x9a6e6ca75ff2fd0b70027bbe844f5afa612dd773	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	1737841418338041856	0x130966628846bfd36ff31a822705796e8cb8c18d	28209805	30858850065428609236	2023-04-02T06:09:01.000Z	0xca69c82c317e2833bcc01427ecd3df26ea12c06e1d6a8056497b0d97f58522ff	34	30753929975206151964

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gmx_v1_avalanche.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