What is Hotstoks

​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

Next - Stocks table

Overview

Last modified 4mo ago

Copy link

Contents

Example queries

post

API specification