NASA Solar Wave And Mag

Develop the Oracle of DSCOVR

@kaggle.asisheriberto_nasa_solar_wave

Table List

6 tables(105.92 MB)

Dsc Fc Summed Spectra 2022 V01

Mag And Solarwind

@kaggle.asisheriberto_nasa_solar_wave.mag_and_solarwind

177.74 KB
1264 rows
30 columns

timestamp Timestamp	bt_med Bt-med	bt_min Bt-min	bt_max Bt-max	bx_med Bx-med	bx_min Bx-min	bx_max Bx-max	by_med By-med	by_min By-min	by_max By-max	bz_med Bz-med	bz_min Bz-min	bz_max Bz-max	phi_mean Phi-mean	phi_min Phi-min	phi_max Phi-max	theta_med Theta-med	theta_min Theta-min	theta_max Theta-max	dens_med Dens-med	dens_min Dens-min	dens_max Dens-max	speed_med Speed-med	speed_min Speed-min	speed_max Speed-max	temp_med Temp-med	temp_min Temp-min	temp_max Temp-max
1	3.78	2.41	3.94	-0.47	-1.89	1.03	-2.95	-3.71	0.57	2.12	-1.34	3.82	264.11	12.22	340.25	35.95	-28.66	84.55	1.3	0.85	3.46	354.94	351.18	359.63	42043	25990	53268
2	4.39	3.63	5.07	-0.96	-1.61	0.69	-4.19	-4.84	0.18	1.21	-0.48	4.14	270.81	51.85	328.12	15.57	-5.79	85.32	2.07	1.52	2.96	355.54	349.42	359.23	39564	30904	51431
3	3.34	1.91	4.74	0.02	-2.95	1.75	-2.31	-4.47	1.27	-0.17	-3.7	2.41	274.69	6.95	319.39	-2.77	-76.6	50.53	2.57	1.29	4.6	352.31	342.73	361.68	40378	27786	62475
4	4.32	3.06	4.77	0.26	-0.47	0.81	-2.7	-3.91	-1.28	3.34	0.15	4.27	275.26	260.01	293.53	50.93	2.73	70.94	1.94	1	2.34	356.76	345.55	360.5	46960	35443	57584
5	3.75	1.65	4.57	0.65	-0.67	2.22	-2.61	-3.77	1.35	2.33	-1.95	3.57	291.16	20.67	348.62	34.65	-43.62	60.06	2.8	1.9	4.51	357.85	351.55	361.68	49492	32079	65849
6	4.16	2.3	4.79	1.31	-4.23	2.68	-2.39	-3.3	-0.12	2.77	-1.6	4.11	281.16	180.22	318.89	40.28	-30.28	62.46	2.49	1.23	4.15	355.38	342.95	372.56	57062	27358	87930
7	4.56	1.16	4.91	-1.16	-4.41	2.34	-0.56	-2.03	3.14	2.92	-1.83	4.63	188.31	12.35	295.2	37.74	-35.26	87.14	2.06	1.14	3.92	361.99	349.93	375.54	51335	34819	76479
8	2.68	1.14	3.64	1.44	-1.04	2.65	-0.48	-3.1	1.52	1.61	-1.75	3.44	343.02	4.42	357.67	38.36	-44.62	75.1	2.41	1.63	3.69	360.25	344.6	368.69	65470	34259	97171
9	3.8	3.11	4.42	1.74	0.1	3.07	2.22	-1.19	3.8	1.79	-0.57	3.69	40.83	2.18	357.83	25.85	-7.93	80.61	1.86	0.92	2.72	356.62	347.89	364.58	62573	37610	93403
10	3.91	3	4.44	2.09	-0.96	2.63	3.25	1.55	3.95	-0.43	-1.82	2.21	59.26	36.3	88.48	-6.1	-34.91	39.39	2.02	1.13	3.13	353.97	333.87	362.73	52662	34630	85045


CREATE TABLE mag_and_solarwind (
  "timestamp" BIGINT,
  "source" BIGINT,
  "bt_med" DOUBLE,
  "bt_min" DOUBLE,
  "bt_max" DOUBLE,
  "bx_med" DOUBLE,
  "bx_min" DOUBLE,
  "bx_max" DOUBLE,
  "by_med" DOUBLE,
  "by_min" DOUBLE,
  "by_max" DOUBLE,
  "bz_med" DOUBLE,
  "bz_min" DOUBLE,
  "bz_max" DOUBLE,
  "phi_mean" DOUBLE,
  "phi_min" DOUBLE,
  "phi_max" DOUBLE,
  "theta_med" DOUBLE,
  "theta_min" DOUBLE,
  "theta_max" DOUBLE,
  "dens_med" DOUBLE,
  "dens_min" DOUBLE,
  "dens_max" DOUBLE,
  "speed_med" DOUBLE,
  "speed_min" DOUBLE,
  "speed_max" DOUBLE,
  "temp_med" BIGINT,
  "temp_min" BIGINT,
  "temp_max" BIGINT,
  "n__1" VARCHAR
);