squeeth_v1_ethereum

Tables

Controller_BurnShort_event

Short position reduction events from Squeeth (ETH² perpetual) protocol on Ethereum, recording the amount of oSQTH tokens burned and the vault ID affected. Used for tracking position closures and vault collateral 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	10191374407253541021	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	717	89	14196543	2022-02-13T07:46:40.000Z	0xb4c64766cb5edd28c74576dd80cccabb9b4e3915651941dbe6968f9f0392dd6f
0x64187ae08781b09368e6253f9e94951243a493d5	false	103593401864932010771	0xf205ad80bb86ac92247638914265887a8baa437d	3	70	14195119	2022-02-13T02:45:47.000Z	0x0623b0c22d20518f85fe1286efa7e4280eb13a1949bbf14c0c00562bbafc94ae
0x64187ae08781b09368e6253f9e94951243a493d5	false	53106528594262478644	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	141	399	16721198	2023-02-27T18:05:11.000Z	0xd37332a4b1f1e569428c9f1cd06d0d6a6502eafc700155b2e2a03121ccbe4fe6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.squeeth_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 Squeeth (squared ETH) protocol on Ethereum, tracking when users create leveraged short exposure by minting oSQTH tokens into vaults. Used for analyzing leverage positions, vault activity, and short-side liquidity dynamics.

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	10000000000000000000	0x35e5b9c65334238184f7785de8e34409be9572e6	139	179	14583896	2022-04-14T13:50:28.000Z	0x25c23fe76161af1046b9b5a285ca9835d2a38e65c84429d58c84e0631ce20acf
0x64187ae08781b09368e6253f9e94951243a493d5	false	10000000000000000000	0x35e5b9c65334238184f7785de8e34409be9572e6	95	179	14583962	2022-04-14T14:07:45.000Z	0x8fac89c49dfc63a0f80611ba09b93f3032a597a0053f955ad6d69bef0048071b
0x64187ae08781b09368e6253f9e94951243a493d5	false	19420390767518991173	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	157	189	14584146	2022-04-14T14:41:27.000Z	0x76f5a573dd4c5124bd0f71418f500fe604e403fed7048359907db477f92fe0ef

Example Query

Query with partition filter

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

Controller_OpenVault_event

Vault creation events from Squeeth (Power Perpetual) protocol on Ethereum, recording when users open new collateralized positions. Used to track vault lifecycle initiation and analyze user onboarding patterns across the protocol’s lifespan.

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	148	222	14756152	2022-05-11T17:24:55.000Z	0x3405372a83ab422dcda79e4cf4f05b67c65e39ffc072cad93fd053d5f9edaab2
0x64187ae08781b09368e6253f9e94951243a493d5	false	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	62	126	14218097	2022-02-16T16:02:40.000Z	0x0d1ed15d5c954449d41dc91b7a82e1bb891ed9a8127432e1d6cbfc25940c9a0f
0x64187ae08781b09368e6253f9e94951243a493d5	false	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	149	127	14218390	2022-02-16T17:04:20.000Z	0xd3ee715b11dda57f5edc7c813cec16472386c5ae62077ed440a68e34de31dfca

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.squeeth_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, recording instant deposits with deposited amounts and corresponding strategy token outputs. Useful for analyzing vault entry activity 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	428	14538686	0x25f9278827072c1f3e66bb115acecb35ee33da12	2022-04-07T12:21:04.000Z	0x2bf10e153d0ba3069370d1b414186396a4647f17c2fc8550d8b33e36f199abf0	684293365478515625	1347934266839813694
0xf205ad80bb86ac92247638914265887a8baa437d	false	294	14539407	0x6ef86f5fda69e0f2baacb9a7f04a54c5de0cceed	2022-04-07T14:55:55.000Z	0x30e1ef7b64b45f9dce6f2cb2dcf94dafdf290b7ed22d974b0942da3b0b2afa59	10000000000000000	20071423026577955
0xf205ad80bb86ac92247638914265887a8baa437d	false	568	14541593	0xb7f9f538aa1b41ae2853eb63f1939187ffe70eb4	2022-04-07T23:03:37.000Z	0xa414a6a6538fca65b3874a465fe9ed276d313129bdb84643dae6062bd9cf3cd3	5959533691406250000	11961632176135852496

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.squeeth_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 instant exits where users redeem CRAB tokens for wSqueeth (wrapped Squeeth) positions. Tracks withdrawal amounts, redeemer addresses, and the exchange rate between vault shares and underlying positions for analyzing vault liquidity and user exit behavior.

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.squeeth_v1_ethereum.CrabStrategyV1_FlashWithdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CrabStrategyV2_FlashDeposit_event

Flash deposit events from Squeeth’s Crab Strategy V2 vault on Ethereum, recording instant deposits where users swap ETH for strategy tokens in a single transaction. Useful for analyzing user onboarding patterns and tracking deposited amounts versus tokens received.

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	291	16575920	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-02-07T09:10:11.000Z	0x57b1ba138537d05c9bbbc368bebea40badc9c0be44610d5959a21fb56a43e25c	240709046306653715	1967124834031091446
0x3b960e47784150f5a63777201ee2b15253d713e8	false	311	15839733	0x02ee2a6dcf969ebf38e6d7ce81f5927b855706ee	2022-10-27T13:32:47.000Z	0xc4bd1effa32f74df9f9b3cef44a06ec49d95a8e2b3b27b6d26dd12dbeed08147	337301041103184150	2477565813555473655
0x3b960e47784150f5a63777201ee2b15253d713e8	false	219	15842816	0x16b9fba174b9944f91b250888f52387c21b02ea6	2022-10-27T23:53:35.000Z	0x40b5ee18da5b21e61f1ec7d10c1ab005425d2ffdd5769234babfe4b943aa7f71	211851043701171875	1556102233551971198

Example Query

Query with partition filter

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

CrabStrategyV2_FlashWithdraw_event

Flash withdrawal events from Squeeth’s Crab Strategy V2 vault on Ethereum, recording instant redemptions of Crab vault tokens for underlying wSqueeth (wrapped Squeeth) positions. Used for analyzing user exit patterns and vault liquidity dynamics.

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	325	16598599	844475011880175712	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-02-10T13:16:35.000Z	0xdd6b6be18ea6a433d9c5692145502a84cc898ec78946a88d6c75b6ee128206f8	10821729889782520120
0x3b960e47784150f5a63777201ee2b15253d713e8	false	229	16598440	889371391982783759	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-02-10T12:44:47.000Z	0x0f9d2b1e563c06062ee516390423feed3ea8714be53870a923e70209601733ab	11397065443427498644
0x3b960e47784150f5a63777201ee2b15253d713e8	false	286	16598662	908238475461520724	0x2f55e27e669f070def7b5771db72f6b31a6d4df8	2023-02-10T13:29:23.000Z	0x7aaa3dc75a9c476220a3c2c070f2e91a78ece5393eda6886ad4a18902bf02fc1	11638842261382463211

Example Query

Query with partition filter

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

FlashZen_FlashDeposit_event

Flash deposit events from Squeeth’s FlashZen contract on Ethereum, recording atomic deposits where users contribute ETH to mint wPowerPerp (wrapped power perpetual) tokens, receive Crab strategy tokens, borrow USDC, and lend WETH in a single transaction. Used for analyzing Squeeth strategy vault entry points and leverage parameters.

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 into the FlashZen contract for this flash deposit operation, denominated in wei (1e18 = 1 ETH). Values are consistently round numbers like 0.25 ETH, 0.3 ETH, or 1.0 ETH in the samples.
`in_wPowerPerpToMint`	`STRING`	Amount of wPowerPerp (wrapped power perpetual) tokens minted during this FlashDeposit transaction, denominated in wei (18 decimals). This represents the synthetic squeeth position created as part of the Crab strategy deposit.
`in_usdcToBorrow`	`STRING`	Amount of USDC borrowed as part of the flash deposit operation, denominated in USDC’s smallest unit (6 decimals, so 1 USDC = 1,000,000). This value is used to facilitate the leveraged position creation in the Squeeth Crab strategy.
`in_wethToLend`	`STRING`	Amount of WETH (Wrapped Ethereum) tokens being lent in the flash deposit transaction, specified in wei (10^-18 ETH). This value is typically slightly less than the deposited ETH amount due to protocol fees or reserve 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	0x56d5eaccd56884ac6f0942dbefe3652eedc30d56	false	147	16504961	151804520912146262	249167406990913980	2023-01-28T11:16:47.000Z	250000000000000000	195437203	0x6a5f8becf0ae8b9368afed5a445a9624f62ae2c38fbdc588a091af1f3e35e97f	2059807826592374465
0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	0x37cf126355f8857467f7a39f8eb06ac4e7556dbf	false	333	16504842	181870531179149920	298516569267867931	2023-01-28T10:52:59.000Z	300000000000000000	234144641	0x899b444c41f52fcf8ea1cf7e8932ca5979dbb803bbd82572b32aa63181be83f7	2467768030216510075
0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	0x0c55fe07ad75c135c797422a5857347b2e5a591e	false	141	16506259	605148652663149813	993283483510693206	2023-01-28T15:37:59.000Z	1000000000000000000	779097315	0x98cc7a50da84916307c7d790b9c959fff2044c616bf42138b9e2a05faf30b89c	8211151575181152013

Example Query

Query with partition filter

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

FlashZen_FlashWithdraw_event

Flash withdrawal events from the FlashZen contract in Squeeth V1 (Ethereum Power Perpetual) protocol, recording bullish strategy token redemptions for ETH. Tracks withdrawal amounts and ETH returned to users for analyzing liquidity flows and position unwinding in the power perpetual vault system.

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 (Squeeth bull strategy tokens) withdrawn in the flash withdrawal operation, denominated in wei (1e18 = 1 token). Values typically range from tens to hundreds of tokens based on the sample data.
`in_ethReturned`	`STRING`	Amount of ETH returned to the recipient in wei (1e18 units per ETH). Values typically range from fractional ETH to several ETH based on the bull token amount withdrawn.

Sample Data

in_to	address	removed	log_index	block_number	in_bullAmount	in_ethReturned	block_timestamp	transaction_hash
0xacd0442dc50f48949aa308d6f1494f6976643d1f	0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	false	214	16287421	896155592797222888	1943809791360669649	2022-12-29T02:25:59.000Z	0x423d561c35e5ed79cfc7633c3205efb255701690e0bb2b68536cba4b868fd977
0x6c4adea8f704410d4146368203856dc4c439acdb	0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	false	192	16801589	457285786628733700	1016400033977377491	2023-03-11T01:29:59.000Z	0xcda9e3e83c07cfa6ba65678268d9a6ad0a4af366993cc8ebc8b677886f876478
0x23e57777c60155baade25879bcaa03123745e350	0x11a56a3a7a6eb768a9125798b1eabe9ebd9ece02	false	379	16614154	40462064520725090	88855509847774300	2023-02-12T17:24:35.000Z	0x27d87116f1a53569b93b0e8163e23f0a9b91e070d1b8ddb366f8e54507fc7f2e

Example Query

Query with partition filter

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

ShortHelper_closeShort_function

Short position closure transactions from Squeeth v1 (Opyn’s ETH² perpetual) on Ethereum, capturing vault closures where users buy back wPowerPerp tokens via Uniswap swaps and withdraw collateral. Used for analyzing short squeeze dynamics and position unwinding behavior.

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`	`NUMERIC`	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 wPowerPerp (wrapped power perpetual) tokens being closed in this short position, denominated in the smallest unit (wei). This represents the quantity of squeeth derivative contracts being burned or returned when unwinding the position.
`in__withdrawAmount`	`STRING`	Amount of collateral token (ETH) to withdraw from the Squeeth vault, denominated in wei. Specified as a string to preserve precision for values up to 18 decimal places.
`in__exactOutputParams`	`STRUCT<tokenIn STRING, tokenOut STRING, fee STRING, recipient STRING, deadline STRING, amountOut STRING, amountInMaximum STRING, sqrtPriceLimitX96 STRING>`	Uniswap V3 swap parameters for buying back wPowerPerp tokens to close the short position. Structured record containing tokenIn (WETH), tokenOut (wPowerPerp), amountOut (exact wPowerPerp to buy), amountInMaximum (max ETH to spend), and other swap execution parameters.

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
768293	2688682135146292330	true	501943	0x17fd9e0e	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	226	14774731	0x7391f51dfe61e59c4bb6788df66c2bca55197f82	2022-05-14T16:46:24.000Z	0x768458ca76ad26aeaf8dc016643a9393af698868a2c8a29827a264a221bdcd5a	7000000000000000000	17339991512135497526	{“fee”:“3000”,“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1652633143”,“tokenOut”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountOut”:“17339991512135497526”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountInMaximum”:“2688682135146292330”,“sqrtPriceLimitX96”:“0”}
623860	3190907974298287060	true	405686	0x17fd9e0e	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	224	14772435	0x8bcbb2743467773c65eff63ba77d2cace3c8691b	2022-05-14T08:01:20.000Z	0x93760f9966f794b8b97491ac1d2d811d3bdce5046d19469816e7dfbf51e7db9f	7200000000000000000	20211994611393624699	{“fee”:“3000”,“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1652601639”,“tokenOut”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountOut”:“20211994611393624699”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountInMaximum”:“3190907974298287060”,“sqrtPriceLimitX96”:“0”}
741343	5902292742794550470	true	480044	0x17fd9e0e	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	148	14775778	0x8164ea45bb8fd3f3c446ea875c2d7cbf0c2ccde8	2022-05-14T20:46:33.000Z	0x495ffae7f23d434699297264594bd97c3f50dbde1a294ebe890342ea4b8c81f4	16000000000000000000	38078364177104130387	{“fee”:“3000”,“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“deadline”:“1652647584”,“tokenOut”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountOut”:“38078364177104130387”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountInMaximum”:“5902292742794550470”,“sqrtPriceLimitX96”:“0”}

Example Query

Query with partition filter

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

ShortHelper_openShort_function

Decoded function calls to openShort on Squeeth’s ShortHelper contract on Ethereum, recording short positions opened with vault IDs, power perpetual amounts minted, and Uniswap swap parameters for collateral management. Used for analyzing Squeeth (squared ETH perpetual) short position creation and associated hedging trades.

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`	`NUMERIC`	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 Squeeth (power perpetual) tokens to be minted and shorted when opening the position. Denominated in wei (18 decimals), typically ranging from 1-60 oSQTH tokens based on sample values.
`in__uniNftId`	`STRING`	Identifier for an existing Uniswap V3 liquidity position NFT to be used in opening the short. A value of ‘0’ indicates a new position will be created rather than modifying an existing one.
`in__exactInputParams`	`STRUCT<tokenIn STRING, tokenOut STRING, fee STRING, recipient STRING, deadline STRING, amountIn STRING, amountOutMinimum STRING, sqrtPriceLimitX96 STRING>`	Parameters for the exact input swap executed on Uniswap V3, including token addresses, amounts, fee tier, and slippage protection. This nested record specifies the token swap details required to open a Squeeth short position.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash	in__powerPerpAmount	in__exactInputParams
1074032	20000000000000000000	true	706051	0xe56cfbbe	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	14199485	0x83560d47550bb1d52e4da82560971fe03e52526a	2022-02-13T18:48:01.000Z	0x170d30fdf149eb299a2e7215eebeb68b99a647f589dbaad3cb28545d58a5357c	31054314405073884404	{“fee”:“3000”,“tokenIn”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountIn”:“36120774831627502712”,“deadline”:“1644864445”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountOutMinimum”:“9283892225032634310”,“sqrtPriceLimitX96”:“0”}
1019750	34000000000000000000	true	674363	0xe56cfbbe	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	14195206	0x9b6ab9b2acbdb25a56971daedd7b3e8c4c1364ad	2022-02-13T03:02:09.000Z	0x4472c295c4b80a4a3d2c07f2df0d305cd5e17ae4bc04f907458040601eba20ff	58209585521258879038	{“fee”:“3000”,“tokenIn”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountIn”:“67597968540677688993”,“deadline”:“1644807709”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountOutMinimum”:“17700214771134558000”,“sqrtPriceLimitX96”:“0”}
950762	6900000000000000000	true	587216	0xe56cfbbe	0x3b4095d5ff0e629972caaa50bd3004b09a1632c5	14196838	0x9427a246ddeabb4c79e91a8de070aa0aef2508a3	2022-02-13T08:50:51.000Z	0x1786bffd7645387ef59825984239e293acf85e7e2bf7ec239ad191793223571a	1180957853959334874	{“fee”:“3000”,“tokenIn”:“0xf1b99e3e573a1a9c5e6b2ce818b617f0e664e86b”,“amountIn”:“1372259216750157655”,“deadline”:“1644828582”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“recipient”:“0x3b4095d5ff0e629972caaa50bd3004b09a1632c5”,“amountOutMinimum”:“357380142227534947”,“sqrtPriceLimitX96”:“0”}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.squeeth_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