Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
in_toaddressin_fromremovedin_indexin_valuelog_indexblock_numberblock_timestamptransaction_hash
0x8b81420441ac3933c58d1190c8499c2f89eb12630x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fe0x9d46270b0382f5a93b596e37d3584b5e3e4c7c2dfalse10001306139877050578818450983329565112223368867171674237222025-02-01T21:53:38.000Z0x5fb07134d77a1f1c859563eba0ab1abba04547b3f0d71e0734cc2ad85419f8ff
0x3f48cb78d2e254ed12ef6c24b7b94e4cc87b24c20xea1132120ddcdda2f119e99fa7a27a0d036f7ac90x111111125421ca6dc452d289314280a0f8842a65false1000144182669129402468064493206184410815618271557308674065352025-02-01T11:40:06.000Z0x6b1b5e03b9b4f4ec9b39518efb25b2b8ef2a6febdc555d1fc61a56ce14f3d699
0x00c600b30fb0400701010f4b080409018b9006e00xf329e36c7bf6e5e86ce2150875a84ce77f4773750x8c9cd965b7561b86f7069fd8ce9728383846055afalse10010622504063374357841475415114567049073881210190674037662025-02-01T10:00:18.000Z0x2bb45fa27d323b48090ce8c3f9549d64a90ff0214aa77d26622474424c6eea3d
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fe0x67709ce1908077801567998a23ab3ce10c45727dfalse1000158720375732063517640869259398212484846981310xcccb791f248740927389a355745c6f9c7ec009b2400728355472025-06-16T10:30:13.000Z0xcf7c140013c3a49f06be6911ae0d1084f3cde642682f47c4d904cc2684e694050
0x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fe0x67709ce1908077801567998a23ab3ce10c45727dfalse1000158720574744474148619085129699106269091375060xcccb791f248740927389a355745c6f9c7ec009b2252728356882025-06-16T10:35:13.000Z0xe99e77cf1bd3901dc237b7424282a0ac0e4c6d033cea52b8d321005111f6bae50
0x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fe0xf8d601931fb2d67786f3e3fa954c3ec22c9d98abfalse100015873172873828349670465030595530450xf8d601931fb2d67786f3e3fa954c3ec22c9d98ab156728435222025-06-16T15:15:27.000Z0x01353c10fd5f129f33f122cfb9253b7120aaaceedb2b261e96814f0a05e4989d1414
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_underlyingAssetSTRINGContract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_treasurySTRINGContract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
in_incentivesControllerSTRINGContract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenDecimalsINT64Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
in_aTokenNameSTRINGHuman-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_aTokenSymbolSTRINGTrading 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_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
addressin_poolremovedin_paramslog_indexin_treasuryblock_numberin_aTokenNameblock_timestampin_aTokenSymboltransaction_hashin_aTokenDecimalsin_underlyingAssetin_incentivesController
0xa4d94019934d8333ef880abffbf2fdd611c762bd0x794a61358d6845594f94dc1db02a252b5b4814adfalse0x2140xe8599f3cc5d38a9ad6f3684cd5cea72f10dbc38351373556Aave Polygon USDCn2023-12-21T04:47:39.000ZaPolUSDCn0x4a68392fa153577d9c6a0580979c426bb708448d2c7d1f92b847e6b294cbdef260x3c499c542cef5e3811e1192ce70d8cc03d5c33590x929ec64c34a17401f460460d4b9390518e5b473e
0x38d693ce1df5aadf7bc62595a37d667ad57922e50x794a61358d6845594f94dc1db02a252b5b4814adfalse0x307831305150xe8599f3cc5d38a9ad6f3684cd5cea72f10dbc38342535602Aave Polygon EURS2023-05-10T13:37:22.000ZaPolEURS0x0967c39ab7306cf2fe43bce0ad6e918ba7aeeee94609b8e76d2401d5df61a99420xe111178a87a3bff0c8d18decba5798827539ae990x929ec64c34a17401f460460d4b9390518e5b473e
0x6ab707aca953edaefbc4fd23ba732942414906200x794a61358d6845594f94dc1db02a252b5b4814adfalse0x307831304350xe8599f3cc5d38a9ad6f3684cd5cea72f10dbc38342535602Aave Polygon USDT2023-05-10T13:37:22.000ZaPolUSDT0x0967c39ab7306cf2fe43bce0ad6e918ba7aeeee94609b8e76d2401d5df61a99460xc2132d05d31c914a87c6611c10748aeb04b58e8f0x929ec64c34a17401f460460d4b9390518e5b473e
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fefalse100015888149358852398770315010014744888355034176840x3b1390c6dc52bab80bed8da13d7b968616181d81392729497370x3b1390c6dc52bab80bed8da13d7b968616181d812025-06-19T06:12:17.000Z0xefb6164421746781b4300ab2ece75c64c24d870a258a2925872bad5b343960ab71056058009691867
0x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fefalse100015888639586052934613165381932319655984125050870x4782e37ebcf6c50f69a6ec71a3411b1698a9bf1c419729532130x4782e37ebcf6c50f69a6ec71a3411b1698a9bf1c2025-06-19T08:15:53.000Z0x11bd296e6218fa620be23136a06f4629b50685364c55427620e61465d354c4f90
0x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fefalse10001589024877421020835435122814888849622909832720x9bee2025767bcff5b169bc4017eca9a04c3f9ed1449729646630x9bee2025767bcff5b169bc4017eca9a04c3f9ed12025-06-19T15:01:46.000Z0xc0338ccec87ec05ea4713e2b77ab6f3bbd58672bc64a270fde06501b1644bfee99622225310705941
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest 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_borrowRateSTRINGAnnual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_borrowRatein_onBehalfOfblock_timestampin_referralCodetransaction_hashin_interestRateMode
0x794a61358d6845594f94dc1db02a252b5b4814ad0x50a5ba5ec2a49c9ad9055379ab378fe3b46d7fecfalse70000000000000000002260x03b54a6e9a984069379fae1a4fc4dbae93b3bccd5951661232021893527980402253737870x50a5ba5ec2a49c9ad9055379ab378fe3b46d7fec2024-07-18T16:31:47.000Z00x6d59faf749e1e12ec26765d1c83a03d4eec74774029ae306e3de8239961a84c72
0x794a61358d6845594f94dc1db02a252b5b4814ad0x50a5ba5ec2a49c9ad9055379ab378fe3b46d7fecfalse65000000000000000004600x03b54a6e9a984069379fae1a4fc4dbae93b3bccd5951802033094000326420149516831870x50a5ba5ec2a49c9ad9055379ab378fe3b46d7fec2024-07-18T17:21:53.000Z00xe4458582fdf5ae7cd6ed641a815f19be0057b41730d716ce4481471d253b9dbe2
0x794a61358d6845594f94dc1db02a252b5b4814ad0x50a5ba5ec2a49c9ad9055379ab378fe3b46d7fecfalse65000000000000000002310x03b54a6e9a984069379fae1a4fc4dbae93b3bccd5951825334166105412357766483045380x50a5ba5ec2a49c9ad9055379ab378fe3b46d7fec2024-07-18T17:30:07.000Z00x255746cfc70b2c7211d02212176bad8164088d0a23d94ab97ac10780e4a93abc2
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest 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_premiumSTRINGFee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressremovedin_assetin_amountin_targetlog_indexin_premiumblock_numberin_initiatorblock_timestampin_referralCodetransaction_hashin_interestRateMode
0x794a61358d6845594f94dc1db02a252b5b4814adfalse0xe111178a87a3bff0c8d18decba5798827539ae99925090xb58fd91558fa213d97ac94c97f831c72892780845020519403240xb58fd91558fa213d97ac94c97f831c72892780842024-01-04T19:24:15.000Z59360x31ce226b7fbfd8c112ee882333104eab799bfeba3a6ff8c30b8accf4aee915de2
0x794a61358d6845594f94dc1db02a252b5b4814adfalse0xe111178a87a3bff0c8d18decba5798827539ae99137830xb58fd91558fa213d97ac94c97f831c72892780846480519123670xb58fd91558fa213d97ac94c97f831c72892780842024-01-04T01:53:40.000Z59360x594452eb7844fffc7f3d5ec406bff023f64b59f488d2ca1d52bd5bdfb7f35fab2
0x794a61358d6845594f94dc1db02a252b5b4814adfalse0xe111178a87a3bff0c8d18decba5798827539ae991074570xb58fd91558fa213d97ac94c97f831c72892780844960519203200xb58fd91558fa213d97ac94c97f831c72892780842024-01-04T06:55:36.000Z59360x0526a2f251ea2609fff5050a81c41bc25b5b5fc8e4066719ad9d8ecdbe37bbc92
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_collateralAssetSTRINGContract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtAssetSTRINGContract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtToCoverSTRINGAmount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
in_liquidatedCollateralAmountSTRINGAmount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
in_liquidatorSTRINGAddress of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiveATokenBOOLBoolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.
addressin_userremovedlog_indexblock_numberin_debtAssetin_liquidatorin_debtToCoverblock_timestampin_receiveATokentransaction_hashin_collateralAssetin_liquidatedCollateralAmount
0x794a61358d6845594f94dc1db02a252b5b4814ad0x69ea6f5edd0f404f72f7a083962ded64e08a90edfalse335410887940x0d500b1d8e8ef31e21c99d1db9a6444d3adf12700x53d87a4027fc0b13dc8f5e89411c2f15e6147af747589514785009425596202023-04-03T08:33:33.000Zfalse0x392e5fb9fc946acad8ea0bae10b5fc18b8693e75501b708685df8e31f9425cf40x2791bca1f2de4661ed88a30c99a7a9449aa841745490422691
0x794a61358d6845594f94dc1db02a252b5b4814ad0x7347f924ebaa4541141e706f5ab64c5b9bd4db24false211410778120x2791bca1f2de4661ed88a30c99a7a9449aa841740x9999b50bb6fc4ac42ddc5f10518e406549ebc3a02507498342023-04-03T01:44:25.000Zfalse0x727f516653f8f2cfce908d52f11a0db73ea0af39ad3140da3d8645a87b8087a60x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270253993820994130896208
0x794a61358d6845594f94dc1db02a252b5b4814ad0x57e76a5ca6886f024ac761abde533076e30a6b12false141410777980x8f3cf7ad23cd3cadbd9735aff958023239c6a0630x9999b50bb6fc4ac42ddc5f10518e406549ebc3a01508350777794634617622023-04-03T01:43:55.000Zfalse0xb618a55d0cce2dc2eb8e7194b26f1b354793371232e42843851d97c9d080591c0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270152316453931831386285
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountMintedSTRINGAmount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.
addressremovedlog_indexin_reserveblock_numberblock_timestampin_amountMintedtransaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814adfalse1890x2791bca1f2de4661ed88a30c99a7a9449aa84174612222052024-08-30T13:05:38.000Z3596079590x90322bb3690e67d14d41fb72ac9f10c4cfa33338ca617c472187c894b54699f6
0x794a61358d6845594f94dc1db02a252b5b4814adfalse1980xc2132d05d31c914a87c6611c10748aeb04b58e8f612222052024-08-30T13:05:38.000Z1566499260x90322bb3690e67d14d41fb72ac9f10c4cfa33338ca617c472187c894b54699f6
0x794a61358d6845594f94dc1db02a252b5b4814adfalse1830x8f3cf7ad23cd3cadbd9735aff958023239c6a063612222052024-08-30T13:05:38.000Z3801786033820277925860x90322bb3690e67d14d41fb72ac9f10c4cfa33338ca617c472187c894b54699f6
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_repayerSTRINGAddress of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_useATokensBOOLBoolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.
addressin_userremovedin_amountlog_indexin_repayerin_reserveblock_numberin_useATokensblock_timestamptransaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad0x3fabe6f79f5119336886bbbdfc0b0853dc831919false171015809753726750792963610x3fabe6f79f5119336886bbbdfc0b0853dc8319190x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a41369646false2023-04-10T13:47:28.000Z0xdf8f3408a06c343b94b98da2518a7d3070635966cd4fc171ebe1dd6be41979de
0x794a61358d6845594f94dc1db02a252b5b4814ad0xb731c1da69c3bff9b4d13a911895f052a71f19bbfalse4750000000000000000001960xb731c1da69c3bff9b4d13a911895f052a71f19bb0x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a41378228false2023-04-10T18:57:14.000Z0x888d3030876a4782725c5a6a5de142d100f491b29e97f1b732ee781b9158eb97
0x794a61358d6845594f94dc1db02a252b5b4814ad0x0b7b8c32a3e52fee150e078a9ed014ab3eedcc7bfalse10000000000000000000004490x1e4b7a6b903680eab0c5dabcb8fd429cd2a9598c0x0d500b1d8e8ef31e21c99d1db9a6444d3adf127041354048false2023-04-10T04:04:10.000Z0xa354801e560267002164347d1c2999f1b580cb6a8c60e3ab01c548ad49d3552c
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_liquidityRateSTRINGCurrent 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_stableBorrowRateSTRINGCurrent 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_variableBorrowRateSTRINGCurrent 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_liquidityIndexSTRINGCumulative 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_variableBorrowIndexSTRINGCumulative 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.
addressremovedlog_indexin_reserveblock_numberblock_timestampin_liquidityRatetransaction_hashin_liquidityIndexin_stableBorrowRatein_variableBorrowRatein_variableBorrowIndex
0x794a61358d6845594f94dc1db02a252b5b4814adfalse00xd6df932a45c0f255f85145f286ea0b292b21c90b351107302022-11-02T13:48:18.000Z00x7a478ba439270a2bb71a1a3981c6774040020c1672af4c65fd52ec1c2e94c12b10001838593803448531456083799000000000000000000000000001000000000000000000000000000
0x794a61358d6845594f94dc1db02a252b5b4814adfalse00xd6df932a45c0f255f85145f286ea0b292b21c90b351135632022-11-02T15:25:43.000Z00xdd9ce6bd9c1060edb31de4d5d69302fd85203702b8a429c02db17dce703fbdd410001838594865340555985957739000000000000000000000000001000000000000000000000000000
0x794a61358d6845594f94dc1db02a252b5b4814adfalse00x7ceb23fd6bc0add59e62ac25578270cff1b9f619351125462022-11-02T14:50:45.000Z17352222268514437029674930x487da10645884e08d9025414b2e3946c6a9478be4b917c7601a96be26a7bfa2d100328105800137482851379217190000000000000000000000000173180528001602540961425241011011785329025070095370173
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_onBehalfOfblock_timestampin_referralCodetransaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad0x0a031fb8cc977d5d1f34a0212be8cad3ab630357false1481853004850946413600x03b54a6e9a984069379fae1a4fc4dbae93b3bccd740991580x0a031fb8cc977d5d1f34a0212be8cad3ab6303572025-07-18T06:29:08.000Z00x5baf35a477b04189d71e073c41a489fde7ccf9db85d97ec1ddf5b8ddd5774f71
0x794a61358d6845594f94dc1db02a252b5b4814ad0x0e4533cad21947661c644f2014c76b4f4d000b0afalse23443556329345893710x03b54a6e9a984069379fae1a4fc4dbae93b3bccd740960030x0e4533cad21947661c644f2014c76b4f4d000b0a2025-07-18T04:37:24.000Z00x14d7d29deaaee52ed3e41e9c14944f018c340ce931db7d59f3777fb55e64ffa7
0x794a61358d6845594f94dc1db02a252b5b4814ad0x440ba0d649d2fc64b34becf8b211595780c9fefefalse800000000000000011120x03b54a6e9a984069379fae1a4fc4dbae93b3bccd741051330x440ba0d649d2fc64b34becf8b211595780c9fefe2025-07-18T10:01:48.000Z00x318bb52969389f873036f44dd2f6ba16ad4a98f83e64b0ee6574975382e7e903
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressin_userremovedin_amountlog_indexin_reserveblock_numberblock_timestamptransaction_hash
0x238643d4106c7c6206f8dc31acb59cd24c979d120x794a61358d6845594f94dc1db02a252b5b4814ad0x238643d4106c7c6206f8dc31acb59cd24c979d12false16101380645330474147850x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a341982552022-10-11T06:06:29.000Z0x9a7e30e04ea36b57f21c8facea66e29ea32a8490efdb6b120a36bd8a0f49e8ef
0x2e26ff7bc1ba49c4a234858f6a75379c56a9c85b0x794a61358d6845594f94dc1db02a252b5b4814ad0x2e26ff7bc1ba49c4a234858f6a75379c56a9c85bfalse662351766617131848784750x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a342233352022-10-11T20:31:41.000Z0x85bb607e87aa3bb68af753aff5856e6f1af86d8695347566f0569ee79f7207d1
0x301f221bc732907e2da2dbbfaa8f8f6847c170c30x794a61358d6845594f94dc1db02a252b5b4814ad0x301f221bc732907e2da2dbbfaa8f8f6847c170c3false2000000000000000000001590x0b3f868e0be5597d5db7feb59e1cadbb0fdda50a342213722022-10-11T19:24:11.000Z0x264c2563f430c0c50d1785d84fd264332cacade71603f8516460830418d47ac8
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.LendingPool_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in lending markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_ltvSTRINGLoan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
in_liquidationThresholdSTRINGLiquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
in_liquidationBonusSTRINGLiquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.
in_ltvaddressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_liquidationBonusin_liquidationThreshold
75000x8145edddf43f50276641b55bd3ad95944510021efalse0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd372624990622024-10-01T11:19:48.000Z0xfbe648eb076d12dd6f81e3a893ca6240c9986c5058b5c08b312fb5eebefed132107207900
66000x8145edddf43f50276641b55bd3ad95944510021efalse0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39369624990622024-10-01T11:19:48.000Z0xfbe648eb076d12dd6f81e3a893ca6240c9986c5058b5c08b312fb5eebefed132107507100
63000x8145edddf43f50276641b55bd3ad95944510021efalse0xd6df932a45c0f255f85145f286ea0b292b21c90b371624990622024-10-01T11:19:48.000Z0xfbe648eb076d12dd6f81e3a893ca6240c9986c5058b5c08b312fb5eebefed132107507000
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.LendingPoolConfigurator_CollateralConfigurationChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldFeeSTRINGPrevious liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
in_newFeeSTRINGUpdated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.
addressremovedin_assetin_newFeein_oldFeelog_indexblock_numberblock_timestamptransaction_hash
0x8145edddf43f50276641b55bd3ad95944510021efalse0xfa68fb4628dff1028cfec22b4162fccd0d45efb62000082333168632022-09-19T21:02:19.000Z0xffd11dcfb6db64df0c6919e15483ca3b09032be9214fef93c5d990f8c95f3ec2
0x8145edddf43f50276641b55bd3ad95944510021efalse0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c420000175331015852022-09-14T16:26:59.000Z0x9470258f40ba4cdf5150dcb0aa7a926492357d1e74d1baa180c9c89bf6be28c7
0x8145edddf43f50276641b55bd3ad95944510021efalse0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd1000066422205252023-05-02T15:25:10.000Z0x026e80d2cad6383b8f1f62993f402e4f03bd7bccad80e013182a2a432ac3365f
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldReserveFactorSTRINGPrevious reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
in_newReserveFactorSTRINGUpdated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.
addressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_newReserveFactorin_oldReserveFactor
0x8145edddf43f50276641b55bd3ad95944510021efalse0x2791bca1f2de4661ed88a30c99a7a9449aa84174206683663232025-02-25T19:25:59.000Z0x4cde475606ee8448a9b44d38cbe19db2e1c1526d8dd358773ea3bf2d98c38fac60005000
0x8145edddf43f50276641b55bd3ad95944510021efalse0x3c499c542cef5e3811e1192ce70d8cc03d5c3359210683663232025-02-25T19:25:59.000Z0x4cde475606ee8448a9b44d38cbe19db2e1c1526d8dd358773ea3bf2d98c38fac20001000
0x8145edddf43f50276641b55bd3ad95944510021efalse0xc2132d05d31c914a87c6611c10748aeb04b58e8f208683663232025-02-25T19:25:59.000Z0x4cde475606ee8448a9b44d38cbe19db2e1c1526d8dd358773ea3bf2d98c38fac25001000
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenSTRINGContract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_stableDebtTokenSTRINGContract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_variableDebtTokenSTRINGContract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_interestRateStrategyAddressSTRINGContract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_assetin_aTokenlog_indexblock_numberblock_timestamptransaction_hashin_stableDebtTokenin_variableDebtTokenin_interestRateStrategyAddress
0x8145edddf43f50276641b55bd3ad95944510021efalse0xfa68fb4628dff1028cfec22b4162fccd0d45efb60x80ca0d8c38d2e2bcbab66aa1648bd1c7160500fe78333168632022-09-19T21:02:19.000Z0xffd11dcfb6db64df0c6919e15483ca3b09032be9214fef93c5d990f8c95f3ec20x62fc96b27a510cf4977b59ff952dc32378cc221d0xb5b46f918c2923fc7f26db76e8a6a6e9c4347cf90x03733f4e008d36f2e37f0080ff1c8df756622e6f
0x8145edddf43f50276641b55bd3ad95944510021efalse0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd0xf59036caebea7dc4b86638dfa2e3c97da9fccd4057422205252023-05-02T15:25:10.000Z0x026e80d2cad6383b8f1f62993f402e4f03bd7bccad80e013182a2a432ac3365f0x173e54325ae58b072985dbf232436961981ea0000x77fa66882a8854d883101fb8501bd3cad347fc320xa6459195d60a797d278f58ffbd2ba62fb3f7fa1e
0x8145edddf43f50276641b55bd3ad95944510021efalse0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c40xea1132120ddcdda2f119e99fa7a27a0d036f7ac9171331015852022-09-14T16:26:59.000Z0x9470258f40ba4cdf5150dcb0aa7a926492357d1e74d1baa180c9c89bf6be28c70x1ffd28689da7d0148ff0fcb669e9f9f0fc13a2190x6b030ff3fb9956b1b69f475b77ae0d3cf2cc5afa0x03733f4e008d36f2e37f0080ff1c8df756622e6f
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.LendingPoolConfigurator_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ShortExecutor_ExecutedAction_event

Governance execution event recording completed actions in Aave V3’s ShortExecutor contract. Contains target address, function signature, execution timestamp, and delegatecall flag for tracking protocol governance operations across chains.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_signatureSTRINGCryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
in_dataSTRINGEncoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
in_executionTimeSTRINGUnix timestamp when the action was executed. Integer value representing seconds since epoch.
in_withDelegatecallBOOLBoolean flag indicating whether the contract call was executed using delegatecall opcode instead of a standard call.
in_resultDataSTRINGReturn data from the executed contract function call. Hex-encoded byte string containing the function’s output parameters.
addressin_dataremovedin_valuein_targetlog_indexblock_numberin_signaturein_resultDatablock_timestampin_executionTimetransaction_hashin_withDelegatecall
0xdf7d0e6454db638881302729f5ba99936eaab2330xfalse00x8c6cd76bedb22ba5bd79fa5ebe47e5d99a22d75a9052901216execute()0x2024-01-29T22:19:36.000Z17065667760xe4a48945c2e428f02a0bf86000fa8dc1a19074c2b2d46e53523f76725c320c6ftrue
0xdf7d0e6454db638881302729f5ba99936eaab2330xfalse00x5056b08129d788344f0bdba4652e936c24229d9a19160424006execute()0x2024-08-10T15:07:09.000Z17233024290xe3268206090d7b6592a62000decaaf34573bdc5a1888a886ca4cda17777530eetrue
0xdf7d0e6454db638881302729f5ba99936eaab2330xfalse00x864fe2b34b6066e3d14fc1fb460faf2b1b069d6431773530806execute()0x2025-07-03T14:57:00.000Z17515546200x41fe8e1d02ffa283ea42970ecf4d85795b6171d541199336a0c970785c8af677true
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.ShortExecutor_ExecutedAction_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_currentBalanceSTRINGUser’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_avgStableRateSTRINGAverage stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
in_newTotalSupplySTRINGUpdated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.
addressin_fromremovedin_amountlog_indexblock_numberblock_timestampin_avgStableRatetransaction_hashin_currentBalancein_newTotalSupplyin_balanceIncrease
0x307ffe186f84a3bc2613d1ea417a5737d69a70070x23de13e5707126536ff9800461a34f98837b4b67false81331217337098022022-09-29T10:38:06.000Z528615384457710311071271410xf3bb160855d0f112068a88f256421bd092c40699613678de84bb1e83c26e1b8d813312044392243360
0x307ffe186f84a3bc2613d1ea417a5737d69a70070x73a9ee34eaa91046b12e7598a540f28fa1b590a6false42257475216337285102022-09-29T21:37:51.000Z528643619396345963268793040x06cc7c2669e1f78dd4ba95845d655d46fcfd699c74d8ae45ac0ee7d080e9b4328456750120367975013626209
0x307ffe186f84a3bc2613d1ea417a5737d69a70070xa09bcf8b6236766d4f73bdd439e5d63fed6615a5false722950973404337111182022-09-29T11:23:26.000Z528643618236403390083474800x247ef040e705a9dda1bf7a3173cbbd65a86ba235ceca4bed555b9da75fba218f80005106820371715644649027
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_currentBalanceSTRINGUser’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_newRateSTRINGUpdated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
in_avgStableRateSTRINGAverage stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
in_newTotalSupplySTRINGUpdated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.
addressin_userremovedin_amountlog_indexin_newRateblock_numberin_onBehalfOfblock_timestampin_avgStableRatetransaction_hashin_currentBalancein_newTotalSupplyin_balanceIncrease
0x307ffe186f84a3bc2613d1ea417a5737d69a70070xeea8f7ba122fbadeb1ae725ba81294360ac5f9aafalse160000000019752384146630329355000000000309472980xeea8f7ba122fbadeb1ae725ba81294360ac5f9aa2022-07-20T18:54:45.000Z530076348744306012635599990xed9aa9b61fa4f86781c5c10feca60b2059d2a6967e0e5c28334bcf8b129095fd01925552560680
0x307ffe186f84a3bc2613d1ea417a5737d69a70070xfe6882837b95cb94ff35867c87bd8fde8cb347f2false4500000000028952351601250558280044444444309380580xfe6882837b95cb94ff35867c87bd8fde8cb347f22022-07-20T13:31:09.000Z530130507977970305674749910x21e79add851c9008f20d0c1dc613f23eb6660063bf71c60dd92567ea651bb45f01915805985180
0x307ffe186f84a3bc2613d1ea417a5737d69a70070x989e663f0c104e2f1a0bec618fa7b5f4dc093417false20000000019452334674631211300000000000309176500x989e663f0c104e2f1a0bec618fa7b5f4dc0934172022-07-20T01:10:04.000Z532161095029026293351658920xd9401638bbd0870460f1104f0a982af83ec624f79f74db7c7ecfaf74407562c001465704522950
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x77fa66882a8854d883101fb8501bd3cad347fc320xb2b89fc6dac21b553caa7b3e751089dc0cbd6344false1002066749769095954666241692183044358009432150x0000000000000000000000000000000000000000155491657012023-10-26T07:18:22.000Z0x8fd39543aa86acdb7c994684b64007c6b18b74c453c75d5d8f105a9c641d69787798915117396
0x77fa66882a8854d883101fb8501bd3cad347fc320x08f5dbfcb664b9ebb64574aa2cc8e353203028c8false10020774446474960809630046162999200454874155880x0000000000000000000000000000000000000000143491907082023-10-26T22:12:50.000Z0x2578ee545f2da0941972e6c9f4cd67afa29f627e974958d5a16814d5518c9d4579954512584412
0xb5b46f918c2923fc7f26db76e8a6a6e9c4347cf90xece1477d3c350a42486d2dc802f6243e99409a41false100232632300824779236706654936041962658052367830x0000000000000000000000000000000000000000376491537922023-10-26T00:04:47.000Z0x629952c393edb9d7b69c0acbdcc3fe83c105ee7c06aa741bb2beb70185cd1d7e142369618529223
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351false10284639129403935984520628503467438372939730x063f69b513628aaedd10696028609cf8ed522c42366481318450x063f69b513628aaedd10696028609cf8ed522c422023-09-29T18:00:53.000Z0xdfa98f32118b76e8142172079461b6b41609e495bb78399682965a930167393d11595223204
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351false10284573751846538536935861533848364464596390x063f69b513628aaedd10696028609cf8ed522c42698481277060x063f69b513628aaedd10696028609cf8ed522c422023-09-29T15:29:02.000Z0x7c8a5ad1b95df2b25b24db99c6e7baeaac1140c050f899ba3df2d5be7f43ac493045937599
0x0c84331e39d6658cd6e6b9ba04736cc4c4734351false10284481869079770806870528733593518006034050x063f69b513628aaedd10696028609cf8ed522c42552481217260x063f69b513628aaedd10696028609cf8ed522c422023-09-29T11:55:39.000Z0x3f0d67068c8c19f9c89f9fea1983e3c84b4a9f1108eb53dce241a7cf9cc5dc6c16848059005
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_anon0STRINGContract address of the lending pool. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_polygon.WrappedTokenGatewayV3_withdrawETH_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100