balancer_v3_avalanche

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
0xeaedc32a51c510d35ebc11088fd5ff2b47aacf2e	0xd254fa41bfc7855c4966771f96bbd90a59e2c866	false	1	69612710	2025-10-01T20:30:55.000Z	0xe5ac05ad1186054628d419846603af5c5c79754a6d3db463324b180ac0e1582e
0xeaedc32a51c510d35ebc11088fd5ff2b47aacf2e	0x5ade2c2e25ccc0fdebe913fcf137e523a3073d64	false	1	69605517	2025-10-01T17:19:13.000Z	0x242fc6ae37a9731185f175ad116b599d2bb8f3b39fde5d724550036a64dcc869
0xeaedc32a51c510d35ebc11088fd5ff2b47aacf2e	0xe29f281b44117ad7996893fa0d5186a19168538a	false	4	69606465	2025-10-01T17:43:08.000Z	0xaa4bd51c3a06a02491b27b57eb0aed970c12c6cb51287942691331aea8b4a817

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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
0x18cc3c68a5e64b40c846aa6e45312cbcbb94f71b	0x4c6c0b3f11577aef4448b45838c7d7d379e9cc69	false	2	62020996	2025-05-14T14:09:00.000Z	0x68684ef766347faf398309e27285e37c4d5ec315c21310e45af55bf6ecd122f3
0x18cc3c68a5e64b40c846aa6e45312cbcbb94f71b	0xdd4784800dc8129824df1bcf2a7f2d92870a4bb4	false	13	69785294	2025-10-05T02:24:48.000Z	0xf42fb2c55c63d2524b287fb90e6a1cc9cd5417fb93e6b39f31091e5e4b46a20d
0x18cc3c68a5e64b40c846aa6e45312cbcbb94f71b	0x7ac301ddd7b85bbbe82daa0ba4f1b6e06d5e1182	false	60	69815001	2025-10-05T15:19:43.000Z	0x420afe3dc7723e6536bb827c13dcdc754b00f212d2e46822634147fb39862620

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	block_number	block_timestamp	transaction_hash
0xd961e30156c2e0d0d925a0de45f931cb7815e970	0x06ea9acf1ac9a01e25670e483e42cb822e286c85	false	68389621	2025-09-08T01:54:31.000Z	0x3efc2bb20bacc2d102f7382cdfd26c1f420b3019bbd0b350e1d5ee93011b8180
0xd961e30156c2e0d0d925a0de45f931cb7815e970	0x1a52b1cd1afcd1cbf90f16cbdf99aabfec76f2e6	false	68389811	2025-09-08T02:00:12.000Z	0x0c05ea7d3448a78173f7806518f764c1e5177909bac329b5e2671f2560834ab4
0xd961e30156c2e0d0d925a0de45f931cb7815e970	0x6ecdab151d79fc71c17fe8863ee15ede31982353	false	68389907	2025-09-08T02:02:30.000Z	0x05123b0ac5b9f7351747908b4ba8eaedd85016298a7b4a205efe454b1552e420

Example Query

Query with partition filter

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

Vault_LiquidityAdded_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsAddedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x1c39ebe0ee53b52ab24d3945e9cde9e6c09d0851	false	176	65520890	19558136735365656229	2025-07-16T00:40:22.000Z	0x481f5452f160531138e71c0d119cf9ab853d42db1e7042e1ce5fabc2485c1643	[“209250687780144269”,“191262141856408”]	0x9e688cc1e56243e95dac3a9ed085a6a27404d66c	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x58374fff35d1f3023bbfc646fb9ecd2b180ca0b0	false	14	65549389	1210142883934946143	2025-07-16T12:10:23.000Z	0x36b665858a07a9abd22cb512a9f48ac9272550aee1fb884b0bc01accbe88434f	[“43341”,“2030187437208260262”]	0x0c9eefa16408122412e80eb7ab1099d18d21603e	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x58374fff35d1f3023bbfc646fb9ecd2b180ca0b0	false	142	65529844	1209638640992658279	2025-07-16T04:10:39.000Z	0xe010b80cc6695c435552b029606a2ef50a507d2d9abf5ed55d62f2b98beb97bb	[“132”,“6287124603299539”]	0x3514c7f00da4d35958dcc73a5c42b506d3cd4f0a	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	0xfcec3c8d86329defb548202fe1b86ff2188603a8	false	161	69321769	526693317505720680459043	2025-09-26T09:48:00.000Z	0xb2f8e416a179d2b4538976effe12c43c6fae22ea7b92a9ef7f11e65423a309c2	[“761036666”,“2092159440325859744380”,“1415212642”]	0x146eb542c97b8f8bc0bedaceed1a749d54e8f1ef	[“0”,“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x22715161201922af61f4ca22e979ef0c6c20be13	false	31	69330506	2571270059011626818361901	2025-09-26T13:36:17.000Z	0x9a7ff18859bb8f3e012ec695b621e43f9b2eb2abbe29dfc868d21033e077daa8	[“1572884424654363076433”,“1088646790”]	0x97692e7106427c259a5b78f75ff68ff5152cf4ca	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x31ae873544658654ce767bde179fd1bbcb84850b	false	74	69315699	636149508214780112232683	2025-09-26T06:55:10.000Z	0xb8a1682e835ebb4dd15e8b6767b01d56ef7125875b47f67061d373bd4cacdda8	[“2741865887”,“819414978”,“1180883436”]	0xff9f193b38ad33a1bdb75a11ef993c7096baa61c	[“0”,“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	0xa6a20c2786bb7f79f3f4fd0a958ea1ab5658ddde	false	15	0x18cc3c68a5e64b40c846aa6e45312cbcbb94f71b	64397420	{“hooksContract”:“0x86705ee19c0509ff68f1118c55ee2ebde383d122”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0x51b47b3013863c52ca28d603de3c2d7a5fef50b9”,“tokenType”:1,“rateProvider”:“0x121ce3929a4b7162a84345c9b6296439a82a841c”,“paysYieldFees”:true},{“token”:“0xdfd2b2437a94108323045c282ff1916de5ac6af7”,“tokenType”:1,“rateProvider”:“0x64a721e8bae80983d00f96ccfa8ed95ec9352255”,“paysYieldFees”:true}]	2025-06-24T14:49:36.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0xf32d11d078ddebac3b333225b9a0650e73d9caa5abf6226f7fc50dd085b847e4	100000000000000	1868631574	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xf6cf8b90f7e7ad9e5563773ec295791be43d8d8f	false	8	0xd961e30156c2e0d0d925a0de45f931cb7815e970	63824950	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x91a1c5a6001e6aa628f49094658c65a19794d7f6”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-06-14T04:54:24.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0xbb0992a43f7b62e047a09c6d51fab1973d04de40”,“swapFeeManager”:“0xbb0992a43f7b62e047a09c6d51fab1973d04de40”}	0x31cdd675a08ea8923c76c1da1e4898a6a6dc6c85f274e45d0d61ea871fcb70a7	100000000000000000	1868630982	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x954362fb93839f24b3de794e62d7efb99ba34d5b	false	24	0xd961e30156c2e0d0d925a0de45f931cb7815e970	63824364	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x1010e0c6e531be777b2b5432eb518c0e39b801df”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-06-14T04:39:37.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0xbb0992a43f7b62e047a09c6d51fab1973d04de40”,“swapFeeManager”:“0xbb0992a43f7b62e047a09c6d51fab1973d04de40”}	0x8bcac2b27b5af4bea185ceaec0c0c608dc97fc5b8be210ed5fd98582f08b5420	50000000000000000	1868630982	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	0x5f7d916d90453915120efa46106a886f351e6c14	false	9	0x152b9d0fdc40c096757f570a51e494bd4b943e50	1241	0x2cd3cdb3bd68eea0d3be81da707bc0c8743d7335	65217148	1240	2025-07-10T05:39:03.000Z	0	0xa0401e296c47da0f12ccd5623988c762d031297df6ef6b33dd052559a5b289f3	100000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x5f7d916d90453915120efa46106a886f351e6c14	false	14	0x152b9d0fdc40c096757f570a51e494bd4b943e50	3911	0x2cd3cdb3bd68eea0d3be81da707bc0c8743d7335	65217102	3910	2025-07-10T05:37:51.000Z	0	0x68e7624f5aba5d92329f67f9c53b3b88ba0abee4104e91150a6426b0f1341586	100000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xc07f45ee39f3fa2abaeb2b3309543e69129e3c21	false	26	0x2137568666f12fc5a026f5430ae7194f1c1362ab	491041627	0x39de0f00189306062d79edec6dca5bb6bfd108f9	65221219	491041033	2025-07-10T07:42:57.000Z	19641	0xbcf59bd7ea4e3f92faa2168a3531c74864e88dc6022429f4f0895973de278c1b	40000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	0x95e1a718f23ad77a12ee455b12f9971bfa9f539c	false	10	69993288	2025-10-08T21:59:51.000Z	0xaf04f8d7d3c09c031824e2a84c72da8fb8e9d37356a2b1ba52a3216d80eb8d72	7000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xb109a472b1c59fadce6b3691eaa79269d4bba37c	false	11	62819164	2025-05-27T16:57:42.000Z	0x5787f02858bf9108445bb1aba614f2ac7b893eec1bcb49599a07642df08ec9e6	50000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x08a00fb3409c6f3a68d56434ac4a63580409193c	false	28	66424243	2025-08-02T02:05:08.000Z	0xc7a7d4109fc72dfbf458895ed56857d42405f973785470e43bac98a5fb54a5d0	10000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	70790478	2025-10-23T16:45:44.000Z	12333	0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	0x0117cf223dc6fff7ab07001d8dfc8eb48b99df8462665bb95a67931414edeefe	0x00000000000000000000000000016ae800000000000000000000000000027c41	12375
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	15	70765661	2025-10-23T05:22:19.000Z	13966	0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	0x6211ee0f04dfc299770d3f8d82a68ceb1be8fe0a7f876210fcfb8191741f8add	0x00000000000000000000000000018cb800000000000000000000000000025901	14014
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	15	70789667	2025-10-23T16:22:54.000Z	14862	0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	0x0cfeca7afcdb36249f57e26a9b6f82e0f33140b9ef5a6d61202314ded4ed1db7	0x0000000000000000000000000002fd780000000000000000000000000000e82a	14913

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_avalanche.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	12	60874411	2025-04-24T18:38:35.000Z	34401537	0x2137568666f12fc5a026f5430ae7194f1c1362ab	0xacb0da5c1a74b06d0a0c787875e1cad2a7ecae0dc4fcb1e0b151aa9dbf2de982	0x0000000000000000000000000020effa0000000000000000000000000021060d	34491565
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	14	60868067	2025-04-24T16:14:59.000Z	1033057	0x2137568666f12fc5a026f5430ae7194f1c1362ab	0x6cd06f409d035012b6e5463849953ae5ccf590fb75286dc904efbb84c98a88a5	0x00000000000000000000000000321cad000000000000000000000000000fcdde	1035742
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	15	60874287	2025-04-24T18:35:44.000Z	13187205072	0x2137568666f12fc5a026f5430ae7194f1c1362ab	0x1c41c936a86f5a6701d5a8e7821eafe5294235a662e13b60a14efe433f714cd8	0x0000000000000000000000000020effa0000000000000000000000000021060b	13221709966

Example Query

Query with partition filter

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