kychanbp

import awswrangler as wr
import pandas as pd
from pandas import json_normalize
from pandas.tseries.offsets import MonthEnd
import sqlalchemy as sql
import json
import logging
from datetime import datetime

import pdb

kychanbp

{ "data":[{"s":"NASDAQ:MSFT","d":["MSFT",184.68,0.58823529,1.08,0.49090909,30601603,1400509699200,30.57197569,6.0629,144000,"Technology Services","MICROSOFT CORP","MSFT","stock","common","delayed_streaming_900",100,1,"false",0]},{"s":"NASDAQ:AAPL","d":["AAPL",310.13,2.10377296,6.39,0.6030303,33511985,1344208864200,23.81153967,12.8615,137000,"Electronic Technology","APPLE INC","AAPL","stock","common","delayed_streaming_900",100,1,"false",0]},{"s":"NASDAQ:AMZN","d":["AMZN",2379.61,0.50684023,12,0.37575758,3211228,1186892357360,113.09878666,21.3147,798000,"Retail Trade","AMAZON COM INC","AMZN","stock","common","delayed_streaming_900",100,1,"false",0]},{"s":"NASDAQ:GOOG","d":["GOOG",1388.37,1.15186221,15.81,0.46666667,1388068,947728422720,27.69569762,49.9867,118899,"Technology Services","ALPHABET INC","GOOG","stock","common","delayed_streaming_900",100,1,"false",0]},{"s":"NASDAQ:GOOGL","d":["GOOGL",1384.34,1.0998481,15.06,0.42121212,1666487,944977466171,27.62951334,49.9867,118899,"Technology Services","ALPHABET I

kychanbp

import requests
from bs4 import BeautifulSoup
import re
from zipfile import ZipFile
import configparser
import os
import shutil
import boto3
import time
import logging

kychanbp