> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# goldfinch_v3_base
> Tables in tt-contracts.goldfinch_v3_base
## 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.
| 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). |
| address | removed | log\_index | in\_assetAId | in\_assetBId | block\_number | in\_rebalanceId | block\_timestamp | in\_assetAAmount | in\_assetBAmount | in\_portfolioAId | in\_portfolioBId | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------ | ------------ | ------------- | ------------------------------------------------------------------ | ------------------------ | ---------------- | ---------------- | ---------------- | ---------------- | ------------------------------------------------------------------ |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 183 | 510 | 450 | 12142081 | 0x3078303138653633626262666430000000000000000000000000000000000000 | 2024-03-22T02:11:49.000Z | 150000001 | 150000001 | 0 | 38 | 0x82b47d5b1abffa9e9bfbc83a54c0bf9fd558ad354d87c5bc82c483b2ea17da0f |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 170 | 508 | 448 | 12142081 | 0x3078303138653633626262666430000000000000000000000000000000000000 | 2024-03-22T02:11:49.000Z | 150000000 | 150000000 | 0 | 38 | 0x82b47d5b1abffa9e9bfbc83a54c0bf9fd558ad354d87c5bc82c483b2ea17da0f |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 157 | 506 | 446 | 12142081 | 0x3078303138653633626262666430000000000000000000000000000000000000 | 2024-03-22T02:11:49.000Z | 150000000 | 150000000 | 0 | 38 | 0x82b47d5b1abffa9e9bfbc83a54c0bf9fd558ad354d87c5bc82c483b2ea17da0f |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_amount | log\_index | block\_number | in\_portfolioId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ---------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 0 | 1 | 10198293 | 2 | 2024-02-06T02:18:53.000Z | 0x012820d71faff60d0c0b6591520c3c999b17e94191e9ff004d91de21e4668fb6 |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 0 | 1 | 10198347 | 3 | 2024-02-06T02:20:41.000Z | 0xcf78929d1b25969ea8d57a51d3d3db1457dcec5acd96a465cea425a88a55e2db |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 0 | 1 | 10198213 | 1 | 2024-02-06T02:16:13.000Z | 0xa6f0bff8cf1ad1e8f3d5726fa3e29aeae00a1ae53712314c27cbe85133d14cd8 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | in\_tokenId | block\_number | in\_portfolioId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 26 | 261 | 10876976 | 0 | 2024-02-21T19:21:39.000Z | 0x0afb0bcee97e6416ab2c11c405f871c2ba27b303d1a1f155b5d3fdf02df042bb |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 52 | 265 | 10876976 | 0 | 2024-02-21T19:21:39.000Z | 0x0afb0bcee97e6416ab2c11c405f871c2ba27b303d1a1f155b5d3fdf02df042bb |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 39 | 263 | 10876976 | 0 | 2024-02-21T19:21:39.000Z | 0x0afb0bcee97e6416ab2c11c405f871c2ba27b303d1a1f155b5d3fdf02df042bb |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | in\_tokenId | block\_number | in\_portfolioId | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 54 | 16 | 9756182 | 0 | 2024-01-26T20:41:51.000Z | 0x1ed66a0acb82a330cb68486a1ac434e784fa3e6c502d8973a899103a4d777393 |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 41 | 14 | 9756182 | 0 | 2024-01-26T20:41:51.000Z | 0x1ed66a0acb82a330cb68486a1ac434e784fa3e6c502d8973a899103a4d777393 |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 26 | 18 | 9760950 | 0 | 2024-01-26T23:20:47.000Z | 0x269a76103b297bfa45588e5d37eefbdb9639315b263370cd13f00a641f610924 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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>` | 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>` | 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>` | 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. |
| gas | value | status | gas\_used | signature | to\_address | in\_deposits | block\_number | from\_address | trace\_address | in\_rebalanceId | block\_timestamp | transaction\_hash | in\_assetForAssetSwaps | in\_stableForAssetSwaps |
| ------- | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 4177709 | 0 | true | 1746196 | 0xa474b76e | 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | \[] | 9762168 | 0xedb36057118792c29593ed3a3610e1a5c3164289 | 0,0 | 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 | 0 | true | 1359656 | 0xa474b76e | 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | \[] | 9762179 | 0xedb36057118792c29593ed3a3610e1a5c3164289 | 0,0 | 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 | 0 | true | 1835449 | 0xa474b76e | 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | \[] | 10065454 | 0xedb36057118792c29593ed3a3610e1a5c3164289 | 0,0 | 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"}] |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | log\_index | in\_tokenId | block\_number | in\_assetAmount | in\_rebalanceId | block\_timestamp | in\_stableAmount | transaction\_hash | in\_assetPortfolioId | in\_stablePortfolioId |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | --------------- | ------------------------------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- | --------------------- |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 96 | 259 | 10876998 | 166000000 | 0x00000000000000000000000000000000000000000000000000009b6301dbfed9 | 2024-02-21T19:22:23.000Z | 166000000 | 0xbc23798137ceda984b8661c04862e07b2c854367e5ec596e448e2576e15c63e6 | 0 | 25 |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 70 | 255 | 10876998 | 166000000 | 0x00000000000000000000000000000000000000000000000000009b6301dbfed9 | 2024-02-21T19:22:23.000Z | 166000000 | 0xbc23798137ceda984b8661c04862e07b2c854367e5ec596e448e2576e15c63e6 | 0 | 25 |
| 0x62bd519fa2bb53d9e8e29e7657840f4b8167e44c | false | 83 | 257 | 10876998 | 167000000 | 0x00000000000000000000000000000000000000000000000000009b6301dbfed9 | 2024-02-21T19:22:23.000Z | 167000000 | 0xbc23798137ceda984b8661c04862e07b2c854367e5ec596e448e2576e15c63e6 | 0 | 25 |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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. |
| gas | value | status | gas\_used | out\_pool | in\_\_limit | signature | to\_address | block\_number | from\_address | in\_\_borrower | in\_\_schedule | trace\_address | in\_\_fundableAt | in\_\_lateFeeApr | block\_timestamp | in\_\_interestApr | transaction\_hash | in\_\_allowedUIDTypes | in\_\_originationFees | in\_\_juniorFeePercent |
| -------- | ----- | ------ | --------- | ------------------------------------------ | ------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | -------------- | ---------------- | ---------------- | ------------------------ | ------------------- | ------------------------------------------------------------------ | --------------------- | --------------------------------------------------------------------------- | ---------------------- |
| 4314401 | 0 | true | 1185072 | 0xd30b83ef8004860a91084d67cbd14b84d906e07f | 100000000 | 0x0771b68e | 0x2eb556087beb4f25d77222002cbe96cb0fac7e67 | 9760621 | 0xa3f4318f9220c796495b9aa4ed1e525b180a5cba | 0x46cc6418bf12933e4afcf95ae255e8249fffd0d9 | 0xa7da355994cf22541d3c76738b290f80bdbd0601 | 0,3,0 | 0 | 0 | 2024-01-26T23:09:49.000Z | 3650000000000000000 | 0xa0167af1db4852072dbc5edc16bced2fc6c4c1f3582dd390161775af74ae5d18 | \["1"] | \{"feeInBps":"0","originator":"0x0000000000000000000000000000000000000000"} | 0 |
| 7415320 | 0 | false | 1132303 | 0x64e9f5c3f788d4d6bd5612cee0d04c5845448917 | 150000000000 | 0x0771b68e | 0x2eb556087beb4f25d77222002cbe96cb0fac7e67 | 10191729 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x71fb757bd053b7cddfc3740573e925371ed9b2ef | 0,2,8 | 0 | 0 | 2024-02-05T22:40:05.000Z | 141944183000000000 | 0x37c6cb8b2fccb29089a61183823e0ee87bf0951dcf04113d42de2bb6b1495573 | \["1"] | \{"feeInBps":"0","originator":"0x0000000000000000000000000000000000000000"} | 0 |
| 20387729 | 0 | true | 1132303 | 0x64e9f5c3f788d4d6bd5612cee0d04c5845448917 | 150000000000 | 0x0771b68e | 0x2eb556087beb4f25d77222002cbe96cb0fac7e67 | 10191804 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x71fb757bd053b7cddfc3740573e925371ed9b2ef | 0,2,8 | 0 | 0 | 2024-02-05T22:42:35.000Z | 141944183000000000 | 0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32 | \["1"] | \{"feeInBps":"0","originator":"0x0000000000000000000000000000000000000000"} | 0 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| 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 |
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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` | 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. |
| gas | value | status | gas\_used | in\_\_limit | signature | in\_\_config | to\_address | block\_number | from\_address | in\_\_borrower | in\_\_schedule | trace\_address | in\_\_fundableAt | in\_\_lateFeeApr | block\_timestamp | in\_\_interestApr | transaction\_hash | in\_\_allowedUIDTypes | in\_\_originationFees | in\_\_juniorFeePercent |
| -------- | ----- | ------ | --------- | ------------ | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | -------------- | ---------------- | ---------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ | --------------------- | --------------------------------------------------------------------------- | ---------------------- |
| 17731116 | 0 | true | 942935 | 500000000000 | 0x3bde8d44 | 0xac91743f4cfdebc1f7a38ecf38a8cf78ef5355f5 | 0x23334e85bf9576896039f62568b321118b98fa59 | 10191804 | 0x77e91f120d97a5c26dfca7ca96e9228e820b1041 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x1fc10568ee4bfeb0fc63dc9c8338bdd645045319 | 0,2,12,0,3,1 | 0 | 0 | 2024-02-05T22:42:35.000Z | 152083333330000000 | 0x559906ed01511626b5054ed6fd6770b46b8929f4097e40d608ce103b253cec32 | \["1"] | \{"feeInBps":"0","originator":"0x0000000000000000000000000000000000000000"} | 0 |
| 5357336 | 0 | false | 942935 | 500000000000 | 0x3bde8d44 | 0xac91743f4cfdebc1f7a38ecf38a8cf78ef5355f5 | 0x23334e85bf9576896039f62568b321118b98fa59 | 10191729 | 0x77e91f120d97a5c26dfca7ca96e9228e820b1041 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x1fc10568ee4bfeb0fc63dc9c8338bdd645045319 | 0,2,12,0,3,1 | 0 | 0 | 2024-02-05T22:40:05.000Z | 152083333330000000 | 0x37c6cb8b2fccb29089a61183823e0ee87bf0951dcf04113d42de2bb6b1495573 | \["1"] | \{"feeInBps":"0","originator":"0x0000000000000000000000000000000000000000"} | 0 |
| 2246423 | 0 | false | 942935 | 250000000000 | 0x3bde8d44 | 0xac91743f4cfdebc1f7a38ecf38a8cf78ef5355f5 | 0x23334e85bf9576896039f62568b321118b98fa59 | 10191729 | 0xa61b41bb3f65c9e11f4b895196afdcdb14ad7556 | 0x9817fb8db3c1f65feaa07a297dc37580ed588183 | 0x62d3701e41b4f18705905c53ef36053546b34467 | 0,2,20,0,3,1 | 0 | 0 | 2024-02-05T22:40:05.000Z | 157274221000000000 | 0x37c6cb8b2fccb29089a61183823e0ee87bf0951dcf04113d42de2bb6b1495573 | \["1"] | \{"feeInBps":"0","originator":"0x0000000000000000000000000000000000000000"} | 0 |
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| 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` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v3_base.TranchedPool_WithdrawalMade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***