balancer_v2_ethereum - Token Terminal Docs

Tables

AaveLinearPoolFactory_PoolCreated_event

Pool creation events from Balancer V2’s Aave Linear Pool Factory on Ethereum. Tracks deployment of linear pools that integrate Aave lending positions, linking factory addresses to created pool addresses for analyzing 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.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xd7fad3bd59d6477cbe1be7f646f7f1ba25b230f8	0xa3823e50f20982656557a4a6a9c06ba5467ae908	false	49	13767310	2021-12-08T22:01:42.000Z	0x733415630fcc3fd8e03b1c203849ce3dbc7a8a08eec867f1005ea06c02adfdbf
0xd7fad3bd59d6477cbe1be7f646f7f1ba25b230f8	0x652d486b80c461c397b0d95612a404da936f3db3	false	119	13767470	2021-12-08T22:37:25.000Z	0xb399ba55bbc21d68d62e0a175ff78d5f8745e8db727516b3b6a7530880e059c1
0xd7fad3bd59d6477cbe1be7f646f7f1ba25b230f8	0xe6bcc79f328eec93d4ec8f7ed35534d9ab549faa	false	171	13767512	2021-12-08T22:48:19.000Z	0xb3341c9fcaed40316324e20f618fb7175665268b85f0273b5a019a7e2eb9066a

Example Query

Query with partition filter

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

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
0x6a0ac04f5c2a10297d5fa79fa6358837a8770041	false	356	16238162	2022-12-22T05:30:35.000Z	0xa39e2a39e5491034c711562036bc481eaebf429cb361dc6e27f47cd34d8e77b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x6a0ac04f5c2a10297d5fa79fa6358837a8770041	0x2f4eb100552ef93840d5adc30560e5513dfffacb	false	236	15366102	2022-08-18T16:38:54.000Z	0x63932a60115caad696834902f569a0e4037e9bafcd3d245326043ff81e4354b8
0x6a0ac04f5c2a10297d5fa79fa6358837a8770041	0x82698aecc9e28e9bb27608bd52cf57f704bd1b83	false	151	15367159	2022-08-18T20:41:34.000Z	0x2ec7b27334390bd3b01bb6968c70e9eac6d696677009d8132b7de4ac71f3a9b2
0x6a0ac04f5c2a10297d5fa79fa6358837a8770041	0xae37d54ae477268b9997d4161b96b8200755935c	false	154	15367176	2022-08-18T20:44:35.000Z	0x762e0d2b0bf6bdc561af983063c9fa2fe2eb1505b5298a229bc4ed76a0372bb3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x7d833fef5bb92ddb578da85fc0c35cd5cc00fb3e	0x454ed96955d04d2f5cdd05e0fd1c77975bfe5307	false	271	16179228	1	2022-12-14T00:02:47.000Z	0x81e200930e258e46d595cedfb5ef43267c692c5cb5f12f47ae098448ba4f29b1
0x7d833fef5bb92ddb578da85fc0c35cd5cc00fb3e	0x6a1eb2e9b45e772f55bd9a34659a04b6f75da687	false	158	16177902	1	2022-12-13T19:36:11.000Z	0xc2ecd6ecec849a3d2959620c625e34f844ad3805c3d5f2f30f3300b62dd383b2
0x7d833fef5bb92ddb578da85fc0c35cd5cc00fb3e	0x813e3fe1761f714c502d1d2d3a7cceb33f37f59d	false	276	16169944	0	2022-12-12T16:54:35.000Z	0x5ebcbab9eb41175b464fcf87f470a43eb8869c78900b49031449032b74f8347f

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x7d833fef5bb92ddb578da85fc0c35cd5cc00fb3e	0x454ed96955d04d2f5cdd05e0fd1c77975bfe5307	false	266	16179228	2022-12-14T00:02:47.000Z	0x81e200930e258e46d595cedfb5ef43267c692c5cb5f12f47ae098448ba4f29b1
0x7d833fef5bb92ddb578da85fc0c35cd5cc00fb3e	0x6a1eb2e9b45e772f55bd9a34659a04b6f75da687	false	153	16177902	2022-12-13T19:36:11.000Z	0xc2ecd6ecec849a3d2959620c625e34f844ad3805c3d5f2f30f3300b62dd383b2
0x7d833fef5bb92ddb578da85fc0c35cd5cc00fb3e	0x813e3fe1761f714c502d1d2d3a7cceb33f37f59d	false	271	16169944	2022-12-12T16:54:35.000Z	0x5ebcbab9eb41175b464fcf87f470a43eb8869c78900b49031449032b74f8347f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0x331d50e0b00fc1c32742f151e56b9b616227e23e	false	200	16600029	0	2023-02-10T18:04:59.000Z	0x03a375ae4403b5a429fe641d4276f3181c712ed7efe3b96d8dd3211640585125
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0xdc063deafce952160ec112fa382ac206305657e6	false	193	16778438	13	2023-03-07T19:16:35.000Z	0xdb69bf37464ffbcdb0bfc147576924ae77c0ce2f10befcd0b3bafde801dec432
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0xbfa413a2ff0f20456d57b643746133f54bfe0cd2	false	183	16778438	13	2023-03-07T19:16:35.000Z	0xf4d130be465062b487d82351f91c2f48b6927d4fff3ddad23d701562d8891c3e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	false	255	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0x331d50e0b00fc1c32742f151e56b9b616227e23e	false	195	16600029	2023-02-10T18:04:59.000Z	0x03a375ae4403b5a429fe641d4276f3181c712ed7efe3b96d8dd3211640585125
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0x3bb22fc9033b802f2ac47c18885f63476f158afc	false	426	16613434	2023-02-12T14:59:47.000Z	0x8c06b95b90695fadc54bbeb4490f48b9e53dc8889185550b1bdae985e0f39d04
0xb9f8ab3ed3f3acba64bc6cd2dca74b7f38fd7b88	0xfd11ccdbdb7ab91cb9427a6d6bf570c95876d195	false	168	16778438	2023-03-07T19:16:35.000Z	0xa16debe6f99062e7f90ce1a2009f3c56e14fb69cf3af543a86ba9f66dd42a7c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x0b576c1245f479506e7c8bbc4db4db07c1cd31f9	0x4ce277df0feb5b4d07a0ca2adcf5326e4005239d	false	125	17045360	0	2023-04-14T12:17:35.000Z	0xda940e86debbd0edcd4b845cbb8f9572603e84ac9072905121b85c30bd736ce2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x0b576c1245f479506e7c8bbc4db4db07c1cd31f9	false	254	17973271	2023-08-22T22:35:23.000Z	0xc8c47370e55c81e247562f7ed072ea60b1d3e1147b46a8d64418f4d74d439847

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x0b576c1245f479506e7c8bbc4db4db07c1cd31f9	0x4ce277df0feb5b4d07a0ca2adcf5326e4005239d	false	120	17045360	2023-04-14T12:17:35.000Z	0xda940e86debbd0edcd4b845cbb8f9572603e84ac9072905121b85c30bd736ce2

Example Query

Query with partition filter

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

ArbitrumRootGauge_Checkpoint_event

Checkpoint events from Balancer V2 Arbitrum root gauge contracts on Ethereum, recording periodic BAL token emission distributions to Arbitrum-based liquidity pools. Used for tracking cross-chain gauge reward allocations and analyzing incentive flows to Layer 2 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.
`in_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash	in_periodEmissions
0xc4b6cc9a444337b1cb8cbbdd9de4d983f609c391	false	157	19179810	1706745600	2024-02-08T00:12:47.000Z	0x53802b5715dfefc900ec3092d7bd0054f83b23751bfe883b29f4f55db252e119	91592330468515696193
0x49f530b45ae792cdf5cbd5d25c5a9b9e59c6c3b8	false	61	19179810	1706745600	2024-02-08T00:12:47.000Z	0x53802b5715dfefc900ec3092d7bd0054f83b23751bfe883b29f4f55db252e119	167400925896213400002
0xa8d974288fe44acc329d7d7a179707d27ec4dd1c	false	121	19179810	1706745600	2024-02-08T00:12:47.000Z	0x53802b5715dfefc900ec3092d7bd0054f83b23751bfe883b29f4f55db252e119	169383850635095326722

Example Query

Query with partition filter

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

ArbitrumRootGauge_RelativeWeightCapChanged_event

Events tracking updates to relative weight caps on Balancer V2 Arbitrum root gauges on Ethereum mainnet. Used for monitoring governance changes to gauge voting power limits, with caps typically set at 2%, 10%, or 100% (represented as 18-decimal values).

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_new_relative_weight_cap`	`STRING`	New maximum weight cap for the gauge expressed as a decimal with 18 precision (wei format). Common values include 0.02 (20000000000000000), 0.1 (100000000000000000), and 1.0 (1000000000000000000) representing different cap percentages.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_new_relative_weight_cap
0x8f7a0f9cf545db78bf5120d3dbea7de9c6220c10	false	97	17328939	2023-05-24T12:07:11.000Z	0x453a3015ff09b21f4e6ff1bcbd2cdc9f8851ab7cdda717d079f97d49b87377a1	20000000000000000
0x4215a70b944ffae8d8db3c9d5d73749370372387	false	316	18171930	2023-09-19T19:06:11.000Z	0xea73a34f96b5f6921e8029d094a993043cbd9091e7900f7db96144778853ba72	1000000000000000000
0x66e9a9d0a35c6a368a66a432abd9db4fb248f212	false	149	18166329	2023-09-19T00:15:23.000Z	0x9489938638dd0ea6133bdbcce45af12fad0ca6011723c0a4263d8309ed30c10e	1000000000000000000

Example Query

Query with partition filter

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

ArbitrumRootGaugeFactory_GaugeCreated_event

Balancer V2 gauge creation events on Ethereum for Arbitrum liquidity pools, emitted by the ArbitrumRootGaugeFactory contract. Tracks new gauge deployments that enable BAL token emissions for cross-chain liquidity incentives on Arbitrum.

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
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	false	0xa1dde34d48868f9e0901592f2a97e20f76004059	267	18530420	2023-11-08T23:08:47.000Z	0x721d22d1423cb5a3cd3def23ea2c0b1cbbe24c706d79bbd770dfdfe210a2a40a
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	false	0xad2632513bfd805a63ad3e38d24ee10835877d41	224	16982403	2023-04-05T11:52:47.000Z	0x58d5270cb1dfb519529eedf129e8aaacd260eb79307c9fa91a4cc73c497ba271
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	false	0x3461841828e3c184f418de6d4267cc0761d96fc9	182	18263728	2023-10-02T15:25:11.000Z	0x3b711fcdb572593b62a641a8fae8095d2d76223f3d84fd2b33369ae2602daa6d

Example Query

Query with partition filter

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

AvalancheRootGauge_Checkpoint_event

Checkpoint events from Balancer V2’s Avalanche Root Gauge contract on Ethereum, recording periodic token emissions bridged to Avalanche. Used for tracking cross-chain liquidity mining reward distributions and analyzing emission schedules across weekly periods.

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_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash
0xb95397a17acbb5824535ebe69cd9dcf8fa7afc50	false	276	18830620	1696464000	2023-12-21T00:17:47.000Z	0x3d454055bfdee30b61f8d780e106f3a738e5255972f34a8ac0591259462c9843
0xb95397a17acbb5824535ebe69cd9dcf8fa7afc50	false	277	18830620	1697068800	2023-12-21T00:17:47.000Z	0x3d454055bfdee30b61f8d780e106f3a738e5255972f34a8ac0591259462c9843
0xb95397a17acbb5824535ebe69cd9dcf8fa7afc50	false	278	18830620	1697673600	2023-12-21T00:17:47.000Z	0x3d454055bfdee30b61f8d780e106f3a738e5255972f34a8ac0591259462c9843

Example Query

Query with partition filter

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

AvalancheRootGauge_RelativeWeightCapChanged_event

Events tracking changes to relative weight caps on Balancer v2 Avalanche root gauges, which control the maximum share of BAL token emissions a gauge can receive. Used for analyzing governance decisions around liquidity incentive distribution limits across Avalanche 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.
`in_new_relative_weight_cap`	`STRING`	New maximum relative weight cap for the gauge expressed as a decimal fraction in wei (18 decimals). Common values include 0.02 (20000000000000000) and 1.0 (1000000000000000000) representing governance-set limits on gauge voting power.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_new_relative_weight_cap
0xc7e5fe004416a96cb2c7d6440c28ae92262f7695	false	422	20112799	2024-06-17T16:48:23.000Z	0x49462601a4866a46ec72cbcb7b5cd155f1d46a13062b46f874a7d2cfe16e1aee	20000000000000000
0x2911d599c3494a416b27c144e4084a6617ca4ff0	false	239	19479627	2024-03-21T00:57:23.000Z	0x36c2bf70921aa1a843559926979864e86ee7d736d62f7a9264b453d1463c9dca	20000000000000000
0x78b67fdb0613bfd7063c030d9b2a0766a8fdd5e8	false	415	18314218	2023-10-09T16:51:11.000Z	0x5399f3612b92369b2dcd8eaf111c35ddc0ff2f341fc4466f4a7ad980d201e282	20000000000000000

Example Query

Query with partition filter

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

AvalancheRootGaugeFactory_GaugeCreated_event

Gauge deployment events from Balancer V2’s Avalanche Root Gauge Factory on Ethereum, recording when new cross-chain gauges are created to distribute BAL incentives to liquidity pools on Avalanche. Used for tracking gauge deployment history and analyzing Balancer’s cross-chain incentive 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_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
0x22625eedd92c81a219a83e1dc48f88d54786b017	false	0x78b67fdb0613bfd7063c030d9b2a0766a8fdd5e8	414	18314218	2023-10-09T16:51:11.000Z	0x5399f3612b92369b2dcd8eaf111c35ddc0ff2f341fc4466f4a7ad980d201e282
0x22625eedd92c81a219a83e1dc48f88d54786b017	false	0x80f392bf3fa6973c3e14bb276e04931ec12de05e	135	18314405	2023-10-09T17:28:47.000Z	0x2d1fa2ff243f8ab541ffe169d357beb65dde43bb11dd91fe20150727aa51d406
0x22625eedd92c81a219a83e1dc48f88d54786b017	false	0x40b4c2e260f803f868053789bd4a6c7edd1cdc39	186	18072076	2023-09-05T18:31:35.000Z	0xba5d274ce62cfc18af037940a5dc487ea1e373e75387b0ac40d0aef003399bd1

Example Query

Query with partition filter

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

BaseRootGauge_Checkpoint_event

Checkpoint events from Balancer V2 root gauges on Ethereum recording token emissions per period. Used for tracking liquidity mining rewards distribution across different gauge contracts over time.

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_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash	in_periodEmissions
0xbf8f01ebcf0a21c46d23ada2c86eb31c9965b2f0	false	619	18432397	1697673600	2023-10-26T05:46:11.000Z	0x81cc19dc9f1fb4166e7398e8e86425946c7bc15e294053145aa285030123b58b	2399348031156156393257
0xe9b2cb6836be07357bcb8144f398730d5ec268e9	false	643	18432397	1697673600	2023-10-26T05:46:11.000Z	0x81cc19dc9f1fb4166e7398e8e86425946c7bc15e294053145aa285030123b58b	212151030315890033509
0xed0bb13496ce24efff8f9734a9707d092d4be10c	false	655	18432397	1697673600	2023-10-26T05:46:11.000Z	0x81cc19dc9f1fb4166e7398e8e86425946c7bc15e294053145aa285030123b58b	11929850083778267223497

Example Query

Query with partition filter

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

BaseRootGaugeFactory_GaugeCreated_event

Gauge deployment events from Balancer V2’s root gauge factory contract on Ethereum, recording when new liquidity mining gauges are created. Used for tracking gauge deployments and analyzing Balancer’s incentive distribution expansion over time.

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
0x8e3b64b3737097f283e965869e3503aa20f31e4d	false	0xd31342887b2ebeec5e91d1df07d93250d55e9ca1	245	18208311	2023-09-24T21:23:11.000Z	0x7b9b847a54d1199501cf12aab7de0026de4247197f728225759004a52efd9aa7
0x8e3b64b3737097f283e965869e3503aa20f31e4d	false	0x156cc29c8dfa80821ed240c3ca4ba85103e10f2b	247	18467553	2023-10-31T03:51:59.000Z	0x1d069334ab045f35031bd066c75dc93968a6232eb0e8cfd43ba50b86fef9da5e
0x8e3b64b3737097f283e965869e3503aa20f31e4d	false	0xf6fa773b5e54f4bd20e09d806ab483d58dd55dcb	377	18467524	2023-10-31T03:45:59.000Z	0xd02e18b6fa21316fd8eed6661279ef69261f47e08625a6c595ebe8b46b111be1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.BaseRootGaugeFactory_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
0xf9ac7b9df2b3454e841110cce5550bd5ac6f875f	false	358	16238162	2022-12-22T05:30:35.000Z	0xa39e2a39e5491034c711562036bc481eaebf429cb361dc6e27f47cd34d8e77b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xf9ac7b9df2b3454e841110cce5550bd5ac6f875f	0x4c8d2e60863e8d7e1033eda2b3d84e92a6418020	false	46	16179085	2022-12-13T23:34:11.000Z	0x166f0ad6755208600fad3108c34cd93e0c02c4df87d82d5429c29c30d19bdd2d
0xf9ac7b9df2b3454e841110cce5550bd5ac6f875f	0x9fb771d530b0ceba5160f7bfe2dd1e8b8aa13403	false	300	16179074	2022-12-13T23:31:59.000Z	0x07a9237084118544a7f0816107947879f341cc90510aae495c07bffbb8fc17d6
0xf9ac7b9df2b3454e841110cce5550bd5ac6f875f	0x6a9603e481fb8f2c09804ea9adab49a338855b90	false	308	15831713	2022-10-26T10:41:11.000Z	0x0a1773f54edbf56066c08ea4b8620f49290a5d1220979d5c4064b40310c27dfe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	164	16348014	2023-01-06T13:22:35.000Z	0x9675b19253bc24bc4acd4fb2961eda5b9dcd7bdac78716d8ea375f18eade9c35

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	194	16083810	2022-11-30T15:51:47.000Z	0x8a92b6e8db14842aaf6a3c4de54627887798189a306243f6cb1387724fde96f7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xdba127fbc23fb20f5929c546af220a991b5c6e01	false	254	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xdba127fbc23fb20f5929c546af220a991b5c6e01	0x779d01f939d78a918a3de18cc236ee89221dfd4e	false	299	16784403	2023-03-08T15:23:11.000Z	0x8b33a68d510d50c37cdfbdbd49af07c1ad4126de20c70281cc1662a55c1a97e7
0xdba127fbc23fb20f5929c546af220a991b5c6e01	0x133d241f225750d2c92948e464a5a80111920331	false	25	16592498	2023-02-09T16:50:23.000Z	0x48b67fab33cce504f267e7e0fa0a0c409646476a4f5c7f79b5f5635f7edcf622
0xdba127fbc23fb20f5929c546af220a991b5c6e01	0x00c2a4be503869fa751c2dbcb7156cc970b5a8da	false	141	16592716	2023-02-09T17:34:23.000Z	0x54640b8a28d90ee1b68d8fb1f8225c7a33352b0c0c3177a11505283c6fed23bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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_ethereum.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
0xfada0f4547ab2de89d1304a668c39b3e09aa7c76	0xf57c794f42da72b38c8f610ff3b5e8502e48cbde	false	254	17381892	2023-05-31T22:44:35.000Z	0x7ea358e8e2b50ed7b9da63bd0af9063991976ee6dcd5195c75e69e3e4f4663c6
0xfada0f4547ab2de89d1304a668c39b3e09aa7c76	0x0bbc7b78ff8453c40718e290b33f1d00ee67274e	false	56	17435286	2023-06-08T11:26:23.000Z	0x6f56bd44d7602b7d1422624d4aee088f183613d1617fb11e7b74cba718c0c58e
0xfada0f4547ab2de89d1304a668c39b3e09aa7c76	0x5537f945d8c3fcfdc1b8deceebd220fad26afda8	false	222	16879139	2023-03-21T23:01:47.000Z	0x112d86c1cbe9451a65fa63edd4b0d7c009f93fbf32a06050d800ed1e4af46caa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xdb8d758bcb971e482b2c45f7f8a7740283a1bd3a	false	153	20163413	2024-06-24T18:44:47.000Z	0x7954662ac9e9e5eeb0cb8ffb5cb5c46170537e4589fc3544c47e3fec33ec61dd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xdb8d758bcb971e482b2c45f7f8a7740283a1bd3a	0x3fa8c89704e5d07565444009e5d9e624b40be813	false	210	17699498	2023-07-15T14:54:35.000Z	0xc396780a32ac12d9119b02048356ae37718500b8aa27fa4ae657779bdff089c6
0xdb8d758bcb971e482b2c45f7f8a7740283a1bd3a	0xc2b021133d1b0cf07dba696fd5dd89338428225b	false	172	17699462	2023-07-15T14:47:23.000Z	0xccfbabbc8c438a961f8f5d86e039f5ebd9956c6bb2751bee3620ba15d56f8d57
0xdb8d758bcb971e482b2c45f7f8a7740283a1bd3a	0x9a172e1cb0e99f7e6dcc4c52e4655e8f337d5c00	false	328	17699540	2023-07-15T15:02:59.000Z	0x20ed2bc44d2e63aae9a470c39b96d00fdf9852df9e5c733f771e910599d6f4ab

Example Query

Query with partition filter

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

ConvergentCurvePool_FeeCollection_event

Fee collection events from Balancer V2 Convergent Curve Pools on Ethereum, tracking accumulated and remaining base and bond token balances. Used for monitoring protocol fee accrual and liquidity provider revenue in yield-bearing liquidity 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.
`in_collectedBase`	`STRING`	Amount of base token (underlying collateral) fees collected by the protocol at this event, denominated in smallest unit (wei). Sample values show zero collections, indicating fees may accumulate before withdrawal or this event tracks remaining versus collected amounts.
`in_collectedBond`	`STRING`	Amount of bond tokens collected as fees from the Convergent Curve Pool during this event, denominated in the smallest unit of the bond token. Sample values show zero collections, indicating fees may accumulate before being claimed.
`in_remainingBase`	`STRING`	Amount of base token fees remaining uncollected in the pool at the time of this event, denominated in the smallest unit of the base token. This value represents accrued but not yet withdrawn protocol or LP fees from the Convergent Curve Pool.
`in_remainingBond`	`STRING`	Amount of bond tokens remaining uncollected in the Convergent Curve Pool after this fee collection event, denominated in the bond token’s smallest unit (wei). Represents accrued fees that have not yet been withdrawn by fee recipients.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_remainingBase	transaction_hash
0xce16e7ed7654a3453e8faf748f2c82e57069278f	false	296	13612632	2021-11-14T07:28:37.000Z	556148565618783290	0xe82acb673d3e86aee7dad6b67d65107cbc5610406a5a90e080a70585fea8be25
0x893b30574bf183d69413717f30b17062ec9dfd8b	false	373	13614202	2021-11-14T13:17:48.000Z	1062363917018694541490	0x89821f23a6489397a7e2ff5765774e10670f7368b17fe15a157a51321fe9f8a2
0x893b30574bf183d69413717f30b17062ec9dfd8b	false	376	13613268	2021-11-14T09:46:00.000Z	1062571172469220713860	0x81ba08fb6d7291ccbd2f19cf51810324da1e78cd08c3fe7b5aa9d60e166d4a07

Example Query

Query with partition filter

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

ConvergentCurvePool_onSwap_function

Swap execution events from Balancer V2 Convergent Curve pools on Ethereum, capturing token exchanges with pool balances, amounts, and calculated output values. Used for analyzing convergent curve pool pricing dynamics and liquidity provider performance.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_swapRequest`	`STRUCT<kind INT64, tokenIn STRING, tokenOut STRING, amount STRING, poolId STRING, lastChangeBlock STRING,` from`STRING,`to `STRING, userData STRING>`	Structured data object containing the parameters of a Balancer V2 swap request, including token addresses, amounts, pool ID, swap direction (kind), and last balance update block. Passed as input to the onSwap function when the vault executes a token swap through this convergent curve pool.
`in_currentBalanceTokenIn`	`STRING`	Current balance of the token being swapped into the pool at the time of the swap execution. Denominated in the smallest unit of the input token (wei for ETH-based tokens), typically in the quadrillions range for standard ERC20 tokens.
`in_currentBalanceTokenOut`	`STRING`	Current balance of the output token in the Convergent Curve pool at swap execution time. Value is denominated in the token’s smallest unit (wei for 18-decimal tokens).
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	out_anon0	signature	to_address	block_number	from_address	in_swapRequest	block_timestamp	transaction_hash	in_currentBalanceTokenIn	in_currentBalanceTokenOut
86837	true	21403	1248772150908385458	0x9d2c110c	0xa8d4433badaa1a35506804b43657b0694dea928d	12888960	0xba12222222228d8ba445958a75a0704d566bf2c8	{“to”:“0xc6426f1f046fd3c34e5fc24610327a3dd0fc8cfd”,“from”:“0xc6426f1f046fd3c34e5fc24610327a3dd0fc8cfd”,“kind”:0,“amount”:“1230000000000000000”,“poolId”:“0xa8d4433badaa1a35506804b43657b0694dea928d00020000000000000000005e”,“tokenIn”:“0xed279fdd11ca84beef15af5d39bb4d4bee23f0ca”,“tokenOut”:“0x9b44ed798a10df31dee52c5256dcb4754bcf097e”,“userData”:“0x00”,“lastChangeBlock”:“12887317”}	2021-07-24T12:24:02.000Z	0xb81bb350f3f9b990e11ccb84d93fb014af16307f6229273dee48bdd67a41f759	10178286793365495027875968	17552314469857710224892952
83885	true	21627	199030690443935399	0x9d2c110c	0x71628c66c502f988fbb9e17081f2bd14e361faf4	12887573	0xba12222222228d8ba445958a75a0704d566bf2c8	{“to”:“0x57a901ca3688d505234241d2d6f5a02ab41c0762”,“from”:“0x57a901ca3688d505234241d2d6f5a02ab41c0762”,“kind”:0,“amount”:“197040389748033311”,“poolId”:“0x71628c66c502f988fbb9e17081f2bd14e361faf4000200000000000000000078”,“tokenIn”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“tokenOut”:“0xb1cc77e701de60fe246607565cf7edc9d9b6b963”,“userData”:“0x00”,“lastChangeBlock”:“12887417”}	2021-07-24T07:07:18.000Z	0x87d03046d8969aff79ffa716dabdc4bfd54ac7a40eef7d69bc2ee4de501445d5	435161250291045947848737	424448058596074866068170
83885	true	21627	50504131939821707620	0x9d2c110c	0x71628c66c502f988fbb9e17081f2bd14e361faf4	12888551	0xba12222222228d8ba445958a75a0704d566bf2c8	{“to”:“0xa061d957861a99521487050752fccde513b7cb0d”,“from”:“0xa061d957861a99521487050752fccde513b7cb0d”,“kind”:0,“amount”:“50000000000000000000”,“poolId”:“0x71628c66c502f988fbb9e17081f2bd14e361faf4000200000000000000000078”,“tokenIn”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“tokenOut”:“0xb1cc77e701de60fe246607565cf7edc9d9b6b963”,“userData”:“0x00”,“lastChangeBlock”:“12888538”}	2021-07-24T10:51:44.000Z	0xfdf2941a9473bffa82a34f61cac27f0ad29466f4c0d612dda96406c636349c9a	435218732305454501901258	424592136808150616068903

Example Query

Query with partition filter

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

ConvergentPoolFactory_CCPoolCreated_event

Pool creation events from Balancer V2’s Convergent Curve Pool Factory on Ethereum, recording new pools with their bond token addresses. Used for tracking the deployment of specialized pools designed for trading fixed-term 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_bondToken`	`STRING`	Contract address of the bond token associated with this Convergent Curve pool deployment. Represents the yield-bearing asset (typically an Element Finance principal token) that pairs with the underlying asset in the pool.

Sample Data

address	in_pool	removed	log_index	block_number	in_bondToken	block_timestamp	transaction_hash
0xe88628700eae9213169d715148ac5a5f47b5dcd9	0xabb93e3787b984cb62dcd962af8732f52ff57586	false	140	14475529	0x21fb757c2d3a5c574e8721027c3d7a506d77b6b3	2022-03-28T15:44:08.000Z	0x1466328abbb475244a4130421087b4b36a3f34c6762b8c98a169789cc2a107f1
0xb7561f547f3207edb42a6afa42170cd47add17bd	0x6dd0f7c8f4793ed2531c0df4fea8633a21fdcff4	false	210	13550865	0x285328906d0d33cb757c1e471f5e2176683247c2	2021-11-04T14:55:28.000Z	0x9206b197aafc00c64040f299dae361b33d8ab7aa6920258b4ebaffea9e9fc277
0xe88628700eae9213169d715148ac5a5f47b5dcd9	0x7f4a33dee068c4fa012d64677c61519a578dfa35	false	523	15398483	0x09459654777bb2669ad8ad0b54e876d4b5ff77f4	2022-08-23T19:25:54.000Z	0xafe5f826a7e1b5fed86b52827f7dd22097d55380a855d68debcc3829137bac11

Example Query

Query with partition filter

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

ConvergentPoolFactory_PoolCreated_event

Pool creation events from Balancer V2’s Convergent Curve Pool factory contracts on Ethereum. Tracks deployment of new Convergent pools (Element Finance-style fixed-rate pools) with their contract addresses and creation timestamps for monitoring liquidity pool launches.

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
0xb7561f547f3207edb42a6afa42170cd47add17bd	0xa8d4433badaa1a35506804b43657b0694dea928d	false	58	12735535	2021-06-30T13:11:56.000Z	0xba7de25f3aad5673ce0cf108914e0994144e7e7aba2d11086747e9acbeb3cb5e
0xb7561f547f3207edb42a6afa42170cd47add17bd	0x893b30574bf183d69413717f30b17062ec9dfd8b	false	208	12736296	2021-06-30T15:58:00.000Z	0xa42828f28f06685678b089ceb7760e42ea9f9b4a1aec4ece5bb4c35a4eb7fae9
0xb7561f547f3207edb42a6afa42170cd47add17bd	0x10a2f8bd81ee2898d7ed18fb8f114034a549fa59	false	380	13224603	2021-09-14T15:16:09.000Z	0xfaae2ef79a63a7cd4533b17c07138ec1522d684aa2dfa5baa84698a1ea1ebced

Example Query

Query with partition filter

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

ConvergentPoolFactory_setGovFee_function

Governance fee adjustment transactions for Balancer v2 Convergent Pool Factory contracts on Ethereum. Captures administrative updates to protocol fee parameters, with fee values denominated in 18-decimal wei format (0.2 or 20% in sample data).

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

gas	value	status	gas_used	in_newFee	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
68802	0	true	45868	200000000000000000	0x278473fd	0xb7561f547f3207edb42a6afa42170cd47add17bd	12686346	0x422494292e7a9dda8778bb4ea05c2779a3d60f5d		2021-06-22T21:02:44.000Z	0x01e4e127ea2ea5f2fdd9b901fe5c71b80ca890f1ccca921e8d26dd3dd4683fc9
68769	0	true	45846	200000000000000000	0x278473fd	0xe88628700eae9213169d715148ac5a5f47b5dcd9	14315159	0x422494292e7a9dda8778bb4ea05c2779a3d60f5d		2022-03-03T16:41:34.000Z	0xecad4576ebe7647763e5b9be9565ca935e91d6a1c88799c275c42f39f549a9fe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.ConvergentPoolFactory_setGovFee_function`
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
0xe061bf85648e9fa7b59394668cfeef980aec4c66	0xb0f75e97a114a4eb4a425edc48990e6760726709	false	62	14570793	2022-04-12T12:54:04.000Z	0xe4b0f35cd2463354f6f0736dfd3838b2de2d59728d74e108c45873dfe4e3524a
0xe061bf85648e9fa7b59394668cfeef980aec4c66	0xc8c79fcd0e859e7ec81118e91ce8e4379a481ee6	false	52	14570763	2022-04-12T12:46:26.000Z	0xb99abe7a2a7e1d211f89fec95d25d75872df9123b09b8a8a12eabaf65cef5f44
0xe061bf85648e9fa7b59394668cfeef980aec4c66	0x8f4063446f5011bc1c9f79a819efe87776f23704	false	135	14570791	2022-04-12T12:53:55.000Z	0x27e67d3b1fa1ddb1b858133bfa7d39e091055d0043f31ec3d5986158ff4b1816

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	0xfef969638c52899f91781f1be594af6f40b99bad	false	333	16599925	0	2023-02-10T17:44:11.000Z	0x0185d2c92cd50d4315d37583cb8d82dd3dac9789cbd7234dc3f23f3c5012f97c
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	0x126e7643235ec0ab9c103c507642dc3f4ca23c66	false	118	16587836	14	2023-02-09T01:12:11.000Z	0xe0bbd852e45ceb45e86945c51081e7f24b143e1df275cf6de1ec0257df9f2df9
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	0x159cb00338fb63f263fd6f621df619cef71da954	false	153	16842259	8	2023-03-16T18:42:59.000Z	0xc3df4b903a371ef1c6796135b316dc99a4ab2accadb4e22beb1d9f28e48cfb58

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	false	256	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	0xfef969638c52899f91781f1be594af6f40b99bad	false	328	16599925	2023-02-10T17:44:11.000Z	0x0185d2c92cd50d4315d37583cb8d82dd3dac9789cbd7234dc3f23f3c5012f97c
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	0x126e7643235ec0ab9c103c507642dc3f4ca23c66	false	113	16587836	2023-02-09T01:12:11.000Z	0xe0bbd852e45ceb45e86945c51081e7f24b143e1df275cf6de1ec0257df9f2df9
0x67a25ca2350ebf4a0c475ca74c257c94a373b828	0xf22ff21e17157340575158ad7394e068048dd98b	false	269	16741493	2023-03-02T14:32:59.000Z	0x7d187532c6c132382f66b978fcb483315f370a2c72b35c3c815b36b72c7dffff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	0x9516a2d25958edb8da246a320f2c7d94a0dbe25d	false	110	17045882	0	2023-04-14T14:05:23.000Z	0x756e81cea4cf725c738bcef3852ad57687156b561574cad3e2956e6cb48da5e6
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	0x3fcb7085b8f2f473f80bf6d879cae99ea4de9344	false	72	17480142	8	2023-06-14T19:06:11.000Z	0x5ff97870685370bab3876a4335d28c42e24659064fe78b486d6fb1b37b992877
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	0xfa24a90a3f2bbe5feea92b95cd0d14ce709649f9	false	180	17677916	3	2023-07-12T13:55:59.000Z	0x104f1939e6fc2a1e20275005e699f18f5b32c6dda5f50ac7cc5219b4d21579c6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	false	251	17973271	2023-08-22T22:35:23.000Z	0xc8c47370e55c81e247562f7ed072ea60b1d3e1147b46a8d64418f4d74d439847

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	0xc50d4347209f285247bda8a09fc1c12ce42031c3	false	62	17677936	2023-07-12T14:00:11.000Z	0x7d2ea17e3bb746650b8c1d952cbeb770b0c84328258b21b7dcf5ea3d09540664
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	0xcfae6e251369467f465f13836ac8135bd42f8a56	false	438	17677939	2023-07-12T14:00:47.000Z	0x75438794cf3375da7bd02c38f79e93e184cff63f86fc7d8e1b770c8aefef76c4
0x813ee7a840ce909e7fea2117a44a90b8063bd4fd	0x2b218683178d029bab6c9789b1073aa6c96e5176	false	226	17677562	2023-07-12T12:44:47.000Z	0xd446c422f3c82f710f29b22eee0295403341f249cdd63110de817cc3436f12a8

Example Query

Query with partition filter

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

EulerLinearPoolFactory_EulerLinearPoolCreated_event

Events emitted when new Euler Linear Pools are created on Balancer V2 Ethereum, capturing pool addresses and protocol identifiers for tracking boosted pool deployments integrated with Euler Protocol lending markets.

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
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	0xdec02e6642e2c999af429f5ce944653cad15e093	false	164	16588079	0	2023-02-09T02:00:47.000Z	0xd639c8a6c3a553d47fd7f3d384ec4bc50a2cd6dfb2c3135b7f5db49d73c15df2
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	0xeb486af868aeb3b6e53066abc9623b1041b42bc0	false	345	16588127	5	2023-02-09T02:10:35.000Z	0x805bd2a49c425107392cc29ffeedfdab1a5edf7e15b7f411941f6a6a6ea5fab7
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	0x3c640f0d3036ad85afa2d5a9e32be651657b874f	false	215	16588122	5	2023-02-09T02:09:35.000Z	0x5a8109988bf3476042a9b22d0a30092b2c8ec90bcdb654ae0852c02b9ae70be2

Example Query

Query with partition filter

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

EulerLinearPoolFactory_FactoryDisabled_event

Factory disable events from Balancer V2’s Euler Linear Pool factory contract on Ethereum. Records when the factory was administratively disabled, preventing creation of new Euler-integrated linear 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
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	false	257	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

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

EulerLinearPoolFactory_PoolCreated_event

Pool creation events from Balancer v2’s Euler Linear Pool Factory on Ethereum, recording new yield-bearing linear pools that integrate with Euler Protocol. Used for tracking Euler-specific liquidity pool deployments and their corresponding pool 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
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	0xd4e7c1f3da1144c9e2cfd1b015eda7652b4a4399	false	334	16588117	2023-02-09T02:08:35.000Z	0x4a9ea683052afefdae3d189862868c3a7dc8f431d1d9828b6bfd9451a8816426
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	0xdec02e6642e2c999af429f5ce944653cad15e093	false	159	16588079	2023-02-09T02:00:47.000Z	0xd639c8a6c3a553d47fd7f3d384ec4bc50a2cd6dfb2c3135b7f5db49d73c15df2
0x5f43fba61f63fa6bff101a0a0458cea917f6b347	0x3c640f0d3036ad85afa2d5a9e32be651657b874f	false	210	16588122	2023-02-09T02:09:35.000Z	0x5a8109988bf3476042a9b22d0a30092b2c8ec90bcdb654ae0852c02b9ae70be2

Example Query

Query with partition filter

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

GearboxLinearPoolFactoryV2_FactoryDisabled_event

Factory deactivation events from Balancer V2’s Gearbox Linear Pool Factory on Ethereum, tracking when the factory contract was disabled from creating new liquidity 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
0x39a79eb449fc05c92c39aa6f0e9bfac03be8de5b	false	252	17973271	2023-08-22T22:35:23.000Z	0xc8c47370e55c81e247562f7ed072ea60b1d3e1147b46a8d64418f4d74d439847

Example Query

Query with partition filter

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

GearboxLinearPoolFactoryV2_GearboxLinearPoolCreated_event

Pool creation events from Balancer V2’s Gearbox Linear Pool Factory on Ethereum. Tracks when new linear pools integrating Gearbox Protocol yield-bearing tokens are deployed, used for monitoring liquidity pool launches and factory contract activity.

Columns

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

Example Query

Query with partition filter

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

GearboxLinearPoolFactoryV2_PoolCreated_event

Gearbox Linear Pool creation events from Balancer V2 factory contract on Ethereum, recording when new Gearbox-integrated liquidity pools are deployed. Used for tracking the expansion of Balancer’s Gearbox Linear Pool ecosystem and pool registry 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_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
0x39a79eb449fc05c92c39aa6f0e9bfac03be8de5b	0x0d05aac44ac7dd3c7ba5d50be93eb884a057d234	false	169	17052587	2023-04-15T13:04:11.000Z	0x9f8cb91df524d0592893bbab7ac6c53f3fb8a25dfea6e51765faad80e5152ef5

Example Query

Query with partition filter

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

GnosisRootGauge_Checkpoint_event

Checkpoint events from Balancer v2 Gnosis Root Gauge contracts recording BAL token emission distributions to Gnosis Chain gauges. Used for tracking cross-chain liquidity mining reward allocations and analyzing incentive distribution patterns across periods.

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_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash	in_periodEmissions
0x346f1d4f98f055bb0791465923e27a10f1082912	false	184	18630989	1700092800	2023-11-23T00:54:47.000Z	0x1ddb7fa80cbe39df39dc54b601f6445eb0dc716947a24531377b685ecaf13c1c	1747826760433272906951
0x41a8243656bcf628ac92189558f70d371dd08b4e	false	121	18630989	1700092800	2023-11-23T00:54:47.000Z	0x1ddb7fa80cbe39df39dc54b601f6445eb0dc716947a24531377b685ecaf13c1c	379182652172115491535
0xb1af0d75aeea1c13c450ffc7e12083072daf41eb	false	148	18630989	1700092800	2023-11-23T00:54:47.000Z	0x1ddb7fa80cbe39df39dc54b601f6445eb0dc716947a24531377b685ecaf13c1c	466937957665627965237

Example Query

Query with partition filter

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

GnosisRootGaugeFactory_GaugeCreated_event

Gauge deployment events from Balancer V2’s Gnosis Root Gauge Factory on Ethereum, recording when new liquidity mining gauges are created for cross-chain reward distribution. Used to track gauge deployments and analyze Balancer’s incentive system expansion 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_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
0x2a18b396829bc29f66a1e59fadd7a0269a6605e8	false	0x2617724db92a8dbd4eba7e24615ba369133ff684	215	18356091	2023-10-15T13:31:47.000Z	0x6726225077b651e485061feb6675f2d627708da0afaaac0d8a8d8412255f3978
0x2a18b396829bc29f66a1e59fadd7a0269a6605e8	false	0xd19b843b2318595a4d56d9ca3aaec593423a4156	338	18356092	2023-10-15T13:31:59.000Z	0x5bd2a0840b28e7922b06f76fef9cb8c6ed19f1aa92c305737213ccfdfe36e780
0x2a18b396829bc29f66a1e59fadd7a0269a6605e8	false	0x346f1d4f98f055bb0791465923e27a10f1082912	271	18356053	2023-10-15T13:24:11.000Z	0x19995668366391c0a3c53a4e4a2ee5ae7ad324e4037fea03b8143439c2e580f6

Example Query

Query with partition filter

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

InvestmentPoolFactory_PoolCreated_event

Investment pool creation events from Balancer V2’s InvestmentPoolFactory contract on Ethereum. Tracks new pool deployments with pool addresses and creation timestamps for monitoring protocol growth and liquidity 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
0x48767f9f868a4a7b86a90736632f6e44c2df7fa9	0x3b40d7d5ae25df2561944dd68b252016c4c7b280	false	265	13618508	2021-11-15T05:29:09.000Z	0xeb09dc88310030df2b1222b5014827808bf23ee733fbd8884c18bef374d5af53
0x48767f9f868a4a7b86a90736632f6e44c2df7fa9	0xe7b1d394f3b40abeaa0b64a545dbcf89da1ecb3f	false	164	13279333	2021-09-23T02:33:43.000Z	0x028236d35ebd2ee9482831963751b3f9633b8b0956f45c02a6abfb14e648df9e
0x48767f9f868a4a7b86a90736632f6e44c2df7fa9	0xccf5575570fac94cec733a58ff91bb3d073085c7	false	28	13486828	2021-10-25T13:15:34.000Z	0x6a20dde2b73657e4e583f7da7a3ddd65513e768097fc4e88634588852f6958b8

Example Query

Query with partition filter

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

LiquidityBootstrappingPoolFactory_PoolCreated_event

Liquidity Bootstrapping Pool (LBP) creation events emitted by Balancer V2 factory contracts. Records the deployment of new LBP pools with their contract addresses for tracking token launch 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
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	0xe11b6a3fa1e69ab2d9aa872701cfb32decec6d41	false	172	15404566	2022-08-24T18:52:17.000Z	0x900c5f9450e1b7bd36fb080ae0718e1d0240449ad917a8043d9e8b1a0d083d26
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	0xc79b9b75cd0e9567a000eeb8f6e46b3d074ac38c	false	229	13697150	2021-11-27T16:39:31.000Z	0x18f00ce27bb7b68d65eefcb66ad644bb626ef83caec9f9fb39744bffeafa5c51
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	0x1e8075178ad0bcb6e0668690d507cd7a90466e82	false	109	13621195	2021-11-15T15:46:53.000Z	0x763f0a03865199da211db4c39ef738b020c860d39b2c59358af9e50c00fc82f2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.LiquidityBootstrappingPoolFactory_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
0x9ac3e70db606659bf32d4bdfbb687ad193fd1f5b	false	253	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x9ac3e70db606659bf32d4bdfbb687ad193fd1f5b	0x1201faa7258a48b820619dd57cd8fdeb25d49b2c	false	424	15877531	2022-11-01T20:21:35.000Z	0x391643b28319e86f68c929ead226864745f9e20d672b50ee2152e1916fa73e0e
0x9ac3e70db606659bf32d4bdfbb687ad193fd1f5b	0x9d7a0b279512a4f55b3e8e3f1f72a284892c9530	false	440	16292010	2022-12-29T17:49:11.000Z	0xb27f3977f2736ca0400a74e5c2918e0ace8821085a1fa49120520555fb3d6448

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xbf904f9f340745b4f0c4702c7b6ab1e808ea6b93	false	195	23841253	2025-11-20T15:50:59.000Z	0x214e48f866c39a0aef255923ff3c22e25f9afc5ec70a8823e102e854d9595d1b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xbf904f9f340745b4f0c4702c7b6ab1e808ea6b93	0xd0cbf6765997b7ca7be6440f5e305b2ec7b96065	false	163	17046266	2023-04-14T15:24:59.000Z	0x649ac12525bbac417f312ac74849f44b2defd24f58128d305ebf32de3733f913
0xbf904f9f340745b4f0c4702c7b6ab1e808ea6b93	0xa3604999b3102ee4bfbeb0ae4b51f60d61cbe0a5	false	137	21889437	2025-02-20T18:45:35.000Z	0xc1aea8303e89d316918c6cb2884f72777faa42c46312b006d5d1c33201f6bc1a

Example Query

Query with partition filter

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

MerkleOrchard_DistributionClaimed_event

Token distribution claim events from Balancer V2’s MerkleOrchard contract on Ethereum, tracking when users claim rewards from merkle-based airdrops and liquidity mining programs. Useful for analyzing reward distribution patterns, claim timing, and recipient behavior across different token incentive campaigns.

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_distributor`	`STRING`	Address of the distributor contract responsible for managing the token distribution or reward allocation. 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_distributionId`	`STRING`	Unique identifier for a specific reward distribution within the MerkleOrchard contract. Sequential numeric IDs track individual distribution rounds for different tokens and time periods.
`in_claimer`	`STRING`	Address of the account initiating the claim transaction. 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	log_index	in_claimer	block_number	in_recipient	in_distributor	block_timestamp	transaction_hash	in_distributionId
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	false	0xba100000625a3754423978a60c9317c58a424e3d	2540307870000000000	14	0xeaa96b728b9fa8daae67782d997846eb5d3caf40	14906668	0xeaa96b728b9fa8daae67782d997846eb5d3caf40	0xd2eb7bd802a7ca68d9acd209bec4e664a9abdd7b	2022-06-05T02:42:41.000Z	0x81904a599ea034634d988bee35234e134aa68cae253fe80056447f3b4e08ac4b	77
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	false	0x43d4a3cd90ddd2f8f4f693170c9c8098163502ad	4500487700000000000	49	0x23b6d8e09cb33b1550de19ac25cc3f41ae4603bb	15220360	0x23b6d8e09cb33b1550de19ac25cc3f41ae4603bb	0xc38c5f97b34e175ffd35407fc91a937300e33860	2022-07-26T20:54:40.000Z	0xa2cc2b4398b011674fad1e3759ea2bfbec3ca2cc82723183326f587cf117a76d	7
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	false	0x43d4a3cd90ddd2f8f4f693170c9c8098163502ad	7416041300000000000	50	0x23b6d8e09cb33b1550de19ac25cc3f41ae4603bb	15220360	0x23b6d8e09cb33b1550de19ac25cc3f41ae4603bb	0xc38c5f97b34e175ffd35407fc91a937300e33860	2022-07-26T20:54:40.000Z	0xa2cc2b4398b011674fad1e3759ea2bfbec3ca2cc82723183326f587cf117a76d	8

Example Query

Query with partition filter

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

MerkleRedeem_Claimed_event

Token claim events from Merkle tree-based distribution contracts recording successful redemptions. Contains claimant address and claimed token balance for tracking airdrop and reward distribution execution.

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__claimant`	`STRING`	Address of the account claiming the tokens or rewards. Hex-encoded, 0x-prefixed, 42-character string.
`in__balance`	`STRING`	Token amount represented in smallest denomination. String-encoded integer value without decimal places.

Sample Data

address	removed	log_index	in__balance	block_number	in__claimant	block_timestamp	transaction_hash
0x6d19b2bf3a36a61530909ae65445a906d98a2fa8	false	258	66403815131304298802	12325240	0xea745c344e8198b602df3af937bcbf3a1d917817	2021-04-27T22:48:20.000Z	0x144f5e25280acbbcb0c12263361175aa800a683e37a2678006cff540608a3cac
0x6d19b2bf3a36a61530909ae65445a906d98a2fa8	false	260	25093051806074807785	12325112	0x346c48ff889501a968f1ab5256480baba010bbb5	2021-04-27T22:18:29.000Z	0x83284b9033b7297535cd98200672d78de2b6ecbfc1068a12c29d1ba18e949aba
0x6d19b2bf3a36a61530909ae65445a906d98a2fa8	false	260	127826056647999436677	12325243	0x36c39434db7987cae67233d06de9427c4c67e787	2021-04-27T22:49:35.000Z	0x283981048e99cb2058d875e9f8eb60758776fd9d95de2d8e6c942e4e4f1c5dc9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.MerkleRedeem_Claimed_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
0x67d27634e44793fe63c467035e31ea8635117cd4	0x8a34b5ad76f528bfec06c80d85ef3b53da7fc300	false	501	16492486	2023-01-26T17:28:47.000Z	0x5f79c73333e8a1e83fbd6773d582323b04a8d894f582c0bf165629c04df59954
0x67d27634e44793fe63c467035e31ea8635117cd4	0x831261f44931b7da8ba0dcc547223c60bb75b47f	false	134	16584685	2023-02-08T14:34:35.000Z	0xe1e1b5e7adac438724ef029eff8717ee8e7c34be7d4126b0a2f316a529f04f99
0x67d27634e44793fe63c467035e31ea8635117cd4	0x4d7880b18373fd916bbe63227509a187a41f8b62	false	2119	15924659	2022-11-08T10:16:59.000Z	0xf1ea507b23a9032a6c23f566f5fed0ea38244482671fe861ee244efea80e687d

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x597b9b5b0e8d4f7d708cb9ff81fc6fea695af2f8	false	247	17344108	2023-05-26T15:18:35.000Z	0xf5deed7c8132563ef1b70efa3d16a83127d627d3e2cc536d1852c2eb930cf80e
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x06419e7e010f073e1fa85027aaf9f0010499fc1b	false	398	15380792	2022-08-21T00:26:03.000Z	0x75a502c6e392651b9ce1bfcc84e6b8cc11bc18c024291ba9e013019ff8a9607f
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0xcb8b86fd454618f205dc8582974eb1e700687e23	false	99	15386294	2022-08-21T21:18:54.000Z	0x02216dea9d1ea027e7e13d5bc08fcd1f84f7a95ac1f4d7afe960062ae5809783

Example Query

Query with partition filter

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

OptimismRootGaugeFactory_GaugeCreated_event

Events emitted when new liquidity gauge contracts are deployed on Optimism through Balancer v2’s root gauge factory on Ethereum. Used to track cross-chain gauge creation for veBAL voting and liquidity mining rewards distribution.

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
0x866d4b65694c66fbfd15dd6fa933d0a6b3940a36	false	0x20d03f9d0304744891881e6ac1d45b996e7f39b5	166	18477804	2023-11-01T14:19:11.000Z	0x725f026597f844128ca2b8b211e389b9e180293dd669f3e3645a1b74303da7dc
0x866d4b65694c66fbfd15dd6fa933d0a6b3940a36	false	0x0a2738a1eeada91da6d5375a2e6f620c85c287f3	344	18263313	2023-10-02T14:01:35.000Z	0x2d30034fda2a63e0458456baa9300ae5898e240d33b47630f8e7c296694805f9
0x866d4b65694c66fbfd15dd6fa933d0a6b3940a36	false	0xec2087fda4c00d75f0a7d6c3acfde840347f673f	251	17545011	2023-06-23T21:42:11.000Z	0x82a63ed730a1a5e71bf2c5350281ea3d63d33bb87bb824c42d14c465f0f3e2f6

Example Query

Query with partition filter

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

PolygonRootGauge_Checkpoint_event

Checkpoint events from Balancer v2 Polygon Root Gauge contracts on Ethereum recording weekly token emission snapshots bridged to Polygon. Tracks BAL token distribution amounts and period timestamps for cross-chain liquidity mining reward analysis.

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_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash	in_periodEmissions
0xc9cd2b2d8744eb1e5f224612bd7dbe7bb7d99b5a	false	155	16139122	1669852800	2022-12-08T09:32:59.000Z	0xabf4fff519f4763b81de624d94e18e002fc997848bf237ca5314bde3685fb83e	938778142309570727348
0xb34d43ada4105ff71e89b8b22a8b9562e78f01e3	false	130	16139122	1669852800	2022-12-08T09:32:59.000Z	0xabf4fff519f4763b81de624d94e18e002fc997848bf237ca5314bde3685fb83e	60847892419806809828
0x852580e3e1c0fd35de426c5481670c1772525265	false	68	19229653	1706745600	2024-02-15T00:05:47.000Z	0xa84cf7c09e4a1645da4263d8e2cc77c6b22d879429abfb145c950c0248f4412e	0

Example Query

Query with partition filter

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

PolygonRootGaugeFactory_GaugeCreated_event

Gauge deployment events from Balancer v2’s Polygon Root Gauge Factory on Ethereum, tracking creation of cross-chain liquidity mining gauges that bridge BAL token incentives to Polygon pools. Used for analyzing gauge deployment history and identifying new incentivized liquidity 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.
`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
0xa98bce70c92ad2ef3288dbcd659bc0d6b62f8f13	false	0x90437a1d2f6c0935dd6056f07f05c068f2a507f9	187	16581970	2023-02-08T05:27:35.000Z	0x5b1cf13eee61caf6b449e0936aaac5733d38746ad3ff1a252fa4f26f43f15a90
0xa98bce70c92ad2ef3288dbcd659bc0d6b62f8f13	false	0x539d6edbd16f2f069a06716416c3a6e98cc29dd0	84	17130087	2023-04-26T11:25:23.000Z	0x3edb8bdb1b27034578d3f9bc21446ab8d299617ceb58cc3f969acf1445618d38
0xa98bce70c92ad2ef3288dbcd659bc0d6b62f8f13	false	0xac03e4615e9a6a91536ff761d9645f39a82b3bc4	571	15498155	2022-09-08T18:28:37.000Z	0x2046bc12052758f8963a47b1bb8a143a2652f8e62710cf6aadfea4424bf9c373

Example Query

Query with partition filter

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

PolygonZkEVMRootGaugeFactory_GaugeCreated_event

Gauge deployment events from Balancer V2’s Polygon zkEVM Root Gauge Factory on Ethereum, recording when new liquidity mining gauges are created for cross-chain reward distribution. Used for tracking gauge lifecycle and analyzing Balancer’s multi-chain liquidity incentive 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_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
0x9bf951848288ccd87d06fac426150262cd3447de	false	0xce99399fb4de36056a6831b159572e271360ea40	123	17439789	2023-06-09T02:43:11.000Z	0x88ba452ecf261aa149485b86b684f53210f99776c4ba879a02c443ffebe294d5
0x9bf951848288ccd87d06fac426150262cd3447de	false	0xf7d515dc47d5bd57786494628ed766d6bf31cd39	116	17439792	2023-06-09T02:43:47.000Z	0x61370cb2658aae8578edc012a6931443bd5dda2e95836ea6b6000eda93eef8ae
0x9bf951848288ccd87d06fac426150262cd3447de	false	0x227534d3f9ae72cb5b31e1d0a27be1a2859c6cc8	163	17439795	2023-06-09T02:44:23.000Z	0x32362b1e5bf9213f5d59457ad7cc75347204ec4d9af6e96572f61028754a3e3b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.PolygonZkEVMRootGaugeFactory_GaugeCreated_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
0xa718042e5622099e5f0ace4e7122058ab39e1bbe	false	152	true	16818712	2023-03-13T11:15:59.000Z	0xd6172241de15a7c57bfabd3ea7cf8deeb5308e2778d981ca3bf3858923ae449a
0x50cf90b954958480b8df7958a9e965752f627124	false	154	true	16818712	2023-03-13T11:15:59.000Z	0xd6172241de15a7c57bfabd3ea7cf8deeb5308e2778d981ca3bf3858923ae449a
0xb5e3de837f869b0248825e0175da73d4e8c3db6b	false	156	true	16818712	2023-03-13T11:15:59.000Z	0xd6172241de15a7c57bfabd3ea7cf8deeb5308e2778d981ca3bf3858923ae449a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xd4154dc7709fe659c3ab167648374b1a327acca3	false	434	15090474	2022-07-06T18:08:21.000Z	0x7d329a3b43d031f81097b52e676b6e71332af2e4dc81747f8b9814d8e99a7431	25000000000000000
0xe779d385d71ed8c37b7554461a2684bc3fef4be6	false	254	15089711	2022-07-06T15:16:39.000Z	0x89717e559c7ab44cba12000ef86952208d76f4c907ddbe48572fb019df9e40c4	25000000000000000
0xffa3209e32658e48fcdfc0c918e4678d61ee07c1	false	109	15091450	2022-07-06T21:37:36.000Z	0x0e13bb8ae369d080994f8c02be2b841adfe3ab477d27b019be9801c6e83caedf	25000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	log_index	block_number	block_timestamp	transaction_hash
0xbf97af0d72df8f15d40726a3f6618346395f3e66	0x0b09dea16768f0799065c475be02919503cb2a35	0x0000000000000000000000000000000000000000	false	43916620921334713398	96	12523898	2021-05-28T16:29:16.000Z	0xae3597da3b78236d98a98d6bdb2ebd6e46ca9d5912eec1240c52a91b465f070e
0xac993a2cac36a17839d9d8f2642e7c506b193015	0x0b09dea16768f0799065c475be02919503cb2a35	0x0000000000000000000000000000000000000000	false	19260736148072279704	153	12522383	2021-05-28T10:51:50.000Z	0xdd11f967b647575c4293587bd9f4cecf250f653bbe8f34247e216613ca07c215
0x01985007dfe022dd0935de2e421e0c0e301fe225	0x0b09dea16768f0799065c475be02919503cb2a35	0x0000000000000000000000000000000000000000	false	4631349655698166438	251	12524973	2021-05-28T20:35:48.000Z	0xc5eaa77bf30c5940bcf69e6abf18f4d7b11266ec0efe9da9b24ae454008f1e4b

Example Query

Query with partition filter

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

PoolFactory_PoolCreated_event

Pool creation events emitted by factory contracts when new liquidity pools are deployed. Records the pool address, token pair or configuration parameters, and fee structure for tracking pool deployments across decentralized exchange 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
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x4fc2b79590a39775a5025f9a80285cec3e1f369e	false	76	15268901	2022-08-03T10:17:37.000Z	0xa8e4acbabccb133959ba1c07fe4149ff839016dc94e6ff256cb6057e33b24f5b
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x4a366d6a01784d0766f21b8553b7e54ad61cad4b	false	371	15269359	2022-08-03T12:07:12.000Z	0xbb31e91e1e93882251c480f4747668f5961b6ac8aa8385310e8f2458087a6505
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	0x2269301b32ed3d7d4f2396769952a0e84218ab63	false	314	15271817	2022-08-03T21:17:05.000Z	0x28db6258e698eb89f75e95cc24f0285c353b34a213ecc01146f5c045713c0e62

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.PoolFactory_PoolCreated_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_ethereum.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	232	13932914	2022-01-03T14:07:47.000Z	0x8e8005b4262bbe3dc128545956eba25af6de8cc1aa7da5d102f6d8d6f2b1b6c2	100000000000000000
0xce88686553686da562ce7cea497ce749da109f9f	false	170	14250148	2022-02-21T15:08:14.000Z	0xc421ff8642bdeb12dd0776015e1e7bcaa6c7430970c9079a14f2c2463d22c437	500000000000000000

Example Query

Query with partition filter

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

SiloLinearPoolFactory_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_ethereum.SiloLinearPoolFactory_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SiloLinearPoolFactory_PoolCreated_event

Pool creation events from Balancer V2’s Silo Linear Pool Factory on Ethereum, tracking when new Silo-integrated linear pools are deployed. Records factory address, newly created pool address, and deployment transaction details for monitoring liquidity pool launches.

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
0xfd1c0e6f02f71842b6fff7cdc7a017ee1fd3cdac	0x395d8a1d9ad82b5abe558f8abbfe183b27138af4	false	194	16886361	2023-03-22T23:20:59.000Z	0x59b3ee43960d2220a773fa7389e01030a77bb113a06a69c59a3c60f8ab98e898

Example Query

Query with partition filter

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

SiloLinearPoolFactory_SiloLinearPoolCreated_event

Pool creation events from Balancer V2’s Silo Linear Pool Factory on Ethereum, tracking when new linear pools integrating Silo Finance yield-bearing tokens are deployed. Used for monitoring pool launches and tracking the expansion of Balancer’s boosted pool ecosystem.

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
0xfd1c0e6f02f71842b6fff7cdc7a017ee1fd3cdac	0x395d8a1d9ad82b5abe558f8abbfe183b27138af4	false	199	16886361	0	2023-03-22T23:20:59.000Z	0x59b3ee43960d2220a773fa7389e01030a77bb113a06a69c59a3c60f8ab98e898

Example Query

Query with partition filter

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

SiloLinearPoolFactoryV2_FactoryDisabled_event

Factory disable events from Balancer V2’s Silo Linear Pool Factory on Ethereum, indicating when the factory contract was disabled from creating new pools. Used 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
0x4e11aeec21baf1660b1a46472963cb3da7811c89	false	255	17973271	2023-08-22T22:35:23.000Z	0xc8c47370e55c81e247562f7ed072ea60b1d3e1147b46a8d64418f4d74d439847

Example Query

Query with partition filter

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

SiloLinearPoolFactoryV2_PoolCreated_event

Pool creation events from Balancer V2’s Silo Linear Pool Factory on Ethereum. Tracks deployments of linear pools that integrate with Silo Finance for yield-bearing asset 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.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x4e11aeec21baf1660b1a46472963cb3da7811c89	0x74cbfaf94a3577c539a9dcee9870a6349a33b34f	false	151	17173186	2023-05-02T12:48:11.000Z	0x215c9f4256ab450368132f4063611ae8cdd98e80bea7e44ecf0600ed1d757018

Example Query

Query with partition filter

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

SiloLinearPoolFactoryV2_SiloLinearPoolCreated_event

Pool creation events from Balancer V2’s Silo Linear Pool Factory on Ethereum, tracking when new Silo-integrated linear pools are deployed with their addresses and protocol identifiers. Used for monitoring Silo protocol integration deployments and analyzing Balancer’s yield-bearing pool ecosystem 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.
`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
0x4e11aeec21baf1660b1a46472963cb3da7811c89	0x74cbfaf94a3577c539a9dcee9870a6349a33b34f	false	156	17173186	0	2023-05-02T12:48:11.000Z	0x215c9f4256ab450368132f4063611ae8cdd98e80bea7e44ecf0600ed1d757018

Example Query

Query with partition filter

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

StablePhantomPoolFactory_PoolCreated_event

Pool creation events emitted by Balancer V2 StablePhantomPoolFactory contracts. Records the deployment of stable phantom pools, which are composable stable pools that hold Balancer Pool Tokens (BPTs) alongside regular 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	0x7b50775383d3d6f0215a8f290f2c9e2eebbeceb2	false	84	13799690	2021-12-13T22:48:24.000Z	0x7484612f0429bfafad7c276fa5c8184ee23ec4d1ff20521b234fe71d4a241ec5
0xb08e16cfc07c684daa2f93c70323badb2a6cbfd2	0x4fd63966879300cafafbb35d157dc5229278ed23	false	185	13767526	2021-12-08T22:50:55.000Z	0x1e2ec897531a764bf84f6a89850e90f03ae748b71f0cc25763c3752a3f1e3d73
0xb08e16cfc07c684daa2f93c70323badb2a6cbfd2	0xd997f35c9b1281b82c8928039d14cddab5e13c20	false	255	14584121	2022-04-14T14:38:01.000Z	0xb9fecccb78ecfbbe2c355236450bcc6a71a3e2f8ba3a8efdd1d40363a268a6f0

Example Query

Query with partition filter

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

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xc66ba2b6595d3613ccab350c886ace23866ede24	0x06df3b2bbb68adc8b0e302443692037ed9f91b42	false	52	12769758	2021-07-05T20:52:40.000Z	0x73372ed8a5f49a4b390fbe99bf4a3f2129ec68bec0ea1d8890c48cbde26a8804
0xc66ba2b6595d3613ccab350c886ace23866ede24	0x9f19a375709baf0e8e35c2c5c65aca676c4c7191	false	154	12816304	2021-07-13T03:00:54.000Z	0xf47d270a921ec0ec283d8e93511ad019d14eebf2d365e1d350d5ad1adb538c5a
0xc66ba2b6595d3613ccab350c886ace23866ede24	0x6641a8c1d33bd3dec8dd85e69c63cafb5bf36388	false	150	14932410	2022-06-09T11:46:04.000Z	0x03753e27f36e795aa2b8ae5ea2c2eff6641e3afbd42f6eda3a7e95be97bcfb57

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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_ethereum.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
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0xf3aeb3abba741f0eece8a1b1d2f11b85899951cb	false	445	15443084	2022-08-30T22:55:26.000Z	0xfad13ca43729bda7327956c23233967dbd015d096bd192964dab0ae0f2926bff
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0x178e029173417b1f9c8bc16dcec6f697bc323746	false	26	14978072	2022-06-17T07:57:26.000Z	0x031f1efcf179c9b479f3be832e3065852ef2e0af051bb65f54275c2d20b547a2
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0x961764651931941f23cea5bab246607dc19ef224	false	147	16513492	2023-01-29T15:53:11.000Z	0x60189732fa4d1848ef415673f67db1c7e9ac9fa55f551ec8e9206979c675a2e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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_ethereum.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	3	12272146	2021-04-19T18:36:47.000Z	0xa331d84ec860bf466b4cdccfb4ac09a1b43f3ae6	0x28c44bb10d469cbd42accf97bd00b73eabbace138e9d44593e851231fbed1cb7
0xba12222222228d8ba445958a75a0704d566bf2c8	false	95	17229469	2023-05-10T10:40:11.000Z	0x6048a8c631fb7e77eca533cf9c29784e482391e7	0x8a7d86bef0c2571e52ea2f0ce129a8bf0c769bc0880fc911e7bf41644ad534b0

Example Query

Query with partition filter

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

Vault_batchSwap_function

Balancer V2 Vault batchSwap function call records on Ethereum, capturing multi-hop token swaps through Balancer liquidity pools with input amounts, pool routes, asset deltas, and slippage limits. Used for analyzing swap routing efficiency, arbitrage patterns, and cross-pool trading activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`in_swaps`	`ARRAY<STRUCT<poolId STRING, assetInIndex STRING, assetOutIndex STRING, amount STRING, userData STRING>>`	Array of swap operations executed sequentially in the batch, each specifying pool ID, asset indices, and amount for chained trades through Balancer V2 pools. Subsequent swaps use zero amounts, with actual quantities determined by prior swap outputs.
`in_assets`	`ARRAY<STRING>`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_funds`	`STRUCT<sender STRING, fromInternalBalance BOOL, recipient STRING, toInternalBalance BOOL>`	Fund transfer routing parameters for a swap operation. Struct containing sender address, recipient address, and boolean flags indicating whether to use internal balance for source (fromInternalBalance) and destination (toInternalBalance) of funds.
`in_limits`	`ARRAY<STRING>`	Maximum negative amounts allowed for each asset in the batch swap operation. Values represent slippage protection limits for assets being sold (positive deltas), with zero limits for assets being acquired.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`out_assetDeltas`	`ARRAY<STRING>`	Array of token balance changes for each asset in the swap, denominated in their native units (positive for tokens received, negative for tokens paid). Values correspond positionally to the in_assets array.

Sample Data

gas	status	gas_used	in_funds	in_swaps	in_assets	in_limits	signature	to_address	in_deadline	block_number	from_address	trace_address	block_timestamp	out_assetDeltas	transaction_hash
376042	true	287347	{“sender”:“0x220bda5c8994804ac96ebe4df184d25e5c2196d4”,“recipient”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“toInternalBalance”:false,“fromInternalBalance”:false}	[{“amount”:“850000000000”,“poolId”:“0x9210f1204b5a24742eba12f710636d76240df3d00000000000000000000000fc”,“userData”:“0x”,“assetInIndex”:“0”,“assetOutIndex”:“1”},{“amount”:“0”,“poolId”:“0x7b50775383d3d6f0215a8f290f2c9e2eebbeceb20000000000000000000000fe”,“userData”:“0x”,“assetInIndex”:“1”,“assetOutIndex”:“2”},{“amount”:“0”,“poolId”:“0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c0000000000000000000000fd”,“userData”:“0x”,“assetInIndex”:“2”,“assetOutIndex”:“3”}]	[“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0x9210f1204b5a24742eba12f710636d76240df3d0”,“0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	[“57896044618658097711785492504343953926634992332820282019728792003956564819967”,“0”,“0”,“0”]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	1654257851	14890874	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	1,1	2022-06-02T12:04:21.000Z	[“850000000000”,“0”,“0”,“-850984993088”]	0xce41d37c5775ab6b27c6864db2784054282edba4507add44d8ed36ee5511575c
379408	true	286147	{“sender”:“0x220bda5c8994804ac96ebe4df184d25e5c2196d4”,“recipient”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“toInternalBalance”:false,“fromInternalBalance”:false}	[{“amount”:“177227278627894741676147”,“poolId”:“0x804cdb9116a10bb78768d3252355a1b18067bf8f0000000000000000000000fb”,“userData”:“0x”,“assetInIndex”:“0”,“assetOutIndex”:“1”},{“amount”:“0”,“poolId”:“0x7b50775383d3d6f0215a8f290f2c9e2eebbeceb20000000000000000000000fe”,“userData”:“0x”,“assetInIndex”:“1”,“assetOutIndex”:“2”},{“amount”:“0”,“poolId”:“0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c0000000000000000000000fd”,“userData”:“0x”,“assetInIndex”:“2”,“assetOutIndex”:“3”}]	[“0x6b175474e89094c44da98b954eedeac495271d0f”,“0x804cdb9116a10bb78768d3252355a1b18067bf8f”,“0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	[“57896044618658097711785492504343953926634992332820282019728792003956564819967”,“0”,“0”,“0”]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	1654280720	14892470	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	2,1	2022-06-02T18:25:33.000Z	[“177227278627894741676147”,“0”,“0”,“-177396766339”]	0x7468c20b0eb213815f2f7bcc3c4443cf314b2d80dd383308efd2cccc23d162b0
376042	true	287347	{“sender”:“0x220bda5c8994804ac96ebe4df184d25e5c2196d4”,“recipient”:“0x1111111254fb6c44bac0bed2854e76f90643097d”,“toInternalBalance”:false,“fromInternalBalance”:false}	[{“amount”:“850364000000”,“poolId”:“0x9210f1204b5a24742eba12f710636d76240df3d00000000000000000000000fc”,“userData”:“0x”,“assetInIndex”:“0”,“assetOutIndex”:“1”},{“amount”:“0”,“poolId”:“0x7b50775383d3d6f0215a8f290f2c9e2eebbeceb20000000000000000000000fe”,“userData”:“0x”,“assetInIndex”:“1”,“assetOutIndex”:“2”},{“amount”:“0”,“poolId”:“0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c0000000000000000000000fd”,“userData”:“0x”,“assetInIndex”:“2”,“assetOutIndex”:“3”}]	[“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0x9210f1204b5a24742eba12f710636d76240df3d0”,“0x2bbf681cc4eb09218bee85ea2a5d3d13fa40fc0c”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	[“57896044618658097711785492504343953926634992332820282019728792003956564819967”,“0”,“0”,“0”]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	1654258782	14890942	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	1,1	2022-06-02T12:19:13.000Z	[“850364000000”,“0”,“0”,“-851243911351”]	0xc27876bca293f4841dc326c9fd3212d463f451413e8ceade6d835bc048f5553d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.Vault_batchSwap_function`
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	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	24557500000	0x2ceedd7692b9524272068bf2a82603e530f94376	2	14110181	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2022-01-30T23:34:28.000Z	0xc8e97ec65fea24e99a700be1d324954b3894dabd5300f790d2662498da499ff8
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	76798785	0xfc0591893b0bdb4322d25bdd43904aa9ab137140	2	14105773	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2022-01-30T07:28:42.000Z	0x3f9ecf8b34d0eedb85c3b5ce7fb5551116c0e906e2d3316c324dc828aa3412f2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	76798785	0xfc0591893b0bdb4322d25bdd43904aa9ab137140	2	14105849	0x9008d19f58aabd9ed0d60971565aa8510560ab41	2022-01-30T07:43:12.000Z	0x553b6c8b08a013db961f7d6d0af9708febf900420ae35d579deef02ba2dbe405

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	790654559367764122	45	16364375	0x03971009c84fc3fe8c91e354d565b3ec604bf952	2023-01-08T20:11:47.000Z	0x82938b21049938eec03d7f9caf1b3cc48f66f9b681c4476a06e3e089fe75fb47
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	1976636398419410306	87	16364378	0x03971009c84fc3fe8c91e354d565b3ec604bf952	2023-01-08T20:12:23.000Z	0x9ca1bcd1b68d1cfb930e18c846746ff80302a669fa7b7c799e795d82a16435bb
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xdac17f958d2ee523a2206206994597c13d831ec7	2035342788240	79	16365086	0x079b68be414c6401e23ecd836f22f64be4b3b5d6	2023-01-08T22:34:35.000Z	0x31d672a7efc5a2b8fef8feafba05e6d7ee578ee8b75624400c3d07f83221b5f8

Example Query

Query with partition filter

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

Vault_flashLoan_function

Flash loan requests to Balancer V2 Vault on Ethereum, including borrowed token addresses, amounts, recipients, and execution status. Used for analyzing flash loan utilization, arbitrage patterns, and protocol liquidity access.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. 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_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_userData`	`STRING`	Custom data payload passed to the flash loan recipient contract for application-specific logic. Hex-encoded bytes that can contain routing instructions, swap parameters, or callback data used during loan execution.

Sample Data

gas	status	gas_used	in_tokens	signature	in_amounts	to_address	in_userData	block_number	from_address	in_recipient	trace_address	block_timestamp	transaction_hash
392994	false	233470	[]	0x5c38449e	[]	0xba12222222228d8ba445958a75a0704d566bf2c8		17445541	0xd050e0a4838d74769228b49dff97241b4ef3805d		0,0,0	2023-06-09T22:10:59.000Z	0x40b539d9ced034971ead555bf975696030f03f00f6e8cef54292e066ac6205fa
935663	false	386281	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	0x5c38449e	[“3358153857591289827”]	0xba12222222228d8ba445958a75a0704d566bf2c8	0x000300ff0100002e9a8f2426d627e300000019e1f008f79c86214ffde8000000028ad599c3a0ff1de082011efddc58f1908eb6e6d8a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000000170e035ee0000000000000000000000000000000000000000000000000000000000000bb800000000000000000000000000000000000000000000000000000000000000000269d91b94f0aaf8e8a2586909fa77a5c2c89818d52b591e99afe9f32eaa6214f7b7629768c40eeb3900000000000000000000000000000000000000000000000000004d2285a597ce0000000000000000000000000000000000000000000000000000000000000bb80000000000000000000000000000000000000000000000000000000000000000029e0905249ceefffb9605e034b534544684a58be6c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000034bcd16fc1af137e0000000000000000000000000000000000000000000000000000000000000bb80000000000000000000000000000000000000000000000000000000000000000	17439152	0x5bbacb6ff28dcaeb92f43f9da8de41b3d6028a7a	0x5bbacb6ff28dcaeb92f43f9da8de41b3d6028a7a	3,1	2023-06-09T00:34:47.000Z	0x7bc807fbeb1f2ec5a2f0c274a4f0a7dc8418cdb9c9fdb9b13e6a44a440b80692
1096282	false	107024	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	0x5c38449e	[“3358153857591289827”]	0xba12222222228d8ba445958a75a0704d566bf2c8	0x000300ff0100002e9a8f2426d627e300000019d1f8fb672b6a22b2fde800000001397ff1542f962076d0bfe58ea045ffa2d347aca0a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000000017113830b000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000269d91b94f0aaf8e8a2586909fa77a5c2c89818d52b591e99afe9f32eaa6214f7b7629768c40eeb3900000000000000000000000000000000000000000000000000004d2c198fbf950000000000000000000000000000000000000000000000000000000000000bb80000000000000000000000000000000000000000000000000000000000000000029e0905249ceefffb9605e034b534544684a58be6c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000034c34c8cdc5807530000000000000000000000000000000000000000000000000000000000000bb80000000000000000000000000000000000000000000000000000000000000000	17439152	0x5bbacb6ff28dcaeb92f43f9da8de41b3d6028a7a	0x5bbacb6ff28dcaeb92f43f9da8de41b3d6028a7a	2,1	2023-06-09T00:34:47.000Z	0x7bc807fbeb1f2ec5a2f0c274a4f0a7dc8418cdb9c9fdb9b13e6a44a440b80692

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.Vault_flashLoan_function`
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	0x0000e0ca771e21bd00057f54a68c30d400000000	false	-7294323	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	1	15262093	2022-08-02T08:50:32.000Z	0x9491b60bc9cec8149d2d599a1df429e8fb93101bfb203cca31ab9e51e6255b66
0xba12222222228d8ba445958a75a0704d566bf2c8	0x0000e0ca771e21bd00057f54a68c30d400000000	false	8231703	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	17	15261110	2022-08-02T05:05:40.000Z	0xa1a7f90451dd4952009362408a3e40ec3368aa1bd09a3971735abee127566b5f
0xba12222222228d8ba445958a75a0704d566bf2c8	0x0eae044f00b0af300500f090ea00027097d03000	false	-3269892	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	65	15263832	2022-08-02T15:13:24.000Z	0x8e6ae5c90faef21641504eeb7401efa57244472a9adb277c29145e46f12bb66d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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_ethereum.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	[“-28716417499955638573127”,“-11233938590260159399869”]	0x56f30398d13f111401d6e7ffe758254a0946687d000200000000000000000105	[“0x0740a6cfb9468b8b53070c0b327099293dccb82d”,“0xed279fdd11ca84beef15af5d39bb4d4bee23f0ca”]	43	14698209	2022-05-02T12:13:51.000Z	0xb3261a2f251998939be69a525d7f7c73e653dfca986c9ee6b7b09b854d7dde6d	0x2ede205c8f38abc4ad47ba865c9c8b162f73f4d4	[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“-52386147493182687529”,“-20493599660181658432”]	0x56f30398d13f111401d6e7ffe758254a0946687d000200000000000000000105	[“0x0740a6cfb9468b8b53070c0b327099293dccb82d”,“0xed279fdd11ca84beef15af5d39bb4d4bee23f0ca”]	24	14698147	2022-05-02T11:57:40.000Z	0xd3366abf2264553fbbc1a88a490486b537e66298b66149e547f9b30196257b03	0x3cc769cce18ee80530c94604a1d4ed6bd9ed2eca	[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“-17462049164393823509267”,“-6831199886727060779212”]	0x56f30398d13f111401d6e7ffe758254a0946687d000200000000000000000105	[“0x0740a6cfb9468b8b53070c0b327099293dccb82d”,“0xed279fdd11ca84beef15af5d39bb4d4bee23f0ca”]	110	14698144	2022-05-02T11:56:43.000Z	0x8f90555cf39ce809c3aee18785b50002d565cee1e9b78e475d0479ef067f29a0	0x3cc769cce18ee80530c94604a1d4ed6bd9ed2eca	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	0xafe7131a57e44f832cb2de78ade38cad644aac2f	0x7337224d59cb16c2dc6938cd45a7b2c60c865d6a0000000000000000000004d4	313	17649224	0	2023-07-08T13:05:23.000Z	0xa8a2a1aba91204987882e1a245c6884e3b9c8979	-2925412823063849808919	0xd8b52d5490e78f726303edc20123e53a63577de6be62343e34cd52ae9df711fc
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xafe7131a57e44f832cb2de78ade38cad644aac2f	0x7337224d59cb16c2dc6938cd45a7b2c60c865d6a0000000000000000000004d4	312	17649224	-2925412823063849808919	2023-07-08T13:05:23.000Z	0xa8a2a1aba91204987882e1a245c6884e3b9c8979	2925412823063849808919	0xd8b52d5490e78f726303edc20123e53a63577de6be62343e34cd52ae9df711fc
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0x7337224d59cb16c2dc6938cd45a7b2c60c865d6a0000000000000000000004d4	333	17649224	3010320444	2023-07-08T13:05:23.000Z	0xa8a2a1aba91204987882e1a245c6884e3b9c8979	-3010320444	0xd8b52d5490e78f726303edc20123e53a63577de6be62343e34cd52ae9df711fc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	0xfddd8ca59d193f3f9683b084f8289aa6abd14ede00010000000000000000036c	168	15539027	0xfddd8ca59d193f3f9683b084f8289aa6abd14ede	2022-09-15T12:14:23.000Z	0x2f44373a7bd6d68976c24e7d4a5d86df63dc355b5883d412fa66108b59d0dc26	1
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xa27e92f81b42feb6e0d507d1c0f75a5284e921e600010000000000000000036d	126	15539065	0xa27e92f81b42feb6e0d507d1c0f75a5284e921e6	2022-09-15T12:21:59.000Z	0x471d17be7a40e2644982e6b56f59213ec4ed0c8e06b5a4abfe6b9f7720195754	1
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xae4d08895b1f0f14c7ab5f5b2e9bf54e6e1e5c6f0001000000000000000001ec	197	14749154	0xae4d08895b1f0f14c7ab5f5b2e9bf54e6e1e5c6f	2022-05-10T14:42:29.000Z	0xe2d02dc9a4162931ee051193e736b19548d54d01a23e7cfc3d0ba66c53487a90	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	log_index	in_relayer	in_approved	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x9360cd5f7d7b87b43fb138f44e756dbc24df52e9	409	0xc92e8bdf79f0507f65a392b0ab4667716bfe0110	true	15209010	2022-07-25T02:18:33.000Z	0x2a3dde17bdd32c91036660408835e4b800f9057af45e01b7ac83ec450024c4e1
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x6e93ebc8302890ff1d1befd779d1db131ef30d4d	87	0xc92e8bdf79f0507f65a392b0ab4667716bfe0110	true	15210855	2022-07-25T09:26:03.000Z	0x4e37fbad08b2d64b3ce13479f1da7fcb8e6483a9c64393da16d4fc14e8d65b8d
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb4ee891a959ab1ae052ce9558d71c1a0cdc4a4c6	239	0xc92e8bdf79f0507f65a392b0ab4667716bfe0110	true	15211532	2022-07-25T12:01:52.000Z	0x1533f3cb9ce280f16161646d66e98fe17bb253de5a5a22bb4a00fc991a45dd33

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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	0x01abc00e86c7e258823b9a055fd62ca6cf61a16300010000000000000000003b	225	0x6b3595068778dd592e39a122f4f5a5cf09c90fe2	16445017284768472764	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e	12722854	3924118865845465	2021-06-28T13:44:19.000Z	0xbece309fd1deae21b80a9f60cc05f57deaf970bec03512f593422213043320dc
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x01abc00e86c7e258823b9a055fd62ca6cf61a16300010000000000000000003b	38	0x6b3595068778dd592e39a122f4f5a5cf09c90fe2	15359283962266283372	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e	12722933	3581495474517239	2021-06-28T14:03:16.000Z	0xf55d06aa900eb354dc2c3f49be25ee5d8007781ccd2bfc3c6dc200fcc896082d
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x01abc00e86c7e258823b9a055fd62ca6cf61a16300010000000000000000003b	259	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	19834912500000000	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	12720150	2297718555787381473	2021-06-28T03:39:09.000Z	0x585a4f57356abec40b71f925ce6fe0db7b70adf01bc077d5fb9d7963f712d1fd

Example Query

Query with partition filter

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

Vault_swap_function

Individual swap function calls to Balancer V2 Vault contract on Ethereum. Contains single-swap execution details including pool IDs, token pairs, swap amounts, and calculated output for analyzing DEX (decentralized exchange) trading patterns and liquidity pool performance.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_singleSwap`	`STRUCT<poolId STRING, kind INT64, assetIn STRING, assetOut STRING, amount STRING, userData STRING>`	Structured swap parameters including pool ID, input/output token addresses, swap amount, and swap type (exact-in vs exact-out). This RECORD field contains the core trade specification passed to Balancer V2’s single-swap function.
`in_funds`	`STRUCT<sender STRING, fromInternalBalance BOOL, recipient STRING, toInternalBalance BOOL>`	Fund transfer routing parameters for a swap operation. Struct containing sender address, recipient address, and boolean flags indicating whether to use internal balance for source (fromInternalBalance) and destination (toInternalBalance) of funds.
`in_limit`	`STRING`	Minimum or maximum acceptable output amount for the swap, expressed in the smallest token unit. Acts as slippage protection, with 0 or 1 commonly representing unlimited slippage tolerance.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`out_amountCalculated`	`STRING`	Calculated output amount received from the swap, denominated in the output token’s smallest unit. Returned as a string to preserve precision for tokens with high decimals or large values.

Sample Data

gas	status	gas_used	in_funds	in_limit	signature	to_address	in_deadline	block_number	from_address	in_singleSwap	trace_address	block_timestamp	transaction_hash	out_amountCalculated
399870	true	61514	{“sender”:“0x88a13979517cd3323d6f5e5e5b22b48fc8162c0e”,“recipient”:“0xecc2ba7438c2e00a8561284c1749f6764e74e413”,“toInternalBalance”:false,“fromInternalBalance”:false}	1	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	1645770093	14273132	0x88a13979517cd3323d6f5e5e5b22b48fc8162c0e	{“kind”:0,“amount”:“215352000000000000”,“poolId”:“0x3e5fa9518ea95c3e533eb377c001702a9aacaa32000200000000000000000052”,“assetIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“assetOut”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“userData”:“0x”}	4,3	2022-02-25T04:26:22.000Z	0x6eaab7759200a0a4167af74904f2b0ee8d6e14d3cebb669952dd182fe90605ab	565331652
445129	true	70639	{“sender”:“0x498e84899558545a0f6d4036bdb3a3842cf9b6d0”,“recipient”:“0x498e84899558545a0f6d4036bdb3a3842cf9b6d0”,“toInternalBalance”:false,“fromInternalBalance”:false}	1	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	4294967295	14275460	0x498e84899558545a0f6d4036bdb3a3842cf9b6d0	{“kind”:0,“amount”:“1625782152055098916477895”,“poolId”:“0x60b4601cdddc4467f31b1f770cb93c51dc7dc728000200000000000000000042”,“assetIn”:“0x89045d0af6a12782ec6f701ee6698beaf17d0ea2”,“assetOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“userData”:“0x”}	4,0,3,13	2022-02-25T13:13:55.000Z	0x5c2387296ec5db88cc28e4bc6e8741e2105fb93b70c26b04594c3d540cd7a34d	3274984190711813679
311236	true	73015	{“sender”:“0x18008a3d4de136e090d0a71cb1de601fc8246225”,“recipient”:“0x18008a3d4de136e090d0a71cb1de601fc8246225”,“toInternalBalance”:false,“fromInternalBalance”:false}	0	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	1645807619	14276352	0x18008a3d4de136e090d0a71cb1de601fc8246225	{“kind”:0,“amount”:“1220086708558955457”,“poolId”:“0xe99481dc77691d8e2456e5f3f61c1810adfc1503000200000000000000000018”,“assetIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“assetOut”:“0x514910771af9ca656af840dff83e8264ecf986ca”,“userData”:“0x”}	0,4,3,2,46	2022-02-25T16:29:09.000Z	0x0acbb2a7e46540061192d1c0cc5387b73c77b960120ed70705dbd86273a2d97d	237171469725240324348

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.Vault_swap_function`
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_ethereum.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	0x1e9142bfd599bdecc03e7963aef0d96947bee845000200000000000000000145	[“0x15b7c0c907e4c6b9adaaaabc300c08991d6cea05”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”]	251	14150046	2022-02-06T03:29:12.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x551e52fb6f9227afcae7801f0aba487c7df8a49e423d4e93b47db211e03fb168
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xd6855f0a3c26a1b1b2785ba2604758c0878169bc000100000000000000000317	[“0x6b175474e89094c44da98b954eedeac495271d0f”,“0xbe1f8b3493570501cb32bc87ae3150f4e1a9f0e4”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	492	15317367	2022-08-10T23:45:33.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x1707d29e315136a214cef0100e0273fe503d3af7593293ddb31e8d484d81951d
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x1e904cf298c480e9a38f839af8e8ab3753a26627000200000000000000000315	[“0x4e9e4ab99cfc14b852f552f5fb3aa68617825b6c”,“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	153	15312688	2022-08-10T06:10:21.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x2830dbece4f31ef3055952996e48d6e154e79e8f06659796bedf3009d2dad8a8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xa5bf2ddf098bb0ef6d120c98217dd6b141c74ee0	0xbb31b8eebb9c71001562ae56aa5751af313e6d89	false	56	12445005	2021-05-16T10:44:28.000Z	0x87cadaf27dbf3a9972886c26d0835f72dbd25728b1616dd68d9a7c21c2c9acbf
0xa5bf2ddf098bb0ef6d120c98217dd6b141c74ee0	0x5c6ee304399dbdb9c8ef030ab642b10820db8f56	false	256	12369384	2021-05-04T18:31:11.000Z	0x1d3d5564e83bfec0f0c982b3fdd583148871a45c790e5a231b5620d15dbe524f
0xa5bf2ddf098bb0ef6d120c98217dd6b141c74ee0	0xefaa1604e82e1b3af8430b90192c1b9e8197e377	false	7	12369886	2021-05-04T20:22:20.000Z	0xf458754e62952ed92e80c45c5a05e62e26fa74225c7f07b4a067f8d494da5432

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0x51735bdfbfe3fc13dea8dc6502e2e95898942961	false	532	13378339	2021-10-08T12:58:30.000Z	0x736290cf1c3841733a83841a010e57d913e9c326eed6249d0e6eb1702d47bc0f
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0xb5152e7b85e9c2a9cef95879ee67cfa19da13b1f	false	50	14353646	2022-03-09T16:26:17.000Z	0xf6e8c417db3cf6143ebe3632bdb039d33dbe6ee7f923b252f234c5935ee15a5e
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0xf643b222334d6950b9c2c6686397d1bed9bdf3f3	false	61	14421255	2022-03-20T05:06:00.000Z	0x1a8094c4a1ea4198a46c53f784abc1ccc3190c067a7e8a5b6d664333fe59de75

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xcc508a455f5b0073973107db6a878ddbdab957bc	false	163	16348014	2023-01-06T13:22:35.000Z	0x9675b19253bc24bc4acd4fb2961eda5b9dcd7bdac78716d8ea375f18eade9c35

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0xcc508a455f5b0073973107db6a878ddbdab957bc	0xe340ebfcaa544da8bb1ee9005f1a346d50ec422e	false	280	15732922	2022-10-12T15:28:23.000Z	0x9a949a52e4179d0c57dcffd6884d5787febfb92f8f4b7e114ef8cfbda0292a79
0xcc508a455f5b0073973107db6a878ddbdab957bc	0x25accb7943fd73dda5e23ba6329085a3c24bfb6a	false	493	15691338	2022-10-06T20:06:35.000Z	0xe24987cf155bad22e29de5447a32aed7bf2875199c777b7a355fd4e9cbee590a
0xcc508a455f5b0073973107db6a878ddbdab957bc	0x43bdd55d9c98ae9184dc3a869ab89a83762156d5	false	205	16064296	2022-11-27T22:27:11.000Z	0x86ea14ebad81fed7139a6b96436e5ddbd71caf0b332e3a976862cbee9c158e73

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x5dd94da3644ddd055fcf6b3e1aa310bb7801eb8b	false	252	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x5dd94da3644ddd055fcf6b3e1aa310bb7801eb8b	0x664c6a02dcdbaada80838c20c1e7f21e5b3ea90e	false	237	17021591	2023-04-11T01:22:59.000Z	0xb5e6d5c3e048d0407a2db86fa3ee09501432d4c8c15c7dd2b793a7ddb508a274
0x5dd94da3644ddd055fcf6b3e1aa310bb7801eb8b	0xeab8b160903b4a29d7d92c92b4ff632f5c964987	false	249	16859355	2023-03-19T04:21:23.000Z	0x2239069ff3eb5cd03c9c9686ee7a7093130437573f6f4f4dc494fe5ad820b5de
0x5dd94da3644ddd055fcf6b3e1aa310bb7801eb8b	0x9ce746ded4d6031e4f2da842936c57d0e50f8d0e	false	221	16784086	2023-03-08T14:19:23.000Z	0x36ee9eb0627b791d64580be8b7d7142fb4d18dd93e43c760033dca3553469888

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x897888115ada5773e02aa29f775430bfb5f34c51	0x05b1a35fdbc43849aa836b00c8861696edce8cc4	false	314	18333141	2023-10-12T08:27:59.000Z	0x8004676812f58ca00df3b8b93c04e87e2a9bd3c0c250b0399beb02fe27202bf7
0x897888115ada5773e02aa29f775430bfb5f34c51	0x7a7c857156ce3fbf58bf8f52dd4447ad111889a6	false	126	18333084	2023-10-12T08:16:35.000Z	0xc5714a7b9177bb8a5a02428f3f72742998150504d180322092559a072ee8b855
0x897888115ada5773e02aa29f775430bfb5f34c51	0x150d969723bc8924dc667ba3254bacd967fad266	false	131	18337060	2023-10-12T21:37:11.000Z	0x6a27d11561730078f40bd27e0120b6f4915f3c79b6c1151a63c2f9e706ef90bc

Example Query

Query with partition filter

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

WeightedPoolV2_Approval_event

ERC-20 token approval events from Balancer V2 weighted pool liquidity provider (LP) tokens on Ethereum. Useful for tracking spending allowances granted by LP token holders to contracts and analyzing protocol 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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 of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0x6a5ead5433a50472642cd268e584dafa5a394490	false	0xd7620731c75b0f4078707be8f1fd6b6b7b277a3e	115792089237316195423570985008687907853269984665640564039457584007913129639935	222	0x7818a1da7bd1e64c199029e86ba244a9798eee10	15663653	2022-10-02T23:09:11.000Z	0xb53a87ed339c9a3dd386394aefa40ef96ae1cda8594cb0bb86dc0c070cd33e4e
0x6a5ead5433a50472642cd268e584dafa5a394490	false	0xaf52695e1bb01a16d33d7194c28c42b10e0dbec2	0	522	0xc2c2304e163e1ab53de2eeb08820a0b592bec20b	15663657	2022-10-02T23:09:59.000Z	0x6d8be8a33e584b465c9607f3f972d422ce4e49ae8a74bff1368d0bb61aa10143
0x6a5ead5433a50472642cd268e584dafa5a394490	false	0xaf52695e1bb01a16d33d7194c28c42b10e0dbec2	56128706645358006897	519	0xc2c2304e163e1ab53de2eeb08820a0b592bec20b	15663657	2022-10-02T23:09:59.000Z	0x6d8be8a33e584b465c9607f3f972d422ce4e49ae8a74bff1368d0bb61aa10143

Example Query

Query with partition filter

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

WeightedPoolV2_PausedStateChanged_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_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_ethereum.WeightedPoolV2_PausedStateChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolV2_ProtocolFeePercentageCacheUpdated_event

Protocol fee percentage cache update events from Balancer V2 weighted pools on Ethereum. Tracks fee type changes and percentage values (in 18-decimal format) for analyzing protocol revenue configuration across different pool fee categories.

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_feeType`	`STRING`	Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes.
`in_protocolFeePercentage`	`STRING`	Protocol fee percentage applied to this fee type, denominated in wei where 1e18 represents 100%. Commonly set to 500000000000000000 (50%) or 0 (no fee).

Sample Data

address	removed	log_index	in_feeType	block_number	block_timestamp	transaction_hash	in_protocolFeePercentage
0xe340ebfcaa544da8bb1ee9005f1a346d50ec422e	false	278	3	15732922	2022-10-12T15:28:23.000Z	0x9a949a52e4179d0c57dcffd6884d5787febfb92f8f4b7e114ef8cfbda0292a79	0
0xe340ebfcaa544da8bb1ee9005f1a346d50ec422e	false	277	2	15732922	2022-10-12T15:28:23.000Z	0x9a949a52e4179d0c57dcffd6884d5787febfb92f8f4b7e114ef8cfbda0292a79	500000000000000000
0xe340ebfcaa544da8bb1ee9005f1a346d50ec422e	false	279	0	15732922	2022-10-12T15:28:23.000Z	0x9a949a52e4179d0c57dcffd6884d5787febfb92f8f4b7e114ef8cfbda0292a79	500000000000000000

Example Query

Query with partition filter

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

WeightedPoolV2_RecoveryModeStateChanged_event

Recovery mode activation and deactivation events for Balancer V2 weighted pools on Ethereum. Used to track when pools enter or exit emergency recovery mode, enabling governance-controlled liquidity withdrawals during protocol incidents.

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
0x25accb7943fd73dda5e23ba6329085a3c24bfb6a	false	269	true	16347980	2023-01-06T13:15:47.000Z	0x7a0c40b4a2b88deee5c04de5969d58a33dd0dffbff41d617c4b8166bda7fd03d
0xb9bd68a77ccf8314c0dfe51bc291c77590c4e9e6	false	278	true	16347980	2023-01-06T13:15:47.000Z	0x7a0c40b4a2b88deee5c04de5969d58a33dd0dffbff41d617c4b8166bda7fd03d
0x43bdd55d9c98ae9184dc3a869ab89a83762156d5	false	271	true	16347980	2023-01-06T13:15:47.000Z	0x7a0c40b4a2b88deee5c04de5969d58a33dd0dffbff41d617c4b8166bda7fd03d

Example Query

Query with partition filter

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

WeightedPoolV2_SwapFeePercentageChanged_event

Swap fee percentage change events from Balancer V2 weighted pools on Ethereum, showing when pool operators adjusted trading fees (stored in wei, e.g., 10000000000000000 = 1%). Used for tracking fee policy changes and analyzing their impact on pool liquidity and volume.

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
0x798b112420ad6391a4129ac25ef59663a44c88bb	false	78	18499031	2023-11-04T13:41:23.000Z	0x1cc6ad8cee041c37a867244e79cf4e78d99b54765236ae3dd8fa220e7584c0d5	2000000000000000
0x798b112420ad6391a4129ac25ef59663a44c88bb	false	85	18499031	2023-11-04T13:41:23.000Z	0x1cc6ad8cee041c37a867244e79cf4e78d99b54765236ae3dd8fa220e7584c0d5	10000000000000000
0x798b112420ad6391a4129ac25ef59663a44c88bb	false	109	18101387	2023-09-09T21:02:35.000Z	0xdb929f86fad37e06f48f09a7de60b1db5815180d9c586ab68e7c90cb40fa5ef5	2000000000000000

Example Query

Query with partition filter

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

WeightedPoolV2_Transfer_event

Balancer Pool Token (BPT) transfer events from Weighted Pool V2 contracts on Ethereum, tracking liquidity provider share movements including mints from zero address and burns to zero address. Used for analyzing liquidity provision patterns and LP token holder flows across Balancer V2 weighted 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.
`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	log_index	block_number	block_timestamp	transaction_hash
0xce88686553686da562ce7cea497ce749da109f9f	0x0fd5663d4893ae0d579d580584806aadd2dd0b8b	0x0000000000000000000000000000000000000000	false	385376807401434	406	15771929	2022-10-18T02:13:11.000Z	0xc3c2b5528526f1d455b306fde531b266ff8330bfa4140a7881963e53b9fb7739
0x54881c1b56e0e7a62a3f0752180036976435b891	0x0fd5663d4893ae0d579d580584806aadd2dd0b8b	0x0000000000000000000000000000000000000000	false	433194768310407480778	407	15771929	2022-10-18T02:13:11.000Z	0xc3c2b5528526f1d455b306fde531b266ff8330bfa4140a7881963e53b9fb7739
0xce88686553686da562ce7cea497ce749da109f9f	0x0fd5663d4893ae0d579d580584806aadd2dd0b8b	0x0000000000000000000000000000000000000000	false	1819567366731051065	405	15771929	2022-10-18T02:13:11.000Z	0xc3c2b5528526f1d455b306fde531b266ff8330bfa4140a7881963e53b9fb7739

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.WeightedPoolV2_Transfer_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
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	false	258	17278861	2023-05-17T10:46:59.000Z	0x162852c28f1384e670447cd1b4be99edd2fd48a5e9a324500888cd9933873c32

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	0xd6e355036f41dc261b3f1ed3bbc6003e87aadb4f	false	333	16641340	2023-02-16T12:38:23.000Z	0xfa89f09cc5920aeff27c80eb59224ae4ca8080409dce7d84bf1c4bc71a7a6ea8
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	0x9b1c8407a360443a9e5eca004713e4088fab8ac0	false	262	16641999	2023-02-16T14:50:59.000Z	0x44b014b40082d6ecc6efac6637ab3a1050875ded6316b8a7bcef27f0f1200dac
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	0x8e6ec57a822c2f527f2df7c7d7d361df3e7530a1	false	319	16642017	2023-02-16T14:54:35.000Z	0x899fe26fbd275b1d5b4120f667ced3110f570f94368855a2bf936cae707d432b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	0x9b1c8407a360443a9e5eca004713e4088fab8ac0	false	267	16641999	16	2023-02-16T14:50:59.000Z	0x44b014b40082d6ecc6efac6637ab3a1050875ded6316b8a7bcef27f0f1200dac
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	0x8e6ec57a822c2f527f2df7c7d7d361df3e7530a1	false	324	16642017	16	2023-02-16T14:54:35.000Z	0x899fe26fbd275b1d5b4120f667ced3110f570f94368855a2bf936cae707d432b
0x8b7854708c0c54f9d7d1ff351d4f84e6de0e134c	0xd6e355036f41dc261b3f1ed3bbc6003e87aadb4f	false	338	16641340	16	2023-02-16T12:38:23.000Z	0xfa89f09cc5920aeff27c80eb59224ae4ca8080409dce7d84bf1c4bc71a7a6ea8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x5f5222ffa40f2aed6380d022184d6ea67c776ee0	false	253	17973271	2023-08-22T22:35:23.000Z	0xc8c47370e55c81e247562f7ed072ea60b1d3e1147b46a8d64418f4d74d439847

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x5f5222ffa40f2aed6380d022184d6ea67c776ee0	0xac5b4ef7ede2f2843a704e96dcaa637f4ba3dc3f	false	175	17052604	2023-04-15T13:07:35.000Z	0x497aa03ce84d236c183204ddfc6762c8e4158da1ebc5e7e18e7f6cceaa497a2a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_ethereum.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
0x5f5222ffa40f2aed6380d022184d6ea67c776ee0	0xac5b4ef7ede2f2843a704e96dcaa637f4ba3dc3f	false	180	17052604	0	2023-04-15T13:07:35.000Z	0x497aa03ce84d236c183204ddfc6762c8e4158da1ebc5e7e18e7f6cceaa497a2a

Example Query

Query with partition filter

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

balancer_v1_ethereum balancer_v3_ethereum

⌘I

​Tables

​AaveLinearPoolFactory_PoolCreated_event

​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

​ArbitrumRootGauge_Checkpoint_event

​ArbitrumRootGauge_RelativeWeightCapChanged_event

​ArbitrumRootGaugeFactory_GaugeCreated_event

​AvalancheRootGauge_Checkpoint_event

​AvalancheRootGauge_RelativeWeightCapChanged_event

​AvalancheRootGaugeFactory_GaugeCreated_event

​BaseRootGauge_Checkpoint_event

​BaseRootGaugeFactory_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

​ConvergentCurvePool_FeeCollection_event

​ConvergentCurvePool_onSwap_function

​ConvergentPoolFactory_CCPoolCreated_event

​ConvergentPoolFactory_PoolCreated_event

​ConvergentPoolFactory_setGovFee_function

​ERC4626LinearPoolFactoryV2_PoolCreated_event

​ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV3_FactoryDisabled_event

​ERC4626LinearPoolFactoryV3_PoolCreated_event

​ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV4_FactoryDisabled_event

​ERC4626LinearPoolFactoryV4_PoolCreated_event

​EulerLinearPoolFactory_EulerLinearPoolCreated_event

​EulerLinearPoolFactory_FactoryDisabled_event

​EulerLinearPoolFactory_PoolCreated_event

​GearboxLinearPoolFactoryV2_FactoryDisabled_event

​GearboxLinearPoolFactoryV2_GearboxLinearPoolCreated_event

​GearboxLinearPoolFactoryV2_PoolCreated_event

​GnosisRootGauge_Checkpoint_event

​GnosisRootGaugeFactory_GaugeCreated_event

​InvestmentPoolFactory_PoolCreated_event

​LiquidityBootstrappingPoolFactory_PoolCreated_event

​ManagedPoolFactory_FactoryDisabled_event

​ManagedPoolFactory_PoolCreated_event

​ManagedPoolFactoryV2_FactoryDisabled_event

​ManagedPoolFactoryV2_PoolCreated_event

​MerkleOrchard_DistributionClaimed_event

​MerkleRedeem_Claimed_event

​MetaStablePoolFactory_PoolCreated_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

​OptimismRootGaugeFactory_GaugeCreated_event

​PolygonRootGauge_Checkpoint_event

​PolygonRootGaugeFactory_GaugeCreated_event

​PolygonZkEVMRootGaugeFactory_GaugeCreated_event

​Pool_RecoveryModeStateChanged_event

​Pool_SwapFeePercentageChanged_event

​Pool_Transfer_event

​PoolFactory_PoolCreated_event

​ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

​ProtocolFeesCollector_SwapFeePercentageChanged_event

​SiloLinearPoolFactory_FactoryDisabled_event

​SiloLinearPoolFactory_PoolCreated_event

​SiloLinearPoolFactory_SiloLinearPoolCreated_event

​SiloLinearPoolFactoryV2_FactoryDisabled_event

​SiloLinearPoolFactoryV2_PoolCreated_event

​SiloLinearPoolFactoryV2_SiloLinearPoolCreated_event

​StablePhantomPoolFactory_PoolCreated_event

Tables

AaveLinearPoolFactory_PoolCreated_event

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

ArbitrumRootGauge_Checkpoint_event

ArbitrumRootGauge_RelativeWeightCapChanged_event

ArbitrumRootGaugeFactory_GaugeCreated_event

AvalancheRootGauge_Checkpoint_event

AvalancheRootGauge_RelativeWeightCapChanged_event

AvalancheRootGaugeFactory_GaugeCreated_event

BaseRootGauge_Checkpoint_event

BaseRootGaugeFactory_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

ConvergentCurvePool_FeeCollection_event

ConvergentCurvePool_onSwap_function

ConvergentPoolFactory_CCPoolCreated_event

ConvergentPoolFactory_PoolCreated_event

ConvergentPoolFactory_setGovFee_function

ERC4626LinearPoolFactoryV2_PoolCreated_event

ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV3_FactoryDisabled_event

ERC4626LinearPoolFactoryV3_PoolCreated_event

ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV4_FactoryDisabled_event

ERC4626LinearPoolFactoryV4_PoolCreated_event

EulerLinearPoolFactory_EulerLinearPoolCreated_event

EulerLinearPoolFactory_FactoryDisabled_event

EulerLinearPoolFactory_PoolCreated_event

GearboxLinearPoolFactoryV2_FactoryDisabled_event

GearboxLinearPoolFactoryV2_GearboxLinearPoolCreated_event

GearboxLinearPoolFactoryV2_PoolCreated_event

GnosisRootGauge_Checkpoint_event

GnosisRootGaugeFactory_GaugeCreated_event

InvestmentPoolFactory_PoolCreated_event

LiquidityBootstrappingPoolFactory_PoolCreated_event

ManagedPoolFactory_FactoryDisabled_event

ManagedPoolFactory_PoolCreated_event

ManagedPoolFactoryV2_FactoryDisabled_event

ManagedPoolFactoryV2_PoolCreated_event

MerkleOrchard_DistributionClaimed_event

MerkleRedeem_Claimed_event

MetaStablePoolFactory_PoolCreated_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

OptimismRootGaugeFactory_GaugeCreated_event

PolygonRootGauge_Checkpoint_event

PolygonRootGaugeFactory_GaugeCreated_event

PolygonZkEVMRootGaugeFactory_GaugeCreated_event

Pool_RecoveryModeStateChanged_event

Pool_SwapFeePercentageChanged_event

Pool_Transfer_event

PoolFactory_PoolCreated_event

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

ProtocolFeesCollector_SwapFeePercentageChanged_event

SiloLinearPoolFactory_FactoryDisabled_event

SiloLinearPoolFactory_PoolCreated_event

SiloLinearPoolFactory_SiloLinearPoolCreated_event

SiloLinearPoolFactoryV2_FactoryDisabled_event

SiloLinearPoolFactoryV2_PoolCreated_event

SiloLinearPoolFactoryV2_SiloLinearPoolCreated_event

StablePhantomPoolFactory_PoolCreated_event