write it in js
- User
write it in js
- Assistant
Below is a JavaScript implementation of a converter that takes Binance-style trade data (from a
.csvfile) and aggregates it into candlestick data at a fixed interval (e.g., 250ms). This implementation uses Node.js and thecsv-parserlibrary to read the CSV file and process the data.
Prerequisites
Before running the script, make sure you have Node.js installed. You also need to install the
csv-parserandfsmodules. You can installcsv-parserby running:npm install csv-parser
Code:
convertTradesToCandles.jsconst fs = require('fs'); const csv = require('csv-parser'); /** * Converts trade data from a CSV file into candlestick data at a specified interval. * @param {string} inputCsv - Path to the input CSV file containing trades. * @param {string} outputCsv - Path to the output CSV file for the candles. * @param {number} interval - Candle interval in milliseconds (e.g., 250ms). */ function convertTradesToCandles(inputCsv, outputCsv, interval = 250) { const trades = []; const candles = []; // Read the CSV file fs.createReadStream(inputCsv) .pipe(csv()) .on('data', (row) => { // Parse the trade data const time = parseInt(row.time, 10); // Unix timestamp in ms const price = parseFloat(row.price); const qty = parseFloat(row.qty); trades.push({ time, price, qty }); }) .on('end', () => { console.log('Finished reading trades. Processing candles...'); // Sort trades by time (just in case the data is not sorted) trades.sort((a, b) => a.time - b.time); // Initialize variables for candle aggregation let candleStartTime = Math.floor(trades[0].time / interval) * interval; let open = null, high = null, low = null, close = null, volume = 0; // Process trades into candles trades.forEach((trade) => { const { time, price, qty } = trade; // Check if the trade belongs to the current candle if (time >= candleStartTime + interval) { // Push the completed candle to the candles array if (open !== null) { candles.push({ time: candleStartTime, open, high, low, close, volume, }); } // Start a new candle candleStartTime = Math.floor(time / interval) * interval; open = price; high = price; low = price; close = price; volume = qty; } else { // Update the current candle if (open === null) open = price; if (high === null || price > high) high = price; if (low === null || price < low) low = price; close = price; volume += qty; } }); // Push the last candle if (open !== null) { candles.push({ time: candleStartTime, open, high, low, close, volume, }); } // Write the candles to the output CSV file const outputStream = fs.createWriteStream(outputCsv); outputStream.write('time,open,high,low,close,volume\n'); candles.forEach((candle) => { outputStream.write( `${candle.time},${candle.open},${candle.high},${candle.low},${candle.close},${candle.volume}\n` ); }); outputStream.end(); console.log(`Candles written to ${outputCsv}`); }); } // Command-line arguments const args = process.argv.slice(2); if (args.length < 2) { console.error('Usage: node convertTradesToCandles.js <inputCsv> <outputCsv> [interval]'); process.exit(1); } const inputCsv = args[0]; const outputCsv = args[1]; const interval = args[2] ? parseInt(args[2], 10) : 250; // Default interval is 250ms convertTradesToCandles(inputCsv, outputCsv, interval);
How It Works
-
Reading the CSV File:
- The script uses the
csv-parserlibrary to read the input CSV file line by line. - Each row is parsed into an object with
time,price, andqtyfields.
- The script uses the
-
Sorting Trades:
- The trades are sorted by their
timefield to ensure they are processed in chronological order.
- The trades are sorted by their
-
Aggregating Candles:
- The script groups trades into fixed intervals (e.g., 250ms).
- For each interval, it calculates:
- Open: The first trade price in the interval.
- High: The highest trade price in the interval.
- Low: The lowest trade price in the interval.
- Close: The last trade price in the interval.
- Volume: The sum of all trade quantities in the interval.
-
Writing the Output:
- The aggregated candlestick data is written to a new CSV file with the following columns:
time,open,high,low,close,volume.
- The aggregated candlestick data is written to a new CSV file with the following columns:
Running the Script
Save the script as
convertTradesToCandles.jsand run it from the command line:node convertTradesToCandles.js trades.csv candles.csv 250trades.csvis the input file containing trade data.candles.csvis the output file where the candlestick data will be saved.250is the candle interval in milliseconds (optional; defaults to 250ms).
Example Input (
trades.csv)time,price,qty 1698765300000,100.5,0.01 1698765300100,101.0,0.02 1698765300250,100.8,0.03 1698765300500,101.2,0.01 1698765300750,101.5,0.04Example Output (
candles.csv)time,open,high,low,close,volume 1698765300000,100.5,101.0,100.5,101.0,0.03 1698765300250,100.8,100.8,100.8,100.8,0.03 1698765300500,101.2,101.5,101.2,101.5,0.05
This script provides a simple and efficient way to convert trade data into candlestick data in JavaScript. You can customize it further to handle additional fields or different formats.
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.