Quantitative

PostgreSQL vs Parquet: what should store what in a quant stack?

The question is about Quantitative .

Answer:
Store smaller, structured tables such as metadata, instrument lists, settings, and summary results in Postgresql. Store large historical time-series data, such as ticks and bars, and research feature sets in Parquet files.

Related Quantitative Questions And Answers

Ready to Hire?

Hire trusted Quantitative devs from Ukraine & Europe in 48h

Skip the hiring headaches and get trusted Quantitative developers who deliver results. Cortance has helped startups scale to million-dollar success stories.

Cortance developer 1Cortance developer 2Cortance developer 3

Find your perfect Quantitative tech match

Pavlo mostly specialises in Backend development with a strong emphasis on quantitative analysis and data processing. With nine years of experience, he is proficient in Python, Node.js and JavaScript, utilising frameworks such... Read More

Level
Senior
Availability
40 h/w
Experience
8 yrs.
English
B2
Victoriia S.

Victoriia is a skilled Flutter Developer with 4 years of experience in mobile application development. She specializes in frameworks such as Flutter, leveraging JavaScript, DART, and utilizes databases like MySQL and Firebase... Read More

Level
Senior
Availability
20 - 30 h/w
Experience
10 yrs.
English
C1
Cortance 5-star rating on ClutchCortance 5-star rating on GoodFirms
Anonymous
Co-Owner

Cortance's work resulted in a 30% reduction in development time, exceeding expectations. Their high-quality resource leasing was instrumental in surpassing the project goals, which set new benchmarks for the client. Cortance's ability to provide highly skilled tech professionals was exceptional.

Clutch
5.0/5.0
Ilya Lisovski
Co-Founder & CTO

Thanks to Cortance's professionalism and collaborative approach, the end customer received a well-coded and highly scalable platform, which made them want to continue working with the client moving forward. The team was highly responsive and passionate about their work, offering the right approach.

Clutch
5.0/5.0
Curved left line
We're Here to Help

Thinking about how to expand a tech team flexibly to adapt to different working paces?

Accelerate development, meet launch deadlines with flexible, much-needed capacity. Add new skills your team currently lacks.

Curved right line