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-22T01:02:27.838680+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:51dd0423429ecd20","evidence_event_ids":["evt_62a47d6ce7d7"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/trump-just-extended-iran-ceasefire-heres-what-it-means-investors","as_of":"2026-04-22T01:02:27.838680+00:00","canonical_url":"https://www.fool.com/investing/2026/04/21/trump-just-extended-the-iran-ceasefire-heres-what/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/trump-just-extended-iran-ceasefire-heres-what-it-means-investors","article_chars":4941,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7d87072a7e812930","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/21/trump-just-extended-the-iran-ceasefire-heres-what/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T01:03:45.182524+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsAfter the negotiation between the U.S. and Iran was called off, Trump said the ceasefire would be extended.","fetched_title":"Trump Just Extended the Iran Ceasefire. Here's What It Means for Investors | Nasdaq","final_url":"https://www.nasdaq.com/articles/trump-just-extended-iran-ceasefire-heres-what-it-means-investors","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/trump-just-extended-iran-ceasefire-heres-what-it-means-investors","source_event_id":"evt_62a47d6ce7d7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4a21885246048bc8","kind":"unusual_volume","published_at":"2026-04-22T00:25:59+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 21, 2026"],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Iran ceasefire","relevance":"high","symbol":"","type":"event"},{"asset_class":"other","name":"Shehbaz Sharif","relevance":"medium","symbol":"","type":"person"},{"asset_class":"etf","name":"Vanguard S&P 500 ETF","relevance":"medium","symbol":"VOO","type":"fund"},{"asset_class":"etf","name":"Invesco QQQ Trust","relevance":"medium","symbol":"QQQ","type":"fund"},{"asset_class":"etf","name":"State Street Technology Select Sector SPDR ETF","relevance":"medium","symbol":"XLK","type":"fund"},{"asset_class":"etf","name":"iShares Semiconductor ETF","relevance":"medium","symbol":"SOXX","type":"fund"}],"event_type":"geopolitical_risk","information_gaps":["Unusual volume delta metrics are not provided in the text (no volume ratio vs average, no baseline volume, no ticker-specific volume change).","The article does not explicitly confirm whether the after-hours move is tied to unusual trading volume; it only describes price moves.","No specific catalyst is quantified beyond the ceasefire extension; no other volume-related catalysts are stated."],"key_facts":["The article states that after U.S.-Iran negotiations were called off, Trump said the ceasefire would be extended.","Trump is described as saying the ceasefire would continue until Iran submits a unified proposal and discussions are concluded.","The article says Pakistan\u2019s Prime Minister Shehbaz Sharif thanked Trump for accepting Pakistan\u2019s request to extend the ceasefire.","The article reports that in response to Trump\u2019s announcement, stocks moved higher in after-hours trading, with VOO up 0.4% and QQQ up 0.4%.","The article states that the ceasefire announcement has no clear deadline and could carry on indefinitely (as described by the author).","The article says two tech ETFs (XLK and SOXX) posted their 15th straight day of gains."],"numeric_claims":[{"label":"VOO after-hours move","value":"up 0.4%"},{"label":"QQQ after-hours move","value":"up 0.4%"},{"label":"Tech ETFs winning streak","value":"15th straight day"}],"primary_claim":"Trump said he would extend the Iran ceasefire until Iran submits a unified proposal and discussions are concluded, and stocks rose in after-hours trading on the news.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article says President Trump extended the U.S.-Iran ceasefire after negotiations were called off, and markets reportedly reacted positively in after-hours trading. It also notes that tech ETFs have been posting a 15-day winning streak as investors shift attention away from oil-war risk.","topics":["U.S.-Iran ceasefire extension","after-hours stock reaction","investor risk sentiment","oil price/war risk","tech ETF momentum"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsAfter the negotiation between the U.S. and Iran was called off, Trump said the ceasefire would be extended.","tickers":[],"title":"Trump Just Extended the Iran Ceasefire. Here's What It Means for Investors","url":"https://www.fool.com/investing/2026/04/21/trump-just-extended-the-iran-ceasefire-heres-what/"}}

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