INSERT INTO intraday_data VALUES('$COMPX',20070827111900,20070827,111900,2561.37,2561.37,2560.49,2560.49,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2560.49,2560.49,0);
INSERT INTO intraday_data VALUES('$DJUSAL',20070827111900,20070827,111900,313.39,313.39,313.39,313.39,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAL',20070827,312.25,317.30,312.25,313.39,0);
INSERT INTO intraday_data VALUES('$DJUSBC',20070827111900,20070827,111900,461.37,461.37,461.37,461.37,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBC',20070827,461.99,462.97,460.82,461.37,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827111900,20070827,111900,269.54,269.54,269.52,269.52,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBM',20070827,272.06,272.76,269.50,269.52,0);
INSERT INTO intraday_data VALUES('$DJUSBV',20070827111900,20070827,111900,313.32,313.32,313.32,313.32,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBV',20070827,313.92,314.11,312.48,313.32,0);
INSERT INTO intraday_data VALUES('$DJUSCE',20070827111900,20070827,111900,1347.20,1347.20,1347.20,1347.20,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCE',20070827,1364.01,1364.01,1344.23,1347.20,0);
INSERT INTO intraday_data VALUES('$DJUSCM',20070827111900,20070827,111900,291.66,291.66,291.66,291.66,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCM',20070827,293.88,293.88,291.60,291.66,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827111900,20070827,111900,335.02,335.02,334.94,334.94,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCY',20070827,336.55,336.90,334.94,334.94,0);
INSERT INTO intraday_data VALUES('$DJUSDS',20070827111900,20070827,111900,142.45,142.45,142.45,142.45,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDS',20070827,142.84,143.32,142.41,142.45,0);
INSERT INTO intraday_data VALUES('$DJUSDV',20070827111900,20070827,111900,81.26,81.26,81.26,81.26,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDV',20070827,80.29,81.28,79.95,81.26,0);
INSERT INTO intraday_data VALUES('$DJUSEE',20070827111900,20070827,111900,175.56,175.56,175.56,175.56,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEE',20070827,176.91,176.91,175.56,175.56,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827111900,20070827,111900,593.85,593.88,593.82,593.82,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,593.28,593.82,0);
INSERT INTO intraday_data VALUES('$DJUSFE',20070827111900,20070827,111900,247.69,247.69,247.69,247.69,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFE',20070827,243.63,248.40,243.63,247.69,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827111900,20070827,111900,547.48,547.48,547.45,547.45,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFN',20070827,552.10,552.10,547.04,547.45,0);
INSERT INTO intraday_data VALUES('$DJUSGI',20070827111900,20070827,111900,434.89,434.89,434.89,434.89,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGI',20070827,438.50,438.50,434.49,434.89,0);
INSERT INTO intraday_data VALUES('$DJUSHB',20070827111900,20070827,111900,421.83,421.83,421.83,421.83,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHB',20070827,434.73,436.41,421.83,421.83,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827111900,20070827,111900,343.23,343.24,343.21,343.21,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHC',20070827,343.94,344.09,343.03,343.21,0);
INSERT INTO intraday_data VALUES('$DJUSHP',20070827111900,20070827,111900,564.18,564.18,564.18,564.18,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHP',20070827,565.39,565.78,563.95,564.18,0);
INSERT INTO intraday_data VALUES('$DJUSHV',20070827111900,20070827,111900,540.11,540.11,540.11,540.11,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHV',20070827,524.94,544.42,523.34,540.11,0);
INSERT INTO intraday_data VALUES('$DJUSIB',20070827111900,20070827,111900,107.09,107.09,107.09,107.09,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.09,0);
INSERT INTO intraday_data VALUES('$DJUSIG',20070827111900,20070827,111900,371.82,371.82,371.82,371.82,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIG',20070827,369.44,374.08,369.21,371.82,0);
INSERT INTO intraday_data VALUES('$DJUSIM',20070827111900,20070827,111900,410.64,410.64,410.64,410.64,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIM',20070827,415.30,418.66,410.64,410.64,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827111900,20070827,111900,350.30,350.30,350.19,350.19,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIN',20070827,352.45,352.45,350.19,350.19,0);
INSERT INTO intraday_data VALUES('$DJUSIT',20070827111900,20070827,111900,394.54,394.54,394.54,394.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIT',20070827,391.71,400.72,391.71,394.54,0);
INSERT INTO intraday_data VALUES('$DJUSIV',20070827111900,20070827,111900,218.87,218.87,218.87,218.87,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIV',20070827,219.65,219.65,218.80,218.87,0);
INSERT INTO intraday_data VALUES('$DJUSIX',20070827111900,20070827,111900,413.24,413.24,413.24,413.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIX',20070827,415.71,415.71,412.88,413.24,0);
INSERT INTO intraday_data VALUES('$DJUSMF',20070827111900,20070827,111900,80.96,80.96,80.96,80.96,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMF',20070827,82.03,82.03,80.88,80.96,0);
INSERT INTO intraday_data VALUES('$DJUSMU',20070827111900,20070827,111900,121.07,121.07,121.07,121.07,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMU',20070827,123.48,123.48,121.05,121.07,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827111900,20070827,111900,308.40,308.40,308.33,308.33,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNC',20070827,309.88,310.14,308.33,308.33,0);
INSERT INTO intraday_data VALUES('$DJUSNG',20070827111900,20070827,111900,375.75,375.75,375.75,375.75,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNG',20070827,378.20,378.39,375.75,375.75,0);
INSERT INTO intraday_data VALUES('$DJUSPG',20070827111900,20070827,111900,265.29,265.29,265.29,265.29,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPG',20070827,268.57,268.57,265.29,265.29,0);
INSERT INTO intraday_data VALUES('$DJUSPP',20070827111900,20070827,111900,146.12,146.12,146.12,146.12,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPP',20070827,145.73,146.36,145.29,146.12,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827111900,20070827,111900,282.85,282.85,282.85,282.85,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRE',20070827,287.10,287.12,282.59,282.85,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827111900,20070827,111900,405.30,405.30,405.22,405.22,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.22,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827111900,20070827,111900,115.55,115.56,115.53,115.53,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRI',20070827,117.28,117.34,115.46,115.53,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827111900,20070827,111900,1331.94,1332.12,1331.81,1331.81,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1331.81,1331.81,0);
INSERT INTO intraday_data VALUES('$DJUSSF',20070827111900,20070827,111900,106.19,106.19,106.19,106.19,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSF',20070827,106.04,106.55,105.96,106.19,0);
INSERT INTO intraday_data VALUES('$DJUSSP',20070827111900,20070827,111900,108.62,108.62,108.62,108.62,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSP',20070827,108.46,109.00,108.31,108.62,0);
INSERT INTO intraday_data VALUES('$DJUSSV',20070827111900,20070827,111900,653.42,653.42,653.42,653.42,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSV',20070827,654.61,655.80,653.15,653.42,0);
INSERT INTO intraday_data VALUES('$DJUSSW',20070827111900,20070827,111900,604.06,604.06,604.06,604.06,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSW',20070827,597.99,609.15,596.60,604.06,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827111900,20070827,111900,612.57,612.60,612.56,612.60,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTC',20070827,616.27,616.27,612.45,612.60,0);
INSERT INTO intraday_data VALUES('$DJUSTK',20070827111900,20070827,111900,330.16,330.16,330.16,330.16,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTK',20070827,331.69,332.09,329.87,330.16,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827111900,20070827,111900,186.98,186.98,186.91,186.91,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTL',20070827,187.40,187.42,186.26,186.91,0);
INSERT INTO intraday_data VALUES('$DJUSTQ',20070827111900,20070827,111900,593.37,593.37,593.37,593.37,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTQ',20070827,597.26,597.26,593.37,593.37,0);
INSERT INTO intraday_data VALUES('$DJUSTR',20070827111900,20070827,111900,94.39,94.39,94.39,94.39,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTR',20070827,96.77,96.77,94.17,94.39,0);
INSERT INTO intraday_data VALUES('$DJUSTY',20070827111900,20070827,111900,346.72,346.72,346.72,346.72,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTY',20070827,350.78,350.78,346.31,346.72,0);
INSERT INTO intraday_data VALUES('$DJUSUO',20070827111900,20070827,111900,144.28,144.28,144.28,144.28,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUO',20070827,147.47,147.47,144.25,144.28,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827111900,20070827,111900,186.56,186.56,186.55,186.55,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUT',20070827,191.11,191.11,186.47,186.55,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827111900,20070827,111900,136.72,136.73,136.72,136.72,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.70,136.72,0);
INSERT INTO intraday_data VALUES('$INDU',20070827111900,20070827,111900,13324.81,13324.90,13319.12,13319.12,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13377.16,13305.87,13319.12,0);
INSERT INTO intraday_data VALUES('$INX',20070827111900,20070827,111900,1469.34,1469.38,1469.28,1469.28,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1469.01,1469.28,0);
INSERT INTO intraday_data VALUES('$IUX',20070827111900,20070827,111900,789.97,789.99,789.97,789.98,0);
DELETE FROM eod_data WHERE `ticker` = "$IUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IUX',20070827,797.78,797.78,789.90,789.98,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827111900,20070827,111900,9533.88,9533.97,9533.68,9533.68,0);
DELETE FROM eod_data WHERE `ticker` = "$NYA.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$NYA.X',20070827,9607.04,9607.04,9532.35,9533.68,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827111900,20070827,111900,685.33,685.35,685.29,685.29,0);
DELETE FROM eod_data WHERE `ticker` = "$OEX.X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$OEX.X',20070827,688.88,688.88,685.16,685.29,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827111900,20070827,111900,728.85,728.85,728.84,728.85,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.99,728.85,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827111900,20070827,111900,415.91,415.91,415.91,415.91,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.86,415.91,0);
INSERT INTO intraday_data VALUES('$VIX',20070827111900,20070827,111900,22.44,22.45,22.42,22.45,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',20070827111900,20070827,111900,10.20,10.21,10.20,10.20,1400);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.16,10.20,443006);
INSERT INTO intraday_data VALUES('AAPL',20070827111900,20070827,111900,133.38,133.42,133.25,133.28,33247);
DELETE FROM eod_data WHERE `ticker` = "AAPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAPL',20070827,133.41,134.66,132.72,133.28,11311015);
INSERT INTO intraday_data VALUES('ACLI',20070827111900,20070827,111900,23.81,23.81,23.81,23.81,200);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.80,23.81,198925);
INSERT INTO intraday_data VALUES('ACL',20070827111900,20070827,111900,133.70,133.73,133.64,133.64,400);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.64,123700);
INSERT INTO intraday_data VALUES('ADM',20070827111900,20070827,111900,32.75,32.75,32.73,32.73,4900);
DELETE FROM eod_data WHERE `ticker` = "ADM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADM',20070827,32.83,33.13,32.71,32.73,1036700);
INSERT INTO intraday_data VALUES('ADSK',20070827111900,20070827,111900,45.10,45.11,45.09,45.09,3180);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.51,44.75,45.09,371862);
INSERT INTO intraday_data VALUES('ADS',20070827111900,20070827,111900,76.59,76.59,76.59,76.59,300);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.59,76.59,203200);
INSERT INTO intraday_data VALUES('AET',20070827111900,20070827,111900,49.95,49.95,49.94,49.94,1700);
DELETE FROM eod_data WHERE `ticker` = "AET" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AET',20070827,49.70,50.09,49.68,49.94,732600);
INSERT INTO intraday_data VALUES('ALB',20070827111900,20070827,111900,38.50,38.54,38.50,38.50,1000);
DELETE FROM eod_data WHERE `ticker` = "ALB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ALB',20070827,38.51,38.60,37.97,38.50,209800);
INSERT INTO intraday_data VALUES('AMD',20070827111900,20070827,111900,12.07,12.08,12.07,12.07,57500);
DELETE FROM eod_data WHERE `ticker` = "AMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMD',20070827,12.08,12.25,11.96,12.07,4655775);
INSERT INTO intraday_data VALUES('AMTD',20070827111900,20070827,111900,17.62,17.63,17.61,17.63,9038);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.65,17.40,17.63,743333);
INSERT INTO intraday_data VALUES('AMX',20070827111900,20070827,111900,60.36,60.36,60.33,60.34,3600);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.74,60.06,60.34,1095200);
INSERT INTO intraday_data VALUES('AMZN',20070827111900,20070827,111900,79.37,79.39,79.30,79.32,11317);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.25,79.32,2692180);
INSERT INTO intraday_data VALUES('ANF',20070827111900,20070827,111900,78.93,78.94,78.90,78.94,4000);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.89,78.94,652900);
INSERT INTO intraday_data VALUES('AOB',20070827111900,20070827,111900,9.13,9.13,9.13,9.13,800);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.25,9.03,9.13,327000);
INSERT INTO intraday_data VALUES('APA',20070827111900,20070827,111900,75.25,75.27,75.23,75.23,6100);
DELETE FROM eod_data WHERE `ticker` = "APA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APA',20070827,76.17,76.17,75.18,75.23,811700);
INSERT INTO intraday_data VALUES('APH',20070827111900,20070827,111900,34.93,34.94,34.93,34.93,600);
DELETE FROM eod_data WHERE `ticker` = "APH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('APH',20070827,35.77,35.77,34.92,34.93,169200);
INSERT INTO intraday_data VALUES('AZN',20070827111900,20070827,111900,48.31,48.31,48.28,48.28,1400);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.28,48.28,214500);
INSERT INTO intraday_data VALUES('BA',20070827111900,20070827,111900,97.91,97.91,97.88,97.89,4500);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.36,97.13,97.89,1030405);
INSERT INTO intraday_data VALUES('BBY',20070827111900,20070827,111900,44.30,44.30,44.29,44.29,7000);
DELETE FROM eod_data WHERE `ticker` = "BBY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BBY',20070827,44.00,44.56,43.94,44.29,1071215);
INSERT INTO intraday_data VALUES('BCSI',20070827111900,20070827,111900,86.85,86.90,86.65,86.70,7400);
DELETE FROM eod_data WHERE `ticker` = "BCSI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BCSI',20070827,84.66,87.05,83.26,86.70,1051542);
INSERT INTO intraday_data VALUES('BDK',20070827111900,20070827,111900,87.32,87.32,87.27,87.27,800);
DELETE FROM eod_data WHERE `ticker` = "BDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BDK',20070827,87.69,88.27,87.27,87.27,128900);
INSERT INTO intraday_data VALUES('BG',20070827111900,20070827,111900,87.43,87.53,87.43,87.51,2700);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,87.92,87.03,87.51,158200);
INSERT INTO intraday_data VALUES('BHI',20070827111900,20070827,111900,80.44,80.44,80.25,80.25,16900);
DELETE FROM eod_data WHERE `ticker` = "BHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHI',20070827,81.15,81.40,80.25,80.25,791563);
INSERT INTO intraday_data VALUES('BHP',20070827111900,20070827,111900,61.72,61.72,61.69,61.69,600);
DELETE FROM eod_data WHERE `ticker` = "BHP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BHP',20070827,62.25,62.90,61.63,61.69,510790);
INSERT INTO intraday_data VALUES('BIDU',20070827111900,20070827,111900,208.99,209.24,208.90,209.01,6955);
DELETE FROM eod_data WHERE `ticker` = "BIDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BIDU',20070827,203.46,211.30,200.55,209.01,2103100);
INSERT INTO intraday_data VALUES('BNI',20070827111900,20070827,111900,80.01,80.07,79.84,79.84,24200);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,80.83,79.84,79.84,651258);
INSERT INTO intraday_data VALUES('BPT',20070827111900,20070827,111900,70.60,70.60,70.58,70.58,500);
DELETE FROM eod_data WHERE `ticker` = "BPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BPT',20070827,71.05,71.20,70.53,70.58,24500);
INSERT INTO intraday_data VALUES('BRCD',20070827111900,20070827,111900,7.03,7.04,7.02,7.04,109601);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,7.02,7.04,2844146);
INSERT INTO intraday_data VALUES('BRY',20070827111900,20070827,111900,33.46,33.46,33.46,33.46,100);
DELETE FROM eod_data WHERE `ticker` = "BRY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRY',20070827,34.00,34.15,33.36,33.46,53600);
INSERT INTO intraday_data VALUES('BR',20070827111900,20070827,111900,17.85,17.86,17.84,17.84,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.84,169500);
INSERT INTO intraday_data VALUES('BTU',20070827111900,20070827,111900,41.32,41.33,41.29,41.29,8600);
DELETE FROM eod_data WHERE `ticker` = "BTU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BTU',20070827,42.44,42.56,41.29,41.29,1376692);
INSERT INTO intraday_data VALUES('BZH',20070827111900,20070827,111900,9.76,9.78,9.75,9.78,16700);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.67,9.78,871400);
INSERT INTO intraday_data VALUES('CAM',20070827111900,20070827,111900,77.02,77.03,76.97,76.98,3100);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.97,76.98,277900);
INSERT INTO intraday_data VALUES('CBB',20070827111900,20070827,111900,4.95,4.95,4.95,4.95,300);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,4.98,4.91,4.95,214900);
INSERT INTO intraday_data VALUES('CCJ',20070827111900,20070827,111900,40.20,40.21,40.18,40.19,4700);
DELETE FROM eod_data WHERE `ticker` = "CCJ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CCJ',20070827,40.33,40.49,39.71,40.19,935962);
INSERT INTO intraday_data VALUES('CEG',20070827111900,20070827,111900,84.41,84.41,84.20,84.20,6700);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.86,84.20,461300);
INSERT INTO intraday_data VALUES('CELG',20070827111900,20070827,111900,59.51,59.51,59.45,59.46,6899);
DELETE FROM eod_data WHERE `ticker` = "CELG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CELG',20070827,59.61,59.78,59.30,59.46,677055);
INSERT INTO intraday_data VALUES('CEPH',20070827111900,20070827,111900,73.60,73.61,73.60,73.60,3111);
DELETE FROM eod_data WHERE `ticker` = "CEPH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEPH',20070827,73.75,74.17,73.12,73.60,264223);
INSERT INTO intraday_data VALUES('CERN',20070827111900,20070827,111900,56.61,56.65,56.61,56.61,500);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.61,56.61,56178);
INSERT INTO intraday_data VALUES('CFC',20070827111900,20070827,111900,19.92,19.94,19.91,19.92,51900);
DELETE FROM eod_data WHERE `ticker` = "CFC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CFC',20070827,20.32,20.33,19.53,19.92,19899991);
INSERT INTO intraday_data VALUES('CHAP',20070827111900,20070827,111900,85.34,85.34,85.34,85.34,400);
DELETE FROM eod_data WHERE `ticker` = "CHAP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHAP',20070827,85.34,85.43,85.25,85.34,204226);
INSERT INTO intraday_data VALUES('CHINA',20070827111900,20070827,111900,8.46,8.46,8.46,8.46,2000);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.46,8.20,8.46,314374);
INSERT INTO intraday_data VALUES('CHRW',20070827111900,20070827,111900,49.22,49.22,49.17,49.17,3930);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,49.17,49.17,154900);
INSERT INTO intraday_data VALUES('CI',20070827111900,20070827,111900,50.14,50.14,50.10,50.11,4500);
DELETE FROM eod_data WHERE `ticker` = "CI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CI',20070827,50.36,50.46,50.00,50.11,431792);
INSERT INTO intraday_data VALUES('CMC',20070827111900,20070827,111900,29.17,29.17,29.15,29.15,1400);
DELETE FROM eod_data WHERE `ticker` = "CMC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMC',20070827,29.99,29.99,29.13,29.15,340000);
INSERT INTO intraday_data VALUES('CME',20070827111900,20070827,111900,559.32,559.32,559.32,559.32,200);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.70,556.00,559.32,117200);
INSERT INTO intraday_data VALUES('CMI',20070827111900,20070827,111900,115.78,115.78,115.77,115.77,400);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,115.72,115.77,373400);
INSERT INTO intraday_data VALUES('CNH',20070827111900,20070827,111900,49.26,49.26,49.26,49.26,100);
DELETE FROM eod_data WHERE `ticker` = "CNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CNH',20070827,49.67,50.35,49.21,49.26,99200);
INSERT INTO intraday_data VALUES('COG',20070827111900,20070827,111900,32.54,32.54,32.53,32.54,1300);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.54,175200);
INSERT INTO intraday_data VALUES('COH',20070827111900,20070827,111900,43.61,43.62,43.57,43.57,6200);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.57,43.57,998552);
INSERT INTO intraday_data VALUES('COP',20070827111900,20070827,111900,80.57,80.58,80.54,80.54,17100);
DELETE FROM eod_data WHERE `ticker` = "COP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COP',20070827,80.04,80.82,80.02,80.54,1802700);
INSERT INTO intraday_data VALUES('CRDN',20070827111900,20070827,111900,70.04,70.04,70.04,70.04,100);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.99,70.04,181018);
INSERT INTO intraday_data VALUES('CRI',20070827111900,20070827,111900,19.99,19.99,19.99,19.99,300);
DELETE FROM eod_data WHERE `ticker` = "CRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRI',20070827,20.56,20.56,19.92,19.99,130500);
INSERT INTO intraday_data VALUES('CROX',20070827111900,20070827,111900,59.88,59.91,59.75,59.77,13703);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.55,59.77,3852181);
INSERT INTO intraday_data VALUES('CRS',20070827111900,20070827,111900,115.02,115.02,114.96,114.96,1100);
DELETE FROM eod_data WHERE `ticker` = "CRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRS',20070827,114.59,117.20,114.34,114.96,104600);
INSERT INTO intraday_data VALUES('CSCO',20070827111900,20070827,111900,30.91,30.92,30.88,30.88,130652);
DELETE FROM eod_data WHERE `ticker` = "CSCO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CSCO',20070827,30.51,31.05,30.51,30.88,14581353);
INSERT INTO intraday_data VALUES('CTRP',20070827111900,20070827,111900,42.98,43.03,42.97,43.03,7884);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.03,461801);
INSERT INTO intraday_data VALUES('CTSH',20070827111900,20070827,111900,74.30,74.30,74.25,74.25,1554);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,74.25,703220);
INSERT INTO intraday_data VALUES('CTX',20070827111900,20070827,111900,30.76,30.77,30.72,30.72,4300);
DELETE FROM eod_data WHERE `ticker` = "CTX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTX',20070827,31.74,32.22,30.69,30.72,1073234);
INSERT INTO intraday_data VALUES('CVH',20070827111900,20070827,111900,58.08,58.09,58.08,58.09,900);
DELETE FROM eod_data WHERE `ticker` = "CVH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CVH',20070827,58.00,58.21,57.73,58.09,223500);
INSERT INTO intraday_data VALUES('CXW',20070827111900,20070827,111900,25.48,25.48,25.48,25.48,100);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.30,25.48,348800);
INSERT INTO intraday_data VALUES('CX',20070827111900,20070827,111900,31.37,31.37,31.35,31.35,800);
DELETE FROM eod_data WHERE `ticker` = "CX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CX',20070827,31.86,31.94,31.34,31.35,771300);
INSERT INTO intraday_data VALUES('DECK',20070827111900,20070827,111900,94.60,94.60,94.38,94.52,2088);
DELETE FROM eod_data WHERE `ticker` = "DECK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DECK',20070827,96.35,96.48,94.08,94.52,105216);
INSERT INTO intraday_data VALUES('DIA',20070827111900,20070827,111900,133.18,133.18,133.13,133.14,15100);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.54,132.98,133.14,2557244);
INSERT INTO intraday_data VALUES('DNA',20070827111900,20070827,111900,73.38,73.38,73.36,73.36,2300);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.15,73.36,354500);
INSERT INTO intraday_data VALUES('DRIV',20070827111900,20070827,111900,44.72,44.72,44.72,44.72,100);
DELETE FROM eod_data WHERE `ticker` = "DRIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRIV',20070827,44.64,44.99,44.45,44.72,74760);
INSERT INTO intraday_data VALUES('DRQ',20070827111900,20070827,111900,44.75,44.75,44.75,44.75,600);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.75,44.75,66600);
INSERT INTO intraday_data VALUES('DRYS',20070827111900,20070827,111900,65.62,65.75,65.60,65.60,4752);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.45,63.16,65.60,1036122);
INSERT INTO intraday_data VALUES('EBAY',20070827111900,20070827,111900,33.80,33.80,33.79,33.79,18031);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.79,2632463);
INSERT INTO intraday_data VALUES('ECA',20070827111900,20070827,111900,58.35,58.35,58.31,58.32,4100);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.32,505533);
INSERT INTO intraday_data VALUES('EGY',20070827111900,20070827,111900,3.70,3.70,3.70,3.70,200);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.70,120400);
INSERT INTO intraday_data VALUES('ENR',20070827111900,20070827,111900,107.40,107.42,107.35,107.41,600);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,107.41,248300);
INSERT INTO intraday_data VALUES('EOG',20070827111900,20070827,111900,66.71,66.73,66.68,66.68,2400);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.52,66.68,596550);
INSERT INTO intraday_data VALUES('ESRX',20070827111900,20070827,111900,54.66,54.66,54.58,54.58,2840);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.58,308871);
INSERT INTO intraday_data VALUES('ESV',20070827111900,20070827,111900,56.77,56.77,56.67,56.67,3200);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.67,56.67,527800);
INSERT INTO intraday_data VALUES('EXPD',20070827111900,20070827,111900,45.35,45.38,45.34,45.35,4692);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.69,45.01,45.35,218156);
INSERT INTO intraday_data VALUES('EXP',20070827111900,20070827,111900,38.65,38.73,38.59,38.72,4900);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.31,38.72,154100);
INSERT INTO intraday_data VALUES('EZPW',20070827111900,20070827,111900,12.63,12.63,12.63,12.63,300);
DELETE FROM eod_data WHERE `ticker` = "EZPW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EZPW',20070827,12.65,12.65,12.48,12.63,49898);
INSERT INTO intraday_data VALUES('FDG',20070827111900,20070827,111900,32.60,32.66,32.59,32.59,3600);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.85,32.05,32.59,157100);
INSERT INTO intraday_data VALUES('FFIV',20070827111900,20070827,111900,36.54,36.54,36.40,36.43,5786);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.40,36.43,314448);
INSERT INTO intraday_data VALUES('FIZZ',20070827111900,20070827,111900,10.20,10.20,10.20,10.20,2200);
DELETE FROM eod_data WHERE `ticker` = "FIZZ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FIZZ',20070827,10.29,10.35,10.20,10.20,8178);
INSERT INTO intraday_data VALUES('FLR',20070827111900,20070827,111900,124.36,124.43,124.36,124.41,4600);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.25,123.02,124.41,349575);
INSERT INTO intraday_data VALUES('FMD',20070827111900,20070827,111900,35.20,35.22,35.20,35.22,500);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.44,35.02,35.22,182100);
INSERT INTO intraday_data VALUES('FRK',20070827111900,20070827,111900,62.35,62.35,62.35,62.35,100);
DELETE FROM eod_data WHERE `ticker` = "FRK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRK',20070827,62.83,62.99,62.33,62.35,60300);
INSERT INTO intraday_data VALUES('FRX',20070827111900,20070827,111900,37.16,37.17,37.16,37.16,2500);
DELETE FROM eod_data WHERE `ticker` = "FRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRX',20070827,38.09,38.09,37.10,37.16,809000);
INSERT INTO intraday_data VALUES('FTI',20070827111900,20070827,111900,90.06,90.10,90.01,90.01,1500);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,90.00,90.01,195200);
INSERT INTO intraday_data VALUES('GES',20070827111900,20070827,111900,49.72,49.72,49.62,49.62,3093);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.49,49.62,254193);
INSERT INTO intraday_data VALUES('GGB',20070827111900,20070827,111900,22.82,22.82,22.81,22.81,1000);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.81,22.81,559300);
INSERT INTO intraday_data VALUES('GILD',20070827111900,20070827,111900,36.83,36.84,36.82,36.82,8125);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.77,36.82,1378231);
INSERT INTO intraday_data VALUES('GOOG',20070827111900,20070827,111900,513.16,513.32,513.11,513.11,2041);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,513.11,1099304);
INSERT INTO intraday_data VALUES('GRMN',20070827111900,20070827,111900,101.80,101.83,101.70,101.70,4008);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,101.70,909187);
INSERT INTO intraday_data VALUES('GS',20070827111900,20070827,111900,178.27,178.29,178.13,178.15,5000);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,178.01,178.15,2674200);
INSERT INTO intraday_data VALUES('GTI',20070827111900,20070827,111900,17.25,17.25,17.24,17.24,700);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,17.24,836200);
INSERT INTO intraday_data VALUES('HAL',20070827111900,20070827,111900,33.44,33.45,33.42,33.42,16300);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.41,33.42,3157801);
INSERT INTO intraday_data VALUES('HNR',20070827111900,20070827,111900,11.21,11.21,11.20,11.20,2600);
DELETE FROM eod_data WHERE `ticker` = "HNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HNR',20070827,11.19,11.25,11.01,11.20,65500);
INSERT INTO intraday_data VALUES('HOC',20070827111900,20070827,111900,64.92,64.92,64.77,64.77,3300);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,64.77,301375);
INSERT INTO intraday_data VALUES('HOG',20070827111900,20070827,111900,54.32,54.32,54.21,54.22,5800);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.22,540886);
INSERT INTO intraday_data VALUES('HOV',20070827111900,20070827,111900,11.55,11.55,11.52,11.53,4200);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.52,11.53,646044);
INSERT INTO intraday_data VALUES('HPC',20070827111900,20070827,111900,21.35,21.35,21.33,21.33,1800);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.31,21.33,347769);
INSERT INTO intraday_data VALUES('IBM',20070827111900,20070827,111900,113.24,113.28,113.23,113.23,8200);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.59,112.80,113.23,1405602);
INSERT INTO intraday_data VALUES('ICE',20070827111900,20070827,111900,140.55,140.55,140.50,140.50,600);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.88,140.50,359100);
INSERT INTO intraday_data VALUES('INFY',20070827111900,20070827,111900,46.55,46.56,46.51,46.51,915);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.35,46.51,453097);
INSERT INTO intraday_data VALUES('IVGN',20070827111900,20070827,111900,78.62,78.62,78.61,78.61,500);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,78.79,77.95,78.61,102996);
INSERT INTO intraday_data VALUES('JCI',20070827111900,20070827,111900,111.90,111.93,111.88,111.89,1400);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.54,111.89,110800);
INSERT INTO intraday_data VALUES('JCP',20070827111900,20070827,111900,66.77,66.78,66.75,66.75,3400);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,66.75,669500);
INSERT INTO intraday_data VALUES('JEC',20070827111900,20070827,111900,64.15,64.15,64.04,64.04,800);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.87,64.04,176900);
INSERT INTO intraday_data VALUES('JOYG',20070827111900,20070827,111900,48.27,48.27,48.17,48.17,2875);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.17,537234);
INSERT INTO intraday_data VALUES('JWN',20070827111900,20070827,111900,48.53,48.53,48.35,48.37,13900);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,48.35,48.37,966400);
INSERT INTO intraday_data VALUES('KBH',20070827111900,20070827,111900,30.92,30.92,30.88,30.88,2300);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.86,30.88,785400);
INSERT INTO intraday_data VALUES('KCI',20070827111900,20070827,111900,62.45,62.45,62.45,62.45,200);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,62.25,62.45,131200);
INSERT INTO intraday_data VALUES('KG',20070827111900,20070827,111900,15.62,15.62,15.61,15.61,1400);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.70,15.52,15.61,259000);
INSERT INTO intraday_data VALUES('KSS',20070827111900,20070827,111900,58.31,58.31,58.25,58.25,6300);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,58.25,58.25,1228700);
INSERT INTO intraday_data VALUES('LEH',20070827111900,20070827,111900,58.58,58.58,58.50,58.50,6900);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.50,58.50,2687534);
INSERT INTO intraday_data VALUES('LMT',20070827111900,20070827,111900,100.94,100.97,100.92,100.93,6400);
DELETE FROM eod_data WHERE `ticker` = "LMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LMT',20070827,99.50,100.97,99.12,100.93,496090);
INSERT INTO intraday_data VALUES('LRCX',20070827111900,20070827,111900,52.99,52.99,52.95,52.95,4100);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.88,52.95,853712);
INSERT INTO intraday_data VALUES('LVS',20070827111900,20070827,111900,97.72,97.72,97.60,97.65,9500);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.49,97.65,1119225);
INSERT INTO intraday_data VALUES('MBT',20070827111900,20070827,111900,61.75,61.75,61.61,61.66,2100);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.60,61.61,61.66,243900);
INSERT INTO intraday_data VALUES('MCD',20070827111900,20070827,111900,49.54,49.54,49.52,49.53,12400);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.52,49.53,1331512);
INSERT INTO intraday_data VALUES('MDC',20070827111900,20070827,111900,44.33,44.33,44.33,44.33,600);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,44.33,44.33,230500);
INSERT INTO intraday_data VALUES('MESA',20070827111900,20070827,111900,6.04,6.04,6.04,6.04,1000);
DELETE FROM eod_data WHERE `ticker` = "MESA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MESA',20070827,5.86,6.06,5.81,6.04,82871);
INSERT INTO intraday_data VALUES('MFLX',20070827111900,20070827,111900,12.60,12.60,12.60,12.60,200);
DELETE FROM eod_data WHERE `ticker` = "MFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MFLX',20070827,12.79,12.86,12.60,12.60,11569);
INSERT INTO intraday_data VALUES('MGM',20070827111900,20070827,111900,81.95,81.95,81.92,81.93,1700);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.83,81.93,373500);
INSERT INTO intraday_data VALUES('MICC',20070827111900,20070827,111900,81.99,82.03,81.89,81.89,4200);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.86,81.89,131257);
INSERT INTO intraday_data VALUES('MLM',20070827111900,20070827,111900,131.87,131.91,131.87,131.91,1400);
DELETE FROM eod_data WHERE `ticker` = "MLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MLM',20070827,134.34,135.00,131.69,131.91,166400);
INSERT INTO intraday_data VALUES('MNT',20070827111900,20070827,111900,43.90,43.95,43.90,43.95,1100);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.12,43.63,43.95,210523);
INSERT INTO intraday_data VALUES('MOS',20070827111900,20070827,111900,40.49,40.49,40.44,40.45,1100);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,40.35,40.45,710300);
INSERT INTO intraday_data VALUES('MRVL',20070827111900,20070827,111900,15.41,15.42,15.39,15.40,79490);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.40,7760552);
INSERT INTO intraday_data VALUES('MSFT',20070827111900,20070827,111900,28.49,28.50,28.49,28.49,55580);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.46,28.49,7846907);
INSERT INTO intraday_data VALUES('MSTR',20070827111900,20070827,111900,73.86,73.89,73.77,73.77,1300);
DELETE FROM eod_data WHERE `ticker` = "MSTR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSTR',20070827,75.96,76.50,73.65,73.77,98872);
INSERT INTO intraday_data VALUES('MTH',20070827111900,20070827,111900,18.33,18.33,18.26,18.26,1900);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,18.02,18.26,241991);
INSERT INTO intraday_data VALUES('MTW',20070827111900,20070827,111900,75.77,75.80,75.74,75.74,1300);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.68,75.74,185500);
INSERT INTO intraday_data VALUES('MT',20070827111900,20070827,111900,63.87,63.87,63.78,63.81,8000);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.54,63.81,731560);
INSERT INTO intraday_data VALUES('NEM',20070827111900,20070827,111900,40.47,40.48,40.43,40.45,16800);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.43,40.45,1599100);
INSERT INTO intraday_data VALUES('NEU',20070827111900,20070827,111900,47.72,47.72,47.71,47.72,400);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,47.59,47.72,40600);
INSERT INTO intraday_data VALUES('NFX',20070827111900,20070827,111900,43.58,43.60,43.56,43.56,2100);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.55,43.56,345100);
INSERT INTO intraday_data VALUES('NOV',20070827111900,20070827,111900,118.64,118.64,118.50,118.50,4200);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.50,118.50,738821);
INSERT INTO intraday_data VALUES('NTES',20070827111900,20070827,111900,16.50,16.50,16.50,16.50,700);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.31,16.50,286106);
INSERT INTO intraday_data VALUES('NUE',20070827111900,20070827,111900,53.59,53.63,53.53,53.53,15300);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.50,53.53,2007800);
INSERT INTO intraday_data VALUES('NVDA',20070827111900,20070827,111900,49.09,49.15,49.03,49.03,16331);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.03,3245519);
INSERT INTO intraday_data VALUES('NWRE',20070827111900,20070827,111900,15.96,15.96,15.96,15.96,100);
DELETE FROM eod_data WHERE `ticker` = "NWRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NWRE',20070827,15.83,15.96,15.83,15.96,76162);
INSERT INTO intraday_data VALUES('NYX',20070827111900,20070827,111900,74.05,74.05,74.02,74.05,4300);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,74.02,74.05,596242);
INSERT INTO intraday_data VALUES('OCR',20070827111900,20070827,111900,32.93,32.93,32.91,32.91,1300);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.01,32.66,32.91,173500);
INSERT INTO intraday_data VALUES('OGE',20070827111900,20070827,111900,33.02,33.04,33.02,33.03,2800);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.97,33.03,144400);
INSERT INTO intraday_data VALUES('OII',20070827111900,20070827,111900,64.45,64.45,64.44,64.44,700);
DELETE FROM eod_data WHERE `ticker` = "OII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OII',20070827,65.35,65.45,64.32,64.44,96500);
INSERT INTO intraday_data VALUES('ORCL',20070827111900,20070827,111900,19.86,19.86,19.85,19.85,20604);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.85,6441752);
INSERT INTO intraday_data VALUES('OXY',20070827111900,20070827,111900,56.22,56.22,56.15,56.16,3800);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.16,749600);
INSERT INTO intraday_data VALUES('PBR',20070827111900,20070827,111900,58.76,58.76,58.70,58.70,3500);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.41,58.47,58.70,1109189);
INSERT INTO intraday_data VALUES('PCLN',20070827111900,20070827,111900,80.65,80.65,80.65,80.65,900);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.59,80.65,157445);
INSERT INTO intraday_data VALUES('PCP',20070827111900,20070827,111900,136.78,136.78,136.69,136.69,2700);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.23,136.69,310800);
INSERT INTO intraday_data VALUES('PCR',20070827111900,20070827,111900,55.41,55.41,55.17,55.17,3900);
DELETE FROM eod_data WHERE `ticker` = "PCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCR',20070827,56.99,57.96,55.17,55.17,171300);
INSERT INTO intraday_data VALUES('PCU',20070827111900,20070827,111900,102.23,102.25,102.17,102.19,5800);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.87,102.19,720272);
INSERT INTO intraday_data VALUES('PETS',20070827111900,20070827,111900,15.60,15.60,15.60,15.60,300);
DELETE FROM eod_data WHERE `ticker` = "PETS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PETS',20070827,15.60,15.67,15.33,15.60,85485);
INSERT INTO intraday_data VALUES('PMTI',20070827111900,20070827,111900,30.52,30.52,30.52,30.52,200);
DELETE FROM eod_data WHERE `ticker` = "PMTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PMTI',20070827,30.67,30.72,30.25,30.52,36317);
INSERT INTO intraday_data VALUES('PNK',20070827111900,20070827,111900,27.14,27.14,27.10,27.11,1100);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.27,26.85,27.11,90300);
INSERT INTO intraday_data VALUES('POT',20070827111900,20070827,111900,86.10,86.10,86.10,86.10,100);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.92,86.10,438900);
INSERT INTO intraday_data VALUES('PRFT',20070827111900,20070827,111900,23.32,23.32,23.32,23.32,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.32,102205);
INSERT INTO intraday_data VALUES('PRST',20070827111900,20070827,111900,6.61,6.61,6.61,6.61,400);
DELETE FROM eod_data WHERE `ticker` = "PRST" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRST',20070827,6.52,6.66,6.50,6.61,25245);
INSERT INTO intraday_data VALUES('PTNR',20070827111900,20070827,111900,15.29,15.29,15.27,15.29,2200);
DELETE FROM eod_data WHERE `ticker` = "PTNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PTNR',20070827,15.30,15.43,15.25,15.29,118243);
INSERT INTO intraday_data VALUES('QQQQ',20070827111900,20070827,111900,47.92,47.92,47.89,47.89,64150);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.89,47.89,23862880);
INSERT INTO intraday_data VALUES('QSII',20070827111900,20070827,111900,37.90,37.90,37.90,37.90,100);
DELETE FROM eod_data WHERE `ticker` = "QSII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QSII',20070827,38.16,38.37,37.79,37.90,44645);
INSERT INTO intraday_data VALUES('RAI',20070827111900,20070827,111900,65.10,65.13,65.10,65.11,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.11,260300);
INSERT INTO intraday_data VALUES('RIG',20070827111900,20070827,111900,102.41,102.42,102.34,102.36,12400);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,102.28,102.36,990500);
INSERT INTO intraday_data VALUES('RIMM',20070827111900,20070827,111900,81.01,81.07,80.98,80.98,10998);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.88,80.98,2479926);
INSERT INTO intraday_data VALUES('RIO',20070827111900,20070827,111900,47.28,47.31,47.24,47.24,35400);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.93,47.09,47.24,4433866);
INSERT INTO intraday_data VALUES('RL',20070827111900,20070827,111900,76.97,76.97,76.89,76.89,4000);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.82,76.89,354900);
INSERT INTO intraday_data VALUES('RMD',20070827111900,20070827,111900,41.60,41.60,41.59,41.59,1100);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.59,41.59,98500);
INSERT INTO intraday_data VALUES('RTP',20070827111900,20070827,111900,270.97,271.63,270.73,271.54,1200);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,271.54,136800);
INSERT INTO intraday_data VALUES('RYL',20070827111900,20070827,111900,30.70,30.70,30.69,30.69,3200);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.69,30.69,455381);
INSERT INTO intraday_data VALUES('SBGI',20070827111900,20070827,111900,12.53,12.55,12.53,12.55,2000);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.42,12.55,429976);
INSERT INTO intraday_data VALUES('SBUX',20070827111900,20070827,111900,27.42,27.42,27.41,27.41,18136);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.40,27.41,1251845);
INSERT INTO intraday_data VALUES('SCI',20070827111900,20070827,111900,12.04,12.04,12.02,12.02,1200);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,12.02,12.02,124000);
INSERT INTO intraday_data VALUES('SCUR',20070827111900,20070827,111900,8.33,8.33,8.32,8.32,600);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.26,8.32,143429);
INSERT INTO intraday_data VALUES('SEIC',20070827111900,20070827,111900,25.78,25.79,25.78,25.79,600);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.79,91434);
INSERT INTO intraday_data VALUES('SID',20070827111900,20070827,111900,52.81,52.81,52.78,52.78,400);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.74,52.78,458600);
INSERT INTO intraday_data VALUES('SII',20070827111900,20070827,111900,62.24,62.25,62.17,62.19,5600);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.17,62.19,420700);
INSERT INTO intraday_data VALUES('SIMG',20070827111900,20070827,111900,5.86,5.86,5.86,5.86,700);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.81,5.86,222932);
INSERT INTO intraday_data VALUES('SKX',20070827111900,20070827,111900,19.93,19.95,19.91,19.91,900);
DELETE FROM eod_data WHERE `ticker` = "SKX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SKX',20070827,20.10,20.10,19.90,19.91,114600);
INSERT INTO intraday_data VALUES('SLB',20070827111900,20070827,111900,92.40,92.43,92.35,92.37,7100);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.20,92.37,1604700);
INSERT INTO intraday_data VALUES('SNDK',20070827111900,20070827,111900,52.25,52.25,52.20,52.20,28925);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.20,52.20,3072596);
INSERT INTO intraday_data VALUES('SNE',20070827111900,20070827,111900,46.39,46.39,46.39,46.39,400);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.39,189796);
INSERT INTO intraday_data VALUES('SPF',20070827111900,20070827,111900,9.98,9.98,9.96,9.96,6900);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.96,670800);
INSERT INTO intraday_data VALUES('SPG',20070827111900,20070827,111900,92.56,92.56,92.48,92.48,600);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,92.48,262600);
INSERT INTO intraday_data VALUES('SPIL',20070827111900,20070827,111900,10.15,10.15,10.15,10.15,300);
DELETE FROM eod_data WHERE `ticker` = "SPIL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPIL',20070827,10.26,10.26,10.00,10.15,340590);
INSERT INTO intraday_data VALUES('SPN',20070827111900,20070827,111900,38.15,38.15,38.12,38.12,800);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.12,38.12,118000);
INSERT INTO intraday_data VALUES('SPWR',20070827111900,20070827,111900,62.97,62.97,62.97,62.97,300);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.80,62.97,260713);
INSERT INTO intraday_data VALUES('SPY',20070827111900,20070827,111900,147.18,147.20,147.13,147.13,149300);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,147.13,147.13,33488202);
INSERT INTO intraday_data VALUES('STLD',20070827111900,20070827,111900,43.07,43.09,43.07,43.07,1978);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.06,43.07,427735);
INSERT INTO intraday_data VALUES('STR',20070827111900,20070827,111900,49.48,49.48,49.47,49.47,1300);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.43,49.47,334000);
INSERT INTO intraday_data VALUES('SWKS',20070827111900,20070827,111900,7.73,7.73,7.73,7.73,1602);
DELETE FROM eod_data WHERE `ticker` = "SWKS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWKS',20070827,7.88,7.95,7.72,7.73,494644);
INSERT INTO intraday_data VALUES('SWN',20070827111900,20070827,111900,37.57,37.59,37.54,37.54,2200);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.54,561400);
INSERT INTO intraday_data VALUES('SYKE',20070827111900,20070827,111900,16.71,16.71,16.71,16.71,100);
DELETE FROM eod_data WHERE `ticker` = "SYKE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYKE',20070827,16.96,16.96,16.67,16.71,28876);
INSERT INTO intraday_data VALUES('SYK',20070827111900,20070827,111900,67.28,67.28,67.25,67.25,800);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.11,67.25,203932);
INSERT INTO intraday_data VALUES('TDW',20070827111900,20070827,111900,64.63,64.63,64.60,64.60,3200);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.25,64.58,64.60,306115);
INSERT INTO intraday_data VALUES('TECH',20070827111900,20070827,111900,62.51,62.51,62.51,62.51,100);
DELETE FROM eod_data WHERE `ticker` = "TECH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TECH',20070827,62.17,62.79,62.12,62.51,44181);
INSERT INTO intraday_data VALUES('TEX',20070827111900,20070827,111900,78.05,78.08,78.02,78.02,1700);
DELETE FROM eod_data WHERE `ticker` = "TEX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TEX',20070827,80.00,80.17,78.00,78.02,359900);
INSERT INTO intraday_data VALUES('TLM',20070827111900,20070827,111900,16.99,16.99,16.99,16.99,5700);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.97,16.99,520000);
INSERT INTO intraday_data VALUES('TNB',20070827111900,20070827,111900,55.55,55.56,55.49,55.49,2000);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.49,151300);
INSERT INTO intraday_data VALUES('TOL',20070827111900,20070827,111900,22.45,22.47,22.43,22.44,16400);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.41,22.44,1477966);
INSERT INTO intraday_data VALUES('TOPT',20070827111900,20070827,111900,5.76,5.76,5.76,5.76,1080);
DELETE FROM eod_data WHERE `ticker` = "TOPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOPT',20070827,5.84,5.84,5.73,5.76,106888);
INSERT INTO intraday_data VALUES('TRAD',20070827111900,20070827,111900,10.73,10.73,10.73,10.73,100);
DELETE FROM eod_data WHERE `ticker` = "TRAD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRAD',20070827,10.88,10.92,10.71,10.73,77264);
INSERT INTO intraday_data VALUES('TSN',20070827111900,20070827,111900,21.32,21.32,21.31,21.31,3300);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.30,21.31,404105);
INSERT INTO intraday_data VALUES('TSO',20070827111900,20070827,111900,49.43,49.46,49.43,49.43,5700);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.35,49.43,814000);
INSERT INTO intraday_data VALUES('TS',20070827111900,20070827,111900,46.59,46.61,46.58,46.60,40200);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.60,974300);
INSERT INTO intraday_data VALUES('TXU',20070827111900,20070827,111900,66.10,66.12,66.06,66.06,3100);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.87,66.06,1391700);
INSERT INTO intraday_data VALUES('UFPI',20070827111900,20070827,111900,37.98,37.98,37.93,37.93,478);
DELETE FROM eod_data WHERE `ticker` = "UFPI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UFPI',20070827,38.17,38.87,37.74,37.93,21860);
INSERT INTO intraday_data VALUES('UNH',20070827111900,20070827,111900,49.63,49.64,49.62,49.62,9400);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.38,49.62,1247680);
INSERT INTO intraday_data VALUES('UPL',20070827111900,20070827,111900,54.76,54.76,54.76,54.76,100);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.76,303500);
INSERT INTO intraday_data VALUES('URBN',20070827111900,20070827,111900,22.61,22.61,22.56,22.56,6716);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.54,22.56,791236);
INSERT INTO intraday_data VALUES('USG',20070827111900,20070827,111900,38.05,38.06,38.04,38.04,500);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,38.03,38.04,231700);
INSERT INTO intraday_data VALUES('VIP',20070827111900,20070827,111900,22.16,22.17,22.15,22.15,2700);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.15,22.15,651830);
INSERT INTO intraday_data VALUES('VLO',20070827111900,20070827,111900,67.47,67.55,67.47,67.47,27400);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.47,1583694);
INSERT INTO intraday_data VALUES('VSEA',20070827111900,20070827,111900,54.97,55.02,54.95,54.98,4422);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,56.58,54.80,54.98,877077);
INSERT INTO intraday_data VALUES('WBSN',20070827111900,20070827,111900,20.46,20.46,20.45,20.45,500);
DELETE FROM eod_data WHERE `ticker` = "WBSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WBSN',20070827,20.73,20.91,20.45,20.45,32317);
INSERT INTO intraday_data VALUES('WCC',20070827111900,20070827,111900,48.16,48.18,48.16,48.18,300);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,48.03,48.18,129294);
INSERT INTO intraday_data VALUES('WDC',20070827111900,20070827,111900,21.93,21.93,21.93,21.93,100);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.87,21.93,748600);
INSERT INTO intraday_data VALUES('WFMI',20070827111900,20070827,111900,45.72,45.73,45.68,45.68,4350);
DELETE FROM eod_data WHERE `ticker` = "WFMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFMI',20070827,44.59,46.08,44.56,45.68,1488913);
INSERT INTO intraday_data VALUES('WFR',20070827111900,20070827,111900,58.84,58.84,58.79,58.81,1100);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.56,58.81,379400);
INSERT INTO intraday_data VALUES('WFT',20070827111900,20070827,111900,55.86,55.89,55.80,55.80,6600);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.80,55.80,721400);
INSERT INTO intraday_data VALUES('WHQ',20070827111900,20070827,111900,60.78,60.78,60.75,60.75,1500);
DELETE FROM eod_data WHERE `ticker` = "WHQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WHQ',20070827,61.80,62.05,60.75,60.75,50300);
INSERT INTO intraday_data VALUES('WLP',20070827111900,20070827,111900,78.40,78.42,78.40,78.40,3800);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.54,77.89,78.40,753800);
INSERT INTO intraday_data VALUES('WNR',20070827111900,20070827,111900,52.28,52.28,52.28,52.28,200);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,52.27,52.28,263200);
INSERT INTO intraday_data VALUES('XING',20070827111900,20070827,111900,9.16,9.18,9.16,9.18,3100);
DELETE FROM eod_data WHERE `ticker` = "XING" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('XING',20070827,8.98,9.38,8.83,9.18,197759);
INSERT INTO intraday_data VALUES('X',20070827111900,20070827,111900,93.21,93.22,93.14,93.14,2600);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,93.05,93.14,1289704);
INSERT INTO intraday_data VALUES('YHOO',20070827111900,20070827,111900,23.37,23.38,23.36,23.36,8225);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.34,23.36,3909628);