Bitcoin Forum
September 27, 2018, 10:12:51 PM *
News: ♦♦ New info! Bitcoin Core users absolutely must upgrade to previously-announced 0.16.3 [Torrent]. All Bitcoin users should temporarily trust confirmations slightly less. More info.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Data mining the blockchain  (Read 2857 times)
agent13
Newbie
*
Offline Offline

Activity: 26
Merit: 0


View Profile
September 28, 2013, 01:31:36 AM
 #1

The graphs here depict when newly generated coins first moved (up to block 250000). The Y axis is the mtgox weighted value for that day, with the X axis being the block number from where the coinbase originated. For example, X starts at block 9 which contains Satoshi's address 12cbQLTFMXRnSzktFkuoG3eHoMeFtpTu3S. These coins were first redeemed in block 170. We are not interested in block 170, but rather that it contains a transaction with an input from a coinbase.

Horizontal lines in the graph usually indicate redemption of coinbases within a single transaction (or nearby transaction/s). Redemption does not necessarily equal coin ownership, however coinbase spends are something I find interesting to plot.

Density is difficult to display due to the size of the data set. The red selection (blocks 180000 - 220000, < $40) is shown in the second graph.

It would appear that coinbases were redeemed more quickly from 2011 onwards. Perhaps this is due to pools having to pay their miners.

Click for full size images -
http://www.filedump.net/dumped/graph2xx1380330890.png
http://www.filedump.net/dumped/graph31380330890.png

http://i41.tinypic.com/15ob71v.png
1538086371
Hero Member
*
Offline Offline

Posts: 1538086371

View Profile Personal Message (Offline)

Ignore
1538086371
Reply with quote  #2

1538086371
Report to moderator
Make a difference with your Ether.
Donate Ether for the greater good.
SPRING.WETRUST.IO
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
agent13
Newbie
*
Offline Offline

Activity: 26
Merit: 0


View Profile
September 28, 2013, 01:47:07 AM
 #2

reserved
bitx64
Newbie
*
Offline Offline

Activity: 28
Merit: 0


View Profile
September 29, 2013, 04:31:55 AM
 #3

What tools are you using? Interested in sharing your code?
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!