PREVIEW / stock_daily / 2018-01-19

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-19.parquet
  size:    218 KB
  rows:    6,495
  symbols: 2,876

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
2018-01-19	AAPL	Stock	44.6525	44.895	44.3525	44.615	129700400.0
2018-01-19	MSFT	Stock	90.14	90.61	89.66	90.0	36875000.0
2018-01-19	NVDA	Stock	5.7022	5.7773	5.675	5.7528	609380000.0
2018-01-19	AMZN	Stock	65.6	65.65	64.6495	64.729	91570000.0
2018-01-19	GOOGL	Stock	56.9015	57.189	56.625	57.175	30551080.0
2018-01-19	META	Stock	180.85	182.37	180.17	181.29	26826500.0
2018-01-19	TSLA	Stock	23.0	23.3727	22.84	23.3347	73324500.0
2018-01-19	TLT	Stock	123.4	123.56	122.98	123.06	11374309.0
2018-01-19	ES	Stock	60.98	61.19	60.65	60.79	2158000.0
2018-01-19	CL	Stock	76.96	77.91	76.8	77.5	4480600.0
2018-01-19	A	Stock	72.48	73.22	72.06	73.07	2266100.0
2018-01-19	AA	Stock	52.86	53.68	52.55	53.1	5759600.0
2018-01-19	AAAP-DELISTED	Stock	81.88	81.97	81.86	81.96	175574.0
2018-01-19	AABA-DELISTED	Stock	74.39	74.67	73.71	74.35	6723682.0
2018-01-19	AAC-DELISTED	Stock	9.0	9.27	9.0	9.19	97860.0
2018-01-19	AACG	Stock	5.68	5.68	5.66	5.68	500.0
2018-01-19	AAIC-DELISTED	Stock	11.74	11.77	11.64	11.77	333205.0
2018-01-19	AAL	Stock	58.59	58.59	57.76	58.06	3151200.0
2018-01-19	AAM.A-DELISTED	Stock	25.665	25.69	25.51	25.51	18458.0
2018-01-19	AAME	Stock	3.4	3.5	3.4	3.49	2900.0
2018-01-19	AAMI	Stock	18.15	18.47	18.15	18.36	647200.0
2018-01-19	AAOI	Stock	34.87	36.18	34.015	35.03	2505700.0
2018-01-19	AAON	Stock	24.0667	24.8667	24.0333	24.8667	276600.0
2018-01-19	AAP	Stock	116.24	117.51	115.21	117.02	1169900.0
2018-01-19	AAT	Stock	35.73	36.22	35.73	36.22	143600.0
2018-01-19	AAU-DELISTED	Stock	0.9454	0.9702	0.92	0.9201	151991.0
2018-01-19	AAUAF-DELISTED	Stock	0.9454	0.9702	0.92	0.9201	153465.0
2018-01-19	AAV-DELISTED	Stock	3.5	3.5	3.35	3.5	386682.0
2018-01-19	AAWW-DELISTED	Stock	61.5	62.6	60.85	62.05	165887.0
2018-01-19	AAXJ	Stock	81.14	81.32	80.82	81.32	494112.0
2018-01-19	AAXN-DELISTED	Stock	27.41	27.5661	27.16	27.47	275846.0
2018-01-19	AB	Stock	27.15	27.55	27.01	27.5	238000.0
2018-01-19	ABAC-DELISTED	Stock	2.8399	3.0	2.68	2.99	26796.0
2018-01-19	ABAX-DELISTED	Stock	60.74	61.39	60.66	61.16	112447.0
2018-01-19	ABB-DELISTED	Stock	28.09	28.11	27.97	28.015	1074132.0
2018-01-19	ABBNY-DELISTED	Stock	28.09	28.11	27.97	28.01	1122175.0
2018-01-19	ABBV	Stock	104.33	104.87	103.55	104.64	4991300.0
2018-01-19	ABC-DELISTED	Stock	100.87	101.58	99.63	100.05	1180428.0
2018-01-19	ABCB	Stock	53.35	53.85	53.3	53.85	173300.0
2018-01-19	ABCD-DELISTED	Stock	6.91	7.07	6.85	6.86	126578.0
2018-01-19	ABDC-DELISTED	Stock	8.33	8.37	8.3	8.37	69766.0
2018-01-19	ABE-DELISTED	Stock	15.33	15.46	15.2901	15.4283	10197.0
2018-01-19	ABEO	Stock	366.25	373.25	356.25	365.0	16888.0
2018-01-19	ABEOW-DELISTED	Stock	9.8243	9.8243	9.549	9.549	600.0
2018-01-19	ABEV	Stock	6.78	6.87	6.76	6.86	14321600.0
2018-01-19	ABG	Stock	72.95	74.2	72.22	73.9	252700.0
2018-01-19	ABIL-DELISTED	Stock	0.5	0.51	0.48	0.4856	109914.0
2018-01-19	ABLX-DELISTED	Stock	42.22	42.38	41.25	41.64	181751.0
2018-01-19	ABM	Stock	38.76	39.82	38.76	39.77	397000.0
2018-01-19	ABMD-DELISTED	Stock	227.33	229.0472	226.09	228.31	128054.0

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

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