import pandas as pd

# The is an alternative
# from google.cloud import firestore
# db = firestore.Client()
# db = firestore.Client.from_service_account_json("/Users/your.name/yada-yada-firebase-adminsdk.json")

import firebase_admin
from firebase_admin import credentials
from firebase_admin import firestore

cred = credentials.Certificate('/Users/your.name/yada-yada-firebase-adminsdk.json')

app = firebase_admin.initialize_app(cred)

db = firestore.client()

df = pd.DataFrame()

for indices, row in df.iterrows():
        doc_ref = db.collection("stocks").document(row['Symbol'])

        doc_ref.set({
            "Symbol": row['Symbol'],
            "Name": row['Name'],
            "Sector": row['Sector']
        })