> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# truefi_v1_ethereum

> Tables in tt-contracts.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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.truefi_v1_ethereum.LinearTrueDistributor_Distributed_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.truefi_v1_ethereum.Pool_Borrow_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.truefi_v1_ethereum.Pool_Collected_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.truefi_v1_ethereum.Pool_Exited_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                                                                                   |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.truefi_v1_ethereum.Pool_Joined_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.truefi_v1_ethereum.Pool_Repaid_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***