piuk, do you think you could add a chart that plots what can be seen here?:
http://statistics.ecdsa.org/There's no need for the animation, a static current chart would do.
Can do. But what is the definition of unspent? Literally the value of coinbase transactions which have never been spent?
Yeah, it means the bitcoins that were only issued and not moved since. All the bitcoins that moved since their issuance you plot on the graph when they must the last time.
Or in other words: The coinbase transaction creates coins at a certain block chain height. Every other transaction moves them to a new block chain height.
block 100: coinbase 50Ƀ -> A (add 50Ƀ to "100")
block 200: 50Ƀ of A -> 29Ƀ to A, 10Ƀ to B, 10Ƀ to C (ignore input to A, B, C, fee. Just remove 50Ƀ from "100" and add them to "200")
block 300: 10Ƀ of B -> X, Y (Move the 10Ƀ of B from "200" to "300")
The graph shows, when coins move that were moved last at a certain time. It gives a very interesting insight beyond your bitcoin hours destroyed. For example you can see how in 07/2011 many addresses received coins that were not moved ever since. Unfortunately the y-axis is clipped and not log
Combine this chart with the bitcoin price and you get insights on how people that bought/earned/mined coins at $17 are willing to sell/spend/… at $4 for example as you can see how specific regions melt off over time. Also see for example how the very early blocks get spent 10% in parallel during the 2011 sell offs, while the newer coins are not touched that much. This implies that at least the owners of these coins know each other and coordinated their sale or it was just one of the 10% miners of the first year that moved all his coins.
I hope you find the time to also make an animated version of this chart with even higher granularity as this is at least great fun to speculate about
Also congrats to you and your 100k wallets
Edit: I would remove the green (more or less constant) and red (redundant) lines, use a log scale, and draw the initial value of each bar green, coins that moved last week red, last month blue, last year yellow, earlier black. So for each pixel that you book from "100" to "200" you don't delete it at "200" but turn it red, one week later you turn it blue, …
Edit: Ha! You can make it static! Draw all inputs + coinbase black and mark pixels with the time stamp that they got removed at. Removed following
4 years,
2 years,
1 year,
6 months,
3 months,
6 weeks,
3 weeks,
10 days,
5 days,
2 days, … Edit: Downside would be that pixels one year before the latest block get a different color than younger coins, so relation is harder to read.
I give up
Without animation I see no chance to accurately give insights for all the history.
Very readable would be the inverse of this last suggestion. Draw the "now" bar green, the yesterday-bar blue (for the input), the next 2 red (for the input), … and if you moved value from yesterday to now, color a respective part of "yesterday" in today's color green. This way I could quickly see at which time frames coins were last moved that go into today's, last week's, last month's, … transactions. To analyse which coins went into January 5ths transaction I would need to change the point of reference though as I could not distinguish coins from the day before from coins from 4 days before.