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-03T17:11:20.073868+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:85fb6558f208137a","evidence_event_ids":["evt_188725577f4c"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/gdx-vs-slvp-gold-or-silver-which-mining-etf-better-buy-investors","as_of":"2026-04-03T17:11:20.073868+00:00","canonical_url":"https://www.fool.com/coverage/etfs/2026/04/03/gdx-vs-slvp-gold-or-silver-which-mining-etf-is-the-better-buy-for-investors/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/gdx-vs-slvp-gold-or-silver-which-mining-etf-better-buy-investors","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e31286e6eaf9afa1","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/etfs/2026/04/03/gdx-vs-slvp-gold-or-silver-which-mining-etf-is-the-better-buy-for-investors/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-03T23:38:59.997017+00:00","extraction_method":"heuristic","fetched_description":"Key PointsSLVP has outperformed GDX over the past year, charges lower fees, and pays a higher dividend.","fetched_title":"GDX vs. SLVP: Gold or Silver -- Which Mining ETF Is the Better Buy for Investors? | Nasdaq","final_url":"https://www.nasdaq.com/articles/gdx-vs-slvp-gold-or-silver-which-mining-etf-better-buy-investors","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/gdx-vs-slvp-gold-or-silver-which-mining-etf-better-buy-investors","source_event_id":"evt_188725577f4c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"525f7fa75eee6a8f","kind":"unusual_volume","published_at":"2026-04-03T15:51:30+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 03, 2026"],"entities":[{"asset_class":"mining","name":"GDX","relevance":"high","symbol":"GDX","type":"ETF"},{"asset_class":"mining","name":"SLVP","relevance":"high","symbol":"SLVP","type":"ETF"}],"event_type":"other","information_gaps":["No specific volume data provided for unusual volume delta."],"key_facts":["SLVP 1-year return: 150.6%","GDX 1-year return: 108.2%","SLVP expense ratio: 0.39%","GDX expense ratio: 0.51%","SLVP dividend yield: 1.3%","GDX dividend yield: 0.6%"],"numeric_claims":[{"label":"SLVP 1-year return","value":"150.6%"},{"label":"GDX 1-year return","value":"108.2%"},{"label":"SLVP expense ratio","value":"0.39%"},{"label":"GDX expense ratio","value":"0.51%"},{"label":"SLVP dividend yield","value":"1.3%"},{"label":"GDX dividend yield","value":"0.6%"}],"primary_claim":"SLVP has outperformed GDX over the past year, charges lower fees, and pays a higher dividend.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"The article compares the performance and characteristics of two mining ETFs, GDX and SLVP, highlighting SLVP's recent outperformance and lower fees, while GDX is noted for its stability and larger size.","topics":["ETF comparison","mining","investment strategy"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsSLVP has outperformed GDX over the past year, charges lower fees, and pays a higher dividend.","tickers":[],"title":"GDX vs. SLVP: Gold or Silver -- Which Mining ETF Is the Better Buy for Investors?","url":"https://www.fool.com/coverage/etfs/2026/04/03/gdx-vs-slvp-gold-or-silver-which-mining-etf-is-the-better-buy-for-investors/"}}

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