hyperliquid.assets.summaries_latest view contains the most recent account summary snapshot per (user, dex) on Hyperliquid.
Table Columns
Identifiers
| Column Name | Description |
|---|---|
| user | User wallet address. |
| dex | DEX deployer address associated with the user. |
| last_activity_timestamp | Timestamp of the most recent snapshot. |
| block_date | Date of the most recent snapshot. |
| _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
user,
margin_summary_account_value,
withdrawable,
pnl,
last_activity_timestamp
FROM hyperliquid.assets.summaries_latest
WHERE user = '<user_address_to_search>'
LIMIT 100