Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
attention_candidates
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_narrative_members
intel_narratives
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 480065 in events
seq
Primary key.
INTEGER
id
evt_afed8e8fb542
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-22T09:10:06.597183+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-22T09:08:08.862046+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:108fbeb5d9bd9459","evidence_event_ids":["evt_e9012531d9dc"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/sp-500-and-nasdaq-composite-just-made-history-time-be-fearful-when-others-are-greedy-has","as_of":"2026-04-22T09:08:08.862046+00:00","canonical_url":"https://www.fool.com/investing/2026/04/22/sp-500-nasdaq-history-fearful-when-others-greedy/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/sp-500-and-nasdaq-composite-just-made-history-time-be-fearful-when-others-are-greedy-has","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2b8f1b61adcd3b99","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/22/sp-500-nasdaq-history-fearful-when-others-greedy/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T09:10:06.597125+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe benchmark S&P 500 and tech-driven Nasdaq Composite just reached all-time highs, with the Nasdaq enjoying its longest winning streak of the century.","fetched_title":"The S&P 500 and Nasdaq Composite Just Made History -- the Time to Be Fearful When Others Are Greedy Has Arrived | Nasdaq","final_url":"https://www.nasdaq.com/articles/sp-500-and-nasdaq-composite-just-made-history-time-be-fearful-when-others-are-greedy-has","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/sp-500-and-nasdaq-composite-just-made-history-time-be-fearful-when-others-are-greedy-has","source_event_id":"evt_e9012531d9dc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"27b98a59aae4173e","kind":"unusual_volume","published_at":"2026-04-22T08:26:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["March 27","March 30","April 17","Oct. 1, 2022","Dec. 31, 2025","January 1871","December 28, 2025","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity_index","name":"S&P 500 Index","relevance":"high","symbol":"^GSPC","type":"index"},{"asset_class":"equity_index","name":"Nasdaq Composite","relevance":"high","symbol":"^IXIC","type":"index"},{"asset_class":"equity_index","name":"Dow Jones Industrial Average","relevance":"medium","symbol":"^DJI","type":"index"},{"asset_class":"equities","name":"Berkshire Hathaway","relevance":"medium","symbol":"BRKA/BRKB","type":"company"},{"asset_class":"person","name":"Warren Buffett","relevance":"medium","symbol":"","type":"person"},{"asset_class":"equities","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equities","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"price_action","information_gaps":["No unusual trading volume delta/volume ratio vs average is provided for any ticker (baseline_volume, volume_ratio, direction, and ticker are not present).","The signal type requested (discovery_unusual_volume_delta) is not directly supported by the provided text; the article focuses on price action and valuation rather than volume anomalies.","Catalyst hypothesis for unusual volume is not specified; the article instead offers catalysts for the rally (Iran war end prospects and AI growth).","The article does not state whether the record-high move is confirmed by independent news sources; it is presented as the article\u2019s own market observation."],"key_facts":["The article states that on April 17, both the S&P 500 and Nasdaq Composite closed at record highs.","The article states the Nasdaq Composite had a 13 consecutive trading-day winning streak as of the article\u2019s writing.","The article contrasts prior weakness: it says the Dow entered correction territory on March 27 (peak-to-trough decline just over 10%).","The article states that on March 30, the Nasdaq Composite peaked at 13% below its all-time closing high.","The article states the S&P 500 was one modest down day away from official correction territory at that time (per the article).","The article attributes the recent rally to prospects of a swift end to the Iran war and to AI infrastructure/application growth prospects.","The article claims the S&P 500 Shiller CAPE ratio began 2026 at the second-priciest valuation since January 1871.","The article states the average Shiller P/E over the last 155 years is approximately 17.4.","The article states the Shiller CAPE ratio has oscillated between 39 and 41 for much of the last seven months.","The article claims that when back-tested to 1871, the CAPE ratio exceeded 30 during a continuous bull market on six occasions, including the present.","The article claims the previous five instances were followed by declines of at least 20% in the Dow Jones Industrial Average, S&P 500, and/or Nasdaq Composite.","The article states Buffett was a net seller of equities for 13 consecutive quarters leading up to his retirement (Oct. 1, 2022 \u2013 Dec. 31, 2025) and that Berkshire sold approximately $187 billion more in stocks than were purchased during this period."],"numeric_claims":[{"label":"Nasdaq winning streak length (trading days)","value":"13"},{"label":"Dow correction peak-to-trough decline","value":"just over 10%"},{"label":"Nasdaq distance from all-time closing high (percent)","value":"13% below"},{"label":"Shiller CAPE average over last 155 years","value":"~17.4"},{"label":"Shiller CAPE range for much of last seven months","value":"39 to 41"},{"label":"CAPE ratio second-priciest valuation since","value":"January 1871"},{"label":"CAPE ratio exceeded 30 during continuous bull market (count)","value":"6 occasions"},{"label":"Minimum subsequent decline in prior instances","value":"at least 20%"},{"label":"Buffett net seller period length (quarters)","value":"13"},{"label":"Net selling amount (stocks)","value":"~$187 billion more sold than purchased"}],"primary_claim":"As of April 17, the S&P 500 and Nasdaq Composite closed at record highs, with the Nasdaq logging a 13-consecutive trading-day winning streak, while the market is described as historically pricey based on Shiller CAPE valuation.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article claims the S&P 500 and Nasdaq Composite reached record highs, with the Nasdaq posting a 13-day winning streak, and argues that valuation is historically expensive, implying investors should be fearful. It does not provide any unusual trading volume ratio data for a specific ticker.","topics":["market highs","Nasdaq winning streak","S&P 500 valuation","Shiller CAPE ratio","Buffett selling","risk sentiment","Iran war end prospects","AI infrastructure/applications growth"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe benchmark S&P 500 and tech-driven Nasdaq Composite just reached all-time highs, with the Nasdaq enjoying its longest winning streak of the century.","tickers":[],"title":"The S&P 500 and Nasdaq Composite Just Made History -- the Time to Be Fearful When Others Are Greedy Has Arrived","url":"https://www.fool.com/investing/2026/04/22/sp-500-nasdaq-history-fearful-when-others-greedy/"}}
TEXT NOT NULL
source_ref
candidate:sc_2b8f1b61adcd3b99
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:108fbeb5d9bd9459
TEXT
episode_id
NULL
TEXT
created_at
2026-04-22T09:10:06.597232+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel