INSERT INTO intraday_data VALUES('$DJUSOG',20070827124000,20070827,124000,564.99,564.99,564.99,564.99,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.99,0);
INSERT INTO intraday_data VALUES('AMTD',20070827124000,20070827,124000,17.61,17.62,17.61,17.62,300);
DELETE FROM eod_data WHERE `ticker` = "AMTD" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMTD',20070827,17.64,17.65,17.40,17.62,1063186);
INSERT INTO intraday_data VALUES('AMX',20070827124000,20070827,124000,60.56,60.57,60.54,60.57,3900);
DELETE FROM eod_data WHERE `ticker` = "AMX" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('AMX',20070827,60.44,60.74,60.06,60.57,1502200);
INSERT INTO intraday_data VALUES('BG',20070827124000,20070827,124000,88.33,88.37,88.33,88.37,600);
DELETE FROM eod_data WHERE `ticker` = "BG" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BG',20070827,87.35,88.40,87.03,88.37,227700);
INSERT INTO intraday_data VALUES('BNI',20070827124000,20070827,124000,80.73,80.74,80.65,80.70,9100);
DELETE FROM eod_data WHERE `ticker` = "BNI" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BNI',20070827,80.67,80.83,79.68,80.70,4299432);
INSERT INTO intraday_data VALUES('BRCD',20070827124000,20070827,124000,7.05,7.05,7.04,7.04,17500);
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,3924894);
INSERT INTO intraday_data VALUES('BZH',20070827124000,20070827,124000,9.79,9.79,9.79,9.79,100);
DELETE FROM eod_data WHERE `ticker` = "BZH" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('BZH',20070827,10.15,10.40,9.62,9.79,1255100);
INSERT INTO intraday_data VALUES('CAM',20070827124000,20070827,124000,77.85,77.89,77.85,77.89,1300);
DELETE FROM eod_data WHERE `ticker` = "CAM" AND `_date` = "20070827";
INSERT INTO eod_data VALUES('CAM',20070827,78.07,78.26,76.74,77.89,444200);