PREVIEW / stock_daily / 2017-04-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-20.parquet
  size:    215 KB
  rows:    6,464
  symbols: 3,040

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-04-20	AAPL	Stock	35.305	35.73	35.29	35.61	93278400.0
2017-04-20	MSFT	Stock	65.46	65.75	65.14	65.5	22299500.0
2017-04-20	NVDA	Stock	2.5068	2.5363	2.4852	2.5315	404016000.0
2017-04-20	AMZN	Stock	44.985	45.266	44.8145	45.103	56288000.0
2017-04-20	GOOGL	Stock	42.987	43.1965	42.875	43.004	23776860.0
2017-04-20	META	Stock	142.95	144.25	142.69	143.8	15968200.0
2017-04-20	TSLA	Stock	20.434	20.61	20.0153	20.1673	92241000.0
2017-04-20	TLT	Stock	123.73	123.92	123.135	123.54	7932918.0
2017-04-20	ES	Stock	59.64	59.64	59.03	59.44	1125200.0
2017-04-20	CL	Stock	73.34	73.52	72.95	73.18	3114700.0
2017-04-20	A	Stock	53.33	53.4	52.79	53.13	1570000.0
2017-04-20	AA	Stock	31.89	32.3	31.46	32.04	5429500.0
2017-04-20	AAAP-DELISTED	Stock	37.2404	37.69	37.12	37.6	15319.0
2017-04-20	AABA-DELISTED	Stock	47.25	47.84	47.07	47.67	10369759.0
2017-04-20	AAC-DELISTED	Stock	7.55	7.64	7.342	7.56	68053.0
2017-04-20	AACG	Stock	3.7	3.87	3.7	3.75	6300.0
2017-04-20	AAIC-DELISTED	Stock	14.38	14.45	14.26	14.38	247621.0
2017-04-20	AAL	Stock	44.71	45.38	44.56	45.22	4956500.0
2017-04-20	AAM.A-DELISTED	Stock	25.12	25.15	25.1	25.13	150182.0
2017-04-20	AAMC-DELISTED	Stock	21.7647	22.3529	18.5882	20.6912	237976.0
2017-04-20	AAME	Stock	3.7	3.95	3.65	3.8	3700.0
2017-04-20	AAMI	Stock	15.02	15.15	14.93	15.15	178600.0
2017-04-20	AAOI	Stock	43.93	44.35	43.5	44.31	972600.0
2017-04-20	AAON	Stock	23.3667	23.9867	23.3667	23.9	165900.0
2017-04-20	AAP	Stock	143.56	146.82	143.09	146.56	1278900.0
2017-04-20	AAT	Stock	44.6	44.64	44.25	44.49	250800.0
2017-04-20	AAU-DELISTED	Stock	1.47	1.57	1.4698	1.569	269776.0
2017-04-20	AAUAF-DELISTED	Stock	1.47	1.57	1.4698	1.57	272340.0
2017-04-20	AAV-DELISTED	Stock	6.45	6.55	6.425	6.45	55675.0
2017-04-20	AAWW-DELISTED	Stock	56.3	57.5	56.05	57.3	192061.0
2017-04-20	AAXJ	Stock	62.69	62.84	62.57	62.81	449505.0
2017-04-20	AAXN-DELISTED	Stock	22.94	23.36	22.79	23.3	715656.0
2017-04-20	AB	Stock	23.1	23.2	22.9	23.05	203700.0
2017-04-20	ABAC-DELISTED	Stock	2.3216	2.35	2.2	2.263	85503.0
2017-04-20	ABAX-DELISTED	Stock	48.23	48.85	47.54	48.825	44833.0
2017-04-20	ABB-DELISTED	Stock	22.64	22.97	22.62	22.92	3729621.0
2017-04-20	ABBNY-DELISTED	Stock	22.64	22.97	22.62	22.93	5374299.0
2017-04-20	ABBV	Stock	63.72	64.0	63.29	63.78	5708600.0
2017-04-20	ABC-DELISTED	Stock	82.23	82.93	81.62	82.38	1790405.0
2017-04-20	ABCB	Stock	44.9	45.8	44.65	45.75	155900.0
2017-04-20	ABCD-DELISTED	Stock	4.86	4.92	4.83	4.87	19220.0
2017-04-20	ABCO-DELISTED	Stock	47.35	47.55	47.205	47.5	141522.0
2017-04-20	ABDC-DELISTED	Stock	14.26	14.34	14.25	14.28	45353.0
2017-04-20	ABE-DELISTED	Stock	13.32	13.47	13.32	13.47	17049.0
2017-04-20	ABEO	Stock	126.25	131.25	126.25	130.0	9704.0
2017-04-20	ABEV	Stock	5.69	5.76	5.62	5.62	31504800.0
2017-04-20	ABG	Stock	61.75	62.85	61.7	62.25	219200.0
2017-04-20	ABIL-DELISTED	Stock	1.1	1.1299	1.08	1.11	15024.0
2017-04-20	ABM	Stock	42.72	43.06	42.55	43.03	216000.0
2017-04-20	ABMD-DELISTED	Stock	123.43	125.9	122.6	125.22	194255.0

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

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