Pulling a years worth of data at full resolution

I’ve got a request from someone whos doing a research paper on residential solar PV and is looking for some data.
Ive got over a year stored in my emon cms of each string. If I use the graph function of emoncms as you go as far as a year, the resolution drops (I understand why!)

Where/what could I use to call that data from the database manually.

A general point in the right direction would be great, I have some rusty knowledge of SQL. (and the old version running on a pi before I migrated to a VM,)

Firstly, the data is in flat files ; SQL is just for some other settings and meta data.

On Feeds page, select the feed and click on Download (I think).

image

1 Like

Perfect, Just what I wanted.

1 Like