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/hogs-see-mixed-monday-action","as_of":"2026-04-21T16:48:38.963204+00:00","canonical_url":"https://www.barchart.com/story/news/1421981/hogs-see-mixed-monday-action","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/hogs-see-mixed-monday-action","article_chars":1317,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_519237643b2d2d46","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1421981/hogs-see-mixed-monday-action","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:54:12.298861+00:00","extraction_method":"trafilatura","fetched_description":"Lean hog futures saw gains of 10 to 82 cents in the front months on Monday, with deferreds steady to 27 cents lower. Open interest was down 11,962 contracts on Monday. USDA\u2019s national base hog price was reported at $92.13 on Monday afternoon, up $1.85 from the previous day. The...","fetched_title":"Hogs See Mixed Monday Action | Nasdaq","final_url":"https://www.nasdaq.com/articles/hogs-see-mixed-monday-action","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/hogs-see-mixed-monday-action","source_event_id":"evt_0740f033f411","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"4e4c6dd06a2982cc","kind":"new_listings","published_at":"2026-04-21T16:05:32+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Monday","April 16"],"entities":[{"asset_class":"commodity_futures","name":"Lean hog futures (front months)","relevance":"high","symbol":"","type":"market"},{"asset_class":"commodity_futures","name":"Lean hog futures (deferred months)","relevance":"high","symbol":"","type":"market"},{"asset_class":"commodity_indicator","name":"USDA national base hog price","relevance":"high","symbol":"","type":"economic_indicator"},{"asset_class":"commodity_indicator","name":"CME Lean Hog Index","relevance":"medium","symbol":"","type":"economic_indicator"},{"asset_class":"commodity_indicator","name":"USDA pork carcass cutout value","relevance":"medium","symbol":"","type":"economic_indicator"},{"asset_class":"commodity_futures","name":"May 26 Hogs","relevance":"medium","symbol":"","type":"futures_contract"},{"asset_class":"commodity_futures","name":"Jun 26 Hogs","relevance":"medium","symbol":"","type":"futures_contract"},{"asset_class":"commodity_futures","name":"Jul 26 Hogs","relevance":"medium","symbol":"","type":"futures_contract"}],"event_type":"price_action","information_gaps":["The signal type is labeled discovery_new_listings_delta, but the provided text contains no explicit information about new listings; it only describes price action and USDA/CME indicators.","No specific symbols/tickers for the hog futures contracts are provided in the text.","The article excerpt does not include the full list of which deferred months were lower/steady, only the range described (steady to 27 cents lower).","The excerpt does not state the exact date corresponding to 'Monday' (only 'Monday' is referenced)."],"key_facts":["Front-month lean hog futures gained 10 to 82 cents on Monday.","Deferred lean hog futures were steady to 27 cents lower.","Open interest decreased by 11,962 contracts on Monday.","USDA national base hog price was $92.13 on Monday afternoon, up $1.85 from the previous day.","CME Lean Hog Index was down 15 cents on April 16 at $90.51.","USDA pork carcass cutout value (Monday PM report) increased $1.00 to $100.20 per cwt.","Butt and rib primals were the only reported lower items.","USDA estimated Monday\u2019s federally inspected hog slaughter at 492,000 head.","Monday slaughter was even with the previous week and 149,980 head above the same week last year.","May 26 Hogs closed at $94.225, up $0.825.","Jun 26 Hogs closed at $101.725, up $0.675.","Jul 26 Hogs closed at $104.000, up $0.325."],"numeric_claims":[{"label":"Front-month gains (cents)","value":"10 to 82"},{"label":"Deferred change (cents)","value":"steady to 27 lower"},{"label":"Open interest change (contracts)","value":"-11,962"},{"label":"USDA national base hog price ($)","value":"92.13"},{"label":"USDA base hog price change ($)","value":"+1.85"},{"label":"CME Lean Hog Index ($)","value":"90.51"},{"label":"CME Lean Hog Index change (cents)","value":"-15"},{"label":"Pork carcass cutout value ($/cwt)","value":"100.20"},{"label":"Cutout value change ($/cwt)","value":"+1.00"},{"label":"Federally inspected hog slaughter (head)","value":"492,000"},{"label":"May 26 Hogs close ($)","value":"94.225"},{"label":"May 26 Hogs change ($)","value":"+0.825"},{"label":"Jun 26 Hogs close ($)","value":"101.725"},{"label":"Jun 26 Hogs change ($)","value":"+0.675"},{"label":"Jul 26 Hogs close ($)","value":"104.000"},{"label":"Jul 26 Hogs change ($)","value":"+0.325"}],"primary_claim":"Front-month lean hog futures gained 10 to 82 cents on Monday while deferred contracts were steady to 27 cents lower.","relevance_score":0.62,"sentiment":"mixed","source_quality":"medium","summary":"Lean hog futures were mixed on Monday: front-month contracts rose while deferreds were mostly lower. USDA\u2019s national base hog price increased to $92.13, and open interest fell by 11,962 contracts.","topics":["lean hog futures","open interest","USDA base hog price","CME Lean Hog Index","pork carcass cutout value","federally inspected hog slaughter"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Lean hog futures saw gains of 10 to 82 cents in the front months on Monday, with deferreds steady to 27 cents lower. Open interest was down 11,962 contracts on Monday. USDA\u2019s national base hog price was reported at $92.13 on Monday afternoon, up $1.85 from the previous day. The...","tickers":[],"title":"Hogs See Mixed Monday Action","url":"https://www.barchart.com/story/news/1421981/hogs-see-mixed-monday-action"}

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