INSERT INTO intraday_data VALUES('$COMPX',20070827113800,20070827,113800,2560.72,2560.72,2560.55,2560.55,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2560.55,0);
INSERT INTO intraday_data VALUES('$DJUSAR',20070827113800,20070827,113800,120.41,120.41,120.41,120.41,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.41,0);
INSERT INTO intraday_data VALUES('$DJUSAV',20070827113800,20070827,113800,427.20,427.20,427.20,427.20,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAV',20070827,429.23,429.23,426.44,427.20,0);
INSERT INTO intraday_data VALUES('$DJUSBE',20070827113800,20070827,113800,125.82,125.82,125.82,125.82,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.82,0);
INSERT INTO intraday_data VALUES('$DJUSCC',20070827113800,20070827,113800,247.83,247.83,247.83,247.83,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCC',20070827,248.47,249.49,247.12,247.83,0);
INSERT INTO intraday_data VALUES('$DJUSCL',20070827113800,20070827,113800,258.78,258.78,258.78,258.78,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCL',20070827,265.08,265.08,257.04,258.78,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827113800,20070827,113800,334.92,334.92,334.87,334.87,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCY',20070827,336.55,336.90,334.60,334.87,0);
INSERT INTO intraday_data VALUES('$DJUSDN',20070827113800,20070827,113800,147.05,147.05,147.05,147.05,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.05,0);
INSERT INTO intraday_data VALUES('$DJUSDR',20070827113800,20070827,113800,342.64,342.64,342.64,342.64,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDR',20070827,342.19,343.12,342.01,342.64,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827113800,20070827,113800,594.60,594.60,594.38,594.38,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.75,594.38,0);
INSERT INTO intraday_data VALUES('$DJUSFA',20070827113800,20070827,113800,127.06,127.06,127.06,127.06,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFA',20070827,127.53,127.53,126.83,127.06,0);
INSERT INTO intraday_data VALUES('$DJUSFB',20070827113800,20070827,113800,285.13,285.13,285.13,285.13,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFB',20070827,285.82,285.83,284.79,285.13,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827113800,20070827,113800,547.72,547.72,547.64,547.69,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFN',20070827,552.10,552.10,546.51,547.69,0);
INSERT INTO intraday_data VALUES('$DJUSFP',20070827113800,20070827,113800,253.11,253.11,253.11,253.11,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFP',20070827,253.79,253.87,252.59,253.11,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827113800,20070827,113800,343.15,343.16,343.15,343.15,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.15,0);
INSERT INTO intraday_data VALUES('$DJUSHI',20070827113800,20070827,113800,90.92,90.92,90.92,90.92,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHI',20070827,91.34,91.44,90.61,90.92,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827113800,20070827,113800,350.34,350.34,350.31,350.33,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.33,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827113800,20070827,113800,308.45,308.45,308.43,308.43,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNC',20070827,309.88,310.14,308.09,308.43,0);
INSERT INTO intraday_data VALUES('$DJUSOQ',20070827113800,20070827,113800,694.94,694.94,694.94,694.94,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOQ',20070827,706.87,706.87,693.64,694.94,0);
INSERT INTO intraday_data VALUES('$DJUSOS',20070827113800,20070827,113800,578.24,578.24,578.24,578.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOS',20070827,586.53,586.53,576.95,578.24,0);
INSERT INTO intraday_data VALUES('$DJUSPL',20070827113800,20070827,113800,510.34,510.34,510.34,510.34,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.34,0);
INSERT INTO intraday_data VALUES('$DJUSPN',20070827113800,20070827,113800,303.48,303.48,303.48,303.48,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPN',20070827,304.68,304.68,303.29,303.48,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827113800,20070827,113800,283.83,283.86,283.83,283.86,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.86,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827113800,20070827,113800,405.40,405.40,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',20070827113800,20070827,113800,115.98,116.00,115.98,116.00,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.00,0);
INSERT INTO intraday_data VALUES('$DJUSRQ',20070827113800,20070827,113800,83.85,83.85,83.85,83.85,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRQ',20070827,84.04,84.06,83.65,83.85,0);
INSERT INTO intraday_data VALUES('$DJUSRR',20070827113800,20070827,113800,447.99,447.99,447.99,447.99,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRR',20070827,447.34,453.55,446.51,447.99,0);
INSERT INTO intraday_data VALUES('$DJUSRS',20070827113800,20070827,113800,444.12,444.12,444.12,444.12,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.12,0);
INSERT INTO intraday_data VALUES('$DJUSRT',20070827113800,20070827,113800,371.74,371.74,371.74,371.74,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRT',20070827,369.66,374.33,367.07,371.74,0);
INSERT INTO intraday_data VALUES('$DJUSRU',20070827113800,20070827,113800,446.50,446.50,446.50,446.50,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRU',20070827,450.61,450.61,446.02,446.50,0);
INSERT INTO intraday_data VALUES('$DJUSSB',20070827113800,20070827,113800,1094.60,1094.60,1094.60,1094.60,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSB',20070827,1108.11,1108.11,1093.86,1094.60,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827113800,20070827,113800,1329.33,1329.54,1329.32,1329.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1327.39,1329.54,0);
INSERT INTO intraday_data VALUES('$DJUSSD',20070827113800,20070827,113800,335.47,335.47,335.47,335.47,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSD',20070827,336.33,336.42,334.41,335.47,0);
INSERT INTO intraday_data VALUES('$DJUSST',20070827113800,20070827,113800,364.88,364.88,364.88,364.88,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSST',20070827,354.68,370.62,354.68,364.88,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827113800,20070827,113800,612.44,612.44,612.33,612.33,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,611.66,612.33,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827113800,20070827,113800,186.98,186.98,186.96,186.96,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.42,186.26,186.96,0);
INSERT INTO intraday_data VALUES('$DJUSTS',20070827113800,20070827,113800,176.33,176.33,176.33,176.33,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTS',20070827,176.80,176.82,175.84,176.33,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827113800,20070827,113800,187.13,187.13,187.08,187.08,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUT',20070827,191.11,191.11,186.17,187.08,0);
INSERT INTO intraday_data VALUES('$DJUSWU',20070827113800,20070827,113800,771.19,771.19,771.19,771.19,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWU',20070827,774.49,781.10,765.90,771.19,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827113800,20070827,113800,137.09,137.16,137.09,137.16,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.16,0);
INSERT INTO intraday_data VALUES('$IDX',20070827113800,20070827,113800,855.78,855.79,855.76,855.78,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,855.78,0);
INSERT INTO intraday_data VALUES('$INDU',20070827113800,20070827,113800,13330.10,13330.10,13327.98,13328.31,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13377.16,13305.87,13328.31,0);
INSERT INTO intraday_data VALUES('$INX',20070827113800,20070827,113800,1469.86,1469.86,1469.61,1469.61,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1469.61,0);
INSERT INTO intraday_data VALUES('$IUX',20070827113800,20070827,113800,790.32,790.32,790.27,790.27,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.27,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827113800,20070827,113800,9538.90,9538.90,9538.32,9538.32,0);
DELETE FROM eod_data WHERE `ticker` = "$NYA.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$NYA.X',20070827,9607.04,9607.04,9522.78,9538.32,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827113800,20070827,113800,685.51,685.51,685.38,685.38,0);
DELETE FROM eod_data WHERE `ticker` = "$OEX.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$OEX.X',20070827,688.88,688.88,684.40,685.38,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827113800,20070827,113800,730.04,730.04,729.90,729.94,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.94,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827113800,20070827,113800,416.11,416.12,416.11,416.12,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.12,0);
INSERT INTO intraday_data VALUES('$VIX',20070827113800,20070827,113800,22.46,22.47,22.46,22.47,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',20070827113800,20070827,113800,10.20,10.20,10.19,10.19,1400);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.15,10.19,472906);
INSERT INTO intraday_data VALUES('AAPL',20070827113800,20070827,113800,133.24,133.25,133.18,133.20,19192);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.20,12149012);
INSERT INTO intraday_data VALUES('ACLI',20070827113800,20070827,113800,23.75,23.76,23.74,23.75,3300);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,23.75,227105);
INSERT INTO intraday_data VALUES('ACL',20070827113800,20070827,113800,133.89,133.95,133.89,133.95,1200);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.95,134800);
INSERT INTO intraday_data VALUES('ADM',20070827113800,20070827,113800,32.90,32.92,32.89,32.91,3000);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.69,32.91,1222215);
INSERT INTO intraday_data VALUES('ADSK',20070827113800,20070827,113800,45.30,45.30,45.29,45.30,1300);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.51,44.75,45.30,416183);
INSERT INTO intraday_data VALUES('ADS',20070827113800,20070827,113800,76.56,76.56,76.49,76.50,3100);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.47,76.50,229300);
INSERT INTO intraday_data VALUES('AET',20070827113800,20070827,113800,49.92,49.92,49.89,49.89,5300);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.09,49.68,49.89,815400);
INSERT INTO intraday_data VALUES('AIRM',20070827113800,20070827,113800,41.17,41.17,41.17,41.17,100);
DELETE FROM eod_data WHERE `ticker` = "AIRM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AIRM',20070827,41.25,42.09,41.10,41.17,38774);
INSERT INTO intraday_data VALUES('ALB',20070827113800,20070827,113800,38.54,38.54,38.44,38.44,2300);
DELETE FROM eod_data WHERE `ticker` = "ALB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ALB',20070827,38.51,38.60,37.97,38.44,235300);
INSERT INTO intraday_data VALUES('AMTD',20070827113800,20070827,113800,17.59,17.59,17.57,17.57,7906);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.65,17.40,17.57,868990);
INSERT INTO intraday_data VALUES('AMX',20070827113800,20070827,113800,60.38,60.40,60.38,60.39,5700);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.74,60.06,60.39,1293200);
INSERT INTO intraday_data VALUES('AMZN',20070827113800,20070827,113800,79.48,79.56,79.48,79.51,22345);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.51,3046107);
INSERT INTO intraday_data VALUES('ANF',20070827113800,20070827,113800,78.89,78.89,78.83,78.83,1600);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,78.83,743800);
INSERT INTO intraday_data VALUES('AOB',20070827113800,20070827,113800,9.16,9.17,9.16,9.17,7400);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.25,9.03,9.17,362900);
INSERT INTO intraday_data VALUES('APA',20070827113800,20070827,113800,75.33,75.36,75.33,75.36,1800);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.15,75.36,906500);
INSERT INTO intraday_data VALUES('APH',20070827113800,20070827,113800,34.96,34.97,34.95,34.95,900);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,34.95,191900);
INSERT INTO intraday_data VALUES('AZN',20070827113800,20070827,113800,48.24,48.24,48.20,48.20,4900);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.15,48.20,260700);
INSERT INTO intraday_data VALUES('BA',20070827113800,20070827,113800,97.80,97.80,97.79,97.79,2400);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.36,97.13,97.79,1136405);
INSERT INTO intraday_data VALUES('BBY',20070827113800,20070827,113800,44.07,44.08,44.05,44.06,3500);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.94,44.06,1296115);
INSERT INTO intraday_data VALUES('BCSI',20070827113800,20070827,113800,86.27,86.28,86.20,86.20,2800);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,86.20,1151345);
INSERT INTO intraday_data VALUES('BDK',20070827113800,20070827,113800,87.19,87.19,87.09,87.09,2000);
DELETE FROM eod_data WHERE `ticker` = "BDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BDK',20070827,87.69,88.27,86.99,87.09,147100);
INSERT INTO intraday_data VALUES('BEN',20070827113800,20070827,113800,134.02,134.09,133.95,134.07,4600);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,133.50,134.07,234300);
INSERT INTO intraday_data VALUES('BG',20070827113800,20070827,113800,87.50,87.50,87.50,87.50,400);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,87.92,87.03,87.50,171600);
INSERT INTO intraday_data VALUES('BHI',20070827113800,20070827,113800,80.26,80.28,80.24,80.26,4500);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,80.15,80.26,903463);
INSERT INTO intraday_data VALUES('BIDU',20070827113800,20070827,113800,208.89,208.96,208.66,208.96,5210);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,211.30,200.55,208.96,2256509);
INSERT INTO intraday_data VALUES('BNI',20070827113800,20070827,113800,80.12,80.14,80.01,80.03,7800);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,80.83,79.68,80.03,753458);
INSERT INTO intraday_data VALUES('BPT',20070827113800,20070827,113800,70.79,70.79,70.70,70.70,500);
DELETE FROM eod_data WHERE `ticker` = "BPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BPT',20070827,71.05,71.20,70.53,70.70,32800);
INSERT INTO intraday_data VALUES('BRCD',20070827113800,20070827,113800,7.06,7.07,7.06,7.06,2300);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,7.02,7.06,3154120);
INSERT INTO intraday_data VALUES('BRY',20070827113800,20070827,113800,33.50,33.50,33.50,33.50,100);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.36,33.50,62200);
INSERT INTO intraday_data VALUES('BR',20070827113800,20070827,113800,17.87,17.88,17.87,17.88,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.88,186700);
INSERT INTO intraday_data VALUES('BTU',20070827113800,20070827,113800,41.60,41.60,41.59,41.59,1100);
DELETE FROM eod_data WHERE `ticker` = "BTU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BTU',20070827,42.44,42.56,41.19,41.59,1546792);
INSERT INTO intraday_data VALUES('BZH',20070827113800,20070827,113800,9.78,9.78,9.72,9.73,10200);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.73,1018700);
INSERT INTO intraday_data VALUES('CAM',20070827113800,20070827,113800,77.10,77.12,77.10,77.12,300);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.12,320400);
INSERT INTO intraday_data VALUES('CBB',20070827113800,20070827,113800,5.00,5.00,4.99,5.00,400);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,5.00,4.91,5.00,289300);
INSERT INTO intraday_data VALUES('CCJ',20070827113800,20070827,113800,40.16,40.16,40.16,40.16,800);
DELETE FROM eod_data WHERE `ticker` = "CCJ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CCJ',20070827,40.33,40.49,39.71,40.16,1024362);
INSERT INTO intraday_data VALUES('CEG',20070827113800,20070827,113800,84.23,84.23,84.23,84.23,800);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.86,84.23,577700);
INSERT INTO intraday_data VALUES('CELG',20070827113800,20070827,113800,59.46,59.49,59.46,59.49,700);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.78,59.30,59.49,756540);
INSERT INTO intraday_data VALUES('CEPH',20070827113800,20070827,113800,73.53,73.53,73.50,73.50,400);
DELETE FROM eod_data WHERE `ticker` = "CEPH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEPH',20070827,73.75,74.17,73.12,73.50,298344);
INSERT INTO intraday_data VALUES('CERN',20070827113800,20070827,113800,56.49,56.49,56.49,56.49,930);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.34,56.49,66451);
INSERT INTO intraday_data VALUES('CFC',20070827113800,20070827,113800,20.01,20.03,19.99,20.00,128700);
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,22414291);
INSERT INTO intraday_data VALUES('CHAP',20070827113800,20070827,113800,85.39,85.40,85.39,85.39,2243);
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,219875);
INSERT INTO intraday_data VALUES('CHINA',20070827113800,20070827,113800,8.43,8.43,8.43,8.43,800);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.47,8.20,8.43,362137);
INSERT INTO intraday_data VALUES('CHRW',20070827113800,20070827,113800,49.02,49.02,49.02,49.02,200);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.02,181416);
INSERT INTO intraday_data VALUES('CI',20070827113800,20070827,113800,49.98,50.00,49.96,50.00,3900);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.87,50.00,503592);
INSERT INTO intraday_data VALUES('CME',20070827113800,20070827,113800,559.50,559.50,559.47,559.50,1200);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.80,556.00,559.50,135500);
INSERT INTO intraday_data VALUES('CNH',20070827113800,20070827,113800,49.14,49.15,49.09,49.09,700);
DELETE FROM eod_data WHERE `ticker` = "CNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CNH',20070827,49.67,50.35,48.94,49.09,107400);
INSERT INTO intraday_data VALUES('COGO',20070827113800,20070827,113800,17.44,17.47,17.43,17.47,1623);
DELETE FROM eod_data WHERE `ticker` = "COGO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COGO',20070827,17.16,17.64,17.16,17.47,149640);
INSERT INTO intraday_data VALUES('COG',20070827113800,20070827,113800,32.69,32.69,32.67,32.67,1000);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.67,192700);
INSERT INTO intraday_data VALUES('COH',20070827113800,20070827,113800,43.36,43.36,43.31,43.33,39500);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.22,43.33,1321652);
INSERT INTO intraday_data VALUES('COP',20070827113800,20070827,113800,80.77,80.78,80.73,80.75,16500);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,80.82,80.02,80.75,2055200);
INSERT INTO intraday_data VALUES('CRDN',20070827113800,20070827,113800,69.93,69.96,69.90,69.90,600);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.76,69.90,200282);
INSERT INTO intraday_data VALUES('CROX',20070827113800,20070827,113800,59.60,59.62,59.58,59.62,4826);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,59.62,4056825);
INSERT INTO intraday_data VALUES('CRS',20070827113800,20070827,113800,114.83,114.86,114.83,114.86,200);
DELETE FROM eod_data WHERE `ticker` = "CRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRS',20070827,114.59,117.20,114.34,114.86,120200);
INSERT INTO intraday_data VALUES('CSCO',20070827113800,20070827,113800,30.93,30.94,30.91,30.92,94876);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.92,16432035);
INSERT INTO intraday_data VALUES('CTRP',20070827113800,20070827,113800,43.00,43.01,43.00,43.00,2100);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.00,487775);
INSERT INTO intraday_data VALUES('CTSH',20070827113800,20070827,113800,74.01,74.01,73.98,73.98,1215);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,73.98,757664);
INSERT INTO intraday_data VALUES('CTX',20070827113800,20070827,113800,30.62,30.62,30.56,30.57,7900);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.44,30.57,1263934);
INSERT INTO intraday_data VALUES('CVH',20070827113800,20070827,113800,58.10,58.10,58.07,58.07,300);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,58.07,246200);
INSERT INTO intraday_data VALUES('CXW',20070827113800,20070827,113800,25.45,25.45,25.38,25.38,3500);
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,375800);
INSERT INTO intraday_data VALUES('CX',20070827113800,20070827,113800,31.45,31.45,31.43,31.44,500);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.25,31.44,852000);
INSERT INTO intraday_data VALUES('DECK',20070827113800,20070827,113800,94.28,94.28,94.28,94.28,100);
DELETE FROM eod_data WHERE `ticker` = "DECK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DECK',20070827,96.35,96.48,94.02,94.28,113095);
INSERT INTO intraday_data VALUES('DIA',20070827113800,20070827,113800,133.22,133.23,133.21,133.22,5800);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.54,132.98,133.22,2928144);
INSERT INTO intraday_data VALUES('DNA',20070827113800,20070827,113800,73.35,73.37,73.34,73.37,6800);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.15,73.37,403600);
INSERT INTO intraday_data VALUES('DRIV',20070827113800,20070827,113800,44.77,44.77,44.77,44.77,100);
DELETE FROM eod_data WHERE `ticker` = "DRIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRIV',20070827,44.64,44.99,44.45,44.77,85025);
INSERT INTO intraday_data VALUES('DRYS',20070827113800,20070827,113800,65.98,66.00,65.95,65.95,2843);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.45,63.16,65.95,1125889);
INSERT INTO intraday_data VALUES('DVR',20070827113800,20070827,113800,14.43,14.43,14.43,14.43,200);
DELETE FROM eod_data WHERE `ticker` = "DVR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DVR',20070827,14.68,14.68,14.37,14.43,155200);
INSERT INTO intraday_data VALUES('EBAY',20070827113800,20070827,113800,33.76,33.77,33.76,33.76,31407);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.76,3088787);
INSERT INTO intraday_data VALUES('ECA',20070827113800,20070827,113800,58.47,58.47,58.45,58.45,300);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.45,560533);
INSERT INTO intraday_data VALUES('EGY',20070827113800,20070827,113800,3.71,3.71,3.71,3.71,1700);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.71,142900);
INSERT INTO intraday_data VALUES('ENR',20070827113800,20070827,113800,107.59,107.63,107.59,107.63,200);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,107.63,259300);
INSERT INTO intraday_data VALUES('EOG',20070827113800,20070827,113800,66.78,66.80,66.78,66.79,1800);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.79,688550);
INSERT INTO intraday_data VALUES('ESRX',20070827113800,20070827,113800,54.61,54.61,54.59,54.59,1200);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.59,337058);
INSERT INTO intraday_data VALUES('ESV',20070827113800,20070827,113800,56.79,56.79,56.78,56.79,1100);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.56,56.79,573000);
INSERT INTO intraday_data VALUES('EXPD',20070827113800,20070827,113800,45.29,45.29,45.29,45.29,400);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.69,45.01,45.29,244388);
INSERT INTO intraday_data VALUES('EXP',20070827113800,20070827,113800,38.37,38.37,38.37,38.37,100);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.30,38.37,227600);
INSERT INTO intraday_data VALUES('FDG',20070827113800,20070827,113800,32.65,32.68,32.65,32.68,400);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.85,32.05,32.68,183700);
INSERT INTO intraday_data VALUES('FFIV',20070827113800,20070827,113800,36.50,36.62,36.50,36.60,4100);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,36.60,375148);
INSERT INTO intraday_data VALUES('FLR',20070827113800,20070827,113800,124.70,124.70,124.62,124.62,600);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.25,123.02,124.62,389375);
INSERT INTO intraday_data VALUES('FRK',20070827113800,20070827,113800,62.17,62.17,62.17,62.17,100);
DELETE FROM eod_data WHERE `ticker` = "FRK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRK',20070827,62.83,62.99,62.10,62.17,66100);
INSERT INTO intraday_data VALUES('FRX',20070827113800,20070827,113800,37.18,37.21,37.17,37.20,4500);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.20,893400);
INSERT INTO intraday_data VALUES('FTI',20070827113800,20070827,113800,90.06,90.06,90.06,90.06,200);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,89.69,90.06,212300);
INSERT INTO intraday_data VALUES('GES',20070827113800,20070827,113800,49.73,49.73,49.68,49.70,500);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.49,49.70,290393);
INSERT INTO intraday_data VALUES('GGB',20070827113800,20070827,113800,22.90,22.91,22.90,22.90,400);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,22.90,590000);
INSERT INTO intraday_data VALUES('GILD',20070827113800,20070827,113800,36.81,36.83,36.81,36.82,4200);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.75,36.82,1518927);
INSERT INTO intraday_data VALUES('GNA',20070827113800,20070827,113800,11.80,11.80,11.79,11.80,1800);
DELETE FROM eod_data WHERE `ticker` = "GNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GNA',20070827,12.07,12.29,11.76,11.80,237500);
INSERT INTO intraday_data VALUES('GOOG',20070827113800,20070827,113800,514.02,514.02,513.71,513.84,4290);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,513.84,1175584);
INSERT INTO intraday_data VALUES('GRA',20070827113800,20070827,113800,21.93,21.93,21.88,21.91,1600);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.84,21.91,135100);
INSERT INTO intraday_data VALUES('GRMN',20070827113800,20070827,113800,101.79,101.80,101.76,101.78,1500);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,101.78,1006735);
INSERT INTO intraday_data VALUES('GS',20070827113800,20070827,113800,177.97,177.98,177.80,177.83,11600);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.50,177.83,2947400);
INSERT INTO intraday_data VALUES('GTI',20070827113800,20070827,113800,17.12,17.14,17.12,17.12,2800);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,17.12,916900);
INSERT INTO intraday_data VALUES('HAL',20070827113800,20070827,113800,33.40,33.40,33.38,33.38,22100);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.38,33.38,3730301);
INSERT INTO intraday_data VALUES('HOC',20070827113800,20070827,113800,64.65,64.70,64.65,64.65,500);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,64.65,324275);
INSERT INTO intraday_data VALUES('HOG',20070827113800,20070827,113800,54.18,54.18,54.16,54.16,1200);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.16,619286);
INSERT INTO intraday_data VALUES('HOV',20070827113800,20070827,113800,11.52,11.53,11.52,11.53,1500);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.46,11.53,753944);
INSERT INTO intraday_data VALUES('HPC',20070827113800,20070827,113800,21.36,21.38,21.36,21.38,1100);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.30,21.38,379969);
INSERT INTO intraday_data VALUES('HXM',20070827113800,20070827,113800,53.55,53.55,53.55,53.55,100);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.55,105600);
INSERT INTO intraday_data VALUES('IAG',20070827113800,20070827,113800,7.04,7.04,7.03,7.04,3200);
DELETE FROM eod_data WHERE `ticker` = "IAG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IAG',20070827,7.18,7.18,7.01,7.04,439350);
INSERT INTO intraday_data VALUES('IBM',20070827113800,20070827,113800,113.41,113.41,113.38,113.38,2200);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.59,112.80,113.38,1574002);
INSERT INTO intraday_data VALUES('ICE',20070827113800,20070827,113800,140.66,140.66,140.66,140.66,200);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.88,140.66,377700);
INSERT INTO intraday_data VALUES('INFY',20070827113800,20070827,113800,46.50,46.52,46.50,46.52,600);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.35,46.52,473137);
INSERT INTO intraday_data VALUES('ISE',20070827113800,20070827,113800,66.05,66.06,66.05,66.06,300);
DELETE FROM eod_data WHERE `ticker` = "ISE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ISE',20070827,66.11,66.19,65.96,66.06,76003);
INSERT INTO intraday_data VALUES('JCI',20070827113800,20070827,113800,111.30,111.34,111.22,111.22,3700);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.21,111.22,134500);
INSERT INTO intraday_data VALUES('JCP',20070827113800,20070827,113800,66.52,66.52,66.46,66.48,2500);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,66.48,779900);
INSERT INTO intraday_data VALUES('JEC',20070827113800,20070827,113800,64.35,64.37,64.30,64.30,400);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.87,64.30,197800);
INSERT INTO intraday_data VALUES('JOYG',20070827113800,20070827,113800,48.32,48.33,48.30,48.32,2000);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.32,598166);
INSERT INTO intraday_data VALUES('JWN',20070827113800,20070827,113800,48.36,48.36,48.21,48.26,16300);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,48.21,48.26,1084900);
INSERT INTO intraday_data VALUES('KBH',20070827113800,20070827,113800,30.92,30.92,30.86,30.86,3300);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.68,30.86,925900);
INSERT INTO intraday_data VALUES('KCI',20070827113800,20070827,113800,62.48,62.48,62.47,62.47,800);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,62.25,62.47,144200);
INSERT INTO intraday_data VALUES('KG',20070827113800,20070827,113800,15.61,15.61,15.61,15.61,700);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.70,15.52,15.61,300600);
INSERT INTO intraday_data VALUES('KSS',20070827113800,20070827,113800,58.16,58.17,58.11,58.12,5700);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,58.05,58.12,1367700);
INSERT INTO intraday_data VALUES('LEH',20070827113800,20070827,113800,58.75,58.75,58.69,58.71,10500);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.43,58.71,3188834);
INSERT INTO intraday_data VALUES('LMT',20070827113800,20070827,113800,100.92,100.94,100.85,100.89,5800);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.00,99.12,100.89,602490);
INSERT INTO intraday_data VALUES('LRCX',20070827113800,20070827,113800,53.03,53.03,53.03,53.03,300);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.88,53.03,912623);
INSERT INTO intraday_data VALUES('LVS',20070827113800,20070827,113800,97.95,98.15,97.95,98.07,11700);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,98.07,1313025);
INSERT INTO intraday_data VALUES('MBT',20070827113800,20070827,113800,61.89,61.89,61.89,61.89,400);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.60,61.53,61.89,257500);
INSERT INTO intraday_data VALUES('MCD',20070827113800,20070827,113800,49.48,49.49,49.48,49.48,4300);
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,1542412);
INSERT INTO intraday_data VALUES('MDC',20070827113800,20070827,113800,44.28,44.29,44.28,44.29,300);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,44.08,44.29,249400);
INSERT INTO intraday_data VALUES('MED',20070827113800,20070827,113800,6.75,6.75,6.75,6.75,100);
DELETE FROM eod_data WHERE `ticker` = "MED" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MED',20070827,6.80,6.90,6.63,6.75,117600);
INSERT INTO intraday_data VALUES('MESA',20070827113800,20070827,113800,6.00,6.00,6.00,6.00,200);
DELETE FROM eod_data WHERE `ticker` = "MESA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MESA',20070827,5.86,6.06,5.81,6.00,87271);
INSERT INTO intraday_data VALUES('MGM',20070827113800,20070827,113800,82.21,82.21,82.21,82.21,900);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.21,413800);
INSERT INTO intraday_data VALUES('MICC',20070827113800,20070827,113800,81.74,81.84,81.74,81.83,700);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.34,81.83,140139);
INSERT INTO intraday_data VALUES('MLM',20070827113800,20070827,113800,131.69,131.70,131.69,131.70,200);
DELETE FROM eod_data WHERE `ticker` = "MLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MLM',20070827,134.34,135.00,131.11,131.70,189600);
INSERT INTO intraday_data VALUES('MNT',20070827113800,20070827,113800,44.06,44.07,44.06,44.07,400);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.12,43.63,44.07,238723);
INSERT INTO intraday_data VALUES('MOS',20070827113800,20070827,113800,40.09,40.09,40.07,40.09,3700);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.09,844700);
INSERT INTO intraday_data VALUES('MRVL',20070827113800,20070827,113800,15.38,15.42,15.37,15.41,63638);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.41,8557032);
INSERT INTO intraday_data VALUES('MSFT',20070827113800,20070827,113800,28.47,28.48,28.47,28.48,47466);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.42,28.48,8938024);
INSERT INTO intraday_data VALUES('MSTR',20070827113800,20070827,113800,73.80,73.86,73.79,73.80,402);
DELETE FROM eod_data WHERE `ticker` = "MSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSTR',20070827,75.96,76.50,73.65,73.80,106275);
INSERT INTO intraday_data VALUES('MTH',20070827113800,20070827,113800,18.11,18.12,18.10,18.10,1800);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,18.02,18.10,277691);
INSERT INTO intraday_data VALUES('MT',20070827113800,20070827,113800,63.79,63.79,63.78,63.78,400);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.50,63.78,854060);
INSERT INTO intraday_data VALUES('NEM',20070827113800,20070827,113800,40.72,40.74,40.71,40.73,6400);
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,1768800);
INSERT INTO intraday_data VALUES('NEU',20070827113800,20070827,113800,47.39,47.39,47.28,47.33,800);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,47.28,47.33,57800);
INSERT INTO intraday_data VALUES('NFLX',20070827113800,20070827,113800,17.46,17.46,17.46,17.46,800);
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,155925);
INSERT INTO intraday_data VALUES('NFX',20070827113800,20070827,113800,43.68,43.68,43.68,43.68,1500);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.48,43.68,410200);
INSERT INTO intraday_data VALUES('NILE',20070827113800,20070827,113800,85.25,85.26,85.25,85.26,200);
DELETE FROM eod_data WHERE `ticker` = "NILE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NILE',20070827,86.59,87.20,84.92,85.26,82410);
INSERT INTO intraday_data VALUES('NOV',20070827113800,20070827,113800,119.01,119.04,118.95,118.95,2800);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,118.95,847121);
INSERT INTO intraday_data VALUES('NSTC',20070827113800,20070827,113800,10.95,10.95,10.94,10.94,500);
DELETE FROM eod_data WHERE `ticker` = "NSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NSTC',20070827,10.99,11.11,10.90,10.94,31363);
INSERT INTO intraday_data VALUES('NTES',20070827113800,20070827,113800,16.32,16.34,16.32,16.34,1600);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.30,16.34,327399);
INSERT INTO intraday_data VALUES('NUE',20070827113800,20070827,113800,54.07,54.11,54.04,54.05,5500);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.42,54.05,2326069);
INSERT INTO intraday_data VALUES('NVDA',20070827113800,20070827,113800,49.11,49.17,49.11,49.17,16900);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.17,3559823);
INSERT INTO intraday_data VALUES('NWRE',20070827113800,20070827,113800,15.96,15.96,15.96,15.96,500);
DELETE FROM eod_data WHERE `ticker` = "NWRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NWRE',20070827,15.83,15.96,15.83,15.96,83503);
INSERT INTO intraday_data VALUES('NYX',20070827113800,20070827,113800,73.96,74.00,73.91,73.91,6300);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.75,73.91,712842);
INSERT INTO intraday_data VALUES('OCR',20070827113800,20070827,113800,32.97,32.97,32.97,32.97,200);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.01,32.66,32.97,206400);
INSERT INTO intraday_data VALUES('OGE',20070827113800,20070827,113800,33.04,33.04,33.03,33.03,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.03,153400);
INSERT INTO intraday_data VALUES('OII',20070827113800,20070827,113800,64.05,64.05,64.05,64.05,400);
DELETE FROM eod_data WHERE `ticker` = "OII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OII',20070827,65.35,65.45,64.02,64.05,113600);
INSERT INTO intraday_data VALUES('ORCL',20070827113800,20070827,113800,19.80,19.81,19.80,19.80,31567);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.80,7868854);
INSERT INTO intraday_data VALUES('OXY',20070827113800,20070827,113800,56.30,56.31,56.30,56.30,1400);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.30,865500);
INSERT INTO intraday_data VALUES('PBR',20070827113800,20070827,113800,58.66,58.66,58.61,58.63,13100);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.41,58.47,58.63,1299889);
INSERT INTO intraday_data VALUES('PCLN',20070827113800,20070827,113800,80.73,80.73,80.71,80.71,810);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.59,80.71,186024);
INSERT INTO intraday_data VALUES('PCP',20070827113800,20070827,113800,136.90,136.91,136.90,136.91,200);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.13,136.91,346500);
INSERT INTO intraday_data VALUES('PCR',20070827113800,20070827,113800,55.60,55.60,55.60,55.60,200);
DELETE FROM eod_data WHERE `ticker` = "PCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCR',20070827,56.99,57.96,54.84,55.60,197300);
INSERT INTO intraday_data VALUES('PETS',20070827113800,20070827,113800,15.60,15.60,15.60,15.60,200);
DELETE FROM eod_data WHERE `ticker` = "PETS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PETS',20070827,15.60,15.67,15.33,15.60,93137);
INSERT INTO intraday_data VALUES('PMTI',20070827113800,20070827,113800,30.63,30.63,30.63,30.63,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.63,45717);
INSERT INTO intraday_data VALUES('PNK',20070827113800,20070827,113800,27.21,27.23,27.21,27.23,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.23,103100);
INSERT INTO intraday_data VALUES('POT',20070827113800,20070827,113800,85.85,85.89,85.79,85.80,3000);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.59,85.80,525100);
INSERT INTO intraday_data VALUES('PRFT',20070827113800,20070827,113800,23.26,23.26,23.26,23.26,500);
DELETE FROM eod_data WHERE `ticker` = "PRFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRFT',20070827,23.04,23.45,22.95,23.26,108123);
INSERT INTO intraday_data VALUES('QQQQ',20070827113800,20070827,113800,47.92,47.93,47.92,47.92,13737);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,47.92,27837302);
INSERT INTO intraday_data VALUES('RAI',20070827113800,20070827,113800,65.25,65.27,65.24,65.24,1100);
DELETE FROM eod_data WHERE `ticker` = "RAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RAI',20070827,65.60,65.99,65.10,65.24,290200);
INSERT INTO intraday_data VALUES('RIG',20070827113800,20070827,113800,102.34,102.35,102.28,102.29,5800);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,102.15,102.29,1159700);
INSERT INTO intraday_data VALUES('RIMM',20070827113800,20070827,113800,80.81,80.83,80.72,80.75,24784);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,80.75,2799761);
INSERT INTO intraday_data VALUES('RIO',20070827113800,20070827,113800,47.41,47.43,47.30,47.31,37200);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.93,47.09,47.31,5122673);
INSERT INTO intraday_data VALUES('RL',20070827113800,20070827,113800,76.84,76.85,76.80,76.80,1200);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.63,76.80,396200);
INSERT INTO intraday_data VALUES('RMD',20070827113800,20070827,113800,41.46,41.46,41.44,41.44,600);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.33,41.44,137405);
INSERT INTO intraday_data VALUES('RTP',20070827113800,20070827,113800,272.32,272.32,272.32,272.32,100);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,272.32,146500);
INSERT INTO intraday_data VALUES('RYL',20070827113800,20070827,113800,30.74,30.74,30.71,30.73,3000);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.46,30.73,504981);
INSERT INTO intraday_data VALUES('SBGI',20070827113800,20070827,113800,12.55,12.56,12.55,12.56,300);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.42,12.56,445579);
INSERT INTO intraday_data VALUES('SBUX',20070827113800,20070827,113800,27.44,27.45,27.44,27.44,2554);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.44,1414801);
INSERT INTO intraday_data VALUES('SCI',20070827113800,20070827,113800,12.00,12.01,12.00,12.00,1000);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,12.00,12.00,140600);
INSERT INTO intraday_data VALUES('SCUR',20070827113800,20070827,113800,8.26,8.27,8.26,8.27,600);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.26,8.27,161079);
INSERT INTO intraday_data VALUES('SEIC',20070827113800,20070827,113800,25.70,25.70,25.70,25.70,900);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.70,102904);
INSERT INTO intraday_data VALUES('SII',20070827113800,20070827,113800,62.35,62.35,62.35,62.35,100);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.07,62.35,477700);
INSERT INTO intraday_data VALUES('SIMG',20070827113800,20070827,113800,5.82,5.82,5.81,5.81,550);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.81,256487);
INSERT INTO intraday_data VALUES('SLB',20070827113800,20070827,113800,92.38,92.38,92.35,92.35,2900);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.10,92.35,1796300);
INSERT INTO intraday_data VALUES('SNDK',20070827113800,20070827,113800,52.30,52.35,52.29,52.33,20488);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.12,52.33,3509149);
INSERT INTO intraday_data VALUES('SNE',20070827113800,20070827,113800,46.41,46.41,46.41,46.41,200);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.41,222486);
INSERT INTO intraday_data VALUES('SPF',20070827113800,20070827,113800,9.94,9.96,9.92,9.96,7900);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.96,792800);
INSERT INTO intraday_data VALUES('SPG',20070827113800,20070827,113800,92.86,92.96,92.84,92.96,1400);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,92.96,280500);
INSERT INTO intraday_data VALUES('SPIL',20070827113800,20070827,113800,10.12,10.12,10.12,10.12,900);
DELETE FROM eod_data WHERE `ticker` = "SPIL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPIL',20070827,10.26,10.26,10.00,10.12,368239);
INSERT INTO intraday_data VALUES('SPN',20070827113800,20070827,113800,38.05,38.07,38.05,38.07,2700);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.01,38.07,138100);
INSERT INTO intraday_data VALUES('SPWR',20070827113800,20070827,113800,62.72,62.72,62.71,62.71,380);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.32,62.71,349210);
INSERT INTO intraday_data VALUES('SPY',20070827113800,20070827,113800,147.25,147.25,147.20,147.22,200100);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,146.97,147.22,39278598);
INSERT INTO intraday_data VALUES('STLD',20070827113800,20070827,113800,43.36,43.40,43.34,43.37,2604);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.37,475147);
INSERT INTO intraday_data VALUES('STR',20070827113800,20070827,113800,49.46,49.51,49.46,49.50,1500);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.29,49.50,382000);
INSERT INTO intraday_data VALUES('SWN',20070827113800,20070827,113800,37.46,37.47,37.46,37.47,400);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.47,628100);
INSERT INTO intraday_data VALUES('SYKE',20070827113800,20070827,113800,16.65,16.65,16.65,16.65,100);
DELETE FROM eod_data WHERE `ticker` = "SYKE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYKE',20070827,16.96,16.96,16.62,16.65,33071);
INSERT INTO intraday_data VALUES('SYK',20070827113800,20070827,113800,67.34,67.36,67.32,67.34,4300);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.11,67.34,250032);
INSERT INTO intraday_data VALUES('TDW',20070827113800,20070827,113800,64.66,64.67,64.62,64.62,1500);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.25,64.45,64.62,363015);
INSERT INTO intraday_data VALUES('TEX',20070827113800,20070827,113800,78.16,78.16,78.13,78.13,400);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,77.82,78.13,414000);
INSERT INTO intraday_data VALUES('TLM',20070827113800,20070827,113800,17.00,17.00,16.99,17.00,1000);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.97,17.00,596900);
INSERT INTO intraday_data VALUES('TNB',20070827113800,20070827,113800,55.53,55.53,55.40,55.50,3700);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.50,174700);
INSERT INTO intraday_data VALUES('TOL',20070827113800,20070827,113800,22.45,22.51,22.45,22.47,15200);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.25,22.47,1762866);
INSERT INTO intraday_data VALUES('TRAD',20070827113800,20070827,113800,10.74,10.74,10.74,10.74,500);
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,83564);
INSERT INTO intraday_data VALUES('TRMB',20070827113800,20070827,113800,36.38,36.38,36.34,36.34,360);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.34,276416);
INSERT INTO intraday_data VALUES('TSN',20070827113800,20070827,113800,21.29,21.29,21.28,21.29,2200);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.22,21.29,461705);
INSERT INTO intraday_data VALUES('TSO',20070827113800,20070827,113800,49.26,49.30,49.26,49.26,900);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.26,927500);
INSERT INTO intraday_data VALUES('TS',20070827113800,20070827,113800,46.71,46.71,46.66,46.67,1700);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.67,1177300);
INSERT INTO intraday_data VALUES('TXU',20070827113800,20070827,113800,66.07,66.10,66.05,66.05,39400);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.87,66.05,1734400);
INSERT INTO intraday_data VALUES('UA',20070827113800,20070827,113800,64.89,64.89,64.89,64.89,400);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,64.89,317900);
INSERT INTO intraday_data VALUES('UFPI',20070827113800,20070827,113800,37.98,37.98,37.97,37.98,400);
DELETE FROM eod_data WHERE `ticker` = "UFPI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UFPI',20070827,38.17,38.87,37.74,37.98,25549);
INSERT INTO intraday_data VALUES('UNH',20070827113800,20070827,113800,49.54,49.54,49.53,49.53,4300);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.38,49.53,1396180);
INSERT INTO intraday_data VALUES('UPL',20070827113800,20070827,113800,54.74,54.74,54.74,54.74,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.74,326800);
INSERT INTO intraday_data VALUES('URBN',20070827113800,20070827,113800,22.59,22.59,22.59,22.59,300);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.59,834704);
INSERT INTO intraday_data VALUES('USG',20070827113800,20070827,113800,37.99,38.04,37.99,38.03,1200);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.78,38.03,260400);
INSERT INTO intraday_data VALUES('VIP',20070827113800,20070827,113800,22.13,22.13,22.12,22.12,1500);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.08,22.12,726030);
INSERT INTO intraday_data VALUES('VIVO',20070827113800,20070827,113800,25.16,25.16,25.16,25.16,100);
DELETE FROM eod_data WHERE `ticker` = "VIVO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIVO',20070827,25.53,25.54,25.06,25.16,32861);
INSERT INTO intraday_data VALUES('VLO',20070827113800,20070827,113800,67.54,67.55,67.53,67.53,4900);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.53,1782594);
INSERT INTO intraday_data VALUES('VSEA',20070827113800,20070827,113800,54.65,54.67,54.64,54.64,1300);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,56.58,54.53,54.64,983742);
INSERT INTO intraday_data VALUES('WBSN',20070827113800,20070827,113800,20.49,20.49,20.48,20.48,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.48,41045);
INSERT INTO intraday_data VALUES('WCC',20070827113800,20070827,113800,48.12,48.15,48.11,48.11,1300);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,48.01,48.11,145694);
INSERT INTO intraday_data VALUES('WDC',20070827113800,20070827,113800,21.87,21.87,21.83,21.86,6800);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.77,21.86,875900);
INSERT INTO intraday_data VALUES('WFMI',20070827113800,20070827,113800,45.76,45.76,45.71,45.74,3700);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.74,1587046);
INSERT INTO intraday_data VALUES('WFR',20070827113800,20070827,113800,58.42,58.47,58.42,58.47,2200);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.35,58.47,452200);
INSERT INTO intraday_data VALUES('WFT',20070827113800,20070827,113800,55.86,55.87,55.78,55.80,9100);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.69,55.80,873600);
INSERT INTO intraday_data VALUES('WHQ',20070827113800,20070827,113800,61.02,61.02,61.01,61.01,500);
DELETE FROM eod_data WHERE `ticker` = "WHQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WHQ',20070827,61.80,62.05,60.52,61.01,60300);
INSERT INTO intraday_data VALUES('WLP',20070827113800,20070827,113800,78.40,78.40,78.39,78.40,4500);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.54,77.89,78.40,829200);
INSERT INTO intraday_data VALUES('WNR',20070827113800,20070827,113800,52.05,52.05,52.03,52.03,1500);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,52.00,52.03,306500);
INSERT INTO intraday_data VALUES('WSO',20070827113800,20070827,113800,48.27,48.27,48.27,48.27,500);
DELETE FROM eod_data WHERE `ticker` = "WSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WSO',20070827,48.88,49.10,48.01,48.27,35800);
INSERT INTO intraday_data VALUES('X',20070827113800,20070827,113800,93.42,93.42,93.26,93.30,4500);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,93.30,1414504);
INSERT INTO intraday_data VALUES('YHOO',20070827113800,20070827,113800,23.28,23.30,23.26,23.30,72995);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.24,23.30,4841316);