Create
Query
event_store.db
—
signals
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 sig_4476e819677a in signals
id
sig_4476e819677a
Primary key.
TEXT
event_id
10957
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/bitcoin-vs-ethereum-which-crypto-better-buy-2026","as_of":"2026-04-09T10:38:52.980302+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/bitcoin-vs-ethereum-crypto-better-buy-2026/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bitcoin-vs-ethereum-which-crypto-better-buy-2026","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_124329aca338dee9","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/bitcoin-vs-ethereum-crypto-better-buy-2026/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:12:46.122310+00:00","extraction_method":"heuristic","fetched_description":"Key PointsBitcoin\u2019s key properties, such as decentralization and scarcity, position it as an entirely new monetary system.","fetched_title":"Bitcoin vs. Ethereum: Which Crypto Is the Better Buy in 2026? | Nasdaq","final_url":"https://www.nasdaq.com/articles/bitcoin-vs-ethereum-which-crypto-better-buy-2026","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bitcoin-vs-ethereum-which-crypto-better-buy-2026","source_event_id":"evt_cf678b45bce7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1d58fa66075ab909","kind":"unusual_volume","published_at":"2026-04-09T09:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2026","05:50 am EDT","April 1","2015"],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"crypto_asset"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"high","symbol":"ETH","type":"crypto_asset"},{"asset_class":"media","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"person","name":"Neil Patel","relevance":"medium","symbol":"","type":"author"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company_mentioned"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company_mentioned"},{"asset_class":"company","name":"BlackRock","relevance":"low","symbol":"","type":"company_mentioned"},{"asset_class":"company","name":"JPMorgan Chase","relevance":"low","symbol":"","type":"company_mentioned"},{"asset_class":"cryptocurrency","name":"Solana","relevance":"medium","symbol":"","type":"crypto_asset_mentioned"}],"event_type":"other","information_gaps":["No unusual volume delta information is present in the provided text (no tickers for equities/crypto beyond BTC/ETH, no volume ratio vs average, and no direction).","No explicit catalyst tied to unusual volume is described; the article is primarily an investment thesis rather than a market microstructure/volume event.","The signal type suggests a volume anomaly, but the article content provided does not contain the required volume metrics."],"key_facts":["The article is dated April 09, 2026 (05:50 am EDT) and written by Neil Patel for The Motley Fool.","Bitcoin is described as decentralized with no single entity in control and as scarce with a maximum supply of 21 million Bitcoins.","Bitcoin is described as divisible to eight decimal places.","The article compares Bitcoin to fiat monetary systems and argues it is a competitor to fiat due to issues like currency debasement and rising debt.","The article states Bitcoin\u2019s price has increased 16,200% over the past 10 years (as of April 1).","Ethereum is described as a decentralized global computing network launched in 2015 and as the first blockchain to introduce smart contracts.","The article states Ethereum is the leader in DeFi with $55 billion in total value locked, described as nine times higher than Solana.","The article mentions Ethereum tokenization of real-world assets (RWA) and cites traditional finance firms (BlackRock and JPMorgan Chase) launching RWA projects.","The article cites ARK Invest\u2019s Big Ideas 2026 report, stating Ethereum\u2019s market cap could rise at a 54% compound annual growth rate throughout the rest of the decade.","The article concludes that Bitcoin is the clear winner as the best crypto to buy in 2026, citing Bitcoin\u2019s simpler structure."],"numeric_claims":[{"label":"Bitcoin price increase (10 years, as of April 1)","value":"16,200%"},{"label":"Ethereum price increase (10 years)","value":"18,030%"},{"label":"Bitcoin maximum supply","value":"21 million"},{"label":"Bitcoin divisibility","value":"8 decimal places"},{"label":"Ethereum DeFi total value locked","value":"$55 billion"},{"label":"Ethereum DeFi TVL vs Solana","value":"9x higher"},{"label":"ARK Invest forecast: Ethereum market cap CAGR (rest of decade)","value":"54%"}],"primary_claim":"Bitcoin is presented as the clear winner and the better cryptocurrency to buy in 2026 compared with Ethereum.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool article argues that Bitcoin is the clearer long-term crypto buy in 2026 versus Ethereum, citing Bitcoin\u2019s scarcity/decentralization and Ethereum\u2019s role in smart contracts/DeFi. It does not provide any unusual trading volume data or a volume-vs-average ratio.","topics":["crypto investing","Bitcoin vs Ethereum","scarcity and decentralization","smart contracts","DeFi","tokenization of real-world assets","market cap forecast (ARK Invest)"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsBitcoin\u2019s key properties, such as decentralization and scarcity, position it as an entirely new monetary system.","tickers":[],"title":"Bitcoin vs. Ethereum: Which Crypto Is the Better Buy in 2026?","url":"https://www.fool.com/investing/2026/04/09/bitcoin-vs-ethereum-crypto-better-buy-2026/"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_cf678b45bce7"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:3f47aafc9cde354d
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-09T10:38:52.980302+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel