SQLite Web: event_store.db

Update row sig_0fb4b02c351f in signals

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/why-occidental-petroleum-fell-today","as_of":"2026-04-14T20:20:10.540405+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/why-occidental-petroleum-fell-today/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-occidental-petroleum-fell-today","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_23a4975d11bce875","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/why-occidental-petroleum-fell-today/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-15T17:29:02.444504+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe U.S. imposed a blockade of vessels from Iranian ports through the Strait of Hormuz.","fetched_title":"Why Occidental Petroleum Fell Today | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-occidental-petroleum-fell-today","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-occidental-petroleum-fell-today","source_event_id":"evt_1f2468f5cef6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7c4fe3c6e1796e2c","kind":"unusual_volume","published_at":"2026-04-14T19:06:58+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["Tuesday","end of February","Saturday","later this week","first half of this year"],"entities":[{"asset_class":"equity","name":"Occidental Petroleum","relevance":"high","symbol":"OXY","type":"company"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_location"},{"asset_class":"other","name":"U.S. Central Command (CENTCOM)","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"JD Vance","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"NBC News","relevance":"low","symbol":"","type":"media"},{"asset_class":"other","name":"Reuters","relevance":"low","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["Unusual volume delta details are missing: no volume ratio vs average, no baseline volume, and no direction/confirmation specific to unusual trading volume are provided in the text.","The signal asks whether the volume move is confirmed by news or unexplained; the article discusses price and oil-price drivers but does not provide volume confirmation metrics.","No explicit statement links the unusual volume to a specific catalyst beyond general geopolitical/oil-price impact."],"key_facts":["OXY was down 4.9% as of 1:00 p.m. EDT on Tuesday, per the article.","The article says the U.S. imposed a blockade of vessels from Iranian ports through the Strait of Hormuz.","The article says CENTCOM also allowed some ships from non-Iranian ports to cross the blockade.","The article says CENTCOM ordered six ships from Iranian ports to turn back, and they did.","The article says it was reported that the U.S. and Iran will return to talks later this week.","The article states renewed hopes for a deal to open the Strait sent oil prices tumbling.","The article says oil prices fell about 7.2% today to $91 per barrel as of the time of writing.","The article frames OXY as sensitive to oil prices and as having benefited from Strait of Hormuz closure due to reduced competition access for some Middle East competitors."],"numeric_claims":[{"label":"OXY intraday move","value":"-4.9% (as of 1:00 p.m. EDT)"},{"label":"Oil price move","value":"-7.2% to $91 per barrel (as of time of writing)"}],"primary_claim":"OXY shares fell about 4.9% by 1:00 p.m. EDT as oil prices tumbled on reports that the U.S. and Iran would return to talks later this week and renewed hopes for a deal to open the Strait of Hormuz.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Occidental Petroleum (OXY) fell about 4.9% on Tuesday as oil prices dropped amid renewed hopes for talks to reopen the Strait of Hormuz and reports of U.S. enforcement of a blockade with some exceptions. The article attributes the move to geopolitical developments affecting oil supply risk.","topics":["unusual volume delta","OXY price decline","oil price move","Strait of Hormuz blockade","U.S.-Iran negotiations","CENTCOM enforcement details"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe U.S. imposed a blockade of vessels from Iranian ports through the Strait of Hormuz.","tickers":[],"title":"Why Occidental Petroleum Fell Today","url":"https://www.fool.com/investing/2026/04/14/why-occidental-petroleum-fell-today/"}

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

Cancel