SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/company-news-apr-22-2026","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://www.nasdaq.com/articles/company-news-apr-22-2026","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/company-news-apr-22-2026","article_chars":1064,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d1ad6f1195737d72","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/company-news-apr-22-2026","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:14:28.609908+00:00","extraction_method":"trafilatura","fetched_description":"Companies In The Article Are:AMZN,AAPL,HAL,TSCO","fetched_title":"Company News for Apr 22, 2026 | Nasdaq","final_url":"https://www.nasdaq.com/articles/company-news-apr-22-2026","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/company-news-apr-22-2026","source_event_id":"evt_d713332b68a4","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"e3163c0e485b10d6","kind":"options_flow","published_at":"2026-04-22T12:20:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["Apr 22, 2026","Sept. 1","first-quarter fiscal 2026"],"entities":[{"asset_class":"equity","name":"Amazon.com, Inc.","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Apple Inc.","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Halliburton Company","relevance":"high","symbol":"HAL","type":"company"},{"asset_class":"equity","name":"Tractor Supply Company","relevance":"high","symbol":"TSCO","type":"company"}],"event_type":"other","information_gaps":["Options-flow delta details are not provided in the cleaned article text (no call vs put direction, no expiry dates, no flow size, and no open interest context).","No explicit linkage is provided between the reported stock moves and any options-flow activity.","The signal type indicates options-flow, but the supplied content contains only equity/earnings/management-news statements."],"key_facts":["AMZN shares rose 0.6% after agreeing to invest up to $25 billion in Anthropic as part of an expanded AI infrastructure deal.","AAPL shares fell 2.5% after news that Tim Cook will step down as CEO on Sept. 1.","HAL shares rose 4% after reporting first-quarter fiscal 2026 adjusted earnings of $0.55 per share, beating the Zacks Consensus Estimate of $0.49 per share.","TSCO shares plunged 11.7% after reporting first-quarter fiscal 2026 adjusted earnings of $0.31 per share, missing the Zacks Consensus Estimate of $0.35 per share."],"numeric_claims":[{"label":"AMZN share move","value":"+0.6%"},{"label":"AI investment amount","value":"up to $25 billion"},{"label":"AAPL share move","value":"-2.5%"},{"label":"Tim Cook step-down date","value":"Sept. 1"},{"label":"HAL share move","value":"+4%"},{"label":"HAL adjusted EPS (fiscal 2026 Q1)","value":"$0.55"},{"label":"HAL Zacks consensus EPS","value":"$0.49"},{"label":"TSCO share move","value":"-11.7%"},{"label":"TSCO adjusted EPS (fiscal 2026 Q1)","value":"$0.31"},{"label":"TSCO Zacks consensus EPS","value":"$0.35"}],"primary_claim":"No options-flow (calls/puts, expiry, or size vs open interest) information is present in the provided article text for AMZN, AAPL, HAL, or TSCO.","relevance_score":0.25,"sentiment":"mixed","source_quality":"medium","summary":"The provided article text reports stock moves and company-specific news for AMZN, AAPL, HAL, and TSCO, but it does not include any options-flow details. Therefore, no call/put direction, expiry, or flow size relative to open interest can be extracted from this signal content.","topics":["equities","company news","earnings","AI infrastructure deal","CEO transition"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Companies In The Article Are:AMZN,AAPL,HAL,TSCO","tickers":[],"title":"Company News for Apr 22, 2026","url":"https://www.nasdaq.com/articles/company-news-apr-22-2026"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_c120469aa25a in signals