gammastrategies_v1_polygon

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

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

address	in_hype	removed	in_index	log_index	block_number	block_timestamp	transaction_hash
0xaec731f69fa39ad84c7749e913e3bc227427adfd	0xc12e821ff75b464702d2ad55a0f4504ca6441be5	false	117	149	47451176	2023-09-12T11:50:36.000Z	0x768322c681603026b796ac48c14260b0dc1e5d5af70f2334daa8410601ab936b
0x0ac4c7b794f3d7e7bf1093a4f179ba792cf15055	0x4a39cbb8198376ab08c24e596ff5e668c3ca269e	false	73	0	42790470	2023-05-16T21:49:44.000Z	0x0822a0401654435a61c9305fd383fb07be7e229debac5c815790de3224b5d841
0xaec731f69fa39ad84c7749e913e3bc227427adfd	0x27ffa4221a52b02ecc67c5b199007010b90e8660	false	110	108	42617282	2023-05-12T14:29:01.000Z	0x6c0d4e225269152fb164d0e80e20bf62d1c16447ef61056c4658776715879f95

Example Query

Query with partition filter

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

HypervisorFactoryQuickSwap_HypeAdded_event

Hypervisor vault deployment events from Gamma Strategies’ QuickSwap factory contract on Polygon, tracking new automated liquidity management positions. Used to identify when new Gamma vaults are created for QuickSwap liquidity pools.

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

address	in_hype	removed	in_index	log_index	block_number	block_timestamp	transaction_hash
0xaec731f69fa39ad84c7749e913e3bc227427adfd	0xee2a89071654333703b3d6c9be9ab8f085f977de	false	70	174	39443221	2023-02-18T20:22:07.000Z	0xb729fbe17d20a2939fe4a275c924bbad45fb2b57c0c31bb200ca0ad22b0c769e
0xaec731f69fa39ad84c7749e913e3bc227427adfd	0x2e9225276a8756f6983c6054d7a171dadb24a7b8	false	69	173	39443221	2023-02-18T20:22:07.000Z	0xb729fbe17d20a2939fe4a275c924bbad45fb2b57c0c31bb200ca0ad22b0c769e
0xaec731f69fa39ad84c7749e913e3bc227427adfd	0xfe4bb996926aca85c9747bbec886ec2a3f510c66	false	61	133	39439636	2023-02-18T18:04:27.000Z	0xddf12328fb0f7f5877717630dbc50170975942b6a9acfd10f9f10dfb3e7b2728

Example Query

Query with partition filter

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

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

address	in_hype	removed	in_index	log_index	block_number	block_timestamp	transaction_hash
0x0ac4c7b794f3d7e7bf1093a4f179ba792cf15055	0xa29193af0816d43cf44a3745755bf5f5e2f4f170	false	29	160	31701373	2022-08-09T16:25:13.000Z	0xb931881f24ecc2a679e8e5347ee3ba92cc6e463896d5f52e9bfd927c2740cfd0
0x0ac4c7b794f3d7e7bf1093a4f179ba792cf15055	0xbc89a4413c38dcd066027c1225e2cc390c470b48	false	72	198	42699663	2023-05-14T15:42:06.000Z	0x6b2f5c8b2684797c000454585d0bfdfd5bf9a672275c739d6419e6b90c0fd83b
0x0ac4c7b794f3d7e7bf1093a4f179ba792cf15055	0x91d6569946a11ca0d5564f31a594210bf06c1f0a	false	22	1	27533362	2022-04-24T21:16:57.000Z	0x6ae8d32b31d7d2ebf26762ae7e2aad3ae7a7b1af26f1d50031cb384b4dbf8087

Example Query

Query with partition filter

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

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

in_to	address	removed	in_sender	in_shares	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x14bcd2bc6e516fa296636a55d1cc24fa89cbc5b1	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x14bcd2bc6e516fa296636a55d1cc24fa89cbc5b1	40075405927706933	701	29985163562119050190	3581153049337939	57997905	2024-06-10T17:07:52.000Z	0x9f966bde6dd8ea971581b7d7b60820366c97cd4e1ec7e2f7a2a099c3073eb7a0
0x14bcd2bc6e516fa296636a55d1cc24fa89cbc5b1	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x14bcd2bc6e516fa296636a55d1cc24fa89cbc5b1	162769912910958717	2293	129270282018525630190	13215223637419181	57988403	2024-06-10T11:27:52.000Z	0x4402810f21019afb7f6e74a255d6ac8aece7f2919f1b00ddc52b4e51f7561f8e
0x42181f98a4c0bc89b6b2d9df86aa8a9debc7ffcc	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x42181f98a4c0bc89b6b2d9df86aa8a9debc7ffcc	232428156937840467	417	177124933699969194978	20195139037307987	57994051	2024-06-10T14:50:05.000Z	0x0e8776ec3a8ac0ce1176b1d1acfb41cfd6c6343949f4fb649c55970433cc4c63

Example Query

Query with partition filter

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

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

address	in_tick	removed	log_index	block_number	in_totalSupply	block_timestamp	in_totalAmount0	in_totalAmount1	transaction_hash
0x4b9e26a02121a1c541403a611b542965bd4b68ce	260047	false	111	52026322	1233875043780004325468	2024-01-07T00:51:24.000Z	1835720022	978322104433213952288	0x2499471ad9c2dafd202f3f2f1c6582a2ddf14df239e89ba0ac051c11d3aa032a
0x04d521e2c414e6d898c6f2599fdd863edf49e247	-278516	false	170	52061242	1412898313430	2024-01-07T22:38:28.000Z	660444665138211268708692	119958383022	0x32f4527441a98333b161e8ac8568cc60f706d1f6032ebf96824fcd16405abd45
0x04d521e2c414e6d898c6f2599fdd863edf49e247	-278429	false	84	52060698	1412898313430	2024-01-07T22:18:03.000Z	643644424289435188175332	133473663225	0xeaa87ad9805017e4102dd47a93386db896ff03f73983ddbbf04d09cb69986338

Example Query

Query with partition filter

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

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

in_to	address	removed	in_sender	in_shares	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x0de58892df65a653b049d30b8c2a587d51af6ac9	0x04d521e2c414e6d898c6f2599fdd863edf49e247	false	0x0de58892df65a653b049d30b8c2a587d51af6ac9	67431791611	654	959808574796998373498	970085380	78193977	2025-10-26T15:33:01.000Z	0xcee3154ab0a453dddcc07f0806516a6af5823a0b3222590e759cff397726014e
0x19b1f090644808d4a41a9b20d2cd964cc81335be	0x795f8c9b0a0da9cd8dea65fc10f9b57abc532e58	false	0x19b1f090644808d4a41a9b20d2cd964cc81335be	75542	297	1385218	1010252	78201630	2025-10-26T19:48:07.000Z	0x223c434cad9426f3025320251da6554ddca9cb72bc8121fd81cb140ef093cc49
0x3894af06d4f91a6874791f50e9ca246ea4c6232c	0x9e31214db6931727b7d63a0d2b6236db455c0965	false	0x3894af06d4f91a6874791f50e9ca246ea4c6232c	4080670160902273	373	3434	2245916456806287	78202163	2025-10-26T20:05:53.000Z	0xf807defeb4f8f8f1f4ddf957dbc16c32c814e4656a6e241e37297369d2fa767c

Example Query

Query with partition filter

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

HypervisorV2QuickSwap_Deposit_event

Deposit events from Gamma Strategies Hypervisor V2 vaults on QuickSwap (Polygon), recording liquidity provision with token amounts, LP shares minted, and recipient addresses. Used for tracking liquidity provider activity and vault deposit flows.

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

in_to	address	removed	in_sender	in_shares	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x56c1d2227ad3f391e5b77e41d00ac64916913288	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x56c1d2227ad3f391e5b77e41d00ac64916913288	10642995386498695891	337	4259257801491257788233	1239210651370036345	62340648	2024-09-27T13:26:47.000Z	0x70f730a4970e0aa808283875775a1b46d9010c4e9c3a3968bbb907de0a89a43c
0x90a10587c4a6aec47b420053caa5d43a5fb7cae6	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x90a10587c4a6aec47b420053caa5d43a5fb7cae6	844050885467664329	184	510000000000000000000	70511447847052782	62349096	2024-09-27T18:26:41.000Z	0x54596e7259093734eb69eea2cb5a04c1009593ad2bdc566b7cce7bf4fe7d6f27
0xe90053b8136f18206fcf4f48e0c3b6aed9b1ad71	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0xe90053b8136f18206fcf4f48e0c3b6aed9b1ad71	642753378075275612	264	293559643481549652997	68929625553118595	62342333	2024-09-27T14:26:27.000Z	0xcff1fe9e6d962c0cc8bb11fdc233776bfa77822fa5e8e5f29f2daca7778d0a22

Example Query

Query with partition filter

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

HypervisorV2QuickSwap_Withdraw_event

Withdrawal events from Gamma Strategies Hypervisor V2 vaults on QuickSwap (Polygon), recording liquidity removals with LP share burns and underlying token amounts returned. Used for tracking vault outflows, liquidity provider exit behavior, and calculating historical vault composition.

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

in_to	address	removed	in_sender	in_shares	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xb87a4c30ac3a89928234bb83d3c8a817b4916ae0	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0xb87a4c30ac3a89928234bb83d3c8a817b4916ae0	177088475830398752	594	197684280706170119312	40434371581604865	41011119	2023-04-01T08:25:52.000Z	0xa8b191d2c071bc62d4abac18fe47186802320660e24794547006da2061945c3c
0x489a368b61ec309ce79552f326d12c8190db6f19	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x489a368b61ec309ce79552f326d12c8190db6f19	816785852379145087	432	901576863132527348356	192706648560128051	41009873	2023-04-01T07:38:36.000Z	0x9f21a930a5d2a1d28d8af2fa414d06155757da84b827934aae50926469e661de
0x6a077cdc97581b85e2a2d9121ab75996bc490351	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x6a077cdc97581b85e2a2d9121ab75996bc490351	108407794218539931	304	120220603584228498609	25243031612074136	41031662	2023-04-01T20:59:59.000Z	0x41dd3f30fb98072371c1ddee4ca65c3535f43380fc148604a8ff4680fe4042af

Example Query

Query with partition filter

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

HypervisorV2QuickSwap_ZeroBurn_event

ZeroBurn events from Gamma Strategies Hypervisor V2 vaults on QuickSwap (Polygon), tracking fee collection operations where liquidity positions are adjusted without burning LP tokens. Used for analyzing vault fee accrual and rebalancing mechanics across dual-token strategies.

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

in_fee	address	removed	in_fees1	log_index	block_number	block_timestamp	transaction_hash
7	0xac0f71f2492daf020f459bd163052b9dae28f159	false	0	191	37913104	2023-01-10T19:02:52.000Z	0xa0f771a6eead4948aee0630bdecb5b9ebce067a57d76c8faeb65b52ec373dc3d
7	0xac0f71f2492daf020f459bd163052b9dae28f159	false	10	187	37913104	2023-01-10T19:02:52.000Z	0xa0f771a6eead4948aee0630bdecb5b9ebce067a57d76c8faeb65b52ec373dc3d
10	0x15f2e223000d392a8449a53a4b930f3c54926987	false	0	113	37915477	2023-01-10T20:25:24.000Z	0x75e1191ab148abd405d447abbd9885d56e0810c05ad1570f43728ca8b503feaf

Example Query

Query with partition filter

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

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

in_to	address	removed	in_sender	in_shares	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x5a1ef22313e89b003ff76883d7a5263d27ed841a	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x5a1ef22313e89b003ff76883d7a5263d27ed841a	8409603109398185	272	5952017754254989682	2444402338443406	45310652	2023-07-20T16:41:48.000Z	0x363927728e3378d7c018dbdd9194bcbf538dee006895e1b365d623a21dccd193
0x9969430213e7b8b0c88e6641a51d5e19d9078f3d	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x9969430213e7b8b0c88e6641a51d5e19d9078f3d	71971414624953526	108	52704124018370904992	20219898053948151	45318714	2023-07-20T21:33:35.000Z	0x6426414757e4090b12ae3b3798160b9f2ea776869529f7f4d87aff76e70fe752
0xc9dd2a3cea22266058db55c162199e78d7f00e39	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0xc9dd2a3cea22266058db55c162199e78d7f00e39	3053832976383714662	227	1707563394118849828374	1072659516859986477	45301139	2023-07-20T10:59:56.000Z	0xb87442ffc70d1a5a7ac8cac5902eb281db2b422864d8b7b2b3c003fb46dc8bf1

Example Query

Query with partition filter

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

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

in_to	address	removed	in_sender	in_shares	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x50dbca1223169a2aebfd757d994fd7246c8865c1	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x50dbca1223169a2aebfd757d994fd7246c8865c1	12319437434899401001	493	7295327485956403503702	3048839773918045545	51626814	2023-12-27T17:31:43.000Z	0x1e4e5fb7b164af23b4174298eb66b062533d441b39d3de45a7b678c5bfefdd96
0xed55e0638784cad20b05d4ec21258eed5b040556	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0xed55e0638784cad20b05d4ec21258eed5b040556	4592319127065860449	259	108658437357280363864	2323728870454532453	51600767	2023-12-27T01:59:23.000Z	0x38d91031b9c3bb38df5bee6ddd5ba1b8d61ce511367bf0aa474ef2414c50e965
0x42ecabfbdb1480682e821c3badabd9ffd3f8a940	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	0x42ecabfbdb1480682e821c3badabd9ffd3f8a940	66376442803011393278	352	1035951494494507414528	33834985276345365881	51599203	2023-12-27T01:03:47.000Z	0x3e393cb2dbd63e9d34e433dcaf93db75aeecdbf4bebda2b6f5a70f9d9bc79ce0

Example Query

Query with partition filter

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

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

in_fee	address	removed	in_fees0	in_fees1	log_index	block_number	block_timestamp	transaction_hash
5	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	30567408173803694955	5556226827764548	417	54709294	2024-03-16T01:46:00.000Z	0xceb3821a55852436d72088738f386c4746ba3832e0bbdf05b1da51935d794125
5	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	233578651229209544171	42457507714540961	424	54709294	2024-03-16T01:46:00.000Z	0xceb3821a55852436d72088738f386c4746ba3832e0bbdf05b1da51935d794125
5	0x02203f2351e7ac6ab5051205172d3f772db7d814	false	5420482449061311	44321050223474	162	54709857	2024-03-16T02:05:58.000Z	0x458f0f0344ac210bd51b0c0bfb1a44ed5ef9073ed5345bf4ef0930d622b01f10

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

HypervisorFactory_HypeAdded_event

HypervisorFactoryQuickSwap_HypeAdded_event

HypervisorFactoryUniswap_HypeAdded_event

HypervisorV1Uniswap_Deposit_event

HypervisorV1Uniswap_Rebalance_event

HypervisorV1Uniswap_Withdraw_event

HypervisorV2QuickSwap_Deposit_event

HypervisorV2QuickSwap_Withdraw_event

HypervisorV2QuickSwap_ZeroBurn_event

HypervisorV2Uniswap_Deposit_event

HypervisorV2Uniswap_Withdraw_event

HypervisorV2Uniswap_ZeroBurn_event

​Tables

​HypervisorFactory_HypeAdded_event

​HypervisorFactoryQuickSwap_HypeAdded_event

​HypervisorFactoryUniswap_HypeAdded_event

​HypervisorV1Uniswap_Deposit_event

​HypervisorV1Uniswap_Rebalance_event

​HypervisorV1Uniswap_Withdraw_event

​HypervisorV2QuickSwap_Deposit_event

​HypervisorV2QuickSwap_Withdraw_event

​HypervisorV2QuickSwap_ZeroBurn_event

​HypervisorV2Uniswap_Deposit_event

​HypervisorV2Uniswap_Withdraw_event

​HypervisorV2Uniswap_ZeroBurn_event

Tables

HypervisorFactory_HypeAdded_event

HypervisorFactoryQuickSwap_HypeAdded_event

HypervisorFactoryUniswap_HypeAdded_event

HypervisorV1Uniswap_Deposit_event

HypervisorV1Uniswap_Rebalance_event

HypervisorV1Uniswap_Withdraw_event

HypervisorV2QuickSwap_Deposit_event

HypervisorV2QuickSwap_Withdraw_event

HypervisorV2QuickSwap_ZeroBurn_event

HypervisorV2Uniswap_Deposit_event

HypervisorV2Uniswap_Withdraw_event

HypervisorV2Uniswap_ZeroBurn_event