Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Quick Start

FinanceData.KR edited this page Jan 28, 2021 · 1 revision

FinanceDataReader ์‚ฌ์šฉ์ž ์•ˆ๋‚ด์„œ

FinanceDataReader๋Š” ํ•œ๊ตญ, ๋ฏธ๊ตญ ๊ธ€๋กœ๋ฒŒ ์‹œ์žฅ์˜ ๊ธˆ์œต์ƒํ’ˆ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ(์ฃผ์‹, ์ง€์ˆ˜, ํ™˜์œจ, ์„ ๋ฌผ ๋“ฑ)์™€ ์ข…๋ชฉ ๋ฆฌ์ŠคํŒ… ๋“ฑ ๊ธˆ์œต ๋ฐ์ดํ„ฐ ์ˆ˜์ง‘๊ณผ ๋ถ„์„์„ ์œ„ํ•œ ์˜คํ”ˆ์†Œ์Šค ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ž…๋‹ˆ๋‹ค.

] = 'nanummyeongjo' plt.rcParams["figure.figsize"] = (14,4) plt.rcParams['lines.linewidth'] = 2 plt.rcParams["axes.grid"] = True

๊ฐœ์š”

๊ธˆ์œตํˆฌ์ž ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ค๋ฃจ๋Š”๋ฐ ๊ฐ€์žฅ ๊ธฐ๋ณธ์ด ๋˜๋Š” ๋ฐ์ดํ„ฐ๋Š” ๊ฑฐ๋ž˜์†Œ๋ณ„ ์ „์ฒด ์ข…๋ชฉ ์ฝ”๋“œ์™€ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ์ž…๋‹ˆ๋‹ค. FinanceDataReader๋Š” ๊ธˆ์œต ๋ฐ์ดํ„ฐ์— ๊ด€์‹ฌ์ด ๋งŽ์€ ๊ฐœ์ธ, ๊ธˆ์œตํˆฌ์ž ์ข…์‚ฌ์ž ํ˜น์€ ๊ฐœ์ธํˆฌ์ž์ž๋ฅผ ์œ„ํ•ด ๋งŒ๋“ค์–ด์ง„ ์˜คํ”ˆ์†Œ์Šค ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ž…๋‹ˆ๋‹ค. ๋‹ค์–‘ํ•œ ๋ฐ์ดํ„ฐ ์†Œ์Šค๋กœ ๋ถ€ํ„ฐ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ๋ฅผ ์†์‰ฝ๊ฒŒ ๊ฐ€์ ธ์˜ค๊ธฐ ์œ„ํ•œ ๋ชฉ์ ์œผ๋กœ ๋งŒ๋“ค์–ด์กŒ์œผ๋ฉฐ ๋ฐฑํ…Œ์ŠคํŠธ, ๊ฐ€๊ฒฉ ๋ถ„์„, ์‹œ์žฅ ๋ชจ๋‹ˆํ„ฐ๋ง ๋“ฑ์— ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๋‹ค์Œ๊ณผ ๊ฐ™์€ ๋ฐ์ดํ„ฐ๋ฅผ ์†์‰ฝ๊ฒŒ ๊ฐ€์ ธ์˜ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์ข…๋ชฉ ์ฝ”๋“œ

  • ๊ฑฐ๋ž˜์†Œ๋ณ„ ์ „์ฒด ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ: 'KRX' ('KOSPI', 'KODAQ', 'KONEX'), 'NASDAQ', 'NYSE', 'AMEX' and 'S&P500'
  • ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ(KRX) ์ƒ์žฅํ์ง€์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ: 'KRX-DELISTING'

๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ

  • ๊ตญ๋‚ด์ฃผ์‹ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ: '005930'(์‚ผ์„ฑ์ „์ž), '091990'(์…€ํŠธ๋ฆฌ์˜จํ—ฌ์Šค์ผ€์–ด) ๋“ฑ
  • ํ•ด์™ธ์ฃผ์‹ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ: 'AAPL'(์• ํ”Œ), 'AMZN'(์•„๋งˆ์กด), 'GOOG'(๊ตฌ๊ธ€) ๋“ฑ
  • ๊ตญ๋‚ด ์ƒ์žฅํ์ง€ ์ข…๋ชฉ ๊ณผ๊ฑฐ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ
  • ์‹œ์žฅ๋ณ„ ์ข…๋ชฉ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ: 'KRX'(ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ), 'NASDAQ'(๋‚˜์Šค๋‹ฅ), 'NYSE'(๋‰ด์š•์ฆ๊ถŒ๊ฑฐ๋ž˜์†Œ), 'AMEX'(๋ฏธ๊ตญ์ฆ๊ถŒ๊ฑฐ๋ž˜์†Œ), 'SSE'(์ƒํ•ด), 'SZSE'(์‹ฌ์ฒœ), 'HKEX'(ํ™์ฝฉ), 'TSE'(๋„์ฟ„)
  • ETF ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ: ๊ตญ๊ฐ€๋ณ„('KR', 'US', 'JP' ๋“ฑ)
  • ๊ฐ์ข… ์ง€์ˆ˜: 'KS11'(์ฝ”์Šคํ”ผ์ง€์ˆ˜), 'KQ11'(์ฝ”์Šค๋‹ฅ์ง€์ˆ˜), 'DJI'(๋‹ค์šฐ์ง€์ˆ˜), 'IXIC'(๋‚˜์Šค๋‹ฅ ์ง€์ˆ˜), 'US500'(S&P 5000)
  • ํ™˜์œจ ๋ฐ์ดํ„ฐ: 'USD/KRX' (์›๋‹ฌ๋Ÿฌ ํ™˜์œจ), 'USD/EUR'(๋‹ฌ๋Ÿฌ๋‹น ์œ ๋กœํ™” ํ™˜์œจ), 'CNY/KRW': ์œ„์—”ํ™” ์›ํ™” ํ™˜์œจ
  • ์•”ํ˜ธํ™”ํ ๊ฐ€๊ฒฉ: 'BTC/USD' (๋น„ํŠธ์ฝ”์ธ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ, Bitfinex), 'BTC/KRW' (๋น„ํŠธ์ฝ”์ธ ์›ํ™” ๊ฐ€๊ฒฉ, ๋น—์ธ)

์„ค์น˜

์ƒˆ๋กœ ์„ค์น˜

pip install finance-datareader

์—…๋ฐ์ดํŠธ (์ด๋ฏธ ์„ค์น˜ํ•˜์‹  ๋ถ„์ด ์ตœ์‹  ๋ฒ„์ „์„ ์„ค์น˜ํ•˜์‹œ๋ ค๋ฉด)

pip install -U finance-datareader

์‚ฌ์šฉ

import FinanceDataReader as fdr
fdr.__version__

'0.9.3'

๊ฑฐ๋ž˜์†Œ๋ณ„ ์ƒ์žฅ ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ

์ข…๋ชฉ ๋ฐ์ดํ„ฐ ์ „์ฒด๋ฅผ ์–ป๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๊ฑฐ๋ž˜์†Œ ์‹ฌ๋ณผ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

ํ•œ๊ตญ

์‹ฌ๋ณผ ๊ฑฐ๋ž˜์†Œ
KRX KRX ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ ์ „์ฒด
KOSPI KOSPI ๋ฆฌ์ŠคํŠธ ์ข…๋ชฉ
KOSDAQ KOSDAQ ๋ฆฌ์ŠคํŠธ ์ข…๋ชฉ
KONEX KONEX ๋ฆฌ์ŠคํŠธ ์ข…๋ชฉ
KRX-DELISTING KRX์ƒ์žฅํ์ง€์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ
KRX-MARCAP KRX ์‹œ๊ฐ€์ด์•ก์ˆœ ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ

โ€ป(ๆณจ่จ˜) KRX๋Š” KOSPI,KOSDAQ,KONEX ๋ชจ๋‘ ํฌํ•จํ•ฉ๋‹ˆ๋‹ค.

๋ฏธ๊ตญ

์‹ฌ๋ณผ ๊ฑฐ๋ž˜์†Œ
NASDAQ ๋‚˜์Šค๋‹ฅ ์ข…๋ชฉ
NYSE ๋‰ด์š• ์ฆ๊ถŒ๊ฑฐ๋ž˜์†Œ ์ข…๋ชฉ
AMEX AMEX ์ข…๋ชฉ
S&P500 S&P 500 ์ข…๋ชฉ
import FinanceDataReader as fdr
# S&P 500 ์ข…๋ชฉ ์ „์ฒด
sp500 = fdr.StockListing('S&P500')
sp500.head()
Symbol Name Sector Industry
0 MMM 3M Company Industrials Industrial Conglomerates
1 ABT Abbott Laboratories Health Care Health Care Equipment
2 ABBV AbbVie Inc. Health Care Pharmaceuticals
3 ABMD ABIOMED Inc Health Care Health Care Equipment
4 ACN Accenture plc Information Technology IT Consulting & Other Services
# S&P500์˜ ์ข…๋ชฉ์ˆ˜: S&P500 ์ข…๋ชฉ์ˆ˜๋Š” 500๊ฐœ๊ฐ€ ์•„๋‹ˆ๋ผ 2๊ฐœ์˜ ํด๋ž˜์Šค๋ฅผ ๊ฐ€์ง„ ์ข…๋ชฉ๋“ค์ด ์žˆ์–ด์„œ 505๊ฐœ ์ž…๋‹ˆ๋‹ค.
len(sp500)
505

ETF ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ

๊ตญ๊ฐ€๋ณ„ ETF ์ข…๋ชฉ ๋ฆฌ์ŠคํŠธ๋ฅผ ๊ฐ€์ ธ์˜ต๋‹ˆ๋‹ค. ์ง€์›ํ•˜๋Š” ๊ตญ๊ฐ€๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์œผ๋ฉฐ ์ง€์ •ํ•˜์ง€ ์•Š๋Š” ๊ฒฝ์šฐ ๊ธฐ๋ณธ๊ฐ’์€ 'KR'(ํ•œ๊ตญ) ์ž…๋‹ˆ๋‹ค.

  • 'KR': ํ•œ๊ตญ (๊ธฐ๋ณธ๊ฐ’)
  • 'US': ๋ฏธ๊ตญ
  • 'CN': ์ค‘๊ตญ
  • 'HK': ํ™์ฝฉ
  • 'JP': ์ผ๋ณธ
  • 'UK': ์˜๊ตญ
  • 'FR': ํ”„๋ž‘์Šค
df_etf = fdr.EtfListing('KR')
df_etf.head(10)
Symbol Name
0 069500 KODEX 200
1 102110 TIGER 200
2 122630 KODEX ๋ ˆ๋ฒ„๋ฆฌ์ง€
3 278540 KODEX MSCI Korea TR
4 102780 KODEX ์‚ผ์„ฑ๊ทธ๋ฃน
5 148020 KBSTAR 200
6 278530 KODEX 200TR
7 310970 TIGER MSCI Korea TR
8 153130 KODEX ๋‹จ๊ธฐ์ฑ„๊ถŒ
9 273130 KODEX ์ข…ํ•ฉ์ฑ„๊ถŒ(AA-์ด์ƒ)์•กํ‹ฐ๋ธŒ
# ํ˜„์žฌ ํ•œ๊ตญ์— ์ƒ์žฅ๋œ ETF ์ข…๋ชฉ์€ ๋ชจ๋‘ 451์ข…๋ชฉ ์ž…๋‹ˆ๋‹ค.
len(df_etf)
451

๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ - ๊ตญ๋‚ด์ฃผ์‹

๊ตญ๋‚ด ์ฃผ์‹์˜ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ๋Š” ๋ชจ๋‘ ๋‹จ์ถ• ์ฝ”๋“œ(6์ž๋ฆฌ)๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์กฐํšŒํ•ฉ๋‹ˆ๋‹ค. ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ๋Š” ๋ชจ๋‘ ์ˆ˜์ •๊ฐ€๊ฒฉ(Adjusted Price)์ž…๋‹ˆ๋‹ค.

  • ์ฝ”์Šคํ”ผ ์ข…๋ชฉ: 068270(์…€ํŠธ๋ฆฌ์˜จ), 005380(ํ˜„๋Œ€์ฐจ) ๋“ฑ
  • ์ฝ”์Šค๋‹ฅ ์ข…๋ชฉ: 215600(์‹ ๋ผ์  ), 151910(๋‚˜๋…ธ์Šค) ๋“ฑ
import FinanceDataReader as fdr
# ์‹ ๋ผ์  (215600), 2018๋…„
df = fdr.DataReader('215600', '2018-01-01') # 2018ๅนด01ๆœˆ01ๆ—ฅ ~ ํ˜„์žฌ
df.head()
Open High Low Close Volume Change
Date
2018ๅนด01ๆœˆ02ๆ—ฅ 95900 104000 93300 102500 6824281 0.096257
2018ๅนด01ๆœˆ03ๆ—ฅ 102600 104900 99500 103000 4760150 0.004878
2018ๅนด01ๆœˆ04ๆ—ฅ 102600 104000 92200 92200 6538665 -0.104854
2018ๅนด01ๆœˆ05ๆ—ฅ 85800 101200 85700 100000 8318372 0.084599
2018ๅนด01ๆœˆ08ๆ—ฅ 98000 98400 92500 93800 6352776 -0.062000
df.tail()
Open High Low Close Volume Change
Date
2020ๅนด02ๆœˆ03ๆ—ฅ 12600 13400 12450 13150 2577917 0.011538
2020ๅนด02ๆœˆ04ๆ—ฅ 13250 13750 13200 13650 1739670 0.038023
2020ๅนด02ๆœˆ05ๆ—ฅ 13750 14050 11600 12450 5292116 -0.087912
2020ๅนด02ๆœˆ06ๆ—ฅ 12000 12900 11650 12650 5028799 0.016064
2020ๅนด02ๆœˆ07ๆ—ฅ 12700 14800 12300 13050 12577686 0.031621
import FinanceDataReader as fdr
# ์…€ํŠธ๋ฆฌ์˜จ, 2017ๅนด01ๆœˆ01ๆ—ฅ ~ ํ˜„์žฌ
df = fdr.DataReader('068270', '2017-01-01')
df['Close'].plot()

png

๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ - ๋ฏธ๊ตญ ์ฃผ์‹

import FinanceDataReader as fdr
# ์• ํ”Œ(AAPL), 2018ๅนด01ๆœˆ01ๆ—ฅ ~ 2018ๅนด03ๆœˆ30ๆ—ฅ
df = fdr.DataReader('AAPL', '2018-01-01', '2020-01-30')
df.tail()
Close Open High Low Volume Change
Date
2020ๅนด01ๆœˆ24ๆ—ฅ 318.31 320.25 323.33 317.52 36630000.0 -0.0029
2020ๅนด01ๆœˆ27ๆ—ฅ 308.95 310.06 311.77 304.88 40490000.0 -0.0294
2020ๅนด01ๆœˆ28ๆ—ฅ 317.69 312.60 318.40 312.19 40560000.0 0.0283
2020ๅนด01ๆœˆ29ๆ—ฅ 324.34 324.45 327.85 321.38 54150000.0 0.0209
2020ๅนด01ๆœˆ30ๆ—ฅ 323.87 320.54 324.09 318.75 31690000.0 -0.0014
import FinanceDataReader as fdr
# ์• ํ”Œ(AAPL), 2017ๅนด01ๆœˆ01ๆ—ฅ ~ ํ˜„์žฌ
df = fdr.DataReader('AAPL', '2017')
df['Close'].plot()

png

import FinanceDataReader as fdr
# ์•„๋งˆ์กด(AMZN), 2010ๅนด01ๆœˆ01ๆ—ฅ ~ ํ˜„์žฌ
df = fdr.DataReader('AMZN', '2010')
df['Close'].plot()

png

# ๊ธฐ๊ฐ„์— ์ƒ๊ด€์—†์ด ๋ฐ์ดํ„ฐ๋ฅผ ์ฝ์–ด ์˜ต๋‹ˆ๋‹ค ('F'ํฌ๋“œ, 1980ๅนด01ๆœˆ01ๆ—ฅ ~ 2020ๅนด12ๆœˆ31ๆ—ฅ, 40๋…„ ๋ฐ์ดํ„ฐ)
import FinanceDataReader as fdr
df = fdr.DataReader('F', '1980-01-01', '2020-12-31')
len(df)
10060
df['Close'].plot()

png

ETF ์ข…๋ชฉ ๊ฐ€๊ฒฉ

๊ฐœ๋ณ„ ETF ์ข…๋ชฉ์˜ ๊ฐ€๊ฒฉ๋„ DataReader() ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋‹ค์Œ๊ณผ ๊ฐ™์ด ๊ฐ€์ ธ์˜ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

# 069500 KODEX 200
df = fdr.DataReader('069500', '2019-01-01')
df.head(10)
Open High Low Close Volume Change
Date
2019ๅนด01ๆœˆ02ๆ—ฅ 26173 26212 25591 25677 4795980 -0.011625
2019ๅนด01ๆœˆ03ๆ—ฅ 25670 25700 25397 25428 5649255 -0.009697
2019ๅนด01ๆœˆ04ๆ—ฅ 25416 25655 25347 25623 10281475 0.007669
2019ๅนด01ๆœˆ07ๆ—ฅ 25944 26178 25929 25989 5700324 0.014284
2019ๅนด01ๆœˆ08ๆ—ฅ 25998 26076 25802 25819 4670564 -0.006541
2019ๅนด01ๆœˆ09ๆ—ฅ 25924 26432 25924 26351 5263421 0.020605
2019ๅนด01ๆœˆ10ๆ—ฅ 26373 26496 26271 26341 5924713 -0.000379
2019ๅนด01ๆœˆ11ๆ—ฅ 26452 26579 26364 26503 5054162 0.006150
2019ๅนด01ๆœˆ14ๆ—ฅ 26447 26477 26246 26274 3546372 -0.008641
2019ๅนด01ๆœˆ15ๆ—ฅ 26368 26813 26354 26801 4744723 0.020058
# SPDR S&P 500 ETF
df = fdr.DataReader('SPY', '2019-01-01', '2019-06-30')
df.head(10)
Close Open High Low Volume Change
Date
2019ๅนด01ๆœˆ02ๆ—ฅ 250.18 245.98 251.21 245.95 126930000.0 0.0010
2019ๅนด01ๆœˆ03ๆ—ฅ 244.21 248.23 248.57 243.67 144140000.0 -0.0239
2019ๅนด01ๆœˆ04ๆ—ฅ 252.39 247.59 253.11 247.17 142630000.0 0.0335
2019ๅนด01ๆœˆ07ๆ—ฅ 254.38 252.69 255.95 251.69 103140000.0 0.0079
2019ๅนด01ๆœˆ08ๆ—ฅ 256.77 256.82 257.31 254.00 102510000.0 0.0094
2019ๅนด01ๆœˆ09ๆ—ฅ 257.97 257.56 258.91 256.19 95010000.0 0.0047
2019ๅนด01ๆœˆ10ๆ—ฅ 258.88 256.26 259.16 255.50 96820000.0 0.0035
2019ๅนด01ๆœˆ11ๆ—ฅ 258.98 257.68 259.01 257.03 73860000.0 0.0004
2019ๅนด01ๆœˆ14ๆ—ฅ 257.40 256.86 258.30 256.41 70910000.0 -0.0061
2019ๅนด01ๆœˆ15ๆ—ฅ 260.35 257.82 260.70 257.81 85210000.0 0.0115

๊ฑฐ๋ž˜์†Œ ์ง€์ •ํ•˜์—ฌ ์กฐํšŒํ•˜๊ธฐ

FinanceDataReader๋Š” ์ข…๋ชฉ์ฝ”๋“œ(symbol)๊ฐ€ ์ˆซ์ž๋กœ๋งŒ ๊ตฌ์„ฑ๋œ ๊ฒฝ์šฐ ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ(KRX)์‹œ์žฅ์„, ์˜๋ฌธ์œผ๋กœ ๋˜์–ด ์žˆ๋Š” ๊ฒฝ์šฐ ๋ฏธ๊ตญ์‹œ์žฅ(NYSE, NASDAQ, AMEX)์˜ ์ข…๋ชฉ์„ ์šฐ์„  ๊ฒ€์ƒ‰ํ•ฉ๋‹ˆ๋‹ค.

ํ•œ๊ตญ๊ณผ ๋ฏธ๊ตญ์„ ์ œ์™ธํ•œ ๊ตญ๊ฐ€์˜ ์ข…๋ชฉ์„ ์กฐํšŒํ•  ๊ฒฝ์šฐ์—๋Š” ๋ช…์‹œ์ ์œผ๋กœ ๊ฑฐ๋ž˜์†Œ(exchange)๋ฅผ ์ง€์ •ํ•˜์—ฌ ์‚ฌ์šฉํ•˜์„ธ์š”.

ํ•œ๊ตญ, ์ค‘๊ตญ, ํ™์ฝฉ, ์ผ๋ณธ ๋“ฑ์€ ์ข…๋ชฉ ์ฝ”๋“œ๊ฐ€ ์ˆซ์ž๋กœ ๋˜์–ด ์žˆ์Šต๋‹ˆ๋‹ค. ์ข…๋ชฉ์ฝ”๋“œ๊ฐ€ ๊ตญ๊ฐ€๊ฐ„(๊ฑฐ๋ž˜์†Œ)์— ๊ฒน์น  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ(KRX)์˜ ๋‘์‚ฐ(000150)๊ณผ ์‹ฌ์ฒœ๊ฑฐ๋ž˜์†Œ(SZSE)์—์„œ Yihua Healthcare(000150)๋Š” ์ข…๋ชฉ ์ฝ”๋“œ๊ฐ€ ๋™์ผํ•ฉ๋‹ˆ๋‹ค.

์ด๋Ÿฐ ๊ฒฝ์šฐ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์ด ๋ช…์‹œ์ ์œผ๋กœ ๊ฑฐ๋ž˜์†Œ(exchange)๋ฅผ ์ง€์ •ํ•˜์—ฌ ์กฐํšŒ ํ•ฉ๋‹ˆ๋‹ค.

# ๋‘์‚ฐ(000150) ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ(KRX)) 
df = fdr.DataReader('000150', '2018-01-01', '2019-10-30') # KRX ๋‘์‚ฐ(000150)
df = fdr.DataReader('000150', '2018-01-01', '2019-10-30', exchange='KRX') # KRX ๋‘์‚ฐ(000150)
# Yihua Healthcare(000150) ์‹ฌ์ฒœ๊ฑฐ๋ž˜์†Œ(SZSE)
df = fdr.DataReader('000150', '2018-01-01', '2019-10-30', exchange='SZSE') # SZSE
df = fdr.DataReader('000150', '2018-01-01', '2019-10-30', exchange='์‹ฌ์ฒœ') # SZSE

exchange ์˜ต์…˜์— ์ง€์ •ํ•  ์ˆ˜ ์žˆ๋Š” ๊ฑฐ๋ž˜์†Œ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

'KRX'(ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ), 'NASDAQ'(๋‚˜์Šค๋‹ฅ), 'NYSE'(๋‰ด์š•์ฆ๊ถŒ๊ฑฐ๋ž˜์†Œ), 'AMEX'(๋ฏธ๊ตญ์ฆ๊ถŒ๊ฑฐ๋ž˜์†Œ), 'SSE'(์ƒํ•ด), 'SZSE'(์‹ฌ์ฒœ), 'HKEX'(ํ™์ฝฉ), 'TSE'(๋„์ฟ„)
# ํ™์ฝฉ๊ฑฐ๋ž˜์†Œ(HKEX) 7500: CSOP Hang Seng Index Daily (-2x) Inverse
df = fdr.DataReader('7500', '2019-01-01', '2019-06-30', exchange='HKEX')
df.head()
Close Open High Low Volume Change
Date
2019ๅนด05ๆœˆ29ๆ—ฅ 7.22 7.24 7.25 7.12 29560000.0 0.0112
2019ๅนด05ๆœˆ30ๆ—ฅ 7.27 7.22 7.33 7.17 24100000.0 0.0069
2019ๅนด05ๆœˆ31ๆ—ฅ 7.40 7.32 7.41 7.25 27730000.0 0.0179
2019ๅนด06ๆœˆ03ๆ—ฅ 7.41 7.50 7.50 7.34 37710000.0 0.0014
2019ๅนด06ๆœˆ04ๆ—ฅ 7.46 7.37 7.51 7.36 21010000.0 0.0067

์ง€์ˆ˜(index) ์กฐํšŒ

์ง€์ˆ˜๋ฅผ ์‹ฌ๋ณผ(symbol)์„ ์ง€์ •ํ•˜์—ฌ ๋‹ค์–‘ํ•œ ์ง€์ˆ˜๋ฅผ ์กฐํšŒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋ฐ˜ํ™˜ํ˜•์‹์€ ๊ฐœ๋ณ„ ์ข…๋ชฉ๊ณผ ๋™์ผํ•ฉ๋‹ˆ๋‹ค.

ํ•œ๊ตญ ์ง€์ˆ˜

์‹ฌ๋ณผ ์„ค๋ช…
KS11 KOSPI ์ง€์ˆ˜
KQ11 KOSDAQ ์ง€์ˆ˜
KS50 KOSPI 50 ์ง€์ˆ˜
KS100 KOSPI 100 ์ง€์ˆ˜
KS200 KOSPI 200 ์ง€์ˆ˜
KQ150 KOSDAQ 150 ์ง€์ˆ˜
KRX100 KRX 100

๋ฏธ๊ตญ ์ง€์ˆ˜

์‹ฌ๋ณผ ์„ค๋ช…
DJI ๋‹ค์šฐ์กด์Šค ์ง€์ˆ˜
IXIC ๋‚˜์Šค๋‹ฅ ์ง€์ˆ˜
US500 S&P 500 ์ง€์ˆ˜
VIX S&P 500 VIX

โ€ป(ๆณจ่จ˜) DJI, IXIC, US500 ๊ฐ€ ๋ฏธ๊ตญ 3๋Œ€ ์ง€์ˆ˜

๊ธฐํƒ€ ๊ตญ๊ฐ€๋ณ„ ์ฃผ์š” ์ง€์ˆ˜

์‹ฌ๋ณผ ์„ค๋ช…
JP225 ๋‹›์ผ€์ด 225 ์„ ๋ฌผ
STOXX50 ์œ ๋ ต STOXX 50
HSI ํ•ญ์… (ํ™์ฝฉ)
CSI300 CSI 300 (์ค‘๊ตญ)
SSEC ์ƒํ•ด ์ข…ํ•ฉ
UK100 ์˜๊ตญ FTSE
DE30 ๋…์ผ DAX 30
FCHI ํ”„๋ž‘์Šค CAC 40
import FinanceDataReader as fdr
# KS11 (KOSPI ์ง€์ˆ˜), 2015๋…„~ํ˜„์žฌ
df = fdr.DataReader('KS11', '2015-01-01')
df['Close'].plot()

png

# ๋‹ค์šฐ์ง€์ˆ˜, 2015๋…„~ํ˜„์žฌ
df = fdr.DataReader('DJI', '2015')
df['Close'].plot()

png

# DAX, 2015๋…„~ํ˜„์žฌ
df = fdr.DataReader('DE30', '2015')
df['Close'].plot()

png

ํ™˜์œจ

์‹ฌ๋ณผ ์„ค๋ช…
USD/KRW ๋‹ฌ๋Ÿฌ๋‹น ์›ํ™” ํ™˜์œจ
USD/EUR ๋‹ฌ๋Ÿฌ๋‹น ์œ ๋กœํ™” ํ™˜์œจ
USD/JPY ๋‹ฌ๋Ÿฌ๋‹น ์—”ํ™” ํ™˜์œจ
CNY/KRW ์œ„์—”ํ™” ์›ํ™” ํ™˜์œจ
EUR/USD ์œ ๋กœํ™” ๋‹ฌ๋Ÿฌ ํ™˜์œจ
USD/JPY ๋‹ฌ๋Ÿฌ ์—”ํ™” ํ™˜์œจ
JPY/KRW ์—”ํ™” ์›ํ™” ํ™˜์œจ
AUD/USD ์˜ค์ŠคํŠธ๋ ˆ์ผ๋ฆฌ์•„ ๋‹ฌ๋Ÿฌ ํ™˜์œจ
EUR/JPY ์œ ๋กœํ™” ์—”ํ™” ํ™˜์œจ
USD/RUB ๋‹ฌ๋Ÿฌ ๋ฃจ๋ธ”ํ™”
import FinanceDataReader as fdr
# ์›๋‹ฌ๋Ÿฌ ํ™˜์œจ, 1995๋…„~ํ˜„์žฌ
df = fdr.DataReader('USD/KRW', '1995-01-01', '2020-12-31')
df['Close'].plot()

png

# ์œ„์—”ํ™” ํ™˜์œจ, 1995๋…„~ํ˜„์žฌ
df = fdr.DataReader('CNY/KRW', '1995')
df['Close'].plot()

png

์ƒํ’ˆ์„ ๋ฌผ

์‹ฌ๋ณผ ์„ค๋ช…
NG ์ฒœ์—ฐ๊ฐ€์Šค ์„ ๋ฌผ (NYMEX)
GC ๊ธˆ ์„ ๋ฌผ (COMEX)
SI ์€ ์„ ๋ฌผ (COMEX)
HG ๊ตฌ๋ฆฌ ์„ ๋ฌผ (COMEX)
CL WTI์œ  ์„ ๋ฌผ (NYMEX)
import FinanceDataReader as fdr
# ์ฒœ์—ฐ๊ฐ€์Šค ์„ ๋ฌผ (NYMEX)
df = fdr.DataReader('NG', '2018')
df.tail()
Close Open High Low Volume Change
Date
2020ๅนด02ๆœˆ03ๆ—ฅ 1.819 1.852 1.880 1.814 163790.0 -0.0220
2020ๅนด02ๆœˆ04ๆ—ฅ 1.872 1.823 1.888 1.804 184040.0 0.0291
2020ๅนด02ๆœˆ05ๆ—ฅ 1.861 1.876 1.884 1.825 195460.0 -0.0059
2020ๅนด02ๆœˆ06ๆ—ฅ 1.862 1.865 1.906 1.832 186210.0 0.0005
2020ๅนด02ๆœˆ07ๆ—ฅ 1.863 1.869 1.877 1.843 0.0 0.0005
import FinanceDataReader as fdr
# WTI์œ  ์„ ๋ฌผ (NYMEX)
df = fdr.DataReader('CL', '2018')
df.tail()
Close Open High Low Volume Change
Date
2020ๅนด02ๆœˆ03ๆ—ฅ 50.11 51.01 51.97 49.80 876040.0 -0.0184
2020ๅนด02ๆœˆ04ๆ—ฅ 49.61 49.94 51.55 49.31 859360.0 -0.0100
2020ๅนด02ๆœˆ05ๆ—ฅ 50.75 49.51 51.88 49.47 887950.0 0.0230
2020ๅนด02ๆœˆ06ๆ—ฅ 50.95 51.17 52.20 50.24 750660.0 0.0039
2020ๅนด02ๆœˆ07ๆ—ฅ 50.91 51.44 51.45 50.81 0.0 -0.0008

์ฑ„๊ถŒ

ํ•œ๊ตญ

  • 'KR[๋…„๋„]YT=RR' ํ˜•์‹์œผ๋กœ ์กฐํ•ฉ (๊ฐ€๋Šฅ ๋…„๋„=1,2,3,4,5,10,20,30,50)
์‹ฌ๋ณผ ์„ค๋ช…
KR1YT=RR 1๋…„๋งŒ๊ธฐ ํ•œ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
KR3YT=RR 1๋…„๋งŒ๊ธฐ ํ•œ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
KR5YT=RR 5๋…„๋งŒ๊ธฐ ํ•œ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
KR10YT=RR 10๋…„๋งŒ๊ธฐ ํ•œ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 

๋ฏธ๊ตญ

  • 'US[๊ฐœ์›”]MT=RR' ํ˜•์‹์œผ๋กœ ์กฐํ•ฉ (๊ฐ€๋Šฅ ๊ฐœ์›”=1,3,6)
  • 'US[๋…„๋„]YT=RR' ํ˜•์‹์œผ๋กœ ์กฐํ•ฉ (๊ฐ€๋Šฅ ๋…„๋„=1,2,3,4,5,7,10,30)
์‹ฌ๋ณผ ์„ค๋ช…
US1MT=X 1๊ฐœ์›” ๋ฏธ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
US6MT=X 6๊ฐœ์›” ๋ฏธ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
US1YT=X 1๋…„๋งŒ๊ธฐ ๋ฏธ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
US5YT=X 5๋…„๋งŒ๊ธฐ ๋ฏธ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
US10YT=X 10๋…„๋งŒ๊ธฐ ๋ฏธ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
US30YT=X 30๋…„๋งŒ๊ธฐ ๋ฏธ๊ตญ ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
import FinanceDataReader as fdr
# 10๋…„๋งŒ๊ธฐ ๋ฏธ๊ตญ์ฑ„ ์ˆ˜์ต๋ฅ 
df = fdr.DataReader('US10YT=X', '2018')
df.tail()
Close Open High Low Change
Date
2020ๅนด02ๆœˆ03ๆ—ฅ 1.526 1.514 1.575 1.512 0.0071
2020ๅนด02ๆœˆ04ๆ—ฅ 1.603 1.520 1.618 1.517 0.0505
2020ๅนด02ๆœˆ05ๆ—ฅ 1.649 1.604 1.661 1.575 0.0287
2020ๅนด02ๆœˆ06ๆ—ฅ 1.644 1.649 1.684 1.633 -0.0030
2020ๅนด02ๆœˆ07ๆ—ฅ 1.613 1.649 1.649 1.609 -0.0190

์•”ํ˜ธํ™”ํ ๊ฐ€๊ฒฉ (KRW)

์•”ํ˜ธ ํ™”ํ ์›ํ™” ๊ฐ€๊ฒฉ (๋น—์ธ)

์‹ฌ๋ณผ ์„ค๋ช…
BTC/KRW ๋น„ํŠธ์ฝ”์ธ ์›ํ™” ๊ฐ€๊ฒฉ
ETH/KRW ์ด๋”๋ฆฌ์›€ ์›ํ™” ๊ฐ€๊ฒฉ
XRP/KRW ๋ฆฌํ”Œ ์›ํ™” ๊ฐ€๊ฒฉ
BCH/KRW ๋น„ํŠธ์ฝ”์ธ ์บ์‹œ ์›ํ™” ๊ฐ€๊ฒฉ
EOS/KRW ์ด์˜ค์Šค ์›ํ™” ๊ฐ€๊ฒฉ
LTC/KRW ๋ผ์ดํŠธ ์ฝ”์ธ ์›ํ™” ๊ฐ€๊ฒฉ
XLM/KRW ์Šคํ…”๋ผ ์›ํ™” ๊ฐ€๊ฒฉ

์•”ํ˜ธํ™”ํ ๊ฐ€๊ฒฉ (UDS)

์•”ํ˜ธ ํ™”ํ ๋‹ฌ๋Ÿฌํ™” ๊ฐ€๊ฒฉ (Bitfinex)

์‹ฌ๋ณผ ์„ค๋ช…
BTC/USD ๋น„ํŠธ์ฝ”์ธ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
ETH/USD ์ด๋”๋ฆฌ์›€ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
XRP/USD ๋ฆฌํ”Œ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
BCH/USD ๋น„ํŠธ์ฝ”์ธ ์บ์‹œ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
EOS/USD ์ด์˜ค์Šค ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
LTC/USD ๋ผ์ดํŠธ ์ฝ”์ธ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
XLM/USD ์Šคํ…”๋ผ ๋‹ฌ๋Ÿฌ ๊ฐ€๊ฒฉ
import FinanceDataReader as fdr
# ๋น„ํŠธ์ฝ”์ธ ์›ํ™” ๊ฐ€๊ฒฉ (๋น—์ธ), 2016๋…„~ํ˜„์žฌ
df = fdr.DataReader('BTC/KRW', '2016')
df['Close'].plot()

png

import FinanceDataReader as fdr
# ๋น„ํŠธ์ฝ”์ธ USD ๊ฐ€๊ฒฉ
df = fdr.DataReader('BTC/USD', '2016')
df['Close'].plot()

png

์ƒ์žฅํ์ง€ ์ข…๋ชฉ ์กฐํšŒ

ํ•œ๊ตญ๊ฑฐ๋ž˜์†Œ(KRX)์˜ ์ƒ์žฅํ์ง€ ์ „์ฒด ์ข…๋ชฉ ์กฐํšŒ๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค.

fdr.StockListing('KRX-DELISTING')

์กฐํšŒ๊ฒฐ๊ณผ ์ปฌ๋Ÿผ์˜ ๋‚ด์šฉ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

  • Symbol: ์ข…๋ชฉ์ฝ”๋“œ
  • Name: ์ข…๋ชฉ๋ช…
  • DelistingDate: ์ƒ์žฅํ์ง€์ผ
  • Reason: ์ƒ์žฅํ์ง€ ์‚ฌ์œ 
# KRX ์ƒ์žฅํ์ง€ ์ข…๋ชฉ ์ „์ฒด ๋ฆฌ์ŠคํŠธ
krx_delisting = fdr.StockListing('KRX-DELISTING')
krx_delisting
Symbol Name DelistingDate Reason
0 077280 ํ•œ์ปด์ง€์— ๋”” 2020ๅนด01ๆœˆ16ๆ—ฅ ํ”ผํก์ˆ˜ํ•ฉ๋ณ‘
1 265920 ํ•œํ™”์ˆ˜์„ฑ์ŠคํŒฉ 2020ๅนด01ๆœˆ15ๆ—ฅ ์ƒ์žฅ์˜ˆ๋น„์‹ฌ์‚ฌ ์ฒญ๊ตฌ์„œ ๋ฏธ์ œ์ถœ๋กœ ๊ด€๋ฆฌ์ข…๋ชฉ ์ง€์ •ํ›„ 1๊ฐœ์›” ์ด๋‚ด ๋™์‚ฌ์œ ๋ฅผ ๋ฏธํ•ด์†Œ
2 265480 ๋ฏธ๋ž˜์—์…‹๋Œ€์šฐ์ŠคํŒฉ1ํ˜ธ 2020ๅนด01ๆœˆ03ๆ—ฅ ์ƒ์žฅ์˜ˆ๋น„์‹ฌ์‚ฌ ์ฒญ๊ตฌ์„œ ๋ฏธ์ œ์ถœ๋กœ ๊ด€๋ฆฌ์ข…๋ชฉ ์ง€์ • ํ›„ 1๊ฐœ์›” ์ด๋‚ด ๋™ ์‚ฌ์œ  ๋ฏธํ•ด์†Œ
3 210610 ์†Œํ”„ํŠธ์บ ํ”„ 2019ๅนด12ๆœˆ30ๆ—ฅ ํ”ผํก์ˆ˜ํ•ฉ๋ณ‘
4 122050 ์•„์ด์—˜์‚ฌ์ด์–ธ์Šค 2019ๅนด12ๆœˆ27ๆ—ฅ ํ”ผํก์ˆ˜ํ•ฉ๋ณ‘
... ... ... ... ...
1534 034370 ๋Ÿญํ‚ค์†Œ์žฌ 1991ๅนด11ๆœˆ11ๆ—ฅ ํ•ด์‚ฐ ์‚ฌ์œ  ๋ฐœ์ƒ
1535 028460 ํƒœํ‰์–‘๊ฑด์„ค 1991ๅนด10ๆœˆ05ๆ—ฅ ์˜์—…ํ™œ๋™์ •์ง€ 6์›” ๊ณ„์†
1536 028450 ๊ธˆ์„ฑํˆฌ์ž๊ธˆ์œต 1991ๅนด09ๆœˆ02ๆ—ฅ ํ•ด์‚ฐ ์‚ฌ์œ  ๋ฐœ์ƒ
1537 028440 ์‚ผํ™” 1991ๅนด07ๆœˆ12ๆ—ฅ ๊ฐ์‚ฌ์˜๊ฒฌ ์˜๊ฒฌ๊ฑฐ์ ˆ
1538 029260 ๊ธˆ์„ฑ์ „๊ธฐ 1991ๅนด06ๆœˆ13ๆ—ฅ ํ•ด์‚ฐ ์‚ฌ์œ  ๋ฐœ์ƒ

1539 rows ร—ใฐใค 4 columns

KRX ์ƒ์žฅํ์ง€ ์ข…๋ชฉ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ

์ƒ์žฅํ์ง€๋œ ๊ฐœ๋ณ„ ์ข…๋ชฉ์˜ ๊ฐ€๊ฒฉ ๋ฐ์ดํ„ฐ๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. ์ผ๋ฐ˜ ์ข…๋ชฉ์˜ ๊ฐ€๊ฒฉ์กฐํšŒ์™€ ๋งˆ์ฐฌ๊ฐ€์ง€๋กœ fdr.DataReader()๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์กฐํšŒํ•˜๋˜ exchange ์˜ต์…˜ ๊ฐ’์„ 'KRX-DELISTING'๋กœ ์ง€์ •ํ•ฉ๋‹ˆ๋‹ค.

df = fdr.DataReader('036360', exchange='KRX-DELISTING')

๊ฒฐ๊ณผ๋กœ ๋ฐ˜ํ™˜๋˜๋Š” ๋ฐ์ดํ„ฐํ”„๋ ˆ์ž„์—๋Š” ์‹œ๊ฐ€,๊ณ ๊ฐ€,์ €๊ฐ€,์ข…๊ฐ€,๊ฑฐ๋ž˜๋Ÿ‰,์ „์ผ๋Œ€๋น„ ์™ธ์—๋„ ๊ธฐ์ค€๊ฐ€, ์ƒ์žฅ์ฃผ์‹์ˆ˜, ์•ก๋ฉด๊ฐ€, ๊ฑฐ๋ž˜์ •์ง€ ์—ฌ๋ถ€, ๊ด€๋ฆฌ์ข…๋ชฉ ์—ฌ๋ถ€ ๋“ฑ์˜ ๋ถ€๊ฐ€์ •๋ณด ์ปฌ๋Ÿผ์„ ๋” ํฌํ•จํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค.

๋ฐ˜ํ™˜ ๋ฐ์ดํ„ฐํ”„๋ ˆ์ž„์˜ ์ปฌ๋Ÿผ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

  • Open: ์‹œ๊ฐ€
  • High: ๊ณ ๊ฐ€
  • Low: ์ €๊ฐ€
  • Close: ์ข…๊ฐ€
  • Volume: ๊ฑฐ๋ž˜๋Ÿ‰
  • Change: ์ „์ผ๋Œ€๋น„ ๋“ฑ๋ฝ
  • Amount: ๊ฑฐ๋ž˜๋Œ€๊ธˆ
  • Stocks: ์ƒ์žฅ์ฃผ์‹์ˆ˜
  • FaceValue: ์•ก๋ฉด๊ฐ€
  • StandardPrice: ๊ธฐ์ค€๊ฐ€
  • StopOrder: ๊ฑฐ๋ž˜์ •์ง€ ์—ฌ๋ถ€(Y/N)
  • Issues: ๊ด€๋ฆฌ์ข…๋ชฉ ์—ฌ๋ถ€(Y/N)
# KRX delisting stock data ์ƒ์žฅํ์ง€ ์ข…๋ชฉ ๋ฐ์ดํ„ฐ (์ƒ์žฅ์ผ~์ƒ์žฅํ์ง€์ผ)
df = fdr.DataReader('036360', exchange='KRX-DELISTING')
df
Open High Low Close Volume Change Amount Stocks FaceValue StandardPrice StopOrder Issues
Date
2001ๅนด01ๆœˆ18ๆ—ฅ 3800 3800 3800 3800 905 1900 3439000 5833338 500 1900 N N
2001ๅนด01ๆœˆ19ๆ—ฅ 4250 4250 4250 4250 740605 450 3147571250 5833338 500 3800 N N
2001ๅนด01ๆœˆ22ๆ—ฅ 4760 4760 4760 4760 120128 510 571809280 5833338 500 4250 N N
2001ๅนด01ๆœˆ26ๆ—ฅ 5330 5330 5330 5330 8868 570 47266440 5833338 500 4760 N N
2001ๅนด01ๆœˆ29ๆ—ฅ 5960 5960 5960 5960 10422 630 62115120 5833338 500 5330 N N
... ... ... ... ... ... ... ... ... ... ... ... ...
2009ๅนด04ๆœˆ22ๆ—ฅ 15 15 15 15 2596815 5 39031215 43852794 500 20 N Y
2009ๅนด04ๆœˆ23ๆ—ฅ 15 15 10 10 3686592 5 39664090 43852794 500 15 N Y
2009ๅนด04ๆœˆ24ๆ—ฅ 10 10 5 10 2312778 0 22688460 43852794 500 10 N Y
2009ๅนด04ๆœˆ27ๆ—ฅ 5 10 5 5 4644295 5 28588310 43852794 500 10 N Y
2009ๅนด04ๆœˆ28ๆ—ฅ 5 5 5 5 9958363 0 49791815 43852794 500 5 N Y

2045 rows ร—ใฐใค 12 columns

Clone this wiki locally

AltStyle ใซใ‚ˆใฃใฆๅค‰ๆ›ใ•ใ‚ŒใŸใƒšใƒผใ‚ธ (->ใ‚ชใƒชใ‚ธใƒŠใƒซ) /