aave_v2_ethereum

Tables

AMMLendingPool_Borrow_event

Borrow event records from Aave V2’s AMM (Automated Market Maker) lending pools on Ethereum, capturing loan originations with borrowed asset, amount, interest rate mode, and user addresses. Used for analyzing borrowing activity, interest rate dynamics, and leverage patterns in Aave’s liquidity protocol.

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
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x7a70f84dd808f8e75efee126ea48ebe7aa12e4e4	false	2200000000	262	0xdac17f958d2ee523a2206206994597c13d831ec7	12977992	38600427394985915769394945	0x7a70f84dd808f8e75efee126ea48ebe7aa12e4e4	2021-08-07T12:45:28.000Z	0xb89808aaaeb1d71608184c77bc2840d1a04586d6ffa02b0c802a876592dc35f0	2
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x62d6019237378ed44e67652c94fae7fda2cdf4fd	false	37541054654443080000000	602	0x6b175474e89094c44da98b954eedeac495271d0f	12977134	35137845694638625851393298	0x62d6019237378ed44e67652c94fae7fda2cdf4fd	2021-08-07T09:35:09.000Z	0x93cc94b0ccdd213ed7dfaeb2800b793c04da7fcc65fa1623fb877698c17ea6b2	2
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x98578d10dc7fc755ea00682bd4e931b798219892	false	7001224936684205000000	445	0x6b175474e89094c44da98b954eedeac495271d0f	12975722	34385061358507932341116570	0x98578d10dc7fc755ea00682bd4e931b798219892	2021-08-07T04:16:49.000Z	0x9a9c8512bba5bc15170ddff7307bdc523834bd09d54da62c58a6bfc151ec76a6	2

Example Query

Query with partition filter

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

AMMLendingPool_Deposit_event

Deposit events from Aave V2’s Automated Market Maker (AMM) lending pool on Ethereum, capturing user deposits of assets like WETH and USDC into liquidity reserves. Used for tracking capital inflows, analyzing lending liquidity dynamics, and identifying deposit patterns including referral-driven deposits and deposits made on behalf of other addresses.

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
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0xcc9a0b7c43dc2a5f023bb9b738e45b0ef6b06e04	false	500000000000000000	290	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	14192142	0x474f2587151e0d3136eaef58e983419dfe27a8fb	2022-02-12T15:46:51.000Z	0x92283b5cc6589fa1fead8fbbe486535bae5923eb5506d4494e63237fdd954119
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0xf8f26686f1275e5aa23a82c29079c68d3de4d3b4	false	70000000000	679	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	12649196	0xf8f26686f1275e5aa23a82c29079c68d3de4d3b4	2021-06-17T02:12:01.000Z	0x9954393850358b95a9fb5566c6a9ee89d5ab8d407d5cd5f712beba475caf1dc3
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x4da5dc85136bb3a3b896ad4b352c95e40a5fc26c	false	20000000	293	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	12652061	0x4da5dc85136bb3a3b896ad4b352c95e40a5fc26c	2021-06-17T12:51:59.000Z	0x5709217c6707999b23d1e7a8fc5bd481f253debb2c1c9e4e7d4cb034c92f8071

Example Query

Query with partition filter

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

AMMLendingPool_FlashLoan_event

Flash loan events from Aave V2’s Automated Market Maker (AMM) lending pool on Ethereum, capturing borrowed asset, amount, premium fees, initiator and target addresses. Used for analyzing flash loan arbitrage activity, fee revenue, and protocol utilization patterns.

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
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	294839036500073090338	0xf1859145906b08c66fb99e167a1406ac00a2079e	374	265355132850065781	16725369	0xf1859145906b08c66fb99e167a1406ac00a2079e	2023-02-28T08:08:11.000Z	0xf71d740dd118ba2c17c43a29334cae4edf84cc7ca47fdb8226667d2c41985793
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	85223215668520845767	0xf1859145906b08c66fb99e167a1406ac00a2079e	119	76700894101668761	16728530	0xf1859145906b08c66fb99e167a1406ac00a2079e	2023-02-28T18:46:47.000Z	0x0362146061f1fac1f41f1810c3dc145f729a464033fb81143774638957d67ceb
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	56100623611992336751	0x638b129ab6d241ec2f890aa3af197bf84b5ff1bb	503	50490561250793103	17177985	0x638b129ab6d241ec2f890aa3af197bf84b5ff1bb	2023-05-03T04:59:11.000Z	0x63b9efb3291bf5d068f7e7d0bf115a3da7944e6688bcff4b086cc8a5efa3b2ae

Example Query

Query with partition filter

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

AMMLendingPool_Repay_event

Loan repayment events from Aave V2’s Automated Market Maker (AMM) lending pool on Ethereum. Tracks debt repayments with borrower address, asset reserve, and repaid amount for analyzing loan lifecycle and protocol debt management.

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
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x2e6b28fda29e5328acd9cadaf6b5900daf5cb576	false	5000000000000000000000	184	0x2e6b28fda29e5328acd9cadaf6b5900daf5cb576	0x6b175474e89094c44da98b954eedeac495271d0f	12842622	2021-07-17T06:14:08.000Z	0x153fd1deffa043c555fc5fe3b01d862bf290c37b87aad4dbcb95e2933407e152
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x98578d10dc7fc755ea00682bd4e931b798219892	false	1207820914576911455374	345	0x98578d10dc7fc755ea00682bd4e931b798219892	0x6b175474e89094c44da98b954eedeac495271d0f	12842801	2021-07-17T06:57:32.000Z	0xc32e455ac382de277b7e5d3d58ad393fc45fd7084d1ed738bd601a41a3160edb
0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x98578d10dc7fc755ea00682bd4e931b798219892	false	1474242168632194057757	285	0x98578d10dc7fc755ea00682bd4e931b798219892	0x6b175474e89094c44da98b954eedeac495271d0f	12842825	2021-07-17T07:01:55.000Z	0x09b7bda23a33f49943dd7ebb081b8c606d786deed2e099a81a0231e0a1dae69e

Example Query

Query with partition filter

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

AMMLendingPool_Withdraw_event

Withdrawal events from Aave v2 AMM (Automated Market Maker) lending pools on Ethereum, tracking when users remove deposited assets with user addresses, reserve token addresses, and withdrawal amounts. Used for analyzing liquidity removal patterns and user behavior in Aave’s AMM-specific lending pools.

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
0xc6db14ecb0a091db99c97647f10ec12f408099f3	0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0xc6db14ecb0a091db99c97647f10ec12f408099f3	false	99653329	366	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	14950230	2022-06-12T12:52:33.000Z	0x1e76ba99dc789330b526fdba668ad7f2726251f9c173954f53f8979a22bd60ed
0x25beda673690ecd0a8a64d35ab228fc2e1c0048a	0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0x25beda673690ecd0a8a64d35ab228fc2e1c0048a	false	100784152	221	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17466591	2023-06-12T21:19:11.000Z	0xafe3c5b58db88fcdbc13605a4b18904cef4c7e46455a64e078cf9673c250e846
0xe5c0c893f318acbbb5ac5e5a28ec0fe609e711a0	0x7937d4799803fbbe595ed57278bc4ca21f3bffcb	0xe5c0c893f318acbbb5ac5e5a28ec0fe609e711a0	false	139168513	233	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17463688	2023-06-12T11:29:11.000Z	0x9db66234af0f3b38678dfb3e57f740d4e9e83691aa066ba4ddd2037bdab3a818

Example Query

Query with partition filter

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

AMMLendingPoolConfigurator_ReserveInitialized_event

Reserve initialization events from Aave V2’s AMM market configurator contract on Ethereum, capturing when new assets are added to the protocol with their associated aToken, debt token, and interest rate strategy addresses. Used for tracking protocol expansion and market configuration 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_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
0x23a875ede3f1030138701683e42e9b16a7f87768	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xf9fb4ad91812b704ba883b11d2b576e890a6730a	29	11998921	2021-03-08T16:31:36.000Z	0x2e97222ee57f49fac87f3c21e1906c2bb02cf323d8da5112b495b5ef93339185	0x118ee405c6be8f9ba7cc7a98064eb5da462235cf	0xa4c273d9a0c1fe2674f0e845160d6232768a3064	0x8d02bac65cd84343ef8239d277794bad455ce889
0x23a875ede3f1030138701683e42e9b16a7f87768	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0x17a79792fe6fe5c95dfe95fe3fcee3caf4fe4cb7	41	11998921	2021-03-08T16:31:36.000Z	0x2e97222ee57f49fac87f3c21e1906c2bb02cf323d8da5112b495b5ef93339185	0x04a0577a89e1b9e8f6c87ee26cce6a168fffc5b5	0xdcfe9bfc246b02da384de757464a35efca402797	0x79f40cdf9f491f148e522d7845c3fbf61e56c33f
0x23a875ede3f1030138701683e42e9b16a7f87768	false	0x6b175474e89094c44da98b954eedeac495271d0f	0x79be75ffc64dd58e66787e4eae470c8a1fd08ba4	33	11998921	2021-03-08T16:31:36.000Z	0x2e97222ee57f49fac87f3c21e1906c2bb02cf323d8da5112b495b5ef93339185	0x8da51a5a3129343468a63a96ccae1ff1352a3dfe	0x3f4fa4937e72991367dc32687bc3278f095e7eaa	0x79f40cdf9f491f148e522d7845c3fbf61e56c33f

Example Query

Query with partition filter

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

AMMVToken_Burn_event

Variable debt token burn events from Aave V2 on Ethereum, recording when users repay variable-rate borrows across different asset pools. Contains user addresses, burned amounts, and liquidity index values for tracking debt repayment 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_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
0x3f4fa4937e72991367dc32687bc3278f095e7eaa	0xd78f2899070a174cb69191f44711715a792035bc	false	1034362638886125266890675861	2199236539566127504984	85	12959334	2021-08-04T15:01:06.000Z	0x15b792729bcaf692753898e0e51f8f476b83c3458fd3dcc45399f3201c9447b2
0xdcfe9bfc246b02da384de757464a35efca402797	0xff85080e72df23412190e8c661c59be89a0aac90	false	1045196631086178087725753865	354153215	256	12956064	2021-08-04T02:29:41.000Z	0x4dbd63995b6eaa564917a2ec0cee37a7ab156f1a1e12fe7d4f1998a35b9a74f2
0xcfdc74b97b69319683fec2a4ef95c4ab739f1b12	0x662146dad213ea5a74f48da75e18be241632994b	false	1083179957454234630975397439	8995897725	210	14809530	2022-05-20T06:26:26.000Z	0x84e15a2c7e10f7e1e44a80980243a1c36e5686cf4d494e8d8dcd5a94a216de98

Example Query

Query with partition filter

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

AMMVToken_Mint_event

Variable debt token mint events from Aave V2 on Ethereum, recording when users borrow assets at variable interest rates. Tracks borrowed amounts, borrower addresses, and debt token issuance for analyzing protocol borrowing 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_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
0xcfdc74b97b69319683fec2a4ef95c4ab739f1b12	0x799c1497bc63e6c34be032e7933adde7a2459182	false	1034620738951744197414714624	79241162	232	12628249	0x799c1497bc63e6c34be032e7933adde7a2459182	2021-06-13T20:21:31.000Z	0x58e18cbeab3122c4cfc42802417e77825cdd0d43e3dbd1140426fdbec792ce41
0xcfdc74b97b69319683fec2a4ef95c4ab739f1b12	0xc9ac2940e99c00d4c188c3b446b08c03502ee568	false	1034551026284971034822399286	7994666865	195	12624206	0xc9ac2940e99c00d4c188c3b446b08c03502ee568	2021-06-13T05:16:03.000Z	0xb7f3640a249188df7ec2ef112d8b405cef876d1032bc040294be565330912369
0xdcfe9bfc246b02da384de757464a35efca402797	0x8713e5c7fd6246c5694cba17d6d16e5fe0d0c4e3	false	1033597593180647505489829580	22000000000	76	12626727	0x8713e5c7fd6246c5694cba17d6d16e5fe0d0c4e3	2021-06-13T14:43:50.000Z	0x920fff56ba40d00b846f400869ef9a8b615e1d0c1b740082cc7276c39480f4bc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.AMMVToken_Mint_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_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
0xffc97d72e13e01096502cb8eb52dee56f74dad7b	0x04ada96a5c5a1fdf7e315f14aeb2ce9eb61efb5e	false	1000009515901455747680659989	32820497211244776822	0x04ada96a5c5a1fdf7e315f14aeb2ce9eb61efb5e	163	11440120	2020-12-12T19:47:39.000Z	0xd9b1c2fbd7c36503711499793b7a18c3bb51cc4053204c9d01d496050394158f
0x028171bca77440897b824ca71d1c56cac55b68a3	0x04ada96a5c5a1fdf7e315f14aeb2ce9eb61efb5e	false	1001839613610192365757908008	2000000000000000000000	0x04ada96a5c5a1fdf7e315f14aeb2ce9eb61efb5e	116	11434859	2020-12-12T00:24:56.000Z	0x6835b52ff9e47c3cded4c9e5250d8e59734ccff87ddf869523342a6627651aaa
0x028171bca77440897b824ca71d1c56cac55b68a3	0x04ada96a5c5a1fdf7e315f14aeb2ce9eb61efb5e	false	1001844137399796535676098382	3432559616733469910850	0x04ada96a5c5a1fdf7e315f14aeb2ce9eb61efb5e	84	11435105	2020-12-12T01:18:37.000Z	0x5d82ab61fa41aa73c47c120979ee91b1a46f7246546af2defb11c77f3df1ecab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	false	1004891676688872045600892288	3437	83	22321978	2025-04-22T03:53:23.000Z	0x58230510cddc13357acce73e1ed14382069b53bc16975722985cfda1cce9c100
0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	false	1004891677060821228292015307	429	38	22322184	2025-04-22T04:34:35.000Z	0x2dc9675f1174b43f4ff96007f28f0c7fbada2fcc6689d6fc78a57e4cf5f24526
0x9ff58f4ffb29fa2266ab25e75e2a8b3503311656	0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c	false	1004891680197436763268871197	3620	124	22323965	2025-04-22T10:31:59.000Z	0x178e2d2f512c83a45719020d83ba04f46914b5e70419123b0cd2b35e7702e14c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x9349e39a43e837e69eb03f95b8186221f286397d	0xd784927ff2f95ba542bfc824c8a8a98f3495f6b5	0x9349e39a43e837e69eb03f95b8186221f286397d	false	59809986164969532	119	0x9349e39a43e837e69eb03f95b8186221f286397d	19110881	2024-01-29T08:05:59.000Z	0xa2ee999f788c9538b3b4775acdaf956012646c9ad93592f6b7856f814d62d89f
0xabc3b8a22b766b9c5bbe73724d2f35f81359e72a	0xd784927ff2f95ba542bfc824c8a8a98f3495f6b5	0xabc3b8a22b766b9c5bbe73724d2f35f81359e72a	false	152778046453528070	220	0xabc3b8a22b766b9c5bbe73724d2f35f81359e72a	19110238	2024-01-29T05:56:23.000Z	0x2b001a56f4eb922fb113021941e4de32d5467939c2a138127e3407ee88d6ced6
0xd79e338667aeb42fb8f71c03b815d06bb8da968d	0xd784927ff2f95ba542bfc824c8a8a98f3495f6b5	0xd79e338667aeb42fb8f71c03b815d06bb8da968d	false	3929929720563729204	205	0xd79e338667aeb42fb8f71c03b815d06bb8da968d	19111503	2024-01-29T10:11:11.000Z	0x7e8693747eeb9a15f5a63e983aab31be1b42c524524ba0fefe865499e440bcff

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x05656db19ec9ff8dfb437475b3d76ca9a29e968f	false	240714025	14	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18455167	9630234159052435279788860	0x05656db19ec9ff8dfb437475b3d76ca9a29e968f	2023-10-29T10:12:11.000Z	0x379a5fd4020956648b3152c5e9d2deac387e62e461b5481e915dbb4643c8e21a	2
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0xe8cfad4c75a5e1caf939fd80afcf837dde340a69	false	87295838	29	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18456782	9650145990347771100449343	0xe8cfad4c75a5e1caf939fd80afcf837dde340a69	2023-10-29T15:37:59.000Z	0x61b49d2ed8c2233dd871976329a5a9c2394debc681bb88b3ef453ac36ad9eba5	2
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0xe8cfad4c75a5e1caf939fd80afcf837dde340a69	false	405957444	21	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18458425	9712545308308131270994011	0xe8cfad4c75a5e1caf939fd80afcf837dde340a69	2023-10-29T21:09:47.000Z	0x8cb39dbc606ab7694783d336cce5b0d9589d1d11bca68f731dc5405f2f416ffe	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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	in_referral	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x6ada4e93aa63f395a66444db475f0f56f4f3ca4f	false	101178774669497576218	119	0x03ab458634910aad20ef5f1c8ee96f1d6ac54919	0	12672309	0x6ada4e93aa63f395a66444db475f0f56f4f3ca4f	2021-06-20T16:42:14.000Z	0x93df81717fb8bd10f95d06ec7f4cd5a82eae5a22c83e3ffc68d20bc319f08555
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x0083ba4df668a42f3d96a6c95700562618c14b2a	false	115330	466	0x056fd409e1d7a124bd7017459dfea2f387b6d5cd	3228	12670656	0x0083ba4df668a42f3d96a6c95700562618c14b2a	2021-06-20T10:15:40.000Z	0xfaae87debdf18a60620cc4b25a1bb7909420cf2eeaa36bcb3589965010dcce96
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x0487fed00e5f5e81507b1cd6e851b741a4a020fd	false	8736667	136	0x056fd409e1d7a124bd7017459dfea2f387b6d5cd	0	12674248	0x0487fed00e5f5e81507b1cd6e851b741a4a020fd	2021-06-20T23:38:28.000Z	0x350d61a515ed616da263e782d36d0b51301e58920da1b326c29cee7fab5fcc88

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	6111000000	0x135896de8421be2ec868e0b811006171d9df802a	303	5499900	17982856	0xd5c66bb825cf398d2b2035dcd8cdd102d9704f1c	2023-08-24T06:44:35.000Z	0x8c9a81975444c3807bfdff838d68f456206bc5d0722cb01ff039e06f77a41274
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	false	0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9	100615824200788740000	0x135896de8421be2ec868e0b811006171d9df802a	197	90554241780709866	17985455	0x68465085891466fae2aacbf1e98c0f38d9b0ea7c	2023-08-24T15:28:11.000Z	0xb018a7a70a6208e3a6a9b475e1da0975bf890e8134a6e232b92ad8e71aa3eb08
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	297829657006734000000	0x135896de8421be2ec868e0b811006171d9df802a	56	268046691306060600	17986970	0xcd003b9ce7b1c64b57857710beccdda8d982a740	2023-08-24T20:34:11.000Z	0xda7489fc9c2520333aca6bffc44c875a44e19aaf5c6baff41103c605c8ace435

Example Query

Query with partition filter

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

LendingPool_LiquidationCall_event

Liquidation events from Aave-compatible lending protocols when undercollateralized positions are closed. Records liquidator, borrower, debt repaid, collateral seized, and asset addresses for tracking protocol risk and liquidation bot activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAsset`	`STRING`	Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtToCover`	`STRING`	Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
`in_liquidatedCollateralAmount`	`STRING`	Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveAToken`	`BOOL`	Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0xe77be5f59ee555427272d1bcbee00dd845d89eaa	false	25	17360364	0x853d955acef822db058eb8505911ed77f175b99e	0x80d4230c0a68fc59cb264329d3a717fcaa472a13	13721372699421055566541	2023-05-28T22:02:59.000Z	false	0x442a2b948d9926dd88dfaac5e6e6d063feb589f3011879181353eb985794bfd0	0x6b175474e89094c44da98b954eedeac495271d0f	14709297602741462142923
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x2e271003e1638f977295f91d2ef73916169771bc	false	22	16275054	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x170567524b6906c44563b0fe0a027f5d1ddd115f	376151598	2022-12-27T09:01:35.000Z	false	0x796c0e0316b0b8b78ed931a7fb06e68f5b23261de5cc124c0ca85448b598d59e	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	393078419
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x7b62478ab79d5088cebde1d53489e2fb5fa25268	false	42	14858296	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x07197a25bf7297c2c41dd09a79160d05b6232bcf	312240769	2022-05-28T04:52:34.000Z	false	0x60bf135aa374e2da175c82ed21b6e1d0830149ebcb768a85bbeaf7ffc31a6edc	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	187582488626903695

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x03b08491fd4cbeb80d24b823ff4c542d8ff67382	false	6000066290	99	0x03b08491fd4cbeb80d24b823ff4c542d8ff67382	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	11533043	2020-12-27T02:07:46.000Z	0x2b397568456b1524d9e08d851089f242b80c5c64660c9d19742fb92146dacb6e
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x0afde4bfb50f3b908440c7e04ba7d45aa9f5ce7f	false	1644940352857799384	308	0x0afde4bfb50f3b908440c7e04ba7d45aa9f5ce7f	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e	11536766	2020-12-27T15:56:36.000Z	0xfd574937765962db78957c5dcacf6515011f14617efbe21cf52bc3958589d652
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x0afde4bfb50f3b908440c7e04ba7d45aa9f5ce7f	false	1000000000000000000000	152	0x0afde4bfb50f3b908440c7e04ba7d45aa9f5ce7f	0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f	11536758	2020-12-27T15:55:32.000Z	0xd1bff373a53f02c9b61789e7593ce16aa32d939df27bd457903a6749b6b5d120

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

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

Columns

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

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_stableBorrowRate	in_variableBorrowRate	in_variableBorrowIndex
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	false	314	0x514910771af9ca656af840dff83e8264ecf986ca	14720985	2022-05-06T02:45:54.000Z	1297824751039886163197828	0x00c13944640cd7d89098b998f226ae3ff8bfdf797b37f06671883ded7f8f84d1	1000437367106217226522021090	52686102278520402084971660	15880271594964281459480162	1004301773754550355578846254
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	false	366	0x514910771af9ca656af840dff83e8264ecf986ca	14721299	2022-05-06T03:54:27.000Z	1297787824781093516613450	0x2c778e60afbc06f67ba99c687ef2e34bdd6bc6a93b45457e23d3f8f8b6d400ea	1000437536445633962053095801	52685779299246073630411623	15880045509472251541288136	1004303853809019299893640134
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	false	349	0x514910771af9ca656af840dff83e8264ecf986ca	14722274	2022-05-06T07:41:25.000Z	1300592080664269289531798	0x69d03b77770dcb950591e22c95ef18cd9418c4d8134000f0c7d54c75278c4c7d	1000438097106697496401017908	52710292729825689954468016	15897204910877982968127611	1004310740729742749964932503

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x666b8215ba205aa633f0b7d9965639c68d109666	0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0x202e2d5afb987df3930c73c3df5adfe280f04b82	false	7648	319	0x056fd409e1d7a124bd7017459dfea2f387b6d5cd	16322021	2023-01-02T22:17:35.000Z	0x188aa0ed7c12749fb984fa12b7022b53c49e295c956cbf645e03ca96f5cd486c
0xc7d64d4402702f6e068103e0e2af0998c063c5aa	0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0xc7d64d4402702f6e068103e0e2af0998c063c5aa	false	100392	201	0x056fd409e1d7a124bd7017459dfea2f387b6d5cd	16315451	2023-01-02T00:17:59.000Z	0x46a671d448104f8bf6aa7ead2f671dd14fcf6a662998821c097debed3a5e2ba4
0xc53310c800778e7983d63b24481c2cb8bbfb336c	0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	0xc53310c800778e7983d63b24481c2cb8bbfb336c	false	640284382673289400046	78	0x0d8775f648430679a709e98d2b0cb6250d2887ef	16315761	2023-01-02T01:19:59.000Z	0xca0b4f800a1fafdff87692996d8032b5e9d8e0be57f4f85a5d66a855d24516d8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_ethereum.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
0x311bb771e4f8952e6da169b425e7e92d6ac45756	false	0x853d955acef822db058eb8505911ed77f175b99e	9500	24	19912526	2024-05-20T17:08:23.000Z	0x8f1a23296f488364a9c6d2fc3cee852fd10f310094da3f9e9fd038778d61dc5e
0x311bb771e4f8952e6da169b425e7e92d6ac45756	false	0x056fd409e1d7a124bd7017459dfea2f387b6d5cd	9500	22	19912526	2024-05-20T17:08:23.000Z	0x8f1a23296f488364a9c6d2fc3cee852fd10f310094da3f9e9fd038778d61dc5e
0x311bb771e4f8952e6da169b425e7e92d6ac45756	false	0x8e870d67f660d95d5be530380d0ec0bd388289e1	9500	21	19912526	2024-05-20T17:08:23.000Z	0x8f1a23296f488364a9c6d2fc3cee852fd10f310094da3f9e9fd038778d61dc5e

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x311bb771e4f8952e6da169b425e7e92d6ac45756	false	0xd46ba6d942050d489dbd938a2c909a5d5039a161	0x1e6bb68acec8fefbd87d192be09bb274170a0548	262	12891159	2021-07-24T20:22:25.000Z	0x55132524308d603337bb8f55d828be8b0d69a59128add5bb82fd7152fa5dd951	0x18152c9f77dadc737006e9430db913159645fa87	0xf013d90e4e4e3baf420dfea60735e75dbd42f1e1	0x9a8ca7e1d64afff2664443b3803f280345f5336b
0x311bb771e4f8952e6da169b425e7e92d6ac45756	false	0xc18360217d8f7ab5e7c516566761ea12ce7f9d72	0x9a14e23a58edf4efdcb360f68cd1b95ce2081a2f	300	14338029	2022-03-07T06:02:56.000Z	0x47c2b4fc4c0226373a0ad1a86249f4668519447bac3504ec1cb928a9c221d35a	0x34441ffd1948e49dc7a607882d0c38efd0083815	0x176808047cc9b7a2c9ae202c593ed42ddd7c0d13	0xb2ed1ece1c13455ce9299d35d3b00358529f3dc8
0x311bb771e4f8952e6da169b425e7e92d6ac45756	false	0x853d955acef822db058eb8505911ed77f175b99e	0xd4937682df3c8aef4fe912a96a74121c0829e664	86	13207481	2021-09-11T23:42:46.000Z	0x120017e1789e029a20f06c2403119a63b1541ef234d87b753edb99d7aa227843	0x3916e3b6c84b161df1b2733dffc9569a1da710c2	0xfe8f19b17ffef0fdbfe2671f248903055afaa8ca	0xb0a73ac3b10980a598685d4631c83f5348f5d32c

Example Query

Query with partition filter

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

stkAAVE_RewardsClaimed_event

Staking reward claim events from Aave V2’s stkAAVE (staked AAVE) contract on Ethereum, capturing when users collect accrued AAVE token incentives from staking. Used for tracking staker reward distribution patterns and staking program participation.

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_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_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x131af6ec274845c29d8a23aed0bca4b63955c71e	0x4da27a545c0c5b758a6ba100e3a049001de870f5	0x131af6ec274845c29d8a23aed0bca4b63955c71e	false	212097300000000000	146	21044981	2024-10-25T20:20:23.000Z	0xba11408abe61385d2573ae75feb69a8220c797458d59e9c06176ae6d89f3010a
0x136aea6a78d2014e1e5263b98dcfbbcb49f2b012	0x4da27a545c0c5b758a6ba100e3a049001de870f5	0x136aea6a78d2014e1e5263b98dcfbbcb49f2b012	false	610867815865229175	372	21039296	2024-10-25T01:18:47.000Z	0x070b118ed4bb52ffc8241e8ec8d8e35af69258a55864e67183c78d6b72e9c5ed
0x215f5d8b4a0548dbfaa30c0844f3e8352152fba6	0x4da27a545c0c5b758a6ba100e3a049001de870f5	0x215f5d8b4a0548dbfaa30c0844f3e8352152fba6	false	1103755010129374774	145	21040598	2024-10-25T05:40:35.000Z	0xfa8996a998a531810cb16afcca0e65fe39c94e9eee3f5c328b975a4aab894ed0

Example Query

Query with partition filter

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

stkAAVEwstETHBPTv2_RewardsClaimed_event

Reward claim events from Aave V2’s staked AAVE-wstETH Balancer Pool Token (BPT) staking contract on Ethereum. Tracks users claiming their staking rewards with recipient addresses and claimed amounts for analyzing staking incentive distribution.

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_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_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x71f12a5b0e60d2ff8a87fd34e7dcff3c10c914b0	0x9eda81c21c273a82be9bbc19b6a6182212068101	0x71f12a5b0e60d2ff8a87fd34e7dcff3c10c914b0	false	24242174291047987259	823	20137428	2024-06-21T03:31:59.000Z	0x610fa9dc82c67411fb316ada4d2f94984f6a85d59a369baf7007fec1c6c5d69b
0xcb926f497763ea5cf993912a442431e6a91d5a64	0x9eda81c21c273a82be9bbc19b6a6182212068101	0xcb926f497763ea5cf993912a442431e6a91d5a64	false	10996653811344273136	265	20682593	2024-09-05T06:27:59.000Z	0x535a96b674030ac7e8780526fa30505d2a8ebb921d4de0ffbd22098762a22915
0xd3ef08d4fb48a24efe72b88401dd7daafa360523	0x9eda81c21c273a82be9bbc19b6a6182212068101	0xd3ef08d4fb48a24efe72b88401dd7daafa360523	false	467851970322016527	710	22754570	2025-06-21T18:17:59.000Z	0xac5122101e6b7bb4fddb8c9887a1d093f866f7304443bbb26353730f86b8bd17

Example Query

Query with partition filter

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

stkABPT_RewardsClaimed_event

Reward claim events from Aave V2’s staked ABPT (Aave Balancer Pool Token) contract on Ethereum, tracking user withdrawals of staking incentives. Used for analyzing reward distribution patterns and staker behavior in Aave’s Safety Module.

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_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_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x1a92e2b2db688d5ce3d24b58dbcc7716912873d0	0xa1116930326d21fb917d5a27f1e9943a9595fb47	0x1a92e2b2db688d5ce3d24b58dbcc7716912873d0	false	13079929882178410360	221	13806733	2021-12-15T01:10:03.000Z	0x0f1b231271e56b5344fa95e3e2f07250f2e2abab79625c9926c322afe9d00fcd
0xdf9924a483d946e8e2cc50652a6b3907e64edd5d	0xa1116930326d21fb917d5a27f1e9943a9595fb47	0xdf9924a483d946e8e2cc50652a6b3907e64edd5d	false	11034487282647965319	150	13812026	2021-12-15T20:59:14.000Z	0x7e91b6509189a19d8fdd34214445862c7334c55c8e91507fb1b1d7437a3d2bf8
0x329c54289ff5d6b7b7dae13592c6b1eda1543ed4	0xa1116930326d21fb917d5a27f1e9943a9595fb47	0x329c54289ff5d6b7b7dae13592c6b1eda1543ed4	false	161306306451834127096	282	13808940	2021-12-15T09:39:00.000Z	0xb4830d0f4bb13dcbce7206599a0a7b4baf7a7ac2413fbefa6c8f979d00ce3686

Example Query

Query with partition filter

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

stkGHO_RewardsClaimed_event

Reward claims from Aave’s staked GHO (stkGHO) staking contract on Ethereum, capturing when users collect their accrued staking rewards. Used for analyzing stkGHO staking participation and reward distribution patterns.

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_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_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xc99c3bedd99c8923a0f0b3a3b0a9dfe2d352288a	0x1a88df1cfe15af22b3c4c783d4e6f7f9e0c1885d	0xc99c3bedd99c8923a0f0b3a3b0a9dfe2d352288a	false	8237576991707776358	52	19581182	2024-04-04T08:22:47.000Z	0xb514c40401466935c1cce3147d094089f19ff583d088df1aec5140d2954b82cd
0x43917a8174465dc01522e8e14335eaa2cde33f6f	0x1a88df1cfe15af22b3c4c783d4e6f7f9e0c1885d	0x43917a8174465dc01522e8e14335eaa2cde33f6f	false	104302904334127673	203	19581635	2024-04-04T09:53:35.000Z	0x7f95f39f0df911c08d65d0f8f20c9dacca884ca010794e978176461f9879ee62
0xed3ac827c901ec17f875ce289754e061c804b67d	0x1a88df1cfe15af22b3c4c783d4e6f7f9e0c1885d	0xed3ac827c901ec17f875ce289754e061c804b67d	false	839183199012317265	78	19583588	2024-04-04T16:28:35.000Z	0xa711ac837b52728246716047f509581c8551b4c4ea090ea859b49cea061e2c02

Example Query

Query with partition filter

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

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0x3356ec1efa75d9d150da1ec7d944d9edf73703b7	0xbffa9f687ade110d442d3bdcc55d5613ac1ca3e8	false	304920392247829989206	169	12624202	2021-06-13T05:15:07.000Z	7777672431860732560432965	0x87056dcd14fb2e9ab0271d26906663c691009db7ddd891db0b91779340d76f2c	305046662909744767269	628359680543460008631950	126270661914778063
0x4e977830ba4bd783c0bb7f15d3e243f73ff57121	0x249ffb1ef12e805f72b657a3a0c68c349ec0d7a0	false	2310539629632617546	347	12624288	2021-06-13T05:41:04.000Z	48104339058281953317304682	0x4d5954b4571372c9ff85cfce12b2762185c8715976895afe1dba026a20819f5a	2310561515497886204	709220833669303301571	21885865268658
0x4e977830ba4bd783c0bb7f15d3e243f73ff57121	0x41321108f48f9908a15f226988974da62c2a278b	false	89546341861505830	103	12626587	2021-06-13T14:10:06.000Z	48105744322745146096791583	0xee2a03a3c3bf3387ebab32d1770baa7c7da8da06333ea9a0aa19d27aee03e723	89678341399133170	709167197438790910602	131999537627340

Example Query

Query with partition filter

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

SToken_Mint_event

Stable debt token minting events from Aave protocol lending pools. Captures stable-rate borrowing activity including borrowed amount, interest rate calculations, borrower address, and updated pool totals.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_newRate	block_number	in_onBehalfOf	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0xe4922afab0bbadd8ab2a88e0c79d884ad337fca6	0x823034a8e2cfd842c914d9456250959c760f45ea	false	112000000000	216	105196534750536124517389536	14194439	0x823034a8e2cfd842c914d9456250959c760f45ea	2022-02-13T00:04:31.000Z	108343942728119691788454867	0xbba44442892400826bc8e06215b9bb4417e034f4708d4b80f2111a6bcbec65e2	2000854934364	21167880269843	80083252
0x778a13d3eeb110a4f7bb6529f99c000119a08e92	0x454ed4e1036c497f78d7accdf0b0a1022e8ac825	false	200000000000000000000000	430	117471160068485758715176599	14199862	0x454ed4e1036c497f78d7accdf0b0a1022e8ac825	2022-02-13T20:06:07.000Z	108354031694168234994984662	0x30f9d5be0e0f9921f6bc7ba4fd38f01b4a152b5a23083540c84c0e38049e7ee3	0	5183979921778681616875210	0
0x4e977830ba4bd783c0bb7f15d3e243f73ff57121	0xcc9a0b7c43dc2a5f023bb9b738e45b0ef6b06e04	false	2000000000000000000	290	56908504001428938434466456	12078141	0xb9addb7594e6047baa292e98800a29d142e93fe1	2021-03-20T21:31:26.000Z	57104836191323489950906379	0xe483bef61ad87bd9f6b039a960c6ca833d1f1fba6818c8b89aa09ad7b7789426	0	848927948103592142470	0

Example Query

Query with partition filter

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

VToken_Burn_event

Variable debt token burn events emitted when borrowers repay debt in Aave-based lending protocols. Contains user address, repayment amount, updated interest index, and accrued interest since last interaction for tracking debt position changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x00ad8ebf64f141f1c81e9f8f792d3d1631c6c684	0xaf0fdd39e5d92499b0ed9f68693da99c0ec1e92e	false	1304783365596670400844485621	17591625482419147925640	542	15227680	2022-07-28T00:12:22.000Z	0xb9cd00619f53c4d61b43f0b0f8a605358b5ca25ebd8e7668ac1b14f1b8c5e226
0x00ad8ebf64f141f1c81e9f8f792d3d1631c6c684	0x9d4ad620d071204cc99ae17a56e4bd9b72b7d8c5	false	1304814545886770808030668834	694390000000000000000	283	15228589	2022-07-28T03:34:30.000Z	0x0a43555dc1ed13156caa6757b7bbff57e83a32ac4c2ef0732d99bf605bfb32db
0x00ad8ebf64f141f1c81e9f8f792d3d1631c6c684	0x017b3763b8a034f8655d46345e3eb42555e39064	false	1304831559916568453907217588	10007157295213159049025	293	15229076	2022-07-28T05:24:45.000Z	0x968de69eed193a7d6bbbb8fc54f3b8cc22e2ac6be8ca90a747b6a19eaf6322b3

Example Query

Query with partition filter

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

VToken_Mint_event

Variable rate debt token mint events from lending protocols. Records debt token issuance with borrower address, borrowed amount, interest rate index, and accrued interest at the time of minting.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x619beb58998ed2278e08620f97007e1116d5d25b	0x0084ee6c8893c01e252198b56ec127443dc27464	false	1442451593081360417620328767	3500000000	245	21939370	0x0084ee6c8893c01e252198b56ec127443dc27464	2025-02-27T18:09:11.000Z	0x3990a8a4fc5f56eef871b4a385314b0a24c9c0bf1d4c6536e14da60d8f6cfd61
0x619beb58998ed2278e08620f97007e1116d5d25b	0x151e4f9ebb49c96e5a0eca36cbfb7663cf21b7ca	false	1442461373557555557189823542	5000000	296	21939534	0x151e4f9ebb49c96e5a0eca36cbfb7663cf21b7ca	2025-02-27T18:42:11.000Z	0xb34f0b24fc92360f4bb4cd6ad8b11fe9b5807a05a3583f5d246b380ab48d4c00
0x531842cebbdd378f8ee36d171d6cc9c4fcf475ec	0x15395fd02c359a55f776653720247b92bee1c373	false	1590577323794656381296421426	10000000000	136	21938828	0x15395fd02c359a55f776653720247b92bee1c373	2025-02-27T16:20:35.000Z	0xab492396f177cbbc4828ad9359bf83402466cfabd0e3d5a41c47c1e41515fa54

Example Query

Query with partition filter

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

WrappedTokenGatewayV2_withdrawETH_function

ETH withdrawal transactions from Aave V2 lending protocol on Ethereum, converting aWETH (Aave interest-bearing wrapped ETH) back to native ETH. Tracks withdrawal amounts, recipient addresses, and transaction execution details for analyzing protocol liquidity flows and user redemption patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_anon0`	`STRING`	Contract address of the lending pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_to	status	gas_used	in_anon0	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
853433	0xee6256f9dcb69170231220a6549916d919b72f14	true	594595	0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	1000000000000000000	0x80500d20	0xa0d9c1e9e48ca30c8d8c3b5d69ff5dc1f6dffc24	19665755	0xee6256f9dcb69170231220a6549916d919b72f14	2024-04-16T04:46:59.000Z	0x302269d75f2c3e2365c9ecf9688f335cf5fc9ff53f7caf05fa4700d2bec1b957
566792	0x54c2778651e055c40d1af89c33276ec61dbda73c	true	374102	0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	10000000000000000000	0x80500d20	0xa0d9c1e9e48ca30c8d8c3b5d69ff5dc1f6dffc24	19667788	0x54c2778651e055c40d1af89c33276ec61dbda73c	2024-04-16T11:36:59.000Z	0xb08f3ad108bb5db83b4714c326d38179d0de675ab6daf198e487da9f9e22f294
564360	0x7d1c3f9f61e3cd667d22b4613a49ac27f53bf8be	true	303534	0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xa0d9c1e9e48ca30c8d8c3b5d69ff5dc1f6dffc24	19669948	0x7d1c3f9f61e3cd667d22b4613a49ac27f53bf8be	2024-04-16T18:52:35.000Z	0x180155ea98e3593414e8b11b9c5cd37ec734902fad246480e183d9b94c98a591

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AMMLendingPool_Borrow_event

AMMLendingPool_Deposit_event

AMMLendingPool_FlashLoan_event

AMMLendingPool_Repay_event

AMMLendingPool_Withdraw_event

AMMLendingPoolConfigurator_ReserveInitialized_event

AMMVToken_Burn_event

AMMVToken_Mint_event

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

stkAAVE_RewardsClaimed_event

stkAAVEwstETHBPTv2_RewardsClaimed_event

stkABPT_RewardsClaimed_event

stkGHO_RewardsClaimed_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV2_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AMMLendingPool_Borrow_event

​AMMLendingPool_Deposit_event

​AMMLendingPool_FlashLoan_event

​AMMLendingPool_Repay_event

​AMMLendingPool_Withdraw_event

​AMMLendingPoolConfigurator_ReserveInitialized_event

​AMMVToken_Burn_event

​AMMVToken_Mint_event

​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

​stkAAVE_RewardsClaimed_event

​stkAAVEwstETHBPTv2_RewardsClaimed_event

​stkABPT_RewardsClaimed_event

​stkGHO_RewardsClaimed_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV2_withdrawETH_function

Tables

AMMLendingPool_Borrow_event

AMMLendingPool_Deposit_event

AMMLendingPool_FlashLoan_event

AMMLendingPool_Repay_event

AMMLendingPool_Withdraw_event

AMMLendingPoolConfigurator_ReserveInitialized_event

AMMVToken_Burn_event

AMMVToken_Mint_event

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

stkAAVE_RewardsClaimed_event

stkAAVEwstETHBPTv2_RewardsClaimed_event

stkABPT_RewardsClaimed_event

stkGHO_RewardsClaimed_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV2_withdrawETH_function