morpho_v2_optimism

Tables

MorphoBlue_AccrueInterest_event

Interest accrual events from Morpho Blue lending markets containing market identifier, accrued interest amount, protocol fee shares, and previous borrow rate. Used for tracking yield generation and interest rate dynamics across lending positions.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_prevBorrowRate`	`STRING`	Borrow rate before the interest accrual event in the Morpho Blue lending market. Numeric string representation.
`in_interest`	`STRING`	Interest amount accrued or paid in the transaction. Numeric string representation in the smallest unit of the relevant token.
`in_feeShares`	`STRING`	Number of fee shares minted to the protocol during the interest accrual event. Numeric string representation of share quantity.

Sample Data

in_id	address	removed	log_index	in_interest	block_number	block_timestamp	transaction_hash	in_prevBorrowRate
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	14	6666039	138717862	2025-07-20T18:01:41.000Z	0xbf20758af4f8b70298407fbc53e7ea1d95a07297623cbca877f508f634771517	339574169
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	899	225923	138702446	2025-07-20T09:27:49.000Z	0x3ddbd1092554ccf8d14fff8304052f5a1bf112d7d63f70764f80375f66c80846	348848523
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	7	680032	138705373	2025-07-20T11:05:23.000Z	0x63be9d89d2b8e4084a4fbf27bff4e548f55f4a1d50c613f912f3415f0b2bd351	339858190

Example Query

Query with partition filter

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

MorphoBlue_Borrow_event

Borrow events from Morpho Blue lending protocol recording debt position creation. Contains market identifier, borrowed asset amount, shares issued, caller address, borrower (onBehalf), and asset recipient, used for tracking protocol lending activity and user debt positions.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`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_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_id	address	removed	in_assets	in_caller	in_shares	log_index	in_onBehalf	in_receiver	block_number	block_timestamp	transaction_hash
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	75000000000	0x79481c87f24a3c4332442a2e9faaf675e5f141f0	74815176090337377	2	0xa988f520b9a2af4132392ce732f5eee2884cb7c9	0xa988f520b9a2af4132392ce732f5eee2884cb7c9	136891085	2025-06-08T11:09:07.000Z	0x22beb429a4b1b3e29f876e6ecd8fa514da2d450d6258ed27f54eff579ce168f3
0x173b66359f0741b1c7f1963075cd271c739b6dc73b658e108a54ce6febeb279b	0xce95afbb8ea029495c66020883f87aae8864af92	false	10000000000	0x79481c87f24a3c4332442a2e9faaf675e5f141f0	9736350325306101	2	0xa988f520b9a2af4132392ce732f5eee2884cb7c9	0xa988f520b9a2af4132392ce732f5eee2884cb7c9	136891895	2025-06-08T11:36:07.000Z	0x9c4317e2b09e878f1b574792080bfff7197664023b932948e04f04b0fd821e5d
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	1150000000	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	1147165960395460	38	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	136892164	2025-06-08T11:45:05.000Z	0x24a4cdc27a43487288588271735e8c9ca16d3d782ffa3b20770167746ab98ad0

Example Query

Query with partition filter

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

MorphoBlue_CreateMarket_event

Market creation events from the Morpho Blue lending protocol, containing the unique market identifier and configuration parameters including loan token, collateral token, oracle address, interest rate model (IRM), and liquidation loan-to-value (LLTV) ratio.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_marketParams`	`STRUCT<loanToken STRING, collateralToken STRING, oracle STRING, irm STRING, lltv STRING>`	Market parameters defining a lending market. Struct containing loan token address, collateral token address, oracle address, interest rate model (IRM) address, and loan-to-value (LLTV) ratio as numeric string.

Sample Data

in_id	address	removed	log_index	block_number	block_timestamp	in_marketParams	transaction_hash
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	104	131332012	2025-01-30T18:46:41.000Z	{“irm”:“0x0000000000000000000000000000000000000000”,“lltv”:“0”,“oracle”:“0x0000000000000000000000000000000000000000”,“loanToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“collateralToken”:“0x0000000000000000000000000000000000000000”}	0xd2d630d426f554dc8d03846369e9423686fac6f14e9410bf86a97290ef5b1e63
0x67840b3ace736fe47ab919ad003e0330da50536f61f9fcb96af80d0f37a57070	0xce95afbb8ea029495c66020883f87aae8864af92	false	66	132793113	2025-03-05T14:30:03.000Z	{“irm”:“0x8cd70a8f399428456b29546bc5dbe10ab6a06ef6”,“lltv”:“385000000000000000”,“oracle”:“0x119d36383418d7d986d14ab8e6632b0f420e7c48”,“loanToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“collateralToken”:“0x4200000000000000000000000000000000000006”}	0xb0b8a3137a6236d0babaa8dc5f2a58725ace3435555db08f9d89f33ba9b20ffb
0x173b66359f0741b1c7f1963075cd271c739b6dc73b658e108a54ce6febeb279b	0xce95afbb8ea029495c66020883f87aae8864af92	false	44	132181583	2025-02-19T10:45:43.000Z	{“irm”:“0x8cd70a8f399428456b29546bc5dbe10ab6a06ef6”,“lltv”:“860000000000000000”,“oracle”:“0x6475585f7811d03063bf6817306d75f9d9e61735”,“loanToken”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“collateralToken”:“0x4200000000000000000000000000000000000006”}	0x878598f8caf3e603e2b3735d5c5594db6b731d95d16532fc3784c65f45edee11

Example Query

Query with partition filter

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

MorphoBlue_Liquidate_event

Liquidation events from Morpho Blue lending markets recording debt repayment, collateral seizure, and bad debt realization. Captures liquidator address, borrower address, market identifier, repaid and seized asset amounts in both token units and protocol shares, with separate tracking of unrecoverable bad debt.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repaidAssets`	`STRING`	Amount of borrowed asset tokens repaid during the liquidation. Numeric string representation.
`in_repaidShares`	`STRING`	Amount of debt repaid denominated in protocol share units during the liquidation. Numeric string representation.
`in_seizedAssets`	`STRING`	Amount of collateral tokens seized from the borrower during liquidation. Numeric string representation.
`in_badDebtAssets`	`STRING`	Amount of bad debt denominated in asset tokens that could not be recovered during liquidation. Numeric string representation.
`in_badDebtShares`	`STRING`	Amount of bad debt denominated in protocol share units that could not be recovered during liquidation. Numeric string representation.

Sample Data

in_id	address	removed	in_caller	log_index	in_borrower	block_number	block_timestamp	in_repaidAssets	in_repaidShares	in_seizedAssets	in_badDebtAssets	in_badDebtShares	transaction_hash
0x67840b3ace736fe47ab919ad003e0330da50536f61f9fcb96af80d0f37a57070	0xce95afbb8ea029495c66020883f87aae8864af92	false	0x17e7bb9fe7983947fdcf02c1e3d8e6c92c21da54	103	0x17e7bb9fe7983947fdcf02c1e3d8e6c92c21da54	132793906	2025-03-05T14:56:29.000Z	2	999996	7000000000000000	10000041	9999999000004	0x0360ef2746b45595a3eed37de0e9888513760b1101f9473aa322d357c21319f3
0x173b66359f0741b1c7f1963075cd271c739b6dc73b658e108a54ce6febeb279b	0xce95afbb8ea029495c66020883f87aae8864af92	false	0x4661f836f07c78a01d5490bff6e8587b9291c6b8	51	0x0373830701ec399a19e7ec423d988053b08951d8	143318522	2025-11-04T05:57:01.000Z	297301	287459681220	88853772211377	0	0	0x39714ebc7f7323fef19f10b4026bb663b3e8290ba15867eac7d5691b3a7b37cc
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	0x2992915a2a55fc5f2c9d308fb1adc2320612faf1	230	0x77819d746a876b523b0b41d942c1477f248f9137	141163865	2025-09-15T08:55:07.000Z	288168387	285943053715448	55009891448142710	0	0	0x0d3b9c178f8990d3984918a50a837dcb8a4a50b27ca815d24b41dde6ec8524ff

Example Query

Query with partition filter

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

MorphoBlue_Repay_event

Debt repayment events from Morpho Blue lending protocol. Records asset amounts repaid, borrower shares burned, market identifier, caller address, and beneficiary for tracking loan paydown activity.

Columns

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

Sample Data

in_id	address	removed	in_assets	in_caller	in_shares	log_index	in_onBehalf	block_number	block_timestamp	transaction_hash
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	7400000000	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	7361143336715290	436	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	139955732	2025-08-18T09:44:01.000Z	0x02606b22fdeed7659c140b641a7e2bc50a4d5755d836dc72ceea746c1e3852cd
0x173b66359f0741b1c7f1963075cd271c739b6dc73b658e108a54ce6febeb279b	0xce95afbb8ea029495c66020883f87aae8864af92	false	1864589122	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	1810975764076180	199	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	140737525	2025-09-05T12:03:47.000Z	0x07ad9b43d8138b4c3b2f601bffe584a3d97c0106d8db3748f95c3adfeb696535
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	298534	0xcdef0a216fcef809258aa4f341db1a5ab296ea72	296439804777	131	0xbada9c382165b31419f4cc0edf0fa84f80a3c8e5	140740306	2025-09-05T13:36:29.000Z	0xa4caa9859bef36a38226e090aaf974e55d722e5542f9bf66139c80f8ea2c97dd

Example Query

Query with partition filter

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

MorphoBlue_Supply_event

Morpho Blue supply events capturing liquidity provider deposits into lending markets. Records market identifier, depositor address, beneficiary account, asset amounts supplied, and corresponding shares minted for tracking lender positions.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`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_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_id	address	removed	in_assets	in_caller	in_shares	log_index	in_onBehalf	block_number	block_timestamp	transaction_hash
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	10500000	0x3520e1a10038131a3c00bf2158835a75e929642d	10500000000000	917	0x3520e1a10038131a3c00bf2158835a75e929642d	137695104	2025-06-27T01:49:45.000Z	0x4979066617f2bb9835b0578115f452aafea4829d151570ee929e8e9df98b063b
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	200000000000	0x3520e1a10038131a3c00bf2158835a75e929642d	200000000000000000	21	0x3520e1a10038131a3c00bf2158835a75e929642d	137721681	2025-06-27T16:35:39.000Z	0x31401758cba57b33baa916a127688316f806c9793966da909d6f995515c902b3
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	128080000	0x3520e1a10038131a3c00bf2158835a75e929642d	128080000000000	104	0x3520e1a10038131a3c00bf2158835a75e929642d	137717789	2025-06-27T14:25:55.000Z	0xe94c26df862119a6b667b05b796159dc03f56ff0e7a21dab3d9a1c68160cd315

Example Query

Query with partition filter

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

MorphoBlue_SupplyCollateral_event

Collateral deposit events from Morpho Blue lending markets recording the caller address, market identifier, beneficiary address, and collateral amount supplied. Used for tracking collateral positions and user lending activity across Morpho protocols.

Columns

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

Sample Data

in_id	address	removed	in_assets	in_caller	log_index	in_onBehalf	block_number	block_timestamp	transaction_hash
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	22011216906140467	0x275b0b1f5fae1dd696abf1cdbe7506723e14a3aa	6	0x275b0b1f5fae1dd696abf1cdbe7506723e14a3aa	143130050	2025-10-30T21:14:37.000Z	0x03e626c3c462917e671e61bb75578137f305fc9b9f77e975691eae7c6148e6a2
0x173b66359f0741b1c7f1963075cd271c739b6dc73b658e108a54ce6febeb279b	0xce95afbb8ea029495c66020883f87aae8864af92	false	54350000000000000	0x79481c87f24a3c4332442a2e9faaf675e5f141f0	23	0x450b7ee6c008f7c87009a7d845ef82bcc71ea279	143132218	2025-10-30T22:26:53.000Z	0x3ab27bc7247ab82253cf0fce5ad2161d01e7fa89713b8743acd218e08ed316bf
0x8e77af0efaf4a3d59f37126c77f6f0ee7b56bcb1363c0986b8f6087b93ba833e	0xce95afbb8ea029495c66020883f87aae8864af92	false	280573	0x79481c87f24a3c4332442a2e9faaf675e5f141f0	122	0x450b7ee6c008f7c87009a7d845ef82bcc71ea279	143132317	2025-10-30T22:30:11.000Z	0xa57e695abc69e53eb4ecc25b708b270535bc381c378f640ff6841d268ee2928e

Example Query

Query with partition filter

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

MorphoBlue_Withdraw_event

Withdraw event logs from Morpho Blue lending protocol containing market identifier, withdrawn asset amounts, share amounts, and participant addresses (caller, onBehalf, receiver). Used for tracking liquidity removals and position closures across Morpho 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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`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_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

in_id	address	removed	in_assets	in_caller	in_shares	log_index	in_onBehalf	in_receiver	block_number	block_timestamp	transaction_hash
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	1003680157	0x3520e1a10038131a3c00bf2158835a75e929642d	1003680157000000	12	0x3520e1a10038131a3c00bf2158835a75e929642d	0x3520e1a10038131a3c00bf2158835a75e929642d	136509961	2025-05-30T15:24:59.000Z	0x2f1dd684daf9f2794e42347f933ab15971def8edf4fcd9d060369bd32a7e811e
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	602208166	0x3520e1a10038131a3c00bf2158835a75e929642d	602208166000000	27	0x3520e1a10038131a3c00bf2158835a75e929642d	0x3520e1a10038131a3c00bf2158835a75e929642d	136517237	2025-05-30T19:27:31.000Z	0xe68143545941043620c14b914275f24d2ef99f2c621715db8cb02d3c49e8a4c4
0xff239fbfcc8fc3b579ee12496554a51f0187e2fa04e44d6439dca4ed79c167c8	0xce95afbb8ea029495c66020883f87aae8864af92	false	7527601741	0x3520e1a10038131a3c00bf2158835a75e929642d	7527601741000000	13	0x3520e1a10038131a3c00bf2158835a75e929642d	0x3520e1a10038131a3c00bf2158835a75e929642d	136514491	2025-05-30T17:55:59.000Z	0xa378988dd13801432cb86dd3472975a788bbe990c34873bb592c438915be3c26

Example Query

Query with partition filter

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

MorphoBlue_WithdrawCollateral_event

Collateral withdrawal events from Morpho Blue lending markets. Records the caller, beneficiary, recipient, market identifier, and withdrawn asset amount for tracking position liquidations and user collateral management.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`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_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.

Sample Data

in_id	address	removed	in_assets	in_caller	log_index	in_onBehalf	in_receiver	block_number	block_timestamp	transaction_hash
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	2000000000000000000	0x0d3758942ecd2a02312641f5f991900352b4cbdb	10	0x0d3758942ecd2a02312641f5f991900352b4cbdb	0x0d3758942ecd2a02312641f5f991900352b4cbdb	139799194	2025-08-14T18:46:05.000Z	0xf3ed2c08562eb13efbea264a0054ac271f8437fef9bde7561dc047ab71266cbb
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	1000000000000000000	0x0d3758942ecd2a02312641f5f991900352b4cbdb	46	0x0d3758942ecd2a02312641f5f991900352b4cbdb	0x0d3758942ecd2a02312641f5f991900352b4cbdb	139799650	2025-08-14T19:01:17.000Z	0x12ede3fa77c9902aacd14e1fe50c714d09dcc3a34cd9319975dd5462d7775d27
0xc7ae57c1998c67a4c21804df606db1309b68a518ba5acc8b1dc3ffcb1b26b071	0xce95afbb8ea029495c66020883f87aae8864af92	false	67000000000000000000	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	50	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	0xff7690b1963171db50ce9a1e3ac58cf25c8dfb4c	139786136	2025-08-14T11:30:49.000Z	0xe6d0b2bcbb3e0449f462a9b4ba4ce8c8002484724180091c765da7178451b00d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MorphoBlue_AccrueInterest_event

MorphoBlue_Borrow_event

MorphoBlue_CreateMarket_event

MorphoBlue_Liquidate_event

MorphoBlue_Repay_event

MorphoBlue_Supply_event

MorphoBlue_SupplyCollateral_event

MorphoBlue_Withdraw_event

MorphoBlue_WithdrawCollateral_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MorphoBlue_AccrueInterest_event

​MorphoBlue_Borrow_event

​MorphoBlue_CreateMarket_event

​MorphoBlue_Liquidate_event

​MorphoBlue_Repay_event

​MorphoBlue_Supply_event

​MorphoBlue_SupplyCollateral_event

​MorphoBlue_Withdraw_event

​MorphoBlue_WithdrawCollateral_event

Tables

MorphoBlue_AccrueInterest_event

MorphoBlue_Borrow_event

MorphoBlue_CreateMarket_event

MorphoBlue_Liquidate_event

MorphoBlue_Repay_event

MorphoBlue_Supply_event

MorphoBlue_SupplyCollateral_event

MorphoBlue_Withdraw_event

MorphoBlue_WithdrawCollateral_event