aave_v3_avalanche

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
0xc244accfe1ed082c944106109f23ce1f7527ebb1	0x8ffdf2de812095b1d19cb146e4c004587c0a0692	0x28f08f2fd6ab1cb7ebefe5ba6acda9f6a86b7f78	false	1003311861181785850941806675	781412	5	54153748	2024-12-10T04:07:16.000Z	0x063f6812e036c49078c3acd7f088d1fb868f9e3e656da0b7eae0ca551b17a30e
0xf5bfda4aac69846c86ae48230e6da3bd4bc2782b	0x6d80113e533a2c0fe82eabd35f1875dcea89ea97	0x6d2f00b549859be2f85e1b968efa3b43f6d919cc	false	1059814222744942091942275636	94356288409304672	15	54160476	2024-12-10T07:56:36.000Z	0x59df0a72d96c91b83128086d4b889b98a9ddc69bd38c46ad317a72a282f314a3
0x7b77d2bc27c82a1180d7802141ed412a3fe96aa3	0x625e7708f30ca75bfd92586e17077590c60eb4cd	0xf724d681bae7c2c0ef66a91c4c500d1e032736a9	false	1125839348535765164580120801	882550873	18	54158947	2024-12-10T07:03:57.000Z	0xe4906ef13d58f0bc1a56045608bb3f35578eba98375c9544866726458253ff2c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0xc45a479877e1e9dfe9fcd4056c699575a1045daa	0x8edcfd59b8477aab0af872e3b101a4410bd8cc42	false	1100986867062460870382928770	216645248096475037740	0x8edcfd59b8477aab0af872e3b101a4410bd8cc42	2	41434475	2024-02-09T02:59:32.000Z	0xda7eb0b0f5f23ef145b4849864ece3fa9986d674418a5a07af6c554516a6f277	284382607684562231
0x078f358208685046a11c85e8ad32895ded33a249	0x49f5b996814fed1dd39285b92a59cfb2dfd8d4f9	false	1002412392954009905018784802	1707439	0x49f5b996814fed1dd39285b92a59cfb2dfd8d4f9	42	41443701	2024-02-09T08:12:12.000Z	0x024e14f74a9ed53dca8eae95ae66710056713f23b16f7aad714490ad7caa261b	0
0x078f358208685046a11c85e8ad32895ded33a249	0x51d1bca0a960b93ccbef4144f63790af6040d9c7	false	1002412809015660581063232976	1999562	0x51d1bca0a960b93ccbef4144f63790af6040d9c7	11	41467617	2024-02-09T21:37:37.000Z	0xc0e42e9ae26e8c22e80441f52870efdbb28ec6fff7b2e40f6c0e9aa570f61816	438

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x8a9fde6925a839f6b1932d16b36ac026f8d3fbdb	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	185	0x5ba7fd868c40c16f7adfae6cf87121e13fc2f7a0	68891248	Aave Avalanche EURC	2025-09-17T19:03:33.000Z	aAvaEURC	0x5e67ff3938a52f22a7878c55a6b825bea0dbd7aabdae062f78d965642caee9ee	6	0xc891eb4cbdeff6e073e859e987815ed1505c2acd	0x929ec64c34a17401f460460d4b9390518e5b473e
0x724dc807b04555b71ed48a6896b6f41593b8c637	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	79	0x5ba7fd868c40c16f7adfae6cf87121e13fc2f7a0	66697842	Aave Avalanche AUSD	2025-08-07T10:06:57.000Z	aAvaAUSD	0x962a92a09a3cdeed31d9ebcd254f1e836a24e4195fd7b388fd634f754ae44f8d	6	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	0x929ec64c34a17401f460460d4b9390518e5b473e
0x6ab707aca953edaefbc4fd23ba73294241490620	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	37	0x5ba7fd868c40c16f7adfae6cf87121e13fc2f7a0	66697842	Aave Avalanche USDT	2025-08-07T10:06:57.000Z	aAvaUSDT	0x962a92a09a3cdeed31d9ebcd254f1e836a24e4195fd7b388fd634f754ae44f8d	6	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x929ec64c34a17401f460460d4b9390518e5b473e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x8ffdf2de812095b1d19cb146e4c004587c0a0692	false	1000209092877137726103971479	930210	0xf7fc20d9d1d8dfe55f5f2c3180272a5747dd327f	38	20550863	0x70eb9d6528d65dac60a2eee849ce0b5e2eac8dae	2022-10-02T12:07:24.000Z	0xdc51b2702e11662e0911f317e2897e3c212a7b09ca8ab90cc9d4f67f0df055b2	0
0x8ffdf2de812095b1d19cb146e4c004587c0a0692	false	1000209607349903301222296156	549249956	0xd317af4d629148886c02b4143363bc033c5dfe63	32	20551622	0x2fb12028b6ad4412b5c4be47cfee6ade7f5a22c3	2022-10-02T12:33:18.000Z	0x796be267b896d8730e3d0af1597b771a3980678492dd557949096fb952b2cb51	18
0x8ffdf2de812095b1d19cb146e4c004587c0a0692	false	1000209616365070947200069065	150837761	0xd317af4d629148886c02b4143363bc033c5dfe63	33	20551635	0x2fb12028b6ad4412b5c4be47cfee6ade7f5a22c3	2022-10-02T12:33:44.000Z	0x274cbf564e2d8fb76d3025cd687f6d4a26785d38be2a626a3de33e0cffaf746b	14

Example Query

Query with partition filter

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

in_to	address	in_user	removed	in_amount	in_reward	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x03362b4d67ff56d0faa708d387e571d1d1190007	0x929ec64c34a17401f460460d4b9390518e5b473e	0x03362b4d67ff56d0faa708d387e571d1d1190007	false	388523975843758191	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	13	0x03362b4d67ff56d0faa708d387e571d1d1190007	53713501	2024-11-29T19:19:09.000Z	0x736d450e71fe7d56d023d0badfd31386f14edb4c085f5a10726eb1bca7a68faa
0x043aba1b57ad8bd7516a6aaa5ffb92e3fe0fbe0c	0x929ec64c34a17401f460460d4b9390518e5b473e	0x043aba1b57ad8bd7516a6aaa5ffb92e3fe0fbe0c	false	2560937696741071632	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	23	0x043aba1b57ad8bd7516a6aaa5ffb92e3fe0fbe0c	53705545	2024-11-29T14:49:07.000Z	0xdf3980fd03535ef60317e02f9392f24f78882b4f848b25b7deb37afd740c37be
0x043aba1b57ad8bd7516a6aaa5ffb92e3fe0fbe0c	0x929ec64c34a17401f460460d4b9390518e5b473e	0x043aba1b57ad8bd7516a6aaa5ffb92e3fe0fbe0c	false	1027966944539765714	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	20	0x043aba1b57ad8bd7516a6aaa5ffb92e3fe0fbe0c	53705545	2024-11-29T14:49:07.000Z	0xdf3980fd03535ef60317e02f9392f24f78882b4f848b25b7deb37afd740c37be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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	in_referralCode	transaction_hash	in_interestRateMode
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x72315955b082695c18dbbec62a4f941da1f474f8	false	500000	16	0x152b9d0fdc40c096757f570a51e494bd4b943e50	43730650	1428032919508841868022347	0x72315955b082695c18dbbec62a4f941da1f474f8	2024-04-03T12:13:22.000Z	0	0x6d31d2c1931f5bcf99fb5fb98ad966c6dc916e35405c459f36ca3f8bcefae032	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x8a9b2c132ea7676ee267f5b97b622083d6e3a2d4	false	50184	28	0x152b9d0fdc40c096757f570a51e494bd4b943e50	43718134	1519205636430170981262142	0xe08296b2130640d5d12b21bf66e24296566dfccf	2024-04-03T05:00:46.000Z	5936	0x2f691ab1a47ac87b8f99cd853486bce4cac8914274bdf08a62b866a32deeb312	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x8a9b2c132ea7676ee267f5b97b622083d6e3a2d4	false	6057511	23	0x152b9d0fdc40c096757f570a51e494bd4b943e50	43720240	1524903451619311614060927	0x3958a583bcf988f97756fcff975db2a5c9fcaabe	2024-04-03T06:13:49.000Z	5936	0xcd1015d9d3af03dd7bf15d37845e6b218470c18774672d277acee7f94263f969	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	2300000000000000000000	0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a	51	1150000000000000000	53659789	0x019ea1afabcbd84d922043c4261052a583315d2c	2024-11-28T12:47:24.000Z	0xc353592e604208a0d3cc744b772c94425c92da62b7f968aeae0f6bf0100c1734
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	38905237921	0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a	64	19452619	53638519	0x019ea1afabcbd84d922043c4261052a583315d2c	2024-11-28T00:45:05.000Z	0x49aa0a23961423bb3e74bea3544cc1963c22caf8cfedc52634095f3cae0ccb5d
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	63964367471	0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a	56	31982184	53659189	0x019ea1afabcbd84d922043c4261052a583315d2c	2024-11-28T12:27:07.000Z	0x68da44f80a5b1dc6f157311548863f15e49b14eb648a7f15cbba2016ba30b1a3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x9aec2edfa7ad43cd5fadfc6f64809b04ea68693f	false	21	17510339	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0x5a26fb2e021df2bd122a61699c2a9a2049c0a4c1	10982095225826902	2022-07-19T01:19:11.000Z	false	0x9d964962a57221c5d8da2fff1d358f12f50bb8b726efe85b22e34bc3a09325c6	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	11476289510989112
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x3b8ed304faf0f5e8322b9cea4117ad1aef0ce4f0	false	24	17510970	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	0x03f237c83f87c8215eaa46cf638f09396ca9739d	477203286	2022-07-19T01:40:14.000Z	false	0x1b502775ceb712a7400698272e056f78e46f3d75de51aadff80664ec0e63b373	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	324665856500985012
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xa9f036edbd41596ff0c2656fe1c9b0db1fb7a542	false	23	17531871	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0x9291bc4b9c3620b5ec37d51edc919c32545f2143	1127685054078383347506	2022-07-19T13:20:29.000Z	false	0xfebabb8706efc52e30bb252cb39de0a7e308ca8f30a37d632862b65df427e230	0x50b7545627a5162f82a992c33b87adc75187b218	134677992

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	86	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	63615266	2025-06-10T06:00:47.000Z	924632354	0xb455012dc5ff95f95b7a7f0c2ec19fcd9909615252e6657158c26323f781cd85
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	74	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	63615266	2025-06-10T06:00:47.000Z	83270620062700250850	0xb455012dc5ff95f95b7a7f0c2ec19fcd9909615252e6657158c26323f781cd85
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	83	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	63615266	2025-06-10T06:00:47.000Z	807613663098650726	0xb455012dc5ff95f95b7a7f0c2ec19fcd9909615252e6657158c26323f781cd85

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0f9ef41f81b763083b29460cfb788843e7dd993c	false	20000000000	7	0x0f9ef41f81b763083b29460cfb788843e7dd993c	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	60690538	false	2025-04-21T19:15:33.000Z	0x5cf47cc2bea14dee6ae47bec603d85a7fe78bab60df700c71340e63876af24ef
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x23ae0187806b375ee83f9701ed5570e4ef2ca415	false	500000000	7	0x23ae0187806b375ee83f9701ed5570e4ef2ca415	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	60689770	false	2025-04-21T18:57:46.000Z	0xea992c40e3a43c5c95312baf14e753c906a12789a0d69364237a2073b13d3f46
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x5afed6b5de5949b6d2f364dd610caea7ecf5626a	false	2101559968	5	0x5afed6b5de5949b6d2f364dd610caea7ecf5626a	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	60694425	false	2025-04-21T20:50:59.000Z	0xd966e7d471f5d26db665f6e0bb90a229c0bf770f5eab9379b8526961adef3c34

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	56	0x63a72806098bd3d9520cc43356dd78afe5d386d9	41695555	2024-02-15T05:36:41.000Z	0x36de5e6b544e5d7c66cdce9cb14311a9bea954ef4109b56d506bb62165ef36ab	1000274994219064480009425974	90000000000000000000000000	1000000000000000000000000000
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	52	0x63a72806098bd3d9520cc43356dd78afe5d386d9	41713761	2024-02-15T15:48:52.000Z	0x53b121fadbfb818d18b9d78225eb4fcde372001c469239ace921dd7ccf1d22b7	1000275494817734089604854181	90000000000000000000000000	1000000000000000000000000000
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	64	0x63a72806098bd3d9520cc43356dd78afe5d386d9	41719684	2024-02-15T19:08:17.000Z	0xe82028f24366fbe7af06d2f4e105995d6e4e791c7a95d1e032eed4467b807b2f	1000276498025145183720376727	90000000000000000000000000	1000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x5ba60565827607db35fb46f2dae79aca0c5ae37b	false	8672834346225103	16	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	18816568	0x5ba60565827607db35fb46f2dae79aca0c5ae37b	2022-08-18T20:33:35.000Z	0xdc154d560ff5086e6a6eed7ab8a92a37d69d72918df92be0cb3e69c841d04719
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x8b7a6fec5c6638c1d667ef8126b457fec09376eb	false	386946863810683875120	52	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	18806870	0x8b7a6fec5c6638c1d667ef8126b457fec09376eb	2022-08-18T15:00:59.000Z	0x7cb079f0dd788bd2229e5e3305623d3a04f85ee2f8fd49ba2fe9cbfd81c4148d
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xd317af4d629148886c02b4143363bc033c5dfe63	false	7792552392257403176	31	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	18790215	0x576de0ff0a1ba2ac33349e26132efaa69af1a32e	2022-08-18T05:31:07.000Z	0x04d4eaf31fddece1ad29b9f1d8e64640acecb7ed165c31dfc40650e75d979d4e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x12cff045f29dd72cb0d0122950ad6a5488754989	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x12cff045f29dd72cb0d0122950ad6a5488754989	false	10048986	18	0x152b9d0fdc40c096757f570a51e494bd4b943e50	44279342	2024-04-16T14:44:38.000Z	0x79489ae30fba2e397004878791d65310dd7d8d755945c3c343bf08443d8aaec8
0x191470821c2ce5be23812cc7a8e9d4d7dc0786be	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x191470821c2ce5be23812cc7a8e9d4d7dc0786be	false	127779	32	0x152b9d0fdc40c096757f570a51e494bd4b943e50	44279791	2024-04-16T14:59:52.000Z	0xcb46bdf1916ee80dabecd9b96b504a131a150287376c76d784ffeacf4c445b3d
0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x2cf641f7c0eac2788a7924b82d6ca8eb7baa4e3a	false	5002500	32	0x152b9d0fdc40c096757f570a51e494bd4b943e50	44286921	2024-04-16T19:04:13.000Z	0xc7cf12a7f28250d2f1f53e8e01319f9dac1bd966cb1bb93f4936bdbecdff55c9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
6300	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	3	44859561	2024-04-30T15:28:57.000Z	0x5e11d89fd7bb790e4eef4c39936abf490aa1fe23fb5818684bfe69b3b0f01104	10500	7700
4000	0x8145edddf43f50276641b55bd3ad95944510021e	false	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	5	48846771	2024-08-04T19:44:22.000Z	0x7bb6cd8b3f5f241bf581ac12ec8ad13da4ca04f08d2b62427b44b9bdece6e8aa	11000	4500
7500	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xd24c2ad096400b6fbcd2ad8b24e7acbc21a1da64	30	27564142	2023-03-17T17:59:09.000Z	0x688dccfa2dd38905d2a207efdc7009060e1c584102b046ba1a6f9087366cf791	10500	8000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	1000	19	20167422	2022-09-23T07:25:40.000Z	0xdfe07773091925a3dd20f233360aab86c004b87f90d80d20bde67bec13c20965
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xd24c2ad096400b6fbcd2ad8b24e7acbc21a1da64	1000	18	19400874	2022-09-01T12:33:15.000Z	0x8310e09df71581b2dad2059f6f8d180851160ebbef7a2e917bfea46d77d3fc8f
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x5c49b268c9841aff1cc3b0a418ff5c3442ee3f3b	1000	77	19400907	2022-09-01T12:34:18.000Z	0xcc1f6e6dc4584f3456a7f80d3969ac23306b06393f4927735a50a9093e998107

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2	90	70937103	2025-10-26T14:58:06.000Z	0x848c9e0fd99da396cecf8eb4d6e3adf13cd5a05a290d1d91bc2c44902cc85640	4500
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34	84	70937103	2025-10-26T14:58:06.000Z	0x848c9e0fd99da396cecf8eb4d6e3adf13cd5a05a290d1d91bc2c44902cc85640	2500
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x63a72806098bd3d9520cc43356dd78afe5d386d9	76	11974622	2022-03-11T13:39:10.000Z	0x7801b9913a5b6af0edbc39c4dcaf37196916b935dd26c7a0d0ed94fd6df8dcf2	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xfc421ad3c883bf9e7c4f42de845c4e4405799e73	0xf611aeb5013fd2c0511c9cd55c7dc5c1140741a6	273	64466944	2025-06-25T21:06:11.000Z	0xfc950ab0642b944a0d81d312af8743bf0a9bce6fa7b16304a98c5fc6604c204e	0x0000000000000000000000000000000000000000	0x38d693ce1df5aadf7bc62595a37d667ad57922e5	0xce1c5509f2f4d755aa64b8d135b15ec6f12a93da
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x152b9d0fdc40c096757f570a51e494bd4b943e50	0x8ffdf2de812095b1d19cb146e4c004587c0a0692	13	20167422	2022-09-23T07:25:40.000Z	0xdfe07773091925a3dd20f233360aab86c004b87f90d80d20bde67bec13c20965	0xa5e408678469d23efdb7694b1b0a85bb0669e8bd	0xa8669021776bc142dfca87c21b4a52595bcbb40a	0x79a906e8c998d2fb5c5d66d23c4c5416fe0168d6
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xd24c2ad096400b6fbcd2ad8b24e7acbc21a1da64	0xc45a479877e1e9dfe9fcd4056c699575a1045daa	11	19400874	2022-09-01T12:33:15.000Z	0x8310e09df71581b2dad2059f6f8d180851160ebbef7a2e917bfea46d77d3fc8f	0x78246294a4c6fbf614ed73ccc9f8b875ca8ee841	0x34e2ed44ef7466d5f9e0b782b5c08b57475e7907	0xf4a0039f2d4a2ead5216abb6ae4c4c3aa2db9b82

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x3c06dce358add17aaf230f2234bccc4afd50d090	0x	false	0x882ccd8087bc44105e962bc01280a335b210d738	39	43057058	execute()	0x	2024-03-18T11:22:11.000Z	1710760931	0x8c75392123cfd688587e53025a17ba5f49ce70f3969624ceb7ad52f75b436f37	true
0x3c06dce358add17aaf230f2234bccc4afd50d090	0x	false	0x0a99a362d24cb7ed4a4ab94494a7dfc71c408fd5	6	48384131	execute()	0x	2024-07-24T16:32:56.000Z	1721838776	0xa82275b1606039794297db01e7ca48d703e56c022f906cdc910312942dcd33ae	true
0x3c06dce358add17aaf230f2234bccc4afd50d090	0x	false	0x41fad3911a819646ff385e392ad05046e64661f8	12	54397860	execute()	0x	2024-12-15T23:39:04.000Z	1734305944	0x19fd0d772e83b1ffd2b2b54b0ddd414c8b27f797c64113680caf41e87bd72db9	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	102887	0xba1333333333a1ba1108e8412f11850a5c319ba9	102520	14	67286269	2025-08-19T01:07:56.000Z	0x589e7d7edc5a2d1c91aecb5d123a7e04d18abc22f718a5b02e10bf26459e3f17
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	141106	0xba1333333333a1ba1108e8412f11850a5c319ba9	140603	14	67329060	2025-08-19T20:36:21.000Z	0x7de169aa1602851953559a90c382a1941c8d4b39a6dcd05bc4d6a01657b9c162
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	279458	0xba1333333333a1ba1108e8412f11850a5c319ba9	278463	14	67328632	2025-08-19T20:25:22.000Z	0x28c19f5c18470dbbf61417cc8fb849ceb7147adf93111f5c7868a3d30f741a40

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	12	1	59291603	2025-03-26T19:36:43.000Z	0x3f8f8def3051ee3f7a616e32d9fb7acf4293a25896987201ad78270c175f9178
0x3929336afd0bba6fcabb67dfb78610379c66b43b	false	85	1	59291603	2025-03-26T19:36:43.000Z	0x3f8f8def3051ee3f7a616e32d9fb7acf4293a25896987201ad78270c175f9178
0x45cf39eeb437fa95bb9b52c0105254a6bd25d01e	false	54	1	59291603	2025-03-26T19:36:43.000Z	0x3f8f8def3051ee3f7a616e32d9fb7acf4293a25896987201ad78270c175f9178

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	273754	0xba1333333333a1ba1108e8412f11850a5c319ba9	272807	20	0xba1333333333a1ba1108e8412f11850a5c319ba9	61381902	2025-05-03T15:42:17.000Z	0xd2207ec7fb04e1803dee1f9912122d8d808448c967ae436eda2fa08537402ce9
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	209246	0xba1333333333a1ba1108e8412f11850a5c319ba9	208522	22	0xba1333333333a1ba1108e8412f11850a5c319ba9	61383545	2025-05-03T16:23:44.000Z	0x31ae82297aaa90dbac1132cd8e82b7584c0585749abf8bf54013b470e61ed26a
0x2d324fd1ca86d90f61b0965d2db2f86d22ea4b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	1610917	0xba1333333333a1ba1108e8412f11850a5c319ba9	1605342	23	0xba1333333333a1ba1108e8412f11850a5c319ba9	61383566	2025-05-03T16:24:23.000Z	0x532aad36b29bc74bb5beb1d3e318293405491b406d867517f817efcfddcc682b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0xc2e7a608d868817dd58438913ed72955a0567561	false	58	59291603	0x45cf39eeb437fa95bb9b52c0105254a6bd25d01e	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	2025-03-26T19:36:43.000Z	0x3f8f8def3051ee3f7a616e32d9fb7acf4293a25896987201ad78270c175f9178
0xc2e7a608d868817dd58438913ed72955a0567561	false	25	59291603	0xe1bfc96d95badcb10ff013cb0c9c6c737ca07009	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	2025-03-26T19:36:43.000Z	0x3f8f8def3051ee3f7a616e32d9fb7acf4293a25896987201ad78270c175f9178
0xc2e7a608d868817dd58438913ed72955a0567561	false	74	59291603	0x61933af56431280ee4e5667133d8af6322d64b32	0x5947bb275c521040051d82396192181b413227a3	2025-03-26T19:36:43.000Z	0x3f8f8def3051ee3f7a616e32d9fb7acf4293a25896987201ad78270c175f9178

Example Query

Query with partition filter

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

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0x70effc565db6eef7b927610155602d31b670e802	0x0a8305c2050f080ba7c0aaa446ec0b28dba8af93	false	189400032691	30	17578517	2022-07-20T15:20:27.000Z	57704474037978412533351817	0x68625ac9d0a0082b5f3574c9f8d50587ffd2f3e4b6f73d01d821df5d627441c1	375907121229	80882197238877	1210495621
0x70effc565db6eef7b927610155602d31b670e802	0x0a8305c2050f080ba7c0aaa446ec0b28dba8af93	false	185296592917	17	17578689	2022-07-20T15:26:11.000Z	57713417739356917428726591	0x20a692a7abe38df1c73c8e0ed95c1f93e7beb4c7252beb63efc8998839070630	185296701649	80700451450574	108732
0x70effc565db6eef7b927610155602d31b670e802	0x8544107a04f53ab53ff211bdef82f32dca29e798	false	602647692930	4	17586386	2022-07-20T19:43:25.000Z	57718114816941913776819244	0x034d23bb9d0e869509f24fd7d549c8b5bc44aff28b88ff4c675e9027529477d2	602655608718	80106075407698	7915788

Example Query

Query with partition filter

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

address	in_user	removed	in_amount	log_index	in_newRate	block_number	in_onBehalfOf	block_timestamp	in_avgStableRate	transaction_hash	in_newTotalSupply
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0x083b672cd93fdd548ccd0f2a1dbc0d5b285bc312	false	3000000096	21	52301374804795112913223053	23381706	0x083b672cd93fdd548ccd0f2a1dbc0d5b285bc312	2022-12-08T18:58:19.000Z	52814332071281749172742174	0x9141911397620e2d4e059fb2805599710c36e4ff0754b4195fc1a6063614459f	102486304570
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0xab1b722bbe4a2ba446fbda2888123d1e531da662	false	4877000000	75	53412022190596125897067870	29779328	0xab1b722bbe4a2ba446fbda2888123d1e531da662	2023-05-09T03:08:36.000Z	53018742654058951742143889	0x563b51329f52268a041cd83d550f5fca88e2134f36121b5490f3b25bb54e3745	102672685554
0xd94112b5b62d53c9402e7a60289c6810def1dc9b	0xd998864177a59e769332ada79468ef4b50e9b9f7	false	120000000000000000000	75	54150435566572681991159605	29800542	0xd998864177a59e769332ada79468ef4b50e9b9f7	2023-05-09T15:03:44.000Z	53968198923410853183099292	0x9592ad287fd1b93b188e6e85340fc5c37dc15da69ab54294af8d67499ab9fe38	4660252530609520234318

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x34e2ed44ef7466d5f9e0b782b5c08b57475e7907	0xb6f28ba5470f5009f905298658a95c6e991ae6d6	false	1011459501407423455816580123	3993110242572263465570	0x0000000000000000000000000000000000000000	1	25186507	2023-01-20T13:53:55.000Z	0x1128fb88f7934346a71c057c2ded53146cef971840562eaad72669ac4e34d0f4	6889757427736534430
0x92b42c66840c7ad907b4bf74879ff3ef7c529473	0x048bf2f5908e95976cead0e47d805b3803e286e2	false	1013323978581975922105533891	407315951	0x0000000000000000000000000000000000000000	1	25195875	2023-01-20T19:10:43.000Z	0x308905116ac40d13cc4d870e1dec4ff18ab51292fdae374c3e7d9bf7c6f875af	106410
0x4a1c3ad6ed28a636ee1751c69071f6be75deb8b8	0x0ffeb87106910eefc69c1902f411b431ffc424ff	false	1054259101581471362682453765	215715522093626598494	0x0000000000000000000000000000000000000000	1	25166056	2023-01-20T02:15:00.000Z	0xe04b119b2d85c2ba30c1c193670edec5b602dc8c652e7e8dccbfe315e2ca117b	73634348475604086

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	false	1049718843219147446283241688	16732264712463725	0x32d3bbb0cc1d1fe32cdab957c2ed206ea872b0d4	1	45573551	0x32d3bbb0cc1d1fe32cdab957c2ed206ea872b0d4	2024-05-18T01:23:20.000Z	0x9ad078bc96a19b4b57531b4415f9e8694f6842a6fbf62ffd35c2cb2e258d68aa	2778832460842
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	false	1049721574963481281944456072	17011965754643897994	0xa523d2d2e9a2ee4089e57f77bedebec9b36bf318	1	45574921	0xa523d2d2e9a2ee4089e57f77bedebec9b36bf318	2024-05-18T02:12:16.000Z	0x4cf280ce023d2bcc74f58766820e2430568edf60f3ef3f3426f7f50c21dd3477	6549754643897994
0x8619d80fb0141ba7f184cbf22fd724116d9f7ffc	false	1119013393613032115752788993	251554707234115224967	0x1b72f5db285b011326efc250627e89c4fd24e084	1	45585625	0x1b72f5db285b011326efc250627e89c4fd24e084	2024-05-18T08:28:28.000Z	0x95928bcaaa5c1acf81519866a0e6b01f808537066bd8b95b91ccdb8d442ce978	1554707234115224967

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_avalanche.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`	`STRING`	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
487299		false	298390			0x80500d20	0x2825ce5921538d17cc15ae00a8b24ff759c6cdae	64075557	0x8d5b2d2433f5947cb0ffa81d6ad2949fd5d57050	2025-06-18T20:14:29.000Z	0x28f7b000d4fd2282ac55916196508ca86921cb2bd13f3b97ff2d736b8c899fc9
647580		false	340065			0x80500d20	0x2825ce5921538d17cc15ae00a8b24ff759c6cdae	64055000	0xe3884a72546f65944df71d7199c038270519511b	2025-06-18T11:06:42.000Z	0x0c82f8785be4ec53b21c5490089a10a33492f7918dcb8efb784e278c5688a879
399909	0xa54371be88e912d2f6401b694824034d379e415e	true	304043	0x794a61358d6845594f94dc1db02a252b5b4814ad	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x2825ce5921538d17cc15ae00a8b24ff759c6cdae	64048358	0xa54371be88e912d2f6401b694824034d379e415e	2025-06-18T08:04:38.000Z	0x36d5ed22882a825505f2ac5ceaaa210576802fa8d10f0a8e193077ec0a71cbbd

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

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