fact_staking_events

hypercore.core.fact_staking_events

Schema: hypercore.core Table: fact_staking_events Type: View

What

HYPE token staking activity including delegations to validators, staking deposits (CDeposit), and staking withdrawals (CWithdrawal). Hyperliquid uses delegated proof-of-stake with 24 active validators running HyperBFT consensus. Delegations have a 1-day lockup, and withdrawals go through a 7-day unstaking queue.

Key Use Cases

• Tracking HYPE delegation flows to/from validators
• Monitoring staking deposit and withdrawal patterns
• Analyzing validator delegation concentration
• Calculating net staking inflows/outflows over time
• Identifying large delegation/undelegation events

Important Relationships

• Derived from silver__staking_events which parses silver__misc_events
• Links to core__fact_validator_rewards via validator_address
• Links to core__dim_perp_markets for HYPE market context

Commonly-used Fields

• event_type: delegation, staking_deposit, or staking_withdrawal
• user_address: User performing the staking action
• validator_address: Target validator (delegations only)
• amount: Amount of HYPE
• is_undelegate: TRUE for undelegations
• is_finalized: Whether withdrawal completed the 7-day queue

Sample queries

-- HYPE token staking activity (last 30 days)
SELECT
    event_type,
    block_timestamp::DATE AS dt,
    COUNT(*) AS events,
    COUNT(DISTINCT user_address) AS unique_users,
    ROUND(SUM(amount), 2) AS total_hype_amount
FROM hypercore.core.fact_staking_events
WHERE block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
GROUP BY 1, 2
ORDER BY 2, 1;

Columns

Column Name	Data Type	Description
BLOCK_NUMBER	NUMBER	L1 block number containing this event.
BLOCK_TIMESTAMP	TIMESTAMP_NTZ	Block production timestamp on the Hyperliquid L1. This is the canonical time for ordering blockchain events.
EVENT_TIMESTAMP	TIMESTAMP_NTZ	Exact timestamp of the event from the L1, extracted from the event payload.
TX_HASH	TEXT	L1 transaction hash uniquely identifying the on-chain transaction.
EVENT_TYPE	TEXT	Type of event: delegation, staking_deposit, staking_withdrawal, deposit, withdrawal, internal_transfer, spot_transfer, etc.
USER_ADDRESS	TEXT	HyperCore address of the primary user involved in this event.
VALIDATOR_ADDRESS	TEXT	HyperCore address of the validator involved in staking or reward events.
AMOUNT	FLOAT	Numeric amount for the event (HYPE for staking, USDC for ledger events, etc.).
IS_UNDELEGATE	BOOLEAN	Boolean indicating whether this delegation event is an undelegation (removing stake from a validator).
IS_FINALIZED	BOOLEAN	Boolean indicating whether a staking withdrawal has completed the 7-day unstaking queue.
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_STAKING_EVENTS_ID	TEXT	Surrogate key generated from block_number, tx_hash, event_index, and event_type
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.