Date conversion and integer truncation during import
I suggest that this is a bit cleaner than Vérace's answer:

LOAD DATA
    INFILE 'apa.txt'
    INTO TABLE Test_Stock_Daily
    FIELDS TERMINATED BY ','
    (symbol, @date, open, high, low, close, volume)
    SET date = STR_TO_DATE(@date, '%m/%d/%y'); 


(And yes, date is a poor choice for a column name.)