NIFTY-50 Stock Market Data (2000 - 2021)

date Date	symbol Symbol	series Series	prev_close Prev Close	open Open	high High	low Low	last Last	close Close	vwap VWAP	volume Volume	turnover Turnover
Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	703.25	705	759.5	705	758	756.9	741.01	7512	556648765000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	756.9	710	770	710	740	754.55	742.52	8135	604039070000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	754.55	755	759	705	740	735.3	739.92	6095	450978430000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	735.3	740	794.15	740	770	785.65	788.83	19697	1553755555000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	785.65	808	848.5	798	848.5	848.5	827.53	33107	2739708030000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	848.5	900	916.4	865	916.4	912.2	905.42	29575	2677784025000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	912.2	920	920	839.25	865	853.75	858.02	20635	1770515830000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	853.75	900	900	860.55	890.95	882.7	885.18	9312	824275625000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	882.7	890	920	875	885	881.4	898.96	19526	1755312510000.0002
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	EQ	881.4	872.5	880	864	870	869.65	873.91	15675	1369847005000


CREATE TABLE britannia (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "series" VARCHAR,
  "prev_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "last" DOUBLE,
  "close" DOUBLE,
  "vwap" DOUBLE,
  "volume" BIGINT,
  "turnover" DOUBLE,
  "trades" DOUBLE,
  "deliverable_volume" DOUBLE,
  "n__deliverble" DOUBLE
);