zerolend_v1_base

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	in_balanceIncrease
0x1f3f89ffc8cd686cecc845b5f52246598f1e3196	0x0b5897d201d83a9fcbeefc086c100a8eaa5ada9a	false	1001473362657746108949491635	997591465618570955	0x0b5897d201d83a9fcbeefc086c100a8eaa5ada9a	68	21006848	2024-10-13T07:04:03.000Z	0xa624942bf630eae0ad5af391b44e11657306db02adda5238936689631b6f2b7f	2408534381429045
0x4433cf6e9458027ff0833f22a3cf73318908e48e	0x0e9b063789909565ceda1fba162474405a151e66	false	1001134492884499025033770805	237970	0x0e9b063789909565ceda1fba162474405a151e66	348	21029775	2024-10-13T19:48:17.000Z	0x7930ed17dec0ff39e671ecb260675080c0858791b470eb335382e88320cfa8f3	0
0x4677201dbb575d485ad69e5c5b1e7e7888c3ab29	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	false	1000454291389424792769637880	100000009084021669	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	551	21009938	2024-10-13T08:47:03.000Z	0x058a55e1ae028655c4d4d207b1ff6e7176ad8de4a4b5b8a78ec4e9f1b135c50d	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0xbbb4080b4d4510ace168d1ff8c5cc256ab74e1fb	0x766f21277087e18967c1b10bf602d8fe56d0c671	false	0x10	215	0x6f5ae60d89dbbc4eed4b08d08a68dd5679ac61b4	23170848	ZeroLend Lombard Staked Bitcoin	2024-12-02T09:17:23.000Z	z0LBTC	0xc021ec9132ed3854b287c2db380a5b606ee700b0f9645a7f90ab3dd614814645	8	0xecac9c5f704e954931349da37f60e39f515c11c1	0x73a7a4b40f3fe11e0bcab5538c75d3b984082cae
0x89bb87137afe8bae03f4ab286de667a513ceebdd	0x766f21277087e18967c1b10bf602d8fe56d0c671	false	0x10	163	0x6f5ae60d89dbbc4eed4b08d08a68dd5679ac61b4	20423235	ZeroLend USDzUSDC_LP	2024-09-29T18:50:17.000Z	z0USDzUSDC_LP	0x9fb2b284dae9b00ce7e420034508e495dba4984fb705482ae0ed25010358b68d	18	0x1097dfe9539350cb466df9ca89a5e61195a520b0	0x73a7a4b40f3fe11e0bcab5538c75d3b984082cae
0xb2de5acea05a42b05d05bcf252a2e15a3c93c19e	0x766f21277087e18967c1b10bf602d8fe56d0c671	false	0x10	278	0x6f5ae60d89dbbc4eed4b08d08a68dd5679ac61b4	25671301	ZeroLend ZAI Stablecoin	2025-01-29T06:25:49.000Z	z0ZAI	0xf7d6adc8bebacb6897277334949b2d952a7266eaae47085f9035923d0f5f94a5	18	0x69000dfd5025e82f48eb28325a2b88a241182ced	0x73a7a4b40f3fe11e0bcab5538c75d3b984082cae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x134efc999957fc7984c5ab91bc7ec0f0d373b71e	false	1000002999199372324702102536	65859990976116431	0x5614c860bfcb8d8ea59e14c8aee0b3f73511cd5b	701	29208491	0x5614c860bfcb8d8ea59e14c8aee0b3f73511cd5b	2025-04-21T03:32:09.000Z	0x898f7ba589cc9067c693292a9af2ec34e06d77bd2aab5b3768b8fed8db507af4	0
0x134efc999957fc7984c5ab91bc7ec0f0d373b71e	false	1000002999199372825645452669	82816217137403673	0x5614c860bfcb8d8ea59e14c8aee0b3f73511cd5b	620	29208589	0x5614c860bfcb8d8ea59e14c8aee0b3f73511cd5b	2025-04-21T03:35:25.000Z	0x3fada4d19337bcbd3739d360d34a0c4535a8f3f6c5d514fee1736dcfc925fb8e	33
0x134efc999957fc7984c5ab91bc7ec0f0d373b71e	false	1000002999199373436290913492	90169652014747040	0x5614c860bfcb8d8ea59e14c8aee0b3f73511cd5b	694	29208709	0x5614c860bfcb8d8ea59e14c8aee0b3f73511cd5b	2025-04-21T03:39:25.000Z	0x964cb12389b0e0ce972cf7aabc880419cec73ae9a6573bf0277feec2ba2dcd9b	91

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	false	335000000000000000	199	0x4200000000000000000000000000000000000006	34811614	22447051555140017666377864	0x54015c2f05417af5f1f75ac75ce5a8b62ec7e972	2025-08-28T20:22:55.000Z	0x0619e05e1fb4deea7f76d67653c4dd677de870a2e24f9547443c64a4d3acc084	2
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	false	100000000000000000	40	0x4200000000000000000000000000000000000006	34808755	22626023132041337306137824	0xe2feb73dafcf4db9c86bee4a4dd932d4c79ca2dc	2025-08-28T18:47:37.000Z	0xea99890729b0c538d8b5e8099ed19b15b257a6fad59bd72c687b8937aab142d8	2
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	false	5100000000000000	658	0x4200000000000000000000000000000000000006	34800703	22365453221877193994248183	0xec075563c0ed5d325dcd5dcce67fb1e1fa345ac6	2025-08-28T14:19:13.000Z	0x474782af05ef5cbc6423c2d4df3ebe204bfb3826a969051fb31e61ec6f89c98f	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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	block_number	in_initiator	block_timestamp	transaction_hash	in_interestRateMode
0x766f21277087e18967c1b10bf602d8fe56d0c671	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	46937056940	0x8c44e0b034ec72e362ccf02bb3ebe6671268b850	243	25633054	0x8c44e0b034ec72e362ccf02bb3ebe6671268b850	2025-01-28T09:10:55.000Z	0x727f74a67d4cf44a5696a7b0feefb9ae8f4bb36807a84254b510268ff564af56	2
0x766f21277087e18967c1b10bf602d8fe56d0c671	false	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	423010	0xb5fb94802c6eb44ac94c38e74b3064305b0a0006	248	31413847	0xb5fb94802c6eb44ac94c38e74b3064305b0a0006	2025-06-11T04:44:01.000Z	0x2f4ac14fb6a087b090d7006e57a329d7a4b4c288454f5bbcef0e4e7aa3870bdb	2
0x766f21277087e18967c1b10bf602d8fe56d0c671	false	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	965	0x5c84d288a271ba05135203b8fa567d35f6a321c0	491	35135079	0x5c84d288a271ba05135203b8fa567d35f6a321c0	2025-09-05T08:05:05.000Z	0x2a3fc1b315eccccd793c04ac2be544cf94732bef7d97afc5f0c5fcebdf50942d	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x4cd80aacd9942ccc93f19f3554c7eab411571196	false	310	34006249	0x4200000000000000000000000000000000000006	0xeaf95ce60afcaec82fd69d616076b303ec509ebc	98433328991904	2025-08-10T04:57:25.000Z	false	0xba43027aa958099ff13dff099c848f1eb66924f91040093b911bedbd78543697	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	437690
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x2e6ac4651b6a8a7a84939133d15dd8d8ca30181c	false	56	34022468	0x940181a94a35a4569e4529a3cdfb74e38fd98631	0xf4cd829526070c2c0af9e6dce2c9255130f7ec68	1009044408906715883	2025-08-10T13:58:03.000Z	false	0xcf4a085c754a7c76be1c0c96707ce88542e8fb3736bcb355492c3ca39755b0e5	0x4200000000000000000000000000000000000006	305366676734254
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x23fcd104a217f316dbfa66efcef38f0a084971ad	false	383	34011436	0xecac9c5f704e954931349da37f60e39f515c11c1	0xf7ce7e560be797202b69325852bb11311aa22145	444	2025-08-10T07:50:19.000Z	false	0x62d0ad69d3d9bd4e99aebea1d6aae524c52651cda7c7366d44576f85a5db6675	0xecac9c5f704e954931349da37f60e39f515c11c1	457

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x766f21277087e18967c1b10bf602d8fe56d0c671	false	478	0x940181a94a35a4569e4529a3cdfb74e38fd98631	22245128	2024-11-10T23:00:03.000Z	868424755066428213	0x400db8c2c828e6b987ad89fe216d4a9bda7c764fd5e6acc7d1bd4507854c2f9f
0x766f21277087e18967c1b10bf602d8fe56d0c671	false	484	0x0a27e060c0406f8ab7b64e3bee036a37e5a62853	22245128	2024-11-10T23:00:03.000Z	429465332882927669	0x400db8c2c828e6b987ad89fe216d4a9bda7c764fd5e6acc7d1bd4507854c2f9f
0x766f21277087e18967c1b10bf602d8fe56d0c671	false	475	0x4200000000000000000000000000000000000006	22245128	2024-11-10T23:00:03.000Z	8498584163153007	0x400db8c2c828e6b987ad89fe216d4a9bda7c764fd5e6acc7d1bd4507854c2f9f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x5a4ec1fb0d9a54188b315306a5c3cbe0d7f0c9aa	false	15000000000000000	183	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	0x4200000000000000000000000000000000000006	33139340	false	2025-07-21T03:20:27.000Z	0x11b699b4164ab608ae6f2ed4d136a48120c99319abb2372f550bab6024ba97f8
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x3c2188ffaba22618e8eba8256addee9f7e2ea410	false	22000000000000000	122	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	0x4200000000000000000000000000000000000006	33138322	false	2025-07-21T02:46:31.000Z	0xcd7f7be4c90dba4c821a9e51d4b70a4461689b4d77b647b8113d0fda28d653b6
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x26f7d10ae03a42618277e7c3cc946e14bc4eb726	false	540002480343576421	64	0x26f7d10ae03a42618277e7c3cc946e14bc4eb726	0x4200000000000000000000000000000000000006	33163200	false	2025-07-21T16:35:47.000Z	0x03ec2b61d20b35b6e968168252f8cc37b79201698dc51e48a23c15c27e272b34

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x766f21277087e18967c1b10bf602d8fe56d0c671	0xb7ea94340e65cc68d1274ae483dfbe593fd6f21e	false	1736281450345582	1133	0x4200000000000000000000000000000000000006	33640030	0x2e6ac4651b6a8a7a84939133d15dd8d8ca30181c	2025-08-01T17:30:07.000Z	0xc7732d27fd749f9bb356ceb0b98e0504a7299b84cca13d9f20d060de46a96fbe
0x766f21277087e18967c1b10bf602d8fe56d0c671	0xb7ea94340e65cc68d1274ae483dfbe593fd6f21e	false	452489524543162	87	0x4200000000000000000000000000000000000006	33640016	0x2e6ac4651b6a8a7a84939133d15dd8d8ca30181c	2025-08-01T17:29:39.000Z	0xe51573d7b230e8abf5944a6691d31d254fc47e9a3fe193527cc4e10c3703fa9b
0x766f21277087e18967c1b10bf602d8fe56d0c671	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	false	150000000000000000	427	0x4200000000000000000000000000000000000006	33643923	0x93a80240f0485b6e6bad7d46ac3f617bc396be29	2025-08-01T19:39:53.000Z	0x51873cfdf67894c3207edc68ad3cfa2a9114dbbe80b798786bb4d3441b594f43

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x0a3efbc22cb02d29161226fd756113e5548a271e	0x766f21277087e18967c1b10bf602d8fe56d0c671	0x0a3efbc22cb02d29161226fd756113e5548a271e	false	65000000	605	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	22353475	2024-11-13T11:11:37.000Z	0x1ca016023e6e4a7c035689c522485e75f56bfe637d20b32884238903b594c636
0x0b5897d201d83a9fcbeefc086c100a8eaa5ada9a	0x766f21277087e18967c1b10bf602d8fe56d0c671	0x0b5897d201d83a9fcbeefc086c100a8eaa5ada9a	false	14000000000	179	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	22362476	2024-11-13T16:11:39.000Z	0x0c80cd06301faef25f89378467b840eca5af56fcaf3b7d3b2f258469689b1d4a
0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	0x766f21277087e18967c1b10bf602d8fe56d0c671	0x11ccdcfb19151feb086ee6f1f62bfa0940c85612	false	41750020599464106	451	0x4200000000000000000000000000000000000006	22340460	2024-11-13T03:57:47.000Z	0xeb2b85feaa595e5a97b6774a776bef79c0bb298577ebf821bf5c4ca788700887

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
8000	0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0xecac9c5f704e954931349da37f60e39f515c11c1	219	23170848	2024-12-02T09:17:23.000Z	0xc021ec9132ed3854b287c2db380a5b606ee700b0f9645a7f90ab3dd614814645	10400	8500
0	0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938	608	35833824	2025-09-21T12:16:35.000Z	0x5059fc6418608d2e1ddf7cd4c21bd7c3a5b42f7c059dc1922183840d565ab22e	10400	8000
0	0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0xecac9c5f704e954931349da37f60e39f515c11c1	605	35833824	2025-09-21T12:16:35.000Z	0x5059fc6418608d2e1ddf7cd4c21bd7c3a5b42f7c059dc1922183840d565ab22e	10400	8500

Example Query

Query with partition filter

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

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0xe46c8ba948f8071b425a1f7ba45c0a65cbacea2e	3000	245	25671301	2025-01-29T06:25:49.000Z	0xf7d6adc8bebacb6897277334949b2d952a7266eaae47085f9035923d0f5f94a5
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0x5d746848005507da0b1717c137a10c30ad9ee307	3000	266	25671301	2025-01-29T06:25:49.000Z	0xf7d6adc8bebacb6897277334949b2d952a7266eaae47085f9035923d0f5f94a5
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0x69000dfd5025e82f48eb28325a2b88a241182ced	3000	288	25671301	2025-01-29T06:25:49.000Z	0xf7d6adc8bebacb6897277334949b2d952a7266eaae47085f9035923d0f5f94a5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0x35e5db674d8e93a03d814fa0ada70731efe8a4b9	132	26148107	2025-02-09T07:19:21.000Z	0x09bb97aa6991ff10050f66e7bb23c9c7463cdba71956eb3b7338538af4fe21a7	3000
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0xf469fbd2abcd6b9de8e169d128226c0fc90a012e	215	21698534	2024-10-29T07:20:15.000Z	0xd38fac1567bacce47ce4f6a6c9a39944c3c31e83b61cde3134c92d892b5882a0	3000
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0xdbfefd2e8460a6ee4955a68582f85708baea60a3	201	21698351	2024-10-29T07:14:09.000Z	0x0b696a0ae84c77e2fd76ef0ab78fcac87518ec19924c7fd8da4be5b926a16dd6	3000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0x1097dfe9539350cb466df9ca89a5e61195a520b0	0x89bb87137afe8bae03f4ab286de667a513ceebdd	166	20423235	2024-09-29T18:50:17.000Z	0x9fb2b284dae9b00ce7e420034508e495dba4984fb705482ae0ed25010358b68d	0x6bb22ac00925f75e0a089178835cb98239b0ad30	0x6b0b75c223ddd146b213ef4e35bc61d1de7b46a4	0xa32eb787f2a3dc1f2c2da0e5d8cae7ff74e6fd32
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0xecac9c5f704e954931349da37f60e39f515c11c1	0xbbb4080b4d4510ace168d1ff8c5cc256ab74e1fb	218	23170848	2024-12-02T09:17:23.000Z	0xc021ec9132ed3854b287c2db380a5b606ee700b0f9645a7f90ab3dd614814645	0x33a0a85a3f184e75333b8c25307acfb9a5e4cb57	0x8307952247925a2ed9f5729eaf67172a77e08999	0x795b70fd08a538598e19a927f5400febfaeb92c7
0xb40e21d5cd8e9e192b0da3107883f8b0f4e4e6e3	false	0x35e5db674d8e93a03d814fa0ada70731efe8a4b9	0x9e08e9119883f9ffc59f97bbab45340f4da0db39	124	26148107	2025-02-09T07:19:21.000Z	0x09bb97aa6991ff10050f66e7bb23c9c7463cdba71956eb3b7338538af4fe21a7	0x52582bc17928f6a0f365728fa715649367455d05	0x4dfa4449f0ddd7fdea916d1242acd8a7f78259df	0x795b70fd08a538598e19a927f5400febfaeb92c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.LendingPoolConfigurator_ReserveInitialized_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
0x8307952247925a2ed9f5729eaf67172a77e08999	0xc8f5e91a1e4bb9252f4c8f4cd5c85776f13f4669	false	1013932570576099513491340872	462546	0x0000000000000000000000000000000000000000	373	30054973	2025-05-10T17:48:13.000Z	0x08d245fdb7858ffa102ee78b00ddd95b220a5930506181306d4643db66999961	37454
0x8307952247925a2ed9f5729eaf67172a77e08999	0xc8f5e91a1e4bb9252f4c8f4cd5c85776f13f4669	false	1013932662503773512289162250	800000	0x0000000000000000000000000000000000000000	129	30055009	2025-05-10T17:49:25.000Z	0xbc7a4e93e7e8ad5b55a956601a6b44fbcda6106f8c979b73252d6fa310a13d47	0
0x8307952247925a2ed9f5729eaf67172a77e08999	0xc8f5e91a1e4bb9252f4c8f4cd5c85776f13f4669	false	1013932710998877073431835973	900000	0x0000000000000000000000000000000000000000	46	30055028	2025-05-10T17:50:03.000Z	0x75a4bc43194e689900e5a86dc5ea8c5a9afb798e982be53baba0090389929def	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.zerolend_v1_base.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
0x19887e3d984cbbd75805dfdbc9810efe923b897f	false	1009278769681995486600314077	545250000000000000000	0x0a4463c10a87ff6924328eec16309ad3f1b27c19	251	23202149	0x0a4463c10a87ff6924328eec16309ad3f1b27c19	2024-12-03T02:40:45.000Z	0x44f70fa9bdd5378cb7c425fbaf5c5144a032918c795acd5af60899c0030ee910	0
0x19887e3d984cbbd75805dfdbc9810efe923b897f	false	1009284376953312755257168620	130003029256908578442	0x0a4463c10a87ff6924328eec16309ad3f1b27c19	171	23202775	0x0a4463c10a87ff6924328eec16309ad3f1b27c19	2024-12-03T03:01:37.000Z	0x199b505eab4d4997ff39ea1bfc22ae74f6fce869a8bdabcb7aca3de73187ff18	3029256908578442
0x19887e3d984cbbd75805dfdbc9810efe923b897f	false	1009570440024555497548322761	10000000000000000000	0x43cb50ac6268efbd9fd0697abc8ecb75d890ea8c	261	23229718	0x43cb50ac6268efbd9fd0697abc8ecb75d890ea8c	2024-12-03T17:59:43.000Z	0x3718c0c16aa265ab2088d9a2b7f4e47688810ddf270c2546efc7ebfbcf476f2d	0

Example Query

Query with partition filter

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

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

VToken_Burn_event

VToken_Mint_event

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

​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

VToken_Burn_event

VToken_Mint_event