opyn_v1_ethereum

Tables

Controller_BurnShort_event

BurnShort events from Opyn v1 options protocol on Ethereum, recording when users burn (close) short option positions from their vaults. Used for tracking option position lifecycle and vault collateral management analysis.

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_sender`	`STRING`	Address that initiated 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.
`in_vaultId`	`STRING`	Unique identifier for a vault within the protocol. Numeric string representation.

Sample Data

address	removed	in_amount	in_sender	log_index	in_vaultId	block_number	block_timestamp	transaction_hash
0x64187ae08781b09368e6253f9e94951243a493d5	false	2184662623363993606	0x3b960e47784150f5a63777201ee2b15253d713e8	240	286	16664841	2023-02-19T19:54:23.000Z	0xee37a1d2972ca3337d7f979136e1bc5006b99248b3eee127c33bc0a20f1f1673
0x64187ae08781b09368e6253f9e94951243a493d5	false	2684763016733192112	0x3b960e47784150f5a63777201ee2b15253d713e8	587	286	17977266	2023-08-23T11:59:59.000Z	0x2b7ad15bbe11df16d0bbb25d86d8b11a3dea524a0d61962fa4a2f2a4e6d550ab
0x64187ae08781b09368e6253f9e94951243a493d5	false	3272270927985385809	0x3b960e47784150f5a63777201ee2b15253d713e8	302	286	17973729	2023-08-23T00:07:35.000Z	0xd252c46eb91ebcb11b53c68815b1c6df8c1d6f01d3b407746d97e96b325a015e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.Controller_BurnShort_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Controller_MintShort_event

Short position minting events from Opyn v1 options protocol on Ethereum, capturing vault-level issuance of options contracts. Records vault ID, minted option amounts, and sender addresses for tracking collateralized options creation and position management.

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_sender`	`STRING`	Address that initiated 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.
`in_vaultId`	`STRING`	Unique identifier for a vault within the protocol. Numeric string representation.

Sample Data

address	removed	in_amount	in_sender	log_index	in_vaultId	block_number	block_timestamp	transaction_hash
0x64187ae08781b09368e6253f9e94951243a493d5	false	125745702531558414294	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	588	309	15415856	2022-08-26T14:18:13.000Z	0x7d58dd09580786cee1020bb2ebb4850443dff6d215efd490961af519dff6ec57
0x64187ae08781b09368e6253f9e94951243a493d5	false	17498274995819470223	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	418	60	15414666	2022-08-26T09:49:34.000Z	0x33e168d023524be0186422365af43841c8290f3e7ae13b1ed70038efcee5d2b0
0x64187ae08781b09368e6253f9e94951243a493d5	false	111299260606885297	0x3b960e47784150f5a63777201ee2b15253d713e8	548	286	15414022	2022-08-26T07:15:13.000Z	0xd0f14530516d0fb7e7dd427a94686d296c22ac320b6b46e4a3f73caffa8cc626

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.Controller_MintShort_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Controller_OpenVault_event

Vault creation events from Opyn v1 options protocol on Ethereum, recording when users open new collateralized positions for minting options. Useful for tracking vault lifecycle and user position management activity.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_vaultId`	`STRING`	Unique identifier for a vault within the protocol. Numeric string representation.

Sample Data

address	removed	in_sender	log_index	in_vaultId	block_number	block_timestamp	transaction_hash
0x64187ae08781b09368e6253f9e94951243a493d5	false	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	77	368	16130690	2022-12-07T05:08:47.000Z	0x5d29424599a4b2d414ed943635d86b8af6835eb3c4a6d9ccfbff3f5fc600679a
0x64187ae08781b09368e6253f9e94951243a493d5	false	0x1433c27dc3cb0567aa84ea17bfb48509a42b171b	553	107	14179824	2022-02-10T18:05:00.000Z	0x895a93dd7d6b9a60b27cdafc1150e16454841476a402b3d970d898220b06dd8f
0x64187ae08781b09368e6253f9e94951243a493d5	false	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	157	108	14180204	2022-02-10T19:29:51.000Z	0x1bf74dd5b93fc43d15fc30451a2bea8eb050fbbcca9ba2530fb82adc1bb2974f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.Controller_OpenVault_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CrabStrategyV1_FlashDeposit_event

Flash deposit events from Opyn’s Crab Strategy V1 vault on Ethereum, capturing instant deposits with corresponding strategy token outputs. Used for tracking vault entry transactions, depositor behavior, and deposit-to-share conversion rates.

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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositedAmount`	`STRING`	Amount of tokens deposited by the user in the flash deposit transaction. String-encoded integer representing the value in smallest unit (wei).
`in_tradedAmountOut`	`STRING`	Amount of tokens received by the depositor from the trade executed during the flash deposit. String-encoded integer representing the value in smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_depositor	block_timestamp	transaction_hash	in_depositedAmount	in_tradedAmountOut
0xf205ad80bb86ac92247638914265887a8baa437d	false	665	14158386	0x9897a13dcb54b4e8743b86c3724f98b185e94e69	2022-02-07T10:25:28.000Z	0xf5bd8046943811a605f8222390bc5e40433348e32176b8ee8b3819bdc3f2755c	983100891113281250	1756866682611163206
0xf205ad80bb86ac92247638914265887a8baa437d	false	279	14158440	0x4e481165b434eb76d09e82bd16b6b649c01c664a	2022-02-07T10:37:28.000Z	0x43a9288f7314fccfda3e75c6b0e731fa0b01b237f4461fc8c2289847f240ef34	1968719482421875000	3518232662934221643
0xf205ad80bb86ac92247638914265887a8baa437d	false	366	14156916	0x5edf60c9dc63efa6b9cd41d0aed34ea1c7e7f603	2022-02-07T04:48:52.000Z	0xee75391425547f6e874f22aa8002cac3c0c4090c77f3f68ff7077d2a8f26ac5c	296163940429687500	529264660662177625

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.CrabStrategyV1_FlashDeposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CrabStrategyV1_FlashWithdraw_event

Flash withdrawal events from Opyn’s Crab Strategy V1 vault on Ethereum, recording instantaneous redemptions of Crab vault shares (crabAmount) for wSqueeth (wrapped Squeeth power perpetual) tokens. Tracks user exits from the delta-neutral ETH² strategy with withdrawer addresses and redeemed token amounts.

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_withdrawer`	`STRING`	Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
`in_crabAmount`	`STRING`	Amount of Crab strategy tokens involved in the operation. Decimal string representing the token quantity in smallest units (wei-equivalent, 18 decimals).
`in_wSqueethAmount`	`STRING`	Amount of wSqueeth tokens withdrawn in the flash withdrawal operation. Decimal string representing the token quantity in smallest units (wei-equivalent, 18 decimals).

Sample Data

address	removed	log_index	block_number	in_crabAmount	in_withdrawer	block_timestamp	transaction_hash	in_wSqueethAmount
0xf205ad80bb86ac92247638914265887a8baa437d	false	279	14159003	1627261623743604974	0xd435231bed0d4de8541d94ec93e1e094ae633b72	2022-02-07T12:49:46.000Z	0x88cc846ff4ac50e1a458ea9e21dec673f57b2ece19c51da286beaa12f117b4c6	2662196389823904424
0xf205ad80bb86ac92247638914265887a8baa437d	false	106	14157845	1080847990421224607	0x7fc55ecf955f1c0072b3b6cacab654532f10f017	2022-02-07T08:19:12.000Z	0x3f1ea30d77fe34f29f9e17fced2542ab4578a445eac7c8aa6e2091ade3efed2c	1768264903481298165
0xf205ad80bb86ac92247638914265887a8baa437d	false	162	14155956	1677758359038868528	0x45f47efaed81d5c4fb1bf4446621e1ff720c3b4c	2022-02-07T01:12:54.000Z	0x4dc94ae44e66b5e51556851bf1acad98498e161ed10ae4fdef0f85d30467586a	2933867487619672674

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.CrabStrategyV1_FlashWithdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CrabStrategyV2_FlashDeposit_event

Flash deposit events from Opyn’s Crab Strategy V2 vault on Ethereum, capturing instant deposits where users exchange ETH for strategy tokens in atomic transactions. Records depositor addresses, input amounts (in wei), and output token amounts for analyzing vault entry flows and conversion rates.

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_depositor`	`STRING`	Address of the user who initiated the deposit or cross-chain transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositedAmount`	`STRING`	Amount of tokens deposited by the user in the flash deposit transaction. String-encoded integer representing the value in smallest unit (wei).
`in_tradedAmountOut`	`STRING`	Amount of tokens received by the depositor from the trade executed during the flash deposit. String-encoded integer representing the value in smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_depositor	block_timestamp	transaction_hash	in_depositedAmount	in_tradedAmountOut
0x3b960e47784150f5a63777201ee2b15253d713e8	false	251	16125736	0x1e04a53c92e81cdba0aa55ccaa623dbb385016fc	2022-12-06T12:24:59.000Z	0xa9dce11bbee35dc270c513f3fe21f4579f9a89617590bbfc4c150686ce4c13e3	196574468994140625	1922589706952583347
0x3b960e47784150f5a63777201ee2b15253d713e8	false	804	16122850	0x96ad6be504d153a25d41a476d5202425e85135fb	2022-12-06T02:45:35.000Z	0x095376cd71fd8a358600548315e1043b8ce9ca5f738575cd72abcb816aecf5b2	198567199707031250	1942079539874100726
0x3b960e47784150f5a63777201ee2b15253d713e8	false	225	16125404	0xfbaa6104ce2321ea98f0ad6c5ab3d49871bc0f4f	2022-12-06T11:18:23.000Z	0x5dfc3e97526dc4f66c04b1ce8c46a986057eeba60763c315fa41f1a93a1b358e	787823486328125000	7705280006403580935

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.CrabStrategyV2_FlashDeposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CrabStrategyV2_FlashWithdraw_event

Flash withdrawal events from Opyn’s Crab Strategy V2 vault on Ethereum, tracking instant redemptions of Crab vault tokens for wSqueeth (wrapped Squeeth power perpetuals). Records withdrawer addresses and amounts of both Crab tokens burned and wSqueeth received for analyzing vault exit activity.

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_withdrawer`	`STRING`	Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string.
`in_crabAmount`	`STRING`	Amount of Crab strategy tokens involved in the operation. Decimal string representing the token quantity in smallest units (wei-equivalent, 18 decimals).
`in_wSqueethAmount`	`STRING`	Amount of wSqueeth tokens withdrawn in the flash withdrawal operation. Decimal string representing the token quantity in smallest units (wei-equivalent, 18 decimals).

Sample Data

address	removed	log_index	block_number	in_crabAmount	in_withdrawer	block_timestamp	transaction_hash	in_wSqueethAmount
0x3b960e47784150f5a63777201ee2b15253d713e8	false	332	18391528	45479031030533354	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-10-20T12:26:47.000Z	0x4eb5b9fe2b1567baab581df7c4c5e6b475f4f89fa5e04b0e2a9ba9a14686a673	948198426536019214
0x3b960e47784150f5a63777201ee2b15253d713e8	false	317	18389642	232662105290471735	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-10-20T06:06:35.000Z	0xda012243c59d749d4ea3015e09e070ad361b8086db48329297220d986f56fcd7	4850803483541055017
0x3b960e47784150f5a63777201ee2b15253d713e8	false	290	18389848	246571252889357729	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-10-20T06:47:47.000Z	0x246f34836183431ec266f2298a2733c25703436fa772a8bae974688631f31bbb	5140797170057077518

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.CrabStrategyV2_FlashWithdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlashZen_FlashDeposit_event

FlashZen deposit events from Opyn v1 on Ethereum capturing single-transaction positions combining ETH deposits, USDC borrowing, WETH lending, Crab strategy tokens, and wPowerPerp (wrapped Power Perpetual) minting. Used for analyzing leveraged DeFi strategy executions and position compositions in Opyn’s options 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_crabAmount`	`STRING`	Amount of Crab strategy tokens involved in the operation. Decimal string representing the token quantity in smallest units (wei-equivalent, 18 decimals).
`in_ethDeposited`	`STRING`	Amount of ETH deposited by the user in this flash deposit transaction, denominated in wei (1e18 wei = 1 ETH). Sample values show deposits ranging from 0.1 to 1 ETH.
`in_wPowerPerpToMint`	`STRING`	Quantity of wPowerPerp (wrapped power perpetual) tokens minted in this flash deposit transaction. Denominated in wei (18 decimals), typically ranges from less than 1 to over 9 wPowerPerp tokens.
`in_usdcToBorrow`	`STRING`	Amount of USDC borrowed through the flash loan mechanism in the deposit transaction, denominated in the smallest USDC unit (6 decimals). This represents the USDC liquidity accessed to facilitate the leveraged position entry.
`in_wethToLend`	`STRING`	Amount of Wrapped Ether (WETH) designated for lending in the flash deposit transaction, denominated in wei (smallest ETH unit). Typically slightly less than the deposited ETH amount due to transaction costs or protocol requirements.

Sample Data

address	in_from	removed	log_index	block_number	in_crabAmount	in_wethToLend	block_timestamp	in_ethDeposited	in_usdcToBorrow	transaction_hash	in_wPowerPerpToMint
0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	0x10cc16d56358168e9b286f2c2f93d27f52b8d675	false	409	16399959	51905642525856685	99703654783836359	2023-01-13T19:27:59.000Z	100000000000000000	66209249	0xb115907ef8bfb2b545e2b1aa653ac1a1c20424abba4cb996ef01e7d4c1e8b39a	857444211863996756
0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	0xf2719419a42fd83f9a30b9a73b3eabc61c3c6c84	false	401	16400925	51489855109323975	98905659214022686	2023-01-13T22:41:35.000Z	100000000000000000	65679654	0x54953f9cf631905162cd008c9be4faf3623b2509e783eda66c5472ff37790614	850575700150760973
0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	0x6b96ea754bc1f36b9d2c145c786119ebe74e4190	false	448	16400085	129647964578183640	249036265869211810	2023-01-13T19:53:11.000Z	250000000000000000	165375227	0xf6641eeb2d9a9296696212fad38fa8acabc0812d25e675ce3abd93968850aba3	2141691950969143904

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.FlashZen_FlashDeposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlashZen_FlashWithdraw_event

Flash withdrawal events from Opyn v1’s FlashZen contract on Ethereum, recording bull token amounts redeemed and ETH returned to users. Useful for tracking options position closures and liquidity flows in the Opyn 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_bullAmount`	`STRING`	Amount of BULL tokens (Opyn’s bullish position tokens) withdrawn via flash transaction, denominated in wei (base units of 10^-18). Values represent precise token quantities being withdrawn from the FlashZen contract on Ethereum.
`in_ethReturned`	`STRING`	Amount of ETH returned to the recipient in wei (10^-18 ETH). String-encoded integer representing the ETH proceeds from the flash withdrawal operation.

Sample Data

in_to	address	removed	log_index	block_number	in_bullAmount	in_ethReturned	block_timestamp	transaction_hash
0x7d4ad2e4bc426a45f34bcd53766f39e6eb61f013	0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	false	401	16298219	365784717372829387	796756014824923787	2022-12-30T14:36:11.000Z	0x545ba89a93257d584dd71e43afce4815191923df2dae68a109f7133c3dadbdd4
0x7833175e5aca23ddc9268ec43148a68e3389b00a	0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	false	252	16299811	458902544171816452	997457528525079858	2022-12-30T19:56:35.000Z	0xbe3b950d9765141ce63131b085acf02f5a2aa9ec4257b14ff9b671ae95e26650
0xf74d66c85ee082cb4921864ff0bb67145f97ae48	0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	false	188	16295286	458453268956785381	997331604777449636	2022-12-30T04:45:59.000Z	0xe88b28842f7fbf6a5f760c15761dd8c916d9a198c1239a595263260c8aa35fc6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.FlashZen_FlashWithdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ShortHelper_closeShort_function

Short position closure transactions on Opyn v1 Ethereum power perpetuals (Squeeth). Records vault closures with collateral withdrawals and perpetual buybacks via Uniswap V3, including swap parameters and gas costs for position exit analysis.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__vaultId`	`STRING`	Unique identifier for the vault position. String-encoded integer used to reference a specific vault instance within the protocol.
`in__wPowerPerpAmount`	`STRING`	Amount of wrapped Power Perpetual (wPowerPerp) tokens being closed from the vault, denominated in wei. Typically represents standard amounts like 25 ETH or 50 ETH worth of perpetual position being unwound.
`in__withdrawAmount`	`STRING`	Amount of collateral (in wei) withdrawn from the Opyn vault upon closing the short position. Null for failed transactions or when no withdrawal occurs.
`in__exactOutputParams`	`STRUCT<tokenIn STRING, tokenOut STRING, fee STRING, recipient STRING, deadline STRING, amountOut STRING, amountInMaximum STRING, sqrtPriceLimitX96 STRING>`	Swap parameters for exact output trades executed via Uniswap V3 to close the short position. Includes token addresses, amounts, slippage limits, and deadline timestamp for the DEX transaction.

Sample Data

gas	value	status	gas_used	signature	to_address	in__vaultId	block_number	from_address	block_timestamp	transaction_hash	in__withdrawAmount	in__wPowerPerpAmount	in__exactOutputParams
807180	5997158070489633000	true	487806	0x17fd9e0e	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	341	15696791	0xb9d7a0daa17c1ffe90c27b0fe3b38ff07edc9937	2022-10-07T14:22:23.000Z	0x5e63b864d590924e3345ebf4e8cd80079039474ed05f963fa11dadc7515177e7	13816275336755294646	100000000000000000000	{“fee”:“3000”,“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1665238925”,“tokenOut”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountOut”:“100000000000000000000”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountInMaximum”:“5997158070489633000”,“sqrtPriceLimitX96”:“0”}
760162	2762969853210307000	true	454395	0x17fd9e0e	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	52	14112061	0x1b1ef65bb57862c88fb3ca5aaab8746791928485	2022-01-31T06:39:40.000Z	0x69dbaed2085ae450038939027a79baaea1bbeab7fef0cd8509394dc64b75d079	6900000000000000000	11349959584492119929	{“fee”:“3000”,“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1643697561”,“tokenOut”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountOut”:“11349959584492119929”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountInMaximum”:“2762969853210307050”,“sqrtPriceLimitX96”:“0”}
653662	12032540106166501000	true	385319	0x17fd9e0e	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	74	14114525	0xdd1722fa301bf9036eedca5e290dfbcb33a16a1f	2022-01-31T15:48:28.000Z	0x5ec7f60737192a5ac9cabde49f4d8215ec23399345fbc0ac84e5c6ab553b2a39	21329434418844867699	50000000000000000000	{“fee”:“3000”,“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1643730491”,“tokenOut”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountOut”:“50000000000000000000”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountInMaximum”:“12032540106166502000”,“sqrtPriceLimitX96”:“0”}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.ShortHelper_closeShort_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ShortHelper_openShort_function

Function calls to Opyn v1’s ShortHelper contract for opening short positions with collateral and power perpetual amounts on Ethereum. Includes Uniswap v3 swap parameters for hedging and vault identifiers for position tracking.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__vaultId`	`STRING`	Unique identifier for the vault position. String-encoded integer used to reference a specific vault instance within the protocol.
`in__powerPerpAmount`	`STRING`	Amount of power perpetual (oSQTH) tokens being shorted in the position. Value is in wei (18 decimals), typically ranging from ~10 to ~200 oSQTH tokens based on collateral.
`in__uniNftId`	`STRING`	Identifier for an existing Uniswap V3 liquidity position NFT used in this short position operation. Typically ‘0’ when opening a new short without an existing LP position.
`in__exactInputParams`	`STRUCT<tokenIn STRING, tokenOut STRING, fee STRING, recipient STRING, deadline STRING, amountIn STRING, amountOutMinimum STRING, sqrtPriceLimitX96 STRING>`	Structured parameters for the Uniswap V3 swap executed as part of opening the short position, including token addresses, amounts, slippage limits, and fee tier. Contains nested fields defining the exact swap routing and execution constraints for converting collateral or power perpetual tokens.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash	in__powerPerpAmount	in__exactInputParams
1130733	69000000000000000000	true	646470	0xe56cfbbe	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	14047649	0x84832e0e6678a6d505c76c2c97112524aaeb64cc	2022-01-21T07:40:00.000Z	0xc630cde4c51796ae2dd4b9014aa9bba1d076b96339324e270f6b1bfc2503f2e5	105874210272559284203	{“fee”:“3000”,“tokenIn”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountIn”:“111860323301922880640”,“deadline”:“1642837201”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountOutMinimum”:“32983619700291708800”,“sqrtPriceLimitX96”:“0”}
1049116	6900000000000000000	true	592073	0xe56cfbbe	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	14047862	0xd9a220fc883d60aeb81d99ebe668f1b990f63cdd	2022-01-21T08:30:16.000Z	0x8360895217a7b801c7c4f0b2f770e5001a94f4834648f18ac224a5696ee21b03	11941388463054457413	{“fee”:“3000”,“tokenIn”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountIn”:“12618257484044342837”,“deadline”:“1642840183”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountOutMinimum”:“3651849476834203550”,“sqrtPriceLimitX96”:“0”}
1145557	83000000000000000000	true	656441	0xe56cfbbe	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	14049712	0x7bdfe11c4981dd4c33e1aa62457b8773253791b3	2022-01-21T15:25:56.000Z	0x6ee2a54b507bec29c189943afdf2175c1631cc5f9c864d4cc5e35496883a2fa4	132265328112534060253	{“fee”:“3000”,“tokenIn”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountIn”:“139978769795633714030”,“deadline”:“1642865144”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountOutMinimum”:“41791373916939780700”,“sqrtPriceLimitX96”:“0”}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.opyn_v1_ethereum.ShortHelper_openShort_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Controller_BurnShort_event

Controller_MintShort_event

Controller_OpenVault_event

CrabStrategyV1_FlashDeposit_event

CrabStrategyV1_FlashWithdraw_event

CrabStrategyV2_FlashDeposit_event

CrabStrategyV2_FlashWithdraw_event

FlashZen_FlashDeposit_event

FlashZen_FlashWithdraw_event

ShortHelper_closeShort_function

ShortHelper_openShort_function

​Tables

​Controller_BurnShort_event

​Controller_MintShort_event

​Controller_OpenVault_event

​CrabStrategyV1_FlashDeposit_event

​CrabStrategyV1_FlashWithdraw_event

​CrabStrategyV2_FlashDeposit_event

​CrabStrategyV2_FlashWithdraw_event

​FlashZen_FlashDeposit_event

​FlashZen_FlashWithdraw_event

​ShortHelper_closeShort_function

​ShortHelper_openShort_function

Tables

Controller_BurnShort_event

Controller_MintShort_event

Controller_OpenVault_event

CrabStrategyV1_FlashDeposit_event

CrabStrategyV1_FlashWithdraw_event

CrabStrategyV2_FlashDeposit_event

CrabStrategyV2_FlashWithdraw_event

FlashZen_FlashDeposit_event

FlashZen_FlashWithdraw_event

ShortHelper_closeShort_function

ShortHelper_openShort_function