balancer_v1_ethereum

Tables

BaseRootGauge_Checkpoint_event

Checkpoint events from Balancer V1 liquidity gauge contracts on Ethereum recording periodic token emissions distributed to liquidity providers. Used for tracking BAL (Balancer governance token) reward distribution schedules and analyzing incentive programs across different gauge addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash	in_periodEmissions
0xed0bb13496ce24efff8f9734a9707d092d4be10c	false	773	18330652	1696464000	2023-10-12T00:05:35.000Z	0x0b6523f59cd08453ad3f0b7a3b2ecbdb02c0fb277e85fabe4501541bc67bb053	11983507389256538816913
0xe9b2cb6836be07357bcb8144f398730d5ec268e9	false	761	18330652	1696464000	2023-10-12T00:05:35.000Z	0x0b6523f59cd08453ad3f0b7a3b2ecbdb02c0fb277e85fabe4501541bc67bb053	126292505845023584591
0xeff145872582721e1b33931d61c3fe9c1ca66690	false	785	18330652	1696464000	2023-10-12T00:05:35.000Z	0x0b6523f59cd08453ad3f0b7a3b2ecbdb02c0fb277e85fabe4501541bc67bb053	112417834967436603801

Example Query

Query with partition filter

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

BPool_LOG_SWAP_event

Swap event logs from Balancer V1 liquidity pools on Ethereum, capturing token exchanges with input/output amounts, tokens, and caller addresses. Used for analyzing trading volume, price impact, and liquidity utilization across Balancer pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmountIn`	`STRING`	Amount of the input token transferred into the Balancer V1 pool during the swap, denominated in the token’s smallest unit (wei for most ERC-20 tokens). This value represents the exact quantity sold by the trader before any fees or slippage.
`in_tokenAmountOut`	`STRING`	Amount of the output token received by the swap caller, denominated in the token’s smallest unit (wei for ERC-20 tokens). Values are raw integers without decimal adjustment, requiring division by the token’s decimals for human-readable amounts.

Sample Data

address	removed	in_caller	log_index	in_tokenIn	in_tokenOut	block_number	block_timestamp	in_tokenAmountIn	transaction_hash	in_tokenAmountOut
0xd262e43273ca96214bb02b4036a1f24ad9806739	false	0x6317c5e82a06e1d8bf200d21f4510ac2c038ac81	63	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	9697714	2020-03-18T20:17:30.000Z	30389873966626106	0x0c5d4b22d087f445f1a58a14888f4454095c17b2a123d6bc8c58f7ffa1016435	19503236418344578
0x987d7cc04652710b74fff380403f5c02f82e290a	false	0x6317c5e82a06e1d8bf200d21f4510ac2c038ac81	67	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	9697714	2020-03-18T20:17:30.000Z	10140838773198817	0x0c5d4b22d087f445f1a58a14888f4454095c17b2a123d6bc8c58f7ffa1016435	6664878550537387
0xe5d1fab0c5596ef846dcc0958d6d0b20e1ec4498	false	0x6317c5e82a06e1d8bf200d21f4510ac2c038ac81	71	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2	9697714	2020-03-18T20:17:30.000Z	9469287260175077	0x0c5d4b22d087f445f1a58a14888f4454095c17b2a123d6bc8c58f7ffa1016435	6343347370594412

Example Query

Query with partition filter

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

BPool_setSwapFee_function

Transaction-level records of swap fee updates on Balancer V1 liquidity pools on Ethereum. Tracks pool controller actions changing fee percentages (in_swapFee as wei-denominated values, typically 0.1-1% of trades).

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_swapFee`	`STRING`	Fee charged for executing the swap transaction. String-encoded integer value representing the fee amount in the smallest denomination of the token.

Sample Data

gas	status	gas_used	signature	in_swapFee	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1128857	true	9275	0x34e19907	10000000000000000	0x6f518b88234aa3727b0cd98122270769aba9c32b	10903698	0xc71c003839075acb1a1e934188c5cd88c881b1f7	0,1	2020-09-21T04:51:05.000Z	0x1519737f63dcf26a8fcf4962898d5de592ce8549c594c25507048bedbc8c81b1
1636599	true	9275	0x34e19907	10000000000000000	0x7b9ad04a09da6dd2e530fb17d323b31e9486ef4b	10907186	0xe1ce31103a400f09e213e39436af78274ba17537	0,1	2020-09-21T17:30:45.000Z	0xb8ca905bd0a94c4ac5a8c5bddc3405899a26e4105031f813d70528459a130906
1121345	true	9275	0x34e19907	1500000000000000	0xb364fa80ecc585280213a8c951859e9b032727ca	10904637	0x8fc18139e841f763fdab95bdf7e9e5a56f88e6bc	0,1	2020-09-21T08:24:08.000Z	0x7151ed17e72843884fa8ab178dda98a29cb56f2228b1c76d00b1e4bafcbda6dd

Example Query

Query with partition filter

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

BPoolFactory_LOG_NEW_POOL_event

Pool creation events from Balancer V1 factory contract on Ethereum. Tracks new liquidity pool deployments with pool addresses and creator accounts for analyzing Balancer V1 pool launch activity.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_caller	log_index	block_number	block_timestamp	transaction_hash
0x9424b1412450d0f8fc2255faf6046b98213b76bd	0xa5910940b97b7b8771a01b202583fd9331cb8be3	false	0x13c6771d30b0877d01eb729d73c3ab9fa09ab2b6	34	10477840	2020-07-17T15:34:54.000Z	0x214e1e64f86d99eec48a780c0393f7a911798abefe97287f9baeb93d4399a226
0x9424b1412450d0f8fc2255faf6046b98213b76bd	0x159a2d68c57efa0474d1f322173295e95ecc1e9a	false	0xa170834ca5627505b52190667caf8758fde2388c	40	10475879	2020-07-17T08:32:32.000Z	0x24909733ee82e6e104a7e42a4fb0045bc527dae7da698b5e9b3aa6e4fdbedd42
0x9424b1412450d0f8fc2255faf6046b98213b76bd	0xe26a220a341eaca116bda64cf9d5638a935ae629	false	0x1c4cc5be82e1d1c498864c298b35e1f39f96de17	40	10479606	2020-07-17T22:18:36.000Z	0x2f71958e04099b66996d4f02b8b081020113c5b8ea5286dd68a8588fef006b5b

Example Query

Query with partition filter

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

GnosisRootGauge_Checkpoint_event

Checkpoint events from Balancer V1’s Gnosis root gauge contracts on Ethereum recording periodic token emissions for cross-chain liquidity incentives. Used for tracking BAL (Balancer) token distribution amounts and timing across gauge addresses deployed to Gnosis Chain.

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_periodTime`	`STRING`	Unix timestamp marking the start of the emission period for which tokens are being distributed. String representation of seconds since epoch (January 1, 1970 UTC).
`in_periodEmissions`	`STRING`	Amount of token emissions distributed during the time period. String representation of an integer value measured in the token’s smallest unit (wei).

Sample Data

address	removed	log_index	block_number	in_periodTime	block_timestamp	transaction_hash	in_periodEmissions
0xf8c85bd74fee26831336b51a90587145391a27ba	false	201	18980006	1704326400	2024-01-11T00:05:47.000Z	0x0723bb3ce9d6ad75af4e0058055112e0df73591f8ea5d34be4a3bd7d722c9ec3	1286769679386958956624
0x346f1d4f98f055bb0791465923e27a10f1082912	false	228	18980006	1704326400	2024-01-11T00:05:47.000Z	0x0723bb3ce9d6ad75af4e0058055112e0df73591f8ea5d34be4a3bd7d722c9ec3	1941231244192139801509
0x93ae6971f03ce890fa4e9274ab441477b84dae5f	false	183	18980006	1704326400	2024-01-11T00:05:47.000Z	0x0723bb3ce9d6ad75af4e0058055112e0df73591f8ea5d34be4a3bd7d722c9ec3	513149274492115778136

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BaseRootGauge_Checkpoint_event

BPool_LOG_SWAP_event

BPool_setSwapFee_function

BPoolFactory_LOG_NEW_POOL_event

GnosisRootGauge_Checkpoint_event

​Tables

​BaseRootGauge_Checkpoint_event

​BPool_LOG_SWAP_event

​BPool_setSwapFee_function

​BPoolFactory_LOG_NEW_POOL_event

​GnosisRootGauge_Checkpoint_event

Tables

BaseRootGauge_Checkpoint_event

BPool_LOG_SWAP_event

BPool_setSwapFee_function

BPoolFactory_LOG_NEW_POOL_event

GnosisRootGauge_Checkpoint_event