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

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

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.

But this is part of my daily bytelight questions where bytexplorers earn tokens for answering questions, so I will let the community take a stab at answering first ;)