Documentation
Search…
What is Hotstoks
SQL • Finance • API
Hotstoks is a stock market API powered by SQL.
Using Hotstoks, you get all the functionality you expect in a stock market API, combined with the flexibility and unparallel power of SQL to query data in any way you can imagine and get results in standard JSON format.
You can use Hotstoks API to:
  • Screen stocks
  • Identify trends
  • Track your portfolio
  • View stock performance
  • Compare ETF's
  • Check dividends
  • Query penny stocks
  • Track meme stocks
  • Track FAANG performance
  • View earnings calendar
  • Power a finance dashboard
  • And a ton more ...

Example queries

Find stocks that are between 30% to 50% below their 52 week high
1
SELECT * FROM stocks
2
WHERE week_52_high_percent_diff BETWEEN -50 AND -30
3
ORDER BY volume DESC, market_cap DESC
Copied!
Find dividend paying stocks ordered by market cap
1
SELECT * FROM stocks
2
WHERE NOT dividend_date IS NULL
3
ORDER BY market_cap DESC
Copied!
Find penny stocks that are trending
1
SELECT * FROM stocks
2
WHERE price <= 10
3
AND volume_avg_10d_percent_diff > 20
4
ORDER BY market_cap DESC, volume_avg_10d_percent_diff DESC
Copied!
Find the most active ETF’s
1
SELECT symbol, name, volume
2
FROM stocks
3
WHERE TYPE = 'etf'
4
ORDER BY volume DESC
Copied!
post
https://api.hotstoks.com
/query
API specification
Last modified 8mo ago