PREVIEW / stock_daily / 2017-05-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-16.parquet
  size:    215 KB
  rows:    6,455
  symbols: 3,005

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-16	AAPL	Stock	38.985	39.015	38.68	38.8675	80194000.0
2017-05-16	MSFT	Stock	68.23	69.44	68.16	69.41	34956000.0
2017-05-16	NVDA	Stock	3.4095	3.436	3.334	3.4202	1120700000.0
2017-05-16	AMZN	Stock	48.05	48.503	48.0455	48.3035	62522000.0
2017-05-16	GOOGL	Stock	48.1775	48.2948	48.0175	48.2305	22030880.0
2017-05-16	META	Stock	150.11	150.21	149.03	149.78	14550800.0
2017-05-16	TSLA	Stock	21.1727	21.3373	21.0093	21.134	62287500.0
2017-05-16	TLT	Stock	121.11	121.89	121.105	121.51	6722728.0
2017-05-16	ES	Stock	60.15	60.27	59.6	59.63	1076400.0
2017-05-16	CL	Stock	71.78	71.98	71.54	71.58	2907500.0
2017-05-16	A	Stock	58.38	58.38	56.45	56.83	1032600.0
2017-05-16	AA	Stock	32.1	32.4	31.75	32.16	3001800.0
2017-05-16	AAAP-DELISTED	Stock	36.11	37.5464	35.99	36.17	44568.0
2017-05-16	AABA-DELISTED	Stock	50.04	51.12	50.03	50.97	16226448.0
2017-05-16	AAC-DELISTED	Stock	7.21	7.2448	7.03	7.06	97255.0
2017-05-16	AACG	Stock	3.52	3.56	3.5	3.51	10600.0
2017-05-16	AAIC-DELISTED	Stock	14.17	14.2004	14.13	14.13	201797.0
2017-05-16	AAL	Stock	46.79	47.13	44.74	46.94	4627800.0
2017-05-16	AAM.A-DELISTED	Stock	25.8	25.86	25.795	25.82	35770.0
2017-05-16	AAMC-DELISTED	Stock	21.8235	22.6324	21.8235	22.3971	16412.0
2017-05-16	AAME	Stock	3.73	3.73	3.7	3.7	800.0
2017-05-16	AAMI	Stock	14.55	14.69	14.5	14.64	8530200.0
2017-05-16	AAOI	Stock	64.11	65.24	62.53	64.97	2528000.0
2017-05-16	AAON	Stock	24.4	24.5333	24.1333	24.4333	163500.0
2017-05-16	AAP	Stock	146.65	146.65	142.11	145.25	2319800.0
2017-05-16	AAT	Stock	39.29	39.4	38.28	38.38	183500.0
2017-05-16	AAU-DELISTED	Stock	1.38	1.39	1.31	1.35	273798.0
2017-05-16	AAUAF-DELISTED	Stock	1.38	1.39	1.31	1.33	277113.0
2017-05-16	AAV-DELISTED	Stock	6.6	6.688	6.55	6.6	93856.0
2017-05-16	AAWW-DELISTED	Stock	49.5	49.975	49.05	49.65	181070.0
2017-05-16	AAXJ	Stock	66.33	66.41	66.2	66.37	848527.0
2017-05-16	AAXN-DELISTED	Stock	25.1	25.61	24.83	25.55	832856.0
2017-05-16	AB	Stock	21.35	21.35	21.1	21.25	363300.0
2017-05-16	ABAC-DELISTED	Stock	1.8	1.805	1.7601	1.78	4540.0
2017-05-16	ABAX-DELISTED	Stock	48.28	48.28	47.485	48.12	46073.0
2017-05-16	ABB-DELISTED	Stock	25.18	25.195	25.055	25.17	1824693.0
2017-05-16	ABBNY-DELISTED	Stock	25.18	25.195	25.055	25.18	1877906.0
2017-05-16	ABBV	Stock	66.73	66.92	66.33	66.85	6313500.0
2017-05-16	ABC-DELISTED	Stock	89.84	89.84	88.46	89.03	1112207.0
2017-05-16	ABCB	Stock	45.35	46.0	44.8	45.95	160300.0
2017-05-16	ABCD-DELISTED	Stock	5.09	5.1	4.93	5.03	34410.0
2017-05-16	ABCO-DELISTED	Stock	52.0	52.0	51.2	51.5	424829.0
2017-05-16	ABDC-DELISTED	Stock	14.4	14.4	14.02	14.03	22934.0
2017-05-16	ABE-DELISTED	Stock	14.0	14.0	13.91	13.95	15040.0
2017-05-16	ABEO	Stock	156.25	158.75	152.5	153.75	11676.0
2017-05-16	ABEOW-DELISTED	Stock	3.626	3.626	3.626	3.626	100.0
2017-05-16	ABEV	Stock	6.37	6.39	6.29	6.36	28064900.0
2017-05-16	ABG	Stock	57.0	57.7	55.95	57.3	214200.0
2017-05-16	ABIL-DELISTED	Stock	0.751	1.14	0.751	0.822	471645.0
2017-05-16	ABM	Stock	42.67	42.76	41.96	42.01	214100.0

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

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