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/president-trump-has-set-deadline-reopening-strait-hormuz-heres-how-oil-stocks-are-reacting","as_of":"2026-04-06T18:42:37.816572+00:00","canonical_url":"https://www.fool.com/investing/2026/04/06/president-trump-has-set-a-deadline-for-reopening-t/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/president-trump-has-set-deadline-reopening-strait-hormuz-heres-how-oil-stocks-are-reacting","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1c76b84896d8d956","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/06/president-trump-has-set-a-deadline-for-reopening-t/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T12:48:03.248149+00:00","extraction_method":"heuristic","fetched_description":"Key PointsOil prices have barely budged today after President Trump issued a new deadline to reopen the Strait of Hormuz.","fetched_title":"President Trump Has Set a Deadline for Reopening the Strait of Hormuz. Here's How Oil Stocks are Reacting. | Nasdaq","final_url":"https://www.nasdaq.com/articles/president-trump-has-set-deadline-reopening-strait-hormuz-heres-how-oil-stocks-are-reacting","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/president-trump-has-set-deadline-reopening-strait-hormuz-heres-how-oil-stocks-are-reacting","source_event_id":"evt_7c327944c567","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c3bf4d36cab7a7d9","kind":"unusual_volume","published_at":"2026-04-06T17:30:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 6, 2026","April 7, 2026"],"entities":[{"asset_class":"equity","name":"Chevron","relevance":"high","symbol":"CVX","type":"stock"},{"asset_class":"equity","name":"ExxonMobil","relevance":"high","symbol":"XOM","type":"stock"}],"event_type":"price_action","information_gaps":["Specific volume ratio vs average for CVX and XOM not provided.","No explicit confirmation of unusual volume activity."],"key_facts":["President Trump set a deadline for Iran to reopen the Strait of Hormuz by April 7, 2026.","Chevron's stock was down about 1% on the day of the announcement.","ExxonMobil's shares were marginally higher but down over 5% in the past week."],"numeric_claims":[{"label":"Chevron stock change","value":"-1%"},{"label":"ExxonMobil stock change","value":"marginally higher"}],"primary_claim":"Oil stocks, including Chevron (CVX) and ExxonMobil (XOM), have not reacted significantly to President Trump's deadline regarding the Strait of Hormuz.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"Oil stocks have shown minimal reaction to President Trump's deadline for reopening the Strait of Hormuz, with Chevron and ExxonMobil experiencing slight declines amid market expectations of a ceasefire with Iran.","topics":["oil prices","Strait of Hormuz","Trump deadline","Chevron","ExxonMobil"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsOil prices have barely budged today after President Trump issued a new deadline to reopen the Strait of Hormuz.","tickers":[],"title":"President Trump Has Set a Deadline for Reopening the Strait of Hormuz. Here's How Oil Stocks are Reacting.","url":"https://www.fool.com/investing/2026/04/06/president-trump-has-set-a-deadline-for-reopening-t/"}

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_739625b5cc22 in signals