balancer_v2_optimism - Token Terminal Docs

Tables

AaveLinearPoolFactoryV2_FactoryDisabled_event

Event logs emitted when the Aave Linear Pool Factory V2 contract is administratively disabled on Balancer V2. Captures factory deactivation transactions for tracking operational status changes of the pool creation mechanism.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x994086630773dc6cb54d3a5e0ef0963532789e75	false	9	53309448	2022-12-22T06:00:47.000Z	0x7caaa5d95e44e87750bc0363991fa701304a9e810b4b1ceb40610e3acf87e026

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV2_PoolCreated_event

Balancer V2 pool creation events emitted by Aave Linear Pool Factory V2 contracts. Records the deployment of new Aave-integrated linear pools that enable yield-bearing liquidity provision on Balancer protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x994086630773dc6cb54d3a5e0ef0963532789e75	0x5d8955a2068ee6d1f7ab17640301219afa4b526f	false	4	20254496	2022-08-23T08:14:00.000Z	0xc098e1d221006b0024851d3e3da5f283a216041e6d23fc7e45164a15d58e1dba

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV3_AaveLinearPoolCreated_event

Event logs emitted when Balancer V2 Aave Linear Pool Factory V3 creates a new linear pool contract. Contains the deployed pool address and associated Aave protocol identifier for tracking liquidity pool deployments across DeFi integrations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xad3cc7852382c09fdce54784292c6ab7fb9df917	0x5936497ffe0dba0ef272d6301d65c0122862971a	false	9	46528034	0	2022-12-08T00:40:22.000Z	0xf40650ac932e7e9f54316861eff90f84896e66d59d79d8b9cd05eaf10231fa7d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV3_AaveLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV3_AaveLinearPoolProtocolIdRegistered_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV3_AaveLinearPoolProtocolIdRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV3_FactoryDisabled_event

Event log emitted when a Balancer V2 Aave Linear Pool factory contract is permanently disabled, preventing creation of new pools. Used for tracking factory lifecycle and protocol governance changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xad3cc7852382c09fdce54784292c6ab7fb9df917	false	23	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV3_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV3_PoolCreated_event

Event logs emitted when Balancer V2’s Aave Linear Pool Factory V3 creates a new liquidity pool integrated with Aave lending protocol. Records the deployed pool contract address and factory source for tracking pool deployment history.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xad3cc7852382c09fdce54784292c6ab7fb9df917	0x5936497ffe0dba0ef272d6301d65c0122862971a	false	4	46528034	2022-12-08T00:40:22.000Z	0xf40650ac932e7e9f54316861eff90f84896e66d59d79d8b9cd05eaf10231fa7d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV4_AaveLinearPoolCreated_event

Emitted when a Balancer V2 Aave linear pool is created by the factory contract, containing the pool address and protocol identifier for the Aave integration. Used for tracking pool deployment events across Balancer’s Aave-integrated liquidity strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f	false	9	73524746	0	2023-02-10T17:38:39.000Z	0x589b93f2ef59d5cbf790f8e9ce93f0e04a44d203ae083049e77e4847858119a0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV4_AaveLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV4_FactoryDisabled_event

Event emitted when a Balancer V2 Aave Linear Pool Factory V4 contract is disabled, halting creation of new linear pools. Contains transaction metadata and contract address for tracking factory lifecycle state changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843	false	26	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV4_PoolCreated_event

Pool creation events emitted by Balancer V2 Aave Linear Pool Factory V4 contracts. Contains factory contract address and newly created pool address for tracking Aave-integrated linear pool deployments across supported chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f	false	4	73524746	2023-02-10T17:38:39.000Z	0x589b93f2ef59d5cbf790f8e9ce93f0e04a44d203ae083049e77e4847858119a0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	0x45d37982784f022a9864748b4e8750e1e7019604	false	9	90010128	0	2023-04-13T19:59:35.000Z	0x4b585c98bd80aef1542c2b8fc2f6d991a46913f1fc9bc668d33f1cfc39678998

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	false	46	108572520	2023-08-22T22:36:57.000Z	0xcb326a8962d785160f17009be441e27eae181c68f7d43a11c932538b32a45c81

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	0x45d37982784f022a9864748b4e8750e1e7019604	false	4	90010128	2023-04-13T19:59:35.000Z	0x4b585c98bd80aef1542c2b8fc2f6d991a46913f1fc9bc668d33f1cfc39678998

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AaveLinearPoolFactoryV5_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AggregationRouterV3_AaveLinearPoolCreated_event

Aave Linear Pool creation events from Balancer V2’s Aggregation Router V3 on Optimism. Tracks when new boosted pools are deployed that integrate with Aave lending markets for yield-bearing liquidity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xad3cc7852382c09fdce54784292c6ab7fb9df917	0x5936497ffe0dba0ef272d6301d65c0122862971a	false	9	46528034	0	2022-12-08T00:40:22.000Z	0xf40650ac932e7e9f54316861eff90f84896e66d59d79d8b9cd05eaf10231fa7d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AggregationRouterV3_AaveLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AggregationRouterV3_FactoryDisabled_event

Factory disable events from Balancer V2’s Aggregation Router V3 contract on Optimism. Tracks when aggregation factories are disabled in the routing system, useful for monitoring protocol configuration changes and routing availability.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xad3cc7852382c09fdce54784292c6ab7fb9df917	false	23	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.AggregationRouterV3_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AggregationRouterV3_PoolCreated_event

Pool creation events from Balancer V2’s Aggregation Router V3 contract on Optimism. Tracks when new liquidity pools are deployed through the aggregation router, capturing pool addresses and deployment timestamps for monitoring protocol expansion.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xad3cc7852382c09fdce54784292c6ab7fb9df917	0x5936497ffe0dba0ef272d6301d65c0122862971a	false	4	46528034	2022-12-08T00:40:22.000Z	0xf40650ac932e7e9f54316861eff90f84896e66d59d79d8b9cd05eaf10231fa7d

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__owner`	`STRING`	Address of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string.
`in__spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount 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).

Sample Data

address	removed	in__owner	log_index	in__spender	block_number	block_timestamp	transaction_hash
0xa30992b40a0cb4b2da081ddbd843f9cce25c2fe3	false	0x99cf24f1934fc5f10efb0800f98996953ca8d11e	16	0x0000000000000000000000000000000000000001	115506413	2024-01-30T10:46:43.000Z	0x345dd1468f690cb3f91fa5bf6c4ff8dc6b3c2b35f69a0103c87f239a9bb42ea0
0xf27d53f21d024643d50de50183932f17638229f6	false	0x7db8ce0da046483c2cad137ebfa61133eea6bbc0	174	0x0000000000000000000000000000000000000001	111354267	2023-10-26T08:01:51.000Z	0x6e2e72216a395140879ee7ef86cc13642767c9003bb1a7e1682098ec84e4bff5
0xa30992b40a0cb4b2da081ddbd843f9cce25c2fe3	false	0x7db8ce0da046483c2cad137ebfa61133eea6bbc0	11	0x0000000000000000000000000000000000000001	111352885	2023-10-26T07:15:47.000Z	0x6ebacc890c15ca4365d75368615ef933f2e20ec29c77c9a2212469ec33058525

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount 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).

Sample Data

address	removed	in__user	in__value	log_index	block_number	block_timestamp	transaction_hash
0x97ff1e71620b7638bf82204763e5c04a6d554a40	false	0x18b2555b76a24ce30fe678d601da01d57c9f1879	14969009925597613871	2	103405834	2023-05-31T23:33:30.000Z	0xcc31c959bdf4b4de20cf2d1c87164334bf3d41a45ae46e129d5852069025a0bc
0xf27d53f21d024643d50de50183932f17638229f6	false	0xa93c4f71492065ee492b3d81a55ffedc95b2ad77	5403525649622357244	2	103392074	2023-05-31T22:11:06.000Z	0x762e5f211a33352d0a409960d7a997a56d367d0a555e327a27afab4e104f9317
0xf27d53f21d024643d50de50183932f17638229f6	false	0x5e18a3dcb5df855689118cc086dba7fb0c63bf54	10764118977400004273	2	103239654	2023-05-31T11:03:59.000Z	0xf1bafc07ed2d89e544fdb5b0674a71f5065d41351e6f5cb5c447c006fb5cac53

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount 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).

Sample Data

in__to	address	removed	in__from	in__value	log_index	block_number	block_timestamp	transaction_hash
0xc181edc719480bd089b94647c2dc504e2700a2b0	0x5669fb0dcfa758bf69fb3adab14578ede14cc89a	false	0x0000000000000000000000000000000000000000	60000000000000000000	74	113058992	2023-12-04T19:06:01.000Z	0x9cbb7f123bef6b78d355805c28ec2b1004bb67208167cdc49c8ce62f59b110b3
0xc181edc719480bd089b94647c2dc504e2700a2b0	0x5669fb0dcfa758bf69fb3adab14578ede14cc89a	false	0x0000000000000000000000000000000000000000	22340640923880814	51	113058992	2023-12-04T19:06:01.000Z	0x9cbb7f123bef6b78d355805c28ec2b1004bb67208167cdc49c8ce62f59b110b3
0xc181edc719480bd089b94647c2dc504e2700a2b0	0x5669fb0dcfa758bf69fb3adab14578ede14cc89a	false	0x0000000000000000000000000000000000000000	3572094462518230	63	113053088	2023-12-04T15:49:13.000Z	0x6843ba718bb981d2fed14feb76942f408dd1deb80841e78ca7427b189178ae68

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__original_balance`	`STRING`	User’s original balance in the liquidity gauge. String-encoded integer representing token amount in smallest unit.
`in__original_supply`	`STRING`	Total original token supply in the liquidity gauge. String-encoded integer representing token amount in smallest unit.
`in__working_balance`	`STRING`	User’s working balance in the liquidity gauge after applying boost multipliers. String-encoded integer representing token amount in smallest unit.
`in__working_supply`	`STRING`	Total working supply in the liquidity gauge after applying boost multipliers to all user balances. String-encoded integer representing token amount in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	block_timestamp	transaction_hash	in__working_supply	in__original_supply	in__working_balance	in__original_balance
0x317e0451da949ee999aac2d7bc063737f5fe84e5	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	33	113598268	2023-12-17T06:41:53.000Z	0x04c701097ec3428010c9560a562586e8f394b4ff0c49b077a3a8ef8e18a1ccb7	212222483334686993548	305499878253079028574	212221671013410490253	305497847449887770336
0x5669fb0dcfa758bf69fb3adab14578ede14cc89a	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	18	113586619	2023-12-17T00:13:35.000Z	0xa567e4f94e6dfa2044f08ce0f59ca4178643cef53223bd069618eb0311263eee	3381863896722838609997	4762918091482318349864	2910986838834510023248	3769899801461213686544
0x5669fb0dcfa758bf69fb3adab14578ede14cc89a	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	52	113586654	2023-12-17T00:14:45.000Z	0x1bfbb3210dcb5a6fbcbc05215b40417c90203f5f2a4d2401079574a823d030c5	3381936914901932159580	4763021161735054645663	2911059857013603572831	3770002871713949982343

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount 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).

Sample Data

address	removed	in__user	in__value	log_index	block_number	block_timestamp	transaction_hash
0x02ab6fe6b3af13b4f859001486dc75f2dac79026	false	0x708cd5150bf64791f14373cdc9b708bf1c03954c	44585375028404797091	24	108411760	2023-08-19T05:18:17.000Z	0x9419fb57d6441f4075c191540342a6b4626301d1b47cb7a493deace15280ddcb
0x32441cb2da08a3f4c63e29834e155c0434d50e6a	false	0x6ffa791fbe22fb518f222245e3daa5cc223739d0	174052708936286122545	11	108405946	2023-08-19T02:04:29.000Z	0x6f44207d8e836672980bb7b993b523adb0a32538b3f11a423e742ba20cd09bb9
0x32441cb2da08a3f4c63e29834e155c0434d50e6a	false	0xcae7d0dadafc547fd7b343d401afc0527478f76a	2967329242971348450	3	108402349	2023-08-19T00:04:35.000Z	0x2431c40a2859a0109f994c7c597191120723b6a8e3aaf9521dcea81c2e436191

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_gauge`	`STRING`	Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash
0xa523f47a933d5020b23629ddf689695aa94612dc	false	0xca64d546125852c00cb27eae3e1efe03d2439f03	6	109112584	2023-09-04T10:39:05.000Z	0x3549155832c9f891b253b08e2ed08a15e89bd0366c1a95ee6eee488bdf97e771
0xa523f47a933d5020b23629ddf689695aa94612dc	false	0x4496c59363397d655cbbbea2441c16c7b7e8c69b	0	99732504	2023-05-19T11:21:10.000Z	0xa82dcebe3097e8f46804421e53e75890439361df7148142f069c70b9d0eb2fa7
0xa523f47a933d5020b23629ddf689695aa94612dc	false	0x6da0597f0072428ea116f99047ba191afc66c533	0	102808322	2023-05-30T05:45:00.000Z	0x5bdb0394587cb109947029db43b9a9ff992bdaafd29b1c48be0d84dd34499626

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ChildChainGaugeFactory_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactory_FactoryDisabled_event

Event emitted when a Balancer V2 ComposableStablePoolFactory contract is administratively disabled, preventing creation of new composable stable pools. Used for tracking factory lifecycle and protocol governance actions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xf145cafb67081895ee80eb7c04a30cf87f07b745	false	10	53309448	2022-12-22T06:00:47.000Z	0x7caaa5d95e44e87750bc0363991fa701304a9e810b4b1ceb40610e3acf87e026

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactory_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactory_PoolCreated_event

Pool creation events emitted by Balancer V2 Composable Stable Pool factory contracts. Records the factory contract address and newly deployed pool address for tracking stable pool deployments across AMM (Automated Market Maker) protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xf145cafb67081895ee80eb7c04a30cf87f07b745	0x7d6bff131b359da66d92f215fd4e186003bfaa42	false	11	27814742	2022-10-06T13:17:52.000Z	0xffda1189b737400dd715db4e764c55e15232f6d3ee5c16aed729da5615b71748
0xf145cafb67081895ee80eb7c04a30cf87f07b745	0xde45f101250f2ca1c0f8adfc172576d10c12072d	false	11	23931372	2022-09-20T12:36:46.000Z	0xf2e86f4cac50530b95531bc74fd97a6d2216e62c38b1db4fbb0b2fba1793f5e6
0xf145cafb67081895ee80eb7c04a30cf87f07b745	0x428e1cc3099cf461b87d124957a0d48273f334b1	false	13	53201767	2022-12-22T01:03:06.000Z	0x1fd4e9d8b1eae24a6723fa3966e027b31999b4acd9672b019a8cc405d60751ed

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV2_FactoryDisabled_event

Event log emitted when a Balancer V2 Composable Stable Pool factory contract is disabled. Records the administrative action of deactivating the factory’s ability to create new pool instances.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x85a80afee867adf27b50bdb7b76da70f1e853062	false	2	61220873	2023-01-06T13:27:03.000Z	0xe9471a83adb4455b4f174b01f4bb84c1b4a6ace6853aaae2729408a5c3789ad0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV2_PoolCreated_event

Pool creation events emitted by Balancer V2 Composable Stable Pool Factory V2 contracts, recording the deployment address of each new stable pool. Used for tracking pool deployments and factory activity across Balancer V2 implementations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x373b347bc87998b151a5e9b6bb6ca692b766648a	false	7	43941882	2022-11-30T15:27:06.000Z	0x4e07aee77080dc6e868e4aa06e77ea58763277a0205f175df2b5c6fd2302f205

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV3_FactoryDisabled_event

Event logs emitted when Balancer V2 Composable Stable Pool Factory V3 contracts are disabled. Records the factory contract address and transaction context for tracking administrative changes to pool creation functionality across Balancer V2 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	false	25	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactoryV3_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV3_PoolCreated_event

Pool creation events emitted by Balancer V2 ComposableStablePoolFactoryV3 contracts. Records the deployment of new composable stable pools with their contract addresses for tracking liquidity pool lifecycle and inventory.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	0x43da214fab3315aa6c02e0b8f2bfb7ef2e3c60a5	false	11	80844244	2023-03-14T16:19:03.000Z	0x6409b38ffe5a647a44cabe322380ca81f37ffa4bead674bdb49bff96814a58bc
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	0x9bf7c3b63c77b4b4f2717776f15a4bec1b532a28	false	7	72867444	2023-02-08T04:06:34.000Z	0xd8f2f67de1b47767d461c44970719a13149ebff60cb26acb83a4d674d2b129bb
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	0x23ca0306b21ea71552b148cf3c4db4fc85ae1929	false	13	80480520	2023-03-13T07:09:36.000Z	0xe439ebe305d569a731a686aeea42a7b6303fc172968cf2c0d309f57be51852b9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV4_FactoryDisabled_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV4_PoolCreated_event

Event log emitted when a new composable stable pool is deployed by Balancer V2’s ComposableStablePoolFactoryV4 contract. Records the deployed pool address and factory contract address for tracking pool creation activity across Balancer V2 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x1802953277fd955f9a254b80aa0582f193cf1d77	0xe94c45de980f914904fdcfa9fbbe7c4a0ffe6ac7	false	21	105964535	2023-06-23T13:44:07.000Z	0x4b90ec3a47c6d88f2049de0b477d419caea2536333384d5e4e2a63b633c2baef
0x1802953277fd955f9a254b80aa0582f193cf1d77	0x64cee2338369aa9b36fc756ea231eb9bc242926f	false	29	105963738	2023-06-23T13:17:33.000Z	0xa156ca59c84c4f0ccc8021e4db43654986af749a360859624f68cd1356feeb3a
0x1802953277fd955f9a254b80aa0582f193cf1d77	0x11a4cf51bb0bb4d925cadfda61fcda952d64889c	false	7	82748215	2023-03-21T21:02:06.000Z	0x67229fb949215144e3d5cd677252665792bc1daf4181a1bfbe6da165209fe741

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x043a2dad730d585c44fb79d2614f295d2d625412	false	52	122253918	2024-07-04T15:23:33.000Z	0xfedb73b632f8a91cbbeafc97b682fedb25b8413216c9b5c252695f4bca8d571a

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x043a2dad730d585c44fb79d2614f295d2d625412	0x004700ba0a4f5f22e1e78a277fca55e36f47e09c	false	41	109853512	2023-09-21T14:16:41.000Z	0xec84415e72d181c613cf0425be8b5a5d6b01070426628e649243fcf66fc2a80f
0x043a2dad730d585c44fb79d2614f295d2d625412	0x4136e861e0ad0642cb2f16962540a7808bbade53	false	36	109843150	2023-09-21T08:31:17.000Z	0x7c6a87fa3f3b9b8b4783ba769503e12a7f8b7aaff9adc884f5567e3371303be9
0x043a2dad730d585c44fb79d2614f295d2d625412	0xc05ab1b0ad472ce802e2c8db6f23e4a2865fdca6	false	59	109843602	2023-09-21T08:46:21.000Z	0xe9a9be295b670690ba88704dcab544d87359a4be78e919c2ea10c2603367bf96

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ComposableStablePoolFactoryV5_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV2_PoolCreated_event

Pool creation events emitted by Balancer V2’s ERC4626 linear pool factory (version 2), recording the deployment of new ERC-4626 tokenized vault linear pools. Used for tracking factory-deployed pool inventory and analyzing pool creation patterns across Balancer-compatible protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x4c4287b07d293e361281bceee8715c8cdeb64e34	0xb5ad7d6d6f92a77f47f98c28c84893fbccc94809	false	4	35756921	2022-11-08T10:16:49.000Z	0xcd678c57cb5a53608ae2fc12646c8b0c6517a76519ce6a493ce9901ad15088fd
0x4c4287b07d293e361281bceee8715c8cdeb64e34	0xfbf87d2c22d1d298298ab5b0ec957583a2731d15	false	4	26486771	2022-09-30T12:47:18.000Z	0xc34a53365bc2e46f0ba0b60f625fb0eac23d7e833cc843ced61b982c52cf85d8
0x4c4287b07d293e361281bceee8715c8cdeb64e34	0x88d07558470484c03d3bb44c3ecc36cafcf43253	false	4	26486758	2022-09-30T12:47:03.000Z	0x57ab7208951338d8509a654373e4a344e0f0ebacfe4fcf50ca0d3e4d55d7a34a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ERC4626LinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

ERC-4626 (Tokenized Vault Standard) linear pool creation events emitted by Balancer V2 factory contracts. Contains pool address and protocol identifier linking the linear pool to its underlying ERC-4626 vault integration.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xf984eb2b8a7ef780245a797a2fccd82f346409ca	false	9	73010796	0	2023-02-08T20:28:02.000Z	0xe8f449195279a9adcd285cea7d94b6bf78d750a598b15b8b86a041e60ad50e60

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV3_FactoryDisabled_event

Event logs emitted when a Balancer V2 ERC-4626 (tokenized vault standard) linear pool factory is disabled. Captures the factory address and block metadata for tracking factory lifecycle state changes across Balancer deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	false	27	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ERC4626LinearPoolFactoryV3_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ERC4626LinearPoolFactoryV3_PoolCreated_event

ERC-4626 Linear Pool Factory version 3 pool creation events emitted when a new ERC-4626 linear pool is deployed through the Balancer V2 factory contract. Tracks the creation of yield-bearing linear pools that implement the ERC-4626 tokenized vault standard.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xf984eb2b8a7ef780245a797a2fccd82f346409ca	false	4	73010796	2023-02-08T20:28:02.000Z	0xe8f449195279a9adcd285cea7d94b6bf78d750a598b15b8b86a041e60ad50e60

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0xa5d4802b4ce6b745b0c9e1b4a79c093d197869c8	false	15	107297725	10	2023-07-24T10:23:47.000Z	0x80db4250dc0c160f0e65284793bcaf4131dc173e65b826edeaa84f67a582741d
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0x48ace81c09382bfc08ed102e7eadd37e3b049752	false	28	107298047	10	2023-07-24T10:34:31.000Z	0x6d7914c1dc99f5ac8f56c1acccbceb7176078509b1f3f0fa692081d89580edcb
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0x2e2b8b82123789d895fd79913f6dfa51f5b5a0e6	false	29	107297811	10	2023-07-24T10:26:39.000Z	0xf46158dfb343a6496267f1e676a3cb1d0fe7c4be2bdf092eb4774360d84427a9

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x7adbdabaa80f654568421887c12f09e0c7bd9629	false	44	108572520	2023-08-22T22:36:57.000Z	0xcb326a8962d785160f17009be441e27eae181c68f7d43a11c932538b32a45c81

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0xa5d4802b4ce6b745b0c9e1b4a79c093d197869c8	false	10	107297725	2023-07-24T10:23:47.000Z	0x80db4250dc0c160f0e65284793bcaf4131dc173e65b826edeaa84f67a582741d
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0x48ace81c09382bfc08ed102e7eadd37e3b049752	false	23	107298047	2023-07-24T10:34:31.000Z	0x6d7914c1dc99f5ac8f56c1acccbceb7176078509b1f3f0fa692081d89580edcb
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0x2e2b8b82123789d895fd79913f6dfa51f5b5a0e6	false	24	107297811	2023-07-24T10:26:39.000Z	0xf46158dfb343a6496267f1e676a3cb1d0fe7c4be2bdf092eb4774360d84427a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ERC4626LinearPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ManagedPoolFactory_FactoryDisabled_event

Event log emitted when a Balancer V2 ManagedPoolFactory contract is disabled, preventing creation of new managed pools. Used to track factory lifecycle and pool deployment restrictions across Balancer V2 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	false	22	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ManagedPoolFactory_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ManagedPoolFactory_PoolCreated_event

Event logs emitted by Balancer V2 ManagedPoolFactory contracts when new managed pools are deployed. Contains the deployed pool address and transaction metadata for tracking pool creation across Balancer V2 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	0x1f7c9d8ed305420aad47097a21af1ecd19b713c5	false	8	43724207	2022-11-30T03:38:22.000Z	0x0d55c3598202471c2cf285c133d9dcce74992d282fdcf35c91fc375a6dc289d8
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	0x150245f92f0b8d6f37c1f5c991f1873bb0d9f495	false	8	43727335	2022-11-30T03:47:37.000Z	0x69225743658757d0315388288657f718c7e8efc6c381531ca32b027c0c704f73
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	0x2d7f35e02446e1d03a86d889b07fb7693b5dab67	false	8	37843768	2022-11-13T16:22:38.000Z	0x87701c83811f3f861066a3974a87e801345cf8745c3c982a21bdd6cbd7072a66

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4	false	17	144027679	2025-11-20T15:55:35.000Z	0x617229364fc28790cd3980f1d8b2c31e0a47f2e0a144337101ed32a6bffd7d69

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4	0xb4af4fdd49da2a2ba9522eadcf86d407a69f19c8	false	9	90348647	2023-04-14T14:39:48.000Z	0xa6c8de5accb30361eb5c1fb33107ca741116da53887f3f1a29c791e80639011a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ManagedPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MetaStablePoolFactory_PoolCreated_event

Event logs emitted when a new MetaStable pool is deployed through Balancer V2’s MetaStable pool factory contract. MetaStable pools are designed for assets with known exchange rates that fluctuate within a narrow band, such as wrapped or derivative tokens.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xb08e16cfc07c684daa2f93c70323badb2a6cbfd2	0x4fd63966879300cafafbb35d157dc5229278ed23	false	9	18855471	2022-08-12T11:28:02.000Z	0xaf12c9e8283da70c78d86724f4881ad63ee290f00155932577a3e4a8e89e1632
0xb08e16cfc07c684daa2f93c70323badb2a6cbfd2	0x7b50775383d3d6f0215a8f290f2c9e2eebbeceb2	false	9	64419319	2023-01-11T15:36:05.000Z	0x33a4221bb960302ada64c74e8e96ac6f5f7607c84c0a5527de3e126dae06a43b

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xf302f9f50958c5593770fdf4d4812309ff77414f	false	18	144027679	2025-11-20T15:55:35.000Z	0x617229364fc28790cd3980f1d8b2c31e0a47f2e0a144337101ed32a6bffd7d69

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xf302f9f50958c5593770fdf4d4812309ff77414f	0xa94a92fc2ca0601481d5de357489ceaeba1c1dc6	false	9	77972728	2023-03-01T13:58:53.000Z	0xbb6441c4a71e08c179d748b2931c5849bec3c8cb711316502aae3f7f5a6cced7
0xf302f9f50958c5593770fdf4d4812309ff77414f	0xbea652aa29d38114e9d36f2a2e4167b13df68e73	false	10	80193913	2023-03-12T02:53:47.000Z	0x801c707991f1f9d5c5b26c7d3a4053fb4aea6b152604226d66f98e0951194c5d
0xf302f9f50958c5593770fdf4d4812309ff77414f	0x0503dd6b2d3dd463c9bef67fb5156870af63393e	false	10	72049859	2023-02-03T10:03:03.000Z	0x31828f5e91262215f00266b0136b86873586454376430096ba161be61269465f

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_enabled`	`BOOL`	Boolean flag indicating whether recovery mode or the collector is enabled.

Sample Data

address	removed	log_index	in_enabled	block_number	block_timestamp	transaction_hash
0x479a7d1fcdd71ce0c2ed3184bfbe9d23b92e8337	false	28	true	105977818	2023-06-23T21:06:53.000Z	0x3b5824e79a849a4adb836fb1986fcaf96e26c121073e06271ba6826498b71b94
0x9964b1bd3cc530e5c58ba564e45d45290f677be2	false	35	true	105977818	2023-06-23T21:06:53.000Z	0x3b5824e79a849a4adb836fb1986fcaf96e26c121073e06271ba6826498b71b94
0x1f131ec1175f023ee1534b16fa8ab237c00e2381	false	24	true	105977818	2023-06-23T21:06:53.000Z	0x3b5824e79a849a4adb836fb1986fcaf96e26c121073e06271ba6826498b71b94

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_swapFeePercentage`	`STRING`	Swap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_swapFeePercentage
0x2a67663642d083debca989b6e169c5e21c16a96a	false	0	23632804	2022-09-18T17:36:39.000Z	0xc4e5ae219eb28713276d83dd8b43026a5427f17f2755a7bc61e616f4643a287f	10000000000000000
0x1e5373ececb55fb16902ac0b4573b27e6fddc20d	false	0	30017339	2022-10-18T07:12:50.000Z	0x5fe42153265d3ec28ba13334f2fecb59364fd25f2e93b97f4a2d23edfa9b656b	7500000000000000
0xbf4f5e87d0b2f9ba735b7ab4e11bc30d65fab991	false	1	45975985	2022-12-06T09:19:28.000Z	0x69f05303418896e23f7e19c9df9d9a9c727fa249fc9013da5697f69c55ce6ffc	2500000000000000

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x4fd63966879300cafafbb35d157dc5229278ed23	0x76a81325e0bdc64d5f1e28ecf8f6881cbe32cd20	false	50382869654991856	34337312	2022-11-04T14:04:48.000Z	0x805213690e9ef652032a7a454beb045696a3dde69dc8f68a05970c93f9e25f3a
0x0000000000000000000000000000000000000000	0x4fd63966879300cafafbb35d157dc5229278ed23	0xb62f0578daf2549966d368b6381bdf06784a5fba	false	50662159002110316	34362655	2022-11-04T15:13:04.000Z	0x49dbfbdbc9c1bdf904021eac067bc1f7f91980f1fb982a77411fb668ae6a1540
0x0000000000000000000000000000000000000000	0x4fd63966879300cafafbb35d157dc5229278ed23	0xc63a6888cf3e6ff79d7fe3263487943ed08ea054	false	51789853788025201	34113253	2022-11-04T00:12:20.000Z	0x80de7f459e09567857bb936bfeb444ed11e91634390ba85df0f2d1a4ba34c2a9

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newFlashLoanFeePercentage`	`STRING`	New flash loan fee percentage for the Balancer protocol. String-encoded integer value representing the fee in basis points with 18 decimal places of precision.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newSwapFeePercentage`	`STRING`	New swap fee percentage for the protocol. 18-decimal fixed-point integer represented as a string, where 1e18 equals 100%.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newSwapFeePercentage
0xce88686553686da562ce7cea497ce749da109f9f	false	2	9162285	2022-05-27T22:09:17.000Z	0x8b4794efcc040593ca216fe4bede744887d5630e9c146a8e45fd84f1757ca3ad	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.ProtocolFeesCollector_SwapFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StablePoolFactory_PoolCreated_event

Pool creation events emitted by StablePoolFactory contracts on decentralized exchange (DEX) platforms. Records the deployment of new stable swap pools with their contract addresses and constituent token pairs for tracking liquidity pool initialization.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.StablePoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StablePoolFactoryV2_FactoryDisabled_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.StablePoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StablePoolFactoryV2_PoolCreated_event

Event log emitted by Balancer V2 StablePoolFactoryV2 contract when a new stable pool is deployed. Records the factory address, newly created pool address, and block metadata for tracking stable pool creation across Balancer V2 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xeb151668006cd04dadd098afd0a82e78f77076c3	0x3f16f0301b62015b926c3b559b645a5a0e19d8aa	false	4	64418363	2023-01-11T15:34:50.000Z	0x2b194c9b3338d55a96a82fa3ff2e86f7027466c999abf7823eae7c82f7e49da4
0xeb151668006cd04dadd098afd0a82e78f77076c3	0x6b704813007545df4f7e2c75ebc804d3a6317549	false	4	64409241	2023-01-11T15:17:50.000Z	0x3c3686425aed415fee38e5ac2453b2f46e51b8bfd69e1f3585be641a64a225cb
0xeb151668006cd04dadd098afd0a82e78f77076c3	0x373643b17cd80e37675c8c98ef774efe6ca0b4de	false	4	12865984	2022-06-24T01:49:53.000Z	0xf6b6c6e8d3428dbde7656fd26287f5c141db6ae4da66aebed7c5a0dbe5ee7f60

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.StablePoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

UnbuttonAaveLinearPoolFactory_PoolCreated_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.UnbuttonAaveLinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_AuthorizerChanged_event

Balancer Vault authorizer change events emitted when the protocol’s permission controller contract address is updated. Records the new authorizer contract address responsible for managing access control to vault functions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newAuthorizer`	`STRING`	Address of the new authorizer contract set for the Balancer vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_newAuthorizer	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	7	97231742	2023-05-10T11:40:09.000Z	0xacf05be5134d64d150d153818f8c67ee36996650	0xf92b7510cf8c19c5e1d1fbd66e9824255e2f186348138c41d9308eda3814b5df
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0	7003431	2022-05-03T21:43:47.000Z	0xa331d84ec860bf466b4cdccfb4ac09a1b43f3ae6	0xa03cb990595df9eed6c5db17a09468cab534aed5f5589a06c0bb3d19dd2f7ce9

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xf27d53f21d024643d50de50183932f17638229f6	106754463045962	0x300d1c0700f14f486aa67779d9f216cb7a600a66	927	110830441	0x03f1ab8b19bce21eb06c364aec9e40322572a1e9	2023-10-14T05:00:59.000Z	0x0d3761dde1d6b2c8d44459a825821c343e95f74097dc0c01f96fd403038c2f7b
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x38f79beffc211c6c439b0a3d10a0a673ee63afb4	2805177581606383	0x939035097adb542b53b56e586deaafa27e8a6566	7	110849643	0x03f1ab8b19bce21eb06c364aec9e40322572a1e9	2023-10-14T15:41:03.000Z	0x4575187951088d3044011adfebab38bfc6b39b9b316371c7d7a9bc356304ed70
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x38f79beffc211c6c439b0a3d10a0a673ee63afb4	2974751372756504	0xf86c596b19fe64448b33fef3422c1928f20ed7de	142	110849448	0x03f1ab8b19bce21eb06c364aec9e40322572a1e9	2023-10-14T15:34:33.000Z	0x44f26c6e31ff78f6961e1245c31b79869c1fdb52cb19b799e143bdba58efaf29

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	2872238283	19	113588184	0x0825b2f46dbba2d05cfc1879fe91e2b360733766	2023-12-17T01:05:45.000Z	0xca521bfc21975646b1f5efec0e976fc1dfca3434e280bb51c34643d60dd15429
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x4200000000000000000000000000000000000006	60000000000000000000	46	113588221	0x0d20d9ee0335686f4e2b8fbc85283e31b2b7785e	2023-12-17T01:06:59.000Z	0x612403bd42d3a9336be6e3dc0e2fb973478d15a52d8ac9e78b2b2dbb99b14ee0
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x4200000000000000000000000000000000000006	60000000000000000000	63	113597357	0x0d20d9ee0335686f4e2b8fbc85283e31b2b7785e	2023-12-17T06:11:31.000Z	0xe177b4b2e2b911fa8bcab1a2658bcc3536468a697da22cd7c30d681d16007235

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_delta`	`STRING`	Change 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.

Sample Data

address	in_user	removed	in_delta	in_token	log_index	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	0x06f3252cd39287361613d0021292ce7bc0434cbd	false	-5972185362551235426	0xdd89c7cd0613c1557b2daac6ae663282900204f1	6	50031766	2022-12-15T12:06:09.000Z	0xcc26ec87bf718ddfe4a46feac4bd9ed566733eeeec0c78a2bdece376ebd2b296
0xba12222222228d8ba445958a75a0704d566bf2c8	0x06f3252cd39287361613d0021292ce7bc0434cbd	false	5972185362551235426	0xdd89c7cd0613c1557b2daac6ae663282900204f1	2	50031766	2022-12-15T12:06:09.000Z	0xcc26ec87bf718ddfe4a46feac4bd9ed566733eeeec0c78a2bdece376ebd2b296
0xba12222222228d8ba445958a75a0704d566bf2c8	0x0c3fa66e7454c9d6644bdc3c882903c44bc76318	false	51589959189125120	0xdd89c7cd0613c1557b2daac6ae663282900204f1	2	49781558	2022-12-15T03:15:55.000Z	0x8ae86d098240fcdd829ca58938c9cacaea98201cf1b6ccd302b51058654c13c4

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_paused`	`BOOL`	Boolean flag indicating whether the paused state is active. True indicates the contract or program is paused, false indicates it is active.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_deltas`	`ARRAY<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_protocolFeeAmounts`	`ARRAY<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.

Sample Data

address	removed	in_deltas	in_poolId	in_tokens	log_index	block_number	block_timestamp	transaction_hash	in_liquidityProvider	in_protocolFeeAmounts
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“0”,“-4000000”]	0x39965c9dab5448482cf7e002f583c812ceb53046000100000000000000000003	[“0x4200000000000000000000000000000000000006”,“0x4200000000000000000000000000000000000042”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”]	2	15896310	2022-07-26T23:42:58.000Z	0xb0711b752438880a8ec660b32550968b24026b4b6f8b4b89afdfa484474a51a7	0x0b7c75a9689a84854256c7d5db7c87feb1bbbb8b	[“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“-10756409269”,“0”]	0x3dc09db8e571da76dd04e9176afc7feee0b89106000000000000000000000019	[“0x2e3d870790dc77a83dd1d18184acc7439a53f475”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“0xdfa46478f9e5ea86d57387849598dbfb2e964b02”]	2	15788591	2022-07-26T02:08:30.000Z	0x47f7f50bb66e00b672274323bb3801e17fe17b5e60ff0ad28b928c4fc3920fd2	0x0f1c872ffb923ecb5249bfa5f9234ef1d53b847c	[“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“0”,“-8000000000000000000”]	0x3dc09db8e571da76dd04e9176afc7feee0b89106000000000000000000000019	[“0x2e3d870790dc77a83dd1d18184acc7439a53f475”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“0xdfa46478f9e5ea86d57387849598dbfb2e964b02”]	2	15783906	2022-07-26T00:55:13.000Z	0x3ea08f26bf0b0337e55c8269928e3cc4f4e434195bee686cb778a86f4dc8be4b	0x9ef0ec7d2cdbb66bcfbd2d5bd41229bf71d69444	[“0”,“0”,“0”]

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_assetManager`	`STRING`	Contract address of the asset manager responsible for managing pool token balances. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_cashDelta`	`STRING`	Change in token balance available to the pool’s vault for immediate operations. String-encoded signed integer representing token units.
`in_managedDelta`	`STRING`	Change in token balance managed by the asset manager outside the vault’s immediate liquidity pool. String-encoded signed integer representing token units.

Sample Data

address	removed	in_token	in_poolId	log_index	block_number	in_cashDelta	block_timestamp	in_assetManager	in_managedDelta	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x9253d7e1b42fa01ede2c53f3a21b3b4d13239cd4000000000000000000000042	18	34802723	66385588541	2022-11-05T23:06:16.000Z	0x1491b1bcb8e5b6608a984a3b56ad783bb4c5df49	-66385588541	0xfa81e3c2ceee32c100a94a689a5fe434cd71f44b0ca9b70ed3d3177e16cd9a53
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x9253d7e1b42fa01ede2c53f3a21b3b4d13239cd4000000000000000000000042	15	34802723	0	2022-11-05T23:06:16.000Z	0x1491b1bcb8e5b6608a984a3b56ad783bb4c5df49	66385588541	0xfa81e3c2ceee32c100a94a689a5fe434cd71f44b0ca9b70ed3d3177e16cd9a53
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x61cbcb4278d737471ee54dc689de50e4455978d8	0x9253d7e1b42fa01ede2c53f3a21b3b4d13239cd4000000000000000000000042	4	34802723	0	2022-11-05T23:06:16.000Z	0x1491b1bcb8e5b6608a984a3b56ad783bb4c5df49	-66140602556	0xfa81e3c2ceee32c100a94a689a5fe434cd71f44b0ca9b70ed3d3177e16cd9a53

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_poolAddress`	`STRING`	Contract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_specialization`	`INT64`	Pool 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).

Sample Data

address	removed	in_poolId	log_index	block_number	in_poolAddress	block_timestamp	transaction_hash	in_specialization
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb9f8d92fae343ee3880f3cdded160538bc575560000200000000000000000013	2	11189352	0xb9f8d92fae343ee3880f3cdded160538bc575560	2022-06-10T22:03:21.000Z	0x47c49f856d9a540568ea40b0c375ca545998e9966f328d2cbd1088724f409697	2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb0de49429fbb80c635432bbad0b3965b2856017700010000000000000000004e	1	25922732	0xb0de49429fbb80c635432bbad0b3965b28560177	2022-09-28T07:06:23.000Z	0xe06da3a13ba60443ecdd165bb8febe222db419c48bded54eb83afa2328ce97f8	1
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xa4e597c1bd01859b393b124ce18427aa4426a87100000000000000000000004c	1	25916457	0xa4e597c1bd01859b393b124ce18427aa4426a871	2022-09-28T06:32:44.000Z	0xc05e4590269cdb80e486866cb4526e9aca7c06eccb736c68818d57d650535595	0

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_approved`	`BOOL`	Boolean flag indicating whether approval was granted or revoked for the operation.

Sample Data

address	removed	in_sender	in_relayer	in_approved	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x7472c48649d797e06022f28f4a8f58cb1c001b27	0x03f1ab8b19bce21eb06c364aec9e40322572a1e9	true	113063564	2023-12-04T21:38:25.000Z	0x5c481f23a6dfb71f90018b23a36fa7a421aef477de15eb02bf0f92decb842b32
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x53c76edeb3b27ba1b14faad18adfc6b17408c471	0x03f1ab8b19bce21eb06c364aec9e40322572a1e9	true	113062761	2023-12-04T21:11:39.000Z	0x8c387d2c880fb61ad5a59d1c198663de44f3eb5cdf70bee348c8e54457cfc311
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x63a02d5290ac0ea280f863b11a7e5d897a05461b	0x03f1ab8b19bce21eb06c364aec9e40322572a1e9	true	113063299	2023-12-04T21:29:35.000Z	0x5d0b526a88f364b11a92fa905f882780d126365d0d35e1d096b5386420f734c4

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.

Sample Data

address	removed	in_poolId	log_index	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xefb0d9f51efd52d7589a9083a6d0ca4de416c24900020000000000000000002c	11	0x4200000000000000000000000000000000000006	316796093333507544	0x00a35fd824c717879bf370e70ac6868b95870dfb	24367730	73658149268027082281	2022-09-21T21:29:02.000Z	0xd042748dda8f905498f787bad39686fa078bc99c16dd683b5f46b46c19e3d4c5
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xefb0d9f51efd52d7589a9083a6d0ca4de416c24900020000000000000000002c	6	0x4200000000000000000000000000000000000006	373751346252945525	0x00a35fd824c717879bf370e70ac6868b95870dfb	24092044	86464764644805840886	2022-09-21T04:03:39.000Z	0xf815384d8f1470681cd7191a5a1124b1ded35abb708ec842a0c19e8f1196497e
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xefb0d9f51efd52d7589a9083a6d0ca4de416c24900020000000000000000002c	6	0x4200000000000000000000000000000000000006	396133776577676303	0x00a35fd824c717879bf370e70ac6868b95870dfb	24367771	90769562059487363059	2022-09-21T21:29:02.000Z	0x84aebb8a3a34d14b540bea1e4b08223378ca4caf95b5140fa3486030f670acbe

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_assetManagers`	`ARRAY<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.

Sample Data

address	removed	in_poolId	in_tokens	log_index	block_number	block_timestamp	in_assetManagers	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xaf5e0b5425de1f5a630a8cb5aa9d97b8141c908d00010000000000000000000e	[“0x10010078a54396f62c96df8532dc2b4847d47ed3”,“0x4200000000000000000000000000000000000006”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“0x97513e975a7fa9072c72c92d8000b0db90b163c5”]	2	10596467	2022-06-05T00:12:04.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x3bd59e39b7ffbb6e29bb34d8bab84d7f82f66437a0e54178913301fad6d92cde
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xc17636e36398602dd37bb5d1b3a9008c7629005f00010000000000000000000f	[“0x0994206dfe8de6ec6920ff4d779b0d950605fb53”,“0x4200000000000000000000000000000000000006”,“0x4200000000000000000000000000000000000042”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”]	2	10658972	2022-06-05T15:47:36.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x83c5f574c16335a363b832cbd89cdf0b7077a41efc297201998f64c833a70e8a
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xc23cd64318f917420bb0592bb18ea50437fa823e000200000000000000000060	[“0x4fd63966879300cafafbb35d157dc5229278ed23”,“0x7f5c764cbc14f9669b88837ca1490cca17c31607”]	3	30414334	2022-10-20T13:12:55.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x56fa1c27645207643910e7d2f61d2253e58c4b8b0b788c371be908a1201b95db

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.Vault_TokensRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPool2TokensFactory_PoolCreated_event

PoolCreated event logs emitted by the WeightedPool2TokensFactory contract when new two-token weighted pools are deployed on Balancer V2. Records factory contract address and newly created pool address for tracking pool deployments across DEX infrastructure.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x8175c3893a54238e0f1350075d17c177bf789a24	false	4	10586174	2022-06-04T20:10:45.000Z	0x2139bf186822c7625ae7dec36ca59062b7a13bc143f22d6b727a22515573250a
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x02b67e19eec23c4ef40f95735aa522f63c254cd8	false	4	50423008	2022-12-16T09:44:01.000Z	0x34cd34074b49e6cf6f095141d3577dc9234ffa9e8cd0448332736cf58010a21d
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0xa1039beb7a9aae096b41c4a8ad91efc8624d0279	false	4	34698019	2022-11-05T14:51:18.000Z	0xdbb667066832ce1bea61872392c5c940903c0c5ff939c545cba6a72e01007a4b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.WeightedPool2TokensFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactory_PoolCreated_event

Weighted pool creation events emitted by Balancer V2 factory contracts. Records the deployment of new weighted pools with factory address and newly created pool address.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	0xe37c8cd79b17c2173870e31586b4823c459f4abf	false	3	74378849	2023-02-14T23:05:08.000Z	0x9e6e3ddd261052457f1c2a8c98904d5ee3fbe23bde4c1c96bf87aabf3471c53f
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	0x7e0f700ace89af378446ed4a2a66f45a250c25ec	false	3	70416237	2023-01-25T20:24:46.000Z	0x75c315a5f6dd944cbe61e57e51dbeedbcea553ae96fa741b7dc583e959efb302
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	0x77ee88d816e35826e7955c462be33e8c5330aed1	false	3	10890696	2022-06-07T23:39:32.000Z	0xd4f804fe3bfa7e62c86c55482556c8119b27901990eba991ae123e2aecc20c51

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.WeightedPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV2_FactoryDisabled_event

Event logs emitted when a Balancer V2 WeightedPoolFactory contract is disabled, preventing creation of new weighted pools. Contains transaction metadata and contract address for tracking factory lifecycle state changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xad901309d9e9dbc5df19c84f729f429f0189a633	false	1	61220873	2023-01-06T13:27:03.000Z	0xe9471a83adb4455b4f174b01f4bb84c1b4a6ace6853aaae2729408a5c3789ad0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.WeightedPoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV2_PoolCreated_event

Event logs emitted when new weighted liquidity pools are created by Balancer V2 WeightedPoolFactory contracts. Records the factory contract address and newly deployed pool address for tracking pool deployments across Balancer-based decentralized exchanges.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xad901309d9e9dbc5df19c84f729f429f0189a633	0x899f737750db562b88c1e412ee1902980d3a4844	false	6	59597125	2023-01-03T13:50:45.000Z	0x6f6d491f971646cf700504539da0cda20acacab55a8f1c71ed0834dc8689da64
0xad901309d9e9dbc5df19c84f729f429f0189a633	0x3fdb6fb126521a28f06893f9629da12f7b7266eb	false	6	22524817	2022-09-09T15:15:15.000Z	0x1e8b0d1dc087b33c4b3b2a3d0f0ca97da09a0404edbe4ba068bd4c24feeeb5f5
0xad901309d9e9dbc5df19c84f729f429f0189a633	0xe0b50b0635b90f7021d2618f76ab9a31b92d0094	false	6	23102887	2022-09-14T11:04:45.000Z	0x0a0d86ee3a5daecf4e8638ea48318d7077ba9d144e1aebff1f40780ac5a7cd08

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.WeightedPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV3_FactoryDisabled_event

Event log emitted when a Balancer V2 Weighted Pool Factory V3 contract is disabled. Records factory contract deactivation for tracking protocol governance actions and factory lifecycle management.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xa0dabebaad1b243bbb243f933013d560819eb66f	false	24	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.WeightedPoolFactoryV3_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV3_PoolCreated_event

Pool creation events emitted by Balancer V2 WeightedPoolFactory V3 contracts. Records the address of newly deployed weighted liquidity pools from the factory contract.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xa0dabebaad1b243bbb243f933013d560819eb66f	0xbc99aa9bd55d3f8431ecec24da03aec1d6e62754	false	6	72866911	2023-02-08T04:01:12.000Z	0xb03349ebbdc7b30704d10edfee550125f49c56360c7b934234015d782bd4920c
0xa0dabebaad1b243bbb243f933013d560819eb66f	0xdc125d09891c5b6b66061e3170e9a1e1c5cf9be4	false	6	80842461	2023-03-14T16:09:30.000Z	0x613555ea3d328ba694f6c7e7b2937cde8bbd761155f8893258a6997b5fd356f5
0xa0dabebaad1b243bbb243f933013d560819eb66f	0x59aba93eb2fb1d12ae0a292d96655a13469417a0	false	6	82429794	2023-03-20T15:17:13.000Z	0x0a9123cfe4b8af5fef8ea1b26b6b5bd6f72efe09f2212264c3a2e48bff0b0b38

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x230a59f4d9adc147480f03b0d3fffecd56c3289a	false	16	144027679	2025-11-20T15:55:35.000Z	0x617229364fc28790cd3980f1d8b2c31e0a47f2e0a144337101ed32a6bffd7d69

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x230a59f4d9adc147480f03b0d3fffecd56c3289a	0x098f32d98d0d64dba199fc1923d3bf4192e78719	false	6	95053863	2023-04-28T16:01:03.000Z	0xec66d73ac83957253b95a1084c78670bca72a032e39bc1ee3202bee1735406af
0x230a59f4d9adc147480f03b0d3fffecd56c3289a	0x2f6b6973f38381fe453ea819b7e0f0897adeaae7	false	25	113128902	2023-12-06T09:56:21.000Z	0x36af5d2c38bb1edc33296f5d2cfdb1045c3f973ac964d78ccb799b1d3b102f08
0x230a59f4d9adc147480f03b0d3fffecd56c3289a	0xbc80540bb282e7724be7f1e0b92b4ea51340ddbf	false	11	112814684	2023-11-29T03:22:25.000Z	0x90e9866f195416d876618b5a69dbec732348a58c81df45df0224bfde2f479cf0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.WeightedPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YearnLinearPoolFactory_FactoryDisabled_event

Event logs emitted when a Yearn Linear Pool factory contract is disabled on Balancer V2. Contains transaction metadata and contract address for tracking factory lifecycle state changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xd8b6b96c88ad626eb6209c4876e3b14f45f8803a	false	28	99724055	2023-05-19T10:30:42.000Z	0xcf5f3aa6566fc6a6c56650d520c7473d9ddcd611e2c85f4a946910749e9a50b0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.YearnLinearPoolFactory_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YearnLinearPoolFactory_PoolCreated_event

Emitted when a new Yearn Linear Pool is created by the factory contract on Balancer V2. Contains the factory address and the newly deployed pool address, linking pool creation to transaction metadata.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xd8b6b96c88ad626eb6209c4876e3b14f45f8803a	0x81fc12c60ee5b753cf5fd0adc342dfb5f3817e32	false	4	74613729	2023-02-16T02:05:14.000Z	0x0a6fbcbd7edf5be43e009ca4fdd1b1aa4164db63172ee3d38e192b1a5e1d9d07

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.YearnLinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

YearnLinearPoolFactory_YearnLinearPoolCreated_event

Event logs emitted when a new Yearn linear pool is deployed by the Balancer V2 YearnLinearPoolFactory contract. Records the created pool address and associated Yearn protocol vault identifier for tracking Balancer-Yearn integration deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xd8b6b96c88ad626eb6209c4876e3b14f45f8803a	0x81fc12c60ee5b753cf5fd0adc342dfb5f3817e32	false	9	74613729	0	2023-02-16T02:05:14.000Z	0x0a6fbcbd7edf5be43e009ca4fdd1b1aa4164db63172ee3d38e192b1a5e1d9d07

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x19dfef0a828eec0c85fbb335aa65437417390b85	false	45	108572520	2023-08-22T22:36:57.000Z	0xcb326a8962d785160f17009be441e27eae181c68f7d43a11c932538b32a45c81

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x19dfef0a828eec0c85fbb335aa65437417390b85	0x34557ef500bfc060b8e3f2da58ef725bb7d32202	false	4	90034179	2023-04-13T22:20:42.000Z	0x34557a0e88eb7fdc37022de7563813f00755f17e67ed0de6fb5f3f8b68a8baf1

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0x19dfef0a828eec0c85fbb335aa65437417390b85	0x34557ef500bfc060b8e3f2da58ef725bb7d32202	false	9	90034179	0	2023-04-13T22:20:42.000Z	0x34557a0e88eb7fdc37022de7563813f00755f17e67ed0de6fb5f3f8b68a8baf1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_optimism.YearnLinearPoolFactoryV2_YearnLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

​Tables

​AaveLinearPoolFactoryV2_FactoryDisabled_event

​AaveLinearPoolFactoryV2_PoolCreated_event

​AaveLinearPoolFactoryV3_AaveLinearPoolCreated_event

​AaveLinearPoolFactoryV3_AaveLinearPoolProtocolIdRegistered_event

​AaveLinearPoolFactoryV3_FactoryDisabled_event

​AaveLinearPoolFactoryV3_PoolCreated_event

​AaveLinearPoolFactoryV4_AaveLinearPoolCreated_event

​AaveLinearPoolFactoryV4_FactoryDisabled_event

​AaveLinearPoolFactoryV4_PoolCreated_event

​AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event

​AaveLinearPoolFactoryV5_FactoryDisabled_event

​AaveLinearPoolFactoryV5_PoolCreated_event

​AggregationRouterV3_AaveLinearPoolCreated_event

​AggregationRouterV3_FactoryDisabled_event

​AggregationRouterV3_PoolCreated_event

​ChildChainGauge_Approval_event

​ChildChainGauge_Deposit_event

​ChildChainGauge_Transfer_event

​ChildChainGauge_UpdateLiquidityLimit_event

​ChildChainGauge_Withdraw_event

​ChildChainGaugeFactory_GaugeCreated_event

​ComposableStablePoolFactory_FactoryDisabled_event

​ComposableStablePoolFactory_PoolCreated_event

​ComposableStablePoolFactoryV2_FactoryDisabled_event

​ComposableStablePoolFactoryV2_PoolCreated_event

​ComposableStablePoolFactoryV3_FactoryDisabled_event

​ComposableStablePoolFactoryV3_PoolCreated_event

​ComposableStablePoolFactoryV4_FactoryDisabled_event

​ComposableStablePoolFactoryV4_PoolCreated_event

​ComposableStablePoolFactoryV5_FactoryDisabled_event

​ComposableStablePoolFactoryV5_PoolCreated_event

​ERC4626LinearPoolFactoryV2_PoolCreated_event

​ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV3_FactoryDisabled_event

​ERC4626LinearPoolFactoryV3_PoolCreated_event

​ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV4_FactoryDisabled_event

​ERC4626LinearPoolFactoryV4_PoolCreated_event

​ManagedPoolFactory_FactoryDisabled_event

​ManagedPoolFactory_PoolCreated_event

​ManagedPoolFactoryV2_FactoryDisabled_event

​ManagedPoolFactoryV2_PoolCreated_event

​MetaStablePoolFactory_PoolCreated_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

​Pool_RecoveryModeStateChanged_event

​Pool_SwapFeePercentageChanged_event

​Pool_Transfer_event

​ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

​ProtocolFeesCollector_SwapFeePercentageChanged_event

​StablePoolFactory_PoolCreated_event

​StablePoolFactoryV2_FactoryDisabled_event

​StablePoolFactoryV2_PoolCreated_event

​UnbuttonAaveLinearPoolFactory_PoolCreated_event

​Vault_AuthorizerChanged_event

​Vault_ExternalBalanceTransfer_event

​Vault_FlashLoan_event

​Vault_InternalBalanceChanged_event

​Vault_PausedStateChanged_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_RelayerApprovalChanged_event

​Vault_Swap_event

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPool2TokensFactory_PoolCreated_event

​WeightedPoolFactory_PoolCreated_event

​WeightedPoolFactoryV2_FactoryDisabled_event

​WeightedPoolFactoryV2_PoolCreated_event

​WeightedPoolFactoryV3_FactoryDisabled_event

​WeightedPoolFactoryV3_PoolCreated_event

​WeightedPoolFactoryV4_FactoryDisabled_event

​WeightedPoolFactoryV4_PoolCreated_event

​YearnLinearPoolFactory_FactoryDisabled_event

Tables

AaveLinearPoolFactoryV2_FactoryDisabled_event

AaveLinearPoolFactoryV2_PoolCreated_event

AaveLinearPoolFactoryV3_AaveLinearPoolCreated_event

AaveLinearPoolFactoryV3_AaveLinearPoolProtocolIdRegistered_event

AaveLinearPoolFactoryV3_FactoryDisabled_event

AaveLinearPoolFactoryV3_PoolCreated_event

AaveLinearPoolFactoryV4_AaveLinearPoolCreated_event

AaveLinearPoolFactoryV4_FactoryDisabled_event

AaveLinearPoolFactoryV4_PoolCreated_event

AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event

AaveLinearPoolFactoryV5_FactoryDisabled_event

AaveLinearPoolFactoryV5_PoolCreated_event

AggregationRouterV3_AaveLinearPoolCreated_event

AggregationRouterV3_FactoryDisabled_event

AggregationRouterV3_PoolCreated_event

ChildChainGauge_Approval_event

ChildChainGauge_Deposit_event

ChildChainGauge_Transfer_event

ChildChainGauge_UpdateLiquidityLimit_event

ChildChainGauge_Withdraw_event

ChildChainGaugeFactory_GaugeCreated_event

ComposableStablePoolFactory_FactoryDisabled_event

ComposableStablePoolFactory_PoolCreated_event

ComposableStablePoolFactoryV2_FactoryDisabled_event

ComposableStablePoolFactoryV2_PoolCreated_event

ComposableStablePoolFactoryV3_FactoryDisabled_event

ComposableStablePoolFactoryV3_PoolCreated_event

ComposableStablePoolFactoryV4_FactoryDisabled_event

ComposableStablePoolFactoryV4_PoolCreated_event

ComposableStablePoolFactoryV5_FactoryDisabled_event

ComposableStablePoolFactoryV5_PoolCreated_event

ERC4626LinearPoolFactoryV2_PoolCreated_event

ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV3_FactoryDisabled_event

ERC4626LinearPoolFactoryV3_PoolCreated_event

ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV4_FactoryDisabled_event

ERC4626LinearPoolFactoryV4_PoolCreated_event

ManagedPoolFactory_FactoryDisabled_event

ManagedPoolFactory_PoolCreated_event

ManagedPoolFactoryV2_FactoryDisabled_event

ManagedPoolFactoryV2_PoolCreated_event

MetaStablePoolFactory_PoolCreated_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

Pool_RecoveryModeStateChanged_event

Pool_SwapFeePercentageChanged_event

Pool_Transfer_event

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

ProtocolFeesCollector_SwapFeePercentageChanged_event

StablePoolFactory_PoolCreated_event

StablePoolFactoryV2_FactoryDisabled_event

StablePoolFactoryV2_PoolCreated_event

UnbuttonAaveLinearPoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_ExternalBalanceTransfer_event

Vault_FlashLoan_event

Vault_InternalBalanceChanged_event

Vault_PausedStateChanged_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_RelayerApprovalChanged_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPool2TokensFactory_PoolCreated_event

WeightedPoolFactory_PoolCreated_event

WeightedPoolFactoryV2_FactoryDisabled_event

WeightedPoolFactoryV2_PoolCreated_event

WeightedPoolFactoryV3_FactoryDisabled_event

WeightedPoolFactoryV3_PoolCreated_event

WeightedPoolFactoryV4_FactoryDisabled_event

WeightedPoolFactoryV4_PoolCreated_event

YearnLinearPoolFactory_FactoryDisabled_event

YearnLinearPoolFactory_PoolCreated_event

YearnLinearPoolFactory_YearnLinearPoolCreated_event

YearnLinearPoolFactoryV2_FactoryDisabled_event

YearnLinearPoolFactoryV2_PoolCreated_event