import sqlite3
import pandas as pd

universe = "AAPL,MSFT,NVDA,AMD,META,GOOG,TSLA,AMZN,JPM,GS,V,JNJ,PFE,UNH,XOM,CVX,WMT,KO,CAT,GE,DIS,NFLX,SPY,QQQ,IWM,INTC,BAC,SOFI,PLTR,UBER,SHOP,PYPL,MA,CSCO,PEP,MRK,BRK.B,LLY,AVGO,HD,PG,COST,ABBV,CRM,MCD,LIN,IONQ,NBIS,VRT".split(",")

conn = sqlite3.connect('data/market_data.db')
selected = []
for sym in universe:
    try:
        df = pd.read_sql_query(f"SELECT close FROM '{sym}_1Day' ORDER BY timestamp DESC LIMIT 1", conn)
        if not df.empty:
            price = df['close'].iloc[0]
            if 50 <= price <= 140:
                selected.append(sym)
    except Exception as e:
        pass

print(",".join(selected))