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 38748 in events
seq
Primary key.
INTEGER
id
evt_af04caac946c
TEXT NOT NULL
kind
signal_emitted
TEXT NOT NULL
ts
2026-04-07T17:01:51.606961+00:00
TEXT NOT NULL
actor
opportunity_finder
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-07T17:01:51.606961+00:00","dedupe_key":"opportunity_case_memory:case_d0a24cbd92304d8c:monitor:2026-04-07T17","evidence_event_ids":["evt_1cd748af020c","evt_bf8abaa13309","evt_e8d8c390e190","evt_6beea3db668e","evt_af6d70ff6826","evt_38e0f51d7144","evt_56796542a57b","evt_cf3d4e184e68","evt_ee479b7f8175","evt_04fe61bfc342","evt_0845429be1f5","evt_6dd5e345f029","evt_41909eeda90e","evt_65299e9e0bdd","evt_2062f959c2c3","evt_b2a0259da968","evt_063652e5c824","evt_717ad6e88ad1","evt_54580b61fe88","evt_7ef0e915bdb8","evt_f8cbab5ea784","evt_edef8803b2f7","evt_7a84c6ec1f4f","evt_9862f77afc4f","evt_eda1e33329d9","evt_7cc08e7b1688","evt_95c22ccfadaa"],"reason_trace":{"case_id":"case_d0a24cbd92304d8c","decision":"monitor","entity_key":"macro:bitcoin","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_type":"opportunity_case_memory","source":"opportunity_finder","throttle_s":3600,"value":{"case_id":"case_d0a24cbd92304d8c","confidence":0.42,"corroboration":{"agreement":{"count_score":1.0,"down_count":0,"magnitude_weighted_score":1.0,"majority_direction":"up","neutral_count":40,"score":1.0,"up_count":1},"base_score":0.7134,"claim_graph":{"case_signal_families":["market","technical"],"case_source_domains":["cryptoslate.com","decrypt.co","news.bitcoin.com","quiverquant.com","tradingview.com","investors.com","citizen-times.com","coingecko.com","bitbo.io","aol.com","finance.yahoo.com","barrons.com","fool.com","nasdaq.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_f800fe27d673fb0c","conflict":false,"direction":"neutral","evidence_count":26,"family_coverage":1,"quality_score":0.6803,"source_coverage":14,"source_trust":0.6029,"statement":"Bitcoin Holds Weekly Inflows While Ether, Altcoin ETFs Slip","strength":0.6652},{"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":2,"conflicting_claims":0,"dominant_claim_id":"claim_f800fe27d673fb0c","multi_family_claims":0,"multi_source_claims":1},"score":0.4751},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":[],"evidence_event_count":27,"high_precision_pass":false,"high_trust_source_coverage":1,"independent_source_coverage":14,"low_trust_source_coverage":0,"score":0.6218,"signal_family_coverage":2,"source_trust":{"avg_score":0.6005,"domains":[{"count":3,"domain":"barrons.com","score":0.82,"source":"Barron's"},{"count":3,"domain":"tradingview.com","score":0.66,"source":"TradingView"},{"count":7,"domain":"decrypt.co","score":0.58,"source":"Decrypt RSS"},{"count":6,"domain":"cryptoslate.com","score":0.58,"source":"CryptoSlate RSS"},{"count":5,"domain":"news.bitcoin.com","score":0.58,"source":"Bitcoin.com News"},{"count":3,"domain":"citizen-times.com","score":0.58,"source":"citizen-times.com"},{"count":3,"domain":"coingecko.com","score":0.58,"source":"CoinGecko Trending"},{"count":2,"domain":"quiverquant.com","score":0.58,"source":"Quiver Quantitative"},{"count":2,"domain":"bitbo.io","score":0.58,"source":"Bitbo"},{"count":2,"domain":"aol.com","score":0.58,"source":"AOL.com"},{"count":1,"domain":"investors.com","score":0.58,"source":"Investor's Business Daily"},{"count":1,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":1,"domain":"fool.com","score":0.58,"source":"Nasdaq Markets"},{"count":1,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Markets"},{"count":1,"domain":"","score":0.46,"source":"technical_analyzer"}],"high_trust_domains":["barrons.com"],"independent_high_trust_sources":14,"low_trust_domains":[]},"source_trust_score":0.5669},"decision":"monitor","entity_key":"macro:bitcoin","evidence_event_count":27,"headline":"A solo miner mined a Bitcoin block and earned a reward of $210,000.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Signal convergence: Bitcoin Holds Weekly Inflows While Ether, Altcoin ETFs Slip [neutral]; BTC technical priceAboveEma12 [up] Near-term catalyst: Trending: Bitcoin (BTC) (2026-04-06T18:42:47Z)."}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
opportunity_case_memory:case_d0a24cbd92304d8c:monitor:2026-04-07T17
TEXT
episode_id
NULL
TEXT
created_at
2026-04-07T17:02:45.575677+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel