PREVIEW / stock_daily / 2017-05-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-11.parquet
  size:    215 KB
  rows:    6,445
  symbols: 3,012

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-05-11	AAPL	Stock	38.1125	38.5175	38.0775	38.4875	109020400.0
2017-05-11	MSFT	Stock	68.36	68.73	68.12	68.46	28789400.0
2017-05-11	NVDA	Stock	3.0013	3.2608	2.9978	3.1625	1939792000.0
2017-05-11	AMZN	Stock	47.2555	47.5145	47.039	47.381	43882000.0
2017-05-11	GOOGL	Stock	47.5645	47.8995	47.4305	47.7945	20621860.0
2017-05-11	META	Stock	150.31	150.65	149.41	150.04	11841900.0
2017-05-11	TSLA	Stock	21.56	21.7333	21.3067	21.54	71307000.0
2017-05-11	TLT	Stock	120.0	120.57	119.91	120.48	7479834.0
2017-05-11	ES	Stock	59.04	59.48	58.87	59.48	1279100.0
2017-05-11	CL	Stock	71.48	71.66	71.33	71.62	2538000.0
2017-05-11	A	Stock	56.13	56.38	55.8	56.23	1347600.0
2017-05-11	AA	Stock	31.23	31.31	30.45	31.16	4109300.0
2017-05-11	AAAP-DELISTED	Stock	36.52	36.9756	36.41	36.7	19798.0
2017-05-11	AABA-DELISTED	Stock	49.45	49.71	49.14	49.69	5810061.0
2017-05-11	AAC-DELISTED	Stock	7.19	7.49	7.11	7.43	55925.0
2017-05-11	AACG	Stock	3.6	3.6	3.52	3.6	8800.0
2017-05-11	AAIC-DELISTED	Stock	14.23	14.2876	14.06	14.22	222545.0
2017-05-11	AAL	Stock	47.21	47.24	45.65	46.54	6086300.0
2017-05-11	AAM.A-DELISTED	Stock	25.84	25.84	25.7	25.73	52778.0
2017-05-11	AAMC-DELISTED	Stock	20.9118	21.1618	20.9118	21.1618	12165.0
2017-05-11	AAME	Stock	3.65	3.7	3.65	3.65	2000.0
2017-05-11	AAMI	Stock	15.54	15.58	15.26	15.28	207700.0
2017-05-11	AAOI	Stock	64.05	65.33	62.08	64.23	3543900.0
2017-05-11	AAON	Stock	24.3	24.6333	24.0667	24.5	113700.0
2017-05-11	AAP	Stock	145.49	146.17	143.03	145.95	773000.0
2017-05-11	AAT	Stock	39.99	39.99	39.37	39.62	315200.0
2017-05-11	AAU-DELISTED	Stock	1.29	1.3164	1.28	1.3	242877.0
2017-05-11	AAUAF-DELISTED	Stock	1.29	1.3164	1.28	1.3	247463.0
2017-05-11	AAV-DELISTED	Stock	6.5	6.65	6.5	6.55	152772.0
2017-05-11	AAWW-DELISTED	Stock	51.15	51.5	50.55	51.1	144625.0
2017-05-11	AAXJ	Stock	65.63	65.78	65.38	65.77	759369.0
2017-05-11	AAXN-DELISTED	Stock	26.06	26.29	25.75	26.0	868983.0
2017-05-11	AB	Stock	20.8	21.25	20.8	21.1	737400.0
2017-05-11	ABAC-DELISTED	Stock	1.7501	1.79	1.75	1.79	8648.0
2017-05-11	ABAX-DELISTED	Stock	48.7	48.99	48.43	48.78	126086.0
2017-05-11	ABB-DELISTED	Stock	24.61	24.68	24.5	24.67	1867113.0
2017-05-11	ABBNY-DELISTED	Stock	24.61	24.68	24.5	24.67	1912564.0
2017-05-11	ABBV	Stock	65.9	65.96	64.66	65.3	7853800.0
2017-05-11	ABC-DELISTED	Stock	87.84	88.935	87.8	88.85	1890157.0
2017-05-11	ABCB	Stock	46.3	47.2	45.1	45.2	185900.0
2017-05-11	ABCD-DELISTED	Stock	5.24	5.31	5.22	5.29	55142.0
2017-05-11	ABCO-DELISTED	Stock	51.75	51.95	51.15	51.35	222232.0
2017-05-11	ABDC-DELISTED	Stock	14.42	14.61	14.24	14.45	28226.0
2017-05-11	ABE-DELISTED	Stock	13.8	13.88	13.7965	13.84	6818.0
2017-05-11	ABEO	Stock	146.25	158.75	143.75	152.5	32796.0
2017-05-11	ABEOW-DELISTED	Stock	2.79	3.202	2.79	3.202	2629.0
2017-05-11	ABEV	Stock	6.06	6.19	6.04	6.15	55139400.0
2017-05-11	ABG	Stock	57.0	57.35	55.6	56.5	163700.0
2017-05-11	ABIL-DELISTED	Stock	0.82	0.88	0.6772	0.7315	45860.0
2017-05-11	ABM	Stock	42.74	42.83	42.46	42.5	288600.0

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

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