aave_v3_ethereum

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
0x0b23462e76b51c925a11ecdf3a28cd26568a6a87	0xa700b4eb416be35b2911fd5dee80678ff64ff6c9	0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	1000000000000000000000000000	3324903091682057588	74	23385002	2025-09-17T19:51:11.000Z	0xf31159e08706c8a0d1b12ce3f30e97023a20fa6ee2b7d07a564b9e27cc577ec1
0x1db08ee2e01064212f472d91526be504570fde85	0xa700b4eb416be35b2911fd5dee80678ff64ff6c9	0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	1000000000000000000000000000	326151039902180322	668	23385434	2025-09-17T21:17:47.000Z	0xbd283d3fcb57e281d3d9311c7e901244ff332f61b050ed5b6418e2c76336a1c0
0x50dd9ba784f9e3658f7bade66c2a9e19ad3dde36	0xa700b4eb416be35b2911fd5dee80678ff64ff6c9	0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	1000000000000000000000000000	1127006657867934666	284	23385045	2025-09-17T19:59:47.000Z	0xf52488f108a47cfed1239cbeaa2436503e9db02c985bae6703fc775a0f845b47

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0xb82fa9f31612989525992fcfbb09ab22eff5c85a	0x037ed7cb8006afb17f764fde9b8bcdcef734dc62	false	1145819578939292612055487937	57767222387990192088	0x037ed7cb8006afb17f764fde9b8bcdcef734dc62	461	22255138	2025-04-12T20:01:59.000Z	0xb158422a0c38f442e6075f8da0e486702be1ab9bddabb3036faa3a0e399053a7	609814259303564622
0x65906988adee75306021c417a1a3458040239602	0x1a6f6b9313a6314d071e502c65a2eba14e58f3b1	false	1000002056679413523066764457	800000000	0x1a6f6b9313a6314d071e502c65a2eba14e58f3b1	96	22249791	2025-04-12T02:09:23.000Z	0x5a4813a62421ff8ffe05a03085934d124654d69ce55233e15fe6ef26fbd64e4f	0
0xf6d2224916ddfbbab6e6bd0d1b7034f4ae0cab18	0x1b8eabf8bff8bdcde721cde33067739d312dd0c9	false	1001932701539485372556396990	4868494308868665220072	0x1b8eabf8bff8bdcde721cde33067739d312dd0c9	430	22253454	2025-04-12T14:23:11.000Z	0xe3edeee6eed4ba3544f27522d55eeed0f831daf92241f63bf45c20f1330a5646	475483232667424

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x7380c583cde4409eff5dd3320d93a45d96b80e2e	0x0aa97c284e98396202b6a04024f5e2c65026f3c0	false	0x	549	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	23088584	Aave Ethereum EtherFi USDC	2025-08-07T10:27:23.000Z	aEthEtherFiUSDC	0xa17567fa201a78b66c43e6ab178559f8c1d5d308fe944c0bd2c39b5e585097dc	6	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x8164cc65827dcfe994ab23944cbc90e0aa80bfcb
0xdf7f48892244c6106ea784609f7de10ab36f9c7e	0x0aa97c284e98396202b6a04024f5e2c65026f3c0	false	0x	555	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	23088584	Aave Ethereum EtherFi PYUSD	2025-08-07T10:27:23.000Z	aEthEtherFiPYUSD	0xa17567fa201a78b66c43e6ab178559f8c1d5d308fe944c0bd2c39b5e585097dc	6	0x6c3ea9036406852006290770bedfcaba0e23a0e8	0x8164cc65827dcfe994ab23944cbc90e0aa80bfcb
0x6914eccf50837dc61b43ee478a9bd9b439648956	0x0aa97c284e98396202b6a04024f5e2c65026f3c0	false	0x	561	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	23088584	Aave Ethereum EtherFi FRAX	2025-08-07T10:27:23.000Z	aEthEtherFiFRAX	0xa17567fa201a78b66c43e6ab178559f8c1d5d308fe944c0bd2c39b5e585097dc	18	0x853d955acef822db058eb8505911ed77f175b99e	0x8164cc65827dcfe994ab23944cbc90e0aa80bfcb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0xa700b4eb416be35b2911fd5dee80678ff64ff6c9	false	1000000000000000000000000000	71842615302264571014	0xece792e16f847add756d2c421801ff82999d2333	449	22299002	0xece792e16f847add756d2c421801ff82999d2333	2025-04-18T22:54:59.000Z	0x63175306c713583edcca34511d83034e6f977ddc6585ff3e6b21b9622e54a815
0xa700b4eb416be35b2911fd5dee80678ff64ff6c9	false	1000000000000000000000000000	51274277106739491233	0xece792e16f847add756d2c421801ff82999d2333	407	22295466	0xece792e16f847add756d2c421801ff82999d2333	2025-04-18T11:04:35.000Z	0xdc72db428a295e473ffe075b5e514e698746c9a3d8972137deed6cf848c961f3
0xa700b4eb416be35b2911fd5dee80678ff64ff6c9	false	1000000000000000000000000000	225876406801749098	0x70c0a3302f767418af2b178c184ec32490edebb9	104	22296098	0x70c0a3302f767418af2b178c184ec32490edebb9	2025-04-18T13:11:23.000Z	0x2833c7dd82db15fe73147774816f91a8b24d8bb0ccce298b3b0a7a0a961c7ad8

Example Query

Query with partition filter

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

LendingPool_Borrow_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x8f2ac88bd3080b470648d2205142c37fa16dfe58	false	1000000000000000000000	521	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	21241589	2101974736323065043773280	0x8f2ac88bd3080b470648d2205142c37fa16dfe58	2024-11-22T06:49:59.000Z	0x10fbf44b287e6452711854c7ffb83cc1e7393a3c235ea2d64f9b7ed204526d14	2
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0xe7e61486cf7ecb8f87e60581810649faf84cbe59	false	54000000000000000000	72	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	21244274	2104002939508064935448251	0xe7e61486cf7ecb8f87e60581810649faf84cbe59	2024-11-22T15:49:47.000Z	0xb933bcb79f09bc288a36c5fb5a431b9e2ba43635191d64e114a02ee6788666d8	2
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x02bb4f741ab052b02d43dbcece16ed792d5dd102	false	2200000	97	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21246315	6972712649072478233805267	0x02bb4f741ab052b02d43dbcece16ed792d5dd102	2024-11-22T22:40:35.000Z	0xc711cff6e59ee3a0401840390bdfb80db0dedb999343e2f9819b47a20dbb024b	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	0x5f98805a4e8be255a32880fdec7f6728c6568ba0	99384688772224840000000	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	108	49692344386112420000	18733728	0xf1f304def83d6cf4680a81c49cac184a8119a538	2023-12-07T10:09:59.000Z	0xadd2346211eb9cfd01ebfe4a9064831109c56490ccab93db4792006e67d8fcfb
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	9688934758902164000	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	380	4844467379451082	18731931	0xb6c02ea3555b053f822d673436783863b87e2709	2023-12-07T04:07:35.000Z	0x5ee295b439882f47ae9b96cb592bca6b37dcdcec56ead816c428530e9d6dd620
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	0x6b175474e89094c44da98b954eedeac495271d0f	204810300427774450000	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	366	102405150213887225	18736770	0x99fe0a7cd4e33ff816f1d2ad0063f760e06adc5d	2023-12-07T20:24:23.000Z	0x3baf0f6bc6665b1c2eaa182efc1ad300cb34b2a10749a0df7f236cb90b6cf6d7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x7635798778c3d8ea9a2fc7f28f5fa300fb2f61e1	false	32	20049543	0xdac17f958d2ee523a2206206994597c13d831ec7	0xb4b50bfa4c4c90dd25a4cbe695f8124d24ac6474	298740441	2024-06-08T20:37:35.000Z	false	0xab8627dd21314d313227708f55d6828a8055e16586197f28f39187bde96f8470	0xc18360217d8f7ab5e7c516566761ea12ce7f9d72	14851487847121828783
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x2c321c6ae722a80a577c5cea51afd9199bfcdaa4	false	65	20415648	0xdac17f958d2ee523a2206206994597c13d831ec7	0x6fb323bc0a1c0e5991bfc2088b02b6185d8d4232	193014656	2024-07-29T23:55:47.000Z	false	0xf317e7bca2d968de57108b2f082a25398ad99848967a56c39027fd681893fcb2	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	60783658770821431
0x0aa97c284e98396202b6a04024f5e2c65026f3c0	0xb4a648cb2fb6bd4f762b21ea5cb1b0c5172fb6a7	false	374	21762793	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xa7bc4d21680ab2d088614951b20c9195e8d23470	2888775958	2025-02-03T01:46:35.000Z	false	0x39d7144c6d050da69222e6b1fe3a6bc9abb822d7eb6c95a78cebce10184101c0	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	1058940892963084916

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	483	0xbe9895146f7af43049ca1c1ae358b0541ea49704	16694468	2023-02-23T23:50:47.000Z	1554556101859	0xee195084fb17148f54fb7654c0b420c075b047423d79f855e2dfe7d224e05e29
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	474	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	16694468	2023-02-23T23:50:47.000Z	1838156903	0xee195084fb17148f54fb7654c0b420c075b047423d79f855e2dfe7d224e05e29
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	486	0xdac17f958d2ee523a2206206994597c13d831ec7	16694468	2023-02-23T23:50:47.000Z	14829151	0xee195084fb17148f54fb7654c0b420c075b047423d79f855e2dfe7d224e05e29

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x06b8a93aea2a5a1199c3a5c9dd76382c59557a3b	false	251867797	534	0x06b8a93aea2a5a1199c3a5c9dd76382c59557a3b	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	17998267	false	2023-08-26T10:32:59.000Z	0x740d112aa653fad42ea49ebb68618a05dd8b96853f892739e39db888a6249945
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x06b8a93aea2a5a1199c3a5c9dd76382c59557a3b	false	400000000	182	0x06b8a93aea2a5a1199c3a5c9dd76382c59557a3b	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	17998168	false	2023-08-26T10:12:59.000Z	0x3ec8346fb13642ffbec647f83575ce69d3846ba95874e6b3640c83b12a77f92e
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x474dad210217f4c52d1bd23977c9b412999c33ae	false	90000000	184	0x474dad210217f4c52d1bd23977c9b412999c33ae	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	17999197	false	2023-08-26T13:40:11.000Z	0x759809828df93668aa08552e7f7e4730eed482e193e514510e02edd05ecf1eb2

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

Aave V2/V3 protocol events emitted when lending pool reserve parameters are updated, including liquidity and borrow indices, interest rates for stable and variable borrowing. Used for tracking interest accrual and reserve state changes across lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityRate`	`STRING`	Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers.
`in_stableBorrowRate`	`STRING`	Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan.
`in_variableBorrowRate`	`STRING`	Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan.
`in_liquidityIndex`	`STRING`	Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve’s inception, stored as a numeric string.
`in_variableBorrowIndex`	`STRING`	Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve’s inception, stored as a numeric string.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	transaction_hash	in_liquidityIndex	in_stableBorrowRate	in_variableBorrowIndex
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	145	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	19112022	2024-01-29T11:55:23.000Z	0x43e360b8cf46bc79fe1bc3b6fc9191835697abb826d8abaf8576fbb869c4e7c1	1000000000000000000000000000	90000000000000000000000000	1000000000000000000000000000
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	289	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	19114967	2024-01-29T21:49:35.000Z	0x5f5ffbdceae54c2501424d90146ee21f7b5bca517537e80e7a61e28c8bf93587	1000000000000000000000000000	90000000000000000000000000	1000000000000000000000000000
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	false	350	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	19115288	2024-01-29T22:54:11.000Z	0x6359397ddc3d5eabe5a164f01c4d49496fcd523ecdcf2d3b99e7fbac2f94b2a9	1000000000000000000000000000	90000000000000000000000000	1000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x0ebfa6d5591fee005f2e3718e904619c08c136ff	false	21321316330000000000	262	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	20438450	0x0ebfa6d5591fee005f2e3718e904619c08c136ff	2024-08-02T04:23:23.000Z	0xbd7bb1be3a7cc853489a10276d1afad75ac09924e7daa7f93f31c9cf10410c17
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x272408e5e2fc8030fae41a8bd4dbeb53eb5ea733	false	269134173060000000000	193	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	20438760	0x272408e5e2fc8030fae41a8bd4dbeb53eb5ea733	2024-08-02T05:25:35.000Z	0x7c6fbded237cdf768b7e7f55631050ead3bec82d38dd18a6b5ebc83db3bb9d55
0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x568ea7d5c3ec009543a841178e96ef00cb757e42	false	50221176957874739741731	148	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	20443806	0x568ea7d5c3ec009543a841178e96ef00cb757e42	2024-08-02T22:22:11.000Z	0xd5d67c8ad30a4617df710a8622281c23c98a77eabe300ea472de54c8124ed172

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	false	123727257	97	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	20247647	2024-07-06T13:04:59.000Z	0x9a121bd05096b0862effb672f605522f4da59a73fc5dcfab7804119559c97f98
0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x02e7b8511831b1b02d9018215a0f8f500ea5c6b3	false	2747763	377	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	20244195	2024-07-06T01:29:47.000Z	0x88db25d2923c2e70a0bd8f1f5c67c90b0835d0d7467d685198d618d85e736bc2
0x25b039b7bbf5ee19e3426f603bcec61b3d056f78	0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	0x25b039b7bbf5ee19e3426f603bcec61b3d056f78	false	1210400	388	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	20248226	2024-07-06T15:00:47.000Z	0xb36705772b037eca95850d6b3a307684c02f29f4ae8365760af7493a1e0b226c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
6700	0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0xae78736cd615f374d3085123a210448e74fc6393	256	16620261	2023-02-13T13:53:23.000Z	0xcd9fe1a55aa699b22bd9b727ee70e9027d7e0213af9574fe2cebfa28cdd69143	10750	7400
7000	0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0x68749665ff8d2d112fa859aa293f07a622782f38	21	23260601	2025-08-31T10:42:35.000Z	0xeafa6e00db723879eaf11b2586e4f8fa30ac55bcfb817516e824223685145b34	10600	7500
7700	0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0x5f98805a4e8be255a32880fdec7f6728c6568ba0	233	17925832	2023-08-16T07:14:11.000Z	0xa68821a2f4cc39773b385670bf5269af35cf0396e486fa4e4cfd389c33b8614b	10450	8000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0x9d39a5de30e57443bff2a8307a4256c8797a3497	1000	344	20184634	2024-06-27T17:51:47.000Z	0x8d3393bdf789611ddddf54a8a6e38d53e8e2280e5ea36f36c1182538a0ff1261
0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202	1000	14	18366741	2023-10-17T01:12:59.000Z	0xdc18e36b9522b594be9dc9f674e29ccb24091953f09445c5615f7029ea098364
0x342631c6cefc9cfbf97b2fe4aa242a236e1fd517	false	0x9d39a5de30e57443bff2a8307a4256c8797a3497	1000	26	21214289	2024-11-18T11:25:23.000Z	0x90537e7a5cad5f0b979e7e369051a739b57bab179ed254ec6a252f3651808fe9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x342631c6cefc9cfbf97b2fe4aa242a236e1fd517	false	0xbf5495efe5db9ce00f80364c8b423567e58d2110	47	21057012	2024-10-27T12:37:47.000Z	0x68ba5914c5ae6a520a7a42ffd2288c3d64e41bb8eba0ae47269dba3901a4d4dd	1500
0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0x111111111117dc0aa78b770fa6a738034120c302	110	17539726	2023-06-23T03:52:35.000Z	0x1cccbb1b88d9aa969348db2577a53dc1fcc76b42e270784d453005838c5968a0	2000
0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0xc18360217d8f7ab5e7c516566761ea12ce7f9d72	91	17539726	2023-06-23T03:52:35.000Z	0x1cccbb1b88d9aa969348db2577a53dc1fcc76b42e270784d453005838c5968a0	2000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0xf1c9acdc66974dfb6decb12aa385b9cd01190e38	0x927709711794f3de5ddbf1d176bee2d55ba13c21	136	19859211	2024-05-13T06:09:47.000Z	0x27088d0f6c546386177ac5728acd9f78a20c73d56262e9840b41f16744244430	0x48fa27f511f40d16f9e7c913e9388d52d95bc6d2	0x8838eeff2af391863e1bb8b1df563f86743a8470	0x48af11111764e710fcdce2750db848c63edab57b
0x64b761d848206f447fe2dd461b0c635ec39ebb27	false	0x1abaea1f7c830bd89acc67ec4af516284b1bc33c	0xaa6e91c82942aeae040303bf96c15a6dbcb82ca0	4	22824444	2025-07-01T12:39:11.000Z	0x37c86d632fdbf876997356771b95a5bd1b03a3438173c25acc014fcd19b3a9a5	0x0000000000000000000000000000000000000000	0x6c82c66622eb360fc973d3f492f9d8e9ea538b08	0x9ec6f08190dea04a54f8afc53db96134e5e3fdfb
0x342631c6cefc9cfbf97b2fe4aa242a236e1fd517	false	0xd11c452fc99cf405034ee446803b6f6c1f6d5ed8	0xce8c60fd8390efcc3fc66a3f0bd64beb969e750e	118	22802246	2025-06-28T10:09:35.000Z	0xbdae250a9812be6e12d2108cc6159dd3c7315e8221f483535a73c94b71ce7ec7	0x0000000000000000000000000000000000000000	0xe7ea6125490ae4594ad9b44d05dff9f2a4343134	0x8958b1c39269167527821f8c276ef7504883f2fa

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x5300a1a15135ea4dc7ad5a167152c01efc9b192a	0x	false	0x991200058d0abfa279192a9b3575d9a679bbbdbb	83	21610531	execute()	0x	2025-01-12T19:34:35.000Z	1736710475	0xfa101fe3efcde74fdc10645056ed006d950cb57a07444583fb8e16265a136899	true
0x5300a1a15135ea4dc7ad5a167152c01efc9b192a	0x	false	0x70e9fa954051a6b227249021a349ae9e5aad55bf	249	21610004	execute()	0x	2025-01-12T17:48:35.000Z	1736704115	0x5c89211e695c2157f00446bfcdbfda3c4718035e9e4048469d7edb9dd232ba2c	true
0x5300a1a15135ea4dc7ad5a167152c01efc9b192a	0x	false	0xf58c30f316e3b8200cbc83365e7e1f7f648dc5c9	143	22775229	execute()	0x	2025-06-24T15:37:23.000Z	1750779443	0xfc3ce30f63ea81b5ddba3f5458808fb13785bf682c6209c4d9e556a6d6153a35	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x0bfc9d54fc184518a81162f8fb99c2eaca081202	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	51189805975462797855	0xba1333333333a1ba1108e8412f11850a5c319ba9	49056445769704613735	235	22265865	2025-04-14T07:54:11.000Z	0x045df5ee05ed585114456e95ea76ccb472a9b4332aad3cebe21344c5b60221fa
0x7bc3485026ac48b6cf9baf0a377477fff5703af8	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	126742450790	0xba1333333333a1ba1108e8412f11850a5c319ba9	113133115715	439	22263997	2025-04-14T01:39:59.000Z	0xa9b2b0c3836335fcf745e54fbbb376c829565b085942ecea660c383994e0c4de
0x7bc3485026ac48b6cf9baf0a377477fff5703af8	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	33493763234	0xba1333333333a1ba1108e8412f11850a5c319ba9	29897125435	373	22264686	2025-04-14T03:57:59.000Z	0x44d32b6205a5e858f1959cb7e8b7e47c8fa74c3f4aa704d3b898c52824b094fc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0x5caf5a86f39073637ac7c8a7b5290871de80cb9b	false	177	1	22132820	2025-03-26T18:17:23.000Z	0x5228d4aa541d86f88d817a2bc309280e84e2c45c0cfdb70876c8cb457b432ca6
0xb80b3215ea8183a064073f9892eb64236160a4df	false	440	1	21285713	2024-11-28T10:50:23.000Z	0xb5f3c0f35618dbb0af20257443bb0fc9f09e39193c43f2a776a062d0071d4c28
0x6a1792a91c08e9f0bfe7a990871b786643237f0f	false	175	1	22439025	2025-05-08T13:10:35.000Z	0x59bd0d5e949fc6778a72b54ec4313098b3fff0e6879c2da8ddb073dc92e3b007

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0xd4fa2d31b7968e448877f69a96de69f5de8cd23e	false	0xe6b1de575e7e610889ea21024834e120f92033a3	20660489931	0xe6b1de575e7e610889ea21024834e120f92033a3	18599686045	73	0xe6b1de575e7e610889ea21024834e120f92033a3	21529966	2025-01-01T13:38:11.000Z	0xe1b08fd6efafa3e51f08207381c2beb11605a40daf0f166bcdc6de04d5dd4f17
0x0bfc9d54fc184518a81162f8fb99c2eaca081202	false	0xe6b1de575e7e610889ea21024834e120f92033a3	18308101519950341640	0xe6b1de575e7e610889ea21024834e120f92033a3	17645813332149780568	44	0xe6b1de575e7e610889ea21024834e120f92033a3	21527921	2025-01-01T06:47:47.000Z	0xe91dc970affe579e3de2feeea7e9aaf77418d93b67f47a8c91460eda36df85d5
0x0bfc9d54fc184518a81162f8fb99c2eaca081202	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	49506758204514363783	0xba1333333333a1ba1108e8412f11850a5c319ba9	47584407380605948190	113	0xba1333333333a1ba1108e8412f11850a5c319ba9	21903965	2025-02-22T19:29:35.000Z	0x3d5b03799f98cff647d6b70d8eb2ae478b5f81ed1865bcc670955f761e6a2aa1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0xcb0b5ca20b6c5c02a9a3b2ce433650768ed2974f	false	180	22132820	0x5caf5a86f39073637ac7c8a7b5290871de80cb9b	0x6b175474e89094c44da98b954eedeac495271d0f	2025-03-26T18:17:23.000Z	0x5228d4aa541d86f88d817a2bc309280e84e2c45c0cfdb70876c8cb457b432ca6
0xcb0b5ca20b6c5c02a9a3b2ce433650768ed2974f	false	443	21285713	0xb80b3215ea8183a064073f9892eb64236160a4df	0xdc035d45d973e3ec169d2276ddab16f1e407384f	2024-11-28T10:50:23.000Z	0xb5f3c0f35618dbb0af20257443bb0fc9f09e39193c43f2a776a062d0071d4c28
0xcb0b5ca20b6c5c02a9a3b2ce433650768ed2974f	false	352	21625164	0xb51edddd8c47856d81c8681ea71404cec93e92c6	0x6c3ea9036406852006290770bedfcaba0e23a0e8	2025-01-14T20:38:11.000Z	0x9a1edb955e8f993938310fe0628a443edee458b1d2c65025e89b24b0ddaeceea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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_ethereum.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_ethereum.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
0x028f7886f3e937f8479efad64f31b3fe1119857a	0x0cba4e88cf1a0ab30d1df0b856b2d632e05a024c	false	1019263405083398001608124773	2000000000000000000000	0x0000000000000000000000000000000000000000	96	19150965	2024-02-03T23:01:35.000Z	0xd69331b3bab516cc9d63d423d4396a931b25f5a5c96893576e7023efaf120d1d	16370028630046381534
0x0c91bca95b5fe69164ce583a2ec9429a569798ed	0x1aecea38b8626eeb3748234343cff427268dd487	false	1008972403622554850285684599	309096150160171597824	0x0000000000000000000000000000000000000000	76	19150659	2024-02-03T21:59:59.000Z	0x45cfec683a2de63dcc154dcfc9a8337fbfdfa7d9189d1da6c2bcbc54714f5a21	0
0x0c91bca95b5fe69164ce583a2ec9429a569798ed	0x1aecea38b8626eeb3748234343cff427268dd487	false	1008958867787345930950170431	116958860204141854720	0x0000000000000000000000000000000000000000	78	19145560	2024-02-03T04:48:11.000Z	0x5b9e613d35ffa2df37a11afd027a05b1ccf2cd7ff4ed16a81f90530913a67154	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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
0xeb284a70557efe3591b9e6d9d720040e02c54a4d	false	1002158602320899139861450481	2502658226	0xa937f63ba1d69fd7e022fd50628b6d8fcfbde52d	160	22749993	0xa937f63ba1d69fd7e022fd50628b6d8fcfbde52d	2025-06-21T02:56:11.000Z	0x74818e6da8b47683942a89fe7a9ab22a1f6594dcd62f2071d1427952a55c1615	2658226
0xeb284a70557efe3591b9e6d9d720040e02c54a4d	false	1002163222576847514458113185	28785924	0xd6cb7a7b544e24e5160a948a16c45b1096276f9d	407	22753354	0xd6cb7a7b544e24e5160a948a16c45b1096276f9d	2025-06-21T14:12:23.000Z	0x69ae7037f3fffe7a5a52ded13941129138984a76ae9d33aad4832fa0ad4087a5	15134
0xbdfe7ad7976d5d7e0965ea83a81ca1bcff7e84a9	false	1003370713261447014473282039	3249141269419868187010	0xe4bbe2f185fb37effc311c190d0db2ec8eb46893	301	22751073	0xe4bbe2f185fb37effc311c190d0db2ec8eb46893	2025-06-21T06:33:23.000Z	0xd8c7d2fc7f3c3d4b9bb64dab16792aa8375684927519ae267d0217c84c214468	6938549161589931321

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_ethereum.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`	`FLOAT64`	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
414097	0x1213f27ba2441b3d1db8e610c850d9ea9ab9f4cb	true	222072	0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	15000000000000000000	0x80500d20	0xd01607c3c5ecaba394d8be377a08590149325722	23521104	0x1213f27ba2441b3d1db8e610c850d9ea9ab9f4cb	2025-10-06T20:27:11.000Z	0x9d4c58347f48433d8a15f9b1420dbe18ab7e0e0d8f9908d0baa71a4077194434
355381	0x0347e66c17958851ef10b2ac61a1e0d97376f5f4	true	222217	0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	10000000000000000000	0x80500d20	0xd01607c3c5ecaba394d8be377a08590149325722	23518738	0x0347e66c17958851ef10b2ac61a1e0d97376f5f4	2025-10-06T12:30:11.000Z	0xc1c85133af898455a90272eaf5f66e3cee59e91abe186d62128af8b56c3ed19e
345220	0x849db3b43e7b76119420489dc4f779d6e8173a71	true	222326	0x87870bca3f3fd6335c3f4ce8392d69350b4fa4e2	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xd01607c3c5ecaba394d8be377a08590149325722	23521040	0x849db3b43e7b76119420489dc4f779d6e8173a71	2025-10-06T20:13:59.000Z	0x40ba1177698e2e343997ec32e13cc403962a9c49d1659fd4e4fabd55cd469a26

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

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

​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

​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

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

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