Calculate average of columns at the end of each day

[Tyruiop]

Using a statement like

SELECT timeseries.contractSymbol, AVG(timeseries.delta) FROM timeseries LEFT JOIN live ON timeseries.contractsymbol = live.contractsymbol WHERE live.expiration > 1627721273 GROUP BY timeseries.contractSymbol;

at the end of each days, update the live table with the average value of (most) columns as we go, to enable search by average.

Add two averages: 20days & 100 days averages for each column, for now.

This will allow identifying drops & peaks in movements of each contract.

[Tyruiop]

Store all these statistics in a json field maybe, instead of creating many columns?

[Tyruiop]

Done, one column per average (20d and 100d).