balancer_v3_optimism

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
0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	0x870c0af8a1af0b58b4b0bd31ce4fe72864ae45be	false	1	135447089	2025-05-06T00:55:55.000Z	0xc32db538b5df0d65b1b6c11e7e1f8786d01bea17c46d6180680dac4988b3dcc2
0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	0x699a52566f3db5e055a0b7ea73a4d3bf042f1552	false	10	135171507	2025-04-29T15:49:51.000Z	0x02d78f03988d6c8a5a7b1b5338785e06ea65883c5a17fdba528db5d2014d0775
0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	0xc1c4fefb072a4eea4c427981aea0481605aa3d79	false	9	138593044	2025-07-17T20:41:05.000Z	0xfdef5bc1eb02435227c806fe5341f6e045acd77adf4c1e16e4865a2bb341c609

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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
0x3beb058de1a25dd24223fd9e1796df8589429ace	0xe728e8176be82a5152ba0427b10730e91ef192ee	false	4	142018319	2025-10-05T03:36:55.000Z	0x083fd77d682e5b941f52be35bb320253a07d42b9be115547bc7ef067d19a3923
0x3beb058de1a25dd24223fd9e1796df8589429ace	0x02e6bd3c3eb8624bdb3c6a9cec489719b56e41f5	false	139	138605080	2025-07-18T03:22:17.000Z	0x2d579b243a2f0aa6e0c5cd7e7eeeac7108af6feb5533e66807f5c3b15b281c96
0x3beb058de1a25dd24223fd9e1796df8589429ace	0x49e75c0df48ad09a0e20e8bbded07ee60dd8bc03	false	38	135858938	2025-05-15T13:44:13.000Z	0x7dedf41c3f7ed47ecccba57724fb997efbed2784b0b1b6e63d0b0544c8958fdf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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
0x0f08eef2c785aa5e7539684af04755dec1347b7c	0x1f7c1bc9ffc3bd33e4dde4b91432b79f934a3aba	false	1	135636148	2025-05-10T09:57:53.000Z	0x24dd23fd773f60e54c4ac3e5dd76c27cd183cbc7552954d4ec1224003bce3981
0x0f08eef2c785aa5e7539684af04755dec1347b7c	0xf57ea25b0817b1a20eae5b99fb869acae72fba76	false	139	141021750	2025-09-12T01:57:57.000Z	0x8d9360950618b4ec09cb01b9adcd3873bf8ca90647ffd5ee4ba2ae91a2bbe2ba
0x0f08eef2c785aa5e7539684af04755dec1347b7c	0x65d418d46a5a58b322cd2a695d22c40fefe974ff	false	108	135716927	2025-05-12T06:50:31.000Z	0x7fd95cf398a90d965ec548d90726309151f76d8dab01ab6f612285e9650f6448

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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_optimism.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	0x08a8bba83af849e3755771a4070aec87c9d6b86e	false	1099	139672214	260220863867953734	2025-08-11T20:13:25.000Z	0xd5cb5b79ab8a48e32db67f1c3dba74b48f0c2a5b084934c4058f7e368cb30110	[“23949135763699”,“722234024202”]	0xa4e78c91e7079c9a74e383e8e0af7b3db10817c8	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x49e75c0df48ad09a0e20e8bbded07ee60dd8bc03	false	204	139676736	652240868701267975721	2025-08-11T22:44:09.000Z	0x5e866cffcdbb31412bdaba46f5678eaafc953a74b85c67e5507e1541f07fdebc	[“0”,“0”,“62845040159569”]	0x04b86debeefdf5a179433fb2eeeaac828948230d	[“0”,“0”,“18675240796”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x49e75c0df48ad09a0e20e8bbded07ee60dd8bc03	false	319	139663130	652240716753090960178	2025-08-11T15:10:37.000Z	0x1ef1efdcba9636b945b9eaa8b35d3fdb4399a63e9ad7b015a7373028c1272c28	[“0”,“0”,“71910727416979”]	0x04b86debeefdf5a179433fb2eeeaac828948230d	[“0”,“0”,“21369090812”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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	0xe0d0b607539fdb647c4e87eff89588c6bb669c03	false	68	137549451	268982881151227542591	2025-06-23T16:54:39.000Z	0xe1e07ba8a034985edb37a80cfe1da62578c7c8c8123c1bc8a671e60ec39c365b	[“1151539888804307”,“1599976696412771”]	0x5f0828075b1a9038f4b53d75126706b119ea8260	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x49e75c0df48ad09a0e20e8bbded07ee60dd8bc03	false	52	140533607	279823116903915444744	2025-08-31T18:46:31.000Z	0xd495f180909b3df5d409ab002fba1d0fc900ff552307b518964e452f51008176	[“2372215268505449968”,“2539468242603614708”,“737308978252185885”]	0x475e80062da060826a54b3e29776ea55ff4d32e0	[“0”,“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x08a8bba83af849e3755771a4070aec87c9d6b86e	false	10	140533665	54791483552688403	2025-08-31T18:48:27.000Z	0x8e7661b551533a7b59d0d8d882039d8f0f33742a4c95c15cf692c455a3d86c64	[“5325746372921193562”,“572422148142173”]	0x475e80062da060826a54b3e29776ea55ff4d32e0	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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	0xcee3c0b23b0f505efe4d8e56869230e154c8bc3d	false	220	0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	137597301	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x5a7facb970d094b6c7ff1df0ea68d99e6e73cbff”,“tokenType”:1,“rateProvider”:“0xef42d000a3e85c4e71c57e2c6a1e600e86f5a91b”,“paysYieldFees”:true},{“token”:“0xbaf95bb30cdab3d5b7a11b67edef5631bd62be86”,“tokenType”:1,“rateProvider”:“0xf6655d9f5c2060ef4836a067e61a78891f8feb03”,“paysYieldFees”:true}]	2025-06-24T19:29:39.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x3797d7be2d5c9c03f1279cc15c81b47405b3c4d91251186ee343f6f153d41c3b	400000000000000	1867954497	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x05bd88d143a2eddf08b82632a358e9ed0e6eef9d	false	90	0x3beb058de1a25dd24223fd9e1796df8589429ace	134097712	{“hooksContract”:“0xf39ca6ede9bf7820a952b52f3c94af526bab9015”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0x4200000000000000000000000000000000000006”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xfe8b128ba8c78aabc59d4c64cee7ff28e9379921”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-04-04T19:16:41.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x7247297ff4b2501c43996e262a57ab72a54041fdee1d23730a9634d15e4d7e18	10000000000000000	1868210177	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x636dafb7db210fdf628b0eb114852be75ce8b052	false	12	0x268e2ee1413d768b6e2dc3f5a4ddc9ae03d9af42	142097551	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e”,“tokenType”:1,“rateProvider”:“0x2124372fb3f106a9753edf1c248eb1fd3fc72833”,“paysYieldFees”:true},{“token”:“0x94b008aa00579c1307b0ef2c499ad98a8ce58e58”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-10-06T23:37:59.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x8fb5634cbe67100432483207606b1d5acd21f1c5f8fd8d6502c5b9270d5d391f	1000000000000000	1867954497	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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	0x0854c8fa68cff2ac363b541f08f35181ca51b870	false	61	0x5bff88ca1442c2496f7e475e9e7786383bc070c0	2466778013000000000000	0x464b808c2c7e04b07e860fdf7a91870620246148	136369453	1037551488615386990	2025-05-27T09:21:23.000Z	2466778013000000000	0x23e0f2cb714714f21abc8aca59b87b4590fae8b13fc569616111bb5b29a5f4aa	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x0854c8fa68cff2ac363b541f08f35181ca51b870	false	78	0x464b808c2c7e04b07e860fdf7a91870620246148	48093760664179	0x5bff88ca1442c2496f7e475e9e7786383bc070c0	136370116	115950926300033948	2025-05-27T09:43:29.000Z	48093760664	0x4ba6763c381dd9a5909fb1a87d82cda226da52606a80abc3a7d1f70c3ab56752	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x0854c8fa68cff2ac363b541f08f35181ca51b870	false	127	0x464b808c2c7e04b07e860fdf7a91870620246148	48093760729622	0x5bff88ca1442c2496f7e475e9e7786383bc070c0	136370114	115951006885381921	2025-05-27T09:43:25.000Z	48093760729	0x5c7319c493e8b2261a1061815dbc30c7b8532c0dea6cae8ddd9ed581cc610d7d	1000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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	0x699a52566f3db5e055a0b7ea73a4d3bf042f1552	false	14	135171507	2025-04-29T15:49:51.000Z	0x02d78f03988d6c8a5a7b1b5338785e06ea65883c5a17fdba528db5d2014d0775	400000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x870c0af8a1af0b58b4b0bd31ce4fe72864ae45be	false	5	135447089	2025-05-06T00:55:55.000Z	0xc32db538b5df0d65b1b6c11e7e1f8786d01bea17c46d6180680dac4988b3dcc2	400000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x7e13f93446695252e3a7185ea4d7b1e272666297	false	93	139737360	2025-08-13T08:24:57.000Z	0x08e42451ff29496c54d0fac67cb0744034905eaaa19bffc0f845111f9f250166	3000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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	15	136593646	2025-06-01T13:54:29.000Z	945375468	0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	0x495f7f905762c37341022f725cc031abfba68a0d80b6e40d011dcc03afffb809	0x0000000000000000000000000006e4790000000000000000000000000007a498	1048307422
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	19	136596848	2025-06-01T15:41:13.000Z	7748442526	0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	0x81f45348498b40b0bba8863be143448017888a1c5160400cfe6bcbd94413ce88	0x0000000000000000000000000006e47b0000000000000000000000000007a49e	8592141845
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	14	136596799	2025-06-01T15:39:35.000Z	12371471120	0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	0x2315df356ee39b5374a4762c96588436e4ce23a061e7dd9cc3dde3fa3777f5c4	0x0000000000000000000000000006e47a0000000000000000000000000007a49d	13718553671

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_optimism.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	108	139135395	2025-07-30T09:59:27.000Z	1069105640064434	0xbaf95bb30cdab3d5b7a11b67edef5631bd62be86	0x573728f1315ccf42fd861cdd248a245f3fc4bfeece2422fce9b7d41540c0f82b	0x0000000000000000000000000007a1b80000000000000000000000000007a359	1070000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	70	139135407	2025-07-30T09:59:51.000Z	1958375938757681	0x8e6a81b9d541a0cea090818b62c4b2de7f2a2cf7	0x5c161af913f03929a819b1c99b06c2009361cb1d20e396a75c1c18a49df46901	0x0000000000000000000000000007a2220000000000000000000000000007a31a	1959336107479437
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	84	139135407	2025-07-30T09:59:51.000Z	1123095044950480	0xbaf95bb30cdab3d5b7a11b67edef5631bd62be86	0x5c161af913f03929a819b1c99b06c2009361cb1d20e396a75c1c18a49df46901	0x0000000000000000000000000007a1b80000000000000000000000000007a35b	1124034569710969

Example Query

Query with partition filter

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