Create
Query
event_store.db
—
events
actions
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
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 29857 in events
seq
Primary key.
INTEGER
id
evt_e171fbaf1317
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-12T15:17:16.530843+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-12T14:47:21.649613+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:cfbb48f5601216e8","evidence_event_ids":["evt_d23dbafc5895"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","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
source_ref
candidate:sc_8f51a06ecc7fd57f
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:cfbb48f5601216e8
TEXT
episode_id
NULL
TEXT
created_at
2026-04-12T15:17:16.531199+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel