sqlite3 -header -csv $HOME/.homeassistant/home-assistant_v2.db "SELECT last_changed, state FROM states WHERE entity_id = 'ENTITY_NAME' AND last_changed BETWEEN '2020-03-08 00:00:00:000000' AND '2020-04-08 00:00:00:000000';" > /tmp/data.csv

Изменить пасту