balancer_v2_arbitrum - Token Terminal Docs

Tables

AaveLinearPoolFactory_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_arbitrum.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
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	false	15	47959475	2022-12-22T06:06:35.000Z	0xf79a5eeb54636e353dc151179386d38da1c5e4d41a273e889d4d879162a25f89

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	0x9bf7c3b63c77b4b4f2717776f15a4bec1b532a28	false	4	20987967	2022-08-22T18:41:03.000Z	0x51147e2fa6feb428beb6bde33666a822c44a513fe5793f36652aad4287c4b3ba
0xe2e901ab09f37884ba31622df3ca7fc19aa443be	0x23ca0306b21ea71552b148cf3c4db4fc85ae1929	false	4	20988011	2022-08-22T18:42:03.000Z	0xa8dcf201fa078f8671cdc67244b89726dd31804b2536c77d735988e01b7bc498

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xa2d801064652a269d92ee2a59f3261155ec66830	0xa612b6aed2e7ca1a3a4f23fbca9128461bbb7718	false	9	44470332	0	2022-12-07T23:59:20.000Z	0xa8699f09498f3ba37f02ed16e1c3aabf017df4469353a51818d021216098858c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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_arbitrum.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
0xa2d801064652a269d92ee2a59f3261155ec66830	false	25	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xa2d801064652a269d92ee2a59f3261155ec66830	0xa612b6aed2e7ca1a3a4f23fbca9128461bbb7718	false	4	44470332	2022-12-07T23:59:20.000Z	0xa8699f09498f3ba37f02ed16e1c3aabf017df4469353a51818d021216098858c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	15	59763340	0	2023-02-10T17:35:39.000Z	0x115fca74954fef4e1095dda7f5f135ddcec18595d464c03b22d7defeccaf7841

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	28	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	10	59763340	2023-02-10T17:35:39.000Z	0x115fca74954fef4e1095dda7f5f135ddcec18595d464c03b22d7defeccaf7841

Example Query

Query with partition filter

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

AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event

Event emitted when a new Aave linear pool is created via Balancer V2’s AaveLinearPoolFactoryV5 contract. Contains the deployed pool address and associated Aave protocol identifier for tracking linear pool deployments across Balancer-Aave integrations.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	0x19b1c92631405a0a9495ccba0becf4f2e8e908bd	false	9	80183370	0	2023-04-14T00:01:16.000Z	0x7e28c009ba0e292513d8d9e555ef7e6a9f24278cc7caa238e0aee53969a431a4

Example Query

Query with partition filter

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

AaveLinearPoolFactoryV5_FactoryDisabled_event

Event log emitted when Balancer V2 Aave Linear Pool Factory V5 contract is disabled, preventing new pool creation. Contains transaction metadata and contract address for tracking factory lifecycle state changes.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	false	4	123991754	2023-08-22T22:36:10.000Z	0xacafd397b9c19093796b677b9818b89536ca307f65343ad21df59c09c025649f

Example Query

Query with partition filter

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

AaveLinearPoolFactoryV5_PoolCreated_event

Pool creation events emitted by Balancer V2 Aave Linear Pool Factory V5 contracts. Records the deployment of new Aave-integrated linear pools with their contract addresses and creation timestamps for tracking liquidity pool instantiation across supported chains.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b	0x19b1c92631405a0a9495ccba0becf4f2e8e908bd	false	4	80183370	2023-04-14T00:01:16.000Z	0x7e28c009ba0e292513d8d9e555ef7e6a9f24278cc7caa238e0aee53969a431a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xb438c6cc53315ffa3fcd1bc8b27d6c3155b0b56a	false	0x897c6e306a6f819ba1d8610b96551eb288fadc1b	115792089237316195423570985008687907853269984665640564039457584007913129639935	7	0x000098d9ab3552a0871adfd0289d575e6a360000	167810899	2024-01-06T22:05:33.000Z	0x1466fb253cc05987412c5f271211473b33b503eb1a88a36afdf15bf80a81175f
0xcf9f895296f5e1d66a7d4dcf1d92e1b435e9f999	false	0xf84bfa23c2ab766c47056011b26e2d12ade5c754	0	0	0x7c5235255a3368961ca278b4d9437fab41519285	162295103	2023-12-21T15:48:37.000Z	0xe20435c59a2ca3236fc51b5bdbb3b6699b675b5d97cfae39f4404df943ea694f
0xcf9f895296f5e1d66a7d4dcf1d92e1b435e9f999	false	0xf84bfa23c2ab766c47056011b26e2d12ade5c754	115792089237316195423570985008687907853269984665640564039457584007913129639935	0	0x7c5235255a3368961ca278b4d9437fab41519285	162294293	2023-12-21T15:45:10.000Z	0x08d86d2610ebb2f132b55efdaaea98f59f6ae1e9dbc5ca8f1f79657bfc7f733a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x050fbe33699e56b577c3d6f090ece9870a0966bd	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	56793808988023377928	33	287225006	2024-12-21T22:41:22.000Z	0x98585bbca28ca476450b1e2f476ff09d5fa7edb3c4d10bd8b7739d331b71a409
0x052597b6633814a0a6ea9020ee46e25aa6936e49	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	481288574591879703	117	287142172	2024-12-21T16:54:45.000Z	0xad162ba6a29e57d6cd305027e6bbe98c39e38d600f02872173e2b27543fec5da
0x052597b6633814a0a6ea9020ee46e25aa6936e49	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	1937208216980847438349	140	287142172	2024-12-21T16:54:45.000Z	0xad162ba6a29e57d6cd305027e6bbe98c39e38d600f02872173e2b27543fec5da

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x0000000000000000000000000000000000000000	0x04d32f27ee3ff5efbcb855a1c2ee04a6191f23bf	false	0x70cf20fbf48dfff1724081337873d1ff32de79d1	14000000000000000	21	199575208	2024-04-10T13:26:21.000Z	0xf273a430de258c354a88951c8edc124e254014392aa4261a8b2c7c2d9c74566b
0x0000000000000000000000000000000000000000	0x04d32f27ee3ff5efbcb855a1c2ee04a6191f23bf	false	0x70cf20fbf48dfff1724081337873d1ff32de79d1	60000000000000000	12	199574262	2024-04-10T13:22:21.000Z	0x2cb1dd458eb2d159a7c3981859c81253f586b92f7aadc4acb755de3bdf8b1be4
0x0000000000000000000000000000000000000000	0x04d32f27ee3ff5efbcb855a1c2ee04a6191f23bf	false	0x70cf20fbf48dfff1724081337873d1ff32de79d1	510000000000000	19	199575597	2024-04-10T13:28:01.000Z	0x76d2a3babf7fb60f4ba22d0de5ab9990883045ad31fc8c50773e9969eaa75a04

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x011417bbed6fc9ceff36c032d431b0efcba7f8b3	false	0x011417bbed6fc9ceff36c032d431b0efcba7f8b3	4	185504203	2024-02-29T00:25:28.000Z	0x90896cd7fc2b2680da600ba680747e04a7a232dbc6da86fa1de66afbe7652b69	48982880361739432756	66337985951068381299	0	0
0x011417bbed6fc9ceff36c032d431b0efcba7f8b3	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	173	185691164	2024-02-29T13:37:45.000Z	0xb1659b31d6b6814f82e438e9181d8a25185ff3a86caf37406134e8f7b2a8c030	49016448091582773103	66345098496105323054	48891329139689574475	66032301116372326479
0x050fbe33699e56b577c3d6f090ece9870a0966bd	false	0xd133d54755ab3ae907f3916313a31e5ee734e64e	28	185788579	2024-02-29T20:30:06.000Z	0xd00a1d7f348d4bdee91b50913b606fdf66f2046e180e82246985dfb5405ff537	3286583271796032824880868	4343926475166761004301598	0	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x011417bbed6fc9ceff36c032d431b0efcba7f8b3	false	0x66b0ac5331551083ce49d224e9045b2f6de8bd4e	749958019004486	21	190546968	2024-03-15T06:55:37.000Z	0x59627bc93f09271d828fa715a555402d32891666399e48b38e8f960cd217c8fa
0x2162abd00312a0496b4b72b20a6790cc07268a25	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	14666410158195649221	23	190592055	2024-03-15T10:04:07.000Z	0x983a5e2842a9f1c481928240d9383132eb242b40904ef07a4e53636b90babf04
0x260cbb867359a1084ec97de4157d06ca74e89415	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	259315014971480790	8	190725288	2024-03-15T19:23:49.000Z	0x58b8077361035bf1e3b4962c1a214cdeeb2bb896f46ba989d8648ece15443dce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x6817149cb753bf529565b4d023d7507ed2ff4bc0	false	0x04d32f27ee3ff5efbcb855a1c2ee04a6191f23bf	0	194172251	2024-03-25T20:30:56.000Z	0x06a1f6210d5c2876adddb51a0e3efcb83bdfd902941140b8b904cbd916f56484
0x6817149cb753bf529565b4d023d7507ed2ff4bc0	false	0x0bcdc8186c0201a29a7dad1d3e4fe7a9bf92a0a8	23	284021362	2024-12-12T15:02:25.000Z	0x06e0cde87bd8381d7375bc739bcf68eb55d066ee3f0bc9687731501d9d8390da
0x6817149cb753bf529565b4d023d7507ed2ff4bc0	false	0x65cbc124ac6b605bbd23538bd8cb4b257cab3643	0	149258973	2023-11-11T05:30:05.000Z	0x84025e2e9ca726cef0180d56ad35e48604669778911319b859030d81f4e4bbb4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xaeb406b0e430bf5ea2dc0b9fe62e4e53f74b3a33	false	14	47959475	2022-12-22T06:06:35.000Z	0xf79a5eeb54636e353dc151179386d38da1c5e4d41a273e889d4d879162a25f89

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xaeb406b0e430bf5ea2dc0b9fe62e4e53f74b3a33	0xfb5e6d0c1dfed2ba000fbc040ab8df3615ac329c	false	9	25048692	2022-09-17T20:24:51.000Z	0xe57a0c604634c00d56d99f0dead02b6d38c5f6f5ffb7c7a9cd1cc58292f0cb8f
0xaeb406b0e430bf5ea2dc0b9fe62e4e53f74b3a33	0xcc98357eaf3e227bdef6b97780aae84bea9b02b0	false	7	23342442	2022-09-07T09:40:25.000Z	0x1c38f2b74a1a2f3714e78f636733b1c44435e1b19b0963b53e4edf950abf560c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	1	51224641	2023-01-06T13:25:44.000Z	0x5760e216f4499be78a418beba3f7016f29ef01e167b90e65d0db93d9524d2c15

Example Query

Query with partition filter

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

ComposableStablePoolFactoryV2_PoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x373b347bc87998b151a5e9b6bb6ca692b766648a	false	7	42470051	2022-11-30T15:11:50.000Z	0xdd699704f42562c13f30f7ff41243d012a78dcde4d21396b90a5209416ad8ec6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	false	27	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	0x519cce718fcd11ac09194cff4517f12d263be067	false	15	65756316	2023-03-01T14:04:44.000Z	0xf1b7d11e4404c1e4396f34ece092cdf7bc8124a7f774042e937b9981c4fda30a
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	0xcba9ff45cfb9ce238afde32b0148eb82cbe63562	false	17	77282932	2023-04-05T11:50:34.000Z	0xe026dde848bf79afff3be472a19d7890c32c1473b9ff310d5d9c9d30aad93228
0x1c99324edc771c82a0dccb780cc7dda0045e50e7	0x077794c30afeccdf5ad2abc0588e8cee7197b71a	false	13	59462409	2023-02-09T17:40:18.000Z	0x83137c86e4801e72e1e053dfbdb6cf34a0d35f4c370a797f7142d59f3aee883a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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_arbitrum.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
0x2498a2b0d6462d2260eac50ae1c3e03f4829ba95	0x542f16da0efb162d20bf4358efa095b70a100f9e	false	16	91445025	2023-05-17T00:42:33.000Z	0x235f00433b72aff32667cba661070c2cf9fca162205966be44dde595b06f839c
0x2498a2b0d6462d2260eac50ae1c3e03f4829ba95	0xd7621e87fea8771e91b7ba75882c21c71a6a24ac	false	7	100239941	2023-06-12T01:24:18.000Z	0x1cfc70808d07f5085ed923f6a7e48ca4fafedecdf9aab8809f59fc54c07d03f3
0x2498a2b0d6462d2260eac50ae1c3e03f4829ba95	0xff7e6b102516e071dcda763ee9d02c1515481db5	false	37	72235971	2023-03-21T20:32:38.000Z	0xab8abe5b095879698a4b3eb8b3fe454f9f9dad61121d8e18c394b056cba87df1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xa8920455934da4d853faac1f94fe7bef72943ef1	false	119	226582798	2024-06-28T11:13:19.000Z	0xde5d116706d172c342cac8dcd92c94abf1388369adcee2fa7716d64a6ea2e8c6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xa8920455934da4d853faac1f94fe7bef72943ef1	0x7a66b9ef65a88e9abc94a08c9b043e73685d850b	false	16	189428708	2024-03-11T22:24:29.000Z	0x5454702bde1db52ebc238a367c830d94648738d28eb9e5bf5dc0816c8ec6e6ad
0xa8920455934da4d853faac1f94fe7bef72943ef1	0xb61371ab661b1acec81c699854d2f911070c059e	false	11	189426358	2024-03-11T22:13:36.000Z	0x7e7ff7872c67e8f6063099a37000be8f6c8fee2d4ef73784e7d703c1fc77a4fe
0xa8920455934da4d853faac1f94fe7bef72943ef1	0xa50f89e9f439fde2a6fe05883721a00475da3c45	false	13	115146298	2023-07-26T14:08:39.000Z	0x840ba522cb2d5dec81537bd088ffd6cbebf4fbe8ad3ea714d57a0be3efbb02e7

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV2_PoolCreated_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	0x117a3d474976274b37b7b94af5dcade5c90c6e85	false	11	65411515	19	2023-02-28T12:23:52.000Z	0x79f3053f18d8f1daab877da985f910299d6ad3dfcf02572d1d9ecedd79b4367f
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0x284eb68520c8fa83361c1a3a5910aec7f873c18b	false	9	65411503	19	2023-02-28T12:23:49.000Z	0x01d9992a6bde7687978826af36e51cce6e443b3064c1a50b0c73ede715eec531
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0x894c82800526e0391e709c0983a5aea3718b7f6d	false	9	59262025	10	2023-02-09T01:22:59.000Z	0x3f52e61131dad14d870a5716bf5b1b1c2048f3eab0aff1cf24f8c60ef9ffdc2f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	29	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	0xaef2c171dbe64b0c18977e16e70bfd29d4ee0256	false	4	59358986	2023-02-09T09:15:11.000Z	0x5520300969d9c84eb9e530b095a109615816f417ecc3a87007a51cc5cacb9ee1
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0x5bae72b75caab1f260d21bc028c630140607d6e8	false	4	59262242	2023-02-09T01:24:19.000Z	0x6f05a27e3806a62bd0abd93f25f6ad9668155685d0d7ec24b9b1ce00c71623a5
0xa3b9515a9c557455bc53f7a535a85219b59e8b2e	0xe1fb90d0d3b47e551d494d7ebe8f209753526b01	false	4	59261737	2023-02-09T01:21:17.000Z	0x212ff3bf511814e64a29196cb6c5817a778cd0de92001bc15745ba8776e1fc97

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

ERC-4626 (Tokenized Vault Standard) linear pool creation events emitted by Balancer V2 factory contracts. Contains deployed pool address and protocol integration identifier for tracking vault-based linear pool deployments across liquidity management strategies.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0x36942963e3b6f37ecc45a4e72349558514233f00	false	9	115141153	3	2023-07-26T13:46:41.000Z	0x5d121ea35a0a40d1e225f51a833d22e5ff7c7b8a6d4de06abef8ee1dc8591215
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0xc46be4b8bb6b5a3d3120660efae9c5416318ed40	false	9	110508593	3	2023-07-12T16:42:46.000Z	0xe24c744d6736ffbde1923534f13c1d7962d96d502a9c200299391f2f67eb0004
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0xad28940024117b442a9efb6d0f25c8b59e1c950b	false	9	110489801	3	2023-07-12T15:23:07.000Z	0xcd1e69b66013222960a7bf872a0a27c5d54ab1895f4387036d0586dda09b5339

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV4_FactoryDisabled_event

Event log emitted when an ERC4626 linear pool factory (version 4) is disabled in Balancer V2. Records the deactivation of pool creation functionality for ERC-4626 tokenized vault integration.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x7adbdabaa80f654568421887c12f09e0c7bd9629	false	2	123991754	2023-08-22T22:36:10.000Z	0xacafd397b9c19093796b677b9818b89536ca307f65343ad21df59c09c025649f

Example Query

Query with partition filter

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

ERC4626LinearPoolFactoryV4_PoolCreated_event

PoolCreated event logs emitted by Balancer V2’s ERC4626LinearPoolFactoryV4 contract when new ERC-4626 linear pools are deployed. Records the factory contract address and newly created pool address for tracking Balancer linear pool creation across chains.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0xad28940024117b442a9efb6d0f25c8b59e1c950b	false	4	110489801	2023-07-12T15:23:07.000Z	0xcd1e69b66013222960a7bf872a0a27c5d54ab1895f4387036d0586dda09b5339
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0xc46be4b8bb6b5a3d3120660efae9c5416318ed40	false	4	110508593	2023-07-12T16:42:46.000Z	0xe24c744d6736ffbde1923534f13c1d7962d96d502a9c200299391f2f67eb0004
0x7adbdabaa80f654568421887c12f09e0c7bd9629	0x6cb787a419c3e6ee2e9ff365856c29cd10659113	false	8	110513621	2023-07-12T17:04:35.000Z	0xeb06863bc443a405289bb76f67dc31f8ad9a10fc859e9a0a5d75f17e577bfa6d

Example Query

Query with partition filter

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

InvestmentPoolFactory_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_arbitrum.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
0x142b9666a0a3a30477b052962dda81547e7029ab	0xf49dded65145d3fbb0370bdd3361e4fac1f95c70	false	5	5171377	2022-01-28T13:53:20.000Z	0xb4d39a66c09c38316cf21063f916b2c53eec780ba0902c70374a2966b0699910
0x142b9666a0a3a30477b052962dda81547e7029ab	0xadb3c884134aa5af0764b5d297e5d16b45d89d23	false	5	5276842	2022-01-31T10:20:15.000Z	0xae740c385759e57b23e7e37ad097d94c51cf41ee1a511a9fc4cb5ba4650efcc2
0x142b9666a0a3a30477b052962dda81547e7029ab	0x803573b640ed7944761d4f9b50d428508adcf885	false	5	5285845	2022-01-31T16:17:22.000Z	0x81ad6c5ffd4cb010f3c37c9723d301b5ecd541f764c0b876661c164a59072121

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	false	24	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

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

ManagedPoolFactory_PoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	0x0ef07d253ed3523e3a056a1583eea82751c1a848	false	8	79294220	2023-04-11T09:18:01.000Z	0x9fc8d81070b81e6c4c98ac6f62871970ee70d64e7a8a4938ce5cccd4d793699f
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	0x16b345ed6781b68458eec3bb23d897daa81057a8	false	8	79380176	2023-04-11T15:14:39.000Z	0xd7cfaac34c6e60bcb7dcf595957c277b2e00e0caadc7eadc61616a381614a046
0x956ccab09898c0af2aca5e6c229c3ad4e93d9288	0xe949c53cf5c366771b93c9bc765fa45faa9d040d	false	11	79372553	2023-04-11T14:42:59.000Z	0x8eca6c33d1be7e9efe129e00ec9ddcb821c78bbf581321ec78b835568b6b7640

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x8ea89804145c007e7d226001a96955ad53836087	false	7	402289562	2025-11-20T15:52:35.000Z	0xf0a926d47c8afcbc31285fe56ef33cd12ae8cc39d186d11280d1cc35314b6732

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x8ea89804145c007e7d226001a96955ad53836087	0x0a6eb487db5a1aeb35d3d9fce9a32fbb943d186d	false	28	99128940	2023-06-08T18:10:47.000Z	0xc5ffe7f0fbfde4e7affb3e7e1a3f8fcc16e57869a083cb747b27de78368ec511
0x8ea89804145c007e7d226001a96955ad53836087	0xf43ab4cbe4999309d7c8077ad99f52c78cc495e6	false	32	99128425	2023-06-08T18:08:29.000Z	0xb949862ef02d1caec10e772ceed8fb6d34a9fa3bf8476bcbed4a354f3dfd6961
0x8ea89804145c007e7d226001a96955ad53836087	0x6d0781212a62e99f5ef04b78c9b9cf3531d4a7e6	false	64	99126194	2023-06-08T17:58:36.000Z	0x2804069be537275893355b6a9bdc56bbd41d71f375cebf9cf1801795a022197c

Example Query

Query with partition filter

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

MerkleOrchard_DistributionClaimed_event

Token distribution claim events from Balancer V2’s MerkleOrchard contract on Arbitrum. Records when users claim allocated tokens from merkle tree-based reward distributions, capturing claimer, recipient, token, and distribution identifiers for analyzing incentive program participation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 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`	Identifier for the specific token distribution campaign from which rewards are being claimed. Each distribution represents a discrete reward period or allocation event within the MerkleOrchard contract.
`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
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	63775601320000000000	0	0x0034daf2e65f6ef82bc6f893dbbfd7c232a0e59c	8189053	0x0034daf2e65f6ef82bc6f893dbbfd7c232a0e59c	0xd2eb7bd802a7ca68d9acd209bec4e664a9abdd7b	2022-03-20T07:04:34.000Z	0x08cec766caa3c469f38dedc0faa1e78ff50d0f3bd4edd10cd74147e5f233b8d5	27
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	20451310000000000	0	0x05aba422026a5c6249f364796bf9bc850a95ce42	8181537	0x05aba422026a5c6249f364796bf9bc850a95ce42	0xd2eb7bd802a7ca68d9acd209bec4e664a9abdd7b	2022-03-20T02:36:11.000Z	0x0294b74deadf1234dfc80e475802ca83df1412f7c7a092478aa38e111f7b924c	27
0x751a0bc0e3f75b38e01cf25bfce7ff36de1c87de	false	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	1953780490000000000	4	0x0b146a1ca55dd51fe98a33e5ef6b00552f648a7f	8213870	0x0b146a1ca55dd51fe98a33e5ef6b00552f648a7f	0xd2eb7bd802a7ca68d9acd209bec4e664a9abdd7b	2022-03-20T17:50:40.000Z	0xeb5a190dc83620a94e3053d3ae1dff8d3aebd668ff34890352a903c02eab51eb	27

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xebfd5681977e38af65a7487dc70b8221d089ccad	0x2b2da14c95b6dd31851bd2993cd11bddbe5510f6	false	9	52198765	2023-01-11T02:20:25.000Z	0x554c9f2ea8721ef4abe799f363092b39b173d5d3a2267b02b8a23d1ed0464563
0xebfd5681977e38af65a7487dc70b8221d089ccad	0x36bf227d6bac96e2ab1ebb5492ecec69c691943f	false	9	52358696	2023-01-11T17:43:59.000Z	0x3db22ef611ab75436e22b3e0960a961a422597755d5cfd22ade0848571395ef3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x1802953277fd955f9a254b80aa0582f193cf1d77	false	8	402289562	2025-11-20T15:52:35.000Z	0xf0a926d47c8afcbc31285fe56ef33cd12ae8cc39d186d11280d1cc35314b6732

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x1802953277fd955f9a254b80aa0582f193cf1d77	0x82917cc4097d38be313aa4a4d0989739e3447fc5	false	51	73818774	2023-03-26T08:55:44.000Z	0x0278f49c68efb32d94fe4bd469c038b98dcde383fada79e6c51948dfa6939e0f
0x1802953277fd955f9a254b80aa0582f193cf1d77	0x338a003321b99a9c7de40dde60d248262923cead	false	27	76542925	2023-04-03T07:52:55.000Z	0xcf97518d264cb1d9df94686a5e0a235342aed8716617cc6ad79e153578a53da1
0x1802953277fd955f9a254b80aa0582f193cf1d77	0x85f2c2e8a01055d45a469c3f53b2ebb7b6540eb5	false	11	76606552	2023-04-03T12:17:07.000Z	0x0fa5717dfff62093ff8c0ce72d1c16b7ee0b333e0d8606722d3a9e2b7baecb68

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xbd724eb087d4cc0f61a5fed1fffaf937937e14de	false	81	true	123894606	2023-08-22T15:00:48.000Z	0xaf0986e706b00f88bfe3f9cf774b8038fb0fbd76463a71e6fcac17962a430d34
0xa1ea76c42b2938cfa9abea12357881006c528513	false	72	true	123894606	2023-08-22T15:00:48.000Z	0xaf0986e706b00f88bfe3f9cf774b8038fb0fbd76463a71e6fcac17962a430d34
0xd6d20527c7b0669989ee082b9d3a1c63af742290	false	91	true	123894606	2023-08-22T15:00:48.000Z	0xaf0986e706b00f88bfe3f9cf774b8038fb0fbd76463a71e6fcac17962a430d34

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x0c8972437a38b389ec83d1e666b69b8a4fcf8bfd	false	0	124025002	2023-08-23T01:18:39.000Z	0x17038640992f3fb496eb789baaacbcbc9cf913958a9599d2c0dea5f1e7a82047	400000000000000
0x3a4c6d2404b5eb14915041e01f63200a82f4a343	false	3	124169185	2023-08-23T11:37:56.000Z	0x9431af9f3c5a4608fc9fc5c57f48588080bb12319e2130392871db84d0072c31	600000000000000
0x3a4c6d2404b5eb14915041e01f63200a82f4a343	false	12	124169185	2023-08-23T11:37:56.000Z	0x9431af9f3c5a4608fc9fc5c57f48588080bb12319e2130392871db84d0072c31	3000000000000000

Example Query

Query with partition filter

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

Pool_Transfer_event

Liquidity pool token transfer events emitted when LP (Liquidity Provider) tokens are minted, burned, or transferred between addresses. Contains sender, recipient, and token amount for tracking pool share ownership and liquidity position changes.

Columns

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

Sample Data

in_to	address	in_from	removed	in_value	block_number	block_timestamp	transaction_hash
0xfd67d1f84c38e5b607a413c70e820834a0d9a217	0x1533a3278f3f9141d5f820a184ea4b017fce2382	0x0000000000000000000000000000000000000000	false	3149418328657515485155	3481149	2021-12-01T07:03:41.000Z	0x0d8d0e242f542cec3aa8299104df6cace3da5703e100aded0ac96911871cf0b6
0x1d7f4ec86d8cf76458143da658f30b7e1420cde1	0x1533a3278f3f9141d5f820a184ea4b017fce2382	0x0000000000000000000000000000000000000000	false	50491667553637977260217	3478390	2021-12-01T04:26:34.000Z	0xb5d71c54e3ebab6602e7fb0ae31c0191932c1ebd6cf5781baefe5754dda469f5
0xd80937707b1ee9fdea70461ffe40382a992fdaa9	0x1533a3278f3f9141d5f820a184ea4b017fce2382	0x0000000000000000000000000000000000000000	false	53618062652767983205344	3484210	2021-12-01T09:16:33.000Z	0x1502ee305fd26e428ee7cb082f32990048f4a8c4e9ac0881117c41043d108cb0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x7dfdef5f355096603419239ce743bfaf1120312b	0x090baf9b679e9a2eeab799f304bc30d25752d3c9	false	3	43609109	2022-12-04T17:58:57.000Z	0xa52d70321b1bc264f6ede81a19afcd0b89d3fa83f7b840caa46850f725897201
0x7dfdef5f355096603419239ce743bfaf1120312b	0x9ed0b68c4d35b62a5d9d86d8ee7b5d4081d03673	false	3	43601920	2022-12-04T17:26:08.000Z	0x5452a06e2bc27ceb9fa618fd479d06894a53f5f43fedeb1c1a18d69dbeafdb3f
0x7dfdef5f355096603419239ce743bfaf1120312b	0x996b05f7c54c0c54ac4a16d8e566ab6f7f5039ca	false	3	43609626	2022-12-04T18:01:17.000Z	0x92dd0d1cbdcc9c32cc5c389bc2a996e94e4dd5b3161fac5dd065a865f68e17da

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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_arbitrum.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	1	6203674	2022-02-16T22:26:03.000Z	0x6f428f4ddd9741df8fed61f282ba54e7173aad8e5c317799457f46e4bee27e9b	500000000000000000
0xce88686553686da562ce7cea497ce749da109f9f	false	1	3825712	2021-12-13T17:20:01.000Z	0x939a9caa396093603479b6096f412f250e0fdc4c5d84619b8942ae6b14fea585	100000000000000000

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x2433477a10fc5d31b9513c638f19ee85caed53fd	0x5a5884fc31948d59df2aeccca143de900d49e1a3	false	5	9455379	2022-04-07T14:43:17.000Z	0x37db68dbab7f0cbacd68181ec186a4a2c468e3bcd25eed1228fe773aa8793ad5
0x2433477a10fc5d31b9513c638f19ee85caed53fd	0x1533a3278f3f9141d5f820a184ea4b017fce2382	false	5	1519621	2021-09-23T15:12:58.000Z	0x056d99e0dcce7112c845a569710cb33917fd94f063594fd9c9257bc2f725cd4e
0x2433477a10fc5d31b9513c638f19ee85caed53fd	0x0510ccf9eb3ab03c1508d3b9769e8ee2cfd6fdcf	false	5	7710865	2022-03-10T22:26:57.000Z	0xa031b5774c7c4769ff667ad6416f67455afb56a8c2092866ffe8e709d5c905a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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_arbitrum.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
0xef44d6786b2b4d544b7850fe67ce6381626bf2d6	0xed420d58d6efa85d63926966cd1ec9eba4e57b11	false	4	23415617	2022-09-07T17:34:16.000Z	0x767deb3b4b3350eb789e77e9b37187ada1bf813df1f11afc2818d9a118bae983
0xef44d6786b2b4d544b7850fe67ce6381626bf2d6	0x7bceaa9c5e7f4836fec3bce2d5346637c9b13970	false	4	23432109	2022-09-07T19:21:28.000Z	0x0ad3125d28557fda785d086c217fdf4079b53dd0f47a1d00bc2d39474469fba7
0xef44d6786b2b4d544b7850fe67ce6381626bf2d6	0xcaffc904684771c9841e0b60e7c52566d4baa4a8	false	4	19272385	2022-08-03T09:53:19.000Z	0xab1f2951bb190ff6f3653d5d3f591ccac23117247b710fc01862e05724156659

Example Query

Query with partition filter

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

Vault_AuthorizerChanged_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	in_newAuthorizer	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	7	89245179	2023-05-10T11:40:04.000Z	0x6b1da720be2d11d95177ccfc40a917c2688f396c	0x3d4a472b436428674341b139c168d39023b76f4d5ca6b8ee07e44ba5a6eeea82
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0	222832	2021-08-24T21:41:48.000Z	0xa331d84ec860bf466b4cdccfb4ac09a1b43f3ae6	0xe2c3826bd7b15ef8d338038769fe6140a44f1957a36b0f27ab321ab6c68d5a8e

Example Query

Query with partition filter

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

Vault_ExternalBalanceTransfer_event

External token transfer events emitted by Balancer V2 and BEX vault contracts, capturing sender address, recipient address, token address, and transfer amount. Used for tracking token movements between vault external balances and user accounts.

Columns

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

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x5b6776cd9c51768fc915cad7a7e8f5c4a6331131	500557189228984	0xd11e43f6b816816f442e9605ae83148a91f56c0a	1	279063611	0x9b892e515d2ab8869f17488d64b3b918731cc70d	2024-11-28T03:41:12.000Z	0x1a960c022a7d8bc99478ae0a0a341b27494feecce2b2b2caf2995f9c4d784788
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x5b6776cd9c51768fc915cad7a7e8f5c4a6331131	913248246159032	0x0feb58dc349330b9df5be5d72c07adf22aeda84e	1	279230675	0x9b892e515d2ab8869f17488d64b3b918731cc70d	2024-11-28T15:21:48.000Z	0x84560c34a5645d00d6ed502f5a1c3aa3b593b16722ee37f298632bbc3dac800f
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x5b6776cd9c51768fc915cad7a7e8f5c4a6331131	2628274193606143	0x9a9e9c1a31f9d618290201c271e20a2565431aae	1	279283628	0x9b892e515d2ab8869f17488d64b3b918731cc70d	2024-11-28T19:04:10.000Z	0x08e6b2a8b028eb11b1b2ce40679a62e58fbe4a28f6c9276ba2d59c336f46a0a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	836336	28	132484028	0x0000000000bf41eb500675cabaa1223e3c1ab90f	2023-09-19T09:26:14.000Z	0x6af8d1715459463dbe5ae776f663338bc9cf617f02b4ea57d1a2eb633043e732
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	3354356	12	132648095	0x0000000000bf41eb500675cabaa1223e3c1ab90f	2023-09-19T21:27:34.000Z	0xc41139d2da91bc1f4a90f637bd0128478d8b2b5d0c9fd62389ddf6a6c07c9a5f
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	535166422	10	132591505	0x0000000000bf41eb500675cabaa1223e3c1ab90f	2023-09-19T17:05:46.000Z	0x4cd797066f1782d342af6a7eb7c08cca6bebf32bb4897e0b750090dd10a278a5

Example Query

Query with partition filter

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

Vault_InternalBalanceChanged_event

Balancer Vault internal balance modification events recording user token deposit and withdrawal changes. Tracks user address, token address, and signed delta values for internal accounting within the Vault contract.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	in_user	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	0xe6d1ea689223b723ac2a0514c7b9da68c07c9dd1	false	0x1509706a6c66ca549ff0cb464de88231ddbe213b	30	292382152	2025-01-05T22:27:05.000Z	0xccc5d3e9b9ae903b586673b0add382cefb438e5faacd48b794558e820914cfa6
0xba12222222228d8ba445958a75a0704d566bf2c8	0xe6d1ea689223b723ac2a0514c7b9da68c07c9dd1	false	0x5979d7b546e38e414f7e9822514be443a4800529	14	292066665	2025-01-05T00:26:34.000Z	0x8fda69164241fc4364e562513b787ecd5f7ceb3846f7bc7a4dddc6ac4cd277fa
0xba12222222228d8ba445958a75a0704d566bf2c8	0xe6d1ea689223b723ac2a0514c7b9da68c07c9dd1	false	0x5979d7b546e38e414f7e9822514be443a4800529	13	292350911	2025-01-05T20:15:37.000Z	0xfa4c3ecf5a04b0de1840d00fc95ebd3c069bc93ae8c815101d2ef00f125d5213

Example Query

Query with partition filter

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

Vault_PoolBalanceChanged_event

Balancer V2 Vault event emitted when liquidity provider positions change in a pool, recording token balance deltas and protocol fees. Contains pool identifier, liquidity provider address, token addresses, and per-token balance changes for tracking deposits, withdrawals, and pool composition updates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_deltas`	`ARRAY<STRING>`	Array of token balance changes for each token in the pool. String-encoded signed integers representing the change in token amounts, with positive values indicating deposits and negative values indicating withdrawals.
`in_protocolFeeAmounts`	`ARRAY<STRING>`	Array of protocol fee amounts collected for each token in the pool. String-encoded unsigned integers corresponding positionally to tokens in the pool, representing fees taken by the protocol on the transaction.

Sample Data

address	removed	in_deltas	in_poolId	in_tokens	log_index	block_number	block_timestamp	transaction_hash	in_liquidityProvider	in_protocolFeeAmounts
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“508417306000000000000”,“0”]	0x2e8ea681fd59c9dc5f32b29de31f782724ef4dcb0001000000000000000004bc	[“0x5979d7b546e38e414f7e9822514be443a4800529”,“0x8b5e4c9a188b1a187f2d1e80b1c2fb17fa2922e1”,“0xaf88d065e77c8cc2239327c5edb3a432268e5831”]	3	148403812	2023-11-08T15:54:36.000Z	0x0824f812293282742af219a2ae3d2f7e838b80443f4fd0773eb443ac34730e0e	0x95c1d2014909c04202fa73820b894b45f054f25e	[“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“522916333203456588665”,“0”]	0x2e8ea681fd59c9dc5f32b29de31f782724ef4dcb0001000000000000000004bc	[“0x5979d7b546e38e414f7e9822514be443a4800529”,“0x8b5e4c9a188b1a187f2d1e80b1c2fb17fa2922e1”,“0xaf88d065e77c8cc2239327c5edb3a432268e5831”]	4	148402056	2023-11-08T15:47:12.000Z	0x29a4f2e33f17e79123f93e55dc08725198a92c45e0ccdb10f330e23906d8426f	0x95c1d2014909c04202fa73820b894b45f054f25e	[“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“0”,“124091476”]	0x2e8ea681fd59c9dc5f32b29de31f782724ef4dcb0001000000000000000004bc	[“0x5979d7b546e38e414f7e9822514be443a4800529”,“0x8b5e4c9a188b1a187f2d1e80b1c2fb17fa2922e1”,“0xaf88d065e77c8cc2239327c5edb3a432268e5831”]	6	148341465	2023-11-08T11:30:33.000Z	0x07afe703c46726fa975e3f41f58a6870d367ef1f0ea28aeb1d1c9fa1a965f7bf	0x35e2a11f743a43f00381a0aeb6764322ef1eb788	[“0”,“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	0x4739e50b59b552d490d3fdc60d200977a38510c0000000000000000000000409	2	106111024	0	2023-06-29T12:17:17.000Z	0x65c574a3e3ceae1cb8c9d46d92ae4b32f3f33d3c	-541320328819	0x50bc019af7bd3050b25f68451ab219c2a494e59dd703853c69ba1caee729faee
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x3c7680dfe7f732ca0279c39ff30fe2eafdae49db	0x4739e50b59b552d490d3fdc60d200977a38510c0000000000000000000000409	16	106111024	0	2023-06-29T12:17:17.000Z	0x65c574a3e3ceae1cb8c9d46d92ae4b32f3f33d3c	538033375521	0x50bc019af7bd3050b25f68451ab219c2a494e59dd703853c69ba1caee729faee
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x3c7680dfe7f732ca0279c39ff30fe2eafdae49db	0x4739e50b59b552d490d3fdc60d200977a38510c0000000000000000000000409	19	106111024	538033375521	2023-06-29T12:17:17.000Z	0x65c574a3e3ceae1cb8c9d46d92ae4b32f3f33d3c	-538033375521	0x50bc019af7bd3050b25f68451ab219c2a494e59dd703853c69ba1caee729faee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	0x284eb68520c8fa83361c1a3a5910aec7f873c18b000000000000000000000380	0	65411503	0x284eb68520c8fa83361c1a3a5910aec7f873c18b	2023-02-28T12:23:49.000Z	0x01d9992a6bde7687978826af36e51cce6e443b3064c1a50b0c73ede715eec531	0
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x117a3d474976274b37b7b94af5dcade5c90c6e85000000000000000000000381	2	65411515	0x117a3d474976274b37b7b94af5dcade5c90c6e85	2023-02-28T12:23:52.000Z	0x79f3053f18d8f1daab877da985f910299d6ad3dfcf02572d1d9ecedd79b4367f	0
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x47c56a900295df5224ec5e6751dc31eb900321d500020000000000000000037f	2	65409354	0x47c56a900295df5224ec5e6751dc31eb900321d5	2023-02-28T12:14:45.000Z	0x00f1bf40f0d4c639d4ad38c4a19627ad8fba242ed9227c9d1e170679d418f345	2

Example Query

Query with partition filter

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

Vault_RelayerApprovalChanged_event

Relayer approval state change events emitted by Balancer V2 Vault contracts when users authorize or revoke permission for relayer addresses to execute operations on their behalf. Used for tracking relayer delegation patterns and vault security permissions.

Columns

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

Sample Data

address	removed	in_sender	in_relayer	in_approved	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xfcc92f0d50f43a3798041afd7e2c918cfb8b28ad	0x598ce0f1ab64b27256759ef99d883ee51138b9bd	true	140979502	2023-10-16T03:41:45.000Z	0x614bdb488415830bb94f72948f906d1aedaad25de2d00320ada2f7096fe54581
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xc3f0cb0b70ef09c17fbdea0059c0e85fd324f94b	0x598ce0f1ab64b27256759ef99d883ee51138b9bd	true	141157330	2023-10-16T17:12:40.000Z	0x5f2561648ea28ab59f743a7a36cd4c092a4cb7dc08424fe0796693cd431bb9de
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xe6aba9bfc304b01282c7fc1f9ab362849a463f9c	0x598ce0f1ab64b27256759ef99d883ee51138b9bd	true	191177553	2024-03-17T03:16:24.000Z	0x06c07984697ffde9e6a21f1761bfb9c23302c690aa2bdf705c20cf8d0354b235

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb286b923a4ed32ef1eae425e2b2753f07a517708000200000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	60000000000000	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	225238	7825071908253494	2021-08-27T20:27:39.000Z	0x4ba1ab7e814ab09761ca20a42efbf7be09a5139de8ad1a8ae37a9a09b9e2f0c9
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb286b923a4ed32ef1eae425e2b2753f07a517708000200000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	60000000000000	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	225237	8478431940058101	2021-08-27T20:26:42.000Z	0xf17bb3a84ea05c4ece8070b513ae12bac40ccca7979dd7d08a764bbab2595ae8
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xb286b923a4ed32ef1eae425e2b2753f07a517708000200000000000000000000	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	94288978568736	0x040d1edc9569d4bab2d15287dc5a4f10f56a56b8	225232	10000000000000000	2021-08-27T20:24:13.000Z	0x2ba0f2d64fdde215acabe01c8fd67b2304e0ac21622440ccf219c630e1a3ea84

Example Query

Query with partition filter

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

Vault_TokensDeregistered_event

Balancer V2 Vault event recording the removal of tokens from a liquidity pool’s registered token list. Emitted when pool composition changes through token deregistration, containing the pool identifier and array of deregistered token addresses.

Columns

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

Sample Data

address	removed	in_poolId	in_tokens	log_index	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xe405f6384bcd8d44981879599983d92bd977658600010000000000000000052e	[“0x9d2f299715d94d8a7e6f5eaa8e654e8c74a988a7”]	10	221201172	2024-06-12T21:14:29.000Z	0xe8d1938930ce7c1903ed84b3ae3e820dc654d4ab5ce53d024361d0e3c63858b2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xc3f47f3627305213adaa021ccccb61d5987eaa97000100000000000000000532	[“0x366e293a5cf90a0458d9ff9f3f92234da598f62e”]	6	237327017	2024-07-29T15:50:46.000Z	0x1bcba2df19aaa96e635b35d0adefa234ab2a8515024c2e185806ba9771efe61f
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x00877b8fc17b6e65675653bd85c7696bdb767ff70001000000000000000004b9	[“0x9623063377ad1b27544c965ccd7342f7ea7e88c7”]	6	137449135	2023-10-04T14:13:07.000Z	0x890076913a0b883832b569d5f39fa13a28c5fde741554e22aab3eda21049b760

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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	0x75fecb660fe5d32c53ac5f0d69daf586d949d5d40002000000000000000002b2	[“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“0x87ce4a47ae1e1ae8c09e439fed64de508fce53d6”]	2	46912205	2022-12-17T15:32:31.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xe963ef23ff3218d7dba063d4abfce8dc631b0215477cf36e581fa9e07fef6da7
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x59109b9c38b28695bee64d4846ae28b2c1cb7c670002000000000000000002b3	[“0xd4d42f0b6def4ce0383636770ef773390d85c61a”,“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”]	3	46985649	2022-12-17T23:47:40.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x360bfffae87d34fb59793a01f9c80b4fc99b49b1744f17160833cfd7b7c8aca0
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x8a5d3eecec2c23fe3517398a86a7a8de742670650002000000000000000002b4	[“0xd4d42f0b6def4ce0383636770ef773390d85c61a”,“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”]	3	46985749	2022-12-17T23:48:37.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x01151e3e68bfdb1124ef1bfa4c5f3f56bdbd2eae2f13592dc632f710ca9835a8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xcf0a32bbef8f064969f21f7e02328fb577382018	0xb286b923a4ed32ef1eae425e2b2753f07a517708	false	4	224873	2021-08-26T21:51:43.000Z	0xfe89df6a37d0d19d1f61b14935bd4388db7ca223e9d8a562d913639bd191333e
0xcf0a32bbef8f064969f21f7e02328fb577382018	0x934d3c04f0603332d6e182bf33289bc4c905fc22	false	5	231052809	2024-07-11T10:26:55.000Z	0xa86f1ba2527dde7dc5e3be7900089665ac38d9fc475bac194c7d62ade1ad07f5
0xcf0a32bbef8f064969f21f7e02328fb577382018	0xcc65a812ce382ab909a11e434dbf75b34f1cc59d	false	4	226818	2021-08-30T20:03:01.000Z	0x6df20a3c6b4aa2f01ce932353048f61c55b62d7b7521919eed18913d094b0de5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x7dfdef5f355096603419239ce743bfaf1120312b	0x6ee86e032173716a41818e6d6d320a752176d697	false	3	1666255	2021-09-27T01:32:17.000Z	0x7d67d179bea2522268bb7cd85661438c6851b2e8a695446273e49586210557be
0x7dfdef5f355096603419239ce743bfaf1120312b	0x17a35e3d578797e34131d10e66c11170848c6da1	false	3	1666332	2021-09-27T01:34:53.000Z	0x36c0c46cc89f1b500315a5b40014ce806c32a46cd1a464f3b18619a53ec03ad2
0x7dfdef5f355096603419239ce743bfaf1120312b	0x36d7cd617e68ad6a73634130a2c68c55ca45e452	false	3	12673157	2022-05-22T02:34:24.000Z	0x380a9e66345e80ab49a19027ba2f197a62c6c16904fdae61e7ad4de0284ebc46

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	false	2	51224641	2023-01-06T13:25:44.000Z	0x5760e216f4499be78a418beba3f7016f29ef01e167b90e65d0db93d9524d2c15

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0x3dd0843a028c86e0b760b1a76929d1c5ef93a2dd	false	11	23790348	2022-09-09T15:14:20.000Z	0xba27310edeebba23bfd25b5310cfc0c2c96ad1ec587198c9b960c8486c2fd969
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0xf93579002dbe8046c43fefe86ec78b1112247bb8	false	6	40350371	2022-11-22T20:20:36.000Z	0x371c24e2f740a6f68a61281e93cfa6b640184bbc6c3a6a924e3a4b847bb71084
0x8df6efec5547e31b0eb7d1291b511ff8a2bf987c	0x2d011adf89f0576c9b722c28269fcb5d50c2d179	false	6	25047692	2022-09-17T20:06:49.000Z	0x19eb3747333ea0c3a5676c229e0789a8247827fff0ac43dffa404badb59430a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xf1665e19bc105be4edd3739f88315cc699cc5b65	false	26	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xf1665e19bc105be4edd3739f88315cc699cc5b65	0x6ab026b3f9d7c55b871901b1a5c19ea5e6c5fdb9	false	6	71327176	2023-03-19T05:27:56.000Z	0x55c4ccf82becbe17531663ca7526b2fd0961cd9cc8bca15b823d6889362dfee6
0xf1665e19bc105be4edd3739f88315cc699cc5b65	0x2de9cf1e8f823f0586b1e11664fc05144a02f059	false	18	71476063	2023-03-19T15:49:05.000Z	0x5131e0af182a113f6c9dafd0b37e623ebbc4dc9dbf276bce756634322ac28c0f
0xf1665e19bc105be4edd3739f88315cc699cc5b65	0x882f961def46deadacf31798b295834a5b6d0c86	false	7	85151932	2023-04-28T11:23:31.000Z	0x8594ee5454c0d123f62b4e494a03fe95b7b2d132607a52c7117b27f143d2faa3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xc7e5ed1054a24ef31d827e6f86caa58b3bc168d7	false	6	402289562	2025-11-20T15:52:35.000Z	0xf0a926d47c8afcbc31285fe56ef33cd12ae8cc39d186d11280d1cc35314b6732

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_arbitrum.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
0xc7e5ed1054a24ef31d827e6f86caa58b3bc168d7	0x55f80dff950dcbf8e8e843efbf54716044157ed9	false	91	220939610	2024-06-12T03:06:15.000Z	0xbd2378051a573b6aac9718ed8a44730a4a3f9611e6ac73150b8439f9fc554d73
0xc7e5ed1054a24ef31d827e6f86caa58b3bc168d7	0xb09dc8f98164974fa89e55a97fd99b62bdbe4de2	false	8	197487639	2024-04-04T11:49:20.000Z	0xe15bac4cba3d7e8ee4841d405bf27246adfc56ed1e6e5220aa84d668ccfc5f3a
0xc7e5ed1054a24ef31d827e6f86caa58b3bc168d7	0x75a8db0454572fb1a190a4f476d9707d25c6b0a1	false	8	255945383	2024-09-21T20:43:25.000Z	0xefa3b2d3af60f15edc5c58f9c4caf70caa37601b677954d0e1ed49b80d10cbc3

Example Query

Query with partition filter

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

YearnLinearPoolFactory_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xd8b6b96c88ad626eb6209c4876e3b14f45f8803a	false	30	93386981	2023-05-22T21:05:46.000Z	0xd1195f80fcfc6ba9c4425ff2cedb61063e67f4e630a92d8424e05b21dc598467

Example Query

Query with partition filter

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

YearnLinearPoolFactory_PoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xd8b6b96c88ad626eb6209c4876e3b14f45f8803a	0x81fc12c60ee5b753cf5fd0adc342dfb5f3817e32	false	4	61319749	2023-02-16T02:01:00.000Z	0xb84c93d5a4d9fb29f2ffaef19196df98bc1a9efe4d315b5403fd98a70d7a833e

Example Query

Query with partition filter

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

YearnLinearPoolFactory_YearnLinearPoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0xd8b6b96c88ad626eb6209c4876e3b14f45f8803a	0x81fc12c60ee5b753cf5fd0adc342dfb5f3817e32	false	9	61319749	0	2023-02-16T02:01:00.000Z	0xb84c93d5a4d9fb29f2ffaef19196df98bc1a9efe4d315b5403fd98a70d7a833e

Example Query

Query with partition filter

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

YearnLinearPoolFactoryV2_FactoryDisabled_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x19dfef0a828eec0c85fbb335aa65437417390b85	false	3	123991754	2023-08-22T22:36:10.000Z	0xacafd397b9c19093796b677b9818b89536ca307f65343ad21df59c09c025649f

Example Query

Query with partition filter

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

YearnLinearPoolFactoryV2_PoolCreated_event

Balancer V2 event logs emitted when a Yearn Linear Pool is created by the YearnLinearPoolFactoryV2 contract, recording the factory address and newly created pool address. Used to track the deployment of Yearn-integrated linear pools across Balancer V2 implementations.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x19dfef0a828eec0c85fbb335aa65437417390b85	0x1fa7f727934226aedab636d62a084931b97d366b	false	22	80185866	2023-04-14T00:12:06.000Z	0xbc90ce23fc39279e32b265d14ae79f1423375801427de947368d60b137921589

Example Query

Query with partition filter

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

YearnLinearPoolFactoryV2_YearnLinearPoolCreated_event

Event logs recording creation of Yearn-integrated linear pools in Balancer V2, emitted by the YearnLinearPoolFactoryV2 contract. Contains the newly created pool address and protocol identifier linking the pool to Yearn vault integrations for yield-bearing assets.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	in_protocolId	block_timestamp	transaction_hash
0x19dfef0a828eec0c85fbb335aa65437417390b85	0x1fa7f727934226aedab636d62a084931b97d366b	false	27	80185866	0	2023-04-14T00:12:06.000Z	0xbc90ce23fc39279e32b265d14ae79f1423375801427de947368d60b137921589

Example Query

Query with partition filter

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

backed_v1_sonic balancer_v3_arbitrum

⌘I

​Tables

​AaveLinearPoolFactory_PoolCreated_event

​AaveLinearPoolFactoryV2_FactoryDisabled_event

​AaveLinearPoolFactoryV2_PoolCreated_event

​AaveLinearPoolFactoryV3_AaveLinearPoolCreated_event

​AaveLinearPoolFactoryV3_AaveLinearPoolProtocolIdRegistered_event

​AaveLinearPoolFactoryV3_FactoryDisabled_event

​AaveLinearPoolFactoryV3_PoolCreated_event

​AaveLinearPoolFactoryV4_AaveLinearPoolCreated_event

​AaveLinearPoolFactoryV4_FactoryDisabled_event

​AaveLinearPoolFactoryV4_PoolCreated_event

​AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event

​AaveLinearPoolFactoryV5_FactoryDisabled_event

​AaveLinearPoolFactoryV5_PoolCreated_event

​ChildChainGauge_Approval_event

​ChildChainGauge_Deposit_event

​ChildChainGauge_Transfer_event

​ChildChainGauge_UpdateLiquidityLimit_event

​ChildChainGauge_Withdraw_event

​ChildChainGaugeFactory_GaugeCreated_event

​ComposableStablePoolFactory_FactoryDisabled_event

​ComposableStablePoolFactory_PoolCreated_event

​ComposableStablePoolFactoryV2_FactoryDisabled_event

​ComposableStablePoolFactoryV2_PoolCreated_event

​ComposableStablePoolFactoryV3_FactoryDisabled_event

​ComposableStablePoolFactoryV3_PoolCreated_event

​ComposableStablePoolFactoryV4_FactoryDisabled_event

​ComposableStablePoolFactoryV4_PoolCreated_event

​ComposableStablePoolFactoryV5_FactoryDisabled_event

​ComposableStablePoolFactoryV5_PoolCreated_event

​ERC4626LinearPoolFactoryV2_PoolCreated_event

​ERC4626LinearPoolFactoryV3_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV3_FactoryDisabled_event

​ERC4626LinearPoolFactoryV3_PoolCreated_event

​ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV4_FactoryDisabled_event

​ERC4626LinearPoolFactoryV4_PoolCreated_event

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

​Vault_FlashLoan_event

​Vault_InternalBalanceChanged_event

​Vault_PausedStateChanged_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_RelayerApprovalChanged_event

​Vault_Swap_event

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPool2TokensFactory_PoolCreated_event

​WeightedPoolFactory_PoolCreated_event

​WeightedPoolFactoryV2_FactoryDisabled_event

​WeightedPoolFactoryV2_PoolCreated_event

​WeightedPoolFactoryV3_FactoryDisabled_event

​WeightedPoolFactoryV3_PoolCreated_event

​WeightedPoolFactoryV4_FactoryDisabled_event

​WeightedPoolFactoryV4_PoolCreated_event

​YearnLinearPoolFactory_FactoryDisabled_event

​YearnLinearPoolFactory_PoolCreated_event

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

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_ExternalBalanceTransfer_event

Vault_FlashLoan_event

Vault_InternalBalanceChanged_event

Vault_PausedStateChanged_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_RelayerApprovalChanged_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPool2TokensFactory_PoolCreated_event

WeightedPoolFactory_PoolCreated_event

WeightedPoolFactoryV2_FactoryDisabled_event

WeightedPoolFactoryV2_PoolCreated_event

WeightedPoolFactoryV3_FactoryDisabled_event

WeightedPoolFactoryV3_PoolCreated_event

WeightedPoolFactoryV4_FactoryDisabled_event

WeightedPoolFactoryV4_PoolCreated_event

YearnLinearPoolFactory_FactoryDisabled_event

YearnLinearPoolFactory_PoolCreated_event