balancer_v3_ethereum

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
0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	0x206987c703a4bb121b97346fbf619fd0294b2994	false	0	22468099	2025-05-12T15:29:59.000Z	0x02721d45c49af8c70eed69d80fe080dc84fa24c294444d8a5f26d67f35ec1643
0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	0x6c9b0af1a8c77275514b8454c73396996fcccfa5	false	435	22468006	2025-05-12T15:11:11.000Z	0x43f2e30ee7d81ee7f1922f794246fdf584f936bf2fd1c5d7bee6d5b31259ecbe
0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	0xf2d8ad2984aa8050dd1ca1e74b862b165f7a622a	false	119	23030104	2025-07-30T06:17:59.000Z	0x3052d6856207a2bde10d622da0f6c17977ea71bfe9f470ae58b7ba5cb63409fa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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
0xe42c2e153bb0a8899b59c73f5ff941f9742f1197	0xecd03277a21e41bd61c9226eba24930a6a54b30c	false	32	23145577	2025-08-15T09:36:11.000Z	0x21b77d5bb5a3a111592b4634ef0698a82b759f570e7d7d26c7abb1875eb55c44
0xe42c2e153bb0a8899b59c73f5ff941f9742f1197	0x1c84704fb1a140cdef733c2530e611ea9f2aee73	false	1	23218431	2025-08-25T13:30:23.000Z	0x8381fbba9973f8869894a50fdf31b879eaef55ed25843c917f070047d917ee37
0xe42c2e153bb0a8899b59c73f5ff941f9742f1197	0xaee2162000f0c26e6feab3c8e7978b89f4d862cd	false	534	23218400	2025-08-25T13:24:11.000Z	0x97ae6bdc3af99b92026c19e22bdc2ca9439e0eaec221455ccdf2a91c9e9e6af6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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
0xd53f5d8d926fb2a0f7be614b16e649b8ac102d83	0x83cd2b247f7dbb692a2b44b67cb4f448f93f0c76	false	12	22147114	2025-03-28T18:11:23.000Z	0xa78252320edfb15035ba5f44ddfcb85459170e65e6ce39bfe2f2b1d50fa7550d
0xd53f5d8d926fb2a0f7be614b16e649b8ac102d83	0xf40a27c779c74596e063906b2741fa37a36c0957	false	180	22147800	2025-03-28T20:29:47.000Z	0x21cdd5256309368745c179da02eb8f4ebed85592df6166d73ecdb257cf549867
0xd53f5d8d926fb2a0f7be614b16e649b8ac102d83	0x813e55c077d9a40afc06b901b050ca3fc72957ec	false	8	22147286	2025-03-28T18:45:47.000Z	0x33c50b7c2d85a9404f43500ea2b2d06306746bd58b5e03a6a6136cdeaf800ee5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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
0x355bd33f0033066bb3de396a6d069be57353ad95	0x8f5e19d7c906aecce13b2661459d893ef298cdcf	false	218	22524789	2025-05-20T14:41:35.000Z	0xcd80c78abb3b30f19571eb5b623b91bcd38489b9269b204a899f6a07fb4df522
0x355bd33f0033066bb3de396a6d069be57353ad95	0x6c5972311191097d002e804a9bf97c96c54059ed	false	229	22524801	2025-05-20T14:44:11.000Z	0x0c25d7f35e1ba6ffffc5759f4f3fdb87963e2d9f2d7d78d10def20ebc1be6f65
0x355bd33f0033066bb3de396a6d069be57353ad95	0xc67ac5c41e1fdd7aee35a64fd0d27f426f9d6d57	false	344	22442595	2025-05-09T01:15:35.000Z	0xa0e30ae4270bc464413fb9eb59545726162f61194dd3873f1cebb5d5f9fed653

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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
0xb9d01ca61b9c181da1051bfdd28e1097e920ab14	0x2a2c4cba6f46a10c1fcab96ba2ac88e4642a929f	false	361	21705533	2025-01-26T01:53:59.000Z	0x4ad6e0bdac68b27228ced199429cecdcd6e8e320efad5276b5738731066cb38c
0xb9d01ca61b9c181da1051bfdd28e1097e920ab14	0xeb95d6bd67f613e7918a031d9f4a9a92766659ac	false	62	21767402	2025-02-03T17:14:23.000Z	0x7470b3155f8bae28770c612cd69d697526e7888dde280055e1dd2355f1171d28
0xb9d01ca61b9c181da1051bfdd28e1097e920ab14	0x10a04efba5b880e169920fd4348527c64fb29d4d	false	1	21554344	2025-01-04T23:17:11.000Z	0xd25ef762cff81240e0bf60514964dfb4942f00f51dd0c5e01c0ed366233d3818

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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_ethereum.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	0xac035537edf62beef0c7208181379f89def22119	false	73	21506178	937431550110629377496769	2024-12-29T05:56:23.000Z	0x5c87b1897979fceca1a37e9a66ac8ab26d0df867ab72bbaaf492b2f0360b6fd7	[“88724825691420727416456”,“158916586693407180563295”]	0xa004e4cedea8497d6f028463e6756a5e6296bad3	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xac035537edf62beef0c7208181379f89def22119	false	42	21506144	669561607186157711230028	2024-12-29T05:49:35.000Z	0x2348f9d12c156f867718c38cb1e91810774637a9a6f44d30bc46cb80ff9dde36	[“100421438840261645579032”,“179866620356221927081070”]	0xa004e4cedea8497d6f028463e6756a5e6296bad3	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xac035537edf62beef0c7208181379f89def22119	false	4	21505892	63194642199782873155405	2024-12-29T04:58:59.000Z	0xeed89d2c7edb5abe2c4d5e75f7396c37429a6f5384051666cf7d1777f91feea7	[“12406942683470463721800”,“44225286275054093628930”]	0xa004e4cedea8497d6f028463e6756a5e6296bad3	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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	0x6c5972311191097d002e804a9bf97c96c54059ed	false	429	23566701	2244907915079357881271076	2025-10-13T05:26:35.000Z	0x5b41a73b5b214e0cb1ec0de8c2a0d688ef611fa645cdfce573fc0d42996ddb06	[“856781518062432649739”,“3543027671700062352163”]	0x2d23feffed69eba4cd6ed47f7006bbd6284dfbea	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6c5972311191097d002e804a9bf97c96c54059ed	false	1137	23571501	2238424086538084667913600	2025-10-13T21:34:35.000Z	0x4590029fbae907d59343550642cbc1f3980cedd9937e42482eb0020527ef561c	[“610826801177739751144”,“1275779609596935151587”]	0x2e51d9c51a568b519506fcd59ce682975fba494f	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6c5972311191097d002e804a9bf97c96c54059ed	false	431	23571429	2240298480355524514282675	2025-10-13T21:19:47.000Z	0xd37a07c9b570292e8a07ecdeed03ba3194300729ec96847dd515cdccb6dfab96	[“1502121115875347719717”,“3137346473147664612935”]	0x3ff245612e4dcae39e3f683acda7b7d2edff43d4	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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	0x2412cf57c5d5ae1980bd2d30753d403fa194fb4a	false	160	0xd53f5d8d926fb2a0f7be614b16e649b8ac102d83	22160180	{“hooksContract”:“0xb18fa0cb5de8cecb8899aae6e38b1b7ed77885da”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0xd4fa2d31b7968e448877f69a96de69f5de8cd23e”,“tokenType”:1,“rateProvider”:“0x8f4e8439b970363648421c692dd897fb9c0bd1d9”,“paysYieldFees”:true},{“token”:“0xfa2b947eec368f42195f24f36d2af29f7c24cec2”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-03-30T13:59:35.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x29377ba20a0305945d11a3d7908db01ad44ad3bb69a335522f7f1065b14a8f82	30000000000000	1863304487	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x571bea0e99e139cd0b6b7d9352ca872dfe0d72dd	false	81	0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	22570726	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x4a220e6096b25eadb88358cb44068a3248254675”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-05-27T01:04:47.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0xe1f720df7c700614c70f42db85a4d3e9f2420220fcf10b834d3dc4183ba39b8f	3000000000000000	1857825455	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xa99b9eca675d1ca6943af29c2f3b395c8670aa65	false	124	0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	22570715	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x4a220e6096b25eadb88358cb44068a3248254675”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-05-27T01:02:35.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x777f8c2defe53d29edc9209b6946a174cefa0e2732b288c47f3ba743947feec4	5000000000000000	1857825455	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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	0x4ab7ab316d43345009b2140e0580b072eec7df16	false	28	0xa35b1b31ce002fbf2058d22f30f95d405200a15b	45288799982583963625	0x0bfc9d54fc184518a81162f8fb99c2eaca081202	22081462	45853500344878937932	2025-03-19T14:18:11.000Z	905775999651679	0x3bca1c23ad484c73e8f0dafc5cca5e905e2132d5992b09e415cb18540484f686	20000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4ab7ab316d43345009b2140e0580b072eec7df16	false	91	0xa35b1b31ce002fbf2058d22f30f95d405200a15b	16790211730648184832	0x0bfc9d54fc184518a81162f8fb99c2eaca081202	22078527	17003944645930397264	2025-03-19T04:27:11.000Z	335804234612963	0x500be94da608430fae4f2cfb60fce7915796e36aa167aacdf0076379e66a7ca9	20000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4ab7ab316d43345009b2140e0580b072eec7df16	false	4	0xa35b1b31ce002fbf2058d22f30f95d405200a15b	35765923663188589688	0x0bfc9d54fc184518a81162f8fb99c2eaca081202	22081464	36217651962577307235	2025-03-19T14:18:35.000Z	715318473263772	0xae1c8dec46825c9f6dc2750ce7bfe2dcd9bf353f850e0a1505de62cac40a1ae9	20000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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	0x2d34b79cc6d1a0ea77e3cbcebe66daf14ecddfd6	false	8	23237622	2025-08-28T05:47:11.000Z	0xcd46e18ed51d7705e8fc6e79e6350657fcf7050d3281fca3e3421eb57b3a45c8	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x2d3ac49c6e3289debd156d664162875f2a6da7e3	false	45	23239961	2025-08-28T13:37:59.000Z	0x04c332a9f14f9e72990c037ce43993aed4a515d4b6e7dbab3248b20f6ce27b4e	10000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x3c2d67e73150dcc80f8fd17227c50989ac9fb570	false	146	23239883	2025-08-28T13:22:23.000Z	0xfb3bff87d019528f02b5785fe7c10f297ea77693b6e3acb7ea3927f624c92fc5	10000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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	28	23343120	2025-09-11T23:32:11.000Z	28384209041290837358	0x0bfc9d54fc184518a81162f8fb99c2eaca081202	0xb5907d9ecf4c02360b1fa6a4e1b510d17f04bc408317238c97474cf2363ae999	0x000000000000000109f3a4655ecc96b6000000000000000117ee764e19e26561	29876226368107982863
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	125	23338650	2025-09-11T08:32:47.000Z	8666817699012268325	0x0bfc9d54fc184518a81162f8fb99c2eaca081202	0x5f248edef59e4dd16a31372404a3d012e010f888e61486f5e5e77030a66991b1	0x00000000000000020575bbbf4c22802700000000000000000f35ca614e547ca7	9122104805144798898
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	564	23341201	2025-09-11T17:05:47.000Z	12325191076666040571	0x0bfc9d54fc184518a81162f8fb99c2eaca081202	0xf16a9da7dace692d0665776a972dd7204ace54d0e9734e8939081e8f56ff0eaf	0x0000000000000000d1f21eeeec0c08f2000000000000000152e10c5f13eb8aec	12972892799063902800

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_ethereum.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	88	21511617	2024-12-30T00:09:11.000Z	31403613374355373378	0x0fe906e030a44ef24ca8c7dc7b7c53a6c4f00ce9	0x71fba55ed375200e6519a8d255e0e8972dbf7330c2af9bcefe3d5286033d2443	0x0000000000000000b7bb86d632e229a70000000000000000b95ed3955fb65ac1	31683561946876047516
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	118	21511606	2024-12-30T00:06:59.000Z	19668949055840584890	0x0fe906e030a44ef24ca8c7dc7b7c53a6c4f00ce9	0x33d288f241a0640aaf5b04fa489124a88b757658ed5b6f48db7b078c88fbd7b4	0x0000000000000000b7bb8759425e69a40000000000000000b95ed31125219125	19844286879340209404
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	167	21514534	2024-12-30T09:56:11.000Z	19459329729313473059	0x0fe906e030a44ef24ca8c7dc7b7c53a6c4f00ce9	0x8610800998c31c13472d39ee04f0a5c168ff6eb2372289a2200658fe0780b3b2	0x0000000000000000b7baffab6711ae670000000000000000b95f5bf563f87e8a	19633241366952330462

Example Query

Query with partition filter

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