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 4401 in events
seq
Primary key.
INTEGER
id
evt_f462d39d4a62
TEXT NOT NULL
kind
signal_emitted
TEXT NOT NULL
ts
2026-04-03T19:04:37.705245+00:00
TEXT NOT NULL
actor
opportunity_finder
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-03T19:04:37.705245+00:00","dedupe_key":"opportunity_case_memory:case_11c2f28a44862b00:digest:2026-04-03T19","evidence_event_ids":["evt_001eea4a88bb","evt_e94a4f70b913","evt_362cdd795306","evt_2b0602be162b","evt_41045779ee62","evt_edc8bbcfb1b6","evt_feb95e9982f9","evt_1be7f9beeded","evt_601e25343546","evt_0bb6419fb48d","evt_e48ca46b8af3","evt_29f9deb7d4b8","evt_c482b3694d13","evt_b9c4f6ce13de","evt_070d46e77dce","evt_e283adc71d26","evt_fa28bcce594c","evt_8a18667dd17c","evt_be1f9a2bb530","evt_c3bac2fb4e60","evt_d58aa7072112","evt_cad751bc81bf","evt_3312d1fa59d6","evt_36fda3645a3f","evt_282ff52e2355","evt_a3f215c45eca","evt_5842863b776f","evt_f2b3629e9d0f","evt_4cf74687be5d","evt_af187233c05a","evt_04e281a380bf","evt_2e00da746176","evt_356eb2f2bdd4","evt_58a7e4dc7969","evt_0d2b41e11926","evt_8f8b7d3890ae","evt_c8393ac8fc54","evt_c5dfc852e158","evt_63323d8e6c15","evt_250780b52270","evt_913ec9cbe1af","evt_85ae61f3366f","evt_80375aea4e05","evt_e6d62463685d","evt_2292508410a3","evt_836394a27f3f","evt_2452a684a1ca","evt_559366d93d08","evt_3ddc70a87b81","evt_0074dbd52832","evt_e7717625091a","evt_9e01a2de90ac","evt_d510df9f7662","evt_f19284613c1d","evt_5fa51bed2092","evt_91dfdbf3d748","evt_26a23dd407ce","evt_1c62e928d973","evt_c67144804799","evt_4b14f74635a9"],"reason_trace":{"case_id":"case_11c2f28a44862b00","decision":"digest","entity_key":"commodity:us_oil_wti","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_type":"opportunity_case_memory","source":"opportunity_finder","throttle_s":3600,"value":{"case_id":"case_11c2f28a44862b00","confidence":0.85,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":250,"score":0.5,"up_count":0},"base_score":0.7544,"claim_graph":{"case_signal_families":["research","market","smart_money","news"],"case_source_domains":["argusmedia.com","facebook.com","decrypt.co","cryptoslate.com","nasdaq.com","barrons.com","fortune.com","isonewswire.com","politico.com","wsj.com","finance.yahoo.com","bloomberg.com","marketplace.org","morningstar.com","marketbeat.com","mitrade.com","cryptorank.io","ad-hoc-news.de","ainvest.com","tmgm.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_eb63f04a05318718","conflict":false,"direction":"neutral","evidence_count":11,"family_coverage":1,"quality_score":0.6864,"source_coverage":16,"source_trust":0.6644,"statement":"How to Play a Pullback in Energy Stocks - Barron's","strength":0.6216},{"agreement_score":0.6,"claim_id":"claim_fd58142e5b877fc3","conflict":false,"direction":"neutral","evidence_count":32,"family_coverage":1,"quality_score":0.6831,"source_coverage":16,"source_trust":0.6312,"statement":"Free commodity and energy news - Argus Media","strength":0.6076},{"agreement_score":0.6,"claim_id":"claim_d2a131e960ac19f7","conflict":false,"direction":"neutral","evidence_count":12,"family_coverage":1,"quality_score":0.681,"source_coverage":8,"source_trust":0.61,"statement":"Federal Reserve Chairman Jerome Powell Just Delivered Fantastic News for Stock Market Investors","strength":0.6177},{"agreement_score":0.6,"claim_id":"claim_5ab6665853dcd932","conflict":false,"direction":"neutral","evidence_count":1,"family_coverage":1,"quality_score":0.3963,"source_coverage":1,"source_trust":0.58,"statement":"Analyzing the Energy Sector's Strong Earnings Outlook","strength":0.4346}],"coverage":{"claim_count":4,"conflicting_claims":0,"dominant_claim_id":"claim_eb63f04a05318718","multi_family_claims":0,"multi_source_claims":3},"score":0.5697},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":[],"evidence_event_count":60,"high_precision_pass":true,"high_trust_source_coverage":5,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6738,"signal_family_coverage":4,"source_trust":{"avg_score":0.6232,"domains":[{"count":2,"domain":"reuters.com","score":0.9,"source":"web_search"},{"count":2,"domain":"bloomberg.com","score":0.89,"source":"Bloomberg.com"},{"count":7,"domain":"wsj.com","score":0.86,"source":"WSJ"},{"count":2,"domain":"apnews.com","score":0.86,"source":"AP News"},{"count":15,"domain":"barrons.com","score":0.82,"source":"Barron's"},{"count":1,"domain":"morningstar.com","score":0.82,"source":"Morningstar"},{"count":1,"domain":"argusmedia.com","score":0.8,"source":"web_search"},{"count":1,"domain":"axios.com","score":0.77,"source":"axios.com"},{"count":9,"domain":"investing.com","score":0.74,"source":"web_search"},{"count":6,"domain":"oilprice.com","score":0.7,"source":"web_search"},{"count":2,"domain":"stockstory.org","score":0.68,"source":"StockStory"},{"count":2,"domain":"npr.org","score":0.68,"source":"npr.org"},{"count":1,"domain":"marketplace.org","score":0.68,"source":"marketplace.org"},{"count":1,"domain":"aei.org","score":0.68,"source":"web_search"},{"count":29,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":22,"domain":"ad-hoc-news.de","score":0.58,"source":"web_search"},{"count":18,"domain":"bitget.com","score":0.58,"source":"web_search"},{"count":16,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":14,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":12,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Investing"},{"count":11,"domain":"mitrade.com","score":0.58,"source":"web_search"},{"count":9,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":9,"domain":"discoveryalert.com.au","score":0.58,"source":"web_search"},{"count":8,"domain":"mufgamericas.com","score":0.58,"source":"web_search"},{"count":7,"domain":"vtmarkets.com","score":0.58,"source":"web_search"},{"count":3,"domain":"mexc.com","score":0.58,"source":"web_search"},{"count":2,"domain":"fortune.com","score":0.58,"source":"fortune.com"},{"count":2,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":2,"domain":"news.futunn.com","score":0.58,"source":"web_search"},{"count":2,"domain":"nbcnews.com","score":0.58,"source":"NBC News"},{"count":2,"domain":"fool.com","score":0.58,"source":"The Motley Fool"},{"count":2,"domain":"charles-stanley.co.uk","score":0.58,"source":"web_search"},{"count":2,"domain":"washingtonpost.com","score":0.58,"source":"The Washington Post"},{"count":2,"domain":"nytimes.com","score":0.58,"source":"nytimes.com"},{"count":2,"domain":"cnn.com","score":0.58,"source":"CNN"},{"count":1,"domain":"decrypt.co","score":0.58,"source":"Decrypt RSS"},{"count":1,"domain":"cryptoslate.com","score":0.58,"source":"CryptoSlate RSS"},{"count":1,"domain":"isonewswire.com","score":0.58,"source":"ISO Newswire"},{"count":1,"domain":"politico.com","score":0.58,"source":"Politico"},{"count":1,"domain":"tmgm.com","score":0.58,"source":"web_search"}],"high_trust_domains":["apnews.com","argusmedia.com","axios.com","barrons.com","bloomberg.com","morningstar.com","reuters.com","wsj.com"],"independent_high_trust_sources":57,"low_trust_domains":[]},"source_trust_score":0.7722},"decision":"digest","entity_key":"commodity:us_oil_wti","evidence_event_count":60,"headline":"The energy sector is experiencing a pullback, influenced by recent developments and Federal Reserve news.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Recent signals indicate a convergence in energy stock trends and external geopolitical factors."}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
opportunity_case_memory:case_11c2f28a44862b00:digest:2026-04-03T19
TEXT
episode_id
NULL
TEXT
created_at
2026-04-03T19:05:21.639959+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel