aave_v3_base

Tables

AToken_BalanceTransfer_event

Interest-bearing aToken balance transfer events from Aave V3 lending protocol. Records movements between accounts with normalized interest index for calculating accrued yields on deposited collateral.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

in_to	address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0xf276d10b388e00b8a04b1362f66c6e2aad8a1960	0x7c307e128efa31f540f2e2d976c995e0b65f51f6	0x19ceead7105607cd444f5ad10dd51356436095a1	false	1001129601324473628345449504	18820617599539407640	221	27402255	2025-03-10T08:04:17.000Z	0x6d0bbd3f56d50382e29c54265b6bef96e3b0f68027d366f82baea4a9d4617bbd
0x6d718a725bd39357cdb3d6bf6b36e1347d952877	0x7c307e128efa31f540f2e2d976c995e0b65f51f6	0x111111125421ca6dc452d289314280a0f8842a65	false	1001129610282865607692156795	33847798088340133	193	27405156	2025-03-10T09:40:59.000Z	0xaa60f2cce5fecf25c51b3de5be878bf322e1c20e5b4ba8958a18a98e43d7cf2c
0x6d718a725bd39357cdb3d6bf6b36e1347d952877	0x7c307e128efa31f540f2e2d976c995e0b65f51f6	0x111111125421ca6dc452d289314280a0f8842a65	false	1001129779784963374712674516	13799618488020489	270	27422523	2025-03-10T19:19:53.000Z	0xe45933a89177374e9787855ca90caf82fabd0f7cd8d75ffb40d0da2a1fb4e649

Example Query

Query with partition filter

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

AToken_Burn_event

Burn events for Aave interest-bearing tokens (aTokens) emitted when users withdraw or repay underlying assets. Records the amount burned, the user’s address, the interest accrual index at burn time, and optional balance increase from accrued interest in V3 implementations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x067ae75628177fd257c2b1e500993e1a0babcbd1	0x88b1cd4b430d95b406e382c3cdbae54697a0286e	false	1001748684078751259197531943	184485018588647992284	0xba1333333333a1ba1108e8412f11850a5c319ba9	511	27634083	2025-03-15T16:51:53.000Z	0x0e0e7fbd174519fd79c1bb4ba901c6cbaae402c721075b58db7f6561918ded11	10149333228069915877
0x067ae75628177fd257c2b1e500993e1a0babcbd1	0x88b1cd4b430d95b406e382c3cdbae54697a0286e	false	1001737205432480578803023764	1354719696153101365562	0xba1333333333a1ba1108e8412f11850a5c319ba9	441	27618753	2025-03-15T08:20:53.000Z	0xd352f27d15f5718cf6c225150af10a23f6e86cd50fc5417bc2ff57a209023a71	58728532526856981644
0x067ae75628177fd257c2b1e500993e1a0babcbd1	0x88b1cd4b430d95b406e382c3cdbae54697a0286e	false	1001747143739784963019837771	134919900433920580835	0xba1333333333a1ba1108e8412f11850a5c319ba9	317	27632033	2025-03-15T15:43:33.000Z	0x5636152890cf959c3bd409ca8a1e65e69c0d92efacf3358f4c9ca88f09ef157c	5080103173790329821

Example Query

Query with partition filter

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

AToken_Initialized_event

Aave V3 AToken initialization events emitted when new interest-bearing token markets are deployed. Contains AToken metadata (name, symbol, decimals), configuration references (pool, treasury, incentives controller), and the underlying asset address being wrapped.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aTokenDecimals`	`INT64`	Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
`in_aTokenName`	`STRING`	Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
`in_aTokenSymbol`	`STRING`	Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	in_treasury	block_number	in_aTokenName	block_timestamp	in_aTokenSymbol	transaction_hash	in_aTokenDecimals	in_underlyingAsset	in_incentivesController
0x7c307e128efa31f540f2e2d976c995e0b65f51f6	0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	0x	45	0xba9424d650a4f5c80a0da641254d1acce2a37057	15302050	Aave Base weETH	2024-06-03T05:44:07.000Z	aBasweETH	0x8cb8093f6d18a2105ced30c6e62b86e9298b6da13de556c2e59660d38369dcd0	18	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0xf9cc4f0d883f1a1eb2c253bdb46c254ca51e1f44
0xdd5745756c2de109183c6b5bb886f9207bef114d	0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	0x	186	0xba9424d650a4f5c80a0da641254d1acce2a37057	25085323	Aave Base ezETH	2025-01-15T16:53:13.000Z	aBasezETH	0xe576428129a21be6abaf461e2c4e899fe2f6b1285ee25c8503789e6056ab024d	18	0x2416092f143378750bb29b79ed961ab195cceea5	0xf9cc4f0d883f1a1eb2c253bdb46c254ca51e1f44
0xbcffb4b3beadc989bd1458740952af6ec8fbe431	0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	0x	350	0xba9424d650a4f5c80a0da641254d1acce2a37057	34923705	Aave Base tBTC	2025-08-31T10:39:17.000Z	aBastBTC	0x1fce903cfbca3ba33092e57bfab92a8fa10e285a317590aefbade0a65592ed09	18	0x236aa50979d5f3de3bd1eeb40e81137f22ab794b	0xf9cc4f0d883f1a1eb2c253bdb46c254ca51e1f44

Example Query

Query with partition filter

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

AToken_Mint_event

Aave Protocol interest-bearing token (aToken) mint events emitted when users deposit underlying assets into lending pools. Records deposit transactions including depositor address, recipient address, minted token amount, liquidity index, and accrued interest balance increases for lending position tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0xd4a0e0b9149bcee3c920d2e00b5de09138fd8bb7	false	1019640280337171030978751100	4916158298394	0x000000000022d473030f116ddee9f6b43ac78ba3	49	23743441	0x6e55ae43dfb7a541a3702aa8f91926b6c433ca77	2024-12-15T15:23:49.000Z	0xae19f23f8a1c505ef917d80ad95c94a85525460d0c794df7748633fbb20e7de0	4916158298394
0xd4a0e0b9149bcee3c920d2e00b5de09138fd8bb7	false	1019636278134473732389139451	17000643679	0x000000000022d473030f116ddee9f6b43ac78ba3	162	23740662	0x048d79a8f51fce31b6f604303d7f084e3d1f97e1	2024-12-15T13:51:11.000Z	0xfc5d0e10bbe17f8cb470949585e5aa331bedbdd0930279b3c1f1e94f890dd368	17000643679
0xd4a0e0b9149bcee3c920d2e00b5de09138fd8bb7	false	1019640280337171030978751100	63882798855	0x000000000022d473030f116ddee9f6b43ac78ba3	51	23743441	0x4eb7474a78f1c9c63faa53255dc4edadd9bea168	2024-12-15T15:23:49.000Z	0xae19f23f8a1c505ef917d80ad95c94a85525460d0c794df7748633fbb20e7de0	63882798855

Example Query

Query with partition filter

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

LendingPool_Borrow_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x07258130c0d77e8813eec06428c6f7fc6c73dde1	false	555000000000000000	248	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	12809932	1978323093600290099420558	0x07258130c0d77e8813eec06428c6f7fc6c73dde1	2024-04-06T13:13:31.000Z	0x3cbb55e44d6f2773cf6ac5f280786555fb5959add11e82122f7e704c257484fc	2
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x2bd1965a3b9bb05fc0183b08223e2da9574ce0c6	false	400000000000000000	377	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	12811524	1962211442943105157892129	0x2bd1965a3b9bb05fc0183b08223e2da9574ce0c6	2024-04-06T14:06:35.000Z	0xbde2b35a9725e2ea7cae8f899492418ff93c030b04e892d68190d0784de14812	2
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x3350ecddf44531956dfc0c23ca5ffbc02854a278	false	1000000000000000000	113	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	12807249	2023040612987605002535584	0x3350ecddf44531956dfc0c23ca5ffbc02854a278	2024-04-06T11:44:05.000Z	0x6fc5f65a408d7862b92ae25b2e2d74a378cadf23e3c06dd1874824678dc9f912	2

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

Flash loan events from Aave and Aave-forked lending protocols containing borrowed asset, amount, initiator, recipient, and premium fee charged. Used for tracking uncollateralized borrowing activity and arbitrage transactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	in_referralCode	transaction_hash	in_interestRateMode
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	8700687364029795	0x2e549104c516b8657a7d888494dfbabd7c70b464	393	4350343682015	18843569	0x42623cc892b273c136196261c35e5a372a0079a6	2024-08-24T05:14:45.000Z	0	0x1c20e9f63448f7b25d123dbc9d5f6ff7db02b4dad65529fcc11576a89e771425	0
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	373730544413765	0x5f4d15d761528c57a5c30c43c1dab26fc5452731	348	0	18864050	0x5f4d15d761528c57a5c30c43c1dab26fc5452731	2024-08-24T16:37:27.000Z	5936	0x636cbe7bb5f2714a4736604d647031bef9459e0b75eb76050adec0556cd32666	2
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	2062589411021216365	0x5f4d15d761528c57a5c30c43c1dab26fc5452731	382	0	18838337	0x5f4d15d761528c57a5c30c43c1dab26fc5452731	2024-08-24T02:20:21.000Z	5936	0xab1515e9ca098aed57b8e981e01a926e5439bf3554a309771648db2ee6c25841	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_base.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
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x8cb904216e165783a8fa3f621aa478e772b1b1ff	false	537	23303058	0x4200000000000000000000000000000000000006	0x0c714690a405c44745b9a7b51514db7e12bcad2b	812385969045354	2024-12-05T10:44:23.000Z	false	0x98ea688064b5715cd40a7fcfa9a3135788fc9cb2fda1da00b9f9b729ffc690e6	0x4200000000000000000000000000000000000006	848943337652395
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0xb900d7f31a01c76d568a952c6d130fedd7a1f0a6	false	340	23300798	0x4200000000000000000000000000000000000006	0x888888887a487f209e31a692b227d8d1ff9070ba	5008946306876001	2024-12-05T09:29:03.000Z	false	0xfafe4538d412d2fdd014d42d347f7bdbfd3056c82348a363b8d3c4eee116a8cb	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	20545376
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x6fba394d3a407519de0775ca93e8c7e17d3a0e99	false	353	23310456	0x4200000000000000000000000000000000000006	0x888888887a487f209e31a692b227d8d1ff9070ba	2530714348497767	2024-12-05T14:50:59.000Z	false	0x2b92b5c55f7337744ff98622876b0e28023310563b23c06240020093b694e48e	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	10461058

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

Aave V3 protocol event recording interest-bearing token mints to the treasury reserve. Contains reserve address, amount minted, and transaction identifiers for tracking protocol fee accumulation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	641	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	27752380	2025-03-18T10:35:07.000Z	5257896700528	0x0701c90512af9e0ca1696709d675a49e2b7d498f76fbf88fb73093eb7aa6cf1d
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	650	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	27752380	2025-03-18T10:35:07.000Z	19155494	0x0701c90512af9e0ca1696709d675a49e2b7d498f76fbf88fb73093eb7aa6cf1d
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	638	0x4200000000000000000000000000000000000006	27752380	2025-03-18T10:35:07.000Z	5390667543084612	0x0701c90512af9e0ca1696709d675a49e2b7d498f76fbf88fb73093eb7aa6cf1d

Example Query

Query with partition filter

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

LendingPool_Repay_event

Loan repayment events from Aave-based lending protocols containing borrower address, repayer address, reserve asset, and repayment amount. Used for tracking debt reduction and loan lifecycle analysis across DeFi lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayer`	`STRING`	Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_useATokens`	`BOOL`	Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0xe5b62cd578ec7f95acbc320bdc2132bd2ffdec03	false	261964157357903342	190	0xe5b62cd578ec7f95acbc320bdc2132bd2ffdec03	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	13546857	false	2024-04-23T14:37:41.000Z	0xe95774f0c7a8a3800ee83309591c07f63a3f2ce8b6cb69ca05dcff894011f57f
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x2a83449e880374435fec2cea0da457df10f6757e	false	408736046488894183	63	0x2a83449e880374435fec2cea0da457df10f6757e	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	13525314	false	2024-04-23T02:39:35.000Z	0xb5d6a369cb8308fb0069329c0f0b8ca21c8723caff05d0abe7ffa2ad1f21664b
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x250d512bae80c8bbafb8a0d45b866472109dddc8	false	300000000000000000	196	0x250d512bae80c8bbafb8a0d45b866472109dddc8	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	13544599	false	2024-04-23T13:22:25.000Z	0x022bed9f3da53bec4957f33337149f587454353bf7c496c21d53de64f997a0e0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_base.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
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	52	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	16219942	2024-06-24T11:40:31.000Z	4113692283509987281368907	0x9328df783eab44af9b355433a1efe9c389f8983a6491ea556c54fed36a80851e	1000232363400193503668254168	108676712671768535783441569	38676712671768535783441569	1002199681277514021424290514
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	52	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	16238889	2024-06-24T22:12:05.000Z	4033796707085849071565184	0x651dac4b6d06108be8fa1d9ae802386f382d0b95b3877f74e81ba8153c02c971	1000237221625192072680504781	108299284147527301088179594	38299284147527301088179594	1002245852056634717771431815
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	false	53	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	16221672	2024-06-24T12:38:11.000Z	4115762272137407881286582	0xe3c03c870d3b4d29930d27832c00de612ae62c441de662e2d4cad99ab526cb0d	1000232807639606588766055614	108686442408572343214876831	38686442408572343214876831	1002203899999391073372945272

Example Query

Query with partition filter

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

LendingPool_Supply_event

Aave V3 Supply events emitted when users deposit assets into lending pools. Records depositor address, reserve token, deposit amount, beneficiary, and optional referral code for tracking liquidity provision across DeFi lending protocols.

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x3e21e3bfeea7e793799c8883a8259c5c3d61c364	false	1000000000000000000	4	0x4200000000000000000000000000000000000006	14664170	0x3e21e3bfeea7e793799c8883a8259c5c3d61c364	2024-05-19T11:21:27.000Z	0x735f56f0fdbe1b7c60699acd48e63ecf25dcf8490b2c38a9d4d5555f887a5db3
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0xbe13f93fb57569a9a9b41cecfd27eab2c60c03e0	false	3650359052	5	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	14647231	0xbe13f93fb57569a9a9b41cecfd27eab2c60c03e0	2024-05-19T01:56:49.000Z	0xf0db3da01968afd2ab3f1e715aedf21a33ce528cd056a4f5393a27eeb4b4ac87
0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x0ac0508870b28e79c10be28291a179612f117f2b	false	144074916	5	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	14647315	0x0ac0508870b28e79c10be28291a179612f117f2b	2024-05-19T01:59:37.000Z	0x03ff8f446862cc150b5a63e85df313e91c8cd92b3b609bf6c443a680aa969196

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

Aave LendingPool withdrawal events recording asset removals from lending positions. Contains user address, reserve token address, withdrawal amount, and recipient address for tracking collateral and liquidity movements across Aave V2 and V3 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0xbbae6c1efa69210ec8c62ec4cbf3b84a9a2f23ac	0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0xbbae6c1efa69210ec8c62ec4cbf3b84a9a2f23ac	false	1789029	4	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	15205784	2024-06-01T00:15:15.000Z	0xefbf71ce7bf4cf7751c8d5e484cb286b1592078b8f955d9854ec9f009dd47046
0x8be473dcfa93132658821e67cbeb684ec8ea2e74	0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0x8be473dcfa93132658821e67cbeb684ec8ea2e74	false	560000000000000000	11	0x4200000000000000000000000000000000000006	15226452	2024-06-01T11:44:11.000Z	0xf2b3be92b6801fec5d890158c19c2558a6bda30fc8ba9ddf8e7028cf6c259dab
0xd303cd8d5b011216ab803e05b82ac043b8895b3b	0xa238dd80c259a72e81d7e4664a9801593f98d1c5	0xd303cd8d5b011216ab803e05b82ac043b8895b3b	false	1236340509680480	11	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	15211197	2024-06-01T03:15:41.000Z	0x4486f8a5f0192ed0ef31cec119fa9d76d9fd6314c80c0b9e46e7554ab585b990

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_ltv`	`STRING`	Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationThreshold`	`STRING`	Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationBonus`	`STRING`	Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
7500	0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	87	14328424	2024-05-11T16:49:55.000Z	0xe0321d6c16a8104b8744161f1e0fd8e91f9c524f877e1c2fe408ff479224d023	10500	7800
7500	0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	86	14328424	2024-05-11T16:49:55.000Z	0xe0321d6c16a8104b8744161f1e0fd8e91f9c524f877e1c2fe408ff479224d023	10500	7800
7300	0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x236aa50979d5f3de3bd1eeb40e81137f22ab794b	363	34923705	2025-08-31T10:39:17.000Z	0x1fce903cfbca3ba33092e57bfab92a8fa10e285a317590aefbade0a65592ed09	10750	7800

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumToProtocol	in_oldFlashloanPremiumToProtocol
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	15	2357134	2023-08-08T14:06:55.000Z	0x65ada47b1e29db97b062d601cc2d3d4ba3b4ce8d35b24efd65fd03dd1ca130f0	4	0
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	151	32382140	2025-07-03T14:40:27.000Z	0x5a00c0f7b758b0e6aa9cd918d5bd69fa4281a05c2d5d4017324a02df5e8d7881	10000	4

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldFlashloanPremiumTotal`	`STRING`	Previous total flash loan premium fee rate expressed in basis points.
`in_newFlashloanPremiumTotal`	`STRING`	Updated total flash loan premium fee rate expressed in basis points.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumTotal	in_oldFlashloanPremiumTotal
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	14	2357134	2023-08-08T14:06:55.000Z	0x65ada47b1e29db97b062d601cc2d3d4ba3b4ce8d35b24efd65fd03dd1ca130f0	5	0

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFee`	`STRING`	Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	1000	19	8192239	2023-12-21T15:50:25.000Z	0x08eeb9fe32f72acc3ac8a28fe76066f418ef7a79f64382caea30c3ca735c9696
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	1000	728	20151660	2024-09-23T11:57:47.000Z	0xded919c77289c4c4e2562db3237e7120b687a138aea343cea449583840943d8f
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x236aa50979d5f3de3bd1eeb40e81137f22ab794b	1000	364	34923705	2025-08-31T10:39:17.000Z	0x1fce903cfbca3ba33092e57bfab92a8fa10e285a317590aefbade0a65592ed09

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldReserveFactor`	`STRING`	Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
`in_newReserveFactor`	`STRING`	Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor	in_oldReserveFactor
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	55	15302050	2024-06-03T05:44:07.000Z	0x8cb8093f6d18a2105ced30c6e62b86e9298b6da13de556c2e59660d38369dcd0	4500	0
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452	54	18335640	2024-08-12T11:03:47.000Z	0x4ef34b51bcaf8adb440d7f119d390f3142dd0e4a38386697c071f58b430bb48c	500	1500
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	180	18354081	2024-08-12T21:18:29.000Z	0xeff28d458bd1ad2472159d169eb7cd7043393caf77722b2019b635fd12e152a5	3000	2500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_base.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
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0x7c307e128efa31f540f2e2d976c995e0b65f51f6	48	15302050	2024-06-03T05:44:07.000Z	0x8cb8093f6d18a2105ced30c6e62b86e9298b6da13de556c2e59660d38369dcd0	0xcbeda45432d5325585acad29244f113c237b6cf0	0x8d2e3f1f4b38aa9f1ced22ac06019c7561b03901	0xa31accd744ebdbf1b36e4556ea09c8b34cd65bb2
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0x2416092f143378750bb29b79ed961ab195cceea5	0xdd5745756c2de109183c6b5bb886f9207bef114d	189	25085323	2025-01-15T16:53:13.000Z	0xe576428129a21be6abaf461e2c4e899fe2f6b1285ee25c8503789e6056ab024d	0x0000000000000000000000000000000000000000	0xbc4f5631f2843488792e4f1660d0a51ba489bdbd	0x86ab1c62a8bf868e1b3e1ab87d587aba6fbcbdc5
0x5731a04b1e775f0fdd454bf70f3335886e9a96be	false	0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452	0x99cbc45ea5bb7ef3a5bc08fb1b7e56bb2442ef0d	5	7744683	2023-12-11T07:11:53.000Z	0x852e9315303690e1a6bd79ab9e68e6c6354b66a8865bf0000c108d3adec61975	0xfe742fa2a84294e8316f05b17c05090fc68b5105	0x41a7c3f5904ad176dacbb1d99101f59ef0811dc1	0x2f51b00ec4912874dfdbd8dc3c8e390c21e77af9

Example Query

Query with partition filter

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

ShortExecutor_ExecutedAction_event

Governance execution event recording completed actions in Aave V3’s ShortExecutor contract. Contains target address, function signature, execution timestamp, and delegatecall flag for tracking protocol governance operations across chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_executionTime`	`STRING`	Unix timestamp when the action was executed. Integer value representing seconds since epoch.
`in_withDelegatecall`	`BOOL`	Boolean flag indicating whether the contract call was executed using delegatecall opcode instead of a standard call.
`in_resultData`	`STRING`	Return data from the executed contract function call. Hex-encoded byte string containing the function’s output parameters.

Sample Data

address	in_data	removed	in_target	log_index	block_number	in_signature	in_resultData	block_timestamp	in_executionTime	transaction_hash	in_withDelegatecall
0x9390b1735def18560c509e2d0bc090e9d6ba257a	0x	false	0x50c3cb80c56563ecb46b88d88d3aa6b3a3efd16d	64	13967710	execute()	0x	2024-05-03T08:26:07.000Z	1714724767	0x06c3246474aa676883e94e59168279252c9f42ba028e2465d8693b165941d6de	true
0x9390b1735def18560c509e2d0bc090e9d6ba257a	0x	false	0xeb0b55ce74a8b4a614dd2163e35eaeb4739f0758	19	11434625	execute()	0x	2024-03-05T17:09:57.000Z	1709658597	0x2369045fd7df4ed4fb04a4cf986d842f75e7fa988a19cf484bac30c97eeea501	true
0x9390b1735def18560c509e2d0bc090e9d6ba257a	0x	false	0xba9020937281d05b0e0d68a0e25028c192020a6b	67	17402930	execute()	0x	2024-07-21T20:53:27.000Z	1721595207	0xc6b983448372f6f98a783de1bebcdd6af238476331069beb4b3e1faf8feb9693	true

Example Query

Query with partition filter

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

StataToken_Deposit_event

Deposit events emitted by Aave V3 StataToken contracts recording asset conversions to yield-bearing shares. Contains sender address, asset owner, deposited asset amount, and received share amount for tracking StataToken minting activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x0830820d1a9aa1554364752d6d8f55c836871b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	1000586145729335855	0xba1333333333a1ba1108e8412f11850a5c319ba9	998024795496186342	242	27379143	2025-03-09T19:13:53.000Z	0x15494886edafe9209a45c9e17e5c020ee402f6b36881a7f5fcdeb172203e297f
0x0830820d1a9aa1554364752d6d8f55c836871b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	21495378248653884	0xba1333333333a1ba1108e8412f11850a5c319ba9	21440354876481801	96	27367362	2025-03-09T12:41:11.000Z	0x9136fdec1f37f8797645c2269568ce81dc72c5900d9cd2b8d3fef23b4e5419d0
0x0830820d1a9aa1554364752d6d8f55c836871b74	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	838974015307497270	0xba1333333333a1ba1108e8412f11850a5c319ba9	836826437664501658	77	27359140	2025-03-09T08:07:07.000Z	0x06b67fe0590b1c2c80915f242445a6abb3d28af99f0aa660f4f478afaa48c502

Example Query

Query with partition filter

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

StataToken_Initialized_event

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

Columns

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

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0xc768c589647798a6ee01a91fde98ef2ed046dbd6	false	134	1	25303796	2025-01-20T18:15:39.000Z	0x60176d0a43937dbfdd12c891a288ea022b51a658c9e9e89fa1a73ee607733e39
0xfa2a03b6f4a65fb1af64f7d935fdbf78693df9af	false	140	1	25303796	2025-01-20T18:15:39.000Z	0x60176d0a43937dbfdd12c891a288ea022b51a658c9e9e89fa1a73ee607733e39
0xf8f10f39116716e89498c1c5e94137ada11b2bc7	false	164	1	25303796	2025-01-20T18:15:39.000Z	0x60176d0a43937dbfdd12c891a288ea022b51a658c9e9e89fa1a73ee607733e39

Example Query

Query with partition filter

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

StataToken_Withdraw_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x0830820d1a9aa1554364752d6d8f55c836871b74	false	0x4f1c0915352a55f70e1644f3917e3fa6a9dcd037	6976594430210028	0x4f1c0915352a55f70e1644f3917e3fa6a9dcd037	6956598798264785	488	0x20e068d76f9e90b90604500b84c7e19dcb923e7e	32697420	2025-07-10T21:49:47.000Z	0x8552defe99c10efa3661d4ef23bf3ba5a7178ac37b4cdac01c143e8c85d93891
0x0830820d1a9aa1554364752d6d8f55c836871b74	false	0x4f1c0915352a55f70e1644f3917e3fa6a9dcd037	3735286777154017	0x4f1c0915352a55f70e1644f3917e3fa6a9dcd037	3724581098455391	226	0x20e068d76f9e90b90604500b84c7e19dcb923e7e	32697114	2025-07-10T21:39:35.000Z	0x10f30f81c857d3ce03babcd3b4119607821a019c322c16764408e9ac5a3ec4b8
0x0830820d1a9aa1554364752d6d8f55c836871b74	false	0x4f1c0915352a55f70e1644f3917e3fa6a9dcd037	2196799007153336	0x4f1c0915352a55f70e1644f3917e3fa6a9dcd037	2190503146095203	314	0x20e068d76f9e90b90604500b84c7e19dcb923e7e	32691571	2025-07-10T18:34:49.000Z	0x533d65533206f62c9fd9e2c8608dc7f2b2ae36cc87d45a89469a76057977041f

Example Query

Query with partition filter

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

StataTokenFactory_StataTokenCreated_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	in_stataToken	in_underlying	block_timestamp	transaction_hash
0x78d33bf0014ab169725f2ea5a62b200f2977faee	false	349	28361836	0x729f75aff28c726e32403e80cef2afb518cfbfa7	0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42	2025-04-01T13:10:19.000Z	0x35d483591f606a62a3f90f78c7820b4a2779573cac24097d52b286c6a8c7b3d4
0x78d33bf0014ab169725f2ea5a62b200f2977faee	false	155	25303796	0x5e8b674127b321dc344c078e58bbacc3f3008962	0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22	2025-01-20T18:15:39.000Z	0x60176d0a43937dbfdd12c891a288ea022b51a658c9e9e89fa1a73ee607733e39
0x78d33bf0014ab169725f2ea5a62b200f2977faee	false	149	25303796	0x0830820d1a9aa1554364752d6d8f55c836871b74	0xc1cba3fcea344f92d9239c08c0568f6f2f0ee452	2025-01-20T18:15:39.000Z	0x60176d0a43937dbfdd12c891a288ea022b51a658c9e9e89fa1a73ee607733e39

Example Query

Query with partition filter

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

SToken_Burn_event

Stable rate debt token burn events from Aave-based lending protocols, emitted when borrowers repay stable-rate debt positions. Records the burn amount, user balance changes, average stable rate, and updated total supply for tracking debt repayments and interest accrual.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SToken_Mint_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VToken_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x03d01595769333174036832e18fa2f17c74f8161	0xc8a41de2503252da4d1fc7398ebb9c2d18c8eff9	false	1003135669854825167362984095	45398159	0x0000000000000000000000000000000000000000	385	28479944	2025-04-04T06:47:15.000Z	0x9b82a283813a228e4ec0d1ae752b4344a596b701e45014b71e35bed6c0015ef6	1579019
0x03d01595769333174036832e18fa2f17c74f8161	0xcd5adcb3a1f63180f8d4f75d8f12de8883f7c641	false	1003142377004183934610266617	41785551	0x0000000000000000000000000000000000000000	159	28481916	2025-04-04T07:52:59.000Z	0x8507067d62ccf59bbab87f066c94a794cca24ae8ebe6c601ddad0c1904f09758	493011
0x03d01595769333174036832e18fa2f17c74f8161	0xc7054e1bec2e34c2a8a85fe5f7da06fe7c28a0f8	false	1003143714461234217702672808	14889657	0x0000000000000000000000000000000000000000	251	28482310	2025-04-04T08:06:07.000Z	0xaa00c8bf6a0545ed2670dbd73cce9bd75c55407768ed7e41d82b4e20ee264b70	3737346

Example Query

Query with partition filter

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

VToken_Mint_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x41a7c3f5904ad176dacbb1d99101f59ef0811dc1	false	1002849027525103654384394991	61100000000000000	0x908ff1ef30b61d468d3bb41427fa9abb31cd6a85	11	10634970	0x908ff1ef30b61d468d3bb41427fa9abb31cd6a85	2024-02-16T04:54:47.000Z	0xfb64fdccba80bb7a11d80c088bf5604746252bd967e3f7dc7824837b8f428617
0x41a7c3f5904ad176dacbb1d99101f59ef0811dc1	false	1002849377310073453442584789	61767338434448772	0x764897268325efc9bfab5368a54ab1b45151230f	25	10638839	0x764897268325efc9bfab5368a54ab1b45151230f	2024-02-16T07:03:45.000Z	0x818189982f9b5f2e9b6b3ac6e21daf8134d9097d9426a26240da7a40410d9405
0x41a7c3f5904ad176dacbb1d99101f59ef0811dc1	false	1002849499825026111483793146	542388219496204930	0x251662b500c63e5fb485fe6aada0b63bca29f3ef	62	10640190	0x251662b500c63e5fb485fe6aada0b63bca29f3ef	2024-02-16T07:48:47.000Z	0xedffb4f1f6de637792cdaf7d03950f0e6f250c1b8c5fe7f84edda59be6bfda62

Example Query

Query with partition filter

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

WrappedTokenGatewayV3_withdrawETH_function

Aave V3 WrappedTokenGatewayV3 withdrawETH function call records containing withdrawal amounts, pool addresses, and recipient addresses. Used for tracking ETH unwrapping and withdrawal transactions from Aave lending pools across multiple chains.

Columns

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

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
1000000	false	175211	0x80500d20	0xa0d9c1e9e48ca30c8d8c3b5d69ff5dc1f6dffc24	31130190	0x1fdf59b52db7771400c252ac61729fb3d83f5760	2025-06-04T15:08:47.000Z	0xd4fdfa408707cffc448639e8609557eb0ddba1c37a3a712808ab6266cede27e6
1000000	false	192310	0x80500d20	0xa0d9c1e9e48ca30c8d8c3b5d69ff5dc1f6dffc24	31132624	0x736aade618aed72b6dbeb50cfe975c2969571fff	2025-06-04T16:29:55.000Z	0xe37d72b03ef36454bd15385af5e0c4742044e9b952cc9a7fe31b95dc2d2ba3fc
287485	false	192322	0x80500d20	0xa0d9c1e9e48ca30c8d8c3b5d69ff5dc1f6dffc24	31134016	0x83c1b07c8bd8992f60d14259fd214598e0209b69	2025-06-04T17:16:19.000Z	0xa3e0d5d77e83684a90b78d7d95f026ce620b3d57cea0adc3573344dbd810cb34

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

​LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​ShortExecutor_ExecutedAction_event

​StataToken_Deposit_event

​StataToken_Initialized_event

​StataToken_Withdraw_event

​StataTokenFactory_StataTokenCreated_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV3_withdrawETH_function

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function