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

# beethoven_v3_sonic

> Tables in tt-contracts.beethoven_v3_sonic

## Tables

### V3StablePoolFactory\_PoolCreated\_event

Event logs emitted when new stable swap pools are created by Balancer V3 StablePoolFactory contracts. Contains the factory contract address and newly deployed pool address for tracking pool deployment activity.

<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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x815ab57a5a2e4976cec0b43c2d50cf26ef6f31fd | 0xd9a6c9e698b64d37953300a02b4c970538bde3a2 | false   | 5          | 16406725      | 2025-03-27T19:44:20.000Z | 0xa51b5bd6ef3f7e8150a32835f7597c079403e0523fe060b369378723f0633d78 |
  | 0x815ab57a5a2e4976cec0b43c2d50cf26ef6f31fd | 0xc1c2d92b9b0f3963185a4e80de73e3da20930b4e | false   | 1          | 4663293       | 2025-01-20T09:36:10.000Z | 0x8f1a3fb16c818cb8ef6fe79a1e275ef46aaafd5ede4bce33abd740b810a42205 |
  | 0x815ab57a5a2e4976cec0b43c2d50cf26ef6f31fd | 0xf0db172592fb5f091e1805eb0a774fa66bf254f4 | false   | 1          | 5092414       | 2025-01-23T07:13:34.000Z | 0x5f4516e9f5dded93190a1165a27d5378aff19d1136d2d508117e8640d0584484 |
</Accordion>

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

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

***

### V3StablePoolFactoryV2\_PoolCreated\_event

Balancer V3 stable pool creation events emitted by the V3StablePoolFactoryV2 contract. Records the deployment of new stable pools with the pool contract address for tracking liquidity pool initialization across Balancer V3 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.                                           |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x482ee54595f79b6ba34b75754a4983134148affb | 0xaadf6ba424d7333c0a397075a41af86c21f43806 | false   | 1          | 45729260      | 2025-09-04T13:30:02.000Z | 0x811135e238f42b17c00e717cac9f8964606bdffbc22c3ea8fa0aef2ab745d8ab |
  | 0x482ee54595f79b6ba34b75754a4983134148affb | 0x23a5b6d48d71ec44f251c8eae5d899fab6e58315 | false   | 9          | 41665245      | 2025-08-05T00:24:38.000Z | 0x735e2eee096fecba6c2957233b05a052fee38aab83d1f6c6aedbe6c5d4203b09 |
  | 0x482ee54595f79b6ba34b75754a4983134148affb | 0x6105fc53ba076ed947647fca9d036565fa85c8e5 | false   | 1          | 39064826      | 2025-07-18T09:20:43.000Z | 0xde889309d21c45d8bde5b5b5c53ddc1eebd35df5c8cec5e4a16793376faec77d |
</Accordion>

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

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

***

### V3WeightedPoolFactory\_PoolCreated\_event

Event logs emitted when a new weighted liquidity pool is deployed by the V3WeightedPoolFactory contract on Balancer V3 or Beethoven X protocols. Contains the factory contract address and the newly created pool address for tracking pool 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.                                           |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x4726eb55c37f0353f6d5011b5652d44a87d60fc3 | 0x5ea5ea5892f033a20ee42a2b180de85f2f21ec00 | false   | 0          | 36634675      | 2025-06-30T21:10:55.000Z | 0x1e1a400a463aa9dfdc2395d10eb0bf70d3edeef59451e4df53638dfad8aa10d9 |
  | 0x4726eb55c37f0353f6d5011b5652d44a87d60fc3 | 0x5c7230d2ad051920da978cbb7f00e158da634df6 | false   | 0          | 36549023      | 2025-06-30T06:56:07.000Z | 0x587bc141e9dbfb87b86abe293e5003f37edc390ca1bbcd6ec04a03e2e3974f13 |
  | 0x4726eb55c37f0353f6d5011b5652d44a87d60fc3 | 0x4579ef27fcf0e5d6ab5e11eeb0d4867070d91caf | false   | 0          | 34890496      | 2025-06-19T21:07:35.000Z | 0x36520cf03cb7d665034c472aea4658412ca5a988b663ec462b0c904bba6cb53b |
</Accordion>

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

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

***