search

yoshikouki / dividend-portal

1 stars 1 forks source link

取得できるシンボルについて #43

Open yoshikouki opened 3 years ago

yoshikouki commented 3 years ago

企業数

2021-08-01時点において、エンドポイントによるFMPで取得できる企業数の差は少ない https://financialmodelingprep.com/developer/docs#Symbols-List https://financialmodelingprep.com/developer/docs#Tradable-Symbols-List

irb(main):040:0> Client::Fmp.get_symbols_list.count
=> 23747
irb(main):039:0> Client::Fmp.get_tradable_symbols_list.count
=> 23745

取得した情報をDBに登録し、GROUP BYしてカウントした結果

exchange count
LSE 2948
New York Stock Exchange 2804
Nasdaq Capital Market 2660
HKSE 2555
Nasdaq Global Select 2327
NSE 1591
Toronto 1532
New York Stock Exchange Arca 1253
Other OTC 961
Nasdaq Global Market 884
XETRA 858
Paris 722
NYSEArca 410
NYSE American 298
Nasdaq 255
SIX 235
BATS Exchange 232
BATS 216
MCX 215
OSE 154
Brussels 149
Amsterdam 120
NMS 73
Lisbon 41
Oslo 36
Irish 34
NCM 31
Sao Paolo 24
TSXV 15
NASDAQ Global Market 13
Frankfurt 10
YHD 9
Taiwan 7
Canadian Sec 7
Copenhagen 6
Stockholm 6
NASDAQ 6
HKG 5
Helsinki 4
Athens 3
Johannesburg 3
Istanbul 3
Shenzhen 3
Vienna 2
Shanghai 2
Swiss 2
Milan 2
NZSE 2
MCE 2
Tokyo 2
EURONEXT 2
KOSDAQ 1
OSL 1
Jakarta 1
SAT 1
Hamburg 1
OTC 1
São Paulo 1
AMEX 1
FGI 1
Santiago 1
Mexico 1
ASE 1
KSE 1
SQL ``` SELECT exchange, count(exchange) FROM companies GROUP BY exchange ORDER BY count DESC; ```

ETF

irb(main):041:0> Client::Fmp.get_etf_list.count
=> 2976