[PLUG] MSQL Cross-Table Query

D. Cooper Stevenson cooper at cooper.stevenson.name
Tue Mar 2 16:14:57 UTC 2010


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.






More information about the PLUG mailing list