Release Notes

2026-02-14

New Functions

• Filter by instrument type with is_etf and is_stock fields — e.g., is_etf == false; to exclude ETFs [see: fields documentation]

• Rank stocks against the full universe with universe_percentile() — e.g., universe_percentile(volume) > 90; for top 10% by volume [see: universe_percentile() documentation]

Improvements

• Scans using lookback values (e.g., close[1], high[2]) generate leaner SQL for faster execution

• Improved data accuracy through nightly automated reconciliation to capture tweaks in price or volume, and to correct bad ticks

• Custom error pages with branding instead of generic browser errors

Bug Fixes

• Fixed chained offsets like close[1][2] producing errors

• Fixed certain scan patterns causing duplicate column errors

• Fixed multi-timeframe blocks incorrectly scoping fields

• Fixed broken formatting on function documentation pages

2026-02-02

Massive Performance Improvement!

• Scan performance improved 10-35x across all query types

• Complex indicator scans (MACD, RSI, etc) went from multi-second to sub-second query times

• Multi-Timeframe scans up to 33x faster

• All possible due to revamped query cache layer

2026-01-30

New Functions

• Conditional logic with cond(condition, true_val, false_val) for dynamic filtering [cond() documentation]

• Rolling sums with sum(field, period) for accumulation analysis [sum() documentation]

• Cumulative sums with cumsum(field) for running totals [cumsum() documentation]

• RSI building blocks: gain(field) and loss(field) for custom momentum analysis [gain() documentation] [loss() documentation]

• Related blog post: [blog post]

Performance

• Multi-timeframe query optimization: 74x faster MTF scans (3.474s to 0.047s)

• Progressive rendering for scan results - table populates as data arrives

• Other general scan optimizations for faster scan times

Infrastructure (Stock Universe)

• New symbol staging system with automatic qualification based on turnover analysis

• Symbol lifecycle tracking (additions, purges, blacklisting)

Bug Fixes

• Fixed synthetic field expansion

• Fixed MTF filter-mode filters not being applied

• Fixed RSI lookback period calculation edge case

• Fixed hover chart scroll position desync

• Fixed date resolution for aggregated timeframe queries

UI/UX

• Hover chart debouncing and memory improvements

• Display timing in seconds instead of milliseconds

• Rate limiting for chart-data endpoint

2025-12-17

• Multi-timeframe analysis with mtf() blocks. See NEW: Multi-Timeframe Scanning

• New all_time_high and all_time_low indicators. See All-Time High and All-Time Low: Two New Functions for Historical Analysis

• Editor beautify and auto-indent features

• Fixed OR filter logic bug that could produce incorrect results

2025-11-29

• Undo/redo support in expression editor

• Editor toolbar with copy button

• New indicators: streak(), count(), true_range(), pct_change()

• New synthetic fields: bar_range, bar_body, bar_upper_wick, bar_lower_wick

• Smart example browser with backend-driven category order

• Fixed race conditions in scan management

2025-11-26

• Improved mobile experience

• New landing page with feature showcase and chart examples

• Revamped pricing page with expanded FAQs

• Mobile-responsive scanner with offcanvas drawers

• Dark mode improvements across all pages

• Global message system replacing browser alerts

2025-11-24

• Expanded StonQL reference documentation

2025-11-23

• StonQL branding (Security Temporal ObservatioN Query Language)

• Recent IPOs example scan category

2025-11-22

• New synthetic fields: typical_price, hlc3, ohlc4, hl2

• Date delta functions: days_since(), weeks_since(), months_since(), years_since()

• first_trade_date metadata field for filtering by stock age

• Fixed theme flash on page load

2025-11-17

• Full-page chart view

• Improved hover chart with crosshair legend

• Company name column in scan results

• Enhanced chart color schemes for light/dark modes

2025-11-15

• Per-page social card support for blog posts

2025-11-14

• Pricing page origin story section

• Improved branding consistency

• Redesigned social card

2025-11-13

• Tag-based deployment system

• Subscription success page with analytics tracking

• Dedicated scan examples library page

• Dynamic function reference pages with categories

• New /docs/ landing page