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.Columns
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_msgSender | STRING | Address of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string. |
in_eventName | STRING | Name 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_eventNameHash | STRING | Keccak-256 hash of the event name. 66-character hex string including 0x prefix. |
in_eventData | STRUCT<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. |
Sample Data
Sample Data
| address | removed | log_index | block_number | in_eventData | in_eventName | in_msgSender | block_timestamp | in_eventNameHash | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 16 | 35808498 | {“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”:[]}} | InsolventClose | 0x931c18af613f56289253f0eed57f315de7dbafcd | 2023-09-29T12:07:01.000Z | 0xcfa5615fee0f8a3be5094b3bca17ec4275ce73d648845f3e7c10226bb9e0eed0 | 0x3ef84749c6a88711614636c9fa23b91ac43c65da03fdb0e094a7d15c113550a3 |
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 10 | 33663898 | {“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”:[]}} | DepositExecuted | 0x65d406bdb91813e8bc55090a7fcfed971737ce05 | 2023-08-08T18:33:15.000Z | 0x2856020a9644603d22d7b029b5649a55d708b88d9049150f146ac26c4107b880 | 0xf49176f16688f32aee480e865e07a3a55dd72271bf47bdd50cdd00efb60e0265 |
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 12 | 33634340 | {“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”:[]}} | DepositExecuted | 0x65d406bdb91813e8bc55090a7fcfed971737ce05 | 2023-08-08T01:50:30.000Z | 0x2856020a9644603d22d7b029b5649a55d708b88d9049150f146ac26c4107b880 | 0x6662b15763070d7090ab5011eceeb643528dffeaf8eff6430517a75e06e57f4d |
Example Query
Example Query
Query with partition filter
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.Columns
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_msgSender | STRING | Address of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string. |
in_eventName | STRING | Name 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_eventNameHash | STRING | Keccak-256 hash of the event name. 66-character hex string including 0x prefix. |
in_topic1 | STRING | First 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_eventData | STRUCT<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. |
Sample Data
Sample Data
| address | removed | in_topic1 | log_index | block_number | in_eventData | in_eventName | in_msgSender | block_timestamp | in_eventNameHash | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 0x000000000000000000000000913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf | 40 | 36102638 | {“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”:[]}} | SwapInfo | 0xee027373517a6d96fe62f70e9a0a395cb5a39eee | 2023-10-06T10:40:40.000Z | 0x93534d650a9b8eb67820f87038b8e8b36b741c6f7eb14d1a7ac5027e80fd4a82 | 0x7b08ab1e9bb5c9ba236a4a9f4157310778ef317902f31ad20721d3b2ceadad01 |
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 0x000000000000000000000000913c1f46b48b3ed35e7dc3cf754d4ae8499f31cf | 26 | 36088121 | {“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”:[]}} | SwapInfo | 0xee027373517a6d96fe62f70e9a0a395cb5a39eee | 2023-10-06T02:32:47.000Z | 0x93534d650a9b8eb67820f87038b8e8b36b741c6f7eb14d1a7ac5027e80fd4a82 | 0x89b793463b05f72de264eeb97aee09243bcf270171796b1913cb3ac8939ff8bb |
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 0x000000000000000000000000fb02132333a79c8b5bd0b64e3abcca5f7faf2937 | 17 | 36108368 | {“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”:[]}} | SwapInfo | 0xd3b6e962f135634c43415d57a28e688fb4f15a58 | 2023-10-06T13:47:29.000Z | 0x93534d650a9b8eb67820f87038b8e8b36b741c6f7eb14d1a7ac5027e80fd4a82 | 0xc00db992a0fd7a2d2f3bf173bb1ee0bca37244f0333eb4dedec22d18128aed62 |
Example Query
Example Query
Query with partition filter
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.Columns
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_msgSender | STRING | Address of the contract or account that triggered the event emission. Hex-encoded, 0x-prefixed, 42-character string. |
in_eventName | STRING | Name 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_eventNameHash | STRING | Keccak-256 hash of the event name. 66-character hex string including 0x prefix. |
in_topic1 | STRING | First 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_topic2 | STRING | Account 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_eventData | STRUCT<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. |
Sample Data
Sample Data
| address | removed | in_topic1 | in_topic2 | log_index | block_number | in_eventData | in_eventName | in_msgSender | block_timestamp | in_eventNameHash | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 0x5a39a4b70a530bb9f28364a2cebde40dae9411e7786b00b8ab54360c00e1258a | 0x00000000000000000000000000cbd3f851debf7e2d2b2b50ad7fb5754e60fe79 | 2 | 48248436 | {“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”:[]}} | OrderCancelled | 0x32a0258007a6ea78265a5ae4dbb28f176be4a8eb | 2024-07-21T11:25:36.000Z | 0xc7bb288dfd646d5b6c69d5099dd75b72f9c8c09ec9d40984c8ad8182357ae4b2 | 0x8586e4bafca2533e2d4d4263e1b5c9e2ee31ef0925aea57138a7006f74688c28 |
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 0x4ab93432ff6b82ff9d5a9fdcc2e4367bb2de1f2cd20a3cf059db7dfce4f7aead | 0x0000000000000000000000004f7d9ebe792cb4f4729de9328a8889c1e49b37b0 | 24 | 48259936 | {“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”:[]}} | OrderCancelled | 0x32a0258007a6ea78265a5ae4dbb28f176be4a8eb | 2024-07-21T17:50:27.000Z | 0xc7bb288dfd646d5b6c69d5099dd75b72f9c8c09ec9d40984c8ad8182357ae4b2 | 0xb709e675f4bc32ee4d724872c8bae6584a2cb4f8e998168bc76f18c63b872251 |
| 0xdb17b211c34240b014ab6d61d4a31fa0c0e20c26 | false | 0x45dd743cdb940d06fe0e84344c9a9a77e681d341ff738c2f0bbdc6f716fecbfe | 0x0000000000000000000000004f7d9ebe792cb4f4729de9328a8889c1e49b37b0 | 5 | 48261066 | {“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”:[]}} | OrderCancelled | 0x32a0258007a6ea78265a5ae4dbb28f176be4a8eb | 2024-07-21T18:26:48.000Z | 0xc7bb288dfd646d5b6c69d5099dd75b72f9c8c09ec9d40984c8ad8182357ae4b2 | 0xa91b5cebc1fcf41214d4efd25e11013f3aad70857a857dc46ea57d3c3bd5845a |
Example Query
Example Query
Query with partition filter