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-rallying-back-tuesday","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://www.barchart.com/story/news/30763251/hogs-rallying-back-on-tuesday","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/hogs-rallying-back-tuesday","article_chars":1734,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e7308c035c1ea419","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/30763251/hogs-rallying-back-on-tuesday","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T00:00:36.848334+00:00","extraction_method":"trafilatura","fetched_description":"Lean hog futures are pushing back following limit losses on Monday, with contracts up $1.02 ti $3.47 at midday, with today having expanded limits of $6. The national average base hog negotiated price was not reported on Tuesday morning due to low volume, with the 5-day rolling average at $83.92....","fetched_title":"Hogs Rallying Back on Tuesday | Nasdaq","final_url":"https://www.nasdaq.com/articles/hogs-rallying-back-tuesday","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/hogs-rallying-back-tuesday","source_event_id":"evt_5099db9470da","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"ece1536a58fc8159","kind":"new_listings","published_at":"2026-04-21T19:22:47+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.66,"dates_mentioned":["Tuesday","Monday","January 31","April 17"],"entities":[{"asset_class":"futures","name":"Lean hog futures (front months)","relevance":"high","symbol":"HOG","type":"asset"},{"asset_class":"commodity_indicator","name":"USDA national average base hog negotiated price","relevance":"medium","symbol":"","type":"indicator"},{"asset_class":"commodity_indicator","name":"CME Lean Hog Index","relevance":"medium","symbol":"","type":"indicator"},{"asset_class":"commodity_indicator","name":"USDA FOB plant pork cutout value","relevance":"medium","symbol":"","type":"indicator"},{"asset_class":"livestock_statistic","name":"Federally inspected hog slaughter","relevance":"medium","symbol":"","type":"statistic"},{"asset_class":"other","name":"Austin Schroeder","relevance":"low","symbol":"","type":"person"}],"event_type":"price_action","information_gaps":["The signal type guidance mentions discovery_new_listings_delta, but the provided text does not describe any new listings; it focuses on price action and USDA/CME indicators.","The article excerpt includes conflicting/unclear numeric context between the provided Source Summary and the cleaned Article Text (e.g., different CME Lean Hog Index values and different base hog price figures).","No standardized ticker symbols for the specific hog futures contracts are provided in the text (only month/year and prices).","The excerpt truncates after 'USDA\u2019s pork carcass cutout value from...' in the Source Summary; additional cutout details are not fully present in the cleaned text."],"key_facts":["Lean hog futures rebounded after Monday\u2019s limit losses, with contracts up $1.02 to $3.47 at midday.","The article states that today\u2019s expanded limits are $6.","The national average base hog negotiated price was not reported on Tuesday morning due to low volume; the 5-day rolling average was $83.92.","The CME Lean Hog Index was reported at $83.77 on January 31, up 29 cents from the previous day.","The article says tariff threat on Mexico and Canada has been put on the back burner for now.","The article says pork missed out on the Chinese retaliatory action overnight.","USDA\u2019s FOB plant pork cutout value was 78 cents higher in the Tuesday AM report at $94.59 per cwt.","The belly was the only primal reported lower.","Federally inspected hog slaughter for Monday was estimated at 491,000 head.","The slaughter estimate was 8,000 head above Monday but up 2,772 head from the same Monday last year.","Contract prices listed: Feb 25 Hogs at $85.350 (up $1.025); Apr 25 Hogs at $89.825 (up $3.475); May 25 Hogs at $93.775 (up $3.050).","Disclosure statement: Austin Schroeder did not have positions in any securities mentioned (as stated in the article)."],"numeric_claims":[{"label":"Lean hog futures move at midday","value":"up $1.02 to $3.47"},{"label":"Expanded daily limits","value":"$6"},{"label":"5-day rolling average base hog negotiated price","value":"$83.92"},{"label":"CME Lean Hog Index (Jan 31)","value":"$83.77"},{"label":"CME Lean Hog Index daily change","value":"+29 cents"},{"label":"USDA FOB plant pork cutout value (Tuesday AM)","value":"$94.59 per cwt"},{"label":"USDA FOB plant pork cutout change","value":"+78 cents"},{"label":"Federally inspected hog slaughter (Monday estimate)","value":"491,000 head"},{"label":"Slaughter change vs Monday","value":"+8,000 head"},{"label":"Slaughter change vs same Monday last year","value":"+2,772 head"},{"label":"Feb 25 Hogs","value":"$85.350 (up $1.025)"},{"label":"Apr 25 Hogs","value":"$89.825 (up $3.475)"},{"label":"May 25 Hogs","value":"$93.775 (up $3.050)"}],"primary_claim":"Lean hog futures were up $1.02 to $3.47 at midday on Tuesday, with expanded limits of $6, after limit losses on Monday.","relevance_score":0.72,"sentiment":"positive","source_quality":"medium","summary":"Lean hog futures rebounded after Monday\u2019s limit losses, with multiple contracts up sharply at midday and expanded daily limits. USDA and CME hog/pork pricing indicators and slaughter estimates were also reported, alongside a temporary easing of tariff-related concerns.","topics":["lean hog futures","pork cutout","CME Lean Hog Index","USDA base hog price","tariff threat Mexico and Canada","Chinese retaliatory action","hog slaughter estimates","CME/USDA pricing indicators"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Lean hog futures are up 72 cents to $1.45 in the front months on Tuesday after gapping higher. USDA\u2019s national base hog price was reported at $91.73 on Tuesday morning. The CME Lean Hog Index was down 14 cents on April 17 at $90.37. USDA\u2019s pork carcass cutout value from...","tickers":[],"title":"Hogs Rallying Back on Tuesday","url":"https://www.barchart.com/story/news/30763251/hogs-rallying-back-on-tuesday"}

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