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:3393b621d20b0ce6","evidence_event_ids":["evt_5604b0eb6ba6"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/","enrichment":{"aggregator_url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/","article_chars":3045,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_52423ee07927fe92","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:53:05.855361+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin dropped below $68,000 on April 7 as reported U.S. and Israeli strikes on Iranian infrastructure rattled global markets.","fetched_title":"BTC Erases Gains in Global Risk-off Flush Amid Middle East Military Escalation \u2013 Markets and Prices Bitcoin News","final_url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/","source_event_id":"evt_5604b0eb6ba6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"25514209ee6c5d49","kind":"crypto_extremes","published_at":"2026-04-07T19:29:10+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["Apr 7, 2026","Tuesday","Monday night","11 a.m. EST"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptoasset"},{"asset_class":"other","name":"U.S. forces","relevance":"medium","symbol":"","type":"military_actor"},{"asset_class":"other","name":"Israeli forces","relevance":"medium","symbol":"","type":"military_actor"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic_chokepoint"},{"asset_class":"commodity","name":"West Texas Intermediate (WTI) crude oil","relevance":"medium","symbol":"WTI","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["The article excerpt does not provide the exact time/date for the $60.63M liquidations figure beyond it being associated with the described high volatility.","No specific details are given on the magnitude/timing of the U.S./Israeli strikes beyond \u201cinitiated strikes against Iranian civilian infrastructure.\u201d","The \u201cTrump deadline\u201d is referenced but the specific deadline content and its direct causal link to BTC are not detailed in the provided text.","The article does not specify whether the $67,724 low was on a particular exchange or across all venues.","No quantitative data is provided for equities\u2019 move beyond \u201cglobal markets recoiled.\u201d"],"key_facts":["Bitcoin fell below $68,000 on Apr 7, 2026.","Bitcoin\u2019s intraday low was $67,724 (by 11 a.m. EST, per article).","The move is described as a reversal from the prior day\u2019s attempt to break $70,000 resistance.","The article attributes the decline to U.S. and Israeli military strikes on Iranian infrastructure.","Coinglass is cited as reporting $60.63 million in liquidations (timing tied to the high volatility described).","WTI crude oil briefly peaked just above $117 per barrel before retreating to $113 (per article).","The article states analysts warn that a prolonged closure of the Strait of Hormuz could trigger acute global oil shortages and potentially a deep recession.","The article mentions investors bracing for the expiration of President Donald Trump\u2019s Tuesday deadline (as part of broader risk-off)."],"numeric_claims":[{"label":"BTC intraday low (USD)","value":"67,724"},{"label":"BTC level breached (USD)","value":"68,000"},{"label":"BTC resistance level attempted (USD)","value":"70,000"},{"label":"Liquidations reported (USD)","value":"60.63 million"},{"label":"WTI peak (USD/barrel)","value":"just above 117"},{"label":"WTI retreat level (USD/barrel)","value":"113"},{"label":"BTC surge prior day","value":"4%"}],"primary_claim":"Bitcoin tumbled below $68,000 on Apr 7, reaching an intraday low of $67,724, amid U.S. and Israeli strikes on Iranian infrastructure and a broader global risk-off move.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"On Apr 7, 2026, bitcoin fell below $68,000 and hit an intraday low of $67,724, reversing a prior attempt to break $70,000 amid Middle East military escalation. The article links the move to U.S. and Israeli strikes on Iranian infrastructure and reports $60.63M in liquidations alongside a spike in WTI oil above $117/barrel.","topics":["BTC price drop","$68,000 support break","$70,000 resistance attempt","Middle East military escalation","Iran retaliation risk","Strait of Hormuz closure risk","crypto liquidations","global risk-off equities","WTI oil spike","Trump deadline (Tuesday)"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"On April 7, bitcoin tumbled below $68,000, hitting an intraday low of $67,724. This marked a swift reversal from the previous day\u2019s attempt to break the $70,000 resistance level. Key Takeaways: Bitcoin fell below $68,000 on April 7 following U.S. and Israeli military strikes on Iranian infrastructure. High volatility led Coinglass to report $60.63 million [\u2026]","tickers":[],"title":"BTC Erases Gains in Global Risk-off Flush Amid Middle East Military Escalation","url":"https://news.bitcoin.com/btc-erases-gains-in-global-risk-off-flush-amid-middle-east-military-escalation/"}}

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