Dataset · v1 · sealed 2026-07-29 · go15
The Sleeping Fleet
Every Satoshi-era mining reward, classified one coin at a time.
196,479 P2PK coinbase outputs — every mining reward Bitcoin ever paid to a raw public key — each one classified as asleep or awoken by checking whether that exact coin is still in the unspent set. Plus 157,766 departures dated to the block.
Free finding = full narrative, method, controls, charts, published figures. Paid file = full Parquet + CSV row tables for your own queries.
Measured twice
Independent second pass and controls that must be able to fail.
Own node
Raw blocks parsed on our archival hardware — no rented API.
Bitcoin-anchored
Root hash committed on-chain via OpenTimestamps.
Verify free first
Title
…
generated_utc
…
Age
…
Root
…
Rows
…
Fetch
…
The free finding is the full narrative: method, controls, charts, and the published headline figures. The paid file is the row-by-row tables (Parquet + CSV) for your own joins and re-queries — the same tables summarized in the finding, not a different conclusion.
Built from a full archival parse with era-aware classification. Buying is for analysts who want the finished tables instead of re-deriving them from raw blocks. Read free finding →
Preview · free sample
Schema and sample rows
Preview: first rows of the free sample (real sealed data, not mock). Full schemas for every table are also in manifest.json and below under Contents.
Columns · fleet_outputs
| Column | Type |
|---|---|
height | BIGINT |
output_n | INTEGER |
value_sats | BIGINT |
pubkey_hex | VARCHAR |
year | INTEGER |
sleeping | BOOLEAN |
Sample rows
height | output_n | value_sats | pubkey_hex | year | sleeping |
|---|---|---|---|---|---|
| 0 | 0 | 5000000000 | 04678afdb0fe5548271967f1a67130b7105… | 2009 | false |
| 1 | 0 | 5000000000 | 0496b538e853519c726a2c91e61ec11600a… | 2009 | true |
| 2 | 0 | 5000000000 | 047211a824f55b505228e4c3d5194c1fcfa… | 2009 | true |
| 3 | 0 | 5000000000 | 0494b9d3e76c5b1629ecf97fff95d7a4bbd… | 2009 | true |
| 4 | 0 | 5000000000 | 04184f32b212815c6e522e66686324030ff… | 2009 | true |
| 5 | 0 | 5000000000 | 0456579536d150fbce94ee62b47db2ca43a… | 2009 | true |
| 6 | 0 | 5000000000 | 0408ce279174b34c077c7b2043e3f3d45a5… | 2009 | true |
| 7 | 0 | 5000000000 | 04a59e64c774923d003fae7491b2a7f75d6… | 2009 | true |
Download full free sample CSV → · Free kit · Full schema
Seal root (SHA-256): 3b02823f0596e708bdb87efb79fe838eae671c63a24ceb5eb0b7abd8612b2758
root.hash ·
root.hash.ots ·
manifest.json
Judge the seal before you pay. These files are free right now:
One-time purchase. Instant download, no account, no subscription.
Send exactly this amount to this address. It is derived fresh for your order, from our own wallet — no payment processor sits in between.
Amount
Address
Order — copy and keep this order id. It is the only record. Paste it under Recover if you close the tab. It re-derives your address and download link.
Watching the chain…
Everything needed to judge this dataset — manifest, samples, verifier, Bitcoin timestamp — is free below, right now.
Lost payment or closed the tab?
Bitcoin: your order id re-derives the invoice address and unlocks the download when the payment is seen. Paste it below (this browser) or keep the order id from the pay screen.
Card: checkout returns a success page with the download when payment completes. Use the same browser session if Stripe redirected you; there is no account email from us.
Free kit paths (always public):
/products/sleeping-fleet/manifest.json ·
verify.py · root.hash · samples on this page.
Root-level /manifest.json is not used — see verify kits.
Check us before you pay
Free downloads
Most data vendors ask you to trust a description. Here is the actual manifest for the actual product, the actual Bitcoin timestamp, and the verifier that checks them — all of it free, before any money changes hands.
Sample rows
The first 1,000 rows of the main table, and the complete by-year summary. Real rows from the sealed file, not a mock-up.
The manifest
Row counts, full schemas, per-column digests, every published figure with the SQL behind it, and the controls the build had to pass.
The proof
The root hash and its OpenTimestamps receipt, committing this exact dataset to the Bitcoin blockchain.
The verifier
Recomputes everything from the files alone. Core check needs no third-party package; install duckdb and it re-derives every figure and re-runs every control.
The root of this dataset, committed to Bitcoin:
3b02823f0596e708bdb87efb79fe838eae671c63a24ceb5eb0b7abd8612b2758Contents
What's in the box
| Table | Rows | Parquet | CSV | What it is |
|---|---|---|---|---|
| fleet_outputs | 196,479 | 13.84 MB | 31.22 MB | Every P2PK coinbase output, classified |
| fleet_keys | 192,288 | 14.28 MB | 31.26 MB | The distinct public keys paid |
| fleet_awakenings | 157,766 | 11.40 MB | 23.49 MB | First-spend height per clean key |
| fleet_awakening_years | 18 | < 0.01 MB | < 0.01 MB | Awakenings by calendar year |
| fleet_by_year | 17 | < 0.01 MB | < 0.01 MB | Mined vs still-asleep, by year |
| fleet_meta | 3 | < 0.01 MB | < 0.01 MB | Build method and caveats |
Schema
fleet_outputs height BIGINT · output_n INTEGER · value_sats BIGINT
pubkey_hex VARCHAR · year INTEGER · sleeping BOOLEAN
fleet_keys pubkey_hex VARCHAR · n_outputs BIGINT · funded_sats DOUBLE
first_h BIGINT · last_h BIGINT · n_sleeping DOUBLE
fully_sleeping BOOLEAN
fleet_awakenings pubkey_hex VARCHAR · funded_h INTEGER · spend_h INTEGER
n_history INTEGER · clean BOOLEAN
fleet_awakening_years wake_year INTEGER · keys_awoken BIGINT · btc_awoken DOUBLE
fleet_by_year year INTEGER · outputs BIGINT · btc DOUBLE
sleeping_outputs DOUBLE · sleeping_btc DOUBLE
pct_btc_sleeping DOUBLE
fleet_meta k VARCHAR · v VARCHARQuality
The controls this build had to pass
The export aborts and produces nothing if any of these fail. They are cases where the
answer is already known, so a wrong result proves the instrument broken rather than the
finding interesting. All four are recorded in the manifest and re-run by
verify.py against your copy:
- block_1_is_sleeping — Satoshi's first reward after genesis. Its script shows 2024–25 activity from inbound homage deposits; the coin has never moved. Any pipeline reporting this as spent is classifying at script level, and is wrong.
- block_9_is_awoken — spent at height 170: the Satoshi → Hal Finney transaction.
- sleeping_is_a_strict_subset — if every output classified as sleeping, the awoken side of the join silently failed. That is the failure mode that would make this dataset worthless while still looking complete.
- no_negative_values — sanity floor on the value column.
Honest limits
What this is not
- It covers P2PK coinbase outputs only — mining rewards paid to a raw public key. It is not a census of all early Bitcoin.
- "Satoshi-era" describes the period, not the owner. We make no claim about who controls any key in this file.
- 70 reused keys are recorded as deferred rather than dated. We would rather hand you a gap than a guess.
- It is a snapshot, at block height 959,975 (unspent set) and 959,976 (chain parse), taken 2026-07-28. Coins wake up; 57 did this year.
Read first
The finding is free
Everything this dataset was built to show is published free and in full, including both tables and the method. Read it → and buy the data only if you want to go further than we did.