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-10T07:07:49.121719+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:f3bc1663d93b2208","evidence_event_ids":["evt_ebf77474742f"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/billionaire-bill-gates-has-59-his-foundations-36-billion-portfolio-invested-3-brilliant","as_of":"2026-04-10T07:07:49.121719+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/billionaire-bill-gates-has-59-of-his-foundations-3/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/billionaire-bill-gates-has-59-his-foundations-36-billion-portfolio-invested-3-brilliant","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6fba587197735e14","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/billionaire-bill-gates-has-59-of-his-foundations-3/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T07:08:27.500376+00:00","extraction_method":"heuristic","fetched_description":"Key PointsBill Gates plans to give away practically all of his wealth through his foundation by 2045.","fetched_title":"Billionaire Bill Gates Has 59% of His Foundation's $36 Billion Portfolio Invested in 3 Brilliant Stocks | Nasdaq","final_url":"https://www.nasdaq.com/articles/billionaire-bill-gates-has-59-his-foundations-36-billion-portfolio-invested-3-brilliant","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/billionaire-bill-gates-has-59-his-foundations-36-billion-portfolio-invested-3-brilliant","source_event_id":"evt_ebf77474742f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8805700f83f65f04","kind":"unusual_volume","published_at":"2026-04-10T06:25:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 10, 2026"],"entities":[{"asset_class":"equity","name":"Bill Gates","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Gates Foundation","relevance":"high","symbol":"","type":"organization"},{"asset_class":"equity","name":"Berkshire Hathaway","relevance":"high","symbol":"BRKA/BRKB","type":"company"},{"asset_class":"equity","name":"Waste Management","relevance":"high","symbol":"WM","type":"company"}],"event_type":"other","information_gaps":["No unusual trading volume delta (baseline volume, current volume, or volume ratio vs average) is provided in the provided text.","The third of the \u201ctop three\u201d holdings is not included in the excerpt, so its ticker/weight cannot be extracted.","No explicit catalyst tied to trading volume is described; the article frames the holdings as long-term value selections rather than a near-term trade trigger."],"key_facts":["The article states the foundation trust fund includes a stock portfolio worth about $36 billion as of the article\u2019s writing.","The article states 59% of the portfolio is invested in just three companies.","The article lists Berkshire Hathaway as 25.4% of the portfolio.","The article lists WM (Waste Management) as 18.6% of the portfolio.","The article states Microsoft is not among the top three holdings."],"numeric_claims":[{"label":"Foundation trust portfolio value (USD)","value":"$36 billion"},{"label":"Concentration in top three holdings","value":"59%"},{"label":"Berkshire Hathaway weight","value":"25.4%"},{"label":"WM weight","value":"18.6%"}],"primary_claim":"Gates\u2019 foundation trust portfolio is about $36B, and 59% of it is invested in just three holdings (including Berkshire Hathaway at 25.4% and WM at 18.6%).","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The Motley Fool article says Bill Gates\u2019 foundation trust holds about $36B in a stock portfolio, with 59% concentrated in three holdings: Berkshire Hathaway (25.4%) and Waste Management (18.6%) plus one additional stock not shown in the provided excerpt. The signal does not provide any trading-volume data, so no unusual volume delta can be extracted from this text.","topics":["Gates Foundation portfolio","concentrated holdings","Berkshire Hathaway stake","Waste Management stake","philanthropy trust fund"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsBill Gates plans to give away practically all of his wealth through his foundation by 2045.","tickers":[],"title":"Billionaire Bill Gates Has 59% of His Foundation's $36 Billion Portfolio Invested in 3 Brilliant Stocks","url":"https://www.fool.com/investing/2026/04/10/billionaire-bill-gates-has-59-of-his-foundations-3/"}}

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