timescaleDB get time period

query.sql

 SELECT 
  time_bucket('1 day', timestamp) AS period, 
  summit, 
  direction, 
  avg(temperature), 
  max(temperature), 
  min(temperature) 
 FROM 
  temperature_hyper 
 WHERE
  summit='DSH' 
 group by period,summit,direction 
 order by summit,period