It takes too long to fetch market_cap data.

[noivan0]

I want to utilize market cap data, so the syntax for importing is

import FinanceDataReader as fdr
import pandas as pd
from yahooquery import Ticker
from tqdm import tqdm

def get_ticker():
    nasdaq = fdr.StockListing('NASDAQ')
    nyse = fdr.StockListing('NYSE')
    amex = fdr.StockListing('AMEX')

    df = pd.concat([nasdaq, nyse, amex])
    df1 = df.copy()
    df1 = df1.drop_duplicates('Symbol')
    
    return df1['Symbol']

tickers_all = get_ticker()
tickers = tickers_all.to_list()

symbol = Ticker(tickers)

market_caps = []

for ticker in tqdm(tickers):
    sym_detail = symbol.summary_detail[ticker]
    if isinstance(sym_detail, dict):
        market_cap = sym_detail.get('marketCap')
        market_caps.append(market_cap)
    else:
        market_caps.append(None)

I applied this approach, and I'm only getting about 50 tickers in 2 hours.
This is taking way too long, is there a quick way to improve this?

Is this a structural issue that can't be fixed?