gearbox_v3_ethereum

Tables

CreditFacadeV3_OpenCreditAccount_event

Credit account opening events from Gearbox V3 protocol on Ethereum, capturing when users open leveraged positions with account addresses, callers, and optional referral codes. Used for tracking protocol onboarding activity and referral program 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_creditAccount`	`STRING`	Address of the credit account associated with the 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`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_caller	log_index	block_number	in_onBehalfOf	block_timestamp	in_creditAccount	transaction_hash
0x5366b8c2de34f614556d085961b3699aa1755af4	false	0x9156f526ca04516b2bded49525a1325e03028c82	22	18956024	0x9156f526ca04516b2bded49525a1325e03028c82	2024-01-07T15:15:23.000Z	0x40622563ebbcb50a31118844e6c68bf7be53ae38	0x16bc1e80bb3572a25240d1c91605c45b7fba53aacf5df77487796bdcd8f3a867
0x5366b8c2de34f614556d085961b3699aa1755af4	false	0xa7888f85bd76deef3bd03d4dbcf57765a49883b3	176	18891723	0xa7888f85bd76deef3bd03d4dbcf57765a49883b3	2023-12-29T14:05:59.000Z	0x0f2aa94ef894c703573b2f1de808cba24e2e28b4	0x4cd70078b245fee1c64516cb56d119c3e3710de9523c82ce1293b070daf29da0
0x5366b8c2de34f614556d085961b3699aa1755af4	false	0xf532a30a48bc18b4074c6930f335e5db107ce555	7	18970223	0xf532a30a48bc18b4074c6930f335e5db107ce555	2024-01-09T15:12:47.000Z	0x0eb0eddda638a4e7a8c698e147bff720208a3ae4	0x52379b955557c0f3c0fd3fe69e99e409e894689945acef59af08e3c27188a3b6

Example Query

Query with partition filter

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

PoolV3_Borrow_event

Borrow events from Gearbox Protocol V3 lending pools on Ethereum, capturing when credit accounts take leveraged positions by borrowing assets from the pool. Used for analyzing borrowing activity, credit utilization, and leverage trends across 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_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
0xda00000035fef4082f78def6a8903bee419fbf8e	false	360908753328	17	19063251	2024-01-22T15:47:35.000Z	0x2e65fe048fb51b5429e15cf7a110b50294d03f9f	0x3eb95430fdb99439a86d3c6d7d01c3c561393556	0xdb41b42604fd4d6975d8794c785ba279eeb9ddf9e398d826cac47650b0dea327
0xda00000035fef4082f78def6a8903bee419fbf8e	false	105434200654	60	18970384	2024-01-09T15:45:35.000Z	0x929bd491f0861697c465d81845ae8cab0753741a	0x3eb95430fdb99439a86d3c6d7d01c3c561393556	0xd0b7662c25da1edb690f53a57592dde5b6c6580a8f7e1918321d0fc1963c2342
0xda00000035fef4082f78def6a8903bee419fbf8e	false	22504232934	69	18972538	2024-01-09T22:59:59.000Z	0x420d841e5276b53e78178ebd1a027c60a034efa5	0x3eb95430fdb99439a86d3c6d7d01c3c561393556	0x36390ea6f9579ab370a31a545e124f265d940e7acc85f7cbda57b9c8be17221a

Example Query

Query with partition filter

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

PoolV3_redeem_function

Redemption transactions from Gearbox V3 lending pools on Ethereum, recording conversions of pool shares to underlying assets. Contains share amounts, asset outputs, owner addresses, and receivers for analyzing liquidity withdrawal patterns and pool utilization.

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_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`out_assets`	`STRING`	Amount of underlying assets returned from redeeming shares. String-encoded integer representing token quantity in the token’s smallest unit.

Sample Data

gas	status	gas_used	in_owner	in_shares	signature	out_assets	to_address	in_receiver	block_number	from_address	trace_address	block_timestamp	transaction_hash
96242	true	91540	0x53d5bd0e7faa9ee3eafef7c5572d54db1b7f5b25	11651080254	0xba087652	12435191878	0xda00000035fef4082f78def6a8903bee419fbf8e	0x1259971f8b7b5c7f86a21bcd89a13b0c9da90466	20212512	0x53d5bd0e7faa9ee3eafef7c5572d54db1b7f5b25	2	2024-07-01T15:18:11.000Z	0x4449d8b9704ee48b3159617da4dba3b8e94e70af9a054a9ead7c3fe4ce3339dd
96242	true	91540	0x53d5bd0e7faa9ee3eafef7c5572d54db1b7f5b25	65006318663	0xba087652	69381636406	0xda00000035fef4082f78def6a8903bee419fbf8e	0xfc428c8887bd0f49d636fc7cc599ffe21a1fb2b6	20212712	0x53d5bd0e7faa9ee3eafef7c5572d54db1b7f5b25	2	2024-07-01T15:58:11.000Z	0x5260719fcf0daebe855eefcec29df56cc1b9060360dad013e3c48500b628e517
114296	true	75545	0xd92b65d2321076fbac23fcfc9a9fd5ed2e98b758	1075281140235436561	0xba087652	1130184758430782372	0xda0002859b2d05f66a753d8241fcde8623f26f4f	0xd92b65d2321076fbac23fcfc9a9fd5ed2e98b758	20213170	0xd92b65d2321076fbac23fcfc9a9fd5ed2e98b758	0,4,0,5,0,1,0,5	2024-07-01T17:30:11.000Z	0xa5d7d9f5ab92c547f009e2183bad9386688bc31de8f06acb120c704f61a764cf

Example Query

Query with partition filter

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

PoolV3_Repay_event

Loan repayment events from Gearbox v3 credit accounts on Ethereum, capturing borrowed amounts, profit/loss on position closure, and associated credit manager addresses. Used for analyzing leverage trading performance and protocol utilization across different Gearbox 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_creditManager`	`STRING`	Address of the credit manager contract that controls the credit account. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowedAmount`	`STRING`	Amount of borrowed tokens being repaid to the Gearbox V3 pool, denominated in the pool’s base token with decimals included. Values represent raw token amounts that require decimal adjustment for human-readable interpretation.
`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
0xda00000035fef4082f78def6a8903bee419fbf8e	false	2835972	253	18828230	2023-12-20T16:11:59.000Z	0x3eb95430fdb99439a86d3c6d7d01c3c561393556	0xc0044e10bb7b073f16824a35cffcdc6c34e67a8a4c101ceea1a4be1972d76f10	20226292782
0xda00000035fef4082f78def6a8903bee419fbf8e	false	14681058	154	18826426	2023-12-20T10:08:11.000Z	0x3eb95430fdb99439a86d3c6d7d01c3c561393556	0x4f2381ea6eeeb9fe3a8ea5e99cfc26122a608566fe9855da61a3510a6bc62d42	120000000000
0xda00000035fef4082f78def6a8903bee419fbf8e	false	0	107	18929669	2024-01-03T22:02:23.000Z	0x3eb95430fdb99439a86d3c6d7d01c3c561393556	0xe1953a9c44003f53afd0fcb3615a2573d0551e021f2eabe284daad30e990c737	0

Example Query

Query with partition filter

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

PoolV3_Transfer_event

ERC-20 transfer events for Gearbox V3 liquidity pool shares on Ethereum, tracking mints, burns, and transfers between accounts. Used for analyzing pool liquidity provider positions and share movements.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x3e965117a51186e41c2bb58b729a1e518a715e5f	0xda00000035fef4082f78def6a8903bee419fbf8e	0x0000000000000000000000000000000000000000	false	46611681	156	18938989	2024-01-05T05:26:23.000Z	0x91642287c923455175e020869908b7f8bff4eb326772ae81b55d4a25f482b560
0x0000000000000000000000000000000000000000	0xda00000035fef4082f78def6a8903bee419fbf8e	0x53d5bd0e7faa9ee3eafef7c5572d54db1b7f5b25	false	2009768658	136	18942268	2024-01-05T16:30:59.000Z	0x909a143c8083aaf402623d999ecfa2fc83fa2ee76bb3c0bf4f4daf177eca28ca
0x53d5bd0e7faa9ee3eafef7c5572d54db1b7f5b25	0xda00000035fef4082f78def6a8903bee419fbf8e	0x9ef444a6d7f4a5adcd68fd5329aa5240c90e14d2	false	2009768658	135	18942268	2024-01-05T16:30:59.000Z	0x909a143c8083aaf402623d999ecfa2fc83fa2ee76bb3c0bf4f4daf177eca28ca

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

CreditFacadeV3_OpenCreditAccount_event

PoolV3_Borrow_event

PoolV3_redeem_function

PoolV3_Repay_event

PoolV3_Transfer_event

​Tables

​CreditFacadeV3_OpenCreditAccount_event

​PoolV3_Borrow_event

​PoolV3_redeem_function

​PoolV3_Repay_event

​PoolV3_Transfer_event

Tables

CreditFacadeV3_OpenCreditAccount_event

PoolV3_Borrow_event

PoolV3_redeem_function

PoolV3_Repay_event

PoolV3_Transfer_event