본문 바로가기
카테고리 없음

PostgreSQL에서 OHLC 데이터 구축

by 나스닥171819 2023. 2. 12.
728x90
반응형

 

PostgreSQL에서 OHLC 데이터 구축

 

 

https://www.compose.com/articles/building-ohlc-data-in-postgresql/

 

Building OHLC Data in PostgreSQL

In this Write Stuff article, Lucero Del Alba illustrates the power of PostgreSQL's aggregate and date functions to analyze financial data, and shows you how to display the results in a web browser using TechanJS. OHLC charts (open, high, low, close) are es

www.compose.com

 

 

username  이 analog 일 경우

 

SET DateStyle = 'ISO,DMY'; COPY "EUR/USD" FROM '/home/analog/EURUSD_Ticks_08.11.2016-08.11.2016.csv' CSV HEADER;

 

 

 

반응형