morpho_v3_sonic

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	in_feeShares	block_timestamp	transaction_hash	in_newTotalAssets
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	25	19638957	0	2025-04-11T18:33:35.000Z	0x1fd9697f660b50ef1c52926a513a4f713142d545cf7add0e411a3f604ba5cf86	96311118
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	33	19639656	0	2025-04-11T18:37:55.000Z	0x028c202c522f687757e42023d9c67a6aec443f65f103f144719deb99641ccee8	96511118
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	22	19638439	999999927015	2025-04-11T18:30:17.000Z	0x6b8c41688b6a130f6fb7ba2baff35d538edcb98aa7818463adf2ef8f39ef4600	95911118

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.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
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	400000	0x1b874aae59d738079fe3e4f7d90b5793d3a51481	399999970806304228	28	19638439	2025-04-11T18:30:17.000Z	0x6b8c41688b6a130f6fb7ba2baff35d538edcb98aa7818463adf2ef8f39ef4600
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	200000	0x1b874aae59d738079fe3e4f7d90b5793d3a51481	199999985403152114	30	19638957	2025-04-11T18:33:35.000Z	0x1fd9697f660b50ef1c52926a513a4f713142d545cf7add0e411a3f604ba5cf86
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	0x0a01f4a6711012157c1b33ad9c01af7f526962f5	600000	0x1b874aae59d738079fe3e4f7d90b5793d3a51481	599999956209456342	38	19639656	2025-04-11T18:37:55.000Z	0x028c202c522f687757e42023d9c67a6aec443f65f103f144719deb99641ccee8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.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
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	2	0x3804ca0991a4d6e95981aa33975ec16acfef62bd	17734930	2025-04-02T17:57:36.000Z	0x0000000000000000000000000000000000000000	0x2e454dad5d8892d99261f0abb5aab16b29ba725029d230222da134435b0b6b9c
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	0	0xa3a1c213679fc562f95f091d2d827d01c62eea1d	20012083	2025-04-13T17:35:23.000Z	0x0000000000000000000000000000000000000000	0x0ded8fb51a33cb336475b4a55fdd2cb4ddf30270b7131a21e168a7bf72a35086
0xd7f2f89e1991de2b9d62fbeeeb3bc0b01d032328	false	6	0x0000000000000000000000000000000000000001	9101790	2025-02-21T09:59:57.000Z	0x0000000000000000000000000000000000000000	0xbaafb59e4f38d6b3093c1b6c573c5b12dd4b908894e8012fafca6d5fe878ae4b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.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
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	27	20013838	0xa3a1c213679fc562f95f091d2d827d01c62eea1d	2025-04-13T17:48:56.000Z	0xbb3d04ee6b05b65993084412bd58d020b910ce10d4e72cdd2c20c172c5acbe76

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.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
0x6ae5e57135ebd44ea1ff7f3fec4dede488aaef47	false	0x3804ca0991a4d6e95981aa33975ec16acfef62bd	150000000000000000	27	17736173	2025-04-02T18:05:34.000Z	0x05745add1e654b6b04a8598f721dba111d015c45bb4ef5511356e2506d5f6a50
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	0xa3a1c213679fc562f95f091d2d827d01c62eea1d	150000000000000000	36	20013838	2025-04-13T17:48:56.000Z	0xbb3d04ee6b05b65993084412bd58d020b910ce10d4e72cdd2c20c172c5acbe76

Example Query

Query with partition filter

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

MetaMorphoVault_SetName_event

MetaMorpho vault name configuration events emitted when vault names are set or updated. Records administrative changes to vault display names with transaction context.

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_name`	`STRING`	Name or label identifier for the entity being created, registered, or updated in the event.

Sample Data

address	in_name	removed	log_index	block_number	block_timestamp	transaction_hash
0x2e651455c2455053dcaa02593989e0d3a4770166	CC-USDC Vault	false	14	36888821	2025-07-02T19:00:13.000Z	0xbdfb964ed8fb0b409047d9c580ca1bcd62a7484beccafb7c19ed74d5403c9e47
0x915851dfaa406d6591cac0f14b9dde7453328e4e	USDC Rezerve Vault	false	2	39213530	2025-07-19T10:06:54.000Z	0x14bf00fd54379a384c53771d46b8041338f39d4fde34b3d071f0e9307c97e727
0x24b650fbfca57e619b3cd94ff821635472069d42	RZR Rezerve Vault	false	3	39213571	2025-07-19T10:07:25.000Z	0x5238c7bd1c49f9902763329dbf5847604e837b75eab730e2e8da048fa85de24b

Example Query

Query with partition filter

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

MetaMorphoVault_SetSymbol_event

Event emitted when a MetaMorpho vault’s symbol is set or updated, recording the new symbol identifier for the vault contract. Used for tracking vault configuration changes and metadata updates 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_symbol`	`STRING`	Symbol of the token involved in the transaction or event.

Sample Data

address	removed	in_symbol	log_index	block_number	block_timestamp	transaction_hash
0x2e651455c2455053dcaa02593989e0d3a4770166	false	CCUSDC	15	36888821	2025-07-02T19:00:13.000Z	0xbdfb964ed8fb0b409047d9c580ca1bcd62a7484beccafb7c19ed74d5403c9e47
0x24b650fbfca57e619b3cd94ff821635472069d42	false	RZRrv	4	39213571	2025-07-19T10:07:25.000Z	0x5238c7bd1c49f9902763329dbf5847604e837b75eab730e2e8da048fa85de24b
0x915851dfaa406d6591cac0f14b9dde7453328e4e	false	USDCrv	3	39213530	2025-07-19T10:06:54.000Z	0x14bf00fd54379a384c53771d46b8041338f39d4fde34b3d071f0e9307c97e727

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.MetaMorphoVault_SetSymbol_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
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	26	35419219	2025-06-23T00:44:45.000Z	0x2370c3fb095e576ecee5aa27eef8cc2e8816dc579c6b54fba24b09bda4a892c4	68102753
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	36	35419219	2025-06-23T00:44:45.000Z	0x2370c3fb095e576ecee5aa27eef8cc2e8816dc579c6b54fba24b09bda4a892c4	71087768
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	16	23720684	2025-05-02T07:09:37.000Z	0xebfaa728065200908962703423fe92a181525d5498d90f84d7ca2ed70c72c98d	21122132

Example Query

Query with partition filter

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

MetaMorphoVault_UpdateLostAssets_event

Event emitted when a MetaMorpho vault updates its lost assets value, recording the new amount of unrecoverable assets. Used for vault accounting and loss tracking in 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_newLostAssets`	`STRING`	Updated amount of lost assets in the MetaMorpho vault. String-encoded integer representing the new total value of assets considered permanently lost or irrecoverable.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	1	22331671	2025-04-26T00:46:54.000Z	0x9e8e989d8fb2b9e7228bd2c83c91ebf513d3292a0fd59924bf306cf52fe88297
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	1	22333908	2025-04-26T01:03:19.000Z	0x9280dd1541f42f3ec69b98f31d16c7c781d75dad306dd025b08cb5c9eab3f9a5
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	1	22347960	2025-04-26T02:34:28.000Z	0xab4dd766f055172e8a6c94354307597c936ff7e6dc4f610964d6cfbfb0e3dc75

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.MetaMorphoVault_UpdateLostAssets_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
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	0xa3a1c213679fc562f95f091d2d827d01c62eea1d	3000000	0x31d5aee8d75eeab548cfa0d11c4f9843a5201eaf	2997285546681864877	52	0xb06f1ad8c908b958e596c42973f67f2f1d9a9aff	24902817	2025-05-07T02:48:15.000Z	0xc9833573328beb4dc425aaa805eb6a2861e832165a2e2442714c12bc04237346
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	0x0a01f4a6711012157c1b33ad9c01af7f526962f5	184738	0x31d5aee8d75eeab548cfa0d11c4f9843a5201eaf	184611505520896395	11	0xb06f1ad8c908b958e596c42973f67f2f1d9a9aff	22347960	2025-04-26T02:34:28.000Z	0xab4dd766f055172e8a6c94354307597c936ff7e6dc4f610964d6cfbfb0e3dc75
0x9c19f937e8948ae81c53d48463e06aa5f7c7a155	false	0xa3a1c213679fc562f95f091d2d827d01c62eea1d	2500067	0x31d5aee8d75eeab548cfa0d11c4f9843a5201eaf	2498359364259075717	10	0xb06f1ad8c908b958e596c42973f67f2f1d9a9aff	22331671	2025-04-26T00:46:54.000Z	0x9e8e989d8fb2b9e7228bd2c83c91ebf513d3292a0fd59924bf306cf52fe88297

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.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
0x0ce9e3512cb4df8ae7e265e62fb9258dc14f12e8		0x0000000000000000000000000000000000000000000000000000000000000000	false	0xf1e71beb3565f6bb7529e40dbd4469d8722f06bf	0x3d4af4825397bd778a3787bdfee5ae0e501fe9e2		10	9101790	0xd7f2f89e1991de2b9d62fbeeeb3bc0b01d032328	2025-02-21T09:59:57.000Z	0x0000000000000000000000000000000000000001	0xbaafb59e4f38d6b3093c1b6c573c5b12dd4b908894e8012fafca6d5fe878ae4b	0
0x0ce9e3512cb4df8ae7e265e62fb9258dc14f12e8	USDC Rezerve Vault	0x0000000000000000000000000000000000000000000000000000000000000001	false	0x29219dd400f2bf60e5a23d13be72b486d4038894	0x5f5a6e0f769bbb9232d2f6eda84790296b288974	USDCrv	5	39213530	0x915851dfaa406d6591cac0f14b9dde7453328e4e	2025-07-19T10:06:54.000Z	0x5f5a6e0f769bbb9232d2f6eda84790296b288974	0x14bf00fd54379a384c53771d46b8041338f39d4fde34b3d071f0e9307c97e727	86400
0x0ce9e3512cb4df8ae7e265e62fb9258dc14f12e8	RZR Rezerve Vault	0x0000000000000000000000000000000000000000000000000000000000000001	false	0xb4444468e444f89e1c2cac2f1d3ee7e336cbd1f5	0x5f5a6e0f769bbb9232d2f6eda84790296b288974	RZRrv	6	39213571	0x24b650fbfca57e619b3cd94ff821635472069d42	2025-07-19T10:07:25.000Z	0x5f5a6e0f769bbb9232d2f6eda84790296b288974	0x5238c7bd1c49f9902763329dbf5847604e837b75eab730e2e8da048fa85de24b	86400

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.morpho_v3_sonic.MetaMorphoVaultFactory_CreateMetaMorpho_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_SetName_event

MetaMorphoVault_SetSymbol_event

MetaMorphoVault_UpdateLastTotalAssets_event

MetaMorphoVault_UpdateLostAssets_event

MetaMorphoVault_Withdraw_event

MetaMorphoVaultFactory_CreateMetaMorpho_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MetaMorphoVault_AccrueInterest_event

​MetaMorphoVault_Deposit_event

​MetaMorphoVault_OwnershipTransferred_event

​MetaMorphoVault_SetCurator_event

​MetaMorphoVault_SetFee_event

​MetaMorphoVault_SetName_event

​MetaMorphoVault_SetSymbol_event

​MetaMorphoVault_UpdateLastTotalAssets_event

​MetaMorphoVault_UpdateLostAssets_event

​MetaMorphoVault_Withdraw_event

​MetaMorphoVaultFactory_CreateMetaMorpho_event

Tables

MetaMorphoVault_AccrueInterest_event

MetaMorphoVault_Deposit_event

MetaMorphoVault_OwnershipTransferred_event

MetaMorphoVault_SetCurator_event

MetaMorphoVault_SetFee_event

MetaMorphoVault_SetName_event

MetaMorphoVault_SetSymbol_event

MetaMorphoVault_UpdateLastTotalAssets_event

MetaMorphoVault_UpdateLostAssets_event

MetaMorphoVault_Withdraw_event

MetaMorphoVaultFactory_CreateMetaMorpho_event