File size: 708 Bytes
d53dc44 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | 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 bars_1d WHERE symbol='{sym}' 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:
print(f"Error {sym}: {e}")
print(",".join(selected))
|