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-14T14:15:37.043630+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:643d39afa2f2557e","evidence_event_ids":["evt_8d9d9c5b7e8c"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/insurance-stock-has-quietly-crushed-sp-500-over-10-years","as_of":"2026-04-14T14:15:37.043630+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/insurance-stock-quietly-crushed-sp-500-pgr/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/insurance-stock-has-quietly-crushed-sp-500-over-10-years","article_chars":4551,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2449d71a279bdfc8","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/insurance-stock-quietly-crushed-sp-500-pgr/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T14:21:14.423405+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsProgressive's combined ratio is exceeding management's target, resulting in high profitability.","fetched_title":"This Insurance Stock Has Quietly Crushed the S&P 500 Over 10 Years | Nasdaq","final_url":"https://www.nasdaq.com/articles/insurance-stock-has-quietly-crushed-sp-500-over-10-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/insurance-stock-has-quietly-crushed-sp-500-over-10-years","source_event_id":"evt_8d9d9c5b7e8c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"be34ecda67eaef22","kind":"unusual_volume","published_at":"2026-04-14T13:45:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2025","January","December 17, 2004","April 15, 2005","April 14, 2026"],"entities":[{"asset_class":"equity","name":"Progressive","relevance":"high","symbol":"PGR","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"high","symbol":"","type":"index"}],"event_type":"other","information_gaps":["This signal type is \u201cdiscovery_unusual_volume_delta,\u201d but the provided text contains no trading volume data, no volume ratio vs average, and no confirmation/unexplained status for unusual volume.","The article does not provide a specific catalyst tied to unusual volume; it discusses longer-term performance drivers (underwriting, investments, technology/AI, and dividends).","The magnitude of outperformance vs the S&P 500 over 10 years is not quantified in the provided text (no exact return percentage).","No explicit statement confirms whether the described performance is based on audited results vs projections beyond the cited 2025 figures."],"key_facts":["Progressive is described as one of the largest U.S. insurance companies and has been in operation since 1937.","Management\u2019s stated goal is to keep the combined ratio below 96%.","The article states the combined ratio \u201ccame in below 90% in 2025.\u201d","The article states Progressive had \u201ca 7% return on investments\u201d and that \u201cprofits soared last year.\u201d","The article states earnings per share rose from $14.40 to $19.23.","The article states Progressive had \u201c3.7 million new policies in force\u201d and \u201c$9 billion in additional written premiums\u201d compared to the previous year.","The article states Progressive paid out $13.50 per share in January, described as tied to high 2025 profits.","The article claims Progressive stock \u201ctrounced the S&P 500 over the past 10 years, dividends included.\u201d","The article states Progressive\u2019s P/E ratio is 10 and price-to-book ratio is 3.7, concluding it looks \u201cfairly valued.\u201d","The article mentions Progressive is \u201cincorporating technology into its systems in the age of AI.\u201d","The article notes risks from changing insurance regulations and AI/machine learning adoption in the industry."],"numeric_claims":[{"label":"combined_ratio_target","value":"<96% (management goal)"},{"label":"combined_ratio_2025","value":"<90% (stated)"},{"label":"roi","value":"7% (stated return on investments)"},{"label":"eps_earlier","value":"$14.40"},{"label":"eps_later","value":"$19.23"},{"label":"new_policies_in_force","value":"3.7 million"},{"label":"additional_written_premiums","value":"$9 billion"},{"label":"dividend_per_share_january","value":"$13.50"},{"label":"pe_ratio","value":"10"},{"label":"price_to_book","value":"3.7"}],"primary_claim":"Progressive (NYSE: PGR) has \u201cseriously outperformed the S&P 500 over the last decade,\u201d with profitability driven by a combined ratio below management\u2019s 96% target (below 90% in 2025).","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article argues that Progressive (PGR) has outperformed the S&P 500 over the past 10 years, attributing strength to underwriting performance (combined ratio below target) and profitability supported by investment returns and technology adoption.","topics":["insurance underwriting","combined ratio","profitability","stock performance","valuation","technology/AI in insurance","dividends","regulatory risk"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsProgressive's combined ratio is exceeding management's target, resulting in high profitability.","tickers":[],"title":"This Insurance Stock Has Quietly Crushed the S&P 500 Over 10 Years","url":"https://www.fool.com/investing/2026/04/14/insurance-stock-quietly-crushed-sp-500-pgr/"}}

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 43005 in events