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-03T11:42:42.284122+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:b4b2228c643344bb","evidence_event_ids":["evt_f531825f72c2"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","as_of":"2026-04-03T11:42:42.284122+00:00","canonical_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","enrichment":{"aggregator_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1d07d62fd4c1a6d9","canonical_host":"cryptorank.io","canonical_is_aggregator":false,"canonical_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T00:44:09.029842+00:00","extraction_method":"heuristic","fetched_description":"BitcoinWorld WTI Crude Oil Skyrockets: Trump\u2019s Explosive Iran Remarks Shatter De-escalation Hopes, Price Nears $99 Global oil markets experienced a sharp and","fetched_title":"WTI Crude Oil Skyrockets: Trump\u2019s Explosive Iran Remarks Shatter De-escalation Hopes, Price Nears $99","final_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","html_truncated":true,"paywall_likely":false,"publisher_domain":"cryptorank.io","publisher_resolution":"canonical_url","requested_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","source_event_id":"evt_f531825f72c2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c220e2546626b9df","published_at":"","publisher_domain":"cryptorank.io","query":"brent crude geopolitical risk sanctions production outage catalyst next 14 days","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"energy","name":"WTI Crude Oil","relevance":"high","symbol":"WTI","type":"commodity"},{"asset_class":"energy","name":"Brent Crude Oil","relevance":"high","symbol":"Brent","type":"commodity"},{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"individual"}],"event_type":"price_action","information_gaps":["No specific date for Trump's remarks provided.","Details on the exact geopolitical implications remain unclear."],"key_facts":["WTI crude oil surged by over 3.5%.","Price approached $99 per barrel.","CBOE Crude Oil Volatility Index (OVX) increased by 15%.","Options traders showed increased demand for call options above $105 per barrel."],"numeric_claims":[{"label":"WTI price increase","value":"3.5%"},{"label":"OVX increase","value":"15%"},{"label":"WTI price near","value":"$99"},{"label":"Call options demand above","value":"$105"}],"primary_claim":"WTI crude oil prices increased by over 3.5% following Trump's comments on Iran, reaching nearly $99 per barrel.","relevance_score":0.9,"sentiment":"positive","source_quality":"high","summary":"WTI crude oil prices surged over 3.5% to near $99 per barrel following remarks by former President Trump that dampened hopes for de-escalation with Iran, leading to increased volatility and a reassessment of geopolitical risks in the oil market.","topics":["oil prices","geopolitical risk","Trump Iran remarks"]},"snippet":"BitcoinWorld WTI Crude Oil Skyrockets: Trump's Explosive Iran Remarks Shatter De-escalation Hopes, Price Nears $99 Global oil markets experienced a sharp ...","source":"web_search","source_domain":"cryptorank.io","summary":"BitcoinWorld WTI Crude Oil Skyrockets: Trump's Explosive Iran Remarks Shatter De-escalation Hopes, Price Nears $99 Global oil markets experienced a sharp ...","title":"WTI Crude Oil Skyrockets: Trump's Explosive Iran Remarks Shatter ...","url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments"}}

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