SELECT symbol, MAX( date_effective ) as date_effective, current_month

FROM   `fund_cap_shortinterest`

GROUP BY symbol