gearbox_v2_ethereum

Tables

CreditConfigurator_FeesUpdated_event

Fee parameter update events from Gearbox V2 credit configurators on Ethereum. Tracks changes to interest rates, liquidation fees, and liquidation premiums for analyzing protocol fee structure adjustments across credit accounts.

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_feeInterest`	`STRING`	Interest fee rate charged on borrowed funds in basis points (10000 = 100%). Sample values show 5000, representing a 50% annual interest rate on credit account positions.
`in_feeLiquidation`	`STRING`	Annual percentage rate (APR) charged as interest on borrowed positions in basis points (e.g., ‘5000’ = 50%). This fee accrues continuously on outstanding credit account debt.
`in_liquidationPremium`	`STRING`	Liquidation premium percentage applied when credit accounts are liquidated, expressed in basis points (100 = 1%). This represents the discount or bonus paid to liquidators for closing undercollateralized positions.
`in_feeLiquidationExpired`	`STRING`	Liquidation fee percentage charged when a Gearbox credit account expires, expressed in basis points (100 = 1%). This fee is typically lower than the standard liquidation fee to incentivize timely position management.
`in_liquidationPremiumExpired`	`STRING`	Liquidation premium percentage (in basis points) applied when liquidating an expired Gearbox credit account. Value of 200 represents 2.00% premium paid to liquidators above the debt amount.

Sample Data

address	removed	log_index	block_number	in_feeInterest	block_timestamp	transaction_hash	in_feeLiquidation	in_liquidationPremium	in_feeLiquidationExpired	in_liquidationPremiumExpired
0x140a896808bbc8c7187a67f1751d796705cd7798	false	255	15833466	5000	2022-10-26T16:32:59.000Z	0xadabf893b2e518d808651f9a4fe9e652a96fb449ec1f43b7ac7ce3cac85b8104	150	400	100	200
0xeb0ed1ee3062735cc73661888ed87aa407501674	false	63	15833599	5000	2022-10-26T16:59:35.000Z	0x6e55ab10427ec2a5f5c19e56db92476321cdf49d0073c77a5718e19e5d4428da	150	400	100	200
0xb1558a128a5a3116de88c8457334f2464785b02a	false	73	15840211	5000	2022-10-27T15:09:35.000Z	0x819c5c6cb8791b2bd1d7c6db6609c768da87b5f5282b6eb021c1f13a1c257d62	150	400	100	200

Example Query

Query with partition filter

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

CreditFacade_CloseCreditAccount_event

Credit account closure events from Gearbox v2 lending protocol on Ethereum, recording when leveraged positions are closed with borrower and recipient addresses. Used for tracking account lifecycle and liquidation 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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. 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	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0x16f6965651143a140f1f5f213e378bc4683cef9b	0xc59135f449bb623501145443c70a30ee648fa304	false	83	0x16f6965651143a140f1f5f213e378bc4683cef9b	16819476	2023-03-13T13:50:47.000Z	0x8f52ef7b638cb00d0019ff380d481ebb05b5e4246c2ce6392e9b92c129780397
0x0f101ccdd4673316933339c8fba5fc3b262cf4cb	0xc59135f449bb623501145443c70a30ee648fa304	false	319	0x0f101ccdd4673316933339c8fba5fc3b262cf4cb	16820004	2023-03-13T15:37:35.000Z	0x4df86e74bbe02b5159e74640ad17a3a3a7bd2d680c82427ea66c8b1772706d07
0x43faf3f8bef053d901c572edc32f055c20efb764	0xc59135f449bb623501145443c70a30ee648fa304	false	279	0x43faf3f8bef053d901c572edc32f055c20efb764	16820213	2023-03-13T16:19:59.000Z	0xa65c89dd27e6e1bfc53ead1f6774e7798b3ec0fd2aa6a7deda5cdb3f891d8340

Example Query

Query with partition filter

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

CreditFacade_LiquidateCreditAccount_event

Liquidation events from Gearbox v2 credit accounts on Ethereum, capturing borrower addresses, liquidator addresses, and remaining funds after liquidation. Used to analyze credit account defaults, liquidator behavior, and protocol health metrics.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_remainingFunds`	`STRING`	Amount of funds remaining in the liquidated credit account after liquidation, denominated in the smallest unit of the underlying asset. Large integer values indicate wei-denominated amounts for ETH or 18-decimal tokens.

Sample Data

in_to	address	removed	log_index	in_borrower	block_number	in_liquidator	block_timestamp	transaction_hash	in_remainingFunds
0x6c63a4df7551472145c6bb35bbe91d291129cd45	0xf6f4f24ae50206a07b8b32629aeb6cb1837d854f	false	55	0xc3be098f9594e57a3e71f485a53d990fe3961fe5	16302868	0x6c63a4df7551472145c6bb35bbe91d291129cd45	2022-12-31T06:11:11.000Z	0x9cb8b15989b485093a8f573dfb8c85dd7d4b3e3b5e3b4e66e8f078fdae10eaef	48783013455206530565548
0xd050e0a4838d74769228b49dff97241b4ef3805d	0x61fbb350e39cc7bf22c01a469cf03085774184aa	false	63	0xc3be098f9594e57a3e71f485a53d990fe3961fe5	16302869	0xd050e0a4838d74769228b49dff97241b4ef3805d	2022-12-31T06:11:23.000Z	0x6bab72bff9bd43f7807810dab6865658c55906b28dbd2685482696222573b1a7	49070178608
0x6c6b87d44d239b3750bf9badce26a9a0a3d2364e	0xc59135f449bb623501145443c70a30ee648fa304	false	21	0x39c78ce4fbd59722f48a3271fe11f9ac5f933ba0	15884037	0x6c6b87d44d239b3750bf9badce26a9a0a3d2364e	2022-11-02T18:10:35.000Z	0xa6705997b63e0d87376cd5fe5c49b4f5bf4ecfdf3b6052fcfb50812bb107434d	11081476085457680684

Example Query

Query with partition filter

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

CreditFacade_OpenCreditAccount_event

Credit account opening events from Gearbox V2 protocol on Ethereum, recording leverage account creation with borrowed amounts, beneficiary addresses, and credit account identifiers. Used for tracking leveraged position openings and protocol growth metrics.

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_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_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	log_index	block_number	in_onBehalfOf	block_timestamp	in_borrowAmount	in_creditAccount	transaction_hash
0xf6f4f24ae50206a07b8b32629aeb6cb1837d854f	false	139	16181108	0xc3be098f9594e57a3e71f485a53d990fe3961fe5	2022-12-14T06:19:59.000Z	855000000000000000000000	0xdb978c8b50d0ffc306d54c91587192aec3c00337	0x8e8d4d906cce79a6dc8d97d8aa930b9d526ece62d7edec93fdc3a35dae779290
0x61fbb350e39cc7bf22c01a469cf03085774184aa	false	131	16181806	0x478cafc1bf482ba4b4bfff2500cbdf3a9423ea61	2022-12-14T08:41:11.000Z	221080368720	0x04dc3f436613ab01332ec22d474bbf673245d64c	0x18c9cfdfcfbeaec8acbcb8d741d6f05327781994fafa3223b2c8b61fe99ff424
0x61fbb350e39cc7bf22c01a469cf03085774184aa	false	34	16182950	0xb0399dac8f4d4100b49b2a7b3873481114229d18	2022-12-14T12:31:35.000Z	148980000000	0xb1ae6d9e6dde5af397ec22229cba7edab6cbdbf0	0xaebbe2972728c5b0d5eca67b2451f531edf38913ff06f2ad086226b271be88b2

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CreditConfigurator_FeesUpdated_event

CreditFacade_CloseCreditAccount_event

CreditFacade_LiquidateCreditAccount_event

CreditFacade_OpenCreditAccount_event

​Tables

​CreditConfigurator_FeesUpdated_event

​CreditFacade_CloseCreditAccount_event

​CreditFacade_LiquidateCreditAccount_event

​CreditFacade_OpenCreditAccount_event

Tables

CreditConfigurator_FeesUpdated_event

CreditFacade_CloseCreditAccount_event

CreditFacade_LiquidateCreditAccount_event

CreditFacade_OpenCreditAccount_event