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-07 in artifacts
id
opp_digest:2026-04-07
Primary key.
TEXT
kind
opportunity_digest
TEXT NOT NULL
status
ready
TEXT NOT NULL
title
Opportunity digest 2026-04-07
TEXT
summary
2 case(s)
TEXT
meta
{"count":2,"day":"2026-04-07"}
TEXT
output_json
{"items": [{"case_id": "case_d0a24cbd92304d8c", "confidence": 0.75, "corroboration": {"agreement": {"count_score": 1.0, "down_count": 0, "magnitude_weighted_score": 1.0, "majority_direction": "up", "neutral_count": 155, "score": 1.0, "up_count": 1}, "base_score": 0.8125, "claim_graph": {"case_signal_families": ["market", "technical", "research"], "case_source_domains": ["quiverquant.com", "investors.com", "citizen-times.com", "cryptoslate.com", "decrypt.co", "news.bitcoin.com", "coingecko.com", "tradingview.com", "bitbo.io", "aol.com", "finance.yahoo.com", "barrons.com", "nasdaq.com", "protos.com", "mexc.com", "blockchair.com", "wazirx.com", "cryptorank.io", "facebook.com", "bitget.com"], "claims": [{"agreement_score": 0.6, "claim_id": "claim_f800fe27d673fb0c", "conflict": false, "direction": "neutral", "evidence_count": 32, "family_coverage": 1, "quality_score": 0.681, "source_coverage": 16, "source_trust": 0.61, "statement": "Trending: Bitcoin (BTC)", "strength": 0.6677}, {"agreement_score": 0.6, "claim_id": "claim_c74fd428abf811f0", "conflict": false, "direction": "neutral", "evidence_count": 23, "family_coverage": 1, "quality_score": 0.678, "source_coverage": 16, "source_trust": 0.58, "statement": "Latest Crypto News & Updates", "strength": 0.616}, {"agreement_score": 1.0, "claim_id": "claim_10c36e29e202c82e", "conflict": false, "direction": "up", "evidence_count": 1, "family_coverage": 1, "quality_score": 0.345, "source_coverage": 0, "source_trust": 0.0, "statement": "BTC technical priceAboveEma12", "strength": 0.2792}], "coverage": {"claim_count": 3, "conflicting_claims": 0, "dominant_claim_id": "claim_f800fe27d673fb0c", "multi_family_claims": 0, "multi_source_claims": 2}, "score": 0.5339}, "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": false, "high_trust_source_coverage": 1, "independent_source_coverage": 20, "low_trust_source_coverage": 0, "score": 0.6883, "signal_family_coverage": 3, "source_trust": {"avg_score": 0.6024, "domains": [{"count": 13, "domain": "barrons.com", "score": 0.82, "source": "Barron's"}, {"count": 2, "domain": "investing.com", "score": 0.74, "source": "Investing.com"}, {"count": 1, "domain": "seekingalpha.com", "score": 0.68, "source": "Seeking Alpha"}, {"count": 1, "domain": "tradingview.com", "score": 0.66, "source": "tradingview.com"}, {"count": 13, "domain": "news.bitcoin.com", "score": 0.58, "source": "Bitcoin.com News"}, {"count": 12, "domain": "cryptoslate.com", "score": 0.58, "source": "CryptoSlate RSS"}, {"count": 9, "domain": "coingecko.com", "score": 0.58, "source": "CoinGecko Trending"}, {"count": 9, "domain": "mexc.com", "score": 0.58, "source": "web_search"}, {"count": 9, "domain": "cryptorank.io", "score": 0.58, "source": "web_search"}, {"count": 8, "domain": "decrypt.co", "score": 0.58, "source": "Decrypt RSS"}, {"count": 8, "domain": "blockchair.com", "score": 0.58, "source": "web_search"}, {"count": 8, "domain": "stocktitan.net", "score": 0.58, "source": "web_search"}, {"count": 5, "domain": "bitget.com", "score": 0.58, "source": "web_search"}, {"count": 5, "domain": "kucoin.com", "score": 0.58, "source": "web_search"}, {"count": 4, "domain": "facebook.com", "score": 0.58, "source": "web_search"}, {"count": 4, "domain": "fengyuan-yap.medium.com", "score": 0.58, "source": "web_search"}, {"count": 4, "domain": "ainvest.com", "score": 0.58, "source": "web_search"}, {"count": 4, "domain": "beincrypto.com", "score": 0.58, "source": "web_search"}, {"count": 4, "domain": "cryptohopper.com", "score": 0.58, "source": "web_search"}, {"count": 3, "domain": "quiverquant.com", "score": 0.58, "source": "Quiver Quantitative"}, {"count": 3, "domain": "investors.com", "score": 0.58, "source": "Investor's Business Daily"}, {"count": 3, "domain": "bitbo.io", "score": 0.58, "source": "Bitbo"}, {"count": 3, "domain": "nasdaq.com", "score": 0.58, "source": "Nasdaq Markets"}, {"count": 3, "domain": "wazirx.com", "score": 0.58, "source": "web_search"}, {"count": 2, "domain": "citizen-times.com", "score": 0.58, "source": "citizen-times.com"}, {"count": 2, "domain": "aol.com", "score": 0.58, "source": "AOL.com"}, {"count": 2, "domain": "finance.yahoo.com", "score": 0.58, "source": "Yahoo Finance"}, {"count": 2, "domain": "protos.com", "score": 0.58, "source": "Protos | Informed crypto news"}, {"count": 2, "domain": "binance.com", "score": 0.58, "source": "web_search"}, {"count": 2, "domain": "en.bloomingbit.io", "score": 0.58, "source": "en.bloomingbit.io"}, {"count": 1, "domain": "xbtfx.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "weex.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "uk.finance.yahoo.com", "score": 0.58, "source": "Yahoo Finance UK"}, {"count": 1, "domain": "phemex.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "msn.com", "score": 0.58, "source": "MSN"}, {"count": 1, "domain": "", "score": 0.46, "source": "technical_analyzer"}], "high_trust_domains": ["barrons.com"], "independent_high_trust_sources": 35, "low_trust_domains": []}, "source_trust_score": 0.5624}, "decision": "digest", "decision_reason_codes": ["market_trend", "economic_indicators", "technical_analysis", "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 Bitcoin price trends closely", "Assess broader crypto market movements", "Evaluate economic indicators affecting crypto"], "recommended_investigation_action": "Investigate upcoming economic events and their potential impact on Bitcoin's price.", "thesis": "Bitcoin's recent peak indicates a significant market movement, suggesting potential volatility ahead.", "uncertainty": {"band": "low", "reasons": ["high_impact_case"], "score": 0.1}, "why_now": "The market is reacting to key economic indicators and on-chain data, making this a pivotal moment for Bitcoin."}, {"case_id": "case_0f5c0db7300e58d9", "confidence": 0.75, "corroboration": {"agreement": {"count_score": 1.0, "down_count": 0, "magnitude_weighted_score": 1.0, "majority_direction": "up", "neutral_count": 8, "score": 1.0, "up_count": 1}, "base_score": 0.7754, "claim_graph": {"case_signal_families": ["market", "technical", "research"], "case_source_domains": ["coingecko.com", "mexc.com", "facebook.com"], "claims": [{"agreement_score": 0.6, "claim_id": "claim_10c82375cfdb0fb5", "conflict": false, "direction": "neutral", "evidence_count": 4, "family_coverage": 1, "quality_score": 0.5313, "source_coverage": 1, "source_trust": 0.58, "statement": "Trending: Ethereum (ETH)", "strength": 0.4946}, {"agreement_score": 0.6, "claim_id": "claim_ed72761f7c7ee947", "conflict": false, "direction": "neutral", "evidence_count": 2, "family_coverage": 1, "quality_score": 0.5147, "source_coverage": 2, "source_trust": 0.58, "statement": "The share of non-dollar stablecoins on the Ethereum network fell to 65% in February 2025, down from 90% in early 2023.", "strength": 0.69}, {"agreement_score": 1.0, "claim_id": "claim_4d208f655a639ae8", "conflict": false, "direction": "up", "evidence_count": 1, "family_coverage": 1, "quality_score": 0.345, "source_coverage": 0, "source_trust": 0.0, "statement": "ETH technical priceAboveEma12", "strength": 0.2825}], "coverage": {"claim_count": 3, "conflicting_claims": 0, "dominant_claim_id": "claim_10c82375cfdb0fb5", "multi_family_claims": 0, "multi_source_claims": 1}, "score": 0.4188}, "contradiction": {"flags": [], "has_unresolved_conflict": false, "resolved_claims": [], "resolved_count": 0, "score": 0.0, "unresolved_claims": [], "unresolved_count": 0}, "contradiction_flags": [], "evidence_event_count": 7, "high_precision_pass": false, "high_trust_source_coverage": 0, "independent_source_coverage": 3, "low_trust_source_coverage": 0, "score": 0.6296, "signal_family_coverage": 3, "source_trust": {"avg_score": 0.5667, "domains": [{"count": 6, "domain": "coingecko.com", "score": 0.58, "source": "CoinGecko Trending"}, {"count": 1, "domain": "mexc.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "facebook.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "", "score": 0.46, "source": "technical_analyzer"}], "high_trust_domains": [], "independent_high_trust_sources": 3, "low_trust_domains": []}, "source_trust_score": 0.377}, "decision": "digest", "decision_reason_codes": ["market_recovery", "economic_analysis", "investor_sentiment", "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 recovery trends", "Evaluate external economic impacts", "Assess investor sentiment"], "recommended_investigation_action": "Investigate factors contributing to the recovery and potential risks.", "thesis": "The crypto market is showing signs of recovery, but caution is advised.", "uncertainty": {"band": "low", "reasons": ["high_impact_case"], "score": 0.1}, "why_now": "Recent trends suggest a potential rebound, but underlying risks remain."}]}
TEXT
output_mrkdwn
Opportunity digest 2026-04-07 - Bitcoin's recent peak indicates a significant market movement, suggesting potential volatility ahead. - The market is reacting to key economic indicators and on-chain data, making this a pivotal moment for Bitcoin. [conf 0.75] - The crypto market is showing signs of recovery, but caution is advised. - Recent trends suggest a potential rebound, but underlying risks remain. [conf 0.75]
TEXT
evidence_event_ids
["evt_fcf094396824","evt_04fe61bfc342","evt_0845429be1f5","evt_41909eeda90e","evt_2062f959c2c3","evt_b2a0259da968","evt_063652e5c824","evt_717ad6e88ad1","evt_54580b61fe88","evt_7ef0e915bdb8","evt_f8cbab5ea784","evt_edef8803b2f7","evt_7cc08e7b1688","evt_95c22ccfadaa","evt_a3dc8ce1ecb9","evt_fef989983d45","evt_703633285b0c","evt_6de9f41d331a","evt_1201239f5ecd","evt_7056f8b3b14a","evt_9882d557c9d8","evt_2d0b63faa46b","evt_7dcbb093ec51","evt_0d40de6dd790","evt_c52ad3cbf1b9","evt_010e497bd281","evt_732b3a4fa411","evt_c4e6f511352a","evt_e365a64a73d2","evt_da517ddf343e","evt_171af8314f2b","evt_4527ff3bf84b","evt_de10e1806ab3","evt_fa3564d8acf6","evt_1b9da5adaef1","evt_ae3fb7394c93","evt_5fa2a643230a","evt_c50764235d28","evt_fa96c2c2fc7e","evt_d76cf602019c","evt_ae1094e22b52","evt_dd18c98e12f5","evt_63c6bfe183dc","evt_d1b21fba57a4","evt_2944edd2152b","evt_3ede114f9635","evt_a45a795ba59b","evt_57544313d8bb","evt_4dc031b7c3e3","evt_9060789eb71f","evt_40eb21aedd2e","evt_2e55928caf2b","evt_f8ae97bfcd2a","evt_c116dd9b0524","evt_c8d7f78f26f4","evt_b846ad52e9ca","evt_40b274fe69eb","evt_341ac7b899a3","evt_03ca8deb5100","evt_511d6b966e40","evt_cbc8d510e9b5","evt_6345eeab814c","evt_44237956d97f"]
TEXT
confidence
REAL
episode_id
NULL
TEXT
thread_id
NULL
TEXT
error
NULL
TEXT
attempt_count
INTEGER (default 0
created_at
2026-04-07T00:05:49.882129+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
updated_at
2026-04-07T00:03:57.950006+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-07T00:03:57.950006+00:00
TEXT
discarded_at
NULL
TEXT
Update
Cancel