SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/","as_of":"2026-04-04T18:48:42.386550+00:00","canonical_url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/","enrichment":{"aggregator_url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_86e50dfdb2a61f51","canonical_host":"coinmarketcap.com","canonical_is_aggregator":false,"canonical_url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-05T00:38:44.118097+00:00","extraction_method":"heuristic","fetched_description":"Latest ZKsync News - Discover Market Trends, Price Updates, and Insights on the Future of ZKsync for Traders and Investors.","fetched_title":"Latest ZKsync News - (ZK) Future Outlook, Trends & Market Insights","final_url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/","html_truncated":true,"paywall_likely":false,"publisher_domain":"coinmarketcap.com","publisher_resolution":"canonical_url","requested_url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/","source_event_id":"evt_2fe9aca6ba7a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e3c4e12c65415cbb","published_at":"","publisher_domain":"coinmarketcap.com","query":"Starknet has market conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-02-01","2026-03-26","2026-03-27"],"entities":[{"asset_class":"crypto","name":"ZKsync","relevance":"high","symbol":"ZK","type":"cryptocurrency"},{"asset_class":"financial services","name":"BitGo","relevance":"high","symbol":"","type":"company"}],"event_type":"research","information_gaps":["No specific details on the success of the BitGo partnership's pilot programs are provided.","Current daily activity metrics for ZKsync are mentioned but lack historical context for comparison."],"key_facts":["ZKsync Lite deprecation date is set for May 4, 2026.","ZKsync has partnered with BitGo for a tokenization platform targeting banks.","Analysts highlight ZKsync's scalability and security as key strengths."],"numeric_claims":[{"label":"ZKsync Lite deprecation date","value":"May 4, 2026"},{"label":"Total Value Locked (TVL)","value":"$44.5M"}],"primary_claim":"ZKsync Lite will sunset on May 4, 2026, as the project shifts focus to the ZKsync Era.","relevance_score":0.85,"sentiment":"positive","source_quality":"high","summary":"ZKsync is set to deprecate its legacy rollup on May 4, 2026, focusing on the ZKsync Era, while recent partnerships and analyst coverage highlight its growth potential despite current price challenges.","topics":["ZKsync","cryptocurrency","blockchain","institutional adoption"]},"snippet":"ZKsync Lite Deprecation Date Set (27 February 2026) \u2013 Confirms the legacy rollup will sunset on 4 May 2026, focusing resources on the modern ZKsync Era. Deep ...","source":"web_search","source_domain":"coinmarketcap.com","summary":"ZKsync Lite Deprecation Date Set (27 February 2026) \u2013 Confirms the legacy rollup will sunset on 4 May 2026, focusing resources on the modern ZKsync Era. Deep ...","title":"Latest ZKsync (ZK) News Update - CoinMarketCap","url":"https://coinmarketcap.com/cmc-ai/zksync/latest-updates/"}

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