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 56784 in events
seq
Primary key.
INTEGER
id
evt_f52f7785a6a7
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-16T11:17:30.637551+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-16T11:16:12.965101+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:1c82da4787f14021","evidence_event_ids":["evt_d7b814eacc20"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/1-obvious-way-consumer-facing-stock-can-beat-sp-500-over-next-3-years","as_of":"2026-04-16T11:16:12.965101+00:00","canonical_url":"https://www.fool.com/investing/2026/04/16/1-obvious-way-consumer-stock-beat-sp500-3-years/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1-obvious-way-consumer-facing-stock-can-beat-sp-500-over-next-3-years","article_chars":4798,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ccc16730054e2c71","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/16/1-obvious-way-consumer-stock-beat-sp500-3-years/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-16T11:17:30.637513+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThanks to turnaround progress, this company's leadership team expects adjusted earnings per share to rise 73% (at the midpoint) between fiscal 2025 and fiscal 2028.","fetched_title":"1 Obvious Way This Consumer-Facing Stock Can Beat the S&P 500 Over the Next 3 Years | Nasdaq","final_url":"https://www.nasdaq.com/articles/1-obvious-way-consumer-facing-stock-can-beat-sp-500-over-next-3-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1-obvious-way-consumer-facing-stock-can-beat-sp-500-over-next-3-years","source_event_id":"evt_d7b814eacc20","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5384d581d8b1c517","kind":"unusual_volume","published_at":"2026-04-16T10:55:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["July 2021","April 14","late January","Dec. 28, 2025","April 16, 2026","December 17, 2004","April 15, 2005","fiscal 2022","fiscal 2025","fiscal 2026","fiscal 2028"],"entities":[{"asset_class":"equity","name":"Starbucks","relevance":"high","symbol":"SBUX","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"other","name":"Motley Fool Stock Advisor","relevance":"low","symbol":"","type":"publisher_section"}],"event_type":"other","information_gaps":["This signal type is discovery_unusual_volume_delta, but the provided text contains no unusual volume metrics (no volume ratio vs average, no baseline volume, no direction, and no explicit confirmation of volume anomaly).","No explicit catalyst is tied to unusual trading volume; the article\u2019s catalyst discussion is about management\u2019s turnaround and valuation headwinds, not volume behavior.","The article does not provide the specific ticker symbol in the provided text (though it clearly refers to Starbucks).","No confirmation is provided that any volume change is driven by news; the text does not mention volume at all."],"key_facts":["The article states Starbucks management expects adjusted EPS to total between $3.35 and $4.00 in fiscal 2028.","The article states fiscal 2025 adjusted EPS is $2.13.","The article calculates this as 73% adjusted EPS growth (at the midpoint) between fiscal 2025 and fiscal 2028.","The article says adjusted EPS declined by 28% over fiscal 2022 to fiscal 2025.","The article attributes prior issues to falling same-store sales and operational challenges (long wait times and a complex menu).","The article states comparable transactions globally increased 3% in fiscal 2026 first quarter (ended Dec. 28, 2025).","The article lists turnaround actions: revamped loyalty program, menu innovation, and investment in labor and technology to streamline store operations.","The article states Starbucks trades 22% below its record (as of April 14).","The article states Starbucks trades at 46x fiscal 2025 adjusted EPS.","The article argues valuation is an unlikely headwind to overcome (multiple would need to stay constant three years from now)."],"numeric_claims":[{"label":"Adjusted EPS (fiscal 2025)","value":"$2.13"},{"label":"Adjusted EPS (fiscal 2028 range)","value":"$3.35 to $4.00"},{"label":"Adjusted EPS growth (midpoint)","value":"73%"},{"label":"Adjusted EPS decline (fiscal 2022 to fiscal 2025)","value":"28%"},{"label":"Comparable transactions growth (global, fiscal 2026 Q1)","value":"3%"},{"label":"Stock discount to record (as of April 14)","value":"22%"},{"label":"Valuation multiple","value":"46x fiscal 2025 adjusted EPS"},{"label":"Implied annualized gain (if EPS growth occurs)","value":"20%"}],"primary_claim":"Starbucks management expects adjusted EPS to rise 73% (midpoint) between fiscal 2025 ($2.13) and fiscal 2028 ($3.35\u2013$4.00).","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues Starbucks could outperform the S&P 500 over the next three years if management\u2019s turnaround plan drives adjusted EPS growth of 73% (midpoint) from fiscal 2025 to fiscal 2028, but it warns valuation is a headwind.","topics":["turnaround","earnings outlook","adjusted EPS forecast","valuation","consumer demand","industry competition","stock performance vs S&P 500"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThanks to turnaround progress, this company's leadership team expects adjusted earnings per share to rise 73% (at the midpoint) between fiscal 2025 and fiscal 2028.","tickers":[],"title":"1 Obvious Way This Consumer-Facing Stock Can Beat the S&P 500 Over the Next 3 Years","url":"https://www.fool.com/investing/2026/04/16/1-obvious-way-consumer-stock-beat-sp500-3-years/"}}
TEXT NOT NULL
source_ref
candidate:sc_ccc16730054e2c71
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:1c82da4787f14021
TEXT
episode_id
NULL
TEXT
created_at
2026-04-16T11:17:30.637599+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel