Probably gonna take a few more months to complete but this is what I’ll be primarily focused on in early 2025. Recreating the UTXO sets at every block height, analyzing them to get these metrics and then animating all of that data. Right now I’ve got genesis to block 330k complete and some of the more recent blocks.

Hopefully I don’t melt my computer keeping it running 24/7 for this. 🫠

Reply to this note

Please Login to reply.

Discussion

Very cool!

I am looking forward to see it!

Amazing. What kind of software are you using to crunch these numbers? Was thinking of dabbling a bit in crunching some stats from the block data myself.

Started by building these massive postgres tables at the outputs level and then have been using python scripts to query and analyze them.

Gonna have to give that a try. The block data is a huge tresuretrove that people are be going to be revisiting long into the future. It is quite unique to have an underlying dataset which provides a timeseries that will never be interrupted and maintains perfect fidelity.

this is gonna be cool AF

Imagine keeping it updated until that orange line stair steps all the way down to 1 sat in 2136. 🤤

ur so bullish on Bitcoin scaling getting figured out šŸ¤

wait, I read that wrong. thought u were saying something about UTXO sizes

BUILD SOMETHING THAT LASTS

Can we talk about the nearly 450 bitcoin wasted creating the10s of millions of spam UTXOs (with values between 100 - 1k sats) that will all become economically unspendable in the future? šŸ™„

nostr:nevent1qvzqqqqqqypzpte0dqh4z2yes5kxv48lqed2gpdyr5279vwtdjghxy3kq46y7phxq90xsar5wpen5te0d9kkzem99ehx7um5wghxyatfd3jz7efsxdjnzdrxxajnyepj8ycrje33vvensdnzxfnrydmyxu6rjcesvfsk2ef4v9nrzce5xe3rscf5x43xzepj8p3xxvtyvycrvvp3x5ezu6nsvuqzpcy2m33zk2dsyx0s9u0nuklz95whq7h5f2vxkpturkyg3hdnnp97jl0jtm

That Rocks šŸ‘Š

Being off twitter I’ve missed these charts. Thanks for coming over and sharing here too.

Are we getting a Bitcoin anniversary timeline post soon?

I think I’ve run out of time to update that one but we’ll see. šŸ˜