aave_v3_zksyncera

Tables

AToken_BalanceTransfer_event

Interest-bearing aToken balance transfer events from Aave V3 lending protocol. Records movements between accounts with normalized interest index for calculating accrued yields on deposited collateral.

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_to`	`STRING`	Destination address receiving tokens or assets in 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_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

in_to	address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	0x651c636fc2adbb79fb2c8fbb1cf3a6f76ff1fdd9	false	1000790337076283906496373095	199959318308582103	17	47638296	2024-10-29T02:34:17.000Z	0x224c5068f5c92ea190616936e44bd7c6e3ec89cd262bd96ca72790691b1f3ac2
0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	0x9fe1381bbf84af2bd3d1c1ee48eed57e475f3f30	false	1000807719266516171397328787	299757879785207450	14	47702890	2024-10-29T22:23:31.000Z	0x7c2ac6de2e310ad247d656885de27b5199228644967508821f9993392e52dd40
0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	0x0008c89cf3e964103bb2ce837731be1ebe847d03	false	1000808576274269735166763535	75899998080636341	20	47705841	2024-10-29T23:22:36.000Z	0x9f0db6877f2d224f13782fb77356bb75ec5ebf73f80b06892ebc85b5ea82112c

Example Query

Query with partition filter

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

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
0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	false	1001760906684392067742830920	21317630000000000	0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	11	52445294	2024-12-29T16:12:15.000Z	0x9bcb614587bca9fba31671fedbfc0a5ebc0481524e66faf6e82cb79815a625a1
0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	false	1001749579271851453215831415	510000000000000000	0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	11	52402526	2024-12-29T02:01:55.000Z	0xfab6e838ba1d6ef8c24d59c9af4ddfc5689b322fb9b2198d7c0432020e363fd8
0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	false	1001767450864242349062353908	44044458692878140	0xd5f6c8d402e0a0222f7fa132f9e80fdcc074df5c	12	52466937	2024-12-29T23:33:43.000Z	0x6249e5b84e60a3fbf371934713bd677a60097f8af05d57ac27b32c0e4a2ff7f2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0xe818a67ee5c0531afaa31aa6e20bcac36227a641	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	0x	6	0xd69cbda644c6be817aafb5fd9174f50c33803b6b	54060721	Aave ZkSync weETH	2025-01-19T15:49:08.000Z	aZksweETH	0x861c5e80b9f073ce62bca6c095493240ad7de47c1c39c15bbe02172c60da9667	18	0xc1fa6e2e8667d9be0ca938a54c7e0285e9df924a	0x37c972c9ddfc2138ebe33ec19dba063ab9f8966e
0xf3c9d58b76ac6ee6811520021e9a9318c49e4cfa	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	0x	13	0xd69cbda644c6be817aafb5fd9174f50c33803b6b	54060721	Aave ZkSync sUSDe	2025-01-19T15:49:08.000Z	aZkssUSDe	0x861c5e80b9f073ce62bca6c095493240ad7de47c1c39c15bbe02172c60da9667	18	0xad17da2f6ac76746ef261e835c50b2651ce36da8	0x37c972c9ddfc2138ebe33ec19dba063ab9f8966e
0xc48574bc5358c967d9447e7df70230fdb469e4e7	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	0x	38	0xd69cbda644c6be817aafb5fd9174f50c33803b6b	44671759	Aave ZkSync USDT	2024-09-20T14:07:05.000Z	aZksUSDT	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4	6	0x493257fd37edb34451f62edf8d2a0c418852ba4c	0x37c972c9ddfc2138ebe33ec19dba063ab9f8966e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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	in_balanceIncrease
0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	false	1006227246406117510621765347	674281785403686	0xae2b00d676130bdf22582781bbba8f4f21e8b0ff	4	61689809	0x52542ffc9120723ac5bd1e7b6b2da9b066621ae3	2025-06-14T03:16:08.000Z	0x5f2d2949e8ab66a8c9df6adbca4e61a7872e2f3d5ff5a3a0850da8864151499e	674281785403686
0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	false	1006242444449927445303336497	16306007691818	0xae2b00d676130bdf22582781bbba8f4f21e8b0ff	4	61706565	0xdb9f34e8d6ad8f1d632c33029979e9ecc05ab4b8	2025-06-14T14:01:55.000Z	0x2d34e2ac05fb2a58134d7cb1b64d5fb577f92874255c90efda814c95eab6d67f	16306007691818
0xb7b93bcf82519bb757fd18b23a389245dbd8ca64	false	1006241294061747084973627239	32555038505028	0xae2b00d676130bdf22582781bbba8f4f21e8b0ff	4	61705215	0x91d78a84329a7e1d668919645a0b1165c18545a3	2025-06-14T13:13:02.000Z	0x6b635e0c7bc079551aaf36f7d836bd94b237a24e9c567ba8bcca944117980806	32555038505028

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x7bfee91193d9df2ac0bfe90191d40f23c773c060	false	150000000	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	47166910	50448491610224765926446703	0x7bfee91193d9df2ac0bfe90191d40f23c773c060	2024-10-22T21:11:20.000Z	0x86df35bb550f1f61449ed6aaf28b38160fb816871821a699faffed2e85534ae6	2
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0xc64903b4e9a43b1f9ee94b7b7949189cfc40cdcf	false	260000000	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	47144008	52051285869741284759216358	0xc64903b4e9a43b1f9ee94b7b7949189cfc40cdcf	2024-10-22T14:17:05.000Z	0x45bf3e86b941a3a0313f551275149b3860772c778bb0073c93ea8f2d209e206e	2
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x98231a159ee1e33d0088777ad968a8681a04d854	false	80000000	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	47166122	50416077559882081111594586	0x98231a159ee1e33d0088777ad968a8681a04d854	2024-10-22T20:56:18.000Z	0x353cd6e5305c6b2c9498218e8d1fcc9b4db2ed96dfe9d2d359ddf33e75807f70	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	21093750	0x3335457cd3a45d691b5d7b065e4dae6121741783	31	10547	61953135	0x3335457cd3a45d691b5d7b065e4dae6121741783	2025-06-20T17:39:03.000Z	0x05c1892e0dce7f0bbfb3516c221e0db7a386650cf7ce77c28d2eea6de4c772ea
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	0x493257fd37edb34451f62edf8d2a0c418852ba4c	3568412	0x3335457cd3a45d691b5d7b065e4dae6121741783	42	1784	61953144	0x3335457cd3a45d691b5d7b065e4dae6121741783	2025-06-20T17:39:16.000Z	0x3097b002e0ef5823cbff084da05c48ccb84014fc02334e65ebd1ea730a85076f
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	22701569116877852	0x5ae15eabb65d8be11d368beb6ae843fa1b7d7ee5	35	11350784558439	61930737	0x5ae15eabb65d8be11d368beb6ae843fa1b7d7ee5	2025-06-20T04:36:55.000Z	0x7250147c612d7d8b972931b02e9b07450934468426ccfebf9bec2da33f461ecd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x9a126eddd23df8daef0867d06d52146420c93208	false	17	50977531	0x5a7d6b2f92c77fad6ccabd7ee0624e64907eaf3e	0xeeda0088c3b603eb04e1113a8df1d6629cbd4820	69522291911482280604	2024-12-10T19:39:47.000Z	false	0x832774617cfcb6543b0dbeb98b3a57a6a9753c74486baf8132fa4bbf1b89e27c	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	4277409846032015
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x4862c6ded275b30780f1c03053b13f100a3e4073	false	17	56634005	0x493257fd37edb34451f62edf8d2a0c418852ba4c	0xfafe38b1449ce574ca0b494a5bb79d982f787545	51759929	2025-02-26T12:05:53.000Z	false	0xc3a67d47a88cb95dcd5e1b08c0051e34aa546847ccffcb123ecb2ad2ab244839	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	22193484245279037
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x8d59b9fc743cb2d80b47ad8bc0571432b45c68d2	false	22	56648178	0x493257fd37edb34451f62edf8d2a0c418852ba4c	0xfafe38b1449ce574ca0b494a5bb79d982f787545	18607420	2025-02-26T17:53:03.000Z	false	0xd49364d9e95ca2b50ffee0498e4fbbfb17006298c44b2b59ecdd0eae316aa5c6	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	8279461660249235

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x1df2535cf0956abec21c4738534885d3849d6578	false	2550001245	6	0x1df2535cf0956abec21c4738534885d3849d6578	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	45868266	false	2024-10-05T07:21:38.000Z	0xf712806ac727805af5458af5300fed73a90e169ae126b83b361650596175cf42
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x4809453c254609f86393728336014f69dfc745dd	false	5000000000	10	0x4809453c254609f86393728336014f69dfc745dd	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	45848562	false	2024-10-05T01:08:02.000Z	0x8a74251b3d36431058b38a5bb0ad4f67ff087cee6e3445eba1e2b46d305565d0
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0xe28e42ee6da993aa51bb2de2a6bba88656e60a0a	false	23400	32	0xe28e42ee6da993aa51bb2de2a6bba88656e60a0a	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	45870421	false	2024-10-05T08:00:47.000Z	0x13af8d2b8617e1ad59eba21b4bc80ce814f0beeefa5a4fe368d036273ea51ede

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

Aave V2/V3 protocol events emitted when lending pool reserve parameters are updated, including liquidity and borrow indices, interest rates for stable and variable borrowing. Used for tracking interest accrual and reserve state changes across 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_liquidityRate`	`STRING`	Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers.
`in_stableBorrowRate`	`STRING`	Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan.
`in_variableBorrowRate`	`STRING`	Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan.
`in_liquidityIndex`	`STRING`	Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve’s inception, stored as a numeric string.
`in_variableBorrowIndex`	`STRING`	Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve’s inception, stored as a numeric string.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_variableBorrowRate	in_variableBorrowIndex
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	2	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	63116436	2025-07-20T08:35:12.000Z	40866279603831455997372150	0xa899379f3a7c80e10d5fbf238d2cc7dc188538ca3eb99912834b6e657504eee1	1038887182437230633673734960	52677047478213005158244993	1056487821449793522920990885
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	4	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	63139151	2025-07-20T19:55:38.000Z	39647410455061241287433915	0x857a2fa9efc9a5c7a8bb422512d9347cb1743c3e469de6fa74160cdde86ffb9b	1038941306599112233306136702	51885533593577178651670527	1056559317938073561322005976
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	false	4	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	63118776	2025-07-20T09:43:37.000Z	40815979210310587194072558	0x2e3d18743cdf40447df1f55287e24d2fa8f7998aca97be570a248a795fc6f5ef	1038892709472206500223037337	52644618638489264540169928	1056495066139196155075023595

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_zksyncera.LendingPool_ReserveDataUpdated_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
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x656ca92a30b6cf6344e726fb0fc6b7641a3f8213	false	4999927000	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	60109895	0x656ca92a30b6cf6344e726fb0fc6b7641a3f8213	2025-05-08T17:20:27.000Z	0x185d236aa2bf30afe29689ead36c5bfc334d9da342287703f9d3520b6604eb1a
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x8ed0d975bb0b4e723ed9b02107348a66480ca9f1	false	177103649	7	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	60108905	0x8ed0d975bb0b4e723ed9b02107348a66480ca9f1	2025-05-08T16:50:28.000Z	0x8b07be1dece579d2bf31e2f546cbdfa902aed8d0ab0b6808b5874e2c4ade094a
0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0xf2b1db1a280f042506fceaebbf8a3753b91d44eb	false	6520992513	7	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	60105259	0xf2b1db1a280f042506fceaebbf8a3753b91d44eb	2025-05-08T15:17:32.000Z	0x999e7af6932ba71a14a895441797e1e7466b6f97f6c2a088ac414438039cd0d3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0xe1c70e0e9233b730228e17ae68a2d5281db4740e	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0xe1c70e0e9233b730228e17ae68a2d5281db4740e	false	50521172597	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	57696814	2025-03-15T08:54:59.000Z	0x928a56d13343057750e8a6ab77b34ab8f2130907a886a9d3ab60cdfb34231db6
0xe1c70e0e9233b730228e17ae68a2d5281db4740e	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0xe1c70e0e9233b730228e17ae68a2d5281db4740e	false	2000000	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	57695678	2025-03-15T08:25:46.000Z	0xb0d66e00f4ed90d7beadd275feebb0d3168ef88d570dc6d500b047c2d44ae242
0x984ab9407abf0a07d56adcfd5b1369426a13c671	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	0x984ab9407abf0a07d56adcfd5b1369426a13c671	false	30000000000	6	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	57702921	2025-03-15T11:37:19.000Z	0xc9c2b5b29852ba440101fcd31ce020a8a0c9b1fa38a3aad3b579125206c6b546

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
7500	0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	118	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4	10500	7800
7500	0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x493257fd37edb34451f62edf8d2a0c418852ba4c	122	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4	10500	7800
7500	0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	126	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4	10600	7800

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0xd4169e045bcf9a86cc00101225d9ed61d2f51af2	1000	20	61587841	2025-06-11T18:34:33.000Z	0x61459b3bbcec1864105fe2d73e898eb751d3fb0942cc0e47629e547fc7654389
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	1000	127	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	1000	119	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0xd4169e045bcf9a86cc00101225d9ed61d2f51af2	16	61587841	2025-06-11T18:34:33.000Z	0x61459b3bbcec1864105fe2d73e898eb751d3fb0942cc0e47629e547fc7654389	1000
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x1d17cbcf0d6d143135ae902365d2e5e2a16538d4	87	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4	1000
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0x493257fd37edb34451f62edf8d2a0c418852ba4c	94	44671759	2024-09-20T14:07:05.000Z	0x0d0f32647507f482fa77c09da54153ecf14560572a5491590f97c5ee465715c4	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0xad17da2f6ac76746ef261e835c50b2651ce36da8	0xf3c9d58b76ac6ee6811520021e9a9318c49e4cfa	17	54060721	2025-01-19T15:49:08.000Z	0x861c5e80b9f073ce62bca6c095493240ad7de47c1c39c15bbe02172c60da9667	0x0000000000000000000000000000000000000000	0xdebb4ddaaab1676775214552a7a05d6a13f905da	0x57815ab06d846d7decd326ee541cd06144fed237
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0xc1fa6e2e8667d9be0ca938a54c7e0285e9df924a	0xe818a67ee5c0531afaa31aa6e20bcac36227a641	10	54060721	2025-01-19T15:49:08.000Z	0x861c5e80b9f073ce62bca6c095493240ad7de47c1c39c15bbe02172c60da9667	0x0000000000000000000000000000000000000000	0xf31e1599b4480d07fa96a7248c4f05ca84da7fa8	0x57815ab06d846d7decd326ee541cd06144fed237
0x0207d31b4377c74bec37356aad83e3dcc979f40e	false	0xd4169e045bcf9a86cc00101225d9ed61d2f51af2	0x5722921bb6c37eaeb78b993765aa5d79cc50052f	9	61587841	2025-06-11T18:34:33.000Z	0x61459b3bbcec1864105fe2d73e898eb751d3fb0942cc0e47629e547fc7654389	0x0000000000000000000000000000000000000000	0x97dec07366be72884331be21704fd93bf35286f9	0x57815ab06d846d7decd326ee541cd06144fed237

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x6450fd7f877b5bb726f7bc6bf0e6ffabd48d72ad	0xcba9f2a01fce2797b79184ddf5df13888ad90443	false	1001245441988057074296529449	185709795122849462542	0x0000000000000000000000000000000000000000	3	54198834	2025-01-21T08:14:48.000Z	0xe1a02b3f18ff9e7ab9352c9a747eac95a14a00e9509cfe1ec90a3d9541e63137	9259385758376924487
0x6450fd7f877b5bb726f7bc6bf0e6ffabd48d72ad	0x41fd941bb20990b5bec8cb424f19397254707981	false	1001246480710121747164295012	14998133025701592804292	0x0000000000000000000000000000000000000000	3	54201417	2025-01-21T08:59:25.000Z	0x8904a56c80917b0e560f61b50acabac640eff7d9646eff5813675cae57472e54	1866974298407195708
0x0049250d15a8550c5a14baa5af5b662a93a525b9	0xe610c6de59e10fe84d017b3141f8c0f23a325d30	false	1028988900614955254722732889	165666318	0x0000000000000000000000000000000000000000	3	54173923	2025-01-21T00:47:10.000Z	0x334848b1b3c8638ff205d89d2e2dba8ac7dcd8162a66fd77e36f392d3fbe37ba	10833682

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_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
0x0049250d15a8550c5a14baa5af5b662a93a525b9	false	1042915273080654432266541720	150487911	0xa8cbe4b838b951bc4ca4838e38d4ae83833f54fd	3	59392602	0xa8cbe4b838b951bc4ca4838e38d4ae83833f54fd	2025-04-20T11:09:22.000Z	0x3fc7ed9ea1973b1514132b21100e24dbdfee7c34471b1f7565d913abb4f6df59	487911
0x0049250d15a8550c5a14baa5af5b662a93a525b9	false	1042983650831265062010708849	30000021	0x7a789b0024e92b25c041ee236fe91796c8445934	3	59406462	0x7a789b0024e92b25c041ee236fe91796c8445934	2025-04-20T20:58:06.000Z	0x56544696ab72d2aa28af0ff0e1502f7fe587f68b4a7b757675e03fa56bdcefc4	21
0x8992db58077fe8c7b80c1b3a738eae8a7bddba34	false	1052092595205206657148114068	450000000	0x4629b2d672ee6791aab629912114825de021a107	3	59403715	0x4629b2d672ee6791aab629912114825de021a107	2025-04-20T19:09:39.000Z	0xa26a28e2686030337f0eeac50dfa0d3795e84a9f639c52471410f516414b954e	0

Example Query

Query with partition filter

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

WrappedTokenGatewayV3_withdrawETH_function

Aave V3 WrappedTokenGatewayV3 withdrawETH function call records containing withdrawal amounts, pool addresses, and recipient addresses. Used for tracking ETH unwrapping and withdrawal transactions from Aave lending pools across multiple chains.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_anon0`	`STRING`	Contract address of the lending pool. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_to	status	gas_used	in_anon0	in_amount	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
602847	0x06770a6301e77b4bfab8cf4954bf40ffed29e2e5	true	217713	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	300000000000000000	0x80500d20	0xae2b00d676130bdf22582781bbba8f4f21e8b0ff	65291667	0x06770a6301e77b4bfab8cf4954bf40ffed29e2e5	20,0	2025-10-16T16:22:48.000Z	0x03ad01bfc0121399856b1d39f5ce993c71a492bae980c2312736ab3fd037475b
708750	0x1412a1eb9841f87c9bd2e81e5fe147622def0aef	true	226585	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	70471372222388000	0x80500d20	0xae2b00d676130bdf22582781bbba8f4f21e8b0ff	65296974	0x1412a1eb9841f87c9bd2e81e5fe147622def0aef	20,0	2025-10-16T22:23:44.000Z	0x0b4914e75b8692d83f325f1e5df0014d89f2b1e2becff698471863e5ffc46afc
715113	0x0f4daa365a72c5b134d6e263f21b64de87f2392a	true	223290	0x78e30497a3c7527d953c6b1e3541b021a98ac43c	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xae2b00d676130bdf22582781bbba8f4f21e8b0ff	65293286	0x0f4daa365a72c5b134d6e263f21b64de87f2392a	20,0	2025-10-16T18:11:00.000Z	0x3913734d135c679cff744830b3ff3a1204783a77969592e3e959fa772ded1aaa

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

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_ReserveDataUpdated_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

WrappedTokenGatewayV3_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​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_ReserveDataUpdated_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

​WrappedTokenGatewayV3_withdrawETH_function

Tables

AToken_BalanceTransfer_event

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_ReserveDataUpdated_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

WrappedTokenGatewayV3_withdrawETH_function