Bitcoin analysis of average change by weekday and month for YTD 2017 ending through August

_results.txt

	Sun	Mon	Tue	Wed	Thu	Fri	Sat
Jan	0.8	0.16	2.74	-1.3	-1.2	-1.97	0.77
Feb	-0.24	1.6	1.9	0.29	1.1	0.73	-0
Mar	2.4	2.76	1.09	-1.85	-0.33	-3.56	-0.57
Apr	1.32	1.44	1.18	0.17	1.98	0.43	0.29
May	1.16	3.8	2.18	3.82	0.1	-3.63	1.44
Jun	0.05	-1.56	5.58	-5.27	2.01	1.13	0.71
Jul	-0.67	3.35	-0.76	0.29	7.54	-2.99	-1.28
Aug	0.45	2.87	-0.26	0.93	1.8	1.51	5.26
							

bitcoin_daily_2017.txt

Date	Price	Open	High	Low	Change %
Aug 29, 2017	4587.1	4385.1	4644.2	4336.7	4.64
Aug 28, 2017	4383.8	4330.7	4395.2	4175.7	1.2
Aug 27, 2017	4331.8	4340.2	4405.7	4305	-0.23
Aug 26, 2017	4341.7	4351.5	4364	4243.6	-0.23
Aug 25, 2017	4351.5	4324.1	4461.2	4277.4	0.61
Aug 24, 2017	4325.2	4135	4370.8	4093	4.75
Aug 23, 2017	4129.1	4086.9	4248.6	4055.9	1.35
Aug 22, 2017	4074	3998.9	4140	3600	1.79
Aug 21, 2017	4002.5	4066.3	4093.5	3956.4	-1.52
Aug 20, 2017	4064.3	4145	4192	4040.9	-1.95
Aug 19, 2017	4145.1	4088.2	4184.1	3920	1.34
Aug 18, 2017	4090.2	4269.7	4359	3957	-3.99
Aug 17, 2017	4260	4386.4	4489.1	4178.1	-2.88
Aug 16, 2017	4386.3	4160	4403.6	3928.1	5.65
Aug 15, 2017	4151.9	4321	4430	3841.9	-3.88
Aug 14, 2017	4319.5	4061.6	4330.3	3969.3	6.57
Aug 13, 2017	4053.3	3866.2	4183.7	3836.1	4.86
Aug 12, 2017	3865.5	3643.4	3965.4	3590	6.08
Aug 11, 2017	3644.1	3404.7	3690.6	3380	6.93
Aug 10, 2017	3407.9	3340.2	3444.4	3310	2.04
Aug 09, 2017	3339.9	3415	3424.4	3236.8	-2.2
Aug 08, 2017	3415	3395	3482.9	3343.8	0.54
Aug 07, 2017	3396.7	3232.5	3440	3190	5.23
Aug 06, 2017	3227.9	3255	3309.8	3156	-0.88
Aug 05, 2017	3256.4	2860	3331.9	2855	13.86
Aug 04, 2017	2860	2790.3	2874.8	2762.6	2.5
Aug 03, 2017	2790.3	2702	2813	2698	3.27
Aug 02, 2017	2702	2733.8	2757.8	2640	-1.07
Aug 01, 2017	2731.2	2854.3	2901.6	2615.8	-4.37
Jul 31, 2017	2856	2748.9	2883.5	2694.8	3.89
Jul 30, 2017	2749	2713.7	2756.2	2595	1.29
Jul 29, 2017	2714.1	2784.8	2794.2	2662.6	-2.54
Jul 28, 2017	2784.8	2664.6	2819.9	2655.5	4.5
Jul 27, 2017	2664.9	2527.74	2682.2	2511	5.51
Jul 26, 2017	2525.7	2560.9	2612	2404.6	-1.37
Jul 25, 2017	2560.9	2769.7	2790.1	2435.7	-7.54
Jul 24, 2017	2769.7	2750.1	2812	2707.3	0.81
Jul 23, 2017	2747.5	2845.7	2875.7	2656.2	-3.45
Jul 22, 2017	2845.7	2659	2912.9	2642.8	6.82
Jul 21, 2017	2664	2874.5	2874.5	2615	-6.73
Jul 20, 2017	2856.3	2253.3	2919.9	2253.3	26.77
Jul 19, 2017	2253.1	2302.2	2399.9	2214.2	-2.13
Jul 18, 2017	2302.1	2220	2380.2	2139.8	3.74
Jul 17, 2017	2219	1925	2223.3	1924.1	15.28
Jul 16, 2017	1924.9	1979.7	2048.8	1835.8	-2.71
Jul 15, 2017	1978.6	2206.5	2210.1	1975.7	-10.27
Jul 14, 2017	2205.1	2329.4	2345.6	2138	-5.32
Jul 13, 2017	2329	2375.6	2400	2293.8	-1.91
Jul 12, 2017	2374.4	2285.6	2394	2195.8	4.04
Jul 11, 2017	2282.1	2318.3	2372.8	2183.3	-1.56
Jul 10, 2017	2318.3	2477.9	2498.1	2240	-6.44
Jul 09, 2017	2478	2542	2555.6	2473.7	-2.52
Jul 08, 2017	2542	2479.3	2542.6	2436.8	2.53
Jul 07, 2017	2479.3	2593.2	2598	2447	-4.39
Jul 06, 2017	2593.1	2598.6	2603.3	2546	-0.21
Jul 05, 2017	2598.5	2579.9	2617.6	2482.5	0.62
Jul 04, 2017	2582.6	2525.9	2628	2512.4	2.32
Jul 03, 2017	2524	2445.1	2584	2416.2	3.23
Jul 02, 2017	2445	2346.2	2470	2302	4.06
Jul 01, 2017	2349.5	2420.6	2440.9	2291	-2.94
Jun 30, 2017	2420.7	2472.4	2511.1	2406.6	-2
Jun 29, 2017	2470.1	2518.2	2537	2424.1	-1.91
Jun 28, 2017	2518.2	2521.3	2561.1	2403.2	-0.12
Jun 27, 2017	2521.2	2393.5	2524	2208.1	5.29
Jun 26, 2017	2394.6	2480	2510.4	2258.7	-3.35
Jun 25, 2017	2477.7	2502.6	2595	2369.1	-0.99
Jun 24, 2017	2502.6	2674.9	2700	2454.1	-6.44
Jun 23, 2017	2674.9	2672.8	2725.3	2652.8	0.08
Jun 22, 2017	2672.8	2624.4	2709	2554.8	1.97
Jun 21, 2017	2621.2	2715.3	2760	2573.3	-3.36
Jun 20, 2017	2712.2	2585	2779.6	2568.2	5.09
Jun 19, 2017	2580.8	2494.9	2592.7	2481.4	3.58
Jun 18, 2017	2491.5	2610.1	2635	2421	-4.54
Jun 17, 2017	2610	2435.5	2636.9	2368.7	7.1
Jun 16, 2017	2437	2377.5	2480	2261.2	2.51
Jun 15, 2017	2377.4	2394.3	2455	2050	-0.74
Jun 14, 2017	2395.04	2677.1	2720	2284.4	-10.51
Jun 13, 2017	2676.4	2570	2730	2532.6	4.07
Jun 12, 2017	2571.8	2941.8	2961.9	2298.23	-12.41
Jun 11, 2017	2936.3	2806	3000	2793.8	4.64
Jun 10, 2017	2806	2809.9	2890.5	2750.8	-0.11
Jun 09, 2017	2809	2781.5	2849.8	2769.6	0.97
Jun 08, 2017	2782.1	2642	2789.3	2570.1	5.28
Jun 07, 2017	2642.63	2844.6	2850	2600.2	-7.07
Jun 06, 2017	2843.6	2636.9	2896.5	2620	7.87
Jun 05, 2017	2636.2	2488.2	2637.5	2480	5.95
Jun 04, 2017	2488.2	2461.6	2498	2376.4	1.11
Jun 03, 2017	2461	2405.9	2481	2348	2.29
Jun 02, 2017	2405.88	2312	2407.8	2271.9	4.08
Jun 01, 2017	2311.6	2191.83	2366.7	2187.4	5.46
May 31, 2017	2191.83	2147.29	2240.1	2002.1	2.1
May 30, 2017	2146.7	2207.4	2263.1	2080.4	-2.75
May 29, 2017	2207.4	2056.9	2249.8	1990.1	7.33
May 28, 2017	2056.6	1980	2193	1955.5	4.27
May 27, 2017	1972.3	2125.9	2207.9	1810	-7.29
May 26, 2017	2127.3	2268.1	2477	2008.7	-5.54
May 25, 2017	2252	2392.6	2689	2142.1	-5.96
May 24, 2017	2394.8	2250	2443.8	2247.7	6.47
May 23, 2017	2249.3	2087.5	2262.9	2060	7.85
May 22, 2017	2085.5	2026.5	2219.9	1979.2	2.77
May 21, 2017	2029.2	2059.3	2099.1	2001	-1.48
May 20, 2017	2059.7	1966.5	2072.2	1963.6	4.74
May 19, 2017	1966.5	1941.5	2000	1925	1.29
May 18, 2017	1941.5	1870	1949.9	1861	3.82
May 17, 2017	1870	1786.2	1892.9	1766.4	4.72
May 16, 2017	1785.7	1772	1795.1	1728	0.74
May 15, 2017	1772.5	1826.8	1828.5	1720	-3.04
May 14, 2017	1828.1	1820.6	1852.4	1780	0.42
May 13, 2017	1820.4	1735	1824	1666	4.92
May 12, 2017	1735	1853.9	1864.8	1700.8	-6.41
May 11, 2017	1853.9	1796.9	1908	1766.6	3.18
May 10, 2017	1796.8	1759.8	1817.4	1722.3	2.09
May 09, 2017	1760	1703.5	1813.9	1695.1	3.33
May 08, 2017	1703.2	1619.8	1715	1618.9	5.14
May 07, 2017	1619.9	1597	1631.3	1575.1	1.43
May 06, 2017	1597.1	1545.1	1605	1545	3.37
May 05, 2017	1545.1	1607.2	1665.5	1511.7	-3.86
May 04, 2017	1607.1	1619.4	1701.9	1521.1	-0.66
May 03, 2017	1617.8	1558.5	1626.9	1542	3.71
May 02, 2017	1560	1533	1604.6	1479.2	1.75
May 01, 2017	1533.1	1435	1560	1432	6.82
Apr 30, 2017	1435.2	1425.4	1443.5	1403.3	0.81
Apr 29, 2017	1423.6	1415.6	1436.6	1401.5	0.57
Apr 28, 2017	1415.6	1440.3	1447	1368.3	-1.71
Apr 27, 2017	1440.3	1399.3	1449.7	1392.5	2.93
Apr 26, 2017	1399.3	1371	1411.7	1365.1	2.12
Apr 25, 2017	1370.3	1345	1378.5	1342.1	1.88
Apr 24, 2017	1345	1355.3	1359.6	1326.9	-0.75
Apr 23, 2017	1355.2	1346.4	1359	1336	0.57
Apr 22, 2017	1347.5	1327.1	1353.1	1290.1	1.65
Apr 21, 2017	1325.6	1308.7	1333.1	1307.5	1.31
Apr 20, 2017	1308.4	1260.5	1325.7	1260.1	3.8
Apr 19, 2017	1260.5	1265.4	1272	1255	-0.39
Apr 18, 2017	1265.4	1240	1274.8	1237	2.05
Apr 17, 2017	1240	1212.5	1247	1202.2	2.31
Apr 16, 2017	1212	1193.3	1217.6	1190.4	1.57
Apr 15, 2017	1193.3	1206.8	1215	1190	-1.12
Apr 14, 2017	1206.8	1187	1219.1	1184	1.67
Apr 13, 2017	1187	1227.4	1235.1	1163.5	-3.29
Apr 12, 2017	1227.4	1236.9	1239	1221	-0.66
Apr 11, 2017	1235.6	1220.3	1243.4	1209.1	1.25
Apr 10, 2017	1220.3	1215.9	1229.9	1208.1	0.36
Apr 09, 2017	1215.9	1188.1	1226.9	1180.2	2.34
Apr 08, 2017	1188.1	1196.6	1202.6	1171.3	-0.71
Apr 07, 2017	1196.6	1191.5	1208.9	1176.7	0.43
Apr 06, 2017	1191.5	1140.3	1206.4	1140.3	4.46
Apr 05, 2017	1140.6	1145.8	1146.7	1112.3	-0.38
Apr 04, 2017	1145	1150.1	1161.9	1124.1	-0.45
Apr 03, 2017	1150.2	1107.8	1159.9	1107.8	3.85
Apr 02, 2017	1107.6	1093.5	1118.2	1081	1.32
Apr 01, 2017	1093.2	1081.3	1106.9	1070.2	1.06
Mar 31, 2017	1081.7	1042.1	1089.4	1041	3.91
Mar 30, 2017	1041	1041.7	1053.5	1022.2	-0.08
Mar 29, 2017	1041.8	1044.7	1058.9	1009.3	-0.28
Mar 28, 2017	1044.7	1042.8	1066.5	1016.8	0.19
Mar 27, 2017	1042.7	968.9	1046.9	960.1	7.61
Mar 26, 2017	969	971.31	1005.5	950.1	-0.33
Mar 25, 2017	972.17	942.13	980	891	3.08
Mar 24, 2017	943.1	1032.7	1034.2	928.3	-8.7
Mar 23, 2017	1033	1039.4	1055	1018	-0.59
Mar 22, 2017	1039.1	1115.9	1116	986.3	-6.81
Mar 21, 2017	1115	1040.4	1120.9	1040.1	7.31
Mar 20, 2017	1039	1016.5	1052.1	1011.2	2.25
Mar 19, 2017	1016.1	971.9	1058.9	971	4.64
Mar 18, 2017	971	1067.8	1097.1	935.11	-9.12
Mar 17, 2017	1068.4	1169.1	1169.6	1066	-8.61
Mar 16, 2017	1169	1256.1	1259.7	1132.5	-6.93
Mar 15, 2017	1256.1	1245	1262	1241.3	0.89
Mar 14, 2017	1245	1238.5	1257.9	1218.9	0.52
Mar 13, 2017	1238.5	1224.4	1246.9	1207.5	1.09
Mar 12, 2017	1225.2	1172.4	1232.6	1167.5	4.47
Mar 11, 2017	1172.8	1113.5	1196.1	1107	5.32
Mar 10, 2017	1113.6	1190.4	1328.8	971	-6.45
Mar 09, 2017	1190.4	1150	1207.5	1136	3.58
Mar 08, 2017	1149.3	1232.4	1243.6	1142.2	-6.74
Mar 07, 2017	1232.4	1279.2	1281.8	1185.9	-3.67
Mar 06, 2017	1279.3	1278.4	1287.8	1268.6	0.07
Mar 05, 2017	1278.4	1267.8	1279.8	1245.3	0.84
Mar 04, 2017	1267.8	1289.1	1291.8	1240.1	-1.58
Mar 03, 2017	1288.2	1257.6	1294.7	1256.6	2.05
Mar 02, 2017	1262.3	1232.9	1283.1	1213	2.39
Mar 01, 2017	1232.8	1189.1	1233.5	1186	3.68
Feb 28, 2017	1189.1	1196	1216	1177.8	-0.54
Feb 27, 2017	1195.5	1178.3	1202.6	1171	1.46
Feb 26, 2017	1178.3	1153	1185.9	1130.9	2.19
Feb 25, 2017	1153	1185.4	1189.9	1131.5	-2.71
Feb 24, 2017	1185.1	1189.9	1222.2	1111.1	-0.49
Feb 23, 2017	1190.9	1125.5	1196.9	1120.4	5.83
Feb 22, 2017	1125.3	1129.6	1140	1106.4	-0.38
Feb 21, 2017	1129.6	1091.3	1134	1085	3.52
Feb 20, 2017	1091.2	1056.2	1100.3	1044.1	3.31
Feb 19, 2017	1056.2	1059.8	1066	1045	-0.34
Feb 18, 2017	1059.8	1056.2	1071.1	1053.1	0.34
Feb 17, 2017	1056.2	1038.5	1065.8	1034.1	1.71
Feb 16, 2017	1038.4	1013.9	1045.7	1013.9	2.43
Feb 15, 2017	1013.8	1013.3	1017.3	1002.4	0.01
Feb 14, 2017	1013.7	996.52	1019	988.88	1.73
Feb 13, 2017	996.5	996	1004.5	975.9	0.05
Feb 12, 2017	996.01	1000.1	1005.4	992.33	-0.43
Feb 11, 2017	1000.3	992.1	1009	984.19	0.84
Feb 10, 2017	992	984.97	1002	949.39	0.71
Feb 09, 2017	984.97	1049	1078	936.41	-6.09
Feb 08, 2017	1048.8	1052.5	1068	1013.2	-0.31
Feb 07, 2017	1052.1	1022.6	1056.3	1021.7	2.88
Feb 06, 2017	1022.6	1006.6	1026.2	1006	1.59
Feb 05, 2017	1006.6	1031.1	1033	996.35	-2.38
Feb 04, 2017	1031.1	1016.8	1040	1001.6	1.52
Feb 03, 2017	1015.7	1007	1020.5	988.34	0.99
Feb 02, 2017	1005.7	983.73	1010.5	970.11	2.23
Feb 01, 2017	983.73	966.19	984.99	960.1	1.82
Jan 31, 2017	966.19	917.36	969.38	916.75	5.32
Jan 30, 2017	917.36	912.55	920.79	910.01	0.53
Jan 29, 2017	912.56	919.43	922.99	910.72	-0.75
Jan 28, 2017	919.43	916.7	923.98	915.01	0.3
Jan 27, 2017	916.7	915.12	922.16	905.05	0.17
Jan 26, 2017	915.12	893.35	917.64	893.35	2.44
Jan 25, 2017	893.35	886.1	899.61	884.2	0.82
Jan 24, 2017	886.1	908.41	927	884.2	-2.63
Jan 23, 2017	910.03	923.72	928.82	910.03	-1.48
Jan 22, 2017	923.72	924.02	939.73	892	-0.03
Jan 21, 2017	924.02	895.74	931.01	893.89	3.13
Jan 20, 2017	895.96	900.29	904.5	883.34	-0.48
Jan 19, 2017	900.29	887.6	908.2	884.57	1.41
Jan 18, 2017	887.76	903.99	913.85	847.3	-1.8
Jan 17, 2017	903.99	830.1	910.77	828	8.9
Jan 16, 2017	830.1	820.74	837.89	814.79	1.14
Jan 15, 2017	820.74	815.3	822.98	805.13	0.67
Jan 14, 2017	815.3	828.12	838.54	800.71	-1.55
Jan 13, 2017	828.12	804.58	832.29	776	2.93
Jan 12, 2017	804.58	779.54	831.16	738.66	3.34
Jan 11, 2017	778.58	905.76	922.63	760	-14.04
Jan 10, 2017	905.76	903	917.88	895.5	0.31
Jan 09, 2017	903	915.9	916.1	876.3	-1.41
Jan 08, 2017	915.9	908.84	942.5	890	0.78
Jan 07, 2017	908.84	898.5	911	816.1	1.21
Jan 06, 2017	898	1003.8	1025	871	-10.49
Jan 05, 2017	1003.2	1139.8	1166	865.38	-11.97
Jan 04, 2017	1139.6	1037.5	1150	1036.4	9.84
Jan 03, 2017	1037.5	1019.3	1038.7	1013.5	1.79
Jan 02, 2017	1019.3	999.24	1034.8	997.3	2.03
Jan 01, 2017	998.99	966.58	1006.5	961.26	3.35

daily_change.rb

# https://www.investing.com/currencies/btc-usd-historical-data

require 'date'

class Historical
  attr_reader :date
  attr_reader :open, :close, :high, :low
  attr_reader :change

  def initialize values
    @date = Date.parse values.shift
    @close = values.shift.to_f
    @open = values.shift.to_f
    @high = values.shift.to_f
    @low = values.shift.to_f
    @change = values.shift.to_f
  end

  def weekday
    @date.strftime "%a"
  end

  def month
    @date.strftime "%B"
  end
end

days = File.read('bitcoin_daily_2017.txt')
  .split("\n")
  .slice(1,10_000)
  .map{ |l| Historical.new(l.split("\t")) }
  .group_by{|gb| gb.month}

days.each do |month, historicals|
  puts "\n", '-' * month.size, month, '-' * month.size
  historicals.group_by{|gb| gb.weekday}.each do |weekday, monthlys|
    sum_change = monthlys.inject(0.0){ |s,h| s+= h.change }
    avg_change = sum_change / monthlys.size
    puts [weekday, avg_change.round(2)].join("\t")
  end
end