balancer_v2_polygon - Token Terminal Docs

Tables

AaveLinearPoolFactory_PoolCreated_event

Pool creation events from Balancer V2’s Aave Linear Pool Factory on Polygon, tracking when new linear pools are deployed with their addresses. Used to identify and track Balancer pools that integrate with Aave lending markets for yield optimization.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xf302f9f50958c5593770fdf4d4812309ff77414f	0x0503dd6b2d3dd463c9bef67fb5156870af63393e	false	37	26620631	2022-04-01T15:04:24.000Z	0x2f23d15c06272cd7c0a3ad6863d6b7477526d3a7de77ceb25fbb2ebfcd3f5af1
0xf302f9f50958c5593770fdf4d4812309ff77414f	0x8a819a4cabd6efcb4e5504fe8679a1abd831dd8f	false	15	26620628	2022-04-01T15:04:18.000Z	0x6d50addf07f594f02b41c3ad48fcc6f1a77860263cec2bfcf31f96bc57a7ffd0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	false	175	37127292	2022-12-22T06:00:48.000Z	0x7884e4f12cbec4695cd6bda6cafa35a4a0c50859f2b15ec896c2f7b87afd23ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0x3dd0843a028c86e0b760b1a76929d1c5ef93a2dd	false	264	32201001	2022-08-22T18:32:10.000Z	0xb99f722617bfdf001e83deed7f8a3c9f2ac6dcc9d85b8d521d14d4c9154ae0d8
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0xf93579002dbe8046c43fefe86ec78b1112247bb8	false	140	32808756	2022-09-07T14:57:22.000Z	0xe2a2dcce49040ec4f91e065bd52887466f8c7de4bf3251f12e2da1a83edb3a9d
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0xff4ce5aaab5a627bf82f4a571ab1ce94aa365ea6	false	241	32808997	2022-09-07T15:05:40.000Z	0x980e991f61a4dd5839bd29fa928c8ea78610324747a7d1ebfc03a0fd46677ddd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x35c425234dc42e7402f54cc54573f77842963a56	0xfa2c0bd8327c99db5bde4c9e9e5cbf30946351bb	false	212	36555216	0	2022-12-07T23:25:26.000Z	0x9f246123242dbf445122e3abc13846a30eead98cd5769ad7f1210ff948341f23

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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_polygon.AaveLinearPoolFactoryV3_AaveLinearPoolProtocolIdRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AaveLinearPoolFactoryV3_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x35c425234dc42e7402f54cc54573f77842963a56	false	306	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x35c425234dc42e7402f54cc54573f77842963a56	0xfa2c0bd8327c99db5bde4c9e9e5cbf30946351bb	false	207	36555216	2022-12-07T23:25:26.000Z	0x9f246123242dbf445122e3abc13846a30eead98cd5769ad7f1210ff948341f23

Example Query

Query with partition filter

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

AaveLinearPoolFactoryV4_AaveLinearPoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f	false	159	39142858	0	2023-02-10T17:33:07.000Z	0xbc51a51efdd10d21ad83d70cdfbebebd95734f0add7124ec1f614abd3ee44dbd

Example Query

Query with partition filter

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

AaveLinearPoolFactoryV4_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843	false	309	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

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

AaveLinearPoolFactoryV4_PoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f	false	154	39142858	2023-02-10T17:33:07.000Z	0xbc51a51efdd10d21ad83d70cdfbebebd95734f0add7124ec1f614abd3ee44dbd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xab2372275809e15198a7968c7f324053867cdb0c	0x0889b240a5876aae745ac19f1771853671dc5d36	false	272	41503173	0	2023-04-14T00:58:48.000Z	0x0a36297bf67c2ddf54e35d2989ebd2837026b8ad3909614c64976b3500e48a7c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xab2372275809e15198a7968c7f324053867cdb0c	false	204	46633724	2023-08-22T22:35:41.000Z	0xe039eaed246d26abe5fe601955b9ca9ce449ed47de9bccadca7b57c208d861ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xab2372275809e15198a7968c7f324053867cdb0c	0x0889b240a5876aae745ac19f1771853671dc5d36	false	267	41503173	2023-04-14T00:58:48.000Z	0x0a36297bf67c2ddf54e35d2989ebd2837026b8ad3909614c64976b3500e48a7c

Example Query

Query with partition filter

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

ChildChainGauge_Approval_event

ERC20 Approval events emitted by Balancer V2 ChildChainGauge contracts, recording token allowance grants from owners to spenders. Tracks gauge token approvals across multiple chains (Arbitrum, Avalanche, Base, Gnosis, Optimism, Polygon) for liquidity mining and delegation operations.

Columns

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

Sample Data

address	removed	in__owner	in__value	log_index	in__spender	block_number	block_timestamp	transaction_hash
0xd955f46b110583e14644665c69e26cd8126070ec	false	0xc5238ebc7ccd0d2b86e23a7764d15dc2e69f74e4	115792089237316195423570985008687907853269984665640564039457584007913129639935	82	0xe7dcc8fff165d53aea6640ba7ad1961637b5af27	50376503	2023-11-25T14:49:20.000Z	0x9bbaa0b999be2c3c825213767e7100dec9a360d7e33b9408dffd5276a9df2caf
0xd955f46b110583e14644665c69e26cd8126070ec	false	0xc5238ebc7ccd0d2b86e23a7764d15dc2e69f74e4	0	153	0xe7dcc8fff165d53aea6640ba7ad1961637b5af27	50382181	2023-11-25T18:17:39.000Z	0xf410f97e5fc0f59ee7a319f61c1118b8508c35ae9e9e76228cc2dcfacf998cc0
0xf16becc1bcaf0ff0b865024a644a4da1a2f8585c	false	0xe79e13e129d9bb1706845de7eb077b067d848f07	441434547000000000000	140	0xe3b8e734e7bccb64b63e032795896cc57012a51d	58840727	2024-07-01T20:06:56.000Z	0x18eefd0376189bf23df1f2468e09291fd6a5f96ac84c31765be93dc1d9dc5236

Example Query

Query with partition filter

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

ChildChainGauge_Deposit_event

Deposit events from Balancer V2 liquidity gauge contracts on Layer 2 chains and sidechains. Records user staking of liquidity pool tokens into gauges for BAL token rewards.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	in__user	in__value	log_index	block_number	block_timestamp	transaction_hash
0x0aea1abc694a3608c8ac5f131d8310f95039111a	false	0x0fdacd96faaae263ca6d6f4a4dc6b12fe9ed6769	50903622034671629457	263	53649443	2024-02-18T01:44:40.000Z	0x48bf263854fa90fbf90a595a2534df4435833637df8ab39e6476ec498f044bbc
0x40b4c2e260f803f868053789bd4a6c7edd1cdc39	false	0x34f1d87bf9d77c5181fffedde3468ffbbd209999	18583329948799217495	116	53682236	2024-02-18T21:40:34.000Z	0x89ab0c953238c5ccf430de564a48e8158b19ea725dd78ba10ea4f39e0a90a6e0
0x40b4c2e260f803f868053789bd4a6c7edd1cdc39	false	0x47b7c7143d2f2b60f810bd9966d0b34935dee904	131090410403911799302	81	53682774	2024-02-18T22:00:27.000Z	0x7d235a7ffe637e6e5af3a1724a043c573c62d743ba67fe880824197367ff0616

Example Query

Query with partition filter

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

ChildChainGauge_Transfer_event

ERC20 Transfer events emitted by Balancer ChildChainGauge contracts tracking gauge token movements between addresses. Records sender, recipient, and token amount for liquidity mining reward distribution and staking position transfers across Layer 2 and sidechain deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).

Sample Data

in__to	address	removed	in__from	in__value	log_index	block_number	block_timestamp	transaction_hash
0xc181edc719480bd089b94647c2dc504e2700a2b0	0x5c13c3b72b031b6405046c319b2d840d3c1403c7	false	0x0000000000000000000000000000000000000000	1702661367361029543	187	72778511	2025-06-15T00:45:31.000Z	0x67c44fc591d417bb44c4fe66b6cd1d985bcea981dad054a91b6dcd576b3ed9ed
0xc181edc719480bd089b94647c2dc504e2700a2b0	0x5c13c3b72b031b6405046c319b2d840d3c1403c7	false	0x0000000000000000000000000000000000000000	1702493870968079760	319	72796161	2025-06-15T11:11:41.000Z	0x1f334395808a56fef0a9a9b5123915ab74cddd00d49eef582d5c62d442fdacf1
0xc181edc719480bd089b94647c2dc504e2700a2b0	0x5c13c3b72b031b6405046c319b2d840d3c1403c7	false	0x0000000000000000000000000000000000000000	1685856650638764261	205	72813767	2025-06-15T21:38:41.000Z	0xe6c9d97a1e2135f4cd89eea165421f643ded3cd4947c63365074550795326422

Example Query

Query with partition filter

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

ChildChainGauge_UpdateLiquidityLimit_event

Liquidity limit update events emitted by Balancer v2 ChildChainGauge contracts, recording changes to user staking balances and total supply metrics. Contains original and working balance/supply values used for calculating gauge rewards and voting power across Layer 2 deployments.

Columns

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

Sample Data

address	removed	in__user	log_index	block_number	block_timestamp	transaction_hash	in__working_supply	in__original_supply	in__working_balance	in__original_balance
0x1f0ee42d005b89814a01f050416b28c3142ac900	false	0xb728311c5557f82050cda1bbe98dff6595be969a	129	53089722	2024-02-03T21:03:15.000Z	0x2f841ddc6bf8d966a49e36f97cdc8ca30a3d2e7b6d71e039339c9e69c82bfd08	960695665983723508015660	1334131426403560649717297	4379152157006868691072	10947880392517171727680
0x219b3a4a2d2351582277a87048995034ca7e9aef	false	0xe145de979b48984befc87f442b3660ff59975c1b	253	53068363	2024-02-03T08:05:20.000Z	0x2c5efe574c45657257ee1ad3365df5e1d68c6e8a609dd3a79a0834480b04260d	62433959747566060776	156084755871370733054	195016489612863959	487541224032159898
0x40b4c2e260f803f868053789bd4a6c7edd1cdc39	false	0x30407b54015c7341ed6f31bbafe07a32199fa3e0	149	53058274	2024-02-03T01:51:40.000Z	0x192d5900d2f52e8d234777d6325718efc933d6ba8176eef6e86afc740fce421a	70657524183925249767496	170465985692263169558098	2130153888362165221	5325384720905413053

Example Query

Query with partition filter

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

ChildChainGauge_Withdraw_event

Withdrawal events emitted by Balancer V2 ChildChainGauge contracts when users unstake liquidity pool tokens from gauges. Records the user address and token amount withdrawn in base units for tracking gauge participation changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	in__user	in__value	log_index	block_number	block_timestamp	transaction_hash
0x4dd47e45e0b7ad0b72fe163cbbd59a17c09b3eda	false	0xcdbbd921cbb4ef4ab48775cc42f630c02aec9b54	1138634244546048127	589	57228510	2024-05-21T16:34:14.000Z	0xeb6d6a7d5932b66c1fdf21416d575b1ba595bd1a06ba8a1ae370704ab81dadcf
0x5c13c3b72b031b6405046c319b2d840d3c1403c7	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	126126500262322674386	1094	57223855	2024-05-21T13:37:06.000Z	0xd630bcc12e0108cb23ec45e4fe2a27d2963be0c6dcaf80551c06c84a1f4178eb
0x5c13c3b72b031b6405046c319b2d840d3c1403c7	false	0xd9d3cf5fe2889190fed05e413abece5a38583a93	2290360891233047325	133	57207762	2024-05-21T03:26:55.000Z	0xf76c85c3b1694e281bd2cb85ace42790ec26b3999a0129b67fcf6d9ba1412723

Example Query

Query with partition filter

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

ChildChainGaugeFactory_GaugeCreated_event

Event logs emitted when a new gauge contract is deployed by the ChildChainGaugeFactory contract in Balancer v2. Records the address of each created gauge contract for tracking liquidity mining incentive distribution mechanisms across Layer 2 and sidechain deployments.

Columns

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

Sample Data

address	removed	in_gauge	log_index	block_number	block_timestamp	transaction_hash
0x22625eedd92c81a219a83e1dc48f88d54786b017	false	0x1f0ee42d005b89814a01f050416b28c3142ac900	3	41978521	2023-04-26T11:24:20.000Z	0xf10c7516debee9c9c607dc8bc906260d2ab343d2b4b4cf52e32203127985acd5
0x22625eedd92c81a219a83e1dc48f88d54786b017	false	0x3dd7f73d807b7aa4a1112b30319201e9798d27c4	387	50515587	2023-11-29T02:35:04.000Z	0x1957199a0d73033530b26650beaaa1fb65a26d77419a445ff095fdd588c2d42b
0x22625eedd92c81a219a83e1dc48f88d54786b017	false	0x15639b2f9159dfd4acf8ecf56222421ead906826	159	50828626	2023-12-06T23:53:21.000Z	0x60702f365537b7681824ee444f2cbbd569ed8ea2e4c1e7cbd9e68a95968b163d

Example Query

Query with partition filter

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

ComposableStablePoolFactory_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x136fd06fa01ecf624c7f2b3cb15742c1339dc2c4	false	177	37127292	2022-12-22T06:00:48.000Z	0x7884e4f12cbec4695cd6bda6cafa35a4a0c50859f2b15ec896c2f7b87afd23ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x136fd06fa01ecf624c7f2b3cb15742c1339dc2c4	0x94970a3f6a6aab442aefad68ff57abec0b9e3c01	false	133	34706704	2022-10-23T16:18:23.000Z	0x7ca8e2e51746be9af197ddc6cb5e14589457993ac4f1635505fc846d01c2fcb2
0x136fd06fa01ecf624c7f2b3cb15742c1339dc2c4	0x7982c1b61abdc36942301ff2377d92b43784f120	false	103	34706837	2022-10-23T16:22:57.000Z	0xfbfca8921366d0a8e1003eb224753b94d59e6e4f70bc9a542dc4d3034c15efa7
0x136fd06fa01ecf624c7f2b3cb15742c1339dc2c4	0x92bc61bd96f275ea5507a3e1e5fbf0bc69cc98dc	false	124	34706573	2022-10-23T16:13:52.000Z	0xfc5354c7c238a4d48c048db33680fadd9798f61160fe6c8d26b05ffe034aba38

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	366	37743618	2023-01-06T13:27:39.000Z	0xcd12cc84431baa89f7eeb04f69157cafb39510528d342141a57df901701ab2ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x600bd01b6526611079e12e1ff93aba7a3e34226f	false	159	37469845	2022-12-30T18:04:27.000Z	0xd3c9706c303cfed8b205e5dba25cb78c8586cf50892a8c295544732a0201b792
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x31bccf9e28b94e5dacebaa67fe8bc1603cecd904	false	180	37724059	2023-01-06T01:51:08.000Z	0x8e8e81e449850d97630df8b8fb9fb8cbba7e1d989392db4387eed99271e78b9b
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x7079a25dec33be61bbd81b2fb69b468e80d3e72c	false	293	37699986	2023-01-05T11:22:18.000Z	0x117fc5bd8904da15bc09713e8475af2bb78907a75cba49a10d95a59fb70996b8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x7bc6c0e73edaa66ef3f6e2f27b0ee8661834c6c9	false	308	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x7bc6c0e73edaa66ef3f6e2f27b0ee8661834c6c9	0x10b040038f87219d9b42e025e3bd9b8095c87dd9	false	209	40602485	2023-03-21T13:59:27.000Z	0x5cd681554cc598e93ba4ad292f7042a54990ce567fee29754692f9b963a9e200
0x7bc6c0e73edaa66ef3f6e2f27b0ee8661834c6c9	0xd80ef9fabfdc3b52e17f74c383cf88ee2efbf0b6	false	375	39185224	2023-02-11T20:37:40.000Z	0x5a99ff3e4b9236153d5ae52c1288df77b7da5a67f7ec2b8f148c041e8a000ce1
0x7bc6c0e73edaa66ef3f6e2f27b0ee8661834c6c9	0x3db543faf7a92052de7860c5c9debabee59ed5bd	false	282	39171412	2023-02-11T11:46:18.000Z	0x8d68bee298571775401519892b2c9cea31e89e3ed7905265f6db1efb788dea86

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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_polygon.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
0x6ab5549bbd766a43afb687776ad8466f8b42f777	0xa2ccad543fbe9332b87910beabd941b86dd5f762	false	221	42458360	2023-05-08T15:31:10.000Z	0xed8d91b31c3416de6d52db3e95bb3e4f01b5a9ea222658fdf0f9ba5a5f2d14a1
0x6ab5549bbd766a43afb687776ad8466f8b42f777	0x0f25823cf786b78696b16536e2f2b9835289ab51	false	158	40613559	2023-03-21T21:25:26.000Z	0xa56b9702b257d75d86c4d494f574f105929abc9be9ad16e4428430b0bb621086
0x6ab5549bbd766a43afb687776ad8466f8b42f777	0xee39953381c22b814adae305e117a91266142198	false	503	44236881	2023-06-23T07:53:12.000Z	0x6d58ba51215ba51be7a1039206674d5af2b97755ed71e9618af96e2868b5013b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xe2fa4e1d17725e72dcdafe943ecf45df4b9e285b	false	239	58706372	2024-06-28T11:11:57.000Z	0x7f4e7cfd8ac053cbf58521e4c875290acf03cde16e4d42ad57f9bb48e120f27d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xe2fa4e1d17725e72dcdafe943ecf45df4b9e285b	0x70ff0078d55ce9c1a0e668f35eb4400a4300122d	false	557	45069281	2023-07-14T12:58:26.000Z	0x19b55e0558ab5333f1195dc34b7a357f8c06b638f9585f793ebc871885ae9227
0xe2fa4e1d17725e72dcdafe943ecf45df4b9e285b	0x42942cdec85078cf0e28e9cb5acd40cb53997ed6	false	193	45069027	2023-07-14T12:48:50.000Z	0xee539f6d17d07339abde3dfd8ce3d99d9286cdeb3b56345907f040b64d94bfda
0xe2fa4e1d17725e72dcdafe943ecf45df4b9e285b	0x4cd8a3df2536100ec552a37c813a9414123e1c03	false	117	51625253	2023-12-27T16:36:05.000Z	0x04927dbd87645cf83c7ceed4fa677bc0d317ca44642dec3678a4a17520c83383

Example Query

Query with partition filter

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

ERC4626LinearPoolFactory_PoolCreated_event

Pool creation events from Balancer v2’s ERC4626 Linear Pool Factory on Polygon, tracking deployment of yield-bearing linear pools that integrate ERC-4626 vaults. Used for monitoring new pool launches and analyzing factory deployment patterns.

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
0xc6bd2497332d24094ec16a7261eec5c412b5a2c1	0xb878ecce26838fbba4f78cb5b791a0e09152c067	false	4	26535966	2022-03-30T10:51:44.000Z	0x89836f71069746d3530d193ef1289fba6320646aa106b6209fc7d1dc80143e80
0xc6bd2497332d24094ec16a7261eec5c412b5a2c1	0x6933ec1ca55c06a894107860c92acdfd2dd8512f	false	4	26535997	2022-03-30T10:52:46.000Z	0x2222b0ebdca31be201b320f10f898e5cd5c8d9fd9a0b0d4aa3c074d4ea76f94a
0xc6bd2497332d24094ec16a7261eec5c412b5a2c1	0xcb21a9e647c95127ed784626485b3104cb28d0e7	false	6	26534338	2022-03-30T09:55:02.000Z	0x58091846eff6345f009a631a621c2067554155c10e48b7fc09909c938f49ee07

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV2_PoolCreated_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xe4885ed2818cc9e840a25f94f9b2a28169d1aea7	false	223	41169997	3	2023-04-05T11:08:58.000Z	0x8213cc2635e1d0dbc0602fab03f9543a8a6fa831a8de8e41a01ea8549350e0b0
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xb59be8f3c85a9dd6e2899103b6fbf6ea405b99a4	false	483	41416764	3	2023-04-11T19:03:44.000Z	0xaad1bfdb989ee7c8e3a6e038da39786f2f33778777a1aa792489ccf6117dae20
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xa5fe91dde37d8bf2dacacc0168b115d28ed03f84	false	183	41416812	3	2023-04-11T19:05:26.000Z	0xce3b998dd744a56698e2f0b7dc28d60740accd4401f09ac46d8d4390ed02b56c

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV3_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	false	310	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV3_PoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xe1fb90d0d3b47e551d494d7ebe8f209753526b01	false	294	40148052	2023-03-09T14:12:28.000Z	0xab88ce7280c2b2c30b72b73dc0939002208625ca2295439dfc4861be4d0929b1
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0x7c82a23b4c48d796dee36a9ca215b641c6a8709d	false	294	40148297	2023-03-09T14:21:40.000Z	0x0676c48fccd6ae288b385eb6c5b67d8cffcc9db5be8ab905737900358b53a731
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0x894c82800526e0391e709c0983a5aea3718b7f6d	false	516	40148063	2023-03-09T14:12:50.000Z	0x7cf552fc4e8651fd02091c37656dcef23a036672919539b06d4a39f15842b517

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	0x25e57f4612912614e6c99616bd2abb9b5ae71e99	false	137	45205001	3	2023-07-17T23:15:12.000Z	0xde2f22d109b6e131b2fafa390a1b29b06165c52fa879defc6f8be46978f8bf82
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	0x63ce19ccd39930725b8a3d2733627804718ab83d	false	652	45205287	3	2023-07-17T23:25:20.000Z	0x9b70b505451012cdc00e3b3fd3b2229c8c3c46888da028df566493d5fc4e45f0
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	0x89bb15076c9f2d86aa98ec6cffc1a71e31c38953	false	121	45205160	3	2023-07-17T23:20:50.000Z	0x28753d2a39f33c346c3b2033e55293f13f5bda05449f3ba167f47d61d9452ed7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	false	202	46633724	2023-08-22T22:35:41.000Z	0xe039eaed246d26abe5fe601955b9ca9ce449ed47de9bccadca7b57c208d861ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	0xc55ec796a4debe625d95436a3531f4950b11bdcf	false	575	41502992	2023-04-14T00:51:52.000Z	0x4ab9c07eb8dcc4c492943b75ccb7bfaed7ba6358b79d7587c6215a5cc137d8c1
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	0xb0c830dceb4ef55a60192472c20c8bf19df03488	false	282	44993397	2023-07-12T14:58:32.000Z	0xe9e1dd5138ae20dbf52452a9b06d750d9b53fe1c20d28f22b8625938164705f5
0x5c5fcf8fbd4cd563ced27e7d066b88ee20e1867a	0x230ecdb2a7cee56d6889965a023aa0473d6da507	false	204	45205351	2023-07-17T23:27:36.000Z	0xe3770c3cb8e79fde33f582dc71a0ef5d16b76c26f36db3d9125b33e6880b0ca2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.ERC4626LinearPoolFactoryV4_PoolCreated_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 Polygon. Tracks new managed pool deployments with pool addresses and factory contract 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
0x0f7bb7ce7b6ed9366f9b6b910adefe72dc538193	0xc113e59274d681747e2fc93204028a4ecd79d922	false	133	20462483	2021-10-21T19:47:21.000Z	0x8000fa4b9e306689243a7f79eaf98404607d82d540c9a88e50932a1792003091
0x0f7bb7ce7b6ed9366f9b6b910adefe72dc538193	0x95a28a3be5ed7b5bfc01c804fa33877853527756	false	73	20462547	2021-10-21T19:49:33.000Z	0x86eed70fd0bcf2e0d825c14e4d0d3299764e6d1260159b8fbfbb01e643b65447
0x0f7bb7ce7b6ed9366f9b6b910adefe72dc538193	0xdf58b99e5622cd31eb7eee29a7428bb57a4c22dd	false	179	29299184	2022-06-08T02:53:04.000Z	0xff9a2076287a98fd8116d2f5b74383e62c8302a6dc7857b11fd71e16b753fd98

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0xe5769603af1c9ec809dd5cfbc7fee36e7f09a3e6	false	437	21723480	2021-11-23T23:04:44.000Z	0x9175e597d609b65365ec0aaadd05c2883c950884c0222716ec1005f1e54d9cfc
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	0xaaac5297f76ed0158b2a39639d71647b7f2eb6be	false	538	21724501	2021-11-23T23:42:43.000Z	0xc0cd4942750a872abd1c80830a9621d8a12fa0263e94200c448ac84f25fbadde
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	0x89d4a55ca51192109bb85083ff7d9a13ab24c8a1	false	793	21712795	2021-11-23T16:23:58.000Z	0x7b427088e37dd0581224a6ab861dbceb20353b221f67418b0c30186c7a0c3ba4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	305	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xb8dfa4fd0f083de2b7edc0d5eed5e684e54ba45d	false	103	79274442	2025-11-20T15:51:55.000Z	0xb24ab61c335111f4d6c6c9431bc9b7c8ef388543b7f73281dc1edc569e640a62

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xb8dfa4fd0f083de2b7edc0d5eed5e684e54ba45d	0x77816998ed420f9c6eb5d6cb3f9a5f9eff884c11	false	194	42808481	2023-05-17T08:45:00.000Z	0x7cac77b590a5df62e9aaee8260ce3044301b14026ff8fbd1109a9e244fff57e5
0xb8dfa4fd0f083de2b7edc0d5eed5e684e54ba45d	0x4e416f139efdfe48afd2f8312747fc85600b227e	false	358	42818209	2023-05-17T14:46:28.000Z	0x30af1f6c389309ab72365bc3ab59fbb79ad8a4a181aa2d469037c9ee9c43e444
0xb8dfa4fd0f083de2b7edc0d5eed5e684e54ba45d	0xc8bd2457d65f5fa728728be53827b142c6e36d54	false	552	44450080	2023-06-28T20:06:40.000Z	0xfcaccf806c5a0b9e09e08f6a99bc76324bddc50fa6cccf4de103432302fc1d60

Example Query

Query with partition filter

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

MerkleOrchard_DistributionClaimed_event

Reward claim events from Balancer V2’s MerkleOrchard contract on Polygon, recording token distribution claims with claimer, recipient, distributor addresses, and claim amounts. Used for tracking liquidity mining rewards and incentive program participation across distribution 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 the specific Balancer reward distribution campaign from which tokens are being claimed. Each distribution ID represents a distinct merkle-based rewards period or campaign.
`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
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	119899400000000000	278	0x1ea8a177fbf8e6c5b76905a5c5d9ae7d16ee695c	23806028	0x1ea8a177fbf8e6c5b76905a5c5d9ae7d16ee695c	0x632208491602dd205da8cb9c0ba98620fc19854a	2022-01-17T00:11:37.000Z	0x0f7e88bb0104f4e18681f42c96fb158da744e964f9f3d1c1e72ae82bc54f4fa5	5
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	109864600000000000	279	0x1ea8a177fbf8e6c5b76905a5c5d9ae7d16ee695c	23806028	0x1ea8a177fbf8e6c5b76905a5c5d9ae7d16ee695c	0x632208491602dd205da8cb9c0ba98620fc19854a	2022-01-17T00:11:37.000Z	0x0f7e88bb0104f4e18681f42c96fb158da744e964f9f3d1c1e72ae82bc54f4fa5	6
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	125069600000000000	277	0x1ea8a177fbf8e6c5b76905a5c5d9ae7d16ee695c	23806028	0x1ea8a177fbf8e6c5b76905a5c5d9ae7d16ee695c	0xbd44c01ec7d623372b4572247afb6231edd8486f	2022-01-17T00:11:37.000Z	0x0f7e88bb0104f4e18681f42c96fb158da744e964f9f3d1c1e72ae82bc54f4fa5	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.MerkleOrchard_DistributionClaimed_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
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	0x34a81e8956bf20b7448b31990a2c06f96830a6e4	false	446	37949056	2023-01-11T15:57:26.000Z	0x1858e3c0b1c40ca62f289a9902fc0a730443d595ad16b343cb70915fe1c9b9d9
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	0xaf5e0b5425de1f5a630a8cb5aa9d97b8141c908d	false	111	25510304	2022-03-02T22:44:00.000Z	0xa4455a09a0e976c91172ac378dfaf7294506c7b0ce2b6b0b106510d0c97554dd
0xdae7e32adc5d490a43ccba1f0c736033f2b4efca	0x61d8c210aadcf9fe432f16a8a33ca92931521565	false	323	25509268	2022-03-02T22:05:43.000Z	0x3a06c16196e55390902ccad16d25026cb7522bacebe188f52708ef9cf59e08ce

Example Query

Query with partition filter

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

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

Event logs emitted when a Balancer V2 Liquidity Bootstrapping Pool (LBP) factory contract is disabled. Records administrative actions that prevent new pool creation from the factory.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x41b953164995c11c81da73d212ed8af25741b7ac	false	104	79274442	2025-11-20T15:51:55.000Z	0xb24ab61c335111f4d6c6c9431bc9b7c8ef388543b7f73281dc1edc569e640a62

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x41b953164995c11c81da73d212ed8af25741b7ac	0x2ec8df9e61c6b963a183896dbb923b5154ee64d6	false	145	30747658	2022-07-15T09:41:39.000Z	0x22aae3ef2a7d703287357dabbac2cd2812625a440e0e836b456e9127abcd23d3
0x41b953164995c11c81da73d212ed8af25741b7ac	0xf11e0e13649c68eb3921e108cb8b08ca3b89055a	false	238	24007816	2022-01-22T01:45:55.000Z	0xe069a8eb495242261cfdbefad690ec651f154312c2cee549abc3571ceab25d5a
0x41b953164995c11c81da73d212ed8af25741b7ac	0x6579388c71e17243904087f0e8b7f320c8b750be	false	363	22983958	2021-12-26T11:56:12.000Z	0xe43267ade990fd45c1ec726076eb6ad82bb094bce3eada06e19cde580f360ebf

Example Query

Query with partition filter

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

Pool_RecoveryModeStateChanged_event

Balancer V2 pool recovery mode state change events emitted when pools enter or exit recovery mode. The in_enabled flag indicates whether recovery mode was activated or deactivated for emergency liquidity withdrawals.

Columns

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

Sample Data

address	removed	log_index	in_enabled	block_number	block_timestamp	transaction_hash
0x9d75cc71555ddabcb89b52c818c2c689e2191401	false	162	true	37742045	2023-01-06T12:31:19.000Z	0x5dcd82ad817973249052b125a597ee38a727f2a700747eda3c68f42055a43660
0x7d60a4cb5ca92e2da965637025122296ea6854f9	false	161	true	37742045	2023-01-06T12:31:19.000Z	0x5dcd82ad817973249052b125a597ee38a727f2a700747eda3c68f42055a43660
0xe22483774bd8611be2ad2f4194078dac9159f4ba	false	303	true	37742710	2023-01-06T12:56:17.000Z	0xc43d37b2afe0495fbe2399a801b2c7571085ee3c5427f4a4ac6064292c2aa5e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x385fd3414afb52d5cd60e22f17826cf992060244	false	39	62201575	2024-09-24T02:56:16.000Z	0xe196e2697d6cfd8c4cb06ef680f42b4967ebcec27677ed84933b9cc88ee3244e	3000000000000000
0x385fd3414afb52d5cd60e22f17826cf992060244	false	33	62201575	2024-09-24T02:56:16.000Z	0xe196e2697d6cfd8c4cb06ef680f42b4967ebcec27677ed84933b9cc88ee3244e	600000000000000
0x385fd3414afb52d5cd60e22f17826cf992060244	false	343	62220641	2024-09-24T14:19:57.000Z	0xf83853487b0857066747a0debafe27a1fb3a6d92b37329e5ff83c94966a0a7ae	600000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x7040ab396d75b9bac78fd85cecc2c2556b514144	0x0297e37f1873d2dab4487aa67cd56b58e2f27875	0x0000000000000000000000000000000000000000	false	10060880696356216	884	37975183	2023-01-12T07:10:03.000Z	0x03dd15b7209a75b43c29dc5454c8f375e1684208dd9d890ad4dc797bf3ed43c1
0x068ff98072d3eb848d012e3390703bb507729ed6	0x0297e37f1873d2dab4487aa67cd56b58e2f27875	0x7040ab396d75b9bac78fd85cecc2c2556b514144	false	10060880696356216	188	37975291	2023-01-12T07:13:43.000Z	0xa590984b6813e1ff15f7a05fd14ecfaf071c3549fc3fc750e5a33f7ecc5f3a43
0x068ff98072d3eb848d012e3390703bb507729ed6	0x0297e37f1873d2dab4487aa67cd56b58e2f27875	0xb31724d1c04b4a67ddd4f2b67d65507062a42883	false	10179535743914070	320	37964562	2023-01-12T01:02:04.000Z	0xfcdca351df604e320abe398347603c2d6fc9c81628cb89c2010aadcdfe1e60c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0xd9b84f68af362159da621473ef0f979709734db6	false	264	20780207	2021-10-30T12:48:56.000Z	0x0af6768cb649356147199f3e2c60d342c5412c83a6833d677d4e85bbb9bcff7f
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0xcf4dcadfe05a5a37472d7f11e0643a7b7585d50a	false	167	39654945	2023-02-24T11:37:00.000Z	0x519765c1b64085c3234e8de91243b79b4cf68b9c830a7892ef6e2c1ff60cad4d
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0x2322c2e8ee30661b446a9c64c291bf0bb0c93264	false	159	39645924	2023-02-24T05:47:48.000Z	0x8a531b3d12856428dad1de5d17f730c5255b050d22ff460a9e1dc1f562b2179e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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_polygon.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	135	22482469	2021-12-13T17:38:33.000Z	0x393db16facd5d0a3f84bd183c943e889e9b1b841959e1d31db2c7b8ebbf82589	100000000000000000
0xce88686553686da562ce7cea497ce749da109f9f	false	18	25025173	2022-02-16T22:13:34.000Z	0x0e5d2108213e1670284340e05e9621dcd3061e66b53d7910d8e2dd4186abd8ec	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.ProtocolFeesCollector_SwapFeePercentageChanged_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
0xc128a9954e6c874ea3d62ce62b468ba073093f25	0xf48f01dcb2cbb3ee1f6aab0e742c2d3941039d56	false	13	26777380	2022-04-05T15:03:15.000Z	0x99686edd3c9efa9e1ea6753eb613d91c2766fe57d15dccf9a80d673bdd4df121
0xc128a9954e6c874ea3d62ce62b468ba073093f25	0xe051605a83deae38d26a7346b100ef1ac2ef8a0b	false	122	26000599	2022-03-16T10:15:45.000Z	0xc6ab10eca2f7414a956a8a331993c3f395cd056b797743d9d1fb013cda473edb
0xc128a9954e6c874ea3d62ce62b468ba073093f25	0xb973ca96a3f0d61045f53255e319aedb6ed49240	false	16	26620779	2022-04-01T15:09:28.000Z	0x9d5266e04cd853bc892c4753915e29a87d816779a124c1c37e617fc4d7cbf93d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0xb4670d1389c758e4380c4211bcbc85342688b9c5	false	450	26077110	2022-03-18T14:04:39.000Z	0x908c1a5040ce1aad47723262250aff23674493afb513695e7b0a378bf332a4f5
0xc66ba2b6595d3613ccab350c886ace23866ede24	0xc31a37105b94ab4efca1954a14f059af11fcd9bb	false	42	26828212	2022-04-06T21:37:59.000Z	0x9f503d4d9e034effcc95d670230f26f0f938bb7ba95cb72f3a64479e3a906b3a
0xc66ba2b6595d3613ccab350c886ace23866ede24	0x6aa098a327b8001a24713f6970980d70f2fbdaea	false	76	26828002	2022-04-06T21:30:47.000Z	0xd7ff5524794cf84c0f8a544c428e9c7cb6ab02fcbdc7066cc3eef7f90dd3225b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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_polygon.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
0xca96c4f198d343e251b1a01f3eba061ef3da73c1	0x2492b06d0c980c5a480c72c20e6791eb27e92b24	false	176	29523856	2022-06-13T16:44:16.000Z	0x155be869efc8c8c04f96807b54964c3f34dce9b34351985ff83313f38e4dccc7
0xca96c4f198d343e251b1a01f3eba061ef3da73c1	0xb4b22bd6cdad0ab828be6f8a4086dfa54e9b3736	false	346	29523852	2022-06-13T16:44:08.000Z	0xd3caae1e09324fd3d25694095e05483cd1a6be0114b24cb483b195a4b123955f
0xca96c4f198d343e251b1a01f3eba061ef3da73c1	0xb797adfb7b268faeaa90cadbfed464c76ee599cd	false	21	29684839	2022-06-17T17:45:34.000Z	0x85aabe2964e1968587c2ab711c09b6c6d77d42e2f8e9737dc56a7752c35eb14b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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_polygon.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	212	15832990	2021-06-17T19:10:11.000Z	0xa331d84ec860bf466b4cdccfb4ac09a1b43f3ae6	0x66f275a2ed102a5b679c0894ced62c4ebcb2a65336d086a916eb83bd1fe5c8d2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	238	42532299	2023-05-10T11:39:50.000Z	0x020301b0a99efb6816b41007765fb577259ec418	0x7471717a1ff9061d66c16a162fef7660dcd7642012e26ab40d33243a3bba06b9

Example Query

Query with partition filter

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

Vault_batchSwap_function

Batch swap function calls to the Balancer V2 Vault contract on Polygon, capturing multi-hop token swap attempts with input parameters, asset deltas, and execution status. Used for analyzing complex swap routing patterns and failed transaction behavior.

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`	`NUMERIC`	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 steps defining the token exchange path, pool identifiers, and amounts for each leg of the batch swap operation. Empty when transaction fails or is simulated without executing actual swaps.
`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>`	Array of maximum allowable asset deltas for each token in the swap, enforcing slippage protection. Negative values indicate maximum tokens to send, positive values indicate minimum tokens to receive.
`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 net token balance changes for each asset involved in the batch swap, returned by the Vault contract. Positive values indicate tokens received, negative values indicate tokens sent.

Sample Data

gas	status	gas_used	in_swaps	in_assets	in_limits	signature	to_address	block_number	from_address	block_timestamp	out_assetDeltas	transaction_hash
117393	false	101325	[]	[]	[]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	35069699	0x6c4dc34e062b4b62a3bb2dc928c65a74f7c980b3	2022-11-01T13:56:23.000Z	[]	0xb42269d146fdfb9bf2ecf770861424b1a17645520ae491e4d8285a74807906d7
117393	false	101325	[]	[]	[]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	35076545	0x6c4dc34e062b4b62a3bb2dc928c65a74f7c980b3	2022-11-01T17:52:05.000Z	[]	0xb6236c2bdb4efba3d64e1d1e2f6a4f8f51a0d6ffed3a4d23469e2b9b4cba4275
117262	false	101201	[]	[]	[]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	35069277	0x6c4dc34e062b4b62a3bb2dc928c65a74f7c980b3	2022-11-01T13:39:43.000Z	[]	0x414250de5453ee476e3e4b7e3e57e90a0ee4a6768ef62dafb872e8d8b286b5ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x9928340f9e1aaad7df1d95e27bd9a5c715202a56	1855863603508080796029	0x064f155a887810006b05de59358b3cdf06db0644	216	34990566	0xcf6a66e32dca0e26acc3426b851fd8acbf12dac7	2022-10-30T14:59:48.000Z	0xfc6e8c3ca5df1d2e8f0a943cae89d872c84e5451d986cab859c20115e3b3a9f3
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x48534d027f8962692122db440714ffe88ab1fa85	27929058179017150947	0x6c7c3806b3cae601b1d99c017e4592753ba8d41e	177	34977582	0xcf6a66e32dca0e26acc3426b851fd8acbf12dac7	2022-10-30T07:18:10.000Z	0x85c4d75aec273d342c4787ac0d5da1d6c6bc0eb8bc3d34a3ae93327d7116188c
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x0d6135b2cfbae3b1c58368a93b855fa54fa5aae1	438923755811398922798	0xa1b39e97080b110b3517f2deddcc4b2b92102c9d	408	50839631	0xd18d5d377eb23362e54fa496597d7e962d56c554	2023-12-07T06:29:46.000Z	0x532560c684c8af37ca01ff06243aa7108436ea1f1a61d22972c80ded678a2e80

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	11755605	204	62232450	0x0869c28a5d0070c14152f12d6fb9ff4fc530eb05	2024-09-24T21:22:24.000Z	0x2cc34bc231667c47e7b2b2f3a31175e3850ee6d23bb2ad0c600682f10af6fada
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	41028171	158	62199455	0x0869c28a5d0070c14152f12d6fb9ff4fc530eb05	2024-09-24T01:41:03.000Z	0x1daea7c944097347e933b3f7c47d656ed73afa8098196288d37fb1be709aa55c
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	10269486	51	62215928	0x0869c28a5d0070c14152f12d6fb9ff4fc530eb05	2024-09-24T11:29:12.000Z	0x053600386512a3f942f3d2112cf2c29085866c2e35df15cb68e29816b8739bc7

Example Query

Query with partition filter

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

Vault_flashLoan_function

Flash loan function calls to Balancer V2 Vault contract on Polygon, including requested tokens, amounts, recipients, and execution status. Useful for tracking flash loan usage patterns and analyzing failed loan attempts.

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`	`NUMERIC`	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. Often null when no additional parameters are needed beyond the standard flash loan parameters.

Sample Data

gas	status	gas_used	in_tokens	signature	in_amounts	to_address	block_number	from_address	block_timestamp	transaction_hash
1783119	false	1340501	[]	0x5c38449e	[]	0xba12222222228d8ba445958a75a0704d566bf2c8	34038386	0x027d24217f18822e6ce11821524c212f507d0787	2022-10-07T09:05:04.000Z	0x80921453ded43b884f8244583dac3337d4e1f3526d7ca908b7e7bbb4057b7e4d
972817	false	716713	[]	0x5c38449e	[]	0xba12222222228d8ba445958a75a0704d566bf2c8	34046145	0x027d24217f18822e6ce11821524c212f507d0787	2022-10-07T13:31:58.000Z	0xb8157d8f1eae075017e1946dd8c8085d32754f1ed0ec0b0c6a95749149734d68
2392755	false	1788113	[]	0x5c38449e	[]	0xba12222222228d8ba445958a75a0704d566bf2c8	34059812	0x027d24217f18822e6ce11821524c212f507d0787	2022-10-07T21:26:12.000Z	0x3fd618e830e5dc5fcbb1b606d4ebb5417f125952946fa84813873ace557a1264

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x1f1adde14239d469086dfd49a2a9235050c84c51	false	0	0x43894de14462b421372bcfe445fa51b1b4a0ff3d	497	43457781	2023-06-02T21:04:06.000Z	0xea6518619e602610c38dffa990ec76b9d297048d7915b7b869382b0692074b4e
0xba12222222228d8ba445958a75a0704d566bf2c8	0x356e9563ce4007a251f00fa49508494102c6d353	false	11807045156067327224	0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3	185	43425959	2023-06-02T00:03:43.000Z	0x4323f5dcf39e93f333abf66cf006b07559e4978f4e430d403d0fb0d88f40e0de
0xba12222222228d8ba445958a75a0704d566bf2c8	0x356e9563ce4007a251f00fa49508494102c6d353	false	-11807045156067327224	0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3	187	43425959	2023-06-02T00:03:43.000Z	0x4323f5dcf39e93f333abf66cf006b07559e4978f4e430d403d0fb0d88f40e0de

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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_polygon.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	[“-5980452152420740844735”,“-7399109513”,“-2239748378954327380”,“-334543417798331005101”]	0x0297e37f1873d2dab4487aa67cd56b58e2f27875000100000000000000000002	[“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3”]	333	19753822	2021-10-02T09:54:39.000Z	0x90762aebd7add9eec96746e523be2eb101032e95568688cd092bafed81a6df49	0x180d1994a0d0ce7c3f1490cf901133c2623f57cc	[“0”,“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“40753255”,“0”,“0”]	0x0297e37f1873d2dab4487aa67cd56b58e2f27875000100000000000000000002	[“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3”]	154	19764880	2021-10-02T16:49:29.000Z	0x007f74f010502fa33bfbbec8136c81d5b47e04c5e5c60e60b81905aab9fbb2f6	0x7cadaa9f9ff0b58eb9306744b737e22eed384345	[“0”,“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“0”,“0”,“306536932900000000”]	0x0297e37f1873d2dab4487aa67cd56b58e2f27875000100000000000000000002	[“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3”]	16	19741516	2021-10-02T02:32:05.000Z	0xba72a65c7f13690f460b5fc2ebeb946bbfad5015e5373011841f56d723dad07d	0x745de4ac392d7666f7e212d6cb05cf164d26cdcb	[“0”,“0”,“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x113f3d54c31ebc71510fd664c8303b34fbc2b355	0xae646817e458c0be890b81e8d880206710e3c44e000000000000000000000acb	153	44848770	-74648110999	2023-07-08T23:34:22.000Z	0x9756549a334bd48423457d057e8edbfaf2104b16	74648110999	0x424e26f59930409198fe10d0e97db99adddbd3a30cec337a941d2467ad497a1a
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x113f3d54c31ebc71510fd664c8303b34fbc2b355	0xae646817e458c0be890b81e8d880206710e3c44e000000000000000000000acb	154	44848770	0	2023-07-08T23:34:22.000Z	0x9756549a334bd48423457d057e8edbfaf2104b16	-74648110999	0x424e26f59930409198fe10d0e97db99adddbd3a30cec337a941d2467ad497a1a
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0xae646817e458c0be890b81e8d880206710e3c44e000000000000000000000acb	189	44848770	0	2023-07-08T23:34:22.000Z	0x9756549a334bd48423457d057e8edbfaf2104b16	75350686554	0x424e26f59930409198fe10d0e97db99adddbd3a30cec337a941d2467ad497a1a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x2c0ba0cd688cdf79bc9ec54858ae045a9fd94fa3000100000000000000000a0b	409	37885049	0x2c0ba0cd688cdf79bc9ec54858ae045a9fd94fa3	2023-01-10T02:44:25.000Z	0xf51c316bb5d51bd5ca2c812509469ba16bd04d17aea40d8a9200904b99044b4a	1
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xa1afc1e57de5b45daab1631fd1193a1a423ffa21000100000000000000000a0d	342	37913415	0xa1afc1e57de5b45daab1631fd1193a1a423ffa21	2023-01-10T19:13:34.000Z	0x87fc027594e70e781398f8e62646ca6d966a0a542988b18073f758df8a310a99	1
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xbaebef6632c4cef3a81ebced25744bb485adcda7000100000000000000000a0e	160	37913831	0xbaebef6632c4cef3a81ebced25744bb485adcda7	2023-01-10T19:27:52.000Z	0x3b4d24d5100e755711ada79325b5943cbaecbfe5aab461b5be2ff196f23b4725	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x9ba7f0ae62b9f0db305ecf65c65fc93fd710696c	328	0xb1ed8d3b5059b3281d43306cc9d043ce8b22599b	true	74512916	2025-07-28T12:07:05.000Z	0x46890496527077ff6f9d598197ded636447e0146cc1577e74a4425831d468670
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x9008e2a8c9f6e4fe77ccf98b58652176e4451ec0	474	0xb1ed8d3b5059b3281d43306cc9d043ce8b22599b	true	74498705	2025-07-28T03:43:45.000Z	0x1d6bb17ff8715682629894cce42b792d471a30ac6fd97e3ca40c5bf4a11cd776
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x8d198fc0e5254cc969b955a5718d05e388150aa0	175	0xb1ed8d3b5059b3281d43306cc9d043ce8b22599b	true	74524153	2025-07-28T18:46:27.000Z	0xc784561f523986f6a5525ef3171ad452aeb5c59a443f9cafe23eed4f67fabc5e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x6bd5fb546456d8819efa086b51fce3776475ac19000100000000000000000494	153	0x0169ec1f8f639b32eec6d923e24c2a2ff45b9dd6	64248589628563214932	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	47290525	1071756522957770091	2023-09-08T10:25:35.000Z	0x0926d26ef1cb5c845d128398bbbe2408ea89044bd002469de5a1a2190aee2947
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x8ae82fd20cab98ec31d68a9e6b73faa620f414610001000000000000000008f6	2632	0x0297e37f1873d2dab4487aa67cd56b58e2f27875	1084816328044125	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	47311311	19184156819514996	2023-09-08T23:03:27.000Z	0x3081d485b7a2e4e433121676dc8a6bdbb794acd67172a7b9f4acf69f107953d3
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xe93a1e6fb57d2e2be40377841a6477cfe1ef55c2000100000000000000000bbb	617	0x033d942a6b495c4071083f4cde1f17e986fe856c	3475296	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	47299011	13362861	2023-09-08T15:31:59.000Z	0xd6ad2044751d594659529515e2bdd1043c2f85dd55a959f5ec04540977c8ee45

Example Query

Query with partition filter

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

Vault_swap_function

Swap function calls to Balancer V2 Vault contract on Polygon, including both successful and failed transaction attempts. Useful for analyzing swap execution patterns, gas consumption, and transaction failure rates across Balancer 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.
`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`	`NUMERIC`	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 input parameters defining a single token swap on Balancer V2, including pool ID, token addresses, and swap amounts. Frequently null in the samples, indicating failed or internal swap calls within multi-step transactions.
`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`	Maximum acceptable token amount for slippage protection in the swap operation. Null when swap parameters are not captured or transaction failed before execution.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`out_amountCalculated`	`STRING`	Calculated token amount output from the swap transaction on Balancer V2 Vault. Null when swap fails as indicated by false status.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
639267	false	7313	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	69529205	0x3cb2452c615007b9ef94d5814765eb48b71ae520	5,6,1	2025-03-26T16:21:43.000Z	0x97b0bb588126751564685ab370d58942292503069e84cda04665f5c9940903fc
820719	false	7313	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	69527340	0x3cb2452c615007b9ef94d5814765eb48b71ae520	5,6,2	2025-03-26T15:15:10.000Z	0xe0f1e63f12a55d4ba63c9f8e1c7f65de696728b8e2d0ec7e6d4f38bbd83673ef
630500	false	7313	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	69529205	0x3cb2452c615007b9ef94d5814765eb48b71ae520	5,6,2	2025-03-26T16:21:43.000Z	0x97b0bb588126751564685ab370d58942292503069e84cda04665f5c9940903fc

Example Query

Query with partition filter

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

address	removed	in_poolId	in_tokens	log_index	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb717a8de7ceb31dde31ccaae350f89b7203b7c97000100000000000000000b61	[“0x172370d5cd63279efa6d502dab29171933a610af”]	207	42623279	2023-05-12T18:14:19.000Z	0xcbfa3eb2f83a43d65a6b475de15135083d0715d2915bef732fdd70d6c6160126
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x763db85040032ad8b8430af336d3b265eafe58ba000100000000000000000b64	[“0xc3c7d422809852031b44ab29eec9f1eff2a58756”]	668	42614592	2023-05-12T12:43:42.000Z	0x488aaf675edb34d4fe502ca9ed2a1282139451d39ee5c2c8b7e8e62111e46ccf
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x20703aa47956deb5aa826dedb3e6d2a3e2603dc4000100000000000000000e41	[“0x366e293a5cf90a0458d9ff9f3f92234da598f62e”]	390	59883873	2024-07-27T20:39:47.000Z	0x97bb7a5d825aa2756161a39689a2d3703afcf7ae928e9a0d41aea058b3c20ddc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0xce220a47b80cc8ec2dfc62732448fbc17c13bd83000100000000000000000eef	[“0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd”,“0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6”,“0x2c89bbc92bd86f8075d1decc58c7f4e0107f286b”,“0x50b728d8d964fd00c2d0aad81718b71311fef68a”,“0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39”,“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“0xd6df932a45c0f255f85145f286ea0b292b21c90b”,“0xd93f7e271cb87c23aaa73edc008a79646d1f9912”]	128	59988871	2024-07-30T12:54:52.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xdc320a15486164731f16d4da07f883da84e858864df398763ff4af7094aff79e
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x0c028f753f72473458af306c50aa208ff70ebe2d000200000000000000000179	[“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“0x4702bb9cbc7ab275e4736b5812b25d5d30ecf983”]	106	22607766	2021-12-16T22:28:46.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x0a4fef1cbbd302f0355c8246b530b4c9236e35c8eb9342c525784f8dc3ada1a2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x2d3c28d942f873be606483dd0ce7ecd3fa3cbcd5000100000000000000000176	[“0x1d607faa0a51518a7728580c238d912747e71f7a”,“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“0x85955046df4668e1dd369d2de9f3aeb98dd2a369”,“0xfe712251173a2cd5f5be2b46bb528328ea3565e1”]	105	22585829	2021-12-16T08:50:17.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x4a1595cd91841ac575b6679269449c13658a796124036bd57bb0ebaecb9d7968

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0xaac98ee71d4f8a156b6abaa6844cdb7789d086ce	false	192	20213910	2021-10-14T15:23:30.000Z	0xf80bfb8c876b9e90fb56b1e9ba0a681548626087dee2fa2b88374ca2ad90e415
0xa5bf2ddf098bb0ef6d120c98217dd6b141c74ee0	0x0b09dea16768f0799065c475be02919503cb2a35	false	230	20213860	2021-10-14T15:21:46.000Z	0xd9a2511e78a8931240b7c5691985fdc854a463ff70a8cff5c22987f54aed2e2e
0xa5bf2ddf098bb0ef6d120c98217dd6b141c74ee0	0x9f1f16b025f703ee985b58ced48daf93dad2f7ef	false	277	23527727	2022-01-09T18:36:18.000Z	0x1867b474802c2582b35bcabede6aedcbe00fba86d90e595a57599e571118b914

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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	0x49d8d916ca318198b18a06b1addf89b5cb083ca8	false	185	24593483	2022-02-05T21:45:13.000Z	0x2951a16d77ec3de7a4a5fc0850d1a3179604ffaf89e640ff5f180f6185c52c36
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0x1c9c8073a25297a4f860c32f2df27f33388dfb43	false	256	24562625	2022-02-05T02:12:46.000Z	0x737b332a5e54cd9b94c7aba23710646cb7dae930dc7d36a62cbf917099d68b2c
0x8e9aa87e45e92bad84d5f8dd1bff34fb92637de9	0x9edb3c15e2863a4f0352c395c5bf8250ff2233fa	false	293	24580853	2022-02-05T13:16:37.000Z	0x525c53ec65d8df49186ed341c9205912232feac8aa3cb8c3665ac3733235fb5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x0e39c3d9b2ec765efd9c5c70bb290b1fcd8536e3	false	365	37743618	2023-01-06T13:27:39.000Z	0xcd12cc84431baa89f7eeb04f69157cafb39510528d342141a57df901701ab2ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x0e39c3d9b2ec765efd9c5c70bb290b1fcd8536e3	0x4973f591784d9c94052a6c3ebd553fcd37bb0e55	false	315	35029760	2022-10-31T14:21:47.000Z	0xdaedbda2d011bd1a5da1b5f0213aaac7072f480e9f25f2b31b796184a23d820c
0x0e39c3d9b2ec765efd9c5c70bb290b1fcd8536e3	0x8ac5fafe2e52e52f5352aec64b64ff8b305e1d4a	false	144	33603515	2022-09-26T20:29:49.000Z	0x3c35519973ddfff818ac78a9e8183f3681c795416378a1d84d8fb089f078ea8b
0x0e39c3d9b2ec765efd9c5c70bb290b1fcd8536e3	0x9d75cc71555ddabcb89b52c818c2c689e2191401	false	112	32892066	2022-09-09T15:13:19.000Z	0x2817e58c8da4d70ca2f752354917e0f95a026888f8e39d676c03dd8df5bc965f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x82e4cfaef85b1b6299935340c964c942280327f4	false	307	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x82e4cfaef85b1b6299935340c964c942280327f4	0x8d8723ae74cec3f01633dcfe27751edb6ec68712	false	159	40167651	2023-03-10T02:32:54.000Z	0xd4900334238c56c51b41cdfba27ad6f4eb56f94300e8f43d5db9ef235178aee0
0x82e4cfaef85b1b6299935340c964c942280327f4	0x345c59e93de1e87509327795ab9ed4d158884a96	false	379	40164822	2023-03-10T00:46:16.000Z	0x3fb1dfb9a784d9b2a26b4b9c8d70624b036f8f3db96f623fed49ae9cc9b0bc95
0x82e4cfaef85b1b6299935340c964c942280327f4	0x577f6076e558818a5df21ce4acde9a9623ec0b4c	false	308	39184899	2023-02-11T20:24:54.000Z	0x8cbe26d717c5d984910268c5f8046f603cf28778f9af39b2f53d506026c02250

Example Query

Query with partition filter

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

WeightedPoolFactoryV4_FactoryDisabled_event

Event emitted when a Balancer V2 weighted pool factory (version 4) is administratively disabled, preventing new pool creation. Used for tracking factory lifecycle and protocol governance actions.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xfc8a407bba312ac761d8bfe04ce1201904842b76	false	102	79274442	2025-11-20T15:51:55.000Z	0xb24ab61c335111f4d6c6c9431bc9b7c8ef388543b7f73281dc1edc569e640a62

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0xfc8a407bba312ac761d8bfe04ce1201904842b76	0x05f72ccbab9b3536583603e5c13dc54671869379	false	391	52668409	2024-01-23T19:25:02.000Z	0xedbc5f492b6b3ae6b00046385ce5d75ccd5c05fe319ed786a56e0008d4f9545e
0xfc8a407bba312ac761d8bfe04ce1201904842b76	0x62309056c759c36879cde93693e7903bf415e4bc	false	386	51626717	2023-12-27T17:28:17.000Z	0x80a9d8da7b8668d571d692bdd6ef8800d6c7617a56ee7a65e1872cd8af0d999c
0xfc8a407bba312ac761d8bfe04ce1201904842b76	0xa4a03a57c89f39c66f2237c0643ba6eec36da5ec	false	337	51598109	2023-12-27T00:25:00.000Z	0x2d7208ba6eef1714cfcc1e7fa9eea6e5c57d9a73d417f7c62705876a24c6b493

Example Query

Query with partition filter

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

YearnLinearPoolFactory_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	false	311	43061191	2023-05-23T18:35:52.000Z	0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	0x0320c1c5b6df19a194d48882aaec1c72940081d9	false	320	39341199	2023-02-16T01:50:22.000Z	0x6dd9d5d3a6ca6291bafd4da510b2411adccd9a5f00ec2c6f416a26ec7aa1703a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	0x0320c1c5b6df19a194d48882aaec1c72940081d9	false	325	39341199	0	2023-02-16T01:50:22.000Z	0x6dd9d5d3a6ca6291bafd4da510b2411adccd9a5f00ec2c6f416a26ec7aa1703a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x0b576c1245f479506e7c8bbc4db4db07c1cd31f9	false	203	46633724	2023-08-22T22:35:41.000Z	0xe039eaed246d26abe5fe601955b9ca9ce449ed47de9bccadca7b57c208d861ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x0b576c1245f479506e7c8bbc4db4db07c1cd31f9	0xdae301690004946424e41051ace1791083be42a1	false	249	41503277	2023-04-14T01:03:32.000Z	0xd1ff4b1a64a4a26a5de3eb33dd50d4c701e937ebd71510321f8cc57f13064de1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_polygon.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
0x0b576c1245f479506e7c8bbc4db4db07c1cd31f9	0xdae301690004946424e41051ace1791083be42a1	false	254	41503277	0	2023-04-14T01:03:32.000Z	0xd1ff4b1a64a4a26a5de3eb33dd50d4c701e937ebd71510321f8cc57f13064de1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​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

​ChildChainGauge_Approval_event

​ChildChainGauge_Deposit_event

​ChildChainGauge_Transfer_event

​ChildChainGauge_UpdateLiquidityLimit_event

​ChildChainGauge_Withdraw_event

​ChildChainGaugeFactory_GaugeCreated_event

​ComposableStablePoolFactory_FactoryDisabled_event

​ComposableStablePoolFactory_PoolCreated_event

​ComposableStablePoolFactoryV2_FactoryDisabled_event

​ComposableStablePoolFactoryV2_PoolCreated_event

​ComposableStablePoolFactoryV3_FactoryDisabled_event

​ComposableStablePoolFactoryV3_PoolCreated_event

​ComposableStablePoolFactoryV4_FactoryDisabled_event

​ComposableStablePoolFactoryV4_PoolCreated_event

​ComposableStablePoolFactoryV5_FactoryDisabled_event

​ComposableStablePoolFactoryV5_PoolCreated_event

​ERC4626LinearPoolFactory_PoolCreated_event

​ERC4626LinearPoolFactoryV2_PoolCreated_event

​ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV3_FactoryDisabled_event

​ERC4626LinearPoolFactoryV3_PoolCreated_event

​ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV4_FactoryDisabled_event

​ERC4626LinearPoolFactoryV4_PoolCreated_event

​InvestmentPoolFactory_PoolCreated_event

​LiquidityBootstrappingPoolFactory_PoolCreated_event

​ManagedPoolFactory_FactoryDisabled_event

​ManagedPoolFactory_PoolCreated_event

​ManagedPoolFactoryV2_FactoryDisabled_event

​ManagedPoolFactoryV2_PoolCreated_event

​MerkleOrchard_DistributionClaimed_event

​MetaStablePoolFactory_PoolCreated_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

​Pool_RecoveryModeStateChanged_event

​Pool_SwapFeePercentageChanged_event

​Pool_Transfer_event

​PoolFactory_PoolCreated_event

​ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

​ProtocolFeesCollector_SwapFeePercentageChanged_event

​StablePhantomPoolFactory_PoolCreated_event

​StablePoolFactory_PoolCreated_event

​StablePoolFactoryV2_FactoryDisabled_event

​StablePoolFactoryV2_PoolCreated_event

​UnbuttonAaveLinearPoolFactory_PoolCreated_event

​Vault_AuthorizerChanged_event

​Vault_batchSwap_function

​Vault_ExternalBalanceTransfer_event

​Vault_FlashLoan_event

​Vault_flashLoan_function

​Vault_InternalBalanceChanged_event

​Vault_PausedStateChanged_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_RelayerApprovalChanged_event

​Vault_Swap_event

​Vault_swap_function

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPool2TokensFactory_PoolCreated_event

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

ChildChainGauge_Approval_event

ChildChainGauge_Deposit_event

ChildChainGauge_Transfer_event

ChildChainGauge_UpdateLiquidityLimit_event

ChildChainGauge_Withdraw_event

ChildChainGaugeFactory_GaugeCreated_event

ComposableStablePoolFactory_FactoryDisabled_event

ComposableStablePoolFactory_PoolCreated_event

ComposableStablePoolFactoryV2_FactoryDisabled_event

ComposableStablePoolFactoryV2_PoolCreated_event

ComposableStablePoolFactoryV3_FactoryDisabled_event

ComposableStablePoolFactoryV3_PoolCreated_event

ComposableStablePoolFactoryV4_FactoryDisabled_event

ComposableStablePoolFactoryV4_PoolCreated_event

ComposableStablePoolFactoryV5_FactoryDisabled_event

ComposableStablePoolFactoryV5_PoolCreated_event

ERC4626LinearPoolFactory_PoolCreated_event

ERC4626LinearPoolFactoryV2_PoolCreated_event

ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV3_FactoryDisabled_event

ERC4626LinearPoolFactoryV3_PoolCreated_event

ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV4_FactoryDisabled_event

ERC4626LinearPoolFactoryV4_PoolCreated_event

InvestmentPoolFactory_PoolCreated_event

LiquidityBootstrappingPoolFactory_PoolCreated_event

ManagedPoolFactory_FactoryDisabled_event

ManagedPoolFactory_PoolCreated_event

ManagedPoolFactoryV2_FactoryDisabled_event

ManagedPoolFactoryV2_PoolCreated_event

MerkleOrchard_DistributionClaimed_event

MetaStablePoolFactory_PoolCreated_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

Pool_RecoveryModeStateChanged_event

Pool_SwapFeePercentageChanged_event

Pool_Transfer_event

PoolFactory_PoolCreated_event

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

ProtocolFeesCollector_SwapFeePercentageChanged_event

StablePhantomPoolFactory_PoolCreated_event

StablePoolFactory_PoolCreated_event

StablePoolFactoryV2_FactoryDisabled_event

StablePoolFactoryV2_PoolCreated_event

UnbuttonAaveLinearPoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_batchSwap_function

Vault_ExternalBalanceTransfer_event

Vault_FlashLoan_event

Vault_flashLoan_function

Vault_InternalBalanceChanged_event

Vault_PausedStateChanged_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_RelayerApprovalChanged_event

Vault_Swap_event

Vault_swap_function

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPool2TokensFactory_PoolCreated_event

WeightedPoolFactory_PoolCreated_event

WeightedPoolFactoryV2_FactoryDisabled_event

WeightedPoolFactoryV2_PoolCreated_event

WeightedPoolFactoryV3_FactoryDisabled_event

WeightedPoolFactoryV3_PoolCreated_event