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
0x31ccdb5bd6322483bebd0787e1dabd1bf1f149460xf874d4957861e193aec9937223062679c14f9acafalse5562143481962022-03-08T20:03:49.000Z0x35a70297d0d5966bfc54b2e382ccc6dff9996454ef18c57cf6546f3c33b163d9
0x31ccdb5bd6322483bebd0787e1dabd1bf1f149460xca8759814695516c34168bbedd86290964d37adafalse89230175003342023-06-17T15:10:47.000Z0x87dd971979b31ed9e9d12240761a3efb30142f52480331ed00254f69759429d0
0x31ccdb5bd6322483bebd0787e1dabd1bf1f149460x336d7e0a0f87e2729c0080f86801e6f4becf146ffalse5052140491522022-01-21T13:22:36.000Z0xa0d902c17c13e90abad61a69935f2fe6e08c6d5b12fe305f71b04bec00e056ca
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
0x31ccdb5bd6322483bebd0787e1dabd1bf1f149460x33412fef1af035d6dba8b2f9b33b022e4c31dbb4false4490138958362021-12-28T20:15:46.000Z0x5bf57f1a6a5ac70a0d98e87a7ef9571843c3172a4a975f8d834010532c7f1a06
0x31ccdb5bd6322483bebd0787e1dabd1bf1f149460xe065ff6a26f286ddb0e823920caaecd1fcd57ba1false46313138961712021-12-28T21:33:27.000Z0xe6f0e1de182c19f94a095b0fd618d73f7f58aac66c3d147ef2d7f688600de9ca
0x31ccdb5bd6322483bebd0787e1dabd1bf1f149460xa625ea468a4c70f13f9a756ffac3d0d250a5c276false45613138959342021-12-28T20:40:01.000Z0x6e98c3561b9498df976eaf9578331a215d49c68540b1bfe9a5c0c9baffed982a
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
0x1e604083c3993e0b6fb2fbf1970e401b21c283720x6c8116abe5c5f2c39553c6f4217840e71462539cfalse0xb0aac0747f9aec9a1121f62efbc27ffb7ac63c9c80921708246111474213823940000000000000000000126944612021-06-24T03:19:39.000Z0x81133bfe9ae6164ddfea174c3ea34fb92d1b49c588b4513680cb83a4a82e30da
0x1e604083c3993e0b6fb2fbf1970e401b21c283720x716bd8a7f8a44b010969a1825ae5658e7a18630dfalse0xb0aac0747f9aec9a1121f62efbc27ffb7ac63c9c194931369420988419525446380000000126944172021-06-24T03:09:35.000Z0xf08628f8d9157c1976be174d62d162eaab65796b3143f4348681908e0a6026de
0x5233b322139effc15fa5649c8c39cc56c3907fed0xc92ff322c8a18e38b46393dbcc8a7c5691586497false0xa3666ade53f583bf1808110600467530ce9342677418665139979343697784100000000000000000126987632021-06-24T19:40:34.000Z0x1ec83c77ea17eeec1a401cfa2e3515200b8d5868fbe191893535fc21d2ce9c61
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
0xca8759814695516c34168bbedd86290964d37ada-92969false37717500516001144718554657082023-06-17T15:47:23.000Z618708507860692000577034045008660x2f3bc04896e70ae577e569dd09822e9a281d4e8a4c765159c9c4c7a4c943bc0a
0x9a98bffabc0abf291d6811c034e239e916bbcec0-199661false19012887849212336149874210170129023327413907343823502021-07-24T08:06:47.000Z1697260911564648580908698028226400x34d57eca7ed58e9f9184fe0a32ac81a7eb6395bba41078724b2b16ef739fdf01
0x0624eb9691d99178d0d2bd76c72f1dbb4db05286-39471false2061288784912907726949134676383201067295225201592429331438783735045052021-07-24T08:06:47.000Z5548548069543489990403480586932258674350x2630bcdcd8b7c68e7e70b5ddb73ff89c3c96e8053904583391cd0214948161d3
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
0xcb057f062696f89fcb98872b86b1fa43e05ca9100x9a98bffabc0abf291d6811c034e239e916bbcec0false0x1b0dd3744746c47507ec0a9a830f2a621b266e141000000341223525299169849416829125904922021-06-07T23:53:15.000Z0xa2b514ce05b7ccc710bb9c102b9dd9343f4001d815722214742eb7b72352544f
0xfeb7e72357116275a6960c5243f33d94b1c673fa0x09b8d86c6275e707155cdb5963cf611a432ccb21false0x28d2733ef77d0d895989f732488668b78fceb217443786866704234095813723989916059004758420024644717078605130876144417722022-03-23T09:39:33.000Z0xa869e7cb3298ab79c61de8703c3e07aa9c897b27803024fa0fb059589614abde
0x49a216d58dc65db1db92405ebdc48fdf945db9910x407e99b20d61f245426031df872966953909e9d3false0x2aadf819ddaf0d9698cc3f61876e367a29828c69741317489668449831550822499475345086800833241460170572521671671144420472022-03-23T10:36:44.000Z0x9935f572db5d142ec6878b8f25ae4f1553340c9cea71074b389052a6e240b539
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
0x2fd3cbba9d869f7422a1da04f1bd9ae7f1efea620x65bc5c6a2630a87c2b494f36148e338dd76c054ffalse0x547c7d66221a0ec7e5f7b1e940488dd55fbf0a6e2667130542646551501530580000000000000000134857072021-10-25T09:09:30.000Z0x4592a5ce23cd348dd15d65e3f4a8640f5f0fb7830d74836836558489403da61b
0xabfa06a3ac398a7d27bc1b6b51469b86a58ee9cf0x65bc5c6a2630a87c2b494f36148e338dd76c054ffalse0x66ab525022c5291c0c3d7a7199a38b827586f30c45537368039260335625201000000000000000000134892242021-10-25T22:19:47.000Z0xf45e14509b6fe178bfbca4b38be0e2482a182093ce6406f02a8e3c3e1ef9f0c4
0xb6ae91ed4c9eefcd0dd9623d60d57667f5c7949a0x65bc5c6a2630a87c2b494f36148e338dd76c054ffalse0x15693ce71d0838fa95f059bd0382d564b64f08b8114196050046775704358424000000125000000000000000134864512021-10-25T11:59:05.000Z0x83cb5559fd7ca52e2e1843a33921bda3acbd76441b7afdf17a04958b6a53dc8e
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
0x09c46a907ba6167c50423ca130ad123dc6ec98620x35abccd8e577607275647edab08c537fa32cc65efalse0x09c46a907ba6167c50423ca130ad123dc6ec986219874431203481656542971003099955776355151912144844662022-03-30T00:52:18.000Z0x564c68b4a308702b1dcc1564cf17114e6abee6bab7e1353458b766237c0fdb48
0x09c46a907ba6167c50423ca130ad123dc6ec98620x35abccd8e577607275647edab08c537fa32cc65efalse0x09c46a907ba6167c50423ca130ad123dc6ec98621987848998320414483671027499961477931775886144843762022-03-30T00:31:50.000Z0x3bcf4edd6743c0a5d1b48a13b53327a6b3f605a024753d59d4c793b7ecf988b1
0x2a7cdb289c1481d9cbf2d6c08cc478c6380c41410xd930ab15c8078ebae4ac8da1098a81583603f7cefalse0x2f219e18d60ddc29544099bb88cbec8fd9e32392157511323211268089587062231960463187114357943950802779303144889462022-03-30T17:41:58.000Z0xd99b8caf906a880b7cbb63a2f6c89577651b9d704de4cec199784ed4ab13126f
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.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
60xa3ecb6e941e773c6568052a509a04cf455a752aefalse193635328991271969683782889781178130032023-07-31T12:30:47.000Z0x56c353be4e0789fcc4a98ac1c344dbaf5895ed13ed7c09f532660d9c0089c770
60xa3ecb6e941e773c6568052a509a04cf455a752aefalse79193430611354700942938188178130032023-07-31T12:30:47.000Z0x56c353be4e0789fcc4a98ac1c344dbaf5895ed13ed7c09f532660d9c0089c770
50x75cd1842b529ed87817b0453c00b471f5a1b381afalse2095226984612529526049545152178157972023-07-31T21:52:23.000Z0x7cb6287685e65a45b82438c22940a644dec6f4a06aee4fca6e06ac0173dafaea
Query with partition filter
SELECT *
FROM `tt-contracts.gammastrategies_v1_ethereum.HypervisorV2Uniswap_ZeroBurn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100