> ## 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_v2_ethereum
> Tables in tt-contracts.goldfinch_v2_ethereum
## Tables
### 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd20508e1e971b80ee172c73517905bfffcbd87f9 | 0xaa2ccc5547f64c5dffd0a624eb4af2543a67ba65 | false | 40 | 0x9892245a6a6a0706bf10a59129ba9cbf0e1033e3 | 13457805 | 2021-10-21T00:36:20.000Z | 0x8a19dc02b741072d426f7884770029e0d01f7d424395e9a6e7862d668bde2cc7 |
| 0xd20508e1e971b80ee172c73517905bfffcbd87f9 | 0xc13465ce9ae3aa184eb536f04fdc3f54d2def277 | false | 264 | 0xcf595641c40008fdc97e5ccbce710ab4d31539a3 | 13149810 | 2021-09-03T01:30:26.000Z | 0x57df5c4b02d07193fc63ee05207e57f2afae8a1f91bc8ef1581642c3792f524c |
| 0xd20508e1e971b80ee172c73517905bfffcbd87f9 | 0x9e8b9182abba7b4c188c979bc8f4c79f7f4c90d3 | false | 403 | 0x71693a31d4026edaf24bd192bd51558d442bb2ef | 13097799 | 2021-08-26T00:35:52.000Z | 0x9ebb9fa91e17e3464d2e1b859368b331a97bc0f4634c57cbcc812bcec295797c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### SeniorPool\_DepositMade\_event
Capital provider deposit events into Goldfinch V2's Senior Pool on Ethereum, recording USDC amounts deposited and FIDU shares minted. Used for tracking liquidity provision and share-based ownership in the senior tranche.
| 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_capitalProvider` | `STRING` | Address of the capital provider making the deposit or withdrawal. 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_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_amount | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_capitalProvider |
| ------------------------------------------ | ------- | ---------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | 100000000 | 92437015238987756806 | 4 | 15314107 | 2022-08-10T11:36:53.000Z | 0xc94ab00c51e610c24526f91139f7bd256b4f1c44d9d828b0ba4ac893e8b0dafb | 0x66f68692c03eb9c0656d676f2f4bd13eba40d1b7 |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | 101000000 | 93361385391377634374 | 292 | 15313862 | 2022-08-10T10:42:33.000Z | 0x82cf841eca9f6d890bd5d6c30c545055d8032d9376cd389db1dbaae8d891af94 | 0x66f68692c03eb9c0656d676f2f4bd13eba40d1b7 |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | 101000000 | 93361385391377634374 | 253 | 15313177 | 2022-08-10T08:04:25.000Z | 0x1a17967ccb308590c0ac6b519ca373d335db58789425ffce7ee241bfb961816f | 0x66f68692c03eb9c0656d676f2f4bd13eba40d1b7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.SeniorPool_DepositMade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### SeniorPool\_PrincipalWrittenDown\_event
Principal write-down events from Goldfinch v2 Senior Pool on Ethereum, tracking loan loss adjustments across tranched pools. Used for analyzing credit losses and risk exposure in the protocol's senior tranche liquidity pool.
| 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_tranchedPool` | `STRING` | Contract address of the specific Goldfinch tranched pool where the principal writedown occurred. References the underlying borrower pool affected by the loss adjustment event. |
| `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 | block\_timestamp | in\_tranchedPool | transaction\_hash |
| ------------------------------------------ | ------- | -------------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | -624720853121 | 221 | 17802279 | 2023-07-30T00:29:47.000Z | 0xaa2ccc5547f64c5dffd0a624eb4af2543a67ba65 | 0xa93d549607024c38c09859c8724c4e503b3ae6c2c71c0bff77ecc2cb83014f6f |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | -1249441706244 | 436 | 18230364 | 2023-09-27T23:26:35.000Z | 0xaa2ccc5547f64c5dffd0a624eb4af2543a67ba65 | 0xb9397076b7bba3fe932c9961717bc8ad62677475d7f77cab48c04d72ffc66a22 |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | -1249441706243 | 149 | 18024789 | 2023-08-30T03:38:11.000Z | 0xaa2ccc5547f64c5dffd0a624eb4af2543a67ba65 | 0x68d134058efb2a2606b76572f1a9e673085fda7c8dc4f885cf0ef89601b7a189 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.SeniorPool_PrincipalWrittenDown_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### SeniorPool\_ReserveFundsCollected\_event
Reserve fund collection events from Goldfinch v2 SeniorPool on Ethereum, tracking protocol fees and reserve allocations with user addresses and amounts. Used for analyzing protocol revenue collection and fee distribution to the reserve.
| 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_user` | `STRING` | Address of the user account associated with the transaction or protocol 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. |
| address | in\_user | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | 0x4f2dccace79a58989f562155ecb1dc4623572e0a | false | 113691577 | 12 | 15117079 | 2022-07-10T20:42:39.000Z | 0x0f611f28af96d8272171a62a9ccece886e5417f364c22774729bcb76cf0705bc |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | 0x0b8f684433b668c928bfa1556598bfac7fa00b65 | false | 24752123 | 17 | 15117083 | 2022-07-10T20:43:08.000Z | 0x8c57442aee6d5eb8a80ee9e0a8062d991e8a261fbf8fdc25b956874904833d23 |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | 0xc16e9ce31179909a69f92c6b587e9255bb77fb16 | false | 150000 | 368 | 15114724 | 2022-07-10T11:49:05.000Z | 0x258ab672418164304c8cdd69994a6ae7da1ff157875d40eb57dd04b204dbb988 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.SeniorPool_ReserveFundsCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### SeniorPool\_WithdrawalMade\_event
Withdrawal events from Goldfinch's SeniorPool smart contract on Ethereum, recording when liquidity providers exit their positions with user and reserve amounts in USDC (6 decimals). Used to analyze capital flows, liquidity provider behavior, and Senior Pool redemption patterns.
| 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_capitalProvider` | `STRING` | Address of the capital provider making the deposit or withdrawal. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_userAmount` | `STRING` | Amount withdrawn by the capital provider from the Goldfinch Senior Pool, denominated in the smallest unit (likely USDC with 6 decimals). Values are string-encoded integers representing the user's portion of the withdrawal, typically much larger than the reserve amount. |
| `in_reserveAmount` | `STRING` | Amount of tokens reserved in the protocol for the position or operation. String-encoded integer value representing the reserved quantity in the smallest unit of the relevant token. |
| address | removed | log\_index | block\_number | in\_userAmount | block\_timestamp | in\_reserveAmount | transaction\_hash | in\_capitalProvider |
| ------------------------------------------ | ------- | ---------- | ------------- | -------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | 117 | 18303668 | 2843296284 | 2023-10-08T05:26:35.000Z | 14287921 | 0x66724610586af2330bd6d6ed1ddb73c124014bf782e10213794594408eee53ca | 0x442bee95d7fea5217431a02a0df4d10bb1e85e68 |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | 140 | 18303137 | 1529022137 | 2023-10-08T03:39:23.000Z | 7683528 | 0x5f5498813926eba5d5fa11916a40e22bd68363637f574d6204745372f438b73a | 0xe42f738e4ef514f6a2b1b569d8aefafaffaa9f52 |
| 0x8481a6ebaf5c7dabc3f7e09e44a89531fd31f822 | false | 208 | 18304717 | 1178812237 | 2023-10-08T08:57:23.000Z | 5923679 | 0x2a4abe1a5b0d1dd5c7d022e9b8496f566a48603f27c6a2c6bba2bd0f026408f1 | 0xb49ce783e7572ffe985c0eeced326b621201ffda |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.SeniorPool_WithdrawalMade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TranchedPool\_DepositMade\_event
Lender deposit events from Goldfinch V2 tranched pools on Ethereum, recording capital contributions with tranche assignments and NFT token IDs. Used to track liquidity provider activity and pool funding across senior and junior 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_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. |
| address | removed | in\_owner | in\_amount | log\_index | in\_tokenId | in\_tranche | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ----------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1d596d28a7923a22aa013b0e7082bba23daa656b | false | 0xfb892ca235a9fbbcb6dcd808b151f08a712f2f36 | 10293948 | 82 | 348 | 2 | 13823684 | 2021-12-17T16:26:22.000Z | 0x3b78ab1088926c27d31c262ca320cdb294669c771e8671339c3b24f32abc93a5 |
| 0x1d596d28a7923a22aa013b0e7082bba23daa656b | false | 0xafa78d6e24101eb874333549a87f46629c94b759 | 60000000 | 114 | 341 | 2 | 13823630 | 2021-12-17T16:15:09.000Z | 0xf4a204171b62f6cc2ef1afd1d47ca433ab6a0932c27809717e32fd66571d25de |
| 0x1d596d28a7923a22aa013b0e7082bba23daa656b | false | 0x1d082f295ad54f472824a7f3b01fd2d29a05833b | 90000000 | 264 | 364 | 2 | 13824006 | 2021-12-17T17:40:51.000Z | 0x7cfc3d79cbe46d1bab898d699d812ccb6fb9410be4de92438d054ad3858c61b2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.TranchedPool_DepositMade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TranchedPool\_DrawdownMade\_event
Borrower loan drawdown events from Goldfinch v2 tranched pools on Ethereum, recording when borrowers withdraw USDC capital from their credit lines. Tracks drawdown amounts, borrower addresses, and pool contracts for analyzing capital deployment and credit utilization.
| 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. |
| address | removed | in\_amount | log\_index | in\_borrower | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb26b42dd5771689d0a7faeea32825ff9710b9c11 | false | 10150000000000 | 88 | 0x37e12d7abff5a2636acc3dced31030f3ed9cc0f8 | 14424794 | 2022-03-20T18:10:58.000Z | 0xd6bd44d46461313d3032ade83419607c4ef9512d3f68acf059b95d61c3aeaea2 |
| 0x00c27fc71b159a346e179b4a1608a0865e8a7470 | false | 19999990000000 | 20 | 0xf8c4a0fedf9b249253d89203034374e5a57b617c | 14251940 | 2022-02-21T21:47:45.000Z | 0x44adb6f8d03b7308e93f226ccc8fb6b6e39c2083c2ff15c6e3e8160b2eb932e1 |
| 0x00c27fc71b159a346e179b4a1608a0865e8a7470 | false | 10000000 | 20 | 0xf8c4a0fedf9b249253d89203034374e5a57b617c | 14251887 | 2022-02-21T21:37:32.000Z | 0x7b442b19f79ee53b4612e0f7bb2fd79652b31f2701f43818c8496ed0a506ebc6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.TranchedPool_DrawdownMade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TranchedPool\_PaymentApplied\_event
Loan payment events from Goldfinch V2 tranched pools on Ethereum, recording the allocation of borrower payments across interest, principal, and protocol reserves. Used to track repayment activity and calculate pool performance metrics.
| 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_interestAmount` | `STRING` | Interest portion of the payment denominated in the smallest unit of the token (e.g., USDC with 6 decimals). This amount is allocated to lenders as yield on their investment in the tranched pool. |
| `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_remainingAmount` | `STRING` | Amount of funds remaining after allocating the payment across interest, principal, and reserve. Denominated in the smallest unit of the payment token (typically USDC with 6 decimals), usually zero when payment fully covers the amount due. |
| `in_reserveAmount` | `STRING` | Amount of tokens reserved in the protocol for the position or operation. String-encoded integer value representing the reserved quantity in the smallest unit of the relevant token. |
| address | in\_pool | removed | in\_payer | log\_index | block\_number | block\_timestamp | in\_reserveAmount | transaction\_hash | in\_interestAmount | in\_principalAmount | in\_remainingAmount |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------ | ------------------- | ------------------- |
| 0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae | 0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae | false | 0xd750033cd9ab91ead99074f671bbcbce0ffd91a8 | 48 | 14934840 | 2022-06-09T21:46:43.000Z | 5283569126 | 0xd71518f8db2e621a62906e59ca132d4e7508dad14e31bde2e4bd79289e7052b0 | 52835691264 | 8736 | 0 |
| 0xd09a57127bc40d680be7cb061c2a6629fe71abef | 0xd09a57127bc40d680be7cb061c2a6629fe71abef | false | 0xd750033cd9ab91ead99074f671bbcbce0ffd91a8 | 94 | 18160051 | 2023-09-18T03:04:59.000Z | 8219176886 | 0xe158e17aab8021b810f1b7ec0d3e74048199284c07050e03b5bca4e5e1a61060 | 82191768864 | 231136 | 0 |
| 0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae | 0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae | false | 0xd750033cd9ab91ead99074f671bbcbce0ffd91a8 | 324 | 16558297 | 2023-02-04T22:07:11.000Z | 5283569050 | 0xe85fea15dea3a1943fb522c85e4f1f4a1033d76f0cc8d461234107788f022fd4 | 52835690507 | 0 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.TranchedPool_PaymentApplied_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TranchedPool\_ReserveFundsCollected\_event
Reserve fund collection events from Goldfinch v2 senior tranches on Ethereum, recording protocol fees withdrawn from individual borrower pools. Tracks pool addresses and USDC amounts (6 decimals) collected by the protocol for reserve purposes.
| 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. |
| address | in\_from | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xaa2ccc5547f64c5dffd0a624eb4af2543a67ba65 | 0xaa2ccc5547f64c5dffd0a624eb4af2543a67ba65 | false | 5341850988 | 4 | 15554745 | 2022-09-17T17:19:23.000Z | 0x393b1f900eb59d238097f76f0338c4aaeac5189f8d80a056ccde9143e08c9b0e |
| 0xefeb69edf6b6999b0e3f2fa856a2acf3bdea4ab5 | 0xefeb69edf6b6999b0e3f2fa856a2acf3bdea4ab5 | false | 2222572559 | 58 | 15239445 | 2022-07-29T20:08:44.000Z | 0xb91be5a293f611c0fbca3128221830447ec58ecac6d3949c716b1f25897273d4 |
| 0xd09a57127bc40d680be7cb061c2a6629fe71abef | 0xd09a57127bc40d680be7cb061c2a6629fe71abef | false | 8219178028 | 35 | 15807773 | 2022-10-23T02:18:23.000Z | 0x0d425bd5c28cf893f675eaedc4f2b9895a1b4dc6d2d9e20390e50267873b1df3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.TranchedPool_ReserveFundsCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TranchedPool\_WithdrawalMade\_event
Withdrawal events from Goldfinch v2 tranched credit pools on Ethereum, tracking principal and interest redemptions by liquidity providers. Contains token-level withdrawal data separated by tranche (junior/senior) 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_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` | Interest amount withdrawn from the tranched pool position, denominated in the smallest unit of the pool's currency (typically USDC with 6 decimals). Zero values indicate principal-only withdrawals where no interest was available or claimed. |
| `in_principalWithdrawn` | `STRING` | Principal amount withdrawn from the tranched pool position in the smallest token denomination. Non-zero values indicate capital redemptions, while zero values suggest interest-only withdrawals as seen in most sample transactions. |
| address | removed | in\_owner | log\_index | in\_tokenId | in\_tranche | block\_number | block\_timestamp | transaction\_hash | in\_interestWithdrawn | in\_principalWithdrawn |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ | --------------------- | ---------------------- |
| 0xe6c30756136e07eb5268c3232efbfbe645c1ba5a | false | 0x4bcdbebbf5253850d8ffc3137d2475670e09732a | 357 | 297 | 2 | 13710171 | 2021-11-29T18:33:53.000Z | 0xc2a90f03bde9200f3c22428b5dd334bd06af7a2cef4687499d7025e4eb236b50 | 0 | 10081340000 |
| 0x1d596d28a7923a22aa013b0e7082bba23daa656b | false | 0x0ae9b28ccbe5cfe2bd4e6731392441023c9d6cb9 | 321 | 333 | 2 | 15523911 | 2022-09-13T00:26:22.000Z | 0xff6c683bf6efa31a151d051e379aab5b436ce87e324509707349e0315d11ea00 | 1275000000 | 0 |
| 0x418749e294cabce5a714efccc22a8aade6f9db57 | false | 0x3ecd0359496f9a49a1b11eb50bb603c262ff4218 | 5 | 527 | 2 | 15524456 | 2022-09-13T02:37:16.000Z | 0x943fabf9a1dc997b7d5ef722a7483039dcb1f1fbcc304902cbdec099582e7218 | 2144900000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.goldfinch_v2_ethereum.TranchedPool_WithdrawalMade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***