zerolend_v1_ethereum - Token Terminal Docs

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
0x29a3a6af690942a3b7665bb2839a3f563c6f987b	0xeb1a8c8ffbb7b35658ef925589ad71ae352f2fdf	false	1030320527906930152382657115	400000000000000000000	0xeb1a8c8ffbb7b35658ef925589ad71ae352f2fdf	227	19784295	2024-05-02T18:42:11.000Z	0xa35fa9fb12213d4bab408258e9e8d633366cad36848726fcb4a8e0e885d8d507	508936902124892558
0x68fd75cf5a91f49effad0e857ef2e97e5d1f35e7	0xf6a6f520455135f69ce093d3f72d33c2a1b72a39	false	1000001442671716032354747206	200000000000000000	0xf6a6f520455135f69ce093d3f72d33c2a1b72a39	112	19780643	2024-05-02T06:26:47.000Z	0xd50af317d43abda4b9310761272c531a306eec6f798b9240853225e6dd2943c3	0
0x68fd75cf5a91f49effad0e857ef2e97e5d1f35e7	0x0ed61a1952f34e762f16a14af603e9832c5af767	false	1000001442671716032354747206	228423188654377485	0x0ed61a1952f34e762f16a14af603e9832c5af767	145	19781989	2024-05-02T10:57:59.000Z	0xd1643adde1dee79dad03ef3f7819eb7243586a89f5d642f2dfb976702cabc8f0	329539673558

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0xb2feb2c46305329a340e6188532f31fce9347a5c	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0x10	136	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	19356953	ZeroLend USDC	2024-03-03T20:14:23.000Z	z0USDC	0x8f2471146f64476c83403a3017824693ada1b1f7cf99be1248552c80ccf1bffe	6	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x5be89bb10e2234204a2607765714916ed95a73a2
0x6c735966bc965bd4066c14fca3df443496ce14fb	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0x10	140	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	19356953	ZeroLend USDT	2024-03-03T20:14:23.000Z	z0USDT	0x8f2471146f64476c83403a3017824693ada1b1f7cf99be1248552c80ccf1bffe	6	0xdac17f958d2ee523a2206206994597c13d831ec7	0x5be89bb10e2234204a2607765714916ed95a73a2
0x29a3a6af690942a3b7665bb2839a3f563c6f987b	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0x10	132	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	19356953	ZeroLend DAI	2024-03-03T20:14:23.000Z	z0DAI	0x8f2471146f64476c83403a3017824693ada1b1f7cf99be1248552c80ccf1bffe	18	0x6b175474e89094c44da98b954eedeac495271d0f	0x5be89bb10e2234204a2607765714916ed95a73a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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	in_balanceIncrease
0x68fd75cf5a91f49effad0e857ef2e97e5d1f35e7	false	1000003330966552440062260605	290303533330	0x813b7f74d30fc5b4c0323e3108fe9c6857c55796	53	20078699	0x97bc27e86fd6e860fc20ab751d113cef6d4e126b	2024-06-12T22:21:47.000Z	0xf617045884ffa01529ca9c540aabb331f165d9eaa4aa04d3be7c7b9c778df456	290303533330
0x68fd75cf5a91f49effad0e857ef2e97e5d1f35e7	false	1000003330966552440062260605	46925844728	0x813b7f74d30fc5b4c0323e3108fe9c6857c55796	55	20078699	0xfc4eaa4ac84d00f1c5854113581f881b42b4a745	2024-06-12T22:21:47.000Z	0xf617045884ffa01529ca9c540aabb331f165d9eaa4aa04d3be7c7b9c778df456	46925844728
0x6c735966bc965bd4066c14fca3df443496ce14fb	false	1044348259479953199999677462	727552464	0x0a24c2b9683d158d33baefa0152f30196e9ed82c	178	20073993	0x0a24c2b9683d158d33baefa0152f30196e9ed82c	2024-06-12T06:35:59.000Z	0x015bbad47845be34ff9a2efa7933d9cadad320dd247a6210d594744c4cd2fa84	0

Example Query

Query with partition filter

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

ATokenBtcLrt_Burn_event

Token burn events from ZeroLend V1’s Bitcoin Liquid Restaking Token (BTC LRT) aToken contract on Ethereum, recording when interest-bearing deposit tokens are destroyed during withdrawals or redemptions. Contains burn amounts, accrued interest, and user addresses for tracking lending position closures and capital outflows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x0ea724a5571ed15209dd173b77fe3cda3f371fe3	0x8e4ec074d9d5ce19d34ef67405b6ece8126373fb	false	1008202884164916677437928941	10037724	0x8e4ec074d9d5ce19d34ef67405b6ece8126373fb	185	21299908	2024-11-30T10:30:35.000Z	0x97fe28445f0b6f252d65def0f458d2b6e0cbad8c8ca7837bf49f5c2e57e4e84e	6641
0x52bb650211e8a6986287306a4c09b73a9affd5e9	0x0a0137a32769bce3e7cefbfe2c76cbbc5b5bc2d5	false	1003133102843701335464868947	34860000	0x0a0137a32769bce3e7cefbfe2c76cbbc5b5bc2d5	188	21301317	2024-11-30T15:13:59.000Z	0x35d55e81c4580d059f0ca0974cf906a98aab7689b4e6a5c72c96dab3f8e0889d	9142
0x52bb650211e8a6986287306a4c09b73a9affd5e9	0x41e3c4014fe8c03ce6c2e193a333091e613a9093	false	1003133143673117502107252511	15223710	0x41e3c4014fe8c03ce6c2e193a333091e613a9093	410	21301329	2024-11-30T15:16:23.000Z	0x9bd78955ad368cc370c5768c79867a3bc79a42181b74ac139edb3caba4abaa6c	3995

Example Query

Query with partition filter

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

ATokenBtcLrt_Initialized_event

Interest-bearing token (aToken) initialization events from ZeroLend’s Bitcoin Liquid Restaking Token (LRT) lending pool on Ethereum. Tracks deployment of new aToken contracts for various wrapped and liquid staked BTC assets (WBTC, LBTC, eBTC, cbBTC) with their associated pool configurations.

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
0x5d9155032e3cd6bb2c6b6a448b79bacb0ff01be9	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	0x10	375	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	20820880	ZeroLend SolvBTC.BBN	2024-09-24T13:53:23.000Z	z0SolvBTC.BBN	0x7c66aafa9e27a8ebaba544dab84fa0b53a6095df8bb18b1fdef4853ec8b1c2ab	18	0xd9d920aa40f578ab794426f5c90f6c731d159def	0x938e23c10c501ce5d42bc516ecfdf5abd9c51d2b
0x0ea724a5571ed15209dd173b77fe3cda3f371fe3	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	0x10	242	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	20740550	ZeroLend cbBTC	2024-09-13T08:38:11.000Z	z0cbBTC	0x7b87d50fb11ddfd006b9bf4852722cbc561e2ca50e6d168903c2a2988ab500ac	8	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	0x938e23c10c501ce5d42bc516ecfdf5abd9c51d2b
0xd9484f9d140f3300c6527b50ff81d46a9d53acca	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	0x10	26	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	20761188	ZeroLend LBTC-PT-26DEC24	2024-09-16T05:46:47.000Z	z0LBTC-PT-26DEC24	0x83c63d24a12f2c15ef42591341f9b8f752e490dbb62abdaa8d2cffa8d1b28cd5	8	0x332a8ee60edff0a11cf3994b1b846bbc27d3dcd6	0x938e23c10c501ce5d42bc516ecfdf5abd9c51d2b

Example Query

Query with partition filter

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

ATokenBtcLrt_Mint_event

Interest-bearing aToken (BTC Liquid Restaking Token) mint events from ZeroLend v1 lending protocol on Ethereum. Tracks when users deposit BTC-based LRT collateral and receive corresponding aTokens, including caller addresses, beneficiary accounts, and minted amounts.

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
0x0ea724a5571ed15209dd173b77fe3cda3f371fe3	false	1017842671390120701939843573	107472051	0xf4673dbb9188406ff51bd421fdfa339f7dbc5aea	83	22449539	0xf4673dbb9188406ff51bd421fdfa339f7dbc5aea	2025-05-10T00:48:47.000Z	0x049ea78decc3ed0227cc307c6a4cfafcca4e8202e2fb85ea1079d6be5a048478
0x0ea724a5571ed15209dd173b77fe3cda3f371fe3	false	1017880679788677798142767756	33017	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	166	22456254	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	2025-05-10T23:30:11.000Z	0x0b1c82c7d6d4183186c07cd6d17b89555c0601841126f2f9bfdd5931e328c86c
0x1d5f4e8c842a5655f9b722cac40c6722794b75f5	false	1022663008349191223847109430	16889	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	154	22456254	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	2025-05-10T23:30:11.000Z	0x0b1c82c7d6d4183186c07cd6d17b89555c0601841126f2f9bfdd5931e328c86c

Example Query

Query with partition filter

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

ATokenEthLrt_Burn_event

AToken burn events from ZeroLend V1 lending protocol on Ethereum, tracking when users redeem their interest-bearing liquid restaking token (LRT) positions. Records the burned amount, user address, and accrued interest for analyzing withdrawal patterns and yield redemptions.

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
0xdd7afc0f014a1e1716307ff040704fa12e8d33a3	0x4cd279347bd15cca417439064ee24f5ed3391a8e	false	1000000000000000000000000000	105241853047180017	0x4cd279347bd15cca417439064ee24f5ed3391a8e	191	20282822	2024-07-11T10:59:35.000Z	0x6c65f3473275d0e7ffef70e82c332733104739f9783ca748e1688063894194da
0xdd7afc0f014a1e1716307ff040704fa12e8d33a3	0xac8ec41d441f2e843930e8d5654002acd440b910	false	1000000000000000000000000000	306042301048521970	0xac8ec41d441f2e843930e8d5654002acd440b910	270	20286462	2024-07-11T23:10:59.000Z	0xe4d0e857fdba0b024551b2a55465e4c663a5552b06bd6dd3b6db3a3b05ea6fdc
0xfb932a75c5f69d03b0f6e59573fde6976af0d88c	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	false	1028397181513896663387717876	641100000000000	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	96	20280655	2024-07-11T03:43:47.000Z	0x585cb2e1adf0d44a5d2bd0ad042f75f6b7377b8138b0a628a510066f4596ae2d

Example Query

Query with partition filter

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

ATokenEthLrt_Initialized_event

AToken initialization events from ZeroLend v1 lending protocol on Ethereum, recording when new interest-bearing tokens are deployed for underlying assets including liquid restaking tokens (LRTs) and stablecoins. Used for tracking protocol expansion and mapping between aTokens and their underlying collateral assets.

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
0x7740f60f773bc743ed76310ac1d054a4a4a17e7c	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0x10	372	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	20669217	ZeroLend PT Kelp rsETH 26SEP2024	2024-09-03T09:40:59.000Z	z0PT-rsETH-26SEP2024	0xfc020c73d3fce4a92726ae8f9e4787a912fa1832ecdcd81263447acf6e25c5a3	18	0x7baf258049cc8b9a78097723dc19a8b103d4098f	0x5be89bb10e2234204a2607765714916ed95a73a2
0xdd7afc0f014a1e1716307ff040704fa12e8d33a3	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0x10	375	0xc3f57eef47e0a4da4dae2310ea692ba360f2bbd9	19463180	ZeroLend Puffer ETH	2024-03-18T17:32:47.000Z	z0pufETH	0xd8c99d135aa3ca908f8e33b2485d7488f720882af132ec01e61fccf593e0a294	18	0xd9a442856c234a39a81a089c06451ebaa4306a72	0x5be89bb10e2234204a2607765714916ed95a73a2
0xb2db477a6c198f5c524302bb67085f8f3ab06059	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0x10	12	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	21216757	ZeroLend PT Renzo ezETH 26DEC2024	2024-11-18T19:40:59.000Z	z0PT-ezETH-26DEC2024	0xac338297b9f1bf3ec673ecafa9bbd799300812edc8b5178af553ac544c77a9f3	18	0xf7906f274c174a52d444175729e3fa98f9bde285	0x5be89bb10e2234204a2607765714916ed95a73a2

Example Query

Query with partition filter

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

ATokenEthLrt_Mint_event

Mint events for ZeroLend V1 aToken (interest-bearing token) representing deposited Ethereum Liquid Restaking Tokens (LRT), tracking deposits with accrued interest balances. Used to analyze lending pool supply growth, yield accumulation, and user deposit behavior across different LRT collateral types.

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
0xfb932a75c5f69d03b0f6e59573fde6976af0d88c	false	1058547518557660569756668256	658104037254	0x0000f2f52672181dc33210201e6c86b3cbd10000	132	21861494	0x8a7ea8bf5d72037b151df18dbe180b345917e2ed	2025-02-16T20:58:59.000Z	0xfc73e225e82ce9a67d2a4b56b4af936005191d2d1d96504981d2d626acb96a3d	658104037254
0xfb932a75c5f69d03b0f6e59573fde6976af0d88c	false	1058539900226352656685761041	163395459122327	0xc8c8a4d9730eb1416bb7b8b1fb9cba488a82316e	122	21860908	0xc8c8a4d9730eb1416bb7b8b1fb9cba488a82316e	2025-02-16T19:01:11.000Z	0x1f283e29b2e30473b23974ac71f6f20c2f631d2ba6d1cfd46ad9cb08d75dd899	192229951908620
0xfb932a75c5f69d03b0f6e59573fde6976af0d88c	false	1058539900226352656685761041	274592866206618096	0xc8c8a4d9730eb1416bb7b8b1fb9cba488a82316e	167	21860908	0xc8c8a4d9730eb1416bb7b8b1fb9cba488a82316e	2025-02-16T19:01:11.000Z	0x1f283e29b2e30473b23974ac71f6f20c2f631d2ba6d1cfd46ad9cb08d75dd899	0

Example Query

Query with partition filter

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

ATokenRwaStablecoin_Burn_event

AToken burn events from ZeroLend V1 lending protocol on Ethereum, tracking withdrawals of Real-World Asset (RWA) backed stablecoins with redemption amounts and accrued interest. Used for analyzing lending pool liquidity changes and user withdrawal patterns across RWA collateral types.

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
0x3ce38a9e2403415c50661a3f78acf4d392320e7e	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	false	1003878163181787371328367573	35615896	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	566	21272546	2024-11-26T14:33:47.000Z	0x2b9ca6eebcc8ad7ac7c9099a865b26deb48a1fa5645d154de9f5f967521f8723	0
0x3ce38a9e2403415c50661a3f78acf4d392320e7e	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	false	1003992319606811002017688428	2439732668	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	657	21275334	2024-11-26T23:52:59.000Z	0xfa01895f97a11d756da83149f101d19a823785b3c9c5b79a14533e11e5480368	0
0x3ce38a9e2403415c50661a3f78acf4d392320e7e	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	false	1003992319606811002017688428	16370321771	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	650	21275334	2024-11-26T23:52:59.000Z	0xfa01895f97a11d756da83149f101d19a823785b3c9c5b79a14533e11e5480368	38377472

Example Query

Query with partition filter

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

ATokenRwaStablecoin_Initialized_event

AToken initialization events for Real-World Asset (RWA) and stablecoin markets on ZeroLend protocol’s Ethereum deployment, recording aToken contract deployments with metadata including token names, symbols, decimals, underlying asset addresses, and linked pool/treasury/incentive controller contracts. Used to track new lending market creation and identify supported RWA and stablecoin collateral types across ZeroLend pools.

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
0x798d024f96fb220f701f4aee3bc0ef5c64dd172e	0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	0x10	118	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	21328226	ZeroLend YieldFi yToken	2024-12-04T09:25:35.000Z	z0yUSD	0x7bd3f95d22f5b0353a2b1e82b088f2286b6996f93e03bcaebf3aa0b8046a0e2b	18	0x1ce7d9942ff78c328a4181b9f3826fee6d845a97	0xbc2fdc58e3e06d265b46e32771442b7f5098725b
0xc57c57523416671e494f4594a6926f39d255674b	0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	0x10	97	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	21328226	ZeroLend YieldFi Stable Token	2024-12-04T09:25:35.000Z	z0sUSD	0x7bd3f95d22f5b0353a2b1e82b088f2286b6996f93e03bcaebf3aa0b8046a0e2b	18	0x4f8e1426a9d10bddc11d26042ad270f16ccb95f2	0xbc2fdc58e3e06d265b46e32771442b7f5098725b
0xb73ca924bf3e1c2c5ac4d7718700650d706aad73	0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	0x10	13	0x4e88e72bd81c7ea394cb410296d99987c3a242fe	21328226	ZeroLend PT Ethena sUSDE 27MAR2025	2024-12-04T09:25:35.000Z	z0PT-sUSDE-27MAR2025	0x7bd3f95d22f5b0353a2b1e82b088f2286b6996f93e03bcaebf3aa0b8046a0e2b	18	0xe00bd3df25fb187d6abbb620b3dfd19839947b81	0xbc2fdc58e3e06d265b46e32771442b7f5098725b

Example Query

Query with partition filter

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

ATokenRwaStablecoin_Mint_event

AToken minting events from ZeroLend’s real-world asset (RWA) stablecoin market on Ethereum, recording when interest-bearing tokens are issued to depositors with amounts and accrued interest. Used for tracking liquidity provision and yield generation in RWA-backed lending positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x3ce38a9e2403415c50661a3f78acf4d392320e7e	false	1039039349257259120552161082	10000000000	0x0180977da3ef0d9a2cb625afe581ea52abfdc6df	842	21982044	0x0180977da3ef0d9a2cb625afe581ea52abfdc6df	2025-03-05T17:01:47.000Z	0xa0249c35d294b4e78f146e68f0f098732dab34e6d189754c8511be707dffa279	0
0x3ce38a9e2403415c50661a3f78acf4d392320e7e	false	1038833269285608781695321804	10543550000	0x3dc5a669b6c0745e1a4b46bcc4fdf0b921580c8a	545	21981695	0x3dc5a669b6c0745e1a4b46bcc4fdf0b921580c8a	2025-03-05T15:51:35.000Z	0xf5ebc33e9a7ba9953bb458099179f1256daac8f634f0571fd52c00d48ec49c0e	0
0x3ce38a9e2403415c50661a3f78acf4d392320e7e	false	1039458567787554640541574723	8890420149	0x495690ecbd0d835815e13c0dc63f3e60e04601e8	434	21983117	0x495690ecbd0d835815e13c0dc63f3e60e04601e8	2025-03-05T20:36:59.000Z	0x0859176549e63f4cc455af357c338214d33638b15603b4ec835d466c90e47739	8595871

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.ATokenRwaStablecoin_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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xaa1c8d84680dc84ddbb0a20ed3e0c126e688b440	false	30000000	228	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	20249334	37081762236590672056538681	0xaa1c8d84680dc84ddbb0a20ed3e0c126e688b440	2024-07-06T18:42:47.000Z	0x417162b3563c9ef7a4d3a016b896ed45a27756d7a41c87f2e984a5e5b706eb09	2
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x0f6e98a756a40dd050dc78959f45559f98d3289d	false	10000000000000000	25	0xbf5495efe5db9ce00f80364c8b423567e58d2110	20619775	9004204284241026244173	0x0f6e98a756a40dd050dc78959f45559f98d3289d	2024-08-27T11:58:47.000Z	0xf62ea3ef4e4bde08795508268ba7d775b3484c2a59891caa0fe4c94ed58a1df3	2
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x0f6e98a756a40dd050dc78959f45559f98d3289d	false	10000000000000000	40	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	20619778	21871565976106329809878	0x0f6e98a756a40dd050dc78959f45559f98d3289d	2024-08-27T11:59:23.000Z	0x9f30f729b57fadea8af61b36fa80fc94c519ba09ab1083a48578996a4167eba9	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	317663645087905400	0x189cfdb4d7a08d926ca209d84a713c4c629645af	288	158831822543953	20542776	0xfb0a805e893a3a0125922078ef2ce4c265eeed23	2024-08-16T17:46:47.000Z	0x4ae1ebc650807540806cceaccdb43c42637173f9cf94b52472c661c16769d4c3
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0xbf5495efe5db9ce00f80364c8b423567e58d2110	421316413219662460	0x189cfdb4d7a08d926ca209d84a713c4c629645af	380	210658206609831	20469049	0xf285d0fcabcbaf5941b47fa282c0c1db05e15e32	2024-08-06T10:51:59.000Z	0x4e8dd330bedeeef349172cd660347ee89e58cb6a344be5b4587e374c5ad2e18b
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	1618819501736152600	0x189cfdb4d7a08d926ca209d84a713c4c629645af	146	809409750868076	20118448	0x9c19471bca230b45ab356f8b5cf5474f6427809a	2024-06-18T11:49:23.000Z	0xe7a28b3de551613bac131825a2b0a881953c2d7751d02b2b50a32c0257a301aa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x0aa5c77816584e97f5012118d706689b3d9e3ae0	false	65	19914456	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x167f6e958a1a082e33c75fab66bd511016e51340	484775558206574945	2024-05-20T23:38:11.000Z	false	0xa01855c155c80efd2c62f6a895ba6b2c69d795ada9ccdd66692b807b4705e37b	0x6b175474e89094c44da98b954eedeac495271d0f	1874062144874661082176
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x42b057b572cf0dcf826be48ec98cdf774c6a2a40	false	196	20237710	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa7bc4d21680ab2d088614951b20c9195e8d23470	1211123582	2024-07-05T03:46:11.000Z	false	0x47b0b7fe8e6ff07909229e5794488e729750ce4e153758555d409b6bf207bc37	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	431404060920744450
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x1eb4bb1fafa749c1cf83ded8ba4faafe88d5b065	false	322	20237881	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa7bc4d21680ab2d088614951b20c9195e8d23470	2434971296	2024-07-05T04:20:59.000Z	false	0x6d60161bfbeffe52141de6b27703846ec5feb3c4dd0ce823d35ca9a6631d5d67	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	884559124457297875

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.LendingPool_LiquidationCall_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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x0a3d3b1f49707422d475116aca83b0836f81f098	false	51519057110671490	291	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	20516000	false	2024-08-13T00:03:59.000Z	0x0ed37da2bb94de8899ede8583cb070f65a8207c119a9efadf55b3de1137da78d
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x17b265d2f0a3ddd8618142734b933e4b44ea0016	false	5000000000	414	0x17b265d2f0a3ddd8618142734b933e4b44ea0016	0xdac17f958d2ee523a2206206994597c13d831ec7	20516977	false	2024-08-13T03:20:35.000Z	0x50331ff2949eca1ab1b61282a8969af36ac323bb6f01e14a66aed6d0e1264685
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x38f3dc74a17fba75475fe30e2a1a01a621a631a7	false	95650814	149	0x38f3dc74a17fba75475fe30e2a1a01a621a631a7	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	19677329	false	2024-04-17T19:37:59.000Z	0xa9bdfff469295f0e7fe50280d755542fae8c13ff798073e6d9d45b50aa559bf4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x6a6a8ce52758adf46c181ba8c2d43a38a24b1d22	false	693827412385055357662	516	0x6b175474e89094c44da98b954eedeac495271d0f	19644527	0x6a6a8ce52758adf46c181ba8c2d43a38a24b1d22	2024-04-13T05:19:35.000Z	0xdf596b388a0127b18f16e3f994147816aaf513c2a06a5ffdfa686bc246bbc7ce
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x29ccf5c9bf9f911bb843dbf7dec35da872e5abe1	false	1850285605	496	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	19646494	0x29ccf5c9bf9f911bb843dbf7dec35da872e5abe1	2024-04-13T11:56:59.000Z	0x72029d5e69c0c2c205ff7394393e9f75d740f185aba8acc5be738ad35cd289e4
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x59688454b00405d84d104b52601c0b9861247721	false	881762601	273	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	19647066	0x59688454b00405d84d104b52601c0b9861247721	2024-04-13T13:52:11.000Z	0xdf522c852c927e6b8278df2f581eb161e164bd34b724d10f88569af50f2f46e8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0x08afa0eef6e44677374336c974858ecdf3ea96d1	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x08afa0eef6e44677374336c974858ecdf3ea96d1	false	110289990462401983103	376	0x6b175474e89094c44da98b954eedeac495271d0f	20068872	2024-06-11T13:26:11.000Z	0x42286434577b5dec08611fc708b5736c6346a5bc3c6e1762c0653f74e8358da0
0xc952e9ac81e13f183dfa3c3d454ed4316f7aea70	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xc952e9ac81e13f183dfa3c3d454ed4316f7aea70	false	40735603	236	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	20066913	2024-06-11T06:51:59.000Z	0x14bdcb882234d2a5b69c6579e656ca6ff49da9e30ada0a6b262d31a543d74e3e
0xaa96661ee845ffad9f29fb8d9360da7fbabcd391	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xaa96661ee845ffad9f29fb8d9360da7fbabcd391	false	19794094277827978	267	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	20066454	2024-06-11T05:19:47.000Z	0xd408661bc966d41a920094e652698326eb72e2b3778d04f9128ae42265f29c16

Example Query

Query with partition filter

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

LendingPoolBtcLrt_Borrow_event

Borrow transaction events from ZeroLend V1’s BTC LRT (Liquid Restaking Token) lending pool on Ethereum, capturing loan originations with borrowed amounts, interest rates, and user addresses. Used for analyzing borrowing activity, rate dynamics, and leverage patterns in BTC-backed 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_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
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0xf4673dbb9188406ff51bd421fdfa339f7dbc5aea	false	500000000000000000	161	0xd9d920aa40f578ab794426f5c90f6c731d159def	22449542	535587300162559279135837048	0xf4673dbb9188406ff51bd421fdfa339f7dbc5aea	2025-05-10T00:49:23.000Z	0x0e88e31984c50547bf366960c33656add3a705f484ba973e485dbec4a9d76647	2
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x4775ca26bd675cf59ed2609cfdc18dd6818f0c96	false	58963265	133	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	20755368	56453695883976180057781900	0x4775ca26bd675cf59ed2609cfdc18dd6818f0c96	2024-09-15T10:18:23.000Z	0x6514a85a9154b7c24bda39478f1a91db87ca887d0ea547f19558b40c71c45207	2
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x4c4740fe779442843cc0670ac1bd4c4163183354	false	25348020	44	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	20757315	33908424024595160616368530	0x4c4740fe779442843cc0670ac1bd4c4163183354	2024-09-15T16:49:23.000Z	0x033e0095c7e6029f095f31faf64e1c155b02411a35e6e37cd98b8ac31406a4c1	2

Example Query

Query with partition filter

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

LendingPoolBtcLrt_FlashLoan_event

Flash loan events from ZeroLend’s Bitcoin Liquid Restaking Token (BTC LRT) lending pool on Ethereum. Tracks uncollateralized loans with asset amounts, borrower addresses, premiums, and interest rate modes for analyzing arbitrage strategies and protocol usage patterns.

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	block_number	in_initiator	block_timestamp	transaction_hash	in_interestRateMode
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	42762580	0x25c9022dc4f3c333fa4530fb18bdf1834297985c	222	20742865	0x25c9022dc4f3c333fa4530fb18bdf1834297985c	2024-09-13T16:24:23.000Z	0x774079817c9a88054e9e9bda0e42192ba05334d9af9a03e303b0ea2db3ae7cca	2
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	163865487	0xf3d41fc99c8e969284150ca28b4d98b0feb10330	165	20743128	0xf3d41fc99c8e969284150ca28b4d98b0feb10330	2024-09-13T17:17:23.000Z	0xd6f43e476defd17fd48a735c1b44ea0dab89e799d090da5390accccf72fb2f26	2
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	316764485	0x6c725bf910807c0f5694d60afdd7e302b42cd404	246	20744081	0x6c725bf910807c0f5694d60afdd7e302b42cd404	2024-09-13T20:28:35.000Z	0x595e96edec75911ef5e193043a43d2a64e3fb9ff67a5cf7446c2e4c0533725b7	2

Example Query

Query with partition filter

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

LendingPoolBtcLrt_LiquidationCall_event

Liquidation events from ZeroLend v1’s Bitcoin Liquid Restaking Token (BtcLrt) lending pool on Ethereum, capturing undercollateralized position seizures with debt repayment and collateral seizure amounts. Used for analyzing liquidator activity, collateral ratios, and protocol health across BTC and BTC-LRT 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_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
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x847c15140958fef6895cfa52b0258dbd0a3024d5	false	663	22542109	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x3c74497c25c6dfc306e7302751dd1bfa55f1e586	169624	2025-05-23T00:52:11.000Z	false	0x2ad117621b063c99b04641aa01cb0f0838b3b06a218464cdfecd2161a9549a2d	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	175730
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0xb4c8158a47294cfc7beb2d74b32849c22c9189ed	false	469	22544342	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	0x3c74497c25c6dfc306e7302751dd1bfa55f1e586	225997	2025-05-23T08:21:59.000Z	false	0x875c2c7ab19a03812b56dd9d062d8ce6f7fb3afb603deb5acc548860ed7353b4	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	234133
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x42efae05e0b76f5d2f16aa325d6ea3f3192a1eaf	false	189	21551970	0x8236a87084f8b84306f72007f36f2618a5634494	0x720ff7451a5883574dfde3be5c5d1ebfdbc9edb3	3441725	2025-01-04T15:20:11.000Z	false	0xb7127fbf1ef42195ab8f57a1b55587796cfce2585480aa6edbd095937cab301b	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	3565627

Example Query

Query with partition filter

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

LendingPoolBtcLrt_MintedToTreasury_event

Treasury minting events from ZeroLend’s Bitcoin Liquid Restaking Token (BTC LRT) lending pool on Ethereum, recording protocol fee accrual amounts for various BTC-related reserves. Used for tracking protocol revenue and treasury accumulation across wrapped Bitcoin and liquid staking derivatives.

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
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	385	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	21342610	2024-12-06T09:38:11.000Z	4750807	0x5f9c7899529500a7a96350b56bd0c43e107ec218ca9dcac89f8195b023e3277a
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	381	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21342610	2024-12-06T09:38:11.000Z	97659	0x5f9c7899529500a7a96350b56bd0c43e107ec218ca9dcac89f8195b023e3277a
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	false	389	0x8236a87084f8b84306f72007f36f2618a5634494	21342610	2024-12-06T09:38:11.000Z	7535935	0x5f9c7899529500a7a96350b56bd0c43e107ec218ca9dcac89f8195b023e3277a

Example Query

Query with partition filter

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

LendingPoolBtcLrt_Repay_event

Loan repayment events from ZeroLend’s Bitcoin Liquid Restaking Token (BTC LRT) lending pool on Ethereum, capturing repayment amounts, reserve assets, and whether aTokens were used for repayment. Used for tracking debt reduction activity and borrower behavior in BTC-backed lending positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0xae7f281a92834dbfa1e94f1fd23c5b0b3735615d	false	140371478	257	0xae7f281a92834dbfa1e94f1fd23c5b0b3735615d	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	21706018	false	2025-01-26T03:30:59.000Z	0x084f75906444e32841e9fad029ecc83f5d9754bc767ea50e26b17ddb8db349c3
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x10daaddfcbf9dcade8939b9149fb4a67db2c22b2	false	935478	492	0x10daaddfcbf9dcade8939b9149fb4a67db2c22b2	0x8236a87084f8b84306f72007f36f2618a5634494	21708460	false	2025-01-26T11:42:11.000Z	0xe98e1835b55acf2ba83d12b0d39275f893db10c39470e0451924a7e6fcb6d81e
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x10daaddfcbf9dcade8939b9149fb4a67db2c22b2	false	172194	345	0x10daaddfcbf9dcade8939b9149fb4a67db2c22b2	0x8236a87084f8b84306f72007f36f2618a5634494	21708470	false	2025-01-26T11:44:11.000Z	0xef6af6649934ebba6e71d1fb6d46028d798760028722508346a8a10e4230d75c

Example Query

Query with partition filter

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

LendingPoolBtcLrt_Supply_event

Supply events from ZeroLend’s Bitcoin Liquid Restaking Token (LRT) lending pool on Ethereum, capturing deposit transactions with user addresses, reserve tokens, and supplied amounts. Used for tracking liquidity provision and analyzing depositor behavior in the Bitcoin LRT lending market.

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
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x1766ffb3711a6e816ecddbd7ae36f4041becda7c	false	151315	172	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21018951	0x1766ffb3711a6e816ecddbd7ae36f4041becda7c	2024-10-22T05:12:23.000Z	0xd0e48944dab674d1973ef9797845876290dd3d6dead1f9830cba735901fbaf72
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x200c2725b2d31aa054a37f968efee0336b83b307	false	1038628	180	0x332a8ee60edff0a11cf3994b1b846bbc27d3dcd6	21018635	0x200c2725b2d31aa054a37f968efee0336b83b307	2024-10-22T04:08:59.000Z	0x0fb13467d604dd88ce87ebae80049664c2156b925b9ce85ba7d56eeb94c48414
0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x6723f512657fb15858089704d546215913effef3	false	434555731	378	0x332a8ee60edff0a11cf3994b1b846bbc27d3dcd6	21018985	0x6723f512657fb15858089704d546215913effef3	2024-10-22T05:19:11.000Z	0x8bb84fdaaecb802e7d45297dba5abaac7bc740ec35ee59c4435858183785573a

Example Query

Query with partition filter

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

LendingPoolBtcLrt_Withdraw_event

Withdrawal events from ZeroLend’s Bitcoin Liquid Restaking Token (BTC LRT) lending pool on Ethereum, capturing when users withdraw reserves with user address, recipient address, reserve token, and withdrawal amount. Used for tracking lending pool liquidity outflows and user withdrawal patterns across various BTC-derivative assets.

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
0x6cae28b3d09d8f8fc74ccd496ac986fc84c0c24e	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x83c6bc664a5a5099abf91ea0220ed0cecbe6ecf3	false	5047748	300	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	22304214	2025-04-19T16:22:11.000Z	0x19cac70126b99157cb5e33090ac584e4f48c02b7c26d7222247f30192f84756d
0x33c0389405e00c821a917235ff21a0d782b6f93d	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x33c0389405e00c821a917235ff21a0d782b6f93d	false	8657135	284	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	22303752	2025-04-19T14:49:11.000Z	0x1b7058ef2522319a58cdae9caefe938ee471bbe233a8a39c95132bca7fc80d92
0x6138e156b4cb78350ccc749e560404bb6425a3ec	0xcd2b31071119d7ea449a9d211ac8ebf7ee97f987	0x6138e156b4cb78350ccc749e560404bb6425a3ec	false	79507	75	0x8236a87084f8b84306f72007f36f2618a5634494	22306344	2025-04-19T23:30:11.000Z	0xd955aedcd82e0e95046d1575a8ed2d67957ee1ceeee09be15d911daafca3616a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.LendingPoolBtcLrt_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
9000	0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x7baf258049cc8b9a78097723dc19a8b103d4098f	383	20669217	2024-09-03T09:40:59.000Z	0xfc020c73d3fce4a92726ae8f9e4787a912fa1832ecdcd81263447acf6e25c5a3	10500	9500
5000	0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xf951e335afb289353dc249e82926178eac7ded78	342	19655703	2024-04-14T18:57:11.000Z	0x437edfac586b977ab775054834b3bd8a84f3c220a5a7eb5b01e366e04367e179	11000	8000
0	0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x7baf258049cc8b9a78097723dc19a8b103d4098f	230	20827470	2024-09-25T11:57:59.000Z	0x1dd4bf8255c948766e93d5b932bdd93670c25a01f6715a82b3be29b266e7659f	10400	9500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.LendingPoolConfigurator_CollateralConfigurationChanged_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	in_oldReserveFactor
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	197	20625285	2024-08-28T06:26:11.000Z	0x5c5f49f1e8eade4089374da58e1073323323f199facc094dc6b4543e99ad1d89	1500	3000
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x6b175474e89094c44da98b954eedeac495271d0f	257	19479842	2024-03-21T01:41:11.000Z	0x87bb3b67f26aa431332cf6ecc627a3acef8891e211f325ea53c95c306ac232ba	500	5000
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xdac17f958d2ee523a2206206994597c13d831ec7	259	19479842	2024-03-21T01:41:11.000Z	0x87bb3b67f26aa431332cf6ecc627a3acef8891e211f325ea53c95c306ac232ba	500	5000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x7baf258049cc8b9a78097723dc19a8b103d4098f	0x7740f60f773bc743ed76310ac1d054a4a4a17e7c	375	20669217	2024-09-03T09:40:59.000Z	0xfc020c73d3fce4a92726ae8f9e4787a912fa1832ecdcd81263447acf6e25c5a3	0x8983845311f9df4465b8a94713a2d5824b943251	0xb8d45c7fbbbc6e1d36bc1caa7d43dcc7d0513cfd	0xcbdc0aed7cdf2472784068abef23a902cafabb98
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xf951e335afb289353dc249e82926178eac7ded78	0xb7cadc9cdfbbef6d230dd99a7c62e294fc44bfc6	41	19655674	2024-04-14T18:51:23.000Z	0xc068b96584885e58f4e424f7ae8ff50f1f69735092858fa08dd9f63000339324	0x9924462b20a93551efbec5eecc437b632b3cb48c	0xb04adaff2f221f63b977185f5a7d8ee49aacbaff	0xcbdc0aed7cdf2472784068abef23a902cafabb98
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x6b175474e89094c44da98b954eedeac495271d0f	0x29a3a6af690942a3b7665bb2839a3f563c6f987b	135	19356953	2024-03-03T20:14:23.000Z	0x8f2471146f64476c83403a3017824693ada1b1f7cf99be1248552c80ccf1bffe	0x8569052157069ed81f603001596ee8ae1c85e049	0x0047cac82cf5fb36954de1b9d86d657915ab3b47	0xa32eb787f2a3dc1f2c2da0e5d8cae7ff74e6fd32

Example Query

Query with partition filter

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

LendingPoolConfiguratorBtcLrt_CollateralConfigurationChanged_event

Collateral configuration updates for Bitcoin Liquid Restaking Token (BTC LRT) assets in ZeroLend’s lending pool on Ethereum, including loan-to-value (LTV) ratios, liquidation thresholds, and liquidation bonuses. Used for tracking risk parameter changes across different BTC-derivative collateral types.

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

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0xec5a52c685cc3ad79a6a347abace330d69e0b1ed	444	21981573	2025-03-05T15:27:11.000Z	0x6919daba140e729f8933cccdbcdcf5153561af633fdea4802f3400a7e56e25ce	10300	8700
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0x44a7876ca99460ef3218bf08b5f52e2dbe199566	290	21981583	2025-03-05T15:29:11.000Z	0x65c38e29b47946ec0dd9903ff76e1b9bd0984e2edaf8b02bde8e38c5014b3439	10300	8700
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0x332a8ee60edff0a11cf3994b1b846bbc27d3dcd6	226	21473012	2024-12-24T14:45:59.000Z	0xf8ec635c8acd1645a843ea7c74adacb9aea358a8e96ede473fd8a1d0b6e9394d	10400	9500

Example Query

Query with partition filter

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

LendingPoolConfiguratorBtcLrt_LiquidationProtocolFeeChanged_event

Protocol fee change events from ZeroLend’s Bitcoin Liquid Restaking Token (BTC LRT) lending pool configurator on Ethereum. Tracks liquidation fee adjustments for collateral assets, showing old and new fee values in basis points for governance and fee structure 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_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

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0x18084fba666a33d37592fa2633fd49a74dd93a88	3000	714	22181669	2025-04-02T13:56:47.000Z	0x0f1575e4a5b80c9821a42b95f37b6d60730449584775b674349c7972a257d52b
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0x2f913c820ed3beb3a67391a6eff64e70c4b20b19	3000	351	21071614	2024-10-29T13:33:23.000Z	0x65babaa4ab8ddd7b9c1bfa978a2efae02e44ff935bd9861531a6a3def63aaf13
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0xb997b3418935a1df0f914ee901ec83927c1509a0	1000	961	20690404	2024-09-06T08:37:35.000Z	0x29725cb090270a25183a95d88cfc076689d546e892df421f9385f7fe21a1229f

Example Query

Query with partition filter

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

LendingPoolConfiguratorBtcLrt_ReserveFactorChanged_event

Reserve factor adjustment events from ZeroLend’s Bitcoin Liquid Restaking Token (BtcLRT) lending pool configurator on Ethereum. Tracks protocol fee parameter changes for individual assets, showing transitions in the percentage of interest reserved by the protocol.

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	in_oldReserveFactor
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0xd9d920aa40f578ab794426f5c90f6c731d159def	633	20929466	2024-10-09T17:15:35.000Z	0x67c8eb4964c3e9dcb8d02807b4277a8b55ad3e5dcd2dc6af3904406a951af544	3000	0
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	73	20929461	2024-10-09T17:14:35.000Z	0x76bdf81bceb16d5d4b848b57e7623c11a8ea4c198202023a897f83a2a7f572f7	3000	1000
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0x8236a87084f8b84306f72007f36f2618a5634494	144	20929462	2024-10-09T17:14:47.000Z	0x6eeb97d47f23377a41352790452a9f42c59c51c3b77df7275d6d3229002f41eb	3000	1000

Example Query

Query with partition filter

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

LendingPoolConfiguratorBtcLrt_ReserveInitialized_event

Reserve initialization events from ZeroLend’s Bitcoin Liquid Restaking Token (BTC LRT) lending pool configurator on Ethereum. Records deployment of new lending markets including aToken, debt token contracts, and interest rate strategy assignments for analyzing protocol expansion and BTC-related collateral additions.

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
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	0x0ea724a5571ed15209dd173b77fe3cda3f371fe3	245	20740550	2024-09-13T08:38:11.000Z	0x7b87d50fb11ddfd006b9bf4852722cbc561e2ca50e6d168903c2a2988ab500ac	0xa8ce68264e58c0a0b2553a28890af090b0855b28	0x0519d972fdca215e6b555b0bb4d8d95704206b58	0x3789f77acfee511396fd97900e77450a5f1db19b
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0xd9d920aa40f578ab794426f5c90f6c731d159def	0x5d9155032e3cd6bb2c6b6a448b79bacb0ff01be9	378	20820880	2024-09-24T13:53:23.000Z	0x7c66aafa9e27a8ebaba544dab84fa0b53a6095df8bb18b1fdef4853ec8b1c2ab	0xfae48848b299553ea3061c0257a86e8b36b43e53	0x250d1435b02ddce933f73317feeba58f78861108	0x92a8334c72bf62bfcbe27302bb5d11c47487e821
0x6864b4dbfb0c2ee6d1135cd7f5f896ecef03ff93	false	0xb997b3418935a1df0f914ee901ec83927c1509a0	0x75351765d44e322681dceb691c85eace247e5627	80	20690396	2024-09-06T08:35:59.000Z	0x90d71744fcd6a5a6fd760f6c991846057862dd2eded2026e32b470ed3e92f3fa	0x10c71923abfdae4dbe5e78df23fd98f9787ecb80	0xcfbfcfdd63fb2305b433cbf433d7eba21d8bf0ea	0x716cbffecf07cdf411946891cdcb5e12460690d3

Example Query

Query with partition filter

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

LendingPoolConfiguratorEthLrt_CollateralConfigurationChanged_event

Collateral configuration change events from ZeroLend’s Ethereum Liquid Restaking Token (LRT) lending pool, capturing loan-to-value (LTV), liquidation threshold, and liquidation bonus parameters for supported assets. Used for tracking risk parameter adjustments and collateral policy evolution across different token types.

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
7000	0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xbf5495efe5db9ce00f80364c8b423567e58d2110	143	19356973	2024-03-03T20:18:23.000Z	0x47ff72a8f202b7d15323aa2c18c6794e805a54f8726ff0cbc5c11e2a05e18e0f	10500	8000
7000	0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	139	19356973	2024-03-03T20:18:23.000Z	0x47ff72a8f202b7d15323aa2c18c6794e805a54f8726ff0cbc5c11e2a05e18e0f	10500	8000
7000	0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	147	19356973	2024-03-03T20:18:23.000Z	0x47ff72a8f202b7d15323aa2c18c6794e805a54f8726ff0cbc5c11e2a05e18e0f	10500	8000

Example Query

Query with partition filter

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

LendingPoolConfiguratorEthLrt_LiquidationProtocolFeeChanged_event

Event logs tracking changes to liquidation protocol fees for assets in ZeroLend’s Ethereum LRT (Liquid Restaking Token) lending pool configurator. Records fee adjustments with old and new values in basis points (e.g., 3000 = 30%) for protocol revenue 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_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

address	removed	in_asset	in_newFee	in_oldFee	log_index	block_number	block_timestamp	transaction_hash
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xf7906f274c174a52d444175729e3fa98f9bde285	3000	0	19	21216757	2024-11-18T19:40:59.000Z	0xac338297b9f1bf3ec673ecafa9bbd799300812edc8b5178af553ac544c77a9f3

Example Query

Query with partition filter

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

LendingPoolConfiguratorEthLrt_ReserveFactorChanged_event

Reserve factor parameter changes for lending assets in ZeroLend’s Ethereum Liquid Restaking Token (LRT) pool configurator. Tracks protocol revenue allocation adjustments across different collateral assets including stablecoins and liquid staking derivatives.

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	in_oldReserveFactor
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x6b175474e89094c44da98b954eedeac495271d0f	257	19479842	2024-03-21T01:41:11.000Z	0x87bb3b67f26aa431332cf6ecc627a3acef8891e211f325ea53c95c306ac232ba	500	5000
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xdac17f958d2ee523a2206206994597c13d831ec7	259	19479842	2024-03-21T01:41:11.000Z	0x87bb3b67f26aa431332cf6ecc627a3acef8891e211f325ea53c95c306ac232ba	500	5000
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	258	19479842	2024-03-21T01:41:11.000Z	0x87bb3b67f26aa431332cf6ecc627a3acef8891e211f325ea53c95c306ac232ba	500	5000

Example Query

Query with partition filter

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

LendingPoolConfiguratorEthLrt_ReserveInitialized_event

Reserve initialization events from ZeroLend’s Ethereum Liquid Restaking Token (LRT) lending pool configurator, recording when new assets are added to the protocol with their associated aToken, debt token, and interest rate strategy addresses. Used for tracking market expansion and protocol configuration 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_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
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x7baf258049cc8b9a78097723dc19a8b103d4098f	0x7740f60f773bc743ed76310ac1d054a4a4a17e7c	375	20669217	2024-09-03T09:40:59.000Z	0xfc020c73d3fce4a92726ae8f9e4787a912fa1832ecdcd81263447acf6e25c5a3	0x8983845311f9df4465b8a94713a2d5824b943251	0xb8d45c7fbbbc6e1d36bc1caa7d43dcc7d0513cfd	0xcbdc0aed7cdf2472784068abef23a902cafabb98
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0xf951e335afb289353dc249e82926178eac7ded78	0xb7cadc9cdfbbef6d230dd99a7c62e294fc44bfc6	41	19655674	2024-04-14T18:51:23.000Z	0xc068b96584885e58f4e424f7ae8ff50f1f69735092858fa08dd9f63000339324	0x9924462b20a93551efbec5eecc437b632b3cb48c	0xb04adaff2f221f63b977185f5a7d8ee49aacbaff	0xcbdc0aed7cdf2472784068abef23a902cafabb98
0x09edc8f101897aa693932c1966725e05d6d68b5f	false	0x8c9532a60e0e7c6bbd2b2c1303f63ace1c3e9811	0xd9855847ffd9bc0c5f3effbef67b558dbf090a71	305	20619742	2024-08-27T11:52:11.000Z	0x2aa41762efc3f5cf0e7d4763b0f3ec6c83f8f2c25daf4b897c6b419967b20377	0x7333113ac92a86e7d562fbe9f03c62d2007cd295	0x8e3e54599d6f40c8306b895214f54882d98cd2b5	0xcbdc0aed7cdf2472784068abef23a902cafabb98

Example Query

Query with partition filter

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

LendingPoolConfiguratorRwaStablecoin_CollateralConfigurationChanged_event

Collateral parameter configuration changes for real-world asset (RWA) stablecoin markets on ZeroLend v1 Ethereum, capturing loan-to-value (LTV), liquidation threshold, and liquidation bonus updates for each asset. Used for tracking risk parameter adjustments and governance actions in RWA 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
9000	0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x0022228a2cc5e7ef0274a7baa600d44da5ab5776	52	21126999	2024-11-06T07:03:59.000Z	0x715b6453d5156ebc110440dce8d46164386c3f62b82b12d4762262a388ae3aba	10400	9500
9000	0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x5bae9a5d67d1ca5b09b14c91935f635cfbf3b685	72	21126999	2024-11-06T07:03:59.000Z	0x715b6453d5156ebc110440dce8d46164386c3f62b82b12d4762262a388ae3aba	10400	9500
0	0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x270d664d2fc7d962012a787aec8661ca83df24eb	275	21127782	2024-11-06T09:41:47.000Z	0x41369ffb32f70bbdd7496140f8f036c5aca163b57a6a28db015beb1575d1a544	10500	9500

Example Query

Query with partition filter

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

LendingPoolConfiguratorRwaStablecoin_LiquidationProtocolFeeChanged_event

Liquidation protocol fee adjustment events from ZeroLend’s Real-World Asset (RWA) stablecoin lending pool configurator on Ethereum. Tracks fee changes per asset with old and new fee values in basis points for monitoring protocol revenue parameters.

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

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x9d39a5de30e57443bff2a8307a4256c8797a3497	3000	145	21276880	2024-11-27T05:04:47.000Z	0x74371dd226bfcc697473bf2539fb0b66ea9576b36d0a854ebe291532feb92f8b
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	3000	166	21276880	2024-11-27T05:04:47.000Z	0x74371dd226bfcc697473bf2539fb0b66ea9576b36d0a854ebe291532feb92f8b
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x1a88df1cfe15af22b3c4c783d4e6f7f9e0c1885d	3000	208	21276880	2024-11-27T05:04:47.000Z	0x74371dd226bfcc697473bf2539fb0b66ea9576b36d0a854ebe291532feb92f8b

Example Query

Query with partition filter

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

LendingPoolConfiguratorRwaStablecoin_ReserveFactorChanged_event

Reserve factor configuration changes for Real World Asset (RWA) stablecoin markets on ZeroLend’s Ethereum lending protocol. Tracks adjustments to the protocol’s revenue share percentage for each asset reserve, useful for monitoring risk parameter governance decisions.

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
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x939778d83b46b456224a33fb59630b11dec56663	386	20804634	2024-09-22T07:30:35.000Z	0x99ce7ea9ccef3da58365a5986730521d766b1f94860d10027bd8dca303495624	1000
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0x69000405f9dce69bd4cbf4f2865b79144a69bfe0	379	20804634	2024-09-22T07:30:35.000Z	0x99ce7ea9ccef3da58365a5986730521d766b1f94860d10027bd8dca303495624	1000
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0xdc035d45d973e3ec169d2276ddab16f1e407384f	372	20804634	2024-09-22T07:30:35.000Z	0x99ce7ea9ccef3da58365a5986730521d766b1f94860d10027bd8dca303495624	1000

Example Query

Query with partition filter

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

LendingPoolConfiguratorRwaStablecoin_ReserveInitialized_event

Reserve initialization events from ZeroLend’s RWA (Real-World Asset) stablecoin lending pool configurator on Ethereum, recording when new assets are added to the protocol with their corresponding aToken, stable debt token, variable debt token, and interest rate strategy addresses. Used for tracking lending market expansions and reserve configuration 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_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
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x3ce38a9e2403415c50661a3f78acf4d392320e7e	155	20804626	2024-09-22T07:28:59.000Z	0xa53ff77a6dd3f559bdb56d2ebc7e481feb0bf98186270cd1b14ef3f510471589	0xbbf306933b1a0e8f0f7e9e4cbc49cc83e2969ddf	0xda6991cf0eb96d29d42682bd201b678944bf9d6b	0x6b534c6904ee137b021490622a24c8fff89f5a63
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0xdc035d45d973e3ec169d2276ddab16f1e407384f	0x6125f4a075a793d53307f077d22671c57f4d1d1a	163	20804626	2024-09-22T07:28:59.000Z	0xa53ff77a6dd3f559bdb56d2ebc7e481feb0bf98186270cd1b14ef3f510471589	0x35d76f23ce40c91a9601f4d776195fde7c38b60c	0x2e15d7e91a4cdc41f7feb0e1060161ff53d8a388	0x6b534c6904ee137b021490622a24c8fff89f5a63
0x0faae8092a240e7517be28af51da5fd3566fb364	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0x4aeafa9f24096bfe4b7354c16b2d34e2a7b92b78	159	20804626	2024-09-22T07:28:59.000Z	0xa53ff77a6dd3f559bdb56d2ebc7e481feb0bf98186270cd1b14ef3f510471589	0xf4bd886991234a94e7b1ef6d4032bb6373e27135	0xe7a632694dc4ac65583248aaf92fb5becb54011e	0x6b534c6904ee137b021490622a24c8fff89f5a63

Example Query

Query with partition filter

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

LendingPoolEthLrt_Borrow_event

Borrow event logs from ZeroLend V1 Ethereum Liquid Restaking Token (LRT) lending pool, capturing loan originations with borrowed amounts, interest rates, and collateral reserve addresses. Used for tracking borrowing activity, analyzing interest rate modes, and monitoring delegated borrowing through onBehalfOf addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x487c6480c33f32435f99cfa4b1e09c0d4e4165f7	false	2200062089	301	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	20386538	88961269244963974956616444	0x487c6480c33f32435f99cfa4b1e09c0d4e4165f7	2024-07-25T22:26:59.000Z	0xb26a41a6a4f35ad1a3988ad98012e1cc756994ed61de3a94d3c24ad50489457e	2
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	false	70000000000000000	1022	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	20014805	34035162802867020663312008	0x3777d156916bca8602cb083b41b1e172e508e769	2024-06-04T00:14:35.000Z	0x88377a61ffae79028c94cf18e33b028e83ebc17e0675ae26a4213a99d8ead2d0	2
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x57eed9235db3c99bd4bb0446a73c03f4bcfb1da3	false	1700000000	210	0xdac17f958d2ee523a2206206994597c13d831ec7	20019240	34476487008533877700266181	0x57eed9235db3c99bd4bb0446a73c03f4bcfb1da3	2024-06-04T15:05:47.000Z	0x58128d010cdbee189c370ec9324d1e2eaf336f860e7c890c4e2acf846f29f219	2

Example Query

Query with partition filter

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

LendingPoolEthLrt_FlashLoan_event

Flash loan events from ZeroLend V1’s Ethereum LRT (Liquid Restaking Token) lending pool, capturing uncollateralized loan executions with borrowed asset addresses, amounts, premiums, and initiator/target contracts. Used for analyzing flash loan arbitrage activity, MEV strategies, and instant liquidity usage patterns across Ethereum liquid restaking tokens.

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	in_interestRateMode
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	2122403894393005300	0x189cfdb4d7a08d926ca209d84a713c4c629645af	169	1061201947196503	19755989	0x487c6480c33f32435f99cfa4b1e09c0d4e4165f7	2024-04-28T19:46:23.000Z	0xd221d01edc5d861dca9bd1bad8bba88f79832872cebbf3cdf75dd06a49b317a2	0
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	802511700862483151	0x917b8b0e35ed1781953ed45128edef6333a2dd3a	288	0	22589354	0x917b8b0e35ed1781953ed45128edef6333a2dd3a	2025-05-29T15:40:23.000Z	0xe81508e199484334116e968279d7e0352b8f40b438ee5041c2fbdf5dfd9d17d4	2
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	false	0xbf5495efe5db9ce00f80364c8b423567e58d2110	2457032231163712	0xd804ac51dc478ccf46a8b5d1a23909d7a6609312	151	0	20739133	0xd804ac51dc478ccf46a8b5d1a23909d7a6609312	2024-09-13T03:53:47.000Z	0x6bbbbb52daa405fc2c70fce9ba1505f50a6231c478a747aa9af241344ecc96e5	2

Example Query

Query with partition filter

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

LendingPoolEthLrt_LiquidationCall_event

Liquidation events from ZeroLend v1’s Ethereum Liquid Restaking Token (LRT) lending pool, capturing when undercollateralized positions are liquidated with debt repaid and collateral seized. Records include liquidator and borrower addresses, debt and collateral asset pairs, amounts covered, and whether liquidators received aTokens or underlying assets.

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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x1eb4bb1fafa749c1cf83ded8ba4faafe88d5b065	false	312	22215215	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x4ab12e7ce31857ee022f273e8580f73335a73c0b	81399826	2025-04-07T06:23:47.000Z	false	0x18752385c870ba5b7e5bf968e1560effcfda212128d9d6a5b920d6831266e4f7	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	54262101272489832
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x5014f5cf5f9f14033316c333245b66189a709537	false	462	22213548	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa090fc409a9f25bf8e28257d42ef6904590c8984	70608771	2025-04-07T00:48:47.000Z	false	0x1bf71e867046316009233259b6dd9773caf57b9daba9c4890121927fa32d3395	0xbf5495efe5db9ce00f80364c8b423567e58d2110	45666185392917728
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xfa5c23b9043a2ebd7315d9d1c3804225e4f45740	false	587	22216563	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa090fc409a9f25bf8e28257d42ef6904590c8984	158035634	2025-04-07T10:55:35.000Z	false	0x2af8b05c59368f223d29c9a5f4504402daf01b3f7565c02c62eed2c37c67c104	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	110887320128597427

Example Query

Query with partition filter

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

LendingPoolEthLrt_MintedToTreasury_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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

No sample data available.

Example Query

Query with partition filter

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

LendingPoolEthLrt_Repay_event

Loan repayment events from ZeroLend V1 LendingPool ETH LRT (Liquid Restaking Token) market on Ethereum, capturing repayment amounts, borrower and repayer addresses, and reserve tokens. Used for analyzing debt repayment patterns and liquidation activity in restaking-enabled 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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x39ae00d3bfe82b2168969891150afb6da5579eb9	false	2399850235828896598	283	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	20002898	false	2024-06-02T08:19:23.000Z	0x77578ddbd23f289a3738cf41ff3a60f62be6d5045393339ec17fc481fbbf219a
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xaa96661ee845ffad9f29fb8d9360da7fbabcd391	false	122264777574649826	246	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	20002869	false	2024-06-02T08:13:35.000Z	0xbaad104c9b11d1f091a0082aa8f29642cccd643dab0c43b8eb166c347a968738
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xb438593e0e43f4fb9f8d655d8ed883cc23c384a8	false	2000000000000000000	220	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	20001215	false	2024-06-02T02:40:35.000Z	0x45a8e29227e98f0abac0245a77ad6637965bd949a1809fc5114e4a51d9423a4e

Example Query

Query with partition filter

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

LendingPoolEthLrt_Supply_event

Supply deposit events from ZeroLend’s Ethereum Liquid Restaking Token (LRT) lending pool. Tracks user deposits of ERC-20 tokens including WETH, USDC, USDT, and DAI with amounts, beneficiary addresses, and optional referral codes for analyzing 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_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
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xcffc88c705af9e89394f0ed3602cf84fac1118fd	false	581661408985032909	128	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	21520147	0xcffc88c705af9e89394f0ed3602cf84fac1118fd	2024-12-31T04:44:11.000Z	0x8fdf21ade9a84d6d59ff33fe6d10a51ba7a52aa77a73e7145910ed6374328fc8
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0xcb26e36edf6262ed8e39d43954ad3889459f0a7a	false	32131651600000	290	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	21520172	0xcb26e36edf6262ed8e39d43954ad3889459f0a7a	2024-12-31T04:49:11.000Z	0x340d0d0d914d067dbac881e17d9d7f3c8e0d61c614b64c53204e2a5571c41752
0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x189cfdb4d7a08d926ca209d84a713c4c629645af	false	835992318	270	0xdac17f958d2ee523a2206206994597c13d831ec7	20542776	0xfb0a805e893a3a0125922078ef2ce4c265eeed23	2024-08-16T17:46:47.000Z	0x4ae1ebc650807540806cceaccdb43c42637173f9cf94b52472c661c16769d4c3

Example Query

Query with partition filter

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

LendingPoolEthLrt_Withdraw_event

Withdrawal events from ZeroLend V1’s Ethereum Liquid Restaking Token (LRT) lending pool, capturing user withdrawals with reserve asset addresses, amounts, and recipient details. Used for tracking lending pool liquidity outflows and user redemption behavior across various LRT assets.

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
0x3edd148ce72bdcba5984581d8f1b25894a8e8521	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x3edd148ce72bdcba5984581d8f1b25894a8e8521	false	19871739629757479	162	0xbf5495efe5db9ce00f80364c8b423567e58d2110	23191385	2025-08-21T18:56:11.000Z	0x03801e7521ea66439591b1bd851de900278453da8ef54aefaa1ea9b1c1300892
0x3edd148ce72bdcba5984581d8f1b25894a8e8521	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x3edd148ce72bdcba5984581d8f1b25894a8e8521	false	108913666038770221	116	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	23191382	2025-08-21T18:55:35.000Z	0xb9eec65b99d67b1d70dd02bee4a7cb7700ab06bb78f0a4cc0c33e0aa13f7d586
0x1582b06d8c4b6c5990e2ba951d88a88363dab891	0x3bc3d34c32cc98bf098d832364df8a222bbab4c0	0x1582b06d8c4b6c5990e2ba951d88a88363dab891	false	1815374448	366	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	19507721	2024-03-24T23:41:11.000Z	0xce0ecd6be752217224d36eaf3253d2a209edebdb06fdc2939864586efc5405ae

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_Borrow_event

Borrow transaction events from ZeroLend V1’s Real World Asset (RWA) stablecoin lending pool on Ethereum, capturing loan originations with borrowed amounts, interest rates, reserve tokens (USDC, USDT), and borrower addresses. Used for analyzing lending activity, interest rate dynamics, and debt positions in RWA-backed 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_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
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x0f6e98a756a40dd050dc78959f45559f98d3289d	false	1000000	137	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21330551	184702341043358722417043711	0x0f6e98a756a40dd050dc78959f45559f98d3289d	2024-12-04T17:13:11.000Z	0x9ddbe27c20b3ab882c806ea23550ad728ea94785a8a57efbb18491531798d62f	2
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x83f630217cd7c3eee1886fe8c6e5881fd0fd644f	false	1000000000	199	0xdac17f958d2ee523a2206206994597c13d831ec7	22293854	88314538961154898481387397	0x83f630217cd7c3eee1886fe8c6e5881fd0fd644f	2025-04-18T05:39:59.000Z	0xf85210537b2f6ce765df686f224417f1ab93d9389d6e254a27bdc4df79edae68	2
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0xbeaae572562131e92dae1b6800c5c20af440caca	false	10698574120369346548591	300	0x73a15fed60bf67631dc6cd7bc5b6e8da8190acf5	20977592	34836289489799180954133772	0xbeaae572562131e92dae1b6800c5c20af440caca	2024-10-16T10:41:47.000Z	0x94cb178cffc3ae9689d59f785b7401232f3f23a8142091a863ba304cfd4b28d1	2

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_FlashLoan_event

Flash loan events from ZeroLend v1’s Real-World Asset (RWA) stablecoin lending pool on Ethereum, recording uncollateralized loans with asset address, borrowed amount, initiator, target contract, premium fees, and interest rate mode. Used for analyzing flash loan arbitrage patterns and protocol liquidity 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_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	block_number	in_initiator	block_timestamp	transaction_hash	in_interestRateMode
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	0xdac17f958d2ee523a2206206994597c13d831ec7	1984764830	0x526079f6a4fc1877b876db5ecd02f00d894e4047	117	22085459	0x526079f6a4fc1877b876db5ecd02f00d894e4047	2025-03-20T03:42:23.000Z	0xa3d491eba4fb21a6584490a07593150ecef28417aac7ac40ee7cd05b5a277dc8	2
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	0xdc035d45d973e3ec169d2276ddab16f1e407384f	3957432086040000000000	0x4e18c3023e37b34cd8733d3729b9b498d3b947af	242	22162998	0x4e18c3023e37b34cd8733d3729b9b498d3b947af	2025-03-30T23:24:59.000Z	0x7950f351378b18032f59710c4135cfdd7326cafae54de6c8a233b3f876b64a6c	2
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	421900000000	0x1e69f06bac94a05b45257e36671b1dec67940c40	35	21593897	0x1e69f06bac94a05b45257e36671b1dec67940c40	2025-01-10T11:52:35.000Z	0x7986836d2142dfdeae88a4d38c1ea60b9d2bf3e0b83ed3ee3579b7acaf581b54	0

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_LiquidationCall_event

Liquidation event records from ZeroLend’s Real World Asset (RWA) stablecoin lending pool on Ethereum, capturing undercollateralized position closures with liquidator addresses, debt repayment amounts, and seized collateral values. Used for analyzing liquidation mechanics, keeper profitability, and protocol risk management in RWA-backed 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_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
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0xf0fead40e78f6888dfca953fad104c7383061480	false	16	22663399	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x13cf8829d2eaf6a70a33c6b9bb67b6c2f5d135be	16039674478	2025-06-09T00:18:47.000Z	false	0x4f7b34b7a62cbf065cf3eb8dbd7e0b7be16f4c8743370a1c643749e1aeb24134	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	16468675722861498606787
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0xf0fead40e78f6888dfca953fad104c7383061480	false	152	22948658	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x3c74497c25c6dfc306e7302751dd1bfa55f1e586	2593724116	2025-07-18T21:04:11.000Z	false	0xe34851450caa0e9547543c79625ef03f116456abc0a4e5117d11060210b1cdbb	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	2661762840342573693086
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x3a69f366393f9a451c5ebfecfb85ddbb1465a3e0	false	444	22182602	0x1ce7d9942ff78c328a4181b9f3826fee6d845a97	0xa090fc409a9f25bf8e28257d42ef6904590c8984	810892669356038179370	2025-04-02T17:04:35.000Z	false	0x22272fbc2b7dce654df5de9e15310f5f6b70fd7d4440747c2f38c7de8604e472	0x69000dfd5025e82f48eb28325a2b88a241182ced	898265678802834552278

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_MintedToTreasury_event

Events tracking Real World Asset (RWA) stablecoin issuance to the ZeroLend protocol treasury on Ethereum. Records minting amounts per reserve asset for analyzing protocol revenue and treasury growth from RWA-backed lending operations.

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
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	221	0x69000dfd5025e82f48eb28325a2b88a241182ced	21542620	2025-01-03T07:59:47.000Z	1419319340067608997	0xd6e9fc440c95cd82af6be0d74d91e5c166456f23c49e3c97fb03e2b64f459409
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	187	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21542620	2025-01-03T07:59:47.000Z	624421253	0xd6e9fc440c95cd82af6be0d74d91e5c166456f23c49e3c97fb03e2b64f459409
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	false	205	0x73a15fed60bf67631dc6cd7bc5b6e8da8190acf5	21542620	2025-01-03T07:59:47.000Z	329182888774554895612	0xd6e9fc440c95cd82af6be0d74d91e5c166456f23c49e3c97fb03e2b64f459409

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_Repay_event

Debt repayment events from ZeroLend V1’s RWA (Real World Asset) stablecoin lending pool on Ethereum, capturing loan repayments with borrower, repayer, reserve asset, and amount data. Used for analyzing repayment behavior, debt servicing patterns, and aToken usage in RWA-backed lending positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x1f1345248892697f730f211d7fb73759ed3a7628	false	10000000000000000000000	62	0x1f09ec21d7fd0a21879b919bf0f9c46e6b85ca8b	0x69000405f9dce69bd4cbf4f2865b79144a69bfe0	22961224	false	2025-07-20T15:13:11.000Z	0x5fe1e6b97e544b2eac10b08219cc6db3f9c93aa372fab3c43cd69723988b72e9
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x1f1345248892697f730f211d7fb73759ed3a7628	false	2614580000000000000000	138	0x1f09ec21d7fd0a21879b919bf0f9c46e6b85ca8b	0x69000405f9dce69bd4cbf4f2865b79144a69bfe0	22961228	false	2025-07-20T15:13:59.000Z	0x71445bff0f9daa38a9f2dffb5f046d99820228e5958adb744dc728f9ca1bce59
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x0f6e98a756a40dd050dc78959f45559f98d3289d	false	4299449079371	239	0x0f6e98a756a40dd050dc78959f45559f98d3289d	0x35d8949372d46b7a3d5a56006ae77b215fc69bc0	21520880	true	2024-12-31T07:11:23.000Z	0xbd27c6bf2bcd43d7ce919dc2e6a8b1ae6722b444cb15ad3f135f6a15a487e600

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_Supply_event

Stablecoin deposit events from ZeroLend V1’s real-world asset (RWA) lending pool on Ethereum, capturing user supply transactions with reserve token addresses and amounts. Used for tracking liquidity provision activity and analyzing deposit patterns for stablecoin reserves like USDT and USDC.

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
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x5403c0a05673f9c3aa6acfcb712d98140856cc04	false	1625747435	303	0xdac17f958d2ee523a2206206994597c13d831ec7	21422696	0x5403c0a05673f9c3aa6acfcb712d98140856cc04	2024-12-17T13:56:35.000Z	0x245741ac8c40126c8135fd6cae3a9da7267130704a6133850f55a6602f0a5156
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x5403c0a05673f9c3aa6acfcb712d98140856cc04	false	10856268087	311	0xdac17f958d2ee523a2206206994597c13d831ec7	21422696	0x5403c0a05673f9c3aa6acfcb712d98140856cc04	2024-12-17T13:56:35.000Z	0x245741ac8c40126c8135fd6cae3a9da7267130704a6133850f55a6602f0a5156
0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x4a4037e53306f284cf214b733e9a54d6a5939818	false	162122753182	234	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21612405	0x4a4037e53306f284cf214b733e9a54d6a5939818	2025-01-13T01:51:23.000Z	0xc3b0d20ba7341bdeeeedbe319f9a9d2d30f6b90048754232de01e062af4441ca

Example Query

Query with partition filter

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

LendingPoolRwaStablecoin_Withdraw_event

Withdrawal events from ZeroLend’s Real World Asset (RWA) stablecoin lending pool on Ethereum, capturing user withdrawals of deposited assets with amounts and recipient addresses. Used for tracking liquidity outflows and user redemption patterns across stablecoin reserves like USDC and USDT.

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
0xe22f4ca77d3278255d3c6fe2076a672857eab83f	0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0xe22f4ca77d3278255d3c6fe2076a672857eab83f	false	145899978	397	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	22479765	2025-05-14T06:55:59.000Z	0x033562b502afe657f1c9f52317c53ccd7c5ae8575728b0d716a26322200bb53b
0x5403c0a05673f9c3aa6acfcb712d98140856cc04	0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x5403c0a05673f9c3aa6acfcb712d98140856cc04	false	37835964	166	0xdac17f958d2ee523a2206206994597c13d831ec7	22479960	2025-05-14T07:35:35.000Z	0x021254f98a59a0c595b47ac191d0c45113776646ebd4e979379fe91d21c818de
0x5403c0a05673f9c3aa6acfcb712d98140856cc04	0xd3a4da66ec15a001466f324fa08037f3272bdbe8	0x5403c0a05673f9c3aa6acfcb712d98140856cc04	false	511351401	392	0xdac17f958d2ee523a2206206994597c13d831ec7	22480520	2025-05-14T09:28:35.000Z	0x8175eb89609614d30e67a33161ef39511f9c30c5d806a198776bde03c5a0fc02

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.LendingPoolRwaStablecoin_Withdraw_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
0x227f86fbfccb5664403b62a5b6d4e0e593968275	0x3689c216f8f6ce7e2ce2a27c81a23096a787f532	false	1001008399956175151594904359	85544078015	0x0000000000000000000000000000000000000000	162	19481724	2024-03-21T08:02:47.000Z	0x4dd8081a3d6ad5e21c5123cd9b2a5e2dc661ef810efd5f91d7f80dbae41c2969	57859841
0x227f86fbfccb5664403b62a5b6d4e0e593968275	0x3689c216f8f6ce7e2ce2a27c81a23096a787f532	false	1001008606608106795601577800	8893915627	0x0000000000000000000000000000000000000000	149	19481773	2024-03-21T08:12:35.000Z	0x952e20669744b24ca759c993a9b04b15e1027b915085178baabaf46a2a69c89b	1837
0x7ef98cd28902ce57b7aeec66dfb06b454cda1941	0x95ce459b20586cf44ee6d295c4f28e1a134cf529	false	1005518737894821028199053847	6988614657987911089	0x0000000000000000000000000000000000000000	41	19484315	2024-03-21T16:47:47.000Z	0xc95888d831de99f4d1ce96d0fa389987789d6d30426390bfc943f15dfa57c717	11385342012088911

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_ethereum.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
0x7ef98cd28902ce57b7aeec66dfb06b454cda1941	false	1000003440037772584484407864	6418617786300443073	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	347	19421270	0x0f6e98a756a40dd050dc78959f45559f98d3289d	2024-03-12T20:05:11.000Z	0x77d051089f38c6ef136aef609aedab099fecd84853126159252f91f04f4af8fe	28416790560350
0x7ef98cd28902ce57b7aeec66dfb06b454cda1941	false	1000009321532713855635300255	5608224961708233563	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	196	19421280	0x0f6e98a756a40dd050dc78959f45559f98d3289d	2024-03-12T20:07:11.000Z	0xf98543c826034a5cf74b8e77f149bd3c11aeaf56d591db45d14857647a3c1a03	86335473007356
0x7ef98cd28902ce57b7aeec66dfb06b454cda1941	false	1000000000000000000000000000	8260604225575419658	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	220	19421259	0x0f6e98a756a40dd050dc78959f45559f98d3289d	2024-03-12T20:02:59.000Z	0x2a50b5302993ce334d808b21472a75e0b1ef54a4cff2a8a815f8a60f6826cc31	0

Example Query

Query with partition filter

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

VTokenBtcLrt_Burn_event

Variable-rate token burn events for Bitcoin Liquid Restaking Token (BTC LRT) collateral in ZeroLend V1 on Ethereum. Tracks withdrawal redemptions with scaled balances and interest index values for analyzing lending position unwinding and yield-bearing token burns.

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
0xa2962376f68edb09b08f9b433f4ecae8d3217eec	0xfd8bf1e6246c28c1f383ffe55e473d14a6724332	false	1032574479780957434271489085	468335	0x0000000000000000000000000000000000000000	229	21918991	2025-02-24T21:53:35.000Z	0xedbfd2d15b0f22bfa95b5ac30865e75f16c93078403e59974c1c0c0a9f4dc617	1
0xa2962376f68edb09b08f9b433f4ecae8d3217eec	0xfd8bf1e6246c28c1f383ffe55e473d14a6724332	false	1032573982600764965600620429	622612	0x0000000000000000000000000000000000000000	253	21918952	2025-02-24T21:45:47.000Z	0x5ded19b66fe388cec4a6527f8bd12cbd7d51022d8376df736940aca1e4df729e	25865
0xa2962376f68edb09b08f9b433f4ecae8d3217eec	0xfd8bf1e6246c28c1f383ffe55e473d14a6724332	false	1032574237847739301381066601	698393	0x0000000000000000000000000000000000000000	351	21918972	2025-02-24T21:49:47.000Z	0x024eeba755b44cbddd6580079f122683e486c7875fd6d88c0c4f52b8daa48345	0

Example Query

Query with partition filter

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

VTokenBtcLrt_Mint_event

Mint events for ZeroLend V1 BTC LRT (Liquid Restaking Token) vTokens on Ethereum, recording when users deposit and receive interest-bearing tokens with the minted amount and accrued balance increase. Used for tracking supply changes and user positions in the BTC liquid restaking market.

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
0x57c0fbfefa18c6b438a4eb3c01354640017bf154	false	1006425546688350672840952625	500010373	0xae7f281a92834dbfa1e94f1fd23c5b0b3735615d	246	21125509	0xae7f281a92834dbfa1e94f1fd23c5b0b3735615d	2024-11-06T02:04:59.000Z	0xdef709edff7f20a46da783a1714f90bbab8d0e6738d36fb77e7d80ea8793503d	10373
0x028cf048867d37566b60cee7822c857441dac9e7	false	1007198523089673267448679192	2150395	0xcd415ffd988c5421cd25e2557154506045a42283	339	21128345	0xcd415ffd988c5421cd25e2557154506045a42283	2024-11-06T11:35:11.000Z	0x3090b1678937f1480b553e7a98f77adc8024acd0233dcd0795b1bcffa62b4e45	395
0x028cf048867d37566b60cee7822c857441dac9e7	false	1020024017410569720645631804	400006	0x065e3aa8724cf010f9ee222c480e9f729a5b5f6b	123	21491133	0x065e3aa8724cf010f9ee222c480e9f729a5b5f6b	2024-12-27T03:32:11.000Z	0xd18897f0b312815d79c857c98e1f4931f32bf68c7b86f058c642338e073aaaa0	6

Example Query

Query with partition filter

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

VTokenEthLrt_Burn_event

Token burn events from ZeroLend V1’s Ethereum LRT (Liquid Restaking Token) vToken contract, recording when users redeem their vTokens for underlying assets. Contains burn amounts, balance increases from accrued interest, and user addresses for tracking LRT redemptions and yield realization.

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
0x0047cac82cf5fb36954de1b9d86d657915ab3b47	0xb0ad83f09a4ca40a1a54d4a938f7a82ceacecc84	false	1032196470133093585771016515	899997589610344824661	0x0000000000000000000000000000000000000000	203	19730951	2024-04-25T07:40:23.000Z	0x75b69a9f722779047556425a1f6f0d1a10e1e6b061da94befb4bb7d8293b2edb	2410389655175339
0x227f86fbfccb5664403b62a5b6d4e0e593968275	0x902896cf27e60c12b803f11966c280b84502fdc6	false	1021192958049046217670698453	2000000	0x0000000000000000000000000000000000000000	557	19732456	2024-04-25T12:43:23.000Z	0xc8be841af9883792a379f364715177c5c22d8fcb47129eed0014974eb180ecf8	0
0x227f86fbfccb5664403b62a5b6d4e0e593968275	0x170b6ee0387762acb551310e817febe5f98157bd	false	1021087895437466744108700737	7500000000	0x0000000000000000000000000000000000000000	161	19729828	2024-04-25T03:54:11.000Z	0x0caba107b09e87450cdefaca451d2883492b79ab39da2935007d1c32832f03c2	149348548

Example Query

Query with partition filter

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

VTokenEthLrt_Mint_event

Mint events for ZeroLend V1 vToken (interest-bearing token) positions on Ethereum, tracking deposits of ETH liquid restaking tokens (LRT) with minted amounts, accrued interest, and beneficiary accounts. Used for analyzing lending protocol supply activity and yield accumulation patterns.

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
0x7ef98cd28902ce57b7aeec66dfb06b454cda1941	false	1039875565927564740477211544	3350000000000000000	0x6ea9d99c6653df987bdea11ffcd56dfb4b5d38b4	81	20341385	0xa41c88c77c339e46416609da258b345c999eeaf2	2024-07-19T15:10:11.000Z	0x3363299746ef755c6e5fddbcc608557157ea6bd93d98b1fc29da24f45260fa10	0
0x227f86fbfccb5664403b62a5b6d4e0e593968275	false	1047451746139659123017446712	1200232592	0x3457c815a155516c7160241071659d378fd76931	716	20340848	0x3457c815a155516c7160241071659d378fd76931	2024-07-19T13:22:23.000Z	0x04c9d12d8614211f3c287480cb63c5f83fa6e34e9a6e6dc69781b210890b1ee2	232592
0x227f86fbfccb5664403b62a5b6d4e0e593968275	false	1047496894941377822773190342	2501600393	0x887adcdf6def59c203f4d5236c5974f6a556d548	210	20343675	0x887adcdf6def59c203f4d5236c5974f6a556d548	2024-07-19T22:50:23.000Z	0x5f140a1d334fd300a6c808df48e8f32b150f8bfd48cb9a845a9f0e3b886530e7	1600393

Example Query

Query with partition filter

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

VTokenRwaStablecoin_Burn_event

Token burn events from ZeroLend’s Real-World Asset (RWA) stablecoin vToken contracts on Ethereum. Records when users redeem interest-bearing tokens, capturing burned amounts, accrued interest (balanceIncrease), and the source address for analyzing withdrawal patterns 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_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
0xda6991cf0eb96d29d42682bd201b678944bf9d6b	0x50f02612ea1f79a84ef72d6912a5452f40a88edd	false	1085790340292601630698554482	116843906667	0x0000000000000000000000000000000000000000	110	22305901	2025-04-19T22:01:35.000Z	0x606f259baca5ffd7fe0dee6b8f558a1785a73a73cad9e6b74530161af062868e	2139751663
0xbf9126198ee2ddf2c59b0b2db35844e600557edb	0x6fec1427c201917a80835a1aa0b587f6cac81a09	false	1069362586501162077361798115	49937255192923042305779	0x0000000000000000000000000000000000000000	194	22305833	2025-04-19T21:47:59.000Z	0x967734cd25a801f3bfd1361100df85b803a7db1347e14bfad00f69df7526f39c	3463754807076957694221
0xe7a632694dc4ac65583248aaf92fb5becb54011e	0x791f7179dd23ac94154c0d17ccccb0e2a2625174	false	1079919301526314516464331091	1999999907	0x0000000000000000000000000000000000000000	160	22306110	2025-04-19T22:43:23.000Z	0xc51e293c4b7565e0c328e1f96341ac82b41823b86bda5cac46b493dac29ab8b7	4701165

Example Query

Query with partition filter

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

VTokenRwaStablecoin_Mint_event

Mint events for ZeroLend V1’s Real World Asset (RWA) stablecoin vToken on Ethereum, recording deposits with balance increases, interest index values, and beneficiary addresses. Used for tracking yield-bearing token issuance and analyzing lending protocol 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_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
0xe7a632694dc4ac65583248aaf92fb5becb54011e	false	1067747321035585388819797273	7418523739	0xc6e71d3dcfaefa9c3cfeb860c9b5ed35d01c0a73	230	22034473	0xc6e71d3dcfaefa9c3cfeb860c9b5ed35d01c0a73	2025-03-13T00:49:47.000Z	0x1327cf49c243b35452a65364276e997e6871529c83fd0632cd0a26db5401944b	0
0xda6991cf0eb96d29d42682bd201b678944bf9d6b	false	1011681822845329086121171645	7907304342	0x142905f9009c34977f49b52aeccaaea273865538	443	21363984	0x142905f9009c34977f49b52aeccaaea273865538	2024-12-09T09:15:23.000Z	0x4c090c9f195f960fe8d83fe247b9c8be14b32e037274a003cbb454d5bc3656d1	80309
0xda6991cf0eb96d29d42682bd201b678944bf9d6b	false	1011673570173105810866225934	9844866586	0x142905f9009c34977f49b52aeccaaea273865538	271	21363860	0x142905f9009c34977f49b52aeccaaea273865538	2024-12-09T08:50:35.000Z	0x0588ac42014368526227800671c520c1205a95cc3c7d3354ceff0ffd84e073e0	0

Example Query

Query with partition filter

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

zerolend_v1_blast zerolend_v1_linea

⌘I

​Tables

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​ATokenBtcLrt_Burn_event

​ATokenBtcLrt_Initialized_event

​ATokenBtcLrt_Mint_event

​ATokenEthLrt_Burn_event

​ATokenEthLrt_Initialized_event

​ATokenEthLrt_Mint_event

​ATokenRwaStablecoin_Burn_event

​ATokenRwaStablecoin_Initialized_event

​ATokenRwaStablecoin_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_Repay_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolBtcLrt_Borrow_event

​LendingPoolBtcLrt_FlashLoan_event

​LendingPoolBtcLrt_LiquidationCall_event

​LendingPoolBtcLrt_MintedToTreasury_event

​LendingPoolBtcLrt_Repay_event

​LendingPoolBtcLrt_Supply_event

​LendingPoolBtcLrt_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​LendingPoolConfiguratorBtcLrt_CollateralConfigurationChanged_event

​LendingPoolConfiguratorBtcLrt_LiquidationProtocolFeeChanged_event

​LendingPoolConfiguratorBtcLrt_ReserveFactorChanged_event

​LendingPoolConfiguratorBtcLrt_ReserveInitialized_event

​LendingPoolConfiguratorEthLrt_CollateralConfigurationChanged_event

​LendingPoolConfiguratorEthLrt_LiquidationProtocolFeeChanged_event

​LendingPoolConfiguratorEthLrt_ReserveFactorChanged_event

​LendingPoolConfiguratorEthLrt_ReserveInitialized_event

​LendingPoolConfiguratorRwaStablecoin_CollateralConfigurationChanged_event

​LendingPoolConfiguratorRwaStablecoin_LiquidationProtocolFeeChanged_event

​LendingPoolConfiguratorRwaStablecoin_ReserveFactorChanged_event

​LendingPoolConfiguratorRwaStablecoin_ReserveInitialized_event

​LendingPoolEthLrt_Borrow_event

​LendingPoolEthLrt_FlashLoan_event

​LendingPoolEthLrt_LiquidationCall_event

​LendingPoolEthLrt_MintedToTreasury_event

​LendingPoolEthLrt_Repay_event

​LendingPoolEthLrt_Supply_event

​LendingPoolEthLrt_Withdraw_event

​LendingPoolRwaStablecoin_Borrow_event

​LendingPoolRwaStablecoin_FlashLoan_event

​LendingPoolRwaStablecoin_LiquidationCall_event

​LendingPoolRwaStablecoin_MintedToTreasury_event

​LendingPoolRwaStablecoin_Repay_event

​LendingPoolRwaStablecoin_Supply_event

​LendingPoolRwaStablecoin_Withdraw_event

​VToken_Burn_event

​VToken_Mint_event

​VTokenBtcLrt_Burn_event

​VTokenBtcLrt_Mint_event

​VTokenEthLrt_Burn_event

​VTokenEthLrt_Mint_event

​VTokenRwaStablecoin_Burn_event

​VTokenRwaStablecoin_Mint_event

Tables

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

ATokenBtcLrt_Burn_event

ATokenBtcLrt_Initialized_event

ATokenBtcLrt_Mint_event

ATokenEthLrt_Burn_event

ATokenEthLrt_Initialized_event

ATokenEthLrt_Mint_event

ATokenRwaStablecoin_Burn_event

ATokenRwaStablecoin_Initialized_event

ATokenRwaStablecoin_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_Repay_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolBtcLrt_Borrow_event

LendingPoolBtcLrt_FlashLoan_event

LendingPoolBtcLrt_LiquidationCall_event

LendingPoolBtcLrt_MintedToTreasury_event

LendingPoolBtcLrt_Repay_event

LendingPoolBtcLrt_Supply_event

LendingPoolBtcLrt_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

LendingPoolConfiguratorBtcLrt_CollateralConfigurationChanged_event

LendingPoolConfiguratorBtcLrt_LiquidationProtocolFeeChanged_event

LendingPoolConfiguratorBtcLrt_ReserveFactorChanged_event

LendingPoolConfiguratorBtcLrt_ReserveInitialized_event

LendingPoolConfiguratorEthLrt_CollateralConfigurationChanged_event

LendingPoolConfiguratorEthLrt_LiquidationProtocolFeeChanged_event

LendingPoolConfiguratorEthLrt_ReserveFactorChanged_event

LendingPoolConfiguratorEthLrt_ReserveInitialized_event

LendingPoolConfiguratorRwaStablecoin_CollateralConfigurationChanged_event

LendingPoolConfiguratorRwaStablecoin_LiquidationProtocolFeeChanged_event

LendingPoolConfiguratorRwaStablecoin_ReserveFactorChanged_event

LendingPoolConfiguratorRwaStablecoin_ReserveInitialized_event

LendingPoolEthLrt_Borrow_event

LendingPoolEthLrt_FlashLoan_event

LendingPoolEthLrt_LiquidationCall_event

LendingPoolEthLrt_MintedToTreasury_event

LendingPoolEthLrt_Repay_event

LendingPoolEthLrt_Supply_event

LendingPoolEthLrt_Withdraw_event

LendingPoolRwaStablecoin_Borrow_event

LendingPoolRwaStablecoin_FlashLoan_event

LendingPoolRwaStablecoin_LiquidationCall_event

LendingPoolRwaStablecoin_MintedToTreasury_event

LendingPoolRwaStablecoin_Repay_event

LendingPoolRwaStablecoin_Supply_event

LendingPoolRwaStablecoin_Withdraw_event

VToken_Burn_event

VToken_Mint_event

VTokenBtcLrt_Burn_event

VTokenBtcLrt_Mint_event

VTokenEthLrt_Burn_event

VTokenEthLrt_Mint_event

VTokenRwaStablecoin_Burn_event

VTokenRwaStablecoin_Mint_event