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/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5","as_of":"2026-04-08T20:43:08.008104+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/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_01e24f971b55036a","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:10:27.372200+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNaEtrS096T2NYU2tzMHd3OURYNjlBRERwbzBMOW5zVTJPdDlQTUljWldsamFkVW9mdlBtaE1XTkpvQjBpSWpUd2NCaUpRMml5dDVLemFENlhvR0wyWDdreTRzX3FqVnlhd1lGNENsYVhfVDgtVkpjRENSc1JwVXJocGpURlR0WXRxMGdDZkRfSkMzSnVCalJFblFYcGRLRklHMnhCaGk3Wi05d1k?oc=5","source_event_id":"evt_4dfb07e0ba97","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a516b39181df492e","published_at":"2026-04-08T20:29:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity_index","name":"Dow Jones Industrial Average","relevance":"high","symbol":"^DJI","type":"index"},{"asset_class":"equity_index","name":"S&P 500","relevance":"medium","symbol":"^GSPC","type":"index"},{"asset_class":"equity_index","name":"Nasdaq","relevance":"medium","symbol":"^IXIC","type":"index"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil (global crude)","relevance":"high","symbol":"WTI/Brent (unspecified)","type":"commodity"},{"asset_class":"equity","name":"Chip stock (unspecified)","relevance":"medium","symbol":"","type":"company"}],"event_type":"geopolitical_risk","information_gaps":["The specific chip stock name/ticker is not included in the provided headline/summaries.","The exact timing/date of the market move (which trading session) is not specified in the provided text.","The oil benchmark (WTI vs Brent) is not specified.","The ceasefire details (parties involved, start/end dates, verification status) are not provided beyond \u201ctwo-week ceasefire.\u201d","The magnitude of S&P 500/Nasdaq moves is not quantified in the provided text."],"key_facts":["Dow rallied about 1,300 points on the day (per headline).","The rally was attributed to news of an Iran ceasefire described as lasting two weeks (per provided source summary).","Oil surged past $100/barrel globally due to the Iran conflict (per provided source summary).","S&P 500 and Nasdaq ended closer to record territory on Middle East optimism (per provided source summary).","A chip stock was described as \u201cbreaking out\u201d (company name not present in the provided text)."],"numeric_claims":[{"label":"Dow rally magnitude","value":"~1,300 points"},{"label":"Ceasefire duration","value":"two weeks"},{"label":"Oil price level","value":"> $100/barrel"}],"primary_claim":"The Dow rallied about 1,300 points amid news of a two-week Iran ceasefire, alongside a breakout in a chip stock.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"U.S. equities rose sharply as markets reacted positively to an Iran ceasefire, with oil jumping above $100/barrel. The coverage also highlights a \u201cchip stock\u201d breaking out, suggesting near-term momentum in semiconductors tied to the broader risk-on move.","topics":["Iran ceasefire","Middle East optimism","U.S. stock market rally","Dow/S&P/Nasdaq performance","Oil price surge","Semiconductor breakout (unspecified)"]},"source":"investors.com","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Stock Market Today: Dow Rallies 1,300 Points Amid Iran Ceasefire; This Chip Stock Breaks Out (Live Coverage) investors.com Oil surges past $100/barrel globally due to Iran conflict WWLP Dow logs best day in a year, S&P 500 and Nasdaq end closer to record territory on Middle East optimism MarketWatch Analysts Are Slow to Recognize a Crisis WSJ Stock market today: Dow, S&P 500, Nasdaq futures surge on news of a two-week ceasefire Yahoo Finance","title":"Stock Market Today: Dow Rallies 1,300 Points Amid Iran Ceasefire; This Chip Stock Breaks Out (Live Coverage) - investors.com","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_77ef8534a9d7 in signals