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-03T13:51:42.389356+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:00ec169364a1f874","evidence_event_ids":["evt_e466d8c51022"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/schwabnetwork/posts/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/1524926262968064/","as_of":"2026-04-03T13:51:42.389356+00:00","canonical_url":"https://www.facebook.com/schwabnetwork/videos/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/911463064979731/","enrichment":{"aggregator_url":"https://www.facebook.com/schwabnetwork/posts/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/1524926262968064/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9ad5daebee74a016","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/schwabnetwork/videos/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/911463064979731/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T01:01:20.339889+00:00","extraction_method":"heuristic","fetched_description":"Insigneo Chief Investment Officer Ahmed Riesgo says \u201cwe are headed down a de\u2011escalatory path\u201d in the Iran war. He suggests that investors who do not...","fetched_title":"Insigneo Chief Investment Officer Ahmed Riesgo says \u201cwe are headed down a de\u2011escalatory path\u201d in the Iran war. He suggests that investors who do not actively follow market headlines should wait for more definitive signs of de-escalation. He doesn\u2019t foresee oil prices returning to pre\u2011war levels anytime soon after surging more than 50% since the end of February. On opportunities in the current environment, he points to rising demand for software companies and a \u201cbooming\u201d space sector. For more ma","final_url":"https://www.facebook.com/schwabnetwork/videos/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/911463064979731/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/schwabnetwork/posts/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/1524926262968064/","source_event_id":"evt_e466d8c51022","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"dab9e9c4f9a9afc8","published_at":"","publisher_domain":"facebook.com","query":"us oil wti 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":"Brent Crude Oil","relevance":"high","symbol":"BRENT","type":"commodity"}],"event_type":"macro_policy","information_gaps":["No specific timeline for expected de-escalation in the Iran conflict.","Lack of detailed data on the software companies and space sector opportunities mentioned."],"key_facts":["Oil prices surged over 50% since the end of February.","Brent crude briefly topped $119\u2013$126 per barrel."],"numeric_claims":[{"label":"Percentage increase in oil prices","value":"50%"},{"label":"Peak Brent crude price","value":"$126"}],"primary_claim":"Brent crude oil prices have risen over 50% since the end of February, reaching a peak of $119\u2013$126 per barrel.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Oil prices have surged over 50% since the end of February due to the Iran conflict, with Brent crude briefly reaching $119\u2013$126 per barrel. Insigneo's CIO suggests waiting for clearer signs of de-escalation before investing.","topics":["oil prices","Iran conflict","investment opportunities"]},"snippet":"Oil prices have surged dramatically: Brent crude has risen over 50% since the conflict began, briefly topping $119\u2013$126 per barrel before easing but remaining ...","source":"web_search","source_domain":"facebook.com","summary":"Oil prices have surged dramatically: Brent crude has risen over 50% since the conflict began, briefly topping $119\u2013$126 per barrel before easing but remaining ...","title":"Schwab Network - Facebook","url":"https://www.facebook.com/schwabnetwork/videos/insigneo-chief-investment-officer-ahmed-riesgo-says-we-are-headed-down-a-deescal/911463064979731/"}}

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