select   cast(from_unixtime(created)as date) as date_creation,
         count(created)
from     datalake.test
group by date_creation