SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/ford-stock-10-years-where-will-it-be","as_of":"2026-04-19T12:46:14.065812+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/ford-stock-in-10-years-where-will-it-be/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ford-stock-10-years-where-will-it-be","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fd128e8029666b93","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/ford-stock-in-10-years-where-will-it-be/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T13:16:10.043383+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsFord's position as a legacy business in a mature industry means that its growth will remain extremely low in the long run.","fetched_title":"Ford Stock in 10 Years: Where Will It Be? | Nasdaq","final_url":"https://www.nasdaq.com/articles/ford-stock-10-years-where-will-it-be","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ford-stock-10-years-where-will-it-be","source_event_id":"evt_29237a32f8bf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba5e9b43343af530","kind":"unusual_volume","published_at":"2026-04-19T11:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 16","1903","2015","2017","2024","2025","December 17, 2004","2036"],"entities":[{"asset_class":"equity","name":"Ford Motor Company","relevance":"high","symbol":"F","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"other","information_gaps":["The provided signal type is \u201cdiscovery_unusual_volume_delta,\u201d but the article text contains no information about trading volume, volume ratio vs average, or any unusual volume confirmation.","No baseline volume, volume ratio, or direction (above/below average) is stated in the provided text.","No explicit catalyst for unusual volume is described; the article\u2019s catalyst content is limited to long-term fundamental outlook and valuation assumptions."],"key_facts":["The article states Ford is a legacy business in a mature industry and therefore will have extremely low long-run growth.","It claims Ford faces intense competition and demand fluctuates with the broader economy.","It states Ford\u2019s U.S. vehicle sales were 2.2 million \u201cjust last year.\u201d","It states Ford employed 169,000 people worldwide.","It states Ford\u2019s total return over the past decade was 66% versus the S&P 500\u2019s 300% (as of April 16).","It states Ford\u2019s automotive sales in 2025 were 24% higher than total from 2015.","It states worldwide new vehicle sales in 2024 were about the same as in 2017.","It states Ford\u2019s adjusted operating margin was 3.6% in 2025 versus 6.8% in 2015.","It states the article expects Ford to lag the S&P 500 between now and 2036.","It provides a scenario: assuming revenue grows 24% over the next decade and no margin expansion, earnings rise at a low-single-digit annualized rate.","It provides a valuation scenario: if the P/E of 11.3 stays the same in 10 years, shares would sell for $15.43; with a current price of $12.44, that implies 24% capital appreciation."],"numeric_claims":[{"label":"Ford employees (worldwide)","value":"169,000"},{"label":"Ford U.S. vehicles sold (just last year)","value":"2.2 million"},{"label":"S&P 500 total return (past decade, as of April 16)","value":"300%"},{"label":"Ford total return (past decade)","value":"66%"},{"label":"Ford automotive sales 2025 vs 2015","value":"24% higher"},{"label":"Worldwide new vehicle sales 2024 vs 2017","value":"about the same"},{"label":"Adjusted operating margin 2025","value":"3.6%"},{"label":"Automotive margin 2015","value":"6.8%"},{"label":"Forecast lag period","value":"between now and 2036"},{"label":"Assumed revenue growth over next decade","value":"24%"},{"label":"Current P/E used in scenario","value":"11.3"},{"label":"Implied share price in 10 years (scenario)","value":"$15.43"},{"label":"Current stock price used in scenario","value":"$12.44"},{"label":"Implied capital appreciation","value":"24%"}],"primary_claim":"Ford\u2019s growth and profitability are expected to remain low due to the mature global car market and legacy position, leading to likely underperformance versus the S&P 500 over the next decade.","relevance_score":0.25,"sentiment":"negative","source_quality":"high","summary":"The article argues Ford (NYSE: F) is likely to remain a low-growth, low-margin legacy automaker over the next decade, implying its stock may continue to lag the S&P 500. It provides long-term return/valuation scenarios but does not report any specific unusual trading volume event.","topics":["long-term stock outlook","automotive industry maturity","profitability/margins","valuation scenario","relative performance vs S&P 500"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsFord's position as a legacy business in a mature industry means that its growth will remain extremely low in the long run.","tickers":[],"title":"Ford Stock in 10 Years: Where Will It Be?","url":"https://www.fool.com/investing/2026/04/19/ford-stock-in-10-years-where-will-it-be/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_66b817b959db in signals