from quantrocket.license import set_license
from quantrocket.master import download_master_file, create_universe
import pandas as pd
from quantrocket.fundamental import collect_shortable_shares
set_license("xxxxxxxx")
download_master_file("securities.csv", exchanges=["NASDAQ"])
securities = pd.read_csv("securities.csv")
print(securities)
ConId Symbol Etf SecType PrimaryExchange Currency LocalSymbol \
0 265598 AAPL 0 STK NASDAQ USD AAPL
1 272093 MSFT 0 STK NASDAQ USD MSFT
TradingClass MarketName LongName ... UnderSecType
0 NMS NMS APPLE INC ... NaN
1 NMS NMS MICROSOFT CORP ... NaN
MarketRuleIds Strike Right ComboLegs \
0 26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,2... 0.0 NaN NaN
1 26,26,26,26,26,26,26,26,26,26,26,26,26,26,26,2... 0.0 NaN NaN
Cusip EvRule EvMultiplier Delisted DateDelisted
0 NaN NaN 0.0 0 NaN
1 NaN NaN 0.0 0 NaN
[2 rows x 37 columns]