> For the complete documentation index, see [llms.txt](https://docs.hydromancer.xyz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hydromancer.xyz/readme/hyena/data-export-overview/daily-exports.md).

# Daily exports

CSV/Parquet format, runs at 00:10 UTC.

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