Ibovespa Index

CREATE TABLE ibovespa_indexq (
  "date" TIMESTAMP,
  "abev3" DOUBLE,
  "alpa4" DOUBLE,
  "amer3" DOUBLE,
  "arzz3" DOUBLE,
  "asai3" DOUBLE,
  "azul4" DOUBLE,
  "b3sa3" DOUBLE,
  "bbas3" DOUBLE,
  "bbdc3" DOUBLE,
  "bbdc4" DOUBLE,
  "bbse3" DOUBLE,
  "beef3" DOUBLE,
  "bpac11" DOUBLE,
  "bpan4" DOUBLE,
  "brap4" DOUBLE,
  "brfs3" DOUBLE,
  "brkm5" DOUBLE,
  "brml3" DOUBLE,
  "cash3" DOUBLE,
  "ccro3" DOUBLE,
  "ciel3" DOUBLE,
  "cmig4" DOUBLE,
  "cmin3" DOUBLE,
  "cogn3" DOUBLE,
  "cpfe3" DOUBLE,
  "cple6" DOUBLE,
  "crfb3" DOUBLE,
  "csan3" DOUBLE,
  "csna3" DOUBLE,
  "cvcb3" DOUBLE,
  "cyre3" DOUBLE,
  "dxco3" DOUBLE,
  "ecor3" DOUBLE,
  "egie3" DOUBLE,
  "elet3" DOUBLE,
  "elet6" DOUBLE,
  "embr3" DOUBLE,
  "enbr3" DOUBLE,
  "enev3" DOUBLE,
  "engi11" DOUBLE,
  "eqtl3" DOUBLE,
  "eztc3" DOUBLE,
  "flry3" DOUBLE,
  "ggbr4" DOUBLE,
  "goau4" DOUBLE,
  "goll4" DOUBLE,
  "hapv3" DOUBLE,
  "hype3" DOUBLE,
  "igti11" DOUBLE,
  "irbr3" DOUBLE,
  "itsa4" DOUBLE,
  "itub4" DOUBLE,
  "jbss3" DOUBLE,
  "klbn11" DOUBLE,
  "lren3" DOUBLE,
  "lwsa3" DOUBLE,
  "mglu3" DOUBLE,
  "mrfg3" DOUBLE,
  "mrve3" DOUBLE,
  "mult3" DOUBLE,
  "ntco3" DOUBLE,
  "pcar3" DOUBLE,
  "petr3" DOUBLE,
  "petr4" DOUBLE,
  "petz3" DOUBLE,
  "posi3" DOUBLE,
  "prio3" DOUBLE,
  "qual3" DOUBLE,
  "radl3" DOUBLE,
  "rail3" DOUBLE,
  "raiz4" DOUBLE,
  "rdor3" DOUBLE,
  "rent3" DOUBLE,
  "rrrp3" DOUBLE,
  "sanb11" DOUBLE,
  "sbsp3" DOUBLE,
  "slce3" DOUBLE,
  "smto3" DOUBLE,
  "soma3" DOUBLE,
  "sula11" DOUBLE,
  "suzb3" DOUBLE,
  "taee11" DOUBLE,
  "tims3" DOUBLE,
  "tots3" DOUBLE,
  "ugpa3" DOUBLE,
  "usim5" DOUBLE,
  "vale3" DOUBLE,
  "vbbr3" DOUBLE,
  "viia3" DOUBLE,
  "vivt3" DOUBLE,
  "wege3" DOUBLE,
  "yduq3" DOUBLE,
  "bvsp" DOUBLE
);

CREATE TABLE ibovespa_info (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "setor" VARCHAR,
  "c_digo" VARCHAR,
  "a_o" VARCHAR  -- Ação,
  "tipo" VARCHAR,
  "qtde_te_rica" BIGINT  -- Qtde. Teórica,
  "part" DOUBLE  -- Part. (%),
  "part_acum" DOUBLE  -- Part. (%)Acum.
);