> ## 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_v3_ethereum
> Tables in tt-contracts.truefi_v3_ethereum
## Tables
### ManagedPortfolio\_BulletLoanCreated\_event
Bullet loan creation events from TrueFi V3 managed portfolios on Ethereum, capturing loan terms including principal amount, repayment amount, duration in seconds, and borrower address. Used for analyzing TrueFi lending activity, loan pricing, and portfolio composition.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| `in_loanDuration` | `STRING` | Duration of the bullet loan in seconds, representing the time between loan creation and expected repayment date. Sample values range from 7 days (604800) to approximately 6 months (17280000), stored as string-encoded integers. |
| `in_borrower` | `STRING` | Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_principalAmount` | `STRING` | Amount of principal repaid, deposited, or allocated in the transaction. String-encoded integer value representing the principal quantity in the smallest unit of the relevant token. |
| `in_repaymentAmount` | `STRING` | Principal plus interest amount due at loan maturity, denominated in the smallest unit of the lending token (e.g., wei for ETH-based tokens). Typically 1-4% higher than `in_principalAmount` based on loan duration and interest rate. |
| in\_id | address | removed | log\_index | in\_borrower | block\_number | block\_timestamp | in\_loanDuration | transaction\_hash | in\_principalAmount | in\_repaymentAmount |
| ------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------- | ------------------- |
| 6 | 0x6a32f6d334ea790e126737f12acefdf9ea94d335 | false | 115 | 0x964d9d1a532b5a5daeacbac71d46320de313ae9c | 14527358 | 2022-04-05T17:41:13.000Z | 6307200 | 0xeff821eba18eab2d35bac8cb88debfbb559f787e7e8c87f317c260ccd66141fb | 2870000000000 | 2915920000000 |
| 15 | 0x3eabf546fff0a41edaaf5b667333a84628571318 | false | 340 | 0x964d9d1a532b5a5daeacbac71d46320de313ae9c | 15002988 | 2022-06-21T15:38:47.000Z | 15724800 | 0x533872e46a3abd0c58200672c0f72397fc2e14e473cbe4b607dc95df362140d5 | 4980000000000 | 5178654246575 |
| 26 | 0xe2805231071207bc9d5781f9f09afab43b068661 | false | 460 | 0x8f4b9297f27d0e92d064e7290208c667a50b3ae1 | 15993537 | 2022-11-18T01:12:23.000Z | 5961600 | 0xde22f7c51a1fb7aa00774528c1871db6809d3061037d1c96d44e0d700a22b4a3 | 160000000000 | 162419726027 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolio_BulletLoanCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ManagedPortfolio\_BulletLoanDefaulted\_event
Events emitted when bullet loans (single-payment loans) default within TrueFi v3 managed portfolios on Ethereum. Used for tracking loan performance issues and portfolio risk events.
| 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_id` | `STRING` | Unique identifier for the position, record, or entity within the protocol. Numeric string representation. |
| in\_id | address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 15 | 0x3eabf546fff0a41edaaf5b667333a84628571318 | false | 129 | 16233165 | 2022-12-21T12:46:11.000Z | 0xd805be10acbadba680a80e93cfb85570cbcb9f388cbac973df028a09180b373b |
| 16 | 0x3eabf546fff0a41edaaf5b667333a84628571318 | false | 141 | 16233184 | 2022-12-21T12:49:59.000Z | 0x5d8eda01966d4baa640dc8f097593e0a00f66feb570dbe701b84e13a29774c0b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolio_BulletLoanDefaulted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ManagedPortfolio\_Deposited\_event
Deposit events from TrueFi v3 managed lending portfolios on Ethereum, tracking lender addresses and deposit amounts into specific portfolio contracts. Used for analyzing capital inflows, lender behavior, and portfolio TVL (Total Value Locked) changes over time.
| 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_lender` | `STRING` | Address of the lender providing funds 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. |
| address | removed | in\_amount | in\_lender | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6a32f6d334ea790e126737f12acefdf9ea94d335 | false | 150001000000 | 0xa776008931c4b245ef57a97e2d21e3ece7411284 | 248 | 14502797 | 2022-04-01T21:30:18.000Z | 0xe55fbe24d1d4ad6b66579a277d66631eec7f871cc2455399b4c150506f08681b |
| 0x7c9b8374b32c75f06c5e5a16ace1822c28f3e87e | false | 100000000 | 0xde0f4538010c538a1bca467722e626475ce5f955 | 203 | 14924407 | 2022-06-08T03:02:14.000Z | 0xe7f7f427840feb17b2f8afa2f6c8e89ee6f86179c8b8b33303b88624d505b7c5 |
| 0x3eabf546fff0a41edaaf5b667333a84628571318 | false | 100000000000 | 0x80009ff8154bd5653c6dda2fa5f5053e5a5c1a91 | 512 | 15625562 | 2022-09-27T15:23:59.000Z | 0x4e971aace1162b1aba5a6ba6ef0990ff1ff3c1eff7209275c74ba0fd73e28dbe |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolio_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ManagedPortfolio\_ManagerFeeChanged\_event
Manager fee update events from TrueFi v3 managed portfolios on Ethereum. Tracks changes to portfolio management fees charged by protocol managers, useful for analyzing fee structure evolution and portfolio economics.
| 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_newManagerFee` | `STRING` | The updated manager fee rate for the TrueFi managed portfolio, represented as a basis points value in string format. A value of '0' indicates no management fee is charged on the portfolio. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newManagerFee | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ |
| 0xf3094013e6106dc26828b64bcde92240398a8379 | false | 506 | 14168139 | 2022-02-08T22:33:10.000Z | 0 | 0xdafcc0b22adcf9ac08e123be94870e271bda174701d2de9bf338109bdc7a4542 |
| 0xa62cafd41676613e3723ff966a0f2e3f6ddffee2 | false | 167 | 14168166 | 2022-02-08T22:37:44.000Z | 0 | 0x2ab7dc1e752467692717c0e535b31e179cd83e2f3a29e08db773c7670330b27d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolio_ManagerFeeChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ManagedPortfolio\_Withdrawn\_event
Withdrawal events from TrueFi V3 managed lending portfolios on Ethereum, recording when lenders redeem their shares for underlying assets. Contains lender addresses, share amounts burned, and assets received for tracking portfolio liquidity and redemption activity.
| 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_lender` | `STRING` | Address of the lender providing funds in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sharesAmount` | `STRING` | Amount of portfolio shares burned during the withdrawal, denominated in the portfolio's share token with 18 decimals. This value represents the lender's ownership stake being redeemed for underlying assets. |
| `in_receivedAmount` | `STRING` | Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token's smallest denomination. |
| address | removed | in\_lender | log\_index | block\_number | block\_timestamp | in\_sharesAmount | transaction\_hash | in\_receivedAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ | ------------------ |
| 0x6a32f6d334ea790e126737f12acefdf9ea94d335 | false | 0x5daeeacf169af4996e09a0afd7d4d488ed1a8afc | 342 | 14987404 | 2022-06-18T22:20:11.000Z | 5794168272930719202117649 | 0xb6759aa0ceaf56e703b152a3877dc73175ecf1a06e6078f6db437d9c9fc7fd00 | 5886402522934 |
| 0x6a32f6d334ea790e126737f12acefdf9ea94d335 | false | 0x2ae5c897107acc1d98a4e245d93a20a8b5a83428 | 288 | 14987215 | 2022-06-18T21:33:54.000Z | 1499946619422382220756250 | 0x7ad2a9b83afafd1692c8aa4a37098c638ac1f0f20ab50246b09ba2a8e279bb5c | 1523823463340 |
| 0x6a32f6d334ea790e126737f12acefdf9ea94d335 | false | 0xa776008931c4b245ef57a97e2d21e3ece7411284 | 315 | 14987162 | 2022-06-18T21:19:53.000Z | 849542342172320980977808 | 0x6f470f5143ae4986e2170c9d2c5b46134535b4e364a72fc938e3f74b478d2fc6 | 863065750034 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolio_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ManagedPortfolioFactory\_createPortfolio\_function
Portfolio creation events from TrueFi v3's ManagedPortfolioFactory contract on Ethereum, capturing parameters like underlying token, max portfolio size, duration, and manager fees when new lending portfolios are deployed. Used for tracking portfolio launches and analyzing portfolio configurations across TrueFi's institutional lending platform.
| 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_name` | `STRING` | Name or label identifier for the entity being created, registered, or updated in the event. |
| `in_symbol` | `STRING` | Symbol of the token involved in the transaction or event. |
| `in__underlyingToken` | `STRING` | Contract address of the token that serves as the portfolio's underlying asset for lending and investment. Hex-encoded, 0x-prefixed Ethereum address, typically USDC or other ERC-20 tokens. |
| `in__lenderVerifier` | `STRING` | Contract address of the lender verifier contract used to validate lender eligibility for this portfolio. Hex-encoded, 0x-prefixed Ethereum address that implements verification logic. |
| `in__duration` | `STRING` | Portfolio duration in seconds from creation to maturity. Commonly ranges from 90 days (7.9M seconds) to 365 days (31.5M seconds). |
| `in__maxSize` | `STRING` | Maximum portfolio size denominated in the underlying token's smallest unit (wei). Specifies the cap on total deposits allowed into this managed portfolio, with 0 indicating no size limit. |
| `in__managerFee` | `STRING` | Fee amount charged to the manager for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei). |
| gas | value | status | in\_name | gas\_used | in\_symbol | signature | to\_address | in\_\_maxSize | block\_number | from\_address | in\_\_duration | trace\_address | in\_\_managerFee | block\_timestamp | transaction\_hash | in\_\_lenderVerifier | in\_\_underlyingToken |
| ------- | ----- | ------ | ----------------------------- | --------- | --------------- | ---------- | ------------------------------------------ | --------------- | ------------- | ------------------------------------------ | -------------- | -------------- | ---------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 1205426 | 0 | true | Alameda Research Portfolio II | 499700 | tfAlameda2-USDC | 0x1987d3fd | 0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7 | 100000000000000 | 14969637 | 0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb | 16329600 | 0,2 | 0 | 2022-06-15T21:16:52.000Z | 0x3efcacca4ad35047125797130ba501410688aa65f049efae0098bd916dcd137b | 0xae48bea8f3fc1696dc8ec75183705cee1d071b05 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
| 1157192 | 0 | true | TAM Portfolio I | 479800 | tfTAM-I-USDC | 0x1987d3fd | 0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7 | 0 | 14612001 | 0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb | 8640000 | 0,1 | 0 | 2022-04-18T23:09:25.000Z | 0x73d824f4642b64f096dfcd78bffea0de4b147ba3c764cfb6656f97e44db20249 | 0xae48bea8f3fc1696dc8ec75183705cee1d071b05 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
| 1157199 | 0 | true | TAM Portfolio II | 479800 | tfTAM-II-USDC | 0x1987d3fd | 0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7 | 0 | 14612005 | 0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb | 17280000 | 0,1 | 0 | 2022-04-18T23:10:09.000Z | 0xd3349d48f93348b4ac020f439ea5f225668cb52075ffc0b287ae4e4e57f327cd | 0xae48bea8f3fc1696dc8ec75183705cee1d071b05 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolioFactory_createPortfolio_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ManagedPortfolioFactory\_PortfolioCreated\_event
Portfolio creation events from TrueFi V3's ManagedPortfolioFactory contract on Ethereum, capturing the deployment of new managed lending portfolios with their assigned manager addresses. Used to track portfolio initialization and manager assignments across TrueFi's decentralized lending protocol.
| 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_newPortfolio` | `STRING` | Contract address of the newly created TrueFi managed portfolio instance on Ethereum. Hex-encoded, 0x-prefixed 40-character string identifying the deployed portfolio contract. |
| `in_manager` | `STRING` | Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | in\_manager | block\_number | block\_timestamp | in\_newPortfolio | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7 | false | 52 | 0x19885377b0d10c7697df33eda5cb276c9837ebae | 14923222 | 2022-06-07T22:15:17.000Z | 0x7c9b8374b32c75f06c5e5a16ace1822c28f3e87e | 0x75fb363e48678d96c0d6bf14fed6d7451f546964660c73c21688e8a69f60adf2 |
| 0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7 | false | 86 | 0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb | 14232440 | 2022-02-18T21:18:26.000Z | 0x6a32f6d334ea790e126737f12acefdf9ea94d335 | 0x1ba6c01c21c3e020a01a63913a3937aeb5eb9e7ac5a3be657c303304ffd4d4e6 |
| 0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7 | false | 245 | 0x40d811662c61d140245d24e7dcfe240c40d32e4a | 14981165 | 2022-06-17T20:34:49.000Z | 0xae86120411c450bc792e7465653f99e2fe47752c | 0xc50dff99f1fd735c2121190bf4839a17fcbdb0aa8ce7914c2a33815543e0218f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.truefi_v3_ethereum.ManagedPortfolioFactory_PortfolioCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***