blocks|key|3216210|text|Shadowman，如果你说出你想要的详细清单会更好。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3216211|3216212|列入黑名单的IP地址-+Ad？Xxx？欺诈？|unordered-list-item|3216213|的学院/大学名称-世界上所有的？这不是太多了吗？|3216214|3216215|下面是一个如何下拉列表的想法--我是这样做的：|3216216|例如，我需要加州的学院/大学列表。|3216217|3216218|I谷歌搜索：colleges+california+wikipedia。然后在那里打开first+found+item；|ordered-list-item|CODE|3216219|用鼠标从那里选中所有高校，然后将复制的名称粘贴到第一个Excel中，第二个单元格的第一行写模板化脚本，如：|3216220|3216221|=“插入学院(州，名称)值('CA'，'”&+RC-1+&+"');“|3216222|这应该会产生类似这样的结果|3216223|插入学院(州，名称)值('CA'，‘学院艺术大学，旧金山’)；插入学院(州，名称)值('CA'，‘联合美国大学，拉古纳山，(在线)’)；插入学院(州，名称)值('CA'，‘美国犹太大学，洛杉矶’)；插入学院(州，名称)值('CA'，‘美国体育大学，圣贝纳迪诺’)；插入学院(州，名称)值('CA'，‘阿纳海姆大学，和阿纳海姆大学(在线)’)；插入学院(州，名称)值('CA'，‘安提阿大学，和卡尔弗城’)；--等...|3216224|然后只需复制生成的脚本并将其用于数据库|3216225|3216226|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/List_of_colleges_and_universities_in_California^0|0|9|0|0|0|0|0|0|0|0|6|T|17|G|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1F|8|@$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1I|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|1J|8|@]|D|@]|E|$]]|$1|J|3|K|5|I|7|1K|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|1M|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1N|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1O|8|@]|D|@]|E|$]]|$1|R|3|S|5|T|7|1P|8|@$9|1Q|A|1R|B|U]]|D|@$9|1S|A|1T|1|1U]]|E|$]]|$1|V|3|W|5|T|7|1V|8|@]|D|@]|E|$]]|$1|X|3|-4|5|6|7|1W|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|1X|8|@]|D|@]|E|$]]|$1|10|3|11|5|6|7|1Y|8|@]|D|@]|E|$]]|$1|12|3|13|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|14|3|15|5|I|7|20|8|@]|D|@]|E|$]]|$1|16|3|-4|5|6|7|21|8|@]|D|@]|E|$]]|$1|17|3|-4|5|6|7|22|8|@]|D|@]|E|$]]]|18|$19|$5|1A|1B|1C|E|$1D|1E]]]]

Shadowman, better if you say detail list of what you want.

<ul>
<li>Blacklisted IP addresses - Ad? Xxx? Fraud?</li>
<li>Names of colleges/universities - All in the world? Wouldn't it be too much?</li>
</ul>

Here is an idea how to drop down a list of something - this is how I do that:

For example, I need a list of colleges/universities in California.

<ol>
<li>I google for: <code>colleges california wikipedia</code>. Then open the <a href="http://en.wikipedia.org/wiki/List_of_colleges_and_universities_in_California" rel="noreferrer">first found item</a> there;</li>
<li>By using mouse I select all the colleges and universities from there to clipboard;</li>
<li>Open Excel and paste copied names into the first row+column;</li>
<li>In the second cell of the first row write templated script, like:

<pre><code>="INSERT INTO Colleges (state, name) VALUES ('CA', '" &amp; RC[-1] &amp; "');"
</code></pre>

This should produce something like

<pre><code>INSERT INTO Colleges (state, name) VALUES ('CA', 'Academy of Art University, San Francisco');
INSERT INTO Colleges (state, name) VALUES ('CA', 'Allied American University, Laguna Hills (Online)');
INSERT INTO Colleges (state, name) VALUES ('CA', 'American Jewish University, Los Angeles');
INSERT INTO Colleges (state, name) VALUES ('CA', 'American Sports University, San Bernardino');
INSERT INTO Colleges (state, name) VALUES ('CA', 'Anaheim University, Anaheim (Online)');
INSERT INTO Colleges (state, name) VALUES ('CA', 'Antioch University, Culver City');
-- etc...
</code></pre></li>
<li>Then just copy generated script and use it for your database</li>
</ol>

blocks|key|287808|text|这里有很多指向开放数据集的链接：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|287809|http://readwrite.com/2008/04/09/where_to_find_open_data_on_the/|offset|length|287810|尽管我怀疑它们中的任何一个都不能为您生成SQL语句。|287811|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1R|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

Lots of links to open data sets here:

<a href="http://readwrite.com/2008/04/09/where_to_find_open_data_on_the/" rel="nofollow noreferrer">http://readwrite.com/2008/04/09/where_to_find_open_data_on_the/</a>

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

blocks|key|284716|text|http://www.data.gov/有很多不同的数据集，但大多数都不是“股票”。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|284717|entityMap|0|LINK|mutability|MUTABLE|url|http://www.data.gov/^0|0|K|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.data.gov/" rel="nofollow">http://www.data.gov/</a> has a lot of different datasets but most are not "stock".

blocks|key|3002993|text|股票代码是有问题的，每个交易执行地点的股票代码都可能不同，几乎所有的交易执行地点或数据供应商都是作为受保护的知识产权持有的，例如汤森路透、彭博、纳斯达克、纽约证券交易所。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3002994|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Stock symbols are problematic, they can be different for every trade execution venue and pretty much all are held as protected intellectual property of the venue or data vendor, e.g. Thomson Reuters, Bloomberg, Nasdaq, NYSE.

blocks|key|284748|text|如果您正在寻找时间序列数据，请查看Quandl。这里最棒的是，它有大量不同的数据集(股票、经济、健康、教育等)。但都可以通过一个简单的RESTful应用程序接口来访问。如果您不擅长编程，那么有一个免费的Excel插件可以让您轻松地将数据抓取到电子表格中。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|284749|entityMap|0|LINK|mutability|MUTABLE|url|http://quandl.com/^0|H|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you're looking for time series data, check out <a href="http://quandl.com" rel="nofollow">Quandl</a>. The great thing here is that it has tons of different data sets (stocks, economics, health, education, etc.) but accessible all by one easy, RESTful API. If programming isn't your thing, then there is a free Excel plug in that lets you easily grab the data into your spreadsheet.

blocks|key|3216522|text|MySQL文档站点提供了一个可下载数据集的列表，该数据集已采用SQL格式，可在数据库中使用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3216523|数据库下载数据集，如world+database：http://downloads.mysql.com/docs/world_innodb.sql.gz|offset|length|3216524|Change目录到您下载到的文件夹中，如cd+Downloads|unordered-list-item|style|CODE|3216525|
|3216526|Unzip+gunzip+world_innodb.sql.gz|3216527|3216528|Login+to+|3216529|并创建world数据库|ordered-list-item|3216530|3216531|3216532|$+mysql++mysql>+create+database+world++mysql>+quit|3216533|3216534|使用cat|3216535|导入mysqldump文件的内容|3216536|3216537|+cat+world_innodb.sql+%7C+mysql的世界|blockquote|3216538|3216539|3216540|此数据集是希望练习SQL的学习者的理想选择。|3216541|entityMap|0|LINK|mutability|MUTABLE|url|http://downloads.mysql.com/docs/world_innodb.sql.gz^0|0|P|1F|0|0|K|C|0|0|6|Q|0|0|0|3|5|0|0|0|0|1E|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1K|8|@]|9|@$D|1L|E|1M|1|1N]]|A|$]]|$1|F|3|G|5|H|7|1O|8|@$D|1P|E|1Q|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|1R|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|1S|8|@$D|1T|E|1U|I|J]]|9|@]|A|$]]|$1|O|3|L|5|6|7|1V|8|@]|9|@]|A|$]]|$1|P|3|Q|5|H|7|1W|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1X|8|@$D|1Y|E|1Z|I|J]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|21|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|22|8|@$D|23|E|24|I|J]]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|25|8|@]|9|@]|A|$]]|$1|Z|3|10|5|T|7|26|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|27|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|28|8|@]|9|@]|A|$]]|$1|14|3|15|5|16|7|29|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2A|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|2C|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]]|1C|$1D|$5|1E|1F|1G|A|$1H|1I]]]]

The MySQL documentation site has a list to a downloadable dataset already in SQL format, ready for use in a database.

<ol>
<li>Download the dataset, such as the world database: <a href="http://downloads.mysql.com/docs/world_innodb.sql.gz" rel="nofollow">http://downloads.mysql.com/docs/world_innodb.sql.gz</a></li>
<li>Change directory into the folder you downloaded to, e.g. <code>cd Downloads</code></li>
<li>Unzip <code>gunzip world_innodb.sql.gz</code></li>
<li>Login to mysql and create a <code>world</code> database</li>
</ol>

<code>$ mysql
 mysql&gt; create database world
 mysql&gt; quit
</code>

<ol start="5">
<li>Import the contents of the mysqldump file using cat</li>
</ol>

<blockquote>
 cat world_innodb.sql | mysql world
</blockquote>

This dataset is idea for learners, looking to practice their SQL.

blocks|key|287067|text|编辑:我将离开我之前的答案。如果您想要将任意CSV转换为SQL脚本以供数据库使用，请阅读下面的内容。否则，返回the+Chinook+Database+offers+excellent+sample+data+with+scripts+that+are+compatible+with+a+variety+of+relational+databases。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|287068|287069|我正在寻找示例基本的SQL类数据集，以帮助教一位朋友如何进行SQL查询。这里发布的一些链接不再可用，所以我将发布我最终使用的链接。|287070|SpatialKey+here提供了一些非常酷的CSV数据。|287071|如果需要的话，可以使用CSV数据，但是我想要SQLite数据库中的数据，所以我使用了这个方便的CSV->SQL+online+converter。|287072|在我下载SQL之后，我运行了以下命令：|287073|在shell：|287074|sqlite3+<database_file>|code-block|syntax|javascript|287075|在SQLite+shell中：|287076|.load+<path+to+SQL+script+file>|287077|entityMap|0|LINK|mutability|MUTABLE|url|http://chinookdatabase.codeplex.com/wikipage?title=Chinook_Schema&referringTitle=Documentation|1|https://support.spatialkey.com/spatialkey-sample-csv-data/|2|http://www.convertcsv.com/csv-to-sql.htm^0|1J|3D|0|0|0|0|0|F|1|0|1B|P|2|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@$A|1A|B|1B|1|1C]]|C|$]]|$1|D|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]|$1|E|3|F|5|6|7|1E|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|1F|8|@]|9|@$A|1G|B|1H|1|1I]]|C|$]]|$1|I|3|J|5|6|7|1J|8|@]|9|@$A|1K|B|1L|1|1M]]|C|$]]|$1|K|3|L|5|6|7|1N|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|1O|8|@]|9|@]|C|$]]|$1|O|3|P|5|Q|7|1P|8|@]|9|@]|C|$R|S]]|$1|T|3|U|5|6|7|1Q|8|@]|9|@]|C|$]]|$1|V|3|W|5|Q|7|1R|8|@]|9|@]|C|$R|S]]|$1|X|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|Y|$Z|$5|10|11|12|C|$13|14]]|15|$5|10|11|12|C|$13|16]]|17|$5|10|11|12|C|$13|18]]]]

EDIT: 
I will leave my previous answer. If you want to convert arbitrary CSV into SQL scripts for database use, read below. Otherwise, <a href="http://chinookdatabase.codeplex.com/wikipage?title=Chinook_Schema&amp;referringTitle=Documentation" rel="nofollow">the Chinook Database offers excellent sample data with scripts that are compatible with a variety of relational databases</a>.

<hr>

I was looking for sample basic SQL-like data sets to assist in teaching a friend how to make SQL queries. Some of the links posted here were no longer available, so I'll post what I ended up using.

There are some pretty cool CSV data available from <a href="https://support.spatialkey.com/spatialkey-sample-csv-data/" rel="nofollow">SpatialKey here</a>.

The CSV data can be used, if that's what you need, but I wanted the data in a SQLite database, so I used this handy <a href="http://www.convertcsv.com/csv-to-sql.htm" rel="nofollow">CSV->SQL online converter</a>. 

After I downloaded the SQL, I ran the following:

At shell:

<pre><code>sqlite3 &lt;database_file&gt;
</code></pre>

In SQLite shell:

<pre><code>.load &lt;path to SQL script file&gt;
</code></pre>

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:

<ul>
<li>Blacklisted IP addresses</li>
<li>Names of colleges/universities</li>
<li>Names of corporations/stock symbols</li>
</ul>

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?

<a href="http://www.chrissibert.com/blog/wp-content/uploads/2009/06/zipcodes.7z">http://www.chrissibert.com/blog/wp-content/uploads/2009/06/zipcodes.7z</a>

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.

Useful stock SQL datasets?

数据库

SQLite

MySQL

有没有人知道提供好的、有用的股票数据集的资源？例如，我下载了一个包含美国所有州、城市和邮政编码的SQL脚本。这为我在最近的一个应用程序中节省了大量时间，因为我希望能够按地理位置进行查找。你们中有没有人知道其他可以免费下载的有用的数据集？例如：被列入黑名单的公司IP addressesNames of colleges/...

问有用的股票SQL数据集？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有用的股票SQL数据集？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有用的股票SQL数据集？
EN