PREVIEW / stock_daily / 2017-03-22

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-22.parquet
  size:    215 KB
  rows:    6,459
  symbols: 3,050

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-03-22	AAPL	Stock	34.9625	35.4	34.94	35.355	103440800.0
2017-03-22	MSFT	Stock	64.12	65.14	64.12	65.03	20680000.0
2017-03-22	NVDA	Stock	2.6365	2.7065	2.6325	2.7018	616764000.0
2017-03-22	AMZN	Stock	42.0215	42.4685	41.9525	42.403	53174000.0
2017-03-22	GOOGL	Stock	42.474	42.7675	42.35	42.49	27334980.0
2017-03-22	META	Stock	137.93	139.79	137.6	139.59	17055400.0
2017-03-22	TSLA	Stock	16.7707	17.0047	16.7007	17.0007	60889500.0
2017-03-22	TLT	Stock	120.72	121.17	120.43	120.62	11661374.0
2017-03-22	ES	Stock	59.76	60.21	59.52	59.71	1514200.0
2017-03-22	CL	Stock	74.01	74.25	73.46	73.68	2810900.0
2017-03-22	A	Stock	52.79	53.47	52.65	53.13	1257100.0
2017-03-22	AA	Stock	33.35	34.15	33.01	33.69	2877900.0
2017-03-22	AAAP-DELISTED	Stock	36.99	38.01	36.89	37.3	44647.0
2017-03-22	AABA-DELISTED	Stock	45.61	46.14	45.6	46.07	6417037.0
2017-03-22	AAC-DELISTED	Stock	8.25	8.278	7.875	7.98	118428.0
2017-03-22	AACG	Stock	3.7	3.79	3.54	3.76	9200.0
2017-03-22	AAIC-DELISTED	Stock	14.22	14.36	14.16	14.28	366385.0
2017-03-22	AAL	Stock	39.78	40.55	39.21	40.35	9943000.0
2017-03-22	AAM.A-DELISTED	Stock	24.96	25.08	24.95	24.98	245850.0
2017-03-22	AAMC-DELISTED	Stock	17.5147	19.1324	16.7206	17.0441	76252.0
2017-03-22	AAME	Stock	3.8	3.8	3.7	3.7	1400.0
2017-03-22	AAMI	Stock	14.11	14.27	13.98	14.25	372400.0
2017-03-22	AAOI	Stock	48.02	53.09	47.06	52.63	2207300.0
2017-03-22	AAON	Stock	23.8333	24.0	23.6333	23.7333	234900.0
2017-03-22	AAP	Stock	151.6	152.06	150.46	151.27	661400.0
2017-03-22	AAT	Stock	41.76	42.13	40.99	41.2	489200.0
2017-03-22	AAU-DELISTED	Stock	1.16	1.22	1.13	1.145	296874.0
2017-03-22	AAUAF-DELISTED	Stock	1.16	1.22	1.13	1.145	307291.0
2017-03-22	AAV-DELISTED	Stock	6.0	6.025	5.9	5.95	57027.0
2017-03-22	AAWW-DELISTED	Stock	51.25	51.65	50.6	51.4	110097.0
2017-03-22	AAXJ	Stock	62.86	63.29	62.81	63.2	490122.0
2017-03-22	AAXN-DELISTED	Stock	22.47	22.93	22.22	22.45	567323.0
2017-03-22	AB	Stock	21.8	21.9	21.7	21.7	468500.0
2017-03-22	ABAC-DELISTED	Stock	2.33	2.38	2.21	2.3	33914.0
2017-03-22	ABAX-DELISTED	Stock	47.6	48.5	47.5	48.45	76223.0
2017-03-22	ABB-DELISTED	Stock	22.97	23.19	22.905	23.17	2731867.0
2017-03-22	ABBNY-DELISTED	Stock	22.97	23.19	22.905	23.17	2781251.0
2017-03-22	ABBV	Stock	65.38	65.73	65.1	65.52	5662600.0
2017-03-22	ABC-DELISTED	Stock	86.12	86.28	85.22	85.87	983975.0
2017-03-22	ABCB	Stock	44.0	44.5	42.7	43.35	306400.0
2017-03-22	ABCD-DELISTED	Stock	4.95	5.25	4.94	5.0901	110356.0
2017-03-22	ABCO-DELISTED	Stock	44.95	47.0	44.4	44.75	1028889.0
2017-03-22	ABDC-DELISTED	Stock	13.43	13.54	13.18	13.34	46981.0
2017-03-22	ABE-DELISTED	Stock	12.62	12.62	12.54	12.58	8334.0
2017-03-22	ABEO	Stock	120.0	122.5	113.75	118.75	12996.0
2017-03-22	ABEV	Stock	5.57	5.61	5.51	5.53	13666600.0
2017-03-22	ABG	Stock	60.5	60.8	59.25	60.35	314800.0
2017-03-22	ABIL-DELISTED	Stock	2.44	2.44	2.3	2.32	10350.0
2017-03-22	ABM	Stock	43.44	43.63	43.07	43.3	240300.0
2017-03-22	ABMD-DELISTED	Stock	122.36	123.66	121.86	123.44	188073.0

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

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