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.Columns
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_hype | STRING | Contract address of the hypervisor added to the factory. Hex-encoded, 0x-prefixed, 42-character string. |
in_index | STRING | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
Sample Data
Sample Data
| address | in_hype | removed | in_index | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x31ccdb5bd6322483bebd0787e1dabd1bf1f14946 | 0xf874d4957861e193aec9937223062679c14f9aca | false | 55 | 62 | 14348196 | 2022-03-08T20:03:49.000Z | 0x35a70297d0d5966bfc54b2e382ccc6dff9996454ef18c57cf6546f3c33b163d9 |
| 0x31ccdb5bd6322483bebd0787e1dabd1bf1f14946 | 0xca8759814695516c34168bbedd86290964d37ada | false | 89 | 230 | 17500334 | 2023-06-17T15:10:47.000Z | 0x87dd971979b31ed9e9d12240761a3efb30142f52480331ed00254f69759429d0 |
| 0x31ccdb5bd6322483bebd0787e1dabd1bf1f14946 | 0x336d7e0a0f87e2729c0080f86801e6f4becf146f | false | 50 | 52 | 14049152 | 2022-01-21T13:22:36.000Z | 0xa0d902c17c13e90abad61a69935f2fe6e08c6d5b12fe305f71b04bec00e056ca |
Example Query
Example Query
Query with partition filter
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.Columns
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_hype | STRING | Contract address of the hypervisor added to the factory. Hex-encoded, 0x-prefixed, 42-character string. |
in_index | STRING | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
Sample Data
Sample Data
| address | in_hype | removed | in_index | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x31ccdb5bd6322483bebd0787e1dabd1bf1f14946 | 0x33412fef1af035d6dba8b2f9b33b022e4c31dbb4 | false | 44 | 90 | 13895836 | 2021-12-28T20:15:46.000Z | 0x5bf57f1a6a5ac70a0d98e87a7ef9571843c3172a4a975f8d834010532c7f1a06 |
| 0x31ccdb5bd6322483bebd0787e1dabd1bf1f14946 | 0xe065ff6a26f286ddb0e823920caaecd1fcd57ba1 | false | 46 | 313 | 13896171 | 2021-12-28T21:33:27.000Z | 0xe6f0e1de182c19f94a095b0fd618d73f7f58aac66c3d147ef2d7f688600de9ca |
| 0x31ccdb5bd6322483bebd0787e1dabd1bf1f14946 | 0xa625ea468a4c70f13f9a756ffac3d0d250a5c276 | false | 45 | 613 | 13895934 | 2021-12-28T20:40:01.000Z | 0x6e98c3561b9498df976eaf9578331a215d49c68540b1bfe9a5c0c9baffed982a |
Example Query
Example Query
Query with partition filter
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.Columns
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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_shares | STRING | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system. |
in_amount0 | STRING | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
in_amount1 | STRING | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | in_shares | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x1e604083c3993e0b6fb2fbf1970e401b21c28372 | 0x6c8116abe5c5f2c39553c6f4217840e71462539c | false | 0xb0aac0747f9aec9a1121f62efbc27ffb7ac63c9c | 809217082461114742 | 138 | 2394000000000000000000 | 0 | 12694461 | 2021-06-24T03:19:39.000Z | 0x81133bfe9ae6164ddfea174c3ea34fb92d1b49c588b4513680cb83a4a82e30da |
| 0x1e604083c3993e0b6fb2fbf1970e401b21c28372 | 0x716bd8a7f8a44b010969a1825ae5658e7a18630d | false | 0xb0aac0747f9aec9a1121f62efbc27ffb7ac63c9c | 1949313694209884195 | 254 | 4638000000 | 0 | 12694417 | 2021-06-24T03:09:35.000Z | 0xf08628f8d9157c1976be174d62d162eaab65796b3143f4348681908e0a6026de |
| 0x5233b322139effc15fa5649c8c39cc56c3907fed | 0xc92ff322c8a18e38b46393dbcc8a7c5691586497 | false | 0xa3666ade53f583bf1808110600467530ce934267 | 74186651399793436977 | 84 | 10000000000000000 | 0 | 12698763 | 2021-06-24T19:40:34.000Z | 0x1ec83c77ea17eeec1a401cfa2e3515200b8d5868fbe191893535fc21d2ce9c61 |
Example Query
Example Query
Query with partition filter
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.Columns
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_tick | INT64 | Current 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_totalAmount0 | STRING | Total amount of token0 held in the hypervisor after the rebalance operation. Numeric string representation in smallest token denomination. |
in_totalAmount1 | STRING | Total amount of token1 held in the hypervisor after the rebalance operation. Numeric string representation in smallest token denomination. |
in_feeAmount0 | STRING | Amount of token0 fees collected during the rebalance operation. Numeric string representation in smallest token denomination. |
in_feeAmount1 | STRING | Amount of token1 fees collected during the rebalance operation. Numeric string representation in smallest token denomination. |
in_totalSupply | STRING | Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| address | in_tick | removed | log_index | block_number | in_feeAmount0 | in_feeAmount1 | in_totalSupply | block_timestamp | in_totalAmount0 | in_totalAmount1 | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xca8759814695516c34168bbedd86290964d37ada | -92969 | false | 377 | 17500516 | 0 | 0 | 114471855465708 | 2023-06-17T15:47:23.000Z | 618708507860692000 | 57703404500866 | 0x2f3bc04896e70ae577e569dd09822e9a281d4e8a4c765159c9c4c7a4c943bc0a |
| 0x9a98bffabc0abf291d6811c034e239e916bbcec0 | -199661 | false | 190 | 12887849 | 212336149874210170 | 1290233274 | 1390734382350 | 2021-07-24T08:06:47.000Z | 169726091156464858090 | 869802822640 | 0x34d57eca7ed58e9f9184fe0a32ac81a7eb6395bba41078724b2b16ef739fdf01 |
| 0x0624eb9691d99178d0d2bd76c72f1dbb4db05286 | -39471 | false | 206 | 12887849 | 12907726949134676383 | 201067295225201592 | 42933143878373504505 | 2021-07-24T08:06:47.000Z | 5548548069543489990 | 40348058693225867435 | 0x2630bcdcd8b7c68e7e70b5ddb73ff89c3c96e8053904583391cd0214948161d3 |
Example Query
Example Query
Query with partition filter
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.Columns
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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_shares | STRING | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system. |
in_amount0 | STRING | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
in_amount1 | STRING | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | in_shares | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xcb057f062696f89fcb98872b86b1fa43e05ca910 | 0x9a98bffabc0abf291d6811c034e239e916bbcec0 | false | 0x1b0dd3744746c47507ec0a9a830f2a621b266e14 | 1000000 | 341 | 223525299169849 | 416829 | 12590492 | 2021-06-07T23:53:15.000Z | 0xa2b514ce05b7ccc710bb9c102b9dd9343f4001d815722214742eb7b72352544f |
| 0xfeb7e72357116275a6960c5243f33d94b1c673fa | 0x09b8d86c6275e707155cdb5963cf611a432ccb21 | false | 0x28d2733ef77d0d895989f732488668b78fceb217 | 4437868667042340958 | 137 | 2398991605900475842002 | 4644717078605130876 | 14441772 | 2022-03-23T09:39:33.000Z | 0xa869e7cb3298ab79c61de8703c3e07aa9c897b27803024fa0fb059589614abde |
| 0x49a216d58dc65db1db92405ebdc48fdf945db991 | 0x407e99b20d61f245426031df872966953909e9d3 | false | 0x2aadf819ddaf0d9698cc3f61876e367a29828c69 | 741317489668449831550 | 82 | 249947534508680083324 | 1460170572521671671 | 14442047 | 2022-03-23T10:36:44.000Z | 0x9935f572db5d142ec6878b8f25ae4f1553340c9cea71074b389052a6e240b539 |
Example Query
Example Query
Query with partition filter
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.Columns
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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_shares | STRING | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system. |
in_amount0 | STRING | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
in_amount1 | STRING | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | in_shares | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x2fd3cbba9d869f7422a1da04f1bd9ae7f1efea62 | 0x65bc5c6a2630a87c2b494f36148e338dd76c054f | false | 0x547c7d66221a0ec7e5f7b1e940488dd55fbf0a6e | 266713054264655150 | 153 | 0 | 580000000000000000 | 13485707 | 2021-10-25T09:09:30.000Z | 0x4592a5ce23cd348dd15d65e3f4a8640f5f0fb7830d74836836558489403da61b |
| 0xabfa06a3ac398a7d27bc1b6b51469b86a58ee9cf | 0x65bc5c6a2630a87c2b494f36148e338dd76c054f | false | 0x66ab525022c5291c0c3d7a7199a38b827586f30c | 455373680392603356 | 252 | 0 | 1000000000000000000 | 13489224 | 2021-10-25T22:19:47.000Z | 0xf45e14509b6fe178bfbca4b38be0e2482a182093ce6406f02a8e3c3e1ef9f0c4 |
| 0xb6ae91ed4c9eefcd0dd9623d60d57667f5c7949a | 0x65bc5c6a2630a87c2b494f36148e338dd76c054f | false | 0x15693ce71d0838fa95f059bd0382d564b64f08b8 | 114196050046775704 | 358 | 424000000 | 125000000000000000 | 13486451 | 2021-10-25T11:59:05.000Z | 0x83cb5559fd7ca52e2e1843a33921bda3acbd76441b7afdf17a04958b6a53dc8e |
Example Query
Example Query
Query with partition filter
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.Columns
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_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_shares | STRING | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system. |
in_amount0 | STRING | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
in_amount1 | STRING | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| in_to | address | removed | in_sender | in_shares | log_index | in_amount0 | in_amount1 | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x09c46a907ba6167c50423ca130ad123dc6ec9862 | 0x35abccd8e577607275647edab08c537fa32cc65e | false | 0x09c46a907ba6167c50423ca130ad123dc6ec9862 | 198744312034816565 | 429 | 710030 | 99955776355151912 | 14484466 | 2022-03-30T00:52:18.000Z | 0x564c68b4a308702b1dcc1564cf17114e6abee6bab7e1353458b766237c0fdb48 |
| 0x09c46a907ba6167c50423ca130ad123dc6ec9862 | 0x35abccd8e577607275647edab08c537fa32cc65e | false | 0x09c46a907ba6167c50423ca130ad123dc6ec9862 | 198784899832041448 | 36 | 710274 | 99961477931775886 | 14484376 | 2022-03-30T00:31:50.000Z | 0x3bcf4edd6743c0a5d1b48a13b53327a6b3f605a024753d59d4c793b7ecf988b1 |
| 0x2a7cdb289c1481d9cbf2d6c08cc478c6380c4141 | 0xd930ab15c8078ebae4ac8da1098a81583603f7ce | false | 0x2f219e18d60ddc29544099bb88cbec8fd9e32392 | 157511323211268089 | 58 | 70622319604631871143 | 57943950802779303 | 14488946 | 2022-03-30T17:41:58.000Z | 0xd99b8caf906a880b7cbb63a2f6c89577651b9d704de4cec199784ed4ab13126f |
Example Query
Example Query
Query with partition filter
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.Columns
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_fee | INT64 | Fee 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_fees0 | STRING | Fee amount collected in token0 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token0. |
in_fees1 | STRING | Fee amount collected in token1 of the liquidity pair. String-encoded integer representing the fee in the smallest unit of token1. |
Sample Data
Sample Data
| in_fee | address | removed | in_fees0 | in_fees1 | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 6 | 0xa3ecb6e941e773c6568052a509a04cf455a752ae | false | 19363532899127 | 19696837828897 | 81 | 17813003 | 2023-07-31T12:30:47.000Z | 0x56c353be4e0789fcc4a98ac1c344dbaf5895ed13ed7c09f532660d9c0089c770 |
| 6 | 0xa3ecb6e941e773c6568052a509a04cf455a752ae | false | 791934306113 | 547009429381 | 88 | 17813003 | 2023-07-31T12:30:47.000Z | 0x56c353be4e0789fcc4a98ac1c344dbaf5895ed13ed7c09f532660d9c0089c770 |
| 5 | 0x75cd1842b529ed87817b0453c00b471f5a1b381a | false | 209522698 | 4612529526049545 | 152 | 17815797 | 2023-07-31T21:52:23.000Z | 0x7cb6287685e65a45b82438c22940a644dec6f4a06aee4fca6e06ac0173dafaea |
Example Query
Example Query
Query with partition filter