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/swiss-market-ends-modestly-higher-0","as_of":"2026-04-09T19:34:12.195303+00:00","canonical_url":"https://www.nasdaq.com/articles/swiss-market-ends-modestly-higher-0","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/swiss-market-ends-modestly-higher-0","article_chars":2433,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_12907a7d2c2b1681","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/swiss-market-ends-modestly-higher-0","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:45:19.183982+00:00","extraction_method":"heuristic","fetched_description":"(RTTNews) - After a firm start and a subsequent move up north amid hopes for a peace deal in Ukraine, the Switzerland stock market began paring gains Monday afternoon, but still managed to close modestly higher.","fetched_title":"Swiss Market Ends Modestly Higher | Nasdaq","final_url":"https://www.nasdaq.com/articles/swiss-market-ends-modestly-higher-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/swiss-market-ends-modestly-higher-0","source_event_id":"evt_f4c95f46a229","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"45cfa8e1748db136","kind":"unusual_volume","published_at":"2026-04-09T17:57:07+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["March 28, 2022"],"entities":[{"asset_class":"equity_index","name":"Swiss Market Index (SMI)","relevance":"high","symbol":"","type":"index"},{"asset_class":"equity","name":"Alcon","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Richemont","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Credit Suisse","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"ABB","relevance":"medium","symbol":"","type":"company"}],"event_type":"macro_policy","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided text contains no ticker-level or market-level volume data, no volume ratio vs average, and no unusual-volume confirmation details.","No specific ticker is identified for the unusual volume event; the article is index/market performance focused.","No explicit catalyst is stated in the context of unusual volume; only general sentiment drivers (COVID-19 Shanghai lockdown measures; geopolitical mentions) are provided."],"key_facts":["The SMI climbed to a high of 12,264.93 around mid afternoon.","The SMI closed with a gain of 34.28 points or 0.28% at 12,155.95.","The market began negative earlier in the session and later moved up, but gains were pared before the close.","Sentiment was weighed by reports of a surge in COVID-19 cases in Shanghai and imposition of fresh lockdown measures.","The article also mentions hopes for a peace deal in Ukraine and that early doubts about a U.S.-Iran truce weighed on sentiment."],"numeric_claims":[{"label":"SMI intraday high","value":"12,264.93"},{"label":"SMI close","value":"12,155.95"},{"label":"SMI point gain","value":"34.28"},{"label":"SMI percent gain","value":"0.28%"}],"primary_claim":"The Swiss benchmark SMI closed up 0.28% at 12,155.95 after trading near a mid-afternoon high of 12,264.93.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article reports that Switzerland\u2019s stock market (SMI) ended modestly higher after paring gains, with sentiment weighed by doubts tied to geopolitical tensions and reports of rising COVID-19 cases in Shanghai and new lockdown measures.","topics":["Switzerland equities","SMI index close","market sentiment","COVID-19 Shanghai lockdown measures","geopolitical risk (Ukraine peace hopes mentioned)"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"(RTTNews) - Save for a brief while early on in the session and a few minutes before the closing bell, the Switzerland market remained in negative territory on Thursday as doubts about U.S.-Iran truce weighed on sentiment.","tickers":[],"title":"Swiss Market Ends Modestly Higher","url":"https://www.nasdaq.com/articles/swiss-market-ends-modestly-higher-0"}

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