Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_assetsSTRINGNumber of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
in_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
addressremovedin_ownerin_assetsin_senderin_shareslog_indexblock_numberblock_timestamptransaction_hash
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43dfalse0x182b9569feb9bfc90ece9e2d3489a19882ed522a8200000000x182b9569feb9bfc90ece9e2d3489a19882ed522a81935179317738630922025-12-16T18:33:01.000Z0x03b8ef830ffee05a626db3c73c734ab2125499b8997e43771c515a9cf929a2d6
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43dfalse0x182b9569feb9bfc90ece9e2d3489a19882ed522a20313984080x182b9569feb9bfc90ece9e2d3489a19882ed522a202976923842738698882025-12-16T21:07:14.000Z0xea703a34442b0bfa3ccb867c10759492a6ff15dbdaede9746c718b82146b2b05
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43dfalse0x1ce42626115591888500f0bdaedad32a15ccd8ae152666197940x1ce42626115591888500f0bdaedad32a15ccd8ae1525480558519738531992025-12-16T14:50:47.000Z0x0324140009eec8b1fd3b501d8d76c064ba3422fe01509106f2a9a00bbc6620e8
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_assetsSTRINGNumber of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
in_sharesSTRINGNumber of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
addressremovedin_ownerin_assetsin_senderin_shareslog_indexin_receiverblock_numberblock_timestamptransaction_hash
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43dfalse0x00e0842876e32cfbd52c711d333eac9c39539a7410000000000000x00e0842876e32cfbd52c711d333eac9c39539a7499974082199650x00e0842876e32cfbd52c711d333eac9c39539a74735688402025-12-12T02:28:01.000Z0x2b7acbc0571be5f4c8a62578951fecdf0476717fdf5dd77df4b13a9f05463828
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43dfalse0x0bbad437c1a31562fbd3a598380db12a770fabbd120000000000x0bbad437c1a31562fbd3a598380db12a770fabbd1199593000260x0bbad437c1a31562fbd3a598380db12a770fabbd736136012025-12-12T19:18:25.000Z0xdb3287107072d7d37e1737247535e7fd1e1cd8a6128a923bbe4ab7a9a6d67d4e
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43dfalse0x159466d804f07555ee38673f65ce579f0a64c5c31000079392630x159466d804f07555ee38673f65ce579f0a64c5c399980333000400x159466d804f07555ee38673f65ce579f0a64c5c3735780932025-12-12T06:01:01.000Z0x12f303c049aa2675332b671b47e9188714a19ead10ef0f7b3566275205d1cc64
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