SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3","as_of":"2026-04-03T12:37:56.088827+00:00","canonical_url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3","enrichment":{"aggregator_url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d9090ff700f08a25","canonical_host":"cryptorank.io","canonical_is_aggregator":false,"canonical_url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T00:58:35.972421+00:00","extraction_method":"heuristic","fetched_description":"BitcoinWorld Silver Price Forecast: XAG/USD Plunges to $72.00 as Safe-Haven Appeal Evaporates Global silver markets witnessed a significant correction on","fetched_title":"Silver Price Forecast: XAG/USD Plunges to $72.00 as Safe-Haven Appeal Evaporates","final_url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3","html_truncated":true,"paywall_likely":false,"publisher_domain":"cryptorank.io","publisher_resolution":"canonical_url","requested_url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3","source_event_id":"evt_0379f73558c9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f3901715d523a065","published_at":"","publisher_domain":"cryptorank.io","query":"silver real yields dollar positioning central bank demand update","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["Thursday"],"entities":[{"asset_class":"precious metal","name":"Silver","relevance":"high","symbol":"XAG/USD","type":"commodity"}],"event_type":"price_action","information_gaps":["No specific date for the price drop was provided.","Details on the broader financial conditions affecting silver demand are not fully explained."],"key_facts":["XAG/USD fell to $72.00 per ounce.","Trading volumes spiked by approximately 35% above the 30-day average.","Critical support is at the 100-day simple moving average around $70.80."],"numeric_claims":[{"label":"Current Price","value":"$72.00"},{"label":"Volume Increase","value":"35%"},{"label":"Critical Support Level","value":"$70.80"}],"primary_claim":"The XAG/USD pair has fallen to $72.00, marking a significant correction in the silver market.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Silver prices have sharply declined to $72.00 per ounce due to a significant drop in safe-haven demand, with trading volumes increasing by 35% above the 30-day average.","topics":["silver","price action","market analysis"]},"snippet":"BitcoinWorld Silver Price Forecast: XAG/USD Plunges to $72.00 as Safe-Haven Appeal Evaporates Global silver markets witnessed a significant correction on.","source":"web_search","source_domain":"cryptorank.io","summary":"BitcoinWorld Silver Price Forecast: XAG/USD Plunges to $72.00 as Safe-Haven Appeal Evaporates Global silver markets witnessed a significant correction on.","title":"Silver Price Forecast: XAG/USD Plunges to $72.00 as Safe-Haven ...","url":"https://cryptorank.io/news/feed/c2ff0-silver-price-forecast-xag-usd-falls-3"}

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