INSERT INTO intraday_data VALUES('$COMPX',20070827141200,20070827,141200,2566.52,2566.52,2566.31,2566.31,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2566.31,0);
INSERT INTO intraday_data VALUES('$DJUSAR',20070827141200,20070827,141200,120.05,120.05,120.05,120.05,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.05,0);
INSERT INTO intraday_data VALUES('$DJUSBE',20070827141200,20070827,141200,125.84,125.84,125.84,125.84,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.84,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827141200,20070827,141200,270.95,270.97,270.86,270.86,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBM',20070827,272.06,272.76,269.04,270.86,0);
INSERT INTO intraday_data VALUES('$DJUSCL',20070827141200,20070827,141200,259.00,259.00,259.00,259.00,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.00,0);
INSERT INTO intraday_data VALUES('$DJUSCP',20070827141200,20070827,141200,191.07,191.07,191.07,191.07,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.07,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827141200,20070827,141200,335.32,335.33,335.32,335.33,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.33,0);
INSERT INTO intraday_data VALUES('$DJUSDS',20070827141200,20070827,141200,142.84,142.84,142.84,142.84,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDS',20070827,142.84,143.40,142.18,142.84,0);
INSERT INTO intraday_data VALUES('$DJUSEC',20070827141200,20070827,141200,155.33,155.33,155.33,155.33,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.33,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827141200,20070827,141200,595.92,595.93,595.65,595.75,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.62,595.75,0);
INSERT INTO intraday_data VALUES('$DJUSFA',20070827141200,20070827,141200,126.85,126.85,126.85,126.85,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFA',20070827,127.53,127.53,126.74,126.85,0);
INSERT INTO intraday_data VALUES('$DJUSFB',20070827141200,20070827,141200,285.72,285.72,285.72,285.72,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFB',20070827,285.82,285.88,284.79,285.72,0);
INSERT INTO intraday_data VALUES('$DJUSFI',20070827141200,20070827,141200,656.74,656.74,656.74,656.74,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFI',20070827,664.66,664.66,655.51,656.74,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827141200,20070827,141200,546.78,546.78,546.57,546.65,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.65,0);
INSERT INTO intraday_data VALUES('$DJUSFS',20070827141200,20070827,141200,247.71,247.71,247.71,247.71,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.71,0);
INSERT INTO intraday_data VALUES('$DJUSGF',20070827141200,20070827,141200,795.60,795.60,795.60,795.60,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGF',20070827,804.70,804.70,794.02,795.60,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827141200,20070827,141200,343.22,343.23,343.19,343.22,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.22,0);
INSERT INTO intraday_data VALUES('$DJUSHP',20070827141200,20070827,141200,563.53,563.53,563.53,563.53,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHP',20070827,565.39,565.78,562.76,563.53,0);
INSERT INTO intraday_data VALUES('$DJUSHV',20070827141200,20070827,141200,542.33,542.33,542.33,542.33,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHV',20070827,524.94,544.42,523.34,542.33,0);
INSERT INTO intraday_data VALUES('$DJUSIB',20070827141200,20070827,141200,107.49,107.49,107.49,107.49,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIB',20070827,106.51,107.81,106.51,107.49,0);
INSERT INTO intraday_data VALUES('$DJUSIF',20070827141200,20070827,141200,451.61,451.61,451.61,451.61,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.61,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827141200,20070827,141200,351.13,351.13,351.08,351.11,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.11,0);
INSERT INTO intraday_data VALUES('$DJUSIQ',20070827141200,20070827,141200,889.66,889.66,889.66,889.66,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIQ',20070827,888.35,891.00,883.63,889.66,0);
INSERT INTO intraday_data VALUES('$DJUSMC',20070827141200,20070827,141200,452.22,452.22,452.22,452.22,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.22,0);
INSERT INTO intraday_data VALUES('$DJUSMS',20070827141200,20070827,141200,383.25,383.25,383.25,383.25,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.25,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827141200,20070827,141200,308.79,308.79,308.71,308.71,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.71,0);
INSERT INTO intraday_data VALUES('$DJUSPB',20070827141200,20070827,141200,291.82,291.82,291.82,291.82,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPB',20070827,291.86,292.07,290.89,291.82,0);
INSERT INTO intraday_data VALUES('$DJUSPP',20070827141200,20070827,141200,147.57,147.57,147.57,147.57,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.57,0);
INSERT INTO intraday_data VALUES('$DJUSPR',20070827141200,20070827,141200,276.86,276.86,276.86,276.86,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.86,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827141200,20070827,141200,283.07,283.11,283.06,283.06,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.06,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827141200,20070827,141200,405.70,405.82,405.70,405.78,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.78,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827141200,20070827,141200,115.63,115.66,115.63,115.64,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.64,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827141200,20070827,141200,1334.57,1334.59,1334.23,1334.43,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1327.39,1334.43,0);
INSERT INTO intraday_data VALUES('$DJUSST',20070827141200,20070827,141200,365.21,365.21,365.21,365.21,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.21,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827141200,20070827,141200,613.96,613.97,613.88,613.91,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,611.64,613.91,0);
INSERT INTO intraday_data VALUES('$DJUSTK',20070827141200,20070827,141200,330.55,330.55,330.55,330.55,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.55,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827141200,20070827,141200,187.09,187.09,187.04,187.04,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.04,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827141200,20070827,141200,186.11,186.13,186.08,186.09,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.09,0);
INSERT INTO intraday_data VALUES('$DJUSWC',20070827141200,20070827,141200,404.68,404.68,404.68,404.68,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.68,0);
INSERT INTO intraday_data VALUES('$DJUSWU',20070827141200,20070827,141200,767.88,767.88,767.88,767.88,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSWU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSWU',20070827,774.49,781.10,765.24,767.88,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827141200,20070827,141200,137.21,137.22,137.17,137.17,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.17,0);
INSERT INTO intraday_data VALUES('$IDX',20070827141200,20070827,141200,856.88,856.94,856.88,856.88,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,856.88,0);
INSERT INTO intraday_data VALUES('$INDU',20070827141200,20070827,141200,13352.05,13352.29,13347.74,13350.99,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13378.63,13305.87,13350.99,0);
INSERT INTO intraday_data VALUES('$INX',20070827141200,20070827,141200,1470.57,1470.61,1470.17,1470.17,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1470.17,0);
INSERT INTO intraday_data VALUES('$IUX',20070827141200,20070827,141200,790.93,790.94,790.89,790.89,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.89,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827141200,20070827,141200,9546.55,9546.68,9545.16,9545.31,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,9545.31,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827141200,20070827,141200,686.03,686.05,685.82,685.97,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.97,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827141200,20070827,141200,731.37,731.37,731.04,731.32,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,731.32,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827141200,20070827,141200,416.79,416.79,416.76,416.76,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.76,0);
INSERT INTO intraday_data VALUES('$VIX',20070827141200,20070827,141200,22.32,22.36,22.32,22.36,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',20070827141200,20070827,141200,10.33,10.33,10.33,10.33,13300);
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,1173006);
INSERT INTO intraday_data VALUES('ACLI',20070827141200,20070827,141200,24.07,24.07,24.04,24.04,500);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,24.04,383578);
INSERT INTO intraday_data VALUES('ACL',20070827141200,20070827,141200,133.51,133.51,133.51,133.51,100);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.51,249300);
INSERT INTO intraday_data VALUES('ADM',20070827141200,20070827,141200,32.96,32.96,32.94,32.95,5500);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.69,32.95,2158415);
INSERT INTO intraday_data VALUES('ADS',20070827141200,20070827,141200,76.68,76.68,76.68,76.68,100);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.43,76.68,397100);
INSERT INTO intraday_data VALUES('AET',20070827141200,20070827,141200,50.09,50.09,50.06,50.08,6600);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.23,49.68,50.08,1910100);
INSERT INTO intraday_data VALUES('AIRM',20070827141200,20070827,141200,40.88,40.88,40.88,40.88,100);
DELETE FROM eod_data WHERE `ticker` = "AIRM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AIRM',20070827,41.25,42.09,40.44,40.88,69315);
INSERT INTO intraday_data VALUES('ALB',20070827141200,20070827,141200,38.57,38.57,38.57,38.57,500);
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,349900);
INSERT INTO intraday_data VALUES('AMD',20070827141200,20070827,141200,12.10,12.12,12.10,12.10,29700);
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,10303275);
INSERT INTO intraday_data VALUES('ANF',20070827141200,20070827,141200,79.69,79.69,79.55,79.55,2500);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,79.55,1121500);
INSERT INTO intraday_data VALUES('AOB',20070827141200,20070827,141200,9.40,9.40,9.40,9.40,2700);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.46,9.03,9.40,1003600);
INSERT INTO intraday_data VALUES('APA',20070827141200,20070827,141200,75.34,75.35,75.29,75.35,3500);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.12,75.35,1520500);
INSERT INTO intraday_data VALUES('APH',20070827141200,20070827,141200,35.00,35.00,35.00,35.00,200);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.84,35.00,417737);
INSERT INTO intraday_data VALUES('AZN',20070827141200,20070827,141200,48.35,48.37,48.34,48.34,800);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.15,48.34,415600);
INSERT INTO intraday_data VALUES('BA',20070827141200,20070827,141200,98.62,98.64,98.57,98.64,5600);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.67,97.13,98.64,1925205);
INSERT INTO intraday_data VALUES('BBY',20070827141200,20070827,141200,43.78,43.80,43.76,43.76,9600);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.70,43.76,2329915);
INSERT INTO intraday_data VALUES('BEN',20070827141200,20070827,141200,133.03,133.05,132.97,132.97,3500);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,132.51,132.97,454516);
INSERT INTO intraday_data VALUES('BHI',20070827141200,20070827,141200,80.94,80.95,80.90,80.94,3000);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,79.96,80.94,1391405);
INSERT INTO intraday_data VALUES('BHP',20070827141200,20070827,141200,62.19,62.19,62.16,62.16,1400);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,62.16,830890);
INSERT INTO intraday_data VALUES('BIDU',20070827141200,20070827,141200,211.73,211.77,211.57,211.77,4065);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,212.38,200.55,211.77,3384366);
INSERT INTO intraday_data VALUES('BRY',20070827141200,20070827,141200,33.47,33.49,33.47,33.49,300);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.30,33.49,100800);
INSERT INTO intraday_data VALUES('BZH',20070827141200,20070827,141200,9.69,9.71,9.69,9.71,700);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.71,1478700);
INSERT INTO intraday_data VALUES('CAMP',20070827141200,20070827,141200,3.75,3.75,3.75,3.75,100);
DELETE FROM eod_data WHERE `ticker` = "CAMP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAMP',20070827,3.72,3.79,3.72,3.75,42597);
INSERT INTO intraday_data VALUES('CAM',20070827141200,20070827,141200,77.99,77.99,77.94,77.95,1500);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.95,607000);
INSERT INTO intraday_data VALUES('CBB',20070827141200,20070827,141200,4.97,4.97,4.97,4.97,4200);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,5.00,4.91,4.97,539400);
INSERT INTO intraday_data VALUES('CCJ',20070827141200,20070827,141200,40.17,40.17,40.12,40.14,3700);
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,1600362);
INSERT INTO intraday_data VALUES('CELG',20070827141200,20070827,141200,59.55,59.56,59.53,59.56,12563);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.84,59.26,59.56,1381252);
INSERT INTO intraday_data VALUES('CERN',20070827141200,20070827,141200,56.49,56.49,56.49,56.49,671);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.25,56.49,152863);
INSERT INTO intraday_data VALUES('CHINA',20070827141200,20070827,141200,8.44,8.44,8.43,8.43,2300);
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,763459);
INSERT INTO intraday_data VALUES('CHRW',20070827141200,20070827,141200,49.15,49.15,49.14,49.15,600);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.15,293321);
INSERT INTO intraday_data VALUES('CI',20070827141200,20070827,141200,49.86,49.86,49.79,49.84,9400);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,49.74,49.84,994092);
INSERT INTO intraday_data VALUES('CMC',20070827141200,20070827,141200,29.17,29.17,29.14,29.15,5500);
DELETE FROM eod_data WHERE `ticker` = "CMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMC',20070827,29.99,29.99,29.07,29.15,626600);
INSERT INTO intraday_data VALUES('CMI',20070827141200,20070827,141200,115.68,115.71,115.66,115.71,400);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,114.97,115.71,617900);
INSERT INTO intraday_data VALUES('CNH',20070827141200,20070827,141200,49.29,49.29,49.29,49.29,100);
DELETE FROM eod_data WHERE `ticker` = "CNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CNH',20070827,49.67,50.35,48.87,49.29,145900);
INSERT INTO intraday_data VALUES('COGO',20070827141200,20070827,141200,17.34,17.34,17.34,17.34,100);
DELETE FROM eod_data WHERE `ticker` = "COGO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COGO',20070827,17.16,17.64,17.16,17.34,241703);
INSERT INTO intraday_data VALUES('COG',20070827141200,20070827,141200,32.63,32.64,32.63,32.63,400);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.63,312100);
INSERT INTO intraday_data VALUES('CRS',20070827141200,20070827,141200,115.73,115.73,115.73,115.73,200);
DELETE FROM eod_data WHERE `ticker` = "CRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRS',20070827,114.59,117.20,114.34,115.73,205800);
INSERT INTO intraday_data VALUES('CTRP',20070827141200,20070827,141200,43.68,43.75,43.68,43.71,750);
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,658786);
INSERT INTO intraday_data VALUES('CTSH',20070827141200,20070827,141200,73.05,73.07,73.04,73.06,1600);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,73.06,1251552);
INSERT INTO intraday_data VALUES('CTX',20070827141200,20070827,141200,30.42,30.46,30.41,30.46,2900);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.28,30.46,2050534);
INSERT INTO intraday_data VALUES('CVH',20070827141200,20070827,141200,58.04,58.04,58.02,58.03,1000);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,58.03,470600);
INSERT INTO intraday_data VALUES('CXW',20070827141200,20070827,141200,25.35,25.37,25.35,25.37,300);
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,851300);
INSERT INTO intraday_data VALUES('CX',20070827141200,20070827,141200,31.30,31.32,31.30,31.30,3300);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.20,31.30,1467100);
INSERT INTO intraday_data VALUES('DRIV',20070827141200,20070827,141200,44.65,44.70,44.65,44.70,310);
DELETE FROM eod_data WHERE `ticker` = "DRIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRIV',20070827,44.64,44.99,44.45,44.70,137491);
INSERT INTO intraday_data VALUES('DRQ',20070827141200,20070827,141200,44.98,44.98,44.81,44.84,6700);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.58,44.84,149200);
INSERT INTO intraday_data VALUES('DRYS',20070827141200,20070827,141200,67.15,67.15,67.10,67.10,3652);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.74,63.16,67.10,1722623);
INSERT INTO intraday_data VALUES('DVR',20070827141200,20070827,141200,14.55,14.55,14.55,14.55,100);
DELETE FROM eod_data WHERE `ticker` = "DVR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DVR',20070827,14.68,14.68,14.37,14.55,358900);
INSERT INTO intraday_data VALUES('ECA',20070827141200,20070827,141200,58.29,58.29,58.23,58.23,2200);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.23,961686);
INSERT INTO intraday_data VALUES('EGY',20070827141200,20070827,141200,3.73,3.75,3.73,3.74,4900);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.74,219400);
INSERT INTO intraday_data VALUES('EOG',20070827141200,20070827,141200,66.83,66.84,66.80,66.84,4400);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.84,1088250);
INSERT INTO intraday_data VALUES('EXPD',20070827141200,20070827,141200,45.27,45.27,45.27,45.27,500);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.72,45.01,45.27,430045);
INSERT INTO intraday_data VALUES('EXP',20070827141200,20070827,141200,38.21,38.21,38.20,38.20,700);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.03,38.20,376700);
INSERT INTO intraday_data VALUES('EZPW',20070827141200,20070827,141200,12.54,12.54,12.54,12.54,200);
DELETE FROM eod_data WHERE `ticker` = "EZPW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EZPW',20070827,12.65,12.65,12.48,12.54,111884);
INSERT INTO intraday_data VALUES('FDG',20070827141200,20070827,141200,32.82,32.82,32.82,32.82,100);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.97,32.05,32.82,302775);
INSERT INTO intraday_data VALUES('FFIV',20070827141200,20070827,141200,37.00,37.02,37.00,37.02,3827);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,37.02,639187);
INSERT INTO intraday_data VALUES('FLR',20070827141200,20070827,141200,125.68,125.70,125.64,125.70,1300);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.94,123.02,125.70,672675);
INSERT INTO intraday_data VALUES('FMD',20070827141200,20070827,141200,35.30,35.32,35.30,35.32,400);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.58,35.02,35.32,324600);
INSERT INTO intraday_data VALUES('FRX',20070827141200,20070827,141200,37.18,37.18,37.17,37.17,4400);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.17,1567300);
INSERT INTO intraday_data VALUES('GES',20070827141200,20070827,141200,49.92,49.92,49.92,49.92,500);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.27,49.92,450019);
INSERT INTO intraday_data VALUES('GGB',20070827141200,20070827,141200,23.02,23.02,23.01,23.02,900);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,23.02,911700);
INSERT INTO intraday_data VALUES('GOOG',20070827141200,20070827,141200,515.54,515.77,515.54,515.66,1400);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,515.66,1680060);
INSERT INTO intraday_data VALUES('GRA',20070827141200,20070827,141200,22.05,22.05,22.05,22.05,100);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.76,22.05,265100);
INSERT INTO intraday_data VALUES('GRMN',20070827141200,20070827,141200,102.50,102.50,102.49,102.49,855);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,102.49,1644143);
INSERT INTO intraday_data VALUES('GS',20070827141200,20070827,141200,178.15,178.17,178.00,178.16,5700);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.45,178.16,4624142);
INSERT INTO intraday_data VALUES('GTI',20070827141200,20070827,141200,16.85,16.85,16.85,16.85,2600);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,16.85,1572147);
INSERT INTO intraday_data VALUES('HNR',20070827141200,20070827,141200,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,113100);
INSERT INTO intraday_data VALUES('HOC',20070827141200,20070827,141200,65.02,65.05,65.02,65.05,1600);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,65.05,484975);
INSERT INTO intraday_data VALUES('HOG',20070827141200,20070827,141200,54.12,54.14,54.12,54.13,2100);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.13,1131163);
INSERT INTO intraday_data VALUES('HPC',20070827141200,20070827,141200,21.25,21.26,21.25,21.25,1600);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.25,21.25,894887);
INSERT INTO intraday_data VALUES('IBM',20070827141200,20070827,141200,113.49,113.52,113.45,113.51,5700);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.85,112.80,113.51,2643302);
INSERT INTO intraday_data VALUES('ICE',20070827141200,20070827,141200,140.28,140.42,140.20,140.22,2200);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.69,140.22,611700);
INSERT INTO intraday_data VALUES('INFY',20070827141200,20070827,141200,46.42,46.42,46.38,46.42,700);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.19,46.42,840730);
INSERT INTO intraday_data VALUES('IVGN',20070827141200,20070827,141200,78.89,78.90,78.89,78.90,400);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,79.22,77.95,78.90,221504);
INSERT INTO intraday_data VALUES('JCI',20070827141200,20070827,141200,112.10,112.10,112.06,112.06,700);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.21,112.06,261785);
INSERT INTO intraday_data VALUES('JOYG',20070827141200,20070827,141200,48.13,48.14,48.12,48.14,935);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.14,1020299);
INSERT INTO intraday_data VALUES('KEP',20070827141200,20070827,141200,22.09,22.09,22.07,22.07,800);
DELETE FROM eod_data WHERE `ticker` = "KEP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KEP',20070827,22.09,22.20,21.86,22.07,250000);
INSERT INTO intraday_data VALUES('LMT',20070827141200,20070827,141200,101.69,101.81,101.69,101.71,4900);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,101.95,99.12,101.71,1323590);
INSERT INTO intraday_data VALUES('LVS',20070827141200,20070827,141200,98.70,98.73,98.68,98.72,1700);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,98.72,1905525);
INSERT INTO intraday_data VALUES('MBT',20070827141200,20070827,141200,62.81,62.81,62.78,62.79,2500);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.96,61.43,62.79,405700);
INSERT INTO intraday_data VALUES('MCD',20070827141200,20070827,141200,49.44,49.44,49.42,49.43,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.43,2801112);
INSERT INTO intraday_data VALUES('MED',20070827141200,20070827,141200,6.66,6.66,6.66,6.66,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.66,129700);
INSERT INTO intraday_data VALUES('MFLX',20070827141200,20070827,141200,12.58,12.58,12.58,12.58,100);
DELETE FROM eod_data WHERE `ticker` = "MFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MFLX',20070827,12.79,12.86,12.48,12.58,35669);
INSERT INTO intraday_data VALUES('MGM',20070827141200,20070827,141200,82.17,82.17,82.17,82.17,100);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.17,734400);
INSERT INTO intraday_data VALUES('MICC',20070827141200,20070827,141200,82.76,82.78,82.69,82.69,1422);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.31,82.69,232121);
INSERT INTO intraday_data VALUES('MLM',20070827141200,20070827,141200,131.38,131.58,131.38,131.58,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.58,261700);
INSERT INTO intraday_data VALUES('MNT',20070827141200,20070827,141200,43.89,43.90,43.89,43.90,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.90,350059);
INSERT INTO intraday_data VALUES('MTH',20070827141200,20070827,141200,17.48,17.49,17.48,17.49,900);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,17.28,17.49,531291);
INSERT INTO intraday_data VALUES('MTW',20070827141200,20070827,141200,76.64,76.68,76.59,76.62,1100);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.62,427400);
INSERT INTO intraday_data VALUES('NEM',20070827141200,20070827,141200,40.38,40.39,40.37,40.37,3200);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.30,40.37,2788500);
INSERT INTO intraday_data VALUES('NEU',20070827141200,20070827,141200,47.67,47.67,47.66,47.66,200);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,46.84,47.66,107700);
INSERT INTO intraday_data VALUES('NFX',20070827141200,20070827,141200,43.74,43.75,43.74,43.75,800);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.28,43.75,726928);
INSERT INTO intraday_data VALUES('NILE',20070827141200,20070827,141200,85.79,85.79,85.79,85.79,100);
DELETE FROM eod_data WHERE `ticker` = "NILE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NILE',20070827,86.59,87.20,84.92,85.79,141266);
INSERT INTO intraday_data VALUES('NOV',20070827141200,20070827,141200,119.94,120.00,119.94,120.00,9700);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,120.00,1397721);
INSERT INTO intraday_data VALUES('NSTC',20070827141200,20070827,141200,10.86,10.86,10.86,10.86,300);
DELETE FROM eod_data WHERE `ticker` = "NSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NSTC',20070827,10.99,11.11,10.85,10.86,65884);
INSERT INTO intraday_data VALUES('NTES',20070827141200,20070827,141200,16.28,16.29,16.28,16.29,1300);
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,602995);
INSERT INTO intraday_data VALUES('NVDA',20070827141200,20070827,141200,49.49,49.51,49.48,49.50,15952);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.50,6148268);
INSERT INTO intraday_data VALUES('OCR',20070827141200,20070827,141200,33.06,33.06,33.04,33.05,1300);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.06,32.66,33.05,574500);
INSERT INTO intraday_data VALUES('OGE',20070827141200,20070827,141200,33.08,33.08,33.08,33.08,400);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.87,33.08,241000);
INSERT INTO intraday_data VALUES('OII',20070827141200,20070827,141200,65.01,65.01,64.95,65.01,1800);
DELETE FROM eod_data WHERE `ticker` = "OII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OII',20070827,65.35,65.45,64.01,65.01,202288);
INSERT INTO intraday_data VALUES('PBR',20070827141200,20070827,141200,59.22,59.22,59.16,59.21,7700);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.43,58.47,59.21,1958759);
INSERT INTO intraday_data VALUES('PCR',20070827141200,20070827,141200,55.60,55.62,55.55,55.62,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.62,288100);
INSERT INTO intraday_data VALUES('PCU',20070827141200,20070827,141200,103.69,103.69,103.48,103.63,5400);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,103.63,1312473);
INSERT INTO intraday_data VALUES('PMTI',20070827141200,20070827,141200,30.45,30.45,30.45,30.45,400);
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,94805);
INSERT INTO intraday_data VALUES('PNK',20070827141200,20070827,141200,27.29,27.29,27.28,27.28,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.28,169300);
INSERT INTO intraday_data VALUES('PRFT',20070827141200,20070827,141200,23.38,23.38,23.38,23.38,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.38,152828);
INSERT INTO intraday_data VALUES('QDEL',20070827141200,20070827,141200,17.15,17.15,17.15,17.15,300);
DELETE FROM eod_data WHERE `ticker` = "QDEL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QDEL',20070827,17.33,17.40,17.06,17.15,180899);
INSERT INTO intraday_data VALUES('QSII',20070827141200,20070827,141200,37.98,37.98,37.96,37.96,200);
DELETE FROM eod_data WHERE `ticker` = "QSII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QSII',20070827,38.16,38.37,37.77,37.96,92102);
INSERT INTO intraday_data VALUES('RIG',20070827141200,20070827,141200,102.78,102.80,102.62,102.73,9300);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.54,102.73,2524333);
INSERT INTO intraday_data VALUES('RIO',20070827141200,20070827,141200,47.90,47.91,47.86,47.91,23600);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.97,47.09,47.91,7196683);
INSERT INTO intraday_data VALUES('RL',20070827141200,20070827,141200,76.59,76.59,76.55,76.57,1300);
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,648500);
INSERT INTO intraday_data VALUES('RMD',20070827141200,20070827,141200,41.46,41.46,41.44,41.44,400);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.32,41.44,311605);
INSERT INTO intraday_data VALUES('RYL',20070827141200,20070827,141200,30.04,30.05,30.02,30.05,1300);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,29.97,30.05,940781);
INSERT INTO intraday_data VALUES('SBGI',20070827141200,20070827,141200,12.39,12.39,12.38,12.39,800);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.35,12.39,574770);
INSERT INTO intraday_data VALUES('SBUX',20070827141200,20070827,141200,27.46,27.46,27.45,27.45,400);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.45,2626136);
INSERT INTO intraday_data VALUES('SCI',20070827141200,20070827,141200,12.04,12.04,12.02,12.02,500);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,11.96,12.02,750300);
INSERT INTO intraday_data VALUES('SEIC',20070827141200,20070827,141200,25.77,25.78,25.76,25.76,1100);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.76,223836);
INSERT INTO intraday_data VALUES('SID',20070827141200,20070827,141200,53.81,53.82,53.81,53.82,300);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.67,53.82,701000);
INSERT INTO intraday_data VALUES('SIMG',20070827141200,20070827,141200,5.88,5.88,5.87,5.87,604);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.87,468500);
INSERT INTO intraday_data VALUES('SKX',20070827141200,20070827,141200,19.99,19.99,19.98,19.98,300);
DELETE FROM eod_data WHERE `ticker` = "SKX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SKX',20070827,20.10,20.10,19.81,19.98,243800);
INSERT INTO intraday_data VALUES('SNDK',20070827141200,20070827,141200,52.15,52.15,52.11,52.11,4000);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.05,52.11,5529806);
INSERT INTO intraday_data VALUES('SNE',20070827141200,20070827,141200,46.34,46.34,46.34,46.34,100);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.34,389840);
INSERT INTO intraday_data VALUES('SPF',20070827141200,20070827,141200,9.96,9.96,9.95,9.95,5200);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.95,1361400);
INSERT INTO intraday_data VALUES('SPN',20070827141200,20070827,141200,38.31,38.33,38.31,38.32,3600);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.01,38.32,304700);
INSERT INTO intraday_data VALUES('SPWR',20070827141200,20070827,141200,62.24,62.26,62.24,62.26,900);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.05,62.26,590054);
INSERT INTO intraday_data VALUES('STEC',20070827141200,20070827,141200,7.56,7.56,7.56,7.56,100);
DELETE FROM eod_data WHERE `ticker` = "STEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STEC',20070827,7.61,7.64,7.52,7.56,96181);
INSERT INTO intraday_data VALUES('STLD',20070827141200,20070827,141200,43.64,43.64,43.61,43.63,2442);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.63,752478);
INSERT INTO intraday_data VALUES('SWN',20070827141200,20070827,141200,37.59,37.62,37.59,37.61,2300);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.61,1078600);
INSERT INTO intraday_data VALUES('TEX',20070827141200,20070827,141200,78.27,78.30,78.27,78.30,1500);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,77.82,78.30,693400);
INSERT INTO intraday_data VALUES('THOR',20070827141200,20070827,141200,20.84,20.85,20.84,20.85,400);
DELETE FROM eod_data WHERE `ticker` = "THOR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('THOR',20070827,20.87,20.94,20.61,20.85,176107);
INSERT INTO intraday_data VALUES('TLM',20070827141200,20070827,141200,17.03,17.03,17.02,17.02,1300);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.95,17.02,1270782);
INSERT INTO intraday_data VALUES('TNB',20070827141200,20070827,141200,55.48,55.50,55.47,55.50,1100);
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,310300);
INSERT INTO intraday_data VALUES('TOPT',20070827141200,20070827,141200,5.73,5.73,5.73,5.73,200);
DELETE FROM eod_data WHERE `ticker` = "TOPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOPT',20070827,5.84,5.84,5.65,5.73,213573);
INSERT INTO intraday_data VALUES('TRMB',20070827141200,20070827,141200,36.50,36.51,36.50,36.51,300);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.51,396518);
INSERT INTO intraday_data VALUES('TSO',20070827141200,20070827,141200,49.51,49.55,49.49,49.55,12200);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.55,1655900);
INSERT INTO intraday_data VALUES('TXU',20070827141200,20070827,141200,66.01,66.15,66.01,66.10,32500);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.73,66.10,3959200);
INSERT INTO intraday_data VALUES('UFPI',20070827141200,20070827,141200,38.35,38.35,38.31,38.32,946);
DELETE FROM eod_data WHERE `ticker` = "UFPI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UFPI',20070827,38.17,38.87,37.74,38.32,54991);
INSERT INTO intraday_data VALUES('URBN',20070827141200,20070827,141200,22.66,22.66,22.66,22.66,100);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.66,1398079);
INSERT INTO intraday_data VALUES('USG',20070827141200,20070827,141200,37.68,37.69,37.68,37.68,1000);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.65,37.68,409200);
INSERT INTO intraday_data VALUES('VIP',20070827141200,20070827,141200,22.80,22.80,22.77,22.77,1900);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.87,22.08,22.77,1157730);
INSERT INTO intraday_data VALUES('WBSN',20070827141200,20070827,141200,20.50,20.50,20.50,20.50,300);
DELETE FROM eod_data WHERE `ticker` = "WBSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WBSN',20070827,20.73,20.91,20.44,20.50,93924);
INSERT INTO intraday_data VALUES('WFMI',20070827141200,20070827,141200,45.75,45.76,45.75,45.75,900);
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,2148680);
INSERT INTO intraday_data VALUES('WFR',20070827141200,20070827,141200,58.41,58.41,58.35,58.36,2700);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.21,58.36,808100);
INSERT INTO intraday_data VALUES('WLP',20070827141200,20070827,141200,78.43,78.44,78.42,78.43,1200);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.63,77.89,78.43,1420100);
INSERT INTO intraday_data VALUES('WNR',20070827141200,20070827,141200,52.19,52.19,52.17,52.18,1700);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,52.18,516100);
INSERT INTO intraday_data VALUES('YHOO',20070827141200,20070827,141200,23.17,23.18,23.17,23.18,57816);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.16,23.18,9508658);