Calculate an exponential moving average  
Author Message
Rainaelan





PostPosted: Wed Nov 15 00:41:01 CST 2006 Top

SQL Server Developer >> Calculate an exponential moving average

Hi there,

I'm wondering if this is possible in SQL Server 2005. I need to calculate the exponential moving average (EMA)
for a financial application. The moving average period is 34, thus a 34EMA. The formula for calculating the
EMA for a price is:

EMA(current) = ( (Price(current) - EMA(prev) ) x Multiplier) + EMA(prev)

Multiplier is calculated as 2/(1+N) where N is the period (in our case, 34). We can therefore substitute
Multiplier with 0.05714.

Now, what may strike you is we need a recursive query, however we need an initial value to seed the recursion.
For my purposes the price on Oct 16, 2006 at 09:30 will be fine as the seed price for the first EMA(prev) in
the query. Now, using the table and data below I'm wondering if it's possible using functions or just a
straight SQL statement to get the 34EMA for each row in the prices table. In other words, I'd like to add a
4th column called 34EMA to the table and populate it using the formula above.

Is this possible with SQL Server?

Thanks for your help!!

CREATE TABLE [dbo].[prices](
[priceid] [int] NULL,
[dtbar] [datetime] NULL,
[price] [money] NULL
)

INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51379,'Oct 16 2006 9:30:00:000AM',768.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51380,'Oct 16 2006 9:35:00:000AM',768.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51381,'Oct 16 2006 9:40:00:000AM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51382,'Oct 16 2006 9:45:00:000AM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51383,'Oct 16 2006 9:50:00:000AM',770.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51384,'Oct 16 2006 9:55:00:000AM',770.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51385,'Oct 16 2006 10:00:00:000AM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51386,'Oct 16 2006 10:05:00:000AM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51387,'Oct 16 2006 10:10:00:000AM',773.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51388,'Oct 16 2006 10:15:00:000AM',774.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51389,'Oct 16 2006 10:20:00:000AM',773.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51390,'Oct 16 2006 10:25:00:000AM',774.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51391,'Oct 16 2006 10:30:00:000AM',772.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51392,'Oct 16 2006 10:35:00:000AM',772.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51393,'Oct 16 2006 10:40:00:000AM',772.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51394,'Oct 16 2006 10:45:00:000AM',771.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51395,'Oct 16 2006 10:50:00:000AM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51396,'Oct 16 2006 10:55:00:000AM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51397,'Oct 16 2006 11:00:00:000AM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51398,'Oct 16 2006 11:05:00:000AM',773.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51399,'Oct 16 2006 11:10:00:000AM',773.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51400,'Oct 16 2006 11:15:00:000AM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51401,'Oct 16 2006 11:20:00:000AM',773.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51402,'Oct 16 2006 11:25:00:000AM',773.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51403,'Oct 16 2006 11:30:00:000AM',773.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51404,'Oct 16 2006 11:35:00:000AM',774.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51405,'Oct 16 2006 11:40:00:000AM',773.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51406,'Oct 16 2006 11:45:00:000AM',773.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51407,'Oct 16 2006 11:50:00:000AM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51408,'Oct 16 2006 11:55:00:000AM',773.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51409,'Oct 16 2006 12:00:00:000PM',773.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51410,'Oct 16 2006 12:05:00:000PM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51411,'Oct 16 2006 12:10:00:000PM',773.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51412,'Oct 16 2006 12:15:00:000PM',772.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51413,'Oct 16 2006 12:20:00:000PM',772.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51414,'Oct 16 2006 12:25:00:000PM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51415,'Oct 16 2006 12:30:00:000PM',772.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51416,'Oct 16 2006 12:35:00:000PM',773.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51417,'Oct 16 2006 12:40:00:000PM',773.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51418,'Oct 16 2006 12:45:00:000PM',773.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51419,'Oct 16 2006 12:50:00:000PM',772.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51420,'Oct 16 2006 12:55:00:000PM',773.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51421,'Oct 16 2006 1:00:00:000PM',772.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51422,'Oct 16 2006 1:05:00:000PM',773.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51423,'Oct 16 2006 1:10:00:000PM',773.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51424,'Oct 16 2006 1:15:00:000PM',773.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51425,'Oct 16 2006 1:20:00:000PM',773.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51426,'Oct 16 2006 1:25:00:000PM',774.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51427,'Oct 16 2006 1:30:00:000PM',774.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51428,'Oct 16 2006 1:35:00:000PM',774.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51429,'Oct 16 2006 1:40:00:000PM',774.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51430,'Oct 16 2006 1:45:00:000PM',774.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51431,'Oct 16 2006 1:50:00:000PM',774.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51432,'Oct 16 2006 1:55:00:000PM',774.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51433,'Oct 16 2006 2:00:00:000PM',774.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51434,'Oct 16 2006 2:05:00:000PM',773.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51435,'Oct 16 2006 2:10:00:000PM',773.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51436,'Oct 16 2006 2:15:00:000PM',773.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51437,'Oct 16 2006 2:20:00:000PM',773.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51438,'Oct 16 2006 2:25:00:000PM',773.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51439,'Oct 16 2006 2:30:00:000PM',774.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51440,'Oct 16 2006 2:35:00:000PM',773.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51441,'Oct 16 2006 2:40:00:000PM',773.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51442,'Oct 16 2006 2:45:00:000PM',774.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51443,'Oct 16 2006 2:50:00:000PM',773.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51444,'Oct 16 2006 2:55:00:000PM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51445,'Oct 16 2006 3:00:00:000PM',773.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51446,'Oct 16 2006 3:05:00:000PM',773.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51447,'Oct 16 2006 3:10:00:000PM',774.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51448,'Oct 16 2006 3:15:00:000PM',774.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51449,'Oct 16 2006 3:20:00:000PM',774.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51450,'Oct 16 2006 3:25:00:000PM',774.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51451,'Oct 16 2006 3:30:00:000PM',774.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51452,'Oct 16 2006 3:35:00:000PM',775.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51453,'Oct 16 2006 3:40:00:000PM',775.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51454,'Oct 16 2006 3:45:00:000PM',775.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51455,'Oct 16 2006 3:50:00:000PM',775.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51456,'Oct 16 2006 3:55:00:000PM',774.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51457,'Oct 16 2006 4:00:00:000PM',774.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51458,'Oct 16 2006 4:05:00:000PM',774.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51459,'Oct 16 2006 4:10:00:000PM',773.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51460,'Oct 17 2006 9:30:00:000AM',769.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51461,'Oct 17 2006 9:35:00:000AM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51462,'Oct 17 2006 9:40:00:000AM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51463,'Oct 17 2006 9:45:00:000AM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51464,'Oct 17 2006 9:50:00:000AM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51465,'Oct 17 2006 9:55:00:000AM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51466,'Oct 17 2006 10:00:00:000AM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51467,'Oct 17 2006 10:05:00:000AM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51468,'Oct 17 2006 10:10:00:000AM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51469,'Oct 17 2006 10:15:00:000AM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51470,'Oct 17 2006 10:20:00:000AM',767.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51471,'Oct 17 2006 10:25:00:000AM',766.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51472,'Oct 17 2006 10:30:00:000AM',765.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51473,'Oct 17 2006 10:35:00:000AM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51474,'Oct 17 2006 10:40:00:000AM',765.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51475,'Oct 17 2006 10:45:00:000AM',765.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51476,'Oct 17 2006 10:50:00:000AM',765.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51477,'Oct 17 2006 10:55:00:000AM',765.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51478,'Oct 17 2006 11:00:00:000AM',763.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51479,'Oct 17 2006 11:05:00:000AM',764.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51480,'Oct 17 2006 11:10:00:000AM',764.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51481,'Oct 17 2006 11:15:00:000AM',764.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51482,'Oct 17 2006 11:20:00:000AM',763.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51483,'Oct 17 2006 11:25:00:000AM',763.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51484,'Oct 17 2006 11:30:00:000AM',764.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51485,'Oct 17 2006 11:35:00:000AM',764.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51486,'Oct 17 2006 11:40:00:000AM',764.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51487,'Oct 17 2006 11:45:00:000AM',764.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51488,'Oct 17 2006 11:50:00:000AM',763.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51489,'Oct 17 2006 11:55:00:000AM',764.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51490,'Oct 17 2006 12:00:00:000PM',764.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51491,'Oct 17 2006 12:05:00:000PM',764.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51492,'Oct 17 2006 12:10:00:000PM',765.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51493,'Oct 17 2006 12:15:00:000PM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51494,'Oct 17 2006 12:20:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51495,'Oct 17 2006 12:25:00:000PM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51496,'Oct 17 2006 12:30:00:000PM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51497,'Oct 17 2006 12:35:00:000PM',766.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51498,'Oct 17 2006 12:40:00:000PM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51499,'Oct 17 2006 12:45:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51500,'Oct 17 2006 12:50:00:000PM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51501,'Oct 17 2006 12:55:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51502,'Oct 17 2006 1:00:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51503,'Oct 17 2006 1:05:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51504,'Oct 17 2006 1:10:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51505,'Oct 17 2006 1:15:00:000PM',767.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51506,'Oct 17 2006 1:20:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51507,'Oct 17 2006 1:25:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51508,'Oct 17 2006 1:30:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51509,'Oct 17 2006 1:35:00:000PM',767.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51510,'Oct 17 2006 1:40:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51511,'Oct 17 2006 1:45:00:000PM',768.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51512,'Oct 17 2006 1:50:00:000PM',769.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51513,'Oct 17 2006 1:55:00:000PM',769.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51514,'Oct 17 2006 2:00:00:000PM',769.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51515,'Oct 17 2006 2:05:00:000PM',769.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51516,'Oct 17 2006 2:10:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51517,'Oct 17 2006 2:15:00:000PM',769.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51518,'Oct 17 2006 2:20:00:000PM',769.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51519,'Oct 17 2006 2:25:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51520,'Oct 17 2006 2:30:00:000PM',768.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51521,'Oct 17 2006 2:35:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51522,'Oct 17 2006 2:40:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51523,'Oct 17 2006 2:45:00:000PM',768.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51524,'Oct 17 2006 2:50:00:000PM',769.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51525,'Oct 17 2006 2:55:00:000PM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51526,'Oct 17 2006 3:00:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51527,'Oct 17 2006 3:05:00:000PM',771.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51528,'Oct 17 2006 3:10:00:000PM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51529,'Oct 17 2006 3:15:00:000PM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51530,'Oct 17 2006 3:20:00:000PM',771.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51531,'Oct 17 2006 3:25:00:000PM',772.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51532,'Oct 17 2006 3:30:00:000PM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51533,'Oct 17 2006 3:35:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51534,'Oct 17 2006 3:40:00:000PM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51535,'Oct 17 2006 3:45:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51536,'Oct 17 2006 3:50:00:000PM',769.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51537,'Oct 17 2006 3:55:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51538,'Oct 17 2006 4:00:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51539,'Oct 17 2006 4:05:00:000PM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51540,'Oct 17 2006 4:10:00:000PM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51541,'Oct 18 2006 9:30:00:000AM',776.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51542,'Oct 18 2006 9:35:00:000AM',776.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51543,'Oct 18 2006 9:40:00:000AM',776.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51544,'Oct 18 2006 9:45:00:000AM',776.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51545,'Oct 18 2006 9:50:00:000AM',775.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51546,'Oct 18 2006 9:55:00:000AM',773.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51547,'Oct 18 2006 10:00:00:000AM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51548,'Oct 18 2006 10:05:00:000AM',772.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51549,'Oct 18 2006 10:10:00:000AM',773.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51550,'Oct 18 2006 10:15:00:000AM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51551,'Oct 18 2006 10:20:00:000AM',770.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51552,'Oct 18 2006 10:25:00:000AM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51553,'Oct 18 2006 10:30:00:000AM',770.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51554,'Oct 18 2006 10:35:00:000AM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51555,'Oct 18 2006 10:40:00:000AM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51556,'Oct 18 2006 10:45:00:000AM',769.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51557,'Oct 18 2006 10:50:00:000AM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51558,'Oct 18 2006 10:55:00:000AM',770.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51559,'Oct 18 2006 11:00:00:000AM',769.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51560,'Oct 18 2006 11:05:00:000AM',769.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51561,'Oct 18 2006 11:10:00:000AM',770.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51562,'Oct 18 2006 11:15:00:000AM',772.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51563,'Oct 18 2006 11:20:00:000AM',772.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51564,'Oct 18 2006 11:25:00:000AM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51565,'Oct 18 2006 11:30:00:000AM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51566,'Oct 18 2006 11:35:00:000AM',772.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51567,'Oct 18 2006 11:40:00:000AM',771.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51568,'Oct 18 2006 11:45:00:000AM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51569,'Oct 18 2006 11:50:00:000AM',772.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51570,'Oct 18 2006 11:55:00:000AM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51571,'Oct 18 2006 12:00:00:000PM',772.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51572,'Oct 18 2006 12:05:00:000PM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51573,'Oct 18 2006 12:10:00:000PM',772.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51574,'Oct 18 2006 12:15:00:000PM',772.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51575,'Oct 18 2006 12:20:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51576,'Oct 18 2006 12:25:00:000PM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51577,'Oct 18 2006 12:30:00:000PM',772.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51578,'Oct 18 2006 12:35:00:000PM',772.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51579,'Oct 18 2006 12:40:00:000PM',771.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51580,'Oct 18 2006 12:45:00:000PM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51581,'Oct 18 2006 12:50:00:000PM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51582,'Oct 18 2006 12:55:00:000PM',769.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51583,'Oct 18 2006 1:00:00:000PM',769.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51584,'Oct 18 2006 1:05:00:000PM',769.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51585,'Oct 18 2006 1:10:00:000PM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51586,'Oct 18 2006 1:15:00:000PM',768.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51587,'Oct 18 2006 1:20:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51588,'Oct 18 2006 1:25:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51589,'Oct 18 2006 1:30:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51590,'Oct 18 2006 1:35:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51591,'Oct 18 2006 1:40:00:000PM',767.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51592,'Oct 18 2006 1:45:00:000PM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51593,'Oct 18 2006 1:50:00:000PM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51594,'Oct 18 2006 1:55:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51595,'Oct 18 2006 2:00:00:000PM',767.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51596,'Oct 18 2006 2:05:00:000PM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51597,'Oct 18 2006 2:10:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51598,'Oct 18 2006 2:15:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51599,'Oct 18 2006 2:20:00:000PM',768.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51600,'Oct 18 2006 2:25:00:000PM',768.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51601,'Oct 18 2006 2:30:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51602,'Oct 18 2006 2:35:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51603,'Oct 18 2006 2:40:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51604,'Oct 18 2006 2:45:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51605,'Oct 18 2006 2:50:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51606,'Oct 18 2006 2:55:00:000PM',768.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51607,'Oct 18 2006 3:00:00:000PM',768.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51608,'Oct 18 2006 3:05:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51609,'Oct 18 2006 3:10:00:000PM',768.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51610,'Oct 18 2006 3:15:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51611,'Oct 18 2006 3:20:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51612,'Oct 18 2006 3:25:00:000PM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51613,'Oct 18 2006 3:30:00:000PM',768.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51614,'Oct 18 2006 3:35:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51615,'Oct 18 2006 3:40:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51616,'Oct 18 2006 3:45:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51617,'Oct 18 2006 3:50:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51618,'Oct 18 2006 3:55:00:000PM',768.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51619,'Oct 18 2006 4:00:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51620,'Oct 18 2006 4:05:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51621,'Oct 18 2006 4:10:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51622,'Oct 19 2006 9:30:00:000AM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51623,'Oct 19 2006 9:35:00:000AM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51624,'Oct 19 2006 9:40:00:000AM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51625,'Oct 19 2006 9:45:00:000AM',769.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51626,'Oct 19 2006 9:50:00:000AM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51627,'Oct 19 2006 9:55:00:000AM',771.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51628,'Oct 19 2006 10:00:00:000AM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51629,'Oct 19 2006 10:05:00:000AM',773.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51630,'Oct 19 2006 10:10:00:000AM',773.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51631,'Oct 19 2006 10:15:00:000AM',772.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51632,'Oct 19 2006 10:20:00:000AM',772.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51633,'Oct 19 2006 10:25:00:000AM',772.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51634,'Oct 19 2006 10:30:00:000AM',772.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51635,'Oct 19 2006 10:35:00:000AM',772.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51636,'Oct 19 2006 10:40:00:000AM',772.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51637,'Oct 19 2006 10:45:00:000AM',772.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51638,'Oct 19 2006 10:50:00:000AM',772.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51639,'Oct 19 2006 10:55:00:000AM',772.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51640,'Oct 19 2006 11:00:00:000AM',770.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51641,'Oct 19 2006 11:05:00:000AM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51642,'Oct 19 2006 11:10:00:000AM',771.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51643,'Oct 19 2006 11:15:00:000AM',771.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51644,'Oct 19 2006 11:20:00:000AM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51645,'Oct 19 2006 11:25:00:000AM',771.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51646,'Oct 19 2006 11:30:00:000AM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51647,'Oct 19 2006 11:35:00:000AM',772.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51648,'Oct 19 2006 11:40:00:000AM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51649,'Oct 19 2006 11:45:00:000AM',771.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51650,'Oct 19 2006 11:50:00:000AM',772.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51651,'Oct 19 2006 11:55:00:000AM',771.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51652,'Oct 19 2006 12:00:00:000PM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51653,'Oct 19 2006 12:05:00:000PM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51654,'Oct 19 2006 12:10:00:000PM',772.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51655,'Oct 19 2006 12:15:00:000PM',772.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51656,'Oct 19 2006 12:20:00:000PM',771.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51657,'Oct 19 2006 12:25:00:000PM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51658,'Oct 19 2006 12:30:00:000PM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51659,'Oct 19 2006 12:35:00:000PM',771.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51660,'Oct 19 2006 12:40:00:000PM',770.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51661,'Oct 19 2006 12:45:00:000PM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51662,'Oct 19 2006 12:50:00:000PM',769.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51663,'Oct 19 2006 12:55:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51664,'Oct 19 2006 1:00:00:000PM',769.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51665,'Oct 19 2006 1:05:00:000PM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51666,'Oct 19 2006 1:10:00:000PM',770.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51667,'Oct 19 2006 1:15:00:000PM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51668,'Oct 19 2006 1:20:00:000PM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51669,'Oct 19 2006 1:25:00:000PM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51670,'Oct 19 2006 1:30:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51671,'Oct 19 2006 1:35:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51672,'Oct 19 2006 1:40:00:000PM',771.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51673,'Oct 19 2006 1:45:00:000PM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51674,'Oct 19 2006 1:50:00:000PM',770.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51675,'Oct 19 2006 1:55:00:000PM',770.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51676,'Oct 19 2006 2:00:00:000PM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51677,'Oct 19 2006 2:05:00:000PM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51678,'Oct 19 2006 2:10:00:000PM',770.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51679,'Oct 19 2006 2:15:00:000PM',771.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51680,'Oct 19 2006 2:20:00:000PM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51681,'Oct 19 2006 2:25:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51682,'Oct 19 2006 2:30:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51683,'Oct 19 2006 2:35:00:000PM',771.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51684,'Oct 19 2006 2:40:00:000PM',770.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51685,'Oct 19 2006 2:45:00:000PM',771.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51686,'Oct 19 2006 2:50:00:000PM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51687,'Oct 19 2006 2:55:00:000PM',772.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51688,'Oct 19 2006 3:00:00:000PM',771.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51689,'Oct 19 2006 3:05:00:000PM',771.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51690,'Oct 19 2006 3:10:00:000PM',770.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51691,'Oct 19 2006 3:15:00:000PM',770.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51692,'Oct 19 2006 3:20:00:000PM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51693,'Oct 19 2006 3:25:00:000PM',771.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51694,'Oct 19 2006 3:30:00:000PM',771.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51695,'Oct 19 2006 3:35:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51696,'Oct 19 2006 3:40:00:000PM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51697,'Oct 19 2006 3:45:00:000PM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51698,'Oct 19 2006 3:50:00:000PM',771.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51699,'Oct 19 2006 3:55:00:000PM',772.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51700,'Oct 19 2006 4:00:00:000PM',772.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51701,'Oct 19 2006 4:05:00:000PM',772.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51702,'Oct 19 2006 4:10:00:000PM',772.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51703,'Oct 20 2006 9:30:00:000AM',771.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51704,'Oct 20 2006 9:35:00:000AM',770.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51705,'Oct 20 2006 9:40:00:000AM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51706,'Oct 20 2006 9:45:00:000AM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51707,'Oct 20 2006 9:50:00:000AM',767.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51708,'Oct 20 2006 9:55:00:000AM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51709,'Oct 20 2006 10:00:00:000AM',766.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51710,'Oct 20 2006 10:05:00:000AM',765.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51711,'Oct 20 2006 10:10:00:000AM',764.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51712,'Oct 20 2006 10:15:00:000AM',765.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51713,'Oct 20 2006 10:20:00:000AM',766.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51714,'Oct 20 2006 10:25:00:000AM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51715,'Oct 20 2006 10:30:00:000AM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51716,'Oct 20 2006 10:35:00:000AM',767.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51717,'Oct 20 2006 10:40:00:000AM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51718,'Oct 20 2006 10:45:00:000AM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51719,'Oct 20 2006 10:50:00:000AM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51720,'Oct 20 2006 10:55:00:000AM',767.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51721,'Oct 20 2006 11:00:00:000AM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51722,'Oct 20 2006 11:05:00:000AM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51723,'Oct 20 2006 11:10:00:000AM',766.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51724,'Oct 20 2006 11:15:00:000AM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51725,'Oct 20 2006 11:20:00:000AM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51726,'Oct 20 2006 11:25:00:000AM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51727,'Oct 20 2006 11:30:00:000AM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51728,'Oct 20 2006 11:35:00:000AM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51729,'Oct 20 2006 11:40:00:000AM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51730,'Oct 20 2006 11:45:00:000AM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51731,'Oct 20 2006 11:50:00:000AM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51732,'Oct 20 2006 11:55:00:000AM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51733,'Oct 20 2006 12:00:00:000PM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51734,'Oct 20 2006 12:05:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51735,'Oct 20 2006 12:10:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51736,'Oct 20 2006 12:15:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51737,'Oct 20 2006 12:20:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51738,'Oct 20 2006 12:25:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51739,'Oct 20 2006 12:30:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51740,'Oct 20 2006 12:35:00:000PM',768.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51741,'Oct 20 2006 12:40:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51742,'Oct 20 2006 12:45:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51743,'Oct 20 2006 12:50:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51744,'Oct 20 2006 12:55:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51745,'Oct 20 2006 1:00:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51746,'Oct 20 2006 1:05:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51747,'Oct 20 2006 1:10:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51748,'Oct 20 2006 1:15:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51749,'Oct 20 2006 1:20:00:000PM',768.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51750,'Oct 20 2006 1:25:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51751,'Oct 20 2006 1:30:00:000PM',768.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51752,'Oct 20 2006 1:35:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51753,'Oct 20 2006 1:40:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51754,'Oct 20 2006 1:45:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51755,'Oct 20 2006 1:50:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51756,'Oct 20 2006 1:55:00:000PM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51757,'Oct 20 2006 2:00:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51758,'Oct 20 2006 2:05:00:000PM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51759,'Oct 20 2006 2:10:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51760,'Oct 20 2006 2:15:00:000PM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51761,'Oct 20 2006 2:20:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51762,'Oct 20 2006 2:25:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51763,'Oct 20 2006 2:30:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51764,'Oct 20 2006 2:35:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51765,'Oct 20 2006 2:40:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51766,'Oct 20 2006 2:45:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51767,'Oct 20 2006 2:50:00:000PM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51768,'Oct 20 2006 2:55:00:000PM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51769,'Oct 20 2006 3:00:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51770,'Oct 20 2006 3:05:00:000PM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51771,'Oct 20 2006 3:10:00:000PM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51772,'Oct 20 2006 3:15:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51773,'Oct 20 2006 3:20:00:000PM',768.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51774,'Oct 20 2006 3:25:00:000PM',768.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51775,'Oct 20 2006 3:30:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51776,'Oct 20 2006 3:35:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51777,'Oct 20 2006 3:40:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51778,'Oct 20 2006 3:45:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51779,'Oct 20 2006 3:50:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51780,'Oct 20 2006 3:55:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51781,'Oct 20 2006 4:00:00:000PM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51782,'Oct 20 2006 4:05:00:000PM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51783,'Oct 20 2006 4:10:00:000PM',765.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51784,'Oct 20 2006 4:15:00:000PM',764.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51785,'Oct 23 2006 9:30:00:000AM',762.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51786,'Oct 23 2006 9:35:00:000AM',762.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51787,'Oct 23 2006 9:40:00:000AM',763.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51788,'Oct 23 2006 9:45:00:000AM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51789,'Oct 23 2006 9:50:00:000AM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51790,'Oct 23 2006 9:55:00:000AM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51791,'Oct 23 2006 10:00:00:000AM',765.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51792,'Oct 23 2006 10:05:00:000AM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51793,'Oct 23 2006 10:10:00:000AM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51794,'Oct 23 2006 10:15:00:000AM',768.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51795,'Oct 23 2006 10:20:00:000AM',769.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51796,'Oct 23 2006 10:25:00:000AM',771.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51797,'Oct 23 2006 10:30:00:000AM',771.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51798,'Oct 23 2006 10:35:00:000AM',770.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51799,'Oct 23 2006 10:40:00:000AM',769.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51800,'Oct 23 2006 10:45:00:000AM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51801,'Oct 23 2006 10:50:00:000AM',769.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51802,'Oct 23 2006 10:55:00:000AM',769.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51803,'Oct 23 2006 11:00:00:000AM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51804,'Oct 23 2006 11:05:00:000AM',771.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51805,'Oct 23 2006 11:10:00:000AM',771.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51806,'Oct 23 2006 11:15:00:000AM',771.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51807,'Oct 23 2006 11:20:00:000AM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51808,'Oct 23 2006 11:25:00:000AM',769.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51809,'Oct 23 2006 11:30:00:000AM',769.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51810,'Oct 23 2006 11:35:00:000AM',769.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51811,'Oct 23 2006 11:40:00:000AM',769.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51812,'Oct 23 2006 11:45:00:000AM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51813,'Oct 23 2006 11:50:00:000AM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51814,'Oct 23 2006 11:55:00:000AM',769.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51815,'Oct 23 2006 12:00:00:000PM',769.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51816,'Oct 23 2006 12:05:00:000PM',769.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51817,'Oct 23 2006 12:10:00:000PM',769.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51818,'Oct 23 2006 12:15:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51819,'Oct 23 2006 12:20:00:000PM',770.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51820,'Oct 23 2006 12:25:00:000PM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51821,'Oct 23 2006 12:30:00:000PM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51822,'Oct 23 2006 12:35:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51823,'Oct 23 2006 12:40:00:000PM',769.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51824,'Oct 23 2006 12:45:00:000PM',768.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51825,'Oct 23 2006 12:50:00:000PM',768.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51826,'Oct 23 2006 12:55:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51827,'Oct 23 2006 1:00:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51828,'Oct 23 2006 1:05:00:000PM',768.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51829,'Oct 23 2006 1:10:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51830,'Oct 23 2006 1:15:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51831,'Oct 23 2006 1:20:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51832,'Oct 23 2006 1:25:00:000PM',769.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51833,'Oct 23 2006 1:30:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51834,'Oct 23 2006 1:35:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51835,'Oct 23 2006 1:40:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51836,'Oct 23 2006 1:45:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51837,'Oct 23 2006 1:50:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51838,'Oct 23 2006 1:55:00:000PM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51839,'Oct 23 2006 2:00:00:000PM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51840,'Oct 23 2006 2:05:00:000PM',765.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51841,'Oct 23 2006 2:10:00:000PM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51842,'Oct 23 2006 2:15:00:000PM',764.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51843,'Oct 23 2006 2:20:00:000PM',764.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51844,'Oct 23 2006 2:25:00:000PM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51845,'Oct 23 2006 2:30:00:000PM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51846,'Oct 23 2006 2:35:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51847,'Oct 23 2006 2:40:00:000PM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51848,'Oct 23 2006 2:45:00:000PM',767.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51849,'Oct 23 2006 2:50:00:000PM',767.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51850,'Oct 23 2006 2:55:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51851,'Oct 23 2006 3:00:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51852,'Oct 23 2006 3:05:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51853,'Oct 23 2006 3:10:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51854,'Oct 23 2006 3:15:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51855,'Oct 23 2006 3:20:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51856,'Oct 23 2006 3:25:00:000PM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51857,'Oct 23 2006 3:30:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51858,'Oct 23 2006 3:35:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51859,'Oct 23 2006 3:40:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51860,'Oct 23 2006 3:45:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51861,'Oct 23 2006 3:50:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51862,'Oct 23 2006 3:55:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51863,'Oct 23 2006 4:00:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51864,'Oct 23 2006 4:05:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51865,'Oct 23 2006 4:10:00:000PM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51866,'Oct 23 2006 4:15:00:000PM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51867,'Oct 24 2006 9:30:00:000AM',763.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51868,'Oct 24 2006 9:35:00:000AM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51869,'Oct 24 2006 9:40:00:000AM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51870,'Oct 24 2006 9:45:00:000AM',768.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51871,'Oct 24 2006 9:50:00:000AM',767.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51872,'Oct 24 2006 9:55:00:000AM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51873,'Oct 24 2006 10:00:00:000AM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51874,'Oct 24 2006 10:05:00:000AM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51875,'Oct 24 2006 10:10:00:000AM',765.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51876,'Oct 24 2006 10:15:00:000AM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51877,'Oct 24 2006 10:20:00:000AM',765.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51878,'Oct 24 2006 10:25:00:000AM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51879,'Oct 24 2006 10:30:00:000AM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51880,'Oct 24 2006 10:35:00:000AM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51881,'Oct 24 2006 10:40:00:000AM',764.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51882,'Oct 24 2006 10:45:00:000AM',765.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51883,'Oct 24 2006 10:50:00:000AM',764.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51884,'Oct 24 2006 10:55:00:000AM',765.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51885,'Oct 24 2006 11:00:00:000AM',765.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51886,'Oct 24 2006 11:05:00:000AM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51887,'Oct 24 2006 11:10:00:000AM',765.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51888,'Oct 24 2006 11:15:00:000AM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51889,'Oct 24 2006 11:20:00:000AM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51890,'Oct 24 2006 11:25:00:000AM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51891,'Oct 24 2006 11:30:00:000AM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51892,'Oct 24 2006 11:35:00:000AM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51893,'Oct 24 2006 11:40:00:000AM',766.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51894,'Oct 24 2006 11:45:00:000AM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51895,'Oct 24 2006 11:50:00:000AM',766.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51896,'Oct 24 2006 11:55:00:000AM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51897,'Oct 24 2006 12:00:00:000PM',766.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51898,'Oct 24 2006 12:05:00:000PM',766.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51899,'Oct 24 2006 12:10:00:000PM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51900,'Oct 24 2006 12:15:00:000PM',765.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51901,'Oct 24 2006 12:20:00:000PM',765.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51902,'Oct 24 2006 12:25:00:000PM',765.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51903,'Oct 24 2006 12:30:00:000PM',765.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51904,'Oct 24 2006 12:35:00:000PM',765.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51905,'Oct 24 2006 12:40:00:000PM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51906,'Oct 24 2006 12:45:00:000PM',764.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51907,'Oct 24 2006 12:50:00:000PM',763.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51908,'Oct 24 2006 12:55:00:000PM',762.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51909,'Oct 24 2006 1:00:00:000PM',763.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51910,'Oct 24 2006 1:05:00:000PM',762.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51911,'Oct 24 2006 1:10:00:000PM',763.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51912,'Oct 24 2006 1:15:00:000PM',763.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51913,'Oct 24 2006 1:20:00:000PM',763.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51914,'Oct 24 2006 1:25:00:000PM',763.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51915,'Oct 24 2006 1:30:00:000PM',764.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51916,'Oct 24 2006 1:35:00:000PM',764.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51917,'Oct 24 2006 1:40:00:000PM',763.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51918,'Oct 24 2006 1:45:00:000PM',763.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51919,'Oct 24 2006 1:50:00:000PM',763.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51920,'Oct 24 2006 1:55:00:000PM',764.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51921,'Oct 24 2006 2:00:00:000PM',763.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51922,'Oct 24 2006 2:05:00:000PM',765.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51923,'Oct 24 2006 2:10:00:000PM',764.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51924,'Oct 24 2006 2:15:00:000PM',765.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51925,'Oct 24 2006 2:20:00:000PM',765.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51926,'Oct 24 2006 2:25:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51927,'Oct 24 2006 2:30:00:000PM',765.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51928,'Oct 24 2006 2:35:00:000PM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51929,'Oct 24 2006 2:40:00:000PM',765.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51930,'Oct 24 2006 2:45:00:000PM',765.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51931,'Oct 24 2006 2:50:00:000PM',765.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51932,'Oct 24 2006 2:55:00:000PM',765.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51933,'Oct 24 2006 3:00:00:000PM',766.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51934,'Oct 24 2006 3:05:00:000PM',765.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51935,'Oct 24 2006 3:10:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51936,'Oct 24 2006 3:15:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51937,'Oct 24 2006 3:20:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51938,'Oct 24 2006 3:25:00:000PM',766.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51939,'Oct 24 2006 3:30:00:000PM',765.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51940,'Oct 24 2006 3:35:00:000PM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51941,'Oct 24 2006 3:40:00:000PM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51942,'Oct 24 2006 3:45:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51943,'Oct 24 2006 3:50:00:000PM',767.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51944,'Oct 24 2006 3:55:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51945,'Oct 24 2006 4:00:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51946,'Oct 24 2006 4:05:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51947,'Oct 24 2006 4:10:00:000PM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51948,'Oct 25 2006 9:30:00:000AM',768.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51949,'Oct 25 2006 9:35:00:000AM',767.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51950,'Oct 25 2006 9:40:00:000AM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51951,'Oct 25 2006 9:45:00:000AM',769.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51952,'Oct 25 2006 9:50:00:000AM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51953,'Oct 25 2006 9:55:00:000AM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51954,'Oct 25 2006 10:00:00:000AM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51955,'Oct 25 2006 10:05:00:000AM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51956,'Oct 25 2006 10:10:00:000AM',772.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51957,'Oct 25 2006 10:15:00:000AM',772.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51958,'Oct 25 2006 10:20:00:000AM',772.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51959,'Oct 25 2006 10:25:00:000AM',772.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51960,'Oct 25 2006 10:30:00:000AM',771.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51961,'Oct 25 2006 10:35:00:000AM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51962,'Oct 25 2006 10:40:00:000AM',771.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51963,'Oct 25 2006 10:45:00:000AM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51964,'Oct 25 2006 10:50:00:000AM',770.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51965,'Oct 25 2006 10:55:00:000AM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51966,'Oct 25 2006 11:00:00:000AM',770.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51967,'Oct 25 2006 11:05:00:000AM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51968,'Oct 25 2006 11:10:00:000AM',770.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51969,'Oct 25 2006 11:15:00:000AM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51970,'Oct 25 2006 11:20:00:000AM',770.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51971,'Oct 25 2006 11:25:00:000AM',771.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51972,'Oct 25 2006 11:30:00:000AM',771.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51973,'Oct 25 2006 11:35:00:000AM',771.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51974,'Oct 25 2006 11:40:00:000AM',771.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51975,'Oct 25 2006 11:45:00:000AM',770.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51976,'Oct 25 2006 11:50:00:000AM',770.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51977,'Oct 25 2006 11:55:00:000AM',770.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51978,'Oct 25 2006 12:00:00:000PM',770.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51979,'Oct 25 2006 12:05:00:000PM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51980,'Oct 25 2006 12:10:00:000PM',770.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51981,'Oct 25 2006 12:15:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51982,'Oct 25 2006 12:20:00:000PM',768.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51983,'Oct 25 2006 12:25:00:000PM',768.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51984,'Oct 25 2006 12:30:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51985,'Oct 25 2006 12:35:00:000PM',766.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51986,'Oct 25 2006 12:40:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51987,'Oct 25 2006 12:45:00:000PM',766.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51988,'Oct 25 2006 12:50:00:000PM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51989,'Oct 25 2006 12:55:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51990,'Oct 25 2006 1:00:00:000PM',767.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51991,'Oct 25 2006 1:05:00:000PM',767.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51992,'Oct 25 2006 1:10:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51993,'Oct 25 2006 1:15:00:000PM',767.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51994,'Oct 25 2006 1:20:00:000PM',766.5000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51995,'Oct 25 2006 1:25:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51996,'Oct 25 2006 1:30:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51997,'Oct 25 2006 1:35:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51998,'Oct 25 2006 1:40:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(51999,'Oct 25 2006 1:45:00:000PM',767.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52000,'Oct 25 2006 1:50:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52001,'Oct 25 2006 1:55:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52002,'Oct 25 2006 2:00:00:000PM',768.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52003,'Oct 25 2006 2:05:00:000PM',767.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52004,'Oct 25 2006 2:10:00:000PM',767.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52005,'Oct 25 2006 2:15:00:000PM',770.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52006,'Oct 25 2006 2:20:00:000PM',768.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52007,'Oct 25 2006 2:25:00:000PM',765.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52008,'Oct 25 2006 2:30:00:000PM',764.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52009,'Oct 25 2006 2:35:00:000PM',764.9000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52010,'Oct 25 2006 2:40:00:000PM',766.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52011,'Oct 25 2006 2:45:00:000PM',766.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52012,'Oct 25 2006 2:50:00:000PM',765.6000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52013,'Oct 25 2006 2:55:00:000PM',768.3000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52014,'Oct 25 2006 3:00:00:000PM',769.0000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52015,'Oct 25 2006 3:05:00:000PM',768.7000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52016,'Oct 25 2006 3:10:00:000PM',770.1000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52017,'Oct 25 2006 3:15:00:000PM',770.2000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52018,'Oct 25 2006 3:20:00:000PM',770.4000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52019,'Oct 25 2006 3:25:00:000PM',768.8000)
INSERT INTO [prices] ([priceid],[dtbar],[price])VALUES(52020,'Oct 25 2006 3:30:00:000PM',769.6000)

SQL Server306  
 
 
Omnibuzz





PostPosted: Wed Nov 15 00:41:01 CST 2006 Top

SQL Server Developer >> Calculate an exponential moving average I am not really sure about the calculation part, but the general logic should
work, if I understood you correctly..

with
prices_cte as
(select *,row_number() over(order by priceid) as id from prices)
,ema_calc as
(select a.priceid,a.dtbar,a.price,cast(a.price as decimal(16,10)) as
[34EMA],id from prices_cte a where id = 1
union all
select a.priceid,a.dtbar,a.price,cast((a.Price - b.[34EMA])*0.05714 +
b.[34EMA] as decimal(16,10)),a.id from prices_cte a, ema_calc b
where a.id = b.id + 1
)
select priceid,dtbar,price, [34EMA] from ema_Calc option (maxrecursion 30000)

Hope this helps.
--
-Omnibuzz

http://omnibuzz-sql.blogspot.com/



 
 
Bob





PostPosted: Wed Nov 15 10:38:25 CST 2006 Top

SQL Server Developer >> Calculate an exponential moving average
> I am not really sure about the calculation part, but the general logic should
> work, if I understood you correctly..
>
> with
> prices_cte as
> (select *,row_number() over(order by priceid) as id from prices)
> ,ema_calc as
> (select a.priceid,a.dtbar,a.price,cast(a.price as decimal(16,10)) as
> [34EMA],id from prices_cte a where id = 1
> union all
> select a.priceid,a.dtbar,a.price,cast((a.Price - b.[34EMA])*0.05714 +
> b.[34EMA] as decimal(16,10)),a.id from prices_cte a, ema_calc b
> where a.id = b.id + 1
> )
> select priceid,dtbar,price, [34EMA] from ema_Calc option (maxrecursion 30000)
>
> Hope this helps.

Thanks, that worked perfectly. Took a while to run on a few hundred thousand rows.
 
 
Omnibuzz





PostPosted: Wed Nov 15 23:58:02 CST 2006 Top

SQL Server Developer >> Calculate an exponential moving average I guess you will be better off (performance wise) using a cursor to populate
into a table variable or temp table.

--
-Omnibuzz

http://omnibuzz-sql.blogspot.com/






> > I am not really sure about the calculation part, but the general logic should
> > work, if I understood you correctly..
> >
> > with
> > prices_cte as
> > (select *,row_number() over(order by priceid) as id from prices)
> > ,ema_calc as
> > (select a.priceid,a.dtbar,a.price,cast(a.price as decimal(16,10)) as
> > [34EMA],id from prices_cte a where id = 1
> > union all
> > select a.priceid,a.dtbar,a.price,cast((a.Price - b.[34EMA])*0.05714 +
> > b.[34EMA] as decimal(16,10)),a.id from prices_cte a, ema_calc b
> > where a.id = b.id + 1
> > )
> > select priceid,dtbar,price, [34EMA] from ema_Calc option (maxrecursion 30000)
> >
> > Hope this helps.
>
> Thanks, that worked perfectly. Took a while to run on a few hundred thousand rows.
>