fact_validator_rewards

hypercore.core.fact_validator_rewards

Schema: hypercore.core Table: fact_validator_rewards Type: View

What

Per-block validator reward distributions on the Hyperliquid L1. Rewards are accrued every minute and distributed daily to validators. The staking reward rate is inversely proportional to the square root of total HYPE staked (inspired by Ethereum’s model).

Key Use Cases

• Analyzing validator reward distribution and economics
• Calculating effective APR for individual validators
• Tracking total network reward issuance over time
• Comparing reward amounts across validators
• Monitoring reward rate changes as total stake fluctuates

Important Relationships

• Derived from silver__validator_rewards which parses silver__misc_events
• Links to core__fact_staking_events via validator_address
• Reward amounts are in HYPE

Commonly-used Fields

• validator_address: Validator receiving the reward
• reward_amount: Amount of HYPE rewarded
• event_timestamp: Exact reward distribution timestamp
• block_number / block_timestamp: L1 block context

Sample queries

-- Validator reward distribution
SELECT
    validator_address,
    COUNT(*) AS reward_events,
    ROUND(SUM(reward_amount), 4) AS total_rewards,
    MIN(block_timestamp)::DATE AS first_reward,
    MAX(block_timestamp)::DATE AS last_reward
FROM hypercore.core.fact_validator_rewards
GROUP BY 1
ORDER BY 3 DESC
LIMIT 24;

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.
VALIDATOR_ADDRESS	TEXT	HyperCore address of the validator involved in staking or reward events.
REWARD_AMOUNT	FLOAT	Amount of HYPE rewarded to a validator in a single reward distribution.
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_VALIDATOR_REWARDS_ID	TEXT	Surrogate key passed through from silver__validator_rewards (generated from block_number, validator_address, and event_index)
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.