Create
Query
event_store.db
—
artifacts
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 opp_digest:2026-04-04 in artifacts
id
opp_digest:2026-04-04
Primary key.
TEXT
kind
opportunity_digest
TEXT NOT NULL
status
ready
TEXT NOT NULL
title
Opportunity digest 2026-04-04
TEXT
summary
2 case(s)
TEXT
meta
{"count":2,"day":"2026-04-04"}
TEXT
output_json
{"items": [{"case_id": "case_c41917c0ac891521", "confidence": 0.68, "corroboration": {"agreement": {"count_score": 1.0, "down_count": 0, "magnitude_weighted_score": 1.0, "majority_direction": "up", "neutral_count": 2, "score": 1.0, "up_count": 2}, "base_score": 0.7754, "claim_graph": {"case_signal_families": ["market", "research", "technical"], "case_source_domains": ["simplywall.st", "tickeron.com"], "claims": [{"agreement_score": 0.6, "claim_id": "claim_c7bf814cd7a6fc76", "conflict": false, "direction": "neutral", "evidence_count": 1, "family_coverage": 1, "quality_score": 0.3963, "source_coverage": 1, "source_trust": 0.58, "statement": "Alcoa (AA) Is Up 24.2% After Gulf Smelter Attacks Tighten Aluminum Supply - What's Changed - simplywall.st", "strength": 0.414}, {"agreement_score": 0.6, "claim_id": "claim_35e1775cf5b0594b", "conflict": false, "direction": "neutral", "evidence_count": 1, "family_coverage": 1, "quality_score": 0.3963, "source_coverage": 1, "source_trust": 0.58, "statement": "Alcoa Corporation (AA) Stock Analysis: Data Center Pivot Fuels Rally", "strength": 0.3976}, {"agreement_score": 1.0, "claim_id": "claim_755a4187f37b556a", "conflict": false, "direction": "up", "evidence_count": 2, "family_coverage": 1, "quality_score": 0.39, "source_coverage": 0, "source_trust": 0.0, "statement": "AA technical emaCrossUp", "strength": 0.5109}], "coverage": {"claim_count": 3, "conflicting_claims": 0, "dominant_claim_id": "claim_c7bf814cd7a6fc76", "multi_family_claims": 0, "multi_source_claims": 0}, "score": 0.3177}, "contradiction": {"flags": [], "has_unresolved_conflict": false, "resolved_claims": [], "resolved_count": 0, "score": 0.0, "unresolved_claims": [], "unresolved_count": 0}, "contradiction_flags": [], "evidence_event_count": 4, "high_precision_pass": false, "high_trust_source_coverage": 0, "independent_source_coverage": 2, "low_trust_source_coverage": 0, "score": 0.5911, "signal_family_coverage": 3, "source_trust": {"avg_score": 0.52, "domains": [{"count": 1, "domain": "simplywall.st", "score": 0.58, "source": "simplywall.st"}, {"count": 1, "domain": "tickeron.com", "score": 0.58, "source": "web_search"}, {"count": 2, "domain": "", "score": 0.46, "source": "technical_analyzer"}], "high_trust_domains": [], "independent_high_trust_sources": 2, "low_trust_domains": []}, "source_trust_score": 0.377}, "decision": "digest", "decision_reason_codes": ["strong_support", "medium_risk", "developing_case", "neutral_personalization_mode"], "personal_relevance": {"applied": false, "boost": 0.0, "explanations": ["No strong personal linkage detected."], "factors": [{"matched_assets": [], "max_exposure": 0.0, "name": "asset_linkage", "score": 0.0}, {"hits": [], "name": "theme_alignment", "score": 0.0}, {"hits": [], "name": "fallback_theme_alignment", "score": 0.0}, {"hits": [], "name": "role_alignment", "score": 0.0}, {"hits": [], "name": "location_alignment", "score": 0.0}, {"hits": [], "name": "goal_alignment", "score": 0.0}, {"hits": [], "name": "project_alignment", "score": 0.0}, {"hits": [], "name": "commitment_alignment", "score": 0.0}, {"name": "event_magnitude", "score": 0.1, "value": 10.0}, {"kind": "opportunity_case", "name": "urgency_context", "score": 0.0}], "kind": "boost_only", "matched_assets": [], "matched_keywords": [], "no_personalization_reason": "insufficient_profile_context", "profile_confidence": 0.0, "rationale": "No strong personal linkage detected.", "score": 0.1, "why_you": ""}, "personal_relevance_score": 0.1, "profile_confidence": 0.0, "recommended_checks": ["Identify key stocks with strong earnings potential", "Evaluate market conditions affecting the energy sector"], "recommended_investigation_action": "Investigate specific stocks with strong earnings potential in the energy sector.", "thesis": "The energy sector is showing potential for strong earnings despite recent challenges.", "uncertainty": {"band": "low", "reasons": ["limited_corroboration", "high_impact_case"], "score": 0.34}, "why_now": "Recent analyses indicate that certain stocks may still offer value amid broader market concerns."}, {"case_id": "case_11c2f28a44862b00", "confidence": 0.674, "corroboration": {"agreement": {"count_score": 0.5, "down_count": 0, "magnitude_weighted_score": 0.5, "majority_direction": "neutral", "neutral_count": 394, "score": 0.5, "up_count": 0}, "base_score": 0.7488, "claim_graph": {"case_signal_families": ["market", "smart_money", "news", "research"], "case_source_domains": ["nasdaq.com", "decrypt.co", "cryptoslate.com", "barrons.com", "marketbeat.com", "finance.yahoo.com", "stocktitan.net", "wsj.com", "msn.com", "fool.com", "fidelity.com", "outkick.com", "isonewswire.com", "politico.com", "trig-ltd.com", "facebook.com", "cryptorank.io", "mitrade.com", "ainvest.com", "fxstreet.com"], "claims": [{"agreement_score": 0.6, "claim_id": "claim_eb63f04a05318718", "conflict": false, "direction": "neutral", "evidence_count": 32, "family_coverage": 1, "quality_score": 0.6871, "source_coverage": 16, "source_trust": 0.6706, "statement": "Oil stocks are considered tapped out, indicating a potential decline in their value.", "strength": 0.6658}, {"agreement_score": 0.6, "claim_id": "claim_d2a131e960ac19f7", "conflict": false, "direction": "neutral", "evidence_count": 17, "family_coverage": 1, "quality_score": 0.6807, "source_coverage": 9, "source_trust": 0.6067, "statement": "The Energy Sector Is Paying Out. Here Are 2 Stocks That Could Fund Your Retirement.", "strength": 0.6445}, {"agreement_score": 0.6, "claim_id": "claim_fd58142e5b877fc3", "conflict": false, "direction": "neutral", "evidence_count": 32, "family_coverage": 1, "quality_score": 0.6797, "source_coverage": 16, "source_trust": 0.5975, "statement": "[PDF] TRIG 2025 Annual Report", "strength": 0.6076}, {"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.5694}, "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": 2, "independent_source_coverage": 20, "low_trust_source_coverage": 0, "score": 0.674, "signal_family_coverage": 4, "source_trust": {"avg_score": 0.637, "domains": [{"count": 2, "domain": "reuters.com", "score": 0.9, "source": "web_search"}, {"count": 3, "domain": "bloomberg.com", "score": 0.89, "source": "bloomberg.com"}, {"count": 16, "domain": "wsj.com", "score": 0.86, "source": "WSJ"}, {"count": 1, "domain": "apnews.com", "score": 0.86, "source": "AP News"}, {"count": 1, "domain": "ag.purdue.edu", "score": 0.84, "source": "web_search"}, {"count": 44, "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": 2, "domain": "axios.com", "score": 0.77, "source": "axios.com"}, {"count": 13, "domain": "investing.com", "score": 0.74, "source": "web_search"}, {"count": 14, "domain": "oilprice.com", "score": 0.7, "source": "web_search"}, {"count": 3, "domain": "npr.org", "score": 0.68, "source": "NPR"}, {"count": 2, "domain": "marketplace.org", "score": 0.68, "source": "marketplace.org"}, {"count": 1, "domain": "stimson.org", "score": 0.68, "source": "web_search"}, {"count": 1, "domain": "stockstory.org", "score": 0.68, "source": "StockStory"}, {"count": 45, "domain": "facebook.com", "score": 0.58, "source": "web_search"}, {"count": 28, "domain": "ad-hoc-news.de", "score": 0.58, "source": "web_search"}, {"count": 27, "domain": "bitget.com", "score": 0.58, "source": "web_search"}, {"count": 23, "domain": "cryptorank.io", "score": 0.58, "source": "web_search"}, {"count": 19, "domain": "ainvest.com", "score": 0.58, "source": "web_search"}, {"count": 15, "domain": "nasdaq.com", "score": 0.58, "source": "Nasdaq Stocks"}, {"count": 15, "domain": "discoveryalert.com.au", "score": 0.58, "source": "web_search"}, {"count": 13, "domain": "mitrade.com", "score": 0.58, "source": "web_search"}, {"count": 12, "domain": "finance.yahoo.com", "score": 0.58, "source": "Yahoo Finance"}, {"count": 12, "domain": "vtmarkets.com", "score": 0.58, "source": "web_search"}, {"count": 8, "domain": "mufgamericas.com", "score": 0.58, "source": "web_search"}, {"count": 6, "domain": "mexc.com", "score": 0.58, "source": "web_search"}, {"count": 5, "domain": "stocktitan.net", "score": 0.58, "source": "Stock Titan"}, {"count": 5, "domain": "msn.com", "score": 0.58, "source": "MSN"}, {"count": 4, "domain": "fool.com", "score": 0.58, "source": "The Motley Fool"}, {"count": 3, "domain": "isonewswire.com", "score": 0.58, "source": "ISO Newswire"}, {"count": 3, "domain": "politico.com", "score": 0.58, "source": "Politico"}, {"count": 3, "domain": "instagram.com", "score": 0.58, "source": "web_search"}, {"count": 3, "domain": "fortune.com", "score": 0.58, "source": "fortune.com"}, {"count": 3, "domain": "nytimes.com", "score": 0.58, "source": "nytimes.com"}, {"count": 3, "domain": "cnn.com", "score": 0.58, "source": "CNN"}, {"count": 2, "domain": "marketbeat.com", "score": 0.58, "source": "MarketBeat"}, {"count": 2, "domain": "fidelity.com", "score": 0.58, "source": "Fidelity"}, {"count": 2, "domain": "outkick.com", "score": 0.58, "source": "OutKick"}, {"count": 2, "domain": "fxstreet.com", "score": 0.58, "source": "web_search"}], "high_trust_domains": ["ag.purdue.edu", "apnews.com", "argusmedia.com", "axios.com", "barrons.com", "bloomberg.com", "morningstar.com", "reuters.com", "wsj.com"], "independent_high_trust_sources": 62, "low_trust_domains": []}, "source_trust_score": 0.7439}, "decision": "digest", "decision_reason_codes": ["high_precision_pass", "signal_convergence", "medium_risk", "developing_case", "neutral_personalization_mode"], "personal_relevance": {"applied": false, "boost": 0.0, "explanations": ["No strong personal linkage detected."], "factors": [{"matched_assets": [], "max_exposure": 0.0, "name": "asset_linkage", "score": 0.0}, {"hits": [], "name": "theme_alignment", "score": 0.0}, {"hits": [], "name": "fallback_theme_alignment", "score": 0.0}, {"hits": [], "name": "role_alignment", "score": 0.0}, {"hits": [], "name": "location_alignment", "score": 0.0}, {"hits": [], "name": "goal_alignment", "score": 0.0}, {"hits": [], "name": "project_alignment", "score": 0.0}, {"hits": [], "name": "commitment_alignment", "score": 0.0}, {"name": "event_magnitude", "score": 0.1, "value": 10.0}, {"kind": "opportunity_case", "name": "urgency_context", "score": 0.0}], "kind": "boost_only", "matched_assets": [], "matched_keywords": [], "no_personalization_reason": "insufficient_profile_context", "profile_confidence": 0.0, "rationale": "No strong personal linkage detected.", "score": 0.1, "why_you": ""}, "personal_relevance_score": 0.1, "profile_confidence": 0.0, "recommended_checks": ["Monitor oil stock performance in the coming weeks", "Assess geopolitical developments in Iran", "Evaluate market reactions to the incident"], "recommended_investigation_action": "Investigate the potential impact of geopolitical events on oil prices and stock performance.", "thesis": "The recent downing of a U.S. fighter jet in Iran may impact oil markets due to geopolitical tensions.", "uncertainty": {"band": "low", "reasons": ["high_impact_case"], "score": 0.1}, "why_now": "The incident has raised concerns about stability in the region, which could affect oil supply and prices."}]}
TEXT
output_mrkdwn
Opportunity digest 2026-04-04 - The energy sector is showing potential for strong earnings despite recent challenges. - Recent analyses indicate that certain stocks may still offer value amid broader market concerns. [conf 0.68] - The recent downing of a U.S. fighter jet in Iran may impact oil markets due to geopolitical tensions. - The incident has raised concerns about stability in the region, which could affect oil supply and prices. [conf 0.67]
TEXT
evidence_event_ids
["evt_7acf3c905000","evt_1766711f1460","evt_611a08f661dc","evt_4c3b448790bb","evt_2662039a0590","evt_23482fb1db88","evt_ee12c73ea5f8","evt_f4750615360b","evt_d773b907cc9c","evt_521efc1ce50e","evt_b55897879f3b","evt_d5e4556a506e","evt_1033efd7dd3c","evt_da5b2c177e83","evt_3f0ea0afa05b","evt_ae0bc79681c0","evt_986089c985cf","evt_9afe30cf53da","evt_bc9766bc40de","evt_8ff7823dde8a","evt_229091d34c1a","evt_891b86cd84ac","evt_7358d8f4ed78","evt_89c06d89897d","evt_ae90e6fdd026","evt_fa9646798b61","evt_55ea73005574","evt_b23d250b2ec3","evt_c1350eb1804e","evt_8c042505e628","evt_59628adee814","evt_630b99ba2c26","evt_da599e349e0e","evt_3573181812db","evt_115c6b703b9c","evt_badc66754df3","evt_8f58f786af47","evt_fad243a1ef1f","evt_b7dafe0829c9","evt_a5b3d7794907","evt_8ad36a9a853c","evt_4ff788211c2d","evt_642e367605ec","evt_7c96fcbec7f2","evt_cdc92343eb6b","evt_0ad30ab43f02","evt_914700340d98","evt_49371ad70293","evt_120661564e2b","evt_4de3dd17f42e","evt_90dd1343dc3f","evt_0466e3530266","evt_3bd5fdd3b95f","evt_ec228f463bce","evt_5ab0dbebace4","evt_8b79f8293e4f","evt_acb649297e57","evt_001eea4a88bb","evt_e94a4f70b913","evt_ed641b166520","evt_edc8bbcfb1b6","evt_1be7f9beeded"]
TEXT
confidence
REAL
episode_id
NULL
TEXT
thread_id
NULL
TEXT
error
NULL
TEXT
attempt_count
INTEGER (default 0
created_at
2026-04-04T00:06:53.890924+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
updated_at
2026-04-04T00:05:27.264219+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
claimed_at
NULL
TEXT
claim_id
NULL
TEXT
ready_at
2026-04-04T00:05:27.264219+00:00
TEXT
discarded_at
NULL
TEXT
Update
Cancel