Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 1492 in events
seq
Primary key.
INTEGER
id
evt_0136d80fae29
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-03T11:42:42.284122+00:00
TEXT NOT NULL
actor
collector:opportunity_research
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-03T11:42:42.284122+00:00","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":{"as_of":"2026-04-03T11:42:42.284122+00:00","bucket":"2026-04-03T11:00Z","items":[{"fp":"7444f34f8ab262a9","provider":"serper","published_at":"2026-04-03T11:42:42.284122+00:00","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","snippet":"WTI Crude Oil surges more than 8% on Thursday, rebounding after a two-day decline. Middle East tensions keep supply disruptions through the Strait of Hormuz in ...","source":"web_search","source_url":"https://www.mitrade.com/au/insights/news/live-news/article-2-1605697-20260403","summary":"WTI Crude Oil surges more than 8% on Thursday, rebounding after a two-day decline. Middle East tensions keep supply disruptions through the Strait of Hormuz in ...","title":"WTI rallies as Trump signals continued military action against Iran","url":"https://www.mitrade.com/au/insights/news/live-news/article-2-1605697-20260403"},{"fp":"b118fbbad9daf28e","provider":"serper","published_at":"2026-04-03T11:42:42.284122+00:00","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","snippet":"WTI technical outlook: Struggling to gain momentum below the 200-day SMA and facing resistance at $72.50. Support seen at $68.00. Analysis: While the decline in ...","source":"web_search","source_url":"https://www.facebook.com/cointelegraph/posts/-update-jim-cramer-warns-87-oil-surge-could-trigger-major-market-downside/1259050639735095/","summary":"WTI technical outlook: Struggling to gain momentum below the 200-day SMA and facing resistance at $72.50. Support seen at $68.00. Analysis: While the decline in ...","title":"Jim Cramer warns 87% oil surge could trigger major market downside.","url":"https://www.facebook.com/cointelegraph/posts/-update-jim-cramer-warns-87-oil-surge-could-trigger-major-market-downside/1259050639735095/"},{"fp":"b46d4eb043659163","provider":"serper","published_at":"2026-04-03T11:42:42.284122+00:00","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","snippet":"WTI and Brent crude futures decline over 2% in early trading, pressured by surprise U.S. stockpile increases and softening global demand outlook, ...","source":"web_search","source_url":"https://www.ad-hoc-news.de/boerse/news/ueberblick/oil-prices-dip-as-u-s-inventories-build-and-demand-worries-mount-amid/69056703","summary":"WTI and Brent crude futures decline over 2% in early trading, pressured by surprise U.S. stockpile increases and softening global demand outlook, ...","title":"Oil Prices Dip as U.S. Inventories Build and Demand Worries Mount ...","url":"https://www.ad-hoc-news.de/boerse/news/ueberblick/oil-prices-dip-as-u-s-inventories-build-and-demand-worries-mount-amid/69056703"},{"fp":"f206d0bf3c5b16a3","provider":"serper","published_at":"2026-04-03T11:42:42.284122+00:00","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","snippet":"Commercial crude stocks have drawn down consistently. This fundamental tightness provides the tinder for geopolitical sparks to cause significant price flares.","source":"web_search","source_url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments","summary":"Commercial crude stocks have drawn down consistently. This fundamental tightness provides the tinder for geopolitical sparks to cause significant price flares.","title":"WTI Crude Oil Skyrockets: Trump's Explosive Iran Remarks Shatter ...","url":"https://cryptorank.io/news/feed/fe2d9-wti-crude-oil-trump-iran-comments"},{"fp":"6ff30451b0761087","provider":"serper","published_at":"2026-04-03T11:42:42.284122+00:00","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","snippet":"The immediate catalyst for oil's dramatic move was the conflict in the Middle East. Since the war began at the end of February, crude prices have jumped ...","source":"web_search","source_url":"https://www.ainvest.com/news/oil-geopolitical-rally-faces-oversupply-reckoning-inventories-climb-461-6-million-barrels-2604/","summary":"The immediate catalyst for oil's dramatic move was the conflict in the Middle East. Since the war began at the end of February, crude prices have jumped ...","title":"Oil's Geopolitical Rally Faces Oversupply Reckoning as Inventories ...","url":"https://www.ainvest.com/news/oil-geopolitical-rally-faces-oversupply-reckoning-inventories-climb-461-6-million-barrels-2604/"},{"fp":"f6ef7bb291cf9310","provider":"serper","published_at":"2026-04-03T11:42:42.284122+00:00","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","snippet":"Goldman Sachs estimates the current geopolitical risk premium baked into crude prices sits between $14 and $18 per barrel. The $100 level and the war ...","source":"web_search","source_url":"https://www.fxstreet.com/analysis/wti-holds-above-100-as-trump-threats-to-obliterate-irans-energy-infrastructure-boost-crude-oil-202603301624","summary":"Goldman Sachs estimates the current geopolitical risk premium baked into crude prices sits between $14 and $18 per barrel. The $100 level and the war ...","title":"WTI holds above $100 as Trump threats to obliterate Iran's energy ...","url":"https://www.fxstreet.com/analysis/wti-holds-above-100-as-trump-threats-to-obliterate-irans-energy-infrastructure-boost-crude-oil-202603301624"}],"meta":{},"provider":"serper","quality_hint":1.0,"query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","source":"opportunity_research_ingestor","source_ref":"web_search:serper","status":"ok"}}
TEXT NOT NULL
source_ref
web_search:serper
TEXT
confidence
REAL (default 0.0
dedupe_key
opportunity_research_snapshot:a3f3b397a7b6a81b
TEXT
episode_id
NULL
TEXT
created_at
2026-04-03T11:42:54.300353+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel