bancor_v1_ethereum - Token Terminal Docs

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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.

Sample Data

gas	value	status	in_pool	gas_used	out_anon0	signature	to_address	block_number	from_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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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.

Sample Data

gas	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	false		43885		0xb3db428b	0xeef417e1d5cc832e619ae18d2f140de2999dd4fb		14716922	0xb0b958398abb0b5db4ce4d7598fb868f5a00f372	0,4		2022-05-05T11:11:46.000Z	0x047ed3e2dee6473174cc54f63a3ac384b97be327772136ee2ba638267af8501a
657649	true	0x6b175474e89094c44da98b954eedeac495271d0f	92049	599931107089467535941779	0xb3db428b	0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	0xb0b958398abb0b5db4ce4d7598fb868f5a00f372	14716924	0xb0b958398abb0b5db4ce4d7598fb868f5a00f372	0,4	600000000000000000000000	2022-05-05T11:12:53.000Z	0xd845fc3b5bc7d4a681dce1b5a5eb850ac37311223a8150414c0310044088dfaa
657637	true	0x6b175474e89094c44da98b954eedeac495271d0f	92049	499942589241222946618149	0xb3db428b	0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	0xb0b958398abb0b5db4ce4d7598fb868f5a00f372	14717215	0xb0b958398abb0b5db4ce4d7598fb868f5a00f372	0,4	500000000000000000000000	2022-05-05T12:17:40.000Z	0x82ea96b15884561d4835417c86ca87bfbc0e46b1f933e2c23727562f25033de8

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

address	removed	in_token	in_amount	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	false	0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c	20701530318273057000000	442	0x41eeba3355d7d6ff628b7982f3f9d055c39488cb	16927798	2023-03-28T19:06:59.000Z	0xf70ec3cc6b5b2358cdc06584de88c671da11fb6a0ef0108a091b4ca9ac4cb58e
0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	false	0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c	6646180546506721000000	311	0x41eeba3355d7d6ff628b7982f3f9d055c39488cb	16925187	2023-03-28T10:17:11.000Z	0x6d068f8e19f3bca0a838551e04ea542c716943d6027a602710915bb4f694d603
0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	false	0x1f573d6fb3f13d689ff844b4ce37794d79a7ff1c	13380615867457427000000	74	0x41eeba3355d7d6ff628b7982f3f9d055c39488cb	16924080	2023-03-28T06:31:47.000Z	0x5e1addd68fc33c71b2f363eb99ce016d73e7ff65599d9a60d1af9c564b9317a9

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_poolCollection`	`STRING`	Contract address of the pool collection managing the referenced pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_poolCollection`	`STRING`	Contract address of the pool collection managing the referenced pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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.

Sample Data

gas	in_id	status	gas_used	out_anon0	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
375199	9305	true	293630		0x2e1a7d4d	0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	23003399	0x18571698d3a7c1f5f768b79e0b0cbfd87cd712bf	2025-07-26T12:43:59.000Z	0xd8e724e29ed61fb459e03738141c1114ae72885540142525aa3300fcd2d4d03a
397921	9306	true	309095	136229564506410135593	0x2e1a7d4d	0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	23003409	0x18571698d3a7c1f5f768b79e0b0cbfd87cd712bf	2025-07-26T12:45:59.000Z	0x10a20f7c5786382ae520e4d29471b90e20a713f5d56504e9da801dafd7a58f8e
268382	9307	true	209512	3379161707140921290132	0x2e1a7d4d	0xeef417e1d5cc832e619ae18d2f140de2999dd4fb	23003415	0x18571698d3a7c1f5f768b79e0b0cbfd87cd712bf	2025-07-26T12:47:11.000Z	0x172bb65918d3670949cf3c34f25b4ae8b601cfbb586c0a2f1abfed53a36a901e

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__value`	`STRING`	Amount transferred, approved, deposited, or withdrawn in the transaction. String-encoded integer representing token quantity in smallest denomination (wei for ETH, base units for ERC20 tokens).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0xc537e898cd774e2dcba3b14ea6f34c93d5ea45e1	false	254	1	17087375	2023-04-20T11:20:59.000Z	0xa8c33dd6939277c3dae2307d5ccf98fa35d2f727cb4f0d95111089615775b77e

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<y STRING, z STRING, A STRING, B STRING>`	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<y STRING, z STRING, A STRING, B STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<y STRING, z STRING, A STRING, B STRING>`	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<y STRING, z STRING, A STRING, B STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<y STRING, z STRING, A STRING, B STRING>`	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<y STRING, z STRING, A STRING, B STRING>`	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.

Sample Data

in_id	address	removed	in_order0	in_order1	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”}	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”}	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”}	0x7721a4cb6190edb11d47f51c20968436eccdafb8	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	777	18131767	2023-09-14T03:12:59.000Z	0x2acbd28c7c4dfe06ef248fece9c2bdbbc21b212035b580b8170a40c8984f3beb

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0xba7d1581db6248dc9177466a328bf457703c8f84	false	135	1	17087475	2023-04-20T11:41:11.000Z	0xc26ab98d01d3d8d8fcde878e09e69497b3418d74544ec3ee8f600ff6ed320b7e

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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%.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_rewardAmounts`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
908864	false	90935	0xe4a76726	0xeead394a017b8428e2d5a976a054f303f78f3c0c	11864577	0x7a22e7a4d912231f9c0fb6760c59ab560188360b	2021-02-16T00:32:03.000Z	0xc6e66608b1e7ba1b3e3af6f4b965505aee9bd97771be497634e5bbd434c2d459
719644	false	258532	0xe4a76726	0xeead394a017b8428e2d5a976a054f303f78f3c0c	11869916	0x34cadf09dbf50a39d1a68b87d7763db3961ef483	2021-02-16T20:06:07.000Z	0x030b5424f9a241195bb6105351bd531f754b25d6b3145ce594f11292a7953098
937167	false	524996	0xe4a76726	0xeead394a017b8428e2d5a976a054f303f78f3c0c	11865657	0x035fc3b0ec2487c1c9def561f578ec77a06b1b12	2021-02-16T04:30:22.000Z	0xe913c8836f35251b887961d36659fc2ef3e98fbfb634151285a325a23929b106

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
903585	false	38082	0x782ed90c	0xeead394a017b8428e2d5a976a054f303f78f3c0c	12183307	0x447ecbd0cb12fe94cbe8ff3a49fbf3acc23fdf41	2021-04-06T01:59:03.000Z	0x7a8b4be503377582896fc56e6fa0f768097bb122bd7f78c4333a81cdf68b926e
1098854	false	38082	0x782ed90c	0xeead394a017b8428e2d5a976a054f303f78f3c0c	12182912	0x49b5c10a4aa292d13e3251b5f74722496272a565	2021-04-06T00:21:16.000Z	0xd3749684a1422e80081c9daa02992da06bf751776f7dfb5a1ccf7f32511d0211
865764	false	488066	0x782ed90c	0xeead394a017b8428e2d5a976a054f303f78f3c0c	12186307	0x53deea1808b6d2b8681241e3857b6c6ed1e7e103	2021-04-06T12:59:52.000Z	0xedb92393305c7df3aaf6b05bdab0e0b506b92b91c563c2544e5307f26ef3667f

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
670045	false	119762	0xe4a76726	0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e	12500586	0x3323e4c51f4a819fe017c3aba9f8abbe4535d0ab	2021-05-25T01:31:33.000Z	0x67dadd3804299622bd0e97f62374e4eeb169ff115124e8e3d9b1e52172b841af
776765	false	117345	0xe4a76726	0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e	12506361	0x695d1b61f09d07956af3f93d62aa79b1ab8fa29c	2021-05-25T23:09:56.000Z	0xced564ce79590d730b331dcfbb6b14ea68a7e43973fac34de2739d7d6b20938a
670045	false	119762	0xe4a76726	0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e	12500629	0x3323e4c51f4a819fe017c3aba9f8abbe4535d0ab	2021-05-25T01:40:25.000Z	0x7fcb46c2be872be49842c06a9ca684aaadd8d98906af8ac3a8cfaa0e51e04b7b

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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).

Sample Data

gas	in_id	status	gas_used	signature	in_portion	to_address	block_number	from_address	block_timestamp	transaction_hash
683517	52410	true	545779	0x782ed90c	1000000	0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e	14078886	0x06185869b7d687e56e707f7a6fb23f6c752ee08b	2022-01-26T03:33:44.000Z	0x84e3573f9441907ba5e92137c579219a82953e2247683243b1fb5530f7e025f6
852552	34929	true	482356	0x782ed90c	1000000	0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e	14079320	0x12b6966160c37660effb630320f5a3cd1fb808f5	2022-01-26T05:15:07.000Z	0xc9379714c79053f3ba232922a1163c70dd3d82b1f0c1c438118cab66e9461c31
863552	29583	true	481556	0x782ed90c	1000000	0x853c2d147a1bd7eda8fe0f58fb3c5294db07220e	14079319	0x12b6966160c37660effb630320f5a3cd1fb808f5	2022-01-26T05:15:00.000Z	0xcf855726a7766701bfa6a58a536ae65ae01a2be6e2930c8686c4360db34aa8b7

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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%.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

address	removed	in_token	log_index	in_provider	block_number	in_contextId	block_timestamp	transaction_hash	in_baseTokenAmount	in_poolTokenAmount
0xd982e001491d414c857f2a1aaa4b43ccf9f642b4	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	266	0x1974ebe4f12c587a101e44795cccb3d52b8786f6	16519692	0xbddecb62059ba6723086c703b664df7a68a196d83ced9bfd57a5589c9301c876	2023-01-30T12:38:47.000Z	0xacec44ddf0b3e89eb4214ee90085866f2af3c7d0f1f0ed9a8531e1bd9f8ee0be	4163525629244907689	11029973522429226849
0xd982e001491d414c857f2a1aaa4b43ccf9f642b4	false	0x514910771af9ca656af840dff83e8264ecf986ca	278	0x697999ecfc86f0bfa43235bcf324cc7f186e3d54	16520503	0x1e420779467ef50c56d662124d591f0af56bc59c8da854ed7b34e0be2afe8055	2023-01-30T15:21:47.000Z	0x7cf16ccb1079fd511106f1d623fbdb7f1e5209fd1d3e9943cf9e2e85756f3e0b	716412582382567803901	1037783382700434851929
0xd982e001491d414c857f2a1aaa4b43ccf9f642b4	false	0x48fb253446873234f2febbf9bdeaa72d9d387f94	133	0xd7f397a87d0b308ae01c551553e95d3669506910	16517314	0xaee65f6b42c960ec5c1a86db9f356c64f56dc0a67f2754864991ead3b1b8c292	2023-01-30T04:40:59.000Z	0x9729944ab0f26c0439a19ef9ae433fddba5721e4b8464976b45d7be4d4e68381	15447748019315590260254	16506643357562355685764

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address 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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address 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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newBaseExtension`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newBaseURI`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x3660f04b79751e31128f6378eac70807e38f554e	false	251	1	17087131	2023-04-20T10:31:23.000Z	0xd97eb5e3ea04719f29fa12eed85412e5cbac2622ada0c6684b6f9647265a80a4

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newUseGlobalURI`	`BOOL`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

balancer_v2_polygon bancor_v3_ethereum

⌘I

​Tables

​AutoCompoundingRewards_RewardsDistributed_event

​BancorNetwork_deposit_function

​BancorNetwork_depositFor_function

​BancorNetwork_FlashLoanCompleted_event

​BancorNetwork_PoolAdded_event

​BancorNetwork_PoolCreated_event

​BancorNetwork_TokensTraded_event

​BancorNetwork_withdraw_function

​BancorNetworkV21_Conversion_event

​BNT_Destruction_event

​BNT_Issuance_event

​BNT_Transfer_event

​CarbonController_FeesWithdrawn_event

​CarbonController_Initialized_event

​CarbonController_PairCreated_event

​CarbonController_Paused_event

​CarbonController_RoleAdminChanged_event

​CarbonController_RoleGranted_event

​CarbonController_RoleRevoked_event

​CarbonController_StrategyCreated_event

​CarbonController_StrategyDeleted_event

​CarbonController_StrategyUpdated_event

​CarbonController_TokensTraded_event

​CarbonController_TradingFeePPMUpdated_event

​CarbonController_Unpaused_event

​CarbonVortex_Initialized_event

​CarbonVortex_RewardsUpdated_event

​CarbonVortex_RoleAdminChanged_event

​CarbonVortex_RoleGranted_event

​CarbonVortex_RoleRevoked_event

​CarbonVortex_TokensBurned_event

​Converter_Conversion_event

​Converter_LiquidityAdded_event

​Converter_LiquidityRemoved_event

​Factory_NewConverter_event

​Factory2_NewConverter_event

​LiquidityProtection_addLiquidity_function

​LiquidityProtection_removeLiquidity_function

​LiquidityProtectionV2_addLiquidity_function

​LiquidityProtectionV2_removeLiquidity_function

​NetworkSettings_VortexBurnRewardUpdated_event

​NetworkSettings21_NetworkFeeUpdated_event

​PoolCollection_NetworkFeePPMUpdated_event

​PoolCollection_TokensDeposited_event

​PoolCollection_TokensWithdrawn_event

​StakingRewards_RewardsClaimed_event

​StakingRewards_RewardsStaked_event

​StakingRewardsClaim_RewardsClaimed_event

​StakingRewardsClaim_RewardsStaked_event

​StandardRewards_RewardsClaimed_event

​vBNT_Destruction_event

​Voucher_Approval_event

​Voucher_ApprovalForAll_event

​Voucher_BaseExtensionUpdated_event

​Voucher_BaseURIUpdated_event

​Voucher_Initialized_event

​Voucher_RoleAdminChanged_event

​Voucher_RoleGranted_event

​Voucher_RoleRevoked_event

​Voucher_Transfer_event

​Voucher_UseGlobalURIUpdated_event

Tables

AutoCompoundingRewards_RewardsDistributed_event

BancorNetwork_deposit_function

BancorNetwork_depositFor_function

BancorNetwork_FlashLoanCompleted_event

BancorNetwork_PoolAdded_event

BancorNetwork_PoolCreated_event

BancorNetwork_TokensTraded_event

BancorNetwork_withdraw_function

BancorNetworkV21_Conversion_event

BNT_Destruction_event

BNT_Issuance_event

BNT_Transfer_event

CarbonController_FeesWithdrawn_event

CarbonController_Initialized_event

CarbonController_PairCreated_event

CarbonController_Paused_event

CarbonController_RoleAdminChanged_event

CarbonController_RoleGranted_event

CarbonController_RoleRevoked_event

CarbonController_StrategyCreated_event

CarbonController_StrategyDeleted_event

CarbonController_StrategyUpdated_event

CarbonController_TokensTraded_event

CarbonController_TradingFeePPMUpdated_event

CarbonController_Unpaused_event

CarbonVortex_Initialized_event

CarbonVortex_RewardsUpdated_event

CarbonVortex_RoleAdminChanged_event

CarbonVortex_RoleGranted_event

CarbonVortex_RoleRevoked_event

CarbonVortex_TokensBurned_event

Converter_Conversion_event

Converter_LiquidityAdded_event

Converter_LiquidityRemoved_event

Factory_NewConverter_event

Factory2_NewConverter_event

LiquidityProtection_addLiquidity_function

LiquidityProtection_removeLiquidity_function

LiquidityProtectionV2_addLiquidity_function

LiquidityProtectionV2_removeLiquidity_function

NetworkSettings_VortexBurnRewardUpdated_event

NetworkSettings21_NetworkFeeUpdated_event

PoolCollection_NetworkFeePPMUpdated_event

PoolCollection_TokensDeposited_event

PoolCollection_TokensWithdrawn_event

StakingRewards_RewardsClaimed_event

StakingRewards_RewardsStaked_event

StakingRewardsClaim_RewardsClaimed_event

StakingRewardsClaim_RewardsStaked_event

StandardRewards_RewardsClaimed_event

vBNT_Destruction_event

Voucher_Approval_event

Voucher_ApprovalForAll_event

Voucher_BaseExtensionUpdated_event

Voucher_BaseURIUpdated_event

Voucher_Initialized_event

Voucher_RoleAdminChanged_event

Voucher_RoleGranted_event

Voucher_RoleRevoked_event

Voucher_Transfer_event

Voucher_UseGlobalURIUpdated_event