Perpetual PnL Daily - Allium Documentation Hub

The hyperliquid.assets.perpetual_pnl_daily table contains one row per UTC day, user, coin, and collateral token for native Hyperliquid perps and HIP-3 perps. Spot markets and HIP-4 prediction markets are not included. gross_realized_pnl, total_fees, total_funding, and net_realized_pnl are denominated in the market’s collateral token. Do not treat those columns as USD unless the collateral token is a dollar stablecoin at peg. Matching *_usd columns convert each fill or funding event at the collateral token’s 5-minute USD price. When any contributing event lacks a price, the affected USD columns are null, net_usd_is_complete is false, and unpriced_component_count records the unpriced fill and funding events. net_realized_pnl equals gross_realized_pnl - total_fees + total_funding. The exchange fee field already includes builder and HIP-3 deployer fees. Coverage starts at 2025-06-05 00:00:00 UTC.

Always filter with WHERE user = .... User-scoped queries are the supported access pattern.

Table Details

Property	Value
Table Name	`hyperliquid.assets.perpetual_pnl_daily`
Table Status	Production-Ready
Unique Key	`block_date, user, coin, collateral_token`

Sample Query

SELECT
  block_date,
  coin,
  collateral_token,
  gross_realized_pnl,
  total_fees,
  total_funding,
  net_realized_pnl,
  net_realized_pnl_usd,
  net_usd_is_complete
FROM hyperliquid.assets.perpetual_pnl_daily
WHERE user = '0x9237794d8e5c6eb247b20f2e5edd9ad5f530d8ec'
  AND block_date >= '2026-08-17'
  AND block_date < '2026-09-16'
ORDER BY block_date, coin;

​Table Details

​Sample Query

Table Details

Sample Query