moonwell_v1_base

Tables

Comptroller_MarketEntered_event

Event logs emitted when an account enters a lending market in a Compound-based protocol, enabling the account to use deposited assets as collateral for borrowing. Records the account address and market token address (cToken, mToken, or vToken) for tracking collateral activation across lending 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_mToken`	`STRING`	Contract address of the mToken (market token) in a lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_mToken	log_index	in_account	block_number	block_timestamp	transaction_hash
0xfbb21d0380bee3312b33c4353c8936a0f13ef26c	false	0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	19	0x5dbee9fddd6e015d506ecc4b4e117f7cd937e373	5546979	2023-10-21T10:15:05.000Z	0x71760a8c4e87c572f8d54870596e07c75751d2cd21c00f36d83aa3215e85da99
0xfbb21d0380bee3312b33c4353c8936a0f13ef26c	false	0x628ff693426583d9a7fb391e54366292f509d457	6	0x7906336f8440124845cce2b6c5b43b38b3413871	5563845	2023-10-21T19:37:17.000Z	0x1e8a1c7ece84b27bffd017a425395aee3589cc0635226b2e0e8479cad8d3855e
0xfbb21d0380bee3312b33c4353c8936a0f13ef26c	false	0x628ff693426583d9a7fb391e54366292f509d457	6	0x2862f66f50ca6dc81620cd82c5dae5c334a777cf	5544234	2023-10-21T08:43:35.000Z	0x9f6751526e2b865589b941b5aaad9d176fbe1fa9515a5bc47f75723814926d36

Example Query

Query with partition filter

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

Comptroller_NewLiquidationIncentive_event

Comptroller governance event emitted when the liquidation incentive parameter is updated. Records old and new mantissa values (18-decimal scaled integers) representing the bonus percentage liquidators receive for repaying undercollateralized loans in Compound-based lending 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_oldLiquidationIncentiveMantissa`	`STRING`	Previous liquidation incentive parameter in mantissa format. 18-decimal fixed-point integer representation where 1e18 equals 1.0 (e.g., ‘1080000000000000000’ represents 1.08 or 8% incentive).
`in_newLiquidationIncentiveMantissa`	`STRING`	Updated liquidation incentive parameter in mantissa format. 18-decimal fixed-point integer representation where 1e18 equals 1.0 (e.g., ‘1080000000000000000’ represents 1.08 or 8% incentive).

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newLiquidationIncentiveMantissa	in_oldLiquidationIncentiveMantissa
0xfbb21d0380bee3312b33c4353c8936a0f13ef26c	false	11	2162600	2023-08-04T02:02:27.000Z	0x7454b38e10033a66b82c3b33f53fc293024362386ca1a31d4d396622f2e5fe9c	1100000000000000000	0

Example Query

Query with partition filter

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

MToken_AccrueInterest_event

Interest accrual events from Moonwell lending protocol mToken markets on Base, recording periodic updates to borrow index, total borrows, and cash reserves. Used for calculating lending rates, borrower costs, and protocol revenue 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_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	0	10096975	3040168214367238226247	1011043703591420635	2024-02-03T18:01:37.000Z	544649687082376931190	0x2bd3db7c423830bf92182d30dd990374948297470b10caad477814234c757d90	77160579364549
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	1	10104099	3055914702613035522921	1011047893690778883	2024-02-03T21:59:05.000Z	549237165116445745811	0xec13cf695699fbe8026d7a1bf6e617cc2dae45a1750b8d86cc8a62533c5944b4	48087789559017
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	2	10105611	3062284970061454240347	1011048779298149702	2024-02-03T22:49:29.000Z	549237646209858620257	0xf0c9fb0e9d99ebc5f8ed4b725f52eb0a22f8d908e1c048d85685026904cb3514	236835993413205

Example Query

Query with partition filter

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

MToken_Borrow_event

Borrow transaction events from Moonwell lending protocol on Base, recording when users take out loans against their collateral. Contains borrower addresses, borrow amounts, running account balances, and protocol-wide total borrows for analyzing lending activity and utilization.

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_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	135	0x85e90d12de1a50ee56dd696028fedaf8db10585d	7465952	2023-12-04T20:20:51.000Z	3306957835740919	627604163257927419999	0x3ad76230bc338e48d090ac57438b03deaefb8158f6d91a3f5559ff94acaea3c0	11188565533610742997
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	5	0xa7fd89f4ac91f4798f24df2ea55a30847a54f6fb	7429726	2023-12-04T00:13:19.000Z	27012273737987187	627590921092871297011	0x691991c3a0076fda8e712053fe5cef7a6a32c175372393875b53bd5507c81c53	125721976227098334
0x627fe393bc6edda28e99ae648fd6ff362514304b	false	9	0x8b9869a87d5d5128eb742fbaed44441e90327e10	7442030	2023-12-04T07:03:27.000Z	5000000000000000000	100008703962604326274	0x284b0fdb21f47d8b131f0ee1973206af1a3dc589c5e57ba8326d000754d2ff7d	5000000159135854274

Example Query

Query with partition filter

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

MToken_LiquidateBorrow_event

Liquidation events from Moonwell V1 lending protocol on Base, recording when undercollateralized borrower positions are seized by liquidators. Tracks debt repayment amounts, collateral seized (mTokens), and participating addresses for analyzing protocol health and liquidation bot 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_liquidator`	`STRING`	Address of the account executing the liquidation operation. 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_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_mTokenCollateral`	`STRING`	MToken contract address representing the collateral asset being seized during the liquidation event. Hex-encoded, 0x-prefixed 40-character string identifying the specific Moonwell market token on Base chain.
`in_seizeTokens`	`STRING`	Quantity of collateral tokens seized from the borrower during liquidation. Numeric string representing the amount in the smallest unit of the collateral token.

Sample Data

address	removed	log_index	in_borrower	block_number	in_liquidator	in_repayAmount	in_seizeTokens	block_timestamp	transaction_hash	in_mTokenCollateral
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	28	0xe29c308a938f57f18e881f4946bb54cacaf5be7f	14938924	0x1c9e10cfa11b598988a6b60f5e7d4f05d8f17177	1172324110052076	6776284	2024-05-25T19:59:55.000Z	0x5f403067d84929a1482ce3a780957cfbf7120123a52ee4a05545ebf69a482d6e	0x628ff693426583d9a7fb391e54366292f509d457
0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22	false	56	0x063f327e44977d733810d2e2301f552d841efc5f	14939097	0x1c9e10cfa11b598988a6b60f5e7d4f05d8f17177	4940421	7116320	2024-05-25T20:05:41.000Z	0xa98a0de80a1963374e9c49b9d3cf87cf01ab73179069f3681322b734b900814b	0x628ff693426583d9a7fb391e54366292f509d457
0x628ff693426583d9a7fb391e54366292f509d457	false	264	0x47877a34f32887cd9619bf778147a5756c28743e	14939097	0x1c9e10cfa11b598988a6b60f5e7d4f05d8f17177	937646525589087	18826561441	2024-05-25T20:05:41.000Z	0x96f4dc0cba1db286ed6fd2e6213a3d1045b40ac5ba5d353df106b1c273f8ebda	0xedc817a28e8b93b03976fbd4a3ddbc9f7d176c22

Example Query

Query with partition filter

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

MToken_Mint_event

Mint events from Moonwell lending protocol mToken contracts on Base, recording when users deposit underlying assets and receive mTokens in return. Tracks depositor addresses, underlying asset amounts, and corresponding mToken quantities for analyzing supply-side lending 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_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	0xe2e464873ee3dc2aaadec285e2d20f64e9bb5ff1	13	14402373	140000000000000000	698321359	2024-05-13T09:54:53.000Z	0x840fdf06c654496e706d520783bdd1b613ce93efdf2c82e58c904cf49399a583
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	0x46b63128223cfd81fb15b47a584243f7c7a5ca02	17	14400725	279000000000000000	1391655037	2024-05-13T08:59:57.000Z	0x7ae513364f41fc9a393fe6628745417f17afeccc7059ea91a0842702f60bb773
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	0xe6d348e5f4318afa46db49106224c40bf327ce61	31	14397780	280000000000000000	1396643639	2024-05-13T07:21:47.000Z	0xa5a8b2909fe9ff22e688beac77d6170318b3190b00b43048bc7e841cff3c5e47

Example Query

Query with partition filter

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

MToken_NewProtocolSeizeShare_event

Protocol fee configuration changes for Moonwell lending markets on Base, recording updates to the liquidation seizure share percentage (mantissa format, typically 3% or 0.03e18). Used for tracking protocol revenue parameter adjustments across different mToken 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_oldProtocolSeizeShareMantissa`	`STRING`	Previous protocol seize share value in mantissa format. Represented as a string-encoded integer with 18 decimal places of precision.
`in_newProtocolSeizeShareMantissa`	`STRING`	Updated protocol seize share value in mantissa format. Represented as a string-encoded integer with 18 decimal places of precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newProtocolSeizeShareMantissa
0xb8051464c8c92209c92f3a4cd9c73746c4c3cfb3	false	324	18092453	2024-08-06T19:57:33.000Z	0x62f4419da76b9746333dc0b52e6adda9fc45b57a11a81fed118c5cc539c72a58	30000000000000000
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	58	2162578	2023-08-04T02:01:43.000Z	0x84dff72ad9d705aab4520a3b1fa7804162effdfe542d09589f80a599f4229254	30000000000000000
0x703843c3379b52f9ff486c9f5892218d2a065cc8	false	22	2162525	2023-08-04T01:59:57.000Z	0x328f40b15615f45db7c6ad3ed380d121b3ee882deae958da9a66d13b27028440	30000000000000000

Example Query

Query with partition filter

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

MToken_NewReserveFactor_event

Reserve factor adjustment events from Moonwell lending markets on Base, tracking changes to the protocol’s retention percentage from interest payments. Used for analyzing fee structure modifications and treasury revenue allocation across different mToken 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_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x703843c3379b52f9ff486c9f5892218d2a065cc8	false	170	12833295	2024-04-07T02:12:17.000Z	0x8fa86bef5b973034698de3b12d06042611b4f7f40da8632682773f9d22c9db5c	200000000000000000	150000000000000000
0x73902f619ceb9b31fd8efecf435cbdf89e369ba6	false	144	13815313	2024-04-29T19:46:13.000Z	0x39c621b507f2c82c26acee6ecb8735f9c1a86920ca82bff06d21615648a01a34	250000000000000000	0
0xb8051464c8c92209c92f3a4cd9c73746c4c3cfb3	false	194	18092452	2024-08-06T19:57:31.000Z	0x2d4b97d7500c56b12905b022a9b517619d0967a521e57bb7f33c5e17c37955ae	150000000000000000	0

Example Query

Query with partition filter

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

MToken_Redeem_event

Withdrawal events from Moonwell lending protocol mToken contracts on Base, recording when users redeem their interest-bearing tokens for underlying assets. Tracks redeemer addresses, mToken amounts burned, and underlying token amounts received for analyzing liquidity withdrawals and yield farming 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_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	41	0xcca63badee2c2bfd8d27b5b54f62cb7ccc171142	6621271	2023-11-15T07:04:49.000Z	11807190039202453	58946646	0x974d2a207c76d73275f36c1f8fc7c850220c2aa0a1afa61bd3fa51bfc589f282
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	7	0x6a01793ff990ce1af2a1840951a09da55aff576e	6611820	2023-11-15T01:49:47.000Z	19999999946671666	99848856	0x13ea2426f3e309f54949679a63862695cf87915638a5eb694ac416c58e9e3086
0x3bf93770f2d4a794c3d9ebefbaebae2a8f09a5e5	false	6	0x522e042b188ee8fcf0a17bdd0f87abb38cc2e4ee	6637103	2023-11-15T15:52:33.000Z	40000032812049022	199697198	0xb6cf513bb696fa7ec94364a44464b9cdb65b2a4e6097ec18674a687c47b68429

Example Query

Query with partition filter

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

MToken_RepayBorrow_event

Borrow repayment events from Moonwell lending protocol on Base, recording when users pay down debt positions. Contains repayment amounts, updated borrow balances, and payer/borrower addresses for tracking loan servicing activity and liquidations.

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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. 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_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x627fe393bc6edda28e99ae648fd6ff362514304b	false	0xc8b93c4079841353760dc7d268490ed61040d91c	30	0xc8b93c4079841353760dc7d268490ed61040d91c	11360703	4000000000000000000	2024-03-04T00:05:53.000Z	517938773927094002211	0x40b65c873623a088611bb98403afd4b6788efb3731c3bb8fe5e42268b6a9c465	44015249633705075857
0x627fe393bc6edda28e99ae648fd6ff362514304b	false	0xe25ebb91da142b2adcd60fd6e130c11224416986	167	0xe25ebb91da142b2adcd60fd6e130c11224416986	11376710	3499427592706470	2024-03-04T08:59:27.000Z	517957191439817883113	0xa0d6483888133943dc8d22c71b15d03c56e23930f738e7b61aeee70ca6731899	2067068901276
0x628ff693426583d9a7fb391e54366292f509d457	false	0x26dac33accf8d28cf26ccc0135d8c6ee3233a2e7	119	0x26dac33accf8d28cf26ccc0135d8c6ee3233a2e7	11387890	1976610077256623463	2024-03-04T15:12:07.000Z	6476728964129239355031	0x4f9a984498b0c9abd57f1d517a34213374fbfe7bc94e7f803b1bcad1d4d2d21b	64712929678732244663

Example Query

Query with partition filter

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

MToken_ReservesAdded_event

Reserve addition events from Moonwell V1 lending protocol on Base, tracking when protocol reserves are increased through mToken contract operations. Records benefactor addresses, added amounts, and running reserve totals for protocol revenue and risk analysis.

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_benefactor`	`STRING`	Address of the account that provided or contributed the reserves being added to the lending market contract. Hex-encoded, 0x-prefixed, 42-character string.
`in_addAmount`	`STRING`	Amount of reserves added to the lending market contract. String-encoded integer representing the token amount in smallest denomination.
`in_newTotalReserves`	`STRING`	Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	log_index	block_number	in_addAmount	in_benefactor	block_timestamp	transaction_hash	in_newTotalReserves
0x628ff693426583d9a7fb391e54366292f509d457	false	19	6241575	4098954155197136	0x628ff693426583d9a7fb391e54366292f509d457	2023-11-06T12:08:17.000Z	0x6fccb93e0d62f7e070d06a2121be84c922e83cd121d6a495bd6405ee5d8a0224	7457474587578483100
0x628ff693426583d9a7fb391e54366292f509d457	false	14	5464499	3090177611879756	0x628ff693426583d9a7fb391e54366292f509d457	2023-10-19T12:25:45.000Z	0x50020003588a009cae72880935d6d712521a9ad39716c8ecf2ee2640ba761077	6688594017490069716
0x628ff693426583d9a7fb391e54366292f509d457	false	21	9627694	5642525974709933	0x628ff693426583d9a7fb391e54366292f509d457	2024-01-23T21:18:55.000Z	0xa552f59781c2c517153384f2da0105c190b0de7e0debaeb7ee8245e02f06b344	16383781258507991952

Example Query

Query with partition filter

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

MToken_ReservesReduced_event

Reserve withdrawal events from Moonwell lending protocol markets on Base showing when protocol admins extract accumulated reserves. Useful for tracking protocol revenue collection and treasury management across different mToken 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_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reduceAmount`	`STRING`	Amount of reserves withdrawn from the lending market contract. String-encoded integer representing the token amount in smallest denomination.
`in_newTotalReserves`	`STRING`	Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination.

Sample Data

address	removed	in_admin	log_index	block_number	block_timestamp	in_reduceAmount	transaction_hash	in_newTotalReserves
0x73b06d8d18de422e269645eace15400de7462417	false	0x8b621804a7637b781e2bbd58e256a591f2df7d51	300	26506882	2025-02-17T14:38:31.000Z	25269148508723140000000	0xd6727a96f20060c8bfb27ebde3790302e23ae431fb8e6d56b5fcf6e5b7b11e73	531454757563034290126
0x703843c3379b52f9ff486c9f5892218d2a065cc8	false	0x8b621804a7637b781e2bbd58e256a591f2df7d51	294	26506882	2025-02-17T14:38:31.000Z	32175116397	0xd6727a96f20060c8bfb27ebde3790302e23ae431fb8e6d56b5fcf6e5b7b11e73	1831508
0x73b06d8d18de422e269645eace15400de7462417	false	0x8b621804a7637b781e2bbd58e256a591f2df7d51	246	27717652	2025-03-17T15:17:31.000Z	247289129037697000000	0x1f1589a2d852e114e2d47573af4c3c42eaf8aa27bf1bf3fbbdb984bc523edaf8	2011788044216674224742

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Comptroller_MarketEntered_event

Comptroller_NewLiquidationIncentive_event

MToken_AccrueInterest_event

MToken_Borrow_event

MToken_LiquidateBorrow_event

MToken_Mint_event

MToken_NewProtocolSeizeShare_event

MToken_NewReserveFactor_event

MToken_Redeem_event

MToken_RepayBorrow_event

MToken_ReservesAdded_event

MToken_ReservesReduced_event

​Tables

​Comptroller_MarketEntered_event

​Comptroller_NewLiquidationIncentive_event

​MToken_AccrueInterest_event

​MToken_Borrow_event

​MToken_LiquidateBorrow_event

​MToken_Mint_event

​MToken_NewProtocolSeizeShare_event

​MToken_NewReserveFactor_event

​MToken_Redeem_event

​MToken_RepayBorrow_event

​MToken_ReservesAdded_event

​MToken_ReservesReduced_event

Tables

Comptroller_MarketEntered_event

Comptroller_NewLiquidationIncentive_event

MToken_AccrueInterest_event

MToken_Borrow_event

MToken_LiquidateBorrow_event

MToken_Mint_event

MToken_NewProtocolSeizeShare_event

MToken_NewReserveFactor_event

MToken_Redeem_event

MToken_RepayBorrow_event

MToken_ReservesAdded_event

MToken_ReservesReduced_event