Calculations › Market Trends
Show the most recent trend-break events detected market-wide (technical analysis event log)
The query
-- analysis_type can also be price_zscore, price_volume_spike, trend_change,
-- volatility_expansion, volume_anomaly, or relative_strength for other event types
SELECT ta.ticket, tn.ticketname AS name,
ta.payload->>'explanation' AS explanation,
ta.event_at
FROM ticker_analysis ta
JOIN ticketname tn ON tn.ticket = ta.ticket
WHERE ta.analysis_type = 'trend_break'
ORDER BY ta.event_at DESC
LIMIT 20
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
| Ticket | Name | Explanation | Event at |
|---|---|---|---|
| HOFI.ST | Hoist Finance | Price broke below rolling low (201.8000 < 202.0000, window=20). | 2026-10-01 00:00:00 |
| TEL.OL | Telenor | Price broke below rolling low (126.9000 < 127.3000, window=20). | 2026-10-01 00:00:00 |
| GARO.ST | Garo | Price broke above rolling high (11.8000 > 11.5000, window=20). | 2026-10-01 00:00:00 |
| SPEC.ST | SpectraCure AB | Price broke below rolling low (0.0180 < 0.0182, window=20). | 2026-10-01 00:00:00 |
| VNV.ST | VNV Global | Price broke below rolling low (18.0400 < 18.1800, window=20). | 2026-10-01 00:00:00 |
| DNB.OL | DNB Bank | Price broke below rolling low (309.2000 < 312.7000, window=20). | 2026-10-01 00:00:00 |
| MTRS.ST | Munters Group AB | Price broke below rolling low (129.5500 < 130.0000, window=20). | 2026-10-01 00:00:00 |
| EMBRAC-B.ST | Embracer Group B | Price broke above rolling high (88.1600 > 86.4200, window=20). | 2026-10-01 00:00:00 |
| LUND-B.ST | Lundberg B | Price broke below rolling low (566.0000 < 576.0000, window=20). | 2026-10-01 00:00:00 |
| SGDUSD=X | SGD/USD | Price broke below rolling low (0.7804 < 0.7811, window=20). | 2026-10-01 00:00:00 |
| HANZA.ST | HANZA | Price broke above rolling high (163.4000 > 159.2000, window=20). | 2026-10-01 00:00:00 |
| ASTS | AST SpaceMobile A | Price broke below rolling low (57.9350 < 58.5200, window=20). | 2026-10-01 00:00:00 |
| ENGCON-B.ST | engcon B | Price broke below rolling low (68.0000 < 68.1000, window=20). | 2026-10-01 00:00:00 |
| KEBNI-B.ST | KebNi B | Price broke below rolling low (0.7700 < 0.7810, window=20). | 2026-10-01 00:00:00 |
| HEXA-B.ST | Hexagon B | Price broke above rolling high (99.0200 > 98.8200, window=20). | 2026-10-01 00:00:00 |
Live output, first 15 rows, refreshed periodically. Model estimates are trend projections from recent prices, not financial advice.
Run this on your own holdings, change it, or write your own in SQL or Python — then put it on a dashboard or have it emailed on a schedule. Free, no credit card.
Sign Up Free