Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_memory
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 224915 in events
seq
Primary key.
INTEGER
id
evt_deb36f7912c9
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-18T19:17:35.324404+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-18T18:48:29.555162+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:f7082b1ef91a88c0","evidence_event_ids":["evt_7fd78612f936"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/should-you-buy-lemonade-stock-april-29","as_of":"2026-04-18T18:48:29.555162+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/should-you-buy-lemonade-stock-before-apr-29/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/should-you-buy-lemonade-stock-april-29","article_chars":4832,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_53d2d8c87d53fb76","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/should-you-buy-lemonade-stock-before-apr-29/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T19:17:35.324355+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsLemonade is growing quickly and moving toward profitability.","fetched_title":"Should You Buy Lemonade Stock Before April 29? | Nasdaq","final_url":"https://www.nasdaq.com/articles/should-you-buy-lemonade-stock-april-29","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/should-you-buy-lemonade-stock-april-29","source_event_id":"evt_7fd78612f936","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c00a7716d3926f07","kind":"unusual_volume","published_at":"2026-04-18T18:09:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 29, 2026","2026 first-quarter","2026 fourth quarter","2027","2025 fourth quarter","April 18, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Lemonade","relevance":"high","symbol":"LMND","type":"company"},{"asset_class":"other","name":"Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"","type":"company"}],"event_type":"earnings","information_gaps":["This signal type is discovery_unusual_volume_delta, but the provided text contains no volume ratio, baseline volume, or any unusual trading volume figures.","No explicit statement confirms whether any unusual volume is confirmed by news versus unexplained; the article discusses volatility and macro/geopolitical sentiment but does not tie it to a specific volume spike.","No explicit catalyst is stated for unusual volume beyond the general upcoming earnings date (April 29) and broader geopolitical/macro uncertainty."],"key_facts":["Lemonade (NYSE: LMND) reports 2026 first-quarter earnings on April 29.","The article states Lemonade is growing quickly and moving toward profitability.","The article attributes an edge to Lemonade\u2019s AI foundation versus larger insurance incumbents.","The article says Lemonade\u2019s operating expenses excluding growth (OPEX) have remained constant while in-force premium (IFP) has increased.","The article says Lemonade\u2019s loss ratio has been declining, implying underwriting improvement as more data is collected.","Management long-term goals cited include reaching positive adjusted EBITDA by 2026 fourth quarter and positive net income to follow in 2027.","The article states IFP growth has accelerated for seven quarters, reaching 31% in 2025 fourth quarter.","The article says management expects IFP to increase about 32% in 2026 first quarter.","The article states adjusted EBITDA is expected to remain negative for the first three quarters and full year, with a 50% improvement in the loss.","The article says the stock has seen major swings recently and is trading roughly flat this year despite broader market recovery.","The article links recent market volatility to the war in Iran and changing investor sentiment."],"numeric_claims":[{"label":"S&P 500 performance (as of writing)","value":"up 4% in 2026"},{"label":"IFP growth (2025 Q4)","value":"31%"},{"label":"IFP expected growth (2026 Q1)","value":"about 32%"},{"label":"Adjusted EBITDA outlook","value":"negative for first three quarters and full year; 50% improvement in the loss"},{"label":"Earnings date","value":"April 29, 2026"}],"primary_claim":"Lemonade (LMND) is scheduled to report 2026 first-quarter earnings on April 29, and the article argues its AI-driven model is supporting robust growth and improving profitability metrics.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"The article discusses Lemonade (NYSE: LMND) ahead of its April 29, 2026 earnings, highlighting growth and improving profitability metrics. It frames recent stock volatility as largely driven by broader geopolitical/macro sentiment rather than company performance.","topics":["earnings preview","insurance technology","AI foundation","profitability metrics","loss ratio","in-force premium (IFP)","geopolitical market volatility","macro sentiment"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsLemonade is growing quickly and moving toward profitability.","tickers":[],"title":"Should You Buy Lemonade Stock Before April 29?","url":"https://www.fool.com/investing/2026/04/18/should-you-buy-lemonade-stock-before-apr-29/"}}
TEXT NOT NULL
source_ref
candidate:sc_53d2d8c87d53fb76
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:f7082b1ef91a88c0
TEXT
episode_id
NULL
TEXT
created_at
2026-04-18T19:17:35.324482+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel