> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# balancer_v1_ethereum
> Tables in tt-contracts.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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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).
| 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. |
| gas | value | status | gas\_used | signature | in\_swapFee | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ----- | ------ | --------- | ---------- | ----------------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 1128857 | 0 | true | 9275 | 0x34e19907 | 10000000000000000 | 0x6f518b88234aa3727b0cd98122270769aba9c32b | 10903698 | 0xc71c003839075acb1a1e934188c5cd88c881b1f7 | 0,1 | 2020-09-21T04:51:05.000Z | 0x1519737f63dcf26a8fcf4962898d5de592ce8549c594c25507048bedbc8c81b1 |
| 1636599 | 0 | true | 9275 | 0x34e19907 | 10000000000000000 | 0x7b9ad04a09da6dd2e530fb17d323b31e9486ef4b | 10907186 | 0xe1ce31103a400f09e213e39436af78274ba17537 | 0,1 | 2020-09-21T17:30:45.000Z | 0xb8ca905bd0a94c4ac5a8c5bddc3405899a26e4105031f813d70528459a130906 |
| 1121345 | 0 | true | 9275 | 0x34e19907 | 1500000000000000 | 0xb364fa80ecc585280213a8c951859e9b032727ca | 10904637 | 0x8fc18139e841f763fdab95bdf7e9e5a56f88e6bc | 0,1 | 2020-09-21T08:24:08.000Z | 0x7151ed17e72843884fa8ab178dda98a29cb56f2228b1c76d00b1e4bafcbda6dd |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.balancer_v1_ethereum.GnosisRootGauge_Checkpoint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***