Skip to main content

​
Tables

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newAuthorizerSTRINGAddress of the new authorizer contract set for the Balancer vault. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.beethoven_v2_sonic.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_liquidityProviderSTRINGAddress of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
in_kindINT64Swap 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_totalSupplySTRINGTotal supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
in_amountsAddedRawARRAY<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_swapFeeAmountsRawARRAY<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.
addressin_kindin_poolremovedlog_indexblock_numberin_totalSupplyblock_timestamptransaction_hashin_amountsAddedRawin_liquidityProviderin_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba900x3d71ad2852676f8a3644a37a2932e678c0b80cf3false2539214053944128921312577763165932025-07-19T10:13:29.000Z0x7452766d124cdd34734e5894cae074029038de07bec1eedf9df8a7da9b48864d[“147245082260136137782”,“96065653443372479186194263”]0xf4a3adf696838d8f8035cdb4fcfa9403e3a16863[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba900x3d71ad2852676f8a3644a37a2932e678c0b80cf3false439264582945533111054573392407062025-07-19T18:45:54.000Z0x14c8c7f0c350a91c172a55d2d981d04895e2b8e14e58e6d5aff01d2c6d858d83[“69281891852738955698”,“45229922946321504319977770”]0x9bebfb7057bc361cf2807e48e2284924ce0cacbe[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba900x3d71ad2852676f8a3644a37a2932e678c0b80cf3false1139190298824867034793912535963782025-07-19T05:41:41.000Z0x19596de68efdb7d759279779d3e2c3f563a073a7e8c80c9fddbe6c2a036bf08f[“5331426413424135770650”,“3417157373905445063529153491”]0xfd184b39cd9152a09c1c895cafd7efcd93dbbad1[“0”,“0”]
Query with partition filter
SELECT *
FROM `tt-contracts.beethoven_v2_sonic.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_liquidityProviderSTRINGAddress of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
in_kindINT64Swap 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_totalSupplySTRINGTotal supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
in_amountsRemovedRawARRAY<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_swapFeeAmountsRawARRAY<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.
addressin_kindin_poolremovedlog_indexblock_numberin_totalSupplyblock_timestamptransaction_hashin_amountsRemovedRawin_liquidityProviderin_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba900x3b57c58440ebb220d4d11db087d884a387259cf0false63708296089025998696137565662642025-07-04T04:36:44.000Z0x6851c27665d2962f880263b82ae8fce41c5778856d4dd3ec0164dfb45870bdc1[“6426146860478”,“7205789146597392518375132”]0x7fb1041931a8ca61a7607feb1500265bbd8f0434[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba900x43026d483f42fb35efe03c20b251142d022783f2false6371634754500722375688296067083772025-07-04T18:38:38.000Z0x79202a9f8d305394e2144616b1ea56a67236236ac9e359177d4e17827194db76[“2223475088”,“3604842138”]0xb444776908ff797e69d516caa5cc22856781b0a9[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba900x43026d483f42fb35efe03c20b251142d022783f2false6370702494568999751437448931053622025-07-04T01:49:27.000Z0xfe4111a76275612ac0d91cecd199971ce810ce91b5dbb38fa0ecfe7b0c38f15c[“4141123697”,“5919449789”]0x18a3a9ad1b6873f5cd104293d46fb6f81d8794f4[“0”,“0”]
Query with partition filter
SELECT *
FROM `tt-contracts.beethoven_v2_sonic.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_factorySTRINGContract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenConfigARRAY<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_swapFeePercentageSTRINGSwap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
in_pauseWindowEndTimeSTRINGUnix timestamp indicating when the pause window expires for the pool. Numeric string representing seconds since epoch.
in_roleAccountsSTRUCT<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_hooksConfigSTRUCT<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_liquidityManagementSTRUCT<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.
addressin_poolremovedlog_indexin_factoryblock_numberin_hooksConfigin_tokenConfigblock_timestampin_roleAccountstransaction_hashin_swapFeePercentagein_pauseWindowEndTimein_liquidityManagement
0xba1333333333a1ba1108e8412f11850a5c319ba90x4633a4a0bcb9d65e45c79f14be134d7d7b41b3f0false40xf023731dd8758d7c869af10005e6380cb57775a934968585{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}[{“token”:“0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“tokenType”:1,“rateProvider”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“paysYieldFees”:true}]2025-06-20T09:43:50.000Z{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x9c38c59e9a5b0140c672529a2487f5859ba4ca06”}0x1937e18ae9e82d6756e8209651575cbb3d737f7f4b89cd4c4ddaf9b4935e4e23900000000000001866617958{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba90x10658b1c73c9e91450f4f543a4f338e2cbb0db90false40xf023731dd8758d7c869af10005e6380cb57775a934970237{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}[{“token”:“0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“tokenType”:1,“rateProvider”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“paysYieldFees”:true}]2025-06-20T10:00:44.000Z{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x9c38c59e9a5b0140c672529a2487f5859ba4ca06”}0xb219fe0595c455f162c72d882785566ec4a489d177749b786cde08c840fc5218900000000000001866617958{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba90x6a684174cec570f622f9b77fbdc56e9cd83860aefalse40xf023731dd8758d7c869af10005e6380cb57775a934968305{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}[{“token”:“0x3333111a391cc08fa51353e9195526a70b333333”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“tokenType”:1,“rateProvider”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“paysYieldFees”:true}]2025-06-20T09:41:13.000Z{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0xcf392f62151fe078a5c26c6fd7e6bc5f15d9735a”,“swapFeeManager”:“0xcf392f62151fe078a5c26c6fd7e6bc5f15d9735a”}0xb6177036dbb3c111a85f9081e007bd6bddaa2999d219908cf273279880c6cca6195000000000000001866617958{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
Query with partition filter
SELECT *
FROM `tt-contracts.beethoven_v2_sonic.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenOutSTRINGContract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_amountInSTRINGAmount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
in_amountOutSTRINGAmount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
in_swapFeePercentageSTRINGSwap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
in_swapFeeAmountSTRINGAmount of fees charged on the swap transaction. Numeric string representing the fee quantity in the input token’s smallest denomination.
addressin_poolremovedlog_indexin_tokenInin_amountInin_tokenOutblock_numberin_amountOutblock_timestampin_swapFeeAmounttransaction_hashin_swapFeePercentage
0xba1333333333a1ba1108e8412f11850a5c319ba90x944d4ae892de4bfd38742cc8295d6d5164c5593cfalse520x016c306e103fbf48ec24810d078c65ad13c5f11b35179752755369024761219270x0c4e186eae8acaa7f7de1315d5ad174be39ec9874561176836031467193299076521162025-09-03T14:07:37.000Z35179752755369024770430xa49062a7d203f14c6e6a57ee11bdc7ae420f98b8aca84e1df447247c5faf5c301000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba90x944d4ae892de4bfd38742cc8295d6d5164c5593cfalse100x016c306e103fbf48ec24810d078c65ad13c5f11b8001009728748944424255940x0c4e186eae8acaa7f7de1315d5ad174be39ec987456173798194744258500333947552025-09-03T15:00:30.000Z8001009728748944433540x5d7fb65577fa2d643ccebe284169f3864af21c61e22dd1d392a066651f4a4edd1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba90x944d4ae892de4bfd38742cc8295d6d5164c5593cfalse380x016c306e103fbf48ec24810d078c65ad13c5f11b29323164603178400050900x0c4e186eae8acaa7f7de1315d5ad174be39ec9874556608530028861210040163722025-09-03T05:00:38.000Z29323164603178404120x5ce90e4d5df153a4d2d9f8e68ea19c2a4b733fd953e177f9f34fd960c527a8751000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.beethoven_v2_sonic.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_swapFeePercentageSTRINGSwap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hashin_swapFeePercentage
0xba1333333333a1ba1108e8412f11850a5c319ba90x2905927272e18a047983196472ff3b964c8f7c5cfalse5459485052025-09-06T12:20:39.000Z0x7bfefdb6eb34cd7cd0b0855f04831079ebb65f0cef814da77937297817ad3bab500000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba90x8759fefd6f4e24fe95b3e779739761d0ca71c01dfalse5285711362025-05-21T20:15:43.000Z0xf29e99b13c7b78c62fa07c82859085a93a068ae53d6c42305c8b26eddc91099b100000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba90x4a774e742d93374870d01532faa53bfdef4de1e6false23285173282025-05-21T15:15:46.000Z0xb368b69682bfe3816a4b29fd8e8ab7b344d186a6bc2a8c86bdd188901d6ca625100000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.beethoven_v2_sonic.Vault_SwapFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100