gearbox_v1_ethereum

Tables

CreditManager_CloseCreditAccount_event

Credit account closure events from Gearbox V1 protocol on Ethereum, recording the owner, recipient, and remaining funds when leveraged credit positions are closed. Used for analyzing protocol liquidations, user position management, and capital efficiency.

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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remainingFunds`	`STRING`	Amount of funds returned to the credit account owner after closing their position, denominated in the smallest unit of the underlying asset. Values are string-encoded integers representing wei or similar base units, typically ranging from billions to quadrillions.

Sample Data

in_to	address	removed	in_owner	log_index	block_number	block_timestamp	transaction_hash	in_remainingFunds
0x2cb2e17d23ee7fcf8691afd998f52b1af362ded5	0x2664cc24cbad28749b3dd6fc97a6b402484de527	false	0x2cb2e17d23ee7fcf8691afd998f52b1af362ded5	136	14163098	2022-02-08T03:48:11.000Z	0xd0ff6abd64ee4f5ee06bc309b5f3cccf6801b802c6187fc347611416577d3007	1101503693
0xfe22b1709a8ef6aeb49d0e35128a0d3eb315cde1	0x2664cc24cbad28749b3dd6fc97a6b402484de527	false	0xfe22b1709a8ef6aeb49d0e35128a0d3eb315cde1	313	14163145	2022-02-08T03:59:40.000Z	0x0ae5ab8b50e2205c05d503ce49cc1216d98019641acb11a7032ce9da16436269	7832548697
0xa89c470df27ffcbe80926dcdae86a4d19aaab59d	0x2664cc24cbad28749b3dd6fc97a6b402484de527	false	0xa89c470df27ffcbe80926dcdae86a4d19aaab59d	163	14481296	2022-03-29T13:15:26.000Z	0x9043addc4758b30e723028d1d32af12264f572b179430345fe8b3d8a4a4dc9db	10674235118

Example Query

Query with partition filter

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

CreditManager_LiquidateCreditAccount_event

Liquidation events from Gearbox v1 protocol credit accounts on Ethereum, recording when undercollateralized positions are closed by liquidators. Contains account owner addresses, liquidator addresses, and remaining funds after liquidation for analyzing protocol risk and liquidation efficiency.

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_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remainingFunds`	`STRING`	Amount of funds remaining in the credit account after liquidation, denominated in the smallest unit of the underlying token (e.g., wei for ETH). These are the residual funds returned to the original account owner after debt and fees are settled.

Sample Data

address	removed	in_owner	log_index	block_number	in_liquidator	block_timestamp	transaction_hash	in_remainingFunds
0x777e23a2acb2fcbb35f6ccf98272d03c722ba6eb	false	0xfe32a37f15ee4a4b59715530e5817d1322b9df80	105	14054765	0xad4b61f5bce7841e0c5dea42f8f00a17e95bfd9a	2022-01-22T10:07:13.000Z	0xbd31df0470f24216acdf05da0a1669aa0e0152fd5c046a333ccfe9af3526cd9a	430521967763687774556
0x2664cc24cbad28749b3dd6fc97a6b402484de527	false	0x9b3f49a186670194f625199b822fcbdfd3feacf7	962	14054312	0x43faf3f8bef053d901c572edc32f055c20efb764	2022-01-22T08:28:02.000Z	0x6ff228c928958b7c8837fd7bb7283c4cd9f874245abb6a12d5e1e9b83433d0ef	1589808977
0x2664cc24cbad28749b3dd6fc97a6b402484de527	false	0xd01a2311ca001241502394d25bc08b0ad8cd2229	265	14688158	0x42ccf4f456d7c7febf274242caccd74aaa0a53d7	2022-04-30T22:06:28.000Z	0xeed949c9174bbbe772befe4c7d8f7aec651dc0a4e8df3b8fb5e664f9ac7fb9f5	373900120

Example Query

Query with partition filter

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

CreditManager_OpenCreditAccount_event

Credit account opening events from Gearbox V1 protocol on Ethereum, capturing initial collateral amounts, borrowed amounts, and account addresses when users open leveraged positions. Used for analyzing leverage ratios, borrowing patterns, and user acquisition across different Gearbox credit managers.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_creditAccount`	`STRING`	Address of the credit account associated with 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.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	in_onBehalfOf	block_timestamp	in_borrowAmount	in_creditAccount	transaction_hash
0x968f9a68a98819e2e6bb910466e191a7b6cf02f0	false	2500000000000000000	0x4f952c4c5415b2609899abdc2f8f352f600d14d6	315	14068880	0x41797b5e0398af475422f6f33f2dc81d9a24ae33	2022-01-24T14:37:43.000Z	7500000000000000000	0xc5d4f0bbbdf94ce68d3a88d4caafd8dc9241e4f1	0x298ba5c617bcc469ad03b7dae38a2fc6bee778a58b8d3f27d9a6b9a32cdfb8f0
0x968f9a68a98819e2e6bb910466e191a7b6cf02f0	false	300000000000000000	0x4f952c4c5415b2609899abdc2f8f352f600d14d6	150	14070449	0x696969536948c9902a622ddb9d959ae4038f5cbb	2022-01-24T20:25:52.000Z	900000000000000000	0x653d7a1a903827a5195b21283ea9714b6f1b3f7d	0xa8282ef62d8a6d451e0d74d061f209abd2def9f2d17696ae919f2a1e38a37dc9
0x777e23a2acb2fcbb35f6ccf98272d03c722ba6eb	false	3657471542816664360101	0x67de6d9bd31f8baf7147a953fc1f42b71b0c9c6e	440	14070618	0x67de6d9bd31f8baf7147a953fc1f42b71b0c9c6e	2022-01-24T20:58:58.000Z	6437149915357329273777	0x08dd8994b7897a93c201ca7be6a16dc20422891a	0xd11abbf000e12b3f7b29ce672830e0c3cabd7472ed6577d55a5805ccb2c0c2cf

Example Query

Query with partition filter

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

CreditManager_RepayCreditAccount_event

Credit account repayment events from Gearbox V1 leveraged trading protocol on Ethereum. Records when users close their leveraged positions by repaying borrowed funds, including the account owner and recipient addresses.

Columns

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

Sample Data

in_to	address	removed	in_owner	log_index	block_number	block_timestamp	transaction_hash
0x092518f41762e9874d925cfbe26dc3f7e2b73881	0x968f9a68a98819e2e6bb910466e191a7b6cf02f0	false	0x092518f41762e9874d925cfbe26dc3f7e2b73881	306	13940428	2022-01-04T17:57:27.000Z	0x34772f0d3ca2c59d9e18f0fb99336c05e2367cd1de0c469a9f6ea8937f715798
0x72fa7697238e2c89c9b07e9200aa05f1481ecde1	0x2664cc24cbad28749b3dd6fc97a6b402484de527	false	0x72fa7697238e2c89c9b07e9200aa05f1481ecde1	589	15002798	2022-06-21T14:48:35.000Z	0xe9162d444ba3d2b8128d53b16a9682123975b3d3ea08b355c66b841d6ff83348
0x4d5daadc1bf9aa1c023fe1a9f75545b3863dfd14	0xc38478b0a4bafe964c3526eeff534d70e1e09017	false	0x4d5daadc1bf9aa1c023fe1a9f75545b3863dfd14	365	14741436	2022-05-09T08:37:11.000Z	0xf7ac262a21a393d5b82e33adf93204700a1e77fda37b0ed28937487d6f0ef35c

Example Query

Query with partition filter

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

CurveGearWethPool_TokenExchange_event

Token swap events from the Gearbox V1 Curve-GEAR-WETH liquidity pool on Ethereum. Tracks exchanges between GEAR tokens and WETH with buyer addresses, token amounts, and pool identifiers for analyzing liquidity provision and trading 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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_sold_id`	`STRING`	Index of the token sold in the exchange transaction within the pool’s token array. String-encoded integer identifier.
`in_tokens_sold`	`STRING`	Quantity of tokens sold by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token.
`in_bought_id`	`STRING`	Index of the token purchased in the exchange transaction within the pool’s token array. String-encoded integer identifier.
`in_tokens_bought`	`STRING`	Quantity of tokens received by the buyer in the exchange transaction. String-encoded integer representing the amount in the smallest unit of the token.

Sample Data

address	removed	in_buyer	log_index	in_sold_id	block_number	in_tokens_sold	block_timestamp	in_tokens_bought	transaction_hash
0x0e9b5b092cad6f1c5e6bc7f89ffe1abb5c95f1c2	false	0x0000000000a84d1a9b0063a910315c7ffa9cd248	32	1	16690778	1513740050000000000	2023-02-23T11:23:59.000Z	151661438788147688162434	0xb0abf7546bf0dc8676ea92eb24086af875e0ba45a48166c7910c5310fb6ddfc1
0x0e9b5b092cad6f1c5e6bc7f89ffe1abb5c95f1c2	false	0x0000000000a84d1a9b0063a910315c7ffa9cd248	5	1	16693545	2900195210000000000	2023-02-23T20:43:35.000Z	292303592424577309307041	0xdc2e88779500024919ffaba935a17f9c5b4c24cc3891d344efdb2639e4c649ce
0x0e9b5b092cad6f1c5e6bc7f89ffe1abb5c95f1c2	false	0x0000000000a84d1a9b0063a910315c7ffa9cd248	5	1	16693557	1988896090000000000	2023-02-23T20:46:11.000Z	200503465375110284017955	0xa49a6491f0d90baef47489a7de5574541d1578c70bc42951cdb76e948e8d6a9c

Example Query

Query with partition filter

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

Pool_AddLiquidity_event

Liquidity provision events recording deposits into decentralized exchange (DEX) pools. Contains deposited asset addresses, amounts, liquidity position identifiers, and updated pool liquidity balances for tracking capital inflows and position creation.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of 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.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	28307000697721617867	0x39be637c2d57c3b3f3bb4d732eed83b95aa19f55	536	18209204	0x39be637c2d57c3b3f3bb4d732eed83b95aa19f55	2023-09-25T00:22:59.000Z	0xc1ce75600b983d9634da2bde47ade25302876ea1694f7d6649c754a0686923b8
0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	57016960695686067454	0x6dcdddaae2bb72bdc6e04548d86c19fb819f863b	1262	18209604	0x6dcdddaae2bb72bdc6e04548d86c19fb819f863b	2023-09-25T01:43:35.000Z	0x68ec976062ce3b815fb0d3ca64cd9a6da8815db4d41e92ca1f63ec8e53b35c94
0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	31471950184256160898	0xe50b139167c8eb1a29d686e65a1c11f173cda156	148	18209446	0xe50b139167c8eb1a29d686e65a1c11f173cda156	2023-09-25T01:11:59.000Z	0x363ced3c42fa5aa2f691986c9baeb0a5018b42d8c8684ed18adace17c64d9c83

Example Query

Query with partition filter

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

Pool_Borrow_event

Borrow events emitted when users take loans from lending pools, recording borrower address, borrowed amount, and applicable interest rate. Used for tracking lending protocol utilization and debt 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_creditManager`	`STRING`	Address of the credit manager contract that controls the credit account. Hex-encoded, 0x-prefixed, 42-character string.
`in_creditAccount`	`STRING`	Address of the credit account associated with 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	block_number	block_timestamp	in_creditAccount	in_creditManager	transaction_hash
0x86130bdd69143d8a4e5fc50bf4323d48049e98e4	false	199013154866	365	17018609	2023-04-10T15:14:47.000Z	0x3989960db37ed4c56aae29f950d923b7b70684d0	0x95357303f995e184a7998da6c6ea35cc728a1900	0xe18485c0ca9f2869b8d9be2f05b1c6b5226db3263d8163760f61eb7b50a4eb35
0xb03670c20f87f2169a7c4ebe35746007e9575901	false	175400000000000000000	205	16294237	2022-12-30T01:15:59.000Z	0xe7fcb650ed4265680300c52326bc5057730c5ff0	0x5887ad4cb2352e7f01527035faa3ae0ef2ce2b9b	0x44df42d9b2f980f39109bbede7cab8ca822e62e5b480f47464bfb3b7e30643c9
0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	999228308218207772645437	107	16295828	2022-12-30T06:34:47.000Z	0x489a6804aa6232f61f9bd47de4b810d265ab2251	0x672461bfc20dd783444a830ad4c38b345ab6e2f7	0x4193baad4e3711b1067c182d3275e43b8501336300b4a28836608bb77447a8e5

Example Query

Query with partition filter

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

Pool_RemoveLiquidity_event

Liquidity withdrawal events from decentralized exchange pools recording the removal of assets by liquidity providers. Contains withdrawal amounts, recipient addresses, and pool state changes including updated liquidity balances and token identifiers.

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_sender`	`STRING`	Address that initiated the transaction 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0xbe0affe00de6bbdb717d2c7af7f9feb45311320d	0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	15630000000000000000000	0xbe0affe00de6bbdb717d2c7af7f9feb45311320d	295	16520263	2023-01-30T14:33:23.000Z	0xa463759c76d5e60a6f63744dae1883e97a064730f2cbcc2a4c77e2057a946333
0x64163b7f5558c54c2494fe18e09ba8ee2ec7bc8a	0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	99632632461500843691347	0x64163b7f5558c54c2494fe18e09ba8ee2ec7bc8a	366	16520441	2023-01-30T15:09:23.000Z	0x2614acf012b1f5cdf864b72d6039b85a6ff2b7ca7a55aca9c945796816e4811b
0xac03363f1dfd8087f8ee7775a703ace890a06d7f	0x24946bcbbd028d5abb62ad9b635eb1b1a67af668	false	33693601130327569256871	0xac03363f1dfd8087f8ee7775a703ace890a06d7f	534	16521848	2023-01-30T19:51:47.000Z	0x545157df0cea336342004a9cc29e9e842a289dfdc89bb9dca618060b1cf2f283

Example Query

Query with partition filter

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

Pool_Repay_event

Loan repayment events from Gearbox V1 credit accounts on Ethereum, recording borrowed amounts repaid and resulting profit or loss to the lending pool. Tracks credit manager addresses and pool-level P&L for analyzing protocol performance and leverage usage.

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_creditManager`	`STRING`	Address of the credit manager contract that controls the credit account. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowedAmount`	`STRING`	Principal amount borrowed that is being repaid in this transaction, denominated in the pool’s base token with full precision. Values are string-encoded integers representing the smallest token unit.
`in_profit`	`STRING`	Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.
`in_loss`	`STRING`	Loss amount incurred by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.

Sample Data

address	removed	in_profit	log_index	block_number	block_timestamp	in_creditManager	transaction_hash	in_borrowedAmount
0x86130bdd69143d8a4e5fc50bf4323d48049e98e4	false	2649309479	195	17426820	2023-06-07T06:47:47.000Z	0x95357303f995e184a7998da6c6ea35cc728a1900	0x0a8c0b67be351399e04542c55faa64009790b52cb04f6fcaf34ad66eee0ac316	999353671351
0x86130bdd69143d8a4e5fc50bf4323d48049e98e4	false	225767329	76	17790850	2023-07-28T10:05:59.000Z	0x95357303f995e184a7998da6c6ea35cc728a1900	0x8b4bd538259981198398e6404e06e951b3bd8221d33a781ae67f4c9fdcbc95a4	300000000000
0x86130bdd69143d8a4e5fc50bf4323d48049e98e4	false	2150293	332	15804929	2022-10-22T16:46:11.000Z	0x2664cc24cbad28749b3dd6fc97a6b402484de527	0xbfd7fddbeb193d0d713cea31f87297b47af046be75f3a5cdd07b358e971f3114	6000000000

Example Query

Query with partition filter

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

TokenDistributor_NewVestingContract_event

Vesting contract creation events from Gearbox V1 protocol’s TokenDistributor on Ethereum, linking token holders to their vesting contract addresses. Used for tracking token distribution schedules and analyzing vesting participant allocations.

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_holder`	`STRING`	Ethereum address of the token holder for whom the vesting contract was created. This is the beneficiary who will receive tokens according to the vesting schedule.
`in_vestingContract`	`STRING`	Contract address of the newly created vesting contract for the token holder. Hex-encoded, 0x-prefixed 40-character Ethereum address unique to each holder in the distribution event.
`in_votingPower`	`INT64`	Voting power allocated to the token holder in the vesting contract at the time of creation. All sample values are 0, indicating voting power may be granted later in the vesting schedule.

Sample Data

address	removed	in_holder	log_index	block_number	block_timestamp	transaction_hash	in_vestingContract
0xbf57539473913685688d224ad4e262684b23dd4c	false	0x512de6920f4d78401ec759a4ba6a81cceaf2a486	153	13811178	2021-12-15T17:51:13.000Z	0x6b1ca4a9f7ca8689955ab3a16258fda068eb4c162bc3e0454a638f2107f2733c	0x01756dcf8248f5e5c5a6e8e2bdfe47439008e231
0xbf57539473913685688d224ad4e262684b23dd4c	false	0xc524ed0fd1af56ce04becfa8ffbc73ffc085be3a	163	13811178	2021-12-15T17:51:13.000Z	0x6b1ca4a9f7ca8689955ab3a16258fda068eb4c162bc3e0454a638f2107f2733c	0x151a79fb8ba57b04613d955cb48d59879c552268
0xbf57539473913685688d224ad4e262684b23dd4c	false	0x4d108e41b380aecd04693690996192beee29174c	133	13811178	2021-12-15T17:51:13.000Z	0x6b1ca4a9f7ca8689955ab3a16258fda068eb4c162bc3e0454a638f2107f2733c	0xdf63f75cac46e0d7ec18ebcd35e1dfe15318fa26

Example Query

Query with partition filter

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

TokenDistributorV2_VestingContractAdded_event

Event logs tracking vesting contract registrations in Gearbox V1 token distribution system on Ethereum. Records holder addresses, vesting amounts, contract addresses, and voting power categories for governance token allocation 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_holder`	`STRING`	Ethereum address of the token recipient who will receive vested tokens through the associated vesting contract. Always appears as a hex-encoded, 0x-prefixed 40-character string.
`in_vestingContract`	`STRING`	Contract address of the vesting schedule created for the token holder. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the deployed vesting contract instance.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_votingPowerCategory`	`STRING`	Category classifying the voting power tier of the vesting contract holder. Common values include TYPE_ONE, with other tiers potentially used to differentiate governance weight in the Gearbox protocol.

Sample Data

address	removed	in_amount	in_holder	log_index	block_number	block_timestamp	transaction_hash	in_vestingContract	in_votingPowerCategory
0xf7512b2b20cf427add8b01d8cdeef97a4b0e2c27	false	1111111000000000000000000	0xe27b57a99e5cac0e0f16ee0d5d768126b05422a8	373	18047555	2023-09-02T08:10:47.000Z	0xc9dfca10342d2cd2ee57f12e7d05a422db2c9dc34668af21a7c3cddf6ed98616	0xc287d91e1ca0e10a5bd47e900f71d6a5ca75e3e5	TYPE_ONE
0xf7512b2b20cf427add8b01d8cdeef97a4b0e2c27	false	30000000000000000000000	0x32945e04d34fdc2431aa3370e82393a6141769fe	158	16988516	2023-04-06T08:46:59.000Z	0x076625ba475cdfee19da6f52de7af914a76c2deb10bae51a53913b7819383d24	0xb4c69c8c5dc1a51064bff83edb47ea17b481554d	TYPE_ONE
0xf7512b2b20cf427add8b01d8cdeef97a4b0e2c27	false	33333000000000000000000	0xc9396c19c5ce1cb80be5a2c7f52d1cef88ac866e	55	16988482	2023-04-06T08:39:47.000Z	0xc5e094082d724456d6b8211fddeec153dfec4d4d5e5113968e8a6ac03798cfa4	0x22f5d645c4a24dad2501b7ed84de6d54e23d7cc1	TYPE_ONE

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CreditManager_CloseCreditAccount_event

CreditManager_LiquidateCreditAccount_event

CreditManager_OpenCreditAccount_event

CreditManager_RepayCreditAccount_event

CurveGearWethPool_TokenExchange_event

Pool_AddLiquidity_event

Pool_Borrow_event

Pool_RemoveLiquidity_event

Pool_Repay_event

TokenDistributor_NewVestingContract_event

TokenDistributorV2_VestingContractAdded_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CreditManager_CloseCreditAccount_event

​CreditManager_LiquidateCreditAccount_event

​CreditManager_OpenCreditAccount_event

​CreditManager_RepayCreditAccount_event

​CurveGearWethPool_TokenExchange_event

​Pool_AddLiquidity_event

​Pool_Borrow_event

​Pool_RemoveLiquidity_event

​Pool_Repay_event

​TokenDistributor_NewVestingContract_event

​TokenDistributorV2_VestingContractAdded_event

Tables

CreditManager_CloseCreditAccount_event

CreditManager_LiquidateCreditAccount_event

CreditManager_OpenCreditAccount_event

CreditManager_RepayCreditAccount_event

CurveGearWethPool_TokenExchange_event

Pool_AddLiquidity_event

Pool_Borrow_event

Pool_RemoveLiquidity_event

Pool_Repay_event

TokenDistributor_NewVestingContract_event

TokenDistributorV2_VestingContractAdded_event