Skip to main content

Tables

EventEmitter_EventLog_event

Raw event log data from GMX v2 EventEmitter contract on Avalanche containing structured event parameters for deposits, withdrawals, position updates, and liquidations. Used for reconstructing detailed protocol activity with typed event data stored as nested key-value records.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_msgSenderSTRINGAddress of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string.
in_eventNameSTRINGName of the event emitted by the GMX v2 EventEmitter contract. String value identifying the specific event type such as OrderCreated, SetUint, SwapInfo, or DepositExecuted.
in_eventNameHashSTRINGKeccak-256 hash of the event name. 66-character hex string including 0x prefix.
in_eventDataSTRUCT<addressItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, uintItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, intItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, boolItems STRUCT<items ARRAY<STRUCT<key STRING, value BOOL>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<BOOL>>>>, bytes32Items STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, bytesItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, stringItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>>Structured event parameter data organized by data type. Contains nested structs for addressItems, uintItems, intItems, boolItems, bytes32Items, bytesItems, and stringItems, each with items arrays of key-value pairs and arrayItems for array values.
addressremovedlog_indexblock_numberin_eventDatain_eventNamein_msgSenderblock_timestampin_eventNameHashtransaction_hash
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false1635808498{“intItems”:{“items”:[{“key”:“basePnlUsd”,“value”:“-5451727321932920000000000000000”}],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“positionCollateralAmount”,“value”:“5714142”},{“key”:“remainingCostUsd”,“value”:“142663000000000000000000000000”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“orderKey”,“value”:“0xc3bbda09b579132a155154419a2b623ee8e7e797e4060ae6d872b7198140176f”}],“arrayItems”:[]}}InsolventClose0x931c18af613f56289253f0eed57f315de7dbafcd2023-09-29T12:07:01.000Z0xcfa5615fee0f8a3be5094b3bca17ec4275ce73d648845f3e7c10226bb9e0eed00x3ef84749c6a88711614636c9fa23b91ac43c65da03fdb0e094a7d15c113550a3
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false1033663898{“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“longTokenAmount”,“value”:“1000000000000000000”},{“key”:“shortTokenAmount”,“value”:“0”},{“key”:“receivedMarketTokens”,“value”:“13670360180899785388”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x4eb89130db09a7f125e70232a7ea5925dcdb53670900cd08bff6a4bf13539c9d”}],“arrayItems”:[]}}DepositExecuted0x65d406bdb91813e8bc55090a7fcfed971737ce052023-08-08T18:33:15.000Z0x2856020a9644603d22d7b029b5649a55d708b88d9049150f146ac26c4107b8800xf49176f16688f32aee480e865e07a3a55dd72271bf47bdd50cdd00efb60e0265
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false1233634340{“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“longTokenAmount”,“value”:“0”},{“key”:“shortTokenAmount”,“value”:“47473237”},{“key”:“receivedMarketTokens”,“value”:“51490121646155590390”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0xba91248eb1678c5fb90b80f2aa7005351be021265ab1f331d81c394b60b12d4a”}],“arrayItems”:[]}}DepositExecuted0x65d406bdb91813e8bc55090a7fcfed971737ce052023-08-08T01:50:30.000Z0x2856020a9644603d22d7b029b5649a55d708b88d9049150f146ac26c4107b8800x6662b15763070d7090ab5011eceeb643528dffeaf8eff6430517a75e06e57f4d
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_avalanche.EventEmitter_EventLog_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EventEmitter_EventLog1_event

Event logs from GMX V2 protocol’s EventEmitter contract on Avalanche, containing structured event data with typed parameters (addresses, integers, strings, bytes) for swaps, orders, and protocol operations. Enables detailed analysis of protocol activity and state changes through decoded event parameters.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_msgSenderSTRINGAddress of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string.
in_eventNameSTRINGName of the event emitted by the GMX v2 EventEmitter contract. String value identifying the specific event type such as OrderCreated, SetUint, SwapInfo, or DepositExecuted.
in_eventNameHashSTRINGKeccak-256 hash of the event name. 66-character hex string including 0x prefix.
in_topic1STRINGFirst indexed topic parameter of the event. 66-character hex string including 0x prefix, typically containing a key identifier, market address, or account address depending on the event type.
in_eventDataSTRUCT<addressItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, uintItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, intItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, boolItems STRUCT<items ARRAY<STRUCT<key STRING, value BOOL>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<BOOL>>>>, bytes32Items STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, bytesItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, stringItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>>Structured event parameter data organized by data type. Contains nested structs for addressItems, uintItems, intItems, boolItems, bytes32Items, bytesItems, and stringItems, each with items arrays of key-value pairs and arrayItems for array values.
addressremovedin_topic1log_indexblock_numberin_eventDatain_eventNamein_msgSenderblock_timestampin_eventNameHashtransaction_hash
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false0x000000000000000000000000913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf4036102638{“intItems”:{“items”:[{“key”:“priceImpactUsd”,“value”:“222857942010605680133224735000”},{“key”:“priceImpactAmount”,“value”:“20728410668022190”}],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“tokenInPrice”,“value”:“999950000000000000000000”},{“key”:“tokenOutPrice”,“value”:“10751328000000”},{“key”:“amountIn”,“value”:“74777956”},{“key”:“amountInAfterFees”,“value”:“74740568”},{“key”:“amountOut”,“value”:“6972133015903766090”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“market”,“value”:“0x913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf”},{“key”:“receiver”,“value”:“0xa2351b384384e0d632781adf423d7a14458d8375”},{“key”:“tokenIn”,“value”:“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”},{“key”:“tokenOut”,“value”:“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”}],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“orderKey”,“value”:“0x2e7d12dbf5436b3673cd2794d2a8290361465468f3369fd5b5c7e15148c7eda3”}],“arrayItems”:[]}}SwapInfo0xee027373517a6d96fe62f70e9a0a395cb5a39eee2023-10-06T10:40:40.000Z0x93534d650a9b8eb67820f87038b8e8b36b741c6f7eb14d1a7ac5027e80fd4a820x7b08ab1e9bb5c9ba236a4a9f4157310778ef317902f31ad20721d3b2ceadad01
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false0x000000000000000000000000913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf2636088121{“intItems”:{“items”:[{“key”:“priceImpactUsd”,“value”:“-401655052519408574882036990000”},{“key”:“priceImpactAmount”,“value”:“-38595501984033548”}],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“tokenInPrice”,“value”:“10406784000000”},{“key”:“tokenOutPrice”,“value”:“1000001630000000000000000”},{“key”:“amountIn”,“value”:“7409869528787623049”},{“key”:“amountInAfterFees”,“value”:“7366087118133438165”},{“key”:“amountOut”,“value”:“76657152”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“market”,“value”:“0x913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf”},{“key”:“receiver”,“value”:“0x913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf”},{“key”:“tokenIn”,“value”:“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”},{“key”:“tokenOut”,“value”:“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”}],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“orderKey”,“value”:“0x238615ac87c421364c40f0921ab0381d7cf7178c0f87853f4484fc7b64b0ec57”}],“arrayItems”:[]}}SwapInfo0xee027373517a6d96fe62f70e9a0a395cb5a39eee2023-10-06T02:32:47.000Z0x93534d650a9b8eb67820f87038b8e8b36b741c6f7eb14d1a7ac5027e80fd4a820x89b793463b05f72de264eeb97aee09243bcf270171796b1913cb3ac8939ff8bb
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false0x000000000000000000000000fb02132333a79c8b5bd0b64e3abcca5f7faf29371736108368{“intItems”:{“items”:[{“key”:“priceImpactUsd”,“value”:“933272733928328671585442699880”},{“key”:“priceImpactAmount”,“value”:“3390”}],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[{“key”:“tokenInPrice”,“value”:“999950000000000000000000”},{“key”:“tokenOutPrice”,“value”:“275239500000000000000000000”},{“key”:“amountIn”,“value”:“55082398965”},{“key”:“amountInAfterFees”,“value”:“55054857766”},{“key”:“amountOut”,“value”:“200018667”}],“arrayItems”:[]},“bytesItems”:{“items”:[],“arrayItems”:[]},“stringItems”:{“items”:[],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“market”,“value”:“0xfb02132333a79c8b5bd0b64e3abcca5f7faf2937”},{“key”:“receiver”,“value”:“0x32b80026753267331cb6cd161c6e12d6da437262”},{“key”:“tokenIn”,“value”:“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”},{“key”:“tokenOut”,“value”:“0x152b9d0fdc40c096757f570a51e494bd4b943e50”}],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“orderKey”,“value”:“0x7110c884eb6809e4323c7082d110fec2aec9617f2fbcee3a5b5cccd15fb3f64c”}],“arrayItems”:[]}}SwapInfo0xd3b6e962f135634c43415d57a28e688fb4f15a582023-10-06T13:47:29.000Z0x93534d650a9b8eb67820f87038b8e8b36b741c6f7eb14d1a7ac5027e80fd4a820xc00db992a0fd7a2d2f3bf173bb1ee0bca37244f0333eb4dedec22d18128aed62
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_avalanche.EventEmitter_EventLog1_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EventEmitter_EventLog2_event

Raw event logs from GMX v2’s EventEmitter contract on Avalanche, capturing order cancellations, deposit cancellations, and other protocol actions with structured event data including account addresses, order keys, and cancellation reasons.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_msgSenderSTRINGAddress of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string.
in_eventNameSTRINGName of the event emitted by the GMX v2 EventEmitter contract. String value identifying the specific event type such as OrderCreated, SetUint, SwapInfo, or DepositExecuted.
in_eventNameHashSTRINGKeccak-256 hash of the event name. 66-character hex string including 0x prefix.
in_topic1STRINGFirst indexed topic parameter of the event. 66-character hex string including 0x prefix, typically containing a key identifier, market address, or account address depending on the event type.
in_topic2STRINGAccount address associated with the event, stored as a hex-encoded bytes32 value with zero-padding. Represents the user or contract involved in the GMX v2 action (order, deposit, or withdrawal).
in_eventDataSTRUCT<addressItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, uintItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, intItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, boolItems STRUCT<items ARRAY<STRUCT<key STRING, value BOOL>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<BOOL>>>>, bytes32Items STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, bytesItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>, stringItems STRUCT<items ARRAY<STRUCT<key STRING, value STRING>>, arrayItems ARRAY<STRUCT<key STRING, value ARRAY<STRING>>>>>Structured event parameter data organized by data type. Contains nested structs for addressItems, uintItems, intItems, boolItems, bytes32Items, bytesItems, and stringItems, each with items arrays of key-value pairs and arrayItems for array values.
addressremovedin_topic1in_topic2log_indexblock_numberin_eventDatain_eventNamein_msgSenderblock_timestampin_eventNameHashtransaction_hash
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false0x5a39a4b70a530bb9f28364a2cebde40dae9411e7786b00b8ab54360c00e1258a0x00000000000000000000000000cbd3f851debf7e2d2b2b50ad7fb5754e60fe79248248436{“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“reasonBytes”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[{“key”:“reason”,“value”:“USER_INITIATED_CANCEL”}],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“account”,“value”:“0x00cbd3f851debf7e2d2b2b50ad7fb5754e60fe79”}],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x5a39a4b70a530bb9f28364a2cebde40dae9411e7786b00b8ab54360c00e1258a”}],“arrayItems”:[]}}OrderCancelled0x32a0258007a6ea78265a5ae4dbb28f176be4a8eb2024-07-21T11:25:36.000Z0xc7bb288dfd646d5b6c69d5099dd75b72f9c8c09ec9d40984c8ad8182357ae4b20x8586e4bafca2533e2d4d4263e1b5c9e2ee31ef0925aea57138a7006f74688c28
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false0x4ab93432ff6b82ff9d5a9fdcc2e4367bb2de1f2cd20a3cf059db7dfce4f7aead0x0000000000000000000000004f7d9ebe792cb4f4729de9328a8889c1e49b37b02448259936{“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“reasonBytes”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[{“key”:“reason”,“value”:“USER_INITIATED_CANCEL”}],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“account”,“value”:“0x4f7d9ebe792cb4f4729de9328a8889c1e49b37b0”}],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x4ab93432ff6b82ff9d5a9fdcc2e4367bb2de1f2cd20a3cf059db7dfce4f7aead”}],“arrayItems”:[]}}OrderCancelled0x32a0258007a6ea78265a5ae4dbb28f176be4a8eb2024-07-21T17:50:27.000Z0xc7bb288dfd646d5b6c69d5099dd75b72f9c8c09ec9d40984c8ad8182357ae4b20xb709e675f4bc32ee4d724872c8bae6584a2cb4f8e998168bc76f18c63b872251
0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26false0x45dd743cdb940d06fe0e84344c9a9a77e681d341ff738c2f0bbdc6f716fecbfe0x0000000000000000000000004f7d9ebe792cb4f4729de9328a8889c1e49b37b0548261066{“intItems”:{“items”:[],“arrayItems”:[]},“boolItems”:{“items”:[],“arrayItems”:[]},“uintItems”:{“items”:[],“arrayItems”:[]},“bytesItems”:{“items”:[{“key”:“reasonBytes”,“value”:“0x”}],“arrayItems”:[]},“stringItems”:{“items”:[{“key”:“reason”,“value”:“USER_INITIATED_CANCEL”}],“arrayItems”:[]},“addressItems”:{“items”:[{“key”:“account”,“value”:“0x4f7d9ebe792cb4f4729de9328a8889c1e49b37b0”}],“arrayItems”:[]},“bytes32Items”:{“items”:[{“key”:“key”,“value”:“0x45dd743cdb940d06fe0e84344c9a9a77e681d341ff738c2f0bbdc6f716fecbfe”}],“arrayItems”:[]}}OrderCancelled0x32a0258007a6ea78265a5ae4dbb28f176be4a8eb2024-07-21T18:26:48.000Z0xc7bb288dfd646d5b6c69d5099dd75b72f9c8c09ec9d40984c8ad8182357ae4b20xa91b5cebc1fcf41214d4efd25e11013f3aad70857a857dc46ea57d3c3bd5845a
Query with partition filter
SELECT *
FROM `tt-contracts.gmx_v2_avalanche.EventEmitter_EventLog2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100