SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/case-owning-just-1-cryptocurrency-and-which-one-it-should-be","as_of":"2026-04-08T06:31:07.641041+00:00","canonical_url":"https://www.fool.com/investing/2026/04/08/the-case-for-owning-just-one-cryptocurrency-and-wh/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/case-owning-just-1-cryptocurrency-and-which-one-it-should-be","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e9b2e2dae747d9e7","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/08/the-case-for-owning-just-one-cryptocurrency-and-wh/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T06:32:25.053770+00:00","extraction_method":"heuristic","fetched_description":"Key PointsMost cryptocurrencies aren't worth buying.","fetched_title":"The Case for Owning Just 1 Cryptocurrency -- and Which One It Should Be | Nasdaq","final_url":"https://www.nasdaq.com/articles/case-owning-just-1-cryptocurrency-and-which-one-it-should-be","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/case-owning-just-1-cryptocurrency-and-which-one-it-should-be","source_event_id":"evt_dfc3dc09ffbe","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f7be739a4422ecbf","kind":"unusual_volume","published_at":"2026-04-08T04:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["March 25 (year not specified)","late 2024","December 17, 2004","April 15, 2005","April 8, 2026","April 8, 2026 \u2014 12:50 am EDT"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"media","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"financial services","name":"Fidelity Digital Assets","relevance":"medium","symbol":"","type":"research/firm"},{"asset_class":"financial services","name":"BlackRock","relevance":"medium","symbol":"","type":"research/firm"},{"asset_class":"financial services","name":"Grayscale","relevance":"medium","symbol":"","type":"research/firm"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"cryptocurrency","name":"XRP","relevance":"medium","symbol":"XRP","type":"cryptocurrency"}],"event_type":"other","information_gaps":["This signal type is discovery_unusual_volume_delta, but the provided text contains no trading volume data, no volume ratio vs average, and no ticker-specific volume metrics.","No baseline volume or computed volume ratio is provided in the excerpt.","The article does not describe any specific market event or catalyst tied to unusual volume; it is primarily an investment thesis/argument for Bitcoin.","The excerpt includes many stock tickers at the top (AAPL, TSLA, etc.) but does not connect them to any volume anomaly or to the crypto discussion."],"key_facts":["The article states that most cryptocurrencies aren't worth buying and that there is one asset shown to be worth owning over time.","It recommends holding just one crypto and says the case overwhelmingly favors Bitcoin (CRYPTO: BTC).","It cites Fidelity Digital Assets research (March 25) that adding Bitcoin to a standard 60/40 stocks/bonds portfolio over a 10-year lookback improved returns: 24% with up to 10% allocation and 17.5% with a 5% allocation; it also states a portfolio without Bitcoin had annualized returns around 9.4%.","It cites BlackRock research from late 2024 supporting that a 1% to 2% allocation to Bitcoin can provide significant upside exposure with manageable downside risk.","It cites Grayscale suggesting a roughly 5% portfolio allocation is a \u201csweet spot\u201d for maximizing risk-adjusted returns.","The article argues other cryptocurrencies (e.g., Ethereum and XRP) lack Bitcoin\u2019s \u201ctightly constrained supply policy\u201d and \u201cscarce stores of value,\u201d and require ongoing competition/changes.","The article includes a note that Stock Advisor\u2019s 10 best stocks list did not include Bitcoin (no specific date for the list is provided in the excerpt beyond \u201cjust identified\u201d)."],"numeric_claims":[{"label":"BTC allocation up to 10% (annualized/return figure cited)","value":"24%"},{"label":"BTC allocation 5% (annualized/return figure cited)","value":"17.5%"},{"label":"Portfolio without BTC annualized returns (figure cited)","value":"~9.4%"},{"label":"BlackRock cited allocation range","value":"1% to 2%"},{"label":"Grayscale cited \u201csweet spot\u201d allocation","value":"~5%"}],"primary_claim":"If an investor holds only one cryptocurrency, the article says Bitcoin (CRYPTO: BTC) is overwhelmingly the best choice.","relevance_score":0.2,"sentiment":"positive","source_quality":"high","summary":"The article argues that investors should hold just one cryptocurrency and that Bitcoin (BTC) is the preferred choice over other cryptocurrencies. It cites portfolio research suggesting small BTC allocations can improve returns with manageable downside risk.","topics":["cryptocurrency investing","Bitcoin allocation","portfolio performance","risk/volatility","altcoin comparison"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsMost cryptocurrencies aren't worth buying.","tickers":[],"title":"The Case for Owning Just 1 Cryptocurrency -- and Which One It Should Be","url":"https://www.fool.com/investing/2026/04/08/the-case-for-owning-just-one-cryptocurrency-and-wh/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_540c582ec23f in signals