Mysql - Daily Sum by currency
... adding to my recent comment ... 

http://sqlfiddle.com/#!9/8e8f57/4

select DATE(added), SUM(amount) ,currency 
from transactions 
where  DATE(added)  &gt; subdate(CURDATE(),10) 
  AND status = 'APPROVED' 
GROUP BY  currency,DATE(added)
ORDER BY DATE(added) desc; 


delivers daily amounts separated by currency as you wanted