> ## 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.
# bancor_v1_ethereum
> Tables in tt-contracts.bancor_v1_ethereum
## Tables
### AutoCompoundingRewards\_RewardsDistributed\_event
Reward distribution events from Bancor v1's auto-compounding rewards contract on Ethereum, tracking periodic reward payouts to liquidity pools with amounts distributed, pool token quantities, and remaining reward balances. Used for analyzing liquidity mining incentives and reward accumulation patterns across Bancor 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_rewardsAmount` | `STRING` | Amount of rewards being distributed or received. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_poolTokenAmount` | `STRING` | Amount of pool tokens involved in the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_remainingRewards` | `STRING` | Remaining reward tokens in the pool after this distribution event. Stored as a string-encoded integer representing the token amount in smallest denomination (wei for ERC-20 tokens). |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | in\_rewardsAmount | transaction\_hash | in\_poolTokenAmount | in\_remainingRewards |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------ |
| 0x036f8b31d78ca354ada40dbd117e54f78b6f6cdc | 0x939b462ee3311f8926c047d2b576c389092b1649 | false | 54 | 16846339 | 2023-03-17T08:26:35.000Z | 1231196989 | 0x823247f3c8c13556caff54f7b74334431f6cd5276dcabc56e16e6d6efa75f810 | 1473740141 | 226686569572 |
| 0x036f8b31d78ca354ada40dbd117e54f78b6f6cdc | 0xb2cabf797bc907b049e4ccb5b84d13be3a8cfc21 | false | 57 | 16846339 | 2023-03-17T08:26:35.000Z | 101938561604339159845090 | 0x823247f3c8c13556caff54f7b74334431f6cd5276dcabc56e16e6d6efa75f810 | 19467749506108522328934 | 80074077297266491667704 |
| 0x036f8b31d78ca354ada40dbd117e54f78b6f6cdc | 0x444d6088b0f625f8c20192623b3c43001135e0fa | false | 60 | 16846339 | 2023-03-17T08:26:35.000Z | 133693413515034631494613 | 0x823247f3c8c13556caff54f7b74334431f6cd5276dcabc56e16e6d6efa75f810 | 108806723349985478071016 | 561803759520228764649285 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.AutoCompoundingRewards_RewardsDistributed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_deposit\_function
Token deposit function calls to Bancor V1 liquidity pools on Ethereum. Records token amounts deposited, pool addresses, and output amounts returned for analyzing liquidity provision 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. |
| `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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenAmount` | `STRING` | Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | in\_pool | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | in\_tokenAmount | block\_timestamp | transaction\_hash |
| ------ | ---------------- | ------ | ------------------------------------------ | --------- | ------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------ | ------------------------ | ------------------------------------------------------------------ |
| 269899 | 1000000000000000 | true | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 257669 | 996848882340308 | 0x47e7ef24 | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 17869028 | 0x305938c5c6abb6440f1402cc7488b56fed153c0e | | 1000000000000000 | 2023-08-08T08:31:47.000Z | 0xcf29704afd33a20333cf2e680ef623698d6161bbfa28f034210587712c726cb7 |
| 192897 | 0 | true | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 185416 | 298497 | 0x47e7ef24 | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 17869036 | 0x305938c5c6abb6440f1402cc7488b56fed153c0e | | 300000 | 2023-08-08T08:33:23.000Z | 0xfa2fbd3d879dc1346224fceeae16e599f5c5827654c45e34bb7ed5d44e084bf1 |
| 148144 | 0 | true | 0x6b3595068778dd592e39a122f4f5a5cf09c90fe2 | 141363 | 300000000000000000 | 0x47e7ef24 | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 17869031 | 0x305938c5c6abb6440f1402cc7488b56fed153c0e | | 300000000000000000 | 2023-08-08T08:32:23.000Z | 0x970c912e5e4f095e644bd4385aedae8133ffdf6d6910c633b5e3cc21d14df14d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_depositFor\_function
Liquidity deposits into Bancor V1 pools on Ethereum via the depositFor function, recording token amounts, pool addresses, and returned position amounts. Used for tracking liquidity provider activity and position sizing across Bancor liquidity 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. |
| `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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. 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. |
| `in_tokenAmount` | `STRING` | Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | in\_pool | gas\_used | out\_anon0 | signature | to\_address | in\_provider | block\_number | from\_address | trace\_address | in\_tokenAmount | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | ------------------------------------------ | --------- | ------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 657649 | 0 | false | | 43885 | | 0xb3db428b | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | | 14716922 | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 0,4 | | 2022-05-05T11:11:46.000Z | 0x047ed3e2dee6473174cc54f63a3ac384b97be327772136ee2ba638267af8501a |
| 657649 | 0 | true | 0x6b175474e89094c44da98b954eedeac495271d0f | 92049 | 599931107089467535941779 | 0xb3db428b | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 14716924 | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 0,4 | 600000000000000000000000 | 2022-05-05T11:12:53.000Z | 0xd845fc3b5bc7d4a681dce1b5a5eb850ac37311223a8150414c0310044088dfaa |
| 657637 | 0 | true | 0x6b175474e89094c44da98b954eedeac495271d0f | 92049 | 499942589241222946618149 | 0xb3db428b | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 14717215 | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 0,4 | 500000000000000000000000 | 2022-05-05T12:17:40.000Z | 0x82ea96b15884561d4835417c86ca87bfbc0e46b1f933e2c23727562f25033de8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_depositFor_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_FlashLoanCompleted\_event
Completed flash loan events from Bancor V1 protocol on Ethereum, recording borrowed token amounts and associated fees charged to borrowers. Useful for analyzing flash loan usage patterns, fee revenue, and arbitrage activity on the Bancor decentralized exchange.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_borrower` | `STRING` | Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_feeAmount` | `STRING` | Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination. |
| address | removed | in\_token | in\_amount | log\_index | in\_borrower | block\_number | in\_feeAmount | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | false | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 20701530318273057000000 | 442 | 0x41eeba3355d7d6ff628b7982f3f9d055c39488cb | 16927798 | 0 | 2023-03-28T19:06:59.000Z | 0xf70ec3cc6b5b2358cdc06584de88c671da11fb6a0ef0108a091b4ca9ac4cb58e |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | false | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 6646180546506721000000 | 311 | 0x41eeba3355d7d6ff628b7982f3f9d055c39488cb | 16925187 | 0 | 2023-03-28T10:17:11.000Z | 0x6d068f8e19f3bca0a838551e04ea542c716943d6027a602710915bb4f694d603 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | false | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 13380615867457427000000 | 74 | 0x41eeba3355d7d6ff628b7982f3f9d055c39488cb | 16924080 | 0 | 2023-03-28T06:31:47.000Z | 0x5e1addd68fc33c71b2f363eb99ce016d73e7ff65599d9a60d1af9c564b9317a9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_FlashLoanCompleted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_PoolAdded\_event
Liquidity pool registration events from Bancor v1 automated market maker protocol on Ethereum, tracking when pools are added to or removed from pool collections. Used for analyzing Bancor's supported token pairs and historical pool availability.
| Column | Type | Description |
| ------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_poolCollection` | `STRING` | Contract address of the pool collection managing the referenced pool. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_poolCollection |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0x6b175474e89094c44da98b954eedeac495271d0f | false | 98 | 14609495 | 2022-04-18T13:39:39.000Z | 0x96141627a1b1106215811ee1981cfae638a81dbf7a23dbde01f33789f7c58783 | 0x6f9124c32a9f6e532c908798f872d5472e9cb714 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | false | 169 | 14609486 | 2022-04-18T13:37:07.000Z | 0x894cc251eb4eeda2045c5cc9ebef8ad0b6c05c99cf2b0b46e9ce09864ceb3009 | 0x6f9124c32a9f6e532c908798f872d5472e9cb714 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0x514910771af9ca656af840dff83e8264ecf986ca | false | 29 | 14609502 | 2022-04-18T13:41:03.000Z | 0xfff4a86939588de9f025080ea6fed80fe1938623160695397f625eb3f41ea077 | 0x6f9124c32a9f6e532c908798f872d5472e9cb714 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_PoolAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_PoolCreated\_event
Pool creation events from Bancor V1 automated market maker protocol on Ethereum. Records new liquidity pool deployments with pool addresses and their associated collection contracts for tracking protocol expansion.
| Column | Type | Description |
| ------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_poolCollection` | `STRING` | Contract address of the pool collection managing the referenced pool. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_pool | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_poolCollection |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0xdac17f958d2ee523a2206206994597c13d831ec7 | false | 143 | 15012316 | 2022-06-23T09:42:28.000Z | 0x6c9234acbfeea2c0b72628a8a9ac9651725643f430565a600cc36b1425755d1c | 0x05e29f07b9710368a1d5658750e9b4b478c15bb8 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0x444d6088b0f625f8c20192623b3c43001135e0fa | false | 127 | 15012316 | 2022-06-23T09:42:28.000Z | 0x6c9234acbfeea2c0b72628a8a9ac9651725643f430565a600cc36b1425755d1c | 0x05e29f07b9710368a1d5658750e9b4b478c15bb8 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 0x967da4048cd07ab37855c090aaf366e4ce1b9f48 | false | 135 | 15012316 | 2022-06-23T09:42:28.000Z | 0x6c9234acbfeea2c0b72628a8a9ac9651725643f430565a600cc36b1425755d1c | 0x05e29f07b9710368a1d5658750e9b4b478c15bb8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_TokensTraded\_event
Token swap execution events from Bancor V1 decentralized exchange on Ethereum, capturing trade details including source/target tokens, amounts, BNT (Bancor Network Token) routing amounts, and protocol fees for analyzing trading volume and liquidity provider earnings.
| 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_contextId` | `STRING` | Unique identifier linking related events within a transaction or operation. 66-character hex string including 0x prefix. |
| `in_sourceToken` | `STRING` | Token address of the asset being sold by the trader in this swap. Hex-encoded Ethereum address (0x-prefixed) representing the input token of the trade. |
| `in_targetToken` | `STRING` | Contract address of the token received by the trader in the swap. Hex-encoded, 0x-prefixed 40-character string, or 0xee...ee representing native ETH. |
| `in_sourceAmount` | `STRING` | Amount of the source token being sold in this trade. Expressed in the token's smallest unit (wei-equivalent), typically 18 decimals for ERC-20 tokens. |
| `in_targetAmount` | `STRING` | Amount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_bntAmount` | `STRING` | Amount of BNT (Bancor Network Token) involved in the operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_targetFeeAmount` | `STRING` | Protocol fee amount charged on the target token output, denominated in the smallest unit of that token. Typically a small percentage of the target amount received by the trader. |
| `in_bntFeeAmount` | `STRING` | Fee amount denominated in BNT (Bancor Network Token) charged on this trade, stored as a wei-denominated string. Zero values indicate fee-exempt trades or promotional periods. |
| `in_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_trader | log\_index | block\_number | in\_bntAmount | in\_contextId | in\_sourceToken | in\_targetToken | block\_timestamp | in\_bntFeeAmount | in\_sourceAmount | in\_targetAmount | transaction\_hash | in\_targetFeeAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ---------------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------ | -------------------- | ---------------------- | ---------------------- | ------------------------------------------------------------------ | ------------------- |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | false | 0x0000000000a84d1a9b0063a910315c7ffa9cd248 | 17 | 17429938 | 3315535967172946199859 | 0x7ff1170bcc6fa10597630a1e70b17565ea4af3cacdf76d434f518b134ab8ff84 | 0x0f5d2fb29fb7d3cfee444a200298f468908cc942 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 2023-06-07T17:20:47.000Z | 16660984759663046230 | 3031928194274480216722 | 1303385902 | 0xb6150ffa6512e556b0467e0d3be6b27615827ed8573e410efdd6b2bc854fd0fa | 13165514 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | false | 0x0eae044f00b0af300500f090ea00027097d03000 | 47 | 17426905 | 1788459100255083637538 | 0x5a96f64250a3350af6c80b74d96c32f0fa25b28e098503bf88e1504dc7a87a1b | 0x0f5d2fb29fb7d3cfee444a200298f468908cc942 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 2023-06-07T07:05:35.000Z | 8987231659573284610 | 1592435920729028518435 | 1788459100255083637538 | 0x99f9adbc9574f47f6c193359d5a5cbe0cd1c4f406157a3bbd9f14477c704622d | 8987231659573284610 |
| 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | false | 0x24902aa0cf0000a08c0ea0b003b0c0bf600000e0 | 328 | 17428953 | 1025556497062299340575 | 0xdef89e1ccdd8a13f63ce7c7b02fb09b9a0de9ece06b6add20a9c866b77fe9f4c | 0x0f5d2fb29fb7d3cfee444a200298f468908cc942 | 0x4104b135dbc9609fc1a9490e61369036497660c8 | 2023-06-07T14:00:59.000Z | 5153550236493966535 | 922721982496213303296 | 1361559790792069126959 | 0xc01aca8cdd9f6a6ccd967441047d40adf39c19a75a0cc158cdbdd144f07444ce | 6842008998955121241 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_TokensTraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetwork\_withdraw\_function
Withdraw function calls from Bancor V1's network contract on Ethereum, capturing token withdrawals with amounts and transaction details. Used for analyzing liquidity removal patterns and user withdrawal behavior from Bancor 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. |
| `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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | in\_id | value | status | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ------ | ----- | ------ | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 375199 | 9305 | 0 | true | 293630 | | 0x2e1a7d4d | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 23003399 | 0x18571698d3a7c1f5f768b79e0b0cbfd87cd712bf | | 2025-07-26T12:43:59.000Z | 0xd8e724e29ed61fb459e03738141c1114ae72885540142525aa3300fcd2d4d03a |
| 397921 | 9306 | 0 | true | 309095 | 136229564506410135593 | 0x2e1a7d4d | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 23003409 | 0x18571698d3a7c1f5f768b79e0b0cbfd87cd712bf | | 2025-07-26T12:45:59.000Z | 0x10a20f7c5786382ae520e4d29471b90e20a713f5d56504e9da801dafd7a58f8e |
| 268382 | 9307 | 0 | true | 209512 | 3379161707140921290132 | 0x2e1a7d4d | 0xeef417e1d5cc832e619ae18d2f140de2999dd4fb | 23003415 | 0x18571698d3a7c1f5f768b79e0b0cbfd87cd712bf | | 2025-07-26T12:47:11.000Z | 0x172bb65918d3670949cf3c34f25b4ae8b601cfbb586c0a2f1abfed53a36a901e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetwork_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BancorNetworkV21\_Conversion\_event
Token swap events from Bancor V2.1 automated market maker on Ethereum. Contains conversion details including trader addresses, input/output token pairs, exchange amounts, and pool identifiers for analyzing liquidity pool trading 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__smartToken` | `STRING` | Contract address of the Bancor pool smart token (relay token) through which the conversion was routed. Represents the intermediary liquidity pool on Ethereum, hex-encoded 0x-prefixed address. |
| `in__fromToken` | `STRING` | Contract address of the source token being swapped in the Bancor conversion. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the token sent by the trader. |
| `in__toToken` | `STRING` | Contract address of the destination token received in this Bancor V2.1 conversion. Hex-encoded, 0x-prefixed 40-character Ethereum address. |
| `in__fromAmount` | `STRING` | Amount of tokens sent by the trader in the conversion, denominated in the fromToken's smallest unit (wei-equivalent). Represents the input quantity before any conversion fees or slippage. |
| `in__toAmount` | `STRING` | Amount of destination tokens received by the trader in the conversion, denominated in the smallest unit (wei-equivalent) of the token. String format preserves precision for large token amounts with many decimal places. |
| `in__trader` | `STRING` | Contract address of the user who initiated the token swap on Bancor v2.1. This is the wallet that executed the conversion transaction between the source and destination tokens. |
| address | removed | log\_index | in\_\_trader | in\_\_toToken | block\_number | in\_\_toAmount | in\_\_fromToken | in\_\_fromAmount | in\_\_smartToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ---------------------- | ------------------------------------------ | --------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x2f9ec37d6ccfff1cab21733bdadede11c823ccb0 | false | 22 | 0x0000d2fa2d0000a58c0000c300720b0ee3b02a81 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 15338960 | 1131860591242137601457 | 0x0391d2021f89dc339f60fff84546ea23e337750f | 87422991020462082788 | 0x5189426a5906d00cbef2675764596e9a6a427fd5 | 2022-08-14T09:30:49.000Z | 0x2a4cfdba416e657e1e4e26a92fca462316c1f69c231759d3765b04b027c46fc3 |
| 0x2f9ec37d6ccfff1cab21733bdadede11c823ccb0 | false | 35 | 0x0000d2fa2d0000a58c0000c300720b0ee3b02a81 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 15340171 | 2774919922883119650019 | 0x0391d2021f89dc339f60fff84546ea23e337750f | 212712025145892812600 | 0x5189426a5906d00cbef2675764596e9a6a427fd5 | 2022-08-14T14:02:17.000Z | 0x209462cd430aa389c1a481705ffc45893cb6c5ad2a4ec79339211fb749c2c71a |
| 0x2f9ec37d6ccfff1cab21733bdadede11c823ccb0 | false | 113 | 0xed77777586d73c58eb4d6bebdf9c85c2d5f56c2d | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 15340391 | 2519727576548013486033 | 0x0391d2021f89dc339f60fff84546ea23e337750f | 195550203156754857984 | 0x5189426a5906d00cbef2675764596e9a6a427fd5 | 2022-08-14T14:49:13.000Z | 0xf1a8c5e793d87daa20514b343bb5c68b0a4cc4f3b816309b1fbb04ac2c60d83d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BancorNetworkV21_Conversion_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BNT\_Destruction\_event
BNT token burn events from Bancor v1 protocol on Ethereum, recording the destruction of BNT (Bancor Network Token) with amounts destroyed per transaction. Used for tracking deflationary tokenomics and protocol-level BNT supply adjustments.
| 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__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| address | removed | log\_index | in\_\_amount | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 43 | 26240358644316340791860 | 14481415 | 2022-03-29T13:40:07.000Z | 0x8545bc8ffab092fcc6bec980fa0d3cfda85bc22011b63d232f34c4bff3247645 |
| 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 558 | 2838998945685619444045 | 14482697 | 2022-03-29T18:21:55.000Z | 0x0cd40f6f7edc3369b8b4cda84af492b3a6d45a6b910b71f87f2d9e2bd41e598a |
| 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 600 | 13724987430741188465612 | 14483477 | 2022-03-29T21:14:57.000Z | 0xd6496623b6e46620e636810ecaad457d01b5922d4f2b6cec405f2dbbf76466f1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BNT_Destruction_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BNT\_Issuance\_event
BNT (Bancor Network Token) issuance events from Bancor v1 protocol on Ethereum, recording new token minting operations. Contains issuance amounts and timestamps for analyzing BNT token supply expansion and liquidity provision incentive programs.
| 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__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| address | removed | log\_index | in\_\_amount | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 3 | 500000000000000000000 | 6538255 | 2018-10-18T13:19:49.000Z | 0x790719ac42be44ff2c1816fd94140b4f18c5a6d5ff602b66e00d17ac7b214a20 |
| 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 4 | 316663606408203083545 | 6540908 | 2018-10-18T23:45:45.000Z | 0x3c77a4ec415bb9506d5a1b6b7ac1e4812c4f92642601784d1b904c9f16f788cc |
| 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 5 | 158000000000000000000 | 6536709 | 2018-10-18T07:15:31.000Z | 0x7596372d6730addd12ae71ad73c79b6c9a747f9887d62788d31e07f7495a8757 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BNT_Issuance_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### BNT\_Transfer\_event
BNT (Bancor Network Token) transfer events from the Bancor v1 protocol on Ethereum, capturing token movements between addresses with wei-denominated amounts. Used for analyzing BNT token flows, liquidity provider activity, and trading patterns within the Bancor decentralized exchange ecosystem.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in__from` | `STRING` | Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__to` | `STRING` | Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__value` | `STRING` | Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens). |
| in\_\_to | address | removed | in\_\_from | in\_\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5142127a6703f5fc80bf11b7b57ff68998f218e4 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 0x3ab6564d5c214bc416ee8421e05219960504eead | 2155997212189998868125 | 50 | 9380223 | 2020-01-30T00:01:40.000Z | 0x3241965ee8d1a31523ae8f2efb836cd4494b8ba2e493521bfd9eb5cdeff127d5 |
| 0x3ab6564d5c214bc416ee8421e05219960504eead | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 0x5142127a6703f5fc80bf11b7b57ff68998f218e4 | 184086081216093855445 | 64 | 9380223 | 2020-01-30T00:01:40.000Z | 0x93744e919893e6dd2fc9b5e06c996e63baf4e5a6e9deddd6f3dc3b010b80afa2 |
| 0xd3ec78814966ca1eb4c923af4da86bf7e6c743ba | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 0x3ab6564d5c214bc416ee8421e05219960504eead | 184086081216093855445 | 70 | 9380223 | 2020-01-30T00:01:40.000Z | 0x93744e919893e6dd2fc9b5e06c996e63baf4e5a6e9deddd6f3dc3b010b80afa2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.BNT_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_FeesWithdrawn\_event
Fee withdrawal events from Bancor Carbon's automated market maker protocol on Ethereum, recording token amounts collected by recipients from the protocol's CarbonController contract. Useful for analyzing protocol revenue distribution and fee accumulation patterns across different tokens including WBTC, USDT, USDC, and native ETH.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_token | in\_amount | in\_sender | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 11027 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 34 | 19224362 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 2024-02-14T06:15:59.000Z | 0x04c6f2911db1d7c532ac10f43a29ec34336c2386c6abc08268a4562ffdd9ceac |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 3304336677909576146 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 36 | 19224362 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 2024-02-14T06:15:59.000Z | 0x04c6f2911db1d7c532ac10f43a29ec34336c2386c6abc08268a4562ffdd9ceac |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 3164221452145999 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 246 | 18393054 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 2023-10-20T17:34:47.000Z | 0xc0e4d2516eb8fbc941bdd9559458c0d0430e90350e00f1cbc21bad218c761408 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_FeesWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_Initialized\_event
Initialization events for Bancor Carbon protocol controller contracts on Ethereum, tracking when new controller instances are deployed and initialized with their version number. Used for monitoring protocol upgrades and deployment history.
| 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_version` | `INT64` | Version identifier for the contract or event schema. String or integer value indicating the initialization or state version. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 254 | 1 | 17087375 | 2023-04-20T11:20:59.000Z | 0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_PairCreated\_event
Trading pair creation events from Bancor Carbon's automated market maker protocol on Ethereum. Records new liquidity pools with token pair addresses and unique pair IDs for tracking decentralized exchange strategy deployments.
| 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_pairId` | `STRING` | Unique identifier assigned to each trading pair created in the Bancor Carbon protocol. Sequential numeric values starting from creation, used to reference specific token pair configurations on-chain. |
| `in_token0` | `STRING` | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token1` | `STRING` | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_pairId | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 223 | 0xa41d2f8ee4f47d3b860a149765a7df8c3287b7f0 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 267 | 18817942 | 2023-12-19T05:31:35.000Z | 0xdb167e99e5cdaa5eec28def6ac28fffb7d91d61bd293bb9b8b2fee33dc7a12e9 |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 56 | 0x9d65ff81a3c488d585bbfb0bfe3c7707c7917f54 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 287 | 17430002 | 2023-06-07T17:33:35.000Z | 0xa71922667f31e973603034c16b3af90a3810472009e5eb1f70926b28bdec49ae |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 233 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 702 | 18901699 | 2023-12-30T23:48:11.000Z | 0x1b3b8db1ddc100666db6865c71f604965a3678e16de971f229d7b73c080b2f26 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_Paused\_event
*No description available.*
| 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_Paused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_RoleAdminChanged\_event
Role administration changes in Bancor's Carbon protocol on Ethereum, tracking when admin permissions are granted or revoked for different role identifiers. Useful for monitoring protocol governance and access control modifications.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_previousAdminRole` | `STRING` | Previous admin role identifier before the role change. 66-character keccak256 hash including 0x prefix. |
| `in_newAdminRole` | `STRING` | New admin role identifier for the specified role. 66-character keccak256 hash including 0x prefix. |
| address | in\_role | removed | log\_index | block\_number | block\_timestamp | in\_newAdminRole | transaction\_hash | in\_previousAdminRole |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 250 | 17087375 | 2023-04-20T11:20:59.000Z | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | 0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e | 0x0000000000000000000000000000000000000000000000000000000000000000 |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0x24a843cae781765d8cdc3bca1cc42497522c0508f4e621c2ca36ceea2fda7b16 | false | 253 | 17087375 | 2023-04-20T11:20:59.000Z | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | 0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e | 0x0000000000000000000000000000000000000000000000000000000000000000 |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0xf28f409b8cbe6b50c7ca45afe893f01f69626f8a4e33cb480bc1bc2d618c0845 | false | 252 | 17087375 | 2023-04-20T11:20:59.000Z | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | 0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e | 0x0000000000000000000000000000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_RoleAdminChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_RoleGranted\_event
Role assignment events from Bancor's Carbon Controller contract on Ethereum, tracking administrative permissions granted to accounts. Used for analyzing protocol governance and access control changes over time.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_role | removed | in\_sender | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0x24a843cae781765d8cdc3bca1cc42497522c0508f4e621c2ca36ceea2fda7b16 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 110 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 17087480 | 2023-04-20T11:42:11.000Z | 0x9184b57362983ea326e1aa284fa547095985e25df4376e258abe0731696e178c |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 251 | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 17087375 | 2023-04-20T11:20:59.000Z | 0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0xf28f409b8cbe6b50c7ca45afe893f01f69626f8a4e33cb480bc1bc2d618c0845 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 193 | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 17087923 | 2023-04-20T13:11:59.000Z | 0xb824c64d25e40d4b24d35c728160e39f6b8396d1a451c6b8fa82a7a9dc0cab08 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_RoleGranted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_RoleRevoked\_event
Access control events from Bancor v1 Carbon protocol on Ethereum tracking role revocations from accounts. Used for monitoring administrative permissions and governance changes in the protocol's role-based access system.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_role | removed | in\_sender | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0xf28f409b8cbe6b50c7ca45afe893f01f69626f8a4e33cb480bc1bc2d618c0845 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 300 | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 19425449 | 2024-03-13T10:06:47.000Z | 0xe5483ced975da02ac39552c7afda7691110b0c20f6fa087b53528ef4c61bfe13 |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 0x24a843cae781765d8cdc3bca1cc42497522c0508f4e621c2ca36ceea2fda7b16 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 39 | 0xba7d1581db6248dc9177466a328bf457703c8f84 | 21379209 | 2024-12-11T12:17:35.000Z | 0x1e283b9ac66e3384ae1a0ceb924e7fede82bc80a5769177e305f559a73fa5101 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_RoleRevoked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_StrategyCreated\_event
Strategy creation events from Bancor Carbon (v1) automated market maker on Ethereum. Records bidirectional liquidity provision strategies with order parameters (A, B, y, z values) for analyzing concentrated liquidity positions and trading curve configurations.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token0` | `STRING` | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token1` | `STRING` | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_order0` | `STRUCT` | Order parameters for the first token in the strategy's trading pair, containing bonding curve coefficients (A, B) and liquidity values (y, z). Values are null or zero when the strategy has no active buy or sell orders for token0. |
| `in_order1` | `STRUCT` | Order parameters for the second token in the trading pair, containing liquidity curve coefficients (A, B, y, z) that define pricing and availability. Structured as a RECORD with numeric string values representing the automated market maker's bonding curve configuration. |
| in\_id | address | removed | in\_owner | in\_order0 | in\_order1 | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ----------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------------------------------------------------------- | --------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 57507720009638600325310308655968827736561 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x25ca93c584756d674d6fe6d1e241a89791b18df3 | \{"A":"0","B":"0","y":"0","z":"0"} | \{"A":"46406659","B":"267030609","y":"13652792574","z":"13652792574"} | 0xf16e81dce15b08f326220742020379b855b87df9 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 219 | 18174112 | 2023-09-20T02:25:35.000Z | 0xf68f1bfa97599d96c8ddc61c5630645710c602b48672c7082df9a13913d73b93 |
| 2381976568446569244243622252022377480690 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0xddd6516ed7e9b2defb2e1ae50379943cc9ee2b73 | \{"A":"0","B":"6111054486652827","y":"1221000000000000000000","z":"1221000000000000000000"} | \{"A":"0","B":"173512828","y":"464234783","z":"464234783"} | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 131 | 18176438 | 2023-09-20T10:15:11.000Z | 0x2e147a21fa45c76c9fa0231a52629b71dcc7293747c4fb1c96f7e0ce5f058c9a |
| 4083388403051261561560495289181218537643 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0xe76f1230c61160206306cb55e524d5843bad697a | \{"A":"0","B":"17373012734782","y":"0","z":"0"} | \{"A":"0","B":"1548301910034222","y":"205000000","z":"205000000"} | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 134 | 17457526 | 2023-06-11T14:41:11.000Z | 0xb89ee5cad6d4a72cbc92ead7c81eef494121915c2a4ac3661381dff1dbc54d05 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_StrategyCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_StrategyDeleted\_event
Strategy deletion events from Bancor Carbon automated market maker protocol on Ethereum. Captures removal of liquidity strategies with order parameters (y, z, A, B values) for both token pairs when liquidity providers exit positions.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token0` | `STRING` | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token1` | `STRING` | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_order0` | `STRUCT` | Order parameters for the first token in the trading pair, containing pricing curve coefficients (A, B) and liquidity amounts (y, z). All values are stored as strings representing integers due to precision requirements for on-chain calculations. |
| `in_order1` | `STRUCT` | Order parameters for the second token in the deleted Bancor Carbon strategy, containing bonding curve coefficients (A, B) and liquidity amounts (y, z). The RECORD structure defines the automated market maker pricing algorithm for token1 trades. |
| in\_id | address | removed | in\_owner | in\_order0 | in\_order1 | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ----------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------------------------------------------------------------- | ----------------------------------------------------------------------------------------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 45938119534326692567555572003288708546957 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x9f6dbfbfcc350d55a207e22ddd1d8813d4b19ff2 | \{"A":"2132133601889728","B":"3303421762110733","y":"0","z":"0"} | \{"A":"11128445448","B":"163522184576","y":"200000000000000000","z":"200000000000000000"} | 0x3007083eaa95497cd6b2b809fb97b6a30bdf53d3 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 255 | 17917783 | 2023-08-15T04:12:59.000Z | 0x55fc39cbacaf804d83ea23686a53116f80e9e88293896728254e5b4359c25ee1 |
| 47639531368931384884872445040447549604244 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x6609005145c7511a91a16301f298fd18a7b72ac8 | \{"A":"0","B":"0","y":"0","z":"0"} | \{"A":"0","B":"8349897185747","y":"16800000000000000","z":"16800000000000000"} | 0xd8b90d2e680ea535eacce1b025c998b347892f68 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 296 | 17922075 | 2023-08-15T18:38:11.000Z | 0xf177226c78b1d364826c6eca682b1cb20691b4962f8845c2d5e21124cb5c632c |
| 47299249002010446421409070433015781392787 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x6609005145c7511a91a16301f298fd18a7b72ac8 | \{"A":"0","B":"0","y":"0","z":"0"} | \{"A":"0","B":"7552766182682","y":"500000000000000000","z":"500000000000000000"} | 0xd8b90d2e680ea535eacce1b025c998b347892f68 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 360 | 17922078 | 2023-08-15T18:38:47.000Z | 0xab90f965457d53bb0d842b96c1b359b618ac0e317a59b8fe1d2cb9734dc7e77e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_StrategyDeleted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_StrategyUpdated\_event
Strategy update events from Bancor Carbon automated market maker on Ethereum. Contains paired order configurations with pricing parameters (A, B, y, z values) for analyzing automated trading strategy adjustments and liquidity provision behavior.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_token0` | `STRING` | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token1` | `STRING` | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_order0` | `STRUCT` | Order parameters for the first token in a Bancor Carbon trading pair, containing pricing curve coefficients (A, B) and liquidity values (y, z). Structured record defining one side of a bidirectional automated market maker strategy. |
| `in_order1` | `STRUCT` | Order configuration for the second token in the Bancor v3 Carbon trading strategy, containing pricing curve parameters (A, B, y, z). Typically represents the opposite direction of in\_order0, with y and z values indicating available liquidity. |
| `in_reason` | `INT64` | Enumerated code indicating the cause or category of the operation or state change. Non-negative integer value representing different reason types defined by the protocol. |
| in\_id | address | removed | in\_order0 | in\_order1 | in\_reason | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ----------------------------------------- | ------------------------------------------ | ------- | ------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 9187623906865338513511114400657741709793 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | \{"A":"0","B":"693363839","y":"0","z":"0"} | \{"A":"0","B":"5564577281336368","y":"100000000000000000","z":"100000000000000000"} | 0 | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 261 | 18136158 | 2023-09-14T18:02:35.000Z | 0xdb8976951c3ccff1d2d625bd7c4c336d840a798f7eff067035ca458f49b17105 |
| 56146590541954846471456810226241754890722 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | \{"A":"0","B":"5265938431914332","y":"3049940584000000000000000000","z":"3049940584000000000000000000"} | \{"A":"0","B":"1138147818","y":"0","z":"0"} | 0 | 0x75c97384ca209f915381755c582ec0e2ce88c1ba | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 192 | 18134697 | 2023-09-14T13:05:11.000Z | 0xc08ecce424fb18da5f947d57fca1cca97dff59936d83219f2d6b333db4c0457c |
| 55125743441192031081066686403946450256345 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | \{"A":"0","B":"6123191372350253","y":"70779239735011","z":"70779239735011"} | \{"A":"0","B":"154170194","y":"0","z":"0"} | 0 | 0x7721a4cb6190edb11d47f51c20968436eccdafb8 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 777 | 18131767 | 2023-09-14T03:12:59.000Z | 0x2acbd28c7c4dfe06ef248fece9c2bdbbc21b212035b580b8170a40c8984f3beb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_StrategyUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_TokensTraded\_event
Token swap events from Bancor v3's Carbon automated trading strategy protocol on Ethereum. Captures trade executions with source/target tokens, amounts, fees, and trader addresses for analyzing on-chain liquidity strategy performance.
| 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_trader` | `STRING` | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sourceToken` | `STRING` | Contract address of the token being sold by the trader in the swap transaction. Hex-encoded, 0x-prefixed 40-character string representing an ERC-20 token or native ETH (0xeeee...eeee). |
| `in_targetToken` | `STRING` | Contract address of the token being received in the trade on Ethereum. Uses 0xeeee...eeee as a special identifier for native ETH. |
| `in_sourceAmount` | `STRING` | Amount of source tokens transferred from the trader in the swap, denominated in the token's smallest unit (wei for ETH). String-encoded to preserve precision for large integer values common in DeFi transactions. |
| `in_targetAmount` | `STRING` | Amount of target tokens received in the trade. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_tradingFeeAmount` | `STRING` | Trading fee charged for the swap, denominated in the smallest unit of the target token. This is the protocol or liquidity provider fee extracted from the trade, separate from the amounts exchanged. |
| `in_byTargetAmount` | `BOOL` | Indicates whether the trade was executed by specifying the target (output) amount rather than the source (input) amount. When true, the trader specified the exact amount of target token desired; when false, they specified the source token amount to swap. |
| address | removed | in\_trader | log\_index | block\_number | in\_sourceToken | in\_targetToken | block\_timestamp | in\_sourceAmount | in\_targetAmount | transaction\_hash | in\_byTargetAmount | in\_tradingFeeAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ---------------------- | ----------------------- | ------------------------------------------------------------------ | ------------------ | -------------------- |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0xe27baebd7b14602de3797974db9f5f4f8dcb6679 | 117 | 17195821 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2023-05-05T17:08:59.000Z | 20182585644 | 10329343832159940169 | 0xe9d03642109ced8f6f6e0569bae7b087e29010fc4ba805582345187e09572f1f | false | 20700087839999881 |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x41eeba3355d7d6ff628b7982f3f9d055c39488cb | 53 | 17191510 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2023-05-05T02:37:59.000Z | 4965213572290183947188 | 1252398814586205257 | 0xf88e3e9a05a9e80f3dde5c5bd7ee71e96d4fa2ede5bae48e76d531465da9d55f | false | 2509817263699811 |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 0x41eeba3355d7d6ff628b7982f3f9d055c39488cb | 246 | 17560315 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x6b175474e89094c44da98b954eedeac495271d0f | 2023-06-26T01:22:59.000Z | 9072393088530614000 | 17084957765872823623774 | 0xfcbf2ea0ab54dcdd6d5e0fbb6d7cb961708f3b15bf685007d6c689ad54778918 | false | 34238392316378404056 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_TokensTraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_TradingFeePPMUpdated\_event
Trading fee configuration changes from Bancor's Carbon Controller on Ethereum. Tracks fee updates in parts-per-million (PPM) with previous and new values for analyzing fee policy adjustments.
| 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_prevFeePPM` | `STRING` | Previous fee rate in parts per million (PPM). String-encoded integer representing the fee as a proportion of 1,000,000 before the update. |
| `in_newFeePPM` | `STRING` | Updated fee rate in parts per million (PPM). String-encoded integer representing the fee as a proportion of 1,000,000. |
| address | removed | log\_index | block\_number | in\_newFeePPM | in\_prevFeePPM | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | false | 249 | 17087375 | 2000 | 0 | 2023-04-20T11:20:59.000Z | 0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_TradingFeePPMUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonController\_Unpaused\_event
*No description available.*
| 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonController_Unpaused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonVortex\_Initialized\_event
Initialization events for Bancor V1's CarbonVortex contract on Ethereum, capturing when the contract was deployed and initialized. Used for tracking contract deployment history and verifying operational start times.
| 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_version` | `INT64` | Version identifier for the contract or event schema. String or integer value indicating the initialization or state version. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | false | 135 | 1 | 17087475 | 2023-04-20T11:41:11.000Z | 0xc26ab98d01d3d8d8fcde878e09e69497b3418d74544ec3ee8f600ff6ed320b7e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonVortex_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonVortex\_RewardsUpdated\_event
Events tracking changes to rewards parameters in Bancor v1's Carbon Vortex contract on Ethereum, recorded in parts per million (PPM). Contains previous and new reward rate configurations for analyzing protocol incentive adjustments over time.
| 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_prevRewardsPPM` | `STRING` | Previous rewards rate in parts per million (PPM) before the update event. May contain large numeric values representing the prior configuration of the rewards mechanism. |
| `in_newRewardsPPM` | `STRING` | New rewards rate in parts per million (PPM) after the update event. Represents the fee or reward percentage where 1,000,000 PPM equals 100%. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newRewardsPPM | transaction\_hash | in\_prevRewardsPPM |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------ |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | false | 80 | 17634948 | 2023-07-06T12:57:11.000Z | 20000 | 0x6982bcd8f9c1cc47c168bb4f2361cd98cabbd9e7f300559e2426ccb95d9a874c | 429496729600000000000000020000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonVortex_RewardsUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonVortex\_RoleAdminChanged\_event
Role admin change events from Bancor v1's CarbonVortex contract on Ethereum, tracking modifications to access control admin roles. Used for monitoring governance changes and permission management in the protocol's admin hierarchy.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_previousAdminRole` | `STRING` | Previous admin role identifier before the role change. 66-character keccak256 hash including 0x prefix. |
| `in_newAdminRole` | `STRING` | New admin role identifier for the specified role. 66-character keccak256 hash including 0x prefix. |
| address | in\_role | removed | log\_index | block\_number | block\_timestamp | in\_newAdminRole | transaction\_hash | in\_previousAdminRole |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 132 | 17087475 | 2023-04-20T11:41:11.000Z | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | 0xc26ab98d01d3d8d8fcde878e09e69497b3418d74544ec3ee8f600ff6ed320b7e | 0x0000000000000000000000000000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonVortex_RoleAdminChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonVortex\_RoleGranted\_event
Role assignment events from Bancor's CarbonVortex contract on Ethereum, tracking access control changes with role identifiers and assigned accounts. Used for monitoring administrative permissions and contract governance 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_role | removed | in\_sender | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 133 | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 17087475 | 2023-04-20T11:41:11.000Z | 0xc26ab98d01d3d8d8fcde878e09e69497b3418d74544ec3ee8f600ff6ed320b7e |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 152 | 0xd053dcd7037af7204cece544ea9f227824d79801 | 20469412 | 2024-08-06T12:04:35.000Z | 0xf076387ede8bfd7fbf0a6e6e0faf79f4b372eaf825bc01a6eeb96c1bee6115f8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonVortex_RoleGranted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonVortex\_RoleRevoked\_event
*No description available.*
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonVortex_RoleRevoked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CarbonVortex\_TokensBurned\_event
Token burn events from Bancor's Carbon Vortex contract on Ethereum, recording burn amounts of protocol tokens and associated reward distributions. Tracks caller addresses, multiple token types (including ETH as 0xeeee...eeee), and reward amounts for analyzing Bancor's deflationary tokenomics.
| 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_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_rewardAmounts` | `ARRAY` | Reward amounts distributed to participants for each token burned, ordered to match the in\_tokens array. Values are in base token units (wei for ETH, smallest denomination for ERC20 tokens). |
| `in_burnAmount` | `STRING` | Amount of Bancor Network Tokens (BNT) burned in this transaction, denominated in wei (1e-18 BNT). Values typically range from hundreds to thousands of BNT tokens. |
| address | removed | in\_caller | in\_tokens | log\_index | block\_number | in\_burnAmount | block\_timestamp | in\_rewardAmounts | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------- | ---------------------- | ------------------------ | ------------------------------------------------------------------------- | ------------------------------------------------------------------ |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | false | 0x160f5f00288e9e1cc8655b327e081566e580a71d | \["0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee"] | 52 | 18097173 | 823884495682984473764 | 2023-09-09T06:52:23.000Z | \["4445448885894782"] | 0x3e98c031c131b237d79b3b3c994abf07d27c49a43a93cafd99adedccdd0c9cc2 |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | false | 0x23b530268c4a1f0bb11fbb0aa2f3ddf0d41caf22 | \["0x2260fac5e5542a773aa44fbcfedf7c193bc2c599","0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee","0x514910771af9ca656af840dff83e8264ecf986ca","0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c"] | 964 | 18703395 | 5360138718032924866312 | 2023-12-03T04:08:59.000Z | \["88791","5497106613347610","562478090977925335","40351371011580956351"] | 0x62162a299be9e72c57820cdea0485285a469ea4df8dcdd70d8ffa178325f2299 |
| 0xba7d1581db6248dc9177466a328bf457703c8f84 | false | 0x1d148065ff0ba5aa48c538cd798e8c4af5168ce0 | \["0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee","0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c","0xf629cbd94d3791c9250152bd8dfbdf380e2a3b9c"] | 381 | 18586971 | 3685960772974280886377 | 2023-11-16T20:55:11.000Z | \["8648452138845250","32252004044922304375","59900591854386804521"] | 0xfb113a36e3ed8fb35eb58258a4671a895f7fdd010006ce69ee23ff2fe21f80b1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.CarbonVortex_TokensBurned_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Converter\_Conversion\_event
Token swap events from Bancor V1 converter contracts on Ethereum, capturing trades between token pairs with amounts, fees, and trader addresses. Used for analyzing decentralized exchange (DEX) volume, liquidity provider fee revenue, and trading patterns across Bancor liquidity 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__fromToken` | `STRING` | Contract address of the token being sold/swapped from in this Bancor V1 conversion. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the input token in the trade. |
| `in__toToken` | `STRING` | Contract address of the destination token in the Bancor V1 conversion. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token received by the trader. |
| `in__trader` | `STRING` | Ethereum address of the user who initiated the token swap on the Bancor V1 converter. Hex-encoded, 0x-prefixed 40-character string representing the trader's wallet address. |
| `in__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| `in__return` | `STRING` | Token amount received by the trader after the conversion, denominated in the output token's smallest unit. Values are large integers representing wei-equivalent amounts for the destination token specified in `in__toToken`. |
| `in__conversionFee` | `STRING` | Fee charged by the Bancor protocol for this conversion, denominated in the smallest unit of the output token. Represented as a string to preserve precision for large integer values common in token transactions. |
| address | removed | log\_index | in\_\_amount | in\_\_return | in\_\_trader | in\_\_toToken | block\_number | in\_\_fromToken | block\_timestamp | transaction\_hash | in\_\_conversionFee |
| ------------------------------------------ | ------- | ---------- | ---------------------- | -------------------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x0a3df697e872ab920f305db00450c0a372e6c970 | false | 24 | 351822502504653380475 | 68865713737578147128 | 0xfd0000000100069ad1670066004306009b487ad7 | 0x0954906da0bf32d5479e25f46056d22f08464cab | 16676227 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 2023-02-21T10:17:47.000Z | 0xb414dca350af5872ee91ad8654a2f4cb0e191c6d0da2ec3e649efa497f4f698c | 138007442359876046 |
| 0x0a3df697e872ab920f305db00450c0a372e6c970 | false | 168 | 260848548376869396875 | 57193394196806377353 | 0xfd0000000100069ad1670066004306009b487ad7 | 0x0954906da0bf32d5479e25f46056d22f08464cab | 16674526 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 2023-02-21T04:32:35.000Z | 0x746ad0829d76eb985079a01b25e98a1d37cb89d3ee530e2b8b37d8e56ec19ad5 | 114616020434481718 |
| 0x555981b82743aa443cb1c3002c85ba9d795d4596 | false | 83 | 1239949514519676263259 | 76940886451896623 | 0x0b3f6d4a5d6835137ccb2c1248f5a7d882c0dbda | 0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e | 16679738 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 2023-02-21T22:06:35.000Z | 0x9690a9296b66f76aead2432dab321201b433580e5a9bf549191a803f8c7dcd2e | 154190153210213 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Converter_Conversion_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Converter\_LiquidityAdded\_event
Liquidity deposit events from Bancor v1 converter contracts on Ethereum, recording provider addresses, token amounts added, and resulting pool balances and supply. Used for analyzing liquidity provider activity and pool composition changes over time.
| 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__provider` | `STRING` | Ethereum address of the liquidity provider adding tokens to the Bancor v1 converter pool. Hex-encoded, 0x-prefixed 40-character string identifying the wallet depositing reserve tokens. |
| `in__reserveToken` | `STRING` | Contract address of the reserve token being added to the Bancor liquidity pool. Uses 0xeeee...eeee as a sentinel value to represent native ETH deposits. |
| `in__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| `in__newBalance` | `STRING` | New balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens). |
| `in__newSupply` | `STRING` | Total supply of pool tokens after the liquidity addition event. Value is denominated in the smallest unit (wei-equivalent) of the pool token. |
| address | removed | log\_index | in\_\_amount | block\_number | in\_\_provider | in\_\_newSupply | in\_\_newBalance | block\_timestamp | in\_\_reserveToken | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | -------------------- | ------------- | ------------------------------------------ | -------------------------- | ------------------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0xe870d00176b2c71afd4c43cea550228e22be4abd | false | 180 | 5410317666515627 | 10567051 | 0xa15959aaaa96c0b17d06ffbb2dc10ae249e37bf6 | 12142940705905530737379209 | 21266689856150126124698 | 2020-07-31T11:22:40.000Z | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x8e41e1899b16c036e5e127a2e63987b37e67ee4a447e72c44276ffd1604e346d |
| 0xe870d00176b2c71afd4c43cea550228e22be4abd | false | 178 | 999717242895349971 | 10567051 | 0xa15959aaaa96c0b17d06ffbb2dc10ae249e37bf6 | 12142940705905530737379209 | 3929654016451365105876540 | 2020-07-31T11:22:40.000Z | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0x8e41e1899b16c036e5e127a2e63987b37e67ee4a447e72c44276ffd1604e346d |
| 0xe870d00176b2c71afd4c43cea550228e22be4abd | false | 254 | 22013367537442391200 | 10566576 | 0x09804954cbf4844601baf6cb8792e189e930dbc2 | 12142967316700437279237089 | 3859093644929622426826857 | 2020-07-31T09:36:29.000Z | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0x3b5a1d6e48c97d2eff07247cbd363477de00ea66cfc0c06d7d4c938664cbc70a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Converter_LiquidityAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Converter\_LiquidityRemoved\_event
Liquidity withdrawal events from Bancor V1 converter pools on Ethereum, capturing provider addresses, token amounts removed, and updated pool balances and supply. Used for tracking liquidity provider exits and analyzing pool depth changes over time.
| 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__provider` | `STRING` | Address of the liquidity provider removing tokens from the Bancor V1 converter pool. Hex-encoded Ethereum address that initiated the liquidity withdrawal transaction. |
| `in__reserveToken` | `STRING` | Contract address of the reserve token withdrawn from the Bancor V1 liquidity pool. Hex-encoded, 0x-prefixed 40-character string representing ERC20 tokens like BNT or paired assets. |
| `in__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| `in__newBalance` | `STRING` | New balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens). |
| `in__newSupply` | `STRING` | Total supply of pool tokens after this liquidity removal transaction. Value is denominated in the smallest unit (wei-equivalent) of the pool token. |
| address | removed | log\_index | in\_\_amount | block\_number | in\_\_provider | in\_\_newSupply | in\_\_newBalance | block\_timestamp | in\_\_reserveToken | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x8df51a9714ae6357a5b829cc8d677b43d7e8bd53 | false | 166 | 11468567534525035478445 | 18254398 | 0x85cbbb1ede2b3e389235ae56ec54bec8159001e5 | 637758291207733513645061 | 1486594261258849309100616 | 2023-10-01T08:08:47.000Z | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0xb8bd087e145b45cabcabba298604e379db6cd0518dbdbf763d75048ac38bbd38 |
| 0x8df51a9714ae6357a5b829cc8d677b43d7e8bd53 | false | 163 | 589917315999112218990 | 18254398 | 0x85cbbb1ede2b3e389235ae56ec54bec8159001e5 | 637758291207733513645061 | 76467064778707128950699 | 2023-10-01T08:08:47.000Z | 0x514910771af9ca656af840dff83e8264ecf986ca | 0xb8bd087e145b45cabcabba298604e379db6cd0518dbdbf763d75048ac38bbd38 |
| 0xe31643ebd9fd29b668c0553c76308a33decffa6d | false | 381 | 1306997227693219229871 | 18257711 | 0x85cbbb1ede2b3e389235ae56ec54bec8159001e5 | 241514504890936170235371 | 276160817362818956778802 | 2023-10-01T19:15:47.000Z | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | 0x424e481febc6ad62ddc89dc7c4e4bda9e5ef1c7e34430251c5627e7d65cebda6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Converter_LiquidityRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory\_NewConverter\_event
Converter deployment events from Bancor V1 protocol factory contract on Ethereum. Tracks creation of new liquidity pool converters with type identifier, owner address, and converter contract address for monitoring protocol expansion.
| 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__type` | `STRING` | Converter type identifier specifying the Bancor pool version or configuration model. Common values include '1' for legacy converters and '3' for newer pool types. |
| `in__converter` | `STRING` | Contract address of the newly deployed Bancor converter created by the factory. This address manages the liquidity pool and token conversion logic for the specific trading pair. |
| `in__owner` | `STRING` | Address of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_\_type | in\_\_owner | log\_index | block\_number | in\_\_converter | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x4ade0e57bc2e129f62547af4d620fb40d28ea269 | false | 3 | 0x7dfb5180878b43c6ff5aa6a2ea55db20bcc87410 | 60 | 12600804 | 0x6ab5f3b870bb8ab4750eec0f3779b38b926d3c25 | 2021-06-09T14:20:26.000Z | 0x6a97aefebfca8009862bbff0b526159485887d8f07f64eae7e70f24ecd2370f7 |
| 0x4ade0e57bc2e129f62547af4d620fb40d28ea269 | false | 3 | 0x7dfb5180878b43c6ff5aa6a2ea55db20bcc87410 | 77 | 12225047 | 0x5a7bb6adf00a1d6284773887fcadce079c636567 | 2021-04-12T11:40:49.000Z | 0x6be3c4aa417a18b67517cced5d21083665f6544fb9315cea1c588c58cc43c01d |
| 0x4ade0e57bc2e129f62547af4d620fb40d28ea269 | false | 3 | 0x7dfb5180878b43c6ff5aa6a2ea55db20bcc87410 | 355 | 15673692 | 0xb8990e35ce04fb257bf84f02eed7b5e97b413e34 | 2022-10-04T08:50:23.000Z | 0xd812cfe27ee54aee812abb6698831449df8eb2e1d7f449506937fbc131ddf3e2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Factory_NewConverter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Factory2\_NewConverter\_event
Bancor V1 converter creation events on Ethereum, emitted when new liquidity pool converters are deployed through the Factory2 contract. Used for tracking pool deployments and identifying converter contract addresses with their respective owners.
| 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__converter` | `STRING` | Contract address of the newly deployed Bancor V1 converter instance created by this factory event. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the liquidity pool converter. |
| `in__owner` | `STRING` | Address of the account that owns the position, vault, or allowance. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_\_owner | log\_index | block\_number | in\_\_converter | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x9afb9d7ed0f6c054ec76ea61d5cabc384d4dcb25 | false | 0x06915fb082d34ff4fe5105e5ff2829dc5e7c3c6d | 17 | 10373354 | 0xcaf6eb14c3a20b157439904a88f00a8be929c887 | 2020-07-01T11:50:52.000Z | 0xc6232e3e278a33ec5ad3ec26c0f3801bae77a0a75c6b0d8aeabe837e56797cfd |
| 0x9afb9d7ed0f6c054ec76ea61d5cabc384d4dcb25 | false | 0x06915fb082d34ff4fe5105e5ff2829dc5e7c3c6d | 19 | 10326543 | 0x7ff01db7ae23b97b15bc06f49c45d6e3d84df46f | 2020-06-24T05:26:26.000Z | 0x3eca95c85d4db83613d3d06af0fe2ed6338da6b1bb2e94d59a81cef00d8c2653 |
| 0x9afb9d7ed0f6c054ec76ea61d5cabc384d4dcb25 | false | 0x06915fb082d34ff4fe5105e5ff2829dc5e7c3c6d | 9 | 10329440 | 0x16ff969cc3a4ae925d9c0a2851e2386d61e75954 | 2020-06-24T16:02:23.000Z | 0x332e80fab53b46352d55d5d5ae5fb42c4560171fd1295fddc19645ae5c9fffd9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Factory2_NewConverter_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityProtection\_addLiquidity\_function
Failed liquidity deposit attempts to Bancor V1's Liquidity Protection contract on Ethereum. All sample transactions show failed status, useful for analyzing protection mechanism rejections and user interaction errors with pool anchors and reserve tokens.
| 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_poolAnchor` | `STRING` | Pool anchor contract address identifying the Bancor liquidity pool receiving the added liquidity. Null when the transaction failed (status=false), otherwise contains a 0x-prefixed hex address. |
| `in_reserveToken` | `STRING` | Token address being deposited into the Bancor V1 liquidity protection pool. Null when transaction fails, as indicated by the status field in sample data. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | gas\_used | in\_amount | out\_anon0 | signature | to\_address | block\_number | from\_address | in\_poolAnchor | trace\_address | block\_timestamp | in\_reserveToken | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 908864 | 0 | false | 90935 | | | 0xe4a76726 | 0xeead394a017b8428e2d5a976a054f303f78f3c0c | 11864577 | 0x7a22e7a4d912231f9c0fb6760c59ab560188360b | | | 2021-02-16T00:32:03.000Z | | 0xc6e66608b1e7ba1b3e3af6f4b965505aee9bd97771be497634e5bbd434c2d459 |
| 719644 | 0 | false | 258532 | | | 0xe4a76726 | 0xeead394a017b8428e2d5a976a054f303f78f3c0c | 11869916 | 0x34cadf09dbf50a39d1a68b87d7763db3961ef483 | | | 2021-02-16T20:06:07.000Z | | 0x030b5424f9a241195bb6105351bd531f754b25d6b3145ce594f11292a7953098 |
| 937167 | 0 | false | 524996 | | | 0xe4a76726 | 0xeead394a017b8428e2d5a976a054f303f78f3c0c | 11865657 | 0x035fc3b0ec2487c1c9def561f578ec77a06b1b12 | | | 2021-02-16T04:30:22.000Z | | 0xe913c8836f35251b887961d36659fc2ef3e98fbfb634151285a325a23929b106 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.LiquidityProtection_addLiquidity_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityProtection\_removeLiquidity\_function
Liquidity withdrawal function calls from Bancor v1's Liquidity Protection contract on Ethereum. Tracks removeLiquidity attempts with protection IDs, withdrawal portions (typically 1000000 representing 100%), and transaction outcomes for analyzing protected liquidity exits.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_portion` | `STRING` | Proportional amount of liquidity being removed, expressed as parts per million where 1000000 represents 100% of the position. Null values indicate failed transactions that did not execute the function parameters. |
| gas | in\_id | value | status | gas\_used | signature | in\_portion | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ------ | ----- | ------ | --------- | ---------- | ----------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 903585 | | 0 | false | 38082 | 0x782ed90c | | 0xeead394a017b8428e2d5a976a054f303f78f3c0c | 12183307 | 0x447ecbd0cb12fe94cbe8ff3a49fbf3acc23fdf41 | | 2021-04-06T01:59:03.000Z | 0x7a8b4be503377582896fc56e6fa0f768097bb122bd7f78c4333a81cdf68b926e |
| 1098854 | | 0 | false | 38082 | 0x782ed90c | | 0xeead394a017b8428e2d5a976a054f303f78f3c0c | 12182912 | 0x49b5c10a4aa292d13e3251b5f74722496272a565 | | 2021-04-06T00:21:16.000Z | 0xd3749684a1422e80081c9daa02992da06bf751776f7dfb5a1ccf7f32511d0211 |
| 865764 | | 0 | false | 488066 | 0x782ed90c | | 0xeead394a017b8428e2d5a976a054f303f78f3c0c | 12186307 | 0x53deea1808b6d2b8681241e3857b6c6ed1e7e103 | | 2021-04-06T12:59:52.000Z | 0xedb92393305c7df3aaf6b05bdab0e0b506b92b91c563c2544e5307f26ef3667f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.LiquidityProtection_removeLiquidity_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityProtectionV2\_addLiquidity\_function
Failed liquidity addition attempts to Bancor V1 Liquidity Protection contract on Ethereum. All sample transactions show failed status (status=false) with null input parameters, useful for analyzing transaction failures and gas costs during the May 2021 period.
| 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_poolAnchor` | `STRING` | Contract address of the pool anchor (Bancor V1 pool token) to which liquidity is being added. Null in failed transactions, otherwise a hex-encoded Ethereum address. |
| `in_reserveToken` | `STRING` | Contract address of the reserve token being added to the Bancor liquidity pool. Null in all sample rows indicating failed transactions where function parameters were not decoded. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | gas\_used | in\_amount | out\_anon0 | signature | to\_address | block\_number | from\_address | in\_poolAnchor | trace\_address | block\_timestamp | in\_reserveToken | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 670045 | 0 | false | 119762 | | | 0xe4a76726 | 0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e | 12500586 | 0x3323e4c51f4a819fe017c3aba9f8abbe4535d0ab | | | 2021-05-25T01:31:33.000Z | | 0x67dadd3804299622bd0e97f62374e4eeb169ff115124e8e3d9b1e52172b841af |
| 776765 | 0 | false | 117345 | | | 0xe4a76726 | 0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e | 12506361 | 0x695d1b61f09d07956af3f93d62aa79b1ab8fa29c | | | 2021-05-25T23:09:56.000Z | | 0xced564ce79590d730b331dcfbb6b14ea68a7e43973fac34de2739d7d6b20938a |
| 670045 | 0 | false | 119762 | | | 0xe4a76726 | 0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e | 12500629 | 0x3323e4c51f4a819fe017c3aba9f8abbe4535d0ab | | | 2021-05-25T01:40:25.000Z | | 0x7fcb46c2be872be49842c06a9ca684aaadd8d98906af8ac3a8cfaa0e51e04b7b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.LiquidityProtectionV2_addLiquidity_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityProtectionV2\_removeLiquidity\_function
Liquidity withdrawal transactions from Bancor v1's Liquidity Protection V2 contract on Ethereum, capturing position ID, portion removed (basis points), and transaction execution details. Used for analyzing liquidity provider exit patterns and impermanent loss protection claims.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_portion` | `STRING` | Portion of the liquidity position being removed, expressed in basis points where 1000000 represents 100%. All sample transactions show complete withdrawals (1000000 = 100% of position). |
| gas | in\_id | value | status | gas\_used | signature | in\_portion | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ------ | ----- | ------ | --------- | ---------- | ----------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 683517 | 52410 | 0 | true | 545779 | 0x782ed90c | 1000000 | 0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e | 14078886 | 0x06185869b7d687e56e707f7a6fb23f6c752ee08b | | 2022-01-26T03:33:44.000Z | 0x84e3573f9441907ba5e92137c579219a82953e2247683243b1fb5530f7e025f6 |
| 852552 | 34929 | 0 | true | 482356 | 0x782ed90c | 1000000 | 0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e | 14079320 | 0x12b6966160c37660effb630320f5a3cd1fb808f5 | | 2022-01-26T05:15:07.000Z | 0xc9379714c79053f3ba232922a1163c70dd3d82b1f0c1c438118cab66e9461c31 |
| 863552 | 29583 | 0 | true | 481556 | 0x782ed90c | 1000000 | 0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e | 14079319 | 0x12b6966160c37660effb630320f5a3cd1fb808f5 | | 2022-01-26T05:15:00.000Z | 0xcf855726a7766701bfa6a58a536ae65ae01a2be6e2930c8686c4360db34aa8b7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.LiquidityProtectionV2_removeLiquidity_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### NetworkSettings\_VortexBurnRewardUpdated\_event
Parameter updates for Bancor V1 Vortex burn rewards on Ethereum, capturing changes to reward rates (in parts per million) and maximum amounts. Used for tracking protocol incentive mechanism adjustments over time.
| 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_prevBurnRewardPPM` | `STRING` | Previous burn reward rate in parts per million (PPM), where 1,000,000 PPM equals 100%. This value represents the reward percentage before the update event occurred. |
| `in_newBurnRewardPPM` | `STRING` | New burn reward rate denominated in parts per million (PPM), where 1,000,000 PPM equals 100%. Represents the percentage of burned tokens awarded as rewards after a Vortex burn reward parameter update. |
| `in_prevBurnRewardMaxAmount` | `STRING` | Maximum token amount for vortex burn rewards before this update, denominated in wei (smallest unit). Null values indicate no previous limit was set. |
| `in_newBurnRewardMaxAmount` | `STRING` | Maximum amount of tokens that can be awarded as a burn reward after the update, denominated in the token's smallest unit (wei). This field captures the new ceiling value when the Vortex burn reward parameters are modified. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newBurnRewardPPM | in\_prevBurnRewardPPM | in\_newBurnRewardMaxAmount | in\_prevBurnRewardMaxAmount |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | --------------------- | -------------------------- | --------------------------- |
| 0x83e1814ba31f7ea95d216204bb45fe75ce09b14f | false | 3 | 14609482 | 2022-04-18T13:36:28.000Z | 0x4e41a1129816d40577716d2ea30407a1384110b4b3bfce3de0826ad69accf877 | 100000 | 0 | 100000000000000000000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.NetworkSettings_VortexBurnRewardUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### NetworkSettings21\_NetworkFeeUpdated\_event
Network fee parameter change events from Bancor V1 protocol on Ethereum, capturing previous and new fee values in basis points. Used for tracking protocol governance decisions and fee structure evolution over time.
| 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_prevNetworkFee` | `STRING` | Previous network fee value before the update, denominated in basis points (1/100th of 1%). Values typically range from 0 to 1,000,000, representing 0% to 10% fee rates on Bancor protocol swaps. |
| `in_newNetworkFee` | `STRING` | Previous network fee value in parts per million (PPM) before the update event. Typically ranges from 0 to 1,000,000 PPM, representing fee percentages up to 100%. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newNetworkFee | transaction\_hash | in\_prevNetworkFee |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------ |
| 0x59d03727d8f3fc695ca74f2dfdf0fd698424e0a2 | false | 324 | 13459971 | 2021-10-21T08:38:09.000Z | 150000 | 0x06e3ee885c4eedff8a1e02ebb336c9209a45bc6dee9239acbcc19c261f3c3f1e | 100000 |
| 0x59d03727d8f3fc695ca74f2dfdf0fd698424e0a2 | false | 12 | 12174531 | 2021-04-04T17:36:06.000Z | 50000 | 0xae21d3aaedaa82792f59bc1df2ac2fc2e16b07a89af53fc1018f3cdfed75a97e | 0 |
| 0x59d03727d8f3fc695ca74f2dfdf0fd698424e0a2 | false | 234 | 12563202 | 2021-06-03T18:44:51.000Z | 100000 | 0x3fcab2a41622368a602ff82d8645e5f048914e38f4b642b70ee73b033f3907f6 | 50000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.NetworkSettings21_NetworkFeeUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolCollection\_NetworkFeePPMUpdated\_event
Network fee updates for Bancor V1 liquidity pools on Ethereum, tracking changes in fee rates measured in parts-per-million (PPM). Used for analyzing protocol fee adjustments and revenue model changes over time.
| 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_prevFeePPM` | `STRING` | Previous fee rate in parts per million (PPM). String-encoded integer representing the fee as a proportion of 1,000,000 before the update. |
| `in_newFeePPM` | `STRING` | Updated fee rate in parts per million (PPM). String-encoded integer representing the fee as a proportion of 1,000,000. |
| address | removed | log\_index | block\_number | in\_newFeePPM | in\_prevFeePPM | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5ce51256651aa90eee24259a56529affcf13a3d0 | false | 93 | 15197787 | 200000 | 0 | 2022-07-23T08:12:48.000Z | 0xf1785eb273354e2cf053a3302983fae6ba3318b33130dadde7f6f798c6ee6f72 |
| 0x5ce51256651aa90eee24259a56529affcf13a3d0 | false | 198 | 15197795 | 900000 | 200000 | 2022-07-23T08:14:07.000Z | 0x8a0ce5b97556b05eac8e39ac8a3c212a010e908db4996365ea1756b63be89517 |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 141 | 15255742 | 900000 | 200000 | 2022-08-01T09:09:03.000Z | 0xdc2212dbe8f639c76a7b78f5349fcec6c5d5a28e79f2ad56088fa9e236f7190e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.PoolCollection_NetworkFeePPMUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolCollection\_TokensDeposited\_event
Liquidity deposit events from Bancor V1 protocol on Ethereum, capturing when providers add tokens to pools with corresponding pool token amounts minted. Used for tracking liquidity provider contributions, pool token issuance, and historical deposit activity across Bancor 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_contextId` | `STRING` | Unique identifier linking related events within a transaction or operation. 66-character hex string including 0x prefix. |
| `in_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_baseTokenAmount` | `STRING` | Amount of base tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_poolTokenAmount` | `STRING` | Amount of pool tokens involved in the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination. |
| address | removed | in\_token | log\_index | in\_provider | block\_number | in\_contextId | block\_timestamp | transaction\_hash | in\_baseTokenAmount | in\_poolTokenAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------ |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 0xa36fdbbae3c9d55a1d67ee5821d53b50b63a1ab9 | 179 | 0x750650d39d41cbf2afd591c22a204634eaa60db5 | 15820497 | 0x392f7493b7cd476491ea3d55f08901803295675a70d1594797786e250834d015 | 2022-10-24T21:02:59.000Z | 0x3c95dd2e14796f0259cc3c32c37238b0913c192289f21a3006cfc1548eb5e3f7 | 6112229054049512471957 | 6108063462444326446107 |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 0x444d6088b0f625f8c20192623b3c43001135e0fa | 305 | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 15817698 | 0x85eb369f92ab44f32b775b35adc211527efe4c4818a2df95d4c5b1943c2e0510 | 2022-10-24T11:34:47.000Z | 0x257edbe1fc081ac96abe99bd327469f0af205a497669807ed062dc9e741360b2 | 211393000000000000000000 | 195056141951122177729754 |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 0xb2cabf797bc907b049e4ccb5b84d13be3a8cfc21 | 207 | 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 15814465 | 0x650b11729fe2a7a450e2217ecbec921265498892e0e888d637e57e9aceeeb77d | 2022-10-24T00:43:47.000Z | 0xcf49454c47c3675e531cd330dfd876a6cf5e38a4a1499622edb998a0f56c689b | 1777500217032925399250 | 734921008846827679768 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.PoolCollection_TokensDeposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolCollection\_TokensWithdrawn\_event
Liquidity withdrawal events from Bancor V1 automated market maker (AMM) pools on Ethereum. Records provider withdrawals with pool token burns, base token amounts received, BNT (Bancor Network Token) amounts, and withdrawal fees for analyzing liquidity provider behavior.
| 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_contextId` | `STRING` | Unique identifier linking related events within a transaction or operation. 66-character hex string including 0x prefix. |
| `in_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_baseTokenAmount` | `STRING` | Amount of base tokens involved in the operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_poolTokenAmount` | `STRING` | Amount of pool tokens involved in the liquidity pool operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_externalProtectionBaseTokenAmount` | `STRING` | Amount of base tokens provided by external impermanent loss protection. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_bntAmount` | `STRING` | Amount of BNT (Bancor Network Token) involved in the operation. String-encoded integer representing the token quantity in its smallest denomination. |
| `in_withdrawalFeeAmount` | `STRING` | Fee amount charged on withdrawal from the liquidity pool. String-encoded integer representing the fee quantity in its smallest denomination. |
| address | removed | in\_token | log\_index | in\_provider | block\_number | in\_bntAmount | in\_contextId | block\_timestamp | transaction\_hash | in\_baseTokenAmount | in\_poolTokenAmount | in\_withdrawalFeeAmount | in\_externalProtectionBaseTokenAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ----------------------- | ----------------------- | ----------------------- | ------------------------------------- |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 266 | 0x1974ebe4f12c587a101e44795cccb3d52b8786f6 | 16519692 | 0 | 0xbddecb62059ba6723086c703b664df7a68a196d83ced9bfd57a5589c9301c876 | 2023-01-30T12:38:47.000Z | 0xacec44ddf0b3e89eb4214ee90085866f2af3c7d0f1f0ed9a8531e1bd9f8ee0be | 4163525629244907689 | 11029973522429226849 | 0 | 0 |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 0x514910771af9ca656af840dff83e8264ecf986ca | 278 | 0x697999ecfc86f0bfa43235bcf324cc7f186e3d54 | 16520503 | 0 | 0x1e420779467ef50c56d662124d591f0af56bc59c8da854ed7b34e0be2afe8055 | 2023-01-30T15:21:47.000Z | 0x7cf16ccb1079fd511106f1d623fbdb7f1e5209fd1d3e9943cf9e2e85756f3e0b | 716412582382567803901 | 1037783382700434851929 | 0 | 0 |
| 0xd982e001491d414c857f2a1aaa4b43ccf9f642b4 | false | 0x48fb253446873234f2febbf9bdeaa72d9d387f94 | 133 | 0xd7f397a87d0b308ae01c551553e95d3669506910 | 16517314 | 0 | 0xaee65f6b42c960ec5c1a86db9f356c64f56dc0a67f2754864991ead3b1b8c292 | 2023-01-30T04:40:59.000Z | 0x9729944ab0f26c0439a19ef9ae433fddba5721e4b8464976b45d7be4d4e68381 | 15447748019315590260254 | 16506643357562355685764 | 0 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.PoolCollection_TokensWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_RewardsClaimed\_event
Staking reward claim events from Bancor v1 protocol on Ethereum, capturing when liquidity providers withdraw their earned rewards. Records include provider address, claimed token amounts (in wei), and transaction details for tracking reward distribution and provider 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_amount | log\_index | in\_provider | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb443dea978b39178cb05ae005074227a4390dfce | false | 110832387085757718250 | 266 | 0xd4a1308212333a383d320aaee211aaa590f17660 | 12018961 | 2021-03-11T18:45:19.000Z | 0x27a550c4169584a2009bb72f180dbf653c48380a2a0cdf30b464bd9448ade57f |
| 0xb443dea978b39178cb05ae005074227a4390dfce | false | 331084573770660465902 | 240 | 0x54995a400169de148692b5da87b5ed65212b40a0 | 12015285 | 2021-03-11T04:58:19.000Z | 0xe3cfa19f60d6094cd59108d2193fc18071ca09f290bad37f8ed1c7207bbcd70f |
| 0xb443dea978b39178cb05ae005074227a4390dfce | false | 2909661840053690567108 | 238 | 0x270042a7623a90e6ebe6ae6e3263d61896b46906 | 12018738 | 2021-03-11T17:53:42.000Z | 0x8d387f43873622aa2fe7ee00ebae013e01c0150156ad0bdc16116b8ae73676f6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.StakingRewards_RewardsClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_RewardsStaked\_event
Staking reward events from Bancor v1 protocol on Ethereum, recording when liquidity providers stake pool tokens into rewards programs. Captures provider addresses, pool token addresses, staked amounts, and unique position IDs for analyzing staking activity and reward program participation.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_poolToken` | `STRING` | Contract address of the liquidity pool token representing shares in the pool. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_newId` | `STRING` | Unique identifier assigned to the staking position created when rewards are staked into a Bancor pool. Incrementing numeric value represented as a string, used to track individual staking positions. |
| address | removed | in\_newId | in\_amount | log\_index | in\_provider | block\_number | in\_poolToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ---------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x318fea7e45a7d3ac5999da7e1055f5982eeb3e67 | false | 51783 | 1105932860081497495487 | 520 | 0xecdd19b7d188524fa09fc43b9445f10ab11bed80 | 13915781 | 0xb1cd6e4153b2a390cf00a6556b0fc1458c4a5533 | 2021-12-31T22:35:31.000Z | 0x2f28a617fe1e136261458cad3068eb2e2ca1a164e215bbad0c392e85dadea0b6 |
| 0x318fea7e45a7d3ac5999da7e1055f5982eeb3e67 | false | 51773 | 4778681494649110242456 | 414 | 0xf887bd34d36c60b76d461b064c1fe247206f275b | 13911653 | 0xb1cd6e4153b2a390cf00a6556b0fc1458c4a5533 | 2021-12-31T06:57:33.000Z | 0x99aef374f108f27333ef9f85812dcd698b77c14ed3e5dbde804ad0ad1b6dbecd |
| 0x318fea7e45a7d3ac5999da7e1055f5982eeb3e67 | false | 51780 | 9350000000000000000000 | 75 | 0xdbcac67084fc86c550740fd6dc55261f964b2146 | 13915610 | 0xb1cd6e4153b2a390cf00a6556b0fc1458c4a5533 | 2021-12-31T21:56:03.000Z | 0xb94ec08a0ba5a111767cd2acc56625f3112322aad7acfae67c6615276e29d4ba |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.StakingRewards_RewardsStaked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewardsClaim\_RewardsClaimed\_event
Staking reward claim events from Bancor V1 liquidity providers on Ethereum, capturing the reward amount and provider address for each claim transaction. Used for analyzing liquidity provider earnings and reward distribution patterns.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_amount | log\_index | in\_provider | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6248e4118818c9075a142ef8a12e09d49888af58 | false | 38982999345794881236 | 94 | 0xcccb8df130a5993a48a7e625237bc4d5e5a2bafc | 15116271 | 2022-07-10T17:33:49.000Z | 0xa71bbe2fbf6204da63bec54fd86aa4d1b3966715cc00b3f8ab7c52db1790c0e0 |
| 0x6248e4118818c9075a142ef8a12e09d49888af58 | false | 313177305584223996900 | 230 | 0xb6c7d43ff53fab1a66ec5cce0cc915b30b2b898f | 15114261 | 2022-07-10T09:57:35.000Z | 0x58105cd21469997901979289aae51ea15851157d9589a365c2cec7dc29c6bd81 |
| 0x6248e4118818c9075a142ef8a12e09d49888af58 | false | 46927947448486735144 | 119 | 0x2eda1a1112166deb2c88a24264cb26b3632d5af1 | 15113080 | 2022-07-10T05:46:37.000Z | 0x8bac0740f8fdcfc481fb82eb057b413fdf1453df7803dfcdbf4174b72a7e9fbc |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.StakingRewardsClaim_RewardsClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewardsClaim\_RewardsStaked\_event
RewardsStaked events from Bancor v1 staking rewards contract on Ethereum, recording when liquidity providers restake their claimed rewards with provider addresses and restaked amounts in wei. Used for tracking reward compounding behavior and staking position growth.
| 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_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | in\_amount | log\_index | in\_provider | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6248e4118818c9075a142ef8a12e09d49888af58 | false | 21526477595005940880 | 72 | 0x27009520fd9974f2815a611d5943e4d4b0495bef | 14881752 | 2022-06-01T00:18:19.000Z | 0x8a0cbc3b1b9c8cfd9581f8bdbc78f327aefa36c91f0600dff73136f4e7ec567f |
| 0x6248e4118818c9075a142ef8a12e09d49888af58 | false | 677847183736649845334 | 489 | 0xe5516f4d30e5989bf6e3ea62055cf3a704d9da01 | 14885823 | 2022-06-01T16:26:45.000Z | 0xec968c52592a56edfe0834b9682aa821d663510d218127f10ae9269015b427cf |
| 0x6248e4118818c9075a142ef8a12e09d49888af58 | false | 46839125742180628414 | 672 | 0x6c87a52ad7b8c337845e8e4fa99a797af0c5128f | 14881936 | 2022-06-01T01:02:46.000Z | 0x64ec52c95b48c83004615418ed61be871a7593129c503d86b287ebfca6a39995 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.StakingRewardsClaim_RewardsStaked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StandardRewards\_RewardsClaimed\_event
Liquidity mining reward claim events from Bancor V1 protocol on Ethereum, recording provider addresses, pool tokens, reward amounts, and program identifiers. Used for analyzing liquidity provider incentive distribution and reward program participation across different token 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_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_programId` | `STRING` | Identifier of the Bancor rewards program from which the provider is claiming rewards. String-encoded numeric value referencing a specific liquidity mining or incentive program on the platform. |
| `in_provider` | `STRING` | Address of the liquidity provider or participant in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_pool | removed | in\_amount | log\_index | in\_provider | block\_number | in\_programId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 0xb2cabf797bc907b049e4ccb5b84d13be3a8cfc21 | false | 79824664057856208815 | 61 | 0x5ecea38f6b7239339ab526085eae0c54cd4df4d9 | 15809362 | 10 | 2022-10-23T07:36:59.000Z | 0x524d4baef9c0b9f7812b9e82dc33fd50fdd51b585245a3c8f320196be264bf59 |
| 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 0x514910771af9ca656af840dff83e8264ecf986ca | false | 14741900892578693633 | 621 | 0x49d2e0809d7a21de5d12803ce1af8b22df020a3d | 15237252 | 8 | 2022-07-29T12:08:12.000Z | 0x0d420e8441fa259e53d985eb3b6062e352896ae1f9b4180fcc61edc73ffc1385 |
| 0xb0b958398abb0b5db4ce4d7598fb868f5a00f372 | 0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c | false | 3867177677970397911 | 622 | 0x49d2e0809d7a21de5d12803ce1af8b22df020a3d | 15237252 | 5 | 2022-07-29T12:08:12.000Z | 0x0d420e8441fa259e53d985eb3b6062e352896ae1f9b4180fcc61edc73ffc1385 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.StandardRewards_RewardsClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### vBNT\_Destruction\_event
vBNT (vote-locked BNT) token burn events from Bancor V1 protocol on Ethereum, recording governance token destruction amounts and contract addresses. Used for tracking vBNT supply changes and governance token circulation analysis.
| 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__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| address | removed | log\_index | in\_\_amount | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x48fb253446873234f2febbf9bdeaa72d9d387f94 | false | 258 | 996293002004249330395 | 12485856 | 2021-05-22T18:56:34.000Z | 0xa09e92da8f48dabd5db1a576268f0a6806de551d6e9c643727f8032c8eefbcaa |
| 0x48fb253446873234f2febbf9bdeaa72d9d387f94 | false | 260 | 45980117740000000000000 | 12485588 | 2021-05-22T17:56:08.000Z | 0xec926f2c0db67ce7b0934ecd466e86da56c45c850f337e2ee3e6a8ba7a95d014 |
| 0x48fb253446873234f2febbf9bdeaa72d9d387f94 | false | 261 | 18595633194937760887190 | 12485869 | 2021-05-22T18:59:04.000Z | 0xc9b2894a822cf65837fe17f14291fa5846b376c5abde9911360aaf08f600c52b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.vBNT_Destruction_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_Approval\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_approved` | `STRING` | Boolean flag indicating whether approval was granted or revoked for the operation. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_ApprovalForAll\_event
ApprovalForAll events from Bancor v1 Voucher contract on Ethereum, recording when token owners grant or revoke operator permissions to manage all their vouchers. Used for tracking delegation of trading authority and third-party approvals for liquidity positions.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_operator` | `STRING` | Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_approved` | `BOOL` | Boolean flag indicating whether approval was granted or revoked for the operation. |
| address | removed | in\_owner | log\_index | in\_approved | in\_operator | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x3660f04b79751e31128f6378eac70807e38f554e | false | 0x3d0bb7cb65467aaf491640f110da7822b06aadce | 208 | true | 0x616ac240bccc24d0e77f994019e4a407e8dee4b2 | 18569740 | 2023-11-14T11:06:59.000Z | 0xcd2832935474afc5b45b8d1c91f1649f37326f6f9485afe73d462fb5544dfd1d |
| 0x3660f04b79751e31128f6378eac70807e38f554e | false | 0x3038b6ddf96e18c9d7f7b4fecaf7ea0d69c27de1 | 92 | true | 0x1e0049783f008a0085193e00003d00cd54003c71 | 19038434 | 2024-01-19T04:10:59.000Z | 0x1e22cbcf69435450374890674e39c7cc94e586db5643b464551dffc20a00599b |
| 0x3660f04b79751e31128f6378eac70807e38f554e | false | 0xeb57dd0a036e0bf4bf16a00c2697c3f6b54d10ab | 253 | true | 0x1e0049783f008a0085193e00003d00cd54003c71 | 18779078 | 2023-12-13T18:38:11.000Z | 0xa303df080f27125b9ae0c672510354339c2002468991a77d4f15d98c409c7a5f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_ApprovalForAll_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_BaseExtensionUpdated\_event
*No description available.*
| 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_newBaseExtension` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_BaseExtensionUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_BaseURIUpdated\_event
*No description available.*
| 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_newBaseURI` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_BaseURIUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_Initialized\_event
Initialization events for Bancor v1 voucher contracts on Ethereum, tracking when new voucher instances are deployed with their contract addresses and version numbers. Used for identifying and cataloging Bancor liquidity pool token contracts.
| 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_version` | `INT64` | Version identifier for the contract or event schema. String or integer value indicating the initialization or state version. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x3660f04b79751e31128f6378eac70807e38f554e | false | 251 | 1 | 17087131 | 2023-04-20T10:31:23.000Z | 0xd97eb5e3ea04719f29fa12eed85412e5cbac2622ada0c6684b6f9647265a80a4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_RoleAdminChanged\_event
Role administration change events from Bancor v1 voucher contracts on Ethereum, tracking updates to role-based access control permissions. Records role identifier hashes, previous and new admin roles, and contract addresses for monitoring governance and permission management.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_previousAdminRole` | `STRING` | Previous admin role identifier before the role change. 66-character keccak256 hash including 0x prefix. |
| `in_newAdminRole` | `STRING` | New admin role identifier for the specified role. 66-character keccak256 hash including 0x prefix. |
| address | in\_role | removed | log\_index | block\_number | block\_timestamp | in\_newAdminRole | transaction\_hash | in\_previousAdminRole |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------------------------------ |
| 0x3660f04b79751e31128f6378eac70807e38f554e | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 248 | 17087131 | 2023-04-20T10:31:23.000Z | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | 0xd97eb5e3ea04719f29fa12eed85412e5cbac2622ada0c6684b6f9647265a80a4 | 0x0000000000000000000000000000000000000000000000000000000000000000 |
| 0x3660f04b79751e31128f6378eac70807e38f554e | 0xaeaef46186eb59f884e36929b6d682a6ae35e1e43d8f05f058dcefb92b601461 | false | 250 | 17087131 | 2023-04-20T10:31:23.000Z | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | 0xd97eb5e3ea04719f29fa12eed85412e5cbac2622ada0c6684b6f9647265a80a4 | 0x0000000000000000000000000000000000000000000000000000000000000000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_RoleAdminChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_RoleGranted\_event
Role assignment events from Bancor v1 voucher contracts on Ethereum, tracking access control grants and revocations. Used for analyzing administrative permissions and governance changes across Bancor protocol components.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_role | removed | in\_sender | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x3660f04b79751e31128f6378eac70807e38f554e | 0xaeaef46186eb59f884e36929b6d682a6ae35e1e43d8f05f058dcefb92b601461 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 103 | 0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1 | 17087469 | 2023-04-20T11:39:59.000Z | 0x7ce158a8ddcd4b5ba051ebe4484e5f4abc85dd44540789b1252ea84e818814f7 |
| 0x3660f04b79751e31128f6378eac70807e38f554e | 0x2172861495e7b85edac73e3cd5fbb42dd675baadf627720e687bcfdaca025096 | false | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 249 | 0x5beba4d3533a963dedb270a95ae5f7752fa0fe22 | 17087131 | 2023-04-20T10:31:23.000Z | 0xd97eb5e3ea04719f29fa12eed85412e5cbac2622ada0c6684b6f9647265a80a4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_RoleGranted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_RoleRevoked\_event
*No description available.*
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_RoleRevoked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_Transfer\_event
NFT voucher transfer events from Bancor V1 liquidity positions on Ethereum, tracking mints (from zero address) and burns (to zero address) of tokenized liquidity provider positions. Used for analyzing liquidity provision activity and LP token ownership changes.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| in\_to | address | in\_from | removed | log\_index | in\_tokenId | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ----------------------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0000000000000000000000000000000000000000 | 0x3660f04b79751e31128f6378eac70807e38f554e | 0xc0f07a9301d18a44f9322b7d6fd7f2c17733336e | false | 139 | 4763953136893138488487244504044754960408 | 17505060 | 2023-06-18T07:03:23.000Z | 0x3047ac6b75683db4988ebd1d00134d0e98ab1bcfb5054bd378aeb5d2a47f09c2 |
| 0xdf1aa31f03ae4f7890278ae28c73f059c2536396 | 0x3660f04b79751e31128f6378eac70807e38f554e | 0x0000000000000000000000000000000000000000 | false | 202 | 82008050427946169694673280391056138961587 | 18946217 | 2024-01-06T05:51:23.000Z | 0xbe606e5ac53d4ea293a8e0bfe99d6dd5529e468f8c09f0704818a96fb85f010f |
| 0x0000000000000000000000000000000000000000 | 0x3660f04b79751e31128f6378eac70807e38f554e | 0x41f57a9c25d6f9607b85fac6fe778c265d8575f6 | false | 190 | 3743106036130323098097120681749450326148 | 17405919 | 2023-06-04T07:58:35.000Z | 0x7b6f7b2bc431810d85d2699adf0a606177cf03f66257e34f1d5324cddd378c37 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voucher\_UseGlobalURIUpdated\_event
*No description available.*
| 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_newUseGlobalURI` | `BOOL` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.bancor_v1_ethereum.Voucher_UseGlobalURIUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***