Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 23742 in events
seq
Primary key.
INTEGER
id
evt_9a7e994f5003
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-11T16:37:42.165562+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-11T10:38:56.745219+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:5c2c07190adfea8f","evidence_event_ids":["evt_e309329c25e7"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/cryptocurrency-legitimate-part-long-term-investment-portfolio","as_of":"2026-04-11T10:38:56.745219+00:00","canonical_url":"https://www.fool.com/investing/2026/04/11/is-cryptocurrency-a-legitimate-part-of-a-long-term/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/cryptocurrency-legitimate-part-long-term-investment-portfolio","article_chars":3546,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f56d57eb11910f70","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/11/is-cryptocurrency-a-legitimate-part-of-a-long-term/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T16:37:42.165519+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsMost experts consider crypto to be a legitimate asset class.","fetched_title":"Is Cryptocurrency a Legitimate Part of a Long-Term Investment Portfolio? | Nasdaq","final_url":"https://www.nasdaq.com/articles/cryptocurrency-legitimate-part-long-term-investment-portfolio","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/cryptocurrency-legitimate-part-long-term-investment-portfolio","source_event_id":"evt_e309329c25e7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b975b3c7408c3e1f","kind":"unusual_volume","published_at":"2026-04-11T09:32:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2025","2026","December 17, 2004","April 15, 2005","April 11, 2026"],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"high","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"crypto","name":"Solana","relevance":"medium","symbol":"SOL","type":"cryptocurrency"},{"asset_class":"company","name":"Bitwise","relevance":"medium","symbol":"","type":"asset manager"},{"asset_class":"media/investment service","name":"Motley Fool Stock Advisor","relevance":"low","symbol":"","type":"investment service"}],"event_type":"other","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided text contains no volume ratio, baseline volume, direction (up/down), or ticker tied to unusual trading volume.","No explicit confirmation is provided that any unusual volume event occurred; the article is a general discussion of crypto portfolio legitimacy rather than a market-volume report.","The article does not provide a specific catalyst hypothesis for any price/volume move; it focuses on advisor survey findings and asset legitimacy criteria."],"key_facts":["The article states that most experts consider crypto a legitimate asset class.","It cites a 2026 Bitwise survey: 32% of financial advisors polled allocated crypto in client accounts in 2025, and 99% planned to maintain or increase exposure.","It says 83% of professional investment advisors who allocate keep crypto exposure under 5%, with a 2% allocation as a starting point.","The article identifies Bitcoin as having the deepest liquidity and the biggest regulated investment vehicles, including spot Bitcoin ETFs.","It states Ethereum and Solana are also generally endorsed, each backed by spot ETFs and with growing institutional interest.","It claims that professional interest drops off quickly below Bitcoin/Ethereum/Solana and advises most investors to do the same.","It says volatility alone does not disqualify an asset; the disqualifier for smaller tokens is typically lack of a strong investment thesis.","It advises investors to keep crypto fairly small, anchor it in Bitcoin, and avoid speculative tokens."],"numeric_claims":[{"label":"Bitwise survey: advisors allocating crypto in 2025","value":"32%"},{"label":"Bitwise survey: advisors planning to maintain or increase exposure","value":"99%"},{"label":"Advisors keeping exposure under 5%","value":"83%"},{"label":"Starting-point allocation","value":"2%"},{"label":"Crypto exposure under 5% (stated as typical)","value":"under 5%"}],"primary_claim":"Bitcoin (along with Ethereum and Solana) is presented as the most widely accepted crypto for long-term portfolio inclusion, while smaller altcoins and meme coins are generally not recommended for heavy investment.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues that crypto is increasingly viewed as a legitimate long-term asset class, citing a 2026 Bitwise survey of advisors. It recommends limiting crypto exposure and focusing on Bitcoin, with Ethereum and Solana also described as broadly endorsed, while smaller tokens are discouraged.","topics":["cryptocurrency","portfolio allocation","financial advisors","Bitcoin","Ethereum","Solana","ETFs","volatility","altcoins","meme coins"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsMost experts consider crypto to be a legitimate asset class.","tickers":[],"title":"Is Cryptocurrency a Legitimate Part of a Long-Term Investment Portfolio?","url":"https://www.fool.com/investing/2026/04/11/is-cryptocurrency-a-legitimate-part-of-a-long-term/"}}
TEXT NOT NULL
source_ref
candidate:sc_f56d57eb11910f70
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:5c2c07190adfea8f
TEXT
episode_id
NULL
TEXT
created_at
2026-04-11T16:37:42.165609+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel