Skip to main content

Tables

HypervisorFactory_HypeAdded_event

Event log emitted when a new hypervisor vault is registered to a Gamma Strategies factory contract. Records the hypervisor address and its factory-assigned index number for tracking deployed vault instances.
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_hypeSTRINGContract address of the hypervisor added to the factory. Hex-encoded, 0x-prefixed, 42-character string.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_hyperemovedin_indexlog_indexblock_numberblock_timestamptransaction_hash
0xf5bfa20f4a77933fee0c7bb7f39e7642a070d5990x4f2b80d797bd1b93903cc84e5992586142c3ecd1false225531615842022-12-21T21:34:36.000Z0x5bf0c06b32598b8dd7880d71c55e9c01e56f1977a370045e0417950f0d635061
0xf5bfa20f4a77933fee0c7bb7f39e7642a070d5990x431f6e577a431d9ee87a535fde2db830e352e33cfalse170531615842022-12-21T21:34:36.000Z0x5bf0c06b32598b8dd7880d71c55e9c01e56f1977a370045e0417950f0d635061
0xf5bfa20f4a77933fee0c7bb7f39e7642a070d5990x2102bef0d9727ea50ba844e7658e38480961835cfalse236531615842022-12-21T21:34:36.000Z0x5bf0c06b32598b8dd7880d71c55e9c01e56f1977a370045e0417950f0d635061
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorFactory_HypeAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorFactoryUniswap_HypeAdded_event

Emitted when a new hypervisor contract is registered to a Gamma Strategies Uniswap V3 hypervisor factory. Contains the hypervisor contract address and its assigned factory index for tracking active liquidity management vaults.
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_hypeSTRINGContract address of the hypervisor added to the factory. Hex-encoded, 0x-prefixed, 42-character string.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_hyperemovedin_indexlog_indexblock_numberblock_timestamptransaction_hash
0xf5bfa20f4a77933fee0c7bb7f39e7642a070d5990xd3c480ec7a47596ff8d63396227d1f7dc728a7f0false71191079148152023-08-07T17:13:27.000Z0x6b471ab133ea74b620cabfae2d57ed0a8683795be918ab299c3ed6cc21766c8a
0xf5bfa20f4a77933fee0c7bb7f39e7642a070d5990x8323eac5003d98879e886e5cd6d9abd0c22fc14ffalse311725215022023-02-06T05:54:13.000Z0x017f6455f3e1ffe837453b5e48def9a7e6eb23be4790cba6ac9d2a3750135476
0xf5bfa20f4a77933fee0c7bb7f39e7642a070d5990x28a7a607f19c2e51da44663b0a520285be914947false300725215022023-02-06T05:54:13.000Z0x017f6455f3e1ffe837453b5e48def9a7e6eb23be4790cba6ac9d2a3750135476
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorFactoryUniswap_HypeAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorV1Uniswap_Deposit_event

Deposit events from Gamma Strategies HypervisorV1 contracts on Uniswap liquidity pools, recording token pair amounts deposited, LP shares minted, and recipient addresses. Used for tracking liquidity provision activity and share issuance in Gamma’s automated liquidity management vaults.
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_senderSTRINGAddress that initiated the transaction 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_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressremovedin_senderin_shareslog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0x7c930969fcf3e5a5c78bcf2e1cefda3f53e3c8fd0x1392698b2f2ca87e6329c1ca502c5d4ba938d1b8false0x7c930969fcf3e5a5c78bcf2e1cefda3f53e3c8fd1118810275995816313417741419701520739008463163231000000000000000001073939342023-07-26T15:50:45.000Z0xe8419e82703f7a9d430464b156bd7cb1c7bccb07b0abb92720aeca2c2d34afee
0xae2586e76c8a4d8dc1ff3d9ab70bec760ae143c20x1392698b2f2ca87e6329c1ca502c5d4ba938d1b8false0xae2586e76c8a4d8dc1ff3d9ab70bec760ae143c2611660159122832541115138804853585225091224476798076404188881491073881032023-07-26T12:36:23.000Z0xe94da34e61554204586356235d3d409c58f4f057f5c79f5ecd58982f075371d1
0xae2586e76c8a4d8dc1ff3d9ab70bec760ae143c20x1392698b2f2ca87e6329c1ca502c5d4ba938d1b8false0xae2586e76c8a4d8dc1ff3d9ab70bec760ae143c2353692899113388129179551325257601932078032000000000000000000001073937202023-07-26T15:43:37.000Z0x613b34f76d05938b743d9b83a9912246dd75d702cdf68a025812f3727a99b964
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorV1Uniswap_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorV1Uniswap_Rebalance_event

Rebalance events emitted by Gamma Strategies HypervisorV1 liquidity management vaults on Uniswap V3, recording adjustments to concentrated liquidity positions including total token amounts, accumulated fees, pool tick position, and vault token supply. Used for tracking automated liquidity strategy executions and position management analytics.
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_tickINT64Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.
in_totalAmount0STRINGTotal amount of token0 held in the hypervisor after the rebalance operation. Numeric string representation in smallest token denomination.
in_totalAmount1STRINGTotal amount of token1 held in the hypervisor after the rebalance operation. Numeric string representation in smallest token denomination.
in_feeAmount0STRINGAmount of token0 fees collected during the rebalance operation. Numeric string representation in smallest token denomination.
in_feeAmount1STRINGAmount of token1 fees collected during the rebalance operation. Numeric string representation in smallest token denomination.
in_totalSupplySTRINGTotal supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
addressin_tickremovedlog_indexblock_numberin_feeAmount0in_feeAmount1in_totalSupplyblock_timestampin_totalAmount0in_totalAmount1transaction_hash
0x34d4112d180e9faf06f77c8c550ba20c9f61ae31-259347false171110550840014073369172023-10-19T09:49:05.000Z2700283965716075028274270221880xd66a3c6e76303325d855101be8c5cddd858193cbc214c7098588a4fc516ba34a
0x34d4112d180e9faf06f77c8c550ba20c9f61ae31-259318false111110531410014073369172023-10-19T08:44:19.000Z2605769509781676440054786907670x22027c8d5fa0cf87dc4c59c3ec14bc17029ae1471021e095788b2848aa5c4658
0x34d4112d180e9faf06f77c8c550ba20c9f61ae31-259377false211110641920014073369172023-10-19T14:52:41.000Z2796924766796660724433744622330xf9aa1e0502ef565dd496d2b2728a50d5360b88f45241e9427bfd0545d6f01840
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorV1Uniswap_Rebalance_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorV1Uniswap_Withdraw_event

Withdrawal events from Gamma Strategies Hypervisor V1 vaults built on Uniswap V3 liquidity positions. Records redemption of vault shares for underlying token0 and token1 amounts, tracking sender, recipient, and burned share quantities.
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_senderSTRINGAddress that initiated the transaction 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_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressremovedin_senderin_shareslog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0x01c020c8f90aebc4d8fcac2ea1acec596da4e01b0x1392698b2f2ca87e6329c1ca502c5d4ba938d1b8false0x01c020c8f90aebc4d8fcac2ea1acec596da4e01b20882197580759147176437164812550337300638699741216319566017891139999502023-12-26T13:51:17.000Z0xb5523d33582aee021459fe23ca0150e9c077fabdb05a4668ed3974c90fbaf7d1
0x4754541109a3d8d7747d99dfc6125b32393559130x2102bef0d9727ea50ba844e7658e38480961835cfalse0x4754541109a3d8d7747d99dfc6125b323935591313884508583637741436284769706934539942091139900012023-12-26T08:19:39.000Z0x7ddc90c0d26d6e1287f5376b2825b0140d29bb5844080a905bc0902e295e99bf
0xcb36db29a298e9bef6fe93d6ae32432b1bdc9e500x46b4fa8e2e98a3c53fe526a87591d596e1b4d98cfalse0xcb36db29a298e9bef6fe93d6ae32432b1bdc9e504801887154049514451016258263432234007930171601238191139920402023-12-26T09:27:37.000Z0xc6535b69b1f8710c9e16f8511611e0c2be57ee795d2a5684d39b756fc743d754
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorV1Uniswap_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorV2Uniswap_Deposit_event

Deposit events from Gamma Strategies HypervisorV2 contracts on Uniswap, recording liquidity additions with token amounts deposited, shares minted, and recipient addresses. Used for tracking LP position creation and vault inflows across Gamma’s active liquidity management vaults.
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_senderSTRINGAddress that initiated the transaction 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_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressremovedin_senderin_shareslog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0x5525e6fbfb80fa70932c130ee1550d364fee264f0x2102bef0d9727ea50ba844e7658e38480961835cfalse0x5525e6fbfb80fa70932c130ee1550d364fee264f1023016441426048848262480792817000000701149742023-01-24T11:28:55.000Z0x0f95aefe80b3bbed468eaa42e6e642522d59ec4d745fcba7f50031db5d922d46
0x7a3d751619e2da4dcd6ebebcac78aa209f84a2270x2102bef0d9727ea50ba844e7658e38480961835cfalse0x7a3d751619e2da4dcd6ebebcac78aa209f84a22723501525651573371972627693684298130159786700230742023-01-24T00:10:17.000Z0x29cca70639e0fb0a390a131c40c8060e0624ea8bc32d7bfcad82fb883bd6cb6a
0xe5656d9cf64ff41ceb7e26e819d70df8b66d15950x2102bef0d9727ea50ba844e7658e38480961835cfalse0xe5656d9cf64ff41ceb7e26e819d70df8b66d159524755051700155487021113841324488021873328244700981892023-01-24T09:26:22.000Z0x7cdc4c43f2c2f7fd383ff8a7330c7d5c9a68ab6de45e6527e65eda70d3229e9c
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorV2Uniswap_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorV2Uniswap_Withdraw_event

Withdrawal events from Gamma Strategies HypervisorV2 Uniswap liquidity management vaults. Records liquidity provider withdrawals including burned shares and returned token amounts for both assets in the pair.
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_senderSTRINGAddress that initiated the transaction 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_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressremovedin_senderin_shareslog_indexin_amount0in_amount1block_numberblock_timestamptransaction_hash
0x75c7a39f2ddaceeab4664b7baad9e8570c89ce3e0x431f6e577a431d9ee87a535fde2db830e352e33cfalse0x75c7a39f2ddaceeab4664b7baad9e8570c89ce3e148106208501025759087638325141480626271057325862023-06-18T04:52:29.000Z0xd590d0b5efd50bd8c14f0e5a0b7e8a136a8c3f2850540017e758f919dfb083e0
0x2f062d9aa98209d2c79a744b0d4ef203d363b7d60x431f6e577a431d9ee87a535fde2db830e352e33cfalse0x2f062d9aa98209d2c79a744b0d4ef203d363b7d6839338776605831788169634644798361266141057628222023-06-18T21:40:21.000Z0x09d8deea5deb06be42b183f8fc7dd5d732ef8d2be8933a947b1e9f074d265ad2
0x6a4d00bc2a921e9bf5397cecba78c6802be3702f0x6f670062bca8c759a876841fcf1c4b0147879097false0x6a4d00bc2a921e9bf5397cecba78c6802be3702f146019379635844828852828012346117459820332220903828271062871057657972023-06-18T23:19:31.000Z0x47d2d21b26503478e130570679baf2b1b354003c85300df08f1949b7b47b8b23
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorV2Uniswap_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

HypervisorV2Uniswap_ZeroBurn_event

Fee collection events emitted by Gamma Strategies Uniswap V2 Hypervisor contracts during zero-burn operations. Records fee amounts collected in both tokens of the liquidity pair along with the fee tier percentage.
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_feeINT64Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
in_fees0STRINGFee amount collected in token0 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token0.
in_fees1STRINGFee amount collected in token1 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token1.
in_feeaddressremovedin_fees0in_fees1log_indexblock_numberblock_timestamptransaction_hash
50x63923f4c88bee08fb9bd5cf97badb30435aa4ffdfalse00161115483032023-10-30T19:49:43.000Z0x9d030d9b079d632ad1b08e4868ad02faec11dc9ff4e209afde2276e097930d4b
50x63923f4c88bee08fb9bd5cf97badb30435aa4ffdfalse181809417390588201417949405821495658151115291772023-10-30T09:12:11.000Z0xd8b52e5368a2ee4b3585726af08261296f50928bd83ff2478be6329fd99b3fb2
50x63923f4c88bee08fb9bd5cf97badb30435aa4ffdfalse4348730324814485420111115474142023-10-30T19:20:05.000Z0xa8a51ec701a02458a0239292c6fc72caba2e2b921994b3d90d7bff215b075e3f
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_optimism.HypervisorV2Uniswap_ZeroBurn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100