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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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.

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_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).

Sample Data

gas	status	in_name	gas_used	in_symbol	signature	to_address	in__maxSize	block_number	from_address	in__duration	trace_address	block_timestamp	transaction_hash	in__lenderVerifier	in__underlyingToken
1205426	true	Alameda Research Portfolio II	499700	tfAlameda2-USDC	0x1987d3fd	0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7	100000000000000	14969637	0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb	16329600	0,2	2022-06-15T21:16:52.000Z	0x3efcacca4ad35047125797130ba501410688aa65f049efae0098bd916dcd137b	0xae48bea8f3fc1696dc8ec75183705cee1d071b05	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
1157192	true	TAM Portfolio I	479800	tfTAM-I-USDC	0x1987d3fd	0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7	0	14612001	0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb	8640000	0,1	2022-04-18T23:09:25.000Z	0x73d824f4642b64f096dfcd78bffea0de4b147ba3c764cfb6656f97e44db20249	0xae48bea8f3fc1696dc8ec75183705cee1d071b05	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
1157199	true	TAM Portfolio II	479800	tfTAM-II-USDC	0x1987d3fd	0x17b7b75fd4288197cfd99d20e13b0dd9da1ff3e7	0	14612005	0xf0ae09d3abdf3641e2eb4cd45cf56873296a02cb	17280000	0,1	2022-04-18T23:10:09.000Z	0xd3349d48f93348b4ac020f439ea5f225668cb52075ffc0b287ae4e4e57f327cd	0xae48bea8f3fc1696dc8ec75183705cee1d071b05	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48

Example Query

Query with partition filter

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.

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

Sample Data

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ManagedPortfolio_BulletLoanCreated_event

ManagedPortfolio_BulletLoanDefaulted_event

ManagedPortfolio_Deposited_event

ManagedPortfolio_ManagerFeeChanged_event

ManagedPortfolio_Withdrawn_event

ManagedPortfolioFactory_createPortfolio_function

ManagedPortfolioFactory_PortfolioCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ManagedPortfolio_BulletLoanCreated_event

​ManagedPortfolio_BulletLoanDefaulted_event

​ManagedPortfolio_Deposited_event

​ManagedPortfolio_ManagerFeeChanged_event

​ManagedPortfolio_Withdrawn_event

​ManagedPortfolioFactory_createPortfolio_function

​ManagedPortfolioFactory_PortfolioCreated_event

Tables

ManagedPortfolio_BulletLoanCreated_event

ManagedPortfolio_BulletLoanDefaulted_event

ManagedPortfolio_Deposited_event

ManagedPortfolio_ManagerFeeChanged_event

ManagedPortfolio_Withdrawn_event

ManagedPortfolioFactory_createPortfolio_function

ManagedPortfolioFactory_PortfolioCreated_event