PREVIEW / stock_daily / 2017-11-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-01.parquet
  size:    216 KB
  rows:    6,444
  symbols: 2,896

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2017-11-01	AAPL	Stock	42.4675	42.485	41.4025	41.7225	134551200.0
2017-11-01	MSFT	Stock	83.68	83.76	82.88	83.18	22307400.0
2017-11-01	NVDA	Stock	5.2338	5.2492	5.115	5.18	502576000.0
2017-11-01	AMZN	Stock	55.27	55.4485	54.837	55.184	75110000.0
2017-11-01	GOOGL	Stock	51.8158	52.393	51.7	52.1298	43261460.0
2017-11-01	META	Stock	182.36	182.9	180.57	182.66	40918300.0
2017-11-01	TSLA	Stock	22.15	22.174	21.3507	21.4053	126859500.0
2017-11-01	TLT	Stock	124.35	125.14	124.3	124.75	8940443.0
2017-11-01	ES	Stock	62.79	63.06	61.98	62.68	2622800.0
2017-11-01	CL	Stock	70.72	70.9	70.39	70.56	3279600.0
2017-11-01	A	Stock	68.2	68.44	67.84	68.02	1357300.0
2017-11-01	AA	Stock	48.91	49.27	47.45	47.7	3174600.0
2017-11-01	AAAP-DELISTED	Stock	81.0	81.5	80.81	81.0	1491874.0
2017-11-01	AABA-DELISTED	Stock	70.85	71.385	69.84	70.6048	7872782.0
2017-11-01	AAC-DELISTED	Stock	7.96	7.97	7.53	7.53	96992.0
2017-11-01	AAIC-DELISTED	Stock	11.52	11.5414	11.35	11.38	526127.0
2017-11-01	AAL	Stock	48.0	48.2	47.37	47.84	4354500.0
2017-11-01	AAM.A-DELISTED	Stock	26.2866	26.32	26.1791	26.25	3936.0
2017-11-01	AAME	Stock	3.7	3.8	3.55	3.8	9600.0
2017-11-01	AAMI	Stock	15.41	15.58	15.28	15.39	540900.0
2017-11-01	AAOI	Stock	40.41	41.466	38.83	38.97	1270600.0
2017-11-01	AAON	Stock	23.5	23.5	22.7333	22.9333	177150.0
2017-11-01	AAP	Stock	82.33	82.74	80.68	80.75	1157000.0
2017-11-01	AAT	Stock	37.25	38.87	36.79	38.76	677100.0
2017-11-01	AAU-DELISTED	Stock	1.06	1.06	1.0	1.0	279097.0
2017-11-01	AAUAF-DELISTED	Stock	1.06	1.06	1.0	1.0	288264.0
2017-11-01	AAV-DELISTED	Stock	5.35	5.6343	5.35	5.6	274934.0
2017-11-01	AAWW-DELISTED	Stock	61.95	62.625	60.75	61.6	200518.0
2017-11-01	AAXJ	Stock	76.23	76.35	75.85	75.96	2869473.0
2017-11-01	AAXN-DELISTED	Stock	23.0	23.045	22.81	23.03	380753.0
2017-11-01	AB	Stock	25.9	26.0	25.65	25.9	135300.0
2017-11-01	ABAC-DELISTED	Stock	3.3836	3.4	3.3284	3.4	10186.0
2017-11-01	ABAX-DELISTED	Stock	48.34	48.38	47.26	47.77	72491.0
2017-11-01	ABB-DELISTED	Stock	26.47	26.48	26.24	26.25	1988126.0
2017-11-01	ABBNY-DELISTED	Stock	26.47	26.48	26.24	26.24	2051220.0
2017-11-01	ABBV	Stock	90.78	93.34	90.27	92.44	7048800.0
2017-11-01	ABC-DELISTED	Stock	77.48	77.495	76.31	76.63	2194308.0
2017-11-01	ABCB	Stock	48.3	48.65	47.15	47.65	83100.0
2017-11-01	ABCD-DELISTED	Stock	6.15	6.195	5.95	6.11	27545.0
2017-11-01	ABCO-DELISTED	Stock	53.95	53.95	53.675	53.8	770272.0
2017-11-01	ABDC-DELISTED	Stock	9.26	9.33	8.51	8.75	218765.0
2017-11-01	ABE-DELISTED	Stock	14.51	14.53	14.43	14.43	14604.0
2017-11-01	ABEO	Stock	452.5	452.5	403.75	410.0	53504.0
2017-11-01	ABEOW-DELISTED	Stock	11.78	11.93	11.16	11.4	8600.0
2017-11-01	ABEV	Stock	6.38	6.45	6.29	6.29	20600600.0
2017-11-01	ABG	Stock	61.25	62.55	60.65	62.45	361200.0
2017-11-01	ABIL-DELISTED	Stock	0.6404	0.66	0.6404	0.65	15584.0
2017-11-01	ABLX-DELISTED	Stock	20.73	21.175	20.61	21.0	564911.0
2017-11-01	ABM	Stock	42.08	42.2	41.0	41.13	226600.0
2017-11-01	ABMD-DELISTED	Stock	192.98	194.42	188.12	188.91	281836.0

> showing 50 of 6,444 rows — these rows as CSV

> unlock the full archive -- $79 one-time