Stock Prices

 Creation & Upload:

import yfinance as yf

import csv

from google.cloud import datastore, storage

from datetime import datetime

tsla = yf.Ticker("TSLA")

historical_data = tsla.history(start='2023-01-01', end='2023-06-16')

csv_file_name = 'tesla_stock.csv'

with open(csv_file_name, 'w', newline='') as csv_file:

    writer = csv.writer(csv_file)

    

    writer.writerow(["Date", "Price", "Volume"])

    

    for index, row in historical_data.iterrows():

        date = index

        price = row['Close']

        volume = row['Volume']

        

        writer.writerow([date, price, volume])

storage_client = storage.Client()

bucket_name = 'sentiment-files'

bucket = storage_client.bucket(bucket_name)

blob = bucket.blob(csv_file_name)

blob.upload_from_filename(csv_file_name)

script_file_name = 'creation&upload.py'

blob = bucket.blob(script_file_name)

blob.upload_from_filename(script_file_name)

client = datastore.Client()

kind = 'tesla-data'

for index, row in historical_data.iterrows():

    date = index

    price = row['Close']

    volume = row['Volume']

    entity = datastore.Entity(client.key(kind))

    entity.update({

        "date": date,

        "price": price,

        "volume": volume

    })

    client.put(entity)

print("Data uploaded to Google Cloud Datastore and files uploaded to Google Cloud Storage.")

------------------

deletion:

from google.cloud import storage

def delete_file(bucket_name, file_name):

    storage_client = storage.Client()

    bucket = storage_client.bucket(bucket_name)

    blob = bucket.blob(file_name)

    blob.delete()

    print(f"File '{file_name}' deleted successfully from bucket '{bucket_name}'.")

bucket_name = 'sentiment-files'

file_name = 'tesla_stock.csv'

delete_file(bucket_name, file_name)