INSERT INTO intraday_data VALUES('$DJUSAF',20070827115900,20070827,115900,638.65,638.65,638.65,638.65,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAF',20070827,638.59,643.96,637.94,638.65,0);
INSERT INTO intraday_data VALUES('$DJUSAG',20070827115900,20070827,115900,151.14,151.14,151.14,151.14,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAG',20070827,151.64,151.64,150.59,151.14,0);
INSERT INTO intraday_data VALUES('$DJUSAM',20070827115900,20070827,115900,533.68,533.68,533.68,533.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAM',20070827,535.81,536.28,533.15,533.68,0);
INSERT INTO intraday_data VALUES('$DJUSAV',20070827115900,20070827,115900,427.17,427.17,427.17,427.17,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAV',20070827,429.23,429.23,426.44,427.17,0);
INSERT INTO intraday_data VALUES('$DJUSBK',20070827115900,20070827,115900,526.32,526.32,526.32,526.32,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBK',20070827,528.26,530.46,523.64,526.32,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827115900,20070827,115900,270.42,270.43,270.42,270.43,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.43,0);
INSERT INTO intraday_data VALUES('$DJUSCF',20070827115900,20070827,115900,176.15,176.15,176.15,176.15,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCF',20070827,177.95,180.61,176.04,176.15,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827115900,20070827,115900,334.94,334.96,334.94,334.96,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCY',20070827,336.55,336.90,334.60,334.96,0);
INSERT INTO intraday_data VALUES('$DJUSEU',20070827115900,20070827,115900,197.96,197.96,197.96,197.96,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEU',20070827,200.33,203.14,197.61,197.96,0);
INSERT INTO intraday_data VALUES('$DJUSFC',20070827115900,20070827,115900,179.54,179.54,179.54,179.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFC',20070827,177.25,180.14,177.25,179.54,0);
INSERT INTO intraday_data VALUES('$DJUSFI',20070827115900,20070827,115900,658.68,658.68,658.68,658.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFI',20070827,664.66,664.66,656.78,658.68,0);
INSERT INTO intraday_data VALUES('$DJUSFP',20070827115900,20070827,115900,253.20,253.20,253.20,253.20,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFP',20070827,253.79,253.87,252.59,253.20,0);
INSERT INTO intraday_data VALUES('$DJUSHN',20070827115900,20070827,115900,493.36,493.36,493.36,493.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHN',20070827,498.78,498.78,491.51,493.36,0);
INSERT INTO intraday_data VALUES('$DJUSHV',20070827115900,20070827,115900,540.48,540.48,540.48,540.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,540.48,0);
INSERT INTO intraday_data VALUES('$DJUSID',20070827115900,20070827,115900,524.18,524.18,524.18,524.18,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSID',20070827,522.68,527.76,522.24,524.18,0);
INSERT INTO intraday_data VALUES('$DJUSIL',20070827115900,20070827,115900,684.82,684.82,684.82,684.82,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIL',20070827,687.95,688.53,683.68,684.82,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827115900,20070827,115900,350.47,350.48,350.45,350.48,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.48,0);
INSERT INTO intraday_data VALUES('$DJUSMS',20070827115900,20070827,115900,383.70,383.70,383.70,383.70,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMS',20070827,382.69,383.84,382.69,383.70,0);
INSERT INTO intraday_data VALUES('$DJUSPG',20070827115900,20070827,115900,265.31,265.31,265.31,265.31,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPG',20070827,268.57,268.57,265.08,265.31,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827115900,20070827,115900,284.43,284.43,284.42,284.43,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRE',20070827,287.10,287.12,282.50,284.43,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827115900,20070827,115900,116.24,116.24,116.23,116.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRI',20070827,117.28,117.34,115.42,116.24,0);
INSERT INTO intraday_data VALUES('$DJUSRU',20070827115900,20070827,115900,446.47,446.47,446.47,446.47,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRU',20070827,450.61,450.61,446.02,446.47,0);
INSERT INTO intraday_data VALUES('$DJUSSP',20070827115900,20070827,115900,108.43,108.43,108.43,108.43,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSP',20070827,108.46,109.00,108.31,108.43,0);
INSERT INTO intraday_data VALUES('$DJUSSW',20070827115900,20070827,115900,603.41,603.41,603.41,603.41,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSW',20070827,597.99,609.15,596.60,603.41,0);
INSERT INTO intraday_data VALUES('$DJUSTK',20070827115900,20070827,115900,329.53,329.53,329.53,329.53,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTK',20070827,331.69,332.09,329.17,329.53,0);
INSERT INTO intraday_data VALUES('$DJUSTR',20070827115900,20070827,115900,95.10,95.10,95.10,95.10,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTR',20070827,96.77,96.77,94.17,95.10,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827115900,20070827,115900,186.72,186.73,186.72,186.73,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUT',20070827,191.11,191.11,186.17,186.73,0);
INSERT INTO intraday_data VALUES('$DJUSWC',20070827115900,20070827,115900,403.33,403.33,403.33,403.33,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWC',20070827,402.90,403.92,401.97,403.33,0);
INSERT INTO intraday_data VALUES('$DJUSWU',20070827115900,20070827,115900,771.85,771.85,771.85,771.85,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWU',20070827,774.49,781.10,765.90,771.85,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827115900,20070827,115900,137.27,137.27,137.27,137.27,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.27,0);
INSERT INTO intraday_data VALUES('$INDU',20070827115900,20070827,115900,13334.73,13336.36,13334.33,13334.73,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13377.16,13305.87,13334.73,0);
INSERT INTO intraday_data VALUES('$INX',20070827115900,20070827,115900,1470.13,1470.25,1470.13,1470.25,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1470.25,0);
INSERT INTO intraday_data VALUES('$IUX',20070827115900,20070827,115900,790.22,790.24,790.22,790.24,0);
DELETE FROM eod_data WHERE `ticker` = "$IUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IUX',20070827,797.78,797.78,788.57,790.24,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827115900,20070827,115900,9542.21,9542.66,9542.12,9542.66,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,9542.66,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827115900,20070827,115900,685.70,685.77,685.70,685.77,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.77,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827115900,20070827,115900,729.51,729.60,729.48,729.60,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,729.60,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827115900,20070827,115900,416.19,416.21,416.19,416.21,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.21,0);
INSERT INTO intraday_data VALUES('AAPL',20070827115900,20070827,115900,133.28,133.33,133.28,133.29,10991);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.29,12810004);
INSERT INTO intraday_data VALUES('ACL',20070827115900,20070827,115900,133.97,133.97,133.97,133.97,100);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.97,153900);
INSERT INTO intraday_data VALUES('ADM',20070827115900,20070827,115900,32.86,32.87,32.86,32.86,2800);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.69,32.86,1313415);
INSERT INTO intraday_data VALUES('ADS',20070827115900,20070827,115900,76.51,76.51,76.50,76.50,400);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.43,76.50,248500);
INSERT INTO intraday_data VALUES('AET',20070827115900,20070827,115900,49.99,49.99,49.98,49.98,500);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.09,49.68,49.98,861600);
INSERT INTO intraday_data VALUES('AMD',20070827115900,20070827,115900,12.01,12.01,12.00,12.01,36000);
DELETE FROM eod_data WHERE `ticker` = "AMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMD',20070827,12.08,12.25,11.96,12.01,6215875);
INSERT INTO intraday_data VALUES('AMZN',20070827115900,20070827,115900,79.42,79.48,79.41,79.48,8824);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.48,3262608);
INSERT INTO intraday_data VALUES('AOB',20070827115900,20070827,115900,9.23,9.23,9.23,9.23,600);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.25,9.03,9.23,428500);
INSERT INTO intraday_data VALUES('APA',20070827115900,20070827,115900,75.33,75.35,75.33,75.35,800);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.15,75.35,956600);
INSERT INTO intraday_data VALUES('APH',20070827115900,20070827,115900,35.00,35.04,35.00,35.04,3400);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,35.04,234900);
INSERT INTO intraday_data VALUES('BA',20070827115900,20070827,115900,97.73,97.74,97.71,97.71,2500);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.36,97.13,97.71,1198405);
INSERT INTO intraday_data VALUES('BBY',20070827115900,20070827,115900,43.88,43.92,43.87,43.91,18400);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.81,43.91,1420315);
INSERT INTO intraday_data VALUES('BEN',20070827115900,20070827,115900,133.99,134.00,133.99,133.99,1300);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,133.50,133.99,280700);
INSERT INTO intraday_data VALUES('BG',20070827115900,20070827,115900,87.53,87.54,87.53,87.54,200);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,87.92,87.03,87.54,191200);
INSERT INTO intraday_data VALUES('BIDU',20070827115900,20070827,115900,209.12,209.20,209.05,209.20,3173);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,211.30,200.55,209.20,2331214);
INSERT INTO intraday_data VALUES('BNI',20070827115900,20070827,115900,80.27,80.27,80.23,80.25,2300);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,80.83,79.68,80.25,4144132);
INSERT INTO intraday_data VALUES('BRCD',20070827115900,20070827,115900,7.06,7.06,7.06,7.06,1300);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,7.02,7.06,3343996);
INSERT INTO intraday_data VALUES('BRY',20070827115900,20070827,115900,33.53,33.53,33.53,33.53,100);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.36,33.53,66100);
INSERT INTO intraday_data VALUES('BZH',20070827115900,20070827,115900,9.76,9.76,9.76,9.76,900);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.76,1131000);
INSERT INTO intraday_data VALUES('CAM',20070827115900,20070827,115900,77.26,77.26,77.26,77.26,200);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.26,348600);
INSERT INTO intraday_data VALUES('CHINA',20070827115900,20070827,115900,8.43,8.43,8.43,8.43,100);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.47,8.20,8.43,417747);
INSERT INTO intraday_data VALUES('CME',20070827115900,20070827,115900,559.15,559.15,559.15,559.15,100);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.80,556.00,559.15,148714);
INSERT INTO intraday_data VALUES('COG',20070827115900,20070827,115900,32.69,32.69,32.69,32.69,200);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.69,204600);
INSERT INTO intraday_data VALUES('COH',20070827115900,20070827,115900,43.26,43.29,43.26,43.29,7200);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.14,43.29,1549552);
INSERT INTO intraday_data VALUES('CRDN',20070827115900,20070827,115900,69.98,69.98,69.97,69.97,460);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.76,69.97,222747);
INSERT INTO intraday_data VALUES('CSCO',20070827115900,20070827,115900,30.91,30.93,30.91,30.93,47985);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.93,18058474);
INSERT INTO intraday_data VALUES('CXW',20070827115900,20070827,115900,25.45,25.45,25.41,25.41,1800);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.30,25.41,395000);
INSERT INTO intraday_data VALUES('DECK',20070827115900,20070827,115900,94.54,94.54,94.54,94.54,100);
DELETE FROM eod_data WHERE `ticker` = "DECK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DECK',20070827,96.35,96.48,94.00,94.54,117995);
INSERT INTO intraday_data VALUES('DNA',20070827115900,20070827,115900,73.11,73.12,73.10,73.10,4200);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.10,73.10,478800);
INSERT INTO intraday_data VALUES('DRIV',20070827115900,20070827,115900,44.67,44.67,44.67,44.67,100);
DELETE FROM eod_data WHERE `ticker` = "DRIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRIV',20070827,44.64,44.99,44.45,44.67,93600);
INSERT INTO intraday_data VALUES('DRQ',20070827115900,20070827,115900,44.80,44.80,44.80,44.80,400);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.60,44.80,81600);
INSERT INTO intraday_data VALUES('DRYS',20070827115900,20070827,115900,66.59,66.75,66.50,66.63,7300);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.45,63.16,66.63,1192691);
INSERT INTO intraday_data VALUES('ECA',20070827115900,20070827,115900,58.49,58.53,58.49,58.53,4700);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.53,605833);
INSERT INTO intraday_data VALUES('EOG',20070827115900,20070827,115900,66.75,66.76,66.75,66.76,1500);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.76,718050);
INSERT INTO intraday_data VALUES('ESV',20070827115900,20070827,115900,56.77,56.78,56.76,56.76,1700);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.56,56.76,631300);
INSERT INTO intraday_data VALUES('EXPD',20070827115900,20070827,115900,45.21,45.21,45.21,45.21,300);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.69,45.01,45.21,262961);
INSERT INTO intraday_data VALUES('EZPW',20070827115900,20070827,115900,12.59,12.59,12.59,12.59,300);
DELETE FROM eod_data WHERE `ticker` = "EZPW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EZPW',20070827,12.65,12.65,12.48,12.59,59617);
INSERT INTO intraday_data VALUES('FLR',20070827115900,20070827,115900,124.49,124.49,124.43,124.49,500);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.25,123.02,124.49,413075);
INSERT INTO intraday_data VALUES('FRX',20070827115900,20070827,115900,37.19,37.19,37.18,37.18,2500);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.18,975300);
INSERT INTO intraday_data VALUES('GES',20070827115900,20070827,115900,49.40,49.45,49.40,49.45,900);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.36,49.45,319793);
INSERT INTO intraday_data VALUES('GGB',20070827115900,20070827,115900,22.99,22.99,22.99,22.99,1500);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,22.99,643900);
INSERT INTO intraday_data VALUES('GILD',20070827115900,20070827,115900,36.89,36.91,36.88,36.91,12339);
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,1689389);
INSERT INTO intraday_data VALUES('GRA',20070827115900,20070827,115900,22.04,22.04,22.04,22.04,300);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.84,22.04,175700);
INSERT INTO intraday_data VALUES('GS',20070827115900,20070827,115900,178.39,178.42,178.35,178.38,7000);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.50,178.38,3103800);
INSERT INTO intraday_data VALUES('GTI',20070827115900,20070827,115900,17.09,17.11,17.09,17.11,200);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,17.11,1068100);
INSERT INTO intraday_data VALUES('HAL',20070827115900,20070827,115900,33.43,33.43,33.42,33.43,6400);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.36,33.43,4052502);
INSERT INTO intraday_data VALUES('HNR',20070827115900,20070827,115900,11.10,11.10,11.09,11.09,200);
DELETE FROM eod_data WHERE `ticker` = "HNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HNR',20070827,11.19,11.25,11.01,11.09,73500);
INSERT INTO intraday_data VALUES('HOC',20070827115900,20070827,115900,64.92,64.92,64.85,64.85,2400);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,64.85,349075);
INSERT INTO intraday_data VALUES('HXM',20070827115900,20070827,115900,53.49,53.49,53.49,53.49,100);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.49,109400);
INSERT INTO intraday_data VALUES('IBM',20070827115900,20070827,115900,113.34,113.35,113.33,113.33,4100);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.59,112.80,113.33,1727102);
INSERT INTO intraday_data VALUES('ICE',20070827115900,20070827,115900,140.51,140.51,140.51,140.51,200);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.88,140.51,390300);
INSERT INTO intraday_data VALUES('INFY',20070827115900,20070827,115900,46.40,46.40,46.39,46.40,2100);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.35,46.40,523618);
INSERT INTO intraday_data VALUES('IVGN',20070827115900,20070827,115900,78.79,78.79,78.79,78.79,200);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,78.79,77.95,78.79,126635);
INSERT INTO intraday_data VALUES('JCP',20070827115900,20070827,115900,66.32,66.32,66.28,66.28,2500);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,66.28,856100);
INSERT INTO intraday_data VALUES('JEC',20070827115900,20070827,115900,64.08,64.10,64.07,64.08,1300);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.87,64.08,211900);
INSERT INTO intraday_data VALUES('JOYG',20070827115900,20070827,115900,48.10,48.11,48.08,48.09,2140);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.09,657391);
INSERT INTO intraday_data VALUES('JWN',20070827115900,20070827,115900,48.12,48.15,48.12,48.14,3600);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,48.12,48.14,1263500);
INSERT INTO intraday_data VALUES('KEP',20070827115900,20070827,115900,22.07,22.08,22.07,22.07,1300);
DELETE FROM eod_data WHERE `ticker` = "KEP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KEP',20070827,22.09,22.20,21.86,22.07,148200);
INSERT INTO intraday_data VALUES('LEH',20070827115900,20070827,115900,58.78,58.82,58.78,58.78,7300);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.43,58.78,3431318);
INSERT INTO intraday_data VALUES('LMT',20070827115900,20070827,115900,100.95,100.96,100.87,100.87,3500);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.25,99.12,100.87,732290);
INSERT INTO intraday_data VALUES('LVS',20070827115900,20070827,115900,98.93,98.97,98.86,98.90,5000);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,98.90,1441825);
INSERT INTO intraday_data VALUES('MDC',20070827115900,20070827,115900,44.11,44.11,44.11,44.11,200);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,44.08,44.11,259100);
INSERT INTO intraday_data VALUES('MSFT',20070827115900,20070827,115900,28.44,28.46,28.44,28.46,84263);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.42,28.46,9569713);
INSERT INTO intraday_data VALUES('MTH',20070827115900,20070827,115900,17.91,17.92,17.89,17.91,6000);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,17.89,17.91,326391);
INSERT INTO intraday_data VALUES('MTW',20070827115900,20070827,115900,76.02,76.06,76.00,76.06,3400);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.06,227700);
INSERT INTO intraday_data VALUES('MT',20070827115900,20070827,115900,63.85,63.87,63.84,63.84,400);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.50,63.84,883960);
INSERT INTO intraday_data VALUES('NEM',20070827115900,20070827,115900,40.73,40.73,40.71,40.71,6200);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.41,40.71,1841400);
INSERT INTO intraday_data VALUES('NVDA',20070827115900,20070827,115900,49.30,49.38,49.30,49.38,8806);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.38,4003380);
INSERT INTO intraday_data VALUES('NWRE',20070827115900,20070827,115900,15.96,15.96,15.96,15.96,200);
DELETE FROM eod_data WHERE `ticker` = "NWRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NWRE',20070827,15.83,15.96,15.83,15.96,95043);
INSERT INTO intraday_data VALUES('NYX',20070827115900,20070827,115900,73.83,73.83,73.77,73.77,3500);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.75,73.77,766742);
INSERT INTO intraday_data VALUES('OCR',20070827115900,20070827,115900,32.86,32.86,32.86,32.86,1100);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.01,32.66,32.86,236000);
INSERT INTO intraday_data VALUES('PETS',20070827115900,20070827,115900,15.57,15.57,15.57,15.57,200);
DELETE FROM eod_data WHERE `ticker` = "PETS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PETS',20070827,15.60,15.67,15.33,15.57,97469);
INSERT INTO intraday_data VALUES('PMTI',20070827115900,20070827,115900,30.48,30.48,30.48,30.48,200);
DELETE FROM eod_data WHERE `ticker` = "PMTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PMTI',20070827,30.67,30.72,30.25,30.48,51875);
INSERT INTO intraday_data VALUES('PNK',20070827115900,20070827,115900,27.22,27.22,27.21,27.22,600);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.27,26.85,27.22,118400);
INSERT INTO intraday_data VALUES('POT',20070827115900,20070827,115900,85.79,85.81,85.77,85.77,2000);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.59,85.77,578250);
INSERT INTO intraday_data VALUES('PRST',20070827115900,20070827,115900,6.49,6.49,6.49,6.49,200);
DELETE FROM eod_data WHERE `ticker` = "PRST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRST',20070827,6.52,6.66,6.48,6.49,41345);
INSERT INTO intraday_data VALUES('QQQQ',20070827115900,20070827,115900,47.92,47.93,47.91,47.93,34065);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,47.93,29147830);
INSERT INTO intraday_data VALUES('REXI',20070827115900,20070827,115900,15.88,15.91,15.88,15.89,1200);
DELETE FROM eod_data WHERE `ticker` = "REXI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('REXI',20070827,16.24,16.37,15.67,15.89,54316);
INSERT INTO intraday_data VALUES('RIG',20070827115900,20070827,115900,102.02,102.02,101.98,101.98,11400);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.98,101.98,1341233);
INSERT INTO intraday_data VALUES('RIMM',20070827115900,20070827,115900,80.80,80.84,80.80,80.84,3959);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,80.84,2992942);
INSERT INTO intraday_data VALUES('RIO',20070827115900,20070827,115900,47.52,47.53,47.49,47.52,5800);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.93,47.09,47.52,5341373);
INSERT INTO intraday_data VALUES('RL',20070827115900,20070827,115900,76.69,76.75,76.69,76.72,1800);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.63,76.72,418700);
INSERT INTO intraday_data VALUES('RMD',20070827115900,20070827,115900,41.44,41.47,41.44,41.44,2600);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.33,41.44,192105);
INSERT INTO intraday_data VALUES('RYL',20070827115900,20070827,115900,30.35,30.35,30.32,30.32,1100);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.32,30.32,565781);
INSERT INTO intraday_data VALUES('SCI',20070827115900,20070827,115900,12.00,12.00,11.99,11.99,3100);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,11.98,11.99,163300);
INSERT INTO intraday_data VALUES('SCUR',20070827115900,20070827,115900,8.25,8.25,8.25,8.25,850);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.23,8.25,188786);
INSERT INTO intraday_data VALUES('SEIC',20070827115900,20070827,115900,25.79,25.79,25.78,25.78,500);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.78,114079);
INSERT INTO intraday_data VALUES('SID',20070827115900,20070827,115900,53.55,53.59,53.55,53.56,1300);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.67,53.56,527600);
INSERT INTO intraday_data VALUES('SII',20070827115900,20070827,115900,62.35,62.36,62.31,62.31,3400);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.07,62.31,511000);
INSERT INTO intraday_data VALUES('SIMG',20070827115900,20070827,115900,5.83,5.83,5.83,5.83,600);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.83,276837);
INSERT INTO intraday_data VALUES('SKX',20070827115900,20070827,115900,19.85,19.86,19.85,19.86,1300);
DELETE FROM eod_data WHERE `ticker` = "SKX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SKX',20070827,20.10,20.10,19.83,19.86,153600);
INSERT INTO intraday_data VALUES('SLB',20070827115900,20070827,115900,92.43,92.46,92.42,92.45,8200);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.10,92.45,1923800);
INSERT INTO intraday_data VALUES('SNDK',20070827115900,20070827,115900,52.40,52.44,52.37,52.43,24458);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.12,52.43,3793225);
INSERT INTO intraday_data VALUES('SNE',20070827115900,20070827,115900,46.36,46.36,46.36,46.36,800);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.36,239586);
INSERT INTO intraday_data VALUES('SPG',20070827115900,20070827,115900,93.40,93.45,93.36,93.36,3300);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,93.36,312000);
INSERT INTO intraday_data VALUES('SPIL',20070827115900,20070827,115900,10.14,10.15,10.14,10.15,1053);
DELETE FROM eod_data WHERE `ticker` = "SPIL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPIL',20070827,10.26,10.26,10.00,10.15,390440);
INSERT INTO intraday_data VALUES('SPN',20070827115900,20070827,115900,38.08,38.09,38.06,38.06,800);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.01,38.06,148200);
INSERT INTO intraday_data VALUES('SPWR',20070827115900,20070827,115900,62.50,62.53,62.50,62.53,400);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.32,62.53,369573);
INSERT INTO intraday_data VALUES('SPY',20070827115900,20070827,115900,147.30,147.32,147.29,147.29,28800);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,146.97,147.29,42352783);
INSERT INTO intraday_data VALUES('STLD',20070827115900,20070827,115900,43.32,43.32,43.31,43.31,1000);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.31,509187);
INSERT INTO intraday_data VALUES('STR',20070827115900,20070827,115900,49.70,49.72,49.70,49.72,300);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.29,49.72,421800);
INSERT INTO intraday_data VALUES('SWKS',20070827115900,20070827,115900,7.71,7.72,7.71,7.72,1700);
DELETE FROM eod_data WHERE `ticker` = "SWKS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWKS',20070827,7.88,7.95,7.69,7.72,611432);
INSERT INTO intraday_data VALUES('TEX',20070827115900,20070827,115900,78.44,78.44,78.44,78.44,100);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,77.82,78.44,446700);
INSERT INTO intraday_data VALUES('THOR',20070827115900,20070827,115900,20.73,20.73,20.73,20.73,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.73,48551);
INSERT INTO intraday_data VALUES('TOPT',20070827115900,20070827,115900,5.74,5.74,5.74,5.74,100);
DELETE FROM eod_data WHERE `ticker` = "TOPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOPT',20070827,5.84,5.84,5.73,5.74,127496);
INSERT INTO intraday_data VALUES('TSN',20070827115900,20070827,115900,21.28,21.28,21.27,21.27,1000);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.22,21.27,496205);
INSERT INTO intraday_data VALUES('UPL',20070827115900,20070827,115900,54.77,54.77,54.75,54.75,1900);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.75,348100);
INSERT INTO intraday_data VALUES('URBN',20070827115900,20070827,115900,22.59,22.59,22.59,22.59,100);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.59,894290);
INSERT INTO intraday_data VALUES('VIP',20070827115900,20070827,115900,22.28,22.28,22.28,22.28,900);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.08,22.28,749130);
INSERT INTO intraday_data VALUES('VLO',20070827115900,20070827,115900,67.31,67.33,67.30,67.32,8100);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.32,1952294);
INSERT INTO intraday_data VALUES('VSEA',20070827115900,20070827,115900,55.12,55.12,55.07,55.10,3438);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,56.58,54.53,55.10,1096030);
INSERT INTO intraday_data VALUES('WCC',20070827115900,20070827,115900,48.10,48.12,48.08,48.09,3700);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,48.00,48.09,173894);
INSERT INTO intraday_data VALUES('WFMI',20070827115900,20070827,115900,45.84,45.89,45.84,45.88,3903);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.88,1658087);
INSERT INTO intraday_data VALUES('WFR',20070827115900,20070827,115900,58.52,58.55,58.52,58.55,600);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.35,58.55,489500);
INSERT INTO intraday_data VALUES('WFT',20070827115900,20070827,115900,55.76,55.76,55.75,55.75,2600);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.69,55.75,959300);
INSERT INTO intraday_data VALUES('WLP',20070827115900,20070827,115900,78.48,78.49,78.48,78.48,6800);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.54,77.89,78.48,906600);
INSERT INTO intraday_data VALUES('WNR',20070827115900,20070827,115900,51.99,51.99,51.99,51.99,500);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,51.99,357200);
INSERT INTO intraday_data VALUES('XING',20070827115900,20070827,115900,9.24,9.24,9.23,9.23,200);
DELETE FROM eod_data WHERE `ticker` = "XING" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('XING',20070827,8.98,9.38,8.83,9.23,221836);
INSERT INTO intraday_data VALUES('X',20070827115900,20070827,115900,93.34,93.44,93.34,93.44,4000);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,93.44,1476904);
INSERT INTO intraday_data VALUES('YHOO',20070827115900,20070827,115900,23.23,23.23,23.22,23.23,7190);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.21,23.23,5505993);
INSERT INTO intraday_data VALUES('$COMPX',20070827115900,20070827,115900,2561.18,2561.55,2561.18,2561.55,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2561.55,0);
INSERT INTO intraday_data VALUES('$DJUSBD',20070827115900,20070827,115900,360.80,360.80,360.80,360.80,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBD',20070827,363.23,364.72,360.40,360.80,0);
INSERT INTO intraday_data VALUES('$DJUSCA',20070827115900,20070827,115900,750.37,750.37,750.37,750.37,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCA',20070827,757.25,757.25,747.32,750.37,0);
INSERT INTO intraday_data VALUES('$DJUSCL',20070827115900,20070827,115900,258.50,258.50,258.50,258.50,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.50,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827115900,20070827,115900,594.04,594.11,594.04,594.08,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.75,594.08,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827115900,20070827,115900,548.36,548.40,548.36,548.40,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFN',20070827,552.10,552.10,546.51,548.40,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827115900,20070827,115900,343.30,343.30,343.28,343.30,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHC',20070827,343.94,344.09,342.98,343.30,0);
INSERT INTO intraday_data VALUES('$DJUSMG',20070827115900,20070827,115900,155.03,155.03,155.03,155.03,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMG',20070827,158.00,158.00,154.17,155.03,0);
INSERT INTO intraday_data VALUES('$DJUSMU',20070827115900,20070827,115900,121.21,121.21,121.21,121.21,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMU',20070827,123.48,123.48,120.79,121.21,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827115900,20070827,115900,308.70,308.70,308.69,308.70,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.70,0);
INSERT INTO intraday_data VALUES('$DJUSPC',20070827115900,20070827,115900,111.83,111.83,111.83,111.83,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPC',20070827,113.00,113.00,111.53,111.83,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827115900,20070827,115900,405.69,405.81,405.65,405.79,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.79,0);
INSERT INTO intraday_data VALUES('$DJUSRT',20070827115900,20070827,115900,371.59,371.59,371.59,371.59,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRT',20070827,369.66,374.33,367.07,371.59,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827115900,20070827,115900,1332.47,1332.91,1332.47,1332.91,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1327.39,1332.91,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827115900,20070827,115900,612.64,612.69,612.62,612.69,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,611.66,612.69,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827115900,20070827,115900,186.97,186.97,186.96,186.96,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.42,186.26,186.96,0);
INSERT INTO intraday_data VALUES('$IDX',20070827115900,20070827,115900,855.97,856.00,855.96,856.00,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,856.00,0);
INSERT INTO intraday_data VALUES('$VIX',20070827115900,20070827,115900,22.38,22.38,22.37,22.37,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',20070827115900,20070827,115900,10.18,10.19,10.18,10.19,1100);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.15,10.19,486106);
INSERT INTO intraday_data VALUES('ADSK',20070827115900,20070827,115900,45.35,45.36,45.33,45.34,1400);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.51,44.75,45.34,477987);
INSERT INTO intraday_data VALUES('ALB',20070827115900,20070827,115900,38.40,38.40,38.40,38.40,200);
DELETE FROM eod_data WHERE `ticker` = "ALB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ALB',20070827,38.51,38.60,37.97,38.40,248000);
INSERT INTO intraday_data VALUES('AMTD',20070827115900,20070827,115900,17.55,17.56,17.55,17.56,700);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.65,17.40,17.56,913590);
INSERT INTO intraday_data VALUES('AMX',20070827115900,20070827,115900,60.48,60.48,60.47,60.47,1300);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.74,60.06,60.47,1344100);
INSERT INTO intraday_data VALUES('ANF',20070827115900,20070827,115900,78.89,78.89,78.89,78.89,100);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,78.89,778100);
INSERT INTO intraday_data VALUES('AZN',20070827115900,20070827,115900,48.23,48.26,48.23,48.26,3300);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.15,48.26,272700);
INSERT INTO intraday_data VALUES('BCSI',20070827115900,20070827,115900,86.56,86.75,86.56,86.75,1665);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,86.75,1230825);
INSERT INTO intraday_data VALUES('BDK',20070827115900,20070827,115900,87.09,87.09,87.09,87.09,200);
DELETE FROM eod_data WHERE `ticker` = "BDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BDK',20070827,87.69,88.27,86.99,87.09,154200);
INSERT INTO intraday_data VALUES('BHP',20070827115900,20070827,115900,61.95,61.96,61.92,61.92,1600);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,61.92,629090);
INSERT INTO intraday_data VALUES('BTU',20070827115900,20070827,115900,41.51,41.51,41.49,41.49,1100);
DELETE FROM eod_data WHERE `ticker` = "BTU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BTU',20070827,42.44,42.56,41.19,41.49,1594792);
INSERT INTO intraday_data VALUES('CAMP',20070827115900,20070827,115900,3.74,3.74,3.73,3.74,500);
DELETE FROM eod_data WHERE `ticker` = "CAMP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAMP',20070827,3.72,3.78,3.72,3.74,20520);
INSERT INTO intraday_data VALUES('CBB',20070827115900,20070827,115900,4.97,4.97,4.96,4.96,600);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,5.00,4.91,4.96,344000);
INSERT INTO intraday_data VALUES('CCJ',20070827115900,20070827,115900,40.04,40.07,40.04,40.07,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.07,1124062);
INSERT INTO intraday_data VALUES('CEG',20070827115900,20070827,115900,84.13,84.19,84.13,84.14,2100);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.86,84.14,642300);
INSERT INTO intraday_data VALUES('CELG',20070827115900,20070827,115900,59.39,59.40,59.39,59.40,1780);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.78,59.30,59.40,824844);
INSERT INTO intraday_data VALUES('CERN',20070827115900,20070827,115900,56.44,56.45,56.44,56.44,700);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.34,56.44,77878);
INSERT INTO intraday_data VALUES('CFC',20070827115900,20070827,115900,19.95,19.96,19.95,19.95,32900);
DELETE FROM eod_data WHERE `ticker` = "CFC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CFC',20070827,20.32,20.33,19.53,19.95,23609691);
INSERT INTO intraday_data VALUES('CHAP',20070827115900,20070827,115900,85.36,85.36,85.36,85.36,600);
DELETE FROM eod_data WHERE `ticker` = "CHAP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHAP',20070827,85.34,85.43,85.25,85.36,234751);
INSERT INTO intraday_data VALUES('CHRW',20070827115900,20070827,115900,49.02,49.02,49.02,49.02,100);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.02,193142);
INSERT INTO intraday_data VALUES('CI',20070827115900,20070827,115900,49.93,49.94,49.93,49.94,4600);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.87,49.94,571692);
INSERT INTO intraday_data VALUES('CMC',20070827115900,20070827,115900,29.28,29.30,29.27,29.28,3100);
DELETE FROM eod_data WHERE `ticker` = "CMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMC',20070827,29.99,29.99,29.07,29.28,405600);
INSERT INTO intraday_data VALUES('CNH',20070827115900,20070827,115900,48.92,48.92,48.92,48.92,100);
DELETE FROM eod_data WHERE `ticker` = "CNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CNH',20070827,49.67,50.35,48.87,48.92,112100);
INSERT INTO intraday_data VALUES('COGO',20070827115900,20070827,115900,17.32,17.32,17.31,17.31,1000);
DELETE FROM eod_data WHERE `ticker` = "COGO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COGO',20070827,17.16,17.64,17.16,17.31,166468);
INSERT INTO intraday_data VALUES('COP',20070827115900,20070827,115900,80.74,80.76,80.74,80.74,6400);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,80.82,80.02,80.74,2244100);
INSERT INTO intraday_data VALUES('CRI',20070827115900,20070827,115900,20.02,20.02,19.99,19.99,1600);
DELETE FROM eod_data WHERE `ticker` = "CRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRI',20070827,20.56,20.56,19.92,19.99,180600);
INSERT INTO intraday_data VALUES('CROX',20070827115900,20070827,115900,59.90,59.95,59.90,59.94,3375);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,59.94,4334752);
INSERT INTO intraday_data VALUES('CTRP',20070827115900,20070827,115900,43.45,43.48,43.41,43.48,980);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.48,514391);
INSERT INTO intraday_data VALUES('CTSH',20070827115900,20070827,115900,73.83,73.85,73.83,73.83,1000);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,73.83,869893);
INSERT INTO intraday_data VALUES('CTX',20070827115900,20070827,115900,30.45,30.45,30.43,30.44,3900);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.43,30.44,1371334);
INSERT INTO intraday_data VALUES('CVH',20070827115900,20070827,115900,58.02,58.02,57.98,57.98,600);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,57.98,275100);
INSERT INTO intraday_data VALUES('CX',20070827115900,20070827,115900,31.34,31.35,31.33,31.33,700);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.25,31.33,897800);
INSERT INTO intraday_data VALUES('DIA',20070827115900,20070827,115900,133.28,133.28,133.27,133.27,3600);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.54,132.98,133.27,3035844);
INSERT INTO intraday_data VALUES('EBAY',20070827115900,20070827,115900,33.68,33.69,33.68,33.69,6492);
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,3319124);
INSERT INTO intraday_data VALUES('ENR',20070827115900,20070827,115900,107.70,107.75,107.70,107.75,300);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,107.75,265400);
INSERT INTO intraday_data VALUES('ESRX',20070827115900,20070827,115900,54.68,54.68,54.68,54.68,100);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.68,360036);
INSERT INTO intraday_data VALUES('EXP',20070827115900,20070827,115900,38.21,38.21,38.14,38.14,3300);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.14,38.14,261300);
INSERT INTO intraday_data VALUES('FDG',20070827115900,20070827,115900,32.84,32.86,32.84,32.86,2900);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.88,32.05,32.86,196775);
INSERT INTO intraday_data VALUES('FFIV',20070827115900,20070827,115900,36.51,36.51,36.49,36.49,800);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,36.49,408372);
INSERT INTO intraday_data VALUES('FMD',20070827115900,20070827,115900,35.34,35.40,35.34,35.39,1900);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.44,35.02,35.39,221600);
INSERT INTO intraday_data VALUES('GOOG',20070827115900,20070827,115900,514.50,514.50,514.32,514.32,1700);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,514.32,1234321);
INSERT INTO intraday_data VALUES('GRMN',20070827115900,20070827,115900,101.79,101.79,101.73,101.73,700);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,101.73,1135891);
INSERT INTO intraday_data VALUES('HOG',20070827115900,20070827,115900,54.26,54.28,54.25,54.28,1500);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.28,662386);
INSERT INTO intraday_data VALUES('HOV',20070827115900,20070827,115900,11.33,11.34,11.33,11.33,4000);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.32,11.33,844344);
INSERT INTO intraday_data VALUES('HPC',20070827115900,20070827,115900,21.37,21.38,21.37,21.37,3300);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.30,21.37,413587);
INSERT INTO intraday_data VALUES('JCI',20070827115900,20070827,115900,111.63,111.63,111.61,111.63,1000);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.21,111.63,154800);
INSERT INTO intraday_data VALUES('KBH',20070827115900,20070827,115900,30.69,30.70,30.68,30.70,1900);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.65,30.70,1013200);
INSERT INTO intraday_data VALUES('KCI',20070827115900,20070827,115900,62.01,62.01,62.01,62.01,600);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,61.93,62.01,249300);
INSERT INTO intraday_data VALUES('KG',20070827115900,20070827,115900,15.62,15.63,15.61,15.62,4400);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.70,15.52,15.62,334600);
INSERT INTO intraday_data VALUES('KSS',20070827115900,20070827,115900,57.85,57.86,57.84,57.84,6600);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,57.83,57.84,1606300);
INSERT INTO intraday_data VALUES('LRCX',20070827115900,20070827,115900,52.96,52.98,52.96,52.98,200);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.88,52.98,941230);
INSERT INTO intraday_data VALUES('MBT',20070827115900,20070827,115900,61.70,61.70,61.70,61.70,100);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.60,61.53,61.70,276400);
INSERT INTO intraday_data VALUES('MCD',20070827115900,20070827,115900,49.50,49.50,49.49,49.50,3500);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.42,49.50,1674912);
INSERT INTO intraday_data VALUES('MGM',20070827115900,20070827,115900,82.75,82.75,82.71,82.71,800);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.71,461500);
INSERT INTO intraday_data VALUES('MICC',20070827115900,20070827,115900,81.60,81.61,81.57,81.58,800);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.34,81.58,147070);
INSERT INTO intraday_data VALUES('MNT',20070827115900,20070827,115900,44.10,44.12,44.10,44.12,600);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.12,43.63,44.12,250723);
INSERT INTO intraday_data VALUES('MOS',20070827115900,20070827,115900,40.55,40.55,40.47,40.50,8000);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.50,932600);
INSERT INTO intraday_data VALUES('MRVL',20070827115900,20070827,115900,15.49,15.49,15.47,15.49,94696);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.49,9072073);
INSERT INTO intraday_data VALUES('NFX',20070827115900,20070827,115900,43.47,43.47,43.46,43.46,1800);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.39,43.46,470200);
INSERT INTO intraday_data VALUES('NILE',20070827115900,20070827,115900,85.34,85.35,85.24,85.24,700);
DELETE FROM eod_data WHERE `ticker` = "NILE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NILE',20070827,86.59,87.20,84.92,85.24,90178);
INSERT INTO intraday_data VALUES('NOV',20070827115900,20070827,115900,118.99,119.05,118.99,119.03,500);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,119.03,901221);
INSERT INTO intraday_data VALUES('NSTC',20070827115900,20070827,115900,10.96,10.96,10.96,10.96,100);
DELETE FROM eod_data WHERE `ticker` = "NSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NSTC',20070827,10.99,11.11,10.90,10.96,34163);
INSERT INTO intraday_data VALUES('NTES',20070827115900,20070827,115900,16.22,16.25,16.22,16.25,3214);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.21,16.25,364870);
INSERT INTO intraday_data VALUES('NUE',20070827115900,20070827,115900,53.88,53.90,53.88,53.90,2200);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.42,53.90,2496769);
INSERT INTO intraday_data VALUES('OII',20070827115900,20070827,115900,64.23,64.23,64.23,64.23,100);
DELETE FROM eod_data WHERE `ticker` = "OII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OII',20070827,65.35,65.45,64.02,64.23,118700);
INSERT INTO intraday_data VALUES('ORCL',20070827115900,20070827,115900,19.81,19.81,19.80,19.80,5317);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.80,8651799);
INSERT INTO intraday_data VALUES('OXY',20070827115900,20070827,115900,56.31,56.32,56.29,56.30,4100);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.30,937800);
INSERT INTO intraday_data VALUES('PBR',20070827115900,20070827,115900,58.86,58.87,58.85,58.87,300);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.41,58.47,58.87,1368989);
INSERT INTO intraday_data VALUES('PCP',20070827115900,20070827,115900,137.00,137.02,137.00,137.02,500);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.13,137.02,366800);
INSERT INTO intraday_data VALUES('PCU',20070827115900,20070827,115900,102.49,102.54,102.47,102.47,1300);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,102.47,903573);
INSERT INTO intraday_data VALUES('PRFT',20070827115900,20070827,115900,23.23,23.24,23.23,23.24,200);
DELETE FROM eod_data WHERE `ticker` = "PRFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRFT',20070827,23.04,23.45,22.95,23.24,114659);
INSERT INTO intraday_data VALUES('QDEL',20070827115900,20070827,115900,17.25,17.26,17.25,17.26,200);
DELETE FROM eod_data WHERE `ticker` = "QDEL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QDEL',20070827,17.33,17.40,17.06,17.26,84371);
INSERT INTO intraday_data VALUES('RAI',20070827115900,20070827,115900,65.19,65.19,65.19,65.19,100);
DELETE FROM eod_data WHERE `ticker` = "RAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RAI',20070827,65.60,65.99,65.10,65.19,307200);
INSERT INTO intraday_data VALUES('SBGI',20070827115900,20070827,115900,12.46,12.46,12.43,12.43,700);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.42,12.43,456379);
INSERT INTO intraday_data VALUES('SBUX',20070827115900,20070827,115900,27.42,27.43,27.42,27.43,2666);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.43,1533217);
INSERT INTO intraday_data VALUES('SPF',20070827115900,20070827,115900,9.86,9.86,9.85,9.85,1200);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.85,852900);
INSERT INTO intraday_data VALUES('SWN',20070827115900,20070827,115900,37.41,37.41,37.37,37.39,400);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.39,660200);
INSERT INTO intraday_data VALUES('SYK',20070827115900,20070827,115900,67.22,67.24,67.22,67.24,400);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.11,67.24,275532);
INSERT INTO intraday_data VALUES('TDW',20070827115900,20070827,115900,64.59,64.62,64.59,64.61,1300);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.25,64.45,64.61,392615);
INSERT INTO intraday_data VALUES('TLM',20070827115900,20070827,115900,17.00,17.01,17.00,17.01,2000);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.97,17.01,707800);
INSERT INTO intraday_data VALUES('TOL',20070827115900,20070827,115900,22.27,22.28,22.27,22.28,2200);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.22,22.28,1981266);
INSERT INTO intraday_data VALUES('TRAD',20070827115900,20070827,115900,10.73,10.74,10.72,10.74,2100);
DELETE FROM eod_data WHERE `ticker` = "TRAD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRAD',20070827,10.88,10.92,10.70,10.74,89859);
INSERT INTO intraday_data VALUES('TSO',20070827115900,20070827,115900,49.45,49.45,49.44,49.45,600);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.45,995500);
INSERT INTO intraday_data VALUES('TS',20070827115900,20070827,115900,46.68,46.71,46.68,46.71,1900);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.71,1237800);
INSERT INTO intraday_data VALUES('TXU',20070827115900,20070827,115900,66.03,66.04,66.00,66.00,13700);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.87,66.00,2401700);
INSERT INTO intraday_data VALUES('UA',20070827115900,20070827,115900,64.42,64.43,64.37,64.42,700);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,64.42,338800);
INSERT INTO intraday_data VALUES('UNH',20070827115900,20070827,115900,49.56,49.57,49.56,49.57,1700);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.38,49.57,1543780);
INSERT INTO intraday_data VALUES('USG',20070827115900,20070827,115900,37.91,37.91,37.91,37.91,800);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.78,37.91,270800);
INSERT INTO intraday_data VALUES('WDC',20070827115900,20070827,115900,21.92,21.92,21.92,21.92,600);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.77,21.92,915700);