beethoven_v2_sonic

Tables

Vault_AuthorizerChanged_event

Balancer Vault authorizer change events emitted when the protocol’s permission controller contract address is updated. Records the new authorizer contract address responsible for managing access control to vault functions.

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_newAuthorizer`	`STRING`	Address of the new authorizer contract set for the Balancer vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Vault_LiquidityAdded_event

Liquidity deposit events emitted by Balancer V3 vault contracts recording token amounts added to pools, associated fees, and resulting pool token supply. Used for tracking liquidity provision activity and calculating pool composition 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
`in_amountsAddedRaw`	`ARRAY<STRING>`	Array of token amounts added to the pool during the liquidity addition operation. Numeric string representation of quantities in smallest denomination, ordered to match the pool’s token array.
`in_swapFeeAmountsRaw`	`ARRAY<STRING>`	Array of swap fee amounts charged on the liquidity operation for each token in the pool. Numeric string representation of fee quantities in smallest denomination, ordered to match the pool’s token array.

Sample Data

address	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsAddedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x3d71ad2852676f8a3644a37a2932e678c0b80cf3	false	25	39214053	94412892131257776316593	2025-07-19T10:13:29.000Z	0x7452766d124cdd34734e5894cae074029038de07bec1eedf9df8a7da9b48864d	[“147245082260136137782”,“96065653443372479186194263”]	0xf4a3adf696838d8f8035cdb4fcfa9403e3a16863	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x3d71ad2852676f8a3644a37a2932e678c0b80cf3	false	4	39264582	94553311105457339240706	2025-07-19T18:45:54.000Z	0x14c8c7f0c350a91c172a55d2d981d04895e2b8e14e58e6d5aff01d2c6d858d83	[“69281891852738955698”,“45229922946321504319977770”]	0x9bebfb7057bc361cf2807e48e2284924ce0cacbe	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x3d71ad2852676f8a3644a37a2932e678c0b80cf3	false	11	39190298	82486703479391253596378	2025-07-19T05:41:41.000Z	0x19596de68efdb7d759279779d3e2c3f563a073a7e8c80c9fddbe6c2a036bf08f	[“5331426413424135770650”,“3417157373905445063529153491”]	0xfd184b39cd9152a09c1c895cafd7efcd93dbbad1	[“0”,“0”]

Example Query

Query with partition filter

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

Vault_LiquidityRemoved_event

Balancer V3 Vault liquidity removal events recording withdrawal transactions from liquidity pools. Contains provider address, pool address, withdrawn token amounts in smallest denomination, swap fees charged, and updated pool token supply after withdrawal.

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_liquidityProvider`	`STRING`	Address of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_kind`	`INT64`	Swap operation type indicator for Balancer V2/V3 batch swaps and liquidity operations. Integer value where 0 represents GIVEN_IN (exact input amount specified) and 1 represents GIVEN_OUT (exact output amount specified).
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.
`in_amountsRemovedRaw`	`ARRAY<STRING>`	Array of token amounts withdrawn from the pool during the liquidity removal operation. Numeric string representation of quantities in smallest denomination, ordered to match the pool’s token array.
`in_swapFeeAmountsRaw`	`ARRAY<STRING>`	Array of swap fee amounts charged on the liquidity operation for each token in the pool. Numeric string representation of fee quantities in smallest denomination, ordered to match the pool’s token array.

Sample Data

address	in_pool	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash	in_amountsRemovedRaw	in_liquidityProvider	in_swapFeeAmountsRaw
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x3b57c58440ebb220d4d11db087d884a387259cf0	false	6	37082960	8902599869613756566264	2025-07-04T04:36:44.000Z	0x6851c27665d2962f880263b82ae8fce41c5778856d4dd3ec0164dfb45870bdc1	[“6426146860478”,“7205789146597392518375132”]	0x7fb1041931a8ca61a7607feb1500265bbd8f0434	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x43026d483f42fb35efe03c20b251142d022783f2	false	6	37163475	450072237568829606708377	2025-07-04T18:38:38.000Z	0x79202a9f8d305394e2144616b1ea56a67236236ac9e359177d4e17827194db76	[“2223475088”,“3604842138”]	0xb444776908ff797e69d516caa5cc22856781b0a9	[“0”,“0”]
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x43026d483f42fb35efe03c20b251142d022783f2	false	6	37070249	456899975143744893105362	2025-07-04T01:49:27.000Z	0xfe4111a76275612ac0d91cecd199971ce810ce91b5dbb38fa0ecfe7b0c38f15c	[“4141123697”,“5919449789”]	0x18a3a9ad1b6873f5cd104293d46fb6f81d8794f4	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v2_sonic.Vault_LiquidityRemoved_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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_factory`	`STRING`	Contract address of the factory that deployed or created the associated resource. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenConfig`	`ARRAY<STRUCT<token STRING, tokenType INT64, rateProvider STRING, paysYieldFees BOOL>>`	Array of token configuration structs defining properties for each token in the pool. Each struct contains the token contract address (hex-encoded, 0x-prefixed, 42-character string), token type identifier, rate provider address, and boolean flag indicating whether the token pays yield fees.
`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%.
`in_pauseWindowEndTime`	`STRING`	Unix timestamp indicating when the pause window expires for the pool. Numeric string representing seconds since epoch.
`in_roleAccounts`	`STRUCT<pauseManager STRING, swapFeeManager STRING, poolCreator STRING>`	Struct containing account addresses assigned to manage pool operations. The `pauseManager` field specifies the account authorized to pause the pool, `swapFeeManager` controls swap fee adjustments, and `poolCreator` identifies the original pool deployer. Each field contains a contract address (hex-encoded, 0x-prefixed, 42-character string, or zero address if unassigned).
`in_hooksConfig`	`STRUCT<enableHookAdjustedAmounts BOOL, shouldCallBeforeInitialize BOOL, shouldCallAfterInitialize BOOL, shouldCallComputeDynamicSwapFee BOOL, shouldCallBeforeSwap BOOL, shouldCallAfterSwap BOOL, shouldCallBeforeAddLiquidity BOOL, shouldCallAfterAddLiquidity BOOL, shouldCallBeforeRemoveLiquidity BOOL, shouldCallAfterRemoveLiquidity BOOL, hooksContract STRING>`	Configuration struct defining hook contract settings and lifecycle callbacks for pool operations. The `hooksContract` field contains the hook contract address (hex-encoded, 0x-prefixed, 42-character string, or zero address if hooks are disabled), while boolean fields specify which pool lifecycle events trigger hook execution.
`in_liquidityManagement`	`STRUCT<disableUnbalancedLiquidity BOOL, enableAddLiquidityCustom BOOL, enableRemoveLiquidityCustom BOOL, enableDonation BOOL>`	Configuration struct defining liquidity management rules for pool operations. Boolean fields control whether unbalanced liquidity is disabled, custom add/remove liquidity functions are enabled, and direct token donations to the pool are permitted.

Sample Data

address	in_pool	removed	log_index	in_factory	block_number	in_hooksConfig	in_tokenConfig	block_timestamp	in_roleAccounts	transaction_hash	in_swapFeePercentage	in_pauseWindowEndTime	in_liquidityManagement
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4633a4a0bcb9d65e45c79f14be134d7d7b41b3f0	false	4	0xf023731dd8758d7c869af10005e6380cb57775a9	34968585	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“tokenType”:1,“rateProvider”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“paysYieldFees”:true}]	2025-06-20T09:43:50.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x9c38c59e9a5b0140c672529a2487f5859ba4ca06”}	0x1937e18ae9e82d6756e8209651575cbb3d737f7f4b89cd4c4ddaf9b4935e4e23	90000000000000	1866617958	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x10658b1c73c9e91450f4f543a4f338e2cbb0db90	false	4	0xf023731dd8758d7c869af10005e6380cb57775a9	34970237	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“tokenType”:1,“rateProvider”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“paysYieldFees”:true}]	2025-06-20T10:00:44.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0x0000000000000000000000000000000000000000”,“swapFeeManager”:“0x9c38c59e9a5b0140c672529a2487f5859ba4ca06”}	0xb219fe0595c455f162c72d882785566ec4a489d177749b786cde08c840fc5218	90000000000000	1866617958	{“enableDonation”:true,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x6a684174cec570f622f9b77fbdc56e9cd83860ae	false	4	0xf023731dd8758d7c869af10005e6380cb57775a9	34968305	{“hooksContract”:“0x0000000000000000000000000000000000000000”,“shouldCallAfterSwap”:false,“shouldCallBeforeSwap”:false,“enableHookAdjustedAmounts”:false,“shouldCallAfterInitialize”:false,“shouldCallBeforeInitialize”:false,“shouldCallAfterAddLiquidity”:false,“shouldCallBeforeAddLiquidity”:false,“shouldCallAfterRemoveLiquidity”:false,“shouldCallBeforeRemoveLiquidity”:false,“shouldCallComputeDynamicSwapFee”:false}	[{“token”:“0x3333111a391cc08fa51353e9195526a70b333333”,“tokenType”:0,“rateProvider”:“0x0000000000000000000000000000000000000000”,“paysYieldFees”:false},{“token”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“tokenType”:1,“rateProvider”:“0xe5da20f15420ad15de0fa650600afc998bbe3955”,“paysYieldFees”:true}]	2025-06-20T09:41:13.000Z	{“poolCreator”:“0x0000000000000000000000000000000000000000”,“pauseManager”:“0xcf392f62151fe078a5c26c6fd7e6bc5f15d9735a”,“swapFeeManager”:“0xcf392f62151fe078a5c26c6fd7e6bc5f15d9735a”}	0xb6177036dbb3c111a85f9081e007bd6bddaa2999d219908cf273279880c6cca6	19500000000000000	1866617958	{“enableDonation”:false,“enableAddLiquidityCustom”:false,“disableUnbalancedLiquidity”:false,“enableRemoveLiquidityCustom”:false}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.beethoven_v2_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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`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%.
`in_swapFeeAmount`	`STRING`	Amount of fees charged on the swap transaction. Numeric string representing the fee quantity in the input token’s smallest denomination.

Sample Data

address	in_pool	removed	log_index	in_tokenIn	in_amountIn	in_tokenOut	block_number	in_amountOut	block_timestamp	in_swapFeeAmount	transaction_hash	in_swapFeePercentage
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x944d4ae892de4bfd38742cc8295d6d5164c5593c	false	52	0x016c306e103fbf48ec24810d078c65ad13c5f11b	3517975275536902476121927	0x0c4e186eae8acaa7f7de1315d5ad174be39ec987	45611768	3603146719329907652116	2025-09-03T14:07:37.000Z	3517975275536902477043	0xa49062a7d203f14c6e6a57ee11bdc7ae420f98b8aca84e1df447247c5faf5c30	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x944d4ae892de4bfd38742cc8295d6d5164c5593c	false	10	0x016c306e103fbf48ec24810d078c65ad13c5f11b	800100972874894442425594	0x0c4e186eae8acaa7f7de1315d5ad174be39ec987	45617379	819474425850033394755	2025-09-03T15:00:30.000Z	800100972874894443354	0x5d7fb65577fa2d643ccebe284169f3864af21c61e22dd1d392a066651f4a4edd	1000000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x944d4ae892de4bfd38742cc8295d6d5164c5593c	false	38	0x016c306e103fbf48ec24810d078c65ad13c5f11b	2932316460317840005090	0x0c4e186eae8acaa7f7de1315d5ad174be39ec987	45566085	3002886121004016372	2025-09-03T05:00:38.000Z	2932316460317840412	0x5ce90e4d5df153a4d2d9f8e68ea19c2a4b733fd953e177f9f34fd960c527a875	1000000000000000

Example Query

Query with partition filter

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

Vault_SwapFeePercentageChanged_event

Event logs emitted when a liquidity pool’s swap fee percentage is updated. Records the pool address and new fee rate in wei basis (1e18 = 100%), enabling fee structure tracking across Balancer V3 vault contracts.

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_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	in_pool	removed	log_index	block_number	block_timestamp	transaction_hash	in_swapFeePercentage
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x2905927272e18a047983196472ff3b964c8f7c5c	false	5	45948505	2025-09-06T12:20:39.000Z	0x7bfefdb6eb34cd7cd0b0855f04831079ebb65f0cef814da77937297817ad3bab	500000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x8759fefd6f4e24fe95b3e779739761d0ca71c01d	false	5	28571136	2025-05-21T20:15:43.000Z	0xf29e99b13c7b78c62fa07c82859085a93a068ae53d6c42305c8b26eddc91099b	100000000000000
0xba1333333333a1ba1108e8412f11850a5c319ba9	0x4a774e742d93374870d01532faa53bfdef4de1e6	false	23	28517328	2025-05-21T15:15:46.000Z	0xb368b69682bfe3816a4b29fd8e8ab7b344d186a6bc2a8c86bdd188901d6ca625	100000000000000

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Vault_AuthorizerChanged_event

Vault_LiquidityAdded_event

Vault_LiquidityRemoved_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_SwapFeePercentageChanged_event

​Tables

​Vault_AuthorizerChanged_event

​Vault_LiquidityAdded_event

​Vault_LiquidityRemoved_event

​Vault_PoolRegistered_event

​Vault_Swap_event

​Vault_SwapFeePercentageChanged_event

Tables

Vault_AuthorizerChanged_event

Vault_LiquidityAdded_event

Vault_LiquidityRemoved_event

Vault_PoolRegistered_event

Vault_Swap_event

Vault_SwapFeePercentageChanged_event