Daily Stock Prices, Technical Indicators & Metadata | Asia Exchanges | AI Fact Table
收藏Databricks2024-05-21 收录
下载链接:
https://marketplace.databricks.com/details/e957b47e-2ce1-45a1-9f58-e7012f8c2821/OLAPTrader_Daily-Stock-Prices,-Technical-Indicators-&-Metadata-Asia-Exchanges-AI-Fact-Table
下载链接
链接失效反馈官方服务:
资源简介:
**Overview**
This offering includes Daily OHLCV, Metadata and over 180 Technical Indicators (330 with variations) for 9 Asia Stock Exchanges.
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:**
* Bombay Stock Exchange
* National Stock Exchange - India
* Shanghai Stock Exchange
* Shenzhen Stock Exchange
* Singapore Stock Exchange
* Hong Kong Stock Exchange
* Korea Stock Exchange
* Tokyo Stock Exchange
* Saudi Arabia Stock Exchange (Tadawul)
**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 the following times:
Tokyo Stock Exchange | ~4:45 am Eastern Time (M-F)
Shenzhen Stock Exchange | ~5:45 am Eastern Time (M-F)
Shanghai Stock Exchange | ~5:45 am Eastern Time (M-F)
Korea Stock Exchange | ~5:15 am Eastern Time (M-F)
Singapore Stock Exchange |~7:25 am Eastern Time (M-F)
National Stock Exchange | ~10:00 am Eastern Time (M-F)
Hong Kong Stock Exchange | ~8:25 am Eastern Time (M-F)
Bombay Stock Exchange | ~10:00 am Eastern Time (M-F)
Saudi Arabia | ~1:25 pm Eastern Time (M-F)
We will publish sooner and will have multiple revisions per day in the future based on demand
**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 example, for Tokyo, we compare to TOPIX 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.
提供机构:
OLAPTrader



