Marc,

select entity as node_name,bytes as Bytes_transfered,successful from summary
where start_time>=timestamp(current_date -1 day,'20:00:00') and
end_time<=timestamp(current_date,'05:00:00')

I use "days(current_date)-days(end_time)<=1" to report previous 24 hours
activity counted by end_time.

Phillip