beethoven_v1_fantom - Token Terminal Docs

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xba306e3cf84751d8ef5e812c18caa6c567c783e8	0x71959b131426fdb7af01de8d7d4149ccaf09f8cc	false	4	32511287	2022-03-04T07:40:50.000Z	0xc03781c0617125a786a2073fb382bd988d218ff63c20e663ba1b5d7e03cdab72

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x89857161e0ad36f8c5a537733c1fcf7145220aae	0x3ee7a82c1ecf54a375da1e3452b21ac986f348db	false	155	66439063	2023-07-30T05:07:58.000Z	0x0322d045d2a7e811d6ed8773b6a83442cb50e3a0a6e9fdc9fb3bbb9cbac6f64e
0x89857161e0ad36f8c5a537733c1fcf7145220aae	0xa02c23525f12c677156d076268f4b44e12e38e4d	false	9	66438895	2023-07-30T04:59:46.000Z	0xfacc2a200c6062b76557ec0058b2c7a0e932cb8d4a0035de1238477e649377ef
0x89857161e0ad36f8c5a537733c1fcf7145220aae	0xd20547850f3f80204439eafc942ec4780d32f2bd	false	47	55683449	2023-02-13T07:16:49.000Z	0x92b4101408a9fdcad4130ff3deb9c2294222c664ce63a65312727400547513cf

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_protocolId`	`STRING`	Numeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x1f641e8a2a966835f1979c3938654b6a4874eeda	0x441fe62fdc40125aace5e11644cd59ffe7515d66	false	10	66363553	2023-07-27T20:33:17.000Z	0x42fb5c53bd90b5f949378ae6fc9ea6ae9fd72b31faeeaf4590f31eeba9b69966
0x1f641e8a2a966835f1979c3938654b6a4874eeda	0x6ab829877d5ad14667b00b57e6df9d98da0867a3	false	21	66363604	2023-07-27T20:35:24.000Z	0xbe65393b1102c80e13c86b5c2c325cf996013baa530b5b54088a3171d59ddbfd

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x1b2b291f5dca9fc7811fc5998758305faec7977c	0xadab239e677bbc038f5244ac6c7de2d684b0b92c	false	13	63803359	2023-06-09T03:19:01.000Z	0x9ce7abc8bfa54471b8a7a74b4be7fc13d4ee668d42baebcd8af042b4b9f1d139

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_swapFeePercentage`	`STRING`	Swap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newSwapFeePercentage`	`STRING`	New swap fee percentage for the protocol. 18-decimal fixed-point integer represented as a string, where 1e18 equals 100%.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xd448c4156b8de31e56fdfc071c8d96459bb28119	0x55e0499d268858a5e804d7864dc2a6b4ef194c63	false	6	49515964	2022-10-19T07:23:22.000Z	0x6e266032a73b11d10934ea50c32dc77ebdd32c554c131f48167126cb5380055f
0xd448c4156b8de31e56fdfc071c8d96459bb28119	0xa9a1f2f7407ce27bcef35d04c47e079e7d6d399e	false	4	49593426	2022-10-20T06:37:44.000Z	0x3e97cd172d6b71e79aa31ae001b5cc00af9a2cce6a55c3934b4a8f96195e297b

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0x80434cf3661313d1a0632f567c1ba389ee2f7665	0xb85a3fc39993b2e7e6874b8700b436c212a00516	false	4	35349603	2022-04-06T03:55:49.000Z	0xdfa0291a6f881ff37866763eef0099bc729b89279eb5c96aeaa625dcab90b24e

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xac372c8a6d59c4f22a3b9867d4b677c554302145	0x1583817b28251844a826f92016cbbbb5aa783824	false	16	46920430	2022-09-14T08:11:57.000Z	0x29638669ebe690a06a9c936d935df3774bc863766f325e033945785862ee976a

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_deltas`	`ARRAY<STRING>`	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<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_assetManagers`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xd678b6acd834cc969bb19ce82727f2a541fb7941	0x9f88483b389d66c5c9e72f93f81b4d8bcf9b4b11	false	16	56789001	2023-03-02T11:38:38.000Z	0x2c6ab3ef15499bc02778fc1929de286fcf63364e734850ba2d5b35a75ccccb32
0xd678b6acd834cc969bb19ce82727f2a541fb7941	0x64af567094787a485031b4fcf6ad9a5e606b80a1	false	38	55681561	2023-02-13T06:37:29.000Z	0x468b94deb4872343e4063414816ab7495a7af7d45936bceec68cc031aa09a698

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash
0xe6332a48be7496489561ab4cfab71407b1ac8ca4	0x8e58191cb73b283af2d7a8ef3f9ce1544db2b828	false	12	52026002	2022-12-08T10:01:51.000Z	0x8e5b0495156a5ac586fb0ad7c64ddd2f4092c6739377061eeec0c3cc2a4c2414

Example Query

Query with partition filter

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

​Tables

​BooLinearPoolFactory_PoolCreated_event

​ComposableStablePoolFactory_PoolCreated_event

​ComposableStablePoolFactoryV2_PoolCreated_event

​ComposableStablePoolFactoryV3_PoolCreated_event

​ERC4626LinearPoolFactory_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactory_PoolCreated_event

​ERC4626LinearPoolFactoryV2_Erc4626LinearPoolCreated_event

​ERC4626LinearPoolFactoryV2_PoolCreated_event

​ERC4626LinearPoolFactoryV3_PoolCreated_event

​LiquidityBootstrappingPoolFactory_PoolCreated_event

​LiquidityBootstrappingPoolFactoryV2_PoolCreated_event

​MasterChef_Harvest_event

​MetaStablePoolFactory_PoolCreated_event

​Pool_SwapFeePercentageChanged_event

​Pool_Transfer_event

​ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

​ProtocolFeesCollector_SwapFeePercentageChanged_event

​ReaperLinearPoolFactory_PoolCreated_event

​ReaperLinearPoolFactoryV2_PoolCreated_event

​ReaperLinearPoolFactoryV3_PoolCreated_event

​StablePhantomPoolFactory_PoolCreated_event

​StablePoolFactory_PoolCreated_event

​TarotLinearPoolFactory_PoolCreated_event

​Vault_FlashLoan_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_Swap_event

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPool2TokensFactory_PoolCreated_event

​WeightedPoolFactory_PoolCreated_event

​WeightedPoolFactoryV2_PoolCreated_event

​WeightedPoolFactoryV3_PoolCreated_event

​WeightedPoolFactoryV4_PoolCreated_event

​YearnLinearPoolFactory_PoolCreated_event

​YearnLinearPoolFactoryV2_PoolCreated_event

Tables

BooLinearPoolFactory_PoolCreated_event

ComposableStablePoolFactory_PoolCreated_event

ComposableStablePoolFactoryV2_PoolCreated_event

ComposableStablePoolFactoryV3_PoolCreated_event

ERC4626LinearPoolFactory_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactory_PoolCreated_event

ERC4626LinearPoolFactoryV2_Erc4626LinearPoolCreated_event

ERC4626LinearPoolFactoryV2_PoolCreated_event

ERC4626LinearPoolFactoryV3_PoolCreated_event

LiquidityBootstrappingPoolFactory_PoolCreated_event

LiquidityBootstrappingPoolFactoryV2_PoolCreated_event

MasterChef_Harvest_event

MetaStablePoolFactory_PoolCreated_event

Pool_SwapFeePercentageChanged_event

Pool_Transfer_event

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

ProtocolFeesCollector_SwapFeePercentageChanged_event

ReaperLinearPoolFactory_PoolCreated_event

ReaperLinearPoolFactoryV2_PoolCreated_event

ReaperLinearPoolFactoryV3_PoolCreated_event

StablePhantomPoolFactory_PoolCreated_event

StablePoolFactory_PoolCreated_event

TarotLinearPoolFactory_PoolCreated_event

Vault_FlashLoan_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPool2TokensFactory_PoolCreated_event

WeightedPoolFactory_PoolCreated_event

WeightedPoolFactoryV2_PoolCreated_event

WeightedPoolFactoryV3_PoolCreated_event

WeightedPoolFactoryV4_PoolCreated_event

YearnLinearPoolFactory_PoolCreated_event

YearnLinearPoolFactoryV2_PoolCreated_event