fact_vault_snapshots

hypercore.core.fact_vault_snapshots

Schema: hypercore.core Table: fact_vault_snapshots Type: View

What

Periodic snapshots of Hyperliquid vault state including total value locked, APR, lockup periods, and follower relationships. Vaults are managed portfolios where a leader trades on behalf of followers.

Key Use Cases

• Monitoring vault TVL growth and APR trends
• Analyzing vault leader performance
• Tracking follower concentration across vaults
• Understanding lockup period distribution

Important Relationships

• Links to core__fact_ledger_events via vault_address for deposit/withdrawal activity
• Leader addresses can be cross-referenced with core__fact_trades for trading activity

Commonly-used Fields

• vault_address / vault_name: Vault identifier and name
• leader_address: Vault manager address
• tvl: Total value locked (USD)
• apr: Annualized return
• lockup_days: Lockup period

Columns

Column Name	Data Type	Description
VAULT_ADDRESS	TEXT	Address of the vault for vault-related ledger events.
VAULT_NAME	TEXT	Human-readable name of the vault.
LEADER_ADDRESS	TEXT	Address of the vault leader/manager who trades on behalf of followers.
TVL	FLOAT	Total value locked in the vault, denominated in USD.
LOCKUP_DAYS	NUMBER	Number of days funds are locked in the vault.
APR	FLOAT	Annualized percentage return for the vault.
FOLLOWER_STATE	VARIANT	JSON object describing follower positions and allocations.
RELATIONSHIP	VARIANT	JSON object describing vault relationships and parameters.
SNAPSHOT_TIMESTAMP	TIMESTAMP_LTZ	Timestamp when the market data snapshot was taken via Streamline API.
INSERTED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMP	TIMESTAMP_NTZ	Timestamp when the record was last modified in this table (Snowflake SYSDATE).
FACT_VAULT_SNAPSHOTS_ID	TEXT	Surrogate key for vault snapshot records
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.