Author

Topic: Top 20 days for Bitcoin - page 139. (Read 111801 times)

legendary
Activity: 2940
Merit: 1333
January 05, 2017, 01:21:56 AM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
3  2017-01-04  1088.45
 4  2013-11-29  1065.36
 5  2013-12-03  1050.57
6  2017-01-03  1020.56
7  2017-01-02  1013.00
 8  2013-12-02  1000.49
 9  2013-11-28   998.56
10  2017-01-01   987.47
11  2013-12-05   975.06
12  2016-12-29   967.02
13  2016-12-28   955.98
14  2016-12-31   955.73
15  2016-12-30   951.07
16  2013-12-01   945.67
17  2013-12-10   941.56
18  2013-11-27   937.09
19  2014-01-06   936.62
20  2016-12-27   922.42

legendary
Activity: 2101
Merit: 1061
January 04, 2017, 05:02:41 PM
Very cool. Was thinking it might be nice to have different years have diff color font to help visualisation a little bit.. But anyway interesting way to look at the price. Thanks
legendary
Activity: 2940
Merit: 1333
January 04, 2017, 02:20:41 PM
Today may become top 4 or 3

We'll see...

I scripted the report generation. Until now I was doing it by hand each day.

Here's the top 100 volume weighted daily prices:


  1  2013-11-30  1132.29
  2  2013-12-04  1111.56
  3  2013-11-29  1065.36
  4  2013-12-03  1050.57
 5  2017-01-03  1020.56
 6  2017-01-02  1013.00
  7  2013-12-02  1000.49
  8  2013-11-28   998.56
 9  2017-01-01   987.47
 10  2013-12-05   975.06
11  2016-12-29   967.02
12  2016-12-28   955.98
13  2016-12-31   955.73
14  2016-12-30   951.07
 15  2013-12-01   945.67
 16  2013-12-10   941.56
 17  2013-11-27   937.09
 18  2014-01-06   936.62
19  2016-12-27   922.42
20  2016-12-24   900.20
21  2016-12-26   898.97
22  2016-12-23   897.77
 23  2013-12-06   894.36
 24  2013-12-11   890.42
 25  2014-01-11   883.00
 26  2013-12-13   882.99
 27  2014-01-05   881.82
28  2016-12-25   874.03
 29  2013-12-09   867.49
 30  2013-12-12   862.85
 31  2013-12-14   860.41
 32  2014-01-12   858.24
 33  2014-01-07   857.96
34  2016-12-22   855.94
 35  2013-11-26   849.32
 36  2013-12-15   838.37
 37  2014-01-15   837.66
 38  2013-11-23   832.85
 39  2014-01-20   831.00
 40  2014-01-10   829.44
 41  2014-01-16   828.18
 42  2014-01-21   821.57
 43  2014-01-19   821.41
 44  2014-01-14   821.00
 45  2014-01-26   819.29
 46  2014-02-02   818.22
47  2016-12-21   816.48
 48  2014-02-01   815.29
 49  2014-01-09   815.29
 50  2014-01-13   814.71
 51  2014-01-22   814.24
 52  2014-01-04   814.07
 53  2014-01-23   811.40
 54  2014-01-08   809.64
 55  2014-02-03   808.55
 56  2014-01-18   808.12
 57  2013-11-25   807.80
 58  2014-02-04   803.25
 59  2014-01-31   801.74
 60  2014-01-03   798.57
 61  2014-01-25   796.79
 62  2014-02-05   796.18
 63  2014-01-17   795.31
 64  2013-11-24   795.08
 65  2014-01-30   794.78
 66  2014-01-29   794.65
67  2016-12-20   793.38
68  2016-12-19   791.41
69  2016-12-18   787.21
 70  2014-01-24   786.70
71  2016-12-17   786.01
 72  2014-01-28   781.56
73  2016-12-16   778.66
74  2016-12-13   778.31
75  2016-12-14   776.73
76  2016-12-15   776.63
 77  2014-01-27   776.44
78  2016-12-12   775.18
 79  2014-02-06   774.92
80  2016-12-10   772.55
81  2016-12-09   770.33
 82  2014-01-02   768.67
83  2016-12-08   768.16
84  2016-12-11   767.68
85  2016-12-02   766.70
86  2016-12-03   762.58
87  2016-12-07   762.03
88  2016-12-04   758.91
89  2016-12-06   755.27
90  2016-06-19   754.72
91  2016-06-18   753.96
92  2016-12-05   749.99
93  2016-12-01   749.47
94  2016-11-19   748.08
 95  2014-01-01   745.45
96  2016-11-18   744.66
97  2016-11-17   744.08
 98  2013-11-22   743.65
99  2016-06-20   741.90
100  2016-11-22   741.88


bitcoincharts.com seems to be working again. It has $1013.00 for the #6 price on 2017-01-02, whereas the other site says $1013.01. I'll be switching back to the bitcoincharts.com prices from today.

Edit: here's the (bash) script I wrote that generates these reports:

Code:
vwap() {
    days=1200
    top=20
    rows=$(wget -o/dev/null -O- "http://bitcoincharts.com/charts/chart.json?m=bitstampUSD&r=$days&i=Daily" |
                  sed 's/], \[/\n/g'   |
                  head -n $((days-1))  |
                  tr -d '[],'          |
                  awk '{print $1, $8}' |
                  sort -k2nr           |
                  head -$top
        )
    newest=$(echo "$rows" | sort -n | tail -1 | awk '{print $1}')
    printf "Update:\n[pre]\n"
    n=1
    echo "$rows" |
        while read t p
        do
            if ((t > 1400000000)); then b1="[b]"            ; b2="[/b]"    ; else b1=""; b2=""; fi
            if ((t == newest))   ; then c1="[color=#7F0000]"; c2="[/color]"; else c1=""; c2=""; fi
            printf "%s%s%2d  %s  %7.2f%s%s\n" "$b1" "$c1" $n "$(TZ= date -d @$t +%Y-%m-%d)" $p "$c2" "$b2"
            ((n++))
        done
    printf "[/pre]\n"
}
legendary
Activity: 1792
Merit: 1121
January 04, 2017, 09:25:36 AM
Today may become top 4 or 3
legendary
Activity: 2940
Merit: 1333
January 03, 2017, 07:51:43 PM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
5  2017-01-03  1020.56
6  2017-01-02  1013.01
 7  2013-12-02  1000.49
 8  2013-11-28   998.56
9  2017-01-01   987.47
10  2013-12-05   975.06
11  2016-12-29   967.02
12  2016-12-28   955.98
13  2016-12-31   955.73
14  2016-12-30   951.07
15  2013-12-01   945.67
16  2013-12-10   941.56
17  2013-11-27   937.09
18  2014-01-06   936.62
19  2016-12-27   922.42
20  2016-12-24   900.20

full member
Activity: 166
Merit: 101
January 03, 2017, 09:35:29 AM
legendary
Activity: 2940
Merit: 1333
January 02, 2017, 07:12:47 PM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
5  2017-01-02  1013.01
 6  2013-12-02  1000.49
 7  2013-11-28   998.56
8  2017-01-01   987.47
 9  2013-12-05   975.06
10  2016-12-29   967.02
11  2016-12-28   955.98
12  2016-12-31   955.73
13  2016-12-30   951.07
14  2013-12-01   945.67
15  2013-12-10   941.56
16  2013-11-27   937.09
17  2014-01-06   936.62
18  2016-12-27   922.42
19  2016-12-24   900.20
20  2016-12-26   898.97


Looking back, the most recent day used to be distinguished (dark red colour), which was nice.  Any chance of having that again?

Sure!
legendary
Activity: 2842
Merit: 1511
January 02, 2017, 09:30:38 AM
If it closes now today should be #5

Seems that way now. Is Bitcoin dead?  Wink
full member
Activity: 166
Merit: 101
January 02, 2017, 06:18:44 AM
Looking back, the most recent day used to be distinguished (dark red colour), which was nice.  Any chance of having that again?
legendary
Activity: 1792
Merit: 1121
January 02, 2017, 05:44:30 AM
If it closes now today should be #5

2013: 7th highest 10 days after breaking into top 20, with 8 days in top 20.
2016: 7th highest 10 days after breaking into top 20, with 9 days in top 20.

Looks like today could also be #4, which would be a carbon copy of 2013.
legendary
Activity: 2842
Merit: 1511
January 02, 2017, 01:02:13 AM
2013: 7th highest 10 days after breaking into top 20, with 8 days in top 20.
2016: 7th highest 10 days after breaking into top 20, with 9 days in top 20.

Looks like today could also be #4, which would be a carbon copy of 2013.
legendary
Activity: 1512
Merit: 1012
January 01, 2017, 09:25:24 PM
According to BitcoinWisdom Bitstamp high for the 1st Jan was 1005$ at 23:00.

Right, but this thread is logging the "volume weighted average price" for each day. A single small trade at 1005 is enough to put the high at 1005. I think the volume weighted average is a more useful indicator of the "real" price for the day.

Edit: The VWAP is where you multiply each trade's price in USD by its volume in BTC, add them all up, and divide the total by the total volume in BTC for the day. That way big trades have more effect on the VWAP than small trades, as they should.

All right. Excuse me, I've just stumbled upon this thread and didn't really pay attention...
legendary
Activity: 2940
Merit: 1333
January 01, 2017, 09:20:56 PM
According to BitcoinWisdom Bitstamp high for the 1st Jan was 1005$ at 23:00.

Right, but this thread is logging the "volume weighted average price" for each day. A single small trade at 1005 is enough to put the high at 1005. I think the volume weighted average is a more useful indicator of the "real" price for the day.

Edit: The VWAP is where you multiply each trade's price in USD by its volume in BTC, add them all up, and divide the total by the total volume in BTC for the day. That way big trades have more effect on the VWAP than small trades, as they should.
legendary
Activity: 1512
Merit: 1012
January 01, 2017, 09:07:35 PM
According to BitcoinWisdom Bitstamp high for the 1st Jan was 1005$ at 23:00.
legendary
Activity: 2940
Merit: 1333
January 01, 2017, 08:50:45 PM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
 5  2013-12-02  1000.49
 6  2013-11-28   998.56
7  2017-01-01   987.47
 8  2013-12-05   975.06
9  2016-12-29   967.02
10  2016-12-28   955.98
11  2016-12-31   955.73
12  2016-12-30   951.07
13  2013-12-01   945.67
14  2013-12-10   941.56
15  2013-11-27   937.09
16  2014-01-06   936.62
17  2016-12-27   922.42
18  2016-12-24   900.20
19  2016-12-26   898.97
20  2016-12-23   897.77


I used quandl.com since bitcoincharts.com seems to be broken.
legendary
Activity: 2940
Merit: 1333
January 01, 2017, 08:14:28 PM
Does anyone know where to find the daily bitstamp volume weighted average price? BitcoinCharts.com seems to have stopped updating about 8 hours ago.
legendary
Activity: 2940
Merit: 1333
December 31, 2016, 07:43:22 PM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
 5  2013-12-02  1000.49
 6  2013-11-28   998.56
 7  2013-12-05   975.06
8  2016-12-29   967.02
9  2016-12-28   955.98
10  2016-12-31   955.73
11  2016-12-30   951.07
12  2013-12-01   945.67
13  2013-12-10   941.56
14  2013-11-27   937.09
15  2014-01-06   936.62
16  2016-12-27   922.42
17  2016-12-24   900.20
18  2016-12-26   898.97
19  2016-12-23   897.77
20  2013-12-06   894.36
legendary
Activity: 2940
Merit: 1333
December 30, 2016, 11:31:08 PM
Update (thanks jl2012 for stepping up yesterday when I forgot):

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
 5  2013-12-02  1000.49
 6  2013-11-28   998.56
 7  2013-12-05   975.06
8  2016-12-29   967.02
9  2016-12-28   955.98
10  2016-12-30   951.07
11  2013-12-01   945.67
12  2013-12-10   941.56
13  2013-11-27   937.09
14  2014-01-06   936.62
15  2016-12-27   922.42
16  2016-12-24   900.20
17  2016-12-26   898.97
18  2016-12-23   897.77
19  2013-12-06   894.36
20  2013-12-11   890.42
legendary
Activity: 1792
Merit: 1121
December 29, 2016, 11:17:45 PM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
 5  2013-12-02  1000.49
 6  2013-11-28   998.56
 7  2013-12-05   975.06
8  2016-12-29   967.02
9  2016-12-28   955.98
10  2013-12-01   945.67
11  2013-12-10   941.56
12  2013-11-27   937.09
13  2014-01-06   936.62
14  2016-12-27   922.42
15  2016-12-24   900.20
16  2016-12-26   898.97
17  2016-12-23   897.77
18  2013-12-06   894.36
19  2013-12-11   890.42
20  2014-01-11   883.00
legendary
Activity: 2940
Merit: 1333
December 28, 2016, 09:04:49 PM
Update:

 1  2013-11-30  1132.29
 2  2013-12-04  1111.56
 3  2013-11-29  1065.36
 4  2013-12-03  1050.57
 5  2013-12-02  1000.49
 6  2013-11-28   998.56
 7  2013-12-05   975.06
8  2016-12-28   955.98
 9  2013-12-01   945.67
10  2013-12-10   941.56
11  2013-11-27   937.09
12  2014-01-06   936.62
13  2016-12-27   922.42
14  2016-12-24   900.20
15  2016-12-26   898.97
16  2016-12-23   897.77
17  2013-12-06   894.36
18  2013-12-11   890.42
19  2014-01-11   883.00
20  2013-12-13   882.99


Feels good to see this being updated after 3 years  Cool

Yeah!
Jump to: