#run as follows:

# python3 historical.py --dateStart=20200319 --dateEnd=20200324

#optional:

# python3 historical.py --dateStart=20200319 --dateEnd=20200324 --ticker=QQQ

import requests

import os

from datetime import datetime, timedelta

import pandas as pd

from pandas.tseries.holiday import get_calendar, HolidayCalendarFactory, GoodFriday

import time# as timecode

import mysql.connector

import sys

import telegram_send

import signal

import argparse

global polygon_api_key

global ticker

global con

global map

def signint_handler(a, b): # define the handler

exit()

def remap(map, s):

#print(item,val['name'])#,val['type'])

def as_date(string):

return value

def get_one_minute_polygon(dt, start_unix_time, unix_increment, ticker, polygon_api_key):

return None

#start timing loop for JUST logging

starttime = time.time()

#asyncio.set_event_loop_policy(uvloop.EventLoopPolicy())

signal.signal(signal.SIGINT, signint_handler) # assign the handler to the signal SIGINT

#error handlers for CTRL-C - done

parser = argparse.ArgumentParser(description='Parameters for historical ticker script.')

parser.add_argument('--ticker', metavar="ticker", help='Ticker symbol', default='QQQ', required=False)

parser.add_argument('--dateEnd', metavar="dateE", type=as_date, help='Ending Date', default=None, required=False)

parser.add_argument('--dateStart', metavar="dateS", type=as_date, help='Starting Date', default=None, required=False)

parser.add_argument('--resume', metavar="resume", type=bool, help='Resume Flag', default=True, required=False)

args = parser.parse_args()

ticker = args.ticker.lower()

dateStart = args.dateStart

dateEnd = args.dateEnd

resume = args.resume

tDelta = timedelta(days=1)

#without end date, use one day data

if dateEnd is None and dateStart is not None:

dateEnd=dateStart+Delta

if dateStart is not None:

dateStart=dateStart.strftime("%Y-%m-%d")

if dateEnd is not None:

dateEnd=dateEnd.strftime("%Y-%m-%d")

if dateEnd is None and dateStart is None:

dateEnd=datetime.now()

dateStart=dateEnd-tDelta

dateEnd=dateEnd.strftime("%Y%m%d %H:%M:%S")

dateStart=dateStart.strftime("%Y%m%d %H:%M:%S")

print ("Script running ticker:"+ticker)

if ticker.find(',')!=-1:

tickers = ticker.split(",")

print("Script can only support a single ticker at this time!")

exit()

else:

tickers = None

if dateStart is not None:

print(" Starting date:"+dateStart)

if dateEnd is not None:

print(" Ending date:"+dateEnd)

print(" Resuming:"+str(resume))

#print(tickers)

#exit()

os.environ['polygon_api_key'] = "jg0i3J_ZFD1_v4wBRQFEzp9NHDlYwHQff5_8_u"

polygon_api_key = os.environ.get("polygon_api_key", "my-api-key")

# dd=datetime(2020, 3, 25,4,0,0) #starting on date at 4am

# dd = dd.strftime("%Y-%m-%d %H:%M:%S") #start date as string

#calculate holidays

cal = get_calendar('USFederalHolidayCalendar') # Create calendar instance

cal.rules.pop(7) # Remove Veteran's Day rule

cal.rules.pop(6) # Remove Columbus Day rule

tradingCal = HolidayCalendarFactory('TradingCalendar', cal, GoodFriday)

#print (tradingCal.rules)

#new instance of class

cal1 = tradingCal()

holiday_dates = cal1.holidays(datetime(2020, 1, 1), datetime(2020, 12, 31))

dstart = datetime.strptime(dateStart, '%Y-%m-%d') #start market day at 4am

dend = datetime.strptime(dateEnd, '%Y-%m-%d') #start market day at 4am

date_rng = pd.bdate_range(datetime(dstart.year,dstart.month,dstart.day), datetime(dend.year,dend.month,dend.day), holidays=holiday_dates, freq='C', weekmask = None)

#print (date_rng)

#exit()

#iterate market business days:

index = 0

for d in date_rng:

index += 1

start = datetime.strptime(d.strftime("%Y-%m-%d 4:0:0"), '%Y-%m-%d %H:%M:%S') #start market day at 4am

unixtime_start = start.strftime('%s') #convert to unixtime

unixtime_end = int(unixtime_start) + 57600 #16 hours ahead to market close as 8pm

end = datetime.fromtimestamp(unixtime_end).strftime('%Y-%m-%d %H:%M:%S') #end date as string

ii = 0

for i in range(int(unixtime_start), int(unixtime_end)+60, 60): #step in 60-second increments, and inclusive of unix_end

ii += 1

print(unixtime_start, unixtime_end, index, ii, i)

get_one_minute_polygon(d, i, 60, ticker, polygon_api_key)

#exit()

exit()