gammastrategies_v1_arbitrum

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
0x66cd859053c458688044d816117d5bdf42a56813	0x904135ac233e53fc1c1a5b061d34496b362489c3	false	58	0	142023004	2023-10-19T14:06:36.000Z	0xf32abecdb0ae7cbd6d604daf6363790fad9aa693fa0394ededf4cad92f4a8280
0x66cd859053c458688044d816117d5bdf42a56813	0x145d55ae4848f9782efcac785a655e3e5dce1bcd	false	17	0	41901135	2022-11-28T14:30:40.000Z	0xd6791641963b12df62e8e380e13720c15397f280933773ffaad2f1340b2b769a
0x37595fcaf29e4fbac0f7c1863e3df2fe6e2247e9	0xa634bb5eb81b3ec6041c68fc77dff2068df33cb4	false	18	1	72234740	2023-03-21T20:27:37.000Z	0x7d762bcbcd972689d3f6bdc5a9eb4ff76cb05f76d0c9d40d40f92bb428d92daa

Example Query

Query with partition filter

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

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
0x66cd859053c458688044d816117d5bdf42a56813	0xd147e0be7b8cb2104274f1ff3962b917c6c300b1	false	83	3	205308811	2024-04-27T09:23:23.000Z	0xc71a47c99352bcb10f2253637da8ab7109ae7b039a9993675b29d07e382c1db7
0x66cd859053c458688044d816117d5bdf42a56813	0x8dbb0993c76d006896ca2c894272580ae561563d	false	81	1	205308811	2024-04-27T09:23:23.000Z	0xc71a47c99352bcb10f2253637da8ab7109ae7b039a9993675b29d07e382c1db7
0x66cd859053c458688044d816117d5bdf42a56813	0x330dfc5bc1a63a1dcf1cd5bc9ad3d5e5e61bcb6c	false	82	2	205308811	2024-04-27T09:23:23.000Z	0xc71a47c99352bcb10f2253637da8ab7109ae7b039a9993675b29d07e382c1db7

Example Query

Query with partition filter

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

HypervisorFactoryZyberswap_HypeAdded_event

Hypervisor vault deployment events from Gamma Strategies on Zyberswap DEX (decentralized exchange) on Arbitrum. Tracks newly created liquidity management vaults with their contract addresses and sequential indexing for monitoring Gamma’s vault ecosystem expansion.

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
0x37595fcaf29e4fbac0f7c1863e3df2fe6e2247e9	0x3b3fec6029534e4e794f0cfb58cc64cdd66b90c7	false	6	2	67705273	2023-03-07T20:53:59.000Z	0x937ca44ef2da512d573277c67cf4df1335b612dfd22bdc8a4cf61a736d67349b
0x37595fcaf29e4fbac0f7c1863e3df2fe6e2247e9	0xaa3522d51448a33682692baccfbefc109d211f65	false	5	1	67705273	2023-03-07T20:53:59.000Z	0x937ca44ef2da512d573277c67cf4df1335b612dfd22bdc8a4cf61a736d67349b
0x37595fcaf29e4fbac0f7c1863e3df2fe6e2247e9	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	10	6	67705273	2023-03-07T20:53:59.000Z	0x937ca44ef2da512d573277c67cf4df1335b612dfd22bdc8a4cf61a736d67349b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gammastrategies_v1_arbitrum.HypervisorFactoryZyberswap_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
0xe84b0443b8341d9c215a150ff208c0ce5d2d9a74	0x52ee1ffba696c5e9b0bc177a9f8a3098420ea691	false	0xe84b0443b8341d9c215a150ff208c0ce5d2d9a74	700504003560034755	23	919356	1200000000000000000	70085680	2023-03-15T13:31:15.000Z	0xaa56acc711655ef77e5fe6ded5dd65ce72f60cf4b5396ff53a124120574a36a4
0xae9d26141a04dfa8fc91ab360b32ced1c86c823d	0xdbd82a83eae485eb589f56a7c20f440aec952d1d	false	0xae9d26141a04dfa8fc91ab360b32ced1c86c823d	30602707	19	19266447758685312	20000000	70187920	2023-03-15T21:00:23.000Z	0x07a2075e8756554fd3ae67ffd18bd3a0efa951a19a73def19389cd61caa0bc37
0x5b2ffd93727bb48ce4893ee906aa34092f5174ee	0xf08bdbc590c59cb7b27a8d224e419ef058952b5f	false	0x5b2ffd93727bb48ce4893ee906aa34092f5174ee	1322133100588845345	19	58000000000000000	46371777806374206	70193733	2023-03-15T21:28:12.000Z	0xf74743ffa2ae8a7da11b2c257742e94972cadc3be65ce70ceeba6057f4517962

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gammastrategies_v1_arbitrum.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
0x8ab16e90409690098ed94ef437a138b7cf702bd5	-269619	false	12	190384724	1928649564	2024-03-14T19:34:46.000Z	737503553615463262087	392553918	0xbe76fcd6c08207e77408a350036f5c22aaa146080bc9d76a20db6c7bdc4680ab
0x8ab16e90409690098ed94ef437a138b7cf702bd5	-269622	false	62	190384358	1928649564	2024-03-14T19:33:14.000Z	737945332016635048667	391671753	0xddfd8dda4d5986d0a5aa2f716619ba941880b1e9ffc3e86329b71a0ae9645542
0x8ab16e90409690098ed94ef437a138b7cf702bd5	-269631	false	33	190383910	1928649564	2024-03-14T19:31:23.000Z	739470751116340779502	388648238	0x1228109d757f46f31a4d665b4b4edcb73b27d8a976eea03282fa6fc88fa4263a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gammastrategies_v1_arbitrum.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
0xcfaba3994c45aa03e479000300801ae35b39c388	0x52ee1ffba696c5e9b0bc177a9f8a3098420ea691	false	0xcfaba3994c45aa03e479000300801ae35b39c388	3260000000000000000	20	26326253	2287412730906660758	57995008	2023-02-04T16:21:57.000Z	0xb4ed750819316f75422b063e0632c169f102219f91dc39d389a6f6a84971cef4
0xf619033986e1b79f151c7b2ff0c620259807863a	0xf08bdbc590c59cb7b27a8d224e419ef058952b5f	false	0xf619033986e1b79f151c7b2ff0c620259807863a	6712389540619685988	24	266247003155516898	269944364207356033	57819161	2023-02-04T00:47:48.000Z	0xe5dda9dca1a4609f0d77d9bdd09b3134c07cb0f4cf16b24ec8cb4a99b070750f
0x9ac21fa62d237e9198d41a1df1de5e2fbf843071	0x21178dd2ba9caee9df37f2d5f89a097d69fb0a7d	false	0x9ac21fa62d237e9198d41a1df1de5e2fbf843071	1546125139900625	24	1723259139311473991	14586920137820847	57995260	2023-02-04T16:23:02.000Z	0x328a5ee2c1b8864921270f0dc06ce8ae9982984a0c8666917cfaf9fc3c129f1a

Example Query

Query with partition filter

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

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
0x35689fd85a10c11e91592260cd654e7d05a7a9d1	0x08a61a58ab10db054fbbe57996e89a69ddeba2f3	false	0x35689fd85a10c11e91592260cd654e7d05a7a9d1	112489488722120248993	27	23241957860157882	315301560245156139328	184510150	2024-02-26T01:45:09.000Z	0xfaf81604b82de62b9cc549f9197dae70fecc19d4b2deca8d49919202a544e116
0x465fdd529ec465411c0b589db3e1072755d90f8d	0x2bcbdd577616357464cfe307bc67f9e820a66e80	false	0x465fdd529ec465411c0b589db3e1072755d90f8d	75620508310894753	15	389434082727016371520	61476755765589442	184781445	2024-02-26T20:57:27.000Z	0xc43dd56be5309218cd38af6eed5aa704d72d387114c687a4566a9d7d3a0f25d5
0x8e8d1e637d207c374105fd9bb88159f4befaac98	0x2bcbdd577616357464cfe307bc67f9e820a66e80	false	0x8e8d1e637d207c374105fd9bb88159f4befaac98	23553515971820088	15	130505000000000000000	18040912856413915	184775265	2024-02-26T20:30:47.000Z	0x0af461ba0467c8636784c9bdab5c8e84a99c3603ec0c0d0747e8ba46b72b6fd2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gammastrategies_v1_arbitrum.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
0x1d58328205429d39ce21a13dcd3feb73180c9b20	0x1787e94420be13581ad1a58318c379a66fc520bf	false	0x1d58328205429d39ce21a13dcd3feb73180c9b20	8820086423809395	20	13709556045697956586	3475032926051546	165248911	2023-12-30T09:45:24.000Z	0x6fd810674562c165fccd16ca0e5398a4f648352ab46c24dc99aba50c8da2e3b4
0xd952dc6d2badb958dcb263d5883f76a65dbbf842	0x265a0f96b61849773a7b515495c6f04b364b28d8	false	0xd952dc6d2badb958dcb263d5883f76a65dbbf842	9102040301	21	1061583915760720893767	5240268742	165221438	2023-12-30T07:50:37.000Z	0x566ad6621181a584c1d04d6458821054a7dc92610bbf8f30b0128b2c550f1f5a
0x3304552189ceaf3ec54075dc2f80d399a3854548	0x265a0f96b61849773a7b515495c6f04b364b28d8	false	0x3304552189ceaf3ec54075dc2f80d399a3854548	876828450	20	100639258104523664010	512519827	165125005	2023-12-30T01:07:26.000Z	0x7afd77f6e3398f5efd3745d8fb342237c6be6a6ce9edecb623bacc3dfa0f5b74

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.gammastrategies_v1_arbitrum.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
7	0x1e86a593e55215957c4755f1be19a229af3286f6	false	407644353058358952506	105414597615230032	4	71303590	2023-03-19T03:47:48.000Z	0x5592d8c29243e1a2fad1e9f6df699c57cebdf7577acd02d4963eca06579222d6
7	0x1e86a593e55215957c4755f1be19a229af3286f6	false	179187719686448705558	46336963155806175	11	71303590	2023-03-19T03:47:48.000Z	0x5592d8c29243e1a2fad1e9f6df699c57cebdf7577acd02d4963eca06579222d6
7	0x1f70f9c577bb91f1445c7144fe66d15f7041fd10	false	3076519396788	138352899	11	71340206	2023-03-19T06:23:32.000Z	0x5db35adbe7f4b8206e9bdc1c7f8b112954225d75b26efb6b7efcaadc763072ab

Example Query

Query with partition filter

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

HypervisorV2Zyberswap_Deposit_event

Deposit events from Gamma Strategies V2 Hypervisor vaults on Zyberswap DEX (decentralized exchange) on Arbitrum, recording liquidity provider deposits with token amounts and LP share issuance. Used for tracking vault liquidity inflows and user position entries.

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
0x22f41395faf8a38de821202406c778f71a14e2a2	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	0x22f41395faf8a38de821202406c778f71a14e2a2	227261444831295562	20	245236926437286454112	438631341955596	123087744	2023-08-20T01:26:06.000Z	0x5ee22912dbc9f9f0ccb649b1893ea5581f2851861e2fcc16db1dabe55dbeaeac
0x63dada04127bc47d60265b0190ace89887f6dda2	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	0x63dada04127bc47d60265b0190ace89887f6dda2	1699154159619892016	23	1575000000000000000000	13010947037828170	123327298	2023-08-20T19:23:10.000Z	0xcd77b5d740ef11ee4ddb9a38e7de867376fcb8fcf553806a793bf800a4986b4e
0xd31e9a3e1321c89bb6b400eae70a507e49c1f4be	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	0xd31e9a3e1321c89bb6b400eae70a507e49c1f4be	118557502613893060	31	114408092144161161497	732910584292581	123175061	2023-08-20T08:06:15.000Z	0x3278db055890110b85bf7205cf95dd707e2da7e45872841c4c6f20c098b1defd

Example Query

Query with partition filter

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

HypervisorV2Zyberswap_Withdraw_event

Withdraw events from Gamma Strategies hypervisor vaults on Zyberswap (Arbitrum), recording liquidity provider exits with share redemption amounts and underlying token0/token1 quantities received.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x3028d2fd110cddc08ea105af2804a2e38f35e073	0xaa3522d51448a33682692baccfbefc109d211f65	false	0x3028d2fd110cddc08ea105af2804a2e38f35e073	3000000000	38	218180176597195829	3217931724	189332758	2024-03-11T15:13:29.000Z	0x0f0a0961c8074eeeafcee09225eda5bc491e3444a258ca49ea1866979f20be9a
0xba7c58e3735cc41856395afa52514cf9f7963d32	0xd820502864dc8928b40b92e764908a22780a0ffe	false	0xba7c58e3735cc41856395afa52514cf9f7963d32	29479323	17	20089616	23760430	232795116	2024-07-16T11:44:00.000Z	0xd09c8fe570c6e5fb923bfaf8a22117ba10e30217c3b30829bd380ce7d7db77c2
0x1a1e7a3b925476a3d81fddaa113dceb94257e88a	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	0x1a1e7a3b925476a3d81fddaa113dceb94257e88a	10000000000000000000	23	9233270608067786409606	64603805828712849	139306062	2023-10-10T09:18:16.000Z	0x052be64267440ff981958198f062a75eb76e23b360b0c8aea470dbba3fe87063

Example Query

Query with partition filter

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

HypervisorV2Zyberswap_ZeroBurn_event

ZeroBurn events from Gamma Strategies Hypervisor V2 vaults on Zyberswap (Arbitrum), recording fee collection amounts in both tokens without removing liquidity. Used to track vault fee accrual and performance without position rebalancing.

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
7	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	1654550719671663432	96105552714267	7	144191771	2023-10-26T13:11:54.000Z	0x66da02535fd7cfcef2e38f9d912eff1228fb7f38d4a59ec29e05eaf85377298e
7	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	428846940444930595	24909827031148	14	144191771	2023-10-26T13:11:54.000Z	0x66da02535fd7cfcef2e38f9d912eff1228fb7f38d4a59ec29e05eaf85377298e
7	0x35ea99ab62bcf7992136558e94fb97c7807fcd6a	false	1499588210439074132	81407714650202	11	144023143	2023-10-26T00:59:25.000Z	0xc081c72b6e80d92460b69854a32fb61651831f384a55b599bc44319789f72541

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

HypervisorFactory_HypeAdded_event

HypervisorFactoryUniswap_HypeAdded_event

HypervisorFactoryZyberswap_HypeAdded_event

HypervisorV1Uniswap_Deposit_event

HypervisorV1Uniswap_Rebalance_event

HypervisorV1Uniswap_Withdraw_event

HypervisorV2Uniswap_Deposit_event

HypervisorV2Uniswap_Withdraw_event

HypervisorV2Uniswap_ZeroBurn_event

HypervisorV2Zyberswap_Deposit_event

HypervisorV2Zyberswap_Withdraw_event

HypervisorV2Zyberswap_ZeroBurn_event

​Tables

​HypervisorFactory_HypeAdded_event

​HypervisorFactoryUniswap_HypeAdded_event

​HypervisorFactoryZyberswap_HypeAdded_event

​HypervisorV1Uniswap_Deposit_event

​HypervisorV1Uniswap_Rebalance_event

​HypervisorV1Uniswap_Withdraw_event

​HypervisorV2Uniswap_Deposit_event

​HypervisorV2Uniswap_Withdraw_event

​HypervisorV2Uniswap_ZeroBurn_event

​HypervisorV2Zyberswap_Deposit_event

​HypervisorV2Zyberswap_Withdraw_event

​HypervisorV2Zyberswap_ZeroBurn_event

Tables

HypervisorFactory_HypeAdded_event

HypervisorFactoryUniswap_HypeAdded_event

HypervisorFactoryZyberswap_HypeAdded_event

HypervisorV1Uniswap_Deposit_event

HypervisorV1Uniswap_Rebalance_event

HypervisorV1Uniswap_Withdraw_event

HypervisorV2Uniswap_Deposit_event

HypervisorV2Uniswap_Withdraw_event

HypervisorV2Uniswap_ZeroBurn_event

HypervisorV2Zyberswap_Deposit_event

HypervisorV2Zyberswap_Withdraw_event

HypervisorV2Zyberswap_ZeroBurn_event