aave_v3_plasma

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
0x4f7dd098060f64e698efde35d5e4eda655f65f07	0xc1a318493ff07a68fe438cee60a7ad0d0dba300e	0x473d3a2005499301dc353afa9d0c9c5980b5188c	false	1000000000000000000000000000	1900000000000000000000000	11	2013791	2025-09-27T03:16:13.000Z	0x516e207b250c7c71a505f4d9e01f26f0a12773aa4022a9c203072bc2e2ddc41d
0x4f7dd098060f64e698efde35d5e4eda655f65f07	0xc1a318493ff07a68fe438cee60a7ad0d0dba300e	0x473d3a2005499301dc353afa9d0c9c5980b5188c	false	1000000000000000000000000000	2250000000000000000000000	1	2014171	2025-09-27T03:22:33.000Z	0x191f945adbea961c1f9c52b3a481b505b5bc785e2b2a2bb42432b6903af25833
0x4f7dd098060f64e698efde35d5e4eda655f65f07	0xc1a318493ff07a68fe438cee60a7ad0d0dba300e	0x473d3a2005499301dc353afa9d0c9c5980b5188c	false	1000000000000000000000000000	2200000000000000000000000	6	2014347	2025-09-27T03:25:29.000Z	0x7f598356a9f41236d4592f486ccb603b5f380c12b5141392895b8e1ac97c62c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	0x0000000002c0fd34c64a4813d6568abf13b0adda	false	1000004048023620164775744321	19999987078	0x0000000002c0fd34c64a4813d6568abf13b0adda	7	1881467	2025-09-25T14:29:04.000Z	0x8a1ac8a97a331ec2b2490c2f25192f4add978737d78c14bfe801ec263fe50496	12922
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	0x0001094b9d760df1407279e84c2308a92c85a710	false	1000036582452213407438848891	68553447562	0x0001094b9d760df1407279e84c2308a92c85a710	13	1912686	2025-09-25T23:09:23.000Z	0x40702c4195a1b18e9bd374e671523f898b74a12636ba1d318224dc20a525e4ab	25643
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	0x000f9764a2c9345df184d19a2cb935a0857af000	false	1000025260591133857478511188	14850989998	0x000f9764a2c9345df184d19a2cb935a0857af000	7	1902510	2025-09-25T20:19:47.000Z	0x7a9a1860e10da0106df98615a155b0f4055a10864c8b42b791661991c23c6e18	78833

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x5c43d6c075c7cf95fb188fb2977eed3e3f2a92c2	0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x	21	0x5e2d083417d12d4b0824e14ecd48d26831f4da7d	1701201	Aave Plasma XAUt0	2025-09-23T12:21:01.000Z	aPlaXAUt0	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	6	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	0x3a57eaa3ca3794d66977326af7991eb3f6dd5a5a
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x	6	0x5e2d083417d12d4b0824e14ecd48d26831f4da7d	1701201	Aave Plasma USDT0	2025-09-23T12:21:01.000Z	aPlaUSDT0	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	6	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	0x3a57eaa3ca3794d66977326af7991eb3f6dd5a5a
0xc1a318493ff07a68fe438cee60a7ad0d0dba300e	0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x	16	0x5e2d083417d12d4b0824e14ecd48d26831f4da7d	1701201	Aave Plasma sUSDe	2025-09-23T12:21:01.000Z	aPlasUSDe	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	18	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	0x3a57eaa3ca3794d66977326af7991eb3f6dd5a5a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	false	1000794721949599682585398860	56345	0x2460a05cc7c9e0f1e20b9b98c6f54acaad221b98	61	2767211	0x2c17ad2b21d02a1a6ede600b7d7eb2e78148c12d	2025-10-05T20:33:13.000Z	0xc5be115157a4688221df5bdf11ef3a9307994609bffc2a6ba8a536d187cfe81a	56345
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	false	1000794721949599682585398860	117594	0x2460a05cc7c9e0f1e20b9b98c6f54acaad221b98	59	2767211	0x2460a05cc7c9e0f1e20b9b98c6f54acaad221b98	2025-10-05T20:33:13.000Z	0xc5be115157a4688221df5bdf11ef3a9307994609bffc2a6ba8a536d187cfe81a	117594
0x5d72a9d9a9510cd8cbdba12ac62593a58930a948	false	1000774365405703787607191837	379975	0x2460a05cc7c9e0f1e20b9b98c6f54acaad221b98	48	2748184	0x2460a05cc7c9e0f1e20b9b98c6f54acaad221b98	2025-10-05T15:16:06.000Z	0xe7a0171f133bb230c27834a9b187295a2a8ae5ee2c8007c23e19ab8d1db1543b	379975

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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_plasma.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
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x04171c2692e2ee2d80d3d79a07763fcb1b6f9237	false	371741891887822500000000	5	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	2410409	28128296822141716687964389	0x04171c2692e2ee2d80d3d79a07763fcb1b6f9237	2025-10-01T17:26:31.000Z	0xd87d93279bf892b5add173ffcab49abf741f7a1647a4a3914113b37298cc54ad	2
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x1c1e747a6be850549e9655addf59fd9e7cc2d4dc	false	100000000000000000000000	8	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	2355295	27977843083592463511340344	0x1c1e747a6be850549e9655addf59fd9e7cc2d4dc	2025-10-01T02:07:57.000Z	0x86a17c5e0598dfa4fff59ebdd040465550cd2e3a315c50c4b6bbd4108310e60e	2
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	false	15000000000000000000000	4	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	2385062	27968559317359791953398064	0x1d1714a49483f4b2b71f468cf471e13eedcf760a	2025-10-01T10:24:04.000Z	0x20758135444dea6fce8d64156626c601c3645668b891c748527d4485f3d7d109	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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	in_referralCode	transaction_hash
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	3021463342705627	0x352423e2fa5d5c99343d371c9e3bc56c87723cc7	28	1510731671353	3172884	0x352423e2fa5d5c99343d371c9e3bc56c87723cc7	2025-10-10T13:18:10.000Z	3228	0x0f9f25ec1356fd1d69b12152165fc7b3805e8c042a79cc5956af22902b3c6a07
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	15144744396189117710	0x352423e2fa5d5c99343d371c9e3bc56c87723cc7	33	7572372198094559	3180368	0x352423e2fa5d5c99343d371c9e3bc56c87723cc7	2025-10-10T15:22:54.000Z	3228	0x0e2a3908f243fc33a0b839a6f61ace536a50546861109d9dfd27431091012ad1
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	2885584542306476611	0x352423e2fa5d5c99343d371c9e3bc56c87723cc7	33	1442792271153239	3180258	0x352423e2fa5d5c99343d371c9e3bc56c87723cc7	2025-10-10T15:21:04.000Z	3228	0x82d6192cad7cee1f6b48fde6fdf2cf7df457fa146a2e74dc4682c2a9e8a7b20b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x832fdd7d994ebac6fd3c3e99046d7da59a302973	false	112	3201645	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	0x63348739e87142f1c7178be13b1d6f2da0644852	6004923322981118119208	2025-10-10T21:17:31.000Z	false	0x0be5c24e9f7b5800179c004cd17070b1dbbffe89ef94f96595e30b160f038d50	0x9895d81bb462a195b4922ed7de0e3acd007c32cb	1749486192043282840
0x925a2a7214ed92428b5b1b090f80b25700095e12	0xe95b9c8f7087c70e5db8c74756c1da6708c48e42	false	62	3200203	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	0x63348739e87142f1c7178be13b1d6f2da0644852	140302598583918912848	2025-10-10T20:53:29.000Z	false	0xf68ed8932fb6755d626bfe4f0366687566e890698a64f55566e86d4e5b9fd69c	0x9895d81bb462a195b4922ed7de0e3acd007c32cb	37527232530939128
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x26c9219b725be0c7823aa523190f7037bcd217e1	false	58	3201583	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	0x63348739e87142f1c7178be13b1d6f2da0644852	534871246480	2025-10-10T21:16:29.000Z	false	0xaf317fb6e93527a8ba748ed8e792b63494488ff6855db6fa2373121d218b9e17	0x9895d81bb462a195b4922ed7de0e3acd007c32cb	153207906816815807476

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	86	0x9895d81bb462a195b4922ed7de0e3acd007c32cb	3233261	2025-10-11T06:04:27.000Z	1786381626221784292	0xc41091c3f747f06475b430834d4c4e0726b505ad3569fd3d7b0f498dc63325f0
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	83	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	3233261	2025-10-11T06:04:27.000Z	3723847775355128064093	0xc41091c3f747f06475b430834d4c4e0726b505ad3569fd3d7b0f498dc63325f0
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	80	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	3233261	2025-10-11T06:04:27.000Z	34977020980	0xc41091c3f747f06475b430834d4c4e0726b505ad3569fd3d7b0f498dc63325f0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x0a776abbaae0e2161d0e131f57e605efbea4b99b	false	257575539733549319101178	4	0x0a776abbaae0e2161d0e131f57e605efbea4b99b	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	3592881	false	2025-10-15T09:58:07.000Z	0x56a45cfa42318bd67f7f4675a1166ede138b81f4ca8bce461ece93b3d81faac7
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x0a776abbaae0e2161d0e131f57e605efbea4b99b	false	216719419986450669158567	4	0x0a776abbaae0e2161d0e131f57e605efbea4b99b	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	3589444	false	2025-10-15T09:00:50.000Z	0x9a601b8b620557b1110f33c839f689e971f97f2364920ae4a01a7c6e76f1c31a
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x242cef6ad93979a54a275636eab111c97003f805	false	73013771316309454392887	4	0x242cef6ad93979a54a275636eab111c97003f805	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	3585069	false	2025-10-15T07:47:55.000Z	0x76254837694f4a3628299edb17473f4580fc5cb8a336e00a56782aba7ac83575

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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	transaction_hash	in_liquidityIndex	in_variableBorrowIndex
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	2813720	2025-10-06T09:28:22.000Z	0x4f642cc065a2abd2b5e20df1d765523c55e980e130f65f33fbe5b796b54813a7	1000000000000000000000000000	1000000000000000000000000000
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	2795719	2025-10-06T04:28:21.000Z	0x21da0ebdf6afa5693f17267c7d28e603b225b1ee7cc647e9e06cf60e74153332	1000000000000000000000000000	1000000000000000000000000000
0x925a2a7214ed92428b5b1b090f80b25700095e12	false	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	2829297	2025-10-06T13:47:59.000Z	0x92fda8e6458312b4db9f8bf9a0cd88747c944c576ac1c8ed4be8ebcf1847d7d6	1000000000000000000000000000	1000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x09006946e70bb95fea200e635755d979f12f76ff	false	12882786672	72	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	2434674	0x09006946e70bb95fea200e635755d979f12f76ff	2025-10-02T00:10:56.000Z	0xc0d8f061702348985ebdc6361ddd2348db198fff41fbc88c43f373d4d93ab59a
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x195458b682791666037d9c146bc4d6106d06bc8b	false	350000000000000000000	58	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	2463396	0x195458b682791666037d9c146bc4d6106d06bc8b	2025-10-02T08:09:38.000Z	0x797a639d8ea3140490f276e87a47ecd6504916e0268fe8b58f5b86618feb7c04
0x925a2a7214ed92428b5b1b090f80b25700095e12	0x1eb0187a62cb7c57632f33dd73d0e3a62112ab03	false	1000000000000000000	79	0x9895d81bb462a195b4922ed7de0e3acd007c32cb	2440172	0x1eb0187a62cb7c57632f33dd73d0e3a62112ab03	2025-10-02T01:42:34.000Z	0x835153e45d4f82ac5fb7256e6378a70c67437d7769063c080eefab582383dc09

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x001c002a206f39ae24f872c30280c40c6080900e	0x925a2a7214ed92428b5b1b090f80b25700095e12	0x001c002a206f39ae24f872c30280c40c6080900e	false	19004750253	24	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	3090047	2025-10-09T14:13:56.000Z	0xa57664d840d86b61d5d51d68af5ceb5dbcd2b50250fd468237a2d5fdc57def81
0x001c002a206f39ae24f872c30280c40c6080900e	0x925a2a7214ed92428b5b1b090f80b25700095e12	0x001c002a206f39ae24f872c30280c40c6080900e	false	19004680317	45	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	3084951	2025-10-09T12:49:00.000Z	0x0f235bb9b78d80bdc114d126a0a58e30675d051f6a92e98e16a382d75ff15a61
0x01c2f22754e1c2cc64a18ba6162e5c7d417fff7f	0x925a2a7214ed92428b5b1b090f80b25700095e12	0x01c2f22754e1c2cc64a18ba6162e5c7d417fff7f	false	106000000000	4	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	3079102	2025-10-09T11:11:31.000Z	0xb7c74b77bb51762839bc70e70761fbbd39bd864486450e4f02ed4c1d7a84abf5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
5	0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	92	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	10850	10
5	0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0xa3d68b74bf0528fdd07263c60d6488749044914b	99	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	10700	10
7200	0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	88	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	10850	7500

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

Aave V3 LendingPoolConfigurator event emitted when the protocol’s share of flash loan fees is updated, recording both old and new premium values in basis points. Used for tracking protocol fee parameter changes and governance decisions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldFlashloanPremiumToProtocol`	`STRING`	Previous flashloan premium allocated to the protocol treasury before the update. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.
`in_newFlashloanPremiumToProtocol`	`STRING`	Updated flashloan premium allocated to the protocol treasury. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

Aave V3 protocol configuration event tracking changes to flash loan premium rates. Contains old and new premium values in basis points for protocol fee analysis and governance monitoring.

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_oldFlashloanPremiumTotal`	`STRING`	Previous total flash loan premium fee rate expressed in basis points.
`in_newFlashloanPremiumTotal`	`STRING`	Updated total flash loan premium fee rate expressed in basis points.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumTotal	in_oldFlashloanPremiumTotal
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	27	489197	2025-09-09T11:31:02.000Z	0x5231f0f8b1a95f31bbe51a3216e3a6ce36ee0fcaefa2e27a468af7884567d408	5	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.LendingPoolConfigurator_FlashloanPremiumTotalUpdated_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
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	1000	97	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0xa3d68b74bf0528fdd07263c60d6488749044914b	1000	100	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	1000	89	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	51	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	1000
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x9895d81bb462a195b4922ed7de0e3acd007c32cb	81	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	1500
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	69	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	2000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0xa3d68b74bf0528fdd07263c60d6488749044914b	0xaf1a7a488c8348b41d5860c04162af7d3d38a996	29	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	0x0000000000000000000000000000000000000000	0x34542b95efdf2dfbd59978c2f620fbd7275e9323	0x2b16e93bdb1897f517881b3c388babd0c62c6cdc
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	0x5c43d6c075c7cf95fb188fb2977eed3e3f2a92c2	24	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	0x0000000000000000000000000000000000000000	0x20091c402c2933144bd9a9b1b07dbebf19c6d5a1	0x2b16e93bdb1897f517881b3c388babd0c62c6cdc
0xc022b6c71c30a8ad52dac504efa132d13d99d2d9	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	0x7519403e12111ff6b710877fcd821d0c12caf43a	14	1701201	2025-09-23T12:21:01.000Z	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	0x0000000000000000000000000000000000000000	0xea650893085dad858150915291645f57164a4257	0x2b16e93bdb1897f517881b3c388babd0c62c6cdc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0x47aadaae1f05c978e6abb7568d11b7f6e0fc4d6a	0x	false	0x0bf84870529c17ea618c9e877cfb8379b36ad659	23	3599228	execute()	0x	2025-10-15T11:43:54.000Z	1760528634	0xfcfd746ef266c797536ff04c715285d2f7c4296c0d9bf767eecce1c8cde48ee1	true
0x47aadaae1f05c978e6abb7568d11b7f6e0fc4d6a	0x	false	0xdd98dd03aa59a63f2a1997bc9f2183af94bd50df	178	1701201	execute()	0x	2025-09-23T12:21:01.000Z	1758630061	0x6ecc2bf6e7952a1d2b10378fbe11e71f87c25b507f39004b0d21e475d48ea8ae	true
0x47aadaae1f05c978e6abb7568d11b7f6e0fc4d6a	0x	false	0x5412bf87245e0a8e1d06904b5d909ff71baaf799	74	4042028	execute()	0x	2025-10-20T14:43:54.000Z	1760971434	0x5788fd021cab495d8ea467516339c544f56d0865182bd6d4455da94dc3cb4cce	true

Example Query

Query with partition filter

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

StataToken_Deposit_event

Deposit events emitted by Aave V3 StataToken contracts recording asset conversions to yield-bearing shares. Contains sender address, asset owner, deposited asset amount, and received share amount for tracking StataToken minting 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xe0126f0c4451b2b917064a93040fd4770d6774b5	false	0x2102ab11a3c74b1d543891020969dc3d46c132ab	168421	0x2102ab11a3c74b1d543891020969dc3d46c132ab	168089	56	4060433	2025-10-20T19:50:39.000Z	0x96a419686cb0117157a866c59f190beb8b146f7fc3d93862a34c0fb6306b3fa1
0xc63f1a8c0cd4493e18f6f3371182be01ce0bef02	false	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	17104248038304657408	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	17102013319462625990	9	4060819	2025-10-20T19:57:05.000Z	0x67de5617462883316a9f8f15836d484d15fbe4ef62fc6325b7313e897ca78143
0xe0126f0c4451b2b917064a93040fd4770d6774b5	false	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	16503394	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	16471489	11	4017114	2025-10-20T07:48:40.000Z	0x9beca05928d36e08a541276938ffdb1d9c7b656404be0d107beb46a70570e49f

Example Query

Query with partition filter

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

StataToken_Initialized_event

Aave V3 Static A Token (StataToken) initialization events emitted when a new StataToken contract is deployed and initialized with its version parameter. Captures the deployment of yield-bearing wrapped aToken contracts that accrue interest through rebasing mechanisms.

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_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0xe0126f0c4451b2b917064a93040fd4770d6774b5	false	2	1	1701857	2025-09-23T12:31:57.000Z	0x7c9698a6e2e018e1e856e07fe6fd26de6cc5005f6508609436dd949f91555136
0x8aa32f47f375a4a1fc803e24f9ae42c57469c35f	false	23	1	1701857	2025-09-23T12:31:57.000Z	0x7c9698a6e2e018e1e856e07fe6fd26de6cc5005f6508609436dd949f91555136
0xc63f1a8c0cd4493e18f6f3371182be01ce0bef02	false	9	1	1701857	2025-09-23T12:31:57.000Z	0x7c9698a6e2e018e1e856e07fe6fd26de6cc5005f6508609436dd949f91555136

Example Query

Query with partition filter

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

StataToken_Withdraw_event

Aave V3 static aToken (StataToken) withdrawal events recording conversions from yield-bearing shares back to underlying assets. Contains sender, owner, receiver addresses, asset amounts withdrawn, and corresponding share quantities burned in the protocol’s vault accounting system.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xe0126f0c4451b2b917064a93040fd4770d6774b5	false	0x2102ab11a3c74b1d543891020969dc3d46c132ab	160548	0x2102ab11a3c74b1d543891020969dc3d46c132ab	160260	34	0x2102ab11a3c74b1d543891020969dc3d46c132ab	3849719	2025-10-18T09:18:45.000Z	0x37be8d4659eeb4ad065cf9a74b2e8ce10377ebc0338a396eef2a6cabc332c43d
0xe0126f0c4451b2b917064a93040fd4770d6774b5	false	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	2549417	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	2544887	8	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	3821262	2025-10-18T01:24:28.000Z	0x1d403ec2541563f56c8651cbe63b1313d89de7f44bc7de08c6cb00b54a4823ca
0xe0126f0c4451b2b917064a93040fd4770d6774b5	false	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	21277296	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	21238706	8	0x4c1cde610903c93a4f034b4d6133f2dc8279264f	3867907	2025-10-18T14:21:53.000Z	0x6c41a655ca85565627652c1fef86307a16fd6510a30af3ff196540b110e22682

Example Query

Query with partition filter

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

StataTokenFactory_StataTokenCreated_event

Event log emitted when Aave V3’s StataTokenFactory contract creates a new static aToken (stata token) wrapper for an underlying asset. Links the newly deployed stata token address with its corresponding underlying asset address for tracking tokenized yield-bearing positions.

Columns

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

Sample Data

address	removed	log_index	block_number	in_stataToken	in_underlying	block_timestamp	transaction_hash
0xbcb77d9d638abecb6bb910c1d8a4c24b0dd165a2	false	27	1701857	0x8aa32f47f375a4a1fc803e24f9ae42c57469c35f	0x1b64b9025eebb9a6239575df9ea4b9ac46d4d193	2025-09-23T12:31:57.000Z	0x7c9698a6e2e018e1e856e07fe6fd26de6cc5005f6508609436dd949f91555136
0xbcb77d9d638abecb6bb910c1d8a4c24b0dd165a2	false	6	1701857	0xe0126f0c4451b2b917064a93040fd4770d6774b5	0xb8ce59fc3717ada4c02eadf9682a9e934f625ebb	2025-09-23T12:31:57.000Z	0x7c9698a6e2e018e1e856e07fe6fd26de6cc5005f6508609436dd949f91555136
0xbcb77d9d638abecb6bb910c1d8a4c24b0dd165a2	false	20	1701857	0xa31c7ddad8f1d66d037c4ee76f8fb725f927bc25	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	2025-09-23T12:31:57.000Z	0x7c9698a6e2e018e1e856e07fe6fd26de6cc5005f6508609436dd949f91555136

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.StataTokenFactory_StataTokenCreated_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_plasma.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_plasma.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
0xcbbc427b5658672768e11bfda00879839db4785f	0x0e42d7887e4dfd681fe295bec85729c0420e0ae0	false	1001391404660195934898457299	6430004878	0x0000000000000000000000000000000000000000	1	2695555	2025-10-05T00:38:57.000Z	0xf8b2179c8524f13b20a8a8a1bb484e6a39deb76cd8484efef9c4a6b4cdbb8057	7355075
0xcbbc427b5658672768e11bfda00879839db4785f	0x11126b9f7e61f13c5926364f01b1e17490388860	false	1001465264770162488662273058	43034297	0x0000000000000000000000000000000000000000	1	2738119	2025-10-05T12:28:21.000Z	0x5cd59655e3758ca23e2a6b9447030e8cbd3b784a6d962445614294e2ed0eed8d	96996
0xcbbc427b5658672768e11bfda00879839db4785f	0x11126b9f7e61f13c5926364f01b1e17490388860	false	1001465374174919253439685092	72317918	0x0000000000000000000000000000000000000000	1	2738182	2025-10-05T12:29:24.000Z	0x7a3b535203b06da83daab87642bd5758aecea7c74633a75fe14f60a9beaf9d49	6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
0xcbbc427b5658672768e11bfda00879839db4785f	false	1000000000000000000000000000	10000000	0xf0bb20865277abd641a307ece5ee04e79073416c	16	1794221	0xf0bb20865277abd641a307ece5ee04e79073416c	2025-09-24T14:14:58.000Z	0xde0e2938ca47feaace76731a9b96dce11b9078d7db9b6104797c030f5fd31b2c	0
0x638d7db63cd5c902bdd9a91cf195870551c3c7b3	false	1000170954872299993478217074	2849247511092371748	0x19d51e9b2f4ac7df4a114c0eeea01f4f4ab5f585	4	3124776	0x19d51e9b2f4ac7df4a114c0eeea01f4f4ab5f585	2025-10-09T23:55:40.000Z	0xc69bf4a46423895af22c31305bb4db9c2e419fe871235fbf6d36986bab775fe1	13040629366745
0x638d7db63cd5c902bdd9a91cf195870551c3c7b3	false	1000167867481033287046795151	328613355221461816799	0x19d51e9b2f4ac7df4a114c0eeea01f4f4ab5f585	1	3117282	0x19d51e9b2f4ac7df4a114c0eeea01f4f4ab5f585	2025-10-09T21:47:51.000Z	0x659f45648cb452426c2fd824c0e50ab36d91472c7e5ba3a619fc29db006b38c7	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_plasma.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
793416	0x2fec9e2b7198dafcaa07c9faaccd02f87d9572f3	true	209452	0x925a2a7214ed92428b5b1b090f80b25700095e12	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x54bdcc37c4143f944a3ee51c892a6cbdf305e7a0	6037575	0x2fec9e2b7198dafcaa07c9faaccd02f87d9572f3	2025-11-12T17:21:18.000Z	0x6fbb7e21e00380cfb1f0e6b13330ff3e5d5733a5992511d56cca931a570d0026
343813	0x984514bf1fabdc329f5d5e0501d55b7b78f9c64d	true	209452	0x925a2a7214ed92428b5b1b090f80b25700095e12	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x54bdcc37c4143f944a3ee51c892a6cbdf305e7a0	6046218	0x984514bf1fabdc329f5d5e0501d55b7b78f9c64d	2025-11-12T19:45:21.000Z	0x6772a6649a5c3dec44fc41b6ae41ad2fc688f4cae27329576139d392154991e2
343813	0xe2dcfd6d4acba5d81a937cd4dc8d57fd2e173196	true	209452	0x925a2a7214ed92428b5b1b090f80b25700095e12	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x54bdcc37c4143f944a3ee51c892a6cbdf305e7a0	6056887	0xe2dcfd6d4acba5d81a937cd4dc8d57fd2e173196	2025-11-12T22:43:10.000Z	0xac02c957b434f9eb5dd57fa3ff739a5d4a37ca032946b93f3e3ec20587513c73

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_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_FlashloanPremiumToProtocolUpdated_event

​LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​ShortExecutor_ExecutedAction_event

​StataToken_Deposit_event

​StataToken_Initialized_event

​StataToken_Withdraw_event

​StataTokenFactory_StataTokenCreated_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_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function