Show the top 20 symbols in the market by latest trading volume

The query

-- table market-wide: top 20 by volume
WITH latest AS (
  SELECT DISTINCT ON (tp.ticketnameid) tp.ticketnameid, tp.price, tp.volume
  FROM ticketprice tp
  ORDER BY tp.ticketnameid, tp.datetime DESC
)
SELECT tn.ticket AS symbol, COALESCE(sm.name, tn.ticketname, tn.ticket) AS name, sm.exchange, l.price, l.volume
FROM latest l
JOIN ticketname tn ON tn.id = l.ticketnameid
LEFT JOIN symbolmetadata sm ON sm.ticketnameid = l.ticketnameid
WHERE l.volume IS NOT NULL
ORDER BY l.volume DESC
LIMIT 20;

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

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

Related calculations

• Show the top 20 stocks in the market by 30-day % gain (ideas to research)
• Show all funds tracked on the platform
• Show all crypto assets tracked on the platform by category
• Show the top 20 most volatile stocks in the market with sector (ideas to research)
• Show the top 20 best year-to-date performing stocks with sector (ideas to research)
• Show a sector overview across the market (count, average price, average YTD change)