balancer_v3_plasma

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
0x81cfae226343b24ba12ec6521db2c79e7aeeb310	0x21199862da98159e7e54d85011a41e0d0914cdd1	false	19	1973875	2025-09-26T16:09:12.000Z	0x69e05ae235073604940cac0b3370d4bbfeda430b16a8b4946979902390cab57f
0x81cfae226343b24ba12ec6521db2c79e7aeeb310	0xd1e89c7991a6c06b0bc8631f0b59553a2a130b8d	false	1	1975947	2025-09-26T16:43:44.000Z	0xb7a3fae181eb5733ab9eae3a7d5dab228b2608b7cf3fbee90ade018a8f9a5bce
0x81cfae226343b24ba12ec6521db2c79e7aeeb310	0x5618d0dc39c7e7e4ae798d4d09417863c4e739cd	false	1	1974366	2025-09-26T16:17:23.000Z	0x36d962297cf471a511672a9fa4283efa9d8628c011aa784c9b0ed8a05a23c39a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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
0x6b5da774890db7b7b96c6f44e6a4b0f657399e2e	0x19b62820b32c75c7a7c9a627fbf7d6359a23a4ac	false	1	2318989	2025-09-30T16:02:51.000Z	0x29a35476e0fb52971cc9e10d018474684c9312a4f4765407d8da1e3f3e803ab7
0x6b5da774890db7b7b96c6f44e6a4b0f657399e2e	0xcff0ec421e9e887a9cadeb3e90969d789df7d4ac	false	1	2317099	2025-09-30T15:31:21.000Z	0x03656cbdfd4558166a271b774c9c2cb518b4182835d8a9c9075b276a9e3414a0
0x6b5da774890db7b7b96c6f44e6a4b0f657399e2e	0x77f5eb915d1b94bb7fdc5f939fc8b30eda2da2f6	false	20	2316369	2025-09-30T15:19:11.000Z	0x8d511da6e6e8bcc0a89c10c8c8ba6dcc18c2fda21e224b04b36c125d84647241

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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
0xf23b4db826dba14c0e857029dff076b1c0264843	0x54d7704832697f95b2caf201f4bb5e895a7812d7	false	0	2894011	2025-10-07T07:46:33.000Z	0xea1500b617c022245538d3f3aff21a4ffe8e67db2653ef4d151013c67e3f9fb0
0xf23b4db826dba14c0e857029dff076b1c0264843	0x5341061384d6d7adda91468b5b92fffc1b366563	false	0	2894179	2025-10-07T07:49:21.000Z	0x172cbe93d6985c20e15139206766d2646bee008cde5c577c50b3200d6c0409c4
0xf23b4db826dba14c0e857029dff076b1c0264843	0x11e7b1fe6fb6112ed72b0dd9985b4a5a50a43fc0	false	1	1898761	2025-09-25T19:17:18.000Z	0x7e90b86aac9eb2686fb2939e007067bd01de58826d93a9bafbfaa4fcb19d36ab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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_plasma.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	0	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	4	3965419	41310109781775977233962195	2025-10-19T17:27:05.000Z	0x6cc1a92b368310603e054794f43d16174e38a381f522ee4d74df1d431fb2c00f	[“1046937567118556909”,“12765567”]	0xf88c303d383ac9053841531fb64720cf92a8d8d6	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0	0x694c009aa31b3f80ee18c218b02390ca2d7151e7	false	4	3936367	10487555031593933894940518	2025-10-19T09:22:53.000Z	0xe56e5abdbc1c1e1630054a36d6fc33d8c2c696fc047e1c9b16a8fb2cec6fc0f5	[“319130910”,“686280404”]	0x170e15c836be1a48ca1e4e00409517aa878c6f69	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x694c009aa31b3f80ee18c218b02390ca2d7151e7	false	19	3955077	10494226469220058739473317	2025-10-19T14:34:43.000Z	0x89acbb73e3c31af3b08e177199c8a309d571d5e8b336d9739b3b2972d77571f9	[“0”,“1000599746”]	0x4a5206e0416bd8df3f2a73bfc8d29bcfec909984	[“0”,“77292”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	10	4110701	41139371585076353265198181	2025-10-21T09:48:27.000Z	0x2d3b609da64c02acc7c49997b9617e378311af77389aad79cae5d096e9ba326b	[“1631224647869789441”,“19372900”]	0x495cf4815be7b3fc075ef0826967dd7b790e531c	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	6	4121772	27091215237135638458463713	2025-10-21T12:52:58.000Z	0xd28e3221b2dc4c30ae968bf410fd515277c483dd32477033d9c63e9b2ba9a0c3	[“1390727960120850654751747”,“17043389178734”]	0x49329e0a9f7ea3fe0a4f10d755b711146a8f308d	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	6	4125112	45364518578101560197512853	2025-10-21T13:48:38.000Z	0xdea3be3fcd9a29848228be42d98ea746253a6319e318de4bdaf93c70aaaacdb4	[“5008606736818611114819”,“61687045202”]	0xd8dd92360ffa099e9e5da8c272c54316e17a0ed3	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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	0xdc2beff8cf82971005ab7e7e4f72bbee2d825850	false	5	0x662112b8cb18889e81459b92ca0f894a2ef2c1b8	2387433	{“hooksContract”:“0xdc2beff8cf82971005ab7e7e4f72bbee2d825850”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:true,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:true,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:true,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-10-01T11:03:35.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x4a25e49a1c80a3b5f7f6247725ed7ad7a6b95d4bd5c3f1d816c6b082f9ec08f9	50000000000000	1882129035	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:true,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xc9c8fd55d3f242ab99f0a5b02ddf5b9f7bc07ebb	false	9	0x6b5da774890db7b7b96c6f44e6a4b0f657399e2e	4252033	{“hooksContract”:“0x6817149cb753bf529565b4d023d7507ed2ff4bc0”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0xd1074e0ae85610ddba0147e29ebe0d8e5873a000”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe0126f0c4451b2b917064a93040fd4770d6774b5”,“tokenType”:1,“rateProvider”:“0x940748d30315276362f594ecccb648a4f9ab7629”,“paysYieldFees”:true}]	2025-10-23T01:03:59.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x730515ec27ab0750502abb63753621fbec564103”,“swapFeeManager”:“0x730515ec27ab0750502abb63753621fbec564103”}	0x7a1d3dcb90d0045d21449d404ace9c8c81b9649421f796936e89a231b4026623	100000000000000000	1882128250	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x089b4b33bb033f9ca8558d450bee08491ca7d262	false	10	0xf23b4db826dba14c0e857029dff076b1c0264843	2237735	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x6100e367285b01f48d07953803a2d8dca5d19873”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xdecb72b3a0ed43f9e6cef921983883e96c8eaea9”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-09-29T17:28:37.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0xf74c2df828fc89326af19795d0e66d3bda69a509421332a8af2c9d4474277e6c	1000000000000000	1882126854	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	3	0xe0126f0c4451b2b917064a93040fd4770d6774b5	12958172	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	3730419	12792326354639072163	2025-10-17T00:10:25.000Z	5758	0x38f32fabb1295d75e7f8eec6d942c4bfd3b69f13c61de432a23cfb632c2f4f07	444365138458097
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	37	0xe0126f0c4451b2b917064a93040fd4770d6774b5	4390971	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	3730446	4334772869700454643	2025-10-17T00:10:52.000Z	1951	0x31d6141d73f085c46e7af01f99dd8104a22fad1c1f7f51db7520b41b7c4a4633	444369017906053
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x01e2c7fcde2b8d5d1413732c4e274ba5b06b1e54	false	72	0xe0126f0c4451b2b917064a93040fd4770d6774b5	3036350	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	3730448	2997489012406575902	2025-10-17T00:10:54.000Z	1349	0x919f1115dbc1717e13eb0fd12653e64372a9738251f6c6f4e6cdbb2aa7c29313	444371651073400

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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	0x21199862da98159e7e54d85011a41e0d0914cdd1	false	23	1973875	2025-09-26T16:09:12.000Z	0x69e05ae235073604940cac0b3370d4bbfeda430b16a8b4946979902390cab57f	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x277af8acde6cb23c59142513fba49b82af8642e3	false	53	1965079	2025-09-26T13:42:36.000Z	0xa76dfc2683f87226c0a8d666ca5c334637781315bf63dda8d88b88148a8a1d9e	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x8f6abb9a36137b2bff3dfea73fb81920d2cbfc88	false	35	1967233	2025-09-26T14:18:30.000Z	0x01fa87a78132025c6c0f350a5e1c5c696a15180cec61be1c367ca46696c4f107	1000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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	9	4007799	2025-10-20T05:13:25.000Z	431611303432996553	0xa047fdfb3420a27a5f926735b475fe5a1e968786	0x9235cb255f2719b1d60989e0d14c3b716b87fffee98365763cc2466802cbce0b	0x000000000000000000005664cefd57a00000000000000000000056694742d3a7	431698532140657322
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	9	4062635	2025-10-20T20:27:21.000Z	107925140191892067	0xa047fdfb3420a27a5f926735b475fe5a1e968786	0x1f2e893793909d1d4e3c9334f60d2f3a8cb03be29d91abed67aa9611be241bc0	0x000000000000000000005664b6ee32c9000000000000000000005669651230c7	107947978810167727
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	14	4031216	2025-10-20T11:43:42.000Z	480630640406280355	0xa047fdfb3420a27a5f926735b475fe5a1e968786	0x4833dde6c4c2fb33e3b2e8776f6531f146bd2f885c4e96c8f6663aa5e1b72222	0x000000000000000000005664c63ec51400000000000000000000566955589452	480729714035973065

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_plasma.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	3	3335733	2025-10-12T10:32:19.000Z	17321299154215	0xa047fdfb3420a27a5f926735b475fe5a1e968786	0xa8d2907ede7a229be4be5b976a215ace7a4fe3495aae1337340b2eb526edbe4c	0x0000000000000000000046a5425be42b000000000000000000006628e9e30058	17322489141516
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	10	3305769	2025-10-12T02:12:55.000Z	9974983226920	0xa047fdfb3420a27a5f926735b475fe5a1e968786	0x8aecf87739a0d9d8aacf00bc8c0140864c084016e348277ff403088e5a2e098a	0x000000000000000000004d53c7316ec3000000000000000000005f7a4522d7c7	9975610904341
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	11	3305622	2025-10-12T02:10:28.000Z	37084	0xe0126f0c4451b2b917064a93040fd4770d6774b5	0x86d1313b083870199ecaea64cf6421e7942e1c963a2e35b52060b6c71a1e0f91	0x000000000000000000000000000018a700000000000000000000000000013acc	37136

Example Query

Query with partition filter

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

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

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