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-07T15:52:14.382912+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:63b3d53a7fd6c645","evidence_event_ids":["evt_286021e16e69"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran","as_of":"2026-04-07T15:52:14.382912+00:00","canonical_url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0c35c374488e0b54","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T16:21:47.760093+00:00","extraction_method":"heuristic","fetched_description":"All eyes are on this latest deadline ultimatum from President Trump, who has given Iran until this evening to open the Strait of Hormuz.","fetched_title":"Pre-Markets Lower Ahead of Important Day in Iran | Nasdaq","final_url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran","source_event_id":"evt_286021e16e69","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a527f064ff9158d","kind":"options_flow","published_at":"2026-04-07T14:15:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 07, 2026"],"entities":[{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"political","name":"President Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"geopolitical","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"}],"event_type":"macro_policy","information_gaps":["Specific options flow data not provided."],"key_facts":["Dow down -226 points (-0.47%)","S&P 500 down -37 points (-0.56%)","Nasdaq down -181 points (-0.75%)","WTI oil prices up +2.4% to around $115 per barrel"],"numeric_claims":[],"primary_claim":"Pre-markets are lower ahead of a critical deadline set by President Trump for Iran.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Pre-markets are down as tensions rise over Iran's ultimatum regarding the Strait of Hormuz, impacting oil prices and market sentiment.","topics":["market sentiment","oil prices","geopolitical risk"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"All eyes are on this latest deadline ultimatum from President Trump, who has given Iran until this evening to open the Strait of Hormuz.","tickers":[],"title":"Pre-Markets Lower Ahead of Important Day in Iran","url":"https://www.nasdaq.com/articles/pre-markets-lower-ahead-important-day-iran"}}

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