aave_v3_optimism

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
0x78696a78d626db13fe02a878f15b5309f3cf820b	0x82e64f49ed5ec1bc6e43dad4fc8af9bb3a2312ee	0xb4a957fedc75650d027a83ed992fac013c52dce7	false	1006784318450599762629947994	700151399526858949541	7	18560127	2022-08-10T08:48:56.000Z	0x3b279e205bc4f9cc986b0c43518ccb5517a02399d12127d574e80150cd65d5aa
0x78696a78d626db13fe02a878f15b5309f3cf820b	0x078f358208685046a11c85e8ad32895ded33a249	0xb4a957fedc75650d027a83ed992fac013c52dce7	false	1001061068103947128976885188	22509260	14	18560127	2022-08-10T08:48:56.000Z	0x3b279e205bc4f9cc986b0c43518ccb5517a02399d12127d574e80150cd65d5aa
0x800a1dcf7d3039fb7e2a97fa91583c66c42d3746	0x82e64f49ed5ec1bc6e43dad4fc8af9bb3a2312ee	0xdb21b58c882b08ef367d2336aed9e234a9fb9b20	false	1006821155310568505696370186	1093535872027967737758	34	18641140	2022-08-10T20:24:19.000Z	0xdf6ec52a32c9a002420dbaece495a290a8bbe7be45b26d672324d247742b62a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x625e7708f30ca75bfd92586e17077590c60eb4cd	0x6988ff2956fafe168a202c8820dad8d4ad8ac43a	false	1001422935459103244391359834	11367000	0x6988ff2956fafe168a202c8820dad8d4ad8ac43a	2	5890361	2022-04-16T10:36:20.000Z	0x74141fddcb7a97c00d02a5e85b32ef2d532652aa208f62ed391c736fa959c58b	12321
0x625e7708f30ca75bfd92586e17077590c60eb4cd	0x55d50e63a17369510931440e0f199981d179c4f8	false	1001422815522714277771161742	6000000	0x55d50e63a17369510931440e0f199981d179c4f8	2	5890054	2022-04-16T10:23:24.000Z	0xc4a11cd5c6882cf0fca20071b6d7b63e020b3299ee7d171f9defb35612cf5ca6	7013
0x625e7708f30ca75bfd92586e17077590c60eb4cd	0xac7dd5a34f5859ef1fecc8f4d036f75a35b19eb9	false	1001422458047561721355328570	500000	0xac7dd5a34f5859ef1fecc8f4d036f75a35b19eb9	2	5888814	2022-04-16T09:44:51.000Z	0xdd5cdcca1cd0b435dc26a4512d363e1dc70fa0b156ab981b12cb1d088e3dae2c	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x724dc807b04555b71ed48a6896b6f41593b8c637	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	10	0xb2289e329d2f85f1ed31adbb30ea345278f21bcf	107128612	Aave Optimism rETH	2023-07-20T12:26:41.000Z	aOptrETH	0x1d8b04166d66cedce492cbe38185b6ddd76f7bd059bfe48cae20c137acea0111	18	0x9bcef72be871e61ed4fbbc7630889bee758eb81d	0x929ec64c34a17401f460460d4b9390518e5b473e
0x38d693ce1df5aadf7bc62595a37d667ad57922e5	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	119	0xb2289e329d2f85f1ed31adbb30ea345278f21bcf	139480651	Aave Optimism USDCn	2025-08-07T09:47:59.000Z	aOptUSDCn	0x72ba588ee0c029daadc44a3a72a4b65876ff263e1ccefa70bd744fbcda4183be	6	0x0b2c639c533813f4aa9d7837caf62653d097ff85	0x929ec64c34a17401f460460d4b9390518e5b473e
0x6ab707aca953edaefbc4fd23ba73294241490620	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	71	0xb2289e329d2f85f1ed31adbb30ea345278f21bcf	139480651	Aave Optimism USDT	2025-08-07T09:47:59.000Z	aOptUSDT	0x72ba588ee0c029daadc44a3a72a4b65876ff263e1ccefa70bd744fbcda4183be	6	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x929ec64c34a17401f460460d4b9390518e5b473e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0xf329e36c7bf6e5e86ce2150875a84ce77f477375	false	1000018819772786722102779110	147302025754589648	0x42e9ada505f9844dd10978967d58350eb733b0b2	8	114236002	0x42e9ada505f9844dd10978967d58350eb733b0b2	2024-01-01T00:59:41.000Z	0xf5fc745095ca03819bf0f75c6c4e245fc704ca98998b38b452b4281b0282580d	73744217553
0xf329e36c7bf6e5e86ce2150875a84ce77f477375	false	1000018819772786722102779110	1000000000000000	0x20628b67ce5cddac1cb95198c0ff5271f39fc048	49	114256093	0x20628b67ce5cddac1cb95198c0ff5271f39fc048	2024-01-01T12:09:23.000Z	0xb293e186aca9d9ca6c0f3eb1857a0d3588d87c7ef19f102b24ad25e9eb818675	0
0x724dc807b04555b71ed48a6896b6f41593b8c637	false	1000146704727471253164196592	1000090514096	0x4ac3c9c67296646e57d43b60af2b6ed4170f7125	11	114240250	0x4ac3c9c67296646e57d43b60af2b6ed4170f7125	2024-01-01T03:21:17.000Z	0x3dac51045963acc88a7781a93f30c3f92d6b27ee01eafb0692baf7bf28813908	90514096

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_event

Reward claim events from Aave IncentivesController contracts recording the distribution of protocol incentive tokens to users. Tracks user address, claimer address, recipient address, reward token contract, and claimed amount for analyzing liquidity mining and staking reward distributions.

Columns

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

Sample Data

in_to	address	in_user	removed	in_reward	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x91155c72ea13bcbf6066dd161beced3eb7c35e35	0x929ec64c34a17401f460460d4b9390518e5b473e	0x91155c72ea13bcbf6066dd161beced3eb7c35e35	false	0x4200000000000000000000000000000000000042	2	0x91155c72ea13bcbf6066dd161beced3eb7c35e35	61414397	2023-01-06T23:38:52.000Z	0xabe8f2aa193d176d1aa80f8f29213beb87569f786c7b214e88c4d95cf516cbb0
0x63df09710a65e46288747f611d56cc0116a3cf93	0x929ec64c34a17401f460460d4b9390518e5b473e	0x63df09710a65e46288747f611d56cc0116a3cf93	false	0x4200000000000000000000000000000000000042	2	0x63df09710a65e46288747f611d56cc0116a3cf93	61359681	2023-01-06T19:38:47.000Z	0x8c96057163f1741d6b36b8e4fdb8a3a1a5c5051089c1966935eceb0a06db2f10
0xda713512042bbbc599c438fe41c0c14b2e1dea3e	0x929ec64c34a17401f460460d4b9390518e5b473e	0xda713512042bbbc599c438fe41c0c14b2e1dea3e	false	0x4200000000000000000000000000000000000042	2	0xda713512042bbbc599c438fe41c0c14b2e1dea3e	61346138	2023-01-06T18:38:40.000Z	0x359fa526b102bc5d7c8b62baaa02da37491349d60774a96329068369abf8c2f8

Example Query

Query with partition filter

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

LendingPool_Borrow_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0064f043786e8c597d6565fcbf4f0989bdd0f9a3	false	475946551807211252	5	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	21897901	44504445220983049867531259	0x0064f043786e8c597d6565fcbf4f0989bdd0f9a3	2022-09-04T11:58:25.000Z	0x8aad7e4c548ee5a192cf7af76a1fffa63202f39c259e04292f03aad490d2c504	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x015514ab18515b7951616a1087d4c5d326816639	false	6780000	5	0x7f5c764cbc14f9669b88837ca1490cca17c31607	21922593	34218995894824673990031242	0x015514ab18515b7951616a1087d4c5d326816639	2022-09-04T16:52:32.000Z	0x202ac9a582048f6cc353438d37bf7ca445044b93b7c465d3dbcf06babf43fe9d	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0169f84ca058f2f858ba9b9d3508a73bb7f66fd6	false	140000	5	0x7f5c764cbc14f9669b88837ca1490cca17c31607	21881378	34241139681288232313753903	0x0169f84ca058f2f858ba9b9d3508a73bb7f66fd6	2022-09-04T07:43:14.000Z	0xd452d5ef22b4fe1e315e8c57f6ddf7c1d08a1fb56f22ccf0fd7538e02ac44626	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	214675826	0x32ad28356ef70adc3ec051d8aacdeeaa10135296	114	107338	122960713	0x32ad28356ef70adc3ec051d8aacdeeaa10135296	2024-07-21T00:03:23.000Z	196	0x62fe6dfb12af2b1b1c87a873e5002d2965648baade00a25f66ee0fd5d10baace
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	33510051	0x32ad28356ef70adc3ec051d8aacdeeaa10135296	61	16755	122988879	0x32ad28356ef70adc3ec051d8aacdeeaa10135296	2024-07-21T15:42:15.000Z	196	0x3d86404c6b0dabe813d95f7b4b71e8cfc53c41047077293b85cfd10987763367
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	6254894785	0x32b1d1bfd4b3b0cb9ff2dcd9dac757aa64d4cb69	72	3127447	122963183	0x32b1d1bfd4b3b0cb9ff2dcd9dac757aa64d4cb69	2024-07-21T01:25:43.000Z	196	0x303e9cb843e91b542befcd45788b57f66e57c834047b4a9fb1eacb483dd99ac5

Example Query

Query with partition filter

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

LendingPool_LiquidationCall_event

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

Columns

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

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xc8ece5c0e0024c477b16b9840e311d517a639c0b	false	12	79735365	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x9999b50bb6fc4ac42ddc5f10518e406549ebc3a0	13296957	2023-03-10T07:17:27.000Z	false	0x651ea784bfff59d072758c756fc2346dbd1837bb7ad938378d9e2cbc6176b5ea	0x4200000000000000000000000000000000000006	9969959955927057
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x2b0d1e5a1e1cb285db8c8c85d336718df7910bab	false	12	79726612	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	0x9999b50bb6fc4ac42ddc5f10518e406549ebc3a0	51780293	2023-03-10T06:46:39.000Z	false	0xa2519f8b7337a548f9780c1b2d3515b39da6dd83f16ebaa1d949c03ed29c08a7	0x4200000000000000000000000000000000000006	38362241693740028
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1751c6a506e9af85aa8bfc925a3af1ef1d9580ec	false	12	79774696	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	0x9999b50bb6fc4ac42ddc5f10518e406549ebc3a0	200249055595841189031	2023-03-10T10:19:04.000Z	false	0x697ec968491c7f56d3b0781bbcfa7bc2f6d268db86318d85ee3903612c076380	0x76fb31fb4af56892a25e32cfc43de717950c9278	3324126544747905559

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

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

Columns

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

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	129	0xc40f949f8a4e094d1b49a23ea9241d289b7b2819	140683469	2025-09-04T06:01:55.000Z	5343036664093074065	0x0070cefb973fb921e473a838aca32799376b0c3abce8046e625865e9f1cae5b2
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	135	0x0b2c639c533813f4aa9d7837caf62653d097ff85	140683469	2025-09-04T06:01:55.000Z	406285029	0x0070cefb973fb921e473a838aca32799376b0c3abce8046e625865e9f1cae5b2
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	105	0x7f5c764cbc14f9669b88837ca1490cca17c31607	140683469	2025-09-04T06:01:55.000Z	207782426	0x0070cefb973fb921e473a838aca32799376b0c3abce8046e625865e9f1cae5b2

Example Query

Query with partition filter

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

LendingPool_Repay_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xf23fda58c7b927abae31a3c83809424f748c5b88	false	159087904407064199066	5	0xf23fda58c7b927abae31a3c83809424f748c5b88	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	38692744	true	2022-11-16T11:45:35.000Z	0x31afcd42348411e15bbbf3e8d0f6049edceb5607a33b63f2b3bd4c3ef0e44101
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xf23fda58c7b927abae31a3c83809424f748c5b88	false	242748131598200092738	5	0xf23fda58c7b927abae31a3c83809424f748c5b88	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	38690995	false	2022-11-16T11:37:03.000Z	0xbae86d33eba0b4b497f87fce274fe9499b774850b8facd31590b7fa6e86a3f04
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x3afeb77d4df9393cd8da93b29d0987c9d74538eb	false	211830511706527606	25	0x3afeb77d4df9393cd8da93b29d0987c9d74538eb	0x4200000000000000000000000000000000000006	38760415	false	2022-11-16T15:48:26.000Z	0x77c2ff3cffade3dffafb099b6cff8e9612db8c411e0034c4b2137f791f9cf036

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	64	0x76fb31fb4af56892a25e32cfc43de717950c9278	111755346	2023-11-04T14:51:09.000Z	0	0xf8eee5e71c62ab3a0c8533849f46c06817d3d8cd9e66fe777c4141f66752a40c	1000003861773615944638482900	90000000000000000000000000	0	1000000000000000000000000000
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	60	0x4200000000000000000000000000000000000042	111728694	2023-11-04T00:02:45.000Z	1347568822954352042742815	0x703e8a1e9325f4cb4ea4dd595b70acb1ec0409c020e9fc4411157255a440bd30	1000344681151569585774998831	90000000000000000000000000	16187256442337994207822833	1000256586581871261026737060
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	56	0x4200000000000000000000000000000000000042	111729300	2023-11-04T00:22:57.000Z	1411583497529895340095978	0x6261424ffd041e00c292acc85c60df1d6c0ca93a2e884c70af1011391a13cc49	1000344732959546662386410256	90000000000000000000000000	16567274035403238784980082	1000257208854666409438942822

Example Query

Query with partition filter

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

LendingPool_Supply_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0887184a115a1fdbe293a24ef395aa57b22d95aa	false	1	32	0x0b2c639c533813f4aa9d7837caf62653d097ff85	127001570	0x0887184a115a1fdbe293a24ef395aa57b22d95aa	2024-10-22T12:58:37.000Z	0x632995a9e9603f77d0f32a679411724a7b5061b5692b6e73cd3b857907ff9135
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0a597325c656d3d10c3a7d293e0c066325255555	false	7334511826	35	0x0b2c639c533813f4aa9d7837caf62653d097ff85	126996264	0x0a597325c656d3d10c3a7d293e0c066325255555	2024-10-22T10:01:45.000Z	0xe57afd46ab6387d4bb84d7c1c0c4e9c32cace3be9b6c7fc0cff32b041f621fd9
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0b03e110ef81cf0028949996398b48c5732a08c6	false	22442367897	21	0x0b2c639c533813f4aa9d7837caf62653d097ff85	127001492	0x0b03e110ef81cf0028949996398b48c5732a08c6	2024-10-22T12:56:01.000Z	0x02ebf361dcf5903d29d1603550bed443b67677b04db54dd7caaa131b43b920ad

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x1a8bf92abe1de4bdbf5fb8af223ec5fedceffb76	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1a8bf92abe1de4bdbf5fb8af223ec5fedceffb76	false	522115160047	41	0x7f5c764cbc14f9669b88837ca1490cca17c31607	93996865	2023-04-25T04:07:30.000Z	0x360e9e0c304a4aeb4908fc240a9f8c8ce1fa242a5b5e69b4d9b9746aab063b29
0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	0x794a61358d6845594f94dc1db02a252b5b4814ad	0xfe7296c374d996d09e2ffe533eeb85d1896e1b14	false	605936967	35	0x7f5c764cbc14f9669b88837ca1490cca17c31607	93957150	2023-04-25T00:00:38.000Z	0x8c9f41e61ae7864c49b25268770998c05aefb23ac281bcf70b05010d25686778
0x3fa18d0cbaf4c9d5078e758b3deade077ca525cb	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x58ffcdac112d0c0f7b6ac38fb15d178b83663249	false	15116876	65	0x94b008aa00579c1307b0ef2c499ad98a8ce58e58	93957150	2023-04-25T00:00:38.000Z	0x8c9f41e61ae7864c49b25268770998c05aefb23ac281bcf70b05010d25686778

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
5800	0x8145edddf43f50276641b55bd3ad95944510021e	false	0x4200000000000000000000000000000000000042	8	121349556	2024-06-13T16:58:09.000Z	0xa4bdb30a9252e8f5a5292498d53938a2f76fac000f2e25a509c6b99229cbfef9	11000	6300
7800	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	1	94193883	2023-04-25T17:35:14.000Z	0xb1b95b09bad8a17d0d51fa1d36a29ed7739ce86d8e4ce7fae91cf64237f6ebc3	10500	8300
7300	0x8145edddf43f50276641b55bd3ad95944510021e	false	0x68f180fcce6836688e9084f035309e29bf0a2095	0	94193883	2023-04-25T17:35:14.000Z	0xb1b95b09bad8a17d0d51fa1d36a29ed7739ce86d8e4ce7fae91cf64237f6ebc3	10850	7800

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

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

Columns

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

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x0b2c639c533813f4aa9d7837caf62653d097ff85	1000	32	112788107	2023-11-28T12:36:31.000Z	0x85a6c4668f31c070159fb10570f0ff1cb0b2277795d9006259ec5062ea9ed85c
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x4200000000000000000000000000000000000042	1000	8	68225542	2023-01-17T01:17:58.000Z	0x1bde745a6f116c1d854975fc91c695570a081fac0eaaac02677e9932513819e6
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xdfa46478f9e5ea86d57387849598dbfb2e964b02	1000	14	98429188	2023-05-15T09:37:27.000Z	0x50b7a5757a9501e85ee6c0c6fa46b5462f64b713c7b0f4dd49a432c11efc4e10

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x7f5c764cbc14f9669b88837ca1490cca17c31607	34	123949347	2024-08-12T21:17:51.000Z	0xf70b1ce3d3cee1c36b04373ec7d0079ef3731fb074fe5912704677a5acb59bd1	3000	2500
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	148	123930900	2024-08-12T11:02:57.000Z	0xac199dc0d6460ad0ce2a1b7860f988fb0519b8148c7db7c5cac044340b11aec9	500	1500
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xdfa46478f9e5ea86d57387849598dbfb2e964b02	0	112700259	2023-11-26T11:48:15.000Z	0x50097b7a4ae1464f7c78b3be86da487b15a4aa8f9e7b95784844a4c279145b1d	9500	2000

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

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

Columns

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

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x4200000000000000000000000000000000000042	0x513c7e3a9c69ca3e22550ef58ac1c0088e918fff	4	68225542	2023-01-17T01:17:58.000Z	0x1bde745a6f116c1d854975fc91c695570a081fac0eaaac02677e9932513819e6	0x08cb71192985e936c7cd166a8b268035e400c3c3	0x77ca01483f379e58174739308945f044e1a764dc	0xee1bac9355eaafcd1b68d272d640d870bc9b4b5c
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x9bcef72be871e61ed4fbbc7630889bee758eb81d	0x724dc807b04555b71ed48a6896b6f41593b8c637	13	107128612	2023-07-20T12:26:41.000Z	0x1d8b04166d66cedce492cbe38185b6ddd76f7bd059bfe48cae20c137acea0111	0xdc1fad70953bb3918592b6fcc374fe05f5811b6a	0xf611aeb5013fd2c0511c9cd55c7dc5c1140741a6	0x3b57b081da6af5e2759a57bd3211932cb6176997
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x4200000000000000000000000000000000000006	0xe50fa9b3c56ffb159cb0fca61f5c9d750e8128c8	7	4365785	2022-03-11T13:50:03.000Z	0x057b33da19a695e1dbc2d77e00929699c4ec72eef3edcac966313c53520edd75	0xd8ad37849950903571df17049516a5cd4cbe55f6	0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	0xee1bac9355eaafcd1b68d272d640d870bc9b4b5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x746c675dab49bcd5bb9dc85161f2d7eb435009bf	0x	false	0x41dacfa8bc41221f46c780fd6469dad4cdccef83	46	112788107	execute()	0x	2023-11-28T12:36:31.000Z	1701174991	0x85a6c4668f31c070159fb10570f0ff1cb0b2277795d9006259ec5062ea9ed85c	true
0x746c675dab49bcd5bb9dc85161f2d7eb435009bf	0x	false	0x504d3d47b7414f0329d653d8134fe22fe2516c62	42	119690311	execute()	0x	2024-05-06T07:09:59.000Z	1714979399	0x167f32c175f561473a47b2b8c182802cc8ed388ae7d0185e44391dae34127773	true
0x746c675dab49bcd5bb9dc85161f2d7eb435009bf	0x	false	0xdc2ec885bf5d9de4d1e258f13bca78b524cf8212	94	125273069	execute()	0x	2024-09-12T12:41:55.000Z	1726144915	0x165896f9e7d41e3caf2eb750727b92fec67e9217b4a9d31dc78d57d23c619769	true

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0xbaf95bb30cdab3d5b7a11b67edef5631bd62be86	false	0x2691f337abeb0146f16441ca4f82f363275851d5	1892875086334653125	0x2691f337abeb0146f16441ca4f82f363275851d5	1891292636035735181	54	139403340	2025-08-05T14:50:57.000Z	0xf75981c86a88a9a3a113ce3649f1e88807a86c02180a2394ce944e09b31c7e67
0x8e6a81b9d541a0cea090818b62c4b2de7f2a2cf7	false	0x3611b82c7b13e72b26eb0e9be0613bee7a45ac7c	31660256933053409	0x3611b82c7b13e72b26eb0e9be0613bee7a45ac7c	31644741479143263	76	139419222	2025-08-05T23:40:21.000Z	0xb2283c899bb0af392955e16b5c4f4d22df8c6e18f7eb1fbb735a74aacf8e2c03
0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	false	0x4661f836f07c78a01d5490bff6e8587b9291c6b8	26149591	0x4661f836f07c78a01d5490bff6e8587b9291c6b8	23434853	33	139413448	2025-08-05T20:27:53.000Z	0x2c2a62ec14dc05ce0c4531c31c2893c8445e6b9cd9605c4855149e3767e670bd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	false	65	1	132996299	2025-03-10T07:22:55.000Z	0x6496d5ec31092ddfb2f9028f04eec1e357f1673955977fbec40df00eaeabda76
0x0ec63a55a688e5ba26afe8d9250114505e8b60a0	false	8	1	135132926	2025-04-28T18:23:49.000Z	0x2b91889dd9b93dbc0f728117c3f79c6125a2acd0f4f4224d5955834198a101a1
0xc438643b0eee8a314eec53eb8a1ee6467c88fc24	false	10	1	135132884	2025-04-28T18:22:25.000Z	0x71d600c3afa4a13a8125e6433f155ec997351747a58eba686defe187f67b5721

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	false	0x1b52af3d107491c2036d745478176eb3c7863eb5	33891142	0x1b52af3d107491c2036d745478176eb3c7863eb5	30515659	140	0x146eda2f1d35efb5eef5703acec701c68e1503d8	137416151	2025-06-20T14:51:19.000Z	0xf93e34fd05465ca7f2cd1996e0ea371cfa3744b34990fb2fbb09cd26c1981650
0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	false	0x1b52af3d107491c2036d745478176eb3c7863eb5	30380169	0x1b52af3d107491c2036d745478176eb3c7863eb5	27353532	34	0x146eda2f1d35efb5eef5703acec701c68e1503d8	137431291	2025-06-20T23:15:59.000Z	0xb1d8bf5e539b48856d8939d2b1cdc6b1015e2efaeef6e34f533b315a0a961676
0x41b334e9f2c0ed1f30fd7c351874a6071c53a78e	false	0x1b52af3d107491c2036d745478176eb3c7863eb5	39458209	0x1b52af3d107491c2036d745478176eb3c7863eb5	35529047	48	0x146eda2f1d35efb5eef5703acec701c68e1503d8	137405130	2025-06-20T08:43:57.000Z	0xe48e318e06e205780db1822058c6b44fde7ca72572a7ea7ca6024550604a5e65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x170d6d6fcabf0ba3932a03d5f470c16c39c18e39	false	12	135132926	0x0ec63a55a688e5ba26afe8d9250114505e8b60a0	0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9	2025-04-28T18:23:49.000Z	0x2b91889dd9b93dbc0f728117c3f79c6125a2acd0f4f4224d5955834198a101a1
0x170d6d6fcabf0ba3932a03d5f470c16c39c18e39	false	14	135132884	0xc438643b0eee8a314eec53eb8a1ee6467c88fc24	0x350a791bfc2c21f9ed5d10980dad2e2638ffa7f6	2025-04-28T18:22:25.000Z	0x71d600c3afa4a13a8125e6433f155ec997351747a58eba686defe187f67b5721
0x170d6d6fcabf0ba3932a03d5f470c16c39c18e39	false	21	135132824	0x8e6a81b9d541a0cea090818b62c4b2de7f2a2cf7	0x9bcef72be871e61ed4fbbc7630889bee758eb81d	2025-04-28T18:20:25.000Z	0x1493c4016f8a07a28ae1e6142982a474423526f1ee79c1102517480a24d8863b

Example Query

Query with partition filter

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

SToken_Burn_event

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

Columns

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

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0x21357415221ea83f81855998c091bc630c6d2439	false	900000	1	45200605	2022-12-04T08:21:48.000Z	51326137665553187268870574	0xdd1be575f5a8c73da95e6e311803eb7f90e4b65643ea1452e43966d4ea13686e	900000	352043777169	0
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0xb6c0ab6fa80ae76be37ab82abccbf6da4ca34ebe	false	444000000	1	45373149	2022-12-04T17:21:56.000Z	51326137585487148786879883	0x387bc38e97e2d18daee2b9c193f865890ffcce3088da1afe31ac90c32f04a5bc	444000032	352062547653	32
0x70effc565db6eef7b927610155602d31b670e802	0xd3d27b35bf301b9bcb01e0784fe9fd1ee80eb04d	false	500000	1	45260004	2022-12-04T11:41:10.000Z	56458227392402949999335367	0x60f3463fc9bf2d38c3c1a365f88f4642b1f1e413355d970b5d3e8ab9a161cf7e	500000	1990914198653	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0xd6ab15700f2fc1b31f293a32c502bde51cc532a3	false	2100001116	1	52110809706901136267559272	9348955	0xd6ab15700f2fc1b31f293a32c502bde51cc532a3	2022-05-31T00:25:33.000Z	52761332004892046098865351	0x00a93dac28090ad48c37a005f3bae42e642ef06507b1057d9a860e547d67d22a	3500001116	173486954507	1116
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0x20ae6ab571c6899940bac00a31da54f0c93ce740	false	5000000	1	52249098137557000000000000	9369634	0x20ae6ab571c6899940bac00a31da54f0c93ce740	2022-05-31T07:12:06.000Z	52766104155892038982038090	0xddbd541da0914f3a3b190bf0b912e67cc4467c447fc5acfe3deaa607757839d5	0	172232317470	0
0xd94112b5b62d53c9402e7a60289c6810def1dc9b	0xa322e3ea5028e9cc5f6a3c1574c16d50f54902ca	false	10000000000000000000	1	52187040307295019929161100	9376841	0xa322e3ea5028e9cc5f6a3c1574c16d50f54902ca	2022-05-31T09:14:28.000Z	52963387480912114246057757	0x02a56852dcb343d7abad082d22cfccfc2f29c28bc8c64b3ac7fb566f4b902e80	0	24096159134163669335120	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	0xee59e3ec98c8f3227ce7a0998ef35b12008ca683	false	1062091872392277293706742570	448000000000000000	0x0000000000000000000000000000000000000000	31	120555295	2024-05-26T07:42:47.000Z	0xebf2aa88231221930295bd139bc42d802f99c7cfc7b58e24627dafe180f233f8	130645509206053
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	0xb49005bedcfba85a5562801f32420ea1f9b4cd35	false	1062124877942566010830163993	149999950960423091	0x0000000000000000000000000000000000000000	18	120578398	2024-05-26T20:32:53.000Z	0x5ec2d48144d5181ba0449b70da2ee203d1d9408ac28ec87d899bef0d127b4d4b	49039576909
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	0xef22d4235aa03bffa3f52f27edb09d62bb204a25	false	1062074529959887159342733574	139999943409308477	0x0000000000000000000000000000000000000000	92	120543212	2024-05-26T01:00:01.000Z	0x6dc2ad9b3c108e1d0c87f7eba8b8f0d15091c90482a5876700da6c77f4e66931	56590691523

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_optimism.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
0x34e2ed44ef7466d5f9e0b782b5c08b57475e7907	false	1002083470018452196914500728	97792000000000000000	0xb1d72dd9cd988c727b160886b864ee0004965c8a	1	99887432	0xb1d72dd9cd988c727b160886b864ee0004965c8a	2023-05-20T06:39:41.000Z	0x60bfc98248b69a337c47941d2d7cfecaaf5d978aba2b6e8df09aec554df505a7
0x34e2ed44ef7466d5f9e0b782b5c08b57475e7907	false	1002085933593595456852188472	97800000000000000000	0xb1d72dd9cd988c727b160886b864ee0004965c8a	1	99916509	0xb1d72dd9cd988c727b160886b864ee0004965c8a	2023-05-20T09:13:59.000Z	0x3ea59ff3c8b241893bc1bfba7aeb1636666a188b43c7d251992b1e260540fd10
0x34e2ed44ef7466d5f9e0b782b5c08b57475e7907	false	1002097342277704831827614639	71112000000000000000	0xabb4f79430002534df3f62e964d62659a010ef3c	1	100044910	0xabb4f79430002534df3f62e964d62659a010ef3c	2023-05-20T21:57:01.000Z	0xda3d24b0f722e9d0fd9b85309389df942fe871c3595a242e1801928a7194cb4f

Example Query

Query with partition filter

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

WrappedTokenGatewayV3_withdrawETH_function

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

Columns

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

Sample Data

gas	in_to	status	gas_used	in_anon0	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
379388	0xb8a028bc434880da148c322ddce703af5e741c85	true	237599	0x794a61358d6845594f94dc1db02a252b5b4814ad	10000000000000000000	0x80500d20	0x5f2508cae9923b02316254026cd43d7902866725	142080406	0xb8a028bc434880da148c322ddce703af5e741c85	2025-10-06T14:06:29.000Z	0xb62339d8ca311eeb9a79663197971afcb2c1b495911902b6fa5096a6f93828da
437738	0xbe88590088585ee8ba69650a2bad7348d5271db7	true	248040	0x794a61358d6845594f94dc1db02a252b5b4814ad	1000000000000000	0x80500d20	0x5f2508cae9923b02316254026cd43d7902866725	142085381	0xbe88590088585ee8ba69650a2bad7348d5271db7	2025-10-06T16:52:19.000Z	0x373d4c6624b14001cb9d305d59362539621f8e148ba6c45ba0cdf6d174fc63bb
437756	0xf2c9bd65d82a1a14e6a5f93d014e408a98b9f860	true	248052	0x794a61358d6845594f94dc1db02a252b5b4814ad	1400000000000000000	0x80500d20	0x5f2508cae9923b02316254026cd43d7902866725	142080386	0xf2c9bd65d82a1a14e6a5f93d014e408a98b9f860	2025-10-06T14:05:49.000Z	0xaf23193f820e9e62f2c32ca74fbdfc4cf37989c2f8bb823fabec82dca10f5f5f

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​IncentivesController_RewardsClaimed_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​ShortExecutor_ExecutedAction_event

​StataToken_Deposit_event

​StataToken_Initialized_event

​StataToken_Withdraw_event

​StataTokenFactory_StataTokenCreated_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV3_withdrawETH_function

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function