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/cotton-back-strength-tuesdays-midday","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://www.barchart.com/story/news/1429693/cotton-back-to-strength-on-tuesdays-midday","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/cotton-back-strength-tuesdays-midday","article_chars":1334,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2a3d408544c9a85e","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1429693/cotton-back-to-strength-on-tuesdays-midday","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:58:10.800902+00:00","extraction_method":"trafilatura","fetched_description":"Cotton futures are trading with contracts another 60 to 85 points higher across the front months on Tuesday. The US dollar index is 0.313 higher at $98.220. Crude oil is up another $3.03 at midday. NASS Crop Progress data showed 11% of the US cotton crop planted as of April...","fetched_title":"Cotton Back to Strength on Tuesday\u2019s Midday | Nasdaq","final_url":"https://www.nasdaq.com/articles/cotton-back-strength-tuesdays-midday","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/cotton-back-strength-tuesdays-midday","source_event_id":"evt_5960e3f518f6","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"cd3e86722c0bfbb4","kind":"new_listings","published_at":"2026-04-21T19:38:05+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Tuesday","April 19","5-year average (as referenced)","Monday","4/20","April 20","Thursday","May 26","Jul 26","Dec 26"],"entities":[{"asset_class":"commodity_futures","name":"Cotton futures (front months)","relevance":"high","symbol":"CT=F","type":"commodity"},{"asset_class":"currency_index","name":"US Dollar Index","relevance":"medium","symbol":"DXY","type":"macro_indicator"},{"asset_class":"commodity_futures","name":"Crude oil","relevance":"medium","symbol":"CL=F","type":"commodity"},{"asset_class":"government_agency_data","name":"NASS Crop Progress","relevance":"high","symbol":"","type":"data_source"},{"asset_class":"cotton_market_report","name":"The Seam","relevance":"medium","symbol":"","type":"market_report"},{"asset_class":"cotton_price_index","name":"Cotlook A Index","relevance":"medium","symbol":"","type":"price_index"},{"asset_class":"cotton_inventory","name":"ICE certified cotton stocks","relevance":"medium","symbol":"","type":"inventory_metric"},{"asset_class":"cotton_price_metric","name":"Adjusted World Price","relevance":"medium","symbol":"","type":"price_metric"},{"asset_class":"commodity_futures","name":"May 26 Cotton","relevance":"high","symbol":"","type":"cotton_futures_contract"},{"asset_class":"commodity_futures","name":"Jul 26 Cotton","relevance":"high","symbol":"","type":"cotton_futures_contract"},{"asset_class":"commodity_futures","name":"Dec 26 Cotton","relevance":"high","symbol":"","type":"cotton_futures_contract"}],"event_type":"price_action","information_gaps":["No explicit ICE ticker symbols for the May 26/Jul 26/Dec 26 contracts are provided in the text.","The article does not specify the exact date/year for \u201cTuesday,\u201d \u201cMonday,\u201d \u201c4/20,\u201d or \u201cThursday,\u201d beyond month/day references.","No explanation is provided for why cotton strengthened; only concurrent market metrics and reported data are given.","\u201cCotton Back to Strength\u201d is stated in the headline, but the article text does not provide prior context or a comparison period to confirm the \u201cback to strength\u201d framing."],"key_facts":["Cotton futures were trading 60 to 85 points higher across the front months on Tuesday.","US dollar index was 0.313 higher at $98.220.","Crude oil was up another $3.03 at midday.","NASS Crop Progress: 11% of the US cotton crop planted as of April 19, 1 percentage point ahead of the 5-year average of 10%.","The Seam reported 64 bales sold on Monday at an average of 65.98 cents/lb.","Cotlook A Index was 175 points higher on 4/20 at 89.10 cents.","ICE certified cotton stocks were steady on April 20 at 164,967 bales.","Adjusted World Price was up another 287 points on Thursday at 61.61 cents/lb.","May 26 Cotton was 78.24, up 64 points.","Jul 26 Cotton was 80.79, up 75 points.","Dec 26 Cotton was 81.6, up 84 points."],"numeric_claims":[{"label":"Cotton futures move (points)","value":"+60 to +85"},{"label":"US dollar index change","value":"+0.313"},{"label":"US dollar index level","value":"98.220"},{"label":"Crude oil change (midday)","value":"+3.03"},{"label":"US cotton crop planted (as of Apr 19)","value":"11%"},{"label":"5-year average planted (as stated)","value":"10%"},{"label":"The Seam bales sold (Monday)","value":"64"},{"label":"The Seam average price (cents/lb)","value":"65.98"},{"label":"Cotlook A Index change (4/20)","value":"+175 points"},{"label":"Cotlook A Index level (4/20)","value":"89.10 cents"},{"label":"ICE certified cotton stocks (Apr 20)","value":"164,967 bales"},{"label":"Adjusted World Price change (Thursday)","value":"+287 points"},{"label":"Adjusted World Price level (Thursday)","value":"61.61 cents/lb"},{"label":"May 26 Cotton level","value":"78.24"},{"label":"May 26 Cotton change (points)","value":"+64"},{"label":"Jul 26 Cotton level","value":"80.79"},{"label":"Jul 26 Cotton change (points)","value":"+75"},{"label":"Dec 26 Cotton level","value":"81.6"},{"label":"Dec 26 Cotton change (points)","value":"+84"}],"primary_claim":"Cotton futures were trading 60 to 85 points higher across the front months on Tuesday.","relevance_score":0.72,"sentiment":"positive","source_quality":"medium","summary":"Tuesday midday, cotton futures rose across front months, with the US dollar index and crude oil also higher. USDA/NASS planting progress showed 11% of the US cotton crop planted as of April 19, ahead of the 5-year average, alongside reported sales, price indices, and ICE certified stock levels.","topics":["cotton futures","commodity prices","US dollar index","crude oil","US cotton planting progress","cotton market indices","ICE certified stocks"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Cotton futures are trading with contracts another 60 to 85 points higher across the front months on Tuesday. The US dollar index is 0.313 higher at $98.220. Crude oil is up another $3.03 at midday. NASS Crop Progress data showed 11% of the US cotton crop planted as of April...","tickers":[],"title":"Cotton Back to Strength on Tuesday\u2019s Midday","url":"https://www.barchart.com/story/news/1429693/cotton-back-to-strength-on-tuesdays-midday"}

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