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/foldable-iphone-reason-buy-apples-stock","as_of":"2026-04-12T14:47:21.649613+00:00","canonical_url":"https://www.fool.com/investing/2026/04/12/is-a-foldable-iphone-a-reason-to-buy-apples-stock/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/foldable-iphone-reason-buy-apples-stock","article_chars":4205,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_8f51a06ecc7fd57f","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/12/is-a-foldable-iphone-a-reason-to-buy-apples-stock/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T15:17:16.530762+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsApple's entrance into the foldable smartphone market should help drive sales, especially in China.","fetched_title":"Is a Foldable iPhone a Reason to Buy Apple's Stock? | Nasdaq","final_url":"https://www.nasdaq.com/articles/foldable-iphone-reason-buy-apples-stock","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/foldable-iphone-reason-buy-apples-stock","source_event_id":"evt_d23dbafc5895","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0efe63065b2abec0","kind":"unusual_volume","published_at":"2026-04-12T13:45:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["September","2019","December 17, 2004","April 15, 2005","April 12, 2026"],"entities":[{"asset_class":"equity","name":"Apple Inc.","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"N/A","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"N/A","type":"company"}],"event_type":"other","information_gaps":["Unusual volume details are missing: no volume ratio vs average, no baseline volume, and no direction (e.g., above/below average) are provided in the text.","No explicit confirmation source is provided for the technical challenges beyond the article\u2019s wording ('reportedly').","No specific catalyst beyond the foldable iPhone launch is explicitly tied to the volume signal (the signal type is not addressed in the article text)."],"key_facts":["Apple is expected to enter the foldable smartphone market later this year.","The article says Apple has reportedly hit technical challenges related to the device\u2019s design and durability.","The foldable iPhone is expected to be introduced in September, when Apple typically unveils its latest iPhone lineup.","The foldable iPhone is projected to cost more than $2,000 and is described as Apple\u2019s new high-end version.","The article states the most important market for these phones is not the U.S. but China, where foldable smartphone sales are described as growing briskly.","The article concludes Apple stock is not a buy on the introduction of a foldable iPhone by itself; it frames the broader reason as Apple\u2019s compounding business model/ecosystem."],"numeric_claims":[{"label":"foldable iPhone price projection (USD)","value":">2000"}],"primary_claim":"Apple\u2019s entrance into foldable smartphones later this year (expected September) could help drive sales, particularly in China, but Apple stock is not a buy based on the foldable iPhone alone.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article argues Apple\u2019s planned foldable iPhone could be a positive for sales\u2014especially in China\u2014but it is not presented as the main reason to buy Apple stock. It also notes reported technical design/durability challenges and an expected September launch.","topics":["foldable iPhone","product launch timing","China smartphone market","Apple ecosystem lock-in","stock buy thesis"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsApple's entrance into the foldable smartphone market should help drive sales, especially in China.","tickers":[],"title":"Is a Foldable iPhone a Reason to Buy Apple's Stock?","url":"https://www.fool.com/investing/2026/04/12/is-a-foldable-iphone-a-reason-to-buy-apples-stock/"}

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_0a794ccd18af in signals