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-16T10:15:40.769768+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:db5136f8b83d4e9f","evidence_event_ids":["evt_313fa3fc6337"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/what-1000-invested-bitcoin-during-its-last-bear-market-worth-today","as_of":"2026-04-16T10:15:40.769768+00:00","canonical_url":"https://www.fool.com/investing/2026/04/16/this-is-what-1000-invested-in-bitcoin-during-its-l/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/what-1000-invested-bitcoin-during-its-last-bear-market-worth-today","article_chars":4742,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_93b4cd3dfa556cac","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/16/this-is-what-1000-invested-in-bitcoin-during-its-l/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-16T10:21:59.878305+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsBitcoin's bear markets tend to be brutal.","fetched_title":"This Is What $1,000 Invested in Bitcoin During Its Last Bear Market Is Worth Today | Nasdaq","final_url":"https://www.nasdaq.com/articles/what-1000-invested-bitcoin-during-its-last-bear-market-worth-today","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/what-1000-invested-bitcoin-during-its-last-bear-market-worth-today","source_event_id":"evt_313fa3fc6337","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"38ebccafcb729b6e","kind":"unusual_volume","published_at":"2026-04-16T08:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Jan. 1, 2023","Oct. 10, 2025","October 2025","April 16, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided article text contains no trading volume or volume-vs-average ratio data.","No ticker-specific volume ratio, direction (above/below average), or baseline volume is provided in the text.","The article does not explicitly confirm any unusual volume event via news; it focuses on price performance and macro/crypto catalysts rather than volume anomalies.","A 'most likely catalyst hypothesis' for unusual volume cannot be grounded because no volume anomaly is described."],"key_facts":["Bitcoin was priced near $16,600 on Jan. 1, 2023 and was down about 77% from its prior high.","The article states that a $1,000 investment in early January 2023 would be worth approximately $4,330 today.","The article describes the current bear phase as Bitcoin being down about 43% from its all-time high set in October 2025.","The article attributes the 2022 bear market to cascading crypto industry failures (e.g., collapse of fraudulent exchanges and stablecoins losing their peg) and to the Federal Reserve\u2019s rate-hiking campaign.","The article states the current bear market was ushered in by an Oct. 10, 2025 flash crash and coincided with periods when mining-reward-based modeling frameworks indicated a breakdown was likely.","The article cites war with Iran and oil supply disruptions through the Strait of Hormuz as souring risk appetite.","The article states the Federal Reserve\u2019s rate-cutting cycle has stalled and inflation may be returning.","The article recommends dollar-cost averaging (buying a small amount of Bitcoin weekly regardless of price)."],"numeric_claims":[{"label":"Bitcoin price near Jan. 1, 2023","value":"~$16,600"},{"label":"Drawdown from prior high (Jan. 1, 2023 context)","value":"~77% down"},{"label":"Bitcoin drawdown from all-time high (current bear phase)","value":"~43% down"},{"label":"All-time high month/year","value":"October 2025"},{"label":"Value of $1,000 invested in early Jan. 2023","value":"~$4,330"},{"label":"Gain percentage","value":"~333%"},{"label":"Time horizon","value":"a little over three years"},{"label":"Stock Advisor returns as of April 16, 2026 (contextual)","value":"1,002% average return; S&P 500 195%"}],"primary_claim":"A $1,000 investment in Bitcoin in early January 2023 would be worth approximately $4,330 today (about a 333% gain).","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues that buying Bitcoin during the prior bear market (around Jan. 1, 2023) would have turned a $1,000 investment into about $4,330 today, and suggests a similar opportunity may exist during the current bear phase.","topics":["Bitcoin bear market","investment performance","Federal Reserve policy","risk appetite","flash crash","Strait of Hormuz","dollar-cost averaging"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsBitcoin's bear markets tend to be brutal.","tickers":[],"title":"This Is What $1,000 Invested in Bitcoin During Its Last Bear Market Is Worth Today","url":"https://www.fool.com/investing/2026/04/16/this-is-what-1000-invested-in-bitcoin-during-its-l/"}}

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