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/1-etf-could-soar-if-strait-hormuz-stays-open","as_of":"2026-04-18T02:04:28.663448+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/1-etf-that-could-soar-if-the-strait-of-hormuz-stay/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1-etf-could-soar-if-strait-hormuz-stays-open","article_chars":4240,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1b0a88183a0adbad","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/1-etf-that-could-soar-if-the-strait-of-hormuz-stay/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T02:07:16.079730+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsStocks have soared as the Iran conflict takes steps toward a resolution.","fetched_title":"1 ETF That Could Soar If the Strait of Hormuz Stays Open | Nasdaq","final_url":"https://www.nasdaq.com/articles/1-etf-could-soar-if-strait-hormuz-stays-open","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1-etf-could-soar-if-strait-hormuz-stays-open","source_event_id":"evt_fababd65b243","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8c32ef2c6e04e9ed","kind":"unusual_volume","published_at":"2026-04-18T01:06:41+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity_etf","name":"iShares MSCI South Korea ETF","relevance":"high","symbol":"EWY","type":"etf"},{"asset_class":"geopolitical","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_chokepoint"},{"asset_class":"commodity","name":"Brent crude","relevance":"medium","symbol":"BRN","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["Unusual volume delta details are missing: the article does not provide EWY\u2019s volume ratio vs average or any baseline/average volume figures.","The signal asks whether the volume move is confirmed by news or unexplained; the article attributes the move to the Strait reopening/ceasefire news, but it does not explicitly connect this to a specific \u201cunusual volume\u201d metric.","No explicit confirmation of \u201cunusual volume\u201d is provided\u2014only that EWY reached an all-time high on Friday.","No explicit ETF volume numbers (shares traded) are included in the provided text."],"key_facts":["The article states Iran said the Strait of Hormuz was \u201ccompletely open.\u201d","It says this announcement followed news of a 10-day ceasefire agreement between Israel and Lebanon.","The article states oil prices plunged on Friday on the Strait reopening news.","It reports Brent crude down 9.8% to $82.21.","It states the iShares MSCI South Korea ETF (NYSEMKT: EWY) reached an all-time high on Friday.","It says EWY lost more than 20% during the war and then surged back.","It states EWY\u2019s two biggest components are Samsung and SK Hynix (memory-chip producers).","It claims memory chip demand is expected to remain strong at least through 2027 (as stated in the article).","It states EWY was up more than 50% prior to the Iran war.","It states EWY is priced at a price-to-earnings ratio of 20.4 and is \u201csignificantly cheaper\u201d than the S&P 500 (as stated in the article)."],"numeric_claims":[{"label":"Brent crude move","value":"down 9.8% to $82.21"},{"label":"South Korea oil dependence (article claim)","value":"roughly 60%-70% of crude oil through the Strait of Hormuz"},{"label":"EWY drawdown during war (article claim)","value":"lost more than 20%"},{"label":"EWY prior performance (article claim)","value":"up more than 50% prior to the Iran war"},{"label":"EWY valuation (article claim)","value":"P/E ratio 20.4"},{"label":"EWY war-to-recovery context (article claim)","value":"reached an all-time high on Friday"}],"primary_claim":"The iShares MSCI South Korea ETF (EWY) surged to an all-time high on Friday after Iran said the Strait of Hormuz was \u201ccompletely open,\u201d alongside oil prices plunging on the reopening news.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article says stocks rose and oil fell after Iran announced the Strait of Hormuz was \u201ccompletely open,\u201d and it highlights the iShares MSCI South Korea ETF (EWY) reaching an all-time high on the news. It frames the likely catalyst as an Iran-war unwind that eases oil-price pressure on South Korea and supports Korean equities/memory-chip demand.","topics":["Iran conflict","Strait of Hormuz reopening","oil price move","South Korea equities","memory chips","EWY all-time high"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsStocks have soared as the Iran conflict takes steps toward a resolution.","tickers":[],"title":"1 ETF That Could Soar If the Strait of Hormuz Stays Open","url":"https://www.fool.com/investing/2026/04/17/1-etf-that-could-soar-if-the-strait-of-hormuz-stay/"}

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