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-09T00:13:45.001978+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:05fa7ba6a381fda8","evidence_event_ids":["evt_ab2cb83b8120"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/cybersecurity-stock-buy-right-now","as_of":"2026-04-09T00:13:45.001978+00:00","canonical_url":"https://www.fool.com/investing/2026/04/08/is-this-cybersecurity-stock-a-buy-right-now/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/cybersecurity-stock-buy-right-now","article_chars":3308,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4a9a4bbeb3da58dd","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/08/is-this-cybersecurity-stock-a-buy-right-now/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:34:19.347448+00:00","extraction_method":"heuristic","fetched_description":"Cybersecurity stocks have been under pressure in recent weeks.","fetched_title":"Is This Cybersecurity Stock a Buy Right Now? | Nasdaq","final_url":"https://www.nasdaq.com/articles/cybersecurity-stock-buy-right-now","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/cybersecurity-stock-buy-right-now","source_event_id":"evt_ab2cb83b8120","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bcd4ff176781aa5f","kind":"unusual_volume","published_at":"2026-04-08T23:22:20+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 08, 2026","April 4, 2026","December 17, 2004","April 15, 2005","April 8, 2026"],"entities":[{"asset_class":"equity","name":"Fortinet","relevance":"high","symbol":"FTNT","type":"company"},{"asset_class":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No unusual volume delta data is provided (no volume ratio vs average, no baseline volume, no direction, and no ticker-specific volume figures).","The signal type indicates unusual volume, but the cleaned article text does not contain any confirmation or explanation tied to volume changes.","No explicit catalyst for any volume change is stated in the provided text; only general commentary about cybersecurity stocks being under pressure and promotional content about Stock Advisor lists."],"key_facts":["The article is titled \u201cIs This Cybersecurity Stock a Buy Right Now?\u201d and is dated April 08, 2026 (07:22 pm EDT).","The text says cybersecurity stocks have been under pressure in recent weeks.","The article specifically asks whether you should buy stock in Fortinet right now.","The text says Fortinet wasn\u2019t included in The Motley Fool Stock Advisor analyst team\u2019s \u201c10 best stocks\u201d list.","The text includes a disclosure that The Motley Fool has positions in and recommends Fortinet."],"numeric_claims":[],"primary_claim":"The article states that cybersecurity stocks have been under pressure in recent weeks and frames a question about buying Fortinet (FTNT).","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The provided article text discusses that cybersecurity stocks have been under pressure and asks whether Fortinet (FTNT) is a buy, but it does not provide any unusual trading volume metrics.","topics":["cybersecurity stocks","Fortinet","stock recommendation","market pressure"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Cybersecurity stocks have been under pressure in recent weeks.","tickers":[],"title":"Is This Cybersecurity Stock a Buy Right Now?","url":"https://www.fool.com/investing/2026/04/08/is-this-cybersecurity-stock-a-buy-right-now/"}}

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 10235 in events