aave_v3_fantom

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
0x17d013c19fe25cf4d911ce85ed5f40fe8880f46f	0x6d80113e533a2c0fe82eabd35f1875dcea89ea97	0xabe1e936bd6c031573e29998563b8121d7e3d0af	false	1015147671131695527547519558	1057011286014968698098	16	40388164	2022-06-13T00:03:47.000Z	0x09486e12f01272606e55fe6482546f4158b5ba54dba17c78b52639fab7c9a924
0x17d013c19fe25cf4d911ce85ed5f40fe8880f46f	0x6d80113e533a2c0fe82eabd35f1875dcea89ea97	0x400f9dd9f754c483aa90b4a4616a806fb3763cca	false	1015157138300936528915138810	20000641115114510516	39	40388722	2022-06-13T00:20:35.000Z	0xe9a09563580745be4f187c4eda96c2e2dbc1e9f1cae2aedfb384866631a91e90
0x17d013c19fe25cf4d911ce85ed5f40fe8880f46f	0x6d80113e533a2c0fe82eabd35f1875dcea89ea97	0xa50a0b277a7d4a138c0a4c34b3b6deb6f6f0ee03	false	1015211816993875640489594517	641289205351398304765	12	40393966	2022-06-13T02:07:52.000Z	0xc960f4ae9f95eee77194e527b69676b2afe204e3c1e66961fee1433eebe476f5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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
0x078f358208685046a11c85e8ad32895ded33a249	0x35dde5599318112829d97a29f4e8f4c49aafc47c	false	1000001322476070879704651791	1180791	0x35dde5599318112829d97a29f4e8f4c49aafc47c	27	36871695	2022-04-24T17:11:30.000Z	0x802ee01dbb1a8042bb359738e3add70ef4abf8567279a73feefefa6c80963112	1
0x078f358208685046a11c85e8ad32895ded33a249	0x516db224ce62a3c49dc5de6aa448ec48e6c3e291	false	1000001276513240006013909425	4016154	0x516db224ce62a3c49dc5de6aa448ec48e6c3e291	2	36861724	2022-04-24T14:05:12.000Z	0x8d25f417ca1387e9e952c22510905c0b96d80e263598926d2225ea3d6bdcf139	1
0x078f358208685046a11c85e8ad32895ded33a249	0x554d7c5f264f3d2b3ee94a718ba365610169f44b	false	1000001188436410660523876278	220001	0x078f358208685046a11c85e8ad32895ded33a249	4	36843303	2022-04-24T08:10:13.000Z	0xc492bbfbaa1f208d7fae8ee6c3fdeb89f044bb9f8a8de40703a4c6b110d367bd	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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
0xe50fa9b3c56ffb159cb0fca61f5c9d750e8128c8	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x10	61	0xbe85413851d195fc6341619cd68bfdc26a25b928	33143853	Aave Fantom WETH	2022-03-11T14:16:17.000Z	aFanWETH	0x27c89a7c8bfcc9944f05502b577d7e23c7b692bfae79e617adee62de538f7d5a	18	0x74b23882a30290451a17c44f4f05243b6b58c76d	0x6a83d738fcbab0c3973234ac7b7b4f7dda2ad248
0x078f358208685046a11c85e8ad32895ded33a249	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x10	57	0xbe85413851d195fc6341619cd68bfdc26a25b928	33143853	Aave Fantom WBTC	2022-03-11T14:16:17.000Z	aFanWBTC	0x27c89a7c8bfcc9944f05502b577d7e23c7b692bfae79e617adee62de538f7d5a	8	0x321162cd933e2be498cd2267a90534a804051b11	0x6a83d738fcbab0c3973234ac7b7b4f7dda2ad248
0x6ab707aca953edaefbc4fd23ba73294241490620	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x10	65	0xbe85413851d195fc6341619cd68bfdc26a25b928	33143853	Aave Fantom USDT	2022-03-11T14:16:17.000Z	aFanUSDT	0x27c89a7c8bfcc9944f05502b577d7e23c7b692bfae79e617adee62de538f7d5a	6	0x049d68029688eabf473097a2fc38ef61633a3c7a	0x6a83d738fcbab0c3973234ac7b7b4f7dda2ad248

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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
0x625e7708f30ca75bfd92586e17077590c60eb4cd	false	1009122595729352371130591928	24556836	0x744db9648a1d8d610ba48e2ae1d8535ee6922564	55	48968867	0x744db9648a1d8d610ba48e2ae1d8535ee6922564	2022-10-12T00:48:23.000Z	0xe0d0b41c2598ca8f84265286c7c2888dbad67b5da884cea83e6e0594190847d7	34556836
0xe50fa9b3c56ffb159cb0fca61f5c9d750e8128c8	false	1000251130568389484017038589	80072029176499206	0x0aa2ac7f8e89aae67ab58583b1a95676db4e73f3	3	42028181	0x0aa2ac7f8e89aae67ab58583b1a95676db4e73f3	2022-07-04T22:16:22.000Z	0x64b01d8016dfc12bc8a14a6c4d8a203453e16fa54fc4ab08fed2d3dc5a2e46e6	72029176499206
0x6d80113e533a2c0fe82eabd35f1875dcea89ea97	false	1018875327135735562618008954	180000000000000000000	0x17d013c19fe25cf4d911ce85ed5f40fe8880f46f	9	41978512	0x0caad2ba733db214e4e492698cab764ef3b5e81c	2022-07-04T07:10:07.000Z	0xe4ff97c8ea195a2eccb763e3d1e374a7eb4ae0f567be707372e726721eeffa5f	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0ce652a4df6184669643af24756fba22010e1680	false	10936	4	0x049d68029688eabf473097a2fc38ef61633a3c7a	44359817	69136275632700019704244763	0x0ce652a4df6184669643af24756fba22010e1680	2022-08-06T19:04:04.000Z	0x496224d94f0bd552e0c03178f09ee478fc552e751dd0af38ba09adff72124e8b	1
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xbce03405638247f5ca3ea767b2367b1af307ea81	false	7500000000	16	0x04068da6c83afcfa0e13ba15a6696662335d5b75	44342455	15718693003113473569151377	0xbce03405638247f5ca3ea767b2367b1af307ea81	2022-08-06T12:46:22.000Z	0x36e060e32e89774c452c94181181c6377dbb51784bd24265f31eff1192a88b1e	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xeabcc3bec1a93cda596080cde3c2fa19f3522aba	false	370000000	36	0x04068da6c83afcfa0e13ba15a6696662335d5b75	44309119	17331595860505999865984158	0xeabcc3bec1a93cda596080cde3c2fa19f3522aba	2022-08-06T01:15:20.000Z	0x4d5bd5ab454429cbccb8547848d3e991185b3f502b535e02085edc0fb62be4dc	2

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

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

Columns

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

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	2864607294	0x2956914591e03ee87d56d8d2281de938c985c2e0	49	1432304	57465230	0x2956914591e03ee87d56d8d2281de938c985c2e0	2023-03-12T20:29:09.000Z	0xe1c46364e01fa1e5c0bc17fb56c7b561a8b91607ed64e3d45f3076fed1bf1cff
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	1411427864	0x2956914591e03ee87d56d8d2281de938c985c2e0	35	705714	57456416	0x2956914591e03ee87d56d8d2281de938c985c2e0	2023-03-12T17:26:04.000Z	0xa8b9ee6ba761f7fc8f2e52b3015624536eefaf800c841ab16bb91b90ec0f9fbd
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x04068da6c83afcfa0e13ba15a6696662335d5b75	1377851243	0x2956914591e03ee87d56d8d2281de938c985c2e0	21	688926	57435092	0x2956914591e03ee87d56d8d2281de938c985c2e0	2023-03-12T06:43:07.000Z	0xf3392c4c6a093bb6880bf8495cd99d863f899a1d74bf0a90c9a78a9fc7699cf3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0x9249f2c06c7d69b3b4418fb416900c271f93764a	false	80	40560160	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x0000000eb7d8244007da6cd63a512ec69494b231	22513059172	2022-06-15T08:03:35.000Z	false	0xbce273f8843750b6b0f412dc27e96c5fcd9dd1e3df91efb5d189a792e2a083a7	0x321162cd933e2be498cd2267a90534a804051b11	115907035
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xf22c7d84a28b0f13aa7e37ef4e4e2edf8e1e4e3a	false	88	40560529	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x0000000eb7d8244007da6cd63a512ec69494b231	500957161	2022-06-15T08:13:19.000Z	false	0xa394476d7ef592cfafad38afe6444dd2a2382e7aa792906b6bed5f0082c90847	0x74b23882a30290451a17c44f4f05243b6b58c76d	493476892524176930
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xfda21e7df73763a68211dae4ed029bdedb8c5c0a	false	13	40562303	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x0000000eb7d8244007da6cd63a512ec69494b231	1571011198	2022-06-15T08:51:05.000Z	false	0xdaabff9f626028a7af115f40c91fa0268006aade3a260ffb7d4be4b43eaa83f3	0x74b23882a30290451a17c44f4f05243b6b58c76d	1577090026192781996

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0x4a5c7161544432594435ed7a5d143f89a480820b	false	80808452452838304451	48	0x1408401b2a7e28cb747b3e258d0831fc926bac51	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	57450162	false	2023-03-12T14:02:19.000Z	0x851c0fc3268280424ba5e0130d603c2e51c9c57a93211fbbacfc66bbd9140fbe
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1f2066839072a339e3f2e15b4c445ab494f34e9e	false	349023	4	0x1f2066839072a339e3f2e15b4c445ab494f34e9e	0x04068da6c83afcfa0e13ba15a6696662335d5b75	57420828	false	2023-03-12T01:09:37.000Z	0xbcab98bc622cc60dc0c1aa7bdedda040e7208b6c7ce353afb49c93b854908580
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0771190e59e8fc016506ac49c2db580cd84d866f	false	550344337	33	0x0771190e59e8fc016506ac49c2db580cd84d866f	0x04068da6c83afcfa0e13ba15a6696662335d5b75	42955392	false	2022-07-17T10:40:15.000Z	0x4c2e13d5856d21a9eab045111bf8cebf3ba33e0c3a95cdcfbeb63ac4398064e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	63	0x321162cd933e2be498cd2267a90534a804051b11	40409934	2022-06-13T07:16:34.000Z	3056122733914810207973	0xa33cb8f4f74fd2befd778c80640dd5bea68c47b39ddbac7d3f452a1fde5ad790	1000076400089374995957133149	90000000000000000000000000	770873587010288617598591	1000227760969043433038362312
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	52	0x321162cd933e2be498cd2267a90534a804051b11	40410014	2022-06-13T07:18:02.000Z	3058258952851586091582	0xacf7e1039caa392907f50a6052f498e2db24efbb34c331e74e94e31764ead63a	1000076400097903640919490593	90000000000000000000000000	771142958895735984767242	1000227763120626586310521832
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	64	0x321162cd933e2be498cd2267a90534a804051b11	40411767	2022-06-13T07:53:47.000Z	3144363592937330294456	0xab7f3ce02a9d28155e8bb05ea7ebc5074b7cb1827faa4bc421b9e63f851f9a00	1000076400308222223216204397	90000000000000000000000000	781923290329709923090618	1000227815870619501390434239

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0x154ba9e3defed8ba5a97d879911c990ae934382e	false	98860145	99	0x04068da6c83afcfa0e13ba15a6696662335d5b75	37905142	0x154ba9e3defed8ba5a97d879911c990ae934382e	2022-05-09T11:00:00.000Z	0x819511fa820e7f46fb3172d9082de9976ea16243cbbf573ec09193675dd16b20
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x185077247ea1ba50b06e361578d54719a8c9e2c3	false	70000000	21	0x04068da6c83afcfa0e13ba15a6696662335d5b75	37906966	0x185077247ea1ba50b06e361578d54719a8c9e2c3	2022-05-09T11:44:43.000Z	0x8362dbfcc9befc48352e28c99823442cfe4e42cd5608ac8f33604f892b64783c
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x21077c224b7178b1bb46af8dcd73f1ebad869b0b	false	16311048320	22	0x04068da6c83afcfa0e13ba15a6696662335d5b75	37919911	0x21077c224b7178b1bb46af8dcd73f1ebad869b0b	2022-05-09T16:05:25.000Z	0xaef396180192c7f15f04dbea7e7d05c36e226b5be8eeb6e8b56a8880dee2ddc9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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
0x046ae0974283a9acf5cb4228a93d000c6d0ffd76	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x046ae0974283a9acf5cb4228a93d000c6d0ffd76	false	36601765609838011662	22	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	47931490	2022-09-28T10:11:59.000Z	0x7a044d4fe18a2217a92d405e4300dbd02feab803d5a60a0ad8dfe257deffb3e3
0x1408401b2a7e28cb747b3e258d0831fc926bac51	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1408401b2a7e28cb747b3e258d0831fc926bac51	false	456880854819365561451	45	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	47908275	2022-09-28T02:44:33.000Z	0x41f4d2b67ffd756772b07d9eb9cf774ab24ec674dfd42dfc0ff08f39c96adb71
0x1408401b2a7e28cb747b3e258d0831fc926bac51	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1408401b2a7e28cb747b3e258d0831fc926bac51	false	17664486189559413521025	39	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	47962604	2022-09-28T20:28:31.000Z	0x550a3c6493b87ae5b9c21ddc3aba7eb3f9dd73f896ab22bcc9678466e256417d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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
2000	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xae75a438b2e0cb8bb01ec1e1e376de11d44477cc	104	33143911	2022-03-11T14:17:09.000Z	0x51d142f7e8682f779b6af14098e06405575e8e9965d7c24a953a461eea8d526c	11000	4500
2500	0x8145edddf43f50276641b55bd3ad95944510021e	false	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	92	33143911	2022-03-11T14:17:09.000Z	0x51d142f7e8682f779b6af14098e06405575e8e9965d7c24a953a461eea8d526c	11500	4500
5000	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xb3654dc3d10ea7645f8319668e8f54d2574fbdc8	59	33143911	2022-03-11T14:17:09.000Z	0x51d142f7e8682f779b6af14098e06405575e8e9965d7c24a953a461eea8d526c	10750	6500

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0x321162cd933e2be498cd2267a90534a804051b11	1000	107	33144143	2022-03-11T14:21:14.000Z	0x328bf8489325d46e19689dd6f638e5777c2b75bfbb34c349cee47eea0a224779
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x74b23882a30290451a17c44f4f05243b6b58c76d	1000	6	33144149	2022-03-11T14:21:19.000Z	0x5e89778c0f4bcb1b8a07896a66f113056135269264804c726c8cffafe5db73cd
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xae75a438b2e0cb8bb01ec1e1e376de11d44477cc	1000	36	33144185	2022-03-11T14:21:50.000Z	0x66fda6e0be8121154184a0a0b2da8e11ab45468bc9783b1709a04ef8d2a029c5

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

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

Columns

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

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x6a07a792ab2965c72a5b8088d3a069a7ac3a993b	91	33143911	2022-03-11T14:17:09.000Z	0x51d142f7e8682f779b6af14098e06405575e8e9965d7c24a953a461eea8d526c	0
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	58	33143911	2022-03-11T14:17:09.000Z	0x51d142f7e8682f779b6af14098e06405575e8e9965d7c24a953a461eea8d526c	1000
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x1e4f97b9f9f913c46f1632781732927b9019c68b	103	33143911	2022-03-11T14:17:09.000Z	0x51d142f7e8682f779b6af14098e06405575e8e9965d7c24a953a461eea8d526c	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0x74b23882a30290451a17c44f4f05243b6b58c76d	0xe50fa9b3c56ffb159cb0fca61f5c9d750e8128c8	64	33143853	2022-03-11T14:16:17.000Z	0x27c89a7c8bfcc9944f05502b577d7e23c7b692bfae79e617adee62de538f7d5a	0xd8ad37849950903571df17049516a5cd4cbe55f6	0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	0x4aa694e6c06d6162d95be98a2df6a521d5a7b521
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x049d68029688eabf473097a2fc38ef61633a3c7a	0x6ab707aca953edaefbc4fd23ba73294241490620	68	33143853	2022-03-11T14:16:17.000Z	0x27c89a7c8bfcc9944f05502b577d7e23c7b692bfae79e617adee62de538f7d5a	0x70effc565db6eef7b927610155602d31b670e802	0xfb00ac187a8eb5afae4eace434f493eb62672df7	0xee1bac9355eaafcd1b68d272d640d870bc9b4b5c
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x321162cd933e2be498cd2267a90534a804051b11	0x078f358208685046a11c85e8ad32895ded33a249	60	33143853	2022-03-11T14:16:17.000Z	0x27c89a7c8bfcc9944f05502b577d7e23c7b692bfae79e617adee62de538f7d5a	0x633b207dd676331c413d4c013a6294b0fe47cd0e	0x92b42c66840c7ad907b4bf74879ff3ef7c529473	0x4aa694e6c06d6162d95be98a2df6a521d5a7b521

Example Query

Query with partition filter

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

SToken_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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	0x25d93fb08635c3b0731039a62c8b060230c822ec	false	37000000	59	36129662	2022-04-15T15:31:25.000Z	55140129024402234705670554	0x18a46e08a2a444d71f7bcacc3b9b375903006bfecea8a4f35871e27a6e1a3f53	37000023	246225971165	23
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0x68e845717ea2ae0ca63e7b2c9f6052fe7397e96e	false	15004336725	39	36098865	2022-04-15T06:23:29.000Z	55145732017211446272864591	0xd645158ff36ba07613daeb61909f0ca6b8b609415a0cd7dd4a6822c8558b039d	45503555433	238512232785	12563808
0xd94112b5b62d53c9402e7a60289c6810def1dc9b	0x3441c49613f556c0bf62c788ef2c608ef8fb3899	false	248043078182045424941	29	34627451	2022-03-28T14:57:02.000Z	60042314449867956757577469	0xbe33d5f6ac9af3072f77d958379c4935a22bb1402d6bf572d5e36e9ed23a608a	248088129841358875920	31464801008936430120361	45051659313450979

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0xc870c80777762c152b1f71395783b69e8619fe4c	false	459532285	187	64145276863985825287945016	33616857	0xc870c80777762c152b1f71395783b69e8619fe4c	2022-03-16T23:58:47.000Z	64145276863985825287945016	0xbd3f06dd4f0c6fe8664e46a8fc0011c515238a88ffc51fd42094a1472b4ed230	1839475535	2299005149	2671
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0xc870c80777762c152b1f71395783b69e8619fe4c	false	1839472864	11	64048951304341724717065465	33616090	0xc870c80777762c152b1f71395783b69e8619fe4c	2022-03-16T23:46:52.000Z	64048951304341724717065465	0xc03f634a6e48358e3ad321ed945f90ddb6ab8422b7bb6b83df0bc7d7e8fa2efb	0	1839472864	0
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0x0dc23021bee290609fe97060aa3caed6411bce60	false	18722430	22	52220927920516197178127674	46627527	0x0dc23021bee290609fe97060aa3caed6411bce60	2022-09-09T05:34:35.000Z	53689653508012445926571697	0x37ba41343d615b5882494d1efdd9b143dbace9ab06b253fbe4afb79d953aa4c4	78769952	12440568013	24046

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.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	0x90ac122c9f55d23b860ed8d05a27edd16f113618	false	1000606953274246117609496666	1530386226417024848	0x0000000000000000000000000000000000000000	2	38580822	2022-05-19T11:28:01.000Z	0x219958a59bc9b3b8779a353ba788ba4b37d755284fb3c105b7f88c470f627ea1	662171124413008
0x4a1c3ad6ed28a636ee1751c69071f6be75deb8b8	0x12c43675e4f1547bcc24b621fae9d438c6355ac3	false	1025627170665497668484164296	349835579668731900828	0x0000000000000000000000000000000000000000	2	38596796	2022-05-19T16:33:23.000Z	0xf8229541571a72921ee8e0069097ff671cd9467b1953815d9a4e4b1aa6cc7977	615130918054365623
0x4a1c3ad6ed28a636ee1751c69071f6be75deb8b8	0x12c43675e4f1547bcc24b621fae9d438c6355ac3	false	1025636217640548152927663254	50164420331268099172	0x0000000000000000000000000000000000000000	13	38597342	2022-05-19T16:45:48.000Z	0xb0ef6e7cb31d8d3008509ad2236b2c11ff3e10dc521c966c40f6d63fcf8f9a9a	442496330186453

Example Query

Query with partition filter

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

VToken_Mint_event

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

Columns

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

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	false	1000042048167358043579247518	65001602813226497	0x0aa2ac7f8e89aae67ab58583b1a95676db4e73f3	48	35130658	0x0aa2ac7f8e89aae67ab58583b1a95676db4e73f3	2022-04-03T13:34:06.000Z	0x11909854773eb264fc71fd838ddf7973f39f10b7e60f100b77a22a77b8388425	1602813226497
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351	false	1000042805016878219128428304	22000000000000000000	0x1fd2166beff4b06230f053dd0de8a40cd925ff66	43	35152549	0x1fd2166beff4b06230f053dd0de8a40cd925ff66	2022-04-03T20:04:34.000Z	0x2e57da5728d8f26749d67888e0ba24e2a83788367c167db4deb579c7d41c44b7	0
0x4a1c3ad6ed28a636ee1751c69071f6be75deb8b8	false	1004744243106175030418244000	2002345228825421511669	0x17d013c19fe25cf4d911ce85ed5f40fe8880f46f	2	35132662	0x130e6d1a52b4577b3779f7cf50295d3b28e6a593	2022-04-03T14:12:04.000Z	0xa777f7033d6a80594a204214e21cdd0aa219cde32bed9d56c098023dd3ea33cc	2345228825421511669

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_fantom.VToken_Mint_event`
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_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

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_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

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_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event