Skip to main content

Tables

ATokenCroak_Burn_event

AToken burn events from ZeroLend v1 lending protocol on Linea, recording when users withdraw or repay borrowed assets with burned token amounts and accrued interest. Used for tracking lending pool outflows and analyzing user withdrawal patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x176e1e2be1704bf5cf9c55d5ac2282355355b8d00x60f97315200815dbdd003fac19e94e68cacb6230false10093356438460651602381445351000691841422273330x60f97315200815dbdd003fac19e94e68cacb623032233772362025-09-15T21:56:02.000Z0xdbee4e4f3ceb837988ce133f42b40e0e2003fd71c78d12b0a0316c74f5f807c10
0x176e1e2be1704bf5cf9c55d5ac2282355355b8d00x60f97315200815dbdd003fac19e94e68cacb6230false10093245801513022202220913914000000000000000000x60f97315200815dbdd003fac19e94e68cacb623010233430732025-09-15T02:56:19.000Z0x21bd56cca9c2d761f965af085ff394d23b33df14f17beea7e80d3429139652770
0x176e1e2be1704bf5cf9c55d5ac2282355355b8d00x60f97315200815dbdd003fac19e94e68cacb6230false1009330944222487235813858345251319336103421190x60f97315200815dbdd003fac19e94e68cacb623070233626032025-09-15T13:47:26.000Z0x8ed0f71ad022e19593c0fa0a1b94bbfb66c0e96e2acda297cfe7a1566c69e2680
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenCroak_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenCroak_Initialized_event

AToken initialization events from ZeroLend V1 lending protocol on Linea, recording when new interest-bearing tokens (aTokens) are deployed for underlying assets like USDC, WETH, and CROAK. Used for tracking protocol market expansions and aToken configuration parameters.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_underlyingAssetSTRINGContract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_treasurySTRINGContract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
in_incentivesControllerSTRINGContract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenDecimalsINT64Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
in_aTokenNameSTRINGHuman-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
in_aTokenSymbolSTRINGTrading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
addressin_poolremovedin_paramslog_indexin_treasuryblock_numberin_aTokenNameblock_timestampin_aTokenSymboltransaction_hashin_aTokenDecimalsin_underlyingAssetin_incentivesController
0x711449ea0f3c6d9e1626e72aa431597b9216f3d40xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse0x10230xbbe092a8cf3bfa489f933ce69ea138ca1eea2bbf5091012ZeroLendCROAK USDC2024-06-02T09:46:20.000Zz0USDC0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f160x176211869ca2b568f2a7d4ee941e073a821ee1ff0x9c368e7a8a606e1603f798a76ccc722b52ec4578
0x176e1e2be1704bf5cf9c55d5ac2282355355b8d00xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse0x10270xbbe092a8cf3bfa489f933ce69ea138ca1eea2bbf5091012ZeroLendCROAK WETH2024-06-02T09:46:20.000Zz0WETH0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1180xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f0x9c368e7a8a606e1603f798a76ccc722b52ec4578
0xe59691dd4b38ba4632a51d1f7596c431ad36907c0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse0x10310xbbe092a8cf3bfa489f933ce69ea138ca1eea2bbf5091012ZeroLendCROAK CROAK2024-06-02T09:46:20.000Zz0CROAK0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1180xacb54d07ca167934f57f829bee2cc665e1a5ebef0x9c368e7a8a606e1603f798a76ccc722b52ec4578
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenCroak_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenCroak_Mint_event

aToken mint events from ZeroLend V1 lending protocol on Linea, recording when users deposit assets and receive interest-bearing aTokens in return. Tracks deposit amounts, recipients, accrued interest, and liquidity index values for analyzing lending pool activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0xe59691dd4b38ba4632a51d1f7596c431ad36907cfalse1001024694004445199016191456190789605565318538301390x04069ed1e8c500ce3f0785d082d4fe470ce03b4e3121687940x04069ed1e8c500ce3f0785d082d4fe470ce03b4e2024-11-17T07:40:02.000Z0xb60f955f43b6054dcdc6c4f6a8bd09518dce6ed525caf1f225e7b6eeeeb2aa1124122258837134387195
0xe59691dd4b38ba4632a51d1f7596c431ad36907cfalse1001025704907834604969092579207693138306282269365740x18143345e0414e48fe0b3b09343a049e280321f615121835320x18143345e0414e48fe0b3b09343a049e280321f62024-11-17T15:52:38.000Z0xd72f95619a7bcb9e3b082e6aa19d052921bf9209add594b3c94d929f94b1ff9b0
0xe59691dd4b38ba4632a51d1f7596c431ad36907cfalse10010248282386162981590231637151116996936088105249000x2c21dc4fe422fbadd7dc1eda8ac4d10a8d9ffa2e11121708110x2c21dc4fe422fbadd7dc1eda8ac4d10a8d9ffa2e2024-11-17T08:47:16.000Z0x6d60aab719c9d3d13704a55efb931cd306e6cd3d40f26b88879381f9b890b4a6679328047140303606189
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenCroak_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenFoxy_Burn_event

Interest-bearing aToken burn events from ZeroLend V1 lending protocol on Linea, recording withdrawal and redemption transactions where users burn aTokens to reclaim underlying assets. Tracks burn amounts, accrued interest, and account balances for analyzing lending pool liquidity and user withdrawal patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x9cab55d186a45bb29fabdbc0118855cf642d80120x405bda48cab999865688eb1f5129c29a9cb0cde1false1019667019668833759427956951401000000000000000x405bda48cab999865688eb1f5129c29a9cb0cde119129577652024-12-06T04:37:07.000Z0x4a97fcf2a9e77e2e8e95059330391aae369cbf0a29f61c45a557c13346524e410
0x9cab55d186a45bb29fabdbc0118855cf642d80120x405bda48cab999865688eb1f5129c29a9cb0cde1false1019667752745033778611429836500000000000000000x405bda48cab999865688eb1f5129c29a9cb0cde134129623552024-12-06T07:23:05.000Z0x13cac6e02d81c8e8625fbaee067575ff634d5d2f2c93fb1eb13973c40fd2871e0
0x9cab55d186a45bb29fabdbc0118855cf642d80120x405bda48cab999865688eb1f5129c29a9cb0cde1false1019667975702948641391489814423580000000000000x405bda48cab999865688eb1f5129c29a9cb0cde112129638152024-12-06T08:14:21.000Z0x48cf7635d674e15cac98c0a42469ce66577286732425943e97d0aed3f6cadf2c0
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenFoxy_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenFoxy_Initialized_event

aToken initialization events from ZeroLend v1 Foxy pool on Linea, recording the creation of interest-bearing tokens with their symbols, decimals, and associated pool configuration. Used for tracking which underlying assets have been onboarded to the lending protocol and their corresponding aToken deployments.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_underlyingAssetSTRINGContract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_treasurySTRINGContract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
in_incentivesControllerSTRINGContract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenDecimalsINT64Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
in_aTokenNameSTRINGHuman-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
in_aTokenSymbolSTRINGTrading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
addressin_poolremovedin_paramslog_indexin_treasuryblock_numberin_aTokenNameblock_timestampin_aTokenSymboltransaction_hashin_aTokenDecimalsin_underlyingAssetin_incentivesController
0x9cab55d186a45bb29fabdbc0118855cf642d80120xbdaa004a456e7f2daff00ffcdcbead5da27b7966false0x10240x14aad4668de2115e30a5feee42cfa436899ccd8a5219143ZeroLendFoxy WETH2024-06-06T20:37:38.000Zz0WETH0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af180xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f0x98f4c6e15cdcd7e5b36e53a249868a46c4f0105e
0xd84a3f1380ec35ab4cdb16a95508a11f2f4743560xbdaa004a456e7f2daff00ffcdcbead5da27b7966false0x10280x14aad4668de2115e30a5feee42cfa436899ccd8a5219143ZeroLendFoxy FOXY2024-06-06T20:37:38.000Zz0FOXY0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af180x5fbdf89403270a1846f5ae7d113a989f850d15660x98f4c6e15cdcd7e5b36e53a249868a46c4f0105e
0xdae1f8cfd0293bd3ef2541ccb4f265290181cac20xbdaa004a456e7f2daff00ffcdcbead5da27b7966false0x10200x14aad4668de2115e30a5feee42cfa436899ccd8a5219143ZeroLendFoxy USDC2024-06-06T20:37:38.000Zz0USDC0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af60x176211869ca2b568f2a7d4ee941e073a821ee1ff0x98f4c6e15cdcd7e5b36e53a249868a46c4f0105e
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenFoxy_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenFoxy_Mint_event

Interest-bearing token (aToken) mint events from ZeroLend V1 lending protocol on Linea, tracking when users deposit collateral and receive corresponding aTokens with accrued interest calculations. Used for analyzing lending activity, interest accumulation rates, and liquidity provider positions.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0x9cab55d186a45bb29fabdbc0118855cf642d8012false10205349439555118711665941781408661149431080x405bda48cab999865688eb1f5129c29a9cb0cde12178237960xe59448cea4b0ea756ae3493cabb7388daeb2bc672025-04-08T05:34:28.000Z0x3d2da37dd66efc35cdd7d8b4f58f7582913984012165c366c20ce84709ec9641140866114943108
0x9cab55d186a45bb29fabdbc0118855cf642d8012false10205352211484073044314628001263596689727020x405bda48cab999865688eb1f5129c29a9cb0cde12178300270x4f8b8afd3b707c7a365a0beeacb429ad28557d992025-04-08T09:52:27.000Z0x8b55e38d7b1fb75483f038856b8c7358fc91f2fdbe4715f10b4c54ee9239832a126359668972702
0x9cab55d186a45bb29fabdbc0118855cf642d8012false1020534701260398193420730603100057890365590x405bda48cab999865688eb1f5129c29a9cb0cde144178186310x8d9957b8739237a156f9002e070d04893b7865f12025-04-08T01:43:32.000Z0xb176b03b2a1da4985b8a032b4e955732604da0b8b65594339ca9ca5dbd66997710005789036559
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenFoxy_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenMain_Burn_event

AToken burn events from ZeroLend V1 lending protocol on Linea, recording withdrawals where interest-bearing tokens are redeemed by users. Tracks burned amounts, accrued interest, and protocol index values for analyzing lending pool utilization and user redemption patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x03114e4c29ea95bf26108c2c47338488555ced1a0x359b617fa1a4f180f985dea63eb6fe4a3d7c52a1false100000000000000000000000000050000000000000000x359b617fa1a4f180f985dea63eb6fe4a3d7c52a157111467692024-10-24T07:16:54.000Z0x1636ceed9e29738ad347bea05a001bff6f34435b7c7c1e147181337d44bd08b00
0x8d8b70a576113feedd7e3810ce61f5e243b012640xe40a8cd800d2ed6eeaaf3f522c0be4d72dd6cb4bfalse100014360410597739416875469585000000000000000xe40a8cd800d2ed6eeaaf3f522c0be4d72dd6cb4b59111367852024-10-24T01:44:01.000Z0x7470e074efe9898efb7598b62e9f2263e3540fed421777632155075d749df967117307330614
0x8d8b70a576113feedd7e3810ce61f5e243b012640x3a729e3ab72ebd8c2d4f6cf784e753c85e3610a8false10001437704773831419490908001187653663132371920x3a729e3ab72ebd8c2d4f6cf784e753c85e3610a853111417282024-10-24T04:28:48.000Z0xaa0de8008f855e6d57dc4a36755d6e415d29d2e574118cfb514b7f63b706ee0416310455426519
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenMain_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenMain_Initialized_event

Initialization events for interest-bearing aTokens in ZeroLend V1 lending protocol on Linea, capturing token deployment with underlying asset mappings, decimals, and protocol configuration (pool, treasury, incentives controller addresses). Used to track market listings and identify supported collateral types across wrapped ETH, liquid staking tokens (stETH, ezETH, rsETH), stablecoins (USDe, DAI), and wrapped BTC.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_underlyingAssetSTRINGContract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_treasurySTRINGContract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
in_incentivesControllerSTRINGContract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenDecimalsINT64Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
in_aTokenNameSTRINGHuman-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
in_aTokenSymbolSTRINGTrading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
in_paramsSTRINGAdditional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
addressin_poolremovedin_paramslog_indexin_treasuryblock_numberin_aTokenNameblock_timestampin_aTokenSymboltransaction_hashin_aTokenDecimalsin_underlyingAssetin_incentivesController
0x77e305b4d4d3b9da4e82cefd564f5b948366a44b0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false0x1060x89fec31dad373922879bd6279ccdc3666c5d1b7a4460683ZeroLend Wrapper Ether.fi ETH2024-05-11T11:07:38.000Zz0weETH0x008755fd11f9a5d34c8e0b2ddc7f146d80fe1ca9ff3159801538b46827fa17a9180x1bf74c010e6320bab11e2e5a532b5ac15e0b8aa60x28f6899ff643261ca9766ddc251b359a2d00b945
0x8d8b70a576113feedd7e3810ce61f5e243b012640x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false0x10100x89fec31dad373922879bd6279ccdc3666c5d1b7a4460563ZeroLend Kelp rsETH2024-05-11T11:01:38.000Zz0rsETH0x295df4fcdc569405ad38a3afd40fcdc8cb43c881f34e7e69fff9f9ef3f703494180xd2671165570f41bbb3b0097893300b6eb6101e6c0x28f6899ff643261ca9766ddc251b359a2d00b945
0x0ab214f127998a36ce7ab0087a9b0d20adc2d5ad0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false0x10130x89fec31dad373922879bd6279ccdc3666c5d1b7a3598292ZeroLend Wrapper BTC2024-04-11T12:22:37.000Zz0WBTC0x224738865889822fe81e2af0b19b1588a1bfe604bb11409ecafc16d5334a707c180x3aab2285ddcddad8edf438c1bab47e1a9d05a9b40x28f6899ff643261ca9766ddc251b359a2d00b945
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenMain_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

ATokenMain_Mint_event

Minting events for aTokens in ZeroLend V1 lending protocol on Linea, tracking deposits where users receive interest-bearing tokens. Records caller address, recipient, deposit amount, accrued interest, and cumulative index for analyzing lending activity and yield generation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0x03114e4c29ea95bf26108c2c47338488555ced1afalse1000000000000000000000000000956000000000000000xbcf37b6a9fd5cbfb25d75c009c0054950d351a03589180120xbcf37b6a9fd5cbfb25d75c009c0054950d351a032024-09-02T04:14:47.000Z0x8d69366a1556b3f5bd2fe09250e434e1a471ee15f5e058fefd3a6c8873e13c2e0
0x03114e4c29ea95bf26108c2c47338488555ced1afalse1000000000000000000000000000350000000000000000x6fd3acc52b08ccdfb4f10b6fd06cbaa1d6b04fe01689263890x6fd3acc52b08ccdfb4f10b6fd06cbaa1d6b04fe02024-09-02T08:54:01.000Z0xca12eb5ba9c26188df8a461973f626635f91368f6207fbf4ea67c16c79ef8dfb0
0x03114e4c29ea95bf26108c2c47338488555ced1afalse1000000000000000000000000000200000000000000000x3614dc430166214109c8ce488c04309056310c325989255350x3614dc430166214109c8ce488c04309056310c322024-09-02T08:25:33.000Z0xda4e5a64f273f6cae6545b80017b5327673fecc8a183ce084e0aa61e282d8b4f0
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.ATokenMain_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorCroak_ReserveFactorChanged_event

Reserve factor parameter changes for lending assets on ZeroLend V1 (Linea), tracking adjustments to the protocol’s fee allocation percentage. Used to monitor governance decisions affecting protocol revenue distribution between reserves and lenders.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldReserveFactorSTRINGPrevious reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
in_newReserveFactorSTRINGUpdated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.
addressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_newReserveFactorin_oldReserveFactor
0x03dee3b6512fc2c4aced439995c01facbc13a48cfalse0x176211869ca2b568f2a7d4ee941e073a821ee1ff2950927172024-06-02T11:11:35.000Z0x9d1427579b7549d9e3c5e629fa6f304802ffca34f531c8ecd034cbd66f15204a30005000
0x03dee3b6512fc2c4aced439995c01facbc13a48cfalse0x176211869ca2b568f2a7d4ee941e073a821ee1ff14250910172024-06-02T09:46:35.000Z0xdb9f8008c3653978fb98c0b95ed7cb6bbeee797886e4b20c1974a08aaf37c0ac50000
0x03dee3b6512fc2c4aced439995c01facbc13a48cfalse0xacb54d07ca167934f57f829bee2cc665e1a5ebef15650910172024-06-02T09:46:35.000Z0xdb9f8008c3653978fb98c0b95ed7cb6bbeee797886e4b20c1974a08aaf37c0ac30000
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorCroak_ReserveFactorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorCroak_ReserveInitialized_event

Reserve initialization events from ZeroLend v1 lending protocol on Linea, capturing when new assets are added to the lending pool with their associated aToken, debt token, and interest rate strategy contracts. Used for tracking protocol expansion and reserve configuration changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenSTRINGContract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_stableDebtTokenSTRINGContract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_variableDebtTokenSTRINGContract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_interestRateStrategyAddressSTRINGContract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_assetin_aTokenlog_indexblock_numberblock_timestamptransaction_hashin_stableDebtTokenin_variableDebtTokenin_interestRateStrategyAddress
0x03dee3b6512fc2c4aced439995c01facbc13a48cfalse0xacb54d07ca167934f57f829bee2cc665e1a5ebef0xe59691dd4b38ba4632a51d1f7596c431ad36907c3450910122024-06-02T09:46:20.000Z0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f10x5d30efee91787133ecacf1ca40808123382adc8f0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc460x18cb9aecfaab5894219f683ebe66883d0b2e6c64
0x03dee3b6512fc2c4aced439995c01facbc13a48cfalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f0x176e1e2be1704bf5cf9c55d5ac2282355355b8d03050910122024-06-02T09:46:20.000Z0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f10x86453bd0075dc4b5f255a3679f0c9475107847d90x5c8957af6341d824d615fabacb3dbab75932695b0x18cb9aecfaab5894219f683ebe66883d0b2e6c64
0x03dee3b6512fc2c4aced439995c01facbc13a48cfalse0x176211869ca2b568f2a7d4ee941e073a821ee1ff0x711449ea0f3c6d9e1626e72aa431597b9216f3d42650910122024-06-02T09:46:20.000Z0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f10x8cb14e515a98fc3ba7495867ef2e6450cf12c2aa0x2b9881ddb5570ae9eba081fa7fdf334e4195e3de0xfbc45e0f8215668460577afc4b477faf020fa5d2
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorCroak_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorFoxy_CollateralConfigurationChanged_event

Collateral parameter configuration changes from ZeroLend V1 lending protocol on Linea, tracking updates to loan-to-value (LTV), liquidation threshold, and liquidation bonus settings for supported assets. Used for monitoring risk parameter adjustments and analyzing protocol governance decisions affecting borrowing capacity and liquidation mechanics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_ltvSTRINGLoan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
in_liquidationThresholdSTRINGLiquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
in_liquidationBonusSTRINGLiquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.
in_ltvaddressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_liquidationBonusin_liquidationThreshold
30000xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0x5fbdf89403270a1846f5ae7d113a989f850d15665452192242024-06-06T20:41:41.000Z0x7b8f2d7a2f83a8e7167341d3f56fc451e8747aa9e86020b0e79c108bc675cdc6110008000
80000xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f4752192242024-06-06T20:41:41.000Z0x7b8f2d7a2f83a8e7167341d3f56fc451e8747aa9e86020b0e79c108bc675cdc6110009000
80000xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0x176211869ca2b568f2a7d4ee941e073a821ee1ff4052192242024-06-06T20:41:41.000Z0x7b8f2d7a2f83a8e7167341d3f56fc451e8747aa9e86020b0e79c108bc675cdc6110009000
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorFoxy_CollateralConfigurationChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorFoxy_LiquidationProtocolFeeChanged_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldFeeSTRINGPrevious liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
in_newFeeSTRINGUpdated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorFoxy_LiquidationProtocolFeeChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorFoxy_ReserveFactorChanged_event

Reserve factor configuration changes for assets in the ZeroLend lending protocol on Linea, tracking when protocol revenue allocation percentages are updated. Useful for monitoring governance decisions and protocol parameter adjustments over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldReserveFactorSTRINGPrevious reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
in_newReserveFactorSTRINGUpdated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.
addressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_newReserveFactorin_oldReserveFactor
0xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0x176211869ca2b568f2a7d4ee941e073a821ee1ff552203142024-06-06T21:36:11.000Z0xb7a0cfb2e286007070185c2c61dee3628372e8351dc724c576890229188b4a1620005000
0xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f552203222024-06-06T21:36:35.000Z0xe6db4bc1fe840f91c34a7beb6b4054ced979abbd4eabb6521ca94881de556d2b20005000
0xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0x5fbdf89403270a1846f5ae7d113a989f850d1566452203242024-06-06T21:36:41.000Z0x452134dc096b602304621c7adb2b2b0ee479e474df1452588490c07c27aea07c20003000
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorFoxy_ReserveFactorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorFoxy_ReserveInitialized_event

Reserve initialization events from ZeroLend v1 lending protocol on Linea, capturing when new assets are added to the lending pool with their associated aToken, debt token, and interest rate strategy contract addresses. Used for tracking lending market expansions and protocol configuration changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenSTRINGContract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_stableDebtTokenSTRINGContract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_variableDebtTokenSTRINGContract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_interestRateStrategyAddressSTRINGContract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_assetin_aTokenlog_indexblock_numberblock_timestamptransaction_hashin_stableDebtTokenin_variableDebtTokenin_interestRateStrategyAddress
0xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0x5fbdf89403270a1846f5ae7d113a989f850d15660xd84a3f1380ec35ab4cdb16a95508a11f2f4743563152191432024-06-06T20:37:38.000Z0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af0xb490091282a566d4b6d466c7cb5f0cc0a8c3d2300x613ac3930a5b2805e48be151bea8c29d394f8a860x1e62b7782e489dfffd582b88705eb6f66a2982df
0xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0x176211869ca2b568f2a7d4ee941e073a821ee1ff0xdae1f8cfd0293bd3ef2541ccb4f265290181cac22352191432024-06-06T20:37:38.000Z0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af0x0aa52b766999bd7570c5999f2e5e7c0989c5f79f0x384a318215aca36084af3719f3c84aa2167de6be0x5418c519393c4f7b94fdbbda11c63b1e4eea9e1a
0xb86cf9aaf4f512f4e72794850796149562e3cc7efalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f0x9cab55d186a45bb29fabdbc0118855cf642d80122752191432024-06-06T20:37:38.000Z0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af0xf6f54eb569dc28e68c35a640846f0ce70c2ac86b0xfbb30e625ba0aa35c13a86ef49ab4f2bafa215380x5418c519393c4f7b94fdbbda11c63b1e4eea9e1a
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorFoxy_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorMain_CollateralConfigurationChanged_event

Collateral parameter updates from ZeroLend v1 lending protocol on Linea, recording changes to loan-to-value (LTV) ratios, liquidation thresholds, and liquidation bonuses for supported assets. Used for tracking risk parameter governance decisions and analyzing protocol collateral configurations over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_ltvSTRINGLoan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
in_liquidationThresholdSTRINGLiquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
in_liquidationBonusSTRINGLiquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.
in_ltvaddressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_liquidationBonusin_liquidationThreshold
50000xf17218b09699d0f7145e40e771e72130ff616498false0x5a7a183b6b44dc4ec2e3d2ef43f98c5152b1d76d1146308782024-05-17T08:58:58.000Z0x3716f459e048b25a6a663321acc792db798089c9f6c7b053c57c7f9bd1811031110008000
70000xf17218b09699d0f7145e40e771e72130ff616498false0xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f2146299962024-05-17T08:14:52.000Z0x9f77ebae9b4e74f1c3f4344b763a39c94e8bfeb78570a39965073c1e60b9d587110008000
70000xf17218b09699d0f7145e40e771e72130ff616498false0x211cc4dd073734da055fbf44a2b4667d5e5fe5d21946299962024-05-17T08:14:52.000Z0x9f77ebae9b4e74f1c3f4344b763a39c94e8bfeb78570a39965073c1e60b9d587110008000
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorMain_CollateralConfigurationChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorMain_LiquidationProtocolFeeChanged_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldFeeSTRINGPrevious liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
in_newFeeSTRINGUpdated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorMain_LiquidationProtocolFeeChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorMain_ReserveFactorChanged_event

Reserve factor parameter changes for lending markets on ZeroLend protocol (Linea chain). Tracks protocol fee adjustments for each asset reserve, useful for monitoring risk parameter governance and protocol revenue allocation updates.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_oldReserveFactorSTRINGPrevious reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
in_newReserveFactorSTRINGUpdated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.
addressremovedin_assetlog_indexblock_numberblock_timestamptransaction_hashin_newReserveFactorin_oldReserveFactor
0xf17218b09699d0f7145e40e771e72130ff616498false0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef341270079422024-07-19T19:58:53.000Z0xc87c8d93f29b9fcf91739112ca765773a4823d1f9bbd1af50ceb86a8e664526d50001500
0xf17218b09699d0f7145e40e771e72130ff616498false0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b41370079422024-07-19T19:58:53.000Z0xc87c8d93f29b9fcf91739112ca765773a4823d1f9bbd1af50ceb86a8e664526d50001500
0xf17218b09699d0f7145e40e771e72130ff616498false0x4af15ec2a0bd43db75dd04e62faa3b8ef36b00d5970079422024-07-19T19:58:53.000Z0xc87c8d93f29b9fcf91739112ca765773a4823d1f9bbd1af50ceb86a8e664526d50001500
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorMain_ReserveFactorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolConfiguratorMain_ReserveInitialized_event

Reserve initialization events from ZeroLend V1 lending protocol on Linea, recording when new asset markets are added with their corresponding aToken, debt token addresses, and interest rate strategies. Used to track protocol expansion and identify supported collateral assets across the lending pool.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenSTRINGContract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_stableDebtTokenSTRINGContract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_variableDebtTokenSTRINGContract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_interestRateStrategyAddressSTRINGContract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_assetin_aTokenlog_indexblock_numberblock_timestamptransaction_hashin_stableDebtTokenin_variableDebtTokenin_interestRateStrategyAddress
0xf17218b09699d0f7145e40e771e72130ff616498false0x5a7a183b6b44dc4ec2e3d2ef43f98c5152b1d76d0x4585cbe390df68cbaa36c0d0886e8528c31c7c111546308282024-05-17T08:56:28.000Z0x45a835816b7db21c021e7db0815f97067d8a7de62ad585fb5bd43e9d97f45b7c0x705b5ee015f12fc29066b1e5214a2cac702211fa0x53a44b6384c28c099dc168fd1d9044105e23c6320x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e
0xf17218b09699d0f7145e40e771e72130ff616498false0xecc68d0451e20292406967fe7c04280e5238ac7d0x1820335eba09b72ce46c0de4650f71c7505b48249346298362024-05-17T08:06:52.000Z0xa8a5b5b33d91b62ba4f47105ba27d148195844ab42be12f8a6059a953fe0f4260x9861087fe7f894c52efc7b9e12bfaba57fd039610x06ecdfde2d468aed563d5765356b6def4901b6bc0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e
0xf17218b09699d0f7145e40e771e72130ff616498false0x211cc4dd073734da055fbf44a2b4667d5e5fe5d20x5c44c9e5182193ce4e24b8f85c9c914c59d577674246298362024-05-17T08:06:52.000Z0xa8a5b5b33d91b62ba4f47105ba27d148195844ab42be12f8a6059a953fe0f4260x0410fb2330217120ed8e9590543e1c0ea9a00e700x068b5441787b0b973e25d5dbdacb7a7c2161af510x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolConfiguratorMain_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_Borrow_event

Borrow events from ZeroLend V1 lending protocol on Linea, capturing loan originations with borrower address, reserve asset, borrowed amount, interest rate mode, and borrow rate. Used for analyzing borrowing activity, interest rate trends, and protocol utilization across different asset reserves.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
in_borrowRateSTRINGAnnual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_borrowRatein_onBehalfOfblock_timestampin_referralCodetransaction_hashin_interestRateMode
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x312fc6d761b5f4680b5f0cc5a8e2804f647c2041false30000000340x176211869ca2b568f2a7d4ee941e073a821ee1ff81965443645887805867897237380561670x312fc6d761b5f4680b5f0cc5a8e2804f647c20412024-08-16T08:41:18.000Z00xfd895b69c3f1e2069ef127dad643a31ced2f6f43499177cc5b719d5b2146a4992
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x644002353c54cb8d3e851bbdb3fd17c0392430d6false532000000390x176211869ca2b568f2a7d4ee941e073a821ee1ff81991993764236627469664371954921640x644002353c54cb8d3e851bbdb3fd17c0392430d62024-08-16T10:09:50.000Z00x790b58e7dccfa915ecc987f28812d774382c64f97111b2031176c612083c1e322
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xfc101da61af4bc33189e6f8e58dc150eb13f5099false425000000060x176211869ca2b568f2a7d4ee941e073a821ee1ff82098714280815736198572573232427470xfc101da61af4bc33189e6f8e58dc150eb13f50992024-08-16T16:05:34.000Z00x8ed5759677b9cb2bbeecc34b6ac87e2712f69652392d7e425757122f2dafd6152
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_FlashLoan_event

Flash loan execution events from ZeroLend V1 lending protocol on Linea, recording borrowed amounts, assets, premiums paid, and initiator addresses. Used for analyzing flash loan arbitrage activity, fee revenue, and instant liquidity patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
in_premiumSTRINGFee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressremovedin_assetin_amountin_targetlog_indexin_premiumblock_numberin_initiatorblock_timestampin_referralCodetransaction_hashin_interestRateMode
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f11000000000000000x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e3555000000000055161820x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e2024-06-15T06:41:19.000Z00x5ff22211de0ab10da86d12a9511b7bfec566c592c15bfdd20b5558e43e3599990
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f14300000000000000x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e6471500000000055275800x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e2024-06-15T13:01:16.000Z00x5d2170a6f37d0f7015a458d67e979118abb67fd266178a640f399518752237040
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f39600000000000000x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e54198000000000054894920x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e2024-06-14T15:51:36.000Z00x144a3bd2dd75a30b3f190d9a0148a4439cff71bb1670c9a8d32e1cc41aa178420
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_LiquidationCall_event

Liquidation events from ZeroLend V1 lending protocol on Linea, capturing when undercollateralized positions are liquidated with debt repaid and collateral seized. Contains liquidator addresses, borrower accounts, debt and collateral asset addresses, and amounts for analyzing liquidation activity and protocol risk events.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_collateralAssetSTRINGContract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtAssetSTRINGContract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtToCoverSTRINGAmount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
in_liquidatedCollateralAmountSTRINGAmount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
in_liquidatorSTRINGAddress of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiveATokenBOOLBoolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.
addressin_userremovedlog_indexblock_numberin_debtAssetin_liquidatorin_debtToCoverblock_timestampin_receiveATokentransaction_hashin_collateralAssetin_liquidatedCollateralAmount
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xc55720f140337755346ca0bccb5ab3e2e07d27c3false59187454520x176211869ca2b568f2a7d4ee941e073a821ee1ff0x77ba0fc6664ba7b2a80f782e662a46d432a28f1597578462025-05-07T02:51:23.000Zfalse0x84bf5fa74667a7df111abab5260226eb7d3e0d5f1b78190cce42d1d5293e20420x176211869ca2b568f2a7d4ee941e073a821ee1ff10733631
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x67c9ac4a17a1e874d95c91e35abf28756572a8b4false12187469370x176211869ca2b568f2a7d4ee941e073a821ee1ff0x77ba0fc6664ba7b2a80f782e662a46d432a28f1530056452025-05-07T03:54:30.000Zfalse0x6c392542ea67e420d0ef797facf14147b68630212cd7c2995a115f2a9a8c57e00x176211869ca2b568f2a7d4ee941e073a821ee1ff3306210
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x2b2a3d642758526def7e2f165a4d567620d63781false16187469360x176211869ca2b568f2a7d4ee941e073a821ee1ff0x77ba0fc6664ba7b2a80f782e662a46d432a28f1560393622025-05-07T03:54:28.000Zfalse0x1abb7ee08599c9a9d0b6ddb6ad5c9eec2fa8f96f654ce42688d93cf2744210510xacb54d07ca167934f57f829bee2cc665e1a5ebef24541950566818825963279
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_LiquidationCall_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_MintedToTreasury_event

Treasury fee minting events from ZeroLend V1 lending protocol on Linea, recording protocol revenue collected from reserve interest accrual. Tracks amounts minted to treasury by reserve asset for protocol revenue analysis.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountMintedSTRINGAmount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.
addressremovedlog_indexin_reserveblock_numberblock_timestampin_amountMintedtransaction_hash
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse490xacb54d07ca167934f57f829bee2cc665e1a5ebef52178402024-06-06T19:32:29.000Z2779283560306562381880xdfd433e59959b24de40fac8b5aa1066136f80fbca7803367b0dcdb46dcbe0f1d
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse460xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f52178402024-06-06T19:32:29.000Z19352345024250440xdfd433e59959b24de40fac8b5aa1066136f80fbca7803367b0dcdb46dcbe0f1d
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222dfalse410x176211869ca2b568f2a7d4ee941e073a821ee1ff52178402024-06-06T19:32:29.000Z31129860xdfd433e59959b24de40fac8b5aa1066136f80fbca7803367b0dcdb46dcbe0f1d
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_MintedToTreasury_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_Repay_event

Loan repayment events from ZeroLend V1 lending protocol on Linea, tracking amounts repaid, reserve addresses, and whether aTokens (interest-bearing tokens) were used for repayment. Used for analyzing borrower behavior, debt management patterns, and protocol liquidity flows.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_repayerSTRINGAddress of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_useATokensBOOLBoolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.
addressin_userremovedin_amountlog_indexin_repayerin_reserveblock_numberin_useATokensblock_timestamptransaction_hash
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x702e124a72ed4345343d8f4577136d957be2e819false203812577659119641560x702e124a72ed4345343d8f4577136d957be2e8190xacb54d07ca167934f57f829bee2cc665e1a5ebef19241862false2025-05-22T09:43:04.000Z0x0d296a471d1e2dc31852894cf6e57eb5c02018fa20d28dea4380e1075f5c7743
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x94759c0cdd84054a71c4b9746dcdee90783aca4ffalse150000000110x94759c0cdd84054a71c4b9746dcdee90783aca4f0x176211869ca2b568f2a7d4ee941e073a821ee1ff9992006false2024-09-27T02:55:37.000Z0xa07ade5f96281fb3837a2feb1df9a6277d368bfcb59213762a81131b9a22bb62
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xc8962e1139c5a4c0da6d5dd4a93ea5c825392467false54111635794025475814743210xc8962e1139c5a4c0da6d5dd4a93ea5c8253924670xacb54d07ca167934f57f829bee2cc665e1a5ebef10007966false2024-09-27T11:48:01.000Z0xc6bf4bb59728eca0dd1b2ab76948d74008f4808c0460445a68f57bc37adea65d
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_Repay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_Supply_event

Supply deposit events from ZeroLend v1 lending protocol on Linea, capturing when users deposit assets into lending pools. Contains user addresses, reserve tokens, deposit amounts, and optional referral codes for analyzing liquidity provision patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_onBehalfOfblock_timestampin_referralCodetransaction_hash
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x5a2781446dd2ba1f5f6fd6291863e7b4e79459b6false1599555970x176211869ca2b568f2a7d4ee941e073a821ee1ff206909630x5a2781446dd2ba1f5f6fd6291863e7b4e79459b62025-07-08T18:20:29.000Z00x0ea2a5dc313ec5842c87c84a2113faf376b1008d8b181789fe9217819576151b
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xd76c7cb048ed70f809d15f5d4c59a00c50e4c155false2062871309130x176211869ca2b568f2a7d4ee941e073a821ee1ff206776310xd76c7cb048ed70f809d15f5d4c59a00c50e4c1552025-07-08T08:07:00.000Z00x8e2ac30aeaaacafc08fa36fc76280f84380dced19a44f5aae967c2dfe1907810
0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xe58b8932b9016ea436f003bd216a6a22c1f608cafalse500000000170x176211869ca2b568f2a7d4ee941e073a821ee1ff206748780xe58b8932b9016ea436f003bd216a6a22c1f608ca2025-07-08T06:09:41.000Z00xcaff27879b5ea1d8871b8a26453e90c2e1790d346311df9bc44b7828c2a018c0
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_Supply_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolCroak_Withdraw_event

Withdrawal events from ZeroLend V1 lending protocol on Linea, capturing when users withdraw supplied assets from lending pools. Contains reserve token addresses, withdrawal amounts, and recipient details for analyzing liquidity flows and user behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressin_userremovedin_amountlog_indexin_reserveblock_numberblock_timestamptransaction_hash
0x52d463cd769743b7e6e102ce1ca9d126dee00e630xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0x52d463cd769743b7e6e102ce1ca9d126dee00e63false2294771200x176211869ca2b568f2a7d4ee941e073a821ee1ff82887432024-08-18T12:00:18.000Z0x9cb8977358594adee58e30c5f541542b2373aba9abe4a17fd8de928b39a262a9
0xcb4a20fe5f623ce09186c5b7a15c1c6cca60eb700xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xcb4a20fe5f623ce09186c5b7a15c1c6cca60eb70false246999993170x176211869ca2b568f2a7d4ee941e073a821ee1ff82751702024-08-18T04:27:42.000Z0xe35fca7ec69a47d92e270c0427ebf5310d0c5359791f45dc74efd839d4509ee8
0xe3f3ecb40218047910d43c51bf70219eaf3cd57f0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d0xe3f3ecb40218047910d43c51bf70219eaf3cd57ffalse10500000040x176211869ca2b568f2a7d4ee941e073a821ee1ff82939572024-08-18T14:54:12.000Z0xd1409306cf3292e41dbefa085f72226f20c6ef2a55a31e148789f15d4e3e6e08
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolCroak_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_Borrow_event

Borrow events from ZeroLend V1 lending protocol on Linea, recording when users take loans against collateral with reserve address, borrowed amount, interest rate mode, and referral codes. Used for analyzing borrowing activity, interest rate dynamics, and leverage patterns across different asset reserves.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
in_borrowRateSTRINGAnnual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_borrowRatein_onBehalfOfblock_timestampin_referralCodetransaction_hashin_interestRateMode
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x7f2e54d53258dc45b8581f11f924075146608d19false15000000000000000000000150x5fbdf89403270a1846f5ae7d113a989f850d15661593933540208215317300940684388560x7f2e54d53258dc45b8581f11f924075146608d192025-02-17T18:03:16.000Z00x4b5cfa2f7a00b76d88cde9175c770dd5f0690a70f9283d86d3785b10abe839052
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x9afa6e668430a6ef801ddbd55b070a2a8fb47ee4false8731307550819468186989390x5fbdf89403270a1846f5ae7d113a989f850d15661592641140496689136162638195001800x9afa6e668430a6ef801ddbd55b070a2a8fb47ee42025-02-17T10:36:43.000Z00x35d57ce606f2ab451e801d8d1d835c375d20dd4e31d572e1355653874ee4d8df2
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x9afa6e668430a6ef801ddbd55b070a2a8fb47ee4false400000000000000000000040x5fbdf89403270a1846f5ae7d113a989f850d15661593456539832629933103390829995980x9afa6e668430a6ef801ddbd55b070a2a8fb47ee42025-02-17T15:17:42.000Z00x9d591cc4db078297b247feeb18d8420f4050655899043bf3d6bb2bbbad9b115f2
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_FlashLoan_event

Flash loan events from ZeroLend V1 lending protocol on Linea, capturing uncollateralized loans with borrowed asset, amount, fees, and interest rate mode. Used for analyzing flash loan arbitrage activity and protocol fee generation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
in_premiumSTRINGFee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressremovedin_assetin_amountin_targetlog_indexin_premiumblock_numberin_initiatorblock_timestampin_referralCodetransaction_hashin_interestRateMode
0xbdaa004a456e7f2daff00ffcdcbead5da27b7966false0x5fbdf89403270a1846f5ae7d113a989f850d15665615719549887104000000xeff31d74852275f1d652ee10c9f3705d58065e0836063063320xeff31d74852275f1d652ee10c9f3705d58065e082024-07-03T14:08:57.000Z00xa019badbd18ab7c46153b021dcd809876dab1e8acc61f941499884b71f0b74672
0xbdaa004a456e7f2daff00ffcdcbead5da27b7966false0x5fbdf89403270a1846f5ae7d113a989f850d15665610664513048499000000xeff31d74852275f1d652ee10c9f3705d58065e0833063071360xeff31d74852275f1d652ee10c9f3705d58065e082024-07-03T14:35:45.000Z00x7b77dae93daca90f2d5ed0c524c6f6ad7bc1ba9dd5dd4e8c38ec93589bab258e2
0xbdaa004a456e7f2daff00ffcdcbead5da27b7966false0x5fbdf89403270a1846f5ae7d113a989f850d15666048394474244657000000xeff31d74852275f1d652ee10c9f3705d58065e0823063069110xeff31d74852275f1d652ee10c9f3705d58065e082024-07-03T14:28:15.000Z00x3737b21d2a37153111dd9816811fd3c34dc8f0a09034f3556bde4ddaaf013d2d2
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_LiquidationCall_event

Liquidation event logs from ZeroLend v1 lending protocol on Linea, capturing undercollateralized position liquidations with debt covered, collateral seized, and liquidator addresses. Used for analyzing liquidation activity, liquidator behavior, and protocol health metrics.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_collateralAssetSTRINGContract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtAssetSTRINGContract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtToCoverSTRINGAmount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
in_liquidatedCollateralAmountSTRINGAmount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
in_liquidatorSTRINGAddress of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiveATokenBOOLBoolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.
addressin_userremovedlog_indexblock_numberin_debtAssetin_liquidatorin_debtToCoverblock_timestampin_receiveATokentransaction_hashin_collateralAssetin_liquidatedCollateralAmount
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x5209db95e47eb90829db7eb17e71a8f34a502d48false11167480760x176211869ca2b568f2a7d4ee941e073a821ee1ff0x8e595231305efc7ef256679ad95847cb255ef8462881943002025-03-09T21:24:30.000Zfalse0xcc31d8f326ce147b0234ec4a52fdafcc971b85671bfb09d3f669dda72f30cddc0x5fbdf89403270a1846f5ae7d113a989f850d1566147300384493823077030311
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x3df883542ca0037346acff9417ff6a7d68204096false11167418440x176211869ca2b568f2a7d4ee941e073a821ee1ff0x8e595231305efc7ef256679ad95847cb255ef846378646032025-03-09T17:46:01.000Zfalse0xc8069221699271125afc24242fd9e3e44ff665cf1e4c24d9fdef0663b0f09f3a0x5fbdf89403270a1846f5ae7d113a989f850d156618727133745377448423475
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x41617e0d994f3fdf3b1e1eca531b317f4fc9374dfalse12167438690x176211869ca2b568f2a7d4ee941e073a821ee1ff0x30faa15737c88e925df41e89709763a2f84126ec230904592025-03-09T18:55:21.000Zfalse0xe28c60533093d8a42051527c4c959ffd5d4a503c239ebafbbd03eeb56d01ff7e0x5fbdf89403270a1846f5ae7d113a989f850d156611619922996664951363914
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_LiquidationCall_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_MintedToTreasury_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountMintedSTRINGAmount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_MintedToTreasury_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_Repay_event

Debt repayment events from ZeroLend v1 lending protocol on Linea, capturing borrower repayments with reserve addresses, amounts, and aToken usage flags. Tracks individual loan repayment transactions for analyzing borrowing behavior and protocol cash flow.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_repayerSTRINGAddress of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_useATokensBOOLBoolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.
addressin_userremovedin_amountlog_indexin_repayerin_reserveblock_numberin_useATokensblock_timestamptransaction_hash
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660xb5cf4338caa051a48b404570b74fc669a2dd4e69false2680171722443242954436140xb5cf4338caa051a48b404570b74fc669a2dd4e690x5fbdf89403270a1846f5ae7d113a989f850d156618336314false2025-04-24T09:31:25.000Z0xe770fb6dfa1343e5bad8f3c3132e50b646f323c2e40cec7cf93d60e8de3c0319
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x50e713fbea777262a3d5ccfb373692feb73adbf6false135008415147766888530740x50e713fbea777262a3d5ccfb373692feb73adbf60x5fbdf89403270a1846f5ae7d113a989f850d156618335926false2025-04-24T09:16:15.000Z0xe3ba9e8cfbe876c21db2736628eb346bca173cadab318cafb0460ec89e1ee353
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x524b917ea47a45181d768fca39741a059174640bfalse6003546769101200333447560x524b917ea47a45181d768fca39741a059174640b0x5fbdf89403270a1846f5ae7d113a989f850d15666514839false2024-07-08T10:01:16.000Z0xc81f7f32858d9b098e3291a9d310649ff8fe1c75ba17081e65041e3d17292c71
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_Repay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_Supply_event

Supply deposit events from ZeroLend v1 lending protocol on Linea, capturing when users deposit assets into reserves with amount, beneficiary, and optional referral tracking. Used for analyzing lending pool liquidity flows and user deposit behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_onBehalfOfblock_timestampin_referralCodetransaction_hash
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x59644e9f38afc4992e5e53d9d1c6b71e720c052efalse44600726602511315317540x5fbdf89403270a1846f5ae7d113a989f850d1566180111270x59644e9f38afc4992e5e53d9d1c6b71e720c052e2025-04-13T22:25:15.000Z00x679a925055faf45fa58fb12ba71149399da058822fb2e5feadb6cc82be6415ae
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x472bf5ff7b96033bd203b360403a0649a908dbe4false21368541725004116735651640x5fbdf89403270a1846f5ae7d113a989f850d1566180113080x472bf5ff7b96033bd203b360403a0649a908dbe42025-04-13T22:35:36.000Z00xb3e21e2da3b9ab3ab395add4130e56f4fb08b5330ac9377667557fb11d7372ad
0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x472bf5ff7b96033bd203b360403a0649a908dbe4false2470807112328876101249440x5fbdf89403270a1846f5ae7d113a989f850d1566180119120x472bf5ff7b96033bd203b360403a0649a908dbe42025-04-13T23:11:44.000Z00xc5d565ba507a1c73e1ad8b1cf0e52ec614a3c5f076a49d97e02b496dc1a4f91a
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_Supply_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolFoxy_Withdraw_event

Withdrawal events from ZeroLend lending protocol on Linea, capturing when users withdraw deposited assets from liquidity pools. Contains withdrawal amounts, reserve addresses, and recipient details for analyzing lending pool outflows and user withdrawal patterns.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressin_userremovedin_amountlog_indexin_reserveblock_numberblock_timestamptransaction_hash
0x59dd5cc35c15154cc1016d1d37b649ff38ee0a720xbdaa004a456e7f2daff00ffcdcbead5da27b79660x59dd5cc35c15154cc1016d1d37b649ff38ee0a72false100728842170x176211869ca2b568f2a7d4ee941e073a821ee1ff138011592024-12-26T10:46:44.000Z0x5061869ccf8bc52a6337626a8a848df9db1ba2668a396f4cbabddff92db74153
0xabc26230a9d1a5171f0553ed7aec24247be266a10xbdaa004a456e7f2daff00ffcdcbead5da27b79660xabc26230a9d1a5171f0553ed7aec24247be266a1false10318947260x176211869ca2b568f2a7d4ee941e073a821ee1ff138132752024-12-26T17:35:34.000Z0x3035392fbc924654c1f707829b21b8a7190fe4a2ad596014ac64907e87ad6c90
0x33bd8d5a4f40285df90694ccb29d6f5859c3977e0xbdaa004a456e7f2daff00ffcdcbead5da27b79660x33bd8d5a4f40285df90694ccb29d6f5859c3977efalse1216217405631965607272450x5fbdf89403270a1846f5ae7d113a989f850d1566138163122024-12-26T19:22:40.000Z0xc1ff6647b93170d44130e679c27fbb51f9a4f80ff919e02ca0259dbb20e20ef1
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolFoxy_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_Borrow_event

Borrow event logs from ZeroLend V1 lending protocol on Linea, capturing loan originations with borrowed amount, reserve asset, interest rate mode, and borrower addresses. Used for analyzing borrowing activity, interest rate dynamics, and debt positions across ZeroLend markets.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
in_borrowRateSTRINGAnnual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_borrowRatein_onBehalfOfblock_timestampin_referralCodetransaction_hashin_interestRateMode
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x6676ae96a46458f7307e432a86a26533ee970d1dfalse5000000040xa219439258ca9da29e9cc4ce5596924745e12b934126294912966165933182580497595940x6676ae96a46458f7307e432a86a26533ee970d1d2024-04-29T20:26:05.000Z00x7a501ab29d135fb4a4e5894abdcbd14c5025367b38cb07412e18a5930ad590092
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x009eed6c6a65ec46b9b1b9dd4b6140ea1ec707b3false332600000050x176211869ca2b568f2a7d4ee941e073a821ee1ff4103502928416048570402859925100820x009eed6c6a65ec46b9b1b9dd4b6140ea1ec707b32024-04-29T01:26:29.000Z00x8e0ddfb72a97802b39d469e487b3271e600ea0f52c43aada2e33b0a17d98ac682
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x024603c63bf4397c199514ffa32240aa417ce642false311900000050x176211869ca2b568f2a7d4ee941e073a821ee1ff41102771079172643413745602511894180x024603c63bf4397c199514ffa32240aa417ce6422024-04-29T07:05:14.000Z00xf7845581568a529f0a2ffc79e8b6f8e04c15fd1d26b7f2f45f257f385f5c17722
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_FlashLoan_event

Flash loan execution events from ZeroLend V1 lending protocol on Linea, recording borrowed asset, amount, premium fee, initiator, and target contract for each uncollateralized loan. Used for analyzing flash loan strategies, arbitrage activity, and protocol fee revenue.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_interestRateModeINT64Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
in_premiumSTRINGFee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressremovedin_assetin_amountin_targetlog_indexin_premiumblock_numberin_initiatorblock_timestampin_referralCodetransaction_hashin_interestRateMode
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false0xa219439258ca9da29e9cc4ce5596924745e12b9355036135400xa48cc0e4159c51d73b42c824f1444d1c1cbda531762751807197898520xa48cc0e4159c51d73b42c824f1444d1c1cbda5312025-06-08T10:11:32.000Z00xa3bc35bb8345afce44dfbb334f5af405b748a2ed709923e1f9ac535ea9f28ed80
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f587752502762910640x1808f504742e1b0a034fd12dbb6cfc609f3e5eb2372938762513814652552150x1808f504742e1b0a034fd12dbb6cfc609f3e5eb22024-06-08T02:44:06.000Z00xac288328f87a8b8d3e5bb2540e668b305eb0d2ba325730ab39d9af1cf0d948260
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false0x176211869ca2b568f2a7d4ee941e073a821ee1ff11007122320x8e595231305efc7ef256679ad95847cb255ef846141550356153607790x8e595231305efc7ef256679ad95847cb255ef8462025-02-03T02:04:53.000Z00x113b5697c3c24fe52da27f006588471b4055f6c5cbe10108c49964c11bfdd2600
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_LiquidationCall_event

Liquidation events from ZeroLend V1 lending protocol on Linea, recording when undercollateralized positions are liquidated with debt covered, collateral seized, and liquidator addresses. Used for analyzing protocol risk management, liquidation efficiency, and keeper bot activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_collateralAssetSTRINGContract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtAssetSTRINGContract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_debtToCoverSTRINGAmount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
in_liquidatedCollateralAmountSTRINGAmount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
in_liquidatorSTRINGAddress of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiveATokenBOOLBoolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.
addressin_userremovedlog_indexblock_numberin_debtAssetin_liquidatorin_debtToCoverblock_timestampin_receiveATokentransaction_hashin_collateralAssetin_liquidatedCollateralAmount
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x9c69efa7b85873628b4d9dcff30fa425eca7d047false21145295620x176211869ca2b568f2a7d4ee941e073a821ee1ff0x504bea28e5f95d3b7c0d45ea0a5547df2ee54ff739588762025-01-13T09:29:53.000Zfalse0x48ce241ff22c7d1cf6e26c0fbba90235df00a337d9aa828872a2013cf0f9d42c0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f1318567701150159
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690xe8b0929648b8b4239d76c880c75bc2469d126163false74145311280x176211869ca2b568f2a7d4ee941e073a821ee1ff0x504bea28e5f95d3b7c0d45ea0a5547df2ee54ff7133865922025-01-13T10:22:25.000Zfalse0xe9f90cf803b87abaf3495303297f6f2665b5d5fb88bec1f6dae6ca242bde27870xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f4481943682942732
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690xed900a6d68555abbf332cb9a12e5590477d00bb4false103145311300xa219439258ca9da29e9cc4ce5596924745e12b930x504bea28e5f95d3b7c0d45ea0a5547df2ee54ff751786472025-01-13T10:22:29.000Zfalse0xa11deb7d89673ac15dc02b789fea2d1bcfaeda967930b8a0973bf5ef9cc672bf0x93f4d0ab6a8b4271f4a28db399b5e30612d211161751945222979904
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_LiquidationCall_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_MintedToTreasury_event

Treasury fee collection events from ZeroLend lending protocol on Linea, recording protocol revenue minted as interest-bearing tokens for each reserve asset. Used for analyzing protocol fee generation and treasury accumulation across different collateral types.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountMintedSTRINGAmount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.
addressremovedlog_indexin_reserveblock_numberblock_timestampin_amountMintedtransaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false180x3aab2285ddcddad8edf438c1bab47e1a9d05a9b456749492024-06-18T23:00:04.000Z136960xb66ac9945971804b7a2c599943e2eb074ddfa589f0979a6465b5d8ec715dbb3b
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false60x4af15ec2a0bd43db75dd04e62faa3b8ef36b00d556749492024-06-18T23:00:04.000Z59141575996323031440xb66ac9945971804b7a2c599943e2eb074ddfa589f0979a6465b5d8ec715dbb3b
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269false210xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f56749492024-06-18T23:00:04.000Z11902219482068540xb66ac9945971804b7a2c599943e2eb074ddfa589f0979a6465b5d8ec715dbb3b
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_MintedToTreasury_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_Repay_event

Loan repayment events from ZeroLend V1 lending protocol on Linea, capturing borrower addresses, repaid amounts, reserve tokens, and whether aTokens were used for repayment. Used for tracking debt reduction activity and protocol cash flows.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_repayerSTRINGAddress of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_useATokensBOOLBoolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.
addressin_userremovedin_amountlog_indexin_repayerin_reserveblock_numberin_useATokensblock_timestamptransaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x080b42899afc59054b2fa71a71e505e9b46edd5cfalse1208334270x080b42899afc59054b2fa71a71e505e9b46edd5c0x176211869ca2b568f2a7d4ee941e073a821ee1ff20039219false2025-06-15T18:49:18.000Z0x1f71d1b1e151a8fc45f9ad9a788563c2658fe434652b5020129d448393d4104a
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x0a1eeac4aae7dc775819f4fc07d66970a0ba505bfalse31020807640x0a1eeac4aae7dc775819f4fc07d66970a0ba505b0x176211869ca2b568f2a7d4ee941e073a821ee1ff20029613false2025-06-15T11:49:37.000Z0x88a2d26c5e3ebf8d0756e207121608e78d1ad29b5d51a0bf2cb8054aa01f415a
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x0a1eeac4aae7dc775819f4fc07d66970a0ba505bfalse2440x0a1eeac4aae7dc775819f4fc07d66970a0ba505b0x176211869ca2b568f2a7d4ee941e073a821ee1ff20029621false2025-06-15T11:50:00.000Z0xd08f891d982bcd0260ffa4aaab35e956072f7ef225772f4622fb1e91d1af1049
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_Repay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_Supply_event

Supply deposit events from ZeroLend V1 lending protocol on Linea, capturing user deposits of reserve assets with amounts, recipient addresses, and optional referral codes. Used for tracking liquidity provision and analyzing lender behavior across different asset reserves.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressin_userremovedin_amountlog_indexin_reserveblock_numberin_onBehalfOfblock_timestampin_referralCodetransaction_hash
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x6366f25736dd2b563e1bd7a551b9b1191907940afalse803701870x176211869ca2b568f2a7d4ee941e073a821ee1ff214285050x6366f25736dd2b563e1bd7a551b9b1191907940a2025-07-29T16:30:32.000Z00xfcb97fa357a5ced1ba77d7d0d3365e17abe320924549c3ad854ceebacdd787ff
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690xcf2e146ac26691f5eae887ec7e88bc84f63211c2false31359815100x176211869ca2b568f2a7d4ee941e073a821ee1ff214081260xcf2e146ac26691f5eae887ec7e88bc84f63211c22025-07-29T04:39:47.000Z00x1781466ca00cf238366dcdbd3fccffe02c1c30ec40b850ee231b7412bbe5e576
0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x0e7fa1beebc77aac0a18160e226f4c1a510b251cfalse3980688526140x176211869ca2b568f2a7d4ee941e073a821ee1ff214389540x0e7fa1beebc77aac0a18160e226f4c1a510b251c2025-07-29T22:57:48.000Z00x31b6fb09f0594af9b22d3578d85dc773509d09dc2d7293f4b34fea05181148cf
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_Supply_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPoolMain_Withdraw_event

Withdrawal events from ZeroLend lending protocol on Linea, recording when users withdraw deposited assets from reserves. Contains user addresses, reserve token addresses, withdrawal amounts, and recipient addresses for analyzing liquidity movements and user behavior.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toaddressin_userremovedin_amountlog_indexin_reserveblock_numberblock_timestamptransaction_hash
0x597baf1a0b49a6abe86a08d5cdba7394712d6ac40x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x597baf1a0b49a6abe86a08d5cdba7394712d6ac4false45317480050x176211869ca2b568f2a7d4ee941e073a821ee1ff164939582025-03-03T11:58:43.000Z0xee3926c9902067c3f1b1c613bd093eb625716d2861ca88d6d7ef1689ee0b9a07
0x8949c04565078775e3f3e678f2010371322b25ee0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x8949c04565078775e3f3e678f2010371322b25eefalse51411372250x176211869ca2b568f2a7d4ee941e073a821ee1ff164908332025-03-03T10:08:35.000Z0xd986997e1d102a64d0304eda752a17d09aa82e6f0bb5c69d1ce0f24e02894ce3
0x2e905825c0814f7ac098a1c49f925ffecf56251e0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b2690x2e905825c0814f7ac098a1c49f925ffecf56251efalse38767833050x176211869ca2b568f2a7d4ee941e073a821ee1ff164949312025-03-03T12:32:47.000Z0xdde9d4f048f41c499b0c4417ba38238f6a327d5d89e3f82caabe6b8213f39607
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.LendingPoolMain_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

STokenCroak_Burn_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.STokenCroak_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

STokenCroak_Mint_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.STokenCroak_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

STokenFoxy_Burn_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_currentBalanceSTRINGUser’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_avgStableRateSTRINGAverage stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
in_newTotalSupplySTRINGUpdated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.STokenFoxy_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

STokenFoxy_Mint_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_currentBalanceSTRINGUser’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_newRateSTRINGUpdated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
in_avgStableRateSTRINGAverage stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
in_newTotalSupplySTRINGUpdated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.STokenFoxy_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

STokenMain_Burn_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_currentBalanceSTRINGUser’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_avgStableRateSTRINGAverage stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
in_newTotalSupplySTRINGUpdated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.STokenMain_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

STokenMain_Mint_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_currentBalanceSTRINGUser’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_newRateSTRINGUpdated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
in_avgStableRateSTRINGAverage stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
in_newTotalSupplySTRINGUpdated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.STokenMain_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VTokenCroak_Burn_event

Token burn events from ZeroLend V1 lending protocol on Linea, tracking the destruction of interest-bearing vTokens when users withdraw their deposited assets. Records include burn amounts, user addresses, and accrued interest for analyzing lending pool redemptions and yield generation.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x2b9881ddb5570ae9eba081fa7fdf334e4195e3de0x3ec4c6777f48dfdbac1ebf3ba6a264bd5172a890false110697359822023029305805551413000000000x0000000000000000000000000000000000000000199452972024-09-26T00:41:19.000Z0xd5265a4bc2812f5992f2f7ffd538232724825781344c960fda2dc831bd3f76174504877
0x2b9881ddb5570ae9eba081fa7fdf334e4195e3de0x8b1624c8b184edb4e7430194865490ba5e860f0cfalse1107496251179976523567301629200000000x0000000000000000000000000000000000000000199685012024-09-26T13:35:34.000Z0xb5f49e70821935b987b98c8fd6f9f4433425083221b16530c5bab86f70f16d26408989
0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc460xa67fe976fcbad6fb4e2092a4292a89a200ad602cfalse1038052930143893994885652805637710000000000000000000x00000000000000000000000000000000000000002599481862024-09-26T02:17:57.000Z0x7f018dfe37a7ed9ab6c2f67fdadfaeacde85d5bed760bba7941f72b5f7b3217869324775979182838610
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenCroak_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VTokenCroak_Mint_event

Interest-bearing token (vToken) minting events from ZeroLend V1 lending protocol on Linea, recording deposits with corresponding vToken issuance amounts and accrued interest. Tracks user supply activity and collateral position growth for lending market analysis.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46false1069977904177416008281849657121862727627007884484440xc8dce2be2d8847f23bfe00a62d6f818fd97a0f1346137984850xc8dce2be2d8847f23bfe00a62d6f818fd97a0f132024-12-26T09:17:14.000Z0x59eaecd6d06febbe0542ec22a13d44a5597f3c6afc67443493a3dfdb979c641f3070077464716532
0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46false1070013661674626223333968312376200000000000000000000xb205ce1cda3f7d45e7c1f1fbb84e909a29b89e0920138021260xb205ce1cda3f7d45e7c1f1fbb84e909a29b89e092024-12-26T11:19:06.000Z0x8936eb6d0deac3096570fcc13da08a2725e05d17fd8c930f44575ca7c1ddccc50
0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46false1069975242070890955225221122122700584724507145005500x7ee89840bf3bdf1bd9951077d62a73af230f90ed13137982130x7ee89840bf3bdf1bd9951077d62a73af230f90ed2024-12-26T09:08:10.000Z0xa855bfb30814bf35d9581fc4c4658a1c87be3d969519b08f3af3fb40797ba8e90
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenCroak_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VTokenFoxy_Burn_event

Burn events for vTokenFoxy (vFOXY) interest-bearing tokens on ZeroLend V1 lending protocol on Linea, recording when users withdraw their deposited FOXY tokens. Tracks redemption amounts, accrued interest, and account balances for analyzing lending protocol withdrawals and liquidity flows.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x384a318215aca36084af3719f3c84aa2167de6be0x67dc0cad9f5a12a4e5faa368a6aa7cd7fb6259c2false3208416921935672860040734357661516020x000000000000000000000000000000000000000062233441362025-09-15T03:31:47.000Z0xef3e47192d76263d2d6ed914fe65182e82483ec5765580645190d1ac8c616c7d268986
0x384a318215aca36084af3719f3c84aa2167de6be0x67dc0cad9f5a12a4e5faa368a6aa7cd7fb6259c2false3208422585627572312358201524486195370x000000000000000000000000000000000000000067233442152025-09-15T03:34:25.000Z0xfc5c1aa13b043bdd295cedebe6080d50fe6ca386b0d5c2cd5e4e90df7e8cb6c586
0x384a318215aca36084af3719f3c84aa2167de6be0xf2bc825fb466136d00571b496e6eb1a601679919false32110352607510136259174764784880x000000000000000000000000000000000000000017233807832025-09-15T23:54:57.000Z0x58ab2beff5e5b0d8dc9b8feba85b191a15a0828ae538050d4e20f0c7e918f9d30
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenFoxy_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VTokenFoxy_Mint_event

Interest-bearing token (vToken) mint events from ZeroLend V1 lending protocol on Linea, tracking deposits where users receive vTokens representing their supplied collateral with accrued interest tracked via balance increases and index values.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0x613ac3930a5b2805e48be151bea8c29d394f8a86false10637256861244203973245686796182544014176335853960470xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd2862231688240xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd282025-09-10T19:46:31.000Z0x3f83ba7fe0ee773eb1e280754ef68432f92236cf693c2531835bea09c4ba79510
0xfbb30e625ba0aa35c13a86ef49ab4f2bafa21538false2132441112825892872868094099300000500550694170xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28143231690460xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd282025-09-10T19:53:55.000Z0xec15ec98d4fc5136a32e38681e11803c933d70dbf287263817c7d968b79c672950055069417
0xfbb30e625ba0aa35c13a86ef49ab4f2bafa21538false21324407988862687092784324343400000000000000000xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd2834231689520xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd282025-09-10T19:50:47.000Z0x6f5ab5e25a0f8d766f192a3634ffa57d902c648e8d68a74e30441410d22ef9280
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenFoxy_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VTokenMain_Burn_event

Interest-bearing token burn events from ZeroLend V1 lending protocol on Linea, capturing when users withdraw deposited assets or repay borrowed amounts with accrued interest. Records include burned token amounts, balance increases from accumulated yield, and user addresses for tracking lending position changes.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuein_targetlog_indexblock_numberblock_timestamptransaction_hashin_balanceIncrease
0x476f206511a18c9956fc79726108a03e647a18170xabbbd0d907e0320ddd6874030749c64bd0f196c5false11827301928386596907709797184443305210x00000000000000000000000000000000000000001220309282025-08-14T13:09:29.000Z0x54f750a5868c251f10a3c80dc7bbcb184788997068283852cf9d1062a6890f278722628
0x476f206511a18c9956fc79726108a03e647a18170x1432a39a082417ab64410cdbc5632082d87038dafalse1182712084698940891405436055222027060x00000000000000000000000000000000000000004220247812025-08-14T09:44:23.000Z0xe55ba896a04a67a0e995c5f73e9dcce13cc09899eb16b250e0d3cdaffbb637d2185661
0x476f206511a18c9956fc79726108a03e647a18170xb63b67102fcd3681250173e37c5282f319a1cb4bfalse1182668186949257486005423684200487430x00000000000000000000000000000000000000006220101372025-08-14T01:34:27.000Z0x4c30d51b085ead890d1c4bf0dbfa743d4564d4f5a044287aa60459dce1418a3e166916
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenMain_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VTokenMain_Mint_event

Mint events from ZeroLend V1 lending protocol on Linea, tracking when users deposit assets and receive interest-bearing vTokens. Records deposit amounts, accrued interest balance increases, and the liquidity index for calculating yield on supplied collateral.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_callerSTRINGAddress that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_balanceIncreaseSTRINGAccrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressremovedin_indexin_valuein_callerlog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hashin_balanceIncrease
0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00false10080131220807533817705256021000000000000000000x2cd84c5a739c12202fe92b7ce488abf643578a3d1134933590x2cd84c5a739c12202fe92b7ce488abf643578a3d2024-12-19T02:22:30.000Z0x988625461dd109ce9614b394099882db78139a127caf973b87db8cf0a37468650
0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00false1008013884470145055415819818300000000000000000x9beb80af1f2e960877f1dc36dd81b7c2242e52ff1134990220x9beb80af1f2e960877f1dc36dd81b7c2242e52ff2024-12-19T05:34:12.000Z0x05645d7760ca752e9f8228a89ab214edf2bee2dce8317287c23e52a61d5d0dc80
0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00false100801439977521173143817571130000000000000000xc473582f9f75d242548c5abed09bdfa523a01b851135028860xc473582f9f75d242548c5abed09bdfa523a01b852024-12-19T07:43:39.000Z0x2ea7eac5e02bd92ce7d23d2976f318317785d86a41a598f93de6f496252ed4d90
Query with partition filter
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenMain_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100