Summaries EOD (Unhydrated)

The hyperliquid.unhydrated.summaries_eod table contains end-of-day account summary snapshots for every (user, dex) on Hyperliquid. One row per day, keeping the last snapshot of the day.

Table Columns

Identifiers

Column Name	Description
block_date	Calendar date of the summary snapshot.
user	User wallet address.
dex	DEX deployer address associated with the user.
timestamp	Timestamp of the last snapshot taken on this day.
_created_at	Row creation timestamp.
_updated_at	Row last update timestamp.

Agent

Column Name	Description
agent_address	Agent address associated with the user.
agent_valid_until	Agent validity timestamp.

Cross Margin

Column Name	Description
cross_maintenance_margin_used	Cross maintenance margin used.
cross_margin_summary_account_value	Cross margin summary account value.
cross_margin_summary_total_margin_used	Cross margin summary total margin used.
cross_margin_summary_total_natl_pos	Cross margin summary total notional position.
cross_margin_summary_total_raw_usd	Cross margin summary total raw USD.

Margin Summary

Column Name	Description
margin_summary_account_value	Margin summary account value.
margin_summary_total_margin_used	Margin summary total margin used.
margin_summary_total_natl_pos	Margin summary total notional position.
margin_summary_total_raw_usd	Margin summary total raw USD.

Account & Vault

Column Name	Description
withdrawable	Withdrawable amount.
net_deposit	Net deposit amount.
is_vault	True when the user is a vault.
total_vault_equity	Total vault equity.
pnl	PnL of the user at the snapshot timestamp.

Staking

Column Name	Description
staking_delegated	Amount of staked tokens delegated.
staking_undelegated	Amount of staked tokens undelegated.
staking_total_pending_withdrawal	Total amount of staked tokens pending withdrawal.

Sample Query

SELECT
  block_date,
  user,
  margin_summary_account_value,
  withdrawable,
  pnl
FROM hyperliquid.unhydrated.summaries_eod
WHERE block_date >= CURRENT_DATE - 7
ORDER BY block_date DESC, margin_summary_account_value DESC
LIMIT 100

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Identifiers

Agent

Cross Margin

Margin Summary

Account & Vault

Staking

Sample Query

​Table Columns

​Identifiers

​Agent

​Cross Margin

​Margin Summary

​Account & Vault

​Staking

​Sample Query

Table Columns

Identifiers

Agent

Cross Margin

Margin Summary

Account & Vault

Staking

Sample Query