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/how-500-month-turns-1-million-generating-40000-passive-income","as_of":"2026-04-20T05:04:04.603819+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/how-500-month-turns-to-million-with-passive-income/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/how-500-month-turns-1-million-generating-40000-passive-income","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_60b8bd881be356b2","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/how-500-month-turns-to-million-with-passive-income/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T05:05:03.371114+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsEven modest monthly investments of a few hundred dollars can turn into significant amounts of money over time.","fetched_title":"How $500 per Month Turns Into $1 Million Generating $40,000 of Passive Income | Nasdaq","final_url":"https://www.nasdaq.com/articles/how-500-month-turns-1-million-generating-40000-passive-income","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/how-500-month-turns-1-million-generating-40000-passive-income","source_event_id":"evt_679c9ee38157","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1c18df953a9eb66e","kind":"unusual_volume","published_at":"2026-04-20T03:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"index","name":"S&P 500","relevance":"used as return assumption example","symbol":"^GSPC","type":"index"},{"asset_class":"ETF","name":"Vanguard 0-3 Month Treasury Bill ETF","relevance":"example for ~3.5%\u20134% yield","symbol":"VBIL","type":"ETF"},{"asset_class":"ETF","name":"Schwab U.S. Dividend Equity ETF","relevance":"example for dividend yield >3%","symbol":"SCHD","type":"ETF"},{"asset_class":"ETF","name":"Vanguard Total Bond Market ETF","relevance":"example for ~4.3% yield","symbol":"BND","type":"ETF"}],"event_type":"other","information_gaps":["No unusual volume delta metrics are provided (no ticker, no baseline volume, no volume ratio, no direction).","The signal type suggests an unusual-volume event, but the article content is not about trading volume; it is about long-term investing and income strategies.","No confirmation mechanism is described for any market/volume anomaly; the text provides no news-driven catalyst for a specific security."],"key_facts":["The article states that $500 per month invested for 30 years at a 10% average annual return could result in a $1.14 million portfolio.","It states that reducing the assumed return to 9% would drop the total to $922,000.","It suggests not assuming higher than a 10% rate of return when planning.","It describes three approaches to turning $1 million into income: using the 4% withdrawal rule, targeting a ~4% annual return while keeping principal intact, or combining both.","It lists examples of income sources: Treasury bills via VBIL yielding 3.5% to 4%, dividend stocks/Schwab dividend ETF SCHD netting north of 3%, and a diversified bond portfolio via BND yielding 4.3% (as stated).","It emphasizes discipline: start saving, keep saving, and leave it invested over time."],"numeric_claims":[{"label":"monthly investment","value":"$500 per month"},{"label":"target portfolio","value":"$1 million (goal) / $1.14 million (example at 10%)"},{"label":"example time horizon","value":"30 years"},{"label":"assumed annual return (example)","value":"10%"},{"label":"alternative annual return (example)","value":"9%"},{"label":"alternative portfolio value","value":"$922,000"},{"label":"passive income target","value":"$40,000 per month or more in passive income (as stated) / ~4% approach implied"},{"label":"Treasury bill ETF yield range","value":"3.5% to 4%"},{"label":"dividend ETF yield","value":"north of 3%"},{"label":"bond ETF yield","value":"4.3%"}],"primary_claim":"Investing $500 per month for decades at ~10% average annual returns could grow to about $1.14 million, which could then support roughly $40,000+ per year of passive income using a ~4% withdrawal/yield approach.","relevance_score":0.12,"sentiment":"neutral","source_quality":"high","summary":"The article is a general personal-finance/portfolio-planning piece describing how saving about $500 per month could grow to roughly $1 million and then generate around $40,000+ in annual passive income using conservative return and withdrawal assumptions. It does not report any specific ticker or unusual trading volume event.","topics":["personal finance","long-term investing","rate of return assumptions","S&P 500 example","4% withdrawal rule","Treasury bills","dividend ETFs","bond ETFs","passive income"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsEven modest monthly investments of a few hundred dollars can turn into significant amounts of money over time.","tickers":[],"title":"How $500 per Month Turns Into $1 Million Generating $40,000 of Passive Income","url":"https://www.fool.com/investing/2026/04/19/how-500-month-turns-to-million-with-passive-income/"}

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