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-06T21:04:57.701497+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:6661b527584ab7a9","evidence_event_ids":["evt_51c6209e9189"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/","as_of":"2026-04-06T21:04:57.701497+00:00","canonical_url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/","enrichment":{"aggregator_url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/","article_chars":3167,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4511de8c8b33d07a","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T15:48:58.266223+00:00","extraction_method":"heuristic","fetched_description":"U.S. stocks rose Monday as Iran ceasefire talks eased fears, but Trump's Tuesday deadline and $112 oil kept markets cautious.","fetched_title":"Major US Indexes Gain Monday as Iran Ceasefire Talks Ease Market Fears \u2013 Market Updates Bitcoin News","final_url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/","source_event_id":"evt_51c6209e9189","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4539ef6882918069","kind":"crypto_extremes","published_at":"2026-04-06T20:28:01+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-06"],"entities":[{"asset_class":"equity","name":"S&P 500","relevance":"high","symbol":"SPX","type":"index"},{"asset_class":"commodity","name":"West Texas Intermediate","relevance":"high","symbol":"CL=F","type":"commodity"},{"asset_class":"commodity","name":"Brent Crude","relevance":"high","symbol":"BZ=F","type":"commodity"}],"event_type":"price_action","information_gaps":["Details on the specific outcomes of the ceasefire talks are unclear.","The exact implications of Trump's deadline for Iran are not fully detailed."],"key_facts":["S&P 500 gained 0.4% on Monday.","S&P 500 is 4% below pre-conflict levels.","West Texas Intermediate crude settled near $103 a barrel.","Dow Jones Industrial Average climbed 137 points, or 0.3%.","Nasdaq Composite added 0.5%.","CBOE Volatility Index held above 24."],"numeric_claims":[{"label":"S&P 500 gain","value":"0.4%"},{"label":"S&P 500 below pre-conflict levels","value":"4%"},{"label":"West Texas Intermediate crude price","value":"$103"},{"label":"Dow Jones Industrial Average gain","value":"137 points"},{"label":"Nasdaq Composite gain","value":"0.5%"}],"primary_claim":"The S&P 500 gained 0.4% on Monday but remains 4% below pre-conflict levels.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"U.S. stocks gained modestly on Monday amid ceasefire talks regarding Iran, with the S&P 500 up 0.4% but still 4% below pre-conflict levels. Oil prices remained elevated near $103 a barrel as tensions persist.","topics":["U.S. stocks","Iran ceasefire talks","oil prices","market reaction"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"U.S. stocks posted modest gains Monday as investors tracked ceasefire talks in the Middle East and waited on President Donald Trump\u2019s Tuesday deadline for Iran to reopen the Strait of Hormuz. Key Takeaways: The S&P 500 gained 0.4% Monday but remains 4% below pre-conflict levels as Iran tensions persist. Trump\u2019s Tuesday deadline for Iran to [\u2026]","tickers":[],"title":"Major US Indexes Gain Monday as Iran Ceasefire Talks Ease Market Fears","url":"https://news.bitcoin.com/major-us-indexes-gain-monday-as-iran-ceasefire-talks-ease-market-fears/"}}

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