SQLite Web: event_store.db

Update row 101662 in events

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-17T18:02:19.234747+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:c34424cdb73e1396","evidence_event_ids":["evt_1acf26908544"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/why-apple-stock-popped-friday-morning","as_of":"2026-04-17T18:02:19.234747+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/why-apple-stock-popped-friday-morning/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-apple-stock-popped-friday-morning","article_chars":3582,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_8c0c139392820f7d","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/why-apple-stock-popped-friday-morning/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T23:23:57.082014+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsApple increased iPhone sales in China in Q1, even as overall smartphone sales in the country declined.","fetched_title":"Why Apple Stock Popped Friday Morning | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-apple-stock-popped-friday-morning","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-apple-stock-popped-friday-morning","source_event_id":"evt_1acf26908544","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f9bbd3573008e00e","kind":"unusual_volume","published_at":"2026-04-17T17:11:17+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["Friday","Q1","2024","late last year","2025","December 17, 2004","April 15, 2005","April 17, 2026"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"other","name":"Counterpoint Research","relevance":"high","symbol":"","type":"research_firm"},{"asset_class":"other","name":"Tim Cook","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"low","symbol":"","type":"geopolitical_location"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"price_action","information_gaps":["Unusual volume details are missing: no volume ratio vs average, no baseline volume, and no direction/volume delta figures are provided in the text.","The signal type is discovery_unusual_volume_delta, but the article content provided does not mention unusual trading volume or confirm it with any volume metrics.","Catalyst hypothesis is described qualitatively (iPhone sales in China) but no explicit linkage to volume is provided beyond attributing the price move to that news.","The article mentions a cease-fire and opening of the Strait of Hormuz boosting sentiment, but it does not quantify their impact separately from the iPhone-sales catalyst."],"key_facts":["Apple shares climbed on Friday, adding as much as 3.4% and still up 3.1% as of 12:40 p.m. ET (per article).","The article says the catalyst for the move was news of increasing iPhone sales in China.","Counterpoint Research data cited: iPhone shipments increased 20% year over year in Q1 while overall smartphone shipments in China declined 4%.","The article says Apple\u2019s iPhone market share increased while overall smartphone sales declined.","The article states this was the strongest performance among major brands in China, per Counterpoint Research.","The article notes a rebound late last year after a drought in iPhone sales in 2024, citing Apple CEO Tim Cook describing \u201cstaggering demand\u201d and record sales as 2025 came to a close.","The article says the iPhone was the top-selling smartphone brand in China in the final quarter of last year, per Counterpoint Research.","The article claims Apple has held its prices steady despite a spike in global memory prices, helping it gain market share.","The article states Counterpoint views Apple as best positioned to navigate the global memory crunch, supported by premium products and strong supply chain management."],"numeric_claims":[{"label":"Apple stock intraday gain (max)","value":"3.4%"},{"label":"Apple stock gain at 12:40 p.m. ET","value":"3.1%"},{"label":"iPhone shipments growth in China (Q1 YoY)","value":"20%"},{"label":"Overall smartphone shipments decline in China (Q1)","value":"4%"},{"label":"Apple valuation multiple (times earnings)","value":"33x"},{"label":"Active devices","value":"2.5 billion"}],"primary_claim":"The article states that increasing iPhone sales in China in Q1 was the catalyst for Apple stock\u2019s Friday morning gains, even as overall smartphone sales in China declined.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Apple shares rose sharply on Friday, with the article attributing the move primarily to stronger iPhone sales in China despite a decline in overall smartphone shipments. The piece cites Counterpoint Research data showing iPhone shipment growth and rising market share.","topics":["Apple stock price move","iPhone sales in China","market share","Counterpoint Research data","smartphone shipments decline in China","valuation multiple","supply chain/pricing strategy"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsApple increased iPhone sales in China in Q1, even as overall smartphone sales in the country declined.","tickers":[],"title":"Why Apple Stock Popped Friday Morning","url":"https://www.fool.com/investing/2026/04/17/why-apple-stock-popped-friday-morning/"}}

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')

Cancel