Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
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 9403 in events
seq
Primary key.
INTEGER
id
evt_5a489d6a8a0f
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-09T22:56:30.265237+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:b27696abd23f8cae","evidence_event_ids":["evt_56d89812f1b1"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran","enrichment":{"aggregator_url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran","article_chars":4979,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a5e6ecae58b51de4","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:56:30.265205+00:00","extraction_method":"heuristic","fetched_description":"Trump threatened to erase an entire civilization by tonight, and markets\u2014including Bitcoin\u2014are predictably on edge.","fetched_title":"Bitcoin Threatens to Break Support as Trump Threatens to Destroy Iran - Decrypt","final_url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran","source_event_id":"evt_56d89812f1b1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"222441125e876277","kind":"crypto_extremes","published_at":"2026-04-07T20:12:52+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"person","name":"Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"crypto","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"crypto","name":"XRP","relevance":"medium","symbol":"XRP","type":"cryptocurrency"}],"event_type":"geopolitical_risk","information_gaps":["No explicit definition of the \u201csupport\u201d level for Bitcoin is provided in the provided text.","No timestamp for \u201cby tonight\u201d is provided in the cleaned article text.","The article text provided is dominated by a large price list; it does not include the specific market mechanism or technical indicator used to claim Bitcoin is \u201cthreatens to break support.\u201d","The exact wording and context of Trump\u2019s Iran-related threat are not fully quoted beyond the paraphrase in the source summary."],"key_facts":["The headline states: \u201cBitcoin Threatens to Break Support as Trump Threatens to Destroy Iran.\u201d","The source summary says Trump threatened to \u201cerase an entire civilization by tonight,\u201d and that markets\u2014including Bitcoin\u2014are on edge.","The article text includes a price snapshot showing BTC at $72,194.00 with a +1.41% move (as presented in the cleaned text).","The article text includes a price snapshot showing ETH at $2,206.02 with a +0.47% move (as presented in the cleaned text)."],"numeric_claims":[{"label":"BTC price (as shown)","value":"$72,194.00"},{"label":"BTC % move (as shown)","value":"+1.41%"},{"label":"ETH price (as shown)","value":"$2,206.02"},{"label":"ETH % move (as shown)","value":"+0.47%"}],"primary_claim":"Bitcoin is threatening to break support as Trump threatens to destroy Iran, with markets (including Bitcoin) reacting.","relevance_score":0.74,"sentiment":"mixed","source_quality":"high","summary":"The article claims Bitcoin is threatening to break support while markets react to a Trump threat involving Iran. It also lists current prices and percentage moves for many crypto assets, including BTC.","topics":["Bitcoin support level","crypto market reaction","Trump statement","Iran geopolitical risk","broad crypto price moves"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Trump threatened to erase an entire civilization by tonight, and markets\u2014including Bitcoin\u2014are predictably on edge.","tickers":[],"title":"Bitcoin Threatens to Break Support as Trump Threatens to Destroy Iran","url":"https://decrypt.co/363541/bitcoin-pricethreatens-break-support-trump-iran"}}
TEXT NOT NULL
source_ref
candidate:sc_a5e6ecae58b51de4
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_crypto_extremes_delta:b27696abd23f8cae
TEXT
episode_id
NULL
TEXT
created_at
2026-04-09T22:56:30.265284+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel