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-20T15:42:12.815098+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:85a0865b7d227f68","evidence_event_ids":["evt_45ae5e59d44d"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0","as_of":"2026-04-20T15:42:12.815098+00:00","canonical_url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_712c1a961308b9c0","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T16:12:32.165685+00:00","extraction_method":"trafilatura","fetched_description":"Favorable demand in major markets for crop nutrients, backed by the strength in global agriculture markets, should enable the Zacks Fertilizers industry to thrive. NTR, CF and ICL should benefit from supportive industry fundamentals.","fetched_title":"3 Top Fertilizer Stocks to Watch From a Promising Industry | Nasdaq","final_url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0","source_event_id":"evt_45ae5e59d44d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"42ad1571a8599719","kind":"options_flow","published_at":"2026-04-20T12:58:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2022","2023","2024","2025"],"entities":[{"asset_class":"equity","name":"Nutrien Ltd.","relevance":"high","symbol":"NTR","type":"company"},{"asset_class":"equity","name":"CF Industries Holdings, Inc.","relevance":"high","symbol":"CF","type":"company"},{"asset_class":"equity","name":"ICL Group Ltd","relevance":"high","symbol":"ICL","type":"company"},{"asset_class":"other","name":"U.S. Department of Agriculture (USDA)","relevance":"medium","symbol":"","type":"government agency"}],"event_type":"other","information_gaps":["No options-flow data (calls vs puts, expiry dates, flow size vs open interest, or informed positioning indicators) is present in the provided text.","The signal type requests options-flow delta extraction, but the article content provided is an industry/stock outlook piece without any specific options transactions or metrics.","No specific days-to-expiry or open-interest context is provided for any ticker."],"key_facts":["The article states that NTR, CF, and ICL are poised to gain from higher demand for fertilizers in major markets.","It says healthy farm income and expectations of increased planted acres are expected to drive crop nutrient demand globally in the near term.","It notes that phosphate and potash prices have retreated from peak levels since the back half of 2022.","It states global nitrogen prices have declined since the beginning of 2023 due to higher global supply from increased operating rates tied to lower energy costs.","It cites USDA projections that net farm income is projected to climb 29.5% year over year to $180.1 billion this year.","It states USDA forecasts direct government payments of $42.4 billion in 2025, a 354.5% surge from 2024.","It reports the Zacks Fertilizers industry has a Zacks Industry Rank of #39 (top 16% of more than 250 industries).","It states the industry has underperformed over the past year, losing 1.1% versus the S&P 500\u2019s rise of 23.3% and the broader sector\u2019s increase of 0.7%."],"numeric_claims":[{"label":"Net farm income (projected)","value":"$180.1 billion"},{"label":"YoY change in net farm income (projected)","value":"29.5%"},{"label":"Direct government payments (USDA forecast, 2025)","value":"$42.4 billion"},{"label":"YoY/relative change in government payments (from 2024)","value":"354.5% surge"},{"label":"Industry rank","value":"#39"},{"label":"Industry underperformance (past year)","value":"-1.1%"},{"label":"S&P 500 rise (past year)","value":"23.3%"},{"label":"Broader sector increase (past year)","value":"0.7%"}],"primary_claim":"Nutrien (NTR), CF Industries (CF), and ICL Group (ICL) are poised to benefit from higher global fertilizer demand supported by healthy farm income and expectations of increased planted acres.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article argues that fertilizer demand in major markets and expectations of higher planted acres, along with low inventories in some segments, should support fertilizer producers such as NTR, CF, and ICL. It also notes that softer fertilizer prices could weigh on margins and cites USDA projections for rising net farm income.","topics":["fertilizer demand","farm income","planted acres","fertilizer prices","nitrogen","potash","phosphate","industry outlook"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Favorable demand in major markets and higher fertilizer prices should enable the Zacks Fertilizers industry to thrive and support NTR, CF and YARIY stocks.","tickers":[],"title":"3 Top Fertilizer Stocks to Watch From a Promising Industry","url":"https://www.nasdaq.com/articles/3-top-fertilizer-stocks-watch-promising-industry-0"}}

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