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-22T00:01:09.681092+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:bd17904f0e276239","evidence_event_ids":["evt_53268a79d054"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/soybeans-follow-bean-oil-rally-tuesday","as_of":"2026-04-22T00:01:09.681092+00:00","canonical_url":"https://www.barchart.com/story/news/1435974/soybeans-follow-bean-oil-rally-on-tuesday","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/soybeans-follow-bean-oil-rally-tuesday","article_chars":2065,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c09da0fdc6dd1b9f","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1435974/soybeans-follow-bean-oil-rally-on-tuesday","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T00:24:40.652197+00:00","extraction_method":"trafilatura","fetched_description":"Soybeans were in rally mode on Tuesday, with bean oil continuing to pull the market higher, up 6 \u00be to 9 1/4 cents on the beans. The cmdtyView national average Cash Bean price was up 9 1/4 cents at $11.11 3/4. Soymeal futures were down $2.10 to 20 cents higher...","fetched_title":"Soybeans Follow Bean Oil Rally on Tuesday | Nasdaq","final_url":"https://www.nasdaq.com/articles/soybeans-follow-bean-oil-rally-tuesday","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/soybeans-follow-bean-oil-rally-tuesday","source_event_id":"evt_53268a79d054","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"795ad51e7f52123a","kind":"new_listings","published_at":"2026-04-21T23:44:34+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Tuesday","April 19","late 2022","May 26","Jul 26","Nov 26","May 26 Soybeans closed","On the date of publication"],"entities":[{"asset_class":"agriculture","name":"Soybeans","relevance":"high","symbol":"","type":"commodity"},{"asset_class":"agriculture","name":"Bean oil (soy oil)","relevance":"high","symbol":"","type":"commodity"},{"asset_class":"agriculture","name":"cmdtyView national average Cash Bean price","relevance":"high","symbol":"","type":"price_series"},{"asset_class":"agriculture","name":"Soymeal futures","relevance":"medium","symbol":"","type":"commodity_derivative"},{"asset_class":"agriculture","name":"Soy Oil futures (front months)","relevance":"medium","symbol":"","type":"commodity_derivative"},{"asset_class":"agriculture","name":"US soybean crop (NASS Crop Progress)","relevance":"medium","symbol":"","type":"macro_indicator"},{"asset_class":"agriculture","name":"NASS Crop Progress report","relevance":"medium","symbol":"","type":"data_source"}],"event_type":"price_action","information_gaps":["The signal type guidance mentions new listings delta, but the provided text contains no information about new listings; this may be a mismatch with the signal type.","No standardized ticker symbols are provided for the commodity futures/cash series in the text.","The article states soymeal futures were 'down $2.10 to 20 cents higher'\u2014the exact interpretation of this range is unclear from the text alone.","The specific meaning of 'D4 Rin values' is not defined in the provided excerpt."],"key_facts":["Soybeans were described as in rally mode on Tuesday, with bean oil continuing to pull the market higher.","The cmdtyView national average Cash Bean price was up 9 1/4 cents to $11.11 3/4.","Soymeal futures were down $2.10 to 20 cents higher on the day (as stated).","Soy Oil futures were up 184 to 251 points in the front months.","D4 Rin values reached their highest levels since late 2022, supporting the bean oil market via increased renewable demand for the feedstocks (as stated).","NASS Crop Progress reported the US soybean crop was pegged at 12% planted by April 19.","The 12% planted pace was described as above the 5% average pace for this time of year and above the 7% from last year.","By state, only IA, MI, and WI were reported as below the average planting pace.","The next 7 days were described as having limited planters rolling due to expected 1 to 3 inches of rain from the Central Plains to the East Coast (as stated).","May 26 Soybeans closed at $11.74 1/2, up 8 3/4 cents; Nearby Cash was $11.11 3/4, up 9 1/4 cents.","Jul 26 Soybeans closed at $11.90 1/4, up 8 1/2 cents; Nov 26 Soybeans closed at $11.66 1/2, up 8 3/4 cents.","New Crop Cash was $11.04 1/4, up 9 cents."],"numeric_claims":[{"label":"Cash Bean price (cmdtyView national average)","value":"$11.11 3/4 (up 9 1/4 cents)"},{"label":"Soybeans move (range)","value":"up 6 3/4 to 9 1/4 cents on the beans"},{"label":"Soymeal futures move","value":"down $2.10 to 20 cents higher (as stated)"},{"label":"Soy Oil futures move (front months)","value":"up 184 to 251 points"},{"label":"US soybean crop planted (by April 19)","value":"12%"},{"label":"Average planting pace (this time of year)","value":"5%"},{"label":"Last year planting pace (this time of year)","value":"7%"},{"label":"May 26 Soybeans close","value":"$11.74 1/2 (up 8 3/4 cents)"},{"label":"Jul 26 Soybeans close","value":"$11.90 1/4 (up 8 1/2 cents)"},{"label":"Nov 26 Soybeans close","value":"$11.66 1/2 (up 8 3/4 cents)"},{"label":"New Crop Cash close","value":"$11.04 1/4 (up 9 cents)"}],"primary_claim":"Bean oil strength helped lift soybeans on Tuesday, with the cmdtyView national average cash bean price up 9 1/4 cents to $11.11 3/4.","relevance_score":0.62,"sentiment":"positive","source_quality":"medium","summary":"Soybeans rose on Tuesday, supported by strength in bean oil. The article cites higher cash and futures prices for soybeans, alongside higher soy oil front-month futures and a reported faster-than-average US planting pace.","topics":["soybeans","soy oil","soymeal","cash prices","futures","planting progress","rain outlook","renewable demand (as stated)"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Soybeans were in rally mode on Tuesday, with bean oil continuing to pull the market higher, up 6 \u00be to 9 1/4 cents on the beans. The cmdtyView national average Cash Bean price was up 9 1/4 cents at $11.11 3/4. Soymeal futures were down $2.10 to 20 cents higher...","tickers":[],"title":"Soybeans Follow Bean Oil Rally on Tuesday","url":"https://www.barchart.com/story/news/1435974/soybeans-follow-bean-oil-rally-on-tuesday"}}

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