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
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 44828 in events
seq
Primary key.
INTEGER
id
evt_fc1d7562e17f
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-14T21:46:33.664938+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-14T15:49:56.121353+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:79d53aff6d3f13b3","evidence_event_ids":["evt_cdbf8ae2f13f"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/bull-vs-bear-apple-buy-or-sell","as_of":"2026-04-14T15:49:56.121353+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/bull-vs-bear-is-apple-a-buy-or-sell/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bull-vs-bear-apple-buy-or-sell","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0fe9fd7dbb4bf1e2","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/bull-vs-bear-is-apple-a-buy-or-sell/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T21:46:33.664890+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsApple has one of the best business models in the world and should compound its growth for decades to come.","fetched_title":"Bull vs. Bear: Is Apple a Buy or Sell? | Nasdaq","final_url":"https://www.nasdaq.com/articles/bull-vs-bear-apple-buy-or-sell","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bull-vs-bear-apple-buy-or-sell","source_event_id":"evt_cdbf8ae2f13f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7fc67238d4bdd260","kind":"unusual_volume","published_at":"2026-04-14T15:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2016","2019","2021","2023","December 17, 2004"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Alphabet","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Berkshire Hathaway","relevance":"low","symbol":"","type":"company"},{"asset_class":"person","name":"Warren Buffett","relevance":"low","symbol":"","type":"person"}],"event_type":"other","information_gaps":["This signal type is \u201cdiscovery_unusual_volume_delta,\u201d but the provided article text contains no unusual volume ratio, baseline volume, or direction (e.g., volume up/down vs average).","No explicit catalyst tied to unusual volume is described; the article is primarily valuation/innovation commentary.","The article mentions Berkshire Hathaway reducing its stake before Buffett retired as CEO, but provides no dates or quantitative stake-change details in the provided text."],"key_facts":["The article frames Apple as a \u201cbull vs. bear\u201d stock and discusses whether it is a buy or sell.","Bull case: Apple is described as a luxury brand with a high-end customer base that upgrades more predictably and buys higher-margin subscriptions/services.","The article claims Apple\u2019s ecosystem creates customer lock-in and supports high-margin services and payments (Apple Pay).","The article states Apple receives revenue-sharing money from Alphabet as the default search engine on its devices.","Bear case: The article argues Apple is no longer a product innovator and cites limited \u201ctruly impactful\u201d new products since AirPods (2016).","The article mentions AirTags (2021) and Vision Pro (revealed 2023) as not being major mainstream drivers.","The article claims competitors have led smartphone technology and that Apple is only looking to introduce a foldable iPhone (competitors offered since 2019).","The article claims Apple has struggled to keep pace in the AI arms race and that Siri\u2019s more complex reasoning uses Alphabet\u2019s Gemini.","The article states Apple\u2019s stock performance over the past decade is attributed more to multiple expansion than earnings growth, with trailing P/E rising from around 10 to over 30.","The article says forward P/E is nearly 31 and concludes the stock is not cheap.","The article\u2019s \u201cverdict\u201d says holders should hold, and new-money buyers should wait for a dip before buying."],"numeric_claims":[{"label":"P/E (trailing) change over decade","value":"around 10 to over 30"},{"label":"Forward P/E","value":"nearly 31"},{"label":"Android smartphone share (global perspective)","value":"about 70%"},{"label":"iPhone price premium vs comparable Android","value":"30% to 50% more"},{"label":"AirPods introduction year","value":"2016"},{"label":"AirTags introduction year","value":"2021"},{"label":"Vision Pro revealed year","value":"2023"},{"label":"Competitors foldable iPhone availability","value":"since 2019"},{"label":"Siri AI reliance","value":"uses Alphabet's Gemini for more complex reasoning"}],"primary_claim":"Apple\u2019s business model is strong and likely to compound for decades, but the company is behind on innovation and AI, making the stock not cheap and suggesting new buyers wait for a dip.","relevance_score":0.22,"sentiment":"mixed","source_quality":"high","summary":"The article is a \u201cbull vs. bear\u201d discussion of Apple (AAPL), arguing Apple\u2019s business model remains strong but innovation and AI competitiveness lag. It does not provide any specific unusual trading volume figures or a volume-vs-average ratio.","topics":["equity valuation","business model","innovation","AI competitiveness","stock recommendation framing","Apple ecosystem/services"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsApple has one of the best business models in the world and should compound its growth for decades to come.","tickers":[],"title":"Bull vs. Bear: Is Apple a Buy or Sell?","url":"https://www.fool.com/investing/2026/04/14/bull-vs-bear-is-apple-a-buy-or-sell/"}}
TEXT NOT NULL
source_ref
candidate:sc_0fe9fd7dbb4bf1e2
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:79d53aff6d3f13b3
TEXT
episode_id
NULL
TEXT
created_at
2026-04-14T21:46:33.664995+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel