INSERT INTO intraday_data VALUES('$COMPX',20070827121900,20070827,121900,2562.44,2562.63,2562.43,2562.63,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2562.63,0);
INSERT INTO intraday_data VALUES('$DJUSAI',20070827121900,20070827,121900,220.51,220.51,220.51,220.51,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAI',20070827,221.28,221.28,219.58,220.51,0);
INSERT INTO intraday_data VALUES('$DJUSAR',20070827121900,20070827,121900,120.36,120.36,120.36,120.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAR',20070827,122.46,122.46,120.03,120.36,0);
INSERT INTO intraday_data VALUES('$DJUSAT',20070827121900,20070827,121900,255.20,255.20,255.20,255.20,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAT',20070827,256.29,256.29,254.39,255.20,0);
INSERT INTO intraday_data VALUES('$DJUSBE',20070827121900,20070827,121900,125.65,125.65,125.65,125.65,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.65,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827121900,20070827,121900,270.52,270.57,270.52,270.57,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.57,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827121900,20070827,121900,335.34,335.38,335.34,335.38,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.38,0);
INSERT INTO intraday_data VALUES('$DJUSDN',20070827121900,20070827,121900,147.31,147.31,147.31,147.31,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDN',20070827,147.34,147.34,146.73,147.31,0);
INSERT INTO intraday_data VALUES('$DJUSDS',20070827121900,20070827,121900,142.64,142.64,142.64,142.64,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDS',20070827,142.84,143.32,142.18,142.64,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827121900,20070827,121900,594.22,594.45,594.22,594.45,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.45,0);
INSERT INTO intraday_data VALUES('$DJUSEU',20070827121900,20070827,121900,197.77,197.77,197.77,197.77,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEU',20070827,200.33,203.14,197.54,197.77,0);
INSERT INTO intraday_data VALUES('$DJUSFC',20070827121900,20070827,121900,179.89,179.89,179.89,179.89,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.89,0);
INSERT INTO intraday_data VALUES('$DJUSFI',20070827121900,20070827,121900,658.39,658.39,658.39,658.39,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.39,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827121900,20070827,121900,548.08,548.11,548.08,548.11,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.11,0);
INSERT INTO intraday_data VALUES('$DJUSGF',20070827121900,20070827,121900,797.59,797.59,797.59,797.59,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.59,0);
INSERT INTO intraday_data VALUES('$DJUSGI',20070827121900,20070827,121900,435.91,435.91,435.91,435.91,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGI',20070827,438.50,438.50,434.49,435.91,0);
INSERT INTO intraday_data VALUES('$DJUSGT',20070827121900,20070827,121900,353.76,353.76,353.76,353.76,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGT',20070827,355.38,356.60,352.88,353.76,0);
INSERT INTO intraday_data VALUES('$DJUSGU',20070827121900,20070827,121900,117.88,117.88,117.88,117.88,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGU',20070827,120.00,120.00,117.49,117.88,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827121900,20070827,121900,343.55,343.57,343.55,343.57,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.57,0);
INSERT INTO intraday_data VALUES('$DJUSHD',20070827121900,20070827,121900,142.58,142.58,142.58,142.58,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHD',20070827,143.24,143.33,142.09,142.58,0);
INSERT INTO intraday_data VALUES('$DJUSHG',20070827121900,20070827,121900,391.82,391.82,391.82,391.82,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.82,0);
INSERT INTO intraday_data VALUES('$DJUSIF',20070827121900,20070827,121900,452.26,452.26,452.26,452.26,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIF',20070827,454.00,454.00,450.76,452.26,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827121900,20070827,121900,350.80,350.86,350.80,350.86,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.86,0);
INSERT INTO intraday_data VALUES('$DJUSIV',20070827121900,20070827,121900,219.23,219.23,219.23,219.23,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIV',20070827,219.65,219.65,218.57,219.23,0);
INSERT INTO intraday_data VALUES('$DJUSIX',20070827121900,20070827,121900,414.42,414.42,414.42,414.42,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.42,0);
INSERT INTO intraday_data VALUES('$DJUSLE',20070827121900,20070827,121900,318.94,318.94,318.94,318.94,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSLE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSLE',20070827,321.54,321.54,317.62,318.94,0);
INSERT INTO intraday_data VALUES('$DJUSLG',20070827121900,20070827,121900,729.80,729.80,729.80,729.80,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSLG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSLG',20070827,735.87,735.87,726.50,729.80,0);
INSERT INTO intraday_data VALUES('$DJUSMU',20070827121900,20070827,121900,120.96,120.96,120.96,120.96,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMU',20070827,123.48,123.48,120.79,120.96,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827121900,20070827,121900,309.13,309.15,309.13,309.15,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.15,0);
INSERT INTO intraday_data VALUES('$DJUSOG',20070827121900,20070827,121900,564.93,564.93,564.93,564.93,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOG',20070827,560.07,570.20,552.48,564.93,0);
INSERT INTO intraday_data VALUES('$DJUSPG',20070827121900,20070827,121900,265.58,265.58,265.58,265.58,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.58,0);
INSERT INTO intraday_data VALUES('$DJUSRD',20070827121900,20070827,121900,545.17,545.17,545.17,545.17,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRD',20070827,545.07,545.78,543.90,545.17,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827121900,20070827,121900,283.89,283.92,283.89,283.92,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRE',20070827,287.10,287.12,282.50,283.92,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827121900,20070827,121900,405.62,405.62,405.40,405.40,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.40,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827121900,20070827,121900,116.02,116.02,116.02,116.02,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.02,0);
INSERT INTO intraday_data VALUES('$DJUSRS',20070827121900,20070827,121900,444.55,444.55,444.55,444.55,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRS',20070827,440.38,450.76,440.16,444.55,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827121900,20070827,121900,1332.97,1333.24,1332.95,1333.24,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.24,0);
INSERT INTO intraday_data VALUES('$DJUSSP',20070827121900,20070827,121900,108.50,108.50,108.50,108.50,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSP',20070827,108.46,109.00,108.22,108.50,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827121900,20070827,121900,612.84,612.88,612.82,612.88,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,611.64,612.88,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827121900,20070827,121900,187.28,187.32,187.27,187.32,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.42,186.26,187.32,0);
INSERT INTO intraday_data VALUES('$DJUSTQ',20070827121900,20070827,121900,594.16,594.16,594.16,594.16,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.16,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827121900,20070827,121900,186.49,186.49,186.43,186.46,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.46,0);
INSERT INTO intraday_data VALUES('$DJUSWU',20070827121900,20070827,121900,769.53,769.53,769.53,769.53,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWU',20070827,774.49,781.10,765.90,769.53,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827121900,20070827,121900,137.32,137.34,137.31,137.34,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.34,0);
INSERT INTO intraday_data VALUES('$IDX',20070827121900,20070827,121900,856.45,856.52,856.45,856.52,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.52,0);
INSERT INTO intraday_data VALUES('$INDU',20070827121900,20070827,121900,13347.90,13350.26,13347.49,13350.18,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13377.16,13305.87,13350.18,0);
INSERT INTO intraday_data VALUES('$INX',20070827121900,20070827,121900,1470.87,1470.99,1470.86,1470.99,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.99,0);
INSERT INTO intraday_data VALUES('$IUX',20070827121900,20070827,121900,790.22,790.28,790.21,790.28,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.28,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827121900,20070827,121900,9546.00,9546.95,9546.00,9546.95,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,9546.95,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827121900,20070827,121900,686.11,686.18,686.10,686.18,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.18,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827121900,20070827,121900,729.82,729.98,729.82,729.98,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.98,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827121900,20070827,121900,416.24,416.27,416.23,416.27,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.27,0);
INSERT INTO intraday_data VALUES('$VIX',20070827121900,20070827,121900,22.37,22.37,22.35,22.35,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',20070827121900,20070827,121900,10.21,10.21,10.21,10.21,500);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.13,10.21,658306);
INSERT INTO intraday_data VALUES('AAPL',20070827121900,20070827,121900,133.21,133.27,133.20,133.27,29286);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.27,13735509);
INSERT INTO intraday_data VALUES('ACLI',20070827121900,20070827,121900,23.94,23.94,23.94,23.94,100);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,23.94,267338);
INSERT INTO intraday_data VALUES('ACL',20070827121900,20070827,121900,134.02,134.05,134.00,134.05,5700);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,134.05,177200);
INSERT INTO intraday_data VALUES('ADSK',20070827121900,20070827,121900,45.41,45.43,45.39,45.43,1900);
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,529297);
INSERT INTO intraday_data VALUES('ADS',20070827121900,20070827,121900,76.52,76.52,76.52,76.52,100);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.43,76.52,264000);
INSERT INTO intraday_data VALUES('AET',20070827121900,20070827,121900,50.00,50.01,50.00,50.00,20600);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.09,49.68,50.00,1018800);
INSERT INTO intraday_data VALUES('AIRM',20070827121900,20070827,121900,41.11,41.11,41.11,41.11,100);
DELETE FROM eod_data WHERE `ticker` = "AIRM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AIRM',20070827,41.25,42.09,40.80,41.11,50082);
INSERT INTO intraday_data VALUES('ALB',20070827121900,20070827,121900,38.32,38.33,38.32,38.32,300);
DELETE FROM eod_data WHERE `ticker` = "ALB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ALB',20070827,38.51,38.60,37.97,38.32,263200);
INSERT INTO intraday_data VALUES('AMD',20070827121900,20070827,121900,11.99,12.00,11.99,11.99,18000);
DELETE FROM eod_data WHERE `ticker` = "AMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMD',20070827,12.08,12.25,11.96,11.99,6708675);
INSERT INTO intraday_data VALUES('AMTD',20070827121900,20070827,121900,17.59,17.59,17.59,17.59,100);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.65,17.40,17.59,1011354);
INSERT INTO intraday_data VALUES('AMX',20070827121900,20070827,121900,60.50,60.51,60.50,60.50,1200);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.74,60.06,60.50,1418600);
INSERT INTO intraday_data VALUES('AMZN',20070827121900,20070827,121900,79.59,79.61,79.57,79.57,10438);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.57,3461330);
INSERT INTO intraday_data VALUES('ANF',20070827121900,20070827,121900,79.43,79.57,79.43,79.57,5500);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,79.57,853600);
INSERT INTO intraday_data VALUES('APA',20070827121900,20070827,121900,75.32,75.33,75.31,75.33,1200);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.15,75.33,994700);
INSERT INTO intraday_data VALUES('APH',20070827121900,20070827,121900,35.11,35.15,35.10,35.15,2500);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,35.15,303200);
INSERT INTO intraday_data VALUES('ARLP',20070827121900,20070827,121900,33.88,33.90,33.88,33.90,200);
DELETE FROM eod_data WHERE `ticker` = "ARLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ARLP',20070827,34.05,34.23,33.50,33.90,23107);
INSERT INTO intraday_data VALUES('BA',20070827121900,20070827,121900,97.88,97.90,97.86,97.88,3200);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.36,97.13,97.88,1270805);
INSERT INTO intraday_data VALUES('BBY',20070827121900,20070827,121900,43.89,43.91,43.89,43.91,3000);
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,1516915);
INSERT INTO intraday_data VALUES('BCSI',20070827121900,20070827,121900,86.79,86.89,86.70,86.74,4000);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,86.74,1312684);
INSERT INTO intraday_data VALUES('BDK',20070827121900,20070827,121900,87.26,87.26,87.26,87.26,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.26,166200);
INSERT INTO intraday_data VALUES('BEN',20070827121900,20070827,121900,133.80,133.80,133.80,133.80,300);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,133.50,133.80,303800);
INSERT INTO intraday_data VALUES('BG',20070827121900,20070827,121900,88.12,88.12,88.12,88.12,100);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,88.12,87.03,88.12,205300);
INSERT INTO intraday_data VALUES('BHI',20070827121900,20070827,121900,80.30,80.34,80.28,80.32,3100);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,79.96,80.32,1082863);
INSERT INTO intraday_data VALUES('BHP',20070827121900,20070827,121900,61.99,62.01,61.99,62.01,300);
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,660190);
INSERT INTO intraday_data VALUES('BNI',20070827121900,20070827,121900,80.49,80.50,80.49,80.50,2600);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,80.83,79.68,80.50,4202232);
INSERT INTO intraday_data VALUES('BRCD',20070827121900,20070827,121900,7.06,7.06,7.05,7.05,1200);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,7.02,7.05,3667931);
INSERT INTO intraday_data VALUES('BRY',20070827121900,20070827,121900,33.41,33.41,33.41,33.41,300);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.34,33.41,70900);
INSERT INTO intraday_data VALUES('BR',20070827121900,20070827,121900,17.87,17.87,17.87,17.87,200);
DELETE FROM eod_data WHERE `ticker` = "BR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BR',20070827,17.77,17.90,17.63,17.87,217100);
INSERT INTO intraday_data VALUES('BTU',20070827121900,20070827,121900,41.42,41.46,41.42,41.45,2700);
DELETE FROM eod_data WHERE `ticker` = "BTU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BTU',20070827,42.44,42.56,41.19,41.45,1665992);
INSERT INTO intraday_data VALUES('BZH',20070827121900,20070827,121900,9.76,9.77,9.75,9.75,3400);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.75,1176200);
INSERT INTO intraday_data VALUES('CAM',20070827121900,20070827,121900,77.38,77.39,77.37,77.39,900);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.39,395200);
INSERT INTO intraday_data VALUES('CBB',20070827121900,20070827,121900,4.98,4.98,4.98,4.98,2200);
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,376100);
INSERT INTO intraday_data VALUES('CCJ',20070827121900,20070827,121900,39.86,39.90,39.86,39.89,5000);
DELETE FROM eod_data WHERE `ticker` = "CCJ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CCJ',20070827,40.33,40.49,39.71,39.89,1268762);
INSERT INTO intraday_data VALUES('CEG',20070827121900,20070827,121900,83.80,83.80,83.75,83.75,1800);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.75,83.75,720700);
INSERT INTO intraday_data VALUES('CELG',20070827121900,20070827,121900,59.51,59.56,59.51,59.56,3795);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.78,59.26,59.56,892981);
INSERT INTO intraday_data VALUES('CEPH',20070827121900,20070827,121900,73.16,73.21,73.16,73.21,2933);
DELETE FROM eod_data WHERE `ticker` = "CEPH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEPH',20070827,73.75,74.17,73.05,73.21,335667);
INSERT INTO intraday_data VALUES('CERN',20070827121900,20070827,121900,56.50,56.50,56.50,56.50,545);
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,86965);
INSERT INTO intraday_data VALUES('CFC',20070827121900,20070827,121900,19.99,20.00,19.98,20.00,20600);
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,25629491);
INSERT INTO intraday_data VALUES('CHINA',20070827121900,20070827,121900,8.41,8.41,8.39,8.40,7400);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.47,8.20,8.40,462962);
INSERT INTO intraday_data VALUES('CHRW',20070827121900,20070827,121900,49.04,49.05,49.04,49.05,417);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.05,217949);
INSERT INTO intraday_data VALUES('CI',20070827121900,20070827,121900,49.96,49.97,49.92,49.92,2400);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.87,49.92,638092);
INSERT INTO intraday_data VALUES('CMC',20070827121900,20070827,121900,29.23,29.27,29.23,29.25,3200);
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,434700);
INSERT INTO intraday_data VALUES('CME',20070827121900,20070827,121900,559.33,559.42,559.18,559.42,500);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.80,556.00,559.42,165914);
INSERT INTO intraday_data VALUES('CMI',20070827121900,20070827,121900,115.23,115.23,115.23,115.23,100);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,114.97,115.23,480400);
INSERT INTO intraday_data VALUES('CNH',20070827121900,20070827,121900,48.96,48.96,48.96,48.96,300);
DELETE FROM eod_data WHERE `ticker` = "CNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CNH',20070827,49.67,50.35,48.87,48.96,115800);
INSERT INTO intraday_data VALUES('COG',20070827121900,20070827,121900,32.74,32.74,32.73,32.73,300);
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,214900);
INSERT INTO intraday_data VALUES('COH',20070827121900,20070827,121900,43.31,43.33,43.31,43.33,2200);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.00,43.33,1768652);
INSERT INTO intraday_data VALUES('COP',20070827121900,20070827,121900,80.74,80.79,80.73,80.79,9700);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,80.82,80.02,80.79,2484200);
INSERT INTO intraday_data VALUES('CRI',20070827121900,20070827,121900,20.16,20.26,20.16,20.25,12400);
DELETE FROM eod_data WHERE `ticker` = "CRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRI',20070827,20.56,20.56,19.92,20.25,269400);
INSERT INTO intraday_data VALUES('CROX',20070827121900,20070827,121900,60.49,60.65,60.44,60.57,50497);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,60.57,4647431);
INSERT INTO intraday_data VALUES('CSCO',20070827121900,20070827,121900,30.89,30.89,30.85,30.85,118148);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.85,19726193);
INSERT INTO intraday_data VALUES('CTRP',20070827121900,20070827,121900,43.36,43.37,43.36,43.37,200);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.37,532833);
INSERT INTO intraday_data VALUES('CTSH',20070827121900,20070827,121900,73.56,73.56,73.55,73.56,2935);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,73.56,947575);
INSERT INTO intraday_data VALUES('CTX',20070827121900,20070827,121900,30.59,30.60,30.58,30.60,3600);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.28,30.60,1532634);
INSERT INTO intraday_data VALUES('CVH',20070827121900,20070827,121900,58.00,58.00,58.00,58.00,700);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,58.00,326700);
INSERT INTO intraday_data VALUES('CXW',20070827121900,20070827,121900,25.38,25.38,25.38,25.38,100);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.30,25.38,443200);
INSERT INTO intraday_data VALUES('CX',20070827121900,20070827,121900,31.33,31.37,31.33,31.36,12200);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.20,31.36,1021400);
INSERT INTO intraday_data VALUES('DAVE',20070827121900,20070827,121900,19.70,19.70,19.51,19.62,1900);
DELETE FROM eod_data WHERE `ticker` = "DAVE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DAVE',20070827,19.20,19.80,19.14,19.62,22274);
INSERT INTO intraday_data VALUES('DIA',20070827121900,20070827,121900,133.39,133.42,133.39,133.42,14000);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.54,132.98,133.42,3307544);
INSERT INTO intraday_data VALUES('DNA',20070827121900,20070827,121900,73.30,73.30,73.26,73.28,2200);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.05,73.28,538500);
INSERT INTO intraday_data VALUES('DRIV',20070827121900,20070827,121900,44.73,44.75,44.73,44.75,300);
DELETE FROM eod_data WHERE `ticker` = "DRIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRIV',20070827,44.64,44.99,44.45,44.75,97440);
INSERT INTO intraday_data VALUES('DRYS',20070827121900,20070827,121900,66.41,66.53,66.41,66.53,2291);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.45,63.16,66.53,1288291);
INSERT INTO intraday_data VALUES('DVR',20070827121900,20070827,121900,14.44,14.45,14.44,14.45,1300);
DELETE FROM eod_data WHERE `ticker` = "DVR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DVR',20070827,14.68,14.68,14.37,14.45,184000);
INSERT INTO intraday_data VALUES('EBAY',20070827121900,20070827,121900,33.81,33.83,33.81,33.83,6843);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.83,3503503);
INSERT INTO intraday_data VALUES('ECA',20070827121900,20070827,121900,58.43,58.43,58.39,58.40,13900);
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,655833);
INSERT INTO intraday_data VALUES('ENR',20070827121900,20070827,121900,108.22,108.37,108.22,108.37,1200);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,108.37,317800);
INSERT INTO intraday_data VALUES('EOG',20070827121900,20070827,121900,66.57,66.61,66.55,66.60,3000);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.60,777550);
INSERT INTO intraday_data VALUES('ESRX',20070827121900,20070827,121900,54.73,54.74,54.73,54.74,300);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.74,396719);
INSERT INTO intraday_data VALUES('ESV',20070827121900,20070827,121900,56.72,56.75,56.72,56.75,700);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.54,56.75,671200);
INSERT INTO intraday_data VALUES('EXPD',20070827121900,20070827,121900,45.22,45.24,45.20,45.24,500);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.69,45.01,45.24,278187);
INSERT INTO intraday_data VALUES('EXP',20070827121900,20070827,121900,38.19,38.25,38.19,38.25,1600);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.03,38.25,274600);
INSERT INTO intraday_data VALUES('FDG',20070827121900,20070827,121900,32.87,32.87,32.87,32.87,100);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.92,32.05,32.87,226675);
INSERT INTO intraday_data VALUES('FFIV',20070827121900,20070827,121900,36.68,36.68,36.64,36.66,1700);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,36.66,447271);
INSERT INTO intraday_data VALUES('FLR',20070827121900,20070827,121900,124.50,124.50,124.45,124.48,1100);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.25,123.02,124.48,448975);
INSERT INTO intraday_data VALUES('FMD',20070827121900,20070827,121900,35.45,35.45,35.45,35.45,900);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.45,35.02,35.45,250000);
INSERT INTO intraday_data VALUES('FRK',20070827121900,20070827,121900,62.01,62.01,62.01,62.01,100);
DELETE FROM eod_data WHERE `ticker` = "FRK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRK',20070827,62.83,62.99,62.00,62.01,71300);
INSERT INTO intraday_data VALUES('FRX',20070827121900,20070827,121900,37.17,37.18,37.17,37.17,3600);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.17,1054300);
INSERT INTO intraday_data VALUES('FTI',20070827121900,20070827,121900,89.90,89.94,89.90,89.94,400);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,89.69,89.94,253200);
INSERT INTO intraday_data VALUES('GES',20070827121900,20070827,121900,49.35,49.40,49.35,49.40,1500);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.27,49.40,337793);
INSERT INTO intraday_data VALUES('GGB',20070827121900,20070827,121900,22.92,22.92,22.91,22.91,600);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,22.91,695500);
INSERT INTO intraday_data VALUES('GILD',20070827121900,20070827,121900,36.95,36.95,36.93,36.93,3500);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.75,36.93,1833178);
INSERT INTO intraday_data VALUES('GOOG',20070827121900,20070827,121900,514.50,514.69,514.50,514.51,2720);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,514.51,1317740);
INSERT INTO intraday_data VALUES('GRA',20070827121900,20070827,121900,21.98,21.98,21.98,21.98,300);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.84,21.98,188000);
INSERT INTO intraday_data VALUES('GRMN',20070827121900,20070827,121900,102.01,102.10,102.01,102.10,2588);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,102.10,1245572);
INSERT INTO intraday_data VALUES('GS',20070827121900,20070827,121900,178.70,178.81,178.70,178.80,18000);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.50,178.80,3305400);
INSERT INTO intraday_data VALUES('GTI',20070827121900,20070827,121900,16.98,16.99,16.98,16.98,3700);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,16.98,1157500);
INSERT INTO intraday_data VALUES('HAL',20070827121900,20070827,121900,33.25,33.29,33.25,33.29,11900);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.23,33.29,4542652);
INSERT INTO intraday_data VALUES('HNR',20070827121900,20070827,121900,11.05,11.05,11.04,11.04,600);
DELETE FROM eod_data WHERE `ticker` = "HNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HNR',20070827,11.19,11.25,11.01,11.04,79700);
INSERT INTO intraday_data VALUES('HOC',20070827121900,20070827,121900,64.95,64.95,64.90,64.90,1300);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,64.90,368275);
INSERT INTO intraday_data VALUES('HOG',20070827121900,20070827,121900,54.12,54.13,54.08,54.08,3200);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.08,707238);
INSERT INTO intraday_data VALUES('HPC',20070827121900,20070827,121900,21.32,21.32,21.30,21.31,1400);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.27,21.31,492487);
INSERT INTO intraday_data VALUES('HXM',20070827121900,20070827,121900,53.45,53.45,53.45,53.45,1000);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.45,118900);
INSERT INTO intraday_data VALUES('IAG',20070827121900,20070827,121900,7.07,7.07,7.07,7.07,2100);
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,474350);
INSERT INTO intraday_data VALUES('IBM',20070827121900,20070827,121900,113.43,113.46,113.43,113.45,2000);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.59,112.80,113.45,1864502);
INSERT INTO intraday_data VALUES('INFA',20070827121900,20070827,121900,13.75,13.75,13.75,13.75,1371);
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,238244);
INSERT INTO intraday_data VALUES('INFY',20070827121900,20070827,121900,46.38,46.38,46.34,46.35,3000);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.33,46.35,558596);
INSERT INTO intraday_data VALUES('IVGN',20070827121900,20070827,121900,78.90,78.90,78.89,78.89,200);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,79.00,77.95,78.89,140774);
INSERT INTO intraday_data VALUES('JCP',20070827121900,20070827,121900,66.36,66.40,66.36,66.40,900);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,66.40,965700);
INSERT INTO intraday_data VALUES('JEC',20070827121900,20070827,121900,63.85,63.90,63.85,63.90,2700);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.85,63.90,233100);
INSERT INTO intraday_data VALUES('JOYG',20070827121900,20070827,121900,48.13,48.13,48.10,48.10,4000);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.10,751960);
INSERT INTO intraday_data VALUES('JWN',20070827121900,20070827,121900,48.19,48.20,48.19,48.20,3200);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,48.03,48.20,1414800);
INSERT INTO intraday_data VALUES('KBH',20070827121900,20070827,121900,30.74,30.75,30.74,30.75,1300);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.55,30.75,1079000);
INSERT INTO intraday_data VALUES('KCI',20070827121900,20070827,121900,61.77,61.84,61.77,61.81,700);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,61.77,61.81,289900);
INSERT INTO intraday_data VALUES('KG',20070827121900,20070827,121900,15.69,15.70,15.69,15.70,400);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.71,15.52,15.70,456200);
INSERT INTO intraday_data VALUES('KSS',20070827121900,20070827,121900,57.84,57.85,57.83,57.83,3300);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,57.73,57.83,1871900);
INSERT INTO intraday_data VALUES('LEH',20070827121900,20070827,121900,58.70,58.71,58.68,58.69,23100);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.43,58.69,3675618);
INSERT INTO intraday_data VALUES('LMT',20070827121900,20070827,121900,101.34,101.44,101.34,101.44,6000);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.44,99.12,101.44,817390);
INSERT INTO intraday_data VALUES('LRCX',20070827121900,20070827,121900,53.18,53.22,53.18,53.21,2837);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.87,53.21,1031762);
INSERT INTO intraday_data VALUES('LVS',20070827121900,20070827,121900,99.23,99.33,99.22,99.22,3300);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,99.22,1545925);
INSERT INTO intraday_data VALUES('MBT',20070827121900,20070827,121900,61.70,61.70,61.70,61.70,200);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.60,61.43,61.70,302800);
INSERT INTO intraday_data VALUES('MCD',20070827121900,20070827,121900,49.47,49.48,49.47,49.48,4000);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.42,49.48,1834912);
INSERT INTO intraday_data VALUES('MDC',20070827121900,20070827,121900,44.23,44.26,44.19,44.19,300);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,44.00,44.19,272400);
INSERT INTO intraday_data VALUES('MFLX',20070827121900,20070827,121900,12.60,12.60,12.60,12.60,100);
DELETE FROM eod_data WHERE `ticker` = "MFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MFLX',20070827,12.79,12.86,12.55,12.60,16069);
INSERT INTO intraday_data VALUES('MGM',20070827121900,20070827,121900,82.97,82.98,82.88,82.88,3600);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.88,538300);
INSERT INTO intraday_data VALUES('MLM',20070827121900,20070827,121900,131.97,132.03,131.97,132.03,500);
DELETE FROM eod_data WHERE `ticker` = "MLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MLM',20070827,134.34,135.00,131.11,132.03,206000);
INSERT INTO intraday_data VALUES('MNT',20070827121900,20070827,121900,44.05,44.05,44.04,44.04,600);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.26,43.63,44.04,275559);
INSERT INTO intraday_data VALUES('MOS',20070827121900,20070827,121900,40.53,40.54,40.49,40.49,2000);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.49,972000);
INSERT INTO intraday_data VALUES('MRVL',20070827121900,20070827,121900,15.56,15.56,15.54,15.54,48176);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.54,9823430);
INSERT INTO intraday_data VALUES('MSFT',20070827121900,20070827,121900,28.44,28.46,28.44,28.46,20979);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.40,28.46,10355922);
INSERT INTO intraday_data VALUES('MSTR',20070827121900,20070827,121900,73.50,73.69,73.50,73.69,726);
DELETE FROM eod_data WHERE `ticker` = "MSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSTR',20070827,75.96,76.50,73.22,73.69,123197);
INSERT INTO intraday_data VALUES('MTH',20070827121900,20070827,121900,17.90,17.90,17.89,17.89,300);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,17.84,17.89,355491);
INSERT INTO intraday_data VALUES('MTW',20070827121900,20070827,121900,76.18,76.18,76.18,76.18,100);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.18,253600);
INSERT INTO intraday_data VALUES('NEM',20070827121900,20070827,121900,40.73,40.75,40.73,40.75,600);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.41,40.75,1916000);
INSERT INTO intraday_data VALUES('NEU',20070827121900,20070827,121900,46.88,46.93,46.88,46.93,500);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,46.84,46.93,73600);
INSERT INTO intraday_data VALUES('NFLX',20070827121900,20070827,121900,17.41,17.44,17.40,17.42,10398);
DELETE FROM eod_data WHERE `ticker` = "NFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFLX',20070827,17.74,17.85,17.35,17.42,188091);
INSERT INTO intraday_data VALUES('NFX',20070827121900,20070827,121900,43.41,43.41,43.38,43.38,1200);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.28,43.38,527800);
INSERT INTO intraday_data VALUES('NILE',20070827121900,20070827,121900,85.96,86.02,85.72,85.79,1000);
DELETE FROM eod_data WHERE `ticker` = "NILE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NILE',20070827,86.59,87.20,84.92,85.79,98578);
INSERT INTO intraday_data VALUES('NOV',20070827121900,20070827,121900,119.18,119.27,119.18,119.24,2800);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,119.24,961221);
INSERT INTO intraday_data VALUES('NSTC',20070827121900,20070827,121900,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,36663);
INSERT INTO intraday_data VALUES('NTES',20070827121900,20070827,121900,16.34,16.35,16.34,16.35,1700);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.21,16.35,413450);
INSERT INTO intraday_data VALUES('NVDA',20070827121900,20070827,121900,49.37,49.37,49.31,49.35,18540);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.35,4244425);
INSERT INTO intraday_data VALUES('NYX',20070827121900,20070827,121900,73.90,73.93,73.88,73.90,2400);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.75,73.90,806372);
INSERT INTO intraday_data VALUES('OCR',20070827121900,20070827,121900,33.01,33.01,33.01,33.01,300);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.02,32.66,33.01,313200);
INSERT INTO intraday_data VALUES('OGE',20070827121900,20070827,121900,33.10,33.11,33.10,33.11,300);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.87,33.11,170900);
INSERT INTO intraday_data VALUES('ORCL',20070827121900,20070827,121900,19.84,19.85,19.84,19.85,9138);
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,9143391);
INSERT INTO intraday_data VALUES('OXY',20070827121900,20070827,121900,56.31,56.31,56.29,56.31,3300);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.31,1025100);
INSERT INTO intraday_data VALUES('PBR',20070827121900,20070827,121900,58.90,58.93,58.90,58.93,900);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.41,58.47,58.93,1442189);
INSERT INTO intraday_data VALUES('PCLN',20070827121900,20070827,121900,80.55,80.55,80.54,80.54,800);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.41,80.54,232003);
INSERT INTO intraday_data VALUES('PCP',20070827121900,20070827,121900,137.44,137.89,137.44,137.89,2000);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.13,137.89,402600);
INSERT INTO intraday_data VALUES('PCU',20070827121900,20070827,121900,102.11,102.34,102.11,102.19,3800);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,102.19,994073);
INSERT INTO intraday_data VALUES('PETS',20070827121900,20070827,121900,15.44,15.44,15.44,15.44,100);
DELETE FROM eod_data WHERE `ticker` = "PETS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PETS',20070827,15.60,15.67,15.33,15.44,101169);
INSERT INTO intraday_data VALUES('PNK',20070827121900,20070827,121900,27.26,27.26,27.26,27.26,300);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.27,26.85,27.26,123900);
INSERT INTO intraday_data VALUES('POT',20070827121900,20070827,121900,85.50,85.57,85.49,85.50,7200);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.42,85.50,663125);
INSERT INTO intraday_data VALUES('PRFT',20070827121900,20070827,121900,23.20,23.20,23.20,23.20,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.20,122609);
INSERT INTO intraday_data VALUES('PRST',20070827121900,20070827,121900,6.51,6.51,6.51,6.51,100);
DELETE FROM eod_data WHERE `ticker` = "PRST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRST',20070827,6.52,6.66,6.48,6.51,49045);
INSERT INTO intraday_data VALUES('QDEL',20070827121900,20070827,121900,17.29,17.29,17.29,17.29,100);
DELETE FROM eod_data WHERE `ticker` = "QDEL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QDEL',20070827,17.33,17.40,17.06,17.29,95571);
INSERT INTO intraday_data VALUES('QQQQ',20070827121900,20070827,121900,47.95,47.97,47.95,47.97,38392);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,47.97,31852634);
INSERT INTO intraday_data VALUES('RAI',20070827121900,20070827,121900,65.32,65.32,65.32,65.32,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.32,343300);
INSERT INTO intraday_data VALUES('RIG',20070827121900,20070827,121900,102.00,102.13,102.00,102.12,7000);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.54,102.12,1589933);
INSERT INTO intraday_data VALUES('RIMM',20070827121900,20070827,121900,80.96,81.07,80.96,80.99,27080);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,80.99,3185071);
INSERT INTO intraday_data VALUES('RIO',20070827121900,20070827,121900,47.46,47.47,47.41,47.43,19100);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.93,47.09,47.43,5639063);
INSERT INTO intraday_data VALUES('RL',20070827121900,20070827,121900,76.74,76.74,76.74,76.74,100);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.63,76.74,452300);
INSERT INTO intraday_data VALUES('RMD',20070827121900,20070827,121900,41.74,41.74,41.74,41.74,400);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.33,41.74,209505);
INSERT INTO intraday_data VALUES('RTP',20070827121900,20070827,121900,273.26,273.26,273.25,273.26,300);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,273.26,161600);
INSERT INTO intraday_data VALUES('RYL',20070827121900,20070827,121900,30.42,30.43,30.41,30.43,800);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.25,30.43,624881);
INSERT INTO intraday_data VALUES('SBGI',20070827121900,20070827,121900,12.43,12.43,12.43,12.43,200);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.39,12.43,474179);
INSERT INTO intraday_data VALUES('SBUX',20070827121900,20070827,121900,27.41,27.41,27.40,27.41,1200);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.41,1617278);
INSERT INTO intraday_data VALUES('SCI',20070827121900,20070827,121900,12.00,12.01,12.00,12.01,900);
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,548000);
INSERT INTO intraday_data VALUES('SII',20070827121900,20070827,121900,62.23,62.24,62.21,62.24,2100);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.02,62.24,568300);
INSERT INTO intraday_data VALUES('SIMG',20070827121900,20070827,121900,5.86,5.89,5.86,5.89,2300);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.89,307587);
INSERT INTO intraday_data VALUES('SKX',20070827121900,20070827,121900,19.91,19.91,19.91,19.91,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.91,166000);
INSERT INTO intraday_data VALUES('SLB',20070827121900,20070827,121900,92.49,92.54,92.49,92.54,10600);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.03,92.54,2065400);
INSERT INTO intraday_data VALUES('SNDK',20070827121900,20070827,121900,52.42,52.42,52.41,52.41,3169);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.11,52.41,4091173);
INSERT INTO intraday_data VALUES('SNE',20070827121900,20070827,121900,46.40,46.41,46.38,46.40,2200);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.40,251386);
INSERT INTO intraday_data VALUES('SPF',20070827121900,20070827,121900,9.88,9.88,9.88,9.88,200);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.88,899400);
INSERT INTO intraday_data VALUES('SPG',20070827121900,20070827,121900,93.01,93.07,93.01,93.07,1400);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,93.07,340700);
INSERT INTO intraday_data VALUES('SPN',20070827121900,20070827,121900,38.06,38.06,38.06,38.06,100);
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,169300);
INSERT INTO intraday_data VALUES('SPWR',20070827121900,20070827,121900,62.44,62.44,62.37,62.41,1700);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.05,62.41,434658);
INSERT INTO intraday_data VALUES('SPY',20070827121900,20070827,121900,147.37,147.40,147.35,147.40,188300);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,146.97,147.40,44587963);
INSERT INTO intraday_data VALUES('STLD',20070827121900,20070827,121900,43.29,43.29,43.27,43.28,1101);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.28,540057);
INSERT INTO intraday_data VALUES('STR',20070827121900,20070827,121900,49.67,49.68,49.64,49.66,2000);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.29,49.66,460000);
INSERT INTO intraday_data VALUES('SWN',20070827121900,20070827,121900,37.44,37.45,37.39,37.39,2700);
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,726400);
INSERT INTO intraday_data VALUES('SYKE',20070827121900,20070827,121900,16.61,16.62,16.61,16.62,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.62,39498);
INSERT INTO intraday_data VALUES('SYK',20070827121900,20070827,121900,67.40,67.41,67.38,67.39,2100);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.11,67.39,297432);
INSERT INTO intraday_data VALUES('TDW',20070827121900,20070827,121900,64.75,64.77,64.74,64.74,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.74,442015);
INSERT INTO intraday_data VALUES('TEX',20070827121900,20070827,121900,78.39,78.39,78.34,78.34,600);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,77.82,78.34,473800);
INSERT INTO intraday_data VALUES('TLM',20070827121900,20070827,121900,17.00,17.00,16.99,17.00,1800);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.95,17.00,783000);
INSERT INTO intraday_data VALUES('TNB',20070827121900,20070827,121900,55.45,55.45,55.45,55.45,100);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.45,203100);
INSERT INTO intraday_data VALUES('TOL',20070827121900,20070827,121900,22.29,22.30,22.27,22.29,9800);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.17,22.29,2116766);
INSERT INTO intraday_data VALUES('TOPT',20070827121900,20070827,121900,5.74,5.75,5.74,5.75,2100);
DELETE FROM eod_data WHERE `ticker` = "TOPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOPT',20070827,5.84,5.84,5.65,5.75,148216);
INSERT INTO intraday_data VALUES('TRAD',20070827121900,20070827,121900,10.74,10.74,10.74,10.74,200);
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,97559);
INSERT INTO intraday_data VALUES('TRMB',20070827121900,20070827,121900,36.47,36.47,36.47,36.47,100);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.47,292171);
INSERT INTO intraday_data VALUES('TSN',20070827121900,20070827,121900,21.30,21.30,21.30,21.30,600);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.22,21.30,539005);
INSERT INTO intraday_data VALUES('TSO',20070827121900,20070827,121900,49.45,49.48,49.45,49.48,1100);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.48,1037800);
INSERT INTO intraday_data VALUES('TS',20070827121900,20070827,121900,46.72,46.73,46.71,46.71,3500);
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,1304700);
INSERT INTO intraday_data VALUES('TXU',20070827121900,20070827,121900,65.96,65.99,65.92,65.95,4900);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.85,65.95,2583000);
INSERT INTO intraday_data VALUES('UA',20070827121900,20070827,121900,63.88,63.89,63.83,63.89,700);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,63.89,390700);
INSERT INTO intraday_data VALUES('UNH',20070827121900,20070827,121900,49.55,49.55,49.54,49.55,7700);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.38,49.55,1654680);
INSERT INTO intraday_data VALUES('UPL',20070827121900,20070827,121900,54.65,54.65,54.65,54.65,100);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.65,364200);
INSERT INTO intraday_data VALUES('URBN',20070827121900,20070827,121900,22.81,22.81,22.80,22.81,1423);
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,1014466);
INSERT INTO intraday_data VALUES('USG',20070827121900,20070827,121900,37.96,37.96,37.96,37.96,900);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.78,37.96,291700);
INSERT INTO intraday_data VALUES('VIP',20070827121900,20070827,121900,22.41,22.42,22.35,22.42,1900);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.08,22.42,788130);
INSERT INTO intraday_data VALUES('VLO',20070827121900,20070827,121900,67.31,67.37,67.30,67.37,7100);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.37,2136794);
INSERT INTO intraday_data VALUES('VSEA',20070827121900,20070827,121900,55.37,55.37,55.29,55.30,3795);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,56.58,54.53,55.30,1157312);
INSERT INTO intraday_data VALUES('WDC',20070827121900,20070827,121900,21.96,21.97,21.96,21.97,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.97,963000);
INSERT INTO intraday_data VALUES('WFMI',20070827121900,20070827,121900,45.63,45.67,45.63,45.67,2110);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.67,1725219);
INSERT INTO intraday_data VALUES('WFR',20070827121900,20070827,121900,58.56,58.57,58.56,58.57,2000);
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,528400);
INSERT INTO intraday_data VALUES('WFT',20070827121900,20070827,121900,55.46,55.49,55.46,55.48,3800);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.45,55.48,1111400);
INSERT INTO intraday_data VALUES('WHQ',20070827121900,20070827,121900,61.26,61.26,61.26,61.26,400);
DELETE FROM eod_data WHERE `ticker` = "WHQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WHQ',20070827,61.80,62.05,60.52,61.26,83700);
INSERT INTO intraday_data VALUES('WLP',20070827121900,20070827,121900,78.33,78.33,78.30,78.32,1500);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.54,77.89,78.32,992300);
INSERT INTO intraday_data VALUES('WNR',20070827121900,20070827,121900,52.16,52.19,52.15,52.16,2300);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,52.16,394000);
INSERT INTO intraday_data VALUES('XING',20070827121900,20070827,121900,9.21,9.22,9.21,9.21,1100);
DELETE FROM eod_data WHERE `ticker` = "XING" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('XING',20070827,8.98,9.38,8.83,9.21,237645);
INSERT INTO intraday_data VALUES('X',20070827121900,20070827,121900,93.64,93.75,93.64,93.75,7000);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,93.75,1557904);
INSERT INTO intraday_data VALUES('YHOO',20070827121900,20070827,121900,23.22,23.22,23.21,23.21,31478);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.20,23.21,6222141);