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

# Spread statistics

> Spread distribution over a window (median, p10, p90, mean), data coverage and the hour of day (UTC) with the tightest spread. Available for April 2024 to February 2026 (archive of every top-of-book update); not yet extended past February 2026.



## OpenAPI

````yaml /api-reference/openapi.json get /market/spread/{coin}
openapi: 3.0.3
info:
  title: 'Hypedexer API: Indexed Data'
  version: 1.0.0
  description: >-
    API to query indexed Hyperliquid trading data.


    This API provides access to stored/indexed trading data:

    - **Fills**: Executed orders and fills (Spot-only or All = Spot + Perp)

    - **Analytics**: Aggregations and statistics based on indexed data

    - **Completed Trades**: Trade objects and their related fills

    - **Users**: User overviews, performance and activity

    - **Social Trading**: Per-trader equity curve, PnL calendar, account
    leverage and top trades

    - **Funding**: Funding rate history, user funding payments, predicted rates

    - **Liquidations**: Liquidation events with filters

    - **Overview**: Market dashboard metrics (volume, fees, traders, PnL)

    - **Spot**: Spot token metadata, pairs, and auctions

    - **TWAPs**: TWAP orders, execution stats and fills

    - **Vaults**: Vault details, summaries, equity, ledger


    > Note: No live streaming. Responses are computed from indexed data.
servers:
  - url: https://api.hypedexer.com
    description: Production, routed to the nearest region (EU or JP)
security:
  - ApiKeyAuth: []
tags:
  - name: Fills
    description: Fills endpoints.
  - name: Analytics
    description: Aggregations and stats.
  - name: Completed Trades
    description: Trades and fills.
  - name: Users
    description: User profiles.
  - name: Funding
    description: Funding rates and payments (HL-compatible).
  - name: Liquidations
    description: Liquidation events.
  - name: Overview
    description: Market dashboard metrics.
  - name: Spot
    description: Spot token metadata, pairs and auctions.
  - name: TWAPs
    description: TWAP orders, stats and fills.
  - name: Vaults
    description: Vault details, summaries, equity and ledger.
  - name: Social Trading
    description: >-
      Per-trader equity, PnL calendar, performance, account leverage and top
      trades.
  - name: Market history
    description: >-
      Historical Hyperliquid market microstructure: best bid/offer aggregates
      and spread statistics (April 2024 to February 2026), and the order book
      reconstructed minute by minute: April 2024 to February 2026 from our
      archive (top ~20 levels per side) and, since 23 September 2026, the full
      order book replayed from our own node. Served from the EU region.
paths:
  /market/spread/{coin}:
    get:
      tags:
        - Market history
      summary: Spread statistics
      description: >-
        Spread distribution over a window (median, p10, p90, mean), data
        coverage and the hour of day (UTC) with the tightest spread. Available
        for April 2024 to February 2026 (archive of every top-of-book update);
        not yet extended past February 2026.
      parameters:
        - name: coin
          in: path
          description: Coin symbol (e.g. BTC, @107 for a spot pair, xyz:TSLA for HIP-3)
          schema:
            type: string
          required: true
        - name: start_time
          in: query
          description: Start time (ISO UTC)
          schema:
            type: string
            format: date-time
          required: true
        - name: end_time
          in: query
          description: End time (ISO UTC); default = start + 30 days
          schema:
            type: string
            format: date-time
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                type: object
              example:
                success: true
                message: Spread statistics for BTC
                data:
                  coin: BTC
                  start_time: '2025-12-01T00:00:00Z'
                  end_time: '2026-01-01T00:00:00Z'
                  coverage_pct: 99.77
                  minutes_with_data: 44536
                  spread_bps_median: 0.1435
                  spread_bps_p10: 0.1145
                  spread_bps_p90: 0.2023
                  spread_bps_avg: 0.1555
                  spread_bps_max: 2.2621
                  mid_avg: 89000.230667
                  updates: 225302610
                  tightest_hour_utc: 7
                  widest_hour_utc: 15
                  by_hour_utc:
                    - hour_utc: 0
                      spread_bps_avg: 0.1723
                      updates: 9095092
                    - hour_utc: 1
                      spread_bps_avg: 0.1623
                      updates: 9465540
                    - hour_utc: 2
                      spread_bps_avg: 0.1682
                      updates: 9635044
                    - hour_utc: 3
                      spread_bps_avg: 0.1606
                      updates: 8464076
                    - hour_utc: 4
                      spread_bps_avg: 0.1535
                      updates: 7294841
                    - hour_utc: 5
                      spread_bps_avg: 0.1519
                      updates: 6826738
                    - hour_utc: 6
                      spread_bps_avg: 0.1515
                      updates: 6486111
                    - hour_utc: 7
                      spread_bps_avg: 0.1506
                      updates: 6891036
                    - hour_utc: 8
                      spread_bps_avg: 0.1531
                      updates: 7699446
                    - hour_utc: 9
                      spread_bps_avg: 0.1528
                      updates: 7455441
                    - hour_utc: 10
                      spread_bps_avg: 0.1538
                      updates: 7366684
                    - hour_utc: 11
                      spread_bps_avg: 0.1523
                      updates: 7233631
                    - hour_utc: 12
                      spread_bps_avg: 0.1555
                      updates: 8030840
                    - hour_utc: 13
                      spread_bps_avg: 0.1717
                      updates: 10109865
                    - hour_utc: 14
                      spread_bps_avg: 0.2006
                      updates: 14210434
                    - hour_utc: 15
                      spread_bps_avg: 0.202
                      updates: 15470247
                    - hour_utc: 16
                      spread_bps_avg: 0.1813
                      updates: 14199150
                    - hour_utc: 17
                      spread_bps_avg: 0.1779
                      updates: 12584367
                    - hour_utc: 18
                      spread_bps_avg: 0.1704
                      updates: 11308041
                    - hour_utc: 19
                      spread_bps_avg: 0.1773
                      updates: 10909983
                    - hour_utc: 20
                      spread_bps_avg: 0.175
                      updates: 10588394
                    - hour_utc: 21
                      spread_bps_avg: 0.1652
                      updates: 8184223
                    - hour_utc: 22
                      spread_bps_avg: 0.1707
                      updates: 7742191
                    - hour_utc: 23
                      spread_bps_avg: 0.1584
                      updates: 8051195
                total_count: null
                execution_time_ms: 368.45
                next_cursor: null
                has_more: null
        '400':
          description: >-
            Invalid window or parameter (for example a window larger than the
            interval allows)
components:
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: X-API-Key
      description: >-
        Your Hypedexer API key. Create one in the console at
        https://app.hypedexer.com. `Authorization: Bearer <key>` and the
        `api_key` query parameter are accepted as well.

````