Documentation
Search…
Documentation
What is Hotstoks
Stocks table
Overview
Stocks columns
symbol
name
type
Price
price
price_open
price_low
price_high
price_1d
price_change_1d
Performance
price_low_high_change_percent
price_change_percent_1d
price_change_percent_5d
price_change_percent_1m
price_change_percent_3m
price_change_percent_6m
price_change_percent_ytd
price_change_percent_1y
price_change_percent_5y
price_change_percent_10y
All time high
all_time_high_date
all_time_high_price
all_time_high_percent_diff
Moving average
moving_avg_50d
moving_avg_50d_percent_diff
moving_avg_200d
moving_avg_200d_percent_diff
Volume
volume
volume_avg_10d
volume_avg_10d_percent_diff
volume_avg_3m
volume_avg_3m_percent_diff
Fundamentals
pe_ratio
market_cap
eps
52 weeks
week_52_high
week_52_high_percent_diff
week_52_low
week_52_low_percent_diff
Dividends
dividend_rate
dividend_yield_percent
dividend_date
Others
earnings_date
analyst_rating
exchange_name
Timestamps
created
updated
updated_pst
updated_est
Powered By
GitBook
Overview
Database schema
Hotstoks
stores all of its data in a single table called
stocks
for simplicity and easy query manipulation.
The stocks table in this current revision is composed of:
48
columns
5960
stocks
2525
ETF's
Price quotes are updated using
delayed data of 15 minutes
.
Check the sidebar for individual details on each of the columns supported.
Previous
What is Hotstoks
Next - Stocks columns
symbol
Last modified
8mo ago
Copy link