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-03T22:02:10.910615+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:1ad44f27e6d49c53","evidence_event_ids":["evt_431e1918233e"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.mexc.com/news/1002141","as_of":"2026-04-03T22:02:10.910615+00:00","canonical_url":"https://www.mexc.com/news/1002141","enrichment":{"aggregator_url":"https://www.mexc.com/news/1002141","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7e555c85156da59e","canonical_host":"mexc.com","canonical_is_aggregator":false,"canonical_url":"https://www.mexc.com/news/1002141","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T01:29:44.274657+00:00","extraction_method":"heuristic","fetched_description":"BitcoinWorld Silver Price Forecasts: XAG/USD Faces Critical $75.00 Resistance as Bullish Momentum Hangs in the Balance Silver price forecasts for early 2025 highlight","fetched_title":"Silver Price Forecasts: XAG/USD Faces Critical $75.00 Resistance as Bullish Momentum Hangs in the Balance | MEXC News","final_url":"https://www.mexc.com/news/1002141","html_truncated":true,"paywall_likely":false,"publisher_domain":"mexc.com","publisher_resolution":"canonical_url","requested_url":"https://www.mexc.com/news/1002141","source_event_id":"evt_431e1918233e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0658af927d217ec9","published_at":"","publisher_domain":"mexc.com","query":"silver inflation growth risk policy catalyst next 14 days","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2025"],"entities":[{"asset_class":"precious metals","name":"XAG/USD","relevance":"high","symbol":"XAG/USD","type":"currency_pair"}],"event_type":"research","information_gaps":["No specific date for the next potential breakout or correction is provided.","Details on the exact macroeconomic conditions influencing the silver price are not specified."],"key_facts":["XAG/USD has tested the $75.00 resistance level three times in six weeks.","The Relative Strength Index (RSI) has retreated from overbought territory near 70 during these tests.","The 50-day and 200-day moving averages are at $68.50 and $64.00, respectively, indicating underlying support."],"numeric_claims":[{"label":"Resistance level tested","value":"3 times"},{"label":"RSI level during tests","value":"near 70"},{"label":"50-day moving average","value":"$68.50"},{"label":"200-day moving average","value":"$64.00"}],"primary_claim":"The $75.00 level for XAG/USD is a significant resistance zone that has been tested multiple times without a successful breakout.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"The XAG/USD silver price is facing critical resistance at $75.00, which has been tested three times in the past six weeks without a decisive close above it, indicating strong selling interest. Key indicators suggest a fragile bullish momentum, influenced by macroeconomic factors and institutional interest.","topics":["silver price","technical analysis","market trends","macroeconomic factors"]},"snippet":"The silver price forecast remains at a critical inflection point, with the XAG/USD pair's struggle against the $75.00 resistance level serving as the central ...","source":"web_search","source_domain":"mexc.com","summary":"The silver price forecast remains at a critical inflection point, with the XAG/USD pair's struggle against the $75.00 resistance level serving as the central ...","title":"Silver Price Forecasts: XAG/USD Faces Critical $75.00 Resistance ...","url":"https://www.mexc.com/news/1002141"}}

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