zerolend_v1_blast

Tables

AToken_Burn_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_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
0x53a3aa617afe3c12550a93ba6262430010037b04	0xef73ca8feae89c482af25effadf08e971912b31d	false	1022600552775056838310100533	4658085232460934	0x0f6e98a756a40dd050dc78959f45559f98d3289d	21	19876694	2025-05-30T00:00:03.000Z	0x6dda7fcecc13de9167a4fa4c95111f763bbc1bcedf41fde358f78338172e101b
0x23a58cbe25e36e26639bdd969b0531d3ad5f9c34	0xef73ca8feae89c482af25effadf08e971912b31d	false	1073500148687569452369144904	3319788189773579853	0x0f6e98a756a40dd050dc78959f45559f98d3289d	31	19876694	2025-05-30T00:00:03.000Z	0x6dda7fcecc13de9167a4fa4c95111f763bbc1bcedf41fde358f78338172e101b
0x23a58cbe25e36e26639bdd969b0531d3ad5f9c34	0xdb33b1b6b055f2886bf348f88c80473978f11a71	false	1073500204217867104989869888	6909506481688225993242	0x3370290383eb780a37b9df93f7cc9f499873c079	16	19879760	2025-05-30T01:42:15.000Z	0xe4d6c1f427cc2d9178bdee8528e24737049496e2bf37ef8eb70d114f8e6c2cfc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x99b68c56e6c1ac19f52132c3023b5270aadadb07	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	0x10	17	0x9698fdf843cbe4531610ac231b0047d9ffc13bc6	3437681	ZeroLend Ether.fi wETH	2024-05-14T11:12:57.000Z	z0weETH	0xa605ff7de4753612877734ec1ea0bfabcb5935a8906e4d2dc7f9a515141c4f39	18	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0x94dc19a5bd17e84d90e63ff3fba9c3b76e5e4012
0x23a58cbe25e36e26639bdd969b0531d3ad5f9c34	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	0x10	0	0x9698fdf843cbe4531610ac231b0047d9ffc13bc6	192546	ZeroLend USDB	2024-02-29T08:21:47.000Z	z0USDB	0xbf950a3c2ca1c5cc3b6edb25f564afbe356e6999f72fe687c3e408ea5d6f7305	18	0x4300000000000000000000000000000000000003	0x94dc19a5bd17e84d90e63ff3fba9c3b76e5e4012
0x53a3aa617afe3c12550a93ba6262430010037b04	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	0x10	4	0x9698fdf843cbe4531610ac231b0047d9ffc13bc6	192546	ZeroLend WETH	2024-02-29T08:21:47.000Z	z0WETH	0xbf950a3c2ca1c5cc3b6edb25f564afbe356e6999f72fe687c3e408ea5d6f7305	18	0x4300000000000000000000000000000000000004	0x94dc19a5bd17e84d90e63ff3fba9c3b76e5e4012

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x53a3aa617afe3c12550a93ba6262430010037b04	false	1022729976187869741046347808	9700646795107101	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	1	20265495	0x9698fdf843cbe4531610ac231b0047d9ffc13bc6	2025-06-08T00:00:05.000Z	0x314aa50cf0944d82a25fff331b6f9254920dc7b61d277c4222bd87e2c5970e28	0
0x23a58cbe25e36e26639bdd969b0531d3ad5f9c34	false	1073508109588362711275478187	1410182342686901548	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	4	20265495	0x9698fdf843cbe4531610ac231b0047d9ffc13bc6	2025-06-08T00:00:05.000Z	0x314aa50cf0944d82a25fff331b6f9254920dc7b61d277c4222bd87e2c5970e28	0
0x23a58cbe25e36e26639bdd969b0531d3ad5f9c34	false	1073508465497497098447629455	3100000055297276141860	0xdb33b1b6b055f2886bf348f88c80473978f11a71	5	20282551	0x3370290383eb780a37b9df93f7cc9f499873c079	2025-06-08T09:28:37.000Z	0x9a9e21828601bd8c9804aa5e4361deb6122f5d45f2fc33a3e185686bfbb55807	55297276141860

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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	transaction_hash	in_interestRateMode
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0xfadfb0bc400427663020887e7c8073d03a35dc3c	false	19000000000000000	21	0x4300000000000000000000000000000000000004	11041943	39047980353071339028668809	0x126fd62fea6b94f8ede1be71c3bd1d2fd5b6b825	2024-11-06T11:48:21.000Z	0x1a64755395879552bb59dae936622f03c0f6faca7dadc4a253fdfdd8518e77b3	2
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0xfadfb0bc400427663020887e7c8073d03a35dc3c	false	8000000000000000	40	0x4300000000000000000000000000000000000004	11042099	39048856358819153523171018	0x126fd62fea6b94f8ede1be71c3bd1d2fd5b6b825	2024-11-06T11:53:33.000Z	0xb54ae21e88e76fc355306fb749d2ca4cb6df2753aaff604ff671512f5bcb729b	2
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0xd47248d5cc7bd078d111b9bae350587621a5aab6	false	20000000000000000000	27	0x4300000000000000000000000000000000000003	11048919	172147916930147749593692204	0xd47248d5cc7bd078d111b9bae350587621a5aab6	2024-11-06T15:40:53.000Z	0x7925287c5a29f165c77aa551e3efff31cb97352b4f160b07e40b56a0b85f8ef7	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	0x4300000000000000000000000000000000000003	419028484932373568	0x598b6354ea3bd84e2a1b3e44e2003350e8735718	22	209514242466187	23163465	0x598b6354ea3bd84e2a1b3e44e2003350e8735718	2025-08-14T01:59:05.000Z	0xd2127b27135fbf6d3f76be3b40bdca9e08198c7687ef0eeb7ee9e704ba521521
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	0x4300000000000000000000000000000000000004	238648499151637	0x598b6354ea3bd84e2a1b3e44e2003350e8735718	29	119324249576	23164624	0x598b6354ea3bd84e2a1b3e44e2003350e8735718	2025-08-14T02:37:43.000Z	0x8e6bf7c1fa81d653bea2b783ddda1a8cf9ecd843a68d9661dfd6eb7cab87ee40
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	0x4300000000000000000000000000000000000004	365426348430427	0x598b6354ea3bd84e2a1b3e44e2003350e8735718	21	182713174215	23163459	0x598b6354ea3bd84e2a1b3e44e2003350e8735718	2025-08-14T01:58:53.000Z	0xf652aebf1d9a3cfae367376e765b1dcd11591875034d60d6f67c7f67ad072b62

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x2c11c79192f1c497b6bb817d5ac90085bd519ebf	false	14	10562236	0x4300000000000000000000000000000000000004	0x55bd6a41977a08f2fbf8c0a970f954a6735293ff	3486598320475614	2024-10-26T09:18:07.000Z	false	0xbcba5fd84548f4119bb149c29bb5337fbb32e1b924c42c0e3c479e772efd0ef2	0x4300000000000000000000000000000000000004	3660928236499395
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0xda8505a8ae4d0ef43313b0873f2c7ec9d620a6b6	false	18	10550747	0x4300000000000000000000000000000000000004	0x7146941b80a241274fa6e905cd0452433bfab0f5	52724500545337943	2024-10-26T02:55:09.000Z	false	0xb66df8c43ecd91a886ee80f28020d727ea374cfc9d304d9cfe8193784826faa4	0x4300000000000000000000000000000000000004	55360725572604840
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x54eec922de00b559a91ed1f2fa02fcba53d0e3c6	false	12	20895076	0x4300000000000000000000000000000000000003	0xb034bf4c08cdecfd26599b7e1e92bb238733b82e	2861727567106438525	2025-06-22T13:46:07.000Z	false	0xc3b5f5af1ff1c9f918e6974639aeea74762eeabd97084101725f30f927b74173	0x4300000000000000000000000000000000000004	1374223068501753

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	12	0x4300000000000000000000000000000000000004	7694294	2024-08-21T00:00:03.000Z	1451280363839933	0x7b24f45b46875fd5a884de5b2cc63dd85df7b8bacb48c776d0fb0a7e34a671a7
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	16	0x4300000000000000000000000000000000000003	7694294	2024-08-21T00:00:03.000Z	24966874072016695290	0x7b24f45b46875fd5a884de5b2cc63dd85df7b8bacb48c776d0fb0a7e34a671a7
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	false	8	0x4300000000000000000000000000000000000003	21820694	2025-07-14T00:00:03.000Z	22638988333165041760	0x21301dc6b6f0808440daab1c1731dd22474949d88dbe75b6b69c234a75a45e3c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x3370290383eb780a37b9df93f7cc9f499873c079	false	3100000000000000000000	6	0xdb33b1b6b055f2886bf348f88c80473978f11a71	0x4300000000000000000000000000000000000003	19815005	false	2025-05-28T13:43:45.000Z	0x6520dad562bec10b22e421711c632d0cb75ee323e7c2273f9544abee3a4004e8
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x3370290383eb780a37b9df93f7cc9f499873c079	false	3100000000000000000000	6	0xdb33b1b6b055f2886bf348f88c80473978f11a71	0x4300000000000000000000000000000000000003	19814992	false	2025-05-28T13:43:19.000Z	0xd9675074877d0bced58c43def5ef46263704fe94a1cbe7d08bcf0f8d821d5541
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x3370290383eb780a37b9df93f7cc9f499873c079	false	3100000000000000000000	8	0xdb33b1b6b055f2886bf348f88c80473978f11a71	0x4300000000000000000000000000000000000003	19815012	false	2025-05-28T13:43:59.000Z	0xbe355d164d0699810688015468fab88d04c19fd98ef1341aa79b2897b661d1e6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.LendingPool_Repay_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
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x01fa184c54a7bc33b41688484ed62ee19b4af1ee	false	342771943330617984	110	0x2416092f143378750bb29b79ed961ab195cceea5	2164567	0x01fa184c54a7bc33b41688484ed62ee19b4af1ee	2024-04-14T23:55:49.000Z	0x9286bea3f1dc8c29198aa95691ebd643ade1929969a04f740de9bbe9455bd270
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x03c78f6a0a3ec69a3daba16d0165f0ae7382e1c8	false	1729959283799160208834	95	0x4300000000000000000000000000000000000003	2147912	0x03c78f6a0a3ec69a3daba16d0165f0ae7382e1c8	2024-04-14T14:40:39.000Z	0x083b136a53f2ede9676ba5fd175d5ce59b0e67f49e3c0e90dfa898facb20cf86
0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x0b7f29a7d11ad8e779400f18fee367d5180cf6f3	false	190000000000000001	114	0x4300000000000000000000000000000000000004	2135631	0x0b7f29a7d11ad8e779400f18fee367d5180cf6f3	2024-04-14T07:51:17.000Z	0xc193ef1afc7fafe7ce90685231a1ba043bdbc0e7add428739b81d78debc5f1a8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x4f4bd77781ceee4914b6bc16633d5437eabca5d3	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x4f4bd77781ceee4914b6bc16633d5437eabca5d3	false	68584998224767619	9	0x2416092f143378750bb29b79ed961ab195cceea5	12058908	2024-11-30T00:47:11.000Z	0x80a94bc57af763c3f73f2fe6581bf71de63592737e5f1c700d27c77eacd4e429
0x61a7a13c52f3b0ed614efa3a2f45317200c91973	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x61a7a13c52f3b0ed614efa3a2f45317200c91973	false	191182949135996322	15	0x2416092f143378750bb29b79ed961ab195cceea5	12090632	2024-11-30T18:24:39.000Z	0xf31998d35f22b970905f40821fc7eccd968431d3ad45a93fca4ebf84ef895f63
0x7c803a4d7aae9b521e23acafe7ab71aeed61a41d	0xa70b0f3c2470abbe104bdb3f3aaa9c7c54bea7a8	0x7c803a4d7aae9b521e23acafe7ab71aeed61a41d	false	319988844327751967	4	0x2416092f143378750bb29b79ed961ab195cceea5	12095767	2024-11-30T21:15:49.000Z	0x300730e7e2edbb0c3869d591dbb9f4734d33a7b893fe365a909404e14faeecc3

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

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

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
7000	0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	29	3437681	2024-05-14T11:12:57.000Z	0xa605ff7de4753612877734ec1ea0bfabcb5935a8906e4d2dc7f9a515141c4f39	11000	8000
7500	0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000003	0	192553	2024-02-29T08:22:01.000Z	0x9a73ff69732d9369135808ef5a8c1e34be330078daca6029a2bf7de654948865	10500	8000
8000	0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000004	7	192553	2024-02-29T08:22:01.000Z	0x9a73ff69732d9369135808ef5a8c1e34be330078daca6029a2bf7de654948865	10500	8250

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

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

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000004	13	192553	2024-02-29T08:22:01.000Z	0x9a73ff69732d9369135808ef5a8c1e34be330078daca6029a2bf7de654948865	5000	0
0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000003	6	192553	2024-02-29T08:22:01.000Z	0x9a73ff69732d9369135808ef5a8c1e34be330078daca6029a2bf7de654948865	5000	0
0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000003	61	230658	2024-03-01T05:32:11.000Z	0x77a497918b7d178a3dd3ab48b27ae2161d9f0c3dc057a978a48594de5a61359b	500	5000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x04c0599ae5a44757c0af6f9ec3b93da8976c150a	0x99b68c56e6c1ac19f52132c3023b5270aadadb07	20	3437681	2024-05-14T11:12:57.000Z	0xa605ff7de4753612877734ec1ea0bfabcb5935a8906e4d2dc7f9a515141c4f39	0x8feab183e51439ddc7d73a24908389ccc214baa2	0xee09b82100481065bced265bcb35ea4ecb240598	0x859c2ca97ead2742a0758bc9dd889e9d0e7e84e8
0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000003	0x23a58cbe25e36e26639bdd969b0531d3ad5f9c34	3	192546	2024-02-29T08:21:47.000Z	0xbf950a3c2ca1c5cc3b6edb25f564afbe356e6999f72fe687c3e408ea5d6f7305	0xbc83dcbc06876b463efde74a0539d78c586f90e8	0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	0x0a8058203387c15a711204908ed9efed9f76e6a8
0x22d3cdb2fbd1528a0ebb047ec4de369098efcda1	false	0x4300000000000000000000000000000000000004	0x53a3aa617afe3c12550a93ba6262430010037b04	7	192546	2024-02-29T08:21:47.000Z	0xbf950a3c2ca1c5cc3b6edb25f564afbe356e6999f72fe687c3e408ea5d6f7305	0x045d5602faf1abb4c3f3c62fa70293450d9d5106	0x29c2bc372728dacb472a7e90e5fc8aa0f203c8cd	0x859c2ca97ead2742a0758bc9dd889e9d0e7e84e8

Example Query

Query with partition filter

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

SToken_Burn_event

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

Columns

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

No sample data available.

Example Query

Query with partition filter

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

SToken_Mint_event

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	0x3370290383eb780a37b9df93f7cc9f499873c079	false	1133119498485415757153851382	3099998522530674469699	0x0000000000000000000000000000000000000000	3	22116013	2025-07-20T20:04:01.000Z	0x4d3fe87e5fc55b61448d352313684c3948cafc51b51cd26c0eafa6f541d516c0	1477469325530301
0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	0x3370290383eb780a37b9df93f7cc9f499873c079	false	1133119443117653158821023484	3099912657904785348600	0x0000000000000000000000000000000000000000	3	22115976	2025-07-20T20:02:47.000Z	0x43e0efcc06af3ba2b3e4289cc3cbf92f393313bd30d987c107ac2c65323c4617	87342095214651400
0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	0x3370290383eb780a37b9df93f7cc9f499873c079	false	1133113426608453245993280093	3099977081493986997441	0x0000000000000000000000000000000000000000	3	22111957	2025-07-20T17:48:49.000Z	0xe9dbbf2897e6ea0f5b294336f892903b56c30defc6d27f85f84b10225bb80fb1	22918506013002559

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_blast.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
0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	false	1060629659359574976928122016	5007377663404476533056	0x04d4e53bcbe30a0009ce602e5c1b9a2d27a6a4db	29	6128245	0x04d4e53bcbe30a0009ce602e5c1b9a2d27a6a4db	2024-07-15T17:58:25.000Z	0x4013fd40c95e593df1fd8be0630bbcb32cbeac9238d9f5c6cc884059c10dd8cf	7377663404476533056
0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	false	1060636568415740828755180293	101144182935215100876	0x0d423e7877c579a4bde7c70c4bbaa49fbc69720e	50	6129135	0x0d423e7877c579a4bde7c70c4bbaa49fbc69720e	2024-07-15T18:28:05.000Z	0x97f30d1357486ad4cc15f809d03704e3469369b4c31e6abd643fa80482078f4d	1144182935215100876
0x0e914b7669e97fd0c2644af60e90ea7ddb4f91d1	false	1060500985522730016185833438	4200993277864935914	0x158a1b91ca61fed4a198a296f33d43c6dad710e2	19	6116001	0x158a1b91ca61fed4a198a296f33d43c6dad710e2	2024-07-15T11:10:17.000Z	0x22c0cccb0c40bc57802285c9794ca6d28b9c91fa9ca0f7e9f0e52ec6c08fd50a	0

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

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_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

​Tables

​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_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

Tables

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_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event