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/CBMiuAFBVV95cUxNcG40SDh1R2Y0czhISENvenR3bWRFRUNvYXdVb3lqeXpvN25ZbGpfRjhrS1pfemtqX1BsVkxXNHZPMHB3dzVLSzkydUl0dDl0aDBXY3BqQTdla19zeEZpN1VHZzZzUHlJWE9kMF9WbDZNRVJsRFduZFZDVGE4TG1FMWtFckFXRi1wbzFqVTFwNEl6LWpWdGFZS09IYUE4am9Zc29qNDdYUG9DSUR4ZTJJN3lHcEdxb210?oc=5","as_of":"2026-04-10T13:59:13.731928+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/CBMiuAFBVV95cUxNcG40SDh1R2Y0czhISENvenR3bWRFRUNvYXdVb3lqeXpvN25ZbGpfRjhrS1pfemtqX1BsVkxXNHZPMHB3dzVLSzkydUl0dDl0aDBXY3BqQTdla19zeEZpN1VHZzZzUHlJWE9kMF9WbDZNRVJsRFduZFZDVGE4TG1FMWtFckFXRi1wbzFqVTFwNEl6LWpWdGFZS09IYUE4am9Zc29qNDdYUG9DSUR4ZTJJN3lHcEdxb210?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3bfff5ba2d1e5b8d","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-10T14:04:57.361517+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNcG40SDh1R2Y0czhISENvenR3bWRFRUNvYXdVb3lqeXpvN25ZbGpfRjhrS1pfemtqX1BsVkxXNHZPMHB3dzVLSzkydUl0dDl0aDBXY3BqQTdla19zeEZpN1VHZzZzUHlJWE9kMF9WbDZNRVJsRFduZFZDVGE4TG1FMWtFckFXRi1wbzFqVTFwNEl6LWpWdGFZS09IYUE4am9Zc29qNDdYUG9DSUR4ZTJJN3lHcEdxb210?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/CBMiuAFBVV95cUxNcG40SDh1R2Y0czhISENvenR3bWRFRUNvYXdVb3lqeXpvN25ZbGpfRjhrS1pfemtqX1BsVkxXNHZPMHB3dzVLSzkydUl0dDl0aDBXY3BqQTdla19zeEZpN1VHZzZzUHlJWE9kMF9WbDZNRVJsRFduZFZDVGE4TG1FMWtFckFXRi1wbzFqVTFwNEl6LWpWdGFZS09IYUE4am9Zc29qNDdYUG9DSUR4ZTJJN3lHcEdxb210?oc=5","source_event_id":"evt_51cb7103dfaf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1fba0aac4f2f55dc","published_at":"2026-04-10T12:02:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["April 9, 2026"],"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":"high","symbol":"^GSPC","type":"index"},{"asset_class":"equity_index","name":"Nasdaq Composite","relevance":"high","symbol":"^IXIC","type":"index"},{"asset_class":"equities","name":"TSMC","relevance":"high","symbol":"TSM","type":"company"},{"asset_class":"equities","name":"Nvidia","relevance":"medium","symbol":"NVDA","type":"company"},{"asset_class":"macro","name":"U.S. CPI (inflation data)","relevance":"high","symbol":"","type":"economic_indicator"},{"asset_class":"geopolitical_risk","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geopolitical_location"},{"asset_class":"geopolitical_risk","name":"U.S.-Iran peace talks","relevance":"medium","symbol":"","type":"diplomacy_event"}],"event_type":"macro_policy","information_gaps":["The provided text does not include the magnitude of TSMC\u2019s jump (percent/price) or the exact CPI release time.","\u201cStrait of Hormuz still blocked\u201d is stated in the summary, but the provided excerpt does not specify whether this refers to shipping disruption, enforcement, or a particular incident.","The excerpt does not specify whether the CPI data is expected to be higher/lower than consensus, only that markets were positioned ahead of it.","No explicit causal linkage is provided between TSMC\u2019s move and Nvidia/CPI; only association via \u201cNvidia chipmaker\u201d wording."],"key_facts":["Headline indicates Dow was wavering and index futures were stalling ahead of CPI inflation data.","Headline indicates TSMC (described as an Nvidia chipmaker) was jumping.","Source summary adds that Strait of Hormuz was still blocked ahead of peace talks (uncertainty: exact status/duration not fully specified in provided text).","Source summary also states that U.S. indexes ended higher and oil pared gains on Iran ceasefire optimism (directional market impact)."],"numeric_claims":[],"primary_claim":"Dow and other U.S. index futures were wavering/stalling ahead of CPI inflation data, while TSMC shares jumped.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"U.S. stock index futures were described as stalling ahead of upcoming CPI inflation data, while TSMC (a key Nvidia chipmaker) was reported to be jumping. The broader tape was also influenced by ongoing Strait of Hormuz disruption concerns tied to U.S.-Iran peace talks.","topics":["CPI inflation","U.S. stock index futures","TSMC share move","Nvidia supply chain/semiconductors","Strait of Hormuz disruption risk","U.S.-Iran talks"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Stock Market Today: Dow Wavers Ahead Of CPI Inflation Data; Nvidia Chipmaker TSMC Jumps (Live Coverage) Investor's Business Daily Stock market today: Dow, S&P 500, Nasdaq futures stall with Strait of Hormuz still blocked ahead of peace talks Yahoo Finance US Stocks\u2019 Seven-Day Rally Stalls Ahead of CPI, US-Iran Talks Bloomberg.com Markets News, April 9, 2026: U.S. Indexes End Higher, Oil Pares Gains on Iran Ceasefire Optimism; Dow Turns Positive for Year Investopedia Ceasefire uncorks market relief, but outlook remains sobering Reuters","title":"Stock Market Today: Dow Wavers Ahead Of CPI Inflation Data; Nvidia Chipmaker TSMC Jumps (Live Coverage) - Investor's Business Daily","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_361d94492d1f in signals