morpho_v2_unichain

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
0x665c97ec413f4371e1c30c71153757e9b9144dfbe4284a3e910f85dedba6527d	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	22	10536386895009273	22998888	2025-07-29T00:00:47.000Z	0x048b4b657fe20b3fc1db1b452f5e0cd9d15cbebbeb633daba0e7a1b8c2b1d4e9	773237418
0xb43de588b000105917eec9ae26c138e844436aea11e22998878aad72a0f2d66a	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	26	1067920	23001124	2025-07-29T00:38:03.000Z	0x1c1ddb044faabd3ee9cea2e80a5548da3a6695cf3d22801009f5ceb7f40f7940	255796501
0x2b3053ca9550fec1ebfe153c6ad0c16b0736c641d777f3f628c60014046f202e	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	11	467642	23001404	2025-07-29T00:42:43.000Z	0x3760625a7cccba53fb7fb254aa4acc5d0f82ac89043a78a1432940bb9f7f74c4	1809060941

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	40000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	39831277341305047	6	0x454af9188845d92475c60d39bf5dea502e8f6012	0x454af9188845d92475c60d39bf5dea502e8f6012	19985656	2025-06-24T03:00:15.000Z	0x955e2ad0beed912dee476d56dc702a8168e237bcf0e8981af60401933a283242
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	500000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	497893392042667	22	0xeb5c75b3eaf996304288c0cd8b4ccab11f0ebd51	0xeb5c75b3eaf996304288c0cd8b4ccab11f0ebd51	19981432	2025-06-24T01:49:51.000Z	0x8a1bb58ff1e1b5e6f51e93e4f17e5cd19769be50e5963b6ecf30f779863b5ee9
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	140000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	139393388137310527	10	0xa3e56a7d3c97681d443de712e3d397d8d8d8a077	0xa3e56a7d3c97681d443de712e3d397d8d8d8a077	20060316	2025-06-24T23:44:35.000Z	0xadd9adced0b2c66f2479b579b1f485da78ec494336c4427b52b2ad243712dd9b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0xaa6dd8800c9af08ec7caa67192151398be0773d8dffda39dda61921a7d2e589e	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	0	25637953	2025-08-28T13:05:12.000Z	{“irm”:“0x9a6061d51743b31d2c3be75d83781fa423f53f0e”,“lltv”:“860000000000000000”,“oracle”:“0x85ebed8e29bdae1e302afaa764dc95df822d1a67”,“loanToken”:“0xf9876a59d279fac5f41ec780e73e7ecd45ff8ae8”,“collateralToken”:“0xec7d9ef3f248e35f5a1273b4ba5faf3962b6770a”}	0x4414006c7c0bfafd6088d6d3df9c3c6bb380681922e27a469a42065b3f110151
0xbe96f7d990263124100d4da6706063b6fca7eadbf92734c364bf4c4bf7e89eba	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	0	25637889	2025-08-28T13:04:08.000Z	{“irm”:“0x9a6061d51743b31d2c3be75d83781fa423f53f0e”,“lltv”:“860000000000000000”,“oracle”:“0xbebf408c1eabb94f72e20d1edae2164020e6559d”,“loanToken”:“0xf9876a59d279fac5f41ec780e73e7ecd45ff8ae8”,“collateralToken”:“0xddf8b45fbc386001ec686836e417d5af8d68e6c1”}	0xe763ed92f2d60a52f748ba6eeb8bdc8921f08ecbfe70579124c6f3200cc2b8b0
0x2bbdf03759f79d43a2e4b550c6be05cef3bf3f7ec86a7079685344e180833a71	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	1	17043298	2025-05-21T01:40:57.000Z	{“irm”:“0x0000000000000000000000000000000000000000”,“lltv”:“0”,“oracle”:“0x0000000000000000000000000000000000000000”,“loanToken”:“0x9151434b16b9763660705744891fa906f660ecc5”,“collateralToken”:“0x0000000000000000000000000000000000000000”}	0xb6adf5720a85253c9efcad3ff43746ba5b6a90d11a90816d387019aec6b308fc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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	transaction_hash
0xae4c2c8f12e170497b7282c0c257636546c7dadb56122d18cfae50defb2d6777	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	0x2c7efb37e824fa4bc4bc4e0049745360cfebf74b	6	0xdcf972e3851620d1ba5201b923391b9f6a3ba528	23261163	2025-08-01T00:52:02.000Z	1390035	1386329714555	332225003725751	0xd82fe393cf44760ba0da2b472790d20eaab2adf8f3f912c25b4b39732129a48a
0x2b3053ca9550fec1ebfe153c6ad0c16b0736c641d777f3f628c60014046f202e	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	0xbe38969605484f072a39c74e2388d4131942f381	167	0x0cfd05ce0f0ab2fd4a7643643e46133dc114cada	27772602	2025-09-22T06:02:41.000Z	303844	296901041301	282	0xb55c90a5deeb6e36a5022d77b1715405959c836ddbc78f4a1f97658aaf62f04c
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	0xbe38969605484f072a39c74e2388d4131942f381	101	0xf9cd762c75f64cca783ef7ceb41cbd8f5228685a	27772470	2025-09-22T06:00:29.000Z	8176990	8064880725119	2014386025325589	0xd84aa10d02051a4fdd805ed3fb3542b43b78d0f82fea192250015a8ab012dbe4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0xdacbdd711936b4f4bd789f0f7111e36e925d730ebd41178e36e705efd78a4aa1	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	376550860598973	0xc11329d19c2275c9e759867e879ecfceed7e30a0	373044684727076602843	5	0xed92063044f9004b27f2da5c6ed5afc1cb0188f9	29164132	2025-10-08T08:34:51.000Z	0xfa1a8fa1c8a6bcd07736f446855126f2322be3d4287d92fff7c83e1e316b7b52
0xcafaa993ba9267ad9d0b3fdbb106b8f40bf00f155234f67888370b9b997fabe6	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	1000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	971394937953	17	0xed92063044f9004b27f2da5c6ed5afc1cb0188f9	29163808	2025-10-08T08:29:27.000Z	0x111eed68d381132ec0905a66fa5ee607b233dda8c0bb407b491a958cc8e43975
0xae4c2c8f12e170497b7282c0c257636546c7dadb56122d18cfae50defb2d6777	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	5000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	4953676764389084	13	0xb497070466dc15fa6420b4781bb0352257146495	29139733	2025-10-08T01:48:12.000Z	0x5791ddb10d19cc226f1007d61d530d5e99c668848ccbb77112a1211c0cb7d7ff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0x665c97ec413f4371e1c30c71153757e9b9144dfbe4284a3e910f85dedba6527d	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	218765290000000000	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	216887557024411655596905	21	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	30244183	2025-10-20T20:35:42.000Z	0x6d220bbb947638c2afa78939b3f9a20ec7a72e1c8da93110d0be734962f7b519
0xae4c2c8f12e170497b7282c0c257636546c7dadb56122d18cfae50defb2d6777	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	18000000000	0x2c0f7e917257926ba6233b20de19d7fe3210858c	17839168794403287	21	0x2c0f7e917257926ba6233b20de19d7fe3210858c	30195386	2025-10-20T07:02:25.000Z	0xc75cca2ca1710cc147670f8de4c2d702cf2c504b31ea6d829b7e0350c7144741
0x2b3053ca9550fec1ebfe153c6ad0c16b0736c641d777f3f628c60014046f202e	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	1000040	0x38f4f3b6533de0023b9dcd04b02f93d36ad1f9f9	977432118243	15	0x38f4f3b6533de0023b9dcd04b02f93d36ad1f9f9	30240497	2025-10-20T19:34:16.000Z	0x708d4f1e6a1afb7491124c95e2641eab196e1c87c195bffa4b6ef8f86bb5d703

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	9580000000000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	6	0x1a9c40d9d468d4d4031550825b44eb7131c47035	21885112	2025-07-16T02:37:51.000Z	0x24041305ff2629f4e20df5a2b037d19d0340ef51a73a7479c0561efd847f18bc
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	9300000000000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	19	0x17c8afd739a175eacf8af5531671b222102b8083	21910427	2025-07-16T09:39:46.000Z	0x39c0ff7662efa504642e1bcc1ba424c757e7013878fac79255f2589f4afd10e4
0x24ad6142b5d61d37d046aaa7f27694e50f6420162ecef1d31e4cc150a506cbaf	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	133000000000000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	13	0x1597e4b7cf6d2877a1d690b6088668afdb045763	21943005	2025-07-16T18:42:44.000Z	0x43e1a5d4e6f38133a04a03c0a6716f79533f601a1cf73da4d41bd535cc243259

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0x665c97ec413f4371e1c30c71153757e9b9144dfbe4284a3e910f85dedba6527d	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	39600665900977051792	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	39450039213237231043194534	7	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	24048328	2025-08-10T03:31:27.000Z	0x0b4c866298b36be89ae31c1d98a3b6b140c6ed2a4ea2a904079be91158317fe4
0x665c97ec413f4371e1c30c71153757e9b9144dfbe4284a3e910f85dedba6527d	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	20584600000000000000	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	20506271599588113242028147	7	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	24050574	2025-08-10T04:08:53.000Z	0x9864a589fcdbeb0dfd3c1b8e16da28ed02a15cc52872e54d747359f06c69df8b
0x665c97ec413f4371e1c30c71153757e9b9144dfbe4284a3e910f85dedba6527d	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	48415837840672045669	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	48231515274792718571364499	12	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	0x0993ae24a988c6925d80ad61344a76b81aa0d34c	24053083	2025-08-10T04:50:42.000Z	0x9d4a36eebe847b488edcb7661ad8dfa5e5fcd789e2df216a84a65ba4970d0c04

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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
0xdacbdd711936b4f4bd789f0f7111e36e925d730ebd41178e36e705efd78a4aa1	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	140000000000000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	15	0x06c05fbac28826fa24b5fe806f239277d8b5a9fd	0x06c05fbac28826fa24b5fe806f239277d8b5a9fd	22654056	2025-07-25T00:13:35.000Z	0x343e761048dedc9acdcf21243b212a2d70bee797ea7692a897c0cdf496864705
0xdacbdd711936b4f4bd789f0f7111e36e925d730ebd41178e36e705efd78a4aa1	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	10000000000000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	9	0x06c05fbac28826fa24b5fe806f239277d8b5a9fd	0x06c05fbac28826fa24b5fe806f239277d8b5a9fd	22654930	2025-07-25T00:28:09.000Z	0x36aada8677ee34bb8a7ea8c412e1e804ee648e57b12c75dc8dc061c00ef10b5c
0xdacbdd711936b4f4bd789f0f7111e36e925d730ebd41178e36e705efd78a4aa1	0x8f5ae9cddb9f68de460c77730b018ae7e04a140a	false	140000000000000000000	0xc11329d19c2275c9e759867e879ecfceed7e30a0	24	0x06c05fbac28826fa24b5fe806f239277d8b5a9fd	0x06c05fbac28826fa24b5fe806f239277d8b5a9fd	22654400	2025-07-25T00:19:19.000Z	0x7af2cfbd11e8b6dd5b2f9b71530f78ba2dfa877ff908088936e277397bb6b07b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_unichain.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