moonwell_v1_optimism

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
0xca889f40aae37fff165bccf69aef1e82b5c511b9	false	0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	1	0x1837c12cc857059c17e56d914e41ae0d83d1ea35	123879125	2024-08-11T06:17:07.000Z	0x6c8c234e0738000f4f592fb136a5dca63ab9772064577b5a291be7d3fcc65907
0xca889f40aae37fff165bccf69aef1e82b5c511b9	false	0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	5	0xf93a5f0a4925eec32cd585641c88a498523f383c	123868078	2024-08-11T00:08:53.000Z	0x3a3f01336022b7c5584d0125148d9b83e6f1cfaaf87ae7cab944d63015b4c0fc
0xca889f40aae37fff165bccf69aef1e82b5c511b9	false	0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	129	0x53541ddc41da98f330721d7f9f7dc12d015553df	123874643	2024-08-11T03:47:43.000Z	0xf4b198aa4a3d89e7bfcc19eb1eafc814c9c10d08d75acbba377db9f86a16d621

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.moonwell_v1_optimism.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
0xca889f40aae37fff165bccf69aef1e82b5c511b9	false	24	122531779	2024-07-11T01:45:35.000Z	0xf382e1a51b2c25e5deee25f4fbf8acee75726e9aff378947018661d349cd3bd7	1100000000000000000	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.moonwell_v1_optimism.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’s MToken contracts on Optimism, tracking borrow index updates, accumulated interest, and cash balances for each market. Used for analyzing lending rates, protocol revenue, and market utilization 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	transaction_hash
0x9fc345a20541bf8773988515c5950ed69af01847	false	37	123601986	67697472617009845423	1001358192127955147	2024-08-04T20:19:09.000Z	0x15b368da29dcd9f92053108b8c00189239078e61b26b5035a77b2d5e63879373
0x9fc345a20541bf8773988515c5950ed69af01847	false	36	123591895	65459289600603980204	1001345375567612563	2024-08-04T14:42:47.000Z	0x4a8d89563612c816f09a5d2d5a30d40dfe72cfc436aae2733d3a10021ba7c5b3
0x9fc345a20541bf8773988515c5950ed69af01847	false	39	123587565	71168305627782320494	1001339876072865254	2024-08-04T12:18:27.000Z	0x4fc0d3670944d2a871c26f343f46bcc3b89db61670a4ee13fc77c64484de32f1

Example Query

Query with partition filter

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

MToken_Borrow_event

Borrow event logs from Moonwell V1 lending protocol on Optimism, recording when users take out loans against their collateral with individual and cumulative borrow amounts. Used for tracking borrowing activity, debt positions, and protocol-wide utilization metrics.

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
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	2490	0x05949d60fba6e06444eea7288fcbf1bcc62693d1	124409688	2024-08-23T13:02:33.000Z	7319600706842597542	424919299008182528035018	0xc7a88f48238215f7d28f9aead054f106e0bd126acf90f2609028b6a5fb088045	7319600706842597542
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	30	0x08eb7adf4135e2aa455475d6cc8464602a72338e	124393456	2024-08-23T04:01:29.000Z	3000000000000000000000	423137378146375465078193	0x5a0e1b2247b4ba7659fde89b7e9751f84329fda5e523fbfc14cebea77fc22dd5	3000000000000000000000
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	245	0x8832fad83d3abc9d24b46e75d99165fb6ecb92b3	124419456	2024-08-23T18:28:09.000Z	28013555159645763050	424961488563999982783870	0x3e2966c84313a1ec003260486f82f8abdd223a76d77e28424d36ac7a719d6fd2	28013555159645763050

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.moonwell_v1_optimism.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 Optimism, recording when undercollateralized borrower positions are liquidated by repaying debt and seizing collateral. Tracks liquidator addresses, repayment amounts, seized collateral tokens (mTokens), and borrower accounts for analyzing protocol health and liquidation 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`	Contract address of the mToken representing the collateral asset being seized in this liquidation event. Hex-encoded, 0x-prefixed Ethereum address identifying the specific Moonwell market token.
`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
0x8e08617b0d66359d73aa11e11017834c29155525	false	123	0x6f27486b6c9a7a7fef4a6186aa9c0ba746a5a0dd	123933429	0xeb8bae7fccc9028269177fb68e6d5c958ca59ac5	14092311	77514733944	2024-08-12T12:27:15.000Z	0xc24d681ded6bd75fb1d5df52a39a0d40bbf8abe9297d221c8cd544b06eb0a2ea	0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	88	0xaa3163db743b6000d70439a0d410d24a8f9d172d	125028059	0xeb8bae7fccc9028269177fb68e6d5c958ca59ac5	4455175987876567552	9942487	2024-09-06T20:34:55.000Z	0xaf2af3d5e8da815aa857a0d21844eb32c1d0261c728c638860bb97ea65bb7bb6	0x4c2e35e3ec4a0c82849637bc04a4609dbe53d321
0x8e08617b0d66359d73aa11e11017834c29155525	false	158	0x6071b610694db4c502da5370ee39623008db0e03	125018610	0xeb8bae7fccc9028269177fb68e6d5c958ca59ac5	61505407	148586620	2024-09-06T15:19:57.000Z	0x2b48df8d08023eb9133251b683482e93bb4fb08ba1a4f2cb8c9134fcfc0482e0	0xb4104c02bbf4e9be85aaa41a62974e4e28d59a33

Example Query

Query with partition filter

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

MToken_Mint_event

Deposit events from Moonwell V1 lending protocol on Optimism, recording when users mint mTokens by supplying underlying assets. Tracks depositor addresses, amounts supplied, and corresponding mTokens issued for analyzing lending market deposit 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
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	0x8b6247eae510a93d82baad23bdbc5e6f7879dae2	82	123867322	10710000000000000000	53549999999	2024-08-10T23:43:41.000Z	0x33e6cb4507d89809f2c6722bbd65e553426b71f9b3d0c8bb1a8c18ba01e49936
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	0xe4d69c0801e9b00ea3b865a25fb2dbf0604e6d8d	154	123867754	21313001220000000000	106565006098	2024-08-10T23:58:05.000Z	0x721c50e36c29d38f0a2f220918fa7d744f82f36a80e96817b4d7f22fcd95176f
0x4c2e35e3ec4a0c82849637bc04a4609dbe53d321	false	0x0c740699fc922a72e61fef9689713e29a2b899fc	11	123867557	88188336461650668	440941595	2024-08-10T23:51:31.000Z	0x7e7f37704852f19c6773ed0767066fcae54cc4ccc86ec43d4de69c39a9f77b77

Example Query

Query with partition filter

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

MToken_NewProtocolSeizeShare_event

Protocol fee parameter changes for Moonwell lending markets on Optimism, recording updates to the seize share mantissa (percentage of liquidated collateral taken as protocol fee). Used to track governance adjustments to liquidation incentive structures 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
0xa3a53899ee8f9f6e963437c5b3f805fec538bf84	false	66	122531557	2024-07-11T01:38:11.000Z	0xc6661dacead95c66be457083985009461056df5da534c647da1a42e489cdfbd9	30000000000000000
0xbb3b1ab66efb43b10923b87460c0106643b83f9d	false	10	122531657	2024-07-11T01:41:31.000Z	0xec15f5457af0ff1ee4ce2b65c7bba4e2d17a2c00c6c005a4ef326ac84e20fc88	30000000000000000
0x95c84f369bd0251ca903052600a3c96838d78ba1	false	23	122531682	2024-07-11T01:42:21.000Z	0x23fbf2fd98e76161146d24e784487c6d8c2673ebdccd8cf82d6ad6d5d3d6accb	30000000000000000

Example Query

Query with partition filter

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

MToken_NewReserveFactor_event

Reserve factor parameter updates for Moonwell lending markets on Optimism, tracking changes to the protocol’s fee percentage retained from interest payments. Useful for analyzing governance decisions and protocol 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
0xb8051464c8c92209c92f3a4cd9c73746c4c3cfb3	false	30	123694569	2024-08-06T23:45:15.000Z	0x011af03d2f8fed190acc2241f46ec63b8b6a04820ee322e10ee2fff5c120ecd3	150000000000000000	0
0xa3a53899ee8f9f6e963437c5b3f805fec538bf84	false	1541	123872582	2024-08-11T02:39:01.000Z	0x88e8cd5a26a9f8c81e7c74f0d084be901c3d5907e2f5121e56d2cd467d83198d	50000000000000000	150000000000000000
0x8e08617b0d66359d73aa11e11017834c29155525	false	1538	123872582	2024-08-11T02:39:01.000Z	0x88e8cd5a26a9f8c81e7c74f0d084be901c3d5907e2f5121e56d2cd467d83198d	50000000000000000	150000000000000000

Example Query

Query with partition filter

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

MToken_Redeem_event

Withdrawal events from Moonwell lending protocol on Optimism, recording when users redeem mToken receipt tokens to withdraw their underlying deposited assets. Tracks redeemer address, mToken amount burned, and underlying tokens received for analyzing lending market 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_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
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	65	0x836160a1ddb55fb03e608e32354c09e11abe1316	123950832	2024-08-12T22:07:21.000Z	1003001005005823679276	5013710028045	0xd34b0898454a11546bcf25585cc3df6fbedaeb4fd97498140aeda05c1c96d18b
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	14	0x836160a1ddb55fb03e608e32354c09e11abe1316	123925328	2024-08-12T07:57:13.000Z	20000236658415818927945	99985148850399	0x58350c0673214221ffd5186576256f56b0f255e5bdbdb009ed9996b54e5e42c8
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	52	0x6f27486b6c9a7a7fef4a6186aa9c0ba746a5a0dd	123931319	2024-08-12T11:16:55.000Z	28915455372211397472	144549606279	0x66729b825f57bd7c7a46472fe5d016936d9b4c9ab9d9524be8ca8876f8e64615

Example Query

Query with partition filter

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

MToken_RepayBorrow_event

Loan repayment events from Moonwell V1 lending protocol on Optimism. Tracks borrower repayments with amounts, updated borrow balances, and payer information for analyzing debt management and protocol liquidity.

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
0x8e08617b0d66359d73aa11e11017834c29155525	false	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	19	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	124308000	18411856948	2024-08-21T04:32:57.000Z	2093319372960	0xd758f9c1f7c8b262547b11443ad6ae779ba2e5d1762a7b2a8fbf12606fef09de	1288
0x8e08617b0d66359d73aa11e11017834c29155525	false	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	6	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	124307591	5000000255	2024-08-21T04:19:19.000Z	2131728202539	0xcea170c753381a3960fd4f94d6c6a12d77302ac31f4efaff4eb7fe9dd7020751	38411819058
0x8e08617b0d66359d73aa11e11017834c29155525	false	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	16	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	124307784	20000000582	2024-08-21T04:25:45.000Z	2111729638571	0x3ac99eebe863e6c0c8b35a6d3a5f68ed4e2ba789fb8948b9d3a80705e07a53d0	18411844362

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.moonwell_v1_optimism.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 markets on Optimism, tracking when protocol fees are added to market reserves. Records the benefactor address, amount added, and running total reserves for analyzing protocol revenue accumulation across 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_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
0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	false	122	123933429	465182519325340890	0x3fe782c2fe7668c2f1eb313acf3022a31fead6b2	2024-08-12T12:27:15.000Z	0xc24d681ded6bd75fb1d5df52a39a0d40bbf8abe9297d221c8cd544b06eb0a2ea	2383621111769428793
0xb4104c02bbf4e9be85aaa41a62974e4e28d59a33	false	157	125018610	892601958003640	0xb4104c02bbf4e9be85aaa41a62974e4e28d59a33	2024-09-06T15:19:57.000Z	0x2b48df8d08023eb9133251b683482e93bb4fb08ba1a4f2cb8c9134fcfc0482e0	202316033319909972
0x6e6ca598a06e609c913551b729a228b023f06fdb	false	20	125018544	28383	0x6e6ca598a06e609c913551b729a228b023f06fdb	2024-09-06T15:17:45.000Z	0x758fdc5ae7626a53156add883c634ed094dfdcf5931db5debd17f1743a11ea19	201609

Example Query

Query with partition filter

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

MToken_ReservesReduced_event

Reserve withdrawal events from Moonwell V1 lending protocol on Optimism. Records admin-initiated reductions of protocol reserves with reduction amounts and updated reserve balances for analyzing protocol treasury 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_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
0x6e6ca598a06e609c913551b729a228b023f06fdb	false	0x17c9ba3fda7ec71ccfd75f978ef31e21927aff3d	191	132102196	2025-02-17T14:39:29.000Z	469207	0x152e17be7d221a0bad28c38a506490cc7da87317f3a6fcc68f5d5c99877d116d	2276
0x6e6ca598a06e609c913551b729a228b023f06fdb	false	0x17c9ba3fda7ec71ccfd75f978ef31e21927aff3d	215	133312967	2025-03-17T15:18:31.000Z	5759	0x6ffbaefb41304babdaea492ef6ff298905d15256cdf0e7ad8274544253c111bb	660
0x95c84f369bd0251ca903052600a3c96838d78ba1	false	0x17c9ba3fda7ec71ccfd75f978ef31e21927aff3d	221	133312967	2025-03-17T15:18:31.000Z	14031067624711580	0x6ffbaefb41304babdaea492ef6ff298905d15256cdf0e7ad8274544253c111bb	5425872149

Example Query

Query with partition filter

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