Skip to main content

​
Tables

​
HegicStrategyCall_Acquired_event

Option purchase events from Hegic v1 call options strategy on Arbitrum, capturing strike prices, contract amounts, holding periods, and profit/loss scenarios. Used for analyzing options trading activity and pricing dynamics on the protocol.
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_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_dataSTRUCT<amount STRING, strike STRING>Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
in_negativepnlSTRINGPotential loss amount in USDC (6 decimals) if the option position moves against the holder at expiration. Represents the maximum downside risk for this Hegic call option strategy.
in_positivepnlSTRINGPotential profit in the smallest unit of the underlying asset if the option expires in-the-money. Represents the maximum gain scenario for this call option position at expiration.
in_periodSTRINGNumeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
in_additionalARRAY<STRING>Additional parameters or metadata passed during the option acquisition, typically empty for standard call options. This field is an array that may contain supplementary data for customized or complex option structures.
in_idaddressin_dataremovedin_periodlog_indexblock_numberin_additionalin_negativepnlin_positivepnlblock_timestamptransaction_hash
2790x2ef16ae1d45c1c5a0d19da33a8e61144f40aef0f{“amount”:“2500000000000000000”,“strike”:“163166689414”}false604800135569814[]69030731862884142022-11-05T22:23:30.000Z0x49907f5bf34b5ef0743e529e8cc11da035e67ea904ee6e55279b399cd4e5c80a
2760x84554e3ce5e7ee864612c644b6fcbb60f43b6244{“amount”:“205000000000000000”,“strike”:“164015635775”}false604800135509812[]20234527806350892022-11-05T16:37:01.000Z0x26bb63d3eba6b96fad19aa5f7cbb23169def53ae8297f491bbd067bad5778281
2780x75cee0a3c16d5fa4c0e2c87480f8a4c63d7f0adc{“amount”:“6500000000000000000”,“strike”:“163244767798”}false604800135566781[]11081888520113630962022-11-05T22:02:17.000Z0x07afc5d121d8d356451a592ce22c0be2361e0faeb43cf28e1ebbdc31a1bb0def
Query with partition filter
SELECT *
FROM `tt-contracts.hegic_v1_arbitrum.HegicStrategyCall_Acquired_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
OperationalTreasury_Paid_event

Payment events from Hegic v1 protocol’s operational treasury contract on Arbitrum. Records outbound payments to accounts with sequential payment IDs and amounts, useful for tracking protocol fee distributions and treasury operations.
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_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_accountSTRINGAccount address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_idaddressremovedin_amountlog_indexin_accountblock_numberblock_timestamptransaction_hash
74350xec096ea6eb9aa5ea689b0cf00882366e92377371false17858498910x0ce14ece9038e9ee8bae11893b0dd79cf8749a7d1594731432023-12-12T19:05:59.000Z0x098524f8f5374b344a0d5ff8956be62dc15d02ae348f58f5f0bddef4bfd6d1f7
77010xec096ea6eb9aa5ea689b0cf00882366e92377371false175627350110xf762ea49cf3fa0ad5a28f3ce0d490dd3e27f959c1594597432023-12-12T18:06:24.000Z0x5a98c27eb65d2ca76742b61b9ddc55ba18e8ca99d1d26be313cbea77900f7c8d
76580xec096ea6eb9aa5ea689b0cf00882366e92377371false7015515040xf762ea49cf3fa0ad5a28f3ce0d490dd3e27f959c1594596762023-12-12T18:06:07.000Z0x08075bad2c635a8a6634aee5187a706c16d102c768871fc6c09e5dc87e46e7b2
Query with partition filter
SELECT *
FROM `tt-contracts.hegic_v1_arbitrum.OperationalTreasury_Paid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
PositionsManager_Transfer_event

ERC-721 token transfer events from Hegic v1 options protocol on Arbitrum, tracking minting and ownership changes of tokenized options positions. Useful for analyzing position creation flows and holder distributions.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_toaddressin_fromremovedlog_indexin_tokenIdblock_numberblock_timestamptransaction_hash
0x4a9589964cd00664068f298abcbd4db112df481c0x5fe380d68fee022d8acd42dc4d36fbfb249a76d50x0000000000000000000000000000000000000000false278811650946822023-12-29T22:55:04.000Z0x3cdb91213f6c4e80d0662ddf01ed14fb25402ac5e10db3c4336ba75772ee0301
0xf015fd0a62cbd6eb21e581520c561f97abd0350b0x5fe380d68fee022d8acd42dc4d36fbfb249a76d50x0000000000000000000000000000000000000000false278801648788312023-12-29T07:42:11.000Z0xc15d00854a7f534a02bbbcb1c5e8788058ad3fe12ffaf9265264fb039f8420a5
0x0e6c677d8a38bf7133fa79d961d800171c26bb450x5fe380d68fee022d8acd42dc4d36fbfb249a76d50x0000000000000000000000000000000000000000false01426495273822022-12-29T04:31:43.000Z0x0d55cd9e445ac22430d8822d0d32801a4f2b9a5125e196358be61eb8ece644aa
Query with partition filter
SELECT *
FROM `tt-contracts.hegic_v1_arbitrum.PositionsManager_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100