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-21T01:39:14.218814+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:2ecee3dc7b023681","evidence_event_ids":["evt_01611983e957"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/cotton-end-monday-session-higher","as_of":"2026-04-21T01:39:14.218814+00:00","canonical_url":"https://www.barchart.com/story/news/1410613/cotton-end-the-monday-session-higher","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/cotton-end-monday-session-higher","article_chars":1624,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6f497677ab2fd3fb","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1410613/cotton-end-the-monday-session-higher","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:28:37.328628+00:00","extraction_method":"trafilatura","fetched_description":"Cotton futures saw gains of 20 to 36 points across most contracts on Monday.. The US dollar index was $0.053 lower at $97.845. Crude oil was back up $3.95 at midday. NASS Crop Progress data showed 11% of the US cotton crop planted as of April 19, which was 1...","fetched_title":"Cotton End the Monday Session Higher | Nasdaq","final_url":"https://www.nasdaq.com/articles/cotton-end-monday-session-higher","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/cotton-end-monday-session-higher","source_event_id":"evt_01611983e957","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"d94320444894900c","kind":"new_listings","published_at":"2026-04-21T01:18:29+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Monday","April 19","4/17","April 17","Friday","Thursday","4/17"],"entities":[{"asset_class":"commodity","name":"Cotton futures (May 26)","relevance":"high","symbol":"","type":"commodity_contract"},{"asset_class":"commodity","name":"Cotton futures (Jul 26)","relevance":"high","symbol":"","type":"commodity_contract"},{"asset_class":"commodity","name":"Cotton futures (Dec 26)","relevance":"high","symbol":"","type":"commodity_contract"},{"asset_class":"macro","name":"US Dollar Index","relevance":"medium","symbol":"DXY","type":"macro_indicator"},{"asset_class":"commodity","name":"Crude oil","relevance":"medium","symbol":"CL=F","type":"commodity"},{"asset_class":"data","name":"NASS Crop Progress","relevance":"medium","symbol":"","type":"data_source"},{"asset_class":"market_data","name":"The Seam","relevance":"low","symbol":"","type":"market_report"},{"asset_class":"commodity_index","name":"Cotlook A Index","relevance":"low","symbol":"","type":"commodity_index"},{"asset_class":"market_data","name":"ICE certified cotton stocks","relevance":"low","symbol":"","type":"inventory_metric"},{"asset_class":"market_data","name":"Adjusted World Price","relevance":"low","symbol":"","type":"pricing_metric"}],"event_type":"price_action","information_gaps":["The signal type is labeled as discovery_new_listings_delta, but the provided text contains no explicit information about new listings or listing changes.","The article does not specify the exact date/year for \u201cMonday,\u201d \u201cFriday,\u201d or \u201cThursday.\u201d","No contract tickers/symbols are provided for the cotton futures beyond month/year labels (May 26, Jul 26, Dec 26).","The article does not provide the full context for the cotton point gains (e.g., whether points correspond to cents/lb or another unit)."],"key_facts":["Cotton futures were up 20 to 36 points across most contracts on Monday.","US Dollar Index was $0.053 lower at 97.845.","Crude oil was up $3.95 at midday.","NASS Crop Progress reported 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 1,783 bales sold on 4/17 at an average of 74.86 cents/lb.","Cotlook A Index was 75 points higher on April 17 at 87.35 cents.","ICE certified cotton stocks were up 2,600 on Friday; certified stocks level was 164,967 bales.","Adjusted World Price was up 287 points on Thursday at 61.61 cents/lb.","May 26 Cotton closed at 77.6, up 20 points.","Jul 26 Cotton closed at 80.04, up 22 points.","Dec 26 Cotton closed at 80.76, up 26 points."],"numeric_claims":[{"label":"Cotton futures gains (points)","value":"20 to 36"},{"label":"US Dollar Index level","value":"97.845"},{"label":"US Dollar Index change","value":"-0.053"},{"label":"Crude oil change at midday ($)","value":"+3.95"},{"label":"US cotton crop planted (as of Apr 19)","value":"11%"},{"label":"5-year average planted","value":"10%"},{"label":"The Seam bales sold (4/17)","value":"1,783"},{"label":"The Seam average price (cents/lb)","value":"74.86"},{"label":"Cotlook A Index change (points)","value":"+75"},{"label":"Cotlook A Index level (cents)","value":"87.35"},{"label":"ICE certified cotton stocks change (bales)","value":"+2,600"},{"label":"ICE certified cotton stocks level (bales)","value":"164,967"},{"label":"Adjusted World Price change (points)","value":"+287"},{"label":"Adjusted World Price level (cents/lb)","value":"61.61"},{"label":"May 26 Cotton close","value":"77.6"},{"label":"May 26 Cotton change (points)","value":"+20"},{"label":"Jul 26 Cotton close","value":"80.04"},{"label":"Jul 26 Cotton change (points)","value":"+22"},{"label":"Dec 26 Cotton close","value":"80.76"},{"label":"Dec 26 Cotton change (points)","value":"+26"}],"primary_claim":"Cotton futures gained 20 to 36 points across most contracts on Monday.","relevance_score":0.62,"sentiment":"positive","source_quality":"medium","summary":"Cotton futures rose on Monday, with most contracts up 20\u201336 points. The article also cites a stronger US dollar (down $0.053 to 97.845), higher crude oil (+$3.95 at midday), and USDA/NASS planting and market data.","topics":["cotton futures","commodity prices","US dollar index","crude oil","USDA/NASS crop progress","ICE certified cotton stocks","Cotlook A Index","Adjusted World Price"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Cotton futures saw gains of 20 to 36 points across most contracts on Monday.. The US dollar index was $0.053 lower at $97.845. Crude oil was back up $3.95 at midday. NASS Crop Progress data showed 11% of the US cotton crop planted as of April 19, which was 1...","tickers":[],"title":"Cotton End the Monday Session Higher","url":"https://www.barchart.com/story/news/1410613/cotton-end-the-monday-session-higher"}}

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