Calculations › Market Breakdown
Show the top 10 stocks by latest trading volume
The query
WITH latest AS (
SELECT DISTINCT ON (tp.ticketnameid) tp.ticketnameid, tp.price, tp.volume
FROM ticketprice tp JOIN ticketname tn ON tn.id = tp.ticketnameid
WHERE tn.tickettype = 'stock'
ORDER BY tp.ticketnameid, tp.datetime DESC
)
SELECT tn.ticket AS symbol, l.price, l.volume
FROM latest l JOIN ticketname tn ON tn.id = l.ticketnameid
WHERE l.volume IS NOT NULL
ORDER BY l.volume DESC
LIMIT 10;
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
| Symbol | Price | Volume |
|---|---|---|
| NVDA | 228.38 | 117687772 |
| PMED.ST | 0.00 | 102140999 |
| INTC | 120.23 | 92858289 |
| AAPL | 333.02 | 49019894 |
| AMZN | 249.15 | 41228975 |
| SOFI | 15.72 | 40344324 |
| MARA | 11.33 | 40264119 |
| T | 24.40 | 38446425 |
| TSLA | 354.81 | 38002779 |
| NKE | 35.40 | 37165319 |
Live output, first 10 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