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-03T22:02:10.910615+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:e189b1981bc80bb9","evidence_event_ids":["evt_0016c9187f67"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.instagram.com/p/DWq2e2-Cv_c/","as_of":"2026-04-03T22:02:10.910615+00:00","canonical_url":"https://www.instagram.com/p/DWq2e2-Cv_c/","enrichment":{"aggregator_url":"https://www.instagram.com/p/DWq2e2-Cv_c/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c155e08d06783d86","canonical_host":"instagram.com","canonical_is_aggregator":false,"canonical_url":"https://www.instagram.com/p/DWq2e2-Cv_c/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T01:29:24.584485+00:00","extraction_method":"heuristic","fetched_description":"0 likes, 0 comments - insightpakistan.pk on April 3, 2026: \"Global oil markets witnessed a historic shift as WTI Crude Oil surged to $112 per barrel, overtaking Brent Crude at $107.57 for the first time in over 15 years. Traditionally trading at a discount, WTI\u2019s premium highlights growing supply concerns tied to disruptions in the Strait of Hormuz, a vital corridor for global shipments. Prices jumped more than 10% following strong remarks by Donald Trump toward Iran, further intensifying geopolitical tensions. Market signals, including record backwardation, indicate buyers are paying more for immediate supply, reflecting urgent demand and tightening availability worldwide. #OilPrices #WTI #BrentCrude #GlobalMarkets #StraitOfHormuz #EnergyCrisis #InsightPakistan\".","fetched_title":"Instagram","final_url":"https://www.instagram.com/p/DWq2e2-Cv_c/","html_truncated":true,"paywall_likely":false,"publisher_domain":"instagram.com","publisher_resolution":"canonical_url","requested_url":"https://www.instagram.com/p/DWq2e2-Cv_c/","source_event_id":"evt_0016c9187f67","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e2b90af709db7377","published_at":"","publisher_domain":"instagram.com","query":"brent crude geopolitical risk sanctions production outage catalyst next 14 days","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"energy","name":"WTI Crude Oil","relevance":"high","symbol":"CL","type":"commodity"}],"event_type":"price_action","information_gaps":["Specific price points of WTI Crude Oil before and after the comments are not provided."],"key_facts":["WTI Crude Oil prices surged significantly after Trump's comments.","The price action included one of the largest intraday swings recorded."],"numeric_claims":[],"primary_claim":"WTI Crude Oil prices surged after President Trump's remarks.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"WTI Crude Oil prices experienced significant volatility following comments from US President Donald Trump regarding the United States and Iran.","topics":["oil markets","price volatility","Trump comments"]},"snippet":"Crude oil prices tumbled, posting one of the biggest intraday price swings after US President Donald Trump on Monday claimed that the United States and Iran ...","source":"web_search","source_domain":"instagram.com","summary":"Crude oil prices tumbled, posting one of the biggest intraday price swings after US President Donald Trump on Monday claimed that the United States and Iran ...","title":"Global oil markets witnessed a historic shift as WTI Crude Oil surged ...","url":"https://www.instagram.com/p/DWq2e2-Cv_c/"}}

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