Icon

Convert to OHLC_​v2

Read price-volume data, convert UNIX timestamps to Date&Time This workflow takes raw stock price and volume data andconverts it to OHLC format using a user-specified start time,end time, and interval Create bins for OHLC data Bin price-volume data Aggregate data Node 3Node 4Node 6Node 7Node 10OHLC onlyprice/volumedataNode 14Node 15Creates NumRowsvariable for use inCross Joiner chunk sizefor optimizationNode 20Specifiy start data&time;end date&time;durationNode 22Node 23Node 24Node 25Node 26Node 6Node 28Full set forinspectionNode 30 Chunk Loop Start Loop End Column Rename UNIX Timestampto Date&Time Column Rename CSV Writer File Reader Row Filter Cross Joiner Extract TableDimension Create Date&TimeRange Table Creator Table Rowto Variable Date&Time-basedRow Filter Lag Column Rule Engine GroupBy Column Rename Column Filter CSV Writer Timer Info Read price-volume data, convert UNIX timestamps to Date&Time This workflow takes raw stock price and volume data andconverts it to OHLC format using a user-specified start time,end time, and interval Create bins for OHLC data Bin price-volume data Aggregate data Node 3Node 4Node 6Node 7Node 10OHLC onlyprice/volumedataNode 14Node 15Creates NumRowsvariable for use inCross Joiner chunk sizefor optimizationNode 20Specifiy start data&time;end date&time;durationNode 22Node 23Node 24Node 25Node 26Node 6Node 28Full set forinspectionNode 30 Chunk Loop Start Loop End Column Rename UNIX Timestampto Date&Time Column Rename CSV Writer File Reader Row Filter Cross Joiner Extract TableDimension Create Date&TimeRange Table Creator Table Rowto Variable Date&Time-basedRow Filter Lag Column Rule Engine GroupBy Column Rename Column Filter CSV Writer Timer Info

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Loïc
Created at: 2020-03-23
On NodePit since: 2020-04-09
Last update: 2024-11-23
Created with KNIME version: v4.1.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!