morpho_v1_ethereum

Tables

AaveInterestRatesManager_P2PIndexesUpdated_event

Interest rate index updates from Morpho v1’s Aave integration on Ethereum, tracking peer-to-peer (P2P) and underlying pool index values for supply and borrow positions. Used for calculating accrued interest and APY analysis across Morpho’s P2P matching layer.

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__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__p2pSupplyIndex`	`STRING`	Morpho’s peer-to-peer supply index for the specified pool token, representing the cumulative interest growth rate for suppliers matched peer-to-peer. High-precision integer value (27 decimals) that increases over time as interest accrues on P2P matched supply positions.
`in__p2pBorrowIndex`	`STRING`	Morpho’s peer-to-peer borrow interest index for the specified pool token at the time of this event. Represented as a scaled integer (27 decimals) that tracks accumulated borrow interest for positions matched peer-to-peer rather than pooled.
`in__poolSupplyIndex`	`STRING`	Current supply index value from the underlying Aave pool at the time of this event. Ray-precision integer (27 decimals) representing the cumulative supply interest accrued on the pool token.
`in__poolBorrowIndex`	`STRING`	Aave pool’s current borrow index for the specified token, representing the cumulative interest accrued by borrowers. Large integer value (27-digit precision) that increases over time as interest compounds.

Sample Data

address	removed	log_index	block_number	in__poolToken	block_timestamp	transaction_hash	in__p2pBorrowIndex	in__p2pSupplyIndex	in__poolBorrowIndex	in__poolSupplyIndex
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	92	17258985	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2023-05-14T15:28:59.000Z	0xf4b6d8ea5d83deb4ddcf6cb50a1e973c1cae6c4c858f4930fe38ff113818d328	1026048563580010788848454289	1026013982438587846550838107	1172402208388451975441078639	1114698373371921581393281480
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	117	17258966	0xbcca60bb61934080951369a648fb03df4f96263c	2023-05-14T15:24:47.000Z	0x0faf8e4cb8c62daff100ab500a09547f9f005f38fc30a038cf7960f4888b8a16	1013897297678697040130450007	1014005480363692975592057796	1131165753357281564427769362	1088491376860056044971160531
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	183	17258980	0x028171bca77440897b824ca71d1c56cac55b68a3	2023-05-14T15:27:47.000Z	0x01eac3ed18ce5525d79da374c00ce7f9733919f166de4e91efd4d59c5ac2a7eb	1013709174108908821649170191	1013686669922667189782532157	1140872962752342281148508728	1085525043327103692837486503

Example Query

Query with partition filter

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

AaveV3Morph0_Borrowed_event

Borrow events from Morpho v1 optimizer for Aave V3 on Ethereum, recording when users borrow assets with borrower addresses, underlying token addresses, borrowed amounts, and peer-to-peer versus pool-matched scaled balances. Used for analyzing Morpho’s lending optimization patterns and tracking borrower behavior across matched versus pooled 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledOnPool`	`STRING`	Scaled amount of the transaction matched through the underlying lending pool. Numeric string representation in smallest denomination units.
`in_scaledInP2P`	`STRING`	Scaled amount of the transaction matched through Morpho’s peer-to-peer matching mechanism. Numeric string representation in smallest denomination units.

Sample Data

address	removed	in_amount	in_caller	log_index	in_onBehalf	in_receiver	block_number	in_underlying	in_scaledInP2P	block_timestamp	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	false	3000000000000000	0x937ce2d6c488b361825d2db5e8a70e26d48afed5	61	0x937ce2d6c488b361825d2db5e8a70e26d48afed5	0x937ce2d6c488b361825d2db5e8a70e26d48afed5	17180994	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2999392520098540	2023-05-03T15:11:35.000Z	0xfd8e79ca920b860b7f5d1e4e7fb3d7ee41f05c981e4896cad8637291cf9dd95d
0x33333aea097c193e66081e930c33020272b33333	false	395349995273158	0x2b5469940fa577bc4082c6940ee4d8e97fda1b42	61	0x2b5469940fa577bc4082c6940ee4d8e97fda1b42	0x2b5469940fa577bc4082c6940ee4d8e97fda1b42	17180486	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	395271888747937	2023-05-03T13:27:11.000Z	0x6f9fbd6b01e67ac2b3cfe970cdbba4d7a6d550584ebdf8a977d9eb97b0a807f1
0x33333aea097c193e66081e930c33020272b33333	false	339162037134964	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	141	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	17181365	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	733930025307216	2023-05-03T16:26:23.000Z	0x7c39538f1b5dc542b91536c82b72fea314b958f2f39f77dc494d3626f889d9af

Example Query

Query with partition filter

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

AaveV3Morph0_Repaid_event

Debt repayment events from Morpho v1’s Aave V3 optimizer on Ethereum, tracking when users repay borrowed assets through peer-to-peer or pool-based positions. Contains repayment amounts, underlying token addresses (such as WETH), and whether the repayment was settled peer-to-peer or through Aave’s 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_repayer`	`STRING`	Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledOnPool`	`STRING`	Scaled amount of the transaction matched through the underlying lending pool. Numeric string representation in smallest denomination units.
`in_scaledInP2P`	`STRING`	Scaled amount of the transaction matched through Morpho’s peer-to-peer matching mechanism. Numeric string representation in smallest denomination units.

Sample Data

address	removed	in_amount	log_index	in_repayer	in_onBehalf	block_number	in_underlying	in_scaledInP2P	block_timestamp	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	false	367041122983006	182	0x9741f57417e290480a688d62b2ab32d1bbdbd9de	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	17181509	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	366965023021787	2023-05-03T16:55:35.000Z	0x6bf35d215f0730f52e5faf7eed05489692a15c3e50ba35d30ee18af8d88d6c2b
0x33333aea097c193e66081e930c33020272b33333	false	367090449589536	100	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	17193820	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0	2023-05-05T10:25:23.000Z	0x81a9bdb195c6ad0003809b87eb49bb3db76778662d3bf6c5af09c4fd2de38b61
0x33333aea097c193e66081e930c33020272b33333	false	70054098110490604	141	0xc100c251bdd297a66795112f04356e6ba5f89d80	0xc100c251bdd297a66795112f04356e6ba5f89d80	17244207	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0	2023-05-12T12:43:59.000Z	0xaf53d798ccafeac7396785464bdbd29d3423204a49d88299265abefdcb592f4b

Example Query

Query with partition filter

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

AaveV3Morpho_Borrowed_event

Borrow event logs from Morpho v1 protocol on Ethereum, capturing debt positions created through Aave V3 integration with underlying asset amounts, scaled pool and peer-to-peer balances, and borrower addresses. Used for analyzing lending market activity, interest rate optimization between pool and P2P matching, and borrower behavior 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledOnPool`	`STRING`	Scaled amount of the transaction matched through the underlying lending pool. Numeric string representation in smallest denomination units.
`in_scaledInP2P`	`STRING`	Scaled amount of the transaction matched through Morpho’s peer-to-peer matching mechanism. Numeric string representation in smallest denomination units.

Sample Data

address	removed	in_amount	in_caller	log_index	in_onBehalf	in_receiver	block_number	in_underlying	in_scaledInP2P	block_timestamp	in_scaledOnPool	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	false	23000000000000000000	0x391a5d025b8d9d7033cddad1db516c8324f56c53	327	0x391a5d025b8d9d7033cddad1db516c8324f56c53	0x540a83e36e5e6aa916a6c591934d800e17115048	17469636	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0	2023-06-13T07:37:59.000Z	22670192635885127640	0x4f111556bd8807344e244deb899cf9edda4d11ec8b25e1681c6fb54b62e3ed53
0x33333aea097c193e66081e930c33020272b33333	false	18899000000000000	0x241f872b5668655c9843c61e1f28a3e3e6e74e44	116	0x241f872b5668655c9843c61e1f28a3e3e6e74e44	0x241f872b5668655c9843c61e1f28a3e3e6e74e44	19952670	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	18384645663242923	2024-05-26T07:50:35.000Z	0	0xd18442c23c843c4f2eb8fc7ceff730cf04d67497e5a7fd083e72b1baf6fb19f4
0x33333aea097c193e66081e930c33020272b33333	false	202275000000000005684	0xc7372ab5dd315606db799246e8aa112405abaeff	25	0xc7372ab5dd315606db799246e8aa112405abaeff	0xc7372ab5dd315606db799246e8aa112405abaeff	19053807	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0	2024-01-21T07:40:47.000Z	1642398195402906509734	0x0ccbd8c0214acc980972a8849b5f21fe5bf71527ab7343fc8c5162bd19d3c4a9

Example Query

Query with partition filter

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

AaveV3Morpho_CollateralSupplied_event

Collateral deposit events from Morpho’s Aave V3 optimizer on Ethereum, recording when users supply assets as collateral with amounts, scaled balances, and beneficiary addresses. Used for tracking collateral positions and supply flow analysis across Morpho-optimized Aave markets.

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_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledBalance`	`STRING`	User’s aToken balance after the collateral supply transaction, scaled to remove accrued interest and reflect the base deposit amount. Denominated in the underlying asset’s smallest unit (wei for ETH-based tokens).

Sample Data

address	in_from	removed	in_amount	log_index	in_onBehalf	block_number	in_underlying	block_timestamp	in_scaledBalance	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	false	2310503120972808761029	18	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	18597953	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2023-11-18T09:52:11.000Z	5460868454574964857305	0x53104f203c55642177daf298ebfd98d12731396deef0b509cf3bd8f7dcb1a58f
0x33333aea097c193e66081e930c33020272b33333	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	false	391000000000000000000	73	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	18597938	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2023-11-18T09:49:11.000Z	3151545984336999413991	0xd12e85caca36d7eb6fd07a1465710db8068ad379525f329e41b378b4b1159134
0x33333aea097c193e66081e930c33020272b33333	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	false	261615000000000000000	46	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	18597850	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2023-11-18T09:31:11.000Z	3021612413486126627386	0x352bb5a87191435b481ef1a764858d52988af623279419ef66712da2f2140475

Example Query

Query with partition filter

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

AaveV3Morpho_CollateralWithdrawn_event

Collateral withdrawal events from Morpho’s Aave V3 optimizer on Ethereum, tracking when users remove deposited assets with withdrawal amounts, underlying token addresses, and scaled balance data. Used for analyzing user position management and capital flows in Morpho’s lending optimization layer.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledBalance`	`STRING`	Scaled balance of collateral remaining in the account after the withdrawal on Morpho’s Aave V3 optimizer. Denominated in the underlying asset’s smallest unit (wei for ETH-based tokens); zero indicates complete withdrawal of position.

Sample Data

address	removed	in_amount	in_caller	log_index	in_onBehalf	in_receiver	block_number	in_underlying	block_timestamp	in_scaledBalance	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	false	59604229881668686248	0xa4ca19e4ec56571f617ab37353c4cff679b12a2d	164	0xa4ca19e4ec56571f617ab37353c4cff679b12a2d	0xa4ca19e4ec56571f617ab37353c4cff679b12a2d	17374057	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2023-05-30T20:16:23.000Z	0	0xb6a52c07d06afc4edf96f71f39a9ffbabab7275d84511a1bf81d2b839a07c632
0x33333aea097c193e66081e930c33020272b33333	false	55500000000000000000	0xa4ca19e4ec56571f617ab37353c4cff679b12a2d	250	0xa4ca19e4ec56571f617ab37353c4cff679b12a2d	0xa4ca19e4ec56571f617ab37353c4cff679b12a2d	17374028	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2023-05-30T20:10:35.000Z	59582728689389932898	0xc376b042c78fff4ad421748099f4bc4f1b1f00dcc81566ea22f4da8914e4668f
0x33333aea097c193e66081e930c33020272b33333	false	4031633767197172737693	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	339	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	21243309	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2024-11-22T12:35:47.000Z	7340873512732098404864	0x02f8fd03e98e3036c2f5da391547520b8f99ffd6301a8305b16c325782e9dcb6

Example Query

Query with partition filter

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

AaveV3Morpho_IndexesUpdated_event

Interest rate index updates from Morpho’s Aave V3 optimizer on Ethereum, tracking peer-to-peer and pool supply/borrow rates for underlying assets. Used for calculating accrued interest and analyzing yield optimization between Morpho’s P2P matching and Aave’s lending pools.

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_underlying`	`STRING`	Contract address of the underlying asset. Hex-encoded, 0x-prefixed, 42-character string.
`in_poolSupplyIndex`	`STRING`	Current supply index for the underlying asset in the Aave V3 pool at the time of the event. Represented as a high-precision integer scaled by 1e27 (ray units), typically starting near 1e27 and gradually increasing.
`in_p2pSupplyIndex`	`STRING`	Peer-to-peer supply index for the underlying asset in Morpho’s matching engine at the time of the event. Represented as a scaled integer (ray format with 27 decimals) tracking accrued interest for suppliers matched peer-to-peer.
`in_poolBorrowIndex`	`STRING`	Current borrow index for the underlying asset in the Aave V3 pool at the time of this event. Scaled integer value (typically 27 decimals) representing the cumulative interest accrued on borrows.
`in_p2pBorrowIndex`	`STRING`	Peer-to-peer borrow index for the underlying asset in Morpho’s matching engine at the time of the event. Represented as a ray-precision integer (27 decimals) used to calculate accrued interest for borrowers matched peer-to-peer.

Sample Data

address	removed	log_index	block_number	in_underlying	block_timestamp	transaction_hash	in_p2pBorrowIndex	in_p2pSupplyIndex	in_poolBorrowIndex	in_poolSupplyIndex
0x33333aea097c193e66081e930c33020272b33333	false	121	18399011	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-10-21T13:34:35.000Z	0x098ea32a42b0584b2829f2394cec0fa86dfcd2ed983d809b29c5e373e4f7c710	1013865658961674028357741179	1013864516749602519188733424	1027127420156835728667424423	1014381269900368684447800996
0x33333aea097c193e66081e930c33020272b33333	false	514	18399019	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-10-21T13:36:11.000Z	0x141490be795ef897de67a9b5230d073ab0e023c6dfc3371fc65a5f8fc6c9424a	1013865743667689320900379402	1013864601455522382684790003	1027127516914692173683549396	1014381329430689631037066668
0x33333aea097c193e66081e930c33020272b33333	false	119	18397990	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	2023-10-21T10:08:23.000Z	0x5ac83b1c2428849ec914ea24b2bbf31bf4c415e5195b0b9ffa51114f9215e44a	1000108304454634025165997561	1000108304454634025165997561	1003100764394839892696453679	1000507560295401368616338125

Example Query

Query with partition filter

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

AaveV3Morpho_P2PTotalsUpdated_event

Peer-to-peer lending activity events from Morpho’s Aave V3 optimizer on Ethereum, tracking scaled total supply and borrow amounts for underlying assets. Used for monitoring direct lender-borrower matching volumes and tracking Morpho’s capital efficiency improvements over standard Aave pools.

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_underlying`	`STRING`	Contract address of the underlying asset. Hex-encoded, 0x-prefixed, 42-character string.
`in_scaledTotalSupplyP2P`	`STRING`	Total peer-to-peer supply volume for the underlying asset, scaled by Aave V3’s interest rate index at the time of the event. Represented as an integer in the smallest token unit (wei for ETH), tracking matched supply positions outside the traditional liquidity pool.
`in_scaledTotalBorrowP2P`	`STRING`	Scaled total amount borrowed peer-to-peer (P2P) for the underlying asset in Morpho’s Aave V3 integration, represented as an integer string in the asset’s smallest unit. This value is scaled by the protocol’s interest rate index and updates when P2P matching occurs between lenders and borrowers.

Sample Data

address	removed	log_index	block_number	in_underlying	block_timestamp	transaction_hash	in_scaledTotalBorrowP2P	in_scaledTotalSupplyP2P
0x33333aea097c193e66081e930c33020272b33333	false	181	17943920	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-08-18T20:01:23.000Z	0x66d2b9b8f1f44a741f33aed84570a2333ddfda88957fb712492594713e8ac9a1	42655016883152012563893	42655064937970372871937
0x33333aea097c193e66081e930c33020272b33333	false	260	17940682	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-08-18T09:07:47.000Z	0xce828be671dbb84c0073800943ba2f902357f9e7010e89fb21dd700871b290c4	44181392156789931576121	44181441931211093244385
0x33333aea097c193e66081e930c33020272b33333	false	486	17939827	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-08-18T06:15:11.000Z	0x3b25ceea6d1ca43da9250e53fd849d65ecee7ae25328dad4a6127b7c8fb59ac6	33848765452442688238076	33848803586205007302605

Example Query

Query with partition filter

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

AaveV3Morpho_Repaid_event

Debt repayment events from Morpho Protocol V1 on Ethereum optimizing AAVE V3 positions, tracking amounts repaid across peer-to-peer (P2P) and pool-based lending markets. Records repayer and beneficiary addresses with scaled position values for analyzing debt reduction patterns and liquidity distribution between Morpho’s P2P matching layer and underlying AAVE pools.

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_repayer`	`STRING`	Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledOnPool`	`STRING`	Scaled amount of the transaction matched through the underlying lending pool. Numeric string representation in smallest denomination units.
`in_scaledInP2P`	`STRING`	Scaled amount of the transaction matched through Morpho’s peer-to-peer matching mechanism. Numeric string representation in smallest denomination units.

Sample Data

address	removed	in_amount	log_index	in_repayer	in_onBehalf	block_number	in_underlying	in_scaledInP2P	block_timestamp	in_scaledOnPool	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	false	102000000000000000000	95	0xf99e3796f94000462f736925cf32162fea82c168	0x316be293c8f2380769e7b7e7382679fe5a3b6600	18422188	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	48927058907151202056	2023-10-24T19:25:59.000Z	153453761929888389743	0x77e350b804df6f66e03f90f1bbbe984714085a88eaddff258da84668fc6373e6
0x33333aea097c193e66081e930c33020272b33333	false	1000000000000000000000	280	0xb5b29320d2dde5ba5bafa1ebcd270052070483ec	0xb5b29320d2dde5ba5bafa1ebcd270052070483ec	18418309	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	31976823399799112841271	2023-10-24T06:23:11.000Z	18733318616070233679653	0x48c4057ccfc17192449aaf3ed64b206a3226752444d70de49529a62aebad9373
0x33333aea097c193e66081e930c33020272b33333	false	505000000000000000000	134	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	0x4f962bb0ea0785c539f8ab52a17f1f873ddc355f	20675996	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	13961180085688342728248	2024-09-04T08:23:11.000Z	0	0xcfb67eab5462c889fd7e9eeef561fb2e259407c3e2a434c6e29ec95ba74fdf06

Example Query

Query with partition filter

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

AaveV3Morpho_Supplied_event

Supply events from Morpho v1’s Aave V3 optimizer on Ethereum, tracking deposits of underlying assets with peer-to-peer (P2P) and pool allocation amounts. Used for analyzing lending supply flows and capital efficiency between Morpho’s P2P matching layer and Aave’s liquidity pools.

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_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledOnPool`	`STRING`	Scaled amount of the transaction matched through the underlying lending pool. Numeric string representation in smallest denomination units.
`in_scaledInP2P`	`STRING`	Scaled amount of the transaction matched through Morpho’s peer-to-peer matching mechanism. Numeric string representation in smallest denomination units.

Sample Data

address	in_from	removed	in_amount	log_index	in_onBehalf	block_number	in_underlying	in_scaledInP2P	block_timestamp	in_scaledOnPool	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	0xc100c251bdd297a66795112f04356e6ba5f89d80	false	1000000000000000000	114	0xc100c251bdd297a66795112f04356e6ba5f89d80	17174511	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0	2023-05-02T17:16:47.000Z	994909696622309692	0x17a6f14900da04f051890f2b33027a8d2059641f75d3577a6ec063fc41076cb0
0x33333aea097c193e66081e930c33020272b33333	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	false	127457469298111110	39	0x84d3e4ee550dd5f99e76a548ac59a6be1c8dcf79	17174436	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0	2023-05-02T17:01:23.000Z	126808732464496638	0xd0a6cd55335d6276680b77be5e121a5a3f666c81feae3fd3324ad5b54605c396
0x33333aea097c193e66081e930c33020272b33333	0xf99e3796f94000462f736925cf32162fea82c168	false	100000000000000000	249	0xe98346e48c805597fd5bd05b0d9e79b9cc8dfc50	18567337	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	98465656627804260	2023-11-14T03:04:47.000Z	0	0x423b4a8ff6a4b6c101e27b7b9a149ed8ef5f7dd09f741c540881575d1ae885c8

Example Query

Query with partition filter

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

AaveV3Morpho_Withdrawn_event

Withdrawal events from Morpho Protocol’s Aave V3 optimizer on Ethereum, recording when users withdraw supplied assets including amounts, underlying tokens (primarily WETH), and whether withdrawals came from peer-to-peer or pool positions. Used for tracking liquidity movements and user activity within the Morpho lending optimization layer.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalf`	`STRING`	Address for whom the operation is being executed. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. 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_scaledOnPool`	`STRING`	Scaled amount of the transaction matched through the underlying lending pool. Numeric string representation in smallest denomination units.
`in_scaledInP2P`	`STRING`	Scaled amount of the transaction matched through Morpho’s peer-to-peer matching mechanism. Numeric string representation in smallest denomination units.

Sample Data

address	removed	in_amount	in_caller	log_index	in_onBehalf	in_receiver	block_number	in_underlying	block_timestamp	transaction_hash
0x33333aea097c193e66081e930c33020272b33333	false	50011874877437171	0x16f38d2e764e7bebf625a8e995b34968226d2f9c	439	0x9aa1c45e51ab5014ea692b351689f44d8fcab9eb	0x16f38d2e764e7bebf625a8e995b34968226d2f9c	19690385	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2024-04-19T15:30:35.000Z	0x86db9d4b1f794c6ce623c94ef7a661b32d628cec3441f876e72c4c0b240d6858
0x33333aea097c193e66081e930c33020272b33333	false	100791907572963400	0x35d1ca7a982d65c784361501e0aadb1ab1d4cc1b	169	0x35d1ca7a982d65c784361501e0aadb1ab1d4cc1b	0x35d1ca7a982d65c784361501e0aadb1ab1d4cc1b	19765085	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2024-04-30T02:17:23.000Z	0xfef1d43d29eeda554f82baa2fafad375687fe033af6f2e1cc91553a01c8bfbb9
0x33333aea097c193e66081e930c33020272b33333	false	10909861364425639942	0xb5b29320d2dde5ba5bafa1ebcd270052070483ec	124	0xb5b29320d2dde5ba5bafa1ebcd270052070483ec	0xb5b29320d2dde5ba5bafa1ebcd270052070483ec	18861456	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2023-12-25T08:05:47.000Z	0x87e3b50291bc85cb71f5dd8b36d86f45b773349a06f7f6430ef1b36467ded69b

Example Query

Query with partition filter

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

EntryPositionsManager_Borrowed_event

Borrow event logs from Morpho Protocol v1 on Ethereum, tracking when users enter leveraged positions with borrowed assets including pool token addresses, borrow amounts, and peer-to-peer (P2P) versus pool balance allocations. Used for analyzing borrowing activity, liquidity utilization patterns, and P2P matching efficiency across Morpho markets.

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 account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	block_number	in__borrower	in__poolToken	block_timestamp	in__balanceInP2P	transaction_hash
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	267	27500000000000000000000	16702036	0x5e8482a212a83b03c9cd114d3d1075022be0c469	0x028171bca77440897b824ca71d1c56cac55b68a3	2023-02-25T01:28:11.000Z	27245470223768375985252	0x82a0cad567b65d71158a5ba05773c84784be7c8dd45b5556c9f08b1d860aca31
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	216	23000000000000000000000	16702469	0x5e8482a212a83b03c9cd114d3d1075022be0c469	0x028171bca77440897b824ca71d1c56cac55b68a3	2023-02-25T02:54:47.000Z	50032518584572544905998	0xecfc527e6e50c67472362a4ebaf377a55ee6cfec873c863d972845ea88327807
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	186	1999800000	16702090	0x28177b138fdec353c1da1858798c52ac0be0a0a8	0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	2023-02-25T01:38:59.000Z	13951924161	0x661b177e71afe79d390b48c4a7af72d1dcc48c75155662defdb83e0b092a55c8

Example Query

Query with partition filter

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

EntryPositionsManager_BorrowerPositionUpdated_event

Borrower position updates from Morpho v1 protocol on Ethereum, tracking balance changes between peer-to-peer (P2P) and pool allocations for each user and pool token. Used for analyzing Morpho’s capital efficiency mechanism and user position rebalancing between P2P matching and underlying Aave pools.

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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	in__poolToken	block_timestamp	in__balanceInP2P	transaction_hash	in__balanceOnPool
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0xea36d33f049a1082783c34fc679410371cc2f565	337	16729144	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2023-02-28T20:51:47.000Z	3510798379049	0x3af53c1345390d2f9475083f8b3a76eb9761179be0a73a3286b7c60f5ecef694	683806928863
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0xea36d33f049a1082783c34fc679410371cc2f565	79	16729852	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2023-02-28T23:15:23.000Z	983894533801	0xe85fafa930c5b822a8aab16f26781388b5cc75c9c747b3a58d897edf42567094	2897392010803
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x41bc7d0687e6cea57fa26da78379dfdc5627c56d	221	16354425	0x030ba81f1c18d280636f32af80b9aad02cf0854e	2023-01-07T10:51:59.000Z	1637005813871412297412	0x5c46bc3ecb001ba3d8581cf3c150f441d5b409d8d361b1dac1cc5b4e838abc7d	1117748884472672140231

Example Query

Query with partition filter

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

EntryPositionsManager_P2PAmountsUpdated_event

Peer-to-peer (P2P) position balance updates from Morpho Protocol v1 on Ethereum, tracking supply and borrow amounts matched directly between users for each pool token. Used for analyzing Morpho’s P2P matching efficiency and liquidity utilization across Aave markets.

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__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__p2pSupplyAmount`	`STRING`	Updated peer-to-peer supply amount for the specified pool token in Morpho’s matching engine, denominated in the underlying asset’s smallest unit. This value reflects the total matched supply after a position update event, typically in wei for ETH or the token’s base unit.
`in__p2pBorrowAmount`	`STRING`	Updated peer-to-peer borrow amount for the specified pool token in Morpho V1’s matching engine, denominated in the underlying token’s smallest unit. Reflects the total amount currently matched between borrowers in the P2P market rather than being supplied to the underlying lending pool.

Sample Data

address	removed	log_index	block_number	in__poolToken	block_timestamp	transaction_hash	in__p2pBorrowAmount	in__p2pSupplyAmount
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	172	19157061	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2024-02-04T19:35:59.000Z	0xf4fba850b7522597e59f970ad3f4f953b0730882f4c351d6ee89e22b51b831bc	16687542464873	16691322646261
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	314	19155542	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2024-02-04T14:28:23.000Z	0x9892ab3c51ac4a1f1be544eaa20eb4b4716ffbdf6b219c505119adcdb8e39287	16636764848832	16640533527711
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	121	19157353	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2024-02-04T20:35:11.000Z	0xf825498965010f0106788ffdfdddfcd680db2294a97902b4d2a4afedcdffd9ce	16647039319055	16650810325381

Example Query

Query with partition filter

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

EntryPositionsManager_Supplied_event

Supply event logs from Morpho Protocol v1 on Ethereum tracking deposits into lending positions, including amounts supplied, destination pool tokens, and balance splits between peer-to-peer (P2P) and pool-based liquidity. Used for analyzing supplier behavior and liquidity allocation patterns across Morpho’s hybrid matching model.

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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__onBehalf`	`STRING`	Address of the account receiving the position or on whose behalf the transaction is executed. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__from	log_index	in__amount	block_number	in__onBehalf	in__poolToken	block_timestamp	transaction_hash	in__balanceOnPool
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x7bfee91193d9df2ac0bfe90191d40f23c773c060	166	500066163026888665225490	15585453	0x7bfee91193d9df2ac0bfe90191d40f23c773c060	0x028171bca77440897b824ca71d1c56cac55b68a3	2022-09-22T00:56:59.000Z	0xf170ca0a3c5edd62005375332c5f01a0a0f369c18b946b8c2b0aaa298c1323d6	464755454832860130524146
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0xd852e3a7a2abca6aecd0fa39147851ae96eba5d7	178	104055813536299413714	15588578	0xd852e3a7a2abca6aecd0fa39147851ae96eba5d7	0x1982b2f5814301d4e9a8b0201555376e62f82428	2022-09-22T11:27:23.000Z	0xb7c4cafe7e421c1569ca06e720cdba903cac464af82a84369cc01f49de028048	1212578179989797751389
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0xd852e3a7a2abca6aecd0fa39147851ae96eba5d7	689	454154050904158813652	15588454	0xd852e3a7a2abca6aecd0fa39147851ae96eba5d7	0x1982b2f5814301d4e9a8b0201555376e62f82428	2022-09-22T11:02:11.000Z	0xd260d5b9c728024bc3823c863624f9212dc9734b2772c7ecea01e504ecb329b9	454081558768087799123

Example Query

Query with partition filter

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

EntryPositionsManager_SupplierPositionUpdated_event

Supplier position updates from Morpho v1 lending protocol on Ethereum, tracking user balance changes between peer-to-peer (P2P) matching and underlying pool positions for each supplied asset. Used for analyzing capital efficiency and P2P matching effectiveness across different lending markets.

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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	in__poolToken	block_timestamp	in__balanceInP2P	transaction_hash	in__balanceOnPool
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x49e96e255ba418d08e66c35b588e2f2f3766e1d0	179	16869531	0x028171bca77440897b824ca71d1c56cac55b68a3	2023-03-20T14:38:35.000Z	5703003718701717936872275	0xdc640a9067619bc199ae79572353e9be9a9fe23219eec7916e6f0d989883f517	1718186409573140141074116
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x49e96e255ba418d08e66c35b588e2f2f3766e1d0	395	16865727	0x028171bca77440897b824ca71d1c56cac55b68a3	2023-03-20T01:51:11.000Z	5929678197999771571228352	0xcda2cac37221bd24514a8bda03d553d97d501a8e7299294afd2282027963a15b	1506636325728371527206595
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x68963dc7c28a36fcacb0b39ac2d807b0329b9c69	688	16872144	0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	2023-03-20T23:26:23.000Z	1716845322	0x34c32f27009d8e5f06eaf5a595b05a7f75cb2c9b5fb4b1999105170080edf3d2	53568949292

Example Query

Query with partition filter

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

ExitPositionsManager_BorrowerPositionUpdated_event

Borrower position state changes in Morpho v1 lending protocol on Ethereum, tracking balance splits between peer-to-peer (P2P) matched lending and Aave pool positions for each user and asset. Used for analyzing Morpho’s capital efficiency by monitoring how user debt is allocated between direct P2P matching versus underlying 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__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	in__poolToken	block_timestamp	in__balanceInP2P	transaction_hash	in__balanceOnPool
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x49e96e255ba418d08e66c35b588e2f2f3766e1d0	336	15754133	0x030ba81f1c18d280636f32af80b9aad02cf0854e	2022-10-15T14:32:11.000Z	1671514247435451862454	0x979a1ab2573b1ce5f5d1e04a42d11f6dd9380645d69aa7376670887e24abd96d	1503038115351950201428
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x49e96e255ba418d08e66c35b588e2f2f3766e1d0	318	15755379	0x030ba81f1c18d280636f32af80b9aad02cf0854e	2022-10-15T18:42:11.000Z	1672888625969924964799	0xffa84ff3b83b93737c72113b39436af5f19fba6c6bbaa24e1478cbd0b4771962	1501691889317372105123
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x49e96e255ba418d08e66c35b588e2f2f3766e1d0	233	15576618	0x8dae6cb04688c62d939ed9b68d32bc62e49970b1	2022-09-20T18:57:11.000Z	11086557621417420509333	0x3fc8d685e952208e76f2ae78eaf57a667865ba5bb5403374d52aae28cdcb0a40	370073568506441240815841

Example Query

Query with partition filter

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

ExitPositionsManager_Repaid_event

Debt repayment events from Morpho V1 protocol on Ethereum, tracking amount repaid, pool tokens, and account balances split between peer-to-peer (P2P) and pool positions. Used for analyzing lending position management and debt settlement 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__repayer`	`STRING`	Address of the account that executed the debt repayment transaction on Morpho protocol. May differ from `in__onBehalf` when a third party repays debt for another user.
`in__onBehalf`	`STRING`	Address of the account receiving the position or on whose behalf the transaction is executed. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	in__repayer	block_number	in__onBehalf	in__poolToken	block_timestamp	in__balanceInP2P	transaction_hash
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	489	30052217220	0xdeb08d04004ea00bb6898d19267f7d3399e2827d	18219959	0xdeb08d04004ea00bb6898d19267f7d3399e2827d	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2023-09-26T12:30:11.000Z	33190	0x315157289529faba2a38636349f2daf434a307b64af95474f8cd40a16f276e2d
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	44	99949655	0x5aff8841f8138b80c418604f96873eaa99da4705	18830282	0x5aff8841f8138b80c418604f96873eaa99da4705	0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	2023-12-20T23:07:35.000Z	1882663657	0x53f6a8abdb20cf97b502e8dd03fde87c6f09a1b47466ad62049e61aa1666bc6e
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	77	5000000000	0x6980a47bee930a4584b09ee79ebe46484fbdbdd0	18825986	0xaecdde1672f3f121b3a6c43a2e0b5dfc28f6224c	0x3ed3b47dd13ec9a98b44e6204a523e766b225811	2023-12-20T08:39:35.000Z	20241560915	0xded97aff0de21fdeed11bed58592857a648344a52f8a5871a8c999b1208d88f9

Example Query

Query with partition filter

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

ExitPositionsManager_SupplierPositionUpdated_event

Supplier position balance updates from Morpho v1 protocol on Ethereum, tracking user liquidity allocation between peer-to-peer (P2P) matching and underlying pool positions for each supported token. Used for analyzing supplier behavior, P2P matching efficiency, and position rebalancing patterns across Morpho’s optimization layer.

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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	in__poolToken	block_timestamp	in__balanceInP2P	transaction_hash
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x0edf05e4b3e076689f730d1d59da313778e1b42b	310	17580146	0x028171bca77440897b824ca71d1c56cac55b68a3	2023-06-28T20:17:35.000Z	77446526364158564494955	0x15adda9f333b2549f3bb95716f4443c7907c7926b74f9aa1c68e80752da8a982
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0xbaf0ce3ed7888ab21e028ca421664f7b6c8a3eb2	241	17576098	0xbcca60bb61934080951369a648fb03df4f96263c	2023-06-28T06:41:11.000Z	9887	0x5f1d57c657ac8be8a593460c715fda0ee84ee9d32431c01d3290e5ad05196662
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	0x6d07fa7b60cce5b70cd01842310462783b00b770	111	21538827	0xbcca60bb61934080951369a648fb03df4f96263c	2025-01-02T19:17:47.000Z	94	0xcf48528302f99a3338e9c92341cfc3771ecba54302cfacdc407225d50a9b41d3

Example Query

Query with partition filter

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

ExitPositionsManager_Withdrawn_event

Withdrawal events from Morpho v1 protocol on Ethereum, tracking when suppliers exit positions and withdraw funds from pool tokens. Records withdrawal amounts, supplier/receiver addresses, and remaining balances in peer-to-peer (P2P) and pool positions for analyzing liquidity flows and user behavior.

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__supplier`	`STRING`	Address of the user withdrawing supplied assets from their Morpho lending position. In all sampled transactions, this matches the receiver address, indicating direct withdrawals by position owners.
`in__receiver`	`STRING`	Address of the account receiving the tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolToken`	`STRING`	Address of the pool token contract on Aave. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	block_number	in__receiver	in__supplier	in__poolToken	block_timestamp	transaction_hash
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	301	125714973	20003980	0x9540cef7ac93b3ba383de26c216bd4c835958db7	0x9540cef7ac93b3ba383de26c216bd4c835958db7	0xbcca60bb61934080951369a648fb03df4f96263c	2024-06-02T11:57:23.000Z	0xd31019f73a27c9da89eb96c6924d89bbe646ea95764bfab2c1eaae98ae571de1
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	334	204165547714115015	20003970	0x9540cef7ac93b3ba383de26c216bd4c835958db7	0x9540cef7ac93b3ba383de26c216bd4c835958db7	0x030ba81f1c18d280636f32af80b9aad02cf0854e	2024-06-02T11:55:23.000Z	0xa35f4f3a0d32afff44b09827d280a3fdb58a43c34d247ea3cbd55371ef3278ae
0x777777c9898d384f785ee44acfe945efdff5f3e0	false	265	184078978	16341437	0x7724d9dc4ff230740c762466c743887d42813beb	0x7724d9dc4ff230740c762466c743887d42813beb	0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	2023-01-05T15:18:35.000Z	0x0a27da2d33b18ddf4fc1eb71cba20e1a123235c156fedf253002226eb7fab0a6

Example Query

Query with partition filter

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

InterestRatesManager_P2PIndexesUpdated_event

Interest rate index updates from Morpho v1 protocol on Ethereum, tracking peer-to-peer (P2P) and underlying pool supply/borrow indices for each market. Used for calculating accrued interest and analyzing Morpho’s rate optimization versus base lending pools like Compound.

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__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__p2pSupplyIndex`	`STRING`	Peer-to-peer supply interest rate index for the specified pool token on Morpho v1, stored as a scaled integer. This index accrues over time to calculate supplier earnings and is updated whenever interest rates change for the pool.
`in__p2pBorrowIndex`	`STRING`	Peer-to-peer borrow index for the specified pool token at the time of the update event. This index accumulates interest for borrowers matched directly with lenders on Morpho, distinct from the underlying pool’s borrow rate.
`in__poolSupplyIndex`	`STRING`	Current supply index value from the underlying lending pool (e.g., Compound, Aave) at the time of the update. High-precision integer representing the cumulative interest accrual factor for suppliers in the pool.
`in__poolBorrowIndex`	`STRING`	Pool borrow index from the underlying lending protocol at the time of the P2P index update event. Represented as a high-precision integer scaled by 10^18 (ray unit) to track accrued interest over time.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in__p2pBorrowIndex	in__p2pSupplyIndex	in__poolBorrowIndex	in__poolSupplyIndex	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	137	17496544	2023-06-17T02:26:11.000Z	0x031773d5d1baa04738c34748bfe7c008a97ec47a18ca7cb2f49f4da360c882c8	206646185955428	206418423535361	1197389774658556632	223780084437220	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	293	17499639	2023-06-17T12:50:47.000Z	0x46337dd6ddef4a7239951e1a5fe3b7039c53854a56b5c3082725a4cec38d0c18	206655658788182	206427871072150	1197453451049559438	223788037290496	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	225	17499611	2023-06-17T12:44:59.000Z	0x1ad7e8e136d573cec95cbc598c4bdaaad770f94d74c96d7d5b301dc3f8b2be7b	203471798235710	203471794066494	1274273063348487457	228909641028101	0x39aa39c021dfbae8fac545936693ac917d5e7563

Example Query

Query with partition filter

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

PositionsManager_Borrowed_event

Borrow event records from Morpho v1 lending protocol on Ethereum, tracking when users borrow assets with amounts, borrower addresses, pool token identifiers, and balance splits between peer-to-peer (P2P) and pool-based positions. Used for analyzing borrowing activity, position sizes, and Morpho’s matching efficiency between lenders and borrowers.

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 account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	block_number	in__borrower	block_timestamp	transaction_hash	in__balanceOnPool	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	96	282853880209617058119	15124019	0xd4e26683635bf3dc9ead5f31b935c33cc1ce1838	2022-07-11T22:24:04.000Z	0xbf0cf3822eaf550e5529101c33580495f2c03fffb00175b4852eeed977b9096d	932871533802185584580	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5
0x8888882f8f843896699869179fb6e4f7e3b58888	false	396	400000000000000000	16352994	0x2a03278590cd1962de28f9abc855cf3774fe3eb6	2023-01-07T06:03:35.000Z	0x6d548421eac37644ed68afcf5b65b87e6cc0de438e7ff46a51b0d1faf1b44dbb	361633672136704075	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5
0x8888882f8f843896699869179fb6e4f7e3b58888	false	207	45000000000000000000	15975349	0x1b3ddefdfcf95e9781bbed7814c3f21a7c7d0d64	2022-11-15T12:10:35.000Z	0x016704de86b7a738615140426e32a5eac2895d1d455931c1de7ad82240cffdaf	95330503329999321615	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5

Example Query

Query with partition filter

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

PositionsManager_BorrowerPositionUpdated_event

Event logs tracking borrower position changes in Morpho v1 lending protocol on Ethereum, capturing balance updates across peer-to-peer (P2P) matching and pool liquidity for each user and asset. Used for analyzing lending position movements and P2P matching efficiency.

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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	block_timestamp	in__balanceInP2P	transaction_hash	in__balanceOnPool	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	0x1778767436111ec0adb10f9ba4f51a329d0e7770	293	16957155	2023-04-01T22:06:35.000Z	18843318804725965	0xe623338d48bdf1c8a9e1725d628b4845a6ccc7acb971af4e27b4adcb5e885834	404534101466	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	0x381f45cb9814d824178448466a1eb2855ff0ecb1	159	14984175	2022-06-18T09:11:01.000Z	24011105368298	0x9b729c7443a2554796e49b83dd74330df22f5956b4e5f69ca8ae367ac7cb9302	169626273682	0x39aa39c021dfbae8fac545936693ac917d5e7563
0x8888882f8f843896699869179fb6e4f7e3b58888	false	0x381f45cb9814d824178448466a1eb2855ff0ecb1	495	14985538	2022-06-18T14:43:11.000Z	65786918382545	0xa2d15c3072ba02fc6299e6b0f9b089def97399b2e260fc8d44e67cf392a9f2d4	162885221931	0x39aa39c021dfbae8fac545936693ac917d5e7563

Example Query

Query with partition filter

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

PositionsManager_P2PAmountsUpdated_event

Peer-to-peer (P2P) matched position updates from Morpho v1 protocol on Ethereum, tracking supply and borrow amounts matched directly between users for each pool token. Used for analyzing Morpho’s capital efficiency improvements over traditional pooled lending models.

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__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__p2pSupplyAmount`	`STRING`	Peer-to-peer supply amount for the Morpho position in the specified pool token, denominated in the smallest unit of that token. This value represents the matched supply balance that earns improved rates through Morpho’s P2P matching mechanism.
`in__p2pBorrowAmount`	`STRING`	Updated peer-to-peer borrow amount for the specified pool token in the Morpho protocol, denominated in the token’s smallest unit. Values represent the total amount matched directly between borrowers and suppliers, bypassing the underlying pool.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in__p2pBorrowAmount	in__p2pSupplyAmount	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	253	17417834	2023-06-06T00:23:47.000Z	0x8635ed6b8696c07c9b9d59db807336f0ac4ef5e89965a83cc178ace913644259	815304710851530	1418062445831121	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	72	19134568	2024-02-01T15:48:23.000Z	0xdc590e96fd4a34eacf2f3b4ee5cb34f441b2a99d066b247299a0b8bdaf80e10e	27541816572945050	10407409195164833	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	406	14914880	2022-06-06T12:02:29.000Z	0x2ef76f9f7071a406001217a77af6596a84422d6b42a47b2ee8253c3c73464415	511322181588	511322181588	0x4ddc2d193948926d02f9b1fe9e1daa0718270ed5

Example Query

Query with partition filter

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

PositionsManager_Repaid_event

Debt repayment events from Morpho v1 lending protocol on Ethereum, tracking amount repaid, pool token addresses, repayer and beneficiary accounts, and remaining balances in peer-to-peer (P2P) and pool liquidity. Used for analyzing borrower repayment behavior and protocol liquidity 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__repayer`	`STRING`	Ethereum address of the account executing the debt repayment transaction on Morpho v1. This may differ from `in__onBehalf` when one address repays debt for another address.
`in__onBehalf`	`STRING`	Address of the account receiving the position or on whose behalf the transaction is executed. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	in__repayer	block_number	in__onBehalf	block_timestamp	transaction_hash	in__balanceOnPool	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	359	81737464	0x48c750b9317d4c886d206c3294f168ba5e0c144b	17670336	0x48c750b9317d4c886d206c3294f168ba5e0c144b	2023-07-11T12:21:23.000Z	0xeda7c7d88c8469fad30ebd95a06b9e2005fdfcf050e4d3d5d2373ec269edc7c8	26151952	0xccf4429db6322d5c611ee964527d42e5d685dd6a
0x8888882f8f843896699869179fb6e4f7e3b58888	false	383	65137236	0x48c750b9317d4c886d206c3294f168ba5e0c144b	17670321	0x48c750b9317d4c886d206c3294f168ba5e0c144b	2023-07-11T12:18:23.000Z	0x87a256752d654683cfb62459145d5e97c4c7b389173ef81b8ee3b1bc3745904b	101470930	0xccf4429db6322d5c611ee964527d42e5d685dd6a
0x8888882f8f843896699869179fb6e4f7e3b58888	false	222	28380000	0x48c750b9317d4c886d206c3294f168ba5e0c144b	17670358	0x48c750b9317d4c886d206c3294f168ba5e0c144b	2023-07-11T12:25:47.000Z	0x846f510c372c26380675163ce4ed2860e87bca3a893f230988214860801d5735	516	0xccf4429db6322d5c611ee964527d42e5d685dd6a

Example Query

Query with partition filter

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

PositionsManager_Supplied_event

Supply deposits from Morpho Protocol v1 on Ethereum, tracking when users deposit assets into lending pools with peer-to-peer (P2P) matching. Records show deposit amounts, supplier addresses, pool token identifiers, and balance allocation between P2P matched positions versus traditional pool deposits.

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__supplier`	`STRING`	Address of the user initiating the supply transaction to Morpho V1 protocol. This is typically the same as `in__onBehalf` when users supply for themselves.
`in__onBehalf`	`STRING`	Address of the account receiving the position or on whose behalf the transaction is executed. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	block_number	in__onBehalf	in__supplier	block_timestamp	transaction_hash	in__balanceOnPool	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	387	307115046112226222371	16673116	0x1a929b5d550c45ca8a0cfdb82f7c9c15fc278f31	0x1a929b5d550c45ca8a0cfdb82f7c9c15fc278f31	2023-02-20T23:46:23.000Z	0x9f6433ad28e80757baf2466e2ccab6ae4754315fc43e770a6e0873c374ef0e11	1510905596694	0x35a18000230da775cac24873d00ff85bccded550
0x8888882f8f843896699869179fb6e4f7e3b58888	false	330	5000000000000000000	16669160	0x7f7a70b5b584c4033cafd52219a496df9afb1af7	0x7f7a70b5b584c4033cafd52219a496df9afb1af7	2023-02-20T10:27:47.000Z	0xbe29921143abf97ec67136114bd82b2c21aae6ed8d717c43a27bca0b8cb10d82	22555753096	0x5d3a536e4d6dbd6114cc1ead35777bab948e3643
0x8888882f8f843896699869179fb6e4f7e3b58888	false	620	2100983	16670498	0x767aac0fe5c70edc8655618fd9db060c4bf1ccf8	0x767aac0fe5c70edc8655618fd9db060c4bf1ccf8	2023-02-20T14:58:23.000Z	0xd244215ce86e5249f6643001e71b2e91c3b023c91f86027be7eaf38681ac4942	176329270346955	0x39aa39c021dfbae8fac545936693ac917d5e7563

Example Query

Query with partition filter

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

PositionsManager_SupplierPositionUpdated_event

Supplier position update events from Morpho v1 protocol on Ethereum, tracking user lending balances split between peer-to-peer matching and underlying pool positions. Used for analyzing Morpho’s lending optimization and P2P matching efficiency across different token markets.

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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	in__user	log_index	block_number	block_timestamp	in__balanceInP2P	transaction_hash	in__balanceOnPool	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	0x7d0558c4b8e4ddad92989593178dd7a0bcd87ccd	119	16421104	2023-01-16T18:20:23.000Z	528283900462846	0xed7ed71bfe34305f57c79c70ede63b6fdd1d1fa612d0b4043697df827f1a3af8	0	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	0x49e96e255ba418d08e66c35b588e2f2f3766e1d0	118	16421104	2023-01-16T18:20:23.000Z	1969290481834722	0xed7ed71bfe34305f57c79c70ede63b6fdd1d1fa612d0b4043697df827f1a3af8	0	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9
0x8888882f8f843896699869179fb6e4f7e3b58888	false	0x5a4eee58744d1430876d5ca93cab5ccb763c037d	46	16419239	2023-01-16T12:06:35.000Z	22596981310293361	0xf8a5dfca31c1ba1c4b5e4b851ad99cf2f487c96b52b724e5c51c4dd0d20348d2	19915570168529586	0xf650c3d88d12db855b8bf7d11be6c55a4e07dcc9

Example Query

Query with partition filter

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

PositionsManager_Withdrawn_event

Withdrawal events from Morpho v1 lending protocol on Ethereum, tracking supplier fund removals with token amounts and balance splits between pool and peer-to-peer (P2P) positions. Used for analyzing liquidity provider behavior and capital flows across Morpho’s dual-mode lending architecture.

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__supplier`	`STRING`	Ethereum address of the user withdrawing their supplied position from Morpho. Always matches in__receiver in sample data, indicating direct withdrawals to the supplier’s own address.
`in__receiver`	`STRING`	Address of the account receiving the tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__poolTokenAddress`	`STRING`	Contract address of the pool token in the underlying lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__balanceOnPool`	`STRING`	Balance of tokens allocated to the underlying pool in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.
`in__balanceInP2P`	`STRING`	Balance of tokens allocated to peer-to-peer matching in the Morpho protocol. String-encoded integer representing token quantity in smallest unit.

Sample Data

address	removed	log_index	in__amount	block_number	in__receiver	in__supplier	block_timestamp	transaction_hash	in__balanceOnPool	in__poolTokenAddress
0x8888882f8f843896699869179fb6e4f7e3b58888	false	450	40207065	16048648	0x81646d101ad2dfb56da375e3d9da2ab1f32c0ae3	0x81646d101ad2dfb56da375e3d9da2ab1f32c0ae3	2022-11-25T18:00:47.000Z	0xd5181928fbe2768ba1590f42da3a0ea45bd7544216c80ec9438212267e7f6e16	2403733013	0xccf4429db6322d5c611ee964527d42e5d685dd6a
0x8888882f8f843896699869179fb6e4f7e3b58888	false	275	38597547	16048677	0x81646d101ad2dfb56da375e3d9da2ab1f32c0ae3	0x81646d101ad2dfb56da375e3d9da2ab1f32c0ae3	2022-11-25T18:06:35.000Z	0xe221b5b07d9c14472b521f85e041535a916307d674d83145d2d41bebb790f180	480746614	0xccf4429db6322d5c611ee964527d42e5d685dd6a
0x8888882f8f843896699869179fb6e4f7e3b58888	false	257	24627910	16048597	0x81646d101ad2dfb56da375e3d9da2ab1f32c0ae3	0x81646d101ad2dfb56da375e3d9da2ab1f32c0ae3	2022-11-25T17:50:35.000Z	0x21c7df550c767972fb89a6251e61dd19ac03505bdc3c35cbc5d4505ca084477c	4406907964	0xccf4429db6322d5c611ee964527d42e5d685dd6a

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AaveInterestRatesManager_P2PIndexesUpdated_event

AaveV3Morph0_Borrowed_event

AaveV3Morph0_Repaid_event

AaveV3Morpho_Borrowed_event

AaveV3Morpho_CollateralSupplied_event

AaveV3Morpho_CollateralWithdrawn_event

AaveV3Morpho_IndexesUpdated_event

AaveV3Morpho_P2PTotalsUpdated_event

AaveV3Morpho_Repaid_event

AaveV3Morpho_Supplied_event

AaveV3Morpho_Withdrawn_event

EntryPositionsManager_Borrowed_event

EntryPositionsManager_BorrowerPositionUpdated_event

EntryPositionsManager_P2PAmountsUpdated_event

EntryPositionsManager_Supplied_event

EntryPositionsManager_SupplierPositionUpdated_event

ExitPositionsManager_BorrowerPositionUpdated_event

ExitPositionsManager_Repaid_event

ExitPositionsManager_SupplierPositionUpdated_event

ExitPositionsManager_Withdrawn_event

InterestRatesManager_P2PIndexesUpdated_event

PositionsManager_Borrowed_event

PositionsManager_BorrowerPositionUpdated_event

PositionsManager_P2PAmountsUpdated_event

PositionsManager_Repaid_event

PositionsManager_Supplied_event

PositionsManager_SupplierPositionUpdated_event

PositionsManager_Withdrawn_event

​Tables

​AaveInterestRatesManager_P2PIndexesUpdated_event

​AaveV3Morph0_Borrowed_event

​AaveV3Morph0_Repaid_event

​AaveV3Morpho_Borrowed_event

​AaveV3Morpho_CollateralSupplied_event

​AaveV3Morpho_CollateralWithdrawn_event

​AaveV3Morpho_IndexesUpdated_event

​AaveV3Morpho_P2PTotalsUpdated_event

​AaveV3Morpho_Repaid_event

​AaveV3Morpho_Supplied_event

​AaveV3Morpho_Withdrawn_event

​EntryPositionsManager_Borrowed_event

​EntryPositionsManager_BorrowerPositionUpdated_event

​EntryPositionsManager_P2PAmountsUpdated_event

​EntryPositionsManager_Supplied_event

​EntryPositionsManager_SupplierPositionUpdated_event

​ExitPositionsManager_BorrowerPositionUpdated_event

​ExitPositionsManager_Repaid_event

​ExitPositionsManager_SupplierPositionUpdated_event

​ExitPositionsManager_Withdrawn_event

​InterestRatesManager_P2PIndexesUpdated_event

​PositionsManager_Borrowed_event

​PositionsManager_BorrowerPositionUpdated_event

​PositionsManager_P2PAmountsUpdated_event

​PositionsManager_Repaid_event

​PositionsManager_Supplied_event

​PositionsManager_SupplierPositionUpdated_event

​PositionsManager_Withdrawn_event

Tables

AaveInterestRatesManager_P2PIndexesUpdated_event

AaveV3Morph0_Borrowed_event

AaveV3Morph0_Repaid_event

AaveV3Morpho_Borrowed_event

AaveV3Morpho_CollateralSupplied_event

AaveV3Morpho_CollateralWithdrawn_event

AaveV3Morpho_IndexesUpdated_event

AaveV3Morpho_P2PTotalsUpdated_event

AaveV3Morpho_Repaid_event

AaveV3Morpho_Supplied_event

AaveV3Morpho_Withdrawn_event

EntryPositionsManager_Borrowed_event

EntryPositionsManager_BorrowerPositionUpdated_event

EntryPositionsManager_P2PAmountsUpdated_event

EntryPositionsManager_Supplied_event

EntryPositionsManager_SupplierPositionUpdated_event

ExitPositionsManager_BorrowerPositionUpdated_event

ExitPositionsManager_Repaid_event

ExitPositionsManager_SupplierPositionUpdated_event

ExitPositionsManager_Withdrawn_event

InterestRatesManager_P2PIndexesUpdated_event

PositionsManager_Borrowed_event

PositionsManager_BorrowerPositionUpdated_event

PositionsManager_P2PAmountsUpdated_event

PositionsManager_Repaid_event

PositionsManager_Supplied_event

PositionsManager_SupplierPositionUpdated_event

PositionsManager_Withdrawn_event