INSERT INTO intraday_data VALUES('$DJUSAR',20070827141700,20070827,141700,120.12,120.12,120.12,120.12,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAR',20070827,122.46,122.46,119.99,120.12,0);
INSERT INTO intraday_data VALUES('$DJUSAT',20070827141700,20070827,141700,255.61,255.61,255.61,255.61,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.61,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827141700,20070827,141700,271.27,271.27,271.18,271.20,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBM',20070827,272.06,272.76,269.04,271.20,0);
INSERT INTO intraday_data VALUES('$DJUSCL',20070827141700,20070827,141700,259.70,259.70,259.70,259.70,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCL',20070827,265.08,265.08,257.04,259.70,0);
INSERT INTO intraday_data VALUES('$DJUSCP',20070827141700,20070827,141700,191.36,191.36,191.36,191.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCP',20070827,192.56,192.93,189.99,191.36,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827141700,20070827,141700,335.60,335.60,335.57,335.57,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.57,0);
INSERT INTO intraday_data VALUES('$DJUSEC',20070827141700,20070827,141700,155.46,155.46,155.46,155.46,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEC',20070827,156.20,156.21,154.89,155.46,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827141700,20070827,141700,596.77,596.77,596.49,596.49,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.62,596.49,0);
INSERT INTO intraday_data VALUES('$DJUSFB',20070827141700,20070827,141700,285.89,285.89,285.89,285.89,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFB',20070827,285.82,285.89,284.79,285.89,0);
INSERT INTO intraday_data VALUES('$DJUSFI',20070827141700,20070827,141700,657.38,657.38,657.38,657.38,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFI',20070827,664.66,664.66,655.51,657.38,0);
INSERT INTO intraday_data VALUES('$DJUSFS',20070827141700,20070827,141700,247.93,247.93,247.93,247.93,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFS',20070827,239.54,250.30,239.14,247.93,0);
INSERT INTO intraday_data VALUES('$DJUSGI',20070827141700,20070827,141700,435.72,435.72,435.72,435.72,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.72,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827141700,20070827,141700,343.43,343.43,343.38,343.38,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHC',20070827,343.94,344.09,342.97,343.38,0);
INSERT INTO intraday_data VALUES('$DJUSHP',20070827141700,20070827,141700,564.02,564.02,564.02,564.02,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHP',20070827,565.39,565.78,562.76,564.02,0);
INSERT INTO intraday_data VALUES('$DJUSHV',20070827141700,20070827,141700,543.05,543.05,543.05,543.05,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHV',20070827,524.94,544.42,523.34,543.05,0);
INSERT INTO intraday_data VALUES('$DJUSIF',20070827141700,20070827,141700,451.56,451.56,451.56,451.56,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIF',20070827,454.00,454.00,450.35,451.56,0);
INSERT INTO intraday_data VALUES('$DJUSIM',20070827141700,20070827,141700,413.80,413.80,413.80,413.80,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIM',20070827,415.30,418.66,409.61,413.80,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827141700,20070827,141700,351.45,351.45,351.36,351.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIN',20070827,352.45,352.45,349.76,351.36,0);
INSERT INTO intraday_data VALUES('$DJUSIQ',20070827141700,20070827,141700,890.63,890.63,890.63,890.63,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIQ',20070827,888.35,891.00,883.63,890.63,0);
INSERT INTO intraday_data VALUES('$DJUSIX',20070827141700,20070827,141700,413.53,413.53,413.53,413.53,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIX',20070827,415.71,415.71,412.45,413.53,0);
INSERT INTO intraday_data VALUES('$DJUSMC',20070827141700,20070827,141700,452.45,452.45,452.45,452.45,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMC',20070827,453.16,453.33,451.63,452.45,0);
INSERT INTO intraday_data VALUES('$DJUSMS',20070827141700,20070827,141700,383.30,383.30,383.30,383.30,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMS',20070827,382.69,384.11,382.69,383.30,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827141700,20070827,141700,308.98,308.98,308.91,308.91,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.91,0);
INSERT INTO intraday_data VALUES('$DJUSPB',20070827141700,20070827,141700,292.00,292.00,292.00,292.00,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPB',20070827,291.86,292.07,290.89,292.00,0);
INSERT INTO intraday_data VALUES('$DJUSPG',20070827141700,20070827,141700,264.72,264.72,264.72,264.72,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPG',20070827,268.57,268.57,264.50,264.72,0);
INSERT INTO intraday_data VALUES('$DJUSPP',20070827141700,20070827,141700,147.46,147.46,147.46,147.46,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPP',20070827,145.73,147.77,145.29,147.46,0);
INSERT INTO intraday_data VALUES('$DJUSPR',20070827141700,20070827,141700,276.92,276.92,276.92,276.92,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPR',20070827,277.75,277.75,276.46,276.92,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827141700,20070827,141700,406.98,406.98,406.65,406.65,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRH',20070827,410.12,410.12,403.97,406.65,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827141700,20070827,141700,115.93,115.93,115.91,115.91,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRI',20070827,117.28,117.34,115.40,115.91,0);
INSERT INTO intraday_data VALUES('$DJUSST',20070827141700,20070827,141700,365.66,365.66,365.66,365.66,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSST',20070827,354.68,370.62,354.68,365.66,0);
INSERT INTO intraday_data VALUES('$DJUSSV',20070827141700,20070827,141700,655.12,655.12,655.12,655.12,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSV',20070827,654.61,655.80,652.29,655.12,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827141700,20070827,141700,614.33,614.33,614.25,614.25,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,611.64,614.25,0);
INSERT INTO intraday_data VALUES('$DJUSTK',20070827141700,20070827,141700,330.34,330.34,330.34,330.34,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTK',20070827,331.69,332.09,329.14,330.34,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827141700,20070827,141700,187.10,187.10,187.09,187.09,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.96,186.26,187.09,0);
INSERT INTO intraday_data VALUES('$DJUSTQ',20070827141700,20070827,141700,595.60,595.60,595.60,595.60,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTQ',20070827,597.26,597.26,592.81,595.60,0);
INSERT INTO intraday_data VALUES('$DJUSUO',20070827141700,20070827,141700,144.25,144.25,144.25,144.25,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUO',20070827,147.47,147.47,143.64,144.25,0);
INSERT INTO intraday_data VALUES('$DJUSVN',20070827141700,20070827,141700,117.68,117.68,117.68,117.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSVN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSVN',20070827,117.91,118.58,117.27,117.68,0);
INSERT INTO intraday_data VALUES('$DJUSWC',20070827141700,20070827,141700,404.36,404.36,404.36,404.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWC',20070827,402.90,405.13,401.97,404.36,0);
INSERT INTO intraday_data VALUES('$DJUSWU',20070827141700,20070827,141700,768.54,768.54,768.54,768.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWU',20070827,774.49,781.10,765.24,768.54,0);
INSERT INTO intraday_data VALUES('$INX',20070827141700,20070827,141700,1471.89,1471.89,1471.48,1471.48,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1471.48,0);
INSERT INTO intraday_data VALUES('$IUX',20070827141700,20070827,141700,791.98,791.98,791.90,791.90,0);
DELETE FROM eod_data WHERE `ticker` = "$IUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IUX',20070827,797.78,797.78,788.57,791.90,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827141700,20070827,141700,9554.52,9554.52,9552.59,9552.59,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,9552.59,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827141700,20070827,141700,686.56,686.56,686.35,686.36,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.36,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827141700,20070827,141700,417.34,417.34,417.29,417.29,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,417.29,0);
INSERT INTO intraday_data VALUES('AAPL',20070827141700,20070827,141700,133.46,133.50,133.40,133.43,27785);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.43,17728680);
INSERT INTO intraday_data VALUES('ADSK',20070827141700,20070827,141700,45.47,45.47,45.45,45.47,1700);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.60,44.75,45.47,877927);
INSERT INTO intraday_data VALUES('ADS',20070827141700,20070827,141700,76.65,76.67,76.65,76.67,1700);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.43,76.67,399900);
INSERT INTO intraday_data VALUES('AET',20070827141700,20070827,141700,50.11,50.13,50.10,50.13,9000);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.23,49.68,50.13,1941100);
INSERT INTO intraday_data VALUES('ALB',20070827141700,20070827,141700,38.61,38.61,38.57,38.57,1200);
DELETE FROM eod_data WHERE `ticker` = "ALB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ALB',20070827,38.51,38.66,37.97,38.57,354900);
INSERT INTO intraday_data VALUES('AMD',20070827141700,20070827,141700,12.10,12.11,12.10,12.10,16000);
DELETE FROM eod_data WHERE `ticker` = "AMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMD',20070827,12.08,12.25,11.96,12.10,10497475);
INSERT INTO intraday_data VALUES('AMTD',20070827141700,20070827,141700,17.73,17.74,17.67,17.67,49480);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.78,17.40,17.67,1561279);
INSERT INTO intraday_data VALUES('AMX',20070827141700,20070827,141700,60.70,60.71,60.69,60.70,1400);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.76,60.06,60.70,1845900);
INSERT INTO intraday_data VALUES('AOB',20070827141700,20070827,141700,9.42,9.42,9.41,9.42,1100);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.46,9.03,9.42,1014300);
INSERT INTO intraday_data VALUES('AZN',20070827141700,20070827,141700,48.32,48.36,48.32,48.35,5400);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.15,48.35,428800);
INSERT INTO intraday_data VALUES('BA',20070827141700,20070827,141700,98.82,98.84,98.82,98.82,6300);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.84,97.13,98.82,1960705);
INSERT INTO intraday_data VALUES('BBY',20070827141700,20070827,141700,43.79,43.80,43.78,43.79,3600);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.70,43.79,2347415);
INSERT INTO intraday_data VALUES('BEN',20070827141700,20070827,141700,133.07,133.07,132.95,132.95,1600);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,132.51,132.95,463716);
INSERT INTO intraday_data VALUES('BHI',20070827141700,20070827,141700,80.96,80.97,80.89,80.89,1900);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,79.96,80.89,1411605);
INSERT INTO intraday_data VALUES('BHP',20070827141700,20070827,141700,62.27,62.27,62.23,62.23,900);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,62.23,840490);
INSERT INTO intraday_data VALUES('BIDU',20070827141700,20070827,141700,212.42,212.43,212.10,212.22,5004);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,212.49,200.55,212.22,3461242);
INSERT INTO intraday_data VALUES('BR',20070827141700,20070827,141700,17.80,17.81,17.80,17.81,300);
DELETE FROM eod_data WHERE `ticker` = "BR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BR',20070827,17.77,17.90,17.63,17.81,341460);
INSERT INTO intraday_data VALUES('BTU',20070827141700,20070827,141700,41.52,41.53,41.47,41.47,5900);
DELETE FROM eod_data WHERE `ticker` = "BTU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BTU',20070827,42.44,42.56,41.19,41.47,2280392);
INSERT INTO intraday_data VALUES('BZH',20070827141700,20070827,141700,9.70,9.71,9.69,9.69,1000);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.69,1482800);
INSERT INTO intraday_data VALUES('CCJ',20070827141700,20070827,141700,40.14,40.14,40.14,40.14,500);
DELETE FROM eod_data WHERE `ticker` = "CCJ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CCJ',20070827,40.33,40.49,39.71,40.14,1616262);
INSERT INTO intraday_data VALUES('CEG',20070827141700,20070827,141700,83.98,84.11,83.98,84.10,8900);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.37,84.10,1110400);
INSERT INTO intraday_data VALUES('CELG',20070827141700,20070827,141700,59.61,59.63,59.60,59.63,2550);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.84,59.26,59.63,1396216);
INSERT INTO intraday_data VALUES('CEPH',20070827141700,20070827,141700,73.34,73.36,73.33,73.36,1000);
DELETE FROM eod_data WHERE `ticker` = "CEPH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEPH',20070827,73.75,74.17,73.05,73.36,402721);
INSERT INTO intraday_data VALUES('CHAP',20070827141700,20070827,141700,85.39,85.39,85.39,85.39,1300);
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,339587);
INSERT INTO intraday_data VALUES('CHRW',20070827141700,20070827,141700,49.19,49.21,49.15,49.17,1421);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.17,297819);
INSERT INTO intraday_data VALUES('CI',20070827141700,20070827,141700,49.92,49.93,49.90,49.91,2800);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.74,49.91,1010992);
INSERT INTO intraday_data VALUES('CME',20070827141700,20070827,141700,559.27,559.27,559.23,559.23,500);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.87,556.00,559.23,368614);
INSERT INTO intraday_data VALUES('CMI',20070827141700,20070827,141700,115.86,115.93,115.82,115.82,2000);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,114.97,115.82,624600);
INSERT INTO intraday_data VALUES('COG',20070827141700,20070827,141700,32.70,32.70,32.66,32.66,3200);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.66,323400);
INSERT INTO intraday_data VALUES('CSCO',20070827141700,20070827,141700,30.97,30.98,30.96,30.96,41289);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.96,27580955);
INSERT INTO intraday_data VALUES('CTRP',20070827141700,20070827,141700,43.71,43.71,43.71,43.71,300);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.71,665186);
INSERT INTO intraday_data VALUES('CTSH',20070827141700,20070827,141700,72.93,72.93,72.92,72.92,765);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,72.92,1263697);
INSERT INTO intraday_data VALUES('CTX',20070827141700,20070827,141700,30.48,30.49,30.43,30.43,6500);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.28,30.43,2078134);
INSERT INTO intraday_data VALUES('CVH',20070827141700,20070827,141700,58.00,58.05,58.00,58.05,400);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,58.05,486700);
INSERT INTO intraday_data VALUES('DAVE',20070827141700,20070827,141700,19.85,19.85,19.85,19.85,100);
DELETE FROM eod_data WHERE `ticker` = "DAVE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DAVE',20070827,19.20,19.88,19.14,19.85,41152);
INSERT INTO intraday_data VALUES('DRQ',20070827141700,20070827,141700,44.94,44.94,44.94,44.94,600);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.58,44.94,151100);
INSERT INTO intraday_data VALUES('EBAY',20070827141700,20070827,141700,33.74,33.74,33.70,33.70,23900);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.70,5222183);
INSERT INTO intraday_data VALUES('EGY',20070827141700,20070827,141700,3.73,3.73,3.73,3.73,800);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.73,220500);
INSERT INTO intraday_data VALUES('EOG',20070827141700,20070827,141700,66.96,66.99,66.94,66.99,2500);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.99,1100950);
INSERT INTO intraday_data VALUES('ESRX',20070827141700,20070827,141700,54.88,54.88,54.87,54.87,1500);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.87,644834);
INSERT INTO intraday_data VALUES('ESV',20070827141700,20070827,141700,57.37,57.37,57.28,57.28,4200);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.54,57.28,879200);
INSERT INTO intraday_data VALUES('EXPD',20070827141700,20070827,141700,45.37,45.37,45.33,45.34,1400);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.72,45.01,45.34,434716);
INSERT INTO intraday_data VALUES('EXP',20070827141700,20070827,141700,38.30,38.30,38.30,38.30,400);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.03,38.30,380500);
INSERT INTO intraday_data VALUES('FMD',20070827141700,20070827,141700,35.34,35.34,35.33,35.34,600);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.58,35.02,35.34,329100);
INSERT INTO intraday_data VALUES('FRX',20070827141700,20070827,141700,37.24,37.26,37.24,37.24,800);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.24,1583400);
INSERT INTO intraday_data VALUES('FTI',20070827141700,20070827,141700,90.90,90.90,90.84,90.84,700);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,89.69,90.84,385100);
INSERT INTO intraday_data VALUES('GES',20070827141700,20070827,141700,49.92,49.93,49.90,49.93,1100);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.27,49.93,460219);
INSERT INTO intraday_data VALUES('GILD',20070827141700,20070827,141700,36.95,36.95,36.93,36.94,10300);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.75,36.94,2704435);
INSERT INTO intraday_data VALUES('GNA',20070827141700,20070827,141700,11.86,11.86,11.85,11.85,1900);
DELETE FROM eod_data WHERE `ticker` = "GNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GNA',20070827,12.07,12.29,11.76,11.85,353100);
INSERT INTO intraday_data VALUES('GRMN',20070827141700,20070827,141700,102.51,102.51,102.50,102.50,800);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,102.50,1655011);
INSERT INTO intraday_data VALUES('GS',20070827141700,20070827,141700,178.35,178.42,178.35,178.35,10700);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.45,178.35,4679442);
INSERT INTO intraday_data VALUES('HOC',20070827141700,20070827,141700,65.24,65.24,65.19,65.23,1500);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,65.23,492975);
INSERT INTO intraday_data VALUES('HOG',20070827141700,20070827,141700,54.23,54.25,54.22,54.24,2300);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.24,1144863);
INSERT INTO intraday_data VALUES('HPC',20070827141700,20070827,141700,21.29,21.30,21.29,21.29,1700);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.25,21.29,907387);
INSERT INTO intraday_data VALUES('HXM',20070827141700,20070827,141700,53.59,53.60,53.59,53.60,1100);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.60,197200);
INSERT INTO intraday_data VALUES('ICE',20070827141700,20070827,141700,140.78,140.78,140.50,140.63,1300);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.69,140.63,622900);
INSERT INTO intraday_data VALUES('INFY',20070827141700,20070827,141700,46.50,46.50,46.44,46.44,1860);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.19,46.44,847296);
INSERT INTO intraday_data VALUES('IVGN',20070827141700,20070827,141700,79.03,79.03,79.03,79.03,200);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,79.22,77.95,79.03,223104);
INSERT INTO intraday_data VALUES('JCI',20070827141700,20070827,141700,112.15,112.21,112.15,112.21,200);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.21,112.21,265985);
INSERT INTO intraday_data VALUES('JEC',20070827141700,20070827,141700,64.52,64.52,64.52,64.52,900);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.85,64.52,344500);
INSERT INTO intraday_data VALUES('JOYG',20070827141700,20070827,141700,48.11,48.11,48.07,48.08,3540);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.08,1036344);
INSERT INTO intraday_data VALUES('JWN',20070827141700,20070827,141700,48.17,48.18,48.16,48.17,2700);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,47.94,48.17,2139000);
INSERT INTO intraday_data VALUES('KCI',20070827141700,20070827,141700,62.10,62.10,62.10,62.10,1700);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,61.50,62.10,435900);
INSERT INTO intraday_data VALUES('KEP',20070827141700,20070827,141700,22.09,22.09,22.09,22.09,1400);
DELETE FROM eod_data WHERE `ticker` = "KEP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KEP',20070827,22.09,22.20,21.86,22.09,254600);
INSERT INTO intraday_data VALUES('KG',20070827141700,20070827,141700,15.76,15.76,15.75,15.75,1400);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.78,15.52,15.75,856285);
INSERT INTO intraday_data VALUES('KSS',20070827141700,20070827,141700,57.58,57.58,57.51,57.52,6600);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,57.23,57.52,3305100);
INSERT INTO intraday_data VALUES('LMT',20070827141700,20070827,141700,101.83,101.85,101.82,101.84,2800);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.95,99.12,101.84,1342490);
INSERT INTO intraday_data VALUES('LRCX',20070827141700,20070827,141700,53.65,53.69,53.65,53.69,3143);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.87,53.69,1333408);
INSERT INTO intraday_data VALUES('LVS',20070827141700,20070827,141700,98.91,98.92,98.86,98.87,1800);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,98.87,1920325);
INSERT INTO intraday_data VALUES('MCD',20070827141700,20070827,141700,49.41,49.42,49.40,49.41,8600);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.40,49.41,2871512);
INSERT INTO intraday_data VALUES('MESA',20070827141700,20070827,141700,5.96,5.96,5.96,5.96,100);
DELETE FROM eod_data WHERE `ticker` = "MESA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MESA',20070827,5.86,6.06,5.81,5.96,179868);
INSERT INTO intraday_data VALUES('MGM',20070827141700,20070827,141700,82.36,82.36,82.20,82.20,5800);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.20,747100);
INSERT INTO intraday_data VALUES('MLM',20070827141700,20070827,141700,131.59,131.59,131.53,131.56,600);
DELETE FROM eod_data WHERE `ticker` = "MLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MLM',20070827,134.34,135.00,131.11,131.56,266300);
INSERT INTO intraday_data VALUES('MOS',20070827141700,20070827,141700,40.62,40.63,40.59,40.63,2200);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.63,1161500);
INSERT INTO intraday_data VALUES('MRVL',20070827141700,20070827,141700,15.50,15.50,15.49,15.49,16175);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.49,14145100);
INSERT INTO intraday_data VALUES('MSFT',20070827141700,20070827,141700,28.58,28.58,28.56,28.56,28309);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.40,28.56,16656259);
INSERT INTO intraday_data VALUES('MTW',20070827141700,20070827,141700,76.60,76.60,76.56,76.58,500);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.58,432900);
INSERT INTO intraday_data VALUES('NEU',20070827141700,20070827,141700,47.75,47.75,47.74,47.74,300);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,46.84,47.74,109200);
INSERT INTO intraday_data VALUES('NFLX',20070827141700,20070827,141700,17.36,17.36,17.36,17.36,100);
DELETE FROM eod_data WHERE `ticker` = "NFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFLX',20070827,17.74,17.85,17.31,17.36,276313);
INSERT INTO intraday_data VALUES('NFX',20070827141700,20070827,141700,43.93,43.94,43.90,43.94,3700);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.28,43.94,739328);
INSERT INTO intraday_data VALUES('NOV',20070827141700,20070827,141700,120.25,120.25,120.14,120.14,4900);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,120.14,1429721);
INSERT INTO intraday_data VALUES('NTES',20070827141700,20070827,141700,16.31,16.31,16.29,16.29,1330);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.12,16.29,606975);
INSERT INTO intraday_data VALUES('NUE',20070827141700,20070827,141700,53.89,53.90,53.80,53.82,9500);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.42,53.82,3239866);
INSERT INTO intraday_data VALUES('NVDA',20070827141700,20070827,141700,49.56,49.59,49.52,49.59,29600);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.59,6252829);
INSERT INTO intraday_data VALUES('NYX',20070827141700,20070827,141700,73.90,73.92,73.88,73.88,1900);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.59,73.88,1170931);
INSERT INTO intraday_data VALUES('OCR',20070827141700,20070827,141700,33.07,33.07,33.04,33.04,2300);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.08,32.66,33.04,586200);
INSERT INTO intraday_data VALUES('ORCL',20070827141700,20070827,141700,19.95,19.96,19.95,19.95,4975);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.95,11772306);
INSERT INTO intraday_data VALUES('OXY',20070827141700,20070827,141700,56.71,56.71,56.64,56.65,6300);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.73,56.00,56.65,1642500);
INSERT INTO intraday_data VALUES('PCLN',20070827141700,20070827,141700,81.02,81.25,81.02,81.23,2400);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.41,81.23,337212);
INSERT INTO intraday_data VALUES('PCP',20070827141700,20070827,141700,138.75,138.75,138.61,138.61,3500);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.94,136.13,138.61,625000);
INSERT INTO intraday_data VALUES('PCR',20070827141700,20070827,141700,55.67,55.67,55.55,55.55,700);
DELETE FROM eod_data WHERE `ticker` = "PCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCR',20070827,56.99,57.96,54.84,55.55,290700);
INSERT INTO intraday_data VALUES('POT',20070827141700,20070827,141700,85.40,85.40,85.36,85.38,3900);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.11,85.38,1199450);
INSERT INTO intraday_data VALUES('QQQQ',20070827141700,20070827,141700,48.08,48.08,48.07,48.07,71664);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,48.07,46892133);
INSERT INTO intraday_data VALUES('RIG',20070827141700,20070827,141700,102.79,102.85,102.67,102.74,8124);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.54,102.74,2567357);
INSERT INTO intraday_data VALUES('RIMM',20070827141700,20070827,141700,81.26,81.26,81.22,81.24,6960);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,81.24,4330834);
INSERT INTO intraday_data VALUES('RIO',20070827141700,20070827,141700,48.10,48.14,48.03,48.10,25300);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,48.14,47.09,48.10,7356083);
INSERT INTO intraday_data VALUES('RMD',20070827141700,20070827,141700,41.55,41.56,41.55,41.56,300);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.32,41.56,317305);
INSERT INTO intraday_data VALUES('RTP',20070827141700,20070827,141700,273.50,273.50,273.50,273.50,100);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,273.50,184200);
INSERT INTO intraday_data VALUES('SBUX',20070827141700,20070827,141700,27.47,27.48,27.47,27.48,3575);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.48,2653871);
INSERT INTO intraday_data VALUES('SII',20070827141700,20070827,141700,63.06,63.06,62.97,62.97,2700);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.02,62.97,870092);
INSERT INTO intraday_data VALUES('SNDK',20070827141700,20070827,141700,52.16,52.16,52.13,52.15,12776);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.05,52.15,5593845);
INSERT INTO intraday_data VALUES('SPG',20070827141700,20070827,141700,92.71,92.71,92.66,92.66,1800);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,92.66,522000);
INSERT INTO intraday_data VALUES('SPIL',20070827141700,20070827,141700,10.13,10.14,10.13,10.14,1100);
DELETE FROM eod_data WHERE `ticker` = "SPIL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPIL',20070827,10.26,10.26,10.00,10.14,574818);
INSERT INTO intraday_data VALUES('SPY',20070827141700,20070827,141700,147.45,147.47,147.38,147.40,184500);
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,64141910);
INSERT INTO intraday_data VALUES('STLD',20070827141700,20070827,141700,43.72,43.72,43.64,43.68,4000);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.68,770305);
INSERT INTO intraday_data VALUES('SYKE',20070827141700,20070827,141700,16.61,16.61,16.61,16.61,100);
DELETE FROM eod_data WHERE `ticker` = "SYKE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYKE',20070827,16.96,16.96,16.55,16.61,53907);
INSERT INTO intraday_data VALUES('THOR',20070827141700,20070827,141700,20.87,20.87,20.87,20.87,300);
DELETE FROM eod_data WHERE `ticker` = "THOR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('THOR',20070827,20.87,20.94,20.61,20.87,177323);
INSERT INTO intraday_data VALUES('TLM',20070827141700,20070827,141700,17.04,17.05,17.04,17.04,7100);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.95,17.04,1322782);
INSERT INTO intraday_data VALUES('TNB',20070827141700,20070827,141700,55.65,55.65,55.56,55.60,1700);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.60,315800);
INSERT INTO intraday_data VALUES('TOL',20070827141700,20070827,141700,22.10,22.10,22.08,22.08,5200);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.01,22.08,3027763);
INSERT INTO intraday_data VALUES('TRAD',20070827141700,20070827,141700,10.98,10.99,10.97,10.97,1637);
DELETE FROM eod_data WHERE `ticker` = "TRAD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRAD',20070827,10.88,10.99,10.70,10.97,185656);
INSERT INTO intraday_data VALUES('TRMB',20070827141700,20070827,141700,36.52,36.52,36.52,36.52,400);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.52,400713);
INSERT INTO intraday_data VALUES('TSO',20070827141700,20070827,141700,49.70,49.70,49.63,49.63,2400);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.63,1709400);
INSERT INTO intraday_data VALUES('TXU',20070827141700,20070827,141700,66.04,66.04,66.02,66.02,3300);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.73,66.02,3994800);
INSERT INTO intraday_data VALUES('UA',20070827141700,20070827,141700,63.79,63.85,63.79,63.83,800);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,63.83,571400);
INSERT INTO intraday_data VALUES('UNH',20070827141700,20070827,141700,49.44,49.44,49.41,49.41,13600);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.23,49.41,2675780);
INSERT INTO intraday_data VALUES('USG',20070827141700,20070827,141700,37.76,37.76,37.71,37.74,1900);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.65,37.74,420800);
INSERT INTO intraday_data VALUES('VIP',20070827141700,20070827,141700,22.82,22.83,22.80,22.83,800);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.87,22.08,22.83,1172530);
INSERT INTO intraday_data VALUES('VLO',20070827141700,20070827,141700,67.74,67.74,67.61,67.63,9500);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.63,3430894);
INSERT INTO intraday_data VALUES('WFR',20070827141700,20070827,141700,58.49,58.49,58.42,58.42,1400);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.21,58.42,817700);
INSERT INTO intraday_data VALUES('WFT',20070827141700,20070827,141700,56.34,56.35,56.32,56.32,4200);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.45,56.32,1649100);
INSERT INTO intraday_data VALUES('WLP',20070827141700,20070827,141700,78.47,78.50,78.47,78.50,1500);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.63,77.89,78.50,1436000);
INSERT INTO intraday_data VALUES('WNR',20070827141700,20070827,141700,52.19,52.20,52.18,52.20,900);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,52.20,522000);
INSERT INTO intraday_data VALUES('WSO',20070827141700,20070827,141700,48.15,48.15,48.14,48.14,400);
DELETE FROM eod_data WHERE `ticker` = "WSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WSO',20070827,48.88,49.10,47.86,48.14,80100);
INSERT INTO intraday_data VALUES('YHOO',20070827141700,20070827,141700,23.19,23.21,23.19,23.20,50258);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.16,23.20,9710618);
INSERT INTO intraday_data VALUES('$COMPX',20070827141700,20070827,141700,2568.46,2568.46,2568.12,2568.12,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2568.12,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827141700,20070827,141700,547.06,547.06,546.94,546.94,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFN',20070827,552.10,552.10,545.68,546.94,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827141700,20070827,141700,283.75,283.75,283.70,283.70,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRE',20070827,287.10,287.12,282.47,283.70,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827141700,20070827,141700,1335.12,1335.18,1335.12,1335.15,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1327.39,1335.15,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827141700,20070827,141700,186.47,186.47,186.46,186.46,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUT',20070827,191.11,191.11,185.49,186.46,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827141700,20070827,141700,137.43,137.43,137.41,137.43,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.43,0);
INSERT INTO intraday_data VALUES('$IDX',20070827141700,20070827,141700,857.98,857.98,857.73,857.73,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,857.73,0);
INSERT INTO intraday_data VALUES('$INDU',20070827141700,20070827,141700,13361.23,13361.56,13356.27,13356.68,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13378.63,13305.87,13356.68,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827141700,20070827,141700,732.33,732.33,732.04,732.04,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,732.04,0);
INSERT INTO intraday_data VALUES('$VIX',20070827141700,20070827,141700,22.18,22.22,22.18,22.22,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',20070827141700,20070827,141700,10.34,10.35,10.33,10.33,12500);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.13,10.33,1195406);
INSERT INTO intraday_data VALUES('ACLI',20070827141700,20070827,141700,24.03,24.03,24.02,24.02,300);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,24.02,386178);
INSERT INTO intraday_data VALUES('ACL',20070827141700,20070827,141700,133.37,133.37,133.28,133.28,1000);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.28,254300);
INSERT INTO intraday_data VALUES('ADM',20070827141700,20070827,141700,32.95,32.96,32.94,32.94,6500);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.69,32.94,2181615);
INSERT INTO intraday_data VALUES('AIRM',20070827141700,20070827,141700,41.07,41.12,41.00,41.01,931);
DELETE FROM eod_data WHERE `ticker` = "AIRM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AIRM',20070827,41.25,42.09,40.44,41.01,71946);
INSERT INTO intraday_data VALUES('AMZN',20070827141700,20070827,141700,79.61,79.61,79.56,79.56,4260);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.56,4655128);
INSERT INTO intraday_data VALUES('ANF',20070827141700,20070827,141700,79.72,79.72,79.65,79.69,2800);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,79.69,1142500);
INSERT INTO intraday_data VALUES('APA',20070827141700,20070827,141700,75.53,75.53,75.48,75.48,8700);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.12,75.48,1562600);
INSERT INTO intraday_data VALUES('APH',20070827141700,20070827,141700,35.02,35.02,35.01,35.01,1100);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,35.01,425637);
INSERT INTO intraday_data VALUES('BCSI',20070827141700,20070827,141700,84.71,84.75,84.66,84.74,1832);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,84.74,1847552);
INSERT INTO intraday_data VALUES('BDK',20070827141700,20070827,141700,87.27,87.27,87.27,87.27,300);
DELETE FROM eod_data WHERE `ticker` = "BDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BDK',20070827,87.69,88.27,86.99,87.27,226200);
INSERT INTO intraday_data VALUES('BG',20070827141700,20070827,141700,88.87,88.87,88.86,88.86,200);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,88.89,87.03,88.86,298700);
INSERT INTO intraday_data VALUES('BNI',20070827141700,20070827,141700,80.76,80.76,80.71,80.72,2400);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,81.00,79.68,80.72,4679232);
INSERT INTO intraday_data VALUES('BRCD',20070827141700,20070827,141700,7.00,7.00,6.99,7.00,15113);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,6.98,7.00,6220688);
INSERT INTO intraday_data VALUES('BRY',20070827141700,20070827,141700,33.55,33.55,33.54,33.54,500);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.30,33.54,103800);
INSERT INTO intraday_data VALUES('CAMP',20070827141700,20070827,141700,3.74,3.74,3.74,3.74,300);
DELETE FROM eod_data WHERE `ticker` = "CAMP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAMP',20070827,3.72,3.79,3.72,3.74,44197);
INSERT INTO intraday_data VALUES('CAM',20070827141700,20070827,141700,77.97,77.98,77.90,77.90,3800);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.90,618500);
INSERT INTO intraday_data VALUES('CBB',20070827141700,20070827,141700,4.99,4.99,4.98,4.98,5200);
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,557700);
INSERT INTO intraday_data VALUES('CERN',20070827141700,20070827,141700,56.53,56.56,56.53,56.56,601);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.25,56.56,162089);
INSERT INTO intraday_data VALUES('CFC',20070827141700,20070827,141700,20.00,20.00,19.99,20.00,37600);
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,32594591);
INSERT INTO intraday_data VALUES('CHINA',20070827141700,20070827,141700,8.43,8.44,8.43,8.43,2400);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.50,8.20,8.43,772559);
INSERT INTO intraday_data VALUES('CMC',20070827141700,20070827,141700,29.25,29.25,29.22,29.22,1000);
DELETE FROM eod_data WHERE `ticker` = "CMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMC',20070827,29.99,29.99,29.07,29.22,634800);
INSERT INTO intraday_data VALUES('COH',20070827141700,20070827,141700,43.29,43.29,43.21,43.23,5600);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.00,43.23,3044552);
INSERT INTO intraday_data VALUES('COP',20070827141700,20070827,141700,81.10,81.11,80.99,81.01,21800);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,81.13,80.02,81.01,4042000);
INSERT INTO intraday_data VALUES('CRDN',20070827141700,20070827,141700,70.24,70.24,70.22,70.22,400);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.66,70.22,315582);
INSERT INTO intraday_data VALUES('CRI',20070827141700,20070827,141700,20.14,20.14,20.14,20.14,500);
DELETE FROM eod_data WHERE `ticker` = "CRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRI',20070827,20.56,20.56,19.91,20.14,532000);
INSERT INTO intraday_data VALUES('CROX',20070827141700,20070827,141700,59.99,60.00,59.95,60.00,2100);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,60.00,5633431);
INSERT INTO intraday_data VALUES('CRS',20070827141700,20070827,141700,115.89,115.92,115.88,115.91,600);
DELETE FROM eod_data WHERE `ticker` = "CRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRS',20070827,114.59,117.20,114.34,115.91,207200);
INSERT INTO intraday_data VALUES('CXW',20070827141700,20070827,141700,25.39,25.40,25.37,25.37,2400);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.25,25.37,860400);
INSERT INTO intraday_data VALUES('CX',20070827141700,20070827,141700,31.35,31.35,31.34,31.34,5000);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.20,31.34,1497400);
INSERT INTO intraday_data VALUES('DIA',20070827141700,20070827,141700,133.55,133.55,133.50,133.51,13000);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.73,132.98,133.51,5158484);
INSERT INTO intraday_data VALUES('DNA',20070827141700,20070827,141700,73.19,73.19,73.17,73.17,500);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.05,73.17,872580);
INSERT INTO intraday_data VALUES('DRYS',20070827141700,20070827,141700,67.16,67.16,67.16,67.16,100);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.74,63.16,67.16,1735643);
INSERT INTO intraday_data VALUES('ENR',20070827141700,20070827,141700,107.65,107.65,107.57,107.57,400);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,107.57,439000);
INSERT INTO intraday_data VALUES('FDG',20070827141700,20070827,141700,32.88,32.88,32.87,32.87,400);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.97,32.05,32.87,307375);
INSERT INTO intraday_data VALUES('FFIV',20070827141700,20070827,141700,37.02,37.02,36.99,37.00,4308);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,37.00,674492);
INSERT INTO intraday_data VALUES('FLR',20070827141700,20070827,141700,125.95,125.95,125.83,125.83,2800);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,126.00,123.02,125.83,682875);
INSERT INTO intraday_data VALUES('FRK',20070827141700,20070827,141700,62.60,62.60,62.60,62.60,500);
DELETE FROM eod_data WHERE `ticker` = "FRK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRK',20070827,62.83,62.99,62.00,62.60,99300);
INSERT INTO intraday_data VALUES('GGB',20070827141700,20070827,141700,23.08,23.09,23.06,23.06,3900);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,23.06,922400);
INSERT INTO intraday_data VALUES('GOOG',20070827141700,20070827,141700,515.87,516.00,515.84,516.00,1750);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,516.00,1700161);
INSERT INTO intraday_data VALUES('GTI',20070827141700,20070827,141700,16.82,16.83,16.82,16.82,3200);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,16.82,1589947);
INSERT INTO intraday_data VALUES('HAL',20070827141700,20070827,141700,33.47,33.47,33.45,33.46,12300);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.23,33.46,7951174);
INSERT INTO intraday_data VALUES('HNR',20070827141700,20070827,141700,11.10,11.10,11.10,11.10,100);
DELETE FROM eod_data WHERE `ticker` = "HNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HNR',20070827,11.19,11.25,11.00,11.10,113600);
INSERT INTO intraday_data VALUES('HOV',20070827141700,20070827,141700,11.42,11.44,11.42,11.44,1000);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.30,11.44,1279644);
INSERT INTO intraday_data VALUES('IBM',20070827141700,20070827,141700,113.55,113.56,113.54,113.56,9300);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.85,112.80,113.56,2682302);
INSERT INTO intraday_data VALUES('INFA',20070827141700,20070827,141700,13.75,13.75,13.74,13.74,4500);
DELETE FROM eod_data WHERE `ticker` = "INFA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFA',20070827,13.83,13.85,13.69,13.74,389578);
INSERT INTO intraday_data VALUES('ISE',20070827141700,20070827,141700,66.01,66.01,66.01,66.01,100);
DELETE FROM eod_data WHERE `ticker` = "ISE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ISE',20070827,66.11,66.19,65.96,66.01,177103);
INSERT INTO intraday_data VALUES('JCP',20070827141700,20070827,141700,66.25,66.26,66.24,66.25,2700);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,66.25,1443400);
INSERT INTO intraday_data VALUES('KBH',20070827141700,20070827,141700,30.56,30.57,30.54,30.55,2600);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.41,30.55,1668400);
INSERT INTO intraday_data VALUES('LEH',20070827141700,20070827,141700,58.14,58.14,58.07,58.07,13800);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.06,58.07,5227779);
INSERT INTO intraday_data VALUES('MBT',20070827141700,20070827,141700,62.99,62.99,62.99,62.99,600);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,63.02,61.43,62.99,419400);
INSERT INTO intraday_data VALUES('MDC',20070827141700,20070827,141700,43.95,43.95,43.90,43.95,800);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,43.71,43.95,401300);
INSERT INTO intraday_data VALUES('MICC',20070827141700,20070827,141700,82.84,82.84,82.84,82.84,100);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.31,82.84,233721);
INSERT INTO intraday_data VALUES('MNT',20070827141700,20070827,141700,43.92,43.92,43.92,43.92,200);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.26,43.63,43.92,353259);
INSERT INTO intraday_data VALUES('MSTR',20070827141700,20070827,141700,73.44,73.44,73.44,73.44,600);
DELETE FROM eod_data WHERE `ticker` = "MSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSTR',20070827,75.96,76.50,73.22,73.44,160999);
INSERT INTO intraday_data VALUES('MT',20070827141700,20070827,141700,64.30,64.30,64.23,64.24,3600);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.50,64.24,1271760);
INSERT INTO intraday_data VALUES('NEM',20070827141700,20070827,141700,40.42,40.43,40.39,40.39,7700);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.30,40.39,2862300);
INSERT INTO intraday_data VALUES('OGE',20070827141700,20070827,141700,33.16,33.16,33.14,33.14,500);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.87,33.14,243500);
INSERT INTO intraday_data VALUES('OII',20070827141700,20070827,141700,64.97,64.97,64.96,64.96,1500);
DELETE FROM eod_data WHERE `ticker` = "OII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OII',20070827,65.35,65.45,64.01,64.96,208288);
INSERT INTO intraday_data VALUES('PBR',20070827141700,20070827,141700,59.25,59.26,59.23,59.25,17100);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.43,58.47,59.25,2031259);
INSERT INTO intraday_data VALUES('PCU',20070827141700,20070827,141700,103.85,103.85,103.73,103.73,3300);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,103.73,1329973);
INSERT INTO intraday_data VALUES('PMTI',20070827141700,20070827,141700,30.46,30.46,30.45,30.45,800);
DELETE FROM eod_data WHERE `ticker` = "PMTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PMTI',20070827,30.67,30.72,30.25,30.45,96705);
INSERT INTO intraday_data VALUES('PNK',20070827141700,20070827,141700,27.33,27.33,27.32,27.32,400);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.35,26.85,27.32,171700);
INSERT INTO intraday_data VALUES('PRFT',20070827141700,20070827,141700,23.41,23.41,23.41,23.41,100);
DELETE FROM eod_data WHERE `ticker` = "PRFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRFT',20070827,23.04,23.45,22.95,23.41,156266);
INSERT INTO intraday_data VALUES('PTNR',20070827141700,20070827,141700,15.41,15.41,15.41,15.41,200);
DELETE FROM eod_data WHERE `ticker` = "PTNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PTNR',20070827,15.30,15.45,15.25,15.41,158323);
INSERT INTO intraday_data VALUES('QDEL',20070827141700,20070827,141700,17.15,17.15,17.14,17.14,600);
DELETE FROM eod_data WHERE `ticker` = "QDEL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QDEL',20070827,17.33,17.40,17.06,17.14,185199);
INSERT INTO intraday_data VALUES('QSII',20070827141700,20070827,141700,37.98,37.98,37.98,37.98,300);
DELETE FROM eod_data WHERE `ticker` = "QSII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QSII',20070827,38.16,38.37,37.77,37.98,96402);
INSERT INTO intraday_data VALUES('RAI',20070827141700,20070827,141700,65.30,65.31,65.30,65.31,1000);
DELETE FROM eod_data WHERE `ticker` = "RAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RAI',20070827,65.60,65.99,65.10,65.31,516863);
INSERT INTO intraday_data VALUES('RL',20070827141700,20070827,141700,76.55,76.57,76.54,76.57,2000);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.52,76.57,664500);
INSERT INTO intraday_data VALUES('RYL',20070827141700,20070827,141700,30.09,30.10,30.07,30.08,2900);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,29.97,30.08,952681);
INSERT INTO intraday_data VALUES('SBGI',20070827141700,20070827,141700,12.41,12.41,12.41,12.41,1000);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.35,12.41,578198);
INSERT INTO intraday_data VALUES('SCI',20070827141700,20070827,141700,12.04,12.05,12.03,12.05,1700);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,11.96,12.05,755100);
INSERT INTO intraday_data VALUES('SCUR',20070827141700,20070827,141700,8.39,8.39,8.39,8.39,104);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.23,8.39,348375);
INSERT INTO intraday_data VALUES('SEIC',20070827141700,20070827,141700,25.81,25.81,25.77,25.77,2551);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.77,230354);
INSERT INTO intraday_data VALUES('SID',20070827141700,20070827,141700,53.97,53.99,53.86,53.86,2500);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.67,53.86,707700);
INSERT INTO intraday_data VALUES('SIMG',20070827141700,20070827,141700,5.89,5.89,5.89,5.89,400);
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,477152);
INSERT INTO intraday_data VALUES('SLB',20070827141700,20070827,141700,93.28,93.30,93.17,93.19,12700);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.03,93.19,2870100);
INSERT INTO intraday_data VALUES('SPF',20070827141700,20070827,141700,9.98,10.01,9.97,10.01,13500);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,10.01,1385000);
INSERT INTO intraday_data VALUES('SPN',20070827141700,20070827,141700,38.39,38.39,38.35,38.35,700);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.01,38.35,308000);
INSERT INTO intraday_data VALUES('SPWR',20070827141700,20070827,141700,62.33,62.33,62.33,62.33,100);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.05,62.33,594901);
INSERT INTO intraday_data VALUES('STR',20070827141700,20070827,141700,49.57,49.58,49.50,49.50,2400);
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,645000);
INSERT INTO intraday_data VALUES('SWKS',20070827141700,20070827,141700,7.69,7.70,7.69,7.69,1378);
DELETE FROM eod_data WHERE `ticker` = "SWKS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWKS',20070827,7.88,7.95,7.67,7.69,1074132);
INSERT INTO intraday_data VALUES('SWN',20070827141700,20070827,141700,37.65,37.67,37.65,37.67,1400);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.67,1089200);
INSERT INTO intraday_data VALUES('SYK',20070827141700,20070827,141700,67.40,67.40,67.38,67.38,500);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.09,67.38,425332);
INSERT INTO intraday_data VALUES('TDW',20070827141700,20070827,141700,65.40,65.42,65.33,65.33,900);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.48,64.45,65.33,598015);
INSERT INTO intraday_data VALUES('TEX',20070827141700,20070827,141700,78.47,78.47,78.36,78.36,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.36,705100);
INSERT INTO intraday_data VALUES('TOPT',20070827141700,20070827,141700,5.72,5.72,5.72,5.72,400);
DELETE FROM eod_data WHERE `ticker` = "TOPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOPT',20070827,5.84,5.84,5.65,5.72,217273);
INSERT INTO intraday_data VALUES('TSN',20070827141700,20070827,141700,21.28,21.29,21.28,21.28,2300);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.21,21.28,850205);
INSERT INTO intraday_data VALUES('TS',20070827141700,20070827,141700,46.74,46.77,46.73,46.77,11400);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.77,1773200);
INSERT INTO intraday_data VALUES('UFPI',20070827141700,20070827,141700,38.41,38.41,38.41,38.41,100);
DELETE FROM eod_data WHERE `ticker` = "UFPI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UFPI',20070827,38.17,38.87,37.74,38.41,57287);
INSERT INTO intraday_data VALUES('UPL',20070827141700,20070827,141700,54.61,54.62,54.59,54.62,500);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.62,505000);
INSERT INTO intraday_data VALUES('URBN',20070827141700,20070827,141700,22.68,22.69,22.67,22.69,1409);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.69,1406483);
INSERT INTO intraday_data VALUES('VIVO',20070827141700,20070827,141700,25.27,25.27,25.27,25.27,100);
DELETE FROM eod_data WHERE `ticker` = "VIVO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIVO',20070827,25.53,25.54,25.03,25.27,56390);
INSERT INTO intraday_data VALUES('WCC',20070827141700,20070827,141700,48.02,48.02,48.02,48.02,400);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,47.75,48.02,253194);
INSERT INTO intraday_data VALUES('WDC',20070827141700,20070827,141700,21.95,21.95,21.91,21.91,3000);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.77,21.91,1281400);
INSERT INTO intraday_data VALUES('WFMI',20070827141700,20070827,141700,45.75,45.76,45.75,45.75,2400);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.75,2169780);
INSERT INTO intraday_data VALUES('WHQ',20070827141700,20070827,141700,61.95,61.95,61.94,61.94,800);
DELETE FROM eod_data WHERE `ticker` = "WHQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WHQ',20070827,61.80,62.05,60.52,61.94,149000);
INSERT INTO intraday_data VALUES('XING',20070827141700,20070827,141700,9.03,9.03,9.03,9.03,100);
DELETE FROM eod_data WHERE `ticker` = "XING" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('XING',20070827,8.98,9.38,8.83,9.03,317865);
INSERT INTO intraday_data VALUES('X',20070827141700,20070827,141700,93.58,93.62,93.54,93.62,6300);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,93.62,2134304);