INSERT INTO intraday_data VALUES('$COMPX',20070827124000,20070827,124000,2564.24,2564.50,2564.24,2564.50,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.50,0);
INSERT INTO intraday_data VALUES('$DJUSBE',20070827124000,20070827,124000,125.68,125.68,125.68,125.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBE',20070827,126.81,126.81,125.06,125.68,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827124000,20070827,124000,270.80,270.82,270.79,270.82,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.82,0);
INSERT INTO intraday_data VALUES('$DJUSBV',20070827124000,20070827,124000,313.85,313.85,313.85,313.85,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBV',20070827,313.92,314.11,312.48,313.85,0);
INSERT INTO intraday_data VALUES('$DJUSCC',20070827124000,20070827,124000,248.26,248.26,248.26,248.26,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCC',20070827,248.47,249.49,247.12,248.26,0);
INSERT INTO intraday_data VALUES('$DJUSCF',20070827124000,20070827,124000,176.54,176.54,176.54,176.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCF',20070827,177.95,180.61,175.72,176.54,0);
INSERT INTO intraday_data VALUES('$DJUSCR',20070827124000,20070827,124000,641.31,641.31,641.31,641.31,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCR',20070827,632.34,643.67,630.75,641.31,0);
INSERT INTO intraday_data VALUES('$DJUSCT',20070827124000,20070827,124000,778.88,778.88,778.88,778.88,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCT',20070827,776.11,779.76,776.11,778.88,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827124000,20070827,124000,335.55,335.56,335.54,335.56,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.56,0);
INSERT INTO intraday_data VALUES('$DJUSDB',20070827124000,20070827,124000,340.03,340.03,340.03,340.03,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDB',20070827,336.99,340.85,336.80,340.03,0);
INSERT INTO intraday_data VALUES('$DJUSDN',20070827124000,20070827,124000,147.45,147.45,147.45,147.45,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDN',20070827,147.34,147.45,146.73,147.45,0);
INSERT INTO intraday_data VALUES('$DJUSDS',20070827124000,20070827,124000,143.08,143.08,143.08,143.08,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDS',20070827,142.84,143.32,142.18,143.08,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827124000,20070827,124000,594.90,594.99,594.90,594.99,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.62,594.99,0);
INSERT INTO intraday_data VALUES('$DJUSFD',20070827124000,20070827,124000,227.32,227.32,227.32,227.32,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFD',20070827,229.17,229.17,227.30,227.32,0);
INSERT INTO intraday_data VALUES('$DJUSFH',20070827124000,20070827,124000,221.94,221.94,221.94,221.94,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFH',20070827,224.79,224.79,221.28,221.94,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827124000,20070827,124000,548.05,548.07,548.02,548.07,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.07,0);
INSERT INTO intraday_data VALUES('$DJUSGF',20070827124000,20070827,124000,797.38,797.38,797.38,797.38,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGF',20070827,804.70,804.70,796.21,797.38,0);
INSERT INTO intraday_data VALUES('$DJUSGI',20070827124000,20070827,124000,436.24,436.24,436.24,436.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGI',20070827,438.50,438.50,434.49,436.24,0);
INSERT INTO intraday_data VALUES('$DJUSGT',20070827124000,20070827,124000,354.08,354.08,354.08,354.08,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGT',20070827,355.38,356.60,352.88,354.08,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827124000,20070827,124000,343.46,343.47,343.44,343.44,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.44,0);
INSERT INTO intraday_data VALUES('$DJUSHG',20070827124000,20070827,124000,391.74,391.74,391.74,391.74,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHG',20070827,396.25,396.25,390.28,391.74,0);
INSERT INTO intraday_data VALUES('$DJUSHR',20070827124000,20070827,124000,1070.72,1070.72,1070.72,1070.72,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHR',20070827,1072.75,1075.20,1065.07,1070.72,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827124000,20070827,124000,351.26,351.28,351.26,351.27,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIN',20070827,352.45,352.45,349.76,351.27,0);
INSERT INTO intraday_data VALUES('$DJUSIR',20070827124000,20070827,124000,459.77,459.77,459.77,459.77,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIR',20070827,460.14,460.25,458.36,459.77,0);
INSERT INTO intraday_data VALUES('$DJUSIX',20070827124000,20070827,124000,414.27,414.27,414.27,414.27,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIX',20070827,415.71,415.71,412.57,414.27,0);
INSERT INTO intraday_data VALUES('$DJUSLE',20070827124000,20070827,124000,319.05,319.05,319.05,319.05,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSLE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSLE',20070827,321.54,321.54,317.62,319.05,0);
INSERT INTO intraday_data VALUES('$DJUSMU',20070827124000,20070827,124000,121.09,121.09,121.09,121.09,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.09,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827124000,20070827,124000,309.11,309.13,309.11,309.13,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNC',20070827,309.88,310.14,308.09,309.13,0);
INSERT INTO intraday_data VALUES('$DJUSNS',20070827124000,20070827,124000,395.11,395.11,395.11,395.11,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNS',20070827,392.51,397.17,390.21,395.11,0);
INSERT INTO intraday_data VALUES('$DJUSOL',20070827124000,20070827,124000,544.80,544.80,544.80,544.80,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOL',20070827,547.73,547.73,542.85,544.80,0);
INSERT INTO intraday_data VALUES('$DJUSPG',20070827124000,20070827,124000,265.43,265.43,265.43,265.43,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPG',20070827,268.57,268.57,265.01,265.43,0);
INSERT INTO intraday_data VALUES('$DJUSPL',20070827124000,20070827,124000,510.83,510.83,510.83,510.83,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPL',20070827,519.03,519.03,509.24,510.83,0);
INSERT INTO intraday_data VALUES('$DJUSPP',20070827124000,20070827,124000,147.10,147.10,147.10,147.10,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPP',20070827,145.73,147.10,145.29,147.10,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827124000,20070827,124000,284.41,284.41,284.40,284.41,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.41,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827124000,20070827,124000,406.54,406.62,406.54,406.56,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRH',20070827,410.12,410.12,403.97,406.56,0);
INSERT INTO intraday_data VALUES('$DJUSRP',20070827124000,20070827,124000,222.41,222.41,222.41,222.41,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRP',20070827,223.91,224.11,222.02,222.41,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827124000,20070827,124000,1332.65,1333.10,1332.65,1333.06,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.06,0);
INSERT INTO intraday_data VALUES('$DJUSST',20070827124000,20070827,124000,365.53,365.53,365.53,365.53,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSST',20070827,354.68,370.62,354.68,365.53,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827124000,20070827,124000,613.29,613.38,613.29,613.38,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.38,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827124000,20070827,124000,187.72,187.74,187.69,187.74,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.75,186.26,187.74,0);
INSERT INTO intraday_data VALUES('$DJUSTQ',20070827124000,20070827,124000,594.49,594.49,594.49,594.49,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.49,0);
INSERT INTO intraday_data VALUES('$DJUSTY',20070827124000,20070827,124000,348.66,348.66,348.66,348.66,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTY',20070827,350.78,350.78,346.31,348.66,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827124000,20070827,124000,186.37,186.38,186.37,186.37,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.37,0);
INSERT INTO intraday_data VALUES('$DJUSWC',20070827124000,20070827,124000,404.84,404.84,404.84,404.84,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWC',20070827,402.90,404.84,401.97,404.84,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827124000,20070827,124000,137.43,137.44,137.43,137.44,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.44,0);
INSERT INTO intraday_data VALUES('$IDX',20070827124000,20070827,124000,857.43,857.44,857.43,857.44,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,857.44,0);
INSERT INTO intraday_data VALUES('$INDU',20070827124000,20070827,124000,13353.75,13355.46,13353.67,13354.65,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13377.16,13305.87,13354.65,0);
INSERT INTO intraday_data VALUES('$INX',20070827124000,20070827,124000,1471.42,1471.52,1471.42,1471.52,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1471.52,0);
INSERT INTO intraday_data VALUES('$IUX',20070827124000,20070827,124000,791.14,791.18,791.14,791.18,0);
DELETE FROM eod_data WHERE `ticker` = "$IUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IUX',20070827,797.78,797.78,788.57,791.18,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827124000,20070827,124000,9551.13,9551.68,9551.13,9551.68,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,9551.68,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827124000,20070827,124000,686.48,686.55,686.48,686.55,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,686.55,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827124000,20070827,124000,730.47,730.63,730.47,730.63,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.63,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827124000,20070827,124000,416.78,416.79,416.78,416.79,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.79,0);
INSERT INTO intraday_data VALUES('$VIX',20070827124000,20070827,124000,22.36,22.36,22.32,22.32,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',20070827124000,20070827,124000,10.22,10.22,10.21,10.22,1500);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.13,10.22,690306);
INSERT INTO intraday_data VALUES('AAPL',20070827124000,20070827,124000,133.26,133.26,133.23,133.26,16540);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.26,14470279);
INSERT INTO intraday_data VALUES('ACLI',20070827124000,20070827,124000,24.02,24.04,24.02,24.04,200);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,24.04,293826);
INSERT INTO intraday_data VALUES('ACL',20070827124000,20070827,124000,134.00,134.00,134.00,134.00,400);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,134.00,193400);
INSERT INTO intraday_data VALUES('ADM',20070827124000,20070827,124000,33.00,33.01,32.99,33.00,1900);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.69,33.00,1586615);
INSERT INTO intraday_data VALUES('ADSK',20070827124000,20070827,124000,45.43,45.43,45.42,45.43,650);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.51,44.75,45.43,587862);
INSERT INTO intraday_data VALUES('AET',20070827124000,20070827,124000,50.00,50.02,50.00,50.02,10800);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.09,49.68,50.02,1164500);
INSERT INTO intraday_data VALUES('AIRM',20070827124000,20070827,124000,40.99,40.99,40.98,40.98,300);
DELETE FROM eod_data WHERE `ticker` = "AIRM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AIRM',20070827,41.25,42.09,40.80,40.98,53782);
INSERT INTO intraday_data VALUES('AMD',20070827124000,20070827,124000,12.05,12.06,12.05,12.05,29500);
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,7450775);
INSERT INTO intraday_data VALUES('AMZN',20070827124000,20070827,124000,79.50,79.52,79.48,79.52,6749);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.52,3689529);
INSERT INTO intraday_data VALUES('ANF',20070827124000,20070827,124000,79.54,79.54,79.54,79.54,900);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,79.54,891100);
INSERT INTO intraday_data VALUES('AOB',20070827124000,20070827,124000,9.22,9.22,9.22,9.22,500);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.25,9.03,9.22,524100);
INSERT INTO intraday_data VALUES('APA',20070827124000,20070827,124000,75.39,75.40,75.38,75.40,1400);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.15,75.40,1073700);
INSERT INTO intraday_data VALUES('APH',20070827124000,20070827,124000,35.09,35.10,35.08,35.08,1100);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,35.08,332600);
INSERT INTO intraday_data VALUES('BA',20070827124000,20070827,124000,98.07,98.07,98.03,98.05,1200);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.36,97.13,98.05,1401805);
INSERT INTO intraday_data VALUES('BBY',20070827124000,20070827,124000,43.89,43.90,43.89,43.90,5400);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.81,43.90,1628815);
INSERT INTO intraday_data VALUES('BCSI',20070827124000,20070827,124000,86.80,86.98,86.80,86.96,2400);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,86.96,1382559);
INSERT INTO intraday_data VALUES('BDK',20070827124000,20070827,124000,87.27,87.27,87.27,87.27,100);
DELETE FROM eod_data WHERE `ticker` = "BDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BDK',20070827,87.69,88.27,86.99,87.27,177300);
INSERT INTO intraday_data VALUES('BEN',20070827124000,20070827,124000,133.64,133.64,133.64,133.64,600);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,133.50,133.64,320616);
INSERT INTO intraday_data VALUES('BHI',20070827124000,20070827,124000,80.65,80.69,80.62,80.66,4900);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,79.96,80.66,1145863);
INSERT INTO intraday_data VALUES('BHP',20070827124000,20070827,124000,61.98,62.01,61.94,62.01,1900);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,62.01,708590);
INSERT INTO intraday_data VALUES('BIDU',20070827124000,20070827,124000,210.22,210.34,210.15,210.32,1265);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,211.30,200.55,210.32,2585519);
INSERT INTO intraday_data VALUES('BR',20070827124000,20070827,124000,17.83,17.83,17.82,17.82,500);
DELETE FROM eod_data WHERE `ticker` = "BR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BR',20070827,17.77,17.90,17.63,17.82,237400);
INSERT INTO intraday_data VALUES('CBB',20070827124000,20070827,124000,4.99,4.99,4.98,4.98,200);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,5.00,4.91,4.98,403500);
INSERT INTO intraday_data VALUES('CCJ',20070827124000,20070827,124000,39.95,39.96,39.94,39.96,2100);
DELETE FROM eod_data WHERE `ticker` = "CCJ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CCJ',20070827,40.33,40.49,39.71,39.96,1335262);
INSERT INTO intraday_data VALUES('CEG',20070827124000,20070827,124000,84.06,84.06,84.03,84.03,1100);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.53,84.03,796100);
INSERT INTO intraday_data VALUES('CELG',20070827124000,20070827,124000,59.63,59.64,59.63,59.64,1700);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.78,59.26,59.64,969424);
INSERT INTO intraday_data VALUES('CEPH',20070827124000,20070827,124000,73.37,73.38,73.37,73.38,300);
DELETE FROM eod_data WHERE `ticker` = "CEPH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEPH',20070827,73.75,74.17,73.05,73.38,351897);
INSERT INTO intraday_data VALUES('CERN',20070827124000,20070827,124000,56.50,56.50,56.50,56.50,1100);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.34,56.50,98289);
INSERT INTO intraday_data VALUES('CFC',20070827124000,20070827,124000,20.00,20.01,19.99,20.00,166800);
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,26638391);
INSERT INTO intraday_data VALUES('CHAP',20070827124000,20070827,124000,85.38,85.39,85.38,85.39,1400);
DELETE FROM eod_data WHERE `ticker` = "CHAP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHAP',20070827,85.34,85.43,85.25,85.39,262793);
INSERT INTO intraday_data VALUES('CI',20070827124000,20070827,124000,49.87,49.90,49.86,49.90,4800);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.85,49.90,692592);
INSERT INTO intraday_data VALUES('CMC',20070827124000,20070827,124000,29.27,29.27,29.25,29.25,1500);
DELETE FROM eod_data WHERE `ticker` = "CMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMC',20070827,29.99,29.99,29.07,29.25,458000);
INSERT INTO intraday_data VALUES('CME',20070827124000,20070827,124000,559.30,559.30,559.30,559.30,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.30,176314);
INSERT INTO intraday_data VALUES('CMI',20070827124000,20070827,124000,115.64,115.76,115.64,115.67,1500);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,114.97,115.67,500400);
INSERT INTO intraday_data VALUES('COG',20070827124000,20070827,124000,32.73,32.73,32.73,32.73,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.73,225900);
INSERT INTO intraday_data VALUES('COH',20070827124000,20070827,124000,43.34,43.35,43.34,43.35,3600);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.00,43.35,1864352);
INSERT INTO intraday_data VALUES('COP',20070827124000,20070827,124000,80.78,80.80,80.78,80.79,3800);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,80.87,80.02,80.79,2719200);
INSERT INTO intraday_data VALUES('CRDN',20070827124000,20070827,124000,70.08,70.14,70.08,70.13,700);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.66,70.13,264024);
INSERT INTO intraday_data VALUES('CROX',20070827124000,20070827,124000,60.48,60.55,60.45,60.45,7440);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,60.45,4929029);
INSERT INTO intraday_data VALUES('CRS',20070827124000,20070827,124000,115.80,115.80,115.79,115.79,1300);
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,156500);
INSERT INTO intraday_data VALUES('CSCO',20070827124000,20070827,124000,30.86,30.88,30.86,30.86,57759);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.86,20900132);
INSERT INTO intraday_data VALUES('CTRP',20070827124000,20070827,124000,43.44,43.45,43.40,43.40,2146);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.40,552365);
INSERT INTO intraday_data VALUES('CTSH',20070827124000,20070827,124000,73.71,73.71,73.70,73.70,1200);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,73.70,1002327);
INSERT INTO intraday_data VALUES('CTX',20070827124000,20070827,124000,30.70,30.71,30.68,30.68,5600);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.28,30.68,1628134);
INSERT INTO intraday_data VALUES('CVH',20070827124000,20070827,124000,57.91,57.92,57.89,57.92,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.92,352100);
INSERT INTO intraday_data VALUES('CXW',20070827124000,20070827,124000,25.51,25.52,25.51,25.52,800);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.30,25.52,463100);
INSERT INTO intraday_data VALUES('CX',20070827124000,20070827,124000,31.41,31.42,31.40,31.40,1200);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.20,31.40,1104300);
INSERT INTO intraday_data VALUES('DECK',20070827124000,20070827,124000,94.18,94.27,94.18,94.27,400);
DELETE FROM eod_data WHERE `ticker` = "DECK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DECK',20070827,96.35,96.48,94.00,94.27,127165);
INSERT INTO intraday_data VALUES('DIA',20070827124000,20070827,124000,133.47,133.48,133.47,133.48,1700);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.54,132.98,133.48,3481944);
INSERT INTO intraday_data VALUES('DNA',20070827124000,20070827,124000,73.25,73.27,73.25,73.26,1600);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.05,73.26,582480);
INSERT INTO intraday_data VALUES('DRQ',20070827124000,20070827,124000,44.78,44.82,44.78,44.82,300);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.58,44.82,97800);
INSERT INTO intraday_data VALUES('DRYS',20070827124000,20070827,124000,66.99,67.18,66.97,67.07,6513);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.45,63.16,67.07,1368487);
INSERT INTO intraday_data VALUES('EBAY',20070827124000,20070827,124000,33.65,33.65,33.63,33.63,16762);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.63,3793272);
INSERT INTO intraday_data VALUES('ECA',20070827124000,20070827,124000,58.38,58.40,58.38,58.40,400);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.40,704933);
INSERT INTO intraday_data VALUES('EGY',20070827124000,20070827,124000,3.72,3.73,3.72,3.73,500);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.73,174300);
INSERT INTO intraday_data VALUES('ENR',20070827124000,20070827,124000,108.13,108.13,108.13,108.13,100);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,108.13,335800);
INSERT INTO intraday_data VALUES('EOG',20070827124000,20070827,124000,66.56,66.58,66.56,66.58,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.58,846350);
INSERT INTO intraday_data VALUES('ESRX',20070827124000,20070827,124000,54.72,54.72,54.72,54.72,200);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.72,442484);
INSERT INTO intraday_data VALUES('ESV',20070827124000,20070827,124000,56.93,56.95,56.91,56.92,800);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.54,56.92,707300);
INSERT INTO intraday_data VALUES('FDG',20070827124000,20070827,124000,32.78,32.78,32.77,32.77,400);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.92,32.05,32.77,241875);
INSERT INTO intraday_data VALUES('FFIV',20070827124000,20070827,124000,36.71,36.85,36.71,36.85,6300);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,36.85,482432);
INSERT INTO intraday_data VALUES('FLR',20070827124000,20070827,124000,125.33,125.35,125.32,125.34,1400);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.35,123.02,125.34,479275);
INSERT INTO intraday_data VALUES('FMD',20070827124000,20070827,124000,35.53,35.53,35.53,35.53,100);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.56,35.02,35.53,262900);
INSERT INTO intraday_data VALUES('FRX',20070827124000,20070827,124000,37.25,37.33,37.25,37.31,11600);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.31,1173000);
INSERT INTO intraday_data VALUES('FTI',20070827124000,20070827,124000,90.17,90.17,90.17,90.17,100);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,89.69,90.17,263700);
INSERT INTO intraday_data VALUES('GILD',20070827124000,20070827,124000,36.91,36.91,36.89,36.89,2230);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.75,36.89,1985618);
INSERT INTO intraday_data VALUES('GNA',20070827124000,20070827,124000,11.85,11.85,11.85,11.85,300);
DELETE FROM eod_data WHERE `ticker` = "GNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GNA',20070827,12.07,12.29,11.76,11.85,285400);
INSERT INTO intraday_data VALUES('GOOG',20070827124000,20070827,124000,515.54,515.55,515.08,515.13,2650);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,515.13,1407768);
INSERT INTO intraday_data VALUES('GRA',20070827124000,20070827,124000,21.84,21.85,21.84,21.85,300);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.81,21.85,196900);
INSERT INTO intraday_data VALUES('GRMN',20070827124000,20070827,124000,102.28,102.34,102.23,102.33,3280);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,102.33,1313750);
INSERT INTO intraday_data VALUES('GS',20070827124000,20070827,124000,179.01,179.05,178.95,178.95,4800);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.50,178.95,3683000);
INSERT INTO intraday_data VALUES('GTI',20070827124000,20070827,124000,16.94,16.94,16.85,16.87,15700);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,16.87,1264700);
INSERT INTO intraday_data VALUES('HAL',20070827124000,20070827,124000,33.41,33.42,33.40,33.41,8800);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.23,33.41,5273697);
INSERT INTO intraday_data VALUES('HOC',20070827124000,20070827,124000,65.18,65.18,65.18,65.18,500);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,65.18,389575);
INSERT INTO intraday_data VALUES('HOG',20070827124000,20070827,124000,54.08,54.11,54.08,54.10,2900);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.10,773838);
INSERT INTO intraday_data VALUES('HOV',20070827124000,20070827,124000,11.40,11.42,11.40,11.41,3100);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.30,11.41,1003044);
INSERT INTO intraday_data VALUES('HPC',20070827124000,20070827,124000,21.31,21.33,21.31,21.33,6200);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.27,21.33,553087);
INSERT INTO intraday_data VALUES('HXM',20070827124000,20070827,124000,53.58,53.58,53.53,53.54,600);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.54,131400);
INSERT INTO intraday_data VALUES('IAG',20070827124000,20070827,124000,7.07,7.07,7.07,7.07,1000);
DELETE FROM eod_data WHERE `ticker` = "IAG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IAG',20070827,7.18,7.18,7.01,7.07,505450);
INSERT INTO intraday_data VALUES('IBM',20070827124000,20070827,124000,113.51,113.58,113.50,113.56,7600);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.59,112.80,113.56,1974802);
INSERT INTO intraday_data VALUES('ICE',20070827124000,20070827,124000,140.29,140.29,140.22,140.22,400);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.88,140.22,433000);
INSERT INTO intraday_data VALUES('INFA',20070827124000,20070827,124000,13.75,13.76,13.75,13.75,1900);
DELETE FROM eod_data WHERE `ticker` = "INFA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFA',20070827,13.83,13.85,13.69,13.75,264398);
INSERT INTO intraday_data VALUES('INFY',20070827124000,20070827,124000,46.43,46.45,46.43,46.44,3000);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.30,46.44,592847);
INSERT INTO intraday_data VALUES('JCP',20070827124000,20070827,124000,66.32,66.32,66.29,66.29,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.29,1020800);
INSERT INTO intraday_data VALUES('JEC',20070827124000,20070827,124000,64.16,64.16,64.16,64.16,400);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.85,64.16,253800);
INSERT INTO intraday_data VALUES('JOYG',20070827124000,20070827,124000,48.39,48.42,48.39,48.42,910);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.42,795830);
INSERT INTO intraday_data VALUES('JWN',20070827124000,20070827,124000,48.11,48.14,48.11,48.13,2600);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,48.03,48.13,1495700);
INSERT INTO intraday_data VALUES('KBH',20070827124000,20070827,124000,30.86,30.86,30.83,30.84,1100);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.55,30.84,1176300);
INSERT INTO intraday_data VALUES('KCI',20070827124000,20070827,124000,61.84,61.84,61.83,61.83,1400);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,61.77,61.83,304200);
INSERT INTO intraday_data VALUES('KEP',20070827124000,20070827,124000,22.04,22.06,22.04,22.06,900);
DELETE FROM eod_data WHERE `ticker` = "KEP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KEP',20070827,22.09,22.20,21.86,22.06,178700);
INSERT INTO intraday_data VALUES('KG',20070827124000,20070827,124000,15.67,15.68,15.67,15.67,300);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.71,15.52,15.67,490800);
INSERT INTO intraday_data VALUES('KSS',20070827124000,20070827,124000,57.69,57.70,57.67,57.68,3600);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,57.58,57.68,2064300);
INSERT INTO intraday_data VALUES('LEH',20070827124000,20070827,124000,58.75,58.76,58.73,58.73,2000);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.43,58.73,3893618);
INSERT INTO intraday_data VALUES('LMT',20070827124000,20070827,124000,101.35,101.41,101.35,101.41,3800);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.49,99.12,101.41,920090);
INSERT INTO intraday_data VALUES('LRCX',20070827124000,20070827,124000,53.25,53.27,53.25,53.25,900);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.87,53.25,1080022);
INSERT INTO intraday_data VALUES('LVS',20070827124000,20070827,124000,99.07,99.07,99.07,99.07,200);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,99.07,1638425);
INSERT INTO intraday_data VALUES('MBT',20070827124000,20070827,124000,62.04,62.04,62.04,62.04,100);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.60,61.43,62.04,312300);
INSERT INTO intraday_data VALUES('MCD',20070827124000,20070827,124000,49.49,49.50,49.49,49.50,1900);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.40,49.50,2028712);
INSERT INTO intraday_data VALUES('MDC',20070827124000,20070827,124000,44.26,44.30,44.26,44.30,600);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,44.00,44.30,287000);
INSERT INTO intraday_data VALUES('MFLX',20070827124000,20070827,124000,12.53,12.53,12.53,12.53,100);
DELETE FROM eod_data WHERE `ticker` = "MFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MFLX',20070827,12.79,12.86,12.52,12.53,19469);
INSERT INTO intraday_data VALUES('MGM',20070827124000,20070827,124000,82.63,82.66,82.55,82.66,4600);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.66,583600);
INSERT INTO intraday_data VALUES('MNT',20070827124000,20070827,124000,44.03,44.03,44.03,44.03,100);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.26,43.63,44.03,285359);
INSERT INTO intraday_data VALUES('MOS',20070827124000,20070827,124000,40.66,40.66,40.65,40.66,1400);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.66,988200);
INSERT INTO intraday_data VALUES('MRVL',20070827124000,20070827,124000,15.61,15.62,15.59,15.60,51630);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.60,10625621);
INSERT INTO intraday_data VALUES('MSFT',20070827124000,20070827,124000,28.49,28.50,28.48,28.49,45309);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.40,28.49,11178818);
INSERT INTO intraday_data VALUES('MTW',20070827124000,20070827,124000,76.30,76.32,76.28,76.31,1000);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.31,278800);
INSERT INTO intraday_data VALUES('MT',20070827124000,20070827,124000,63.83,63.83,63.83,63.83,100);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.50,63.83,938260);
INSERT INTO intraday_data VALUES('NEM',20070827124000,20070827,124000,40.72,40.73,40.72,40.73,1600);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.41,40.73,2027300);
INSERT INTO intraday_data VALUES('NEU',20070827124000,20070827,124000,47.25,47.30,47.25,47.30,300);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,46.84,47.30,77300);
INSERT INTO intraday_data VALUES('NFLX',20070827124000,20070827,124000,17.46,17.46,17.46,17.46,200);
DELETE FROM eod_data WHERE `ticker` = "NFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFLX',20070827,17.74,17.85,17.35,17.46,199732);
INSERT INTO intraday_data VALUES('NFX',20070827124000,20070827,124000,43.56,43.57,43.56,43.57,1600);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.28,43.57,578128);
INSERT INTO intraday_data VALUES('NILE',20070827124000,20070827,124000,85.21,85.24,85.18,85.24,1100);
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,107271);
INSERT INTO intraday_data VALUES('NOV',20070827124000,20070827,124000,119.38,119.40,119.34,119.39,800);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,119.39,1051921);
INSERT INTO intraday_data VALUES('NTES',20070827124000,20070827,124000,16.24,16.24,16.23,16.23,1720);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.21,16.23,441254);
INSERT INTO intraday_data VALUES('NUE',20070827124000,20070827,124000,53.80,53.80,53.74,53.74,2800);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.42,53.74,2751166);
INSERT INTO intraday_data VALUES('NVDA',20070827124000,20070827,124000,49.25,49.29,49.25,49.29,8543);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.29,4574978);
INSERT INTO intraday_data VALUES('NWRE',20070827124000,20070827,124000,15.97,15.97,15.97,15.97,500);
DELETE FROM eod_data WHERE `ticker` = "NWRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NWRE',20070827,15.83,15.97,15.83,15.97,109830);
INSERT INTO intraday_data VALUES('NYX',20070827124000,20070827,124000,73.85,73.86,73.85,73.86,1200);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.75,73.86,873772);
INSERT INTO intraday_data VALUES('OCR',20070827124000,20070827,124000,32.97,32.97,32.92,32.92,1300);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.02,32.66,32.92,399600);
INSERT INTO intraday_data VALUES('OGE',20070827124000,20070827,124000,33.10,33.10,33.10,33.10,500);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.87,33.10,177400);
INSERT INTO intraday_data VALUES('OII',20070827124000,20070827,124000,64.55,64.55,64.55,64.55,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.55,132100);
INSERT INTO intraday_data VALUES('ORCL',20070827124000,20070827,124000,19.85,19.86,19.85,19.85,16355);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.85,9404127);
INSERT INTO intraday_data VALUES('OXY',20070827124000,20070827,124000,56.24,56.25,56.22,56.25,1300);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.25,1098200);
INSERT INTO intraday_data VALUES('PBR',20070827124000,20070827,124000,59.12,59.14,59.12,59.12,1500);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.41,58.47,59.12,1492689);
INSERT INTO intraday_data VALUES('PCLN',20070827124000,20070827,124000,80.71,80.71,80.70,80.70,400);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.41,80.70,268617);
INSERT INTO intraday_data VALUES('PCP',20070827124000,20070827,124000,137.87,138.00,137.86,137.92,2400);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.13,137.92,450100);
INSERT INTO intraday_data VALUES('PCR',20070827124000,20070827,124000,55.72,55.72,55.72,55.72,100);
DELETE FROM eod_data WHERE `ticker` = "PCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCR',20070827,56.99,57.96,54.84,55.72,232900);
INSERT INTO intraday_data VALUES('PCU',20070827124000,20070827,124000,102.54,102.61,102.54,102.61,2000);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,102.61,1037773);
INSERT INTO intraday_data VALUES('PETS',20070827124000,20070827,124000,15.47,15.47,15.47,15.47,1000);
DELETE FROM eod_data WHERE `ticker` = "PETS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PETS',20070827,15.60,15.67,15.33,15.47,105569);
INSERT INTO intraday_data VALUES('PMTI',20070827124000,20070827,124000,30.55,30.55,30.55,30.55,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.55,60890);
INSERT INTO intraday_data VALUES('PNK',20070827124000,20070827,124000,27.30,27.30,27.30,27.30,100);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.33,26.85,27.30,130600);
INSERT INTO intraday_data VALUES('POT',20070827124000,20070827,124000,85.45,85.45,85.45,85.45,3400);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.36,85.45,751125);
INSERT INTO intraday_data VALUES('PRST',20070827124000,20070827,124000,6.47,6.47,6.45,6.45,1857);
DELETE FROM eod_data WHERE `ticker` = "PRST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRST',20070827,6.52,6.66,6.45,6.45,55702);
INSERT INTO intraday_data VALUES('PTNR',20070827124000,20070827,124000,15.34,15.34,15.34,15.34,100);
DELETE FROM eod_data WHERE `ticker` = "PTNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PTNR',20070827,15.30,15.43,15.25,15.34,134598);
INSERT INTO intraday_data VALUES('QDEL',20070827124000,20070827,124000,17.25,17.26,17.25,17.26,600);
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,108577);
INSERT INTO intraday_data VALUES('QQQQ',20070827124000,20070827,124000,48.00,48.01,48.00,48.01,21047);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,48.01,34467749);
INSERT INTO intraday_data VALUES('RAI',20070827124000,20070827,124000,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,396500);
INSERT INTO intraday_data VALUES('REXI',20070827124000,20070827,124000,15.84,15.84,15.84,15.84,200);
DELETE FROM eod_data WHERE `ticker` = "REXI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('REXI',20070827,16.24,16.37,15.67,15.84,64228);
INSERT INTO intraday_data VALUES('RIG',20070827124000,20070827,124000,102.50,102.56,102.49,102.56,2900);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.54,102.56,1775933);
INSERT INTO intraday_data VALUES('RIMM',20070827124000,20070827,124000,81.14,81.14,81.10,81.11,4979);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,81.11,3358180);
INSERT INTO intraday_data VALUES('RIO',20070827124000,20070827,124000,47.50,47.53,47.50,47.50,4200);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.93,47.09,47.50,5877263);
INSERT INTO intraday_data VALUES('RL',20070827124000,20070827,124000,76.70,76.70,76.64,76.66,1800);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.59,76.66,498100);
INSERT INTO intraday_data VALUES('RMD',20070827124000,20070827,124000,41.72,41.72,41.72,41.72,100);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.33,41.72,224805);
INSERT INTO intraday_data VALUES('RTP',20070827124000,20070827,124000,273.86,273.86,273.86,273.86,100);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,273.86,167000);
INSERT INTO intraday_data VALUES('RYL',20070827124000,20070827,124000,30.50,30.50,30.50,30.50,700);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.25,30.50,662381);
INSERT INTO intraday_data VALUES('SBGI',20070827124000,20070827,124000,12.41,12.41,12.40,12.40,1100);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.39,12.40,488518);
INSERT INTO intraday_data VALUES('SBUX',20070827124000,20070827,124000,27.45,27.46,27.45,27.46,13363);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.46,1748911);
INSERT INTO intraday_data VALUES('SCI',20070827124000,20070827,124000,12.02,12.02,12.01,12.01,500);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,11.96,12.01,625800);
INSERT INTO intraday_data VALUES('SCUR',20070827124000,20070827,124000,8.30,8.30,8.30,8.30,800);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.23,8.30,247059);
INSERT INTO intraday_data VALUES('SID',20070827124000,20070827,124000,53.60,53.60,53.60,53.60,100);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.67,53.60,565500);
INSERT INTO intraday_data VALUES('SII',20070827124000,20070827,124000,62.42,62.43,62.40,62.40,1300);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.02,62.40,647100);
INSERT INTO intraday_data VALUES('SIMG',20070827124000,20070827,124000,5.86,5.86,5.86,5.86,200);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.86,351875);
INSERT INTO intraday_data VALUES('SKX',20070827124000,20070827,124000,19.94,19.96,19.94,19.96,400);
DELETE FROM eod_data WHERE `ticker` = "SKX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SKX',20070827,20.10,20.10,19.81,19.96,196300);
INSERT INTO intraday_data VALUES('SLB',20070827124000,20070827,124000,92.86,92.89,92.84,92.84,2400);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.03,92.84,2201900);
INSERT INTO intraday_data VALUES('SNDK',20070827124000,20070827,124000,52.41,52.43,52.41,52.43,10560);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.11,52.43,4452740);
INSERT INTO intraday_data VALUES('SNE',20070827124000,20070827,124000,46.42,46.42,46.42,46.42,300);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.42,264686);
INSERT INTO intraday_data VALUES('SPG',20070827124000,20070827,124000,93.23,93.23,93.23,93.23,200);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,93.23,362500);
INSERT INTO intraday_data VALUES('SPWR',20070827124000,20070827,124000,62.27,62.27,62.24,62.24,418);
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,465356);
INSERT INTO intraday_data VALUES('SPY',20070827124000,20070827,124000,147.39,147.41,147.39,147.41,63200);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,146.97,147.41,47458163);
INSERT INTO intraday_data VALUES('STEC',20070827124000,20070827,124000,7.59,7.59,7.59,7.59,100);
DELETE FROM eod_data WHERE `ticker` = "STEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STEC',20070827,7.61,7.64,7.53,7.59,55155);
INSERT INTO intraday_data VALUES('STLD',20070827124000,20070827,124000,43.48,43.49,43.48,43.49,700);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.49,569088);
INSERT INTO intraday_data VALUES('STR',20070827124000,20070827,124000,49.67,49.67,49.63,49.63,800);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.29,49.63,484000);
INSERT INTO intraday_data VALUES('SWKS',20070827124000,20070827,124000,7.67,7.68,7.67,7.68,1300);
DELETE FROM eod_data WHERE `ticker` = "SWKS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWKS',20070827,7.88,7.95,7.67,7.68,748029);
INSERT INTO intraday_data VALUES('SWN',20070827124000,20070827,124000,37.54,37.56,37.53,37.53,900);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.53,833700);
INSERT INTO intraday_data VALUES('SYKE',20070827124000,20070827,124000,16.63,16.63,16.63,16.63,500);
DELETE FROM eod_data WHERE `ticker` = "SYKE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYKE',20070827,16.96,16.96,16.55,16.63,43414);
INSERT INTO intraday_data VALUES('SYK',20070827124000,20070827,124000,67.41,67.41,67.41,67.41,100);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.11,67.41,308132);
INSERT INTO intraday_data VALUES('TDW',20070827124000,20070827,124000,64.96,64.96,64.94,64.94,200);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.25,64.45,64.94,467015);
INSERT INTO intraday_data VALUES('TECH',20070827124000,20070827,124000,62.62,62.64,62.62,62.64,400);
DELETE FROM eod_data WHERE `ticker` = "TECH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TECH',20070827,62.17,62.85,62.12,62.64,57852);
INSERT INTO intraday_data VALUES('TEX',20070827124000,20070827,124000,78.88,78.88,78.83,78.85,2200);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,77.82,78.85,510100);
INSERT INTO intraday_data VALUES('TLM',20070827124000,20070827,124000,17.00,17.00,16.99,16.99,400);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.95,16.99,820700);
INSERT INTO intraday_data VALUES('TNB',20070827124000,20070827,124000,55.62,55.62,55.60,55.60,700);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.60,220400);
INSERT INTO intraday_data VALUES('TOL',20070827124000,20070827,124000,22.33,22.34,22.32,22.34,1800);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.17,22.34,2258866);
INSERT INTO intraday_data VALUES('TRMB',20070827124000,20070827,124000,36.49,36.49,36.49,36.49,50000);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.49,345208);
INSERT INTO intraday_data VALUES('TSN',20070827124000,20070827,124000,21.25,21.25,21.25,21.25,1800);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.22,21.25,615105);
INSERT INTO intraday_data VALUES('TSO',20070827124000,20070827,124000,49.35,49.35,49.35,49.35,100);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.35,1146700);
INSERT INTO intraday_data VALUES('TS',20070827124000,20070827,124000,46.60,46.63,46.60,46.63,3300);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.63,1394900);
INSERT INTO intraday_data VALUES('TXU',20070827124000,20070827,124000,65.80,65.82,65.75,65.77,14600);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.73,65.77,2902000);
INSERT INTO intraday_data VALUES('UA',20070827124000,20070827,124000,64.51,64.53,64.38,64.38,1500);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,64.38,425800);
INSERT INTO intraday_data VALUES('UNH',20070827124000,20070827,124000,49.48,49.49,49.48,49.48,1100);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.38,49.48,1786680);
INSERT INTO intraday_data VALUES('UPL',20070827124000,20070827,124000,54.66,54.69,54.66,54.67,300);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.67,385000);
INSERT INTO intraday_data VALUES('URBN',20070827124000,20070827,124000,22.80,22.81,22.80,22.81,4320);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.81,1153207);
INSERT INTO intraday_data VALUES('VIP',20070827124000,20070827,124000,22.39,22.39,22.39,22.39,200);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.08,22.39,836330);
INSERT INTO intraday_data VALUES('VIVO',20070827124000,20070827,124000,25.18,25.18,25.18,25.18,100);
DELETE FROM eod_data WHERE `ticker` = "VIVO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIVO',20070827,25.53,25.54,25.03,25.18,41760);
INSERT INTO intraday_data VALUES('VLO',20070827124000,20070827,124000,67.26,67.29,67.26,67.29,4700);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.29,2283894);
INSERT INTO intraday_data VALUES('VSEA',20070827124000,20070827,124000,55.60,55.66,55.60,55.66,1100);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,56.58,54.53,55.66,1273015);
INSERT INTO intraday_data VALUES('WBSN',20070827124000,20070827,124000,20.50,20.50,20.50,20.50,200);
DELETE FROM eod_data WHERE `ticker` = "WBSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WBSN',20070827,20.73,20.91,20.44,20.50,62109);
INSERT INTO intraday_data VALUES('WCC',20070827124000,20070827,124000,48.19,48.19,48.14,48.16,2800);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,47.93,48.16,206694);
INSERT INTO intraday_data VALUES('WDC',20070827124000,20070827,124000,22.09,22.12,22.09,22.10,4000);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.77,22.10,1043200);
INSERT INTO intraday_data VALUES('WFMI',20070827124000,20070827,124000,45.59,45.59,45.58,45.58,1200);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.58,1796416);
INSERT INTO intraday_data VALUES('WFR',20070827124000,20070827,124000,58.60,58.60,58.57,58.57,600);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.30,58.57,581400);
INSERT INTO intraday_data VALUES('WFT',20070827124000,20070827,124000,55.76,55.77,55.76,55.77,1000);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.45,55.77,1211400);
INSERT INTO intraday_data VALUES('WLP',20070827124000,20070827,124000,78.49,78.51,78.48,78.51,2600);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.54,77.89,78.51,1063000);
INSERT INTO intraday_data VALUES('WNR',20070827124000,20070827,124000,52.20,52.20,52.20,52.20,300);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,52.20,416000);
INSERT INTO intraday_data VALUES('XING',20070827124000,20070827,124000,9.16,9.16,9.16,9.16,100);
DELETE FROM eod_data WHERE `ticker` = "XING" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('XING',20070827,8.98,9.38,8.83,9.16,244045);
INSERT INTO intraday_data VALUES('X',20070827124000,20070827,124000,94.38,94.47,94.25,94.26,18100);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,94.26,1712804);
INSERT INTO intraday_data VALUES('YHOO',20070827124000,20070827,124000,23.25,23.25,23.24,23.25,3010);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.20,23.25,6811096);