#Get only one record per day
SELECT fidId, sp500, fidCurDate
FROM fidelity AS a
WHERE fidCurDate = (
    SELECT MAX(fidCurDate)
    FROM fidelity AS b
    WHERE a.fidId = b.fidId
      AND a.sp500 = b.sp500
)
### NOT WORKING #####
#Get only one record per day
SELECT fidId, sp500, fidCurDate
FROM fidelity AS a
WHERE fidCurDate = (
    SELECT MAX(fidCurDate), fidId
    FROM fidelity AS b
    WHERE a.fidId = b.fidId order by fidCurDate DESC
       limit 1
) order by fidCurDate DESC
### WORKS ****
 SELECT t1.fidId, fidCurDate, fidTot FROM fidelity t1
  JOIN (SELECT fidId, MAX(fidCurDate)  FROM fidelity GROUP BY date(fidCurDate)order by fidCurDate Desc ) t2
    ON t1.fidId = t2.FidId