SQLite Web: event_store.db

Update row sig_13f09402099c in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

Cancel