Price catalog
Price has five categories: Trades & quotes, Latest bars, Session levels & position, Highs & lows and Support & resistance. Each signal links to its full reference page.
Trades & quotes
Last trade and the current quote: price, bid/ask, and depth.
| Column | Type | Description |
|---|---|---|
price | numeric | Current price: the newest source we hold for the ticker, in a fixed order; price_source says which one. |
Latest bars
OHLC of the latest minute bar and the prior session's daily bar.
| Column | Type | Description |
|---|---|---|
min_close | numeric | Current minute bar’s most-recent close (last print). |
min_high | numeric | Current minute bar’s running high. |
min_low | numeric | Current minute bar’s running low. |
min_open | numeric | Current minute bar’s open. Updates every minute, 4 AM to 8 PM ET. |
prev_day_high | numeric | Previous trading day’s session high. |
prev_day_low | numeric | Previous trading day’s session low. |
prev_day_open | numeric | Previous trading day’s official open. |
previous_close | numeric | Official prior-session close. |
price_asof | timestamp with time zone | The time of the data behind the price. |
price_source | text | Where the row's price came from. |
Session levels & position
Today's session levels (open, high, low) and where price sits relative to them and yesterday's landmarks.
| Column | Type | Description |
|---|---|---|
afterhours_price | numeric | Last after-hours price, if available. |
premarket_price | numeric | Last premarket price, if available. |
session_high | numeric | Highest trade so far today. |
session_low | numeric | Lowest trade so far today. |
session_open | numeric | Today’s opening print. |
above_premarket_high | state | Close above the pre-market session high.close > max(price[04:00..09:30]) |
above_session_open | state | Close above today’s session-open price.close > open_0930 |
above_yesterday_close | state | Close above the prior session’s close.close > close_prev |
above_yesterday_high | state | Close above the prior session’s intraday high.close > high_prev |
at_session_high | state | At today’s intraday session high (within tolerance).price >= session_high * 0.999 |
at_session_low | state | At today’s intraday session low (within tolerance).price <= session_low * 1.001 |
below_premarket_low | state | Close below the pre-market session low.close < min(price[04:00..09:30]) |
below_yesterday_low | state | Close below the prior session’s intraday low.close < low_prev |
tested_session_high_recent | state | Price touched today’s session high within the last 5 minutes.max(close, last 5 min) >= session_high * 0.999 |
tested_session_low_recent | state | Price touched today’s session low within the last 5 minutes.min(close, last 5 min) <= session_low * 1.001 |
Highs & lows
Rolling-window highs and lows (5-day, 20-day, 52-week), their dates and distances, and the at/approaching/breaking signals those levels own.
| Column | Type | Description |
|---|---|---|
days_since_52w_high | integer | Trading days since the most recent 52-week high. |
days_since_52w_low | integer | Trading days since the most recent 52-week low. |
from_52w_high_pct | numeric | Percent distance from the 52-week high, as a whole percent. Signed: negative below the high (â27 = 27% under it), 0 at it, positive only on a new high before the window updates. Use the at_52w_high boolean to test highs. Was pct_from_52w_high as a fraction before the 2026-09-07 cutover. |
from_52w_low_pct | numeric | Percent distance above the 52-week low, as a whole percent (22 = 22% above it). Signed; ⥠0 except at a new low before the window updates. Use the at_52w_low boolean to test lows. |
high_20d | numeric | Highest trade in the trailing 20 trading days. |
high_20d_eod | numeric | Highest close over the last 20 trading sessions. Close-basis. For the intraday-wick variant use at_20d_high. |
high_52w | numeric | Highest trade in the trailing 52 weeks (live, includes today). |
high_52w_date | date | Date the trailing-52-week high was set. Useful for "fresh 52w highs in the last 30 days" scans. |
high_52w_eod | numeric | Highest close over the trailing 52 weeks. The _eod distinguishes from the canonical intraday 52_week_high (which captures wicks). |
high_5d | numeric | Highest intraday high over the last 5 trading sessions, inclusive of the current session. |
high_5d_eod | numeric | Highest close over the last 5 trading sessions. Close-basis (no intraday wicks) — pair with high_5d to distinguish. |
last_20d_high_date | date | Date the trailing-20-day high was set. |
last_20d_low_date | date | Date the trailing-20-day low was set. |
low_20d | numeric | Lowest trade in the trailing 20 trading days. |
low_20d_eod | numeric | Lowest close over the last 20 trading sessions. Close-basis. |
low_52w | numeric | Lowest trade in the trailing 52 weeks (live, includes today). |
low_52w_date | date | Date the trailing-52-week low was set. |
low_52w_eod | numeric | Lowest close over the trailing 52 weeks. |
low_5d | numeric | Lowest intraday low over the last 5 trading sessions, inclusive of the current session. |
low_5d_eod | numeric | Lowest close over the last 5 trading sessions. Close-basis. |
position_in_52w_range_pct | numeric | Where the live price sits in the 52-week range, 0–100. 0 = at low, 100 = at high. |
52_week_high | state | Price printed a new 52-week high today.high > max(high) over the prior 252 sessions |
52_week_low | state | Price printed a new 52-week low today.low < min(low) over the prior 252 sessions |
approaching_52w_high | state | Price is within 5% of the 52-week high.close >= high_52w * 0.95 AND close < high_52w AND (close > sma_20 AND close > sma_50, OR >= 3 of last 5 days up) AND volume > avg_volume_10d |
approaching_52w_low | state | Price is within 5% of the 52-week low.close <= low_52w * 1.05 AND close > low_52w AND (close < sma_20 AND close < sma_50, OR >= 3 of last 5 days down) AND volume > avg_volume_10d |
at_20d_high | state | Price is at or above the 20-day high.close >= high_20d |
at_20d_low | state | Price is at or below the 20-day low.close <= low_20d |
at_52w_high | state | Price has traded within 0.5% of the 52-week high this session; once tagged, the boolean stays on for the rest of the session.session_high >= high_52w * 0.995 |
at_52w_low | state | Price has traded within 0.5% of the 52-week low this session; once tagged, the boolean stays on for the rest of the session.session_low <= low_52w * 1.005 |
Support & resistance
Pivot-detected price levels a ticker has repeatedly touched, and whether price is at one now. Levels are found nightly across the equity universe; a ticker with too little history has none and its booleans read NULL rather than false.
| Column | Type | Description |
|---|---|---|
at_resistance | state | Price is testing a detected resistance level.Price within 1.5 × ATR(20) of an active detected resistance level — a cluster of two or more historical swing highs within an ATR-scaled band, still unbroken. |
at_support | state | Price is testing a detected support level.Price within 1.5 × ATR(20) of an active detected support level — a cluster of two or more historical swing lows within an ATR-scaled band, still unbroken. |
bounce_off_support | state | Bounced off a detected support level: price tagged the band within three sessions and closed up.in last 3 bars: low within level ± 1.5 × ATR14 of an active support level AND close > prev close |