maple_v1_ethereum

Tables

Loan_Drawdown_event

Loan withdrawal events from Maple Finance V1 protocol on Ethereum, recording when borrowers draw down funds from approved credit lines. Contains drawdown amounts (in token wei units) and loan contract addresses for tracking capital deployment and borrower 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_drawdownAmount`	`STRING`	Amount of funds withdrawn by the borrower from a Maple V1 loan contract, denominated in the smallest unit of the loan token (typically USDC with 6 decimals). Values range from 1 trillion to 25 trillion base units, representing actual loan drawdowns between $1M and$ 25M.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_drawdownAmount
0x4b15ce7f169eeed2bab30bf0a5c35f6e837792b1	false	104	13053027	2021-08-19T02:46:33.000Z	0x2d5df1570a3323b1cc533a0ca3ce7a2920ebe5b920a913258d9d23a23ce41c7e	5000000000000
0xe7a34c48a8bab6fcd256c2ce1bf0be9568891be2	false	250	13172842	2021-09-06T14:58:36.000Z	0xc305cf98cb88520c16eaf49b9d5fc40b4bb0aaeed6c49f9087426f04875f8910	15000000000000
0x17aeb069194f654e74ab75307b3a3014f233db57	false	68	12849585	2021-07-18T08:35:09.000Z	0xf5868ff9dc0727389b9747f31919996ad659ff977c4710a6c6d1acaef13ada19	4000000000000

Example Query

Query with partition filter

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

LoanFactory_LoanCreated_event

Loan origination events from Maple Finance V1 protocol on Ethereum, capturing new undercollateralized loans issued to institutional borrowers with USDC (liquidity asset) and WBTC (collateral asset). Used for analyzing Maple’s institutional lending activity, loan terms (interest rates in basis points from in_specs), and borrower relationships.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_loan`	`STRING`	Contract address of the loan being created, claimed, funded, or liquidated. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityAsset`	`STRING`	Contract address of the asset used for loan funding in the Maple protocol. Consistently USDC (0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48) across sample loans on Ethereum.
`in_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralLocker`	`STRING`	Contract address of the locker holding collateral assets for this Maple loan. Remains constant throughout the loan lifecycle and is unique per loan.
`in_fundingLocker`	`STRING`	Contract address of the funding locker managing the liquidity for this loan. This locker holds the borrowed assets before disbursement to the borrower.
`in_specs`	`STRING`	Comma-separated loan specification parameters including APR in basis points, term length, payment cadence, and principal amount. Values represent the core financial terms of the Maple protocol loan at creation time.
`in_calcs`	`STRING`	Contract addresses for calculator contracts used in the loan (repayment, late fee, premium calculators). Comma-separated list of three hex-encoded Ethereum addresses that determine loan payment calculations.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.

Sample Data

address	in_loan	in_name	removed	in_calcs	in_specs	in_symbol	log_index	in_borrower	block_number	block_timestamp	in_fundingLocker	transaction_hash	in_liquidityAsset	in_collateralAsset	in_collateralLocker
0x908cc851bc757248514e060ad8bd0a03908308ee	0xf50bcf9593c0e16ca199db0f650710717cbb5966	Maple Loan Token	false	0x7d622bb6ed13a599ec96366fa95f2452c64ce602,0x8dc5aa328142aa8a008c25f66a77eaa8e4b46f3c,0xe88ab4cf1ec06840d16fed69c964ad9daff5c6c2	1050,180,30,5000000000000,0	MPL-LOAN	310	0x12de80ec58568218c2762b3deee7d17cf6a64f0c	13332007	2021-10-01T07:10:45.000Z	0xe3717c1879d92f5832c27d42fd6fb7abbc1a94f1	0xa4ae85bb41791c54a44d7eed90fd03fb9f95e41595e247a966f67072efeb9e7d	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x6810e62d0f50f6faca93b5dd2c89d19d92be3f4c
0x908cc851bc757248514e060ad8bd0a03908308ee	0xabd35e9556f6e17c267285f58b108b1a53d639fe	Maple Loan Token	false	0x7d622bb6ed13a599ec96366fa95f2452c64ce602,0x8dc5aa328142aa8a008c25f66a77eaa8e4b46f3c,0xe88ab4cf1ec06840d16fed69c964ad9daff5c6c2	1125,180,30,3000000000000,0	MPL-LOAN	235	0x61be14477ca25571e197ecc6addb895c67618010	13397052	2021-10-11T11:33:39.000Z	0xf1283fbf847dab4a6ecbdbd9d4e02fefb46a2437	0x0cd94ddbc2ec0945a36ed4e11231ac4612e48e9c0737c8a8b864b207a39f13c8	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0xe17df9b4309e89d1c68e4f5ee9ba65bdc5ba0346
0x908cc851bc757248514e060ad8bd0a03908308ee	0x05eff408e8301f8135d703dd643383d4a6f47000	Maple Loan Token	false	0x7d622bb6ed13a599ec96366fa95f2452c64ce602,0x8dc5aa328142aa8a008c25f66a77eaa8e4b46f3c,0xe88ab4cf1ec06840d16fed69c964ad9daff5c6c2	975,90,30,1000000000000,0	MPL-LOAN	59	0x720f0db5b69eb7752a076fadf6ffbfae81900985	13400278	2021-10-11T23:38:03.000Z	0x6bee492cf37cb2ced68cde3f158dc6222434c6fb	0x58309e7132d42e36edada2b0c7200f82a718ee07c3da3cb5f3f0559bc72a4184	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x78f3a8734be403309364749ee711f7ff9097df1d

Example Query

Query with partition filter

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

MapleLoan_Funded_event

Loan funding events from Maple Finance V1 on Ethereum, recording when lenders provide capital to borrowers with funding amounts, lender addresses, and next payment due dates. Used for analyzing lending activity, capital deployment patterns, and loan origination metrics in the Maple protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_lender_`	`STRING`	Ethereum address of the lender providing funds to the Maple loan contract. Hex-encoded, 0x-prefixed 40-character string representing the entity funding the loan.
`in_amount_`	`STRING`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_nextPaymentDueDate_`	`STRING`	Unix timestamp indicating when the next loan payment is scheduled to be due. Represents a future date typically 30-90 days from loan funding based on the payment schedule terms.

Sample Data

address	removed	log_index	in_amount_	in_lender_	block_number	block_timestamp	transaction_hash	in_nextPaymentDueDate_
0x323bca025f293f9663f3162ff6cbc8edb8cf02b5	false	243	10000000000000	0xba88ccc288faaa376ac8678050eefad5a46818e9	14721288	2022-05-06T03:51:45.000Z	0x7708e9ebe46763b60b0cdb1d4490c6515bfe3b0a95d1fa65f0e01470fee57697	1654401105
0x2e8d2efea5584ebe00c94a206473a70b3c556c0a	false	276	15000000000000	0xd87fca365219c8c1998f525952a338c4a56ed214	14408354	2022-03-18T04:53:42.000Z	0xa26dc92b156a6051e7b039001bdd36673db6df109ca6dc01caeaf01e6199c74d	1650171222
0xe5cb98fadf3c95115d0dce37e83819a5cc3c9983	false	327	2000000000000	0x601843a01685ea4a5a9b10df28d11195f2cce6f1	14613087	2022-04-19T03:05:01.000Z	0x518c65b1febe4b749afd298b5d2f87653bffb2b7040b66494267f20863d05a9b	1652929501

Example Query

Query with partition filter

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

MapleLoanFactory_InstanceDeployed_event

Loan deployment events from Maple Finance v1 protocol on Ethereum, capturing when new loan contracts are instantiated through the factory with their initialization parameters and version numbers. Used for tracking loan origination activity and analyzing protocol growth across different contract 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_
0x36a7350309b2eb30f3b908ab0154851b5ed81db0	false	198	300	15739428	0x91a4eee4d33d9cd7840cae21a4f408c0919f555d	2022-10-13T13:14:59.000Z	0x8dce45cb5962dcaf90227dc1849b0c56de8ba099223af9791a70ee41eb8c6b8a	0x000000000000000000000000a8c37d20d9632ce2e6fff4b027af77e5c4e23e1f0000000000000000000000002260fac5e5542a773aa44fbcfedf7c193bc2c599000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000697800000000000000000000000000000000000000000000000000000000000278d000000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003635c9adc5dea0000000000000000000000000000000000000000000000000003635c9adc5dea00000000000000000000000000000000000000000000000000000011c37937e08000000000000000000000000000000000000000000000000000000470de4df820000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b1a2bc2ec50000
0x36a7350309b2eb30f3b908ab0154851b5ed81db0	false	92	300	15739738	0x2cb5c20309b2dbfdda758237f20c94b5f72d0331	2022-10-13T14:17:35.000Z	0x6e85f301f4c278dd1d75bceecfce0856371a874f784624b929fcba7f5b313aea	0x00000000000000000000000007b6c7bc3d7dc0f36133b542ea51aa7ac560e9740000000000000000000000002260fac5e5542a773aa44fbcfedf7c193bc2c599000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000697800000000000000000000000000000000000000000000000000000000000278d00000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d8d726b7177a8000000000000000000000000000000000000000000000000000d8d726b7177a80000000000000000000000000000000000000000000000000000000f8b0a10e47000000000000000000000000000000000000000000000000000000470de4df820000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b1a2bc2ec50000
0x36a7350309b2eb30f3b908ab0154851b5ed81db0	false	244	200	14499481	0x1fb75317a2dc8430449fc3fd0be206785fb63cbb	2022-04-01T09:16:10.000Z	0xa4c4ef4c4249f881cbb113c41f93986173f1eb06ff8f8dadc5e627e26f8a0e9c	0x000000000000000000000000160834291e67aa55f830062ca8a47186b5e319a90000000000000000000000002260fac5e5542a773aa44fbcfedf7c193bc2c599000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000000000697800000000000000000000000000000000000000000000000000000000000278d00000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005f5e1000000000000000000000000000000000000000000000000000000000005f5e100000000000000000000000000000000000000000000000000016737eb35e2700000000000000000000000000000000000000000000000000000470de4df820000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b1a2bc2ec50000

Example Query

Query with partition filter

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

MapleLoanV2_PaymentMade_event

Payment events from Maple Finance V2 loan contracts on Ethereum, recording interest and principal repayments with associated delegate and treasury fee distributions for analyzing institutional DeFi lending 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_principalPaid_`	`STRING`	Amount of loan principal repaid in this payment transaction, denominated in the loan’s token and represented in the smallest unit (wei for ETH-based tokens). Often zero for interest-only payments, non-zero when principal is being paid down.
`in_interestPaid_`	`STRING`	Amount of interest paid in this loan payment transaction, denominated in the smallest unit of the loan’s token. Values are typically non-zero while principal payments may be zero in interest-only payments.
`in_delegateFeePaid_`	`STRING`	Amount of fees paid to the Maple protocol delegate as part of this loan payment. Denominated in the smallest unit of the loan’s token (wei for ETH-based tokens), typically representing a percentage of the interest payment.
`in_treasuryFeePaid_`	`STRING`	Amount of protocol treasury fees paid in this loan payment, denominated in the loan token’s smallest unit (wei for ETH-based tokens). This value represents the platform’s revenue share from the interest payment.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_interestPaid_	transaction_hash	in_delegateFeePaid_	in_treasuryFeePaid_
0x1154db30d92b1d504719738a13c754b77cf6b75d	false	169	15794288	2022-10-21T05:07:35.000Z	12328767123287670000	0xcaf8269553ceb00418465a1e0ee4999aeef294938c06c83642664be296a498ac	542465753424657534	1084931506849315068
0x0beaa8b67b039db80357ef8336006ffde144fd89	false	98	15796770	2022-10-21T13:26:23.000Z	90410958904	0xa8d8a94615165c01dcf525ee53c975e5a594f8dd4caf1db14571a4075eac18b7	2712328767	5424657534
0xf6950f28353ca676100c2a92dd360dea16a213ce	false	101	15794471	2022-10-21T05:44:23.000Z	147945205479	0xde6360b903ee82120dee4e7269dc1a2e6d2a021b7033d1cd2d244bfc8dc20497	4068493150	8136986301

Example Query

Query with partition filter

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

MplRewards_RewardPaid_event

MPL token reward distribution events from Maple Finance V1 protocol on Ethereum. Records rewards paid to liquidity providers and stakers, tracking recipient accounts and reward amounts denominated in wei.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_reward	log_index	in_account	block_number	block_timestamp	transaction_hash
0x7869d7a3b074b5fa484dc04798e254c9c06a5e90	false	429185538626561048245	139	0xa13b9db1587db796829eefa7718b98a5bed7ab35	15492184	2022-09-07T19:35:59.000Z	0xc5c8843637924b4bc5b8563b1c86f0ee1f4cd60e18723075e3ee273bd65bd1a3
0x7869d7a3b074b5fa484dc04798e254c9c06a5e90	false	8033933035620840000	137	0x0521ca372321b20b7a59abac4d71a4e3112806ad	15489788	2022-09-07T10:31:56.000Z	0xf3b60c01e3c7b7ebbc482942d38bf8f5eae70d798f79e1e8352afa7b36167aa9
0x7869d7a3b074b5fa484dc04798e254c9c06a5e90	false	76004755406242800000	79	0xceefc019b987bc06f2609563f8342b8e7c6069a1	15487275	2022-09-07T00:43:36.000Z	0x9e05639c8cf1156a6b8eb417041b00cd1326d958a71b23f523992856ac7c3a98

Example Query

Query with partition filter

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

MplRewardsFactory_MplRewardsCreated_event

MPL rewards contract deployment events from Maple Finance v1 on Ethereum. Tracks creation of staking reward contracts with MPL token as rewards, linking staking tokens to their corresponding rewards distribution contracts for analyzing Maple’s liquidity mining programs.

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_rewardsToken`	`STRING`	Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
`in_stakingToken`	`STRING`	Contract address of the token that users stake to earn rewards in this Maple v1 rewards contract. Hex-encoded, 0x-prefixed 40-character Ethereum address.
`in_mplRewards`	`STRING`	Contract address of the newly deployed MPL (Maple) rewards contract instance created by this factory event. Hex-encoded, 0x-prefixed 40-character string representing the reward distribution contract for a specific staking pool.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_owner	log_index	block_number	in_mplRewards	block_timestamp	in_rewardsToken	in_stakingToken	transaction_hash
0x0155729ebcd47cb1fba02bf5a8da20faf3860535	false	0xd6d4bcde6c816f17889f1dd3000af0261b03a196	75	13595491	0xd0123f5220a36e9ec6082d83b4a11f92aa48ccd0	2021-11-11T14:37:31.000Z	0x33349b282065b0284d756f0577fb39c158f935e6	0xd618d93676762a8e3107554d9adbff7dfd7fbf47	0xa5c8465b4cc1bd62455cacad62f3ed9feb97da590bd07b426947981384b85edb
0x0155729ebcd47cb1fba02bf5a8da20faf3860535	false	0xd6d4bcde6c816f17889f1dd3000af0261b03a196	44	14347611	0x0a76c7913c94f2af16958fbdf9b4cf0bbdb159d8	2022-03-08T17:53:59.000Z	0x33349b282065b0284d756f0577fb39c158f935e6	0x1a066b0109545455bc771e49e6edef6303cb0a93	0x4312fc015e864bb2f2d2186ca023991e8c3cf936c79fc515cd0ca445df975d23
0x0155729ebcd47cb1fba02bf5a8da20faf3860535	false	0xd6d4bcde6c816f17889f1dd3000af0261b03a196	299	12780726	0x7c57bf654bc16b0c9080f4f75ff62876f50b8259	2021-07-07T14:07:51.000Z	0x33349b282065b0284d756f0577fb39c158f935e6	0x6f6c8013f639979c84b756c7fc1500eb5af18dc4	0xcf51e9746a106af8293be306dba1bff12c03af89cf01734b1a0305cf815c203c

Example Query

Query with partition filter

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

Pool_Claim_event

Loan repayment claim events from Maple Finance V1 lending pools on Ethereum, capturing principal and interest distributions to stake lockers and pool delegates. Used for analyzing lender yield distribution and loan settlement 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_loan`	`STRING`	Contract address of the loan being created, claimed, funded, or liquidated. 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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_stakeLockerPortion`	`STRING`	Amount of interest allocated to stakeLocker participants as their portion of the claim distribution. Denominated in the smallest unit of the pool’s underlying token (e.g., wei for USDC pools with 6 decimals).
`in_poolDelegatePortion`	`STRING`	Portion of the interest and fees allocated to the pool delegate for this loan claim. Denominated in the pool’s base token (typically USDC), with values commonly in the range of hundreds of millions to billions of smallest units.

Sample Data

address	in_loan	removed	log_index	in_interest	block_number	in_principal	block_timestamp	transaction_hash	in_stakeLockerPortion	in_poolDelegatePortion
0xfebd6f15df3b73dc4307b1d7e65d46413e710c27	0x249b5907564f0cf3fb771b013a6f9f33e1225657	false	80	28931506849	16085610	0	2022-11-30T21:54:11.000Z	0xdd5f9c6db4fd6fb3092d69cb08197aa78300dcd929879e720a1be68df086f435	3616438356	3616438356
0xfebd6f15df3b73dc4307b1d7e65d46413e710c27	0x1fb75317a2dc8430449fc3fd0be206785fb63cbb	false	144	1826482	16084918	100000000	2022-11-30T19:34:11.000Z	0x17c44671316a532e6b855f788c14018947d23e1a0f6852caafb8dc151821ed6b	228310	228310
0xfebd6f15df3b73dc4307b1d7e65d46413e710c27	0x129137f0f3e7177607e3edacc386f7d8e21b4450	false	99	657535	16084922	100000000	2022-11-30T19:34:59.000Z	0x900ac4154765275d0ba9fd04134b11fc8932cdd7c5148fd607e3a54e997ce439	82191	82191

Example Query

Query with partition filter

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

Pool_DefaultSuffered_event

Loan default events from Maple Finance v1 lending pools on Ethereum, tracking losses incurred when borrowers fail to repay and the corresponding Balancer Pool Token (BPT) burns and returns. Used for analyzing protocol credit risk, pool performance, and liquidity provider losses during default scenarios.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_loan`	`STRING`	Contract address of the loan being created, claimed, funded, or liquidated. Hex-encoded, 0x-prefixed, 42-character string.
`in_defaultSuffered`	`STRING`	Amount of principal loss incurred by the pool due to loan default, denominated in the pool’s liquidity asset (typically USDC or wETH). Value is in wei/smallest unit, so divide by token decimals for human-readable amount.
`in_bptsBurned`	`STRING`	Balance Pool Tokens (BPTs) that were burned as a result of the loan default. Represents the amount of pool share tokens destroyed during the default recovery process, denominated in the smallest unit (wei-equivalent).
`in_bptsReturned`	`STRING`	Balance Pool Tokens (BPTs) returned to the pool when a loan default occurs. Represented as a wei-denominated integer string, typically in the hundreds of quintillions based on sample data.
`in_liquidityAssetRecoveredFromBurn`	`STRING`	Amount of liquidity tokens recovered from burning Balancer Pool Tokens (BPTs) during a loan default event. Denominated in the pool’s base asset (typically USDC or wETH), represented as an integer with the asset’s native decimal precision.

Sample Data

address	in_loan	removed	log_index	block_number	in_bptsBurned	block_timestamp	in_bptsReturned	transaction_hash	in_defaultSuffered	in_liquidityAssetRecoveredFromBurn
0xfebd6f15df3b73dc4307b1d7e65d46413e710c27	0x323bca025f293f9663f3162ff6cbc8edb8cf02b5	false	73	15115192	250021532179609691115	2022-07-10T13:38:41.000Z	493734500845728318584	0x303a46d086d335b602f772e91a99c18a25bfd71fb83cc810ea2e352d4c810202	10000000000000	2147853799302

Example Query

Query with partition filter

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

Pool_LoanFunded_event

LoanFunded events from Maple Finance v1 lending pools on Ethereum, recording when pool capital is deployed to borrowers with loan contract addresses, debt locker references, and funded amounts in wei. Used for tracking institutional lending activity and pool capital deployment across Maple’s credit 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_loan`	`STRING`	Contract address of the loan being created, claimed, funded, or liquidated. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtLocker`	`STRING`	Contract address of the DebtLocker contract managing the funded loan’s repayment terms and liquidation logic. Hex-encoded, 0x-prefixed 40-character Ethereum address created to custody and enforce loan obligations.
`in_amountFunded`	`STRING`	Amount funded to the loan in the pool’s underlying token, denominated in the smallest unit (wei). Values range from trillions to quadrillions, representing USDC or other stablecoin amounts with their native decimal precision.

Sample Data

address	in_loan	removed	log_index	block_number	in_debtLocker	block_timestamp	in_amountFunded	transaction_hash
0xd618d93676762a8e3107554d9adbff7dfd7fbf47	0xff351aa6d1e3e4fc21fc5b6275838eb2b0518490	false	306	13772316	0xb6a5d4e6f0f9324e558bf76205b796e7d0b9b521	2021-12-09T17:17:11.000Z	25000000000000	0x0d6a17be965068013cb89bc36e6f07014bc307025d2044bd5dcdd1f4f25b99db
0x6f6c8013f639979c84b756c7fc1500eb5af18dc4	0x1a733df2d0cb01c0cee221ed0533b3c038bc1945	false	80	14378407	0xb7d5a904668ffcc62e275f97ee623f24d60d1db9	2022-03-13T12:52:16.000Z	10000000000000	0x6a267cec10829c9e2ffa7f48175141231ea23dc4c3e3b1eb69ed389ac60c4d8c
0x1a066b0109545455bc771e49e6edef6303cb0a93	0x1628325bb8898626a1656d1c9c3c11b8d8cbb426	false	415	14378399	0x099f0728cb9b70007bf3a93471d2734cc092cd8a	2022-03-13T12:50:03.000Z	2400000000000000000000	0x6fdc9aaee8d388c5adddbfadbc4d754330aeec864a61ec7e87b7bd4597c12546

Example Query

Query with partition filter

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

PoolFactory_PoolCreated_event

Pool creation events emitted by factory contracts when new liquidity pools are deployed. Records the pool address, token pair or configuration parameters, and fee structure for tracking pool deployments across decentralized exchange protocols.

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_delegate`	`STRING`	Contract address of the pool delegate who manages this Maple lending pool. The delegate is responsible for underwriting loans and managing pool strategy on behalf of liquidity providers.
`in_liquidityAsset`	`STRING`	Contract address of the asset deposited by liquidity providers into the pool. Based on sample values, typically USDC (0xa0b8…) or WETH (0xc02a…) on Ethereum.
`in_stakeAsset`	`STRING`	Contract address of the asset token used for staking in this Maple lending pool. Typically MPL token (0xc1b10e536cd611acff7a7c32a9e29ce6a02ef6ef) or similar governance tokens.
`in_liquidityLocker`	`STRING`	Contract address of the liquidity locker contract associated with this Maple pool. This contract manages the custody and withdrawal logic for liquidity provider deposits.
`in_stakeLocker`	`STRING`	Contract address of the stake locker associated with this Maple pool. Holds staked tokens (typically MPL) from liquidity providers as collateral for the lending pool.
`in_stakingFee`	`STRING`	Fee amount allocated to staking rewards or staking pool participants. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_delegateFee`	`STRING`	Percentage fee paid to the pool delegate for managing the Maple lending pool, expressed in basis points (e.g., 1000 = 10%). Can be zero if no delegate fee is charged for that pool.
`in_liquidityCap`	`STRING`	Maximum amount of liquidity asset that can be deposited into this pool, specified in the asset’s smallest denomination (e.g., wei for ETH, base units for USDC). Defined at pool creation and enforced to cap total pool deposits.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.

Sample Data

address	in_name	in_pool	removed	in_symbol	log_index	in_delegate	block_number	in_stakeAsset	in_stakingFee	in_delegateFee	in_stakeLocker	block_timestamp	in_liquidityCap	transaction_hash	in_liquidityAsset	in_liquidityLocker
0x2cd79f7f8b38b9c0d80ea6b230441841a31537ec	Maple Pool Token	0xfebd6f15df3b73dc4307b1d7e65d46413e710c27	false	MPL-LP	79	0xa6ccb9483e3e7a737e3a4f5b72a1ce51838ba122	12462376	0xc1b10e536cd611acff7a7c32a9e29ce6a02ef6ef	1000	1000	0x12b2bbbfab2ce6789df5659e9ac27a4a91c96c5c	2021-05-19T03:15:09.000Z	13000000000000	0x9f50036d80429f5956fc8bed866915293cd24f7754dd154d8b98c5e31a49ee7c	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xb5321058e209e0f6c1216a7c7922b6962681dd77
0x2cd79f7f8b38b9c0d80ea6b230441841a31537ec	Maple Pool Token	0x6f6c8013f639979c84b756c7fc1500eb5af18dc4	false	MPL-LP	124	0x8b4aa04e9642b387293ce6fffa42715a9cd19f3c	12771988	0xc1b10e536cd611acff7a7c32a9e29ce6a02ef6ef	1000	1000	0xbb7866435b8e5d3f6c2ea8b720c8f79db6f7c1b4	2021-07-06T05:17:26.000Z	20085000000000	0x8c80af8e064aab3fd9b8c94502afca11bbb5d75a73482cac5015ce0cfaf34786	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xaaf126daea17f689d4f1753fccb559f0bbacc49e
0x2cd79f7f8b38b9c0d80ea6b230441841a31537ec	Maple Pool Token	0xcc8058526de295c6ad917cb41416366d69a24cde	false	MPL-LP	105	0xab38a4e78a0549f60df1a78f15f35f03f39f11f4	15303255	0xc1b10e536cd611acff7a7c32a9e29ce6a02ef6ef	0	1000	0x15d297b15a631d1f3b53a337d31bdd2d950d5402	2022-08-08T18:52:07.000Z	40000000000000	0x78a23f4d7d60f85be65a280eb61b5e44d6d7afda878ffa6749134f827a48c8e5	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xd19d150cb6dd3d774454480cbfaaa79d06b3ecd3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Loan_Drawdown_event

LoanFactory_LoanCreated_event

MapleLoan_Funded_event

MapleLoanFactory_InstanceDeployed_event

MapleLoanV2_PaymentMade_event

MplRewards_RewardPaid_event

MplRewardsFactory_MplRewardsCreated_event

Pool_Claim_event

Pool_DefaultSuffered_event

Pool_LoanFunded_event

PoolFactory_PoolCreated_event

​Tables

​Loan_Drawdown_event

​LoanFactory_LoanCreated_event

​MapleLoan_Funded_event

​MapleLoanFactory_InstanceDeployed_event

​MapleLoanV2_PaymentMade_event

​MplRewards_RewardPaid_event

​MplRewardsFactory_MplRewardsCreated_event

​Pool_Claim_event

​Pool_DefaultSuffered_event

​Pool_LoanFunded_event

​PoolFactory_PoolCreated_event

Tables

Loan_Drawdown_event

LoanFactory_LoanCreated_event

MapleLoan_Funded_event

MapleLoanFactory_InstanceDeployed_event

MapleLoanV2_PaymentMade_event

MplRewards_RewardPaid_event

MplRewardsFactory_MplRewardsCreated_event

Pool_Claim_event

Pool_DefaultSuffered_event

Pool_LoanFunded_event

PoolFactory_PoolCreated_event