Skip to content

Instantly share code, notes, and snippets.

@gchan

gchan/hay2201_prices.csv

Last active August 29, 2015 14:17
Show Gist options
  • Save gchan/684a9688a6c2121ead07 to your computer and use it in GitHub Desktop.
Save gchan/684a9688a6c2121ead07 to your computer and use it in GitHub Desktop.
Download ZIP
Heat map of Haywards power prices
Raw
hay2201_prices.csv
Time Period Price
2015-03-08T00:00:00+13:00 1 34.76
2015-03-08T00:30:00+13:00 2 .03
2015-03-08T01:00:00+13:00 3 50.2
2015-03-08T01:30:00+13:00 4 50.75
2015-03-08T02:00:00+13:00 5 27.79
2015-03-08T02:30:00+13:00 6 .03
2015-03-08T03:00:00+13:00 7 .03
2015-03-08T03:30:00+13:00 8 .03
2015-03-08T04:00:00+13:00 9 .03
2015-03-08T04:30:00+13:00 10 19.2
2015-03-08T05:00:00+13:00 11 31.78
2015-03-08T05:30:00+13:00 12 52.79
2015-03-08T06:00:00+13:00 13 60.4
2015-03-08T06:30:00+13:00 14 61.39
2015-03-08T07:00:00+13:00 15 59.98
2015-03-08T07:30:00+13:00 16 56.27
2015-03-08T08:00:00+13:00 17 30.36
2015-03-08T08:30:00+13:00 18 45.22
2015-03-08T09:00:00+13:00 19 41.05
2015-03-08T09:30:00+13:00 20 29.87
2015-03-08T10:00:00+13:00 21 29.95
2015-03-08T10:30:00+13:00 22 20.32
2015-03-08T11:00:00+13:00 23 21.16
2015-03-08T11:30:00+13:00 24 21.69
2015-03-08T12:00:00+13:00 25 32.25
2015-03-08T12:30:00+13:00 26 33.05
2015-03-08T13:00:00+13:00 27 35.22
2015-03-08T13:30:00+13:00 28 45.1
2015-03-08T14:00:00+13:00 29 46.37
2015-03-08T14:30:00+13:00 30 46.89
2015-03-08T15:00:00+13:00 31 50.38
2015-03-08T15:30:00+13:00 32 50.38
2015-03-08T16:00:00+13:00 33 50.38
2015-03-08T16:30:00+13:00 34 50.38
2015-03-08T17:00:00+13:00 35 51.93
2015-03-08T17:30:00+13:00 36 61.52
2015-03-08T18:00:00+13:00 37 61.69
2015-03-08T18:30:00+13:00 38 62.09
2015-03-08T19:00:00+13:00 39 69.74
2015-03-08T19:30:00+13:00 40 72.36
2015-03-08T20:00:00+13:00 41 91.84
2015-03-08T20:30:00+13:00 42 92.09
2015-03-08T21:00:00+13:00 43 85.98
2015-03-08T21:30:00+13:00 44 82.18
2015-03-08T22:00:00+13:00 45 72.14
2015-03-08T22:30:00+13:00 46 56.01
2015-03-08T23:00:00+13:00 47 55.41
2015-03-08T23:30:00+13:00 48 48.37
2015-03-09T00:00:00+13:00 1 56.06
2015-03-09T00:30:00+13:00 2 55.13
2015-03-09T01:00:00+13:00 3 55.08
2015-03-09T01:30:00+13:00 4 20.15
2015-03-09T02:00:00+13:00 5 1.01
2015-03-09T02:30:00+13:00 6 1.01
2015-03-09T03:00:00+13:00 7 .04
2015-03-09T03:30:00+13:00 8 1.01
2015-03-09T04:00:00+13:00 9 23.07
2015-03-09T04:30:00+13:00 10 24.18
2015-03-09T05:00:00+13:00 11 54.83
2015-03-09T05:30:00+13:00 12 54.92
2015-03-09T06:00:00+13:00 13 68.42
2015-03-09T06:30:00+13:00 14 82.14
2015-03-09T07:00:00+13:00 15 65.07
2015-03-09T07:30:00+13:00 16 59.37
2015-03-09T08:00:00+13:00 17 59.37
2015-03-09T08:30:00+13:00 18 61.08
2015-03-09T09:00:00+13:00 19 61.99
2015-03-09T09:30:00+13:00 20 69.17
2015-03-09T10:00:00+13:00 21 71.04
2015-03-09T10:30:00+13:00 22 71.04
2015-03-09T11:00:00+13:00 23 76.43
2015-03-09T11:30:00+13:00 24 70.61
2015-03-09T12:00:00+13:00 25 69.73
2015-03-09T12:30:00+13:00 26 76.42
2015-03-09T13:00:00+13:00 27 98.15
2015-03-09T13:30:00+13:00 28 89.57
2015-03-09T14:00:00+13:00 29 86.17
2015-03-09T14:30:00+13:00 30 97.4
2015-03-09T15:00:00+13:00 31 97.37
2015-03-09T15:30:00+13:00 32 94.19
2015-03-09T16:00:00+13:00 33 106.31
2015-03-09T16:30:00+13:00 34 108.44
2015-03-09T17:00:00+13:00 35 69.38
2015-03-09T17:30:00+13:00 36 78.13
2015-03-09T18:00:00+13:00 37 58.05
2015-03-09T18:30:00+13:00 38 57.86
2015-03-09T19:00:00+13:00 39 58.76
2015-03-09T19:30:00+13:00 40 61.99
2015-03-09T20:00:00+13:00 41 82.25
2015-03-09T20:30:00+13:00 42 79.37
2015-03-09T21:00:00+13:00 43 74.39
2015-03-09T21:30:00+13:00 44 76.77
2015-03-09T22:00:00+13:00 45 82.39
2015-03-09T22:30:00+13:00 46 73.91
2015-03-09T23:00:00+13:00 47 60.82
2015-03-09T23:30:00+13:00 48 78.06
2015-03-10T00:00:00+13:00 1 83.3
2015-03-10T00:30:00+13:00 2 75.89
2015-03-10T01:00:00+13:00 3 61.97
2015-03-10T01:30:00+13:00 4 54.88
2015-03-10T02:00:00+13:00 5 61.31
2015-03-10T02:30:00+13:00 6 60.47
2015-03-10T03:00:00+13:00 7 61.9
2015-03-10T03:30:00+13:00 8 61.34
2015-03-10T04:00:00+13:00 9 61.93
2015-03-10T04:30:00+13:00 10 60.14
2015-03-10T05:00:00+13:00 11 60.19
2015-03-10T05:30:00+13:00 12 60.06
2015-03-10T06:00:00+13:00 13 83.36
2015-03-10T06:30:00+13:00 14 83.02
2015-03-10T07:00:00+13:00 15 90.53
2015-03-10T07:30:00+13:00 16 76.78
2015-03-10T08:00:00+13:00 17 62.14
2015-03-10T08:30:00+13:00 18 68.78
2015-03-10T09:00:00+13:00 19 75.85
2015-03-10T09:30:00+13:00 20 97.77
2015-03-10T10:00:00+13:00 21 76.3
2015-03-10T10:30:00+13:00 22 84.59
2015-03-10T11:00:00+13:00 23 78.44
2015-03-10T11:30:00+13:00 24 80.79
2015-03-10T12:00:00+13:00 25 101.6
2015-03-10T12:30:00+13:00 26 97.97
2015-03-10T13:00:00+13:00 27 104.76
2015-03-10T13:30:00+13:00 28 104.86
2015-03-10T14:00:00+13:00 29 104.05
2015-03-10T14:30:00+13:00 30 103.74
2015-03-10T15:00:00+13:00 31 101.06
2015-03-10T15:30:00+13:00 32 98.96
2015-03-10T16:00:00+13:00 33 99.89
2015-03-10T16:30:00+13:00 34 98.59
2015-03-10T17:00:00+13:00 35 98.33
2015-03-10T17:30:00+13:00 36 87.81
2015-03-10T18:00:00+13:00 37 84.16
2015-03-10T18:30:00+13:00 38 68.11
2015-03-10T19:00:00+13:00 39 63.59
2015-03-10T19:30:00+13:00 40 63.57
2015-03-10T20:00:00+13:00 41 75.01
2015-03-10T20:30:00+13:00 42 67.24
2015-03-10T21:00:00+13:00 43 63.62
2015-03-10T21:30:00+13:00 44 61.95
2015-03-10T22:00:00+13:00 45 64.61
2015-03-10T22:30:00+13:00 46 61.89
2015-03-10T23:00:00+13:00 47 62.41
2015-03-10T23:30:00+13:00 48 69.18
2015-03-11T00:00:00+13:00 1 67.04
2015-03-11T00:30:00+13:00 2 65.38
2015-03-11T01:00:00+13:00 3 65.33
2015-03-11T01:30:00+13:00 4 63.12
2015-03-11T02:00:00+13:00 5 60.73
2015-03-11T02:30:00+13:00 6 69.56
2015-03-11T03:00:00+13:00 7 76.08
2015-03-11T03:30:00+13:00 8 76.08
2015-03-11T04:00:00+13:00 9 76.98
2015-03-11T04:30:00+13:00 10 80
2015-03-11T05:00:00+13:00 11 87.44
2015-03-11T05:30:00+13:00 12 65.19
2015-03-11T06:00:00+13:00 13 82.03
2015-03-11T06:30:00+13:00 14 83.65
2015-03-11T07:00:00+13:00 15 87.14
2015-03-11T07:30:00+13:00 16 85.24
2015-03-11T08:00:00+13:00 17 75.72
2015-03-11T08:30:00+13:00 18 75.22
2015-03-11T09:00:00+13:00 19 61.09
2015-03-11T09:30:00+13:00 20 59.49
2015-03-11T10:00:00+13:00 21 54.95
2015-03-11T10:30:00+13:00 22 51.64
2015-03-11T11:00:00+13:00 23 59.82
2015-03-11T11:30:00+13:00 24 78.32
2015-03-11T12:00:00+13:00 25 75.08
2015-03-11T12:30:00+13:00 26 74.5
2015-03-11T13:00:00+13:00 27 74.42
2015-03-11T13:30:00+13:00 28 74.42
2015-03-11T14:00:00+13:00 29 61.69
2015-03-11T14:30:00+13:00 30 66.85
2015-03-11T15:00:00+13:00 31 70.86
2015-03-11T15:30:00+13:00 32 70.86
2015-03-11T16:00:00+13:00 33 57.25
2015-03-11T16:30:00+13:00 34 67.37
2015-03-11T17:00:00+13:00 35 56.96
2015-03-11T17:30:00+13:00 36 57.32
2015-03-11T18:00:00+13:00 37 53.44
2015-03-11T18:30:00+13:00 38 53.55
2015-03-11T19:00:00+13:00 39 59.85
2015-03-11T19:30:00+13:00 40 61.7
2015-03-11T20:00:00+13:00 41 63.26
2015-03-11T20:30:00+13:00 42 61.69
2015-03-11T21:00:00+13:00 43 63.14
2015-03-11T21:30:00+13:00 44 60.11
2015-03-11T22:00:00+13:00 45 74.54
2015-03-11T22:30:00+13:00 46 76.66
2015-03-11T23:00:00+13:00 47 79.86
2015-03-11T23:30:00+13:00 48 77.01
2015-03-12T00:00:00+13:00 1 72.78
2015-03-12T00:30:00+13:00 2 67.09
2015-03-12T01:00:00+13:00 3 62.02
2015-03-12T01:30:00+13:00 4 60.74
2015-03-12T02:00:00+13:00 5 61.91
2015-03-12T02:30:00+13:00 6 70.39
2015-03-12T03:00:00+13:00 7 76.79
2015-03-12T03:30:00+13:00 8 75.5
2015-03-12T04:00:00+13:00 9 77.19
2015-03-12T04:30:00+13:00 10 78.08
2015-03-12T05:00:00+13:00 11 81.63
2015-03-12T05:30:00+13:00 12 87.95
2015-03-12T06:00:00+13:00 13 106.12
2015-03-12T06:30:00+13:00 14 106.29
2015-03-12T07:00:00+13:00 15 154.27
2015-03-12T07:30:00+13:00 16 154.62
2015-03-12T08:00:00+13:00 17 154.64
2015-03-12T08:30:00+13:00 18 104.47
2015-03-12T09:00:00+13:00 19 148.41
2015-03-12T09:30:00+13:00 20 141.19
2015-03-12T10:00:00+13:00 21 80.48
2015-03-12T10:30:00+13:00 22 141.56
2015-03-12T11:00:00+13:00 23 192.02
2015-03-12T11:30:00+13:00 24 214
2015-03-12T12:00:00+13:00 25 196.26
2015-03-12T12:30:00+13:00 26 196.32
2015-03-12T13:00:00+13:00 27 215.45
2015-03-12T13:30:00+13:00 28 211.77
2015-03-12T14:00:00+13:00 29 200.99
2015-03-12T14:30:00+13:00 30 196.13
2015-03-12T15:00:00+13:00 31 186.82
2015-03-12T15:30:00+13:00 32 185.66
2015-03-12T16:00:00+13:00 33 89.81
2015-03-12T16:30:00+13:00 34 132.5
2015-03-12T17:00:00+13:00 35 172.24
2015-03-12T17:30:00+13:00 36 112.81
2015-03-12T18:00:00+13:00 37 110.56
2015-03-12T18:30:00+13:00 38 107.12
2015-03-12T19:00:00+13:00 39 77.63
2015-03-12T19:30:00+13:00 40 111.89
2015-03-12T20:00:00+13:00 41 113.65
2015-03-12T20:30:00+13:00 42 108.94
2015-03-12T21:00:00+13:00 43 105.98
2015-03-12T21:30:00+13:00 44 105.98
2015-03-12T22:00:00+13:00 45 91.69
2015-03-12T22:30:00+13:00 46 97.71
2015-03-12T23:00:00+13:00 47 94.32
2015-03-12T23:30:00+13:00 48 99.71
2015-03-13T00:00:00+13:00 1 84.1
2015-03-13T00:30:00+13:00 2 77.28
2015-03-13T01:00:00+13:00 3 76.17
2015-03-13T01:30:00+13:00 4 76.05
2015-03-13T02:00:00+13:00 5 74.24
2015-03-13T02:30:00+13:00 6 77.86
2015-03-13T03:00:00+13:00 7 77.67
2015-03-13T03:30:00+13:00 8 76.07
2015-03-13T04:00:00+13:00 9 77.32
2015-03-13T04:30:00+13:00 10 76.05
2015-03-13T05:00:00+13:00 11 77.76
2015-03-13T05:30:00+13:00 12 91.41
2015-03-13T06:00:00+13:00 13 84.93
2015-03-13T06:30:00+13:00 14 98.95
2015-03-13T07:00:00+13:00 15 107.23
2015-03-13T07:30:00+13:00 16 77.3
2015-03-13T08:00:00+13:00 17 103.08
2015-03-13T08:30:00+13:00 18 103.49
2015-03-13T09:00:00+13:00 19 112.26
2015-03-13T09:30:00+13:00 20 107.31
2015-03-13T10:00:00+13:00 21 103.6
2015-03-13T10:30:00+13:00 22 118.85
2015-03-13T11:00:00+13:00 23 107.59
2015-03-13T11:30:00+13:00 24 108.24
2015-03-13T12:00:00+13:00 25 107.1
2015-03-13T12:30:00+13:00 26 106.03
2015-03-13T13:00:00+13:00 27 105.8
2015-03-13T13:30:00+13:00 28 105.09
2015-03-13T14:00:00+13:00 29 107.54
2015-03-13T14:30:00+13:00 30 104.92
2015-03-13T15:00:00+13:00 31 105.12
2015-03-13T15:30:00+13:00 32 116.74
2015-03-13T16:00:00+13:00 33 116.98
2015-03-13T16:30:00+13:00 34 116.98
2015-03-13T17:00:00+13:00 35 85.51
2015-03-13T17:30:00+13:00 36 85.51
2015-03-13T18:00:00+13:00 37 78.46
2015-03-13T18:30:00+13:00 38 71.82
2015-03-13T19:00:00+13:00 39 81.76
2015-03-13T19:30:00+13:00 40 107.03
2015-03-13T20:00:00+13:00 41 107.96
2015-03-13T20:30:00+13:00 42 102.31
2015-03-13T21:00:00+13:00 43 101.28
2015-03-13T21:30:00+13:00 44 75.36
2015-03-13T22:00:00+13:00 45 77.67
2015-03-13T22:30:00+13:00 46 92.56
2015-03-13T23:00:00+13:00 47 87.57
2015-03-13T23:30:00+13:00 48 79.21
2015-03-14T00:00:00+13:00 1 110.03
2015-03-14T00:30:00+13:00 2 94.38
2015-03-14T01:00:00+13:00 3 93.1
2015-03-14T01:30:00+13:00 4 72.83
2015-03-14T02:00:00+13:00 5 87.67
2015-03-14T02:30:00+13:00 6 76.06
2015-03-14T03:00:00+13:00 7 73.18
2015-03-14T03:30:00+13:00 8 63.98
2015-03-14T04:00:00+13:00 9 66.36
2015-03-14T04:30:00+13:00 10 70.44
2015-03-14T05:00:00+13:00 11 69.41
2015-03-14T05:30:00+13:00 12 69.55
2015-03-14T06:00:00+13:00 13 61.33
2015-03-14T06:30:00+13:00 14 64.95
2015-03-14T07:00:00+13:00 15 61.58
2015-03-14T07:30:00+13:00 16 60.04
2015-03-14T08:00:00+13:00 17 67.53
2015-03-14T08:30:00+13:00 18 79.66
2015-03-14T09:00:00+13:00 19 99.07
2015-03-14T09:30:00+13:00 20 103.99
2015-03-14T10:00:00+13:00 21 101.02
2015-03-14T10:30:00+13:00 22 99.07
2015-03-14T11:00:00+13:00 23 77.98
2015-03-14T11:30:00+13:00 24 81.69
2015-03-14T12:00:00+13:00 25 81.62
2015-03-14T12:30:00+13:00 26 80.96
2015-03-14T13:00:00+13:00 27 79.54
2015-03-14T13:30:00+13:00 28 78.26
2015-03-14T14:00:00+13:00 29 89.74
2015-03-14T14:30:00+13:00 30 83.1
2015-03-14T15:00:00+13:00 31 81.41
2015-03-14T15:30:00+13:00 32 78.4
2015-03-14T16:00:00+13:00 33 77.08
2015-03-14T16:30:00+13:00 34 77.47
2015-03-14T17:00:00+13:00 35 77.08
2015-03-14T17:30:00+13:00 36 77.08
2015-03-14T18:00:00+13:00 37 77.08
2015-03-14T18:30:00+13:00 38 78.05
2015-03-14T19:00:00+13:00 39 71.43
2015-03-14T19:30:00+13:00 40 71.77
2015-03-14T20:00:00+13:00 41 82.26
2015-03-14T20:30:00+13:00 42 82.26
2015-03-14T21:00:00+13:00 43 80.21
2015-03-14T21:30:00+13:00 44 97.55
2015-03-14T22:00:00+13:00 45 89.44
2015-03-14T22:30:00+13:00 46 74.02
2015-03-14T23:00:00+13:00 47 77.7
2015-03-14T23:30:00+13:00 48 67.39
2015-03-15T00:00:00+13:00 1 60.49
2015-03-15T00:30:00+13:00 2 60.06
2015-03-15T01:00:00+13:00 3 67.74
2015-03-15T01:30:00+13:00 4 60.16
2015-03-15T02:00:00+13:00 5 57.02
2015-03-15T02:30:00+13:00 6 56.3
2015-03-15T03:00:00+13:00 7 56.29
2015-03-15T03:30:00+13:00 8 56.34
2015-03-15T04:00:00+13:00 9 60.07
2015-03-15T04:30:00+13:00 10 58.5
2015-03-15T05:00:00+13:00 11 60.51
2015-03-15T05:30:00+13:00 12 62.15
2015-03-15T06:00:00+13:00 13 60.07
2015-03-15T06:30:00+13:00 14 59.7
2015-03-15T07:00:00+13:00 15 56.1
2015-03-15T07:30:00+13:00 16 55.87
2015-03-15T08:00:00+13:00 17 50.66
2015-03-15T08:30:00+13:00 18 54.9
2015-03-15T09:00:00+13:00 19 56.36
2015-03-15T09:30:00+13:00 20 59.39
2015-03-15T10:00:00+13:00 21 62.13
2015-03-15T10:30:00+13:00 22 61.79
2015-03-15T11:00:00+13:00 23 61.86
2015-03-15T11:30:00+13:00 24 65.57
2015-03-15T12:00:00+13:00 25 73.34
2015-03-15T12:30:00+13:00 26 71.06
2015-03-15T13:00:00+13:00 27 70.58
2015-03-15T13:30:00+13:00 28 71.67
2015-03-15T14:00:00+13:00 29 66.33
2015-03-15T14:30:00+13:00 30 61.98
2015-03-15T15:00:00+13:00 31 63.79
2015-03-15T15:30:00+13:00 32 67.51
2015-03-15T16:00:00+13:00 33 74.68
2015-03-15T16:30:00+13:00 34 73.75
2015-03-15T17:00:00+13:00 35 75.13
2015-03-15T17:30:00+13:00 36 86.38
2015-03-15T18:00:00+13:00 37 86.51
2015-03-15T18:30:00+13:00 38 90.55
2015-03-15T19:00:00+13:00 39 90.68
2015-03-15T19:30:00+13:00 40 90.56
2015-03-15T20:00:00+13:00 41 91.6
2015-03-15T20:30:00+13:00 42 75.77
2015-03-15T21:00:00+13:00 43 66.72
2015-03-15T21:30:00+13:00 44 66.34
2015-03-15T22:00:00+13:00 45 75.98
2015-03-15T22:30:00+13:00 46 70.68
2015-03-15T23:00:00+13:00 47 69.67
2015-03-15T23:30:00+13:00 48 59.03
2015-03-16T00:00:00+13:00 1 58.95
2015-03-16T00:30:00+13:00 2 63.57
2015-03-16T01:00:00+13:00 3 57.35
2015-03-16T01:30:00+13:00 4 60.07
2015-03-16T02:00:00+13:00 5 78.53
2015-03-16T02:30:00+13:00 6 78.53
2015-03-16T03:00:00+13:00 7 67.8
2015-03-16T03:30:00+13:00 8 61.64
2015-03-16T04:00:00+13:00 9 61.15
2015-03-16T04:30:00+13:00 10 61.11
2015-03-16T05:00:00+13:00 11 76.12
2015-03-16T05:30:00+13:00 12 76.14
2015-03-16T06:00:00+13:00 13 75.32
2015-03-16T06:30:00+13:00 14 77.05
2015-03-16T07:00:00+13:00 15 84.93
2015-03-16T07:30:00+13:00 16 126.47
2015-03-16T08:00:00+13:00 17 126.04
2015-03-16T08:30:00+13:00 18 124.44
2015-03-16T09:00:00+13:00 19 102.42
2015-03-16T09:30:00+13:00 20 99.93
2015-03-16T10:00:00+13:00 21 101.34
2015-03-16T10:30:00+13:00 22 92.04
2015-03-16T11:00:00+13:00 23 103.46
2015-03-16T11:30:00+13:00 24 78.26
2015-03-16T12:00:00+13:00 25 74.73
2015-03-16T12:30:00+13:00 26 67.31
2015-03-16T13:00:00+13:00 27 67.91
2015-03-16T13:30:00+13:00 28 68.23
2015-03-16T14:00:00+13:00 29 71.85
2015-03-16T14:30:00+13:00 30 67.91
2015-03-16T15:00:00+13:00 31 96.96
2015-03-16T15:30:00+13:00 32 92.35
2015-03-16T16:00:00+13:00 33 75.99
2015-03-16T16:30:00+13:00 34 75.99
2015-03-16T17:00:00+13:00 35 67.03
2015-03-16T17:30:00+13:00 36 68.35
2015-03-16T18:00:00+13:00 37 68.63
2015-03-16T18:30:00+13:00 38 71.67
2015-03-16T19:00:00+13:00 39 69.91
2015-03-16T19:30:00+13:00 40 73.13
2015-03-16T20:00:00+13:00 41 92.6
2015-03-16T20:30:00+13:00 42 95.14
2015-03-16T21:00:00+13:00 43 77.21
2015-03-16T21:30:00+13:00 44 89.84
2015-03-16T22:00:00+13:00 45 85.94
2015-03-16T22:30:00+13:00 46 76.65
2015-03-16T23:00:00+13:00 47 68.12
2015-03-16T23:30:00+13:00 48 63.2
2015-03-17T00:00:00+13:00 1 67.96
2015-03-17T00:30:00+13:00 2 81.52
2015-03-17T01:00:00+13:00 3 63.07
2015-03-17T01:30:00+13:00 4 58.95
2015-03-17T02:00:00+13:00 5 62.38
2015-03-17T02:30:00+13:00 6 63.52
2015-03-17T03:00:00+13:00 7 62.44
2015-03-17T03:30:00+13:00 8 62.44
2015-03-17T04:00:00+13:00 9 62.44
2015-03-17T04:30:00+13:00 10 63.52
2015-03-17T05:00:00+13:00 11 63.25
2015-03-17T05:30:00+13:00 12 68.66
2015-03-17T06:00:00+13:00 13 80.89
2015-03-17T06:30:00+13:00 14 83.07
2015-03-17T07:00:00+13:00 15 87.21
2015-03-17T07:30:00+13:00 16 126.2
2015-03-17T08:00:00+13:00 17 128.3
2015-03-17T08:30:00+13:00 18 124.42
2015-03-17T09:00:00+13:00 19 84.82
2015-03-17T09:30:00+13:00 20 81.49
2015-03-17T10:00:00+13:00 21 72.55
2015-03-17T10:30:00+13:00 22 81.96
2015-03-17T11:00:00+13:00 23 97.57
2015-03-17T11:30:00+13:00 24 100.9
2015-03-17T12:00:00+13:00 25 88.68
2015-03-17T12:30:00+13:00 26 79.76
2015-03-17T13:00:00+13:00 27 81.93
2015-03-17T13:30:00+13:00 28 65.46
2015-03-17T14:00:00+13:00 29 64
2015-03-17T14:30:00+13:00 30 64.1
2015-03-17T15:00:00+13:00 31 64.32
2015-03-17T15:30:00+13:00 32 64.09
2015-03-17T16:00:00+13:00 33 77.37
2015-03-17T16:30:00+13:00 34 77.09
2015-03-17T17:00:00+13:00 35 77.09
2015-03-17T17:30:00+13:00 36 81.41
2015-03-17T18:00:00+13:00 37 75.91
2015-03-17T18:30:00+13:00 38 85.38
2015-03-17T19:00:00+13:00 39 80.47
2015-03-17T19:30:00+13:00 40 89.91
2015-03-17T20:00:00+13:00 41 92.9
2015-03-17T20:30:00+13:00 42 102.33
2015-03-17T21:00:00+13:00 43 98.5
2015-03-17T21:30:00+13:00 44 77.81
2015-03-17T22:00:00+13:00 45 84.45
2015-03-17T22:30:00+13:00 46 79.69
2015-03-17T23:00:00+13:00 47 80.46
2015-03-17T23:30:00+13:00 48 75.84
2015-03-18T00:00:00+13:00 1 88.32
2015-03-18T00:30:00+13:00 2 75.65
2015-03-18T01:00:00+13:00 3 77.8
2015-03-18T01:30:00+13:00 4 77.82
2015-03-18T02:00:00+13:00 5 88.62
2015-03-18T02:30:00+13:00 6 86.7
2015-03-18T03:00:00+13:00 7 86.88
2015-03-18T03:30:00+13:00 8 84.46
2015-03-18T04:00:00+13:00 9 80.47
2015-03-18T04:30:00+13:00 10 81.41
2015-03-18T05:00:00+13:00 11 84.46
2015-03-18T05:30:00+13:00 12 84.47
2015-03-18T06:00:00+13:00 13 88.67
2015-03-18T06:30:00+13:00 14 94.84
2015-03-18T07:00:00+13:00 15 95.32
2015-03-18T07:30:00+13:00 16 102.47
2015-03-18T08:00:00+13:00 17 104.77
2015-03-18T08:30:00+13:00 18 101.67
2015-03-18T09:00:00+13:00 19 101.59
2015-03-18T09:30:00+13:00 20 89.29
2015-03-18T10:00:00+13:00 21 81.43
2015-03-18T10:30:00+13:00 22 81.99
2015-03-18T11:00:00+13:00 23 80.89
2015-03-18T11:30:00+13:00 24 85.15
2015-03-18T12:00:00+13:00 25 96.36
2015-03-18T12:30:00+13:00 26 84.48
2015-03-18T13:00:00+13:00 27 82.38
2015-03-18T13:30:00+13:00 28 86.81
2015-03-18T14:00:00+13:00 29 82.34
2015-03-18T14:30:00+13:00 30 81.37
2015-03-18T15:00:00+13:00 31 84.2
2015-03-18T15:30:00+13:00 32 80.7
2015-03-18T16:00:00+13:00 33 66.75
2015-03-18T16:30:00+13:00 34 60.96
2015-03-18T17:00:00+13:00 35 59.33
2015-03-18T17:30:00+13:00 36 60.97
2015-03-18T18:00:00+13:00 37 62.88
2015-03-18T18:30:00+13:00 38 66.37
2015-03-18T19:00:00+13:00 39 65.2
2015-03-18T19:30:00+13:00 40 80.07
2015-03-18T20:00:00+13:00 41 82.09
2015-03-18T20:30:00+13:00 42 96.79
2015-03-18T21:00:00+13:00 43 87.05
2015-03-18T21:30:00+13:00 44 79.98
2015-03-18T22:00:00+13:00 45 84.24
2015-03-18T22:30:00+13:00 46 79.57
2015-03-18T23:00:00+13:00 47 78.68
2015-03-18T23:30:00+13:00 48 75.76
2015-03-19T00:00:00+13:00 1 94.99
2015-03-19T00:30:00+13:00 2 87.46
2015-03-19T01:00:00+13:00 3 76.02
2015-03-19T01:30:00+13:00 4 76.03
2015-03-19T02:00:00+13:00 5 83.49
2015-03-19T02:30:00+13:00 6 76.98
2015-03-19T03:00:00+13:00 7 76.11
2015-03-19T03:30:00+13:00 8 76.04
2015-03-19T04:00:00+13:00 9 77.62
2015-03-19T04:30:00+13:00 10 76.27
2015-03-19T05:00:00+13:00 11 89.74
2015-03-19T05:30:00+13:00 12 89.63
2015-03-19T06:00:00+13:00 13 101.33
2015-03-19T06:30:00+13:00 14 88.99
2015-03-19T07:00:00+13:00 15 101.26
2015-03-19T07:30:00+13:00 16 100.2
2015-03-19T08:00:00+13:00 17 101.61
2015-03-19T08:30:00+13:00 18 89.53
2015-03-19T09:00:00+13:00 19 85.67
2015-03-19T09:30:00+13:00 20 82.65
2015-03-19T10:00:00+13:00 21 82.8
2015-03-19T10:30:00+13:00 22 89.53
2015-03-19T11:00:00+13:00 23 85.91
2015-03-19T11:30:00+13:00 24 87.5
2015-03-19T12:00:00+13:00 25 88.12
2015-03-19T12:30:00+13:00 26 87.26
2015-03-19T13:00:00+13:00 27 84.58
2015-03-19T13:30:00+13:00 28 84.16
2015-03-19T14:00:00+13:00 29 81.99
2015-03-19T14:30:00+13:00 30 82.38
2015-03-19T15:00:00+13:00 31 80.92
2015-03-19T15:30:00+13:00 32 82.38
2015-03-19T16:00:00+13:00 33 80.98
2015-03-19T16:30:00+13:00 34 67.52
2015-03-19T17:00:00+13:00 35 81.17
2015-03-19T17:30:00+13:00 36 82.02
2015-03-19T18:00:00+13:00 37 79.92
2015-03-19T18:30:00+13:00 38 64.46
2015-03-19T19:00:00+13:00 39 60.89
2015-03-19T19:30:00+13:00 40 81.85
2015-03-19T20:00:00+13:00 41 84.01
2015-03-19T20:30:00+13:00 42 100.84
2015-03-19T21:00:00+13:00 43 98.88
2015-03-19T21:30:00+13:00 44 80.67
2015-03-19T22:00:00+13:00 45 84.75
2015-03-19T22:30:00+13:00 46 76.71
2015-03-19T23:00:00+13:00 47 74.99
2015-03-19T23:30:00+13:00 48 63.47
2015-03-20T00:00:00+13:00 1 84.56
2015-03-20T00:30:00+13:00 2 85.16
2015-03-20T01:00:00+13:00 3 85.16
2015-03-20T01:30:00+13:00 4 73.11
2015-03-20T02:00:00+13:00 5 77.53
2015-03-20T02:30:00+13:00 6 72.91
2015-03-20T03:00:00+13:00 7 73.18
2015-03-20T03:30:00+13:00 8 68.75
2015-03-20T04:00:00+13:00 9 74.34
2015-03-20T04:30:00+13:00 10 89.22
2015-03-20T05:00:00+13:00 11 85.1
2015-03-20T05:30:00+13:00 12 92.94
2015-03-20T06:00:00+13:00 13 93.79
2015-03-20T06:30:00+13:00 14 88.13
2015-03-20T07:00:00+13:00 15 95.76
2015-03-20T07:30:00+13:00 16 101.38
2015-03-20T08:00:00+13:00 17 88.93
2015-03-20T08:30:00+13:00 18 85.16
2015-03-20T09:00:00+13:00 19 81.16
2015-03-20T09:30:00+13:00 20 79.41
2015-03-20T10:00:00+13:00 21 66.07
2015-03-20T10:30:00+13:00 22 65.67
2015-03-20T11:00:00+13:00 23 65.72
2015-03-20T11:30:00+13:00 24 65.23
2015-03-20T12:00:00+13:00 25 64.59
2015-03-20T12:30:00+13:00 26 78.55
2015-03-20T13:00:00+13:00 27 79.55
2015-03-20T13:30:00+13:00 28 79.45
2015-03-20T14:00:00+13:00 29 79.23
2015-03-20T14:30:00+13:00 30 80.89
2015-03-20T15:00:00+13:00 31 81.14
2015-03-20T15:30:00+13:00 32 66.43
2015-03-20T16:00:00+13:00 33 81.76
2015-03-20T16:30:00+13:00 34 82.93
2015-03-20T17:00:00+13:00 35 81.54
2015-03-20T17:30:00+13:00 36 81.54
2015-03-20T18:00:00+13:00 37 82.49
2015-03-20T18:30:00+13:00 38 69.56
2015-03-20T19:00:00+13:00 39 63.94
2015-03-20T19:30:00+13:00 40 83.07
2015-03-20T20:00:00+13:00 41 91
2015-03-20T20:30:00+13:00 42 87.56
2015-03-20T21:00:00+13:00 43 84.08
2015-03-20T21:30:00+13:00 44 84.08
2015-03-20T22:00:00+13:00 45 87.88
2015-03-20T22:30:00+13:00 46 90.62
2015-03-20T23:00:00+13:00 47 91.39
2015-03-20T23:30:00+13:00 48 82
Raw
index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style>
.period, .keys rect {
stroke: grey;
stroke-width: 0.5;
}
.keys {
font-size: 11px;
}
body {
font: 10px Verdana, sans-serif;
}
</style>
<body>
<script src="//cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/es6-shim/0.27.1/es6-shim.min.js"></script>
<script>
d3.csv('hay2201_prices.csv', parse_csv, ready);
function parse_csv(d) {
return {
time: d3.time.format.iso.parse(d.Time),
period: +d.Period,
price: +d.Price
};
}
function ready(error, data) {
var square_size = 18;
var trading_periods = 48;
var colours = [
{ colour: '#d73027', threshold: 200 },
{ colour: '#f46d43', threshold: 150 },
{ colour: '#fdae61', threshold: 100 },
{ colour: '#fee08b', threshold: 75 },
{ colour: '#ffffbf', threshold: 50 },
{ colour: '#d9ef8b', threshold: 30 },
{ colour: '#a6d96a', threshold: 20 },
{ colour: '#66bd63', threshold: 10 },
{ colour: '#1a9850', threshold: 0 }
];
var days = d3.time.days.apply(null, d3.extent(data, function(d) { return d.time; }));
var time_scale = d3.scale.ordinal()
.domain(days)
.rangeBands([0, square_size * days.length]);
var y_axis = d3.svg.axis()
.scale(time_scale)
.orient('left')
.outerTickSize(0)
.tickFormat(function(d) { return d3.time.format('%d %b')(d); });
var trading_period = d3.scale.ordinal()
.domain(d3.range(1, trading_periods + 1))
.rangeBands([0, square_size * trading_periods]);
var x_axis = d3.svg.axis()
.scale(trading_period)
.orient('top')
.outerTickSize(0);
var svg = d3.select('body')
.append('svg')
.attr('width', 940)
.attr('height', 320);
var g = svg.append('g')
.attr('transform', 'translate(65, 30)');
g.append('g')
.call(y_axis);
g.append('g')
.call(x_axis);
var tooltip = g.append('text')
.attr('y', time_scale.rangeExtent()[1])
.attr('dy', 50);
var keys = g.append('g')
.classed('keys', true)
.attr('transform', 'translate(0,' + (time_scale.rangeExtent()[1] + 10) + ')')
.selectAll('g.key')
.data(colours)
.enter().append('g')
.classed('key', true)
.attr('transform', function(_, i) { return 'translate(' + (i * square_size * 5) + ',0)'; });
keys
.append('rect')
.attr('width', square_size * 2)
.attr('height', square_size)
.attr('fill', function(d) { return d.colour; });
keys
.append('text')
.attr('dy', square_size * 0.8)
.attr('x', square_size * 2.2)
.text(function(d) { return '≥ $' + d.threshold; });
g.append('g')
.classed('periods', true)
.selectAll('rect.period')
.data(data)
.enter().append('rect')
.classed('period', true)
.attr('width', square_size)
.attr('height', square_size)
.attr('x', function(d) { return trading_period(d.period); })
.attr('y', function(d) { return time_scale(d3.time.day(d.time)); })
.attr('fill', function(d) {
return colours.find(function(e) {
return d.price >= e.threshold;
}).colour;
})
.on('mouseover', display_price)
.on('mouseout', function() { tooltip.text(''); })
.append('title')
.text(text_format);
function display_price(d) {
tooltip.text(text_format(d));
}
function text_format(d) {
var time = d3.time.format('%Y-%m-%d %H:%M')(d.time),
period = d.period,
price = d3.format('$.2f')(d.price);
return 'Time: ' + time + ' Period: ' + period + ' Price: ' + price;
}
}
</script>
Raw
process.rb
#!/usr/bin/env ruby
require 'csv'
require 'time'
require 'net/http'
prices = []
today = Date.today
start_date = today - 14
end_date = today - 3
(start_date..end_date).each do |date|
date_formatted = date.strftime("%d/%m/%Y")
response = Net::HTTP.get("www.electricityinfo.co.nz", "/comitFta/ftaPage.download?pNode=HAY2201&pDate=#{date_formatted}")
csv = CSV.parse(response)
csv.shift(2)
rows = csv.map do |time, period, price|
[Time.parse("#{date} #{time}").iso8601, period, price].join(",")
end
prices.concat rows
end
File.open("hay2201_prices.csv", 'w') do |file|
file.puts "Time,Period,Price"
file.puts prices.join("\n")
end
puts "#{prices.count} prices from #{start_date} to #{end_date}"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment