aave_v2_polygon

Tables

AToken_Burn_event

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

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash
0x1a13f4ca1d028320a707d99520abfefca3998b7f	0x001b024b98ee862aa01eea595c4c16a0213d2611	false	1026459135172010294438084152	28174020	0x001b024b98ee862aa01eea595c4c16a0213d2611	294	23336244	2022-01-04T11:08:20.000Z	0x047f8bfd6339e52d99d0bd55de069059af036e9aae43f5206461c2a2f926cb7b
0x1a13f4ca1d028320a707d99520abfefca3998b7f	0x024713784f675dd28b5ce07db91a4d47213c2394	false	1026495285106751522595450941	656830950	0x024713784f675dd28b5ce07db91a4d47213c2394	246	23350387	2022-01-04T21:28:10.000Z	0xdf5b8d2411eeb67be0f7a3c20d5bea65dae7de995d44604267f89e31e31f41b8
0x1a13f4ca1d028320a707d99520abfefca3998b7f	0x02f21b7c148d5fc587a285d2f538f29c36176e52	false	1026433571045714852601141631	1000000000	0x02f21b7c148d5fc587a285d2f538f29c36176e52	365	23324726	2022-01-04T03:47:57.000Z	0xb3e58980dc00568bf4bdbe75d6e2738a75d35f9866a022d714e6bfdd476babb8

Example Query

Query with partition filter

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

AToken_Mint_event

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

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0x1d2a0e5ec8e5bbdca5cb219e649b565d8e5c3360	0xdef171fe48cf0115b1d80b88dc8eab59176fee57	false	1000265954410927379177692702	20777412377420712	276	29188716	2022-06-05T08:24:18.000Z	0x21777700f964d3ad045eed0f09db748df26984b984090f501ec6be5d42115d69
0x1d2a0e5ec8e5bbdca5cb219e649b565d8e5c3360	0x521709b3cd7f07e29722be0ba28a8ce0e806dbc3	false	1000265954410927379177692702	48952750860330177	165	29187655	2022-06-05T07:47:47.000Z	0x16820fef44700b41ec6886cb10fe704d52d3344a7e858f079aac69df59a4025d
0x1d2a0e5ec8e5bbdca5cb219e649b565d8e5c3360	0x125d2e4a83bbba4e6f51a244c494f9a1958d20bb	false	1000265954410927379177692702	3000000000000000000	158	29196496	2022-06-05T12:58:12.000Z	0x017ba4c560da8a64d6bcc2d66b4a5b1597eb03210d5a14be38e70099dcf8c0bd

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_event

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

Columns

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

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_claimer	block_number	block_timestamp	transaction_hash
0x0f8361ef329b43fa48ac66a7cd8f619c517274f1	0x357d51124f59836ded84c8a1730d72b749d8bc23	0x0f8361ef329b43fa48ac66a7cd8f619c517274f1	false	3144247256897732449	306	0x0f8361ef329b43fa48ac66a7cd8f619c517274f1	76641342	2025-09-19T12:48:54.000Z	0x66c642bf14e3ef44aeb1b0dde1c87320208535334d6455a2f75c7912f38971b5
0x5559472b0f983fab295a9c6a2ffd3bcb2fc70238	0x357d51124f59836ded84c8a1730d72b749d8bc23	0x5559472b0f983fab295a9c6a2ffd3bcb2fc70238	false	3160420645874434277	887	0x5559472b0f983fab295a9c6a2ffd3bcb2fc70238	76627973	2025-09-19T04:54:54.000Z	0x6f26e9550d6599c5478405da0a821b60e3d47366ae34eeb1371c721b34cd8bfd
0x6e832478aa89fb4507862b2955a3ef3a9fbaf3ec	0x357d51124f59836ded84c8a1730d72b749d8bc23	0x6e832478aa89fb4507862b2955a3ef3a9fbaf3ec	false	13954049945236215	177	0x6e832478aa89fb4507862b2955a3ef3a9fbaf3ec	76649533	2025-09-19T17:39:00.000Z	0x6ac10f28eec1e052a8aa337db8505931dc72fe006dc5a233b20bc917e017c154

Example Query

Query with partition filter

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

LendingPool_Borrow_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_borrowRateMode
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x340f412860da7b7823df372a2b59ff78b7ae6abc	false	107157142420645918470	109	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	32618108	145508783866623435366134494	0x340f412860da7b7823df372a2b59ff78b7ae6abc	2022-09-03T00:45:34.000Z	0xb126d48439677072e38a6d9326ebc0fbaa89fcaba13478dffe79d6e68d1959e7	2
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x340f412860da7b7823df372a2b59ff78b7ae6abc	false	105855875925285000032	266	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	32655868	67978450205940002437152749	0x340f412860da7b7823df372a2b59ff78b7ae6abc	2022-09-03T22:37:19.000Z	0xea0af7b6d965745460bfa84e049917688f193ba784291cbac889a612d25185e6	2
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x340f412860da7b7823df372a2b59ff78b7ae6abc	false	106404944732432004259	463	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	32644421	69576972440006503709428433	0x340f412860da7b7823df372a2b59ff78b7ae6abc	2022-09-03T16:03:40.000Z	0x6fc58a234cd3a3ced5eed85f1a5b875fca2a81f0f00f786924559e3a5e674897	2

Example Query

Query with partition filter

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

LendingPool_Deposit_event

Deposit events from lending pool contracts recording user supply transactions. Contains depositor address, reserve asset, deposit amount, beneficiary account, and optional referral code for tracking protocol liquidity provisioning.

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x23159e5aa03fdf5c000c99076f5bfc5c49108bcb	false	1782823491098052099294	160	0x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a	26813458	0x23159e5aa03fdf5c000c99076f5bfc5c49108bcb	2022-04-06T12:37:35.000Z	0xaf48e52614d29a7ef25fb70892f72c46548542be410c265be6dc6c3e2a059d9e
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x35e191b9c024155a1de170b493b81eb2ffa2394a	false	5093359557684945104	589	0x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a	26800238	0x35e191b9c024155a1de170b493b81eb2ffa2394a	2022-04-06T04:40:38.000Z	0xe7b297f861d8cdcf73c944e615d9b576014df0da77c5994f1d958ccd8835fa4f
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x3b84dc2d75827c740d70b030a6372c0eb79472e1	false	12696044609892478183	215	0x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a	26810227	0x3b84dc2d75827c740d70b030a6372c0eb79472e1	2022-04-06T10:38:36.000Z	0x6221335879c2eeed5d59e279810feec04a4c4512ddc5101a158da6bd97b52f80

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

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

Columns

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

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	5800000000000000000	0x35784a624d4ffbc3594f4d16fa3801fef063241c	189	5220000000000000	31770258	0x105b512f095dd2bd22bd95b52c634beac2707a56	2022-08-11T13:40:52.000Z	0xd14cdb8228bb435a385f9c431417fb6ea9095024e8cc3ec218c0aa26aecf380f
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	10000000000000000000	0x35784a624d4ffbc3594f4d16fa3801fef063241c	182	9000000000000000	31772735	0x105b512f095dd2bd22bd95b52c634beac2707a56	2022-08-11T15:14:31.000Z	0xe2c225996053ed0ec3d64d15889afa0e223b7756d80c3cfb043e17afb719cc1b
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	65938989417989426231	0x170dff1826595155d2cf50e6df3b3649caf74435	472	59345090476190483	31777340	0x170dff1826595155d2cf50e6df3b3649caf74435	2022-08-11T18:14:38.000Z	0x161de43c14b211330f7c48ac959ddb11cd80f9a3f63d6d8adc062a72e4accf54

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_polygon.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
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0xde3e62d485320b28862d2fbf7bf3d27dd73f09a0	false	17	56539294	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x1b209ec617eceea8467563cccbea71ce9ed44fb2	102690433	2024-05-03T18:33:07.000Z	false	0xffb733b75f37d8b538b4e5211b28c8c6d40cd1933b3b9b6fdff114b93bac1ab0	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	107824954
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x0cd9a37793b4b52bbed71102ff94adb41f593e60	false	158	56518975	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x7b15a342ca8dc73c4b6fb97cad00b67a35c3e5ed	15108764	2024-05-03T04:49:56.000Z	false	0x286849d9f1568d22a5e4a90bd140c1c0114000ad265e006ab2c30e36bc1deb4e	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	15864202
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0xe40a2466802f9a9117ce64fa8367b0e333c84c5d	false	4105	56545616	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x7b15a342ca8dc73c4b6fb97cad00b67a35c3e5ed	119235769	2024-05-03T22:42:03.000Z	false	0x7a591bd90329bd9f2f46964b069267d5ae1f91a22d5494c6cf6ebdc7fa715f64	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	125197557

Example Query

Query with partition filter

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

LendingPool_Repay_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	block_timestamp	transaction_hash
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x6c095a8345c90cf9de34c26f235e672243b8ef0a	false	527127963289188375	310	0x3db487975ab1728db5787b798866c2021b24ec52	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	75824422	2025-08-30T03:12:03.000Z	0x0451c5014edf9f58feb4f2617cd8c5919ad00378fdbc61edaf0db6bdc12c7c74
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0xa5dcc5dc7020bbe8bc85ba8f30d044c7c9419913	false	423993924396942198	313	0xf1e6d4347105138b51e2baca9a22fa228309ebb1	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	75825212	2025-08-30T03:40:33.000Z	0x9a542a559580ff62056d331037b4dfd7454a2b603917ab6dca6232740d78c9d7
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x725d73881e36db47d63dbf48d44d3c709089cc9c	false	401075493133752548	156	0xf1e6d4347105138b51e2baca9a22fa228309ebb1	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	75825083	2025-08-30T03:35:59.000Z	0xfd2929210cc7765cdd4af0fbf4dcad9f27c70fbf5350d75ea58ce52b5fa723d3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_polygon.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
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	false	296	0x9a71012b13ca4d3d0cdc72a177df3ef03b0e76a3	30731996	2022-07-15T00:00:03.000Z	356385494489156515787705522	0xa80bf33bde9b9c46375514f47b7433dd7046609fae7bf1fd8ad83858a36f1fda	1022963155048196372326823916	800229592468080224536014994	770229592468080224536014994	1056149300394664858277158688
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	false	18	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	30731998	2022-07-15T00:00:07.000Z	36902276124469000774942	0xc6c13c29d64407484f15c6fd1e0463632ffe599ad3d8c48ca4bf7431c0878d8d	1003964801025155836006232712	32978378661788550316007005	2382702929430840252805605	1014859143489383984767150403
0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	false	14	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	30732002	2022-07-15T00:00:15.000Z	36925039941698031919477	0x56564c09113796eee46960624850887970fdc8cc73804dae88aeda426f3e27d0	1003964801034554259726851149	32979297152760469800025791	2383437722208375840020632	1014859144102805561325059901

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

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

Columns

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

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x1380f2f57553ada04b31ee7b1e039e496939db3d	0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x1380f2f57553ada04b31ee7b1e039e496939db3d	false	10053379309441786982	466	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	77541471	2025-10-11T12:59:38.000Z	0x705fbd202ec0a8e1e1a5eb761bd74e9c34ee015f8e7715f73748f7431574b5a2
0xf1e6d4347105138b51e2baca9a22fa228309ebb1	0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0xf1e6d4347105138b51e2baca9a22fa228309ebb1	false	31691360312720117536	363	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	77525275	2025-10-11T03:59:34.000Z	0xfa0cf4844acc84bb06236c09b6365888b596f4ba513071c00e7513f3d258b10f
0x1380f2f57553ada04b31ee7b1e039e496939db3d	0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	0x1380f2f57553ada04b31ee7b1e039e496939db3d	false	3560000	625	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	77519405	2025-10-11T00:43:54.000Z	0xd57fe68df510b6796147b7f9d5df2a8f879a6c7961a90e374b549178b54fdfac

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

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

Columns

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

Sample Data

address	removed	in_asset	in_factor	log_index	block_number	block_timestamp	transaction_hash
0x26db2b833021583566323e3b8985999981b9f1f3	false	0xd6df932a45c0f255f85145f286ea0b292b21c90b	0	58	12687363	2021-03-31T09:03:17.000Z	0x3afba04470ac88647da9b871517b2671d95c36d518a9c969496da197ad8b6697
0x26db2b833021583566323e3b8985999981b9f1f3	false	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	1000	52	12687363	2021-03-31T09:03:17.000Z	0x3afba04470ac88647da9b871517b2671d95c36d518a9c969496da197ad8b6697
0x26db2b833021583566323e3b8985999981b9f1f3	false	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	1000	43	12687363	2021-03-31T09:03:17.000Z	0x3afba04470ac88647da9b871517b2671d95c36d518a9c969496da197ad8b6697

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_polygon.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
0x26db2b833021583566323e3b8985999981b9f1f3	false	0xd6df932a45c0f255f85145f286ea0b292b21c90b	0x1d2a0e5ec8e5bbdca5cb219e649b565d8e5c3360	25	12687350	2021-03-31T09:02:35.000Z	0x1509cfb06a8c54aa6012f62ee1c33b428d8b1361269e1119b6626eccb9e4dc8d	0x17912140e780b29ba01381f088f21e8d75f954f9	0x1c313e9d0d826662f5ce692134d938656f681350	0xae9b3eb616ed753dce96c75b6ae30a60ff9290b4
0x26db2b833021583566323e3b8985999981b9f1f3	false	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	0x28424507fefb6f7f8e9d3860f56504e4e5f5f390	17	12687350	2021-03-31T09:02:35.000Z	0x1509cfb06a8c54aa6012f62ee1c33b428d8b1361269e1119b6626eccb9e4dc8d	0xc478cbbeb590c76b01ce658f8c4dda04f30e2c6f	0xede17e9d79fc6f9ff9250d9eefbdb88cc18038b5	0xcdac94de1cf4e8e25b6c61df6481c344c5e88f44
0x26db2b833021583566323e3b8985999981b9f1f3	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x8df3aad3a84da6b69a4da8aec3ea40d9091b2ac4	21	12687350	2021-03-31T09:02:35.000Z	0x1509cfb06a8c54aa6012f62ee1c33b428d8b1361269e1119b6626eccb9e4dc8d	0xb9a6e29fb540c5f1243ef643eb39b0acbc2e68e3	0x59e8e9100cbfcbcbadf86b9279fa61526bbb8765	0x553b64567de5392f6b189f6ac89581342dad12f9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_polygon.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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v2_polygon.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_v2_polygon.SToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VToken_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_user	removed	in_index	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xede17e9d79fc6f9ff9250d9eefbdb88cc18038b5	0x55a10618c7e9489cee047705cd003df6d9e09195	false	1003323076525584971247959691	18622584378638821782	167	14305268	2021-05-10T01:19:10.000Z	0x38b55ae3c65a8d87598efb9970d311209f01f805a8fe9a516a5aeb813c2f92e1
0xede17e9d79fc6f9ff9250d9eefbdb88cc18038b5	0x55a10618c7e9489cee047705cd003df6d9e09195	false	1003323076525584971247959691	3017457929779303	189	14305268	2021-05-10T01:19:10.000Z	0x38b55ae3c65a8d87598efb9970d311209f01f805a8fe9a516a5aeb813c2f92e1
0xede17e9d79fc6f9ff9250d9eefbdb88cc18038b5	0x55a10618c7e9489cee047705cd003df6d9e09195	false	1003323076525584971247959691	23875108177742079206	178	14305268	2021-05-10T01:19:10.000Z	0x38b55ae3c65a8d87598efb9970d311209f01f805a8fe9a516a5aeb813c2f92e1

Example Query

Query with partition filter

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

VToken_Mint_event

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

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x248960a9d75edfa3de94f7193eae3161eb349a12	0x0fa6ec362723f6ddd854a8245922d5c858d27ff8	false	1049472470717279170787336837	250125000	171	29831277	0x0fa6ec362723f6ddd854a8245922d5c858d27ff8	2022-06-21T14:24:04.000Z	0xfcc8a4aad18e3ead8b40bcba3ecbad6c29bebda2c54cef97bf0795d0330cc855
0x248960a9d75edfa3de94f7193eae3161eb349a12	0x12bb764971412d115446fe66acb6fbed9b4e7e01	false	1049444251905781515835457743	1952870000	11	29808111	0x12bb764971412d115446fe66acb6fbed9b4e7e01	2022-06-21T00:01:18.000Z	0xc78fa18be8522852048c715e5c2812442b55f913dd8b4d49ee700a55b126610e
0x248960a9d75edfa3de94f7193eae3161eb349a12	0x12bb764971412d115446fe66acb6fbed9b4e7e01	false	1049444212645213936395662792	4592210000	111	29808099	0x12bb764971412d115446fe66acb6fbed9b4e7e01	2022-06-21T00:00:06.000Z	0x7cdd06e692edb865fa180e473c03b7448f1a566846a63a34f9b2cfe0e3e8719a

Example Query

Query with partition filter

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

WrappedTokenGatewayV2_withdrawETH_function

Withdrawal transactions from Aave V2’s Wrapped Token Gateway on Polygon, converting wrapped ETH (WETH) positions back to native ETH. Used for tracking user exit flows and unwrapping activity in Aave’s lending protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	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
669283	0x7982398688c1a0df28f1649d8d21d74cd5a37bd2	true	346810	0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xf1e6d4347105138b51e2baca9a22fa228309ebb1	71367680	0x7982398688c1a0df28f1649d8d21d74cd5a37bd2	2025-05-11T02:24:31.000Z	0x28c6ce1d64dff11a7b502d2a0100ca63273e2be14a633e0eb482845bc471d759
672256	0x86aabcd459587bc1a347ae1e2d15223856354ec9	true	346810	0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xf1e6d4347105138b51e2baca9a22fa228309ebb1	71373251	0x86aabcd459587bc1a347ae1e2d15223856354ec9	2025-05-11T05:41:57.000Z	0x7855b9a3745d6116a1ee76169f3a98c01f9187de9d63d3ac57e9b59cb7f4dde7
876364	0x3c152093717fe0ca27fdf3457acfa569f38b11df	true	481036	0x8dff5e27ea6b7ac08ebfdf9eb090f32ee9a30fcf	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x80500d20	0xf1e6d4347105138b51e2baca9a22fa228309ebb1	56839768	0x3c152093717fe0ca27fdf3457acfa569f38b11df	2024-05-11T11:20:12.000Z	0xf8676afd7660a5328bbfb4c3ae60bd2df553463779ab472a1c6912ee35140c24

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_Burn_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV2_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_Burn_event

​AToken_Mint_event

​IncentivesController_RewardsClaimed_event

​LendingPool_Borrow_event

​LendingPool_Deposit_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV2_withdrawETH_function

Tables

AToken_Burn_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV2_withdrawETH_function