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/1000-and-rocky-market-these-6-cheap-stocks-are-exactly-where-id-start","as_of":"2026-04-19T00:47:45.189143+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/1000-and-a-rocky-market-check-these-6-cheap-stocks/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1000-and-rocky-market-these-6-cheap-stocks-are-exactly-where-id-start","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_696baa3b453e8e3a","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/1000-and-a-rocky-market-check-these-6-cheap-stocks/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T01:17:11.119866+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsEven in uncertain markets, everyday consumer brands like Post Holdings, Hormel Foods, and Clorox benefit from steady demand, making them resilient long-term holds when others panic.","fetched_title":"$1,000 and a Rocky Market: These 6 Cheap Stocks Are Exactly Where I'd Start | Nasdaq","final_url":"https://www.nasdaq.com/articles/1000-and-rocky-market-these-6-cheap-stocks-are-exactly-where-id-start","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1000-and-rocky-market-these-6-cheap-stocks-are-exactly-where-id-start","source_event_id":"evt_3af097af7725","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c0844110ec61a52c","kind":"unusual_volume","published_at":"2026-04-18T23:41:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Post Holdings","relevance":"high","symbol":"POST","type":"company"},{"asset_class":"equity","name":"Utz Brands","relevance":"high","symbol":"UTZ","type":"company"},{"asset_class":"equity","name":"Hormel Foods","relevance":"high","symbol":"HRL","type":"company"},{"asset_class":"equity","name":"Bath & Body Works","relevance":"high","symbol":"BBWI","type":"company"},{"asset_class":"equity","name":"Conagra Brands","relevance":"high","symbol":"CAG","type":"company"},{"asset_class":"equity","name":"Clorox","relevance":"high","symbol":"CLX","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"other","information_gaps":["No ticker is explicitly tied to an \u201cunusual volume delta\u201d in the provided text.","No volume ratio vs average (or baseline volume) is provided.","No confirmation mechanism is described (e.g., whether unusual volume is driven by news, earnings, filings, or is unexplained).","The article appears to be a general stock-picking piece rather than a report of a specific volume spike event.","most_likely_catalyst_hypothesis_unusual_volume_delta_missing_due_to_no_volume_data: The signal\u2019s catalyst cannot be inferred from the provided article because it contains no unusual-volume figures or event linkage."],"key_facts":["The article frames the market as volatile (S&P 500 swinging ~3% in a day) and argues volatility can create entry points.","It lists six consumer goods stocks: POST, UTZ, HRL, BBWI, CAG, and CLX.","For HRL, the article states it is a \u201cDividend King\u201d with 60 consecutive years of dividend increases.","For BBWI, the article cites Morningstar estimates of trading at \u201cmore than a 60% discount to fair value\u201d and warns about major investors exiting stakes due to weak performance, declining sales, and lowered guidance.","For CAG, the article claims a 9% dividend yield and says the company used AI to rationalize its brand portfolio over the last two years.","For CLX, the article says it is down from highs and faces private-label competition, but argues its products are everyday necessities and it is investing in innovation/marketing."],"numeric_claims":[{"label":"S&P 500 daily swing","value":"~3%"},{"label":"HRL dividend increases","value":"60 consecutive years"},{"label":"BBWI discount to fair value (Morningstar estimate)","value":">60%"},{"label":"CAG dividend yield","value":"9%"}],"primary_claim":"The article recommends Post Holdings (POST), Utz Brands (UTZ), Hormel Foods (HRL), Bath & Body Works (BBWI), Conagra Brands (CAG), and Clorox (CLX) as starting points for long-term investors during market volatility.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The provided article is a Motley Fool-style list recommending six \u201ccheap\u201d consumer goods stocks for a volatile market, but it does not provide any unusual trading volume metrics or specific volume-vs-average ratios.","topics":["consumer staples","stock picking","valuation","dividends","market volatility","turnaround risk","private-label competition","AI/portfolio rationalization"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsEven in uncertain markets, everyday consumer brands like Post Holdings, Hormel Foods, and Clorox benefit from steady demand, making them resilient long-term holds when others panic.","tickers":[],"title":"$1,000 and a Rocky Market: These 6 Cheap Stocks Are Exactly Where I'd Start","url":"https://www.fool.com/investing/2026/04/18/1000-and-a-rocky-market-check-these-6-cheap-stocks/"}

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_5c77df5c8ce9 in signals