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-21T00:08:29.826903+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:4ef5830f3bafbefd","evidence_event_ids":["evt_c1636358adf2"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/nervous-about-iran-war-uncertainty-stock-has-been-rock-solid-over-last-two-months","as_of":"2026-04-21T00:08:29.826903+00:00","canonical_url":"https://www.fool.com/investing/2026/04/20/nervous-about-the-iran-war-uncertainty-this-stock/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/nervous-about-iran-war-uncertainty-stock-has-been-rock-solid-over-last-two-months","article_chars":4851,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_863ebd0de16ed377","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/20/nervous-about-the-iran-war-uncertainty-this-stock/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T21:30:46.757471+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsStocks remain volatile as Iran just closed down the Strait of Hormuz again.","fetched_title":"Nervous About the Iran War Uncertainty? This Stock Has Been Rock Solid Over the Last Two Months | Nasdaq","final_url":"https://www.nasdaq.com/articles/nervous-about-iran-war-uncertainty-stock-has-been-rock-solid-over-last-two-months","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/nervous-about-iran-war-uncertainty-stock-has-been-rock-solid-over-last-two-months","source_event_id":"evt_c1636358adf2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dc55d054c6475ae5","kind":"unusual_volume","published_at":"2026-04-20T23:33:12+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["March","April","last two months","first 31 weeks of the fiscal year","April 20, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Costco Wholesale","relevance":"high","symbol":"COST","type":"company"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic_location"},{"asset_class":"other","name":"President Trump","relevance":"low","symbol":"","type":"person"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"^GSPC","type":"index"}],"event_type":"price_action","information_gaps":["No explicit unusual trading-volume data is provided (baseline volume, current volume, and volume ratio vs average are not stated).","The signal type requests a volume ratio vs average and direction; the provided text only discusses price movement/resilience, not volume.","No specific catalyst tied to a volume spike is described; the article\u2019s catalyst narrative is geopolitical uncertainty (Iran closing the Strait of Hormuz again) and Costco\u2019s business model resilience.","No confirmation method is described for the \u201cunusual volume\u201d aspect because volume metrics are absent in the provided text."],"key_facts":["The article states that Iran closed the Strait of Hormuz again, increasing uncertainty around the conflict in the Middle East.","The article claims Costco (NASDAQ: COST) has been nearly unflappable over the last two months.","The article states Costco only fell as much as 4% in March.","The article states the S&P 500 surged past Costco in April.","The article states Costco\u2019s membership model means most profit comes from membership fees and that retention is around 90%.","The article states Costco sells gasoline, which the article says provides a buffer when oil prices spike.","The article states Costco\u2019s customers are described as less sensitive to the general economy due to a higher-income customer base.","The article states most of Costco\u2019s sales come from staples (groceries) rather than discretionary items.","The article states Costco trades at a price-to-earnings ratio of 52, nearly double the S&P 500.","The article states comparable sales adjusted for gas prices and foreign exchange were up 6.4% for the first 31 weeks of the fiscal year."],"numeric_claims":[{"label":"Costco maximum drop in March (percent)","value":"4%"},{"label":"Costco membership retention (percent)","value":"~90%"},{"label":"Costco P/E","value":"52"},{"label":"Comparable sales adjusted for gas/FX up (percent)","value":"6.4%"},{"label":"S&P 500 comparison","value":"S&P 500 surged past Costco in April (no percent given)"}],"primary_claim":"Costco (NASDAQ: COST) has been nearly unflappable over the last two months, with only about a 4% drop in March, despite Iran closing the Strait of Hormuz again and ongoing Middle East uncertainty.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article argues that Costco (NASDAQ: COST) has been unusually resilient over the last two months despite renewed Iran\u2013Middle East conflict uncertainty, including Iran closing the Strait of Hormuz again. It does not provide any explicit unusual trading-volume ratio versus baseline in the provided text.","topics":["Middle East conflict","Iran Strait of Hormuz","market volatility","consumer staples","Costco resilience","oil price sensitivity","membership model"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsStocks remain volatile as Iran just closed down the Strait of Hormuz again.","tickers":[],"title":"Nervous About the Iran War Uncertainty? This Stock Has Been Rock Solid Over the Last Two Months","url":"https://www.fool.com/investing/2026/04/20/nervous-about-the-iran-war-uncertainty-this-stock/"}}

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