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:6ed0be424d33a597","evidence_event_ids":["evt_0c81800470bf"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst","enrichment":{"aggregator_url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst","article_chars":4958,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cfe3ad1c1724349f","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:56:59.460458+00:00","extraction_method":"heuristic","fetched_description":"Bloomberg\u2019s Mike McGlone argued that Bitcoin could fall as the crypto market purges market excesses that coincided with the pandemic-era boom.","fetched_title":"'A Hurricane Coming': Bitcoin Could Fall to $10K This Year, Says Bloomberg Analyst - Decrypt","final_url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst","source_event_id":"evt_0c81800470bf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"310e2b20c89e10b1","kind":"crypto_extremes","published_at":"2026-04-06T16:47:16+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"crypto_analyst","name":"Mike McGlone","relevance":"primary source of the forecast","symbol":"","type":"person"},{"asset_class":"media","name":"Bloomberg","relevance":"source of the analyst quote","symbol":"","type":"publisher"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"subject of the forecast","symbol":"BTC","type":"asset"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"mentioned in the provided price list (context only)","symbol":"ETH","type":"asset"}],"event_type":"price_action","information_gaps":["The article text provided does not include the full Bloomberg analysis or any supporting quantitative model/assumptions behind the $10,000 forecast.","No specific date range within \u201cthis year\u201d is stated in the provided text.","The cleaned text appears to be a broad crypto price list; it does not explicitly connect those prices to McGlone\u2019s forecast beyond being present in the same cleaned content."],"key_facts":["The headline states that Bloomberg\u2019s Mike McGlone said Bitcoin could fall to $10K this year.","The provided source summary attributes the rationale to a \u201cpurge\u201d of market excesses associated with the pandemic-era boom.","The cleaned article text includes a current price snapshot showing BTC at $71,600.00 and ETH at $2,232.75 (with listed percentage changes)."],"numeric_claims":[{"label":"Bitcoin forecast price","value":"$10,000 (this year)"},{"label":"Bitcoin current price shown","value":"$71,600.00"},{"label":"Bitcoin shown daily/period change","value":"3.96%"},{"label":"Ethereum current price shown","value":"$2,232.75"},{"label":"Ethereum shown daily/period change","value":"5.56%"}],"primary_claim":"Mike McGlone (Bloomberg) expects Bitcoin could fall to $10,000 this year.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg analyst Mike McGlone said Bitcoin could drop to $10,000 within this year as the market \u201cpurges market excesses\u201d from the pandemic-era boom.","topics":["Bitcoin price forecast","crypto market correction","pandemic-era boom excesses","extreme downside scenario"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Bloomberg\u2019s Mike McGlone argued that Bitcoin could fall as the crypto market purges market excesses that coincided with the pandemic-era boom.","tickers":[],"title":"'A Hurricane Coming': Bitcoin Could Fall to $10K This Year, Says Bloomberg Analyst","url":"https://decrypt.co/363398/hurricane-coming-bitcoin-fall-10k-bloomberg-analyst"}}

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