> ## 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_avalanche

> Tables in tt-contracts.spark_v1_avalanche

## Tables

### spUSDC\_Deposit\_event

Deposit events from the Spark Protocol spUSDC vault on Avalanche, recording when users deposit USDC assets in exchange for vault shares. Tracks depositor addresses, amounts deposited, and corresponding share allocations for analyzing vault participation and liquidity provision patterns.

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

<Accordion title="Sample Data">
  | address                                    | removed | in\_owner                                  | in\_assets  | in\_sender                                 | in\_shares  | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ----------- | ------------------------------------------ | ----------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false   | 0x182b9569feb9bfc90ece9e2d3489a19882ed522a | 820000000   | 0x182b9569feb9bfc90ece9e2d3489a19882ed522a | 819351793   | 17         | 73863092      | 2025-12-16T18:33:01.000Z | 0x03b8ef830ffee05a626db3c73c734ab2125499b8997e43771c515a9cf929a2d6 |
  | 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false   | 0x182b9569feb9bfc90ece9e2d3489a19882ed522a | 2031398408  | 0x182b9569feb9bfc90ece9e2d3489a19882ed522a | 2029769238  | 42         | 73869888      | 2025-12-16T21:07:14.000Z | 0xea703a34442b0bfa3ccb867c10759492a6ff15dbdaede9746c718b82146b2b05 |
  | 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false   | 0x1ce42626115591888500f0bdaedad32a15ccd8ae | 15266619794 | 0x1ce42626115591888500f0bdaedad32a15ccd8ae | 15254805585 | 19         | 73853199      | 2025-12-16T14:50:47.000Z | 0x0324140009eec8b1fd3b501d8d76c064ba3422fe01509106f2a9a00bbc6620e8 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.spark_v1_avalanche.spUSDC_Deposit_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### spUSDC\_Withdraw\_event

Withdrawal events from the Spark Protocol's spUSDC vault on Avalanche, recording user redemptions of vault shares for underlying USDC assets. Useful for analyzing vault liquidity flows and user withdrawal patterns.

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

<Accordion title="Sample Data">
  | address                                    | removed | in\_owner                                  | in\_assets    | in\_sender                                 | in\_shares   | log\_index | in\_receiver                               | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false   | 0x00e0842876e32cfbd52c711d333eac9c39539a74 | 1000000000000 | 0x00e0842876e32cfbd52c711d333eac9c39539a74 | 999740821996 | 5          | 0x00e0842876e32cfbd52c711d333eac9c39539a74 | 73568840      | 2025-12-12T02:28:01.000Z | 0x2b7acbc0571be5f4c8a62578951fecdf0476717fdf5dd77df4b13a9f05463828 |
  | 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false   | 0x0bbad437c1a31562fbd3a598380db12a770fabbd | 12000000000   | 0x0bbad437c1a31562fbd3a598380db12a770fabbd | 11995930002  | 6          | 0x0bbad437c1a31562fbd3a598380db12a770fabbd | 73613601      | 2025-12-12T19:18:25.000Z | 0xdb3287107072d7d37e1737247535e7fd1e1cd8a6128a923bbe4ab7a9a6d67d4e |
  | 0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d | false   | 0x159466d804f07555ee38673f65ce579f0a64c5c3 | 100007939263  | 0x159466d804f07555ee38673f65ce579f0a64c5c3 | 99980333000  | 40         | 0x159466d804f07555ee38673f65ce579f0a64c5c3 | 73578093      | 2025-12-12T06:01:01.000Z | 0x12f303c049aa2675332b671b47e9188714a19ead10ef0f7b3566275205d1cc64 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.spark_v1_avalanche.spUSDC_Withdraw_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***