How to export the all available statistics for a energy sensor into a usable format | Home Assistant | Page 1

I have the following problem:
I have been tracking my solar power generation and grid in home assistant for a over year.
Now I want to export the data in some usable format, so i can do some data analysis.
I tried using nodered to export the data to a csv, but it is limited to 10 Days.
I was unable to find any documentation on how to access the long-term-statistics in an automated way.
AppDaemon has (seemingly) no Way of accessing the LTS via the API, and I find myself quite confused looking at the raw SQLite database.

#How to export the all available statistics for a energy sensor into a usable format