On Tue, Mar 02, 2010 at 12:09:36AM -0800, D. Cooper Stevenson wrote:
> Here is an example of each (they're essentially the same):
Are these real samples? You seem to have a problem with data integrity.
(And do you really want to monitor minute by minute price flucuations?)
> msft:
>
> date time open high low close volume
> | 2009-01-15 | 16:57:00 | 18.64 | 18.67 | 18.62 | 18.64 | 190394 |
> | 2009-01-15 | 16:58:00 | 18.63 | 18.63 | 18.61 | 18.62 | 60652 |
> | 2009-01-15 | 16:59:00 | 18.62 | 18.63 | 18.6 | 18.61 | 404419 |
The same date has three different opening prices? A high that drops with time?
A closing price that varies?
> goog:
>
> date time open high low close volume
> | 2009-01-15 | 16:49:00 | 299.32 | 299.32 | 299.32 | 299.32 | 550 |
> | 2009-01-15 | 16:51:00 | 299.93 | 299.93 | 299.93 | 299.93 | 500 |
> | 2009-01-15 | 16:55:00 | 299.4 | 299.4 | 299.39 | 299.39 | 269 |
Same problem with open & close, the low rises.
> aapl:
>
> date time open high low close volume
> | 2009-01-15 | 16:57:00 | 83.49 | 83.49 | 83.49 | 83.49 | 400 |
> | 2009-01-15 | 16:58:00 | 83.49 | 83.49 | 83.49 | 83.49 | 350 |
> | 2009-01-15 | 16:59:00 | 83.43 | 83.46 | 83.41 | 83.42 | 2290 |
> intc:
>
> date time open high low close volume
> | 2009-01-15 | 16:57:00 | 13.57 | 13.58 | 13.56 | 13.56 | 1400 |
> | 2009-01-15 | 16:58:00 | 13.57 | 13.58 | 13.57 | 13.58 | 7517 |
> | 2009-01-15 | 16:59:00 | 13.58 | 13.58 | 13.56 | 13.58 | 2950 |
> Bonus points for doing this within a specific date range.
>
> Thanks in advance for any help you may be able to provide.
Modify Drew's SQL to include:
where date BETWEEN '2005-01-01' AND '2005-12-31'
or whatever dates you deem of interest.
See http://www.plus2net.com/sql_tutorial/between-date.php
(current #1 return when Googling for mysql date range query)
--
Michael Rasmussen, Portland Oregon
Trading kilograms for kilometers since 2003
Be appropriate && Follow your curiosity
http://www.jamhome.us/
The Fortune Cookie Fortune today is:
The devil can cite Scripture for his purpose.
-- William Shakespeare, "The Merchant of Venice"
_______________________________________________
PLUG mailing list
PLUG@lists.pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug
