maple_v2_ethereum

Tables

FeeManager_ServiceFeesPaid_event

Service fee payment events from Maple Finance V2 lending protocol on Ethereum, tracking delegate and platform fees collected per loan including partial refinancing fees. Used for analyzing protocol revenue distribution and loan servicing costs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_loan_`	`STRING`	Contract address of the loan being serviced in this fee payment event. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the specific Maple V2 loan contract.
`in_delegateServiceFee_`	`STRING`	Delegate service fee amount paid on this loan event, denominated in the smallest token units (wei for ETH-based tokens). Zero values indicate no delegate fees were charged for the transaction.
`in_partialRefinanceDelegateServiceFee_`	`STRING`	Service fee paid to the loan delegate during partial loan refinancing, denominated in the smallest token unit. This fee is typically zero for full refinances and non-zero when loans undergo partial refinancing adjustments.
`in_platformServiceFee_`	`STRING`	Platform service fee amount collected on this loan payment event, denominated in the loan’s base token (smallest unit). Zero when no fee is charged or during partial refinances where fees are tracked separately.
`in_partialRefinancePlatformServiceFee_`	`STRING`	Platform service fee collected during partial loan refinancing events in wei. Represents the protocol’s portion of fees when a loan is partially refinanced, with zero indicating no partial refinancing occurred.

Sample Data

address	removed	in_loan_	log_index	block_number	block_timestamp	transaction_hash	in_delegateServiceFee_	in_platformServiceFee_	in_partialRefinanceDelegateServiceFee_	in_partialRefinancePlatformServiceFee_
0xfeaca6a5703e6f9de0ebe0975c93ae34c00523f2	false	0xd027cdd569b6cd1ad13dc82d42d0cd7cdeda3521	487	16298681	2022-12-30T16:08:35.000Z	0x23da6a2378e2d4613bdf52a220dc24ddf3df1462bcc973cda5662d9902773d82	678082191	1356164383	0	0
0xfeaca6a5703e6f9de0ebe0975c93ae34c00523f2	false	0xdef9146f12e22e5c69fb7b7d181534240c04fdce	99	16298103	2022-12-30T14:12:59.000Z	0xd5c540c2dcee8c60825ce30ffe21722059de91427fac382c09fa2fa3196406b6	1457548972602739725	2441095890410958904	0	0
0xfeaca6a5703e6f9de0ebe0975c93ae34c00523f2	false	0x023db56966858d139fe6406ae927275490715a3a	290	17861570	2023-08-07T07:28:23.000Z	0xac72a53664ff6275982e748716cb29a8746ab89ec232dd0def2dae8e1aaf42fa	618410958904109589	1236821917808219178	808559018264840180	1617118036529680364

Example Query

Query with partition filter

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

FixedTermLoanManagerFactory_InstanceDeployed_event

FixedTermLoanManager contract deployment events from Maple Finance V2 protocol on Ethereum, tracking when new loan manager instances are created with their addresses, version numbers, and initialization parameters. Used for monitoring protocol expansion and identifying active loan management contracts across different pool configurations.

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_version_`	`STRING`	Version identifier of the contract implementation being deployed. Numeric string representing the deployed contract version.
`in_instance_`	`STRING`	Contract address of the newly deployed instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_initializationArguments_`	`STRING`	ABI-encoded initialization arguments passed to the deployed contract instance. Hex-encoded string with 0x prefix containing constructor parameters.

Sample Data

address	removed	log_index	in_version_	block_number	in_instance_	block_timestamp	transaction_hash	in_initializationArguments_
0x1551717ae4fdcb65ed028f7fb7aba39908f6a7a6	false	329	200	16485840	0xd05998a1940294e3e49f99dbb13fe20a3483f5ae	2023-01-25T19:11:47.000Z	0x8234a7e1f4bb9c8cb588646d0cc854f6ec6a895499b048b59062a37aeb59194b	0x000000000000000000000000e9d33286f0e37f517b1204aa6da085564414996d
0x1551717ae4fdcb65ed028f7fb7aba39908f6a7a6	false	170	100	16162315	0x6b6491aaa92ce7e901330d8f91ec99c2a157ebd7	2022-12-11T15:18:23.000Z	0x390b5051f64de1e03599fc48d4f1d85ef5adc855e112edbe2f613049a946e647	0x00000000000000000000000000e0c1ea2085e30e5233e98cfa940ca8cbb1b0b7
0x1551717ae4fdcb65ed028f7fb7aba39908f6a7a6	false	274	100	16162589	0x7dca0cd3f1ebae3640ac4c66688a9d3a184af822	2022-12-11T16:13:23.000Z	0x3a8276102a3f55bc996acff3de71c5b8936030a7dfac27b1b813934a02d3f149	0x000000000000000000000000137f2ea5cfb0fe59408bab2779e33ee868f1810e

Example Query

Query with partition filter

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

FTLoanManager_FundsDistributed_event

Loan repayment and interest distribution events from Maple Finance v2 fixed-term (FT) loan manager contracts on Ethereum. Captures principal and net interest amounts distributed per loan for tracking borrower repayments and lender yield attribution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_loan_`	`STRING`	Contract address of the loan receiving the distributed funds in this Maple V2 FTLoanManager event. Hex-encoded, 0x-prefixed 40-character Ethereum address identifier.
`in_principal_`	`STRING`	Principal amount repaid or distributed from the loan, denominated in the smallest unit of the loan’s token. Value of “0” indicates an interest-only distribution without principal repayment.
`in_netInterest_`	`STRING`	Net interest amount distributed from the loan to the pool, denominated in the loan’s underlying token base units (wei for ETH-based tokens). This value represents interest earned after accounting for any fees or deductions.

Sample Data

address	removed	in_loan_	log_index	block_number	in_principal_	block_timestamp	in_netInterest_	transaction_hash
0x74cb3c1938a15e532cc1b465e3b641c2c7e40c2b	false	0xd027cdd569b6cd1ad13dc82d42d0cd7cdeda3521	494	16298681	0	2022-12-30T16:08:35.000Z	18986301370	0x23da6a2378e2d4613bdf52a220dc24ddf3df1462bcc973cda5662d9902773d82
0x373bdcf21f6a939713d5de94096ffdb24a406391	false	0xdef9146f12e22e5c69fb7b7d181534240c04fdce	106	16298103	4500000000000000000000	2022-12-30T14:12:59.000Z	37101246575342462101	0xd5c540c2dcee8c60825ce30ffe21722059de91427fac382c09fa2fa3196406b6
0x74cb3c1938a15e532cc1b465e3b641c2c7e40c2b	false	0xa6b77ac12251ea144a85cd11c9d7f457c124bba8	228	17861641	1550000000000	2023-08-07T07:42:47.000Z	40663332740	0x8c33354940b2b1d9f12f75a1ed20798aa57b6e98eaf818843376f339db773c1d

Example Query

Query with partition filter

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

LoanManager_ClaimedFundsDistributed_event

Fund distribution events from Maple Finance v2 loan manager contracts on Ethereum, tracking principal repayments, interest payments, and fee allocations to platform, delegates, and service providers. Used for analyzing lending protocol revenue streams and fee breakdowns across individual loans.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_loan_`	`STRING`	Contract address of the loan for which funds are being distributed in Maple Finance v2. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the specific loan contract.
`in_principal_`	`STRING`	Principal amount repaid in this loan payment distribution event, denominated in the smallest unit of the loan’s underlying token. Value of ‘0’ indicates an interest-only payment with no principal reduction.
`in_netInterest_`	`STRING`	Net interest amount distributed to the lending pool after deducting all fees. Denominated in the smallest unit of the loan’s token (e.g., wei for ETH-based loans), typically representing the largest portion of funds distributed.
`in_delegateManagementFee_`	`STRING`	Management fee paid to the pool delegate from the loan payment, denominated in the smallest unit of the loan’s token. Value is zero when the pool has no delegate management fee structure configured.
`in_delegateServiceFee_`	`STRING`	Service fee paid to the pool delegate when loan funds are claimed and distributed. Denominated in the smallest unit of the underlying token (e.g., wei for ETH-based tokens), can be zero if no delegate service fee applies.
`in_platformManagementFee_`	`STRING`	Platform management fee amount collected by Maple Finance from this loan payment. Denominated in the smallest unit of the loan token (e.g., wei for ETH-based loans), can be zero if no platform fee applies.
`in_platformServiceFee_`	`STRING`	Platform service fee amount charged on this loan payment event, denominated in the smallest unit of the loan’s token. This fee is typically a percentage of the payment amount and may be zero depending on the loan terms.

Sample Data

address	removed	in_loan_	log_index	block_number	in_principal_	block_timestamp	in_netInterest_	transaction_hash	in_platformManagementFee_
0xfab269cb4ab4d33a61e1648114f6147742f5eecc	false	0xda8f7941192590408dce701a60fb3892455669ce	132	17963121	0	2023-08-21T12:30:47.000Z	5960866194	0x61f7ae09fe68e4f49754b639c1b886e318fbbf4493c96c4699b0722d007b8b78	291486356
0xfab269cb4ab4d33a61e1648114f6147742f5eecc	false	0xda8f7941192590408dce701a60fb3892455669ce	213	17544224	90000000000	2023-06-23T19:03:11.000Z	614562157	0x64336bdeb1fe31eaa13d906c599543b39392295ce9d544b23a0de2d826588405	30728107
0xfab269cb4ab4d33a61e1648114f6147742f5eecc	false	0xda8f7941192590408dce701a60fb3892455669ce	151	18441561	0	2023-10-27T12:31:47.000Z	1984760933	0x3cec2146b7ebd4a7162c6d806e4ac30ff36e1fe7fdb0198be7f67e926ed0452a	93283763

Example Query

Query with partition filter

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

LoanManagerFactory_InstanceDeployed_event

Deployment events for Maple Finance v2 loan manager contracts on Ethereum, capturing when new loan manager instances are created by the factory contract. Used to track protocol expansion and map loan manager addresses to their initialization parameters and deployment versions.

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_version_`	`STRING`	Version identifier of the contract implementation being deployed. Numeric string representing the deployed contract version.
`in_instance_`	`STRING`	Contract address of the newly deployed instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_initializationArguments_`	`STRING`	ABI-encoded initialization arguments passed to the deployed contract instance. Hex-encoded string with 0x prefix containing constructor parameters.

Sample Data

address	removed	log_index	in_version_	block_number	in_instance_	block_timestamp	transaction_hash	in_initializationArguments_
0x90b14505221a24039a2d11ad5862339db97cc160	false	33	100	17877843	0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0	2023-08-09T14:08:11.000Z	0x2b8d97e1afc3473f43960113f167777e39bbe9e15a08bf3f2a0f7e32495899c8	0x0000000000000000000000005ee9587bf5f4ccceeed87b0216a31ebb513fac25
0x90b14505221a24039a2d11ad5862339db97cc160	false	206	100	17912277	0x483082e93635ef280bc5e9f65575a7ff288aba33	2023-08-14T09:45:59.000Z	0x017a83389f3d77241a322b484900085547d62e60354f2adbdad90a7e6c5bdd32	0x000000000000000000000000a9c908ee077ee26b52137fff714150c7eb69e160
0x90b14505221a24039a2d11ad5862339db97cc160	false	106	100	18370317	0xd205b3ed8408afca53315798b891f37bd4c5ce2a	2023-10-17T13:13:35.000Z	0x7489aa7662e0751fbf911171a9d019e7ff2820f148e6be2c161069bf0f5e614f	0x000000000000000000000000ba5936d5d8e5b050159ff8ccb2589309e3071c2a

Example Query

Query with partition filter

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

OTLFactory_InstanceDeployed_event

Instance deployment events from Maple v2’s OTL (Open-Term Loan) Factory contract on Ethereum. Tracks creation of new loan instances with version identifiers and initialization parameters for monitoring protocol expansion and loan origination activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version_`	`STRING`	Version identifier of the contract implementation being deployed. Numeric string representing the deployed contract version.
`in_instance_`	`STRING`	Contract address of the newly deployed instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_initializationArguments_`	`STRING`	ABI-encoded initialization arguments passed to the deployed contract instance. Hex-encoded string with 0x prefix containing constructor parameters.

Sample Data

address	removed	log_index	in_version_	block_number	in_instance_	block_timestamp	transaction_hash	in_initializationArguments_
0x6fad515fc046dd17166453a79725f50b917b7cf6	false	157	101	18442409	0x72569cf4a53eb1b09784d7ecdc640cc4f5ff7366	2023-10-27T15:22:35.000Z	0xaffc16d7048ef372d6d0df471376c7abe0e1c3d270f54a165354c83660b7c373	0x00000000000000000000000071e6686f6267b454dbdf6db3399e7d6ced2b5313000000000000000000000000dc9b93a8a336fe5dc9db97616ea2118000d70fc0000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000082f79cd9000000000000000000000000000000000000000000000000000000000000006978000000000000000000000000000000000000000000000000000000000003b538000000000000000000000000000000000000000000000000000000000002a30000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001adb00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c350
0x6fad515fc046dd17166453a79725f50b917b7cf6	false	278	101	17879167	0x07bc04a9bc791f469060db77a123497c0aab6f81	2023-08-09T18:35:47.000Z	0xad691cea5c584802434d048310ed66cfa3ca6027d95ffe592d33b42efef5ccc6	0x000000000000000000000000ee9d1874b35d40fb13e8a8e6093521f7947d5345000000000000000000000000dc9b93a8a336fe5dc9db97616ea2118000d70fc0000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000001176592e0000000000000000000000000000000000000000000000000000000000000697800000000000000000000000000000000000000000000000000000000000278d000000000000000000000000000000000000000000000000000000000000278d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000190640000000000000000000000000000000000000000000000000000000000002710000000000000000000000000000000000000000000000000000000000000c350
0x6fad515fc046dd17166453a79725f50b917b7cf6	false	317	101	17915021	0xf2fda7d97cf9920e0857ec60416ed0006ea610f9	2023-08-14T18:56:47.000Z	0x9173481a6b09877122a12ebf429f4e7b2d727764dc964ae9b7b3dbcbdd54a0f0	0x0000000000000000000000007e4ddc091f1d208e2345080e169ed4be0a1ce0ad000000000000000000000000483082e93635ef280bc5e9f65575a7ff288aba33000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000001300fb83b300000000000000000000000000000000000000000000000000000000000069780000000000000000000000000000000000000000000000000000000000076a7000000000000000000000000000000000000000000000000000000000000278d00000000000000000000000000000000000000000000000000000000000000051400000000000000000000000000000000000000000000000000000000000278d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c350

Example Query

Query with partition filter

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

Pool_Initialized_event

Pool initialization events from Maple Finance v2 lending protocol on Ethereum, capturing the creation of new lending pools with their associated borrower note tokens, lender note tokens, and collateral token addresses. Used for tracking pool deployment history and analyzing collateral configurations across Maple’s institutional DeFi (decentralized finance) lending marketplace.

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_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowerNote`	`STRING`	Contract address of the borrower note token issued by this Maple V2 pool. This token represents the borrower’s debt obligation and is typically a stablecoin address (commonly USDC).
`in_lenderNote`	`STRING`	Contract address of the lender note token representing the lender’s position in this Maple v2 pool. Hex-encoded, 0x-prefixed 40-character Ethereum address issued upon pool initialization.

Sample Data

address	removed	log_index	block_number	in_lenderNote	block_timestamp	in_borrowerNote	transaction_hash	in_collateralToken
0x00d950a41a0d277ed91bf9fd366a5523fef0371e	false	112	16162536	0xd3cd37a7299b963bbc69592e5ba933388f70dc88	2022-12-11T16:02:47.000Z	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x08b0bb721ffaee0af4d5c093a86e76d31b55b56bf013f678c29c7ad86fa3bd4a	0xf11897a0009b3a37f15365a976015e7f22a16d50
0xc0323b64ef95e5698b30febd6a54bfd66ca2210e	false	271	16162589	0x137f2ea5cfb0fe59408bab2779e33ee868f1810e	2022-12-11T16:13:23.000Z	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x3a8276102a3f55bc996acff3de71c5b8936030a7dfac27b1b813934a02d3f149	0x37c610584f7834a8feb490b73e2ac780aee31905
0x24617612dec91855e126e6330580425f6a262ee9	false	167	16162315	0x00e0c1ea2085e30e5233e98cfa940ca8cbb1b0b7	2022-12-11T15:18:23.000Z	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x390b5051f64de1e03599fc48d4f1d85ef5adc855e112edbe2f613049a946e647	0xec67fd8445e9a84311e2bd118a21b2fdaacfc7fa

Example Query

Query with partition filter

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

PoolManager_RedeemProcessed_event

Redemption execution events from Maple Finance v2 lending pools on Ethereum, tracking when liquidity providers withdraw their pool shares and receive underlying assets. Shows share-to-asset conversion rates for analyzing pool liquidity exits and LP 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_owner_`	`STRING`	Ethereum address of the account that owns the shares being redeemed from the Maple V2 pool. This is the recipient who will receive the resulting assets after redemption processing.
`in_redeemableShares_`	`STRING`	Amount of pool shares being redeemed by the owner in this transaction, denominated in the pool’s smallest unit. Typically represents the user’s claim on underlying assets before conversion to the resulting asset amount.
`in_resultingAssets_`	`STRING`	Amount of underlying assets (denominated in the pool’s base token) returned to the owner upon redemption. Expressed in the smallest unit of the token (e.g., wei for ETH, smallest decimal unit for stablecoins).

Sample Data

address	removed	in_owner_	log_index	block_number	block_timestamp	transaction_hash	in_resultingAssets_	in_redeemableShares_
0xa9c908ee077ee26b52137fff714150c7eb69e160	false	0xb4ec6c18cd9dc4f3d1c378307d4bdda18ddae899	147	19669764	2024-04-16T18:15:35.000Z	0x26141e44a4f13c5ab0e90f99eb2f0e9b9791aee9b118eb2dde2254cf1544c410	11204607541	9663550086
0xa9c908ee077ee26b52137fff714150c7eb69e160	false	0xe83c69d9594118ada9f95af629c989805a33c138	247	19668686	2024-04-16T14:37:59.000Z	0x5bb9b5893f98eafd96eaecfe9dc5c701231318419b80300b765000e93fc69542	17982237396	15509890568
0x00d950a41a0d277ed91bf9fd366a5523fef0371e	false	0x52d597334a853cfc0e5afde7e813ae5a7e965176	459	16353799	2023-01-07T08:45:23.000Z	0xb68ebfed56aabc86bfd3174342d502bb8b667b1e058f4afbaeeb62175079342a	1082963	5097166

Example Query

Query with partition filter

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

PoolManagerFactory_InstanceDeployed_event

Pool manager deployment events from Maple Finance v2 lending protocol on Ethereum. Records factory-created pool manager instances with version numbers and initialization parameters for tracking protocol growth and pool creation activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version_`	`STRING`	Version identifier of the contract implementation being deployed. Numeric string representing the deployed contract version.
`in_instance_`	`STRING`	Contract address of the newly deployed instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_initializationArguments_`	`STRING`	ABI-encoded initialization arguments passed to the deployed contract instance. Hex-encoded string with 0x prefix containing constructor parameters.

Sample Data

address	removed	log_index	in_version_	block_number	in_instance_	block_timestamp	transaction_hash	in_initializationArguments_
0xe463cd473ecc1d1a4ecf20b62624d84dd20a8339	false	273	100	17081094	0x219654a61a0bc394055652986be403fa14405bb8	2023-04-19T13:58:47.000Z	0x0678cf50726f6630bb43e5d3f16a78e64593bb943183c363c3c9d8e7f6ab3349	0x0000000000000000000000008c8c2431658608f5649b8432764a930c952d8a98000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000000000000000000104d61706c65204361736820555344433100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b4d504c6361736855534443000000000000000000000000000000000000000000
0xe463cd473ecc1d1a4ecf20b62624d84dd20a8339	false	272	100	16162589	0xc0323b64ef95e5698b30febd6a54bfd66ca2210e	2022-12-11T16:13:23.000Z	0x3a8276102a3f55bc996acff3de71c5b8936030a7dfac27b1b813934a02d3f149	0x00000000000000000000000037c610584f7834a8feb490b73e2ac780aee31905000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000005237e3e33fb00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000001b496365627265616b6572204d61706c6520506f6f6c2055534443310000000000000000000000000000000000000000000000000000000000000000000000000b4d504c2d69625553444331000000000000000000000000000000000000000000
0xe463cd473ecc1d1a4ecf20b62624d84dd20a8339	false	193	100	16162554	0x833a5c9fc016a87419d21b10b64e24082bd1e49d	2022-12-11T16:06:23.000Z	0x9bb2bc90fb0a17acb4af994382a1f5a8850bbbfca96e57542e70fab15782fa33	0x000000000000000000000000bfa29aa894229d532d1ad1fd7e4226fce842632c000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000004fd7ec4f1064b170b5a00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000001b4d313120437265646974204d61706c6520506f6f6c2057455448310000000000000000000000000000000000000000000000000000000000000000000000000b4d504c2d6d635745544831000000000000000000000000000000000000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

FeeManager_ServiceFeesPaid_event

FixedTermLoanManagerFactory_InstanceDeployed_event

FTLoanManager_FundsDistributed_event

LoanManager_ClaimedFundsDistributed_event

LoanManagerFactory_InstanceDeployed_event

OTLFactory_InstanceDeployed_event

Pool_Initialized_event

PoolManager_RedeemProcessed_event

PoolManagerFactory_InstanceDeployed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​FeeManager_ServiceFeesPaid_event

​FixedTermLoanManagerFactory_InstanceDeployed_event

​FTLoanManager_FundsDistributed_event

​LoanManager_ClaimedFundsDistributed_event

​LoanManagerFactory_InstanceDeployed_event

​OTLFactory_InstanceDeployed_event

​Pool_Initialized_event

​PoolManager_RedeemProcessed_event

​PoolManagerFactory_InstanceDeployed_event

Tables

FeeManager_ServiceFeesPaid_event

FixedTermLoanManagerFactory_InstanceDeployed_event

FTLoanManager_FundsDistributed_event

LoanManager_ClaimedFundsDistributed_event

LoanManagerFactory_InstanceDeployed_event

OTLFactory_InstanceDeployed_event

Pool_Initialized_event

PoolManager_RedeemProcessed_event

PoolManagerFactory_InstanceDeployed_event