fact_ledger_events

hypercore.core.fact_ledger_events

Schema: hypercore.core Table: fact_ledger_events Type: View

What

On-chain ledger actions including deposits, withdrawals, internal transfers, vault operations, spot transfers, and sub-account transfers. Each row represents a single ledger event extracted from L1 misc_events blocks.

Key Use Cases

• Tracking deposit and withdrawal flows to/from the exchange
• Analyzing internal transfer patterns between accounts
• Monitoring vault deposit/withdrawal activity and commissions
• Understanding spot token transfer activity
• Measuring cross-chain bridge usage via source/destination DEX fields

Important Relationships

• Derived from silver__ledger_events which parses silver__misc_events
• Can be joined to core__fact_trades via user_address for trader flow analysis
• Vault events link to core__fact_vault_snapshots via vault_address

Commonly-used Fields

• event_type: Type of ledger event (deposit, withdrawal, internal_transfer, spot_transfer, etc.)
• user_address: Primary user address
• amount / usdc_value: Transfer amount and USD value
• is_deposit: Boolean for deposit events
• tx_hash: L1 transaction hash
• fee / fee_token: Fee details

Sample queries

-- Deposit and withdrawal flow analysis (last 30 days)
SELECT
    block_timestamp::DATE AS dt,
    event_type,
    COUNT(*) AS events,
    ROUND(SUM(usdc_value), 0) AS total_usd
FROM hypercore.core.fact_ledger_events
WHERE event_type IN ('deposit', 'withdraw')
    AND block_timestamp >= DATEADD('day', -30, CURRENT_DATE)
GROUP BY 1, 2
ORDER BY 1, 2;

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_INDEX	NUMBER	Position of this event within the block’s event array, used for ordering.
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.
DESTINATION_ADDRESS	TEXT	Destination address for transfer and withdrawal events.
VAULT_ADDRESS	TEXT	Address of the vault for vault-related ledger events.
TOKEN	TEXT	Token identifier for ledger events (e.g. USDC, HYPE).
AMOUNT	FLOAT	Numeric amount for the event (HYPE for staking, USDC for ledger events, etc.).
USDC_VALUE	FLOAT	USDC-equivalent value of the ledger event amount.
FEE	FLOAT	Fee charged for the event.
NATIVE_TOKEN_FEE	FLOAT	Fee paid in native HYPE token.
FEE_TOKEN	TEXT	Token in which trading fees are denominated.
NONCE	NUMBER	Transaction nonce for uniqueness.
REQUESTED_USD	FLOAT	The USD value requested in the ledger operation.
COMMISSION	FLOAT	Commission amount charged on the operation.
CLOSING_COST	FLOAT	The closing cost associated with the position.
BASIS	FLOAT	The cost basis amount for the position.
NET_WITHDRAWN_USD	FLOAT	The net USD amount withdrawn after fees.
IS_DEPOSIT	BOOLEAN	Boolean indicating whether this ledger event is a deposit.
SOURCE_DEX	TEXT	Source exchange or chain for cross-chain transfers.
DESTINATION_DEX	TEXT	Destination exchange or chain for cross-chain transfers.
TO_PERP	BOOLEAN	Boolean indicating whether the transfer is to a perpetual margin account.
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_LEDGER_EVENTS_ID	TEXT	Surrogate key generated from block_number, tx_hash, and event_index
_INVOCATION_ID	TEXT	dbt invocation identifier for tracking which run produced this record.