US Equities · Daily OHLCV px.eq.us.daily
Daily regular-market open/high/low/close, volume and volume-weighted average price (VWAP). Opt-in premarket and aftermarket VWAP and volumes. Stitched across symbol changes; split and dividend adjustment on request.
PIT · Core tier · 2004-01 → today · 48.6M rows
Countries: US
Available now.
Methodology
The base fields keep their regular-market meaning: open is the first regular-session trade, high and low are the regular-session range, and close is the official closing price, falling back to the last regular-session trade where the official close is missing (mostly before 2010). On GET /v1/securities/{ticker}/prices, extended_hours accepts only true or false and defaults to false. True adds sibling premarket and aftermarket objects to each bar, each with nullable vwap, volume and volume_usd. Dotted schema names describe these nested fields. Both objects appear even when all their fields are null. Omitted or false preserves the existing response shape. No flag echo or wrapper is added. Source nulls and zeros remain distinct. Zero shares can coexist with populated VWAP and dollar volume. Session VWAP and shares use the daily price and share-volume factors, respectively, with six-decimal rounding when adjusted. Raw shares serialize as integers. Dollar volume never changes under adjustment. The API derives no combined session totals. Both summaries use the bar's trading date directly from its UTC-midnight label, without timezone conversion. Source aggregates carry no intraday timestamps or guaranteed clock windows, half-day boundaries or trade eligibility rules. These historical, delayed summaries offer no freshness service-level agreement or guaranteed current-session coverage. They are separate from the planned px.eq.us.extended quotes and trades package, which remains coming soon. No session OHLC or independent last price is included. Bars are keyed to the symbol they traded under and stitched across the security's whole symbol lineage, so META as of today includes the FB era. Prices are as traded by default; split or split-and-dividend adjustment is computed at query time from dated corporate events, applying only events dated on or before as_of; each applied event adjusts the bars strictly before its date, and the bar on the event date is served as traded, already on the new basis. A dividend is skipped when it is not in USD, has no earlier bar in the lineage to anchor on, or would give a factor at or below zero; dividends_skipped in the response counts them, so a series that fell back to splits-only is visible. known_as_of further keeps only events whose computed known_since is on or before the pin — for history backfilled before the September 2026 go-live that date is approximated from the event's own dates. It controls which events are visible, not their values, so a restated event, a corrected bar or a newly learned rename still changes the series under the same pins. Bars are current-state: a corrected bar is served corrected whatever the pin. as_of is a date cap, so as_of=D can include D's aftermarket after loading. It does not establish availability within that date. The opt-in flag preserves lineage, date bounds and pagination. GET and HEAD carry a strong ETag over the exact JSON page, including metadata and next_cursor. A matching If-None-Match returns bodyless 304 after normal quota and service work. This validator detects changed answers without freezing a paginated walk or replaying historical values. Lineage conflicts return 409 ERR_LINEAGE_CONFLICT until reference data is repaired. Retrying unchanged evidence cannot repair them. Temporary KeyDB failures return 503 ERR_UNAVAILABLE. Retry with backoff.
Schema
| Column | Type | Role |
|---|---|---|
date | date | PIT key · trading date |
ticker | string | symbol traded under on date |
open | float64 | first regular-market trade |
high | float64 | regular-market high |
low | float64 | regular-market low |
close | float64 | official close · last trade if missing |
last_10m | float64 | last trade 10 min before close · nullable |
volume | float64 | regular-market shares · whole unless adjusted |
volume_usd | float64 | regular-market dollar volume · never adjusted |
vwap | float64 | regular-market VWAP |
premarket.vwap | float64 | nullable · premarket VWAP · extended_hours=true only |
premarket.volume | float64 | nullable · premarket shares · whole unless adjusted · extended_hours=true only |
premarket.volume_usd | float64 | nullable · premarket dollar volume · never adjusted · extended_hours=true only |
aftermarket.vwap | float64 | nullable · aftermarket VWAP · extended_hours=true only |
aftermarket.volume | float64 | nullable · aftermarket shares · whole unless adjusted · extended_hours=true only |
aftermarket.volume_usd | float64 | nullable · aftermarket dollar volume · never adjusted · extended_hours=true only |
Use cases
- Backtest a daily strategy on prices adjusted only for events dated, and computed as known, by the backtest date.
- Pull a renamed security's full history in one call instead of joining FB and META by hand.
- Rebuild an adjusted series without the splits and dividends whose computed knowledge date falls after the day it was built.
- Compare the official close with the price ten minutes before it to size the cost of trading into the close.
Background
- Point-in-time market data: as-of dates, restatements, and adjustments
- Look-ahead bias in quantitative trading: six mechanisms and their fixes
Related packages
- px.eq.us.minute — US Equities · 1-minute OHLCV
- px.eq.us.extended — Premarket / postmarket prices