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	deliverable_volume Deliverable Volume	n__deliverble %Deliverble
Tue Aug 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	10	305	340	253.25	259	260.2	268.8	6633956	178323693135000	970249	0.1463
Wed Aug 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	260.2	262	264.7	249.2	255	255.55	255.54	2794161	71401072765000	584835	0.2093
Thu Aug 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	255.55	257.75	272.5	256	270.1	270.7	267	2340926	62502313585000	443707	0.1895
Fri Aug 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	270.7	272	272.55	260.65	261.35	262.25	264.4	915106	24195293220000	222763	0.2434
Mon Aug 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	262.25	263.7	269	262.05	267	266.1	265.38	387417	10281084615000	84031	0.2169
Tue Aug 31 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	266.1	266.8	267.8	264.3	266.45	266.2	266	261123	6945977815000.001	85009	0.3256
Wed Sep 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	266.2	267	273.45	265	267	267.2	269.43	311985	8405950375000	67745	0.2171
Thu Sep 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	267.2	267.85	269.5	260	264	262.2	264.61	205537	5438734245000	75679	0.3682
Fri Sep 03 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	262.2	262.2	264.9	257.5	262.65	262.65	261	303156	7912255820000	165614	0.5463
Mon Sep 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	EQ	262.65	263.5	267.85	263	264.75	265.3	265.9	74691	1986045295000	29535	0.3954


CREATE TABLE ultracemco (
  "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" BIGINT,
  "n__deliverble" DOUBLE
);