How to Downsample Your Data Efficiently

It only takes 41 seconds to downsample 6.48 billion high-frequency records to 61 million minute-level records in DolphinDB with just one line of SQL statement.

How does DolphinDB exhibit such outstanding performance in data downsampling? In DolphinDB:

🌠Jobs are executed distributedly and resources of different nodes can be utilized at the same time.
🌠Compression reduces the disk I/O.
🌠Columnar storage and vectorized computation improve the efficiency of aggregation...

👉 Follow us on Twitter:   / dolphindb_inc  
👉 Follow our LinkedIn:   / mycompany  
👉 Visit our GitHub: https://github.com/dolphindb
👉 Join our Slack: https://join.slack.com/t/dolphindb/sh...
👉 Try DolphinDB right now: https://www.dolphindb.com/

#DolphinDB #database #quant #trading #stockmarket #tickdata #hft #sql