SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:577d690ebac0e83c","evidence_event_ids":["evt_fe9be3123974"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","enrichment":{"aggregator_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","article_chars":4978,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e6bdec87963a6381","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:53:32.534211+00:00","extraction_method":"heuristic","fetched_description":"Crypto prices jumped on the announcement of a two-week ceasefire and the reopening of the Strait of Hormuz\u2014but macro events loom.","fetched_title":"Bitcoin Spikes Over $72K as Trump Announces Conditional Ceasefire With Iran - Decrypt","final_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran","source_event_id":"evt_fe9be3123974","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"73956d744afbc670","kind":"crypto_extremes","published_at":"2026-04-08T09:47:03+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"XRP","relevance":"medium","symbol":"XRP","type":"crypto_asset"},{"asset_class":"person","name":"Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"geopolitical_entity","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"geographic_location","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"}],"event_type":"geopolitical_risk","information_gaps":["The article text provided does not include the exact wording of Trump\u2019s conditional ceasefire terms beyond \u201cconditional\u201d and \u201ctwo-week.\u201d","No timestamp/time window for the price moves (e.g., intraday vs. daily) is provided in the cleaned text.","The specific \u201cmacro events\u201d that are said to loom are not identified in the provided text.","The article text does not specify whether the Strait of Hormuz reopening is confirmed or conditional; it is only stated in the source summary."],"key_facts":["BTC price shown as $72,321.00 and +1.51%.","ETH price shown as $2,212.03 and +0.65%.","XRP price shown as $1.36 and +0.66%.","The source summary states crypto prices jumped on Trump\u2019s announcement of a two-week conditional ceasefire with Iran.","The source summary states the reopening of the Strait of Hormuz accompanied the announcement.","The source summary states macro events loom (no specific macro events listed in the provided text)."],"numeric_claims":[{"label":"BTC price","value":"$72,321.00"},{"label":"BTC daily/period change","value":"+1.51%"},{"label":"ETH price","value":"$2,212.03"},{"label":"ETH change","value":"+0.65%"},{"label":"XRP price","value":"$1.36"},{"label":"XRP change","value":"+0.66%"}],"primary_claim":"Bitcoin spiked to $72,321.00 (up 1.51%) after Trump announced a conditional two-week ceasefire with Iran and the reopening of the Strait of Hormuz.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Bitcoin rose above $72K following an announcement by Trump of a conditional two-week ceasefire with Iran, alongside the reopening of the Strait of Hormuz. The article also notes broader macro events could still affect crypto markets.","topics":["Bitcoin price spike","Ceasefire announcement","Iran geopolitical risk","Strait of Hormuz reopening","Crypto market moves"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Crypto prices jumped on the announcement of a two-week ceasefire and the reopening of the Strait of Hormuz\u2014but macro events loom.","tickers":[],"title":"Bitcoin Spikes Over $72K as Trump Announces Conditional Ceasefire With Iran","url":"https://decrypt.co/363611/bitcoin-spikes-over-72k-as-trump-announces-conditional-ceasefire-with-iran"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 9352 in events