Tables
ConfigStorage_LogAddMarketConfig_event
Market configuration events from HMX perpetuals protocol on Arbitrum capturing when new trading markets are added or updated. Contains market parameters including margin requirements (BPS - basis points), position size limits, funding rate caps, and fee structures for analyzing protocol risk settings and market onboarding.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_index | STRING | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
in_newConfig | STRUCT<assetId STRING, maxLongPositionSize STRING, maxShortPositionSize STRING, increasePositionFeeRateBPS STRING, decreasePositionFeeRateBPS STRING, initialMarginFractionBPS STRING, maintenanceMarginFractionBPS STRING, maxProfitRateBPS STRING, assetClass INT64, allowIncreasePosition BOOL, active BOOL, fundingRate STRUCT<maxSkewScaleUSD STRING, maxFundingRate STRING>> | New configuration parameters applied after the update. Struct containing protocol-specific settings such as risk parameters, fees, or contract roles. |
Sample Data
Sample Data
| address | removed | in_index | log_index | block_number | in_newConfig | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xf4f7123ffe42c4c90a4bcdd2317d397e0b7d7cc0 | false | 29 | 25 | 124471639 | {“active”:true,“assetId”:“0x5347440000000000000000000000000000000000000000000000000000000000”,“assetClass”:2,“fundingRate”:{“maxFundingRate”:“1000000000000000000”,“maxSkewScaleUSD”:“1000000000000000000000000000000000000000”},“maxProfitRateBPS”:“200000”,“maxLongPositionSize”:“3000000000000000000000000000000000000”,“maxShortPositionSize”:“3000000000000000000000000000000000000”,“allowIncreasePosition”:true,“initialMarginFractionBPS”:“10”,“decreasePositionFeeRateBPS”:“1”,“increasePositionFeeRateBPS”:“1”,“maintenanceMarginFractionBPS”:“5”} | 2023-08-24T10:17:44.000Z | 0xce924dacd04498498aee8d366877f426094ebe3c9f07e15b225d7754bbe404cc |
| 0xf4f7123ffe42c4c90a4bcdd2317d397e0b7d7cc0 | false | 28 | 22 | 124471639 | {“active”:true,“assetId”:“0x4341440000000000000000000000000000000000000000000000000000000000”,“assetClass”:2,“fundingRate”:{“maxFundingRate”:“1000000000000000000”,“maxSkewScaleUSD”:“1000000000000000000000000000000000000000”},“maxProfitRateBPS”:“200000”,“maxLongPositionSize”:“3000000000000000000000000000000000000”,“maxShortPositionSize”:“3000000000000000000000000000000000000”,“allowIncreasePosition”:true,“initialMarginFractionBPS”:“10”,“decreasePositionFeeRateBPS”:“1”,“increasePositionFeeRateBPS”:“1”,“maintenanceMarginFractionBPS”:“5”} | 2023-08-24T10:17:44.000Z | 0xce924dacd04498498aee8d366877f426094ebe3c9f07e15b225d7754bbe404cc |
| 0xf4f7123ffe42c4c90a4bcdd2317d397e0b7d7cc0 | false | 27 | 19 | 124471639 | {“active”:true,“assetId”:“0x444f474500000000000000000000000000000000000000000000000000000000”,“assetClass”:0,“fundingRate”:{“maxFundingRate”:“8000000000000000000”,“maxSkewScaleUSD”:“200000000000000000000000000000000000000”},“maxProfitRateBPS”:“150000”,“maxLongPositionSize”:“2500000000000000000000000000000000000”,“maxShortPositionSize”:“2500000000000000000000000000000000000”,“allowIncreasePosition”:true,“initialMarginFractionBPS”:“100”,“decreasePositionFeeRateBPS”:“7”,“increasePositionFeeRateBPS”:“7”,“maintenanceMarginFractionBPS”:“50”} | 2023-08-24T10:17:44.000Z | 0xce924dacd04498498aee8d366877f426094ebe3c9f07e15b225d7754bbe404cc |
Example Query
Example Query
Query with partition filter
FeedableARBRewarder_LogHarvest_event
ARB (Arbitrum) token reward harvest events from HMX v1 protocol on Arbitrum, capturing when users claim pending rewards from the FeedableARBRewarder contract. Used for tracking reward distribution patterns and user claim behavior across the protocol’s incentive program.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_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pendingRewardAmount | STRING | Amount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit. |
Sample Data
Sample Data
| address | in_user | removed | log_index | block_number | block_timestamp | transaction_hash | in_pendingRewardAmount |
|---|---|---|---|---|---|---|---|
| 0x238daf7b15342113b00fa9e3f3e60a11ab4274fd | 0x321b821af7f354b879b04cdfaed6de42ab3d0b3b | false | 6 | 170393086 | 2024-01-14T14:30:08.000Z | 0xdfffb1dd1ee3b44945683d304aca1fc9f0882f87bbbe962e873abb831e86eb89 | 10775153529994024008 |
| 0x238daf7b15342113b00fa9e3f3e60a11ab4274fd | 0xf516199866cff36a03069e459827996e5cfb33f7 | false | 7 | 170432954 | 2024-01-14T17:25:06.000Z | 0x089d0e3d0e412cb3ee813023e19d9d10fc8cf7f200791ee287529d3b980c4b89 | 0 |
| 0x238daf7b15342113b00fa9e3f3e60a11ab4274fd | 0xd4ac2e147c8065dbcadcc64b9d108e847baf6382 | false | 7 | 170407523 | 2024-01-14T15:33:51.000Z | 0xaa57108d5659764e2e7f469bb63bd76ac8899add4ca6dfd2596c6e8037066e08 | 0 |
Example Query
Example Query
Query with partition filter
FeedableESHMXRewarder_LogHarvest_event
Reward harvest events from HMX v1 protocol’s esHMX (escrowed HMX) staking rewarder contract on Arbitrum. Tracks when users claim their pending staking rewards, including reward amounts and user addresses for analyzing yield distribution and claiming behavior.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_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pendingRewardAmount | STRING | Amount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit. |
Sample Data
Sample Data
| address | in_user | removed | log_index | block_number | block_timestamp | transaction_hash | in_pendingRewardAmount |
|---|---|---|---|---|---|---|---|
| 0x6d2c18b559c5343cb0703bb55aadb5f22152cc32 | 0x638198fffca8f6803df3728c50491d6715696dde | false | 5 | 192357005 | 2024-03-20T13:59:57.000Z | 0x0d16507866166f11a384eba43b86d2f3b1ceb33b4d335a460c159ef9bd852471 | 0 |
| 0x6d2c18b559c5343cb0703bb55aadb5f22152cc32 | 0xe3e0352b9dcd62a8d514ffc7a4fc57d6eda66853 | false | 5 | 192388740 | 2024-03-20T16:12:17.000Z | 0xfb08dec0aad551de39f4e4404ba7bde3f1431816d60353520589a33256d6f45b | 0 |
| 0x6d2c18b559c5343cb0703bb55aadb5f22152cc32 | 0x50eb42fe63fad9cb6c1ed585ae8951b3a6b0fc24 | false | 5 | 192494575 | 2024-03-20T23:39:51.000Z | 0xc48c6cd56c25eb9a0c9978a5e4b2c9321cf124131e9749e7f072e964388fe96b | 0 |
Example Query
Example Query
Query with partition filter
LiquidationService_LogLiquidationPosition_event
Liquidation event logs from HMX V1 perpetual futures protocol on Arbitrum, recording forced position closures with realized profit/loss, position size, and affected account details. Used for tracking liquidation activity, cascading liquidation risk, and market volatility analysis.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_account | STRING | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_subAccountId | INT64 | Sub-account identifier within the trader’s main account structure on HMX protocol. Always 0 in the samples, indicating liquidations occur on primary sub-accounts. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
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_isProfit | BOOL | Indicates whether the liquidated position had unrealized profit at the time of liquidation. False values in samples suggest positions were liquidated at a loss. |
in_delta | STRING | Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction. |
Sample Data
Sample Data
| address | in_size | removed | in_delta | log_index | in_account | in_isProfit | block_number | in_positionId | in_marketIndex | block_timestamp | in_subAccountId | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x34e89ded96340a177856fd822366afc584438750 | -31000000000000000000000000000000 | false | 14690169588946220691017526623444 | 31 | 0xf2bcde2a54b0f7e795950aea80759979f9b2b784 | false | 274082335 | 0xfd424d53f8c9f6318aab0a3b05d9da6ddac03fb9e035e3150ec9e712a01518b5 | 1 | 2024-11-13T15:46:01.000Z | 0 | 0xb205070d3fe38f9e4b1bc28d7da1de3efab2142f60072ee46ab88849686f02a4 |
| 0x34e89ded96340a177856fd822366afc584438750 | -23000000000000000000000000000000 | false | 567210056657570360737238841949 | 25 | 0xf2bcde2a54b0f7e795950aea80759979f9b2b784 | false | 274082335 | 0xe4f6adf4fbb27a5cacda2d71836d71391ac2b5e5ea081fff56d3b11db48e9cf4 | 0 | 2024-11-13T15:46:01.000Z | 0 | 0xb205070d3fe38f9e4b1bc28d7da1de3efab2142f60072ee46ab88849686f02a4 |
| 0x34e89ded96340a177856fd822366afc584438750 | -31000000000000000000000000000000 | false | 14717590179433912996334263827271 | 21 | 0x0657b32cde02e1a31b4a08edae4e555c137b5206 | false | 274082352 | 0x1f1495bbbc5a34f7530188cbb19c59443d5659f0809a2781ab59d035ed1897fb | 1 | 2024-11-13T15:46:06.000Z | 0 | 0xc8657666861d581f6ab97c31062068e0c918902e95ca6d8c4707681876ecca45 |
Example Query
Example Query
Query with partition filter
OpenInterestIncentiveRewarders_LogHarvest_event
Reward harvest events from HMX v1’s open interest incentive program on Arbitrum, capturing when users claim pending rewards with amounts in wei. Used for tracking incentive distribution and user reward claiming behavior across different rewarder contracts.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_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pendingRewardAmount | STRING | Amount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit. |
Sample Data
Sample Data
| address | in_user | removed | log_index | block_number | block_timestamp | transaction_hash | in_pendingRewardAmount |
|---|---|---|---|---|---|---|---|
| 0xf681ca8789f94a3be3eb0dfec65145556fda254c | 0x0007448f4ba168e24c35f835eefa1a76587d691d | false | 30 | 209881323 | 2024-05-10T17:44:49.000Z | 0xec99e581c0fac4731f6399f0341dfb12f94e9d8ba727ce07abeb85ba36a17add | 35245664319144006 |
| 0xf681ca8789f94a3be3eb0dfec65145556fda254c | 0x0007448f4ba168e24c35f835eefa1a76587d691d | false | 23 | 209666285 | 2024-05-10T02:39:39.000Z | 0xdba25290074d4c27644d14b3439408c151919b548af7fcba51c5742544dfcdad | 80096206240543350 |
| 0x4c1899d1872a4e65e489c33fc560ce3c9a9ad2ff | 0x0007448f4ba168e24c35f835eefa1a76587d691d | false | 27 | 209881323 | 2024-05-10T17:44:49.000Z | 0xec99e581c0fac4731f6399f0341dfb12f94e9d8ba727ce07abeb85ba36a17add | 429823654034845 |
Example Query
Example Query
Query with partition filter
StakingESHMXRewarder_LogHarvest_event
Reward harvest events from HMX V1’s escrowed HMX (esHMX) staking rewarder contract on Arbitrum. Tracks user reward claims with pending reward amounts denominated in wei for analyzing staking yield distribution and user harvesting behavior.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_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pendingRewardAmount | STRING | Amount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit. |
Sample Data
Sample Data
| address | in_user | removed | log_index | block_number | block_timestamp | transaction_hash | in_pendingRewardAmount |
|---|---|---|---|---|---|---|---|
| 0x94c22459b145f012f1c6791f2d729f7a22c44764 | 0xf18011766cf11d905e93ed5626838d44c7fa14b7 | false | 5 | 158663118 | 2023-12-10T07:59:47.000Z | 0x5c22f80bdf54a693d8f73f8696c9ebfaeffe48e5a0c320a7a17fc76ec196127e | 496062116773126340 |
| 0x94c22459b145f012f1c6791f2d729f7a22c44764 | 0xf18011766cf11d905e93ed5626838d44c7fa14b7 | false | 5 | 158591669 | 2023-12-10T02:35:54.000Z | 0x6bb0fe977d72b2a8f5c0d16d39785c1b0c1af116d802d98354363bf6ab424f99 | 30986859441350472 |
| 0x94c22459b145f012f1c6791f2d729f7a22c44764 | 0xf18011766cf11d905e93ed5626838d44c7fa14b7 | false | 5 | 158579544 | 2023-12-10T01:42:23.000Z | 0xef8d7b6e3cc077be6206637b0c6ef774e2c12a9ea29f3bff27b4992194409727 | 284021436461806463 |
Example Query
Example Query
Query with partition filter
SurgeFeedableRewarder_LogHarvest_event
Reward claim events from HMX v1 protocol’s SurgeFeedableRewarder contract on Arbitrum, capturing when users harvest their pending reward amounts. Used for tracking reward distribution activity and user engagement with the protocol’s incentive system.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_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pendingRewardAmount | STRING | Amount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit. |
Sample Data
Sample Data
| address | in_user | removed | log_index | block_number | block_timestamp | transaction_hash | in_pendingRewardAmount |
|---|---|---|---|---|---|---|---|
| 0xce3c078282df113efc3d816e83ca70f4c19d9dab | 0x1b5b7b514771beec3c83add7e0165166dbc77320 | false | 3 | 181188132 | 2024-02-16T02:09:05.000Z | 0x002b872d4e6cd5408ae319090620e8edd25406b4d20195ce323a668196e6b7de | 0 |
| 0xce3c078282df113efc3d816e83ca70f4c19d9dab | 0xcd7a011517f5c038995afaf5a84f4959e0f07c1d | false | 3 | 181343156 | 2024-02-16T13:08:47.000Z | 0x17f79240f2eb37c56d6915164cdea0642049f540b12b9d4e80c9aba508c18344 | 0 |
| 0xce3c078282df113efc3d816e83ca70f4c19d9dab | 0x02c153f5c370942ea085cccaa3964c90872c4483 | false | 3 | 181258473 | 2024-02-16T07:10:24.000Z | 0x5a0bf6bb314c25f7fdb5fe3836b94758718f4b537101d0c545a728e25090102f | 0 |
Example Query
Example Query
Query with partition filter
TLCRewarder_LogHarvest_event
Reward harvest events from HMX v1 protocol’s TLC (Trading Liquidity Committee) rewarder contract on Arbitrum, recording user claims of pending reward amounts for specific epoch periods. Used for analyzing reward distribution patterns and user claiming behavior across trading epochs.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_epochTimestamp | STRING | Unix timestamp marking the reward epoch period for which rewards are being harvested. Stored as a string representation of seconds since epoch, typically aligned to specific period boundaries. |
in_user | STRING | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_pendingRewardAmount | STRING | Amount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit. |
Sample Data
Sample Data
| address | in_user | removed | log_index | block_number | block_timestamp | transaction_hash | in_epochTimestamp | in_pendingRewardAmount |
|---|---|---|---|---|---|---|---|---|
| 0xf70f7e2dd7e5f553d6907cbba433d2256e6f80d2 | 0x06c3738c4a305db05818357744c0d0d82de9046a | false | 37 | 164999724 | 2023-12-29T16:09:26.000Z | 0x354db63cdcd18de9ce8514158cb009d389a1c483f538b0072872d00f3ccf4bd0 | 1690416000 | 0 |
| 0xf70f7e2dd7e5f553d6907cbba433d2256e6f80d2 | 0x06c3738c4a305db05818357744c0d0d82de9046a | false | 36 | 164999724 | 2023-12-29T16:09:26.000Z | 0x354db63cdcd18de9ce8514158cb009d389a1c483f538b0072872d00f3ccf4bd0 | 1689811200 | 0 |
| 0xf70f7e2dd7e5f553d6907cbba433d2256e6f80d2 | 0x06c3738c4a305db05818357744c0d0d82de9046a | false | 40 | 164999724 | 2023-12-29T16:09:26.000Z | 0x354db63cdcd18de9ce8514158cb009d389a1c483f538b0072872d00f3ccf4bd0 | 1699488000 | 0 |
Example Query
Example Query
Query with partition filter
TradeHelper_LogSettleBorrowingFeeValue_event
Borrowing fee settlement events from HMX v1 perpetual futures protocol on Arbitrum, tracking fees charged to leveraged positions by sub-account, position ID, and market index. Used for analyzing funding costs and position financing metrics across different markets.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
in_subAccount | STRING | Address of the sub-account associated with the position or transaction. 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. |
Sample Data
Sample Data
| address | removed | in_feeUsd | log_index | block_number | in_positionId | in_subAccount | in_marketIndex | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 0 | 9 | 274043709 | 0x01f4a46b70664a879c7382ae361b1e7892e95f6990bbbc153d42d071e901c097 | 0x4598e46c2524df21a8316fae2041cffe613e7688 | 0 | 2024-11-13T13:03:55.000Z | 0x4392c845b44b0c91edda0fb1bc036cebc26e13792a3d1e2d83758ad82cdcb1f2 |
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 4065898826626800000000000 | 24 | 274043808 | 0x01f4a46b70664a879c7382ae361b1e7892e95f6990bbbc153d42d071e901c097 | 0x4598e46c2524df21a8316fae2041cffe613e7688 | 0 | 2024-11-13T13:04:20.000Z | 0x9c5919388244dc7961ddc52c69fdf0430da601667567523c8e914d2677b2138d |
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 333204072828000000000000 | 26 | 274102423 | 0x03d2279faf8493c8ff95df56ed85e69822a2ef7f11e79d95e44c205c7c300ac1 | 0x491a69158aee6b1d267c3d5b064333c9c651813d | 0 | 2024-11-13T17:10:10.000Z | 0x1f70b5c69954f3031180f9d8d62fb6ce544b91d64de8498f22cc6e53241d02ea |
Example Query
Example Query
Query with partition filter
TradeHelper_LogSettleFundingFeeValue_event
Funding fee settlement events from HMX v1 perpetual futures protocol on Arbitrum, recording periodic funding payments charged to or paid by open positions. Useful for analyzing funding rate costs, position holder behavior, and market funding dynamics across different perpetual markets.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
in_subAccount | STRING | Address of the sub-account associated with the position or transaction. 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. |
Sample Data
Sample Data
| address | removed | in_feeUsd | log_index | block_number | in_positionId | in_subAccount | in_marketIndex | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 17710388223876000000000000000000 | 46 | 229832303 | 0x354963bd801e971275620116b2916e72c5689cebf98212f3d5c2d3c72a2c46dd | 0xd73bd59e7c0d075c9a83cad272cf17c46f7f2784 | 0 | 2024-07-07T21:23:22.000Z | 0x146700f4213099d8c71498ed2972ed32a24f39165a3358d69199ec2c132c1a55 |
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 201843670444100000000000000000 | 5 | 229856937 | 0x354963bd801e971275620116b2916e72c5689cebf98212f3d5c2d3c72a2c46dd | 0xd73bd59e7c0d075c9a83cad272cf17c46f7f2784 | 0 | 2024-07-07T23:06:18.000Z | 0x2c4183a07a03a967c9af54355c94a3ea5d37e0a14c9e7a3f47c5d4709c457892 |
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 16091735039880300000000000000000 | 13 | 229731313 | 0x354963bd801e971275620116b2916e72c5689cebf98212f3d5c2d3c72a2c46dd | 0xd73bd59e7c0d075c9a83cad272cf17c46f7f2784 | 0 | 2024-07-07T14:22:18.000Z | 0x87fe3368a9c86ed248e50a3092b09672a74245f9a0072f2fb0aba280e82f302f |
Example Query
Example Query
Query with partition filter
TradeHelper_LogSettleLiquidationFeeValue_event
Liquidation fee settlement events from HMX v1 perpetual futures protocol on Arbitrum, recording USD-denominated fees collected when positions are liquidated. Tracks fee distribution across subaccounts and specific positions for analyzing liquidation costs and protocol revenue from forced position closures.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
in_subAccount | STRING | Address of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_usd | STRING | Liquidation fee amount settled in USD terms, represented as a string-encoded integer with implicit decimals. Sample values show ‘0’ indicating no liquidation fee charged for these settlement events. |
Sample Data
Sample Data
| in_usd | address | removed | log_index | block_number | in_positionId | in_subAccount | in_marketIndex | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 4 | 175424881 | 0x214ffc4aaf073559666fc4a07633ee070400b0081c884eed8e1afaac70520259 | 0xceec48581b3145a575508719f45da07dc57fa7ce | 0 | 2024-01-29T15:27:23.000Z | 0x49b4336fe1661f6933f243ecbbf397e436dec65e927c7ab1266b6fb96682bf71 |
| 0 | 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 7 | 175447649 | 0x352eb8aa777e64f02503d4b68f9ac1934195ec5ab51996f15d952270221f5d29 | 0xd9f80cb81164163a90745477ce1b2befb246a33f | 0 | 2024-01-29T17:03:10.000Z | 0x37e68c21c212ac0e27cdff992ef5f49b0b424416ebe65a22a1c5a5e14e47d2f5 |
| 0 | 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 4 | 175330074 | 0x352eb8aa777e64f02503d4b68f9ac1934195ec5ab51996f15d952270221f5d29 | 0xd9f80cb81164163a90745477ce1b2befb246a33f | 0 | 2024-01-29T08:46:32.000Z | 0x48fbfa62e8b7caa20c848b404aa762e9a71a3e085a96e0a66d1f8d8b70def45b |
Example Query
Example Query
Query with partition filter
TradeHelper_LogSettleTradingFeeValue_event
Trading fee settlement events from HMX v1 perpetual futures protocol on Arbitrum. Records USD-denominated fees charged per position and market, enabling fee revenue analysis and trader cost tracking.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
in_subAccount | STRING | Address of the sub-account associated with the position or transaction. 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. |
Sample Data
Sample Data
| address | removed | in_feeUsd | log_index | block_number | in_positionId | in_subAccount | in_marketIndex | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 36711899422391155264965824812519 | 22 | 221605387 | 0x088554283b697157ea1b34ee9b76bf828168dedbc2f5fa9bfe63965ac1476a9d | 0x5ce6f3798b9ca0797e1027e9b86e7df0ba61e593 | 0 | 2024-06-14T01:18:00.000Z | 0xccb0627aa2c1fa50d3e73126e33ca259a2895d4ad6138e15fe21fece50854f30 |
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 41972399349348844735034175187480 | 19 | 221595459 | 0x088554283b697157ea1b34ee9b76bf828168dedbc2f5fa9bfe63965ac1476a9d | 0x5ce6f3798b9ca0797e1027e9b86e7df0ba61e593 | 0 | 2024-06-14T00:36:40.000Z | 0x2bef75515a975563bbfcbb23d0c0570505fccac20b155caa1613a644c1abe031 |
| 0x963cbe4cfcdc58795869be74b80a328b022de00c | false | 70000000000000000000000000000 | 123 | 221819103 | 0x0eb7d07693c1d952dd4d34a1a449fd0fa33e26a9f5db42dbbea95c3a7f9876ad | 0xdb3486cc219e9e7a18b10ccced58e414db30758d | 0 | 2024-06-14T16:08:42.000Z | 0xc6772e1d9e5271f6d94d23a1abf67cefcc1de684b8dcd3c813138ccec3b674f3 |
Example Query
Example Query
Query with partition filter
TradeService_LogDecreasePosition_event
Position reduction events from HMX v1 perpetual futures protocol on Arbitrum. Captures partial or full position closes with realized PnL, entry and exit prices, and funding/borrowing rate data for analyzing trader performance and position management.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_primaryAccount | STRING | Primary account address associated with the position, representing the main wallet controlling the sub-account. This is the parent account in HMX’s account hierarchy system, hex-encoded and 0x-prefixed. |
in_subAccountId | INT64 | Numeric identifier distinguishing multiple sub-accounts under the same primary account address. Typically starts at 0 for the main sub-account and increments for additional sub-accounts. |
in_subAccount | STRING | Address of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
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_decreasedSize | STRING | Amount by which the position size was reduced in this decrease transaction. Denominated in E30 precision (value divided by 10^30 equals actual position size units). |
in_avgEntryPrice | STRING | Average entry price for the position at the time of the decrease event. Expressed as a high-precision integer with 30 decimal places (E30 format). |
in_entryBorrowingRate | STRING | Borrowing rate at the time the position was opened, used to calculate funding costs accrued over the position’s lifetime. Represented as a fixed-point decimal with 18 decimal places of precision. |
in_lastFundingAccrued | STRING | Accumulated funding payment rate at the time the position was last updated. Used to calculate funding fees owed or earned on the position since entry. |
in_realizedPnl | STRING | Realized profit or loss from the position or transaction. String-encoded integer value representing the net financial result in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits. |
in_reserveValueE30 | STRING | Reserve amount held for the position denominated in E30 format (value multiplied by 10^30). Typically represents collateral or margin allocated to secure the position, varying with position size. |
in_price | STRING | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
Sample Data
Sample Data
| address | in_size | removed | in_price | log_index | block_number | in_positionId | in_subAccount | in_marketIndex | in_realizedPnl | block_timestamp | in_subAccountId | in_avgEntryPrice | in_decreasedSize | transaction_hash | in_primaryAccount | in_reserveValueE30 | in_entryBorrowingRate | in_lastFundingAccrued |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xcf533d0eefb072d1bb68e201eafc5368764daa0e | -10000000000000000000000000000000000 | false | 23743632508025426300000000000 | 20 | 292229698 | 0xd0b2dea9e5abdd33f832dbccd1a57aa1a624cba401a813ba5984d43d074c8aef | 0x04ca496d60e6a66d1ac889104ac2fc0e7b23c9e0 | 45 | -468597113893770119565338505073180 | 2025-01-05T11:48:08.000Z | 0 | 22680816015465168600000000000 | 10000000000000000000000000000000000 | 0xd5a9ac4c44f5773e5f2337a09c8c1e587ddb17e5e1505bdd8057dadb2f0510bf | 0x04ca496d60e6a66d1ac889104ac2fc0e7b23c9e0 | 4000000000000000000000000000000000 | 194861702528984512 | 378466554314339107 |
| 0xcf533d0eefb072d1bb68e201eafc5368764daa0e | -196791422879980000000000000000000000 | false | 98582028973908871354969993750379735 | 26 | 292385054 | 0x57c95843b978de83945050dd58f6ab0bdbf64f37a0bd14c70547b7d84211092b | 0x12a1b6df79169b22707a47d0f58b78c31122748e | 1 | -295421062181828491530090917021305 | 2025-01-05T22:39:16.000Z | 0 | 98434260573294274244746403488284324 | 196791422879980000000000000000000000 | 0x7b13a1c7f659d7dabcf2cb32c07692cd535ec4925875270cfd7d44a88282162b | 0x12a1b6df79169b22707a47d0f58b78c31122748e | 78716569151992000000000000000000000 | 196100275016377322 | 370669303622746770 |
| 0xcf533d0eefb072d1bb68e201eafc5368764daa0e | 900000000000000000000000000000000 | false | 2351968478898782411983186400000 | 12 | 292266215 | 0x6d5d2daaf8352cff054b48748d363652cd8ad6708d1386350036c93a7d3232b8 | 0x3b57579a35425a24c2a786dacebe1837c09e5fbb | 23 | -38050290891446341933162525605543 | 2025-01-05T14:20:46.000Z | 0 | 2455794820324393960178322800000 | 900000000000000000000000000000000 | 0x4a3af6a0edec4b4505096b5c1217a96d60e957c9f463e726a1095ac34a617ecc | 0x3b57579a35425a24c2a786dacebe1837c09e5fbb | 360000000000000000000000000000000 | 195302713228292216 | 262173190746515170 |
Example Query
Example Query
Query with partition filter
TradeService_LogIncreasePosition_event
Position size increase events from HMX v1 perpetual futures protocol on Arbitrum. Tracks position modifications including entry prices, borrowing rates, funding accruals, and realized PnL for analyzing trader behavior and position management.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_positionId | STRING | Unique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol. |
in_primaryAccount | STRING | Primary account address associated with this position. This is the main wallet address of the trader, while the sub-account may differ for position segregation. |
in_subAccountId | INT64 | Integer identifier for the sub-account within the primary account structure. Values are typically 0 or 1, allowing traders to segment positions within a single wallet address. |
in_subAccount | STRING | Address of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_marketIndex | STRING | Identifier for the specific market or trading pair in the protocol. String-encoded integer representing the market’s index position in the system’s market registry. |
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_increasedSize | STRING | Amount by which the position size changed in this event, denominated in HMX protocol’s base units (E30 precision). Positive values indicate longs, negative values indicate shorts or size reductions. |
in_avgEntryPrice | STRING | Average entry price of the position after this increase, expressed in high-precision wei units (30 decimal places). Used to calculate unrealized PnL relative to current market price. |
in_entryBorrowingRate | STRING | Borrowing rate applied to the position at the time of entry, expressed in basis points with high precision. This rate determines the funding cost for holding the leveraged position on HMX protocol. |
in_lastFundingAccrued | STRING | Accumulated funding payment for the position at the time of the increase, expressed as a signed integer where negative values indicate funding paid and positive values indicate funding received. Values are in HMX’s fixed-point format with high precision (E30 notation). |
in_realizedPnl | STRING | Realized profit or loss from the position or transaction. String-encoded integer value representing the net financial result in the smallest unit of the relevant token or currency, where negative values indicate losses and positive values indicate profits. |
in_reserveValueE30 | STRING | Reserve or margin amount deposited for the position, denominated in E30 format (value scaled by 10^30). Typically represents a fraction of the position size as collateral backing the leveraged trade. |
in_price | STRING | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision. |
Sample Data
Sample Data
| address | in_size | removed | in_price | log_index | block_number | in_positionId | in_subAccount | in_marketIndex | in_realizedPnl | block_timestamp | in_subAccountId | in_avgEntryPrice | in_increasedSize | transaction_hash | in_primaryAccount | in_reserveValueE30 | in_entryBorrowingRate | in_lastFundingAccrued |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xcf533d0eefb072d1bb68e201eafc5368764daa0e | 500000000000000000000000000000000 | false | 908009619886536040788714835679 | 16 | 197057013 | 0x004ec74b9bfd345dda334cd831fdb620ce883b4832cc503c07f32648a81c274e | 0x98c80d89cbb286ca2a4af0973d3c84a86888d7c0 | 26 | 0 | 2024-04-03T05:44:19.000Z | 0 | 908009619886536040788714835679 | 500000000000000000000000000000000 | 0x91fd9e33a8184c02959c1b489c6598999f178beee387ddb60df53cf9c3b74e9d | 0x98c80d89cbb286ca2a4af0973d3c84a86888d7c0 | 25000000000000000000000000000000 | 14633685497494063 | -18391219165785673 |
| 0xcf533d0eefb072d1bb68e201eafc5368764daa0e | 9000000000000000000000000000000000 | false | 854238651725552226067427754828 | 16 | 197061699 | 0x0099242d35f21be0f37d68cafa3dfe4d5aef5fc137b27fc3d8b4179478ec6adf | 0x1979630a6ab98a0cce107aa8edc4ed1057f2bd43 | 50 | 0 | 2024-04-03T06:03:56.000Z | 0 | 854238651725552226067427754828 | 9000000000000000000000000000000000 | 0xdbef6d562e585c1936040d734d0ca09e02f382db9e23cb95867ac108433f2ded | 0x1979630a6ab98a0cce107aa8edc4ed1057f2bd43 | 3600000000000000000000000000000000 | 73614848715921563 | 73224764409099721 |
| 0xcf533d0eefb072d1bb68e201eafc5368764daa0e | -31000000000000000000000000000000 | false | 3339127563804152320378912046385554 | 19 | 197121293 | 0x00dbaac5bb3ea9c1df872e6ef5fc6d52b8701cf8fd59a79399133ea2cc0ab00c | 0x68247c46cd3d1feb0ef907c571da04fa599f6a01 | 0 | 0 | 2024-04-03T10:14:04.000Z | 0 | 3352975703703306145694140590123451 | -10000000000000000000000000000000 | 0x34f082f074d58b09f6a0bf3c3f98eed4aa7a4510c378a9bb7552b450b69a47ca | 0x68247c46cd3d1feb0ef907c571da04fa599f6a01 | 10850000000000000000000000000000 | 73649591597938699 | 291474460961918238 |
Example Query
Example Query
Query with partition filter