SQLite Web: event

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-09T16:35:58.987693+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:2b82a71098f62917","evidence_event_ids":["evt_7abb8103117a"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/why-blackberry-stock-skyrocketing-today","as_of":"2026-04-09T16:35:58.987693+00:00","canonical_url":"https://www.fool.com/investing/2024/12/20/why-blackberry-stock-is-soaring-today/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-blackberry-stock-skyrocketing-today","article_chars":4294,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_be961184b5925043","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2024/12/20/why-blackberry-stock-is-soaring-today/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:16:08.476664+00:00","extraction_method":"heuristic","fetched_description":"BlackBerry (NYSE: BB) stock is surging in Friday's trading following the company's recent earnings report. The tech specialist's share price was up 22.4% as of 2:15 p.m. ET.","fetched_title":"Why BlackBerry Stock Is Skyrocketing Today | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-blackberry-stock-skyrocketing-today","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-blackberry-stock-skyrocketing-today","source_event_id":"evt_7abb8103117a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"df8dc14e0a175cd8","kind":"unusual_volume","published_at":"2026-04-09T15:37:30+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["December 20, 2024","2:15 p.m. ET","Nov. 30","third quarter of its current fiscal year","Q3","Q2"],"entities":[{"asset_class":"equity","name":"BlackBerry","relevance":"high","symbol":"BB","type":"company"},{"asset_class":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"TD Cowen","relevance":"medium","symbol":"","type":"analyst_firm"},{"asset_class":"other","name":"Baird","relevance":"medium","symbol":"","type":"analyst_firm"}],"event_type":"earnings","information_gaps":["The signal type requests an unusual volume delta (volume ratio vs average), but the provided text contains no volume figures, baseline volume, or volume ratio.","The article attributes the price surge to earnings beat/guidance and analyst upgrades, but it does not explicitly confirm whether the volume spike (if any) was unusually high or unexplained.","No specific trading volume metrics (e.g., shares traded, average volume) are provided."],"key_facts":["BlackBerry (NYSE: BB) stock was up 22.4% as of 2:15 p.m. ET on Friday.","The article states BlackBerry reported Q3 earnings after the market closed the prior day.","Non-GAAP (adjusted) earnings were $0.02 per share on sales of $162 million for the period ended Nov. 30.","The article says consensus called for a breakeven quarter on revenue of roughly $143 million.","Sales were down roughly 7.4% year over year in the quarter, but ahead of consensus estimate.","The article states IoT services revenue increased 13% sequentially, and cybersecurity revenue increased 7% compared to Q2.","The article says multiple analyst firms upgraded ratings/price targets after the report: TD Cowen raised from hold to buy and increased a one-year price target from $3.25 to $4; Baird raised its one-year price target from $3 to $3.50 while keeping a neutral rating.","The article states BlackBerry stock was up roughly 42.5% across 2024's trading as of the article time."],"numeric_claims":[{"label":"intraday stock move (as of 2:15 p.m. ET)","value":"up 22.4%"},{"label":"Q3 non-GAAP EPS","value":"$0.02 per share"},{"label":"Q3 sales","value":"$162 million"},{"label":"consensus revenue expectation (breakeven quarter)","value":"roughly $143 million"},{"label":"sales YoY change","value":"down roughly 7.4%"},{"label":"IoT services revenue change (sequential)","value":"up 13%"},{"label":"cybersecurity revenue change (vs Q2)","value":"up 7%"},{"label":"TD Cowen one-year price target","value":"$3.25 -> $4"},{"label":"Baird one-year price target","value":"$3 -> $3.50"},{"label":"stock performance across 2024 trading","value":"up roughly 42.5%"}],"primary_claim":"BlackBerry stock was up 22.4% as of 2:15 p.m. ET on Friday after the company reported Q3 earnings and guidance ahead of market expectations.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"BlackBerry (BB) surged ~22.4% intraday after reporting Q3 results that beat expectations and provided guidance ahead of consensus, followed by analyst rating/price-target upgrades.","topics":["earnings beat","guidance","analyst upgrades","cybersecurity revenue","IoT services revenue","stock surge"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsBlackBerry beat sales and earnings expectations in Q4.","tickers":[],"title":"Why BlackBerry Stock Is Skyrocketing Today","url":"https://www.fool.com/investing/2024/12/20/why-blackberry-stock-is-soaring-today/"}}

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

event_store.db — events

Update row 12000 in events