Art 3: The business of the art market

Lesson video · The business of the art market (4:11)

View study sheet (PDF) View SQL cheat sheet (PDF)

Teaching this module? A facilitator guide adds a preparation checklist, timing cues, discussion guidance, slides, and a printable PDF.

This session treats the art market as a business and uses auction transaction data to study how it works. Rather than reading about the trade in the abstract, students build the two artifacts that art market professionals actually rely on: an auction house league table that ranks salerooms by the value and volume of what they sell, and an artist-level view of demand measured through pricing power and sell-through. The dataset records what buyers actually paid at more than 850 vendors with history back to 1949, so students can see the secondary market as it behaves, where the estimate meets the hammer, where lots find buyers and where they do not, and how value concentrates among a handful of names and houses. The session builds toward a single question that sits at the center of the trade: what does it mean to run, or to read, the business of a saleroom.

Target course(s) and level

Art business, art market studies, or arts administration course. Suitable for graduate students in art market or arts management programs, advanced undergraduates pairing art history with business, and professional or continuing-education students entering the trade. No finance background is assumed.

Learning objectives

By the end of this session, students will be able to:

  1. Explain the auction house's role as intermediary in the secondary market and define estimate, realized price, and sell-through in plain business terms.
  2. Build an auction house league table by aggregating realized value and lot counts by vendor, and read it as a picture of relative scale in the trade.
  3. Compute an artist's pricing power, the median of realized price over the high estimate, and interpret a value above or below 1.0 as a demand signal.
  4. Measure sell-through for a house or an artist and explain what a high or low clearance rate says about demand and consignment quality.
  5. Describe how value concentrates among a small number of artists and houses, and why that concentration matters to anyone running an art business.
  6. Identify the limits of auction data for art market analysis, including that it captures the secondary market only, that unsold lots are retained and marked unsold, and that the newest periods are still being ingested and should not be read as trends.
  7. (Extension) Retrieve house-level records programmatically via the production API and assemble a league-table slice in Python.

Prerequisites

An introductory art history or arts management course, or professional interest in the art trade. No prior exposure to data tools, SQL, or finance is assumed. The optional code extension assumes basic Python familiarity.

Materials and access needed

  • Sandbox access at sandbox.altfndata.com, self-registered with a work or school email, auto-approved.
  • Projector or screen share for the instructor demo.
  • The coverage browser tab, used before the demo to confirm how a chosen auction house appears in the vendor field and how a chosen artist appears in the designer field.
  • For the optional extension only: an instructor class API key requested from info@altfndata.com, and the downloadable Python client (altfndata_client.py) or tutorials notebook (altfndata_tutorials.ipynb) at docs.altfndata.com.

Session outline (90 minutes)

  • 0 to 15 min: The art market as a business. Introduce the auction house as intermediary and the vocabulary of estimate, realized price, and sell-through, and preview the two artifacts the class will build.
  • 15 to 25 min: Sandbox orientation. Confirm students can open the fine art data table and locate vendor, designer, usd_price_decimal, sale_estimates_high_usd_price, and status in the data dictionary.
  • 25 to 45 min: Guided demo, build an auction house league table by realized value and lot count.
  • 45 to 60 min: Guided demo, compute pricing power and sell-through for a single well-known artist.
  • 60 to 75 min: Small-group exercise, students pick a different house or artist and reproduce one of the two artifacts.
  • 75 to 85 min: Class discussion, groups report what their league table or artist view reveals about concentration and demand.
  • 85 to 90 min: Wrap-up and homework assignment.

In-class demo (sandbox-first, no code)

  1. Open sandbox.altfndata.com, sign in, and select the fine art data table from the SQL editor dropdown.
  2. Open the coverage browser tab and confirm how a major auction house is written in the vendor field, and how a well-known artist is written in the designer field. Spelling matters for exact filters.
  3. Return to the SQL editor and run the first guided query, the auction house league table, which ranks houses by total realized value alongside the number of sold lots.
  4. Read the league table aloud with the class. Point out that a house can rank high on total value but lower on lot count, or the reverse, and ask what each pattern suggests about the kind of business a house runs.
  5. Explain the recency caveat before anyone reads the totals as current standings: the newest periods are still being added to the dataset, so the league table is best read as a picture of relative scale over the long run, not as this year's ranking.
  6. Run the second guided query, pricing power for a single artist, and explain that a median realized price above the high estimate means buyers consistently paid over what the house expected.
  7. Run the third guided query, sell-through for the same artist or a house, and explain that clearance rate reflects both demand and the quality of what was consigned, since unsold lots are retained and counted as unsold.
  8. Open the pre-built charts tab and chart sold-lot count by quarter for one house, to show activity over time, and remind students that any single recent quarter should be treated cautiously given ongoing ingestion.

Datasets and queries used

Dataset: fine art data (documented fields: designer, model, item_title, sale_date, usd_price_decimal, sale_estimates_high_usd_price, status, vendor, stock_ticker). In the fine art data the designer field holds the artist or maker name, and the vendor field holds the auction house.

Query 1, auction house league table by realized value and lot count:

SELECT vendor,
       COUNT(*) AS sold_lots,
       SUM(usd_price_decimal) AS total_realized_usd
FROM all_fine_art_data
WHERE status = 'sold'
GROUP BY vendor
ORDER BY total_realized_usd DESC
LIMIT 25;

Query 2, pricing power for a single artist:

SELECT designer AS artist,
       approx_percentile(usd_price_decimal / sale_estimates_high_usd_price, 0.5) AS pricing_power,
       COUNT(*) AS sold_lots
FROM all_fine_art_data
WHERE status = 'sold'
  AND sale_estimates_high_usd_price > 0
  AND designer LIKE '%Warhol%'
GROUP BY designer;

Query 3, sell-through by house (offered lots that found a buyer):

SELECT vendor,
       COUNT(*) FILTER (WHERE status = 'sold') AS sold_lots,
       COUNT(*) AS offered_lots,
       COUNT(*) FILTER (WHERE status = 'sold') * 1.0 / COUNT(*) AS sell_through
FROM all_fine_art_data
GROUP BY vendor
HAVING COUNT(*) >= 200
ORDER BY sell_through DESC
LIMIT 25;

Optional API extension, retrieve one house's sold lots to assemble its league-table slice in Python (POST /v1/tables/all_fine_art_data/query, header X-API-Key). The API returns rows rather than server-side aggregates, so the totals and counts are computed client-side after paginating on offset:

{
  "fields": ["vendor", "designer", "item_title", "sale_date", "usd_price_decimal"],
  "filters": [
    {"field": "vendor", "op": "eq", "value": "Christie's"},
    {"field": "status", "op": "eq", "value": "sold"}
  ],
  "sort": [{"field": "usd_price_decimal", "direction": "desc"}],
  "limit": 1000
}

Discussion questions

  1. A league table can rank houses by total realized value or by number of lots sold, and the two rankings often disagree. What kind of business does a house at the top of the value ranking run, compared with a house at the top of the volume ranking?
  2. An artist shows pricing power well above 1.0 but a modest sell-through rate. What might explain the two figures together, and what would you want to know before advising a consignor?
  3. Auction data captures the secondary market only, not gallery or primary sales. What parts of the art business does this dataset therefore not see, and how would that shape a conclusion drawn from it?
  4. Why does value in the art market concentrate so heavily among a small number of artists and houses, and what risks does that concentration create for a saleroom's business?
  5. Sell-through reflects both demand and the quality of what was consigned. How would you separate those two influences when a house's clearance rate falls?
  6. If you were advising a mid-size auction house on where to compete, what would you look for in the league table and the artist-level demand figures?
  7. Why is it unwise to read the most recent quarter's totals as evidence that a house or an artist is rising or falling, and what stable measures would you rely on instead?
  8. How does the estimate itself shape behavior in the room, given that pricing power is measured relative to the high estimate the house set before the sale?

Homework assignment

Each student selects one auction house and one artist represented in the fine art data and writes a two-page art market brief, as if for a gallery director or a saleroom's business team. For the house, the brief reports its position in the league table by both realized value and lot count and interprets what that position says about its business. For the artist, the brief reports pricing power and sell-through and argues what the two figures together suggest about demand. The brief must include the SQL queries used as an appendix, at least one exported table or chart, and an explicit limitations section that addresses the secondary-market-only nature of the data and the recency caveat, and that does not draw conclusions from recent quarter-over-quarter changes. Grading criteria: correct construction and reading of the league table (25 percent), correct computation and interpretation of pricing power and sell-through (30 percent), quality of the business argument connecting the figures to a recommendation (30 percent), and honest treatment of the analysis's limitations (15 percent).

Going deeper

Key terms

  • Realized price: what a buyer actually paid for a lot, recorded in usd_price_decimal, as distinct from any pre-sale estimate.
  • High estimate: the auction house's own pre-sale price expectation, recorded in sale_estimates_high_usd_price.
  • Pricing power: the median of realized price divided by the high estimate across sold lots, a measure of whether buyers pay above or below what the house expected.
  • Sell-through: the share of offered lots, sold and unsold together, that find a buyer.
  • League table: a ranking of auction houses by realized value or lot count, used to read relative scale in the trade.
  • Consignment: a seller placing an item with a house to be offered for sale, whose quality shapes sell-through independent of demand.
  • Concentration: the degree to which total realized value clusters among a small number of artists or houses.
  • Secondary market: the resale market captured by auction data, as distinct from primary sales through galleries or dealers.

Common pitfalls

  1. Ranking houses by realized value alone and missing that a high-value house may sell far fewer lots than a high-volume one, or the reverse.
  2. Computing pricing power without the sale_estimates_high_usd_price > 0 guard, letting zero or null estimates distort the median.
  3. Reading a high pricing power figure alone as proof of strong demand, without checking sell-through alongside it.
  4. Reading the newest quarter's totals as evidence of a rising or falling trend, when the newest periods are still being ingested.
  5. Carrying the fine art table's designer-equals-artist, vendor-equals-auction-house convention into another table, where designer and vendor mean something different.
  6. Ranking an artist or house on a handful of lots, producing a pricing power or sell-through figure too noisy to support a real conclusion.

Additional queries to explore

  1. Artist concentration: total realized value by designer across all sold lots, to see what share of the market's total value sits with the top ten artists versus everyone else, revealing how concentrated the trade is at the top.
  2. Average lot value by house: total realized value divided by sold lot count for each vendor, alongside the league table figures already used in class, revealing whether a house's high ranking comes from many modest lots or a few expensive ones.
  3. Pricing power across several artists at once, grouping by designer with a minimum lot count threshold, revealing a comparative demand table rather than one artist studied in isolation.

Extension activities

  1. Have a group repeat the API extension for two different houses and compare their league-table slices as retrieved programmatically, rather than through the SQL editor.
  2. Ask students to sketch a one-page saleroom dashboard combining the league table, pricing power, and sell-through into a single view, as a preview of Data 2 (visualization).
  3. Have students research one artist's primary market or gallery representation for comparison against what the auction data alone shows, to make the secondary-market limitation concrete rather than abstract.

Connections to other modules

Previous in this track: Art 1 (fundamentals) and Art 2 (auction business model) supply the price vocabulary and house mechanics this session widens into market-level league tables. Next: Art 4, auction theory, explains why the estimate itself shapes bidding behavior (the mechanism behind pricing power). Art 5 turns the same fields into research methods. Cross-track: Finance 2 for demand-side brand metrics; Data 2 for charting a league table for a client.