fraxlend_v1_ethereum

Tables

FraxlendPairDeployer_LogDeploy_event

Deployment events from Fraxlend V1 protocol on Ethereum recording creation of new lending pair contracts with their collateral asset, borrowable asset (FRAX), and deployed pair address. Used for tracking protocol expansion and identifying active lending markets.

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__address`	`STRING`	Address of the account or contract involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__asset`	`STRING`	Contract address of the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__collateral`	`STRING`	Contract address of the collateral token used in the deployed Fraxlend pair. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token that borrowers must provide as collateral (e.g., staked Frax Ether).
`in__name`	`STRING`	Human-readable name for the pool, token, or asset being created. String identifier used for display and reference purposes.

Sample Data

address	removed	in__name	in__asset	log_index	in__address	block_number	in__collateral	block_timestamp	transaction_hash
0xaa913c26dd7723fcae9dbd2036d28171a56c6251	false	Fraxlend Interest Bearing FRAX (Staked Frax Ether) - 16	0x853d955acef822db058eb8505911ed77f175b99e	194	0x78bb3aec3d855431bd9289fd98da13f9ebb7ef15	16600181	0xac3e018457b222d93114458476f3e3416abbe38f	2023-02-10T18:35:23.000Z	0xe761076b1fdd88ac8db3cbe5a0a3b7a39c43d5e54a8138f12e44a6c85ece51c9
0xaa913c26dd7723fcae9dbd2036d28171a56c6251	false	Fraxlend Interest Bearing FRAX (Staked Frax Ether) - 13	0x853d955acef822db058eb8505911ed77f175b99e	498	0x9234ea70c2360576c3c9e706e7f3f3219e6d885c	16485554	0xac3e018457b222d93114458476f3e3416abbe38f	2023-01-25T18:14:23.000Z	0xeb2994eb592f27666a90a72e80fc7e5cedb82f9d62ff063e578a317d941f5d17
0xaa913c26dd7723fcae9dbd2036d28171a56c6251	false	Fraxlend Interest Bearing FRAX (Staked Frax Ether) - 14	0x853d955acef822db058eb8505911ed77f175b99e	166	0xa96eb85d1afb297bb67eb4856ad5a469ec921d00	16523892	0xac3e018457b222d93114458476f3e3416abbe38f	2023-01-31T02:42:23.000Z	0xf7d5f6021c2c6f1b560152e8e70a9f763adfb29384deabc2c7817438362da5be

Example Query

Query with partition filter

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

Pair_AddCollateral_event

Collateral deposit events from Fraxlend V1 lending pairs on Ethereum, recording when borrowers add collateral to their positions. Used for tracking collateralization ratio changes and user position management 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_sender`	`STRING`	Address that initiated 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_collateralAmount`	`STRING`	Amount of collateral tokens involved in the operation. Decimal-encoded string representing the quantity in the token’s base units.

Sample Data

address	removed	in_sender	log_index	in_borrower	block_number	block_timestamp	transaction_hash	in_collateralAmount
0x32467a5fc2d72d21e8dce990906547a2b012f382	false	0xbc2f0ebc412647c7d4ec8ffd88ca84bc5b32c8cc	349	0xbc2f0ebc412647c7d4ec8ffd88ca84bc5b32c8cc	17983929	2023-08-24T10:20:47.000Z	0x8ccc8584e80c4c77e73b145e48048d618ad2fdbd292d6b42eaba2e099b1f1efe	407468539
0x66bf36dba79d4606039f04b32946a260bcd3ff52	false	0x3aa8ac0e6c1fb9cbb733565de16cdc5a676bcb04	287	0x3aa8ac0e6c1fb9cbb733565de16cdc5a676bcb04	17981772	2023-08-24T03:06:11.000Z	0x457b4654a334afcb130c11a51db76f9a00529a393c0a0eb7a02cd207f7abbe11	1211580543323300306
0x66bf36dba79d4606039f04b32946a260bcd3ff52	false	0xc7f8769a99194a2be7ac382f3ba4ef6ac7cc31c6	252	0xc7f8769a99194a2be7ac382f3ba4ef6ac7cc31c6	17981177	2023-08-24T01:06:23.000Z	0xbcda3f5592e49a494dc0ebec2441c669cb3b13523030ab6782657a57b1058cac	9720000000000000

Example Query

Query with partition filter

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

Pair_BorrowAsset_event

Borrow transaction events from Fraxlend V1 lending pairs on Ethereum, recording when users take out loans with borrower address, amount borrowed, and debt shares issued. Used for analyzing borrowing activity, leverage patterns, and individual borrower behavior across Fraxlend lending markets.

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 account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__receiver`	`STRING`	Address of the account receiving the tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrowAmount`	`STRING`	Amount of the asset borrowed in this transaction, denominated in the smallest unit of the borrow token (wei for 18-decimal tokens). Values typically range from zero (for certain transaction types) to billions of wei representing thousands of tokens.
`in__sharesAdded`	`STRING`	Number of borrow shares minted and added to the borrower’s position in the Fraxlend pair contract. Denominated in the pair’s internal share units, which represent a claim on the borrowed asset amount adjusted for interest accrual.

Sample Data

address	removed	log_index	block_number	in__borrower	in__receiver	block_timestamp	in__sharesAdded	in__borrowAmount	transaction_hash
0x281e6cb341a552e4faccc6b4eef1a6fcc523682d	false	259	17608659	0x71293f67da2c0a4e7cd5a62066bd6e6679628ca7	0x71293f67da2c0a4e7cd5a62066bd6e6679628ca7	2023-07-02T20:20:11.000Z	4997075994460051634289	5000000000000000000000	0x88ca9c37ecbaedd358e63e6c8d6c55dd8ebc7fc111e012778d33f421fd9bd8b4
0x32467a5fc2d72d21e8dce990906547a2b012f382	false	262	17603282	0xcfcca7aea9e403744858c53e13adf8975db9038b	0xcfcca7aea9e403744858c53e13adf8975db9038b	2023-07-02T02:13:23.000Z	29850088199871128317990	30000000000000000000000	0xaaf633660afb0902b34bde7f036fc8cfa803e935a6913272584e71901593e32d
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	51	17605650	0xcba1a275e2d858ecffaf7a87f606f74b719a8a93	0xcba1a275e2d858ecffaf7a87f606f74b719a8a93	2023-07-02T10:11:59.000Z	1840373097261586559523	2000000000000000000000	0x94faa89b83c51e7e0fd90534a39532ca6452edabbb64d0350820be1434850e63

Example Query

Query with partition filter

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

Pair_RemoveCollateral_event

Collateral withdrawal events from Fraxlend V1 lending pairs on Ethereum, recording when borrowers remove collateral from their positions. Useful for tracking collateral management activity and analyzing position health changes across lending pairs.

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 of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.
`in__collateralAmount`	`STRING`	Amount of collateral tokens withdrawn from the Fraxlend pair, denominated in the smallest unit of the collateral token (wei-equivalent). Values are stored as strings to preserve precision for large token amounts.
`in__receiver`	`STRING`	Address of the account receiving the tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in__sender	block_number	in__borrower	in__receiver	block_timestamp	transaction_hash	in__collateralAmount
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	479	0xba056c82ef963a376648e3ad5123932a071fcd98	17138022	0xba056c82ef963a376648e3ad5123932a071fcd98	0xba056c82ef963a376648e3ad5123932a071fcd98	2023-04-27T14:11:11.000Z	0x85b32bab79f5ea159408a382d639a264c6e0767ecb40134f999b222d18bc9bbc	5000000000000000000000
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	389	0x4f3ef736eaee5baa2fef2579752e0714561ad483	17137858	0x4f3ef736eaee5baa2fef2579752e0714561ad483	0x4f3ef736eaee5baa2fef2579752e0714561ad483	2023-04-27T13:38:11.000Z	0x04423e574d1a42b8bdebf162c28c34ab71395926f385a74ab136ba38708aeb3a	5223840000000000000000
0x74f82bd9d0390a4180daaec92d64cf0708751759	false	58	0x4c42522b28ae01b2153f51d85a8ee7631d243ef5	17139989	0x4c42522b28ae01b2153f51d85a8ee7631d243ef5	0x4c42522b28ae01b2153f51d85a8ee7631d243ef5	2023-04-27T20:49:11.000Z	0x730dc12a2a4a24aa7b16cab7f246f132423721030af46fd8c8c3b0fd2da65ce4	200000000000000000000000

Example Query

Query with partition filter

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

Pair_RepayAsset_event

Loan repayment events from Fraxlend V1 lending pairs on Ethereum, capturing borrower repayments with amounts in both asset units and share tokens. Used for analyzing debt reduction activity, repayment patterns, and calculating outstanding loan balances across lending pairs.

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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. 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_amountToRepay`	`STRING`	Amount of the borrowed asset being repaid, denominated in the smallest unit of the asset (e.g., wei for ETH). Values are stored as strings to preserve precision for large integers exceeding standard numeric limits.
`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.

Sample Data

address	removed	in_payer	in_shares	log_index	in_borrower	block_number	block_timestamp	in_amountToRepay	transaction_hash
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	0x7d3368e90a4e5ad8e46d5fe91f82319f1db639f4	1358805932728856859425	375	0x7d3368e90a4e5ad8e46d5fe91f82319f1db639f4	17242357	2023-05-12T06:28:47.000Z	1451404279264026180564	0xed44744ca87991853f71975a84992eea6f0442fd9a4d216f06fa0193575476b2
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	0x7d3368e90a4e5ad8e46d5fe91f82319f1db639f4	93691573065128872186274	365	0x7d3368e90a4e5ad8e46d5fe91f82319f1db639f4	17242332	2023-05-12T06:22:47.000Z	100076242890229123175009	0x125ed4c6d57d30abff071aad545cd184446cfe231ee6af7a0d20b5df1c9c4fb9
0x66bf36dba79d4606039f04b32946a260bcd3ff52	false	0x440c8ab91ba7c8763b3d9b3357dc1c0d13a148aa	1924003910528666135892	225	0x440c8ab91ba7c8763b3d9b3357dc1c0d13a148aa	17245549	2023-05-12T17:15:23.000Z	2003690444268016079491	0xeacf6bccd94e401cde9e7e65c2616fdce7a0d6ac1e72a489c25f023760232cf5

Example Query

Query with partition filter

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

Pair_Withdraw_event

Withdrawal events from Fraxlend V1 lending pairs on Ethereum, recording when users redeem their deposit shares for underlying assets. Tracks share-to-asset conversions with caller, owner, and receiver addresses for analyzing liquidity withdrawals and redemption 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`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.

Sample Data

address	removed	in_owner	in_assets	in_caller	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	0xdbe19d1c3f21b1bb250ca7bdae0687a97b5f77e6	101070808989124565089065	0xdbe19d1c3f21b1bb250ca7bdae0687a97b5f77e6	94292622158319684299644	74	0xef585cf8cacb909edaa23e8e8d596b338cb72403	17884255	2023-08-10T11:42:23.000Z	0x12d62f6b7afa710e90a55098f02169c4fc3e99df6ba599b4ddbd6cf40b61a78f
0x3835a58ca93cdb5f912519ad366826ac9a752510	false	0xdbe19d1c3f21b1bb250ca7bdae0687a97b5f77e6	5725659515992227	0xdbe19d1c3f21b1bb250ca7bdae0687a97b5f77e6	5341681334047893	102	0xef585cf8cacb909edaa23e8e8d596b338cb72403	17884176	2023-08-10T11:26:11.000Z	0x63aace1dd425425359360f1a398e70a2f7c8d778eaf67739610abf6425560ac1
0x794f6b13fbd7eb7ef10d1ed205c9a416910207ff	false	0x17359937bc169a348aaea90871765aca4071c8d3	25000000028606704931	0x17359937bc169a348aaea90871765aca4071c8d3	24999994249587086539	334	0x17359937bc169a348aaea90871765aca4071c8d3	15484592	2022-09-06T14:21:05.000Z	0x5cf914b9c363bd1e08ce5e280a5b497201d4054cb3d677f5333d8627007751a1

Example Query

Query with partition filter

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

PairRegistry_AddPair_event

Event logs capturing new lending pair registrations in Fraxlend V1 protocol on Ethereum. Records when new lending markets are added to the protocol registry, enabling tracking of market expansion and available lending pair 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__pairAddress`	`STRING`	Contract address of the Fraxlend lending pair registered in the PairRegistry. Hex-encoded, 0x-prefixed 40-character Ethereum address representing a unique lending market instance.

Sample Data

address	removed	log_index	block_number	block_timestamp	in__pairAddress	transaction_hash
0xd6e9d27c75afd88ad24cd5edccdc76fd2fc3a751	false	195	16108100	2022-12-04T01:15:11.000Z	0x74f82bd9d0390a4180daaec92d64cf0708751759	0x25a080566d55e503daf936c82338db0151f26f19a40dbc03f716fe7a7321ad70
0xd6e9d27c75afd88ad24cd5edccdc76fd2fc3a751	false	125	16780540	2023-03-08T02:21:23.000Z	0x3a25b9ab8c07ffefee614531c75905e810d8a239	0x061800a4193a788b91dc530cc8672108e3720665f5dc1ff12a7467d135f4cb20
0xd6e9d27c75afd88ad24cd5edccdc76fd2fc3a751	false	309	17274038	2023-05-16T18:29:23.000Z	0x1fff4a418471a7b44efa023320e02dcdb486ed77	0x93778ffd9c6a9ab873718a754a1b562e2aa2c3b8dd7f38941442a25471898d25

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

FraxlendPairDeployer_LogDeploy_event

Pair_AddCollateral_event

Pair_BorrowAsset_event

Pair_RemoveCollateral_event

Pair_RepayAsset_event

Pair_Withdraw_event

PairRegistry_AddPair_event

​Tables

​FraxlendPairDeployer_LogDeploy_event

​Pair_AddCollateral_event

​Pair_BorrowAsset_event

​Pair_RemoveCollateral_event

​Pair_RepayAsset_event

​Pair_Withdraw_event

​PairRegistry_AddPair_event

Tables

FraxlendPairDeployer_LogDeploy_event

Pair_AddCollateral_event

Pair_BorrowAsset_event

Pair_RemoveCollateral_event

Pair_RepayAsset_event

Pair_Withdraw_event

PairRegistry_AddPair_event