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.

Columns

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

Sample Data

address	in_pool	removed	log_index	in_borrower	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_borrower	block_number	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

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

Sample Data

address	in_pool	removed	in_payer	log_index	block_number	block_timestamp	in_reserveAmount	transaction_hash	in_interestAmount	in_principalAmount
0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae	0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae	false	0xd750033cd9ab91ead99074f671bbcbce0ffd91a8	48	14934840	2022-06-09T21:46:43.000Z	5283569126	0xd71518f8db2e621a62906e59ca132d4e7508dad14e31bde2e4bd79289e7052b0	52835691264	8736
0xd09a57127bc40d680be7cb061c2a6629fe71abef	0xd09a57127bc40d680be7cb061c2a6629fe71abef	false	0xd750033cd9ab91ead99074f671bbcbce0ffd91a8	94	18160051	2023-09-18T03:04:59.000Z	8219176886	0xe158e17aab8021b810f1b7ec0d3e74048199284c07050e03b5bca4e5e1a61060	82191768864	231136
0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae	0xc9bdd0d3b80cc6efe79a82d850f44ec9b55387ae	false	0xd750033cd9ab91ead99074f671bbcbce0ffd91a8	324	16558297	2023-02-04T22:07:11.000Z	5283569050	0xe85fea15dea3a1943fb522c85e4f1f4a1033d76f0cc8d461234107788f022fd4	52835690507	0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_tranche`	`STRING`	Identifier for the tranche type within a Goldfinch lending pool, typically distinguishing between senior and junior tranches. Numeric string representation, commonly ‘1’ for senior or ‘2’ for junior.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_interestWithdrawn`	`STRING`	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.

Sample Data

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

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

SeniorPool_DepositMade_event

SeniorPool_PrincipalWrittenDown_event

SeniorPool_ReserveFundsCollected_event

SeniorPool_WithdrawalMade_event

TranchedPool_DepositMade_event

TranchedPool_DrawdownMade_event

TranchedPool_PaymentApplied_event

TranchedPool_ReserveFundsCollected_event

TranchedPool_WithdrawalMade_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​SeniorPool_DepositMade_event

​SeniorPool_PrincipalWrittenDown_event

​SeniorPool_ReserveFundsCollected_event

​SeniorPool_WithdrawalMade_event

​TranchedPool_DepositMade_event

​TranchedPool_DrawdownMade_event

​TranchedPool_PaymentApplied_event

​TranchedPool_ReserveFundsCollected_event

​TranchedPool_WithdrawalMade_event

Tables

Factory_PoolCreated_event

SeniorPool_DepositMade_event

SeniorPool_PrincipalWrittenDown_event

SeniorPool_ReserveFundsCollected_event

SeniorPool_WithdrawalMade_event

TranchedPool_DepositMade_event

TranchedPool_DrawdownMade_event

TranchedPool_PaymentApplied_event

TranchedPool_ReserveFundsCollected_event

TranchedPool_WithdrawalMade_event