SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks","as_of":"2026-04-21T16:48:38.963204+00:00","canonical_url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks","article_chars":339,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c8f4d1273da3e4f9","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:53:54.557888+00:00","extraction_method":"trafilatura","fetched_description":"In trading on Tuesday, precious metals shares were relative laggards, down on the day by about 3.9%. Helping drag down the group were shares of Hycroft Mining Holding, down about 9.3% and shares of Perpetua Resources off about 6.7% on the day.Also lagging the market Tuesday a","fetched_title":"Tuesday Sector Laggards: Precious Metals, Defense Stocks | Nasdaq","final_url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks","source_event_id":"evt_248fd80af904","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"9a9ad37b533631fc","kind":"new_listings","published_at":"2026-04-21T16:14:24+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.64,"dates_mentioned":["Tuesday"],"entities":[{"asset_class":"equity","name":"Hycroft Mining Holding","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Perpetua Resources","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Northrop Grumman","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"L3Harris Technologies","relevance":"high","symbol":"","type":"company"}],"event_type":"price_action","information_gaps":["No standardized ticker symbols are provided in the text.","The signal type mentions 'new_listings_delta', but the provided text only describes relative laggards and does not mention any new listings.","The excerpt is truncated after 'Also lagging the market Tuesday a', so additional context may be missing.","No market index or benchmark definition is provided for 'relative laggards'."],"key_facts":["Precious metals shares were down on the day by about 3.9%.","Hycroft Mining Holding shares were down about 9.3% on the day.","Perpetua Resources shares were off about 6.7% on the day.","Defense shares were down on the day by about 2.8% as a group.","Northrop Grumman shares were trading lower by about 6.2%.","L3Harris Technologies shares were trading lower by about 3%."],"numeric_claims":[{"label":"Precious metals group daily move (%)","value":"-3.9%"},{"label":"Hycroft Mining Holding daily move (%)","value":"-9.3%"},{"label":"Perpetua Resources daily move (%)","value":"-6.7%"},{"label":"Defense group daily move (%)","value":"-2.8%"},{"label":"Northrop Grumman daily move (%)","value":"-6.2%"},{"label":"L3Harris Technologies daily move (%)","value":"-3%"}],"primary_claim":"Precious metals shares were down about 3.9% on Tuesday, with Hycroft Mining Holding down about 9.3% and Perpetua Resources down about 6.7%, while defense shares fell about 2.8% led by Northrop Grumman (-6.2%) and L3Harris Technologies (-3%).","relevance_score":0.42,"sentiment":"negative","source_quality":"low","summary":"On Tuesday, precious metals and defense stocks were relative laggards. Precious metals fell about 3.9% with Hycroft Mining Holding down about 9.3% and Perpetua Resources down about 6.7%, while defense shares fell about 2.8% led by Northrop Grumman (-6.2%) and L3Harris Technologies (-3%).","topics":["precious metals stocks","defense stocks","market laggards","daily performance"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"In trading on Tuesday, precious metals shares were relative laggards, down on the day by about 3.9%. Helping drag down the group were shares of Hycroft Mining Holding, down about 9.3% and shares of Perpetua Resources off about 6.7% on the day. Also lagging the market Tuesday a","tickers":[],"title":"Tuesday Sector Laggards: Precious Metals, Defense Stocks","url":"https://www.nasdaq.com/articles/tuesday-sector-laggards-precious-metals-defense-stocks"}

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