balancer_v3_arbitrum

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
0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	0x187af649a92b69295c7345bea0b6dda5d22797f3	false	1	300573755	2025-01-29T17:56:30.000Z	0x1451f431e6dd72c55f4833b2c6d057f3f43721709b73535991bbc75d2e50e21e
0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	0x3e862ddd978fef9dc63318c490dd2ab3b7bb76e3	false	11	300568928	2025-01-29T17:36:06.000Z	0x5a6f34a226963271fe828ecc6f2ea30d49b3f6fd7bdb8adca795db0bb5f0f17e
0xeb1eeabf0126d813589c3d2cfeffe410d9ae3863	0x9c5f17d96ca66748b459788148b7357220f2d100	false	7	300910276	2025-01-30T17:30:18.000Z	0xc6a26e9226d3f5e796191a2718ebb06e7a0a800f43d9aa554d6487157775fbf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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
0x44d33798dddcdabc93fe6a40c80588033dc502d3	0x61aa08aebaa140044c93b2e5324146bf98b4d76c	false	16	327289716	2025-04-17T11:01:05.000Z	0x2f9db311e4c3d7da878b30994609eb06bf1a16a469d0bee78681cc54cc4dd79e
0x44d33798dddcdabc93fe6a40c80588033dc502d3	0xdb3b0e8968bada17f4532672bca0a7f6d544eb1f	false	1	347762828	2025-06-15T23:22:05.000Z	0x69fd085a75684facc10b0e8b4ec788d69cb6d31e474e5fb42b9eeb3cea84dd71
0x44d33798dddcdabc93fe6a40c80588033dc502d3	0x975facaddba3b92326cc9bcba01463051b41afac	false	1	347678102	2025-06-15T17:26:52.000Z	0xdbb2e3237e889a88698ee69e1e9c8a26b2170af76e5f0d6d8ed2ab47db8e8ea7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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
0x86e67e115f96df37239e0479441303de0de7bc2b	0xb1b8b406eeebbb636fdbb20e6732c117d828363c	false	1	315697096	2025-03-14T19:16:06.000Z	0x3e9218a440c8187007c750f7e98767ab1b415568687565ea0239175d9f1ffe1f
0x86e67e115f96df37239e0479441303de0de7bc2b	0x1c00eeed6d206c1b251da99bdd63187704bc89a9	false	6	315580844	2025-03-14T11:10:37.000Z	0xfd66bba0393067ee246ba9352dde5c1240ccf984920af8e20d4dd8dac1700ace
0x86e67e115f96df37239e0479441303de0de7bc2b	0x19b001e6bc2d89154c18e2216eec5c8c6047b6d8	false	1	305020810	2025-02-11T17:39:51.000Z	0x2929a5efcb1dd21c114026a9b2fbb354cd74c79d72f39251a59a2e65941fdf35

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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
0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	0x21f132ade35684b230af974b80b5bfd2678ebd80	false	29	332213273	2025-05-01T18:22:21.000Z	0x021cd71312195bcfe5036c773cd3b54ddea279c8c1ff30841a7795627bc40487
0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	0xe07de33d1bac6505b0e4dd0b62fcd42fede69b15	false	14	339737364	2025-05-23T15:53:10.000Z	0xa7dde7476c6a20fcafaac251f809127c9db0c39a54e1d37438373867dd3e724e
0x201efd508c8dfe9de1a13c2452863a78cb2a86cc	0xe8788e22e04d82e0a2b0dae6dfa80b9627060597	false	7	322937883	2025-04-04T19:27:56.000Z	0x8901f596ff34de98bb67ff5c4d76160d675f609c28a4d4b460e7b4c4b64799fb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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
0xd961e30156c2e0d0d925a0de45f931cb7815e970	0xc72a124b81ef2d00704a5936dd46528f75bfbc0d	false	0	386038120	2025-10-04T16:34:48.000Z	0x2e137c8f1eafd047ab6800212ebe58f5c3636f2995c91e35e886f784315f91ec
0xd961e30156c2e0d0d925a0de45f931cb7815e970	0xb4a924255af72c1764a9e659b0ebdd5ffba717a1	false	3	350726224	2025-06-24T13:43:39.000Z	0x9713b3a1fce74128082ea7be95ac4f1805d18722577fa826385dd73bdba16d5b
0xd961e30156c2e0d0d925a0de45f931cb7815e970	0xffe1ba3811010cc8fb94dd0d55d40973c507467b	false	0	369485094	2025-08-17T20:16:29.000Z	0x55290d9df04511594c75bdce473a2d7e65c86f23741d3f19ec33f9a05a9e3a35

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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_arbitrum.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	0x2ece6781bace5e37386adef7a3d45d0bb05f8fce	false	8	321850357	346540147842596451073	2025-04-01T15:46:10.000Z	0xc1fd8017b30b2566ff18810d664c255d58c64269aa0901fc23996389b7eae304	[“2606458474827894073”,“3324964073022442581”]	0x1b8bdf6114ef2f98c3514a52522a18074b7507dc	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xa0e5e7728e026bde02810d255a6b94a9aa47b5f9	false	5	321740594	649315548224330044	2025-04-01T08:09:01.000Z	0xac9875f9cc28194007d79c8bc778f8dccca5863ce5385d11f4d0fd6845c889ef	[“3491314”,“3163675339”]	0x7d117df1ea4191f2da39710c5afd3f636342dc27	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xa0e5e7728e026bde02810d255a6b94a9aa47b5f9	false	52	321767266	649477266132381951	2025-04-01T10:00:12.000Z	0x2eaaed0aaee920e6591f7f60b7943cb0e4b645357a0be104edc7f3170601b61a	[“3314957”,“3352920356”]	0x7d117df1ea4191f2da39710c5afd3f636342dc27	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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	0x19b001e6bc2d89154c18e2216eec5c8c6047b6d8	false	24	356648168	4662422141397278644605034	2025-07-11T17:47:46.000Z	0xc811d477cf6fb75b58a99db709da1ce9e3bb2e1a944df9befb28547e11688419	[“1246683658”,“1141042078”,“2166981453202619900600”]	0xde040b511b9dc961f8b0804b7b412e23729a31a2	[“0”,“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x19b001e6bc2d89154c18e2216eec5c8c6047b6d8	false	22	356591369	4667416588658560463389985	2025-07-11T13:51:26.000Z	0x453decf9c7740b0bd88bbeb29b42e47b1f101551046d21e8615f34db94368c4f	[“51067111329”,“46712303487”,“88680317083114316364219”]	0x923dce3f8faaa1435e72cd36a978cea95169fef4	[“0”,“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x19b001e6bc2d89154c18e2216eec5c8c6047b6d8	false	6	356420378	4874186812464614702067800	2025-07-11T01:59:42.000Z	0x6d2fc6a60fea8be231714f326a3ae357475dfd38799ae5fd083c755c38b8dcf4	[“41776701296”,“38247768721”,“72004425230869609956949”]	0x403d37c861fb54b8f37a3a1870abce335954840b	[“0”,“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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	0x02d592df591aa7a8884b4ec8de91e869c234ad1d	false	32	0x88ed12a90142fdbfe2a28f7d5b48927254c7e760	338691263	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x4ce13a79f45c1be00bdabd38b764ac28c082704e”,“tokenType”:1,“rateProvider”:“0xe3df105db16282e5ce5cda2d15391b04a408bccf”,“paysYieldFees”:true},{“token”:“0xa6d12574efb239fc1d2099732bd8b5dc6306897f”,“tokenType”:1,“rateProvider”:“0xc6b25ba4c028cb238ab7cac7a2ee59ed4f1e96d4”,“paysYieldFees”:true}]	2025-05-20T15:01:16.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x78d8fc685cf1f6b873b0188d5660499f48ecafa52f91335e32ca31ce9693fac5	2000000000000000	1866385973	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:true,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xe8a024832133c2875b8d3cd478fe595b8287ff3b	false	8	0x88ed12a90142fdbfe2a28f7d5b48927254c7e760	338502278	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false}]	2025-05-20T01:51:18.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x34ba4ccc96786b25c480eeca1a828776dab493fc3e7e30932aa99c0419f9adda	500000000000000	1866385973	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:true,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4a2a9ca7b9096755aef69828aef82e3378d79b19	false	6	0x86e67e115f96df37239e0479441303de0de7bc2b	314956491	{“hooksContract”:“0x0fa0f9990d7969a7ae6f9961d663e4a201ed6417”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:true,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:true,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:true}	[{“token”:“0x4ce13a79f45c1be00bdabd38b764ac28c082704e”,“tokenType”:1,“rateProvider”:“0xe3df105db16282e5ce5cda2d15391b04a408bccf”,“paysYieldFees”:true},{“token”:“0x7f6501d3b98ee91f9b9535e4b0ac710fb0f9e0bc”,“tokenType”:1,“rateProvider”:“0xdaff80737b23a6e40f77aa28957a10c9af5dff45”,“paysYieldFees”:true}]	2025-03-12T15:39:37.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x0000000000000000000000000000000000000000”}	0x4b678df598b5c5f6bfd34b919677802d78b088a3b39f12ed2d99562cfd62cffc	1000000000000000	1863303960	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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	0x4b34282cd01716e5ba9f4c365b5bdd15338d3d9b	false	37	0xf97f4df75117a78c1a5a0dbb814af92458539fb4	109428406437823990	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	369888861	2147959232398752576	2025-08-19T00:17:10.000Z	328285219313472	0x67e822e9a39e8cade87d9dcccf40baa566517e7f7f255fedac9e71afcec3f39d	3000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xa978cc348a0b5de8bd564a1d8fe437787fd12664	false	53	0x7f6501d3b98ee91f9b9535e4b0ac710fb0f9e0bc	4990230955	0x0c06ccf38114ddfc35e07427b9424adcca9f44f8	370106142	4867964876453119250209	2025-08-19T15:21:09.000Z	9980461	0xb998db90be11a39351cdb03aed8c812fa26964f421c25ae60eec1ff68865d8f6	2000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xa978cc348a0b5de8bd564a1d8fe437787fd12664	false	14	0x7f6501d3b98ee91f9b9535e4b0ac710fb0f9e0bc	1050726239	0x0c06ccf38114ddfc35e07427b9424adcca9f44f8	370084521	1024614805577026031330	2025-08-19T13:51:16.000Z	2101452	0x0d0d4a3a814a32b67feab2c14cf4a63f99da01a1acd4f316baf23d49c33b8143	2000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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	0xd0737d320360d1817f65ebe2176684009430d1a7	false	5	362892729	2025-07-29T18:54:52.000Z	0xa1fbe55fda43fc34e6d424a1d6bec468484089969caa72348a7b29a5b0219f63	3000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x7481915264ba2601d222404a9960156d7b550cd1	false	8	362851724	2025-07-29T16:04:15.000Z	0xb11fe1ee5bbae2e8dc346f880e7a32cbd35984f19d0ec871e8b7b1e157a39e49	3000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0xeac2102314601e5822392d94477ca37bf6523a19	false	8	362890651	2025-07-29T18:46:13.000Z	0xf2cfabfe6f9452aea273b97d2ae6ecfab78e0466e3fd99a33bcd8df722b3b8e0	3000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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	6	376048508	2025-09-05T19:27:23.000Z	59514840873860	0x4ce13a79f45c1be00bdabd38b764ac28c082704e	0x5cea14204b94694613735885842243d9db42abe7ec50a43d4178a9240264ff6d	0x00000000000000000028951d4fb1974a0000000000000000001cd05ce48eca6d	62493974092065
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	7	376094385	2025-09-05T22:38:31.000Z	36524233250535	0x4ce13a79f45c1be00bdabd38b764ac28c082704e	0x51df1a3166d8f71b44904f78f7e9212fbd18115ad1b63c518b10d4525d4fa4eb	0x0000000000000000001cfe0817585b1900000000000000000028fbfa37553c04	38352815571246
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	7	375920075	2025-09-05T10:33:04.000Z	53503428455551	0x4ce13a79f45c1be00bdabd38b764ac28c082704e	0x570b495b360d6de490594f998a31bfd7599015ca2b28cd7c25e83affe14b73be	0x0000000000000000002233afa39948b9000000000000000000238394c973a2b5	56180450877866

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v3_arbitrum.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	17	317189435	2025-03-19T03:20:45.000Z	1470186321607085760	0x4ce13a79f45c1be00bdabd38b764ac28c082704e	0x314ac6a0255c501ac37e07b391fad916083de507e016aed4dc9b9688e8c955d8	0x000000000000000000222737c7349cab000000000000000000238fb030e8d6b3	1530800000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	22	317269124	2025-03-19T08:53:29.000Z	18091984657765951006	0x4ce13a79f45c1be00bdabd38b764ac28c082704e	0x74ae424652e1735680231b4fe4ff436f25d135e5becc4f0e5ba366ae9104ec4b	0x00000000000000000022272a531626a0000000000000000000238fbe0281bf14	18838116226139909581
0xba1333333333a1ba1108e8412f11850a5c319ba9	false	16	317193896	2025-03-19T03:39:23.000Z	605054070299094628	0x4ce13a79f45c1be00bdabd38b764ac28c082704e	0x1cc4ebef252dba8a94228ca06c45fa5934aca9c1341c8a480a3f3f7c8e959eeb	0x00000000000000000022273709f6bdee000000000000000000238fb0f5f41893	630000000000000000

Example Query

Query with partition filter

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