> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# zerolend_v1_linea
> Tables in tt-contracts.zerolend_v1_linea
## 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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | in\_from | removed | in\_index | in\_value | in\_target | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | ------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x176e1e2be1704bf5cf9c55d5ac2282355355b8d0 | 0x60f97315200815dbdd003fac19e94e68cacb6230 | false | 1009335643846065160238144535 | 100069184142227333 | 0x60f97315200815dbdd003fac19e94e68cacb6230 | 32 | 23377236 | 2025-09-15T21:56:02.000Z | 0xdbee4e4f3ceb837988ce133f42b40e0e2003fd71c78d12b0a0316c74f5f807c1 | 0 |
| 0x176e1e2be1704bf5cf9c55d5ac2282355355b8d0 | 0x60f97315200815dbdd003fac19e94e68cacb6230 | false | 1009324580151302220222091391 | 400000000000000000 | 0x60f97315200815dbdd003fac19e94e68cacb6230 | 10 | 23343073 | 2025-09-15T02:56:19.000Z | 0x21bd56cca9c2d761f965af085ff394d23b33df14f17beea7e80d342913965277 | 0 |
| 0x176e1e2be1704bf5cf9c55d5ac2282355355b8d0 | 0x60f97315200815dbdd003fac19e94e68cacb6230 | false | 1009330944222487235813858345 | 25131933610342119 | 0x60f97315200815dbdd003fac19e94e68cacb6230 | 70 | 23362603 | 2025-09-15T13:47:26.000Z | 0x8ed0f71ad022e19593c0fa0a1b94bbfb66c0e96e2acda297cfe7a1566c69e268 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_underlyingAsset` | `STRING` | Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_treasury` | `STRING` | Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_incentivesController` | `STRING` | Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_aTokenDecimals` | `INT64` | Number of decimal places for the AToken. Integer value representing the divisibility of the token amount. |
| `in_aTokenName` | `STRING` | Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern "Aave \[Chain] \[Asset]" or "\[Protocol] \[Asset]". |
| `in_aTokenSymbol` | `STRING` | Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like "aArb\[Asset]", "aEth\[Asset]", "aBnb\[Asset]", or protocol-specific variants. |
| `in_params` | `STRING` | Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations. |
| address | in\_pool | removed | in\_params | log\_index | in\_treasury | block\_number | in\_aTokenName | block\_timestamp | in\_aTokenSymbol | transaction\_hash | in\_aTokenDecimals | in\_underlyingAsset | in\_incentivesController |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x711449ea0f3c6d9e1626e72aa431597b9216f3d4 | 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 0x10 | 23 | 0xbbe092a8cf3bfa489f933ce69ea138ca1eea2bbf | 5091012 | ZeroLendCROAK USDC | 2024-06-02T09:46:20.000Z | z0USDC | 0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1 | 6 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x9c368e7a8a606e1603f798a76ccc722b52ec4578 |
| 0x176e1e2be1704bf5cf9c55d5ac2282355355b8d0 | 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 0x10 | 27 | 0xbbe092a8cf3bfa489f933ce69ea138ca1eea2bbf | 5091012 | ZeroLendCROAK WETH | 2024-06-02T09:46:20.000Z | z0WETH | 0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1 | 18 | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 0x9c368e7a8a606e1603f798a76ccc722b52ec4578 |
| 0xe59691dd4b38ba4632a51d1f7596c431ad36907c | 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 0x10 | 31 | 0xbbe092a8cf3bfa489f933ce69ea138ca1eea2bbf | 5091012 | ZeroLendCROAK CROAK | 2024-06-02T09:46:20.000Z | z0CROAK | 0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1 | 18 | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 0x9c368e7a8a606e1603f798a76ccc722b52ec4578 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | removed | in\_index | in\_value | in\_caller | log\_index | block\_number | in\_onBehalfOf | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------- | ---------------------------- | ------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | --------------------- |
| 0xe59691dd4b38ba4632a51d1f7596c431ad36907c | false | 1001024694004445199016191456 | 19078960556531853830139 | 0x04069ed1e8c500ce3f0785d082d4fe470ce03b4e | 3 | 12168794 | 0x04069ed1e8c500ce3f0785d082d4fe470ce03b4e | 2024-11-17T07:40:02.000Z | 0xb60f955f43b6054dcdc6c4f6a8bd09518dce6ed525caf1f225e7b6eeeeb2aa11 | 24122258837134387195 |
| 0xe59691dd4b38ba4632a51d1f7596c431ad36907c | false | 1001025704907834604969092579 | 20769313830628226936574 | 0x18143345e0414e48fe0b3b09343a049e280321f6 | 15 | 12183532 | 0x18143345e0414e48fe0b3b09343a049e280321f6 | 2024-11-17T15:52:38.000Z | 0xd72f95619a7bcb9e3b082e6aa19d052921bf9209add594b3c94d929f94b1ff9b | 0 |
| 0xe59691dd4b38ba4632a51d1f7596c431ad36907c | false | 1001024828238616298159023163 | 715111699693608810524900 | 0x2c21dc4fe422fbadd7dc1eda8ac4d10a8d9ffa2e | 11 | 12170811 | 0x2c21dc4fe422fbadd7dc1eda8ac4d10a8d9ffa2e | 2024-11-17T08:47:16.000Z | 0x6d60aab719c9d3d13704a55efb931cd306e6cd3d40f26b88879381f9b890b4a6 | 679328047140303606189 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | in\_from | removed | in\_index | in\_value | in\_target | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | ----------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | false | 1019667019668833759427956951 | 40100000000000000 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | 19 | 12957765 | 2024-12-06T04:37:07.000Z | 0x4a97fcf2a9e77e2e8e95059330391aae369cbf0a29f61c45a557c13346524e41 | 0 |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | false | 1019667752745033778611429836 | 50000000000000000 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | 34 | 12962355 | 2024-12-06T07:23:05.000Z | 0x13cac6e02d81c8e8625fbaee067575ff634d5d2f2c93fb1eb13973c40fd2871e | 0 |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | false | 1019667975702948641391489814 | 42358000000000000 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | 12 | 12963815 | 2024-12-06T08:14:21.000Z | 0x48cf7635d674e15cac98c0a42469ce66577286732425943e97d0aed3f6cadf2c | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_underlyingAsset` | `STRING` | Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_treasury` | `STRING` | Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_incentivesController` | `STRING` | Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_aTokenDecimals` | `INT64` | Number of decimal places for the AToken. Integer value representing the divisibility of the token amount. |
| `in_aTokenName` | `STRING` | Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern "Aave \[Chain] \[Asset]" or "\[Protocol] \[Asset]". |
| `in_aTokenSymbol` | `STRING` | Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like "aArb\[Asset]", "aEth\[Asset]", "aBnb\[Asset]", or protocol-specific variants. |
| `in_params` | `STRING` | Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations. |
| address | in\_pool | removed | in\_params | log\_index | in\_treasury | block\_number | in\_aTokenName | block\_timestamp | in\_aTokenSymbol | transaction\_hash | in\_aTokenDecimals | in\_underlyingAsset | in\_incentivesController |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ----------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | false | 0x10 | 24 | 0x14aad4668de2115e30a5feee42cfa436899ccd8a | 5219143 | ZeroLendFoxy WETH | 2024-06-06T20:37:38.000Z | z0WETH | 0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af | 18 | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 0x98f4c6e15cdcd7e5b36e53a249868a46c4f0105e |
| 0xd84a3f1380ec35ab4cdb16a95508a11f2f474356 | 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | false | 0x10 | 28 | 0x14aad4668de2115e30a5feee42cfa436899ccd8a | 5219143 | ZeroLendFoxy FOXY | 2024-06-06T20:37:38.000Z | z0FOXY | 0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af | 18 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 0x98f4c6e15cdcd7e5b36e53a249868a46c4f0105e |
| 0xdae1f8cfd0293bd3ef2541ccb4f265290181cac2 | 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | false | 0x10 | 20 | 0x14aad4668de2115e30a5feee42cfa436899ccd8a | 5219143 | ZeroLendFoxy USDC | 2024-06-06T20:37:38.000Z | z0USDC | 0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af | 6 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x98f4c6e15cdcd7e5b36e53a249868a46c4f0105e |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | removed | in\_index | in\_value | in\_caller | log\_index | block\_number | in\_onBehalfOf | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------- | ---------------------------- | --------------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | false | 1020534943955511871166594178 | 140866114943108 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | 2 | 17823796 | 0xe59448cea4b0ea756ae3493cabb7388daeb2bc67 | 2025-04-08T05:34:28.000Z | 0x3d2da37dd66efc35cdd7d8b4f58f7582913984012165c366c20ce84709ec9641 | 140866114943108 |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | false | 1020535221148407304431462800 | 126359668972702 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | 2 | 17830027 | 0x4f8b8afd3b707c7a365a0beeacb429ad28557d99 | 2025-04-08T09:52:27.000Z | 0x8b55e38d7b1fb75483f038856b8c7358fc91f2fdbe4715f10b4c54ee9239832a | 126359668972702 |
| 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | false | 1020534701260398193420730603 | 10005789036559 | 0x405bda48cab999865688eb1f5129c29a9cb0cde1 | 44 | 17818631 | 0x8d9957b8739237a156f9002e070d04893b7865f1 | 2025-04-08T01:43:32.000Z | 0xb176b03b2a1da4985b8a032b4e955732604da0b8b65594339ca9ca5dbd669977 | 10005789036559 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | in\_from | removed | in\_index | in\_value | in\_target | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | ------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x03114e4c29ea95bf26108c2c47338488555ced1a | 0x359b617fa1a4f180f985dea63eb6fe4a3d7c52a1 | false | 1000000000000000000000000000 | 5000000000000000 | 0x359b617fa1a4f180f985dea63eb6fe4a3d7c52a1 | 57 | 11146769 | 2024-10-24T07:16:54.000Z | 0x1636ceed9e29738ad347bea05a001bff6f34435b7c7c1e147181337d44bd08b0 | 0 |
| 0x8d8b70a576113feedd7e3810ce61f5e243b01264 | 0xe40a8cd800d2ed6eeaaf3f522c0be4d72dd6cb4b | false | 1000143604105977394168754695 | 8500000000000000 | 0xe40a8cd800d2ed6eeaaf3f522c0be4d72dd6cb4b | 59 | 11136785 | 2024-10-24T01:44:01.000Z | 0x7470e074efe9898efb7598b62e9f2263e3540fed421777632155075d749df967 | 117307330614 |
| 0x8d8b70a576113feedd7e3810ce61f5e243b01264 | 0x3a729e3ab72ebd8c2d4f6cf784e753c85e3610a8 | false | 1000143770477383141949090800 | 118765366313237192 | 0x3a729e3ab72ebd8c2d4f6cf784e753c85e3610a8 | 53 | 11141728 | 2024-10-24T04:28:48.000Z | 0xaa0de8008f855e6d57dc4a36755d6e415d29d2e574118cfb514b7f63b706ee04 | 16310455426519 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_underlyingAsset` | `STRING` | Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_pool` | `STRING` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_treasury` | `STRING` | Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_incentivesController` | `STRING` | Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_aTokenDecimals` | `INT64` | Number of decimal places for the AToken. Integer value representing the divisibility of the token amount. |
| `in_aTokenName` | `STRING` | Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern "Aave \[Chain] \[Asset]" or "\[Protocol] \[Asset]". |
| `in_aTokenSymbol` | `STRING` | Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like "aArb\[Asset]", "aEth\[Asset]", "aBnb\[Asset]", or protocol-specific variants. |
| `in_params` | `STRING` | Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations. |
| address | in\_pool | removed | in\_params | log\_index | in\_treasury | block\_number | in\_aTokenName | block\_timestamp | in\_aTokenSymbol | transaction\_hash | in\_aTokenDecimals | in\_underlyingAsset | in\_incentivesController |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ----------------------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x77e305b4d4d3b9da4e82cefd564f5b948366a44b | 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 0x10 | 6 | 0x89fec31dad373922879bd6279ccdc3666c5d1b7a | 4460683 | ZeroLend Wrapper Ether.fi ETH | 2024-05-11T11:07:38.000Z | z0weETH | 0x008755fd11f9a5d34c8e0b2ddc7f146d80fe1ca9ff3159801538b46827fa17a9 | 18 | 0x1bf74c010e6320bab11e2e5a532b5ac15e0b8aa6 | 0x28f6899ff643261ca9766ddc251b359a2d00b945 |
| 0x8d8b70a576113feedd7e3810ce61f5e243b01264 | 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 0x10 | 10 | 0x89fec31dad373922879bd6279ccdc3666c5d1b7a | 4460563 | ZeroLend Kelp rsETH | 2024-05-11T11:01:38.000Z | z0rsETH | 0x295df4fcdc569405ad38a3afd40fcdc8cb43c881f34e7e69fff9f9ef3f703494 | 18 | 0xd2671165570f41bbb3b0097893300b6eb6101e6c | 0x28f6899ff643261ca9766ddc251b359a2d00b945 |
| 0x0ab214f127998a36ce7ab0087a9b0d20adc2d5ad | 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 0x10 | 13 | 0x89fec31dad373922879bd6279ccdc3666c5d1b7a | 3598292 | ZeroLend Wrapper BTC | 2024-04-11T12:22:37.000Z | z0WBTC | 0x224738865889822fe81e2af0b19b1588a1bfe604bb11409ecafc16d5334a707c | 18 | 0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4 | 0x28f6899ff643261ca9766ddc251b359a2d00b945 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | removed | in\_index | in\_value | in\_caller | log\_index | block\_number | in\_onBehalfOf | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------- | ---------------------------- | ----------------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x03114e4c29ea95bf26108c2c47338488555ced1a | false | 1000000000000000000000000000 | 95600000000000000 | 0xbcf37b6a9fd5cbfb25d75c009c0054950d351a03 | 5 | 8918012 | 0xbcf37b6a9fd5cbfb25d75c009c0054950d351a03 | 2024-09-02T04:14:47.000Z | 0x8d69366a1556b3f5bd2fe09250e434e1a471ee15f5e058fefd3a6c8873e13c2e | 0 |
| 0x03114e4c29ea95bf26108c2c47338488555ced1a | false | 1000000000000000000000000000 | 35000000000000000 | 0x6fd3acc52b08ccdfb4f10b6fd06cbaa1d6b04fe0 | 16 | 8926389 | 0x6fd3acc52b08ccdfb4f10b6fd06cbaa1d6b04fe0 | 2024-09-02T08:54:01.000Z | 0xca12eb5ba9c26188df8a461973f626635f91368f6207fbf4ea67c16c79ef8dfb | 0 |
| 0x03114e4c29ea95bf26108c2c47338488555ced1a | false | 1000000000000000000000000000 | 20000000000000000 | 0x3614dc430166214109c8ce488c04309056310c32 | 59 | 8925535 | 0x3614dc430166214109c8ce488c04309056310c32 | 2024-09-02T08:25:33.000Z | 0xda4e5a64f273f6cae6545b80017b5327673fecc8a183ce084e0aa61e282d8b4f | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldReserveFactor` | `STRING` | Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%. |
| `in_newReserveFactor` | `STRING` | Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%. |
| address | removed | in\_asset | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newReserveFactor | in\_oldReserveFactor |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
| 0x03dee3b6512fc2c4aced439995c01facbc13a48c | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 29 | 5092717 | 2024-06-02T11:11:35.000Z | 0x9d1427579b7549d9e3c5e629fa6f304802ffca34f531c8ecd034cbd66f15204a | 3000 | 5000 |
| 0x03dee3b6512fc2c4aced439995c01facbc13a48c | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 142 | 5091017 | 2024-06-02T09:46:35.000Z | 0xdb9f8008c3653978fb98c0b95ed7cb6bbeee797886e4b20c1974a08aaf37c0ac | 5000 | 0 |
| 0x03dee3b6512fc2c4aced439995c01facbc13a48c | false | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 156 | 5091017 | 2024-06-02T09:46:35.000Z | 0xdb9f8008c3653978fb98c0b95ed7cb6bbeee797886e4b20c1974a08aaf37c0ac | 3000 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_aToken` | `STRING` | Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_stableDebtToken` | `STRING` | Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_variableDebtToken` | `STRING` | Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_interestRateStrategyAddress` | `STRING` | Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_asset | in\_aToken | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_stableDebtToken | in\_variableDebtToken | in\_interestRateStrategyAddress |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x03dee3b6512fc2c4aced439995c01facbc13a48c | false | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 0xe59691dd4b38ba4632a51d1f7596c431ad36907c | 34 | 5091012 | 2024-06-02T09:46:20.000Z | 0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1 | 0x5d30efee91787133ecacf1ca40808123382adc8f | 0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46 | 0x18cb9aecfaab5894219f683ebe66883d0b2e6c64 |
| 0x03dee3b6512fc2c4aced439995c01facbc13a48c | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 0x176e1e2be1704bf5cf9c55d5ac2282355355b8d0 | 30 | 5091012 | 2024-06-02T09:46:20.000Z | 0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1 | 0x86453bd0075dc4b5f255a3679f0c9475107847d9 | 0x5c8957af6341d824d615fabacb3dbab75932695b | 0x18cb9aecfaab5894219f683ebe66883d0b2e6c64 |
| 0x03dee3b6512fc2c4aced439995c01facbc13a48c | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x711449ea0f3c6d9e1626e72aa431597b9216f3d4 | 26 | 5091012 | 2024-06-02T09:46:20.000Z | 0x059bbe2737bd17d76b73090b5b8069428a7f6229f5f6087cc918d6511a69d2f1 | 0x8cb14e515a98fc3ba7495867ef2e6450cf12c2aa | 0x2b9881ddb5570ae9eba081fa7fdf334e4195e3de | 0xfbc45e0f8215668460577afc4b477faf020fa5d2 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_ltv` | `STRING` | Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%. |
| `in_liquidationThreshold` | `STRING` | Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%. |
| `in_liquidationBonus` | `STRING` | Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%. |
| in\_ltv | address | removed | in\_asset | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_liquidationBonus | in\_liquidationThreshold |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | ------------------------ |
| 3000 | 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 54 | 5219224 | 2024-06-06T20:41:41.000Z | 0x7b8f2d7a2f83a8e7167341d3f56fc451e8747aa9e86020b0e79c108bc675cdc6 | 11000 | 8000 |
| 8000 | 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 47 | 5219224 | 2024-06-06T20:41:41.000Z | 0x7b8f2d7a2f83a8e7167341d3f56fc451e8747aa9e86020b0e79c108bc675cdc6 | 11000 | 9000 |
| 8000 | 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 40 | 5219224 | 2024-06-06T20:41:41.000Z | 0x7b8f2d7a2f83a8e7167341d3f56fc451e8747aa9e86020b0e79c108bc675cdc6 | 11000 | 9000 |
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldFee` | `STRING` | Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%. |
| `in_newFee` | `STRING` | Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldReserveFactor` | `STRING` | Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%. |
| `in_newReserveFactor` | `STRING` | Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%. |
| address | removed | in\_asset | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newReserveFactor | in\_oldReserveFactor |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
| 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 5 | 5220314 | 2024-06-06T21:36:11.000Z | 0xb7a0cfb2e286007070185c2c61dee3628372e8351dc724c576890229188b4a16 | 2000 | 5000 |
| 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 5 | 5220322 | 2024-06-06T21:36:35.000Z | 0xe6db4bc1fe840f91c34a7beb6b4054ced979abbd4eabb6521ca94881de556d2b | 2000 | 5000 |
| 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 4 | 5220324 | 2024-06-06T21:36:41.000Z | 0x452134dc096b602304621c7adb2b2b0ee479e474df1452588490c07c27aea07c | 2000 | 3000 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_aToken` | `STRING` | Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_stableDebtToken` | `STRING` | Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_variableDebtToken` | `STRING` | Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_interestRateStrategyAddress` | `STRING` | Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_asset | in\_aToken | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_stableDebtToken | in\_variableDebtToken | in\_interestRateStrategyAddress |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 0xd84a3f1380ec35ab4cdb16a95508a11f2f474356 | 31 | 5219143 | 2024-06-06T20:37:38.000Z | 0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af | 0xb490091282a566d4b6d466c7cb5f0cc0a8c3d230 | 0x613ac3930a5b2805e48be151bea8c29d394f8a86 | 0x1e62b7782e489dfffd582b88705eb6f66a2982df |
| 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0xdae1f8cfd0293bd3ef2541ccb4f265290181cac2 | 23 | 5219143 | 2024-06-06T20:37:38.000Z | 0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af | 0x0aa52b766999bd7570c5999f2e5e7c0989c5f79f | 0x384a318215aca36084af3719f3c84aa2167de6be | 0x5418c519393c4f7b94fdbbda11c63b1e4eea9e1a |
| 0xb86cf9aaf4f512f4e72794850796149562e3cc7e | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 0x9cab55d186a45bb29fabdbc0118855cf642d8012 | 27 | 5219143 | 2024-06-06T20:37:38.000Z | 0x110a3f76fe9047f117c9f2a0c32fd730f015de773c98e6cb3c4c3f92445164af | 0xf6f54eb569dc28e68c35a640846f0ce70c2ac86b | 0xfbb30e625ba0aa35c13a86ef49ab4f2bafa21538 | 0x5418c519393c4f7b94fdbbda11c63b1e4eea9e1a |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_ltv` | `STRING` | Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%. |
| `in_liquidationThreshold` | `STRING` | Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%. |
| `in_liquidationBonus` | `STRING` | Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%. |
| in\_ltv | address | removed | in\_asset | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_liquidationBonus | in\_liquidationThreshold |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | ------------------------ |
| 5000 | 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x5a7a183b6b44dc4ec2e3d2ef43f98c5152b1d76d | 11 | 4630878 | 2024-05-17T08:58:58.000Z | 0x3716f459e048b25a6a663321acc792db798089c9f6c7b053c57c7f9bd1811031 | 11000 | 8000 |
| 7000 | 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f | 21 | 4629996 | 2024-05-17T08:14:52.000Z | 0x9f77ebae9b4e74f1c3f4344b763a39c94e8bfeb78570a39965073c1e60b9d587 | 11000 | 8000 |
| 7000 | 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2 | 19 | 4629996 | 2024-05-17T08:14:52.000Z | 0x9f77ebae9b4e74f1c3f4344b763a39c94e8bfeb78570a39965073c1e60b9d587 | 11000 | 8000 |
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldFee` | `STRING` | Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%. |
| `in_newFee` | `STRING` | Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldReserveFactor` | `STRING` | Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%. |
| `in_newReserveFactor` | `STRING` | Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%. |
| address | removed | in\_asset | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newReserveFactor | in\_oldReserveFactor |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
| 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef34 | 12 | 7007942 | 2024-07-19T19:58:53.000Z | 0xc87c8d93f29b9fcf91739112ca765773a4823d1f9bbd1af50ceb86a8e664526d | 5000 | 1500 |
| 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4 | 13 | 7007942 | 2024-07-19T19:58:53.000Z | 0xc87c8d93f29b9fcf91739112ca765773a4823d1f9bbd1af50ceb86a8e664526d | 5000 | 1500 |
| 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x4af15ec2a0bd43db75dd04e62faa3b8ef36b00d5 | 9 | 7007942 | 2024-07-19T19:58:53.000Z | 0xc87c8d93f29b9fcf91739112ca765773a4823d1f9bbd1af50ceb86a8e664526d | 5000 | 1500 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_aToken` | `STRING` | Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_stableDebtToken` | `STRING` | Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_variableDebtToken` | `STRING` | Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_interestRateStrategyAddress` | `STRING` | Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_asset | in\_aToken | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_stableDebtToken | in\_variableDebtToken | in\_interestRateStrategyAddress |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x5a7a183b6b44dc4ec2e3d2ef43f98c5152b1d76d | 0x4585cbe390df68cbaa36c0d0886e8528c31c7c11 | 15 | 4630828 | 2024-05-17T08:56:28.000Z | 0x45a835816b7db21c021e7db0815f97067d8a7de62ad585fb5bd43e9d97f45b7c | 0x705b5ee015f12fc29066b1e5214a2cac702211fa | 0x53a44b6384c28c099dc168fd1d9044105e23c632 | 0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e |
| 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0xecc68d0451e20292406967fe7c04280e5238ac7d | 0x1820335eba09b72ce46c0de4650f71c7505b4824 | 93 | 4629836 | 2024-05-17T08:06:52.000Z | 0xa8a5b5b33d91b62ba4f47105ba27d148195844ab42be12f8a6059a953fe0f426 | 0x9861087fe7f894c52efc7b9e12bfaba57fd03961 | 0x06ecdfde2d468aed563d5765356b6def4901b6bc | 0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e |
| 0xf17218b09699d0f7145e40e771e72130ff616498 | false | 0x211cc4dd073734da055fbf44a2b4667d5e5fe5d2 | 0x5c44c9e5182193ce4e24b8f85c9c914c59d57767 | 42 | 4629836 | 2024-05-17T08:06:52.000Z | 0xa8a5b5b33d91b62ba4f47105ba27d148195844ab42be12f8a6059a953fe0f426 | 0x0410fb2330217120ed8e9590543e1c0ea9a00e70 | 0x068b5441787b0b973e25d5dbdacb7a7c2161af51 | 0x0f9bfa294be6e3ca8c39221bb5dfb88032c8936e |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_interestRateMode` | `INT64` | Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate. |
| `in_borrowRate` | `STRING` | Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places). |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | in\_borrowRate | in\_onBehalfOf | block\_timestamp | in\_referralCode | transaction\_hash | in\_interestRateMode |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | --------------------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x312fc6d761b5f4680b5f0cc5a8e2804f647c2041 | false | 30000000 | 34 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 8196544 | 364588780586789723738056167 | 0x312fc6d761b5f4680b5f0cc5a8e2804f647c2041 | 2024-08-16T08:41:18.000Z | 0 | 0xfd895b69c3f1e2069ef127dad643a31ced2f6f43499177cc5b719d5b2146a499 | 2 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x644002353c54cb8d3e851bbdb3fd17c0392430d6 | false | 532000000 | 39 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 8199199 | 376423662746966437195492164 | 0x644002353c54cb8d3e851bbdb3fd17c0392430d6 | 2024-08-16T10:09:50.000Z | 0 | 0x790b58e7dccfa915ecc987f28812d774382c64f97111b2031176c612083c1e32 | 2 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xfc101da61af4bc33189e6f8e58dc150eb13f5099 | false | 4250000000 | 6 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 8209871 | 428081573619857257323242747 | 0xfc101da61af4bc33189e6f8e58dc150eb13f5099 | 2024-08-16T16:05:34.000Z | 0 | 0x8ed5759677b9cb2bbeecc34b6ac87e2712f69652392d7e425757122f2dafd615 | 2 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_interestRateMode` | `INT64` | Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate. |
| `in_premium` | `STRING` | Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset. |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | removed | in\_asset | in\_amount | in\_target | log\_index | in\_premium | block\_number | in\_initiator | block\_timestamp | in\_referralCode | transaction\_hash | in\_interestRateMode |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 1100000000000000 | 0x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e | 35 | 550000000000 | 5516182 | 0x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e | 2024-06-15T06:41:19.000Z | 0 | 0x5ff22211de0ab10da86d12a9511b7bfec566c592c15bfdd20b5558e43e359999 | 0 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 1430000000000000 | 0x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e | 64 | 715000000000 | 5527580 | 0x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e | 2024-06-15T13:01:16.000Z | 0 | 0x5d2170a6f37d0f7015a458d67e979118abb67fd266178a640f39951875223704 | 0 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 3960000000000000 | 0x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e | 54 | 1980000000000 | 5489492 | 0x17f3ef25e6ecaa9a7e1a95f95a0473e5bd44fc9e | 2024-06-14T15:51:36.000Z | 0 | 0x144a3bd2dd75a30b3f190d9a0148a4439cff71bb1670c9a8d32e1cc41aa17842 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_collateralAsset` | `STRING` | Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtAsset` | `STRING` | Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtToCover` | `STRING` | Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset's smallest unit. |
| `in_liquidatedCollateralAmount` | `STRING` | Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset's smallest unit. |
| `in_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiveAToken` | `BOOL` | Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation. |
| address | in\_user | removed | log\_index | block\_number | in\_debtAsset | in\_liquidator | in\_debtToCover | block\_timestamp | in\_receiveAToken | transaction\_hash | in\_collateralAsset | in\_liquidatedCollateralAmount |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | --------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------ |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xc55720f140337755346ca0bccb5ab3e2e07d27c3 | false | 59 | 18745452 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x77ba0fc6664ba7b2a80f782e662a46d432a28f15 | 9757846 | 2025-05-07T02:51:23.000Z | false | 0x84bf5fa74667a7df111abab5260226eb7d3e0d5f1b78190cce42d1d5293e2042 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 10733631 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x67c9ac4a17a1e874d95c91e35abf28756572a8b4 | false | 12 | 18746937 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x77ba0fc6664ba7b2a80f782e662a46d432a28f15 | 3005645 | 2025-05-07T03:54:30.000Z | false | 0x6c392542ea67e420d0ef797facf14147b68630212cd7c2995a115f2a9a8c57e0 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 3306210 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x2b2a3d642758526def7e2f165a4d567620d63781 | false | 16 | 18746936 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x77ba0fc6664ba7b2a80f782e662a46d432a28f15 | 6039362 | 2025-05-07T03:54:28.000Z | false | 0x1abb7ee08599c9a9d0b6ddb6ad5c9eec2fa8f96f654ce42688d93cf274421051 | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 24541950566818825963279 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountMinted` | `STRING` | Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value. |
| address | removed | log\_index | in\_reserve | block\_number | block\_timestamp | in\_amountMinted | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 49 | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 5217840 | 2024-06-06T19:32:29.000Z | 277928356030656238188 | 0xdfd433e59959b24de40fac8b5aa1066136f80fbca7803367b0dcdb46dcbe0f1d |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 46 | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 5217840 | 2024-06-06T19:32:29.000Z | 1935234502425044 | 0xdfd433e59959b24de40fac8b5aa1066136f80fbca7803367b0dcdb46dcbe0f1d |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | false | 41 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 5217840 | 2024-06-06T19:32:29.000Z | 3112986 | 0xdfd433e59959b24de40fac8b5aa1066136f80fbca7803367b0dcdb46dcbe0f1d |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_repayer` | `STRING` | Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_useATokens` | `BOOL` | Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset. |
| address | in\_user | removed | in\_amount | log\_index | in\_repayer | in\_reserve | block\_number | in\_useATokens | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x702e124a72ed4345343d8f4577136d957be2e819 | false | 2038125776591196415 | 6 | 0x702e124a72ed4345343d8f4577136d957be2e819 | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 19241862 | false | 2025-05-22T09:43:04.000Z | 0x0d296a471d1e2dc31852894cf6e57eb5c02018fa20d28dea4380e1075f5c7743 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x94759c0cdd84054a71c4b9746dcdee90783aca4f | false | 150000000 | 11 | 0x94759c0cdd84054a71c4b9746dcdee90783aca4f | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 9992006 | false | 2024-09-27T02:55:37.000Z | 0xa07ade5f96281fb3837a2feb1df9a6277d368bfcb59213762a81131b9a22bb62 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xc8962e1139c5a4c0da6d5dd4a93ea5c825392467 | false | 54111635794025475814743 | 21 | 0xc8962e1139c5a4c0da6d5dd4a93ea5c825392467 | 0xacb54d07ca167934f57f829bee2cc665e1a5ebef | 10007966 | false | 2024-09-27T11:48:01.000Z | 0xc6bf4bb59728eca0dd1b2ab76948d74008f4808c0460445a68f57bc37adea65d |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | in\_onBehalfOf | block\_timestamp | in\_referralCode | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x5a2781446dd2ba1f5f6fd6291863e7b4e79459b6 | false | 15995559 | 7 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 20690963 | 0x5a2781446dd2ba1f5f6fd6291863e7b4e79459b6 | 2025-07-08T18:20:29.000Z | 0 | 0x0ea2a5dc313ec5842c87c84a2113faf376b1008d8b181789fe9217819576151b |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xd76c7cb048ed70f809d15f5d4c59a00c50e4c155 | false | 2062871309 | 13 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 20677631 | 0xd76c7cb048ed70f809d15f5d4c59a00c50e4c155 | 2025-07-08T08:07:00.000Z | 0 | 0x8e2ac30aeaaacafc08fa36fc76280f84380dced19a44f5aae967c2dfe1907810 |
| 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xe58b8932b9016ea436f003bd216a6a22c1f608ca | false | 500000000 | 17 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 20674878 | 0xe58b8932b9016ea436f003bd216a6a22c1f608ca | 2025-07-08T06:09:41.000Z | 0 | 0xcaff27879b5ea1d8871b8a26453e90c2e1790d346311df9bc44b7828c2a018c0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| in\_to | address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x52d463cd769743b7e6e102ce1ca9d126dee00e63 | 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0x52d463cd769743b7e6e102ce1ca9d126dee00e63 | false | 2294771 | 20 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 8288743 | 2024-08-18T12:00:18.000Z | 0x9cb8977358594adee58e30c5f541542b2373aba9abe4a17fd8de928b39a262a9 |
| 0xcb4a20fe5f623ce09186c5b7a15c1c6cca60eb70 | 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xcb4a20fe5f623ce09186c5b7a15c1c6cca60eb70 | false | 246999993 | 17 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 8275170 | 2024-08-18T04:27:42.000Z | 0xe35fca7ec69a47d92e270c0427ebf5310d0c5359791f45dc74efd839d4509ee8 |
| 0xe3f3ecb40218047910d43c51bf70219eaf3cd57f | 0xc6ff96aefd1cc757d56e1e8dcc4633dd7aa5222d | 0xe3f3ecb40218047910d43c51bf70219eaf3cd57f | false | 105000000 | 4 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 8293957 | 2024-08-18T14:54:12.000Z | 0xd1409306cf3292e41dbefa085f72226f20c6ef2a55a31e148789f15d4e3e6e08 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_interestRateMode` | `INT64` | Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate. |
| `in_borrowRate` | `STRING` | Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places). |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | in\_borrowRate | in\_onBehalfOf | block\_timestamp | in\_referralCode | transaction\_hash | in\_interestRateMode |
| ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x7f2e54d53258dc45b8581f11f924075146608d19 | false | 15000000000000000000000 | 15 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 15939335 | 4020821531730094068438856 | 0x7f2e54d53258dc45b8581f11f924075146608d19 | 2025-02-17T18:03:16.000Z | 0 | 0x4b5cfa2f7a00b76d88cde9175c770dd5f0690a70f9283d86d3785b10abe83905 | 2 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x9afa6e668430a6ef801ddbd55b070a2a8fb47ee4 | false | 8731307550819468186989 | 39 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 15926411 | 4049668913616263819500180 | 0x9afa6e668430a6ef801ddbd55b070a2a8fb47ee4 | 2025-02-17T10:36:43.000Z | 0 | 0x35d57ce606f2ab451e801d8d1d835c375d20dd4e31d572e1355653874ee4d8df | 2 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x9afa6e668430a6ef801ddbd55b070a2a8fb47ee4 | false | 4000000000000000000000 | 4 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 15934565 | 3983262993310339082999598 | 0x9afa6e668430a6ef801ddbd55b070a2a8fb47ee4 | 2025-02-17T15:17:42.000Z | 0 | 0x9d591cc4db078297b247feeb18d8420f4050655899043bf3d6bb2bbbad9b115f | 2 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_interestRateMode` | `INT64` | Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate. |
| `in_premium` | `STRING` | Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset. |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | removed | in\_asset | in\_amount | in\_target | log\_index | in\_premium | block\_number | in\_initiator | block\_timestamp | in\_referralCode | transaction\_hash | in\_interestRateMode |
| ------------------------------------------ | ------- | ------------------------------------------ | --------------------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | false | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 561571954988710400000 | 0xeff31d74852275f1d652ee10c9f3705d58065e08 | 36 | 0 | 6306332 | 0xeff31d74852275f1d652ee10c9f3705d58065e08 | 2024-07-03T14:08:57.000Z | 0 | 0xa019badbd18ab7c46153b021dcd809876dab1e8acc61f941499884b71f0b7467 | 2 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | false | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 561066451304849900000 | 0xeff31d74852275f1d652ee10c9f3705d58065e08 | 33 | 0 | 6307136 | 0xeff31d74852275f1d652ee10c9f3705d58065e08 | 2024-07-03T14:35:45.000Z | 0 | 0x7b77dae93daca90f2d5ed0c524c6f6ad7bc1ba9dd5dd4e8c38ec93589bab258e | 2 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | false | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 604839447424465700000 | 0xeff31d74852275f1d652ee10c9f3705d58065e08 | 23 | 0 | 6306911 | 0xeff31d74852275f1d652ee10c9f3705d58065e08 | 2024-07-03T14:28:15.000Z | 0 | 0x3737b21d2a37153111dd9816811fd3c34dc8f0a09034f3556bde4ddaaf013d2d | 2 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_collateralAsset` | `STRING` | Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtAsset` | `STRING` | Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtToCover` | `STRING` | Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset's smallest unit. |
| `in_liquidatedCollateralAmount` | `STRING` | Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset's smallest unit. |
| `in_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiveAToken` | `BOOL` | Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation. |
| address | in\_user | removed | log\_index | block\_number | in\_debtAsset | in\_liquidator | in\_debtToCover | block\_timestamp | in\_receiveAToken | transaction\_hash | in\_collateralAsset | in\_liquidatedCollateralAmount |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | --------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------ |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x5209db95e47eb90829db7eb17e71a8f34a502d48 | false | 11 | 16748076 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x8e595231305efc7ef256679ad95847cb255ef846 | 288194300 | 2025-03-09T21:24:30.000Z | false | 0xcc31d8f326ce147b0234ec4a52fdafcc971b85671bfb09d3f669dda72f30cddc | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 147300384493823077030311 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x3df883542ca0037346acff9417ff6a7d68204096 | false | 11 | 16741844 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x8e595231305efc7ef256679ad95847cb255ef846 | 37864603 | 2025-03-09T17:46:01.000Z | false | 0xc8069221699271125afc24242fd9e3e44ff665cf1e4c24d9fdef0663b0f09f3a | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 18727133745377448423475 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x41617e0d994f3fdf3b1e1eca531b317f4fc9374d | false | 12 | 16743869 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x30faa15737c88e925df41e89709763a2f84126ec | 23090459 | 2025-03-09T18:55:21.000Z | false | 0xe28c60533093d8a42051527c4c959ffd5d4a503c239ebafbbd03eeb56d01ff7e | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 11619922996664951363914 |
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountMinted` | `STRING` | Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_repayer` | `STRING` | Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_useATokens` | `BOOL` | Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset. |
| address | in\_user | removed | in\_amount | log\_index | in\_repayer | in\_reserve | block\_number | in\_useATokens | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0xb5cf4338caa051a48b404570b74fc669a2dd4e69 | false | 2680171722443242954436 | 14 | 0xb5cf4338caa051a48b404570b74fc669a2dd4e69 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 18336314 | false | 2025-04-24T09:31:25.000Z | 0xe770fb6dfa1343e5bad8f3c3132e50b646f323c2e40cec7cf93d60e8de3c0319 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x50e713fbea777262a3d5ccfb373692feb73adbf6 | false | 1350084151477668885307 | 4 | 0x50e713fbea777262a3d5ccfb373692feb73adbf6 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 18335926 | false | 2025-04-24T09:16:15.000Z | 0xe3ba9e8cfbe876c21db2736628eb346bca173cadab318cafb0460ec89e1ee353 |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x524b917ea47a45181d768fca39741a059174640b | false | 6003546769101200333447 | 56 | 0x524b917ea47a45181d768fca39741a059174640b | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 6514839 | false | 2024-07-08T10:01:16.000Z | 0xc81f7f32858d9b098e3291a9d310649ff8fe1c75ba17081e65041e3d17292c71 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | in\_onBehalfOf | block\_timestamp | in\_referralCode | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x59644e9f38afc4992e5e53d9d1c6b71e720c052e | false | 446007266025113153175 | 4 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 18011127 | 0x59644e9f38afc4992e5e53d9d1c6b71e720c052e | 2025-04-13T22:25:15.000Z | 0 | 0x679a925055faf45fa58fb12ba71149399da058822fb2e5feadb6cc82be6415ae |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x472bf5ff7b96033bd203b360403a0649a908dbe4 | false | 213685417250041167356516 | 4 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 18011308 | 0x472bf5ff7b96033bd203b360403a0649a908dbe4 | 2025-04-13T22:35:36.000Z | 0 | 0xb3e21e2da3b9ab3ab395add4130e56f4fb08b5330ac9377667557fb11d7372ad |
| 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x472bf5ff7b96033bd203b360403a0649a908dbe4 | false | 24708071123288761012494 | 4 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 18011912 | 0x472bf5ff7b96033bd203b360403a0649a908dbe4 | 2025-04-13T23:11:44.000Z | 0 | 0xc5d565ba507a1c73e1ad8b1cf0e52ec614a3c5f076a49d97e02b496dc1a4f91a |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| in\_to | address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x59dd5cc35c15154cc1016d1d37b649ff38ee0a72 | 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x59dd5cc35c15154cc1016d1d37b649ff38ee0a72 | false | 100728842 | 17 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 13801159 | 2024-12-26T10:46:44.000Z | 0x5061869ccf8bc52a6337626a8a848df9db1ba2668a396f4cbabddff92db74153 |
| 0xabc26230a9d1a5171f0553ed7aec24247be266a1 | 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0xabc26230a9d1a5171f0553ed7aec24247be266a1 | false | 103189472 | 6 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 13813275 | 2024-12-26T17:35:34.000Z | 0x3035392fbc924654c1f707829b21b8a7190fe4a2ad596014ac64907e87ad6c90 |
| 0x33bd8d5a4f40285df90694ccb29d6f5859c3977e | 0xbdaa004a456e7f2daff00ffcdcbead5da27b7966 | 0x33bd8d5a4f40285df90694ccb29d6f5859c3977e | false | 12162174056319656072724 | 5 | 0x5fbdf89403270a1846f5ae7d113a989f850d1566 | 13816312 | 2024-12-26T19:22:40.000Z | 0xc1ff6647b93170d44130e679c27fbb51f9a4f80ff919e02ca0259dbb20e20ef1 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_interestRateMode` | `INT64` | Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate. |
| `in_borrowRate` | `STRING` | Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places). |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | in\_borrowRate | in\_onBehalfOf | block\_timestamp | in\_referralCode | transaction\_hash | in\_interestRateMode |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | --------------------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x6676ae96a46458f7307e432a86a26533ee970d1d | false | 50000000 | 4 | 0xa219439258ca9da29e9cc4ce5596924745e12b93 | 4126294 | 91296616593318258049759594 | 0x6676ae96a46458f7307e432a86a26533ee970d1d | 2024-04-29T20:26:05.000Z | 0 | 0x7a501ab29d135fb4a4e5894abdcbd14c5025367b38cb07412e18a5930ad59009 | 2 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x009eed6c6a65ec46b9b1b9dd4b6140ea1ec707b3 | false | 3326000000 | 5 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 4103502 | 92841604857040285992510082 | 0x009eed6c6a65ec46b9b1b9dd4b6140ea1ec707b3 | 2024-04-29T01:26:29.000Z | 0 | 0x8e0ddfb72a97802b39d469e487b3271e600ea0f52c43aada2e33b0a17d98ac68 | 2 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x024603c63bf4397c199514ffa32240aa417ce642 | false | 3119000000 | 5 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 4110277 | 107917264341374560251189418 | 0x024603c63bf4397c199514ffa32240aa417ce642 | 2024-04-29T07:05:14.000Z | 0 | 0xf7845581568a529f0a2ffc79e8b6f8e04c15fd1d26b7f2f45f257f385f5c1772 | 2 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| --------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_initiator` | `STRING` | Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_asset` | `STRING` | Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_interestRateMode` | `INT64` | Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate. |
| `in_premium` | `STRING` | Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset. |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | removed | in\_asset | in\_amount | in\_target | log\_index | in\_premium | block\_number | in\_initiator | block\_timestamp | in\_referralCode | transaction\_hash | in\_interestRateMode |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------- | ------------------------------------------ | ---------- | -------------- | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 0xa219439258ca9da29e9cc4ce5596924745e12b93 | 5503613540 | 0xa48cc0e4159c51d73b42c824f1444d1c1cbda531 | 76 | 2751807 | 19789852 | 0xa48cc0e4159c51d73b42c824f1444d1c1cbda531 | 2025-06-08T10:11:32.000Z | 0 | 0xa3bc35bb8345afce44dfbb334f5af405b748a2ed709923e1f9ac535ea9f28ed8 | 0 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 58775250276291064 | 0x1808f504742e1b0a034fd12dbb6cfc609f3e5eb2 | 37 | 29387625138146 | 5255215 | 0x1808f504742e1b0a034fd12dbb6cfc609f3e5eb2 | 2024-06-08T02:44:06.000Z | 0 | 0xac288328f87a8b8d3e5bb2540e668b305eb0d2ba325730ab39d9af1cf0d94826 | 0 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 1100712232 | 0x8e595231305efc7ef256679ad95847cb255ef846 | 141 | 550356 | 15360779 | 0x8e595231305efc7ef256679ad95847cb255ef846 | 2025-02-03T02:04:53.000Z | 0 | 0x113b5697c3c24fe52da27f006588471b4055f6c5cbe10108c49964c11bfdd260 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_collateralAsset` | `STRING` | Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtAsset` | `STRING` | Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtToCover` | `STRING` | Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset's smallest unit. |
| `in_liquidatedCollateralAmount` | `STRING` | Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset's smallest unit. |
| `in_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiveAToken` | `BOOL` | Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation. |
| address | in\_user | removed | log\_index | block\_number | in\_debtAsset | in\_liquidator | in\_debtToCover | block\_timestamp | in\_receiveAToken | transaction\_hash | in\_collateralAsset | in\_liquidatedCollateralAmount |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | --------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------ |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x9c69efa7b85873628b4d9dcff30fa425eca7d047 | false | 21 | 14529562 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x504bea28e5f95d3b7c0d45ea0a5547df2ee54ff7 | 3958876 | 2025-01-13T09:29:53.000Z | false | 0x48ce241ff22c7d1cf6e26c0fbba90235df00a337d9aa828872a2013cf0f9d42c | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 1318567701150159 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0xe8b0929648b8b4239d76c880c75bc2469d126163 | false | 74 | 14531128 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 0x504bea28e5f95d3b7c0d45ea0a5547df2ee54ff7 | 13386592 | 2025-01-13T10:22:25.000Z | false | 0xe9f90cf803b87abaf3495303297f6f2665b5d5fb88bec1f6dae6ca242bde2787 | 0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f | 4481943682942732 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0xed900a6d68555abbf332cb9a12e5590477d00bb4 | false | 103 | 14531130 | 0xa219439258ca9da29e9cc4ce5596924745e12b93 | 0x504bea28e5f95d3b7c0d45ea0a5547df2ee54ff7 | 5178647 | 2025-01-13T10:22:29.000Z | false | 0xa11deb7d89673ac15dc02b789fea2d1bcfaeda967930b8a0973bf5ef9cc672bf | 0x93f4d0ab6a8b4271f4a28db399b5e30612d21116 | 1751945222979904 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amountMinted` | `STRING` | Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value. |
| address | removed | log\_index | in\_reserve | block\_number | block\_timestamp | in\_amountMinted | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------- | ------------------------------------------------------------------ |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 18 | 0x3aab2285ddcddad8edf438c1bab47e1a9d05a9b4 | 5674949 | 2024-06-18T23:00:04.000Z | 13696 | 0xb66ac9945971804b7a2c599943e2eb074ddfa589f0979a6465b5d8ec715dbb3b |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 6 | 0x4af15ec2a0bd43db75dd04e62faa3b8ef36b00d5 | 5674949 | 2024-06-18T23:00:04.000Z | 5914157599632303144 | 0xb66ac9945971804b7a2c599943e2eb074ddfa589f0979a6465b5d8ec715dbb3b |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | false | 21 | 0xb5bedd42000b71fdde22d3ee8a79bd49a568fc8f | 5674949 | 2024-06-18T23:00:04.000Z | 1190221948206854 | 0xb66ac9945971804b7a2c599943e2eb074ddfa589f0979a6465b5d8ec715dbb3b |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_repayer` | `STRING` | Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_useATokens` | `BOOL` | Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset. |
| address | in\_user | removed | in\_amount | log\_index | in\_repayer | in\_reserve | block\_number | in\_useATokens | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x080b42899afc59054b2fa71a71e505e9b46edd5c | false | 12083342 | 7 | 0x080b42899afc59054b2fa71a71e505e9b46edd5c | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 20039219 | false | 2025-06-15T18:49:18.000Z | 0x1f71d1b1e151a8fc45f9ad9a788563c2658fe434652b5020129d448393d4104a |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x0a1eeac4aae7dc775819f4fc07d66970a0ba505b | false | 310208076 | 4 | 0x0a1eeac4aae7dc775819f4fc07d66970a0ba505b | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 20029613 | false | 2025-06-15T11:49:37.000Z | 0x88a2d26c5e3ebf8d0756e207121608e78d1ad29b5d51a0bf2cb8054aa01f415a |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x0a1eeac4aae7dc775819f4fc07d66970a0ba505b | false | 24 | 4 | 0x0a1eeac4aae7dc775819f4fc07d66970a0ba505b | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 20029621 | false | 2025-06-15T11:50:00.000Z | 0xd08f891d982bcd0260ffa4aaab35e956072f7ef225772f4622fb1e91d1af1049 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_referralCode` | `STRING` | Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives. |
| address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | in\_onBehalfOf | block\_timestamp | in\_referralCode | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x6366f25736dd2b563e1bd7a551b9b1191907940a | false | 8037018 | 7 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 21428505 | 0x6366f25736dd2b563e1bd7a551b9b1191907940a | 2025-07-29T16:30:32.000Z | 0 | 0xfcb97fa357a5ced1ba77d7d0d3365e17abe320924549c3ad854ceebacdd787ff |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0xcf2e146ac26691f5eae887ec7e88bc84f63211c2 | false | 31359815 | 10 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 21408126 | 0xcf2e146ac26691f5eae887ec7e88bc84f63211c2 | 2025-07-29T04:39:47.000Z | 0 | 0x1781466ca00cf238366dcdbd3fccffe02c1c30ec40b850ee231b7412bbe5e576 |
| 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x0e7fa1beebc77aac0a18160e226f4c1a510b251c | false | 3980688526 | 14 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 21438954 | 0x0e7fa1beebc77aac0a18160e226f4c1a510b251c | 2025-07-29T22:57:48.000Z | 0 | 0x31b6fb09f0594af9b22d3578d85dc773509d09dc2d7293f4b34fea05181148cf |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| in\_to | address | in\_user | removed | in\_amount | log\_index | in\_reserve | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x597baf1a0b49a6abe86a08d5cdba7394712d6ac4 | 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x597baf1a0b49a6abe86a08d5cdba7394712d6ac4 | false | 453174800 | 5 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 16493958 | 2025-03-03T11:58:43.000Z | 0xee3926c9902067c3f1b1c613bd093eb625716d2861ca88d6d7ef1689ee0b9a07 |
| 0x8949c04565078775e3f3e678f2010371322b25ee | 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x8949c04565078775e3f3e678f2010371322b25ee | false | 514113722 | 5 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 16490833 | 2025-03-03T10:08:35.000Z | 0xd986997e1d102a64d0304eda752a17d09aa82e6f0bb5c69d1ce0f24e02894ce3 |
| 0x2e905825c0814f7ac098a1c49f925ffecf56251e | 0x2f9bb73a8e98793e26cb2f6c4ad037bdf1c6b269 | 0x2e905825c0814f7ac098a1c49f925ffecf56251e | false | 387678330 | 5 | 0x176211869ca2b568f2a7d4ee941e073a821ee1ff | 16494931 | 2025-03-03T12:32:47.000Z | 0xdde9d4f048f41c499b0c4417ba38238f6a327d5d89e3f82caabe6b8213f39607 |
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_currentBalance` | `STRING` | User's current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_avgStableRate` | `STRING` | Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals). |
| `in_newTotalSupply` | `STRING` | Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_currentBalance` | `STRING` | User's current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_newRate` | `STRING` | Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals). |
| `in_avgStableRate` | `STRING` | Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals). |
| `in_newTotalSupply` | `STRING` | Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_currentBalance` | `STRING` | User's current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_avgStableRate` | `STRING` | Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals). |
| `in_newTotalSupply` | `STRING` | Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.*
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_currentBalance` | `STRING` | User's current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_newRate` | `STRING` | Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals). |
| `in_avgStableRate` | `STRING` | Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals). |
| `in_newTotalSupply` | `STRING` | Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | in\_from | removed | in\_index | in\_value | in\_target | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | ----------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- |
| 0x2b9881ddb5570ae9eba081fa7fdf334e4195e3de | 0x3ec4c6777f48dfdbac1ebf3ba6a264bd5172a890 | false | 1106973598220230293058055514 | 1300000000 | 0x0000000000000000000000000000000000000000 | 1 | 9945297 | 2024-09-26T00:41:19.000Z | 0xd5265a4bc2812f5992f2f7ffd538232724825781344c960fda2dc831bd3f7617 | 4504877 |
| 0x2b9881ddb5570ae9eba081fa7fdf334e4195e3de | 0x8b1624c8b184edb4e7430194865490ba5e860f0c | false | 1107496251179976523567301629 | 20000000 | 0x0000000000000000000000000000000000000000 | 1 | 9968501 | 2024-09-26T13:35:34.000Z | 0xb5f49e70821935b987b98c8fd6f9f4433425083221b16530c5bab86f70f16d26 | 408989 |
| 0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46 | 0xa67fe976fcbad6fb4e2092a4292a89a200ad602c | false | 1038052930143893994885652805 | 63771000000000000000000 | 0x0000000000000000000000000000000000000000 | 25 | 9948186 | 2024-09-26T02:17:57.000Z | 0x7f018dfe37a7ed9ab6c2f67fdadfaeacde85d5bed760bba7941f72b5f7b32178 | 69324775979182838610 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | removed | in\_index | in\_value | in\_caller | log\_index | block\_number | in\_onBehalfOf | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------- | ---------------------------- | ----------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46 | false | 1069977904177416008281849657 | 12186272762700788448444 | 0xc8dce2be2d8847f23bfe00a62d6f818fd97a0f13 | 46 | 13798485 | 0xc8dce2be2d8847f23bfe00a62d6f818fd97a0f13 | 2024-12-26T09:17:14.000Z | 0x59eaecd6d06febbe0542ec22a13d44a5597f3c6afc67443493a3dfdb979c641f | 3070077464716532 |
| 0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46 | false | 1070013661674626223333968312 | 37620000000000000000000 | 0xb205ce1cda3f7d45e7c1f1fbb84e909a29b89e09 | 20 | 13802126 | 0xb205ce1cda3f7d45e7c1f1fbb84e909a29b89e09 | 2024-12-26T11:19:06.000Z | 0x8936eb6d0deac3096570fcc13da08a2725e05d17fd8c930f44575ca7c1ddccc5 | 0 |
| 0xb1048e86a1a1faf0ee53ce78cdd5e0180643dc46 | false | 1069975242070890955225221122 | 12270058472450714500550 | 0x7ee89840bf3bdf1bd9951077d62a73af230f90ed | 13 | 13798213 | 0x7ee89840bf3bdf1bd9951077d62a73af230f90ed | 2024-12-26T09:08:10.000Z | 0xa855bfb30814bf35d9581fc4c4658a1c87be3d969519b08f3af3fb40797ba8e9 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | in\_from | removed | in\_index | in\_value | in\_target | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | --------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x384a318215aca36084af3719f3c84aa2167de6be | 0x67dc0cad9f5a12a4e5faa368a6aa7cd7fb6259c2 | false | 3208416921935672860040734357 | 66151602 | 0x0000000000000000000000000000000000000000 | 62 | 23344136 | 2025-09-15T03:31:47.000Z | 0xef3e47192d76263d2d6ed914fe65182e82483ec5765580645190d1ac8c616c7d | 268986 |
| 0x384a318215aca36084af3719f3c84aa2167de6be | 0x67dc0cad9f5a12a4e5faa368a6aa7cd7fb6259c2 | false | 3208422585627572312358201524 | 48619537 | 0x0000000000000000000000000000000000000000 | 67 | 23344215 | 2025-09-15T03:34:25.000Z | 0xfc5c1aa13b043bdd295cedebe6080d50fe6ca386b0d5c2cd5e4e90df7e8cb6c5 | 86 |
| 0x384a318215aca36084af3719f3c84aa2167de6be | 0xf2bc825fb466136d00571b496e6eb1a601679919 | false | 3211035260751013625917476478 | 488 | 0x0000000000000000000000000000000000000000 | 17 | 23380783 | 2025-09-15T23:54:57.000Z | 0x58ab2beff5e5b0d8dc9b8feba85b191a15a0828ae538050d4e20f0c7e918f9d3 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | removed | in\_index | in\_value | in\_caller | log\_index | block\_number | in\_onBehalfOf | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------- | ---------------------------- | ------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x613ac3930a5b2805e48be151bea8c29d394f8a86 | false | 1063725686124420397324568679 | 618254401417633585396047 | 0xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28 | 62 | 23168824 | 0xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28 | 2025-09-10T19:46:31.000Z | 0x3f83ba7fe0ee773eb1e280754ef68432f92236cf693c2531835bea09c4ba7951 | 0 |
| 0xfbb30e625ba0aa35c13a86ef49ab4f2bafa21538 | false | 2132441112825892872868094099 | 30000050055069417 | 0xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28 | 143 | 23169046 | 0xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28 | 2025-09-10T19:53:55.000Z | 0xec15ec98d4fc5136a32e38681e11803c933d70dbf287263817c7d968b79c6729 | 50055069417 |
| 0xfbb30e625ba0aa35c13a86ef49ab4f2bafa21538 | false | 2132440798886268709278432434 | 340000000000000000 | 0xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28 | 34 | 23168952 | 0xd95451b9f51bfe8f37bbf2165c4aa37f9bd7cd28 | 2025-09-10T19:50:47.000Z | 0x6f5ab5e25a0f8d766f192a3634ffa57d902c648e8d68a74e30441410d22ef928 | 0 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_target` | `STRING` | Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | in\_from | removed | in\_index | in\_value | in\_target | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | --------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x476f206511a18c9956fc79726108a03e647a1817 | 0xabbbd0d907e0320ddd6874030749c64bd0f196c5 | false | 1182730192838659690770979718 | 444330521 | 0x0000000000000000000000000000000000000000 | 1 | 22030928 | 2025-08-14T13:09:29.000Z | 0x54f750a5868c251f10a3c80dc7bbcb184788997068283852cf9d1062a6890f27 | 8722628 |
| 0x476f206511a18c9956fc79726108a03e647a1817 | 0x1432a39a082417ab64410cdbc5632082d87038da | false | 1182712084698940891405436055 | 22202706 | 0x0000000000000000000000000000000000000000 | 4 | 22024781 | 2025-08-14T09:44:23.000Z | 0xe55ba896a04a67a0e995c5f73e9dcce13cc09899eb16b250e0d3cdaffbb637d2 | 185661 |
| 0x476f206511a18c9956fc79726108a03e647a1817 | 0xb63b67102fcd3681250173e37c5282f319a1cb4b | false | 1182668186949257486005423684 | 20048743 | 0x0000000000000000000000000000000000000000 | 6 | 22010137 | 2025-08-14T01:34:27.000Z | 0x4c30d51b085ead890d1c4bf0dbfa743d4564d4f5a044287aa60459dce1418a3e | 166916 |
**Query with partition filter**
```sql theme={null}
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.
| Column | Type | Description |
| -------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_caller` | `STRING` | Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_onBehalfOf` | `STRING` | Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_balanceIncrease` | `STRING` | Accrued interest amount since the last update for the user's balance. Numeric string representation of token quantity in smallest denomination. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| address | removed | in\_index | in\_value | in\_caller | log\_index | block\_number | in\_onBehalfOf | block\_timestamp | transaction\_hash | in\_balanceIncrease |
| ------------------------------------------ | ------- | ---------------------------- | ------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00 | false | 1008013122080753381770525602 | 100000000000000000 | 0x2cd84c5a739c12202fe92b7ce488abf643578a3d | 1 | 13493359 | 0x2cd84c5a739c12202fe92b7ce488abf643578a3d | 2024-12-19T02:22:30.000Z | 0x988625461dd109ce9614b394099882db78139a127caf973b87db8cf0a3746865 | 0 |
| 0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00 | false | 1008013884470145055415819818 | 30000000000000000 | 0x9beb80af1f2e960877f1dc36dd81b7c2242e52ff | 1 | 13499022 | 0x9beb80af1f2e960877f1dc36dd81b7c2242e52ff | 2024-12-19T05:34:12.000Z | 0x05645d7760ca752e9f8228a89ab214edf2bee2dce8317287c23e52a61d5d0dc8 | 0 |
| 0xcc7b5fd2f290a61587352343b7cf77bb35cb6f00 | false | 1008014399775211731438175711 | 3000000000000000 | 0xc473582f9f75d242548c5abed09bdfa523a01b85 | 1 | 13502886 | 0xc473582f9f75d242548c5abed09bdfa523a01b85 | 2024-12-19T07:43:39.000Z | 0x2ea7eac5e02bd92ce7d23d2976f318317785d86a41a598f93de6f496252ed4d9 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.zerolend_v1_linea.VTokenMain_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***