How many stocks had an unusual volume anomaly in the last 30 days?

The query

SELECT COUNT(*) AS symbols_with_volume_anomaly
FROM ticker_analysis ta
JOIN ticketname tn ON tn.ticket = ta.ticket
WHERE ta.analysis_type = 'volume_anomaly' AND tn.tickettype = 'stock'
  AND ta.event_at >= NOW() - INTERVAL '30 days'

Runs against Cryptobi's market tables — ticketname (symbols), ticketprice (daily prices and volume) and symbolmetadata (sector, exchange, market cap and other reference fields).

Current output

Live output, first 1 rows, refreshed periodically. Model estimates are trend projections from recent prices, not financial advice.

Related calculations

• Show the average stock volatility by sector, last 30 days
• Show the top 10 most volatile stocks in the market, last 30 days
• Get the risk profile (max drawdown, volatility, Sharpe ratio) for a specific symbol (edit the symbol)