Query for displaying certain part of a day

Grafana Time Series Panel
1

I have two panels showing me the total used kw/h over a day for each hour and also over the current month for each day.
Now I like to show also how much energy is used during low and high price.
So low price is during 22:00 and 06:00 and high price during 06:00 to 22:00.

With this Query I can display how much energy is used during a single day and with the value “now/M” in the relative time part it shows me this over the current month for each day in the month. (the shellyserverpm_power_0371 reports every 30 sec the current consumption)

SELECT
  $__timeGroupAlias(time,1d),
  sum(value)/120/1000 AS "server power consumption"
FROM shellyserverpm_power_0371
WHERE
  $__timeFilter(time)
GROUP BY 1
ORDER BY $__timeGroup(time,1d)

Now I like to show for each day how much energy is used during low and how much during high price.
Can someone give me a hint how to deal with this?