SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_754064457911 in signals