update the query
Add charts to visualize the 30 previous data of each sensors.