SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNZFU1Ti1LRG5TMkJnWGxFOFJnZWZpcVE2eHBCbG1pNWVLSFJ5YnFadlZUeEY3eFVySFV1a1BHYjhOWllYNzVlWUVhcUVUbXM5MllnTDl0czVHMWVFbUNObFVFZWJOdVpwMHgwT2FudGJyUXpQbFpNTm5RVHU1d0pKcWlkTHRqRkJSLTVydWVubDYzMWxlWkJ2ZTJpRkowRlBROTlkMEJEWmxVa1IwN3ZWMnI5UV9wUGJEQ1NKV0ZoUENYaWVuMlJaXzMxaUE?oc=5","as_of":"2026-04-08T20:43:08.420899+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNZFU1Ti1LRG5TMkJnWGxFOFJnZWZpcVE2eHBCbG1pNWVLSFJ5YnFadlZUeEY3eFVySFV1a1BHYjhOWllYNzVlWUVhcUVUbXM5MllnTDl0czVHMWVFbUNObFVFZWJOdVpwMHgwT2FudGJyUXpQbFpNTm5RVHU1d0pKcWlkTHRqRkJSLTVydWVubDYzMWxlWkJ2ZTJpRkowRlBROTlkMEJEWmxVa1IwN3ZWMnI5UV9wUGJEQ1NKV0ZoUENYaWVuMlJaXzMxaUE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ae705c4aeb8793c4","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:11:31.160811+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNZFU1Ti1LRG5TMkJnWGxFOFJnZWZpcVE2eHBCbG1pNWVLSFJ5YnFadlZUeEY3eFVySFV1a1BHYjhOWllYNzVlWUVhcUVUbXM5MllnTDl0czVHMWVFbUNObFVFZWJOdVpwMHgwT2FudGJyUXpQbFpNTm5RVHU1d0pKcWlkTHRqRkJSLTVydWVubDYzMWxlWkJ2ZTJpRkowRlBROTlkMEJEWmxVa1IwN3ZWMnI5UV9wUGJEQ1NKV0ZoUENYaWVuMlJaXzMxaUE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketwatch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNZFU1Ti1LRG5TMkJnWGxFOFJnZWZpcVE2eHBCbG1pNWVLSFJ5YnFadlZUeEY3eFVySFV1a1BHYjhOWllYNzVlWUVhcUVUbXM5MllnTDl0czVHMWVFbUNObFVFZWJOdVpwMHgwT2FudGJyUXpQbFpNTm5RVHU1d0pKcWlkTHRqRkJSLTVydWVubDYzMWxlWkJ2ZTJpRkowRlBROTlkMEJEWmxVa1IwN3ZWMnI5UV9wUGJEQ1NKV0ZoUENYaWVuMlJaXzMxaUE?oc=5","source_event_id":"evt_6fd70f28e401","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8b321bb2ff37be90","published_at":"2026-04-08T18:59:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Micron","relevance":"high","symbol":"MU","type":"company"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"equities_sector","name":"memory stocks","relevance":"high","symbol":"","type":"sector"}],"event_type":"geopolitical_risk","information_gaps":["No specific percentage/price levels or time window for the \u201csoar\u201d are provided in the supplied text.","No list of \u201cother memory stocks\u201d or their tickers is provided.","No details are provided on the timing of the Iran cease-fire (e.g., when it occurred) beyond the causal framing in the headline.","No direct evidence from the article text is available beyond the provided headline/summary; the full article content was not included in the cleaned text."],"key_facts":["MarketWatch headline states that Micron and other memory stocks \u201csoar.\u201d","The stated reason is that an Iran cease-fire caused attention to refocus on the AI boom."],"numeric_claims":[],"primary_claim":"Micron and other memory stocks soared as an Iran cease-fire refocused attention on the AI boom.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"MarketWatch reports that Micron and other memory stocks rose sharply after an Iran cease-fire shifted investor attention back toward the AI boom.","topics":["AI boom","memory semiconductors","geopolitical cease-fire","market reaction"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"Micron and other memory stocks soar as Iran cease-fire refocuses attention on the AI boom MarketWatch","title":"Micron and other memory stocks soar as Iran cease-fire refocuses attention on the AI boom - MarketWatch","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

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