aave_v2_avalanche

Tables

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_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
0x686bef2417b6dc32c50a3cbfbcc3bb60e1e9a15d	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	1001800381234360253129188978	9050090	0x000000c0f624da031e44661f23c2e5bdacc6dcf4	51	31511078	2023-06-19T01:13:53.000Z	0xcc390f23bf4f9f2e13a6eed61695c4dbb2e7d2d62897552f8e2297f7168acbdf
0x686bef2417b6dc32c50a3cbfbcc3bb60e1e9a15d	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	1001800387568823306491401380	7581676	0x000000c0f624da031e44661f23c2e5bdacc6dcf4	42	31511729	2023-06-19T01:35:45.000Z	0x84c7ee01f9649e3aaac40922dcda8fc07502b79aa71890633eebeddcdd632dc8
0x686bef2417b6dc32c50a3cbfbcc3bb60e1e9a15d	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	1001800493682943484488160126	8145377	0x000000c0f624da031e44661f23c2e5bdacc6dcf4	45	31522509	2023-06-19T07:41:59.000Z	0x9605251cc6527ccc0ddef7c66b57f6eb0c755d8de3da5b56217a02002ae50370

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_avalanche.AToken_Burn_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_from`	`STRING`	Address originating the transfer or 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

address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0x46a51127c3ce23fb7ab1de06226147f446e4a857	0x5ba7fd868c40c16f7adfae6cf87121e13fc2f7a0	false	1047134600750891899933890878	2870	12	36710379	2023-10-21T00:02:05.000Z	0x2fef0e06ae4fdf5b07734c0de628185ff121829f4c2a42d593bb52826e82fc82
0x46a51127c3ce23fb7ab1de06226147f446e4a857	0x5ba7fd868c40c16f7adfae6cf87121e13fc2f7a0	false	1047135237787586335534931489	97335	137	36711548	2023-10-21T00:42:10.000Z	0x5b3a95d13232a38c1f849bea1f94c91192f2527fb54fde2c2ff19f0764bccbf9
0x686bef2417b6dc32c50a3cbfbcc3bb60e1e9a15d	0x5ba7fd868c40c16f7adfae6cf87121e13fc2f7a0	false	1001858174835740061808627519	1	13	36714121	2023-10-21T02:10:04.000Z	0x8053fc039d30ed5e8e3cdeb889bec69b6f70cafd086a9f846c1ea17b45818e66

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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_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	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x359061180839f6d9904f4020d79deabd21f2f213	0x01d83fe6a10d2f2b7af17034343746188272cac9	0x359061180839f6d9904f4020d79deabd21f2f213	false	863853395972970518	1	0x359061180839f6d9904f4020d79deabd21f2f213	56518729	2025-01-29T10:54:57.000Z	0x675c90d3d5d7ee222ab8904fb88c59788b7f590f5cbcdaabe61f02f2dcf77875
0xb88204292cb7f491b8f74a7a8fa5d603a92b5232	0x01d83fe6a10d2f2b7af17034343746188272cac9	0xb88204292cb7f491b8f74a7a8fa5d603a92b5232	false	1432185211892650	4	0xb88204292cb7f491b8f74a7a8fa5d603a92b5232	23839581	2022-12-19T14:32:30.000Z	0x61a118a4605c051a98daf19818465716187bac24320d66fcd2bccc3ccf3b17f7
0x973a74083b8e38453208d821587502a94d18ab44	0x01d83fe6a10d2f2b7af17034343746188272cac9	0x973a74083b8e38453208d821587502a94d18ab44	false	117052114541808508	1	0x973a74083b8e38453208d821587502a94d18ab44	23840321	2022-12-19T14:57:28.000Z	0x25515196e901c2b3f8fe0af8a3a15ea0508eff79a8361daff43ebf7f7b4842b5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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_borrowRateMode`	`STRING`	Interest rate mode selected for the borrow operation. Numeric string value where ‘1’ represents stable rate and ‘2’ represents 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_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_borrowRateMode
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0xc7ffa5070a1cdb10dfcc6cc20a59d24c3fb54e05	false	375000000000000000000	17	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	19609111	6341381166055040658736611	0xc7ffa5070a1cdb10dfcc6cc20a59d24c3fb54e05	2022-09-06T17:01:23.000Z	0x4c0420791959a05a71603eeca31dd6217a69504a6163fa91aa38a55a71d1536b	2
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0xffbaa0de31cd06c0031682e6e991b2515e71192e	false	500000000000000000	9	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	19585831	3466583162931261627448689	0xffbaa0de31cd06c0031682e6e991b2515e71192e	2022-09-06T03:17:09.000Z	0x15a42acca0cd8cf9773b3dc0d0ee1dfdafb8b67456700b068316371177c5d41e	2
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0xe6163c56b77e22ba39653b9bb46abc9d9ed6c45b	false	180000000	16	0x50b7545627a5162f82a992c33b87adc75187b218	19600845	2503932750966485797825240	0xe6163c56b77e22ba39653b9bb46abc9d9ed6c45b	2022-09-06T12:14:01.000Z	0x60696f372f6bb471dbdeb5c1ed793510967ac3f6f74cff4a09b323657e18c792	2

Example Query

Query with partition filter

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

LendingPool_Deposit_event

Deposit events from lending pool contracts recording user supply transactions. Contains depositor address, reserve asset, deposit amount, beneficiary account, and optional referral code for tracking protocol liquidity provisioning.

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_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	792165504102091069	49	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	36523882	0x58e57ca18b7a47112b877e31929798cd3d703b0f	2023-10-16T13:30:00.000Z	0x7659949b14fc4dd587d0e9baa941e60aaa7f9c77a9bd094cfdde9c66fff99a20
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	517481196242862080	32	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	36511852	0x58e57ca18b7a47112b877e31929798cd3d703b0f	2023-10-16T06:36:49.000Z	0x7ddb1c8c232f57e4097a3e4796323eb8ca1d0e8eb46fe2d0f1d2d118bda73877
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	213263045842994430	25	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	36528972	0x58e57ca18b7a47112b877e31929798cd3d703b0f	2023-10-16T16:28:08.000Z	0x42080d1fd1b06b62a0e11fbe4f054ccf94d57dab715f5f41411f74a154d8c774

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_avalanche.LendingPool_Deposit_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_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
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	300000000000000000	0x2ecf2a2e74b19aab2a62312167aff4b78e93b6c5	59	270000000000000	7528773	0x22a1ead3d87a9d3143d43a8ec0a1ee2b23562f1c	2021-11-28T07:25:23.000Z	0x1f4d54401b20e1c7ee946654b41c1e5405c88cd2de063a59a38328951ed1a108
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	300000000000000000	0x2ecf2a2e74b19aab2a62312167aff4b78e93b6c5	98	270000000000000	7554161	0x22a1ead3d87a9d3143d43a8ec0a1ee2b23562f1c	2021-11-28T21:32:04.000Z	0x99f555cd328440ed077f7989267de6a2b37da8d6355d70a87b754a0a2aa4a503
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	300000000000000000	0x2ecf2a2e74b19aab2a62312167aff4b78e93b6c5	62	270000000000000	7557190	0x22a1ead3d87a9d3143d43a8ec0a1ee2b23562f1c	2021-11-28T23:12:59.000Z	0xc80e6dbc30621daecaa92b5e225704ec9e8af26790297658dda509d61100d5be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x358dbc0b83186591f3202400ffcd70c14c1ff9ae	false	57	13670840	0xc7198437980c041c805a1edcba50c1ce5db95118	0x9291bc4b9c3620b5ec37d51edc919c32545f2143	10140446871	2022-04-20T15:06:09.000Z	false	0xcd47823e3e62416ebd998b598d35c4ea290e0c56cde4d153669baec0fd839c81	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	142258184020420269213
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x450d85afc3f8afabaa1c7423fd8ca52544f47a9f	false	62	56937021	0xc7198437980c041c805a1edcba50c1ce5db95118	0x8ef9d10d953f4c23e94c065ed84b11c05128a301	1165895	2025-02-06T19:49:08.000Z	false	0x2f0b59fd459e5d1af1b32c3ec7abe055de2ec4dbad7923d6367a9e803c6756f3	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	52140382664744528
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x2550feebe8633f3fc435a3e6ff9b97140aa4b5da	false	27	10595743	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	0xb88041ec230c8cc942d76bed19ffc68568247345	2109091	2022-02-07T06:44:47.000Z	false	0xdf273334bab0a70748ad3b3a7035e0105cbb615babe7ec47c5dd196959b1e608	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	2214545

Example Query

Query with partition filter

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

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	block_timestamp	transaction_hash
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x0204e35b4c6531676b0d468ededcb0f0752699b8	false	2178767341926633749	28	0x0204e35b4c6531676b0d468ededcb0f0752699b8	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	7198728	2021-11-20T15:10:50.000Z	0xbbfb1ea9a5a5e3215c6bb1be9d11b0f6eda3fab5ef7183892f0dfceac32361fa
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x0fc92515c95532a875286bd1951a7ddf15b7013a	false	3500000867148962	170	0x0fc92515c95532a875286bd1951a7ddf15b7013a	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	7212328	2021-11-20T22:44:58.000Z	0x7e518f36d36e4e517cd87b1965b580fc59f775e8fca7956ecfac45a11f102e7c
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x1d11cbabdf4bccfee67d606c6c9c6c75e037aad0	false	51806766540635910	37	0x1d11cbabdf4bccfee67d606c6c9c6c75e037aad0	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	7178827	2021-11-20T04:05:01.000Z	0x00cecb88be60253b5e1d0b8c45f19d3a8e9428b88bfe62f1fe67ac8353e3bed6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	false	49	0x63a72806098bd3d9520cc43356dd78afe5d386d9	11530265	2022-03-01T03:28:30.000Z	0x002e57af0704f10abfbab9e2478bc07e1a36084bc0f282a6a6c50191c2637007	1000011214274486917304539880	30000000000000000000000000	1000000000000000000000000000
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	false	42	0x63a72806098bd3d9520cc43356dd78afe5d386d9	11547113	2022-03-01T12:57:25.000Z	0xbb107020e5cb762847374bf789ae1d23f7b1f91998b49a286cf276585a5aa51d	1000011214274486917304539880	30000000000000000000000000	1000000000000000000000000000
0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	false	46	0x63a72806098bd3d9520cc43356dd78afe5d386d9	11525986	2022-03-01T01:01:46.000Z	0x90b9fbe7e73d0c65259d8c496e77fbb70046c4fd26594c2ea0f76d90353a29ef	1000011214274486917304539880	30000000000000000000000000	1000000000000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_avalanche.LendingPool_ReserveDataUpdated_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
0x02921d9ebb1d85ea9afcd57a4c2c30c6372c6853	0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	38020603376607692	38	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	19300943	2022-08-30T04:43:11.000Z	0x75563805a35e00e048f836134eeb95875eff5c9713eaed718fac30b688d90c37
0x02921d9ebb1d85ea9afcd57a4c2c30c6372c6853	0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x58e57ca18b7a47112b877e31929798cd3d703b0f	false	12673105304746417	32	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	19300963	2022-08-30T04:43:51.000Z	0x0e08879f3e168b669a0213459546e1b88f199c2ff4bdc870d7f63b3066482ec7
0x063b284006519f9cd2b0a744bc7de252a29d1eac	0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	0x063b284006519f9cd2b0a744bc7de252a29d1eac	false	7549513848841408336	9	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	19328177	2022-08-30T19:55:24.000Z	0x932ef2a78de1614201dd6fc9d30a7643e2f40d064d3e6688fb757724c74116ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_avalanche.LendingPool_Withdraw_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_factor`	`STRING`	Reserve factor for the asset in basis points. String-encoded integer where 10000 equals 100%.

Sample Data

address	removed	in_asset	in_factor	log_index	block_number	block_timestamp	transaction_hash
0x230b618ad4c475393a7239ae03630042281bd86e	false	0xd586e7f844cea2f87f50152665bcbc2c279d8d70	3500	3	44187080	2024-04-14T09:39:40.000Z	0xd1b722002abb91aaa6da4e49ed112c69f03c2035d0539a555bbd1f49990e00d9
0x230b618ad4c475393a7239ae03630042281bd86e	false	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	3500	4	44187080	2024-04-14T09:39:40.000Z	0xd1b722002abb91aaa6da4e49ed112c69f03c2035d0539a555bbd1f49990e00d9
0x230b618ad4c475393a7239ae03630042281bd86e	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	3500	8	44187080	2024-04-14T09:39:40.000Z	0xd1b722002abb91aaa6da4e49ed112c69f03c2035d0539a555bbd1f49990e00d9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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
0x230b618ad4c475393a7239ae03630042281bd86e	false	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	0xdfe521292ece2a4f44242efbcd66bc594ca9714b	3	4607232	2021-09-20T13:23:41.000Z	0xeee08f32bc796543b17e766c52355dceb67523990bbea26b849f16bc919ca7a6	0x2920cd5b8a160b2addb00ec5d5f4112255d4ae75	0x66a0fe52fb629a6cb4d10b8580afdffe888f5fd4	0x6724e923e4bb58fcdf7cee7a5e7bbb47b99c2647
0x230b618ad4c475393a7239ae03630042281bd86e	false	0x63a72806098bd3d9520cc43356dd78afe5d386d9	0xd45b7c061016102f9fa220502908f2c0f1add1d7	3	4607228	2021-09-20T13:23:29.000Z	0x9dcd392af519a2f01341e1cbbcb78778475175b23af679f825f79dbd20814da6	0x66904e4f3f44e3925d22ceca401b6f2da085c98f	0x8352e3fd18b8d84d3c8a1b538d788899073c7a8e	0x6724e923e4bb58fcdf7cee7a5e7bbb47b99c2647
0x230b618ad4c475393a7239ae03630042281bd86e	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0x53f7c5869a859f0aec3d334ee8b4cf01e3492f21	10	4607207	2021-09-20T13:22:58.000Z	0x18fc717b7680acb69faab2550e4325d3bfbdc76aa94b9887557d35c33ce5ae71	0x60f6a45006323b97d97cb0a42ac39e2b757ada63	0x4e575cacb37bc1b5afec68a0462c4165a5268983	0x6724e923e4bb58fcdf7cee7a5e7bbb47b99c2647

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_avalanche.LendingPoolConfigurator_ReserveInitialized_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_user`	`STRING`	Address of the user account associated with the transaction or protocol 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_v2_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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_user`	`STRING`	Address of the user account associated with the transaction or protocol 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_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_user	removed	in_index	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x2dc0e35ec3ab070b8a175c829e23650ee604a9eb	0xfcdb094854e00b4e2b916c3996029bf5b7480a0a	false	1008183139102657059300804230	2000000	6	12462610	2022-03-23T06:15:06.000Z	0x842c7306825fabe52ed7011fb188253103870d8c398f7bac116043ef7f441235
0x2dc0e35ec3ab070b8a175c829e23650ee604a9eb	0x1fbdc311eb546a92b54fd8919fa7058e41822fa6	false	1008183259051872976714470467	9978379	18	12463033	2022-03-23T06:29:28.000Z	0x5cdb94acd1486a53ce1f460c046255e3db9d343822c3b99224046e9ab8be8f1a
0x4e575cacb37bc1b5afec68a0462c4165a5268983	0xe1ab85e458ebea43c5302ce84f5a89cb22fe351a	false	1008356937705404048321805550	169639372378243384	15	12466646	2022-03-23T08:33:09.000Z	0xe286d8d0b7eb443a07cf5e24fe4b4ace16f3f66b9be4c106b5f2001c76ca7e74

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_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_from`	`STRING`	Address originating the transfer or 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_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

address	in_from	removed	in_index	in_value	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x4e575cacb37bc1b5afec68a0462c4165a5268983	0x39b47aa07f2994a797f6656688ed86ab2947f873	false	1004630624380533248814753388	60245325402869775	104	7651690	0x39b47aa07f2994a797f6656688ed86ab2947f873	2021-12-01T04:03:57.000Z	0x18fa402eac78f217aa7ca78e03853eac34f9917ffdd54f5b2b05ef186ac84194
0x4e575cacb37bc1b5afec68a0462c4165a5268983	0x11eb2fbd13c0ffb0862731cfab7e409a05ce1e7f	false	1004631277541769027411236739	105837000000000000	57	7652259	0x11eb2fbd13c0ffb0862731cfab7e409a05ce1e7f	2021-12-01T04:22:58.000Z	0x1cf5794fb17e4c91ae5f9938e1618324eb4809381365bff3933cfea6aa93e491
0x4e575cacb37bc1b5afec68a0462c4165a5268983	0x49ffe4429610efa450b0654ea9a20e0eb4960920	false	1004637349702215612030635807	5016746932122908000	84	7657559	0x49ffe4429610efa450b0654ea9a20e0eb4960920	2021-12-01T07:20:14.000Z	0x5bc9da977f66d6c0007359ecf0cf7af6ee78dcc502e514b7e24852e5a798d884

Example Query

Query with partition filter

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

WrappedTokenGatewayV2_withdrawETH_function

Withdrawal transactions from Aave V2’s Wrapped Token Gateway on Avalanche, converting aTokens back to native AVAX. Records include withdrawal amounts, recipient addresses, and transaction execution details for analyzing protocol exit flows.

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
667305	0xf902a220ca495f96e3b886cea428001e3c978e66	true	508112	0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	140000000000000000	0x80500d20	0x68c815cb8c8390bc3f2ce99265044dec9d350c49	53333550	0xf902a220ca495f96e3b886cea428001e3c978e66	2024-11-20T21:16:57.000Z	0x396e04a930ff15489c05bc650aeb3b2f748febfb4a30196a699063ad69718de5
786613	0x582faeb9a8e10f5efad9a3faadd3ec91f6d55551	true	599164	0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x68c815cb8c8390bc3f2ce99265044dec9d350c49	53304715	0x582faeb9a8e10f5efad9a3faadd3ec91f6d55551	2024-11-20T04:56:38.000Z	0xa7296502d46b2295a87acc0128875e9f19189b3d4827dfb0a9d19acc24fd236f
516175	0x86cf8514ec1c7bf133f2834c7a8844298edde754	true	394866	0x4f01aed16d97e3ab5ab2b501154dc9bb0f1a5a2c	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x68c815cb8c8390bc3f2ce99265044dec9d350c49	44484528	0x86cf8514ec1c7bf133f2834c7a8844298edde754	2024-04-21T13:59:34.000Z	0xa356bbbcd3c89f6535b1011778a894e8d2e410ef1b858e8fc11b550d6f0468a4

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_Burn_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV2_withdrawETH_function

​Tables

​AToken_Burn_event

​AToken_Mint_event

​IncentivesController_RewardsClaimed_event

​LendingPool_Borrow_event

​LendingPool_Deposit_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV2_withdrawETH_function

Tables

AToken_Burn_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV2_withdrawETH_function