Compute skewness in sliding windows with mskew! 📊. Calculate skewness of X in windows (by element count or time). Syntax: mskew(X, window, [biased=true], [minPeriods]). #DolphinDB #SlidingWindow #Statistics

Calculate population std dev of top N elements in sliding windows! 📊. mstdpTopN(X, S, window, top, ascending) sorts X by S in each window, takes top N, computes STD. #DolphinDB #SlidingWindow #Statistics

RT @DolphinDB_Inc: 📢 At the 2025 Mid-Year Strategy Conference hosted by Guotai Junan Futures, our CEO Dr. Zhou Xiaohua was honored to speak….

Map-Reduce is core to DolphinDB's distributed computing! 🚀. Here's an example of distributed linear regression using Map-Reduce. #DolphinDB #MapReduce #DistributedComputing

Compute sliding window products with mprod! 📊. Calculate product of X elements in windows defined by element count or time. Syntax: mprod(X, window, [minPeriods]). #DolphinDB #SlidingWindow #DataCalculation

Understand movingWindowIndex! 📊. Returns an array of indices for elements in each sliding window of X. #DolphinDB #SlidingWindow #IndexManipulation

RT @DolphinDB_Inc: 💥 Facing memory pressure in #DolphinDB?. 📘 Dive into the full guide: Our latest technical guide….

Understand movingTopNIndex! 📊. Returns an array of indices for the top N elements in each sliding window of X, sorted as specified. #DolphinDB #SlidingWindow #IndexManipulation

Understand movingWindowData(X, window, [fixed=false])! 📊. Returns an array where each row holds elements of X's sliding windows. #DolphinDB #SlidingWindow #DataProcessing

Move chunk replicas between nodes with moveReplicas! 🔄. Example: Move all chunk replicas from "node1" to "node2's" specified dir:. #DolphinDB #DistributedStorage #ClusterOps

Find elements in vector A but not in B in #DolphinDB! 🔍.2 easy methods:. #DolphinDB #DataManipulation #Vectors

Window stats in #DolphinDB like Oracle's PARTITION BY! 📊. Use context by for partitioning:. #DolphinDB #SQLComparison #WindowFunctions

🧐Dynamic column fetching in #DolphinDB! . Use metaprogramming with select to get multiple columns:.select colNames()[idx1, idx2. ] from table. #DolphinDB #MetaProgramming #DataQuery

RT @DolphinDB_Inc: 👏Excited to share that #DolphinDB is partnering with the #FICCPKU Club for an exclusive in-person event in Beijing on Th….

TSDB Engine Error: "sort keys must be specified" ⚠️. When creating a distributed table with TSDB engine, you must specify the sortColumns parameter!.Example:.db = database("", TSDB, sortColumns=[time])`. #DolphinDB #TSDB #DistributedTables

Subscribe to cross-process SHM tables via API in #DolphinDB! 🚀. Server creates SHM table via GUI & writes data live. Use subscribeTable() API with proper parameters to stream updates. #DolphinDB #RealTimeData #InterProcessComm

Split data into N groups by value! 📊. Use cutPoints & asof for uniform binning. #DolphinDB #DataBinning #DistributedStorage #ClusterManagement

RT @DolphinDB_Inc: 🚀 Optimizing SQL in #DolphinDB Just Got Easier – Introducing the SQL Execution Plan Feature. 📘 Learn how it works and ge….

Move chunk replicas between nodes with moveReplicas! 🔄. Moves chunk copies from source to target nodes. Skips existing chunks on targets. Requires admin privileges & run on the control node. #DolphinDB #DistributedStorage #ClusterManagement

Extract month from dates with monthOfYear(X)! 🗓️. Returns month (1-12) for DATE, MONTH, DATETIME, TIMESTAMP, or NANOTIMESTAMP scalars, vectors, or tables. #DolphinDB #TimeSeries #DateFunctions