> ## 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_v1_fantom
> Tables in tt-contracts.beethoven_v1_fantom
## Tables
### BooLinearPoolFactory\_PoolCreated\_event
Linear pool creation events from Beethoven X (formerly Boo) on Fantom, tracking when new linear pools are deployed through the factory contract. Used for monitoring pool launches and analyzing liquidity deployment strategies.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xba306e3cf84751d8ef5e812c18caa6c567c783e8 | 0x71959b131426fdb7af01de8d7d4149ccaf09f8cc | false | 4 | 32511287 | 2022-03-04T07:40:50.000Z | 0xc03781c0617125a786a2073fb382bd988d218ff63c20e663ba1b5d7e03cdab72 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.BooLinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ComposableStablePoolFactory\_PoolCreated\_event
Pool creation events emitted by Balancer V2 Composable Stable Pool factory contracts. Records the factory contract address and newly deployed pool address for tracking stable pool deployments across AMM (Automated Market Maker) protocols.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5c3094982cf3c97a06b7d62a6f7669f14a199b19 | 0x98c3c3a426dc2c2a7017809f134ca9dab151877a | false | 270 | 61771622 | 2023-05-08T14:44:15.000Z | 0x3d56d0eaabb14da81370a866da71213796d14fc1a840fe81e2964fa49c90514a |
| 0x5c3094982cf3c97a06b7d62a6f7669f14a199b19 | 0x3eb521a33082e471f87df67b82e14e1c760fc861 | false | 7 | 61772733 | 2023-05-08T15:00:25.000Z | 0xeb4f157ba82680ae61f2ed9c7e3c08b01e69e8577957fdbde9919aa5ff03fcf6 |
| 0x5c3094982cf3c97a06b7d62a6f7669f14a199b19 | 0xeb38aa08bc00ba68237543d2daa1476b4dfd37f8 | false | 12 | 61391871 | 2023-05-03T17:12:17.000Z | 0x0e737f9cef738437e71de4e57e1e76c9eda97ce79ee56d1cfaabaacb90e8e6a0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ComposableStablePoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ComposableStablePoolFactoryV2\_PoolCreated\_event
Pool creation events emitted by Balancer V2 Composable Stable Pool Factory V2 contracts, recording the deployment address of each new stable pool. Used for tracking pool deployments and factory activity across Balancer V2 implementations.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb384a86f2fd7788720db42f9daa60fc07ecbea06 | 0xd69959fa7910ceb3a2d359ed33cb8297670b6937 | false | 28 | 49516811 | 2022-10-19T07:37:58.000Z | 0x6352a14411ee37dd90463390f49a6bf71d56845634b9a932f5d39c9c6dcdec5e |
| 0xb384a86f2fd7788720db42f9daa60fc07ecbea06 | 0xf86785fe1cefd5069e6df1b4b54b72b199200311 | false | 77 | 49518805 | 2022-10-19T08:12:55.000Z | 0xdd5ee31bb150246c363a702c38892faed0f9d0c1d4fd43c4cc68b570ea604387 |
| 0xb384a86f2fd7788720db42f9daa60fc07ecbea06 | 0xf7705cd188a8ac806d28f85bdb13a38313e985ff | false | 11 | 49595723 | 2022-10-20T07:21:50.000Z | 0xe0191b9e5a6920c32e92773235fa777e837f2f4d912c59cf82ee7fd1e5394771 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ComposableStablePoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ComposableStablePoolFactoryV3\_PoolCreated\_event
Pool creation events emitted by Balancer V2 ComposableStablePoolFactoryV3 contracts. Records the deployment of new composable stable pools with their contract addresses for tracking liquidity pool lifecycle and inventory.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x23f03a4fb344d8b98833d2ace093cc305e03474f | 0x4e87cc8043ef97a21282e72ab172722634fc2127 | false | 7 | 66050303 | 2023-07-19T13:10:31.000Z | 0xc286b2b6b7971bcb17205ffb66867d85a3a691e2568b86e54ed462603a93c7b2 |
| 0x23f03a4fb344d8b98833d2ace093cc305e03474f | 0x775c8e7e56f7fae5e483c900c1d1217b7b51971e | false | 17 | 66730119 | 2023-08-07T15:13:55.000Z | 0x7a6dc113a3e8f068f2872a79cf30e232a5b3a0cbe32809c24600419ff9d18815 |
| 0x23f03a4fb344d8b98833d2ace093cc305e03474f | 0xae3cf8cb5d85f8b826a2181729df3d1760827529 | false | 16 | 66518669 | 2023-08-01T15:44:01.000Z | 0x2c3cb3c59da340c649b29b38a261d4757ece418aca46a40414de657a12a8ca29 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ComposableStablePoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ERC4626LinearPoolFactory\_Erc4626LinearPoolCreated\_event
Pool deployment events from Beethoven X's ERC-4626 Linear Pool Factory on Fantom, tracking creation of yield-bearing pools that integrate with ERC-4626 vaults. Used for monitoring new pool launches and analyzing Beethoven's liquidity infrastructure expansion.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | in\_protocolId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x89857161e0ad36f8c5a537733c1fcf7145220aae | 0x3ee7a82c1ecf54a375da1e3452b21ac986f348db | false | 155 | 66439063 | 0 | 2023-07-30T05:07:58.000Z | 0x0322d045d2a7e811d6ed8773b6a83442cb50e3a0a6e9fdc9fb3bbb9cbac6f64e |
| 0x89857161e0ad36f8c5a537733c1fcf7145220aae | 0xa02c23525f12c677156d076268f4b44e12e38e4d | false | 9 | 66438895 | 0 | 2023-07-30T04:59:46.000Z | 0xfacc2a200c6062b76557ec0058b2c7a0e932cb8d4a0035de1238477e649377ef |
| 0x89857161e0ad36f8c5a537733c1fcf7145220aae | 0xd20547850f3f80204439eafc942ec4780d32f2bd | false | 47 | 55683449 | 0 | 2023-02-13T07:16:49.000Z | 0x92b4101408a9fdcad4130ff3deb9c2294222c664ce63a65312727400547513cf |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ERC4626LinearPoolFactory_Erc4626LinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ERC4626LinearPoolFactory\_PoolCreated\_event
ERC-4626 (tokenized vault standard) linear pool creation events from Beethoven X protocol on Fantom. Records factory contract deployments of new liquidity pools with their addresses and timestamps for tracking pool launches and ecosystem growth.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x89857161e0ad36f8c5a537733c1fcf7145220aae | 0xd20547850f3f80204439eafc942ec4780d32f2bd | false | 42 | 55683449 | 2023-02-13T07:16:49.000Z | 0x92b4101408a9fdcad4130ff3deb9c2294222c664ce63a65312727400547513cf |
| 0x89857161e0ad36f8c5a537733c1fcf7145220aae | 0x3ee7a82c1ecf54a375da1e3452b21ac986f348db | false | 150 | 66439063 | 2023-07-30T05:07:58.000Z | 0x0322d045d2a7e811d6ed8773b6a83442cb50e3a0a6e9fdc9fb3bbb9cbac6f64e |
| 0x89857161e0ad36f8c5a537733c1fcf7145220aae | 0xa02c23525f12c677156d076268f4b44e12e38e4d | false | 4 | 66438895 | 2023-07-30T04:59:46.000Z | 0xfacc2a200c6062b76557ec0058b2c7a0e932cb8d4a0035de1238477e649377ef |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ERC4626LinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ERC4626LinearPoolFactoryV2\_Erc4626LinearPoolCreated\_event
ERC-4626 linear pool creation events from Beethoven X (Balancer V2 fork) on Fantom, tracking when new yield-bearing token pools are deployed via the factory contract. Used for monitoring pool launches and analyzing the expansion of Beethoven's liquidity infrastructure.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | in\_protocolId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1f641e8a2a966835f1979c3938654b6a4874eeda | 0x6ab829877d5ad14667b00b57e6df9d98da0867a3 | false | 26 | 66363604 | 0 | 2023-07-27T20:35:24.000Z | 0xbe65393b1102c80e13c86b5c2c325cf996013baa530b5b54088a3171d59ddbfd |
| 0x1f641e8a2a966835f1979c3938654b6a4874eeda | 0x441fe62fdc40125aace5e11644cd59ffe7515d66 | false | 15 | 66363553 | 0 | 2023-07-27T20:33:17.000Z | 0x42fb5c53bd90b5f949378ae6fc9ea6ae9fd72b31faeeaf4590f31eeba9b69966 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ERC4626LinearPoolFactoryV2_Erc4626LinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ERC4626LinearPoolFactoryV2\_PoolCreated\_event
Pool creation events emitted by Balancer V2's ERC4626 linear pool factory (version 2), recording the deployment of new ERC-4626 tokenized vault linear pools. Used for tracking factory-deployed pool inventory and analyzing pool creation patterns across Balancer-compatible protocols.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1f641e8a2a966835f1979c3938654b6a4874eeda | 0x441fe62fdc40125aace5e11644cd59ffe7515d66 | false | 10 | 66363553 | 2023-07-27T20:33:17.000Z | 0x42fb5c53bd90b5f949378ae6fc9ea6ae9fd72b31faeeaf4590f31eeba9b69966 |
| 0x1f641e8a2a966835f1979c3938654b6a4874eeda | 0x6ab829877d5ad14667b00b57e6df9d98da0867a3 | false | 21 | 66363604 | 2023-07-27T20:35:24.000Z | 0xbe65393b1102c80e13c86b5c2c325cf996013baa530b5b54088a3171d59ddbfd |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ERC4626LinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ERC4626LinearPoolFactoryV3\_PoolCreated\_event
ERC-4626 Linear Pool Factory version 3 pool creation events emitted when a new ERC-4626 linear pool is deployed through the Balancer V2 factory contract. Tracks the creation of yield-bearing linear pools that implement the ERC-4626 tokenized vault standard.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1b2b291f5dca9fc7811fc5998758305faec7977c | 0xadab239e677bbc038f5244ac6c7de2d684b0b92c | false | 13 | 63803359 | 2023-06-09T03:19:01.000Z | 0x9ce7abc8bfa54471b8a7a74b4be7fc13d4ee668d42baebcd8af042b4b9f1d139 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ERC4626LinearPoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityBootstrappingPoolFactory\_PoolCreated\_event
Liquidity Bootstrapping Pool (LBP) creation events emitted by Balancer V2 factory contracts. Records the deployment of new LBP pools with their contract addresses for tracking token launch mechanisms.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x2c774732c93ce393ec8125bda49fb3737ae6f473 | 0xf98a106f2e02ad15aa00189414979b110d45fe8a | false | 46 | 55596336 | 2023-02-12T01:12:11.000Z | 0xec6581191666aa78bb764050604d21d9c3d0bb0e08cd7e4714bf55e2b3c41418 |
| 0x2c774732c93ce393ec8125bda49fb3737ae6f473 | 0xd1cbea11d759d64c985687d63ffcc905468c0218 | false | 18 | 27634551 | 2022-01-11T08:45:03.000Z | 0x33a4f14538b923df5569632aa430960a748ec5d8c7bd56395bd02d2c0b9137ec |
| 0x2c774732c93ce393ec8125bda49fb3737ae6f473 | 0x65cf74fb5e6161f6d2f99eac1d3f4deace58e0f5 | false | 20 | 60315623 | 2023-04-19T18:10:04.000Z | 0x78f8011c2d53b8835a8c1caa73c56497a31f961513b783acfaf77387ee95fdce |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.LiquidityBootstrappingPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityBootstrappingPoolFactoryV2\_PoolCreated\_event
Liquidity Bootstrapping Pool (LBP) creation events from Beethoven X V2 factory on Fantom, capturing newly deployed pool addresses and deployment timestamps. Used for tracking LBP launches and analyzing token distribution events on the platform.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x458368b3724b5a1c1057a00b28eb03feb5b64968 | 0x9969a68cd31414b74ba61e9c3553431a7bca76e2 | false | 35 | 23487562 | 2021-11-29T15:28:34.000Z | 0x5f0dcf3aaa6f42ccd4772f8401254992a1ee31b27de2701766f8999eb442e2a2 |
| 0x458368b3724b5a1c1057a00b28eb03feb5b64968 | 0x395a9cf7d1a11806d08f090ab07125eb65c49ace | false | 5 | 23470965 | 2021-11-29T11:29:05.000Z | 0x4badd53b52f88b78915981d4cda24ea7b60d1b4889c1d04ef407aa2ba3b44a36 |
| 0x458368b3724b5a1c1057a00b28eb03feb5b64968 | 0x7c947d335df2e9da65e0a1f8e6bbeaa3ff0a373d | false | 5 | 23481507 | 2021-11-29T14:05:59.000Z | 0xace464743e2807079110b54f80114fe897fc675fb2dc35f56b9cc31a73622b9d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.LiquidityBootstrappingPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MasterChef\_Harvest\_event
Reward harvest events from Beethoven X (Balancer V2 fork) MasterChef staking contracts on Fantom, tracking when users claim earned tokens from liquidity mining pools. Contains harvested amounts per pool ID (pid) for analyzing farming incentive distributions and yield claiming behavior.
| 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_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pid` | `STRING` | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| in\_pid | address | in\_user | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 1 | 0x8166994d9ebbe5829ec86bd81258149b87facfd3 | 0x710e1ca587ff2a8a87d3e12dfafd379aae2ae811 | false | 0 | 15 | 65201815 | 2023-07-06T07:18:40.000Z | 0x42aaf9c254a4c0fe090b86c2d5c9b6973d50ccfbda28af88cb4ecb764cd0850b |
| 1 | 0x8166994d9ebbe5829ec86bd81258149b87facfd3 | 0xeb9e60c00992df72bf1daef801b895ac5365fa0d | false | 1811416604543792786 | 13 | 65193384 | 2023-07-06T03:26:38.000Z | 0x4f86ea99b0fabe3f916e412d0ce5f0cbf250d3ff1cb7b4be31e76a49c34be0ca |
| 8 | 0x8166994d9ebbe5829ec86bd81258149b87facfd3 | 0x710e1ca587ff2a8a87d3e12dfafd379aae2ae811 | false | 0 | 32 | 65201815 | 2023-07-06T07:18:40.000Z | 0x42aaf9c254a4c0fe090b86c2d5c9b6973d50ccfbda28af88cb4ecb764cd0850b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.MasterChef_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### MetaStablePoolFactory\_PoolCreated\_event
Event logs emitted when a new MetaStable pool is deployed through Balancer V2's MetaStable pool factory contract. MetaStable pools are designed for assets with known exchange rates that fluctuate within a narrow band, such as wrapped or derivative tokens.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x70b55af71b29c5ca7e67bd1995250364c4be5554 | 0x0c3ee26045fdf5d5e358a85c112cb913fafa502e | false | 26 | 25680552 | 2021-12-22T06:22:41.000Z | 0xa5521498da9d0bbc0c8c99609094a4ceb6575e12daa47f6b21161cf527ddf5e2 |
| 0x70b55af71b29c5ca7e67bd1995250364c4be5554 | 0x8fda1835d346cf3d22c01742d2edbb0831402a3a | false | 45 | 57997948 | 2023-03-20T18:00:52.000Z | 0x648da1b037d215f3db687ede9e405b1962766d9f72c7159ac988837d6415fa94 |
| 0x70b55af71b29c5ca7e67bd1995250364c4be5554 | 0xb95dff01e367b2eef1d8407985c1cdd0c4ba7e4a | false | 40 | 60682649 | 2023-04-24T15:30:43.000Z | 0x214c84b4209c00e6c54c8019e0671931df914000560d2beb43236938085208c2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.MetaStablePoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_SwapFeePercentageChanged\_event
Event logs recording swap fee percentage updates for Balancer V2 and Beethoven X liquidity pools. Emitted when pool administrators modify the fee rate charged on token swaps, stored as a wei-denominated percentage where 1e18 equals 100%.
| 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%. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_swapFeePercentage |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | --------------------- |
| 0x9f95ae778d14dfcee1decbd848350703c161f9c9 | false | 16 | 57309541 | 2023-03-10T10:24:04.000Z | 0xeda8d2f02c4a8539298804e4d6a406c2e335e7b9ef8d270f3c8b02f28faa067e | 30000000000000000 |
| 0x1e43d3d3e1ebe8425b7e295eb85765b5d10a1016 | false | 0 | 57283531 | 2023-03-10T01:15:20.000Z | 0x39631b5de70dcd63949db3df7ea461c201f8c5905cda573c0a12cedafee67fd3 | 10000000000000000 |
| 0x453fae3fcb7323a3360e8413877d0423f1c8b3d9 | false | 0 | 42847221 | 2022-07-15T23:02:33.000Z | 0x005d9225cd11a0570c494de685c936a3b7136e65bc0698e47b8528871e41fef1 | 7500000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Pool_SwapFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Transfer\_event
Liquidity pool token transfer events emitted when LP (Liquidity Provider) tokens are minted, burned, or transferred between addresses. Contains sender, recipient, and token amount for tracking pool share ownership and liquidity position changes.
| 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. |
| in\_to | address | in\_from | removed | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xfe1bfcefa9a9de300a99bcbc36af17ed71637157 | 0x0459a6e0478644a87ee1371ecf944f403ac65522 | 0x0000000000000000000000000000000000000000 | false | 480446771399439412 | 17 | 40696476 | 2022-06-17T05:54:38.000Z | 0xaa5d2033693bef46ad8a8518f4de95eafec823d34540c01bb1ac1a165bf2fa4e |
| 0x8166994d9ebbe5829ec86bd81258149b87facfd3 | 0x0459a6e0478644a87ee1371ecf944f403ac65522 | 0xfe1bfcefa9a9de300a99bcbc36af17ed71637157 | false | 480446771399439412 | 23 | 40696476 | 2022-06-17T05:54:38.000Z | 0xaa5d2033693bef46ad8a8518f4de95eafec823d34540c01bb1ac1a165bf2fa4e |
| 0x0000000000000000000000000000000000000000 | 0x0579b9df6ed258aab3cb58cf95149fe0c25ef8cb | 0x82e38f1a06fd2692ab9275bde75092341b8f187c | false | 933021343681352029451 | 18 | 40700298 | 2022-06-17T07:06:56.000Z | 0xa629f228820315044a88af5e04524d6d370905fd774a838845c0f4dbc2972b2a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Pool_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ProtocolFeesCollector\_FlashLoanFeePercentageChanged\_event
Event logs capturing flash loan fee percentage updates in the Balancer V2 Protocol Fees Collector contract. Records the new fee percentage value whenever protocol governance modifies the flash loan borrowing cost.
| 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_newFlashLoanFeePercentage` | `STRING` | New flash loan fee percentage for the Balancer protocol. String-encoded integer value representing the fee in basis points with 18 decimal places of precision. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newFlashLoanFeePercentage |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ----------------------------- |
| 0xc6920d3a369e7c8bd1a22dbe385e11d1f7af948f | false | 8 | 19651695 | 2021-10-21T05:44:22.000Z | 0x16bfb8641727bb8f87a57ba0766be976d29ec8712bd52a0c124fccfe7026ab56 | 300000000000000 |
| 0xc6920d3a369e7c8bd1a22dbe385e11d1f7af948f | false | 0 | 17719216 | 2021-09-26T09:25:51.000Z | 0x2eca0862f9eafaacdcbcecc3b55cc08de8e031756090d577c3dfb4e6897194ce | 1000000000000000 |
| 0xc6920d3a369e7c8bd1a22dbe385e11d1f7af948f | false | 96 | 17366840 | 2021-09-20T13:54:31.000Z | 0x63856e70c2f52e91cc8ecb3838298d0b8a2e0dc20f11e737fca066d6f550125c | 1000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ProtocolFeesCollector_FlashLoanFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ProtocolFeesCollector\_SwapFeePercentageChanged\_event
Protocol fee percentage update events emitted by Balancer V2 ProtocolFeesCollector contracts. Records changes to the swap fee percentage charged on protocol-level transactions, with the new percentage value stored as a wei-denominated string.
| 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_newSwapFeePercentage` | `STRING` | New swap fee percentage for the protocol. 18-decimal fixed-point integer represented as a string, where 1e18 equals 100%. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newSwapFeePercentage |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 0xc6920d3a369e7c8bd1a22dbe385e11d1f7af948f | false | 45 | 17356710 | 2021-09-20T09:58:35.000Z | 0x2cae7dbc0ef64f4660a8befa5274177b08b66122bfc99f157904ef0c60e87cb3 | 150000000000000000 |
| 0xc6920d3a369e7c8bd1a22dbe385e11d1f7af948f | false | 15 | 40988493 | 2022-06-21T06:05:57.000Z | 0xa39303f24dcf72795e98414a99830484644ccb6c4e570999db758ac7d734b987 | 250000000000000000 |
| 0xc6920d3a369e7c8bd1a22dbe385e11d1f7af948f | false | 91 | 101220920 | 2024-12-27T08:34:23.000Z | 0x83df37d3a270071e322a18ffd04e9a7c9ed11fef38c483ca406deed71afd7bbd | 500000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ProtocolFeesCollector_SwapFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ReaperLinearPoolFactory\_PoolCreated\_event
Pool creation events from Beethoven X's (Balancer V2 fork) Reaper Linear Pool Factory on Fantom. Captures each new linear pool deployment with pool address and creation timestamp for tracking liquidity pool launches.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd448c4156b8de31e56fdfc071c8d96459bb28119 | 0x55e0499d268858a5e804d7864dc2a6b4ef194c63 | false | 6 | 49515964 | 2022-10-19T07:23:22.000Z | 0x6e266032a73b11d10934ea50c32dc77ebdd32c554c131f48167126cb5380055f |
| 0xd448c4156b8de31e56fdfc071c8d96459bb28119 | 0xa9a1f2f7407ce27bcef35d04c47e079e7d6d399e | false | 4 | 49593426 | 2022-10-20T06:37:44.000Z | 0x3e97cd172d6b71e79aa31ae001b5cc00af9a2cce6a55c3934b4a8f96195e297b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ReaperLinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ReaperLinearPoolFactoryV2\_PoolCreated\_event
Pool creation events from Beethoven X's Reaper Linear Pool Factory V2 on Fantom, tracking when new linear pools are deployed with their contract addresses and deployment timestamps.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x80434cf3661313d1a0632f567c1ba389ee2f7665 | 0xb85a3fc39993b2e7e6874b8700b436c212a00516 | false | 4 | 35349603 | 2022-04-06T03:55:49.000Z | 0xdfa0291a6f881ff37866763eef0099bc729b89279eb5c96aeaa625dcab90b24e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ReaperLinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ReaperLinearPoolFactoryV3\_PoolCreated\_event
Pool creation events from Beethoven X (Balancer V2 fork) ReaperLinearPoolFactoryV3 contract on Fantom. Captures new linear pool deployments with pool addresses and creation timestamps for tracking liquidity pool launches.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xac372c8a6d59c4f22a3b9867d4b677c554302145 | 0x1583817b28251844a826f92016cbbbb5aa783824 | false | 16 | 46920430 | 2022-09-14T08:11:57.000Z | 0x29638669ebe690a06a9c936d935df3774bc863766f325e033945785862ee976a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.ReaperLinearPoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePhantomPoolFactory\_PoolCreated\_event
Pool creation events emitted by Balancer V2 StablePhantomPoolFactory contracts. Records the deployment of stable phantom pools, which are composable stable pools that hold Balancer Pool Tokens (BPTs) alongside regular tokens.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0e2afa0b5f9174750d4e84bf9798f89b79bd5bf4 | 0xdfc65c1f15ad3507754ef0fd4ba67060c108db7e | false | 21 | 35818261 | 2022-04-11T19:36:39.000Z | 0xfc3c415dd67da885e39ce3250a0565e7c6812ee9721360b4b3048c9ddf1eea14 |
| 0x0e2afa0b5f9174750d4e84bf9798f89b79bd5bf4 | 0x1352fd97a1828093bf375f62e088bc196facd1ee | false | 17 | 35808426 | 2022-04-11T16:43:38.000Z | 0x680d5e606897ad434a3fa1e26c6043e65cfec527c8cd0e5e10a4ecd6eba3c15b |
| 0x0e2afa0b5f9174750d4e84bf9798f89b79bd5bf4 | 0xecc53ac812123d471360ea3d90023318868b56a5 | false | 20 | 36722751 | 2022-04-22T19:27:33.000Z | 0x499fbd227dbbf64c18dacfd8ae9cad5826d7fe5f53ad7f9dfdfe2ed5f4c634a1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.StablePhantomPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StablePoolFactory\_PoolCreated\_event
Pool creation events emitted by StablePoolFactory contracts on decentralized exchange (DEX) platforms. Records the deployment of new stable swap pools with their contract addresses and constituent token pairs for tracking liquidity pool initialization.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x55df810876354fc3e249f701dd78dede57991f8d | 0x8fe1a318e67bc203180adf68007613546e8af393 | false | 23 | 20214946 | 2021-10-27T02:46:16.000Z | 0xe09cee765375975715f9bda1bab334f551b7ff9bdf4be06998d9435e9b20662d |
| 0x55df810876354fc3e249f701dd78dede57991f8d | 0xf3f0970bca8ce7e9672d17a301b54d1485d93807 | false | 8 | 23778357 | 2021-12-02T13:31:06.000Z | 0xc1be1fb2a34361d137e170ff2a3cdafc07c16f63fd684ce9f06e916257b34852 |
| 0x55df810876354fc3e249f701dd78dede57991f8d | 0xd163415bd34ef06f57c58d2aed5a5478afb464cc | false | 36 | 18254881 | 2021-10-04T02:38:43.000Z | 0x43cf60e88bc97ad5f041f24c65c11cd00db50ad8efcab70149931c704caef812 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.StablePoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TarotLinearPoolFactory\_PoolCreated\_event
Pool creation events from Beethoven X's Tarot Linear Pool Factory contract on Fantom. Tracks when new Tarot lending pools are added to or removed from the protocol with pool addresses and factory contract details.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x681b59c9cbbb6ab43ee3360ac6c34e1dd2f147e9 | 0x49769fe4c796b2775d2e44982cca8cdae36f6671 | false | 4 | 36716890 | 2022-04-22T17:48:16.000Z | 0xd7b0e3f42052e51fa5509738d57903971b80ea6ad8e811b329233cdbfa5147c1 |
| 0x681b59c9cbbb6ab43ee3360ac6c34e1dd2f147e9 | 0x230112fa4b07234769fc92bd616c8c77f4fe0e53 | false | 4 | 36723127 | 2022-04-22T19:34:18.000Z | 0x3c106fd58bc4930eb30c1e87d45300cf3067ea3b1c6dc38e526c35a7dd8e946f |
| 0x681b59c9cbbb6ab43ee3360ac6c34e1dd2f147e9 | 0xb4aae62a3f10717b9c649ed5ce099d981e5dca8c | false | 8 | 36741981 | 2022-04-23T01:16:24.000Z | 0xac6ec41c412fff6a9c122cc9ad4a911d7d5342ba72a902a0428d97a62d338ed6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.TarotLinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_FlashLoan\_event
Flash loan events emitted by decentralized exchange (DEX) vault contracts, recording uncollateralized borrows of tokens with borrowed amount, fee charged, and recipient address. Used for arbitrage tracking and flash loan analytics across Balancer V2, Beethoven X, BEX, and SyncSwap protocols.
| 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_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_feeAmount` | `STRING` | Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination. |
| address | removed | in\_token | in\_amount | log\_index | block\_number | in\_feeAmount | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 3082668573 | 15 | 38029201 | 924801 | 0x5e00104a8050ae73e6987b0056537cc239666755 | 2022-05-11T07:33:02.000Z | 0x8dabb1a497a560b93a17c0882c30dd1c350b93ad8803d7e30634a4bf2642e8f9 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 4781355373 | 25 | 38045692 | 1434407 | 0x5e00104a8050ae73e6987b0056537cc239666755 | 2022-05-11T14:33:14.000Z | 0x243af8b1ef73013581a9487d157a17158980b1debda980eae5360428a14f6f42 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 6000529488 | 16 | 38062836 | 1800159 | 0x5e00104a8050ae73e6987b0056537cc239666755 | 2022-05-11T21:47:44.000Z | 0x7a35fda4d3df934882c63516262dbad551e2ef72a3fb1ff2685cfc314253b690 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_PoolBalanceChanged\_event
Balancer V2 Vault event emitted when liquidity provider positions change in a pool, recording token balance deltas and protocol fees. Contains pool identifier, liquidity provider address, token addresses, and per-token balance changes for tracking deposits, withdrawals, and pool composition updates.
| 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_poolId` | `STRING` | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix. |
| `in_liquidityProvider` | `STRING` | Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_deltas` | `ARRAY` | Array of token balance changes for each token in the pool. String-encoded signed integers representing the change in token amounts, with positive values indicating deposits and negative values indicating withdrawals. |
| `in_protocolFeeAmounts` | `ARRAY` | Array of protocol fee amounts collected for each token in the pool. String-encoded unsigned integers corresponding positionally to tokens in the pool, representing fees taken by the protocol on the transaction. |
| address | removed | in\_deltas | in\_poolId | in\_tokens | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_liquidityProvider | in\_protocolFeeAmounts |
| ------------------------------------------ | ------- | ------------------------------------ | ------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ----------------------- |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | \["0","8951638332440115","0","0"] | 0xf3a602d30dcb723a74a0198313a7551feaca7dac00010000000000000000005f | \["0x04068da6c83afcfa0e13ba15a6696662335d5b75","0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83","0x321162cd933e2be498cd2267a90534a804051b11","0x74b23882a30290451a17c44f4f05243b6b58c76d"] | 128 | 47006196 | 2022-09-15T20:24:31.000Z | 0x2049732248b9970bcac3d917bb7ac310182d35122ef973b9a4680dc96b92c01c | 0x00f23196ea5a1a94d24a56402dc12e043a0a0cc0 | \["0","0","0","0"] |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | \["0","1844744644321865178","0","0"] | 0xf3a602d30dcb723a74a0198313a7551feaca7dac00010000000000000000005f | \["0x04068da6c83afcfa0e13ba15a6696662335d5b75","0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83","0x321162cd933e2be498cd2267a90534a804051b11","0x74b23882a30290451a17c44f4f05243b6b58c76d"] | 168 | 47012273 | 2022-09-15T22:40:20.000Z | 0xc68116e949d905e18088d6ae1a652b0b9e176f3fc3697d1075eab035b80e66a7 | 0x00f23196ea5a1a94d24a56402dc12e043a0a0cc0 | \["721526","0","0","0"] |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | \["0","1812562405677145061","0","0"] | 0xf3a602d30dcb723a74a0198313a7551feaca7dac00010000000000000000005f | \["0x04068da6c83afcfa0e13ba15a6696662335d5b75","0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83","0x321162cd933e2be498cd2267a90534a804051b11","0x74b23882a30290451a17c44f4f05243b6b58c76d"] | 132 | 47010163 | 2022-09-15T21:43:07.000Z | 0x03386ea9f595195d2e57422f808a9ad0a00e9dd9bf294178558d8003575e6a08 | 0x00f23196ea5a1a94d24a56402dc12e043a0a0cc0 | \["0","0","0","0"] |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_PoolBalanceChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_PoolBalanceManaged\_event
Balancer V2 Vault event emitted when an asset manager adjusts the allocation of a pool's token balance between liquid cash reserves and managed external positions. Records changes in cash and managed amounts for pool rebalancing operations.
| 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_poolId` | `STRING` | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix. |
| `in_assetManager` | `STRING` | Contract address of the asset manager responsible for managing pool token balances. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_cashDelta` | `STRING` | Change in token balance available to the pool's vault for immediate operations. String-encoded signed integer representing token units. |
| `in_managedDelta` | `STRING` | Change in token balance managed by the asset manager outside the vault's immediate liquidity pool. String-encoded signed integer representing token units. |
| address | removed | in\_token | in\_poolId | log\_index | block\_number | in\_cashDelta | block\_timestamp | in\_assetManager | in\_managedDelta | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------------------------------ | ---------- | ------------- | ------------------------- | ------------------------ | ------------------------------------------ | ------------------------- | ------------------------------------------------------------------ |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e | 0x685056d3a4e574b163d0fa05a78f1b0b3aa04a8000000000000000000000071a | 27 | 64170652 | 113766944255165936076367 | 2023-06-15T18:17:36.000Z | 0x8553fdc738521b0408c22897f6ceeed7f753a2c9 | -113766944255165936076367 | 0x4d64956f48357a5b14c15b4a424e4619ec4703026f73d99a279eafd23b453cc2 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x16e4399fa9ba6e58f12bf2d2bc35f8bde8a9a4ab | 0x685056d3a4e574b163d0fa05a78f1b0b3aa04a8000000000000000000000071a | 10 | 64170652 | -113317200008057326511693 | 2023-06-15T18:17:36.000Z | 0x8553fdc738521b0408c22897f6ceeed7f753a2c9 | 113317200008057326511693 | 0x4d64956f48357a5b14c15b4a424e4619ec4703026f73d99a279eafd23b453cc2 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e | 0x685056d3a4e574b163d0fa05a78f1b0b3aa04a8000000000000000000000071a | 24 | 64170652 | 0 | 2023-06-15T18:17:36.000Z | 0x8553fdc738521b0408c22897f6ceeed7f753a2c9 | 113766944255165936076367 | 0x4d64956f48357a5b14c15b4a424e4619ec4703026f73d99a279eafd23b453cc2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_PoolBalanceManaged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_PoolRegistered\_event
Event logs recording new liquidity pool registrations in Balancer vault contracts. Contains pool address, unique pool identifier, factory address, token configurations with rate providers, hook configurations for custom pool logic, liquidity management settings, role assignments for governance, and initial swap fee parameters.
| 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_poolId` | `STRING` | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix. |
| `in_poolAddress` | `STRING` | Contract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_specialization` | `INT64` | Pool specialization type indicator in Balancer V2 Vault architecture. Integer value encoding the pool's internal asset management strategy (0=General, 1=Minimal Swap Info, 2=Two Token). |
| address | removed | in\_poolId | log\_index | block\_number | in\_poolAddress | block\_timestamp | transaction\_hash | in\_specialization |
| ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x971c4a721cf9d41adab780822177db4c505fc048000100000000000000000092 | 1 | 21950749 | 0x971c4a721cf9d41adab780822177db4c505fc048 | 2021-11-13T18:01:46.000Z | 0xc8bbb18aa8ba2c9e6eecd75c3b75cdd5bbaedc9e21d77c85b13062c57be752f1 | 1 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x4ba8790a9f46d2bfc2340866bc85449fed2e3680000100000000000000000093 | 1 | 21952474 | 0x4ba8790a9f46d2bfc2340866bc85449fed2e3680 | 2021-11-13T18:25:27.000Z | 0xf6b5aee8a37882a7b9be3ad59441af22227fdb32e216da224d4f5871eb733985 | 1 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0xdee35a4192f4b4d7f9ca44e3aafb44731b460125000100000000000000000090 | 1 | 21883737 | 0xdee35a4192f4b4d7f9ca44e3aafb44731b460125 | 2021-11-13T01:09:52.000Z | 0x897ca6fdb5a3e4dfed75367e7f37c81315a9b4020d46a95476b180044db26feb | 1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_PoolRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_Swap\_event
Swap events emitted by decentralized exchange vault contracts containing input/output token addresses, amounts, pool identifiers, and swap fee data. Tracks token exchanges executed through vault-based automated market maker protocols.
| 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_poolId` | `STRING` | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix. |
| `in_tokenIn` | `STRING` | Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenOut` | `STRING` | Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountIn` | `STRING` | Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination. |
| `in_amountOut` | `STRING` | Amount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination. |
| address | removed | in\_poolId | log\_index | in\_tokenIn | in\_amountIn | in\_tokenOut | block\_number | in\_amountOut | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------------------------------ | ---------- | ------------------------------------------ | ----------------------- | ------------------------------------------ | ------------- | ---------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x21bbfc5681d9e171677dbd1a85a9ab15df82ad86000100000000000000000708 | 1 | 0x02838746d9e1413e07ee064fcbada57055417f21 | 458810760844659570933 | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 61630095 | 49879165213609276263 | 2023-05-06T17:53:13.000Z | 0x63da0745b5212a3ffe08b0655973015c1edd3aaa6342ce6636e39fbd3c6a860b |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x21bbfc5681d9e171677dbd1a85a9ab15df82ad86000100000000000000000708 | 15 | 0x02838746d9e1413e07ee064fcbada57055417f21 | 25411477995526860772077 | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 61585113 | 1195594033 | 2023-05-06T04:45:00.000Z | 0xc772cc9a0cd2d0a2219b4138d15824076b763c10e1e589b5687967d40082bd32 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x21bbfc5681d9e171677dbd1a85a9ab15df82ad86000100000000000000000708 | 3 | 0x02838746d9e1413e07ee064fcbada57055417f21 | 40819265943531077235006 | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 61595323 | 4361625302849035939659 | 2023-05-06T08:39:12.000Z | 0xb64371cda9cd05f5bddc931d6c87aa4644412e83eb9e5a76ad2c55278e20aecc |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_TokensDeregistered\_event
Balancer V2 Vault event recording the removal of tokens from a liquidity pool's registered token list. Emitted when pool composition changes through token deregistration, containing the pool identifier and array of deregistered token addresses.
| 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_poolId` | `STRING` | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix. |
| `in_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_TokensDeregistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Vault\_TokensRegistered\_event
Event logs recording token registration within Balancer V2 vault pools. Contains pool identifier, array of registered token addresses, and corresponding asset manager addresses for tracking pool composition initialization.
| 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_poolId` | `STRING` | Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix. |
| `in_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_assetManagers` | `ARRAY` | Array of asset manager contract addresses for each token in the pool. Hex-encoded, 0x-prefixed, 42-character strings corresponding to each token in in\_tokens array. |
| address | removed | in\_poolId | in\_tokens | log\_index | block\_number | block\_timestamp | in\_assetManagers | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------- | ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0x41870439b607a29293d48f7c9da10e67142176240001000000000000000000a4 | \["0x04068da6c83afcfa0e13ba15a6696662335d5b75","0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83","0x44f7237df00e386af8e79b817d05ed9f6fe0f296"] | 2 | 22822058 | 2021-11-22T17:58:51.000Z | \["0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0x466fa547b78d46808dac352a2e233e62aae482fcdf6b9197e36f278c76535741 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0xb4aae62a3f10717b9c649ed5ce099d981e5dca8c00000000000000000000042b | \["0x74d1d2a851e339b8cb953716445be7e8abdf92f4","0xb4aae62a3f10717b9c649ed5ce099d981e5dca8c","0xc5e2b037d30a390e62180970b3aa4e91868764cd"] | 6 | 36741981 | 2022-04-23T01:16:24.000Z | \["0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0xac6ec41c412fff6a9c122cc9ad4a911d7d5342ba72a902a0428d97a62d338ed6 |
| 0x20dd72ed959b6147912c2e529f0a0c651c33c9ce | false | 0xc0064b291bd3d4ba0e44ccfc81bf8e7f7a579cd200000000000000000000042c | \["0xc0064b291bd3d4ba0e44ccfc81bf8e7f7a579cd2","0xc3bf643799237588b7a6b407b3fc028dd4e037d2","0xd7028092c830b5c8fce061af2e593413ebbc1fc1"] | 67 | 36795116 | 2022-04-23T17:19:47.000Z | \["0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000","0x0000000000000000000000000000000000000000"] | 0xd7e369ad298c0627a89fbf9ad9c1ce8b3e5ac0cc51e0a533e85d5f3f9d6a78c0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.Vault_TokensRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### WeightedPool2TokensFactory\_PoolCreated\_event
PoolCreated event logs emitted by the WeightedPool2TokensFactory contract when new two-token weighted pools are deployed on Balancer V2. Records factory contract address and newly created pool address for tracking pool deployments across DEX infrastructure.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x92b377187bccc6556fced2f1e6dad65850c20630 | 0xea0406e924765a78c08de89412a3bd769111eacf | false | 4 | 38914876 | 2022-05-24T00:07:30.000Z | 0x12e53bbc1922f5f509a3a6d30efe9c05eae979bfeb09b45cf74d4b25e184b64d |
| 0x92b377187bccc6556fced2f1e6dad65850c20630 | 0xc2d10578163bc27b98d0e8f004656e3c91c59d2e | false | 99 | 35103290 | 2022-04-03T05:28:05.000Z | 0x69928bffc181dce4f498e46068168cf34272f3a207f73049160d5d80692b9fe6 |
| 0x92b377187bccc6556fced2f1e6dad65850c20630 | 0x38e0b2b7d6915ce138b5acf454e0f4784a92f308 | false | 22 | 35103082 | 2022-04-03T05:24:45.000Z | 0x15a56d361c3e3e809f1a6a7fd650cf18d47a38af66a3e1e00facc9bb49815889 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.WeightedPool2TokensFactory_PoolCreated_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.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x60467cb225092ce0c989361934311175f437cf53 | 0x7865a5e9e8073cd4354673fa737036ea1cba5144 | false | 28 | 29558285 | 2022-01-31T07:06:20.000Z | 0xceee2abdb447944000f718c94135b154ded33ab570c3d6f547abc461fa783435 |
| 0x60467cb225092ce0c989361934311175f437cf53 | 0xb7ea6f4ee77e66c64d850d5e64d21dc82fdb0131 | false | 3 | 29529867 | 2022-01-31T00:19:17.000Z | 0x2499baa049e8b4e411785f722fb4cb50caa4430a1e0afe3701e19d4b93b12f09 |
| 0x60467cb225092ce0c989361934311175f437cf53 | 0xa1c5698a042638b6220e336ed9cfafb499560c20 | false | 3 | 29627218 | 2022-01-31T23:30:23.000Z | 0xc9e2fd7a454005b58af369dfa3c474ed8eba4ebea4053f8c4872210f3840e4a8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.WeightedPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### WeightedPoolFactoryV2\_PoolCreated\_event
Event logs emitted when new weighted liquidity pools are created by Balancer V2 WeightedPoolFactory contracts. Records the factory contract address and newly deployed pool address for tracking pool deployments across Balancer-based decentralized exchanges.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb841df73861e65e6d61a80f503f095a91ce75e15 | 0x8264a29a6386828f24ebf06b1b2dffeeffcf6295 | false | 6 | 65609742 | 2023-07-11T18:18:19.000Z | 0x918ffd831340fd4b7925a3fa786cdb34f41672e1571a8b7c4276742f453f7500 |
| 0xb841df73861e65e6d61a80f503f095a91ce75e15 | 0x607319a87618bbc52a3afaef45febeb67888c62d | false | 6 | 70151718 | 2023-11-03T17:39:11.000Z | 0x26a3fafcdfcddef12d24ef24af9cafaf1c1a38e0c1c50f2171f68f2bc5511574 |
| 0xb841df73861e65e6d61a80f503f095a91ce75e15 | 0xc3b27e9d74e8076f5566a1b33413b0db7df77b4b | false | 159 | 70138882 | 2023-11-03T09:51:03.000Z | 0xc08ea70efe5d32ee13051a8893f3dc3d763a2621dbd02b69b0af3bcaa12b835c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.WeightedPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### WeightedPoolFactoryV3\_PoolCreated\_event
Pool creation events emitted by Balancer V2 WeightedPoolFactory V3 contracts. Records the address of newly deployed weighted liquidity pools from the factory contract.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd678b6acd834cc969bb19ce82727f2a541fb7941 | 0x9f88483b389d66c5c9e72f93f81b4d8bcf9b4b11 | false | 16 | 56789001 | 2023-03-02T11:38:38.000Z | 0x2c6ab3ef15499bc02778fc1929de286fcf63364e734850ba2d5b35a75ccccb32 |
| 0xd678b6acd834cc969bb19ce82727f2a541fb7941 | 0x64af567094787a485031b4fcf6ad9a5e606b80a1 | false | 38 | 55681561 | 2023-02-13T06:37:29.000Z | 0x468b94deb4872343e4063414816ab7495a7af7d45936bceec68cc031aa09a698 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.WeightedPoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### WeightedPoolFactoryV4\_PoolCreated\_event
Event logs emitted by Balancer V2 WeightedPoolFactory version 4 contracts when new weighted pools are deployed. Records the deployed pool address and factory contract address for tracking pool creation across Balancer protocol instances.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb2ed595afc445b47db7043bec25e772bf0fa1fbb | 0x9e4341acef4147196e99d648c5e43b3fc9d02678 | false | 13 | 51938780 | 2022-12-06T01:44:36.000Z | 0x29d2587c8af3a6a007808da92be2bb7f165da9329c6f69cb1f3509a2c4335e42 |
| 0xb2ed595afc445b47db7043bec25e772bf0fa1fbb | 0x9a8f6d18c55f2f117170390c74e6720077788900 | false | 9 | 50594683 | 2022-11-08T01:55:46.000Z | 0x1b0bd792e7da43ee3b27f34d9cc141b98e23aecb929aac18e00e5f1f3b919e53 |
| 0xb2ed595afc445b47db7043bec25e772bf0fa1fbb | 0x56ad84b777ff732de69e85813daee1393a9ffe10 | false | 176 | 53977576 | 2023-01-18T09:45:02.000Z | 0xd1fd5439e2acb47591240bf5022120574882e38a4c2c66d71557cea16de45f59 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.WeightedPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1f73ae6ed391a2b1e84ff988a1bb5394b78a4a71 | 0xc3bf643799237588b7a6b407b3fc028dd4e037d2 | false | 10 | 31158645 | 2022-02-16T18:03:53.000Z | 0xd36bba2284708df0a2446980ac6e6b78d90ee02d3b3437931b753caa8209086a |
| 0x1f73ae6ed391a2b1e84ff988a1bb5394b78a4a71 | 0x3b998ba87b11a1c5bc1770de9793b17a0da61561 | false | 8 | 28893627 | 2022-01-24T07:59:53.000Z | 0xc8d56da1b448458c939268379cd8dc99cdcd30124eaa47f942be81117abdd5de |
| 0x1f73ae6ed391a2b1e84ff988a1bb5394b78a4a71 | 0x2ff1552dd09f87d6774229ee5eca60cf570ae291 | false | 85 | 28894028 | 2022-01-24T08:05:13.000Z | 0xe238a33dcd0ab2b9a9ce38d9d68fa9c71e578e15f9082417e7fca019cb3efb8a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.YearnLinearPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### YearnLinearPoolFactoryV2\_PoolCreated\_event
Balancer V2 event logs emitted when a Yearn Linear Pool is created by the YearnLinearPoolFactoryV2 contract, recording the factory address and newly created pool address. Used to track the deployment of Yearn-integrated linear pools across Balancer V2 implementations.
| 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. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe6332a48be7496489561ab4cfab71407b1ac8ca4 | 0x8e58191cb73b283af2d7a8ef3f9ce1544db2b828 | false | 12 | 52026002 | 2022-12-08T10:01:51.000Z | 0x8e5b0495156a5ac586fb0ad7c64ddd2f4092c6739377061eeec0c3cc2a4c2414 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.beethoven_v1_fantom.YearnLinearPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***