SELECT SUM(money_volume) AS money_volume_sum  
FROM (
    SELECT symbols.exchange, stocks.close * stocks.volume AS money_volume  
    FROM symbols  
    JOIN stocks ON symbols.id = stocks.id  
    WHERE stocks.t = '20160323'  
    ORDER BY money_volume DESC  
) t
GROUP BY exchange