zerolend_v1_manta

Tables

AToken_Burn_event

Burn events for Aave interest-bearing tokens (aTokens) emitted when users withdraw or repay underlying assets. Records the amount burned, the user’s address, the interest accrual index at burn time, and optional balance increase from accrued interest in V3 implementations.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x8d8b70a576113feedd7e3810ce61f5e243b01264	0x231dc45dadd6d8e2923559741112873306885de3	false	1082252197288781766168599160	412470912725516	0x9335341b954b6d62fd9d91eb6396bb2a85f00850	8	5811073	2025-07-12T15:38:09.000Z	0xcbbf2ddf59917e172a41a2e9b7b7ea0ab4bb96e493dd0d24f149f9f97a50aff0	2143871325241
0xb4ffef15daf4c02787bc5332580b838ce39805f5	0x5946ecf36ec487c3f4a5b154b02b9bf48f35bc2d	false	1143669002442662223465293448	499780	0x5946ecf36ec487c3f4a5b154b02b9bf48f35bc2d	8	5809821	2025-07-12T12:09:29.000Z	0x3691000830b30c90d3ccf044279a8a1c992ab86dbea23f064e6109cd335a3c54	220
0x759cb97fbc452bafd49992ba88d3c5da4dd9b0e7	0x5946ecf36ec487c3f4a5b154b02b9bf48f35bc2d	false	1161266298258365384188541439	249841	0x5946ecf36ec487c3f4a5b154b02b9bf48f35bc2d	12	5809827	2025-07-12T12:10:29.000Z	0xf32b57cbb3aae5005483df7dd8dc4de7b95e79ddf602fcd38830de601db68fa3	159

Example Query

Query with partition filter

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

AToken_Initialized_event

Aave V3 AToken initialization events emitted when new interest-bearing token markets are deployed. Contains AToken metadata (name, symbol, decimals), configuration references (pool, treasury, incentives controller), and the underlying asset address being wrapped.

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_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aTokenDecimals`	`INT64`	Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
`in_aTokenName`	`STRING`	Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
`in_aTokenSymbol`	`STRING`	Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	in_treasury	block_number	in_aTokenName	block_timestamp	in_aTokenSymbol	transaction_hash	in_aTokenDecimals	in_underlyingAsset	in_incentivesController
0x03114e4c29ea95bf26108c2c47338488555ced1a	0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	0x10	25	0x97e59722318f1324008484aca9c343863792cbf6	1133944	ZeroLend Manta Network	2024-01-18T07:36:39.000Z	z0MANTA	0x51a9922789c283ddb98660e3dc5094fe3e50913d40e0fe03ca7cd3541d818749	18	0x95cef13441be50d20ca4558cc0a27b601ac544e5	0x28f6899ff643261ca9766ddc251b359a2d00b945
0xb4ffef15daf4c02787bc5332580b838ce39805f5	0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	0x10	18	0x97e59722318f1324008484aca9c343863792cbf6	1093827	ZeroLend USDC	2024-01-13T16:10:29.000Z	z0USDC	0xce37f2e02ea6ab4df3dcfcac7bec0c79c02d8b17088b6b42254705dff09aac57	6	0xb73603c5d87fa094b7314c74ace2e64d165016fb	0x28f6899ff643261ca9766ddc251b359a2d00b945
0x2e207eca8b6bf77a6ac82763eeed2a94de4f081d	0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	0x10	10	0x97e59722318f1324008484aca9c343863792cbf6	1093827	ZeroLend MATIC	2024-01-13T16:10:29.000Z	z0MATIC	0xce37f2e02ea6ab4df3dcfcac7bec0c79c02d8b17088b6b42254705dff09aac57	18	0x0f52a51287f9b3894d73df05164d0ee2533ccbb4	0x28f6899ff643261ca9766ddc251b359a2d00b945

Example Query

Query with partition filter

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

AToken_Mint_event

Aave Protocol interest-bearing token (aToken) mint events emitted when users deposit underlying assets into lending pools. Records deposit transactions including depositor address, recipient address, minted token amount, liquidity index, and accrued interest balance increases for lending position tracking.

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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x8d8b70a576113feedd7e3810ce61f5e243b01264	false	1004566648506597523637856632	3000000000000000	0x000abfe337d7ef2ee79a3e48b515a3849c21e78e	30	3822647	0x000abfe337d7ef2ee79a3e48b515a3849c21e78e	2024-11-24T12:13:49.000Z	0x941252d6550f5fe5bc5591279d04deab77d41c1c260c62042680d58bad086697
0x8d8b70a576113feedd7e3810ce61f5e243b01264	false	1004572742357959967329391502	1005006328965992752	0x15a1c072c4e286da08066a0bd78aa0c00d03f4f4	54	3826374	0x15a1c072c4e286da08066a0bd78aa0c00d03f4f4	2024-11-24T22:34:59.000Z	0x847baadc416e98905fc76614b5d71df77c1c7332f4fa1998c6bb701451c88e97
0x8d8b70a576113feedd7e3810ce61f5e243b01264	false	1004572791216610517868575644	1005006356484966788	0x15a1c072c4e286da08066a0bd78aa0c00d03f4f4	23	3826404	0x15a1c072c4e286da08066a0bd78aa0c00d03f4f4	2024-11-24T22:39:59.000Z	0x2138bf7db676fc68502cace5fb4647c535069f2690be7a71e40ff6db132ce346

Example Query

Query with partition filter

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

LendingPool_Borrow_event

Borrow events emitted by Aave lending pool contracts capturing loan originations with borrower address, reserve asset, loan amount, interest rate, and rate mode (stable or variable). Used for tracking DeFi lending activity and calculating protocol borrowing 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of 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.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_borrowRate`	`STRING`	Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x888bd1c669de602cc66067d5353c84847caa6156	false	2655593317046778117	14	0x0dc808adce2099a9f62aa87d9670745aba741746	1905793	20538199129646790594158112	0x888bd1c669de602cc66067d5353c84847caa6156	2024-04-16T15:38:09.000Z	0x8a727392aa1f14c64b487bce58c29a526da7b45fdc881a78601bce43cab1a88c	2
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x888bd1c669de602cc66067d5353c84847caa6156	false	4128695861913117512	5	0x0dc808adce2099a9f62aa87d9670745aba741746	1905777	20456974343843841916779893	0x888bd1c669de602cc66067d5353c84847caa6156	2024-04-16T15:35:29.000Z	0x436fe8dc6b1c7a6443589dc9f160bdd6bb2f5ac92b9c9f96c5bf334f9925a08e	2
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x888bd1c669de602cc66067d5353c84847caa6156	false	188037296200724179	10	0x0dc808adce2099a9f62aa87d9670745aba741746	1905909	20628929383445773709259924	0x888bd1c669de602cc66067d5353c84847caa6156	2024-04-16T15:57:29.000Z	0xc27f4a91bc7a3fc27d335ef6e52af93401acb77a78b34ea9a1dd10eab26005db	2

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

Flash loan events from Aave and Aave-forked lending protocols containing borrowed asset, amount, initiator, recipient, and premium fee charged. Used for tracking uncollateralized borrowing activity and arbitrage transactions.

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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	0x0dc808adce2099a9f62aa87d9670745aba741746	1576831713668433	0x0b46f121ef78fcc74cec89562198f28df8c94fd3	52	788415856834	1938219	0x0b46f121ef78fcc74cec89562198f28df8c94fd3	2024-04-20T09:42:29.000Z	0x3840b38398fdc3ac59ddd13ed597942a194adc879fa85ff19ca9b60eb03a1c4a
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	0x0dc808adce2099a9f62aa87d9670745aba741746	695368409053938	0x0b46f121ef78fcc74cec89562198f28df8c94fd3	127	347684204527	1936388	0x0b46f121ef78fcc74cec89562198f28df8c94fd3	2024-04-20T04:37:19.000Z	0x570ff87d6af1cae6eb960edd1c4dd8c9410400f182651d1b2bc24dc746655b94
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	0x0dc808adce2099a9f62aa87d9670745aba741746	1041543497952623	0x0b46f121ef78fcc74cec89562198f28df8c94fd3	35	520771748976	1941141	0x0b46f121ef78fcc74cec89562198f28df8c94fd3	2024-04-20T17:49:29.000Z	0xc5f2213d8a271b25e0e5e83e3765288f158a4075c5f356c6c2920dc0601098ba

Example Query

Query with partition filter

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

LendingPool_LiquidationCall_event

Liquidation events from Aave-compatible lending protocols when undercollateralized positions are closed. Records liquidator, borrower, debt repaid, collateral seized, and asset addresses for tracking protocol risk 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_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAsset`	`STRING`	Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtToCover`	`STRING`	Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
`in_liquidatedCollateralAmount`	`STRING`	Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveAToken`	`BOOL`	Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x555a8bbec0ff4938b4dd83b45f5c4f93a02081b5	false	12	5204185	0x95cef13441be50d20ca4558cc0a27b601ac544e5	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	6717024846252556272114	2025-05-03T09:50:09.000Z	false	0x027c65dde8ca9fa8e9769699d0f0faa7c2c51b4757068c1c3114f32cbee2eb49	0x0dc808adce2099a9f62aa87d9670745aba741746	948905099999999998
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x7896ae63d4aab8c6d3c3412fc3485acc0fd11be0	false	15	3160884	0xb73603c5d87fa094b7314c74ace2e64d165016fb	0x5420e98d489af99355478b2f1e79b7c2301805a3	81385529	2024-09-08T21:59:59.000Z	false	0xf2a8586594321cae5d8c6e48258ce28e79ef97117adaca07bf91d24f6060687a	0xb73603c5d87fa094b7314c74ace2e64d165016fb	84640950
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0xae883c17d92f4b98ca80378d481d3da91d18c111	false	11	3160502	0xb73603c5d87fa094b7314c74ace2e64d165016fb	0x5420e98d489af99355478b2f1e79b7c2301805a3	58214355	2024-09-08T20:56:19.000Z	false	0xb81322c7e3049a06ac19b39bcc5acd643f88e9c3bfd6bd56bfcd5c75800dfa53	0xb73603c5d87fa094b7314c74ace2e64d165016fb	60542929

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

Aave V3 protocol event recording interest-bearing token mints to the treasury reserve. Contains reserve address, amount minted, and transaction identifiers for tracking protocol fee accumulation.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	6	0xec901da9c68e90798bbbb74c11406a32a70652c3	2064325	2024-05-05T00:00:09.000Z	83094943526608	0x8d2d04743440679644d89b17cc38a0a7259ddcea14fab8e15668b5e4727ee89e
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	25	0xbdad407f77f44f7da6684b416b1951eca461fb07	2064325	2024-05-05T00:00:09.000Z	931617908133168719	0x8d2d04743440679644d89b17cc38a0a7259ddcea14fab8e15668b5e4727ee89e
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	false	28	0x95cef13441be50d20ca4558cc0a27b601ac544e5	2064325	2024-05-05T00:00:09.000Z	7532763886978778	0x8d2d04743440679644d89b17cc38a0a7259ddcea14fab8e15668b5e4727ee89e

Example Query

Query with partition filter

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

LendingPool_Repay_event

Loan repayment events from Aave-based lending protocols containing borrower address, repayer address, reserve asset, and repayment amount. Used for tracking debt reduction and loan lifecycle analysis across DeFi 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayer`	`STRING`	Address of the account that executed the repayment transaction. 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.
`in_useATokens`	`BOOL`	Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x0c5646ae03c13b9e1c64ac0aa3cbb9453838e13e	false	10000000000000000	6	0x0c5646ae03c13b9e1c64ac0aa3cbb9453838e13e	0x0dc808adce2099a9f62aa87d9670745aba741746	1386567	false	2024-02-16T13:20:29.000Z	0x67b57a249329e1cfb4c532f054ea0bfbf6e98ef7c5dbf4016403fab03c42b44d
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x4a1fc803ce305351af3b439b807e2fb9811e8520	false	11045074461321827	7	0xe05361ea51e20118072aec0fb0fd178e8b09d69e	0x0dc808adce2099a9f62aa87d9670745aba741746	1389097	false	2024-02-16T20:22:09.000Z	0x3c40bdf644bf522e89639765d7914602586f5c453bf7cf42f7d3b6983cef4cec
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x890a0047f8d573347872cb6c019f86552f2367d6	false	72000000000000000	24	0xe05361ea51e20118072aec0fb0fd178e8b09d69e	0x0dc808adce2099a9f62aa87d9670745aba741746	1389638	false	2024-02-16T21:52:19.000Z	0x900691a852cd4666d431672027ace81374a63e1acb7121952ed5279f65f9a4ba

Example Query

Query with partition filter

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

LendingPool_Supply_event

Aave V3 Supply events emitted when users deposit assets into lending pools. Records depositor address, reserve token, deposit amount, beneficiary, and optional referral code for tracking liquidity provision across DeFi 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of 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.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x78ce719b54fd4bd013e0bd95cb5071c59589ef7d	false	1000000000000000	110	0xec901da9c68e90798bbbb74c11406a32a70652c3	4305087	0x78ce719b54fd4bd013e0bd95cb5071c59589ef7d	2025-01-19T08:20:29.000Z	0xbfee7ef3ca1f8d73f899573e983cb09ef4d1d81a2f9ece8f0e5cbe9f4ce804d6
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x86a3cdf3500e4ddaa8b5a2cfd0af8c671b07cfff	false	100417672781214334	7	0xec901da9c68e90798bbbb74c11406a32a70652c3	4309755	0x86a3cdf3500e4ddaa8b5a2cfd0af8c671b07cfff	2025-01-19T21:18:29.000Z	0x67eb488ecb12f76287a59234d47ae0760a8d85e7f1bbcb5cc8130db33c33d375
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0xe05361ea51e20118072aec0fb0fd178e8b09d69e	false	101000000000000000	39	0x0dc808adce2099a9f62aa87d9670745aba741746	4305552	0x35f27457f3d19616de8d6eaee0609ee6c014acde	2025-01-19T09:37:59.000Z	0xcc84d92be7330943cb16ff932761b9a3d212ff586699088bdcfe7075d2dff433

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

Aave LendingPool withdrawal events recording asset removals from lending positions. Contains user address, reserve token address, withdrawal amount, and recipient address for tracking collateral and liquidity movements across Aave V2 and V3 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x2bd111bda69c828dcc267b49d9bb27c37e3053b1	0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x2bd111bda69c828dcc267b49d9bb27c37e3053b1	false	50000000000000000	4	0xec901da9c68e90798bbbb74c11406a32a70652c3	5800953	2025-07-11T11:31:29.000Z	0xa6757358bcc557d9519b334eed8ec4f9d79353048555e49188cdca98800b077b
0x95615b6c83685376e44b64ffc8db42d5561567e5	0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x95615b6c83685376e44b64ffc8db42d5561567e5	false	10764408621876	4	0xec901da9c68e90798bbbb74c11406a32a70652c3	5799889	2025-07-11T08:34:09.000Z	0x4e50b942453b4cb952bbe97ee037e5a5f40ab65cbbc648871e9f81720be434dc
0x95615b6c83685376e44b64ffc8db42d5561567e5	0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269	0x95615b6c83685376e44b64ffc8db42d5561567e5	false	96942	5	0xb73603c5d87fa094b7314c74ace2e64d165016fb	5799881	2025-07-11T08:32:49.000Z	0x3b9dc48721a8accdefe688d318945f5130d0aac92d435cddfba688fca17d9bdd

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_ltv`	`STRING`	Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationThreshold`	`STRING`	Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationBonus`	`STRING`	Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
5000	0xf17218b09699d0f7145e40e771e72130ff616498	false	0x6fae4d9935e2fcb11fc79a64e917fb2bf14dafaa	32	1102036	2024-01-14T14:58:39.000Z	0xc49d440063a9032002d9b1e053ccac1e4214938250712caec064f9cb3b0b28de	10500	8000
6000	0xf17218b09699d0f7145e40e771e72130ff616498	false	0xbdad407f77f44f7da6684b416b1951eca461fb07	13	1103859	2024-01-14T20:02:29.000Z	0xfe60730e913fc3b881d50211cdc94bbb136ca6e2e1fb995007e45dce5fa29f12	11000	8000
6000	0xf17218b09699d0f7145e40e771e72130ff616498	false	0xec901da9c68e90798bbbb74c11406a32a70652c3	49	1103861	2024-01-14T20:02:49.000Z	0x5da91c9ae5211763938ab90beab3347129447ed375d46aa745e523456d66128d	11000	8000

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.

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_oldFee`	`STRING`	Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldReserveFactor`	`STRING`	Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
`in_newReserveFactor`	`STRING`	Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor
0xf17218b09699d0f7145e40e771e72130ff616498	false	0x0dc808adce2099a9f62aa87d9670745aba741746	199	1093832	2024-01-13T16:11:19.000Z	0xf8c7ac6058c62c60e7626bd2b0083a6c01082e74b58ee2411adc3878a4636b26	1000
0xf17218b09699d0f7145e40e771e72130ff616498	false	0xf417f5a458ec102b90352f697d6e2ac3a3d2851f	185	1093832	2024-01-13T16:11:19.000Z	0xf8c7ac6058c62c60e7626bd2b0083a6c01082e74b58ee2411adc3878a4636b26	1000
0xf17218b09699d0f7145e40e771e72130ff616498	false	0x0f52a51287f9b3894d73df05164d0ee2533ccbb4	167	1093832	2024-01-13T16:11:19.000Z	0xf8c7ac6058c62c60e7626bd2b0083a6c01082e74b58ee2411adc3878a4636b26	2000

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

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_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0xf17218b09699d0f7145e40e771e72130ff616498	false	0x2fe3ad97a60eb7c79a976fc18bb5ffd07dd94ba5	0x0ab214f127998a36ce7ab0087a9b0d20adc2d5ad	8	1093829	2024-01-13T16:10:49.000Z	0x8d23e247ebc52d0219008f4996d6a5fb70bbe0eaf762314b7631daeeab4b32a3	0x28d7246cd9da102c75faa7d4cf1c5399b323f084	0xb5eef4df2e48fb41e6eae6778c14787baaa181f1	0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e
0xf17218b09699d0f7145e40e771e72130ff616498	false	0x0dc808adce2099a9f62aa87d9670745aba741746	0x0684fc172a0b8e6a65cf4684edb2082272fe9050	30	1093828	2024-01-13T16:10:39.000Z	0x9c702347fe179216564c95f353024a56392d0a53035240165c44cc718acf4138	0xffa256ad2487c4d989c3dfa6a6e9c13fe33beba4	0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00	0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e
0xf17218b09699d0f7145e40e771e72130ff616498	false	0x305e88d809c9dc03179554bfbf85ac05ce8f18d6	0xe7e54ca3d6f8a5561f8cee361260e537bdc5be48	26	1093828	2024-01-13T16:10:39.000Z	0x9c702347fe179216564c95f353024a56392d0a53035240165c44cc718acf4138	0x7c2e57764ec33292fe098636aaa5d0357d814d16	0xe6b9b00d42fa5831cce4e44d9d6d8c51ba17cd1e	0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e

Example Query

Query with partition filter

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

SToken_Burn_event

Stable rate debt token burn events from Aave-based lending protocols, emitted when borrowers repay stable-rate debt positions. Records the burn amount, user balance changes, average stable rate, and updated total supply for tracking debt repayments and interest accrual.

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_from`	`STRING`	Address originating the transfer or 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.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the 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.zerolend_v1_manta.SToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

SToken_Mint_event

Stable debt token minting events from Aave protocol lending pools. Captures stable-rate borrowing activity including borrowed amount, interest rate calculations, borrower address, and updated pool totals.

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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of 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.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the 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.zerolend_v1_manta.SToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VToken_Burn_event

Variable debt token burn events emitted when borrowers repay debt in Aave-based lending protocols. Contains user address, repayment amount, updated interest index, and accrued interest since last interaction for tracking debt position changes.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x061ca6fdf24d586ee9a4e4b4a1d61f9090ab48e9	0x8c37384480426e363941122c6bb446eed5b954d3	false	1058928495629977885945329441	8390392158574481158	0x0000000000000000000000000000000000000000	4	5018986	2025-04-11T23:23:39.000Z	0xb23a2d25fc731f4ba0e28a2403be11225ae2247c8d7b7d8fc5cf2d087c1faf96	734843258022775742
0x3da71ad7e055ee9716bba4dac53e37cddf60d509	0xf70cdd28f21c3242bd47f9735465f9df8116c14d	false	1039969873247151027122357397	2027707122519580	0x0000000000000000000000000000000000000000	18	4143720	2024-12-31T16:05:59.000Z	0x494d505a0f369c13430ee6cac26141a715b3ebb04441a563be30f09ffa904675	363766165
0x3da71ad7e055ee9716bba4dac53e37cddf60d509	0xd1cc6444fa70665f5daebcd9e23cd31b764fc76a	false	1040013754667254115872549316	12000000000000000	0x0000000000000000000000000000000000000000	4	4144426	2024-12-31T18:03:39.000Z	0x112b80adab16d6cf763d56a9c654e73bef691eff3b5dc39735c2dd8abaf45b0b	11042398322410

Example Query

Query with partition filter

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

VToken_Mint_event

Variable rate debt token mint events from lending protocols. Records debt token issuance with borrower address, borrowed amount, interest rate index, and accrued interest at the time of minting.

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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0x061ca6fdf24d586ee9a4e4b4a1d61f9090ab48e9	false	1012112355217706113612697106	170000332491425463430	0x5b8ea9b493ee25a55cf36d0ebbb8c3b24754b3a8	49	1623734	0x5b8ea9b493ee25a55cf36d0ebbb8c3b24754b3a8	2024-03-15T00:08:19.000Z	0x553b3338787179e27460df54ca6d47b9bdb8d1756dd71c2907757ba940b0808b	332491425463430
0x061ca6fdf24d586ee9a4e4b4a1d61f9090ab48e9	false	1012120331005561641522287836	10000000000000000000	0x54230e4d52e7510295ce359a030abfd1e3b84641	20	1624111	0x54230e4d52e7510295ce359a030abfd1e3b84641	2024-03-15T01:11:09.000Z	0x94aa237fb167fe45d06af6d4ee8c79d48a54976221f4e2d5557f533e5f11cf28	0
0x061ca6fdf24d586ee9a4e4b4a1d61f9090ab48e9	false	1012121362241018827729344711	1000082606840151451990	0x4004ef31c034d4bf1583c7c326704276c67aa838	25	1624162	0x4004ef31c034d4bf1583c7c326704276c67aa838	2024-03-15T01:19:39.000Z	0x5da1806f39892feab84096ee70bec72439f66afff7084827a36a2d278719c868	82606840151451990

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

Tables

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event