2008-2017年玉米和大豆价格数据集，美国农业部 WASDE 月度预测的价格

The U. S. Department of Agriculture (USDA) issues a monthly World Agricultural Supply and Demand Estimate (WASDE) report which includes projections for the Supply and Demand for various U. S. crops. The data in the reports indicates (amongst other things) projected scarcity of crop supplies - which affects price movements on the commodity markets. (Python Kernel to follow shortly.) The USDA data was acquired by downloading all the historical WASDE reports starting in May2007 through Mar2018. (A python script aggregated the data and output the CSV files in this dataset.) The best way to understand the many columns of data is to look at a single WASDE report and visit the official website with historical reports - but it can be useful to have the projections arranged by date as presented here. I have generated corresponding files for other crops - if they would be of interest to others I'd be happy to add them. The price data has been scraped from a public website - and rearranged for ease of use. At any one time there are multiple commodity contracts open and the "nearby" is the contract that will be the first to expire. The "nearby" files show the close price of the nearby contract during the period Feb2008 through Dec2017. Included are files for two separate contracts - SoybeansJul14 and CornJul14: along with Open, High, Low, Close, Volume and OpenInterest, the last column indicates Total Open Interest across all soybean (and respectively corn) contracts on that date. The WASDE data is extracted from (public domain) monthly reports produced by the U. S. Department of Agriculture. Banner Photo by Henry Be on Unsplash

美国农业部（U. S. Department of Agriculture, USDA）每月发布一期《世界农业供需预测报告》（World Agricultural Supply and Demand Estimate, WASDE），报告涵盖各类美国农作物的供需预测数据。该报告数据除包含其他信息外，还涵盖农作物供应的预测稀缺性情况——这一信息会对大宗商品市场的价格走势产生影响。（后续将发布Python内核代码。）
本数据集的USDA数据通过下载2007年5月至2018年3月期间的全部历史WASDE报告获取；本次数据集的CSV文件由Python脚本聚合数据后生成。
理解这份多列数据的最佳途径是查阅单期WASDE报告并访问包含历史报告的官方网站，但如本数据集这般按时间排序的预测数据仍具备较高实用价值。我还为其他农作物生成了对应的数据文件，若其他用户有需求，我乐于补充上传。
价格数据源自公开网站的爬取结果，并经过重新整理以提升易用性。在任意时点，大宗商品市场均存在多份未到期合约，其中“近期合约”指首个到期的合约。本次“近期合约”数据集涵盖2008年2月至2017年12月期间的近期合约收盘价。
本次数据集包含两份独立合约的数据文件——2014年7月到期的大豆（SoybeansJul14）与2014年7月到期的玉米（CornJul14），文件包含开盘价（Open）、最高价（High）、最低价（Low）、收盘价（Close）、成交量（Volume）以及持仓量（OpenInterest）数据，最后一列分别标注当日所有大豆（对应玉米）合约的总持仓量。
WASDE数据均提取自美国农业部发布的公有领域月度报告。封面照片由Henry Be拍摄于Unsplash平台。

搜集汇总

背景与挑战

背景概述

该数据集涵盖了2008年至2017年美国玉米和大豆的价格数据，来源于美国农业部（USDA）每月发布的世界农业供需估计（WASDE）报告，这些报告包含作物供需预测，影响商品市场价格。数据通过历史WASDE报告聚合生成，包括'近月'合约的收盘价以及开盘价、最高价、最低价、成交量等详细信息，适用于农业经济和市场分析。