balancer_v3_hyperevm

Tables

V3StablePoolFactoryV2_PoolCreated_event

Balancer V3 stable pool creation events emitted by the V3StablePoolFactoryV2 contract. Records the deployment of new stable pools with the pool contract address for tracking liquidity pool initialization across Balancer V3 deployments.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x96484f2abf5e58b15176dbf1a799627b53f13b6d	0xaae3f92c771c2caed82df8ecf73b85c193c81481	false	4	10844693	2025-08-11T13:22:00.000Z	0x886e4fce9e439c5ff3e87b0da4fbe55e21ee9ddea5726ddb12ce89f43ac17055
0x96484f2abf5e58b15176dbf1a799627b53f13b6d	0x771ffda7186aa4ff78139672ce8f4017773b4512	false	4	9644074	2025-07-28T21:14:00.000Z	0x23d339e85531c1e1e8458871f51583fc4c75ffe95f1c3b3e544c84aa17a370df
0x96484f2abf5e58b15176dbf1a799627b53f13b6d	0x6763b125cd2aff99b3701b2061e5fd6584cb9b2b	false	10	9635351	2025-07-28T18:51:00.000Z	0x060baad29764faa17d47749aea60e6af6264e80023294ffd522061257f7e9dfc

Example Query

Query with partition filter

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

V3StableSurgePoolFactoryV2_PoolCreated_event

Pool creation events emitted by Balancer V3 StableSurge Pool Factory V2 contracts. Records the instantiation of new stable pool instances with the deployed pool contract address.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x3f170631ed9821ca51a59d996ab095162438dc10	0xe2a9c8c600115cecc65e3e5a29ec54e6eedc2501	false	10	11650441	2025-08-20T17:33:00.000Z	0xba58f2404073b68ff6d905856a5b400101059bb093b3727c5425228459d25f57
0x3f170631ed9821ca51a59d996ab095162438dc10	0xba0163e18b8b6236d5046841e698f2f2d89bd4bd	false	1	11651173	2025-08-20T17:45:00.000Z	0x6f6c1175cd533908ea9af523929ec3af426893076e095df0d7f77ddab7d29684
0x3f170631ed9821ca51a59d996ab095162438dc10	0x78a5c99070024a8b8d5cdbceec84ecbf073d9c56	false	3	15657775	2025-10-05T08:45:00.000Z	0x4d33c7102259e385641c799761e0cece8628ffbd86f70ee4055168ba50f47e1f

Example Query

Query with partition filter

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

V3WeightedPoolFactory_PoolCreated_event

Event logs emitted when a new weighted liquidity pool is deployed by the V3WeightedPoolFactory contract on Balancer V3 or Beethoven X protocols. Contains the factory contract address and the newly created pool address for tracking pool deployments.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xe3881627b8deebccf9c23b291430a549fc0be5f7	0x6bd8de0fed17dc0c0a82b9fe5522b129ecaebdbd	false	8	9292523	2025-07-24T20:28:00.000Z	0x9dcc29bd25ac8395b98bbfc9eb3dae3772848d90a17cfb595bb407cb3e5261ca
0xe3881627b8deebccf9c23b291430a549fc0be5f7	0xa5b39551f301343b5f6dd1047d4c55082a60f14f	false	0	9292950	2025-07-24T20:35:00.000Z	0xc30c2892de9243e88ebef2e7d77034fecffdf26b2c704fe8dccca5d90cc92895
0xe3881627b8deebccf9c23b291430a549fc0be5f7	0xb537c62307d25f1eb70b720f5850b8c638240f1b	false	5	6737631	2025-06-25T17:40:00.000Z	0xf0982e39a0a21d3a302aad74a4e1ad5fcc90e06534fcd023438e55ea50b06b0a

Example Query

Query with partition filter

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

Vault_AuthorizerChanged_event

Balancer Vault authorizer change events emitted when the protocol’s permission controller contract address is updated. Records the new authorizer contract address responsible for managing access control to vault functions.

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_newAuthorizer`	`STRING`	Address of the new authorizer contract set for the Balancer vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_LiquidityAdded_event

Liquidity deposit events emitted by Balancer V3 vault contracts recording token amounts added to pools, associated fees, and resulting pool token supply. Used for tracking liquidity provision activity and calculating pool composition changes.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
`in_amountsAddedRaw`	`ARRAY<STRING>`	Array of token amounts added to the pool during the liquidity addition operation. Numeric string representation of quantities in smallest denomination, ordered to match the pool’s token array.
`in_swapFeeAmountsRaw`	`ARRAY<STRING>`	Array of swap fee amounts charged on the liquidity operation for each token in the pool. Numeric string representation of fee quantities in smallest denomination, ordered to match the pool’s token array.

Sample Data

address	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsAddedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xba0163e18b8b6236d5046841e698f2f2d89bd4bd	false	131	18372381	1049021001723180004401662	2025-11-05T06:33:00.000Z	0xf9ac4693b48abcfdf7b2ca93d18dd0485144e373e896ebdc417779a4365a796d	[“5628666176325153539413”,“1147615952”]	0x5db201ae15f9702f0a0ff9f00b8c1c18355373d0	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xba0163e18b8b6236d5046841e698f2f2d89bd4bd	false	4	18395125	1049067552277288571834562	2025-11-05T12:45:52.000Z	0x4270420a45494b0ec1bb8b0db127380c701a1e8c13adf0e0c2a1b76fd1b711d4	[“38600262330811165560”,“7871988”]	0xa09d5ba6f2463abd0429fab9f4aaa920b185387b	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x768e4f8219095d714bc7dcfd60a5ece67d32faf9	false	4	10028129	71800563491017869864731	2025-08-02T06:10:00.000Z	0x6675295feee4679783d720030041ca99d61cf1c04964283a6d33c9ca38c2dd4d	[“67408173”,“139985995”]	0xd385e0e6ec2318a82bc4e97f2d5d27d80d6683e1	[“0”,“0”]

Example Query

Query with partition filter

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

Vault_LiquidityRemoved_event

Balancer V3 Vault liquidity removal events recording withdrawal transactions from liquidity pools. Contains provider address, pool address, withdrawn token amounts in smallest denomination, swap fees charged, and updated pool token supply after withdrawal.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
`in_amountsRemovedRaw`	`ARRAY<STRING>`	Array of token amounts withdrawn from the pool during the liquidity removal operation. Numeric string representation of quantities in smallest denomination, ordered to match the pool’s token array.
`in_swapFeeAmountsRaw`	`ARRAY<STRING>`	Array of swap fee amounts charged on the liquidity operation for each token in the pool. Numeric string representation of fee quantities in smallest denomination, ordered to match the pool’s token array.

Sample Data

address	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsRemovedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6e7615cd5533f5fb1eb623ac1f99a921d66425df	false	5	15356260	1000000	2025-10-01T22:22:07.000Z	0x9b18a41655d093b4d9878a4f2ebbe5f8c60e4b668e53f34ef4ad8e21a51d65bb	[“25137535136973258982”,“1792758130599020384826”]	0x182453d6092020f9034c4e3c49235cb261280059	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x7344f2d57402a03c07d47893fe9c045cdd3d0a6b	false	10	15294228	119401959336280541666	2025-10-01T05:25:12.000Z	0x2a189d64257e096a3ff32437bfdef18d788bb4e51b891634543417d32c43889a	[“1129242736422627”,“40240”]	0xaeb001af15a14929ab035ce5c2a31b19e5145688	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x0a30dd024acad66e9c17f23aea8f71490a711626	false	6	12995175	1000000	2025-09-05T01:10:32.000Z	0x611b04d26d462bb9aa6c9aad66062d1bfb7205b31d64e31f8c4abd23e3cc2c19	[“4162359673721733535”,“99732256”]	0x90347b9cc81a4a28aac74e8b134040d5ce2eab6d	[“0”,“0”]

Example Query

Query with partition filter

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

Vault_PoolRegistered_event

Event logs recording new liquidity pool registrations in Balancer vault contracts. Contains pool address, unique pool identifier, factory address, token configurations with rate providers, hook configurations for custom pool logic, liquidity management settings, role assignments for governance, and initial swap fee parameters.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenConfig`	`ARRAY<STRUCT<token STRING, tokenType INT64, rateProvider STRING, paysYieldFees BOOL>>`	Array of token configuration structs defining properties for each token in the pool. Each struct contains the token contract address (hex-encoded, 0x-prefixed, 42-character string), token type identifier, rate provider address, and boolean flag indicating whether the token pays yield fees.
`in_swapFeePercentage`	`STRING`	Swap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
`in_pauseWindowEndTime`	`STRING`	Unix timestamp indicating when the pause window expires for the pool. Numeric string representing seconds since epoch.
`in_roleAccounts`	`STRUCT<pauseManager STRING, swapFeeManager STRING, poolCreator STRING>`	Struct containing account addresses assigned to manage pool operations. The `pauseManager` field specifies the account authorized to pause the pool, `swapFeeManager` controls swap fee adjustments, and `poolCreator` identifies the original pool deployer. Each field contains a contract address (hex-encoded, 0x-prefixed, 42-character string, or zero address if unassigned).
`in_hooksConfig`	`STRUCT<enableHookAdjustedAmounts BOOL, shouldCallBeforeInitialize BOOL, shouldCallAfterInitialize BOOL, shouldCallComputeDynamicSwapFee BOOL, shouldCallBeforeSwap BOOL, shouldCallAfterSwap BOOL, shouldCallBeforeAddLiquidity BOOL, shouldCallAfterAddLiquidity BOOL, shouldCallBeforeRemoveLiquidity BOOL, shouldCallAfterRemoveLiquidity BOOL, hooksContract STRING>`	Configuration struct defining hook contract settings and lifecycle callbacks for pool operations. The `hooksContract` field contains the hook contract address (hex-encoded, 0x-prefixed, 42-character string, or zero address if hooks are disabled), while boolean fields specify which pool lifecycle events trigger hook execution.
`in_liquidityManagement`	`STRUCT<disableUnbalancedLiquidity BOOL, enableAddLiquidityCustom BOOL, enableRemoveLiquidityCustom BOOL, enableDonation BOOL>`	Configuration struct defining liquidity management rules for pool operations. Boolean fields control whether unbalanced liquidity is disabled, custom add/remove liquidity functions are enabled, and direct token donations to the pool are permitted.

Sample Data

address	in_pool	removed	log_index	in_factory	block_number	in_hooksConfig	in_tokenConfig	block_timestamp	in_roleAccounts	transaction_hash	in_swapFeePercentage	in_pauseWindowEndTime	in_liquidityManagement
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xf7948a260fb0a93bdab3ac05e0ac89284acd746b	false	10	0xe3881627b8deebccf9c23b291430a549fc0be5f7	17094647	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x02c6a2fa58cc01a18b8d9e00ea48d65e4df26c70”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x1359b05241ca5076c9f59605214f4f84114c0de8”,“tokenType”:1,“rateProvider”:“0x083961c864cfb44b5b772341659587357acf21e6”,“paysYieldFees”:true},{“token”:“0x5748ae796ae46a4f1348a1693de4b50560485562”,“tokenType”:1,“rateProvider”:“0xb5f8f253d0a6d4a18014ceca4253a2cec6c98763”,“paysYieldFees”:true},{“token”:“0x81e064d0eb539de7c3170edf38c1a42cbd752a76”,“tokenType”:1,“rateProvider”:“0x36c61230ceae487572369ead4a8bd7fd19ebf4fd”,“paysYieldFees”:true},{“token”:“0xb50a96253abdf803d85efcdce07ad8becbc52bd5”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xfd739d4e423301ce9385c1fb8850539d657c296d”,“tokenType”:1,“rateProvider”:“0x532da919d3eb5606b5867a6f505969c57f3a721b”,“paysYieldFees”:true}]	2025-10-21T17:24:00.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0xeaa27e3ee5d021ae0db2883de16bf72ea8f8575c58ea364b4c7de43f0de95f2c	3000000000000000	1874760180	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4d694d25dfacad0334bd118c81f8c63b81f23c7e	false	14	0xe3881627b8deebccf9c23b291430a549fc0be5f7	17093549	{“hooksContract”:“0x5dbad78818d4c8958eff2d5b95b28385a22113cd”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0x02c6a2fa58cc01a18b8d9e00ea48d65e4df26c70”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x1359b05241ca5076c9f59605214f4f84114c0de8”,“tokenType”:1,“rateProvider”:“0x083961c864cfb44b5b772341659587357acf21e6”,“paysYieldFees”:true},{“token”:“0x5748ae796ae46a4f1348a1693de4b50560485562”,“tokenType”:1,“rateProvider”:“0xb5f8f253d0a6d4a18014ceca4253a2cec6c98763”,“paysYieldFees”:true},{“token”:“0x81e064d0eb539de7c3170edf38c1a42cbd752a76”,“tokenType”:1,“rateProvider”:“0x36c61230ceae487572369ead4a8bd7fd19ebf4fd”,“paysYieldFees”:true},{“token”:“0xb50a96253abdf803d85efcdce07ad8becbc52bd5”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xfd739d4e423301ce9385c1fb8850539d657c296d”,“tokenType”:1,“rateProvider”:“0x532da919d3eb5606b5867a6f505969c57f3a721b”,“paysYieldFees”:true}]	2025-10-21T17:06:00.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x9631acf3509531dda1b6917cde04d3a0cd08fbfc70b8bbe8ebc61d6f2798d0b0	3000000000000000	1874760180	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x9a501d6b739f9b0a79214c9d2b3cdbf602b3b63d	false	48	0xe3881627b8deebccf9c23b291430a549fc0be5f7	8498170	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x02c6a2fa58cc01a18b8d9e00ea48d65e4df26c70”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xbe6727b535545c67d5caa73dea54865b92cf7907”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-07-15T19:01:00.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x4b7566c182c49d18c2956626a79b10a0510fb66d12ffe10cff41dcf69aecd758	1000000000000000	1874760180	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

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

Vault_Swap_event

Swap events emitted by decentralized exchange vault contracts containing input/output token addresses, amounts, pool identifiers, and swap fee data. Tracks token exchanges executed through vault-based automated market maker protocols.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
`in_swapFeePercentage`	`STRING`	Swap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
`in_swapFeeAmount`	`STRING`	Amount of fees charged on the swap transaction. Numeric string representing the fee quantity in the input token’s smallest denomination.

Sample Data

address	in_pool	removed	log_index	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	in_swapFeeAmount	transaction_hash	in_swapFeePercentage
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x1c9854020388ea51b3f0a4e86695596362073bbd	false	13	0xd704254eb350e0d3baecd194d095862267897ae0	2476993369494077	0xfd739d4e423301ce9385c1fb8850539d657c296d	12185848	2484964048361574	2025-08-26T20:01:45.000Z	123849668475	0x189a5007db5926d461cde41e9874721192b49bf5992d2f8605b564a67598da47	50000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x1c9854020388ea51b3f0a4e86695596362073bbd	false	34	0xd704254eb350e0d3baecd194d095862267897ae0	73607985605458704351	0xfd739d4e423301ce9385c1fb8850539d657c296d	12127001	73797812543268149839	2025-08-26T03:57:02.000Z	3680399280272935	0x2e0929714e61198c72d6779327c2c8c849edd74242d187e3206a3998d1ecfc85	50000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x1c9854020388ea51b3f0a4e86695596362073bbd	false	31	0xd704254eb350e0d3baecd194d095862267897ae0	3502098189981421244	0xfd739d4e423301ce9385c1fb8850539d657c296d	12159559	3513040168110091590	2025-08-26T12:50:47.000Z	175104909499071	0x27d9d75cb103e8179f9ab62870f0b9df2263d1771929c3b0fd05e3b8dcede69d	50000000000000

Example Query

Query with partition filter

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

Vault_SwapFeePercentageChanged_event

Event logs emitted when a liquidity pool’s swap fee percentage is updated. Records the pool address and new fee rate in wei basis (1e18 = 100%), enabling fee structure tracking across Balancer V3 vault contracts.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_swapFeePercentage`	`STRING`	Swap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_swapFeePercentage
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x2f81d322aeef021f43020df4a45ca1087c7281ab	false	7	9111720	2025-07-22T19:04:00.000Z	0x3f2b964598adfc08eafe496273f23bef2e14da499d1c474b41842e527ae088d5	10000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4c5605eae66608c706f77f6527b6e02888721b10	false	11	9107328	2025-07-22T17:52:00.000Z	0x595115e483f7f9e9f0657ff00a912ef07113e34f8be5652bbf46f5e2588b1840	10000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x581d2efd114c4cb1fb5e8a44eb55af7ca941ea4b	false	4	14327717	2025-09-20T05:18:00.000Z	0x04de85e05b70f35e5f8aa7e6e576c629f3ec8db95f08ee1091c1a9deea2aaa6f	2900000000000000

Example Query

Query with partition filter

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

Vault_Unwrap_event

Unwrap events from Balancer v3 Vault contracts recording conversions of wrapped tokens back to underlying assets. Contains burned share amounts, withdrawn underlying amounts, wrapped token addresses, and post-operation buffer balances for tracking liquidity buffer state changes.

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_wrappedToken`	`STRING`	Contract address of the wrapped token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_burnedShares`	`STRING`	Number of wrapped token shares burned in the unwrap operation. Decimal string representation of the token amount.
`in_withdrawnUnderlying`	`STRING`	Amount of underlying token withdrawn from the buffer during the unwrap operation. Decimal string representation of the token amount.
`in_bufferBalances`	`STRING`	Buffer balances after the operation encoded as a 66-character hex string. Concatenates two 32-byte values representing the balances of the underlying and wrapped tokens in the buffer.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_burnedShares	in_wrappedToken	transaction_hash	in_bufferBalances	in_withdrawnUnderlying
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	51	14835462	2025-09-26T00:03:00.000Z	777337046343222	0x0571362ba5ea9784a97605f57483f865a37dbeaa	0x9be3d2d10ac79174e9edb3f27bf8bbb3b293a42d39ae8fc0491b34db5ae4ea08	0x000000000000000000005ad225d7568c000000000000000000005afc7b883155	778752450413266
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	91	14853823	2025-09-26T05:04:00.000Z	278761897575578	0x0571362ba5ea9784a97605f57483f865a37dbeaa	0x9c042a112ba49fcf99f80f6efde4c62bfb3cdc1f99d121fd87463854f7d693b9	0x000000000000000000005ad219a45ea6000000000000000000005afc8793a34a	279270614051945
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	274	14916043	2025-09-26T22:04:00.000Z	678839265349113	0x0571362ba5ea9784a97605f57483f865a37dbeaa	0xa0dcf9f6e0c9e09c98f6897aeb211087aec7d48778d8f00bb71acfa9eb0a7bcd	0x000000000000000000005ad1f0284751000000000000000000005afcb17387e7	680087604576923

Example Query

Query with partition filter

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

Vault_Wrap_event

Token wrapping events from Balancer V3 vault operations recording the conversion of underlying assets into wrapped token shares. Contains deposited amounts, minted shares, wrapped token addresses, and post-operation buffer balances for tracking liquidity buffer state changes.

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_wrappedToken`	`STRING`	Contract address of the wrapped token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_depositedUnderlying`	`STRING`	Amount of underlying token deposited in the wrap operation. String-encoded integer representing token amounts in the smallest denomination.
`in_mintedShares`	`STRING`	Number of shares minted in the operation. String-encoded integer representing share amounts in the smallest denomination.
`in_bufferBalances`	`STRING`	Buffer balances after the operation encoded as a 66-character hex string. Concatenates two 32-byte values representing the balances of the underlying and wrapped tokens in the buffer.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_mintedShares	in_wrappedToken	transaction_hash	in_bufferBalances	in_depositedUnderlying
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	24	18657224	2025-11-08T12:23:50.000Z	511175302173760	0x0571362ba5ea9784a97605f57483f865a37dbeaa	0x763c63f56e80d8e9bfac82ebc194a512d0cd3a505264c2a444485799c891f7c5	0x000000000000000000005ac73f4399f5000000000000000000005b07486dbda5	512583846902150
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	20	18621754	2025-11-08T02:41:05.000Z	14217591	0x06fd9d03b3d0f18e4919919b72d30c582f0a97e5	0x5fc7f3f159100e0e6ed89c1ec4a07713a40dd18c3733cae85bcdbd777c73e40c	0x000000000000000000000000000775690000000000000000000000000007cdc2	14875552
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	26	18622816	2025-11-08T02:58:30.000Z	25150023	0x06fd9d03b3d0f18e4919919b72d30c582f0a97e5	0x28d6df121bfd8d81687570a3756c80711057698a145f4fbcb6542f3584341031	0x000000000000000000000000000775680000000000000000000000000007cdc5	26314023

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

V3StablePoolFactoryV2_PoolCreated_event

V3StableSurgePoolFactoryV2_PoolCreated_event

V3WeightedPoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_LiquidityAdded_event

Vault_LiquidityRemoved_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_SwapFeePercentageChanged_event

Vault_Unwrap_event

Vault_Wrap_event

​Tables

​V3StablePoolFactoryV2_PoolCreated_event

​V3StableSurgePoolFactoryV2_PoolCreated_event

​V3WeightedPoolFactory_PoolCreated_event

​Vault_AuthorizerChanged_event

​Vault_LiquidityAdded_event

​Vault_LiquidityRemoved_event

​Vault_PoolRegistered_event

​Vault_Swap_event

​Vault_SwapFeePercentageChanged_event

​Vault_Unwrap_event

​Vault_Wrap_event

Tables

V3StablePoolFactoryV2_PoolCreated_event

V3StableSurgePoolFactoryV2_PoolCreated_event

V3WeightedPoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_LiquidityAdded_event

Vault_LiquidityRemoved_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_SwapFeePercentageChanged_event

Vault_Unwrap_event

Vault_Wrap_event