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-21T19:57:20.275338+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:ab01815e199f3a18","evidence_event_ids":["evt_1366c62906e2"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/","enrichment":{"aggregator_url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/","article_chars":526,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2bc93c0c0708529b","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:26:12.978706+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin (BTC) struggles to maintain momentum amid $97 million in liquidations and shifting risk-off sentiment.","fetched_title":"Bitcoin Seesaw: Geopolitical Uncertainty Shakes BTC Price Ahead of US-Iran Deadline","final_url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/","source_event_id":"evt_1366c62906e2","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"746a74a69f154dcb","kind":"crypto_extremes","published_at":"2026-04-21T19:44:34+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.45000000000000007,"dates_mentioned":["April 21"],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"government","name":"U.S. officials","relevance":"medium","symbol":"","type":"group"},{"asset_class":"government","name":"Iranian officials","relevance":"medium","symbol":"","type":"group"},{"asset_class":"country","name":"Pakistan","relevance":"medium","symbol":"","type":"location"}],"event_type":"geopolitical_risk","information_gaps":["The provided cleaned article text does not include the detailed body content; only the headline and the limited 'Key Takeaways' excerpt are available.","The specific 'US-Iran deadline' timing/date is not stated in the provided text.","The excerpt truncates after 'wiping out $97 million in [\u2026]', so the full liquidation context (e.g., timeframe, instrument type) is not fully verifiable from the provided text.","No additional quantitative details (e.g., closing price, percentage move, duration of volatility) are included in the provided text."],"key_facts":["The article states that on April 21, bitcoin fluctuated between approximately $75,000 and $77,000.","The article reports a bitcoin high of $76,944 on April 21.","The article attributes the move to reports of U.S. and Iranian officials meeting in Pakistan on April 21.","The article states that high volatility led to liquidation of 6,769 traders.","The article states the liquidations wiped out $97 million (exact context not fully shown in provided text).","The headline indicates the move occurred ahead of a US-Iran deadline (deadline date/details not provided in the cleaned text)."],"numeric_claims":[{"label":"BTC trading range (approx.)","value":"$75,000\u2013$77,000"},{"label":"BTC reported high","value":"$76,944"},{"label":"Traders liquidated","value":"6,769"},{"label":"Liquidation value wiped out","value":"$97 million"}],"primary_claim":"On April 21, Bitcoin\u2019s price was volatile (roughly $75,000\u2013$77,000) and hit a reported high of $76,944 amid reports of U.S. and Iranian officials meeting in Pakistan, alongside liquidations of 6,769 traders totaling $97 million.","relevance_score":0.72,"sentiment":"mixed","source_quality":"low","summary":"Bitcoin traded with high volatility around a geopolitical news cycle, moving between about $75,000 and $77,000 and reaching a reported high of $76,944 on April 21. The article links the move to reports of U.S. and Iranian officials meeting in Pakistan and notes liquidations totaling $97 million across 6,769 traders.","topics":["Bitcoin price volatility","geopolitical uncertainty","US-Iran deadline","liquidations","market sentiment"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"On April 21, bitcoin experienced a volatile trading session, fluctuating between $75,000 and $77,000 as market sentiment swung alongside high-stakes geopolitical developments. Key Takeaways: Bitcoin hit a $76,944 high after reports of U.S. and Iranian officials meeting in Pakistan on April 21. High volatility fueled the liquidation of 6,769 traders, wiping out $97 million in [\u2026]","tickers":[],"title":"Bitcoin Seesaw: Geopolitical Uncertainty Shakes BTC Price Ahead of US-Iran Deadline","url":"https://news.bitcoin.com/bitcoin-seesaw-geopolitical-uncertainty-shakes-btc-price-ahead-of-us-iran-deadline/"}}

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