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-04T04:50:36.967489+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:ce8304af636e0718","evidence_event_ids":["evt_64cc10b91785"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.mexc.com/news/1000735","as_of":"2026-04-04T04:50:36.967489+00:00","canonical_url":"https://www.mexc.com/news/1000735","enrichment":{"aggregator_url":"https://www.mexc.com/news/1000735","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ba1ee787b9fda353","canonical_host":"mexc.com","canonical_is_aggregator":false,"canonical_url":"https://www.mexc.com/news/1000735","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T04:51:02.664602+00:00","extraction_method":"heuristic","fetched_description":"BitcoinWorld Bitcoin Bottom Confirmed: Prepare for Months of Sideways Trading Before Recovery Bitcoin may trade sideways for months after finding bottom, according","fetched_title":"Bitcoin Bottom Confirmed: Prepare for Months of Sideways Trading Before Recovery | MEXC News","final_url":"https://www.mexc.com/news/1000735","html_truncated":true,"paywall_likely":false,"publisher_domain":"mexc.com","publisher_resolution":"canonical_url","requested_url":"https://www.mexc.com/news/1000735","source_event_id":"evt_64cc10b91785","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bed02001d51babcd","published_at":"","publisher_domain":"mexc.com","query":"bitcoin miner supply onchain activity regulatory catalyst next 14 days","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2025"],"entities":[{"asset_class":"digital asset","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"}],"event_type":"research","information_gaps":["Specific dates for the expected sideways trading period are not provided.","Details on macroeconomic conditions influencing Bitcoin's price are not fully elaborated."],"key_facts":["Long-term holders control approximately 80% of Bitcoin's circulating supply.","Historical patterns show that price bottoms typically form months before the HODL Waves indicator peaks.","Previous bear market bottoms occurred in 2015, 2018, and 2022."],"numeric_claims":[{"label":"Percentage of Bitcoin supply held by long-term holders","value":"80%"},{"label":"Threshold for previous bear market bottoms","value":"85%"}],"primary_claim":"Long-term Bitcoin holders currently control approximately 80% of the total circulating supply, suggesting a potential price floor has been reached.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"Bitcoin is expected to trade sideways for several months after confirming a bottom, based on on-chain data analysis indicating long-term holder behavior.","topics":["Bitcoin","market analysis","on-chain data","long-term holders","trading patterns"]},"snippet":"Bitcoin may trade sideways for months after finding bottom, according to new on-chain data analysis that reveals critical patterns in long-term holder behavior.","source":"web_search","source_domain":"mexc.com","summary":"Bitcoin may trade sideways for months after finding bottom, according to new on-chain data analysis that reveals critical patterns in long-term holder behavior.","title":"Bitcoin Bottom Confirmed: Prepare for Months of Sideways Trading ...","url":"https://www.mexc.com/news/1000735"}}

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