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.

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

Example Query

Query with partition filter

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

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.

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

Example Query

Query with partition filter

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

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.

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	block_number	block_timestamp	transaction_hash
0x4726eb55c37f0353f6d5011b5652d44a87d60fc3	0x5ea5ea5892f033a20ee42a2b180de85f2f21ec00	false	36634675	2025-06-30T21:10:55.000Z	0x1e1a400a463aa9dfdc2395d10eb0bf70d3edeef59451e4df53638dfad8aa10d9
0x4726eb55c37f0353f6d5011b5652d44a87d60fc3	0x5c7230d2ad051920da978cbb7f00e158da634df6	false	36549023	2025-06-30T06:56:07.000Z	0x587bc141e9dbfb87b86abe293e5003f37edc390ca1bbcd6ec04a03e2e3974f13
0x4726eb55c37f0353f6d5011b5652d44a87d60fc3	0x4579ef27fcf0e5d6ab5e11eeb0d4867070d91caf	false	34890496	2025-06-19T21:07:35.000Z	0x36520cf03cb7d665034c472aea4658412ca5a988b663ec462b0c904bba6cb53b

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

V3StablePoolFactory_PoolCreated_event

V3StablePoolFactoryV2_PoolCreated_event

V3WeightedPoolFactory_PoolCreated_event

​Tables

​V3StablePoolFactory_PoolCreated_event

​V3StablePoolFactoryV2_PoolCreated_event

​V3WeightedPoolFactory_PoolCreated_event

Tables

V3StablePoolFactory_PoolCreated_event

V3StablePoolFactoryV2_PoolCreated_event

V3WeightedPoolFactory_PoolCreated_event