balancer_v3_gnosis

Tables

V3StablePoolFactory_PoolCreated_event

Event logs emitted when new stable swap pools are created by Balancer V3 StablePoolFactory contracts. Contains the factory contract address and newly deployed pool address for tracking pool deployment activity.

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
0x22625eedd92c81a219a83e1dc48f88d54786b017	0x1545815a9df066bd58d5d47eff7ade0e2a9a6bbb	false	18	38302457	2025-01-30T08:27:55.000Z	0x2c1a14846dc52a85484843cd17bfb0b7487ea2996f44d62690a6d7cba174fde6
0x22625eedd92c81a219a83e1dc48f88d54786b017	0x889ac9f5c87e6ca075777d5e417b3634d3f84135	false	46	38294245	2025-01-29T20:51:20.000Z	0x92ab23b07d686b5ff3bfe4991fe0d4239ae85c8cf3dfef30446e92867285289d
0x22625eedd92c81a219a83e1dc48f88d54786b017	0x30f94009b65778b36122a5bbdf5dfcae4d0aff25	false	104	38324479	2025-01-31T15:43:10.000Z	0xc606d1c0db9db4303a6be24482693282f563512924d3ed33f5bde566e2f114bb

Example Query

Query with partition filter

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

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
0x161f4014c27773840ccb4ec1957113e6dd028846	0x71b81b341e6cc1e5740bb02c20d117d3bd2d7bd3	false	21	41232255	2025-07-23T10:30:45.000Z	0x251152d3ba9c51ea2903b19b078093ffa99bf4b4d8b7ebc8b8d2b53314d4edae
0x161f4014c27773840ccb4ec1957113e6dd028846	0x137d23457a5f58d3ece291ce5654ee33863e9adf	false	195	41692477	2025-08-20T01:57:45.000Z	0xeee82145ad5359ad34eb7ca8015711c4661397436688cfb94c96f716bb9ef49c
0x161f4014c27773840ccb4ec1957113e6dd028846	0x027218b64ff130a7d2692739c8d90bc72b440972	false	6	40241277	2025-05-25T11:18:45.000Z	0x796dba5fc17b46f02ca09fe66aaf87b25c5338313839286513d4ba623b5d7e60

Example Query

Query with partition filter

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

V3StableSurgePoolFactory_PoolCreated_event

Pool creation events emitted by Balancer V3 StableSurge pool factory contracts. Records the factory contract address and newly deployed pool address for tracking stable pool deployments across chains.

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
0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	0x3491bfb37c749121f6175d612ae222f57825a878	false	24	38745786	2025-02-25T17:01:30.000Z	0x06df1b3d3b8d851d0ed2676678cc65edf3a45305581e3d3af76093923aed5b2e
0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	0xdbdd7f265cfc703b46efc34e1d7808155c670226	false	21	38912225	2025-03-07T13:01:20.000Z	0xeb89da287b4894c26deed0b7afbd75756b0cf44cf225c03d6262bf8a5b5e999b
0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	0x825dc69a2fc808620eed7377b19d204e6944c675	false	10	38432099	2025-02-07T00:25:35.000Z	0xf538bc64b1879852464677222f06df10c9de47f026b23ad510374d3847467db4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.V3StableSurgePoolFactory_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
0x45fb5af0a1ad80ea16c803146eb81844d9972373	0xfdc8e4e289a2c070182bb797dcff87fcf0ac661f	false	60	40141841	2025-05-19T13:13:40.000Z	0x22c3133eb61d88d5a3acf98717fc84c647ce52d0331288fb6ff95f220534c10e
0x45fb5af0a1ad80ea16c803146eb81844d9972373	0x00a57f76ee23302f7315dd773efdb7c89468c51e	false	78	39390489	2025-04-04T19:18:50.000Z	0x89720b4eb3eec75dd6017b4b7b09ab7fd0e8aa283fe2d7ca6b95adfeefd355ae
0x45fb5af0a1ad80ea16c803146eb81844d9972373	0xc2c6a23461fffc71068a7cb207336d68c91fb8bd	false	26	41471478	2025-08-06T17:30:30.000Z	0x277212d8ae6648f8a4e238e707772006c68b998d68e547e36e4ff745761f2461

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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
0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	0xae2bb6494d44e5248c4e16e687372260b35a8a0d	false	26	39117614	2025-03-19T16:02:50.000Z	0xd7a57c803799f395d9ae0e6a665cf728d26ed8145807bfc5b1db0ffc69dffb99
0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	0x3baefb385d01af07da39fa30f86f3767fa15aa8e	false	90	42097938	2025-09-13T06:07:50.000Z	0x4a80e242b4c00d28ae1f5ff04b0cd2cb4ff349c7e0a390b72a6969886d5293f7
0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	0x2856d758ad694c2ad6c922997291ea586be725ac	false	37	42273803	2025-09-23T20:10:30.000Z	0x2fb982b84b94eaaea952b647187b8e9d98f3fcdc20bf58517e8aebfd51b27073

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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_gnosis.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_kind	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsAddedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x272d6be442e30d7c87390edeb9b96f1e84cecd8d	false	19	39099299	2597242020464636586493	2025-03-18T14:06:00.000Z	0x0f69e182fefeaa5136fc319044664dc571686347f9dc91b1b96b65354a0082f5	[“71916823559211883”,“1315059136249699063”]	0x22ac765428fa3ac8f0c0b1c92c3200644d59d8b2	[“9276158374”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x272d6be442e30d7c87390edeb9b96f1e84cecd8d	false	182	39101488	2597245096901146455551	2025-03-18T17:11:55.000Z	0x952ebda573a73aa2a6d17a576114fef8d6fb8e69e5df9759c8bca83635567c51	[“11807276363387”,“0”]	0x30f63a4ce1eae9c6652a0964dd57cb59e606794e	[“14759151165”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x272d6be442e30d7c87390edeb9b96f1e84cecd8d	false	168	39100538	2597243757541622241617	2025-03-18T15:50:50.000Z	0xee461b7628c3e54032e49621f54a68ef4a9f46a1570bf39eb36723f3f2212975	[“12990901527552”,“0”]	0x30f63a4ce1eae9c6652a0964dd57cb59e606794e	[“16238682639”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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	0x272d6be442e30d7c87390edeb9b96f1e84cecd8d	false	46	39475860	2595896494086630019799	2025-04-09T20:18:05.000Z	0x405c3b629906279e93ce63d1dbd49ce5aa26cfac1e1ac69554d54cb7cb79daf2	[“282664462214260078”,“5308572135599792428”]	0x84891f7e94d9e1159296ad2345f12027a45a9b0a	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6e6bb18449fcf15b79efa2cfa70acf7593088029	false	100	38526176	1327338710037789124383	2025-02-12T14:28:35.000Z	0x6db3e4a80f8be6991184e6a3b6bfff90e1328aa2e5044cac7b60cecb3feaa894	[“403805840637182102”,“1017219993822494559”]	0x61a7b3d2c5edc9c7f960a8079b41d37e6800d9f7	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6e6bb18449fcf15b79efa2cfa70acf7593088029	false	50	38526426	1326535630924878122660	2025-02-12T14:49:50.000Z	0xb3fbb6e1cdec9021a10011735c4255999a7ccf7b810672a55b05f70c875c5aa0	[“200797233596507114”,“505755735523629833”]	0x61a7b3d2c5edc9c7f960a8079b41d37e6800d9f7	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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	0x031032ef4c0c9dc9710daca530de284c609e7aee	false	3	0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	37534519	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x8fed19c7e7b59e7cfe8d0a1f570c96a721198710”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xaf204776c7245bf4147c2612bf6e5972ee483701”,“tokenType”:1,“rateProvider”:“0x89c80a4540a00b5270347e02e2e144c71da2eced”,“paysYieldFees”:true}]	2024-12-15T06:36:05.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x474786ec369f77b0b432bef1d94d6329c488a08e8b25885d12eeda8d1a6f5460	10000000000000000	1857825345	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x39b466e933735b9870ef1552b096e15107164353	false	88	0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	41258052	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x26ef460b92666ba7233eb7b69431d4273ac1de43”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-07-24T23:21:40.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x07769243d608fc7bee30c935600daa73502c90f6”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0xad2fffa36c746bf7ecb577444c389464dfb2d69a10304089e82e3ba196b539cf	3000000000000000	1857825345	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:true,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x9a1022282c164eacb0cccfe2d4a312a80919783a	false	89	0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	40088520	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x84fee0c672b00795b35cc074b065735f20499903”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x9c9e6f83f882908dca2c28c31d8198b46e7a652f”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-05-16T08:28:40.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0xfff1f03507fe1dd37695f0c49a7b4506d313fb38”,“swapFeeManager”:“0xfff1f03507fe1dd37695f0c49a7b4506d313fb38”}	0x684f43dd933d8d7d18957075de7a85ff0621b36e7a8cb7cdd4499f41283e7e40	1000000000000000	1857825345	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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	0x1f393c5096549b8bbcbe1d7201bad5b74b518ea8	false	290	0x8fed19c7e7b59e7cfe8d0a1f570c96a721198710	85943832486088958743408	0x1509706a6c66ca549ff0cb464de88231ddbe213b	41811449	61152449050313468	2025-08-27T04:10:00.000Z	859438324860889587435	0x02d746570488e141cfc265d1a4fb2fdb0c4028326ed50ebd0afb83f9e344bf70	10000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x1f393c5096549b8bbcbe1d7201bad5b74b518ea8	false	37	0x8fed19c7e7b59e7cfe8d0a1f570c96a721198710	86624992263020036292549	0x1509706a6c66ca549ff0cb464de88231ddbe213b	41819017	60601236271042209	2025-08-27T14:53:45.000Z	866249922630200362926	0x2fb07ff1f4dfae780f622ce110ee1ca0eda5950e0c56ba957bea0fc533cb0d8a	10000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6fb656febeadbad8b3b8ff63b1c5c7f1a22ae0f7	false	88	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	282740422520227000	0x3e76f9caaf9b47089810b4579c598228735e7a11	41820734	84141962092471	2025-08-27T17:21:35.000Z	282740422520227	0x6fb3139d34e39f6042a656e19db37e8867a83df7c2758ee1a5383d71669480d9	1000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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	0x1af3f08e5d4edfb0ebe5873c241b1803102616a3	false	17	40063775	2025-05-14T20:55:20.000Z	0x03ad3b117c577269a5e756abbf610c9001361c7cf7b48fa2feba3a8a5414188b	10000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xa50085ff1dfa173378e7d26a76117d68d5eba539	false	91	42041322	2025-09-09T20:56:40.000Z	0xf212af0dc2d11a04a58fe62686263f77112eae7aeef05ab31ef162a368c37112	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x70b3b56773ace43fe86ee1d80cbe03176cbe4c09	false	27	42039309	2025-09-09T18:03:15.000Z	0x35fcfc2f11e0fe39ec2bdb7ea95c773977163b03ca7b2d839a2905c5cab8eec3	3000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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	7	37805141	2024-12-31T13:08:35.000Z	3839825738224692	0x57f664882f762fa37903fc864e2b633d384b411a	0x7ff034141502ea4b552b828766c73101a32e808ac013d4ad59b073a8f7cb9059	0x000000000000000001ad03e42380cc5d0000000000000000000bbb15b029a7ab	3870662049105123
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	7	37804799	2024-12-31T12:39:20.000Z	5809357013087259	0x57f664882f762fa37903fc864e2b633d384b411a	0xebce36397eeadbeb9c7e9da250e7f06610f04a3630804538d71e3b8ba8b679d1	0x00000000000000000183acb485799d8e000000000000000000356742af4f8193	5856005748885723
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	7	37801995	2024-12-31T08:36:25.000Z	870450874742131	0x57f664882f762fa37903fc864e2b633d384b411a	0xb88c060bbaad9dd8bd450db4d84b6ab975a772860daaab9dfecd7f02834da8cb	0x000000000000000000cac56e05de196b000000000000000000efca6e9039cef0	877435366241390

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_gnosis.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	5	39462088	2025-04-09T00:49:20.000Z	480075	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	0x8fe23833e8be69a3f2e661f77782408e5b3999ff10d381e8774f2d963d9a4d4f	0x000000000000000000000000052c2f2000000000000000000000000009b652a8	488598
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	8	39462767	2025-04-09T01:47:20.000Z	2640104	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	0x36bd86a6cb175e9d5ea897238cf8d5874b3b5d8cb3763fb1e8ab288d36a5e24c	0x00000000000000000000000005559648000000000000000000000000098c2f87	2686968
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	9	39476561	2025-04-09T21:17:40.000Z	447459	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	0x671f4b9054924cf215a60e5788508a47b524b1581bedcef3e07524b290ac7447	0x00000000000000000000000004f0c5fd00000000000000000000000009f2cb2b	455424

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

V3StablePoolFactory_PoolCreated_event

V3StablePoolFactoryV2_PoolCreated_event

V3StableSurgePoolFactory_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

Metrics

Primitives

Contracts

Blockchain

​Tables

​V3StablePoolFactory_PoolCreated_event

​V3StablePoolFactoryV2_PoolCreated_event

​V3StableSurgePoolFactory_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

V3StablePoolFactory_PoolCreated_event

V3StablePoolFactoryV2_PoolCreated_event

V3StableSurgePoolFactory_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