Transacted Coin Acquisition Cost

For the coins/tokens transacted on a given day, get the price they were acquired at. Any movement of coins/tokens on-chain is treated as an acquisition. The metric does not include:

• Minting/mining/uncle rewards.
• Transactions of coins/tokens that were acquired on the same day. This would handle most situations with deposit/withdrawal addresses.
  • Example: There are two transactions on the same day: A - 10ETH -> B and B -> 10ETH C - B moves the coins on the same day that they were received. This second transaction is not counted.

The total number of coins/tokens that are counted is equal to the 1-day circulation (not the transaction volume) minus the block rewards/uncle rewards/mints.

The metric returns a list of price ranges and the number of coins/tokens that were last moved when the price was in that range. The ranges have even length with the exception of the range that contains the queried day price. This range is split around that price, resulting in two ranges. This has the benefit of knowing exactly how many coins/tokens were last moved when the price was above or below the queried day price.

Let’s take a look at what prices were acquired at for the bitcoins transacted on 09 November 2021, when bitcoin reached an all-time high of over $68,000:

• [$low - $high] - number of bitcoins
• [$0 - $16,886.13] - 9,497.95
• [$16,886.13 - $33,772.26] - 1290.67
• [$33,772.26 - $50,658.39] - 14,159.67
• [$50,658.39 - $59,987.51] - 2711.52
• [$59,987.51 - ∞] - 178,339.76

It is clear that when the price is at its all-time high, all of the sellers are profiting, but some are profiting much more than others. The majority of the bitcoins were last moved when the price was in the range $59.9k-$57.5k. But there are 9,497.95 bitcoins that moved last when the price was under $16.9k.

Let’s take a look at what prices were acquired at for the bitcoins transacted on 20 July 2021, when bitcoin reached a local minimum of around $29,000, after reaching over$64,000 just 3 months before that:

• [$low - $high] - number of bitcoins
• [$0 - $15880.41] - 13586.16
• [$15880.41 - $29842.86] - 694.53
• [$29842.86 - $31760.82] - 52818.93
• [$31760.82 - $47641.23] - 41785.33
• [$47641.23 - $63521.64] - 4693.35
• [$63521.64 - ∞] - 146.27

Looking at this data, we conclude that the majority of the bitcoins, around 99.9k or around 87% of all bitcoins transacted, were last moved when the price was higher. This would mean that most of the transactions on that day resulted in a loss.

Restricted Access

Number of coins/tokens per price range

Histogram Data

Five-Minute Intervals

On-Chain Latency

Available for these assets

Available under price_histogram and spent_coins_cost metric names. Both metrics return exactly the same data.

1
{
2
  getMetric(metric: "spent_coins_cost") {
3
    histogramData(
4
      slug: "santiment"
5
      from: "2020-04-07T00:00:00Z"
6
      to: "2020-04-08T00:00:00Z"
7
      interval: "1d"
8
      limit: 10
9
    ) {
10
      values {
11
        ... on FloatRangeFloatValueList {
12
          data {
13
            range
14
            value
15
          }
16
        }
17
      }
18
    }
19
  }
20
}

Run in Explorer