First off, lots and lots of languages can let you capture that data. It’s all information retrieved from an API in a readily usable format called JSON. You can use Python, Javascript , C#, Java, and some others I can’t name off the top of my head.
As for putting it into a database, again, lots of different languages let you open up a connection to a database and store it. It really depends on what languages feel most comfortable to you.
To make the charts, you could export to a CSV file format and open that up in your favorite spreadsheet program. If that’s not what you’re after, you could follow the Data Analysis course FreeCodeCamp has to offer.
P.S I would look into the http-client library in Python to make requests, and the json library to parse it.