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