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
0x0727a6494095511078d63143a8a1e90b9f3108800x00901a076785e0906d1028c7d6372d247bec7d610xa46afe1e600956ca4ecbd6f3186bc2155d5ecf63false1022901605837289337866318091507045474937324423090387648852024-05-16T06:12:08.000Z0x9badfeb0d359103bb16e5b853e5c86ad34ac5ab0fc929c781417f28bbdc84dd7
0x33e0b3fc976dc9c516926ba48cfc0a9e10a2aaa50x00901a076785e0906d1028c7d6372d247bec7d610x287e643ce0502664338cb176b67f18a26bc444bbfalse102298115091152365258582318999753635673218604090744387842122024-05-16T22:21:39.000Z0x71688f185c49c593477a3a40078f8b86e29d4735bbbaa02c09ada05f3cbb8ced
0x0727a6494095511078d63143a8a1e90b9f3108800x2e94171493fabe316b6205f1585779c887771e2f0x385af66f4d0d6b54805c43691e5b226729eb7847false10009342032853221316536874246390014311947595098121387577502024-05-16T00:14:05.000Z0x1d9264449be3798432f32180d354968db8e9237ecda8cda53bd8d5ab53428ce7
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x2e94171493fabe316b6205f1585779c887771e2f0x04520de90ba88a1e096705425ea180c925ea9e32false100522196173629037653677371214630680000000000000x04520de90ba88a1e096705425ea180c925ea9e32111462404772025-01-31T05:52:38.000Z0xdac99b4472a4f9585f34626e3954ac6179b29e8a93a202312d9b7021f5415410147514472290109
0xa9251ca9de909cb71783723713b21e4233fbf1b10x06ebf9f5c391cb02cc2d6ae874961598d1445493false10721887961449226347596582292489076873856606196470x06ebf9f5c391cb02cc2d6ae874961598d14454934462538072025-01-31T16:59:16.000Z0x4e0a1ee7c47a37ca2a94491e9e10cf27627aae40c99de417e108125b3a5c23c61092312614339380353
0x56a7ddc4e848ebf43845854205ad71d5d5f72d3d0x084698d7d809f778691603cd520a5aa1d1637a10false1000506532925665932072260874149997158314333910x084698d7d809f778691603cd520a5aa1d1637a1038462393132025-01-31T04:54:24.000Z0x8d91699ae3d5780a16f59e283f31ff6d97b6241cffa6bfd4529e3114160fd8e6284168566609
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x56a7ddc4e848ebf43845854205ad71d5d5f72d3d0x6807dc923806fe8fd134338eabca509979a7e0cbfalse0x2570x25ec457d1778b0e5316e7f38f3c22baf413f1a8c35498575Aave BNB Smart Chain BTCB2024-01-23T14:47:12.000ZaBnbBTCB0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4180x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c0xc206c2764a9dbf27d599613b8f9a63acd1160ab4
0x2e94171493fabe316b6205f1585779c887771e2f0x6807dc923806fe8fd134338eabca509979a7e0cbfalse0x2610x25ec457d1778b0e5316e7f38f3c22baf413f1a8c35498575Aave BNB Smart Chain ETH2024-01-23T14:47:12.000ZaBnbETH0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4180x2170ed0880ac9a755fd29b2688956bd959f933f80xc206c2764a9dbf27d599613b8f9a63acd1160ab4
0x9b00a09492a626678e5a3009982191586c444df90x6807dc923806fe8fd134338eabca509979a7e0cbfalse0x2530x25ec457d1778b0e5316e7f38f3c22baf413f1a8c35498575Aave BNB Smart Chain WBNB2024-01-23T14:47:12.000ZaBnbWBNB0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4180xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c0xc206c2764a9dbf27d599613b8f9a63acd1160ab4
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0xa9251ca9de909cb71783723713b21e4233fbf1b1false108697658761970449776244727420148050768489308610x00c600b30fb0400701010f4b080409018b9006e0344537903320x6a000f20005980200259b80c51020030400010682025-07-12T17:16:33.000Z0xb8702761d35f1c6c143e622c3fb0a0848b76f2d43f4e2b1b57512f310d7014060
0xa9251ca9de909cb71783723713b21e4233fbf1b1false108697473053990228168251959679961841743741212320x00c600b30fb0400701010f4b080409018b9006e0708537867530x6a000f20005980200259b80c51020030400010682025-07-12T16:31:48.000Z0x561447c40508c72e62d7baaad6aa6bd384f897c3a9c76aff88869737f1cfbec30
0xa9251ca9de909cb71783723713b21e4233fbf1b1false1086952978618738730671047349299172854387820549000x00c600b30fb0400701010f4b080409018b9006e0878537448230x6a000f20005980200259b80c51020030400010682025-07-12T07:47:38.000Z0x280184125a1fa83ec9ae2a348e093393fce3a5b990db991c899a51e55410f34a0
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cb0x586fe4f146fe62a92f8539bc890c49dc39d4516bfalse100000000000000000001300x0e09fabb73bd3ade0a17ecc321fd13a19e81ce8242332821136604411486643540679324840x586fe4f146fe62a92f8539bc890c49dc39d4516b2024-09-17T12:34:01.000Z00x29c6ef04fae9f4545e6afe390ed29d734cbb1b9e1a0e3ed6be0964b0b78641672
0x6807dc923806fe8fd134338eabca509979a7e0cb0xf00111f367b6684a7654f4f45ab48570d7299f11false42000000000000000000090x0e09fabb73bd3ade0a17ecc321fd13a19e81ce8242341435137064470454845749776544440xf00111f367b6684a7654f4f45ab48570d7299f112024-09-17T19:45:24.000Z00x60b7b20605657d5429224bd703a8138a27f94ec9c83a7536585f9a584609c70e2
0x6807dc923806fe8fd134338eabca509979a7e0cb0x27f12d7520d43cc65459df04d5a0bf33901a298afalse130000000000000000002930x2170ed0880ac9a755fd29b2688956bd959f933f842325665111063534165236689261148800x27f12d7520d43cc65459df04d5a0bf33901a298a2024-09-17T06:35:21.000Z00x1b32b16ce9c0e8cb916afe595dd03fb4fd8138e4d81873d94bc7d93c5ff86bb32
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse0x55d398326f99059ff775485246999027b3197955267960967874658862910xe1f435dfcd6969ae22e96aab56d5ba1bc837b1d51813398048393732943386473690xe1f435dfcd6969ae22e96aab56d5ba1bc837b1d52024-05-12T04:04:13.000Z00x36caeb983b32a93c9d0c5890772d9717f3bdd415de38f71916c2dbf83b611b500
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse0x2170ed0880ac9a755fd29b2688956bd959f933f81336242273165145090x0727a6494095511078d63143a8a1e90b9f31088015866812113658257386711960x7693517008eee395e93dfc8e784d48e667222fa62024-05-12T23:58:10.000Z00x527b3f68003a6f57be03a23e1cd73e1a21721139b74a407739b8cea0465b9a450
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse0x2170ed0880ac9a755fd29b2688956bd959f933f82689563715908467190x0727a6494095511078d63143a8a1e90b9f310880107134478185795423386583280x7693517008eee395e93dfc8e784d48e667222fa62024-05-12T13:13:42.000Z00x4b54d2b6528a00c2dd3bc62eb5f534920ea34a745009e4991b37052b1e74a4f20
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cb0xcf2a8b8563ee046bccbf33fc58c6d29b1db0c6aefalse101378332980x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x1cbda9e3ecf292d5113fc6be56aadb9e244782652394568605012939933582024-04-13T20:23:59.000Zfalse0xb6d675b7618849bbe07347b235ee6783b3b175802cdc4007d738c4b628aa4c000x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82101207968801323519728
0x6807dc923806fe8fd134338eabca509979a7e0cb0x2a316e998781e0f8901967d6073f879b180b2a66false173378346020x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x1cbda9e3ecf292d5113fc6be56aadb9e244782651012465107265429569972024-04-13T21:30:02.000Zfalse0x78905fa75e53ff8561f9bd25ed9125715259f9d15fb15b5ef2754592f447fe460x0e09fabb73bd3ade0a17ecc321fd13a19e81ce8245053541190361591185
0x6807dc923806fe8fd134338eabca509979a7e0cb0x984103ac304cea446e4d8a8a8e4731eaa0afcc07false19378327000xc5f0f7b66764f6ec8c8dff7ba683102295e164090x1cbda9e3ecf292d5113fc6be56aadb9e2447826523845518026678708989082024-04-13T19:52:54.000Zfalse0x2d5f55a6d1b5014cc5dd85351b3c1178fe11d6a8dfabbb9a2157ee73269c29740x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82873123504777998210028
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse1070xc5f0f7b66764f6ec8c8dff7ba683102295e16409378061752024-04-12T21:44:23.000Z35665295833018269856080xf40a8a2094391c85418bcee21ff93b51fc83e20cf38ddc554cc3d8fa49d6e946
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse980x2170ed0880ac9a755fd29b2688956bd959f933f8378061752024-04-12T21:44:23.000Z223579853353945640xf40a8a2094391c85418bcee21ff93b51fc83e20cf38ddc554cc3d8fa49d6e946
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse890x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82378061752024-04-12T21:44:23.000Z15223149476587717360xf40a8a2094391c85418bcee21ff93b51fc83e20cf38ddc554cc3d8fa49d6e946
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cb0x22a9b881eeb103cfa9766fc835f8f5a64b2f329dfalse3078049551631222743713200x0727a6494095511078d63143a8a1e90b9f3108800xc5f0f7b66764f6ec8c8dff7ba683102295e1640936731361false2024-03-06T12:05:25.000Z0x2ba3b5f2ba86ae8e901ebdabd661305b418282958e3679fba3c8fd89bda33e6d
0x6807dc923806fe8fd134338eabca509979a7e0cb0x49df226357b7b060e3171e1084892c0a68e600d3false500000000000000000002550x0727a6494095511078d63143a8a1e90b9f3108800xc5f0f7b66764f6ec8c8dff7ba683102295e1640936741311false2024-03-06T20:23:48.000Z0xc56b9424c519e35a2874ce5257251626de227450e9179f8054f6cb013170a974
0x6807dc923806fe8fd134338eabca509979a7e0cb0x5569a9660730fd042f20ace9cb9d1735399170cdfalse4964568608416106778083880x0727a6494095511078d63143a8a1e90b9f3108800xc5f0f7b66764f6ec8c8dff7ba683102295e1640936736130false2024-03-06T16:04:12.000Z0xde0341b8896ac6438c14e01411ecd5e5439304cad3d7ad66e12ad7b194412042
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse150x26c5e01524d2e6280a48f2c50ff6de7e52e9611c439889802024-11-14T01:27:56.000Z989683112466335602110860x884f0375241961575b7aab80ab8a267ed4776285171e0b649a3aa7dfb609ea721000001703279022478044612162042558016647679242919523841000060574401221061035177188
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse1280x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c439875352024-11-14T00:15:41.000Z539493365159356720711240x71aa5affbf5a307cbd0748b5b2e07e791d71ad02eff6f411162a5cfdffc910401000481065429021812703406379032388499142423212617484601003352449328158053173173942
0x6807dc923806fe8fd134338eabca509979a7e0cbfalse1900x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c439876792024-11-14T00:22:53.000Z538818055709052258397070xe67529cdfe44f774982a21869a972b39d82ac64c12e57b6825fe4a6addc2c01a1000481066168409342520559157032368221684081191360578711003352493844706907771235190
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x6807dc923806fe8fd134338eabca509979a7e0cb0x8639210491c10fabf47bc6e9457eba98ca8c026efalse25131889743496371599212130x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82366242430x8639210491c10fabf47bc6e9457eba98ca8c026e2024-03-02T18:39:49.000Z00x47625c00c97f5638fcd492936d4e290cb4580788a8945e9901199aaaad0c06a2
0x6807dc923806fe8fd134338eabca509979a7e0cb0x0727a6494095511078d63143a8a1e90b9f310880false795532981096493270x2170ed0880ac9a755fd29b2688956bd959f933f8366187030xf7b4a0062fce6e8f395a8fb95bed81a356d78bed2024-03-02T14:02:31.000Z00xd224c994eeb7520a54ac7637f4b35037b3fd25612f507d92fdda5350fdf7d95e
0x6807dc923806fe8fd134338eabca509979a7e0cb0x225a11fd88b2e1b92bf45be47b8cde86a63f240cfalse5446594011736620740x2170ed0880ac9a755fd29b2688956bd959f933f8366152090x225a11fd88b2e1b92bf45be47b8cde86a63f240c2024-03-02T11:07:32.000Z00x6085967545f826913f0023efc09bb333194b64a95a150b05d699469efb6f9efa
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x3c59211297f9e3215e60bc02b4a8ec3a78eca1690x6807dc923806fe8fd134338eabca509979a7e0cb0x3c59211297f9e3215e60bc02b4a8ec3a78eca169false327278138494809347581440x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82390393002024-05-25T19:24:51.000Z0xfa54414ae5e853927a859ce4b18f426309d222339ca34bacbf24dc1fcf124e8e
0x0727a6494095511078d63143a8a1e90b9f3108800x6807dc923806fe8fd134338eabca509979a7e0cb0x0727a6494095511078d63143a8a1e90b9f310880false11235302402445386392850x2170ed0880ac9a755fd29b2688956bd959f933f8390268372024-05-25T09:00:44.000Z0xebc6cf47e23370b94dda47ac73a56d80442eae0ac7e35830ac5984c405813474
0x33e0b3fc976dc9c516926ba48cfc0a9e10a2aaa50x6807dc923806fe8fd134338eabca509979a7e0cb0x33e0b3fc976dc9c516926ba48cfc0a9e10a2aaa5false295488917123388930720x2170ed0880ac9a755fd29b2688956bd959f933f8390418922024-05-25T21:34:45.000Z0x76f7c5988505353f75250735bfff68d90382dc26b99b1f4d3bc14792cfaeb7ab
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
75000x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x55d398326f99059ff775485246999027b3197955340354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4105008000
77000x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d336354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4105008000
55000x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82321354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4110006100
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.LendingPoolConfigurator_CollateralConfigurationChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

Aave V3 LendingPoolConfigurator event emitted when the protocol’s share of flash loan fees is updated, recording both old and new premium values in basis points. Used for tracking protocol fee parameter changes and governance decisions.
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_oldFlashloanPremiumToProtocolSTRINGPrevious flashloan premium allocated to the protocol treasury before the update. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.
in_newFlashloanPremiumToProtocolSTRINGUpdated flashloan premium allocated to the protocol treasury. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_newFlashloanPremiumToProtocolin_oldFlashloanPremiumToProtocol
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false266335716252023-11-17T12:25:17.000Z0x88bd8649730ef615e8ba0f606e53ce3b3522605a47c7633158292f8a1792c9fe40
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false304527422282025-07-03T14:54:31.000Z0x351a09449be739c87efd788b075f015257ce5acbcbff040137864ef364a7926f100004
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

Aave V3 protocol configuration event tracking changes to flash loan premium rates. Contains old and new premium values in basis points for protocol fee analysis and governance monitoring.
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_oldFlashloanPremiumTotalSTRINGPrevious total flash loan premium fee rate expressed in basis points.
in_newFlashloanPremiumTotalSTRINGUpdated total flash loan premium fee rate expressed in basis points.
addressremovedlog_indexblock_numberblock_timestamptransaction_hashin_newFlashloanPremiumTotalin_oldFlashloanPremiumTotal
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false265335716252023-11-17T12:25:17.000Z0x88bd8649730ef615e8ba0f606e53ce3b3522605a47c7633158292f8a1792c9fe50
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.
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
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x26c5e01524d2e6280a48f2c50ff6de7e52e9611c1000083437466812024-11-05T15:20:52.000Z0xb161ba73cea34447d89cb9016a16fd749afa289ee77f3c2c32ac901b93155044
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0xc5f0f7b66764f6ec8c8dff7ba683102295e164091000094359081132024-02-06T20:43:05.000Z0x5603c550b71608f4cd96710e364551cb01d98b9ad8fe4cfe2217ee69fd7eca8e
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x2170ed0880ac9a755fd29b2688956bd959f933f810000333354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c4
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0xc5f0f7b66764f6ec8c8dff7ba683102295e1640991359081132024-02-06T20:43:05.000Z0x5603c550b71608f4cd96710e364551cb01d98b9ad8fe4cfe2217ee69fd7eca8e20000
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x26c5e01524d2e6280a48f2c50ff6de7e52e9611c79437466812024-11-05T15:20:52.000Z0xb161ba73cea34447d89cb9016a16fd749afa289ee77f3c2c32ac901b9315504415000
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x55d398326f99059ff775485246999027b3197955319354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c410000
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0xc5f0f7b66764f6ec8c8dff7ba683102295e164090x75bd1a659bdc62e4c313950d44a2416fab43e78584359081132024-02-06T20:43:05.000Z0x5603c550b71608f4cd96710e364551cb01d98b9ad8fe4cfe2217ee69fd7eca8e0x5543d347bfae77a5ff913e589ab6d6ad520f1c730xe628b8a123e6037f1542e662b9f55141a16945c80xdffd9cdd2ec42099d7086ff76938c111022014d0
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x00901a076785e0906d1028c7d6372d247bec7d61268354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c40xccc260d9778f900ead566fa2e1d622e6676776530xcdbbed5606d9c5c98eeedd67933991dc17f0c68d0x786c9ff899805fa0813c77cd3228c0e857664e78
0x67bdf23c7fce7c65ff7415ba3f2520b45d6f9584false0x55d398326f99059ff775485246999027b31979550xa9251ca9de909cb71783723713b21e4233fbf1b1272354985752024-01-23T14:47:12.000Z0x7b03a46cea96cfdc9d6343c708ae8bb0197c64f5d3fa827df0f4ccfa5fb9e3c40xb735d922a36d4337f561ce433594727e1bc8bd010xf8bb2be50647447fb355e3a77b81be4db64107cd0xa60d98d1e7c1b5c186c181152ae7412c38abac94
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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.
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.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x0e76414d433ddfe8004d2a7505d218874875a9960xd27accb1e01dcbbdc507819652837e6a3d1631d2false1045031505354398386401142781100000000000000000x0000000000000000000000000000000000000000158390381182024-05-25T18:25:45.000Z0x926df27b7faac313680da5eb091adac1aeb1a20a9d0e96d5fc5b9c1fd9f0e0301516156697
0x7b1e82f4f542fbb25d64c5523fe3e44abe4f27020x49b8ff21c0489dd378ca5eefb6ee288a6267714ffalse1001754091537970115629176093299999833081660x000000000000000000000000000000000000000033390381622024-05-25T18:27:57.000Z0x3afec80ac2ed186535f6ca9e7337f4ee6318876f88f7a551690f4d638650792516691834
0x7b1e82f4f542fbb25d64c5523fe3e44abe4f27020x49b8ff21c0489dd378ca5eefb6ee288a6267714ffalse1001754126949930555305823752166918350x000000000000000000000000000000000000000048390382812024-05-25T18:33:54.000Z0x0b2e1a609ccddf98276cf83e828b28efbb3c829bacfb985c0ad1906c27b699b30
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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
0x0e76414d433ddfe8004d2a7505d218874875a996false10001920741723381490017516771050000000000000000xd91d1331db4f436daf47ec9dd86decb8eef946b4155358681140xbf9949933e418ab5a0344651a3e9c8df234ba6192024-02-05T11:19:02.000Z0xd6d2ac11c22ba8a9c8e0961a30037a4fd4e7619f3a7922d1232dd1f987de02a50
0x0e76414d433ddfe8004d2a7505d218874875a996false10001924295399054377097543866400001768288687130xd91d1331db4f436daf47ec9dd86decb8eef946b4160358727210x7a0744f7eba675c324f2be9169f9ede23db613ec2024-02-05T15:09:38.000Z0xc47b5506d9a64199259c6b1eef638c05658f27cdf61efe41ecd0f952c432a8a2176828868713
0x0e76414d433ddfe8004d2a7505d218874875a996false1000192680577785495980524367247202044964875640xd91d1331db4f436daf47ec9dd86decb8eef946b4107358739630x44f010c36b4bb6489e66d084e70c7f329d63fbf12024-02-05T16:11:50.000Z0x74eb2e2372209cbed6cd06c9ceb8429fb0b35b410dbfbe4b5026bf5c4709102a0
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.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.
gasin_tovaluestatusgas_usedin_anon0in_amountsignatureto_addressblock_numberfrom_addresstrace_addressblock_timestamptransaction_hash
4357910x2da892095b107381c2d68b70cd6ef045bc16815d0true2422570x6807dc923806fe8fd134338eabca509979a7e0cb1157920892373161954235709850086879078532699846656405640394575840079131296399350x80500d200x0c2c95b24529664fe55d4437d7a31175cfe6c4f7494757530x2da892095b107381c2d68b70cd6ef045bc16815d2025-05-11T09:46:51.000Z0x3cc7ba9430ff86300172dfd8d981d9e41e154ffdf3573e2e16af9689a1c999fc
4357910xe8ca11cc8b272069aa7e88ea5badcf2e329703160true2422570x6807dc923806fe8fd134338eabca509979a7e0cb1157920892373161954235709850086879078532699846656405640394575840079131296399350x80500d200x0c2c95b24529664fe55d4437d7a31175cfe6c4f7494555190xe8ca11cc8b272069aa7e88ea5badcf2e329703162025-05-11T01:20:59.000Z0xf58251490a8dded80885a9c225d2c95960b844c6bca60e3ec34a559deacdde75
3776850x1b1ed976669f4b33f436e22cb9cd0e85b26be5a00true2422570x6807dc923806fe8fd134338eabca509979a7e0cb1157920892373161954235709850086879078532699846656405640394575840079131296399350x80500d200x0c2c95b24529664fe55d4437d7a31175cfe6c4f7494927290x1b1ed976669f4b33f436e22cb9cd0e85b26be5a02025-05-11T16:51:17.000Z0x5869a094d3abc005f5224fbc6af7e9796eeb6d9f03369de5b0cf9e8feb7e7822
Query with partition filter
SELECT *
FROM `tt-contracts.aave_v3_bsc.WrappedTokenGatewayV3_withdrawETH_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100