<jupyter_start><jupyter_text>Batch Process Stock's Additional Info<jupyter_code>from datetime import datetime
import pandas as pd
import pymysql
from yitian.datasource import *

# Set up cloud sql connections
password = ''
database = EQUITY
connection = pymysql.connect(host=PRIVATE_HOST,
                             user=USER,
                             password=password,
                             db=database)
# Grab tickers from dim tables
nasdaq_pd = pd.read_sql("SELECT * FROM quant.nasdaq", connection)
nasdaq_tickers = nasdaq_pd.symbol

nyse_pd = pd.read_sql("SELECT * FROM quant.nyse", connection)
nyse_tickers = nyse_pd.symbol

tickers = nasdaq_tickers
# ETL stock additional info into Cloud Storage and mySQL

for t in tickers:
    
    ticker = t
    print(ticker)
    
    %run -i 'notebooks/etl/yfinance/add_info_etl.py'<jupyter_output><empty_output>
StarcoderdataJupyterStructuredCleanDedup