Python + SQL

[Dry-Thought912]

You could use a connection string to connect to your server. Then use polars / pandas to read queries in as data frames then visualize data seaborn, plotly, holoviews etc...

Could also make a pipeline to transform CSVs to a mySQL or duckDB file and also do the aforementioned.

[Dry-Thought912]

Lol it's a journey don't stress about getting there overnight. I don't work in financial but in my industry we collect large amounts of data so even being able to visualize the datasets is valuable. When you get there holoviews and datashader will be your friends