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/stocks-rallied-after-president-donald-trumps-ceasefire-iran-heres-how-invest-now","as_of":"2026-04-11T10:38:56.745219+00:00","canonical_url":"https://www.fool.com/investing/2026/04/11/stocks-rallied-after-president-donald-trumps-cease/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/stocks-rallied-after-president-donald-trumps-ceasefire-iran-heres-how-invest-now","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e60d4b0f387b737f","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/11/stocks-rallied-after-president-donald-trumps-cease/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T17:07:21.759614+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe war in Iran has weighed on investors' minds, so the ceasefire was welcome news.","fetched_title":"Stocks Rallied After President Donald Trump's Ceasefire in Iran. Here's How to Invest Now. | Nasdaq","final_url":"https://www.nasdaq.com/articles/stocks-rallied-after-president-donald-trumps-ceasefire-iran-heres-how-invest-now","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/stocks-rallied-after-president-donald-trumps-ceasefire-iran-heres-how-invest-now","source_event_id":"evt_98a6b19c5ade","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0c597a357890fe04","kind":"unusual_volume","published_at":"2026-04-11T09:26:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 8"],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"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":"equity_index","name":"Dow Jones Industrial Average","relevance":"high","symbol":"^DJI","type":"index"},{"asset_class":"equities","name":"Amazon","relevance":"medium","symbol":"AMZN","type":"company"},{"asset_class":"equities","name":"Johnson & Johnson","relevance":"medium","symbol":"JNJ","type":"company"},{"asset_class":"equities","name":"Coca-Cola","relevance":"low","symbol":"KO","type":"company"},{"asset_class":"equities","name":"Nvidia","relevance":"medium","symbol":"NVDA","type":"company"},{"asset_class":"equities","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"geopolitical_risk","information_gaps":["No ticker-specific unusual volume ratio vs average is provided in the text (baseline volume, volume ratio, and direction are not stated).","The signal type requests an unusual volume delta, but the article content provided focuses on index price moves and geopolitical context rather than volume metrics.","The article does not quantify which specific stocks experienced unusual volume; it only discusses general market rally and provides investment examples."],"key_facts":["The article states the war in Iran weighed on investors for weeks and increased uncertainty.","It says Trump announced he would suspend attacks in Iran for a period of two weeks.","It reports that on April 8, the trading session immediately following the news, all three major indexes (S&P 500, Nasdaq Composite, Dow Jones Industrial Average) climbed more than 2.5%.","It states the Dow posted its biggest gain in a year (as described by the article).","The article says geopolitical uncertainty is not over because the U.S. and Iran are involved in negotiations and Trump said U.S. military forces would remain until Iran complies with a \u201creal agreement.\u201d","The article provides investment guidance and mentions examples including AMZN, JNJ, KO, and NVDA (including that NVDA is trading around its lowest in a year and at 21x forward earnings estimates, per the article)."],"numeric_claims":[{"label":"Index move (each)","value":"more than 2.5% (S&P 500, Nasdaq Composite, Dow) on April 8"},{"label":"Ceasefire duration","value":"two weeks"},{"label":"Dow gain","value":"biggest gain in a year (no numeric % provided)"}],"primary_claim":"On April 8 (the trading session after Trump\u2019s announcement), the S&P 500, Nasdaq Composite, and Dow Jones Industrial Average each jumped more than 2.5% following Trump\u2019s stated two-week ceasefire/suspension of attacks in Iran.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"The article says stocks surged after President Trump announced a two-week suspension of attacks in Iran, which the author frames as relief from geopolitical uncertainty. It reports all three major U.S. indexes rose more than 2.5% on April 8, the session immediately after the announcement.","topics":["Iran ceasefire announcement","geopolitical risk","U.S. stock market rally","index performance","investment strategy","AI stocks","Nvidia valuation"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe war in Iran has weighed on investors' minds, so the ceasefire was welcome news.","tickers":[],"title":"Stocks Rallied After President Donald Trump's Ceasefire in Iran. Here's How to Invest Now.","url":"https://www.fool.com/investing/2026/04/11/stocks-rallied-after-president-donald-trumps-cease/"}

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