Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BTC-USD Date Open High Low Close Adj Close Volume Log Returns Column1 1/10/2015 236.003998 334.169006 235.615997 314.165985 314.165985 95327950 1/11/2015 315.005005 495.562012 300.997009 377.321014 377.321014
BTC-USD
Date Open High Low Close Adj Close Volume Log Returns Column1 1/10/2015 236.003998 334.169006 235.615997 314.165985 314.165985 95327950 1/11/2015 315.005005 495.562012 300.997009 377.321014 377.321014 2177623396 18.31748603 Mean 6.758033437 1/12/2015 377.414001 469.102997 349.464996 430.566986 430.566986 2096250000 13.20065911 Standard Error 2.485056671 1/01/2016 430.721008 462.93399 354.914001 368.766998 368.766998 1990880304 -15.49379094 Median 6.298888947 1/02/2016 369.350006 448.04599 367.957001 437.696991 437.696991 1876238692 17.13618667 Mode #N/A 1/03/2016 437.916992 439.653015 394.035004 416.729004 416.729004 2332852776 -4.90907296 Standard Deviation 21.52122207 1/04/2016 416.76001 467.964996 415.830994 448.317993 448.317993 1811475204 7.30666464 Sample Variance 463.1629994 1/05/2016 448.484009 553.960022 437.389008 531.385986 531.385986 2234432796 16.99858747 Kurtosis 0.135186238 1/06/2016 531.106995 777.98999 525.635986 673.336975 673.336975 4749702740 23.67572490 Skewness 0.109784084 1/07/2016 672.515015 704.968018 611.833984 624.68103 624.68103 3454186204 -7.50047427 Range 98.11811881 1/08/2016 624.60199 626.119019 531.333984 575.471985 575.47198 2686220180 -8.20506199 Minimum 45.27387426 1/09/2016 575.546021 628.817993 570.810974 609.734985 609.734985 2004401400 5.78338644 Maximum 52.84424455 1/10/2016 609.929016 720.401978 609.479004 700.971985 700.971985 2115443796 13.94435100 Sum 506.8525078 1/11/2016 701.336975 756.237 678.156006 745.690979 745.690979 2635773092 6.1843355 Count 75 1/12/2016 746.046021 979.396973 746.046021 963.742981 963.742981 3556763800 25.65133647 1/01/2017 963.65802 1191.099976 755.755981 970.403015 970.403015 5143971692 0.68868227 1/02/2017 970.940979 1200.390015 946.690979 1179.969971 1179.969971 4282761200 19.55328042 1/03/2017 1180.040039 1280.310059 903.713013 1071.790039 1071.790039 10872455960 -9.61588055 1/04/2017 1071.709961 1347.910034 1061.089966 1347.890015 1347.890015 9757448112 22.92102336 1/05/2017 1348.300049 2763.709961 1348.300049 2286.409912 2286.409912 34261856864 52.84424455 1/06/2017: 7 2288.330078 2999.909912 2212.959961 2480.840088 2480.840088 44478140928 8.16143846 1/07/2017 2492.600098 2916.139893 1843.030029 2875.340088 2875.340088 32619956992 14.75737108 1/08/2017 2871.300049 4736.049805 2668.590088 4703.390137 4703.390137 63548016640 49.21125957 1/09/2017 4701.759766 4975.040039 2946.620117 4338.709961 4338.709961 55700949056 -8.07064945 1/10/2017 4341.049805 6470.430176 4164.049805 6468.399902 6468.399902 58009357952 39.93517077 1/11/2017 7446.830078 11517.40039 5519.009766 10233.59961 10233.59961 115000000000 45.87476185 1/12/2017 10198.59961 20089 9694.650391 14156.40039 14156.40039 410000000000 32.44904601 1/01/2018 14112.2002 2 17712.40039 9402.290039 10221.09961 10221.09961 416000000000 -32.57126733 1/02/2018 10237.29981 11958.5 6048.259766 10397.90039 10397.90039 230000000000 1.71497273 1/03/2018 10385 11704.09961 6683.930176 6973.529785 6973.529785 194000000000 -39.94823782 1/04/2018 7003.060059 9745.320313 6526.870117 9240.549805 9240.549805 197000000000 28.14798646 1/05/2018 9251.469727 9964.5 7090.6801 7494.169922 198000000000 -20.94760121 1/06/2018 7500.700195 7754.890137 5826.410156 6404 6404 130000000000 -15.72025794 1/07/2018 6411.680176 8424.269531 6136.419922 7780.439941 7780.439941 141000000000 19.46900891 1/08/2018 7769.040039 7769.040039 5971.049805 7037.580078 7037.580078 132000000000 -10.03485121 1/09/2018 7044.810059 7388.430176 6197.52002 6625.560059 6625.560059 130000000000 -6.03294667 1/10/2018 6619.850098 6965.060059 6236.470215 6317.609863 6317.609863 118000000000 -4.75939551 1/11/2018 6318.140137 6552.160156 3585.060059 4017.268555 4017.268555 158000000000 -45.27387426 1/12/2018 4024.464355 4309.377441 3191.303467 3742.700439 3742.700439 169000000000 -7.07948144 1/01/2019 3746.713379 4109.020996 3400.819824 3457.792725 3457.792725 167000000000 -7.91769486 1/02/2019 3460.547119 4210.641602 3391.023682 3854.7854 3854.7854 199000000000 10.86848928 1/03/2019 3853.75708 4296.806641 3733.749756 4105.404297 4105.404297 298000000000 6.29888895 1/04/2019 4105.362305 5642.044434 4096.901367 5350.72 5350.726563 445000000000 26.49281309 1/05/2019 5350.914551 9008.314453 5347.645996 8574.501953 8574.501953 724000000000 47.15605522 1/06/2019 8573.839844 13796.48926 7564.48877 10817.15527 10817.15527 676000000000 23.23404147 1/07/2019 10796.93066 13129.5293 9163.134766 10085.62793 10085.62793 676000000000 -7.00218916 1/08/2019 10077.44238 12273.82129 9421.629883 9630.664063 9630.664063 534000000000 -4.61592521 1/09/2019 9630.592773 10898.76172 7830.758789 8293.868164 8293.868164 481000000000 -14.94357148 1/10/2019 8299.720703 3 10021.74414 7446.98877 9199.584961 9199.584961 595000000000 10.36419038 1/11/2019 9193.992188 9505.051758 6617.166992 7569.629883 7569.629883 677000000000 -19.50141965 1/12/2019 7571.616211 7743.431641 6540.049316 7193.599121 7193.599121 634000000000 -5.09525540 1/01/2020 7194.89209 9553.125977 6914.996094 9350.529297 9350.529297 853000000000 26.22413314 1/02/2020 9346.357422 10457.62695 8492.932617 8599.508789 8599.508789 1160000000000 -8.37278669 1/03/2020 8599.758789 9167.695313 4106.980957 6438.644531 6438.644531 1290000000000 -28.93870427 1/04/2020 6437.319336 9440.650391 6202.373535 8658.553711 8658.553711 1160000000000 29.62296592 1/05/2020 8672.782227 7 9996.743164 8374.323242 9461.058594 9461.058594 1290000000000 8.86365783 1/06/2020 9463.605469 10199.56543 8975.525391 9137.993164 9137.993164 651000000000 -3.47434839 1/07/2020 9145.985352 11415.86426 8977.015625 11323.4668 11323.4668 546000000000 21.44364852 1/08/2020 11322.57031 12359.05664 11012.41504 11680.82031 11680.82031 708000000000 3.10709266 1/09/2020 11679.31641 12067.08106 9916.493164 10784.49121 10784.49121 1080000000000 -7.98391039 1/10/2020 10795.25488 14028.21387 10416.68945 13780.99512 13780.99512 1 1050000000000 24.51813748 1/11/2020 13780.99512 19749.26367 13243.16016 19625.83594 19625.83594 1090000000000 35.35563806 1/12/2020 19633.76953 29244.87695 17619.5332 29001.7207 29001.7207 1210000000000 39.05083043 1/01/2021 28994.00977 41946.73828 28722.75586 33114.35938 33114.35938 2150000000000 13.26118437 1/02/2021 33114.57813 58330.57031 32384.22852 45137.76953 45137.76953 2270000000000 30.97523515 1/03/2021 45159.50391 61683.86328 45115.09375 58918.83203 58918.83203 1680000000000 26.64414105 1/04/2021 58926.5625 64863.09766 47159.48438 57750.17578 8 57750.17578 1840000000000 -2.00343752 1/05/2021 57714.66406 59519.35547 30681.49609 37332.85547 37332.85547 1980000000000 -43.62526106 1/06/2021 37293.79297 41295.26953 28893.62109 35040.83594 35040.83594 1190000000000 -6.33596601 1/07/2021 35035.98438 42235.54688 29360.95508 41626.19531 41626.19531 819000000000 17.22155415 1/08/2021 41460.84375 50482.07813 37458.00391 47166.6875 47166.6875 1010000000000 12.49582061 1/09/2021 47099.77344 52853.76563 39787.60938 43790.89453 43790.89453 1100000000000 -7.42619618 1/10/2021 43816.74219 66930.39063 43320.02344 61318.95703 61318.95703 1150000000000 33.66631369 1/11/2021 61320.44922 68789.625 53569.76563 57005.42578 57005.42578 1050000000000 -7.29425928 1/12/2021 56907.96484 59041.68359 42874.61719 50822.19531 50822.19531 766000000000 -11.48132777 26/12/2021 50450.29688 50683.20313 49933.45703 49933.45703 49933.45703 19784943616 -1.76419151Date Open High Low Close Adj Close Volume Log Returns Column1 1/10/2015 0.734307 1.34505 0.420897 0.916627 0.91662 19815600 11.19440799 1/11/2015 0.920847 1.10642 0.725665 0.873119 0.873119 25989045 -4.86287702 Mean 1/12/2015 0.878316 1.04537 0.770488 0.933542 0.933542 14436832 6.69140958 Standard Error 4.24624819 1/01/2016 0.933712 2.83699 0.929835 2.30604 2.30604 99427369 90.43010928 Median 7.143413659 1/02/2016 6.64741 101.08721246 Mode #N/A 2.31969 2.11631 6.33699 6.33699 350388940 1/03/2016 6.31931 15.2571 6.30885 11.4035 11.4035 911491280 58.75164335 Standard Deviation 36.7735881 1/04/2016 11.4006 11.8504 .05898 8.81398 8.81398 503439580 25.75812285 Sample Variance 1352.296782 1/05/2016 8.77508 15.0482 8.43236 14.0773 14.0773 866285490 46.82244737 Kurtosi 0.641453121 1/06/2016 14.1098 21.522699 9.96364 12.4615 12.4615 1179208426 12.19196796 skewness 0.554358462 1/07/2016 12.4381 14.8989 9.57626 11.8759 11.8759 851472184 -4.81327548 Range 192.0437344 1/08/2016 11.8948 12.4578 8.20098 11.6724 11.6724 507070296 1.72840558 Minimum 76.87665724 1/09/2016 11.6705 14.4341 11.2524 13.2248 13.2248 347623070 12.48667741 Maximum 115.1670772 13.2032 13.531 9.56327 10.9982 10.9982 311770270 18.43622317 Sum 839.5805992 1/10/2016 1/11/2016 10.9578 11.2454 7.87573 8.58754 8.58754 263548890 24.74193076 Count 75 1/12/2016 8.60162 8.86133 5.97887 7.9691 7.9691 388060700 7.47407525 1/01/2017 7.98231 11.8909 7.98231 10.7275 10.7275 521748480 29.72389749 1/02/2017 10.7413 16.059401 10.5519 15.8172 15.8172 467166760 38.82874176 1/03/2017 15.8472 55.1147 15.5589 50.0373 50.0373 4324810304 115.16707718 1/04/2017 50.033699 79.021202 40.9011 79.021202 79.021202 3154319672 45.69474689 1/05/2017 79.321602 236.965 73.086601 230.66901 230.669006 14679954720 107.12676123 1/06/2017 230.886 414.75601 214.48 294.91599 294.915985 34410801184 24.57067107 1/07/2017 293.353 295.509 133.72301 203.871 203.871002 31034420096 -36.92030685 1/08/2017 204.688 388.74799 204.688 383.04 383.041992 33197513792 63.06571722 1/09/2017 383.46701 390.04401 195.035 301.465 301.464996 24310299968 -23.94907129 1/10/2017 301.547 349.345 277.57501 305.879 305.878998 13427328896 1.45356825 1/2017 308.64499 522.30701 294.54199 447.11401 447.114014 26957496832 37.96240346 1/12/2017 445.20902 881.94397 414.41101 756.73297 756.732971 79862276544 52.61968179 8 755.75702 1432.88 742.00403 1118.3101 1118.310059 164000000000 39.05635041 1/02/2018 1119.37 1161.35 574.41901 855.19898 855.198975 83393441152 -26.82397877 1/03/2018 856.01202 880.302 368.633 396.457 396.457001 53716179584 -76.87665724 1/04/2018 397.254 708.875 669.924 669.924011 60669918656 52.45967007 1/05/2018 670.46301 835.05701 512.552 577.64502 577.64502 81752720256 -14.82047618 1/06/2018 578.672 624.513 407.94699 455.17999 455.179993 55077550208 23.82665980 1/07/2018 455.242 513.43298 422.81 433.867 433.867004 52395320112 4.79548850 1/08/2018 433.86899 435.457 254.64999 283.004 283.003998 49073240000 42.72770200 1/09/2018 283.496 301.14401 170.257 232.84801 232.848007 55203910000 -19.50751145 1/10/2018 233.22 234.145 188.707 197.381 197.380997 44459810000 -16.52500543 1/11/2018 197.537 221.6519 101.77 113.17142 113.171417 59375107547 -55.62322220 1/12/2018 157.6687 82.829887 133.36 133.368256 72329895639 16.42105103 1/01/2019 133.41815 160.82489 103.33646 107.06101 107.061012 85054975141 -21.97152666 1/02/2019 107.14768 165.54962 102.93456 136.74625 136.746246 101000000000 24.47281118 1/03/2019 136.83624 149.61324 125.4027 141.5141 141.514099 139000000000 3.42723623 1/04/2019 141.46549 184.37785 140.73756 162.16603 162.166031 205000000000 13.62213414 1/05/2019 162.18655 287.20163 159.66022 268.1: 268.113556 314000000000 50.27899141 1/06/2019 268.43335 361.39868 229.25743 290.69598 290.695984 271000000000 8.08673854 1/07/2019 290.26849 318.22311 193.99042 218.65414 218.654144 250000000000 28.47867622 1/08/2019 218.5546 239.11591 167.07141 172.46979 172.469788 203000000000 23.72691512 1/09/2019 172.45841 222.87169 157.13033 179.87221 179.872208 223000000000 4.20245641 1/10/2019 180.20912 195.94251 157.46343 183.96692 183.966919 252000000000 2.25093102 1/11/2019 183.8037 193.54726 133.80234 152.53969 152.539688 253000000000 18.73311420 1/12/2019 152.49193 153.1554 119.78006 129.61086 129.610855 247000000000 16.28882732 1/2020 129.63066 186.26048 126.49002 180.16017 180.160172 328000000000 32.93097615 1/02/2020 180.11377 287.12369 179.74518 219.84851 219.848511 578000000000 19.90924231 1/03/2020 219.75269 249.97849 95.184303 133.59357 133.593567 499000000000 49.81366141 1/04/2020 133.61232 227.52969 129.73094 207.60205 207.602051 532000000000 44.08209221 1/05/2020 207.90173 244.04526 180.71834 230.97571 230.975708 506000000000 10.66895140 1/06/2020 230.86026 252.222 219.47267 226.315 226.315002 252000000000 2.03847018 1/07/2020 226.13458 348.61136 224.5445 345.55466 345.554657 251000000000 42.32229845 1/08/2020 345.79862 444.57776 343.58743 435.07974 435.079742 374000000000 23.03785017 1/09/2020 434.87445 487.21188 316.77435 359.93787 359.937866 518000000000 18.95979071 1/10/2020 360.30914 420.14166 334.54556 386.59033 386.590332 417000000000 7.14341366 1/11/2020 386.59033 621.1734 371.31274 614.84253 614.842529 487000000000 46.40006259 1/12/2020 615.07031 754.30322 532.99841 737.80341 737.803406 471000000000 18.23112170 1/01/2021 737.70837 1467.7849 718.1095 1314.9862 1314.986206 1180000000000 57.79040532 1/02/2021 1314.8552 2036.2865 1274.3578 1416.049 1416.04895 1010000000000 7.40443880 1/03/2021 1417.1511 1947.8378 1416.4161 1918.3621 1918.362061 731000000000 30.36011648 1/04/2021 1919.1572 2797.9724 1912.1785 2773.207 2773.207031 995000000000 36.85326947 1/05/2021 2772.8384 4362.3506 1737.4688 2714.9453 2714.945313 1510000000000 -2.12326128 1/06/2021 2707.5605 2891.2549 1707.6006 2274.5476 2274.547607 814000000000 17.69906321 1/07/2021 2274.3975 2551.1611 1722.0508 2536.21 2536.209961 592000000000 10.8889646 1/08/2021 2530.4629 3466.9922 2449.3535 3433.7327 3433.732666 703000000000 30.29770849 1/09/2021 3430.7625 4022.4692 2676.4075 3001.679 3001.678955 654000000000 -13.44761265 1/10/2021 3001.1294 4455.7354 2978.6543 4288.0742 4288.074219 575000000000 35.66659484 1/11/2021 4288.2173 4891.7046 3933.5066 4631.479 4631.479004 574000000000 7.70385242 1/12/2021 4623.6797 4780.7324 3525.4941 4047.9829 4047.98291 527000000000 13.46575463 26/12/2021 4093.2805 4104.7388 4058.9739 4059.2412 4059.241211 11723804672 0.27773522Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started