using select to sum date in intervall

[prometheus__0]

hiho@ll

i have a table which has a column, where i insert unix timestamps and other columns with numbers
now i need to select all elements of the table grouped by an time intervall and some columns sum

for example i have my date column and a column with access counts
i want to select all access counts per day
which means in my result i have sumed entrys with the access counts and every row equals a day

the sum interval could also be a hour or month

is this possible? and if yes how?
don't really know how to do this

thx@ll