balancer_v4_ethereum

Tables

WeightedPool_Approval_event

ERC-20 token approval events from Balancer V4 weighted pool contracts on Ethereum, recording owner addresses authorizing spender addresses to transfer specified token amounts. Used for tracking liquidity pool token spending permissions and analyzing approval patterns for pool share transfers.

Columns

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

Sample Data

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0x034e2d995b39a88ab9a532a9bf0deddac2c576ea	false	0x42b12c45044a89045f483d28c24a9c0abeccfbb6	28242580395975240850	178	0x13dd3eaecfb09a1ea9ced4a21ca47ca7852c9694	18557521	2023-11-12T18:08:47.000Z	0xbbd26435973a39dc8de3f84a355a1b27dfae607f5fc14d28ddd4f929f37a4058
0x034e2d995b39a88ab9a532a9bf0deddac2c576ea	false	0xbd71f285ab35c72409ab87da2f43040ceff168e5	115792089237316195423570985008687907853269984665640564039457584007913129639935	177	0x13dd3eaecfb09a1ea9ced4a21ca47ca7852c9694	18558339	2023-11-12T20:52:59.000Z	0x0ae39bd61744df25e4ff2983baf070bafe129311ddcc25a6039be051b6705df6
0x034e2d995b39a88ab9a532a9bf0deddac2c576ea	false	0xc406d141c65750c9332fa4049313e5f400ae826c	115792089237316195423570985008687907853269984665640564039457584007913129639935	240	0x13dd3eaecfb09a1ea9ced4a21ca47ca7852c9694	18554311	2023-11-12T07:21:23.000Z	0x1ec3ae59071e1836f1d095593b6405ea63361a74b69c4b703325c5376a87b3b8

Example Query

Query with partition filter

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

WeightedPool_PausedStateChanged_event

No description available.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

WeightedPool_ProtocolFeePercentageCacheUpdated_event

Protocol fee percentage cache updates for Balancer V4 weighted pools on Ethereum, emitted when fee rates are modified by fee type. Used for tracking fee structure changes across different pool operations like swaps and yields.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_feeType`	`STRING`	Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes.
`in_protocolFeePercentage`	`STRING`	Protocol fee percentage applied to the specified fee type, represented as an 18-decimal fixed-point number. Value of ‘500000000000000000’ equals 50% fee, while ‘0’ indicates no fee is charged.

Sample Data

address	removed	log_index	in_feeType	block_number	block_timestamp	transaction_hash	in_protocolFeePercentage
0x271d57ce059780462f89800141a089008ca78d4a	false	91	3	18464666	2023-10-30T18:09:47.000Z	0x54f5790888b96def03336e0cc2e129d7f3b563b0b361f957da5c86cf816aaad3	0
0x271d57ce059780462f89800141a089008ca78d4a	false	92	0	18464666	2023-10-30T18:09:47.000Z	0x54f5790888b96def03336e0cc2e129d7f3b563b0b361f957da5c86cf816aaad3	500000000000000000
0x271d57ce059780462f89800141a089008ca78d4a	false	90	2	18464666	2023-10-30T18:09:47.000Z	0x54f5790888b96def03336e0cc2e129d7f3b563b0b361f957da5c86cf816aaad3	500000000000000000

Example Query

Query with partition filter

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

WeightedPool_RecoveryModeStateChanged_event

Recovery mode state changes for Balancer v4 weighted pools on Ethereum. Tracks when pools enter or exit recovery mode, which allows emergency withdrawals during protocol issues or 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.
`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
0xb841b062ea8ccf5c4cb78032e91de4ae87556042	false	105	true	17971031	2023-08-22T15:05:23.000Z	0x4cac17671a7490b4c9816323be399493b8ff1757fc26f3d9d47a0efdce83d64f
0x9d7f992c900fbea0ec314bdd71b7cc1becf76a33	false	100	true	17971031	2023-08-22T15:05:23.000Z	0x4cac17671a7490b4c9816323be399493b8ff1757fc26f3d9d47a0efdce83d64f
0x2e52c64fd319e380cdbcfc4577ea1fda558a32e4	false	72	true	17971031	2023-08-22T15:05:23.000Z	0x4cac17671a7490b4c9816323be399493b8ff1757fc26f3d9d47a0efdce83d64f

Example Query

Query with partition filter

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

WeightedPool_SwapFeePercentageChanged_event

Swap fee percentage update events from Balancer v4 weighted pools on Ethereum, recording when pool operators modify trading fees (expressed in wei, typically 0.1-1% range). Useful for tracking fee governance decisions and analyzing pool competitiveness over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x26cc136e9b8fd65466f193a8e5710661ed9a9827	false	60	18129821	2023-09-13T20:40:47.000Z	0xc40d5cc3b6ca1a9ddcbcb4ca843f48e5c9cfebb7708daa77308a0f387039110a	1000000000000000
0x26cc136e9b8fd65466f193a8e5710661ed9a9827	false	66	18129821	2023-09-13T20:40:47.000Z	0xc40d5cc3b6ca1a9ddcbcb4ca843f48e5c9cfebb7708daa77308a0f387039110a	5000000000000000
0x3ff3a210e57cfe679d9ad1e9ba6453a716c56a2e	false	137	18129410	2023-09-13T19:17:59.000Z	0xe0e06dcf167d7e84f5924068bae895d5d652db6606dd877882111e15b151bb53	2000000000000000

Example Query

Query with partition filter

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

WeightedPool_Transfer_event

Balancer Pool Token (BPT) transfer events from Balancer v4 weighted pools on Ethereum, tracking liquidity provider token movements including mints (from zero address) and burns (to zero address). Used for analyzing pool share ownership changes, liquidity additions and 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_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	0x380aabe019ed2a9c2d632b51eddd30fd804d0fad	0x0000000000000000000000000000000000000000	false	4894659483779611411	228	17451343	2023-06-10T17:47:11.000Z	0x431ea9d54bc4c3b4c1a40e34154647037dcfa6463b9324e11bc571950a525353
0x2326d4fb2737666dda96bd6314e3d4418246cfe8	0x380aabe019ed2a9c2d632b51eddd30fd804d0fad	0x0000000000000000000000000000000000000000	false	22478700210160862139638	230	17451343	2023-06-10T17:47:11.000Z	0x431ea9d54bc4c3b4c1a40e34154647037dcfa6463b9324e11bc571950a525353
0xce88686553686da562ce7cea497ce749da109f9f	0x380aabe019ed2a9c2d632b51eddd30fd804d0fad	0x0000000000000000000000000000000000000000	false	17139780795563402	229	17451343	2023-06-10T17:47:11.000Z	0x431ea9d54bc4c3b4c1a40e34154647037dcfa6463b9324e11bc571950a525353

Example Query

Query with partition filter

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

WeightedPoolFactory_FactoryDisabled_event

Factory disablement events from Balancer V4’s WeightedPoolFactory contract on Ethereum. Tracks when the factory contract is administratively disabled, preventing creation of new weighted pools.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x897888115ada5773e02aa29f775430bfb5f34c51	false	194	23841253	2025-11-20T15:50:59.000Z	0x214e48f866c39a0aef255923ff3c22e25f9afc5ec70a8823e102e854d9595d1b

Example Query

Query with partition filter

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

WeightedPoolFactory_PoolCreated_event

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

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x897888115ada5773e02aa29f775430bfb5f34c51	0x4114fd8554e63a9e0f09ca2480977883fea06430	false	234	18371924	2023-10-17T18:37:11.000Z	0xc45366c45974319cab39dfe10769c303ce2ab39e9fe100ad58260118c3c11821
0x897888115ada5773e02aa29f775430bfb5f34c51	0xa9dd57145ca13a2f05199d85e3f2739af6478427	false	384	17889516	2023-08-11T05:19:59.000Z	0x9cd5b3b0d41d37c4c3f599b92a3e0cd72507f22a24ed5213eb7814dec1fe3375
0x897888115ada5773e02aa29f775430bfb5f34c51	0x382dc5b2eca1c1308eb7e2b40c0f571afb899ac8	false	290	17345657	2023-05-26T20:30:47.000Z	0xa00c4b44b0b526a33776769180535f1ee8269bc7cb5f7ab08b0691016e490761

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

WeightedPool_Approval_event

WeightedPool_PausedStateChanged_event

WeightedPool_ProtocolFeePercentageCacheUpdated_event

WeightedPool_RecoveryModeStateChanged_event

WeightedPool_SwapFeePercentageChanged_event

WeightedPool_Transfer_event

WeightedPoolFactory_FactoryDisabled_event

WeightedPoolFactory_PoolCreated_event

​Tables

​WeightedPool_Approval_event

​WeightedPool_PausedStateChanged_event

​WeightedPool_ProtocolFeePercentageCacheUpdated_event

​WeightedPool_RecoveryModeStateChanged_event

​WeightedPool_SwapFeePercentageChanged_event

​WeightedPool_Transfer_event

​WeightedPoolFactory_FactoryDisabled_event

​WeightedPoolFactory_PoolCreated_event

Tables

WeightedPool_Approval_event

WeightedPool_PausedStateChanged_event

WeightedPool_ProtocolFeePercentageCacheUpdated_event

WeightedPool_RecoveryModeStateChanged_event

WeightedPool_SwapFeePercentageChanged_event

WeightedPool_Transfer_event

WeightedPoolFactory_FactoryDisabled_event

WeightedPoolFactory_PoolCreated_event