Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_protocolIdSTRINGNumeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
addressin_poolremovedlog_indexblock_numberin_protocolIdblock_timestamptransaction_hash
0x6caf662b573f577de01165d2d38d1910bba41f8a0xa826a114b0c7db4d1ff4a4be845a78998c64564cfalse362951268302023-05-02T20:16:34.000Z0xf137340008c7897487853f68d28f2c37cbb4aed67e31feaac10c9f9e43687c89
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.AaveLinearPoolFactoryV5_AaveLinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x6caf662b573f577de01165d2d38d1910bba41f8afalse12342557372023-08-22T22:38:31.000Z0x943505c91f5a347627fa8736d9d43d9f36cd5208cadf7ab2575e2257250a0ec3
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.AaveLinearPoolFactoryV5_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x6caf662b573f577de01165d2d38d1910bba41f8a0xa826a114b0c7db4d1ff4a4be845a78998c64564cfalse31295126832023-05-02T20:16:34.000Z0xf137340008c7897487853f68d28f2c37cbb4aed67e31feaac10c9f9e43687c89
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.AaveLinearPoolFactoryV5_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__ownerSTRINGAddress of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string.
in__spenderSTRINGAddress authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount 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).
addressremovedin__ownerin__valuelog_indexin__spenderblock_numberblock_timestamptransaction_hash
0xf9ae6d2d56f02304f72dcc61694ead0dc8db51f7false0x9bd09687da5ec6b50e8242e7ce3cc5c065ff07c9115792089237316195423570985008687907853269984665640564039457584007913129639935270xf9ae6d2d56f02304f72dcc61694ead0dc8db51f7346551282023-09-01T21:24:39.000Z0x67fd9ab66745ecc6a6e5f986154c5d8bf2a059d0375f6737f1da09bd02c65150
0xf9ae6d2d56f02304f72dcc61694ead0dc8db51f7false0x7f429edeff8afc7bb3a2cf7db832fc86f6fa99da11579208923731619542357098500868790785326998466564056403945758400791312963993510x40aa958dd87fc8305b97f2ba922cddca374bcd7f387252622023-12-07T06:51:41.000Z0xe90b9ebb93bf30fd542bafa5c852d36ddd74948fe6660784d1488ec8003c741f
0x231d84c37b2c4b5a2e2fe325bb77daa65bf71d92false0xb79c2a75cd9073d68e75ddf71d53c07747df79339968981568956966150xfd94711ea42f74581e1b2a54ac3a52954b0a5b35387315832023-12-07T10:19:41.000Z0xcae457d6f6bcf426b9bb51857045fb933f18de74a4ad44885886e563d48d5217
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ChildChainGauge_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__userSTRINGAddress of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount 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).
addressremovedin__userin__valuelog_indexblock_numberblock_timestamptransaction_hash
0x0c22ff3f93b5c9f13e41fa9d270680e97ac13b28false0xd3f85ade70adf48ed17c8cb182b8b1aff542e51f530429001802339540131882371689352023-10-31T19:47:11.000Z0xe71ebc5ae9c611a2fbd54de84a4db0a5af9340c4d9ddd0621b77e69a379f17d8
0x231d84c37b2c4b5a2e2fe325bb77daa65bf71d92false0x26fa40f1f29e3b495ec3c4c46b24df7ecde796d9209087852152446335725371756952023-10-31T23:43:03.000Z0x11d57db94d9ec0bbb0750ff366bbf7f5241e776dc8ddc5252b56d8cad2c4e494
0x231d84c37b2c4b5a2e2fe325bb77daa65bf71d92false0x26fa40f1f29e3b495ec3c4c46b24df7ecde796d9405735026784535721634371521442023-10-31T10:14:51.000Z0x23b3fe5d19a5392429aefa11a12aff31f294594c8084bc3af9c30cfebd754416
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ChildChainGauge_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__fromSTRINGAddress initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__toSTRINGDestination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount 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).
in__toaddressremovedin__fromin__valuelog_indexblock_numberblock_timestamptransaction_hash
0x00000000000000000000000000000000000000000x231d84c37b2c4b5a2e2fe325bb77daa65bf71d92false0x89017b6469c1735a6580a4a1e6d95664391986b513277206688241637537046346103152023-08-31T18:39:36.000Z0x7f2937053c742ececa0b0bd144e1b4cf3236415efbe12821947fee5c62e0e2d5
0x00000000000000000000000000000000000000000x231d84c37b2c4b5a2e2fe325bb77daa65bf71d92false0x685fb9fbde184dfa93347d3434b0c5254ba90b0b30891341097957201690229346084342023-08-31T17:32:57.000Z0xda31bde493c09acae9c578ccffb163eb611f823ce1c971f8d58fad4033db5bd9
0x00000000000000000000000000000000000000000x231d84c37b2c4b5a2e2fe325bb77daa65bf71d92false0x26fa40f1f29e3b495ec3c4c46b24df7ecde796d9999379716646470961844346155262023-08-31T21:45:23.000Z0xb0065a0b10c02cdef74ac07439c3d8d4d088f52a3b3a02c9647e0ada6ea91b5e
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ChildChainGauge_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__userSTRINGAddress of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__original_balanceSTRINGUser’s original balance in the liquidity gauge. String-encoded integer representing token amount in smallest unit.
in__original_supplySTRINGTotal original token supply in the liquidity gauge. String-encoded integer representing token amount in smallest unit.
in__working_balanceSTRINGUser’s working balance in the liquidity gauge after applying boost multipliers. String-encoded integer representing token amount in smallest unit.
in__working_supplySTRINGTotal working supply in the liquidity gauge after applying boost multipliers to all user balances. String-encoded integer representing token amount in smallest unit.
addressremovedin__userlog_indexblock_numberblock_timestamptransaction_hashin__working_supplyin__original_supplyin__working_balancein__original_balance
0xc2b75a2ebfc9479efa0ef9c4b013b4fe4b2adf8afalse0x21fbcde968d472ca8ffedef3ef4bafd61e1eb19c0381749702023-11-24T09:26:21.000Z0x63351d406cd03ca8dda25617c19602801ab3a0b6a4dd61efbd289fd8d04f5359560373238586786222182140093309646696555546000
0x74abfe305bc0d729f29a2da26c5b7ef0bd1e3a8cfalse0xc18d92d5d5bf023ada14076fc63498bd62f7fa7f15381621742023-11-24T02:12:23.000Z0x025459495b7bddd6faaf615ea13397a718521b6e5fe21d37a61b8c65d51f7b5e874002328000425329874218500582000106332470600
0x720158c329e6558287c4539b0ed21742b0b73436false0xea7df94f2fb98b0fe8398a00d78c0f8351005d6515381936532023-11-24T19:55:22.000Z0xfa9e180ad24da4c290df378926f52e923666160f207da6d6cc70ac82a4c432083149132211119241078802778726527297079300583824893532610892722930637322338315272318073265934
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ChildChainGauge_UpdateLiquidityLimit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__userSTRINGAddress of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__valueSTRINGAmount 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).
addressremovedin__userin__valuelog_indexblock_numberblock_timestamptransaction_hash
0x11884da90fb4221b3aa288a7741c51ec4fc43b2ffalse0x558afca8d68f6a7335837b06ce218a234978225b8019551686108982417603736335691452023-08-06T12:58:47.000Z0xe4e34b76e6813b3719afbc8b8c9f9f4a73cc7a4af0905632a7ff3bf9ea89c5f9
0x301a121d1d0d72c4005b354854a842a55d23251ffalse0xa1b16cea4f9c0429d45ff70efa821258086c587c170129674293584946013335829062023-08-06T20:45:59.000Z0x424153de5c63bcbfeb458ad12e307b4b93ef1daf686df32f16831aec62206891
0x301a121d1d0d72c4005b354854a842a55d23251ffalse0x9245438524aa65b148bee7dc3625e1082b497a4849767021545616543401864335482352023-08-06T01:14:17.000Z0xd88c493048974c09dfb999b7b37f3a9f6a570b95899e151563947897f9da1e7b
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ChildChainGauge_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_gaugelog_indexblock_numberblock_timestamptransaction_hash
0xf23b4db826dba14c0e857029dff076b1c0264843false0x74abfe305bc0d729f29a2da26c5b7ef0bd1e3a8c23339198602023-08-14T18:41:34.000Z0x8691169d3c2d8741f277008786a1850b93c8d2a020d3596d465ac2a58acb8d3d
0xf23b4db826dba14c0e857029dff076b1c0264843false0x231d84c37b2c4b5a2e2fe325bb77daa65bf71d9213339197902023-08-14T18:39:15.000Z0xb8e2d271deb84f5409508f75bf6b66ca50dff90e1775d0f888f235d917ca4007
0xf23b4db826dba14c0e857029dff076b1c0264843false0x5a9dbaed7921538d16c96510489b16e62a6e79af10339200662023-08-14T18:48:27.000Z0xcfa8b0d3e1faf73fdc17449ec6231dc554f2b327b52d2847a25a80f03f3d00a9
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ChildChainGaugeFactory_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV4_FactoryDisabled_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ComposableStablePoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ComposableStablePoolFactoryV4_PoolCreated_event

Event log emitted when a new composable stable pool is deployed by Balancer V2’s ComposableStablePoolFactoryV4 contract. Records the deployed pool address and factory contract address for tracking pool creation activity across Balancer V2 deployments.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x3b1eb8eb7b43882b385ab30533d9a2bef9052a980xea4643102dfc03d5e382e7827bf767f6587e9965false25292226562023-04-25T23:16:57.000Z0x058e5dab728fd0b341f6b13ea13984821a9fec8473e26df44b61cfeb504ad84f
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ComposableStablePoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0xe42ffa682a26ef8f25891db4882932711d42e467false2472891912024-06-28T11:16:57.000Z0xfd22da05fb0fa76dd9e164d912ebf6434fd4994c76719b418678d12d8f467c99
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ComposableStablePoolFactoryV5_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0xe42ffa682a26ef8f25891db4882932711d42e4670xb26f0e66317846bd5fe0cbaa1d269f0efeb05c96false16339198382023-08-14T18:40:50.000Z0x3b9061cefc69ca19b0f52a7c0b550225c7945a9ed725db636a7ed18a03cbc957
0xe42ffa682a26ef8f25891db4882932711d42e4670x9fa6ab3d78984a69e712730a2227f20bcc8b5ad9false17339199212023-08-14T18:43:36.000Z0x85b22d1224c383daa3a57f02a17ccf409a723c69efe4e611477bc20ffa4b9eed
0xe42ffa682a26ef8f25891db4882932711d42e4670xfd2620c9cfcec7d152467633b3b0ca338d3d78ccfalse25339196912023-08-14T18:35:54.000Z0xd9766781231025ed6658c37f58df1e5a0e39fcb97ba6ec3e0cf601dae63cf906
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ComposableStablePoolFactoryV5_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_protocolIdSTRINGNumeric identifier for the protocol or vault integration associated with the linear pool. String-encoded integer value.
addressin_poolremovedlog_indexblock_numberin_protocolIdblock_timestamptransaction_hash
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba50xed3e2f496cbcd8e212192fb8d1499842f04a0d19false772951348502023-05-02T20:45:17.000Z0x174068905d431373eaba56267351448814b0ec85bfbd263c29bfb0fa00bfd2c7
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba50xeb496161099d45b3ea4892408ef745c6182eb56efalse183251726432023-07-12T19:02:15.000Z0x7b8f77ce84eea537166c9c7cdbe6ff72d67baeea48a7670778ae5c167010fabc
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba50xea67626e1f0b59e0d172a04f5702ef90bcdf440cfalse213251760532023-07-12T19:13:40.000Z0x62f53873579b4ed6c36d830cb04a054ad1e54200a65627e39cbacd3b644fc835
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ERC4626LinearPoolFactoryV4_Erc4626LinearPoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba5false11342557372023-08-22T22:38:31.000Z0x943505c91f5a347627fa8736d9d43d9f36cd5208cadf7ab2575e2257250a0ec3
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ERC4626LinearPoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba50xed3e2f496cbcd8e212192fb8d1499842f04a0d19false72295134852023-05-02T20:45:17.000Z0x174068905d431373eaba56267351448814b0ec85bfbd263c29bfb0fa00bfd2c7
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba50x7275c131b1f67e8b53b4691f92b0e35a4c1c6e22false28325176542023-07-12T19:15:19.000Z0x1d6ce60863afb8af8eab7936d5980adc2a099526c498da4266fd7a9de6f21596
0x4507d91cd2c0d51d9b4f30bf0b93afc938a70ba50xeb496161099d45b3ea4892408ef745c6182eb56efalse13325172642023-07-12T19:02:15.000Z0x7b8f77ce84eea537166c9c7cdbe6ff72d67baeea48a7670778ae5c167010fabc
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ERC4626LinearPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x03f3fb107e74f2eac9358862e91ad3c692712054false91722863032025-11-20T16:00:07.000Z0x70377d05acc02d0cce962a9e82359ed1711ad2452aff26ea658bdbd8e66bb450
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ManagedPoolFactoryV2_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x03f3fb107e74f2eac9358862e91ad3c6927120540x3fb81f6fb0dd94c6fc7e138887f1ca4cdb5e2999false53292217542023-04-25T22:46:10.000Z0x2863b94b65665436e4e59b08cd6cb49df9043caa2dd83194871ae0ffa690449f
0x03f3fb107e74f2eac9358862e91ad3c6927120540xd18a45c72a7362dc4f6be7505604fdd28710bcbdfalse35370705002023-10-29T12:02:59.000Z0x733283d7445f566a3e619c902ca319a618dcc79963da4778ba9e8f7fe309ee3c
0x03f3fb107e74f2eac9358862e91ad3c6927120540x7c6e42aac7494a62eb7b8691e2e2501b6aef7aa0false77383239982023-11-27T21:19:17.000Z0x36f52dbb6b32bd26093bee0c49d3c1b1714eea23ce0add2e9e5a15524efb1a31
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ManagedPoolFactoryV2_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.NoProtocolFeeLiquidityBootstrappingPoolFactory_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e0x32f0dc9e2d890bac95106a65eb82db70bc58badbfalse14288567732023-04-17T08:27:44.000Z0x2544d5a20195055112ffad9dd255e8b7c8b5c38719a0782bb7b9dd52abf27f4c
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e0xf1b3256505159f6004da0b16e985ee46e6ffeea8false61296396802023-05-05T20:03:20.000Z0x7e0339a2280d2d3912b256199edb1ea9fad60997629676962f80c59a0af506d0
0x0f3e0c4218b7b0108a3643cfe9d3ec0d4f57c54e0xbccd9d4b953ada653b7c464665d7263e5e078a98false10267353072023-02-25T23:20:39.000Z0x6692e6ebdc821bb511c6639a69da8bc94213e17c1378d85cb6fef2d51d55ea37
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.NoProtocolFeeLiquidityBootstrappingPoolFactory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_RecoveryModeStateChanged_event

Balancer V2 pool recovery mode state change events emitted when pools enter or exit recovery mode. The in_enabled flag indicates whether recovery mode was activated or deactivated for emergency liquidity withdrawals.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_enabledBOOLBoolean flag indicating whether recovery mode or the collector is enabled.
addressremovedlog_indexin_enabledblock_numberblock_timestamptransaction_hash
0x3f1a2c4a3a751f6626bd90ef16e104f0772d4d6bfalse19true342430202023-08-22T15:04:12.000Z0x8076eecaf826db62ba5b6630258074ac7736cb70b3f16814a98f57022ac03ccf
0x054e7b0c73e1ee5aed6864fa511658fc2b54bcaafalse10true342429792023-08-22T15:02:37.000Z0xb053203def9493233c48f989a522f8bf13ee1580779aff6e9d7e134015fbcf17
0x7275c131b1f67e8b53b4691f92b0e35a4c1c6e22false11true342429792023-08-22T15:02:37.000Z0xb053203def9493233c48f989a522f8bf13ee1580779aff6e9d7e134015fbcf17
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.Pool_RecoveryModeStateChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_SwapFeePercentageChanged_event

Event logs recording swap fee percentage updates for Balancer V2 and Beethoven X liquidity pools. Emitted when pool administrators modify the fee rate charged on token swaps, stored as a wei-denominated percentage where 1e18 equals 100%.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_swapFeePercentageSTRINGSwap fee charged on the transaction expressed as a percentage. Numeric string in wei representing the fee rate, where 1e18 equals 100%.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_swapFeePercentage
0x3fc26a34594ec8adfd9431ff3b9e8fce00bedd19false4373786562023-11-05T18:54:15.000Z0x7d5d1a65a1ac8fced85dc98ece1f627dd1f9a762ef5ced06e7f74f1de6e86f223000000000000000
0x90065d5e455e6b26a4eaf630c26289f6b6735647false17333601492023-08-01T15:27:17.000Z0xcf9dba22abe6753bbb166fdd952934ca4ec8d4a9fca82e896247c557f0282b991000000000000000
0xa826a114b0c7db4d1ff4a4be845a78998c64564cfalse30295126832023-05-02T20:16:34.000Z0xf137340008c7897487853f68d28f2c37cbb4aed67e31feaac10c9f9e43687c891000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.Pool_SwapFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Transfer_event

Liquidity pool token transfer events emitted when LP (Liquidity Provider) tokens are minted, burned, or transferred between addresses. Contains sender, recipient, and token amount for tracking pool share ownership and liquidity position changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c80x054e7b0c73e1ee5aed6864fa511658fc2b54bcaa0xea00fc641a817e5f3eded4743aac7ab08dbf74b0false19977554838603980225039341968312023-08-21T11:36:34.000Z0x0297c6f525ebbd1008424a83cae0809966c1b83d632f184092b18f8391844a35
0xce88686553686da562ce7cea497ce749da109f9f0x054e7b0c73e1ee5aed6864fa511658fc2b54bcaa0x0000000000000000000000000000000000000000false501133665722673646341968312023-08-21T11:36:34.000Z0x0297c6f525ebbd1008424a83cae0809966c1b83d632f184092b18f8391844a35
0xce88686553686da562ce7cea497ce749da109f9f0x054e7b0c73e1ee5aed6864fa511658fc2b54bcaa0x0000000000000000000000000000000000000000false1230177073859759512341922332023-08-21T08:48:25.000Z0x14d4d1dc51ac0c14b8e8576663f367d493273927027c216ec2dc1eface507f2c
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.Pool_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ProtocolFeesCollector_FlashLoanFeePercentageChanged_event

Event logs capturing flash loan fee percentage updates in the Balancer V2 Protocol Fees Collector contract. Records the new fee percentage value whenever protocol governance modifies the flash loan borrowing cost.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newFlashLoanFeePercentageSTRINGNew flash loan fee percentage for the Balancer protocol. String-encoded integer value representing the fee in basis points with 18 decimal places of precision.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ProtocolFeesCollector_FlashLoanFeePercentageChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ProtocolFeesCollector_SwapFeePercentageChanged_event

Protocol fee percentage update events emitted by Balancer V2 ProtocolFeesCollector contracts. Records changes to the swap fee percentage charged on protocol-level transactions, with the new percentage value stored as a wei-denominated string.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newSwapFeePercentageSTRINGNew swap fee percentage for the protocol. 18-decimal fixed-point integer represented as a string, where 1e18 equals 100%.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_newSwapFeePercentage
0xce88686553686da562ce7cea497ce749da109f9ffalse84313179492023-06-14T11:23:50.000Z0x0cf6e6043c2dbf246e9a966835c75b77c86e9f18b03710b7193ac6d935e62e59500000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.ProtocolFeesCollector_SwapFeePercentageChanged_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newAuthorizerSTRINGAddress of the new authorizer contract set for the Balancer vault. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedlog_indexblock_numberblock_timestampin_newAuthorizertransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false1263861412023-02-17T19:04:56.000Z0xa331d84ec860bf466b4cdccfb4ac09a1b43f3ae60xc49af0372feb032e0edbba6988410304566b1fd65546c01ced620ac3c934120f
0xba12222222228d8ba445958a75a0704d566bf2c8false95313179492023-06-14T11:23:50.000Z0x8df317a729fcaa260306d7de28888932cb579b880x0cf6e6043c2dbf246e9a966835c75b77c86e9f18b03710b7193ac6d935e62e59
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_tokenin_amountin_senderlog_indexblock_numberin_recipientblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0x759a2e28d4c3ad394d3125d5ab75a6a5d6782fd91313484640xd3a5e4b35aaa9366b68df937867602d1e6aee7f41349476110x03f1ab8b19bce21eb06c364aec9e40322572a1e92023-09-09T03:49:29.000Z0xd6a4940e17bd8e58c88b6774fca05aa52d78447cdfab9e1561ccccac41e5ec73
0xba12222222228d8ba445958a75a0704d566bf2c8false0xe7839ea8ea8543c7f5d9c9d7269c661904729fe7144701520xd3a5e4b35aaa9366b68df937867602d1e6aee7f415349476520x03f1ab8b19bce21eb06c364aec9e40322572a1e92023-09-09T03:50:56.000Z0x2aad078874c6141de27bcfe4be1c21b04120b1c89f6ca67c1bd303799b6fec77
0xba12222222228d8ba445958a75a0704d566bf2c8false0xa291ae608d8854cdbf9838e28e9badcf1018166940557633696086771420x88bb4f02687695ef98dcfa33c270b32d1fa15d962348884480x03f1ab8b19bce21eb06c364aec9e40322572a1e92023-09-07T17:21:53.000Z0xc9ca38408d8a7069a0c1317060150dc0d8677abab605bc6fc28a5ada57aa4834
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_feeAmountSTRINGFee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
addressremovedin_tokenin_amountlog_indexblock_numberin_feeAmountin_recipientblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb31f66aa3c1e785363f0875a1b74e27b85fd66c76798472575533360822553766435500x003c287946ca5764ccd12288dddcdb0bc7c5fb4b2023-11-12T11:30:11.000Z0x26ff3967c5cfe94a4e542495d02c6295f6c04673ffa98bd2e8bb65c6bda96e2a
0xba12222222228d8ba445958a75a0704d566bf2c8false0x152b9d0fdc40c096757f570a51e494bd4b943e50934452823766137000x1281dc864b3b1aa5103b792481e58d35e54308c32023-11-12T09:50:09.000Z0x8f3d48f29982da40bb5e17fd14a933a294eab32bbe47aa76b3a2b873ba645da4
0xba12222222228d8ba445958a75a0704d566bf2c8false0x152b9d0fdc40c096757f570a51e494bd4b943e5013210861363766127100x1281dc864b3b1aa5103b792481e58d35e54308c32023-11-12T09:46:49.000Z0xb1ab7fd13d393b726cac5a5614e80fd4aedebfcdc98537ab9d17b2b6f3a75184
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_deltaSTRINGChange 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.
addressin_userremovedin_deltain_tokenlog_indexblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c80x03f1ab8b19bce21eb06c364aec9e40322572a1e9false-2226352473028969816470x7275c131b1f67e8b53b4691f92b0e35a4c1c6e2213338311982023-08-12T16:33:06.000Z0x7d5fd897a8bc819dbceab845986f34ef6cdb03890af04a26e06ca5996709e039
0xba12222222228d8ba445958a75a0704d566bf2c80x03f1ab8b19bce21eb06c364aec9e40322572a1e9false2226352473028969816470x7275c131b1f67e8b53b4691f92b0e35a4c1c6e227338311982023-08-12T16:33:06.000Z0x7d5fd897a8bc819dbceab845986f34ef6cdb03890af04a26e06ca5996709e039
0xba12222222228d8ba445958a75a0704d566bf2c80x82b5bbfbbd016bae0af9bba9fdfc3bd0cd409e7ffalse00x7275c131b1f67e8b53b4691f92b0e35a4c1c6e2211338174142023-08-12T08:50:12.000Z0x7ecd6c89beef93f9dbd85c0bc18939d644ca8029d7d3a26c12c2cc677fca6091
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_pausedBOOLBoolean flag indicating whether the paused state is active. True indicates the contract or program is paused, false indicates it is active.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_liquidityProviderSTRINGAddress of the liquidity provider adding or removing funds from the pool. Hex-encoded, 0x-prefixed, 42-character string.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
in_deltasARRAY<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_protocolFeeAmountsARRAY<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.
addressremovedin_deltasin_poolIdin_tokenslog_indexblock_numberblock_timestamptransaction_hashin_liquidityProviderin_protocolFeeAmounts
0xba12222222228d8ba445958a75a0704d566bf2c8false[“-131353760372721435797”,“-56749686929879949844”,“0”]0xa154009870e9b6431305f19b09f9cfd7284d4e7a000000000000000000000013[“0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be”,“0x7275c131b1f67e8b53b4691f92b0e35a4c1c6e22”,“0xa154009870e9b6431305f19b09f9cfd7284d4e7a”]20348330172023-09-06T08:20:03.000Z0x70531602c487e2f7337705b2869898cab69586637afe965314cc14cd546fc23b0x99ee6d18708fe26192c943897f3d0d7c45b628d8[“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8false[“0”,“1290000000000000000000”,“0”]0xfd2620c9cfcec7d152467633b3b0ca338d3d78cc00000000000000000000001c[“0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be”,“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”,“0xfd2620c9cfcec7d152467633b3b0ca338d3d78cc”]10348200492023-09-06T00:31:44.000Z0xadbb91232e5a7e176ecb7f34181fb38b5aec9b00790c20aea205bc678c6d241d0xc2d3259640b7ac40ddf5ea11220eb631d325cd6d[“0”,“0”,“0”]
0xba12222222228d8ba445958a75a0704d566bf2c8false[“0”,“-19838677648847925342”,“0”]0xfd2620c9cfcec7d152467633b3b0ca338d3d78cc00000000000000000000001c[“0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be”,“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”,“0xfd2620c9cfcec7d152467633b3b0ca338d3d78cc”]41348446852023-09-06T15:13:15.000Z0x489a0dcf0118dd13a4dedf86f9848c62429d67584d5de24999c4dcd549d39c8e0x318a410a22941ecb72391046e8a81482f14bb5da[“0”,“0”,“0”]
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_assetManagerSTRINGContract address of the asset manager responsible for managing pool token balances. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_cashDeltaSTRINGChange in token balance available to the pool’s vault for immediate operations. String-encoded signed integer representing token units.
in_managedDeltaSTRINGChange in token balance managed by the asset manager outside the vault’s immediate liquidity pool. String-encoded signed integer representing token units.
addressremovedin_tokenin_poolIdlog_indexblock_numberin_cashDeltablock_timestampin_assetManagerin_managedDeltatransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb279f8dd152b99ec1d84a489d32c35bc0c7f56740x7c6e42aac7494a62eb7b8691e2e2501b6aef7aa00001000000000000000000323138701373680969177387040161222023-12-06T17:30:56.000Z0x583816b37b6c5dbdc23f6672b39b4ef814091a09-680969177387040161220xde132d1ba4e6e945c9320233ac698f82f25a4f1006dd18c0bb5f5115aad5ea86
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb279f8dd152b99ec1d84a489d32c35bc0c7f56740x7c6e42aac7494a62eb7b8691e2e2501b6aef7aa0000100000000000000000032293870137302023-12-06T17:30:56.000Z0x583816b37b6c5dbdc23f6672b39b4ef814091a09680969177387040161220xde132d1ba4e6e945c9320233ac698f82f25a4f1006dd18c0bb5f5115aad5ea86
0xba12222222228d8ba445958a75a0704d566bf2c8false0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc40x7c6e42aac7494a62eb7b8691e2e2501b6aef7aa000010000000000000000003255387014381366752407908054670502023-12-06T17:33:05.000Z0x583816b37b6c5dbdc23f6672b39b4ef814091a09-1366752407908054670500x10c5923861a15ae1d5be49527fdcd070be0665842d9ab22d8c22d11e6ee1afba
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_poolAddressSTRINGContract address of the liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
in_specializationINT64Pool 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).
addressremovedin_poolIdlog_indexblock_numberin_poolAddressblock_timestamptransaction_hashin_specialization
0xba12222222228d8ba445958a75a0704d566bf2c8false0xdbcadaaaab7f4c37539a9538b838836dffd50d0e0002000000000000000000221347595300xdbcadaaaab7f4c37539a9538b838836dffd50d0e2023-09-04T12:01:46.000Z0x8dd05f09fc9ec4daefe4c22360f187af9d4ac4b1600f438adbfd35f85cc9e12c2
0xba12222222228d8ba445958a75a0704d566bf2c8false0x3441a6f48f0f5a1ada460885df5b461deb2ee4940002000000000000000000241352579340x3441a6f48f0f5a1ada460885df5b461deb2ee4942023-09-16T11:41:13.000Z0x649dc52eae805f68893d1184296ad683afe1be09b6995ba40697c92c399dbbc42
0xba12222222228d8ba445958a75a0704d566bf2c8false0xd9710759d76b0c46b3b1a1d2aec087ee7fddf3940001000000000000000000234352523960xd9710759d76b0c46b3b1a1d2aec087ee7fddf3942023-09-16T08:34:43.000Z0xc69d56546fd0947c009d297130fda164ed3cf194ac386101fd0fcce804bd72171
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_relayerSTRINGAddress of the relayer executing the cross-chain transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_approvedBOOLBoolean flag indicating whether approval was granted or revoked for the operation.
addressremovedin_senderlog_indexin_relayerin_approvedblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xdee01df93184c42447448ce2c85248e0b3b4f5c040x03f1ab8b19bce21eb06c364aec9e40322572a1e9true337131152023-08-09T22:11:57.000Z0xe107774045752163a30405c9bb430162849e0355463f659f08a9328ca67c29d6
0xba12222222228d8ba445958a75a0704d566bf2c8false0x725e052c654f3e55a843e0033a1470289ddd020a50x03f1ab8b19bce21eb06c364aec9e40322572a1e9true336932072023-08-09T11:01:57.000Z0x94136edc61f2bdc10a18df66cb4d8291eb30c6a455f5a91a294e4bb74f572d38
0xba12222222228d8ba445958a75a0704d566bf2c8false0x536dd41d6137e86cc61b82bf1ff6bd7bfe0a5ae850x03f1ab8b19bce21eb06c364aec9e40322572a1e9true336874512023-08-09T07:48:30.000Z0x6f2ac0235757ca18ef7fb3f61569f93b64f7d1d965a08edd61e43eeebcaceda1
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_tokenInSTRINGContract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenOutSTRINGContract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_amountInSTRINGAmount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
in_amountOutSTRINGAmount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
addressremovedin_poolIdlog_indexin_tokenInin_amountInin_tokenOutblock_numberin_amountOutblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0x054e7b0c73e1ee5aed6864fa511658fc2b54bcaa00000000000000000000001590xa25eaf2906fa1a3a13edac9b9657108af7b703e368282521056095496670x054e7b0c73e1ee5aed6864fa511658fc2b54bcaa3420714168900923482072958182023-08-21T17:45:46.000Z0x86f50135d933451c004b48c9afca74e87dd14f1d3b4c59d98295523ae35569c3
0xba12222222228d8ba445958a75a0704d566bf2c8false0x3f1a2c4a3a751f6626bd90ef16e104f0772d4d6b00020000000000000000001b110xa1d14d922a575232066520eda11e27760946c9913479613302089621438810x152b9d0fdc40c096757f570a51e494bd4b943e503421583013248702023-08-21T22:54:17.000Z0x3e4e2ed410f775132694cb39beeb925a406f8a5c02b279e422852d1e4cb08f63
0xba12222222228d8ba445958a75a0704d566bf2c8false0x3f1a2c4a3a751f6626bd90ef16e104f0772d4d6b00020000000000000000001b820xa1d14d922a575232066520eda11e27760946c991884537087072506746240x152b9d0fdc40c096757f570a51e494bd4b943e50342161093390382023-08-21T23:04:31.000Z0x0976d627a44f169aa50ca4052b746e2bb273d44c95d7ac0c85d62639743a4561
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
addressremovedin_poolIdin_tokenslog_indexblock_numberblock_timestamptransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0x856561c3b21efca7e483b1ad197e4ab5fb56ccdb000100000000000000000048[“0xf32398dae246c5f672b52a54e9b413dffcae1a44”]7485884542024-07-29T14:40:55.000Z0x121ec4d66aa790d022189e460f0fcde587bd9285f2f9f67a73f482be4884f11b
0xba12222222228d8ba445958a75a0704d566bf2c8false0x956ff4e3f61344da97ff3438254a2374cd40cad900010000000000000000003f[“0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4”]12415031742024-02-10T17:34:31.000Z0x958d1a5d96c88ce4198dcb162aabda8dc35a03ee108508fe1bc8d0f76bc086a5
0xba12222222228d8ba445958a75a0704d566bf2c8false0x956ff4e3f61344da97ff3438254a2374cd40cad900010000000000000000003f[“0x60781c2586d68229fde47564546784ab3faca982”]16414908042024-02-10T10:39:21.000Z0x07f6c3c99dc7b756350e04c48bc277f4b0569a694e48be0aebaf4be5c3470d70
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
in_assetManagersARRAY<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.
addressremovedin_poolIdin_tokenslog_indexblock_numberblock_timestampin_assetManagerstransaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8false0xab567c27450e3fa1b4ee4e67ca7d1003c49e7ea800020000000000000000002b[“0x152b9d0fdc40c096757f570a51e494bd4b943e50”,“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”]8366890322023-10-20T11:46:21.000Z[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]0xabad39f7a31860d333afb73d2eeeaa43b1e04dd7eb95e24a3ec382a4122c2f24
0xba12222222228d8ba445958a75a0704d566bf2c8false0xb06fdbd2941d2f42d60accee85086198ac72923600020000000000000000001a[“0x502580fc390606b47fc3b741d6d49909383c28a9”,“0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7”]16334217492023-08-03T02:08:57.000Z[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]0xd832ce2f476c6b1cb8e9515a328b8ac3d3b92f86b2ceb008f6215a2e75d4a953
0xba12222222228d8ba445958a75a0704d566bf2c8false0x66bb9d104c55861feb3ec3559433f01f6373c96600020000000000000000002a[“0x228a48df6819ccc2eca01e2192ebafffdad56c19”,“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”]7366312332023-10-19T03:00:53.000Z[“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]0xec69f6135acf13a181c9d130102ec0cf398a284731d349024af9afd4c3cb45a2
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.Vault_TokensRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV3_FactoryDisabled_event

Event log emitted when a Balancer V2 Weighted Pool Factory V3 contract is disabled. Records factory contract deactivation for tracking protocol governance actions and factory lifecycle management.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.WeightedPoolFactoryV3_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV3_PoolCreated_event

Pool creation events emitted by Balancer V2 WeightedPoolFactory V3 contracts. Records the address of newly deployed weighted liquidity pools from the factory contract.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x94f68b54191f62f781fe8298a8a5fa3ed772d2270xe867ad0a48e8f815dc0cda2cdb275e0f163a480bfalse20263892442023-02-17T20:49:07.000Z0xeeede9c3d51ea5526ebf7ad511a7bb45ee62cc6fed7932d48a91d29022276cb3
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.WeightedPoolFactoryV3_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
addressremovedlog_indexblock_numberblock_timestamptransaction_hash
0x230a59f4d9adc147480f03b0d3fffecd56c3289afalse90722863032025-11-20T16:00:07.000Z0x70377d05acc02d0cce962a9e82359ed1711ad2452aff26ea658bdbd8e66bb450
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.WeightedPoolFactoryV4_FactoryDisabled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WeightedPoolFactoryV4_PoolCreated_event

Event logs emitted by Balancer V2 WeightedPoolFactory version 4 contracts when new weighted pools are deployed. Records the deployed pool address and factory contract address for tracking pool creation across Balancer protocol instances.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
addressin_poolremovedlog_indexblock_numberblock_timestamptransaction_hash
0x230a59f4d9adc147480f03b0d3fffecd56c3289a0x3396cca90c9335565ecdbae3a260dafb13a7959efalse19332220582023-07-29T09:26:34.000Z0x8e1f33c60645d41d4a412d47c3b331a288cce4821c3c7fe672cfb2c45372b4e2
0x230a59f4d9adc147480f03b0d3fffecd56c3289a0x3441a6f48f0f5a1ada460885df5b461deb2ee494false6352579342023-09-16T11:41:13.000Z0x649dc52eae805f68893d1184296ad683afe1be09b6995ba40697c92c399dbbc4
0x230a59f4d9adc147480f03b0d3fffecd56c3289a0xd9710759d76b0c46b3b1a1d2aec087ee7fddf394false9352523962023-09-16T08:34:43.000Z0xc69d56546fd0947c009d297130fda164ed3cf194ac386101fd0fcce804bd7217
Query with partition filter
SELECT *
FROM `tt-contracts.balancer_v2_avalanche.WeightedPoolFactoryV4_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100