balancer_v2_gnosis - Token Terminal Docs

Tables

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
0x9dd5db2d38b50bef682ce532bcca5dfd203915e1	0x581ec1f5e7ced12b186deae32256adb53bdd5b08	false	9	25415477	0	2022-12-12T18:38:20.000Z	0xd0cb3ba0b190576923032623c48f751a3b48e21292bc545c50066c922ff1da18

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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_gnosis.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
0x9dd5db2d38b50bef682ce532bcca5dfd203915e1	false	21	27987556	2023-05-17T10:48:25.000Z	0x75555a955fdf1d1962c563c4a282305fbd62e875feb3992284d2974bf3875132

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x9dd5db2d38b50bef682ce532bcca5dfd203915e1	0x581ec1f5e7ced12b186deae32256adb53bdd5b08	false	4	25415477	2022-12-12T18:38:20.000Z	0xd0cb3ba0b190576923032623c48f751a3b48e21292bc545c50066c922ff1da18

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	0x225e0047671939a8d78e08ebd692788abe63f15c	false	11	26410985	0	2023-02-10T17:41:15.000Z	0x3df7be933012947dcb6e428c658cd48cefafbc81d2be7cceaa8fdcc012ca6522
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	0xbb9cd48d33033f5effbedec9dd700c7d7e1dcf50	false	9	26443415	18	2023-02-12T16:18:40.000Z	0xf40b8ee8e6ee66d5d8563b390c68eeba4f75bdadc7c672d938fa7ffcfcc70cb1
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	0xd16f72b02da5f51231fde542a8b9e2777a478c88	false	9	26443431	18	2023-02-12T16:20:00.000Z	0xe82fd6a6a34863111912c4a709bf21490a9371069d4ab61e79dcef91fca76db1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	false	24	27987556	2023-05-17T10:48:25.000Z	0x75555a955fdf1d1962c563c4a282305fbd62e875feb3992284d2974bf3875132

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	0x225e0047671939a8d78e08ebd692788abe63f15c	false	6	26410985	2023-02-10T17:41:15.000Z	0x3df7be933012947dcb6e428c658cd48cefafbc81d2be7cceaa8fdcc012ca6522
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	0xd16f72b02da5f51231fde542a8b9e2777a478c88	false	4	26443431	2023-02-12T16:20:00.000Z	0xe82fd6a6a34863111912c4a709bf21490a9371069d4ab61e79dcef91fca76db1
0x9da18982a33fd0c7051b19f0d7c76f2d5e7e017c	0xbb9cd48d33033f5effbedec9dd700c7d7e1dcf50	false	4	26443415	2023-02-12T16:18:40.000Z	0xf40b8ee8e6ee66d5d8563b390c68eeba4f75bdadc7c672d938fa7ffcfcc70cb1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x62aab12865d7281048c337d53a4dde9d770321e6	0x1ac55c31dac78ca943cb8ebfca5945ce09e036e2	false	42	27443308	0	2023-04-14T11:58:05.000Z	0x50158d2b89cfc6546f290ac3fa8dbc42695045aeeb0b8be4658395fa72026944

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x62aab12865d7281048c337d53a4dde9d770321e6	false	11	29595692	2023-08-22T22:37:45.000Z	0xe62856cef2caff0bb50c08cb3174dba8aa6295deb44b0c7fcca1b455793cc4ed

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x62aab12865d7281048c337d53a4dde9d770321e6	0x1ac55c31dac78ca943cb8ebfca5945ce09e036e2	false	37	27443308	2023-04-14T11:58:05.000Z	0x50158d2b89cfc6546f290ac3fa8dbc42695045aeeb0b8be4658395fa72026944

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	log_index	in__spender	block_number	block_timestamp	transaction_hash
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0x25e58696fbc8eb88301ee06a57f77d9f0715ec97	0	0x0000000000000000000000000000000000000001	30649755	2023-10-26T16:57:40.000Z	0x80a48382be14367e2481098d70978039efcff17c4581fcf43e12fb9b700d6c95
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0x8e5382c4cb693b8186b81239b229ad0deed48b65	3	0x0000000000000000000000000000000000000001	31126294	2023-11-25T15:15:30.000Z	0x355e14928c2c61fcb546221f5ef006d8d071fde0c429a85e6c29c140b375e432
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0xe79ece09c4240dcb3d632585df427d824223fd04	1881	0x0000000000000000000000000000000000000001	32109887	2024-01-24T20:33:55.000Z	0x89e939c5b84cafea5289011d80743c34d1441cf08dbf447fe36a9b8ad4bfa265

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x27519f69b2ac912aeb6fe066180fb25a17c71755	false	0x1c85d6ae1336d0e4e3f165bbfa9641bfa04cedb1	58998240942325	21	29321130	2023-08-06T05:17:50.000Z	0x8ab01e74b963e4c1059e3b0234a8d5cb87caa72da9e06b91725a127ce5dfd934
0xde3b7ec86b67b05d312ac8fd935b6f59836f2c41	false	0xdef0e5f2a793479d16249117434ac3e1ae9f5b2c	3999198167690754508657	70	29329508	2023-08-06T17:27:55.000Z	0xbb1d82b181dea706ffbd0aab2b71139e84f92b8eb740cd13fb8b8f5b182da042
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0x3af39efa87cfe3b8df20175fbc2bc9797204dd00	229168377838591	3	29317994	2023-08-06T00:45:30.000Z	0xa9f49cc0bde5f07838cddd87f7bf2989cd68e4702e64541a75fd9c13dbd0d176

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	0x4d13d387f372dbe5125b7d78e75094ac85b31edc	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	417001375796543624098	2505	32529807	2024-02-19T13:24:30.000Z	0x0dd632abee107595d85b08ac51c16e3ad7b61f1391370ab19960fb024bc8624a
0x0000000000000000000000000000000000000000	0x9ff4e3925b88b6885083a88c2283a21cd504d3d4	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	93980000000000000000	13	32536779	2024-02-19T23:43:55.000Z	0x12ddb7977361cdaf5128accb63cb254b56403956f73bcef6d958427eb0f504b4
0x0000000000000000000000000000000000000000	0xb079bd76dd9b5f9a8d3954e4250fc25be0549ac0	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	50562869479370235697309	383	32526708	2024-02-19T08:47:40.000Z	0x4ecbab1049c6d65b0c2688736c892b149616b032bb1c1c8eae891f689ea33aaf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0xf33797902a452d02f06d6eef1adf7fce89630678	77	28462888	2023-06-15T07:35:05.000Z	0x639b5e0427c25c5c81762936045abbc6a794b46e745ab3e6e00cb09aca2d00ae	3539938840193487418335	8848699152409740776319
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0xf752dd899f87a91370c1c8ac1488aef6be687505	3	28457783	2023-06-15T00:10:40.000Z	0x32e64b96aff0c7d1661477d9b925e363aaa8cd0ff8b92d11192c455513a5861c	3539938809817752472840	8848699076470403412577
0xf752dd899f87a91370c1c8ac1488aef6be687505	false	0x152fa38ffa947a7fe081a8a7d80d7cc402b5bf9e	18	28472446	2023-06-15T21:30:50.000Z	0x2dc778643849eb883314671f08b8cd0bd2c283b50f09e15fc02c4580e4dfd69f	3539959898945644927328	8848751799290134548812

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x210abdfd989f3ee5c08614a8f4e096cf8408f5df	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	20039590644441535861309	6	30994512	2023-11-17T11:17:30.000Z	0xe886243d15fe31119230bf5fb32cf916d9f004fe570f6608aba4bee668fee0d7
0x210abdfd989f3ee5c08614a8f4e096cf8408f5df	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	730663178530920469087	267	30990878	2023-11-17T05:52:50.000Z	0xa68c7faede1cda1becda243883b83cf0540aaf70db12fdf0c9b68ceea153b95b
0x210abdfd989f3ee5c08614a8f4e096cf8408f5df	false	0xc181edc719480bd089b94647c2dc504e2700a2b0	2652388690848084493191	4	30991582	2023-11-17T06:55:45.000Z	0xfa9a166b8e758a5586d650c21972c4c8e4e5a83f1c1192eed5665fc2d1a0cac8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x83e443ef4f9963c77bd860f94500075556668cb8	false	0xd264f4d4ad98fef4b198547059c07a8e8bbf2f0e	0	29509573	2023-08-17T18:01:55.000Z	0xcf9bc82507e6233f3432ed236ba62777853afca7c3985071fd95a44345481ae3
0x83e443ef4f9963c77bd860f94500075556668cb8	false	0xbdcc4015eb062ca9045e55793dcac95cda093a01	21	29602990	2023-08-23T09:05:30.000Z	0xe82dd066459167f8547bfd5ef475c2bf2e4c37bbd5347a7ad452b0ec3aeec7a2
0x83e443ef4f9963c77bd860f94500075556668cb8	false	0x5508d8872e91854d7c6056bc70e9eb5ed1443464	0	29603122	2023-08-23T09:17:35.000Z	0xb0847ef7c87420ff88a99f8d345a736c89ebd45f165882c41612c0a710a97591

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.ChildChainGaugeFactory_GaugeCreated_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
0x76578ecf9a141296ec657847fb45b0585bcda3a6	false	9	26629165	2023-02-23T20:04:35.000Z	0x04289b1a1deae052a0c26f1a1906f9a72941b63b128587797e789499b38391b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x76578ecf9a141296ec657847fb45b0585bcda3a6	0x707b7d4a1bae449d546dcab869256591bbb3d70b	false	8	25415388	2022-12-12T18:30:35.000Z	0x0df2697f1993e5cfaf1b6a76cd58c648cc2f67863f38dea0d0ee1b8f844ad647

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xc128468b7ce63ea702c1f104d55a2566b13d3abd	false	23	27987556	2023-05-17T10:48:25.000Z	0x75555a955fdf1d1962c563c4a282305fbd62e875feb3992284d2974bf3875132

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xc128468b7ce63ea702c1f104d55a2566b13d3abd	0xfedb19ec000d38d92af4b21436870f115db22725	false	14	26476373	2023-02-14T15:51:10.000Z	0x0e3e80a3f81c634790ab65ab760b532285d7c1a872a4f91113a8be015f12cddf
0xc128468b7ce63ea702c1f104d55a2566b13d3abd	0x07c896050dd6e273c199f06d7516f8a4a369d23a	false	7	26368162	2023-02-08T04:08:50.000Z	0xdb6f2d2d5fd149e1b3740be6d68355e9840ff9fdcf8d9b6ca44f6eaeff35a215
0xc128468b7ce63ea702c1f104d55a2566b13d3abd	0x9949f1884b61a8265e12056650c1ac4677a75403	false	35	26968103	2023-03-16T07:18:40.000Z	0xde654ce62cccee19a83c6c4441009ddbea88d98a1bdef7965c90b38ee17495f4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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_gnosis.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
0xd87f44df0159dc78029ab9ca7d7e57e7249f5acd	0xa611a551b95b205ccd9490657acf7899daee5db7	false	15	28097288	2023-05-24T01:22:15.000Z	0x92ce79bc0f3f03264c7f13135c7ba9cefe9622e98ff8fe0a2b121211afad0fca
0xd87f44df0159dc78029ab9ca7d7e57e7249f5acd	0xf3678a0b54c61ccd88ce321c2e07f87ac75f08b9	false	7	27057476	2023-03-21T22:12:10.000Z	0x5433098c3bab330a27136103aac9b3bed89de3cbb143b86b5c6b5221e5579289
0xd87f44df0159dc78029ab9ca7d7e57e7249f5acd	0xbad20c15a773bf03ab973302f61fabcea5101f0a	false	20	28204798	2023-05-30T16:11:45.000Z	0x815cdac87410cb366402ee6d1012cbae4a5aa57df5eeccd75896c43c2d877a66

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x4bdcc2fb18aeb9e2d281b0278d946445070eada7	false	1507	34693309	2024-06-28T11:10:20.000Z	0xb38cd92e53340a82ec94bf871bec580a74eb55a1b5c27f73715227c06e81c3c8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x4bdcc2fb18aeb9e2d281b0278d946445070eada7	0xc9f00c3a713008ddf69b768d90d4978549bfdf94	false	11	30428786	2023-10-12T23:48:40.000Z	0xd77bddf91ba793dc6e47de1de13a7579b180230ea49e9561123d910f26e760b4
0x4bdcc2fb18aeb9e2d281b0278d946445070eada7	0xe24f9e0e04cfd758c8decef155185b48b6f79ede	false	3007	30428039	2023-10-12T22:42:40.000Z	0x8928ec54c4bf4cc8e8f7f8d878ab8e1882094e41a8b65a387d7e1504676cdcac
0x4bdcc2fb18aeb9e2d281b0278d946445070eada7	0x72a040c63496c9306ab3409a11dff73176e203fd	false	12	30424981	2023-10-12T18:11:20.000Z	0x12f45f0686de47e3a45e8050b98a65fa814c236629faae234d6a0a4935d91769

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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_gnosis.ERC4626LinearPoolFactoryV2_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
0xdf9b5b00ef9bca66e9902bd813db14e4343be025	false	20	43243860	2025-11-20T15:59:10.000Z	0x1005b5abdb5b6a0303838f20dadbf35e04912101b3b78690ef25a741ebb74506

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xdf9b5b00ef9bca66e9902bd813db14e4343be025	0x4d7adc5e362a97b5ba1b02bc0447249ac81e76ad	false	131	28649942	2023-06-26T15:32:55.000Z	0xd6f5726b3d6e822f24b34e6f067e591a5d761c0d42a52a9df447476ddb3a8772
0xdf9b5b00ef9bca66e9902bd813db14e4343be025	0xc061361fda32ff5b65f7d98acc9a87349d3f0768	false	9	27434726	2023-04-13T23:35:35.000Z	0x196561364f4d83202697bbe3e64332ae431d2655afb46260db8f5bb831eedc0f

Example Query

Query with partition filter

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

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 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_gnosis.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
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x5b9ee8b8abf0d187742b42892f3aa88638cace8f	false	20	36903187	2024-11-07T14:47:10.000Z	0xe89cfb224efe52f021d14f51354cbdddaadf0016e72059793b7492362160e505
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x7079a25dec33be61bbd81b2fb69b468e80d3e72c	false	12	36886336	2024-11-06T14:32:30.000Z	0x35f28e554449718b3b1d00f789a1e1f31b136f0ed037e95b47407792bdef506d
0x85a80afee867adf27b50bdb7b76da70f1e853062	0x31bccf9e28b94e5dacebaa67fe8bc1603cecd904	false	14	36889547	2024-11-06T19:10:05.000Z	0x5f108b2abf610d2cda1e9398bd7c08d26edbfbe51b7a3033b1e8b587d3b48231

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xbad20c15a773bf03ab973302f61fabcea5101f0a	false	35	false	28861868	2023-07-09T11:35:10.000Z	0x25164221f6f1a5a9611562bdb7ce6be867f3906b81045e609b56ab10befc2a57
0x5c78d05b8ecf97507d1cf70646082c54faa4da95	false	36	false	28861868	2023-07-09T11:35:10.000Z	0x25164221f6f1a5a9611562bdb7ce6be867f3906b81045e609b56ab10befc2a57
0xa611a551b95b205ccd9490657acf7899daee5db7	false	13	true	28605055	2023-06-23T21:52:40.000Z	0x417bc35f6420795879b6c74b2c3beab3268b4f9e7f09cad4a70e5355aa3d12a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xdfe4f5b252b24784805343983c588c657741d408	false	2	28186274	2023-05-29T12:30:25.000Z	0x88052a856fc72cd5865936d8b7df7c745d24a0f83001067a1314abb400f5f2c4	3000000000000000
0xbad20c15a773bf03ab973302f61fabcea5101f0a	false	11	28204798	2023-05-30T16:11:45.000Z	0x815cdac87410cb366402ee6d1012cbae4a5aa57df5eeccd75896c43c2d877a66	100000000000000
0xe15cac1df3621e001f76210ab12a7f1a1691481f	false	30	29001202	2023-07-17T21:20:45.000Z	0x56ccbb695e506cdc2ca6e4cffb417fff9bbd7d51cfdc335bddc8e762f151d09c	50000000000000

Example Query

Query with partition filter

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

Pool_Transfer_event

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

Columns

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

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xce88686553686da562ce7cea497ce749da109f9f	0x00df7f58e1cf932ebe5f54de5970fb2bdf0ef06d	0x0000000000000000000000000000000000000000	false	23305257004109	540	30761272	2023-11-02T19:23:10.000Z	0x0350ebd2883c65190dff86464c5a4e9bb7159ffd1b7d35a6f49b9939c0dc14b4
0xeb269f003002217930a2bf5a5bb53a4e77882417	0x00df7f58e1cf932ebe5f54de5970fb2bdf0ef06d	0x0000000000000000000000000000000000000000	false	14841456595847816	542	30761272	2023-11-02T19:23:10.000Z	0x0350ebd2883c65190dff86464c5a4e9bb7159ffd1b7d35a6f49b9939c0dc14b4
0x64cee2356f959e78db36a4c23a28f0454447c3df	0x00df7f58e1cf932ebe5f54de5970fb2bdf0ef06d	0xc181edc719480bd089b94647c2dc504e2700a2b0	false	14841456595847816	549	30761272	2023-11-02T19:23:10.000Z	0x0350ebd2883c65190dff86464c5a4e9bb7159ffd1b7d35a6f49b9939c0dc14b4

Example Query

Query with partition filter

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

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

Event logs capturing flash loan fee percentage updates in the Balancer V2 Protocol Fees Collector contract. Records the new fee percentage value whenever protocol governance modifies the flash loan borrowing cost.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	27179191	2023-03-29T10:48:00.000Z	0xd2fc3e99fe36fdc45645c9a36b5039bb985646b2b7af0fb037827c126edbfd8f	500000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.ProtocolFeesCollector_SwapFeePercentageChanged_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_gnosis.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
0xf23b4db826dba14c0e857029dff076b1c0264843	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f	false	5	25912543	2023-01-11T15:18:35.000Z	0x4c97fa39a89030f703904a09ac8ef2ba0e38ecfdbce50eee832601629608222b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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_gnosis.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	17	27871556	2023-05-10T10:31:45.000Z	0x03f3fb107e74f2eac9358862e91ad3c692712054	0xbd1f85029d80fce444f09f0514d72141ccd08d216746a919bff817029afd04cd
0xba12222222228d8ba445958a75a0704d566bf2c8	false	10	24821598	2022-11-01T18:55:55.000Z	0xa331d84ec860bf466b4cdccfb4ac09a1b43f3ae6	0x21947751661e1b9197492f22779af1f5175b71dc7057869e5a8593141d40edf1

Example Query

Query with partition filter

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

Vault_batchSwap_function

Batch swap function calls on Balancer V2’s Vault contract on Gnosis Chain, executing multi-hop token swaps through one or more liquidity pools. Contains swap paths, token amounts, pool identifiers, and asset deltas for analyzing routing efficiency and arbitrage activity.

Columns

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

Sample Data

gas	status	gas_used	in_funds	in_swaps	in_assets	in_limits	signature	to_address	in_deadline	block_number	from_address	trace_address	block_timestamp	out_assetDeltas	transaction_hash
242511	true	129832	{“sender”:“0x02ae4716b9d5d48db1445814b0ede39f5c28264b”,“recipient”:“0x02ae4716b9d5d48db1445814b0ede39f5c28264b”,“toInternalBalance”:false,“fromInternalBalance”:false}	[{“amount”:“9333363208227727863”,“poolId”:“0x2086f52651837600180de173b09470f54ef7491000000000000000000000004f”,“userData”:“0x”,“assetInIndex”:“0”,“assetOutIndex”:“1”}]	[“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”]	[“9333363208227727863”,“-1”]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	1718803820	34544464	0x02ae4716b9d5d48db1445814b0ede39f5c28264b	0,2,0,0,0,1	2024-06-19T13:30:20.000Z	[“9333363208227727863”,“-9330305”]	0x41aab0b7b379c44d10e291e151f4d681e0b510bfd2a0001b79e6ca45e49dd5dc
242511	true	129832	{“sender”:“0x02ae4716b9d5d48db1445814b0ede39f5c28264b”,“recipient”:“0x02ae4716b9d5d48db1445814b0ede39f5c28264b”,“toInternalBalance”:false,“fromInternalBalance”:false}	[{“amount”:“9151211926288538645”,“poolId”:“0x2086f52651837600180de173b09470f54ef7491000000000000000000000004f”,“userData”:“0x”,“assetInIndex”:“0”,“assetOutIndex”:“1”}]	[“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”]	[“9151211926288538645”,“-1”]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	1718760645	34536077	0x02ae4716b9d5d48db1445814b0ede39f5c28264b	0,2,0,0,0,1	2024-06-19T01:30:45.000Z	[“9151211926288538645”,“-9148845”]	0x038f531b4f9aa6bc8136be41fa103a2eb61973c31af72a5bc18a3dd6a56f21e9
1083525	true	210464	{“sender”:“0x06882eeb8386874a1e5d543d064681c9c3d0668b”,“recipient”:“0x06882eeb8386874a1e5d543d064681c9c3d0668b”,“toInternalBalance”:false,“fromInternalBalance”:false}	[{“amount”:“8124904669228624”,“poolId”:“0x2086f52651837600180de173b09470f54ef7491000000000000000000000004f”,“userData”:“0x”,“assetInIndex”:“0”,“assetOutIndex”:“1”},{“amount”:“0”,“poolId”:“0x7644fa5d0ea14fcf3e813fdf93ca9544f8567655000000000000000000000066”,“userData”:“0x”,“assetInIndex”:“1”,“assetOutIndex”:“2”}]	[“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“0xaf204776c7245bf4147c2612bf6e5972ee483701”]	[“8124904669228624”,“0”,“-1”]	0x945bcec9	0xba12222222228d8ba445958a75a0704d566bf2c8	1718834000	34550347	0x06882eeb8386874a1e5d543d064681c9c3d0668b	1,0,13	2024-06-19T21:53:20.000Z	[“8124904669228624”,“0”,“-7465439526709014”]	0x2a00ef04e8e927c2a8c9e394bfc405483e0c7f2f48eb542da64525ee1177c757

Example Query

Query with partition filter

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

Vault_ExternalBalanceTransfer_event

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

Columns

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

Sample Data

address	removed	in_token	in_amount	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x20e5eb701e8d711d419d444814308f8c2243461f	1619426091804053	0x73b6a7a6e39a2e405087164d7f407a0bd2c86dcc	17	29736577	0x3536fd480ca495ac91e698a703248a8915c137a3	2023-08-31T09:29:20.000Z	0xcd189dfac180d148ef51684d0ee2cb6a7bae8c3f331466c97df8f7f42dcc97e7
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xc1593302979e5e8e16e53c3303bf99ffa319d314	1970608025736351	0x73b6a7a6e39a2e405087164d7f407a0bd2c86dcc	21	29736575	0x3536fd480ca495ac91e698a703248a8915c137a3	2023-08-31T09:29:10.000Z	0x1c1b2b13abfdb0bdcf56d95d758087a9eb4da4649903e2d9ef36feb0cb8ac979
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x20e5eb701e8d711d419d444814308f8c2243461f	843316271280390	0x1326cfa027c77d5df1bbc3c2c8e602aca3d157e5	7509	30185029	0x3536fd480ca495ac91e698a703248a8915c137a3	2023-09-27T20:10:10.000Z	0xdd5a882f8b77c28b1dc9799f0772dedb82a4a9a7b16cacb0f83927a926784901

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	100031198367151665	114	30865626	0x3d4df8596e5750a4f721c8764d585dcc8623d009	2023-11-09T08:53:20.000Z	0x8a02fcba66318f8cfc6cce64e62a9ae5b8e730e94ab7cc215d42d1ffb0090c5b
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	2000000	545	30874813	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	2023-11-09T22:47:30.000Z	0x149d139a1dbf3de58767973d994551a6745bb99a02a750202555c0abb04d1268
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	2000000	2592	30869584	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	2023-11-09T14:52:50.000Z	0x8fc53307576c22d9f88508d3ac37a3ae5237314f8962c47d70063c3af27b2dbb

Example Query

Query with partition filter

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

Vault_flashLoan_function

Flash loan transaction records from Balancer V2 Vault contract on Gnosis Chain, capturing borrowed token addresses, amounts, recipients, and execution status. Used for analyzing arbitrage activity, liquidations, and flash loan usage patterns across Balancer pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_userData`	`STRING`	Custom data passed to the flash loan recipient contract for execution logic. Hex-encoded bytes that can be empty or null; typically contains parameters for the recipient’s callback function.

Sample Data

gas	status	gas_used	in_tokens	signature	in_amounts	to_address	in_userData	block_number	from_address	in_recipient	trace_address	block_timestamp	transaction_hash
1489629	true	329411	[“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”]	0x5c38449e	[“2000000”]	0xba12222222228d8ba445958a75a0704d566bf2c8	0x00000000000000000000000000000000000000000000000000000000001e84800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000001e84800000000000000000000000000000000000000000000000000000000000000001000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8000000000000000000000000ddafbb505ad214d7b80b1f830fccc89b60fb7a8300000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000001b02da8cb0d097eb8d57a175b88c7d8b4799750600000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000003000000000000000000000000ddafbb505ad214d7b80b1f830fccc89b60fb7a830000000000000000000000006a023ccd1ff6f2045c3309768ead9e68f978f6e10000000000000000000000009c58bacc331c9aa871afd802db6379a98e80cedb000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000001c232f01118cb8b424793ae03f870aa7d0ac7f77000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000030000000000000000000000009c58bacc331c9aa871afd802db6379a98e80cedb000000000000000000000000e91d153e0b41518a2ce8dd3d7944fa863463a97d000000000000000000000000ddafbb505ad214d7b80b1f830fccc89b60fb7a83	30593573	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	0x6cd74fe6114620e7be7c80a22c9669d7e208c0c7	2	2023-10-23T03:45:40.000Z	0x8300cb0d4f671df5ffe5b7badd5bbe6ac7f4d9d4f48d78698e6e6ef4722458b6
304135	false	274429	[]	0x5c38449e	[]	0xba12222222228d8ba445958a75a0704d566bf2c8		33086829	0x1ef59199c2897066e624f31310952a572f90e1d2		0	2024-03-24T06:06:00.000Z	0x6da058ec41f20a39e9d90fef76d021ec448054637d15e55da1b8d6adb639cc5a
590611	false	514022	[]	0x5c38449e	[]	0xba12222222228d8ba445958a75a0704d566bf2c8		33097866	0x1ef59199c2897066e624f31310952a572f90e1d2		0	2024-03-24T22:05:00.000Z	0x961e0ff5bd231c311816dea0179cf7dde3157e28ad0206d8888a66e1b83e4a60

Example Query

Query with partition filter

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

Vault_InternalBalanceChanged_event

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

Columns

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

Sample Data

address	in_user	removed	in_delta	in_token	log_index	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	0x35606256aa7a7b489b961aedc3c729c9d0af96bd	false	10319032196921	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	175	29698268	2023-08-29T02:36:45.000Z	0xad44b2717a91779ec4b746115c7e097020838b974c7d67d94c30fc80c839a2f6
0xba12222222228d8ba445958a75a0704d566bf2c8	0x35606256aa7a7b489b961aedc3c729c9d0af96bd	false	11501440962821	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	13	29698278	2023-08-29T02:37:35.000Z	0x153e968e3509bb29abdc1aa79ea62cfa078ac2e65b806fa1c6c46f821584b601
0xba12222222228d8ba445958a75a0704d566bf2c8	0x35606256aa7a7b489b961aedc3c729c9d0af96bd	false	10807412823867	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	7	29708037	2023-08-29T16:37:45.000Z	0x3a75e3ae0503fa137f12cbeadb2f1da09fbbc0aa054564169c5ff9887b052f06

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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_gnosis.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	[“-176325274626768866”,“-47729531349006390”]	0x388cae2f7d3704c937313d990298ba67d70a3709000200000000000000000026	[“0x3a97704a1b25f08aa230ae53b352e2e72ef52843”,“0x9c58bacc331c9aa871afd802db6379a98e80cedb”]	69	28560028	2023-06-21T04:18:10.000Z	0x26917a85667de33b17873c913631f2c230f3567cdca90731301bda7606af9332	0xe29a236d38f609fa7891851a0828c8b9dd197f6e	[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“-158450865041155798”]	0x388cae2f7d3704c937313d990298ba67d70a3709000200000000000000000026	[“0x3a97704a1b25f08aa230ae53b352e2e72ef52843”,“0x9c58bacc331c9aa871afd802db6379a98e80cedb”]	23	28557859	2023-06-21T01:08:30.000Z	0x94ef0328384d55868b3cd9cc60297af03a16a73a17b23512aa210e8819b02d37	0xec23615309aa1f56d5d01647e9c5d562ff375ba0	[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“-104664376972644016”,“-28331625584671737”]	0x388cae2f7d3704c937313d990298ba67d70a3709000200000000000000000026	[“0x3a97704a1b25f08aa230ae53b352e2e72ef52843”,“0x9c58bacc331c9aa871afd802db6379a98e80cedb”]	49	28560033	2023-06-21T04:18:35.000Z	0xe40d6b2d9d9e81d41cb13fefafa3ab2c82d3bcd6dba987d4706846f819eb594c	0x016f4eb10196d247ae5eb2c9d6c2562d7db7e61c	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	0xbb9cd48d33033f5effbedec9dd700c7d7e1dcf5000000000000000000000000e	24	29472083	0	2023-08-15T11:27:50.000Z	0x588bfbed8e9910cabed5025f104ecec23c858cd7	-539758995063638441940	0xe73f999d329c2664ff5eaa6efd19e108e9bf7207a9e46ed0c7daca90fd4ad44c
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x20e5eb701e8d711d419d444814308f8c2243461f	0xbb9cd48d33033f5effbedec9dd700c7d7e1dcf5000000000000000000000000e	40	29472083	530900912155842674778	2023-08-15T11:27:50.000Z	0x588bfbed8e9910cabed5025f104ecec23c858cd7	-530900912155842674778	0xe73f999d329c2664ff5eaa6efd19e108e9bf7207a9e46ed0c7daca90fd4ad44c
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	0xbb9cd48d33033f5effbedec9dd700c7d7e1dcf5000000000000000000000000e	23	29472083	-539758995063638441940	2023-08-15T11:27:50.000Z	0x588bfbed8e9910cabed5025f104ecec23c858cd7	539758995063638441940	0xe73f999d329c2664ff5eaa6efd19e108e9bf7207a9e46ed0c7daca90fd4ad44c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	0x5237a12e9d9095cc085f2bdd4e32393993f73c15000200000000000000000062	30	30181402	0x5237a12e9d9095cc085f2bdd4e32393993f73c15	2023-09-27T14:46:10.000Z	0x30aed4282fbc1e4e7ad0d31fbf6696c0920ca8e2300e770d07532fc8c1dd990d	2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x3f3df4deee2067e7972d436980d2887103a3ed4d000200000000000000000052	2	29491600	0x3f3df4deee2067e7972d436980d2887103a3ed4d	2023-08-16T15:58:45.000Z	0xbc85f972ad7cbdbea45c1d77546389445717d9888fbed699f054d6abcf17013d	2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x915148cde625618e91b76edc7a20f00f12dfc4c1000200000000000000000047	18	29022286	0x915148cde625618e91b76edc7a20f00f12dfc4c1	2023-07-19T03:45:40.000Z	0x76bf4b53ef61a73a3a6b8c3d79a59b5f42a66bf4792e804927c59a6c9fa2eb75	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	0x1395de9daec52ad405e945603ea0a9346d00d01c	0xef606f58a4fd0fccb066c6203d0994694d3eb2d3	true	26827239	2023-03-07T18:02:15.000Z	0xe2e53f686139e405aa014d857454a0ae6a01f77b0947d3f66e658e87abb9b98e
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x7193b9710442d309614d4b57443c78b9365a2f6a	0x3536fd480ca495ac91e698a703248a8915c137a3	true	28761751	2023-07-03T10:27:40.000Z	0x9fa996144ba298a614e35f0d96172a65882dd3c5f268e35d845f6ba9a2a77a3b
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x93cafc0a320db75a0d2f44093486af22f8a2d9cb	0x3536fd480ca495ac91e698a703248a8915c137a3	true	28769224	2023-07-03T21:25:55.000Z	0x2989c32bbc33eb8b8eff19b654bbcddda3f00137169373c1dd1936fedb713e74

Example Query

Query with partition filter

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

Vault_Swap_event

Swap events emitted by decentralized exchange vault contracts containing input/output token addresses, amounts, pool identifiers, and swap fee data. Tracks token exchanges executed through vault-based automated market maker protocols.

Columns

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

Sample Data

address	removed	in_poolId	log_index	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f000000000000000000000004	30	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	2555983	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	26062897	2558264928509234751	2023-01-20T17:55:40.000Z	0xf764e11154b556fcd4e2d48b3d4fa438159781f5e69e4566919f5b984b438936
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f000000000000000000000004	20	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	2811563	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	26059328	2811201702694397942	2023-01-20T12:42:40.000Z	0x70a7380d73bd8dc96aa2a2ec338f6a660df54e797bab507b5ee04c27e6433844
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x11884da90fb4221b3aa288a7741c51ec4fc43b2f000000000000000000000004	40	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	417724816941565120	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	26066670	417397	2023-01-20T23:25:00.000Z	0x1523eb5ef57c779b87c1aaea092b085e4274e327b011363880fa5384dd89153a

Example Query

Query with partition filter

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

Vault_swap_function

Individual swap function calls to Balancer V2 Vault contract on Gnosis Chain including both successful and failed transactions. Useful for analyzing swap execution patterns, slippage impact, and transaction failure rates across Balancer pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_singleSwap`	`STRUCT<poolId STRING, kind INT64, assetIn STRING, assetOut STRING, amount STRING, userData STRING>`	Structured input parameter defining the swap operation, including pool identifier, token addresses, swap amount, and direction. Contains nested fields like `poolId`, `assetIn`, `assetOut`, `amount`, and `kind` that specify the complete swap execution details.
`in_funds`	`STRUCT<sender STRING, fromInternalBalance BOOL, recipient STRING, toInternalBalance BOOL>`	Fund transfer routing parameters for a swap operation. Struct containing sender address, recipient address, and boolean flags indicating whether to use internal balance for source (fromInternalBalance) and destination (toInternalBalance) of funds.
`in_limit`	`STRING`	Minimum amount of output tokens or maximum amount of input tokens acceptable for the swap, depending on swap direction (kind). Null for failed transactions; typically a large integer string for successful swaps specifying the user’s slippage tolerance.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`out_amountCalculated`	`STRING`	Token amount received from the swap execution, denominated in the output asset’s smallest unit. Null for failed transactions; populated with string-encoded integers for successful swaps.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
102291	1.000002e+21	false	58198	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	37271856	0xaa778c77e61b6feff66a6aa290adb4bfb5fc8ee4	2024-11-29T16:00:45.000Z	0xcc5fa0e09497c28670d16ed5a1a74bba6c73f7ab21a74376140b51b1a9087a25
1000000	0	false	58400	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	37271695	0x88928ff265a144aef2c5e228d536d9e477a68cfc	2024-11-29T15:47:05.000Z	0xa8a38e6f9121f0a5f51037beec2e377f4921d0d644a1e773eddccc4b10cc151f
1000000	0	false	58401	0x52bbbe29	0xba12222222228d8ba445958a75a0704d566bf2c8	37265333	0x88928ff265a144aef2c5e228d536d9e477a68cfc	2024-11-29T06:34:50.000Z	0x00d4add2ff7985817abb56b8dd7089bda26ef51e1975366426a835e5721016b7

Example Query

Query with partition filter

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

Vault_TokensDeregistered_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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	0x0c1b9ce6bf6c01f587c2ee98b0ef4b20c6648753000000000000000000000050	[“0x0c1b9ce6bf6c01f587c2ee98b0ef4b20c6648753”,“0x2086f52651837600180de173b09470f54ef74910”,“0xcb444e90d8198415266c6a2724b7900fb12fc56e”]	13	29419668	2023-08-12T05:09:30.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x65b51c3739522bef5e7375a0fa81b29c7111fd43f12d977ddd919ffa041ff8de
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x2086f52651837600180de173b09470f54ef7491000000000000000000000004f	[“0x2086f52651837600180de173b09470f54ef74910”,“0x4ecaba5870353805a9f068101a40e0f32ed605c6”,“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”]	114	29419540	2023-08-12T04:58:05.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xb708dfeebbcb933746e5187c375fa16eaa36f5583e782f92b4c875f5c0b62efd
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x07c896050dd6e273c199f06d7516f8a4a369d23a000000000000000000000008	[“0x07c896050dd6e273c199f06d7516f8a4a369d23a”,“0x7ef541e2a22058048904fe5744f9c7e4c57af717”,“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”]	2	26368162	2023-02-08T04:08:50.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xdb6f2d2d5fd149e1b3740be6d68355e9840ff9fdcf8d9b6ca44f6eaeff35a215

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.Vault_TokensRegistered_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
0xf302f9f50958c5593770fdf4d4812309ff77414f	false	10	26629165	2023-02-23T20:04:35.000Z	0x04289b1a1deae052a0c26f1a1906f9a72941b63b128587797e789499b38391b3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xf302f9f50958c5593770fdf4d4812309ff77414f	0x0503dd6b2d3dd463c9bef67fb5156870af63393e	false	6	25898822	2023-01-10T19:19:20.000Z	0xc2f2ccd95f69a5c4ee875fcd862b5a16fbbf58a840af9d5ef1be7df59252f86a
0xf302f9f50958c5593770fdf4d4812309ff77414f	0x8a819a4cabd6efcb4e5504fe8679a1abd831dd8f	false	11	25897218	2023-01-10T16:58:45.000Z	0xc74ba73e16c76e6f99fe937a83c64a14c51c8c3421f45191998d5f4035dbe601
0xf302f9f50958c5593770fdf4d4812309ff77414f	0xbea652aa29d38114e9d36f2a2e4167b13df68e73	false	6	26365879	2023-02-08T00:52:25.000Z	0x193d5a15f56a43fc537fe5f8f387d6519a15094b60725ded00ed36434ba2048f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xc128a9954e6c874ea3d62ce62b468ba073093f25	false	22	27987556	2023-05-17T10:48:25.000Z	0x75555a955fdf1d1962c563c4a282305fbd62e875feb3992284d2974bf3875132

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0xc128a9954e6c874ea3d62ce62b468ba073093f25	0x026e352458409db7113cda942149c1e19693ac80	false	12	27166983	2023-03-28T17:03:10.000Z	0x1c00d43b9299ff2909f4b22a761b7ec73130b82da331ebb7578a3e52c7f0546b
0xc128a9954e6c874ea3d62ce62b468ba073093f25	0x864f76eabe542b0a83d09257afad59ad6f4eedc3	false	6	26982794	2023-03-17T05:36:25.000Z	0x3d98271fdbf0c1b6e76444bf501ad3d79312af9d16cad5adb1245190573f70df
0xc128a9954e6c874ea3d62ce62b468ba073093f25	0x11467c3beea894d9e8618d80b9a006c9baa9344c	false	88	26988793	2023-03-17T14:44:25.000Z	0x84fa4b52c9e1ae95af2b8d20070b2396262c3373f172bfb62091de491b1d277d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x6cad2ea22bfa7f4c14aae92e47f510cd5c509bc7	false	19	43243860	2025-11-20T15:59:10.000Z	0x1005b5abdb5b6a0303838f20dadbf35e04912101b3b78690ef25a741ebb74506

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.balancer_v2_gnosis.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
0x6cad2ea22bfa7f4c14aae92e47f510cd5c509bc7	0x65fdcd3c159845f0b33a274aad527391cfe0583e	false	47	28250588	2023-06-02T10:27:45.000Z	0x6ae9100a4b94f509d1fe75620745523f684782a335be14a86697d1843c643c3a
0x6cad2ea22bfa7f4c14aae92e47f510cd5c509bc7	0x15d17723bc3840f6e86ab47819843fcd7558f410	false	208	28417245	2023-06-12T12:56:55.000Z	0x7498d931ef394c418cf4af7f4abb405a2d1ad1cef494e11e27eff82beaab0432
0x6cad2ea22bfa7f4c14aae92e47f510cd5c509bc7	0x77672c8c5c91976d79785661f7bff7281ee529ca	false	74	28416815	2023-06-12T12:18:05.000Z	0xdf3035ddc02902807d332962d834a0bb9febcc943cf3f0761e7d85761a1fd07c

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​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

​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

​ManagedPoolFactoryV2_FactoryDisabled_event

​ManagedPoolFactoryV2_PoolCreated_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

​NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

​Pool_RecoveryModeStateChanged_event

​Pool_SwapFeePercentageChanged_event

​Pool_Transfer_event

​ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

​ProtocolFeesCollector_SwapFeePercentageChanged_event

​StablePoolFactoryV2_FactoryDisabled_event

​StablePoolFactoryV2_PoolCreated_event

​UnbuttonAaveLinearPoolFactory_PoolCreated_event

​Vault_AuthorizerChanged_event

​Vault_batchSwap_function

​Vault_ExternalBalanceTransfer_event

​Vault_FlashLoan_event

​Vault_flashLoan_function

​Vault_InternalBalanceChanged_event

​Vault_PausedStateChanged_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_RelayerApprovalChanged_event

​Vault_Swap_event

​Vault_swap_function

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPoolFactoryV2_FactoryDisabled_event

​WeightedPoolFactoryV2_PoolCreated_event

​WeightedPoolFactoryV3_FactoryDisabled_event

​WeightedPoolFactoryV3_PoolCreated_event

​WeightedPoolFactoryV4_FactoryDisabled_event

​WeightedPoolFactoryV4_PoolCreated_event

Tables

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

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

ManagedPoolFactoryV2_FactoryDisabled_event

ManagedPoolFactoryV2_PoolCreated_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event

NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event

Pool_RecoveryModeStateChanged_event

Pool_SwapFeePercentageChanged_event

Pool_Transfer_event

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

ProtocolFeesCollector_SwapFeePercentageChanged_event

StablePoolFactoryV2_FactoryDisabled_event

StablePoolFactoryV2_PoolCreated_event

UnbuttonAaveLinearPoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_batchSwap_function

Vault_ExternalBalanceTransfer_event

Vault_FlashLoan_event

Vault_flashLoan_function

Vault_InternalBalanceChanged_event

Vault_PausedStateChanged_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_RelayerApprovalChanged_event

Vault_Swap_event

Vault_swap_function

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPoolFactoryV2_FactoryDisabled_event

WeightedPoolFactoryV2_PoolCreated_event

WeightedPoolFactoryV3_FactoryDisabled_event

WeightedPoolFactoryV3_PoolCreated_event

WeightedPoolFactoryV4_FactoryDisabled_event

WeightedPoolFactoryV4_PoolCreated_event