> ## 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.
# spark_v1_ethereum
> Tables in tt-contracts.spark_v1_ethereum
## Tables
### LendingPoolConfigurator\_CollateralConfigurationChanged\_event
Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in lending markets.
| 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 |
| ------- | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | ------------------------ |
| 0 | 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 200 | 22617678 | 2025-06-02T14:47:35.000Z | 0x4ddc25f122e8092d40a008e2a1807ed81beb514f054345085ef863cdf266cf5e | 10700 | 4000 |
| 7400 | 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 184 | 19462132 | 2024-03-18T14:00:23.000Z | 0x42360f376ade384dddee970b309e051380d0b201127e505eb70c8e6e6c1909c8 | 10700 | 7500 |
| 7900 | 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 186 | 19462132 | 2024-03-18T14:00:23.000Z | 0x42360f376ade384dddee970b309e051380d0b201127e505eb70c8e6e6c1909c8 | 10700 | 8000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.LendingPoolConfigurator_CollateralConfigurationChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingPoolConfigurator\_LiquidationProtocolFeeChanged\_event
Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.
| 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%. |
| address | removed | in\_asset | in\_newFee | in\_oldFee | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 1000 | 0 | 71 | 16776463 | 2023-03-07T12:36:11.000Z | 0x93494a0fb66734a4ebd6cd6cc1810faa4884cc35904cc7da2062ac8062637af6 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 1000 | 0 | 76 | 16776471 | 2023-03-07T12:37:47.000Z | 0x14acacc8ba55fd779fb86a7d3cba71f3198a444bfe8db9346312636133e9543b |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 1000 | 0 | 42 | 16776480 | 2023-03-07T12:39:35.000Z | 0x6e54b5bdb9680e9ae824459c1455af2216779c21bcf1ae74ddd5d24c2025873f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.LendingPoolConfigurator_LiquidationProtocolFeeChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingPoolConfigurator\_ReserveFactorChanged\_event
Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 246 | 17857211 | 2023-08-06T16:49:35.000Z | 0x6afccfeb89bbbd2a9f198004c111b22b13aacd9e2eba23ad13f8dc242516a18d | 500 | 1500 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xdc035d45d973e3ec169d2276ddab16f1e407384f | 382 | 21723481 | 2025-01-28T14:00:35.000Z | 0x7236e4886857aa0c6cf4a2f1e784158b6a2e698515f64898f41c7e4ae27ba2e9 | 0 | 1 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xdc035d45d973e3ec169d2276ddab16f1e407384f | 375 | 21723481 | 2025-01-28T14:00:35.000Z | 0x7236e4886857aa0c6cf4a2f1e784158b6a2e698515f64898f41c7e4ae27ba2e9 | 1 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.LendingPoolConfigurator_ReserveFactorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LendingPoolConfigurator\_ReserveInitialized\_event
Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xa3931d71877c0e7a3148cb7eb4463524fec27fbd | 0x6715bc100a183cc65502f05845b589c1919ca3d3 | 324 | 21014413 | 2024-10-21T14:00:23.000Z | 0xda31ba8a27ff7166680d9b556abe508a713a5e2028a729f87334d1c1ef4ccad6 | 0x55580770e14e008082ab2e8d08a16cc1dc192741 | 0x4e89b83f426fed3f2ef7bb2d7eb5b53e288e1a13 | 0xa8632b2f0a3c5327a77ee51a47a168b6490a7178 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x18084fba666a33d37592fa2633fd49a74dd93a88 | 0xce6ca9cdce00a2b0c0d1dac93894f4bd2c960567 | 245 | 22117224 | 2025-03-24T14:00:35.000Z | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | 0xf4b45ed75b50ec613661bcdf2353aa45a288872e | 0x764591dc9ba21c1b92049331b80b6e2a2acf8b17 | 0x0d195221329c38a706966eb1da89636160f27c2a |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x8236a87084f8b84306f72007f36f2618a5634494 | 0xa9d4ecebd48c282a70cfd3c469d6c8f178a5738e | 241 | 22117224 | 2025-03-24T14:00:35.000Z | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | 0xfbaf333a919cb92caf9e85966d4e28fff80e5d1d | 0x096bddfee63f44a97cc6d2945539ee7c8f94637d | 0xde5dde40e12763464dc859a9f03793988de953fb |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.LendingPoolConfigurator_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_BackUnbacked\_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_backer` | `STRING` | - |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_fee` | `STRING` | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_BackUnbacked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Borrow\_event
Borrow events emitted when users take loans from lending pools, recording borrower address, borrowed amount, and applicable interest rate. Used for tracking lending protocol utilization and debt 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_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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ----------------------- | ---------- | ------------------------------------------ | ------------- | -------------------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x28177b138fdec353c1da1858798c52ac0be0a0a8 | false | 10377205295953186285776 | 265 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17889732 | 31401763155165655148976000 | 0x28177b138fdec353c1da1858798c52ac0be0a0a8 | 2023-08-11T06:03:23.000Z | 0 | 0xcf0bf73d4a2bb144344be76af37f4b4f174f8e89b721ad5a36bc56ebbfc5029c | 2 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x2471ee5c959e89470827ce0e8269aa3031481d19 | false | 30000000000000000000000 | 142 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17888791 | 31401763155165655148976000 | 0x2471ee5c959e89470827ce0e8269aa3031481d19 | 2023-08-11T02:54:35.000Z | 0 | 0xe89530f68da2397aa5b0813744a0afd66f07350b7e42a11c363c1a58f570c0ea | 2 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0xb584b70908588db7a70ff590000700479868a610 | false | 65000000000000000000000 | 173 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17889556 | 31401763155165655148976000 | 0xb584b70908588db7a70ff590000700479868a610 | 2023-08-11T05:27:59.000Z | 0 | 0x95b58c2b1803bf40a1e803b90b2a03614681b72b19693ca062ff200959643de6 | 2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_FlashLoan\_event
Flash loan event records from Spark Protocol (Aave v3 fork) lending pools on Ethereum, capturing borrowed asset, amount, initiator, target contract, premium fee, and interest rate mode. Used for analyzing flash loan arbitrage strategies, liquidation flows, and protocol utilization 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ | -------------------- |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 1500000000000000000000 | 0x619ad2d02dbee6eba3cdbda3f98430410e892882 | 87 | 0 | 18372089 | 0x619ad2d02dbee6eba3cdbda3f98430410e892882 | 2023-10-17T19:10:11.000Z | 3228 | 0x583c4202ccbcb7c440f3ac7f766e38b184dc38500f38f6c0c4469dc9321055b0 | 0 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 20000000000000000000000 | 0x619ad2d02dbee6eba3cdbda3f98430410e892882 | 245 | 0 | 18371583 | 0x619ad2d02dbee6eba3cdbda3f98430410e892882 | 2023-10-17T17:28:35.000Z | 3228 | 0x3c71e7c2e49602bd775063a37ee99592fa943119e5de359f1b45e0e8db50e8c4 | 0 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 30000000000000000000 | 0x619ad2d02dbee6eba3cdbda3f98430410e892882 | 163 | 0 | 18445827 | 0x619ad2d02dbee6eba3cdbda3f98430410e892882 | 2023-10-28T02:49:23.000Z | 3228 | 0xa1282718584622b512fc25a40f6cba8b8e2a3898acde2b53eb10f056f52f3755 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_FlashLoan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_IsolationModeTotalDebtUpdated\_event
Event logs tracking total debt changes for isolated assets in Spark Protocol lending pools on Ethereum. Used to monitor aggregate borrowing positions and debt accumulation for specific collateral assets in isolation mode.
| 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_totalDebt` | `STRING` | Aggregate debt amount across all positions for the specified asset in the pool's isolation mode, denominated in the asset's smallest unit. Values are stored as strings to preserve precision for large integers representing token amounts. |
| address | removed | in\_asset | log\_index | block\_number | in\_totalDebt | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee | 482 | 21020689 | 4561206443 | 2024-10-22T11:02:11.000Z | 0x8e63f0cb91133ad35436d962d8282b272eee640a14b07324a6b7e7c598b488d0 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee | 246 | 21020078 | 3911206443 | 2024-10-22T08:58:59.000Z | 0xe84f7d07c15432506e8313c3b271cdf8280f8c7238c486b07596a34163c57462 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee | 139 | 21375221 | 13182931579 | 2024-12-10T22:54:59.000Z | 0xa8ec177876274d4afbb90be9904d5d76bdfac0f9af49165e2ffc6988b7399f18 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_IsolationModeTotalDebtUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_LiquidationCall\_event
Liquidation events from Spark Protocol (Aave v3 fork) lending pools on Ethereum, capturing when undercollateralized positions are forcibly closed by liquidators. Records debt repayment amounts, seized collateral quantities, and liquidator addresses for analyzing protocol risk and liquidation 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | --------------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------ |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0xebd551abbf4d86855ded110e7b345807976d2d2c | false | 186 | 18322547 | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xcbed8b1b92c6e4f86a58f66da7ba26a7172df827 | 332444159064168524654 | 2023-10-10T20:50:23.000Z | false | 0x08e37a31fa047fcc7cd105862f146dbb4f9140bb1e269a1bd1a775760d7a10e5 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 223326565570604934 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | false | 112 | 18322529 | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xde26008df5af55a28da3d77d2996886f3b241845 | 562475670468718600068 | 2023-10-10T20:46:35.000Z | false | 0x04438bf7075440922444ff3987367a1d2aaf2b71c342dea44d73e7bb2dcd307c | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 336649353261709628 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x154a1910dca4f418c1cabba264259082c474cac0 | false | 56 | 18321228 | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xde26008df5af55a28da3d77d2996886f3b241845 | 528933506795511026917 | 2023-10-10T16:24:11.000Z | false | 0x9020393a6c4accd9b7bb0f63a45e4f277dcac31f740e311b02681b975797838a | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 354061995433029127 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_LiquidationCall_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_MintedToTreasury\_event
Treasury minting events from Spark Protocol lending pools on Ethereum, recording interest accrual transferred to protocol treasury per reserve asset. Used for tracking protocol revenue generation and reserve-specific yield performance across different collateral types like WETH, DAI, and USDC.
| 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 |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------ | ------------------------------------------------------------------ |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 205 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 17708904 | 2023-07-16T22:44:59.000Z | 16036590224556071 | 0x56e209559d525727ce5d5c9c98879422844907ea34bf5ef1728b8a8b94f070a1 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 202 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 17708904 | 2023-07-16T22:44:59.000Z | 328873230269530649 | 0x56e209559d525727ce5d5c9c98879422844907ea34bf5ef1728b8a8b94f070a1 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 199 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17708904 | 2023-07-16T22:44:59.000Z | 197498406607968 | 0x56e209559d525727ce5d5c9c98879422844907ea34bf5ef1728b8a8b94f070a1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_MintedToTreasury_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_MintUnbacked\_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_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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_MintUnbacked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Repay\_event
Loan repayment events from Spark Protocol lending pools on Ethereum, recording borrower repayments with repaid amounts, reserve token addresses, and whether aTokens were used for repayment. Used for analyzing debt reduction 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------- | ---------- | ------------------------------------------ | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x74b3691ebc3fb083e36065a1986d6c490b13e95a | false | 1002285201333203928347689 | 106 | 0x74b3691ebc3fb083e36065a1986d6c490b13e95a | 0x6b175474e89094c44da98b954eedeac495271d0f | 17590669 | false | 2023-06-30T07:39:59.000Z | 0x7378ab0134f799c6206c6292ad0b68a1fe9199188bda223a3b49c8742e3c41e3 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | false | 27309849990698405779660 | 466 | 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | 0x6b175474e89094c44da98b954eedeac495271d0f | 17816273 | false | 2023-07-31T23:27:47.000Z | 0xb847dc2b9afd04897af7105976c022e305976661660a33ac3536008fe5699835 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0xd4f072b18c7a31d50bbf1df729b68e9ace7bc0d9 | false | 1000000000000000000000000 | 292 | 0xd4f072b18c7a31d50bbf1df729b68e9ace7bc0d9 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17862523 | false | 2023-08-07T10:40:47.000Z | 0x86a959a3c626c237b2f65eca5d597b32da9547be32d31d5e292129b1a28afa97 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_Repay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_ReserveDataUpdated\_event
Reserve state updates from Spark Protocol (Aave v3 fork) lending pools on Ethereum, tracking liquidity and borrow indices for interest rate calculations. Each event records the current liquidity rate, variable/stable borrow rates, and cumulative indices for a specific reserve asset, enabling analysis of lending pool dynamics and yield accrual.
| Column | Type | Description |
| ------------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_reserve` | `STRING` | Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_liquidityRate` | `STRING` | Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers. |
| `in_stableBorrowRate` | `STRING` | Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan. |
| `in_variableBorrowRate` | `STRING` | Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan. |
| `in_liquidityIndex` | `STRING` | Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve's inception, stored as a numeric string. |
| `in_variableBorrowIndex` | `STRING` | Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve's inception, stored as a numeric string. |
| address | removed | log\_index | in\_reserve | block\_number | block\_timestamp | in\_liquidityRate | transaction\_hash | in\_liquidityIndex | in\_stableBorrowRate | in\_variableBorrowRate | in\_variableBorrowIndex |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ | ---------------------------- | -------------------- | -------------------------- | ---------------------------- |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 184 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17580316 | 2023-06-28T20:51:59.000Z | 9155942964767453191920067 | 0x50036a445b1ee0867728520c710bf80e22221aa954ebb5241e16c5bcb2dd6d60 | 1000982534517136313072801386 | 0 | 34304803710648653896272000 | 1003366132954620220860606616 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 314 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17580473 | 2023-06-28T21:23:47.000Z | 9168946593728384784106356 | 0x3bb00c60763e5dc932687df9b8fd55572a8a30eb4ff75ed7ca01204bc4937d1d | 1000983089016870014745445252 | 0 | 34304803710648653896272000 | 1003368215462198914922631082 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 166 | 0x6b175474e89094c44da98b954eedeac495271d0f | 17580201 | 2023-06-28T20:28:35.000Z | 9130598755621093259396610 | 0x53df746ad6b8b01f25e39b45a208e32f410f23c2ef42eb3730620d1ce3298453 | 1000982127618642495132698886 | 0 | 34304803710648653896272000 | 1003364600546143542256870405 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_ReserveDataUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Supply\_event
Deposit events from Spark Protocol lending pools on Ethereum, capturing user supply transactions with token reserve addresses, amounts, and optional referral codes. Used for analyzing lending activity, liquidity provider behavior, and reserve utilization across the protocol.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ---------------- | ------------------------------------------------------------------ |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0xd1abe5db14d073883f2084c2af105652102bdefc | false | 303201023984483786718 | 293 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 18013757 | 0xd1abe5db14d073883f2084c2af105652102bdefc | 2023-08-28T14:32:23.000Z | 0 | 0x9990d4fd3ac7e31c966b9059a200952d4dbb47ff08662d245df3537b6a875936 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x5b183ae7d37aeaf4bcb953aa85622c30772163af | false | 23305223245481426 | 378 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 18010150 | 0x5b183ae7d37aeaf4bcb953aa85622c30772163af | 2023-08-28T02:26:23.000Z | 0 | 0xf5f0fd2f0f422f2aa566424e761a9a49b446c82052db2ed94a71349fbeea3fe0 |
| 0xc13e21b648a5ee794902342038ff3adab66be987 | 0xe1e271a26a42d00731caf4c7ab8ed1684510ab6e | false | 167741730536126406177 | 301 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 18015219 | 0xe1e271a26a42d00731caf4c7ab8ed1684510ab6e | 2023-08-28T19:27:59.000Z | 0 | 0xd69832ee2e89ce7559afeefb7d1e64a2793cb44b95cd52da5d11b87d54444f05 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_Supply_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Pool\_Withdraw\_event
Withdrawal events from liquidity pools recording user withdrawals of reserve assets. Contains user address, withdrawn amount, reserve or currency identifier, and recipient address for tracking outbound pool liquidity.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | false | 5190000000000000000 | 283 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 17817903 | 2023-08-01T04:56:23.000Z | 0x2aa5e240737168a6b312be029e50aa3ab4addc83392a9368cedf1aab5c1e1601 |
| 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | 0xc13e21b648a5ee794902342038ff3adab66be987 | 0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d | false | 2300000000000000000 | 175 | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 17817228 | 2023-08-01T02:40:23.000Z | 0x5bc90cfce58bd065bf83159a3281d23c045f615cffb2252df0995d26a8438868 |
| 0xa9c2649f667dd489dc7a41b8ae5b804f0d5fcfad | 0xc13e21b648a5ee794902342038ff3adab66be987 | 0xa9c2649f667dd489dc7a41b8ae5b804f0d5fcfad | false | 135796019061151760061168 | 163 | 0x83f20f44975d03b1b09e64809b757c47f942beea | 17819637 | 2023-08-01T10:45:11.000Z | 0x19d8751fb9d6a95edcd564f98c9b505762cf279552d633e6d1997acef35c9e8c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.Pool_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolConfigurator\_FlashloanPremiumToProtocolUpdated\_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_oldFlashloanPremiumToProtocol` | `STRING` | Previous flashloan premium allocated to the protocol treasury before the update. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%. |
| `in_newFlashloanPremiumToProtocol` | `STRING` | Updated flashloan premium allocated to the protocol treasury. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.PoolConfigurator_FlashloanPremiumToProtocolUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolConfigurator\_LiquidationProtocolFeeChanged\_event
Liquidation protocol fee configuration changes for assets in Spark Protocol (Aave v3 fork) lending pools on Ethereum. Tracks fee adjustments per asset with old and new fee values in basis points (e.g., 1000 = 10%) for analyzing protocol revenue 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_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%. |
| address | removed | in\_asset | in\_newFee | in\_oldFee | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee | 1000 | 0 | 260 | 20111964 | 2024-06-17T14:00:23.000Z | 0x75ee5811583faac5c9e22f2d4a4ec58091f9307e63eb4c8c77d5bdb75a6254ce |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf | 1000 | 0 | 194 | 20863927 | 2024-09-30T14:00:23.000Z | 0xfc1d79ef313c8b5af720830fb9f7f029bf700cbdfc0a472e12df1c72cce6be43 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x6c3ea9036406852006290770bedfcaba0e23a0e8 | 1000 | 0 | 181 | 23118264 | 2025-08-11T14:00:23.000Z | 0x39372da80325b306a02f93de009ecaffdd6e106b7cbd7f305ab7a39adbc527ed |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.PoolConfigurator_LiquidationProtocolFeeChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolConfigurator\_ReserveFactorChanged\_event
Reserve factor configuration change events from Spark Protocol's PoolConfigurator contract on Ethereum, tracking adjustments to the protocol's reserve allocation percentage for different assets. Shows historical parameter changes useful for analyzing protocol risk management and treasury fee structure evolution.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 346 | 18385588 | 2023-10-19T16:32:23.000Z | 0x557c5c6306aec0f58c282c7b19519eebf5b94c3cab32e729adfee4cd2c41b967 | 500 | 0 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 353 | 18385588 | 2023-10-19T16:32:23.000Z | 0x557c5c6306aec0f58c282c7b19519eebf5b94c3cab32e729adfee4cd2c41b967 | 500 | 1000 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x83f20f44975d03b1b09e64809b757c47f942beea | 20 | 16776448 | 2023-03-07T12:33:11.000Z | 0xff56ceba37cfa6983667b711a19d7459fc9a772b60b749c29f065a123f6aed64 | 1000 | 0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.PoolConfigurator_ReserveFactorChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### PoolConfigurator\_ReserveInitialized\_event
Reserve initialization events from Spark Protocol (Aave v3 fork) on Ethereum capturing when new lending assets are added to the protocol. Records contract addresses for interest-bearing tokens (aTokens), debt tokens, and interest rate strategy contracts for analyzing protocol expansion and asset onboarding.
| 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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 0xe7df13b8e3d6740fe17cbe928c7334243d86c92f | 339 | 18385588 | 2023-10-19T16:32:23.000Z | 0x557c5c6306aec0f58c282c7b19519eebf5b94c3cab32e729adfee4cd2c41b967 | 0x0dae62f953ceb2e969fb4de85f3f9074fa920776 | 0x529b6158d1d2992e3129f7c69e81a7c677dc3b12 | 0xbc8a68b0ab0617d7c90d15bb1601b25d795dc4c8 |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db | 52 | 16776431 | 2023-03-07T12:29:47.000Z | 0x76ad67a5e378e3592462a5fee09c3c7a7097cb8d729c11194778509213153093 | 0x3c6b93d38ffa15ea995d1bc950d5d0fa6b22bd05 | 0x2e7576042566f8d6990e07a1b61ad1efd86ae70d | 0x764b4ab9bca18eb633d92368f725765ebb8f047c |
| 0x542dba469bde58faee189ffb60c6b49ce60e0738 | false | 0x83f20f44975d03b1b09e64809b757c47f942beea | 0x78f897f0fe2d3b5690ebae7f19862deacedf10a7 | 44 | 16776431 | 2023-03-07T12:29:47.000Z | 0x76ad67a5e378e3592462a5fee09c3c7a7097cb8d729c11194778509213153093 | 0xec6c6abed4dc03299eff82ac8a0a83643d3cb335 | 0xabc57081c04d921388240393ec4088aa47c6832b | 0xec4cf692c18e62159a39704aa1db82ca2306ff90 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.PoolConfigurator_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spETH\_Deposit\_event
Deposit events from the Spark v1 protocol's spETH (staked ETH) vault on Ethereum, recording asset deposits with corresponding share issuance. Shows asset-to-share conversion rates and depositor addresses for analyzing staking activity and vault growth.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------- | ------------------------------------------ | ------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f | false | 0x22a84d3612422873985b6acb039c7b43f13ee2b5 | 999999999999999999 | 0x22a84d3612422873985b6acb039c7b43f13ee2b5 | 999740963303216210 | 82 | 23671793 | 2025-10-27T22:35:59.000Z | 0xee8c3b349b102acf49923e93c825cdc3af4499f6b1d3d342cac6e0bed927be43 |
| 0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f | false | 0x328ca8f95cd62a07e10343c2ea41268a5d1c99ea | 3000000000000000000 | 0x328ca8f95cd62a07e10343c2ea41268a5d1c99ea | 2999245447937879747 | 410 | 23670333 | 2025-10-27T17:41:11.000Z | 0x014af408e8e513e4ea88c9cc9cf4255ef8d32829ead1a2f3d958cdc67baf0553 |
| 0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f | false | 0x451248229712d6f207ff9466d8d3a33cb59d103c | 4950000000000000000 | 0x451248229712d6f207ff9466d8d3a33cb59d103c | 4948847057357167610 | 147 | 23666715 | 2025-10-27T05:31:59.000Z | 0x078483c5bcc202aa7d087df881240adb0d64cd2ed871b90efab529ff2e95c81e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spETH_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spETH\_Withdraw\_event
Withdrawal events from Spark Protocol's spETH (staked ETH) vault on Ethereum, recording conversions of spETH shares back to ETH assets. Contains share amounts, corresponding asset values, and participant addresses for analyzing vault redemption activity and share-to-asset exchange rates.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | in\_receiver | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | -------------------- | ------------------------------------------ | -------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f | false | 0x00ff6b7d26407a46af2b631b4fa452a036d027e5 | 11004743852330590387 | 0x00ff6b7d26407a46af2b631b4fa452a036d027e5 | 10999606656216840303 | 32 | 0x00ff6b7d26407a46af2b631b4fa452a036d027e5 | 23712209 | 2025-11-02T14:22:59.000Z | 0x8cd87650c15ca531dd2938a651903c9b81318e654ced02dc98c35e6edfeedcc7 |
| 0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f | false | 0x3c16d0d61d9cff2cbac3dc02ccf296421291e51e | 22000000000000000 | 0x3c16d0d61d9cff2cbac3dc02ccf296421291e51e | 21996323981273159 | 59 | 0x3c16d0d61d9cff2cbac3dc02ccf296421291e51e | 23653890 | 2025-10-25T10:31:23.000Z | 0x17d32d5c9c00e3d8a66bad4c5585cddeb866f308bb67b58ce8f72f708026dc57 |
| 0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f | false | 0x3a3986d7be9463a530c71387c4a94cbaeb8592bc | 700028006803626289 | 0x3a3986d7be9463a530c71387c4a94cbaeb8592bc | 699894438312110926 | 176 | 0x3a3986d7be9463a530c71387c4a94cbaeb8592bc | 23658514 | 2025-10-26T02:00:59.000Z | 0x994bf6f6c62bf2aa65aebe3ee554e5ab8acdb407e51d6cb1309bf6bc5477f3b6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spETH_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spPYUSD\_Deposit\_event
Deposit events from Spark Protocol's spPYUSD vault on Ethereum, recording PYUSD (PayPal USD) stablecoin deposits with corresponding share issuance. Useful for tracking vault inflows, share-to-asset exchange rates, and depositor behavior in the Spark lending protocol.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x80128dbb9f07b93dde62a6daeadb69ed14a7d354 | false | 0x0000000000000000000000000000000000000001 | 1000000 | 0x3300f198988e4c9c63f75df86de36421f06af8c4 | 1000000 | 127 | 24018489 | 2025-12-15T14:06:11.000Z | 0x8faf325fc9893985064042909bd9d560a47c49b3fd600f752414a74173a85347 |
| 0x80128dbb9f07b93dde62a6daeadb69ed14a7d354 | false | 0x52a8305f29f85bec5fa6ee78b87ddd2218d8e12e | 19953517376 | 0x52a8305f29f85bec5fa6ee78b87ddd2218d8e12e | 19953493990 | 233 | 24018610 | 2025-12-15T14:30:35.000Z | 0xc3ea4b71483233ecceb79d9a3665e478dabe5865cfa39c0ef8bcf728ad9bc3bb |
| 0x80128dbb9f07b93dde62a6daeadb69ed14a7d354 | false | 0x90598105df535b19420bd0d89aff73ecd6966312 | 690000 | 0x90598105df535b19420bd0d89aff73ecd6966312 | 689990 | 313 | 24019429 | 2025-12-15T17:15:11.000Z | 0xeb37749134ff1b1d8c168d6d435ae7edd32d4bb9dcbe6d063a01a70e6387034b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spPYUSD_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spPYUSD\_Withdraw\_event
Withdrawal events from Spark Protocol's PYUSD (PayPal USD) vault on Ethereum, tracking redemptions where users burn vault shares to receive underlying PYUSD assets. Records share-to-asset conversion rates for analyzing vault liquidity flows 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | in\_receiver | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x80128dbb9f07b93dde62a6daeadb69ed14a7d354 | false | 0xe6db30da89e8c6492da3677fa9b5a7d59124995e | 9997 | 0xe6db30da89e8c6492da3677fa9b5a7d59124995e | 9996 | 585 | 0xe6db30da89e8c6492da3677fa9b5a7d59124995e | 24027666 | 2025-12-16T20:50:59.000Z | 0xb62242a28dda4b7f90e41e5b948e596f94b0cd02130baec17dee0fc3a003e0dc |
| 0x80128dbb9f07b93dde62a6daeadb69ed14a7d354 | false | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 2000000 | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 2000000 | 91 | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 24018546 | 2025-12-15T14:17:35.000Z | 0xd5bec6e74851f0728cbc5b451e047bb758ff12a608dd97f1ba56eb19c5c0a3c9 |
| 0x80128dbb9f07b93dde62a6daeadb69ed14a7d354 | false | 0x1f9f5a2511c4ca5b768dadd067bc19916dd59d88 | 290000000 | 0x1f9f5a2511c4ca5b768dadd067bc19916dd59d88 | 289775755 | 181 | 0x1f9f5a2511c4ca5b768dadd067bc19916dd59d88 | 24069656 | 2025-12-22T17:31:11.000Z | 0x4d565b09c5137bc189d7129e44cac73d8abd6e3b07368d0d0cb11796d53ffc97 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spPYUSD_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spToken\_BalanceTransfer\_event
BalanceTransfer event logs from Spark Protocol's spToken contract on Ethereum, tracking all transfers of interest-bearing deposit tokens between addresses. Used for analyzing lending pool liquidity flows, user deposit/withdrawal patterns, and spToken holder 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_from` | `STRING` | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_to` | `STRING` | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_value` | `STRING` | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values. |
| `in_index` | `STRING` | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27). |
| in\_to | address | in\_from | removed | in\_index | in\_value | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xbd7d6a9ad7865463de44b05f04559f65e3b11704 | 0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db | 0x465af2bd215b5f6ff97705dd821ff281ca1ef55a | false | 1009415560399684515337444845 | 990689894982841114 | 192 | 18517977 | 2023-11-07T05:24:59.000Z | 0x17a216d19ad05b6188503aa598696e1e319a7aef2707300f38868c72dcd71949 |
| 0xbd7d6a9ad7865463de44b05f04559f65e3b11704 | 0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db | 0x074fddd3ec0e28a2589fcef3662c7ff65fda9f31 | false | 1012009211623136588334408366 | 494066649055557848967 | 232 | 18883032 | 2023-12-28T08:50:59.000Z | 0xb5f82511ba9a75339898d2b65f080524ddad5ab5fd8fc58b0b3c78bd8cd37735 |
| 0xbd7d6a9ad7865463de44b05f04559f65e3b11704 | 0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db | 0x1758094d540bded730e4b0c35db1e25ea1fccda1 | false | 1012008525465669322612842603 | 495055118008485174115 | 183 | 18882940 | 2023-12-28T08:32:35.000Z | 0x0f5213241fe4c04832c0085ed28f03fde1ea1c776f27b29c93247ef9850bd8ca |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spToken_BalanceTransfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spToken\_Burn\_event
Burn events from Spark Protocol interest-bearing token contracts on Ethereum, capturing withdrawals where users redeem spTokens for underlying assets. Records include burned amount, accrued interest, and account addresses for analyzing redemption patterns and yield calculations.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | ---------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x377c3bd93f2a2984e1e7be6a5c22c525ed4a4815 | 0x3d73fb14ee12a9baabc41122fe852e8a10798113 | false | 1112747711393705686340603119 | 39993239710 | 0x3d73fb14ee12a9baabc41122fe852e8a10798113 | 252 | 22130792 | 2025-03-26T11:30:47.000Z | 0xa92922aeef518542860d30217d19577879558cbfca6922e283d6b77590b8e2da | 838371728 |
| 0x3cfd5c0d4acaa8faee335842e4f31159fc76b008 | 0xaaf9f14f20145ad50db369e52b2793bfeb18a45b | false | 1000000000000000000000000000 | 2000000000000000000000 | 0xaaf9f14f20145ad50db369e52b2793bfeb18a45b | 167 | 22130691 | 2025-03-26T11:10:35.000Z | 0x5d03206ec82e604ad8ba2a9f86465584d5ccd4ae9a7f576f9e109951e3b941ac | 0 |
| 0x4197ba364ae6698015ae5c1468f54087602715b2 | 0x6c30b5471e42e2d47c18b98df187f35edbab8357 | false | 1000137529380430378499303886 | 7999998 | 0x6c30b5471e42e2d47c18b98df187f35edbab8357 | 110 | 22128142 | 2025-03-26T02:38:35.000Z | 0x570b2aff8e4cb7a5e1f29c48c7362c154cd9e5f4e5c9f4ce341dfe991f06c488 | 2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spToken\_Initialized\_event
Initialization events for Spark Protocol spTokens (interest-bearing receipt tokens) on Ethereum, capturing when new asset markets are added with metadata including token name, symbol, decimals, underlying asset address, and associated pool/treasury/incentives controller contracts. Used for tracking Spark lending market expansion and spToken configuration details.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ | ------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x9985df20d7e9103ecbceb16a84956434b6f06ae8 | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 364 | 0xb137e7d16564c81ae2b0c8ee6b55de81dd46ece5 | 17514251 | Spark rETH | 2023-06-19T14:00:47.000Z | sprETH | 0xa4073ced1bd5d26a95fd3642a30417ffea5ce9dc54d84a3a13c47ddb74b65555 | 18 | 0xae78736cd615f374d3085123a210448e74fc6393 | 0x4370d3b6c9588e02ce9d22e684387859c7ff5b34 |
| 0x7b481acc9fdaddc9af2cbea1ff2342cb1733e50f | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 373 | 0xb137e7d16564c81ae2b0c8ee6b55de81dd46ece5 | 17365842 | Spark GNO | 2023-05-29T16:30:59.000Z | spGNO | 0x87ab228bf3cbe6c6f763b0f66e6252a0ff90654ebdfaeaf7fdd31a28e2d16bb6 | 18 | 0x6810e776880c02933d47db1b9fc05908e5386b96 | 0x0000000000000000000000000000000000000000 |
| 0xa9d4ecebd48c282a70cfd3c469d6c8f178a5738e | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 238 | 0xb137e7d16564c81ae2b0c8ee6b55de81dd46ece5 | 22117224 | Spark LBTC | 2025-03-24T14:00:35.000Z | spLBTC | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | 8 | 0x8236a87084f8b84306f72007f36f2618a5634494 | 0x4370d3b6c9588e02ce9d22e684387859c7ff5b34 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spToken_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spToken\_Mint\_event
Mint events from Spark Protocol's interest-bearing spToken contracts on Ethereum, recording deposit amounts, accrued interest balances, and recipient addresses. Enables tracking of lending pool deposits and yield accumulation across Spark's money market 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 |
| ------------------------------------------ | ------- | ---------------------------- | ------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x6715bc100a183cc65502f05845b589c1919ca3d3 | false | 1000000000000000000000000000 | 150000000000000000000000 | 0xa53a13a80d72a855481de5211e7654fabdfe3526 | 394 | 21601942 | 0xa53a13a80d72a855481de5211e7654fabdfe3526 | 2025-01-11T14:49:35.000Z | 0x9c4555d316a2d398a6372965a9e2e30e6adbe5181014c87e73708335ee4f5296 | 0 |
| 0x3cfd5c0d4acaa8faee335842e4f31159fc76b008 | false | 1000000000000000000000000000 | 4255924522982780138 | 0xcd54cc88ac8bb4f437937b5dfa9c341570c6169b | 255 | 21600711 | 0xcd54cc88ac8bb4f437937b5dfa9c341570c6169b | 2025-01-11T10:41:59.000Z | 0x697d3e0ded41645df89d267169f67083a3db421501322c76ea22dd019be8a150 | 0 |
| 0x12b54025c112aa61face2cdb7118740875a566e9 | false | 1000040217747267515389394109 | 15948147065998321492 | 0x8ed9e66a5cd8dde284038ecb17d3b82f0b557fa1 | 103 | 21598106 | 0x8ed9e66a5cd8dde284038ecb17d3b82f0b557fa1 | 2025-01-11T01:57:59.000Z | 0x989afbdcefc42289123c255d16933419da13e7f3963356e01da414dc7fe17d0c | 1001744187466 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spUSDC\_Deposit\_event
Deposit events from Spark Protocol's spUSDC vault on Ethereum, recording USDC deposits with corresponding share mints. Used for analyzing vault inflows, depositor behavior, and share-to-asset conversion rates.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------ | ------------------------------------------ | ------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 1006394 | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 1006394 | 291 | 23597347 | 2025-10-17T12:21:35.000Z | 0x975e9153a4cfb29152f12f53c2a6652a0162c1bfa7aa3b8e192fdf9685df23cb |
| 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 1000000 | 0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c | 1000000 | 289 | 23597359 | 2025-10-17T12:23:59.000Z | 0xe55f2f6561194142842d728c01786dec1d0df88759b5f9907b8b915cd75b1b06 |
| 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false | 0x0000aa99e12ad566e4c97882296076023d123cfe | 390000000000 | 0x0000aa99e12ad566e4c97882296076023d123cfe | 389187611641 | 430 | 23742330 | 2025-11-06T19:28:47.000Z | 0x098d2f0bf15e66c815cd5178ad750f253f8ed75c996f7615979cd8372d09dc5f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spUSDC_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spUSDC\_Withdraw\_event
Withdrawal events from the Spark v1 USDC vault (spUSDC) on Ethereum, recording when users redeem vault shares for underlying USDC assets. Tracks the conversion between shares and assets for analyzing vault redemption activity and share price dynamics.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | in\_receiver | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ------------------------------------------ | ----------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false | 0x18dff5b53cb6c4a5bddd0b7f0396a4210a2cff90 | 73042363029 | 0x18dff5b53cb6c4a5bddd0b7f0396a4210a2cff90 | 73026654785 | 188 | 0x18dff5b53cb6c4a5bddd0b7f0396a4210a2cff90 | 23633508 | 2025-10-22T13:57:35.000Z | 0x126c5434a953d55c581a625a36d85b63bb10d61357b9b73aa7f576b6b1743f1e |
| 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false | 0x83a05e2f45105d88ea0f505544cd8df0b547c1d0 | 8985973101 | 0x83a05e2f45105d88ea0f505544cd8df0b547c1d0 | 8983883869 | 613 | 0x83a05e2f45105d88ea0f505544cd8df0b547c1d0 | 23634483 | 2025-10-22T17:15:11.000Z | 0x7762972b095a0762b9f2456d6abb30eeb21e967f830eba4dc4ad3405a7b7b4e2 |
| 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false | 0x87062ea097b5927bfe3e27d1fe9b4ad4d93f6475 | 2170000000 | 0x87062ea097b5927bfe3e27d1fe9b4ad4d93f6475 | 2169580144 | 730 | 0x87062ea097b5927bfe3e27d1fe9b4ad4d93f6475 | 23632300 | 2025-10-22T09:53:11.000Z | 0x30b43dbdc2bf4372d4109674b8c7765f5fc2935f48c9f45c2dc6a50e5d8a242f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spUSDC_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spUSDT\_Deposit\_event
Deposit events from Spark Protocol's spUSDT vault on Ethereum, recording USDT deposits with corresponding share issuance. Tracks vault interactions including depositor addresses, asset amounts (6 decimals), and shares minted for analyzing yield strategy participation 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe2e7a17dff93280dec073c995595155283e3c372 | false | 0x2869f0a4a8b63b9d3357588074fb9ffa2d87b985 | 5200000000 | 0x2869f0a4a8b63b9d3357588074fb9ffa2d87b985 | 5194229909 | 162 | 23684533 | 2025-10-29T17:26:47.000Z | 0xedd12f40ae5ee56ea667e2dc6d632736d91f947cf976bfeea0538ef543b12d63 |
| 0xe2e7a17dff93280dec073c995595155283e3c372 | false | 0x523b19b99d60ff8345c314b0987ac4499b3bd077 | 15599976347 | 0x523b19b99d60ff8345c314b0987ac4499b3bd077 | 15582973558 | 659 | 23683361 | 2025-10-29T13:31:11.000Z | 0x086f2c2b0e5016b6cc0914e4274d58a6d57c7334c100fb99d427571a58358460 |
| 0xe2e7a17dff93280dec073c995595155283e3c372 | false | 0x5d4ad877d2442dc69dfd4c8576d45249784272e9 | 99998325326 | 0x5d4ad877d2442dc69dfd4c8576d45249784272e9 | 99894795785 | 209 | 23680126 | 2025-10-29T02:38:23.000Z | 0x06903d80b13e96e025cdb19a5ee7f78907c6a83f6bec59e7d981532c8caa4f66 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spUSDT_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### spUSDT\_Withdraw\_event
Withdrawal events from Spark Protocol's USDT vault (spUSDT) on Ethereum, tracking share redemptions with corresponding asset amounts, owner addresses, and receivers. Used for analyzing vault outflows and calculating share-to-asset conversion rates.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_receiver` | `STRING` | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_owner` | `STRING` | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_assets` | `STRING` | Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol's accounting system. |
| `in_shares` | `STRING` | Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol's accounting system. |
| address | removed | in\_owner | in\_assets | in\_sender | in\_shares | log\_index | in\_receiver | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ------------------------------------------ | ---------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe2e7a17dff93280dec073c995595155283e3c372 | false | 0x9b1d7c56c53c6b6f5cdd26f8f9fa021bd0d51e74 | 101120896 | 0x9b1d7c56c53c6b6f5cdd26f8f9fa021bd0d51e74 | 100966900 | 509 | 0x9b1d7c56c53c6b6f5cdd26f8f9fa021bd0d51e74 | 23709052 | 2025-11-02T03:47:59.000Z | 0x3605084f321a6d62ce1f4806e5d742bb75ac85ff3a6076808a99cff194d9c9b7 |
| 0xe2e7a17dff93280dec073c995595155283e3c372 | false | 0xd900411debddaa5483cd5832f4102556df70dc96 | 10000076636 | 0xd900411debddaa5483cd5832f4102556df70dc96 | 9993669335 | 107 | 0xd900411debddaa5483cd5832f4102556df70dc96 | 23657418 | 2025-10-25T22:20:47.000Z | 0x6571634c996cd72e6ecaa08e5029e9540589e5fc7a1297309e443fbdbb697ec3 |
| 0xe2e7a17dff93280dec073c995595155283e3c372 | false | 0x15775b23340c0f50e0428d674478b0e9d3d0a759 | 10006 | 0x15775b23340c0f50e0428d674478b0e9d3d0a759 | 10000 | 136 | 0x15775b23340c0f50e0428d674478b0e9d3d0a759 | 23659979 | 2025-10-26T06:55:11.000Z | 0x1bf9f0b668f8247ca717e062befdd9e52ca2c7040b9a53255c256b408d90fc89 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.spUSDT_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StableDebtToken\_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.spark_v1_ethereum.StableDebtToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StableDebtToken\_Initialized\_event
Initialization events for stable-rate debt tokens in Spark Protocol lending markets on Ethereum, capturing token metadata including name, symbol, decimals, and associated pool and underlying asset addresses. Used for tracking new debt token deployments and market expansions.
| 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_incentivesController` | `STRING` | Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtTokenDecimals` | `INT64` | Number of decimal places for the debt token. Integer value matching the precision of the underlying asset. |
| `in_debtTokenName` | `STRING` | Human-readable name of the debt token being initialized in the lending protocol. |
| `in_debtTokenSymbol` | `STRING` | Ticker symbol for the debt token being initialized in the lending protocol. |
| `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 | block\_number | block\_timestamp | in\_debtTokenName | transaction\_hash | in\_debtTokenSymbol | in\_underlyingAsset | in\_debtTokenDecimals | in\_incentivesController |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ----------------------- | ------------------------------------------------------------------ | ------------------- | ------------------------------------------ | --------------------- | ------------------------------------------ |
| 0xbf13910620722d4d4f8a03962894eb3335bf4fae | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 374 | 17365842 | 2023-05-29T16:30:59.000Z | Spark Stable Debt GNO | 0x87ab228bf3cbe6c6f763b0f66e6252a0ff90654ebdfaeaf7fdd31a28e2d16bb6 | stableDebtGNO | 0x6810e776880c02933d47db1b9fc05908e5386b96 | 18 | 0x0000000000000000000000000000000000000000 |
| 0xfbaf333a919cb92caf9e85966d4e28fff80e5d1d | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 239 | 22117224 | 2025-03-24T14:00:35.000Z | Spark Stable Debt LBTC | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | stableDebtLBTC | 0x8236a87084f8b84306f72007f36f2618a5634494 | 8 | 0x4370d3b6c9588e02ce9d22e684387859c7ff5b34 |
| 0x1b16e95958e06291c028e709727f8b0bb56451d3 | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 251 | 22117224 | 2025-03-24T14:00:35.000Z | Spark Stable Debt rsETH | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | stableDebtrsETH | 0xa1290d69c65a6fe4df752f95823fae25cb99e5a7 | 18 | 0x4370d3b6c9588e02ce9d22e684387859c7ff5b34 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StableDebtToken_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StableDebtToken\_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.spark_v1_ethereum.StableDebtToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_Recovered\_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_token` | `STRING` | Token address involved in the transaction 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_Recovered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_Referral\_event
Referral reward events from Spark Protocol's staking contract on Ethereum, tracking reward amounts distributed to users through the referral program. Used for analyzing referral incentive distribution and user acquisition economics.
| 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_referral` | `STRING` | Referral code identifier associated with the transaction. Numeric string representation, often '0' when no referral is present. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol 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. |
| address | in\_user | removed | in\_amount | log\_index | in\_referral | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x55e55c649895940826a852820d9e1a076ec47b09 | false | 10000000000000000000 | 96 | 1 | 22796704 | 2025-06-27T15:35:35.000Z | 0x98c4eb625f8e1031d7bcf55359eedc282004e06f853c0a4d22799f6ee2c6630a |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0xcc95127fe5195c9deee63fb7ab921dbdcbbb8c8b | false | 1036537158726295518601 | 139 | 1 | 22847827 | 2025-07-04T19:04:59.000Z | 0x7efd9048b55b66d479c798cb6f1d76a065a9ec48b05a4d47f99fbff71cdcd0a9 |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x6ae4e505c3e1f56014d5e3a5b73aeffbf71b03f4 | false | 132796426604018922690 | 231 | 1 | 22843191 | 2025-07-04T03:33:23.000Z | 0xd1d04214338cf2cb01254daf11ee0f8d31b65ee70f09f440e731dab86beedf0c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_Referral_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_RewardAdded\_event
RewardAdded events from Spark Protocol v1 staking contracts on Ethereum, capturing when new reward tokens are allocated to staking pools. Used for tracking reward distribution schedules and analyzing staking incentive programs.
| 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_reward` | `STRING` | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | false | 21688679604261796042617960 | 139 | 22967140 | 2025-07-21T11:02:23.000Z | 0xf0af1f60548794fe82d785a92b1d50c824075acb959a99e90b645dfc85679325 |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | false | 21685216894977168949771690 | 1012 | 23216211 | 2025-08-25T06:05:11.000Z | 0x87a5829941cb71f0b1f57d434171b175474432a414b865bbc8221f3a019fde08 |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | false | 21691276636225266362252663 | 313 | 23315890 | 2025-09-08T04:08:35.000Z | 0xeeaf316b5b998e0a0d57d2a13ce0d653d8ac13d510318b991711af145cc45ea8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_RewardAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_RewardPaid\_event
Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_reward` | `STRING` | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_user | removed | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x01c2f22754e1c2cc64a18ba6162e5c7d417fff7f | false | 9045209254313298181749 | 439 | 22945050 | 2025-07-18T09:00:23.000Z | 0xda59689cb1f084c6ad6b83d90711b0870b3cef4a8ba9ec09255b1b682444412e |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x05654ff0cb3635fa5de00cc11607dbf203435c13 | false | 5939368676934709111434 | 419 | 22947232 | 2025-07-18T16:18:35.000Z | 0x3f86b86a444712cbe85f1422f1d70cfcbcc921a4039e986d8504f9bcbc742b98 |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x0ee69a11b4391c5af5eb2fb088c2df5dd2a0d075 | false | 5117416871734860743663 | 165 | 22945052 | 2025-07-18T09:00:47.000Z | 0x46a994e6ca1079928303fe518fa74aaba4ccf540b7004035b4d26902051f61c6 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_RewardsDistributionUpdated\_event
Events emitted when the rewards distribution address is updated in Spark v1 staking contracts on Ethereum. Tracks administrative changes to the address authorized to distribute staking rewards.
| 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_newRewardsDistribution` | `STRING` | The new rewards distribution contract address that was set in this update event. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the contract authorized to distribute staking rewards. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_newRewardsDistribution |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | false | 143 | 22817692 | 2025-06-30T14:00:23.000Z | 0x666eb7807c1b4098f9b91658eb008e8931063c5050e4dbe28bd6fac3a2948d02 | 0x3959e23a63ca7ac12d658bb44f90cb1f7ee4c02c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_RewardsDistributionUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_RewardsDurationUpdated\_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_newDuration` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_RewardsDurationUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_Staked\_event
Staking deposit events from Spark v1 protocol on Ethereum, capturing user addresses and token amounts when positions are created. Tracks individual stake transactions with wei-denominated amounts for analyzing protocol TVL (Total Value Locked) growth and user deposit 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_user` | `STRING` | Address of the user account associated with the transaction or protocol 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. |
| address | in\_user | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x01149169454715c5ccaf0a47dc53f8cdd2412d54 | false | 1444585731525000000000000 | 129 | 22975795 | 2025-07-22T16:05:23.000Z | 0x5ec39f2891522e3aca1716464f33d5c8e387be56cfb1c691a10ccd8f6298b44b |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x01149169454715c5ccaf0a47dc53f8cdd2412d54 | false | 500007014999000000000000 | 482 | 22975293 | 2025-07-22T14:24:11.000Z | 0xb3de329060e51dc930995c8f002bb7bed2858b3758f9a66863764543423a9c9b |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x01857b094e58e94f4fea0ba506b8475504910a8f | false | 6936413950793426583425 | 52 | 22974989 | 2025-07-22T13:22:59.000Z | 0x2df10a59e970af47915d162340b6f5809ad7fe5af5fe23cb65ab1af18925d7fc |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_Staked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### StakingRewards\_Withdrawn\_event
Staking reward withdrawal events from Spark protocol on Ethereum, recording when users withdraw their earned rewards with withdrawal amounts and user addresses. Used for tracking reward distribution patterns and participant behavior in the Spark staking program.
| 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x05654ff0cb3635fa5de00cc11607dbf203435c13 | false | 1169901075004693273519325 | 135 | 23256284 | 2025-08-30T20:16:11.000Z | 0xd15692432e717484814f30ccd02aac4606af712c912b72f5ee9b3c4eaa76e904 |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x0ee69a11b4391c5af5eb2fb088c2df5dd2a0d075 | false | 50228656577589786091 | 436 | 23254054 | 2025-08-30T12:48:23.000Z | 0x5dad783fa19913e4dc5644ff2dfa9f4687cc0c3fa24e8d219d8093c6537adfac |
| 0x173e314c7635b45322cd8cb14f44b312e079f3af | 0x198a2e8b12bb4f12e7f7a0d154dced16c7967c07 | false | 50000000000000000000000 | 1990 | 23254057 | 2025-08-30T12:48:59.000Z | 0xd18896e01897fd023c4d7410da60007d8b49ca5b5eab80dcd65301ee519b150a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.StakingRewards_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sUSDC\_Deposit\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ----------- |
| `block_timestamp` | `TIMESTAMP` | - |
| `block_number` | `INT64` | - |
| `transaction_hash` | `STRING` | - |
| `log_index` | `INT64` | - |
| `address` | `STRING` | - |
| `removed` | `BOOL` | - |
| `in_sender` | `STRING` | - |
| `in_owner` | `STRING` | - |
| `in_assets` | `STRING` | - |
| `in_shares` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.sUSDC_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### sUSDC\_Withdraw\_event
*No description available.*
| Column | Type | Description |
| ------------------ | ----------- | ----------- |
| `block_timestamp` | `TIMESTAMP` | - |
| `block_number` | `INT64` | - |
| `transaction_hash` | `STRING` | - |
| `log_index` | `INT64` | - |
| `address` | `STRING` | - |
| `removed` | `BOOL` | - |
| `in_sender` | `STRING` | - |
| `in_receiver` | `STRING` | - |
| `in_owner` | `STRING` | - |
| `in_assets` | `STRING` | - |
| `in_shares` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.sUSDC_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VariableDebtToken\_Burn\_event
Variable rate debt token burn events emitted when users repay borrowed assets in lending protocols. Records the debt amount repaid, accumulated interest, and liquidity index at the time of repayment for tracking variable-rate loan lifecycle and interest accrual.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------------------- | ------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ----------------------- |
| 0xd5c3e3b566a42a6110513ac7670c1a86d76e13e6 | 0x6236b9a8477d934dd1bfc9899bd8a11b8a670afc | false | 1001258000703429566284182985 | 39967287531874684 | 0x0000000000000000000000000000000000000000 | 355 | 17928923 | 2023-08-16T17:37:23.000Z | 0x8ea2cd21490c467e469c2fc3fc0521e7901e6c4452b467914f4fcc04ffe08fd1 | 32712468125316 |
| 0xf705d2b7e92b3f38e6ae7afadaa2fee110fe5914 | 0x171c53d55b1bcb725f660677d9e8bad7fd084282 | false | 1007769838259551760529283171 | 977385044138115928718613 | 0x0000000000000000000000000000000000000000 | 219 | 17930291 | 2023-08-16T22:12:35.000Z | 0x92da596a465939987619838f8b3e86627113932156618348023913fd7558a471 | 22614955861884071281387 |
| 0xf705d2b7e92b3f38e6ae7afadaa2fee110fe5914 | 0xd3cbf4408c97f8de3c54e16b425e520d87760cdd | false | 1007750391002041397404600634 | 500000000000000000000 | 0x0000000000000000000000000000000000000000 | 277 | 17928687 | 2023-08-16T16:49:35.000Z | 0x71663511810777dd51c99b14ed2c51265ed70e07d79b525bebe00305a142fac4 | 273400302989964253 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.VariableDebtToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VariableDebtToken\_Initialized\_event
Variable debt token initialization events from Spark lending protocol on Ethereum, recording when new borrowable assets are added to the pool. Tracks token metadata (symbols like variableDebtUSDC, variableDebtGNO), underlying asset addresses, and incentive controller configurations for analyzing protocol expansion and supported 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_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_incentivesController` | `STRING` | Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtTokenDecimals` | `INT64` | Number of decimal places for the debt token. Integer value matching the precision of the underlying asset. |
| `in_debtTokenName` | `STRING` | Human-readable name of the debt token being initialized in the lending protocol. |
| `in_debtTokenSymbol` | `STRING` | Ticker symbol for the debt token being initialized in the lending protocol. |
| `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 | block\_number | block\_timestamp | in\_debtTokenName | transaction\_hash | in\_debtTokenSymbol | in\_underlyingAsset | in\_debtTokenDecimals | in\_incentivesController |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------- | ------------------------------------------------------------------ | ------------------- | ------------------------------------------ | --------------------- | ------------------------------------------ |
| 0x57a2957651da467fcd4104d749f2f3684784c25a | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 375 | 17365842 | 2023-05-29T16:30:59.000Z | Spark Variable Debt GNO | 0x87ab228bf3cbe6c6f763b0f66e6252a0ff90654ebdfaeaf7fdd31a28e2d16bb6 | variableDebtGNO | 0x6810e776880c02933d47db1b9fc05908e5386b96 | 18 | 0x0000000000000000000000000000000000000000 |
| 0x764591dc9ba21c1b92049331b80b6e2a2acf8b17 | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 244 | 22117224 | 2025-03-24T14:00:35.000Z | Spark Variable Debt tBTC | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | variableDebttBTC | 0x18084fba666a33d37592fa2633fd49a74dd93a88 | 18 | 0x4370d3b6c9588e02ce9d22e684387859c7ff5b34 |
| 0xb0b14dd477e6159b4f3f210cf45f0954f57c0fab | 0xc13e21b648a5ee794902342038ff3adab66be987 | false | 0x | 248 | 22117224 | 2025-03-24T14:00:35.000Z | Spark Variable Debt ezETH | 0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab | variableDebtezETH | 0xbf5495efe5db9ce00f80364c8b423567e58d2110 | 18 | 0x4370d3b6c9588e02ce9d22e684387859c7ff5b34 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.VariableDebtToken_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VariableDebtToken\_Mint\_event
Variable debt token minting events from lending protocols recording debt issuance to borrowers. Contains borrower address, delegated beneficiary, debt amount, and liquidity index in ray units (1e27) for tracking compounding interest on variable-rate loans.
| 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 |
| ------------------------------------------ | ------- | ---------------------------- | -------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x2e7576042566f8d6990e07a1b61ad1efd86ae70d | false | 1016183352447502092972378895 | 35000428362340379709 | 0xbd7d6a9ad7865463de44b05f04559f65e3b11704 | 238 | 18360149 | 0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b | 2023-10-16T03:08:23.000Z | 0x9b303ba5173d383a0884db634ac4efe99f08de6a290ca658451829ce98d6e3d6 | 428362340379709 |
| 0x2e7576042566f8d6990e07a1b61ad1efd86ae70d | false | 1016182193850258646390086116 | 75248032398002238826 | 0xbd7d6a9ad7865463de44b05f04559f65e3b11704 | 198 | 18360051 | 0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b | 2023-10-16T02:48:35.000Z | 0xf6035c8ee2e87e8a536bb2fcdbaacbfe00aa9e02710fafd5db0a2955fc6297ac | 248032398002238826 |
| 0x2e7576042566f8d6990e07a1b61ad1efd86ae70d | false | 1016195726834655588510924497 | 30005001326125201254 | 0xbd7d6a9ad7865463de44b05f04559f65e3b11704 | 122 | 18361203 | 0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b | 2023-10-16T06:39:47.000Z | 0x0635df3d6fb1789d7232e53d72faee41fa5774b47e46172842ce273340ac6b8a | 5001326125201254 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.spark_v1_ethereum.VariableDebtToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***