> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# balancer_v4_ethereum

> Tables in tt-contracts.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.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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.       |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPool_Approval_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### WeightedPool\_PausedStateChanged\_event

*No description available.*

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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.          |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPool_PausedStateChanged_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column                     | Type        | Description                                                                                                                                                                                      |
  | -------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
  | `block_timestamp`          | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                                                      |
  | `block_number`             | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.                                             |
  | `transaction_hash`         | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                                                              |
  | `log_index`                | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                                                               |
  | `address`                  | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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. |
</Accordion>

<Accordion title="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        |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPool_ProtocolFeePercentageCacheUpdated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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.                                                                           |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPool_RecoveryModeStateChanged_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column                 | Type        | Description                                                                                                                                          |
  | ---------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`      | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`         | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash`     | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`            | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`              | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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%.              |
</Accordion>

<Accordion title="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      |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPool_SwapFeePercentageChanged_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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.       |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPool_Transfer_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

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

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x897888115ada5773e02aa29f775430bfb5f34c51 | false   | 194        | 23841253      | 2025-11-20T15:50:59.000Z | 0x214e48f866c39a0aef255923ff3c22e25f9afc5ec70a8823e102e854d9595d1b |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPoolFactory_FactoryDisabled_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-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.                                           |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.balancer_v4_ethereum.WeightedPoolFactory_PoolCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***