SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-18T23:17:56.322952+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:2b8d9d9bfb7801ab","evidence_event_ids":["evt_ebed1b6aac74"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/better-insurance-stock-lemonade-vs-progressive","as_of":"2026-04-18T23:17:56.322952+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/better-insurance-stock-lemonade-vs-progressive/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/better-insurance-stock-lemonade-vs-progressive","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7d3dadbea0d1073c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/better-insurance-stock-lemonade-vs-progressive/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T00:41:47.722558+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsInsurance stocks can be an excellent source of stability and cash flow in a diversified investment portfolio.","fetched_title":"Better Insurance Stock: Lemonade vs. Progressive | Nasdaq","final_url":"https://www.nasdaq.com/articles/better-insurance-stock-lemonade-vs-progressive","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/better-insurance-stock-lemonade-vs-progressive","source_event_id":"evt_ebed1b6aac74","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"767759049376751f","kind":"unusual_volume","published_at":"2026-04-18T22:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["early January","2026","fourth quarter","two years earlier","past three decades","last year"],"entities":[{"asset_class":"equity","name":"Lemonade","relevance":"high","symbol":"LMND","type":"company"},{"asset_class":"equity","name":"Progressive","relevance":"high","symbol":"PGR","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"","type":"company_mentioned"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"","type":"company_mentioned"}],"event_type":"other","information_gaps":["No data is provided on unusual trading volume, including volume ratio vs average, baseline volume, or direction (up/down).","No explicit confirmation is given that any volume spike is driven by news; the article reads as a stock comparison rather than a volume-triggered event report.","The signal type requested (discovery_unusual_volume_delta) is not supported by the provided text; therefore no catalyst hypothesis for unusual volume can be grounded in the article."],"key_facts":["Lemonade (NYSE: LMND) uses AI to streamline operations, including chatbots for sales/claims and AI systems (AI Maya and AI Jim) for policy sales and claims automation (percentages stated in text).","Lemonade generated $738 million in revenue last year, representing 40% growth, and posted a net loss of $166 million (improved from prior years).","Lemonade\u2019s gross loss ratio improved to 64% in the fourth quarter, down from around 85% two years earlier.","Progressive (NYSE: PGR) has a long track record in automotive insurance and has returned 17% compounded annually over the past three decades.","Progressive wrote $83 billion in net premiums and produced $11.3 billion in net income last year.","Progressive paid a special dividend of $13.50 per share (around a 6% yield) in early January (as stated).","The article attributes Progressive\u2019s recent stock decline to competition heating up and a softening insurance market; it cites a projected 1% national average increase for 2026.","The article states Progressive\u2019s stock is down 30% from its 52-week high and Lemonade is down 26.5% (as stated)."],"numeric_claims":[{"label":"Lemonade revenue (last year)","value":"$738 million"},{"label":"Lemonade revenue growth","value":"40%"},{"label":"Lemonade net loss (last year)","value":"$166 million"},{"label":"Lemonade gross loss ratio (Q4)","value":"64%"},{"label":"Lemonade gross loss ratio (two years earlier)","value":"~85%"},{"label":"Progressive stock decline from 52-week high","value":"30%"},{"label":"Lemonade stock decline from 52-week high","value":"26.5%"},{"label":"Progressive return (past three decades, CAGR)","value":"17% compounded annually"},{"label":"Progressive net premiums (last year)","value":"$83 billion"},{"label":"Progressive net income (last year)","value":"$11.3 billion"},{"label":"Progressive special dividend per share","value":"$13.50"},{"label":"Dividend yield (early January)","value":"~6%"},{"label":"Projected national average increase for 2026","value":"1%"}],"primary_claim":"Lemonade is improving underwriting profitability (gross loss ratio improved to 64% in Q4) while Progressive\u2019s stock has declined due to softer market conditions and competition.","relevance_score":0.15,"sentiment":"mixed","source_quality":"high","summary":"The article compares insurance stocks Lemonade (LMND) and Progressive (PGR), arguing Lemonade\u2019s AI-driven underwriting improvements and Progressive\u2019s recent stock weakness make them different investment choices. It does not provide any unusual trading volume data or a volume ratio versus average.","topics":["insurance stocks","AI in insurance","underwriting profitability","gross loss ratio","market cycles (soft vs hard)","stock performance","telemetics","telematics pricing","dividends"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsInsurance stocks can be an excellent source of stability and cash flow in a diversified investment portfolio.","tickers":[],"title":"Better Insurance Stock: Lemonade vs. Progressive","url":"https://www.fool.com/investing/2026/04/18/better-insurance-stock-lemonade-vs-progressive/"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 253407 in events