PREVIEW / stock_daily / 2017-03-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-07.parquet
  size:    214 KB
  rows:    6,451
  symbols: 3,051

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-07	AAPL	Stock	34.765	34.995	34.6975	34.88	69785200.0
2017-03-07	MSFT	Stock	64.19	64.78	64.19	64.4	18521000.0
2017-03-07	NVDA	Stock	2.4418	2.4883	2.4288	2.4685	603400000.0
2017-03-07	AMZN	Stock	42.274	42.423	42.1875	42.301	44952000.0
2017-03-07	GOOGL	Stock	42.363	42.6665	42.276	42.5575	20773920.0
2017-03-07	META	Stock	137.03	138.37	136.99	137.3	13527100.0
2017-03-07	TSLA	Stock	16.7947	16.926	16.5547	16.5727	51892500.0
2017-03-07	TLT	Stock	118.48	118.68	118.25	118.42	7080088.0
2017-03-07	ES	Stock	58.19	58.77	58.19	58.56	1652800.0
2017-03-07	CL	Stock	73.6	73.89	73.54	73.72	3216200.0
2017-03-07	A	Stock	51.06	51.45	50.86	51.21	2233600.0
2017-03-07	AA	Stock	36.81	36.89	35.75	35.8	3753400.0
2017-03-07	AAAP-DELISTED	Stock	38.18	38.3	37.69	38.1	59773.0
2017-03-07	AABA-DELISTED	Stock	45.5	45.915	45.49	45.73	4922433.0
2017-03-07	AAC-DELISTED	Stock	8.95	8.97	8.64	8.71	108089.0
2017-03-07	AACG	Stock	3.68	3.78	3.42	3.58	18900.0
2017-03-07	AAIC-DELISTED	Stock	14.07	14.19	13.84	13.88	375425.0
2017-03-07	AAL	Stock	45.02	45.23	44.56	44.84	4565300.0
2017-03-07	AAMC-DELISTED	Stock	23.6471	23.6471	22.5735	22.7647	31919.0
2017-03-07	AAME	Stock	3.7	3.7	3.7	3.7	300.0
2017-03-07	AAMI	Stock	14.95	15.06	14.73	14.82	280900.0
2017-03-07	AAOI	Stock	51.31	56.14	50.54	54.54	1902200.0
2017-03-07	AAON	Stock	23.0667	23.4	22.9667	23.2667	321300.0
2017-03-07	AAP	Stock	154.26	154.8	151.62	151.99	1102700.0
2017-03-07	AAT	Stock	42.61	42.9	42.32	42.34	195300.0
2017-03-07	AAU-DELISTED	Stock	1.0	1.02	0.9733	0.985	313732.0
2017-03-07	AAUAF-DELISTED	Stock	1.0	1.02	0.9733	0.985	316632.0
2017-03-07	AAV-DELISTED	Stock	5.9	6.195	5.875	6.1	204291.0
2017-03-07	AAWW-DELISTED	Stock	56.25	56.325	54.95	55.1	113727.0
2017-03-07	AAXJ	Stock	60.66	60.7101	60.49	60.56	1058250.0
2017-03-07	AAXN-DELISTED	Stock	22.42	22.7	22.4	22.48	1167015.0
2017-03-07	AB	Stock	22.9	23.3	22.9	23.0	339300.0
2017-03-07	ABAC-DELISTED	Stock	2.52	2.73	2.05	2.53	22794.0
2017-03-07	ABAX-DELISTED	Stock	49.53	49.59	48.51	49.51	49004.0
2017-03-07	ABB-DELISTED	Stock	22.55	22.64	22.49	22.61	1344675.0
2017-03-07	ABBNY-DELISTED	Stock	22.55	22.64	22.49	22.61	1381235.0
2017-03-07	ABBV	Stock	63.14	64.14	62.97	63.69	9638000.0
2017-03-07	ABC-DELISTED	Stock	89.23	89.8	87.92	88.47	2356101.0
2017-03-07	ABCB	Stock	47.3	47.5	46.75	46.8	215000.0
2017-03-07	ABCD-DELISTED	Stock	4.68	4.76	4.6	4.74	51209.0
2017-03-07	ABCO-DELISTED	Stock	44.65	45.45	44.5	45.0	440279.0
2017-03-07	ABDC-DELISTED	Stock	12.6	12.68	12.24	12.62	43846.0
2017-03-07	ABE-DELISTED	Stock	12.15	12.1815	12.15	12.15	10334.0
2017-03-07	ABEO	Stock	123.75	132.5	122.5	126.25	8456.0
2017-03-07	ABEV	Stock	5.47	5.48	5.36	5.38	28211000.0
2017-03-07	ABG	Stock	63.25	63.6	62.15	62.25	334600.0
2017-03-07	ABIL-DELISTED	Stock	2.37	2.37	2.26	2.3499	5068.0
2017-03-07	ABM	Stock	40.43	40.55	40.14	40.22	557000.0
2017-03-07	ABMD-DELISTED	Stock	119.08	120.75	118.6625	120.01	272383.0
2017-03-07	ABR	Stock	7.67	7.85	7.57	7.72	238300.0

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

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