# Daily exports

### HLPe Fee Summary

**File:** `daily/hlpe_fee_summary/daily_hlpe_fee_summary.csv`

Daily fee summary per market (single file, overwritten daily).

| Field                       | Type   | Description                         |
| --------------------------- | ------ | ----------------------------------- |
| `date`                      | string | Date (YYYY-MM-DD)                   |
| `market`                    | string | Market/coin                         |
| `num_trades`                | u64    | Number of trades                    |
| `notional_volume`           | string | Notional volume                     |
| `total_taker_fees`          | string | Total taker fees paid               |
| `total_affiliate_share`     | string | Affiliate share (90% of taker fees) |
| `net_fees_after_affiliates` | string | Net fees (10% of taker fees)        |

***

### Fills Summary Per User

**File:** `daily/fills_summary_per_user/user_fills_maker_taker_summary.csv`

Rolling window aggregates per user (single file, overwritten daily). Windows: 90d, 30d, 7d, 1d.

| Field                   | Type   | Description  |
| ----------------------- | ------ | ------------ |
| `user`                  | string | User address |
| `volume_{window}`       | f64    | Total volume |
| `maker_volume_{window}` | f64    | Maker volume |
| `taker_volume_{window}` | f64    | Taker volume |
| `fees_{window}`         | f64    | Total fees   |
| `maker_fees_{window}`   | f64    | Maker fees   |
| `taker_fees_{window}`   | f64    | Taker fees   |
| `count_{window}`        | u64    | Fill count   |

Replace `{window}` with: `90d`, `30d`, `7d`, `1d`

***

## Snapshots

Snapshot filenames use `{ts}` = millisecond timestamp of the snapshot block.

***

### Position Snapshots

**File:** `daily/snapshots/positions/date={YYYY-MM-DD}/{ts}_perp_positions.parquet`

Daily position snapshot per user per market.

| Field               | Type   | Description         |
| ------------------- | ------ | ------------------- |
| `user`              | string | User address        |
| `market`            | string | Market/coin         |
| `size`              | f64    | Position size       |
| `notional`          | f64    | Notional value      |
| `entry_price`       | f64    | Entry price         |
| `liquidation_price` | f64?   | Liquidation price   |
| `leverage_type`     | string | cross / isolated    |
| `leverage`          | u32    | Leverage multiplier |
| `funding_pnl`       | f64    | Funding PnL         |
| `account_value`     | f64    | Account value       |

***

### Account Snapshots

**File:** `daily/snapshots/accounts/date={YYYY-MM-DD}/{ts}_account_values.parquet`

Daily account-level snapshot.

| Field                  | Type   | Description         |
| ---------------------- | ------ | ------------------- |
| `user`                 | string | User address        |
| `account_value`        | f64    | Total account value |
| `total_long_notional`  | f64    | Long exposure       |
| `total_short_notional` | f64    | Short exposure      |

***

### Orderbook Snapshots

**File:** `daily/snapshots/orderbooks/date={YYYY-MM-DD}/{ts}_orderbook.parquet`

Daily L4 orderbook state snapshot (one row per resting order).

| Field    | Type   | Description  |
| -------- | ------ | ------------ |
| `height` | u64    | Block height |
| `market` | string | Market/coin  |
| `side`   | string | bid / ask    |
| `user`   | string | User address |
| `price`  | f64    | Limit price  |
| `size`   | f64    | Order size   |
| `oid`    | u64    | Order ID     |

***

### Spot Holders Snapshots

**File:** `daily/snapshots/spot_holders/date={YYYY-MM-DD}/{ts}_spot_positions.parquet`

Daily USDE spot balance snapshot.

| Field     | Type   | Description  |
| --------- | ------ | ------------ |
| `user`    | string | User address |
| `balance` | f64    | USDE balance |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.hydromancer.xyz/readme/hyena/data-export-overview/daily-exports.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.