Calculations › Market Overview

How many materials are up this week?

The query

-- kpi market-wide: how many materials are up over the past week
WITH latest AS (
  SELECT DISTINCT ON (tp.ticketnameid) tp.ticketnameid, tp.price AS price_now, tp.datetime AS ts_now
  FROM ticketprice tp JOIN ticketname tn ON tn.id = tp.ticketnameid
  WHERE tn.tickettype = 'material'
  ORDER BY tp.ticketnameid, tp.datetime DESC
),
week_ago AS (
  SELECT DISTINCT ON (tp2.ticketnameid) tp2.ticketnameid, tp2.price AS price_1w
  FROM ticketprice tp2 JOIN latest l ON l.ticketnameid = tp2.ticketnameid
  WHERE tp2.datetime <= l.ts_now - 7*86400
  ORDER BY tp2.ticketnameid, tp2.datetime DESC
)
SELECT COUNT(*) FILTER (WHERE l.price_now > w.price_1w) AS materials_up_this_week,
       COUNT(*) AS materials_measured
FROM latest l JOIN week_ago w ON w.ticketnameid = l.ticketnameid

Runs against Cryptobi's market tables — ticketname (symbols), ticketprice (daily prices and volume) and symbolmetadata (sector, exchange, market cap and other reference fields).

Current output

Materials up this weekMaterials measured
3 16

Live output, first 1 rows, refreshed periodically. Model estimates are trend projections from recent prices, not financial advice.

Run this on your own holdings, change it, or write your own in SQL or Python — then put it on a dashboard or have it emailed on a schedule. Free, no credit card.

Sign Up Free

Related calculations