beethoven_v1_sonic

Tables

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
0x993767e29726ddb7f5e8a751faf54d4b83f3fc62	0xeca0bc45fc02ab59941bdb0bc3718efe6d3f09b3	false	7	392533	2024-12-14T06:42:11.000Z	0x8b36ba0153af03f84ba3db083d76b4dc8f24247ec864433a4f370239215dd42c
0x993767e29726ddb7f5e8a751faf54d4b83f3fc62	0xcd4d2b142235d5650ffa6a38787ed0b7d7a51c0c	false	7	1587923	2024-12-25T18:55:35.000Z	0x7bcee8f95a5fc0601adff3ca22c9f4edc3108a989e731e1a33900862cc886f58
0x993767e29726ddb7f5e8a751faf54d4b83f3fc62	0xe54dd58a6d4e04687f2034dd4ddab49da55f8aff	false	7	3103315	2025-01-09T10:49:36.000Z	0xaba7dd42b8984e72a53d0d2af5eed626a58b1a8b6f2c52314c406c657e52b713

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.ComposableStablePoolFactory_PoolCreated_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	block_number	block_timestamp	transaction_hash
0xa09bc385421f18d5d5072924f9d3709bb2b76281	0xdec5e7fe67249a101ba90693c2504cc85f7d00d0	0xce88686553686da562ce7cea497ce749da109f9f	false	25462477482924922337172	8430200	2025-02-18T09:26:10.000Z	0xbe2f188a83b4d7387b66cecadf99c3af366614a8ba675a62a85c171e3537c47f
0xa09bc385421f18d5d5072924f9d3709bb2b76281	0xb246d02278834c4c67b5b4db17288d9469e3c347	0xce88686553686da562ce7cea497ce749da109f9f	false	184162423938248820468	8430265	2025-02-18T09:26:40.000Z	0x3a2bfd2b3d84f11d7f599cf53fd67d9e2386cff996d6d2e6e2843279f5498fad
0xa09bc385421f18d5d5072924f9d3709bb2b76281	0x442df4bdcfc5afb11571dad8885ff51a9d15e753	0xce88686553686da562ce7cea497ce749da109f9f	false	345380551383442471	8430327	2025-02-18T09:27:12.000Z	0x17be4b93b997273aa335c2aff139447685379b3d72258b0c369556eaf7d85547

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.Pool_Transfer_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
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	291032196320722571088	32	29147212	87309658896216772	0x455a07a656bb847ac162d1e039b25dacc94a194f	2025-05-24T02:01:23.000Z	0xe1d1cf9bdd9172e88f4a349a2d6033170a90376df03c9098b6e503f67f4d860b
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	3429626869980252340224	14	29311516	1028888060994075703	0x48d6535173ff00979800c81aa8425d4ab4f3f030	2025-05-24T18:35:24.000Z	0x57e9f669f498806b3e7061e435f0d0749c9e634f73cf3da53eb1fd9bcba804e3
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	45863244691707747368960	14	29344323	13758973407512324211	0x48d6535173ff00979800c81aa8425d4ab4f3f030	2025-05-24T22:12:41.000Z	0xdbce1c6ccd8994237d4ff79fa57eb5b421317049917c0c489d972d50aeb0da15

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.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
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“12707968045043525947”]	0xf633a43e5ccf858a27dd1d74a23be15ea5aa28f30002000000000000000000c2	[“0x3419966bc74fa8f951108d15b053bed233974d3d”,“0xe5da20f15420ad15de0fa650600afc998bbe3955”]	3	31373046	2025-06-02T16:39:05.000Z	0x6a06aa4d9014b12dc0719ea2c2bd389875186edf259cb4bd6733d10b91ce398b	0x6a5334e6c9352c1b5735969dd439e41bcf9b4da4	[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“-71527546”,“-398041660079871305843”]	0x25ca5451cd5a50ab1d324b5e64f32c0799661891000200000000000000000018	[“0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae”,“0xe5da20f15420ad15de0fa650600afc998bbe3955”]	4	31360588	2025-06-02T15:29:45.000Z	0x3d4ed6767f84f90f43a9d4ccfe81facbc42aa047e1f8c249ea05018d3def2b63	0x29fd3139f3163677f9b99a81f4c4ffb5db8e1444	[“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8	false	[“0”,“29026582167638217436”]	0x25ca5451cd5a50ab1d324b5e64f32c0799661891000200000000000000000018	[“0xd3dce716f3ef535c5ff8d041c1a41c3bd89b97ae”,“0xe5da20f15420ad15de0fa650600afc998bbe3955”]	4	31427312	2025-06-02T22:00:05.000Z	0x5d0d933d8b9074a7ab39943b5df3b845a005140dbc13442ae780156c43f7b6ba	0x3948a2bb0f33a56bd6e4faa9bf1509c4a8e93af1	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.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
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x6768bcd52ccac972e7fab2b964d9ffbc8d0a10670002000000000000000000a3	1	7672580	0x6768bcd52ccac972e7fab2b964d9ffbc8d0a1067	2025-02-13T09:06:28.000Z	0x30a40d721087f0216316034839e9ea8747ceafbc04e1717d7be50fc306ca287d	2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xfc127dfc32b7739a7cfff7ed19e4c4ab3221953a0002000000000000000000a4	1	7674728	0xfc127dfc32b7739a7cfff7ed19e4c4ab3221953a	2025-02-13T09:25:49.000Z	0x98f681d7cc71f6946df6b9d6825289c333985f353f2c13b16df641a656cc2978	2
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xf960f0552f812010e40c29b041a70f0b440339fa000100000000000000000070	1	2247076	0xf960f0552f812010e40c29b041a70f0b440339fa	2025-01-02T10:36:36.000Z	0x584a8a04ae1e4b2baff7a4b1c2ba4d5ac68be2ec2a7c601dcf6d4ba2ec7423fd	1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.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
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x0054b73c676222ff5285a2ef92e3aa2b846f143800020000000000000000006e	7	0xb2a909b8bcce9b30bbc9d4c748fd897d6ad9c285	266331405571570741277029	0xe5da20f15420ad15de0fa650600afc998bbe3955	4644347	35099364866181208870	2025-01-20T05:53:33.000Z	0x316a5b39aca699ba19238db864895d036c2326f12bd7a84391175618def20371
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x0054b73c676222ff5285a2ef92e3aa2b846f143800020000000000000000006e	2	0xb2a909b8bcce9b30bbc9d4c748fd897d6ad9c285	3850501066299332554324	0xe5da20f15420ad15de0fa650600afc998bbe3955	4654830	505706594300026645	2025-01-20T07:46:52.000Z	0xe1f41dbc2b2b201cab83bd200f13e384c7ba9bc2b99437e75df816302fc83a42
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x0054b73c676222ff5285a2ef92e3aa2b846f143800020000000000000000006e	5	0xb2a909b8bcce9b30bbc9d4c748fd897d6ad9c285	3843341551426665438499	0xe5da20f15420ad15de0fa650600afc998bbe3955	4654830	504716950001790524	2025-01-20T07:46:52.000Z	0xe1f41dbc2b2b201cab83bd200f13e384c7ba9bc2b99437e75df816302fc83a42

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.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_sonic.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
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x139bb6e49e198be3f7c0971ebdbf3fd1c021bd29000200000000000000000094	[“0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38”,“0xe5da20f15420ad15de0fa650600afc998bbe3955”]	2	5236080	2025-01-24T08:37:29.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x8a43a6349dcb13e03d86f16007f1dd78d52c253ecc75dfdcb9238201d0d8a740
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0xe743a7dca1bb056dd89523d6c3ae89533bd30b88000100000000000000000009	[“0x342781fd3d3f73bdb54b2dedd925f2ad81b48590”,“0x93cd403693da40d27188714a872943f717e3c543”,“0xb5a10bd15af95381d830f71e85328f2d1d823de7”,“0xe17be928a08d66156ec242a68c4929b07cf14ccc”,“0xe5da20f15420ad15de0fa650600afc998bbe3955”]	2	585078	2024-12-18T16:32:56.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x07d2b0958f492d3e12a0887921eaeb897cf545cb3ab3dad5cc16a1b28cb0802a
0xba12222222228d8ba445958a75a0704d566bf2c8	false	0x51885d0ffed347115c04cf865c5442134d1c05aa000200000000000000000011	[“0xbe422dd2f451348d5d0979d8ab25b4c6eaad1eb2”,“0xe5da20f15420ad15de0fa650600afc998bbe3955”]	2	621140	2024-12-18T21:30:42.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xf4c0a99b569da67bb7c7d1f143b54cf17709aa71a2defc03bec62f02c6708dec

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v1_sonic.Vault_TokensRegistered_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
0x22f5b7fdd99076f1f20f8118854ce3984544d56d	0x737011d07574e4e2283999be2748b1f7cdc4588c	false	6	19826333	2025-04-12T16:37:58.000Z	0xad47a9941fc52803707f4fa445cf6ad5f292ac962fcd0f18d6fda300fabf7334
0x22f5b7fdd99076f1f20f8118854ce3984544d56d	0xc30c23550fc99aece495df36fed9d0cdc3163c13	false	14	19822436	2025-04-12T16:12:30.000Z	0x9bb9c4ef4603731ad4c270e420ab7732f9ddca30b3a22b72f2b19ebf5b5600a9
0x22f5b7fdd99076f1f20f8118854ce3984544d56d	0x6caaa83e04be0bf2970f6f000cee9c31cfd20be4	false	13	19868123	2025-04-12T21:31:18.000Z	0x605e59c5e3c8f6ed70f5f68eeb8e70427f486a0bc4c75fd6b31e8c634d288dfc

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ComposableStablePoolFactory_PoolCreated_event

Pool_Transfer_event

Vault_FlashLoan_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPoolFactory_PoolCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ComposableStablePoolFactory_PoolCreated_event

​Pool_Transfer_event

​Vault_FlashLoan_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_Swap_event

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPoolFactory_PoolCreated_event

Tables

ComposableStablePoolFactory_PoolCreated_event

Pool_Transfer_event

Vault_FlashLoan_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPoolFactory_PoolCreated_event