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

> Tables in tt-contracts.balancer_0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b_polygon

## Tables

### YearnLinearPoolFactory\_FactoryDisabled\_event

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

<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                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b | false   | 311        | 43061191      | 2023-05-23T18:35:52.000Z | 0xd206088f1705a8c09f4df54f549b5d5a57a9033fbbf586aff61bbad491eef13b |
</Accordion>

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

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

***

### YearnLinearPoolFactory\_PoolCreated\_event

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

<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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b | 0x0320c1c5b6df19a194d48882aaec1c72940081d9 | false   | 320        | 39341199      | 2023-02-16T01:50:22.000Z | 0x6dd9d5d3a6ca6291bafd4da510b2411adccd9a5f00ec2c6f416a26ec7aa1703a |
</Accordion>

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

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

***

### YearnLinearPoolFactory\_YearnLinearPoolCreated\_event

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

<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.                                           |
  | `in_protocolId`    | `STRING`    | Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | log\_index | block\_number | in\_protocolId | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x7396f99b48e7436b152427bfa3dd6aa8c7c6d05b | 0x0320c1c5b6df19a194d48882aaec1c72940081d9 | false   | 325        | 39341199      | 0              | 2023-02-16T01:50:22.000Z | 0x6dd9d5d3a6ca6291bafd4da510b2411adccd9a5f00ec2c6f416a26ec7aa1703a |
</Accordion>

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

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

***
