aave_v3_arbitrum

Tables

AToken_BalanceTransfer_event

Interest-bearing aToken balance transfer events from Aave V3 lending protocol. Records movements between accounts with normalized interest index for calculating accrued yields on deposited collateral.

Columns

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

Sample Data

in_to	address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0x000000000000000000000000000000000000dead	0x625e7708f30ca75bfd92586e17077590c60eb4cd	0x4d842c484484f629064b99c57104174f87debe06	false	1014115451458874057094000801	1	6	94968963	2023-05-27T12:05:08.000Z	0xe7c5a800db91284402be804c3b457bad799939086b460ca55bb5d9602e852d6c
0x09c803b103600d149419025bd44161b08acacc9f	0x6ab707aca953edaefbc4fd23ba73294241490620	0xdd94018f54e565dbfc939f7c44a16e163faab331	false	1041569713969987422839708726	1018310000	11	95134003	2023-05-27T23:39:06.000Z	0x23ef5e9dce70a4551ef2496f93e60134cefa095bed804a84f4b1be3f48c83e90
0x12a6780f6024c96c543c7274c875e2ac9335884c	0x82e64f49ed5ec1bc6e43dad4fc8af9bb3a2312ee	0xdd94018f54e565dbfc939f7c44a16e163faab331	false	1016616427649463543462070482	21497211375225261118	14	95039685	2023-05-27T17:00:19.000Z	0xd053bf5fe412cf17705b8454aaeeab87e81371a4ac180d9b1d46b8d6456cc8f0

Example Query

Query with partition filter

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

AToken_Burn_event

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

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash
0x625e7708f30ca75bfd92586e17077590c60eb4cd	0x0081772fd29e4838372cbccdd020f53954f5ecde	false	1010769225070255919967252696	465196152	0x0081772fd29e4838372cbccdd020f53954f5ecde	80	69473684	2023-03-13T15:19:00.000Z	0xb22b103c5bf42fa03bec6427ded6be22d4516049742b8238d5fcfc809d6fff4e
0x625e7708f30ca75bfd92586e17077590c60eb4cd	0x0081772fd29e4838372cbccdd020f53954f5ecde	false	1010783945863160666059928875	16266143	0x0081772fd29e4838372cbccdd020f53954f5ecde	52	69521790	2023-03-13T19:02:41.000Z	0xdb3b8beab426b9d98aaa72b87296c9a5a375e25ad229319b5efe814dfe83c15b
0x625e7708f30ca75bfd92586e17077590c60eb4cd	0x0081772fd29e4838372cbccdd020f53954f5ecde	false	1010769225070255919967252696	270365142	0x0081772fd29e4838372cbccdd020f53954f5ecde	63	69473684	2023-03-13T15:19:00.000Z	0xb22b103c5bf42fa03bec6427ded6be22d4516049742b8238d5fcfc809d6fff4e

Example Query

Query with partition filter

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

AToken_Initialized_event

Aave V3 AToken initialization events emitted when new interest-bearing token markets are deployed. Contains AToken metadata (name, symbol, decimals), configuration references (pool, treasury, incentives controller), and the underlying asset address being wrapped.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aTokenDecimals`	`INT64`	Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
`in_aTokenName`	`STRING`	Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
`in_aTokenSymbol`	`STRING`	Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	in_treasury	block_number	in_aTokenName	block_timestamp	in_aTokenSymbol	transaction_hash	in_aTokenDecimals	in_underlyingAsset	in_incentivesController
0x8437d7c167dfb82ed4cb79cd44b7a32a1dd95c77	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	2	0x053d55f9b5af8694c503eb288a1b7e552f590710	203072170	Aave Arbitrum weETH	2024-04-20T19:32:53.000Z	aArbweETH	0x8bb7251e9dde6b5605effdf3445ceeee34ac8d274da8bf819f0d32255ba7df6c	18	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	0x929ec64c34a17401f460460d4b9390518e5b473e
0xea1132120ddcdda2f119e99fa7a27a0d036f7ac9	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	10	0x053d55f9b5af8694c503eb288a1b7e552f590710	295743569	Aave Arbitrum ezETH	2025-01-15T16:59:33.000Z	aArbezETH	0x88b14ce8a9b08a6ef0be2d14d00d0302f392612d463ec16aa3a9fda6b64198ad	18	0x2416092f143378750bb29b79ed961ab195cceea5	0x929ec64c34a17401f460460d4b9390518e5b473e
0xc45a479877e1e9dfe9fcd4056c699575a1045daa	0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x	3	0x053d55f9b5af8694c503eb288a1b7e552f590710	90873582	Aave Arbitrum MAI	2023-05-15T07:36:03.000Z	aArbMAI	0x72d101080a7af8792402772fdb715edf9db86536008190e71ed00ff706d3b50f	18	0x3f56e0c36d275367b8c502090edf38289b3dea0d	0x929ec64c34a17401f460460d4b9390518e5b473e

Example Query

Query with partition filter

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

AToken_Mint_event

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

Columns

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

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0x625e7708f30ca75bfd92586e17077590c60eb4cd	false	1144539136249763548503378713	3998	0x0000000000001ff3684f28c67538d4d072c22734	16	369239327	0x8002c521c2d7b4cb6035399a056d91d8b4656d14	2025-08-17T03:13:13.000Z	0x006e2254005961b0eb7270ba30cc1183a07f79e7d9484549ac0532b87ec0b62d	3998
0x625e7708f30ca75bfd92586e17077590c60eb4cd	false	1144596960390474437247306000	1934	0x0000000000001ff3684f28c67538d4d072c22734	19	369495056	0xbb448958dbc7f5d98708da0b438781ce1d4dbc37	2025-08-17T20:57:59.000Z	0xf51080f3423c61c04d28576362b2dc7b90c45eea396ca995af05eb330b49fd3c	1934
0x6ab707aca953edaefbc4fd23ba73294241490620	false	1192463672240776295533204057	32804	0x000000000022d473030f116ddee9f6b43ac78ba3	2	369425523	0x123cc997cec4a5aafd45276dd7eb6ffacbf2ff01	2025-08-17T16:08:18.000Z	0xffea3fe5762f5a0b7772056d14c7c26d1d370a69ff195890e7037cc6654b855f	32804

Example Query

Query with partition filter

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

LendingPool_Borrow_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	in_referralCode	transaction_hash	in_interestRateMode
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x6259ea067d5391d1731eeb2749a6193e889067ac	false	5000000000000000000000	4	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	282086949	149984455735520489500691710	0x6259ea067d5391d1731eeb2749a6193e889067ac	2024-12-06T22:43:57.000Z	0	0x4be0607724a4fe89be8e37907472fa723fb9a51a091da3668c9ef2ffc4de134d	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x62bc3de30e94277213c44c21c55ae0bee8aa956f	false	500000000000000000000	11	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	282083536	54894457745664118170710279	0x62bc3de30e94277213c44c21c55ae0bee8aa956f	2024-12-06T22:29:37.000Z	0	0x5fa4a49f14b2a720301a0e098e9a55c4c1e3ddeb651e29164f5900ffc52b6c61	2
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x63dfa7c09dc2ff4030d6b8dc2ce6262bf898c8a4	false	101434468193298139114	39	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	282021679	244139865180760912855637650	0x96bfc0a3358aebbc74ba431a8b1e4023719e195c	2024-12-06T18:11:06.000Z	5936	0xa745f351c2315adadb68fd8ee77ab8c0dd36eeb663aa8f9768f73e46c721e16c	2

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

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

Columns

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

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1052631578947368	0x6804060adc36e9ba46df0c35adca7d73e3fb4a41	32	526315789474	96635329	0x6804060adc36e9ba46df0c35adca7d73e3fb4a41	2023-06-01T09:12:18.000Z	0xc9fa412e426088f816b71c0eae7b9895cd43817c108f5b9ef622dcb9f9945a74
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1074691026329930	0x6804060adc36e9ba46df0c35adca7d73e3fb4a41	34	537345513165	96651123	0x6804060adc36e9ba46df0c35adca7d73e3fb4a41	2023-06-01T10:18:08.000Z	0x92c1bc9dcb03593983bbe665c336c27f72f8a9733d1871223854ca7f7398f95d
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	0x5979d7b546e38e414f7e9822514be443a4800529	6829220146992	0x80af24d8edc2da28627966b0982862f613c80e86	28	3414610073	96746527	0x80af24d8edc2da28627966b0982862f613c80e86	2023-06-01T16:56:56.000Z	0x4b40ba656418e5a69bc4b8968e1afb63bd50c60e3de6c986dace944ba2e21c25

Example Query

Query with partition filter

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

LendingPool_LiquidationCall_event

Liquidation events from Aave-compatible lending protocols when undercollateralized positions are closed. Records liquidator, borrower, debt repaid, collateral seized, and asset addresses for tracking protocol risk and liquidation bot activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAsset`	`STRING`	Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtToCover`	`STRING`	Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
`in_liquidatedCollateralAmount`	`STRING`	Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveAToken`	`BOOL`	Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1bdd5257a67e0e18ada502aa8dfaf59c14309ce9	false	22	177069266	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x0f8ba26d98f2af09bf99d4f8e84be4afb02c497a	190417283	2024-02-03T15:03:30.000Z	false	0xf8bf24462aa6a807930a02c9ed22641ced0e621a876ea12c9744a4bd49a5a5e1	0x912ce59144191c1204e64559fe8253a0e49e6548	116854885362320152500
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1bdd5257a67e0e18ada502aa8dfaf59c14309ce9	false	49	177057162	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x0f8ba26d98f2af09bf99d4f8e84be4afb02c497a	220718659	2024-02-03T14:11:28.000Z	false	0x2619eb2f19cf9a6cdb3a3b3eda4fbf56fc580c2c8de7bf97a89af6be740eeea1	0x912ce59144191c1204e64559fe8253a0e49e6548	135039063727763128603
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1bdd5257a67e0e18ada502aa8dfaf59c14309ce9	false	14	176982934	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x9999b50bb6fc4ac42ddc5f10518e406549ebc3a0	441421665	2024-02-03T08:50:16.000Z	false	0xc257a87a46352beb6f1590b8f3fd6deb5696d77588c86afde6074237bbc2e885	0x912ce59144191c1204e64559fe8253a0e49e6548	266150214666722680143

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

Aave V3 protocol event recording interest-bearing token mints to the treasury reserve. Contains reserve address, amount minted, and transaction identifiers for tracking protocol fee accumulation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	35	0x5979d7b546e38e414f7e9822514be443a4800529	276350499	2024-11-20T06:05:32.000Z	517187092851030	0x1aed3d52dbeeb7d8985560c86cd74d93ec73b22b61705cd3ca84cd214877426a
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	38	0xec70dcb4a1efa46b8f2d97c310c9c4790ba5ffa8	276350499	2024-11-20T06:05:32.000Z	320732984755567	0x1aed3d52dbeeb7d8985560c86cd74d93ec73b22b61705cd3ca84cd214877426a
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	53	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	276350499	2024-11-20T06:05:32.000Z	49529627323105748	0x1aed3d52dbeeb7d8985560c86cd74d93ec73b22b61705cd3ca84cd214877426a

Example Query

Query with partition filter

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

LendingPool_Repay_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1a6182d45e31cb09ffbab66b5a5d09ea379235d3	false	17110175084313	4	0x1a6182d45e31cb09ffbab66b5a5d09ea379235d3	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	26411233	false	2022-09-24T14:59:10.000Z	0x73f0057ff5428a4594f7778b45844573a2255a3281eed4dce06fff018950ad71
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1c05decb151a459e8b045a93f472d1b238204094	false	10000708357575627119	4	0x1c05decb151a459e8b045a93f472d1b238204094	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	26306485	false	2022-09-24T03:36:07.000Z	0x58f94f760c8e48d74696dd16c86d5796dc0c8941b39185d7f1b9c18729273819
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x1c54c331ac240cbc5e8ab94937ce42729fc85d75	false	200982466945638087	4	0x1c54c331ac240cbc5e8ab94937ce42729fc85d75	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	26331011	false	2022-09-24T06:29:59.000Z	0x2bc1d18c7f7da60b5869874b71eca8313b4f90b49f6206d53fa1140fcd469e9a

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

Aave V2/V3 protocol events emitted when lending pool reserve parameters are updated, including liquidity and borrow indices, interest rates for stable and variable borrowing. Used for tracking interest accrual and reserve state changes across lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityRate`	`STRING`	Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers.
`in_stableBorrowRate`	`STRING`	Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan.
`in_variableBorrowRate`	`STRING`	Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan.
`in_liquidityIndex`	`STRING`	Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve’s inception, stored as a numeric string.
`in_variableBorrowIndex`	`STRING`	Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve’s inception, stored as a numeric string.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_stableBorrowRate	in_variableBorrowRate	in_variableBorrowIndex
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	19	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	18483723	2022-07-25T00:25:00.000Z	790668943629437571458353	0xa57a412f10379faac449f88dc73725dc98a7e29bd03a2d83c10e0a849a889c3a	1000374550735451380298983608	90000000000000000000000000	11690116755751957273597338	1003952662148356625009149137
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	37	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	18496430	2022-07-25T03:41:39.000Z	822626611876604983009487	0x531a8d6ad138a2f6f06fb7fb45f28671a9276db33538375b31c1cecb7dd31f68	1000374896676565358435979100	90000000000000000000000000	11924025216401905763871751	1003957102359117651346141821
0x794a61358d6845594f94dc1db02a252b5b4814ad	false	33	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	18513940	2022-07-25T09:02:05.000Z	918521185614333262579665	0x145aa0b9c2eab75cdafab970caf237c9e604f9a5cce8f2fa489a52afb27eb411	1000375666651926637803537999	90000000000000000000000000	12599870956913503872304084	1003964612336029218206857206

Example Query

Query with partition filter

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

LendingPool_Supply_event

Aave V3 Supply events emitted when users deposit assets into lending pools. Records depositor address, reserve token, deposit amount, beneficiary, and optional referral code for tracking liquidity provision across DeFi lending protocols.

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x794a61358d6845594f94dc1db02a252b5b4814ad	0xab7eed4971b3637c3df434b34a5a19fcd947e971	false	114706207760915360000	5	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	163407033	0xab7eed4971b3637c3df434b34a5a19fcd947e971	2023-12-24T22:55:56.000Z	0x85eff74f40502767f2ea572a75e4dfc8d61c01947992e91ce5d88c5c4a59331d
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x01c020c8f90aebc4d8fcac2ea1acec596da4e01b	false	7545354	11	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	163224881	0x01c020c8f90aebc4d8fcac2ea1acec596da4e01b	2023-12-24T09:42:11.000Z	0x08aaf3314bf62f9085906d97f5ec16f21aacbbfa2c97422df3c3267d0a5637f6
0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0246b0a279dd8466ecba9b3b0af5f51076763e09	false	4000000	7	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	163333750	0x0246b0a279dd8466ecba9b3b0af5f51076763e09	2023-12-24T17:24:01.000Z	0x4ccc057ab650a2cd74818c61ee8c335519d65fb61896d1639be0b3d2290fe02f

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

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

Columns

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

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x0246b0a279dd8466ecba9b3b0af5f51076763e09	0x794a61358d6845594f94dc1db02a252b5b4814ad	0x0246b0a279dd8466ecba9b3b0af5f51076763e09	false	2002314320313105457803	9	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	165331306	2023-12-30T15:30:03.000Z	0x952f68549395b021a7e0588ac71db4c51ef6f390f8dcaee47f599cbc2dfadff7
0xd602069b6b743c9b4ec833ae96acb06d777d2717	0x794a61358d6845594f94dc1db02a252b5b4814ad	0xd602069b6b743c9b4ec833ae96acb06d777d2717	false	701692927618533428734	27	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	165260793	2023-12-30T10:35:12.000Z	0xecf24ceb89bed492c51b9155476e51f25cfa12f58fc00555857afa4cfe024b1f
0x2277a5694a90fb4c0522ea3e661bf5fc0e4f46b3	0x794a61358d6845594f94dc1db02a252b5b4814ad	0xf59d43a9bacb8bfa95fb2a013cd163c84c2b2091	false	2701773373850672356	30	0x17fc002b466eec40dae837fc4be5c67993ddbd6f	165429602	2023-12-30T22:36:23.000Z	0x38677864cbaba6d9790973ea3a8fde91841f74b9446f8a967d943d0ba6ce50c0

Example Query

Query with partition filter

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

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

No description available.

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in lending markets.

Columns

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

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
7600	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	7	199697258	2024-04-10T22:00:05.000Z	0xb91c08b19b5c0bbbfe1218bcdf9f86d90a44a185bc2f9b1570a5b2cbd1340bb9	10500	7900
7600	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xaf88d065e77c8cc2239327c5edb3a432268e5831	9	199697258	2024-04-10T22:00:05.000Z	0xb91c08b19b5c0bbbfe1218bcdf9f86d90a44a185bc2f9b1570a5b2cbd1340bb9	10500	7900
7600	0x8145edddf43f50276641b55bd3ad95944510021e	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	6	199697258	2024-04-10T22:00:05.000Z	0xb91c08b19b5c0bbbfe1218bcdf9f86d90a44a185bc2f9b1570a5b2cbd1340bb9	10500	7900

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumToProtocol	in_oldFlashloanPremiumToProtocol
0x8145edddf43f50276641b55bd3ad95944510021e	false	2	353846925	2025-07-03T14:45:05.000Z	0x192900e1597722899cb45fc302b8d06739d9de3bbfba0002d7848dde1c240579	10000	4
0x8145edddf43f50276641b55bd3ad95944510021e	false	0	7742450	2022-03-11T15:02:08.000Z	0x6a6f1e38f3c55dd4da2b6536ad313c1c6e11c1a6f6d55d1642cc49ee2c90bc9e	4	0
0x8145edddf43f50276641b55bd3ad95944510021e	false	3	89267099	2023-05-10T13:10:49.000Z	0x28196e923a50ce9ea72908d8a5c02818b4303adb3e26d37465124fc1d5e97e3e	4	0

Example Query

Query with partition filter

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

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newFlashloanPremiumTotal	in_oldFlashloanPremiumTotal
0x8145edddf43f50276641b55bd3ad95944510021e	false	0	7742446	2022-03-11T15:02:08.000Z	0xea0e1798dd709afcd1f825566836ab6fe0d19072c01c5328a7a404b92eb2d91d	5	9
0x8145edddf43f50276641b55bd3ad95944510021e	false	2	89267099	2023-05-10T13:10:49.000Z	0x28196e923a50ce9ea72908d8a5c02818b4303adb3e26d37465124fc1d5e97e3e	5	9

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

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

Columns

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

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	1000	15	203072170	2024-04-20T19:32:53.000Z	0x8bb7251e9dde6b5605effdf3445ceeee34ac8d274da8bf819f0d32255ba7df6c
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x2416092f143378750bb29b79ed961ab195cceea5	1000	24	295743569	2025-01-15T16:59:33.000Z	0x88b14ce8a9b08a6ef0be2d14d00d0302f392612d463ec16aa3a9fda6b64198ad
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xaf88d065e77c8cc2239327c5edb3a432268e5831	1000	21	105740626	2023-06-28T10:09:48.000Z	0x904364beeab39ba08a36254891516f94de49af3e0c7272c516a90a678a2a8cc0

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

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

Columns

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

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor	in_oldReserveFactor
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x93b346b6bc2548da6a1e7d98e9a421b42541425b	6	360477965	2025-07-22T19:26:41.000Z	0x02133b16eacaba2e68300b0f57995b83f0c534d7cd22d459e00cb5934c6c316b	5000	2000
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x4186bfc76e2e237523cbc30fd220fe055156b41f	31	322437335	2025-04-03T08:34:06.000Z	0x6a50945c6df8309431fb0b136dc0bb12f1133465473cfcbfe232ed6b4b47eee2	2000	0
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x912ce59144191c1204e64559fe8253a0e49e6548	12	113260138	2023-07-20T21:28:09.000Z	0x793ecdf0b56b1b94ec81a6c16466ad9ae2cf9b16eb9baebbb903109d0a79d2d5	2000	0

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x2416092f143378750bb29b79ed961ab195cceea5	0xea1132120ddcdda2f119e99fa7a27a0d036f7ac9	13	295743569	2025-01-15T16:59:33.000Z	0x88b14ce8a9b08a6ef0be2d14d00d0302f392612d463ec16aa3a9fda6b64198ad	0x0000000000000000000000000000000000000000	0x1ffd28689da7d0148ff0fcb669e9f9f0fc13a219	0x429f16dba3b9e1900087cbaa7b50d38bc60fb73f
0x8145edddf43f50276641b55bd3ad95944510021e	false	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x724dc807b04555b71ed48a6896b6f41593b8c637	11	105740626	2023-06-28T10:09:48.000Z	0x904364beeab39ba08a36254891516f94de49af3e0c7272c516a90a678a2a8cc0	0xdc1fad70953bb3918592b6fcc374fe05f5811b6a	0xf611aeb5013fd2c0511c9cd55c7dc5c1140741a6	0xf6733b9842883bfe0e0a940ea2f572676af31bde
0x8145edddf43f50276641b55bd3ad95944510021e	false	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	0x8437d7c167dfb82ed4cb79cd44b7a32a1dd95c77	5	203072170	2024-04-20T19:32:53.000Z	0x8bb7251e9dde6b5605effdf3445ceeee34ac8d274da8bf819f0d32255ba7df6c	0x40b4baecc69b882e8804f9286b12228c27f8c9bf	0x3ca5fa07689f266e907439afd1fbb59c44fe12f6	0x0fc12ad84210695de8c0d5d8b6f720c37ceab02f

Example Query

Query with partition filter

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`in_executionTime`	`STRING`	Unix timestamp when the action was executed. Integer value representing seconds since epoch.
`in_withDelegatecall`	`BOOL`	Boolean flag indicating whether the contract call was executed using delegatecall opcode instead of a standard call.
`in_resultData`	`STRING`	Return data from the executed contract function call. Hex-encoded byte string containing the function’s output parameters.

Sample Data

address	in_data	removed	in_target	log_index	block_number	in_signature	in_resultData	block_timestamp	in_executionTime	transaction_hash	in_withDelegatecall
0xff1137243698caa18ee364cc966cf0e02a4e6327	0x	false	0xcd320ca435193b4a9b04d0a02c777b5e8902c9b4	24	194780846	execute()	0x	2024-03-27T14:51:18.000Z	1711551078	0x24923d42886dd5305877a03778a79a24039f41166c1b9da9429e35a2b3673369	true
0xff1137243698caa18ee364cc966cf0e02a4e6327	0x	false	0x868b4bc72f3ad129b3c5805b19ce2a18849bc1ae	7	194779349	execute()	0x	2024-03-27T14:45:01.000Z	1711550701	0x76a5cc2c78abb8823eb43e38ec1951d4b48e225e61e5407c18b1b9ca5077478d	true
0xff1137243698caa18ee364cc966cf0e02a4e6327	0x	false	0x0efc2a29c1f203a29dfdc3b8a723dd67d1d9a42d	47	295743569	execute()	0x	2025-01-15T16:59:33.000Z	1736960373	0x88b14ce8a9b08a6ef0be2d14d00d0302f392612d463ec16aa3a9fda6b64198ad	true

Example Query

Query with partition filter

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

StataToken_Deposit_event

Deposit events emitted by Aave V3 StataToken contracts recording asset conversions to yield-bearing shares. Contains sender address, asset owner, deposited asset amount, and received share amount for tracking StataToken minting activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x4ce13a79f45c1be00bdabd38b764ac28c082704e	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	2570939203130468789	0xba1333333333a1ba1108e8412f11850a5c319ba9	2462528830795317618	12	335819197	2025-05-12T06:09:48.000Z	0xc6ffaa3a4de08a220a0c3e19be5550f5a73c8fa25641a871895697323b5a19a5
0x4ce13a79f45c1be00bdabd38b764ac28c082704e	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	17999981410049658	0xba1333333333a1ba1108e8412f11850a5c319ba9	17241005338994874	12	335801005	2025-05-12T04:53:46.000Z	0xb88b176ff936e596d655ca957d7902619d50db8a6fecd8ea75fb4339765fbe4e
0x4ce13a79f45c1be00bdabd38b764ac28c082704e	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	19999999588965390	0xba1333333333a1ba1108e8412f11850a5c319ba9	19156282671872180	16	335966674	2025-05-12T16:25:30.000Z	0xae17569c1fc6977408e134ad153e98d39eb6131d79b3651db68acc0cd233b182

Example Query

Query with partition filter

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

StataToken_Initialized_event

Aave V3 Static A Token (StataToken) initialization events emitted when a new StataToken contract is deployed and initialized with its version parameter. Captures the deployment of yield-bearing wrapped aToken contracts that accrue interest through rebasing mechanisms.

Columns

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

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x4ff50c17df0d1b788d021acd85039810a1aa68a1	false	5	1	300629404	2025-01-29T21:49:36.000Z	0xf305ed861da2e939b350a95970925a092d41d3fabc4678c02858e8f9d8df76cc
0xd9e3ef2c12de90e3b03f7b7e3964956a71920d40	false	8	1	297503444	2025-01-20T19:43:12.000Z	0xcf75a9d2c0dd287dea9bbb21ebbee15f5c6af306a80a2bfb65e75611fc939e94
0xe6d5923281c89dc989d00817387292387552d5c1	false	63	1	297503444	2025-01-20T19:43:12.000Z	0xcf75a9d2c0dd287dea9bbb21ebbee15f5c6af306a80a2bfb65e75611fc939e94

Example Query

Query with partition filter

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

StataToken_Withdraw_event

Aave V3 static aToken (StataToken) withdrawal events recording conversions from yield-bearing shares back to underlying assets. Contains sender, owner, receiver addresses, asset amounts withdrawn, and corresponding share quantities burned in the protocol’s vault accounting system.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x4ce13a79f45c1be00bdabd38b764ac28c082704e	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	215154128090586267	0xba1333333333a1ba1108e8412f11850a5c319ba9	206411624927629577	73	0xba1333333333a1ba1108e8412f11850a5c319ba9	324548742	2025-04-09T11:46:41.000Z	0x500c44f3fd81acd14d6cc14217f565ec7f03bfd519fc8e3655e5320a68049946
0x4ce13a79f45c1be00bdabd38b764ac28c082704e	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	451899411588154731	0xba1333333333a1ba1108e8412f11850a5c319ba9	433537244207396133	95	0xba1333333333a1ba1108e8412f11850a5c319ba9	324546329	2025-04-09T11:36:40.000Z	0x10aad24c84fcea77b880b3e978127f2d97769d12d443cc1065d8d304b1a92ec8
0x4ce13a79f45c1be00bdabd38b764ac28c082704e	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	95792258678510225	0xba1333333333a1ba1108e8412f11850a5c319ba9	91902020100062975	129	0xba1333333333a1ba1108e8412f11850a5c319ba9	324407888	2025-04-09T01:59:34.000Z	0x67f2c296ff4f1ebba2f5a4789a3011189e243510c89aaab13679ee7a0ff73414

Example Query

Query with partition filter

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

StataTokenFactory_StataTokenCreated_event

Event log emitted when Aave V3’s StataTokenFactory contract creates a new static aToken (stata token) wrapper for an underlying asset. Links the newly deployed stata token address with its corresponding underlying asset address for tracking tokenized yield-bearing positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_stataToken`	`STRING`	Contract address of the newly created static aToken wrapper. Hex-encoded, 0x-prefixed, 42-character string.
`in_underlying`	`STRING`	Contract address of the underlying asset. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_stataToken	in_underlying	block_timestamp	transaction_hash
0xd85922fff51ba4130cec7c499db4ac3eb9981ead	false	11	297503444	0xd9e3ef2c12de90e3b03f7b7e3964956a71920d40	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	2025-01-20T19:43:12.000Z	0xcf75a9d2c0dd287dea9bbb21ebbee15f5c6af306a80a2bfb65e75611fc939e94
0xd85922fff51ba4130cec7c499db4ac3eb9981ead	false	36	297503444	0xa6d12574efb239fc1d2099732bd8b5dc6306897f	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	2025-01-20T19:43:12.000Z	0xcf75a9d2c0dd287dea9bbb21ebbee15f5c6af306a80a2bfb65e75611fc939e94
0xd85922fff51ba4130cec7c499db4ac3eb9981ead	false	24	297503444	0x7f6501d3b98ee91f9b9535e4b0ac710fb0f9e0bc	0xaf88d065e77c8cc2239327c5edb3a432268e5831	2025-01-20T19:43:12.000Z	0xcf75a9d2c0dd287dea9bbb21ebbee15f5c6af306a80a2bfb65e75611fc939e94

Example Query

Query with partition filter

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

SToken_Burn_event

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

Columns

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

Sample Data

address	in_from	removed	in_amount	log_index	block_number	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0x70effc565db6eef7b927610155602d31b670e802	0xfe96719aa7ba8fab02e9d3123c0c40c23945557c	false	123951561	2	10873697	2022-04-30T04:23:59.000Z	54293186744902075226729455	0x10745cce1233c91448c2c222df8469675d2ab6989a6c6a763e149bc70c8ef104	124111639	74012117240	160073
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0xf4cae903dc1698bb309c650685f69cd84b45bc3c	false	183461405	2	10903427	2022-04-30T12:19:59.000Z	56071965009958875013670003	0xc490acfff465ee8ca4c7dc3bcf9a67329e36f2e75f2c21323606a3e5debf8ff1	1604989402	322616949062	3975919
0x307ffe186f84a3bc2613d1ea417a5737d69a7007	0xd603a49886c9b500f96c0d798aed10068d73bf7c	false	50000000000	2	10923186	2022-04-30T17:06:19.000Z	56385651898592962001429118	0x41a689046a31bc825cd5d2dcfe8ece3aa031b906e1da281e9a56997c3eaa9ea7	50103608817	272170754158	103608817

Example Query

Query with partition filter

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

SToken_Mint_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_newRate	block_number	in_onBehalfOf	block_timestamp	in_avgStableRate	transaction_hash	in_currentBalance	in_newTotalSupply	in_balanceIncrease
0x70effc565db6eef7b927610155602d31b670e802	0x905f662694c355acc7c7aceff467716a529dc818	false	5054259136	1	54859122912561077985350940	8428784	0x905f662694c355acc7c7aceff467716a529dc818	2022-03-23T19:54:08.000Z	54490949859746672938311507	0x50a71aa86754e413fcd7841643d8742a2d103f1f687f333c10f0ab7d13a7150d	6716621944	22584095603	4538
0x70effc565db6eef7b927610155602d31b670e802	0x905f662694c355acc7c7aceff467716a529dc818	false	6716617406	1	54776309937585781255678686	8428534	0x905f662694c355acc7c7aceff467716a529dc818	2022-03-23T19:47:39.000Z	54353067046700936228833953	0x713086588f7c8e779ab8df7cf27d7d04f3107addcf16caadd1e1c65734cc9470	0	17529829252	0
0x70effc565db6eef7b927610155602d31b670e802	0xa314e002ef1a776fac6b3d251c6643bc9180764a	false	1000000000	1	54389042030128606000000000	8423531	0xa314e002ef1a776fac6b3d251c6643bc9180764a	2022-03-23T17:45:19.000Z	54090170082471524900671753	0x0a4bdd5ab193dec79251ce4d22e708a9b333d275c1e10247f90be8da5a42514a	0	10813075714	0

Example Query

Query with partition filter

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

VToken_Burn_event

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

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0xf611aeb5013fd2c0511c9cd55c7dc5c1140741a6	0xc53a1008802cea1e5b87f19c0b3df4033783f7a6	false	1002543354756899232923472936	58528247	0x0000000000000000000000000000000000000000	52	111184279	2023-07-14T16:47:25.000Z	0x2c6aa1bfe7234e0ba507940bccd2f85607f02c6ef6d5900c10640e8580fefed5	22
0xfccf3cabbe80101232d343252614b6a3ee81c989	0xbb9d86186ee173c7490536f3e64db16e3313f706	false	1030057293445728821887437084	199999566	0x0000000000000000000000000000000000000000	56	110947410	2023-07-14T00:11:57.000Z	0x2279b6faf085df5a5ff47894e5541c64ce85565b21bb3430373eaaab6b8dd364	434
0xfccf3cabbe80101232d343252614b6a3ee81c989	0x4d2564ab6e91a2b667ad7b5747918e5ef3dc327f	false	1030058657701011806997080861	6744607938	0x0000000000000000000000000000000000000000	65	110952465	2023-07-14T00:33:57.000Z	0x3d582588cbf42e466ed27d1c19bb302bdcab0e8079f43d7e6bcb926b008392dc	3340089

Example Query

Query with partition filter

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

VToken_Mint_event

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

Columns

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

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0xce186f6cccb0c955445bb9d10c59cae488fea559	false	1012540113181758806951551859	49982719036220500	0x9e8e9d6b0d24216f59043db68bdda1620892f549	23	189033854	0x2b4cbfd8ca8df67e87d83ad7f5cd6a96ad14ef5b	2024-03-10T17:12:19.000Z	0xd886f61a249ade8b5ce8a64cd8796f2ecefeeaefaf2d0db613d99c050a671bd1	3508930161195
0xa8669021776bc142dfca87c21b4a52595bcbb40a	false	1051002702721644808942287659	3378405425140113520219	0x9e8e9d6b0d24216f59043db68bdda1620892f549	22	189032784	0xc27e87cfe1fd2ed6f43dfffbb9e9e46428497a24	2024-03-10T17:07:08.000Z	0x9017dda273a934109a2063d88b076f83ff9252c720a1ddd992c14d18b85522cb	20588755670470566
0xa8669021776bc142dfca87c21b4a52595bcbb40a	false	1051002125369633886538283022	10578698757628745866765	0xc27e87cfe1fd2ed6f43dfffbb9e9e46428497a24	4	189032507	0xc27e87cfe1fd2ed6f43dfffbb9e9e46428497a24	2024-03-10T17:05:54.000Z	0x1eb48c9c4cd2639cd658ea4fe221d5f03aea65302a5b919b570ac3db725799db	269198757628745866765

Example Query

Query with partition filter

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

WrappedTokenGatewayV3_withdrawETH_function

Aave V3 WrappedTokenGatewayV3 withdrawETH function call records containing withdrawal amounts, pool addresses, and recipient addresses. Used for tracking ETH unwrapping and withdrawal transactions from Aave lending pools across multiple chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`STRING`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_anon0`	`STRING`	Contract address of the lending pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_to	status	gas_used	in_anon0	in_amount	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
515980	0x78583242f3912f6cc94897de774cfe30701f106f	true	348409	0x794a61358d6845594f94dc1db02a252b5b4814ad	1000000000000000	0x80500d20	0x5283beced7adf6d003225c13896e536f2d4264ff	334746292	0x78583242f3912f6cc94897de774cfe30701f106f	2025-05-09T03:17:05.000Z	0x4ed1bb1234b1a6377e94aaa84e7bcfeef9652ebd8cdbdb602cd2c98864c10d15
700241	0x08baa969b1ee930d775518a609514fe0b5a6339d	true	421635	0x794a61358d6845594f94dc1db02a252b5b4814ad	1000000000000000	0x80500d20	0x5283beced7adf6d003225c13896e536f2d4264ff	334908765	0x08baa969b1ee930d775518a609514fe0b5a6339d	2025-05-09T14:35:42.000Z	0xb296ac51facae10fcd43b745b6cab595008c4565b48c1c3f6e44b6591df5fb20
595450	0xc089a3d1c6c739a5bfcf6a59b91a7e418bedd74e	true	351709	0x794a61358d6845594f94dc1db02a252b5b4814ad	1000000000000000	0x80500d20	0x5283beced7adf6d003225c13896e536f2d4264ff	334922911	0xc089a3d1c6c739a5bfcf6a59b91a7e418bedd74e	2025-05-09T15:34:42.000Z	0x593c445ef5d91788e414fa9c47fbd6ec31fd31b0e18691cad15c7cc226bef07b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

​LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​ShortExecutor_ExecutedAction_event

​StataToken_Deposit_event

​StataToken_Initialized_event

​StataToken_Withdraw_event

​StataTokenFactory_StataTokenCreated_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV3_withdrawETH_function

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

ShortExecutor_ExecutedAction_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function