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-12T17:46:47.322267+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:533896d8ee31c0f5","evidence_event_ids":["evt_38f7107dfdc2"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/could-buying-bitcoin-today-still-set-you-life","as_of":"2026-04-12T17:46:47.322267+00:00","canonical_url":"https://www.fool.com/investing/2026/04/12/could-buying-bitcoin-today-still-set-you-up-for-li/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/could-buying-bitcoin-today-still-set-you-life","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a00698fdf34c032c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/12/could-buying-bitcoin-today-still-set-you-up-for-li/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T19:16:14.160217+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsDespite trading 43% below its record, Bitcoin\u2019s long-term return was a boon for investor portfolios.","fetched_title":"Could Buying Bitcoin Today Still Set You Up for Life? | Nasdaq","final_url":"https://www.nasdaq.com/articles/could-buying-bitcoin-today-still-set-you-life","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/could-buying-bitcoin-today-still-set-you-life","source_event_id":"evt_38f7107dfdc2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4b4fb4bf8292e599","kind":"unusual_volume","published_at":"2026-04-12T16:29:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 9","January 2009","December 17, 2004"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"media","name":"Motley Fool Stock Advisor","relevance":"medium","symbol":"","type":"publisher_section"},{"asset_class":"financial services","name":"River Financial","relevance":"medium","symbol":"","type":"company"}],"event_type":"other","information_gaps":["No unusual volume delta details are provided (no volume ratio vs average, no baseline volume, no direction, and no ticker-specific volume metrics).","No explicit catalyst for the alleged unusual volume is described; the article is primarily a long-term investment argument.","The signal type (discovery_unusual_volume_delta) is not corroborated by the provided text.","catalyst_hypothesis_most_likely_unavailable_due_to_missing_volume_data:","The most likely catalyst cannot be inferred from the provided text because no volume anomaly or trading activity data is included."],"key_facts":["Bitcoin is described as trading 43% below its record (peak).","The article states Bitcoin has risen almost 17,000% in the past 10 years (as of April 9).","The article claims Bitcoin accounts for 59% of the entire crypto industry's value.","The article states Bitcoin\u2019s hard supply cap is 21 million units.","The article states Bitcoin has a predictable inflation schedule enforced by a halving event occurring roughly every four years.","The article states Bitcoin\u2019s market cap is $1.5 trillion.","The article cites River Financial estimating Bitcoin represents 0.2% of worldwide wealth.","The article suggests investors should use patience and dollar-cost averaging over time."],"numeric_claims":[{"label":"drawdown_from_record","value":"43% below its record"},{"label":"price_return_past_10_years","value":"~17,000% (as of April 9)"},{"label":"share_of_crypto_industry_value","value":"59%"},{"label":"hypothetical_growth","value":"$10,000 -> nearly $1.7 million"},{"label":"supply_cap_units","value":"21 million"},{"label":"halving_interval","value":"~every 4 years"},{"label":"market_cap","value":"$1.5 trillion"},{"label":"share_of_worldwide_wealth","value":"0.2%"}],"primary_claim":"Bitcoin is down 43% from its peak but has long-term return potential, and the article recommends it as a top long-term digital asset.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article argues that Bitcoin (BTC) has strong long-term upside despite being down 43% from its peak, citing decentralization, simplicity, and scarcity. It does not provide any unusual trading volume metrics or a volume-vs-average ratio.","topics":["Bitcoin long-term returns","decentralization","scarcity/21 million cap","halving","market cap","investor portfolio allocation","dollar-cost averaging"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsDespite trading 43% below its record, Bitcoin\u2019s long-term return was a boon for investor portfolios.","tickers":[],"title":"Could Buying Bitcoin Today Still Set You Up for Life?","url":"https://www.fool.com/investing/2026/04/12/could-buying-bitcoin-today-still-set-you-up-for-li/"}}

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