How Many Bitcoins Were Sent Per Month Per Year

btc_sent.sql

#standardSQL
SELECT
  EXTRACT(year
  FROM
    o.day) AS year,
  EXTRACT(month
  FROM
    o.day) AS month,
  SUM(o.output_satoshis) * 0.00000001 AS btc
FROM (
  SELECT
    TIMESTAMP_MILLIS((timestamp - MOD(timestamp,86400000))) AS day,
    output.output_pubkey_base58 AS output_key,
    output.output_satoshis
  FROM
    `bigquery-public-data.bitcoin_blockchain.transactions`,
    UNNEST(outputs) AS output
  GROUP BY
    day,
    output_key,
    output_satoshis ) AS o
GROUP BY
  1,
  2
ORDER BY
  1,
  2