aave_v3_gnosis

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
0x3e652e97ff339b73421f824f5b03d75b62f1fb51	0x23e4e76d01b2002be436ce8d6044b0aa2f68b68a	0xeab8c6ffcb27bcaab1167d41f920311f4c9c98a6	false	1000109812946832938294250210	252632066000243	18	41659780	2025-08-18T02:51:40.000Z	0x1faf4328ab20397b1fced2fbe5c5188f870328538390964754ff5615ad21317a
0x263ecee424cc549719c5da28f1ff5784dea103fe	0x23e4e76d01b2002be436ce8d6044b0aa2f68b68a	0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	1000109821510361378817171410	531574794560262	37	41668526	2025-08-18T15:27:25.000Z	0x0d81b8f52ec496a5621c8e4aea91f7b986f83fff663f1610bacef0e9a6f92414
0x57dd8a9d1517f3cd1431284aedc3aa41db3a62ea	0x3fdcec11b4f15c79d483aedc56f37d302837cf4d	0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	1000231135063661878972836855	1997966202596955436	48	41668605	2025-08-18T15:34:15.000Z	0x9f4f9ca525da504fa996e3d4f14f27e01577380c44043d97e787587e14da8b6f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x23e4e76d01b2002be436ce8d6044b0aa2f68b68a	0x5a4f0a744b70cbe2454be0586826e10a77650dcd	false	1000048492380831871030554635	6117382657862450292	0x6cae28b3d09d8f8fc74ccd496ac986fc84c0c24e	98	36921544	2024-11-08T17:07:30.000Z	0x3490c01c93f70a50e4488d3b76e3e92b5a2e4201d47458d5f23fafca75435fca	296346922458633
0x23e4e76d01b2002be436ce8d6044b0aa2f68b68a	0x8e11a6d55bf0455fe9f4f0c4bc79a8b8d0083967	false	1000048494605173030726939161	21585916858830	0x8e11a6d55bf0455fe9f4f0c4bc79a8b8d0083967	32	36922447	2024-11-08T18:26:10.000Z	0x10869a50310534115d8741bc5ba995b97ba4e13aae0deaa35204a6f9bb103570	0
0x23e4e76d01b2002be436ce8d6044b0aa2f68b68a	0xb87ca5329061e9c5f946a5ce3ab455298eeb8343	false	1000048494906758971578094195	1000000000000000	0xb87ca5329061e9c5f946a5ce3ab455298eeb8343	54	36922568	2024-11-08T18:36:50.000Z	0x5301ee4561b603540917e96f6864d7da1d8f490a9fa4308755a79f8bbdb383c2	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xc6b7aca6de8a6044e0e32d0c841a89244a10d284	0xb50201558b00496a145fe76f7424749556e326d8	false	0x	25	0x3e652e97ff339b73421f824f5b03d75b62f1fb51	40901012	Aave Gnosis USDC	2025-07-03T14:48:10.000Z	aGnoUSDC	0x8165dc121d369dc2ceacd5aa2fec3fe1c58d67428b068f570cffbc21dbac12bd	6	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	0xad4f91d26254b6b0c6346b390dda2991fde2f20d
0xc0333cb85b59a788d8c7cae5e1fd6e229a3e5a65	0xb50201558b00496a145fe76f7424749556e326d8	false	0x	49	0x3e652e97ff339b73421f824f5b03d75b62f1fb51	40901012	Aave Gnosis USDCe	2025-07-03T14:48:10.000Z	aGnoUSDCe	0x8165dc121d369dc2ceacd5aa2fec3fe1c58d67428b068f570cffbc21dbac12bd	6	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	0xad4f91d26254b6b0c6346b390dda2991fde2f20d
0xa1fa064a85266e2ca82dee5c5ccec84df445760e	0xb50201558b00496a145fe76f7424749556e326d8	false	0x	19	0x3e652e97ff339b73421f824f5b03d75b62f1fb51	40901012	Aave Gnosis GNO	2025-07-03T14:48:10.000Z	aGnoGNO	0x8165dc121d369dc2ceacd5aa2fec3fe1c58d67428b068f570cffbc21dbac12bd	18	0x9c58bacc331c9aa871afd802db6379a98e80cedb	0xad4f91d26254b6b0c6346b390dda2991fde2f20d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xedbc7449a9b594ca4e053d9737ec5dc4cbccbfb2	false	1041786895053993717848454981	2000000000000000000000	0x000010036c0190e009a000d0fc3541100a07380a	80	40611264	0x6a000f20005980200259b80c5102003040001068	2025-06-16T08:35:05.000Z	0x8fcd305ab204ee9c481022aa0b99b7893a2f6cb8341f7c11eca502d99bcc11dd	0
0xedbc7449a9b594ca4e053d9737ec5dc4cbccbfb2	false	1041818930262606129877179275	50166801642342587	0x008c40fcb094c67e0c9f424ac65220069d6c4854	105	40616600	0x008c40fcb094c67e0c9f424ac65220069d6c4854	2025-06-16T16:10:15.000Z	0xf9f415e95707ca70c08e63e237db0db7444cf508591f3b6cabd7491382c50256	50166801642342587
0xa818f1b57c201e092c4a2017a91815034326efd1	false	1011954001396048641926246709	105574826370340719	0x0477b12dcf072d7a18f270f27f9cd196f7bf0edb	22	40619808	0x0477b12dcf072d7a18f270f27f9cd196f7bf0edb	2025-06-16T20:45:50.000Z	0xc727d469d6b2cc65082c956fd167e735e0163c0528fa4c16222d8a4293b2b996	3647343994239

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xb50201558b00496a145fe76f7424749556e326d8	0x7346d88acd237083adca857bc8307c5b1765d636	false	2854664179	49	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	38318356	81909417471062476520305504	0x7346d88acd237083adca857bc8307c5b1765d636	2025-01-31T06:59:35.000Z	0x3414571712945c871e2602829184b3feaeb5215e2baf14ce9249355a1388d428	2
0xb50201558b00496a145fe76f7424749556e326d8	0xd76a7748292479c2c5ccd88f200954b7df7429c5	false	2000000000	11	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	38325947	81941811260712272046588776	0xd76a7748292479c2c5ccd88f200954b7df7429c5	2025-01-31T17:49:10.000Z	0x4ec598ed52e495bdeae460ef8e374716de11125430c631bfacd3dfb0ffe5e154	2
0xb50201558b00496a145fe76f7424749556e326d8	0x73a7984c3379aeedf004bc21bf2d614a2584b48f	false	100000000000000000	93	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	38324694	19183760964656428524097543	0x73a7984c3379aeedf004bc21bf2d614a2584b48f	2025-01-31T16:01:55.000Z	0x5dbfaafa85efa5368e945ca1de6d96c461743a02f59ebcd842f5b3b6fae434bf	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xb50201558b00496a145fe76f7424749556e326d8	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	2233214840028075700000	0x63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4	115	1116607420014037850	39577689	0xebd594bebf68a71bdcf37e5323c779abffc23457	2025-04-15T20:14:50.000Z	0x86149b2ad04520518d1d38dfc1b3cb154b01ddaf6d33d732c7c5382d227a1050
0xb50201558b00496a145fe76f7424749556e326d8	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	1500753933644564800000	0x63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4	80	750376966822282400	39577168	0x0a8fd42b5e7806567c9a05746dbb9c6ba6a79012	2025-04-15T19:30:20.000Z	0x7ca7af2bbe7ea9d3fa4478af85b790a37dd96054eabdb185b5ee0193215caed2
0xb50201558b00496a145fe76f7424749556e326d8	false	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	1600034918964477400	0x63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4	87	800017459482239	39570160	0xebd594bebf68a71bdcf37e5323c779abffc23457	2025-04-15T09:36:25.000Z	0xbc8a61a1c7c211a421987aae68f536b73718e8d92bad2489bcf5a623d773f314

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xb50201558b00496a145fe76f7424749556e326d8	0x946805df79af35d777400a5188d44de073851d9f	false	17	40139331	0xcb444e90d8198415266c6a2724b7900fb12fc56e	0xa0085d1f87b3407ce9ee562c392784ce0363c648	1011736404995896825863	2025-05-19T09:40:20.000Z	false	0x2d9fc34a0dcdff652875b49d9ac9d838f7873ef5a1d48fa1a6f722c19499d2d7	0xaf204776c7245bf4147c2612bf6e5972ee483701	1007234424437135664266
0xb50201558b00496a145fe76f7424749556e326d8	0xc720083294fc29e7a25abc513821cd59c5ad60fd	false	74	41839315	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	0x693ff6878898ce96d996dc78db9c6829a996ac18	30733327737998	2025-08-28T19:54:25.000Z	false	0xc23247d3d7e4e79ed0d2fd1df6df40145afbe18eebb1637d2feb601985949aea	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	172933894742692400
0xb50201558b00496a145fe76f7424749556e326d8	0xdc7587a982b254ceda4a9cb49e494419f1a48d84	false	23	41839277	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	0x693ff6878898ce96d996dc78db9c6829a996ac18	33971758463215	2025-08-28T19:51:15.000Z	false	0xc8169a8162fc6b4fe774cfe0c57a63ae8e1170a59a3e332492c0143ed454b122	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	191156276742470563

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xb50201558b00496a145fe76f7424749556e326d8	false	25	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	37534178	2024-12-15T06:06:55.000Z	11750979	0xcef2628c1941a45ae735cf8f4ea6bfb7c77892d294de3c518f7184854056983d
0xb50201558b00496a145fe76f7424749556e326d8	false	7	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	37534178	2024-12-15T06:06:55.000Z	2821796805	0xcef2628c1941a45ae735cf8f4ea6bfb7c77892d294de3c518f7184854056983d
0xb50201558b00496a145fe76f7424749556e326d8	false	4	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	37534178	2024-12-15T06:06:55.000Z	5795890518111603	0xcef2628c1941a45ae735cf8f4ea6bfb7c77892d294de3c518f7184854056983d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xb50201558b00496a145fe76f7424749556e326d8	0x0ffad609d35c4bef104ee245a9c4c891d463aa2a	false	10000498466287776435	4	0x0ffad609d35c4bef104ee245a9c4c891d463aa2a	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	32094714	false	2024-01-23T22:24:10.000Z	0xd49e3ea1cbf31b8a670de721ba1767c148dd7fcc0c598571bd91d446e0bfc9be
0xb50201558b00496a145fe76f7424749556e326d8	0x6fce63859a859a0f30ed09b12f5010d790618ca4	false	2364037991625149921	15	0x6fce63859a859a0f30ed09b12f5010d790618ca4	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	32089793	false	2024-01-23T15:07:40.000Z	0xc9fb742dbac2d8689491e71a77f7528a1bd0cbdd1f7f8a2d8c64409e925c0e04
0xb50201558b00496a145fe76f7424749556e326d8	0x6fce63859a859a0f30ed09b12f5010d790618ca4	false	25000000000000000000	9	0x6fce63859a859a0f30ed09b12f5010d790618ca4	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	32086560	false	2024-01-23T10:23:10.000Z	0x7c6454a05cb4ce36064e08ddbd28d2a0a777a367c15167b09bd50d6be6db57a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_variableBorrowRate	in_variableBorrowIndex
0xb50201558b00496a145fe76f7424749556e326d8	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	37883763	2025-01-05T07:02:45.000Z	0	0x835532853a23becaca5c2c26a50b8d6cd29987e572fa018ea12993130c3ccb34	1000012236375861810745798101	0	1000000000000000000000000000
0xb50201558b00496a145fe76f7424749556e326d8	false	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	37883773	2025-01-05T07:03:35.000Z	90409519665779075117	0xfd07a769ec55d879e2fc88227f69a11df6d238abdbca545fdebd334a195cc023	1000052546511048434408110053	121671270055710658380873	1001518179945732771456292464
0xb50201558b00496a145fe76f7424749556e326d8	false	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	37888750	2025-01-05T14:18:10.000Z	13153150898855531949343789	0xe49a6a686fef83c9b451b84adcb6653528c0f3fd7e473c0f69a8367a110838ab	1008208521503421631823967023	21545970742895866492466914	1019654832838893197740541218

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0xb50201558b00496a145fe76f7424749556e326d8	0xf8333277c637691be45031a4365d9442def4bb74	false	121550614455368955	21	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	35874767	0xf8333277c637691be45031a4365d9442def4bb74	2024-09-07T06:52:45.000Z	0x687d8707287fab1059966b300ada976bee18840cb2aeff679ce0949dae442d0f
0xb50201558b00496a145fe76f7424749556e326d8	0x2cfe3d5b6c62d905f2dc961dee9550a88f23963a	false	1000000000000000000	18	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	35870497	0x2cfe3d5b6c62d905f2dc961dee9550a88f23963a	2024-09-07T00:49:20.000Z	0x1f8f9f4bddba8cddd73c704c89f23b38884f3e48f6d1127d49850b5bec8a09e4
0xb50201558b00496a145fe76f7424749556e326d8	0xdecfce6476a66bf8cb1a9f3005ce5496363a99de	false	341502199082991345	16	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	35879815	0xdecfce6476a66bf8cb1a9f3005ce5496363a99de	2024-09-07T14:03:00.000Z	0x4dfaedefc85f7875adc8a0d6c0d2131438d05bdae16e25a5d90b9953ae26947f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x9484fcaa4c39d68798e3c1b7f4a3d9dc2adc69cd	0xb50201558b00496a145fe76f7424749556e326d8	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	false	13776	65	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	38571813	2025-02-15T08:03:50.000Z	0x408a23a087a430a4d6dd62faa7a7bb40f08378fe287e10d2f779b63db1e26d91
0x9484fcaa4c39d68798e3c1b7f4a3d9dc2adc69cd	0xb50201558b00496a145fe76f7424749556e326d8	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	false	202382	40	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	38571695	2025-02-15T07:53:05.000Z	0x278b8fe66f48f4a132e1791f9d907790fe2cb91561b4a988bafea17780bb1d51
0x9484fcaa4c39d68798e3c1b7f4a3d9dc2adc69cd	0xb50201558b00496a145fe76f7424749556e326d8	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	false	1906	34	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	38580377	2025-02-15T20:18:55.000Z	0x56efd0f2c7a365881ab5a236d700919351720403c840b4bc5205f2c431e89163

Example Query

Query with partition filter

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

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

No description available.

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_oldBridgeProtocolFee`	`STRING`	-
`in_newBridgeProtocolFee`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.LendingPoolConfigurator_BridgeProtocolFeeUpdated_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
7700	0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	117	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f	10500	8000
7700	0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	113	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f	10500	8000
7700	0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	109	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f	10500	8000

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumToProtocol	in_oldFlashloanPremiumToProtocol
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	25	30293057	2023-10-04T13:19:25.000Z	0x22cae352fccb5ab3d48d8260c2655910845638763eecebce6b58e4e274f58e93	4	0
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	1	40901012	2025-07-03T14:48:10.000Z	0x8165dc121d369dc2ceacd5aa2fec3fe1c58d67428b068f570cffbc21dbac12bd	10000	4

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumTotal	in_oldFlashloanPremiumTotal
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	24	30293057	2023-10-04T13:19:25.000Z	0x22cae352fccb5ab3d48d8260c2655910845638763eecebce6b58e4e274f58e93	5	0

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

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

Columns

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

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	1000	99	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0x9c58bacc331c9aa871afd802db6379a98e80cedb	1000	107	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	1000	103	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xfc421ad3c883bf9e7c4f42de845c4e4405799e73	13	41454924	2025-08-05T17:18:10.000Z	0xa83f67826954a6aac0ffc1d9b09885bade5c15d61cc49c06c73d9b4042142163	1000
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	85	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f	1000
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	96	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xfc421ad3c883bf9e7c4f42de845c4e4405799e73	0x3fdcec11b4f15c79d483aedc56f37d302837cf4d	6	41454924	2025-08-05T17:18:10.000Z	0xa83f67826954a6aac0ffc1d9b09885bade5c15d61cc49c06c73d9b4042142163	0x0000000000000000000000000000000000000000	0x2766eefe0311bf7421cc30155b03d210bce30df8	0x4ce496f0a390745102540faf041ef92ffd588b44
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	0xc0333cb85b59a788d8c7cae5e1fd6e229a3e5a65	6	35329303	2024-08-05T12:29:00.000Z	0xab2f76503ae7540da067be3485f17ec63a6c94648e7d2f887b0f1ed4d02dece7	0x135a7ba96fbe20949cf2d8e46c7f5ca3bb1ee222	0x37b9ad6b5dc8ad977ad716e92f49e9d200e58431	0x98619395148c348e9a09c7d34290b1e9e7715a3e
0x7304979ec9e4eaa0273b6a037a31c4e9e5a75d16	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	0xd0dd6cef72143e22cced4867eb0d5f2328715533	35	30834029	2023-11-07T09:08:10.000Z	0xd8b3d8a9ee914d10bc4923cb698419c2cdae7b4551c8b8d39efb7ed86827fd6f	0xac8b1ce0548c69318920c3e0b21db296d5770d57	0x281963d7471ecdc3a2bd4503e24e89691cfe420d	0x345f7fcd88207fe060ad03c2656a23a3ab596479

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.LendingPoolConfigurator_ReserveInitialized_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
0x57f664882f762fa37903fc864e2b633d384b411a	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	694999886441736852	0xba1333333333a1ba1108e8412f11850a5c319ba9	689734991120911451	11	37549246	2024-12-16T03:43:20.000Z	0x1171565a651457d0fea629c3101c9bb80fdc3dc09787f1de8c379f7631f768de
0x773cda0cade2a3d86e6d4e30699d40bb95174ff2	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	2999999999999985540	0xba1333333333a1ba1108e8412f11850a5c319ba9	2999848434957262245	23	37559963	2024-12-16T19:05:35.000Z	0x70ed6b2c2fa0b67e0692e4ad9f62e1db2dcbd058a5f1bebbcfa6eb858c12c705
0x773cda0cade2a3d86e6d4e30699d40bb95174ff2	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	3540629678234148533	0xba1333333333a1ba1108e8412f11850a5c319ba9	3540450799673380031	40	37559921	2024-12-16T19:02:00.000Z	0x708db9d25eaeccab7db8fa2c178e38c7e5f918b6738d8df0a042b7f646cb3de7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x417bc5b940475203a18c2f320a5ba470d6c5e463	false	30	1	39000679	2025-03-12T18:39:20.000Z	0xcb33d2d0f8de8368667cd3ddd9cf71e89573a7537a2b76b5062f3caaa188e563
0x58d9acac48a4077e4909181c48decd00e5ba5de4	false	87	1	41471438	2025-08-06T17:26:45.000Z	0xfad09520731d5d7c069c7f4f1ba81dde943f6df257fd7bc4f099b445096b8fed
0x57f664882f762fa37903fc864e2b633d384b411a	false	26	1	37238388	2024-11-27T15:50:45.000Z	0xae9250d2447017f0e29048cce6cd8a5c95f37816f7cba6d9684160a638b3ebab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x7c16f0185a26db0ae7a9377f23bc18ea7ce5d644	false	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	605575547698441216	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	603543766153631599	8	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	42613739	2025-10-14T03:29:35.000Z	0xa45d88932f8f71b84cd12c742535eba424a07e365c84ef678a2f78da343af09d
0x51350d88c1bd32cc6a79368c9fb70373fb71f375	false	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	107336885	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	103932167	10	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	42624924	2025-10-14T19:20:30.000Z	0x826540564935fa5e88ccc9561d66985ee2324cb6e7302da3cdde044834822849
0x7c16f0185a26db0ae7a9377f23bc18ea7ce5d644	false	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	1145552552302670848	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	1141709204174227271	10	0x2b7ccf33316f30970b77d20f3dcb45c367b5ba39	42613485	2025-10-14T03:07:55.000Z	0x319f1f21182297ef9e75661d91c5ed10e6673c001a70fecaf1626eb26a3c98d5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x33992721c565da3248bd3af80524e054f5f05b42	false	33	39000679	0x417bc5b940475203a18c2f320a5ba470d6c5e463	0xcb444e90d8198415266c6a2724b7900fb12fc56e	2025-03-12T18:39:20.000Z	0xcb33d2d0f8de8368667cd3ddd9cf71e89573a7537a2b76b5062f3caaa188e563
0x33992721c565da3248bd3af80524e054f5f05b42	false	90	41471438	0x58d9acac48a4077e4909181c48decd00e5ba5de4	0xfc421ad3c883bf9e7c4f42de845c4e4405799e73	2025-08-06T17:26:45.000Z	0xfad09520731d5d7c069c7f4f1ba81dde943f6df257fd7bc4f099b445096b8fed
0x33992721c565da3248bd3af80524e054f5f05b42	false	17	37238388	0x51350d88c1bd32cc6a79368c9fb70373fb71f375	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	2024-11-27T15:50:45.000Z	0xae9250d2447017f0e29048cce6cd8a5c95f37816f7cba6d9684160a638b3ebab

Example Query

Query with partition filter

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

SToken_Burn_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SToken_Mint_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x281963d7471ecdc3a2bd4503e24e89691cfe420d	0xf10581d6ba3d531bc3ce9b24af359089fe7616f1	false	1126491030102118915025727353	14059363381495384457	0x0000000000000000000000000000000000000000	5	40512699	2025-06-10T13:24:10.000Z	0xada09aa8a1bae1b2b0692e9c300d7d178b275ebb88a7d289558eb07cc58fc963	3882877373764112
0x281963d7471ecdc3a2bd4503e24e89691cfe420d	0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d4581	false	1126531976995998697207872100	35998263412393396923257	0x0000000000000000000000000000000000000000	1	40518255	2025-06-10T21:16:00.000Z	0x9d96f00773927e29f5a56ccae542c32012b9408ea7ec5d80f9bda564edc463b1	1736587606603076743
0x281963d7471ecdc3a2bd4503e24e89691cfe420d	0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d4581	false	1126482459446912487042160328	119999822297025760725943	0x0000000000000000000000000000000000000000	1	40511547	2025-06-10T11:45:35.000Z	0x6a2259e040310f7318987794d61816e997be90d0ed99c10f4db13b3488a2471b	177702974239274057

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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
0x281963d7471ecdc3a2bd4503e24e89691cfe420d	false	1129484493583789458316434778	123314223213281849433	0x721b9abab6511b46b9ee83a1aba23bdacb004149	31	40896520	0xc102c17a3b97661b0592239ce9046cbed652ddab	2025-07-03T08:25:00.000Z	0xc5a0cdc5fde30b9df73a425ceffcc49d23da38fd8ad14de096d329a5c39105d7	3314223213281849433
0x281963d7471ecdc3a2bd4503e24e89691cfe420d	false	1129519311825334868792967962	57000723369440036411259	0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d4581	1	40900202	0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d4581	2025-07-03T13:38:50.000Z	0x88cc87347ae67b4804c97fd77cf4c4be53d4f437670ca1a98dc3de45e77e9712	723369440036411259
0x281963d7471ecdc3a2bd4503e24e89691cfe420d	false	1129512665384215215769958771	30000181307879776391735	0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d4581	1	40899508	0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d4581	2025-07-03T12:39:40.000Z	0x3dd89ee5b843f63102acf8519f336eba00e17de67afdeea1c7fffb05644178d1	181307879776391735

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_gnosis.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`	`NUMERIC`	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
421431	0x15e696e03cf87f23a2b864948eab5595797aca6a	true	234216	0xb50201558b00496a145fe76f7424749556e326d8	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x721b9abab6511b46b9ee83a1aba23bdacb004149	42789625	0x15e696e03cf87f23a2b864948eab5595797aca6a	2025-10-24T13:15:20.000Z	0xd913b3859916d50edb9762deaacddcbd9828ee559f089fe92db941258b536b6c
362044	0xe6386827c99639ccbc253f70609fbb2b999b5895	true	231561	0xb50201558b00496a145fe76f7424749556e326d8	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0x721b9abab6511b46b9ee83a1aba23bdacb004149	42789891	0xe6386827c99639ccbc253f70609fbb2b999b5895	2025-10-24T13:38:00.000Z	0x5aeb99b69742b4b83306abf73a739a0e01d41b94197d0051197225e3f2a5fc3e
369223		false	192386			0x80500d20	0x721b9abab6511b46b9ee83a1aba23bdacb004149	40502768	0xbf4ebea7279de8517f60bd5fdbe9aebe03de90ed	2025-06-09T23:14:55.000Z	0xdc7c1d0b4301c73ff82f10ec314af1621d64b827c237e9f8103bec074ad6bc70

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

​LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​StataToken_Deposit_event

​StataToken_Initialized_event

​StataToken_Withdraw_event

​StataTokenFactory_StataTokenCreated_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV3_withdrawETH_function

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_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