The data that will be used in this case study is provided in two different
formats at the book Web site3
file that can be read into R in the same way as the data used in Chapter 2.
The book site also provides the data as a MySQL database dump file which we
can use to create a database with the stock quotes in MySQL. In this section,
we will illustrate how to load this data into R for these two alternative ways of
storing it. It is up to you to decide which alternative you will download. The
rest of the chapter (i.e. the analysis after reading the data) is independent of
the storage schema you decide to use.
Whichever the format you choose to download, the daily stock quotes data
includes information regarding the following properties:
• Date of the stock exchange session.
• Open price at the begining of the session.
• Highest price during the session.
• Lowest price.
• Closing price of the session.
• Volume of transactions.
• Ticker (a identifier of the stock).
. The first is a comma separated values (CSV)