SQLite Web: event_store.db

Update row sig_a75d0b6b7d7e in signals

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/better-dividend-etf-schwabs-schd-vs-vanguards-vig","as_of":"2026-04-22T14:13:37.135360+00:00","canonical_url":"https://www.fool.com/coverage/etfs/2026/04/22/better-dividend-etf-schwab-s-schd-vs-vanguard-s-vig/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/better-dividend-etf-schwabs-schd-vs-vanguards-vig","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c002e133f661d183","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/22/better-dividend-etf-schwab-s-schd-vs-vanguard-s-vig/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T14:14:53.703609+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsSCHD offers a higher dividend yield and slightly less volatility than VIG.","fetched_title":"Better Dividend ETF: Schwab's SCHD vs. Vanguard's VIG | Nasdaq","final_url":"https://www.nasdaq.com/articles/better-dividend-etf-schwabs-schd-vs-vanguards-vig","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/better-dividend-etf-schwabs-schd-vs-vanguards-vig","source_event_id":"evt_78835fe8a21f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0e9f2b283a221a70","kind":"unusual_volume","published_at":"2026-04-22T13:52:01+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 21","April 22, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity_etf","name":"Schwab U.S. Dividend Equity ETF","relevance":"high","symbol":"SCHD","type":"etf"},{"asset_class":"equity_etf","name":"Vanguard Dividend Appreciation ETF","relevance":"high","symbol":"VIG","type":"etf"},{"asset_class":"equity","name":"Texas Instruments","relevance":"medium","symbol":"TXN","type":"stock"},{"asset_class":"equity","name":"UnitedHealth Group","relevance":"medium","symbol":"UNH","type":"stock"},{"asset_class":"equity","name":"Merck","relevance":"medium","symbol":"MRK","type":"stock"},{"asset_class":"equity","name":"Broadcom","relevance":"medium","symbol":"AVGO","type":"stock"},{"asset_class":"equity","name":"Apple","relevance":"medium","symbol":"AAPL","type":"stock"},{"asset_class":"equity","name":"Microsoft","relevance":"medium","symbol":"MSFT","type":"stock"}],"event_type":"other","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided text contains no trading volume, volume ratio vs average, or any confirmation/unexplained volume anomaly details.","No baseline volume or volume ratio is stated for SCHD or VIG.","The article does not explicitly identify a catalyst for any volume change; it is primarily a comparative analysis of dividend yield, volatility, and performance.","The article mentions 'latest data' and 'beta' calculations but does not provide the actual beta/max drawdown values or the exact one-year return figures."],"key_facts":["Both SCHD and VIG are low-cost exchange-traded funds targeting U.S. dividend stocks.","The article states SCHD has a much higher dividend yield than VIG and slightly less volatility (lower beta and max drawdown).","The article states VIG has outperformed SCHD over the past five years in total growth.","The article states both funds delivered near-identical one-year returns.","SCHD sector tilts: consumer defensive (20%), healthcare (19%), energy (17%).","VIG sector tilts: technology (23%), financial services (20%), healthcare (18%).","SCHD holds 104 stocks; VIG holds 338 stocks (as stated in the article).","SCHD tracks the Dow Jones U.S. Dividend 100 Index; VIG tracks a broader basket emphasizing dividend growth history (as described).","The article lists SCHD top holdings as Texas Instruments (TXN), United Health Group (UNH), and Merck (MRK).","The article lists VIG top holdings as Broadcom (AVGO), Apple (AAPL), and Microsoft (MSFT).","The article provides an example claim that Broadcom experienced more than 120% growth over the last 12 months through April 21 (year not explicitly stated)."],"numeric_claims":[{"label":"SCHD dividend yield vs VIG","value":"much higher (no numeric value provided)"},{"label":"SCHD consumer defensive sector weight","value":"20%"},{"label":"SCHD healthcare sector weight","value":"19%"},{"label":"SCHD energy sector weight","value":"17%"},{"label":"VIG technology sector weight","value":"23%"},{"label":"VIG financial services sector weight","value":"20%"},{"label":"VIG healthcare sector weight","value":"18%"},{"label":"SCHD number of stocks","value":"104"},{"label":"VIG number of stocks","value":"338"},{"label":"Broadcom growth example","value":"more than 120% growth over last 12 months through April 21"}],"primary_claim":"SCHD offers a higher dividend yield and slightly less volatility than VIG, while VIG has outperformed SCHD over the past five years in total growth.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article compares two dividend-focused ETFs\u2014Schwab\u2019s SCHD and Vanguard\u2019s VIG\u2014highlighting that SCHD has a higher dividend yield and lower volatility, while VIG has outperformed over five years and has higher growth exposure via technology and financials.","topics":["ETF comparison","dividend yield","volatility/beta","sector tilts","performance over 1-year and 5-year periods","index tracking"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsSCHD offers a higher dividend yield and slightly less volatility than VIG.","tickers":[],"title":"Better Dividend ETF: Schwab's SCHD vs. Vanguard's VIG","url":"https://www.fool.com/coverage/etfs/2026/04/22/better-dividend-etf-schwab-s-schd-vs-vanguard-s-vig/"}

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')

Cancel