SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-18T17:18:47.705432+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:13aba09a6547b65b","evidence_event_ids":["evt_c95601db4683"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/better-ishares-international-etf-iefa-vs-iemg","as_of":"2026-04-18T17:18:47.705432+00:00","canonical_url":"https://www.fool.com/coverage/etfs/2026/04/18/better-ishares-international-etf-iefa-vs-iemg/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/better-ishares-international-etf-iefa-vs-iemg","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8006346a80f13ebe","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/18/better-ishares-international-etf-iefa-vs-iemg/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T17:49:22.303336+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsIEFA charges a slightly lower expense ratio and offers a higher dividend yield than IEMG.","fetched_title":"Better iShares International ETF: IEFA vs. IEMG | Nasdaq","final_url":"https://www.nasdaq.com/articles/better-ishares-international-etf-iefa-vs-iemg","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/better-ishares-international-etf-iefa-vs-iemg","source_event_id":"evt_c95601db4683","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c2c187c43dd3a206","kind":"unusual_volume","published_at":"2026-04-18T15:42:01+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 18, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity ETF","name":"iShares Core MSCI EAFE ETF","relevance":"high","symbol":"IEFA","type":"etf"},{"asset_class":"equity ETF","name":"iShares Core MSCI Emerging Markets ETF","relevance":"high","symbol":"IEMG","type":"etf"},{"asset_class":"fund/issuer","name":"iShares Trust","relevance":"medium","symbol":"","type":"issuer/brand"}],"event_type":"other","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided article text does not include any volume ratio, baseline volume, or confirmation of unusual trading volume for IEFA or IEMG.","No explicit catalyst for unusual volume is stated; the article is a comparative overview of fees/yield/holdings/performance rather than a volume-driven news event.","The article mentions 'higher dividend yield' and 'stronger one-year return' and 'steeper five-year drawdown' but does not provide the specific numeric values for dividend yield, one-year return, or five-year drawdown in the provided text."],"key_facts":["IEFA expense ratio is 0.07% versus IEMG\u2019s 0.09%.","IEFA is described as offering a higher dividend yield than IEMG.","IEFA holds 2,626 developed-market stocks (excluding the United States and Canada) and has been operating for over thirteen years.","IEFA sector skews toward financial services (23%), industrials (20%), and healthcare (10%).","IEFA leading positions include ASML, HSBC, and AstraZeneca.","IEMG covers 2,725 stocks across emerging markets.","IEMG largest weights are described as basic materials, technology, and financial services.","IEMG top holdings include Taiwan Semiconductor Manufacturing, Samsung Electronics, and SK Hynix.","The article states IEMG has a stronger one-year return but a steeper five-year drawdown.","The article states IEFA has lower max drawdown and is positioned as more stable/reduced risk.","The article frames IEFA as better for conservative, income-focused investors and IEMG as better for growth-oriented investors with higher risk tolerance."],"numeric_claims":[{"label":"IEFA expense ratio","value":"0.07%"},{"label":"IEMG expense ratio","value":"0.09%"},{"label":"IEFA developed-market stock count","value":"2,626"},{"label":"IEMG emerging-market stock count","value":"2,725"},{"label":"IEFA financial services weight","value":"23%"},{"label":"IEFA industrials weight","value":"20%"},{"label":"IEFA healthcare weight","value":"10%"}],"primary_claim":"IEFA has a slightly lower expense ratio (0.07%) and a higher dividend yield than IEMG (0.09% expense ratio), while IEMG has delivered a stronger one-year return but with a steeper five-year drawdown.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article compares iShares Core MSCI EAFE ETF (IEFA) and iShares Core MSCI Emerging Markets ETF (IEMG), noting IEFA\u2019s lower expense ratio and higher dividend yield versus IEMG. It also contrasts developed-markets exposure (IEFA) with emerging-markets exposure (IEMG) and their differing return/risk profiles.","topics":["ETF comparison","expense ratio","dividend yield","developed vs emerging markets","performance and risk","sector/holdings tilt"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsIEFA charges a slightly lower expense ratio and offers a higher dividend yield than IEMG.","tickers":[],"title":"Better iShares International ETF: IEFA vs. IEMG","url":"https://www.fool.com/coverage/etfs/2026/04/18/better-ishares-international-etf-iefa-vs-iemg/"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 216644 in events