We basically need for all cryptocurrencies available in one table,
Change (24h) (%)
Weithed Moving Average (200day).
And in another table, historical prices for all cryptocurrencies (lifetime)
Historical low price
Historical high price
Historical market caps
We will use it for our website readers. They can compare all cryptocurrencies with prices, volumes or another technical indicators between selected (by user) two dates.
It will run real time (when user call the data)