Bitcoin Forum
November 01, 2024, 09:08:45 PM *
News: Bitcoin Pumpkin Carving Contest
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Fact sheet for bitcoin price (daily low, high, close price over years)  (Read 326 times)
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
October 09, 2020, 04:57:08 AM
Last edit: October 10, 2020, 04:59:37 AM by tranthidung
Merited by JayJuanGee (1), Tytanowy Janusz (1)
 #1

  • In 3 types of median,2 types of min, p25 and p75 of daily low price BTC is in its uptrend.
  • Look at p25, p75. If you buy BTC in price from $ 4155 to $10037 in years between 2018 till now, you are fine.
  • If you bought BTC at a bit higher price than the lowest in a weak-down in March, you are fine
  • Next target of BTC would be somewhere around $12300 (max_h)

Congratulations to all bitcoiners!  Cheesy



Data source:

Variable notes:
  • Medians
    • median_l: Median of daily low price over year
    • median_h: Median of daily high price over year
    • median_c: Median of daily close price over year
  • min_c: Minimum of daily close price over year
  • max_c: Maximum of daily close price over year
  • min_l: Minimum of daily low price over year (Lowest over year)
  • max_h: maximum of daily high price over year (Highest over year
  • p25l: p25 quantile of daily low price over year
  • p75l: p75 quantile of daily low price over year


Raw data:
Code:
    +------------------------------------------------------------------------------------------------------+
     | year   median_l   median_h   median_c     min_c      max_c     min_l      max_h      p25l       p75l |
     |------------------------------------------------------------------------------------------------------|
  1. | 2013      124.7      129.9     127.04     68.43    1151.17     65.53    1156.14       104     199.97 |
  2. | 2014     489.73     516.16      502.5    310.74     953.29     289.3    1017.12    382.25      609.1 |
  3. | 2015     244.13     254.69     249.01     178.1     465.32    171.51     495.56    231.09     281.01 |
  4. | 2016    575.315     588.96    582.555    364.33     975.92    354.91      979.4    427.09      653.7 |
  5. | 2017    2510.48    2682.26    2589.41    777.76    19497.4    755.76      20089   1172.61    4377.46 |
     |------------------------------------------------------------------------------------------------------|
  6. | 2018    6747.98    7109.56    6906.92   3236.76      17527    3191.3    17712.4   6310.11    8360.62 |
  7. | 2019    7583.22    8047.41    7824.23   3399.47   13016.23   3391.02   13796.49   4155.32    9411.52 |
  8. | 2020   9221.055    9445.61    9324.99   4970.79    12254.4   4106.98   12359.06   8329.57   10037.07 |
     +------------------------------------------------------------------------------------------------------+

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Tytanowy Janusz
Legendary
*
Offline Offline

Activity: 2156
Merit: 1622


View Profile
October 09, 2020, 05:12:24 PM
Merited by tranthidung (1)
 #2



In the meantime bitcoin "has died 382 times". Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.
ChrisPop
Legendary
*
Offline Offline

Activity: 2310
Merit: 1035

Not your Keys, Not your Bitcoins


View Profile
October 09, 2020, 05:20:11 PM
 #3

In the meantime bitcoin "has died 382 times". Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.

Exactly, man. I see a very big confusion between people who do trading. Every person should be clear about their goal. The philosophy is simple. If you're a long-term investor don't look at below Monthly timeframes. That's a waste of your time. Go relax, spend time with friends & family or follow any other passion you have. Time is the scarcest resource, please don't waste it.

Conversely, if you're a day-trader, looking at a weekly time-frame won't do you any good. Smiley
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
October 10, 2020, 02:38:27 AM
Last edit: October 10, 2020, 07:12:02 AM by tranthidung
Merited by JayJuanGee (1)
 #4

In the meantime bitcoin "has died 382 times". Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.
People who say bitcoin has died belong to 2 types:
  • Type I: They hate bitcoin and feel jealously with bitcoiners who are believe in bitcoin (its technology, decentralization and future). They also want to invest in BTC but always feel fear and never actually buy BTC. They simply watch, regret and repeat it many times.
  • Type II: Investors who often buy BTC at peaks, all-time-high and make panic sells when BTC crashes or corrects
They are failured guys. Ignore them.
The plot is for type II investors.  Undecided

I created another plot with p25 and p75 for daily low price over years. The range between p25 and p75 represents 50% of daily low price over all days are observed inthe period. It is in upward trend too.
The raw data in OP shows if you buy BTC in price from $ 4155 to $10037 in years between 2018 till now, you are fine.  Tongue

Exactly, man. I see a very big confusion between people who do trading. Every person should be clear about their goal. The philosophy is simple. If you're a long-term investor don't look at below Monthly timeframes. That's a waste of your time. Go relax, spend time with friends & family or follow any other passion you have. Time is the scarcest resource, please don't waste it.

Conversely, if you're a day-trader, looking at a weekly time-frame won't do you any good. Smiley
Your statement is all true and I'd prefer to add one more thing: Even you are long term investor or day-trader, you should look at wider time-frame in order to know what's going on in the market battle field. If a day-trader solely and always look at 5-min/ 15-min charts, they will be stucked in very shadow field and they can be killed by crashes. Look wider can help them have better look and make estimation on whether crashes will happen soon and when.

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Tytanowy Janusz
Legendary
*
Offline Offline

Activity: 2156
Merit: 1622


View Profile
October 10, 2020, 04:39:34 PM
Merited by JayJuanGee (1)
 #5

  • Type I: They hate bitcoin and feel jealously with bitcoiners who are believe in bitcoin (its technology, decentralization and future). They also want to invest in BTC but always feel fear and never actually buy BTC. They simply watch, regret and repeat it many times.

Yes. I've heard it many times. They are always looking for the dip to buy and every dip is not dip enough or too big(bitcoin going to 0 fear). They are always frightened about fluctuation. Well I would rather like to sit on this:



than this:



pixie85
Hero Member
*****
Offline Offline

Activity: 2184
Merit: 531


View Profile
October 10, 2020, 06:16:36 PM
 #6

The question arises, is there a fall now? Or is it still slow growth?

I'd call that a stabilization.

Both the lowest and the highest yearly values are coming closer with each year which means that Bitcoin is looking for a stable line or at least a channel to say in.
The recent 9-12 thousand channel that we've been in for over 5 months is confirming this.
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
October 12, 2020, 05:27:44 PM
Last edit: October 13, 2020, 03:52:07 AM by tranthidung
Merited by JayJuanGee (1), Stedsm (1)
 #7

Yearly low price of bitcoin:



  • During the period of almost 8 years, the lowest yearly price of BTC has 7 years with increase (positive in percent_change), only has 1 year with a fall (negative in percent_change, at -40.7 % in 2015).
  • Min and max percent of increase is 6.3% (2019) and 341.5% (2014).
  • Also, see median_l, p25l and p75l (in statistics and in chart) to see the continuous growth (yearly low price) of bitcoin
  • Make double check with another dataset from 2010 to 2020 that I made in WO

Raw results:
Code:
     +---------------------------------+
     | year     min_l   percent_change |
     |---------------------------------|
  1. | 2013     65.53                . |
  2. | 2014     289.3           341.48 |
  3. | 2015    171.51           -40.72 |
  4. | 2016    354.91           106.93 |
  5. | 2017    755.76           112.94 |
     |---------------------------------|
  6. | 2018    3191.3           322.26 |
  7. | 2019   3391.02             6.26 |
  8. | 2020   4106.98            21.11 |
     +---------------------------------+


If you take 2015 out of the equation and the short timespan during which BTC has been past $12k, all you're left with is mostly pure profit and every year has been a new high. Even if you had invested once per month ever since BTC was >$12k, you still would've had a profit today as the price crashed a few times.

@20kevin20,

I used medians to exclude all extreme values or outliers from pumps or dumps. Please look at the details in OP. Here, I give you charts only. The first chart is very very bullish.  Cheesy


▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
20kevin20
Legendary
*
Offline Offline

Activity: 1134
Merit: 1598


View Profile
October 12, 2020, 05:44:47 PM
Merited by JayJuanGee (1)
 #8

Besides 2015 when Bitcoin and crypto in general seemed to be on the real brink of death having their worst year, today the markets look better than ever before imo - possibly being even highly undervalued.

But it's very, very hard to convince someone that they should head for a long term vision and not be led by short radical market movements. If you take 2015 out of the equation and the short timespan during which BTC has been past $12k, all you're left with is mostly pure profit and every year has been a new high. Even if you had invested once per month ever since BTC was >$12k, you still would've had a profit today as the price crashed a few times.

It all goes down to your own vision over the market.
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
November 23, 2020, 09:19:10 AM
 #9

Update for the uncertainty period:

This post is not made to say you buy or long bitcoin, just a fact and visual chart!

With 2765 observed days (from 29 Apr 2013 to 22 Nov 2020), there are only 5 days that have daily high price are higher than the yearly-high-price in 2020 at $18936.62

Those 4 days account for 0.14% whilst the rest of 2761 days account for 99.86%. In the long run, most of people are in profit even they are FOMO. Exceptions for people who are FOMOed in the 4 days: 4 days from 16 Dec 2017 to 19 Dec 2017
Code:
      +----------------------+
      |      date       high |
      |----------------------|
1693. | 16dec2017    19716.7 |
1694. | 17dec2017      20089 |
1695. | 18dec2017      19371 |
1696. | 19dec2017    19177.8 |


▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
January 03, 2021, 10:44:24 AM
 #10

Today is the anniversary day for Bitcoin's genesis block. Let's me use this remarkable day to make a plot for Bitcoin close price on 3Jan-dates. There are 2 exceptions: in 2013 and in 2021. Data from coinmarketcap.com in 2013 is from 29 Apr 2013, and this year, the date 3 Jan 2021 has not yet ended.


What a growth!

You can also look at price history for yearly low price in previous post.


▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Welsh
Staff
Legendary
*
Offline Offline

Activity: 3304
Merit: 4115


View Profile
January 03, 2021, 11:06:22 PM
Merited by JayJuanGee (1)
 #11

In the meantime bitcoin "has died 382 times". Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.
Honestly, this is quite common to see. People are way to irrational, and reactionary to really have any weight behind something as volatile as Bitcoin. This is proven in some sense, to supporting sports, and how a loss is suddenly a massive deal. Its the same as Bitcoin, has its "losses", and has its winning streaks, and no matter what statistical data you show, there will always be people who claim Bitcoin has died, despite proving time, and time again its actually moving in a upward trend in the long term. 
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
January 04, 2021, 08:02:34 AM
 #12

Its the same as Bitcoin, has its "losses", and has its winning streaks, and no matter what statistical data you show, there will always be people who claim Bitcoin has died, despite proving time, and time again its actually moving in a upward trend in the long term.  
Streaks, I have it for both rise and fall streaks. Below is the part of table for 2020-streaks.

In the last year (2020), there are 10 streaks in total (with my streak definition is for 5+-days at least to be considered as a streak) and only 2 of them (20%) are Fall streaks. The rest 8 streaks (80%) are all Rise streaks. The last streak (also a rise) is lasting since late 2020 till early days of 2021 (yesterday) and might continue if bitcoin can bounce well today after dip few hours ago.

50% of 8 rise streaks have their duration (longevity) last from 6 to 8 days (I have to round the raw results) with the median is at 6 days. The shortest and longest rise streaks are 5 and 9 days, respectively.

50% of 8 rise streaks have changes (in %) range from 12.3% to 26.3% with the median is at 16.9%. The smallest and largest streaks are 8.8% and 32.2%, respectively.

Raw results
Code:
    variable |         N      mean        sd       p50       p25       p75       min       max
-------------+--------------------------------------------------------------------------------
         dur |       8.0       6.5       1.4       6.0       5.5       7.5       5.0       9.0
----------------------------------------------------------------------------------------------

    variable |         N      mean        sd       p50       p25       p75       min       max
-------------+--------------------------------------------------------------------------------
       poc_s |       8.0      19.0       8.4      16.9      12.3      26.3       8.8      32.2
----------------------------------------------------------------------------------------------

More details:

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Tstar
Legendary
*
Offline Offline

Activity: 1176
Merit: 1005


Decentralized Asset Management Platform


View Profile
January 04, 2021, 09:50:47 PM
 #13

Excellent data compilation, thanks.

I like how stable is the Min of close price in the second graph. This shows us that the price is steadily rising even the fluctuations.

███████████████████████████
████▄▀▀▀███████████████████
█████▄    ▀▀▀██████████████
██████▄▄       ▀▀▀█████████
███████▀██▄▄        ▀▀█████
████████   ▀▀▀      ▄██████
█████████▄▄       ▄████████
█████████  ▀▀   ▄██████████
██████████    ▄████████████
███████████ ▄██████████████
███████████████▀▀▀▀▀▀▀▀████
████▄▄▄▄▄▄▄▄▄      ▄▄██████
███████████████████████████
.
.COOK.
     Decentralized Asset Management Platform     
│▐ █     WHITEPAPER   │   TWITTER   │   LINKEDIN   │   TELEGRAM     █ ▌│
          ▄▄███████▄▄
 ▄▄▄▄▄▄▄▄██████▀▀█████▄▄
███████████████▄▄█▀██████

█████████████████████████
██▀▀▀▀▀█████████████████
██▀▀▀▀▀▀████████████████
██▄▄▄▄▄▄▄█▀▀███████▀███▄█
█████████████████████▀███▄
██▀▀▀▀▀▀▀▄▄▄▄▀▀▀▀▀▀▀▀▀███▄
▀█████████████▀█████████▀▀▀
       ██ ▀█▀ ▄██
       ▀██▄ ▄███▀
        ▀▀████▀▀
✔  Accessible
✔  Secure
✔  Transparent
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
January 05, 2021, 05:50:53 AM
 #14

Excellent data compilation, thanks.
You are welcome. It is my love to do this as I am stats enthusiast.

Quote
I like how stable is the Min of close price in the second graph. This shows us that the price is steadily rising even the fluctuations.
Truly it is.

This fact (growth of bitcoin price) is also reflected through the yearly lowest price. Check details (stats and charts) there. Despite of some ups and downs, the yearly lowest price almost rises in 2 consecutive years. The exception is year 2015, when price ($171.51) has -40.7% compares to yearly lowest price in 2014 ($289.3)

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
tranthidung (OP)
Legendary
*
Offline Offline

Activity: 2450
Merit: 4273


Farewell o_e_l_e_o


View Profile WWW
August 17, 2021, 08:45:32 AM
Last edit: August 17, 2021, 03:49:20 PM by tranthidung
Merited by JayJuanGee (1)
 #15

After half of a year, I am back.  Cheesy

  • Data source: https://coinmarketcap.com/currencies/bitcoin/historical-data/
  • Here is use Daily Close price for calculations
  • Yearly Highest price: Highest price of Daily Close price each year
  • Yearly Lowest price: Lowest price of Daily Close price each year
  • Yearly Median price: Median price of Daily Close price each year


Conclusions
  • Generally, Bitcoin is bullish in all three charts, especially if you look at charts for Yearly Lowest price or Yearly Median price
  • Death cross, who care about it because each year, Bitcoin moves upward in its bullish ride
  • Death crosses, dips, crashes are chances for you to do accumulation and Dollar Cost Averaging (DCA) [1]

[1] https://dcabtc.com/

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!