count distinct events per day
You could run something like this:

select Cast([timestamp] as date) "date", COUNT(distinct event)"nb events"
from yourtable
group by Cast([timestamp] as date) 


Also, it is not a best pratice to use reserved work for column name (like user, timestamp, etc).