Historical Stock Market SQL Server 2005 Database
To purchase this database, please click HERE
There is a one-time charge of $499.00
Exchanges and Symbols: Amex - 567 symbols Nasdaq - 5993 symbols Nyse - 3127 symbols Otcbb - 2121 symbols
Columns include: Ticker, Date, Open, High, Low, Close, Volume, Sector, Industry, Company Name and Exchange.
Drawbacks of other historical data sources:
- Many sources of historical data such as Yahoo Finance only allow you to download a very limited number of symbols at once. To attempt to gather years of historical stock data in this fashion is prohibitively time consuming.
- Other sources will allow you to buy historical data for thousands of ticker symbols but the data will often reside in thousands of separate excel spreadsheets or comma separated files (ascii format). The data from these sources needs to be combined and/or imported if one is desirous of organizing it in a fashion which lends itself to complex analysis such as in a relational database or data warehouse. Opening up thousands of individual spreadsheets to look for data is highly impractical while attempting to open a large ascii file in Excel can be difficult or impossible depending on the size of the file, the speed of the computer, or the version of Excel.
- Data which is contained in Metastock, Telechart, Quicken, .PRN-format or other proprietary programs are often very difficult to cleanly export to ascii (.txt or .csv). Unusual characters, spaces, varying date formats, and misaligned data is often a problem, and yet, even if the investor/analyst is successful in exporting the data properly, he or she is left with a gigantic and unwieldy .txt or .csv file.
To purchase this database, please click HERE
There is a one-time charge of $499.00
Exchanges and Symbols: Amex - 567 symbols Nasdaq - 5993 symbols Nyse - 3127 symbols Otcbb - 2121 symbols
Columns include: Ticker, Date, Open, High, Low, Close, Volume, Sector, Industry, Company Name and Exchange.
Drawbacks of other historical data sources:
- Many sources of historical data such as Yahoo Finance only allow you to download a very limited number of symbols at once. To attempt to gather years of historical stock data in this fashion is prohibitively time consuming.
- Other sources will allow you to buy historical data for thousands of ticker symbols but the data will often reside in thousands of separate excel spreadsheets or comma separated files (ascii format). The data from these sources needs to be combined and/or imported if one is desirous of organizing it in a fashion which lends itself to complex analysis such as in a relational database or data warehouse. Opening up thousands of individual spreadsheets to look for data is highly impractical while attempting to open a large ascii file in Excel can be difficult or impossible depending on the size of the file, the speed of the computer, or the version of Excel.
- Data which is contained in Metastock, Telechart, Quicken, .PRN-format or other proprietary programs are often very difficult to cleanly export to ascii (.txt or .csv). Unusual characters, spaces, varying date formats, and misaligned data is often a problem, and yet, even if the investor/analyst is successful in exporting the data properly, he or she is left with a gigantic and unwieldy .txt or .csv file.
To purchase this database, please click HERE
