bex_v1_berachain

Tables

StablePoolFactory_FactoryDisabled_event

Factory disable events from BEX (Berachain Exchange) V1 stableswap pool factory contract. Tracks when the factory contract is disabled, useful for monitoring protocol governance actions and pool creation availability.

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.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xdfa30bda0375d4763711ab0cc8d91b20bfcc87e1	false	45	12675429	2025-11-05T17:59:34.000Z	0xb72914fa54a641a6f996aaaea137752a19348b78fe6ba47c25c5196d6972598a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.StablePoolFactory_FactoryDisabled_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
0xdfa30bda0375d4763711ab0cc8d91b20bfcc87e1	0x13ee7b7fc58cc8ed1205edb8d56e1b9351a3b57a	false	57	1602184	2025-02-25T20:24:06.000Z	0x5508c75fd47cb8adb2e51a57a42ff06e747bf808b7a3ebd1ece0acf0f3e48359
0xdfa30bda0375d4763711ab0cc8d91b20bfcc87e1	0x0c7fba80e7e54c2245f3105a06c5d4eb01217439	false	126	1579439	2025-02-25T07:37:52.000Z	0xdaa7c802ac28b0c60d44d389344658eb355e07ca32981daf856dcd91182932b2
0xdfa30bda0375d4763711ab0cc8d91b20bfcc87e1	0x2d85e82b6bebcd0e19e79b2500600062bbe27e76	false	7	1602312	2025-02-25T20:28:20.000Z	0x58f12434fea2224599a73818b602da089baec73833576ca1cbb77ab8f97c458e

Example Query

Query with partition filter

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

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.bex_v1_berachain.Vault_AuthorizerChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_ExternalBalanceTransfer_event

External token transfer events emitted by Balancer V2 and BEX vault contracts, capturing sender address, recipient address, token address, and transfer amount. Used for tracking token movements between vault external balances and user accounts.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.Vault_ExternalBalanceTransfer_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
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x6969696969696969696969696969696969696969	200000000000000000	9	5453812	200000000000000000	0xaf3a0f3a6ffdee34255e0e53d8121571fc1311dc	2025-05-24T19:11:44.000Z	0x44cd5eea40500c005b01256616a9624a200fac055d3aa727e4842682569e1e32
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce	1506105930924618752	142	5671223	1506105930924618752	0x59df0bf995d4b739d2cda01cf0b0ac8c6226d7be	2025-05-29T18:24:29.000Z	0x365dfcbee88e1a9ed02e985d698e65a28e1796d7074242b5b6a6beff78e8214d
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce	6672310137007613662	253	5682655	6672310137007613662	0x59df0bf995d4b739d2cda01cf0b0ac8c6226d7be	2025-05-30T00:41:18.000Z	0x0072d082c985651e001c01051e215250e683cf8f02da806a6c0a50e2c0ca8e29

Example Query

Query with partition filter

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

Vault_InternalBalanceChanged_event

Balancer Vault internal balance modification events recording user token deposit and withdrawal changes. Tracks user address, token address, and signed delta values for internal accounting within the Vault 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_user`	`STRING`	Address of the user account associated with the transaction or protocol 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_delta`	`STRING`	Change in token amounts represented as a structured object containing amount0 and amount1 fields. Each amount includes a magnitude value and a boolean sign indicating positive or negative direction.

Sample Data

address	in_user	removed	in_delta	in_token	log_index	block_number	block_timestamp	transaction_hash
0x4be03f781c497a489e3cb0287833452ca9b9e80b	0x2a7f8db344a8af91399548353512a305b754a390	false	915320484556806	0x13ee7b7fc58cc8ed1205edb8d56e1b9351a3b57a	29	2307999	2025-03-14T01:39:38.000Z	0xbd592cc68012b8e2851f0c0ed7c04fd554733baa5145346197ab3f0d6164b8aa
0x4be03f781c497a489e3cb0287833452ca9b9e80b	0x2a7f8db344a8af91399548353512a305b754a390	false	-915320484556806	0x13ee7b7fc58cc8ed1205edb8d56e1b9351a3b57a	32	2307999	2025-03-14T01:39:38.000Z	0xbd592cc68012b8e2851f0c0ed7c04fd554733baa5145346197ab3f0d6164b8aa
0x4be03f781c497a489e3cb0287833452ca9b9e80b	0x2a7f8db344a8af91399548353512a305b754a390	false	-727733147089113	0x13ee7b7fc58cc8ed1205edb8d56e1b9351a3b57a	9	2313550	2025-03-14T04:38:53.000Z	0x90b85a3a51a62138e02e77454a06548f1c17c6a5f7d8b5659ead6603feced984

Example Query

Query with partition filter

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

Vault_PausedStateChanged_event

Event logs recording pause state transitions for Balancer V2 vault contracts. Tracks when vault operations are paused or unpaused through the boolean in_paused field.

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_paused`	`BOOL`	Boolean flag indicating whether the paused state is active. True indicates the contract or program is paused, false indicates it is active.

Sample Data

address	removed	in_paused	log_index	block_number	block_timestamp	transaction_hash
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	true	53	12625294	2025-11-03T08:40:26.000Z	0xe900b7354733ef506e23e4922b8774807e28052ff52e31b2023d2051c6176744
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	false	84	12980704	2025-11-12T19:35:25.000Z	0x1acc9e3756cd76f561996da5d9e1a2f8f06894f6662fd73de4183d2c5aa01e8b
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	true	56	12980921	2025-11-12T19:42:39.000Z	0xcccea4dace169d4fe61a13bbed2239e3e555344ce1092978afd2926d075fbc56

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.Vault_PausedStateChanged_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
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	[“-114084212586869293”,“-69019409303733821”]	0x1207c619086a52edef4a4b7af881b5ddd367a919000200000000000000000006	[“0x6969696969696969696969696969696969696969”,“0xac03caba51e17c86c921e1f6cbfbdc91f8bb2e6b”]	100	1145898	2025-02-14T23:35:40.000Z	0x19b2ea79bd7f5f5f19c5f8b9a13a68a73b3049daed9520a7a8c34ef74c68b9c5	0x0fb8273b25fdd7bddab4000157578d3960670f43	[“0”,“0”]
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	[“143809540841640120204”,“844612266131348980429”]	0x2c4a603a2aa5596287a06886862dc29d56dbc354000200000000000000000002	[“0x6969696969696969696969696969696969696969”,“0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce”]	4	1143425	2025-02-14T22:14:49.000Z	0x92ce03026657843d9083a94dcc7e9823834597994f0e6ffd0ae4cdd414e7027d	0xfb9744178e47572919c64c684ae3c5d0957cbfd2	[“0”,“0”]
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	[“84515481481641381496”,“498759234059326524204”]	0x2c4a603a2aa5596287a06886862dc29d56dbc354000200000000000000000002	[“0x6969696969696969696969696969696969696969”,“0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce”]	4	1146494	2025-02-14T23:54:58.000Z	0x67e5136ceb03b3b5221b409d8d04e7daf84e6385c6065a03a635e9a7e7cb8477	0x0a97582b44911e075d77452727bef59de9d9aba4	[“0”,“0”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.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.bex_v1_berachain.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
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0xb81b7376f8f4ecd09dca4434b661fc8eb04222b500020000000000000000016c	89	5207778	0xb81b7376f8f4ecd09dca4434b661fc8eb04222b5	2025-05-19T05:23:33.000Z	0x8f696edea522d35a1fe9582520fee924b174c38a687bef42781a38d8effcb702	2
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0xf296d962a264dd08002328b2322a99320a9755cf00020000000000000000016d	53	5219290	0xf296d962a264dd08002328b2322a99320a9755cf	2025-05-19T11:35:35.000Z	0xaba4b7c18f2aa60fb638bc2e379479f487b5788475c7f084fd8c9190a79563b6	2
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x5b902d94673a92df08f0ddde5340d16bec29fd3000020000000000000000016e	11	5229800	0x5b902d94673a92df08f0ddde5340d16bec29fd30	2025-05-19T17:15:46.000Z	0x25526dc148b74306acae07efd20c128d7aa65fc6193a2ea57c97f90a084b531a	2

Example Query

Query with partition filter

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

Vault_RelayerApprovalChanged_event

Relayer approval state change events emitted by Balancer V2 Vault contracts when users authorize or revoke permission for relayer addresses to execute operations on their behalf. Used for tracking relayer delegation patterns and vault security permissions.

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_relayer`	`STRING`	Address of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_approved`	`BOOL`	Boolean flag indicating whether approval was granted or revoked for the operation.

Sample Data

address	removed	in_sender	log_index	in_relayer	in_approved	block_number	block_timestamp	transaction_hash
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0xa80d9559a864f9ae8ddbcb7766fbeee1e3e8b57c	0	0x0000000000000000000000000000000000000000	true	1605903	2025-02-25T22:28:16.000Z	0xe27e0f6d15c2a7fbbefe70a9b95efca9074806d867f0c4665669dcc120f29a71
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0xce8d4e158981c4bb9b830fd729e415b5f7b666af	36	0x55dcce8165c88aad4403a15a9ce3a8e244657dd2	true	1592176	2025-02-25T14:49:15.000Z	0xed8646f93088ca7ab64cb6721e998991ae8c44ad5534c6a0b66484339388243e
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x0204e78d2043b9615b98339eec9b14d10bbff541	90	0x55dcce8165c88aad4403a15a9ce3a8e244657dd2	true	1579257	2025-02-25T07:31:31.000Z	0xdf41d07c72fc0563f8aac960cd29bb0a20d4e1420ca3eb43a19f5c2b266de692

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.Vault_RelayerApprovalChanged_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
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x38fdd999fe8783037db1bbfe465759e312f2d809000200000000000000000004	120	0x0555e30da8f98308edb960aa94c0db47230d2b9c	523000	0x6969696969696969696969696969696969696969	1317492	79851923482017569685	2025-02-19T00:00:38.000Z	0xf468c723a20abdc4c995f4020c5dc32f53de74bf9a3f05254df3fe349398b3fa
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x38fdd999fe8783037db1bbfe465759e312f2d809000200000000000000000004	29	0x0555e30da8f98308edb960aa94c0db47230d2b9c	400000	0x6969696969696969696969696969696969696969	1317495	61069791812536806944	2025-02-19T00:00:45.000Z	0x5107ef17f30ef390ea21369a420c24c635711abc28b40d3835e78749b85984fe
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x38fdd999fe8783037db1bbfe465759e312f2d809000200000000000000000004	114	0x0555e30da8f98308edb960aa94c0db47230d2b9c	103095	0x6969696969696969696969696969696969696969	1317496	15739525087782744922	2025-02-19T00:00:47.000Z	0x6dac15f21899cfacfdd4df7a5ee3ca2290dd41139fcbf3da49b624b27b26ed95

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.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.bex_v1_berachain.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
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x57110a237644f27f01c4d7e315a328e1da63306000000000000000000000016f	[“0x549943e04f40284185054145c6e4e9568c1d3241”,“0x57110a237644f27f01c4d7e315a328e1da633060”,“0x688e72142674041f8f6af4c808a4045ca1d6ac82”]	230	5261467	2025-05-20T10:28:24.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xcb63edad2e6719035ac8c016348efff79d0bb5846e376a46b84c0a0ce5f4f37b
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x0e35d1ffb2eed2708d278e939e3c244a9a91e84c0000000000000000000000f7	[“0x0e35d1ffb2eed2708d278e939e3c244a9a91e84c”,“0x549943e04f40284185054145c6e4e9568c1d3241”,“0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce”]	124	2690524	2025-03-22T16:54:53.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0x002b1a42938b49ba132af3e07ffbb15b8809c3ccb8ce76af8fd947441880d4b5
0x4be03f781c497a489e3cb0287833452ca9b9e80b	false	0x2a9ea10b60ab02e9b8960a08b4996e6bf5ea5eab000000000000000000000162	[“0x2a9ea10b60ab02e9b8960a08b4996e6bf5ea5eab”,“0xedb5180661f56077292c92ab40b1ac57a279a396”,“0xfcbd14dc51f0a4d49d5e53c2e0950e0bc26d0dce”]	145	4786027	2025-05-09T15:23:23.000Z	[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	0xca13b17bb5d36ee0aec0914a665ffcbd70ecade5dc633ca307c157c78e45fbff

Example Query

Query with partition filter

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

WeightedPoolFactory_FactoryDisabled_event

Factory disable/enable events from BEX v1 weighted pool factory contract on Berachain. Tracks administrative actions controlling whether the factory can create new liquidity pools.

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.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0xa966fa8f2d5b087fffa499c0c1240589371af409	false	44	13625025	2025-11-27T17:32:46.000Z	0x0a641cdeb81f6f96123e27a070734eab36c11e26c5626893198d310de68d6120

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.bex_v1_berachain.WeightedPoolFactory_FactoryDisabled_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
0xa966fa8f2d5b087fffa499c0c1240589371af409	0x2c4a603a2aa5596287a06886862dc29d56dbc354	false	6	471857	2025-01-30T21:44:03.000Z	0x43c9b6945ddcecfea8f60bed660aaa60aeabda9fe4a21e429ee7524c288da84a
0xa966fa8f2d5b087fffa499c0c1240589371af409	0x38fdd999fe8783037db1bbfe465759e312f2d809	false	6	472091	2025-01-30T21:51:20.000Z	0x3840930058b527471369a394aa21c573fd52ff220bb8dd063c16a6f6d14bc104
0xa966fa8f2d5b087fffa499c0c1240589371af409	0xdd70a5ef7d8cfe5c5134b5f9874b09fb5ce812b4	false	6	472004	2025-01-30T21:48:39.000Z	0xa24d422fc1b128559a6f1bf1e48b02a79c38e815feedeaf5723b3d3bf9ce0caf

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

StablePoolFactory_FactoryDisabled_event

StablePoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_ExternalBalanceTransfer_event

Vault_FlashLoan_event

Vault_InternalBalanceChanged_event

Vault_PausedStateChanged_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_RelayerApprovalChanged_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPoolFactory_FactoryDisabled_event

WeightedPoolFactory_PoolCreated_event

​Tables

​StablePoolFactory_FactoryDisabled_event

​StablePoolFactory_PoolCreated_event

​Vault_AuthorizerChanged_event

​Vault_ExternalBalanceTransfer_event

​Vault_FlashLoan_event

​Vault_InternalBalanceChanged_event

​Vault_PausedStateChanged_event

​Vault_PoolBalanceChanged_event

​Vault_PoolBalanceManaged_event

​Vault_PoolRegistered_event

​Vault_RelayerApprovalChanged_event

​Vault_Swap_event

​Vault_TokensDeregistered_event

​Vault_TokensRegistered_event

​WeightedPoolFactory_FactoryDisabled_event

​WeightedPoolFactory_PoolCreated_event

Tables

StablePoolFactory_FactoryDisabled_event

StablePoolFactory_PoolCreated_event

Vault_AuthorizerChanged_event

Vault_ExternalBalanceTransfer_event

Vault_FlashLoan_event

Vault_InternalBalanceChanged_event

Vault_PausedStateChanged_event

Vault_PoolBalanceChanged_event

Vault_PoolBalanceManaged_event

Vault_PoolRegistered_event

Vault_RelayerApprovalChanged_event

Vault_Swap_event

Vault_TokensDeregistered_event

Vault_TokensRegistered_event

WeightedPoolFactory_FactoryDisabled_event

WeightedPoolFactory_PoolCreated_event