Hi Michael, On 03/02/10 06:03, Michael Rasmussen wrote: > Are these real samples? You seem to have a problem with data integrity. > > We're alright, see below. > (And do you really want to monitor minute by minute price flucuations?) Yes, you may view a screenshot depicting my utilization of the minute tick data here:
http://cooper.stevenson.name/images/neural_automation_nasdaq.png >> 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? > Note the minute difference-- each of the ohlc variables can change from minute to minute. > 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) > I wrote, successfully, a "date/time" query based on the tick data some time ago. I suspected, through my reading of the documentation, that the "narrowing of the fields--" so to speak--would be more complex than a simple WHERE statement. Thank for your effort. _______________________________________________ PLUG mailing list PLUG@lists.pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug