SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum","as_of":"2026-04-06T17:13:11.811157+00:00","canonical_url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6f925a97f7d0e3c0","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T17:42:34.115089+00:00","extraction_method":"heuristic","fetched_description":"Pre-market futures are off early-morning highs at this hour, but mildly mixed.","fetched_title":"Pre-Markets Mixed Post-BLS Jobs, Pre-Iran Ultimatum | Nasdaq","final_url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum","source_event_id":"evt_8928a5d314f5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5abc58a2acd94fba","kind":"options_flow","published_at":"2026-04-06T14:21:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 6, 2026"],"entities":[{"asset_class":"","name":"U.S. Bureau of Labor Statistics","relevance":"source of employment data","symbol":"","type":"government"},{"asset_class":"energy","name":"WTI Crude Oil","relevance":"current price context","symbol":"CL","type":"commodity"},{"asset_class":"energy","name":"Brent Crude Oil","relevance":"current price context","symbol":"BZ","type":"commodity"}],"event_type":"macro_policy","information_gaps":["No specific options flow data provided (calls vs puts, size, expiry).","No details on informed positioning or open interest context."],"key_facts":["U.S. added +178K jobs in March, significantly above expectations of +60K.","Unemployment rate decreased to 4.3%.","WTI oil prices are around $110 per barrel."],"numeric_claims":[{"label":"Dow change","value":"-64 points, -0.14%"},{"label":"S&P 500 change","value":"+4 points, +0.08%"},{"label":"Nasdaq change","value":"+95 points, +0.39%"}],"primary_claim":"Pre-market futures are mixed, with the Dow down 0.14% and the Nasdaq up 0.39%.","relevance_score":0.7,"sentiment":"mixed","source_quality":"high","summary":"Pre-market futures are mixed following a strong jobs report, with significant geopolitical tensions affecting market sentiment.","topics":["employment","oil prices","market sentiment"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Pre-market futures are off early-morning highs at this hour, but mildly mixed.","tickers":[],"title":"Pre-Markets Mixed Post-BLS Jobs, Pre-Iran Ultimatum","url":"https://www.nasdaq.com/articles/pre-markets-mixed-post-bls-jobs-pre-iran-ultimatum"}

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_81f928ded8bd in signals