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/which-types-investments-should-you-own-and-what-accounts-should-you-own-them","as_of":"2026-04-13T00:26:13.487360+00:00","canonical_url":"https://www.fool.com/investing/2026/04/12/which-types-of-investments-should-you-own-and-in-what-accounts-should-you-own-them/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/which-types-investments-should-you-own-and-what-accounts-should-you-own-them","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1b41302526f8dcf1","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/12/which-types-of-investments-should-you-own-and-in-what-accounts-should-you-own-them/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T05:34:31.473234+00:00","extraction_method":"trafilatura","fetched_description":"In this episode of Motley Fool Money, Motley Fool personal finance expert Robert Brokamp and Motley Fool employee Stephanie Marini discuss:","fetched_title":"Which Types of Investments Should You Own and in What Accounts Should You Own Them | Nasdaq","final_url":"https://www.nasdaq.com/articles/which-types-investments-should-you-own-and-what-accounts-should-you-own-them","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/which-types-investments-should-you-own-and-what-accounts-should-you-own-them","source_event_id":"evt_636b5b3b2767","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"33a1cac7965d006f","kind":"unusual_volume","published_at":"2026-04-12T23:29:59+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.85,"dates_mentioned":["April 12, 2026","April 4, 2026"],"entities":[{"asset_class":"","name":"Motley Fool Money","relevance":"high","symbol":"","type":"program"},{"asset_class":"","name":"Robert Brokamp","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Stephanie Marini","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"fund provider","name":"Vanguard","relevance":"low","symbol":"","type":"company"},{"asset_class":"fund provider","name":"Schwab","relevance":"low","symbol":"","type":"company"},{"asset_class":"fund provider","name":"Fidelity","relevance":"low","symbol":"","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"NASDAQ-100","relevance":"medium","symbol":"","type":"index"}],"event_type":"other","information_gaps":["No ticker symbol is provided.","No trading volume, baseline volume, or volume ratio is provided.","No catalyst or confirmation mechanism for any volume change is described.","The provided text does not mention unusual volume delta or any price/volume event."],"key_facts":["The episode is described as a back-to-basics segment focused on choosing investment types and where to hold them.","The main investment types discussed are index funds, actively managed funds, and individual stocks.","Index funds are described as tracking existing indices such as the S&P 500 and NASDAQ-100.","The text claims index fund fees can be around 0.03% to 0.04% for some major providers (Vanguard, Schwab, Fidelity).","The episode states index funds offer simplicity, broad diversification, and low cost, but are described as \u201cboring\u201d and not expected to beat the market (they match their respective markets).","The episode includes guidance questions for each investment: (1) if you didn\u2019t own it, would you buy it today, and (2) is it in the right account."],"numeric_claims":[{"label":"index fund fee range (percent)","value":"0.03% to 0.04%"}],"primary_claim":"The article/podcast episode discusses investment types and appropriate account placement, and it does not provide any ticker or volume data to support an unusual volume delta signal.","relevance_score":0.05,"sentiment":"neutral","source_quality":"high","summary":"The Motley Fool Money episode is a back-to-basics discussion on which types of investments (index funds, actively managed funds, individual stocks) to own and which account types (taxable brokerage, 401(k), IRA, Roth) they fit best. The provided text contains no information about any specific stock\u2019s trading volume or unusual volume delta.","topics":["index funds vs actively managed funds vs individual stocks","portfolio account selection (taxable brokerage, 401(k), IRA, Roth)","investment simplicity and diversification","fund fees","set-and-forget investing"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"In this episode of Motley Fool Money, Motley Fool personal finance expert Robert Brokamp and Motley Fool employee Stephanie Marini discuss:","tickers":[],"title":"Which Types of Investments Should You Own and in What Accounts Should You Own Them","url":"https://www.fool.com/investing/2026/04/12/which-types-of-investments-should-you-own-and-in-what-accounts-should-you-own-them/"}

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