balancer_v3_base

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
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0xacba78d745faae7751c09489d5f15a26eb27f1ad	false	107	25653429	2025-01-28T20:30:05.000Z	0x80aaa0aecb9829d86b968cefc1861ec667a028d3ebeefe274d65e1ac3eba79eb
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0xa3fe227d63181963eafbef659152b071f51ea814	false	213	26927722	2025-02-27T08:26:31.000Z	0x993794e77506750bd55f1c2d184bdadfbf8a258b70511291a02fe345214f8ee1
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0x66d7b6ead3d1bc1a7d54f4812f33d3b276aa4b68	false	822	25994350	2025-02-05T17:54:07.000Z	0x34c1f22f60191b2c6e62ddf6dd3063b938b6f9bf4f97f6552eb8827bd5148598

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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
0xc49ca921c4cd1117162eaeec0ee969649997950c	0xce62d2ce8e3500af88d3a780249529842e471160	false	219	33643956	2025-08-01T19:40:59.000Z	0x356fe1af4f2719413f098c359c2307fe927e7c39fd080297ee4bcef5ea97fe9a
0xc49ca921c4cd1117162eaeec0ee969649997950c	0xe3a85e913f967406823cde9c390ae7bad9496367	false	85	31073075	2025-06-03T07:24:57.000Z	0xfae6c729972781dc31535ae4dddbf3899231c803ab30f96c5c19d7c86432398f
0xc49ca921c4cd1117162eaeec0ee969649997950c	0xb2500855889fc728966a5e93bada0a45b961f719	false	54	35890843	2025-09-22T19:57:13.000Z	0xec3a6eb4508229a8454849a6c45ba44bb97d4e917cd5550efd2c892397c8b2fb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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
0x4fb47126fa83a8734991e41b942ac29a3266c968	0x97df848793aae72ee0d99004b4daebc6dbf4c589	false	118	30441524	2025-05-19T16:33:15.000Z	0xd835dfa5187b383dc491be0ccefa10eb34f2c5d2cf72b1efff4e6d7c1acaa983
0x4fb47126fa83a8734991e41b942ac29a3266c968	0x2292f56597a79f7cd75e570136b26f88a91052f8	false	143	30441887	2025-05-19T16:45:21.000Z	0x79559a91024617a7e927af1993807e99803cd474dbfbc8d064fb7958e8e7a3a8
0x4fb47126fa83a8734991e41b942ac29a3266c968	0xf8324fc157965f2d288f1ebc904beddd40a0b166	false	649	32995468	2025-07-17T19:24:43.000Z	0xe745394051e46b46f8914094c3dbe551f74af7a90a5c14a40dbffdb0e119935d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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
0x8e3feaab11b7b351e3ea1e01247ab6ccc847dd52	0x606979a49ab85efbc19544a294c36aae85b31180	false	1347	29846691	2025-05-05T22:05:29.000Z	0x5a093eda3886d6a4cd1db4b1b1d604d0eb401de2e2f4359388d5a69a8ccc3822
0x8e3feaab11b7b351e3ea1e01247ab6ccc847dd52	0xfbcb0e67d522faac3dbad0d0706bbe241ebcf73d	false	431	29845052	2025-05-05T21:10:51.000Z	0x8f74e60cf506084da53bae1098c1f929bc2c6095118b78eb8d0c818a1f671fbb
0x8e3feaab11b7b351e3ea1e01247ab6ccc847dd52	0xe5556b41256d7efb2f0a17011ef8ab507a352141	false	53	29847147	2025-05-05T22:20:41.000Z	0x033534f6e579b8626014280b7197688f8b033ef56bc03e349a130f44b4f1511b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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
0x5cf4928a3205728bd12830e1840f7db85c62a4b9	0x5d00ca76958c4379d70c5d8b94b12969c70f0f0c	false	209	36970227	2025-10-17T19:36:41.000Z	0xf001ed772a793ff1ef997592337e63767354f980861171d906af528a1957f9db
0x5cf4928a3205728bd12830e1840f7db85c62a4b9	0x1282030e352538aef4fee63747e880863af82a13	false	708	36947121	2025-10-17T06:46:29.000Z	0xa4d71551670f91ef454b43751a0cb118e20ce8da2dc9a096c4fc6564592c69e0
0x5cf4928a3205728bd12830e1840f7db85c62a4b9	0xc7f8e86eccf42c6d57cc847c249445722a34d292	false	130	36968224	2025-10-17T18:29:55.000Z	0x0f2d9e6f9a6f111a839f38a6c1661890f5a03505fabacc4c44566a4e06bd30d2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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_base.Vault_AuthorizerChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_LiquidityAdded_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
`in_amountsAddedRaw`	`ARRAY<STRING>`	Array of token amounts added to the pool during the liquidity addition operation. Numeric string representation of quantities in smallest denomination, ordered to match the pool’s token array.
`in_swapFeeAmountsRaw`	`ARRAY<STRING>`	Array of swap fee amounts charged on the liquidity operation for each token in the pool. Numeric string representation of fee quantities in smallest denomination, ordered to match the pool’s token array.

Sample Data

address	in_kind	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsAddedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x4147d8aeecb75bc9f5c973c3b73d2dfc4dcce131	false	351	26697538	353723578384162905254848	2025-02-22T00:33:43.000Z	0x9971ed76eba48c803c08f4b1173c83788a3f693e1625e753f84a063d770cc632	[“0”,“7735944745502953808577”]	0x857dc07ac7658544c486bba9602b4f79c5b6d82b	[“0”,“151140772243737027”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x4147d8aeecb75bc9f5c973c3b73d2dfc4dcce131	false	76	26707824	354729017284631556185134	2025-02-22T06:16:35.000Z	0x0bbe6d1098cd2e776c54a7921621a30ad29a209d67b878562ffcdcc57b329c70	[“963931014858606353859”,“996505820925647877626”]	0xe6f43a9dc80d833decf722df5d0a2c7e6013ef07	[“11516579915594883”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	1	0x4147d8aeecb75bc9f5c973c3b73d2dfc4dcce131	false	555	26724950	357740067557565365257706	2025-02-22T15:47:27.000Z	0xd00dc1744cbcbb4ef177ef13c3362db0db7c746ed7eeaee1088de6bdb07117a8	[“0”,“3008719144383899028837”]	0xbc7642d71a89ea3caccb465abbf89cfebd4bcc6f	[“0”,“56992204202125641”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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	0x1a48f20a34e523394dea029d8854634b9fe43ec2	false	95	29615730	16380500348222778125	2025-04-30T13:46:47.000Z	0x69e54e118ca50c840bb5242608f0c5efacf82d0973efd5b78160c5ea47d8326a	[“100878235006607033”,“220144029”]	0xe2796eef9601daa61124e63914d3af62c16a33ee	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x1a48f20a34e523394dea029d8854634b9fe43ec2	false	28	29620153	14199210297042706050	2025-04-30T16:14:13.000Z	0xa6c0cae89c7114b911da8eb346dc5e141d451eea290b94d5a7a0e92025d752d7	[“133227044323865291”,“300133879”]	0x46792084f2fa64244ec3ab3e9f992e01dbfb023d	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4147d8aeecb75bc9f5c973c3b73d2dfc4dcce131	false	302	29611412	153844040193091021933753	2025-04-30T11:22:51.000Z	0x357ced437adf0d3bcf6105e39efc85c7d0012822ee831404b34632e8d30ca814	[“6848316510444562026”,“7841665695691214265”]	0x6a8b92caa27d471b6aa12f4211564994b72266fe	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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	0x617ed411439681363279feeafa0335576c181344	false	190	0x8e3feaab11b7b351e3ea1e01247ab6ccc847dd52	33497783	{“hooksContract”:“0xdb8d758bcb971e482b2c45f7f8a7740283a1bd3a”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0x080d43c2164afdbc3712422ce78ab902ccab5ca1”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-07-29T10:28:33.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0932220dc2b8305761573ac0d48dede8c4876ccc”,“swapFeeManager”:“0x0932220dc2b8305761573ac0d48dede8c4876ccc”}	0x02b2bff93c285e8e6e1e0183170d8ac899412f67f47678699a5b1f9a55bd96f0	3000000000000000	1868210379	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x5b2e2cbee37480848d742c03eb743450529bb1ba	false	209	0x5f6848976c2914403b425f18b589a65772f082e3	33497892	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x080d43c2164afdbc3712422ce78ab902ccab5ca1”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-07-29T10:32:11.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0932220dc2b8305761573ac0d48dede8c4876ccc”}	0x49aa62059ce5ce0098a25a551e9dfc37fe58d885098b6b1f7053ebe1e0cf7a16	3000000000000000	1866386045	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:true,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xe03fd3e33a88fbf26808522fffaa3b17bdf599dd	false	348	0x5cf4928a3205728bd12830e1840f7db85c62a4b9	33508024	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x4200000000000000000000000000000000000006”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0x63706e401c06ac8513145b7687a14804d17f814b”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-07-29T16:09:55.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0xec576a26335de1c360d2fc9a68cba6ba37af4a13”}	0xa8f71fb026c7b008bb6d56321fbadacbb249446665bd057d9f3a1a7bc00b43ba	3000000000000000	1861900177	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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	0xb9b667df28acc676b35b1471d0e83133242fdf9b	false	191	0x0000000f2eb9f69274678c76222b35eec7588a65	29600138	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	33529679	7487619223121351	2025-07-30T04:11:45.000Z	52188	0x18a50ee723f4d3d6efb65beed1a195649169668c3f117db75634ae287cf8fb1e	1763112776638419
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x7b4c560f33a71a9f7a500af3c4c65b46fbbafdb7	false	1700	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	4109823985304712	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	33542513	16582249	2025-07-30T11:19:33.000Z	410982398530	0x9ffe0b98ce7f47c80eeea9a806bcc031fb9286734b8c77324ba0dd2467747172	100000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x7b4c560f33a71a9f7a500af3c4c65b46fbbafdb7	false	259	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	3308267478825152	0x4200000000000000000000000000000000000006	33538375	3547722881821414	2025-07-30T09:01:37.000Z	330826747883	0x080797e3691f1498913fc6a0a68020ee5c6dd278ccde2a58da01d54b966989c6	100000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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	0x00000d01ba5fa829d672c385e8969644ceeed43e	false	90	36536612	2025-10-07T18:42:51.000Z	0xc5f6df02f3baace8f85441a3cae25aee213850071cd36ebbd65764cd4e691bce	1000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x074a6485532e78fd7144dcb330ab45b6d808daa5	false	327	36523170	2025-10-07T11:14:47.000Z	0x3a871b5077895ce43e06b261c529e05b1636067ac8b9ae317a3efc2e2ad71bd7	1000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xbc9da01314e143d3dcf0caa9b57c33bb0a0f0e1c	false	138	36515298	2025-10-07T06:52:23.000Z	0xa2c12626e1275fb86391e37200c3713a78cd781e9369771cec3cb3c8fc9dc5d0	1000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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	16	37036825	2025-10-19T08:36:37.000Z	509249637809973	0x0830820d1a9aa1554364752d6d8f55c836871b74	0xeb5ab1e6043766f24b6d86e28aed11ca096fdeaae5375c4085dfad5304611bb6	0x00000000000000000022c8bcd253386a000000000000000000245cbe6707ef07	510779193200940
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	20	37028443	2025-10-19T03:57:13.000Z	7569851699948711	0x0830820d1a9aa1554364752d6d8f55c836871b74	0xfa6da38f49721168cdd79d7543471b8ce5e6e37deabf5377775b15ae6ba3ae9c	0x0000000000000000002384cdc65af75b00000000000000000023a01cd8d1e605	7592586616699655
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	25	37022161	2025-10-19T00:27:49.000Z	727766430179695	0x0830820d1a9aa1554364752d6d8f55c836871b74	0xaa86ae6def34c1cb1c2cdff6cd0586eb005044f18b4c57231d8401ac5cf19531	0x00000000000000000037960db90bae720000000000000000000f7f6f2de9012b	729952060365321

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_base.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	81	28337593	2025-03-31T23:42:13.000Z	5000353941098190	0x0830820d1a9aa1554364752d6d8f55c836871b74	0x11272e3f5df26f0a188bf93397a0ab99224747fb8431adb8e8be002e9b11e753	0x00000000000000000011c2e64bfe4100000000000000000000356dde8c6ea83f	5013321312845813
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	569	28337492	2025-03-31T23:38:51.000Z	5833746350980413	0x0830820d1a9aa1554364752d6d8f55c836871b74	0xa57f6c05394ba617dbc1e7abc55a5b53b6ecf2d644dcc1a561ce876b8d22007d	0x0000000000000000000eccef0324c77a0000000000000000003865cd06ddf161	5848874903091225
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	384	28333025	2025-03-31T21:09:57.000Z	2648145938585060732	0x0830820d1a9aa1554364752d6d8f55c836871b74	0x3b7d14b1c3054b85fc91f957619af6537adf14a46433a2ee7285e56c474582dd	0x0000000000000000002386b25de40306000000000000000000239e4747db0549	2655012332445563960

Example Query

Query with partition filter

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