Skip to main content

Tables

AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event

Event emitted when a new Aave linear pool is created via Balancer V2’s AaveLinearPoolFactoryV5 contract. Contains the deployed pool address and associated Aave protocol identifier for tracking linear pool deployments across Balancer-Aave integrations.
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_protocolIdSTRINGNumeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
addressin_poolremovedlog_indexblock_numberin_protocolIdblock_timestamptransaction_hash
0x687b8c9b41e01be8b591725fac5d5f52d0564d790x712e23a9b91aa30ee7997d1c7a1a285d4c7912d1false9176866502023-07-25T23:11:17.000Z0x2afdad34bf1e499205302bb0802f5cfacf3db2275a4f3ca978796e0f54211e9a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV5_FactoryDisabled_event

Event log emitted when Balancer V2 Aave Linear Pool Factory V5 contract is disabled, preventing new pool creation. Contains transaction metadata and contract address for tracking factory lifecycle state 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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x687b8c9b41e01be8b591725fac5d5f52d0564d79false1030575832023-08-24T19:15:13.000Z0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.AaveLinearPoolFactoryV5_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV5_PoolCreated_event

Pool creation events emitted by Balancer V2 Aave Linear Pool Factory V5 contracts. Records the deployment of new Aave-integrated linear pools with their contract addresses and creation timestamps for tracking liquidity pool instantiation across supported chains.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x687b8c9b41e01be8b591725fac5d5f52d0564d790x712e23a9b91aa30ee7997d1c7a1a285d4c7912d1false417686652023-07-25T23:11:17.000Z0x2afdad34bf1e499205302bb0802f5cfacf3db2275a4f3ca978796e0f54211e9a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.AaveLinearPoolFactoryV5_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ChildChainGauge_Approval_event

ERC20 Approval events emitted by Balancer V2 ChildChainGauge contracts, recording token allowance grants from owners to spenders. Tracks gauge token approvals across multiple chains (Arbitrum, Avalanche, Base, Gnosis, Optimism, Polygon) for liquidity mining and delegation operations.
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__ownerSTRINGAddress of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string.
in__spenderSTRINGAddress authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).
addressremovedin__ownerin__valuelog_indexin__spenderblock_numberblock_timestamptransaction_hash
0x29b0c494ed7d098f4930428f115dcaf42a92392bfalse0x0d9fe4d2312fe4db12c2aef5dc1c3514af3da5023000000000000000080x8d2de8d2f73f1f4cab472ac9a881c9b123c7962777164812023-12-10T15:31:49.000Z0x3abca48929feb31e7cd4428eade14f842f3648d71d7de7828c7597e00cae9a67
0x29b0c494ed7d098f4930428f115dcaf42a92392bfalse0x0d9fe4d2312fe4db12c2aef5dc1c3514af3da502030x8d2de8d2f73f1f4cab472ac9a881c9b123c7962779662322023-12-16T10:16:51.000Z0xe716f81652256602babe940bd5fc52aa39ae905db3e461e2d8c87bde9ccd64b0
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x3fdb50f723ceb370470d314ed05c22d7359be52911579208923731619542357098500868790785326998466564056403945758400791312963993500x00007c1b03497405f082c160cccff2dba1b3000060403582023-11-01T20:21:03.000Z0xee61a4549c2cab98fa798cff395699ea1a09d8e4a9aad61cdb987928b695e8c1
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ChildChainGauge_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ChildChainGauge_Deposit_event

Deposit events from Balancer V2 liquidity gauge contracts on Layer 2 chains and sidechains. Records user staking of liquidity pool tokens into gauges for BAL token rewards.
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__userSTRINGAddress of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).
addressremovedin__userin__valuelog_indexblock_numberblock_timestamptransaction_hash
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0xb5003153c07c51b9ac40e7b7d30bd8268104680b70795392857550732143913112023-09-24T16:12:49.000Z0xff0b5d6efccae228b9e35add6477584ea5de5dd1f566dc4a4890aee6548f5aaf
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x6b21de83d21d6e64be0033bf6b1ab81cd8063d3b5997168279931654443681512023-09-24T03:20:49.000Z0x26b43ddbb99d381cbd8bd9eaa15d9d9953de88a5ee6b5f7999222a643890a85b
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x0afb69f36b0f28064e3e3657595655b077ae4883219886086897312643834442023-09-24T11:50:35.000Z0x6cabbb6c4ab3c97a79c4ab6b0de65f60384602fa47bc0f8840c85376661af68a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ChildChainGauge_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ChildChainGauge_Transfer_event

ERC20 Transfer events emitted by Balancer ChildChainGauge contracts tracking gauge token movements between addresses. Records sender, recipient, and token amount for liquidity mining reward distribution and staking position transfers across Layer 2 and sidechain deployments.
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__fromSTRINGAddress initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__toSTRINGDestination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).
in__toaddressremovedin__fromin__valuelog_indexblock_numberblock_timestamptransaction_hash
0x00000000000000000000000000000000000000000x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x4e9baacf3b7acc03269bfced5f350f6fb0eb1bd5897540437430718441176236532023-12-08T11:57:33.000Z0x30ef23c0a3bd164bb64ed299a132ad05669ef7d07583bc09fb349bdcb58921e6
0x00000000000000000000000000000000000000000x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0xc181edc719480bd089b94647c2dc504e2700a2b05000000000000000004376242812023-12-08T12:18:29.000Z0x20dfb5e5ecaec01a0350ab24ca5c5522ebb841203042cfb61efa5cdd04122026
0x00000000000000000000000000000000000000000x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0xc181edc719480bd089b94647c2dc504e2700a2b021689018963545211931976381362023-12-08T20:00:19.000Z0xdbd11bda8b90235b6615e84cd0e8c7f2689e9adbf49226804801bace71cbf5b3
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ChildChainGauge_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ChildChainGauge_UpdateLiquidityLimit_event

Liquidity limit update events emitted by Balancer v2 ChildChainGauge contracts, recording changes to user staking balances and total supply metrics. Contains original and working balance/supply values used for calculating gauge rewards and voting power across Layer 2 deployments.
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__userSTRINGAddress of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__original_balanceSTRINGUser’s original balance in the liquidity gauge. String-encoded integer representing token amount in smallest unit.
in__original_supplySTRINGTotal original token supply in the liquidity gauge. String-encoded integer representing token amount in smallest unit.
in__working_balanceSTRINGUser’s working balance in the liquidity gauge after applying boost multipliers. String-encoded integer representing token amount in smallest unit.
in__working_supplySTRINGTotal working supply in the liquidity gauge after applying boost multipliers to all user balances. String-encoded integer representing token amount in smallest unit.
addressremovedin__userlog_indexblock_numberblock_timestamptransaction_hashin__working_supplyin__original_supplyin__working_balancein__original_balance
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x850f83132d66abf840f32b6a8c5db6fd1a54f9852459835672023-10-31T12:48:01.000Z0x2571ebb988e579ee56539d731f1a83c3fef49a7c97eb3379a5cf5f2920ef4f51574627421660711156015143649251060038207170700
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0xcd07da92d4be4a79baa895a0cd58a2ff1ef949bb1559824782023-10-31T12:11:43.000Z0x988bb714493e313a2ba9ca8f312243424738ccb0f2670840a0df987ac02f9023574736625943297871625143676552130684886073400
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0xcd07da92d4be4a79baa895a0cd58a2ff1ef949bb859824292023-10-31T12:10:05.000Z0x15031103cefbabefa849ddd85967843906b81e8917e2ba02dae031bd6c7a7d6d574736625943297871625143676552130684886073400
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ChildChainGauge_UpdateLiquidityLimit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ChildChainGauge_Withdraw_event

Withdrawal events emitted by Balancer V2 ChildChainGauge contracts when users unstake liquidity pool tokens from gauges. Records the user address and token amount withdrawn in base units for tracking gauge participation 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__userSTRINGAddress of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).
addressremovedin__userin__valuelog_indexblock_numberblock_timestamptransaction_hash
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x7828eb93f247a81a907a99a0c77c7b4b9235c03870966836546827375281671872023-12-21T01:55:21.000Z0x34a6c68655e6347cb859c4256921657991989a36dd1f398f8b09d8ba63df9a5c
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0x8f26bdea1b442e3311c6c99d61071624531d895171011853915847467381657432023-12-21T01:07:13.000Z0x0eb8ee446b4eb311fc6fd2d4a895d780b2a65121cddca0f673c833808cb01650
0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8false0xb5003153c07c51b9ac40e7b7d30bd8268104680b100024626359712692381718752023-12-21T04:31:37.000Z0x5f6b01efb7f9fbd67de9c7f3bd2d39ad441783e8c7ab76ec4845f3ae819ed934
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ChildChainGauge_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ChildChainGaugeFactory_GaugeCreated_event

Event logs emitted when a new gauge contract is deployed by the ChildChainGaugeFactory contract in Balancer v2. Records the address of each created gauge contract for tracking liquidity mining incentive distribution mechanisms across Layer 2 and sidechain deployments.
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_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_gaugelog_indexblock_numberblock_timestamptransaction_hash
0xb1a4fe1c6d25a0ddab47431a92a723dd71d9021ffalse0x4321edfe7dec773a91316481fcb19d6ca6dc52072559673992023-10-31T03:49:05.000Z0x98b35da464e3a601ccc63068f852e47546114aa27d5a532187b7670f5d0b5482
0xb1a4fe1c6d25a0ddab47431a92a723dd71d9021ffalse0xfa61fb6218378b9f01ca4b2b662b5c4d12915db91159636732023-10-31T01:44:53.000Z0xc6c3aea149b26b004bab42ea3efc17181504adf14b0b42c4644e01ec4efcfb30
0xb1a4fe1c6d25a0ddab47431a92a723dd71d9021ffalse0x309b2b4549be6821b735e86b47df3bea1a7f6b08544005972023-09-24T21:22:21.000Z0x5205ca8389107c75ce1090798359f9eb8eee577794b3e57f6e1985b564703792
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ChildChainGaugeFactory_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV5_FactoryDisabled_event

Event log emitted when a Balancer V2 Composable Stable Pool Factory V5 contract is disabled. Records the administrative action of deactivating the factory contract from creating new pools.
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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x8df317a729fcaa260306d7de28888932cb579b88false153163919612024-06-28T11:14:29.000Z0x7d6a41891991fb1eadf57bf74fc5ae98bf4ff34c99ae242b7259a0e5165c1c77
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ComposableStablePoolFactoryV5_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV5_PoolCreated_event

Pool creation events emitted by Balancer V2 ComposableStablePoolFactoryV5 contracts. Captures the factory contract address and newly deployed composable stable pool address for tracking pool deployments across the protocol.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x8df317a729fcaa260306d7de28888932cb579b880x6fbfcf88db1aada31f34215b2a1df7fafb4883e9false721071592023-08-02T19:14:25.000Z0x70a5bbade72795084c7903c4715d828e523b08973fd599e2dddea60b50a9f702
0x8df317a729fcaa260306d7de28888932cb579b880x0c659734f1eef9c63b7ebdf78a164cdd745586dbfalse1936217212023-09-06T20:39:49.000Z0xc5da71d36c7406f7e04747b0c2b7965188ffe96309a70f013376fa0ad5dbfb11
0x8df317a729fcaa260306d7de28888932cb579b880xc561540c16d49d0bfc69c99f9fc66145b1d5ddbdfalse1422766782023-08-06T17:25:03.000Z0x40e58e8f0058b1b6a30cf4331a3489991dc8b7baa6be61bcfaef3d49bb131a51
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ComposableStablePoolFactoryV5_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

ERC-4626 (Tokenized Vault Standard) linear pool creation events emitted by Balancer V2 factory contracts. Contains deployed pool address and protocol integration identifier for tracking vault-based linear pool deployments across liquidity management strategies.
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_protocolIdSTRINGNumeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
addressin_poolremovedlog_indexblock_numberin_protocolIdblock_timestamptransaction_hash
0x161f4014c27773840ccb4ec1957113e6dd0288460x1cc2e10c486ffb7228810b9c7c183d0cd92cdf44false9176862202023-07-25T23:09:51.000Z0x409a4a467fcad05f47f8deee638d698e058bc36854c932f3a571cfdc3dd78a40
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV4_FactoryDisabled_event

Event log emitted when an ERC4626 linear pool factory (version 4) is disabled in Balancer V2. Records the deactivation of pool creation functionality for ERC-4626 tokenized vault integration.
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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x161f4014c27773840ccb4ec1957113e6dd028846false730575832023-08-24T19:15:13.000Z0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ERC4626LinearPoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV4_PoolCreated_event

PoolCreated event logs emitted by Balancer V2’s ERC4626LinearPoolFactoryV4 contract when new ERC-4626 linear pools are deployed. Records the factory contract address and newly created pool address for tracking Balancer linear pool creation across chains.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x161f4014c27773840ccb4ec1957113e6dd0288460x1cc2e10c486ffb7228810b9c7c183d0cd92cdf44false417686222023-07-25T23:09:51.000Z0x409a4a467fcad05f47f8deee638d698e058bc36854c932f3a571cfdc3dd78a40
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ERC4626LinearPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GearboxLinearPoolFactoryV2_FactoryDisabled_event

Factory disable events from Balancer V2’s Gearbox Linear Pool Factory on Base chain. Tracks when the factory contract is administratively disabled, preventing creation of new Gearbox-integrated linear pools.
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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x9dd32684176638d977883448a4c914311c07bd62false830575832023-08-24T19:15:13.000Z0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.GearboxLinearPoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GearboxLinearPoolFactoryV2_GearboxLinearPoolCreated_event

Pool creation events from Balancer V2’s Gearbox Linear Pool Factory on Base, capturing when new Gearbox-integrated linear pools are deployed. Used for tracking pool deployments and analyzing Gearbox protocol integration with Balancer’s liquidity infrastructure.
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_protocolIdSTRINGNumeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
addressin_poolremovedlog_indexblock_numberin_protocolIdblock_timestamptransaction_hash
0x9dd32684176638d977883448a4c914311c07bd620x3c28a59356b473847aaa5e0b6f561636079213a6false9176887302023-07-25T23:18:13.000Z0x96b4a76957bcdfe134c36be78f4e6fc0d46b7f1d8633921c0cea751b62a3893a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.GearboxLinearPoolFactoryV2_GearboxLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GearboxLinearPoolFactoryV2_PoolCreated_event

Pool creation events from Balancer V2’s Gearbox Linear Pool Factory on Base, tracking newly deployed Gearbox-integrated linear pools. Used for monitoring pool deployments and analyzing Gearbox protocol integration with Balancer liquidity infrastructure.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x9dd32684176638d977883448a4c914311c07bd620x3c28a59356b473847aaa5e0b6f561636079213a6false417688732023-07-25T23:18:13.000Z0x96b4a76957bcdfe134c36be78f4e6fc0d46b7f1d8633921c0cea751b62a3893a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.GearboxLinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ManagedPoolFactoryV2_FactoryDisabled_event

Event log emitted when a Balancer V2 Managed Pool Factory V2 contract is disabled. Records administrative actions that prevent the factory from creating new managed pool instances.
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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x9a62c91626d39d0216b3959112f9d4678e20134dfalse418384325732025-11-20T16:01:33.000Z0xd897b9c5b7fe5d63464f51736fc11298ed3144b909e35920553988ea2e247f7a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ManagedPoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ManagedPoolFactoryV2_PoolCreated_event

Pool creation events emitted by Balancer V2 ManagedPoolFactory V2 contracts. Records the deployment of new managed pools with factory and pool contract addresses.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x9a62c91626d39d0216b3959112f9d4678e20134d0x69592c63173bf84aa29c10935b9863717a8efe31false17102434362024-02-07T03:23:39.000Z0x980cc98668f90759ea6e5753d85e76b8c99e6dde2df5ea55ffaf2cf47836ea34
0x9a62c91626d39d0216b3959112f9d4678e20134d0xe50ad96af9370d05d3c1ce85f17c31557b29c4eefalse1017690002023-07-25T23:22:27.000Z0xd79a9e12b5575c7a6c30e735eda2b0f3e76d36273bf864b7a3f5798be473a201
0x9a62c91626d39d0216b3959112f9d4678e20134d0xfaf027b660a614126cb204184422e34780980789false9105635492024-02-14T13:14:05.000Z0x764304ca9b3b87741932ce95f541f8ac9cf31adbfd49def1164b6030565e15f7
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ManagedPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

Event logs emitted when a Balancer V2 Liquidity Bootstrapping Pool (LBP) factory contract is disabled. Records administrative actions that prevent new pool creation from the factory.
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.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

Liquidity Bootstrapping Pool (LBP) creation events emitted by Balancer V2’s no-protocol-fee factory contract. Records the deployed pool address when new weight-adjustable pools are created for token launches and fair distribution mechanisms.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x0c6052254551eae3ecac77b01dfcf1025418828f0xce6f0924180724b025d3132253ceaa7f1e095402false518055882023-07-26T19:42:03.000Z0xc62dd6736281318945c6f689d435656a5033ba0184b72fb03b197dfcaf53bfd7
0x0c6052254551eae3ecac77b01dfcf1025418828f0x71528afe250438e184b2deaf7947f0f45931df3bfalse512065352023-07-12T22:53:37.000Z0xdc1727acbf01ace17bbe6ca4fae9fcbbeced935ef386c38215f16decaaa0f3f3
0x0c6052254551eae3ecac77b01dfcf1025418828f0xd094485a7feb679e5433edb80c3771dccdfa9cf1false92229064172024-11-26T06:23:01.000Z0x8313f17023c6ba78d797058a9853db3a311a4d2bc507dd9a35996a72626a2382
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_RecoveryModeStateChanged_event

Balancer V2 pool recovery mode state change events emitted when pools enter or exit recovery mode. The in_enabled flag indicates whether recovery mode was activated or deactivated for emergency liquidity withdrawals.
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_enabledBOOLBoolean flag indicating whether recovery mode or the collector is enabled.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Pool_RecoveryModeStateChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_SwapFeePercentageChanged_event

Event logs recording swap fee percentage updates for Balancer V2 and Beethoven X liquidity pools. Emitted when pool administrators modify the fee rate charged on token swaps, stored as a wei-denominated percentage where 1e18 equals 100%.
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_swapFeePercentageSTRINGSwap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_swapFeePercentage
0x433f09ca08623e48bac7128b7105de678e37d988false3336219592023-09-06T20:47:45.000Z0xc2773346139264da5c148fd22d25df445a507cca61aa2088b503d190c8724e315000000000000000
0xb328b50f1f7d97ee8ea391ab5096dd7657555f49false736222032023-09-06T20:55:53.000Z0x198d9684de4ed6cd999ecf5914f17eb46dc80a8de8998e3a5a722905a46cb9735000000000000000
0x0c659734f1eef9c63b7ebdf78a164cdd745586dbfalse1236217212023-09-06T20:39:49.000Z0xc5da71d36c7406f7e04747b0c2b7965188ffe96309a70f013376fa0ad5dbfb11100000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Pool_SwapFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Transfer_event

Liquidity pool token transfer events emitted when LP (Liquidity Provider) tokens are minted, burned, or transferred between addresses. Contains sender, recipient, and token amount for tracking pool share ownership and liquidity position 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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
0x52746cbb5f62ac9b5bd295f3ff129c24788f24aefalse8920113592023-07-31T14:01:05.000Z0x9a3fe4d1323bff8c8c00aab646226ae49190625ce4c15a42a8e3672cf9304c9e
0x52746cbb5f62ac9b5bd295f3ff129c24788f24aefalse2020120122023-07-31T14:22:51.000Z0xa0e2337f1056b2433842117485e8e3eeaf9eac5d5703df751bda0615abe89bdf
0x52746cbb5f62ac9b5bd295f3ff129c24788f24aefalse120073162023-07-31T11:46:19.000Z0xaf67702c5704fcf5b0b29cf8bb3d40a27f323bb2d5fd33a8797cb88af3adfa6f
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Pool_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

Event logs capturing flash loan fee percentage updates in the Balancer V2 Protocol Fees Collector contract. Records the new fee percentage value whenever protocol governance modifies the flash loan borrowing cost.
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_newFlashLoanFeePercentageSTRINGNew flash loan fee percentage for the Balancer protocol. String-encoded integer value representing the fee in basis points with 18 decimal places of precision.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ProtocolFeesCollector_FlashLoanFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ProtocolFeesCollector_SwapFeePercentageChanged_event

Protocol fee percentage update events emitted by Balancer V2 ProtocolFeesCollector contracts. Records changes to the swap fee percentage charged on protocol-level transactions, with the new percentage value stored as a wei-denominated string.
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_newSwapFeePercentageSTRINGNew swap fee percentage for the protocol. 18-decimal fixed-point integer represented as a string, where 1e18 equals 100%.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_newSwapFeePercentage
0xce88686553686da562ce7cea497ce749da109f9ffalse7921369222023-08-03T11:46:31.000Z0x6d89afc8361a395c1216386a96e6a2a26d36f52f2f55894f104ab408c1ee6057500000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.ProtocolFeesCollector_SwapFeePercentageChanged_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.
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.
addressremovedlog_indexblock_numberblock_timestampin_newAuthorizertransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false011960362023-07-12T17:03:39.000Z0x809b79b53f18e9bc08a961ed4678b901ac93213a0x0dc2e3d436424f2f038774805116896d31828c0bf3795a6901337bdec4e0dff6
0xba12222222228d8ba445958a75a0704d566bf2c8false8621369222023-08-03T11:46:31.000Z0xa69e0ccf150a29369d8bbc0b3f510849db7e8eee0x6d89afc8361a395c1216386a96e6a2a26d36f52f2f55894f104ab408c1ee6057
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_AuthorizerChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_ExternalBalanceTransfer_event

External token transfer events emitted by Balancer V2 and BEX vault contracts, capturing sender address, recipient address, token address, and transfer amount. Used for tracking token movements between vault external balances and user accounts.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_tokenin_amountin_senderlog_indexblock_numberin_recipientblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee82060785447403154730xeede8aacbf9bd025bf343255c5ebb1ca60ff645363174738300x7c3c773c878d2238a9b64d8cee02377bf07ed06a2024-07-23T12:16:47.000Z0x359b1c47f5c65417e7c875c92338db8f5e1b0298a844588ea318ce160b8f7f89
0xba12222222228d8ba445958a75a0704d566bf2c8false0xf7862a614ffea2bf8ef2d66a872be2df735d22e622959052657804615740xfa70a111fbe53ab5ee7aedb9a3b06c5a9733c09345174942610x7c3c773c878d2238a9b64d8cee02377bf07ed06a2024-07-23T23:37:49.000Z0x8078b4f31862b6e86cf4865a25d60f6327a6b7917632fdf83d2a19e9ba569004
0xba12222222228d8ba445958a75a0704d566bf2c8false0xf7862a614ffea2bf8ef2d66a872be2df735d22e67257161594225725210x3dbce497ba28f264f6f256126c555c51ca885824147174766710x7c3c773c878d2238a9b64d8cee02377bf07ed06a2024-07-23T13:51:29.000Z0x2e380db3e9cc9925cbb517f263ae0f45b80f970dc87d5841911d73d98bf13848
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_ExternalBalanceTransfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_FlashLoan_event

Flash loan events emitted by decentralized exchange (DEX) vault contracts, recording uncollateralized borrows of tokens with borrowed amount, fee charged, and recipient address. Used for arbitrage tracking and flash loan analytics across Balancer V2, Beethoven X, BEX, and SyncSwap 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_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_feeAmountSTRINGFee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
addressremovedin_tokenin_amountlog_indexblock_numberin_feeAmountin_recipientblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0x833589fcd6edb6e08f4c7c32d4f71b54bda02913100000024609725700x3b1c7893c83265c94863243c776a1a862f6174f62023-11-03T03:57:41.000Z0x2b5f916d1b280d9064553bee8e6e9f4425dddc9a996f10628fb6b88e5c9f9b59
0xba12222222228d8ba445958a75a0704d566bf2c8false0xeb466342c4d449bc9f53a865d5cb90586f4052151000000253609173800x0352bad2bb0fbd93455ae0cfb72d9fba3036df022023-11-03T00:53:43.000Z0x2810273ac415a1d69fdc47fc329ff48b92ba07c6b35873e9f80d83b4100afaf1
0xba12222222228d8ba445958a75a0704d566bf2c8false0xeb466342c4d449bc9f53a865d5cb90586f4052151000000223609173800x0352bad2bb0fbd93455ae0cfb72d9fba3036df022023-11-03T00:53:43.000Z0x2810273ac415a1d69fdc47fc329ff48b92ba07c6b35873e9f80d83b4100afaf1
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_InternalBalanceChanged_event

Balancer Vault internal balance modification events recording user token deposit and withdrawal changes. Tracks user address, token address, and signed delta values for internal accounting within the Vault contract.
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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_deltaSTRINGChange in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.
addressin_userremovedin_deltain_tokenlog_indexblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c80x76f7204b62f554b79d444588edac9dfa7032c71afalse00x6fbfcf88db1aada31f34215b2a1df7fafb4883e91950788872023-10-10T14:12:01.000Z0x6adec24b89c44b0b07e59df2404e13a6be8561a6c370e3dc447d5a108e7cd49b
0xba12222222228d8ba445958a75a0704d566bf2c80x76f7204b62f554b79d444588edac9dfa7032c71afalse-50987360x833589fcd6edb6e08f4c7c32d4f71b54bda029133650790472023-10-10T14:17:21.000Z0x89dd458090032e620ca9a42fc95e74d112e78cbe988642d55cf7cc155961aeee
0xba12222222228d8ba445958a75a0704d566bf2c80x76f7204b62f554b79d444588edac9dfa7032c71afalse50987360x833589fcd6edb6e08f4c7c32d4f71b54bda029133250790472023-10-10T14:17:21.000Z0x89dd458090032e620ca9a42fc95e74d112e78cbe988642d55cf7cc155961aeee
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_InternalBalanceChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_PausedStateChanged_event

Event logs recording pause state transitions for Balancer V2 vault contracts. Tracks when vault operations are paused or unpaused through the boolean in_paused field.
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_pausedBOOLBoolean flag indicating whether the paused state is active. True indicates the contract or program is paused, false indicates it is active.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_PausedStateChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_PoolBalanceChanged_event

Balancer V2 Vault event emitted when liquidity provider positions change in a pool, recording token balance deltas and protocol fees. Contains pool identifier, liquidity provider address, token addresses, and per-token balance changes for tracking deposits, withdrawals, and pool composition updates.
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_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_liquidityProviderSTRINGAddress of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
in_deltasARRAY<STRING>Array of token balance changes for each token in the pool. String-encoded signed integers representing the change in token amounts, with positive values indicating deposits and negative values indicating withdrawals.
in_protocolFeeAmountsARRAY<STRING>Array of protocol fee amounts collected for each token in the pool. String-encoded unsigned integers corresponding positionally to tokens in the pool, representing fees taken by the protocol on the transaction.
addressremovedin_deltasin_poolIdin_tokenslog_indexblock_numberblock_timestamptransaction_hashin_liquidityProviderin_protocolFeeAmounts
0xba12222222228d8ba445958a75a0704d566bf2c8false[“4673524703018377”,“0”]0xa892be6ee527f4fb8b3b60486a53c0627cb1d27e000200000000000000000014[“0x4200000000000000000000000000000000000006”,“0xa48c87061f4081ca8b4e2bc01711edefb0dab2fc”]485222452023-12-29T07:10:37.000Z0x00801130100e07f5d21b3b3ddb5a07689e6cb9f323632461b76ff0a014c8199f0xa0ef13ea74083b3b56dd607f2c6aab45fe7d0780[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8false[“5625695403908872”,“0”]0x65e8e75899f683c8e2e73c77d6c5c63075f296cd00020000000000000000002b[“0x4200000000000000000000000000000000000006”,“0xa9c9dcb054421dedc9d9006cffe843d0a5cd6339”]1185094562023-12-29T00:04:19.000Z0x1080d4517b8a06b30dadabf9999b5cf3a63434ceb0310a86222e307172747e300x5bcf1b386034156856277e960e32007facaf7382[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8false[“0”,“657631275353149016640616”]0x65e8e75899f683c8e2e73c77d6c5c63075f296cd00020000000000000000002b[“0x4200000000000000000000000000000000000006”,“0xa9c9dcb054421dedc9d9006cffe843d0a5cd6339”]485455262023-12-29T20:06:39.000Z0xfe6f6f30d94b2e99d4c1f560bfd788b5ede22c77c27f6597d11b3d727de28c220x6afbc428dcde09679592b330a9164247e9614bd3[“0”,“0”]
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_PoolBalanceChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_PoolBalanceManaged_event

Balancer V2 Vault event emitted when an asset manager adjusts the allocation of a pool’s token balance between liquid cash reserves and managed external positions. Records changes in cash and managed amounts for pool rebalancing operations.
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_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_assetManagerSTRINGContract address of the asset manager responsible for managing pool token balances. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_cashDeltaSTRINGChange in token balance available to the pool’s vault for immediate operations. String-encoded signed integer representing token units.
in_managedDeltaSTRINGChange in token balance managed by the asset manager outside the vault’s immediate liquidity pool. String-encoded signed integer representing token units.
addressremovedin_tokenin_poolIdlog_indexblock_numberin_cashDeltablock_timestampin_assetManagerin_managedDeltatransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb33ff54b9f7242ef1593d2c9bcd8f9df46c779350xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae1742411829302024-12-24T07:38:53.000Z0x311b982e5c55dcb96379f8f06f649b13207fcb31-5000000000000000x486ee3096c9efb52c723a441b8b71f71a4b45dbeee2b01447c0da3f4c44accf4
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb33ff54b9f7242ef1593d2c9bcd8f9df46c779350xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae17324118293-5000000000000002024-12-24T07:38:53.000Z0x311b982e5c55dcb96379f8f06f649b13207fcb315000000000000000x486ee3096c9efb52c723a441b8b71f71a4b45dbeee2b01447c0da3f4c44accf4
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb33ff54b9f7242ef1593d2c9bcd8f9df46c779350xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae236241175385000000000000002024-12-24T07:13:43.000Z0x311b982e5c55dcb96379f8f06f649b13207fcb31-5000000000000000x9683bd3403ee98ebd4addb36cf997d1a6e48f1c20acabf3121d87d020da959cc
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_PoolBalanceManaged_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_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_poolAddressSTRINGContract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
in_specializationINT64Pool specialization type indicator in Balancer V2 Vault architecture. Integer value encoding the pool’s internal asset management strategy (0=General, 1=Minimal Swap Info, 2=Two Token).
addressremovedin_poolIdlog_indexblock_numberin_poolAddressblock_timestamptransaction_hashin_specialization
0xba12222222228d8ba445958a75a0704d566bf2c8false0x15d9d108437b17d1fa70392f9ed086306229ec910000000000000000000000bf467270900x15d9d108437b17d1fa70392f9ed086306229ec912023-11-17T17:52:07.000Z0x90f0138d2967b653a9298f26eda75a2d54e9a63963683c473a1501020436bce10
0xba12222222228d8ba445958a75a0704d566bf2c8false0x64fcbd882d7de9d4dd1fa670c3f1ea15f324baf40002000000000000000000be867093540x64fcbd882d7de9d4dd1fa670c3f1ea15f324baf42023-11-17T08:00:55.000Z0x40db041bcb194c5c2e7e29daa375b25f306d2b4208461b9ee4a59c2c9e2c44172
0xba12222222228d8ba445958a75a0704d566bf2c8false0x1607aa77f703deedfd4b8e146d3c7fcb5bee4a9c0002000000000000000000dd1889982570x1607aa77f703deedfd4b8e146d3c7fcb5bee4a9c2024-01-09T07:37:41.000Z0x64272931f0eac1d552ca3f152cde5509beec97bcb8ef5e7a869a0456cb43ef1c2
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_PoolRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_RelayerApprovalChanged_event

Relayer approval state change events emitted by Balancer V2 Vault contracts when users authorize or revoke permission for relayer addresses to execute operations on their behalf. Used for tracking relayer delegation patterns and vault security permissions.
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_relayerSTRINGAddress of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_approvedBOOLBoolean flag indicating whether approval was granted or revoked for the operation.
addressremovedin_senderlog_indexin_relayerin_approvedblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xc040794468e2c5180312e5a10b093a33a486742f00x76f7204b62f554b79d444588edac9dfa7032c71atrue23394252023-08-08T04:16:37.000Z0x366c2cd867847e78049a93871667b17807d3a0d86b677c5aa827f9f5ba0325c6
0xba12222222228d8ba445958a75a0704d566bf2c8false0xc9cd150c362f4c10460677bf2cf294f2354d648400x76f7204b62f554b79d444588edac9dfa7032c71atrue23634302023-08-08T17:36:47.000Z0x6c2c281739e4b860d826645121e98f27d75f4a790122a8536f5fc36fc0725d8b
0xba12222222228d8ba445958a75a0704d566bf2c8false0x97518452ec958be01457e55b96c12bc02a53294500x76f7204b62f554b79d444588edac9dfa7032c71atrue23733392023-08-08T23:07:05.000Z0x82285ab04462736637f5e3bbf15e192590d93634e4fd9b6e80849ba1f9fc26e5
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_RelayerApprovalChanged_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_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
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.
addressremovedin_poolIdlog_indexin_tokenInin_amountInin_tokenOutblock_numberin_amountOutblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0x0c659734f1eef9c63b7ebdf78a164cdd745586db000000000000000000000046290x833589fcd6edb6e08f4c7c32d4f71b54bda029131312232370x0c659734f1eef9c63b7ebdf78a164cdd745586db88827291301676756363234110882024-01-06T15:26:45.000Z0xb009021d5a19266c688b4500357e46308adb20d1c564eeae09bce3c27e9fe00e
0xba12222222228d8ba445958a75a0704d566bf2c8false0x58f2110b61f97fd6b9200b038d92f17c722a5a3300000000000000000000004f40x4158734d47fc9692176b5085e0f52ee0da5d47f132883652540896360x11c1879227d463b60db18c17c20ae739ae8e961a889213332844555588615312024-01-06T20:40:13.000Z0x8a46a50a04ddf42ddd256388d4d9f8244d6a02c3160258585aaae6409f433840
0xba12222222228d8ba445958a75a0704d566bf2c8false0x2650d8d8167faa125a9156d533703a2af5d9f4e10001000000000000000000ce50x4158734d47fc9692176b5085e0f52ee0da5d47f11540897282303967170x1509706a6c66ca549ff0cb464de88231ddbe213b888118410149274986287861822024-01-06T14:35:15.000Z0x1ffce3904226621f177f217abbcca5cc3c112108fb6fe0896ce286096a9727c5
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_TokensDeregistered_event

Balancer V2 Vault event recording the removal of tokens from a liquidity pool’s registered token list. Emitted when pool composition changes through token deregistration, containing the pool identifier and array of deregistered token addresses.
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_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
addressremovedin_poolIdin_tokenslog_indexblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae[“0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935”]177241182932024-12-24T07:38:53.000Z0x486ee3096c9efb52c723a441b8b71f71a4b45dbeee2b01447c0da3f4c44accf4
0xba12222222228d8ba445958a75a0704d566bf2c8false0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae[“0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935”]142241157002024-12-24T06:12:27.000Z0x409a0eace747da13978b85788a0cdb6030ee020abc2a5ef223816eebbc3d036e
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_TokensDeregistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_TokensRegistered_event

Event logs recording token registration within Balancer V2 vault pools. Contains pool identifier, array of registered token addresses, and corresponding asset manager addresses for tracking pool composition initialization.
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_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
in_assetManagersARRAY<STRING>Array of asset manager contract addresses for each token in the pool. Hex-encoded, 0x-prefixed, 42-character strings corresponding to each token in in_tokens array.
addressremovedin_poolIdin_tokenslog_indexblock_numberblock_timestampin_assetManagerstransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xc80289149774aeab633a7a2c28d673c784a30ba1000200000000000000000055[“0x4158734d47fc9692176b5085e0f52ee0da5d47f1”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”]743572002023-09-23T21:15:47.000Z[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]0x3a4dc8abf40bb4c76fdb71ab684b2674419cce968c44d40de6f9bb994d9de309
0xba12222222228d8ba445958a75a0704d566bf2c8false0x6fbfcf88db1aada31f34215b2a1df7fafb4883e900000000000000000000000c[“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“0x6fbfcf88db1aada31f34215b2a1df7fafb4883e9”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”]221071592023-08-02T19:14:25.000Z[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]0x70a5bbade72795084c7903c4715d828e523b08973fd599e2dddea60b50a9f702
0xba12222222228d8ba445958a75a0704d566bf2c8false0x2db50a0e0310723ef0c2a165cb9a9f80d772ba2f00020000000000000000000d[“0x4200000000000000000000000000000000000006”,“0x6fbfcf88db1aada31f34215b2a1df7fafb4883e9”]221073632023-08-02T19:21:13.000Z[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]0xfe4b79ebcf53fdbd387398d20b2c56785414aa448217f5a5e8ba5c68ca81aa09
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.Vault_TokensRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV4_FactoryDisabled_event

Event emitted when a Balancer V2 weighted pool factory (version 4) is administratively disabled, preventing new pool creation. Used for tracking factory lifecycle and protocol governance actions.
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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4false417384325732025-11-20T16:01:33.000Z0xd897b9c5b7fe5d63464f51736fc11298ed3144b909e35920553988ea2e247f7a
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.WeightedPoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV4_PoolCreated_event

Event logs emitted by Balancer V2 WeightedPoolFactory version 4 contracts when new weighted pools are deployed. Records the deployed pool address and factory contract address for tracking pool creation across Balancer protocol instances.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x4c32a8a8fda4e24139b51b456b42290f51d6a1c40xe9ea6b943f252bf3dfa4d7964f19404a2bdd1f75false2167727032023-11-18T19:12:33.000Z0xa792f2123eeb13f1dfeeca02b6778e7ef9ba3f9d3ed9adccceaac8839e0e272f
0x4c32a8a8fda4e24139b51b456b42290f51d6a1c40x9d884e09e0ddf816a1b3f31ccd94a0319793b11bfalse3667812972023-11-18T23:59:01.000Z0x44a1d8132aceff11da322886c0f857b92cceff3f7feada5e66b31a98cfacdaaf
0x4c32a8a8fda4e24139b51b456b42290f51d6a1c40x2650d8d8167faa125a9156d533703a2af5d9f4e1false975084682023-12-05T19:58:03.000Z0x1e982db6e98c12e8aa6692c10f0c4d06ebc40aacac47910a76c0f3f17943070b
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.WeightedPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YearnLinearPoolFactoryV2_FactoryDisabled_event

Event logs emitted when a Yearn Linear Pool Factory V2 contract is disabled on Balancer V2. Contains transaction metadata and contract address for tracking factory lifecycle state 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.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x44d33798dddcdabc93fe6a40c80588033dc502d3false930575832023-08-24T19:15:13.000Z0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.YearnLinearPoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YearnLinearPoolFactoryV2_PoolCreated_event

Balancer V2 event logs emitted when a Yearn Linear Pool is created by the YearnLinearPoolFactoryV2 contract, recording the factory address and newly created pool address. Used to track the deployment of Yearn-integrated linear pools across Balancer V2 implementations.
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.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x44d33798dddcdabc93fe6a40c80588033dc502d30x369877467fc3b6774de4e11e0c0abbde70eb40fdfalse417687212023-07-25T23:13:09.000Z0x0262976c98dca636d6c969d212db76f9c159b1f752ab440a823ffb3fcf3f5b49
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.YearnLinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YearnLinearPoolFactoryV2_YearnLinearPoolCreated_event

Event logs recording creation of Yearn-integrated linear pools in Balancer V2, emitted by the YearnLinearPoolFactoryV2 contract. Contains the newly created pool address and protocol identifier linking the pool to Yearn vault integrations for yield-bearing assets.
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_protocolIdSTRINGNumeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
addressin_poolremovedlog_indexblock_numberin_protocolIdblock_timestamptransaction_hash
0x44d33798dddcdabc93fe6a40c80588033dc502d30x369877467fc3b6774de4e11e0c0abbde70eb40fdfalse9176872102023-07-25T23:13:09.000Z0x0262976c98dca636d6c969d212db76f9c159b1f752ab440a823ffb3fcf3f5b49
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_base.YearnLinearPoolFactoryV2_YearnLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100