PREVIEW / stock_daily / 2016-05-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-20.parquet
  size:    218 KB
  rows:    6,537
  symbols: 3,281

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
2016-05-20	AAPL	Stock	23.66	23.8575	23.63	23.805	128104000.0
2016-05-20	MSFT	Stock	50.48	51.22	50.4	50.62	23905800.0
2016-05-20	NVDA	Stock	1.0955	1.1127	1.0938	1.1082	391084000.0
2016-05-20	AMZN	Stock	35.0525	35.362	35.0	35.14	58324000.0
2016-05-20	GOOGL	Stock	35.823	36.385	35.7505	36.0855	34797900.0
2016-05-20	META	Stock	116.96	117.99	116.95	117.35	18944800.0
2016-05-20	TSLA	Stock	14.466	14.7033	14.4233	14.6853	135106500.0
2016-05-20	TLT	Stock	129.65	130.4	129.55	130.15	5348879.0
2016-05-20	ES	Stock	55.48	55.49	54.45	54.91	2698000.0
2016-05-20	CL	Stock	70.79	70.79	69.92	70.02	2978000.0
2016-05-20	A	Stock	44.86	45.22	44.69	44.89	2567400.0
2016-05-20	AA.B-DELISTED	Stock	31.93	32.18	31.7	31.86	12937.0
2016-05-20	AAAP-DELISTED	Stock	28.15	28.44	27.5083	27.91	18074.0
2016-05-20	AABA-DELISTED	Stock	36.05	36.72	35.88	36.5	32308697.0
2016-05-20	AAC-DELISTED	Stock	19.6	20.16	19.16	19.88	47715.0
2016-05-20	AACG	Stock	5.26	5.26	4.88	4.88	4400.0
2016-05-20	AAIC-DELISTED	Stock	12.35	12.6	12.32	12.59	211005.0
2016-05-20	AAL	Stock	32.3	32.81	31.95	32.01	7278000.0
2016-05-20	AAMC-DELISTED	Stock	3.7353	3.9873	3.6912	3.9176	101986.0
2016-05-20	AAME	Stock	3.36	3.44	3.25	3.32	3800.0
2016-05-20	AAMI	Stock	13.68	13.95	13.68	13.92	161300.0
2016-05-20	AAOI	Stock	8.88	9.19	8.84	9.12	326800.0
2016-05-20	AAON	Stock	18.0867	18.3733	17.9733	18.2467	184200.0
2016-05-20	AAP	Stock	143.36	147.16	142.78	146.39	1948500.0
2016-05-20	AAT	Stock	38.88	39.46	38.75	39.44	130000.0
2016-05-20	AAU-DELISTED	Stock	1.13	1.13	1.06	1.08	173428.0
2016-05-20	AAUAF-DELISTED	Stock	1.13	1.13	1.06	1.08	176847.0
2016-05-20	AAV-DELISTED	Stock	5.71	5.79	5.65	5.76	25945.0
2016-05-20	AAWW-DELISTED	Stock	43.4	44.35	42.46	43.91	326784.0
2016-05-20	AAXJ	Stock	51.35	51.48	51.27	51.33	1889729.0
2016-05-20	AAXN-DELISTED	Stock	21.15	21.75	21.03	21.7	859192.0
2016-05-20	AB	Stock	22.82	23.46	22.75	23.23	368200.0
2016-05-20	ABAC-DELISTED	Stock	0.63	0.69	0.623	0.68	19720.0
2016-05-20	ABAX-DELISTED	Stock	44.16	44.79	42.67	44.6	140415.0
2016-05-20	ABB-DELISTED	Stock	20.38	20.45	20.32	20.34	1101747.0
2016-05-20	ABBNY-DELISTED	Stock	20.39	20.45	20.32	20.34	1143605.0
2016-05-20	ABBV	Stock	59.63	60.05	59.03	59.69	11259400.0
2016-05-20	ABC-DELISTED	Stock	75.14	75.33	74.36	74.81	2282531.0
2016-05-20	ABCB	Stock	30.76	31.16	30.69	30.9	185700.0
2016-05-20	ABCD-DELISTED	Stock	4.53	4.58	4.48	4.53	13313.0
2016-05-20	ABCO-DELISTED	Stock	31.4	32.46	31.21	32.43	402644.0
2016-05-20	ABDC-DELISTED	Stock	12.0	12.0	11.78	11.87	27446.0
2016-05-20	ABE-DELISTED	Stock	11.7141	11.7141	11.62	11.62	13042.0
2016-05-20	ABEO	Stock	62.0	63.25	60.25	62.25	1216.0
2016-05-20	ABEOW-DELISTED	Stock	0.6782	0.7186	0.6782	0.7	5696.0
2016-05-20	ABEV	Stock	5.21	5.26	5.2	5.22	8249800.0
2016-05-20	ABG	Stock	53.31	54.56	53.0	54.49	293000.0
2016-05-20	ABIL-DELISTED	Stock	2.75	2.8	2.524	2.77	75010.0
2016-05-20	ABM	Stock	32.92	33.15	32.72	33.14	197900.0
2016-05-20	ABMD-DELISTED	Stock	96.0	97.32	94.81	97.28	337369.0

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

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