morpho_v2_ethereum

Tables

MetaMorphoVault_AccrueInterest_event

Interest accrual events from MetaMorpho vault contracts recording fee share distributions and updated total asset values. Emitted during vault operations to track accumulated fees and asset growth 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_newTotalAssets`	`STRING`	Updated total asset value in the vault after interest accrual. Numeric string representation of the asset quantity in the vault’s base denomination.
`in_feeShares`	`STRING`	Number of fee shares minted to the protocol during the interest accrual event. Numeric string representation of share quantity.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newTotalAssets
0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	false	193	22272018	2025-04-15T04:31:47.000Z	0xe5f5da79eaabb1f711fedeeb125a942013099e7fa64592e9cdd3eccb19d2f369	63896686876008
0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	false	193	22271342	2025-04-15T02:15:47.000Z	0x2a37080d5a6122b3b5c1fa598f8d49cd623a7883742a1d809582cb20e3971435	54738634652517
0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	false	49	22273347	2025-04-15T08:59:47.000Z	0xb87c92ef73c4f5febba261d384c076c9e9ce3c8865405bce3cd19060472b9bdb	66082672546550

Example Query

Query with partition filter

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

MetaMorphoVault_Deposit_event

Deposit events emitted by MetaMorpho vaults recording asset contributions and corresponding vault share minting. Tracks sender, owner, deposited asset amounts, and issued shares for liquidity provision analysis 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xbeef01735c132ada46aa9aa4c54623caa92a64cb	false	0x22604c0e5633a9810e01c9cb469b23eee17ac411	474551238654	0x22604c0e5633a9810e01c9cb469b23eee17ac411	451724267656761560925355	182	21113451	2024-11-04T09:40:59.000Z	0x5bfdc0209acf0a68f5d9e2b02616afc73d49ff25681731255624780bb2cf5629
0x8eb67a509616cd6a7c1b3c8c21d48ff57df3d458	false	0x321301f1b2b3f6a67df4b581d7e7ebd205a021d9	150321423193	0x321301f1b2b3f6a67df4b581d7e7ebd205a021d9	144020006023488405905528	640	21114897	2024-11-04T14:31:23.000Z	0x6111441efa68d4c6a796a16d1041ce11d8b0bc4226644df05f8fae6ce2ba0090
0x1265a81d42d513df40d0031f8f2e1346954d665a	false	0x13b6cd18b1d111aed5df669cb6fc093585461901	20307838	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	20114507422506790545	157	21116708	2024-11-04T20:35:35.000Z	0xcb9d2f8c7db0a525416791cc7731ff7dee62d95c54ea3d13e00d3e2589982d9a

Example Query

Query with partition filter

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

MetaMorphoVault_OwnershipTransferred_event

OwnershipTransferred events emitted by MetaMorpho vault contracts recording changes in vault ownership. Captures the previous owner address, new owner address, and transaction context for tracking administrative control transfers across Morpho protocol vaults.

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_previousOwner`	`STRING`	Address of the prior owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_newOwner	block_number	block_timestamp	in_previousOwner	transaction_hash
0xd63070114470f685b75b74d60eec7c1113d33a3d	false	403	0x38afc3aa2c76b4ca1f8e1daba68e998e1f4782db	20407394	2024-07-28T20:18:59.000Z	0x06590fef209ebc1f8eef83da05984cd4eff0d0e3	0xbb9a368300abf55b2bb173732a90f339fe89e588dd83164e80f83d058af24bc6
0x9a8bc3b04b7f3d87cfc09ba407dced575f2d61d8	false	156	0x06590fef209ebc1f8eef83da05984cd4eff0d0e3	20406925	2024-07-28T18:44:59.000Z	0x0000000000000000000000000000000000000000	0xe28c95211b53c1b5ade2a6bf7dd3ae873aed9ce9999a8ae3fa10c45228986e61
0x4ff4186188f8406917293a9e01a1ca16d3cf9e59	false	113	0xc684c6587712e5e7bdf9fd64415f23bd2b05faec	20663643	2024-09-02T15:00:59.000Z	0x0000000000000000000000000000000000000000	0x45f23f63b685122547a32c9dc605600005c2a595b11c314aa781b0d031a21f02

Example Query

Query with partition filter

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

MetaMorphoVault_SetCurator_event

MetaMorpho vault governance event emitted when the curator address is updated. Records the new curator address responsible for managing vault market allocations and risk parameters across Morpho protocol deployments.

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_newCurator`	`STRING`	Address of the newly assigned curator for the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_newCurator	block_timestamp	transaction_hash
0x19f91632ba0367cd7b1fc8816071cb31519e5d8a	false	313	19074640	0x6cd72b1e6e300340a48943d6af34ef5ae07d3577	2024-01-24T06:13:35.000Z	0x8ecc8d4fc5a249a1b4003e723a6a2b98b918acf684c192bcb0561e71dc8ec2c1
0xbeefc01767ed5086f35decb6c00e6c12bc7476c1	false	168	21229166	0x255c7705e8bb334dfcae438197f7c4297988085a	2024-11-20T13:11:47.000Z	0xfca86d7229500316f64ddfe6b802664547e36c8540c8c02e0629305f725301ea
0x6188c18cb1c9ef246adf4454cc184a84a4fc5465	false	264	20938134	0x384ef96c71fb94b9f2747b0d6ef4c852fc111397	2024-10-10T22:14:47.000Z	0x90b803f61ff6fb5e5537278c1f13de38ec06e27ef40edbd0748d24a0ebe8a236

Example Query

Query with partition filter

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

MetaMorphoVault_SetFee_event

Event logs emitted when a MetaMorpho vault’s fee parameter is updated by an authorized caller. Records the vault address, caller, and new fee value in wei for tracking vault fee configuration changes across Morpho protocol deployments.

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_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_caller	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0xbeef0075e03a5ce0d84d4accf3481363e0584f5c	false	0x255c7705e8bb334dfcae438197f7c4297988085a	50000000000000000	191	21043788	2024-10-25T16:21:11.000Z	0x09974aa25a49356433cbc932aa71dba83ebaff747674b1619af07d5a72e5fc28
0xc21db71648b18c5b9e038d88393c9b254cf8eac8	false	0xf92971b4d9e6257cf562400ed81d2986f28a8c26	100000000000000000	185	19303954	2024-02-25T10:19:11.000Z	0xf250143c28ea3a29be3bcfb571f1aec9c25b694c1105b14883bc86f4de59fc58
0xd63070114470f685b75b74d60eec7c1113d33a3d	false	0x38afc3aa2c76b4ca1f8e1daba68e998e1f4782db	50000000000000000	358	22682092	2025-06-11T15:03:23.000Z	0x50bbee910d63b865260a841a4c970fe5d2e931071a4174e61a511bea0685b863

Example Query

Query with partition filter

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

MetaMorphoVault_SetFeeRecipient_event

Fee recipient configuration changes for Morpho V2 MetaMorpho vaults on Ethereum. Tracks administrative updates to vault fee collection addresses for analyzing fee distribution and vault management 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_newFeeRecipient`	`STRING`	Address of the new fee recipient being set in the contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFeeRecipient
0x98cf0b67da0f16e1f8f1a1d23ad8dc64c0c70e0b	false	254	20823820	2024-09-24T23:43:47.000Z	0xba6f2443ba7fb3e3e381f3d754be9e69680803fc7b9fccc8565f09369841a1df	0x38afc3aa2c76b4ca1f8e1daba68e998e1f4782db
0x1c530d6de70c05a81bf1670157b9d928e9699089	false	247	20823490	2024-09-24T22:37:23.000Z	0xcc8408f2b6e97b5cd8ce28350ca304fada96a571806961914937160f245668fb	0x38afc3aa2c76b4ca1f8e1daba68e998e1f4782db
0xc0a14627d6a23f70c809777ced873238581c1032	false	472	20823580	2024-09-24T22:55:35.000Z	0x7aeb1b9b51fdce3af1c33e9900ff842e5789242e44eb427e008110c19bff3bd7	0x38afc3aa2c76b4ca1f8e1daba68e998e1f4782db

Example Query

Query with partition filter

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

MetaMorphoVault_UpdateLastTotalAssets_event

Event emitted when a MetaMorpho vault’s cached total assets value is updated. Records the new asset total for vault accounting and share price calculations.

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_updatedTotalAssets`	`STRING`	Updated total value of assets managed by the vault after a state change. String-encoded numeric value representing the total asset amount.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_updatedTotalAssets
0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	false	266	20369305	2024-07-23T12:42:47.000Z	0x7d1158254ce39a50ca1c294fc68c3d0743a83174350c6c9580e39296fa51ad29	5906000655769061559517270
0x2371e134e3455e0593363cbf89d3b6cf53740618	false	174	20369198	2024-07-23T12:21:23.000Z	0xb840efb5c7cb0762359ed57b7728a42eb2e3af0e76cc60d87bae36c4afab998c	6465021890515318967256
0x2371e134e3455e0593363cbf89d3b6cf53740618	false	137	20369152	2024-07-23T12:12:11.000Z	0x36facf24dbda6399b6adb1c43c083e99f516616a4292220ac74c22c8cfa37dce	6560019482947710501427

Example Query

Query with partition filter

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

MetaMorphoVault_Withdraw_event

Withdrawal events from MetaMorpho vaults recording asset redemptions for shares. Contains share owner, transaction sender, asset receiver, withdrawal amounts in both shares and underlying assets, and vault contract address for tracking vault outflows.

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_sender`	`STRING`	Address that initiated the transaction or operation. 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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	false	0x00a2913501c4b09b92b825dc8a2937efdad9953b	4004202777824	0x4a6c312ec70e8747a587ee860a0353cd42be0ae0	3725188648475479642003340	338	0x00a2913501c4b09b92b825dc8a2937efdad9953b	23159500	2025-08-17T08:11:47.000Z	0xc3f0e7e4300e926802e0bdb25bcc17ad6c723ceefa820c36aceddbc64dab6e0d
0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	false	0x2e605d3fd2f13955f946f3a35258896f6d1afc5d	242000014	0x2e605d3fd2f13955f946f3a35258896f6d1afc5d	225150544950814519945	62	0x93f20e492142a79c8a568225f8f77ee1b83d31e3	23157785	2025-08-17T02:27:59.000Z	0xda43af089e47b9944d2977c93706e6aef15d9f3ecdc3113b4a19395bccbe24dd
0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	false	0xa8c18057c5aaaaff6000d28a057a6994b2e09bfb	2000000000000	0x4a6c312ec70e8747a587ee860a0353cd42be0ae0	1860460484570014807783571	142	0xa8c18057c5aaaaff6000d28a057a6994b2e09bfb	23161852	2025-08-17T16:04:35.000Z	0xc2d952642684f5c2f29961bff0a95898e99786652bc614a2eabf6cb5f1c84269

Example Query

Query with partition filter

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

MetaMorphoVaultFactory_CreateMetaMorpho_event

MetaMorpho vault creation events emitted by the vault factory contract. Contains initialization parameters including asset address, vault name and symbol, initial owner, timelock period, and deployed vault address for tracking new MetaMorpho vault deployments across Morpho protocol instances.

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_metaMorpho`	`STRING`	Contract address of the newly created MetaMorpho vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_initialOwner`	`STRING`	Address designated as the initial owner of the newly created MetaMorpho vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_initialTimelock`	`STRING`	Initial timelock duration specified for the newly created MetaMorpho vault, measured in seconds.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_salt`	`STRING`	Cryptographic salt value used for deterministic address generation in contract deployment. 66-character hex string including 0x prefix.

Sample Data

address	in_name	in_salt	removed	in_asset	in_caller	in_symbol	log_index	block_number	in_metaMorpho	block_timestamp	in_initialOwner	transaction_hash	in_initialTimelock
0xa9c3d3a366466fa809d1ae982fb2c46e5fc41101	ZAI Vault (MAHA.xyz)	0x0000000000000000000000000000000000000000000000000000000000000000	false	0x69000dfd5025e82f48eb28325a2b88a241182ced	0x1f09ec21d7fd0a21879b919bf0f9c46e6b85ca8b	ZAIMorpho	181	21404342	0xbd4073e6e929f197a9d18e22a68c276e8b400375	2024-12-15T00:29:11.000Z	0x1f09ec21d7fd0a21879b919bf0f9c46e6b85ca8b	0xd1d96ae99edeb8369a89ac9dd95a513e1cee6fe0a9ee58df13fe34a563305533	86400
0xa9c3d3a366466fa809d1ae982fb2c46e5fc41101	Usual Boosted USDC	0x0000000000000000000000000000000000000000000000000000000000000000	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x06590fef209ebc1f8eef83da05984cd4eff0d0e3	USUALUSDC+	210	20377233	0xd63070114470f685b75b74d60eec7c1113d33a3d	2024-07-24T15:15:35.000Z	0x06590fef209ebc1f8eef83da05984cd4eff0d0e3	0x7f13d5fbdab8cd902247c96287bfcfe2d4e025e7fe1c959c7741e5af5cb6f173	86400
0xa9c3d3a366466fa809d1ae982fb2c46e5fc41101	Flagship USDT	0x74b4d8abaf8b287686ca47251ed84784f3da71f5a996e35e5b16cf8d0ddda104	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0xc79b1de842fdef5c197b9a5c37a97aa3d7cf9835	bbUSDT	215	19127039	0x2c25f6c25770ffec5959d34b94bf898865e5d6b1	2024-01-31T14:24:23.000Z	0x2566f66f68ed438726ad904524fb306a03fdb80b	0x82caa72dc50ce6b095b605219e59673f6840c679353213af7a05b80e3924c7a7	86400

Example Query

Query with partition filter

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

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
0x0eed5a89c7d397d02fd0b9b8e42811ca67e50ed5aeaa4f22e506516c716cfbbf	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	225	98516883800919	21425703	2024-12-18T00:00:47.000Z	0xc623196ea39dc679dff51e9517cc019acae51aebd6f6c0aa61a0a80db4b8cad2	1044851353
0xba761af4134efb0855adfba638945f454f0a704af11fc93439e20c7c5ebab942	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	486	93260899033584951	21425727	2024-12-18T00:05:35.000Z	0xf3b6398bfa3e16dde937c87a3e3ad88a2ac3b6197ff47ccee03a68d1fe3877ae	707432020
0x3a85e619751152991742810df6ec69ce473daef99e28a64ab2340d7b7ccfee49	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	439	338063596	21425727	2024-12-18T00:05:35.000Z	0x6261c36ed671cb191ab5e580e82c1dec31121efc088b89f17b668f8134f3623c	2553834484

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0xe475337d11be1db07f7c5a156e511f05d1844308e66e17d2ba5da0839d3b34d9	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	109130313358213909930127	0x0644f315aff90aaf7b6bf3c79678f4b2d6fd2dbf	102673985648804530321214187360	378	0x0644f315aff90aaf7b6bf3c79678f4b2d6fd2dbf	0xab515542d621574f9b5212d50593cd0c07e641bd	20355621	2024-07-21T14:50:59.000Z	0xea765f3926b1eb1246a1705d5a07ef5e6c27563c897ae00e3fbf0701b3262122
0x3a85e619751152991742810df6ec69ce473daef99e28a64ab2340d7b7ccfee49	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	100000000000	0x222ab46557acd1a1f537850297c4987e4f3621a5	95883001763395167	335	0x222ab46557acd1a1f537850297c4987e4f3621a5	0x222ab46557acd1a1f537850297c4987e4f3621a5	20357753	2024-07-21T21:59:59.000Z	0xf7ade21d79326e7a6287361d204dfc7ecb1972998918c42d94b17bc3194090fd
0x5109cda72b0603e1bac4631ddebd3104bea6414e686c3f7aa2cb3c65795602f0	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	26180747028080555065545	0x2878e0132ae0a96b27531851bd863d70eb5337ac	24890313680136546485571111364	239	0x2878e0132ae0a96b27531851bd863d70eb5337ac	0xab515542d621574f9b5212d50593cd0c07e641bd	20354786	2024-07-21T12:02:47.000Z	0x4ba49e89c90e3900e1f53dea983a8658aa7ca80ce591c91173b386a00e66f3a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0x9a9a96b822945c73eb7395edca049ba942adc597878854e4502148fa6c2480c8	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	724	21006768	2024-10-20T12:23:35.000Z	{“irm”:“0x870ac11d48b15db9a138cf899d20f13f79ba00bc”,“lltv”:“860000000000000000”,“oracle”:“0x874514c2ca3512258c5c8194a7234a06860b080b”,“loanToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“collateralToken”:“0x1202f5c7b4b9e47a1a484e8b270be34dbbc75055”}	0x151c672e4d3f2ce5526345ed623fc97bcb77b94d672cae7cfcd4afa195ffb9a2
0x278290bf72ec20495f3f57910bebac7f2f6a6aeff9e9d550f225b4ba26454fe0	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	133	22095124	2025-03-21T12:04:23.000Z	{“irm”:“0x870ac11d48b15db9a138cf899d20f13f79ba00bc”,“lltv”:“915000000000000000”,“oracle”:“0x65b6fd971e1436130020a3531417f01de127a711”,“loanToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“collateralToken”:“0xae4be3acd95b6a4ac5a0524ab95da90c721f6c83”}	0x72c4108df75464acf0b95fa4559ed851d80807c2242474d04ee47d80250cb244
0x953151614e82ac81cd978d354d7f741bf7f479cdfbe6d48818f8f9454e08657f	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	98	22095742	2025-03-21T14:08:35.000Z	{“irm”:“0x870ac11d48b15db9a138cf899d20f13f79ba00bc”,“lltv”:“915000000000000000”,“oracle”:“0x26be0b9fdaf2855428deee155b195ee802144acd”,“loanToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“collateralToken”:“0x8238884ec9668ef77b90c6dff4d1a9f4f4823bfe”}	0xbc32581a35763ac73300a00f95b55a8e73d051839764b63cc7c3fb935bf4583e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0xb48bb53f0f2690c71e8813f2dc7ed6fca9ac4b0ace3faa37b4a8e5ece38fa1a2	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	0x09f7e8515bb5587812a8783a9ff3b3847fe04755	581	0xd5a183e3cea7e3c30083b4c2323844098f6e6ab7	22067042	2025-03-17T13:54:59.000Z	61181790	48638590948685	63864079012345679013	1240530	986202255237	0x97d48dab06857be408f504bd4aded77e24a9d83cb84c7e789ef874a7abeda0aa
0xb48bb53f0f2690c71e8813f2dc7ed6fca9ac4b0ace3faa37b4a8e5ece38fa1a2	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	0x09f7e8515bb5587812a8783a9ff3b3847fe04755	235	0x9dee988b026ea87c32e4d4fc834a27228c2e3821	22067046	2025-03-17T13:55:47.000Z	61220926	48669666649426	63904932000000000000	0	0	0xbdc359eba2a627e16b4a4ba46175a48faba791b2350f42a54420c431745a0843
0xb48bb53f0f2690c71e8813f2dc7ed6fca9ac4b0ace3faa37b4a8e5ece38fa1a2	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	0x09f7e8515bb5587812a8783a9ff3b3847fe04755	546	0xe2138b953b8ca2faf36400109996c4c6c2d56dd4	22067045	2025-03-17T13:55:35.000Z	60897764	48412767095482	63567601234567901235	1479238	1175970840925	0xd176ff129dfef40aa4c9e4e1b349657e955494a28dceeea484d9e79edc4c7103

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0xc54d7acf14de29e0e5527cabd7a576506870346a78a11a6762e2cca66322ec41	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	150000000000000000000	0xa7995f71aa11525db02fc2473c37dee5dbf55107	149952621954021744160827022	149	0x9cbf099ff424979439dfba03f00b5961784c06ce	18994717	2024-01-13T01:33:23.000Z	0x4b54c434c36884b058616b909286de3142aa8f9b7b2801c1a95ca131bda33d6f
0x1247f1c237eceae0602eab1470a5061a6dd8f734ba88c7cdc5d6109fb0026b28	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	13884057054127358316759	0x005d3aa6d1a2e5efe45d8eef28f1f1470d140fea	13384251096659186470139901960	272	0x005d3aa6d1a2e5efe45d8eef28f1f1470d140fea	19897838	2024-05-18T15:51:47.000Z	0x4b36fe99da04e88071e46961f909af4df5a2b27785c2bf468119e065d05ef046
0xfd8493f09eb6203615221378d89f53fcd92ff4f7d62cca87eece9a2fff59e86f	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	300060312600000000000000	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	290731534891120350942400338786	318	0x0804fe007dce1e12d87e72bd68e84e626028c1f3	19897457	2024-05-18T14:34:35.000Z	0x480ca127ed1a32fc47f1f07b9c070ce6e031803087a67fe5035f6e801d8aa15d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0xd8909210afccc90a67730342d4a4695d437cd898164c59e2f54dfa40b53db2c0	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	14074731857542543336	0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	14035549650191988060573078	361	0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	20811429	2024-09-23T06:14:59.000Z	0xcc4624f2c8e07b9dcd688ab2871718d3ba5c0dca026cfa3e882f63ea3b5abd1d
0x6d5ceaf737f6ed7f5972c46e87d359a77d36fffa484eeddf2f8188e1605fa9d4	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	4059191344186899805269	0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	3989442798195157076299286844	366	0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	20811429	2024-09-23T06:14:59.000Z	0xcc4624f2c8e07b9dcd688ab2871718d3ba5c0dca026cfa3e882f63ea3b5abd1d
0xa42ba90e4d3013dee8eb0d7bb7ae0817297337eeecd525dbdd48c7b5c5e6988d	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	887817105538856589	0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	881476055596176904983621	351	0x125d41a6e5dbf455cd9df8f80bcc6fd172d52cc6	20811429	2024-09-23T06:14:59.000Z	0xcc4624f2c8e07b9dcd688ab2871718d3ba5c0dca026cfa3e882f63ea3b5abd1d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0xeec6c7e2ddb7578f2a7d86fc11cf9da005df34452ad9b9189c51266216f5d71b	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	822362646289631207389	0x0497da33e3b697bd24f632aaaf35c92c486809b3	332	0x0497da33e3b697bd24f632aaaf35c92c486809b3	22510410	2025-05-18T14:16:35.000Z	0x449c0958e7411f744aca7aa792ab8f2d96fff1429cac1ad7c83f1902a5fae45e
0x3f1d5c88c72432b04f2074499fe217468af49ddaa98bcb6ec80b08f76a82c6ec	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	767690833797005903317471039	0x075c10d452dae6ab9c5b494b856eb46e61c4a0ec	150	0x075c10d452dae6ab9c5b494b856eb46e61c4a0ec	22509320	2025-05-18T10:36:23.000Z	0xf8d787d0dcff71d0fd312f770d48e1f849937c3c145b9a9a5d171ab7e5896f4f
0x5f5bfaa51137098abc90b249c93b6051987877ada76135bb3dd7502b10d184a3	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	6911720419089568448318	0x08653b8218809b761f7f8d185e69113e5935aaae	320	0x08653b8218809b761f7f8d185e69113e5935aaae	22510229	2025-05-18T13:39:59.000Z	0x2760c7ece115e9dd423fa0dd6174297798f749179d4b9149d341f12c36edcb0f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0xcfe8238ad5567886652ced15ee29a431c161a5904e5a6f380baaa1b4fdc8e302	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	3429103691951657228850	0x00b6f2c15e4439749f192d10c70f65354848cf4b	3373608389014708977258388139	238	0x00b6f2c15e4439749f192d10c70f65354848cf4b	0x00b6f2c15e4439749f192d10c70f65354848cf4b	22937834	2025-07-17T08:50:11.000Z	0x418d42f14196b9b0e316c833d87af568e9826672e5b5d035a8e0d6ba48e1b588
0x5f8a138ba332398a9116910f4d5e5dcd9b207024c5290ce5bc87bc2dbd8e4a86	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	35000000000000000000	0x0c9d9fc0227ad6f571e208923414f0413f360c04	34026853863543147535019482	389	0x0c9d9fc0227ad6f571e208923414f0413f360c04	0x0c9d9fc0227ad6f571e208923414f0413f360c04	22938661	2025-07-17T11:36:11.000Z	0x7813d2bcb587ca4870c8b1ef2f9acca86750592f6e1affacaf365127ed6abc83
0x1eda1b67414336cab3914316cb58339ddaef9e43f939af1fed162a989c98bc20	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	100002206615	0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	95049830410893614	547	0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	0x0f359fd18bda75e9c49bc027e7da59a4b01bf32a	22941899	2025-07-17T22:26:11.000Z	0x2e99ea045531ceb682f810ae80f4c4332b09edb61a39796d49c79ec74b201abc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v2_ethereum.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
0x698fe98247a40c5771537b5786b2f3f9d78eb487b4ce4d75533cd0e94d88a115	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	190398200000000000	0xa7995f71aa11525db02fc2473c37dee5dbf55107	386	0x17fd03969575d46238cdd3a039a7793731545642	0x17fd03969575d46238cdd3a039a7793731545642	19252069	2024-02-18T03:36:47.000Z	0xd171a7dbd3db14b9edd0b4cb9bff24a5c0afdd189f3618f152a2b5620d48b63c
0xc54d7acf14de29e0e5527cabd7a576506870346a78a11a6762e2cca66322ec41	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	371513167665118378614	0x1c34e31a7d506e287d1100512a31bbc3d4a1f25e	98	0x1c34e31a7d506e287d1100512a31bbc3d4a1f25e	0x1c34e31a7d506e287d1100512a31bbc3d4a1f25e	19251028	2024-02-18T00:06:11.000Z	0xd667458d8e55ab011f1ff468c80f60cd39efb1e8e6606b2989848777c7f819bf
0x0eed5a89c7d397d02fd0b9b8e42811ca67e50ed5aeaa4f22e506516c716cfbbf	0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb	false	247626623824764124	0x4095f064b8d3c3548a3bebfd0bbfd04750e30077	472	0x9e75097b99a5b3e7b9e5a9f23948684f97b97fd6	0x9e75097b99a5b3e7b9e5a9f23948684f97b97fd6	21298189	2024-11-30T04:44:47.000Z	0x5e7b00e179ad7f9bf15f977fa308a7f9bfb8aeb6765206767e8b496c1dadf341

Example Query

Query with partition filter

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

UniversalRewardsDistributor_Claimed_event

Reward claim events from Morpho v2’s Universal Rewards Distributor contract on Ethereum, capturing when users claim their protocol incentives. Contains account addresses, reward token addresses, claimed amounts, and transaction details for analyzing reward distribution patterns and user claim 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_reward	log_index	in_account	block_number	block_timestamp	transaction_hash
0x330eefa8a787552dc5cad3c3ca644844b1e61ddb	false	3784476566162464561	0x9994e35db50125e0df82e4c2dde62496ce330999	812	0xfbad768340a24e06384591537d7d2f80693d6adb	21339917	2024-12-06T00:36:59.000Z	0x60ff22325a075e4110e57bb0ef15946d0e2e72ee8621674e46dd755803089963
0x330eefa8a787552dc5cad3c3ca644844b1e61ddb	false	26451070186772444404	0x58d97b57bb95320f9a05dc918aef65434969c2b2	810	0xfbad768340a24e06384591537d7d2f80693d6adb	21339917	2024-12-06T00:36:59.000Z	0x60ff22325a075e4110e57bb0ef15946d0e2e72ee8621674e46dd755803089963
0x330eefa8a787552dc5cad3c3ca644844b1e61ddb	false	46957047921154648305	0x58d97b57bb95320f9a05dc918aef65434969c2b2	311	0xf26282d4ffc90dc31b5094ad052e915fcc776c9f	21339971	2024-12-06T00:47:59.000Z	0xb8b4be8a5a8c65b05bfa0dbb51a1726f191947e3ba4242d8d2fae6b9738cedd3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MetaMorphoVault_AccrueInterest_event

MetaMorphoVault_Deposit_event

MetaMorphoVault_OwnershipTransferred_event

MetaMorphoVault_SetCurator_event

MetaMorphoVault_SetFee_event

MetaMorphoVault_SetFeeRecipient_event

MetaMorphoVault_UpdateLastTotalAssets_event

MetaMorphoVault_Withdraw_event

MetaMorphoVaultFactory_CreateMetaMorpho_event

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

UniversalRewardsDistributor_Claimed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MetaMorphoVault_AccrueInterest_event

​MetaMorphoVault_Deposit_event

​MetaMorphoVault_OwnershipTransferred_event

​MetaMorphoVault_SetCurator_event

​MetaMorphoVault_SetFee_event

​MetaMorphoVault_SetFeeRecipient_event

​MetaMorphoVault_UpdateLastTotalAssets_event

​MetaMorphoVault_Withdraw_event

​MetaMorphoVaultFactory_CreateMetaMorpho_event

​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

​UniversalRewardsDistributor_Claimed_event

Tables

MetaMorphoVault_AccrueInterest_event

MetaMorphoVault_Deposit_event

MetaMorphoVault_OwnershipTransferred_event

MetaMorphoVault_SetCurator_event

MetaMorphoVault_SetFee_event

MetaMorphoVault_SetFeeRecipient_event

MetaMorphoVault_UpdateLastTotalAssets_event

MetaMorphoVault_Withdraw_event

MetaMorphoVaultFactory_CreateMetaMorpho_event

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

UniversalRewardsDistributor_Claimed_event