mamo_v2_base

Tables

ERC20MoonwellMorphoStrategyFactory_StrategyCreated_event

Strategy deployment events from Mamo v2’s ERC20 Moonwell-Morpho factory contract on Base, capturing when users create new yield strategy instances. Used to track strategy creation activity and map user addresses to their deployed strategy contracts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_strategy`	`STRING`	Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	log_index	in_strategy	block_number	block_timestamp	transaction_hash
0x5967ea71cc65d610dc6999d7df62bfa512e62d07	0x005b43bce1a893686925c799baa7049bed8401e9	false	758	0xe6cf8c485c408dde7c55a36d2db9c1fa79b961f1	30392497	2025-05-18T13:19:01.000Z	0xad843e4a14d29e49561154251e1cb80823b8ab4c705b363c60d8fe740744e546
0x5967ea71cc65d610dc6999d7df62bfa512e62d07	0xb98bd08341ea110088d2bce3ca09ac9ad18290cf	false	241	0xc359284a1036eb3e5734674c8f0d796fdc6a98c8	31769580	2025-06-19T10:21:47.000Z	0x734f1f3d42f5cffdf3a38b0ffa02b549b69c055eb95676b51df9e9a0a0b8e259
0x5967ea71cc65d610dc6999d7df62bfa512e62d07	0xb8cfdb541e0dbb5c2e6415ea4dfff60424145283	false	260	0x3b5968da89db66cc98d2dafa0f3abedb00c11b13	31792097	2025-06-19T22:52:21.000Z	0xf7cf9703b6fc9bd1006f37d47fcb97d9f14993001ab908cbe934edc02cd951a5

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_Deposit_event

Deposit events from Moonwell’s Morpho lending strategy contracts on Base, recording asset deposits with amounts and depositor addresses. Used for tracking user deposit activity and capital flows into Moonwell-Morpho yield optimization 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_asset`	`STRING`	Contract address of the asset or token. 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_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x92f8ec5d5f41042a3e970ad01a4648fe0628b6a2	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	100000000	721	31885689	2025-06-22T02:52:05.000Z	0x48ad59070c37d5cd9315b996eb88810897af603d4df52554267ac179e4686a25
0xce6bdd380c5d1ff2835c13ea19fda457ac9b36f3	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	100000000	401	31909840	2025-06-22T16:17:07.000Z	0x319b561cadeb05bb045f2d63c6e9bb1639e8ea3eda52d994da87649032dd7568
0xbb94a883eedf02e63bbd678701936bb5aa12ff4d	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	111122025	37	31912147	2025-06-22T17:34:01.000Z	0x2728688451c11d4ce3a822f8074a072e174c58f31c542479f8fe31088b772359

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_DepositIdle_event

Idle asset deposit events from Moonwell-Morpho yield strategy vaults on Base, tracking when unallocated tokens are moved into lending positions. Used for analyzing strategy rebalancing patterns and capital efficiency across vault addresses.

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_asset`	`STRING`	Contract address of the asset or token. 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_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x16694b07e23f84536bfef08869daca11cefd0a66	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	5196372	401	38336404	2025-11-18T10:35:55.000Z	0x768b172ebc017aef3077e79627170ffadb635e36d5e27e7533111102d74d38ed
0x5d60eee06c3fe051b204236d726acba58d38ece7	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	5198358	210	38357526	2025-11-18T22:19:59.000Z	0x55aa4a46a56b76aa421b523c3e2a29ff2af1e23199bd698a039989d16be8eab7
0x5d60eee06c3fe051b204236d726acba58d38ece7	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	5292024	131	38343941	2025-11-18T14:47:09.000Z	0x2c9ce3307ca6050545136efb7b5ef18a31d60af3a2b7b02dced8eea730c40eed

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_FeeRecipientUpdated_event

No description available.

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_oldFeeRecipient`	`STRING`	-
`in_newFeeRecipient`	`STRING`	Address of the new fee recipient being set in the contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_Initialized_event

Initialization events for Moonwell Morpho strategy contracts on Base, tracking when new strategy instances are deployed with their contract addresses and version numbers. Used to identify active strategy deployments and analyze strategy creation patterns over time.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x676f5cec75ede73ca0f736803cb1bec3b29a1f3d	false	146	1	30684897	2025-05-25T07:45:41.000Z	0xb9da3449927aa47fbe9c7cc03de29d820121a9bc8ed81e7a4d12e1cba82daabd
0x55cf13286cf43456a8179b12b28bba39ca53546c	false	156	1	30696225	2025-05-25T14:03:17.000Z	0xdb8514a339de306009a2a268be8d76d78d570750840818037a7701e68f5f1054
0xe4aa15b7aaaaa07a6adb220a3a5baeaaad7f8a1e	false	188	1	30672753	2025-05-25T01:00:53.000Z	0x32b90b26348bcc342fa8d7a5a5882abd0e61bf80225b178c0c873600b2753e90

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_OwnershipTransferred_event

Ownership transfer events for MoonwellMorphoStrategy contracts on Base, recording transitions from previous owner addresses (typically zero address at initialization) to new owner addresses. Used for tracking strategy contract deployment and administrative control changes across the Moonwell-Morpho vault ecosystem.

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
0x98b8d1d533aa52c83421b7f49ba17c71042b083b	false	246	0x2980a433b4b08e8bc248786d84eae225db8d2512	31583021	2025-06-15T02:43:09.000Z	0x0000000000000000000000000000000000000000	0x295c3326f2dfa48d0c58c086f9447da40fcbd209f6dc70c011575b4ec6cfa911
0xf12408a65cff13001a92ea42e9cf88ef3470c6b3	false	3771	0x2b80500239852f8b352141719317b394e884a815	31601213	2025-06-15T12:49:33.000Z	0x0000000000000000000000000000000000000000	0x9df9055a946ff66f9b880db5b42ca81be03d3d28e754c050b6b2ba08cbbe823d
0x198efd513b2fe7df0e4d0de1ebbf1879bdf21e33	false	372	0x3a699053c46365ac331e0909507dfa261e7c5bee	31615498	2025-06-15T20:45:43.000Z	0x0000000000000000000000000000000000000000	0xfd2846bac69cefa7af1af176ca2677d89673805497ad47a7c2b0b2b512cdb90b

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_PositionUpdated_event

Position allocation updates for MAMO v2 yield optimization strategies on Base, tracking capital splits between Moonwell and Morpho lending protocols. Sample data shows allocations represented in basis points (10000 = 100% to Morpho, 0 to Moonwell).

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_splitMoonwell`	`STRING`	Allocation percentage (in basis points) of strategy capital directed to the Moonwell protocol at the time of position update. Values of ‘0’ indicate full allocation to Morpho, while 10000 would represent 100% allocation to Moonwell.
`in_splitMorpho`	`STRING`	Allocation percentage to Morpho protocol within the strategy’s position, expressed in basis points where 10000 equals 100%. Sample values show full allocation to Morpho (10000) with zero allocation to Moonwell.

Sample Data

address	removed	log_index	block_number	in_splitMorpho	block_timestamp	transaction_hash
0x45b2c2ed161116d6fbfe7157d4ec2a65283ca0f4	false	786	33842964	10000	2025-08-06T10:14:35.000Z	0x28d24eec6196e148f841b5cbeb2e04e90c778134dc04a54bb63b7c4148b2769b
0x4c2744f0c2c61aa353dd7562e681e115a19ae937	false	444	32479242	10000	2025-07-05T20:37:11.000Z	0x0cef25ff9ec3d8c3aefff96b0666acc424f4920ea5c2621954b5d9e2a8eed304
0x219703f728cc7dce0cb50b5046623bd2c75409c0	false	318	32479229	10000	2025-07-05T20:36:45.000Z	0x1039173fa0891c92c057488d9babd3323e814ef93820ef0eca86edf37459be04

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_RewardsClaimed_event

Reward distribution events from Moonwell’s Morpho strategy vaults on Base, recording token addresses and amounts claimed by strategy contracts. Used for tracking yield farming incentive payouts and analyzing reward token distribution patterns across different vault strategies.

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_rewardTokens`	`ARRAY<STRING>`	Contract addresses of reward tokens distributed in this claim event on Base chain. Array of hex-encoded addresses representing different reward token types (e.g., governance tokens, yield tokens) paid out through the Moonwell Morpho strategy.
`in_rewardAmounts`	`ARRAY<STRING>`	Array of reward token amounts claimed from the Moonwell Morpho strategy, denominated in the smallest unit of each corresponding token. Each amount is a string-formatted integer representing wei-equivalent units (e.g., 10^18 for 18-decimal tokens).

Sample Data

address	removed	log_index	block_number	block_timestamp	in_rewardTokens	in_rewardAmounts	transaction_hash
0xf9d4ecbbd66b264449fb40ba5a281c230c1a2089	false	183	37589811	2025-11-01T03:49:29.000Z	[“0xa88594d404727625a9437c3f886c7643872296ae”,“0xbaa5cc21fd487b8fcc2f632f3f4e8d37262a0842”]	[“335093531344740873512”,“12280136825225349804”]	0x51e2f6264741135554eb70929ccb72b63067fa91a652e301bec061412e306f64
0x2b1660bd6c182a97ebfbf5f656b535d8003188f4	false	173	37589811	2025-11-01T03:49:29.000Z	[“0xa88594d404727625a9437c3f886c7643872296ae”,“0xbaa5cc21fd487b8fcc2f632f3f4e8d37262a0842”]	[“1926508401215521701782”,“48605067683964969325”]	0x51e2f6264741135554eb70929ccb72b63067fa91a652e301bec061412e306f64
0x939e7c376a7d1465cb6c4c13e478f9a2445b1853	false	798	37589802	2025-11-01T03:49:11.000Z	[“0xa88594d404727625a9437c3f886c7643872296ae”,“0xbaa5cc21fd487b8fcc2f632f3f4e8d37262a0842”]	[“5622224840045417214546”,“162012775409850807084”]	0x634d94c6145f2556565203e369819cd62a9b1f46f389c4bd8d960176d485e686

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_SlippageUpdated_event

No description available.

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_oldSlippage`	`STRING`	-
`in_newSlippage`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_TokenRecovered_event

No description available.

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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. 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

No sample data available.

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_Upgraded_event

Upgrade events for Moonwell’s Morpho strategy contracts on Base, recording when proxy contracts switch to new implementation addresses. Used for tracking protocol version changes and deployment history across strategy 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_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_implementation
0x4e18ffeb6b64177e9c7b6875701352e1f91876ad	false	114	31071311	2025-06-03T06:26:09.000Z	0xe0d0ec43f00cf453615db1701045d992d3af7a659f14b4fb9fa14cc0928d1af1	0x5fab373f43079ce488c2b8579751791982c03a35
0xe365dfc210126daa987464283f52caf59f8815dc	false	115	31101365	2025-06-03T23:07:57.000Z	0x1bc3e7f865d5836026a039291a41a282a645564b2035055cf01091beca51f0d4	0x5fab373f43079ce488c2b8579751791982c03a35
0x07106699d8cd7195dcbb870fbf6b0d5b5920a278	false	160	31065078	2025-06-03T02:58:23.000Z	0x81fdd019d8713f6e4453deb7b3039e517daf11be5b32aee50351e8058b842e06	0x5fab373f43079ce488c2b8579751791982c03a35

Example Query

Query with partition filter

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

MoonwellMorphoStrategy_Withdraw_event

Withdrawal events from Moonwell’s Morpho lending strategy contracts on Base, recording asset redemptions with amounts and contract addresses. Used for tracking capital outflows and liquidity movement across Moonwell’s yield optimization strategies.

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_asset`	`STRING`	Contract address of the asset or token. 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_asset	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf53920b033931e0c682faf05b8d5ec271eb60807	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	100081846	395	31693651	2025-06-17T16:10:49.000Z	0x9290f2bead999fff06acc65358ee18075ed2c4e63288f9e063fe443b37fde85a
0xdcdac6ee750260698e0e955accae9ffff0c9df50	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	10014363	1201	31693228	2025-06-17T15:56:43.000Z	0x1a66feed46b0fb7a2a38d1cb28734f52125881a0ca3f1bc00bced4ed631c3672
0x9aa3d9e618727e37878e4db3a7a1cfe46201abf0	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	10384692	841	31669790	2025-06-17T02:55:27.000Z	0x8b30025f13815d91e7575f740c6f0d6556bf549da1bd33d1802ac82471f7b484

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC20MoonwellMorphoStrategyFactory_StrategyCreated_event

MoonwellMorphoStrategy_Deposit_event

MoonwellMorphoStrategy_DepositIdle_event

MoonwellMorphoStrategy_FeeRecipientUpdated_event

MoonwellMorphoStrategy_Initialized_event

MoonwellMorphoStrategy_OwnershipTransferred_event

MoonwellMorphoStrategy_PositionUpdated_event

MoonwellMorphoStrategy_RewardsClaimed_event

MoonwellMorphoStrategy_SlippageUpdated_event

MoonwellMorphoStrategy_TokenRecovered_event

MoonwellMorphoStrategy_Upgraded_event

MoonwellMorphoStrategy_Withdraw_event

​Tables

​ERC20MoonwellMorphoStrategyFactory_StrategyCreated_event

​MoonwellMorphoStrategy_Deposit_event

​MoonwellMorphoStrategy_DepositIdle_event

​MoonwellMorphoStrategy_FeeRecipientUpdated_event

​MoonwellMorphoStrategy_Initialized_event

​MoonwellMorphoStrategy_OwnershipTransferred_event

​MoonwellMorphoStrategy_PositionUpdated_event

​MoonwellMorphoStrategy_RewardsClaimed_event

​MoonwellMorphoStrategy_SlippageUpdated_event

​MoonwellMorphoStrategy_TokenRecovered_event

​MoonwellMorphoStrategy_Upgraded_event

​MoonwellMorphoStrategy_Withdraw_event

Tables

ERC20MoonwellMorphoStrategyFactory_StrategyCreated_event

MoonwellMorphoStrategy_Deposit_event

MoonwellMorphoStrategy_DepositIdle_event

MoonwellMorphoStrategy_FeeRecipientUpdated_event

MoonwellMorphoStrategy_Initialized_event

MoonwellMorphoStrategy_OwnershipTransferred_event

MoonwellMorphoStrategy_PositionUpdated_event

MoonwellMorphoStrategy_RewardsClaimed_event

MoonwellMorphoStrategy_SlippageUpdated_event

MoonwellMorphoStrategy_TokenRecovered_event

MoonwellMorphoStrategy_Upgraded_event

MoonwellMorphoStrategy_Withdraw_event