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/soybeans-posting-midday-gains-following-bean-oil-rally","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://www.barchart.com/story/news/1429653/soybeans-posting-midday-gains-following-bean-oil-rally","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/soybeans-posting-midday-gains-following-bean-oil-rally","article_chars":1356,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_add7eb6a66052da7","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1429653/soybeans-posting-midday-gains-following-bean-oil-rally","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T00:00:11.514286+00:00","extraction_method":"trafilatura","fetched_description":"Soybeans are rallying on Tuesday, with bean oil continuing to pull the market higher. Futures are up 9 to 11 cents. The cmdtyView national average Cash Bean price is up 9 3/4 cents at $11.11 1/4. Soymeal futures are down 30 to 70 cents on the day, with Soy Oil...","fetched_title":"Soybeans Posting Midday Gains Following Bean Oil Rally | Nasdaq","final_url":"https://www.nasdaq.com/articles/soybeans-posting-midday-gains-following-bean-oil-rally","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/soybeans-posting-midday-gains-following-bean-oil-rally","source_event_id":"evt_6c86651f8d37","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"a171f6084ec002ff","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","May 26","Jul 26","Nov 26","On the date of publication"],"entities":[{"asset_class":"commodity","name":"Soybeans","relevance":"high","symbol":"","type":"commodity"},{"asset_class":"commodity","name":"Bean oil (Soy Oil)","relevance":"high","symbol":"","type":"commodity"},{"asset_class":"commodity","name":"Soymeal","relevance":"medium","symbol":"","type":"commodity"},{"asset_class":"commodity_price","name":"cmdtyView national average Cash Bean price","relevance":"high","symbol":"","type":"price_series"},{"asset_class":"macro_data","name":"NASS weekly Crop Progress report","relevance":"medium","symbol":"","type":"report"}],"event_type":"price_action","information_gaps":["No specific futures contract tickers/symbols are provided in the text (only month/year labels like May 26, Jul 26, Nov 26).","The article excerpt truncates after 'Soy Oil...' and does not provide full details beyond the stated ranges.","No explanation is provided for why bean oil is rising beyond the statement that it is 'continuing to pull the market higher.'","The exact publication date/time is not stated; only 'Tuesday' and 'April 19' are mentioned.","No trading volume, open interest, or broader market context is included."],"key_facts":["Soybeans are rallying on Tuesday, with bean oil continuing to pull the market higher.","Soybean futures are up 9 to 11 cents.","cmdtyView national average Cash Bean price is up 9 3/4 cents at $11.11 1/4.","Soymeal futures are down 30 to 70 cents on the day.","Soy Oil futures are up 220 to 240 points.","NASS weekly Crop Progress report pegged the US soybean crop at 12% planted by April 19.","The 12% planted pace is well above the 5% average pace for this time of year and the 7% from last year.","By state, only IA, MI, and WI were the only states below the average planting pace.","May 26 Soybeans are at $11.75 1/2, up 9 3/4 cents.","Nearby Cash is at $11.11 1/4, up 9 3/4 cents.","Jul 26 Soybeans are at $11.91 1/2, up 9 3/4 cents.","Nov 26 Soybeans are at $11.68 1/2, up 10 3/4 cents.","New Crop Cash is at $11.06, up 10 3/4 cents."],"numeric_claims":[{"label":"Soybean futures move (cents)","value":"up 9 to 11 cents"},{"label":"Cash Bean price","value":"$11.11 1/4 (up 9 3/4 cents)"},{"label":"Soymeal futures move (cents)","value":"down 30 to 70 cents"},{"label":"Soy Oil futures move (points)","value":"up 220 to 240 points"},{"label":"US soybean crop planted (by Apr 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","value":"$11.75 1/2 (up 9 3/4 cents)"},{"label":"Jul 26 Soybeans","value":"$11.91 1/2 (up 9 3/4 cents)"},{"label":"Nov 26 Soybeans","value":"$11.68 1/2 (up 10 3/4 cents)"},{"label":"New Crop Cash","value":"$11.06 (up 10 3/4 cents)"}],"primary_claim":"Soybeans are rallying on Tuesday with bean oil continuing to pull the market higher, with soybean futures up 9 to 11 cents and cash bean price up 9 3/4 cents to $11.11 1/4.","relevance_score":0.62,"sentiment":"mixed","source_quality":"medium","summary":"Soybeans are rising midday on Tuesday, supported by strength in bean oil. Soymeal is lower on the day, while multiple soybean futures and cash prices are up.","topics":["soybeans","soy oil","soymeal","futures","cash prices","crop progress","NASS planting pace"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Soybeans are rallying on Tuesday, with bean oil continuing to pull the market higher. Futures are up 9 to 11 cents. The cmdtyView national average Cash Bean price is up 9 3/4 cents at $11.11 1/4. Soymeal futures are down 30 to 70 cents on the day, with Soy Oil...","tickers":[],"title":"Soybeans Posting Midday Gains Following Bean Oil Rally","url":"https://www.barchart.com/story/news/1429653/soybeans-posting-midday-gains-following-bean-oil-rally"}

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