Am 02.03.2010 20:14, schrieb D. Cooper Stevenson:
> On 03/02/10 13:13, Tim Garton wrote:
> [snip]
>> select m.`date`, m.`time`, m.`close`, g.`close`, a.`close`, i.`close`
>> from msft m
>> join goog g on g.`date` = m.`date` and g.`time` = m.`time`
>> join aapl a on a.`date` = m.`date` and a.`time`
On 03/02/10 13:13, Tim Garton wrote:
[snip]
> select m.`date`, m.`time`, m.`close`, g.`close`, a.`close`, i.`close`
> from msft m
> join goog g on g.`date` = m.`date` and g.`time` = m.`time`
> join aapl a on a.`date` = m.`date` and a.`time` = m.`time`
> join intc i on i.`date` = m.`date` and i.`tim
On Tue, Mar 02, 2010 at 01:13:51PM -0800, Tim Garton wrote:
*applause*
Sorry for idle chatter, but I just wanted to point out Tim's excellent and
well-thought-out response, and strongly recommend it to Cooper.
___
PLUG mailing list
PLUG@lists.pdxlinux
If you know for sure that you are going to have data for every minute
and never duplicate data, and that the `time` column will always be 0
seconds, something like:
select m.`date`, m.`time`, m.`close`, g.`close`, a.`close`, i.`close`
from msft m
join goog g on g.`date` = m.`date` and g.`time` = m
On Tue, 2 Mar 2010, D. Cooper Stevenson wrote:
> No way did I give up on you guys! I'll post a solution once I've struck
> it. I'm seeing a lot of good feedback here--in fact I'm getting so much
> that I have much to go through, keep it up!
Coop,
Rick van der Lans' book, "Introduction to SQL,
On 03/02/10 09:40, Aaron Burt wrote:
> On Tue, Mar 02, 2010 at 08:14:57AM -0800, D. Cooper Stevenson wrote:
>
>> 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 t
On 03/02/10 10:29, Michael wrote:
> OK, I see your use and you are doing what you want.
>
> However...
>
> On any given day for a particular equity the opening price is a single
> value.
> The opening price does not change through the day. It was
> fixed at the first trade of the day.
>
The o
D. Cooper Stevenson wrote:
> 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
On Tue, Mar 02, 2010 at 08:14:57AM -0800, D. Cooper Stevenson wrote:
> 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
Am 02.03.2010 09:49, schrieb Carlos Konstanski:
> Am 02.03.2010 01:09, schrieb D. Cooper Stevenson:
>> Hello Everyone,
>>
>> I've worked through the documentation but haven't yet worked out a
>> cross-table query in MYSQL yielding the correct results. My goal is to
>> pull data from four tables tha
Am 02.03.2010 09:49, schrieb Carlos Konstanski:
> Am 02.03.2010 01:09, schrieb D. Cooper Stevenson:
>> Hello Everyone,
>>
>> I've worked through the documentation but haven't yet worked out a
>> cross-table query in MYSQL yielding the correct results. My goal is to
>> pull data from four tables tha
Am 02.03.2010 01:09, schrieb D. Cooper Stevenson:
> Hello Everyone,
>
> I've worked through the documentation but haven't yet worked out a
> cross-table query in MYSQL yielding the correct results. My goal is to
> pull data from four tables that correspond to the date-time stamp of the
> first tab
> 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.
Glad you were able to get it working.
I would sug
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 th
On Tue, Mar 2, 2010 at 7:36 AM, Rich Shepard wrote:
> On Tue, 2 Mar 2010, Patrick J. Timlick wrote:
>
>> select m.close, a.close, g.close, i.close from msft m, aapl a, goog g,
>> intc i where date = "$date" and time = "$time"
>>
>> I don't think this works because date and time are ambiguous; they
On Tue, 2 Mar 2010, Patrick J. Timlick wrote:
> select m.close, a.close, g.close, i.close from msft m, aapl a, goog g,
> intc i where date = "$date" and time = "$time"
>
> I don't think this works because date and time are ambiguous; they could be
> from any of the 4 tables.
Yup.
If the da
select m.close, a.close, g.close, i.close from msft m, aapl a, goog g,
intc i where date = "$date" and time = "$time"
I don't think this works because date and time are ambiguous; they could be
from any of the 4 tables.
When you write a join without join criteria the transitive closure of all
row
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
Pending an announcement from David, I wanted to provide a headsup that
I've got Jeri lined up to speak again this month. If she gets sick
again, I'll have to leave town. I just added a calagator event.
http://calagator.org/events/1250458374
--
Russell Senior ``I have nine fingers;
MEETING ANNOUNCEMENT
The Portland Linux/Unix Group
will meet
7 PM Thursday Mar 4, 2010
at
Portland State University
On Tue, Mar 2, 2010 at 12:20 AM, drew wymore wrote:
> On Tue, Mar 2, 2010 at 12:09 AM, D. Cooper Stevenson
> wrote:
>> Hello Everyone,
>>
>> I've worked through the documentation but haven't yet worked out a
>> cross-table query in MYSQL yielding the correct results. My goal is to
>> pull data fr
On Tue, Mar 2, 2010 at 12:09 AM, D. Cooper Stevenson
wrote:
> Hello Everyone,
>
> I've worked through the documentation but haven't yet worked out a
> cross-table query in MYSQL yielding the correct results. My goal is to
> pull data from four tables that correspond to the date-time stamp of the
>
Hello Everyone,
I've worked through the documentation but haven't yet worked out a
cross-table query in MYSQL yielding the correct results. My goal is to
pull data from four tables that correspond to the date-time stamp of the
first table. This will make sense as I describe what I am trying to pul
23 matches
Mail list logo