please answer only the first question using Python Jupiter notebook
Data Analytics Programming Assignment 3 Please follow the instructions to complete the following Python programs. For each program, please also provide your own testing cases. Please complete them in either Jupter notebook or with .py file and submit your programs and running results. Using what we have learned in Numpy Module to analyze SP500.csv file with Numpy array operations. Please find answers to the following questions: the highest daily gain and its date, the highest daily loss and its date, 2the the most daily transaction volume and its date, a monthly report for year 2017-2018, which has monthly average open price, close price, transaction volume and gain/loss, and a query to find all of the months which have certain range of open prices 3 4 price, transaction volume and gain/loss from 1950 to 2018, and the most profitable year, every other five year report which has every five year average open price, close price, SP500 (1) Date Open High Low Close Adj Close Volume 1950-01-03 16.660000 16.660000 16.660000 16.660000 16.660000 1260000 1950-01-04 16.850000 16.850000 16.850000 16.850000 16.850000 1890000 1950-01-05 16.930000 16.930000 16.930000 16.930000 16.930000 2550000 1950-01-06 16.980000 16.980000 16.980000 16.980000 16.980000 2010000 1950-01-09 17.080000 17.080000 17.080000 17.080000 17.080000 2520000 1950-01-10 17.030001 17.030001 17.030001 17.030001 17.030001 2160000 1950-01-11 17.090000 17.090000 17.090000 17.090000 17.090000 2630000 1950-01-12 16.760000 16.760000 16.760000 16.760000 16.760000 2970000 1950-01-13 16.670000 16.670000 16.670000 16.670000 16.670000 3330000 1950-01-16 16.719999 16.719999 16.719999 16.719999 16.719999 1460000 1950-01-17 16.860001 16.860001 16.860001 16.860001 16.860001 1790000 1950-01-18 16.850000 16.850000 16.850000 16.850000 16.850000 1570000 1950-01-19 16.870001 16.870001 16.870001 16.870001 16.870001 11700000 1950-01-20 16.900000 16.900000 16.900000 16.900000 16.900000 1440000 1950-01-23 16.920000 16.920000 16.920000 16.920000 16.920000 1340000 1950-01-24 16.860001 16.860001 16.860001 16.860001 16.860001 1250000 1950-01-25 16.740000 16.740000 16.740000 16.740000 16.740000 1700000 1950-01-26 16.730000 16.730000 16.730000 16.730000 16.730000 1150000 1950-01-27 16.820000 16.820000 16.820000 16.820000 16.820000 1250000 1950-01-30 17.020000 17.020000 17.020000 17.020000 17.020000 1640000 1950-01-31 17.049999 17.049999 17.049999 17.049999 17.049999 1690000 1950-02-01 17.049999 17.049999 17.049999 17.049999 17.049999 1810000 1950-02-02 17.230000 17.230000 17.230000 17.230000 17.230000 2040000 1950-02-03 17.290001 17.290001 17.290001 17.290001 17.290001 2210000 1950-02-06 17.320000 17.320000 17.320000 17.320000 17.320000 1490000 1950-02-07 17.230000 17.230000 17.230000 17.230000 17.230000 1360000
