Author

Topic: Top 20 days for Bitcoin - page 127. (Read 108140 times)

full member
Activity: 166
Merit: 101
January 05, 2017, 05:37:27 AM
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

The "classic" one had days older than 7 (or 10) fade from black to light grey, but still be thick type.  After another 7 (or 10) days the text for that date was presented in ordinary type.  So 4 categories in total: today, last week (or 10 days), last 2 weeks (or 20 days), and older.
legendary
Activity: 2940
Merit: 1333
January 05, 2017, 01:23:00 AM
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

Well, we really only have two "years": late 2013, early 2014, and late 2016, early 2017...
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: 1111
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: 1111
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
Jump to: