Tables
AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event
Event emitted when a new Aave linear pool is created via Balancer V2’s AaveLinearPoolFactoryV5 contract. Contains the deployed pool address and associated Aave protocol identifier for tracking linear pool deployments across Balancer-Aave integrations.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | in_protocolId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x687b8c9b41e01be8b591725fac5d5f52d0564d79 | 0x712e23a9b91aa30ee7997d1c7a1a285d4c7912d1 | false | 9 | 1768665 | 0 | 2023-07-25T23:11:17.000Z | 0x2afdad34bf1e499205302bb0802f5cfacf3db2275a4f3ca978796e0f54211e9a |
Example Query
Example Query
AaveLinearPoolFactoryV5_FactoryDisabled_event
Event log emitted when Balancer V2 Aave Linear Pool Factory V5 contract is disabled, preventing new pool creation. Contains transaction metadata and contract address for tracking factory lifecycle state changes.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x687b8c9b41e01be8b591725fac5d5f52d0564d79 | false | 10 | 3057583 | 2023-08-24T19:15:13.000Z | 0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6 |
Example Query
Example Query
AaveLinearPoolFactoryV5_PoolCreated_event
Pool creation events emitted by Balancer V2 Aave Linear Pool Factory V5 contracts. Records the deployment of new Aave-integrated linear pools with their contract addresses and creation timestamps for tracking liquidity pool instantiation across supported chains.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x687b8c9b41e01be8b591725fac5d5f52d0564d79 | 0x712e23a9b91aa30ee7997d1c7a1a285d4c7912d1 | false | 4 | 1768665 | 2023-07-25T23:11:17.000Z | 0x2afdad34bf1e499205302bb0802f5cfacf3db2275a4f3ca978796e0f54211e9a |
Example Query
Example Query
ChildChainGauge_Approval_event
ERC20 Approval events emitted by Balancer V2 ChildChainGauge contracts, recording token allowance grants from owners to spenders. Tracks gauge token approvals across multiple chains (Arbitrum, Avalanche, Base, Gnosis, Optimism, Polygon) for liquidity mining and delegation operations.Columns
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__owner | STRING | Address of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string. |
in__spender | STRING | Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string. |
in__value | STRING | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
Sample Data
Sample Data
| address | removed | in__owner | in__value | log_index | in__spender | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x29b0c494ed7d098f4930428f115dcaf42a92392b | false | 0x0d9fe4d2312fe4db12c2aef5dc1c3514af3da502 | 30000000000000000 | 8 | 0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627 | 7716481 | 2023-12-10T15:31:49.000Z | 0x3abca48929feb31e7cd4428eade14f842f3648d71d7de7828c7597e00cae9a67 |
| 0x29b0c494ed7d098f4930428f115dcaf42a92392b | false | 0x0d9fe4d2312fe4db12c2aef5dc1c3514af3da502 | 0 | 3 | 0x8d2de8d2f73f1f4cab472ac9a881c9b123c79627 | 7966232 | 2023-12-16T10:16:51.000Z | 0xe716f81652256602babe940bd5fc52aa39ae905db3e461e2d8c87bde9ccd64b0 |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x3fdb50f723ceb370470d314ed05c22d7359be529 | 115792089237316195423570985008687907853269984665640564039457584007913129639935 | 0 | 0x00007c1b03497405f082c160cccff2dba1b30000 | 6040358 | 2023-11-01T20:21:03.000Z | 0xee61a4549c2cab98fa798cff395699ea1a09d8e4a9aad61cdb987928b695e8c1 |
Example Query
Example Query
ChildChainGauge_Deposit_event
Deposit events from Balancer V2 liquidity gauge contracts on Layer 2 chains and sidechains. Records user staking of liquidity pool tokens into gauges for BAL token rewards.Columns
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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in__value | STRING | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
Sample Data
Sample Data
| address | removed | in__user | in__value | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0xb5003153c07c51b9ac40e7b7d30bd8268104680b | 7079539285755073 | 21 | 4391311 | 2023-09-24T16:12:49.000Z | 0xff0b5d6efccae228b9e35add6477584ea5de5dd1f566dc4a4890aee6548f5aaf |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x6b21de83d21d6e64be0033bf6b1ab81cd8063d3b | 599716827993165 | 44 | 4368151 | 2023-09-24T03:20:49.000Z | 0x26b43ddbb99d381cbd8bd9eaa15d9d9953de88a5ee6b5f7999222a643890a85b |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x0afb69f36b0f28064e3e3657595655b077ae4883 | 21988608689731 | 26 | 4383444 | 2023-09-24T11:50:35.000Z | 0x6cabbb6c4ab3c97a79c4ab6b0de65f60384602fa47bc0f8840c85376661af68a |
Example Query
Example Query
ChildChainGauge_Transfer_event
ERC20 Transfer events emitted by Balancer ChildChainGauge contracts tracking gauge token movements between addresses. Records sender, recipient, and token amount for liquidity mining reward distribution and staking position transfers across Layer 2 and sidechain deployments.Columns
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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string. |
in__to | STRING | Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string. |
in__value | STRING | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
Sample Data
Sample Data
| in__to | address | removed | in__from | in__value | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x0000000000000000000000000000000000000000 | 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x4e9baacf3b7acc03269bfced5f350f6fb0eb1bd5 | 89754043743071844 | 11 | 7623653 | 2023-12-08T11:57:33.000Z | 0x30ef23c0a3bd164bb64ed299a132ad05669ef7d07583bc09fb349bdcb58921e6 |
| 0x0000000000000000000000000000000000000000 | 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0xc181edc719480bd089b94647c2dc504e2700a2b0 | 500000000000000000 | 43 | 7624281 | 2023-12-08T12:18:29.000Z | 0x20dfb5e5ecaec01a0350ab24ca5c5522ebb841203042cfb61efa5cdd04122026 |
| 0x0000000000000000000000000000000000000000 | 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0xc181edc719480bd089b94647c2dc504e2700a2b0 | 2168901896354521193 | 19 | 7638136 | 2023-12-08T20:00:19.000Z | 0xdbd11bda8b90235b6615e84cd0e8c7f2689e9adbf49226804801bace71cbf5b3 |
Example Query
Example Query
ChildChainGauge_UpdateLiquidityLimit_event
Liquidity limit update events emitted by Balancer v2 ChildChainGauge contracts, recording changes to user staking balances and total supply metrics. Contains original and working balance/supply values used for calculating gauge rewards and voting power across Layer 2 deployments.Columns
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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in__original_balance | STRING | User’s original balance in the liquidity gauge. String-encoded integer representing token amount in smallest unit. |
in__original_supply | STRING | Total original token supply in the liquidity gauge. String-encoded integer representing token amount in smallest unit. |
in__working_balance | STRING | User’s working balance in the liquidity gauge after applying boost multipliers. String-encoded integer representing token amount in smallest unit. |
in__working_supply | STRING | Total working supply in the liquidity gauge after applying boost multipliers to all user balances. String-encoded integer representing token amount in smallest unit. |
Sample Data
Sample Data
| address | removed | in__user | log_index | block_number | block_timestamp | transaction_hash | in__working_supply | in__original_supply | in__working_balance | in__original_balance |
|---|---|---|---|---|---|---|---|---|---|---|
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x850f83132d66abf840f32b6a8c5db6fd1a54f985 | 24 | 5983567 | 2023-10-31T12:48:01.000Z | 0x2571ebb988e579ee56539d731f1a83c3fef49a7c97eb3379a5cf5f2920ef4f51 | 574627421660711156015 | 1436492510600382071707 | 0 | 0 |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0xcd07da92d4be4a79baa895a0cd58a2ff1ef949bb | 15 | 5982478 | 2023-10-31T12:11:43.000Z | 0x988bb714493e313a2ba9ca8f312243424738ccb0f2670840a0df987ac02f9023 | 574736625943297871625 | 1436765521306848860734 | 0 | 0 |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0xcd07da92d4be4a79baa895a0cd58a2ff1ef949bb | 8 | 5982429 | 2023-10-31T12:10:05.000Z | 0x15031103cefbabefa849ddd85967843906b81e8917e2ba02dae031bd6c7a7d6d | 574736625943297871625 | 1436765521306848860734 | 0 | 0 |
Example Query
Example Query
ChildChainGauge_Withdraw_event
Withdrawal events emitted by Balancer V2 ChildChainGauge contracts when users unstake liquidity pool tokens from gauges. Records the user address and token amount withdrawn in base units for tracking gauge participation changes.Columns
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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in__value | STRING | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
Sample Data
Sample Data
| address | removed | in__user | in__value | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x7828eb93f247a81a907a99a0c77c7b4b9235c038 | 70966836546827375 | 2 | 8167187 | 2023-12-21T01:55:21.000Z | 0x34a6c68655e6347cb859c4256921657991989a36dd1f398f8b09d8ba63df9a5c |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0x8f26bdea1b442e3311c6c99d61071624531d8951 | 71011853915847467 | 3 | 8165743 | 2023-12-21T01:07:13.000Z | 0x0eb8ee446b4eb311fc6fd2d4a895d780b2a65121cddca0f673c833808cb01650 |
| 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | false | 0xb5003153c07c51b9ac40e7b7d30bd8268104680b | 100024626359712692 | 3 | 8171875 | 2023-12-21T04:31:37.000Z | 0x5f6b01efb7f9fbd67de9c7f3bd2d39ad441783e8c7ab76ec4845f3ae819ed934 |
Example Query
Example Query
ChildChainGaugeFactory_GaugeCreated_event
Event logs emitted when a new gauge contract is deployed by the ChildChainGaugeFactory contract in Balancer v2. Records the address of each created gauge contract for tracking liquidity mining incentive distribution mechanisms across Layer 2 and sidechain deployments.Columns
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_gauge | STRING | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | in_gauge | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0xb1a4fe1c6d25a0ddab47431a92a723dd71d9021f | false | 0x4321edfe7dec773a91316481fcb19d6ca6dc5207 | 25 | 5967399 | 2023-10-31T03:49:05.000Z | 0x98b35da464e3a601ccc63068f852e47546114aa27d5a532187b7670f5d0b5482 |
| 0xb1a4fe1c6d25a0ddab47431a92a723dd71d9021f | false | 0xfa61fb6218378b9f01ca4b2b662b5c4d12915db9 | 11 | 5963673 | 2023-10-31T01:44:53.000Z | 0xc6c3aea149b26b004bab42ea3efc17181504adf14b0b42c4644e01ec4efcfb30 |
| 0xb1a4fe1c6d25a0ddab47431a92a723dd71d9021f | false | 0x309b2b4549be6821b735e86b47df3bea1a7f6b08 | 5 | 4400597 | 2023-09-24T21:22:21.000Z | 0x5205ca8389107c75ce1090798359f9eb8eee577794b3e57f6e1985b564703792 |
Example Query
Example Query
ComposableStablePoolFactoryV5_FactoryDisabled_event
Event log emitted when a Balancer V2 Composable Stable Pool Factory V5 contract is disabled. Records the administrative action of deactivating the factory contract from creating new pools.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x8df317a729fcaa260306d7de28888932cb579b88 | false | 153 | 16391961 | 2024-06-28T11:14:29.000Z | 0x7d6a41891991fb1eadf57bf74fc5ae98bf4ff34c99ae242b7259a0e5165c1c77 |
Example Query
Example Query
ComposableStablePoolFactoryV5_PoolCreated_event
Pool creation events emitted by Balancer V2 ComposableStablePoolFactoryV5 contracts. Captures the factory contract address and newly deployed composable stable pool address for tracking pool deployments across the protocol.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x8df317a729fcaa260306d7de28888932cb579b88 | 0x6fbfcf88db1aada31f34215b2a1df7fafb4883e9 | false | 7 | 2107159 | 2023-08-02T19:14:25.000Z | 0x70a5bbade72795084c7903c4715d828e523b08973fd599e2dddea60b50a9f702 |
| 0x8df317a729fcaa260306d7de28888932cb579b88 | 0x0c659734f1eef9c63b7ebdf78a164cdd745586db | false | 19 | 3621721 | 2023-09-06T20:39:49.000Z | 0xc5da71d36c7406f7e04747b0c2b7965188ffe96309a70f013376fa0ad5dbfb11 |
| 0x8df317a729fcaa260306d7de28888932cb579b88 | 0xc561540c16d49d0bfc69c99f9fc66145b1d5ddbd | false | 14 | 2276678 | 2023-08-06T17:25:03.000Z | 0x40e58e8f0058b1b6a30cf4331a3489991dc8b7baa6be61bcfaef3d49bb131a51 |
Example Query
Example Query
ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event
ERC-4626 (Tokenized Vault Standard) linear pool creation events emitted by Balancer V2 factory contracts. Contains deployed pool address and protocol integration identifier for tracking vault-based linear pool deployments across liquidity management strategies.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | in_protocolId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x161f4014c27773840ccb4ec1957113e6dd028846 | 0x1cc2e10c486ffb7228810b9c7c183d0cd92cdf44 | false | 9 | 1768622 | 0 | 2023-07-25T23:09:51.000Z | 0x409a4a467fcad05f47f8deee638d698e058bc36854c932f3a571cfdc3dd78a40 |
Example Query
Example Query
ERC4626LinearPoolFactoryV4_FactoryDisabled_event
Event log emitted when an ERC4626 linear pool factory (version 4) is disabled in Balancer V2. Records the deactivation of pool creation functionality for ERC-4626 tokenized vault integration.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x161f4014c27773840ccb4ec1957113e6dd028846 | false | 7 | 3057583 | 2023-08-24T19:15:13.000Z | 0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6 |
Example Query
Example Query
ERC4626LinearPoolFactoryV4_PoolCreated_event
PoolCreated event logs emitted by Balancer V2’s ERC4626LinearPoolFactoryV4 contract when new ERC-4626 linear pools are deployed. Records the factory contract address and newly created pool address for tracking Balancer linear pool creation across chains.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x161f4014c27773840ccb4ec1957113e6dd028846 | 0x1cc2e10c486ffb7228810b9c7c183d0cd92cdf44 | false | 4 | 1768622 | 2023-07-25T23:09:51.000Z | 0x409a4a467fcad05f47f8deee638d698e058bc36854c932f3a571cfdc3dd78a40 |
Example Query
Example Query
GearboxLinearPoolFactoryV2_FactoryDisabled_event
Factory disable events from Balancer V2’s Gearbox Linear Pool Factory on Base chain. Tracks when the factory contract is administratively disabled, preventing creation of new Gearbox-integrated linear pools.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x9dd32684176638d977883448a4c914311c07bd62 | false | 8 | 3057583 | 2023-08-24T19:15:13.000Z | 0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6 |
Example Query
Example Query
GearboxLinearPoolFactoryV2_GearboxLinearPoolCreated_event
Pool creation events from Balancer V2’s Gearbox Linear Pool Factory on Base, capturing when new Gearbox-integrated linear pools are deployed. Used for tracking pool deployments and analyzing Gearbox protocol integration with Balancer’s liquidity infrastructure.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | in_protocolId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x9dd32684176638d977883448a4c914311c07bd62 | 0x3c28a59356b473847aaa5e0b6f561636079213a6 | false | 9 | 1768873 | 0 | 2023-07-25T23:18:13.000Z | 0x96b4a76957bcdfe134c36be78f4e6fc0d46b7f1d8633921c0cea751b62a3893a |
Example Query
Example Query
GearboxLinearPoolFactoryV2_PoolCreated_event
Pool creation events from Balancer V2’s Gearbox Linear Pool Factory on Base, tracking newly deployed Gearbox-integrated linear pools. Used for monitoring pool deployments and analyzing Gearbox protocol integration with Balancer liquidity infrastructure.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x9dd32684176638d977883448a4c914311c07bd62 | 0x3c28a59356b473847aaa5e0b6f561636079213a6 | false | 4 | 1768873 | 2023-07-25T23:18:13.000Z | 0x96b4a76957bcdfe134c36be78f4e6fc0d46b7f1d8633921c0cea751b62a3893a |
Example Query
Example Query
ManagedPoolFactoryV2_FactoryDisabled_event
Event log emitted when a Balancer V2 Managed Pool Factory V2 contract is disabled. Records administrative actions that prevent the factory from creating new managed pool instances.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x9a62c91626d39d0216b3959112f9d4678e20134d | false | 418 | 38432573 | 2025-11-20T16:01:33.000Z | 0xd897b9c5b7fe5d63464f51736fc11298ed3144b909e35920553988ea2e247f7a |
Example Query
Example Query
ManagedPoolFactoryV2_PoolCreated_event
Pool creation events emitted by Balancer V2 ManagedPoolFactory V2 contracts. Records the deployment of new managed pools with factory and pool contract addresses.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x9a62c91626d39d0216b3959112f9d4678e20134d | 0x69592c63173bf84aa29c10935b9863717a8efe31 | false | 17 | 10243436 | 2024-02-07T03:23:39.000Z | 0x980cc98668f90759ea6e5753d85e76b8c99e6dde2df5ea55ffaf2cf47836ea34 |
| 0x9a62c91626d39d0216b3959112f9d4678e20134d | 0xe50ad96af9370d05d3c1ce85f17c31557b29c4ee | false | 10 | 1769000 | 2023-07-25T23:22:27.000Z | 0xd79a9e12b5575c7a6c30e735eda2b0f3e76d36273bf864b7a3f5798be473a201 |
| 0x9a62c91626d39d0216b3959112f9d4678e20134d | 0xfaf027b660a614126cb204184422e34780980789 | false | 9 | 10563549 | 2024-02-14T13:14:05.000Z | 0x764304ca9b3b87741932ce95f541f8ac9cf31adbfd49def1164b6030565e15f7 |
Example Query
Example Query
NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event
Event logs emitted when a Balancer V2 Liquidity Bootstrapping Pool (LBP) factory contract is disabled. Records administrative actions that prevent new pool creation from the factory.Columns
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
Sample Data
Example Query
Example Query
NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event
Liquidity Bootstrapping Pool (LBP) creation events emitted by Balancer V2’s no-protocol-fee factory contract. Records the deployed pool address when new weight-adjustable pools are created for token launches and fair distribution mechanisms.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x0c6052254551eae3ecac77b01dfcf1025418828f | 0xce6f0924180724b025d3132253ceaa7f1e095402 | false | 5 | 1805588 | 2023-07-26T19:42:03.000Z | 0xc62dd6736281318945c6f689d435656a5033ba0184b72fb03b197dfcaf53bfd7 |
| 0x0c6052254551eae3ecac77b01dfcf1025418828f | 0x71528afe250438e184b2deaf7947f0f45931df3b | false | 5 | 1206535 | 2023-07-12T22:53:37.000Z | 0xdc1727acbf01ace17bbe6ca4fae9fcbbeced935ef386c38215f16decaaa0f3f3 |
| 0x0c6052254551eae3ecac77b01dfcf1025418828f | 0xd094485a7feb679e5433edb80c3771dccdfa9cf1 | false | 92 | 22906417 | 2024-11-26T06:23:01.000Z | 0x8313f17023c6ba78d797058a9853db3a311a4d2bc507dd9a35996a72626a2382 |
Example Query
Example Query
Pool_RecoveryModeStateChanged_event
Balancer V2 pool recovery mode state change events emitted when pools enter or exit recovery mode. Thein_enabled flag indicates whether recovery mode was activated or deactivated for emergency liquidity withdrawals.
Columns
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_enabled | BOOL | Boolean flag indicating whether recovery mode or the collector is enabled. |
Sample Data
Sample Data
Example Query
Example Query
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
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash | in_swapFeePercentage |
|---|---|---|---|---|---|---|
| 0x433f09ca08623e48bac7128b7105de678e37d988 | false | 33 | 3621959 | 2023-09-06T20:47:45.000Z | 0xc2773346139264da5c148fd22d25df445a507cca61aa2088b503d190c8724e31 | 5000000000000000 |
| 0xb328b50f1f7d97ee8ea391ab5096dd7657555f49 | false | 7 | 3622203 | 2023-09-06T20:55:53.000Z | 0x198d9684de4ed6cd999ecf5914f17eb46dc80a8de8998e3a5a722905a46cb973 | 5000000000000000 |
| 0x0c659734f1eef9c63b7ebdf78a164cdd745586db | false | 12 | 3621721 | 2023-09-06T20:39:49.000Z | 0xc5da71d36c7406f7e04747b0c2b7965188ffe96309a70f013376fa0ad5dbfb11 | 100000000000000 |
Example Query
Example Query
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
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
Sample Data
| in_to | address | in_from | removed | in_value | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0x52746cbb5f62ac9b5bd295f3ff129c24788f24ae | false | 89 | 2011359 | 2023-07-31T14:01:05.000Z | 0x9a3fe4d1323bff8c8c00aab646226ae49190625ce4c15a42a8e3672cf9304c9e | |||
| 0x52746cbb5f62ac9b5bd295f3ff129c24788f24ae | false | 20 | 2012012 | 2023-07-31T14:22:51.000Z | 0xa0e2337f1056b2433842117485e8e3eeaf9eac5d5703df751bda0615abe89bdf | |||
| 0x52746cbb5f62ac9b5bd295f3ff129c24788f24ae | false | 1 | 2007316 | 2023-07-31T11:46:19.000Z | 0xaf67702c5704fcf5b0b29cf8bb3d40a27f323bb2d5fd33a8797cb88af3adfa6f |
Example Query
Example Query
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
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
Sample Data
Example Query
Example Query
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
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash | in_newSwapFeePercentage |
|---|---|---|---|---|---|---|
| 0xce88686553686da562ce7cea497ce749da109f9f | false | 79 | 2136922 | 2023-08-03T11:46:31.000Z | 0x6d89afc8361a395c1216386a96e6a2a26d36f52f2f55894f104ab408c1ee6057 | 500000000000000000 |
Example Query
Example Query
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
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | in_newAuthorizer | transaction_hash |
|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0 | 1196036 | 2023-07-12T17:03:39.000Z | 0x809b79b53f18e9bc08a961ed4678b901ac93213a | 0x0dc2e3d436424f2f038774805116896d31828c0bf3795a6901337bdec4e0dff6 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 86 | 2136922 | 2023-08-03T11:46:31.000Z | 0xa69e0ccf150a29369d8bbc0b3f510849db7e8eee | 0x6d89afc8361a395c1216386a96e6a2a26d36f52f2f55894f104ab408c1ee6057 |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_token | in_amount | in_sender | log_index | block_number | in_recipient | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x1e8448976bd7d403e32304aebe8b64c4a1fa7ee8 | 206078544740315473 | 0xeede8aacbf9bd025bf343255c5ebb1ca60ff6453 | 63 | 17473830 | 0x7c3c773c878d2238a9b64d8cee02377bf07ed06a | 2024-07-23T12:16:47.000Z | 0x359b1c47f5c65417e7c875c92338db8f5e1b0298a844588ea318ce160b8f7f89 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xf7862a614ffea2bf8ef2d66a872be2df735d22e6 | 2295905265780461574 | 0xfa70a111fbe53ab5ee7aedb9a3b06c5a9733c093 | 45 | 17494261 | 0x7c3c773c878d2238a9b64d8cee02377bf07ed06a | 2024-07-23T23:37:49.000Z | 0x8078b4f31862b6e86cf4865a25d60f6327a6b7917632fdf83d2a19e9ba569004 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xf7862a614ffea2bf8ef2d66a872be2df735d22e6 | 725716159422572521 | 0x3dbce497ba28f264f6f256126c555c51ca885824 | 147 | 17476671 | 0x7c3c773c878d2238a9b64d8cee02377bf07ed06a | 2024-07-23T13:51:29.000Z | 0x2e380db3e9cc9925cbb517f263ae0f45b80f970dc87d5841911d73d98bf13848 |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_token | in_amount | log_index | block_number | in_feeAmount | in_recipient | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 1000000 | 24 | 6097257 | 0 | 0x3b1c7893c83265c94863243c776a1a862f6174f6 | 2023-11-03T03:57:41.000Z | 0x2b5f916d1b280d9064553bee8e6e9f4425dddc9a996f10628fb6b88e5c9f9b59 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xeb466342c4d449bc9f53a865d5cb90586f405215 | 1000000 | 253 | 6091738 | 0 | 0x0352bad2bb0fbd93455ae0cfb72d9fba3036df02 | 2023-11-03T00:53:43.000Z | 0x2810273ac415a1d69fdc47fc329ff48b92ba07c6b35873e9f80d83b4100afaf1 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xeb466342c4d449bc9f53a865d5cb90586f405215 | 1000000 | 223 | 6091738 | 0 | 0x0352bad2bb0fbd93455ae0cfb72d9fba3036df02 | 2023-11-03T00:53:43.000Z | 0x2810273ac415a1d69fdc47fc329ff48b92ba07c6b35873e9f80d83b4100afaf1 |
Example Query
Example Query
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
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
Sample Data
| address | in_user | removed | in_delta | in_token | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | 0x76f7204b62f554b79d444588edac9dfa7032c71a | false | 0 | 0x6fbfcf88db1aada31f34215b2a1df7fafb4883e9 | 19 | 5078887 | 2023-10-10T14:12:01.000Z | 0x6adec24b89c44b0b07e59df2404e13a6be8561a6c370e3dc447d5a108e7cd49b |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | 0x76f7204b62f554b79d444588edac9dfa7032c71a | false | -5098736 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 36 | 5079047 | 2023-10-10T14:17:21.000Z | 0x89dd458090032e620ca9a42fc95e74d112e78cbe988642d55cf7cc155961aeee |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | 0x76f7204b62f554b79d444588edac9dfa7032c71a | false | 5098736 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 32 | 5079047 | 2023-10-10T14:17:21.000Z | 0x89dd458090032e620ca9a42fc95e74d112e78cbe988642d55cf7cc155961aeee |
Example Query
Example Query
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
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
Sample Data
Example Query
Example Query
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
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
Sample Data
| address | removed | in_deltas | in_poolId | in_tokens | log_index | block_number | block_timestamp | transaction_hash | in_liquidityProvider | in_protocolFeeAmounts |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | [“4673524703018377”,“0”] | 0xa892be6ee527f4fb8b3b60486a53c0627cb1d27e000200000000000000000014 | [“0x4200000000000000000000000000000000000006”,“0xa48c87061f4081ca8b4e2bc01711edefb0dab2fc”] | 4 | 8522245 | 2023-12-29T07:10:37.000Z | 0x00801130100e07f5d21b3b3ddb5a07689e6cb9f323632461b76ff0a014c8199f | 0xa0ef13ea74083b3b56dd607f2c6aab45fe7d0780 | [“0”,“0”] |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | [“5625695403908872”,“0”] | 0x65e8e75899f683c8e2e73c77d6c5c63075f296cd00020000000000000000002b | [“0x4200000000000000000000000000000000000006”,“0xa9c9dcb054421dedc9d9006cffe843d0a5cd6339”] | 11 | 8509456 | 2023-12-29T00:04:19.000Z | 0x1080d4517b8a06b30dadabf9999b5cf3a63434ceb0310a86222e307172747e30 | 0x5bcf1b386034156856277e960e32007facaf7382 | [“0”,“0”] |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | [“0”,“657631275353149016640616”] | 0x65e8e75899f683c8e2e73c77d6c5c63075f296cd00020000000000000000002b | [“0x4200000000000000000000000000000000000006”,“0xa9c9dcb054421dedc9d9006cffe843d0a5cd6339”] | 4 | 8545526 | 2023-12-29T20:06:39.000Z | 0xfe6f6f30d94b2e99d4c1f560bfd788b5ede22c77c27f6597d11b3d727de28c22 | 0x6afbc428dcde09679592b330a9164247e9614bd3 | [“0”,“0”] |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_token | in_poolId | log_index | block_number | in_cashDelta | block_timestamp | in_assetManager | in_managedDelta | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935 | 0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae | 174 | 24118293 | 0 | 2024-12-24T07:38:53.000Z | 0x311b982e5c55dcb96379f8f06f649b13207fcb31 | -500000000000000 | 0x486ee3096c9efb52c723a441b8b71f71a4b45dbeee2b01447c0da3f4c44accf4 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935 | 0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae | 173 | 24118293 | -500000000000000 | 2024-12-24T07:38:53.000Z | 0x311b982e5c55dcb96379f8f06f649b13207fcb31 | 500000000000000 | 0x486ee3096c9efb52c723a441b8b71f71a4b45dbeee2b01447c0da3f4c44accf4 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935 | 0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae | 236 | 24117538 | 500000000000000 | 2024-12-24T07:13:43.000Z | 0x311b982e5c55dcb96379f8f06f649b13207fcb31 | -500000000000000 | 0x9683bd3403ee98ebd4addb36cf997d1a6e48f1c20acabf3121d87d020da959cc |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_poolId | log_index | block_number | in_poolAddress | block_timestamp | transaction_hash | in_specialization |
|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x15d9d108437b17d1fa70392f9ed086306229ec910000000000000000000000bf | 4 | 6727090 | 0x15d9d108437b17d1fa70392f9ed086306229ec91 | 2023-11-17T17:52:07.000Z | 0x90f0138d2967b653a9298f26eda75a2d54e9a63963683c473a1501020436bce1 | 0 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x64fcbd882d7de9d4dd1fa670c3f1ea15f324baf40002000000000000000000be | 8 | 6709354 | 0x64fcbd882d7de9d4dd1fa670c3f1ea15f324baf4 | 2023-11-17T08:00:55.000Z | 0x40db041bcb194c5c2e7e29daa375b25f306d2b4208461b9ee4a59c2c9e2c4417 | 2 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x1607aa77f703deedfd4b8e146d3c7fcb5bee4a9c0002000000000000000000dd | 18 | 8998257 | 0x1607aa77f703deedfd4b8e146d3c7fcb5bee4a9c | 2024-01-09T07:37:41.000Z | 0x64272931f0eac1d552ca3f152cde5509beec97bcb8ef5e7a869a0456cb43ef1c | 2 |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_sender | log_index | in_relayer | in_approved | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xc040794468e2c5180312e5a10b093a33a486742f | 0 | 0x76f7204b62f554b79d444588edac9dfa7032c71a | true | 2339425 | 2023-08-08T04:16:37.000Z | 0x366c2cd867847e78049a93871667b17807d3a0d86b677c5aa827f9f5ba0325c6 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xc9cd150c362f4c10460677bf2cf294f2354d6484 | 0 | 0x76f7204b62f554b79d444588edac9dfa7032c71a | true | 2363430 | 2023-08-08T17:36:47.000Z | 0x6c2c281739e4b860d826645121e98f27d75f4a790122a8536f5fc36fc0725d8b |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x97518452ec958be01457e55b96c12bc02a532945 | 0 | 0x76f7204b62f554b79d444588edac9dfa7032c71a | true | 2373339 | 2023-08-08T23:07:05.000Z | 0x82285ab04462736637f5e3bbf15e192590d93634e4fd9b6e80849ba1f9fc26e5 |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_poolId | log_index | in_tokenIn | in_amountIn | in_tokenOut | block_number | in_amountOut | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x0c659734f1eef9c63b7ebdf78a164cdd745586db000000000000000000000046 | 29 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 131223237 | 0x0c659734f1eef9c63b7ebdf78a164cdd745586db | 8882729 | 130167675636323411088 | 2024-01-06T15:26:45.000Z | 0xb009021d5a19266c688b4500357e46308adb20d1c564eeae09bce3c27e9fe00e |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x58f2110b61f97fd6b9200b038d92f17c722a5a3300000000000000000000004f | 4 | 0x4158734d47fc9692176b5085e0f52ee0da5d47f1 | 3288365254089636 | 0x11c1879227d463b60db18c17c20ae739ae8e961a | 8892133 | 3284455558861531 | 2024-01-06T20:40:13.000Z | 0x8a46a50a04ddf42ddd256388d4d9f8244d6a02c3160258585aaae6409f433840 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x2650d8d8167faa125a9156d533703a2af5d9f4e10001000000000000000000ce | 5 | 0x4158734d47fc9692176b5085e0f52ee0da5d47f1 | 154089728230396717 | 0x1509706a6c66ca549ff0cb464de88231ddbe213b | 8881184 | 1014927498628786182 | 2024-01-06T14:35:15.000Z | 0x1ffce3904226621f177f217abbcca5cc3c112108fb6fe0896ce286096a9727c5 |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_poolId | in_tokens | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae | [“0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935”] | 177 | 24118293 | 2024-12-24T07:38:53.000Z | 0x486ee3096c9efb52c723a441b8b71f71a4b45dbeee2b01447c0da3f4c44accf4 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xcb893bc24be732b51207ee7a184e88c7056495b20001000000000000000001ae | [“0xb33ff54b9f7242ef1593d2c9bcd8f9df46c77935”] | 142 | 24115700 | 2024-12-24T06:12:27.000Z | 0x409a0eace747da13978b85788a0cdb6030ee020abc2a5ef223816eebbc3d036e |
Example Query
Example Query
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
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
Sample Data
| address | removed | in_poolId | in_tokens | log_index | block_number | block_timestamp | in_assetManagers | transaction_hash |
|---|---|---|---|---|---|---|---|---|
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0xc80289149774aeab633a7a2c28d673c784a30ba1000200000000000000000055 | [“0x4158734d47fc9692176b5085e0f52ee0da5d47f1”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”] | 7 | 4357200 | 2023-09-23T21:15:47.000Z | [“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”] | 0x3a4dc8abf40bb4c76fdb71ab684b2674419cce968c44d40de6f9bb994d9de309 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x6fbfcf88db1aada31f34215b2a1df7fafb4883e900000000000000000000000c | [“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“0x6fbfcf88db1aada31f34215b2a1df7fafb4883e9”,“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”] | 2 | 2107159 | 2023-08-02T19:14:25.000Z | [“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”] | 0x70a5bbade72795084c7903c4715d828e523b08973fd599e2dddea60b50a9f702 |
| 0xba12222222228d8ba445958a75a0704d566bf2c8 | false | 0x2db50a0e0310723ef0c2a165cb9a9f80d772ba2f00020000000000000000000d | [“0x4200000000000000000000000000000000000006”,“0x6fbfcf88db1aada31f34215b2a1df7fafb4883e9”] | 2 | 2107363 | 2023-08-02T19:21:13.000Z | [“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”] | 0xfe4b79ebcf53fdbd387398d20b2c56785414aa448217f5a5e8ba5c68ca81aa09 |
Example Query
Example Query
WeightedPoolFactoryV4_FactoryDisabled_event
Event emitted when a Balancer V2 weighted pool factory (version 4) is administratively disabled, preventing new pool creation. Used for tracking factory lifecycle and protocol governance actions.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4 | false | 417 | 38432573 | 2025-11-20T16:01:33.000Z | 0xd897b9c5b7fe5d63464f51736fc11298ed3144b909e35920553988ea2e247f7a |
Example Query
Example Query
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
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4 | 0xe9ea6b943f252bf3dfa4d7964f19404a2bdd1f75 | false | 21 | 6772703 | 2023-11-18T19:12:33.000Z | 0xa792f2123eeb13f1dfeeca02b6778e7ef9ba3f9d3ed9adccceaac8839e0e272f |
| 0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4 | 0x9d884e09e0ddf816a1b3f31ccd94a0319793b11b | false | 36 | 6781297 | 2023-11-18T23:59:01.000Z | 0x44a1d8132aceff11da322886c0f857b92cceff3f7feada5e66b31a98cfacdaaf |
| 0x4c32a8a8fda4e24139b51b456b42290f51d6a1c4 | 0x2650d8d8167faa125a9156d533703a2af5d9f4e1 | false | 9 | 7508468 | 2023-12-05T19:58:03.000Z | 0x1e982db6e98c12e8aa6692c10f0c4d06ebc40aacac47910a76c0f3f17943070b |
Example Query
Example Query
YearnLinearPoolFactoryV2_FactoryDisabled_event
Event logs emitted when a Yearn Linear Pool Factory V2 contract is disabled on Balancer V2. Contains transaction metadata and contract address for tracking factory lifecycle state changes.Columns
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
Sample Data
| address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|
| 0x44d33798dddcdabc93fe6a40c80588033dc502d3 | false | 9 | 3057583 | 2023-08-24T19:15:13.000Z | 0x40315c892caa6f74638fd95586982923a8669064fc65bdd83f06cf4fc17e93f6 |
Example Query
Example Query
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
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
Sample Data
| address | in_pool | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x44d33798dddcdabc93fe6a40c80588033dc502d3 | 0x369877467fc3b6774de4e11e0c0abbde70eb40fd | false | 4 | 1768721 | 2023-07-25T23:13:09.000Z | 0x0262976c98dca636d6c969d212db76f9c159b1f752ab440a823ffb3fcf3f5b49 |
Example Query
Example Query
YearnLinearPoolFactoryV2_YearnLinearPoolCreated_event
Event logs recording creation of Yearn-integrated linear pools in Balancer V2, emitted by the YearnLinearPoolFactoryV2 contract. Contains the newly created pool address and protocol identifier linking the pool to Yearn vault integrations for yield-bearing assets.Columns
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
Sample Data
| address | in_pool | removed | log_index | block_number | in_protocolId | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x44d33798dddcdabc93fe6a40c80588033dc502d3 | 0x369877467fc3b6774de4e11e0c0abbde70eb40fd | false | 9 | 1768721 | 0 | 2023-07-25T23:13:09.000Z | 0x0262976c98dca636d6c969d212db76f9c159b1f752ab440a823ffb3fcf3f5b49 |
Example Query
Example Query