Trading database

Trading data is a sub-category of financial market data. It provides real-time information about stock and market prices as well as historical trends for assets such as equities, fixed-income products, currencies and derivatives.

SQL remains a fundamental tool for querying and managing data. SQL's simplicity and power make it accessible to both beginners and experts. In trading systems, SQL enables efficient data retrieval and manipulation. Users can write SQL queries to analyze market trends and execute trading strategies.

Parquet - Original first choice and most often the best choice for projects for all of the reasons discussed here. Best compression (roughly 3x smaller than HDF5 and 10x smaller than CSV), Best read time (when using multi cores) and best compatibility with different systems