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/bull-case-bitcoin-has-nothing-do-price-predictions","as_of":"2026-04-06T18:42:37.816572+00:00","canonical_url":"https://www.fool.com/investing/2026/04/06/the-bull-case-for-bitcoin-that-has-nothing-to-do-w/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bull-case-bitcoin-has-nothing-do-price-predictions","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c57f412e4657d291","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/06/the-bull-case-for-bitcoin-that-has-nothing-to-do-w/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T12:32:38.655585+00:00","extraction_method":"heuristic","fetched_description":"Key PointsThere are a few different (but still valid) investment theses for buying Bitcoin.","fetched_title":"The Bull Case for Bitcoin That Has Nothing to Do With Price Predictions | Nasdaq","final_url":"https://www.nasdaq.com/articles/bull-case-bitcoin-has-nothing-do-price-predictions","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bull-case-bitcoin-has-nothing-do-price-predictions","source_event_id":"evt_a6d8112f1ebd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"488718ba3a416874","kind":"unusual_volume","published_at":"2026-04-06T17:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2024","2025","2026"],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"}],"event_type":"other","information_gaps":["No specific volume data provided.","No unusual volume ratio mentioned."],"key_facts":["Bitcoin is recognized as a store of value that no government can control.","Demand for Bitcoin increases in response to geopolitical financial restrictions."],"numeric_claims":[],"primary_claim":"Bitcoin serves as a neutral settlement layer outside any country's banking system, creating persistent demand.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"The article discusses investment theses for Bitcoin, emphasizing its role as a neutral store of value in a polarized world, rather than focusing on price predictions.","topics":["Bitcoin","investment","neutral money","financial infrastructure"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThere are a few different (but still valid) investment theses for buying Bitcoin.","tickers":[],"title":"The Bull Case for Bitcoin That Has Nothing to Do With Price Predictions","url":"https://www.fool.com/investing/2026/04/06/the-bull-case-for-bitcoin-that-has-nothing-to-do-w/"}

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_a75f568552fd in signals