All Of The Optiver Leaderboard Files
(a collection of all the raw csv files)
@kaggle.carlmcbrideellis_optiver_public_leaderboard_files
(a collection of all the raw csv files)
@kaggle.carlmcbrideellis_optiver_public_leaderboard_files
CREATE TABLE merged_optiver_scores (
"teamid" BIGINT,
"teamname" VARCHAR,
"position_0" BIGINT,
"score_0" DOUBLE,
"position_1" DOUBLE,
"score_1" DOUBLE,
"position_2" DOUBLE,
"score_2" DOUBLE,
"position_3" DOUBLE,
"score_3" DOUBLE,
"position_4" DOUBLE,
"score_4" DOUBLE,
"position_5" DOUBLE,
"score_5" DOUBLE,
"position_6" DOUBLE,
"score_6" DOUBLE,
"position_7" DOUBLE,
"score_final" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_00 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_01 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_02 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_02_v2 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_03 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_04 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_05 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE optiver_realized_volatility_prediction_publicleaderboard_06 (
"teamid" BIGINT,
"teamname" VARCHAR,
"submissiondate" TIMESTAMP,
"score" DOUBLE
);
CREATE TABLE privateleaderboardrank (
"teamid" BIGINT,
"teamname" VARCHAR,
"privateleaderboardrank" DOUBLE,
"privateleaderboardscore" DOUBLE
);
Anyone who has the link will be able to view this.