SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/stock-market-sounds-alarm-first-time-25-years-heres-where-history-says-sp-500-headed-next","as_of":"2026-04-18T03:05:05.644967+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/the-stock-market-sounds-an-alarm-for-the-first-tim/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/stock-market-sounds-alarm-first-time-25-years-heres-where-history-says-sp-500-headed-next","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_529c26d92de8a12f","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/the-stock-market-sounds-an-alarm-for-the-first-tim/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T03:43:41.362090+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThroughout 2026, investors have rotated capital away from growth stocks.","fetched_title":"The Stock Market Sounds an Alarm for the First Time in 25 Years. Here's Where History Says the S&P 500 Is Headed Next. | Nasdaq","final_url":"https://www.nasdaq.com/articles/stock-market-sounds-alarm-first-time-25-years-heres-where-history-says-sp-500-headed-next","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/stock-market-sounds-alarm-first-time-25-years-heres-where-history-says-sp-500-headed-next","source_event_id":"evt_ef98f692a3bf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3879a977e8e0bc9f","kind":"unusual_volume","published_at":"2026-04-18T01:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2026","late March","2000","late 1920s"],"entities":[{"asset_class":"equity_index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"equity_index","name":"Nasdaq Composite","relevance":"medium","symbol":"^IXIC","type":"index"},{"asset_class":"macro_institution","name":"Federal Reserve","relevance":"medium","symbol":"","type":"institution"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"price_action","information_gaps":["This signal type requests unusual volume delta (volume ratio vs average), but the provided text contains no volume metrics, no ticker-specific volume information, and no volume ratio/baseline volume values.","The article does not explicitly confirm any volume anomaly with news; it focuses on valuation (CAPE) and historical patterns rather than trading volume behavior.","No specific catalyst is identified as a direct driver of an unusual volume event; the closest catalyst hypothesis is macro/valuation fragility implied by high CAPE and Nasdaq correction."],"key_facts":["The article states investors rotated away from growth stocks throughout 2026.","The article states the S&P 500 is up nearly 3% in 2026.","The article states the S&P 500 CAPE ratio is 36 and is the second-highest reading in history.","The article states the CAPE ratio is about 18% below its record level of 44.","The article states that after pronounced CAPE surges, the stock market cratered in the late 1920s (Great Depression) and after the dot-com bubble burst in 2000.","The article states the Nasdaq Composite entered correction territory in late March.","The article lists multiple uncertainties affecting markets: stubborn inflation, disagreements on Capitol Hill over Federal Reserve monetary policy, geopolitical tensions in the Middle East, energy-driven inflation, and upcoming midterm elections."],"numeric_claims":[{"label":"S&P 500 performance in 2026","value":"up nearly 3%"},{"label":"CAPE ratio","value":"36"},{"label":"CAPE record level","value":"44"},{"label":"CAPE distance from record","value":"about 18% below"}],"primary_claim":"The S&P 500 CAPE ratio is currently 36 (second-highest in history), and the article claims history shows the market has cratered after similar CAPE surges.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article argues that the S&P 500\u2019s cyclically adjusted P/E (CAPE) ratio is at a historically high level, implying the index may be overvalued and vulnerable to a sharp decline. It also notes Nasdaq entering correction territory in late March as additional evidence of market fragility.","topics":["valuation","CAPE ratio","market volatility","S&P 500 overvaluation","historical market drawdowns","Nasdaq correction","AI bull market","inflation","Federal Reserve policy","geopolitical tensions","midterm elections"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThroughout 2026, investors have rotated capital away from growth stocks.","tickers":[],"title":"The Stock Market Sounds an Alarm for the First Time in 25 Years. Here's Where History Says the S&P 500 Is Headed Next.","url":"https://www.fool.com/investing/2026/04/17/the-stock-market-sounds-an-alarm-for-the-first-tim/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_fe482820762b in signals