Skip to main content

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.
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_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
in_newConfigSTRUCT<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.
addressremovedin_indexlog_indexblock_numberin_newConfigblock_timestamptransaction_hash
0xf4f7123ffe42c4c90a4bcdd2317d397e0b7d7cc0false2925124471639{“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.000Z0xce924dacd04498498aee8d366877f426094ebe3c9f07e15b225d7754bbe404cc
0xf4f7123ffe42c4c90a4bcdd2317d397e0b7d7cc0false2822124471639{“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.000Z0xce924dacd04498498aee8d366877f426094ebe3c9f07e15b225d7754bbe404cc
0xf4f7123ffe42c4c90a4bcdd2317d397e0b7d7cc0false2719124471639{“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.000Z0xce924dacd04498498aee8d366877f426094ebe3c9f07e15b225d7754bbe404cc
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.ConfigStorage_LogAddMarketConfig_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pendingRewardAmountSTRINGAmount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_pendingRewardAmount
0x238daf7b15342113b00fa9e3f3e60a11ab4274fd0x321b821af7f354b879b04cdfaed6de42ab3d0b3bfalse61703930862024-01-14T14:30:08.000Z0xdfffb1dd1ee3b44945683d304aca1fc9f0882f87bbbe962e873abb831e86eb8910775153529994024008
0x238daf7b15342113b00fa9e3f3e60a11ab4274fd0xf516199866cff36a03069e459827996e5cfb33f7false71704329542024-01-14T17:25:06.000Z0x089d0e3d0e412cb3ee813023e19d9d10fc8cf7f200791ee287529d3b980c4b890
0x238daf7b15342113b00fa9e3f3e60a11ab4274fd0xd4ac2e147c8065dbcadcc64b9d108e847baf6382false71704075232024-01-14T15:33:51.000Z0xaa57108d5659764e2e7f469bb63bd76ac8899add4ca6dfd2596c6e8037066e080
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.FeedableARBRewarder_LogHarvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pendingRewardAmountSTRINGAmount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_pendingRewardAmount
0x6d2c18b559c5343cb0703bb55aadb5f22152cc320x638198fffca8f6803df3728c50491d6715696ddefalse51923570052024-03-20T13:59:57.000Z0x0d16507866166f11a384eba43b86d2f3b1ceb33b4d335a460c159ef9bd8524710
0x6d2c18b559c5343cb0703bb55aadb5f22152cc320xe3e0352b9dcd62a8d514ffc7a4fc57d6eda66853false51923887402024-03-20T16:12:17.000Z0xfb08dec0aad551de39f4e4404ba7bde3f1431816d60353520589a33256d6f45b0
0x6d2c18b559c5343cb0703bb55aadb5f22152cc320x50eb42fe63fad9cb6c1ed585ae8951b3a6b0fc24false51924945752024-03-20T23:39:51.000Z0xc48c6cd56c25eb9a0c9978a5e4b2c9321cf124131e9749e7f072e964388fe96b0
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.FeedableESHMXRewarder_LogHarvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_subAccountIdINT64Sub-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_marketIndexSTRINGIdentifier 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_sizeSTRINGSize 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_isProfitBOOLIndicates whether the liquidated position had unrealized profit at the time of liquidation. False values in samples suggest positions were liquidated at a loss.
in_deltaSTRINGChange 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.
addressin_sizeremovedin_deltalog_indexin_accountin_isProfitblock_numberin_positionIdin_marketIndexblock_timestampin_subAccountIdtransaction_hash
0x34e89ded96340a177856fd822366afc584438750-31000000000000000000000000000000false14690169588946220691017526623444310xf2bcde2a54b0f7e795950aea80759979f9b2b784false2740823350xfd424d53f8c9f6318aab0a3b05d9da6ddac03fb9e035e3150ec9e712a01518b512024-11-13T15:46:01.000Z00xb205070d3fe38f9e4b1bc28d7da1de3efab2142f60072ee46ab88849686f02a4
0x34e89ded96340a177856fd822366afc584438750-23000000000000000000000000000000false567210056657570360737238841949250xf2bcde2a54b0f7e795950aea80759979f9b2b784false2740823350xe4f6adf4fbb27a5cacda2d71836d71391ac2b5e5ea081fff56d3b11db48e9cf402024-11-13T15:46:01.000Z00xb205070d3fe38f9e4b1bc28d7da1de3efab2142f60072ee46ab88849686f02a4
0x34e89ded96340a177856fd822366afc584438750-31000000000000000000000000000000false14717590179433912996334263827271210x0657b32cde02e1a31b4a08edae4e555c137b5206false2740823520x1f1495bbbc5a34f7530188cbb19c59443d5659f0809a2781ab59d035ed1897fb12024-11-13T15:46:06.000Z00xc8657666861d581f6ab97c31062068e0c918902e95ca6d8c4707681876ecca45
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.LiquidationService_LogLiquidationPosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pendingRewardAmountSTRINGAmount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_pendingRewardAmount
0xf681ca8789f94a3be3eb0dfec65145556fda254c0x0007448f4ba168e24c35f835eefa1a76587d691dfalse302098813232024-05-10T17:44:49.000Z0xec99e581c0fac4731f6399f0341dfb12f94e9d8ba727ce07abeb85ba36a17add35245664319144006
0xf681ca8789f94a3be3eb0dfec65145556fda254c0x0007448f4ba168e24c35f835eefa1a76587d691dfalse232096662852024-05-10T02:39:39.000Z0xdba25290074d4c27644d14b3439408c151919b548af7fcba51c5742544dfcdad80096206240543350
0x4c1899d1872a4e65e489c33fc560ce3c9a9ad2ff0x0007448f4ba168e24c35f835eefa1a76587d691dfalse272098813232024-05-10T17:44:49.000Z0xec99e581c0fac4731f6399f0341dfb12f94e9d8ba727ce07abeb85ba36a17add429823654034845
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.OpenInterestIncentiveRewarders_LogHarvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pendingRewardAmountSTRINGAmount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_pendingRewardAmount
0x94c22459b145f012f1c6791f2d729f7a22c447640xf18011766cf11d905e93ed5626838d44c7fa14b7false51586631182023-12-10T07:59:47.000Z0x5c22f80bdf54a693d8f73f8696c9ebfaeffe48e5a0c320a7a17fc76ec196127e496062116773126340
0x94c22459b145f012f1c6791f2d729f7a22c447640xf18011766cf11d905e93ed5626838d44c7fa14b7false51585916692023-12-10T02:35:54.000Z0x6bb0fe977d72b2a8f5c0d16d39785c1b0c1af116d802d98354363bf6ab424f9930986859441350472
0x94c22459b145f012f1c6791f2d729f7a22c447640xf18011766cf11d905e93ed5626838d44c7fa14b7false51585795442023-12-10T01:42:23.000Z0xef8d7b6e3cc077be6206637b0c6ef774e2c12a9ea29f3bff27b4992194409727284021436461806463
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.StakingESHMXRewarder_LogHarvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pendingRewardAmountSTRINGAmount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_pendingRewardAmount
0xce3c078282df113efc3d816e83ca70f4c19d9dab0x1b5b7b514771beec3c83add7e0165166dbc77320false31811881322024-02-16T02:09:05.000Z0x002b872d4e6cd5408ae319090620e8edd25406b4d20195ce323a668196e6b7de0
0xce3c078282df113efc3d816e83ca70f4c19d9dab0xcd7a011517f5c038995afaf5a84f4959e0f07c1dfalse31813431562024-02-16T13:08:47.000Z0x17f79240f2eb37c56d6915164cdea0642049f540b12b9d4e80c9aba508c183440
0xce3c078282df113efc3d816e83ca70f4c19d9dab0x02c153f5c370942ea085cccaa3964c90872c4483false31812584732024-02-16T07:10:24.000Z0x5a0bf6bb314c25f7fdb5fe3836b94758718f4b537101d0c545a728e25090102f0
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.SurgeFeedableRewarder_LogHarvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_epochTimestampSTRINGUnix 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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pendingRewardAmountSTRINGAmount of pending rewards being harvested for the user. Decimal integer string representing token quantity in smallest unit.
addressin_userremovedlog_indexblock_numberblock_timestamptransaction_hashin_epochTimestampin_pendingRewardAmount
0xf70f7e2dd7e5f553d6907cbba433d2256e6f80d20x06c3738c4a305db05818357744c0d0d82de9046afalse371649997242023-12-29T16:09:26.000Z0x354db63cdcd18de9ce8514158cb009d389a1c483f538b0072872d00f3ccf4bd016904160000
0xf70f7e2dd7e5f553d6907cbba433d2256e6f80d20x06c3738c4a305db05818357744c0d0d82de9046afalse361649997242023-12-29T16:09:26.000Z0x354db63cdcd18de9ce8514158cb009d389a1c483f538b0072872d00f3ccf4bd016898112000
0xf70f7e2dd7e5f553d6907cbba433d2256e6f80d20x06c3738c4a305db05818357744c0d0d82de9046afalse401649997242023-12-29T16:09:26.000Z0x354db63cdcd18de9ce8514158cb009d389a1c483f538b0072872d00f3ccf4bd016994880000
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TLCRewarder_LogHarvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_marketIndexSTRINGIdentifier 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_subAccountSTRINGAddress of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_feeUsdSTRINGUSD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
addressremovedin_feeUsdlog_indexblock_numberin_positionIdin_subAccountin_marketIndexblock_timestamptransaction_hash
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse092740437090x01f4a46b70664a879c7382ae361b1e7892e95f6990bbbc153d42d071e901c0970x4598e46c2524df21a8316fae2041cffe613e768802024-11-13T13:03:55.000Z0x4392c845b44b0c91edda0fb1bc036cebc26e13792a3d1e2d83758ad82cdcb1f2
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse4065898826626800000000000242740438080x01f4a46b70664a879c7382ae361b1e7892e95f6990bbbc153d42d071e901c0970x4598e46c2524df21a8316fae2041cffe613e768802024-11-13T13:04:20.000Z0x9c5919388244dc7961ddc52c69fdf0430da601667567523c8e914d2677b2138d
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse333204072828000000000000262741024230x03d2279faf8493c8ff95df56ed85e69822a2ef7f11e79d95e44c205c7c300ac10x491a69158aee6b1d267c3d5b064333c9c651813d02024-11-13T17:10:10.000Z0x1f70b5c69954f3031180f9d8d62fb6ce544b91d64de8498f22cc6e53241d02ea
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TradeHelper_LogSettleBorrowingFeeValue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_marketIndexSTRINGIdentifier 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_subAccountSTRINGAddress of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_feeUsdSTRINGUSD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
addressremovedin_feeUsdlog_indexblock_numberin_positionIdin_subAccountin_marketIndexblock_timestamptransaction_hash
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse17710388223876000000000000000000462298323030x354963bd801e971275620116b2916e72c5689cebf98212f3d5c2d3c72a2c46dd0xd73bd59e7c0d075c9a83cad272cf17c46f7f278402024-07-07T21:23:22.000Z0x146700f4213099d8c71498ed2972ed32a24f39165a3358d69199ec2c132c1a55
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse20184367044410000000000000000052298569370x354963bd801e971275620116b2916e72c5689cebf98212f3d5c2d3c72a2c46dd0xd73bd59e7c0d075c9a83cad272cf17c46f7f278402024-07-07T23:06:18.000Z0x2c4183a07a03a967c9af54355c94a3ea5d37e0a14c9e7a3f47c5d4709c457892
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse16091735039880300000000000000000132297313130x354963bd801e971275620116b2916e72c5689cebf98212f3d5c2d3c72a2c46dd0xd73bd59e7c0d075c9a83cad272cf17c46f7f278402024-07-07T14:22:18.000Z0x87fe3368a9c86ed248e50a3092b09672a74245f9a0072f2fb0aba280e82f302f
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TradeHelper_LogSettleFundingFeeValue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_marketIndexSTRINGIdentifier 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_subAccountSTRINGAddress of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_usdSTRINGLiquidation 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.
in_usdaddressremovedlog_indexblock_numberin_positionIdin_subAccountin_marketIndexblock_timestamptransaction_hash
00x963cbe4cfcdc58795869be74b80a328b022de00cfalse41754248810x214ffc4aaf073559666fc4a07633ee070400b0081c884eed8e1afaac705202590xceec48581b3145a575508719f45da07dc57fa7ce02024-01-29T15:27:23.000Z0x49b4336fe1661f6933f243ecbbf397e436dec65e927c7ab1266b6fb96682bf71
00x963cbe4cfcdc58795869be74b80a328b022de00cfalse71754476490x352eb8aa777e64f02503d4b68f9ac1934195ec5ab51996f15d952270221f5d290xd9f80cb81164163a90745477ce1b2befb246a33f02024-01-29T17:03:10.000Z0x37e68c21c212ac0e27cdff992ef5f49b0b424416ebe65a22a1c5a5e14e47d2f5
00x963cbe4cfcdc58795869be74b80a328b022de00cfalse41753300740x352eb8aa777e64f02503d4b68f9ac1934195ec5ab51996f15d952270221f5d290xd9f80cb81164163a90745477ce1b2befb246a33f02024-01-29T08:46:32.000Z0x48fbfa62e8b7caa20c848b404aa762e9a71a3e085a96e0a66d1f8d8b70def45b
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TradeHelper_LogSettleLiquidationFeeValue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_marketIndexSTRINGIdentifier 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_subAccountSTRINGAddress of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_feeUsdSTRINGUSD-denominated fee amount collected. String-encoded integer value scaled by a fixed precision factor to represent the fee in USD.
addressremovedin_feeUsdlog_indexblock_numberin_positionIdin_subAccountin_marketIndexblock_timestamptransaction_hash
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse36711899422391155264965824812519222216053870x088554283b697157ea1b34ee9b76bf828168dedbc2f5fa9bfe63965ac1476a9d0x5ce6f3798b9ca0797e1027e9b86e7df0ba61e59302024-06-14T01:18:00.000Z0xccb0627aa2c1fa50d3e73126e33ca259a2895d4ad6138e15fe21fece50854f30
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse41972399349348844735034175187480192215954590x088554283b697157ea1b34ee9b76bf828168dedbc2f5fa9bfe63965ac1476a9d0x5ce6f3798b9ca0797e1027e9b86e7df0ba61e59302024-06-14T00:36:40.000Z0x2bef75515a975563bbfcbb23d0c0570505fccac20b155caa1613a644c1abe031
0x963cbe4cfcdc58795869be74b80a328b022de00cfalse700000000000000000000000000001232218191030x0eb7d07693c1d952dd4d34a1a449fd0fa33e26a9f5db42dbbea95c3a7f9876ad0xdb3486cc219e9e7a18b10ccced58e414db30758d02024-06-14T16:08:42.000Z0xc6772e1d9e5271f6d94d23a1abf67cefcc1de684b8dcd3c813138ccec3b674f3
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TradeHelper_LogSettleTradingFeeValue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_primaryAccountSTRINGPrimary 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_subAccountIdINT64Numeric 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_subAccountSTRINGAddress of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_marketIndexSTRINGIdentifier 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_sizeSTRINGSize 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_decreasedSizeSTRINGAmount 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_avgEntryPriceSTRINGAverage 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_entryBorrowingRateSTRINGBorrowing 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_lastFundingAccruedSTRINGAccumulated 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_realizedPnlSTRINGRealized 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_reserveValueE30STRINGReserve 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_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
addressin_sizeremovedin_pricelog_indexblock_numberin_positionIdin_subAccountin_marketIndexin_realizedPnlblock_timestampin_subAccountIdin_avgEntryPricein_decreasedSizetransaction_hashin_primaryAccountin_reserveValueE30in_entryBorrowingRatein_lastFundingAccrued
0xcf533d0eefb072d1bb68e201eafc5368764daa0e-10000000000000000000000000000000000false23743632508025426300000000000202922296980xd0b2dea9e5abdd33f832dbccd1a57aa1a624cba401a813ba5984d43d074c8aef0x04ca496d60e6a66d1ac889104ac2fc0e7b23c9e045-4685971138937701195653385050731802025-01-05T11:48:08.000Z022680816015465168600000000000100000000000000000000000000000000000xd5a9ac4c44f5773e5f2337a09c8c1e587ddb17e5e1505bdd8057dadb2f0510bf0x04ca496d60e6a66d1ac889104ac2fc0e7b23c9e04000000000000000000000000000000000194861702528984512378466554314339107
0xcf533d0eefb072d1bb68e201eafc5368764daa0e-196791422879980000000000000000000000false98582028973908871354969993750379735262923850540x57c95843b978de83945050dd58f6ab0bdbf64f37a0bd14c70547b7d84211092b0x12a1b6df79169b22707a47d0f58b78c31122748e1-2954210621818284915300909170213052025-01-05T22:39:16.000Z0984342605732942742447464034882843241967914228799800000000000000000000000x7b13a1c7f659d7dabcf2cb32c07692cd535ec4925875270cfd7d44a88282162b0x12a1b6df79169b22707a47d0f58b78c31122748e78716569151992000000000000000000000196100275016377322370669303622746770
0xcf533d0eefb072d1bb68e201eafc5368764daa0e900000000000000000000000000000000false2351968478898782411983186400000122922662150x6d5d2daaf8352cff054b48748d363652cd8ad6708d1386350036c93a7d3232b80x3b57579a35425a24c2a786dacebe1837c09e5fbb23-380502908914463419331625256055432025-01-05T14:20:46.000Z024557948203243939601783228000009000000000000000000000000000000000x4a3af6a0edec4b4505096b5c1217a96d60e957c9f463e726a1095ac34a617ecc0x3b57579a35425a24c2a786dacebe1837c09e5fbb360000000000000000000000000000000195302713228292216262173190746515170
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TradeService_LogDecreasePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
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_positionIdSTRINGUnique identifier for the trading position. String-encoded integer representing the position’s hash or ID in the protocol.
in_primaryAccountSTRINGPrimary 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_subAccountIdINT64Integer 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_subAccountSTRINGAddress of the sub-account associated with the position or transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_marketIndexSTRINGIdentifier 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_sizeSTRINGSize 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_increasedSizeSTRINGAmount 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_avgEntryPriceSTRINGAverage 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_entryBorrowingRateSTRINGBorrowing 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_lastFundingAccruedSTRINGAccumulated 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_realizedPnlSTRINGRealized 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_reserveValueE30STRINGReserve 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_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
addressin_sizeremovedin_pricelog_indexblock_numberin_positionIdin_subAccountin_marketIndexin_realizedPnlblock_timestampin_subAccountIdin_avgEntryPricein_increasedSizetransaction_hashin_primaryAccountin_reserveValueE30in_entryBorrowingRatein_lastFundingAccrued
0xcf533d0eefb072d1bb68e201eafc5368764daa0e500000000000000000000000000000000false908009619886536040788714835679161970570130x004ec74b9bfd345dda334cd831fdb620ce883b4832cc503c07f32648a81c274e0x98c80d89cbb286ca2a4af0973d3c84a86888d7c02602024-04-03T05:44:19.000Z09080096198865360407887148356795000000000000000000000000000000000x91fd9e33a8184c02959c1b489c6598999f178beee387ddb60df53cf9c3b74e9d0x98c80d89cbb286ca2a4af0973d3c84a86888d7c02500000000000000000000000000000014633685497494063-18391219165785673
0xcf533d0eefb072d1bb68e201eafc5368764daa0e9000000000000000000000000000000000false854238651725552226067427754828161970616990x0099242d35f21be0f37d68cafa3dfe4d5aef5fc137b27fc3d8b4179478ec6adf0x1979630a6ab98a0cce107aa8edc4ed1057f2bd435002024-04-03T06:03:56.000Z085423865172555222606742775482890000000000000000000000000000000000xdbef6d562e585c1936040d734d0ca09e02f382db9e23cb95867ac108433f2ded0x1979630a6ab98a0cce107aa8edc4ed1057f2bd4336000000000000000000000000000000007361484871592156373224764409099721
0xcf533d0eefb072d1bb68e201eafc5368764daa0e-31000000000000000000000000000000false3339127563804152320378912046385554191971212930x00dbaac5bb3ea9c1df872e6ef5fc6d52b8701cf8fd59a79399133ea2cc0ab00c0x68247c46cd3d1feb0ef907c571da04fa599f6a01002024-04-03T10:14:04.000Z03352975703703306145694140590123451-100000000000000000000000000000000x34f082f074d58b09f6a0bf3c3f98eed4aa7a4510c378a9bb7552b450b69a47ca0x68247c46cd3d1feb0ef907c571da04fa599f6a011085000000000000000000000000000073649591597938699291474460961918238
Query with partition filter
SELECT *
FROM `tt-contracts.hmx_v1_arbitrum.TradeService_LogIncreasePosition_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100