Trading Prediction Accuracy Table Structure

Table Columns:

Column NameData Type
symboltext
pattern_idtext
long_or_shorttext
exp_pos_return_5_daysnumeric
exp_pos_return_10_daysnumeric
exp_neg_return_5_daysnumeric
exp_neg_return_10_daysnumeric
date_txndate
trade_type_5_daytext
trade_type_10_daytext
positive_5_probnumeric
negative_5_probnumeric
positive_10_probnumeric
negative_10_probnumeric
primary_idbigint
first_prediction_datedate
five_prediction_datedate
ten_prediction_datedate
prediction_met_date_5text
price_on_prediction_datenumeric
max_in_next_5_daynumeric
min_in_next_5_daynumeric
max_in_next_10_daynumeric
min_in_next_10_daynumeric
predicted_price_pos_after_5_daysnumeric
predicted_price_neg_after_5_daysnumeric
predicted_price_pos_after_10_daysnumeric
predicted_price_neg_after_10_daysnumeric
accuracy_5_day_flagtext
accuracy_10_day_flagtext
accuracy_5_day_directional_flagtext
accuracy_10_day_directional_flagtext
accuracy_degree_5_daynumeric
accuracy_degree_10_daynumeric
accuracy_per_day_for_5_day_predictionsnumeric
accuracy_per_day_for_10_day_predictionsnumeric
accuracy_direction_per_day_for_5_day_predictionsnumeric
accuracy_direction_per_day_for_10_day_predictionsnumeric
extreme_valuetext
days_to_meet_predictiontext
prediction_met_date_10text
stop_loss_5_hit_datetext
stop_loss_10_hit_datetext
prediction_timeframetext

Sample Data (first 5 rows):

symbolpattern_idlong_or_shortexp_pos_return_5_daysexp_pos_return_10_daysexp_neg_return_5_daysexp_neg_return_10_daysdate_txntrade_type_5_daytrade_type_10_daypositive_5_probnegative_5_probpositive_10_probnegative_10_probprimary_idfirst_prediction_datefive_prediction_dateten_prediction_dateprediction_met_date_5price_on_prediction_datemax_in_next_5_daymin_in_next_5_daymax_in_next_10_daymin_in_next_10_daypredicted_price_pos_after_5_dayspredicted_price_neg_after_5_dayspredicted_price_pos_after_10_dayspredicted_price_neg_after_10_daysaccuracy_5_day_flagaccuracy_10_day_flagaccuracy_5_day_directional_flagaccuracy_10_day_directional_flagaccuracy_degree_5_dayaccuracy_degree_10_dayaccuracy_per_day_for_5_day_predictionsaccuracy_per_day_for_10_day_predictionsaccuracy_direction_per_day_for_5_day_predictionsaccuracy_direction_per_day_for_10_day_predictionsextreme_valuedays_to_meet_predictionprediction_met_date_10stop_loss_5_hit_datestop_loss_10_hit_dateprediction_timeframe
MSOSA3L1L24.535925620462331001001.46-1.92-4.592026-02-26Normal TradeNormal Trade98.0648.7598.1648.979784152026-02-272026-03-062026-03-13NULL3.8647000789642334NULLNULLNULLNULL4.043.924.063.82NULLNULL-1-1NULLNULLNULLNULL0.00.0NULLNULLNULLNULLNULL5_day
CHWYA10L1S20.855970054272472685000.9-3.35-2.632026-02-26Artificial Manipulation DetectedNormal Trade97.6297.4596.4998.09786822026-02-272026-03-062026-03-13NULL26.8700008392334NULLNULLNULLNULL27.126.0727.2126.26NULLNULL-1-1NULLNULLNULLNULL0.00.0NULLNULLNULLNULLNULL5_day
KLTRA9L1L23.396222694101058310001.69-1.07-1.392026-02-26Normal TradeNormal Trade99.1994.8499.3498.99784742026-02-272026-03-062026-03-13NULL1.3250000476837158NULLNULLNULLNULL1.371.341.371.33NULLNULL-1-1NULLNULLNULLNULL0.00.0NULLNULLNULLNULLNULL5_day
MLIA3L1L22.477943613270179197000.98-0.46-0.312026-02-26Normal TradeNormal Trade98.4774.5198.6774.39784732026-02-272026-03-062026-03-13NULL118.44499969482422NULLNULLNULLNULL121.38119.91121.64120.09NULLNULL-1-1NULLNULLNULLNULL0.00.0NULLNULLNULLNULLNULL5_day
CNHA4L1L22.428814320003438013000.4-0.15-0.152026-02-26Artificial Manipulation DetectedArtificial Manipulation Detected98.4465.7398.1165.889784102026-02-272026-03-062026-03-13NULL11.9399995803833NULLNULLNULLNULL12.2312.1312.212.13NULLNULL-1-1NULLNULLNULLNULL0.00.0NULLNULLNULLNULLNULL5_day

Total rows in table: 138