zerolend_v1_zksyncera

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
0x016341e6da8da66b33fd32189328c102f32da7cc	0x2d9a0e25e696082813cb11431dc774c998ada0a3	false	1034966524635424939299988478	988895760	0x2d9a0e25e696082813cb11431dc774c998ada0a3	4	47303072	2024-10-24T15:28:49.000Z	0x8209f012f7c21982834e2fa8d3d4e3dba931ca55cb9fc613e341905c9276573c	11104240
0x016341e6da8da66b33fd32189328c102f32da7cc	0x7f248e4301f5a16b2a8289989584a509f7157845	false	1034929179310061580971671723	507607188	0x7f248e4301f5a16b2a8289989584a509f7157845	5	47273024	2024-10-24T06:27:14.000Z	0xea041a19e6c34877bfb8b64c778d34a6db4fd6970564d0247c37d599e60ad972	14079696
0x016341e6da8da66b33fd32189328c102f32da7cc	0x114b242d931b47d5cdcee7af065856f70ee278c4	false	1034998885861674166443849262	1000000	0x114b242d931b47d5cdcee7af065856f70ee278c4	5	47326664	2024-10-24T23:25:17.000Z	0x3b311529345afe4856d9870021fb9ee2e9b7468b61345e62a0edc7ffe50c6276	13696

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x52846a8d972abbf49f67d83d5509aa4129257f46	0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	0x	5	0xe52540dbd350c611a1b9c51e97e2a6bc16c09133	10810998	ZeroLend ONEZ	2023-08-09T18:05:35.000Z	zONEZ	0x837a71b590d8a9f974ee1bb4e30601834d04edd032d187dd8764e192ede6aae2	18	0x90059c32eeeb1a2aa1351a58860d98855f3655ad	0x54ab34ab3c723bd2674c7082aa6ffcdfd3a5bedc
0x016341e6da8da66b33fd32189328c102f32da7cc	0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	0x10	59	0xe52540dbd350c611a1b9c51e97e2a6bc16c09133	8776918	ZeroLend zK USDC	2023-07-16T21:21:50.000Z	z0USDC	0x3c89d1ceb7dfa1d329eff493f420eeeab9e399ec4bfaa21206dbcaf0542ee215	6	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	0x54ab34ab3c723bd2674c7082aa6ffcdfd3a5bedc
0x9ca4806fa54984bf5da4e280b7aa8bb821d21505	0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	0x10	73	0xe52540dbd350c611a1b9c51e97e2a6bc16c09133	8776918	ZeroLend zK USDT	2023-07-16T21:21:50.000Z	z0USDT	0x3c89d1ceb7dfa1d329eff493f420eeeab9e399ec4bfaa21206dbcaf0542ee215	6	0x493257fd37edb34451f62edf8d2a0c418852ba4c	0x54ab34ab3c723bd2674c7082aa6ffcdfd3a5bedc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x072416442a0e40135e75c0eefb4be708b74b6c8a	false	1002677515828293999391150169	10664	0xf3a78888de4da96a80ecb9f775fff22cc883bc86	6	63554893	0xf3a78888de4da96a80ecb9f775fff22cc883bc86	2025-07-31T00:01:48.000Z	0xbbbae66b8ee40270853be7c7c190b03563e409e0c885ba029bfea98ca066a5e0
0x072416442a0e40135e75c0eefb4be708b74b6c8a	false	1002677516003503456708362755	12250904847527795782	0xea3ebd0cc853dda25c65c13ca2ac1a8eb6b38f09	5	63555080	0xea3ebd0cc853dda25c65c13ca2ac1a8eb6b38f09	2025-07-31T00:09:38.000Z	0x49a342768dd7b4bda0ea997aaa09b984175426aa87ce5675645676a0c75524a3
0x072416442a0e40135e75c0eefb4be708b74b6c8a	false	1002677516520184773385232662	300000000000000000	0xcad7f7445294364f14786d94ead6077a686888f0	9	63555678	0xcad7f7445294364f14786d94ead6077a686888f0	2025-07-31T00:32:44.000Z	0x78fbdf983586ca21fa98f283766e91abdd9cfe2cda24cd3b587a03f410b76542

Example Query

Query with partition filter

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

LendingPool_Borrow_event

Borrow events emitted by Aave lending pool contracts capturing loan originations with borrower address, reserve asset, loan amount, interest rate, and rate mode (stable or variable). Used for tracking DeFi lending activity and calculating protocol borrowing metrics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_borrowRate`	`STRING`	Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x2d08c45f79d07ee74cbacc2a40223ce732137603	false	2780700000000000000000	77	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	17008749	37135159127945942452781666	0x2d08c45f79d07ee74cbacc2a40223ce732137603	2023-10-22T07:14:51.000Z	0x8122f26816e6963c7aff73451b7ed26e088c0b65c45018e42841a1e4a004cab8	2
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x035c37ad919de748a9b280bf306046cf6e91d7e4	false	1236000000000000000000	49	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	17006203	38268785268587946950769570	0x035c37ad919de748a9b280bf306046cf6e91d7e4	2023-10-22T06:30:08.000Z	0x07a1463592bd63c56c2798835585fb5a60b13d8b783ff17a5555012ebd384f9c	2
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0xb47efb17e1864a9b1d81ecc41ba33d0fc6f37f84	false	1000000000000000000	117	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	16992834	39524091216882702608990154	0xb47efb17e1864a9b1d81ecc41ba33d0fc6f37f84	2023-10-22T02:36:47.000Z	0x08dd20c4fd282de150ad3c95ac2fc0ccc036bb2b35f478dab7d9124158f7322d	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	323960133	0x289aeb8f28406df87bb026c480a97ebfb981075d	103	161980	13904080	0x289aeb8f28406df87bb026c480a97ebfb981075d	2023-09-15T08:38:43.000Z	0x418131c474fb98d220eef624fce0fb4c506b87274723123c301511b859e42026
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	67615561	0x289aeb8f28406df87bb026c480a97ebfb981075d	21	33808	14760070	0x289aeb8f28406df87bb026c480a97ebfb981075d	2023-09-25T12:10:18.000Z	0x18362b1c53ea31cd29d859deaf5756cbe71e427817ef6d84d7ef026701ef8273
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	69396607	0x289aeb8f28406df87bb026c480a97ebfb981075d	42	34698	14760083	0x289aeb8f28406df87bb026c480a97ebfb981075d	2023-09-25T12:10:31.000Z	0x51ba1d8726ad04315f5c431dcff8e3258c3c5d6c3d0f8c4c11380c906799317e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x8b8af5909862e855a98609ea958e39b9792b6a1b	false	16	47350213	0xbbeb516fb02a01611cbbe0453fe3c580d7281011	0x1dacb1dfa11a6ef944ae0f32fd772f5da9a3c8f0	25592	2024-10-25T07:28:57.000Z	false	0x645a6cbea47fa9c13d30b4ce6d655c327d265ccd3b622f22caef87d60d71d867	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	7345630920473130
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0xac14bb729190a40dfe34f59798f8a5b51f516a7c	false	14	47341074	0xbbeb516fb02a01611cbbe0453fe3c580d7281011	0x1dacb1dfa11a6ef944ae0f32fd772f5da9a3c8f0	15153	2024-10-25T04:32:02.000Z	false	0x7c9d6371f76f785b82be9e29874dabd6fbc9a38774a38f9a7aee14ca24431778	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	4330891351376668
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0xa76b46a72ecaedecb0e47bda914943be4586705b	false	23	47402301	0xbbeb516fb02a01611cbbe0453fe3c580d7281011	0x1dacb1dfa11a6ef944ae0f32fd772f5da9a3c8f0	15241	2024-10-25T23:29:53.000Z	false	0xa6615d3323ab209057fff9f89631480aaec84d1dc3a07916eb34e0fb5e6667b9	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	4409093236631539

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	19	0x503234f203fc7eb888eec8513210612a43cf6115	43286242	2024-09-03T08:12:25.000Z	22659347707456792107	0x7f51e9838238b5d354d68d377a824fda2082d3770bdf082cc0e0f00d550b376a
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	13	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	43286242	2024-09-03T08:12:25.000Z	4740835453770514	0x7f51e9838238b5d354d68d377a824fda2082d3770bdf082cc0e0f00d550b376a
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	false	22	0xbbeb516fb02a01611cbbe0453fe3c580d7281011	43286242	2024-09-03T08:12:25.000Z	7704	0x7f51e9838238b5d354d68d377a824fda2082d3770bdf082cc0e0f00d550b376a

Example Query

Query with partition filter

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

LendingPool_Repay_event

Loan repayment events from Aave-based lending protocols containing borrower address, repayer address, reserve asset, and repayment amount. Used for tracking debt reduction and loan lifecycle analysis across DeFi lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayer`	`STRING`	Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_useATokens`	`BOOL`	Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x887ce1549c2b49f1802481f3dc5c25692b8eca8e	false	8001039565233084613088	26	0x887ce1549c2b49f1802481f3dc5c25692b8eca8e	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	11497060	true	2023-08-17T20:51:06.000Z	0xf6961c02012f63031ba8800f0dc8871a9689046241f6f1d23b7863293159a9a5
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x887ce1549c2b49f1802481f3dc5c25692b8eca8e	false	616073998885218596	30	0x887ce1549c2b49f1802481f3dc5c25692b8eca8e	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	11497172	false	2023-08-17T20:53:01.000Z	0x5b2bb5145159e896b27cdb2d8e3e845af2de9124e7a2b313d8b48de8f976959f
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0xd2bed9ff3717572769fcf0fb42319ee764031007	false	1200226044713190356550	9	0xd2bed9ff3717572769fcf0fb42319ee764031007	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	11497296	true	2023-08-17T20:55:08.000Z	0x2a77bac33f9fb604e1ad85a680d31f7729349f17cc24783f2e634b38f42f850c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x1f87868b208842ec7441838180bdd32f4d581cbc	false	62108096504184937899	9	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	14352549	0x1f87868b208842ec7441838180bdd32f4d581cbc	2023-09-20T15:52:21.000Z	0x53cb3c7c183a5ec5375dc165e2c26fbf2a18aee3c814f2066005faab80a4e627
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x6179edfc5b54259e6b1f2e8850568ecba5154b2c	false	3360207326909411	10	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	14312766	0x6179edfc5b54259e6b1f2e8850568ecba5154b2c	2023-09-20T04:26:35.000Z	0x2a52d7c7cac4ceb0ce5c50e41361933af83612cf822881fec5a6cb118e9572a7
0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x055f1f64a9975311d629d5cd60a5e1eacab1e8fd	false	255000000000000000000	10	0x2039bb4116b4efc145ec4f0e2ea75012d6c0f181	14379582	0x055f1f64a9975311d629d5cd60a5e1eacab1e8fd	2023-09-20T23:28:07.000Z	0x372258efa9ea9a3319bfebd0cd4b7489a953700f151db2bb1409db787a7a92c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x086d392d8c499dc2eec12681507e38700dbb2e74	0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x086d392d8c499dc2eec12681507e38700dbb2e74	false	1143696000	154	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	16522539	2023-10-16T11:15:50.000Z	0xc1f81db93a5ee1f6c909c99857167e0375f71c1de242240fe03b3c3675e6fe3b
0x0f7eb8a1a7093fc1a5fa25f9145a7b6beaef3d77	0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x0f7eb8a1a7093fc1a5fa25f9145a7b6beaef3d77	false	5000000180	370	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	16498947	2023-10-16T04:26:20.000Z	0x9359eaec5ec4bad0d102206a25fd280d30ebf687554dda0e543c30503097440f
0x143115c8554e9b97fd09327d6c426ce29fb6be27	0x4d9429246ea989c9cee203b43f6d1c7d83e3b8f8	0x143115c8554e9b97fd09327d6c426ce29fb6be27	false	4170642463	216	0x493257fd37edb34451f62edf8d2a0c418852ba4c	16511077	2023-10-16T07:56:37.000Z	0xfcba709ac95dd1d64358ecbb106cb940a7b60e3cf02be2c1c7171dc50b79152f

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_ltv`	`STRING`	Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationThreshold`	`STRING`	Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationBonus`	`STRING`	Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
0	0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0xe757355edba7ced7b8c0271bba4efda184ad75ab	2	53760905	2025-01-15T20:18:20.000Z	0xce4ed8a0f4bc56243b6fd9c4fc5e4fa208f107ed9f6ad7ac2ef8834f0f029805	10500	8500
5000	0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x0469d9d1de0ee58fa1153ef00836b9bbcb84c0b6	2	56033365	2025-02-16T08:51:14.000Z	0xdc32d4c082c6cce4335c28b240a151e6147ffb7eeeb8c0ffa320f62239367ae3	11000	6000
8000	0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x703b52f2b28febcb60e1372858af5b18849fe867	2	56033680	2025-02-16T08:58:26.000Z	0x80788a37c3ba17a491b710e275e4b35ec4f3758c5a7c4ae4ced8e51d7ea59151	10500	8200

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFee`	`STRING`	Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0xe757355edba7ced7b8c0271bba4efda184ad75ab	3000	42	49906132	2024-11-27T05:52:15.000Z	0xceb504b97355b0d0a72f2588307caa913fe0b5d2989a24809541fbd483ae4b3e
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	3000	66	49906132	2024-11-27T05:52:15.000Z	0xceb504b97355b0d0a72f2588307caa913fe0b5d2989a24809541fbd483ae4b3e
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x5a7d6b2f92c77fad6ccabd7ee0624e64907eaf3e	3000	18	49906132	2024-11-27T05:52:15.000Z	0xceb504b97355b0d0a72f2588307caa913fe0b5d2989a24809541fbd483ae4b3e

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldReserveFactor`	`STRING`	Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
`in_newReserveFactor`	`STRING`	Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	14	8776927	2023-07-16T21:22:00.000Z	0x6545ec66fa26d677715119927e0bca5fa1434056370e7e0a8542629799ad14dc	1000
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x493257fd37edb34451f62edf8d2a0c418852ba4c	21	8776927	2023-07-16T21:22:00.000Z	0x6545ec66fa26d677715119927e0bca5fa1434056370e7e0a8542629799ad14dc	1000
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x3355df6d4c9c3035724fd0e3914de96a5a83aaf4	7	8776927	2023-07-16T21:22:00.000Z	0x6545ec66fa26d677715119927e0bca5fa1434056370e7e0a8542629799ad14dc	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0x0469d9d1de0ee58fa1153ef00836b9bbcb84c0b6	0xe2b026b30dea792e56201308bd566c1e1f43fb2c	58	55391076	2025-02-06T10:42:36.000Z	0xd860d2c03eedf5c900c1bf77d64c7b6fed48cd3c2935417dc61c01a115e8d449	0x01c8c65d352b7c0e7d3a3f45f21b4cb66f41d8db	0xd3cee59667ac8ee5a1e2fbff75e3f3195811885b	0xcaa502e289bfb924732f44f5e70bd08fc052aab8
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0xc1fa6e2e8667d9be0ca938a54c7e0285e9df924a	0x05ef103f8ea305f71f037af636bcf68f8ae047c5	34	55391076	2025-02-06T10:42:36.000Z	0xd860d2c03eedf5c900c1bf77d64c7b6fed48cd3c2935417dc61c01a115e8d449	0x4376bef9f6f3342f8b94a1cd520c13f4704e417c	0x06f7b47194b9956d0eac62adf0827752a29c08f5	0xcaa502e289bfb924732f44f5e70bd08fc052aab8
0x9c3058f7bfca6139ac3013999f57d7aa6a3ab1ed	false	0xa900cbe7739c96d2b153a273953620a701d5442b	0x76d2f67698b7bd6ec78262e4170de089b9bb7549	10	55391076	2025-02-06T10:42:36.000Z	0xd860d2c03eedf5c900c1bf77d64c7b6fed48cd3c2935417dc61c01a115e8d449	0xde4ea959ffa449e516287e77da69d10447c6e02d	0x27024aec8e3b9e1b2b255b982e4f2b1fecfbb2a3	0xcaa502e289bfb924732f44f5e70bd08fc052aab8

Example Query

Query with partition filter

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

SToken_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0x029214a5cd528433b8a4eccd7ef798210db3518c	0x1b2b4f32f8a80464ceac78eae9e76d64b79ae155	false	99979983858753903255	36	16447375	2023-10-15T13:49:13.000Z	54794910743190240981182469	0xea87c521a8db0a212f3dcd8bc304f959c4388ff15d6ebe508a870bcb20f5c712	100040360137677588777	10294796550324472008	40360137677588777
0x029214a5cd528433b8a4eccd7ef798210db3518c	0x6be50ce76b37838a05180bda56380f3e9334fe2a	false	49000000000000000000	3	16444012	2023-10-15T12:50:41.000Z	54707567324711413601766964	0x54bc27d71f53dfe1bf4d4fb459813994f58051a24176376e1076ce1017c9e4eb	49000001972343765370	110314468454172373877	1972343765370
0x6f977fd05962d67eb7b16b15684fbea0462f442d	0xfe4109d5943fdf10976381b2090512ecb465c62a	false	70999980	110	16433500	2023-10-15T09:45:44.000Z	54068678229786691915855018	0x3f2ba66f629e5676c5fd5acde30c1729ab56d02f442a19165df6dd4c1987f72e	71000020	589687074	20

Example Query

Query with partition filter

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

SToken_Mint_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_newRate	block_number	in_onBehalfOf	block_timestamp	in_avgStableRate	transaction_hash	in_newTotalSupply
0x6f977fd05962d67eb7b16b15684fbea0462f442d	0x4f198a6ebafb80a57a422f62c380b207a6807d4c	false	380000000	77	54356846275718347368421053	13151778	0x4f198a6ebafb80a57a422f62c380b207a6807d4c	2023-09-06T11:05:06.000Z	54108343069104922531541996	0xe248ae1e8020ea290c41b31be73cbede02b774f26c6491ad74757725234a0235	804809165
0x5fac4fd2e4bce392d34600d94aa1114274e54dff	0x92e2337ee09a89ce300a3693c758f5634916b249	false	5575679166	61	52411860855069219023998627	13120768	0x92e2337ee09a89ce300a3693c758f5634916b249	2023-09-06T02:11:07.000Z	52574582074567399917712227	0xb4ce3d90a9576c8fc74fa5b4036b1ca39fb4d9cfb85b8e3a230e79026a14a942	6560872654
0x5fac4fd2e4bce392d34600d94aa1114274e54dff	0xcd2d1e4a93c5238c1d6f03282786bb432046936d	false	6051713881	87	52479112060937395959483564	13146928	0xcd2d1e4a93c5238c1d6f03282786bb432046936d	2023-09-06T09:40:51.000Z	52621415608774907425344176	0xbf91bcf37a99f7a659b84c3333989c755775ca19f4d5a921fa0d5bbe797d9670	7036952438

Example Query

Query with partition filter

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

VToken_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x0325f21eb0a16802e2bacd931964434929985548	0xd67e3f59f06bdfdfc2161f19962764f011d715ce	false	1169712245832249240276571550	129257768193487691751	0x0000000000000000000000000000000000000000	8	40234065	2024-07-28T08:28:45.000Z	0x95a1dc2bea4dfd0dbb7ab5c9fc3d15ce769d16abafbe71ff9dd88862f5687caf	91911441149792
0x0325f21eb0a16802e2bacd931964434929985548	0xd67e3f59f06bdfdfc2161f19962764f011d715ce	false	1169711414084468813408073648	73979492097282514228	0x0000000000000000000000000000000000000000	9	40234007	2024-07-28T08:27:47.000Z	0xcebdbe8291536c5639ee42bc044fff4ebe1755773169655b8a56f97fbadb4318	22753150517342059556
0x56f58d9be10929cda709c4134ef7343d73b080cf	0x026a62826fc8b767681a43073351ef1a1e18cb05	false	1046930268324928646476466343	400000016384560747	0x0000000000000000000000000000000000000000	3	40271126	2024-07-28T19:05:45.000Z	0xa702da47de504a0c501659099f5d2601c7092221359cf2b8a33505aa5a2fe9b1	77896625895

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_zksyncera.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
0x0325f21eb0a16802e2bacd931964434929985548	false	1000603154906758648619830994	22021103017969540030	0xf09e1537f3e12ce66f46e6f0c6587e2f98f2ba07	3	19406494	0xf09e1537f3e12ce66f46e6f0c6587e2f98f2ba07	2023-11-19T20:00:16.000Z	0x9ac4e0cedee8acaa651edbd82339c53dcf00a41212f9140768e9c67ab169adf9	21103017969540030
0x0325f21eb0a16802e2bacd931964434929985548	false	1000603382356484102316493124	30027142409591435650	0xbf1a3f1ab33c95b1e15643d25dc43c61d8a710b2	21	19406882	0xbf1a3f1ab33c95b1e15643d25dc43c61d8a710b2	2023-11-19T20:06:49.000Z	0xa8ba94782e3745eae59bcd2c68d0e6d831ec17c27b5b502cb2ee18c4e8896bc1	27142409591435650
0x0325f21eb0a16802e2bacd931964434929985548	false	1000569382471265020216118876	500000000000000000000	0x4a8a22a03eec5c9c26a8ad765c09a007ded27ea5	50	19349424	0x4a8a22a03eec5c9c26a8ad765c09a007ded27ea5	2023-11-19T03:46:59.000Z	0xc979b5ddd5c496acda7b8045110b9f4da6f0affde3cb56de53f7b1885e9ef940	0

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

Tables

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event