Calculations › Market Discovery

Show the top 20 stocks in the market by 30-day % gain (ideas to research)

The query

-- table market-wide: top 20 stock movers (discovery - stocks to consider)
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 = 'stock'
  ORDER BY tp.ticketnameid, tp.datetime DESC
),
month_ago AS (
  SELECT DISTINCT ON (tp2.ticketnameid) tp2.ticketnameid, tp2.price AS price_1m
  FROM ticketprice tp2 JOIN latest l ON l.ticketnameid = tp2.ticketnameid
  WHERE tp2.datetime <= l.ts_now - 30*86400
  ORDER BY tp2.ticketnameid, tp2.datetime DESC
)
SELECT tn.ticket AS symbol, COALESCE(sm.name, tn.ticketname, tn.ticket) AS name, sm.sector,
       l.price_now, (l.price_now - m.price_1m) / NULLIF(m.price_1m,0) * 100 AS pct_change_1m
FROM latest l
JOIN month_ago m ON m.ticketnameid = l.ticketnameid
JOIN ticketname tn ON tn.id = l.ticketnameid
LEFT JOIN symbolmetadata sm ON sm.ticketnameid = l.ticketnameid
WHERE l.price_now >= 1 AND ABS((l.price_now - m.price_1m) / NULLIF(m.price_1m,0) * 100) <= 100
ORDER BY pct_change_1m 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

SymbolNameSectorPrice1m change
NANEXA.ST Nanexa AB (publ) Healthcare 10.54 88.55
2020.OL 2020 Bulkers Ltd. Industrials 5.91 42.75
INTC Intel Corporation Technology 120.23 34.32
GME GameStop Corp. Consumer Cyclical 24.65 34.11
AMD Advanced Micro Devices, Inc. Technology 611.76 29.96
META Meta Platforms, Inc. Communication Services 725.18 26.70
YUBICO.ST Yubico AB Technology 109.20 23.60
IMP-A-SDB.ST Implantica AG Healthcare 74.40 23.59
ZAP.OL Zaptec ASA Industrials 62.10 22.49
BRAIN.ST BrainCool AB (publ) Healthcare 1.08 21.21
EMBRAC-B.ST Embracer Group AB (publ) Communication Services 86 20.01
SCST.ST Scandi Standard AB (publ) Consumer Defensive 170.60 18.47
SIVE.ST Sivers Semiconductors AB (publ) Technology 31.48 18.35
LYKO-A.ST Lyko Group AB (publ) Consumer Defensive 101 17.85
SBB-D.ST Samhällsbyggnadsbolaget i Norden AB (publ) Real Estate 6.93 17.06

Live output, first 15 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