Huge Transactional Dataset

CREATE TABLE transactions (
  "unnamed_0" BIGINT,
  "transactionid" BIGINT,
  "amount" BIGINT,
  "posno" BIGINT,
  "customerid" BIGINT,
  "location" BIGINT,
  "businesssector" BIGINT,
  "timestamp" TIMESTAMP,
  "time" VARCHAR,
  "hour" BIGINT,
  "minute" BIGINT,
  "second" BIGINT,
  "nighttransaction" BIGINT,
  "date" BIGINT,
  "standarddate" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "dayofmonth" BIGINT
);