SQLite Web: event_store.db

Update row sig_3bee177c3981 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/energy-rally-has-cooled-occidental-petroleum-heres-whether-buy-dip","as_of":"2026-04-10T18:51:17.968267+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/the-energy-rally-has-cooled-for-hot-ticker-heres-w/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/energy-rally-has-cooled-occidental-petroleum-heres-whether-buy-dip","article_chars":4365,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9fdad1254aaaab66","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/the-energy-rally-has-cooled-for-hot-ticker-heres-w/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T20:35:57.482057+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsOxy\u2019s stock has pulled back from its 52-week high.","fetched_title":"The Energy Rally Has Cooled for Occidental Petroleum. Here's Whether to Buy the Dip. | Nasdaq","final_url":"https://www.nasdaq.com/articles/energy-rally-has-cooled-occidental-petroleum-heres-whether-buy-dip","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/energy-rally-has-cooled-occidental-petroleum-heres-whether-buy-dip","source_event_id":"evt_44da29750d4f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"71a74f0e122e86c1","kind":"unusual_volume","published_at":"2026-04-10T17:34:49+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["March 31","late February","2025","2026","2022","2023","April 10, 2026"],"entities":[{"asset_class":"equity","name":"Occidental Petroleum","relevance":"high","symbol":"OXY","type":"company"},{"asset_class":"other","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"other","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"commodity","name":"West Texas Intermediate (WTI) crude oil","relevance":"high","symbol":"CL=F","type":"commodity"}],"event_type":"price_action","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided article text does not include any unusual volume metrics (e.g., volume ratio vs average, baseline volume, or direction).","No explicit confirmation is provided that the move is driven by unusual trading volume; the article attributes the pullback to the ceasefire halting the oil rally.","A specific catalyst hypothesis for unusual volume cannot be extracted because volume data is not present in the text."],"key_facts":["OXY hit a 52-week high of $67.45 on March 31.","The article states OXY trades at about $58 as of the time of writing.","The article attributes OXY\u2019s year-to-date gain of nearly 60% to the Iranian conflict starting in late February that pushed oil prices higher.","The article states OXY pulled back because a two-week ceasefire agreement between the U.S. and Iran halted oil\u2019s month-long rally.","The article says OXY generates most revenue from upstream operations (exploration, drilling, extraction).","The article says if oil prices stay above $80 per barrel, OXY should continue generating cash and support growth via Permian Basin production and Gulf of Mexico projects.","The article states analysts expect OXY EPS to grow at a 26% CAGR from 2025 to 2028.","The article states OXY trades at 16 times this year\u2019s earnings and has a forward yield of 1.8%.","The article states insiders have bought more than three times as many shares as they sold over the past 12 months.","The article states Berkshire Hathaway is OXY\u2019s largest institutional investor."],"numeric_claims":[{"label":"52-week high (USD)","value":"67.45"},{"label":"Date of 52-week high","value":"March 31"},{"label":"Current price mentioned (USD)","value":"~58"},{"label":"Year-to-date gain","value":"nearly 60%"},{"label":"Ceasefire duration","value":"two-week"},{"label":"WTI threshold (USD/barrel)","value":"80"},{"label":"EPS growth expectation (CAGR, 2025-2028)","value":"26%"},{"label":"Valuation multiple (times earnings)","value":"16"},{"label":"Forward yield","value":"1.8%"}],"primary_claim":"OXY pulled back from its 52-week high of $67.45 (March 31) to about $58 after a two-week U.S.-Iran ceasefire agreement halted oil\u2019s month-long rally.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"Occidental Petroleum (OXY) has pulled back from its 52-week high after a two-week U.S.-Iran ceasefire halted a month-long oil rally. The article frames the dip as potentially buyable for long-term investors if oil prices remain elevated (e.g., above $80 WTI).","topics":["stock pullback","oil price rally","U.S.-Iran ceasefire","WTI price threshold","Occidental catalysts and risks","valuation and analyst expectations"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsOxy\u2019s stock has pulled back from its 52-week high.","tickers":[],"title":"The Energy Rally Has Cooled for Occidental Petroleum. Here's Whether to Buy the Dip.","url":"https://www.fool.com/investing/2026/04/10/the-energy-rally-has-cooled-for-hot-ticker-heres-w/"}

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