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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:5d06a49ad32eae0c","evidence_event_ids":["evt_9efa67141f01"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides","enrichment":{"aggregator_url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides","article_chars":4958,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_02609ea3ad2b961e","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:59:05.778019+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin jumped on reports that Pakistan has put together a framework for a U.S.-Iran ceasefire, but analysts remain cautious.","fetched_title":"Bitcoin Hits Weekly High Over $69K on US-Iran Ceasefire Hopes as Oil Slides - Decrypt","final_url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides","source_event_id":"evt_9efa67141f01","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"463e82c79984174b","kind":"crypto_extremes","published_at":"2026-04-06T09:08:48+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"macro/geopolitical","name":"Pakistan","relevance":"high","symbol":"","type":"country"},{"asset_class":"macro/geopolitical","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"macro/geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil","relevance":"medium","symbol":"","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned text does not include the article\u2019s specific wording about the exact weekly-high level beyond the headline threshold (> $69K).","No explicit oil price change (magnitude/percentage) is provided in the cleaned text.","The article\u2019s details on what the \u201cframework\u201d entails, timing, and whether it is confirmed are not included.","\u201cAnalysts remain cautious\u201d is not supported with specific analyst quotes or reasons in the provided text."],"key_facts":["Bitcoin price shown at $71,600.00, up 3.96% (as presented in the cleaned article text).","Headline states Bitcoin hit a weekly high over $69K on U.S.-Iran ceasefire hopes as oil slides.","Source summary says the jump was on reports that Pakistan has put together a framework for a U.S.-Iran ceasefire.","Source summary also states analysts remain cautious."],"numeric_claims":[{"label":"Bitcoin price","value":"$71,600.00"},{"label":"Bitcoin daily/period change (as shown)","value":"+3.96%"},{"label":"Bitcoin weekly high threshold (headline)","value":"over $69K"}],"primary_claim":"Bitcoin hit a weekly high over $69,000 (quoted at $71,600) on ceasefire-related hopes as oil prices slid.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Bitcoin rose to a weekly high above $69K, reaching $71,600, alongside broader crypto gains. The move was attributed to reports of Pakistan assembling a framework for a potential U.S.-Iran ceasefire, though analysts were described as cautious.","topics":["Bitcoin weekly high","U.S.-Iran ceasefire hopes","Pakistan ceasefire framework reports","Oil price slide","Crypto market broad-based gains"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Bitcoin jumped on reports that Pakistan has put together a framework for a U.S.-Iran ceasefire, but analysts remain cautious.","tickers":[],"title":"Bitcoin Hits Weekly High Over $69K on US-Iran Ceasefire Hopes as Oil Slides","url":"https://decrypt.co/363361/bitcoin-hits-weekly-high-over-69k-on-us-iran-ceasefire-hopes-as-oil-slides"}}

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 2801 in events