aave_v3_scroll

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
0x09d0f7d5f13e992a1c90aaf62307a100f049b6ab	0xf301805be1df81102c957f6d4ce29d2b8c056b2a	0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	false	1028808022016543741112454400	10011586009808904	16	17122964	2025-07-11T07:23:42.000Z	0x61f218ef754915d9ea8f23cea24e1753889f3e897216693e035d7d0a37dd2d2f
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0xf301805be1df81102c957f6d4ce29d2b8c056b2a	0xbfe03c9e20a9fc0b37de01a172f207004935e0b1	false	1028808022016543741112454400	10011586009808904	10	17122964	2025-07-11T07:23:42.000Z	0x61f218ef754915d9ea8f23cea24e1753889f3e897216693e035d7d0a37dd2d2f
0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae	0xf301805be1df81102c957f6d4ce29d2b8c056b2a	0xbfe03c9e20a9fc0b37de01a172f207004935e0b1	false	1028807963799453209024159285	10011586576333882	10	17122936	2025-07-11T07:22:10.000Z	0x3f647c047e5f97d8804187cb1ab2c862febfa613d209445a9f56261b00c27eab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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	in_balanceIncrease
0x1d738a3436a8c49ceffbab7fbf04b660fb528cbd	0xa4ed9c3dc3eb4a6163a8a1b598a87c8342390460	false	1000091904684980801091055368	1449997444	0xa4ed9c3dc3eb4a6163a8a1b598a87c8342390460	2	3459745	2024-02-19T05:37:58.000Z	0xfd9e584657a5cfb18328c8d72249180293a8fe5ad9add047e021fd0f796ab9b0	14443
0x1d738a3436a8c49ceffbab7fbf04b660fb528cbd	0xa461799a7f333ce53b5868c22def8350c8c5cdf0	false	1000097719523847966763083419	28157291	0xa461799a7f333ce53b5868c22def8350c8c5cdf0	2	3471527	2024-02-19T15:42:08.000Z	0x69c7b620d45eb97e0f76781c97e3cbfc317fa0e937b88c4935176430b08e1484	979
0xf301805be1df81102c957f6d4ce29d2b8c056b2a	0xded6ef110e86a226e78dad607ee413fbb8bcedca	false	1000046555955605835179100590	10292647265547800	0xded6ef110e86a226e78dad607ee413fbb8bcedca	3	3457459	2024-02-19T03:42:29.000Z	0x43ec8f91d30a0fc5091f507a27f0b1f7aebb1f01eb752ed1b3eece1ee0110e4b	1121374963

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0xd80a5e16dbdc52bd1c947cedfa22c562be9129c8	0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0x	35	0x90eb541e1a431d8a30ed85a77675d1f001128cb5	8134455	Aave Scroll weETH	2024-08-06T17:34:10.000Z	aScrweETH	0x08d800dc48cf1e4f402a4c0dcb13901a8ef2e911abca01e2380389c45b3ea493	18	0x01f0a31698c4d065659b9bdc21b3610292a1c506	0xa3f3100c4f1d0624db9db97b40c13885ce297799
0x1d738a3436a8c49ceffbab7fbf04b660fb528cbd	0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0x	13	0x90eb541e1a431d8a30ed85a77675d1f001128cb5	16943281	Aave Scroll USDC	2025-07-03T14:55:03.000Z	aScrUSDC	0xe0529bfe5caf2e3a971f3d5ebaa7af0015981261e1f47f44beebcce0aa72f791	6	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0xa3f3100c4f1d0624db9db97b40c13885ce297799
0xd80a5e16dbdc52bd1c947cedfa22c562be9129c8	0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0x	25	0x90eb541e1a431d8a30ed85a77675d1f001128cb5	16943281	Aave Scroll weETH	2025-07-03T14:55:03.000Z	aScrweETH	0xe0529bfe5caf2e3a971f3d5ebaa7af0015981261e1f47f44beebcce0aa72f791	18	0x01f0a31698c4d065659b9bdc21b3610292a1c506	0xa3f3100c4f1d0624db9db97b40c13885ce297799

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0xf301805be1df81102c957f6d4ce29d2b8c056b2a	false	1001577216909814771484096201	40995904	0xff75a4b698e3ec95e608ac0f22a03b8368e05f5d	2	5645062	0xb704878cae371e656b31d6d55085380be343d296	2024-05-13T21:57:42.000Z	0x4dfa1870e2f3fc1fcd7ec86622845c4249f4d07fab3ba780e8acec62a916bca7	40995904
0xf301805be1df81102c957f6d4ce29d2b8c056b2a	false	1001565286445173906253936803	5132714114880	0xff75a4b698e3ec95e608ac0f22a03b8368e05f5d	2	5629253	0xb8e52321dc7a8c00ca1749aaa53221ed8d7519ae	2024-05-13T08:45:30.000Z	0x55584fc635c24d81e25bec343e6a543bd506f969833508ec74ede7e6b0421461	5132714114880
0xf301805be1df81102c957f6d4ce29d2b8c056b2a	false	1001564507690262992148869105	16492428258	0xff75a4b698e3ec95e608ac0f22a03b8368e05f5d	2	5628201	0x92c43ed73e5d46229e0055005fde3dec5be05d27	2024-05-13T07:52:54.000Z	0x66bfae37f6e7f364bbb1de0e188ebe28050ca50582732ebd62991bdc35370930	16492428258

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_event

Reward claim events from Aave IncentivesController contracts recording the distribution of protocol incentive tokens to users. Tracks user address, claimer address, recipient address, reward token contract, and claimed amount for analyzing liquidity mining and staking reward distributions.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. 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_claimer`	`STRING`	Address of the account initiating the claim 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.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.IncentivesController_RewardsClaimed_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
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x0f3483d8c37c8c9cc89e9e7d9ae00183ec89fea3	false	2939620000000000	53	0x01f0a31698c4d065659b9bdc21b3610292a1c506	10336707	32222768742873958148169857	0x0f3483d8c37c8c9cc89e9e7d9ae00183ec89fea3	2024-10-20T03:41:57.000Z	0x06b21b9b8ae6a48d7bee406ceee369b246fccfab0e55f1d385fa5d74eb8c03fb	2
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x1b648ade1ef219c87987cd60eba069a7faf1621f	false	24570000000000000000	5	0x01f0a31698c4d065659b9bdc21b3610292a1c506	10351031	32332654691296682223879573	0x1b648ade1ef219c87987cd60eba069a7faf1621f	2024-10-20T15:32:12.000Z	0xb513e46a3e910a6ec327bffd92dd6b18fe965a7c271d0da17ed11a8458ea5e4a	2
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x1b648ade1ef219c87987cd60eba069a7faf1621f	false	27200000000000000000	10	0x01f0a31698c4d065659b9bdc21b3610292a1c506	10350991	32222262484601126710052857	0x1b648ade1ef219c87987cd60eba069a7faf1621f	2024-10-20T15:30:13.000Z	0x464fe7bce92d10dcd96aaae3cd8f05ea636159e1471a9ebc51e1e32ffe645595	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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	block_number	in_initiator	block_timestamp	transaction_hash
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0x5300000000000000000000000000000000000004	13194885846082888610	0x14f8e5fe35b2d0d67dbce9329f1b5d09f60c06c3	58	11680326	0x14f8e5fe35b2d0d67dbce9329f1b5d09f60c06c3	2024-12-06T00:26:41.000Z	0x057c5201bdeea5e17072307b2b86150cf1ac7a166e2826e9f883b4443f82f213
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0x5300000000000000000000000000000000000004	3189728295155272825	0x14f8e5fe35b2d0d67dbce9329f1b5d09f60c06c3	41	11692160	0x14f8e5fe35b2d0d67dbce9329f1b5d09f60c06c3	2024-12-06T11:07:17.000Z	0xdf63cc717d81a09881ac044c2301fa19fe1d6be6fcebbb2c7f264f830bf3f15c
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0x5300000000000000000000000000000000000004	442029746882944962	0x14f8e5fe35b2d0d67dbce9329f1b5d09f60c06c3	59	11689350	0x14f8e5fe35b2d0d67dbce9329f1b5d09f60c06c3	2024-12-06T08:40:06.000Z	0x66a6e04c568b421cd07716e19ad06cc46177dfa6d3d7ec7a563516401f36959d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0xf64bc5b2023b0c506955b4c040c925ff48e541c4	false	12	16922942	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0x88888888212b4e299b970e50756db34e018faea5	20317394	2025-07-02T19:56:51.000Z	false	0x5901f50a2a30fcb0eade33a346ee7b17ac850af07ab89a30dd7b6b558d2e0c41	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	21231677
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x1e71bdea429ee1436fbbca449c2bf5cb3c5055fc	false	12	16919014	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0x88888888212b4e299b970e50756db34e018faea5	6714025	2025-07-02T16:50:15.000Z	false	0x5db28722c0e83a8f5920f543fc4a6ac7784a7a0f939fca1e1aa0681d4e22e205	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	7016156
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x1e81f40448f091564c8924b50eae1fdb21e8cf43	false	16	16926210	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	0x9b9f64e199d12ea9b98b9e68e74691f816d227fb	850602591484613	2025-07-02T23:20:17.000Z	false	0xbeb4c7b83ad7ed2a3e9cfc6214f0e9d0ac21f9c97faa4d203532ac9bdef71021	0x5300000000000000000000000000000000000004	1082203932572940

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	14	0xd29687c813d741e2f938f4ac377128810e217b1b	15376872	2025-05-12T06:06:29.000Z	32516329618493933	0xfb92e3dad2ba7e1bc41dca2cb8c8c10295c77e170ecfde1aa5afde3301fe3883
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	2	0x5300000000000000000000000000000000000004	15376872	2025-05-12T06:06:29.000Z	68903608585574134	0xfb92e3dad2ba7e1bc41dca2cb8c8c10295c77e170ecfde1aa5afde3301fe3883
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	11	0x01f0a31698c4d065659b9bdc21b3610292a1c506	15376872	2025-05-12T06:06:29.000Z	29186212936411402	0xfb92e3dad2ba7e1bc41dca2cb8c8c10295c77e170ecfde1aa5afde3301fe3883

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x32031a391b433f7e864705beb62f0f819d9c899f	false	28453686	4	0x32031a391b433f7e864705beb62f0f819d9c899f	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	6952458	false	2024-06-28T07:52:01.000Z	0x51746de2320ddd82fc2c64f1e2aa830f85118750d95ebb0150cfa9859476d4e4
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0xe285aca4e22f3505b8c2be2b29ca8c2006072ef8	false	435677	4	0xe285aca4e22f3505b8c2be2b29ca8c2006072ef8	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	6963258	false	2024-06-28T16:52:16.000Z	0x06941e7a2460ce333ab86749d16669c8c31e838c70fbf4f43852adb942a6febf
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0xacd37dd3bdbd47d2e2908ed0a63743aac8d679b1	false	2000000	4	0xacd37dd3bdbd47d2e2908ed0a63743aac8d679b1	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	6944583	false	2024-06-28T01:18:16.000Z	0xfd2f64b57846fdf79c07f47162bed571cf2f7ebc627162150bb7b15734bba84c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_stableBorrowRate	in_variableBorrowRate	in_variableBorrowIndex
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	6741770	2024-06-21T00:10:32.000Z	121596048092603126680109	0xfd3c348a15691e29d2293139d0f8e4dced5554ca03eff9f7e6f1e258347f5f03	1000085437817838267139506385	94717294939513401057057882	4717294939513401057057882	1002107960532154150965757125
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	6742942	2024-06-21T01:09:08.000Z	121470342030111520281137	0x7a64dd9fbd3140d326bc1bdc4549015314749f1c0da73a84d1988fbebdf05ed8	1000085451466150176504531005	94714855937917353439123344	4714855937917353439123344	1002108489305273891116886490
0x11fcfe756c05ad438e312a7fd934381537d3cffe	false	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	6749578	2024-06-21T06:40:56.000Z	103382386875130058586885	0xa6dc8b12c81d6b7213251a9d23e36b2979c9c1fdde94668a096a50a06824d53f	1000085524352527984613490984	94349672688838069522664022	4349672688838069522664022	1002111395000363495394216020

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x89bdace4cbef8db28f0a42f8d64fbdba5765c7db	false	370716	4	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	4779613	0x89bdace4cbef8db28f0a42f8d64fbdba5765c7db	2024-04-11T09:57:24.000Z	0xfd01efa3a6ba0739d47a12863a632caa87e3d25ebca7fe51ff9ba7c972879bec
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x7d728247dc6e2b23e6b2189f87f341fe346f1487	false	900000000	4	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	4777464	0x7d728247dc6e2b23e6b2189f87f341fe346f1487	2024-04-11T06:18:59.000Z	0x31a7d77995d5d8017ea4ced041af6a1b4d7489fa88fa6ae4fb494ae939ef4bcd
0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x44af52790c30df4e842f0783a8353ec9e7363e5c	false	692689	4	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	4780163	0x44af52790c30df4e842f0783a8353ec9e7363e5c	2024-04-11T10:55:53.000Z	0xaccaf36edfecc6b30436437b4be4c56bfbbf83fcefb5c9f9272c5dcffeb7b3d9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0xbe67bcd696cdde001b9dad3773d9fb2fa5e9e30b	0x11fcfe756c05ad438e312a7fd934381537d3cffe	0xbe67bcd696cdde001b9dad3773d9fb2fa5e9e30b	false	1201000000	4	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	14737682	2025-04-14T22:50:53.000Z	0x26bdea9dc20fc339a244f2095f74ef1d6dfe12318dfa0be98321769504bb66fe
0x0e4b4b84bff1e25c7e0e12b6ea16c92f3413b51e	0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x0e4b4b84bff1e25c7e0e12b6ea16c92f3413b51e	false	5295484	5	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	14733191	2025-04-14T19:06:20.000Z	0xfb1d8e99782e1c01cdd6be3d112d1e2a01419044a6b5b3cc568e01cb49dfb253
0x2bcdd492bd61d201133a24b56913c6b7502f3606	0x11fcfe756c05ad438e312a7fd934381537d3cffe	0x2bcdd492bd61d201133a24b56913c6b7502f3606	false	19181496	5	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	14724176	2025-04-14T11:35:35.000Z	0x2b0691597c84856786426f589716336a5a03dfb5794beb60fa8bd2fb2e09ae0e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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	0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	23	5626234	2024-05-13T06:14:33.000Z	0x0c3557170c8c6977c7391dd60972596e5e0292ff9508da5b3bc10f35ffcd966e	10500	7800
7600	0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0	4778348	2024-04-11T07:49:59.000Z	0xadbf48fdf40b9c377bc9aa94fa17a6a904285982a8f7473ffe09ebd5c543c746	10500	7900
7500	0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	25	9778828	2024-10-01T15:51:32.000Z	0xae16f8a1db7eb726e3b5c6e3f0b108f90ce3fd37eefacc7ab9f4e30a2fc08656	10700	7900

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x01f0a31698c4d065659b9bdc21b3610292a1c506	1000	51	8134455	2024-08-06T17:34:10.000Z	0x08d800dc48cf1e4f402a4c0dcb13901a8ef2e911abca01e2380389c45b3ea493
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x5300000000000000000000000000000000000004	1000	46	3196633	2024-02-09T18:33:14.000Z	0xc166eb675862e5f36e1ced75e87fce48a4e29a96ad2eaee610efa98c560daf85
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	1000	54	3196633	2024-02-09T18:33:14.000Z	0xc166eb675862e5f36e1ced75e87fce48a4e29a96ad2eaee610efa98c560daf85

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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	in_oldReserveFactor
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0xd29687c813d741e2f938f4ac377128810e217b1b	11	12065687	2024-12-20T12:32:09.000Z	0xd26401d2adfe3b138f6ec3ddc44d3dc94731d1cf286a2751f20903ef35b52b56	2000	0
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x01f0a31698c4d065659b9bdc21b3610292a1c506	13	9400186	2024-09-18T14:07:29.000Z	0xc14bcb36bba0c2ed74fbda1862a04cbc7e5d31805c09554efccad486b42a50f0	4500	1500
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0xf610a9dfb7c89644979b4a0f27063e9e7d7cda32	92	8308452	2024-08-12T13:28:01.000Z	0xb3bf9ef2724bce919575d2f7509c279564c2359374628e388dbe1601e01448e3	500	1500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0xd29687c813d741e2f938f4ac377128810e217b1b	0x25718130c2a8eb94e2e1fafb5f1cdd4b459acf64	4	12065687	2024-12-20T12:32:09.000Z	0xd26401d2adfe3b138f6ec3ddc44d3dc94731d1cf286a2751f20903ef35b52b56	0x0000000000000000000000000000000000000000	0xffba405bbf25b2e6c454d18165f2fd8786858c6b	0xc37353e5766164d8654d3cb395acfdca4c2e7ddc
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x01f0a31698c4d065659b9bdc21b3610292a1c506	0xd80a5e16dbdc52bd1c947cedfa22c562be9129c8	39	8134455	2024-08-06T17:34:10.000Z	0x08d800dc48cf1e4f402a4c0dcb13901a8ef2e911abca01e2380389c45b3ea493	0xf474cc392591e3252996459fcaa3d75dc9f95b09	0x009d88c6a6b4caa240b71c98ba93732e26f2a55a	0xec93d0bba1b1e635ba0fff4786db323db49d99f0
0x32bcab42a2bb5ac577d24b425d46d8b8e0df9b7f	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0x1d738a3436a8c49ceffbab7fbf04b660fb528cbd	16	3196633	2024-02-09T18:33:14.000Z	0xc166eb675862e5f36e1ced75e87fce48a4e29a96ad2eaee610efa98c560daf85	0x59f359aa263f7ac09876e869af1f75b558904ed4	0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	0x9205b37978ac983a297dfb53b3f3d2ccc7dddada

Example Query

Query with partition filter

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

ShortExecutor_ExecutedAction_event

Governance execution event recording completed actions in Aave V3’s ShortExecutor contract. Contains target address, function signature, execution timestamp, and delegatecall flag for tracking protocol governance operations across 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.
`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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_executionTime`	`STRING`	Unix timestamp when the action was executed. Integer value representing seconds since epoch.
`in_withDelegatecall`	`BOOL`	Boolean flag indicating whether the contract call was executed using delegatecall opcode instead of a standard call.
`in_resultData`	`STRING`	Return data from the executed contract function call. Hex-encoded byte string containing the function’s output parameters.

Sample Data

address	in_data	removed	in_target	log_index	block_number	in_signature	in_resultData	block_timestamp	in_executionTime	transaction_hash	in_withDelegatecall
0xc1abf87ffadf4908f4ec8dc54a25dcfeabae4a24	0x	false	0xfec5ebf148e91a6090f5b1657eddf31b85dce74e	2	14114573	execute()	0x	2025-03-19T16:05:16.000Z	1742400316	0xf703f1926e440f2d31d770f4cfb162e676a59ab0c717a869ef0f87a688ad9328	true
0xc1abf87ffadf4908f4ec8dc54a25dcfeabae4a24	0x	false	0x5914ab024e4d730886ad2f2af8790c466b0c2868	36	16943281	execute()	0x	2025-07-03T14:55:03.000Z	1751554503	0xe0529bfe5caf2e3a971f3d5ebaa7af0015981261e1f47f44beebcce0aa72f791	true
0xc1abf87ffadf4908f4ec8dc54a25dcfeabae4a24	0x	false	0x9d9892256df8f97d0c15f4494aa5d44d376cc749	15	11952588	execute()	0x	2024-12-16T07:21:36.000Z	1734333696	0xadd1a01fa9c24d363ff765afd859910dd2f6b6ce23a8e4a3db9e8294bfacfec8	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.ShortExecutor_ExecutedAction_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_scroll.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_scroll.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
0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	0xf03374dcbe72652b3cec7a08de79def9942865b1	false	1000810326494882880334632164	50000000	0x0000000000000000000000000000000000000000	1	3630494	2024-02-25T20:18:25.000Z	0x237a096e864ee958defb8efbf06b0d596dc962249ce3a0e8404a24afd9278edc	12
0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	0x2d41c079d733825796842c113ce557acebbb6c6d	false	1000802133978121550982959818	12000000	0x0000000000000000000000000000000000000000	1	3628401	2024-02-25T18:08:23.000Z	0xcde7da7816e6d8354e296d7502e013513180d77bccb6ea9c2fff32a143306a42	56
0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	0xf0061d98fcfb916b3f57ca1f51af90b6722d6762	false	1000753000911941908391819270	900000000	0x0000000000000000000000000000000000000000	1	3616725	2024-02-25T05:09:58.000Z	0x82a2a942ffcc1899805123e14e5262ce59861e45d5e5f5fa8b187a9dbf9b5b3a	66

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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
0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	false	1013794499344906592392309028	138703040	0x1069d8fc5d6b2ba45971a0e52ce4acae7456e2e6	1	5636630	0x1069d8fc5d6b2ba45971a0e52ce4acae7456e2e6	2024-05-13T14:55:29.000Z	0xe5e8619834f8e4c540e87a12776af38b383406446080e6d0daa3e68bfc397c12	1003040
0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	false	1013731715193501011798627422	1498877513	0x3a76e83ab068dc80312cf588dc6267e5d7184629	1	5623493	0x3a76e83ab068dc80312cf588dc6267e5d7184629	2024-05-13T03:57:30.000Z	0x411c57429feec6a2e282899b097f4b07092527b08a63beb840d94be1790966a9	0
0x3d2e209af5bfa79297c88d6b57f89d792f6e28ee	false	1013814269801998306668395953	10000000	0xec3b49371c189380e722fdbc77da9e50ba17d742	1	5640637	0xec3b49371c189380e722fdbc77da9e50ba17d742	2024-05-13T18:16:25.000Z	0x015bf62f2f5cc33d60ecad34c80022143a01e849de7cb0e4318a06e38cf612e2	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_scroll.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	block_timestamp	transaction_hash
864608	0x94cb27428661700e0d4797300e69d29ea33b31f8	true	259643	0x11fcfe756c05ad438e312a7fd934381537d3cffe	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xe79ca44408dae5a57ea2a9594532f1e84d2edaa4	13925033	0x94cb27428661700e0d4797300e69d29ea33b31f8	2025-03-09T15:38:03.000Z	0xeb98f11e53277a9e3df28e81b87b17f011cf7e3b51cf293259c6f772fa92ef9b
355543	0xaabcb9c066fea02fda959caae85e57b2a650eb00	true	266156	0x11fcfe756c05ad438e312a7fd934381537d3cffe	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xe79ca44408dae5a57ea2a9594532f1e84d2edaa4	13921103	0xaabcb9c066fea02fda959caae85e57b2a650eb00	2025-03-09T10:47:38.000Z	0x4a19aee7cae8a93c06f1e3aaa27511c964ddbf33f8c89f0393b89344a41c89ee
355547	0xcd5b610d15b5a675d48e1f162d4f0adf6099b430	true	266156	0x11fcfe756c05ad438e312a7fd934381537d3cffe	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xe79ca44408dae5a57ea2a9594532f1e84d2edaa4	13921039	0xcd5b610d15b5a675d48e1f162d4f0adf6099b430	2025-03-09T10:43:56.000Z	0x761d87a47e15690a9803e51138ea0b2d5e8f1221c040b770c1dab37c9e330736

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_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

ShortExecutor_ExecutedAction_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

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

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

IncentivesController_RewardsClaimed_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

ShortExecutor_ExecutedAction_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function