INSERT INTO intraday_data VALUES('$DJUSAR',20070827140200,20070827,140200,120.05,120.05,120.05,120.05,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAR',20070827,122.46,122.46,119.99,120.05,0);
INSERT INTO intraday_data VALUES('$DJUSAT',20070827140200,20070827,140200,254.95,254.95,254.95,254.95,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAT',20070827,256.29,256.29,254.39,254.95,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827140200,20070827,140200,270.50,270.50,270.49,270.50,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBM',20070827,272.06,272.76,269.04,270.50,0);
INSERT INTO intraday_data VALUES('$DJUSCL',20070827140200,20070827,140200,258.40,258.40,258.40,258.40,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCL',20070827,265.08,265.08,257.04,258.40,0);
INSERT INTO intraday_data VALUES('$DJUSCP',20070827140200,20070827,140200,190.76,190.76,190.76,190.76,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCP',20070827,192.56,192.93,189.99,190.76,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827140200,20070827,140200,335.22,335.26,335.22,335.26,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCY',20070827,336.55,336.90,334.60,335.26,0);
INSERT INTO intraday_data VALUES('$DJUSEC',20070827140200,20070827,140200,155.19,155.19,155.19,155.19,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEC',20070827,156.20,156.21,154.89,155.19,0);
INSERT INTO intraday_data VALUES('$DJUSFB',20070827140200,20070827,140200,285.52,285.52,285.52,285.52,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFB',20070827,285.82,285.88,284.79,285.52,0);
INSERT INTO intraday_data VALUES('$DJUSFI',20070827140200,20070827,140200,656.11,656.11,656.11,656.11,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFI',20070827,664.66,664.66,655.51,656.11,0);
INSERT INTO intraday_data VALUES('$DJUSFS',20070827140200,20070827,140200,247.56,247.56,247.56,247.56,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFS',20070827,239.54,250.30,239.14,247.56,0);
INSERT INTO intraday_data VALUES('$DJUSGI',20070827140200,20070827,140200,434.93,434.93,434.93,434.93,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGI',20070827,438.50,438.50,434.49,434.93,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827140200,20070827,140200,343.03,343.05,343.02,343.03,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHC',20070827,343.94,344.09,342.97,343.03,0);
INSERT INTO intraday_data VALUES('$DJUSHP',20070827140200,20070827,140200,563.42,563.42,563.42,563.42,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHP',20070827,565.39,565.78,562.76,563.42,0);
INSERT INTO intraday_data VALUES('$DJUSHV',20070827140200,20070827,140200,541.48,541.48,541.48,541.48,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHV',20070827,524.94,544.42,523.34,541.48,0);
INSERT INTO intraday_data VALUES('$DJUSIF',20070827140200,20070827,140200,451.04,451.04,451.04,451.04,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIF',20070827,454.00,454.00,450.35,451.04,0);
INSERT INTO intraday_data VALUES('$DJUSIM',20070827140200,20070827,140200,412.47,412.47,412.47,412.47,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIM',20070827,415.30,418.66,409.61,412.47,0);
INSERT INTO intraday_data VALUES('$DJUSIQ',20070827140200,20070827,140200,887.65,887.65,887.65,887.65,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIQ',20070827,888.35,891.00,883.63,887.65,0);
INSERT INTO intraday_data VALUES('$DJUSIX',20070827140200,20070827,140200,412.60,412.60,412.60,412.60,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIX',20070827,415.71,415.71,412.45,412.60,0);
INSERT INTO intraday_data VALUES('$DJUSMC',20070827140200,20070827,140200,452.04,452.04,452.04,452.04,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMC',20070827,453.16,453.33,451.63,452.04,0);
INSERT INTO intraday_data VALUES('$DJUSMS',20070827140200,20070827,140200,383.08,383.08,383.08,383.08,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMS',20070827,382.69,384.11,382.69,383.08,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827140200,20070827,140200,308.69,308.69,308.67,308.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNC',20070827,309.88,310.14,308.09,308.68,0);
INSERT INTO intraday_data VALUES('$DJUSPB',20070827140200,20070827,140200,291.71,291.71,291.71,291.71,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPB',20070827,291.86,292.07,290.89,291.71,0);
INSERT INTO intraday_data VALUES('$DJUSPG',20070827140200,20070827,140200,264.54,264.54,264.54,264.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPG',20070827,268.57,268.57,264.53,264.54,0);
INSERT INTO intraday_data VALUES('$DJUSPP',20070827140200,20070827,140200,147.44,147.44,147.44,147.44,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPP',20070827,145.73,147.77,145.29,147.44,0);
INSERT INTO intraday_data VALUES('$DJUSPR',20070827140200,20070827,140200,276.63,276.63,276.63,276.63,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPR',20070827,277.75,277.75,276.46,276.63,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827140200,20070827,140200,282.90,282.91,282.89,282.91,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRE',20070827,287.10,287.12,282.47,282.91,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827140200,20070827,140200,405.19,405.19,405.19,405.19,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRH',20070827,410.12,410.12,403.97,405.19,0);
INSERT INTO intraday_data VALUES('$DJUSST',20070827140200,20070827,140200,364.54,364.54,364.54,364.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSST',20070827,354.68,370.62,354.68,364.54,0);
INSERT INTO intraday_data VALUES('$DJUSSV',20070827140200,20070827,140200,654.45,654.45,654.45,654.45,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSV',20070827,654.61,655.80,652.29,654.45,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827140200,20070827,140200,613.33,613.48,613.33,613.48,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,611.64,613.48,0);
INSERT INTO intraday_data VALUES('$DJUSTK',20070827140200,20070827,140200,331.20,331.20,331.20,331.20,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTK',20070827,331.69,332.09,329.14,331.20,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827140200,20070827,140200,187.30,187.30,187.24,187.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.96,186.26,187.24,0);
INSERT INTO intraday_data VALUES('$DJUSTQ',20070827140200,20070827,140200,594.36,594.36,594.36,594.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTQ',20070827,597.26,597.26,592.81,594.36,0);
INSERT INTO intraday_data VALUES('$DJUSUO',20070827140200,20070827,140200,143.80,143.80,143.80,143.80,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUO',20070827,147.47,147.47,143.64,143.80,0);
INSERT INTO intraday_data VALUES('$DJUSVN',20070827140200,20070827,140200,117.43,117.43,117.43,117.43,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSVN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSVN',20070827,117.91,118.58,117.27,117.43,0);
INSERT INTO intraday_data VALUES('$DJUSWC',20070827140200,20070827,140200,404.60,404.60,404.60,404.60,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWC',20070827,402.90,405.13,401.97,404.60,0);
INSERT INTO intraday_data VALUES('$INX',20070827140200,20070827,140200,1469.41,1469.53,1469.39,1469.53,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1469.53,0);
INSERT INTO intraday_data VALUES('$IUX',20070827140200,20070827,140200,789.49,789.67,789.49,789.67,0);
DELETE FROM eod_data WHERE `ticker` = "$IUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IUX',20070827,797.78,797.78,788.57,789.67,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827140200,20070827,140200,9538.01,9538.51,9537.54,9538.51,0);
DELETE FROM eod_data WHERE `ticker` = "$NYA.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$NYA.X',20070827,9607.04,9607.04,9522.78,9538.51,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827140200,20070827,140200,685.62,685.68,685.60,685.68,0);
DELETE FROM eod_data WHERE `ticker` = "$OEX.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$OEX.X',20070827,688.88,688.88,684.40,685.68,0);
INSERT INTO intraday_data VALUES('ADSK',20070827140200,20070827,140200,45.40,45.41,45.39,45.40,3500);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.60,44.75,45.40,820923);
INSERT INTO intraday_data VALUES('AMD',20070827140200,20070827,140200,12.06,12.06,12.04,12.05,19100);
DELETE FROM eod_data WHERE `ticker` = "AMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMD',20070827,12.08,12.25,11.96,12.05,9984975);
INSERT INTO intraday_data VALUES('AMX',20070827140200,20070827,140200,60.58,60.60,60.58,60.60,1700);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.76,60.06,60.60,1804000);
INSERT INTO intraday_data VALUES('AMZN',20070827140200,20070827,140200,79.44,79.53,79.43,79.53,11900);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.53,4441386);
INSERT INTO intraday_data VALUES('AOB',20070827140200,20070827,140200,9.40,9.41,9.40,9.40,4300);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.43,9.03,9.40,935200);
INSERT INTO intraday_data VALUES('APH',20070827140200,20070827,140200,35.01,35.02,35.01,35.02,800);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,35.02,407337);
INSERT INTO intraday_data VALUES('BBY',20070827140200,20070827,140200,43.74,43.81,43.74,43.81,30700);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.70,43.81,2247015);
INSERT INTO intraday_data VALUES('BCSI',20070827140200,20070827,140200,85.09,85.25,84.70,84.82,9622);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,84.82,1755165);
INSERT INTO intraday_data VALUES('BG',20070827140200,20070827,140200,88.56,88.60,88.56,88.60,700);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,88.70,87.03,88.60,282300);
INSERT INTO intraday_data VALUES('BNI',20070827140200,20070827,140200,80.36,80.40,80.34,80.40,3300);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,81.00,79.68,80.40,4606932);
INSERT INTO intraday_data VALUES('BPT',20070827140200,20070827,140200,70.83,70.83,70.83,70.83,900);
DELETE FROM eod_data WHERE `ticker` = "BPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BPT',20070827,71.05,71.20,70.53,70.83,52300);
INSERT INTO intraday_data VALUES('BTU',20070827140200,20070827,140200,41.39,41.41,41.38,41.41,10400);
DELETE FROM eod_data WHERE `ticker` = "BTU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BTU',20070827,42.44,42.56,41.19,41.41,2203292);
INSERT INTO intraday_data VALUES('CAM',20070827140200,20070827,140200,77.80,77.80,77.80,77.80,1100);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.80,583900);
INSERT INTO intraday_data VALUES('CBB',20070827140200,20070827,140200,4.95,4.95,4.95,4.95,100);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,5.00,4.91,4.95,519100);
INSERT INTO intraday_data VALUES('CCJ',20070827140200,20070827,140200,40.11,40.12,40.08,40.12,2200);
DELETE FROM eod_data WHERE `ticker` = "CCJ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CCJ',20070827,40.33,40.49,39.71,40.12,1557062);
INSERT INTO intraday_data VALUES('CEG',20070827140200,20070827,140200,83.61,83.75,83.61,83.75,3500);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.37,83.75,1051300);
INSERT INTO intraday_data VALUES('CFC',20070827140200,20070827,140200,19.97,20.00,19.97,20.00,38800);
DELETE FROM eod_data WHERE `ticker` = "CFC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CFC',20070827,20.32,20.33,19.53,20.00,31911391);
INSERT INTO intraday_data VALUES('CI',20070827140200,20070827,140200,49.91,49.91,49.87,49.87,4600);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.74,49.87,935392);
INSERT INTO intraday_data VALUES('CMC',20070827140200,20070827,140200,29.17,29.17,29.15,29.17,1200);
DELETE FROM eod_data WHERE `ticker` = "CMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMC',20070827,29.99,29.99,29.07,29.17,600300);
INSERT INTO intraday_data VALUES('CMI',20070827140200,20070827,140200,115.31,115.35,115.29,115.35,2400);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,114.97,115.35,599800);
INSERT INTO intraday_data VALUES('COG',20070827140200,20070827,140200,32.59,32.59,32.56,32.56,500);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.56,304100);
INSERT INTO intraday_data VALUES('CVH',20070827140200,20070827,140200,57.98,57.99,57.98,57.99,900);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,57.99,452500);
INSERT INTO intraday_data VALUES('CX',20070827140200,20070827,140200,31.30,31.31,31.30,31.30,7100);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.20,31.30,1437400);
INSERT INTO intraday_data VALUES('DECK',20070827140200,20070827,140200,94.01,94.12,93.96,94.02,1613);
DELETE FROM eod_data WHERE `ticker` = "DECK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DECK',20070827,96.35,96.48,93.83,94.02,147787);
INSERT INTO intraday_data VALUES('DIA',20070827140200,20070827,140200,133.39,133.42,133.37,133.42,20700);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.73,132.98,133.42,4900984);
INSERT INTO intraday_data VALUES('DNA',20070827140200,20070827,140200,73.11,73.12,73.10,73.12,700);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.05,73.12,812880);
INSERT INTO intraday_data VALUES('DVR',20070827140200,20070827,140200,14.53,14.53,14.53,14.53,100);
DELETE FROM eod_data WHERE `ticker` = "DVR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DVR',20070827,14.68,14.68,14.37,14.53,342300);
INSERT INTO intraday_data VALUES('ECA',20070827140200,20070827,140200,58.25,58.25,58.25,58.25,1800);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.25,905333);
INSERT INTO intraday_data VALUES('EGY',20070827140200,20070827,140200,3.71,3.72,3.71,3.72,1300);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.72,211100);
INSERT INTO intraday_data VALUES('ENR',20070827140200,20070827,140200,107.39,107.39,107.39,107.39,100);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,107.39,433200);
INSERT INTO intraday_data VALUES('EOG',20070827140200,20070827,140200,66.78,66.79,66.77,66.78,1800);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.78,1052650);
INSERT INTO intraday_data VALUES('EZPW',20070827140200,20070827,140200,12.50,12.50,12.50,12.50,100);
DELETE FROM eod_data WHERE `ticker` = "EZPW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EZPW',20070827,12.65,12.65,12.48,12.50,106190);
INSERT INTO intraday_data VALUES('FDG',20070827140200,20070827,140200,32.75,32.75,32.75,32.75,100);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.97,32.05,32.75,296175);
INSERT INTO intraday_data VALUES('FIZZ',20070827140200,20070827,140200,10.22,10.22,10.22,10.22,100);
DELETE FROM eod_data WHERE `ticker` = "FIZZ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FIZZ',20070827,10.29,10.35,10.18,10.22,23033);
INSERT INTO intraday_data VALUES('FLR',20070827140200,20070827,140200,125.02,125.30,125.00,125.23,11000);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.51,123.02,125.23,642775);
INSERT INTO intraday_data VALUES('FTI',20070827140200,20070827,140200,90.42,90.51,90.42,90.51,500);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,89.69,90.51,331800);
INSERT INTO intraday_data VALUES('GILD',20070827140200,20070827,140200,36.90,36.91,36.90,36.91,3280);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.75,36.91,2597717);
INSERT INTO intraday_data VALUES('GRA',20070827140200,20070827,140200,21.92,21.95,21.92,21.95,1900);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.76,21.95,256600);
INSERT INTO intraday_data VALUES('GS',20070827140200,20070827,140200,177.98,178.07,177.98,178.04,8000);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.45,178.04,4509942);
INSERT INTO intraday_data VALUES('GTI',20070827140200,20070827,140200,16.82,16.82,16.80,16.81,2000);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,16.81,1542300);
INSERT INTO intraday_data VALUES('HOC',20070827140200,20070827,140200,64.90,64.90,64.90,64.90,300);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,64.90,473875);
INSERT INTO intraday_data VALUES('HPC',20070827140200,20070827,140200,21.31,21.31,21.25,21.27,19400);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.25,21.27,869187);
INSERT INTO intraday_data VALUES('IBM',20070827140200,20070827,140200,113.38,113.41,113.38,113.40,8300);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.85,112.80,113.40,2574802);
INSERT INTO intraday_data VALUES('ICE',20070827140200,20070827,140200,140.82,140.82,140.82,140.82,300);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.69,140.82,585500);
INSERT INTO intraday_data VALUES('INFA',20070827140200,20070827,140200,13.72,13.72,13.72,13.72,100);
DELETE FROM eod_data WHERE `ticker` = "INFA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFA',20070827,13.83,13.85,13.69,13.72,371639);
INSERT INTO intraday_data VALUES('INFY',20070827140200,20070827,140200,46.20,46.24,46.20,46.21,3600);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.19,46.21,824397);
INSERT INTO intraday_data VALUES('ISE',20070827140200,20070827,140200,66.00,66.00,66.00,66.00,200);
DELETE FROM eod_data WHERE `ticker` = "ISE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ISE',20070827,66.11,66.19,65.96,66.00,159903);
INSERT INTO intraday_data VALUES('IVGN',20070827140200,20070827,140200,78.79,78.79,78.79,78.79,1100);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,79.22,77.95,78.79,219038);
INSERT INTO intraday_data VALUES('JCI',20070827140200,20070827,140200,111.82,111.92,111.78,111.92,2900);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.21,111.92,249285);
INSERT INTO intraday_data VALUES('JCP',20070827140200,20070827,140200,66.05,66.07,66.05,66.07,1800);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,66.07,1372000);
INSERT INTO intraday_data VALUES('JEC',20070827140200,20070827,140200,64.18,64.19,64.18,64.19,200);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.85,64.19,325100);
INSERT INTO intraday_data VALUES('JOYG',20070827140200,20070827,140200,48.09,48.15,48.06,48.15,1900);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.15,1004862);
INSERT INTO intraday_data VALUES('KEP',20070827140200,20070827,140200,22.08,22.08,22.07,22.08,400);
DELETE FROM eod_data WHERE `ticker` = "KEP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KEP',20070827,22.09,22.20,21.86,22.08,244300);
INSERT INTO intraday_data VALUES('KSS',20070827140200,20070827,140200,57.29,57.31,57.26,57.26,3700);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,57.23,57.26,3115400);
INSERT INTO intraday_data VALUES('LMT',20070827140200,20070827,140200,101.53,101.67,101.53,101.65,4600);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.95,99.12,101.65,1263390);
INSERT INTO intraday_data VALUES('LVS',20070827140200,20070827,140200,98.37,98.52,98.37,98.52,4600);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,98.52,1882025);
INSERT INTO intraday_data VALUES('MBT',20070827140200,20070827,140200,62.75,62.77,62.75,62.76,2500);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.77,61.43,62.76,388100);
INSERT INTO intraday_data VALUES('MGM',20070827140200,20070827,140200,82.15,82.18,82.14,82.18,3500);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.18,708300);
INSERT INTO intraday_data VALUES('MTW',20070827140200,20070827,140200,76.56,76.58,76.56,76.58,400);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.58,418800);
INSERT INTO intraday_data VALUES('MT',20070827140200,20070827,140200,63.88,63.91,63.87,63.91,14500);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.50,63.91,1216260);
INSERT INTO intraday_data VALUES('NEU',20070827140200,20070827,140200,47.55,47.55,47.55,47.55,200);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,46.84,47.55,103800);
INSERT INTO intraday_data VALUES('NFLX',20070827140200,20070827,140200,17.32,17.32,17.32,17.32,900);
DELETE FROM eod_data WHERE `ticker` = "NFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFLX',20070827,17.74,17.85,17.31,17.32,266667);
INSERT INTO intraday_data VALUES('NFX',20070827140200,20070827,140200,43.58,43.63,43.58,43.63,400);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.28,43.63,709928);
INSERT INTO intraday_data VALUES('NOV',20070827140200,20070827,140200,119.29,119.50,119.27,119.40,10100);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,119.40,1338421);
INSERT INTO intraday_data VALUES('NUE',20070827140200,20070827,140200,53.67,53.70,53.66,53.70,6400);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.42,53.70,3160566);
INSERT INTO intraday_data VALUES('NVDA',20070827140200,20070827,140200,49.38,49.43,49.38,49.42,17100);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.42,5983842);
INSERT INTO intraday_data VALUES('OII',20070827140200,20070827,140200,64.95,64.95,64.95,64.95,300);
DELETE FROM eod_data WHERE `ticker` = "OII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OII',20070827,65.35,65.45,64.01,64.95,180888);
INSERT INTO intraday_data VALUES('ORCL',20070827140200,20070827,140200,19.91,19.92,19.91,19.91,18100);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.91,11482552);
INSERT INTO intraday_data VALUES('OXY',20070827140200,20070827,140200,56.39,56.41,56.38,56.40,6700);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.40,1518500);
INSERT INTO intraday_data VALUES('PCLN',20070827140200,20070827,140200,80.98,80.98,80.92,80.94,800);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.41,80.94,326873);
INSERT INTO intraday_data VALUES('PCP',20070827140200,20070827,140200,138.49,138.49,138.29,138.30,1900);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.13,138.30,602400);
INSERT INTO intraday_data VALUES('PCR',20070827140200,20070827,140200,55.55,55.62,55.55,55.62,1000);
DELETE FROM eod_data WHERE `ticker` = "PCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCR',20070827,56.99,57.96,54.84,55.62,278300);
INSERT INTO intraday_data VALUES('PCU',20070827140200,20070827,140200,103.10,103.15,103.09,103.15,2700);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,103.15,1268573);
INSERT INTO intraday_data VALUES('PETS',20070827140200,20070827,140200,15.33,15.33,15.33,15.33,200);
DELETE FROM eod_data WHERE `ticker` = "PETS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PETS',20070827,15.60,15.67,15.31,15.33,125428);
INSERT INTO intraday_data VALUES('PTNR',20070827140200,20070827,140200,15.41,15.41,15.41,15.41,200);
DELETE FROM eod_data WHERE `ticker` = "PTNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PTNR',20070827,15.30,15.45,15.25,15.41,156048);
INSERT INTO intraday_data VALUES('QQQQ',20070827140200,20070827,140200,48.01,48.03,48.01,48.02,73596);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,48.02,44139850);
INSERT INTO intraday_data VALUES('RAI',20070827140200,20070827,140200,65.21,65.25,65.21,65.25,500);
DELETE FROM eod_data WHERE `ticker` = "RAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RAI',20070827,65.60,65.99,65.10,65.25,491663);
INSERT INTO intraday_data VALUES('RIMM',20070827140200,20070827,140200,81.07,81.13,81.07,81.13,4684);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,81.13,4214831);
INSERT INTO intraday_data VALUES('RIO',20070827140200,20070827,140200,47.81,47.84,47.77,47.83,11100);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.97,47.09,47.83,7037583);
INSERT INTO intraday_data VALUES('RL',20070827140200,20070827,140200,76.57,76.59,76.55,76.59,2300);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.52,76.59,623100);
INSERT INTO intraday_data VALUES('RMD',20070827140200,20070827,140200,41.45,41.46,41.32,41.38,28900);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.32,41.38,297005);
INSERT INTO intraday_data VALUES('SCI',20070827140200,20070827,140200,12.08,12.08,12.06,12.06,3700);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,11.96,12.06,710600);
INSERT INTO intraday_data VALUES('SCUR',20070827140200,20070827,140200,8.35,8.35,8.35,8.35,300);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.23,8.35,342071);
INSERT INTO intraday_data VALUES('SID',20070827140200,20070827,140200,53.81,53.81,53.75,53.78,2100);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.67,53.78,684400);
INSERT INTO intraday_data VALUES('SIMG',20070827140200,20070827,140200,5.85,5.85,5.85,5.85,300);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.85,449498);
INSERT INTO intraday_data VALUES('SKX',20070827140200,20070827,140200,19.91,19.93,19.90,19.93,2900);
DELETE FROM eod_data WHERE `ticker` = "SKX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SKX',20070827,20.10,20.10,19.81,19.93,237400);
INSERT INTO intraday_data VALUES('SNDK',20070827140200,20070827,140200,52.11,52.14,52.09,52.13,17650);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.05,52.13,5416928);
INSERT INTO intraday_data VALUES('SPF',20070827140200,20070827,140200,9.97,9.97,9.97,9.97,500);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.97,1335500);
INSERT INTO intraday_data VALUES('SPIL',20070827140200,20070827,140200,10.12,10.12,10.11,10.11,1635);
DELETE FROM eod_data WHERE `ticker` = "SPIL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPIL',20070827,10.26,10.26,10.00,10.11,559318);
INSERT INTO intraday_data VALUES('SPWR',20070827140200,20070827,140200,62.24,62.24,62.24,62.24,100);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.05,62.24,567476);
INSERT INTO intraday_data VALUES('SPY',20070827140200,20070827,140200,147.20,147.25,147.19,147.25,126000);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,146.97,147.25,60985560);
INSERT INTO intraday_data VALUES('STLD',20070827140200,20070827,140200,43.51,43.56,43.50,43.56,8184);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.56,729549);
INSERT INTO intraday_data VALUES('SWKS',20070827140200,20070827,140200,7.70,7.70,7.70,7.70,400);
DELETE FROM eod_data WHERE `ticker` = "SWKS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWKS',20070827,7.88,7.95,7.67,7.70,1054045);
INSERT INTO intraday_data VALUES('TRAD',20070827140200,20070827,140200,10.89,10.89,10.88,10.88,600);
DELETE FROM eod_data WHERE `ticker` = "TRAD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRAD',20070827,10.88,10.92,10.70,10.88,161951);
INSERT INTO intraday_data VALUES('TSO',20070827140200,20070827,140200,49.31,49.33,49.31,49.33,1200);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.33,1590100);
INSERT INTO intraday_data VALUES('UNH',20070827140200,20070827,140200,49.39,49.40,49.39,49.39,2900);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.23,49.39,2579180);
INSERT INTO intraday_data VALUES('UPL',20070827140200,20070827,140200,54.37,54.41,54.37,54.40,1800);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.40,483800);
INSERT INTO intraday_data VALUES('USG',20070827140200,20070827,140200,37.69,37.69,37.69,37.69,1500);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.65,37.69,366000);
INSERT INTO intraday_data VALUES('VIP',20070827140200,20070827,140200,22.72,22.73,22.70,22.71,11900);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.08,22.71,1094330);
INSERT INTO intraday_data VALUES('VLO',20070827140200,20070827,140200,67.53,67.55,67.50,67.55,13600);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.55,3232494);
INSERT INTO intraday_data VALUES('VSEA',20070827140200,20070827,140200,56.37,56.51,56.31,56.51,54007);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,57.41,54.53,56.51,1864431);
INSERT INTO intraday_data VALUES('WBSN',20070827140200,20070827,140200,20.50,20.52,20.50,20.52,3015);
DELETE FROM eod_data WHERE `ticker` = "WBSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WBSN',20070827,20.73,20.91,20.44,20.52,87224);
INSERT INTO intraday_data VALUES('WCC',20070827140200,20070827,140200,47.80,47.80,47.80,47.80,300);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,47.75,47.80,244094);
INSERT INTO intraday_data VALUES('WDC',20070827140200,20070827,140200,21.82,21.84,21.82,21.84,1400);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.77,21.84,1251700);
INSERT INTO intraday_data VALUES('WFR',20070827140200,20070827,140200,58.22,58.32,58.21,58.30,5300);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.21,58.30,781100);
INSERT INTO intraday_data VALUES('WHQ',20070827140200,20070827,140200,61.61,61.64,61.61,61.64,400);
DELETE FROM eod_data WHERE `ticker` = "WHQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WHQ',20070827,61.80,62.05,60.52,61.64,127600);
INSERT INTO intraday_data VALUES('WSO',20070827140200,20070827,140200,47.95,47.99,47.95,47.99,1000);
DELETE FROM eod_data WHERE `ticker` = "WSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WSO',20070827,48.88,49.10,47.86,47.99,77000);
INSERT INTO intraday_data VALUES('$COMPX',20070827140200,20070827,140200,2564.28,2564.65,2564.28,2564.65,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2564.65,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827140200,20070827,140200,595.16,595.27,595.13,595.27,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.62,595.27,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827140200,20070827,140200,546.18,546.24,546.13,546.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFN',20070827,552.10,552.10,545.68,546.24,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827140200,20070827,140200,350.70,350.71,350.68,350.71,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIN',20070827,352.45,352.45,349.76,350.71,0);
INSERT INTO intraday_data VALUES('$DJUSMU',20070827140200,20070827,140200,120.58,120.58,120.58,120.58,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMU',20070827,123.48,123.48,120.42,120.58,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827140200,20070827,140200,115.59,115.59,115.59,115.59,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRI',20070827,117.28,117.34,115.40,115.59,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827140200,20070827,140200,1333.20,1333.45,1333.07,1333.45,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1327.39,1333.45,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827140200,20070827,140200,185.78,185.84,185.78,185.84,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUT',20070827,191.11,191.11,185.49,185.84,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827140200,20070827,140200,137.06,137.06,137.04,137.06,0);
DELETE FROM eod_data WHERE `ticker` = "$GOX.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$GOX.X',20070827,139.46,139.48,136.56,137.06,0);
INSERT INTO intraday_data VALUES('$IDX',20070827140200,20070827,140200,855.65,855.81,855.65,855.81,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,855.81,0);
INSERT INTO intraday_data VALUES('$INDU',20070827140200,20070827,140200,13346.27,13346.84,13344.24,13346.84,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13378.63,13305.87,13346.84,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827140200,20070827,140200,730.84,730.88,730.73,730.80,0);
DELETE FROM eod_data WHERE `ticker` = "$OIX.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$OIX.X',20070827,736.99,736.99,727.80,730.80,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827140200,20070827,140200,416.01,416.09,416.01,416.09,0);
DELETE FROM eod_data WHERE `ticker` = "$SML.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$SML.X',20070827,420.06,420.06,415.19,416.09,0);
INSERT INTO intraday_data VALUES('$VIX',20070827140200,20070827,140200,22.43,22.43,22.40,22.40,0);
DELETE FROM eod_data WHERE `ticker` = "$VIX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$VIX',20070827,0.00,0.00,0.00,0.00,0);
INSERT INTO intraday_data VALUES('AAI',20070827140200,20070827,140200,10.30,10.30,10.29,10.30,12800);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.13,10.30,1110206);
INSERT INTO intraday_data VALUES('AAPL',20070827140200,20070827,140200,133.16,133.22,133.16,133.21,14119);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.21,17251547);
INSERT INTO intraday_data VALUES('ACLI',20070827140200,20070827,140200,24.00,24.00,24.00,24.00,300);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,24.00,358072);
INSERT INTO intraday_data VALUES('ACL',20070827140200,20070827,140200,133.49,133.53,133.48,133.53,800);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.53,240600);
INSERT INTO intraday_data VALUES('ADM',20070827140200,20070827,140200,32.95,32.95,32.94,32.94,2900);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.69,32.94,2101415);
INSERT INTO intraday_data VALUES('ADS',20070827140200,20070827,140200,76.63,76.68,76.63,76.63,1300);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.43,76.63,392200);
INSERT INTO intraday_data VALUES('AET',20070827140200,20070827,140200,50.10,50.10,50.08,50.09,4900);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.23,49.68,50.09,1848400);
INSERT INTO intraday_data VALUES('ALB',20070827140200,20070827,140200,38.55,38.55,38.55,38.55,200);
DELETE FROM eod_data WHERE `ticker` = "ALB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ALB',20070827,38.51,38.66,37.97,38.55,342100);
INSERT INTO intraday_data VALUES('AMTD',20070827140200,20070827,140200,17.70,17.70,17.70,17.70,1700);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.78,17.40,17.70,1457932);
INSERT INTO intraday_data VALUES('ANF',20070827140200,20070827,140200,79.54,79.56,79.54,79.56,1700);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,79.56,1075600);
INSERT INTO intraday_data VALUES('APA',20070827140200,20070827,140200,75.20,75.23,75.20,75.21,2300);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.12,75.21,1422100);
INSERT INTO intraday_data VALUES('AZN',20070827140200,20070827,140200,48.32,48.34,48.32,48.34,1400);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.15,48.34,384400);
INSERT INTO intraday_data VALUES('BA',20070827140200,20070827,140200,98.53,98.53,98.45,98.49,13600);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.67,97.13,98.49,1887505);
INSERT INTO intraday_data VALUES('BEN',20070827140200,20070827,140200,132.77,132.77,132.70,132.77,600);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,132.51,132.77,439116);
INSERT INTO intraday_data VALUES('BHI',20070827140200,20070827,140200,80.74,80.75,80.72,80.74,800);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,79.96,80.74,1359205);
INSERT INTO intraday_data VALUES('BHP',20070827140200,20070827,140200,62.10,62.11,62.09,62.09,1000);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,62.09,817590);
INSERT INTO intraday_data VALUES('BIDU',20070827140200,20070827,140200,211.06,211.19,210.93,211.19,1330);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,212.38,200.55,211.19,3339097);
INSERT INTO intraday_data VALUES('BRCD',20070827140200,20070827,140200,6.99,6.99,6.98,6.99,6960);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,6.98,6.99,5887889);
INSERT INTO intraday_data VALUES('BRY',20070827140200,20070827,140200,33.37,33.38,33.37,33.38,300);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.30,33.38,97100);
INSERT INTO intraday_data VALUES('BR',20070827140200,20070827,140200,17.76,17.77,17.75,17.77,600);
DELETE FROM eod_data WHERE `ticker` = "BR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BR',20070827,17.77,17.90,17.63,17.77,324260);
INSERT INTO intraday_data VALUES('BZH',20070827140200,20070827,140200,9.69,9.70,9.69,9.70,600);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.70,1469800);
INSERT INTO intraday_data VALUES('CELG',20070827140200,20070827,140200,59.48,59.49,59.47,59.47,1410);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.84,59.26,59.47,1328127);
INSERT INTO intraday_data VALUES('CEPH',20070827140200,20070827,140200,73.19,73.20,73.19,73.20,800);
DELETE FROM eod_data WHERE `ticker` = "CEPH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEPH',20070827,73.75,74.17,73.05,73.20,394422);
INSERT INTO intraday_data VALUES('CHINA',20070827140200,20070827,140200,8.43,8.43,8.42,8.42,700);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.50,8.20,8.42,742547);
INSERT INTO intraday_data VALUES('CHRW',20070827140200,20070827,140200,49.25,49.25,49.24,49.25,600);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.25,281400);
INSERT INTO intraday_data VALUES('CME',20070827140200,20070827,140200,559.00,559.00,559.00,559.00,600);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.87,556.00,559.00,358614);
INSERT INTO intraday_data VALUES('COGO',20070827140200,20070827,140200,17.31,17.31,17.28,17.29,1200);
DELETE FROM eod_data WHERE `ticker` = "COGO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COGO',20070827,17.16,17.64,17.16,17.29,232273);
INSERT INTO intraday_data VALUES('COH',20070827140200,20070827,140200,43.34,43.37,43.34,43.34,11700);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.00,43.34,2870852);
INSERT INTO intraday_data VALUES('COP',20070827140200,20070827,140200,80.87,80.88,80.86,80.86,20300);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,81.06,80.02,80.86,3773200);
INSERT INTO intraday_data VALUES('CRDN',20070827140200,20070827,140200,69.97,70.02,69.97,70.02,400);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.66,70.02,310007);
INSERT INTO intraday_data VALUES('CRI',20070827140200,20070827,140200,20.07,20.09,20.07,20.09,2300);
DELETE FROM eod_data WHERE `ticker` = "CRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRI',20070827,20.56,20.56,19.91,20.09,506200);
INSERT INTO intraday_data VALUES('CROX',20070827140200,20070827,140200,60.05,60.08,60.00,60.01,10450);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,60.01,5557223);
INSERT INTO intraday_data VALUES('CRS',20070827140200,20070827,140200,115.72,115.79,115.72,115.79,500);
DELETE FROM eod_data WHERE `ticker` = "CRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRS',20070827,114.59,117.20,114.34,115.79,201500);
INSERT INTO intraday_data VALUES('CSCO',20070827140200,20070827,140200,30.88,30.91,30.88,30.91,27024);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.91,26271157);
INSERT INTO intraday_data VALUES('CTRP',20070827140200,20070827,140200,43.56,43.56,43.54,43.56,500);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.56,650248);
INSERT INTO intraday_data VALUES('CTSH',20070827140200,20070827,140200,73.04,73.12,73.04,73.12,1900);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,73.12,1230039);
INSERT INTO intraday_data VALUES('CTX',20070827140200,20070827,140200,30.42,30.48,30.42,30.48,11000);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.28,30.48,2015734);
INSERT INTO intraday_data VALUES('CXW',20070827140200,20070827,140200,25.39,25.42,25.38,25.42,900);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.25,25.42,831200);
INSERT INTO intraday_data VALUES('DAVE',20070827140200,20070827,140200,19.75,19.82,19.75,19.82,500);
DELETE FROM eod_data WHERE `ticker` = "DAVE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DAVE',20070827,19.20,19.88,19.14,19.82,40952);
INSERT INTO intraday_data VALUES('DRIV',20070827140200,20070827,140200,44.56,44.57,44.54,44.57,400);
DELETE FROM eod_data WHERE `ticker` = "DRIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRIV',20070827,44.64,44.99,44.45,44.57,132581);
INSERT INTO intraday_data VALUES('DRQ',20070827140200,20070827,140200,44.75,44.75,44.75,44.75,100);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.58,44.75,137800);
INSERT INTO intraday_data VALUES('DRYS',20070827140200,20070827,140200,66.95,67.08,66.95,66.95,3534);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.74,63.16,66.95,1692812);
INSERT INTO intraday_data VALUES('EBAY',20070827140200,20070827,140200,33.69,33.69,33.68,33.69,4127);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.69,4993428);
INSERT INTO intraday_data VALUES('ESRX',20070827140200,20070827,140200,54.84,54.85,54.83,54.83,3300);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.83,622330);
INSERT INTO intraday_data VALUES('ESV',20070827140200,20070827,140200,57.05,57.07,57.05,57.07,600);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.54,57.07,844400);
INSERT INTO intraday_data VALUES('EXPD',20070827140200,20070827,140200,45.36,45.36,45.36,45.36,200);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.72,45.01,45.36,413330);
INSERT INTO intraday_data VALUES('EXP',20070827140200,20070827,140200,38.05,38.06,38.04,38.06,400);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.03,38.06,366800);
INSERT INTO intraday_data VALUES('FFIV',20070827140200,20070827,140200,37.01,37.01,37.00,37.01,900);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,37.01,627340);
INSERT INTO intraday_data VALUES('FMD',20070827140200,20070827,140200,35.18,35.21,35.18,35.21,1200);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.58,35.02,35.21,318100);
INSERT INTO intraday_data VALUES('FRK',20070827140200,20070827,140200,62.52,62.52,62.52,62.52,100);
DELETE FROM eod_data WHERE `ticker` = "FRK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRK',20070827,62.83,62.99,62.00,62.52,95200);
INSERT INTO intraday_data VALUES('FRX',20070827140200,20070827,140200,37.17,37.17,37.15,37.15,3800);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.15,1528400);
INSERT INTO intraday_data VALUES('GES',20070827140200,20070827,140200,49.87,49.88,49.83,49.88,800);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.27,49.88,439119);
INSERT INTO intraday_data VALUES('GGB',20070827140200,20070827,140200,22.99,22.99,22.98,22.98,300);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,22.98,888000);
INSERT INTO intraday_data VALUES('GNA',20070827140200,20070827,140200,11.81,11.83,11.81,11.83,2500);
DELETE FROM eod_data WHERE `ticker` = "GNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GNA',20070827,12.07,12.29,11.76,11.83,337000);
INSERT INTO intraday_data VALUES('GOOG',20070827140200,20070827,140200,515.42,515.72,515.31,515.72,3734);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,515.72,1659496);
INSERT INTO intraday_data VALUES('GRMN',20070827140200,20070827,140200,102.30,102.30,102.24,102.30,1798);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,102.30,1619067);
INSERT INTO intraday_data VALUES('HAL',20070827140200,20070827,140200,33.44,33.44,33.42,33.44,663000);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.23,33.44,7342183);
INSERT INTO intraday_data VALUES('HNR',20070827140200,20070827,140200,11.09,11.09,11.09,11.09,100);
DELETE FROM eod_data WHERE `ticker` = "HNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HNR',20070827,11.19,11.25,11.00,11.09,111000);
INSERT INTO intraday_data VALUES('HOG',20070827140200,20070827,140200,54.02,54.03,53.99,53.99,4600);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,53.99,1098063);
INSERT INTO intraday_data VALUES('HOV',20070827140200,20070827,140200,11.36,11.38,11.36,11.38,2000);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.30,11.38,1242144);
INSERT INTO intraday_data VALUES('HXM',20070827140200,20070827,140200,53.60,53.61,53.60,53.61,900);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.61,170500);
INSERT INTO intraday_data VALUES('IAG',20070827140200,20070827,140200,7.07,7.07,7.06,7.06,600);
DELETE FROM eod_data WHERE `ticker` = "IAG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IAG',20070827,7.18,7.18,7.01,7.06,605250);
INSERT INTO intraday_data VALUES('JWN',20070827140200,20070827,140200,48.05,48.05,48.04,48.04,1900);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,47.94,48.04,2073100);
INSERT INTO intraday_data VALUES('KBH',20070827140200,20070827,140200,30.52,30.53,30.51,30.52,1600);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.41,30.52,1604500);
INSERT INTO intraday_data VALUES('KCI',20070827140200,20070827,140200,61.92,61.94,61.92,61.94,900);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,61.50,61.94,417500);
INSERT INTO intraday_data VALUES('KG',20070827140200,20070827,140200,15.71,15.76,15.70,15.76,20000);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.78,15.52,15.76,804885);
INSERT INTO intraday_data VALUES('LEH',20070827140200,20070827,140200,58.20,58.21,58.17,58.21,8500);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.06,58.21,4989979);
INSERT INTO intraday_data VALUES('LRCX',20070827140200,20070827,140200,53.51,53.55,53.51,53.55,3052);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.87,53.55,1291869);
INSERT INTO intraday_data VALUES('MCD',20070827140200,20070827,140200,49.45,49.47,49.45,49.47,10200);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.40,49.47,2698812);
INSERT INTO intraday_data VALUES('MDC',20070827140200,20070827,140200,43.84,43.90,43.84,43.90,600);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,43.71,43.90,388600);
INSERT INTO intraday_data VALUES('MESA',20070827140200,20070827,140200,6.00,6.00,6.00,6.00,300);
DELETE FROM eod_data WHERE `ticker` = "MESA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MESA',20070827,5.86,6.06,5.81,6.00,167086);
INSERT INTO intraday_data VALUES('MICC',20070827140200,20070827,140200,82.85,82.85,82.79,82.79,600);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.31,82.79,228229);
INSERT INTO intraday_data VALUES('MLM',20070827140200,20070827,140200,131.53,131.59,131.53,131.55,1000);
DELETE FROM eod_data WHERE `ticker` = "MLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MLM',20070827,134.34,135.00,131.11,131.55,253900);
INSERT INTO intraday_data VALUES('MNT',20070827140200,20070827,140200,43.80,43.81,43.79,43.81,500);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.26,43.63,43.81,334559);
INSERT INTO intraday_data VALUES('MOS',20070827140200,20070827,140200,40.52,40.52,40.52,40.52,200);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.52,1131400);
INSERT INTO intraday_data VALUES('MRVL',20070827140200,20070827,140200,15.55,15.55,15.53,15.54,81910);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.54,13530712);
INSERT INTO intraday_data VALUES('MSFT',20070827140200,20070827,140200,28.57,28.58,28.56,28.57,71932);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.40,28.57,15771643);
INSERT INTO intraday_data VALUES('MSTR',20070827140200,20070827,140200,73.35,73.35,73.35,73.35,100);
DELETE FROM eod_data WHERE `ticker` = "MSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSTR',20070827,75.96,76.50,73.22,73.35,155721);
INSERT INTO intraday_data VALUES('MTH',20070827140200,20070827,140200,17.51,17.51,17.50,17.50,1200);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,17.50,17.50,481591);
INSERT INTO intraday_data VALUES('NEM',20070827140200,20070827,140200,40.38,40.39,40.35,40.35,13000);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.30,40.35,2733200);
INSERT INTO intraday_data VALUES('NILE',20070827140200,20070827,140200,85.77,85.77,85.77,85.77,300);
DELETE FROM eod_data WHERE `ticker` = "NILE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NILE',20070827,86.59,87.20,84.92,85.77,138406);
INSERT INTO intraday_data VALUES('NSTC',20070827140200,20070827,140200,10.86,10.86,10.86,10.86,200);
DELETE FROM eod_data WHERE `ticker` = "NSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NSTC',20070827,10.99,11.11,10.86,10.86,63284);
INSERT INTO intraday_data VALUES('NTES',20070827140200,20070827,140200,16.14,16.14,16.14,16.14,1200);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.12,16.14,575045);
INSERT INTO intraday_data VALUES('NYX',20070827140200,20070827,140200,73.80,73.90,73.80,73.89,5300);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.59,73.89,1124731);
INSERT INTO intraday_data VALUES('OCR',20070827140200,20070827,140200,32.95,32.97,32.95,32.97,1000);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.02,32.66,32.97,553300);
INSERT INTO intraday_data VALUES('OGE',20070827140200,20070827,140200,33.06,33.06,33.04,33.04,400);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.87,33.04,235400);
INSERT INTO intraday_data VALUES('PBR',20070827140200,20070827,140200,59.03,59.03,58.99,58.99,3500);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.43,58.47,58.99,1880859);
INSERT INTO intraday_data VALUES('PMTI',20070827140200,20070827,140200,30.47,30.47,30.47,30.47,100);
DELETE FROM eod_data WHERE `ticker` = "PMTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PMTI',20070827,30.67,30.72,30.25,30.47,89705);
INSERT INTO intraday_data VALUES('PNK',20070827140200,20070827,140200,27.20,27.20,27.20,27.20,500);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.35,26.85,27.20,160600);
INSERT INTO intraday_data VALUES('POT',20070827140200,20070827,140200,85.30,85.30,85.28,85.28,2000);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.25,85.28,1097350);
INSERT INTO intraday_data VALUES('PRFT',20070827140200,20070827,140200,23.31,23.31,23.31,23.31,100);
DELETE FROM eod_data WHERE `ticker` = "PRFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRFT',20070827,23.04,23.45,22.95,23.31,148224);
INSERT INTO intraday_data VALUES('PRST',20070827140200,20070827,140200,6.46,6.46,6.46,6.46,100);
DELETE FROM eod_data WHERE `ticker` = "PRST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRST',20070827,6.52,6.66,6.45,6.46,72964);
INSERT INTO intraday_data VALUES('RIG',20070827140200,20070827,140200,102.42,102.43,102.40,102.43,900);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.54,102.43,2433633);
INSERT INTO intraday_data VALUES('RTP',20070827140200,20070827,140200,272.31,272.31,272.31,272.31,300);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,272.31,181300);
INSERT INTO intraday_data VALUES('RYL',20070827140200,20070827,140200,30.02,30.02,30.01,30.02,1800);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.01,30.02,889781);
INSERT INTO intraday_data VALUES('SBGI',20070827140200,20070827,140200,12.37,12.37,12.36,12.37,559);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.36,12.37,562040);
INSERT INTO intraday_data VALUES('SBUX',20070827140200,20070827,140200,27.44,27.45,27.44,27.45,1061);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.45,2575820);
INSERT INTO intraday_data VALUES('SEIC',20070827140200,20070827,140200,25.74,25.75,25.74,25.75,1315);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.75,214605);
INSERT INTO intraday_data VALUES('SII',20070827140200,20070827,140200,62.63,62.64,62.63,62.63,400);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.02,62.63,801000);
INSERT INTO intraday_data VALUES('SLB',20070827140200,20070827,140200,92.87,92.91,92.86,92.90,3000);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.03,92.90,2715900);
INSERT INTO intraday_data VALUES('SNE',20070827140200,20070827,140200,46.34,46.34,46.34,46.34,600);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.34,384140);
INSERT INTO intraday_data VALUES('SPG',20070827140200,20070827,140200,92.32,92.34,92.32,92.34,500);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,92.34,490400);
INSERT INTO intraday_data VALUES('SPN',20070827140200,20070827,140200,38.14,38.14,38.12,38.12,1600);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.01,38.12,288200);
INSERT INTO intraday_data VALUES('STR',20070827140200,20070827,140200,49.37,49.41,49.37,49.38,2600);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.29,49.38,620700);
INSERT INTO intraday_data VALUES('SWN',20070827140200,20070827,140200,37.49,37.49,37.48,37.48,1600);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.48,1039400);
INSERT INTO intraday_data VALUES('SYK',20070827140200,20070827,140200,67.13,67.15,67.13,67.15,400);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.09,67.15,399032);
INSERT INTO intraday_data VALUES('TDW',20070827140200,20070827,140200,65.13,65.13,65.12,65.13,700);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.27,64.45,65.13,573715);
INSERT INTO intraday_data VALUES('TEX',20070827140200,20070827,140200,78.36,78.36,78.27,78.27,1100);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,77.82,78.27,674700);
INSERT INTO intraday_data VALUES('THOR',20070827140200,20070827,140200,20.78,20.78,20.78,20.78,100);
DELETE FROM eod_data WHERE `ticker` = "THOR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('THOR',20070827,20.87,20.94,20.61,20.78,171307);
INSERT INTO intraday_data VALUES('TLM',20070827140200,20070827,140200,17.01,17.01,17.01,17.01,200);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.95,17.01,1220582);
INSERT INTO intraday_data VALUES('TNB',20070827140200,20070827,140200,55.41,55.41,55.41,55.41,300);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.41,298000);
INSERT INTO intraday_data VALUES('TOL',20070827140200,20070827,140200,22.03,22.06,22.03,22.05,13900);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.01,22.05,2885066);
INSERT INTO intraday_data VALUES('TRMB',20070827140200,20070827,140200,36.51,36.51,36.50,36.50,300);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.50,388871);
INSERT INTO intraday_data VALUES('TSN',20070827140200,20070827,140200,21.25,21.25,21.24,21.25,1700);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.21,21.25,816005);
INSERT INTO intraday_data VALUES('TS',20070827140200,20070827,140200,46.71,46.72,46.71,46.72,1100);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.72,1603000);
INSERT INTO intraday_data VALUES('TXU',20070827140200,20070827,140200,65.99,66.05,65.99,66.05,16500);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.73,66.05,3846200);
INSERT INTO intraday_data VALUES('UA',20070827140200,20070827,140200,63.80,63.87,63.80,63.82,1300);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,63.82,536800);
INSERT INTO intraday_data VALUES('UFPI',20070827140200,20070827,140200,38.18,38.19,38.18,38.19,300);
DELETE FROM eod_data WHERE `ticker` = "UFPI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UFPI',20070827,38.17,38.87,37.74,38.19,49878);
INSERT INTO intraday_data VALUES('URBN',20070827140200,20070827,140200,22.66,22.66,22.66,22.66,200);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.66,1383288);
INSERT INTO intraday_data VALUES('WFMI',20070827140200,20070827,140200,45.75,45.76,45.73,45.75,2800);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.75,2109225);
INSERT INTO intraday_data VALUES('WFT',20070827140200,20070827,140200,56.27,56.29,56.26,56.29,1000);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.45,56.29,1535900);
INSERT INTO intraday_data VALUES('WLP',20070827140200,20070827,140200,78.47,78.47,78.43,78.43,1200);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.63,77.89,78.43,1369800);
INSERT INTO intraday_data VALUES('WNR',20070827140200,20070827,140200,52.01,52.10,52.01,52.04,1800);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,52.04,506600);
INSERT INTO intraday_data VALUES('X',20070827140200,20070827,140200,93.19,93.27,93.16,93.25,4900);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,93.25,2078304);
INSERT INTO intraday_data VALUES('YHOO',20070827140200,20070827,140200,23.17,23.18,23.17,23.18,77400);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.17,23.18,9180211);