How to query the last value of a series and group by 1 day at midnight of everyday

1

Hi All,

Can anyone please help me to query last value at midnight for 7days?

Thanks in advance