database - Data aggregation and caching: How to quickly graph large time series datasets by interval -

i have huge time series dataset i'd graph. time series spans 5 years. backend standpoint, common approaches displaying data @ various resolutions (intervals)? chart data this:

https://bitcoinwisdom.com/markets/bitstamp/btcusd

i'd offer user ability select time interval (seconds, minutes, hours, days, months, years). how data typically aggregated , stored? want store table each time interval , precompute data? figure need regularly running job combine data. caching come play? how people imagine bitcoinwisdom able recall historical bitcoin prices various time ranges quickly? looked @ backend , api fetch prices allows user specify intervals. how recall data quickly? must precomputed , stored somehow.