aave_v3_sonic

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
0x47fffa06eeeef596d46cf7d58c3856a751ea68ed	0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	0xcf3fe53a837b780369e4ac191cbdc42d05b39bc8	false	1000604696957390923158915302	878170011	12	27101239	2025-05-16T00:01:01.000Z	0x0eb1fb59cd05f9cda5b74977a4083064389849f1c1bc84a50f00981c288c6f7f
0x41d920dae2a39889c7d76496ef871d745672e09e	0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	0x90de6243cbe4f54efbda03b10badf773d378e962	false	1000604698966026917044358030	11232208794	13	27101475	2025-05-16T00:02:23.000Z	0x1abd25383ec9c0ddf73f7d71be9d99524c1d09c022d55b06e620d6b286527300
0x41d920dae2a39889c7d76496ef871d745672e09e	0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	0x90de6243cbe4f54efbda03b10badf773d378e962	false	1000604701587189325092320814	11232230018	11	27101785	2025-05-16T00:04:10.000Z	0x759e792d8065217c01b71687af5aeb72a2c82572772eba683ff5037a268890e4

Example Query

Query with partition filter

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

AToken_Burn_event

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

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0xeaa74d7f42267eb907092af4bc700f667eed0b8b	0x019425b418ff167d62f23324a6fa5fa0023760de	false	1000000068550713984005042152	12184000000000000000001	0x019425b418ff167d62f23324a6fa5fa0023760de	2	42535686	2025-08-11T16:13:29.000Z	0x1c17c4d7210799d4c6d163f328bc1ebd1eca56899c72788a9b0b3be818fb0e53	0
0xeaa74d7f42267eb907092af4bc700f667eed0b8b	0x019425b418ff167d62f23324a6fa5fa0023760de	false	1000000068550713984005042152	2800000000000000000000	0x019425b418ff167d62f23324a6fa5fa0023760de	2	42541798	2025-08-11T17:13:34.000Z	0x9e728f695dbc468c793081de995f773cd087f3ec9ffd7293a123bed2053b9b18	0
0x6c5e14a212c1c3e4baf6f871ac9b1a969918c131	0x019425b418ff167d62f23324a6fa5fa0023760de	false	1004463454215414054438492536	19999974815862233652118	0x019425b418ff167d62f23324a6fa5fa0023760de	2	42505960	2025-08-11T11:55:08.000Z	0x441a3353dd09d98b7d771ddce8ec8d9951ed2888751025f036da0f82118fe698	25184137766347883

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x	9	0x1ab55bbdd5df0782bbcf73553af93bc6b29a286b	41989106	Aave Sonic USDC	2025-08-07T10:21:38.000Z	aSonUSDC	0x38c7bc5ad3e263b8c31778430f33d2a1f06b9db93554771d26025296cea43d73	6	0x29219dd400f2bf60e5a23d13be72b486d4038894	0x24bd6e9ca54f1737467def82dca9702925b3aa59
0xeaa74d7f42267eb907092af4bc700f667eed0b8b	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x	21	0x1ab55bbdd5df0782bbcf73553af93bc6b29a286b	41989106	Aave Sonic stS	2025-08-07T10:21:38.000Z	aSonstS	0x38c7bc5ad3e263b8c31778430f33d2a1f06b9db93554771d26025296cea43d73	18	0xe5da20f15420ad15de0fa650600afc998bbe3955	0x24bd6e9ca54f1737467def82dca9702925b3aa59
0xe18ab82c81e7eecff32b8a82b1b7d2d23f1ece96	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x	3	0x1ab55bbdd5df0782bbcf73553af93bc6b29a286b	41989106	Aave Sonic WETH	2025-08-07T10:21:38.000Z	aSonWETH	0x38c7bc5ad3e263b8c31778430f33d2a1f06b9db93554771d26025296cea43d73	18	0x50c42deacd8fc9773493ed674b675be577f2634b	0x24bd6e9ca54f1737467def82dca9702925b3aa59

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	false	1000555317543549027280668660	109980	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	19	21222146	0x83fe9748fac353106c5c988b93ce229f895e0b02	2025-04-20T18:55:16.000Z	0xd9ad7357e019e5e7ef402574606669a22d5fc67572dd08bdebab321cf4ff7c67	109980
0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	false	1000556105555255175388427170	134	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	22	21247498	0x769162779191b0a513d0d08db6135a144906c39e	2025-04-20T21:54:56.000Z	0xd301ef627eebd3c2ccfa80d8837db027233d94d2e4e896e1380e6268641104d9	134
0x578ee1ca3a8e1b54554da1bf7c583506c4cd11c6	false	1000555695680011095192733325	265	0x000000000000c9b3e2c3ec88b1b4c0cd853f4321	4	21234662	0x769162779191b0a513d0d08db6135a144906c39e	2025-04-20T20:21:31.000Z	0x957d0549a2d130294c652d20e7b8a9ac3dd70058d13adf4c39f6ae6f6b07700a	265

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LendingPool_Borrow_event

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

Columns

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

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	1336720632847966539289	7	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	14806678	41404721063399540573122747	0x95333df86727053ba59db90e8005b5fbacbb5208	2025-03-20T09:39:20.000Z	0xc485ec1266d8eaaa3a366f1a268448046d436ccdefe2a3a5262f9bd2204773c2	2
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	2600000000000000000000	5	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	14771200	41447723347242324038114740	0x1b648ade1ef219c87987cd60eba069a7faf1621f	2025-03-20T04:58:41.000Z	0x6320286717f4c3928448dfee75c76b6ef67be485055fafc9e3000c381981fe0d	2
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	100000000000000000000	5	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	14855735	24715632345072159672585047	0xad036a7e58dfa18a6511e85d29b0341e16bcbd9b	2025-03-20T15:22:36.000Z	0x7e90e4897fc60dc1369d560a88fa05ffb5615da4115c97fb9f861168dc0e0171	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	500000000000000	0x5fb7e07deb733d2d6eb804316b1eca1e436f5f84	38	250000000000	36630483	0x5fb7e07deb733d2d6eb804316b1eca1e436f5f84	2025-06-30T20:22:05.000Z	0x33ac14f5ec4057b9d2513ceedd0ea8cc557c7ecf2fe356a172f659588a8791a3
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	13444127249904260992	0x91fa0194890de278bd5fae713c8c8345c5282783	14	6722063624952130	36548561	0x91fa0194890de278bd5fae713c8c8345c5282783	2025-06-30T06:52:33.000Z	0x5c8cbc7785922abc3dd72579cbbe7a32c8bec9fa09f550ff62b14e4daab8f2fc
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	6865602802460436443885	0x91fa0194890de278bd5fae713c8c8345c5282783	42	3432801401230218222	36592076	0x91fa0194890de278bd5fae713c8c8345c5282783	2025-06-30T14:07:05.000Z	0xf2889b05eb884f8dc29e95315891ea8beab4e163b840a5061f93473a398a6170

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x943840e5243259e4d482968f28c7bef10bc5b9da	false	13	13906565	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	0x678cd6e3485f420e92229180b151309ac05446ad	250019397636944631	2025-03-15T17:01:07.000Z	false	0x91a0822b6f73aed15bc9c40d9e767688291a1abea60105b798c149551f781055	0x50c42deacd8fc9773493ed674b675be577f2634b	74972710528487
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0xddcd6080e56b183eb11cb21b84714b51c4b75583	false	65	17775645	0x29219dd400f2bf60e5a23d13be72b486d4038894	0x6b68fc283c7e00ffee284f6fe2f0774e7d0c7a61	57	2025-04-02T22:12:59.000Z	false	0xf7e68ec7b923dfe00892fbd7339ac08a4c0f3c4b3e180230d0dd94241c83d13a	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	131415883998672
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0xb7752ccf529cbbefde7e2ae78ff2c36d18dd6496	false	14	17775648	0x29219dd400f2bf60e5a23d13be72b486d4038894	0x6b68fc283c7e00ffee284f6fe2f0774e7d0c7a61	394	2025-04-02T22:13:00.000Z	false	0x0480a0d919bc5016861b3e2e9456086a9bac3f1771051ec2e666ead50709268e	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	908383478868016

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	5	0x29219dd400f2bf60e5a23d13be72b486d4038894	45447526	2025-09-02T06:04:47.000Z	331435763	0x93e2bbe5972538759a6f61263f4df77a40b8fb16c8e506b70011a13f3ffb6695
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	11	0xe5da20f15420ad15de0fa650600afc998bbe3955	45447526	2025-09-02T06:04:47.000Z	1135373982347124448	0x93e2bbe5972538759a6f61263f4df77a40b8fb16c8e506b70011a13f3ffb6695
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	2	0x50c42deacd8fc9773493ed674b675be577f2634b	45447526	2025-09-02T06:04:47.000Z	164769811111555	0x93e2bbe5972538759a6f61263f4df77a40b8fb16c8e506b70011a13f3ffb6695

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	false	60000000000000000000000	4	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	13188438	false	2025-03-12T05:42:00.000Z	0xa58fcdb720745f8e93c9a183f2e5043e911bc13bbbf2e4e21f7bf9a27904cf23
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	false	60000000000000000000000	4	0x00005ff7b4e62b6b868d36809f8a30c85a6d0000	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	13188645	false	2025-03-12T05:43:37.000Z	0x9bd281b2f1845e672093fedd11c6c720acd324a4599e064ef1cb32a7723a8a70
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x03adfaa573ac1a9b19d2b8f79a5aaffb9c2a0532	false	9950000000000001	4	0x03adfaa573ac1a9b19d2b8f79a5aaffb9c2a0532	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	13274253	false	2025-03-12T15:44:59.000Z	0xa5d8211a167b9806b527e1919d6cbaddc75e4148dccb8bb8a62ba759386babc2

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

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

Columns

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

Sample Data

address	removed	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_variableBorrowRate	in_variableBorrowIndex
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	21139132	2025-04-20T06:41:58.000Z	10156553931362043523500576	0x2e1d31bdedaa3b72aa3434635d39961d260e476d8a4bab520aec1ff6c4d1d3b0	1001271202785141087236725981	43112825842719793860301584	1004024298691065224328104790
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	21127005	2025-04-20T04:29:52.000Z	9871753342451167441130866	0x9fa111fcc7c9e5656ec7968a6a0cc54be0ff36d693e13954fefcd337ccf27042	1001268726329178391673234730	42504063134390337872962516	1004013589983976505756759930
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	21172745	2025-04-20T11:51:02.000Z	10306958050003416541199970	0xf3ffcf88663067f469f399fafb4dfb14c5846a14d5293bc5912a5baecbe22992	1001277304500447956013523128	43430872531984827005671931	1004049807549657367279869754

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	20000000000000000000	12	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	19822924	0xd0be6274e8a6be25a3e1982cf957595fcb67a4ef	2025-04-12T16:15:42.000Z	0x460c957a36f4164b3d8ce9b68411e1b28dbe55bc071e2ce66603600496a08c8a
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	1800000000000000000000	7	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	19742113	0xe3b20f2cca92d5d9aac068a3ee11a91bc8e0e1a9	2025-04-12T07:31:24.000Z	0xe239b8c2952ea127c78b2d0cec91d2db4b089a08f76948977c02e466cd2aa208
0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	15000000000000000000	7	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	19883328	0xb81b8e6b9688db65771512c347f2a36405889dee	2025-04-12T23:42:56.000Z	0x2edb3f217734fa57b7d17cc70cf01dd054f9f2aa966edcdc4c88a50f83a24585

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x00e046a6f4676fd753cab716d9a9b05c2b4a444f	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x00e046a6f4676fd753cab716d9a9b05c2b4a444f	false	330000000	37	0x29219dd400f2bf60e5a23d13be72b486d4038894	17972787	2025-04-03T19:37:53.000Z	0x8aac2e8ac8507ba8a71c9005a366b2c8065e8f3c59e050d513acf2bf69df70a5
0x0258da40e011acb8e0f6308d6dda4de363c9b604	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0xc4a9d8b486f388cc0e4168d2904277e8c8372fa3	false	19939	59	0x29219dd400f2bf60e5a23d13be72b486d4038894	17890433	2025-04-03T11:18:23.000Z	0x2679e792f01dbeb418708f18a4fbfcc00c796948be8dad6e77d32880d40dd940
0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	false	4220392677838228430	38	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	17927375	2025-04-03T14:56:53.000Z	0x8e4377d7b6e9cdb61d4d04f08e4b1142a92dc34f9a347e4ce27d3a5a830487bf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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_sonic.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
6600	0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0xe5da20f15420ad15de0fa650600afc998bbe3955	15	23299658	2025-04-30T13:51:39.000Z	0xe8fc08b9b7f6b8a6296812aa98f462374d517abbdc992ac7717e346e7ea756db	11000	6800
6800	0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	78	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	11000	7000
8000	0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x50c42deacd8fc9773493ed674b675be577f2634b	70	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	10600	8300

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	1	37012367	2025-07-03T14:51:37.000Z	0x30ba03b72745dde770fbff1e945dc7c51c71e2053b1b4f544f6d25107398098b	10000	4
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	15	7986598	2025-02-15T11:47:26.000Z	0x841161ef03d2ea0d9cf63159b1e9ad2760d9bf075084bdb8a8891efb50643f04	4	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	14	7986598	2025-02-15T11:47:26.000Z	0x841161ef03d2ea0d9cf63159b1e9ad2760d9bf075084bdb8a8891efb50643f04	5	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0xe5da20f15420ad15de0fa650600afc998bbe3955	1000	16	23299658	2025-04-30T13:51:39.000Z	0xe8fc08b9b7f6b8a6296812aa98f462374d517abbdc992ac7717e346e7ea756db
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x29219dd400f2bf60e5a23d13be72b486d4038894	1000	75	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	1000	79	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x50c42deacd8fc9773493ed674b675be577f2634b	55	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	1500
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	67	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	1500
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x29219dd400f2bf60e5a23d13be72b486d4038894	61	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0xe5da20f15420ad15de0fa650600afc998bbe3955	0xeaa74d7f42267eb907092af4bc700f667eed0b8b	5	23299658	2025-04-30T13:51:39.000Z	0xe8fc08b9b7f6b8a6296812aa98f462374d517abbdc992ac7717e346e7ea756db	0x0000000000000000000000000000000000000000	0x333cfdcb6457c409e4f0c88f3806252bee5fe425	0xdff435bccf782f11187d3a4454d96702ed78e092
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	0x6c5e14a212c1c3e4baf6f871ac9b1a969918c131	44	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	0x0000000000000000000000000000000000000000	0xf6089b790fbf8f4812a79a31cfabeb00b06ba7bd	0xdff435bccf782f11187d3a4454d96702ed78e092
0x50c70feb95abc1a92fc30b9acc41bd349e5de2f0	false	0x50c42deacd8fc9773493ed674b675be577f2634b	0xe18ab82c81e7eecff32b8a82b1b7d2d23f1ece96	34	11455249	2025-03-03T18:56:22.000Z	0x3e6673f200c89200859739d305395d1d9deb3ea0df43b57555a3b9223c04bbdc	0x0000000000000000000000000000000000000000	0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	0xdff435bccf782f11187d3a4454d96702ed78e092

Example Query

Query with partition filter

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

StataToken_Deposit_event

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

Columns

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

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x6646248971427b80ce531bdd793e2eb859347e55	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	32476025	0xba1333333333a1ba1108e8412f11850a5c319ba9	32451214	161	34329681	2025-06-16T14:18:50.000Z	0x780747448d4d813eaf89ef4714820df3e2d5ac166273e5e91bf1f9c7685e73b3
0x6646248971427b80ce531bdd793e2eb859347e55	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	3169340828	0xba1333333333a1ba1108e8412f11850a5c319ba9	3166917590	230	34344356	2025-06-16T16:05:07.000Z	0x3bbd0bc9f5afac4ed753a0db3f55ba997b4c300079f2f93827a24a700dcab84f
0x6646248971427b80ce531bdd793e2eb859347e55	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	124125467	0xba1333333333a1ba1108e8412f11850a5c319ba9	124030762	112	34309471	2025-06-16T11:35:16.000Z	0x7c3ee8a0a229b05932b944587ea00b236a5ba6b39ea28d09c7077bcf0f4df09c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0xeb5e9b0ae5bb60274786c747a1a2a798c11271e0	false	16	1	12021337	2025-03-06T09:28:15.000Z	0xc21b8d7d61385a2fff9cc7b09106cff54cbc783c7149bad7ad433716cbf1497e
0x18b7b8695165290f2767bc63c36d3dfea4c0f9bb	false	9	1	12021337	2025-03-06T09:28:15.000Z	0xc21b8d7d61385a2fff9cc7b09106cff54cbc783c7149bad7ad433716cbf1497e
0x6646248971427b80ce531bdd793e2eb859347e55	false	2	1	12021337	2025-03-06T09:28:15.000Z	0xc21b8d7d61385a2fff9cc7b09106cff54cbc783c7149bad7ad433716cbf1497e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x6646248971427b80ce531bdd793e2eb859347e55	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	67605027	0xba1333333333a1ba1108e8412f11850a5c319ba9	67505297	73	0xba1333333333a1ba1108e8412f11850a5c319ba9	40979532	2025-07-31T04:25:52.000Z	0x15eeb6d6595049d7f2b72323f122994dc5c9cc9f1820fe7baf417e6bbd6f115d
0x6646248971427b80ce531bdd793e2eb859347e55	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	2590539740	0xba1333333333a1ba1108e8412f11850a5c319ba9	2586683724	8	0xba1333333333a1ba1108e8412f11850a5c319ba9	41027152	2025-07-31T12:06:52.000Z	0x733e0ce8f605212d63ce0c125e6dedbcbd6e52f54dcd3427181bcf6804ac58b0
0x6646248971427b80ce531bdd793e2eb859347e55	false	0xba1333333333a1ba1108e8412f11850a5c319ba9	832239	0xba1333333333a1ba1108e8412f11850a5c319ba9	830991	32	0xba1333333333a1ba1108e8412f11850a5c319ba9	41066251	2025-07-31T17:26:33.000Z	0x1c7081540167dcdec26d29eeb702c3e1241b21e1f01eb3772958d60dcb3d924e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0xfeeb6fe430b7523fef2a38327241ee7153779535	false	20	12021337	0xeb5e9b0ae5bb60274786c747a1a2a798c11271e0	0x50c42deacd8fc9773493ed674b675be577f2634b	2025-03-06T09:28:15.000Z	0xc21b8d7d61385a2fff9cc7b09106cff54cbc783c7149bad7ad433716cbf1497e
0xfeeb6fe430b7523fef2a38327241ee7153779535	false	6	12021337	0x6646248971427b80ce531bdd793e2eb859347e55	0x29219dd400f2bf60e5a23d13be72b486d4038894	2025-03-06T09:28:15.000Z	0xc21b8d7d61385a2fff9cc7b09106cff54cbc783c7149bad7ad433716cbf1497e
0xfeeb6fe430b7523fef2a38327241ee7153779535	false	13	12021337	0x18b7b8695165290f2767bc63c36d3dfea4c0f9bb	0x039e2fb66102314ce7b64ce5ce3e5183bc94ad38	2025-03-06T09:28:15.000Z	0xc21b8d7d61385a2fff9cc7b09106cff54cbc783c7149bad7ad433716cbf1497e

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	0x0c3f9dbf394c33449895c9c3011a7de087bba603	false	1003264403939623192415594419	2505508280589758608	0x0000000000000000000000000000000000000000	1	23024286	2025-04-29T07:07:01.000Z	0xce68a654bc691b59a3996756c0b185fee2b6b10788033c589e4746af358950cb	2689272830999516
0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	0x184d00210605061ffa9d3f6045804d4976eee5d2	false	1003285019726309685006451315	99737298766712336	0x0000000000000000000000000000000000000000	4	23105315	2025-04-29T15:56:16.000Z	0x57b528869fac30397ef7a259be564e153b0b65bb619f168eef95a76d36b46821	262701233287664
0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	0x27bc5aecfc7adb820c37cb1ef4fc0833c9faac5d	false	1003290710552138556553753760	2892478749700576	0x0000000000000000000000000000000000000000	11	23127788	2025-04-29T18:21:31.000Z	0xd7976126b74be5c101e1db918065c32333b704d3bee18522ff9588795cbb4170	1848665511480433

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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
0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	false	1004769946228918706008494400	230000175423240346181	0x10510c13d916f32f101607d71b06d7f2e5551371	7	30916166	0x10510c13d916f32f101607d71b06d7f2e5551371	2025-05-31T14:45:48.000Z	0x9995138a012c2865829827c56f75f9fbab6d8c22f5b43170ede28ffe1dca1e43	175423240346181
0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	false	1004770138611409376029592532	80000061085549220344	0x10510c13d916f32f101607d71b06d7f2e5551371	1	30917447	0x10510c13d916f32f101607d71b06d7f2e5551371	2025-05-31T14:53:27.000Z	0x5e211879c39b1a31513419f62a5aa9af31f2cb4786008aadc3c9ecc2615e594d	61085549220344
0x07b1adfb7d5795cf21bae8a77eceb222f2fafbce	false	1004770249373818956249584284	13000043988355703629	0x10510c13d916f32f101607d71b06d7f2e5551371	11	30918139	0x10510c13d916f32f101607d71b06d7f2e5551371	2025-05-31T14:57:51.000Z	0xda1351409a87bc3c76bc6039c4bffadce74dc6c8fd19c7c665c1d336eba12ef9	43988355703629

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.aave_v3_sonic.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`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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
378392	0xdda7cec77de1213f91fd76a122ba44fd7169f8d8	true	258029	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	9005841200000000000	0x80500d20	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	24358613	0xdda7cec77de1213f91fd76a122ba44fd7169f8d8	2025-05-04T20:59:39.000Z	0x01e1990116472ebb36e275797d96009157217131bc699b68f7cc71abcd94f112
378392	0xca4a4e011bdeb6e5cbc229b882ee20ad3231096a	true	258029	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	75000000000000000000	0x80500d20	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	24280468	0xca4a4e011bdeb6e5cbc229b882ee20ad3231096a	2025-05-04T13:12:47.000Z	0x423ae283e1f01c40a97c9eb9d8e09dd5d0e9c1307d4a717abcfb91b9d5571789
378392	0xe88429cdec7a6c6ad621e6e09aa84b6fede3881f	true	258029	0x5362dbb1e601abf3a4c14c22ffeda64042e5eaa3	340000000000000000000	0x80500d20	0x061d8e131f26512348ee5fa42e2df1ba9d6505e9	24311686	0xe88429cdec7a6c6ad621e6e09aa84b6fede3881f	2025-05-04T16:12:45.000Z	0x373c1244497cfd1738a3a0a26c43ffafb6ff0473e9cb9b78e3b8e03cf65f32ae

Example Query

Query with partition filter

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

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​IncentivesController_RewardsClaimed_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

​LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​StataToken_Deposit_event

​StataToken_Initialized_event

​StataToken_Withdraw_event

​StataTokenFactory_StataTokenCreated_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

​WrappedTokenGatewayV3_withdrawETH_function

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

IncentivesController_RewardsClaimed_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_BridgeProtocolFeeUpdated_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_FlashloanPremiumToProtocolUpdated_event

LendingPoolConfigurator_FlashloanPremiumTotalUpdated_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

StataToken_Deposit_event

StataToken_Initialized_event

StataToken_Withdraw_event

StataTokenFactory_StataTokenCreated_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

WrappedTokenGatewayV3_withdrawETH_function