aave_v3_linea

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
0x523cb31ca594e7c2cd1aa2c8bddea601c22b8e67	0x374d7860c4f2f604de0191298dd393703cce84f3	0xf344192b9146132fc0e997d1666dc1531bf8f7cd	false	1007412863079870705509033262	99264168	4	20357917	2025-06-27T00:14:58.000Z	0xcbea396e5ed9ccf273a8f4d1086066fa5d531675fda6a35c823dafce14a5a12f
0x31a239f3e39c5d8ba6b201ba81ed584492ae960f	0x787897df92703bb3fc4d9ee98e15c0b8130bf163	0xc20d3b54b85decb70156932eb32b905c42709ccc	false	1004720453862154232338377604	3981206896529243	5	20365037	2025-06-27T06:56:28.000Z	0xa4b91f5a8ea5fe7304169403427588cf7f017cb38152190800a9bd7560169f8a
0x31a239f3e39c5d8ba6b201ba81ed584492ae960f	0x787897df92703bb3fc4d9ee98e15c0b8130bf163	0xab4bdbef93c0590e18d4d047b370453579210d1c	false	1004729797338668478976552615	49840017513022058	5	20373599	2025-06-27T13:14:53.000Z	0x4c1b87f8d9db157d44b43f357339783c49369a200a818b36294f1628988e1f53

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x935efcbefc1df0541afc3fe145134f8c9a0beb89	0x285fea61d7dcb29ae74e8cb29a8339ffc3b8f889	false	1000000000000000000000000000	990000000000000	0x285fea61d7dcb29ae74e8cb29a8339ffc3b8f889	23	23588684	2025-09-20T21:53:19.000Z	0xcaa8c9115ee20abacdb75b936ede8933c4f77f827706395233334345465115ca
0x935efcbefc1df0541afc3fe145134f8c9a0beb89	0x37371dbad6d5074ceae5440f96b506e24d50fcd8	false	1000000000000000000000000000	23495434010392780	0x37371dbad6d5074ceae5440f96b506e24d50fcd8	5	23564358	2025-09-20T08:09:57.000Z	0x6b03c6d7bc7a56d312d77983852fdd397b549b241c5e8e8bcd8bf86f35b7e92a
0x935efcbefc1df0541afc3fe145134f8c9a0beb89	0x797ae17ab4fda327e0697b99e5671e5e963a8838	false	1000000000000000000000000000	214082839704718857	0x797ae17ab4fda327e0697b99e5671e5e963a8838	11	23569489	2025-09-20T11:01:32.000Z	0x8401143959f023402bf372019572286bcbdaaed690887e9292092f98e8005f7b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x88231dfec71d4ff5c1e466d08c321944a7adc673	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0x	47	0x86e2938dae289763d4e09a7e42c5ccca62cf9809	21727801	Aave Linea USDT	2025-08-07T10:25:27.000Z	aLinUSDT	0x37fb8885d40e26b68fbc9e60361920669c6ece909326aa84f0532853fbe75734	6	0xa219439258ca9da29e9cc4ce5596924745e12b93	0xc67bb8f2314fa0df50cba314c6509a7bdad500c0
0x374d7860c4f2f604de0191298dd393703cce84f3	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0x	41	0x86e2938dae289763d4e09a7e42c5ccca62cf9809	21727801	Aave Linea USDC	2025-08-07T10:25:27.000Z	aLinUSDC	0x37fb8885d40e26b68fbc9e60361920669c6ece909326aa84f0532853fbe75734	6	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	0xc67bb8f2314fa0df50cba314c6509a7bdad500c0
0x37f7e06359f98162615e016d0008023d910bb576	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0x	35	0x86e2938dae289763d4e09a7e42c5ccca62cf9809	21727801	Aave Linea WBTC	2025-08-07T10:25:27.000Z	aLinWBTC	0x37fb8885d40e26b68fbc9e60361920669c6ece909326aa84f0532853fbe75734	8	0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4	0xc67bb8f2314fa0df50cba314c6509a7bdad500c0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x374d7860c4f2f604de0191298dd393703cce84f3	false	1004264231559642634753637322	5000000	0x06e7665e8e9e01f74b1e80d35b132b50da6b2537	3	18589882	0x06e7665e8e9e01f74b1e80d35b132b50da6b2537	2025-05-02T00:17:43.000Z	0x63c7d02743a37618ef2c5985c87a9c2393eb22d140c402d19e305e22fc1dd034	0
0x374d7860c4f2f604de0191298dd393703cce84f3	false	1004264573719139445562442843	7855813	0x06e7665e8e9e01f74b1e80d35b132b50da6b2537	5	18590059	0x06e7665e8e9e01f74b1e80d35b132b50da6b2537	2025-05-02T00:28:39.000Z	0x241b4686096d68615dafbd5b64c12103b5e5b441ce16ac6b97364740f8f0997e	1
0x374d7860c4f2f604de0191298dd393703cce84f3	false	1004291136518648647158215743	40002138	0x0784810c77be2956affa56bb04e2befdfadb8902	7	18607888	0x0784810c77be2956affa56bb04e2befdfadb8902	2025-05-02T14:22:43.000Z	0x7a72cd2ae3a6761ab4535cfc9b59fde935982c717fc484d3e15b9cfe871b5fb6	2138

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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_linea.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
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x096b93f8b41b77f1247a13655bc1a5455d967bb5	false	30000000	6	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	19590370	35481694840297280149032721	0x096b93f8b41b77f1247a13655bc1a5455d967bb5	2025-06-02T10:00:56.000Z	0xcf4a3fd3ff5dee7237bcfac9e141dd983a550aaa075035748974811b73170cf7	2
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x0b5dba032bce476ac1e7af9f1f66c6e7823c5ea4	false	100000000	8	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	19599415	37681786351841747146672760	0x0b5dba032bce476ac1e7af9f1f66c6e7823c5ea4	2025-06-02T16:10:10.000Z	0x282053ac1e16fdc83761d86d3e8b4df210afa29d0268f2ac35ded6ec735d13dc	2
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x168fc6735f2d16955ceefe3c326b58f2b709ad4f	false	1000000000	4	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	19586028	35482706834088988203884453	0x168fc6735f2d16955ceefe3c326b58f2b709ad4f	2025-06-02T07:06:14.000Z	0x4c78091288dfd22a1224f93da0574e8919e38b4ebf507adbab772ff95e88f5ac	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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	in_interestRateMode
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0xa219439258ca9da29e9cc4ce5596924745e12b93	173703439901	0x6ef0aa9a0c1205f71aef394168ec5bb747d8a0e5	47	0	22947703	0x6ef0aa9a0c1205f71aef394168ec5bb747d8a0e5	2025-09-05T10:49:53.000Z	0x472af454e7e157993887a7e47e756caab6660a2c54495a73256c3954ec8d7bcd	2
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f	2526952373194783	0x8cea00e1480f3a2ef0934d2e7f9f65453e8dbbeb	49	1263476186597	16240372	0x8cea00e1480f3a2ef0934d2e7f9f65453e8dbbeb	2025-02-25T06:03:47.000Z	0x95f659c4eb2cef6441481fb073716f536f83496754ef4a85a798babd3994de39	0
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f	4284113879072390	0x8e595231305efc7ef256679ad95847cb255ef846	15	2142056939536	16240372	0x8e595231305efc7ef256679ad95847cb255ef846	2025-02-25T06:03:47.000Z	0x1efd455dfb7c5bf6019b02cd5de7c7bbf498be8c8c156462eb94830340a6c5aa	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0xc3ab85bc55e8aa0bc94a703f2c6d86afdf444e2e	false	15	19708430	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	0x17bbe7ee9e8ac27254f0f81466cfba37467dc5dc	2006860	2025-06-05T21:13:30.000Z	false	0x6f777b5b45f0573aa1f7c4266b1298b8ecc3f62a5928556d6d2259cfe3201098	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	871273523544941
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x24231797c2799ae1b0dd5651066017a7cb07d928	false	17	19707030	0xa219439258ca9da29e9cc4ce5596924745e12b93	0x3cc84cce1728c24761fa34712c644ddfa558f846	1339751925	2025-06-05T20:20:57.000Z	false	0x7f814e6979622fa8db0ed7869ea7f4b4b15363d797d44ab1853626cecc7b58dd	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	574920743599262795
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0xa2bdee643864bcccb8c4fded6e076229bc5bf7b0	false	112	17788380	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	0x17bbe7ee9e8ac27254f0f81466cfba37467dc5dc	60248811	2025-04-07T03:46:42.000Z	false	0xe3af6f9961af5c9467ea931610b57cfc5b159c43445d7a17e1ee6d17bcdc40ad	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	41567578546933332

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	14	0xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f	21410341	2025-07-29T06:04:17.000Z	2156732391379	0xa66c03ae735e5b918592a40592d16cdda8d571f126352a9d862db7605165bddb
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	5	0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4	21410341	2025-07-29T06:04:17.000Z	64	0xa66c03ae735e5b918592a40592d16cdda8d571f126352a9d862db7605165bddb
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	11	0xa219439258ca9da29e9cc4ce5596924745e12b93	21410341	2025-07-29T06:04:17.000Z	4360719	0xa66c03ae735e5b918592a40592d16cdda8d571f126352a9d862db7605165bddb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x11315cce8f009e4cb4234ffeaf2e860b84e5b0f6	false	50003474	26	0x11315cce8f009e4cb4234ffeaf2e860b84e5b0f6	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	22219894	false	2025-08-19T01:02:06.000Z	0xc9421d93af28d97d2948a55ebe1e66f257d2c8c6355f14a33582df09160361ff
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x140d50cb6cebfba0708c48e09aaf58287835771b	false	1000000	4	0x140d50cb6cebfba0708c48e09aaf58287835771b	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	22232462	false	2025-08-19T08:07:46.000Z	0x37399282abff7a4d3e496056211e69b8112936900f55afe4cbe29e170c68cdb3
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x148dc860fb69b10b1dddb80a5c82dbb1f1e55c08	false	6500017607	9	0x148dc860fb69b10b1dddb80a5c82dbb1f1e55c08	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	22246438	false	2025-08-19T15:58:56.000Z	0x266aed678b4e18d9516d72adb3edd5cb9efd336148477775386dc9db67fcf77d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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_variableBorrowRate	in_variableBorrowIndex
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	22794252	2025-09-01T19:12:20.000Z	41290591333604195527212299	0xa5b60ebc675f085c7780c7a473cf411517ae1610e9b0c76217b877b82db1bb87	1013179120249658697947440020	57562509626267772235334834	1022304674508938505326000865
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	22794708	2025-09-01T19:28:28.000Z	41836113427056372093630150	0x0616594971861a28de9c1f06e73d19dd7a1e3c2eb7df0ccb6c5061619b86a47c	1013180461708610120824165110	57941513431773554342355569	1022306520087852073070608610
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	false	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	22763774	2025-09-01T01:33:41.000Z	44308421296337245467268396	0xb1a43e3e7b5fb2f56ce70e207904f3afe48e8d65f2e1bf4e8713792a8fb133f9	1013088441518000340720248544	59628969928329761691728980	1022181761193116245942506352

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x8cb71cec028ccb62a88a89364884d1df5c0c5273	false	1636627255	4	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	15854702	0x8cb71cec028ccb62a88a89364884d1df5c0c5273	2025-02-15T13:50:22.000Z	0x61e315a8248323e23e0640581e6208e42031cce523d95bb6a29d31a74c6f48f9
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0xfe3ed0ecefc731ca3fc66eda6433897071b31029	false	304712177	5	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	15854743	0xfe3ed0ecefc731ca3fc66eda6433897071b31029	2025-02-15T13:51:47.000Z	0x519c11262c80b353ba19060423a1ebef3afe65ec7dff5a15e4039593d5f487a3
0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x8ae77380035a911cbb5e12feafd3a598b0818dfa	false	1749599274	5	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	15848933	0x8ae77380035a911cbb5e12feafd3a598b0818dfa	2025-02-15T10:25:30.000Z	0x08042b17c38b2ab3bf58b08cb78fb386bbc83de2ee1cdb4a95471a1f651ac647

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0xf13f99195325f2ef82cd6186a98a7195e68149c4	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0xf13f99195325f2ef82cd6186a98a7195e68149c4	false	500000000	4	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	20077981	2025-06-16T23:48:53.000Z	0xf669e9a3aa20f4156bab55fc88c8b32d9ced84f1a320ae57ee0c99d9d51b17a0
0x2a402a12723457ce8243a70b63f745c462bd11f9	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x2a402a12723457ce8243a70b63f745c462bd11f9	false	138000000	4	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	20077809	2025-06-16T23:37:36.000Z	0x53821c2fe3eb7aaaa57d2faa51a6d9c63e7cbb06972f72825f6b818fd4739e78
0x428430b51eb53d0dacbcedb1cebabf8a123f3e16	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	0x428430b51eb53d0dacbcedb1cebabf8a123f3e16	false	46107517	4	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	20049905	2025-06-16T03:15:07.000Z	0x478855479fc301eb1628b3bd17aa4841ea8fa15cb232441822af47331821f2e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
7250	0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x2416092f143378750bb29b79ed961ab195cceea5	17	22524490	2025-08-26T07:18:03.000Z	0x47073b02de40b80ce4289948837a5a1dd62c9cf24bbb714d1535e3abaeabcdc5	10750	7500
7200	0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x2416092f143378750bb29b79ed961ab195cceea5	129	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0	10750	7500
7250	0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x1bf74c010e6320bab11e2e5a532b5ac15e0b8aa6	133	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0	10750	7500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0xd2671165570f41bbb3b0097893300b6eb6101e6c	1000	21	22451742	2025-08-24T13:04:35.000Z	0x004c8eb3f6659e7bae696468f03d4c80b3fa5bdd7473e08a5f07886daa587f77
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4	1000	114	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0xa219439258ca9da29e9cc4ce5596924745e12b93	1000	122	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0xd2671165570f41bbb3b0097893300b6eb6101e6c	17	22451742	2025-08-24T13:04:35.000Z	0x004c8eb3f6659e7bae696468f03d4c80b3fa5bdd7473e08a5f07886daa587f77	4500
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0xa219439258ca9da29e9cc4ce5596924745e12b93	88	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0	1000
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x176211869ca2b568f2a7d4ee941e073a821ee1ff	82	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0xd2671165570f41bbb3b0097893300b6eb6101e6c	0xcdd80e6211fc767352b198f827200c7e93d7bb04	10	22451742	2025-08-24T13:04:35.000Z	0x004c8eb3f6659e7bae696468f03d4c80b3fa5bdd7473e08a5f07886daa587f77	0x0000000000000000000000000000000000000000	0xf3c806a402e4e9101373f76c05880eeac91bb5b9	0xb1532b76d054c9f9e61b25c4d91f69b4133e4671
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4	0x37f7e06359f98162615e016d0008023d910bb576	26	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0	0x0000000000000000000000000000000000000000	0x74a1b56f5137b00aa0ada1dd964a3a361ecc32e9	0xb1532b76d054c9f9e61b25c4d91f69b4133e4671
0x812e7c19421d9f41a6ddcf047d5cc2de2ca5bfa2	false	0x2416092f143378750bb29b79ed961ab195cceea5	0x935efcbefc1df0541afc3fe145134f8c9a0beb89	46	15692887	2025-02-11T11:56:26.000Z	0x654290a79d09d24038ba6639bd8e4739bf5f0ae62845d962923163716cd9f0a0	0x0000000000000000000000000000000000000000	0x1fe3452cef885724f8adf1382ee17d05d7e01cab	0xb1532b76d054c9f9e61b25c4d91f69b4133e4671

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x8c2d95fe7aeb57b86961f3abb296a54f0adb7f88	0x	false	0xd1b3e25fd7c8ae7caddc6f71b461b79cd4ddcfa3	4	15654649	execute()	0x	2025-02-10T12:51:13.000Z	1739191873	0xdd8e0e601e2869cb75d9ba6ee87a6644ae05455bae95d3015f4608c85ef0165a	true
0x8c2d95fe7aeb57b86961f3abb296a54f0adb7f88	0x	false	0x37d3c1eddbcaa4b2e74156d2c6ad3224027ee7a4	37	22451742	execute()	0x	2025-08-24T13:04:35.000Z	1756040675	0x004c8eb3f6659e7bae696468f03d4c80b3fa5bdd7473e08a5f07886daa587f77	true
0x8c2d95fe7aeb57b86961f3abb296a54f0adb7f88	0x	false	0xc0799cf19914081684f0203cc87fe5436d5d717f	70	21727801	execute()	0x	2025-08-07T10:25:27.000Z	1754562327	0x37fb8885d40e26b68fbc9e60361920669c6ece909326aa84f0532853fbe75734	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.ShortExecutor_ExecutedAction_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
0x0e7543a9da61b2e71fc880685ed2945b7426a689	0xbfa67701f5e0769654ed41b3ab6d8833550f0565	false	1011884310247912930536170745	7221946525	0x0000000000000000000000000000000000000000	1	22924622	2025-09-04T21:31:42.000Z	0x0055388f8c24e97fa4e361a3fbe74d360e288deba83bb30466ab35bdd24c73c9	1424
0x0e7543a9da61b2e71fc880685ed2945b7426a689	0x2e9cee479021ee903cd4e785b9218c33f17cb2de	false	1011881951268768990599006468	384608527189522661	0x0000000000000000000000000000000000000000	1	22922543	2025-09-04T20:17:49.000Z	0xf28dcb0bd99295e80990d3d6f74a1cd0bc38811e06ae15ad40e3f687e078a0cf	43971309245
0x0e7543a9da61b2e71fc880685ed2945b7426a689	0x2de2ee9153e603a5ca98d6fbfde23e00a44a4a12	false	1011858801482225349283242357	100000000000000000001	0x0000000000000000000000000000000000000000	1	22901000	2025-09-04T08:12:17.000Z	0x2e38f34a474739f5be09b3cc75e826f9cebce2da6e5625fc38ce004f31fd7f72	52049345321225

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
0x0e7543a9da61b2e71fc880685ed2945b7426a689	false	1000947453201003406757546454	10000000000000000	0x4758213271bfdc72224a7a8742dc865fc97756e1	22	16166838	0xb13f9d9e140b2b7c33d7376be60aced399237064	2025-02-23T09:02:59.000Z	0xbddd34b215e08a8911bd870c3ba54ed862fec8529e48dbeebb919a14af244ff1	0
0x0e7543a9da61b2e71fc880685ed2945b7426a689	false	1000961863285466129421815305	8005955315304596	0x4758213271bfdc72224a7a8742dc865fc97756e1	12	16175590	0x5874be02f497ecc13f9b8b818d3081cd42bb3ae7	2025-02-23T14:09:16.000Z	0x37c6cd1b53a307d425d6070ed8d397e4589f1ba366a53e40ae2837bffb9d6456	5955315304596
0x0e7543a9da61b2e71fc880685ed2945b7426a689	false	1000938557861101945829878578	640000000000000000	0x4758213271bfdc72224a7a8742dc865fc97756e1	6	16161326	0x4fed89fbf2455d65e1ef7efa774251b3423c4999	2025-02-23T05:54:24.000Z	0xf47a406ae5c3ee47eca76eb3ee34cc136a7298baf7d5193c79fd691809d2de4f	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_linea.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
816951	0x77e5b958186a3de3a0d2c9f6540b28a96fe03152	true	218267	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	5000000000000000	0x80500d20	0x31a239f3e39c5d8ba6b201ba81ed584492ae960f	21487603	0x77e5b958186a3de3a0d2c9f6540b28a96fe03152	2025-07-31T07:17:22.000Z	0x6e7b7d71bba6966ef092fe857681c9825958e313aaee9cf05055742e750665ea
816951	0xd24e5235bd47b31b3d820434d9bb52b461c24399	true	221067	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	13000000000000000	0x80500d20	0x31a239f3e39c5d8ba6b201ba81ed584492ae960f	21498451	0xd24e5235bd47b31b3d820434d9bb52b461c24399	2025-07-31T14:12:02.000Z	0x162b7061aebee98a4271592ea0b62f8c956be8c2697ecdf6705ca1798deae5de
415680	0xc4881bda287395fe37107b17426c156353f07170	true	221295	0xc47b8c00b0f69a36fa203ffeac0334874574a8ac	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x31a239f3e39c5d8ba6b201ba81ed584492ae960f	21486158	0xc4881bda287395fe37107b17426c156353f07170	2025-07-31T06:23:08.000Z	0x1ce89828d73d85dc1ee6e45ac817dc32b8ed2ca135f31dc1a773027ad2adb734

Example Query

Query with partition filter

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

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

​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

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function