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.

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.

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

Example Query

Query with partition filter

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

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.

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.

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

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

spUSDC_Deposit_event

spUSDC_Withdraw_event

​Tables

​spUSDC_Deposit_event

​spUSDC_Withdraw_event

Tables

spUSDC_Deposit_event

spUSDC_Withdraw_event