Name: Market-Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Market-Data

The dataset is crawled from NSE site and all the information is stored in csv and json for analysis. The dataset you've crawled includes the following columns: priority symbol identifier open dayHigh dayLow lastPrice previousClose change pChange ffmc yearHigh yearLow totalTradedVolume totalTradedValue lastUpdateTime nearWKH nearWKL perChange365d date365dAgo chart365dPath date30dAgo perChange30d chart30dPath chartTodayPath series meta

Tables

Etf

@kaggle.bishop36_market_data.etf

71.88 kB
211 rows
28 columns

CREATE TABLE etf (
  "symbol" VARCHAR,
  "assets" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "ltp" DOUBLE,
  "chn" DOUBLE,
  "per" DOUBLE,
  "qty" BIGINT,
  "trdval" DOUBLE,
  "nav" DOUBLE,
  "wkhi" DOUBLE,
  "wklo" DOUBLE,
  "xdt" VARCHAR,
  "cact" VARCHAR,
  "ypc" DOUBLE,
  "mpc" DOUBLE,
  "prevclose" DOUBLE,
  "nearwkh" DOUBLE,
  "nearwkl" DOUBLE,
  "charttodaypath" VARCHAR,
  "perchange365d" VARCHAR,
  "date365dago" VARCHAR,
  "chart365dpath" VARCHAR,
  "date30dago" VARCHAR,
  "perchange30d" VARCHAR,
  "chart30dpath" VARCHAR,
  "meta" VARCHAR
);

Nifty50 Stocks

@kaggle.bishop36_market_data.nifty50_stocks

35.84 kB
49 rows
27 columns

CREATE TABLE nifty50_stocks (
  "priority" BIGINT,
  "symbol" VARCHAR,
  "identifier" VARCHAR,
  "open" DOUBLE,
  "dayhigh" DOUBLE,
  "daylow" DOUBLE,
  "lastprice" DOUBLE,
  "previousclose" DOUBLE,
  "change" DOUBLE,
  "pchange" DOUBLE,
  "ffmc" DOUBLE,
  "yearhigh" DOUBLE,
  "yearlow" DOUBLE,
  "totaltradedvolume" BIGINT,
  "totaltradedvalue" DOUBLE,
  "lastupdatetime" TIMESTAMP,
  "nearwkh" DOUBLE,
  "nearwkl" DOUBLE,
  "perchange365d" DOUBLE,
  "date365dago" TIMESTAMP,
  "chart365dpath" VARCHAR,
  "date30dago" TIMESTAMP,
  "perchange30d" DOUBLE,
  "chart30dpath" VARCHAR,
  "charttodaypath" VARCHAR,
  "series" VARCHAR,
  "meta" VARCHAR
);

Sgb

@kaggle.bishop36_market_data.sgb

33.65 kB
61 rows
28 columns

CREATE TABLE sgb (
  "symbol" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "issue_price" BIGINT,
  "ltp" DOUBLE,
  "chn" DOUBLE,
  "per" DOUBLE,
  "qty" BIGINT,
  "trdval" DOUBLE,
  "wkhi" DOUBLE,
  "wklo" DOUBLE,
  "xdt" VARCHAR,
  "cact" VARCHAR,
  "ypc" DOUBLE,
  "mpc" DOUBLE,
  "prevclose" DOUBLE,
  "nearwkh" DOUBLE,
  "nearwkl" DOUBLE,
  "maturitydate" VARCHAR,
  "charttodaypath" VARCHAR,
  "perchange365d" VARCHAR,
  "date365dago" VARCHAR,
  "chart365dpath" VARCHAR,
  "date30dago" VARCHAR,
  "perchange30d" VARCHAR,
  "chart30dpath" VARCHAR,
  "meta" VARCHAR
);

Sme

@kaggle.bishop36_market_data.sme

71.92 kB
211 rows
28 columns

CREATE TABLE sme (
  "symbol" VARCHAR,
  "assets" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "ltp" DOUBLE,
  "chn" DOUBLE,
  "per" DOUBLE,
  "qty" BIGINT,
  "trdval" DOUBLE,
  "nav" DOUBLE,
  "wkhi" DOUBLE,
  "wklo" DOUBLE,
  "xdt" VARCHAR,
  "cact" VARCHAR,
  "ypc" DOUBLE,
  "mpc" DOUBLE,
  "prevclose" DOUBLE,
  "nearwkh" DOUBLE,
  "nearwkl" DOUBLE,
  "charttodaypath" VARCHAR,
  "perchange365d" VARCHAR,
  "date365dago" VARCHAR,
  "chart365dpath" VARCHAR,
  "date30dago" VARCHAR,
  "perchange30d" VARCHAR,
  "chart30dpath" VARCHAR,
  "meta" VARCHAR
);