added hourly data query for json result