Bitcoin Forum
May 25, 2024, 03:23:37 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Data mining the blockchain  (Read 2940 times)
agent13 (OP)
Newbie
*
Offline Offline

Activity: 26
Merit: 0


View Profile
September 28, 2013, 01:31:36 AM
Last edit: September 28, 2013, 01:50:49 AM by agent13
 #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
agent13 (OP)
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:  

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