Query editor
WITH xe AS (SELECT x.day, x.unspent_amount, x.price, x.age_days,COALESCE(x.price, (SELECT x0.price FROM dune.dempsey.result_utxo_unspent x0 WHERE x0.DAY=(SELECT MIN(day) FROM dune.dempsey.result_utxo_unspent WHERE price IS NOT NULL))) AS price_extraFROM dune.dempsey.result_utxo_unspent x),roll AS (SELECT xe.day, xe.unspent_amount, xe.price_extra,xe.unspent_amount*xe.price_extra AS realized_value,SUM(xe.unspent_amount) OVER (ORDER BY xe.day) AS total_unspent_amount,SUM(xe.unspent_amount*xe.price_extra) OVER (ORDER BY xe.day) AS total_realized_valueFROM xe)SELECT roll.*, roll.price_extra AS price_USD, roll.total_unspent_amount*roll.price_extra AS market_value,roll.total_realized_value/roll.total_unspent_amount as realzd_price_USD,(roll.total_unspent_amount*roll.price_extra)/roll.total_realized_value as mv_rvFROM roll ORDER BY roll.day