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/how-geopolitical-tensions-could-impact-your-portfolio-spring","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://www.fool.com/investing/2026/04/22/how-geopolitical-tensions-impact-portfolio-voo/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/how-geopolitical-tensions-could-impact-your-portfolio-spring","article_chars":4018,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b81afad2851f4d9a","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/22/how-geopolitical-tensions-impact-portfolio-voo/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:15:43.053307+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsInvestors need to prepare for the possibility of a recession if the war continues.","fetched_title":"How Geopolitical Tensions Could Impact Your Portfolio This Spring | Nasdaq","final_url":"https://www.nasdaq.com/articles/how-geopolitical-tensions-could-impact-your-portfolio-spring","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/how-geopolitical-tensions-could-impact-your-portfolio-spring","source_event_id":"evt_a39bae846e93","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1e55454919c2e8c6","kind":"unusual_volume","published_at":"2026-04-22T13:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 20","Monday afternoon, April 20","April 22, 2026"],"entities":[{"asset_class":"equity","name":"Taiwan Semiconductor Manufacturing","relevance":"mentioned as having helium reserves that may last only several more months","symbol":"","type":"company"},{"asset_class":"ETF","name":"Vanguard S&P 500 ETF","relevance":"recommended as a core portfolio holding","symbol":"VOO","type":"ETF"}],"event_type":"geopolitical_risk","information_gaps":["No ticker or volume ratio vs average is provided in the supplied text, so the unusual volume delta cannot be quantified.","The signal\u2019s confirmation status (confirmed by news vs unexplained) is not addressed; the article discusses geopolitical impacts rather than reporting a specific volume anomaly.","No explicit catalyst is tied to a specific stock\u2019s trading volume; the only catalyst hypotheses described are macro/supply-chain impacts from the Iran conflict (oil, helium, sulfur)."],"key_facts":["The author writes that as of Monday afternoon, April 20, the U.S. is still at war with Iran and the Strait of Hormuz is still largely closed.","The article states that nearly 20% of the world's oil flows through the Strait of Hormuz and that oil prices have shot up since the war started.","The article claims this could lead to continued high prices at the pump and likely higher airline fares.","The article states the U.S. is already taking a hit from higher prices due to tariffs and suggests this could potentially cause a recession if the conflict continues.","The article states Qatar supplies over 30% of the world's helium and that it is now cut off.","The article claims helium is used in the cooling process to make advanced semiconductor chips (e.g., GPUs).","The article states Taiwan Semiconductor Manufacturing has helium reserves that will only last several more months.","The article states about 50% of sulfur passes through the waterway and that this could cause prices to rise in areas using sulfur (medicines, fertilizers, mining).","The article says the market has been volatile and that stocks move based on headlines about the war\u2019s progress and when it may end.","The article advises long-term investors not to try to trade headlines and to stick to a fundamental plan.","The article recommends using an S&P 500-tracking ETF such as Vanguard S&P 500 ETF (VOO) as a core position and dollar-cost averaging at least once a month.","The article suggests keeping some cash on the sidelines to buy major dips if a recession becomes more likely, but says not to sell core positions or stop dollar-cost averaging."],"numeric_claims":[{"label":"oil flow share through Strait of Hormuz","value":"nearly 20% of the world's oil flows through the strait"},{"label":"helium supply share from Qatar","value":"over 30% of the world's helium"},{"label":"helium reserve duration for TSMC","value":"several more months"},{"label":"sulfur share through the waterway","value":"about 50% of sulfur"}],"primary_claim":"If the war with Iran continues, it is likely to impact investor portfolios by driving higher oil prices and disrupting helium supply used in semiconductor cooling.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article argues that ongoing geopolitical conflict involving Iran could disrupt oil and helium supply chains, raising costs and potentially increasing recession risk. It advises investors to stick to a core long-term strategy rather than trading headlines.","topics":["geopolitical tensions","Iran conflict","Strait of Hormuz","oil prices","airline fares","tariffs","recession risk","helium supply disruption","semiconductor manufacturing","AI infrastructure","investor strategy (core ETF, dollar-cost averaging)"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsInvestors need to prepare for the possibility of a recession if the war continues.","tickers":[],"title":"How Geopolitical Tensions Could Impact Your Portfolio This Spring","url":"https://www.fool.com/investing/2026/04/22/how-geopolitical-tensions-impact-portfolio-voo/"}

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