Query Run
select SUBSTRING(rc_timestamp,1,10) as hour, count(*),... 8 years ago