RE: Time series

2004-01-02 Thread Tobias Asplund
Fredrick Bartlett [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 01, 2004 10:12 PM > To: Schulman, Michael; [EMAIL PROTECTED] > Subject: Re: Time series > > > Is Hour a DateTime? If so, will this work... > > SELECT ticker, DATE_FORMAT(Hour,'%H' ), min(pric

RE: Time series

2004-01-02 Thread Chris
od, though I've only used it on a 100,000 row table. It can get a little hairy writing the queries though. Chris -Original Message- From: Schulman, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 7:14 PM To: 'Fredrick Bartlett'; [EMAIL PROTECTED] Subject: RE:

Re: Time series

2004-01-01 Thread Bob Terrell
on 1/1/04 9:59 PM, Schulman, Michael wrote: > That only returns one number.. what we are really looking for is something > like > > SELECT ticker, hour, first(price), last(price) from pricedata group by hour Well, if you're using MySQL 4.1+, you're in luck. A subquery should help. SELECT ticker

Re: Time series

2004-01-01 Thread Will Lowe
>> First: select * from table1 order by field1 asc limit 1 >> Last: select * from table1 order by field1 desc limit 1 > That only returns one number.. what we are really looking for is something And worse: as far as I can tell 3.22.x even if field1 is indexed, ONE of those queries is going to be

Re: Time series - Response....

2004-01-01 Thread Amanullah
a. These are large tables with 40 million rows per day. We've done some initial testing with MySQL and have been extremely impressed with its speed and ease of use. I know that it goes agains the SQL standard but adding a FIRST,LAST aggregate function along with some other time series functi

RE: Time series

2004-01-01 Thread Schulman, Michael
ve is trying to do. Thanks again, Mike -Original Message- From: Fredrick Bartlett [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 10:12 PM To: Schulman, Michael; [EMAIL PROTECTED] Subject: Re: Time series Is Hour a DateTime? If so, will this work... SELECT ticker, DATE_F

Re: Time series

2004-01-01 Thread Fredrick Bartlett
;[EMAIL PROTECTED]> To: "'Fredrick Bartlett'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 01, 2004 6:59 PM Subject: RE: Time series > That only returns one number.. what we are really looking for is something > like > > SELECT ticker

RE: Time series

2004-01-01 Thread Schulman, Michael
: Thursday, January 01, 2004 9:57 PM To: Schulman, Michael; [EMAIL PROTECTED] Subject: Re: Time series Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 - Original Message - From: "Schulman, Michael" <[EMAIL P

Re: Time series

2004-01-01 Thread Fredrick Bartlett
Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 - Original Message - From: "Schulman, Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 01, 2004 6:47 PM Subject: Tim

Time series

2004-01-01 Thread Schulman, Michael
at it goes agains the SQL standard but adding a FIRST,LAST aggregate function along with some other time series functions would allow mysql to compete with just about any timeseries database, and open up mysql to a huge market of financial firms. I know my firm would most likely purchase it.Has a