SQLite Web: event_store.db

Update row sig_544a2320aef0 in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/","as_of":"2026-04-22T08:07:13.237740+00:00","canonical_url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/","enrichment":{"aggregator_url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/","article_chars":292,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_62cddc25a4275146","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T08:07:59.506383+00:00","extraction_method":"trafilatura","fetched_description":"BTC hits $78K following Trump\u2019s indefinite ceasefire extension. Read about the surge in ETH, XMR, and BCH amid escalating tensions in Iran.","fetched_title":"Bitcoin Surges Past $78,000 as Trump Extends US-Iran Ceasefire","final_url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/","source_event_id":"evt_bcf1a0ea524c","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"d6ef30e57303bef6","kind":"crypto_extremes","published_at":"2026-04-22T08:05:36+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.52,"dates_mentioned":["April 20","April 22, 2026"],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"political","name":"President Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"geopolitical","name":"U.S.-Iran ceasefire","relevance":"high","symbol":"","type":"geopolitical_event"}],"event_type":"geopolitical_risk","information_gaps":["The text is truncated after \u201cThe rally triggered $320 million in [\u2026]\u201d, so the full claim about $320 million is incomplete.","No additional details are provided about the mechanism linking the ceasefire extension to Bitcoin\u2019s move beyond the stated attribution.","The text does not specify whether the $1.56 trillion market cap figure is intraday or at a specific timestamp.","No information is provided on trading volume, exchange, or broader market context beyond the stated price/market-cap changes."],"key_facts":["Bitcoin surged past $78,000.","Bitcoin peaked at $78,446.","The rally is described as erasing all losses since April 20.","Bitcoin is described as reclaiming a $1.56 trillion market cap.","The rally is described as following President Trump\u2019s indefinite extension of the U.S.-Iran ceasefire."],"numeric_claims":[{"label":"Bitcoin peak price","value":"$78,446"},{"label":"Bitcoin level surpassed","value":"$78,000"},{"label":"Market cap reclaimed","value":"$1.56 trillion"}],"primary_claim":"Bitcoin peaked at $78,446 and reclaimed a $1.56 trillion market cap after Trump extended the U.S.-Iran ceasefire indefinitely.","relevance_score":0.72,"sentiment":"positive","source_quality":"low","summary":"Bitcoin surged past $78,000, peaking at $78,446, and reclaimed a $1.56 trillion market cap. The move is attributed in the text to President Trump\u2019s indefinite extension of the U.S.-Iran ceasefire.","topics":["Bitcoin price surge","$78,000 level","market cap reclaim","U.S.-Iran ceasefire extension","geopolitical risk"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"Bitcoin surged past $78,000 (peaking at $78,446), effectively erasing all losses since April 20 and reclaiming a $1.56 trillion market cap. The rally followed President Trump\u2019s indefinite extension of the Iran ceasefire. Key Takeaways: Bitcoin surged past $78,000 on April 22, 2026, after Trump extended the U.S.-Iran ceasefire indefinitely. The rally triggered $320 million in [\u2026]","tickers":[],"title":"Bitcoin Surges Past $78,000 as Trump Extends US-Iran Ceasefire","url":"https://news.bitcoin.com/bitcoin-surges-past-78000-as-trump-extends-us-iran-ceasefire/"}

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