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/iran-war-didnt-break-market-3-lessons-about-time-market","as_of":"2026-04-18T00:01:35.734361+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/iran-war-didnt-break-market-lessons-time-market/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/iran-war-didnt-break-market-3-lessons-about-time-market","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e0a20c5575944fc4","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/iran-war-didnt-break-market-lessons-time-market/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T00:03:05.652955+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe S&P 500 index lost about 8% from Feb. 27 to March 30, and gained 12% from March 30 to April 17.","fetched_title":"The Iran War Didn't Break the Market -- 3 Lessons About Time in the Market | Nasdaq","final_url":"https://www.nasdaq.com/articles/iran-war-didnt-break-market-3-lessons-about-time-market","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/iran-war-didnt-break-market-3-lessons-about-time-market","source_event_id":"evt_251b713584c5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5d2cc15d086ab723","kind":"unusual_volume","published_at":"2026-04-17T23:08:49+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Feb. 27","Feb. 28","Mar. 30","Apr. 17","Apr. 13","Jan. 1, 1980","Dec. 31, 2024"],"entities":[{"asset_class":"equity_index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"other","name":"Vanguard","relevance":"medium","symbol":"","type":"research_firm"}],"event_type":"price_action","information_gaps":["No ticker is provided because the signal discusses the S&P 500 index, not a specific stock.","No unusual volume ratio vs average is provided in the text; the signal type suggests volume, but the excerpt contains no volume figures.","The article does not provide a confirmed volume-based catalyst; it attributes market volatility to the Iran-war headlines and investor behavior (timing the market), but does not quantify volume changes.","The excerpt does not specify the exact date of the 'Friday' when the S&P 500 closed at a new all-time high."],"key_facts":["The S&P 500 lost about 8% from Feb. 27 to Mar. 30.","The S&P 500 gained about 12% from Mar. 30 to Apr. 17.","The article states Feb. 27 was the last trading day before the Iran war started on Feb. 28 (as described by the article).","The article claims that Vanguard research found 10 of the best 20 S&P 500 days occurred during years with negative total returns, and 11 of the worst 20 days occurred during years with positive total returns (per the article).","The article states that after the March 30 low, the S&P 500 gained more than 12%.","The article states that between Mar. 30 and Apr. 13 the market recovered to its pre-war price level.","The article states that on Friday the S&P 500 closed at a new all-time high (Friday date not explicitly provided in the excerpt)."],"numeric_claims":[{"label":"S&P 500 decline (Feb. 27 to Mar. 30)","value":"~8%"},{"label":"S&P 500 gain (Mar. 30 to Apr. 17)","value":"~12%"}],"primary_claim":"From Feb. 27 to Mar. 30 the S&P 500 lost about 8%, and from Mar. 30 to Apr. 17 it gained about 12%.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article argues that during the Iran-war-related volatility, the S&P 500 fell about 8% from Feb. 27 to Mar. 30 and then rose about 12% from Mar. 30 to Apr. 17, illustrating that trying to time the market is unreliable.","topics":["market timing","time in the market","Iran war","S&P 500 volatility","investor behavior","Vanguard research"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe S&P 500 index lost about 8% from Feb. 27 to March 30, and gained 12% from March 30 to April 17.","tickers":[],"title":"The Iran War Didn't Break the Market -- 3 Lessons About Time in the Market","url":"https://www.fool.com/investing/2026/04/17/iran-war-didnt-break-market-lessons-time-market/"}

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