ref: This is English version of my previous posting https://steemit.com/coinkorea/@geniuskch/btc-1.
Crypto currency market had been keep fall these days. After the end of January, it was kind of a terrible period as to be called Black January for crypto currency investors.
During these bear market, few questions came up in my mind. So I gathered data and did simple exploratory data analysis.
The data I used on this is based on BTC Blocks of Feb. 2, 2018.
There are lots of ways to gather these kind of data, like traverse all BTC blocks, but website https://bitinfocharts.com provide excellent data so I just scraped this like below using Python. So if you want to know detailed information of each wallet addresses or stats of other coins then visit this site.
Q1. How many BTCs do they have?
o When I summed up their BTCs, they have 56.212597184670031% of whole BTCs.
o Based on the Coin Market Cap’s data, market capitalization of BTC is $146,260,172,649 on 2/3/2018, so their BTCs’ valuation is almost $82,216,641,692.785300701561821.
o For your reference, Google has market value of $698,994,000,000 on 2/8/2018.
Q2. What’s the assets of the most BTC-rich person?
o Wallet Address 16rCmCmbuWDhPjWTrpQGaU3EPdZF7MTdUk has 172,203 BTC which is 1.02% of whole BTCs. It’s almost $1,561,350,602.
o At 2016-02-28 03:00:09 is the first deposit time of this address.
Q3. Distribution of BTC of them.
o Some of them suprisingly has more than 100,000 BTCs, but most of them has less than 10,000 BTCs.
o The distribution is form of long tail so I set the log scale on the X axis, but it didn’t get much better.
Q4. Distribution of their investment period
o Histogram of [Today - the first deposited date of their addresses] in days
o Summary statistics of this
- The longest-standing account is almost 9 years old and the median is 1.5 years. Average period is half year, but I think it’s meaningless since the standard deviation of it is too large.
- An account became one of a high-rank account in a day. I guess he may received lots of BTCs from another accounts, in a day.
o Plotted year-based histogram. It shows same median value as above. (Around 1.5Y)
Q5. Is there any correlation between investment period and amount of BTCs?
o At first, I thought the people who got into this earlier have more BTCs. But It seems I don’t need to calculate correlation coefficient.
o Actually this data didn’t show the assets of individual but account status at the present time, the original question could be wrong.
Q6. Did they HODL in this bear market or sell it?
o After 1/6/18 which is the recent inflection point of the BTC chart, among 6.48% of 10,000 accounts has the record of withdrawal to somewhere.
o They weren’t the top 6.48% and their buying and selling has no patterns.
o The withdrawal destination might be another crypto exchange market and to be more accurate, I had to see their volume but it’s hard to say they took the lead of panic selling.
o Additionally, when I looked into the records of recent 7 days, only 3.41% of them withdrew from their account.
o And to conclude, almost of them still HODL their BTCs from 6 Jan. until now.
Q7. Did they buy BTCs in this bear market?
o (I don’t know whether it were buying from the market or mining but…) Were their any deposit on their account, when ordinary individual investors doing panic selling?
o During recent 7 days (after 28 Jan.), when ordinary investors doing panic selling the amount of BTCs of 22.46% of these account were increased.
For your reference, the wealthiest BTC holder’s recent transactions records are below.
These are not kind of fancy analysis or modeling. I just gathered some data and had a quick look with data visualization.
This is block ‘chain’, so just like as a ‘chain’, it might be interesting when I analyze this with graph analysis schemes.