NASA Solar Wave And Mag
Develop the Oracle of DSCOVR
@kaggle.asisheriberto_nasa_solar_wave
Develop the Oracle of DSCOVR
@kaggle.asisheriberto_nasa_solar_wave
CREATE TABLE dsc_fc_summed_spectra_2022_v01 (
"n_2022_01_01_00_00_00" TIMESTAMP,
"n__6_1717" DOUBLE,
"n_1_12483" DOUBLE,
"n__4_90228" DOUBLE,
"n_38_0314" DOUBLE,
"n_0_231726" DOUBLE,
"n_46_0427" DOUBLE,
"n_44_9743" DOUBLE,
"n_55_9143" DOUBLE,
"n_43_7069" DOUBLE,
"n_65_9537" DOUBLE,
"n_63_3898" DOUBLE,
"n_153_751" DOUBLE,
"n_113_728" DOUBLE,
"n_247_075" DOUBLE,
"n_311_317" DOUBLE,
"n_410_73" DOUBLE,
"n_451_121" DOUBLE,
"n_475_199" DOUBLE,
"n_447_67" DOUBLE,
"n_467_265" DOUBLE,
"n_419_028" DOUBLE,
"n_462_876" DOUBLE,
"n_454_962" DOUBLE,
"n_410_064" DOUBLE,
"n_394_014" DOUBLE,
"n_356_12" DOUBLE,
"n_315_868" DOUBLE,
"n_365_553" DOUBLE,
"n_292_86" DOUBLE,
"n_0" DOUBLE,
"n_0_1" DOUBLE,
"n_0_2" DOUBLE,
"n_0_3" DOUBLE,
"n_0_4" DOUBLE,
"n_0_5" DOUBLE,
"n_0_6" DOUBLE,
"n_0_7" DOUBLE,
"n_0_8" DOUBLE,
"n_0_9" DOUBLE,
"n_0_10" DOUBLE,
"n_0_11" DOUBLE,
"n_0_12" DOUBLE,
"n_0_13" DOUBLE,
"n_0_14" DOUBLE,
"n_0_15" DOUBLE,
"n_0_16" DOUBLE,
"n_0_17" DOUBLE,
"n_0_18" DOUBLE,
"n_0_19" DOUBLE,
"n_0_20" DOUBLE,
"n_0_21" DOUBLE,
"n_0_22" DOUBLE,
"n_0_23" DOUBLE
);
CREATE TABLE mag_7_day (
"time_tag" TIMESTAMP,
"bx_gsm" DOUBLE,
"by_gsm" DOUBLE,
"bz_gsm" DOUBLE,
"lon_gsm" DOUBLE,
"lat_gsm" DOUBLE,
"bt" DOUBLE
);
CREATE TABLE mag_7_day_trasf (
"column1" BIGINT,
"bx_gsm" DOUBLE,
"by_gsm" DOUBLE,
"bz_gsm" DOUBLE,
"lon_gsm" DOUBLE,
"lat_gsm" DOUBLE,
"bt" DOUBLE
);
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
);
CREATE TABLE plasma_7_day (
"n_0" VARCHAR,
"n_1" VARCHAR,
"n_2" VARCHAR,
"n_3" VARCHAR
);
CREATE TABLE plasma_7_day_transf (
"column1" BIGINT,
"density" DOUBLE,
"speed" DOUBLE,
"temperature" DOUBLE
);
Anyone who has the link will be able to view this.