hegic_v1_arbitrum

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.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_data`	`STRUCT<amount STRING, strike STRING>`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_negativepnl`	`STRING`	Potential 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_positivepnl`	`STRING`	Potential 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_period`	`STRING`	Numeric identifier representing a time period for rewards distribution or incentive tracking. Numeric string representation.
`in_additional`	`ARRAY<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.

Sample Data

in_id	address	in_data	removed	in_period	log_index	block_number	in_additional	in_negativepnl	in_positivepnl	block_timestamp	transaction_hash
279	0x2ef16ae1d45c1c5a0d19da33a8e61144f40aef0f	{“amount”:“2500000000000000000”,“strike”:“163166689414”}	false	604800	1	35569814	[]	69030731	86288414	2022-11-05T22:23:30.000Z	0x49907f5bf34b5ef0743e529e8cc11da035e67ea904ee6e55279b399cd4e5c80a
276	0x84554e3ce5e7ee864612c644b6fcbb60f43b6244	{“amount”:“205000000000000000”,“strike”:“164015635775”}	false	604800	1	35509812	[]	20234527	80635089	2022-11-05T16:37:01.000Z	0x26bb63d3eba6b96fad19aa5f7cbb23169def53ae8297f491bbd067bad5778281
278	0x75cee0a3c16d5fa4c0e2c87480f8a4c63d7f0adc	{“amount”:“6500000000000000000”,“strike”:“163244767798”}	false	604800	1	35566781	[]	110818885	2011363096	2022-11-05T22:02:17.000Z	0x07afc5d121d8d356451a592ce22c0be2361e0faeb43cf28e1ebbdc31a1bb0def

Example Query

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.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	address	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
7435	0xec096ea6eb9aa5ea689b0cf00882366e92377371	false	178584989	1	0x0ce14ece9038e9ee8bae11893b0dd79cf8749a7d	159473143	2023-12-12T19:05:59.000Z	0x098524f8f5374b344a0d5ff8956be62dc15d02ae348f58f5f0bddef4bfd6d1f7
7701	0xec096ea6eb9aa5ea689b0cf00882366e92377371	false	175627350	11	0xf762ea49cf3fa0ad5a28f3ce0d490dd3e27f959c	159459743	2023-12-12T18:06:24.000Z	0x5a98c27eb65d2ca76742b61b9ddc55ba18e8ca99d1d26be313cbea77900f7c8d
7658	0xec096ea6eb9aa5ea689b0cf00882366e92377371	false	70155150	4	0xf762ea49cf3fa0ad5a28f3ce0d490dd3e27f959c	159459676	2023-12-12T18:06:07.000Z	0x08075bad2c635a8a6634aee5187a706c16d102c768871fc6c09e5dc87e46e7b2

Example Query

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.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

in_to	address	in_from	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x4a9589964cd00664068f298abcbd4db112df481c	0x5fe380d68fee022d8acd42dc4d36fbfb249a76d5	0x0000000000000000000000000000000000000000	false	2	7881	165094682	2023-12-29T22:55:04.000Z	0x3cdb91213f6c4e80d0662ddf01ed14fb25402ac5e10db3c4336ba75772ee0301
0xf015fd0a62cbd6eb21e581520c561f97abd0350b	0x5fe380d68fee022d8acd42dc4d36fbfb249a76d5	0x0000000000000000000000000000000000000000	false	2	7880	164878831	2023-12-29T07:42:11.000Z	0xc15d00854a7f534a02bbbcb1c5e8788058ad3fe12ffaf9265264fb039f8420a5
0x0e6c677d8a38bf7133fa79d961d800171c26bb45	0x5fe380d68fee022d8acd42dc4d36fbfb249a76d5	0x0000000000000000000000000000000000000000	false	0	1426	49527382	2022-12-29T04:31:43.000Z	0x0d55cd9e445ac22430d8822d0d32801a4f2b9a5125e196358be61eb8ece644aa

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

HegicStrategyCall_Acquired_event

OperationalTreasury_Paid_event

PositionsManager_Transfer_event

​Tables

​HegicStrategyCall_Acquired_event

​OperationalTreasury_Paid_event

​PositionsManager_Transfer_event

Tables

HegicStrategyCall_Acquired_event

OperationalTreasury_Paid_event

PositionsManager_Transfer_event