Data

Bitcoin themed question today to celebrate the soon all time high price. 

Can someone calculate the current“realized capitalization” by taking all  UTXOs and valuing them by price at time of output? :)

@thorn goes into some detail on this here

head of research at galaxy, former VC at avon ventures, dir. blockchain research at fidelity alexthorn.com

headmaster @duneanalytics, previously mirror and consensys

data science @ coinbase                                


t0ny.base.eth

@thorn goes into some detail on this here https://twitter.com/intangiblecoins/status/1762865996447035600

Yup, you are right. I would basically take all outputs and get their spend date (setting it as 2099 if not spent). Then I would join it on a sequence of “weeks”, and get all outputs where the spend date > week. 

Then multiply by price at time of output, and sum by week. I’m pretty sure it should run on large.

the tough part is adjusting for inputs right? so you have to take the spent_tx_id from bitcoin.inputs, use its date and calculate realized value from that. i wonder if dune could even handle, there's about 1 million inputs per day that will each be looking up a custom value. and then you need to do that for 15 years