Morning briefing
For portfolio managers, heads of trading, desk strategists
Everything a PM checks before the open — tape, breadth, outliers, rating changes and the earnings calendar — in seven one-line queries instead of six screens and a spreadsheet.
- Financial markets
- 7 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
The tape in one row
Index moves, the VIX and market breadth side by side, so you know the regime before you look at a single name.
GET SPY@close, SPY@ret, QQQ@ret, IWM@ret, $VIX@close, $BRD.A50@close, $BRD.ADR@close
Sector scoreboard
Index and sector ETFs ranked by yesterday's move, with week, month and RSI context for positioning.
GET refs SELECT symbol, name, close, ret, roc(5) AS wk, roc(21) AS mo, rsi(14) SORT ret DESC
Breadth, then and now
Percent above the 50- and 200-day, advancers, new highs and lows, oversold share: today versus yesterday and last week.
GET market SELECT symbol, name, close, close[-1] AS prev, close[-5] AS week_ago
What was truly unusual
Only the events that sit in the top 5% of each stock's own history, so a 3% gap in a utility outranks a routine one in a momentum name.
EVENTS * IN top500 LAST 1d WHERE rarity >= 95 SORT rarity DESC
Cross-sectional outliers
Names that moved more than three standard deviations from the rest of the market, with gap and relative volume attached.
GET top500 SELECT symbol, sector, ret, gap_pct, rvol(20) AS rv, cs_z(ret) AS z WHERE abs(z) > 3 SORT z
Rating changes, last three days
Every upgrade and downgrade across the top 500, with the old and new rating, to catch before the morning call.
RATINGS IN top500 LAST 3d WHERE action IN ('upgrade', 'downgrade') SORT date DESCThis week's reporters
The earnings calendar with consensus EPS and revenue, soonest first, so no position walks into a report by accident.
EARNINGS IN top500 NEXT 1w
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.
More financial markets use cases
- Momentum & trend followingCTAs, trend followers, growth PMs
- Mean reversion & short-term reversalShort-term traders, stat-arb desks
- Event-driven tradingEvent-driven PMs, special-situations traders
- Earnings tradingEarnings traders, fundamental L/S analysts
- Volatility & regime tradingVolatility traders, options desks, risk-premia PMs
- Market timing & breadthMacro PMs, asset allocators, tactical strategists