Baselight

NSE-Cash.Market-Bhavcopies-2001

NSE India's Bhavcopy dataset for Cash market

@kaggle.mayookhlad_nsecashmarketbhavcopies2001

Cm21dec2001bhav
@kaggle.mayookhlad_nsecashmarketbhavcopies2001.cm21dec2001bhav

  • 58.19 KB
  • 1143 rows
  • 12 columns
symbol

SYMBOL

series

SERIES

open

OPEN

high

HIGH

low

LOW

close

CLOSE

last

LAST

prevclose

PREVCLOSE

tottrdqty

TOTTRDQTY

tottrdval

TOTTRDVAL

timestamp

TIMESTAMP

unnamed_11

Unnamed: 11

AARTIDRUGSBE2425.52424.52524.7281368428.25Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
AARTIDRUGSEQ262626262625.11002600Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
AARTIINDBE35.535.535.535.535.535.75200071000Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABANLLOYDBE37.7538.2537.138.2538.2539.17907300400Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABANLLOYDEQ37.238.537.138.538.538.852107871Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABBEQ199201.4198200.05199.7199.8125512504119.05Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABBALPOBE35.637.835.537.237.537.455687208978.35Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABBALPOEQ36.23836.236.5536.5537153356236.15Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABBOTTLABBE153153137.25141.85141148.15760107450.5Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
ABBOTTLABEQ140.25145139.5142.314514737452467.25Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATE TABLE cm21dec2001bhav (
  "symbol" VARCHAR,
  "series" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "last" DOUBLE,
  "prevclose" DOUBLE,
  "tottrdqty" BIGINT,
  "tottrdval" DOUBLE,
  "timestamp" TIMESTAMP,
  "unnamed_11" VARCHAR
);

Share link

Anyone who has the link will be able to view this.