Re: Aggregate intraday data
Posted by:
Rick James
Date: January 16, 2014 07:10PM
> 1) How to modify this query to get 100 daily aggregated rows?
SELECT @ago := `date` FROM F ORDER BY `date` DESC LIMIT 100,1;
SELECT ... WHERE `date` >= @ago ...;
(I may be off by 1.)
You will still get less than 100 rows if a symbol is 'new' or 'delisted' during the 100 days.
Subject
Written By
Posted
Re: Aggregate intraday data
January 16, 2014 07:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.