PREVIEW / stock_daily / 2017-03-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-08.parquet
  size:    216 KB
  rows:    6,496
  symbols: 3,072

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-08	AAPL	Stock	34.7375	34.95	34.705	34.75	74828800.0
2017-03-08	MSFT	Stock	64.26	65.08	64.25	64.99	21510900.0
2017-03-08	NVDA	Stock	2.5175	2.5325	2.4618	2.464	638712000.0
2017-03-08	AMZN	Stock	42.4	42.6535	42.3395	42.525	45730000.0
2017-03-08	GOOGL	Stock	42.656	42.8465	42.5625	42.682	20596680.0
2017-03-08	META	Stock	137.15	137.99	137.05	137.72	10184500.0
2017-03-08	TSLA	Stock	16.4667	16.6713	16.3547	16.458	55878000.0
2017-03-08	TLT	Stock	117.31	117.95	117.23	117.78	11336336.0
2017-03-08	ES	Stock	57.93	58.2	57.42	57.52	1324200.0
2017-03-08	CL	Stock	73.32	73.78	73.14	73.16	4141700.0
2017-03-08	A	Stock	51.26	51.57	50.95	51.41	1517600.0
2017-03-08	AA	Stock	35.9	36.82	35.9	35.99	4485700.0
2017-03-08	AAAP-DELISTED	Stock	38.01	38.5	37.96	38.31	57791.0
2017-03-08	AABA-DELISTED	Stock	45.85	46.19	45.73	45.98	2954103.0
2017-03-08	AAC-DELISTED	Stock	8.71	8.92	8.63	8.69	95632.0
2017-03-08	AACG	Stock	3.56	3.62	3.5	3.56	16400.0
2017-03-08	AAIC-DELISTED	Stock	13.86	13.9193	13.48	13.53	545983.0
2017-03-08	AAL	Stock	44.79	45.3	44.6	44.89	5520400.0
2017-03-08	AAMC-DELISTED	Stock	22.9265	23.0562	21.6912	22.5294	14277.0
2017-03-08	AAME	Stock	3.85	3.85	3.71	3.8	1800.0
2017-03-08	AAMI	Stock	14.96	15.25	14.88	14.98	853800.0
2017-03-08	AAOI	Stock	54.85	54.947	51.5	52.56	1283100.0
2017-03-08	AAON	Stock	23.3333	23.44	23.0333	23.2333	266550.0
2017-03-08	AAP	Stock	153.51	155.74	152.82	155.21	1415600.0
2017-03-08	AAT	Stock	42.03	42.1	41.59	41.62	200200.0
2017-03-08	AAU-DELISTED	Stock	0.98	1.02	0.98	0.9901	188599.0
2017-03-08	AAUAF-DELISTED	Stock	0.98	1.02	0.98	0.9901	190589.0
2017-03-08	AAV-DELISTED	Stock	6.0	6.175	5.8	5.9	224743.0
2017-03-08	AAWW-DELISTED	Stock	55.3	55.6	54.35	54.45	94604.0
2017-03-08	AAXJ	Stock	60.71	60.75	60.4	60.42	519914.0
2017-03-08	AAXN-DELISTED	Stock	22.61	22.64	22.3	22.39	785970.0
2017-03-08	AB	Stock	23.2	23.3	22.85	22.9	174500.0
2017-03-08	ABAC-DELISTED	Stock	2.65	2.68	2.4	2.5601	32547.0
2017-03-08	ABAX-DELISTED	Stock	49.6	49.6	48.88	49.09	55077.0
2017-03-08	ABB-DELISTED	Stock	22.57	22.68	22.52	22.53	1539373.0
2017-03-08	ABBNY-DELISTED	Stock	22.57	22.68	22.52	22.54	1581863.0
2017-03-08	ABBV	Stock	63.75	64.68	63.5	64.14	7049700.0
2017-03-08	ABC-DELISTED	Stock	88.32	89.97	88.32	89.09	1648492.0
2017-03-08	ABCB	Stock	47.35	47.58	46.0	46.1	187000.0
2017-03-08	ABCD-DELISTED	Stock	4.76	4.92	4.71	4.79	72997.0
2017-03-08	ABCO-DELISTED	Stock	45.05	45.75	44.5123	45.05	764802.0
2017-03-08	ABDC-DELISTED	Stock	12.62	12.6798	12.21	12.65	61060.0
2017-03-08	ABE-DELISTED	Stock	12.15	12.17	12.09	12.09	68038.0
2017-03-08	ABEO	Stock	132.5	132.5	122.5	125.0	9440.0
2017-03-08	ABEV	Stock	5.31	5.41	5.3	5.4	27633700.0
2017-03-08	ABG	Stock	62.4	63.65	62.4	62.45	256500.0
2017-03-08	ABIL-DELISTED	Stock	2.36	2.36	2.227	2.26	6686.0
2017-03-08	ABM	Stock	41.0	42.84	40.98	42.5	931200.0
2017-03-08	ABMD-DELISTED	Stock	120.28	121.06	119.55	120.1	170461.0
2017-03-08	ABR	Stock	7.73	7.8	7.59	7.59	136400.0

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

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