I would like to create a line chart on my Ulanzi Pixel Clock that is currently running AWTRIX 3. I can get stock prices in HA and save their historical data, but AWTRIX requires that I send it 11 discrete values to draw a line chart. Is there a way to pull historical data from a sensor from specific times in the past? I would like to plot the hourly price data for the previous 11 hours, but not sure how to grab this from a sensor.
For anyone curious, I ended up using the SQL Integration, specifically this query since I have the sensor added to the Recorder and can pull directly from the HA database.