> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Perpetual PnL Daily

> Daily realized PnL for Hyperliquid native and HIP-3 perpetual futures.

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.

<Info>
  Always filter with `WHERE user = ...`. User-scoped queries are the supported access pattern.
</Info>

### 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

```sql theme={null}
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;
```