INSERT INTO intraday_data VALUES('$COMPX',20070827135500,20070827,135500,2563.37,2563.64,2563.21,2563.21,0);
DELETE FROM eod_data WHERE `ticker` = "$COMPX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$COMPX',20070827,2570.41,2573.58,2557.48,2563.21,0);
INSERT INTO intraday_data VALUES('$DJUSAE',20070827135500,20070827,135500,513.24,513.24,513.24,513.24,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAE',20070827,513.45,514.50,510.20,513.24,0);
INSERT INTO intraday_data VALUES('$DJUSAF',20070827135500,20070827,135500,640.10,640.10,640.10,640.10,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAF',20070827,638.59,643.96,637.78,640.10,0);
INSERT INTO intraday_data VALUES('$DJUSAG',20070827135500,20070827,135500,150.32,150.32,150.32,150.32,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAG',20070827,151.64,151.64,150.32,150.32,0);
INSERT INTO intraday_data VALUES('$DJUSAL',20070827135500,20070827,135500,313.47,313.47,313.47,313.47,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.47,0);
INSERT INTO intraday_data VALUES('$DJUSAM',20070827135500,20070827,135500,534.16,534.16,534.16,534.16,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAM',20070827,535.81,536.28,533.15,534.16,0);
INSERT INTO intraday_data VALUES('$DJUSAS',20070827135500,20070827,135500,543.40,543.40,543.40,543.40,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAS',20070827,543.79,544.63,539.56,543.40,0);
INSERT INTO intraday_data VALUES('$DJUSAV',20070827135500,20070827,135500,427.11,427.11,427.11,427.11,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSAV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSAV',20070827,429.23,429.23,425.97,427.11,0);
INSERT INTO intraday_data VALUES('$DJUSBM',20070827135500,20070827,135500,270.32,270.35,270.29,270.32,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.32,0);
INSERT INTO intraday_data VALUES('$DJUSBT',20070827135500,20070827,135500,449.00,449.00,449.00,449.00,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSBT',20070827,451.22,452.85,448.40,449.00,0);
INSERT INTO intraday_data VALUES('$DJUSCE',20070827135500,20070827,135500,1350.18,1350.18,1350.18,1350.18,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCE',20070827,1364.01,1364.01,1344.23,1350.18,0);
INSERT INTO intraday_data VALUES('$DJUSCM',20070827135500,20070827,135500,290.81,290.81,290.81,290.81,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSCM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSCM',20070827,293.88,293.88,290.81,290.81,0);
INSERT INTO intraday_data VALUES('$DJUSCY',20070827135500,20070827,135500,335.09,335.12,335.05,335.05,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.05,0);
INSERT INTO intraday_data VALUES('$DJUSDN',20070827135500,20070827,135500,147.30,147.30,147.30,147.30,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDN',20070827,147.34,147.82,146.73,147.30,0);
INSERT INTO intraday_data VALUES('$DJUSDR',20070827135500,20070827,135500,341.58,341.58,341.58,341.58,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSDR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSDR',20070827,342.19,343.12,341.58,341.58,0);
INSERT INTO intraday_data VALUES('$DJUSEE',20070827135500,20070827,135500,175.82,175.82,175.82,175.82,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEE',20070827,176.91,176.91,175.40,175.82,0);
INSERT INTO intraday_data VALUES('$DJUSEN',20070827135500,20070827,135500,594.46,594.69,594.44,594.44,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSEN',20070827,600.57,600.57,592.62,594.44,0);
INSERT INTO intraday_data VALUES('$DJUSFC',20070827135500,20070827,135500,179.70,179.70,179.70,179.70,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFC',20070827,177.25,180.37,177.25,179.70,0);
INSERT INTO intraday_data VALUES('$DJUSFH',20070827135500,20070827,135500,221.30,221.30,221.30,221.30,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFH',20070827,224.79,224.79,221.28,221.30,0);
INSERT INTO intraday_data VALUES('$DJUSFN',20070827135500,20070827,135500,545.68,545.85,545.68,545.72,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFN',20070827,552.10,552.10,545.68,545.72,0);
INSERT INTO intraday_data VALUES('$DJUSFO',20070827135500,20070827,135500,201.90,201.90,201.90,201.90,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSFO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSFO',20070827,200.18,202.38,199.99,201.90,0);
INSERT INTO intraday_data VALUES('$DJUSGT',20070827135500,20070827,135500,353.07,353.07,353.07,353.07,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSGT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSGT',20070827,355.38,356.60,352.88,353.07,0);
INSERT INTO intraday_data VALUES('$DJUSHC',20070827135500,20070827,135500,343.01,343.09,343.01,343.02,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHC',20070827,343.94,344.09,342.98,343.02,0);
INSERT INTO intraday_data VALUES('$DJUSHG',20070827135500,20070827,135500,390.75,390.75,390.75,390.75,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHG',20070827,396.25,396.25,390.28,390.75,0);
INSERT INTO intraday_data VALUES('$DJUSHI',20070827135500,20070827,135500,90.74,90.74,90.74,90.74,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSHI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSHI',20070827,91.34,91.44,90.61,90.74,0);
INSERT INTO intraday_data VALUES('$DJUSIN',20070827135500,20070827,135500,350.68,350.76,350.68,350.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIN',20070827,352.45,352.45,349.76,350.68,0);
INSERT INTO intraday_data VALUES('$DJUSIR',20070827135500,20070827,135500,457.87,457.87,457.87,457.87,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIR',20070827,460.14,460.25,457.87,457.87,0);
INSERT INTO intraday_data VALUES('$DJUSIS',20070827135500,20070827,135500,179.77,179.77,179.77,179.77,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIS',20070827,180.74,180.74,179.62,179.77,0);
INSERT INTO intraday_data VALUES('$DJUSIT',20070827135500,20070827,135500,395.33,395.33,395.33,395.33,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIT',20070827,391.71,400.72,391.71,395.33,0);
INSERT INTO intraday_data VALUES('$DJUSIU',20070827135500,20070827,135500,106.50,106.50,106.50,106.50,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSIU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSIU',20070827,107.55,107.55,106.50,106.50,0);
INSERT INTO intraday_data VALUES('$DJUSLE',20070827135500,20070827,135500,318.61,318.61,318.61,318.61,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSLE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSLE',20070827,321.54,321.54,317.62,318.61,0);
INSERT INTO intraday_data VALUES('$DJUSLG',20070827135500,20070827,135500,729.40,729.40,729.40,729.40,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSLG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSLG',20070827,735.87,735.87,726.50,729.40,0);
INSERT INTO intraday_data VALUES('$DJUSMF',20070827135500,20070827,135500,80.56,80.56,80.56,80.56,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMF',20070827,82.03,82.03,80.56,80.56,0);
INSERT INTO intraday_data VALUES('$DJUSMG',20070827135500,20070827,135500,154.41,154.41,154.41,154.41,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMG',20070827,158.00,158.00,154.17,154.41,0);
INSERT INTO intraday_data VALUES('$DJUSMT',20070827135500,20070827,135500,337.10,337.10,337.10,337.10,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSMT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSMT',20070827,340.44,340.44,334.61,337.10,0);
INSERT INTO intraday_data VALUES('$DJUSNC',20070827135500,20070827,135500,308.61,308.63,308.61,308.61,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.61,0);
INSERT INTO intraday_data VALUES('$DJUSNG',20070827135500,20070827,135500,376.02,376.02,376.02,376.02,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSNG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSNG',20070827,378.20,378.39,375.73,376.02,0);
INSERT INTO intraday_data VALUES('$DJUSOG',20070827135500,20070827,135500,564.57,564.57,564.57,564.57,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOG',20070827,560.07,570.20,552.48,564.57,0);
INSERT INTO intraday_data VALUES('$DJUSOL',20070827135500,20070827,135500,544.31,544.31,544.31,544.31,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOL',20070827,547.73,547.73,542.85,544.31,0);
INSERT INTO intraday_data VALUES('$DJUSOQ',20070827135500,20070827,135500,696.90,696.90,696.90,696.90,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSOQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSOQ',20070827,706.87,706.87,692.76,696.90,0);
INSERT INTO intraday_data VALUES('$DJUSPN',20070827135500,20070827,135500,303.47,303.47,303.47,303.47,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPN',20070827,304.68,304.68,303.29,303.47,0);
INSERT INTO intraday_data VALUES('$DJUSPT',20070827135500,20070827,135500,78.54,78.54,78.54,78.54,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSPT',20070827,76.28,84.13,75.29,78.54,0);
INSERT INTO intraday_data VALUES('$DJUSRE',20070827135500,20070827,135500,282.59,282.59,282.49,282.49,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRE',20070827,287.10,287.12,282.49,282.49,0);
INSERT INTO intraday_data VALUES('$DJUSRH',20070827135500,20070827,135500,404.99,404.99,404.78,404.90,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRH',20070827,410.12,410.12,403.97,404.90,0);
INSERT INTO intraday_data VALUES('$DJUSRI',20070827135500,20070827,135500,115.42,115.43,115.41,115.41,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRI',20070827,117.28,117.34,115.41,115.41,0);
INSERT INTO intraday_data VALUES('$DJUSRQ',20070827135500,20070827,135500,84.06,84.06,84.06,84.06,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRQ',20070827,84.04,84.41,83.65,84.06,0);
INSERT INTO intraday_data VALUES('$DJUSRR',20070827135500,20070827,135500,449.68,449.68,449.68,449.68,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRR',20070827,447.34,453.55,446.51,449.68,0);
INSERT INTO intraday_data VALUES('$DJUSRT',20070827135500,20070827,135500,371.19,371.19,371.19,371.19,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSRT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSRT',20070827,369.66,374.33,367.07,371.19,0);
INSERT INTO intraday_data VALUES('$DJUSSC',20070827135500,20070827,135500,1332.18,1332.69,1332.18,1332.36,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSC',20070827,1345.65,1345.65,1327.39,1332.36,0);
INSERT INTO intraday_data VALUES('$DJUSSF',20070827135500,20070827,135500,105.94,105.94,105.94,105.94,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSSF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSSF',20070827,106.04,106.55,105.94,105.94,0);
INSERT INTO intraday_data VALUES('$DJUSTC',20070827135500,20070827,135500,613.04,613.21,613.02,613.02,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.02,0);
INSERT INTO intraday_data VALUES('$DJUSTL',20070827135500,20070827,135500,187.14,187.23,187.14,187.22,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.22,0);
INSERT INTO intraday_data VALUES('$DJUSTT',20070827135500,20070827,135500,130.59,130.59,130.59,130.59,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSTT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSTT',20070827,130.48,131.05,129.88,130.59,0);
INSERT INTO intraday_data VALUES('$DJUSUT',20070827135500,20070827,135500,185.50,185.51,185.49,185.49,0);
DELETE FROM eod_data WHERE `ticker` = "$DJUSUT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$DJUSUT',20070827,191.11,191.11,185.49,185.49,0);
INSERT INTO intraday_data VALUES('$GOX.X',20070827135500,20070827,135500,136.92,136.96,136.92,136.94,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,136.94,0);
INSERT INTO intraday_data VALUES('$IDX',20070827135500,20070827,135500,855.26,855.26,855.09,855.09,0);
DELETE FROM eod_data WHERE `ticker` = "$IDX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IDX',20070827,864.32,864.32,853.84,855.09,0);
INSERT INTO intraday_data VALUES('$INDU',20070827135500,20070827,135500,13340.42,13345.22,13339.20,13341.07,0);
DELETE FROM eod_data WHERE `ticker` = "$INDU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INDU',20070827,13377.16,13378.63,13305.87,13341.07,0);
INSERT INTO intraday_data VALUES('$INX',20070827135500,20070827,135500,1468.62,1468.86,1468.46,1468.70,0);
DELETE FROM eod_data WHERE `ticker` = "$INX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$INX',20070827,1478.52,1478.52,1467.23,1468.70,0);
INSERT INTO intraday_data VALUES('$IUX',20070827135500,20070827,135500,789.50,789.50,789.30,789.30,0);
DELETE FROM eod_data WHERE `ticker` = "$IUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('$IUX',20070827,797.78,797.78,788.57,789.30,0);
INSERT INTO intraday_data VALUES('$NYA.X',20070827135500,20070827,135500,9534.77,9536.11,9534.38,9534.38,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,9534.38,0);
INSERT INTO intraday_data VALUES('$OEX.X',20070827135500,20070827,135500,685.19,685.43,685.19,685.32,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.32,0);
INSERT INTO intraday_data VALUES('$OIX.X',20070827135500,20070827,135500,730.13,730.30,730.13,730.22,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,730.22,0);
INSERT INTO intraday_data VALUES('$SML.X',20070827135500,20070827,135500,415.98,415.98,415.90,415.90,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,415.90,0);
INSERT INTO intraday_data VALUES('$VIX',20070827135500,20070827,135500,22.46,22.46,22.42,22.46,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',20070827135500,20070827,135500,10.27,10.27,10.26,10.26,1200);
DELETE FROM eod_data WHERE `ticker` = "AAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AAI',20070827,10.24,10.38,10.13,10.26,1075306);
INSERT INTO intraday_data VALUES('ACLI',20070827135500,20070827,135500,24.02,24.02,24.00,24.00,3606);
DELETE FROM eod_data WHERE `ticker` = "ACLI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACLI',20070827,24.29,24.29,23.69,24.00,354772);
INSERT INTO intraday_data VALUES('ACL',20070827135500,20070827,135500,133.49,133.54,133.48,133.54,1400);
DELETE FROM eod_data WHERE `ticker` = "ACL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ACL',20070827,135.80,135.80,133.19,133.54,237400);
INSERT INTO intraday_data VALUES('ADSK',20070827135500,20070827,135500,45.38,45.38,45.36,45.38,900);
DELETE FROM eod_data WHERE `ticker` = "ADSK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADSK',20070827,44.99,45.60,44.75,45.38,803309);
INSERT INTO intraday_data VALUES('ADS',20070827135500,20070827,135500,76.60,76.60,76.60,76.60,300);
DELETE FROM eod_data WHERE `ticker` = "ADS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ADS',20070827,76.99,77.04,76.43,76.60,377200);
INSERT INTO intraday_data VALUES('AIRM',20070827135500,20070827,135500,40.63,40.63,40.63,40.63,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.63,66448);
INSERT INTO intraday_data VALUES('AMD',20070827135500,20070827,135500,12.03,12.03,12.02,12.02,10400);
DELETE FROM eod_data WHERE `ticker` = "AMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMD',20070827,12.08,12.25,11.96,12.02,9753075);
INSERT INTO intraday_data VALUES('AMTD',20070827135500,20070827,135500,17.68,17.68,17.68,17.68,1767);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.78,17.40,17.68,1433403);
INSERT INTO intraday_data VALUES('AMX',20070827135500,20070827,135500,60.58,60.62,60.57,60.62,9400);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.76,60.06,60.62,1789300);
INSERT INTO intraday_data VALUES('AMZN',20070827135500,20070827,135500,79.26,79.35,79.22,79.31,28900);
DELETE FROM eod_data WHERE `ticker` = "AMZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMZN',20070827,80.56,80.80,79.00,79.31,4403456);
INSERT INTO intraday_data VALUES('ANF',20070827135500,20070827,135500,79.37,79.47,79.37,79.47,8700);
DELETE FROM eod_data WHERE `ticker` = "ANF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ANF',20070827,80.00,80.73,78.65,79.47,1061300);
INSERT INTO intraday_data VALUES('AOB',20070827135500,20070827,135500,9.32,9.33,9.32,9.33,1200);
DELETE FROM eod_data WHERE `ticker` = "AOB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AOB',20070827,9.13,9.43,9.03,9.33,906700);
INSERT INTO intraday_data VALUES('AZN',20070827135500,20070827,135500,48.28,48.28,48.27,48.27,900);
DELETE FROM eod_data WHERE `ticker` = "AZN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AZN',20070827,48.45,48.62,48.15,48.27,381900);
INSERT INTO intraday_data VALUES('BA',20070827135500,20070827,135500,98.45,98.47,98.42,98.45,8400);
DELETE FROM eod_data WHERE `ticker` = "BA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BA',20070827,98.07,98.67,97.13,98.45,1840405);
INSERT INTO intraday_data VALUES('BEN',20070827135500,20070827,135500,132.83,132.83,132.63,132.64,3000);
DELETE FROM eod_data WHERE `ticker` = "BEN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BEN',20070827,134.15,134.62,132.63,132.64,422416);
INSERT INTO intraday_data VALUES('BG',20070827135500,20070827,135500,88.52,88.53,88.50,88.50,500);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,88.70,87.03,88.50,276100);
INSERT INTO intraday_data VALUES('BPT',20070827135500,20070827,135500,70.86,70.86,70.86,70.86,100);
DELETE FROM eod_data WHERE `ticker` = "BPT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BPT',20070827,71.05,71.20,70.53,70.86,51400);
INSERT INTO intraday_data VALUES('BRCD',20070827135500,20070827,135500,7.00,7.00,6.99,6.99,36770);
DELETE FROM eod_data WHERE `ticker` = "BRCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BRCD',20070827,7.23,7.24,6.98,6.99,5764476);
INSERT INTO intraday_data VALUES('BZH',20070827135500,20070827,135500,9.66,9.66,9.65,9.65,3400);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.65,1448300);
INSERT INTO intraday_data VALUES('CBB',20070827135500,20070827,135500,4.95,4.95,4.94,4.95,3200);
DELETE FROM eod_data WHERE `ticker` = "CBB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CBB',20070827,4.92,5.00,4.91,4.95,517400);
INSERT INTO intraday_data VALUES('CEG',20070827135500,20070827,135500,83.45,83.45,83.40,83.40,3100);
DELETE FROM eod_data WHERE `ticker` = "CEG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CEG',20070827,87.08,87.19,83.40,83.40,1026700);
INSERT INTO intraday_data VALUES('CERN',20070827135500,20070827,135500,56.29,56.29,56.25,56.26,640);
DELETE FROM eod_data WHERE `ticker` = "CERN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CERN',20070827,57.49,57.49,56.25,56.26,134510);
INSERT INTO intraday_data VALUES('CHAP',20070827135500,20070827,135500,85.39,85.39,85.39,85.39,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.39,323777);
INSERT INTO intraday_data VALUES('CHINA',20070827135500,20070827,135500,8.45,8.45,8.45,8.45,100);
DELETE FROM eod_data WHERE `ticker` = "CHINA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHINA',20070827,8.20,8.50,8.20,8.45,718407);
INSERT INTO intraday_data VALUES('CHRW',20070827135500,20070827,135500,49.08,49.12,49.07,49.12,1300);
DELETE FROM eod_data WHERE `ticker` = "CHRW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CHRW',20070827,49.29,49.69,48.88,49.12,276800);
INSERT INTO intraday_data VALUES('CME',20070827135500,20070827,135500,559.23,559.44,559.23,559.25,700);
DELETE FROM eod_data WHERE `ticker` = "CME" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CME',20070827,556.50,559.87,556.00,559.25,355414);
INSERT INTO intraday_data VALUES('CMI',20070827135500,20070827,135500,115.42,115.42,115.28,115.29,2800);
DELETE FROM eod_data WHERE `ticker` = "CMI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CMI',20070827,116.25,118.00,114.97,115.29,589400);
INSERT INTO intraday_data VALUES('COGO',20070827135500,20070827,135500,17.28,17.28,17.27,17.27,450);
DELETE FROM eod_data WHERE `ticker` = "COGO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COGO',20070827,17.16,17.64,17.16,17.27,226473);
INSERT INTO intraday_data VALUES('COG',20070827135500,20070827,135500,32.58,32.58,32.57,32.58,1600);
DELETE FROM eod_data WHERE `ticker` = "COG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COG',20070827,33.22,33.42,32.39,32.58,298100);
INSERT INTO intraday_data VALUES('COH',20070827135500,20070827,135500,43.38,43.41,43.36,43.41,5900);
DELETE FROM eod_data WHERE `ticker` = "COH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('COH',20070827,44.94,44.94,43.00,43.41,2824052);
INSERT INTO intraday_data VALUES('CRDN',20070827135500,20070827,135500,69.99,70.00,69.97,69.97,1720);
DELETE FROM eod_data WHERE `ticker` = "CRDN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRDN',20070827,71.18,71.72,69.66,69.97,304327);
INSERT INTO intraday_data VALUES('CROX',20070827135500,20070827,135500,59.95,59.98,59.95,59.95,3700);
DELETE FROM eod_data WHERE `ticker` = "CROX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CROX',20070827,61.43,61.99,59.51,59.95,5501930);
INSERT INTO intraday_data VALUES('CRS',20070827135500,20070827,135500,115.71,115.71,115.61,115.61,300);
DELETE FROM eod_data WHERE `ticker` = "CRS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CRS',20070827,114.59,117.20,114.34,115.61,199500);
INSERT INTO intraday_data VALUES('CTRP',20070827135500,20070827,135500,43.60,43.60,43.60,43.60,200);
DELETE FROM eod_data WHERE `ticker` = "CTRP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTRP',20070827,42.27,43.88,42.00,43.60,645975);
INSERT INTO intraday_data VALUES('CTSH',20070827135500,20070827,135500,72.82,72.86,72.80,72.86,1100);
DELETE FROM eod_data WHERE `ticker` = "CTSH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CTSH',20070827,72.25,74.93,72.15,72.86,1214294);
INSERT INTO intraday_data VALUES('CXW',20070827135500,20070827,135500,25.27,25.30,25.27,25.29,17400);
DELETE FROM eod_data WHERE `ticker` = "CXW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CXW',20070827,25.54,25.79,25.25,25.29,811300);
INSERT INTO intraday_data VALUES('DECK',20070827135500,20070827,135500,93.83,93.88,93.83,93.84,300);
DELETE FROM eod_data WHERE `ticker` = "DECK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DECK',20070827,96.35,96.48,93.83,93.84,144499);
INSERT INTO intraday_data VALUES('DIA',20070827135500,20070827,135500,133.35,133.39,133.27,133.34,50000);
DELETE FROM eod_data WHERE `ticker` = "DIA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DIA',20070827,133.36,133.73,132.98,133.34,4840184);
INSERT INTO intraday_data VALUES('DNA',20070827135500,20070827,135500,73.12,73.12,73.09,73.10,8500);
DELETE FROM eod_data WHERE `ticker` = "DNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DNA',20070827,73.24,73.67,73.05,73.10,803080);
INSERT INTO intraday_data VALUES('DRIV',20070827135500,20070827,135500,44.57,44.57,44.57,44.57,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.57,130681);
INSERT INTO intraday_data VALUES('DRQ',20070827135500,20070827,135500,44.73,44.74,44.70,44.74,1200);
DELETE FROM eod_data WHERE `ticker` = "DRQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRQ',20070827,45.55,46.30,44.58,44.74,135800);
INSERT INTO intraday_data VALUES('DRYS',20070827135500,20070827,135500,66.75,66.78,66.72,66.73,900);
DELETE FROM eod_data WHERE `ticker` = "DRYS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DRYS',20070827,64.64,67.74,63.16,66.73,1670583);
INSERT INTO intraday_data VALUES('DVR',20070827135500,20070827,135500,14.47,14.48,14.47,14.47,2600);
DELETE FROM eod_data WHERE `ticker` = "DVR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('DVR',20070827,14.68,14.68,14.37,14.47,333900);
INSERT INTO intraday_data VALUES('EBAY',20070827135500,20070827,135500,33.62,33.64,33.61,33.64,8913);
DELETE FROM eod_data WHERE `ticker` = "EBAY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EBAY',20070827,33.65,34.11,33.53,33.64,4954656);
INSERT INTO intraday_data VALUES('ECA',20070827135500,20070827,135500,58.19,58.20,58.17,58.18,1600);
DELETE FROM eod_data WHERE `ticker` = "ECA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ECA',20070827,58.88,58.88,58.06,58.18,897833);
INSERT INTO intraday_data VALUES('EGY',20070827135500,20070827,135500,3.73,3.73,3.72,3.72,300);
DELETE FROM eod_data WHERE `ticker` = "EGY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EGY',20070827,3.72,3.78,3.70,3.72,207200);
INSERT INTO intraday_data VALUES('ENR',20070827135500,20070827,135500,107.17,107.19,107.17,107.19,400);
DELETE FROM eod_data WHERE `ticker` = "ENR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ENR',20070827,108.68,108.82,106.58,107.19,430600);
INSERT INTO intraday_data VALUES('EOG',20070827135500,20070827,135500,66.66,66.72,66.66,66.66,7100);
DELETE FROM eod_data WHERE `ticker` = "EOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EOG',20070827,67.61,67.61,66.45,66.66,1042850);
INSERT INTO intraday_data VALUES('ESRX',20070827135500,20070827,135500,54.83,54.84,54.82,54.84,3140);
DELETE FROM eod_data WHERE `ticker` = "ESRX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESRX',20070827,54.61,55.23,54.20,54.84,609327);
INSERT INTO intraday_data VALUES('ESV',20070827135500,20070827,135500,56.95,57.00,56.93,56.93,3800);
DELETE FROM eod_data WHERE `ticker` = "ESV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ESV',20070827,56.80,57.45,56.54,56.93,838100);
INSERT INTO intraday_data VALUES('EXPD',20070827135500,20070827,135500,45.34,45.36,45.34,45.36,1000);
DELETE FROM eod_data WHERE `ticker` = "EXPD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXPD',20070827,45.52,45.72,45.01,45.36,409189);
INSERT INTO intraday_data VALUES('EXP',20070827135500,20070827,135500,38.07,38.07,38.04,38.05,500);
DELETE FROM eod_data WHERE `ticker` = "EXP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EXP',20070827,38.58,39.06,38.03,38.05,362100);
INSERT INTO intraday_data VALUES('EZPW',20070827135500,20070827,135500,12.50,12.50,12.50,12.50,3500);
DELETE FROM eod_data WHERE `ticker` = "EZPW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('EZPW',20070827,12.65,12.65,12.48,12.50,104990);
INSERT INTO intraday_data VALUES('FDG',20070827135500,20070827,135500,32.67,32.68,32.67,32.68,300);
DELETE FROM eod_data WHERE `ticker` = "FDG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FDG',20070827,32.10,32.97,32.05,32.68,292375);
INSERT INTO intraday_data VALUES('FFIV',20070827135500,20070827,135500,37.00,37.10,37.00,37.05,6722);
DELETE FROM eod_data WHERE `ticker` = "FFIV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FFIV',20070827,37.39,37.64,36.27,37.05,614920);
INSERT INTO intraday_data VALUES('FLR',20070827135500,20070827,135500,124.83,124.89,124.81,124.89,2500);
DELETE FROM eod_data WHERE `ticker` = "FLR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FLR',20070827,124.00,125.51,123.02,124.89,625475);
INSERT INTO intraday_data VALUES('FMD',20070827135500,20070827,135500,35.25,35.26,35.21,35.21,2000);
DELETE FROM eod_data WHERE `ticker` = "FMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FMD',20070827,35.13,35.58,35.02,35.21,312800);
INSERT INTO intraday_data VALUES('FRK',20070827135500,20070827,135500,62.46,62.49,62.46,62.49,700);
DELETE FROM eod_data WHERE `ticker` = "FRK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FRK',20070827,62.83,62.99,62.00,62.49,94300);
INSERT INTO intraday_data VALUES('FRX',20070827135500,20070827,135500,37.16,37.17,37.15,37.17,6200);
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,1502000);
INSERT INTO intraday_data VALUES('FTI',20070827135500,20070827,135500,90.29,90.44,90.25,90.30,9500);
DELETE FROM eod_data WHERE `ticker` = "FTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('FTI',20070827,90.93,91.30,89.69,90.30,324800);
INSERT INTO intraday_data VALUES('GES',20070827135500,20070827,135500,49.86,49.86,49.76,49.76,1800);
DELETE FROM eod_data WHERE `ticker` = "GES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GES',20070827,50.05,50.99,49.27,49.76,433919);
INSERT INTO intraday_data VALUES('GGB',20070827135500,20070827,135500,22.98,23.01,22.98,22.98,1900);
DELETE FROM eod_data WHERE `ticker` = "GGB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GGB',20070827,23.42,23.49,22.75,22.98,877500);
INSERT INTO intraday_data VALUES('GILD',20070827135500,20070827,135500,36.84,36.86,36.84,36.84,10384);
DELETE FROM eod_data WHERE `ticker` = "GILD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GILD',20070827,37.09,37.40,36.75,36.84,2542665);
INSERT INTO intraday_data VALUES('GNA',20070827135500,20070827,135500,11.82,11.85,11.82,11.84,2400);
DELETE FROM eod_data WHERE `ticker` = "GNA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GNA',20070827,12.07,12.29,11.76,11.84,330500);
INSERT INTO intraday_data VALUES('GOOG',20070827135500,20070827,135500,515.33,515.35,514.92,515.25,11732);
DELETE FROM eod_data WHERE `ticker` = "GOOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GOOG',20070827,514.43,517.45,511.40,515.25,1633009);
INSERT INTO intraday_data VALUES('GRA',20070827135500,20070827,135500,21.90,21.90,21.86,21.86,3600);
DELETE FROM eod_data WHERE `ticker` = "GRA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRA',20070827,22.84,22.87,21.76,21.86,248100);
INSERT INTO intraday_data VALUES('GRMN',20070827135500,20070827,135500,102.07,102.11,102.03,102.04,4320);
DELETE FROM eod_data WHERE `ticker` = "GRMN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GRMN',20070827,103.73,104.00,101.40,102.04,1609369);
INSERT INTO intraday_data VALUES('GS',20070827135500,20070827,135500,177.61,177.87,177.54,177.69,25000);
DELETE FROM eod_data WHERE `ticker` = "GS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GS',20070827,179.33,180.05,177.45,177.69,4457942);
INSERT INTO intraday_data VALUES('GTI',20070827135500,20070827,135500,16.81,16.81,16.80,16.80,9400);
DELETE FROM eod_data WHERE `ticker` = "GTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('GTI',20070827,17.43,17.95,16.76,16.80,1516800);
INSERT INTO intraday_data VALUES('HAL',20070827135500,20070827,135500,33.36,33.39,33.36,33.36,25900);
DELETE FROM eod_data WHERE `ticker` = "HAL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HAL',20070827,33.56,33.70,33.23,33.36,6633283);
INSERT INTO intraday_data VALUES('HNR',20070827135500,20070827,135500,11.09,11.09,11.09,11.09,400);
DELETE FROM eod_data WHERE `ticker` = "HNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HNR',20070827,11.19,11.25,11.00,11.09,110600);
INSERT INTO intraday_data VALUES('HOC',20070827135500,20070827,135500,64.80,64.80,64.76,64.76,1100);
DELETE FROM eod_data WHERE `ticker` = "HOC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOC',20070827,64.48,65.83,64.08,64.76,467675);
INSERT INTO intraday_data VALUES('HOG',20070827135500,20070827,135500,54.03,54.07,54.03,54.03,3000);
DELETE FROM eod_data WHERE `ticker` = "HOG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOG',20070827,54.00,54.75,53.90,54.03,1065838);
INSERT INTO intraday_data VALUES('HOV',20070827135500,20070827,135500,11.32,11.32,11.31,11.31,500);
DELETE FROM eod_data WHERE `ticker` = "HOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HOV',20070827,11.98,12.00,11.30,11.31,1214144);
INSERT INTO intraday_data VALUES('HPC',20070827135500,20070827,135500,21.31,21.32,21.31,21.31,6500);
DELETE FROM eod_data WHERE `ticker` = "HPC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HPC',20070827,21.64,21.72,21.27,21.31,843987);
INSERT INTO intraday_data VALUES('HXM',20070827135500,20070827,135500,53.60,53.60,53.60,53.60,600);
DELETE FROM eod_data WHERE `ticker` = "HXM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('HXM',20070827,53.80,54.28,53.25,53.60,163600);
INSERT INTO intraday_data VALUES('IAG',20070827135500,20070827,135500,7.06,7.06,7.06,7.06,2200);
DELETE FROM eod_data WHERE `ticker` = "IAG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IAG',20070827,7.18,7.18,7.01,7.06,603250);
INSERT INTO intraday_data VALUES('IBM',20070827135500,20070827,135500,113.42,113.46,113.32,113.34,15600);
DELETE FROM eod_data WHERE `ticker` = "IBM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IBM',20070827,113.00,113.85,112.80,113.34,2536802);
INSERT INTO intraday_data VALUES('ICE',20070827135500,20070827,135500,140.36,140.82,140.36,140.65,1900);
DELETE FROM eod_data WHERE `ticker` = "ICE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ICE',20070827,142.25,143.31,139.69,140.65,581700);
INSERT INTO intraday_data VALUES('INFA',20070827135500,20070827,135500,13.70,13.70,13.70,13.70,1542);
DELETE FROM eod_data WHERE `ticker` = "INFA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFA',20070827,13.83,13.85,13.69,13.70,363766);
INSERT INTO intraday_data VALUES('INFY',20070827135500,20070827,135500,46.25,46.27,46.24,46.24,4645);
DELETE FROM eod_data WHERE `ticker` = "INFY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('INFY',20070827,47.22,47.25,46.24,46.24,808955);
INSERT INTO intraday_data VALUES('ISE',20070827135500,20070827,135500,66.04,66.04,66.03,66.03,1500);
DELETE FROM eod_data WHERE `ticker` = "ISE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ISE',20070827,66.11,66.19,65.96,66.03,158503);
INSERT INTO intraday_data VALUES('IVGN',20070827135500,20070827,135500,78.80,78.81,78.78,78.81,1400);
DELETE FROM eod_data WHERE `ticker` = "IVGN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('IVGN',20070827,78.48,79.22,77.95,78.81,215059);
INSERT INTO intraday_data VALUES('JCI',20070827135500,20070827,135500,111.71,111.72,111.71,111.72,200);
DELETE FROM eod_data WHERE `ticker` = "JCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCI',20070827,112.25,112.45,111.21,111.72,242185);
INSERT INTO intraday_data VALUES('JCP',20070827135500,20070827,135500,65.94,65.98,65.85,65.90,9000);
DELETE FROM eod_data WHERE `ticker` = "JCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JCP',20070827,65.79,66.90,65.75,65.90,1352700);
INSERT INTO intraday_data VALUES('JEC',20070827135500,20070827,135500,64.05,64.08,64.01,64.08,900);
DELETE FROM eod_data WHERE `ticker` = "JEC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JEC',20070827,64.58,64.98,63.85,64.08,320400);
INSERT INTO intraday_data VALUES('JOYG',20070827135500,20070827,135500,48.12,48.13,48.09,48.10,2100);
DELETE FROM eod_data WHERE `ticker` = "JOYG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JOYG',20070827,47.71,49.04,47.71,48.10,991475);
INSERT INTO intraday_data VALUES('JWN',20070827135500,20070827,135500,48.07,48.08,48.02,48.02,9100);
DELETE FROM eod_data WHERE `ticker` = "JWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('JWN',20070827,48.79,49.35,47.94,48.02,2048400);
INSERT INTO intraday_data VALUES('KBH',20070827135500,20070827,135500,30.46,30.47,30.41,30.43,9000);
DELETE FROM eod_data WHERE `ticker` = "KBH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KBH',20070827,31.93,32.20,30.41,30.43,1562200);
INSERT INTO intraday_data VALUES('KCI',20070827135500,20070827,135500,61.82,61.82,61.80,61.80,1100);
DELETE FROM eod_data WHERE `ticker` = "KCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KCI',20070827,62.74,63.41,61.50,61.80,411300);
INSERT INTO intraday_data VALUES('KEP',20070827135500,20070827,135500,22.09,22.09,22.09,22.09,100);
DELETE FROM eod_data WHERE `ticker` = "KEP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KEP',20070827,22.09,22.20,21.86,22.09,238900);
INSERT INTO intraday_data VALUES('KG',20070827135500,20070827,135500,15.70,15.70,15.68,15.68,1300);
DELETE FROM eod_data WHERE `ticker` = "KG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KG',20070827,15.70,15.78,15.52,15.68,754000);
INSERT INTO intraday_data VALUES('KSS',20070827135500,20070827,135500,57.26,57.27,57.25,57.26,10400);
DELETE FROM eod_data WHERE `ticker` = "KSS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('KSS',20070827,58.58,59.32,57.23,57.26,3078800);
INSERT INTO intraday_data VALUES('LEH',20070827135500,20070827,135500,58.07,58.19,58.06,58.11,22918);
DELETE FROM eod_data WHERE `ticker` = "LEH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LEH',20070827,59.60,59.75,58.06,58.11,4919736);
INSERT INTO intraday_data VALUES('LMT',20070827135500,20070827,135500,101.70,101.77,101.69,101.71,6600);
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,1226290);
INSERT INTO intraday_data VALUES('LRCX',20070827135500,20070827,135500,53.48,53.49,53.47,53.47,4589);
DELETE FROM eod_data WHERE `ticker` = "LRCX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LRCX',20070827,54.49,54.49,52.87,53.47,1268749);
INSERT INTO intraday_data VALUES('LVS',20070827135500,20070827,135500,98.40,98.44,98.40,98.40,600);
DELETE FROM eod_data WHERE `ticker` = "LVS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('LVS',20070827,101.36,101.65,97.25,98.40,1854925);
INSERT INTO intraday_data VALUES('MBT',20070827135500,20070827,135500,62.71,62.74,62.70,62.71,900);
DELETE FROM eod_data WHERE `ticker` = "MBT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MBT',20070827,62.11,62.75,61.43,62.71,375000);
INSERT INTO intraday_data VALUES('MCD',20070827135500,20070827,135500,49.49,49.50,49.47,49.48,12900);
DELETE FROM eod_data WHERE `ticker` = "MCD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MCD',20070827,50.00,50.56,49.40,49.48,2649812);
INSERT INTO intraday_data VALUES('MDC',20070827135500,20070827,135500,43.77,43.80,43.71,43.75,2200);
DELETE FROM eod_data WHERE `ticker` = "MDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MDC',20070827,45.08,45.68,43.71,43.75,383600);
INSERT INTO intraday_data VALUES('MESA',20070827135500,20070827,135500,6.00,6.00,6.00,6.00,600);
DELETE FROM eod_data WHERE `ticker` = "MESA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MESA',20070827,5.86,6.06,5.81,6.00,163030);
INSERT INTO intraday_data VALUES('MGM',20070827135500,20070827,135500,82.24,82.25,82.12,82.20,5700);
DELETE FROM eod_data WHERE `ticker` = "MGM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MGM',20070827,82.88,83.32,81.75,82.20,697900);
INSERT INTO intraday_data VALUES('MICC',20070827135500,20070827,135500,82.75,82.75,82.75,82.75,200);
DELETE FROM eod_data WHERE `ticker` = "MICC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MICC',20070827,82.93,83.13,81.31,82.75,222808);
INSERT INTO intraday_data VALUES('MLM',20070827135500,20070827,135500,131.59,131.59,131.45,131.45,500);
DELETE FROM eod_data WHERE `ticker` = "MLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MLM',20070827,134.34,135.00,131.11,131.45,250900);
INSERT INTO intraday_data VALUES('MNT',20070827135500,20070827,135500,43.81,43.83,43.76,43.76,1200);
DELETE FROM eod_data WHERE `ticker` = "MNT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MNT',20070827,44.09,44.26,43.63,43.76,333359);
INSERT INTO intraday_data VALUES('MOS',20070827135500,20070827,135500,40.47,40.50,40.47,40.48,700);
DELETE FROM eod_data WHERE `ticker` = "MOS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MOS',20070827,40.98,41.22,39.93,40.48,1126100);
INSERT INTO intraday_data VALUES('MRVL',20070827135500,20070827,135500,15.51,15.53,15.50,15.52,33999);
DELETE FROM eod_data WHERE `ticker` = "MRVL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MRVL',20070827,15.74,15.76,15.27,15.52,13357522);
INSERT INTO intraday_data VALUES('MSFT',20070827135500,20070827,135500,28.52,28.54,28.52,28.53,115173);
DELETE FROM eod_data WHERE `ticker` = "MSFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MSFT',20070827,28.62,28.77,28.40,28.53,15431031);
INSERT INTO intraday_data VALUES('MTH',20070827135500,20070827,135500,17.51,17.55,17.50,17.55,3600);
DELETE FROM eod_data WHERE `ticker` = "MTH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTH',20070827,18.99,19.20,17.50,17.55,467991);
INSERT INTO intraday_data VALUES('MTW',20070827135500,20070827,135500,76.52,76.53,76.50,76.50,1500);
DELETE FROM eod_data WHERE `ticker` = "MTW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MTW',20070827,77.50,78.14,75.52,76.50,409600);
INSERT INTO intraday_data VALUES('MT',20070827135500,20070827,135500,63.79,63.82,63.77,63.80,1100);
DELETE FROM eod_data WHERE `ticker` = "MT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('MT',20070827,64.38,64.49,63.50,63.80,1192060);
INSERT INTO intraday_data VALUES('NEM',20070827135500,20070827,135500,40.33,40.36,40.33,40.35,6900);
DELETE FROM eod_data WHERE `ticker` = "NEM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEM',20070827,41.00,41.24,40.30,40.35,2636400);
INSERT INTO intraday_data VALUES('NEU',20070827135500,20070827,135500,47.55,47.55,47.55,47.55,400);
DELETE FROM eod_data WHERE `ticker` = "NEU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NEU',20070827,48.09,48.10,46.84,47.55,101900);
INSERT INTO intraday_data VALUES('NFLX',20070827135500,20070827,135500,17.31,17.31,17.31,17.31,100);
DELETE FROM eod_data WHERE `ticker` = "NFLX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFLX',20070827,17.74,17.85,17.31,17.31,262217);
INSERT INTO intraday_data VALUES('NFX',20070827135500,20070827,135500,43.52,43.52,43.51,43.51,300);
DELETE FROM eod_data WHERE `ticker` = "NFX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NFX',20070827,44.59,44.59,43.28,43.51,702928);
INSERT INTO intraday_data VALUES('NOV',20070827135500,20070827,135500,119.16,119.21,119.07,119.12,7800);
DELETE FROM eod_data WHERE `ticker` = "NOV" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NOV',20070827,119.95,120.76,118.10,119.12,1312421);
INSERT INTO intraday_data VALUES('NSTC',20070827135500,20070827,135500,10.88,10.88,10.88,10.88,400);
DELETE FROM eod_data WHERE `ticker` = "NSTC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NSTC',20070827,10.99,11.11,10.88,10.88,60084);
INSERT INTO intraday_data VALUES('NTES',20070827135500,20070827,135500,16.16,16.16,16.15,16.15,1100);
DELETE FROM eod_data WHERE `ticker` = "NTES" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NTES',20070827,16.31,16.79,16.15,16.15,557004);
INSERT INTO intraday_data VALUES('NUE',20070827135500,20070827,135500,53.67,53.76,53.64,53.73,15900);
DELETE FROM eod_data WHERE `ticker` = "NUE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NUE',20070827,54.58,55.50,53.42,53.73,3140466);
INSERT INTO intraday_data VALUES('NVDA',20070827135500,20070827,135500,49.46,49.46,49.40,49.40,30990);
DELETE FROM eod_data WHERE `ticker` = "NVDA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NVDA',20070827,48.10,49.59,47.97,49.40,5891030);
INSERT INTO intraday_data VALUES('NWRE',20070827135500,20070827,135500,15.98,15.98,15.98,15.98,200);
DELETE FROM eod_data WHERE `ticker` = "NWRE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NWRE',20070827,15.83,15.99,15.83,15.98,145996);
INSERT INTO intraday_data VALUES('NYX',20070827135500,20070827,135500,73.80,73.83,73.78,73.81,4400);
DELETE FROM eod_data WHERE `ticker` = "NYX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('NYX',20070827,74.72,74.76,73.59,73.81,1103331);
INSERT INTO intraday_data VALUES('OCR',20070827135500,20070827,135500,32.93,32.93,32.93,32.93,100);
DELETE FROM eod_data WHERE `ticker` = "OCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OCR',20070827,33.01,33.02,32.66,32.93,545000);
INSERT INTO intraday_data VALUES('OGE',20070827135500,20070827,135500,33.02,33.02,33.02,33.02,100);
DELETE FROM eod_data WHERE `ticker` = "OGE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OGE',20070827,33.48,33.48,32.87,33.02,233100);
INSERT INTO intraday_data VALUES('ORCL',20070827135500,20070827,135500,19.91,19.92,19.91,19.92,51813);
DELETE FROM eod_data WHERE `ticker` = "ORCL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('ORCL',20070827,19.95,19.97,19.75,19.92,11379265);
INSERT INTO intraday_data VALUES('OXY',20070827135500,20070827,135500,56.30,56.35,56.29,56.29,7200);
DELETE FROM eod_data WHERE `ticker` = "OXY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('OXY',20070827,56.45,56.50,56.00,56.29,1478800);
INSERT INTO intraday_data VALUES('PBR',20070827135500,20070827,135500,59.11,59.13,59.10,59.10,4700);
DELETE FROM eod_data WHERE `ticker` = "PBR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PBR',20070827,59.29,59.43,58.47,59.10,1835659);
INSERT INTO intraday_data VALUES('PCLN',20070827135500,20070827,135500,80.69,80.77,80.68,80.76,1327);
DELETE FROM eod_data WHERE `ticker` = "PCLN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCLN',20070827,81.49,81.99,80.41,80.76,319468);
INSERT INTO intraday_data VALUES('PCP',20070827135500,20070827,135500,138.38,138.44,138.36,138.36,1600);
DELETE FROM eod_data WHERE `ticker` = "PCP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCP',20070827,137.46,138.88,136.13,138.36,581900);
INSERT INTO intraday_data VALUES('PCR',20070827135500,20070827,135500,55.46,55.53,55.46,55.53,1400);
DELETE FROM eod_data WHERE `ticker` = "PCR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCR',20070827,56.99,57.96,54.84,55.53,273500);
INSERT INTO intraday_data VALUES('PCU',20070827135500,20070827,135500,102.89,102.89,102.70,102.75,5000);
DELETE FROM eod_data WHERE `ticker` = "PCU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PCU',20070827,103.00,103.99,101.55,102.75,1260773);
INSERT INTO intraday_data VALUES('PMTI',20070827135500,20070827,135500,30.45,30.46,30.45,30.46,1200);
DELETE FROM eod_data WHERE `ticker` = "PMTI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PMTI',20070827,30.67,30.72,30.25,30.46,86605);
INSERT INTO intraday_data VALUES('PNK',20070827135500,20070827,135500,27.16,27.16,27.16,27.16,100);
DELETE FROM eod_data WHERE `ticker` = "PNK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PNK',20070827,27.21,27.35,26.85,27.16,159200);
INSERT INTO intraday_data VALUES('POT',20070827135500,20070827,135500,85.29,85.35,85.27,85.29,9400);
DELETE FROM eod_data WHERE `ticker` = "POT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('POT',20070827,87.13,87.72,85.25,85.29,1078350);
INSERT INTO intraday_data VALUES('PRFT',20070827135500,20070827,135500,23.28,23.28,23.27,23.28,500);
DELETE FROM eod_data WHERE `ticker` = "PRFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('PRFT',20070827,23.04,23.45,22.95,23.28,145129);
INSERT INTO intraday_data VALUES('QDEL',20070827135500,20070827,135500,17.16,17.16,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,176219);
INSERT INTO intraday_data VALUES('QQQQ',20070827135500,20070827,135500,47.98,48.01,47.98,47.99,87546);
DELETE FROM eod_data WHERE `ticker` = "QQQQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('QQQQ',20070827,48.06,48.20,47.84,47.99,43753396);
INSERT INTO intraday_data VALUES('QSII',20070827135500,20070827,135500,37.86,37.87,37.86,37.87,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.87,86894);
INSERT INTO intraday_data VALUES('RAI',20070827135500,20070827,135500,65.22,65.23,65.18,65.18,2500);
DELETE FROM eod_data WHERE `ticker` = "RAI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RAI',20070827,65.60,65.99,65.10,65.18,487363);
INSERT INTO intraday_data VALUES('REXI',20070827135500,20070827,135500,15.80,15.80,15.80,15.80,200);
DELETE FROM eod_data WHERE `ticker` = "REXI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('REXI',20070827,16.24,16.37,15.67,15.80,82964);
INSERT INTO intraday_data VALUES('RIG',20070827135500,20070827,135500,102.37,102.46,102.34,102.34,6100);
DELETE FROM eod_data WHERE `ticker` = "RIG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIG',20070827,103.45,103.80,101.54,102.34,2405733);
INSERT INTO intraday_data VALUES('RIMM',20070827135500,20070827,135500,81.04,81.12,81.04,81.10,29223);
DELETE FROM eod_data WHERE `ticker` = "RIMM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIMM',20070827,81.75,81.99,80.57,81.10,4138006);
INSERT INTO intraday_data VALUES('RIO',20070827135500,20070827,135500,47.86,47.86,47.76,47.78,30300);
DELETE FROM eod_data WHERE `ticker` = "RIO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RIO',20070827,47.50,47.97,47.09,47.78,6938083);
INSERT INTO intraday_data VALUES('RL',20070827135500,20070827,135500,76.56,76.60,76.55,76.56,2300);
DELETE FROM eod_data WHERE `ticker` = "RL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RL',20070827,77.87,78.52,76.52,76.56,617100);
INSERT INTO intraday_data VALUES('RMD',20070827135500,20070827,135500,41.50,41.50,41.50,41.50,200);
DELETE FROM eod_data WHERE `ticker` = "RMD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RMD',20070827,41.84,42.02,41.33,41.50,264405);
INSERT INTO intraday_data VALUES('RTP',20070827135500,20070827,135500,272.78,272.78,272.78,272.78,100);
DELETE FROM eod_data WHERE `ticker` = "RTP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RTP',20070827,274.00,276.85,270.07,272.78,180400);
INSERT INTO intraday_data VALUES('RYL',20070827135500,20070827,135500,30.03,30.03,30.02,30.02,700);
DELETE FROM eod_data WHERE `ticker` = "RYL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('RYL',20070827,31.44,31.83,30.01,30.02,871181);
INSERT INTO intraday_data VALUES('SBGI',20070827135500,20070827,135500,12.37,12.38,12.37,12.37,800);
DELETE FROM eod_data WHERE `ticker` = "SBGI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBGI',20070827,12.79,12.79,12.37,12.37,557158);
INSERT INTO intraday_data VALUES('SBUX',20070827135500,20070827,135500,27.45,27.46,27.43,27.44,31102);
DELETE FROM eod_data WHERE `ticker` = "SBUX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SBUX',20070827,27.51,27.61,27.38,27.44,2533560);
INSERT INTO intraday_data VALUES('SCI',20070827135500,20070827,135500,12.06,12.07,12.05,12.07,1500);
DELETE FROM eod_data WHERE `ticker` = "SCI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCI',20070827,12.26,12.29,11.96,12.07,703600);
INSERT INTO intraday_data VALUES('SCUR',20070827135500,20070827,135500,8.37,8.37,8.37,8.37,300);
DELETE FROM eod_data WHERE `ticker` = "SCUR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SCUR',20070827,8.32,8.49,8.23,8.37,337465);
INSERT INTO intraday_data VALUES('SEIC',20070827135500,20070827,135500,25.74,25.74,25.71,25.71,800);
DELETE FROM eod_data WHERE `ticker` = "SEIC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SEIC',20070827,25.88,26.02,25.65,25.71,208862);
INSERT INTO intraday_data VALUES('SID',20070827135500,20070827,135500,53.86,53.87,53.79,53.81,4200);
DELETE FROM eod_data WHERE `ticker` = "SID" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SID',20070827,54.06,54.19,52.67,53.81,672000);
INSERT INTO intraday_data VALUES('SII',20070827135500,20070827,135500,62.58,62.63,62.57,62.57,2200);
DELETE FROM eod_data WHERE `ticker` = "SII" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SII',20070827,62.98,63.17,62.02,62.57,791100);
INSERT INTO intraday_data VALUES('SIMG',20070827135500,20070827,135500,5.84,5.85,5.84,5.85,2400);
DELETE FROM eod_data WHERE `ticker` = "SIMG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SIMG',20070827,6.03,6.03,5.80,5.85,442798);
INSERT INTO intraday_data VALUES('SKX',20070827135500,20070827,135500,19.90,19.93,19.89,19.89,2600);
DELETE FROM eod_data WHERE `ticker` = "SKX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SKX',20070827,20.10,20.10,19.81,19.89,233100);
INSERT INTO intraday_data VALUES('SLB',20070827135500,20070827,135500,92.65,92.75,92.62,92.63,6500);
DELETE FROM eod_data WHERE `ticker` = "SLB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SLB',20070827,93.92,94.00,92.03,92.63,2693700);
INSERT INTO intraday_data VALUES('SNDK',20070827135500,20070827,135500,52.08,52.09,52.06,52.08,29621);
DELETE FROM eod_data WHERE `ticker` = "SNDK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNDK',20070827,53.50,53.50,52.05,52.08,5321346);
INSERT INTO intraday_data VALUES('SNE',20070827135500,20070827,135500,46.30,46.33,46.30,46.33,300);
DELETE FROM eod_data WHERE `ticker` = "SNE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SNE',20070827,46.55,46.60,46.28,46.33,377040);
INSERT INTO intraday_data VALUES('SPF',20070827135500,20070827,135500,9.99,9.99,9.99,9.99,800);
DELETE FROM eod_data WHERE `ticker` = "SPF" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPF',20070827,9.81,10.20,9.62,9.99,1311200);
INSERT INTO intraday_data VALUES('SPG',20070827135500,20070827,135500,92.19,92.20,92.14,92.15,5800);
DELETE FROM eod_data WHERE `ticker` = "SPG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPG',20070827,94.07,94.34,92.03,92.15,482400);
INSERT INTO intraday_data VALUES('SPN',20070827135500,20070827,135500,38.08,38.08,38.06,38.06,500);
DELETE FROM eod_data WHERE `ticker` = "SPN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPN',20070827,38.63,38.73,38.01,38.06,279800);
INSERT INTO intraday_data VALUES('SPWR',20070827135500,20070827,135500,62.25,62.25,62.25,62.25,300);
DELETE FROM eod_data WHERE `ticker` = "SPWR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPWR',20070827,63.21,63.75,62.05,62.25,561476);
INSERT INTO intraday_data VALUES('SPY',20070827135500,20070827,135500,147.11,147.19,147.10,147.10,370800);
DELETE FROM eod_data WHERE `ticker` = "SPY" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SPY',20070827,147.87,147.93,146.97,147.10,60062825);
INSERT INTO intraday_data VALUES('STEC',20070827135500,20070827,135500,7.52,7.52,7.52,7.52,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.52,93578);
INSERT INTO intraday_data VALUES('STLD',20070827135500,20070827,135500,43.53,43.53,43.50,43.51,4600);
DELETE FROM eod_data WHERE `ticker` = "STLD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STLD',20070827,44.17,44.21,43.00,43.51,715061);
INSERT INTO intraday_data VALUES('STR',20070827135500,20070827,135500,49.31,49.31,49.31,49.31,600);
DELETE FROM eod_data WHERE `ticker` = "STR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('STR',20070827,50.40,50.42,49.29,49.31,607100);
INSERT INTO intraday_data VALUES('SWKS',20070827135500,20070827,135500,7.68,7.68,7.67,7.68,1840);
DELETE FROM eod_data WHERE `ticker` = "SWKS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWKS',20070827,7.88,7.95,7.67,7.68,1037445);
INSERT INTO intraday_data VALUES('SWN',20070827135500,20070827,135500,37.30,37.35,37.30,37.34,6900);
DELETE FROM eod_data WHERE `ticker` = "SWN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SWN',20070827,38.13,38.15,37.20,37.34,1015900);
INSERT INTO intraday_data VALUES('SYKE',20070827135500,20070827,135500,16.59,16.59,16.59,16.59,393);
DELETE FROM eod_data WHERE `ticker` = "SYKE" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYKE',20070827,16.96,16.96,16.55,16.59,51707);
INSERT INTO intraday_data VALUES('SYK',20070827135500,20070827,135500,67.11,67.13,67.09,67.13,1100);
DELETE FROM eod_data WHERE `ticker` = "SYK" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('SYK',20070827,67.15,67.85,67.09,67.13,392832);
INSERT INTO intraday_data VALUES('TDW',20070827135500,20070827,135500,64.99,65.00,64.95,64.95,1400);
DELETE FROM eod_data WHERE `ticker` = "TDW" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TDW',20070827,64.87,65.27,64.45,64.95,566015);
INSERT INTO intraday_data VALUES('TEX',20070827135500,20070827,135500,78.20,78.20,78.14,78.15,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.15,665000);
INSERT INTO intraday_data VALUES('THOR',20070827135500,20070827,135500,20.75,20.75,20.74,20.75,4634);
DELETE FROM eod_data WHERE `ticker` = "THOR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('THOR',20070827,20.87,20.94,20.61,20.75,104207);
INSERT INTO intraday_data VALUES('TLM',20070827135500,20070827,135500,16.98,16.99,16.97,16.97,3800);
DELETE FROM eod_data WHERE `ticker` = "TLM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TLM',20070827,17.29,17.29,16.95,16.97,1194482);
INSERT INTO intraday_data VALUES('TNB',20070827135500,20070827,135500,55.37,55.38,55.37,55.37,600);
DELETE FROM eod_data WHERE `ticker` = "TNB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TNB',20070827,55.78,55.78,54.92,55.37,294400);
INSERT INTO intraday_data VALUES('TOL',20070827135500,20070827,135500,22.09,22.10,22.06,22.06,20200);
DELETE FROM eod_data WHERE `ticker` = "TOL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TOL',20070827,22.94,23.19,22.06,22.06,2819366);
INSERT INTO intraday_data VALUES('TOPT',20070827135500,20070827,135500,5.78,5.78,5.78,5.78,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.78,198199);
INSERT INTO intraday_data VALUES('TRAD',20070827135500,20070827,135500,10.87,10.88,10.86,10.86,5852);
DELETE FROM eod_data WHERE `ticker` = "TRAD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRAD',20070827,10.88,10.92,10.70,10.86,154651);
INSERT INTO intraday_data VALUES('TRMB',20070827135500,20070827,135500,36.48,36.49,36.48,36.49,1600);
DELETE FROM eod_data WHERE `ticker` = "TRMB" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TRMB',20070827,36.74,36.84,36.30,36.49,387071);
INSERT INTO intraday_data VALUES('TSN',20070827135500,20070827,135500,21.23,21.24,21.22,21.23,6300);
DELETE FROM eod_data WHERE `ticker` = "TSN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSN',20070827,21.74,21.74,21.21,21.23,796905);
INSERT INTO intraday_data VALUES('TSO',20070827135500,20070827,135500,49.22,49.22,49.18,49.18,2800);
DELETE FROM eod_data WHERE `ticker` = "TSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TSO',20070827,50.86,50.86,49.15,49.18,1570000);
INSERT INTO intraday_data VALUES('TS',20070827135500,20070827,135500,46.66,46.67,46.66,46.67,1000);
DELETE FROM eod_data WHERE `ticker` = "TS" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TS',20070827,46.95,47.00,46.48,46.67,1592200);
INSERT INTO intraday_data VALUES('TXU',20070827135500,20070827,135500,65.96,65.96,65.91,65.96,8000);
DELETE FROM eod_data WHERE `ticker` = "TXU" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('TXU',20070827,66.25,66.38,65.73,65.96,3737700);
INSERT INTO intraday_data VALUES('UA',20070827135500,20070827,135500,63.85,63.86,63.80,63.86,2400);
DELETE FROM eod_data WHERE `ticker` = "UA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UA',20070827,65.00,65.00,63.50,63.86,529500);
INSERT INTO intraday_data VALUES('UFPI',20070827135500,20070827,135500,38.20,38.20,38.20,38.20,200);
DELETE FROM eod_data WHERE `ticker` = "UFPI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UFPI',20070827,38.17,38.87,37.74,38.20,48478);
INSERT INTO intraday_data VALUES('UNH',20070827135500,20070827,135500,49.40,49.43,49.39,49.42,9700);
DELETE FROM eod_data WHERE `ticker` = "UNH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UNH',20070827,49.42,49.94,49.23,49.42,2552380);
INSERT INTO intraday_data VALUES('UPL',20070827135500,20070827,135500,54.49,54.49,54.38,54.38,3700);
DELETE FROM eod_data WHERE `ticker` = "UPL" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('UPL',20070827,55.55,55.55,54.25,54.38,471200);
INSERT INTO intraday_data VALUES('URBN',20070827135500,20070827,135500,22.60,22.63,22.60,22.63,2000);
DELETE FROM eod_data WHERE `ticker` = "URBN" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('URBN',20070827,22.77,23.18,22.49,22.63,1375164);
INSERT INTO intraday_data VALUES('USG',20070827135500,20070827,135500,37.67,37.67,37.67,37.67,100);
DELETE FROM eod_data WHERE `ticker` = "USG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('USG',20070827,38.45,38.86,37.66,37.67,359400);
INSERT INTO intraday_data VALUES('VIP',20070827135500,20070827,135500,22.70,22.72,22.70,22.71,4300);
DELETE FROM eod_data WHERE `ticker` = "VIP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIP',20070827,22.40,22.80,22.08,22.71,1056430);
INSERT INTO intraday_data VALUES('VIVO',20070827135500,20070827,135500,25.20,25.20,25.20,25.20,800);
DELETE FROM eod_data WHERE `ticker` = "VIVO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VIVO',20070827,25.53,25.54,25.03,25.20,54390);
INSERT INTO intraday_data VALUES('VLO',20070827135500,20070827,135500,67.27,67.30,67.27,67.27,24600);
DELETE FROM eod_data WHERE `ticker` = "VLO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VLO',20070827,67.07,68.13,67.07,67.27,3143794);
INSERT INTO intraday_data VALUES('VSEA',20070827135500,20070827,135500,56.21,56.33,56.21,56.31,1300);
DELETE FROM eod_data WHERE `ticker` = "VSEA" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('VSEA',20070827,56.46,57.41,54.53,56.31,1802024);
INSERT INTO intraday_data VALUES('WBSN',20070827135500,20070827,135500,20.50,20.50,20.50,20.50,600);
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,82409);
INSERT INTO intraday_data VALUES('WCC',20070827135500,20070827,135500,47.81,47.81,47.80,47.80,500);
DELETE FROM eod_data WHERE `ticker` = "WCC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WCC',20070827,48.45,48.55,47.80,47.80,240794);
INSERT INTO intraday_data VALUES('WDC',20070827135500,20070827,135500,21.86,21.86,21.85,21.85,3300);
DELETE FROM eod_data WHERE `ticker` = "WDC" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WDC',20070827,22.00,22.26,21.77,21.85,1233200);
INSERT INTO intraday_data VALUES('WFMI',20070827135500,20070827,135500,45.75,45.76,45.75,45.75,4900);
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,2082785);
INSERT INTO intraday_data VALUES('WFR',20070827135500,20070827,135500,58.34,58.38,58.25,58.26,14100);
DELETE FROM eod_data WHERE `ticker` = "WFR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFR',20070827,59.05,59.34,58.25,58.26,749300);
INSERT INTO intraday_data VALUES('WFT',20070827135500,20070827,135500,56.21,56.26,56.19,56.21,5000);
DELETE FROM eod_data WHERE `ticker` = "WFT" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WFT',20070827,57.13,57.32,55.45,56.21,1523100);
INSERT INTO intraday_data VALUES('WHQ',20070827135500,20070827,135500,61.47,61.50,61.47,61.50,900);
DELETE FROM eod_data WHERE `ticker` = "WHQ" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WHQ',20070827,61.80,62.05,60.52,61.50,126000);
INSERT INTO intraday_data VALUES('WLP',20070827135500,20070827,135500,78.43,78.48,78.43,78.46,4400);
DELETE FROM eod_data WHERE `ticker` = "WLP" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WLP',20070827,78.24,78.63,77.89,78.46,1350900);
INSERT INTO intraday_data VALUES('WNR',20070827135500,20070827,135500,52.01,52.03,51.85,51.85,3200);
DELETE FROM eod_data WHERE `ticker` = "WNR" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WNR',20070827,52.90,53.30,51.75,51.85,503600);
INSERT INTO intraday_data VALUES('WSO',20070827135500,20070827,135500,47.99,47.99,47.91,47.96,800);
DELETE FROM eod_data WHERE `ticker` = "WSO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('WSO',20070827,48.88,49.10,47.91,47.96,72800);
INSERT INTO intraday_data VALUES('XING',20070827135500,20070827,135500,9.11,9.12,9.11,9.12,600);
DELETE FROM eod_data WHERE `ticker` = "XING" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('XING',20070827,8.98,9.38,8.83,9.12,289847);
INSERT INTO intraday_data VALUES('X',20070827135500,20070827,135500,93.19,93.21,93.10,93.10,6800);
DELETE FROM eod_data WHERE `ticker` = "X" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('X',20070827,93.60,95.58,92.70,93.10,2050104);
INSERT INTO intraday_data VALUES('YHOO',20070827135500,20070827,135500,23.19,23.23,23.19,23.19,29100);
DELETE FROM eod_data WHERE `ticker` = "YHOO" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('YHOO',20070827,23.59,23.76,23.17,23.19,8893862);