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? :)

headmaster @duneanalytics, previously mirror and consensys

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

stuff like this is why i would love for dune to have the option to snapshot calculations up to a date and only have to run the full set once.