wsky1

Live stats & data coverage

wsky1.com/stats is a live snapshot of the whole dataset — every count pulled straight from the production database — so you can check coverage and freshness or cite the numbers.

wsky1.com/stats is the honest, live view of the dataset behind every valuation: how many records we hold, how many bottles and distilleries they cover, which feeds are writing, and when we last saw a price. Every number is queried from the production database on load (cached for 15 minutes at the edge), so it's never a hardcoded marketing figure — use it to check coverage, confirm freshness, or cite a number.

The wsky1 live stats page, showing the six live counters — total records, catalog bottles, distilleries, data sources, last scrape, and refresh cadence

What each number means

The page shows six live counters:

  • Total records — every price observation plus every raw auction listing (price points + auction listings). This is the headline "how much data" figure.
  • Catalog bottles — canonical bottle entries with at least one matched sale. Each is a distinct release (distillery + age + vintage + bottler + cask + edition), not just a brand.
  • Distilleries — unique distillery brands represented across the catalog.
  • Data sources — active scraper feeds currently writing into the price-history table.
  • Last scrape — how long ago the most recent scrape finished, with its source and status (e.g. swa · ok). A good at-a-glance health check.
  • Refresh cadence — Daily, run as five scheduled crons staggered across roughly 03:00–10:00 UTC.

Just under the counters, a Last price observation line shows how recently a new hammer price landed — the truest freshness signal on the page.

Methodology

The page's methodology box states the same rules the whole product runs on:

  • Each auction lot is matched against a canonical key — distillery, age, vintage, bottling year, bottler, cask, edition — so the same bottle sold at different houses collapses into one record.
  • All prices are hammer prices in GBP, excluding buyer's premium (which adds 24–28% at most houses).
  • Where wsky1 has bottle-specific hammer data, it surfaces the latest observed price and a monthly median. Where it doesn't, it falls back to distillery-level monthly medians aggregated across major auction houses.

Cite it

Because the counters are pulled live, the stats page is the right thing to point at when you need a current, defensible coverage number — the same figures feed the citable claims in /llms.txt. The methodology box itself links the two JSON alternates (/prices/<slug>.json, /catalog/<key>.json) and /llms.txt for anyone who wants the underlying data.

Notes & limits

  • 15-minute cache. Counts move slowly, so the page is cached for 15 minutes — a repeat load may show the same numbers for a few minutes.
  • "Catalog bottles" counts matched releases, not every title ever seen — bottles with no matched sale yet aren't included.
  • market is synthetic. The distillery-level aggregate is one of the data sources but isn't a real auction house.

Related