spacepaste

Paste details

reply | raw

  1.  
  2. import datetime as dt
  3. import matplotlib.pyplot as plt
  4. from matplotlib import style
  5. import pandas as pd
  6. import pandas_datareader.data as web
  7. style.use('ggplot')
  9. df = pd.read_csv('tsla.csv', parse_dates=True, index_col=0)
  10. df['100ma'] = df['close_price'].rolling(window=100, min_periods=0).mean()
  11. print(df.head())
  13. ax1 = plt.subplot2grid((6,1), (0,0), rowspan=5, colspan=1)
  14. ax2 = plt.subplot2grid((6,1), (5,0), rowspan=1, colspan=1, sharex=ax1)
  16. ax1.plot(df.index, df['close_price'])
  17. ax1.plot(df.index, df['100ma'])
  18. ax2.bar(df.index, df['volume'])
  20. plt.show()
  27. ##################################
  28. ##################################
  29. ##################################
  30. ##################################
  31. ##################################
  35. symbol,begins_at,close_price,high_price,low_price,open_price,volume
  36. TSLA,2018-01-08,336.410000,337.019900,315.500000,316.000000,9859435
  37. TSLA,2018-01-09,333.690000,338.800000,327.405000,335.160000,7146631
  38. TSLA,2018-01-10,334.800000,337.000000,330.000000,332.200000,4309926
  39. TSLA,2018-01-11,337.950000,344.809900,333.260000,335.240000,6645484
  40. TSLA,2018-01-12,336.220000,340.410000,333.670000,338.630000,4825059
  41. TSLA,2018-01-16,340.060000,345.000000,334.800000,337.540000,6474251
  42. TSLA,2018-01-17,347.160000,349.000000,339.750000,340.470000,7103505
  43. TSLA,2018-01-18,344.570000,352.300000,343.740000,345.670000,5685845
  44. TSLA,2018-01-19,350.020000,350.589900,342.600000,345.000000,4888303
  45. TSLA,2018-01-22,351.560000,357.830000,349.200000,349.400000,6210360
  46. TSLA,2018-01-23,352.790000,360.500000,351.000000,360.000000,5465414
  47. TSLA,2018-01-24,345.890000,354.750000,343.520000,354.580000,5287478
  48. TSLA,2018-01-25,337.640000,349.200000,336.400000,348.270000,6740303
  49. TSLA,2018-01-26,342.850000,344.000000,335.710000,341.500000,4539356
  50. TSLA,2018-01-29,349.530000,350.850000,338.280000,339.850000,4747149
  51. TSLA,2018-01-30,345.820000,348.270000,342.170000,345.140000,4717700
  52. TSLA,2018-01-31,354.310000,356.190000,345.190000,347.510000,6214069
  53. TSLA,2018-02-01,349.250000,359.660000,348.630000,351.000000,4197687
  54. TSLA,2018-02-02,343.750000,351.950000,340.510000,348.440000,3704836
  55. TSLA,2018-02-05,333.130000,344.470000,333.000000,337.970000,4464147
  56. TSLA,2018-02-06,333.970000,336.220000,323.500000,325.210000,5088438
  57. TSLA,2018-02-07,345.000000,346.000000,335.660000,338.990000,6969239
  58. TSLA,2018-02-08,315.230000,348.620000,314.600000,343.310000,10314573
  59. TSLA,2018-02-09,310.420000,320.984500,294.760000,319.930000,12933721
  60. TSLA,2018-02-12,315.730000,318.080000,306.250000,316.130000,6227822
  61. TSLA,2018-02-13,323.660000,324.190000,312.510500,315.020000,4560231
  62. TSLA,2018-02-14,322.310000,326.170000,318.520000,320.840000,3950743
  63. TSLA,2018-02-15,334.065000,334.120000,322.400000,324.500000,5912917
  64. TSLA,2018-02-16,335.490000,343.120000,331.640000,332.500000,5642637
  65. TSLA,2018-02-20,334.770000,340.840000,331.500000,334.470000,4009435
  66. TSLA,2018-02-21,333.300000,339.692900,333.170000,336.030000,3219649
  67. TSLA,2018-02-22,346.170000,347.440000,334.750100,335.530000,6969808
  68. TSLA,2018-02-23,352.050000,354.990000,347.100000,347.830000,5817387
  69. TSLA,2018-02-26,357.420000,359.000000,352.355000,353.500000,4339985
  70. TSLA,2018-02-27,350.990000,359.990000,350.010000,356.250000,4797419
  71. TSLA,2018-02-28,343.060000,355.240000,342.220000,352.570000,6069658
  72. TSLA,2018-03-01,330.930000,348.670000,330.070000,345.010000,6885601
  73. TSLA,2018-03-02,335.120000,335.220000,322.970000,326.980000,5092829
  74. TSLA,2018-03-05,333.350000,337.750000,329.292900,332.390000,3823769
  75. TSLA,2018-03-06,328.200000,336.370000,327.030000,333.750000,4285744
  76. TSLA,2018-03-07,332.300000,332.500000,321.740000,325.440000,5007297
  77. TSLA,2018-03-08,329.100000,333.300000,326.274000,332.860000,3566244
  78. TSLA,2018-03-09,327.170000,328.490000,322.370000,324.100000,5506764
  79. TSLA,2018-03-12,345.510000,347.210000,326.500000,328.610000,8264035
  80. TSLA,2018-03-13,341.840000,345.120000,336.263500,344.920000,5965805
  81. TSLA,2018-03-14,326.630000,339.810000,323.930000,336.760000,7967370
  82. TSLA,2018-03-15,325.600000,332.850000,321.100000,329.380000,6564801
  83. TSLA,2018-03-16,321.350000,327.400000,319.070000,322.931400,6117279
  84. TSLA,2018-03-19,313.560000,320.750000,309.670000,316.500000,7484294
  85. TSLA,2018-03-20,310.550000,316.250000,308.760000,314.870000,4764293
  86. TSLA,2018-03-21,316.530000,322.440000,310.190000,310.250000,5958411
  87. TSLA,2018-03-22,309.100000,318.820000,308.180000,313.890000,4939771
  88. TSLA,2018-03-23,301.540000,311.610000,300.450000,311.250000,6654899
  89. TSLA,2018-03-26,304.180000,307.590000,291.360000,307.340000,8375175
  90. TSLA,2018-03-27,279.180000,304.270000,277.180000,304.000000,13872029
  91. TSLA,2018-03-28,257.780000,268.680000,252.100000,264.580000,21001437
  92. TSLA,2018-03-29,266.130000,270.959900,248.210000,256.490000,15170749
  93. TSLA,2018-04-02,252.480000,260.331800,244.590100,256.260000,16113968
  94. TSLA,2018-04-03,267.530000,273.350000,254.490000,269.820000,18844384
  95. TSLA,2018-04-04,286.940000,288.370000,252.000000,252.780000,19896746
  96. TSLA,2018-04-05,305.720000,306.260000,288.200000,289.340000,19121101
  97. TSLA,2018-04-06,299.300000,309.280000,295.500000,301.000000,13520286
  98. TSLA,2018-04-09,289.660000,309.500000,289.210000,300.370000,10249805
  99. TSLA,2018-04-10,304.700000,307.100000,293.680000,298.970000,11024259
  100. TSLA,2018-04-11,300.930000,308.980000,299.660000,300.740300,7482945
  101. TSLA,2018-04-12,294.080000,303.950000,293.680000,302.320000,7608769
  102. TSLA,2018-04-13,300.340000,303.949900,295.980000,303.600000,7327223
  103. TSLA,2018-04-16,291.210000,299.660000,289.010000,299.000000,6338488
  104. TSLA,2018-04-17,287.690000,292.170000,282.510000,288.870000,7000023
  105. TSLA,2018-04-18,293.350000,300.240000,288.160000,291.080000,6557700
  106. TSLA,2018-04-19,300.080000,301.010000,288.550000,291.080000,6090599
  107. TSLA,2018-04-20,290.240000,299.980000,289.750000,295.170000,5627928
  108. TSLA,2018-04-23,283.370000,291.620000,282.330000,291.290000,4893378
  109. TSLA,2018-04-24,283.460000,287.090000,278.460000,285.000000,5685308
  110. TSLA,2018-04-25,280.690000,285.160000,277.250000,283.500000,4013574
  111. TSLA,2018-04-26,285.480000,285.790000,276.500000,278.750000,4356013
  112. TSLA,2018-04-27,294.075000,294.470000,283.830000,285.370000,4364626
  113. TSLA,2018-04-30,293.900000,298.730000,292.500000,293.610000,4228172
  114. TSLA,2018-05-01,299.920000,300.820000,293.220000,293.510000,4625603
  115. TSLA,2018-05-02,301.150000,306.850000,297.784400,298.570000,8970370
  116. TSLA,2018-05-03,284.450000,288.040000,275.230000,278.790000,17352130
  117. TSLA,2018-05-04,294.090000,296.860000,279.520000,283.000000,8569354
  118. TSLA,2018-05-07,302.770000,305.958800,295.170000,297.500000,8678224
  119. TSLA,2018-05-08,301.970000,307.750000,299.000000,300.795300,5930000
  120. TSLA,2018-05-09,306.850000,307.010000,300.050000,300.410000,5727365
  121. TSLA,2018-05-10,305.020000,312.990000,304.111900,307.499700,5651561
  122. TSLA,2018-05-11,301.060000,308.880000,299.080000,307.700000,4679649
  123. TSLA,2018-05-14,291.970000,304.940000,291.620000,303.320000,7286804
  124. TSLA,2018-05-15,284.180000,286.960000,280.500000,285.010000,9519173
  125. TSLA,2018-05-16,286.480000,288.810000,281.560000,283.830000,5674019
  126. TSLA,2018-05-17,284.540000,289.187300,283.970000,285.900000,4420612
  127. TSLA,2018-05-18,276.820000,284.650000,274.000000,284.650000,7251887
  128. TSLA,2018-05-21,284.490000,291.490000,281.300000,281.330000,9182571
  129. TSLA,2018-05-22,275.010000,288.000000,273.422000,287.762000,8945756
  130. TSLA,2018-05-23,279.070000,279.909900,274.000000,277.760000,5985053
  131. TSLA,2018-05-24,277.850000,281.110000,274.890000,278.400000,4176708
  132. TSLA,2018-05-25,278.850000,279.640000,275.610000,277.625200,3875082
  133. TSLA,2018-05-29,283.760000,286.500000,276.150000,278.510000,5666640
  134. TSLA,2018-05-30,291.720000,295.005000,281.600000,283.290000,7489686
  135. TSLA,2018-05-31,284.730000,290.370000,282.930000,287.210000,5919721
  136. TSLA,2018-06-01,291.820000,291.950000,283.839000,285.860000,5424386
  137. TSLA,2018-06-04,296.740000,299.000000,293.548000,294.340000,4797810
  138. TSLA,2018-06-05,291.130000,297.800000,286.740000,297.700000,5995157
  139. TSLA,2018-06-06,319.500000,322.170000,297.480000,300.500000,18767269
  140. TSLA,2018-06-07,316.090000,330.000000,313.580000,316.150000,14345271
  141. TSLA,2018-06-08,317.660000,324.480000,317.150000,319.000000,8205202
  142. TSLA,2018-06-11,332.100000,334.660000,322.500000,322.510000,13183473
  143. TSLA,2018-06-12,342.770000,354.970000,338.000000,344.700000,22347403
  144. TSLA,2018-06-13,344.780000,347.200000,339.800000,346.706000,9469804
  145. TSLA,2018-06-14,357.720000,358.750000,346.600000,347.630000,10981023
  146. TSLA,2018-06-15,358.170000,364.670000,351.250000,353.840000,10848254
  147. TSLA,2018-06-18,370.830000,373.730000,354.500000,355.400000,12073226
  148. TSLA,2018-06-19,352.550000,370.000000,346.250000,365.160000,12761903
  149. TSLA,2018-06-20,362.220000,364.380000,352.000000,358.040000,8383656
  150. TSLA,2018-06-21,347.510000,366.213900,346.270000,362.000000,7967145
  151. TSLA,2018-06-22,333.630000,352.250000,332.000000,351.540000,10266059
  152. TSLA,2018-06-25,333.010000,338.470000,327.500000,330.120000,6931304
  153. TSLA,2018-06-26,342.000000,343.550000,325.799000,336.054000,7452487
  154. TSLA,2018-06-27,344.500000,350.790000,339.500000,345.000000,8333727
  155. TSLA,2018-06-28,349.930000,357.020000,346.110000,348.660000,8398005
  156. TSLA,2018-06-29,342.950000,353.860000,342.410000,353.330000,6492396
  157. TSLA,2018-07-02,335.070000,364.780000,329.850000,360.070000,18758031
  158. TSLA,2018-07-03,310.860000,332.490000,309.690000,331.750000,12282638
  159. TSLA,2018-07-05,309.160000,314.390000,296.220000,313.760000,17476374
  160. TSLA,2018-07-06,308.900000,312.070000,302.000000,304.954500,8865451
  161. TSLA,2018-07-09,318.510000,318.520000,308.000000,311.990000,7596753
  162. TSLA,2018-07-10,322.470000,327.677100,319.200000,324.560000,9471498
  163. TSLA,2018-07-11,318.960000,321.940000,315.070000,315.800000,4884076
  164. TSLA,2018-07-12,316.710000,323.230000,312.770000,321.430000,5721166
  165. TSLA,2018-07-13,318.870000,319.584900,309.250000,315.580000,5875770
  166. TSLA,2018-07-16,310.100000,315.160000,306.250000,311.710000,7818655
  167. TSLA,2018-07-17,322.690000,324.740000,308.500000,308.810000,6996232
  168. TSLA,2018-07-18,323.850000,325.500000,316.250000,325.000000,5624211
  169. TSLA,2018-07-19,320.230000,323.540000,314.010000,316.330000,5915345
  170. TSLA,2018-07-20,313.580000,323.240000,311.709300,321.230000,5166547
  171. TSLA,2018-07-23,303.200000,305.500000,292.860100,301.840000,10992947
  172. TSLA,2018-07-24,297.430000,307.717100,292.545200,304.420900,9590784
  173. TSLA,2018-07-25,308.740000,309.620000,294.502500,296.740000,7094180
  174. TSLA,2018-07-26,306.650000,310.700000,303.641100,304.850000,4630522
  175. TSLA,2018-07-27,297.180000,307.693300,295.340400,307.250000,5703326
  176. TSLA,2018-07-30,290.170000,296.100000,286.130000,295.900000,6814072
  177. TSLA,2018-07-31,298.140000,298.320000,289.070000,292.250000,5079854
  178. TSLA,2018-08-01,300.840000,303.000000,293.000000,297.990000,10129430
  179. TSLA,2018-08-02,349.540000,349.990000,323.160000,328.440000,23214962
  180. TSLA,2018-08-03,348.170000,355.000000,342.530000,347.810000,13656486
  181. TSLA,2018-08-06,341.990000,354.980000,341.820000,345.460000,8564331
  182. TSLA,2018-08-07,379.570000,387.460000,339.150100,343.840000,30875768
  183. TSLA,2018-08-08,370.340000,382.640000,367.120000,369.090000,24571163
  184. TSLA,2018-08-09,352.450000,367.010000,345.730000,365.550000,17183811
  185. TSLA,2018-08-10,355.490000,360.000000,346.000000,354.000000,11552044
  186. TSLA,2018-08-13,356.410000,363.190000,349.020000,361.130000,10463881
  187. TSLA,2018-08-14,347.640000,359.199500,347.100000,358.450000,6986427
  188. TSLA,2018-08-15,338.690000,344.490000,332.140000,341.905900,9101386
  189. TSLA,2018-08-16,335.450000,342.280000,333.820000,339.910000,6064033
  190. TSLA,2018-08-17,305.500000,326.770000,303.530000,323.500000,18958612
  191. TSLA,2018-08-20,308.440000,308.500000,288.200000,291.703500,17402335
  192. TSLA,2018-08-21,321.900000,324.790000,309.000000,310.610000,13172230
  193. TSLA,2018-08-22,321.640000,323.880000,314.670000,320.870000,5945955
  194. TSLA,2018-08-23,320.100000,327.320000,318.100000,319.140000,5147286
  195. TSLA,2018-08-24,322.820000,323.850000,319.400000,320.700000,3602564
  196. TSLA,2018-08-27,319.270000,322.435000,308.810000,318.000000,13079288
  197. TSLA,2018-08-28,311.860000,318.880000,311.190000,318.410000,7649091
  198. TSLA,2018-08-29,305.010000,311.850000,303.690000,310.270000,7447392
  199. TSLA,2018-08-30,303.150000,304.600000,297.720000,302.260000,7216706
  200. TSLA,2018-08-31,301.660000,305.308200,298.600000,302.000000,5375104
  201. TSLA,2018-09-04,288.950000,298.190000,288.000000,296.940000,8350469
  202. TSLA,2018-09-05,280.740000,286.780000,277.180000,285.050000,7720821
  203. TSLA,2018-09-06,280.950000,291.170000,278.880000,284.800000,7480760
  204. TSLA,2018-09-07,263.240000,268.350000,252.254800,260.100000,22491931
  205. TSLA,2018-09-10,285.500000,286.030000,271.000000,273.260000,14283528
  206. TSLA,2018-09-11,279.440000,282.000000,273.550000,279.470000,9169989
  207. TSLA,2018-09-12,290.540000,292.500000,278.646300,281.440000,10015427
  208. TSLA,2018-09-13,289.460000,295.000000,285.180000,288.020000,6340336
  209. TSLA,2018-09-14,295.200000,297.325600,286.520000,288.760000,6765612
  210. TSLA,2018-09-17,294.840000,300.870000,288.130000,290.040000,6887577
  211. TSLA,2018-09-18,284.960000,302.640000,275.500000,296.690000,16547522
  212. TSLA,2018-09-19,299.020000,300.000000,280.500000,280.510000,8294917
  213. TSLA,2018-09-20,298.330000,305.980000,293.330000,303.560000,7349422
  214. TSLA,2018-09-21,299.100000,300.580000,295.370000,297.700000,5050478
  215. TSLA,2018-09-24,299.680000,302.999300,293.580000,298.480000,4842961
  216. TSLA,2018-09-25,300.990000,304.600000,296.500000,300.000000,4481729
  217. TSLA,2018-09-26,309.580000,313.890000,301.109300,301.910000,7843216
  218. TSLA,2018-09-27,307.520000,314.960000,306.910000,312.900000,8509084
  219. TSLA,2018-09-28,264.770000,278.000000,260.555000,270.260000,33649694
  220. TSLA,2018-10-01,310.700000,311.440000,301.050000,305.770000,21777597
  221. TSLA,2018-10-02,301.020000,316.840000,299.150000,313.950000,11743511
  222. TSLA,2018-10-03,294.800000,304.600000,291.570000,303.330000,7994988
  223. TSLA,2018-10-04,281.830000,294.000000,277.670000,293.950000,9814212
  224. TSLA,2018-10-05,261.950000,274.880000,260.000000,274.650000,17944537
  225. TSLA,2018-10-08,250.560000,267.759900,249.000000,264.520000,13472653
  226. TSLA,2018-10-09,262.800000,266.770000,253.300000,255.250000,12060574
  227. TSLA,2018-10-10,256.880000,265.510000,247.770000,264.610000,12815278
  228. TSLA,2018-10-11,252.230000,262.250000,249.030000,257.530000,8167738
  229. TSLA,2018-10-12,258.780000,261.990000,252.010000,261.000000,7201404
  230. TSLA,2018-10-15,259.590000,263.280000,254.536700,259.060000,6199965
  231. TSLA,2018-10-16,276.590000,277.375000,262.240000,265.700000,9526401
  232. TSLA,2018-10-17,271.780000,282.700000,265.803200,282.400000,8655542
  233. TSLA,2018-10-18,263.910000,271.000000,263.000000,269.290000,5421184
  234. TSLA,2018-10-19,260.000000,269.660000,253.500000,267.390000,9375549
  235. TSLA,2018-10-22,260.950000,261.860000,252.590000,260.680000,5600260
  236. TSLA,2018-10-23,294.140000,297.930000,262.100000,263.870000,19027753
  237. TSLA,2018-10-24,288.500000,304.440000,285.730000,301.050000,20058258
  238. TSLA,2018-10-25,314.860000,321.000000,301.010000,317.220000,20840724
  239. TSLA,2018-10-26,330.900000,339.900000,306.650000,308.250000,27425520
  240. TSLA,2018-10-29,334.850000,347.160000,326.500000,337.470000,14486027
  241. TSLA,2018-10-30,329.900000,337.899900,322.260000,328.390000,9126704
  242. TSLA,2018-10-31,337.320000,342.000000,329.100000,332.540000,7624348
  243. TSLA,2018-11-01,344.280000,347.840000,334.725000,338.260000,8000132
  244. TSLA,2018-11-02,346.410000,349.200000,340.910000,343.740000,7807971
  245. TSLA,2018-11-05,341.400000,343.955000,330.140000,340.500000,7831048
  246. TSLA,2018-11-06,341.060000,348.800000,336.090000,339.070000,6762889
  247. TSLA,2018-11-07,348.160000,351.180000,340.800000,343.340000,7374522
  248. TSLA,2018-11-08,351.400000,357.575500,348.440000,348.500000,7090674
  249. TSLA,2018-11-09,350.510000,354.000000,345.230000,349.000000,5098846
  250. TSLA,2018-11-12,331.280000,349.780000,330.340000,348.370000,6941523
  251. TSLA,2018-11-13,338.730000,344.700000,332.200000,333.160000,5448597
  252. TSLA,2018-11-14,344.000000,347.110000,337.150000,342.700000,5040287
  253. TSLA,2018-11-15,348.440000,348.580000,339.040000,342.330000,4625719
  254. TSLA,2018-11-16,354.310000,355.700000,345.120100,345.190000,7206191
  255. TSLA,2018-11-19,353.470000,366.750000,352.880000,356.340000,9708871
  256. TSLA,2018-11-20,347.490000,349.800000,333.550000,341.750000,8004709
  257. TSLA,2018-11-21,338.190000,353.100000,337.399500,352.000000,4686808
  258. TSLA,2018-11-23,325.830000,337.500000,325.550000,334.345000,4202642
  259. TSLA,2018-11-26,346.000000,346.220000,325.000000,325.000000,7992141
  260. TSLA,2018-11-27,343.920000,346.960000,335.500000,340.050000,6358300
  261. TSLA,2018-11-28,347.870000,348.280000,342.210000,345.990000,4127578
  262. TSLA,2018-11-29,341.170000,347.500000,339.550000,347.000000,3080724
  263. TSLA,2018-11-30,350.480000,351.600000,338.264800,341.830000,5629095
  264. TSLA,2018-12-03,358.490000,366.000000,352.000000,360.000000,8306511
  265. TSLA,2018-12-04,359.700000,368.680000,352.000000,356.050000,8461945
  266. TSLA,2018-12-05,359.700000,359.700000,359.700000,359.700000,0
  267. TSLA,2018-12-06,363.060000,367.380000,350.760000,356.010000,7842508
  268. TSLA,2018-12-07,357.965000,379.490000,357.650000,369.000000,11511177
  269. TSLA,2018-12-10,365.150000,365.980000,353.120000,360.000000,6613455
  270. TSLA,2018-12-11,366.760000,372.168900,360.230000,369.910000,6308769
  271. TSLA,2018-12-12,366.600000,371.910000,365.160000,369.420000,5027048
  272. TSLA,2018-12-13,376.790000,377.440000,366.750000,370.150000,7365854
  273. TSLA,2018-12-14,365.710000,377.870000,364.330000,375.000000,6337555
  274. TSLA,2018-12-17,348.420000,365.700000,343.880000,362.000000,7674008
  275. TSLA,2018-12-18,337.030000,351.550000,333.690000,350.540000,7099999
  276. TSLA,2018-12-19,332.970000,347.010000,329.740000,337.600000,8274181
  277. TSLA,2018-12-20,315.380000,330.290000,311.869000,327.053500,9071858
  278. TSLA,2018-12-21,319.770000,323.470000,312.440000,317.400000,8016801
  279. TSLA,2018-12-24,295.390000,314.500000,295.195000,313.500000,5559913
  280. TSLA,2018-12-26,326.090000,326.970000,294.090000,300.000000,8163138
  281. TSLA,2018-12-27,316.130000,322.171700,301.500000,319.840000,8575133
  282. TSLA,2018-12-28,333.870000,336.240000,318.410000,323.100000,9938992
  283. TSLA,2018-12-31,332.800000,339.210000,325.260000,337.790000,6302338
  284. TSLA,2019-01-02,310.120000,315.130000,298.800000,306.100000,11658648
  285. TSLA,2019-01-03,300.360000,309.400000,297.380000,307.000000,6965184
  286. TSLA,2019-01-04,317.690000,318.000000,302.730000,306.000000,7394116
  287.  
Powered by spacepaste. Paste removal.