stfx_v1_avalanche

Tables

StfxVault_Claimed_event

Investor claim events from STFX protocol vaults on Avalanche, recording withdrawal amounts and vault addresses. Used for tracking investor redemptions and vault liquidity outflows across different STFX vault strategies.

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_investor`	`STRING`	Address of the investor depositing funds into or claiming funds from the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_stfxAddress`	`STRING`	Contract address of the STFX fund or vault instance. 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.

Sample Data

address	removed	in_amount	log_index	in_investor	block_number	in_stfxAddress	block_timestamp	transaction_hash
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	19775080	3	0x53a096fef0df25034ad6cc8030d566c8d06c1c51	25685743	0x1e87a5d91ce819b710ee8bef1955e13b4e84e607	2023-02-01T08:15:38.000Z	0x9202efe03642db4f1c328871ba238a296372f69d03af6893018bf9f1293f3b85
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	27607472	6	0x53a096fef0df25034ad6cc8030d566c8d06c1c51	25685389	0xdeb56c0c6cb64e8bc5a0d33d7ea1c8eb637c1f0d	2023-02-01T08:03:47.000Z	0x130f1401d2c80a572b58175ac6cbe66bb590487a4a2aa6212eada521be9432c3
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	19639543	6	0x5405ffa5b9acf32bb639c37a7817133b02a7934b	25675541	0x7854956ebec4b23a5ae15ddfdaa7541c5d0adeaa	2023-02-01T02:34:37.000Z	0x7397d5fd01a371a30aa5993d037677c54019fa8bd97eb9667b015b32c2926a5f

Example Query

Query with partition filter

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

StfxVault_DepositIntoFund_event

Deposit events from STFX vault contracts on Avalanche, capturing investor contributions with deposit amounts, investor addresses, and STFX vault identifiers. Used for tracking capital inflows and vault subscription activity across the STFX protocol.

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__stfxAddress`	`STRING`	Address of the STFX token or fund contract associated with the vault operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_investor`	`STRING`	Address of the investor depositing funds into or claiming funds from the vault. 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.

Sample Data

address	removed	in_amount	log_index	in_investor	block_number	block_timestamp	in__stfxAddress	transaction_hash
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	20000000	9	0x9a17d557faa46b202a31f2d5e740688a2e5699e1	24832387	2023-01-12T05:46:07.000Z	0x987b3e8887335df2de1c1178742267b0564c07f2	0x211273d6530aa39efe86a80a2637338b3ecfd35d284ba3c31aff5d8a89ecb2d3
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	20000000	27	0x5af39def9d41c9970f75f507f2e3d9369b3b418e	24827626	2023-01-12T03:05:42.000Z	0x864d81ddf591df6128fcb55ce55b0cbcb7103a94	0xd0c3c2472fdae9b04355cb8a966d0795685f31d536a64f254d05e23f347c97ca
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	20000000	11	0x1c8adce0dd05a975f6628d7979a4fc8243aa1c39	24825248	2023-01-12T01:45:31.000Z	0xd6c46368ba3ea59376bc9b10a7c99472661fd713	0x2b3d0a604270c3c4ab520f04cc9dcb58142d70a3e7276e902157a544e4d29dde

Example Query

Query with partition filter

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

StfxVault_FeesTransferred_event

Fee transfer events from STFX protocol vaults on Avalanche, recording manager and protocol fee distributions along with vault balances. Used for tracking revenue splits and vault performance metrics across the STFX trading infrastructure.

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__stfxAddress`	`STRING`	Address of the STFX token or fund contract associated with the vault operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__remainingBalance`	`STRING`	Vault balance remaining after manager and protocol fees have been deducted. Denominated in the vault’s base token units (typically 6-9 decimals), ranging from millions to hundreds of millions in sample data.
`in__managerFee`	`STRING`	Fee amount charged to the manager for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).
`in__protocolFee`	`STRING`	Fee amount charged by the protocol for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).

Sample Data

address	removed	log_index	block_number	block_timestamp	in__stfxAddress	transaction_hash	in__remainingBalance
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	2	25675514	2023-02-01T02:33:43.000Z	0x7854956ebec4b23a5ae15ddfdaa7541c5d0adeaa	0x8bd4f6715cf321707e13d9c22de0d8ce5c7b6ce31c9c21eb25a6a5f83e73cd45	39279086
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	31	25740190	2023-02-02T14:23:41.000Z	0x6e4e179d11bc66f5e470278e1e2a9267f82f6543	0xda8a52a82b04fae0c958363f51e038d14a5fb95491a91e05577c938cf257e431	20229608
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	2	25723196	2023-02-02T04:57:13.000Z	0x8657d6e2a6607fd3048c26700fbb4d56cecc93db	0x0b4eed73185236efcab3a7a0f096548c28929af33d4e970bdab8b918bbd5c09e	19925973

Example Query

Query with partition filter

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

StfxVault_NewFundCreated_event

Fund creation events from STFX (Stacked Finance) copy-trading vaults on Avalanche, capturing leveraged trading positions with manager address, entry/target/liquidation prices, trade direction, and fundraising period parameters. Used for analyzing vault strategy configurations and fund manager trading setups.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fundraisingPeriod`	`STRING`	Duration of the fundraising period for the vault in seconds. Common values include 604800 (7 days), 72000 (20 hours), and 3600 (1 hour).
`in_entryPrice`	`STRING`	Price at which the trading position was entered. String-encoded numeric value representing the entry price in the smallest denomination or with extended precision.
`in_targetPrice`	`STRING`	Target price for the leveraged position expressed in base token units with precision-adjusted decimals. Represents the manager’s profit-taking level where the fund aims to close the trade.
`in_liquidationPrice`	`STRING`	Price level at which the leveraged position will be automatically liquidated to prevent further losses. Expressed in the base token’s smallest unit, with zero indicating no liquidation threshold set.
`in_leverage`	`STRING`	Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
`in_tradeDirection`	`BOOL`	Boolean flag indicating the direction of the leveraged trade (true for long, false for short). Determines whether the fund profits from price increases or decreases relative to the entry price.
`in_stfxAddress`	`STRING`	Contract address of the STFX fund or vault instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_manager	in_leverage	block_number	in_baseToken	in_entryPrice	in_stfxAddress	in_targetPrice	block_timestamp	transaction_hash	in_tradeDirection	in_liquidationPrice	in_fundraisingPeriod
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	31	0x0022aa331686560dd555ee252f94ee6d7c293aec	2000000	29838078	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	1853030000	0x38d2532e9e7a3c78a48e94b1c8183a6b6b04db54	1863030000	2023-05-10T12:15:53.000Z	0x173b820b5394f8768a2f83a767b4f0c3924d2c03244f8d2791a04ce928fdfb56	true	1000000000	604800
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	1	0x0022aa331686560dd555ee252f94ee6d7c293aec	1000000	29780238	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	1846240000	0x504f2731deff4426c055b5af8cd759bb4cd3d213	1836240000	2023-05-09T03:39:14.000Z	0x6f3438be09a133129b85f2d15c7b6ad114f24bbf0e6912f1ab93fc2d521307a6	false	1000000000	604800
0xcd9987e26944de1ab817221864d06acd30c1b9f9	false	14	0x0022aa331686560dd555ee252f94ee6d7c293aec	2000000	29779769	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	1844150000	0x8867172515523a212d8d45168ee6bf62f67ad9e7	1854150000	2023-05-09T03:23:35.000Z	0xad21af75492c910498b900deec4bb092654e2d2fd15294ff318cfe61906fdba3	true	1000000000	604800

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

StfxVault_Claimed_event

StfxVault_DepositIntoFund_event

StfxVault_FeesTransferred_event

StfxVault_NewFundCreated_event

​Tables

​StfxVault_Claimed_event

​StfxVault_DepositIntoFund_event

​StfxVault_FeesTransferred_event

​StfxVault_NewFundCreated_event

Tables

StfxVault_Claimed_event

StfxVault_DepositIntoFund_event

StfxVault_FeesTransferred_event

StfxVault_NewFundCreated_event