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/why-conocophillips-stock-rocketed-more-16-march","as_of":"2026-04-07T12:52:53.052514+00:00","canonical_url":"https://www.fool.com/investing/2026/04/07/why-conocophillips-stock-rocketed-more-than-16-in/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-conocophillips-stock-rocketed-more-16-march","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cd2c5b00bad9dd5c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/07/why-conocophillips-stock-rocketed-more-than-16-in/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T20:03:14.289150+00:00","extraction_method":"heuristic","fetched_description":"Key PointsOil had its best month since the pandemic.","fetched_title":"Why ConocoPhillips Stock Rocketed More Than 16% in March | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-conocophillips-stock-rocketed-more-16-march","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-conocophillips-stock-rocketed-more-16-march","source_event_id":"evt_8f7859c4904d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9729073e2186ff7a","kind":"unusual_volume","published_at":"2026-04-07T11:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["March 2026"],"entities":[{"asset_class":"equity","name":"ConocoPhillips","relevance":"high","symbol":"COP","type":"company"}],"event_type":"price_action","information_gaps":["Exact volume ratio vs average volume for ConocoPhillips not provided.","Baseline volume data is missing."],"key_facts":["Brent oil prices rose 43% in March to nearly $104 per barrel.","WTI prices surged 51% in March.","The war with Iran was identified as a catalyst for rising oil prices."],"numeric_claims":[{"label":"March stock increase","value":"16.3%"},{"label":"Brent oil price increase","value":"43%"},{"label":"WTI oil price increase","value":"51%"}],"primary_claim":"ConocoPhillips shares increased by 16.3% in March 2026.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"ConocoPhillips stock surged 16.3% in March, driven by a significant increase in crude oil prices due to geopolitical tensions, particularly the war with Iran.","topics":["oil prices","geopolitical risk","earnings"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsOil had its best month since the pandemic.","tickers":[],"title":"Why ConocoPhillips Stock Rocketed More Than 16% in March","url":"https://www.fool.com/investing/2026/04/07/why-conocophillips-stock-rocketed-more-than-16-in/"}

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