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/3-canadian-ep-stocks-benefiting-tight-oil-market","as_of":"2026-04-09T15:06:58.940339+00:00","canonical_url":"https://www.nasdaq.com/articles/3-canadian-ep-stocks-benefiting-tight-oil-market","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/3-canadian-ep-stocks-benefiting-tight-oil-market","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7412379e337180f9","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/3-canadian-ep-stocks-benefiting-tight-oil-market","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:00:15.535582+00:00","extraction_method":"heuristic","fetched_description":"Following a careful analysis of the Zacks Oil and Gas - Exploration and Production - Canadian industry. we advise focusing on shares of CNQ, BTE and AETUF.","fetched_title":"3 Canadian E&P Stocks Benefiting From a Tight Oil Market | Nasdaq","final_url":"https://www.nasdaq.com/articles/3-canadian-ep-stocks-benefiting-tight-oil-market","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/3-canadian-ep-stocks-benefiting-tight-oil-market","source_event_id":"evt_130294ea12b5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"990753f85d5db0f7","kind":"options_flow","published_at":"2026-04-09T12:57:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2026 \u2014 08:57 am EDT"],"entities":[{"asset_class":"equity","name":"Canadian Natural Resources","relevance":"high","symbol":"CNQ","type":"company"},{"asset_class":"equity","name":"Baytex Energy","relevance":"high","symbol":"BTE","type":"company"},{"asset_class":"equity","name":"ARC Resources","relevance":"high","symbol":"AETUF","type":"company"},{"asset_class":"other","name":"Zacks Oil and Gas - Exploration and Production - Canadian industry","relevance":"medium","symbol":"","type":"industry/sector"}],"event_type":"price_action","information_gaps":["No options flow data (calls vs puts, expiry dates, flow size vs open interest, or open-interest context) is present in the provided text, so options_flow fields cannot be grounded.","The signal type indicates an options-flow delta discovery, but the article content provided is a sector/stock commentary without any explicit options-flow metrics.","No explicit statement is made about whether the positioning is informed; the text only discusses industry fundamentals and market conditions."],"key_facts":["The article states that global supply disruptions have tightened markets, lifting realized prices and boosting cash generation for Canadian producers.","It states that expanding LNG capacity is opening access to global gas markets, improving pricing stability and long-term demand visibility.","It notes risks including price swings and uncertain recovery timelines.","It characterizes oil markets as structurally tight due to low spare capacity and low inventories, supporting a medium-term outlook.","It claims earnings estimates are trending higher and the industry rank places it in the top 40%.","It recommends focusing on CNQ, BTE, and AETUF as standouts with growth and cash flow potential."],"numeric_claims":[],"primary_claim":"Canadian Natural Resources (CNQ), Baytex Energy (BTE), and ARC Resources (AETUF) are presented as compelling opportunities because supply disruptions have tightened oil markets, boosting realized prices and cash generation.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article argues that Canadian E&P stocks (CNQ, BTE, AETUF) may benefit from structurally tight oil markets and supportive realized prices amid global supply disruptions. It also cites LNG capacity expansion as a tailwind for natural gas pricing, while noting risks from volatility and recovery uncertainty.","topics":["tight oil market","supply disruptions","realized prices","cash generation","LNG expansion","volatility","Canadian E&P","earnings estimates trending higher","industry rank momentum"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Following a careful analysis of the Zacks Oil and Gas - Exploration and Production - Canadian industry. we advise focusing on shares of CNQ, BTE and AETUF.","tickers":[],"title":"3 Canadian E&P Stocks Benefiting From a Tight Oil Market","url":"https://www.nasdaq.com/articles/3-canadian-ep-stocks-benefiting-tight-oil-market"}

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