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-19T18:44:42.562027+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:d1f991790c2eb530","evidence_event_ids":["evt_aaa71eabea63"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/heres-1-thing-watch-when-lemonade-releases-earnings-april-29","as_of":"2026-04-19T18:44:42.562027+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/heres-the-1-thing-to-watch-when-lemonade-releases/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/heres-1-thing-watch-when-lemonade-releases-earnings-april-29","article_chars":3385,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d6ecda81ee7ed38c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/heres-the-1-thing-to-watch-when-lemonade-releases/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T19:15:35.909911+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsLemonade's revenue has been increasing, and growth has been accelerating.","fetched_title":"Here's the 1 thing to Watch When Lemonade Releases Earnings on April 29 | Nasdaq","final_url":"https://www.nasdaq.com/articles/heres-1-thing-watch-when-lemonade-releases-earnings-april-29","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/heres-1-thing-watch-when-lemonade-releases-earnings-april-29","source_event_id":"evt_aaa71eabea63","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"902d47b384981b47","kind":"unusual_volume","published_at":"2026-04-19T17:07:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 29","Feb. 19","December 17, 2004","April 15, 2005","April 19, 2026"],"entities":[{"asset_class":"equity","name":"Lemonade","relevance":"high","symbol":"LMND","type":"company"},{"asset_class":"other","name":"Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided text contains no volume ratio, baseline volume, or any mention of unusual trading volume.","No explicit confirmation is provided in the text that any unusual volume is confirmed by news; the article is an earnings preview and does not link volume changes to a specific catalyst beyond general earnings expectations.","The 'most likely catalyst hypothesis' for unusual volume cannot be grounded in the provided text because no volume data or catalyst linkage is stated."],"key_facts":["Lemonade is scheduled to release fiscal 2026 Q1 earnings on April 29.","The article states Lemonade\u2019s revenue has been increasing and growth has been accelerating.","The article states growth in in-force premiums (IFP) has accelerated for the past seven quarters.","The article states Lemonade\u2019s loss ratio has been improving.","The article states Lemonade is still unprofitable on an adjusted EBITDA basis.","Management is expecting adjusted EBITDA to turn positive in the fourth quarter of fiscal 2026 and improve throughout the year.","The article says Lemonade dropped after its last earnings report on Feb. 19."],"numeric_claims":[{"label":"earnings release date","value":"April 29 (year not specified)"}],"primary_claim":"Lemonade\u2019s loss ratio has been improving and the main thing to watch in its April 29 fiscal 2026 Q1 report is how well adjusted EBITDA is improving.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article discusses Lemonade (LMND) ahead of its fiscal 2026 Q1 earnings release on April 29, highlighting accelerating revenue growth and an improving loss ratio. It emphasizes that the key metric to watch is whether adjusted EBITDA losses are improving toward profitability later in fiscal 2026.","topics":["earnings preview","revenue growth","in-force premiums","loss ratio","adjusted EBITDA profitability","insurance metrics","stock performance context"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsLemonade's revenue has been increasing, and growth has been accelerating.","tickers":[],"title":"Here's the 1 thing to Watch When Lemonade Releases Earnings on April 29","url":"https://www.fool.com/investing/2026/04/19/heres-the-1-thing-to-watch-when-lemonade-releases/"}}

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