Calculations › Market Breakdown
Show how many crypto assets fall into each category
The query
-- barchart market-wide: count of symbols per crypto category
SELECT sm.crypto_category, COUNT(*) AS n
FROM ticketname tn
JOIN symbolmetadata sm ON sm.ticketnameid = tn.id
WHERE tn.tickettype = 'crypto_pair' AND sm.crypto_category IS NOT NULL AND sm.crypto_category != ''
GROUP BY sm.crypto_category
ORDER BY n DESC;
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
| Category | Count |
|---|---|
| Other | 15 |
| Layer 1 | 7 |
| DeFi | 2 |
| Meme | 1 |
Live output, first 4 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