BTC: SOPR by Age
Shown as its 2019–2022 sample; the latest readings and full history are included with Pro.
The spent output profit ratio of the coins spent each day from each age band: what they were spent at divided by what they cost.
Why use it. Shows which holding periods are selling into gains and which at a loss; old coins spent at a large profit and young coins spent at a loss mark different market phases. How to read it. Above 1 the band's spent coins were in profit, below 1 at a loss. A band with no coins spent that day has no value.
Calculation. For each band: the sum of each spent coin x the price at the start of the day it was spent, divided by the sum of each spent coin x its creation-day price. A coin's age is counted in whole UTC days: the reporting day minus the UTC day its output was created, by block header time. The bands are: under 1 day (created that same day), 1 day to 1 week (1 to 6 days), 1 week to 1 month (7 to 29 days), 1-3 months (30 to 89), 3-6 months (90 to 179), 6-12 months (180 to 364), 1-2 years (365 to 729), 2-3 years (730 to 1,094), 3-5 years (1,095 to 1,824), 5-7 years (1,825 to 2,554), 7-10 years (2,555 to 3,649), 10-15 years (3,650 to 5,474) and 15 years or more. Because ages are counted in whole days rather than hours, a coin near a band edge can sit in the neighbouring band for up to a day. A spent coin's sale value is the BTC/USD price at the start of the UTC day it was spent and its cost the price at the start of the day it was created, the site's SOPR convention; a spend is in profit when the first is higher and in loss when it is lower. Coins created and spent on the same UTC day share one price, so the under-1-day band always has a SOPR of 1 and no realized profit or loss. Ages belong to outputs, not owners: spending an output resets the age of everything it pays, change and moves between one owner's addresses included, so the bands show how long coins have been unmoved on the blockchain, not how long their holders have held them. Coins created before 18 July 2010, the first day with a BTC/USD price, have no cost basis and are left out of every USD value and ratio here; they sit in the oldest bands. Computed by CryptoKeyhole from its own Bitcoin node's record of every unspent and spent output by creation day, with its own admitted daily BTC/USD prices. Daily from 18 July 2010. Each value describes the UTC day after its last block, valued at the day's closing price; the open day is a labelled partial, valued at the latest completed hour and updated through the day, and becomes final six blocks after the day's last block.