truefi_v1_ethereum

Tables

LinearTrueDistributor_Distributed_event

TRU token distribution events from TrueFi V1’s linear distributor contract on Ethereum, recording the amount of tokens distributed to addresses over time. Used for tracking vesting schedules and token unlock patterns for TrueFi protocol participants.

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`	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	transaction_hash
0xc7ab606e551bebd69f7611cda1fc473f8e5b8f70	false	223555555555	199	13380680	2021-10-08T21:49:16.000Z	0x5a7cd85f463d104f507b697c170919d7943447a8baa3da57da5a6d38f21a18b8
0xc7ab606e551bebd69f7611cda1fc473f8e5b8f70	false	9146180555555	96	13377019	2021-10-08T08:04:57.000Z	0x4f5951a320c7cf191101ff372b18a51ef2f6456db798d5761c893306dcf83e3f
0xc7ab606e551bebd69f7611cda1fc473f8e5b8f70	false	14793272569444	13	13380620	2021-10-08T21:36:28.000Z	0x4a2e30a172ec017326bddf6fe62c99e9b1b2cffcc0a0b71964dd85b47c91f53c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.truefi_v1_ethereum.LinearTrueDistributor_Distributed_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_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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	in_amount	log_index	in_borrower	block_number	block_timestamp	transaction_hash
2500000000000000	0xa1e72267084192db7387c8cc1328fade470e4149	false	1000000000000000000	1	0x16d02dc67eb237c387023339356b25d1d54b0922	11303160	2020-11-21T18:44:09.000Z	0xb96a2f4c99f466b08c72bd572670a768260e682a9b9a4678136739c529ac427b
25000000000000000000000	0xa1e72267084192db7387c8cc1328fade470e4149	false	10000000000000000000000000	167	0x16d02dc67eb237c387023339356b25d1d54b0922	11661454	2021-01-15T18:44:16.000Z	0x6bf48d10fe219bddd4629a41c3870082701c2125da343883c847067d7c7faf7a
12500000000000000000000	0xa1e72267084192db7387c8cc1328fade470e4149	false	5000000000000000000000000	94	0x16d02dc67eb237c387023339356b25d1d54b0922	11671862	2021-01-17T09:20:25.000Z	0x085124ede23b8f47e964529b9c9657a60cab89381c6becac74feeecb219b145a

Example Query

Query with partition filter

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

Pool_Collected_event

Fee collection events from TrueFi v1 lending pools on Ethereum. Records when protocol fees are collected from pools, including the beneficiary address and amount withdrawn for analyzing protocol revenue distribution.

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_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from 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	in_beneficiary	block_timestamp	transaction_hash
0xa1e72267084192db7387c8cc1328fade470e4149	false	143750002500000000000000	247	14935063	0x2a5c94f3f00db7f11d53d1cfbd9ae8a2bbc7bbf0	2022-06-09T22:41:51.000Z	0xc3111369baca5936bb9161802bda0a7f482844a77eacf6717c8d30ac9fd34da2

Example Query

Query with partition filter

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

Pool_Exited_event

Withdrawal events from TrueFi V1 lending pools on Ethereum, recording when stakers exit positions by redeeming pool tokens for underlying assets. Used for analyzing liquidity provider behavior and capital flows in TrueFi 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_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. 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	in_staker	log_index	block_number	block_timestamp	transaction_hash
0xa1e72267084192db7387c8cc1328fade470e4149	false	36742817789268786505985	0x2f5f2223ba5756eb5403d05fd0b9df9fffed253f	170	12355112	2021-05-02T13:41:38.000Z	0x111206dcf64c44ae866b56072ba4d3b6a5d4a3d7c2f80521fc54faed1ab9fed0
0xa1e72267084192db7387c8cc1328fade470e4149	false	163511240255394760589	0x369052fe460cf5d3ae7e87451c8b4b867bda493b	442	17893487	2023-08-11T18:38:59.000Z	0x952456b4ce811d61cc124e17578b720da2c379430d585b39573bd2919bbeb82b
0xa1e72267084192db7387c8cc1328fade470e4149	false	94573325447133671408543	0x9efab36288565dc343b6909350767cb392aa4f69	74	11364251	2020-12-01T03:35:30.000Z	0x04e89da97c64860f19150180ea117a27b0bd3f62c3320eb9d632a7afccf5cabf

Example Query

Query with partition filter

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

Pool_Joined_event

Deposit events from TrueFi v1 lending pools on Ethereum, capturing user stakes with deposited amounts and corresponding pool share tokens minted. Used for tracking liquidity provider positions and pool entry 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_staker`	`STRING`	Address of the account that deposited or staked tokens into the protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_deposited`	`STRING`	Amount of underlying tokens deposited into the TrueFi pool by the staker, denominated in the smallest unit of the token (wei for ETH-based tokens). This raw integer value must be divided by 10^18 to get the human-readable token amount.
`in_minted`	`STRING`	Amount of tokens minted and issued to the user. String-encoded integer value representing the quantity in the smallest unit of the token.

Sample Data

address	removed	in_minted	in_staker	log_index	block_number	in_deposited	block_timestamp	transaction_hash
0xa1e72267084192db7387c8cc1328fade470e4149	false	9248829660940239070793	0x694047845c8df5a193d2baff613971977665ed26	162	12681535	9900182830695300000000	2021-06-22T03:09:14.000Z	0x140d285c439e6485afce4fe41e491f5818e97d035a73a0f9e1b34aba1ee5f44e
0xa1e72267084192db7387c8cc1328fade470e4149	false	68539667893840601395207	0x36cb763573813990dfae2069c4df4eefba3aec7f	72	11805226	70000000000000000000000	2021-02-06T21:42:44.000Z	0x259885224a98e221f7ac5a1d246865b04eba251d2d66d988d6fd4f5152a78de3
0xa1e72267084192db7387c8cc1328fade470e4149	false	195833176466584368532586	0xf3beff5fcd6aa8d0796097c1e4eb729309055379	166	11804114	200000000000000000000000	2021-02-06T17:30:58.000Z	0x96f516aa7b5677c9b1f04bcc7059f1190a347eb54e68aa9020b3e15d69a04177

Example Query

Query with partition filter

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

Pool_Repaid_event

Loan repayment events from TrueFi v1 lending pools on Ethereum, capturing payer addresses and repayment amounts. Used to track borrower repayment activity and analyze pool cash flows.

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

Sample Data

address	removed	in_payer	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xa1e72267084192db7387c8cc1328fade470e4149	false	0x16d02dc67eb237c387023339356b25d1d54b0922	735308416858884115345639	217	11820455	2021-02-09T05:54:55.000Z	0xc69cd3ea106219aa9248106b37c5eb2eb89ca64371a0ed1fa87963b676a6da3a
0xa1e72267084192db7387c8cc1328fade470e4149	false	0x16d02dc67eb237c387023339356b25d1d54b0922	685632246346789202958483	154	11700307	2021-01-21T18:03:32.000Z	0xc12346b2813cbca640ea38b929acf13c4efb10ef1f47e0acc98d6e1f65000bc7
0xa1e72267084192db7387c8cc1328fade470e4149	false	0x16d02dc67eb237c387023339356b25d1d54b0922	909588328697310730365319	26	11700301	2021-01-21T18:02:25.000Z	0xfbd1da167c2d248d550777b7f79a4e2c64fe348709ebc4627c252414aa8627dd

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LinearTrueDistributor_Distributed_event

Pool_Borrow_event

Pool_Collected_event

Pool_Exited_event

Pool_Joined_event

Pool_Repaid_event

​Tables

​LinearTrueDistributor_Distributed_event

​Pool_Borrow_event

​Pool_Collected_event

​Pool_Exited_event

​Pool_Joined_event

​Pool_Repaid_event

Tables

LinearTrueDistributor_Distributed_event

Pool_Borrow_event

Pool_Collected_event

Pool_Exited_event

Pool_Joined_event

Pool_Repaid_event