有用的股票SQL数据集？ [英] Useful stock SQL datasets?

问题描述

有没有人知道任何提供良好有用的股票数据集的资源？例如，我已经下载了一个包含所有美国州，城市和邮政编码的SQL脚本。这使我在最近的一个应用程序中节省了很多时间，我希望能够通过地理位置进行查找。您是否知道可以免费下载的其他有用的数据集？

例如：

• 已列入黑名单的IP位址


• 学校/大学名称


• 公司名称/股票代号

任何人都有任何建议？

EDIT：
$ b

例如，这里是我找到一个包含所有美国邮政编码及其相应纬度/经度的MySQL脚本的位置。是否有其他人在SQL中发现类似有用的数据集，可以轻松导入和使用？

http://www.chrissibert.com/blog/wp-content/uploads/2009/06/zipcodes.7z

编辑2：

澄清我在说什么类型的数据集...引用可以立即用于应用的数据集，可以应用于各种情况，并且通常表示对于小型情况容易找到但对于较大数据集编译更难的信息。邮政编码数据库是一个很好的例子。不难得到一个给定的邮政编码的纬度/经度。但是，在美国获取所有有效邮政编码的值会更加耗时。此数据对单个行业或商业部门也无用，但可应用于一系列应用程序。

解决方案

这里有许多打开数据集的链接：

http://readwrite.com/2008/04/09/where_to_find_open_data_on_the/

虽然我怀疑他们会为你生成SQL语句。

Does anyone know of any resources that provide good, useful stock datasets? For example, I've downloaded a SQL script that includes all of the U.S. states, cities, and zipcodes. This saved me a lot of time in a recent application where I wanted to be able to do lookups by geography. Are any of you aware of other useful datasets that are freely available for download?

For example:

• Blacklisted IP addresses
• Names of colleges/universities
• Names of corporations/stock symbols

Anyone have any recommendations?

EDIT:

As an example, here is the location where I found a MySQL script containing all of the U.S. zip codes and their corresponding latitude/longitude. Has anyone else found similarly useful datasets in SQL that can be easily imported and used?

http://www.chrissibert.com/blog/wp-content/uploads/2009/06/zipcodes.7z

EDIT 2:

To clarify what type of datasets I'm talking about... I'm referring to datasets that can be immediately useful for applications, can be applied across a variety of scenarios, and typically represent information that is easy to find for small cases but harder to compile for larger data sets. The zip code database is a great example to me. It's not hard to get the lat/long for a single given zip code. But, it's a bit more time consuming to get the values for all valid zip codes in the U.S. This data is also not useful to a single industry or business sector, but can be applied across a range of applications.

解决方案

Lots of links to open data sets here:

http://readwrite.com/2008/04/09/where_to_find_open_data_on_the/

although I doubt any of them will generate SQL statements for you.

这篇关于有用的股票SQL数据集？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！