truefi_v2_ethereum

Tables

LoanFactory_createLoanToken_function

Loan origination function calls on TrueFi v2 Ethereum protocol, capturing loan token creation with parameters including pool address, loan amount, annual percentage yield (APY in basis points), and term duration in seconds. Used for analyzing lending activity, borrowing costs, and loan issuance patterns across TrueFi pools.

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`	`NUMERIC`	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__pool`	`STRING`	Contract address of the TrueFi lending pool originating the loan. Hex-encoded, 0x-prefixed Ethereum address identifying the pool providing liquidity for this loan token.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__term`	`STRING`	Loan term duration in seconds. Typically 2,592,000 (30 days) or 7,776,000 (90 days) in TrueFi V2 lending pools.
`in__apy`	`STRING`	Annual percentage yield (APY) for the loan expressed in basis points. Multiply by 0.01 to convert to percentage (e.g., 1157 = 11.57% APY).

Sample Data

gas	status	in__apy	gas_used	in__pool	in__term	signature	in__amount	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
2716209	true	1157	2656312	0x6002b1dcb26e7b1aa797a17551c6f487923299d7	2592000	0xe3f22b65	2800000000000	0x69d844fb5928d0e7bc530cc6325a88e53d6685bc	14001691	0x6dc861183f6c477e95c5325230fbedc10a808570	0,0	2022-01-14T05:10:08.000Z	0x7fdb16b9cee3145a92dd0f462ea67075c5ea096fa60fa41ea1cb35147c798125
3126929	true	899	2656312	0xa991356d261fbaf194463af6df8f0464f8f1c742	7776000	0xe3f22b65	8820000000000	0x69d844fb5928d0e7bc530cc6325a88e53d6685bc	13231733	0x495f8bc43b920279d33d1b34873ab8832440c322		2021-09-15T17:44:07.000Z	0x77e4a9c61c399b0d3a348b18c96ea8f2a1ec913ef6cd1120b1dd17936b62305b
3126929	true	933	2656312	0xa991356d261fbaf194463af6df8f0464f8f1c742	2592000	0xe3f22b65	8490000000000	0x69d844fb5928d0e7bc530cc6325a88e53d6685bc	13231581	0x3ccf39e3f47a8bf6145b781f8236454f73079b41		2021-09-15T17:08:02.000Z	0x0e23c6cefc6ac3df40f01f249c35495f16af24d1910e64b8f8a29182858d3054

Example Query

Query with partition filter

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

LoanFactory_LoanTokenCreated_event

LoanToken creation events from TrueFi V2’s LoanFactory contract on Ethereum, capturing each new loan origination with the deployed loan token contract address. Used for tracking loan issuance activity and identifying individual loan contracts for portfolio analysis.

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_contractAddress`	`STRING`	Contract address on the destination blockchain that is the target of the cross-chain call or deployment. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_contractAddress
0x69d844fb5928d0e7bc530cc6325a88e53d6685bc	false	100	12746155	2021-07-02T04:45:46.000Z	0x3bb31e6cabec4305d7f05adec145d328f502229f88c08d12e1658165750ca74b	0x9fb208196fa3505f531efd7d89712f5e18d96a5d
0x69d844fb5928d0e7bc530cc6325a88e53d6685bc	false	139	13324279	2021-09-30T01:55:17.000Z	0xe4101892232e3fa805a92471eeb8cca9aff9bf14aecb8261bc34a421f818239c	0x7d6ae84a8fff85e75bccade39a237c7d9a0a6c71
0x69d844fb5928d0e7bc530cc6325a88e53d6685bc	false	36	13328258	2021-09-30T17:03:36.000Z	0x524c0138589b5c8a8ed176add3a07b997b1fe0af93dc188385e6e585bdd70ac3	0x37b8010decf23bd0ab0dc88cd971ce2912d8964c

Example Query

Query with partition filter

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

LoanToken_Defaulted_event

Loan default events from TrueFi v2 lending protocol on Ethereum, recording when individual loans fail to be repaid with the returned amount recovered. Used for tracking protocol risk events and analyzing borrower default 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_returnedAmount`	`STRING`	Amount of tokens returned to the user after completing the swap or settlement operation. String-encoded integer representing the quantity in the smallest denomination of the output token.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_returnedAmount
0x97688fb5a06b6f3d3b524f7530afbeb883cdc642	false	379	15868617	2022-10-31T14:24:11.000Z	0xb20d6ae7422e9dd8d477b20f39c87fa6b5a5843d8d8d9084853e5392dbd21953	0
0x4a66a867f52df4ed1d8580a1c383b2dd036a3c47	false	137	15734095	2022-10-12T19:24:23.000Z	0x9a4309bad5a047f128ca62bd69e12ef47992da5eca3fd540256a9fe4507975f5	645405815696064463503820

Example Query

Query with partition filter

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

LoanToken_fund_function

LoanToken fund() function calls on TrueFi V2 lending protocol on Ethereum, tracking when loan tokens receive funding from the originating pool. Used for analyzing loan origination timing and borrower funding 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.
`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`	`NUMERIC`	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.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
4129796	true	106836	0xb60d4288	0x30eb1e7fb76ae6feda7efb1bc6a4d3490f2e61d2	12537842	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0,10	2021-05-30T20:30:40.000Z	0x582df55fb9f503a2ba9fa4f8c4b1222a98dc4137634f201ab75e9f3932009b84
157270	true	108932	0xb60d4288	0xf0974bb470037dcbdf5e0001caa883e84589d76f	14213183	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0,11	2022-02-15T21:32:53.000Z	0x066d4024acb343befbcd78a30f094c4fab3d95b6edd6938ada4ced87cc5eca29
229977	true	108932	0xb60d4288	0xf590649cbacdb392658d4436f2328768c9f2caaa	13523778	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0,11	2021-10-31T08:38:50.000Z	0x1c59fa79dcb2ef4fe2a1d0f42d08ceb9ae86c16a4676329180e2595d89917c13

Example Query

Query with partition filter

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

LoanToken_Funded_event

Loan funding events from TrueFi V2 lending protocol on Ethereum, emitted when a loan token receives capital from the lending pool. Tracks individual loan originations with lender address and loan token contract for analyzing lending pool deployment 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.

Sample Data

address	removed	in_lender	log_index	block_number	block_timestamp	transaction_hash
0x232e0a81c41c0b0999e7b671cb5046beb808c49f	false	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	279	15833955	2022-10-26T18:11:11.000Z	0x0cf5fe80ab2ddd2208568bafeac5834b1ffdec5ffd27c70a43f0defd0edf5bf2
0x033e25dde1cfdb4f5183e924d4ff93b678cf8f74	false	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	331	13170489	2021-09-06T06:02:55.000Z	0x1d088c3b6c65cc70b207f92b6f9ecdde258e51bfa29e8a409990ecca6ffe0b16
0xccfceb165345e9c5231cf1465aa8e956dc28e2fb	false	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	300	15376198	2022-08-20T07:00:39.000Z	0xc09ac8e337c5ec07a5e3a85fc385ee18dd698b5b91ca0f0672dcdf1b98310440

Example Query

Query with partition filter

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

LoanToken_liquidate_function

Liquidation event traces for TrueFi v2 loans on Ethereum, capturing when loan tokens are liquidated due to borrower default or undercollateralization. Used for analyzing protocol risk events, liquidation timing, and recovery processes.

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`	`NUMERIC`	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.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1900173	0	true	6683	0x28a07025	0x4a66a867f52df4ed1d8580a1c383b2dd036a3c47	15734123	0x7ac899754dd042024bb168fd5c9a07420f444bdf	0,4,0,10	2022-10-12T19:29:59.000Z	0xedd04254b5177c78112f236c807bdf5da0c09e950b8c9952e3d1f795e4669e3e
1812304	0	true	6683	0x28a07025	0x97688fb5a06b6f3d3b524f7530afbeb883cdc642	15883716	0x7ac899754dd042024bb168fd5c9a07420f444bdf	0,3,0,10	2022-11-02T17:05:59.000Z	0x6301a634575377750fd9cbd41b27a672bc96e70f14845a353ca14b7388d19eb6

Example Query

Query with partition filter

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

LoanToken_Liquidated_event

Liquidation events from TrueFi V2 loan tokens on Ethereum, capturing when undercollateralized loans are liquidated with status codes and contract addresses. Used for tracking loan defaults and protocol risk management across TrueFi’s lending pools.

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_status`	`INT64`	Status code representing the state of the entity or operation. Integer value with meaning specific to the contract context.

Sample Data

address	removed	in_status	log_index	block_number	block_timestamp	transaction_hash
0x97688fb5a06b6f3d3b524f7530afbeb883cdc642	false	5	149	15883716	2022-11-02T17:05:59.000Z	0x6301a634575377750fd9cbd41b27a672bc96e70f14845a353ca14b7388d19eb6
0x4a66a867f52df4ed1d8580a1c383b2dd036a3c47	false	5	121	15734123	2022-10-12T19:29:59.000Z	0xedd04254b5177c78112f236c807bdf5da0c09e950b8c9952e3d1f795e4669e3e

Example Query

Query with partition filter

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

LoanToken_reclaim_function

TrueFi V2 loan token reclaim function calls on Ethereum, tracking attempts to recover collateral or funds from defaulted or completed loans with transaction-level execution details.

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`	`NUMERIC`	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.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
2828936	0	false	4638	0x80e9071b	0x9997d247ac85af038cfe49d0ca393b90bd664e19	15294963	0x748e8726cac8f58e366829d9c2b72ba97e1cf2f6		2022-08-07T11:43:19.000Z	0x0d254ffb30124db1d17f3679ed543954477631d852d56314ea9d7da8db812411

Example Query

Query with partition filter

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

LoanToken_redeem_function

LoanToken redemption function calls on TrueFi v2 lending protocol (Ethereum), capturing when lenders withdraw their principal and interest by burning loan tokens. Contains redemption amounts, transaction execution details, and caller addresses for analyzing loan repayment flows and lender exit behavior.

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`	`NUMERIC`	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__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1533554	true	54933	0xdb006a75	6162436702668606637181230	0xfd73553fac90fb32f91f8f98bf6e2d913add613d	13551889	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0,5	2021-11-04T18:46:18.000Z	0xe1cfcf914e48c5808bd151297b4f30fbd78ed566a608e23e4223fb2d51f27853
1539786	true	72027	0xdb006a75	8657191780821917808219178	0xdb7754d0ca2c62896bf1f745288f7008f13ba599	13551907	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0,5	2021-11-04T18:51:24.000Z	0x15801e97075e348ad35024f34a09e647cab5bd1da1539d81be5d3debd9940925
1532931	true	72027	0xdb006a75	9113476712328767123287671	0x17314ce9a99a98be1a2537af925b488499c10102	13551900	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0,5	2021-11-04T18:49:24.000Z	0x5c80c2953b36d58c806a578899e9d3b9255b2cc9749352cb7508507b0f2a3ec5

Example Query

Query with partition filter

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

LoanToken_Redeemed_event

Redemption events from TrueFi v2 loan tokens on Ethereum, capturing when lenders burn loan tokens to reclaim underlying assets. Records burned token amounts, redeemed principal, and receiver addresses for analyzing loan repayment activity and liquidity withdrawals.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_burnedAmount`	`STRING`	Amount of loan tokens burned when redeemed, denominated in the token’s smallest unit (wei-equivalent). This value typically matches in_redeemedAmount as burned tokens are exchanged 1:1 for the underlying asset upon redemption.
`in_redeemedAmount`	`STRING`	Amount of underlying tokens redeemed by burning TrueFi LoanTokens, denominated in the smallest token unit (wei for 18-decimal tokens). Matches the burned amount in all sample cases, representing the 1:1 conversion value from loan tokens to underlying assets.

Sample Data

address	removed	log_index	in_receiver	block_number	block_timestamp	in_burnedAmount	transaction_hash	in_redeemedAmount
0x864641e8040798da2e680f4bb3c93ed6ebb62982	false	22	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	12788049	2021-07-08T17:29:14.000Z	1013972490166	0x5a16daf6f3f40ddf2c48dcaf7ade439917d3d504e982633548b130f405e1ae5e	1013972490166
0x164c6f974a9dab180bc763412624107e413af8a2	false	198	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	13052654	2021-08-19T01:17:39.000Z	3216864470277	0x15fed0eec726f76bf76d63ad9cf54530511fb25e900b54414652810decee0397	3216864470277
0xdddca5cf3a53868428ea428cdc6b30bca0f05921	false	355	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	15690010	2022-10-06T15:39:59.000Z	19205081424657	0x73210b0261dafd3c18ebec820fe240e4c1c1618f06dc192fe57a2df9607838cc	19205081424657

Example Query

Query with partition filter

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

LoanToken_Repaid_event

Loan repayment events from TrueFi v2 lending protocol on Ethereum, tracking when borrowers repay principal and interest on tokenized loans. Contains repayment amounts, borrower addresses, and loan token contracts for analyzing loan performance and protocol 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_repayer`	`STRING`	Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repaidAmount`	`STRING`	Amount of tokens repaid by the borrower in the loan repayment transaction, denominated in the smallest unit of the loan token (wei for ETH-based tokens). Values are stored as strings to preserve precision for large token amounts.

Sample Data

address	removed	log_index	in_repayer	block_number	block_timestamp	in_repaidAmount	transaction_hash
0x232e0a81c41c0b0999e7b671cb5046beb808c49f	false	178	0xb868dd38a23b0ad901b635d7b7fe235f2460dc2b	16471131	2023-01-23T17:54:59.000Z	5649178082191	0x70b107fc343464d96b76950adb53204cc8abc81cdd802b6a9624aa23eb10d013
0x4a66a867f52df4ed1d8580a1c383b2dd036a3c47	false	420	0x5ef538da06e6e41e14c788728054436b0a64e4eb	15734077	2022-10-12T19:20:47.000Z	507082023803132490939782	0x45c8489d5c64fe26e67a42b3925dcf1ddaaf39799fe0b092b2d07534a9566859

Example Query

Query with partition filter

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

LoanToken_repay_function

Loan repayment transaction records from TrueFi v2 lending protocol on Ethereum. Captures repayment amounts, sender addresses, and execution details for tracking borrower payment activity and loan performance.

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`	`NUMERIC`	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__sender`	`STRING`	Address of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	value	status	gas_used	signature	in__amount	in__sender	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
83458	0	true	48412	0x22867d78	507082023803132490939782	0x5ef538da06e6e41e14c788728054436b0a64e4eb	0x4a66a867f52df4ed1d8580a1c383b2dd036a3c47	15734077	0x5ef538da06e6e41e14c788728054436b0a64e4eb		2022-10-12T19:20:47.000Z	0x45c8489d5c64fe26e67a42b3925dcf1ddaaf39799fe0b092b2d07534a9566859

Example Query

Query with partition filter

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

LoanToken_repayInFull_function

Loan repayment transactions from TrueFi v2 protocol on Ethereum where borrowers fully repay their outstanding loan principal and interest. Used for tracking loan closure events and analyzing borrower repayment behavior.

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`	`NUMERIC`	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__sender`	`STRING`	Address of the account initiating the contract function call or event emission. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	value	status	gas_used	signature	in__sender	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
636615	0	true	48526	0x780f9e37	0xb868dd38a23b0ad901b635d7b7fe235f2460dc2b	0x232e0a81c41c0b0999e7b671cb5046beb808c49f	16471131	0xb868dd38a23b0ad901b635d7b7fe235f2460dc2b	0,0,0,0,1,2	2023-01-23T17:54:59.000Z	0x70b107fc343464d96b76950adb53204cc8abc81cdd802b6a9624aa23eb10d013

Example Query

Query with partition filter

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

LoanToken_Settled_event

Loan settlement events from TrueFi V2 on Ethereum, recording when loan tokens are repaid with the returned principal and interest amounts. Used for tracking loan performance, default rates, and protocol revenue across TrueFi lending pools.

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_returnedAmount`	`STRING`	Amount of tokens returned to the user after completing the swap or settlement operation. String-encoded integer representing the quantity in the smallest denomination of the output token.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_returnedAmount
0xadf046a62c1a1a01289176a015dff0995bba46e9	false	247	13614304	2021-11-14T13:39:00.000Z	0x40af7c75b5cb17f5589af4eed84e74705ceaa749abd667d9210145a164ab0274	53833938630136
0x8ab3055722c62be1673a194cc9c7a0fbdd898eca	false	319	12854254	2021-07-19T02:02:34.000Z	0xbc5998c0747fee3d7eb6ecf96cca1fc861f1804d590dd3975afc6b8481079c1e	506986301369
0xd425b404a8ba51dc4b260fdbb284d55b7a970a13	false	66	14528824	2022-04-05T23:16:43.000Z	0x0f9cb40ea6bf5796c74a9c7c3250984fb353f2191fbc9e2dced6f22028804b1f	55768335095890

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.truefi_v2_ethereum.LoanToken_Settled_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.

Sample Data

address	removed	in_amount	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0xa991356d261fbaf194463af6df8f0464f8f1c742	false	500000000000	329	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	12668207	2021-06-20T01:05:40.000Z	0xa552dfe34250e4038363135c7fb46e659714c2b91d7bc6e902db972a88eabaee
0xa991356d261fbaf194463af6df8f0464f8f1c742	false	8598000000000	301	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	13595816	2021-11-11T15:53:16.000Z	0xda66d614b6a3fc8d480a59aac16f7bf1cc7d7a090f1e8deefe518f80073e1772
0x1ed460d149d48fa7d91703bf4890f97220c09437	false	20000000000000000000000000	262	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	14828513	2022-05-23T08:30:14.000Z	0x062b4aec76049471adce8ed33d5a50f69241f320ec3a4a8225a9aafce5943403

Example Query

Query with partition filter

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

Pool_Exited_event

Withdrawal events from TrueFi V2 lending pools on Ethereum, recording staker exits with withdrawn amounts and pool addresses. Used for tracking liquidity provider activity and pool outflow analysis.

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
0x1ed460d149d48fa7d91703bf4890f97220c09437	false	1773446315656882587757826	0x2bbde8e38badf38603c8c66869faeb0117bfb1bf	169	14760528	2022-05-12T10:22:57.000Z	0xd32407ebd35272a17fc603af3e3b021fe09444bbfcda5f51fcf8dee48b0fd02d
0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	559706469027	0x0b5a91adc9a867501fd814cea2caba28f9770b63	202	14759292	2022-05-12T05:32:21.000Z	0x217269cd3b56fb09cf482baa6912c13f27f160e97831e6642c8bbfd415f674c3
0xa991356d261fbaf194463af6df8f0464f8f1c742	false	4648633995662	0x4460c8c57b8094d64076e6c26711c3b65554c8d9	188	14759567	2022-05-12T06:34:25.000Z	0x1942cbf72cbf8da423fbe23c5c2ed8e93bb56d4f2e4b4e2f12c213f88b62b6dc

Example Query

Query with partition filter

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

Pool_Joined_event

Deposit events from TrueFi V2 lending pools on Ethereum, capturing when stakers join pools by depositing assets and receiving minted pool tokens. Used for tracking liquidity provider activity and pool token issuance across 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_deposited`	`STRING`	Amount of underlying tokens deposited into the TrueFi v2 pool by the staker, denominated in the smallest unit of the token. Values typically range from billions to trillions, representing deposits with token-specific decimal precision.
`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
0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	479581592556	0x8c14ac5b17cff2612e48334935db48cfd56cbc09	345	12697973	479581592556	2021-06-24T16:49:50.000Z	0xc303d421f7eeb2b2fb799df9f4d03205e2d790b61f4dffb63f3f5fbd0bc51d53
0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	1431014317683	0x818b0246ee14f772847404c12bdc313b1c71bfee	190	12698772	1431014317683	2021-06-24T19:41:49.000Z	0x7cfd68d993b6c0bc59b625fc904e5ac1a53b3cc93d7dd62d03d6847f5365c870
0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	50000000000	0xe4cbd73a353c11030c98b4166cba7afa594895b0	72	12696437	50000000000	2021-06-24T10:57:23.000Z	0x173cde807637811bd76ad3aa44ecbb052a9f9fdd0102445411f72671acf41f9c

Example Query

Query with partition filter

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

Pool_Repaid_event

Loan repayment events from TrueFi v2 lending pools on Ethereum, capturing the payer address and repayment amount for each pool transaction. Used for tracking borrower repayment behavior and pool cash flow analysis.

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
0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	18214882597261	64	13462935	2021-10-21T19:39:06.000Z	0x21b39e53b40e284d9b59c2140eac29d53a9ec7e4c74d69a050ec0001af0fba94
0xa991356d261fbaf194463af6df8f0464f8f1c742	false	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	55205835616438	46	13462935	2021-10-21T19:39:06.000Z	0xd048e97f6398ad98807b38971c0ee1c272b13083c1fbbdc461425c48aafd6480
0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	2037847380136	437	15000305	2022-06-21T03:47:50.000Z	0x4b2f3fc5ef83e4b57b928a44c2214bf8b2b7eedcdf1ea9ceaef59f45368a7b70

Example Query

Query with partition filter

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

PoolFactory_PoolCreated_event

Pool creation events emitted by factory contracts when new liquidity pools are deployed. Records the pool address, token pair or configuration parameters, and fee structure for tracking pool deployments across decentralized exchange protocols.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0x1391d9223e08845e536157995085fe0cef8bd393	0xa991356d261fbaf194463af6df8f0464f8f1c742	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	37	12471560	2021-05-20T13:28:14.000Z	0xb21186ddb51c1a8b73fbc7abbd9ade04b873c139efc4ea9afe926f0c142c5bcf
0x1391d9223e08845e536157995085fe0cef8bd393	0x97ce06c3e3d027715b2d6c22e67d5096000072e5	false	0x0000000000085d4780b73119b644ae5ecd22b376	104	13043539	2021-08-17T15:32:30.000Z	0x8493d3f3d6d8415e7f9c9c64e37d5b6ea1bd2130c10c606b7e9ba0fecbb7ed8e
0x1391d9223e08845e536157995085fe0cef8bd393	0x6002b1dcb26e7b1aa797a17551c6f487923299d7	false	0xdac17f958d2ee523a2206206994597c13d831ec7	292	12653200	2021-06-17T17:13:55.000Z	0xe4d353c8f2cd6f68b302ebe07d4c7eac64dc00a6a58255310f40090604913a3d

Example Query

Query with partition filter

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

SAFU_Liquidated_event

SAFU (Secure Asset Fund for Users) liquidation events from TrueFi v2 lending protocol on Ethereum, capturing undercollateralized loan defaults with deficit amounts and token addresses. Used for tracking protocol insurance fund activations and analyzing credit risk across lending pools.

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_loan`	`STRING`	Contract address of the loan being created, claimed, funded, or liquidated. Hex-encoded, 0x-prefixed, 42-character string.
`in_repaid`	`STRING`	Amount of the loan that was repaid before liquidation, denominated in the deficiency token’s smallest unit. Typically zero when SAFU (Secure Asset Fund for Users) liquidations occur due to loan defaults.
`in_deficiencyToken`	`STRING`	Contract address of the token in which the deficit is denominated after SAFU (Secure Asset Fund for Users) liquidation. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token used to measure the loan shortfall.
`in_deficit`	`STRING`	Outstanding debt amount in the loan’s deficiency token after liquidation. Denominated in the token’s smallest unit (wei-equivalent), represents the shortfall that SAFU (Secure Asset Fund for Users) must cover.

Sample Data

address	in_loan	removed	in_repaid	log_index	in_deficit	block_number	block_timestamp	transaction_hash	in_deficiencyToken
0x1ea63189eb1f4c109b10cf6567f328c826aa6151	0x4a66a867f52df4ed1d8580a1c383b2dd036a3c47	false	0	127	3496922708547945205479452	15734123	2022-10-12T19:29:59.000Z	0xedd04254b5177c78112f236c807bdf5da0c09e950b8c9952e3d1f795e4669e3e	0x7ddb9665810593900219d9f12dc46602b7b181f9
0x1ea63189eb1f4c109b10cf6567f328c826aa6151	0x97688fb5a06b6f3d3b524f7530afbeb883cdc642	false	0	154	1065046038794520547945205	15883716	2022-11-02T17:05:59.000Z	0x6301a634575377750fd9cbd41b27a672bc96e70f14845a353ca14b7388d19eb6	0x50650c56aa2c39c6e76b57883edab738553a3b56

Example Query

Query with partition filter

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

TrueLender_fund_function

Function calls to the TrueFi v2 lending protocol’s fund operation on Ethereum, recording capital deployments to loan tokens. Used to track lending pool funding events and analyze liquidity provider contributions to specific loan opportunities.

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_loanToken`	`STRING`	Contract address of the loan token associated with the lending operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in_loanToken	block_timestamp	transaction_hash
402788	true	289560	0x23024408	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	15369206	0xa801855ef035db7f90f4dd11ee4a49ac47db0ccd	0x7372d690d521f289467ac9c0b647c5d35e8c6d3c	2022-08-19T04:15:09.000Z	0x30e14b47026d72e35dd357298873d7b843f16fd9636e988cad380e1339b04b36
2532737	true	1969418	0x23024408	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	13170489	0x964d9d1a532b5a5daeacbac71d46320de313ae9c	0x033e25dde1cfdb4f5183e924d4ff93b678cf8f74	2021-09-06T06:02:55.000Z	0x1d088c3b6c65cc70b207f92b6f9ecdde258e51bfa29e8a409990ecca6ffe0b16
402788	true	289560	0x23024408	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	15376198	0x728b77751a7b1ae29a94901695f3dd8add37d086	0xccfceb165345e9c5231cf1465aa8e956dc28e2fb	2022-08-20T07:00:39.000Z	0xc09ac8e337c5ec07a5e3a85fc385ee18dd698b5b91ca0f0672dcdf1b98310440

Example Query

Query with partition filter

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

TrueLender_Funded_event

Loan funding events from TrueFi V2 protocol on Ethereum, recording when the TrueLender contract disburses funds from lending pools to borrowers. Used for tracking loan origination activity, pool utilization, and capital deployment across different TrueFi lending pools.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_loanToken`	`STRING`	Contract address of the loan token associated with the lending 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	in_pool	removed	in_amount	log_index	block_number	in_loanToken	block_timestamp	transaction_hash
0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0xa991356d261fbaf194463af6df8f0464f8f1c742	false	3000000000000	183	13576257	0x0d0ec8e87663b1f28c2f01feb3f3eb3ae3ebdea1	2021-11-08T14:15:40.000Z	0xf4f43417c264db480dc46256071a00cb030c76544c2dc14a5e0d101d8ace0ffa
0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0xa991356d261fbaf194463af6df8f0464f8f1c742	false	2058000000000	185	13573688	0x63f828f9490ea9a1ca6965bfc7eb386fb0faa6c4	2021-11-08T04:34:33.000Z	0x9e5477a755b5c77a692fc87812bd95c4360c7fafa2176bcae68e59844502ea9a
0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0xa991356d261fbaf194463af6df8f0464f8f1c742	false	3500000000000	250	14787161	0x73e7a62e5c88aed26df4d1df4d11a41029103278	2022-05-16T15:54:51.000Z	0xaf716e83298751900132264eb747e9667c45060bf0b3154f3805399479c214d9

Example Query

Query with partition filter

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

TrueLender_reclaim_function

TrueFi V2 lending protocol reclaim function calls on Ethereum, tracking lender operations to recover unused funds or expired loan tokens from the TrueLender contract. Used for analyzing fund management operations and recovery patterns across different loan token pools.

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`	`NUMERIC`	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_loanToken`	`STRING`	Contract address of the loan token associated with the lending operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	gas_used	signature	to_address	block_number	from_address	in_loanToken	block_timestamp	transaction_hash
891939	true	0x	875259	0xc35287f7	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	12854371	0x1fdb7d685c1bbc83c8a16e7b88a59d9a58fc22ca	0x8ab3055722c62be1673a194cc9c7a0fbdd898eca	2021-07-19T02:31:56.000Z	0xd17f41b07581ec2dfe07b25e47d2f44787dc676c6db4beb72a2557f4fe6c5390
216238	true	0x	212975	0xc35287f7	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	14758878	0x1fdb7d685c1bbc83c8a16e7b88a59d9a58fc22ca	0x6eedc3df6747ebc1c00ab254b64c46c9e07e02f1	2022-05-12T03:54:49.000Z	0xc80d81de7f5529dde5322155b64f5279d157666e3b2a8a9fbe020cd6c723d04e
878030	false	0x2e95b6c80000000000000000000000000000000000085d4780b73119b644ae5ecd22b37600000000000000000000000000000000000000000000003745a3eedcc9b39dce000000000000000000000000000000000000000000000000000000003baaac060000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000200000000000000003b6d0340760166fa4f227da29ecac3bec348f5fa853a1f3c80000000000000003b6d0340397ff1542f962076d0bfe58ea045ffa2d347aca0cfee7c08	852208	0xc35287f7	0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	14016676	0x1fdb7d685c1bbc83c8a16e7b88a59d9a58fc22ca	0x309d8b391835dacc934bda4af5cc1d8f196ba122	2022-01-16T13:02:17.000Z	0x794a9698e86c9907df05159ba454280d112596368df7da0ea5249863e6cc0073

Example Query

Query with partition filter

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

TrueLender_Reclaimed_event

Reclaimed loan token events from TrueFi V2 lending pools on Ethereum, tracking when the TrueLender contract reclaims tokens from specific pools. Used for analyzing pool liquidity operations and capital allocation between different TrueFi lending pools.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_loanToken`	`STRING`	Contract address of the loan token associated with the lending 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	in_pool	removed	in_amount	log_index	block_number	in_loanToken	block_timestamp	transaction_hash
0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0x97ce06c3e3d027715b2d6c22e67d5096000072e5	false	12483048054794520547945205	363	14093338	0x479e75d870034815aeae0a208244fdef3b360e35	2022-01-28T09:26:24.000Z	0xb0961fff717d1212576bd6cbad1afebd2cf734e7f540c55d6e8f7d1062b17f02
0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0x97ce06c3e3d027715b2d6c22e67d5096000072e5	false	12426870356164383561643835	350	14093335	0x67f3ba00e32e45c06699db47e1a95f3c346d45dd	2022-01-28T09:25:56.000Z	0x399c29edcca8dde752c5e537b5ec3d099780ec912a1d96133ebad251d58ad706
0xa606dd423df7dfb65efe14ab66f5fdebf62ff583	0x97ce06c3e3d027715b2d6c22e67d5096000072e5	false	9096299857534246575342465	375	14093343	0x033e25dde1cfdb4f5183e924d4ff93b678cf8f74	2022-01-28T09:28:16.000Z	0x49ebe4d58bd4de519741da34e50701b121281a612f56a2150b83d846ca855008

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LoanFactory_createLoanToken_function

LoanFactory_LoanTokenCreated_event

LoanToken_Defaulted_event

LoanToken_fund_function

LoanToken_Funded_event

LoanToken_liquidate_function

LoanToken_Liquidated_event

LoanToken_reclaim_function

LoanToken_redeem_function

LoanToken_Redeemed_event

LoanToken_Repaid_event

LoanToken_repay_function

LoanToken_repayInFull_function

LoanToken_Settled_event

Pool_Borrow_event

Pool_Exited_event

Pool_Joined_event

Pool_Repaid_event

PoolFactory_PoolCreated_event

SAFU_Liquidated_event

TrueLender_fund_function

TrueLender_Funded_event

TrueLender_reclaim_function

TrueLender_Reclaimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LoanFactory_createLoanToken_function

​LoanFactory_LoanTokenCreated_event

​LoanToken_Defaulted_event

​LoanToken_fund_function

​LoanToken_Funded_event

​LoanToken_liquidate_function

​LoanToken_Liquidated_event

​LoanToken_reclaim_function

​LoanToken_redeem_function

​LoanToken_Redeemed_event

​LoanToken_Repaid_event

​LoanToken_repay_function

​LoanToken_repayInFull_function

​LoanToken_Settled_event

​Pool_Borrow_event

​Pool_Exited_event

​Pool_Joined_event

​Pool_Repaid_event

​PoolFactory_PoolCreated_event

​SAFU_Liquidated_event

​TrueLender_fund_function

​TrueLender_Funded_event

​TrueLender_reclaim_function

​TrueLender_Reclaimed_event

Tables

LoanFactory_createLoanToken_function

LoanFactory_LoanTokenCreated_event

LoanToken_Defaulted_event

LoanToken_fund_function

LoanToken_Funded_event

LoanToken_liquidate_function

LoanToken_Liquidated_event

LoanToken_reclaim_function

LoanToken_redeem_function

LoanToken_Redeemed_event

LoanToken_Repaid_event

LoanToken_repay_function

LoanToken_repayInFull_function

LoanToken_Settled_event

Pool_Borrow_event

Pool_Exited_event

Pool_Joined_event

Pool_Repaid_event

PoolFactory_PoolCreated_event

SAFU_Liquidated_event

TrueLender_fund_function

TrueLender_Funded_event

TrueLender_reclaim_function

TrueLender_Reclaimed_event