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-16T11:16:12.965101+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:03f646192f436984","evidence_event_ids":["evt_890c9463eaf3"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/how-long-does-average-bull-market-last-heres-what-history-says","as_of":"2026-04-16T11:16:12.965101+00:00","canonical_url":"https://www.fool.com/investing/2026/04/16/how-long-does-the-average-bull-market-last-heres-w/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/how-long-does-average-bull-market-last-heres-what-history-says","article_chars":4239,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c962cf78295268e2","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/16/how-long-does-the-average-bull-market-last-heres-w/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-16T11:18:16.241210+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsAside from a few hiccups, the market has remained incredibly resilient in recent years.","fetched_title":"How Long Does the Average Bull Market Last? Here's What History Says. | Nasdaq","final_url":"https://www.nasdaq.com/articles/how-long-does-average-bull-market-last-heres-what-history-says","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/how-long-does-average-bull-market-last-heres-what-history-says","source_event_id":"evt_890c9463eaf3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"558bdb3bfd2753d4","kind":"unusual_volume","published_at":"2026-04-16T10:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["1929","2022","January 2022","mid-October 2022","2026","April 16, 2026"],"entities":[{"asset_class":"equity_index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"institution","name":"Federal Reserve Bank of St. Louis","relevance":"medium","symbol":"","type":"institution"},{"asset_class":"institution","name":"Bespoke Investment Group","relevance":"medium","symbol":"","type":"institution"},{"asset_class":"geopolitical","name":"Iran","relevance":"low","symbol":"","type":"country"}],"event_type":"macro_policy","information_gaps":["No unusual trading volume ratio vs average is provided in the provided text (baseline volume, volume ratio, and ticker are missing).","No specific catalyst for unusual volume is described; the article focuses on historical market cycle durations and oil-price/recession context rather than volume anomalies.","The signal type indicates unusual volume delta, but the excerpt contains no volume-related metrics to confirm or quantify it."],"key_facts":["Bull markets tend to last far longer than bear markets.","Since 1929, the average S&P 500 bear market lasted about 286 days (~9.5 months), per Bespoke Investment Group.","The average S&P 500 bull market lasted over 1,000 days, amounting to just under three years.","The most recent U.S. bear market was in 2022, spurred by runaway inflation; it began in January and the S&P 500 bottomed out in mid-October.","The current bull market has lasted close to 1,300 days (~3.5 years).","The article states that history provides context but cannot predict the future.","The article suggests bull markets have trended longer in recent decades, citing a bull market from the end of the Great Recession to early 2020 lasting 11 years and another from 2002 to late 2007 lasting close to 2,000 days.","The article states that an increase in oil prices correlates with recession historically and cites a Federal Reserve Bank of St. Louis statement that nearly all post-World War II recessions were preceded by higher oil prices.","The article says it does not mean a recession or bear market is imminent and suggests that if world leaders agree on a resolution in Iran, oil prices may decrease, reducing downturn risk.","The article recommends diversification and dollar-cost averaging as ways to reduce risk when a recession or bear market occurs."],"numeric_claims":[{"label":"Average S&P 500 bear market duration since 1929","value":"286 days (~9.5 months)"},{"label":"Average S&P 500 bull market duration","value":"over 1,000 days (just under three years)"},{"label":"Current bull market duration","value":"close to 1,300 days (~3.5 years)"},{"label":"Bull market after Great Recession to early 2020","value":"11 years"},{"label":"Bull market from 2002 to late 2007","value":"close to 2,000 days"}],"primary_claim":"The current U.S. bull market has lasted close to 1,300 days (~3.5 years), which is longer than the historical average bull market duration of just under three years.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"The article discusses historical average durations of S&P 500 bull and bear markets, noting the current bull market has already lasted longer than the historical average. It argues this does not imply a recession is imminent and suggests long-term, diversified investing approaches.","topics":["bull market duration","bear market duration","S&P 500 history","oil prices and recession correlation","diversification","dollar-cost averaging","recession timing uncertainty"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsAside from a few hiccups, the market has remained incredibly resilient in recent years.","tickers":[],"title":"How Long Does the Average Bull Market Last? Here's What History Says.","url":"https://www.fool.com/investing/2026/04/16/how-long-does-the-average-bull-market-last-heres-w/"}}

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