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-18T15:49:14.474663+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:88bf50fc3a7053bb","evidence_event_ids":["evt_74e8e7c27654"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/you-do-not-have-pick-next-bitcoin-profit-crypto-here-simpler-play","as_of":"2026-04-18T15:49:14.474663+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/you-do-not-have-to-pick-the-next-bitcoin-to-profit/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/you-do-not-have-pick-next-bitcoin-profit-crypto-here-simpler-play","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e18f8847c3caff75","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/you-do-not-have-to-pick-the-next-bitcoin-to-profit/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T16:20:04.717340+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsPicking cryptocurrencies is difficult at best in this still-new arena.","fetched_title":"You Do Not Have to Pick the Next Bitcoin to Profit From Crypto. Here Is the Simpler Play. | Nasdaq","final_url":"https://www.nasdaq.com/articles/you-do-not-have-pick-next-bitcoin-profit-crypto-here-simpler-play","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/you-do-not-have-pick-next-bitcoin-profit-crypto-here-simpler-play","source_event_id":"evt_74e8e7c27654","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"38fdfdffa7f4c767","kind":"unusual_volume","published_at":"2026-04-18T14:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2025","five years ago","three months later","December 17, 2004","April 15, 2005","April 18, 2026"],"entities":[{"asset_class":"equity","name":"Coinbase Global","relevance":"high","symbol":"COIN","type":"company"},{"asset_class":"crypto","name":"Bitcoin","relevance":"medium","symbol":"BTC","type":"asset"},{"asset_class":"crypto","name":"Ethereum","relevance":"low","symbol":"ETH","type":"asset"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"other","information_gaps":["No unusual trading volume delta details are provided in the text (no volume ratio vs average, no baseline volume, no direction, and no explicit confirmation of unusual volume).","The signal\u2019s catalyst hypothesis for unusual volume is not described; the article is primarily a strategy/business-model discussion rather than a market-microstructure event."],"key_facts":["Coinbase generates revenue from trading, custody, and services (as stated in the article).","The article claims Coinbase holds about 12% of all crypto in custody globally.","The article states Coinbase generated about $4.1 billion in transaction revenue in 2025.","The article states Coinbase generated $2.8 billion from other subscription and services revenue.","The article says Coinbase depends heavily on trading activity, which can fluctuate with market conditions.","The article notes that if crypto prices collapse, traders may be less inclined to trade.","The article states that investing in the whole ecosystem removes the need to select winning individual tokens."],"numeric_claims":[{"label":"Custody share (global)","value":"about 12%"},{"label":"Transaction revenue (2025)","value":"about $4.1 billion"},{"label":"Other subscription/services revenue","value":"$2.8 billion"},{"label":"Bitcoin return example (5 years ago)","value":"less than 11%"},{"label":"Bitcoin return example (3 months later)","value":"just under 100%"}],"primary_claim":"Coinbase Global (NASDAQ: COIN) can be a simpler way to gain exposure to crypto because it benefits as users continue to buy, sell, and hold crypto, generating transaction and services revenue.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The article argues that investors can gain crypto exposure without selecting individual tokens by investing in Coinbase (COIN), a major crypto exchange/custody platform. It discusses Coinbase\u2019s revenue sources and dependence on overall crypto participation and trading activity.","topics":["crypto investing strategy","Coinbase business model","crypto market exposure","custody and exchange platforms","investment risk/volatility"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsPicking cryptocurrencies is difficult at best in this still-new arena.","tickers":[],"title":"You Do Not Have to Pick the Next Bitcoin to Profit From Crypto. Here Is the Simpler Play.","url":"https://www.fool.com/investing/2026/04/18/you-do-not-have-to-pick-the-next-bitcoin-to-profit/"}}

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