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-18T15:49:14.474663+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:b8d56f8ef1c01378","evidence_event_ids":["evt_22775f7658bd"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/which-better-large-cap-etf-vanguards-mgk-or-state-streets-spy","as_of":"2026-04-18T15:49:14.474663+00:00","canonical_url":"https://www.fool.com/coverage/etfs/2026/04/18/which-is-the-better-large-cap-etf-vanguard-s-mgk-or-state-street-s-spy/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/which-better-large-cap-etf-vanguards-mgk-or-state-streets-spy","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f187b135025a3d41","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/18/which-is-the-better-large-cap-etf-vanguard-s-mgk-or-state-street-s-spy/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T17:15:02.038741+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsMGK has delivered a higher one-year return and comes with a deeper five-year drawdown compared to SPY.","fetched_title":"Which Is the Better Large-Cap ETF, Vanguard's MGK or State Street's SPY? | Nasdaq","final_url":"https://www.nasdaq.com/articles/which-better-large-cap-etf-vanguards-mgk-or-state-streets-spy","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/which-better-large-cap-etf-vanguards-mgk-or-state-streets-spy","source_event_id":"evt_22775f7658bd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"561e450eb23b8c5c","kind":"unusual_volume","published_at":"2026-04-18T14:12:01+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["December 17, 2004","April 15, 2005","April 18, 2026"],"entities":[{"asset_class":"ETF","name":"Vanguard Mega Cap Growth ETF","relevance":"high","symbol":"MGK","type":"fund"},{"asset_class":"ETF","name":"State Street SPDR S&P 500 ETF Trust","relevance":"high","symbol":"SPY","type":"fund"},{"asset_class":"stock","name":"Nvidia","relevance":"medium","symbol":"NVDA","type":"equity"},{"asset_class":"stock","name":"Apple","relevance":"medium","symbol":"AAPL","type":"equity"},{"asset_class":"stock","name":"Microsoft","relevance":"medium","symbol":"MSFT","type":"equity"}],"event_type":"price_action","information_gaps":["The signal type requests unusual volume delta, but the provided text contains no volume ratio, baseline volume, or confirmation/unexplained volume information.","The article does not provide the specific one-year return percentage values for MGK and SPY\u2014only qualitative statements that MGK\u2019s one-year return is higher.","No explicit catalyst for any volume change is stated; the content is a comparative analysis rather than a news-driven event.","catalyst_hypothesis_most_likely_unavailable_due_to_text_only_constraint: The most likely catalyst hypothesis for any 'unusual volume' cannot be determined from the provided text because no volume data or catalyst is mentioned."],"key_facts":["MGK is described as having higher one-year return than SPY.","MGK is described as having a deeper five-year drawdown than SPY.","MGK\u2019s expense ratio is 0.05% versus SPY\u2019s 0.09%.","MGK\u2019s dividend yield is 0.4% versus SPY\u2019s 1.1%.","MGK is described as heavily tilted toward technology/growth; technology accounts for 54% of assets.","MGK is described as holding 69 stocks.","MGK\u2019s top three holdings are Nvidia, Apple, and Microsoft, making up over a third of the fund.","SPY is described as tracking the broad S&P 500 Index and holding over 500 companies.","SPY is described as providing broader sector diversification and being more balanced across sectors.","The article states MGK targets largest growth-oriented names, while SPY offers wide sector exposure."],"numeric_claims":[{"label":"MGK expense ratio","value":"0.05%"},{"label":"SPY expense ratio","value":"0.09%"},{"label":"MGK dividend yield","value":"0.4%"},{"label":"SPY dividend yield","value":"1.1%"},{"label":"MGK number of stocks","value":"69"},{"label":"MGK technology share of assets","value":"54%"},{"label":"MGK top 3 holdings concentration","value":"over a third"},{"label":"SPY number of companies","value":"over 500"}],"primary_claim":"MGK has delivered higher one-year returns than SPY while charging a slightly lower expense ratio, but it has a much lower dividend yield and a heavier technology/growth concentration.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article compares Vanguard Mega Cap Growth ETF (MGK) versus State Street SPDR S&P 500 ETF Trust (SPY), highlighting MGK\u2019s higher recent one-year returns and lower expense ratio but much lower dividend yield and greater tech concentration. It frames the choice as growth/tech tilt (MGK) versus broad diversification and higher yield (SPY).","topics":["ETF comparison","large-cap U.S. equities","mega-cap growth vs S&P 500","expense ratio","dividend yield","sector concentration","technology tilt","portfolio diversification"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsMGK has delivered a higher one-year return and comes with a deeper five-year drawdown compared to SPY.","tickers":[],"title":"Which Is the Better Large-Cap ETF, Vanguard's MGK or State Street's SPY?","url":"https://www.fool.com/coverage/etfs/2026/04/18/which-is-the-better-large-cap-etf-vanguard-s-mgk-or-state-street-s-spy/"}}

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 213407 in events