goldfinch_v3_base - Token Terminal Docs

Tables

Advisor_AssetToAssetSwapExecuted_event

Asset swap execution events from Goldfinch v3 protocol on Base, recording portfolio rebalancing transactions where assets are exchanged between portfolios. Used for tracking automated asset allocation changes and advisor-driven portfolio management 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_rebalanceId`	`STRING`	Unique identifier for the rebalancing operation. 66-character hex string including 0x prefix.
`in_portfolioAId`	`STRING`	Identifier for the source portfolio from which asset A was transferred during the swap. Numeric string representing the portfolio ID in the Goldfinch Advisor contract rebalancing system.
`in_portfolioBId`	`STRING`	Portfolio identifier receiving Asset B in the swap operation. Numeric string identifier that pairs with `in_portfolioAId` to track bilateral asset exchanges between portfolios.
`in_assetAId`	`STRING`	Identifier for the first asset being swapped in the rebalance operation. Numeric string representing the asset’s unique ID within the Goldfinch protocol.
`in_assetAAmount`	`STRING`	Amount of asset A being swapped in the transaction, denominated in the asset’s smallest unit. Values typically range from hundreds of millions, representing token quantities with decimal precision already factored in.
`in_assetBId`	`STRING`	Identifier of the asset being received (Asset B) in the swap within the Goldfinch Advisor rebalancing system. Numeric string representing the internal asset ID being acquired by the destination portfolio.
`in_assetBAmount`	`STRING`	Quantity of asset B exchanged in the swap transaction, denominated in the asset’s smallest unit. Values typically range from hundreds of millions of base units (e.g., 150000000, 834000000).

Sample Data

address	removed	log_index	in_assetAId	in_assetBId	block_number	in_rebalanceId	block_timestamp	in_assetAAmount	in_assetBAmount	in_portfolioBId	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	183	510	450	12142081	0x3078303138653633626262666430000000000000000000000000000000000000	2024-03-22T02:11:49.000Z	150000001	150000001	38	0x82b47d5b1abffa9e9bfbc83a54c0bf9fd558ad354d87c5bc82c483b2ea17da0f
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	170	508	448	12142081	0x3078303138653633626262666430000000000000000000000000000000000000	2024-03-22T02:11:49.000Z	150000000	150000000	38	0x82b47d5b1abffa9e9bfbc83a54c0bf9fd558ad354d87c5bc82c483b2ea17da0f
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	157	506	446	12142081	0x3078303138653633626262666430000000000000000000000000000000000000	2024-03-22T02:11:49.000Z	150000000	150000000	38	0x82b47d5b1abffa9e9bfbc83a54c0bf9fd558ad354d87c5bc82c483b2ea17da0f

Example Query

Query with partition filter

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

Advisor_DebtAdded_event

No description available.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_portfolioOwedToId`	`STRING`	-
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Advisor_DebtPaid_event

No description available.

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_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_portfolioPaidToId`	`STRING`	-
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Advisor_DepositInLoanExecuted_event

No description available.

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_rebalanceId`	`STRING`	Unique identifier for the rebalancing operation. 66-character hex string including 0x prefix.
`in_fromPortfolioId`	`STRING`	-
`in_intoLoan`	`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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Advisor_FeesClaimed_event

Fee claim events from Goldfinch V3 protocol advisors on Base, recording withdrawal amounts and claiming addresses. Used for tracking advisor compensation and protocol fee distribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_by`	`STRING`	Address that initiated the transaction or 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

in_by	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x8c1a49346dd6d6225fc3c492bc046527cedd8238	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	9964919918	312	23588103	2024-12-12T01:05:53.000Z	0x41d6fc428a3d33de150c5188d068b7e7cb8d661fdcf1720233657c13ff6e1a8e

Example Query

Query with partition filter

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

Advisor_PortfolioDeposited_event

Deposit events from Goldfinch v3 Advisor contract on Base, recording capital allocations to investment portfolios with unique portfolio IDs and deposit amounts (in USDC 6-decimal format). Used for tracking portfolio funding activity and capital deployment across Goldfinch’s credit 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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	100000000	12	10611533	19	2024-02-15T15:53:33.000Z	0x541cb1501133fcf73006f1d559f694588c590b9ddd10fb1ed9ff08fae5b73a22
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	2935000000	7	10619421	20	2024-02-15T20:16:29.000Z	0x01d4d78b97b0a1e2a50d913f7c7da4cd421e65cd52dbe42c3e9a16e2bd6d0866
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	500000000	21	10626071	21	2024-02-15T23:58:09.000Z	0x92b4a94c80de943596414682a385d45e6b0c37b3f95e0410388855f78f2358ac

Example Query

Query with partition filter

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

Advisor_PortfolioFeeCharged_event

Portfolio management fees charged by advisors in Goldfinch V3 protocol on Base, grouped by fee batch and portfolio identifier. Used for tracking advisor compensation and analyzing fee structures across lending portfolios.

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_feeBatchId`	`STRING`	Unique identifier for a batch of fees charged across multiple portfolios in a single transaction. Hex-encoded 32-byte hash that groups related fee events together.
`in_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_feeBatchId	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	66640	261	16933673	0x3789a0c14bb4fe409dd25a0c0af6487a42b037cde83745d855d3dbefa1b0ac11	49	2024-07-11T00:11:33.000Z	0xfc6ddd8a6f527d3e9080c7b0863a01890f9c5b830dc632fca8a71bd75c9ae068
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	72193	219	16933673	0x3789a0c14bb4fe409dd25a0c0af6487a42b037cde83745d855d3dbefa1b0ac11	48	2024-07-11T00:11:33.000Z	0xfc6ddd8a6f527d3e9080c7b0863a01890f9c5b830dc632fca8a71bd75c9ae068
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	116620	231	16933673	0x3789a0c14bb4fe409dd25a0c0af6487a42b037cde83745d855d3dbefa1b0ac11	1	2024-07-11T00:11:33.000Z	0xfc6ddd8a6f527d3e9080c7b0863a01890f9c5b830dc632fca8a71bd75c9ae068

Example Query

Query with partition filter

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

Advisor_PortfolioFeesTaken_event

Advisory fee collection events from Goldfinch v3 protocol on Base, recording amounts extracted from lending portfolios. Used for tracking advisor compensation and portfolio-level fee analysis across the platform’s credit 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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	13596	163	17149131	51	2024-07-15T23:53:29.000Z	0x33eb53967134b7d8cdb4375e05ba554183be1e63da5d215f5cff0a4af9716fe8
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	22697	208	17149131	22	2024-07-15T23:53:29.000Z	0x33eb53967134b7d8cdb4375e05ba554183be1e63da5d215f5cff0a4af9716fe8
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	22697	172	17149131	32	2024-07-15T23:53:29.000Z	0x33eb53967134b7d8cdb4375e05ba554183be1e63da5d215f5cff0a4af9716fe8

Example Query

Query with partition filter

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

Advisor_PortfolioInvestableCashDeposited_event

Cash deposit events into Goldfinch investment portfolios on Base, tracking the amount and portfolio ID for each deposit transaction. Used for monitoring capital inflows and portfolio funding activity in the Goldfinch credit 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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	10000000	98	13949967	7	2024-05-02T22:34:41.000Z	0x0aabeda5d1fd8d4895b6b26e3a1faf0f9752b4dbe4da685a3d33097e8e1515aa
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	10000000	109	13941260	7	2024-05-02T17:44:27.000Z	0xfb7805bc0691faae01d75b4d93d4ba79e656f14ec5b7e1eefef01f95ad0c07b1
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	580670000	95	13940305	33	2024-05-02T17:12:37.000Z	0xaf9b04f1000aab1691c1ff294f21c43d8769724da60f6a58f2fd1c2246abff8d

Example Query

Query with partition filter

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

Advisor_PortfolioInvestableCashWithdrawn_event

Cash withdrawal events from Goldfinch Advisor portfolios on Base, tracking amounts removed from investable capital pools. Used for monitoring portfolio liquidity management and capital allocation changes across lending portfolios.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	20000000	63	10664329	19	2024-02-16T21:13:25.000Z	0x02b3352646a2b5397918ec89a2591c12c6088489f4ff7f1550f9209b27bc5fb0
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	40000000	50	10664329	19	2024-02-16T21:13:25.000Z	0x02b3352646a2b5397918ec89a2591c12c6088489f4ff7f1550f9209b27bc5fb0
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	40000000	37	10664329	19	2024-02-16T21:13:25.000Z	0x02b3352646a2b5397918ec89a2591c12c6088489f4ff7f1550f9209b27bc5fb0

Example Query

Query with partition filter

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

Advisor_PortfolioIsReinvestingInterestUpdated_event

Event log tracking changes to interest reinvestment settings for portfolios in Goldfinch v3 Advisor contract on Base. Records when portfolio holders toggle automatic interest compounding on or off for specific portfolio IDs.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_isReinvestingInterest`	`BOOL`	Boolean flag indicating whether interest earned on the specified portfolio is being automatically reinvested. Toggles between true (reinvesting) and false (not reinvesting) as portfolio settings are updated.

Sample Data

address	removed	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash	in_isReinvestingInterest
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	6	19146592	67	2024-08-31T05:35:31.000Z	0x3302620d27833c85ef5110a4964bd74bb7f3ec42c88eea087fe27e807d8dacdb	false
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	149	19164165	67	2024-08-31T15:21:17.000Z	0x1f0840cd869b67db6a7245420510e0981d3f0ade86f529fd723bf61135b0f9f5	true
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	89	21321463	89	2024-10-20T13:51:13.000Z	0xd3b988bb8a1efa092921771fee3e4c3f27f41f4a1f52f292190a76cfe7b99e99	false

Example Query

Query with partition filter

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

Advisor_PortfolioIsReinvestingPrincipalUpdated_event

Portfolio principal reinvestment configuration events from Goldfinch Advisor contract on Base, tracking when portfolio managers toggle automatic principal reinvestment on or off. Used for analyzing yield optimization strategies and portfolio management 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.
`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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_isReinvestingPrincipal`	`BOOL`	Indicates whether the portfolio is configured to automatically reinvest principal repayments into new loans. Boolean flag that tracks the reinvestment strategy setting for the specified portfolio ID.

Sample Data

address	removed	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash	in_isReinvestingPrincipal
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	81	18400642	17	2024-08-13T23:10:31.000Z	0x28d1869a9285eeaf9e6ad98bebb149eb493ed352a8f928ab682f91b5aa33e4ec	false
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	80	18400655	17	2024-08-13T23:10:57.000Z	0x01aaa973b988d98a7593f1242c652aba744fc4be9fe5d9ecc9f424a9d3cd438b	true
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	157	18402020	17	2024-08-13T23:56:27.000Z	0x0e61182fe226a588b125a791a1a84ac79392763ac4af38506a1346a070fd660f	true

Example Query

Query with partition filter

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

Advisor_PortfolioNonInvestableCashDeposited_event

Cash deposit events for non-investable reserves in Goldfinch v3 portfolios on Base. Tracks when funds are allocated to portfolio cash positions that are held outside of active lending pools, useful for analyzing portfolio liquidity management and reserve strategies.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	1050222	494	21126164	70	2024-10-16T01:21:15.000Z	0xaba384fce4e348239bf432e7f7fc80ffcaa519eff1bad661d4b7179313e0bb43
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	1050001	509	21126164	70	2024-10-16T01:21:15.000Z	0xaba384fce4e348239bf432e7f7fc80ffcaa519eff1bad661d4b7179313e0bb43
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	1050000	489	21126164	70	2024-10-16T01:21:15.000Z	0xaba384fce4e348239bf432e7f7fc80ffcaa519eff1bad661d4b7179313e0bb43

Example Query

Query with partition filter

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

Advisor_PortfolioNonInvestableCashWithdrawn_event

Cash withdrawal events from non-investable portfolio balances in Goldfinch’s Advisor contract on Base. Tracks portfolio-specific withdrawals with amounts (in base units) for monitoring portfolio liquidity management and advisor cash flow operations.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	1	10198293	2	2024-02-06T02:18:53.000Z	0x012820d71faff60d0c0b6591520c3c999b17e94191e9ff004d91de21e4668fb6
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	1	10198347	3	2024-02-06T02:20:41.000Z	0xcf78929d1b25969ea8d57a51d3d3db1457dcec5acd96a465cea425a88a55e2db
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	1	10198213	1	2024-02-06T02:16:13.000Z	0xa6f0bff8cf1ad1e8f3d5726fa3e29aeae00a1ae53712314c27cbe85133d14cd8

Example Query

Query with partition filter

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

Advisor_PortfolioPoolTokenDeposited_event

Events tracking when pool tokens are deposited into portfolios within Goldfinch’s Advisor contract on Base. Used to analyze portfolio composition changes and token management activity across Goldfinch 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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

address	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	26	261	10876976	2024-02-21T19:21:39.000Z	0x0afb0bcee97e6416ab2c11c405f871c2ba27b303d1a1f155b5d3fdf02df042bb
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	52	265	10876976	2024-02-21T19:21:39.000Z	0x0afb0bcee97e6416ab2c11c405f871c2ba27b303d1a1f155b5d3fdf02df042bb
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	39	263	10876976	2024-02-21T19:21:39.000Z	0x0afb0bcee97e6416ab2c11c405f871c2ba27b303d1a1f155b5d3fdf02df042bb

Example Query

Query with partition filter

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

Advisor_PortfolioPoolTokenWithdrawn_event

Portfolio pool token withdrawal events from Goldfinch’s Advisor contract on Base, tracking when pool tokens (NFTs) are removed from managed portfolios. Used to analyze portfolio rebalancing activity and token movement between different portfolio strategies.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

address	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	54	16	9756182	2024-01-26T20:41:51.000Z	0x1ed66a0acb82a330cb68486a1ac434e784fa3e6c502d8973a899103a4d777393
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	41	14	9756182	2024-01-26T20:41:51.000Z	0x1ed66a0acb82a330cb68486a1ac434e784fa3e6c502d8973a899103a4d777393
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	26	18	9760950	2024-01-26T23:20:47.000Z	0x269a76103b297bfa45588e5d37eefbdb9639315b263370cd13f00a641f610924

Example Query

Query with partition filter

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

Advisor_PortfolioWithdrawn_event

Withdrawal events from Goldfinch v3 Advisor contract portfolios on Base, capturing amount and portfolio ID for each withdrawal transaction. Enables tracking of capital outflows and portfolio liquidation activity across different Goldfinch lending portfolios.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	in_portfolioId	block_timestamp	transaction_hash
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	20041472	3	10198213	1	2024-02-06T02:16:13.000Z	0xa6f0bff8cf1ad1e8f3d5726fa3e29aeae00a1ae53712314c27cbe85133d14cd8
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	11228094	3	10198347	3	2024-02-06T02:20:41.000Z	0xcf78929d1b25969ea8d57a51d3d3db1457dcec5acd96a465cea425a88a55e2db
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	10000000	3	10198293	2	2024-02-06T02:18:53.000Z	0x012820d71faff60d0c0b6591520c3c999b17e94191e9ff004d91de21e4668fb6

Example Query

Query with partition filter

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

Advisor_rebalance_function

Portfolio rebalancing transactions from Goldfinch v3 Advisor contract on Base, recording swaps between stable and asset portfolios with token amounts and portfolio identifiers. Used for analyzing automated portfolio management and capital allocation across Goldfinch 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.
`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_rebalanceId`	`STRING`	Unique identifier for the rebalancing operation. 66-character hex string including 0x prefix.
`in_stableForAssetSwaps`	`ARRAY<STRUCT<stablePortfolioId STRING, assetPortfolioId STRING, tokenId STRING, amount STRING>>`	Array of swap operations exchanging stablecoin positions for asset positions within the Goldfinch protocol’s rebalancing mechanism. Each swap specifies token ID, amount, and source/destination portfolio IDs for the transaction.
`in_deposits`	`ARRAY<STRUCT<fromPortfolioId STRING, loan STRING, tranche STRING, amount STRING>>`	Array of deposit operations included in this rebalance transaction. Empty arrays indicate rebalances that only involved swaps between existing portfolio positions without new capital deposits.
`in_assetForAssetSwaps`	`ARRAY<STRUCT<portfolioAId STRING, assetAId STRING, portfolioBId STRING, assetBId STRING, amount STRING>>`	Array of asset-to-asset swap operations executed during portfolio rebalancing, containing tokenId and portfolio identifiers. Typically empty, indicating stablecoin swaps are more common in Goldfinch v3 rebalancing operations.

Sample Data

gas	status	gas_used	signature	to_address	in_deposits	block_number	from_address	in_rebalanceId	block_timestamp	transaction_hash	in_assetForAssetSwaps	in_stableForAssetSwaps
4177709	true	1746196	0xa474b76e	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	[]	9762168	0xedb36057118792c29593ed3a3610e1a5c3164289	0x00000000000000000000000000000000000000000000000000000f84d22365cd	2024-01-27T00:01:23.000Z	0xdd1f7c6faf27bf4331a22a04944e4341de7f904af8942c22b38e9d1f9e7e523c	[]	[{“amount”:“2333328”,“tokenId”:“27”,“assetPortfolioId”:“3”,“stablePortfolioId”:“0”},{“amount”:“1333327”,“tokenId”:“30”,“assetPortfolioId”:“0”,“stablePortfolioId”:“3”},{“amount”:“1000015”,“tokenId”:“33”,“assetPortfolioId”:“0”,“stablePortfolioId”:“3”}]
3257392	true	1359656	0xa474b76e	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	[]	9762179	0xedb36057118792c29593ed3a3610e1a5c3164289	0x00000000000000000000000000000000000000000000000000000f84d22365cb	2024-01-27T00:01:45.000Z	0x49939d36ea79a999ee641fe656405833d2f44cbd667e4a7360d32c34da408e8c	[]	[{“amount”:“500000”,“tokenId”:“19”,“assetPortfolioId”:“1”,“stablePortfolioId”:“0”},{“amount”:“833327”,“tokenId”:“22”,“assetPortfolioId”:“1”,“stablePortfolioId”:“0”},{“amount”:“1666666”,“tokenId”:“26”,“assetPortfolioId”:“0”,“stablePortfolioId”:“1”},{“amount”:“666662”,“tokenId”:“35”,“assetPortfolioId”:“0”,“stablePortfolioId”:“1”}]
4390653	true	1835449	0xa474b76e	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	[]	10065454	0xedb36057118792c29593ed3a3610e1a5c3164289	0x00000000000000000000000000000000000000000000000000000f863b98659e	2024-02-03T00:30:55.000Z	0x4d300ee15ba85fbb15d64641ebc4a2f5b41c3c1c305ab58b55e737f35c3890bd	[]	[{“amount”:“1333334”,“tokenId”:“40”,“assetPortfolioId”:“0”,“stablePortfolioId”:“4”},{“amount”:“833327”,“tokenId”:“46”,“assetPortfolioId”:“0”,“stablePortfolioId”:“4”},{“amount”:“500006”,“tokenId”:“55”,“assetPortfolioId”:“0”,“stablePortfolioId”:“4”},{“amount”:“1333333”,“tokenId”:“83”,“assetPortfolioId”:“0”,“stablePortfolioId”:“4”}]

Example Query

Query with partition filter

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

Advisor_RedemptionCredited_event

RedemptionCredited events from Goldfinch V3 Advisor contract on Base, recording principal and interest amounts credited to portfolio token holders upon loan redemptions. Used for tracking portfolio returns and token holder distributions across different portfolio IDs.

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_portfolioId`	`STRING`	Unique identifier for a portfolio within the Goldfinch Advisor contract. Numeric string representation.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`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_interestAmount`	`STRING`	Amount of interest credited to the token holder during this redemption event, denominated in the smallest unit of the relevant token. Values are stored as strings to preserve precision for large token amounts.

Sample Data

address	removed	log_index	in_tokenId	block_number	in_portfolioId	block_timestamp	transaction_hash	in_interestAmount	in_principalAmount
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	17	32	9761408	3	2024-01-26T23:36:03.000Z	0x1a86a136069470c27ffe77190308ae66d15627614e334bf544c5e069a7db5ba9	14	0
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	47	1892	15072916	0	2024-05-28T22:26:19.000Z	0xe306f6a3c201776cc03a7fb27314ae5f3adc0efe9c168160fa8c04d7dde6c491	340690003	58404000000
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	141	1155	15072949	1	2024-05-28T22:27:25.000Z	0xf2b6f16181fd8bfd3886cad766b7d053ff952ec9f32ba6d123ec0f2a554f047a	81667	14000000

Example Query

Query with partition filter

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

Advisor_StableToAssetSwapExecuted_event

Portfolio rebalancing events from Goldfinch v3 protocol on Base where stablecoins are swapped into asset tokens. Tracks swap amounts, portfolio identifiers, and token IDs for analyzing Advisor contract rebalancing operations.

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_rebalanceId`	`STRING`	Unique identifier for the rebalancing operation. 66-character hex string including 0x prefix.
`in_stablePortfolioId`	`STRING`	Portfolio identifier for the stablecoin side of the swap transaction in Goldfinch’s portfolio management system. Represents which stablecoin portfolio is involved in the rebalancing operation.
`in_assetPortfolioId`	`STRING`	Portfolio identifier for the asset side of the rebalancing swap in the Goldfinch Advisor contract. Always ‘0’ in the sample data, indicating a default or primary asset portfolio.
`in_stableAmount`	`STRING`	Amount of stablecoin swapped in the rebalancing operation, denominated in the token’s smallest unit. Based on sample values, typically represents amounts in the hundreds of millions of base units (e.g., USDC wei).
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_assetAmount`	`STRING`	Amount of asset tokens involved in the operation. Integer value representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in_tokenId	block_number	in_assetAmount	in_rebalanceId	block_timestamp	in_stableAmount	transaction_hash	in_stablePortfolioId
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	96	259	10876998	166000000	0x00000000000000000000000000000000000000000000000000009b6301dbfed9	2024-02-21T19:22:23.000Z	166000000	0xbc23798137ceda984b8661c04862e07b2c854367e5ec596e448e2576e15c63e6	25
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	70	255	10876998	166000000	0x00000000000000000000000000000000000000000000000000009b6301dbfed9	2024-02-21T19:22:23.000Z	166000000	0xbc23798137ceda984b8661c04862e07b2c854367e5ec596e448e2576e15c63e6	25
0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	false	83	257	10876998	167000000	0x00000000000000000000000000000000000000000000000000009b6301dbfed9	2024-02-21T19:22:23.000Z	167000000	0xbc23798137ceda984b8661c04862e07b2c854367e5ec596e448e2576e15c63e6	25

Example Query

Query with partition filter

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

Factory_BeaconCreated_event

No description available.

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_beacon`	`STRING`	Contract address of the beacon proxy implementation contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Factory_CallableLoanCreated_event

No description available.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Factory_createCallableLoan_function

No description available.

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__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__limit`	`STRING`	-
`in__interestApr`	`STRING`	-
`in__numLockupPeriods`	`STRING`	-
`in__schedule`	`STRING`	-
`in__lateFeeApr`	`STRING`	-
`in__fundableAt`	`STRING`	-
`in__allowedUIDTypes`	`ARRAY<STRING>`	Array of unique identifier type codes permitted for accessing or participating in the loan or pool. String elements representing numeric type identifiers.
`out_loan`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Factory_createPool_function

Function call data for liquidity pool creation through factory contracts, including token pair addresses, fee tiers, and the resulting pool address. Used for tracking DEX (Decentralized Exchange) pool deployments and factory contract interactions.

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__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__juniorFeePercent`	`STRING`	Percentage fee allocated to junior tranche investors in the pool’s waterfall structure, expressed in basis points. Commonly set to 0, indicating no junior fee or default configuration.
`in__limit`	`STRING`	Maximum borrowing capacity for the pool in USDC base units (6 decimals). Typical values range from 100M to 350B base units, representing $100 to$ 350,000 loan limits.
`in__interestApr`	`STRING`	Annual percentage rate (APR) for interest on the borrowing pool, encoded as a string representing basis points with 18 decimals (e.g., ‘3650000000000000000’ = 3.65% APR). Values typically range from ~14% to ~365% based on sample pool configurations.
`in__schedule`	`STRING`	Contract address of the repayment schedule configuration for the borrower pool. Hex-encoded, 0x-prefixed 40-character address defining payment terms and timing for the loan.
`in__lateFeeApr`	`STRING`	Late fee annual percentage rate (APR) for the pool expressed in 18-decimal precision. Typically zero, indicating no late fees charged on overdue payments.
`in__fundableAt`	`STRING`	Unix timestamp (in seconds) when the pool becomes available for funding. Typically set to ‘0’ to enable immediate funding upon pool creation.
`in__allowedUIDTypes`	`ARRAY<STRING>`	Array of unique identifier type codes permitted for accessing or participating in the loan or pool. String elements representing numeric type identifiers.
`in__originationFees`	`STRUCT<originator STRING, feeInBps STRING>`	Structured data containing origination fee parameters for the pool, including fee rate in basis points and the originator’s address. Typically zero fees with null address in sample data.
`out_pool`	`STRING`	Contract address of the newly created Goldfinch borrower pool on Base chain. Hex-encoded, 0x-prefixed 40-character string representing the pool deployment address.

Sample Data

gas	status	gas_used	out_pool	in__limit	signature	to_address	block_number	from_address	in__borrower	in__schedule	trace_address	block_timestamp	in__interestApr	transaction_hash	in__allowedUIDTypes	in__originationFees
4314401	true	1185072	0xd30b83ef8004860a91084d67cbd14b84d906e07f	100000000	0x0771b68e	0x2eb556087beb4f25d77222002cbe96cb0fac7e67	9760621	0xa3f4318f9220c796495b9aa4ed1e525b180a5cba	0x46cc6418bf12933e4afcf95ae255e8249fffd0d9	0xa7da355994cf22541d3c76738b290f80bdbd0601	0,3,0	2024-01-26T23:09:49.000Z	3650000000000000000	0xa0167af1db4852072dbc5edc16bced2fc6c4c1f3582dd390161775af74ae5d18	[“1”]	{“feeInBps”:“0”,“originator”:“0x0000000000000000000000000000000000000000”}
7415320	false	1132303	0x64e9f5c3f788d4d6bd5612cee0d04c5845448917	150000000000	0x0771b68e	0x2eb556087beb4f25d77222002cbe96cb0fac7e67	10191729	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x71fb757bd053b7cddfc3740573e925371ed9b2ef	0,2,8	2024-02-05T22:40:05.000Z	141944183000000000	0x37c6cb8b2fccb29089a61183823e0ee87bf0951dcf04113d42de2bb6b1495573	[“1”]	{“feeInBps”:“0”,“originator”:“0x0000000000000000000000000000000000000000”}
20387729	true	1132303	0x64e9f5c3f788d4d6bd5612cee0d04c5845448917	150000000000	0x0771b68e	0x2eb556087beb4f25d77222002cbe96cb0fac7e67	10191804	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x71fb757bd053b7cddfc3740573e925371ed9b2ef	0,2,8	2024-02-05T22:42:35.000Z	141944183000000000	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32	[“1”]	{“feeInBps”:“0”,“originator”:“0x0000000000000000000000000000000000000000”}

Example Query

Query with partition filter

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

Factory_CreditLineCreated_event

Credit line creation events from Goldfinch v3 protocol factory contract on Base. Tracks deployment of new credit line contracts with their addresses for monitoring borrower onboarding and lending pool expansion.

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_creditLine`	`STRING`	Contract address of the newly created credit line in the Goldfinch protocol. Hex-encoded, 0x-prefixed 40-character string representing the deployed credit line contract on Base chain.

Sample Data

address	removed	log_index	block_number	in_creditLine	block_timestamp	transaction_hash
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	false	7	9718734	0x80bf78bfe32c0eaf1e375467820f6214d12f7bd5	2024-01-25T23:53:35.000Z	0xc4c333396ae9e8e268cac7d6a0900cc8c7ed994a7a53278f6a80465956987f5d
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	false	23	9669574	0x22d93b18667cccc273a0ef3277b3e206de08b972	2024-01-24T20:34:55.000Z	0x72c6b8fdd76eb8f350ef5dcd8f692dfabab752793b5502a0c2fdc45daf1ed52d
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	false	42	10191804	0xdb5795eb5651085c88cb146ca0d8f945585f59cf	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32

Example Query

Query with partition filter

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

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0x239865a20edb50f356fdcc798575975e584817ef	false	52	0x9817fb8db3c1f65feaa07a297dc37580ed588183	10191804	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0x77e91f120d97a5c26dfca7ca96e9228e820b1041	false	100	0x9817fb8db3c1f65feaa07a297dc37580ed588183	10191804	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0xb035b0265ead08013117977ee843700d7bc5c0c7	false	124	0x9817fb8db3c1f65feaa07a297dc37580ed588183	10191804	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32

Example Query

Query with partition filter

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

PoolTokens_TokenBurned_event

Token burn events from Goldfinch V3 lending pools on Base, recording when liquidity provider NFT positions are destroyed. Tracks pool participation withdrawals with owner addresses and token IDs for analyzing lender exit 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

address	in_pool	removed	in_owner	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x5883b5a4c1d209d532523ae71e79122d3edc862f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	9	22	9762179	2024-01-27T00:01:45.000Z	0x49939d36ea79a999ee641fe656405833d2f44cbd667e4a7360d32c34da408e8c
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x16e6fb81c8b0b33cd64472d4e4e0dd79a831f1a4	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	27	35	9762179	2024-01-27T00:01:45.000Z	0x49939d36ea79a999ee641fe656405833d2f44cbd667e4a7360d32c34da408e8c
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x16e6fb81c8b0b33cd64472d4e4e0dd79a831f1a4	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	9	27	9762168	2024-01-27T00:01:23.000Z	0xdd1f7c6faf27bf4331a22a04944e4341de7f904af8942c22b38e9d1f9e7e523c

Example Query

Query with partition filter

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

PoolTokens_TokenMinted_event

Token minting events from Goldfinch V3 lending pools on Base, recording when liquidity providers receive pool tokens representing their tranche positions. Used for tracking capital deployment and LP token issuance across junior and senior tranches.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.

Sample Data

address	in_pool	removed	in_owner	in_amount	log_index	in_tokenId	in_tranche	block_number	block_timestamp	transaction_hash
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x5883b5a4c1d209d532523ae71e79122d3edc862f	false	0xa3f4318f9220c796495b9aa4ed1e525b180a5cba	100000000	19	6	2	9718734	2024-01-25T23:53:35.000Z	0xc4c333396ae9e8e268cac7d6a0900cc8c7ed994a7a53278f6a80465956987f5d
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x5883b5a4c1d209d532523ae71e79122d3edc862f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	91500000	24	10	2	9718916	2024-01-25T23:59:39.000Z	0xd632ad39614940b2a83cbd870d8a8e1c6c790760d5a75db9ea7f9ed3d2567675
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x16e6fb81c8b0b33cd64472d4e4e0dd79a831f1a4	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	91500000	11	8	2	9718916	2024-01-25T23:59:39.000Z	0xd632ad39614940b2a83cbd870d8a8e1c6c790760d5a75db9ea7f9ed3d2567675

Example Query

Query with partition filter

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

PoolTokens_TokenPrincipalWithdrawn_event

No description available.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_principalWithdrawn`	`STRING`	-
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

PoolTokens_TokenRedeemed_event

Token redemption events from Goldfinch V3 lending pools on Base, recording when liquidity providers withdraw principal and interest from pool tranches. Tracks withdrawal amounts by pool, token ID, and tranche for analyzing lender behavior and pool liquidity.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_principalRedeemed`	`STRING`	Amount of principal redeemed from the Goldfinch pool token, denominated in the smallest unit of the underlying asset (typically USDC with 6 decimals). This represents the original investment amount being withdrawn by the token owner.
`in_interestRedeemed`	`STRING`	Amount of accrued interest withdrawn by the token holder when redeeming their Goldfinch pool token, denominated in the smallest unit of the pool’s underlying asset (typically USDC with 6 decimals). Values range from small amounts like 20 to over 100,000 units.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.

Sample Data

address	in_pool	removed	in_owner	log_index	in_tokenId	in_tranche	block_number	block_timestamp	transaction_hash	in_interestRedeemed	in_principalRedeemed
0x4cdb2b3358add8bd125855da9e52317352ba25de	0xd30b83ef8004860a91084d67cbd14b84d906e07f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	44	32	2	10058865	2024-02-02T20:51:17.000Z	0xd012b13bb00c8fabc17a3fdb08eee8cc54b8edbfe0c992704d874b95fd67771f	62163	500929
0x4cdb2b3358add8bd125855da9e52317352ba25de	0xd30b83ef8004860a91084d67cbd14b84d906e07f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	23	32	2	10059318	2024-02-02T21:06:23.000Z	0x60b2010c798bc13f869ddba57ea2239f0d69eda08c08976859fc9c80809301e2	30	499072
0x4cdb2b3358add8bd125855da9e52317352ba25de	0xd30b83ef8004860a91084d67cbd14b84d906e07f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	17	44	2	10058859	2024-02-02T20:51:05.000Z	0x834996f69b3a72926732335e55402a45e7d0a99e7950ae8bbfb307446c76255b	62178	500936

Example Query

Query with partition filter

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

PoolTokens_TokenSplit_event

TokenSplit events from Goldfinch v3 lending pools on Base, tracking when pool token positions are divided into two new tokens with split principal amounts. Used for analyzing liquidity provider position management and token rebalancing 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_newTokenId1`	`STRING`	Token identifier for the first newly created pool token resulting from the split operation. Sequential numeric ID issued by the Goldfinch PoolTokens contract when an existing position is divided.
`in_newPrincipal1`	`STRING`	Principal amount allocated to the first newly created pool token after the split operation. Denominated in the smallest unit of the pool’s underlying currency (typically USDC with 6 decimals).
`in_newTokenId2`	`STRING`	Token identifier (NFT) created for the second position after splitting the original pool token. Each split generates two new token IDs representing proportional ownership stakes in the lending pool.
`in_newPrincipal2`	`STRING`	Principal amount allocated to the second newly created pool token after the split. Denominated in the smallest unit of the pool’s underlying currency (typically USDC with 6 decimals).

Sample Data

address	in_pool	removed	in_owner	log_index	in_tokenId	block_number	in_newTokenId1	in_newTokenId2	block_timestamp	in_newPrincipal1	in_newPrincipal2	transaction_hash
0x4cdb2b3358add8bd125855da9e52317352ba25de	0xd30b83ef8004860a91084d67cbd14b84d906e07f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	45	65	10062767	70	71	2024-02-02T23:01:21.000Z	887851	94112133	0x21b88b08c053fe134df2bec2109958ff3e433781924d0d78936ad59b919373d0
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x16e6fb81c8b0b33cd64472d4e4e0dd79a831f1a4	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	19	7	10062767	66	67	2024-02-02T23:01:21.000Z	89852	1410148	0x21b88b08c053fe134df2bec2109958ff3e433781924d0d78936ad59b919373d0
0x4cdb2b3358add8bd125855da9e52317352ba25de	0x5883b5a4c1d209d532523ae71e79122d3edc862f	false	0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c	32	23	10062767	68	69	2024-02-02T23:01:21.000Z	89851	6743482	0x21b88b08c053fe134df2bec2109958ff3e433781924d0d78936ad59b919373d0

Example Query

Query with partition filter

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

SimpleLoan_AccountingSnapshotPopped_event

No description available.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_cumulativeInterestOwed`	`STRING`	-
`in_cumulativePrincipalOwed`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoan_AccountingSnapshotPushed_event

No description available.

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_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
`in_cumulativeInterestOwed`	`STRING`	-
`in_cumulativePrincipalOwed`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoan_initialize_function

No description available.

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__config`	`STRING`	-
`in__contractOwner`	`STRING`	-
`in__allowedUIDTypes`	`ARRAY<STRING>`	Array of unique identifier type codes permitted for accessing or participating in the loan or pool. String elements representing numeric type identifiers.
`in__lender`	`STRING`	-
`in__totalPrincipalDeposited`	`STRING`	-
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoan_pay_function

No description available.

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_interestPayment`	`STRING`	-
`in_principalPayment`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoan_PaymentMade_event

No description available.

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_interest`	`STRING`	Interest amount accrued or paid in the transaction. Numeric string representation in the smallest unit of the relevant token.
`in_principal`	`STRING`	Principal amount borrowed, repaid, or withdrawn in the transaction. Numeric string representation in the smallest unit of the relevant token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoan_WithdrawalMade_event

No description available.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_interest`	`STRING`	Interest amount accrued or paid in the transaction. Numeric string representation in the smallest unit of the relevant token.
`in_principal`	`STRING`	Principal amount borrowed, repaid, or withdrawn in the transaction. Numeric string representation in the smallest unit of the relevant token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoanFactory_BeaconCreated_event

No description available.

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_beacon`	`STRING`	Contract address of the beacon proxy implementation contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoanFactory_CallableLoanCreated_event

No description available.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SimpleLoanFactory_CreditLineCreated_event

Event logs capturing credit line creation events from Goldfinch v3 SimpleLoanFactory contract on Base chain. Used to track when new borrower credit facilities are deployed and identify loan origination 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_creditLine`	`STRING`	Contract address of the newly created credit line in the Goldfinch protocol. This hex-encoded address represents the deployed credit line contract instance associated with a borrower’s loan facility.

Sample Data

address	removed	log_index	block_number	in_creditLine	block_timestamp	transaction_hash
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	false	90	10191804	0x6e4d20484620e22f62df6a02d6ec30b86a3d4150	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	false	114	10191804	0x1b7a5c612076cc757896c7fed222f916e5c436f1	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	false	42	10191804	0xdb5795eb5651085c88cb146ca0d8f945585f59cf	2024-02-05T22:42:35.000Z	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32

Example Query

Query with partition filter

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

SimpleLoanFactory_PoolCreated_event

Pool creation events from Goldfinch v3 SimpleLoanFactory contract on Base, linking borrower addresses to their newly deployed loan pool contracts. Used for tracking borrower onboarding and analyzing pool deployment patterns across the Goldfinch credit 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pool	removed	log_index	in_borrower	block_number	block_timestamp	transaction_hash
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0x5883b5a4c1d209d532523ae71e79122d3edc862f	false	17	0x46cc6418bf12933e4afcf95ae255e8249fffd0d9	9718734	2024-01-25T23:53:35.000Z	0xc4c333396ae9e8e268cac7d6a0900cc8c7ed994a7a53278f6a80465956987f5d
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0xd30b83ef8004860a91084d67cbd14b84d906e07f	false	20	0x46cc6418bf12933e4afcf95ae255e8249fffd0d9	9760621	2024-01-26T23:09:49.000Z	0xa0167af1db4852072dbc5edc16bced2fc6c4c1f3582dd390161775af74ae5d18
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0x16e6fb81c8b0b33cd64472d4e4e0dd79a831f1a4	false	33	0x46cc6418bf12933e4afcf95ae255e8249fffd0d9	9669574	2024-01-24T20:34:55.000Z	0x72c6b8fdd76eb8f350ef5dcd8f692dfabab752793b5502a0c2fdc45daf1ed52d

Example Query

Query with partition filter

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

SimpleLoanFactory_SimpleLoanCreated_event

Loan creation events from Goldfinch v3 protocol on Base, recording when new simple loans are originated with lender, loan contract address, and initial principal deposit amounts. Used for tracking lending activity and capital deployment across the 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_loan`	`STRING`	Contract address of the loan being created, claimed, funded, or liquidated. Hex-encoded, 0x-prefixed, 42-character string.
`in_lender`	`STRING`	Address of the lender providing funds in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalPrincipalDeposited`	`STRING`	Total principal amount deposited into the loan at creation time, denominated in the loan’s base token with its native decimal precision. Values are string-encoded integers representing the smallest unit of the token (e.g., USDC with 6 decimals).

Sample Data

address	in_loan	removed	in_lender	log_index	block_number	block_timestamp	transaction_hash	in_totalPrincipalDeposited
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0xe2b14d198c2a3ceca14133012c45f767c41d61ee	false	0x9817fb8db3c1f65feaa07a297dc37580ed588183	104	12140219	2024-03-22T01:09:45.000Z	0xa39c96eae05ea3dac74bdec8dbc63888d670b684d9fc48c7403aedf9791abf46	150000000000
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0xf5f0cfa6db5863c30b1bb094ef441f4b0ccd2dc0	false	0x9817fb8db3c1f65feaa07a297dc37580ed588183	90	12140219	2024-03-22T01:09:45.000Z	0xa39c96eae05ea3dac74bdec8dbc63888d670b684d9fc48c7403aedf9791abf46	250000000000
0x2eb556087beb4f25d77222002cbe96cb0fac7e67	0x9991684b225cf0b2c5b363b59bf56dd23fd980fd	false	0x9817fb8db3c1f65feaa07a297dc37580ed588183	97	12140219	2024-03-22T01:09:45.000Z	0xa39c96eae05ea3dac74bdec8dbc63888d670b684d9fc48c7403aedf9791abf46	250000000000

Example Query

Query with partition filter

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

TranchedPool_CreditLineMigrated_event

No description available.

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_oldCreditLine`	`STRING`	-
`in_newCreditLine`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_DepositMade_event

No description available.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_depositWithPermit_function

No description available.

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_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`in_v`	`INT64`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_s`	`STRING`	ECDSA signature component s used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`out_tokenId`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_DrawdownMade_event

No description available.

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

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_initialize_function

TranchedPool initialization transactions from Goldfinch credit protocol on Base, capturing pool configuration parameters including borrower address, credit limits, interest rates (APR), repayment schedules, and origination fees. Used for analyzing new pool deployments and their structured lending terms.

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__config`	`STRING`	Contract address of the Goldfinch protocol configuration contract being referenced during pool initialization. Hex-encoded, 0x-prefixed 40-character address pointing to the protocol’s core configuration parameters.
`in__borrower`	`STRING`	Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__juniorFeePercent`	`STRING`	Percentage of interest fees allocated to the junior tranche of the Goldfinch lending pool. Represented as a string-encoded integer, commonly 0 in the sample data indicating no junior fee allocation.
`in__limit`	`STRING`	Pool borrowing limit denominated in the smallest unit of the lending token (e.g., USDC with 6 decimals). Sample values range from 150 to 500 billion base units, representing the maximum capital available for this tranched pool.
`in__interestApr`	`STRING`	Annual Percentage Rate (APR) for interest on the tranched pool, encoded as a wei-denominated integer representing the interest rate. Sample values around 140-157 trillion wei correspond to interest rates of approximately 14-15.7% annually.
`in__schedule`	`STRING`	Contract address of the repayment schedule configuration for this Goldfinch tranched pool. Hex-encoded address defining payment timing and structure for the borrowing arrangement.
`in__lateFeeApr`	`STRING`	Late fee annual percentage rate charged on overdue loan payments. Typically 0 or expressed as a high-precision integer representing basis points.
`in__fundableAt`	`STRING`	Timestamp when the tranched pool becomes available for funding by lenders. Typically set to zero for immediate funding eligibility.
`in__allowedUIDTypes`	`ARRAY<STRING>`	Array of unique identifier type codes permitted for accessing or participating in the loan or pool. String elements representing numeric type identifiers.
`in__originationFees`	`STRUCT<originator STRING, feeInBps STRING>`	Origination fee structure applied when the tranched pool is initialized, including fee rate in basis points and originator address. Typically set to zero in sample data, indicating no origination fees charged.

Sample Data

gas	status	gas_used	in__limit	signature	in__config	to_address	block_number	from_address	in__borrower	in__schedule	trace_address	block_timestamp	in__interestApr	transaction_hash	in__allowedUIDTypes	in__originationFees
17731116	true	942935	500000000000	0x3bde8d44	0xac91743f4cfdebc1f7a38ecf38a8cf78ef5355f5	0x23334e85bf9576896039f62568b321118b98fa59	10191804	0x77e91f120d97a5c26dfca7ca96e9228e820b1041	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x1fc10568ee4bfeb0fc63dc9c8338bdd645045319	0,2,12,0,3,1	2024-02-05T22:42:35.000Z	152083333330000000	0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32	[“1”]	{“feeInBps”:“0”,“originator”:“0x0000000000000000000000000000000000000000”}
5357336	false	942935	500000000000	0x3bde8d44	0xac91743f4cfdebc1f7a38ecf38a8cf78ef5355f5	0x23334e85bf9576896039f62568b321118b98fa59	10191729	0x77e91f120d97a5c26dfca7ca96e9228e820b1041	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x1fc10568ee4bfeb0fc63dc9c8338bdd645045319	0,2,12,0,3,1	2024-02-05T22:40:05.000Z	152083333330000000	0x37c6cb8b2fccb29089a61183823e0ee87bf0951dcf04113d42de2bb6b1495573	[“1”]	{“feeInBps”:“0”,“originator”:“0x0000000000000000000000000000000000000000”}
2246423	false	942935	250000000000	0x3bde8d44	0xac91743f4cfdebc1f7a38ecf38a8cf78ef5355f5	0x23334e85bf9576896039f62568b321118b98fa59	10191729	0xa61b41bb3f65c9e11f4b895196afdcdb14ad7556	0x9817fb8db3c1f65feaa07a297dc37580ed588183	0x62d3701e41b4f18705905c53ef36053546b34467	0,2,20,0,3,1	2024-02-05T22:40:05.000Z	157274221000000000	0x37c6cb8b2fccb29089a61183823e0ee87bf0951dcf04113d42de2bb6b1495573	[“1”]	{“feeInBps”:“0”,“originator”:“0x0000000000000000000000000000000000000000”}

Example Query

Query with partition filter

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

TranchedPool_OriginationFeeCharged_event

No description available.

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_originator`	`STRING`	-
`in_feeCharged`	`STRING`	-
`in_feeInBps`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_PaymentApplied_event

No description available.

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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_interest`	`STRING`	Interest amount accrued or paid in the transaction. Numeric string representation in the smallest unit of the relevant token.
`in_principal`	`STRING`	Principal amount borrowed, repaid, or withdrawn in the transaction. Numeric string representation in the smallest unit of the relevant token.
`in_remaining`	`STRING`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_ReserveFundsCollected_event

No description available.

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_from`	`STRING`	Address originating the transfer or 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

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_TrancheLocked_event

No description available.

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_trancheId`	`STRING`	-
`in_lockedUntil`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_VirtualDepositMade_event

No description available.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_VirtualDrawdownMade_event

No description available.

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

No sample data available.

Example Query

Query with partition filter

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

TranchedPool_WithdrawalMade_event

No description available.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_interestWithdrawn`	`STRING`	-
`in_principalWithdrawn`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​Advisor_AssetToAssetSwapExecuted_event

​Advisor_DebtAdded_event

​Advisor_DebtPaid_event

​Advisor_DepositInLoanExecuted_event

​Advisor_FeesClaimed_event

​Advisor_PortfolioDeposited_event

​Advisor_PortfolioFeeCharged_event

​Advisor_PortfolioFeesTaken_event

​Advisor_PortfolioInvestableCashDeposited_event

​Advisor_PortfolioInvestableCashWithdrawn_event

​Advisor_PortfolioIsReinvestingInterestUpdated_event

​Advisor_PortfolioIsReinvestingPrincipalUpdated_event

​Advisor_PortfolioNonInvestableCashDeposited_event

​Advisor_PortfolioNonInvestableCashWithdrawn_event

​Advisor_PortfolioPoolTokenDeposited_event

​Advisor_PortfolioPoolTokenWithdrawn_event

​Advisor_PortfolioWithdrawn_event

​Advisor_rebalance_function

​Advisor_RedemptionCredited_event

​Advisor_StableToAssetSwapExecuted_event

​Factory_BeaconCreated_event

​Factory_CallableLoanCreated_event

​Factory_createCallableLoan_function

​Factory_createPool_function

​Factory_CreditLineCreated_event

​Factory_PoolCreated_event

​PoolTokens_TokenBurned_event

​PoolTokens_TokenMinted_event

​PoolTokens_TokenPrincipalWithdrawn_event

​PoolTokens_TokenRedeemed_event

​PoolTokens_TokenSplit_event

​SimpleLoan_AccountingSnapshotPopped_event

​SimpleLoan_AccountingSnapshotPushed_event

​SimpleLoan_initialize_function

​SimpleLoan_pay_function

​SimpleLoan_PaymentMade_event

​SimpleLoan_WithdrawalMade_event

​SimpleLoanFactory_BeaconCreated_event

​SimpleLoanFactory_CallableLoanCreated_event

​SimpleLoanFactory_CreditLineCreated_event

​SimpleLoanFactory_PoolCreated_event

​SimpleLoanFactory_SimpleLoanCreated_event

​TranchedPool_CreditLineMigrated_event

​TranchedPool_DepositMade_event

​TranchedPool_depositWithPermit_function

​TranchedPool_DrawdownMade_event

​TranchedPool_initialize_function

​TranchedPool_OriginationFeeCharged_event

​TranchedPool_PaymentApplied_event

​TranchedPool_ReserveFundsCollected_event

​TranchedPool_TrancheLocked_event

​TranchedPool_VirtualDepositMade_event

​TranchedPool_VirtualDrawdownMade_event

​TranchedPool_WithdrawalMade_event

Tables

Advisor_AssetToAssetSwapExecuted_event

Advisor_DebtAdded_event

Advisor_DebtPaid_event

Advisor_DepositInLoanExecuted_event

Advisor_FeesClaimed_event

Advisor_PortfolioDeposited_event

Advisor_PortfolioFeeCharged_event

Advisor_PortfolioFeesTaken_event

Advisor_PortfolioInvestableCashDeposited_event

Advisor_PortfolioInvestableCashWithdrawn_event

Advisor_PortfolioIsReinvestingInterestUpdated_event

Advisor_PortfolioIsReinvestingPrincipalUpdated_event

Advisor_PortfolioNonInvestableCashDeposited_event

Advisor_PortfolioNonInvestableCashWithdrawn_event

Advisor_PortfolioPoolTokenDeposited_event

Advisor_PortfolioPoolTokenWithdrawn_event

Advisor_PortfolioWithdrawn_event

Advisor_rebalance_function

Advisor_RedemptionCredited_event

Advisor_StableToAssetSwapExecuted_event

Factory_BeaconCreated_event

Factory_CallableLoanCreated_event

Factory_createCallableLoan_function

Factory_createPool_function

Factory_CreditLineCreated_event

Factory_PoolCreated_event

PoolTokens_TokenBurned_event

PoolTokens_TokenMinted_event

PoolTokens_TokenPrincipalWithdrawn_event

PoolTokens_TokenRedeemed_event

PoolTokens_TokenSplit_event

SimpleLoan_AccountingSnapshotPopped_event

SimpleLoan_AccountingSnapshotPushed_event

SimpleLoan_initialize_function

SimpleLoan_pay_function

SimpleLoan_PaymentMade_event

SimpleLoan_WithdrawalMade_event

SimpleLoanFactory_BeaconCreated_event

SimpleLoanFactory_CallableLoanCreated_event

SimpleLoanFactory_CreditLineCreated_event

SimpleLoanFactory_PoolCreated_event

SimpleLoanFactory_SimpleLoanCreated_event

TranchedPool_CreditLineMigrated_event

TranchedPool_DepositMade_event

TranchedPool_depositWithPermit_function

TranchedPool_DrawdownMade_event

TranchedPool_initialize_function

TranchedPool_OriginationFeeCharged_event

TranchedPool_PaymentApplied_event

TranchedPool_ReserveFundsCollected_event

TranchedPool_TrancheLocked_event

TranchedPool_VirtualDepositMade_event

TranchedPool_VirtualDrawdownMade_event

TranchedPool_WithdrawalMade_event