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-14T17:20:03.235758+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:2f119856b5916ef1","evidence_event_ids":["evt_c7f43f0b395d"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/market-hasnt-crashed-yet-what-ill-be-doing-if-it-does","as_of":"2026-04-14T17:20:03.235758+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/the-market-hasnt-crashed-yet-but-this-is-what-ill/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/market-hasnt-crashed-yet-what-ill-be-doing-if-it-does","article_chars":4406,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_45c5f24b82bfb176","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/the-market-hasnt-crashed-yet-but-this-is-what-ill/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-15T00:48:55.398458+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe S&P 500 has been steady of late, but there are multiple factors that could send it into a tailspin this year.","fetched_title":"The Market Hasn't Crashed Yet, but This Is What I'll Be Doing If It Does | Nasdaq","final_url":"https://www.nasdaq.com/articles/market-hasnt-crashed-yet-what-ill-be-doing-if-it-does","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/market-hasnt-crashed-yet-what-ill-be-doing-if-it-does","source_event_id":"evt_c7f43f0b395d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"021760a9bd855eca","kind":"unusual_volume","published_at":"2026-04-14T16:20:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2020","2022","last year","2026","December 17, 2004","April 15, 2005","April 14, 2026"],"entities":[{"asset_class":"equity_index","name":"S&P 500 Index","relevance":"high","symbol":"^GSPC","type":"index"}],"event_type":"macro_policy","information_gaps":["No unusual trading volume data is provided (no ticker-specific volume ratio vs average, no baseline volume, no direction, and no confirmation of unusual volume).","The signal type is discovery_unusual_volume_delta, but the article content is primarily macro/strategy commentary rather than a volume anomaly report.","No explicit catalyst tied to a specific ticker\u2019s volume spike is stated; only general market risk factors are mentioned."],"key_facts":["The article states the S&P 500 (^GSPC) is up in positive territory and has been steady of late.","The article says earlier in the year the market looked like it might head for a significant decline.","The article lists potential factors that could weigh on markets this year: inflation, international conflicts, and worsening economic conditions.","The article argues markets can change quickly, citing examples from 2020 (rapid fall and recovery), 2022 (crash and slower recovery), and last year (reciprocal tariffs briefly crippling stocks then rebounding).","The article recommends having a watch list of pre-screened stocks with target buy prices to act quickly if the market overreacts to news and a stock tumbles.","The article suggests remaining invested and considers S&P 500 index funds as an alternative to exiting the market entirely."],"numeric_claims":[],"primary_claim":"The S&P 500 (^GSPC) is currently up/positive but the author believes a prolonged tailspin or crash remains possible this year due to multiple macro and geopolitical risks.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The article discusses that the S&P 500 (^GSPC) has been steady but could still experience a significant decline or crash, and suggests being prepared with a watch list of stocks to buy during a downturn.","topics":["market risk","S&P 500 outlook","inflation","international conflicts","economic conditions","tariffs","AI investing theme","watch list strategy"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe S&P 500 has been steady of late, but there are multiple factors that could send it into a tailspin this year.","tickers":[],"title":"The Market Hasn't Crashed Yet, but This Is What I'll Be Doing If It Does","url":"https://www.fool.com/investing/2026/04/14/the-market-hasnt-crashed-yet-but-this-is-what-ill/"}}

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