GALA（Gala Games）binanceのOHLCを取得してチャートをプロットするpython

##＃ライブラリのインストール
import requests
import json
from datetime import datetime
import time
import pandas as pd
import requests

In [ ]:

period = '3600' #60*30 30分足
exchange = 'binance'
pair = 'galausdt'
#↓指定以降のデータを取得
after = str(int(datetime.timestamp(datetime.strptime('2021-10-15','%Y-%m-%d'))))
url = 'https://api.cryptowat.ch/markets/'
que = f"{url}{exchange}/{pair}/ohlc?periods={period}&after={after}"
print(que)

Out[ ]:

'https://api.cryptowat.ch/markets/binance/galausdt/ohlc?periods=3600&after=1634223600'

r = requests.get(que)#データをjsonに変換する
r2=json.loads(r.text)

In [ ]:

cw_data=r2['result'][period]
cw_data[:2]

Out[ ]:

[[1634223600, 0.08701, 0.09333, 0.08695, 0.09044, 157647502, 14352555.69161],
 [1634227200, 0.09046, 0.09372, 0.08869, 0.09341, 183458903, 16863966.94315]]

In [ ]:

#DataFrameを作るため列データをそれぞれリストに放り込んでいく
bitcoindate=[]
open=[]
high=[]
low=[]
close=[]
volume = []

In [ ]:

for i in cw_data:
    date=int(i[0])
    lct =datetime.utcfromtimestamp(date)
    bitcoindate.append(lct)
    open.append(i[1])
    high.append(i[2])
    low.append(i[3])
    close.append(i[4])
    volume.append(i[5])

df=pd.DataFrame({"date":bitcoindate, "open":open, "high":high, "low":low, "close":close, 'volume':volume})

df['date'] = pd.to_datetime(df['date'])
df.set_index('date', inplace=True)

print(df)

Out[ ]:

	open	high	low	close	volume
date
2021-10-14 15:00:00	0.08701	0.09333	0.08695	0.09044	157647502
2021-10-14 16:00:00	0.09046	0.09372	0.08869	0.09341	183458903
2021-10-14 17:00:00	0.09336	0.09785	0.09220	0.09608	204217967
2021-10-14 18:00:00	0.09608	0.09608	0.09251	0.09350	101290727
2021-10-14 19:00:00	0.09343	0.09350	0.09078	0.09235	62106702
…	…	…	…	…	…
2021-11-25 03:00:00	0.56958	0.56960	0.54031	0.54298	52889285
2021-11-25 04:00:00	0.54298	0.54538	0.52340	0.53722	64936341
2021-11-25 05:00:00	0.53743	0.57680	0.53031	0.57501	73664641
2021-11-25 06:00:00	0.57550	0.63780	0.56538	0.63484	210681360
2021-11-25 07:00:00	0.63546	0.68179	0.62302	0.67279	193644562

1001 rows × 5 columnsIn [ ]:

# 2020年5月 mplfinanceという新たなパッケージが作られている
# https://note.nkmk.me/python-pandas-matplotlib-candlestick-chart/
import mplfinance as mpf
%matplotlib inline
mpf.plot(df, type='candle',  volume=True, mav=(50, 168),  style='yahoo')