I built something like this with a postgres database of transactions, a python script that scrapes the coinmarketcap api, and influxdb + grafana. It works well and suits my needs.
How were you able to update the database frequently with python? I’m trying to basically have a database that mirrors historical data on an exchange, that also updates every 5 minutes — I’m trying to decide between a node server / python aws lambda.