Daily Stock Prices, Technical Indicators & Metadata | US Exchanges | AI Fact Table

**Overview**
This free trial offering includes Daily OHLCV, Metadata and over 180 Technical Indicators (330 with variations) for 12 US Stock Exchanges. At the end of the trial period, we will notify subscribers of the pending retirement of this product. The pricing for the paid product will depend on company size but we always endeavor to offer competitive pricing.
In this product you will find:

- Comparative indicators - which are used to analyze the relationship between two or more securities, indices or markets.
- General indicators, which are heuristic or pattern-based signals produced by the price, volume, and/or open interest of a single security.
- Moving-average type indicators.

**Product details**
With recent advances in AI, we believe that the technical indicator data that we provide is very well suited to be ingested and analyzed with AI tools, with a view towards increasing the probability of making an informed trade or investment. Consider this to be the ultimate daily “fact table” for AI Ingestion and analysis. You will be hard-pressed to find a better source of daily technical indicator data for stock market data analytics.

**Exchanges:**

* BATS Exchange
* NASDAQ Stock Exchange
* NEW YORK Stock Exchange
* NYSE ARCA Exchange
* NYSE MKT Exchange (NYSE American)
* OTCBB, OTCCE, OTCGREY, OTCMKTS, OTCQB, OTCQX
* PINK Sheets

**Example:**

Exchange | NASDAQ
Ticker | MSFT
Name | Microsoft Corporation
Country | USA
Currency | USD
Asset_Type | Common Stock
ISIN | US5949181045
Date | 2023-08-30
Open | 328.670
High | 329.810
Low | 326.450
Close | 328.790
Volume | 15205500
Accumulate_or_Running_Total_Volume | 1482989547
Accumulation_Swing_Index | 0.002678
Aroon_Down | 42.857143
Aroon_Oscillator | 28.571429
Aroon_Up | 71.428571
Average_Directional_Movement_Index_ADX | 12.756091
Average_Directional_Movement_Rating_ADXR | 13.656949
Zigzag | 326.355556
CreateDate | 2024-01-23 13:55:00

- ISIN values may not exist.
- Data is not guaranteed to be 100% free of gaps. There may be some days where we do not have the OHLCV for the asset.
- Ichimoku Indicators are provided in their own table which will be part of this product. In order to have at least one Chikou value per ticker for graphing purposes, we provide 27 rows of data for each ticker daily. Current close is inserted 26 days into the past to populate that value.
- Data will be published daily at ~9:15 pm
- After the trial expires, we will publish multiple times per day

**Comparative Indicators:**

Comparative indicators are calculated by comparing a ticker to an index. For each security on each of our exchanges, we compare the security with the generally accepted equivalent of the S&P 500 for that exchange. For US exchanges, we compare to S&P 500.

- Comparative_Performance
- Comparative_Relative_Strength
- Comparative_Strength
- Moving_Beta_5/10/14/20/50/100/200_days
- Moving_Correlation_Coefficient_5/10/14/20/50/100/200_days
- Moving_Covariance_5/10/14/20/50/100/200_days

**General Indicators & Moving Average type Indicators:**
- Accumulate_or_Running_Total_Volume
- Aroon_Down
- Aroon_Oscillator
- Aroon_Up
- Average_Directional_Movement_Index_ADX
- Average_Directional_Movement_Rating_ADXR
- Average_Price
- Average_True_Range_ATR
- Bollinger_Bandwidth
- Bollinger_Bands_Hi
- Bollinger_Bands_Low
- Bollinger_Bands_Mid
- Balance_of_Power_BOP
- Chaikin_Accumulation_Distribution_Line
- Chaikin_Money_Flow
- Chaikin_Oscillator
- Chaikin_Volatility
- Chande_Momentum_Oscillator_CMO
- Chicago_Floor_Trading_Pivotal_Point_First_Resistance_Level
- Chicago_Floor_Trading_Pivotal_Point_First_Support_Level
- Chicago_Floor_Trading_Pivotal_Point_Second_Resistance_Level
- Chicago_Floor_Trading_Pivotal_Point_Second_Support_Level
- Commodity_Channel_Index_CCI
- Commodity_Selection_Index_CSI
- DEMA_5/10/14/20/50/100/200_days
- Demand_Index
- Directional_Movement_Index_DX
- Directional_Movement_Index_Minus_DI
- Directional_Movement_Index_Plus_DI
- Dynamic_Momentum_Index_DMI
- Ease_of_Movement
- Envelope_Hi_Bollinger_Bands
- Envelope_Low_Bollinger_Bands
- Envelope_Percent_Hi
- Envelope_Percent_Low
- Exponential_Moving_Average_5/9/10/12/14/20/26/50/100/200_days
- Following_Adaptive_Moving_Average_FAMA
- Forecast_Oscillator_FO
- Forecast_Oscillator_Signal
- General_Stochastic_Calculation
- Hilbert_Transform_Dominant_Cycle_Period
- Hilbert_Transform_Dominant_Cycle_Phase
- Hilbert_Transform_Phasor_In_Phase
- Hilbert_Transform_Phasor_Quadrature
- Hilbert_Transform_Sine_Sine
- Hilbert_Transform_Sine_Lead_Sine
- Hilbert_Transform_Instantaneous_Trendline
- Hilbert_Transform_Trend_vs_Cycle_Mode
- Ichimoku_Kinko_Hyo_Chikou_Span
- Ichimoku_Kinko_Hyo_Kijun_Sen
- Ichimoku_Kinko_Hyo_Senkou_Span_A
- Ichimoku_Kinko_Hyo_Senkou_Span_B
- Ichimoku_Kinko_Hyo_Tenkan_Sen
- Kaufman_Adaptive_Moving_Average_KAMA_10/14/20/50/100/200_days
- Least_Squares_Moving_Average_5/10/14/20/50/100/200_days
- Line_Oscillator_Open_to_Close
- Linear_Regression
- Linear_Regression_Angle
- Linear_Regression_Intercept
- Linear_Regression_Slope
- Market_Facilitation_Index_MFI
- MESA_Adaptive_Moving_Average_MAMA
- Mass_Index
- Max_Close_30_days
- Max_Close_Position_30_days
- Median_Price
- MESA_Sinewave
- MESA_Sinewave_Lead
- Mid_Point
- Mid_Price
- Min_Close_30_days
- Min_Close_Position_30_days
- Momentum
- Money_Flow_Index
- Moving_Average_Convergence_Divergence_MACD
- Moving_Average_Convergence_Divergence_MACD_Signal
- Moving_Average_Envelope_Hi_5/10/14/20/50/100/200_days
- Moving_Average_Envelope_Low_5/10/14/20/50/100/200_days
- Moving_Average_Of_The_High_5/10/14/20/50/100/200_days
- Moving_Average_Of_The_Low_5/10/14/20/50/100/200_days
- Moving_Dispersion
- Moving_Regression_Line_Constant_Of_Best_Fit_Line_Equation
- Moving_Regression_Line_Slope
- Moving_Standard_Deviation_5/10/14/20/50/100/200_days
- Moving_Standard_Error_5/10/14/20/50/100/200_days
- Moving_Summation
- Moving_Variance_5/10/14/20/50/100/200_days
- Normalized_Average_True_Range_NATR
- Negative_Volume_Index_NVI
- Net_Momentum_Oscillator_NMO
- On_Balance_Volume_Expanded_System_Array
- On_Balance_Volume_Expanded_System_Breakout
- On_Balance_Volume_Expanded_System_Field_Trend
- On_Balance_Volume_Moving
- On_Balance_Volume_OBV
- Oscillator_Open_to_Close
- Oscillator_Percent_Open_to_Close
- Parabolic_SAR
- Parabolic_SAR_Position
- Percentage_Volume_Oscillator_PVO
- Performance_Indicator
- Polarized_Fractal_Efficiency_PFE
- Positive_Volume_Index_PVI
- Price_and_Volume_Trend_PVT
- Price_Channels_Hi
- Price_Channels_Low
- Price_Oscillator
- Price_Oscillator_Percent
- Price_Volume_Rank
- Projection_Bands_Hi
- Projection_Bands_Low
- Projection_Oscillator
- Qstick
- r_squared
- Random_Walk_Index_RWI_Hi
- Random_Walk_Index_RWI_Low
- Range_Indicator
- Rate_of_Change_ROC
- Ratio_Open_to_Close
- Relative_Momentum_Index_RMI
- Relative_Strength_Index_RSI
- Relative_Volatility_Index_RVI
- Relative_Volatility_Index_RVI_Original_Calculation
- Simple_Moving_Average_5/10/14/20/50/100/200_days
- Standard_Error_Bands_Hi_5/10/14/20/50/100/200_days
- Standard_Error_Bands_Low_5/10/14/20/50/100/200_days
- Standard_Error_Bands_Mid_5/10/14/20/50/100/200_days
- Stochastic_Oscillator_FastD
- Stochastic_Oscillator_FastK
- Stochastic_Oscillator_SlowD
- Stochastic_Oscillator_SlowK
- Stochastic_RSI
- Sum_Close_30_days
- T3_5/10/14/20/50/100/200_days
- T4_5/10/14/20/50/100/200_days
- TEMA_5/10/14/20/50/100/200_days
- Time_Series_Forcast_TSF_5/10/14/20/50/100/200_days
- Trend_Score
- Triangular_Moving_Average_10/14/20/50/100/200_days
- TRIX_5/9/10/12/14/20/26/50/100/200_days
- True_Range_TR
- True_Strength_Index_TSI
- Typical_Price
- Variable_Moving_Average_10/14/20/50/100/200_days
- Vertical_Horizontal_Filter_VHF
- VIDYA
- Volume_Adjusted_Moving_Average_10/14/20/50/100/200_days
- Weighted_Close
- Weighted_Moving_Average_10/14/20/50/100/200_days
- Welles_Wilder_Moving_Average_10/14/20/50/100/200_days
- Welles_Wilder_Summation
- Welles_Wilder_Volatility_System_ATR_Time_Constant
- Welles_Wilder_Volatility_System_Short_Long_Indicator
- Welles_Wilder_Volatility_System_Significant_Close
- Welles_Wilder_Volatility_System_Stop_Reverse_Point
- Williams_Accumulation_Distribution
- Williams_Pct_R
- Zero_Lag_Exponential_Moving_Average_10/14/20/50/100/200_days
- Zig_Zag
- BoxState (Darvas Boxes)
- IsNewBox (Darvas Boxes)
- BoxBottomBreached_Bearish (Darvas Boxes)
- BoxTopBreached_Bullish (Darvas Boxes)

For some sample select statements, refer to the embedded notebook.

**Our Mission**
OLAPTrader was created for the purpose of compiling and analyzing technical indicator data using multi-dimensional analysis – also called online analytical processing or OLAP. Using our own home grown application which leverages third party financial functions and open source libraries, we compile over 180 technical indicators (330 with our variations), 15 Fibonacci Retracements/Projections, 17 Advance/Decline Indicators, and 110 Japanese Candlestick Patterns for over 20 US and international exchanges. We feel that when you understand the power of using mutually complimentary indicators and using dimensional analysis and/or AI to find the best combinations, you give yourself a tremendous edge over other investors.